|
2010
Preferences.EnergyUnitsTWh74968910519321055
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]937INDEX(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 use931INDEX(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
20065713363738399549554045464749506465661087517521780223875391722411319146498798898959607959799809817338910111210410155434356110531053105310531052105210521052222233334444555566667777103810381038103810391039103910391066106610661066
10431044104510461043104410451046104310441045104610431044104510461043104410451046104310441045104610431044104510461043104410451046104310441045104610431044104510461043104410451046
592
|
825INDEX(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)405.72431390398282IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)405.72431390398282IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-33.6221276433132910-13.147942484875603-11.792484496744096-347.16175927904982IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S9:AJ9)-405.72431390398282IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM9:BE9)0IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ90IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)70.8754511168728670.143608625921814090.226631342600366330000000IFERROR(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
886INDEX(Modules[Module], MATCH($C10, Modules[Code], 0))Domestic hot water [UNUSED - See IX.a]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
935SUM(G9:G10)405.72431390398282SUM(H9:H10)000000000405.72431390398282SUM(S9:S10)-33.622127643313291SUM(T9:T10)0-13.147942484875603-11.792484496744096-347.16175927904982SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)0000SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)00-405.72431390398282SUM(AM9:AM10)00000000000000000000SUM(BH9:BH10)0SUM(BI9:BI10)000SUM(BO9:BO10)70.8754511168728670.143608625921814090.2266313426003663300000000000000000000000000000000000000000
933INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling121.4183547665174000000000121.4183547665174-31.40903797859883900-9.3578027720732795-80.651514015845265IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000-121.41835476651738IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)000000000000000000000001.4210854715202004E-14IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)17.1793292719338453.2658931401947748E-27.4085129903368269E-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
934INDEX(Modules[Module], MATCH($C13, Modules[Code], 0))Commercial hot water [UNUSED - See IX.c]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
936SUM(G12:G13)121.4183547665174SUM(H12:H13)000000000121.4183547665174SUM(S12:S13)-31.40903797859883900-9.3578027720732795-80.651514015845265SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)0000SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-121.41835476651738SUM(AM12:AM13)0000000SUM(AT12:AT13)0000000000000SUM(BH12:BH13)0SUM(BI12:BI13)001.4210854715202004E-14SUM(BO12:BO13)17.1793292719338453.2658931401947748E-27.4085129903368269E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11527.14266867050026000000000527.14266867050026S14+S11-65.0311656219121230-13.147942484875603-21.150287268817376-427.81327329489511000AA14+AA11000AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI1100-527.14266867050026AM14+AM110000000AT14+AT110000000000000BH14+BH110BI14+BI11000BO14+BO1188.0547803888067050.176267557323761840.3007164725037345700000000000000000000000000000000000000000SUM(BO15:DF15)88.531764418634211
00
938INDEX(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)095.39317091355827900000000SUM(G17:P17)95.393170913558279IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-87.37770781750622000-8.0154630960520556IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-95.393170913558279IFERROR(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)1.4748452096735782.9563061447817444E-33.1796509840657156E-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.4809811668024255
939INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering082.03479844854477700000000SUM(G18:P18)82.034798448544777-73.047740889398199000-8.9870575591465780000000000000SUM(S18:AJ18)-82.0347984485447770000000000000000000SUM(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.65361859088297013.3146548324448437E-33.5650724193178997E-3000000000000000000000000000000000000000001.6604983181347328
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18177.4279693621030600000000SUM(G19:P19)177.42796936210306S17+S18-160.42544870690443T17+T18000-17.002520655198634X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-177.42796936210306AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)00BO17+BO183.12846380055654826.2709609772265886E-36.7447234033836158E-3000000000000000000000000000000000000000003.1414794849371583
00
888INDEX(Modules[Module], MATCH($C21, Modules[Code], 0))Industrial processesIFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)00411.162565673149120000000SUM(G21:P21)411.16256567314912IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-115.08718969824150-54.894239987253606-82.133198215891667-150.99084060276388IFERROR(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.057097168998474500000000SUM(S21:AJ21)-411.16256567314912IFERROR(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)65.2230401409555750.130921036986789170.579107291927003160000014.3970008912050740.112590959012936612.76224515695433810.0939752854540390000000000000000000000000000000093.298880762495742
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210411.162565673149120000000SUM(G22:P22)411.16256567314912S21-115.08718969824150-54.894239987253606-82.133198215891667-150.99084060276388000AA210-8.05709716899847450AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-411.16256567314912AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)00BO2165.2230401409555750.130921036986789170.579107291927003160000014.3970008912050740.112590959012936612.76224515695433810.0939752854540390000000000000000000000000000000093.298880762495742
00
891INDEX(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)000378.0627418693890715.281084393926859.55109732951690130000SUM(G24:P24)402.89492359283281IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-8.081440121990915800-394.81348347084190IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S24:AJ24)-402.89492359283281IFERROR(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)98.7033708677104760.122885307073952011.77587589406270880000000IFERROR(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)00000000000000100.60213206884714
904INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00092.2242878564000822.443403009406389026.572895707388618000SUM(G25:P25)121.24058657319509-0.1025959918508500100-121.1379905813442400000000000000-121.2405865731950900000000000000000000000030.284497645336063.7704080012782477E-20.544880168320017290000000000000000000000000000000000000000030.86708189366886
907INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000153.6308279436282500SUM(G26:P26)153.63082794362825000-153.6308279436282500000000000000-153.630827943628250000000000000000000000000000000000000000000000000000000038.4077069859070624.7817443573384216E-20.691033349549051600000000039.1465577790295
942INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G26:G27)0SUM(H26:H27)000000153.6308279436282500153.63082794362825SUM(S26:S27)000-153.630827943628250000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-153.63082794362825SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000038.4077069859070624.7817443573384216E-20.691033349549051600000000039.1465577790295
945INDEX(Modules[Module], MATCH($C29, Modules[Code], 0))International shipping (maritime bunkers)IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000033.337857580646393033.337857580646393000-33.3378575806463930IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-33.337857580646393IFERROR(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)008.33446439516159821.0376375269584648E-20.14995409254187250000000008.4947948629730554
947INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
949SUM(G29:G30)0SUM(H29:H30)000000033.337857580646393033.337857580646393SUM(S29:S30)000-33.3378575806463930000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-33.337857580646393SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)000000000000000000000000000000008.33446439516159821.0376375269584648E-20.14995409254187250000000008.4947948629730554
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000470.2870297257891317.7244874033332399.551097329516901326.572895707388618153.6308279436282533.3378575806463930711.1041956903025S24+S25+S28+S31-8.184036113841765200-702.920159576460720000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI3100-711.1041956903025AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI31000BO24+BO25+BO28+BO31128.987868513046520.160589387086734482.32075606238272590000000000000000000000000000046.7421713810686585.8193818842968863E-20.84098744209092413000000000179.11056660451851
00
918INDEX(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
950INDEX(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
1793619G$15+G$19+G$22+G$32+G$35+G$38527.14266867050026177.42796936210306411.16256567314912470.2870297257891317.7244874033332399.551097329516901326.572895707388618153.6308279436282533.33785758064639301826.8373993960549S$15+S$19+S$22+S$32+S$35+S$38-348.727840140899840-68.042182472129213-806.20364506116971-595.80663455285764X$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-8.057097168998474500000000SUM(S40:AJ40)-1826.8373993960549AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000000SUM(AM40:BE40)0BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)00BO$15+BO$19+BO$22+BO$32+BO$35+BO$38285.394152843365360.474048942374512063.2073245502168470000014.3970008912050740.112590959012936612.76224515695433810.0939752854540390000000000000000000046.7421713810686585.8193818842968863E-20.84098744209092413000000000SUM(BO40:DF40)364.08269127058577
0
720
0
19011902AJ$4000SUM(BO44:DF44)0
969INDEX(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)00000IFERROR(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)00000000000SUM(S45:AJ45)0IFERROR(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)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)0IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)00000000000000000000000000000000000000000000SUM(BO45:DF45)0
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S4500000000000AD450AE4500AG450AH450AI4500SUM(S46:AJ46)0AM450AN45000000000000000000SUM(AM46:BE46)0BH450BI450SUM(BH46:BI46)0Q46+AK46+BF46+BJ460BO4500000000000000000000000000000000000000000000SUM(BO46:DF46)0
Q47+AK47+BF47+BJ4700
2227INDEX(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)0000000000000SUM(S48:AJ48)0IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM48:BE48)0IFERROR(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
953INDEX(Modules[Module], MATCH($C49, Modules[Code], 0))Waste arising0000000000SUM(G49:P49)00000033.531381051081439000000013.5146285924945324.070676012641907718.39713863386220900SUM(S49:AJ49)69.513824290080095000000000000000000-69.513824290080095SUM(AM49:BE49)-69.51382429008009500SUM(BH49:BI49)0000000000000000000000000021.8190283621276391.27489951401275950000000000000000023.093927876140398
912INDEX(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.6475062590720720000000SUM(G50:P50)10.647506259072072IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.2590025036288290-0.85180050072576574-3.5136770654937841-2.02302618922369380000002.17456133580729110.853352616690412074.31578057933333264.9667371759916756000SUM(S50:AJ50)1.6629254487506397000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-3.0279139524977032-9.2825177553250082SUM(AM50:BE50)-12.31043170782271200SUM(BH50:BI50)0Q50+AK50+BF50+BJ5001.51301063941414142.6104747739076413E-31.8931147390337289E-20000000000000019.71018349076142322.83633055363073102.54955773611735290000000000000000000000046.630624042087888
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.6475062590720720000000SUM(G51:P51)10.647506259072072SUM(S48:S50)-4.2590025036288290-0.85180050072576574-3.5136770654937841-2.023026189223693833.531381051081439000002.1745613358072911SUM(AE48:AE50)0.8533526166904120717.8304091718278639.0374131886335825SUM(AH48:AH50)18.39713863386220900SUM(S51:AJ51)71.176749738830722SUM(AM48:AM50)00000000000000000-3.0279139524977032-78.796342045405098SUM(AM51:BE51)-81.824255997902796SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ510SUM(BO48:BO50)1.51301063941414142.6104747739076413E-31.8931147390337289E-20000000000000019.71018349076142322.83633055363073102.5495577361173529000021.8190283621276391.27489951401275950000000000000000069.724551918228286
Q52+AK52+BF52+BJ5200
959INDEX(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)-6.494223023413107800-53.229160826579225-2.3679859715607945IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.762622833357385900000000SUM(S53:AJ53)-62.853992654910506IFERROR(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)62.853992654910506SUM(BH53:BI53)62.853992654910506Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)13.7429996254119921.7440897076303603E-20.24036477410889220000000IFERROR(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)0000000000000014.000805296597187
977INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0055.2559115986655270000000SUM(G54:P54)55.255911598665527-1.45127225822105270-4.4692473051785787E-20-53.759946867392692124.39544583847987815.4323959706519637.881984651251630000000000SUM(S54:AJ54)1522.4539148617177-124.39544583847987-815.4323959706519-637.881984651251630000000000000000SUM(AM54:BE54)-1577.7098264603833IFERROR(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)09.87508622360025431.9794469203680252E-22.1289913967007992E-204.25449312982792982.64031296125177750000000000000000000000000000000000000016.810976697850649
957INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)055.2559115986655270000000SUM(G55:P55)55.255911598665527SUM(S53:S54)-7.94549528163416060-4.4692473051785787E-2-53.229160826579225-56.127932838953484SUM(X53:X54)124.39544583847987SUM(Y53:Y54)815.4323959706519SUM(Z53:Z54)637.881984651251630-0.76262283335738590SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)1459.5999222068072SUM(AM53:AM54)-124.39544583847987-815.4323959706519-637.881984651251630000000000000000SUM(AM55:BE55)-1577.7098264603833SUM(BH53:BH54)0SUM(BI53:BI54)62.853992654910506SUM(BH55:BI55)62.853992654910506Q55+AK55+BF55+BJ55-9.2370555648813024E-14SUM(BO53:BO54)23.6180858490122463.7235366279983854E-20.261654688075900204.25449312982792982.64031296125177750000000000000000000000000000000000000030.811781994447838
Q56+AK56+BF56+BJ5600
1709INDEX(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)010.317757319999997000IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S57:AJ57)10.317757319999997IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00000000000-10.3177573199999970000000SUM(AM57:BE57)-10.317757319999997IFERROR(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
1710INDEX(Modules[Module], MATCH($C58, Modules[Code], 0))Offshore wind0000000000SUM(G58:P58)004.12291278000000270000000000000000SUM(S58:AJ58)4.122912780000002700000000000-4.12291278000000270000000SUM(AM58:BE58)-4.122912780000002700SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
799INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric0000000000005.329728000000001100000000000000005.3297280000000011000000000000000-5.3297280000000011000-5.32972800000000110000000000000000000000000000000000000000000000000
804INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Wave and Tidal0000000000005.0034246575342495E-300000000000000005.0034246575342495E-3000000000000-5.0034246575342495E-3000000-5.0034246575342495E-30000000000000000000000000000000000000000000000000
805INDEX(Modules[Module], MATCH($C61, Modules[Code], 0))Geothermal000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
806INDEX(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)019.7754015246575360000000000SUM(AE57:AE62)000SUM(AH57:AH62)00019.775401524657536SUM(AM57:AM62)00000000000-14.440670099999998-5.0034246575342495E-300-5.3297280000000011000-19.775401524657532SUM(BH57:BH62)0SUM(BI57:BI62)003.5527136788005009E-15SUM(BO57:BO62)000000000000000000000000000000000000000000000
0
964INDEX(Modules[Module], MATCH($C65, Modules[Code], 0))Distributed 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)02.8059966000000006E-2000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)2.8059966000000006E-2IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-2.8059966000000006E-200000000SUM(AM65:BE65)-2.8059966000000006E-2IFERROR(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
1317INDEX(Modules[Module], MATCH($C66, Modules[Code], 0))Distributed solar thermal0000000000SUM(G66:P66)0000000000000000000SUM(S66:AJ66)00000000000000000000SUM(AM66:BE66)000SUM(BH66:BI66)00000000000000000000000000000000000000000000000
1582INDEX(Modules[Module], MATCH($C67, Modules[Code], 0))Micro wind0000000000SUM(G67:P67)0000000000000000000SUM(S67:AJ67)00000000000000000000SUM(AM67:BE67)000SUM(BH67:BI67)00000000000000000000000000000000000000000000000
77INDEX(Workstreams[Workstream], MATCH($C68, Workstreams[Code], 0))Distributed renewable power generationSUM(G65:G67)0SUM(H65:H67)000000000SUM(G68:P68)0SUM(S65:S67)02.8059966000000006E-20000000000SUM(AE65:AE67)000SUM(AH65:AH67)000SUM(S68:AJ68)2.8059966000000006E-2SUM(AM65:AM67)0000000000-2.8059966000000006E-200000000SUM(AM68:BE68)-2.8059966000000006E-2SUM(BH65:BH67)0SUM(BI65:BI67)0SUM(BH68:BI68)00SUM(BO65:BO67)0SUM(BP65:BP67)00000000000000000000000000000000000000000000
00
16971328AB$40+AB$46+AB$51+AB$99+AB$55+AB$63+AB$68-8.8197200023558597SUM(BH70:BI70)000
1326INDEX(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-1.2599600003365514000IFERROR(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)008.819720002355859700000000SUM(S71:AJ71)7.5597600020193081IFERROR(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)-7.5597600020193081IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-7.5597600020193081Q71+AK71+BF71+BJ710IFERROR(SUMIFS(INDIRECT($C71&".Emissions["&this.Year&"]"), INDIRECT($C71&".Emissions[GHG]"), BO$6, INDIRECT($C71&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
1324INDEX(Workstreams[Workstream], MATCH($C72, Workstreams[Code], 0))District heatingG710H71000000000SUM(G72:P72)0S710-1.259960000336551400000008.81972000235585970AD710AE71000AH710AI7100SUM(S72:AJ72)7.5597600020193081AM710AN71000000000000000000SUM(AM72:BE72)0BH71-7.5597600020193081BI710SUM(BH72:BI72)-7.5597600020193081Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16981322S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-360.93233792616286T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$72-8.5191425414825446SUM(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)052.595999999999997000IFERROR(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)52.595999999999997IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-160.70999999999998000000000SUM(AM75:BE75)-160.70999999999998IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)102.85439999999998IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)5.2595999999999998SUM(BH75:BI75)108.113999999999990IFERROR(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)0S75052.595999999999997000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)52.595999999999997AM750AN7500000000-160.70999999999998000000000SUM(AM76:BE76)-160.70999999999998BH75102.85439999999998BI755.2595999999999998SUM(BH76:BI76)108.113999999999990BO75000000000000000000000000000000000000000000000
00
16991322S$74+S$76-360.93233792616286T$74+T$7644.07685745851745200
869INDEX(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)00000IFERROR(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)0IFERROR(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)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0SUM(BH79:BI79)00IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
17001322S78+S79-360.93233792616286T78+T7944.07685745851745200
740INDEX(Modules[Module], MATCH($C81, Modules[Code], 0))Biomass/Coal powerIFERROR(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)0316.85548046764541-436.52965676162268-8.5348581120000002-345.19223591897327IFERROR(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)-473.40127032495053IFERROR(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)462.31479553294139IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)11.086474792009135SUM(BH81:BI81)473.40127032495053Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)200.100220219670830.524940965497367681.366361251963484500000000000000000000000000000000000000000201.99152243713169
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810316.85548046764541-436.52965676162268-8.5348581120000002-345.19223591897327000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-473.40127032495053AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81462.31479553294139BI79+BI8111.086474792009135SUM(BH82:BI82)473.401270324950530BO79+BO81200.100220219670830.524940965497367681.366361251963484500000000000000000000000000000000000000000201.99152243713169
SUM(AM83:BE83)00
1794249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$460065.9034178577375940000000SUM(G84:P84)65.903417857737594S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-12.204497785262991387.99498195796639-437.4261497354002-65.277696004073007-403.34319494715044157.92682688956131815.4323959706519637.8819846512516308.057097168998474502.17456133580729110.8533526166904120717.8304091718278639.037413188633582518.39713863386220900SUM(S84:AJ84)1137.3346231133644AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-124.39544583847987-815.4323959706519-637.88198465125163000000-160.70999999999998-2.8059966000000006E-2-14.440670099999998-5.0034246575342495E-300-5.32972800000000110-3.0279139524977032-78.796342045405098SUM(AM84:BE84)-1840.0475439489437BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46557.60943553092204BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4679.200067446919633SUM(BH84:BI84)636.80950297784170BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46225.231316708097210.564786806551259121.646947087429722104.25449312982792982.64031296125177750000000000019.71018349076142322.83633055363073102.5495577361173529000021.8190283621276391.27489951401275950000000000000000DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)302.52785634980779
0
9750
0
|
772INDEX(Modules[Module], MATCH($C89, Modules[Code], 0))Electricity imports / exportsIFERROR(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
17011323S$40+$S46+S$51+S$99+S$55+S$89-360.93233792616286T$40+$S46+T$51+T$99+T$55+T$8900
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-27.062644031803529000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-27.062644031803529IFERROR(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)27.062644031803529SUM(BH91:BI91)27.0626440318035290IFERROR(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, backup0000000000SUM(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)0000000000000000000000000000000000000000000000
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-27.062644031803529000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-27.062644031803529AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9227.062644031803529SUM(BH93:BI93)27.0626440318035290BO$89+BO$91+BO$9200000000000000000000000000000000000000000000SUM(BO93:DF93)0
00
17021650(U$40+U$84+U$93)-505.46833220752944(V$40+V$84+V$93)-871.48134106524276(W$40+W$84+W$93)-999.14982950000808(AC$40+AC$84+AC$93)02.17456133580729110.8533526166904120717.8304091718278639.037413188633582518.397138633862209BE40+BE46+BE51-78.796342045405098SUM(AM95:BE95)-78.7963420454050980
951INDEX(Modules[Module], MATCH($C96, Modules[Code], 0))Biomass to fuel conversionIFERROR(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)0016.0473682546450791.069127005422725325.175198525337397000000-2.1745613358072911-0.85335261669041207-17.830409171827863-9.0374131886335825-18.39713863386220900SUM(S96:AJ96)-6.0011811614161594IFERROR(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)6.001181161416163IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)6.001181161416163Q96+AK96+BF96+BJ960IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-9.84210770244844470000000-9.8421077024484447
17031650U$95+U$96-489.42096395288434V$95+V$96-870.41221405982003W$95+W$96-973.97463097467073AC$95+AC$96000000BE42+BE49+BE53-69.513824290080095SUM(AM97:BE97)-69.513824290080095SUM(BO97:DF97)0
1674INDEX(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)004.089432558139535-0.3678325581395348600000000000000SUM(S98:AJ98)3.7216IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-3.7216000000000000000SUM(AM98:BE98)-3.7216IFERROR(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-1.16758708837209290000000SUM(BO98:DF98)-1.1675870883720929
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S980020.1368008127846140.7012944472831904625.175198525337397000000AD$96+AD98-2.1745613358072911AE$96+AE98-0.85335261669041207-17.830409171827863-9.0374131886335825AH$96+AH98-18.39713863386220900SUM(S99:AJ99)-2.2795811614161643AM$96+AM98000-3.7216000000000000000SUM(AM99:BE99)-3.7216BH$96+BH986.001181161416163BI$96+BI980SUM(BH99:BI99)6.001181161416163Q99+AK99+BF99+BJ990BO$96+BO98000000000000000000000000000000000000-11.0096947908205380000000-11.009694790820538
0
17041212(S$40+S$84+S$93+S$99)-360.93233792616286(T$40+T$84+T$93+T$99)360.93233792616286(U$40+U$84+U$93+U$99)-485.33153139474484(V$40+V$84+V$93+V$99)-870.78004661795956(W$40+W$84+W$93+W$99)-973.974630974670730
1001INDEX(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)00485.33153139474484870.78004661795956973.97463097467073-485.33153139474484-870.78004661795956-985.200039508801640000000000SUM(S102:AJ102)-11.225408534131134IFERROR(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)11.225408534130912SUM(BH102:BI102)11.225408534130912Q102+AK102+BF102+BJ102-2.2204460492503131E-13IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000004.42818288727513030000IFERROR(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)000000000000004.4281828872751303
7941002INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)0-(X$40+X$84+X$93+X$99+X$102)327.40470450518353-(Y$40+Y$84+Y$93+Y$99+Y$102)55.34765064730766-(Z$40+Z$84+Z$93+Z$99+Z$102)347.31805485755001SUM(S103:AJ103)730.0704100100412-T1030-V1030-X103-327.40470450518353-Y103-55.34765064730766-Z103-347.31805485755001SUM(AM103:BE103)-730.0704100100412SUM(BH103:BI103)00000000000000000000000000000000000000000000000
7941000INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)00485.33153139474484870.78004661795956973.97463097467073-157.92682688956131-815.4323959706519-637.88198465125163000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)718.84500147591018SUM(AM102:AM103)000000-327.40470450518353-55.34765064730766-347.318054857550010000000000SUM(AM104:BE104)-730.0704100100412SUM(BH102:BH103)0SUM(BI102:BI103)11.225408534130912SUM(BH104:BI104)11.225408534130912-1.0835776720341528E-13SUM(BO102:BO103)000004.4281828872751303000000000000000000000000000000000000004.4281828872751303
0
17951004G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-27.062644031803529505.46833220752944871.48134106524276999.14982950000808-157.92682688956131-815.4323959706519-637.88198465125163000-2.1745613358072911-0.85335261669041207-17.830409171827863-9.0374131886335825-18.39713863386220900SUM(S106:AJ106)689.50277628269055AM$93+AM$99+AM$104000-3.721600-327.40470450518353-55.34765064730766-347.318054857550010000000000SUM(AM106:BE106)-733.79201001004117BH$93+BH$99+BH$1046.001181161416163BI$93+BI$99+BI$10438.288052565934443SUM(BH106:BI106)44.2892337273506060BO$93+BO$99+BO$104000004.4281828872751303000000000000000000000000000000-11.009694790820538000000DF$93+DF$1040SUM(BO106:DF106)-6.5815119035454073
0
0
593G$40+G$84+G$106527.14266867050026177.42796936210306477.06598353088668470.2870297257891317.7244874033332399.551097329516901326.572895707388618153.6308279436282533.3378575806463930SUM(G109:P109)1892.7408172537926S$40+S$84+S$106-360.93233792616286360.932337926162860000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-124.39544583847987-815.4323959706519-637.88198465125163-3.721600-327.40470450518353-55.34765064730766-347.31805485755001-160.70999999999998-2.8059966000000006E-2-14.440670099999998-5.0034246575342495E-300-5.32972800000000110-3.0279139524977032-78.796342045405098SUM(AM109:BE109)-2573.8395539589851BH$40+BH$84+BH$106563.61061669233823BI$40+BI$84+BI$106117.48812001285407SUM(BH109:BI109)681.098736705192320BO$40+BO$84+BO$106510.625469551462571.03883574892577114.854271637646569104.25449312982792987.06849584852690780014.3970008912050740.112590959012936612.76224515695433810.0939752854540390000019.71018349076142322.83633055363073102.5495577361173529000021.8190283621276391.27489951401275950000046.7421713810686585.8193818842968863E-20.840987442090924130-11.0096947908205380000000SUM(BO109:DF109)660.02903571684794
|
|
2352SUM(DH63,DH68,DH76,DH82)201.99152243713169
79410052353T109-MIN(T103,0)-T72362.19229792649941
2354DH112/DH1130.55769137994790363
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D