|
2040
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)367.81681388141629IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)367.81681388141629IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-83.116366770640170-2.8095501635607762-2.5199058168019333-100.34600394470483IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000-31.376079438041629000000-13.3833772531629760SUM(S9:AJ9)-233.5512833869123IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000-134.2655304945040500SUM(AM9:BE9)-134.26553049450405IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ9-5.6843418860808015E-14IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)19.958982630402894.0336530732123836E-25.8806424007998584E-20000000IFERROR(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]IFERROR(INDEX(INDIRECT($C10&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C10&".Outputs[Vector]"), 0)), 0)00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
934SUM(G9:G10)367.81681388141629SUM(H9:H10)000000000367.81681388141629SUM(S9:S10)-83.11636677064017SUM(T9:T10)0-2.8095501635607762-2.5199058168019333-100.34600394470483SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)00-31.3760794380416290SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)-13.3833772531629760-233.5512833869123SUM(AM9:AM10)0000000000000000-134.2655304945040500-134.26553049450405SUM(BH9:BH10)0SUM(BI9:BI10)00-5.6843418860808015E-14SUM(BO9:BO10)19.958982630402894.0336530732123836E-25.8806424007998584E-200000000000000000000000000000000000000000
932INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling125.2898350864366000000000125.2898350864366-36.36615437439527900-2.9244114182636416-26.76305808132614IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000-14.22441640853363500000000-80.278040282518702IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000000-45.01179480391790100-45.011794803917901000-7.1054273576010019E-15IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)5.65550554152991941.0781114975777223E-22.377066570438955E-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)125.2898350864366SUM(H12:H13)000000000125.2898350864366SUM(S12:S13)-36.36615437439527900-2.9244114182636416-26.76305808132614SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)00-14.2244164085336350SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-80.278040282518702SUM(AM12:AM13)0000000SUM(AT12:AT13)000000000-45.01179480391790100-45.011794803917901SUM(BH12:BH13)0SUM(BI12:BI13)00-7.1054273576010019E-15SUM(BO12:BO13)5.65550554152991941.0781114975777223E-22.377066570438955E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11493.10664896785289000000000493.10664896785289S14+S11-119.482521145035450-2.8095501635607762-5.4443172350655749-127.10906202603097000AA14+AA110-45.6004958465752640AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI11-13.3833772531629760-313.82932366943101AM14+AM110000000AT14+AT11000000000-179.2773252984219400-179.27732529842194BH14+BH110BI14+BI1100-5.6843418860808015E-14BO14+BO1125.6144881719328095.111764570790106E-28.2577089712388141E-200000000000000000000000000000000000000000SUM(BO15:DF15)25.748182907353097
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)089.60203941438038600000000SUM(G17:P17)89.602039414380386IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-87.879112212813737000-1.7229272015666452IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-89.602039414380386IFERROR(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.317018605088262686.3545926317243556E-46.8346733136769901E-40000000IFERROR(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)000000000000000.31833753168280282
938INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering087.23327673937910700000000SUM(G18:P18)87.233276739379107-85.255529016250506000-1.97774772312860090000000000000SUM(S18:AJ18)-87.2332767393791070000000000000000000SUM(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)000.363905581055662517.2944353640564947E-47.8455198641946865E-4000000000000000000000000000000000000000000.36541957657848761
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18176.8353161537594900000000SUM(G19:P19)176.83531615375949S17+S18-173.13464122906424T17+T18000-3.7006749246952459X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-176.83531615375949AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)00BO17+BO180.680924186143925251.364902799578085E-31.4680193177871678E-3000000000000000000000000000000000000000000.68375710826129055
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)00476.511779641246220000000SUM(G21:P21)476.51177964124622IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-255.365893325325770-47.894113029829164-79.462367401069798-84.45173258673303IFERROR(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-9.337673298288391900000000SUM(S21:AJ21)-476.51177964124616IFERROR(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)05.6843418860808015E-14IFERROR(SUMIFS(INDIRECT($C21&".Emissions["&this.Year&"]"), INDIRECT($C21&".Emissions[GHG]"), BO$6, INDIRECT($C21&".Emissions[IPCC Sector]"), BO$5),0)50.1560974594137019.9214768632957473E-20.521599187519223630000016.3404950290589210.123565088183947083.06547145270088044.7841792123037230000000000000000000000000000-4.38546593580120800070.705156262012153
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210476.511779641246220000000SUM(G22:P22)476.51177964124622S21-255.365893325325770-47.894113029829164-79.462367401069798-84.45173258673303000AA210-9.33767329828839190AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-476.51177964124616AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)05.6843418860808015E-14BO2150.1560974594137019.9214768632957473E-20.521599187519223630000016.3404950290589210.123565088183947083.06547145270088044.7841792123037230000000000000000000000000000-4.38546593580120800070.705156262012153
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)000149.3045999026113310.58760723848745813.6809608059864140000SUM(G24:P24)173.57316794708521IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-40.1323131634150200-123.059498141711030IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000000000000-10.381356641959174SUM(S24:AJ24)-173.57316794708524IFERROR(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)0-2.8421709430404007E-14IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), BO$6, INDIRECT($C24&".Emissions[IPCC Sector]"), BO$5),0)30.7648745354277583.8302147344538212E-20.553523132908552370000000IFERROR(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)0000000000000031.356699815680848
903INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00071.8654840669621542.7722589884484807031.207737454577007000SUM(G25:P25)105.84548050998765-0.1164043178683010100-105.7290761921193500000000000000-105.8454805099876500000000000000000000000026.4322690480298383.2908070616776169E-20.475570682288947110000000000000000000000000000000000000000026.940747800935561
906INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000212.0920501260326900SUM(G26:P26)212.09205012603269000-212.0920501260326900000000000000-212.092050126032690000000000000000000000000000000000000000000000000000000053.0230125315081726.6013441280068072E-20.9539926444000937900000000054.043018617188338
941INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
947SUM(G26:G27)0SUM(H26:H27)000000212.0920501260326900212.09205012603269SUM(S26:S27)000-212.092050126032690000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-212.09205012603269SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000053.0230125315081726.6013441280068072E-20.9539926444000937900000000054.043018617188338
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)0000000094.362066333662398094.362066333662398000-94.3620663336623980IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-94.362066333662398IFERROR(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)0023.5905165834155992.9370100016863049E-20.4244417324421830800000000024.044328415874645
946INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G29:G30)0SUM(H29:H30)000000094.362066333662398094.362066333662398SUM(S29:S30)000-94.3620663336623980000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-94.362066333662398SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)0000000000000000000000000000000023.5905165834155992.9370100016863049E-20.4244417324421830800000000024.044328415874645
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000221.1700839695734813.35986622693593913.68096080598641431.207737454577007212.0920501260326994.3620663336623980585.87276491676789S24+S25+S28+S31-40.24871748128332200-535.242690793525410000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI310-10.381356641959174-585.87276491676789AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI31000BO24+BO25+BO28+BO3157.1971435834575967.1210217961314382E-21.02909381519749950000000000000000000000000000076.6135291149237799.5383541296931121E-21.3784343768422769000000000136.38479464967941
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$38493.10664896785289176.83531615375949476.51177964124622221.1700839695734813.35986622693593913.68096080598641431.207737454577007212.0920501260326994.36206633366239801732.3265096796265S$15+S$19+S$22+S$32+S$35+S$38-588.231773180708730-50.703663193389943-620.14937542966072-215.26146953745922X$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-54.938169144863657000000-13.383377253162976-10.381356641959174SUM(S40:AJ40)-1553.0491843812042AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000-179.2773252984219400SUM(AM40:BE40)-179.27732529842194BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)03.4106051316484809E-13BO$15+BO$19+BO$22+BO$32+BO$35+BO$38133.648653400948040.222907535101750991.63473811174689840000016.3404950290589210.123565088183947083.06547145270088044.7841792123037230000000000000000000076.6135291149237799.5383541296931121E-21.378434376842276900000-4.385465935801208000SUM(BO40:DF40)233.52189092730592
0
720
0
18931894AJ$40-10.3813566419591740SUM(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)-9.5332298807391123000-4.7754240553012206IFERROR(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)000000000010.381356641959174SUM(S45:AJ45)-3.9272972940811588IFERROR(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)3.9272972940811597IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)3.9272972940811597IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)0.878678026175424451.7612975456875425E-31.8943611385658365E-300000000000000000000000000000000000000000SUM(BO45:DF45)0.88233368485967789
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45-9.5332298807391123000-4.7754240553012206000000AD450AE4500AG450AH450AI45010.381356641959174SUM(S46:AJ46)-3.9272972940811588AM450AN45000000000000000000SUM(AM46:BE46)0BH453.9272972940811597BI450SUM(BH46:BI46)3.9272972940811597Q46+AK46+BF46+BJ460BO450.878678026175424451.7612975456875425E-31.8943611385658365E-300000000000000000000000000000000000000000SUM(BO46:DF46)0.88233368485967789
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)0000000000.7777777777777779000SUM(S48:AJ48)0.7777777777777779IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000000000000000-0.77777777777777790SUM(AM48:BE48)-0.7777777777777779IFERROR(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)00000056.587104808568142000000033.12665984533533222.51431909512998421.22218770549953600SUM(S49:AJ49)133.45027145453298000000000000000000-133.45027145453298SUM(AM49:BE49)-133.4502714545329800SUM(BH49:BI49)000000000000000000000000009.95008754335852791.51320861648434550000000000000000011.463296159842873
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.8553149533058960000000SUM(G50:P50)10.855314953305896IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.34212598132235870-0.86842519626447168-3.5822539345909461-2.0625098411281204000000121.407832402076861.6878225152696378.040913494473643.096920471427154000SUM(S50:AJ50)233.37817392994134000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-123.09565491734649-121.13783396590075SUM(AM50:BE50)-244.2334888832472500SUM(BH50:BI50)0Q50+AK50+BF50+BJ5001.54254025486476782.661423732367644E-31.9300628931255111E-20000000000000013.06564724395723220.40607298792734905.04061553555376650000000000000000000000040.076838074966744
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.8553149533058960000000SUM(G51:P51)10.855314953305896SUM(S48:S50)-4.34212598132235870-0.86842519626447168-3.5822539345909461-2.062509841128120456.58710480856814200000121.40783240207686SUM(AE48:AE50)1.68782251526963111.1675733398089466.389017344334917SUM(AH48:AH50)21.22218770549953600SUM(S51:AJ51)367.60622316225215SUM(AM48:AM50)00000000000000000-123.87343269512427-254.58810542043375SUM(AM51:BE51)-378.46153811555803SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ510SUM(BO48:BO50)1.54254025486476782.661423732367644E-31.9300628931255111E-20000000000000013.06564724395723220.40607298792734905.040615535553766500009.95008754335852791.51320861648434550000000000000000051.540134234809621
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.111698964908840500-41.897459529683765-1.8638767711097728IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.6002717082296944500000000SUM(S53:AJ53)-49.473306973932068IFERROR(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)49.473306973932068SUM(BH53:BI53)49.473306973932068Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)10.8173182083051391.3727987968785162E-20.189194667719808250000000IFERROR(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)0000000000000011.020240863993733
975INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0012.5179095826129050000000SUM(G54:P54)12.517909582612905-0.608773404193645230-2.2981132038460916E-20-11.88615504638079863.965000000000003179.88427462124332137.343358153041010000000000SUM(S54:AJ54)368.67472319167143-63.965000000000003-179.88427462124332-137.343358153041010000000000000000SUM(AM54:BE54)-381.19263277428433IFERROR(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)02.17844266542789814.3666571892548578E-34.6965520987735489E-300.938540600449365381.3576644262911814000000000000000000000000000000000000004.4837109014564733
956INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)012.5179095826129050000000SUM(G55:P55)12.517909582612905SUM(S53:S54)-5.72047236910248550-2.2981132038460916E-2-41.897459529683765-13.750031817490571SUM(X53:X54)63.965000000000003SUM(Y53:Y54)179.88427462124332SUM(Z53:Z54)137.343358153041010-0.600271708229694450SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)319.20141621773939SUM(AM53:AM54)-63.965000000000003-179.88427462124332-137.343358153041010000000000000000SUM(AM55:BE55)-381.19263277428433SUM(BH53:BH54)0SUM(BI53:BI54)49.473306973932068SUM(BH55:BI55)49.473306973932068Q55+AK55+BF55+BJ550SUM(BO53:BO54)12.9957608737330371.8094645158040018E-20.1938912198185817900.938540600449365381.35766442629118140000000000000000000000000000000000000015.503951765450205
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)052.68383532000IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S57:AJ57)52.68383532IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00000000000-52.683835320000000SUM(AM57:BE57)-52.68383532IFERROR(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)00236.681999999999990000000000000000SUM(S58:AJ58)236.6819999999999900000000000-236.681999999999990000000SUM(AM58:BE58)-236.6819999999999900SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
798INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric power stations0000000000006.662160000000000100000000000000006.6621600000000001000000000000000-6.6621600000000001000-6.66216000000000010000000000000000000000000000000000000000000000000
803INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Tidal and Wave00000000000012.829089032876706000000000000000012.829089032876706000000000000-5.6992088958904104-7.129880136986295200000-12.8290890328767060000000000000000000000000000000000000000000000000
804INDEX(Modules[Module], MATCH($C61, Modules[Code], 0))Geothermal electricity0000000000007.012800000000001300000000000000007.012800000000001300000000000000-7.01280000000000130000-7.01280000000000130000000000000000000000000000000000000000000000000
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)0315.869884352876680000000000SUM(AE57:AE62)000SUM(AH57:AH62)000315.86988435287668SUM(AM57:AM62)00000000000-289.36583531999997-5.6992088958904104-7.1298801369862952-7.0128000000000013-6.6621600000000001000-315.86988435287674SUM(BH57:BH62)0SUM(BI57:BI62)00-5.6843418860808015E-14SUM(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)017.184430450239162000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)17.184430450239162IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-17.18443045023916200000000SUM(AM65:BE65)-17.184430450239162IFERROR(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.9559555180830696700000000SUM(G66:P66)0.95595551808306967-0.9559555180830696700000000000000013.3833772531629760SUM(S66:AJ66)12.4274217350799070000000000-13.38337725316297600000000SUM(AM66:BE66)-13.38337725316297600SUM(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.9559555180830696700000000SUM(G68:P68)0.95595551808306967SUM(S65:S67)-0.9559555180830696717.3180242902391620000000000SUM(AE65:AE67)000SUM(AH65:AH67)013.3833772531629760SUM(S68:AJ68)29.745446025319069SUM(AM65:AM67)0000000000-30.567807703402138-0.133593840000000130000000SUM(AM68:BE68)-30.701401543402138SUM(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-55.538440853093348SUM(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-7.9340629790133352000IFERROR(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)0055.53844085309334800000000SUM(S71:AJ71)47.604377874080015IFERROR(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)-47.604377874080015IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-47.604377874080015Q71+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-7.9340629790133352000000055.5384408530933480AD710AE71000AH710AI7100SUM(S72:AJ72)47.604377874080015AM710AN71000000000000000000SUM(AM72:BE72)0BH71-47.604377874080015BI710SUM(BH72:BI72)-47.604377874080015Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16901318S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-608.78355692995581T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$72279.67903764266225SUM(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)0190.74816000000001000IFERROR(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)190.74816000000001IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-582.84160000000008000000000SUM(AM75:BE75)-582.84160000000008IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)373.01862400000005IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)19.074816000000002SUM(BH75:BI75)392.093440000000040IFERROR(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)0S750190.74816000000001000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)190.74816000000001AM750AN7500000000-582.84160000000008000000000SUM(AM76:BE76)-582.84160000000008BH75373.01862400000005BI7519.074816000000002SUM(BH76:BI76)392.093440000000040BO75000000000000000000000000000000000000000000000
00
16911318S$74+S$76-608.78355692995581T$74+T$76470.4271976426622400
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)0162.7600064868324-261.562234642500020-97.575773605714303IFERROR(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)-196.37800176138194IFERROR(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)172.11539824821429IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)24.262603513167601SUM(BH79:BI79)196.378001761381880IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)98.515110613341420.2726480203252310.752359487847114590000000000000000000000000000000000000-88.66359955200728400010.876518569506487
16921318S78+S79-608.78355692995581T78+T79633.187204129494600
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)00000IFERROR(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)0IFERROR(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)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0SUM(BH81:BI81)0Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810162.7600064868324-261.562234642500020-97.575773605714303000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-196.37800176138194AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81172.11539824821429BI79+BI8124.262603513167601SUM(BH82:BI82)196.378001761381880BO79+BO8198.515110613341420.2726480203252310.752359487847114590000000000000000000000000000000000000-88.66359955200728400010.876518569506487
SUM(AM83:BE83)00
1786249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$4600.9559555180830696723.3732245359188010000000SUM(G84:P84)24.329180054001871S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-20.551783749247026678.76201215093488-262.45364097080295-45.47971346427471-118.1637393196342120.55210480856815179.88427462124332137.34335815304101054.9381691448636570121.407832402076861.68782251526963111.1675733398089466.38901734433491721.22218770549953613.38337725316297610.381356641959174SUM(S84:AJ84)1070.470208576804AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-63.965000000000003-179.88427462124332-137.34335815304101000000-582.84160000000008-30.567807703402138-289.49942915999998-5.6992088958904104-7.1298801369862952-7.0128000000000013-6.66216000000000010-123.87343269512427-254.58810542043375SUM(AM84:BE84)-1689.0670567861212BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46501.45694166821551BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4692.810726487099672SUM(BH84:BI84)594.267668155315160BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46113.932089768114650.29516538676132620.9674456977355172500.938540600449365381.35766442629118140000000000013.06564724395723220.40607298792734905.040615535553766500009.95008754335852791.51320861648434550000000000000-88.66359955200728400DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)78.802938254626
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-607.82760141187271T$40+$S46+T$51+T$99+T$55+T$89-9.53322988073911230
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-45.574808021440276000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-45.574808021440276IFERROR(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)45.574808021440255SUM(BH91:BI91)45.5748080214402550IFERROR(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.9122187189678273.8330150933618612E-34.1225940808124802E-300000000000000000000000000000000000000000
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-45.574808021440276000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-45.574808021440276AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9245.574808021440255SUM(BH93:BI93)45.5748080214402550BO$89+BO$91+BO$921.9122187189678273.8330150933618612E-34.1225940808124802E-300000000000000000000000000000000000000000SUM(BO93:DF93)1.9201743281420014
00
16941642(U$40+U$84+U$93)-313.15730416419291(V$40+V$84+V$93)-665.62908889393543(W$40+W$84+W$93)-333.42520885709342(AC$40+AC$84+AC$93)0121.407832402076861.68782251526963111.1675733398089466.38901734433491721.222187705499536BE40+BE46+BE51-254.58810542043375SUM(AM95:BE95)-254.588105420433750
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)00220.94663545479150.5333519148252030677.652852448184206000000-121.40783240207686-1.68782251526963-111.16757333980894-66.389017344334917-21.22218770549953600SUM(S96:AJ96)-22.741593489188958IFERROR(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)22.741593489188915IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)22.741593489188915Q96+AK96+BF96+BJ96-4.2632564145606011E-14IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-82.4730265492479620000000-82.473026549247962
16951642U$95+U$96-92.210668709401403V$95+V$96-665.09573697911026W$95+W$96-255.77235640890922AC$95+AC$96000000BE42+BE49+BE53-133.45027145453298SUM(AM97:BE97)-133.45027145453298SUM(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)0027.88282325581395326.76850697674418800000000000000SUM(S98:AJ98)54.651330232558138IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-54.651330232558138000000000000000SUM(AM98:BE98)-54.651330232558138IFERROR(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-15.2800363069767440000000SUM(BO98:DF98)-15.280036306976744
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S9800248.8294587106054527.30185889156939277.652852448184206000000AD$96+AD98-121.40783240207686AE$96+AE98-1.68782251526963-111.16757333980894-66.389017344334917AH$96+AH98-21.22218770549953600SUM(S99:AJ99)31.909736743369152AM$96+AM98000-54.651330232558138000000000000000SUM(AM99:BE99)-54.651330232558138BH$96+BH9822.741593489188915BI$96+BI980SUM(BH99:BI99)22.741593489188915Q99+AK99+BF99+BJ99-7.1054273576010019E-14BO$96+BO98000000000000000000000000000000000000-97.7530628562247020000000-97.753062856224702
0
16961209(S$40+S$84+S$93+S$99)-608.78355692995581(T$40+T$84+T$93+T$99)633.1872041294946(U$40+U$84+U$93+U$99)-64.327845453587457(V$40+V$84+V$93+V$99)-638.32723000236604(W$40+W$84+W$93+W$99)-255.772356408909220
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)0064.327845453587457638.32723000236604255.77235640890922-64.327845453587457-638.32723000236604-258.720224968436410000000000SUM(S102:AJ102)-2.9478685595271941IFERROR(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)2.9478685595272043SUM(BH102:BI102)2.9478685595272043Q102+AK102+BF102+BJ1021.021405182655144E-14IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000001.15584119210333870000IFERROR(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)000000000000001.1558411921033387
7931000INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)-24.403647199538796-(X$40+X$84+X$93+X$99+X$102)-56.224259354980688-(Y$40+Y$84+Y$93+Y$99+Y$102)458.44295538112272-(Z$40+Z$84+Z$93+Z$99+Z$102)121.3768668153954SUM(S103:AJ103)499.19191564199866-T10324.403647199538796-V1030-X10356.224259354980688-Y103-458.44295538112272-Z103-121.3768668153954SUM(AM103:BE103)-499.19191564199866SUM(BH103:BI103)00000000000000000000000000000000000000000000000
793998INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)0-24.40364719953879664.327845453587457638.32723000236604255.77235640890922-120.55210480856815-179.88427462124332-137.34335815304101000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)496.24404708247141SUM(AM102:AM103)000024.403647199538796056.224259354980688-458.44295538112272-121.37686681539540000000000SUM(AM104:BE104)-499.19191564199866SUM(BH102:BH103)0SUM(BI102:BI103)2.9478685595272043SUM(BH104:BI104)2.9478685595272043-4.6629367034256575E-14SUM(BO102:BO103)000001.1558411921033387000000000000000000000000000000000000001.1558411921033387
0
17871002G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-69.978455220979072313.15730416419291665.62908889393543333.42520885709342-120.55210480856815-179.88427462124332-137.34335815304101000-121.40783240207686-1.68782251526963-111.16757333980894-66.389017344334917-21.22218770549953600SUM(S106:AJ106)482.5789758044001AM$93+AM$99+AM$104000-54.65133023255813824.403647199538796056.224259354980688-458.44295538112272-121.37686681539540000000000SUM(AM106:BE106)-553.84324587455671BH$93+BH$99+BH$10422.741593489188915BI$93+BI$99+BI$10448.522676580967456SUM(BH106:BI106)71.264270070156371-2.4158453015843406E-13BO$93+BO$99+BO$1041.9122187189678273.8330150933618612E-34.1225940808124802E-3001.1558411921033387000000000000000000000000000000-97.753062856224702000000DF$93+DF$1040SUM(BO106:DF106)-94.677047335979367
0
0
593G$40+G$84+G$106493.10664896785289177.79127167184257499.885004177165221.1700839695734813.35986622693593913.68096080598641431.207737454577007212.0920501260326994.3620663336623980SUM(G109:P109)1756.6556897336284S$40+S$84+S$106-608.78355692995581608.783556929955810000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-63.965000000000003-179.88427462124332-137.34335815304101-54.65133023255813824.403647199538796056.224259354980688-458.44295538112272-121.3768668153954-582.84160000000008-30.567807703402138-289.49942915999998-5.6992088958904104-7.1298801369862952-7.0128000000000013-6.6621600000000001-179.27732529842194-123.87343269512427-254.58810542043375SUM(AM109:BE109)-2422.1876279591002BH$40+BH$84+BH$106524.19853515740442BI$40+BI$84+BI$106141.33340306806713SUM(BH109:BI109)665.531938225471550BO$40+BO$84+BO$106249.492961888030520.521905936956439052.606306403563227700.938540600449365382.51350561839451990016.3404950290589210.123565088183947083.06547145270088044.7841792123037230000013.06564724395723220.40607298792734905.040615535553766500009.95008754335852791.51320861648434550000076.6135291149237799.5383541296931121E-21.37843437684227690-97.753062856224702000-93.049065487808491000SUM(BO109:DF109)217.64778184595258
|
|
2329SUM(DH63,DH68,DH76,DH82)10.876518569506487
79310032330T109-MIN(T103,0)-T72641.12126710850794
2331DH112/DH1131.6964838210031905E-2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D