### ,, -



### U.S. Department 

### of Energy



### Clothes Washer National Energy Savings Spreadsheet Instructions 

# /</;)

June 1999

The Clothes WasherNational Energy Savings Spreadsheet (NES) calculates the national energy, water and dollar savings from a clothes washer efficiency standard. The model uses input from the shipments model regarding washerpurchases and compares the energy use between a baseline scenario and the standard case. The Welcome worksheet is the main user interface for NES calculations. When the user clicks onthe Welcome worksheettab, it brings up a user interface that canberun for different standard levels and scenarios for energy price projection, waterprice projection, start year, and discount rate. Basic Operating Instructions: 1.. Once youhave downloaded the NES file from the Web, openthe file using Excel. Atthe bottom, click onthe tab for the worksheet labeled "Welcome." 2.. The screen will display two tables ("Energy Savings and Water Savings" and "Cost and NetPresent Value") and a chart ("Cost and Savings ofNewClothes Washers"). (Use Excel's "View/Zoom" commands to change the size ofthe display to make it fit your monitor.) 3.. To run different scenarios or standards cases, simply selectthe energy price projection, standard, water price projection, and the startyear from the appropriate list box. The result will be calculated immediately. 4.. The user may also input values for the discountrate and the annual escalation of horizontal axis machines inthe base case by directly typing the desired values into the appropriate input box, highlighted in yellow. Again, after the value is input (i.e. after you type the value andthen hit <Enter>), the result will be calculated immediately. Using these steps you canexplore the potential outcomes ofa range ofalternative assumptions.



### 1Frequently Asked Questions (FAQ) 'Vhat does the Clothes Washer NES Spreadsheet do? The clothes washerNES spreadsheetprovides anestimate ofthe national energy, water, and monetary savings ofdifferent clothes washer efficiency standards. The spreadsheet uses estimates offuture clothes washer sales and stock from the shipments model, andthe chosen standard level (change inunit energy efficiency) to estimate potential energy savings from the standard by fuel type. It also calculates the dollar value ofthese savings year-by-year. It estimates the amount of energy that will be saved at the source by considering generation, transmission and distribution losses. It also calculates the monetary savings that canresult from a standard and the net present value ofsuch savings. 'Vhat are the Worksheets in the Workbook? The worksheets inthe workbook are as follows: Welcome This worksheet is the main userpage. Itprovides four list boxes that allowthe userto choose a range ofscenarios, plus two additional input boxes (highlighted in yellow) where the user cantype in desired input values directly. The user can choose the standard level, growth projections for energy prices and waterprices, standard start year, discount rate, and the base case growth inmarket share ofhorizontal axis washers. Different elements ofthe national energy savings are illustrated, including total energy savings for each fuel type, the dollar value ofenergy and water savings, and the benefit/cost ratio for the standard case. 

### Utility This worksheet summarizes the site energy 

### (energy consumedat thepointof use, in contrast to thepointof supply) savings on an annual basis. Annual This worksheet shows the results ofthe NES calculation ona year-by-year basis. It presents the annual energy savings disaggregated by fuel type, and the annual calculation ofthe net savings in equipment and operating costs. Base Case The Base Case worksheet calculates the base case energy uses and monetary costs (i.e., what is projected to happen in the absence ofan efficiency standard). The sheet contains the base case estimates ofthe population ofwashers in each age category and in eachfuture year . Itthen

2uses this informationto calculate the base case energy consumption and operating cost for each foel type. Italso computes the operating and equipment costs for eachyear. Standard 

### Case Calculates the standard case energy uses andmonetary costs. The sheet contains the estimates ofthe population ofwashers in each age category and each forecast year for the standard case selected by the user onthe Welcome worksheet. Itthen uses this information to calculate the standard case energy consumption and operating cost for eachfuel type. Italso computes the operating and equipment costs for each year. Engineering This worksheet contains the data onprices, energy use, and water consumption for the clothes washers meeting different standard levels. Energy Price This worksheet contains the tables that provide the energy price data for different price projection scenarios. These scenarios include the Annual Energy Outlook (AEO) high-growth, low-growth and reference cases**(http://www.eia.doe~gov/oiaf/aeo99/homepage.html).** There is also an option for constant energy prices, and an estimate from the Gas Research Institute (GRI). Water Price This worksheet contains the price tables for the different waterprice scenarios. The high,

. medium and low waterprice scenarios correspond to annual marginal waterprice escalationrates of5.35%, 2.96%, and 0.46% respectively. These rates corresponded to the 80%, median, and 20% values for a database ofhistorical marginal waterprice escalation rates for the period of 1986 to 1998. The database ofhistorical waterprices was obtained from a survey ofwater utilities. Details ofthe survey methods and results will bereported in Technical Support Document: EnergyEfficiency Standards for Consumer Products: Clothes Washers. Shipments Summary This worksheetprovides the tables ofthe population ofclothes washers (in millions of units) for each age group, for each year, and for each standard level. These populations ofclothes washers are obtained from the clothes washer shipments model. The shipments forecast calculationbegins in 1953, in orderto calibrate the shipments model to the historical data

.. Saturation This worksheet contains tables ofthe relative market share for different fuel types for both



### 3water heaters and clothes dryers. For simplicity, it was asswned thatthe relative saturation ofthe different fuel types for waterheaters and clothes would remain constant at 1997 levels. Even thoughthere is no year-to-year change in fuel saturations inthe current version ofthe spreadsheet, having a table ofvalues allows an advanced userto include year-to-year fuel saturation changes for bothwater heaters and clothes dryers. Site2Srce The worksheet contains the conversion factors from energy at the point ofuse to source energy. These conversion factors account for losses such as those that occur during generation, transmission and distribution. Setup This worksheet contains the datathat represents the current scenario selected in the Vf elcome worksheet. These values change as the user selects different scenarios to calculate.

How does the user operate the spreadsheet? The user operates the spreadsheet by going to the Welcome worksheet and choosing the parameters and selections for the scenarios ofinterest. The possible scenarios include the energy and waterprice scenarios, the standard startyear, one of9 possible standard levels, the discount rate, andthe base case growth inthe market share ofhorizontal axis washers. The results will be displayed in the chart onthe Welcome worksheet and in the tables which detail changes in energy use and operating cost savings. \'\'hat kind ofoutput does the spreadsheet generate? The spreadsheetprovides output as charts, summary statistics, and detailed tables. Detailed tables ofannual energy savings are provided in the Annual worksheet, while summary figures and charts are provided onthe Welcome worksheet. \'\'hat does the chart entitled "Costs and Savings ofClothes Washers" illustrate? Foreachyear from the standard start date to 2030, the "Costs and Savings ofClothes ·washers" chart shows the additional cost (labeled "Price Change") to conswners to purchase the higher efficiency washers mandated bythe standard, vs. the amount saved by conswners in reduced energy and waterbills (labeled "Energy and Water Saving"). The net saving to conswners is the difference between the money saved in energy and waterbills minus the additional money spent onhigher efficiency washers. This net saving is shown as a red line .labeled "Net Saving" onthis chart.



### 4