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

- 2

10

- A

- iAPPENDIX 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 ) residential dehumidifier r ul emaking page: http://www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx?ruleid=62

. From that page, follow the links to the Preliminary Analy sis phase of the rulemaking and then to the

a nalytical t ools.

10

- A.2 STARTUP

The NIA spreadsheet s enable the user to perform a National Impact Analysis (NIA) for residential dehumidifier s

. To utilize the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable of running Windows 200 7 or later. To use the NIA spreadsheets, the user requires Microsoft Excel ® 200 7 or later installed under the Windows ope rating system

.
10

- A.3 DESCRIPTION OF NATIO N AL IMPACT ANALYSIS WORKSHEETS
The NIA spreadsheets perform calculations to project the change in national energy use and net present val ue of financial impacts due to revised energy efficiency standard s

. The energy

use and associated costs for a given standard level are determined by calculating the shipments and then calculating the energy use and costs for all dehumidifier s shipped under that standard. The differences between 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:

Input and Summary This sheet c ontains user input selections under “User Inputs” an d a

s ummary table, Cumulative Energy Savings and NPV for the selected standard level efficiency distribution

. The sheet contains the efficiency levels being considered for residential dehumidifiers and the associated incremental prices. This sheet also contains efficiency weighted average energy use and equipment price for the base and standards cases for all the product classes. Efficiency Distribution This sheet contains base and standards case e fficiency trends for each product class. Historical Shipment This sheet contains data for historical sales of the equipment.

Base Case This sheet calculates the estimation of shipments for selected product class. The sheet starts with the stock accounting of the equipment and uses the survival function to calculate the surviving stock. It then performs calculations of replacements, and sh ipments going into new ownership
, thus yielding total shipments 10

- A

- 1for se lected product class. It also calculates the energy consumption and operating cost for selected product class.

Standards Case This sheet estimates shipments for selected product class b y taking price elasticity into account for the standards case. It also calculates the energy savings and cost savings. The energy and cost savings in a single year are the difference between the base case energy use and costs for that year and the standard case energy use and costs in the same year

. Housing Projection This sheet includes Annual Energy Outlook (AEO) projection of housing stocks and housing starts for residential buildings. Electricity Prices This worksheet contains projected average electricity for the three economic growth scenarios. Learning Rate It includes the learning multipliers to adjust the manufacturer’s cost over the entire analysis period. Site

- to

- Power Plant The she et contains the marginal site

- to

- power plant conversion factors that are used in the source energy savings calculations.

Lifetime This sheet contains the lifetime and the retirement function for each product class.

10

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

1. Once the NIA spreadsheet f ile has been downloaded from the Department’s web site
, open the file using MS Excel

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

.
2. Use MS 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 the drop

- down arrow and i nterchange value (7% or 3%).

(b) Product Class: To change product class, click on the drop

- down arrow and interchange value (Product Class 1, 2, 3, 4, 5, 6
, or 7).

(c) Trial Standards Level: To change standards level, click on the drop

- down arrow and interchange value ( TSL 1, 2, 3
, or 4).

(d) Relative Price Elasticity: To change the applicable elasticity, use the drop

- down

arrow and select the desired value (No impact or RP elasticity = - 0.34)

10

- A

- 2(e) Economic Growth: To change the value, use the drop

- down arrow and select the desired Growth level (Reference, High, or Low).

(f) Learning Sensitivity: To change value, use the drop

- down arrow and select the desired learning level ( Default, High, or Low ).
(g) Current Year: Set to 20 1 3 . To change the value, click on cell D6 and change to desired year.

4. Once the parameters have been set, the results are automat ically updated and are reported in the “National Impact Summary” table for each product class to the right of the “User Inputs” box.

10

- A

- 3