10

- A

- i APPENDIX 10

- A. USER INSTRUCTIONS FO R S HIPMENTS AND NATIONA L

ENERGY SAVINGS SPREA DSHEET MODEL

TABLE OF CO NTENTS

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 SPREADSHEET S ........................................................................... 10-A-3

LIST OF TABLES

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

- A

- 1 APPENDIX 10

- A. U SER 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 dr yer Rulemaking pag e: 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 Analy sis (NIA) of room air conditioners and clothes dryers. A separate spreadsheet exists for each of the product s. 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

N IA

_ 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

a ir conditioner and clothes d ryer NIA spreadsheets require Microsoft Excel 2000 or late r 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 first calculating the shipments and then by calculating the energy use and costs for all products shipped under that

standard. The differences between the sta ndards 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 work sheet s contain detailed calculations for the base case and the shipments and stock energy savings and net present value at given

candidate standard level s

.

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 mod el 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 (Roo m 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 sheet s 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 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. U se 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 d ryers, t he 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 a ir c onditioner 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 a ir c onditioner market, the use r 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.