APPENDIX 9-A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 


ENERGY SAVINGS SPREADSHEET MODEL 


TABLE OF CONTENTS
 

9-A.1 USER INSTRUCTIONS .......................................................................................9-A-1 


9-A.2 STARTUP..............................................................................................................9-A-1 


9-A.3 DESCRIPTION OF NATIONAL IMPACT ANALYSIS WORKSHEETS.........9-A-1 


9-A.4 BASIC INSTRUCTIONS FOR OPERATING THE NATIONAL IMPACT
 

ANALYSIS SPREADSHEETS.............................................................................9-A-3 


LIST OF TABLES 

Table 9-A.2.1 List of National Impact Analysis Spreadsheets .........................................9-A-1 


9-A-i 

EERE-2007-BT-STD-0010 COMMENT 20.3
 

 

APPENDIX 9-A. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL 


ENERGY SAVINGS SPREADSHEET MODEL 


9-A.1 USER INSTRUCTIONS 

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

Excel spreadsheets accessible on the Internet from DOE's Heating Products Rulemaking page: 

http://www.eere.energy.gov/buildings/appliance_standards/. From that page, follow the links to 

the NOPR phase and then to the Analytical Tools. 

9-A.2 STARTUP 

DOE named the spreadsheets for the product classes and subgroup analysis if applicable. 

The spreadsheets enable users to perform National Impact Analysis (NIA) of room air 

conditioners and clothes dryers. A separate spreadsheet exists for each of the products. Table 9­

A.2.1 lists all national impact analysis spreadsheets used in this analysis. 

Table 9-A.2.1 List of National Impact Analysis Spreadsheets 

Filename Description 

NIA_RAC.xls Room Air Conditioner Products 

NIA_CD.xls Clothes Dryer Products 

To examine the spreadsheets, DOE assumes that the user has access to a personal 

computer with a hardware configuration capable of running Windows NT/2000/XP. The Room 

Air Conditioner and Clothes Dryer NIA spreadsheets require Microsoft Excel 2000 or later 

installed under the Windows operating system. 

9-A.3 DESCRIPTION OF NATIONAL IMPACT ANALYSIS WORKSHEETS 

The NIA spreadsheets perform calculations to forecast the change in national energy use 

and net present value of financial impacts due to a revised energy conservation standard. The 

energy use and associated costs for a given standard are determined by first calculating the 

shipments and then by calculating the energy use and costs for all heating products shipped 

under that standard. The differences between the standards and base case can then be compared 

and the overall energy savings and net present values determined. The NIA spreadsheets consist 

of the following worksheets: 

Introduction The Introduction sheet contains a list and description of all worksheets 

used in the analysis. 

Flow Chart The Flow Chart sheet contains a diagram of the structure of the inputs 

and outputs used to derive the NIA. 

National Impacts The National Impacts Summary sheet contains user input selections, 

Summary source energy savings results matrix, net present value results matrix, a 

summary table for each product class and charts of national impacts for 

9-A-1 

EERE-2007-BT-STD-0010 COMMENT 20.3
 

 

 

 

 

 

 

 

 

 

 

 

each product class. 


Base Case 

Consumption 

The Base Case Consumption sheet contains the base case consumption 

calculations. 

NIA The NIA sheet contain detailed calculations for the base case and the 

shipments and stock energy savings and net present value at given 

candidate standard levels. 

Shipments Forecast	 The Shipments Forecast sheet contains a tabular summary and chart of 

the annual shipments forecasts for each product class at each trial 

standard level. 

New Housing The New Housing Market Share sheet contains the market share model 

Market Share calculations that determine the market shares for new housing market 

segment. (Clothes Dryer NIA spreadsheet only.) 

Historical Market The Historical Market Share Data sheet contains the market share model 

Share Data calculations that determine the market shares for each market segment. 

Efficiency Trends	 The Efficiency Trends sheet contains the efficiency trends model which 

captures the changing parameters due to changes in efficiency trends of 

equipment over time. (Room Air Conditioner NIA spreadsheet only.) 

LCC Inputs 	 The LCC Inputs sheet contains inputs from the LCC spreadsheet for each 

product class. 

Retirement The Retirement Function sheet calculates the lifetime expectancy 

Function distribution of room air conditioners and clothes dryers. 

New Housing The New Housing Forecast sheet provides projected new housing 

Forecast construction completions and manufactured home placements. 

Fuel Prices and Site The Fuel Prices and Site to Source sheet contains projected energy price 

to Source trends and site to source heat rates. 

Shipments Forecast The Shipments Forecast Charts sheets contains charts of product 

Charts shipments 

9-A-2 

EERE-2007-BT-STD-0010 COMMENT 20.3
9-A.4	 BASIC INSTRUCTIONS FOR OPERATING THE NATIONAL IMPACT 

ANALYSIS SPREADSHEETS 

Basic instructions for operating the NIA spreadsheets are as follows: 

Once the NIA spreadsheet file has been downloaded from the Web, open the file using 

Excel. Click “Enable Macro” when prompted and then click on the tab for the worksheet 

National Impacts Summary Analysis. 

1.	 Use Excel's View/Zoom commands at the top menu bar to change the size of the display 

to make it fit your monitor. 

2.	 The user can change the parameters under the title “National Impacts Summary”. The 

default parameters are: 

a.	 Discount Rate: Set to 7 percent. To change value, click on cell C5 and interchange 

value (7 percent or 3 percent). 

b.	 Current Year: Set to 2014. To change value, click on cell C6 and interchange to 

desired year. 

c.	 Economic Growth: Set to Reference Case. To change value, use the pull down 

menu and select the desired level (Reference Case, Low Economic Growth or 

High Economic Growth). 

In the case of Clothes Dryers, the results are automatically updated and are 

reported in the source energy savings matrix, net present value matrix, summary 

table for each product class and charts of national impacts for each product class. 

In the Room Air Conditioner spreadsheet, the user can visualize the automatically 

updated results for a given product class by using the pull down menu “select 

product class”. To see the results for the entire Room Air Conditioner market, the 

user needs to update the results tables by clicking on the button “Update all 

Results”. A macro will automatically generate the summary table results for all 

product classes. 

9-A-3 

EERE-2007-BT-STD-0010 COMMENT 20.3