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 A NALYSIS WORKSHEETS

....... 10

- A

- 1 10

- A.4 BASIC INSTRUCTIONS F OR OPERATING THE NAT IONAL 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 ) f urnace fan r ulemaking page: http://www1.eere.energy.gov/buildings/appliance_standards/residential/furnace_fans.html . From that page, follow the links to the Preliminary Analysis phase of the rulemaking 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 candidate standard levels (C SLs) for residential furnace s fans

. To execute the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable of running Windows 2003 or later. To use the NIA spreadsheets, the user requires Microsoft Excel ® 2003 or later installed under the W indows 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 energy efficiency standard. Th e 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 fans shipped under that standard. The differences between the standards and base case ca n then be compared and the overall energy savings and net present values determined. The NIA spreadsheets consist of the following worksheets:

FFC Multipliers Contains full fuel cycle multipliers for electricity, natural gas and distillate. NIA Input Contains energy use, electricity use, total installed price, annual repair and maintenance costs and base case distributions. Learning Rate Includes the learning multipliers to adjust the manufacturer’s cost over the entire analysis period

. Shipments Shipment results for plotting

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

. Fuel Prices Contains energy prices for each product class by region, and energy price trends. NWGFnc Contains non

- weatherized non

- condensing gas furnace NIA calculations. NWGFc Contains non

- weatherized condensing gas furnace NIA calculations.10

- A

- 2 WGF Contains weatherized gas furnace NIA calculations. OF Contains oil furnace calculations. EF Contains electric furnace NIA calculations. MHGFnc Contains mobile home non

- condensing gas furnace NIA calculations. MHGFc Contains mobile home condensing gas furnace NIA calculations. MHEF Contains mobile home electric furnace NIA calculations. HA H Contains hydronic air handler NIA calculations. Historical Shipments Includes historical data and the annual shipments forecasts for each product class

. AEO Housing Forecast Includes Annual Energy Outlook (AEO) forecasts of housing stocks and housing starts by region. New Saturation Contains market saturation data for each product class in new homes. Site

- to

- Source Inclu des the heat rates from AEO forecasts

. Lifetime Includes 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

.

2. Use Excel's ® View/Zoom commands at the top menu bar to change the size of the display to make it fit your monitor.

3. The user can change the parameters in the sheet “ NIA Summary ”. The default parameters are:

a. Discount Rate: Set to 7%. To change value, click on cell M11 and i nterchange value (7% or 3%).

b. Current Year: Set to 20 1 2 . To change value, click on cell M13 and change to desired
year.

4. The user can change the selected CSL under “Summary” by changing the value in cell K3 which allows the user to select the CSL 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.