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-iAPPENDIX 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-1summary 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 ForecastThe 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 SiteThe Fuel Prices and Site to Source sheet contains projected energy price to Source trends and site to source heat rates. Shipments ForecastThe Shipments Forecast Charts sheets contains charts of product Charts shipments

9-A-29-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