APPENDIX 10

- B

. USER INSTRUCTIONS FO R SHIPMENTS AND NATIONAL

IMPACT ANALYSIS SPREADSHEETS

TABLE OF CO NTENTS

10

- B.1 INTRODUCTION

................................ ................................ ............................... 10

- B

- 1

10

- B.2 BASIC INSTRUCTIONS

................................ ................................ .................... 10

- B

- 2

10 A

- iAPPENDIX 10

- B. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL

IMPACT ANALYSIS SPREADSHEET S

10

- B.1 INTRODUCTION

The interested reader can examine and reproduce detailed results of the U.S. Department

o f Energy’s ( DOE’s ) shipments and national impact analysis (NIA) for commercial clothes washers using Microsoft Excel spreadsheets that are available on DOE’s website.

< http://www.eere.energy.gov/buildings/appliance_standards/ >

The latest version of the Microsoft Excel shipments and NIA workbook, which is posted on the DOE website, was tested using Microsoft Excel 20 10

. To execute the sprea dsheet requires

Microsoft Ex cel 2010 or a later version. The N IA spreadsheet performs calculations to forecast the change in national energy use and net present value due to an energy conservation standard. The energy use and associated costs and savings attributable to a given stand ard are determined first by calculating the shipments and then the energy use and costs for all products shipped

under that standard. The d ifferences between results under the standard case and the base case

then can be compared and the nationwide energy savings and net present values (NPVs)

determined.

The shipments and NIA workbook for both front

- and top

- loading residential clothes washers comprises 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 commercial clothes washers and the associated incremental prices. Th is sheet also contains efficiency weighted average energy and water use and equipment price for the base and standards cases for all the product

classes.

LCC Input This sheet c ontains the inputs from the Life

- cycle cost analysis

.

Efficiency Distribution This sheet contains base and standards case efficiency trends.

Historical Shipment This sheet contains data for historical sales of the equipment.

Base Case This sheet mainly performs the calculations leadin g up to the estimation of total commercial clothes washer shipments for the base case. 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 replacement s, and shipments going into new housing, thus yielding total shipments

. 10

- B

- 1Standards Case Contains stock accounting of the equipment that helps calculate annual commercial clothes washer shipments estimates for the

standards case.

Base Case Calc

. This sheet calculates the estimation of shipments for selected product class by taking cross

- price elasticity into account for the base case. It also calculates the energy and water consumption and operating cost for selected product c lass.

Standards Case Calc

. This sheet estimates shipments for selected product class by taking

cross

- price elasticity into account for the standards case. It also calculates the energy and water savings and cost savings. The energy and cost sav ings in a single year are the difference between the base case energy and water use and costs for that year and the standard case energy and water use and costs in the same year

.

Housing Projections This sheet provides projected new housing c onstruction starts by housing type.

Fuel & Water Prices This worksheet contains projected average electricity, gas and water prices for the three economic scenarios.

Heat Rates The sheet contains the site

- to

- power plants and full

- fuel

- cycle

conversion factors t hat are used in the primary and full

- fuel

- cycle energy savings calculations.

Lifetime This sheet contains the probability of survival of a commercial clothes washer unit at a given age of the unit. The sheet also provides the average lifetime of a unit.

10

- B.2 BASIC INSTRUCTIONS

Basic instructions for operating the NIA spreadsheet s are as follows:

1. Once the N IA spreadsheet s have been downloaded from the Web, open the file using

Excel. A t the bottom, click on the tab for the worksheet Input and Summary

.

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.

10

- B

- 23. The user can change the model parameters listed in the box labelled “User Inputs ”. The

parameters are:

a. Economic Growth: To the change value, use the drop

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

b. Discount Rate: To the change value, t ype in the desired Discount Rate.

c. Relative Price Elasticity: To change the applicable elastici ty , use the drop

- down

menu and select the desired value

. d. Base Case Efficiency Trend: To change value, use the drop

- down menu and select the desired efficiency growth value for desired product class ( Default , 1% growth, or 2% growth).

e. Standards Case Efficie ncy Trend: To change value, use the drop

- down menu and select the desired efficiency growth value for desired product class ( Default , 1% growth, or 2% growth).

4. Once the parameters have been set, t he results are automatically updated and are reporte d

in t he “National Impact Summary” table for each product class to the right of the “User

I nputs” box.

10

- B

- 3