|
929662
Preferences.EnergyUnitsTWh749689690688652653654659
847305624252627614446846743562636272688461069146851412021474812471517023192218861513413513661668620216176125579661868731666INDEX(Vectors[Description], MATCH(BK$5,Vectors[Code],FALSE))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(BL$5,Vectors[Code],FALSE))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(BM$5,Vectors[Code],FALSE))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(BN$5,Vectors[Code],FALSE))Blast furnace gas657INDEX(Vectors[Description], MATCH(BP$5,Vectors[Code],FALSE))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(BQ$5,Vectors[Code],FALSE))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(BR$5,Vectors[Code],FALSE))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(BS$5,Vectors[Code],FALSE))Blast furnace gas656INDEX(Vectors[Description], MATCH(BU$5,Vectors[Code],FALSE))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(BV$5,Vectors[Code],FALSE))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(BW$5,Vectors[Code],FALSE))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(BX$5,Vectors[Code],FALSE))Blast furnace gas655660658663
200442456657133637383940454647495010875175275364656673389101112104750541371383435596079561758759760761758759760761758759760761
661
592664
|
676INDEX(Workstreams[Workstream], MATCH($C9, Workstreams[Code], 0))HeatingI15+I10582.62431955664806L9+M9+N9+O90I9+J9+K9+P9+Q9582.62431955664806T15+T10-67.564013066454422V15+V10-8.0382030847790773W15+W10-47.349658995256426X15+X10-448.68165574413212Z15+Z10-5.0871247399999993U9+T9+V9+W9+X9+Y9+Z9+AA9+AB9-576.7206556306221AE15+AE100AF15+AF100AG15+AG100AE9+AF9+AG90AJ15+AJ10-0.52205907000000007AQ15+AQ10-3.8611111111111107AJ9+AK9+AL9+AM9+AN9+AO9+AP9+AQ9-4.3831701811111108AS15+AS10-0.9393085193548687AU15+AU10-0.58118522556009999AS9+AT9+AU9-1.5204937449149687AH9+AI9+AR9+AV9-5.9036639260260797AY9+AZ90BB9+BC9+BD90BA9+BE90R9+AC9+AW9+BF9-1.2345680033831741E-13$D9Heating-($AE9+$V9)*EF.IndustrialCoal.CO22.4757665501119552-($AF9+$W9+$BD9)*EF.Diesel.CO211.837414748814107-($AG9+$X9)*EF.NaturalGas.CO282.55742465692029-$Y9*EF.BlastFurnaceGas.CO20$BK9+$BL9+$BM9+$BN996.870605955846344-($AE9+$V9)*EF.IndustrialCoal.CH47.2729074411706863E-3-($AF9+$W9+$BD9)*EF.Diesel.CH41.4737534631105675E-2-($AG9+$X9)*EF.NaturalGas.CH40.16548517784088498651BP9+BQ9+BR90.18749561991316135-($AE9+$V9)*EF.IndustrialCoal.N2O2.1931611250643586E-2-($AF9+$W9+$BD9)*EF.Diesel.N2O0.21297934726683534-($AG9+$X9)*EF.NaturalGas.N2O0.17798735408335278651BU9+BV9+BW90.41289831260083171BO9+BT9+BY9+BZ997.470999888360339
41$C$136[1]443SUM(I12:I14)436.4944796177661L10+M10+N10+O100436.4944796177661SUM(T12:T14)-36.974092934031496SUM(V12:V14)-7.9083510389235778SUM(W12:W14)-33.454328504791064SUM(X12:X14)-352.90485745899207SUM(Z12:Z14)-0.60399999999999998U10+T10+V10+W10+X10+Y10+Z10+AA10+AB10-431.84562993673819SUM(AE12:AE14)0SUM(AF12:AF14)0SUM(AG12:AG14)0AE10+AF10+AG100SUM(AJ12:AJ14)-0.52205907000000007SUM(AQ12:AQ14)-3.8611111111111107AJ10+AK10+AL10+AM10+AN10+AO10+AP10+AQ10-4.3831701811111108SUM(AS12:AS14)-0.26567949991680362-0.26567949991680362-4.64884968102791430BB10+BC1000-2.6645352591003757E-15-($AE10+$V10)*EF.IndustrialCoal.CO22.43577211998846148.3635821261977661-($AG10+$X10)*EF.NaturalGas.CO264.93449377245453-$Y10*EF.BlastFurnaceGas.CO20$BK10+$BL10+$BM10+$BN1075.733848018640757-($AE10+$V10)*EF.IndustrialCoal.CH47.1554182585022372E-31.041262672977512E-2-($AG10+$X10)*EF.NaturalGas.CH40.13016026474418046651BP10+BQ10+BR100.14772830973245782-($AE10+$V10)*EF.IndustrialCoal.N2O2.1577320053995892E-20.15047798018808303-($AG10+$X10)*EF.NaturalGas.N2O0.13999369267307121651BU10+BV10+BW100.31204899291515015BO10+BT10+BY10+BZ1076.193625321288366
416000000000
114$C$137[1a]-AC12-AW12291.47592449379539L12+M12+N12+O120291.47592449379539-'DECC Energy Cons. (1.14)'!$F$4*Unit.ktoe-13.971461786760198-'DECC Energy Cons. (1.14)'!$E$4*Unit.ktoe-6.0971955573687122-'DECC Energy Cons. (1.14)'!$D$4*Unit.ktoe-24.694588567042736-'DECC Energy Cons. (1.14)'!$C$4*Unit.ktoe-241.45982890159584-'DUKES 09 (1.2)'!$J$58*Unit.ktoe-0.60399999999999998U12+T12+V12+W12+X12+Y12+Z12+AA12+AB12-286.82707481276748AE12+AF12+AG120-'DUKES 09 (7.2)'!$K$61*Unit.ktoe-0.52205907000000007-'DUKES 09 (7.2)'!$C$61*Unit.ktoe-3.8611111111111107-4.3831701811111108-'DUKES 09 (7.2)'!$J$61*Unit.ktoe-0.26567949991680362-0.26567949991680362-4.6488496810279143000-2.6645352591003757E-15-($AE12+$V12)*EF.IndustrialCoal.CO21.87793623166956296.173647141760684-($AG12+$X12)*EF.NaturalGas.CO244.428608517893629-$Y12*EF.BlastFurnaceGas.CO2052.480191891323877-($AE12+$V12)*EF.IndustrialCoal.CH45.5166980072236527E-37.6861663194693428E-3-($AG12+$X12)*EF.NaturalGas.CH48.9056510814868151E-26510.10225937514156115-($AE12+$V12)*EF.IndustrialCoal.N2O1.6635723341771845E-20.11107656244279851-($AG12+$X12)*EF.NaturalGas.N2O9.5784607000118413E-26510.2234968927846887652.805948159250129
115-AC13-AW13130.18160973500784L13+M13+N13+O130130.18160973500784-'DECC Energy Cons. (1.14)'!$F$5*Unit.ktoe-16.177343547341795-'DECC Energy Cons. (1.14)'!$E$5*Unit.ktoe-1.77652236070583-'DECC Energy Cons. (1.14)'!$D$5*Unit.ktoe-8.7188237440085707-'DECC Energy Cons. (1.14)'!$C$5*Unit.ktoe-103.50892008295163U13+T13+V13+W13+X13+Y13+Z13+AA13+AB13-130.18160973500784AE13+AF13+AG1300000000-($AE13+$V13)*EF.IndustrialCoal.CO20.547168887097395532.1797059360021427-($AG13+$X13)*EF.NaturalGas.CO219.045641295263096-$Y13*EF.BlastFurnaceGas.CO2021.772516118362635-($AE13+$V13)*EF.IndustrialCoal.CH41.607384456489961E-32.7137252853860153E-3-($AG13+$X13)*EF.NaturalGas.CH43.8176715782232466E-26514.249782552410844E-2-($AE13+$V13)*EF.IndustrialCoal.N2O4.8471029385725849E-33.9217376203692651E-2-($AG13+$X13)*EF.NaturalGas.N2O4.1060913843324019E-26518.5125392985589257E-221.900139336872332
116-AC14-AW1414.836945388962878L14+M14+N14+O14014.836945388962878-'DECC Energy Cons. (1.14)'!$F$6*Unit.ktoe-6.8252875999295028-'DECC Energy Cons. (1.14)'!$E$6*Unit.ktoe-3.4633120849035942E-2-'DECC Energy Cons. (1.14)'!$D$6*Unit.ktoe-4.0916193739758112E-2-'DECC Energy Cons. (1.14)'!$C$6*Unit.ktoe-7.9361084744445822U14+T14+V14+W14+X14+Y14+Z14+AA14+AB14-14.836945388962878AE14+AF14+AG1400000000-($AE14+$V14)*EF.IndustrialCoal.CO21.0667001221503068E-21.0229048434939528E-2-($AG14+$X14)*EF.NaturalGas.CO21.4602439592978029-$Y14*EF.BlastFurnaceGas.CO201.4811400089542455-($AE14+$V14)*EF.IndustrialCoal.CH43.1335794788623448E-51.2735124919761817E-5-($AG14+$X14)*EF.NaturalGas.CH42.9270381470798334E-36512.9711090667882186E-3-($AE14+$V14)*EF.IndustrialCoal.N2O9.4493773651464227E-51.84041541591885E-4-($AG14+$X14)*EF.NaturalGas.N2O3.1481718296287571E-36513.4267071448721063E-31.4875378251659059
52$C$138[2]444SUM(I17:I19)146.12983993888199L15+M15+N15+O150146.12983993888199SUM(T17:T19)-30.589920132422925SUM(V17:V19)-0.12985204585550009SUM(W17:W19)-13.89533049046536SUM(X17:X19)-95.77679828514006SUM(Z17:Z19)-4.4831247399999992U15+T15+V15+W15+X15+Y15+Z15+AA15+AB15-144.87502569388386SUM(AE17:AE19)0SUM(AF17:AF19)0SUM(AG17:AG19)0AE15+AF15+AG1500SUM(AS17:AS19)-0.67362901943806508SUM(AU17:AU19)-0.58118522556009999-1.254814244998165-1.254814244998165000-3.5083047578154947E-14-($AE15+$V15)*EF.IndustrialCoal.CO23.9994430123494018E-23.4738326226163401-($AG15+$X15)*EF.NaturalGas.CO217.622930884465767-$Y15*EF.BlastFurnaceGas.CO2021.136757937205601-($AE15+$V15)*EF.IndustrialCoal.CH41.1748918266844955E-44.3249079013305538E-3-($AG15+$X15)*EF.NaturalGas.CH43.5324913096704547E-26513.976731018070355E-2-($AE15+$V15)*EF.IndustrialCoal.N2O3.5429119664769499E-46.2501367078752298E-2-($AG15+$X15)*EF.NaturalGas.N2O3.7993661410281585E-26510.1008493196856815721.277374567071988
416000000000
114$C$137[1a]-AC17-AW17104.6275102338453L17+M17+N17+O170104.6275102338453-'DECC Energy Cons. (1.14)'!$F$11*Unit.ktoe-14.045834614912419-'DECC Energy Cons. (1.14)'!$E$11*Unit.ktoe-0.11750963888039824-'DECC Energy Cons. (1.14)'!$D$11*Unit.ktoe-12.289764386263311-'DECC Energy Cons. (1.14)'!$C$11*Unit.ktoe-72.436462608791018-('DUKES 09 (1.2)'!$J$59+'DUKES 09 (1.2)'!$J$60)*Unit.ktoe-4.4831247399999992U17+T17+V17+W17+X17+Y17+Z17+AA17+AB17-103.37269598884714AE17+AF17+AG1700-('DUKES 09 (7.2)'!$J$62+'DUKES 09 (7.2)'!$J$63)*Unit.ktoe-0.67362901943806508-'DUKES 09 (7.2)'!$F$62*Unit.ktoe-0.58118522556009999-1.254814244998165-1.254814244998165000-6.6613381477509392E-15-($AE17+$V17)*EF.IndustrialCoal.CO23.6192968775162648E-23.0724410965658278-($AG17+$X17)*EF.NaturalGas.CO213.328309120017545-$Y17*EF.BlastFurnaceGas.CO2016.436943185358537-($AE17+$V17)*EF.IndustrialCoal.CH41.0632186298463215E-43.8251770359915313E-3-($AG17+$X17)*EF.NaturalGas.CH42.671640514720813E-26513.0647904046184293E-2-($AE17+$V17)*EF.IndustrialCoal.N2O3.2061590021387703E-45.5279511037487759E-2-($AG17+$X17)*EF.NaturalGas.N2O2.8734792594794074E-26518.4334919532495708E-216.551926008937215
115-AC18-AW1819.039910654165368L18+M18+N18+O18019.039910654165368-'DECC Energy Cons. (1.14)'!$F$12*Unit.ktoe-3.3124095446842174-'DECC Energy Cons. (1.14)'!$E$12*Unit.ktoe-1.2342406975101861E-2-'DECC Energy Cons. (1.14)'!$D$12*Unit.ktoe-1.1634552953297206-'DECC Energy Cons. (1.14)'!$C$12*Unit.ktoe-14.55170340717633U18+T18+V18+W18+X18+Y18+Z18+AA18+AB18-19.039910654165368AE18+AF18+AG1800000000-($AE18+$V18)*EF.IndustrialCoal.CO23.8014613483313723E-30.29086382383243015-($AG18+$X18)*EF.NaturalGas.CO22.6775134269204441-$Y18*EF.BlastFurnaceGas.CO202.9721787121012055-($AE18+$V18)*EF.IndustrialCoal.CH41.1167319683817421E-53.6212431241337557E-4-($AG18+$X18)*EF.NaturalGas.CH45.3670373981093613E-36515.740329030206554E-3-($AE18+$V18)*EF.IndustrialCoal.N2O3.3675296433818015E-55.2332361970820378E-3-($AG18+$X18)*EF.NaturalGas.N2O5.7725096484132271E-36511.1039421141929084E-22.9889584622733412
119-AC19-AW1922.462419050871326L19+M19+N19+O19022.462419050871326-'DECC Energy Cons. (1.14)'!$F$13*Unit.ktoe-13.231675972826286-'DECC Energy Cons. (1.14)'!$D$13*Unit.ktoe-0.44211080887232823-'DECC Energy Cons. (1.14)'!$C$13*Unit.ktoe-8.7886322691727088U19+T19+V19+W19+X19+Y19+Z19+AA19+AB19-22.462419050871326AE19+AF19+AG1900000000-($AE19+$V19)*EF.IndustrialCoal.CO200.11052770221808206-($AG19+$X19)*EF.NaturalGas.CO21.6171083375277782-$Y19*EF.BlastFurnaceGas.CO201.7276360397458603-($AE19+$V19)*EF.IndustrialCoal.CH401.3760655292564675E-4-($AG19+$X19)*EF.NaturalGas.CH43.2414705513870499E-36513.3790771043126968E-3-($AE19+$V19)*EF.IndustrialCoal.N2O01.9886198441824939E-3-($AG19+$X19)*EF.NaturalGas.N2O3.4863591670742842E-36515.4749790112567781E-31.7364900958614298
000
677INDEX(Workstreams[Workstream], MATCH($C21, Workstreams[Code], 0))Lighting and appliancesJ22+J23146.69564603235992L21+M21+N21+O210146.69564603235992T22+T23-144.56784227719152V22+V230W22+W23-0.13548086802871323X22+X23-1.9923228871396808U21+T21+V21+W21+X21+Y21+Z21+AA21+AB21-146.69564603235992AE21+AF21+AG2100000BB21+BC21+BD2100R21+AC21+AW21+BF210$D21Lighting and appliances-($AE21+$V21)*EF.IndustrialCoal.CO203.3870217007178308E-2-($AG21+$X21)*EF.NaturalGas.CO20.3665874112337012-$Y21*EF.BlastFurnaceGas.CO200.40045762824087949-($AE21+$V21)*EF.IndustrialCoal.CH404.2168286462748278E-5-($AG21+$X21)*EF.NaturalGas.CH47.3481922666968167E-46517.7698751313242992E-4-($AE21+$V21)*EF.IndustrialCoal.N2O06.0939460710351294E-4-($AG21+$X21)*EF.NaturalGas.N2O7.9033380264585435E-46511.3997284097493673E-30.40263434416376132
41$C$136[1]443-$AC22-$AW2278.114175905582002L22+M22+N22+O22078.114175905582002-'DECC Energy Cons. (1.14)'!$F$8*Unit.ktoe-78.076491881013496-'DECC Energy Cons. (1.14)'!$C$8*Unit.ktoe-3.768402456850671E-2U22+T22+V22+W22+X22+Y22+Z22+AA22+AB22-78.114175905582002AE22+AF22+AG2200000000006.9338605206052334E-306.9338605206052334E-3001.389882431706964E-56511.389882431706964E-5001.4948861265648674E-56511.4948861265648674E-56.9627082061879519E-3
52$C$138[2]444SUM(J25:J28)68.581470126777916L23+M23+N23+O23068.581470126777916SUM(T25:T28)-66.491350396178035SUM(W25:W28)-0.13548086802871323SUM(X25:X28)-1.9546388625711741U23+T23+V23+W23+X23+Y23+Z23+AA23+AB23-68.581470126777916AE23+AF23+AG230000000003.3870217007178308E-20.3596535507130959600.3935237677202742504.2168286462748278E-57.2092040235261206E-46517.6308868881536031E-406.0939460710351294E-47.7538494138020572E-46511.3847795484837186E-30.39567163595757332
417000000000000000651000065100
120-AC25-AW255.2703708188077432L25+M25+N25+O2505.2703708188077432-'DECC Energy Cons. (1.14)'!$F$15*Unit.ktoe-5.2703708188077432U25+T25+V25+W25+X25+Y25+Z25+AA25+AB25-5.2703708188077432AE25+AF25+AG250000000000000000651000065100
121-AC26-AW269.4247154179043644L26+M26+N26+O2609.4247154179043644-'DECC Energy Cons. (1.14)'!$F$16*Unit.ktoe-9.0178517396130111-'DECC Energy Cons. (1.14)'!$C$16*Unit.ktoe-0.40686367829135411U26+T26+V26+W26+X26+Y26+Z26+AA26+AB26-9.4247154179043644AE26+AF26+AG2600000000007.486291680560915E-207.486291680560915E-2001.5006164682034004E-46511.5006164682034004E-4001.6139859663216386E-46511.6139859663216386E-47.5174377049061658E-2
122-AC27-AW2739.231334523028124L27+M27+N27+O27039.231334523028124-'DECC Energy Cons. (1.14)'!$F$17*Unit.ktoe-39.231334523028124U27+T27+V27+W27+X27+Y27+Z27+AA27+AB27-39.231334523028124AE27+AF27+AG270000000000000000651000065100
123-AC28-AW2814.655049367037686L28+M28+N28+O28014.655049367037686-'DECC Energy Cons. (1.14)'!$F$18*Unit.ktoe-12.971793314729153-'DECC Energy Cons. (1.14)'!$D$18*Unit.ktoe-0.13548086802871323-'DECC Energy Cons. (1.14)'!$C$18*Unit.ktoe-1.54777518427982U28+T28+V28+W28+X28+Y28+Z28+AA28+AB28-14.655049367037686AE28+AF28+AG280000000003.3870217007178308E-20.2847906339074868200.3186608509146651204.2168286462748278E-55.7085875553227199E-46516.1302704199502024E-406.0939460710351294E-46.1398634474804181E-46511.2233809518515546E-30.32049725890851166
000
678INDEX(Workstreams[Workstream], MATCH($C30, Workstreams[Code], 0))IndustryK31+K42+K46+K47+K48+K52+K53444.82296266790246L30+M30+N30+O300444.82296266790246T31+T42+T46+T47+T48+T52+T53-119.1190382031217634.033592131949163-95.66818658964182-87.952715482035742-253.09331475925583-0.110456222299999855.8505425742391299U30+T30+V30+W30+X30+Y30+Z30+AA30+AB30-516.05957655016675AE30+AF30+AG300AJ31+AJ42+AJ46+AJ47+AJ48+AJ52+AJ53-1.4000077700000002E-2AK31+AK42+AK46+AK47+AK48+AK52+AK53-1.705027184782586AO31+AO42+AO46+AO47+AO48+AO52+AO53-0.94481533000000006AQ31+AQ42+AQ46+AQ47+AQ48+AQ52+AQ53-4.4099306694429385-7.073773261925524AS31+AS42+AS46+AS47+AS48+AS52+AS53-12.112023888371219AU31+AU42+AU46+AU47+AU48+AU52+AU53-19.88739211449764-31.999416002868859-39.073189264794379AY31+AY42+AY46+AY47+AY48+AY52+AY53106.19377242318789AZ31+AZ42+AZ46+AZ47+AZ48+AZ52+AZ534.1160307238708489110.30980314705874BB30+BC30+BD300110.30980314705874R30+AC30+AW30+BF300$D30Industry-($AE30+$V30)*EF.IndustrialCoal.CO229.46580146960967621.988178870508936-($AG30+$X30)*EF.NaturalGas.CO246.569169915703064-$Y30*EF.BlastFurnaceGas.CO28.6688539495683642E-298.109838795317359-($AE30+$V30)*EF.IndustrialCoal.CH48.6559876478940034E-22.737519588992483E-2-($AG30+$X30)*EF.NaturalGas.CH49.3347235544568585E-26510.20728230791343344-($AE30+$V30)*EF.IndustrialCoal.N2O0.261023198245771140.39561239365179529-($AG30+$X30)*EF.NaturalGas.N2O0.100399490047068326510.7570350819446346599.074156185175426
460$C$140[3]43-AC31-AW31367.37498464752019L31+M31+N31+O310367.37498464752019-'DECC Energy Cons. (4.1)'!$I$44*Unit.ktoe-117.00712613076652-SUM('DECC Energy Cons. (4.1)'!$B$44:$D$44)*Unit.ktoe-22.432673836787838-'DECC Energy Cons. (4.1)'!$L$44*Unit.ktoe-79.395855691428238-SUM('DECC Energy Cons. (4.1)'!$F$44:$H$44)*Unit.ktoe-136.58399643432594-'DECC Energy Cons. (4.1)'!$E$44*Unit.ktoe-0.68804504688000079-'DECC Energy Cons. (4.1)'!$J$44*Unit.ktoe-8.053562079999999U31+T31+V31+W31+X31+Y31+Z31+AA31+AB31-364.16125922018853AE31+AF31+AG310-'DUKES 09 (7.2)'!$E$40*Unit.ktoe-0.29610330888888886-0.29610330888888886-('DUKES 09 (7.2)'!$B$40+'DUKES 09 (7.2)'!$J$40+'DUKES 09 (7.2)'!$D$40)*Unit.ktoe-2.7596816477627946-'DUKES 09 (7.2)'!$G$40*Unit.ktoe-0.15794047067999997-2.9176221184427944-3.21372542733168310BB31+BC31+BD3100-1.5987211554602254E-14-($AE31+$V31)*EF.IndustrialCoal.CO26.909263541730652519.84896392285706-($AG31+$X31)*EF.NaturalGas.CO225.13145534391597-$Y31*EF.BlastFurnaceGas.CO20.5399933021361942352.429676110639875-($AE31+$V31)*EF.IndustrialCoal.CH42.0296919442339929E-22.4711881725186551E-2-($AG31+$X31)*EF.NaturalGas.CH45.0375643066278467E-26519.5384444233804946E-2-($AE31+$V31)*EF.IndustrialCoal.N2O6.1205803923083626E-20.35712353329822888-($AG31+$X31)*EF.NaturalGas.N2O5.4181453206856883E-26510.4725107904281693552.99757134530185
4160000000000
114-AC33-AW3334.313357904108869L33+M33+N33+O33034.313357904108869-'DECC Energy Cons. (1.14)'!F21*Unit.ktoe-9.282915759806853-'DECC Energy Cons. (1.14)'!$E$21*Unit.ktoe-1.0869655186323393-'DECC Energy Cons. (1.14)'!$D$21*Unit.ktoe-8.0171479070190017-'DECC Energy Cons. (1.14)'!$C$21*Unit.ktoe-15.926328718650675U33+T33+V33+W33+X33+Y33+Z33+AA33+AB33-34.313357904108869AE33+AF33+AG3300000000-($AE33+$V33)*EF.IndustrialCoal.CO20.334785379738760442.0042869767547504-($AG33+$X33)*EF.NaturalGas.CO22.9304444842317237-$Y33*EF.BlastFurnaceGas.CO205.2695168407252346-($AE33+$V33)*EF.IndustrialCoal.CH49.8347846221085713E-42.495329373633413E-3-($AG33+$X33)*EF.NaturalGas.CH45.8740340876812618E-36519.352841923525531E-3-($AE33+$V33)*EF.IndustrialCoal.N2O2.9657007848730961E-33.6061229677485984E-2-($AG33+$X33)*EF.NaturalGas.N2O6.3178092364687011E-36514.5344739698827782E-25.3242144223475876
12756.841376311101513056.841376311101513-'DECC Energy Cons. (1.14)'!F22*Unit.ktoe-14.956858068328504-'DECC Energy Cons. (1.14)'!$E$22*Unit.ktoe-13.831665854440475-'DECC Energy Cons. (1.14)'!$D$22*Unit.ktoe-3.0159576692330399-'DECC Energy Cons. (1.14)'!$C$22*Unit.ktoe-25.036894719099493-56.841376311101513000000004.26015308316766550.753989417308259974.606788628314306209.62093112879023241.2514790240499557E-29.3871384798618158E-49.2342419667285E-36512.2687746055214238E-23.7738623330232361E-21.3565814610027272E-29.9318761720386325E-36516.1236314112298268E-29.7048551889577439
12899.439809466979597099.439809466979597-'DECC Energy Cons. (1.14)'!F23*Unit.ktoe-19.534173413224551-'DECC Energy Cons. (1.14)'!$E$23*Unit.ktoe-2.8263344298647115-'DECC Energy Cons. (1.14)'!$D$23*Unit.ktoe-21.331107359048655-'DECC Energy Cons. (1.14)'!$C$23*Unit.ktoe-55.748194264841672-99.439809466979597000000000.870511004398330965.332776839762163810.257667744730865016.4609555888913592.5572467489809536E-36.6392861130279016E-32.0561348395055665E-26512.9757881257064522E-27.7114334293789319E-39.5947582690386529E-22.2114729820339168E-26510.1257737459401046316.61648721608853
12937.15434976555774037.15434976555774-'DECC Energy Cons. (1.14)'!F24*Unit.ktoe-7.2284527736841291-'DECC Energy Cons. (1.14)'!$E$24*Unit.ktoe-1.7641215214918886-'DECC Energy Cons. (1.14)'!$D$24*Unit.ktoe-8.629193243912102-'DECC Energy Cons. (1.14)'!$C$24*Unit.ktoe-19.532582226469618-37.15434976555774000000000.543349428619501642.15729831097802553.593995129670409106.29464286926793641.5961642677432227E-32.685827880690717E-37.2041118732126975E-36511.1486104021646636E-24.8132682143247124E-33.8814217114254257E-27.7483725585772798E-36515.1375857887156248E-26.3575048311767395
13037.339592080383554037.339592080383554-'DECC Energy Cons. (1.14)'!F26*Unit.ktoe-37.339592080383554-37.3395920803835540000000000000000651000065100
13110.857245411785907010.857245411785907-'DECC Energy Cons. (1.14)'!F27*Unit.ktoe-10.857245411785907-10.8572454117859070000000000000000651000065100
1223.717453774060710103.7174537740607101-'DECC Energy Cons. (1.14)'!F28*Unit.ktoe-3.7174537740607101-3.71745377406071010000000000000000651000065100
1326.67650743518304606.676507435183046-'DECC Energy Cons. (1.14)'!F29*Unit.ktoe-6.676507435183046-6.6765074351830460000000000000000651000065100
12331.698936308841688031.698936308841688-'DECC Energy Cons. (1.14)'!F30*Unit.ktoe-5.8154186415123554-'DECC Energy Cons. (1.14)'!$E$45*Unit.ktoe-2.1751648896362656-'DECC Energy Cons. (1.14)'!$D$45*Unit.ktoe-5.8675820652881399-'DECC Energy Cons. (1.14)'!$C$45*Unit.ktoe-17.840770712404925-31.698936308841688000000000.669950786007969651.4668955163220353.282701811082505905.41954811341251031.9680733050356368E-31.8262791268824471E-36.580128865006296E-36511.0374481296924379E-25.9347680398725289E-32.6392456140494111E-27.0772484973612697E-36513.9404472677727911E-25.4693270673871632
163$C$142[4]452SUM(K44:K45)5.020135373716454905.0201353737164549SUM(T44:T45)-8.9714468944641065E-2SUM(V44:V45)-13.20840677256111SUM(W44:W45)0SUM(X44:X45)6.7954780887125361SUM(Y44:Y45)-0.70256923162000007-7.20521238441321450000SUM(AY44:AY45)1.7396077648967605SUM(AZ44:AZ45)0.445469245800000022.185077010696760502.185077010696760504.06818928594882130-1.25036796832310640.551392210556729933.36921352818244471.1950869975414313E-20-2.5063447226505832E-36519.4445252527637288E-33.6038109453182574E-20-2.6956955989996738E-36513.3342413854182899E-23.4120004672893911
4160000000000
158$C$143[4a]L44+M44+N44+O4400'DUKES 09 (1.2)'!$B$21*Unit.ktoe+'DUKES 09 (2.5)'!$B$8*1000000*Constants.GCV.Coke+'DUKES 09 (2.5)'!$C$8*1000000*Constants.GCV.CokeBreeze-13.20840677256111'DUKES 09 (2.5)'!$G$8*Unit.GWh+'DUKES 09 (2.5)'!$H$8*Unit.GWh-'DUKES 09 (2.5)'!$H$38*Unit.GWh11.02332976186435U44+T44+V44+W44+X44+Y44+Z44+AA44+AB44-2.1850770106967605AE44+AF44+AG440000-$AC44-$AW44-$AZ441.7396077648967605'DUKES 09 (2.5)'!$H$38*Unit.GWh0.445469245800000022.185077010696760502.18507701069676050-($AE44+$V44)*EF.IndustrialCoal.CO24.06818928594882130-($AG44+$X44)*EF.NaturalGas.CO2-2.0282926761830402-$Y44*EF.BlastFurnaceGas.CO202.0398966097657811-($AE44+$V44)*EF.IndustrialCoal.CH41.1950869975414313E-20-($AG44+$X44)*EF.NaturalGas.CH4-4.0656836817084411E-36517.885186293705871E-3-($AE44+$V44)*EF.IndustrialCoal.N2O3.6038109453182574E-20-($AG44+$X44)*EF.NaturalGas.N2O-4.3728404591191492E-36513.1665268994063425E-22.0794470650535501
165-AC45-AW455.0201353737164549L45+M45+N45+O4505.0201353737164549-'DUKES 09 (1.2)'!$I$30*Unit.ktoe-8.9714468944641065E-2-'DUKES 09 (2.5)'!$H$33*Unit.GWh-4.2278516731518136-'DUKES 09 (2.5)'!$I$33*Unit.GWh-0.70256923162000007U45+T45+V45+W45+X45+Y45+Z45+AA45+AB45-5.0201353737164549AE45+AF45+AG4500000000-($AE45+$V45)*EF.IndustrialCoal.CO200-($AG45+$X45)*EF.NaturalGas.CO20.77792470785993362-$Y45*EF.BlastFurnaceGas.CO20.551392210556729931.3293169184166636-($AE45+$V45)*EF.IndustrialCoal.CH400-($AG45+$X45)*EF.NaturalGas.CH41.5593389590578578E-36511.5593389590578578E-3-($AE45+$V45)*EF.IndustrialCoal.N2O00-($AG45+$X45)*EF.NaturalGas.N2O1.6771448601194761E-36511.6771448601194761E-31.3325534022358407
166589-AC46-AW4664.79017644142364L46+M46+N46+O460I46+J46+K46+P46+Q4664.79017644142364-'DUKES 09 (1.2)'!$I$27*Unit.ktoe-0.56038416424020732-'DUKES 09 (1.2)'!$F$27*Unit.ktoe-64.229792277183435U46+T46+V46+W46+X46+Y46+Z46+AA46+AB46-64.79017644142364AE46+AF46+AG460AJ46+AK46+AL46+AM46+AN46+AO46+AP46+AQ460AS46+AT46+AU460AH46+AI46+AR46+AV460AY46+AZ4600BA46+BE460R46+AC46+AW46+BF460-($AE46+$V46)*EF.IndustrialCoal.CO200-($AG46+$X46)*EF.NaturalGas.CO211.818281779001751-$Y46*EF.BlastFurnaceGas.CO20$BK46+$BL46+$BM46+$BN4611.818281779001751-($AE46+$V46)*EF.IndustrialCoal.CH400-($AG46+$X46)*EF.NaturalGas.CH42.3689576922962512E-2651BP46+BQ46+BR462.3689576922962512E-2-($AE46+$V46)*EF.IndustrialCoal.N2O00-($AG46+$X46)*EF.NaturalGas.N2O2.5479291685726012E-2651BU46+BV46+BW462.5479291685726012E-2BO46+BT46+BY46+BZ4611.867450647610438
167588-AC47-AW471.118720527615034L47+M47+N47+O470I47+J47+K47+P47+Q471.118720527615034-'DUKES 09 (1.2)'!$I$29*Unit.ktoe-0.98302805456324838-'DUKES 09 (1.2)'!$B$29*Unit.ktoe-4.4692473051785787E-2-'DUKES 09 (1.2)'!$F$29*Unit.ktoe-9.0999999999999998E-2U47+T47+V47+W47+X47+Y47+Z47+AA47+AB47-1.118720527615034AE47+AF47+AG470AJ47+AK47+AL47+AM47+AN47+AO47+AP47+AQ470AS47+AT47+AU470AH47+AI47+AR47+AV470AY47+AZ4700BA47+BE470R47+AC47+AW47+BF470-($AE47+$V47)*EF.IndustrialCoal.CO21.3765281699950021E-20-($AG47+$X47)*EF.NaturalGas.CO21.6743999999999998E-2-$Y47*EF.BlastFurnaceGas.CO20$BK47+$BL47+$BM47+$BN473.0509281699950021E-2-($AE47+$V47)*EF.IndustrialCoal.CH44.0437423189536988E-50-($AG47+$X47)*EF.NaturalGas.CH43.3563108700187771E-5651BP47+BQ47+BR477.4000531889724765E-5-($AE47+$V47)*EF.IndustrialCoal.N2O1.2193993290088287E-40-($AG47+$X47)*EF.NaturalGas.N2O3.6098755129007581E-5651BU47+BV47+BW471.5803868802989046E-4BO47+BT47+BY47+BZ473.0741320919869634E-2
126$C$146[5]446SUM(K50:K51)6.5189456776271442L48+M48+N48+O4806.5189456776271442SUM(T50:T51)-0.47878538460714365SUM(V50:V51)-46.207513154019061SUM(W50:W51)-2.4382732434167682SUM(X50:X51)-1.660831092SUM(Y50:Y51)10.2508280562U48+T48+V48+W48+X48+Y48+Z48+AA48+AB48-40.534574817842973AE48+AF48+AG480000SUM(AY50:AY51)31.94504063119583SUM(AZ50:AZ51)2.070588509020000234.015629140215829034.0156291402158290-($AE48+$V48)*EF.IndustrialCoal.CO214.2319140514378690.60956831085419205-($AG48+$X48)*EF.NaturalGas.CO20.30559292092799994-$Y48*EF.BlastFurnaceGas.CO2-8.04508152016852847.1019937630515315-($AE48+$V48)*EF.IndustrialCoal.CH44.1808220408391682E-27.589101405894586E-4-($AG48+$X48)*EF.NaturalGas.CH46.125566425653578E-46514.3179687191546495E-2-($AE48+$V48)*EF.IndustrialCoal.N2O0.126073601856601821.0967382972982284E-2-($AG48+$X48)*EF.NaturalGas.N2O6.5883444945879404E-46510.13769981927904297.2828732695221214
4160000000000
158$C$142[4]447L50+M50+N50+O5000(-'DUKES 09 (2.5)'!$B$25*1000000*Constants.GCV.Coke)+(-'DUKES 09 (2.5)'!$C$25*1000000*Constants.GCV.CokeBreeze)+('DUKES 09 (1.2)'!$B$22*Unit.ktoe)-46.207513154019061'DUKES 09 (1.2)'!$E$22*Unit.ktoe-2.4382732434167682('DUKES 09 (2.5)'!$I$8-'DUKES 09 (2.5)'!$I$38)*Unit.GWh14.63015725722U50+T50+V50+W50+X50+Y50+Z50+AA50+AB50-34.015629140215829AE50+AF50+AG500000-$AC50-$AW50-$AZ5031.94504063119583'DUKES 09 (2.5)'!$I$38*Unit.GWh2.070588509020000234.015629140215829034.0156291402158290-($AE50+$V50)*EF.IndustrialCoal.CO214.2319140514378690.60956831085419205-($AG50+$X50)*EF.NaturalGas.CO20-$Y50*EF.BlastFurnaceGas.CO2-11.4820780469565313.3594043153355297-($AE50+$V50)*EF.IndustrialCoal.CH44.1808220408391682E-27.589101405894586E-4-($AG50+$X50)*EF.NaturalGas.CH406514.256713054898114E-2-($AE50+$V50)*EF.IndustrialCoal.N2O0.126073601856601821.0967382972982284E-2-($AG50+$X50)*EF.NaturalGas.N2O06510.13704098482958413.5390124307140947
165448-$AC51-$AW516.5189456776271442L51+M51+N51+O5106.5189456776271442-'DUKES 09 (1.2)'!$I$31*Unit.ktoe-0.47878538460714365-'DUKES 09 (2.5)'!$H$34*Unit.GWh-'DUKES 09 (1.2)'!$F$31*Unit.ktoe-1.660831092-'DUKES 09 (2.5)'!$I$34*Unit.GWh-4.37932920102U51+T51+V51+W51+X51+Y51+Z51+AA51+AB51-6.5189456776271442AE51+AF51+AG5100000000-($AE51+$V51)*EF.IndustrialCoal.CO200-($AG51+$X51)*EF.NaturalGas.CO20.30559292092799994-$Y51*EF.BlastFurnaceGas.CO23.43699652678800233.7425894477160022-($AE51+$V51)*EF.IndustrialCoal.CH400-($AG51+$X51)*EF.NaturalGas.CH46.125566425653578E-46516.125566425653578E-4-($AE51+$V51)*EF.IndustrialCoal.N2O00-($AG51+$X51)*EF.NaturalGas.N2O6.5883444945879404E-46516.5883444945879404E-43.7438608388080263
597$C$163[13]814L52+M52+N52+O5200'DUKES 09 (1.2)'!$B$19*Unit.ktoe-3.3270032927989854'DUKES 09 (1.2)'!$E$19*Unit.ktoe-0.69724933371891418'DUKES 09 (1.2)'!$F$19*Unit.ktoe-'DUKES 09 (2.5)'!$H$22*Unit.GWh-22.326946044458992-'DUKES 09 (2.5)'!$I$22*Unit.GWh-0.17926499999999998'DUKES 09 (1.2)'!$J$19*Unit.ktoe13.904104654239129U52+T52+V52+W52+X52+Y52+Z52+AA52+AB52-12.626359016737764AE52+AF52+AG520000-$AC52-$AW5212.62635901673776412.626359016737764012.6263590167377640-($AE52+$V52)*EF.IndustrialCoal.CO21.02471701418208740.17431233342972854-($AG52+$X52)*EF.NaturalGas.CO24.108158072180454-$Y52*EF.BlastFurnaceGas.CO20.140691223265687845.4478786430579582-($AE52+$V52)*EF.IndustrialCoal.CH43.0102482793468942E-32.1701816697829431E-4-($AG52+$X52)*EF.NaturalGas.CH48.2347441432242263E-36511.1462010589549414E-2-($AE52+$V52)*EF.IndustrialCoal.N2O9.0774694390896825E-33.1362360601702994E-3-($AG52+$X52)*EF.NaturalGas.N2O8.8568676707416437E-36512.1070573170001626E-25.4804112268175098
125$C$146[5]445L53+M53+N53+O5300('DUKES 09 (5.1)'!$K$78+'DUKES 09 (5.1)'!$K$90)*Unit.GWh-'DUKES 09 (5.6)'!$M$254*Unit.GWh34.033592131949163'DUKES 09 (1.2)'!$B$18*Unit.ktoe-10.447897060423037'DUKES 09 (1.2)'!$E$18*Unit.ktoe-5.4213372134718112'DUKES 09 (1.2)'!$F$18*Unit.ktoe-'DUKES 09 (2.5)'!$H$21*Unit.GWh-34.996226999999998-'DUKES 09 (2.5)'!$I$21*Unit.GWh-8.7914049999999992U53+T53+V53+W53+X53+Y53+Z53+AA53+AB53-25.623274141945686AE53+AF53+AG530-'DUKES 09 (7.2)'!$K$21*Unit.ktoe-1.4000077700000002E-2-'DUKES 09 (7.2)'!$M$21*Unit.ktoe-1.705027184782586-'DUKES 09 (7.2)'!$L$21*Unit.ktoe-0.94481533000000006-'DUKES 09 (7.2)'!$E$21*Unit.ktoe-4.1138273605540494-6.7776699530366358-('DUKES 09 (7.2)'!$J$21+'DUKES 09 (7.2)'!$D$21)*Unit.ktoe-9.352342240608424-('DUKES 09 (7.2)'!$F$21+'DUKES 09 (7.2)'!$G$21)*Unit.ktoe-19.72945164381764-29.081793884426062-35.859463837462698-$AC53-$AW53-$AZ5359.882765010357538'DUKES 09 (5.6)'!$M$254*Unit.GWh1.599972969050848861.482737979408384061.4827379794083840-($AE53+$V53)*EF.IndustrialCoal.CO23.21795229461029481.3553343033679528-($AG53+$X53)*EF.NaturalGas.CO26.4393057679999988-$Y53*EF.BlastFurnaceGas.CO26.899693323705600217.912285689683848-($AE53+$V53)*EF.IndustrialCoal.CH49.4531809502576732E-31.6873858571705234E-3-($AG53+$X53)*EF.NaturalGas.CH41.2907496383488419E-26512.4048063190916617E-2-($AE53+$V53)*EF.IndustrialCoal.N2O2.8506273640912568E-22.4385241320413809E-2-($AG53+$X53)*EF.NaturalGas.N2O1.3882639878155642E-26516.6774154839482028E-218.003107907714249
000
679INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))TransportL56+L60+L61+L62502.50552967076953M56+M60+M61+M6216.246998166435951N56+N60+N61+N62161.72636929234235O56+O60+O61+O6248.041663833596701L55+M55+N55+O55728.52056096314448728.52056096314448T56+T60+T61+T62-8.1002794197444299W56+W60+W61+W62-720.42028154340005U55+T55+V55+W55+X55+Y55+Z55+AA55+AB55-728.52056096314448AE55+AF55+AG5500000BB55+BC55+BD5500R55+AC55+AW55+BF550$D55Transport-($AE55+$V55)*EF.IndustrialCoal.CO20180.10507038585001-($AG55+$X55)*EF.NaturalGas.CO20-$Y55*EF.BlastFurnaceGas.CO20180.10507038585001-($AE55+$V55)*EF.IndustrialCoal.CH400.22423010162038148-($AG55+$X55)*EF.NaturalGas.CH406510.22423010162038148-($AE55+$V55)*EF.IndustrialCoal.N2O03.2404592678539554-($AG55+$X55)*EF.NaturalGas.N2O06513.2404592678539554183.56975975532436
184$C$149[7]476-$AC56-$AW56161.72636929234235L56+M56+N56+O56161.72636929234235161.72636929234235-'DUKES 09 (1.2)'!$E$52*Unit.ktoe-161.72636929234235U56+T56+V56+W56+X56+Y56+Z56+AA56+AB56-161.72636929234235AE56+AF56+AG5600000000-($AE56+$V56)*EF.IndustrialCoal.CO2040.431592323085589-($AG56+$X56)*EF.NaturalGas.CO20-$Y56*EF.BlastFurnaceGas.CO2040.431592323085589-($AE56+$V56)*EF.IndustrialCoal.CH405.0337172828375784E-2-($AG56+$X56)*EF.NaturalGas.CH406515.0337172828375784E-2-($AE56+$V56)*EF.IndustrialCoal.N2O00.72744719388937817-($AG56+$X56)*EF.NaturalGas.N2O06510.7274471938893781741.209376689803342
4160000000000
41-$AC58-$AW588.7346938775510203L58+M58+N58+O588.73469387755102038.7346938775510203-2.14/0.245*Unit.TWh-8.7346938775510203U58+T58+V58+W58+X58+Y58+Z58+AA58+AB58-8.7346938775510203AE58+AF58+AG5800000000-($AE58+$V58)*EF.IndustrialCoal.CO202.1836734693877551-($AG58+$X58)*EF.NaturalGas.CO20-$Y58*EF.BlastFurnaceGas.CO202.1836734693877551-($AE58+$V58)*EF.IndustrialCoal.CH402.7186648487882679E-3-($AG58+$X58)*EF.NaturalGas.CH406512.7186648487882679E-3-($AE58+$V58)*EF.IndustrialCoal.N2O03.9288760259135309E-2-($AG58+$X58)*EF.NaturalGas.N2O06513.9288760259135309E-22.2256808944956785
461-$AC59-$AW59152.99167541479133L59+M59+N59+O59152.99167541479133152.99167541479133W56-W58-152.99167541479133U59+T59+V59+W59+X59+Y59+Z59+AA59+AB59-152.99167541479133AE59+AF59+AG5900000000-($AE59+$V59)*EF.IndustrialCoal.CO2038.247918853697833-($AG59+$X59)*EF.NaturalGas.CO20-$Y59*EF.BlastFurnaceGas.CO2038.247918853697833-($AE59+$V59)*EF.IndustrialCoal.CH404.7618507979587513E-2-($AG59+$X59)*EF.NaturalGas.CH406514.7618507979587513E-2-($AE59+$V59)*EF.IndustrialCoal.N2O00.68815843363024276-($AG59+$X59)*EF.NaturalGas.N2O06510.6881584336302427638.983695795307661
25477-$AC60-$AW6016.246998166435951L60+M60+N60+O6016.24699816643595116.246998166435951-'DUKES 09 (1.2)'!$I$53*Unit.ktoe-8.1002794197444299-'DUKES 09 (1.2)'!$E$53*Unit.ktoe-8.146718746691521U60+T60+V60+W60+X60+Y60+Z60+AA60+AB60-16.246998166435951AE60+AF60+AG6000000000-($AE60+$V60)*EF.IndustrialCoal.CO202.0366796866728802-($AG60+$X60)*EF.NaturalGas.CO20-$Y60*EF.BlastFurnaceGas.CO202.0366796866728802-($AE60+$V60)*EF.IndustrialCoal.CH402.5356581696031259E-3-($AG60+$X60)*EF.NaturalGas.CH406512.5356581696031259E-3-($AE60+$V60)*EF.IndustrialCoal.N2O03.6644040904511579E-2-($AG60+$X60)*EF.NaturalGas.N2O06513.6644040904511579E-22.0758593857469951
24$C$148[6]478-$AC61-$AW61502.50552967076953L61+M61+N61+O61502.50552967076953502.50552967076953-'DUKES 09 (1.2)'!$E$54*Unit.ktoe-'DUKES 09 (1.2)'!$G$54*Unit.ktoe-502.50552967076953U61+T61+V61+W61+X61+Y61+Z61+AA61+AB61-502.50552967076953AE61+AF61+AG6100000000-($AE61+$V61)*EF.IndustrialCoal.CO20125.62638241769238-($AG61+$X61)*EF.NaturalGas.CO20-$Y61*EF.BlastFurnaceGas.CO20125.62638241769238-($AE61+$V61)*EF.IndustrialCoal.CH400.15640435016832924-($AG61+$X61)*EF.NaturalGas.CH406510.15640435016832924-($AE61+$V61)*EF.IndustrialCoal.N2O02.2602760395376373-($AG61+$X61)*EF.NaturalGas.N2O06512.2602760395376373128.04306280739834
27479SUM(O64:O65)48.041663833596701L62+M62+N62+O6248.04166383359670148.041663833596701SUM(W64:W65)-48.041663833596701U62+T62+V62+W62+X62+Y62+Z62+AA62+AB62-48.041663833596701AE62+AF62+AG6200000000-($AE62+$V62)*EF.IndustrialCoal.CO2012.010415958399175-($AG62+$X62)*EF.NaturalGas.CO20-$Y62*EF.BlastFurnaceGas.CO2012.010415958399175-($AE62+$V62)*EF.IndustrialCoal.CH401.4952920454073357E-2-($AG62+$X62)*EF.NaturalGas.CH406511.4952920454073357E-2-($AE62+$V62)*EF.IndustrialCoal.N2O00.21609199352242864-($AG62+$X62)*EF.NaturalGas.N2O06510.2160919935224286412.241460872375677
4160000000000
185480-$AC64-$AW6418.81937240536579L64+M64+N64+O6418.8193724053657918.81937240536579-'DUKES 09 (1.2)'!$E$55*Unit.ktoe-18.81937240536579U64+T64+V64+W64+X64+Y64+Z64+AA64+AB64-18.81937240536579AE64+AF64+AG6400000000-($AE64+$V64)*EF.IndustrialCoal.CO204.7048431013414476-($AG64+$X64)*EF.NaturalGas.CO20-$Y64*EF.BlastFurnaceGas.CO204.7048431013414476-($AE64+$V64)*EF.IndustrialCoal.CH405.8575110876202584E-3-($AG64+$X64)*EF.NaturalGas.CH406515.8575110876202584E-3-($AE64+$V64)*EF.IndustrialCoal.N2O08.4649768043056892E-2-($AG64+$X64)*EF.NaturalGas.N2O06518.4649768043056892E-24.795350380472124
152480-$AC65-$AW6529.222291428230907L65+M65+N65+O6529.22229142823090729.222291428230907'DUKES 09 (1.2)'!$E$8*Unit.ktoe-29.222291428230907U65+T65+V65+W65+X65+Y65+Z65+AA65+AB65-29.222291428230907AE65+AF65+AG6500000000-($AE65+$V65)*EF.IndustrialCoal.CO207.3055728570577267-($AG65+$X65)*EF.NaturalGas.CO20-$Y65*EF.BlastFurnaceGas.CO207.3055728570577267-($AE65+$V65)*EF.IndustrialCoal.CH409.0954093664530975E-3-($AG65+$X65)*EF.NaturalGas.CH406519.0954093664530975E-3-($AE65+$V65)*EF.IndustrialCoal.N2O00.1314422254793717-($AG65+$X65)*EF.NaturalGas.N2O06510.13144222547937177.4461104919035517
000
680INDEX(Workstreams[Workstream], MATCH($C67, Workstreams[Code], 0))Food consumption [UNUSED]Q6859.09063200000000659.090632000000006AA68-65.656257777777782U67+T67+V67+W67+X67+Y67+Z67+AA67+AB67-65.656257777777782AE67+AF67+AG670000AY686.56562577777777896.5656257777777789BB67+BC67+BD6706.5656257777777789R67+AC67+AW67+BF670$D67Food consumption [UNUSED]-($AE67+$V67)*EF.IndustrialCoal.CO200-($AG67+$X67)*EF.NaturalGas.CO20-$Y67*EF.BlastFurnaceGas.CO200-($AE67+$V67)*EF.IndustrialCoal.CH400-($AG67+$X67)*EF.NaturalGas.CH406510-($AE67+$V67)*EF.IndustrialCoal.N2O00-($AG67+$X67)*EF.NaturalGas.N2O065100
44$C$154[8]475L68+M68+N68+O68060000000*2320000*Unit.calorie*365.2559.09063200000000659.090632000000006-Q68/0.9-65.656257777777782U68+T68+V68+W68+X68+Y68+Z68+AA68+AB68-65.656257777777782AE68+AF68+AG680000-0.1*$AA686.56562577777777896.5656257777777789BB68+BC68+BD6806.5656257777777789R68+AC68+AW68+BF680-($AE68+$V68)*EF.IndustrialCoal.CO200-($AG68+$X68)*EF.NaturalGas.CO20-$Y68*EF.BlastFurnaceGas.CO200-($AE68+$V68)*EF.IndustrialCoal.CH400-($AG68+$X68)*EF.NaturalGas.CH406510-($AE68+$V68)*EF.IndustrialCoal.N2O00-($AG68+$X68)*EF.NaturalGas.N2O065100
BB69+BC69+BD690000
675INDEX(Workstreams[Workstream], MATCH($C70, Workstreams[Code], 0))GeosequestrationL70+M70+N70+O700U70+T70+V70+W70+X70+Y70+Z70+AA70+AB700AE70+AF70+AG700000BB70+BC70+BD700$D70Geosequestration-($AE70+$V70)*EF.IndustrialCoal.CO200-($AG70+$X70)*EF.NaturalGas.CO20-$Y70*EF.BlastFurnaceGas.CO20-($AE70+$V70)*EF.IndustrialCoal.CH400-($AG70+$X70)*EF.NaturalGas.CH40-($AE70+$V70)*EF.IndustrialCoal.N2O00-($AG70+$X70)*EF.NaturalGas.N2O0
000
619I$9+I$21+I$30+I$55+I$67+I$70582.62431955664806146.69564603235992444.82296266790246502.5055296707695316.246998166435951161.7263692923423548.041663833596701728.5205609631444859.0906320000000061961.7541212200549T$9+T$21+T$30+T$55+T$67+T$70-339.35117296651214U$9+U$21+U$30+U$55+U$67+U$7034.033592131949163V$9+V$21+V$30+V$55+V$67+V$70-103.7063896744209W$9+W$21+W$30+W$55+W$67+W$70-855.85813688872099X$9+X$21+X$30+X$55+X$67+X$70-703.76729339052758Y$9+Y$21+Y$30+Y$55+Y$67+Y$70-0.110456222299999850.76341783423913068-65.6562577777777820-2033.652696954071AE$9+AE$21+AE$30+AE$55+AE$67+AE$7000000-0.53605914770000007-1.705027184782586000-0.944815330000000060-8.2710417805540501-11.456943443036636-13.0513324077260880-20.468577340057742-33.519909747783828-44.976853190820457AY$9+AY$21+AY$30+AY$55+AY$67+AY$70112.759398200965684.1160307238708489116.87542892483653000BB72+BC72+BD720116.87542892483653R72+AC72+AW72+BF720$D72Total consumption-($AE72+$V72)*EF.IndustrialCoal.CO231.941568019721633213.96453422218025-($AG72+$X72)*EF.NaturalGas.CO2129.49318198385706-$Y72*EF.BlastFurnaceGas.CO28.6688539495683642E-2375.48597276525464-($AE72+$V72)*EF.IndustrialCoal.CH49.3832783920110727E-20.26638500042787472-($AG72+$X72)*EF.NaturalGas.CH40.259567232612123226510.61978501696010868-($AE72+$V72)*EF.IndustrialCoal.N2O0.282954809496414773.8496604033796897-($AG72+$X72)*EF.NaturalGas.N2O0.279177177933066966514.4117923908091718380.51755017302395
-($AF73+$W73+$BD73)*EF.Diesel.CO20-($AF73+$W73+$BD73)*EF.Diesel.CH40-($AF73+$W73+$BD73)*EF.Diesel.N2O0
72-($AE74+$V74)*EF.IndustrialCoal.CO200-($AG74+$X74)*EF.NaturalGas.CO20-$Y74*EF.BlastFurnaceGas.CO20-($AE74+$V74)*EF.IndustrialCoal.CH400-($AG74+$X74)*EF.NaturalGas.CH40-($AE74+$V74)*EF.IndustrialCoal.N2O00-($AG74+$X74)*EF.NaturalGas.N2O0
000
672INDEX(Workstreams[Workstream], MATCH($C76, Workstreams[Code], 0))Agriculture and wasteL76+M76+N76+O760I76+J76+K76+P76+Q760T77+T78+T83-4.1248585661758046V77+V78+V83-3.111111111111111E-2W77+W78+W83-3.4235639577796366X77+X78+X83-1.9989202658570244AA77+AA78+AA8365.656257777777782U76+T76+V76+W76+X76+Y76+Z76+AA76+AB7656.077803876854205AE77+AE78+AE830AF77+AF78+AF830AG77+AG78+AG830AE76+AF76+AG760AJ77+AJ78+AJ83-54.00076878455662AQ77+AQ78+AQ8318.169646022165825AJ76+AK76+AL76+AM76+AN76+AO76+AP76+AQ76-35.831122762390791AS77+AS78+AS830AS76+AT76+AU760AH76+AI76+AR76+AV76-35.831122762390791AY77+AY78+AY8310.414277248076411AY76+AZ7610.414277248076411BB77+BB78+BB83-26.262503111111116BC77+BC78+BC83-4.3984552514287021BB76+BC76+BD76-30.660958362539816BA76+BE76-20.246681114463406R76+AC76+AW76+BF760$D76Agriculture and waste-($AE76+$V76)*EF.IndustrialCoal.CO29.5822222222222194E-30.85589098944490916-($AG76+$X76)*EF.NaturalGas.CO20.3678013289176924-$Y76*EF.BlastFurnaceGas.CO20$BK76+$BL76+$BM76+$BN761.2332745405848238-($AE76+$V76)*EF.IndustrialCoal.CH42.8149106102027129E-51.0655809030142595E-3-($AG76+$X76)*EF.NaturalGas.CH47.372525073183247E-4651BP76+BQ76+BR761.8309825164346113E-3-($AE76+$V76)*EF.IndustrialCoal.N2O8.4884244310333935E-51.5399232698322449E-2-($AG76+$X76)*EF.NaturalGas.N2O7.9295091428113686E-4651BU76+BV76+BW761.6277067856913921E-2BO76+BT76+BY76+BZ761.2513825909581724
481$C$156[9]484L77+M77+N77+O7700-'DUKES 09 (1.2)'!$I$61*Unit.ktoe-4.1248585661758046-'DUKES 09 (1.2)'!$B$61*Unit.ktoe-3.111111111111111E-2-'DUKES 09 (1.2)'!$E$61*Unit.ktoe-3.4235639577796366-'DUKES 09 (1.2)'!$F$61*Unit.ktoe-1.9989202658570244U77+T77+V77+W77+X77+Y77+Z77+AA77+AB77-9.5784539009235772AE77+AF77+AG770-'DUKES 09 (7.2)'!$E$64*Unit.ktoe-0.83582334715283335-0.835823347152833350-0.83582334715283335-$AC77-$AW7710.41427724807641110.414277248076411010.4142772480764110-($AE77+$V77)*EF.IndustrialCoal.CO29.5822222222222194E-30.85589098944490916-($AG77+$X77)*EF.NaturalGas.CO20.3678013289176924-$Y77*EF.BlastFurnaceGas.CO201.2332745405848238-($AE77+$V77)*EF.IndustrialCoal.CH42.8149106102027129E-51.0655809030142595E-3-($AG77+$X77)*EF.NaturalGas.CH47.372525073183247E-46511.8309825164346113E-3-($AE77+$V77)*EF.IndustrialCoal.N2O8.4884244310333935E-51.5399232698322449E-2-($AG77+$X77)*EF.NaturalGas.N2O7.9295091428113686E-46511.6277067856913921E-21.2513825909581724
599$C$164[14]0U78+T78+V78+W78+X78+Y78+Z78+AA78+AB780AE78+AF78+AG780AJ80+AJ81+AJ82-14.607014117889955AQ80+AQ81+AQ8219.0054693693186574.398455251428702104.39845525142870210BC80+BC81+BC82-4.3984552514287021-4.3984552514287021-4.39845525142870210-($AE78+$V78)*EF.IndustrialCoal.CO200-($AG78+$X78)*EF.NaturalGas.CO20-$Y78*EF.BlastFurnaceGas.CO200-($AE78+$V78)*EF.IndustrialCoal.CH400-($AG78+$X78)*EF.NaturalGas.CH406510-($AE78+$V78)*EF.IndustrialCoal.N2O00-($AG78+$X78)*EF.NaturalGas.N2O065100
4160000000000
223L80+M80+N80+O8000U80+T80+V80+W80+X80+Y80+Z80+AA80+AB800AE80+AF80+AG800-AQ80-3.8611111111111107'DUKES 09 (7.2)'!$C$8*Unit.ktoe3.86111111111111070000000-($AE80+$V80)*EF.IndustrialCoal.CO200-($AG80+$X80)*EF.NaturalGas.CO20-$Y80*EF.BlastFurnaceGas.CO200-($AE80+$V80)*EF.IndustrialCoal.CH400-($AG80+$X80)*EF.NaturalGas.CH406510-($AE80+$V80)*EF.IndustrialCoal.N2O00-($AG80+$X80)*EF.NaturalGas.N2O065100
600L81+M81+N81+O8100U81+T81+V81+W81+X81+Y81+Z81+AA81+AB810AE81+AF81+AG810-AQ81-BC81-5.752538880136143'DUKES 09 (7.2)'!$E$15*Unit.ktoe10.1509941315648454.398455251428702104.39845525142870210-'DUKES 09 (7.2)'!$E$10*Unit.ktoe-4.3984552514287021-4.3984552514287021-4.39845525142870210-($AE81+$V81)*EF.IndustrialCoal.CO200-($AG81+$X81)*EF.NaturalGas.CO20-$Y81*EF.BlastFurnaceGas.CO200-($AE81+$V81)*EF.IndustrialCoal.CH400-($AG81+$X81)*EF.NaturalGas.CH406510-($AE81+$V81)*EF.IndustrialCoal.N2O00-($AG81+$X81)*EF.NaturalGas.N2O065100
613L82+M82+N82+O8200U82+T82+V82+W82+X82+Y82+Z82+AA82+AB820AE82+AF82+AG820-AQ82-4.9933641266427014-AQ1074.99336412664270140000000-($AE82+$V82)*EF.IndustrialCoal.CO200-($AG82+$X82)*EF.NaturalGas.CO20-$Y82*EF.BlastFurnaceGas.CO200-($AE82+$V82)*EF.IndustrialCoal.CH400-($AG82+$X82)*EF.NaturalGas.CH406510-($AE82+$V82)*EF.IndustrialCoal.N2O00-($AG82+$X82)*EF.NaturalGas.N2O065100
42$C$161[12]475L83+M83+N83+O8300-AA6865.656257777777782U83+T83+V83+W83+X83+Y83+Z83+AA83+AB8365.656257777777782AE83+AF83+AG830AA68*60%-39.393754666666666-39.3937546666666660-39.393754666666666040%*AA68-26.262503111111116-26.262503111111116-26.2625031111111160-($AE83+$V83)*EF.IndustrialCoal.CO200-($AG83+$X83)*EF.NaturalGas.CO20-$Y83*EF.BlastFurnaceGas.CO200-($AE83+$V83)*EF.IndustrialCoal.CH400-($AG83+$X83)*EF.NaturalGas.CH406510-($AE83+$V83)*EF.IndustrialCoal.N2O00-($AG83+$X83)*EF.NaturalGas.N2O065100
00000
74INDEX(Workstreams[Workstream], MATCH($C85, Workstreams[Code], 0))Hydrocarbon fuel power generationL85+M85+N85+O8500T860U86276.53401618322465V86-371.39618674674301W86-8.718214578336493X86-319.83646584224255Z860U85+T85+V85+W85+X85+Y85+Z85+AA85+AB85-423.41685098409744AF860AE85+AF85+AG850AQ86-4.9052401149690734-4.9052401149690734AS86-2.3660032518434662-2.3660032518434662-7.2712433668125396AY86420.41209536783174AZ8610.275998983078262430.688094350909980430.68809435090998R85+AC85+AW85+BF850$D85Hydrocarbon fuel power generation-($AE85+$V85)*EF.IndustrialCoal.CO2114.390025517996832.1795536445841233-($AG85+$X85)*EF.NaturalGas.CO258.849909714972618-$Y85*EF.BlastFurnaceGas.CO20175.41948887755356-($AE85+$V85)*EF.IndustrialCoal.CH40.336036557141432712.7135356831717895E-3-($AG85+$X85)*EF.NaturalGas.CH40.117963802959858026510.45671389578446253-($AE85+$V85)*EF.IndustrialCoal.N2O1.01332557809154473.9214636169023563E-2-($AG85+$X85)*EF.NaturalGas.N2O0.126875805074355066511.1794160193349232177.05561879267296
159581L86+M86+N86+O8600U88+U89+U90+U91276.53401618322465V88+V89+V90+V91-371.39618674674301W88+W89+W90+W91-8.718214578336493X88+X89+X90+X91-319.83646584224255U86+T86+V86+W86+X86+Y86+Z86+AA86+AB86-423.41685098409744AE86+AF86+AG860AQ88+AQ89+AQ90+AQ91-4.9052401149690734-4.9052401149690734AS88+AS89+AS90+AS91-2.3660032518434662-2.3660032518434662-7.2712433668125396AY88+AY89+AY90+AY91420.41209536783174AZ88+AZ89+AZ90+AZ9110.275998983078262430.688094350909980430.688094350909980-($AE86+$V86)*EF.IndustrialCoal.CO2114.390025517996832.1795536445841233-($AG86+$X86)*EF.NaturalGas.CO258.849909714972618-$Y86*EF.BlastFurnaceGas.CO20175.41948887755356-($AE86+$V86)*EF.IndustrialCoal.CH40.336036557141432712.7135356831717895E-3-($AG86+$X86)*EF.NaturalGas.CH40.117963802959858026510.45671389578446253-($AE86+$V86)*EF.IndustrialCoal.N2O1.01332557809154473.9214636169023563E-2-($AG86+$X86)*EF.NaturalGas.N2O0.126875805074355066511.1794160193349232177.05561879267296
4160000000000
141C$157[10]L88+M88+N88+O8800('DUKES 09 (5.6)'!$B$246-'DUKES 09 (5.6)'!$B$247)*Unit.GWh125.93794534209844-'DUKES 09 (5.6)'!$B$245*Unit.GWh-371.39618674674301U88+T88+V88+W88+X88+Y88+Z88+AA88+AB88-245.45824140464458AE88+AF88+AG880000-$AC88-$AW88-$AZ88238.72086653696022'DUKES 09 (5.6)'!$B$247*Unit.GWh6.7373748676843679245.458241404644580245.458241404644580-($AE88+$V88)*EF.IndustrialCoal.CO2114.390025517996830-($AG88+$X88)*EF.NaturalGas.CO20-$Y88*EF.BlastFurnaceGas.CO20114.39002551799683-($AE88+$V88)*EF.IndustrialCoal.CH40.336036557141432710-($AG88+$X88)*EF.NaturalGas.CH406510.33603655714143271-($AE88+$V88)*EF.IndustrialCoal.N2O1.01332557809154470-($AG88+$X88)*EF.NaturalGas.N2O06511.0133255780915447115.7393876532298
202C$157[10]L89+M89+N89+O8900('DUKES 09 (5.6)'!$C$246-'DUKES 09 (5.6)'!$C$247)*Unit.GWh1.9959590190899115-'DUKES 09 (5.6)'!$C$245*Unit.GWh-8.718214578336493U89+T89+V89+W89+X89+Y89+Z89+AA89+AB89-6.722255559246582AE89+AF89+AG890000-$AC89-$AW89-$AZ896.3174518861840294'DUKES 09 (5.6)'!$C$247*Unit.GWh0.404803673062552886.72225555924658206.7222555592465820-($AE89+$V89)*EF.IndustrialCoal.CO202.1795536445841233-($AG89+$X89)*EF.NaturalGas.CO20-$Y89*EF.BlastFurnaceGas.CO202.1795536445841233-($AE89+$V89)*EF.IndustrialCoal.CH402.7135356831717895E-3-($AG89+$X89)*EF.NaturalGas.CH406512.7135356831717895E-3-($AE89+$V89)*EF.IndustrialCoal.N2O03.9214636169023563E-2-($AG89+$X89)*EF.NaturalGas.N2O06513.9214636169023563E-22.2214818164363188
14C$157[10]L90+M90+N90+O9000('DUKES 09 (5.6)'!$D$246-'DUKES 09 (5.6)'!$D$247)*Unit.GWh146.45188162344687-'DUKES 09 (5.6)'!$D$245*Unit.GWh-319.83646584224255U90+T90+V90+W90+X90+Y90+Z90+AA90+AB90-173.38458421879568AE90+AF90+AG900000-$AC90-$AW90-$AZ90170.49051986783476'DUKES 09 (5.6)'!$D$247*Unit.GWh2.8940643509609218173.384584218795680173.384584218795680-($AE90+$V90)*EF.IndustrialCoal.CO200-($AG90+$X90)*EF.NaturalGas.CO258.849909714972618-$Y90*EF.BlastFurnaceGas.CO2058.849909714972618-($AE90+$V90)*EF.IndustrialCoal.CH400-($AG90+$X90)*EF.NaturalGas.CH40.117963802959858026510.11796380295985802-($AE90+$V90)*EF.IndustrialCoal.N2O00-($AG90+$X90)*EF.NaturalGas.N2O0.126875805074355066510.1268758050743550659.09474932300683
51C$157[10]L91+M91+N91+O9100('DUKES 09 (5.6)'!$F$246-'DUKES 09 (5.6)'!$F$247)*Unit.GWh2.1482301985894212U91+T91+V91+W91+X91+Y91+Z91+AA91+AB912.1482301985894212AE91+AF91+AG910-'DUKES 09 (7.2)'!$E$20*Unit.ktoe-4.9052401149690734-4.9052401149690734-('DUKES 09 (7.2)'!$D$20+'DUKES 09 (7.2)'!$J$20)*Unit.ktoe-2.3660032518434662-2.3660032518434662-7.2712433668125396-$AC91-$AW91-$AZ914.8832570768526988'DUKES 09 (5.6)'!$F$247*Unit.GWh0.23975609137041925.123013168223118405.12301316822311840-($AE91+$V91)*EF.IndustrialCoal.CO200-($AG91+$X91)*EF.NaturalGas.CO20-$Y91*EF.BlastFurnaceGas.CO200-($AE91+$V91)*EF.IndustrialCoal.CH400-($AG91+$X91)*EF.NaturalGas.CH406510-($AE91+$V91)*EF.IndustrialCoal.N2O00-($AG91+$X91)*EF.NaturalGas.N2O065100
00000
75INDEX(Workstreams[Workstream], MATCH($C93, Workstreams[Code], 0))Nuclear power generationL93+M93+N93+O9300U9457.248895000000005U93+T93+V93+W93+X93+Y93+Z93+AA93+AB9357.248895000000005AE93+AF93+AG930AI94-163.2444768304506200-163.24447683045062AY94100.21613413351562AZ945.7794476969349997105.995581830450620105.99558183045062R93+AC93+AW93+BF930$D93Nuclear power generation-($AE93+$V93)*EF.IndustrialCoal.CO200-($AG93+$X93)*EF.NaturalGas.CO20-$Y93*EF.BlastFurnaceGas.CO200-($AE93+$V93)*EF.IndustrialCoal.CH400-($AG93+$X93)*EF.NaturalGas.CH406510-($AE93+$V93)*EF.IndustrialCoal.N2O00-($AG93+$X93)*EF.NaturalGas.N2O065100
580C$157[10]581L94+M94+N94+O9400('DUKES 09 (5.6)'!$E$246-'DUKES 09 (5.6)'!$E$247)*Unit.GWh57.248895000000005U94+T94+V94+W94+X94+Y94+Z94+AA94+AB9457.248895000000005AE94+AF94+AG940-'DUKES 09 (5.6)'!$E$245*Unit.GWh-163.2444768304506200-163.24447683045062-$AC94-$AW94-$AZ94100.21613413351562'DUKES 09 (5.6)'!$E$247*Unit.GWh5.7794476969349997105.995581830450620105.99558183045062R94+AC94+AW94+BF940-($AE94+$V94)*EF.IndustrialCoal.CO200-($AG94+$X94)*EF.NaturalGas.CO20-$Y94*EF.BlastFurnaceGas.CO200-($AE94+$V94)*EF.IndustrialCoal.CH400-($AG94+$X94)*EF.NaturalGas.CH406510-($AE94+$V94)*EF.IndustrialCoal.N2O00-($AG94+$X94)*EF.NaturalGas.N2O065100
00000
76INDEX(Workstreams[Workstream], MATCH($C96, Workstreams[Code], 0))National renewable power generationL96+M96+N96+O9600U97+U98+U99+U100+U101+U1027.6825918850000008U96+T96+V96+W96+X96+Y96+Z96+AA96+AB967.6825918850000008AE96+AF96+AG960AK97+AK98+AK99+AK100+AK101+AK102-3.5688367850000002AO97+AO98+AO99+AO100+AO101+AO102-4.1435790100000007-7.7124157950000010-7.712415795000001AY97+AY98+AY99+AY100+AY101+AY1021.0755285551056204E-16AZ97+AZ98+AZ99+AZ100+AZ101+AZ1022.9823910000000068E-22.9823910000000176E-202.9823910000000176E-2R96+AC96+AW96+BF960$D96National renewable power generation-($AE96+$V96)*EF.IndustrialCoal.CO200-($AG96+$X96)*EF.NaturalGas.CO20-$Y96*EF.BlastFurnaceGas.CO200-($AE96+$V96)*EF.IndustrialCoal.CH400-($AG96+$X96)*EF.NaturalGas.CH406510-($AE96+$V96)*EF.IndustrialCoal.N2O00-($AG96+$X96)*EF.NaturalGas.N2O065100
1C$159[11]586L97+M97+N97+O9700'DUKES 09 (5.6)'!$L$245*Unit.GWh3.56883678500000023.56883678500000020-'DUKES 09 (5.6)'!$L$248*Unit.GWh-3.5688367850000002-3.56883678500000020-3.5688367850000002000000000000651000065100
69[11]586L98+M98+N98+O9800('DUKES 09 (5.6)'!$J$246-'DUKES 09 (5.6)'!$J$247)*Unit.GWh4.11375510000000064.11375510000000060-'DUKES 09 (5.6)'!$J$245*Unit.GWh-4.1435790100000007-4.14357901000000070-4.1435790100000007-AC98-AW98-AZ981.0755285551056204E-16'DUKES 09 (5.6)'!$J$247*Unit.GWh2.9823910000000068E-22.9823910000000176E-202.9823910000000176E-2000000000651000065100
2[11]0000000000000000000651000065100
68[11]0000000000000000000651000065100
70[11]0000000000000000000651000065100
3[11]0000000000000000000651000065100
00000
77INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))Distributed renewable power generation00U104+T104+V104+W104+X104+Y104+Z104+AA104+AB1040AE104+AF104+AG1040000000R104+AC104+AW104+BF1040$D104Distributed renewable power generation-($AE104+$V104)*EF.IndustrialCoal.CO200-($AG104+$X104)*EF.NaturalGas.CO20-$Y104*EF.BlastFurnaceGas.CO200-($AE104+$V104)*EF.IndustrialCoal.CH400-($AG104+$X104)*EF.NaturalGas.CH406510-($AE104+$V104)*EF.IndustrialCoal.N2O00-($AG104+$X104)*EF.NaturalGas.N2O065100
00000
671INDEX(Workstreams[Workstream], MATCH($C106, Workstreams[Code], 0))Bioenergy00W1074.5999123584699992U106+T106+V106+W106+X106+Y106+Z106+AA106+AB1064.5999123584699992AE106+AF106+AG1060AQ107-4.9933641266427014-4.99336412664270140-4.99336412664270140BB1070.393451768172702110.393451768172702110.39345176817270211R106+AC106+AW106+BF1060$D106Bioenergy-($AE106+$V106)*EF.IndustrialCoal.CO20-1.1499780896174998-($AG106+$X106)*EF.NaturalGas.CO20-$Y106*EF.BlastFurnaceGas.CO20-1.1499780896174998-($AE106+$V106)*EF.IndustrialCoal.CH40-1.4317181817464419E-3-($AG106+$X106)*EF.NaturalGas.CH40651-1.4317181817464419E-3-($AE106+$V106)*EF.IndustrialCoal.N2O0-2.0690462241549329E-2-($AG106+$X106)*EF.NaturalGas.N2O0651-2.0690462241549329E-2-1.1721002700407956
609$C$166[15]00'DUKES 09 (7.2)'!$N$8*Unit.ktoe4.5999123584699992U107+T107+V107+W107+X107+Y107+Z107+AA107+AB1074.5999123584699992AE107+AF107+AG1070-$W107-$BB107-4.9933641266427014-4.99336412664270140-4.99336412664270140-'DUKES 09 (7.2)'!$N$11*Unit.ktoe0.393451768172702110.393451768172702110.39345176817270211R107+AC107+AW107+BF1070-($AE107+$V107)*EF.IndustrialCoal.CO20-1.1499780896174998-($AG107+$X107)*EF.NaturalGas.CO20-$Y107*EF.BlastFurnaceGas.CO20-1.1499780896174998-($AE107+$V107)*EF.IndustrialCoal.CH40-1.4317181817464419E-3-($AG107+$X107)*EF.NaturalGas.CH40651-1.4317181817464419E-3-($AE107+$V107)*EF.IndustrialCoal.N2O0-2.0690462241549329E-2-($AG107+$X107)*EF.NaturalGas.N2O0651-2.0690462241549329E-2-1.1721002700407956
00000
674INDEX(Workstreams[Workstream], MATCH($C109, Workstreams[Code], 0))H2 Production00U109+T109+V109+W109+X109+Y109+Z109+AA109+AB1090AE109+AF109+AG1090000000R109+AC109+AW109+BF1090$D109H2 Production-($AE109+$V109)*EF.IndustrialCoal.CO200-($AG109+$X109)*EF.NaturalGas.CO20-$Y109*EF.BlastFurnaceGas.CO200-($AE109+$V109)*EF.IndustrialCoal.CH400-($AG109+$X109)*EF.NaturalGas.CH406510-($AE109+$V109)*EF.IndustrialCoal.N2O00-($AG109+$X109)*EF.NaturalGas.N2O065100
000
249I$76+I$85+I$93+I$96+I$104+I$106+I$1090000000000T$76+T$85+T$93+T$96+T$104+T$106+T$109-4.1248585661758046341.46550306822468-371.42729785785411-7.5418661776461304-321.835386108099560065.6562577777777820-297.80764786377318AE$76+AE$85+AE$93+AE$96+AE$104+AE$106+AE$1090000-163.24447683045062-54.00076878455662-3.5688367850000002000-4.143579010000000708.2710417805540501-53.442142799002568-2.366003251843466200-2.3660032518434662-219.05262288129663AY$76+AY$85+AY$93+AY$96+AY$104+AY$106+AY$109531.0425067494237516.085270590013263547.12777733943699-25.869051342938413-4.39845525142870210-30.267506594367113516.8602707450699R111+AC111+AW111+BF1110$D111Total supply-($AE111+$V111)*EF.IndustrialCoal.CO2114.399607740219041.8854665444115326-($AG111+$X111)*EF.NaturalGas.CO259.217711043890311-$Y111*EF.BlastFurnaceGas.CO20175.50278532852087-($AE111+$V111)*EF.IndustrialCoal.CH40.336064706247534712.3473984044396069E-3-($AG111+$X111)*EF.NaturalGas.CH40.118701055467176346510.45711316011915065-($AE111+$V111)*EF.IndustrialCoal.N2O1.01341046233585493.3923406625796682E-2-($AG111+$X111)*EF.NaturalGas.N2O0.12766875598863626511.1750026249502878177.1349011135903
000
768-($AE113+$V113)*EF.IndustrialCoal.CO200-($AG113+$X113)*EF.NaturalGas.CO20-$Y113*EF.BlastFurnaceGas.CO20-($AE113+$V113)*EF.IndustrialCoal.CH400-($AG113+$X113)*EF.NaturalGas.CH40-($AE113+$V113)*EF.IndustrialCoal.N2O00-($AG113+$X113)*EF.NaturalGas.N2O0
000
673INDEX(Workstreams[Workstream], MATCH($C115, Workstreams[Code], 0))Electricity distribution, storage, and balancingI116+I120+I121+I123+I122+I124+I126+I1250000000L115+M115+N115+O1150Q116+Q120+Q121+Q123+Q122+Q124+Q126+Q1250I115+J115+K115+P115+Q1150T116+T120+T121+T123+T122+T124+T126+T125344.45990824777186-375.49909520017383475.13368753227502954.997661453441541025.60267949862710-0.7862591642391313400U115+T115+V115+W115+X115+Y115+Z115+AA115+AB1152423.9085823677028AE116+AE120+AE121+AE123+AE122+AE124+AE126+AE125-475.13368753227502AF116+AF120+AF121+AF123+AF122+AF124+AF126+AF125-1067.2164050197666AG116+AG120+AG121+AG123+AG122+AG124+AG126+AG125-1045.8878863613475AE115+AF115+AG115-2588.2379789133893AJ116+AJ120+AJ121+AJ123+AJ122+AJ124+AJ126+AJ12500000000AJ115+AK115+AL115+AM115+AN115+AO115+AP115+AQ1150AS116+AS120+AS121+AS123+AS122+AS124+AS126+AS1250AT116+AT120+AT121+AT123+AT122+AT124+AT126+AT1250AU116+AU120+AU121+AU123+AU122+AU124+AU126+AU12500-2588.2379789133893AY116+AY120+AY121+AY123+AY122+AY124+AY126+AY125-2.0291879444048226AZ116+AZ120+AZ121+AZ123+AZ122+AZ124+AZ126+AZ125110.9920548437758108.96286689937098BB116+BB120+BB121+BB123+BB122+BB124+BB126+BB1250BC116+BC120+BC121+BC123+BC122+BC124+BC126+BC125-5.2145242500000002BD116+BD120+BD121+BD123+BD122+BD124+BD126+BD12560.581053896315709BB115+BC115+BD11555.366529646315712BA115+BE115164.32939654568668R115+AC115+AW115+BF1152.2737367544323206E-13$D115Electricity distribution, storage, and balancing-($AE115+$V115)*EF.IndustrialCoal.CO2012.909422417502345-($AG115+$X115)*EF.NaturalGas.CO23.7324780627405372-$Y115*EF.BlastFurnaceGas.CO2016.641900480242882-($AE115+$V115)*EF.IndustrialCoal.CH401.6072179946603007E-2-($AG115+$X115)*EF.NaturalGas.CH47.4816989333986467E-36512.3553878880001655E-2-($AE115+$V115)*EF.IndustrialCoal.N2O00.23226696186740817-($AG115+$X115)*EF.NaturalGas.N2O8.0469309371275256E-36510.2403138928045356916.905768251927419
162L116+M116+N116+O1160I116+J116+K116+P116+Q1160T118+T119-6.6955015551946326W118+W119977.96119331050966X118+X119-2.4413780829676046Z118+Z119-0.78625916423913134U116+T116+V116+W116+X116+Y116+Z116+AA116+AB116968.0380545081083AF118+AF119-1029.5988829805192AE116+AF116+AG116-1029.5988829805192AJ116+AK116+AL116+AM116+AN116+AO116+AP116+AQ1160AS116+AT116+AU1160AH116+AI116+AR116+AV116-1029.5988829805192AY118+AY119-3.2412277634048223AZ118+AZ11964.802056235815712AY116+AZ11661.56082847241089061.560828472410890-($AE116+$V116)*EF.IndustrialCoal.CO2012.909422417502384-($AG116+$X116)*EF.NaturalGas.CO20.44921356726603917-$Y116*EF.BlastFurnaceGas.CO2013.358635984768423-($AE116+$V116)*EF.IndustrialCoal.CH401.6072179946603055E-2-($AG116+$X116)*EF.NaturalGas.CH49.0044217557030493E-4651BP116+BQ116+BR1161.6972622122173361E-2-($AE116+$V116)*EF.IndustrialCoal.N2O00.23226696186740886-($AG116+$X116)*EF.NaturalGas.N2O9.6846933620190671E-4651BU116+BV116+BW1160.23323543120361076BO116+BT116+BY116+BZ11613.608844038094206
416I117+J117+K117+P117+Q1170AS117+AT117+AU117000000000
158485L118+M118+N118+O1180I118+J118+K118+P118+Q1180'DUKES 09 (1.2)'!$E$20*Unit.ktoe1032.840110743924U118+T118+V118+W118+X118+Y118+Z118+AA118+AB1181032.840110743924'DUKES 09 (1.2)'!$D$20*Unit.ktoe-1029.5988829805192AE118+AF118+AG118-1029.5988829805192AJ118+AK118+AL118+AM118+AN118+AO118+AP118+AQ1180AS118+AT118+AU1180-1029.5988829805192-$AC118-$AW118-3.2412277634048223-3.24122776340482230-3.24122776340482230-($AE118+$V118)*EF.IndustrialCoal.CO20-0.81030694085120558-($AG118+$X118)*EF.NaturalGas.CO20-$Y118*EF.BlastFurnaceGas.CO20-0.81030694085120558-($AE118+$V118)*EF.IndustrialCoal.CH40-1.0088289424695796E-3-($AG118+$X118)*EF.NaturalGas.CH40651BP118+BQ118+BR118-1.0088289424695796E-3-($AE118+$V118)*EF.IndustrialCoal.N2O0-1.4579082258274777E-2-($AG118+$X118)*EF.NaturalGas.N2O0651BU118+BV118+BW118-1.4579082258274777E-2BO118+BT118+BY118+BZ118-0.8258948520519499
165587L119+M119+N119+O1190I119+J119+K119+P119+Q1190-'DUKES 09 (1.2)'!$I$28*Unit.ktoe-6.6955015551946326-'DUKES 09 (1.2)'!$E$28*Unit.ktoe-54.878917433414344-'DUKES 09 (1.2)'!$F$28*Unit.ktoe-2.4413780829676046-'DUKES 09 (1.2)'!$J$28*Unit.ktoe-0.78625916423913134-64.8020562358157120AJ119+AK119+AL119+AM119+AN119+AO119+AP119+AQ1190AS119+AT119+AU11900-$AC119-$AW11964.80205623581571264.802056235815712064.8020562358157120013.7197293583535860.44921356726603917014.16894292561962501.708100888907263E-29.0044217557030493E-4651BP119+BQ119+BR1191.7981451064642936E-200.246846044125683569.6846933620190671E-4651BU119+BV119+BW1190.24781451346188546BO119+BT119+BY119+BZ11914.434738890146154
810('DUKES 09 (1.2)'!$E$6+'DUKES 09 (1.2)'!$E$7)*Unit.ktoe-60.581053896315709-60.581053896315709000-W12060.58105389631570960.58105389631570960.581053896315709R120+AC120+AW120+BF1200000
590591L121+M121+N121+O1210I121+J121+K121+P121+Q1210-'DUKES 09 (1.2)'!$I$34*Unit.ktoe-1.8634191446533293-'DUKES 09 (1.2)'!$F$34*Unit.ktoe-5.7757409066725032-7.63916005132583290AJ121+AK121+AL121+AM121+AN121+AO121+AP121+AQ1210AS121+AT121+AU12100-$AC121-$AW1217.63916005132583297.639160051325832907.6391600513258329R121+AC121+AW121+BF1210001.06273632682774030$BK121+$BL121+$BM121+$BN1211.0627363268277403002.1302397788436297E-3651BP121+BQ121+BR1212.1302397788436297E-3002.2911764470171748E-3651BU121+BV121+BW1212.2911764470171748E-3BO121+BT121+BY121+BZ1211.0671577430536012
807C167[16]-(V72+V111+V116+V121)475.13368753227502'DUKES 09 (1.2)'!$E$14*Unit.ktoe37.617522039247504-(X72+X111+X116+X121)1033.81979848826721546.5710080597896-V122-475.13368753227502-W122-37.617522039247504-X122-1033.8197984882672-1546.57100805978960AS122+AT122+AU1220-1546.5710080597896000R122+AC122+AW122+BF12200000000000
665580-'DUKES 09 (1.2)'!$F$35*Unit.ktoe-12.068087873080305-12.0680878730803050AS123+AT123+AU1230-12.068087873080305'DUKES 09 (1.2)'!$F$35*Unit.ktoe12.06808787308030512.068087873080305012.068087873080305R123+AC123+AW123+BF1230002.220528168646775902.2205281686467759004.4510169789847486E-3651BP123+BQ123+BR1234.4510169789847486E-3004.7872851539084819E-3651BU123+BV123+BW1234.7872851539084819E-3BO123+BT123+BY123+BZ1232.2297664707796692
168605('DUKES 09 (5.6)'!$K$248-'DUKES 09 (5.6)'!$M$249)*Unit.GWh-1.2254999999999996-1.22549999999999960000('DUKES 09 (5.6)'!$M$249-'DUKES 09 (5.6)'!$K$245)*Unit.GWh1.2120398189999997'DUKES 09 (5.6)'!$K$247*Unit.GWh1.346018099999992E-21.225499999999999601.2254999999999996000000000651000065100
60858-U125-AZ125353.01882894761985-(U72+U111+U124+U126)-379.48811945017383-26.46929050255397400AS125+AT125+AU1250AH125+AI125+AR125+AV1250'DUKES 09 (1.2)'!$I$35*Unit.ktoe26.469290502553953AY125+AZ12526.469290502553953026.469290502553953R125+AC125+AW125+BF12500000$BK125+$BL125+$BM125+$BN1250000651BP125+BQ125+BR1250000651BU125+BV125+BW1250BO125+BT125+BY125+BZ1250
607606('DUKES 09 (5.1)'!$K$9+'DUKES 09 (5.1)'!$K$10)*Unit.GWh5.21452425000000025.214524250000000200000-$U126-5.2145242500000002-5.2145242500000002-5.2145242500000002000000000651000065100
000
000
769I$1150J$115000000000344.45990824777186U$115-375.49909520017383V$115475.13368753227502W$115954.99766145344154X$1151025.6026794986271Y$1150-0.78625916423913134002423.9085823677028-475.13368753227502-1067.2164050197666-1045.8878863613475-2588.237978913389300000000000000-2588.2379789133893-2.0291879444048226110.9920548437758108.962866899370980-5.214524250000000260.58105389631570955.366529646315712164.32939654568668R129+AC129+AW129+BF1292.2737367544323206E-13$D129Total Dist'n, storage, conv'n, and balancing-($AE129+$V129)*EF.IndustrialCoal.CO2012.909422417502345-($AG129+$X129)*EF.NaturalGas.CO23.7324780627405372-$Y129*EF.BlastFurnaceGas.CO2016.641900480242882-($AE129+$V129)*EF.IndustrialCoal.CH401.6072179946603007E-2-($AG129+$X129)*EF.NaturalGas.CH47.4816989333986467E-36512.3553878880001655E-2-($AE129+$V129)*EF.IndustrialCoal.N2O00.23226696186740817-($AG129+$X129)*EF.NaturalGas.N2O8.0469309371275256E-36510.2403138928045356916.905768251927419
-($AE130+$V130)*EF.IndustrialCoal.CO200-($AG130+$X130)*EF.NaturalGas.CO20-$Y130*EF.BlastFurnaceGas.CO20-($AE130+$V130)*EF.IndustrialCoal.CH400-($AG130+$X130)*EF.NaturalGas.CH40-($AE130+$V130)*EF.IndustrialCoal.N2O00-($AG130+$X130)*EF.NaturalGas.N2O0
-($AE131+$V131)*EF.IndustrialCoal.CO200-($AG131+$X131)*EF.NaturalGas.CO20-$Y131*EF.BlastFurnaceGas.CO20-($AE131+$V131)*EF.IndustrialCoal.CH400-($AG131+$X131)*EF.NaturalGas.CH40-($AE131+$V131)*EF.IndustrialCoal.N2O00-($AG131+$X131)*EF.NaturalGas.N2O0
-($AE132+$V132)*EF.IndustrialCoal.CO200-($AG132+$X132)*EF.NaturalGas.CO20-$Y132*EF.BlastFurnaceGas.CO20-($AE132+$V132)*EF.IndustrialCoal.CH400-($AG132+$X132)*EF.NaturalGas.CH40-($AE132+$V132)*EF.IndustrialCoal.N2O00-($AG132+$X132)*EF.NaturalGas.N2O0
593I$72+I$111+I$129582.62431955664806146.69564603235992444.82296266790246502.5055296707695316.246998166435951161.7263692923423548.041663833596701728.5205609631444859.0906320000000061961.7541212200549T$72+T$111+T$1290.983876715083908950091.5976583870743750-0.11045622229999985-2.2841330000000659E-20092.448237549858732AE$72+AE$111+AE$129-475.13368753227502-1067.2164050197666-1045.8878863613475-2588.2379789133893-163.24447683045062-54.536827932256621-5.2738639697825862000-5.088394340000000700-64.899086242039203-15.4173356595695540-20.468577340057742-35.885912999627294-2852.2674549855064AY$72+AY$111+AY$129641.77271700598453131.19335615765991772.96607316364452-25.869051342938413-9.612979501428702360.58105389631570925.099023051948599798.06509621559314R133+AC133+AW133+BF1330767-($AE133+$V133)*EF.IndustrialCoal.CO2146.34117575994068228.75942318409415-($AG133+$X133)*EF.NaturalGas.CO2192.44337109048789-$Y133*EF.BlastFurnaceGas.CO28.6688539495683642E-2567.6306585740183-($AE133+$V133)*EF.IndustrialCoal.CH40.429897490167645450.28480457877891741-($AG133+$X133)*EF.NaturalGas.CH40.385749987012698256511.100452055959261-($AE133+$V133)*EF.IndustrialCoal.N2O1.29636527183226964.1158507718728954-($AG133+$X133)*EF.NaturalGas.N2O0.414892864858830656515.8271089085639955574.55821953854161
|
|
109124
439133
117284
124
118441
449
440450
457459
458
620
454450
455
462463
464465
466
467
468
469
473757
474
482483
486585
583
582584
603
594595
596
598667
601602
604
610611
808809
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D