8-A-i APPENDIX 8

- A. USER INSTRUCTIONS FO R THE LIFE

- CYCLE COST

ANALYSIS SPREADSHEET

TABLE OF CO NTENTS

8- A.1 USER INSTRUCTIONS

....................................................................................... 8-A-1

8- A.2 STARTUP

.............................................................................................................. 8-A-1

8- A.3 DESCRIPTION OF LIFE

- CYCLE COST WORKSHEET S ................................ 8-A-1

8- A.4 BASIC INSTRUCTIONS FOR OPERATING THE LIF E- CYCLE COST

SPREADSHEETS

.................................................................................................. 8-A-3

LIST OF TABLES

Table 8 -A.2.1 List of LCC Spreadsheets .......................................................................... 8-A-18

- A

- 1 APPENDIX 8

- A. USER INSTRUCTIONS FO R THE LIFE

- CYCLE COST ANALYSIS

SPREADSHEET

8- A.1 USER INSTRUCTIONS

The results obtained in this analysis can be examined and reproduced using the Microsoft Excel spreadsheets available on DOE's Home Appliances Rulemaking website: http://www.eere.energy.gov/buildings/appliance_standards/. From that page, follow the links to the NOPR phase and then to Analytical Tools.

8- A.2 STARTUP

DOE’s spreadsheets enable users to perform Life

- Cycle Cost (LCC) and Payback Period (PBP) analyses for each product class

. A separate spreadsheet exists for each product class.

Table 8 -A.2.1 lists the LCC spreadsheets used in this rulemaking.

Table 8 -A.2.1 List of LCC Spreadsheets

Filename Product Class
LCC_ RoomAir.xls Room Air Conditioners
LCC_ C lothes Dryer.xls Clothes Dryers

To examine the spreadsheets, DOE assumes that the user has access to a personal computer with a hardware configuration capable of running Windows NT/2000/XP. All LCC spreadsheets require Microsoft Excel 2000 or later installed under the Windows operating

system. Because certain variables inside the spreadsheets are defined as distributions, the user’s computer requires a c opy of Crystal Ball (a commercially available add -on program).

8- A.3 DESCRIPTION OF LIFE

- CYCLE COST WORKSHEET S

For both of the products, DOE created one spreadsheet containi ng a collection of

worksheets. Each work sheet represents a conceptual component within the LCC calculation. To facilitate navigability and identify how work sheets are related, each work sheet contains an area

on the extreme left showing variables imported to and exported from the current work sheet. Each LCC spreadsheet contains the following worksheets:

Summary The Summary work sheet contains LCC and PBP simulation results

for eac h design option and product class

.

Statistics The Statistics work sheet contains statistics for each design option and product class

.

LCC & PB Calcs The LCC&PB Calcs worksheet shows LCC calculation results for

di fferent efficiency levels for single Residential Energy Consumption Survey (RECS) households and Commercial Buildings Energy Consumption Survey (CBECS) building s , if8

- A

- 2 applicable

. 1, 2

Rebuttable Payback The Rebuttable Payback work sheet c ontains the total and

incremental manufac turer costs, retail prices, installation costs, repair and maintenance costs , energy use calculations, and simple payback period calculations for each efficiency level.

Equipment ( and

Installation /Maintenance )

Cost This work sheet calculate s retail price values used as inputs in the

LCC calculations in the Summary work sheet. In the Clothes Dryers LCC spreadsheet, installation and maintenance costs were included

in this worksheet.

RECS Households The RECS Households worksheet contains the RECS 200 5

household data for each residential product class.

CBECS Households The CBECS Households worksheet contains the CBECS 2003 building data for each commercial product class.

Energy Use Adjustment

Factors This worksheet calculates energy adjustment factors used in the energy use calculations for room air conditioners.

Models Data This worksheet includes information on equipment models.

Commercial and

Residential Weather

Station Data These worksheets include temperature data.

Base Case Eff Dist The Base Case EF worksheet determines the efficiency of the base

case unit.

( Per Cycle ) Energy Use The (Per Cycle) Energy Use worksheet calculates annual energy use by fuel type , d epending on product class.

Energy Prices The Energy Prices worksheet calculates energy prices, depending

on a number of variables.

Energy Price Trends The Energy Price Trends worksheet shows the future price trends

of the different heating fuels.

Discount Rate The Discount Rate worksheet contains the distributions of discount rates for replacement and new units.

Lifetime The Lifetime worksheet contains the distribution of lifetimes for equipment of that product class.8

- A

- 3 8- A.4 BASIC INSTRUCTIONS F OR OPERATING THE LIFE

- CYCLE

COST SPREADSHEETS

Basic instructions for operating the LCC spreadsheet are as follows:

1. Once the LCC spreadsheet has been downloaded, open the file using Excel

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

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

3. The user can change the parameters listed under USER INPUT on the Summary

worksheet. There are four drop-down boxes and one command button. The default

parameters are:

a. Energy Price Trend: Defaults to “AEO 2010 - Reference .” To change the input, use the drop-down menu and select the desired trend (Reference, Low

, or High).

b. Start Year: Defaults to “2014.” To change the value , use the drop-down menu and select the desired year.

c. # of Trials: Defaults to “10,000.” To change the value , use the drop-down menu and select the desired number of trials (1,000, 2,000, 3,000, 5,000, or 10,000 ).

d. Analysis Group: Defaults to “National.” To analyze a subgroup, use the dropdown menu and select the desired subgroup.

e. Learning Curve: Defaults to “Yes.”

4. To run the Crystal Ball simulation, click the “run” button (you must re- run after changing

any parameters). The spreadsheet will then be minimized. You can monitor the progress of the simulation by wat ching the count of iterations in the left bottom corner of the

screen

. Wh en the simulation is finished, the spreadsheet will re -open.

5. Additional information can be found in the Statistics and Summary worksheet s.8

- A

- 4 REFERENCES

1. U.S. Department of Energy - Energy Information Administration, Residential Energy Consumption Survey: 2005 Public Use Data Files, 2005.

< http://www.eia.doe.gov/emeu/recs/recspubuse05/pubuse05.html >

2. U.S. Department of Energy - Energy Information Administration, Commercial Buildings Energy Consumption Survey, 2003. < http://www.eia.doe.gov/emeu/cbecs/ >

3. Energy Information Administration, Updated Annual Energy Outlook 2009 Reference Case Service Report , 2009. Washington, DC. Report No. DOE/EIA-0383(2009).

< http://www.eia.doe.gov/oiaf/aeo/ >