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) central 

air conditioner, heat pump, and furnace rulemaking page: 

http://www.eere.energy.gov/buildings/appliance_standards/residential/furnaces_boilers.html and 

http://www.eere.energy.gov/buildings/appliance_standards/residential/central_ac_hp.html. From 

that page, follow the links to the Direct Final Rule notice (DFR) and then to the analytical tools.

10-A.2 STARTUP

The NIA spreadsheet enables the user to perform a National Impact Analysis (NIA) for 

the trial standard levels (TSLs) for residential furnaces and central air conditioners and heat 

pumps. To execute the spreadsheet, the Department assumes that the user has access to a PC with 

a hardware configuration capable of running Windows XP 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 forecast the change in national energy use 

and net present value of financial impacts due to a revised energy efficiency standard. The 

energy use and associated costs for a given standard are determined by first calculating the 

shipments and then calculating the energy use and costs for all furnace and 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:

Results Contains electricity savings results for heating and cooling for the 

selected TSL.

Furnace AFUE 

distribution

Contains efficiency distribution for furnace product classes.

CAC-HP Eff Distr. Contains efficiency distributions for central air conditioner and 

heat pump product classes.

CAC-HP Eff 

Trends

Contains historical and forecasted trends in central air conditioner 

and heat pump efficiency distributions.

User Inputs Contains user input selections.

Labels Includes labels for each product class, economic growth scenarios, 

and climate region.

Switching Tables Includes fuel switching matrices by region. 

Learning Rate Includes the learning multipliers to adjust the manufacturer’s cost 

over the entire analysis period
10-A-2

ROCIS Allows to calculate the annualized benefits for each TSL

Summary all TSL Includes summary tables that include the social cost of emissions 

and the annualized values over the analysis period

Summary Contains a summary of NIA results, including social cost of 

emissions reductions, and inputs for TSL analyzed, start year, and 

discount rate.

NIA Summary Contains source energy savings results matrix, net present value 

results matrix, and a summary table for each product class.

Default Distr Contains base case efficiency distributions.

Energy and Cost 

Data

Contains energy use values and repair and maintenance costs.

Fuel Prices Contains energy prices and trends.

Shipments Check Contains shipments values from the product class worksheets.

SAC-CO Contains split air conditioners coil only product class NIA 

calculations.

SAC-BC Contains split air conditioners blower coil product class NIA 

calculations.

PAC Contains packaged air conditioners product class NIA calculations.

SHP Contains split-system heat pumps product class NIA calculations.

PHP Contains packaged heat pumps product class NIA calculations.

NWGF Contains non-weatherized gas furnace product class NIA 

calculations.

MHF Contains mobile home gas furnace product class NIA calculations.

OF Contains oil-fired furnace product class NIA calculations.

EF Contains electric furnace product class NIA calculations.

Historical 

Shipments

Includes historical data and the annual shipments forecasts for 

each product class.

AEO Resid &

Comm. Forecast

Includes Annual Energy Outlook (AEO) residential and 

commercial building data forecasts.

New Saturation Contains market saturation data for each product class in new 

homes.

Site-to-Source Includes the heat rates from AEO2010 by climate region.

Lifetime Includes the lifetime and the retirement function for each product

class.

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 Internet, open the file using 

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

User Inputs.
10-A-3

2. Use 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 under “User Inputs”. The default parameters are:

a. Discount Rate: Set to 7%. To change value, click on cell E27 and interchange value (7% 

or 3%).

b. Current Year: Set to 2011. To change value, click on cell E29 and change to desired 

year.

c. Economic Growth: Set to Reference Case. To change value, use the drop-down arrow 

and select the desired level (Reference Case, Low Economic Growth, or High Economic 

Growth).

4. The user can change the selected TSL under “Summary”. The drop down arrow in cell 

D5 allows the user to select the TSL analyzed. 

The results are automatically updated and are reported in the source energy savings matrix, net 

present value matrix, summary table for each product class, and charts of national impacts for 

each product class.