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 G­ii** 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**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 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 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**