10-A-i

APPENDIX 10-A. USER INSTRUCTIONS FOR THE NATIONAL IMPACTS

ANALYSIS SPREADSHEET

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 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 DOE's Appliance Standards Rulemaking 

page: http://www.eere.energy.gov/buildings/appliance_standards/.

10-A.2 STARTUP

The spreadsheet enables users to perform the National Impact Analysis (NIA) of 

microwave and combination ovens.

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 

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 heating 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:

Input and 

Summary

The Input and Summary sheet contains user input selections and a 

summary table for each product class.

Charts The Charts sheet contains a variety of charts and other information.

Summary (All 

TSLs)

The Summary (All TSLs) worksheet contains results for all TSLs under a 

variety of cost scenarios.

ROCIS The ROCIS worksheet contains the ROCIS results table.

Base Case The Base Case sheets contains a tabular summary and chart of the annual 

shipments forecasts for each product class at each trial standard level, 

along with energy and operating cost calculations.

Standards Case The Standards Case sheets contains a tabular summary and chart of the 

annual shipments forecasts for each product class at each trial standard 

level, along with energy and operating cost calculations.
10-A-2

Learning Rates The Learning Rates worksheet contains the default learning rate along 

with other learning rate sensitivities.

Housing 

Projections

The Housing Projections sheet contains AEO 2010 housing forecasts.

Historical Shipment The Historical Shipment sheet contains shipments data.

Lifetime The Lifetime sheet calculates the lifetime expectancy distribution.

Heat Rates The Heat Rates sheet contains projected site to source heat rates.

Elec Prices The Elec Prices sheet contains AEO 2010 electricity price projections.

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 “User Inputs”. The default parameters 

are:

a. TSL Level (cell I3): Set to 3. To change the TSL level analyzed, change the value 

of this cell. Acceptable values are 1-4.

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

value (7 percent or 3 percent).

c. Year To Discount To: Set to 2011. To change value, click on cell C6 and set the

desired year.

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

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

High Economic Growth).
10-A-3

e. Market Impact: Set to -0.34. To change the price elasticity, use the pull down 

menu and select the desired level (RP elasticity = -0.34 or No Impact).

f. Learning Case: Set to Default. To change the learning rate utilized, use the pull 

down menu to select the desired rate.

The results are automatically updated and are reported in the National Impact 

Summary table for each product class. Annualized values are presented as well.