APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA 
 

SPREADSHEETS
 

TABLE OF CONTENTS 


11A.1 INTRODUCTION ................................................................................................ 11A-1 


11A.2 SPREADSHEET WORKSHEETS....................................................................... 11A-1 


11A.3 BASIC INSTRUCTIONS..................................................................................... 11A-2 


11A-i 

EERE-2006-STD-0127 COMMENT 66.2
 

 

 

 

APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA 

SPREADSHEET 

11A.1 INTRODUCTION 

The results obtained for the shipments analysis and the national impact analysis (NIA) 

can be examined and reproduced using the Microsoft Excel spreadsheet available on the U.S. 

Department of Energy Building Technologies website 

at: http://www.eere.energy.gov/buildings/appliance_standards/. 

There is one NIA spreadsheet for commercial clothes washers. The spreadsheet posted 

on the DOE website represents the latest version and have been tested with Microsoft Excel 

2003. 

To execute the spreadsheet requires Microsoft Excel 2003 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 efficiency standard. The energy use and associated costs for a given 

standard are determined first by calculating the shipments and then calculating the energy use 

and costs for all equipment shipped under that standard. The differences between the standards 

and base cases can then be compared and the overall energy savings and present values 

determined. 

11A.2 SPREADSHEET WORKSHEETS 

The commercial clothes washer NIA spreadsheet or workbook consists of the following 

worksheets: 

Input and Summary 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 microwave ovens and the 

associated incremental prices. This sheet also contains base and 

standards case efficiency trends, and efficiency weighted average 

energy use and equipment price for the base and standards cases 

for all the product classes. 

Historical Shipment Contains data for historical sales of the equipment. 

Base Case This sheet mainly performs the calculations leading up to the 

estimation of shipments, energy consumption and operating cost 

calculations for the base case. The sheet starts with the stock 

accounting of the equipment and uses the survival function to 

11A-1
 

EERE-2006-STD-0127 COMMENT 66.2
 

 

 

 

 

calculate the surviving stock. It then performs calculations of 

replacements, and shipments going into new housing, thus yielding 

total shipments. 

Standards Case	 Contains stock accounting of the equipment that helps calculate 

annual shipments estimates, energy savings and operating cost 

savings for the standards case. 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 Projections	 Forecast sheet provides projected new housing construction starts 

and stock. 

Fuel Prices	 This worksheet contains projected average electricity prices for the 

three economic scenarios. 

Heat Rates	 The sheet contains the marginal site to source conversion factors 

that are used in the source energy savings calculations. 

Lifetime	 This sheet contains the probability of survival of a microwave oven 

unit at a given age of the unit. The sheet also provides the average 

lifetime of a unit. 

11A.3 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. 

3.	 The user can change the model parameters listed in the grey 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 value, use the drop-down arrow and select 

the desired. 

d.	 Lifetime: To change value, type in the desired value that lies within the maximum 

lifetime indicated. 

11A-2
 

EERE-2006-STD-0127 COMMENT 66.2
 

4.	 Once the parameters have been set, click the “Set base case/Standards Case” button and 

define the efficiency distribution of the market, and the efficiency growth rate for both 

the base case and the standards case. 

5.	 Once the distribution and the growth rate have been set, click the “update” button to 

make your defined distribution effective. 

6.	 The results are automatically updated and are reported in the summary table for each 

product class to the right of the “User Inputs” box. 

11A-3
 

EERE-2006-STD-0127 COMMENT 66.2