APPENDIX F. USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET
 

TABLE OF CONTENTS
 

F.1 INTRODUCTION ..............................................................................................................F­1
 

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

LIST OF TABLES

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

`

F­i
 

 EERE-2007-BT-STD-0012 COMMENT 32
F­ii
 

 EERE-2007-BT-STD-0012 COMMENT 32
                

                           

                       

                     

                           

                        

                         

                      

         

         

                         

                              

                               

                             

                              

                           

           

                  

                         

                       

        

                         

               

                          

           

                                

                     

                       

             

                                 

                       

          

                                 

                           

                             

                 

                               

                             

                                 

                                 

   

APPENDIX F USER INSTRUCTIONS FOR NES AND NPV SPREADSHEET

F.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/packaged_ac_hp.html

The spreadsheet is called “PTAC­PTHP_NIA_Final.xls” and it enables the user to

perform NES analyses of up to four equipment classes of packaged terminal air conditioners

(PTACs) and packaged terminal heat pumps (PTHPs). Standard size PTAC and PTHP

equipment is further divided into two representative capacities, making a total of six

representative capacity of equipment. To execute the spreadsheet requires Microsoft Excel®

2003 or a later version.

F.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 conservation standard for PTAC and PTHP 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 PTAC and PTHP 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:

Table F.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 PTACs and PTHPs 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.

Summary of Results The summary of results contains user input selections and for the selected equipment

class a Summary table, Shipments graph, Cumulative Energy Savings and NPV

graph, and an Annual Non­Discounted Savings Trend plot, which also contains a

plot of discounted net savings by year.

Savings Summary (Hidden) 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., TSL 1­6, A).

Details_Save (Hidden) 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 (Hidden) A worksheet that keeps track of all surviving stock of PTAC and PTHP equipment

in a equipment class from the start year forward. Stock is updated for each year.

Initial Stock Details

(Hidden)

A worksheet that keeps track of all surviving stock of PTAC and PTHP equipment

in a equipment class from 2006 to the start year of the forecast. Stock is updated for

each year.

F­1
 

 EERE-2007-BT-STD-0012 COMMENT 32
      

     

   

                   

                       

        

       

         

       

                   

                             

                         

                           

                         

                           

  

                         

                             

               

                               

                         

                         

                                 

                 

                         

  

                     

                         

                         

                          

                        

                         

     

                           

             

                         

                          

                      

   

                     

             

                               

                     

         

                               

                   

                         

     

                               

                     

     

                                 

       

Table F.2.1 (cont’d)
 

Supplemental Table on

Shipments (Hidden)

The Supplemental Table on Shipments contains detailed forecasts of base case

shipments of PTACs and PTHPs by equipment class, capacity and efficiency level

for selected years

Shares Output 1, Shares

Output 2, Shares Output 3,

Shares Output 4 (Hidden)

Four worksheets that estimate percentage distribution shipments by efficiency level

and year of all equipment classes of PTAC and PTHP equipment from the start year

of the forecast forward. Each worksheet applies to a different type of business

Shares Processing (Hidden) Worksheet that performs the detailed calculations based on annualized cost to

estimate market shares of an equipment class of PTAC and PTHP equipment by

efficiency level in a business type based on risk preferences of purchasers for a

baseline

Input (Hidden) Worksheet that performs detailed calculations by risk preference class to estimate

annualized cost for a newly purchased unit of a equipment class of PTAC and PTHP

equipment by efficiency level in a business type.

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

annual electricity cost for units of PTAC and PTHP equipment, calculated by the

LCC model by equipment class, business type, and efficiency level at U.S. average

conditions

Details_ Ship (Hidden) 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 PTAC and PTHP

equipment

Initial Shipments Detail

(Hidden)

Calculates total shipments by efficiency level and market weighted­average

percentages of shipments by efficiency level of each equipment class of new PTAC

and PTHP equipment for baseline market conditions and up to 5 candidate standard

levels.

Shipments_Summary

(Hidden)

Contains estimates of shipments of an equipment class of PTAC and PTHP

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 (Hidden Contains equipment class percentages of overall PTAC and PTHP equipment

shipments.

Econ_Trends A worksheet that contains historical and projected economic values as well as

shipments data. This worksheet receives data from a separate forecast worksheet

called "Shipments Calculations."

Commercial Construction

(EIA)

Estimates of commercial building stock increases, decreases, and surviving stock by

year and building type from AEO 2006.

Marginal BTU Conversion

Rate

A worksheet that contains data on the marginal conversion rates from site electricity

consumption to primary (source) energy required to generate, transmit, and deliver

electricity to the end user

Post­2012 Shift (Hidden) A worksheet that contains the data and processing capability to shift the efficiency

mix of equipment in the absence of an efficiency standard.

CalcMktShift (Hidden) A worksheet that contains the capabilities to control the maximum technical

efficiency level considered

Equipment Parameters A worksheet that contains the economic, energy, and size parameters for PTAC and

PTHP 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 worksheets ­­ do

not modify this sheet.

F­2
 

 EERE-2007-BT-STD-0012 COMMENT 32
                     

                             

                                   

                              

             

                               

           

                             

      

                         

                

                            

                        

                                  

                             

     

                              

                     

                              

                                  

                           

                   

                           

                       

                         

                                

                 

                         

               

                                 

                         

                             

                       

                        

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 and Capacity: To change the value, select the menu box. A dropdown list appears. Select the desired equipment class.

b.	 Trial Standard Level: Uses Trial Standard Level to selects the efficiency level used in

the analysis and the non­discounted annual net impacts figure. The efficiency level

must be less than or equal to the Max Tech efficiency level. If a higher standard level

than Max Tech efficiency level 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

(usually Level 5). The Max Tech should be selected for the equipment class that was

analyzed in the LCC analysis. If a Max Tech level is selected that is beyond the Max

Tech level identified in the LCC analysis, the model will produce impacts for the

(extra) incorrect efficiency levels, but they will not be valid.

d.	 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

2008.

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

should be set to 2012 for the Final Rule.

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

menu pops up. Select the desired Discount Rate.

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.

F­3
 

 EERE-2007-BT-STD-0012 COMMENT 32
                                 

                       

                          

                          

             

                               

                            

                           

                         

                       

                         

                           

                               

                       

                              

             

                           

                           

                             

                                   

                         

                         

       

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­Output4. 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 0) and the trial standard levels corresponding to efficiency levels 1­5. All

analyses in the model are conducted using the efficiency levels from the LCC analysis,

but the results are mapped onto the corresponding trial standard 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 Efficiency Level, and then select an efficiency level from the drop­down list.

F­4
 

 EERE-2007-BT-STD-0012 COMMENT 32