APPENDIX G. USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET
 

TABLE OF CONTENTS
 

G.1 INTRODUCTION .......................................................................................................... G­1
 

G.2 USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET................................ G­1
 

LIST OF TABLES

Table G.2.1. Description of Tabs in NES and NPV Spreadsheet.............................................. G­1

`

G­i

EERE-2006-STD-0125 COMMENT 22
G­ii

EERE-2006-STD-0125 COMMENT 22
                

                           

                       

   

                   

                           

                     

         

         

                         

                                

                             

                         

                              

                           

                   

                  

   

   

             

                     

            

                   

                 

   

             

                 

                          

                 

                  

                     

                     

                       

                         

           

                     

                     

         

                           

                         

             

APPENDIX G USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET
 

G.1 INTRODUCTION

The results obtained in this analysis can be examined and reproduced using the Microsoft

Excel® spreadsheet available on the U.S. Department of Energy Building Technologies website

at: http://www.eere.energy.gov/buildings/appliance_standards/commercial_products.html.

The spreadsheet is called “BVM_nes_Version 4_08­12­2007.xls” and it enables the user

to perform NES analyses of two equipment classes and three different capacities of beverage

vending machine (BVM) equipment. To execute the spreadsheet requires Microsoft Excel®

2003 or a later version.

G.2 USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET

The NES spreadsheet performs calculations to forecast the change in national energy use

and net present value due to an energy efficiency standard for BVM equipment. 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 commercial refrigeration equipment shipped 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 NES spreadsheet or workbook

consists of the following worksheets as described in Table G.2.1.

Table G.2.1. Description of Tabs in NES and NPV Spreadsheet

Supplemental Table

on Shipments

The Supplemental Table on Shipments contains detailed forecasts

of base case shipments of BVMs by equipment class, capacity and

efficiency level for selected years.

Shipments The Shipments Table contains a summary of the shipments by

equipment class and capacity for selected years and cumulative

from 2012­2042.

Shipments­Weighted

Data

The Shipments­Weighted Data sheet contains calculated tables of

both input data and results from the spreadsheet.

Savings Summary A bookkeeping table used to store the results of the shipments and

energy savings calculations for an individual equipment class and

up to seven candidate standard levels (e.g., Levels 2­8).

Details_Save An accounting worksheet used to tally the energy and cost savings

year by year for an individual equipment class and standard level.

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 level energy use and cost.

Details_Stock A worksheet that keeps track of all surviving stock of BVM

equipment in a equipment class from the start year forward. Stock

is updated for each year.

Initial Stock Details A worksheet that keeps track of all surviving stock of BVM

equipment in a equipment class from 2006 to the start year of the

forecast. Stock is updated for each year.

G­1

EERE-2006-STD-0125 COMMENT 22
  

     

     

     

     

     

     

               

                   

                   

               

                   

                     

                     

              

               

                       

                   

   

                         

                   

                 

                 

                     

                   

           

                  

                   

               

                   

               

                   

                   

                  

                 

     

   

             

                   

                   

                    

             

                 

               

   

                 

               

               

                           

Table G.2.1. (contd)
 

Shares Output 1,

Shares Output 2,

Shares Output 3,

Shares Output 4,

Shares Output 5,

Shares Output 6

Six worksheets that estimate percentage distribution shipments by

efficiency level and year of all equipment classes of BVM

equipment from the start year of the forecast forward. Each

worksheet applies to a different type of business

Shares Processing Worksheet that performs the detailed calculations based on

annualized cost to estimate market shares of an equipment class of

BVM equipment by efficiency level in a business type based on

risk preferences of purchasers for a baseline

Input Worksheet that performs detailed calculations by risk preference

class to estimate annualized cost for a newly purchased unit of a

equipment class of BVM equipment by efficiency level in a

business type.

BVM Cost List Contains input data on installed cost (total price), repair and

maintenance cost, and annual electricity cost for units of BVM

equipment, calculated by the LCC model by equipment class,

business type, and efficiency level at U.S. average conditions.

Details_ Ship Calculates total shipments by efficiency level for an equipment

class by year, given a candidate standard level. Also contains

market weighted­average percentages of shipments by efficiency

level of each equipment class of new BVM equipment.

Initial Shipments

Detail

Calculates total shipments by efficiency level and market

weighted­average percentages of shipments by efficiency level of

each equipment class of new BVM equipment for baseline market

conditions and up to 5 candidate standard levels.

Shipments_Summary Contains estimates of shipments of an equipment class of BVM

equipment by efficiency level and year, given a candidate standard

level. Also contains estimates of total shipments of each

equipment class by year for each candidate standard level.

Base Product Market

Share Calcd

Worksheet performs calculations to estimate total market

shipments by equipment class and year in the base case.

Product Shares Contains equipment class percentages of overall BVM equipment

shipments.

Economic Trends A worksheet that contains historical and projected economic

values as well as shipments data.

Shipments

Background

Contains historical data and detailed forecast calculations to feed

the market size estimates in Economic Trends sheet.

Equipment

Parameters

A worksheet that contains the economic, energy, and size

parameters for BVM equipment and other equipment parameters

used to project survival and calibrate the model.

Labels This is used as an interface between user inputs and the rest of the

G­2

EERE-2006-STD-0125 COMMENT 22
                   

                               

                                   

                              

             

                                 

           

                               

        

                         

                      

                   

                          

                               

                             

     

                               

                     

                             

            

                             

                            

                            

                             

                       

                         

                              

                 

                         

               

                          

                          

                           

               

worksheets              ­­ do not modify this sheet.

Basic instructions for operating the NES spreadsheet are as follows:

1)	 Once the NES spreadsheet file has been downloaded from the Web, open the file using

Excel. You will be confronted with a dialog box as the file opens. You DO want to

Enable Macros (Select “Yes” when this option is presented.) At the bottom, click on the

tab for the worksheet Summary of Results.

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 gray box labeled “User defined

inputs”. The parameters are:

a.	 Equipment Class: To change the value, select the menu box. A drop­down list

appears. Select the desired equipment class. Many of the potential equipment

classes have no shipments; i.e. they are not “real.”

b.	 Std Level: Selects the standard level used in the non­discounted annual net

impacts figure. Must be less than or equal to the Max Tech level. If a higher

standard level than Max Tech is selected, no results will be available for the levels

above Max Tech

c.	 Max Tech: To change the value, select the Max Tech box . A drop­down menu

pops up. Select the desired type of maximum technologically feasible efficiency

level (Level 8). The Max Tech should be selected for the equipment class that

was analyzed in the LCC analysis.

d.	 Rate of Growth of BVM Market: This option allows a rapid sensitivity of the

overall growth rate in the size of the market. It multiplies the reference growth

rate by a ratio ranging from 0.50 to 1.50. The default value is 1.00.

e.	 Growth in Energy Prices: To the change value, select the Growth in Energy Prices

box. A drop­down menu pops up. Select the desired Growth level (Constant,

Reference, Low, or High). The scenarios refer to EIA projected rates from AEO

2007.

f.	 Standard First Year: This is the first year in which the standard will take effect.

This should be set to 2012 for the ANOPR.

g.	 Discount Rate: To the change value, select the Discount Rate box. A drop­down

menu pops up. Select the desired Discount Rate.

h.	 Market Share Assumptions: The user selects the shares that each equipment class

represents in the market. The shares are constant for the entire forecast period

since there is little data concerning how the market shares have changed or will

change. The shares must add to 100%

G­3

EERE-2006-STD-0125 COMMENT 22
                                 

                         

                             

                       

                     

                                 

                       

                            

                          

             

                               

                              

                       

                         

                           

                               

                       

                              

             

                           

                               

                         

                                   

                           

                       

4) Once the user parameters have been reset the model must be re­ run. To re­run the model

press the green “Update Values” button. Note: The output values are not correctly

updated until the “Update Values” button is pressed. To run all cases and update the

summary information in Sales­Weighted Data sheet, press the "Run All Cases" button.

The model will take about ten minutes to rerun all cases.

5) If a new set of LCC results has been loaded into the PTAC Cost List and Equipment

Parameters sheets, it will be necessary to recalculate the baseline equipment shipment

shares by efficiency level in sheets Output1­Output 6. To do this, press the “Shares

Processing” button. The shares automatically update, and it will not be necessary to

update again unless LCC input data change.

6) Tabular results are presented to the right of the “User defined inputs” box for the base

case (Level 1) and the Level 2 through Level 8 standards cases. Tabular results are

summarized as: 1) cumulative shipments, 2) percentage change in total shipments as

efficiency level increases (currently, this does not change), 3) present value of national

equipment cost savings in billions of dollars, 4) present value of national operating cost

savings in billions of dollars, 5) national net present value in billions of dollars, and 6)

cumulative national energy savings in quadrillion Btus. Results for all standards cases

energy savings are tabulated for two periods: 2012 to 2042, and 2010 to 2062. Net

present value results are tabulated for 2012­2062.

Graphical results are presented for the main tabular results. Two charts are provided for

the given model parameters: 1) shipments forecasts for the base case and all standards cases and

2) national energy savings and net present values for all the standards cases.

For a given set of user defined parameters, the user can also view the annual trend in the

non­discounted net impacts for an individual standard level. To view an efficiency level select

Std Level, and then select a standard level from the drop­down list.

G­4

EERE-2006-STD-0125 COMMENT 22