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

fan rulemaking page:

http://www1.eere.energy.gov/buildings/appliance_standards/residential/furnace_fans.html. 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 spreadsheet enables the user to perform a National Impact Analysis (NIA) for 

the candidate standard levels (CSLs) for residential furnaces fans. To execute 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 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 fans 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:

FFC Multipliers Contains full fuel cycle multipliers for electricity, natural gas and 

distillate.

NIA Input Contains energy use, electricity use, total installed price, annual 

repair and maintenance costs and base case distributions.

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

over the entire analysis period.

Shipments Shipment results for plotting.

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

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

Fuel Prices Contains energy prices for each product class by region, and 

energy price trends.

NWGFnc Contains non-weatherized non-condensing gas furnace NIA 

calculations.

NWGFc Contains non-weatherized condensing gas furnace NIA 

calculations.
10-A-2

WGF Contains weatherized gas furnace NIA calculations.

OF Contains oil furnace calculations.

EF Contains electric furnace NIA calculations.

MHGFnc Contains mobile home non-condensing gas furnace NIA 

calculations.

MHGFc Contains mobile home condensing gas furnace NIA calculations.

MHEF Contains mobile home electric furnace NIA calculations.

HAH Contains hydronic air handler NIA calculations.

Historical 

Shipments

Includes historical data and the annual shipments forecasts for 

each product class.

AEO Housing 

Forecast

Includes Annual Energy Outlook (AEO) forecasts of housing 

stocks and housing starts by region.

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

homes.

Site-to-Source Includes the heat rates from AEO forecasts.

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.

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 in the sheet “NIA Summary”. The default 

parameters are:

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

or 3%).

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

year.

4. The user can change the selected CSL under “Summary” by changing the value in cell 

K3 which allows the user to select the CSL 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.