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 INSTRUCTIONS FOR SHIPMENTS AND NI A

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 Buildin g Technologies website

at: http://www1.eere.energy.gov/buildings/appliance_standar ds/rulemaking.aspx/ruleid/71

.

There is a single NIA spreadsheet encompassing all miscellaneous refrigeration products

. The spreadsheet is p ost ed on the DOE website and represent s 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 n ational energy use and net present value due to an energy conservation standard. The energy use and associated costs for a given standard are determined first by calculating the shipments and then calculating the energy use and costs for all equipment ship ped under that standard. The differences between the standards

and base cases can then be compared and the overall energy savings and present values

determined.

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

Input and Summary C o ntains user input selections under “User Inputs” an d a s ummary table, Cumulative Energy Savings and NPV for the selected standard level efficiency distribution

. The sheet contains the efficiency levels being considered for miscellaneous refrigeration produ ct s and the associated incremental prices. This sheet also contains base and standards case efficiency trends for miscellaneous refrigeration product s , and efficiency weighted average energy use and equipment price for the base and standards

cases.

Shipmen t s Contains estimated data for historical and projected sales of

miscellaneous refrigeration products.

Efficiency Dist. Contains the base case market share by efficiency level

. The projected efficienc y distributions for both base and standard case

are provided.10A

- 2 Cal c s The first part c ontains the calculations for determining the shipments, energy consumption, and operating costs for the base

case. The second part c ontains stock accounting of the equipment that calculates annual shipments estimates, energy savings, and operating cost savings for the standards case. The sheet starts with the stock accounting of the equipment and uses the survival function to calculate the surviving stock.

Price Trend s Contains three price scenarios (default, high price decline and low price decline) fo r sensitivity analysis

Electricity Prices Contains projected average energy prices for the three economic

scenarios , as well as the marginal site to source conversion factors

and full

- fuel

- cycle factors that are used in the full

- fuel

- cycle

energy savi ngs calculations

.

Lifetime Contains the probability of survival of a miscellaneous refrigeratio n product at a given age and the average lifetime of a

unit.

10A.2 BASIC INSTRUCTIONS

Basic instructions for operating the NIA spreadsheet are as follows:

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

A t the bottom, c lick on the tab for the worksheet ‘Input and 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 grey box labelled “User Input s ”. The parameters are:

a. Discounting future values: To change the value used for discounting NPV and national energy savings, and the year in which to discount to.

b. Economic Growth: To the change value, use the drop

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

c. Price Trend: To change the price trend scenario used in NPV calculation, use the drop

- down arrow and select the desired price trend (Default, High Price Decline and Low Price Decline)10A

- 3 4. Once the parameters have been set, click the “ EL ” drop

- down list to choose which

effi ciency level to analyze. The associated efficiency distributions and growth tr ends are fixed as specified in c hapter 10 of this preliminary technical support document.

5. The results are automatically updated and are reporte d in the summary table for each

p roduct class below the “User I nputs” box.