APPENDIX 10

- A. USER INSTRUCTIONS FO R N ATIONAL I MPACT A NALYS E S SPREADSHEET MODEL

TABLE OF CO NTENTS

10

- A.1 USER INSTRUCTIONS

................................ ................................ ..................... 10

- A

- 1 10

- A.2 STARTUP

................................ ................................ ................................ ............ 10

- A

- 1 10

- A.3 DESCRIPTION OF NATIO NAL IMPACT ANALYS E S WORKSHEETS

...... 10

- A

- 1 10

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE NAT IONAL IMPACT ANALYS E S SPREADSHEETS

................................ ................................ .......... 10

- A

- 3

LIST OF FIGURES Figure 10

- A.4.1 The default user input parameters

................................ ............................ 10

- A

- 4 Fi gure 10

- A.4.2 Set the spreadsheet to automatic calculation mode

................................ .. 10

- A

- 5

10

- A

- iAPPENDIX 10

- A. U SER INSTRUCTIONS FOR NATIONAL IMPACT ANAL Y S E S SPREADSHEET MODEL
10

- A.1 U SER INSTRUCTIONS The results obtained in this analysis can be examined and reproduced using the Microsoft Excel ® spreadsheets accessible on the Internet from the U.S. Department of Energy’s ( DOE's ) commerci al packaged boiler r ulemaking page: www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx/ruleid/79

. From that page, follow the links to the Preliminary Analysis phase of the rulemaking and then to the
a nalytical t ools.
10

- A.2 STARTUP
The National Impact Analys e s ( NIA ) spreadsheet s enable the user to examine selected national impacts attributable to each efficiency level considered for commercial pa ckaged boilers. To u se the spreadsheet, DOE assumes the user has access to a personal computer with a hardware configuration capable of running Windows 2003 and Microsoft Excel® 2003 , or a later version

. 10

- A.3 DESCRIPTION OF NATIONAL IMPACT ANAL YS E S WORKSHEETS The NIA spreadsheets perform calculations to project the change in N ational energy use and net present val ue of financial impacts due to revised energy efficiency standard s . The energy use and associated costs for a given energy efficiency standard level are determined by calculating the shipments and then calculating the energy use and costs for all boilers shipped under that standard. The differences between the standards and base case can then be compared and the overall energy savings and net present values determined. The NIA spreadsheets consist of the following worksheets:

Flow Chart Contains an introduction to each worksheet and a flow chart of spreadsheet inputs and outputs. Summary Results Contains a summary of disaggregated NIA and National energy savings ( NES ) results for all equipment classes Labels Contains labels and definitions used throughout the spreadsheet

– Also, worksheet where the efficiency levels ( ELs ) used in the analysis are defined NIA Summary Contains source energy savings results matrix, net present value results matrix, and shipment, equipment cost and energy use in 2019 for each equipment class.

SGNDHW Contains Sm all N atural D raft G as
- fired H ot W ater B oiler NIA calculations.

LGNDHW Contains L arge Natural Draft Gas

- fired Hot Water Boiler NIA calculations. SONDHW Contains Small Natural Draft Oil

- fired Hot Water Boiler NIA

10

- A

- 1calculations.

LONDHW Contains Large Natural Draft Oil

- fired Hot Water Boiler NIA calculations.

SGNDST Contains Small Natural Draft Gas

- fired Steam Boiler NIA calculations.

LGNDST Contains Large Natural Draft Gas

- fired Steam Boiler NIA calculations.

SONDST Contains Small Natural Draft Oil

- fired Steam Boiler NIA calculations.

LONDST Contains Large Natural Draft Oil

- fired Steam Boiler NIA calculations.

SGMDHW Contains Small Mechanical Draft Gas

- fired Hot Water Boiler NIA calculations.

LGMDHW Contains Large Mechanical Draft Oil

- fired Hot Water Boiler NIA calculations.

SOMDHW Contains Small Mechanical Draft Oil

- fired Hot Water Boiler NIA calculations.

LOMDHW Contains Large Mechanical Draft Gas

- fired Steam Boiler NIA calculations.

SGMDST Contains Small Mechanical Draft Gas

- fired Steam Boiler NIA calculations.

LGMDST Contains Large Mechanica l Draft Oil

- fired Steam Boiler NIA calculations.

SOMDST Contains Small Mechanical Draft Oil

- fired Steam Boiler NIA calculations. LCC Output Life

- cycle cost (LCC) output c ontains energy use, electricity use, total installed price, annual repair, maintenance costs, energy price, electricity price, price trends, and savings for each equipment class. Eqp Price Trend Includes the learning multipliers to adjust the manufacturer ’s cost over the entire analysis period. Price Elasticity Includes the price elasticity to account for the change in the percentage of commercial consumer s acquiring a boiler divided by a change in the relative price. Energy Use Trend Contains look

- up tables to adjust for the climate conditions and building shell characteristics during the analysis period. Condensing Market Share Contains look

- up table presenting the market share for condensing boilers during the analysis period. Fuel Prices Contains energy prices for each equipment class by year. Historical Shipments Includes historical shipments data for each equipment class. AEO Housing Forecast Includes Annual Energy Outlook (AEO) forecasts of housing stocks and housing starts for both commercial and residential buildings. New Saturation Contains market saturation data for each equipment class in new 10

- A

- 2homes. Lifetime Includes the lifetime and the retirement function for each equipment class. Shipments Historical shipment and the annual shipment forecast results for plotting.

10

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE NATIONAL IMPACT ANALYS E S SPREADSHEETS Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheet f ile has been downloaded from the DOE web site , open the file using MS Excel

. Click “Enable Macro” when prompted and then click on the tab for the worksheet User Inputs

. 2. Use MS Excel's View/Zoom commands at the top menu bar to change the size of the display to make it fit your monitor.
3. The user ca n change the parameters in the sheet “ NIA Summary ”. The default parameters (shown in Figure 10

- A.4.1 ) are:

10

- A

- 3Figure 10

- A.4.1 The default user input parameters (a) Year Standards in Effect: Set to 2019

. To change value, click on cell D 6 and change to desired year. (b) Analysis period: Set to 30. To change value, click on cell D 7 and change to desired analysis period. The year that analysis ends (cell D 8 ) is automatically calculated based on the year standards in effect and analysis period. (c) Discount Rate s : Set to 7%

. To change value, click on cell D52 in “Labels” and change to desired value ( 7% or 3% ). (d) Discount Year: Set to 2014. To change value, click on cell D 1 0 and change to desired year. (e) Economic Growth Scenario: Set to “AEO201 4 Reference”. To change value, click on the pull down menu next to cell C 1 9 “Economic Growth Scenario” and change to desired scenario. (f) Equipment P rice Trend Scenario: Set to “ Constant ”. To change value, click on the pull down menu next to cell C 21 “Equipm ent Price Trend ” and change to desired scenario. 10

- A

- 4(g) Relative Price Elasticity: Set to

- 0.34. To change value, click on t he pull down menu next to cell C 2 3 “Relative Price Elasticity” and change to desired elasticity.
4. The button “Generate Output” updates the analysis results based on user inputs: National Energy Savings by efficiency level in cells J7 to O23 and Net Present Values by efficiency level in cells J30 to O67.
5. Current application sector: because commercial packaged boilers are used for both
commerc ial and residential applications, users could select the application sector by selecting sectors on the pull down menu in the “Application Sector” table next cell D 2 2 in “Labels” . T he annual shipment, unit energy use, equipment cost etc. of commercial pack aged boilers at base case and higher efficiency levels under the selected application sector could be seen in the accounting worksheets named by equipment classes, namely

“ SGNDHW ” , “ LGNDHW ” , “ SONDHW ” , “ LONDHW ” , “ SGNDST ” , “ LGNDST ” , “ SONDST ” , “ LONDST ” , “ SGMDHW ” , “ LGMDHW ” , “ SOMDHW ” , “ LOMDHW ” , “ SGMDST ” , “ LGMDST ” , and “ SOMDST ”

. . It should be mentioned that all the results in the “NIA Summary” worksheet are aggregated from both commercial and residential applications.

Note: Make sure that the spreadsheet i s in automatic calculation mode. The calculation mode could be change d by (shown in Figure 10

- A.4.2 ) :
1. In Excel 20 10 and later, go to the tab “Formulas” in the Office ribbon.
2. Click on the button “Calculation Options” and select “Automatic”. The results are automatically updated and are reported in the source energy savings matrix, net present value matrix, and summary table for each equipment class

.

Figure 10

- A.4.2 Set the spreadsheet to automatic calculation mode

10

- A

- 5