APPENDIX 10-A. USER INSTRUCTIONS FOR NATIONAL IMPACT ANALYSES

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 ANALYSES WORKSHEETS......10-A-1

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

ANALYSES SPREADSHEETS..........................................................................10-A-3

LIST OF FIGURES

Figure 10-A.4.1 The default user input parameters............................................................10-A-4

Figure 10-A.4.2 Set the spreadsheet to automatic calculation mode..................................10-A-5

10-A-i
APPENDIX 10-A. USER INSTRUCTIONS FOR NATIONAL IMPACT ANALYSES 

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 U.S. Department of Energy’s (DOE's)

commercial packaged boiler rulemaking 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 

analytical tools.

10-A.2 STARTUP

The National Impact Analyses (NIA) spreadsheets enable the user to examine selected 

national impacts attributable to each efficiency level considered for commercial packaged 

boilers. To use 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 ANALYSES 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 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 Small Natural Draft Gas-fired Hot Water Boiler NIA 

calculations.

LGNDHW

Contains Large Natural Draft Gas-fired Hot Water Boiler NIA 

calculations.

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

10-A-1
calculations.

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 Mechanical 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 contains 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 consumers 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-2
homes.

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

ANALYSES SPREADSHEETS

Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheet file 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 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 2019. To change value, click on cell D6 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 D8) is automatically 

calculated based on the year standards in effect and analysis period. 

(c) Discount Rates: 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 D10 and change to 

desired year.

(e) Economic Growth Scenario: Set to “AEO2014 Reference”. To change value, 

click on the pull down menu next to cell C19 “Economic Growth Scenario” and 

change to desired scenario.

(f) Equipment Price Trend Scenario: Set to “Constant”. To change value, click on 

the pull down menu next to cell C21 “Equipment Price Trend” and change to 

desired scenario.

10-A-4
(g) Relative Price Elasticity: Set to -0.34. To change value, click on the pull down 

menu next to cell C23 “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 

commercial and residential applications, users could select the application sector by

selecting sectors on the pull down menu in the “Application Sector” table next cell D22

in “Labels”. The annual shipment, unit energy use, equipment cost etc. of commercial

packaged 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 is in automatic calculation mode. The calculation 

mode could be changed by (shown in Figure 10-A.4.2): 

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 equipment class.

Figure 10-A.4.2 Set the spreadsheet to automatic calculation mode

10-A-5