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-i
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 dehumidifier 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 dehumidifiers. To utilize the spreadsheet, the Department assumes that the user has 

access to a PC with a hardware configuration capable of running Windows 2007 or later. To use 

the NIA spreadsheets, the user requires Microsoft Excel® 2007 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 dehumidifiers 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:

Input and 

Summary

This sheet contains user input selections under “User Inputs” and a

summary table, Cumulative Energy Savings and NPV for the 

selected standard level efficiency distribution. The sheet contains 

the efficiency levels being considered for residential dehumidifiers

and the associated incremental prices. This sheet also contains 

efficiency weighted average energy use and equipment price for 

the base and standards cases for all the product classes.

Efficiency 

Distribution

This sheet contains base and standards case efficiency trends for 

each product class. 

Historical 

Shipment This sheet contains data for historical sales of the equipment.

Base Case

This sheet calculates the estimation of shipments for selected 

product class. The sheet starts with the stock accounting of the 

equipment and uses the survival function to calculate the surviving 

stock. It then performs calculations of replacements, and 

shipments going into new ownership, thus yielding total shipments 

10-A-1
for selected product class. It also calculates the energy 

consumption and operating cost for selected product class.

Standards Case

This sheet estimates shipments for selected product class by taking 

price elasticity into account for the standards case. It also 

calculates the energy savings and cost savings. The energy and 

cost savings in a single year are the difference between the base 

case energy use and costs for that year and the standard case 

energy use and costs in the same year.

Housing 

Projection

This sheet includes Annual Energy Outlook (AEO) projection of 

housing stocks and housing starts for residential buildings.

Electricity Prices This worksheet contains projected average electricity for the three 

economic growth scenarios.

Learning Rate It includes the learning multipliers to adjust the manufacturer’s 

cost over the entire analysis period.

Site-to-Power 

Plant

The sheet contains the marginal site-to-power plant conversion 

factors that are used in the source energy savings calculations.

Lifetime This sheet contains 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 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 are:

(a) Discount Rate: Set to 7%. To change value, click on the drop-down arrow and 

interchange value (7% or 3%).

(b) Product Class: To change product class, click on the drop-down arrow and 

interchange value (Product Class 1, 2, 3, 4, 5, 6, or 7).

(c) Trial Standards Level: To change standards level, click on the drop-down arrow

and interchange value (TSL 1, 2, 3, or 4).

(d) Relative Price Elasticity: To change the applicable elasticity, use the drop-down 

arrow and select the desired value (No impact or RP elasticity = - 0.34)

10-A-2
(e) Economic Growth: To change the value, use the drop-down arrow and select the 

desired Growth level (Reference, High, or Low).

(f) Learning Sensitivity: To change value, use the drop-down arrow and select the 

desired learning level (Default, High, or Low).

(g) Current Year: Set to 2013. To change the value, click on cell D6 and change to 

desired year.

4. Once the parameters have been set, the results are automatically updated and are reported 

in the “National Impact Summary” table for each product class to the right of the “User 

Inputs” box.

10-A-3