10A

- i

APPENDIX 10A. USER INSTRUCTIONS FO R N ATIONAL I MPACT A NALYSIS SPREADSHEET MODEL

TABLE OF CO NTENTS

10A

- 1 USER INSTRUCTIONS

................................ ................................ ...................... 10A

- 1 10A

- 2 STARTUP

................................ ................................ ................................ ............. 10A

- 1 10A

- 3 DESCRIPTIONS OF NATI ONAL IMPACT ANALYSIS WORKSHEETS

...... 10A

- 1 10A

- 4 BASIC INSTRUCTIONS

................................ ................................ ..................... 10A

- 210A

- 1

APPENDIX 10A. U SER INSTRUCTIONS FOR N ATIONAL I MPACT A NALYSIS SPREADSHEET MODEL

10A

- 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 portable AC r ulemaking http://www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx?ruleid=??

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

a nalytical t ools

.

10A

- 2 STARTUP

The national impact analysis ( NIA ) spreadsheet s enable the user to perform a n NIA for portable air conditions (ACs)

. DOE assumes that the user has access to a PC that has a hardware configuration cap able of running Windows 2010 or later. To use the NIA spreadsheets, Microsoft Excel 2010 or later must be installed in the Windows operating system

.

10A

- 3 DESCRIPTION S OF NATIO N AL IMPACT ANALYSIS WORKSHEETS

The NIA work sheets perform calculations to project the change in national energy use and net present val ue of financial impacts produced by potential energy conservation standard s for portable ACs

. The energy use and associated costs for a given standard level are determined by calculating (1) shipments u nder that standard and (2) energy use and costs for all portable ACs shipped under that standard. The differences between conditions under a given standards

case and the base case can be compared and the overall energy savings and net present values determ ined. The NIA spreadsheets are described below.

Input and Summary This sheet enables the user to stipulate i nput s under “User Inputs

. ”

It also contains a s ummary table, " Cumulative Energy Savings and NPV
, " for the selected efficiency level

. The sheet provides the incremental total installed prices associated with the standard levels being evaluated for portable ACs . This sheet also contains efficiency

- weighted average energy use and the total installed product price for portable ACs under the base and standards cases

. Efficiency Distribution This sheet contains base

- and standards

- case efficiency trends for

portable ACs

. Historical Shipment This sheet contains historical data regarding sales of room ACs

and estimated sales of portable ACs

. Base Case Shipments This sheet estimates shipments of portable ACs . The sheet starts

with the stock accounting of the product and uses the appropriate survival function to calculate the surviving stock. Th e sheet then10A

- 2 calculat es replacements and shipments going to new owners , yielding total shipments of portable ACs

. Res_Base Case This sheet calculates the energy consumption and operating cost s

for portable ACs used in the residential sector under the base

- case

.

Res_ Stds Case This sheet estimates shipments to the residential sector for a given

standards case by accounting for price elasticity of demand

. It also calculates the energy and cost savings associated with a given standard

. The energy and cost savings in a given year are the difference between the base

- case and the standard s

- case energy use and costs in th at year

.
Comm_Base Case This sheet calculates the energy consumption and operating cost s

for portable ACs used in the commercial sector under the base

case.

Comm_Stds Case This sheet estimates s hipments to the commercial sector for a

given standards case by accounting for price elasticity of demand

. It also calculates the energy and cost savings associated with a given standard. The energy and cost savings in a given year are the difference between the base

- case and the standard s

- case energy use and costs in th at year

. Housing Projection This sheet includes a p rojection of total housing stocks for

residential buildings based on Annual Energy Outlook 2014 (AEO 2014 )

. Electricity Prices This worksheet contains projected average residential and

commercial electricity prices for the three economic growth scenarios in AEO 2014

. Learning Rate This sheet includes multipliers to adjust the manufacturer’s cost

throughout the analysis period bas ed on a learning curve

.

FFC Factor The sheet contains the site

- to

- power plant and full

- fuel

- cycle

conversion factors used to calculate the primary and full

- fuel

- cycle energy saving s , respectively

. Lifetime This sheet contains the lifetime and retirement function for

portable ACs

.

10A

- 4 BASIC INSTRUCTIONS
Basic instructions for operating the NIA spreadsheets are as follows

.

1. After downloading the NIA spreadsheet file from DOE’s website, use Microsoft Excel to op en it. Click “Enable Macro” when prompted

. At the bottom of the workbook, click on the tab for the worksheet Summary and Inputs. 2. Use Excel’s “View/Zoom” command in the top menu bar to change the size of the display so that it fits your monitor. 3. Use the graphical interface in the work sheet to choose parameters or enter data. You can change the default choices for some of the inputs

. To change a default input,10A

- 3 select the desired value from the drop

- down choices by the input box or enter the number manually where app ropriate

. The input parameters are as follows.

a. Discount Rate

. To change the value, which is set to 3 percent, click on cell D5 and change the value to 7 percent. b. Candidate Standards Level

. To change the level, click on the drop

- down arrow to select C SL 1, 2, 3
, or 4.

c. Relative Price Elasticity

. To change the applicable elasticity, use the drop

- down

arrow to select the desired value . To stipulate n o impact or set the relative price elasticity to

- 0.34

. d. Economic Growth

. To change the growth scenario , use the drop

- down arrow to select the desired AEO g rowth case (Reference, Low, or High ).

e. Learning Sensitivity

. To change the value, use the drop

- down arrow to select the desired learning

- curve level ( Default, High, or Low ). f. Current Year

. To chang e the year, which is set to 2014, click on cell D6 and change the year. 4. After you have select ed the desired parameters, t he spreadsheet will automatically generate updated NIA results based on the new simulation. Results are reported in the “National Impact Summary” table to the right of the “User Inputs” box.