10

- A

- i APPENDIX 10

- A. USER INSTRUCTIONS FO R THE NATIONAL IMPACTS

ANALYSIS SPREADSHEET

TABLE OF CO NTENTS

10

- A.1 USER INSTRUCTIONS

................................ ................................ ..................... 10

- A

- 1

10

- A.2 STARTUP

................................ ................................ ................................ ............ 10

- A

- 1

10

- A.3 DESCRIPTION OF NATIO NAL IMPACT ANALYSIS WORKSHEETS

....... 10

- A

- 1

10

- A.4 BASIC INSTRUCTIONS F OR OPE RATING THE NATIONAL IMPACT

ANALYSIS SPREADSHEET S

................................ ................................ ........... 10

- A

- 210

- A

- 1 APPENDIX 10

- A. U SER INSTRUCTIONS FOR SHIPMENTS AND NATION AL

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

pag e: http://www.eere.ener gy.gov/buildings/appliance_standards/.

10

- A.2 STARTUP

The spreadsheet enable s users to perform the National Impact Analy sis (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

sprea dsheets require Microsoft Excel 2000 or later installed under the Windows operating

system.

10

- A.3 DESCRIPTION OF NATION A L 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 fir st 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 valu es 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 sheet s 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 sheet s 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 F OR 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 interch ange value (7 percent or 3 percent ).

c. Year To Discount T o : Set to 2011

. To change value, click on cell C6 and set t he 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 learn ing 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.