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 NATIOANL IMPACT ANALYSIS WORKSHEETS.........9-A-1 

9-A.4 BASIC INSTRUCTIONS FOR OPERATING THE NIA SPREADSHEETS .....9-A-1 

LIST OF TABLES 

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


9-A-i 

EE-2006-STD-0129 and EERE-2006-BT-STD-0129 COMMENT 32.2
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 ANOPR 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 of residential water heaters, 

direct heating equipment and pool heaters. 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_WH.xls Water Heater Products 

NIA_PH.xls Pool Heater 

NIA_DHE.xls DHE Products 

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

computer (PC) with a hardware configuration capable of running Windows NT/2000/XP. The 

Heating Products NIA spreadsheets require Microsoft Excel 2000 or later installed under the 

Windows operating system. 

9-A.3 DESCRIPTION OF NATIOANL 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 efficiency 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 

9-A-1 

EE-2006-STD-0129 and EERE-2006-BT-STD-0129 COMMENT 32.2
summary table for each product class and charts of national impacts for 

each product class. 

Base Case 

Consumption 

The Base Case Consumption sheet contains the base case consumption 

calculations. 

Products The Products sheets contain detailed calculations for the base case and 

the shipments and stock energy savings and net present value at each 

candidate standard level. 

Shipments Forecast	 The Shipments Summary 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 hew housing market 

segment. (Water Heater 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. 

(Water Heater NIA spreadsheet only.) 

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. (Water Heater 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 heating products. 

New Housing The New Housing Forecast sheet provides projected new housing 

Forecast construction completions and manufactured home placements. (Water 

Heater and Pool Heater NIA spreadsheets only.) 

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 

EE-2006-STD-0129 and EERE-2006-BT-STD-0129 COMMENT 32.2
9-A.4 BASIC INSTRUCTIONS FOR OPERATING THE NIA 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%. To change value, click on cell C5 and enterchange 

value (7% or 3%). 

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

desired year. 

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

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

High Economic Growth). 

d.	 Select Product: Set to “All Products”. To change this value use the drop-down 

arrow and select the desired option. (Not in Pool Heater NIA spreadsheet.) 

e.	 Fuel Switching: Set to “On”. To not account for fuel-switching, change this value 

to “Off” by using the drop-down arrow. (Water Heater NIA spreadsheet only.) 

f.	 Instantaneous Water Heater Market Share: Set to Reference Case. To change 

value, use the drop-down arrow and select the desired level (Reference Case, Low 

or High ). (Water Heater NIA spreadsheet only.) 

g.	 Efficiency Growth Rate: Set to Reference Case. To change value, use the dropdown arrow and select the desired level (Constant Efficiency, Low Rate of 

Efficiency Increase, Moderate Rate of Efficiency Increase, High Rate of 

Efficiency Increase ). (Water Heater NIA spreadsheet only.) 

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. 

9-A-3 

EE-2006-STD-0129 and EERE-2006-BT-STD-0129 COMMENT 32.2