ASHRAE Journal - August 2009 - 44

point multiplied by 1.001. Figure 3 shows how this appears in the spreadsheet. The first projected diameter is shown in Cell M77. This value is then used in the same manner for the second projection (shown in Cell M80). This is repeated for a third projection, resulting in a final solution, 2.1571 in. (55 mm) in Cell M83. (Verification of this result is in the sample spreadsheet.) As crude as this procedure may seem, it produces precise results in three projections. Notice the difference in Cell J83 is negative and in Cell J84 it is positive. We have reached the limits in accuracy for the increments used here (meaning the 0.999 and 1.001 multipliers). If greater accuracy is desired, finer increments must be used. When writing this procedure as a user defined function, I’ve used a “Do Loop Until,” ending the loop when I reach a negative difference for the first of the pair and a positive difference for the second line of the pair. This spreadsheet was presented to show the calculation but is good for only one point at a time. The calculation has been written into a UDF named “AirDia,” which makes the procedure easy to use in a network of ducts with multiple points. The next section gives a brief explanation of UDFs, and how they can be used. Visual Basic for Applications (VBA) and Excel D54214asjl_805523 4/9/08 5:15 is Page 1 Visual Basic for Applications (VBA) AM included in Excel. Among the uses of VBA is the creation of macros. There are two Zero Difference High Difference Low Difference Low Diameter High Diameter Projected Diameter Figure 2: In Step 5 the projected diameter is calculated using simple triangulation. types of VBA macros: command macros (sometimes referred as keystroke macros) and user defined functions (sometimes referred to as function procedures). It is the user defined functions that I will focus on. CRITICAL CLEANING DEMANDS GOODWAY. HEAVY-DUTY TUBE CLEANERS FOR FIRETUBE AND WATERTUBE BOILERS • Firetube Boiler Cleaners with Vacuum for Removing Soot and Scale • Watertube Boiler Cleaners with Waterflush for Removing Scale and Hard Water Deposits ® To find out more, call Goodway today at 800-333-7467, or visit us online. www.goodway.com Innovative Maintenance Solutions www.info.hotims.com/25207-18 www.info.hotims.com/25207-19 44 ASHRAE Journal August 2009

ASHRAE Journal - August 2009

Table of Contents for the Digital Edition of ASHRAE Journal - August 2009

ASHRAE Journal - August 2009
Contents
Commentary
Industry News
Letters
Meetings and Shows
Feature Articles
     2009 Presidential Address: Sustaining Our Future by Rebuilding Our Past
     HFOs: New, Low Global Warming Potential Refrigerants
     Defrosting Industrial Refrigeration Evaporators
     Using Excel for Duct Calculations: User Defined Functions
     Rack Enclosures: A Crucial Link in Airflow Management in Data Centers
     Geothermal for Grain Research Center
     Anniversary Feature: Fundamentals of Linear Control Theory
Building Sciences
Special Section
     InfoCenter
Special Products
Emerging Technologies
People
Washington Report
Classified Advertising
Advertisers Index
ASHRAE Journal - August 2009 - ASHRAE Journal - August 2009
ASHRAE Journal - August 2009 - Cover2
ASHRAE Journal - August 2009 - 1
ASHRAE Journal - August 2009 - 2
ASHRAE Journal - August 2009 - Contents
ASHRAE Journal - August 2009 - 4
ASHRAE Journal - August 2009 - Commentary
ASHRAE Journal - August 2009 - Industry News
ASHRAE Journal - August 2009 - 7
ASHRAE Journal - August 2009 - 8
ASHRAE Journal - August 2009 - 9
ASHRAE Journal - August 2009 - Letters
ASHRAE Journal - August 2009 - 11
ASHRAE Journal - August 2009 - 12
ASHRAE Journal - August 2009 - 13
ASHRAE Journal - August 2009 - Meetings and Shows
ASHRAE Journal - August 2009 - 15
ASHRAE Journal - August 2009 -      2009 Presidential Address: Sustaining Our Future by Rebuilding Our Past
ASHRAE Journal - August 2009 - 17
ASHRAE Journal - August 2009 - 18
ASHRAE Journal - August 2009 - 19
ASHRAE Journal - August 2009 - 20
ASHRAE Journal - August 2009 - 21
ASHRAE Journal - August 2009 -      HFOs: New, Low Global Warming Potential Refrigerants
ASHRAE Journal - August 2009 - 23
ASHRAE Journal - August 2009 - 24
ASHRAE Journal - August 2009 - 25
ASHRAE Journal - August 2009 - 26
ASHRAE Journal - August 2009 - 27
ASHRAE Journal - August 2009 - 28
ASHRAE Journal - August 2009 - 29
ASHRAE Journal - August 2009 -      Defrosting Industrial Refrigeration Evaporators
ASHRAE Journal - August 2009 - 31
ASHRAE Journal - August 2009 - 32
ASHRAE Journal - August 2009 - BRC1
ASHRAE Journal - August 2009 - BRC2
ASHRAE Journal - August 2009 - 33
ASHRAE Journal - August 2009 - 34
ASHRAE Journal - August 2009 - 35
ASHRAE Journal - August 2009 - 36
ASHRAE Journal - August 2009 - 37
ASHRAE Journal - August 2009 - 38
ASHRAE Journal - August 2009 - 39
ASHRAE Journal - August 2009 - 40
ASHRAE Journal - August 2009 - 41
ASHRAE Journal - August 2009 -      Using Excel for Duct Calculations: User Defined Functions
ASHRAE Journal - August 2009 - 43
ASHRAE Journal - August 2009 - 44
ASHRAE Journal - August 2009 - 45
ASHRAE Journal - August 2009 - 46
ASHRAE Journal - August 2009 - 47
ASHRAE Journal - August 2009 -      Rack Enclosures: A Crucial Link in Airflow Management in Data Centers
ASHRAE Journal - August 2009 - 49
ASHRAE Journal - August 2009 - 50
ASHRAE Journal - August 2009 - 51
ASHRAE Journal - August 2009 -      Geothermal for Grain Research Center
ASHRAE Journal - August 2009 - 53
ASHRAE Journal - August 2009 - 54
ASHRAE Journal - August 2009 - 55
ASHRAE Journal - August 2009 - 56
ASHRAE Journal - August 2009 - 57
ASHRAE Journal - August 2009 -      Anniversary Feature: Fundamentals of Linear Control Theory
ASHRAE Journal - August 2009 - 59
ASHRAE Journal - August 2009 - 60
ASHRAE Journal - August 2009 - 61
ASHRAE Journal - August 2009 - 62
ASHRAE Journal - August 2009 - 63
ASHRAE Journal - August 2009 - Building Sciences
ASHRAE Journal - August 2009 - 65
ASHRAE Journal - August 2009 - 66
ASHRAE Journal - August 2009 - 67
ASHRAE Journal - August 2009 -      InfoCenter
ASHRAE Journal - August 2009 - 69
ASHRAE Journal - August 2009 - 70
ASHRAE Journal - August 2009 - 71
ASHRAE Journal - August 2009 - 72
ASHRAE Journal - August 2009 - 73
ASHRAE Journal - August 2009 - 74
ASHRAE Journal - August 2009 - 75
ASHRAE Journal - August 2009 - Special Products
ASHRAE Journal - August 2009 - 77
ASHRAE Journal - August 2009 - Emerging Technologies
ASHRAE Journal - August 2009 - 79
ASHRAE Journal - August 2009 - 80
ASHRAE Journal - August 2009 - 81
ASHRAE Journal - August 2009 - 82
ASHRAE Journal - August 2009 - People
ASHRAE Journal - August 2009 - Washington Report
ASHRAE Journal - August 2009 - Classified Advertising
ASHRAE Journal - August 2009 - 86
ASHRAE Journal - August 2009 - 87
ASHRAE Journal - August 2009 - Advertisers Index
ASHRAE Journal - August 2009 - Cover3
ASHRAE Journal - August 2009 - Cover4
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_MCDEBX
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_WNYSQY
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_XATVOD
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_FJSHSS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_CCBZDS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_XDEFVG
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2023november_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2023november
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_VHGNBL
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_WPKBNJ
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_UUVCDE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_RTGDEW
https://www.nxtbook.com/nxtbooks/ashrae/ashraemexico_2023
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_LKRFXS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_AZSOFG
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_ERCDBH
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_QWDFRV
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_JHGVDF
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_OPUYHG
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_SREIBM
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_LRTGLK
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_OKRFGH
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2022november_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2022november
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_TZSERA
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_LVRUIX
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_RPTVYZ
https://www.nxtbook.com/nxtbooks/ashrae/mini_pub_catalog
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_XIYTGD
https://www.nxtbook.com/nxtbooks/ashrae/ashraemexico_2022
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_RFGDOB
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_PABXNU
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_REMKLS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_PICVBT
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_AOYTVW
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_JQOPLS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_IOYTBC
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_SGAJJF
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_IGHYER
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_PDRKLS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2021november
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2021november_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_XCODFR
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_QSLFGO
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_ILKVNM
https://www.nxtbook.com/nxtbooks/ashrae/ashraemexico_2021
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_OPDJKD
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_VJKSRY
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_SDHUTC
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_JPPKRR
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_SDLTTH
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_CKLLES
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_SLDOX
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_HJETUK
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_OLUHGE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2020october
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2020october_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_ZERDGH
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_QVMNEO
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_RTPOKE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_BBATRE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_STUBMW
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_TPEMPE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_JNMKDS
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_FBTTPA
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_WQMMNE
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_TVBRYN
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_showguide2020
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_KTUZMA
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_ABEDGD
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201910
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201909
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2019septmeber_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2019september
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201908
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201907
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201906
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201905
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201904
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_2019april
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201903
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_2019march
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201902
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201901
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_showguide2019
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_2018december
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_2018november
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2018fall_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2018fall
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_2018october
https://www.nxtbook.com/nxtbooks/ashrae/ashraemexico_2018
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201810
https://www.nxtbook.com/nxtbooks/ashrae/ashraeinsights_201806
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201805
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201804
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201803
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201712
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201711
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201710
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2017fall_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2017fall
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201709
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201705
https://www.nxtbook.com/nxtbooks/ashrae/ashrae_meetinginsert_201610
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2016fall_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2016fall
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_acrexindia
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2015summer_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_amca_2015summer
https://www.nxtbook.com/nxtbooks/amca/2014summer2
https://www.nxtbook.com/nxtbooks/amca/2014summer
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_acma_2014summer
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201311
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201309
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_acmasupp_2013fall
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201305
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201303
https://www.nxtbook.com/nxtbooks/ashrae/pubcatalog_2013winter
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201211
https://www.nxtbook.com/nxtbooks/ashrae/achr_expo_mexico2012
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201209
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201208_v3
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201208_v2
https://www.nxtbook.com/nxtbooks/ashrae/pubcatalog_2012summer
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201205
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201203
https://www.nxtbook.com/nxtbooks/ashrae/pubcatalog_2012winter
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201111_v2
https://www.nxtbook.com/nxtbooks/ashrae/ashraejournal_201109_v2
https://www.nxtbook.com/nxtbooks/ashrae/pubcatalog_2011summer
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201105
https://www.nxtbook.com/nxtbooks/ashrae/meetingplanner_201103
https://www.nxtbookmedia.com