|
2035
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)366.87309372260648IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)366.87309372260648IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-69.4610671406726250-4.1535061076808493-3.7253096017343701-148.16948357078957IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000-24.516373145225444000000-10.8044569314871040SUM(S9:AJ9)-260.83019649758995IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000-106.0428972250165500SUM(AM9:BE9)-106.04289722501655IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ9-1.4210854715202004E-14IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)29.473792258624575.9566225576337527E-28.6866301984324656E-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]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
934SUM(G9:G10)366.87309372260648SUM(H9:H10)000000000366.87309372260648SUM(S9:S10)-69.461067140672625SUM(T9:T10)0-4.1535061076808493-3.7253096017343701-148.16948357078957SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)00-24.5163731452254440SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)-10.8044569314871040-260.83019649758995SUM(AM9:AM10)0000000000000000-106.0428972250165500-106.04289722501655SUM(BH9:BH10)0SUM(BI9:BI10)00-1.4210854715202004E-14SUM(BO9:BO10)29.473792258624575.9566225576337527E-28.6866301984324656E-200000000000000000000000000000000000000000
932INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling121.48770480060621000000000121.48770480060621-34.37476581563359400-4.1627446020676384-38.041302137322944IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000-10.73325626164073100000000-87.312068816664905IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000000-34.17563598394129100-34.1756359839412910001.4210854715202004E-14IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)8.04028574378433091.5326247497723097E-23.381466587555558E-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)121.48770480060621SUM(H12:H13)000000000121.48770480060621SUM(S12:S13)-34.37476581563359400-4.1627446020676384-38.041302137322944SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)00-10.7332562616407310SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-87.312068816664905SUM(AM12:AM13)0000000SUM(AT12:AT13)000000000-34.17563598394129100-34.175635983941291SUM(BH12:BH13)0SUM(BI12:BI13)001.4210854715202004E-14SUM(BO12:BO13)8.04028574378433091.5326247497723097E-23.381466587555558E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11488.36079852321268000000000488.36079852321268S14+S11-103.835832956306220-4.1535061076808493-7.8880542038020085-186.2107857081125000AA14+AA110-35.2496294068661770AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI11-10.8044569314871040-348.14226531425487AM14+AM110000000AT14+AT11000000000-140.2185332089578400-140.21853320895784BH14+BH110BI14+BI1100-2.8421709430404007E-14BO14+BO1137.5140780024089017.489247307406062E-20.1206809678598802400000000000000000000000000000000000000000SUM(BO15:DF15)37.709651443342842
00
937INDEX(Modules[Module], MATCH($C17, Modules[Code], 0))Domestic lighting, appliances, and cookingIFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)087.8689722332952100000000SUM(G17:P17)87.86897223329521IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-85.253071928329589000-2.6159003049656158IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-87.86897223329521IFERROR(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.481325656113673239.6481039872983851E-41.0377004895697805E-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)000000000000000.4833281670019729
938INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering085.94595842039377900000000SUM(G18:P18)85.945958420393779-82.952888860466231000-2.99306955992754320000000000000SUM(S18:AJ18)-85.9459584203937790000000000000000000SUM(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.550724799026667821.1039199888689154E-31.1873196167902292E-3000000000000000000000000000000000000000000.55301603863232696
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18173.8149306536889800000000SUM(G19:P19)173.81493065368898S17+S18-168.20596078879584T17+T18000-5.608969864893159X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-173.814930653689AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)0-2.8421709430404007E-14BO17+BO181.03205045514034112.0687303875987538E-32.2250201063600096E-3000000000000000000000000000000000000000001.0363442056343
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)00459.895642216531540000000SUM(G21:P21)459.89564221653154IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-218.867454093700080-48.523506265179201-78.99096423368286-104.50165235759209IFERROR(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.012065266377279100000000SUM(S21:AJ21)-459.89564221653154IFERROR(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)53.9212850218928420.107032434349305010.529149655714946320000016.018400655405010.121829169570129493.01748700478854385.31592509311724730000000000000000000000000000-2.418456591017167100076.612652443820863
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210459.895642216531540000000SUM(G22:P22)459.89564221653154S21-218.867454093700080-48.523506265179201-78.99096423368286-104.50165235759209000AA210-9.01206526637727910AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-459.89564221653154AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)00BO2153.9212850218928420.107032434349305010.529149655714946320000016.018400655405010.121829169570129493.01748700478854385.31592509311724730000000000000000000000000000-2.418456591017167100076.612652443820863
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)000160.4487638893164111.33328293589233813.2230543078523690000SUM(G24:P24)185.00510113306112IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-40.2418249896797700-137.76930592830010IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000000000000-6.9939702150812497SUM(S24:AJ24)-185.00510113306112IFERROR(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)34.4423264820750254.288056050044884E-20.619688028861070330000000IFERROR(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)0000000000000035.104895071436545
903INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00070.5656516265782162.6587354075717369030.221771808142936000SUM(G25:P25)103.44615884229289-0.1116375788843220100-103.3345212634085600000000000000-103.4461588422928900000000000000000000000025.833630315852143.2162767758491688E-20.464799944832052230000000000000000000000000000000000000000026.330593028442685
906INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000212.0565390643582500SUM(G26:P26)212.05653906435825000-212.0565390643582500000000000000-212.056539064358250000000000000000000000000000000000000000000000000000000053.0141347660895626.600238849716912E-20.9538329152088670400000000054.033970069795593
941INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
947SUM(G26:G27)0SUM(H26:H27)000000212.0565390643582500212.05653906435825SUM(S26:S27)000-212.056539064358250000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-212.05653906435825SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000053.0141347660895626.600238849716912E-20.9538329152088670400000000054.033970069795593
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)0000000080.802935392224498080.802935392224498000-80.8029353922244980IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-80.802935392224498IFERROR(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)0020.2007338480561242.5149833893359251E-20.363452595061018400000000020.589336277010503
946INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G29:G30)0SUM(H29:H30)000000080.802935392224498080.802935392224498SUM(S29:S30)000-80.8029353922244980000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-80.802935392224498SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)0000000000000000000000000000000020.2007338480561242.5149833893359251E-20.363452595061018400000000020.589336277010503
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000231.0144155158946313.99201834346407513.22305430785236930.221771808142936212.0565390643582580.8029353922244980581.31073443193679S24+S25+S28+S31-40.3534625685640900-533.963301648291460000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI310-6.9939702150812497-581.31073443193679AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI31000BO24+BO25+BO28+BO3160.2759567979271657.5043328258940528E-21.08448797369312260000000000000000000000000000073.2148686141456869.1152222390528365E-21.3172855102698855000000000136.05879444668534
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$38488.36079852321268173.81493065368898459.89564221653154231.0144155158946313.99201834346407513.22305430785236930.221771808142936212.0565390643582580.80293539222449801703.3821058253702S$15+S$19+S$22+S$32+S$35+S$38-531.262710407366170-52.677012372860048-620.84232008577635-296.32140793059773X$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-44.261694673243454000000-10.804456931487104-6.9939702150812497SUM(S40:AJ40)-1563.1635726164118AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000-140.2185332089578400SUM(AM40:BE40)-140.21853320895784BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)05.9685589803848416E-13BO$15+BO$19+BO$22+BO$32+BO$35+BO$38152.743370277369250.259036966069904891.73654361737430920000016.018400655405010.121829169570129493.01748700478854385.31592509311724730000000000000000000073.2148686141456869.1152222390528365E-21.317285510269885500000-2.4184565910171671000SUM(BO40:DF40)251.41744253948335
0
720
0
18931894AJ$40-6.99397021508124970SUM(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)-5.4080247226815032000-4.3964873879802413IFERROR(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)00000000006.9939702150812497SUM(S45:AJ45)-2.8105418955804939IFERROR(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)2.811241292602003IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)2.811241292602003IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)0.808953679388364271.6215360890306093E-31.7440408972139436E-300000000000000000000000000000000000000000SUM(BO45:DF45)0.81231925637460878
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45-5.4080247226815032000-4.3964873879802413000000AD450AE4500AG450AH450AI4506.9939702150812497SUM(S46:AJ46)-2.8105418955804939AM450AN45000000000000000000SUM(AM46:BE46)0BH452.811241292602003BI450SUM(BH46:BI46)2.811241292602003Q46+AK46+BF46+BJ466.9939702150900729E-4BO450.808953679388364271.6215360890306093E-31.7440408972139436E-300000000000000000000000000000000000000000SUM(BO46:DF46)0.81231925637460878
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.19444444444444448000SUM(S48:AJ48)0.19444444444444448IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000000000000000-0.194444444444444480SUM(AM48:BE48)-0.19444444444444448IFERROR(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)00000055.430694043811066000000030.59666408467620321.13519656503585521.22522160920756200SUM(S49:AJ49)128.38777630273069000000000000000000-128.38777630273069SUM(AM49:BE49)-128.3877763027306900SUM(BH49:BI49)0000000000000000000000000011.7852350204162391.48093734503796770000000000000000013.266172365454207
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.7691203518993890000000SUM(G50:P50)10.769120351899389IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.30764814075975530-0.86152962815195111-3.5538097161267985-2.04613286686088400000095.0831558882422741.595977550231589475.95552733765562443.194481896564049000SUM(S50:AJ50)205.06002232079416000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-96.679133438473869-119.15000923421968SUM(AM50:BE50)-215.8291426726935400SUM(BH50:BI50)0Q50+AK50+BF50+BJ5001.53029200200490312.6402911941804047E-31.9147375891174701E-20000000000000013.4749669780484920.65438545386427907.64650126082866950000000000000000000000043.327933361831697
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.7691203518993890000000SUM(G51:P51)10.769120351899389SUM(S48:S50)-4.30764814075975530-0.86152962815195111-3.5538097161267985-2.04613286686088455.4306940438110660000095.083155888242274SUM(AE48:AE50)1.5959775502315894106.5521914223318364.52412290604434SUM(AH48:AH50)21.22522160920756200SUM(S51:AJ51)333.64224306796928SUM(AM48:AM50)00000000000000000-96.873577882918312-247.53778553695037SUM(AM51:BE51)-344.41136341986868SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ510SUM(BO48:BO50)1.53029200200490312.6402911941804047E-31.9147375891174701E-20000000000000013.4749669780484920.65438545386427907.6465012608286695000011.7852350204162391.48093734503796770000000000000000056.5941057272859
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.226099651069917600-42.835131750114932-1.9055906480415794IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.6137058904411235600000000SUM(S53:AJ53)-50.580527939667554IFERROR(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)50.580527939667554SUM(BH53:BI53)50.580527939667554Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)11.0594116167683831.4035222658077558E-20.193428876336893570000000IFERROR(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.266875715763355
975INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0016.0094102400737480000000SUM(G54:P54)16.009410240073748-0.638972143961613950-2.2981132038460916E-20-15.34745696407367263.965000000000003232.47441995977493177.496435356474620000000000SUM(S54:AJ54)457.92644507617581-63.965000000000003-232.47441995977493-177.496435356474620000000000000000SUM(AM54:BE54)-473.93585531624956IFERROR(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.8153222182833875.6432731508778726E-36.0696146301401355E-301.21292804586487461.3576644262911814000000000000000000000000000000000000005.3976275782204617
956INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)016.0094102400737480000000SUM(G55:P55)16.009410240073748SUM(S53:S54)-5.86507179503153160-2.2981132038460916E-2-42.835131750114932-17.25304761211525SUM(X53:X54)63.965000000000003SUM(Y53:Y54)232.47441995977493SUM(Z53:Z54)177.496435356474620-0.613705890441123560SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)407.34591713650832SUM(AM53:AM54)-63.965000000000003-232.47441995977493-177.496435356474620000000000000000SUM(AM55:BE55)-473.93585531624956SUM(BH53:BH54)0SUM(BI53:BI54)50.580527939667554SUM(BH55:BI55)50.580527939667554Q55+AK55+BF55+BJ556.3948846218409017E-14SUM(BO53:BO54)13.8747338350517711.9678495808955431E-20.199498490967033701.21292804586487461.35766442629118140000000000000000000000000000000000000016.664503293983817
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)00212.224860000000010000000000000000SUM(S58:AJ58)212.2248600000000100000000000-212.224860000000010000000SUM(AM58:BE58)-212.2248600000000100SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
798INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric power stations0000000000006.495605999999999500000000000000006.4956059999999995000000000000000-6.4956059999999995000-6.49560599999999950000000000000000000000000000000000000000000000000
803INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Tidal and Wave0000000000005.56857414794520800000000000000005.568574147945208000000000000-2.3997385315068493-3.168835616438358200000-5.5685741479452080000000000000000000000000000000000000000000000000
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)0283.985675467945210000000000SUM(AE57:AE62)000SUM(AH57:AH62)000283.98567546794521SUM(AM57:AM62)00000000000-264.90869531999999-2.3997385315068493-3.1688356164383582-7.0128000000000013-6.4956059999999995000-283.98567546794521SUM(BH57:BH62)0SUM(BI57:BI62)000SUM(BO57:BO62)000000000000000000000000000000000000000000000
0
963INDEX(Modules[Module], MATCH($C65, Modules[Code], 0))Solar PVIFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000SUM(G65:P65)0IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)09.2041903875262943000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)9.2041903875262943IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-9.204190387526294300000000SUM(AM65:BE65)-9.2041903875262943IFERROR(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.771746923677650300000000SUM(G66:P66)0.7717469236776503-0.771746923677650300000000000000010.8044569314871040SUM(S66:AJ66)10.0327100078094540000000000-10.80445693148710400000000SUM(AM66:BE66)-10.80445693148710400SUM(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.771746923677650300000000SUM(G68:P68)0.7717469236776503SUM(S65:S67)-0.77174692367765039.33778422752629390000000000SUM(AE65:AE67)000SUM(AH65:AH67)010.8044569314871040SUM(S68:AJ68)19.370494235335748SUM(AM65:AM67)0000000000-20.008647319013399-0.133593840000000130000000SUM(AM68:BE68)-20.142241159013398SUM(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-44.875400563684579SUM(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-6.4107715090977972000IFERROR(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)0044.87540056368457900000000SUM(S71:AJ71)38.46462905458678IFERROR(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)-38.46462905458678IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-38.46462905458678Q71+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-6.4107715090977972000000044.8754005636845790AD710AE71000AH710AI7100SUM(S72:AJ72)38.46462905458678AM710AN71000000000000000000SUM(AM72:BE72)0BH71-38.46462905458678BI710SUM(BH72:BI72)-38.46462905458678Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16901318S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-547.61520198951655T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$72245.91046086975172SUM(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)0148.67135999999999000IFERROR(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)148.67135999999999IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-454.27359999999999000000000SUM(AM75:BE75)-454.27359999999999IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)290.73510399999998IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)14.867136SUM(BH75:BI75)305.602239999999990IFERROR(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)0S750148.67135999999999000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)148.67135999999999AM750AN7500000000-454.27359999999999000000000SUM(AM76:BE76)-454.27359999999999BH75290.73510399999998BI7514.867136SUM(BH76:BI76)305.602239999999990BO75000000000000000000000000000000000000000000000
00
16911318S$74+S$76-547.61520198951655T$74+T$76394.5818208697517100
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)0113.73585583244399-183.947385798750020-69.104217446129027IFERROR(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)-139.31574741243506IFERROR(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)121.91224324487904IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)17.403504167556001SUM(BH79:BI79)139.315747412435030IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)69.3709708361027420.1919216397351810.529299045279180480000000000000000000000000000000000000-62.4338737524924670007.6583177686246344
16921318S78+S79-547.61520198951655T78+T79508.3176767021956800
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)039.297525287320866-14.2009200000000020-70.510325986134561IFERROR(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)-45.413720698813698IFERROR(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)44.485760993067274IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0.9279597057464174SUM(BH81:BI81)45.413720698813691Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)17.3477833414487573.8854885788467325E-26.6716818711770667E-20000000000000000000000000000000000000000017.453355045948996
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810153.03338111976484-198.148305798750020-139.61454343226359000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-184.72946811124876AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81166.39800423794631BI79+BI8118.331463873302418SUM(BH82:BI82)184.729468111248740BO79+BO8186.7187541775515030.230776525523648330.596015863990951190000000000000000000000000000000000000-62.43387375249246700025.111672814573645
SUM(AM83:BE83)00
1786249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$4600.771746923677650326.7785305919731370000000SUM(G84:P84)27.550277515650787S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-16.352491582150442588.61742930613855-199.03281655894043-46.388941466241732-163.31021129921996119.39569404381106232.47441995977493177.49643535647462044.261694673243454095.0831558882422741.5959775502315894106.5521914223318364.5241229060443421.22522160920756210.8044569314871046.9939702150812497SUM(S84:AJ84)1043.940308955516AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-63.965000000000003-232.47441995977493-177.49643535647462000000-454.27359999999999-20.008647319013399-265.04228916-2.3997385315068493-3.1688356164383582-7.0128000000000013-6.49560599999999950-96.873577882918312-247.53778553695037SUM(AM84:BE84)-1576.748735363077BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46421.47972047596153BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4683.779127812969961SUM(BH84:BI84)505.258848288931526.9939702132160164E-4BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46102.932733693996540.254716848615814780.8164057717463735201.21292804586487461.35766442629118140000000000013.4749669780484920.65438545386427907.6465012608286695000011.7852350204162391.48093734503796770000000000000-62.43387375249246700DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)99.182601092217965
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-546.84345506583895T$40+$S46+T$51+T$99+T$55+T$89-5.40802472268150320
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-41.002227316621997000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-41.002227316621997IFERROR(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)41.002227316621976SUM(BH91:BI91)41.0022273166219760IFERROR(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.69385019377655443.3952985054680257E-33.6518086102700605E-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-41.002227316621997000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-41.002227316621997AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9241.002227316621976SUM(BH93:BI93)41.0022273166219760BO$89+BO$91+BO$921.69385019377655443.3952985054680257E-33.6518086102700605E-300000000000000000000000000000000000000000SUM(BO93:DF93)1.7008973008922925
00
16941642(U$40+U$84+U$93)-251.70982893180047(V$40+V$84+V$93)-667.23126155201805(W$40+W$84+W$93)-459.63161922981772(AC$40+AC$84+AC$93)095.0831558882422741.5959775502315894106.5521914223318364.5241229060443421.225221609207562BE40+BE46+BE51-247.53778553695037SUM(AM95:BE95)-247.537785536950370
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)00191.553579945045390.5043289058731822476.070726079345249000000-95.083155888242274-1.5959775502315894-106.55219142233183-64.52412290604434-21.22522160920756200SUM(S96:AJ96)-20.852034445793773IFERROR(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)20.85203444579372IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)20.85203444579372Q96+AK96+BF96+BJ96-5.3290705182007514E-14IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-73.1215984481417820000000-73.121598448141782
16951642U$95+U$96-60.156248986755088V$95+V$96-666.72693264614486W$95+W$96-383.56089315047245AC$95+AC$96000000BE42+BE49+BE53-128.38777630273069SUM(AM97:BE97)-128.38777630273069SUM(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)0024.3242348837209322.6527604651162800000000000000SUM(S98:AJ98)46.976995348837207IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-46.976995348837207000000000000000SUM(AM98:BE98)-46.976995348837207IFERROR(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-13.1550544604651150000000SUM(BO98:DF98)-13.155054460465115
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S9800215.877814828766323.15708937098946476.070726079345249000000AD$96+AD98-95.083155888242274AE$96+AE98-1.5959775502315894-106.55219142233183-64.52412290604434AH$96+AH98-21.22522160920756200SUM(S99:AJ99)26.124960903043419AM$96+AM98000-46.976995348837207000000000000000SUM(AM99:BE99)-46.976995348837207BH$96+BH9820.85203444579372BI$96+BI980SUM(BH99:BI99)20.85203444579372Q99+AK99+BF99+BJ99-6.7501559897209518E-14BO$96+BO98000000000000000000000000000000000000-86.2766529086068910000000-86.276652908606891
0
16961209(S$40+S$84+S$93+S$99)-547.61520198951666(T$40+T$84+T$93+T$99)547.61520198951655(U$40+U$84+U$93+U$99)-35.832014103034169(V$40+V$84+V$93+V$99)-644.07417218102864(W$40+W$84+W$93+W$99)-383.560893150472450
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)0035.832014103034169644.07417218102864383.56089315047245-35.832014103034169-644.07417218102864-387.981570636724310000000000SUM(S102:AJ102)-4.4206774862519751IFERROR(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)4.4206774862518579SUM(BH102:BI102)4.4206774862518579Q102+AK102+BF102+BJ102-1.1723955140041653E-13IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000001.73332054412671830000IFERROR(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.7333205441267183
7931000INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)1.1368683772161603E-13-(X$40+X$84+X$93+X$99+X$102)-83.563679940776893-(Y$40+Y$84+Y$93+Y$99+Y$102)411.59975222125371-(Z$40+Z$84+Z$93+Z$99+Z$102)210.48513528024969SUM(S103:AJ103)538.52120756072657-T103-1.1368683772161603E-13-V1030-X10383.563679940776893-Y103-411.59975222125371-Z103-210.48513528024969SUM(AM103:BE103)-538.52120756072657SUM(BH103:BI103)00000000000000000000000000000000000000000000000
793998INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)01.1368683772161603E-1335.832014103034169644.07417218102864383.56089315047245-119.39569404381106-232.47441995977493-177.49643535647462000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)534.10053007447459SUM(AM102:AM103)0000-1.1368683772161603E-13083.563679940776893-411.59975222125371-210.485135280249690000000000SUM(AM104:BE104)-538.52120756072657SUM(BH102:BH103)0SUM(BI102:BI103)4.4206774862518579SUM(BH104:BI104)4.4206774862518579-1.1723955140041653E-13SUM(BO102:BO103)000001.7333205441267183000000000000000000000000000000000000001.7333205441267183
0
17871002G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-41.002227316621884251.70982893180047667.23126155201805459.63161922981772-119.39569404381106-232.47441995977493-177.49643535647462000-95.083155888242274-1.5959775502315894-106.55219142233183-64.52412290604434-21.22522160920756200SUM(S106:AJ106)519.22326366089612AM$93+AM$99+AM$104000-46.976995348837207-1.1368683772161603E-13083.563679940776893-411.59975222125371-210.485135280249690000000000SUM(AM106:BE106)-585.49820290956382BH$93+BH$99+BH$10420.85203444579372BI$93+BI$99+BI$10445.42290480287383SUM(BH106:BI106)66.27493924866755-1.4210854715202004E-13BO$93+BO$99+BO$1041.69385019377655443.3952985054680257E-33.6518086102700605E-3001.7333205441267183000000000000000000000000000000-86.276652908606891000000DF$93+DF$1040SUM(BO106:DF106)-82.842435063587885
0
0
593G$40+G$84+G$106488.36079852321268174.58667757736663486.67417280850469231.0144155158946313.99201834346407513.22305430785236930.221771808142936212.0565390643582580.8029353922244980SUM(G109:P109)1730.9323833410206S$40+S$84+S$106-547.61520198951666547.615201989516660000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-63.965000000000003-232.47441995977493-177.49643535647462-46.976995348837207-1.1368683772161603E-13083.563679940776893-411.59975222125371-210.48513528024969-454.27359999999999-20.008647319013399-265.04228916-2.3997385315068493-3.1688356164383582-7.0128000000000013-6.4956059999999995-140.21853320895784-96.873577882918312-247.53778553695037SUM(AM109:BE109)-2302.4654714815983BH$40+BH$84+BH$106442.33175492175525BI$40+BI$84+BI$106129.20203261584379SUM(BH109:BI109)571.533787537598986.993970212079148E-4BO$40+BO$84+BO$106257.369954165142360.517149113191187732.556601197730952601.21292804586487463.09098497041789950016.018400655405010.121829169570129493.01748700478854385.31592509311724730000013.4749669780484920.65438545386427907.6465012608286695000011.7852350204162391.48093734503796770000073.2148686141456869.1152222390528365E-21.31728551026988550-86.276652908606891000-64.852330343509635000SUM(BO109:DF109)267.75760856811337
|
|
2329SUM(DH63,DH68,DH76,DH82)25.111672814573645
79310032330T109-MIN(T103,0)-T72554.02597349861446
2331DH112/DH1134.5325804232599659E-2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D