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 Building Technologies website

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

There is a single NIA spreadsheet encompassing all miscellaneous refrigeration products.

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 and net present 

value 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:

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 miscellaneous refrigeration 

products and the associated incremental prices. This sheet also 

contains base and standards case efficiency trends for 

miscellaneous refrigeration products, and efficiency weighted 

average energy use and equipment price for the base and standards 

cases.

Shipments Contains estimated data for historical and projected sales of 

miscellaneous refrigeration products.

Efficiency Dist. Contains the base case market share by efficiency level. The 

projected efficiency distributions for both base and standard case 

are provided.
10A-2

Calcs The first part contains the calculations for determining the 

shipments, energy consumption, and operating costs for the base 

case. The second part contains stock accounting of the equipment 

that calculates annual shipments estimates, energy savings, and 

operating cost savings for the standards case. The sheet starts with 

the stock accounting of the equipment and uses the survival 

function to calculate the surviving stock. 

Price Trends Contains three price scenarios (default, high price decline and low 

price decline) for sensitivity analysis 

Electricity Prices Contains projected average energy prices for the three economic 

scenarios, as well as the marginal site to source conversion factors 

and full-fuel-cycle factors that are used in the full-fuel-cycle 

energy savings calculations. 

Lifetime Contains the probability of survival of a miscellaneous 

refrigeration product at a given age and the average lifetime of a 

unit.

10A.2 BASIC INSTRUCTIONS

Basic instructions for operating the NIA spreadsheet are as follows:

1. Once the NIA spreadsheet has 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. Discounting future values: To change the value used for discounting NPV and 

national energy savings, and the year in which to discount to. 

b. Economic Growth: To the change value, use the drop-down arrow and select the 

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

c. Price Trend: To change the price trend scenario used in NPV calculation, use the 

drop-down arrow and select the desired price trend (Default, High Price Decline 

and Low Price Decline)
10A-3

4. Once the parameters have been set, click the “EL” drop-down list 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. 

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

product class below the “User Inputs” box.