10-A-i

APPENDIX 10-A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

ENERGY SAVINGS 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-3

LIST OF TABLES

Table 10-A.2.1 List of National Impact Analysis Spreadsheets ....................................... 10-A-1
10-A-1

APPENDIX 10-A. USER INSTRUCTIONS FOR SHIPMENTS AND 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) room air 

conditioner and clothes dryer Rulemaking page: 

http://www.eere.energy.gov/buildings/appliance_standards/. From that page, follow the links to 

the Final Rule phase and then to the Analytical Tools. 

10-A.2 STARTUP

DOE named the spreadsheets for the product classes and subgroup analysis if applicable.

The spreadsheets enable users to perform National Impact Analysis (NIA) of room air 

conditioners and clothes dryers. A separate spreadsheet exists for each of the products. Table 10-

A.2.1 lists all national impact analysis spreadsheets used in this analysis. 

Table 10-A.2.1 List of National Impact Analysis Spreadsheets 

Filename Description

NIA_RAC.xls Room Air Conditioner Products

NIA_CD.xls Clothes Dryer Products

To examine the spreadsheets, DOE assumes that the user has access to a personal 

computer with a hardware configuration capable of running Windows NT/2000/XP. The room 

air conditioner and clothes dryer NIA spreadsheets require Microsoft Excel 2000 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 conservation standard. The 

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

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

Introduction The Introduction sheet contains a list and description of all worksheets 

used in the analysis.

Flow Chart The Flow Chart sheet contains a diagram of the structure of the inputs 

and outputs used to derive the NIA. 

Summary The Summary sheet contains energy savings results, net present value 

results, and emissions monetization results for each TSL considered. 
10-A-2

National Impacts 

Summary

The National Impacts Summary sheet contains user input selections, 

source energy savings results matrix, net present value results matrix, a 

summary table for each product class and charts of national impacts for 

each product class.

Base Case 

Consumption

The Base Case Consumption sheet contains the base case consumption

calculations.

NES The NES worksheets contain detailed calculations for the base case and 

the shipments and stock energy savings and net present value at given

candidate standard levels.

Base Case 

Shipments

The Base Case Shipments sheet contains a tabular summary and chart of 

the annual shipments forecasts for each product class at each trial 

standard level.

New Housing 

Market Share

The New Housing Market Share sheet contains the market share model 

calculations that determine the market shares for new housing market 

segment. (Clothes Dryer NIA spreadsheet only.) 

Historical Market 

Share Data

The Historical Market Share Data sheet contains the market share model 

calculations that determine the market shares for each market segment.

Efficiency Dist. The Efficiency Dist. sheet contains the efficiency trends model which 

captures the changing parameters due to changes in efficiency trends of 

equipment over time. 

Efficiency Trends The Efficiency Trends sheet contains the efficiency trends combined with 

the LCC inputs (Room Air Conditioner NIA spreadsheet only.)

LCC Inputs The LCC Inputs sheet contains inputs from the LCC spreadsheet for each 

product class.

Lifetime The Lifetime sheet calculates the lifetime expectancy distribution of room 

air conditioners and clothes dryers.

New Housing 

Forecast

The New Housing Forecast sheet provides projected new housing 

construction completions and manufactured home placements. 

Fuel Prices and 

Heat Rates

The Fuel Prices and Heat Rates sheets contain projected energy price

trends and site to source heat rates.
10-A-3

Shipments Forecast 

Charts

The Shipments Forecast Charts sheet contains charts of product 

shipments 

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

ANALYSIS SPREADSHEETS

 Basic instructions for operating the NIA spreadsheets are as follows:

 Once the NIA spreadsheet file has been downloaded from the Web, open the file using 

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

National Impacts Summary Analysis.

1. Use Excel's View/Zoom commands at the top menu bar to change the size of the display 

to make it fit your monitor.

2. The user can change the parameters under the title “National Impacts Summary”. The 

default parameters are:

a. Discount Rate: Set to 7 percent. To change value, click on cell C5 and interchange

value (7 percent or 3 percent).

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

desired year.

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

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

High Economic Growth). 

In the case of clothes dryers, 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.

 

In the room air conditioner spreadsheet, the user can visualize the automatically 

updated results for a given product class by using the pull down menu “select product 

class”. To see the results for the entire room air conditioner market, the user needs to 

update the results tables by clicking on the button “Update TSLs Results”. A macro will 

automatically generate the summary table results for all product classes.