10

- A

- i APPENDIX 10

- A. USER INSTRUCTIONS FO R N ATIONAL I MPACT A NALYSIS SPREADSHEET 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 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 N ATIONAL I MPACT A NALYSIS 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 ) c entral
a ir c onditioner, h ea t p ump, and f urnace r ulemaking page: http://www.eere.energy.gov/buildings/appliance_standards/residential/furnaces_boilers.html and http://w ww .eere.energy.gov/buildings/appliance_standards/residential/central_ac_hp.html . From that page, follow the links t o the Direct Final Rule notice (DFR ) and then to the a nalytical t ools.
10

- A.2 STARTUP
The NIA spreadsheet enables the user to perform a National Impact Analysis (NIA) for the trial standard levels (TSLs) for residential furnace s and central air conditioners and heat pumps. To execute the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable of running Windows XP or later. To use the NIA spreadsheets, the user requires Microsoft Excel ® 2003 or later installed under the Windows operating system

. 10

- A.3 DESCRIPTION OF NATIO N AL 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 ener gy efficiency standard. The energy use and associated costs for a given standard are determined by first calculating the shipments and then calculating the energy use and costs for all furnace and boilers shipped under that standard. The differences betw een 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:

Results Contains electricity savings results for heating and cooling for the selected TSL. Furnace AFUE distribution Contains efficiency distribution for f urnace product classes.

CAC

- HP Eff Distr. Contains efficiency distributions for central air conditioner and heat pump product classes. CAC

- HP Eff Trends Contains historical and forecasted trends in central air conditioner and heat pump efficiency distributions. User Inputs C ontains user input selections. Labels I ncludes labels for each product class, economic growth scenarios, and climate region

. Switch ing Tables I ncludes fuel switching matrices by region. Learning Rate Includes the learning multipliers to adjust the manufacturer’s cost over the entire analysis period10

- A

- 2 ROCIS Allows to calculate the annualized benefits for each TSL Summary all TSL Includes summary tables that include the s ocial cost of emissions and the annualized values over the analysis period Summary C ontain s a summary of NIA results, including social cost of emissions reductions, and inputs for TSL analyzed, start year, and discount rate

. NIA Summary C ontain s source energy savings results matrix, net present value results matrix, and a summary table for each product class

. Default Distr C ontains b ase c ase efficiency distributions

. Energy and Cost Data C ontains e nergy use values and repair and maintenance cost s.
Fuel Prices C ontains e nergy prices and trends

. Shipments Check C ontains shipments values from the product class worksheets

. SAC

- CO C ontains split a ir conditioners coil only product class NIA calculations

. SAC

- BC C ontains split a ir conditioners blower coil product class NIA calculations

. PAC C ontains packaged a ir conditioners product class NIA calculations

. SHP C ontains s plit

- system heat pumps product class NIA calculations

. PHP C ontains p ackaged heat pumps product class NIA calculations

. NWGF C ontains n on
- weatherized gas furnace product class NIA calculations

. MHF C ontains m obile home gas furnace product class NIA calculations

. OF C ontains o il

- fired furnace product class NIA calculations

. EF C ontains e lectric furnace product class NIA calculations

. Historical Shipments I ncludes historical data and the annual shipments forecasts for each product class

. AEO Resid & Comm. Forecast I ncludes Annual Energy Outlook ( AEO ) residential and commercial building data forecasts. New Saturation Contains market saturation data for each product class in new homes. Site

- to

- Source I ncludes the heat rates from AEO2010 by climate region

. Lifetime I ncludes the lifetime and the retirement function for each product class

. 10

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE NATIONAL IMPACT ANALYSIS SPREADSHEETS Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheet file has been downloaded from the Internet , open the file using Excel ®

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

.10

- A

- 3 2. Use Excel's ® View/Zoom commands at the top menu bar to change the s ize of the display to make it fit your monitor.
3. The user can change the parameters under “User Inputs ”. The default parameters are:

a. Discount Rate: Set to 7%. To change value, click on cell E27 and i nterchange value (7% or 3%).
b. Current Year: Set to 20 11

. To change value, click on cell E29 and change to desired year.

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

- down arrow and select the desired level (Reference Case, Low Economic Growth , or High Economic Growth).
4. The user can change the selected TSL under “Summary”. The drop down arrow in cell D5 allows the user to select the TSL analyzed. 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.