10A-i

APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA 

SPREADSHEETS

TABLE OF CONTENTS

10A.1 INTRODUCTION ................................................................................................ 10A-1

10A.2 BASIC INSTRUCTIONS..................................................................................... 10A-2
10A-1

APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA 

SPREADSHEETS

10A.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 (DOE) Building Technologies website

at: http://www1.eere.energy.gov/buildings/appliance_standards/rulemaking.aspx/ruleid/73. 

The spreadsheet is posted on the DOE website and represents the latest version that has

been tested with Microsoft Excel 2010.

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 (NES) and net 

present value (NPV) due to an energy conservation 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. 

The NIA spreadsheet or workbook consists of the following worksheets:

Simulation Inputs Contains high-level input parameters including equipment class 

labels, start year, and relative price elasticity values. 

Summary Contains user input selections under “User Inputs” and a summary

table, Cumulative NES and NPV, for the selected standard level 

efficiency distribution. The sheet contains the efficiency levels 

being considered for refrigerated beverage vending machines and 

the associated incremental prices. 

Shipments Contains estimated data for historical and projected future sales of 

refrigerated beverage vending machines. 

Efficiency Dist. Contains base and standards case efficiency trends for refrigerated 

beverage vending machines.

Calcs Contains the calculations for determining the shipments, energy 

consumption, equipment costs, repair costs, and operating costs for 

the base case and at the standard level selected on the “Summary” 

worksheet. 
10A-2

Price Trend Contains total installed costs by equipment class including price 

trends (default, high price decline, and low price decline).

Electricity Prices Contains projected average energy prices for commercial and 

industrial electricity for the three economic scenarios. 

Lifetime Contains the probability of survival of a refrigerated beverage 

vending machine at a given age and the average lifetime of a unit.

LCC Data Contains data from the LCC spreadsheet output that are required 

by the NIA spreadsheet, including total installed price, annual 

energy use, and annual repair and maintenance cost by equipment 

class and efficiency level. 

10A.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 ‘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 white box at the top of the 

worksheet. The parameters are:

a. Start Year: To select the year in which standards will come into effect. Three 

options are available (2019 is the default, then 2021, and 2023). 

b. Discount Year and Custom Discount Rate: To change the value used for 

discounting NPV and NES, and the year in which to discount to. 

c. Learning: This parameter can be excluded from the calculations by selecting 

“Off”.

d. Economic Scenario: To change the value, use the drop-down arrow and select the 

desired Growth level (Reference, Low, or High).

e. Analysis Length (years): this parameter is 30 by default.

f. Product Group: The green summary table will not be affected by this, however, it 

will change the results shown on the sheets “Calcs” and “Efficiency Dist.”. If you 

wish to view the results broken down by year, rather than the cumulative results, 

select the desired product group and then view the results on these two sheets. 

4. Once the parameters have been set, click the “EL” button to choose which efficiency

level to analyze. The associated efficiency distributions and growth trends are fixed as 

specified in chapter 10 of this preliminary technical support document. 
10A-3

5. The cumulative results are automatically updated and are reported in the summary table 

for each equipment class in a green table below this box. The annual results for each 

equipment class subcategory at a given efficiency level can be seen by selecting the 

“Calcs” tab.