10

- A

- i APPENDIX 10

- A. USER INSTRUCTIONS FO R N ATIONAL I MPACT A NALYSIS 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 ANALYSIS WORKSHEETS

....... 10

- A

- 1 10

- A.4 BASIC INSTRUCTIONS F OR OPE RATING THE NATIONAL IMPACT ANALYSIS SPREADSHEET S

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

- A

- 210

- A

- 1 APPENDIX 10

- A. U SER INSTRUCTIONS FOR N ATIONAL I MPACT A NALYSIS
SPREADSHEET MODEL

10

- A.1 USER INSTRUCTIONS

The results obtained in this analysis can be examined and reproduced using the Microsoft Excel ® spreadsheets accessible on the Internet from the Department of Energy’s ( DOE's ) residential boiler r ulemaking page: http://www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx?ruleid=62

. From that page, follow the links to the Preliminary Analy sis phase of the rulemaking and then to the

a nalytical t ools.

10

- A.2 STARTUP

The NIA spreadsheet s enable the user to perform a National Impact Analysis (NIA) for residential boilers

. To utilize the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable of running Windows 2003 or later. To use the NIA spreadsheets, the user requires Microsoft Excel ® 2003 or later installed under the Windows operating system

.

10

- A.3 DESCRIPTION OF NATIO N AL IMPACT ANALYSIS WORKSHEETS

The NIA spreadsheets perform calculations to project the change in national 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 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:

NIA Summary Contains source energy savings results matrix, net present value results matrix, and shipment, equipment cost and energy use in 2020 for each product class. HWGB Contains Gas

- fired Hot Water Boiler NIA calculations. SGB Contains Gas

- fired Steam Boiler NIA calculations. HWOB Contains Oil

- fired Hot Water Boiler NIA calculations. SOB Contains Oil

- fired Steam Boiler NIA calculations. HW E B Contains Electric Hot Water Boiler NIA calculations. S E B Contains Electric Steam Boiler NIA calculations. Learning Rate Includes the learning multipliers to adjust the manufacturer’s cost over the entire analysis period. LCC Output Contains energy use, electricity use, total installed price, annual repair

, maintenance costs , energy price, electricity price, price trends, and savings by the standby mode for each product class. Energy Use Trend Contains look

- up tables to adjust for the climate conditions and10

- A

- 2 building shell characteristic s during the analysis period. Condensing Market Share Contains look

- up table presenting the market share for condensing boilers during the analysis period. Historical Shipments Includes historical shipments data for each product class.

Fuel Prices Contains energy prices for each product class by year. AEO Housing Forecast Includes Annual Energy Outlook (AEO) forecasts of housing stocks and housing starts for both residential and commercial buildings

. New Saturation Contains market saturation data for each product class in new homes. Lifetime Includes the lifetime and the retirement function for each product class. Full Fuel Cycle Factors Contains the full

- fuel

- cycle factors of fossil fuels and electricity by
year. Labels Contains labels and defi nitions used throughout the spreadsheet

– Also, worksheet where the ELs used in the analysis are defined Shipments Historical s hipment and the annual shipment forecast results for plotting. NIA TSD Tables Contains the tables and figures for Chapter 10 of the Technical Support Documents

10

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE NATIONAL IMPACT ANALYSIS SPREADSHEETS

Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheet f ile has been downloaded from th e Department’s 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 can change the parameters in the sheet “ NIA Summary ”. The default parameters (shown in Figure 10

- A.4.1 ) are:10

- A

- 3 Figure 10

- A.4.1 The default user input parameters.

(a) Year Standards in Effect: Set to 2020. To change value, click on cell E6 and change to desired year.

(b) Analysis period: Set to 30. To change value, click on cell D7 and change to desired analysis period. The year that analysis ends (cell E7) is automatically calculated based on the year standards in effect and analysis period.

(c) Discount Rate: Set to 7%. T o change value, click on cell E9 and change to desired value (7% or 3%).

(d) Discount Year: Set to 2014. To change value, click on cell E11 and change to desired year.

(e) Relative Price Elasticity: Set to

- 0.34. To change value, click on the pull down
menu next to cell B13 “Relative Price Elasticity” and change to desired elasticity.

(f) Economic Growth Scenario: Set to “AEO2013 Reference”. To change value, click on the pull down menu next to cell B15 “Economic Growth Scenario” and change to desired scenario.

(g) Price Trend Scenario: Set to “no Learning Rate”. To change value, click on the pull down menu next to cell B17 “Price Trend Scenario” and change to desired scenario.

4. The button “Generate Output” updates the analysis results based on user inputs: National Energ y Savings and Net Present Values by efficiency level, in cells H5 to X23; National Energy Savings and Net Present Values by standby efficiency level, in cells H28 to X46; and intermediate results, in cells H51 to X103.10

- A

- 4 5. Current application sector: since re sidential boilers are used for both residential and commercial applications, users could select the application sector by selecting sectors on the pull down menu in the “Current Application Sector” table (shown in F igure 10

- A.4.2 ). T he annual shipment, unit energy use, equipment cost etc. of residential boilers at base case and higher efficiency levels under the selected application sector could be s een in the accounting worksheets named by product classes, namely “HWGB”, “SGB”, “HWOB”, “SOB”, “HWEB”, “SEB”. It should be mentioned that all the results in the “NIA Summary” worksheet are aggregated from both residential and commercial applications.

Figure 10

- A.4.2 Select the application sector of residential boilers.

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

- A.4.3 ) :

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 product class

.

Figure 10

- A.4.3 Set the spreadsheet to automatic calculation mode.