APPENDIX 11A. USER INSTRUCT IONS FOR SHIP MENTS AND NIA SPREADSHEETS

TABLE OF CONTENTS

11A.1 INTRODUCTION ................................................................................................ 11A-1 11A.2 SPREADSHEET WORKSHEETS....................................................................... 11A-1 11A.3 BASIC INSTRUCTIONS..................................................................................... 11A-2

11A-iAPPENDIX 11A. USER INSTRUCTIONS FOR SHIPMENTS AND NIA
SPREADSHEET

11A.1 INTRODUCTION
The results obtained for the shipments analys is and the national impact analysis (NIA) can be examined and reproduced using the Micr osoft Excel spreadsheet available on the U.S. Department of Energy Building Technologies website
at: http://www.eere.energy.gov/buildings/appliance_standards /

. There is one NIA spreadsheet for commercial clothes washers. The spreadsheet posted on the DOE website represents the latest versi on and have been tested with Microsoft Excel 2003.

To execute the spreadsheet requires Micr osoft Excel 2003 or a later version. The NIA spreadsheet performs calculations to forecast the change in national energy use and net present value due to an energy efficiency standard. Th e energy use and associated costs for a given standard are determined first by calculating the shipments and then calc ulating the energy use and costs for all equipment shipped under that standard. The differences between the standards and base cases can then be compared and th e overall energy savings and present values determined.

11A.2 SPREADSHEET WORKSHEETS
The commercial clothes washer NIA spreadsh eet or workbook consists of the following worksheets:

Input and Summary Contains user input selections under “User Inputs” and a summary table, Cumulative Energy Savi ngs and NPV for the selected standard level efficiency distri bution. The sheet contains the efficiency levels being consider ed for microwave ovens and the associated incremental prices. This sheet also contains base and standards case efficiency trends, and efficiency weighted average energy use and equipment price fo r the base and standards cases for all the product classes.

Historical Shipment Contains data for historical sales of the equipment.

Base Case This sheet mainly performs the calculations leading up to the estimation of shipments, energy consumption and operating cost calculations for the base case. The sheet starts with the stock accounting of the equipment and us es the survival function to

11A-1calculate the surviving stock. It then performs calculations of replacements, and shipments going into new housing, thus yielding total shipments.

Standards Case Contains stock accounting of th e equipment that helps calculate annual shipments estimates, ener gy savings and operating cost savings for the standards case. The energy and cost savings in a single year are the difference between the base case energy use and costs for that year and the standard case energy use and costs in the
same year.
Housing Projections Forecast sheet provides projec ted new housing construction starts and stock.

Fuel Prices This worksheet contains projecte d average electricity prices for the three economic scenarios.

Heat Rates The sheet contains the marginal site to source conversion factors that are used in the source energy savings calculations.

Lifetime This sheet contains the probability of survival of a microwave oven unit at a given age of the unit. The sheet also provides the average lifetime of a unit.

11A.3 BASIC INSTRUCTIONS
Basic instructions for operating the NIA spreadsheets are as follows:

1. Once the NIA spreadsheets have been downloaded from the Web, open the file using Excel. At the bottom, click on the tab for the worksheet Input and Summary.

2. Use Excel’s View/Zoom commands at the top me nu bar to change the size of the display to make it fit your monitor.

3. The user can change the model parameters lis ted in the grey box labelled “User Inputs”. The parameters are:

a. Economic Growth: To the change value, use the drop-down arrow and select the desired Growth level (Reference, Low, or High). b. Discount Rate: To the change value, type in the desired Discount Rate.

c. Relative Price Elasticity: To change valu e, use the drop-down arrow and select the desired. d. Lifetime: To change value, type in the desired value that lies within the maximum lifetime indicated.

11A-24. Once the parameters have been set, click the “Set base case/Standards Case” button and define the efficiency distribution of the mark et, and the efficiency growth rate for both the base case and the standards case.

5. Once the distribution and the growth rate ha ve been set, click the “update” button to make your defined distribution effective.

6. The results are automatically updated and are reported in the summary table for each product class to the right of the “User Inputs” box.

11A-3