APPENDIX 10-B. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

IMPACT ANALYSIS SPREADSHEETS

TABLE OF CONTENTS

10-B.1 INTRODUCTION ............................................................................................... 10-B-1

10-B.2 BASIC INSTRUCTIONS.................................................................................... 10-B-2

10A-i
APPENDIX 10-B. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL

IMPACT ANALYSIS SPREADSHEETS

10-B.1 INTRODUCTION

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

of 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 2010. To execute the spreadsheet requires 

Microsoft Excel 2010 or a later version. The NIA 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 standard are determined 

first by calculating the shipments and then the energy use and costs for all products shipped 

under that standard. The differences 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 contains user input selections under “User Inputs” and a 

summary 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. This 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 contains 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 leading 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 replacements, and shipments 

going into new housing, thus yielding total shipments.

10-B-1
Standards 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 class.

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 savings 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 construction 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 that 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 spreadsheets are as follows:

1. Once the NIA spreadsheets have been downloaded from the Web, open the file using

Excel. At 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-2
3. 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, type in the desired Discount Rate.

c. Relative Price Elasticity: To change the applicable elasticity, 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 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).

4. Once the parameters have been set, the results are automatically updated and are reported 

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

Inputs” box.

10-B-3