10A

- i APPENDIX 10 A

. USER INSTRUCTIONS FO R SHIPMENTS AND N ATIONAL

IMPACT ANALYSIS SPREADSHEETS

TABLE OF CO NTENTS

10A.1 INTRODUCTION

................................ ................................ ................................ ......... 1

10A.2 INDIVIDUAL SHIPMENTS MODEL WORKSHEETS

................................ ............. 1

10A.3 BASIC INSTRUCTIONS

................................ ................................ .............................. 210A

- 1 APPENDIX 10A

. USER INSTRUCTIONS FOR SHIPMENTS AND N ATIONAL

IMPACT ANALYSIS SPREADSHEET S

10A .1 INTRODUCTION

The results obtained for the shipments analysis and national impacts analysis (NIA) can be examined and reproduced using Microsoft Excel spreadsheet s available on the U.S. Department of Energy (DOE) Building Technologies website at:
h ttp://www1.eere.energy.gov/buildings/appliance_standards/commercial/metal_halide_lamp_fixt

ures.html

. The spreadsheet s post ed represent the lat est version s that have been tested with both

Microsoft Excel 200 7 and 20 10

.

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

. This spreadsheet performs calculations to forecast shipments during the analysis period (201 5

– 20 44 )

, 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) ar e 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 w orkbook , as listed and described

below.

Instructions This worksheet contains further instructions for navigating through the shipments/NIA workbook

.

NIA This work sheet contains user

- selected values, shipments/NIA results, and NIA calculations

. This work sheet 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 hi storical 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 histori cal 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 assum ptions, calculations, and plots for all equipment classes in this analysis.

10A .3 BASIC INSTRUCTIONS

Below are basic instruction s for op e rating the s hipments / 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, t he user can cha n ge the model parameters listed in the upper

- left

corner of the worksheet as follows:

a. Roll o r Shift scenario: S elect either Roll

- up or Shift scenario for the standards case.

The d ifference between the scenarios is described in TSD c hapter 9, Shipments Analysis.

b. Standard Level : S elect the desired candidate standard level from the drop

- down

menu.

c. Discount Rate : S elect the desired discount rate for the NIA analysis. T o 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 i n 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.