11A -i APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL
IMPACTS ANALYSIS SPREADSHEETS

TABLE OF CO NTENTS

11A.1 INTRODUCTION ...................................................................................................... 11A-1
11A.2 INDIVIDUAL MODEL WORKSHEETS .................................................................. 11A-111A -1 APPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL
IMPACTS ANALYSIS SPREADSHEET S

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

.

Th e 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 (NPV s ) 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 R ISC & O IRA Consolidated Information S ystem tables and other
tables of interest.

The energy use and associated costs for a given candidate standard level ( C SL) are
determined by calculating the energy use and costs for all equipment shipped under that C SL.
The differen ces 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 levels11A -2 Scenario Contains matrices for determini ng how equipment changes among
CSLs

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

N PV 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