APPENDIX 9-A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL ENERGY SAVINGS SPREADSHEET MODEL

TABLE OF CONTENTS

9-A.1 USER INSTRUCTIONS .......................................................................................9-A-1 9-A.2 STARTUP..............................................................................................................9-A- 1 9-A.3 DESCRIPTION OF NATIONAL IMPACT ANALYSIS WORKSHEETS.........9-A-1 9-A.4 BASIC INSTRUCTIONS FOR OPERATING THE NATIONAL IMPACT ANALYSIS SPREADSHEETS.............................................................................9-A-3

LIST OF TABLES

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

9-A-iAPPENDIX 9-A. USER INSTRUCTIO NS FOR SHIPMENTS AND NATIONAL
ENERGY SAVINGS SPREADSHEET MODEL

9-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 Heating Produc ts Rulemaking page: http://www.eere.energy.gov/buildings/appliance_standa rds /. From that page, follow the links to the NOPR phase and then to the Analytical Tools.

9-A.2 STARTUP

DOE named the spreadsheets for the product cl asses 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 9­ A.2.1 lists all national impact analysis spreadsheets used in this analysis.

Table 9-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 capab le of running Windows NT/2000/XP. The Room Air Conditioner and Clothes Dryer NIA spreadsh eets require Microsoft Excel 2000 or later installed under the Windows operating system.

9-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 financia l impacts due to a revised ener gy conservation standard. The energy use and associated costs for a given st andard 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 st andards 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.

National Impacts The National Impacts Summary sheet contains user input selections, Summary source energy savings results matrix, net present value results matrix, a summary table for each product class a nd charts of national impacts for
9-A-1each product class.

Base Case Consumption The Base Case Consumption sheet contains the base case consumption calculations.

NIA The NIA sheet contain detailed calculations for the base case and the shipments and stock energy saving s and net present value at given candidate standard levels.

Shipments Forecast The Shipments Forecast sheet contains a tabular summary and chart of the annual shipments forecasts for each product class at each trial standard level.

New Housing The New Housing Market Share sheet contains the market share model Market Share calculations that determine the mark et shares for new housing market segment. (Clothes Dryer NIA spreadsheet only.)

Historical Market The Historical Market Share Data sheet contains the market share model Share Data calculations that determine the market shares for each market segment.

Efficiency Trends The Efficiency Trends sheet contains the efficiency trends model which captures the changing parameters due to changes in efficiency trends of equipment over time. (Room Air C onditioner NIA spreadsheet only.)

LCC Inputs The LCC Inputs sheet contains inputs from th e LCC spreadsheet for each product class.

Retirement The Retirement Function sheet calculates the lifetime expectancy Function distribution of room air cond itioners and clothes dryers.

New Housing The New Housing Forecast sheet provides projected new housing Forecast construction completions and ma nufactured home placements.

Fuel Prices and Site The Fuel Prices and Site to Source sheet contains projected energy price to Source trends and site to source heat rates.

Shipments Forecast The Shipments Forecast Charts sheets contains charts of product Charts shipments

9-A-29-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 dow nloaded 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 2014. To change valu e, click on cell C6 and interchange to desired year.

c. Economic Growth: Set to Re ference 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 cla ss by using the pull down menu “select product class”. To see the results for th e entire Room Air C onditioner market, the user needs to update the results tables by clicking on the button “Update all Results”. A macro will automatically generate the summary table results for all product classes.

9-A-3