|
2007
Preferences.EnergyUnitsTWh74968910489311052
INDEX(Vectors[Description], MATCH(G$5,Vectors[Code],FALSE))Heating and coolingINDEX(Vectors[Description], MATCH(H$5,Vectors[Code],FALSE))Lighting & appliancesINDEX(Vectors[Description], MATCH(I$5,Vectors[Code],FALSE))IndustryINDEX(Vectors[Description], MATCH(J$5,Vectors[Code],FALSE))Road transportINDEX(Vectors[Description], MATCH(K$5,Vectors[Code],FALSE))Rail transportINDEX(Vectors[Description], MATCH(L$5,Vectors[Code],FALSE))Domestic aviationINDEX(Vectors[Description], MATCH(M$5,Vectors[Code],FALSE))National navigationINDEX(Vectors[Description], MATCH(N$5,Vectors[Code],FALSE))International aviationINDEX(Vectors[Description], MATCH(O$5,Vectors[Code],FALSE))International shippingINDEX(Vectors[Description], MATCH(P$5,Vectors[Code],FALSE))Food consumption [UNUSED]936INDEX(Vectors[Description], MATCH(S$5,Vectors[Code],FALSE))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(T$5,Vectors[Code],FALSE))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(U$5,Vectors[Code],FALSE))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(V$5,Vectors[Code],FALSE))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(W$5,Vectors[Code],FALSE))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(X$5,Vectors[Code],FALSE))Coal and fossil wasteINDEX(Vectors[Description], MATCH(Y$5,Vectors[Code],FALSE))Oil and petroleum productsINDEX(Vectors[Description], MATCH(Z$5,Vectors[Code],FALSE))Natural gasINDEX(Vectors[Description], MATCH(AA$5,Vectors[Code],FALSE))Blast furnace gasINDEX(Vectors[Description], MATCH(AB$5,Vectors[Code],FALSE))Heat transportINDEX(Vectors[Description], MATCH(AC$5,Vectors[Code],FALSE))Edible biomassINDEX(Vectors[Description], MATCH(AD$5,Vectors[Code],FALSE))Energy crops (second generation)INDEX(Vectors[Description], MATCH(AE$5,Vectors[Code],FALSE))Dry biomass and wasteINDEX(Vectors[Description], MATCH(AF$5,Vectors[Code],FALSE))Wet biomass and wasteINDEX(Vectors[Description], MATCH(AG$5,Vectors[Code],FALSE))Domestic solar thermalINDEX(Vectors[Description], MATCH(AH$5,Vectors[Code],FALSE))H2685INDEX(Vectors[Description], MATCH(AK$5,Vectors[Code],FALSE))Coal reservesINDEX(Vectors[Description], MATCH(AL$5,Vectors[Code],FALSE))Oil reservesINDEX(Vectors[Description], MATCH(AM$5,Vectors[Code],FALSE))Gas reservesINDEX(Vectors[Description], MATCH(AN$5,Vectors[Code],FALSE))Biomass oversupply (imports)INDEX(Vectors[Description], MATCH(AO$5,Vectors[Code],FALSE))Electricity oversupply (imports)INDEX(Vectors[Description], MATCH(AP$5,Vectors[Code],FALSE))Petroleum products oversupplyINDEX(Vectors[Description], MATCH(AQ$5,Vectors[Code],FALSE))Coal oversupply (imports)INDEX(Vectors[Description], MATCH(AR$5,Vectors[Code],FALSE))Oil and petroleum products oversupply (imports)INDEX(Vectors[Description], MATCH(AS$5,Vectors[Code],FALSE))Gas oversupply (imports)INDEX(Vectors[Description], MATCH(AT$5,Vectors[Code],FALSE))Nuclear fissionINDEX(Vectors[Description], MATCH(AU$5,Vectors[Code],FALSE))SolarINDEX(Vectors[Description], MATCH(AV$5,Vectors[Code],FALSE))WindINDEX(Vectors[Description], MATCH(AW$5,Vectors[Code],FALSE))TidalINDEX(Vectors[Description], MATCH(AX$5,Vectors[Code],FALSE))WaveINDEX(Vectors[Description], MATCH(AY$5,Vectors[Code],FALSE))GeothermalINDEX(Vectors[Description], MATCH(AZ$5,Vectors[Code],FALSE))HydroINDEX(Vectors[Description], MATCH(BA$5,Vectors[Code],FALSE))Environmental heatINDEX(Vectors[Description], MATCH(BB$5,Vectors[Code],FALSE))AgricultureINDEX(Vectors[Description], MATCH(BC$5,Vectors[Code],FALSE))Waste686INDEX(Vectors[Description], MATCH(BF$5,Vectors[Code],FALSE))Conversion lossesINDEX(Vectors[Description], MATCH(BG$5,Vectors[Code],FALSE))Distribution losses and own use930INDEX(Vectors[Description], MATCH(BJ$5,Vectors[Code],FALSE))UnallocatedINDEX(IPCC[Sector_description], MATCH(BM$5, IPCC[Sector_code], 0))Fuel CombustionINDEX(IPCC[Sector_description], MATCH(BQ$5, IPCC[Sector_code], 0))Fugitive Emissions from FuelsINDEX(IPCC[Sector_description], MATCH(BU$5, IPCC[Sector_code], 0))Industrial ProcessesINDEX(IPCC[Sector_description], MATCH(BY$5, IPCC[Sector_code], 0))Solvent and Other Product UseINDEX(IPCC[Sector_description], MATCH(CC$5, IPCC[Sector_code], 0))AgricultureINDEX(IPCC[Sector_description], MATCH(CG$5, IPCC[Sector_code], 0))Land Use, Land-Use Change and ForestryINDEX(IPCC[Sector_description], MATCH(CK$5, IPCC[Sector_code], 0))WasteINDEX(IPCC[Sector_description], MATCH(CO$5, IPCC[Sector_code], 0))OtherINDEX(IPCC[Sector_description], MATCH(CS$5, IPCC[Sector_code], 0))International Aviation and ShippingINDEX(IPCC[Sector_description], MATCH(CW$5, IPCC[Sector_code], 0))Bioenergy creditINDEX(IPCC[Sector_description], MATCH(DA$5, IPCC[Sector_code], 0))Carbon capture
200657133637383995395440454647495064656610875175217727539161315145798598698759607949779789797338910111210410125434356110501049234567103510361063
10401041104210431040104110421043104010411042104310401041104210431040104110421043104010411042104310401041104210431040104110421043104010411042104310401041104210431040104110421043
5921196
|
824INDEX(Modules[Module], MATCH($C9, Modules[Code], 0))Domestic space heating and hot water443-($AI9+$BD9+$BH9)291.47592449379539SUM(G9:P9)291.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.60399999999999998-'DUKES 09 (7.2)'!$C$61*Unit.ktoe-3.8611111111111107SUM(S9:AH9)-290.68818592387856-'DUKES 09 (7.2)'!$K$61*Unit.ktoe-0.52205907000000007-'DUKES 09 (7.2)'!$J$61*Unit.ktoe-0.26567949991680362SUM(AK9:BC9)-0.78773856991680369SUM(BF9:BG9)0Q9+AI9+BD9+BH92.2093438190040615E-14
885INDEX(Modules[Module], MATCH($C10, Modules[Code], 0))Domestic hot water [UNUSED - See IX.a]443-($AI10+$BD10+$BH10)130.18160973500784130.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.50892008295163-130.18160973500784000
934SUM(G9:G10)421.65753422880323SUM(H9:H10)000000000421.65753422880323SUM(S9:S10)-30.148805334101993SUM(T9:T10)0-7.8737179180745418-33.413412311051303-344.96874898454746SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)00-0.6039999999999999800-3.8611111111111107SUM(AF9:AF10)0SUM(AG9:AG10)00-420.8697956588864SUM(AK9:AK10)0000000000-0.522059070000000070000000-0.26567949991680362-0.78773856991680369SUM(BF9:BF10)0SUM(BG9:BG10)002.2093438190040615E-14
1075-($AI12+$BD12+$BH12)104.04632500828521104.04632500828521-'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.4831247399999992-103.37269598884714-('DUKES 09 (7.2)'!$J$62+'DUKES 09 (7.2)'!$J$63)*Unit.ktoe-0.67362901943806508-0.673629019438065082.1094237467877974E-15
1076-($AI13+$BD13+$BH13)19.03991065416536819.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.55170340717633-19.03991065416536800
932INDEX(Modules[Module], MATCH($C14, Modules[Code], 0))Commercial heating and cooling1197G12+G13123.08623566245058123.08623566245058S12+S13-17.358244159596637T12+T130-0.12985204585550009-13.453219681593032-86.9881660159673520000-4.483124739999999200AF12+AF130AG12+AG1300-122.41260664301251AK12+AK13000000000000000000-0.67362901943806508-0.6736290194380650802.1094237467877974E-15
933INDEX(Modules[Module], MATCH($C15, Modules[Code], 0))Commercial hot water [UNUSED - See IX.c]00000
935SUM(G14:G15)123.08623566245058SUM(H14:H15)000000000123.08623566245058SUM(S14:S15)-17.3582441595966370-0.12985204585550009-13.453219681593032-86.988166015967352SUM(X14:X15)0SUM(Y14:Y15)0SUM(Z14:Z15)00-4.4831247399999992000SUM(AF14:AF15)0SUM(AG14:AG15)00-122.41260664301251SUM(AK14:AK15)0000000SUM(AR14:AR15)00000000000-0.67362901943806508-0.67362901943806508SUM(BF14:BF15)0SUM(BG14:BG15)002.1094237467877974E-15
676INDEX(Workstreams[Workstream], MATCH($C17, Workstreams[Code], 0))HeatingG16+G11544.74376989125381000000000544.74376989125381S16+S11-47.5070494936986310-8.0035699639300422-46.866631992644336-431.956915000514810000-5.08712473999999930-3.8611111111111107AF16+AF110AG16+AG1100-543.28240230189897AK16+AK110000000000-0.522059070000000070000000-0.9393085193548687-1.4613675893548688BF16+BF110BG16+BG1100-3.2640556923979602E-14
0
1073-($AI19+$BD19+$BH19)78.114175905582002SUM(G19:P19)78.114175905582002-'DECC Energy Cons. (1.14)'!$F$8*Unit.ktoe-78.076491881013496-'DECC Energy Cons. (1.14)'!$C$8*Unit.ktoe-3.768402456850671E-2SUM(S19:AH19)-78.114175905582002SUM(AK19:BC19)000
1074-($AI20+$BD20+$BH20)14.83694538896287814.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.9361084744445822-14.836945388962878000
937INDEX(Modules[Module], MATCH($C21, Modules[Code], 0))Domestic lighting, appliances, and cooking443H19+H2092.95112129454487692.951121294544876S19+S20-84.901779480942992T19+T200-3.4633120849035942E-2-4.0916193739758112E-2-7.97379249901308910000000AF19+AF200AG19+AG2000-92.9511212945448760SUM(BF21:BG21)00
120-($AI22+$BD22+$BH22)5.27037081880774325.2703708188077432-'DECC Energy Cons. (1.14)'!$F$15*Unit.ktoe-5.2703708188077432-5.2703708188077432000
121-($AI23+$BD23+$BH23)9.42471541790436449.4247154179043644-'DECC Energy Cons. (1.14)'!$F$16*Unit.ktoe-9.0178517396130111-'DECC Energy Cons. (1.14)'!$C$16*Unit.ktoe-0.40686367829135411-9.4247154179043644000
122-($AI24+$BD24+$BH24)39.23133452302812439.231334523028124-'DECC Energy Cons. (1.14)'!$F$17*Unit.ktoe-39.231334523028124-39.231334523028124000
123-($AI25+$BD25+$BH25)14.65504936703768614.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.54777518427982-14.655049367037686000
1077-($AI26+$BD26+$BH26)22.46241905087132622.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.7886322691727088-22.462419050871326000
938INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Commercial lighting, appliances, and catering1197SUM(H22:H26)91.04388917764924891.043889177649248SUM(S22:S26)-79.723026369004316SUM(T22:T26)00-0.57759167690104141-10.7432711317438830000000SUM(AF22:AF26)0SUM(AG22:AG26)00-91.0438891776492340SUM(BF27:BG27)01.4210854715202004E-14
677INDEX(Workstreams[Workstream], MATCH($C28, Workstreams[Code], 0))Lighting and appliancesG21+G270H21+H27183.9950104721941100000000183.99501047219411S21+S27-164.62480584994731T21+T270-3.4633120849035942E-2-0.61850787064079948-18.717063630756972X21+X270Y21+Y270Z21+Z27000000AF21+AF270AG21+AG2700-183.99501047219411AK21+AK2700000000000000000000BF21+BF270BG21+BG270SUM(BF28:BG28)00
0
10691198SUM(G30:P30)0'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.02332976186435SUM(S30:AH30)-2.1850770106967605SUM(AK30:BC30)0-($Q30+$AI30+$BD30)2.1850770106967605SUM(BF30:BG30)2.18507701069676050
4474470(-'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.63015725722-34.0156291402158290-($Q31+$AI31+$BD31)34.01562914021582934.0156291402158290
10671067-($AI32+$BD32+$BH32)5.02013537371645495.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.70256923162000007-5.0201353737164549000
106810686.51894567762714426.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.37932920102-6.5189456776271442000
5915917.63916005132583297.6391600513258329-'DUKES 09 (1.2)'!$I$34*Unit.ktoe-1.8634191446533293-'DUKES 09 (1.2)'!$F$34*Unit.ktoe-5.7757409066725032-7.6391600513258329000
1714319.73181150625037419.731811506250374-'DUKES 09 (1.2)'!$I$39*Unit.ktoe-4.9236735106492704-'DUKES 09 (1.2)'!$B$39*Unit.ktoe-('DUKES 09 (2.5)'!$B$42*1000000*Constants.GCV.Coke+'DUKES 09 (2.5)'!$C$42*1000000*Constants.GCV.CokeBreeze)-5.2541857222222221-'DUKES 09 (1.2)'!$E$39*Unit.ktoe-0.23144272840054639-'DUKES 09 (1.2)'!$F$39*Unit.ktoe-'DUKES 09 (2.5)'!$H$42*Unit.GWh-8.6344644980983354-'DUKES 09 (2.5)'!$I$42*Unit.GWh-0.68804504688000079-19.731811506250374000
1724311.53922269251837211.539222692518372-'DUKES 09 (1.2)'!$I$40*Unit.ktoe-7.3305836262747759-'DUKES 09 (1.2)'!$B$40*Unit.ktoe-0.25451653301210753-'DUKES 09 (1.2)'!$E$40*Unit.ktoe-0.56247844522334201-'DUKES 09 (1.2)'!$F$40*Unit.ktoe-3.3916440880081486-11.539222692518372000
1754317.66368036102607117.663680361026071-'DUKES 09 (1.2)'!$I$43*Unit.ktoe-8.5180652019653511-'DUKES 09 (1.2)'!$B$43*Unit.ktoe-7.9754162510637341E-2-'DUKES 09 (1.2)'!$E$43*Unit.ktoe-1.249127451386987-'DUKES 09 (1.2)'!$F$43*Unit.ktoe-7.8167335451630962-17.663680361026071000
1764311.68862909216119111.688629092161191-'DUKES 09 (1.2)'!$I$44*Unit.ktoe-7.2894327269801078-'DUKES 09 (1.2)'!$B$44*Unit.ktoe-4.5688034677035055E-2-'DUKES 09 (1.2)'!$E$44*Unit.ktoe-0.41344752189730305-'DUKES 09 (1.2)'!$F$44*Unit.ktoe-3.9400608086067463-11.688629092161191000
1065SUM(G30:G38)0079.801584754625438000000079.801584754625438SUM(S30:S38)-30.493674064074618SUM(T30:T38)0-65.05006437900218-4.8947693903249467-24.4239968498362930008.8602137776999985000SUM(AF30:AF38)0SUM(AG30:AG38)00-116.00229090553803SUM(AK30:AK38)00000000000000000000SUM(BF30:BF38)36.200706150912588SUM(BG30:BG38)036.2007061509125880
17343-($AI40+$BD40+$BH40)30.19735675528520630.197356755285206-'DUKES 09 (1.2)'!$I$41*Unit.ktoe-7.8594184101510143-'DUKES 09 (1.2)'!$B$41*Unit.ktoe-8.8298277777777798-'DUKES 09 (1.2)'!$E$41*Unit.ktoe-2.2921274343878464-'DUKES 09 (1.2)'!$F$41*Unit.ktoe-11.215983132968562-30.197356755285206000
1066G400030.197356755285206000000030.197356755285206S40-7.8594184101510143T400-8.8298277777777798-2.2921274343878464-11.2159831329685620000000AF400AG4000-30.197356755285206AK4000000000000000000000BF400BG4000Q41+AI41+BD41+BH410
17443-($AI42+$BD42+$BH42)65.48513307993850765.485133079938507-'DUKES 09 (1.2)'!$I$42*Unit.ktoe-22.199505602922009-'DUKES 09 (1.2)'!$B$42*Unit.ktoe-1.0631637519449721-'DUKES 09 (1.2)'!$E$42*Unit.ktoe-2.2386073224018888-'DUKES 09 (1.2)'!$F$42*Unit.ktoe-36.767114332669635-'DUKES 09 (1.2)'!$J$42*Unit.ktoe-3.2167420699999996-65.485133079938507000
174G420065.485133079938507000000065.485133079938507S42-22.199505602922009T420-1.0631637519449721-2.2386073224018888-36.7671143326696350000-3.216742069999999600AF420AG4200-65.485133079938507AK4200000000000000000000BF420BG42000
17043-($AI44+$BD44+$BH44)36.56205660693208936.562056606932089-'DUKES 09 (1.2)'!$I$38*Unit.ktoe0-'DUKES 09 (1.2)'!$B$38*Unit.ktoe-('DUKES 09 (2.5)'!$B$41*1000000*Constants.GCV.Coke+'DUKES 09 (2.5)'!$C$41*1000000*Constants.GCV.CokeBreeze)-'DUKES 09 (2.5)'!$G$41*Unit.GWh-2.5388507060896268-'DUKES 09 (1.2)'!$E$38*Unit.ktoe-30.706209293478242-'DUKES 09 (1.2)'!$F$38*Unit.ktoe-'DUKES 09 (2.5)'!$H$41*Unit.GWh-0.26121165071253571-('DUKES 09 (7.2)'!$B$41+'DUKES 09 (7.2)'!$E$41)*Unit.ktoe-1.4729146905589265-34.979186340839334-('DUKES 09 (7.2)'!$D$41+'DUKES 09 (7.2)'!$J$41)*Unit.ktoe-1.5828702660927567-1.58287026609275670-1.9984014443252818E-15
17743-($AI45+$BD45+$BH45)16.40330859748069516.403308597480695-'DUKES 09 (1.2)'!$I$45*Unit.ktoe-5.7310286487550925-'DUKES 09 (1.2)'!$B$45*Unit.ktoe-0.4035231747156019-'DUKES 09 (1.2)'!$E$45*Unit.ktoe-1.428078627085088-'DUKES 09 (1.2)'!$F$45*Unit.ktoe-8.8406781469249118-16.403308597480695000
25743-($AI46+$BD46+$BH46)41.93181966979432241.931819669794322-'DUKES 09 (1.2)'!$I$46*Unit.ktoe-12.283410094590781-'DUKES 09 (1.2)'!$B$46*Unit.ktoe-0.34249934016251599-'DUKES 09 (1.2)'!$E$46*Unit.ktoe-3.1125085351113739-'DUKES 09 (1.2)'!$F$46*Unit.ktoe-26.171842679929654-'DUKES 09 (1.2)'!$J$46*Unit.ktoe-2.1559019999999998E-2-41.931819669794322000
25843-($AI47+$BD47+$BH47)11.72339429514094211.723394295140942-'DUKES 09 (1.2)'!$I$47*Unit.ktoe-3.3494086136065309-'DUKES 09 (1.2)'!$B$47*Unit.ktoe-0.60935341109594265-'DUKES 09 (1.2)'!$E$47*Unit.ktoe-1.3849995823965704-'DUKES 09 (1.2)'!$F$47*Unit.ktoe-6.3796326880418972-11.723394295140942000
25943-($AI48+$BD48+$BH48)26.12114582456159126.121145824561591-'DUKES 09 (1.2)'!$I$48*Unit.ktoe-13.356076571372961-'DUKES 09 (1.2)'!$B$48*Unit.ktoe-1.1754751808185944-'DUKES 09 (1.2)'!$E$48*Unit.ktoe-0.75354862786783305-'DUKES 09 (1.2)'!$F$48*Unit.ktoe-10.821610444502204-'DUKES 09 (1.2)'!$J$48*Unit.ktoe-1.4434999999999998E-2-26.121145824561591000
107010700-'DUKES 09 (1.2)'!$I$23*Unit.ktoe0-('DUKES 09 (1.2)'!$B$23+'DUKES 09 (1.2)'!$C$23)*Unit.ktoe-5.3929002811516136E-2-'DUKES 09 (1.2)'!$E$23*Unit.ktoe0-'DUKES 09 (1.2)'!$F$23*Unit.ktoe0-5.3929002811516136E-20-($Q49+$AI49+$BD49)5.3929002811516136E-25.3929002811516136E-20
18143-($AI50+$BD50+$BH50)71.89762962153676571.897629621536765-'DUKES 09 (1.2)'!$I$49*Unit.ktoe-22.568014350701699-'DUKES 09 (1.2)'!$B$49*Unit.ktoe-1.614624391048268-'DUKES 09 (1.2)'!$E$49*Unit.ktoe-33.059141100313447-'DUKES 09 (1.2)'!$F$49*Unit.ktoe-9.8808267794733595-'DUKES 09 (1.2)'!$J$49*Unit.ktoe-4.775023-71.897629621536765000
18243-($AI51+$BD51+$BH51)6.24605308421410226.2460530842141022-'DUKES 09 (1.2)'!$I$50*Unit.ktoe-1.5985087727969405-'DUKES 09 (1.2)'!$B$50*Unit.ktoe0-'DUKES 09 (1.2)'!$E$50*Unit.ktoe-1.9641390214777721-'DUKES 09 (1.2)'!$F$50*Unit.ktoe-2.683405289939389-6.2460530842141022000
123SUM(G44:G51)00210.88540769966050000000210.8854076996605SUM(S44:S51)-58.886447051824SUM(T44:T51)0-6.7382552067420658-72.408624787730332-65.0392076795239550000-4.81101702000000040-1.4729146905589265SUM(AF44:AF51)0SUM(AG44:AG51)00-209.35646643637926SUM(AK44:AK51)000000000000000000-1.5828702660927567-1.5828702660927567SUM(BF44:BF51)5.3929002811516136E-2SUM(BG44:BG51)05.3929002811516136E-2-5.5511151231257827E-16
125445-($AI53+$BD53+$BH53)40.15331336653989840.153313366539898('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.7914049999999992-'DUKES 09 (7.2)'!$E$21*Unit.ktoe-4.1138273605540494-29.737101502499733-'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)'!$J$21+'DUKES 09 (7.2)'!$D$21)*Unit.ktoe-9.352342240608424-12.01618483309101'DUKES 09 (5.6)'!$M$254*Unit.GWh1.59997296905084881.59997296905084882.886579864025407E-15
161813-($AI54+$BD54+$BH54)12.62635901673776412.626359016737764'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.904104654239129-12.626359016737764000
887INDEX(Modules[Module], MATCH($C55, Modules[Code], 0))Industrial processesG$39+G$41+G$43+G$52+G$53+G$5400439.149154672787350000000SUM(G55:P55)439.14915467278735S$39+S$41+S$43+S$52+S$53+S$54-119.43904512897164T$39+T$41+T$43+T$52+T$53+T$5434.033592131949163-95.45621146868902-87.952715482035742-194.76947503945746000-0.110456222300000715.87634556423912890-5.5867420511129762000SUM(S55:AH55)-463.40470769637858AK$39+AK$41+AK$43+AK$52+AK$53+AK$540000000000-1.4000077700000002E-2-1.705027184782586000-0.9448153300000000600-10.935212506701181-13.599055099183767BF$39+BF$41+BF$43+BF$52+BF$53+BF$5436.254635153724102BG$39+BG$41+BG$43+BG$52+BG$53+BG$541.5999729690508488SUM(BF55:BG55)37.8546081227749480
678INDEX(Workstreams[Workstream], MATCH($C56, Workstreams[Code], 0))IndustryG550H550439.149154672787350000000SUM(G56:P56)439.14915467278735S55-119.4390451289716434.033592131949163-95.45621146868902-87.952715482035742-194.76947503945746000AA55-0.110456222300000715.876345564239128900-5.5867420511129762AF550AG5500SUM(S56:AH56)-463.40470769637858AK550000000000-1.4000077700000002E-2-1.705027184782586000-0.9448153300000000600-10.935212506701181-13.599055099183767BF5536.254635153724102BG551.5999729690508488SUM(BF56:BG56)37.8546081227749480
0
890INDEX(Modules[Module], MATCH($C58, Modules[Code], 0))Domestic passenger transport478-($AI58+$BD58+$BH58)502.50552967076953SUM(G58:P58)502.50552967076953-'DUKES 09 (1.2)'!$E$54*Unit.ktoe-'DUKES 09 (1.2)'!$G$54*Unit.ktoe-502.50552967076953SUM(S58:AH58)-502.50552967076953SUM(AK58:BC58)0SUM(BF58:BG58)00
903INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Domestic freight477-($AI59+$BD59+$BH59)16.246998166435951SUM(G59:P59)16.246998166435951-'DUKES 09 (1.2)'!$I$53*Unit.ktoe-8.1002794197444299-'DUKES 09 (1.2)'!$E$53*Unit.ktoe-8.146718746691521-16.246998166435951000
906INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))International aviation476-($AI60+$BD60+$BH60)152.99167541479133SUM(G60:P60)152.99167541479133V62-V61-152.99167541479133-152.99167541479133000
941INDEX(Modules[Module], MATCH($C61, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]476-($AI61+$BD61+$BH61)8.73469387755102038.7346938775510203-2.14/0.245*Unit.TWh-8.7346938775510203-8.7346938775510203000
947SUM(G60:G61)0SUM(H60:H61)00008.73469387755102030152.9916754147913300161.72636929234235SUM(S60:S61)0SUM(T60:T61)0SUM(U60:U61)0-'DUKES 09 (1.2)'!$E$52*Unit.ktoe-161.72636929234235SUM(W60:W61)0SUM(X60:X61)0SUM(Y60:Y61)0SUM(Z60:Z61)0SUM(AA60:AA61)00000SUM(AF60:AF61)0SUM(AG60:AG61)00-161.72636929234235SUM(AK60:AK61)00000000000000000000SUM(BF60:BF61)0SUM(BG60:BG61)000
944INDEX(Modules[Module], MATCH($C63, Modules[Code], 0))International shipping1199-($AI63+$BD63+$BH63)29.22229142823090729.222291428230907'DUKES 09 (1.2)'!$E$8*Unit.ktoe-29.222291428230907-29.222291428230907000
946INDEX(Modules[Module], MATCH($C64, Modules[Code], 0))National navigation [UNUSED - see XII.a]480-($AI64+$BD64+$BH64)18.8193724053657918.81937240536579-'DUKES 09 (1.2)'!$E$55*Unit.ktoe-18.81937240536579-18.81937240536579000
948SUM(G63:G64)0SUM(H63:H64)0000018.81937240536579029.222291428230907048.041663833596701SUM(S63:S64)000-48.0416638335967010000SUM(AA63:AA64)00000SUM(AF63:AF64)0SUM(AG63:AG64)00-48.041663833596701SUM(AK63:AK64)00000000000000000000SUM(BF63:BF64)0SUM(BG63:BG64)000
679INDEX(Workstreams[Workstream], MATCH($C66, Workstreams[Code], 0))TransportG58+G59+G62+G65000502.5055296707695316.2469981664359518.734693877551020318.81937240536579152.9916754147913329.2222914282309070728.52056096314448S58+S59+S62+S65-8.100279419744429900-720.420281543400050000AA58+AA59+AA62+AA6500000AF58+AF59+AF62+AF650AG58+AG59+AG62+AG6500-728.52056096314448AK58+AK59+AK62+AK650000000AR58+AR59+AR62+AR650000000000000BF58+BF59+BF62+BF650BG58+BG59+BG62+BG65000
0
917INDEX(Modules[Module], MATCH($C68, Modules[Code], 0))Food consumption [UNUSED]47560000000*2320000*Unit.calorie*365.2559.090632000000006SUM(G68:P68)59.090632000000006-P68/0.9-65.656257777777782SUM(S68:AH68)-65.656257777777782SUM(AK68:BC68)0-AC68*0.16.5656257777777789SUM(BF68:BG68)6.56562577777777890
680INDEX(Workstreams[Workstream], MATCH($C69, Workstreams[Code], 0))Food consumption [UNUSED]G680H680000000059.090632000000006SUM(G69:P69)59.090632000000006S680T680000X680Y680Z68000-65.65625777777778200AF680AG6800SUM(S69:AH69)-65.656257777777782AK680000000000000000000SUM(AK69:BC69)0BF686.5656257777777789BG680SUM(BF69:BG69)6.56562577777777890
0
949INDEX(Modules[Module], MATCH($C71, Modules[Code], 0))Geosequestration475SUM(G71:P71)0SUM(S71:AH71)0SUM(AK71:BC71)0SUM(BF71:BG71)00
675INDEX(Workstreams[Workstream], MATCH($C72, Workstreams[Code], 0))GeosequestrationG710H71000000000SUM(G72:P72)0S7100000X710Y710Z71000000AF710AG7100SUM(S72:AH72)0AK710000000AR71000000000000SUM(AK72:BC72)0BF710BG710SUM(BF72:BG72)00
SUM(AK73:BC73)00
619G$17+G$28+G$56+G$66+G$69+G$72544.74376989125381183.99501047219411439.14915467278735502.5055296707695316.2469981664359518.734693877551020318.81937240536579152.9916754147913329.22229142823090759.0906320000000061955.4991279993797S$17+S$28+S$56+S$66+S$69+S$72-339.6711798923620334.033592131949163-103.49441455346809-855.85813688872099-645.44345367072924000-0.110456222300000710.78922082423912965-65.6562577777777820-9.4478531622240869000T74+S74+U74+V74+W74+AA74+AB74+AC74+AE74+AH74-1984.8589392113938AK$17+AK$28+AK$56+AK$66+AK$69+AK$720000000000-0.53605914770000007-1.705027184782586000-0.9448153300000000600-11.874521026056049SUM(AK74:BC74)-15.060422688538635BF$17+BF$28+BF$56+BF$66+BF$69+BF$7242.820260931501878BG$17+BG$28+BG$56+BG$66+BG$69+BG$721.5999729690508488SUM(BF74:BG74)44.420233900552724-7.815970093361102E-14
0
720
0
968INDEX(Modules[Module], MATCH($C78, Modules[Code], 0))H2 Production for Transport475SUM(G78:P78)0SUM(S78:AH78)0SUM(AK78:BC78)0SUM(BF78:BG78)0
674INDEX(Workstreams[Workstream], MATCH($C79, Workstreams[Code], 0))H2 ProductionG780H78000000000SUM(G79:P79)0S780000000000000AF780AG7800SUM(S79:AH79)0AK780AL78000000000000000000SUM(AK79:BC79)0BF780BG780SUM(BF79:BG79)0Q79+AI79+BD79+BH790
Q80+AI80+BD80+BH800
952INDEX(Modules[Module], MATCH($C81, Modules[Code], 0))Volume of Waste & Recycling1208SUM(G81:P81)0SUM(S81:AH81)0SUM(AK81:BC81)0SUM(BF81:BG81)0Q81+AI81+BD81+BH810
12260-AC7465.65625777777778265.656257777777782-40%*AC82-26.262503111111116-60%*AC82-39.393754666666666-65.6562577777777820
2230'DUKES 09 (7.2)'!$C$8*Unit.ktoe3.86111111111111073.8611111111111107-AE83-3.8611111111111107-3.86111111111111070Q83+AI83+BD83+BH830
12270'DUKES 09 (7.2)'!$E$15*Unit.ktoe10.15099413156484510.150994131564845-AE84-10.150994131564845-10.15099413156484500
6130'DUKES 09 (7.2)'!$N$8*Unit.ktoe4.59991235846999924.5999123584699992-AE85-4.5999123584699992-4.599912358469999200
911INDEX(Modules[Module], MATCH($C86, Modules[Code], 0))Agriculture and land use1208-S864.12485856617580464.1248585661758046-'DUKES 09 (1.2)'!$I$61*Unit.ktoe-4.1248585661758046SUM(T82:T85)00000000065.65625777777778218.612017601145954SUM(AF82:AF85)0SUM(AG82:AG85)0080.14341681274793SUM(AK82:AK85)000-26.2625031111111160000000000000-58.0057722678126240-84.268275378923732SUM(BF82:BF85)0SUM(BG82:BG85)000
793672INDEX(Workstreams[Workstream], MATCH($C87, Workstreams[Code], 0))Agriculture and wasteG81+G860H81+H8604.124858566175804600000004.1248585661758046S81+S86-4.124858566175804600000000065.656257777777782018.612017601145954AF81+AF860AG81+AG860080.14341681274793AK81+AK86000-26.2625031111111160000000000000-58.0057722678126240-84.268275378923732BF81+BF860BG81+BG86000
0
950INDEX(Modules[Module], MATCH($C89, Modules[Code], 0))Types of fuel from Biomass475SUM(G89:P89)0-AE894.5999123584699992-AE85-4.5999123584699992SUM(S89:AH89)0SUM(AK89:BC89)0SUM(BF89:BG89)00
793671INDEX(Workstreams[Workstream], MATCH($C90, Workstreams[Code], 0))BioenergyG890H89000000000SUM(G90:P90)0S890004.599912358469999200000000-4.5999123584699992AF890AG8900SUM(S90:AH90)0AK890AL89000000000000000000SUM(AK90:BC90)0BF890BG890SUM(BF90:BG90)00
0
485485SUM(G92:P92)0'DUKES 09 (1.2)'!$E$20*Unit.ktoe1032.840110743924'DUKES 09 (1.2)'!$D$20*Unit.ktoe-1029.5988829805192SUM(S92:AH92)3.2412277634048223SUM(AK92:BC92)0-($Q92+$AI92)-3.2412277634048223SUM(BF92:BG92)-3.24122776340482230
587587SUM(G93:P93)0-'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.8020562358157120-($Q93+$AI93)64.80205623581571264.8020562358157120
958INDEX(Modules[Module], MATCH($C94, Modules[Code], 0))Petroleum refineries1200SUM(G92:G93)0000000000SUM(G94:P94)0SUM(S92:S93)-6.6955015551946326SUM(T92:T93)00977.96119331050966-2.44137808296760460-1029.598882980519200-0.7862591642391313400SUM(AF92:AF93)0SUM(AG92:AG93)00-61.560828472410883SUM(AK92:AK93)00000000000000000000SUM(BF92:BF93)-3.2412277634048223SUM(BG92:BG93)64.80205623581571261.560828472410890
2451213'DUKES 09 (1.2)'!$E$9*Unit.ktoe-'DUKES 09 (1.2)'!$E$63*Unit.ktoe-98.388950769950753'DUKES 09 (1.2)'!$B$5*Unit.ktoe+('DUKES 09 (1.2)'!$B$9+'DUKES 09 (1.2)'!$C$9)*Unit.ktoe145.79944495555736'DUKES 09 (1.2)'!$D$5*Unit.ktoe+'DUKES 09 (1.2)'!$D$9*Unit.ktoe985.84902649998276('DUKES 09 (1.2)'!$F$5+'DUKES 09 (1.2)'!$F$9-'DUKES 09 (1.2)'!$F$63)*Unit.ktoe834.06115021419181867.3206708997814-('DUKES 09 (1.2)'!$B$5*Unit.ktoe+('DUKES 09 (1.2)'!$B$9+'DUKES 09 (1.2)'!$C$9)*Unit.ktoe)-145.79944495555736-('DUKES 09 (1.2)'!$D$5+'DUKES 09 (1.2)'!$D$9+'DUKES 09 (1.2)'!$E$9-'DUKES 09 (1.2)'!$E$63)*Unit.ktoe-887.46007573003203-('DUKES 09 (1.2)'!$F$5+'DUKES 09 (1.2)'!$F$9-'DUKES 09 (1.2)'!$F$63)*Unit.ktoe-834.0611502141918-1867.320670899781400
9621214-('DUKES 09 (1.2)'!$I$27+'DUKES 09 (1.2)'!$I$29)*Unit.ktoe-1.5434122188034556-('DUKES 09 (1.2)'!$F$29+'DUKES 09 (1.2)'!$F$27)*Unit.ktoe-64.320792277183429-('DUKES 09 (1.2)'!$B$29+'DUKES 09 (1.2)'!$B$27)*Unit.ktoe-4.4692473051785787E-2-65.9088969690386650-$AI9665.90889696903866565.9088969690386650
975INDEX(Modules[Module], MATCH($C97, Modules[Code], 0))Indigenous fossil-fuel production1228SUM(G97:P97)0SUM(S95:S96)-1.5434122188034556SUM(T95:T96)00-98.388950769950753-64.320792277183429145.75475248250558985.84902649998276834.06115021419180000SUM(AF95:AF96)0SUM(AG95:AG96)001801.4117739307426SUM(AK95:AK96)-145.79944495555736-887.46007573003203-834.06115021419180000000000000000-1867.3206708997814SUM(BF95:BF96)0SUM(BG95:BG96)65.90889696903866565.908896969038665-1.1368683772161603E-13
956INDEX(Workstreams[Workstream], MATCH($C98, Workstreams[Code], 0))Fossil fuel productionG94+G970H94+H97000000000SUM(G98:P98)0S94+S97-8.238913773998088900879.57224254055893-66.762170360151032145.75475248250558-43.749856480536437834.06115021419180-0.78625916423913134000AF94+AF970AG94+AG97001739.8509454583316AK94+AK97-145.79944495555736-887.46007573003203-834.06115021419180000000000000000-1867.3206708997814BF94+BF97-3.2412277634048223BG94+BG97130.71095320485438127.46972544144955-2.2737367544323206E-13
|
Q100+AI100+BD100+BH1000
1701INDEX(Modules[Module], MATCH($C101, Modules[Code], 0))Onshore wind1201SUM(G101:P101)0'DUKES 09 (7.4)'!$M$25*Unit.GWh4.4912822999999999SUM(S101:AH101)4.4912822999999999-T101-4.4912822999999999SUM(AK101:BC101)-4.4912822999999999SUM(BF101:BG101)00
1702INDEX(Modules[Module], MATCH($C102, Modules[Code], 0))Offshore wind12010'DUKES 09 (7.4)'!$M$26*Unit.GWh0.782552399999999930.78255239999999993-T102-0.78255239999999993-0.7825523999999999300
798INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Hydroelectric power stations12010('DUKES 09 (5.6)'!$J$246-'DUKES 09 (5.6)'!$J$247)*Unit.GWh4.11375510000000064.1137551000000006-'DUKES 09 (5.6)'!$J$245*Unit.GWh-4.1435790100000007-4.1435790100000007'DUKES 09 (5.6)'!$J$247*Unit.GWh2.9823910000000068E-22.9823910000000068E-2-1.0755285551056204E-16
803INDEX(Modules[Module], MATCH($C104, Modules[Code], 0))Tidal and Wave120100000
804INDEX(Modules[Module], MATCH($C105, Modules[Code], 0))Geothermal electricity120100000
805INDEX(Modules[Module], MATCH($C106, Modules[Code], 0))Tidal [UNUSED - See III.c]120100000
300000
76INDEX(Workstreams[Workstream], MATCH($C108, Workstreams[Code], 0))National renewable power generationSUM(G101:G107)0SUM(H101:H107)0000000000SUM(S101:S107)09.3875898000000007000SUM(X101:X107)0SUM(Y101:Y107)0SUM(Z101:Z107)000000SUM(AF101:AF107)0SUM(AG101:AG107)009.3875898000000007SUM(AK101:AK107)0000000SUM(AR101:AR107)0000-5.2738347000000001000-4.1435790100000007000-9.4174137100000017SUM(BF101:BF107)0SUM(BG101:BG107)2.9823910000000068E-22.9823910000000068E-2-9.9573127521068727E-16
0
963INDEX(Modules[Module], MATCH($C110, Modules[Code], 0))Solar PV288SUM(G110:P110)0SUM(S110:AH110)0SUM(AK110:BC110)0SUM(BF110:BG110)0
77INDEX(Workstreams[Workstream], MATCH($C111, Workstreams[Code], 0))Distributed renewable power generationG1100H110000000000SUM(G111:P111)0S1100000000000000AF1100AG11000SUM(S111:AH111)0AK1100AL110000000000000000000SUM(AK111:BC111)0BF1100BG1100SUM(BF111:BG111)0Q111+AI111+BD111+BH1110
Q112+AI112+BD112+BH1120
965SUM(BF113:BG113)0Q113+AI113+BD113+BH1130
964SUM(BF114:BG114)0
754INDEX(Modules[Module], MATCH($C115, Modules[Code], 0))Nuclear power1203SUM(G115:P115)0('DUKES 09 (5.6)'!$E$246-'DUKES 09 (5.6)'!$E$247)*Unit.GWh57.248895000000005SUM(S115:AH115)57.248895000000005-'DUKES 09 (5.6)'!$E$245*Unit.GWh-163.24447683045062SUM(AK115:BC115)-163.24447683045062-($AI115+$BD115+$BG115)100.21613413351562'DUKES 09 (5.6)'!$E$247*Unit.GWh5.7794476969349997SUM(BF115:BG115)105.99558183045062Q115+AI115+BD115+BH1150
75INDEX(Workstreams[Workstream], MATCH($C116, Workstreams[Code], 0))Nuclear power generationG1150H115000000000SUM(G116:P116)0S115057.24889500000000500000000000AF1150AG11500SUM(S116:AH116)57.248895000000005AK1150AL11500000000-163.24447683045062000000000SUM(AK116:BC116)-163.24447683045062BF115100.21613413351562BG1155.7794476969349997SUM(BF116:BG116)105.995581830450620
0
965SUM(BF118:BG118)00
96600
868INDEX(Modules[Module], MATCH($C120, Modules[Code], 0))Carbon Capture Storage (CCS)475SUM(G120:P120)0SUM(S120:AH120)0IFERROR(INDEX(INDIRECT($C120&".Outputs["&this.Year&"]"), MATCH(AK$5, INDIRECT($C120&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C120&".Outputs["&this.Year&"]"), MATCH(AT$5, INDIRECT($C120&".Outputs[Vector]"), 0)), 0)0000000000SUM(AK120:BC120)000
96500
967SUM(BF122:BG122)00
141('DUKES 09 (5.6)'!$B$246-'DUKES 09 (5.6)'!$B$247)*Unit.GWh125.93794534209844-'DUKES 09 (5.6)'!$B$245*Unit.GWh-371.39618674674301SUM(S123:AH123)-245.45824140464458SUM(AK123:BC123)0-($AI123+$BD123+$BG123)238.72086653696022'DUKES 09 (5.6)'!$B$247*Unit.GWh6.7373748676843679245.458241404644580
202('DUKES 09 (5.6)'!$C$246-'DUKES 09 (5.6)'!$C$247)*Unit.GWh1.9959590190899115-'DUKES 09 (5.6)'!$C$245*Unit.GWh-8.718214578336493-6.7222555592465820-($AI124+$BD124+$BG124)6.3174518861840294'DUKES 09 (5.6)'!$C$247*Unit.GWh0.404803673062552886.7222555592465820
14('DUKES 09 (5.6)'!$D$246-'DUKES 09 (5.6)'!$D$247)*Unit.GWh146.45188162344687-'DUKES 09 (5.6)'!$D$245*Unit.GWh-319.83646584224255-173.384584218795680-($AI125+$BD125+$BG125)170.49051986783476'DUKES 09 (5.6)'!$D$247*Unit.GWh2.8940643509609218173.384584218795680
51('DUKES 09 (5.6)'!$F$246-'DUKES 09 (5.6)'!$F$247)*Unit.GWh2.1482301985894212-'DUKES 09 (7.2)'!$E$20*Unit.ktoe-4.9052401149690734-2.7570099163796522-('DUKES 09 (7.2)'!$D$20+'DUKES 09 (7.2)'!$J$20)*Unit.ktoe-2.3660032518434662-2.3660032518434662-($AI126+$BD126+$BG126)4.8832570768526988'DUKES 09 (5.6)'!$F$247*Unit.GWh0.23975609137041925.12301316822311840
740INDEX(Modules[Module], MATCH($C127, Modules[Code], 0))Biomass/Coal power stations1202SUM(G127:P127)0SUM(S123:S126)0SUM(T123:T126)276.53401618322465-371.39618674674301-8.718214578336493-319.83646584224255000000-4.9052401149690734SUM(AF123:AF126)0SUM(AG123:AG126)00-428.32209109906648SUM(AK123:AK126)000000000000000000-2.3660032518434662-2.3660032518434662SUM(BF123:BF126)420.41209536783174SUM(BG123:BG126)10.275998983078262430.688094350909980
74INDEX(Workstreams[Workstream], MATCH($C128, Workstreams[Code], 0))Hydrocarbon fuel power generationG120+G1270H120+H127000000000SUM(G128:P128)0S120+S1270276.53401618322465-371.39618674674301-8.718214578336493-319.83646584224255X120+X1270Y120+Y1270Z120+Z12700000-4.9052401149690734AF120+AF1270AG120+AG12700-428.32209109906648AK120+AK1270000000AR120+AR12700000000000-2.3660032518434662-2.3660032518434662BF120+BF127420.41209536783174BG120+BG12710.275998983078262430.688094350909980
0
249G$87+G$90+G$98+G$108+G$111+G$116+G$128+G$79004.12485856617580460000000SUM(G130:P130)4.1248585661758046S$87+S$90+S$98+S$108+S$111+S$116+S$128+S$79-12.363772340173893343.17050098322466-371.39618674674301875.45394032069237-386.59863620239355145.75475248250558-43.749856480536437834.06115021419180-0.7862591642391313465.65625777777778209.1068651277068806000SUM(S130:AH130)1458.3087559720132AK$87+AK$90+AK$98+AK$108+AK$111+AK$116+AK$128+AK$79-145.79944495555736-887.46007573003203-834.0611502141918-26.26250311111111600000-163.244476830450620-5.2738347000000001000-4.14357901000000070-58.005772267812624-2.3660032518434662SUM(AK130:BC130)-2126.6168400709989BF$87+BF$90+BF$98+BF$108+BF$111+BF$116+BF$128+BF$79517.38700173794257BG$87+BG$90+BG$98+BG$108+BG$111+BG$116+BG$128+BG$79146.79622379486764SUM(BF130:BG130)664.183225532810180
0
9730
0
|
772INDEX(Modules[Module], MATCH($C135, Modules[Code], 0))Electricity imports1204SUM(G135:P135)0('DUKES 09 (5.1)'!$K$9+'DUKES 09 (5.1)'!$K$10)*Unit.GWh5.2145242500000002SUM(S135:AH135)5.2145242500000002-('DUKES 09 (5.1)'!$K$9+'DUKES 09 (5.1)'!$K$10)*Unit.GWh-5.2145242500000002SUM(AK135:BC135)-5.2145242500000002SUM(BF135:BG135)0Q135+AI135+BD135+BH1350
972SUM(AK136:BC136)0SUM(BF136:BG136)0Q136+AI136+BD136+BH1360
782INDEX(Modules[Module], MATCH($C137, Modules[Code], 0))Electricity grid distribution1206SUM(G137:P137)0-'DUKES 09 (1.2)'!$I$35*Unit.ktoe-26.469290502553953SUM(S137:AH137)-26.469290502553953SUM(AK137:BC137)0'DUKES 09 (1.2)'!$I$35*Unit.ktoe26.469290502553953SUM(BF137:BG137)26.469290502553953Q137+AI137+BD137+BH1370
792INDEX(Modules[Module], MATCH($C138, Modules[Code], 0))Storage, demand shifting, interconnection1205SUM(G138:P138)0('DUKES 09 (5.6)'!$K$248-'DUKES 09 (5.6)'!$M$249)*Unit.GWh-1.2254999999999996SUM(S138:AH138)-1.2254999999999996SUM(AK138:BC138)0('DUKES 09 (5.6)'!$M$249-'DUKES 09 (5.6)'!$K$245)*Unit.GWh1.2120398189999997'DUKES 09 (5.6)'!$K$247*Unit.GWh1.346018099999992E-2SUM(BF138:BG138)1.2254999999999996Q138+AI138+BD138+BH1380
673INDEX(Workstreams[Workstream], MATCH($C139, Workstreams[Code], 0))Electricity distribution, storage, and balancingG$135+G$137+G$1380000000000SUM(G139:P139)0S$135+S$137+S$1380-22.480266252553953000X$135+X$137+X$1380Y$135+Y$137+Y$1380Z$135+Z$137+Z$138000000000SUM(S139:AH139)-22.480266252553953AK$135+AK$137+AK$1380000-5.214524250000000200000000000000SUM(AK139:BC139)-5.2145242500000002BF$135+BF$137+BF$1381.2120398189999997BG$135+BG$137+BG$13826.482750683553952SUM(BF139:BG139)27.694790502553953Q139+AI139+BD139+BH1390
|
999INDEX(Modules[Module], MATCH($C141, Modules[Code], 0))Fossil fuel transfers1207SUM(G141:P141)0-(U$74+U$130+U$139)474.89060130021107-Z141-'DUKES 09 (1.2)'!$F$35*Unit.ktoe1047.089858423868-U141-474.89060130021107-'DUKES 09 (1.2)'!$F$10*Unit.ktoe-1059.1579462969482SUM(S141:AH141)-12.068087873080231'DUKES 09 (1.2)'!$F$35*Unit.ktoe12.068087873080305SUM(BF141:BG141)12.068087873080305Q141+AI141+BD141+BH1417.460698725481052E-14
1000INDEX(Modules[Module], MATCH($C142, Modules[Code], 0))Balancing imports1204SUM(G142:P142)0('DUKES 09 (1.2)'!$E$6+'DUKES 09 (1.2)'!$E$7)*Unit.ktoe-60.581053896315709('DUKES 09 (1.2)'!$B$6+'DUKES 09 (1.2)'!$B$7+'DUKES 09 (1.2)'!$C$6+'DUKES 09 (1.2)'!$C$7)*Unit.ktoe329.60273235621702('DUKES 09 (1.2)'!$D$6+'DUKES 09 (1.2)'!$D$7)*Unit.ktoe79.743976905201578('DUKES 09 (1.2)'!$F$6+'DUKES 09 (1.2)'!$F$7)*Unit.ktoe214.86865308275657SUM(S142:AH142)563.63430844785944-('DUKES 09 (1.2)'!$E$6+'DUKES 09 (1.2)'!$E$7)*Unit.ktoe60.581053896315709-('DUKES 09 (1.2)'!$B$6+'DUKES 09 (1.2)'!$B$7+'DUKES 09 (1.2)'!$C$6+'DUKES 09 (1.2)'!$C$7)*Unit.ktoe-329.60273235621702-('DUKES 09 (1.2)'!$D$6+'DUKES 09 (1.2)'!$D$7)*Unit.ktoe-79.743976905201578-('DUKES 09 (1.2)'!$F$6+'DUKES 09 (1.2)'!$F$7)*Unit.ktoe-214.86865308275657SUM(AK142:BC142)-563.63430844785944SUM(BF142:BG142)00
998INDEX(Workstreams[Workstream], MATCH($C143, Workstreams[Code], 0))TransfersSUM(G141:G142)0SUM(H141:H142)000000000SUM(G143:P143)0SUM(S141:S142)00474.89060130021107-60.5810538963157091047.089858423868-145.2878689439940679.743976905201578-844.2892932141917300000SUM(AF141:AF142)0SUM(AG141:AG142)00SUM(S143:AH143)551.56622057477921SUM(AK141:AK142)0000060.581053896315709-329.60273235621702-79.743976905201578-214.868653082756570000000000SUM(AK143:BC143)-563.63430844785944SUM(BF141:BF142)0SUM(BG141:BG142)12.068087873080305SUM(BF143:BG143)12.0680878730803057.460698725481052E-14
0
1002G$139+G$1430H$139+H$143000000000SUM(G145:P145)0S$139+S$1430-22.480266252553953474.89060130021107-60.5810538963157091047.089858423868X$139+X$143-145.28786894399406Y$139+Y$14379.743976905201578Z$139+Z$143-844.2892932141917300000000SUM(S145:AH145)529.08595432222523AK$139+AK$1430000-5.214524250000000260.581053896315709-329.60273235621702-79.743976905201578-214.868653082756570000000000SUM(AK145:BC145)-568.84883269785951BF$139+BF$1431.2120398189999997BG$139+BG$14338.550838556634261SUM(BF145:BG145)39.7628783756342590
0
0
593G$74+G$130+G$145544.74376989125381183.99501047219411443.27401323896316502.5055296707695316.2469981664359518.734693877551020318.81937240536579152.9916754147913329.22229142823090759.090632000000006SUM(G148:P148)1959.6239865655557S$74+S$130+S$145-352.03495223253594354.723826862619830-40.98525046434433215.0477685507453320.4668835385115244235.994120424665141-10.228142999999932-0.110456222300000712.9616599999983118E-300-0.34098803451720627000SUM(S148:AH148)2.5357710828444113AK$74+AK$130+AK$145-145.79944495555736-887.46007573003203-834.0611502141918-26.262503111111116-5.214524250000000260.581053896315709-329.60273235621702-79.743976905201578-214.86865308275657-163.24447683045062-0.53605914770000007-6.9788618847825861000-5.08839434000000070-58.005772267812624-14.240524277899516SUM(AK148:BC148)-2710.5260954573973BF$74+BF$130+BF$145561.41930248844437BG$74+BG$130+BG$145186.94703532055274SUM(BF148:BG148)748.366337808997060
|
|
7931225
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D