10A-i

APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

IMPACT ANALYSIS SPREADSHEETS

TABLE OF CONTENTS

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

10A.2 INDIVIDUAL SHIPMENTS MODEL WORKSHEETS .............................................1

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

APPENDIX 10A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

IMPACT ANALYSIS SPREADSHEETS

10A.1 INTRODUCTION

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

be examined and reproduced using Microsoft Excel spreadsheets available on the 

U.S. Department of Energy (DOE) Building Technologies website at:

http://www1.eere.energy.gov/buildings/appliance_standards/commercial/metal_halide_lamp_fixt

ures.html. The spreadsheets posted represent the latest versions that have been tested with both 

Microsoft Excel 2007 and 2010.

There is one spreadsheet for both the shipments and the NIA model. This spreadsheet

performs calculations to forecast shipments during the analysis period (2015–2044), the national 

energy savings (NES, i.e., the change in national energy use from the base to standards cases),

and the net present value (NPV) from an energy conservation standard. The energy use and 

associated costs for a given candidate standard level (CSL) are determined first by calculating 

the shipments and then calculating the energy use and costs for all equipment shipped under that 

CSL. The differences between the standards and base cases can then be compared, and the 

overall NES and NPV determined.

10A.2 INDIVIDUAL SHIPMENTS MODEL WORKSHEETS

There are several shipment worksheets in the NIA workbook, as listed and described 

below.

Instructions This worksheet contains further instructions for navigating through 

the shipments/NIA workbook.

NIA This worksheet contains user-selected values, shipments/NIA 

results, and NIA calculations. This worksheet allows users to 

choose a desired market scenario (Roll-Up or Shift), standard 

level, discount rate, and discount year. Shipment values are input 

from the shipments worksheets, and NIA (NES and NPV) values 

are calculated.

LCC Inputs This worksheet contains the Information Hub values and other 

important quantities from the “Output to NIA” worksheet in the 

LCC model.

W70 This worksheet contains historical and projected shipments for all 

candidate standard levels within the 70W equipment class. All 

possible market scenarios are computed, and the NIA worksheet 

selects the appropriate sets of values to use.
10A-2

W250 This worksheet contains historical and projected shipments for all 

candidate standard levels within the 250W equipment class. All 

possible market scenarios are computed, and the NIA worksheet 

selects the appropriate sets of values to use.

W400 This worksheet contains historical and projected shipments for all 

candidate standard levels within the 400W equipment class. All 

possible market scenarios are computed, and the NIA worksheet 

selects the appropriate sets of values to use.

W1000 This worksheet contains historical and projected shipments for all 

candidate standard levels within the 1000W equipment class. All 

possible market scenarios are computed, and the NIA worksheet 

selects the appropriate sets of values to use.

Lifetimes This worksheet contains lifetime assumptions, calculations, and 

plots for all equipment classes in this analysis.

10A.3 BASIC INSTRUCTIONS 

Below are basic instructions for operating the shipments/NIA workbook: 

1. Once the spreadsheet file is downloaded, open the file using Excel, and begin with the 

“Instructions” worksheet. This worksheet gives further descriptions of each worksheet 

within the workbook.

2. In the “NIA” worksheet, the user can change the model parameters listed in the upper-left 

corner of the worksheet as follows:

a. Roll or Shift scenario: Select either Roll-up or Shift scenario for the standards case. 

The difference between the scenarios is described in TSD chapter 9, Shipments 

Analysis. 

b. Standard Level: Select the desired candidate standard level from the drop-down 

menu.

c. Discount Rate: Select the desired discount rate for the NIA analysis. To change the 

value (ranges from 0 percent to 10 percent), use the drop-down menu. 

d. Discount Year: Select the year the NIA model discounts future expenditures to, using 

the drop-down menu.

3. The NIA results are automatically updated and reported for each equipment class in the 

“NIA” worksheet when users select values for the four quantities described in (a.) 

through (d.) above. Shipments and NIA results are displayed by equipment class in the 

“NIA” worksheet.