10-A-i

APPENDIX 10-A. USER INSTRUCTIONS FOR NATIONAL IMPACT ANALYSIS

SPREADSHEET MODEL

TABLE OF CONTENTS

10-A.1 USER INSTRUCTIONS .....................................................................................10-A-1

10-A.2 STARTUP............................................................................................................10-A-1

10-A.3 DESCRIPTION OF NATIONAL IMPACT ANALYSIS WORKSHEETS.......10-A-1

10-A.4 BASIC INSTRUCTIONS FOR OPERATING THE NATIONAL IMPACT 

ANALYSIS SPREADSHEETS...........................................................................10-A-2
10-A-1

APPENDIX 10-A. USER INSTRUCTIONS FOR NATIONAL IMPACT ANALYSIS

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 rulemaking page:

http://www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx?ruleid=62. From 

that page, follow the links to the Preliminary Analysis phase of the rulemaking and then to the 

analytical tools.

10-A.2 STARTUP

The NIA spreadsheets 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 NATIONAL IMPACT ANALYSIS WORKSHEETS

The NIA spreadsheets perform calculations to project the change in national energy use 

and net present value of financial impacts due to revised energy efficiency standards. 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.

HWEB Contains Electric Hot Water Boiler NIA calculations.

SEB 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 and 
10-A-2

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.

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 definitions used throughout the spreadsheet –

Also, worksheet where the ELs used in the analysis are defined

Shipments Historical shipment 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 FOR OPERATING THE NATIONAL IMPACT 

ANALYSIS SPREADSHEETS

Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheet file has been downloaded from the 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%. To 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 

Energy 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 residential 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 Figure 10-

A.4.2). The 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 seen 

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 changed by (shown in Figure 10-A.4.3): 

1. In Excel 2010 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.