APPENDIX S. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL ENERGY SAVINGS SPREADSHEET MODEL
TABLE OF CONTENTS S.1 USER INSTRUCTIONS ................................................ S-1 S.1.1 Startup ........................................................ S-1 S. 1.2 Description of National Impact Analysis Worksheets .................... S-1 S.1.3 Basic Instructions for Operating the National Impact Analysis Spreadsheets . S-4 LIST OF TABLES Table S.1.1 List of NIA Spreadsheets .......................................... S-1



### APPENDIX S. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL ENERGY SAVINGS SPREADSHEET MODEL
TABLE OF CONTENTS S.l USER INSTRUCTIONS
................................................ S-l S.l.l Startup
........................................................ S-l S.1.2 Description ofNational Impact Analysis Worksheets
.................... S-l S.1.3 Basic Instructions for Operating the National Impact Analysis Spreadsheets
. S-4
LIST OF TABLES Table S.1.1 List ofNIA Spreadsheets
.......................................... S-l

S-iAPPENDIX S. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL ENERGY SAVINGS SPREADSHEET MODEL
S.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 Furnace and Boiler Rulemaking page: http://www.eere.energy.gov/buildings/appliance-standards/residential/fumaces_boilers.html. From that page, follow the links to the final rule and then to the Analytical Tools. S.1.1 Startup The spreadsheet called "NIA(Main)_XX.xls" enables the user to perform National Impact Analysis (NIA) for trial standard levels for residential furnace and boilers, while spreadsheets called "NIA(Regional)XX.xls" enables the user to perform regional NIA for non-weatherized gas furnaces. NIA spreadsheets labeled "rebound"include the rebound effect as described in Chapter 10 and are used to generate the National Energy Savings (NES) results, while NIA spreadsheets without the "rebound"label do not include the rebound effect and are used to generate the National Present Value (NPV) results. Table S. 1.1 lists all NIA spreadsheets used in this analysis. Table S.1.1 List of NIA Spreadsheets Filename Description NIA Alain Spreadsheets NIA(Main).xls Main Generates NPVresults (Ch. 10) NIA(Main)_rebound.xls Main Generates NES results (Ch. 10) NIA Regional Spreadsheets ( 5000 HDD & 6000 HDD ) for Non-weatherized Gas Furnaces NIA(Regional)_HDD5000.xls Generates regional NPV results (HDD5000) (Ch. 10) NIA(Regional)_HDD5000 rebound.xls Generates regional NES results (HDD5000) (Ch. 10) NIA(Regional)_HDD6000.xls Generates regional NPV results (HDD6000) (Ch. 10) NIA(Regional)_HDD6000 rebound.xls Generates regional NES results (HDD6000) (Ch. 10) To execute the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable of running Windows NT/2000/XP. To use the furnace and boiler NIA spreadsheets, the user requires Microsoft Excel® 2000 or later installed under the Windows operating system. S.1.2 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 efficiency standard. The energy use and associated costs for a given standard are determined by first calculating the shipments and then

S-1 

### APPENDIX S. USER INSTRUCTIONS FOR SHIPMENTS AND NATIONAL ENERGY SAVINGS SPREADSHEET MODEL
S.l 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 Furnace and Boiler Rulemaking page: http://www.eere.energy.gov /buildings/appliance _standards/residential/furnaces
_boilers.html. From that page, follow the links to the final rule and then to the Analytical Tools. 

### S.1.1 Startup The spreadsheet called "NIA(MainL XX.xls" enables the user to perform National Impact Analysis (NIA) fortrial standardlevels for residential furnace andboilers, while spreadsheets called "NIA(RegionaIL XX.xls" enables the user to perform regional NIA for non-weatherized gas furnaces. NIA spreadsheets labeled "rebound"include the rebound effect as described in Chapter 1 0 and are used to generate the National Energy Savings (NES) results, while NIA spreadsheets withoutthe "rebound"label do not include the rebound effect and are used to generate the National Present Value (NPV) results. Table S.1.1 lists all NIA spreadsheets used in this analysis. 

### T bI S 11 L· fNIA S

a e 

# .. 1St 0 

### ipread h t 

### s ee s Filename Description 

### NIA Main Spreadsheets NIA(Main).xls Main Generates NPVresults (Ch. 10) NIA(Main)Jebound.xls Main Generates NES results (Ch. 10) 

### NIA RegionalSpreadsheets (5000 HDD & 

### 6000 HDD)forNon-weatherized Gas Furnaces NIA(Regional)_HDDSOOO.xls Generates regional NPV results (HDDSOOO) (Ch. 10) NIA(RegionalL HDDSOOO_rebound.xls Generates regional NES results (HDDSOOO) (Ch. 10) NIA(Regional)_ HDD6000.xls Generates regional NPV results (HDD6000) (Ch. 10) NIA(Regional) HDD6000 rebound.xls Generates regional NES results (HDD6000) (Ch. 10) To execute the spreadsheet, the Department assumes that the user has access to a PC with a hardware configuration capable ofrunningWindows 

### NT/2000IXP. Touse the furnace and boiler NIA spreadsheets, the user requires Microsoft Excel® 2000 or later installed under the Windows operating system. 

### S.1.2 Description ofNational ImpactAnalysis Worksheets TheNIA spreadsheetsperformcalculationsto forecastthe change innational energyuse and net present value offinancial impacts due to a revised energy efficiency standard. The energy use and associated costs for a given standard are determinedby first calculatingthe shipments and then
S-1the energy use and costs for all furnace and boilers 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: National Impacts The National Impacts Summary sheet contains user input selections, source Summary energy savings results matrix, net present value results matrix, a summary

table for each product class and charts of national impacts for each product class. Shipments Summary Flow Chart
NIA Gas Furnace - NW
NIA Gas Furnace - W
NIA Gas Furnace - MH
NIA Oil Furnace

NIA Gas Boiler

NIA Oil Boiler

Base Case Shipments The Shipments Summary sheet contains a tabular summary and chart of the

annual shipments forecasts for each product class at each trial standard level. The Flow Chart sheet contains a diagram of the structure of the inputs and outputs used to derive the NIA. The NIA Gas Furnace - NW sheet contains non-weatherized gas furnace data calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Gas Furnace - W sheet contains weatherized gas furnace data calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Gas Furnace - MH sheet contains mobile home gas furnace data calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Oil Furnace sheet contains oil furnace calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Gas Boiler sheet contains gas boiler calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Oil Boiler sheet contains oil boiler calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The Base Case Shipments sheet contains data for shipments for each product class. It also includes calculations of replacements, conversions, efficiency upgrades, central gas heating retrofit for non-weatherized gas furnaces, percentage of shipments which are to existing homes for each product class, new housing, modeled new construction installations, modeled shipments -
S-2 the energy use and costs for all furnace and boilers 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 ofthe following worksheets: National Impacts Summary
Shipments Summary Flow Chart
NIAGas Furnace-NW
NIA Gas Furnace-W
NIAGas Furnace-MH
NIA OilFurnace

NIA Gas Boiler

NIA Oil Boiler

BaseCase Shipments The National Impacts Summary sheet contains user input selections, source energy savings results matrix, net present value results matrix, a summary table for each product class and charts ofnational impacts for each product class. The Shipments Summary sheet contains a tabular summary and chart ofthe annual shipments forecasts for eachproduct class at eachtrial standard level. The Flow Chart sheet contains a diagram ofthe structure ofthe inputs and outputs used to derive the NIA. TheNIAGas Furnace

- NWsheetcontains non-weatherized gas furnace data calculations for thebasecase andthe shipments andstockenergy savings and net present value at each trial standard level. The NIA Gas Furnace - W sheet contains weatherized gas furnace data calculations for thebasecase andthe shipments and stockenergy savings and netpresent value at each trial standard level. The NIA Gas Furnace

- MH sheet contains mobile horne gas furnace data calculations forthebasecase andthe shipments and stockenergy savings and net present value at each trial standard level. TheNIA OilFurnace sheetcontains oil furnace calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Gas Boiler sheet contains gas boiler calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The NIA Oil Boiler sheet contains oil boiler calculations for the base case and the shipments and stock energy savings and net present value at each trial standard level. The Base Case Shipments sheetcontains data for shipments for each product class. Italso includes calculations of replacements, conversions, efficiency upgrades, central gas heating retrofit for non-weatherized gas furnaces, percentage ofshipments which are to existing homes for eachproduct class, new housing, modeled new construction installations, modeled shipments

- 8-2Change in

Shipments Regional Housing and Fuel Price New Housing Market Share Market Share Model Historic Market Shares Data LCC Inputs
Retirement Function New Housing Forecast Fuel Prices Heat Rates Market Shift Heating Load Price Indices
Chart GF Shipments Chart GF Market Share sum of replacements, conversions and new housing and oil replacements less

conversions for both furnaces and boilers. The Change in Shipments sheet contains the projected change in shipments from standards for non-weatherized gas furnaces and for mobile home furnaces at trail standard efficiency levels. The Regional Housing and Fuel Price sheet is included in the regional NIA spreadsheets only. It contains the housing and fuel price regional breakdown. The New Housing Market Share sheet contains new housing market shares data for single and multi-family homes and mobile homes. The Market Share Model sheet contains the calculations that determine the market share model elasticities. The Historic Market Shares Data sheet contains data of historic market shares in new homes. The LCC Inputs sheet contains inputs from the LCC spreadsheet for each product class. The Retirement Function sheet calculates the lifetime distribution of furnaces and boilers. The New Housing Forecast sheet provides projected new housing construction completions and manufactured home placements. The Fuel Prices and Heat Rates sheet contains projected energy price trends and heat rates. The Market Shift Heating Load sheet contains the heating load ofhouses that shifted away from gas due to new standards. The Price Indices sheet contains equipment and energy price indices used in the determination of price elasticities for market share forecasts. The Chart GF Shipments sheet contains a chart of gas furnace shipment components. The Chart GF Market Share sheet contains a chart of fraction gas versus electric equipment for new households with central heating.

S-3 

### Change in Shipments Regional Housing and Fuel Price New Housing Market Share Market Share Model Historic Market Shares Data LCC Inputs
Retirement Function New Housing Forecast FuelPrices Heat Rates MarketShift Heating Load Price Indices
Chart GF Shipments Chart GF Market Share sumofreplacements, conversions and newhousing and oilreplacements less conversions for both furnaces and boilers. The Change in Shipments sheet contains the projected change in shipments from standards for non-weatherized gas furnaces and for mobile home furnaces at trail standard efficiency levels. The Regional Housing and Fuel Price sheet is included in the regional NIA spreadsheets only. It 

### contains the housing and fuel price regional breakdown. The New Housing Market Share sheet contains new housing market shares data for single and multi-family homes and mobile homes. The Market Share Model sheet contains the calculations that determine the market share model elasticities. The Historic Market Shares Data sheet contains data of historic market shares in new homes. The LCC Inputs sheet contains inputs from the LCC spreadsheet for each product class. TheRetirementFunction sheetcalculatesthelifetime distribution offurnaces and boilers. The New Housing Forecast sheet provides projected new housing construction completions and manufactured home placements. The Fuel Prices and Heat Rates sheet contains projected energy price trends and heat rates. TheMarket ShiftHeatingLoad sheetcontainstheheating load ofhouses that shifted away from gas due to new standards. The Price Indices sheet contains equipment and energyprice indices used in the determination ofprice elasticities for market share forecasts. The Chart OF Shipments sheet contains a chart of gas furnace shipment components. The Chart OF Market Share sheet contains a chart offraction gas versus electric equipment for new households with central heating.

S-3Chart NWGF The Chart NWGF Financial Impacts sheet contains charts of financial

Financial Impacts impacts at each trial standard level. S.1.3 Basic Instructions for Operating the National Impact Analysis Spreadsheets Basic instructions for operating the NIA spreadsheets are as follows: 1. 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. 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 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 enter value (7% or 3%). b. Current Year: Set to 2007. To change value, click on cell C6 and enter 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. Weatherized Gas Furnace Stainless Steel Heat Exchanger Cost Option: Set to "Low". To change this value use the drop-down arrow and select the desired cost option (Low or High). e. Gas Boiler Draft Inducer Cost Option: Set to "Low". To change this value use the drop

-down arrow and select the desired cost option (Low or High). f. Regional Spreadsheets Region Selection: Set to "Cold States". To change this value use the drop-down arrow and select the desired option (Cold States or Warm States). 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. Chart NWGF The Chart NWGF Financial Impacts sheet contains charts offinancial Financial Impacts impacts at each trial standard level.
S.1.3 Basic Instructions for Operating the National Impact Analysis Spreadsheets Basic instructions for operating the NIA spreadsheets are as follows: 1. 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. 2. Use Excel's® View/Zoom commands at the top menubarto change the size ofthe displayto make it fit your monitor. 3. The user can change the parameters under the title "National Impacts Summary". The default parameters are: a. Discount Rate: Setto 7%. To change value, click on cell C5 and enter value (7% or 3%). b. Current Year: Setto 2007. To change value, clickon cell C6 and enter desiredyear.
c. Economic Growth: Set to Reference Case. To change value, use the drop-down arrow and select the desired level (Reference Case, LowEconomic Growth or High Economic Growth). d. WeatherizedGas Furnace Stainless SteelHeatExchangerCostOption: Setto "Low". To change this value use the drop-down arrow and select the desired cost option (Low or High).
e. Gas Boiler Draft Inducer Cost Option: Set to "Low". To change this value use the drop-down arrow and select the desired cost option (Low or High). f. Regional Spreadsheets Region Selection: Setto "Cold States". To changethis value use the drop-down arrow and selectthe desired option (Cold States orWarm States). The results are automaticallyupdated and are reported in the source energy savings matrix, netpresentvaluematrix, summarytable for eachproductclass andcharts ofnationalimpacts for each product class.

8-4