10 A

- i APPENDIX 10 A. USER INSTRUCTIONS FO R SHIPMENTS AND NIA

SPREADSHEETS

TABLE OF CONTENTS

10A.1 INTRODUCTION

................................ ................................ ................................ 10A

- 1

10A.2 BASIC INSTRUCTIONS

................................ ................................ ..................... 10A

- 210A

- 1 APPENDIX 10A. USER INSTRUCTION S 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 (DOE) Building Technologies website

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

.

The spreadsheet is post ed on the DOE website and represents the latest version that has

b een tested with Microsoft Excel 2010.

To execute the sprea dsheet requires Microsoft Excel 2003 or a later version. The N IA spreadsheet performs calculations to forecast the change in national energy use (NES) and net present value (NPV) due to an energy conservation standard. The energy use and a ssociated

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 an d the overall energy savings and present

values determined.

The N IA spreadsheet or workbook consists of the following worksheets:

Simulation Inputs Contains high

- level input parameters including equipment class labels, start year, and relative price e lasticity values.

Summary C ontains user input selections under “User Inputs” an d a s ummary table, Cumulative NES and NPV

, for the selected standard level efficiency distribution

. The sheet contains the efficiency levels being considered for refrigerated beverage vending machines and the associated incremental prices.

Shipmen ts Contains estimated data for historical and projected future sales of refrigerated beverage vending machines

.

Efficiency Dist. Contains base and standards case efficiency trends for refrigerated beverage vending machines.

Ca lcs Contains the calculat ions for determining the shipments, energy consumption, equipment costs, repair costs, and operating costs for the base case and at the standard level selected on the “Summary”

worksheet.10A

- 2 Price Trend Contains total installed costs by equipment class in cluding price trends (default, high price decline, and low price decline).

Electricity Prices Contains projected average energy prices for commercial and industrial electricity for the three economic scenarios.

Lifetime Contains the probability of su rvival of a refrigerated beverage vending machine at a given age and the average lifetime of a unit.

LCC Data Contains data from the LCC spreadsheet output that are required by the NIA spreadsheet, including total installed price, annual energy use, and annual repair and maintenance cost by equipment class and efficiency level.

10A.2 BASIC INSTRUCTIONS

Basic instructions for operating the NIA spreadsheet s are as follows:

1. Once the N IA spreadsheet s have been downloaded from the Web, open the file using

Excel. A t the bottom, click on the tab for the worksheet ‘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 white box at the top o f the

worksheet . The parameters are:

a. Start Year: To select the year in which standards will come into effect. Three options are available (2019 is the default, then 2021, and 2023).

b. Discount Year and Custom Discount Rate : To change the value used for

di scounting NPV and NES , and the year in which to discount to.

c. Learning : This parameter can be excluded from the calculations by selecting

“Off”.

d. Economic Scenario : To change the value, use the drop

- down arrow and select the desired Growth level (Reference, Low, or High).

e. Analysis Length (years): this parameter is 30 by default.

f. Product Group: The green summary table will not be affected by this, however, it will change the results shown on the sheets “Calcs” and “Efficiency Dist.”. If you

wish to view the r esults broken down by year, rather than the cumulative results, select the desired product group and then view the results on these two sheets.

4. Once the parameters have been set, click the “EL” button to choose which efficiency level to analyze. The ass ociated efficiency distributions and growth trends are fixed as specified in c hapter 10 of this preliminary technical support document.10A

- 3 5. The cumulative results are automatically updated and are reporte d in the summary table for each equipment class in a g reen table below this box. The annual results for each equipment class subcategory at a given efficiency level can be seen by selecting the

“Calcs” tab.