11A-i 

APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

IMPACTS ANALYSIS SPREADSHEETS

TABLE OF CONTENTS

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

11A.2 INDIVIDUAL MODEL WORKSHEETS .................................................................. 11A-1
11A-1 

APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 

IMPACTS ANALYSIS SPREADSHEETS 

11A.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: www1.eere.energy.gov/ 

buildings/appliance_standards/product.aspx/productid/60. 

The NIA spreadsheet performs calculations of the national energy savings (NES, i.e., the 

change in national energy use from the base to standards cases) and the net present values 

(NPVs) from potential energy conservation standards. In the notice of proposed rulemaking 

phase of this rulemaking, this model will contain numerous macros and spreadsheets required for 

calculating and outputting RISC & OIRA Consolidated Information System tables and other 

tables of interest.

The energy use and associated costs for a given candidate standard level (CSL) are 

determined by 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. 

11A.2 INDIVIDUAL MODEL WORKSHEETS 

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

Instructions Contains instructions on how to use the model 

Output Consolidates the NES and NPV values into a convenient format for 

output to text tables 

Formats Contains critical formats for use elsewhere in the model

Raw Shipments Contains shipments in raw form, to be reformatted and used 

elsewhere in the model

Base Shipments Contains shipments by equipment class and CSL in the absence of 

new or amended standards 

Base Stock Contains the present and future national stock of high-intensity 

discharge (HID) lamps in the absence of a potential standard

St Shipments Contains shipments by equipment class and CSL for different 

standard levels

St Stock Contains the present and future national stock of HID lamps for 

different standard levels
11A-2 

Scenario Contains matrices for determining how equipment changes among 

CSLs

NES Inputs Contains energy use and other information for use in the NES 

calculations

NPV Inputs Contains values for calculating NPV

NES Contains NES calculations 

NPV Combines operating cost savings from “Oper Costs” tab and 

installed costs increase from “Inst Costs” tab to compute NPVs for

both 3- and 7-percent discount rates 

Oper Costs Computes operating costs for all Roll scenarios 

Inst Costs Computes installed costs for all Roll scenarios based on the data 

from tabs “Percentages,” “Fixt inst,” “Ball inst,” and “Lamp inst” 

Percentages Contains percentages for the lamps shipments that are associated 

with fixture installations, ballasts installations or lamp installations 

for each CSL level 

Fixt inst Contains fixture installed costs for all equipment classes and 

analysis years

Ball inst Contains ballast installed costs for all equipment classes and 

analysis years

Lamp inst Contains fixture installed costs for all equipment classes and 

analysis years