|
2020
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))Energy crops (first generation)INDEX(Vectors[Description], MATCH(AF$5,Vectors[Code],FALSE))Dry biomass and wasteINDEX(Vectors[Description], MATCH(AG$5,Vectors[Code],FALSE))Wet biomass and wasteINDEX(Vectors[Description], MATCH(AH$5,Vectors[Code],FALSE))Gaseous wasteINDEX(Vectors[Description], MATCH(AI$5,Vectors[Code],FALSE))Domestic solar thermalINDEX(Vectors[Description], MATCH(AJ$5,Vectors[Code],FALSE))H2685INDEX(Vectors[Description], MATCH(AM$5,Vectors[Code],FALSE))Coal reservesINDEX(Vectors[Description], MATCH(AN$5,Vectors[Code],FALSE))Oil reservesINDEX(Vectors[Description], MATCH(AO$5,Vectors[Code],FALSE))Gas reservesINDEX(Vectors[Description], MATCH(AP$5,Vectors[Code],FALSE))Biomass oversupply (imports)INDEX(Vectors[Description], MATCH(AQ$5,Vectors[Code],FALSE))Electricity oversupply (imports)INDEX(Vectors[Description], MATCH(AR$5,Vectors[Code],FALSE))Petroleum products oversupplyINDEX(Vectors[Description], MATCH(AS$5,Vectors[Code],FALSE))Coal oversupply (imports)INDEX(Vectors[Description], MATCH(AT$5,Vectors[Code],FALSE))Oil and petroleum products oversupply (imports)INDEX(Vectors[Description], MATCH(AU$5,Vectors[Code],FALSE))Gas oversupply (imports)INDEX(Vectors[Description], MATCH(AV$5,Vectors[Code],FALSE))Nuclear fissionINDEX(Vectors[Description], MATCH(AW$5,Vectors[Code],FALSE))SolarINDEX(Vectors[Description], MATCH(AX$5,Vectors[Code],FALSE))WindINDEX(Vectors[Description], MATCH(AY$5,Vectors[Code],FALSE))TidalINDEX(Vectors[Description], MATCH(AZ$5,Vectors[Code],FALSE))WaveINDEX(Vectors[Description], MATCH(BA$5,Vectors[Code],FALSE))GeothermalINDEX(Vectors[Description], MATCH(BB$5,Vectors[Code],FALSE))HydroINDEX(Vectors[Description], MATCH(BC$5,Vectors[Code],FALSE))Environmental heatINDEX(Vectors[Description], MATCH(BD$5,Vectors[Code],FALSE))AgricultureINDEX(Vectors[Description], MATCH(BE$5,Vectors[Code],FALSE))Waste686INDEX(Vectors[Description], MATCH(BH$5,Vectors[Code],FALSE))Conversion lossesINDEX(Vectors[Description], MATCH(BI$5,Vectors[Code],FALSE))Distribution losses and own use930INDEX(Vectors[Description], MATCH(BL$5,Vectors[Code],FALSE))UnallocatedINDEX(IPCC[Sector_description], MATCH(BO$5, IPCC[Sector_code], 0))Fuel CombustionINDEX(IPCC[Sector_description], MATCH(BS$5, IPCC[Sector_code], 0))Fugitive Emissions from FuelsINDEX(IPCC[Sector_description], MATCH(BW$5, IPCC[Sector_code], 0))Industrial ProcessesINDEX(IPCC[Sector_description], MATCH(CA$5, IPCC[Sector_code], 0))Solvent and Other Product UseINDEX(IPCC[Sector_description], MATCH(CE$5, IPCC[Sector_code], 0))AgricultureINDEX(IPCC[Sector_description], MATCH(CI$5, IPCC[Sector_code], 0))Land Use, Land-Use Change and ForestryINDEX(IPCC[Sector_description], MATCH(CM$5, IPCC[Sector_code], 0))WasteINDEX(IPCC[Sector_description], MATCH(CQ$5, IPCC[Sector_code], 0))OtherINDEX(IPCC[Sector_description], MATCH(CU$5, IPCC[Sector_code], 0))International Aviation and ShippingINDEX(IPCC[Sector_description], MATCH(CY$5, IPCC[Sector_code], 0))Bioenergy creditINDEX(IPCC[Sector_description], MATCH(DC$5, IPCC[Sector_code], 0))Carbon capture148
20065713363738399539544045464749506465661087517521772221675391622191315145798598698759607949779789797338910111210410125434356110501050105010501049104910491049222233334444555566667777103510351035103510361036103610361063106310631063
10401041104210431040104110421043104010411042104310401041104210431040104110421043104010411042104310401041104210431040104110421043104010411042104310401041104210431040104110421043
592
|
824INDEX(Modules[Module], MATCH($C9, Modules[Code], 0))Domestic space heating and hot waterIFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)375.30926613086353IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)375.30926613086353IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-32.6007970470135220-8.1607499217738955-7.3194354968487527-290.77293724876176IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000-5.8792228967333537000000-4.37350662586046560SUM(S9:AJ9)-349.10664923699176IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000-26.20261689387182700SUM(AM9:BE9)-26.202616893871827IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ9-4.9737991503207013E-14IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)57.8455903038907020.116906390262005430.170535486501148530000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BY$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), CI$6, INDIRECT($C9&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), CS$6, INDIRECT($C9&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
885INDEX(Modules[Module], MATCH($C10, Modules[Code], 0))Domestic hot water [UNUSED - See IX.a]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
934SUM(G9:G10)375.30926613086353SUM(H9:H10)000000000375.30926613086353SUM(S9:S10)-32.600797047013522SUM(T9:T10)0-8.1607499217738955-7.3194354968487527-290.77293724876176SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)00-5.87922289673335370SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)-4.37350662586046560-349.10664923699176SUM(AM9:AM10)0000000000000000-26.20261689387182700-26.202616893871827SUM(BH9:BH10)0SUM(BI9:BI10)00-4.9737991503207013E-14SUM(BO9:BO10)57.8455903038907020.116906390262005430.1705354865011485300000000000000000000000000000000000000000
932INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling114.34540083166861000000000114.34540083166861-29.53525557681055600-7.3972293892211516-67.502855617293932IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000-2.312342954711276400000000-106.74768353803691IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000000-7.597717293631697900-7.59771729363169790005.3290705182007514E-15IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)14.269832780887372.7199146068287834E-26.0050510504267324E-20000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BY$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), CI$6, INDIRECT($C12&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), CS$6, INDIRECT($C12&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
933INDEX(Modules[Module], MATCH($C13, Modules[Code], 0))Commercial hot water [UNUSED - See IX.c]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
935SUM(G12:G13)114.34540083166861SUM(H12:H13)000000000114.34540083166861SUM(S12:S13)-29.53525557681055600-7.3972293892211516-67.502855617293932SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)00-2.31234295471127640SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-106.74768353803691SUM(AM12:AM13)0000000SUM(AT12:AT13)000000000-7.597717293631697900-7.5977172936316979SUM(BH12:BH13)0SUM(BI12:BI13)005.3290705182007514E-15SUM(BO12:BO13)14.269832780887372.7199146068287834E-26.0050510504267324E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11489.65466696253213000000000489.65466696253213S14+S11-62.1360526238240780-8.1607499217738955-14.716664886069903-358.27579286605567000AA14+AA110-8.19156585144462920AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI11-4.37350662586046560-455.85433277502864AM14+AM110000000AT14+AT11000000000-33.80033418750352300-33.800334187503523BH14+BH110BI14+BI1100-2.8421709430404007E-14BO14+BO1172.1154230847780720.144105536330293270.2305859970054158500000000000000000000000000000000000000000SUM(BO15:DF15)72.490114618113779
00
937INDEX(Modules[Module], MATCH($C17, Modules[Code], 0))Domestic lighting, appliances, and cookingIFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)087.2655536762444800000000SUM(G17:P17)87.26555367624448IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-81.848847328585776000-5.4167063476587005IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-87.26555367624448IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM17:BE17)0IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0SUM(BH17:BI17)00IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), BO$6, INDIRECT($C17&".Emissions[IPCC Sector]"), BO$5),0)0.996673967969200711.9978187246534732E-32.1487511653832136E-30000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), BY$6, INDIRECT($C17&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), CI$6, INDIRECT($C17&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), CS$6, INDIRECT($C17&".Emissions[IPCC Sector]"), CS$5),0)000000000000001.0008205378592374
938INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering083.1416253913200900000000SUM(G18:P18)83.14162539132009-76.993952103222696000-6.14767328809738880000000000000SUM(S18:AJ18)-83.141625391320090000000000000000000SUM(AM18:BE18)0IFERROR(INDEX(INDIRECT($C18&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C18&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C18&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C18&".Outputs[Vector]"), 0)), 0)0SUM(BH18:BI18)001.13117188500991932.2674178771610268E-32.4387181608809725E-3000000000000000000000000000000000000000001.1358780210479613
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18170.4071790675645800000000SUM(G19:P19)170.40717906756458S17+S18-158.84279943180849T17+T18000-11.56437963575609X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-170.40717906756458AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)00BO17+BO182.127845852979124.2652366018144997E-34.5874693262641861E-3000000000000000000000000000000000000000002.1366985589071983
00
887INDEX(Modules[Module], MATCH($C21, Modules[Code], 0))Industrial processesIFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)00416.340580672644880000000SUM(G21:P21)416.34058067264488IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-154.423544043293530-50.17312828720415-77.75512293514177-125.83022041608795IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)00-8.15856499091744600000000SUM(S21:AJ21)-416.34058067264488IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM21:BE21)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0SUM(BH21:BI21)00IFERROR(SUMIFS(INDIRECT($C21&".Emissions["&this.Year&"]"), INDIRECT($C21&".Emissions[GHG]"), BO$6, INDIRECT($C21&".Emissions[IPCC Sector]"), BO$5),0)58.0448648028044970.116006862934567130.536552513122243610000015.1121764580779820.116878574302977882.87804059029586467.29277964915761160000000000000000000000000000-0.3804249465511244700083.716874504144613
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210416.340580672644880000000SUM(G22:P22)416.34058067264488S21-154.423544043293530-50.17312828720415-77.75512293514177-125.83022041608795000AA210-8.1585649909174460AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-416.34058067264488AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)00BO2158.0448648028044970.116006862934567130.536552513122243610000015.1121764580779820.116878574302977882.87804059029586467.29277964915761160000000000000000000000000000-0.3804249465511244700083.716874504144613
00
890INDEX(Modules[Module], MATCH($C24, Modules[Code], 0))Domestic passenger transportIFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000309.1271502941486313.47987536158183611.0372745218922860000SUM(G24:P24)333.64430017762277IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-10.58607651315575100-322.698848380303280IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000000000000-0.35937528416372705SUM(S24:AJ24)-333.64430017762277IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM24:BE24)0IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)00SUM(BH24:BI24)00IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), BO$6, INDIRECT($C24&".Emissions[IPCC Sector]"), BO$5),0)80.6747120950758190.100439698074680581.45150338038721190000000IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), BY$6, INDIRECT($C24&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), CI$6, INDIRECT($C24&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), CS$6, INDIRECT($C24&".Emissions[IPCC Sector]"), CS$5),0)0000000000000082.226655173537708
903INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00084.1209456861521122.6751944287020066027.645251098050831000SUM(G25:P25)114.44139121290496-0.1123286763378550100-114.3290625365670900000000000000-114.44139121290495000000000000000000000001.4210854715202004E-1428.5822656341417733.5584807878833995E-20.514253526410964330000000000000000000000000000000000000000029.132103968431572
906INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000194.222428842975400SUM(G26:P26)194.2224288429754000-194.222428842975400000000000000-194.22242884297540000000000000000000000000000000000000000000000000000000048.5556072107438516.0451539291921062E-20.8736148685611512300000000049.489673618596917
941INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
947SUM(G26:G27)0SUM(H26:H27)000000194.222428842975400194.2224288429754SUM(S26:S27)000-194.22242884297540000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-194.2224288429754SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000048.5556072107438516.0451539291921062E-20.8736148685611512300000000049.489673618596917
944INDEX(Modules[Module], MATCH($C29, Modules[Code], 0))International shippingIFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000050.735999999999898050.735999999999898000-50.7359999999998980IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-50.735999999999898IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)000000000000000000000000IFERROR(SUMIFS(INDIRECT($C29&".Emissions["&this.Year&"]"), INDIRECT($C29&".Emissions[GHG]"), BO$6, INDIRECT($C29&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C29&".Emissions["&this.Year&"]"), INDIRECT($C29&".Emissions[GHG]"), BY$6, INDIRECT($C29&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C29&".Emissions["&this.Year&"]"), INDIRECT($C29&".Emissions[GHG]"), CI$6, INDIRECT($C29&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C29&".Emissions["&this.Year&"]"), INDIRECT($C29&".Emissions[GHG]"), CS$6, INDIRECT($C29&".Emissions[IPCC Sector]"), CS$5),0)0012.6839999999999741.5791529926724165E-20.2282111506655765400000000012.928002680592275
946INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G29:G30)0SUM(H29:H30)000000050.735999999999898050.735999999999898SUM(S29:S30)000-50.7359999999998980000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-50.735999999999898SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)0000000000000000000000000000000012.6839999999999741.5791529926724165E-20.2282111506655765400000000012.928002680592275
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000393.2480959803007216.15506979028384311.03727452189228627.645251098050831194.222428842975450.7359999999998980693.04412023350301S24+S25+S28+S31-10.69840518949360600-681.986339759845690000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI310-0.35937528416372705-693.04412023350312AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI3100-1.1368683772161603E-13BO24+BO25+BO28+BO31109.25697772921760.136024505953514561.96575690679817640000000000000000000000000000061.2396072107438277.6243069218645224E-21.1018260192267277000000000173.7764354411585
00
917INDEX(Modules[Module], MATCH($C34, Modules[Code], 0))Food consumption [UNUSED]IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000SUM(G34:P34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000000000SUM(S34:AJ34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM34:BE34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0SUM(BH34:BI34)00IFERROR(SUMIFS(INDIRECT($C34&".Emissions["&this.Year&"]"), INDIRECT($C34&".Emissions[GHG]"), BO$6, INDIRECT($C34&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
680INDEX(Workstreams[Workstream], MATCH($C35, Workstreams[Code], 0))Food consumption [UNUSED]G340H34000000000SUM(G35:P35)0S340T340000X340Y340Z340000AD340AE3400AG340AH340AI3400SUM(S35:AJ35)0AM340000000000000000000SUM(AM35:BE35)0BH340BI340SUM(BH35:BI35)00BO34000000000000000000000000000000000000000000000
00
949INDEX(Modules[Module], MATCH($C37, Modules[Code], 0))GeosequestrationIFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000SUM(G37:P37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000000000SUM(S37:AJ37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM37:BE37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0SUM(BH37:BI37)00IFERROR(SUMIFS(INDIRECT($C37&".Emissions["&this.Year&"]"), INDIRECT($C37&".Emissions[GHG]"), BO$6, INDIRECT($C37&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
675INDEX(Workstreams[Workstream], MATCH($C38, Workstreams[Code], 0))GeosequestrationG370H37000000000SUM(G38:P38)0S3700000X370Y370Z370000AD370AE3700AG370AH370AI3700SUM(S38:AJ38)0AM370000000AT37000000000000SUM(AM38:BE38)0BH370BI370SUM(BH38:BI38)00BO37000000000000000000000000000000000000000000000
SUM(AM39:BE39)00
1785619G$15+G$19+G$22+G$32+G$35+G$38489.65466696253213170.40717906756458416.34058067264488393.2480959803007216.15506979028384311.03727452189228627.645251098050831194.222428842975450.73599999999989801769.4465469362447S$15+S$19+S$22+S$32+S$35+S$38-386.100801288419690-58.333878208978049-774.4581275810574-495.67039291789973X$15+X$19+X$22+X$32+X$35+X$380Y$15+Y$19+Y$22+Y$32+Y$35+Y$380Z$15+Z$19+Z$22+Z$32+Z$35+Z$3800-16.350130842362077000000-4.3735066258604656-0.35937528416372705SUM(S40:AJ40)-1735.6462127487409AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000-33.80033418750352300SUM(AM40:BE40)-33.800334187503523BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)01.9895196601282805E-13BO$15+BO$19+BO$22+BO$32+BO$35+BO$38241.54511146977930.400402141820189462.73748288625210010000015.1121764580779820.116878574302977882.87804059029586467.29277964915761160000000000000000000061.2396072107438277.6243069218645224E-21.101826019226727700000-0.38042494655112447000SUM(BO40:DF40)332.12012312232423
0
720
0
18931894AJ$40-0.359375284163727050SUM(BO44:DF44)0
968INDEX(Modules[Module], MATCH($C45, Modules[Code], 0))H2 Production for TransportIFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0000000000SUM(G45:P45)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)-0.16586551576787403000-0.35820085513051225IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)00000000000.35937528416372705SUM(S45:AJ45)-0.16469108673465921IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM45:BE45)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0.16469108673465924IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)0.16469108673465924IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)6.5908957344014238E-21.321135630466549E-41.4209455995997232E-400000000000000000000000000000000000000000SUM(BO45:DF45)6.6183165467020869E-2
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45-0.16586551576787403000-0.35820085513051225000000AD450AE4500AG450AH450AI4500.35937528416372705SUM(S46:AJ46)-0.16469108673465921AM450AN45000000000000000000SUM(AM46:BE46)0BH450.16469108673465924BI450SUM(BH46:BI46)0.16469108673465924Q46+AK46+BF46+BJ460BO456.5908957344014238E-21.321135630466549E-41.4209455995997232E-400000000000000000000000000000000000000000SUM(BO46:DF46)6.6183165467020869E-2
Q47+AK47+BF47+BJ4700
2205INDEX(Modules[Module], MATCH($C48, Modules[Code], 0))Marine algaeIFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000000SUM(G48:P48)0IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000005.8333333333333345E-3000SUM(S48:AJ48)5.8333333333333345E-3IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000000000000000-5.8333333333333345E-30SUM(AM48:BE48)-5.8333333333333345E-3IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00SUM(BH48:BI48)0IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), BO$6, INDIRECT($C48&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), BY$6, INDIRECT($C48&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), CI$6, INDIRECT($C48&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), CS$6, INDIRECT($C48&".Emissions[IPCC Sector]"), CS$5),0)00000000000000SUM(BO48:DF48)0
952INDEX(Modules[Module], MATCH($C49, Modules[Code], 0))Volume of Waste & Recycling0000000000SUM(G49:P49)00000051.961461749539815000000023.00667680269879217.3427021451062819.34760981929299500SUM(S49:AJ49)111.65845051663787000000000000000000-111.65845051663788SUM(AM49:BE49)-111.6584505166378800SUM(BH49:BI49)0000000000000000000000000017.8460065490640681.36299488505732010000000000000000019.209001434121387
911INDEX(Modules[Module], MATCH($C50, Modules[Code], 0))Agriculture and land useIFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)0010.6413450267741470000000SUM(G50:P50)10.641345026774147IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.25653801070965890-0.8513076021419318-3.5116438588354684-2.021855555087087800000035.568182018281761.349356744907436835.75564983291513243.488493311512116000SUM(S50:AJ50)105.52033688084229000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-36.917538763189199-79.244143144427255SUM(AM50:BE50)-116.1616819076164500SUM(BH50:BI50)0Q50+AK50+BF50+BJ50-1.4210854715202004E-141.51213512830460612.6089642097343432E-31.8920192788020086E-20000000000000014.78174079608332621.41759999999999307.26274106512561170000000000000000000000044.995746146511294
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.6413450267741470000000SUM(G51:P51)10.641345026774147SUM(S48:S50)-4.25653801070965890-0.8513076021419318-3.5116438588354684-2.021855555087087851.9614617495398150000035.56818201828176SUM(AE48:AE50)1.349356744907436858.76232663561392460.837028789951731SUM(AH48:AH50)19.34760981929299500SUM(S51:AJ51)217.18462073081349SUM(AM48:AM50)00000000000000000-36.923372096522534-190.90259366106514SUM(AM51:BE51)-227.82596575758768SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ51-2.8421709430404007E-14SUM(BO48:BO50)1.51213512830460612.6089642097343432E-31.8920192788020086E-20000000000000014.78174079608332621.41759999999999307.2627410651256117000017.8460065490640681.36299488505732010000000000000000064.204747580632684
Q52+AK52+BF52+BJ5200
958INDEX(Modules[Module], MATCH($C53, Modules[Code], 0))Petroleum refineriesIFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000000000SUM(G53:P53)0IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)-5.811946425969375200-47.6369582485937-2.1192077257804574IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.682502438661960700000000SUM(S53:AJ53)-56.250614839005493IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM53:BE53)0IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)56.250614839005493SUM(BH53:BI53)56.250614839005493Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)12.2991737836920281.5608573814431257E-20.215112290534936190000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BY$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), CI$6, INDIRECT($C53&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), CS$6, INDIRECT($C53&".Emissions[IPCC Sector]"), CS$5),0)0000000000000012.529894648041395
975INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0034.4646640501325340000000SUM(G54:P54)34.464664050132534-1.29909891475261330-4.5962264076921833E-20-33.119602871302995127.93501.7889500727494383.120645938559960000000000SUM(S54:AJ54)978.3749319611768-127.93-501.7889500727494-383.120645938559960000000000000000SUM(AM54:BE54)-1012.8395960113094IFERROR(INDEX(INDIRECT($C54&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C54&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C54&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C54&".Outputs[Vector]"), 0)), 0)0SUM(BH54:BI54)06.07678720210741391.2180833099154388E-21.3101078188005414E-202.61806821909111112.71532885258236290000000000000000000000000000000000000011.435466185068048
956INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)034.4646640501325340000000SUM(G55:P55)34.464664050132534SUM(S53:S54)-7.11104534072198820-4.5962264076921833E-2-47.6369582485937-35.23881059708345SUM(X53:X54)127.93SUM(Y53:Y54)501.7889500727494SUM(Z53:Z54)383.120645938559960-0.68250243866196070SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)922.12431712217142SUM(AM53:AM54)-127.93-501.7889500727494-383.120645938559960000000000000000SUM(AM55:BE55)-1012.8395960113094SUM(BH53:BH54)0SUM(BI53:BI54)56.250614839005493SUM(BH55:BI55)56.250614839005493Q55+AK55+BF55+BJ551.1368683772161603E-13SUM(BO53:BO54)18.3759609857994412.7789406913585647E-20.228213368722941602.61806821909111112.71532885258236290000000000000000000000000000000000000023.96536083310944
Q56+AK56+BF56+BJ5600
1701INDEX(Modules[Module], MATCH($C57, Modules[Code], 0))Onshore windIFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000SUM(G57:P57)0IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)037.799167319999995000IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S57:AJ57)37.799167319999995IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00000000000-37.7991673199999950000000SUM(AM57:BE57)-37.799167319999995IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00SUM(BH57:BI57)00IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), BO$6, INDIRECT($C57&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), BY$6, INDIRECT($C57&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), CI$6, INDIRECT($C57&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), CS$6, INDIRECT($C57&".Emissions[IPCC Sector]"), CS$5),0)000000000000000
1702INDEX(Modules[Module], MATCH($C58, Modules[Code], 0))Offshore wind0000000000SUM(G58:P58)0051.8421765960000090000000000000000SUM(S58:AJ58)51.84217659600000900000000000-51.8421765960000090000000SUM(AM58:BE58)-51.84217659600000900SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
798INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric power stations0000000000005.995944000000000600000000000000005.9959440000000006000000000000000-5.9959440000000006000-5.99594400000000060000000000000000000000000000000000000000000000000
803INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Tidal and Wave0000000000000.808070427397260200000000000000000.8080704273972602000000000000-0.64962864657534247-0.158441780821917700000-0.80807042739726020000000000000000000000000000000000000000000000000
804INDEX(Modules[Module], MATCH($C61, Modules[Code], 0))Geothermal electricity0000000000000.3646655999999999800000000000000000.3646655999999999800000000000000-0.364665599999999980000-0.364665599999999980000000000000000000000000000000000000000000000000
805INDEX(Modules[Module], MATCH($C62, Modules[Code], 0))Tidal [UNUSED - See III.c]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
76INDEX(Workstreams[Workstream], MATCH($C63, Workstreams[Code], 0))National renewable power generationSUM(G57:G62)00000000000SUM(S57:S62)096.8100239433972550000000000SUM(AE57:AE62)000SUM(AH57:AH62)00096.810023943397255SUM(AM57:AM62)00000000000-89.641343916000011-0.64962864657534247-0.1584417808219177-0.36466559999999998-5.9959440000000006000-96.810023943397255SUM(BH57:BH62)0SUM(BI57:BI62)000SUM(BO57:BO62)000000000000000000000000000000000000000000000
0
963INDEX(Modules[Module], MATCH($C65, Modules[Code], 0))Solar PVIFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000SUM(G65:P65)0IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)00.76377523937797442000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)0.76377523937797442IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-0.7637752393779744200000000SUM(AM65:BE65)-0.76377523937797442IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)00SUM(BH65:BI65)0Q65+AK65+BF65+BJ650IFERROR(SUMIFS(INDIRECT($C65&".Emissions["&this.Year&"]"), INDIRECT($C65&".Emissions[GHG]"), BO$6, INDIRECT($C65&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
1313INDEX(Modules[Module], MATCH($C66, Modules[Code], 0))Solar thermal00.3123933304186046800000000SUM(G66:P66)0.31239333041860468-0.312393330418604680000000000000004.37350662586046560SUM(S66:AJ66)4.06111329544186090000000000-4.373506625860465600000000SUM(AM66:BE66)-4.373506625860465600SUM(BH66:BI66)00000000000000000000000000000000000000000000000
1574INDEX(Modules[Module], MATCH($C67, Modules[Code], 0))Small-scale wind0000000000SUM(G67:P67)000.133593840000000130000000000000000SUM(S67:AJ67)0.1335938400000001300000000000-0.133593840000000130000000SUM(AM67:BE67)-0.1335938400000001300SUM(BH67:BI67)00000000000000000000000000000000000000000000000
77INDEX(Workstreams[Workstream], MATCH($C68, Workstreams[Code], 0))Distributed renewable power generationSUM(G65:G67)0SUM(H65:H67)0.3123933304186046800000000SUM(G68:P68)0.31239333041860468SUM(S65:S67)-0.312393330418604680.89736907937797450000000000SUM(AE65:AE67)000SUM(AH65:AH67)04.37350662586046560SUM(S68:AJ68)4.9584823748198357SUM(AM65:AM67)0000000000-5.1372818652384398-0.133593840000000130000000SUM(AM68:BE68)-5.2708757052384403SUM(BH65:BH67)0SUM(BI65:BI67)0SUM(BH68:BI68)00SUM(BO65:BO67)0SUM(BP65:BP67)00000000000000000000000000000000000000000000
00
16891324AB$40+AB$46+AB$51+AB$99+AB$55+AB$63+AB$68-17.032633281024037SUM(BH70:BI70)000
1322INDEX(Modules[Module], MATCH($C71, Modules[Code], 0))District heating effective demandIFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0000000000SUM(G71:P71)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0-2.4332333258605767000IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0017.03263328102403700000000SUM(S71:AJ71)14.599399955163459IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM71:BE71)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)-14.599399955163459IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-14.599399955163459Q71+AK71+BF71+BJ710IFERROR(SUMIFS(INDIRECT($C71&".Emissions["&this.Year&"]"), INDIRECT($C71&".Emissions[GHG]"), BO$6, INDIRECT($C71&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
1320INDEX(Workstreams[Workstream], MATCH($C72, Workstreams[Code], 0))District heatingG710H71000000000SUM(G72:P72)0S710-2.4332333258605767000000017.0326332810240370AD710AE71000AH710AI7100SUM(S72:AJ72)14.599399955163459AM710AN71000000000000000000SUM(AM72:BE72)0BH71-14.599399955163459BI710SUM(BH72:BI72)-14.599399955163459Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16901318S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-397.94664348603783T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$7265.45961265841666SUM(BH74:BI74)0Q74+AK74+BF74+BJ7400
754INDEX(Modules[Module], MATCH($C75, Modules[Code], 0))Nuclear powerIFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)0000000000SUM(G75:P75)0IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)047.687040000000017000IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)00000000000SUM(S75:AJ75)47.687040000000017IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-145.71040000000005000000000SUM(AM75:BE75)-145.71040000000005IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)93.25465600000004IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)4.7687040000000023SUM(BH75:BI75)98.0233600000000390IFERROR(SUMIFS(INDIRECT($C75&".Emissions["&this.Year&"]"), INDIRECT($C75&".Emissions[GHG]"), BO$6, INDIRECT($C75&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
75INDEX(Workstreams[Workstream], MATCH($C76, Workstreams[Code], 0))Nuclear power generationG750H75000000000SUM(G76:P76)0S75047.687040000000017000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)47.687040000000017AM750AN7500000000-145.71040000000005000000000SUM(AM76:BE76)-145.71040000000005BH7593.25465600000004BI754.7687040000000023SUM(BH76:BI76)98.0233600000000390BO75000000000000000000000000000000000000000000000
00
16911318S$74+S$76-397.94664348603783T$74+T$76113.1466526584166800
868INDEX(Modules[Module], MATCH($C79, Modules[Code], 0))Carbon Capture Storage (CCS)IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0000000000SUM(G79:P79)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)010.834644510000002-20.6975000000000050-5.6830423728813573IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)00000000000SUM(S79:AJ79)-15.545897862881361IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM79:BE79)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)13.713672372881359IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)1.8322254900000003SUM(BH79:BI79)15.5458978628813590IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)7.42050979661016992.0822997036075902E-25.8725921113734557E-20000000000000000000000000000000000000-6.67845881694915280000.82159989781082743
16921318S78+S79-397.94664348603783T78+T79123.9812971684166900
740INDEX(Modules[Module], MATCH($C81, Modules[Code], 0))Biomass/Coal power stationsIFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0000000000SUM(G81:P81)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0273.96534631762114-273.841073999999990-372.67737616794716IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)00000000000SUM(S81:AJ81)-372.55310385032601IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM81:BE81)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)364.33538618397353IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)8.2177176663524225SUM(BH81:BI81)372.55310385032595Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)152.915688006902260.385222274936800390.894991294287878600000000000000000000000000000000000000000154.19590157612694
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810284.79999082762112-294.538573999999980-378.3604185408285000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-388.09900171320737AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81378.0490585568549BI79+BI8110.049943156352423SUM(BH82:BI82)388.099001713207310BO79+BO81160.336197803512420.406045271972876320.953717215401613140000000000000000000000000000000000000-6.6784588169491528000155.01750147393776
SUM(AM83:BE83)00
1786249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$4600.3123933304186046845.106009076906680000000SUM(G84:P84)45.418402407325289S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-11.845842197618127427.76119052453578-295.43584386621882-51.14860210742917-415.97928554812955179.89146174953981501.7889500727494383.12064593855996016.350130842362077035.568182018281761.349356744907436858.76232663561392460.83702878995173119.3476098192929954.37350662586046560.35937528416372705SUM(S84:AJ84)915.10019132642356AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-127.93-501.7889500727494-383.12064593855996000000-145.71040000000005-5.1372818652384398-89.774937756000014-0.64962864657534247-0.1584417808219177-0.36466559999999998-5.99594400000000060-36.923372096522534-190.90259366106514SUM(AM84:BE84)-1488.456861417533BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46456.86900568842611BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4671.06926199535792SUM(BH84:BI84)527.938267683784030BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46180.29020287496050.436575756659242981.200992871472534902.61806821909111112.71532885258236290000000000014.78174079608332621.41759999999999307.2627410651256117000017.8460065490640681.36299488505732010000000000000-6.678458816949152800DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)243.25379305314689
0
9730
0
|
772INDEX(Modules[Module], MATCH($C89, Modules[Code], 0))Electricity importsIFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(G89:P89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)00000000000SUM(S89:AJ89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM89:BE89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0SUM(BH89:BI89)0Q89+AK89+BF89+BJ890IFERROR(SUMIFS(INDIRECT($C89&".Emissions["&this.Year&"]"), INDIRECT($C89&".Emissions[GHG]"), BO$6, INDIRECT($C89&".Emissions[IPCC Sector]"), BO$5),0)00000000000000000000000000000000000000000000
16931319S$40+$S46+S$51+S$99+S$55+S$89-397.63425015561921T$40+$S46+T$51+T$99+T$55+T$89-0.165865515767874030
782INDEX(Modules[Module], MATCH($C91, Modules[Code], 0))Electricity grid distributionIFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000SUM(G91:P91)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0-29.814547038498006000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-29.814547038498006IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM91:BE91)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)29.814547038498006SUM(BH91:BI91)29.8145470384980060IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BO$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BY$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CI$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CS$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
792INDEX(Modules[Module], MATCH($C92, Modules[Code], 0))Storage, demand shifting, interconnection0000000000SUM(G92:P92)0000000000000000000SUM(S92:AJ92)00000000000000000000SUM(AM92:BE92)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0SUM(BH92:BI92)001.4778633402142135E-22.9623559443163064E-53.1861578375854112E-500000000000000000000000000000000000000000
673INDEX(Workstreams[Workstream], MATCH($C93, Workstreams[Code], 0))Electricity distribution, storage, and balancingG$89+G$91+G$920000000000SUM(G93:P93)0S$89+S$91+S$920-29.814547038498006000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-29.814547038498006AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9229.814547038498006SUM(BH93:BI93)29.8145470384980060BO$89+BO$91+BO$921.4778633402142135E-22.9623559443163064E-53.1861578375854112E-500000000000000000000000000000000000000000SUM(BO93:DF93)1.4840118539961152E-2
00
16941642(U$40+U$84+U$93)-353.76972207519685(V$40+V$84+V$93)-825.60672968848655(W$40+W$84+W$93)-911.64967846602929(AC$40+AC$84+AC$93)035.568182018281761.349356744907436858.76232663561392460.83702878995173119.347609819292995BE40+BE46+BE51-190.90259366106514SUM(AM95:BE95)-190.902593661065140
950INDEX(Modules[Module], MATCH($C96, Modules[Code], 0))Types of fuel from BiomassIFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0000000000SUM(G96:P96)0IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0084.8974577885061310.4183005909213053964.9753814117568000000-35.56818201828176-1.3493567449074368-58.762326635613924-60.837028789951731-19.34760981929299500SUM(S96:AJ96)-25.573364216863613IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM96:BE96)0IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)25.573364216863581IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)25.573364216863581Q96+AK96+BF96+BJ96-3.1974423109204508E-14IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-38.2084623263534550000000-38.208462326353455
16951642U$95+U$96-268.87226428669072V$95+V$96-825.18842909756529W$95+W$96-846.67429705427253AC$95+AC$96000000BE42+BE49+BE53-111.65845051663788SUM(AM97:BE97)-111.65845051663788SUM(BO97:DF97)0
1666INDEX(Modules[Module], MATCH($C98, Modules[Code], 0))Bioenergy importsIFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0000000000SUM(G98:P98)0IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0013.6484697674418610.30552093023255900000000000000SUM(S98:AJ98)23.953990697674421IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-23.953990697674421000000000000000SUM(AM98:BE98)-23.953990697674421IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0SUM(BH98:BI98)0Q98+AK98+BF98+BJ980IFERROR(SUMIFS(INDIRECT($C98&".Emissions["&this.Year&"]"), INDIRECT($C98&".Emissions[GHG]"), BO$6, INDIRECT($C98&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-6.78010892093023190000000SUM(BO98:DF98)-6.7801089209302319
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S980098.54592755594799810.72382152115386464.9753814117568000000AD$96+AD98-35.56818201828176AE$96+AE98-1.3493567449074368-58.762326635613924-60.837028789951731AH$96+AH98-19.34760981929299500SUM(S99:AJ99)-1.6193735191891925AM$96+AM98000-23.953990697674421000000000000000SUM(AM99:BE99)-23.953990697674421BH$96+BH9825.573364216863581BI$96+BI980SUM(BH99:BI99)25.573364216863581Q99+AK99+BF99+BJ99-3.1974423109204508E-14BO$96+BO98000000000000000000000000000000000000-44.9885712472836870000000-44.988571247283687
0
16961209(S$40+S$84+S$93+S$99)-397.94664348603783(T$40+T$84+T$93+T$99)397.94664348603777(U$40+U$84+U$93+U$99)-255.22379451924886(V$40+V$84+V$93+V$99)-814.88290816733274(W$40+W$84+W$93+W$99)-846.674297054272530
999INDEX(Modules[Module], MATCH($C102, Modules[Code], 0))Fossil fuel transfersIFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0000000000SUM(G102:P102)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)00255.22379451924886814.88290816733274846.67429705427253-255.22379451924886-814.88290816733274-856.43252337508670000000000SUM(S102:AJ102)-9.758226320814174IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM102:BE102)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)9.7582263208141935SUM(BH102:BI102)9.7582263208141935Q102+AK102+BF102+BJ1021.9539925233402755E-14IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000003.8261407236125340000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BY$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), CI$6, INDIRECT($C102&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), CS$6, INDIRECT($C102&".Emissions[IPCC Sector]"), CS$5),0)000000000000003.826140723612534
7931000INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)5.6843418860808015E-14-(X$40+X$84+X$93+X$99+X$102)75.332332769709041-(Y$40+Y$84+Y$93+Y$99+Y$102)313.09395809458334-(Z$40+Z$84+Z$93+Z$99+Z$102)473.31187743652674SUM(S103:AJ103)861.73816830081921-T103-5.6843418860808015E-14-V1030-X103-75.332332769709041-Y103-313.09395809458334-Z103-473.31187743652674SUM(AM103:BE103)-861.73816830081921SUM(BH103:BI103)00000000000000000000000000000000000000000000000
793998INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)05.6843418860808015E-14255.22379451924886814.88290816733274846.67429705427253-179.89146174953981-501.7889500727494-383.12064593855996000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)851.97994198000504SUM(AM102:AM103)0000-5.6843418860808015E-140-75.332332769709041-313.09395809458334-473.311877436526740000000000SUM(AM104:BE104)-861.73816830081921SUM(BH102:BH103)0SUM(BI102:BI103)9.7582263208141935SUM(BH104:BI104)9.75822632081419351.9539925233402755E-14SUM(BO102:BO103)000003.826140723612534000000000000000000000000000000000000003.826140723612534
0
17871002G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-29.814547038497949353.76972207519685825.60672968848655911.64967846602929-179.89146174953981-501.7889500727494-383.12064593855996000-35.56818201828176-1.3493567449074368-58.762326635613924-60.837028789951731-19.34760981929299500SUM(S106:AJ106)820.54602142231761AM$93+AM$99+AM$104000-23.953990697674421-5.6843418860808015E-140-75.332332769709041-313.09395809458334-473.311877436526740000000000SUM(AM106:BE106)-885.6921589984936BH$93+BH$99+BH$10425.573364216863581BI$93+BI$99+BI$10439.572773359312201SUM(BH106:BI106)65.146137576175789-1.9895196601282805E-13BO$93+BO$99+BO$1041.4778633402142135E-22.9623559443163064E-53.1861578375854112E-5003.826140723612534000000000000000000000000000000-44.988571247283687000000DF$93+DF$1040SUM(BO106:DF106)-41.14759040513119
0
0
593G$40+G$84+G$106489.65466696253213170.7195723979832461.44658974955155393.2480959803007216.15506979028384311.03727452189228627.645251098050831194.222428842975450.7359999999998980SUM(G109:P109)1814.8649493435694S$40+S$84+S$106-397.94664348603783397.946643486037830000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-127.93-501.7889500727494-383.12064593855996-23.953990697674421-5.6843418860808015E-140-75.332332769709041-313.09395809458334-473.31187743652674-145.71040000000005-5.1372818652384398-89.774937756000014-0.64962864657534247-0.1584417808219177-0.36466559999999998-5.9959440000000006-33.800334187503523-36.923372096522534-190.90259366106514SUM(AM109:BE109)-2407.9493546035296BH$40+BH$84+BH$106482.44236990528969BI$40+BI$84+BI$106110.64203535467013SUM(BH109:BI109)593.084405259959790BO$40+BO$84+BO$106421.850092978141960.837007522038875633.938507619303010602.61806821909111116.54146957619489730015.1121764580779820.116878574302977882.87804059029586467.29277964915761160000014.78174079608332621.41759999999999307.2627410651256117000017.8460065490640681.36299488505732010000061.2396072107438277.6243069218645224E-21.10182601922672770-44.988571247283687000-7.058883763500277000SUM(BO109:DF109)534.22632577034005
|
|
2329SUM(DH63,DH68,DH76,DH82)155.01750147393776
79310032330T109-MIN(T103,0)-T72400.37987681189838
2331DH112/DH1130.38717605567066549
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D