For Units Sold from 2005 to 2030

Discounted at 7% to 1997 (in billion 1997 $)

2F40 I F40 2F961ES 2F96HOIES All T12

Total Quad Saved 0.37 0.02 0.20 0.02 0.61

Total Benefit 0.71 0.03 0.35 0.02 1.12

Total Equipment Cost 0.19 0. 02 0.13 0.01 0.34

Net Present Value 052 0.02 0.23 0.01 0.78

I

For Units Sold from 2005 to 2030

Discounted at No to 1997 (in billion 1997 $)

2F40 1F40 2F96/ES 2F96HOIES All T12

Total Quad Saved 0.26 0.01 0.01 018

Total Benefit 0.49 0.01 0.01 0.51

Total Equipment Cost 0.18 0.01 0.00 0.19

Net Present Value 0.31 0.00 0.01 0.32

4^7

EE-RM-97-500 COMMENT 21EE

Energy Saving and Net Present. Values for Ballasts ~ 

Total Quad Saved 

Total Benefit 

Total Equipment Cost 

Net Present Value 

Total Quad Saved 

Total Benefit 

Total Equipment Cost 

Net Present Value 

COrll'erti"g /1'0111 EEM 10 Elet:lronk Rapid Starl 

For Units Sold (rom 2005 to 2030 

Discounted at 7% to 1997 (in billion 1997 $) 

2F40 IF40 lF961ES 

0.37 0.02 0.20 

0.71 0.03 0.35 

0.19 0.02 o.n 

0.52 0.02 0.23 

f'olll'el'lillg from HEM 10 Cat/lOde Culout 

For Units Sold from 2005 to 2030 

Discounted at 7% to 1997 (in billion 1997 $) 

2F40 IF40 2F961ES 

0.26 0.01 

0.49 0.01 

0.18 1t.0l 

0.11 0.00 

2F96HO/ES AllT12 

~l ' 

EI~0F , 1~IDJm~ . 

0.01 0.61 

0.02 1.12 

0.01 0.34 

(}'ol 0.78 

2F96HOIES AllT12 

0.0] 0.28 

0.01 0.51 

".00 0.19 

0.01 0.32. 
EE-RM-97-500 COMMENT 21EE

Discounting 

Shjpment 
EE-RM-97-500 COMMENT 21EE

EIA 

Annual Energy Outlook 1998 

j 

2 +! ---r-----,--.---. 

1990 2000 2010 2020 

5 Industrial Elec Price 

~ 

2~i--.-----,--.---. 

1990 2000 2010 2020 
EE-RM-97-500 COMMENT 21EE
EE-RM-97-500 COMMENT 21EE

Start Year 
EE-RM-97-500 COMMENT 21EE
Comparison of Energy Price Projections

(1997$)

Commercial Electricity Price

5 High Growth . a

4 ®-AEO1999

3 ' °°'GRI1998

2 Low Growth

1995 2000 2005 2010 2015 2020 2025 2030

Industrial Electricity Price

High Growth

0 2

®^AEO1998

Low Growth

GRI 1998

0

1995 2000 2005 2010 2015 2020 2025 2030

OK

EE-RM-97-500 COMMENT 21EE

5 -High Growth . 

4 .... ·-AEO 199& 

3 ~=GRI199S 

2 -Low Growlh 

1995 2000 200S 2010 2015 2020 2025 

5 

Industrial Electricity Price 

3 

•• c •• 

~.':o~ .. ~.: .... ""'-~ .. ~_ '&. .... --t. ••• '. ' '~__ ~_o'" ••••• 

~-~'~-=-::::~~~::.:~~ -High Growth 

4 

2 --o-AEO 1998 

-Low Growth 

; ~GRI]998 

0-',-. • 

1995 2000 2005 2010 2015 2020 2025 

OK 
Historical and Projected Shipments

of T12 Ballasts (in millions)

6

2F96 LBNL Regression

-,i 0 User Forecast

4

I

0

1990 2000 2010 2020 2030

EE-RM-97-500 COMMENT 21EE

:"1"4 ... :", ':4'.~ ,': .. : •. :. '_'.-: ..... _": .. ~:.::.' . '. t4-:": .": .' _. ; ... : .: ... : .. ~ .. ::~~:.:~ 

]0 

20 

t 

)0 

0 

1990 

4 

J 

Historical and Projected Shipments 

of T12 Ballasts (in millions) 

2F40 -LBNL Regression 

<> User Forecnst 

-.......................... ~ 

2000 1010 W20 2030 

IF40 -L8Nl Regressioo 

1 Lmnp Fixtu..re 

o Tolal- U.ser Fom:nst 

8 

6 

) 

4 J 

1 

0 

1990 

Q_6 

0_4 

0.2 

lF96 -LBNL ltegn:s~OQ 

0 U.iC1 Forecast 

2000 21HO 2020 W30 

2F9WO 

--LBNL Regression 

<> User Forcrnsl 

o i 0_0 -I--'---r-~.-r---'Qj_IDl~ 

1990 'WOO 2010 2020 2010 1990 2000 2tHO 2020 2000 
PE Wit wt 9Z'Ltt 01ZI Slfa!-Jp113 Z

apilma 1 0'921 InainD 097£t 6t tsI- Sz L8'

Ott ae1Jasa•O 0 ' HK 96'ZZf O

® 1i'^I ig tKir zsa rad ammlaad f1Lal d M mllaiiad +ae}la4

omt4 y051fi IAOC3Y ® (aanPU .°_ X14 4M1 EuJ-su( ' (511

9S 16'11 Of EOYZt E'S6 Slf 'awojlaa!g z

9E 8L'01S i9i 06YEt 8'IXJ1 1aNO3 2pa4IDJ l

66f It'czs Will II OUT-no 0

I'vali (5L6)mud • t ougduasap la•71 1100 •33OI 801ASs M-4

(pagan aulpoel lou Vueial BSI a nU 53(LIJ01-IZ

Ef SCSI 9ZC EO'SZS 0'16 S71'a!aU1913 Z

'h ThuiiJ 2p19193 I 4Z 18'kS' rtf SYtTI 6

fCLIS I's01 aU!pc 0 SIC

5L0 amd AMR vo!idu-15wQ I'M WI (

in pad atfil4 tad amisiliad

ayz0 dmml C -j 59JZI.IBtJt

`a+ ayncl ® fpa+W 34l 4 Seus141h1 is0J 71u1

'Z9 Ell'anxsrrf3 Z Zzs 0 BE MIS LZZ SE'

'59 Inutro aPC I I OE'91S 6 0Z 0iI t Liz

!IMU O 19Z Ot-1ft t'nL aa

MaN Vn!Iduas-,G IaM LIAM IsuJ'r.IUI L44 (SLi) 7'114 8a!ASS

3/ZIJttJZ (. C-apu dml r ql

Ltl LS'Efs EBB Zt9t1 SOLI S8'`!oI'4,'a13 Z

CL If•-1't LM 4L'Lit EYBI lfQIIt aPu414J I

au!Iaseg 0 O(01 IU%.f Jt0(

{ IsXIJ •lau( 44M1 (t6s) cpd A MN uugduilaa la'l tuctrs gn

smilzId961Z

If I OII lot IK'0£S ['111 Sb =4W1'31if Y

1na0n3 aINJIrc) I

p01 0 tst II 6t0 19x1 1uc

fatal ''apd A IN u0 tie:,a 8uttr.S4!6{ W13 a( 44A11 11!61-

SA <Ll9G1Z

LAU 06111 Z'90 Sd'3!Ieuwal3 Z 01T Is-it

ootIJ alxst(rJ 1 i 'Lif B'001 ME cf EoZ Wit

Z15 Will auslaas9 0 ' C591 tZ

uegeq d 2u II 4Jaf Isgie+a 'ad Istlfai and tt3N un!Id1r_xaJ fa1f

sm) -pa !atw-MOW SJ2110t31 I 'iau) 44hvI ,ni IWJ

SutAe54

91 Wort Lil W ,Us >-zc 98''!ounaal3 z

IIK1In3 OfW4l0) I L IS 6"8£ it 116 (1 Otl 09-

15 Qt a6!la g 0 0 Ifi 11

JuLtZ94M4 111(3 MOI 1SL61 bpd MAN Qo!idplsap psa7 '4I &

IBaanle IIUUJaOI Lp1 auntzil

fiwpa2UZdu-y

EE-RM-97-500 COMMENT 21EE

!:n.l1in*~in!J 

Dera .. 11 U1JlWIlllzbfillf 1Bou ... JaIl) 

IFIOT11ITS 

L:v<l Oca:ripiio.D "lOW PflO::I91I) tW~< locr.CII" kWhSa\;ng: 

B.,..,linc ~l..J $11.711 Ul 

CUII,'II. CulllUl 3H.V SIHIl 140 Sl.~1 11 

2 Eleclmaicp RS )2.4 . S22.~ 117 ~JCl.&:I lfi 

zF40nvrs j .... 'rf1lcd .. ~"".} ,.",(m) kWlv)T IDer. Cool kWbS<.viBg 

1.01>1 Oc:oiplian NfW ",.""'WI pc. 1:111115' ""rball .... fl<7h.lr .... 

0 B.:!«elinr 1Ll:~ SI1.24 2M.7 

J C .. l""k CUI'",I IOIl.R II7.S] 240.3 JL'O 2U 

2 Electroni.:-. RS 96.2 117.110 22ft.' sur .V.D 

lf96n!ITS 

La'" Do::.;;rl['!ion NFW 1'Jiu>(9lJ) klVhI}Y IDt:r. C<:511 lWhS:llinl 

0 OMriine IUd SI9.'!I/ ~54 

J Cl>IlI,wle CUJoul 

1 Eire"' .. ;':. RS IIU $3OjCl 401 SI(lW jJ 

IF!lilTl2110JIS 

la~' tt...Kripli<1. NFW Pri", (illS) kWh!>T !"cr.C',"1 t'o\'b S,,,;n & 

il lIal<line .!OlD J~H! 11») 

I C.lhodr OJllJUI lK5.) .111.7. go:n S·UI 73 

2 Ela:u".k. Ri J16S S46.4! RS) i13.57 tJ7 

Jrm'IVES (iIIllamp n ....... ) ·:t;jj~·(i·:. 

10 ... , Descripl'"11 NfW p""lm} k~.,. lDt:r. elllSl kWh Sa";lIg 

II BIUCU ... 12,1 $JI.40 l61 

I e.1OOde O:IIouI &5.9 S16JO 231 J4.!IO 24 

·2 Ek>o"..roolc, IlS fit.O S22,lj 213 51O.'JS 38 

lFtrrlUf3 (ill J limp Om .... btIdr ... ""ftdl Urb'fr Incr.CoiI kWltI:wio, ~~·A'E:~.: 

U:\'el o.A.Tiplion N!'Vr' p"",(!nlj pcrli;t1ute porb.1llasl pe.bo.llart 

BBlcliIlt! IUS.J Ill.!] HI 

C.tb"de o.lClUl ~,9 J14.4S ~l $f.N7 H 

E1orlnlOic, RS ltJ.D SH.II] 128 ~:.!i 33 

Znotl2l£S (1.3 Jam, Ibtaft, not ."" ....... lft<I) ~~~·i):~::~.~~ ["",1 Otg:riplioo "A\' Po1a:(91S] . t'I!t~ Iocr, eNl kWll s"vi"~ 

0 Ba.o::Jia. IIG.R 523.11 39\1 

[ ellUuxlc CuOOIll lOU.1! JJJ.!lO l<>~ $10.18 36 

EJlldrCDic, lIS "5.1 SH.OO J·U rr.!tl 56 

1F4IJi1 lIP (Ia 4J ..... jltl"~) kV.'IIIJ< I"",. eUK lV.1Ha'!"Il ~:·;.}3~ ;~:::; 

te~ Drs.:riptioo J(F\\' I'rl<I:l'1lJ' j'I£'r.:.""qre. po:rhallut pe.! .. lIut 

0 B.lser ... (41).0 J22.R~ 5114 

I c.u.cdc CulGul 12'-0 S32./iO ~ S4.1J1 1J 

1 Eloc1rooic, RS 121.0 ~21.26 4:!<. $2.20 34 
T12 Shipment

Annual T12 Shipments (in million) based on 199`7 Shipment and Reduction Schedule as speclf ed by User

2F40T12 1F4OT12 1F40T12 2F96T12 2F96T12/HC All TI2

Electronic

4 ft T12s

1Lamp Fix 2Lamp 1 s 0. 728

1997 23.00 1.17 1.03 6.00 0.30 31.50 17.92

2001 17.09 0.91 0.80 4.86 0.24 24.70 13.94

2002 16.61 0.04 0.75 4.57 0.23 23.00 12.94

2003 15.33 0.78 0.69 4.29 0.21 21.30 11.95

2004 14.06 0.71 0.63 4.00 0.20 19.60 10.95

2005 12.78 0.65 0.57 3.71 0.19 17.90 9.95

2006 11.50 0.58 0.52 3.43 0.17 16.20 0.96

2007 10.22 0.52 0.46 3.14 0.16 14.50 7.96

2008 8.94 0.45 0.40 2.86 0.14 12.00 6.97

2009 7.67 0.39 0.34 2.57 0.13 11.10 5.97

2010 6.39 0.32 0.29 2.29 0.11 9.40 4.98

2011 5.11 0.26 0.23 2.00 0.10 7.70 3.98

2012 3.83 0.19 0.17 1.71 0.09 6.00 2.99

2013 2.56 0.13 0.11 1.43 0.07 4.30 1.99

2014 1.28 0.06 0.06 1.14 0.06 2.60 1.00

2015 0.00 0.00 0.00 0.86 0.04 0.90 0.00

2016 0.00 0.00 0.00 0.57 0.03 0.60 0.00

2017 0.00 0.00 0.00 0.29 0.01 0.30 0.00

2018 0.00 0.00 0.00 0.00 0.00 DAD 0.00

2019 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2020 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2021 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2022 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2023 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2024 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2025 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2026 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2027 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2028 0.00 0.00 0.00 0.00 0.00 0.00 0.00

2029 0.00 0.00 0.00 0,00 0.00 0.00 0.00

2030 0.00 0.00 0.00 0.00 0,00 0.00 0.00

If you want to update any cell in]

this %,r'orksheet manually, you

should hit <CRTL><ALT>F9t

invoke the calculation

EE-RM-97-500 COMMENT 21EE

T12 Shipment 

Annual Til Shipments (in million) based on 1m Shlpm~nt and Reduction ScbeduJe as 5Jleclfi~d by User 

El~ctroDic 

2F40TU IF4afU lF40TU 2F'i1tiT12 !F96Tl2/HC ADTU 4 CtTl2s 

lLampFix 2LampFh 0.728 

1997 nOll 1.17 1.03 6.00 1).30 31.50 17.92 

2001 11.89 0.9J 0.80 U6 0.24 24.71l 13.94 

2002 16.61 0.84 0.75 4.57 0.23 23.00 12.94 

20m 15.33 0.78 0.69 4.29 0.21 21.30 11.95 

2004 14.06 0.71 0.63 4.00 0.20 19.60 10.95 

2005 12.78 0.65 0.57 3.71 0.19 17.90 9.95 

2006 11.50 0.58 0.52 3AJ 0.17 IUD 1l.96 

2007 10.22 0.52 0.46 3.14 0.16 J4,S0 7.96 

2008 g.94 0.45 0.40 2.86 0.14 12.IlO 6.97 

2009 7.67 0.39 0.34 2.57 0.13 11.10 5.97 

20JO 6.39 0.32 0.29 2.29 0.11 9.40 4.98 

2011 5.1 ) 0.26 0.23 2.00 0.10 7.7it 3.98 

2012 3.83 0.19 0.17 J.71 0.09 ti.OO 2.99 

2013 2.56 0.13 0.11 ].43 0.07 4.30 1.99 

2014 1.28 0.06 0.06 1.14 0.06 2.60 1.00 

2015 0.00 0.00 0.00 0.86 0.1» 0.90 0.00 

2016 0.00 0.00 0.00 0.57 O.OJ 0.60 0.00 

2017 0.00 0.00 0.00 0.29 om 0.30 0.00 

201 It 0.00 0.00 0.00 0.00 0.00 O.itO 0.00 

2019 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2020 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2021 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2022 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2023 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2024 0.00 0.00 0.00 D.nO 0.00 0.00 0.00 

2025 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2026 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2021 0.00 0.00 0.00 0.00 0.00 It.Oo 0.00 

2028 0.00 0.00 0.00 0.00 0.00 it.oo 0.00 

2029 0.00 0.00 0.00 0.00 0.00 0.00 0.00 

2030 0.00 0.00 0.00 0.00 0.00 0.00 0.00