TO SELECT:

Energy Price Forecast click Energy Prce and a list of options will appear Forecast

Start Year click Start and enter the year for standards to start

Specify Water Heater click Water Heater &

and Dryer Fuel Type Dryer Choice

Choose Design Option for Base click B

Choose Design Option for Standard click tandard

ASSUMPTIONS:

Recovery Efficiency

Electric Water Heater r

Gas Water Heater

Oil Water Heater

Temperature Difference for Hot Water l deg F

kWh required to heat one gallon of water i '

kWh

Number of Washer Cycles per Year cycles
%-11U=IGirjir mll*p~~i~~ro1T~,'vx. Cmm u l ,5.,~:mz*~.~.'~.* 5s ae'V

% Improv. Cumul.

over Variable Retail Hot

Level Option Baseline Mnf. Cost Price Water Water Heat 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+ Improved Fill 16.4% $24.17 $424 7.98 1.436 0.232 1.097 36.77

5a 4a+ Auto Fill + 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

Manufacturer Variable Markup Factor 1.00. 1.23 1.46

Retailer Variable Markup Factor ', 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% % Clange per Year % Change per Year % Change per Year

AE097 GR197 GR196 1996 Constant | 2000-2% 2000-4%

Elec Gas Oil Elec Gas il ec 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
Shipments and Electricity Consumption of New Clothes Washers (Base Case)

assumes 98% baseline and 2% horizontal axis in 1996, with 0.5% increase in horizontal axis each year thereafter.

I1i..(J!NA£her p:r,.UitlnergeUle and~,peratsng~ostK.! Total

New Surviving Unit Hot Water H. 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 expressed as source energy Temperature difference of inlet/outlet water of water heater 75 degree

Heat content of I gallon of water through I degree F 0.0024 kWh

** Energy use is based on assumptions of Heat content of I gallon of hot water heated by water heater 0.18 kWh

water heater saturations and recovery Number of cycles per year for clothes washer 392 cycles

efficiencies byfuel type (see Saturation Sheet)
.7I

Shipments and Electricity Consumption of New Clothes Washer -Standards Case

Year of Standards Dlscu Ratu = 7% to Year 1995

$hlpX ~ ~~~~ e~al Ce dEl Ted Ale T-d

NaV SeeMntig Ifolk 0 r3 Wf fH. &re MotW, Wat,1tŽljlA-4A tr 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 ) ( (1995$) lQua)) 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 13 3 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 al66 $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 1 236 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 1 213 4 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+25 0.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 $213 1 .88 13

206 1.92 11674 $396 26 461 .97 93 19 :73 41 .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 a I 0. .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 20

39 $36 2193 16

37 08 ?$.e4.6 3 0.03

.m6 S3 013004

.041 n W ,4.6 02 0.03

06 e e yf.1 Iee See.tie Shea) N h , Z $6 24 6

03, $2466 2.61 63

$74..620-6 600

3029 M2s4 $246 $78. 63I.0 09. o.0 o.03 0 

33631 $376 668 604 3043 $76 0-.7 00.

2048 $36,6 6o2 04

3353 3046 83 $2.66 0.020630 M46 0.04 o68

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: Water Heater and Dryer Saturations by Fuel Type,

Water Heater Recovery Efficiencies by Fuel Type

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

Water Price

($/1000 gal)

1995 Io a from Al Dietemann of Seattle Water

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

Else

x =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