# TOSELECT: EnergyPriceForecast click EnergyPrce andalistofoptionswillappear Forecast StartYear click Start andentertheyearforstandards tostart SpecifyWaterHeater click WaterHeater& andDryerFuelType DryerChoice
ChooseDesignOptionforBase click B Choose DesignOptionforStandard click tandard

ASSUMPTIONS: RecoveryEfficiency ElectricWater Heater 

# r GasWaterHeater OilWaterHeater TemperatureDifferenceforHotWater l degF kWh requiredtoheatonegallon ofwater 

# i '

# kWh NumberofWasherCyclesperYear cycles

### %-11U=IGirjirmll*p~~i~~ro1T~,'vx. Cmmu l ,5.,~:mz*~.~.'~.* 5s ae'V

%

Improv. Cumul. 

### over Variable Retail Hot Level Option Baseline Mnf.Cost Price Water WaterHeat Machine Dryer Water (1995$) (1995$) (1995$) (gal) (kWh) (kWh) (kWh) (gal) 

## SiSRB~iasehniii^) " m 3 

### la 0+50%RMC 7.0% $4.81 $391 8.63 1.554 0.226 1.295 38.92 4a la+40%RMC 12.8% $12.64 $405 8.63 1.554 0.234 1.097 38.92 6a 4a+ ImprovedFill 16.4% $24.17 $424 7.98 1.436 0.232 1.097 36.77 5a 4a+ AutoFill+ TCMV 19.3% $49.41 $467 7.44 1.339 0.232 1.097 35.23
2c lb+Horz.AxiswlRecirc. 31.9% $80.06 $520 2.06 0.371 0.202 1.533 21.78 3b lb+50%RMC 37.3% $84.71 $528 2.56 0.461 0.204 1.295 25.73 3c 2c+50%RMC 39.2% $87.99 $533 2.06 0.371 0.213 1.295 21.78 6b 3b+40%RMC 43.5% $91.61 $540 2.56 0.461 0.209 1.097 25.73 4c 3c+40%RMC 45.5% $94.89 $545 2.06 0.371 0.218 1.097 21.78
Most Min Likely Max ManufacturerVariableMarkupFactor 1.00. 1.23 1.46
RetailerVariableMarkupFactor ', 130 139 1.48* h

0 AE097 Year Year riSMsWOO Year 2 GR97 3 GR196 4 1996 Constant cent/kWh $/MMBtu /MMBtu cent/kWh $/MMBtu S/MMBtu cent/kWh /MMBtu S/MMBtu 5 2000-2% 6 2000-4% % ClangeperYear % ChangeperYear % ChangeperYear

AE097 GR197 GR196 1996 Constant | 2000-2% 2000-4% Elec Gas il ec Gas Oil Elec Gas Oil Ele Gas Oi Elec Gas Oi Ele Gas Oil Ele Gas Oil cent/kWh $/MMBtu S/MMBtu cent/kWh S/MMBtu $/MMBu cen/kWh /MMBtu /MMBu cnkWh /MMBtu S/MMBtu cnt/kWh S/MMBtu $/MMBtu cent/kWh $tMMBtu S/MMBtu 1995 8.42 6.01 6.24 8.32 5.97 6.24 8.32 6.56 6.24 1996 8.17 5.92 6.80 8.22 5.97 6.80 8.23 6.57 6.80 1997 8.13 5.60 6.73 8.12 5.98 6.73 8.14 6.58 6.73 1998 8.20 5.65 6.93 8.02 5.99 6.93 8.05 6.59 6.93 1999 8.25 5.65 7.02 7.91 5.99 7.02 7.96 6.61 7.02 2000 8.22 5.63 7.03 7.81 6.00 7.03 7.87 6.62 7.03 9.00 8.22 7.00 8.22 7.00 6.00 8.22 8.22 2001 8.24 5.60 7.09 7.72 5.93 7.09 7.69 6.56 *7.09 9.00 8.22 7.00 7.97 6.86 5.82 7.81 7.81 2002 8.18 5.59 7.14 7.63 5.86 7.14 7.51 6.51 7.14 9.00 8.22 7.00 7.73 6.72 5.65 8.22 7.42 7.42 2003 8.14 5.58 7.19 7.55 5.79 7.19 7.33 6.46 7.19 9.00 8.22 7.00 7.50 6.59 5.48 7.89 7.05 7.05 2004 8.05 5.54 7.29 7.46 5.72 7.29 7.15 6.40 7.29 9.00 8.22 7.00 7.28 6.46 5.31 7.58 6.70 6.70 2005 8.02 5.49 7.28 7.37 5.65 7.28 6.97 6.35 7.28 9.00 8.22 7.00 7.06 6.33 5.15 7.27 6.36 6.36 2006 7.99 5.45 7.37 7.25 5.58 7.37 6.85 6.28 7.37 9.00 8.22 7.00 6.85 6.20 5.00 6.98 6.04 6.04 2007 7.94 5.41 7.36 7.12 5.52 7.36 6.73 6.22 7.36 9.00 8.22 7.00 6.64 6.08 4.85 6.70 5.74 5.74 2008 7.89 5.36 7.35 6.99 5.45 7.35 6.62 6.16 7.35 9.00 8.22 7.00 6.44 5.96 4.70 6.43 5.45 5.45 2009 7.86 5.33 7.45 6.87 5.38 7.45 6.50 6.09 7.45 9.00 8.22 7.00

## ShipmentsandElectricityConsumption ofNewClothesWashers(BaseCase)

assumes98%baselineand2% horizontalaxisin1996,with0.5%increaseinhorizontalaxiseach yearthereafter.


### I1i..(J!NA£her p:r,.UitlnergeUle and~,peratsng~ostK.! Total New Surviving Unit Hot WaterH. Dryer Motor Water Annual Year Shipment Units Price Water (Elec) (Elec) Energy Use lec Gas Oil Al Fuel* Op.Cost Energy* million million (1995$) ga/cycle kWh kWh kWh gal/cycle kWh MMBtu MMBtu MMBtu (1995$) (Quad) 1998 6.33 6.33 $383 8.45 1.521 1.533 0.219 3852 764 2.13 0.12 11.03 $75.6 0.07 1999 6.44 12.77 $383 8.42 1.516 1.533 0.219 38.46 763 2.13 0.12 11.02 $75.9 0.14 2000 6.55 19.32 $383 8.39 1.510 1.533 0.219 38.39 762 2.12 0.11 11.00 $755 0.21 2001 6.70 26.02 $383 8.36 1.505 1.533 0.219 38.33 761 2.12 0.11 10.99 $755 0.29 2002 6.80 32.82 $383 8.33 1.499 1.533 0.219 38.26 761 2.11 0.11 10.97 $75.0 0.36 2003 6.90 39.72 $383 8.30 1.494 1.533 0.219 38.19 760 2.11 0.11 10.96 $74.5 0.44 2004 7.00 46.72 $383 8.27 1.488 1.533 0.218 38.13 759 2.10 0.11 10.94 $73.7 0.51 2005 7.10 53.82 $383 8.24 1.483 1.533 0.218 38.06 758 2.09 0.11 10.92 $73.2 0.59 2006 7.20 61.02 $383 8.21 1.477 1.533 0.218 38.00 757 2.09 0.11 10.91 $72.8 0.67 2007 7.26 68.28 $383 8.17 1.472 1.533 0.218 37.93 756 2.08 0.11 10.89 72.2 0.75 2008 7.32 75.60 $383 8.14 1.467 1.533 0.218 37.86 755 2.08 0.11 10.88 $71.7 0.83 2009 7.37 82.97 $383 8.11 1.461 1.533 0.218 37.80 755 2.07 0.11 10.86 $71.3 0.91 2010 7.45 8954 $383 8.08 1.456 1.533 0.218 37.73 754 2.07 0.11 10.85 $70.7 0.98 2011 7.54 94.78 $383 8.05 1.450 1.533 0.217 37.67 753 2.06 0.11 10.83 $69.8 104 2012 7.65 98.50 $383 8.02 1.445 1.533 0.217 37.60 752 2.05 0.11 10.81 $69.0 1.07 2013 7.73 100.83 $383 7.99 1.439 1.533 0.217 37.54 751 2.05 0.11 10.80 $68.2 1.10 2014 7.80 102.25 $383 7.96 1.434 1.533 0.217 37.47 750 2.04 0.11 10.78 $68.1 1.11 2015 7.86 103.44 $383 7.93 1.428 1.533 0.217 37.40 750 2.04 0.11 10.77 $68.5 1.12 2016 7.95 104.61 $383 7.90 1.423 1.533 0.217 37.34 749 2.03 (.11 10.75 $68.0 1.14 2017 8.05 105.76 $383 7.87 1.417 1.533 0.217 37.27 748 2.03 0.11 10.73 $67.6 1.15 2018 8.15 106.92 $383 7.84 1.412 1.533 0.216 37.21 747 2.02 0.11 10.72, $67.2 1.16 2019 8.25 108.07 $383 7.81 1.406 1.533 0.216 37.14 746 2.01 0.11 10.70 $66.7 1.17 2020 8.34 109.24 $383 7.78 1.401 1.533 0.216 37.07 745 2.01 0.11 10.69 $66.3 1.18 2021 8.44 110.43 383 7.75 1.396 1.533 0.216 37.01 745 2.00 0.11 10.67 S65.9 1.19 2022 853 111.65 $383 7.72 1.390 1.533 0.216 36.94 744 2.00 0.11 10.66 $65.5 1.20 2023 8.63 112.90 $383 7.69 1.385 1.533 0.216 36.88 743 1.99 0.11 10.64 $65.1 1.21 2024 8.72 114.17 $383 7.66 1.379 1.533 0.216 36.81 742 1.99 0.10 10.62 $64.7 1.22 2025 8.82 115.45 $383 7.63 1.374 1.533 0.216 36.74 741 1.98 0.10 10.61 $64.3 1.24 2026 8.92 116.74 $383 7.60 1.368 1.533

. 0.215 36.68 740 1.97 0.10 10.59 $63.8 1.25 2027 9.01 118.04 $383 7.57 1.363 1.533 0.215 36.61 740 1.97 0.10 10.58 $63.4 1.26 2028 9.11 119.36 $383 7.54 1.357 1.533 0.215 3655 739 1.96 0.10 10.56 $63.0 1.27 2029 9.21 120.69 $383 7.51 1.352 1.533 0.215 36.48 738 1.96 0.10 1055 $62.6 1.28 2030 9.31 122.05 $383 7.48 1.346 1.533 0.215 36.41 737 1.95 0.10 10.53 $62.2 1.30

*Energy expressedassourceenergy Temperaturedifference ofinlet/outletwaterofwaterheater 75degree HeatcontentofIgallonofwaterthrough IdegreeF 0.0024 kWh **

Energyuseisbasedonassumptionsof HeatcontentofIgallonofhotwaterheatedbywater heater 0.18kWh waterheatersaturationsandrecovery Numberofcyclesperyearforclotheswasher 392cycles efficienciesbyfueltype(seeSaturation Sheet).7I Shipmentsand ElectricityConsumptionofNewClothesWasher

-StandardsCase YearofStandards Dlscu Ratu = 7% to Year 1995
$hlpX

# ~ ~~~~ e~al Ce dEl Ted Ale T-d NaV SeeMntig Ifolk 0 r3Wf fH. &re MotW,tr Wat,1tŽljlA-4A Wat.Han.lldU,.

. Annual Anneal CsL flal PFelCen, Uin Eq1ip. Dfioea Y, IShipme Ut* Prie Watt (Ele) (flel) (Eto ) flat Fle Op AlFP O.Cot E.nSerg S sSl S nV · Op.Ca Saeng Pre CEst Fanr

- ( 5) I -cyde kWh kWh kW/h g-/LSde kWh MMBR MMBi. MMBee (1995S) (Quad) 3 ) ( lQua)) (1995$) ilns (00955s) Thia$ 1998 6.3 6.3 $33 8,45 .521 3IJ] 0.319 332 764 2.13 0,12 11.0. $75.6 0.07 0.00 0.00 Sao 00 $0 0.0 083 I999 6.441 I.77 133 4 1.s16 1.33 0219 3146 76 2.13 0.1 I.0lo $75.9 0.14 0.00 a0.00 0 0.0 S0 0 0.76 m 6.J3 19.31 $96 256 0.461 1.7 0.193 25.73 471 0.17 a0 6.32 143.9 011 003 003 31.6 0,21 23 0.1 2002 670 6.0 $966 6 0461 1.097 6193 23.73 71 0.1 604$ 6.2 $44.0 0 a22 06 0.09 $31. 0,42 1213 1.43 0.6 2002 6.80 322 6 2.56 0.461 1.097 0.193 23,73 471 6 004 6,2 13.1 27 09 19 $313 0.63 $3213 1.4 0.62 2o03 6.90 39.7. $96 2.3 0.461 1.97 0.193 2373 471 o. 004 6.3 $43.3 031 0.13 01 S31.0 0.5 $13 1.47 0.1 200 7.00 46. 72 96 1236 0.461 1.097 0.193 25.73 4 71 0 0 62' $43.0 036 16 0 473 $306 I.06 $213 1.49 0.34 200 7.10 53J

. 9 6 2.56 0.461 1.097 193 25.73 471 0,87 0. 6.3 $412.8 40 1 al 66 $3064 1.25 $213 I.51 0l1 006 7.20 61.80 $16 2.'56 0.461 1.09 0.193 2.73 471 o. 7 0- 4 6.32 $2.7 0435 5 U 6$32 2.19 213 1.53 a0.4 200 7 .26 61.21 59 6 06461 1,09 0193 25.3 47 1 0.7 0.04 6.32 $42,42 0.9 6 1.14 $.1 1.711

. 213 IJ 0.44 7-32 73.50 $596 3.36 0.461 .09 0.193 25.73 47 037 1

.2 $42.3 054 0. 29 .43 296 1.93 $213 1.36 041 9 7J37 2.9 3596 1236 0.461 1.097 0.193 2.73 471 0 a7 004 6J2 $41.9 0.1 032 1.76 129.3 214 $313 1 .7 039 2 70 .45 85.54 $596 2.1 6 0,461 1.97 6.193 2.73 471 0.73 004 62 $41.7 0.62 0.oJ6

. : S29.0 2.36 8323 1.59 0.6 2011 7.34 94.4 S596 236 0461 1.9 0.93 25.73 471 6017n 04 6 $41.2 0.64 039 .51 $2.6 .5 4 1 213 61 0.34 2012 7.63 91.0 $596 2.56 04. 1.097 0.193 25.73 471 017 004 6.32 $407 0.65 0. 2.93 $M22 2.76 $313 1.63 03 213 7.73 100. 96 2.56 0,461 1.07 093 25.73 471 0.87 04 6,32 $401 0.6 45 37 27.9 290 $213 65 0 2014 7.M8 I0333 $59 26 0.461 1.097 193 73 471 0. a 04 632 $40 65 0 46 .3 $27. 2.99 $213 1.66 0,2 015 7.186 103.4 596 236 0.461 1.097 0193 25.73 471 0,T 0.04, 6. $4M6 65 0 7 4.30 $273 3.03 $213 1.67 036 2016 .7.9 104,.61 5 $90 36 0.461 .097 0.193 25.73 471 o. 00 6.32 $404 4047 4.8 $37.6 3.0 .$213 1.69 0. |2017 .0 10,76 $396 2.6 0.461 .09 0.193 .73 4 71 0. 004 6.32 $40 2 067 4 3.26 $27 .4 3.0 $213 1.71 0 20151 8.15 10.92 $39 Z-6 0.461 .097 0,193 25.73 471 0.87 0.04 602 M$40 06 4 .74 $ 27.2 3.063 S213 1.73 0.21 -2019 .2 1.07 $3 2369+250.461 1.097 0.193 25.73 471 0.7 004 .2 $39. 06 049 6.22 $6.9 3.07 213 1.76

. 020 8 % 109624 $3960 26 0461 1.097 0193 25.73 471 07 04 62 $9.6 069 49 6.71 $ I3,07 213 1.71 0. 21 8.44 110643 $396 .6 0.461 1.097 0.193 25.r3 471 0.7 0.04 63 $9.4 0.70 049 2 $26 3. 5213 1,80 017 203

. 103 111263 5396 356 06461 I.97 0193 5.-73 471 7 a 0 4 6.3 S39.2 071 0,50 7.70 $26 3.09 $213 1.82 0.16 2033 .63 112.90 $359 .6 ,461 1.097 0193 25.73 471 08 004 6.2 $39.0 0.71 .503 30 I1 3.10 $213 1,14 0.15 204 1.72 114.171 396 2.6 0461 1.097 193 25.73 471 01 0.04 6.32 $36.8 0.7 0J0 6.70 25..8 310 11$21 1.S 6014 233 1.182 115.4. 5 S6 $ 6 0.461 1.097 0193 25.73 471 .87 0.04 6.32 531.6 0.73 01 9.1 $22.6 3.11 $2131 .88 13 206 1.92 11674 $396 26 461 19 :73 41 .97 93 .3 4 04 6.3 $38.4 0.74 0.31 9.72 $3.4 3.13 $213 1.90 0 027 9.01 .04 $596 2.56 0,461 1.097 0193 25.73 471 .0.17 .04 623 $331- 2 7 051 03 $2 2 3.2.14 S213 .97 202 9.11 119.36 596 2.36 0.461 1.97 193 25.73 471 an7 04 632 $31.0 075 03 10,75 $32.0 3.15 $213 1.94 0.11 E .9 1 9 12069 $596 .56 0.461 1.097 0193 .33 73 2 07 60.4 62 $37.9 0.76 0. a I

. 11. 1 . 3.16 $13 1.96 00 2036 9.33 121.30 $396 3.36 0.461 1.097 193 3.73 47102 0.7 66M8 6.32 $37.7 0.77 0653 21.80 $62436 317 213 1.9 0 609 2039 $36 2193 16

37 ?$.e4.6 08 3 0.03

S3 .m6 013004 .041 n W ,4.6 02 0.03 06 e e yf.1Iee See.tie Shea) N h , 

## Z $6 24 6 03, $2466 2.61 63

$74..620-6 600 M2s4 $246 09. o.03 3029 $78. 63I.0 0 o.0

33631 $376 668 604 3043 $76 0-.7 00. 2048 $36,6 6o2 04 3353 83 M46 0.04 o68 3046 $2.66 0.020630

2090 6346 am 603

205 i 4.6 0.90 002

Sf $3 624 .00 0.02

ygg IZ%46eet~ 44~1,hns g~~39l~

## Saturation


# ASSUMPTIONS: WaterHeaterandDryerSaturationsbyFuelType, WaterHeaterRecovery Efficiencies byFuelType

Year elec gas oil elec gas elec gas oil

1998 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 1999 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2000 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2001 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2002 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2003 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2004 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2005 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2006 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2007 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2008 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2009 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2010 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2011 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2012 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2013 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2014 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2015 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2016 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2017 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2018 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2019 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2020 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2021 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2022 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2023 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2024 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2025 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2026 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2027 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2028 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2029 36.7% 58.7% 4.6% 76.4% 23.6% 100% 75% 81% 2030 36.7% 58.7% 4.6% 1 76.4% 23.6% 100% 75% 81%

Page 5

## Fuel Price

Elec Gas Oil cent/kWh $/MMBtu $/MMBtu 1995 8.42 6.01 6.24 1996 8.17 5.92 6.80 1997 8.13 5.60 6.73 1998 8.20 5.65 6.93 1999 8.25 5.65 7.02 2000 8.22 5.63 7.03 2001 8.24 5.60 7.09 2002 8.18 5.59 7.14 2003 8.14 5.58 7.19 2004 8.05 5.54 7.29 2005 8.02 5.49 7.28 2006 7.99 5.45 7.37 2007 7.94 5.41 7.36 2008 7.89 5.36 7.35 2009 7.86 5.33 7.45 2010 7.81 5.27 7.45 2011 7.72 5.24 7.38 2012 7.62 5.21 7.38 2013 7.54 5.18 7.35 2014 7.54 5.19 7.36 2015 7.60 5.18 7.33 2016 2017.024.967.01 2018.024.967.01 2019 2020.024.967.01 

## 2021.024.96 

# 7.0 2022 2023



## 202436 7.024.967.01 2025 2026 2027 2028 

## 2029 2030 

## 2031 7.02 4.96 7.01 2032 7.02 4.96 7.01 2033 7.02 4.96 7.01 2034 7.02 4.96 7.01 2035 7.02 4.96 7.01 2036 7.02 4.96 7.01

Page 6

## Fuel Price

2037 7.02 4.96 7.01 2038 7.02 4.96 7.01 2039 7.02 4.96 7.01 2040 7.02 4.96 7.01 2041 7.02 4.96 7.01 2042 7.02 4.96 7.01 2043 7.02 4.96 7.01 2044 7.02 4.96 7.01 2045 7.02 4.96 7.01 2046 7.02 4.96 7.01 2047 7.02 4.96 7.01 2048 7.02 4.96 7.01 2049 7.02 4.96 7.01 2050 7.02 4.96 7.01 2051 7.02 4.96 7.01 2052 7.02 4.96 7.01 2053 7.02 4.96 7.01 2054 7.02 4.96 7.01 2055 7.02 4.96 7.01

Page 7

## Water Price

WaterPrice ($/1000gal) 1995 Io a fromAlDietemannofSeattleWater 1996 1997 2.84 1998 284 1999 20000 2001 284 20024 2003 2004 :2005 2!006 2

2007 2.84 2008 284 203

09 '2012

2016 2017 

## 2018 284 2019 2020

2021 

## 2023 2024

, 

# . 2025 2026 2027 :2028 2.84 :2029 

# ~ Y2.~4 

# ~ ~Interpolated 2030 2031 2.84 '2032 2.84 2033 2.84 2034 2.84 

## 2035 2.84 '2036 2.84 2037 2.84

Page 8

## Water Price

2038 2.84 2039 2.84 2040 2.84 2041 2.84 2042 2.84 2043 2.84 2044 2.84 2045 2.84 2046 2.84 2047 2.84 2048 2.84 2049 2.84 2050 2.84 2051 2.84 2052 2.84 2053 2.84 2054 2.84 2055 2.84

Page 9

## VBA program

Function Sum_Val(Vintage, UEC)

'Vintage is a range (row) containing vintage by age 'UEC is a range (col) containing UEC's by year from which Sum_Val is calculated ' For UEC before the baseyear, it is set to 0

'row = the row number of Vintage 'n = the number of age groups in Vintage offset = the first column in the vintage row cur_yr = current year colx points to the col containing UEC's
sheet = Vintage.Worksheet.Name Row = Vintage.Row n = Vintage.Count - 1 Offset = Vintage.Column
col = Range("Year").Column cur_yr = Cells(Row, col)
colx = UEC.Column Base_year = Range("base_year").Value
Sum_Val = 0


## For age = 0 To n units = Worksheets(sheet).Cells(Row, Offset + age).Value yr = curyr - age 

## If yr >= Base_year Then x = Worksheets(sheet).Cells(Row

- age, colx).Value Elsex =0 End If For units older than the base year, UEC is set to 0

SumVal = Sum_Val + x * units 

## Next age End Function

Page 10