|
2045
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)369.22755850412432IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)369.22755850412432IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-97.3956771281436030-1.4256989302195553-1.2787196590629-51.102898404956925IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000-38.586517313963796000000-16.1972858151349330SUM(S9:AJ9)-205.98679725148173IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000-163.2407612526425900SUM(AM9:BE9)-163.24076125264259IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ90IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)10.161728491785422.0536007640052169E-22.9913594429615283E-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)369.22755850412432SUM(H9:H10)000000000369.22755850412432SUM(S9:S10)-97.395677128143603SUM(T9:T10)0-1.4256989302195553-1.2787196590629-51.102898404956925SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)00-38.5865173139637960SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)-16.1972858151349330-205.98679725148173SUM(AM9:AM10)0000000000000000-163.2407612526425900-163.24076125264259SUM(BH9:BH10)0SUM(BI9:BI10)000SUM(BO9:BO10)10.161728491785422.0536007640052169E-22.9913594429615283E-200000000000000000000000000000000000000000
932INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling129.54244058565749000000000129.54244058565749-38.52594052027939100-1.5464728381094155-14.213440446626766IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000-18.13387353614124800000000-72.419727341156829IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000000-57.12271324450065900-57.1227132445006590000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)3.00189125170667875.7236155810042278E-31.2594378049362837E-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)129.54244058565749SUM(H12:H13)000000000129.54244058565749SUM(S12:S13)-38.52594052027939100-1.5464728381094155-14.213440446626766SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)00-18.1338735361412480SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-72.419727341156829SUM(AM12:AM13)0000000SUM(AT12:AT13)000000000-57.12271324450065900-57.122713244500659SUM(BH12:BH13)0SUM(BI12:BI13)000SUM(BO12:BO13)3.00189125170667875.7236155810042278E-31.2594378049362837E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11498.76999908978178000000000498.76999908978178S14+S11-135.921617648422990-1.4256989302195553-2.8251924971723152-65.316338851583694000AA14+AA110-56.7203908501050480AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI11-16.1972858151349330-278.40652459263856AM14+AM110000000AT14+AT11000000000-220.3634744971432400-220.36347449714324BH14+BH110BI14+BI1100-2.8421709430404007E-14BO14+BO1113.1636197434920992.6259623221056398E-24.2507972478978119E-200000000000000000000000000000000000000000SUM(BO15:DF15)13.232387339192133
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)091.47579954150737100000000SUM(G17:P17)91.475799541507371IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-90.624712593660945000-0.85108694784642391IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-91.475799541507371IFERROR(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.156599998403741973.1390245872396226E-43.3761735520662092E-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.15725151821767255
938INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering088.58622903429336800000000SUM(G18:P18)88.586229034293368-87.606093262799206000-0.980135771494162090000000000000SUM(S18:AJ18)-88.5862290342933680000000000000000000SUM(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.180344981954925793.6149893889671388E-43.8880968360822731E-4000000000000000000000000000000000000000000.18109529057743073
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18180.0620285758007500000000SUM(G19:P19)180.06202857580075S17+S18-178.23080585646017T17+T18000-1.8312227193405861X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-180.06202857580075AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)00BO17+BO180.336944980358667776.7540139762067614E-47.2642703881484823E-4000000000000000000000000000000000000000000.33834680879510332
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)00494.274645038465450000000SUM(G21:P21)494.27464503846545IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-294.541612021225150-47.208082202066251-79.953102137515401-62.886096190130438IFERROR(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.6857524875281200000000SUM(S21:AJ21)-494.27464503846539IFERROR(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)46.0994065515992529.0792839822650601E-20.513379872649916360000016.673039181504990.125345250603208783.11422702899257064.30562326114670310000000000000000000000000000-7.942770261114475300062.979043725204818
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210494.274645038465450000000SUM(G22:P22)494.27464503846545S21-294.541612021225150-47.208082202066251-79.953102137515401-62.886096190130438000AA210-9.685752487528120AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-494.27464503846539AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)05.6843418860808015E-14BO2146.0994065515992529.0792839822650601E-20.513379872649916360000016.673039181504990.125345250603208783.11422702899257064.30562326114670310000000000000000000000000000-7.942770261114475300062.979043725204818
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)000133.884464883035979.896375278988472214.0905094223622740000SUM(G24:P24)157.87134958438673IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-42.6410781058664700-99.7032396889466240IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000000000000-15.527031789573648SUM(S24:AJ24)-157.87134958438673IFERROR(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)24.9258099222366563.1032534952289428E-20.448466395744645530000000IFERROR(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)0000000000000025.40530885293359
903INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00073.1653165073460912.8906298374581785032.206096733453151000SUM(G25:P25)108.26204307825742-0.1213745886806170100-108.1406684895768100000000000000-108.2620430782574300000000000000000000000-1.4210854715202004E-1427.0351671223942033.3658676339268223E-20.486418054039558290000000000000000000000000000000000000000027.555243852773028
906INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000209.179517640834400SUM(G26:P26)209.1795176408344000-209.179517640834400000000000000-209.17951764083440000000000000000000000000000000000000000000000000000000052.2948794102086016.5106918418538495E-20.9408920375371567800000000053.300878366164291
941INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
947SUM(G26:G27)0SUM(H26:H27)000000209.179517640834400209.1795176408344SUM(S26:S27)000-209.17951764083440000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-209.1795176408344SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000052.2948794102086016.5106918418538495E-20.9408920375371567800000000053.300878366164291
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)00000000110.1964862976420110.196486297642000-110.1964862976420IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-110.196486297642IFERROR(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)0027.5491215744104993.4298547603064229E-20.495665147770584400000000028.079085269784148
946INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G29:G30)0SUM(H29:H30)0000000110.1964862976420110.196486297642SUM(S29:S30)000-110.1964862976420000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-110.196486297642SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)0000000000000000000000000000000027.5491215744104993.4298547603064229E-20.495665147770584400000000028.079085269784148
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000207.0497813903820712.7870051164466514.09050942236227432.206096733453151209.1795176408344110.1964862976420585.50939660112056S24+S25+S28+S31-42.76245269454708600-527.219912116999810000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI310-15.527031789573648-585.50939660112056AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI31000BO24+BO25+BO28+BO3151.9609770446308596.4691211291557651E-20.934884449784203820000000000000000000000000000079.84400098461919.9405466021602717E-21.4365571853077412000000000134.34051634165507
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$38498.76999908978178180.06202857580075494.27464503846545207.0497813903820712.7870051164466514.09050942236227432.206096733453151209.1795176408344110.19648629764201758.6160693051684S$15+S$19+S$22+S$32+S$35+S$38-651.456488220655390-48.633781132285804-609.99820675168758-130.03365776105471X$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-66.406143337633168000000-16.197285815134933-15.527031789573648SUM(S40:AJ40)-1538.2525948080249AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000-220.3634744971432400SUM(AM40:BE40)-220.36347449714324BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)01.9895196601282805E-13BO$15+BO$19+BO$22+BO$32+BO$35+BO$38111.560948320080880.182419075732885321.49149872195191310000016.673039181504990.125345250603208783.11422702899257064.30562326114670310000000000000000000079.84400098461919.9405466021602717E-21.436557185307741200000-7.9427702611144753000SUM(BO40:DF40)210.89029421484713
0
720
0
18931894AJ$40-15.5270317895736480SUM(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)-16.936319245114237000-3.94214084879731IFERROR(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)000000000015.527031789573648SUM(S45:AJ45)-5.351428304337901IFERROR(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)5.3514283043378974IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)5.3514283043378974IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)0.725353916178704931.453961558457523E-31.563806342690024E-300000000000000000000000000000000000000000SUM(BO45:DF45)0.72837168407985253
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45-16.936319245114237000-3.94214084879731000000AD450AE4500AG450AH450AI45015.527031789573648SUM(S46:AJ46)-5.351428304337901AM450AN45000000000000000000SUM(AM46:BE46)0BH455.3514283043378974BI450SUM(BH46:BI46)5.3514283043378974Q46+AK46+BF46+BJ460BO450.725353916178704931.453961558457523E-31.563806342690024E-300000000000000000000000000000000000000000SUM(BO46:DF46)0.72837168407985253
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)0000000001.9444444444444446000SUM(S48:AJ48)1.9444444444444446IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000000000000000-1.94444444444444460SUM(AM48:BE48)-1.9444444444444446IFERROR(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.12665984533533223.595902593429420.74571967279509700SUM(S49:AJ49)134.05538692012797000000000000000000-134.05538692012794SUM(AM49:BE49)-134.0553869201279400SUM(BH49:BI49)000000000000000000000000008.23912858365585341.544008380420842000000000000000009.7831369640766948
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.9420150969584750000000SUM(G50:P50)10.942015096958475IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.376806038783390-0.87536120775667803-3.610864981996297-2.0789828684221101000000149.710890477034891.784952954155103280.93221103885272842.999579403874293000SUM(S50:AJ50)264.48561877695852000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-151.49584343119-123.93179044272702SUM(AM50:BE50)-275.4276338739169900SUM(BH50:BI50)0Q50+AK50+BF50+BJ5001.55486034527779912.6826802155658939E-31.9454780819811356E-20000000000000012.6687983178965220.16074579990524302.498202571602250000000000000000000000036.904744495717189
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.9420150969584750000000SUM(G51:P51)10.942015096958475SUM(S48:S50)-4.376806038783390-0.87536120775667803-3.610864981996297-2.078982868422110156.58710480856814200000149.71089047703489SUM(AE48:AE50)1.7849529541551032114.0588708841880568.539926441748136SUM(AH48:AH50)20.74571967279509700SUM(S51:AJ51)400.48545014153098SUM(AM48:AM50)00000000000000000-153.44028787563445-257.98717736285494SUM(AM51:BE51)-411.42746523848939SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ515.6843418860808015E-14SUM(BO48:BO50)1.55486034527779912.6826802155658939E-31.9454780819811356E-20000000000000012.6687983178965220.16074579990524302.4982025716022500008.23912858365585341.5440083804208420000000000000000046.687881459793886
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.023177894720479500-41.171906639890828-1.8315993683107199IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.5898765941235889500000000SUM(S53:AJ53)-48.616560497045619IFERROR(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)48.616560497045619SUM(BH53:BI53)48.616560497045619Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)10.6299909437418791.3490255622871969E-20.185918317806509410000000IFERROR(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)0000000000000010.829399517171259
975INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production009.81625293060098690000000SUM(G54:P54)9.8162529306009869-0.585406195024667950-2.2981132038460916E-20-9.207865603537857963.965000000000003139.19102265793308106.273672431058330000000000SUM(S54:AJ54)299.6134421583904-63.965000000000003-139.19102265793308-106.273672431058330000000000000000SUM(AM54:BE54)-309.42969508899142IFERROR(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)01.68563740794479733.3788360936427377E-33.634102486006588E-300.726224825697522671.3576644262911814000000000000000000000000000000000000003.7765395985131507
956INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)09.81625293060098690000000SUM(G55:P55)9.8162529306009869SUM(S53:S54)-5.60858408974514780-2.2981132038460916E-2-41.171906639890828-11.039464971848577SUM(X53:X54)63.965000000000003SUM(Y53:Y54)139.19102265793308SUM(Z53:Z54)106.273672431058330-0.589876594123588950SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)250.99688166134482SUM(AM53:AM54)-63.965000000000003-139.19102265793308-106.273672431058330000000000000000SUM(AM55:BE55)-309.42969508899142SUM(BH53:BH54)0SUM(BI53:BI54)48.616560497045619SUM(BH55:BI55)48.616560497045619Q55+AK55+BF55+BJ550SUM(BO53:BO54)12.3156283516866761.6869091716514708E-20.1895524202925160100.726224825697522671.35766442629118140000000000000000000000000000000000000014.605939115684412
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.828713999999999700000000000000006.8287139999999997000000000000000-6.8287139999999997000-6.82871399999999970000000000000000000000000000000000000000000000000
803INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Tidal and Wave00000000000023.461366430136991000000000000000023.461366430136991000000000000-8.2509554712328761-15.21041095890411500000-23.4613664301369910000000000000000000000000000000000000000000000000
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)0326.668715750136980000000000SUM(AE57:AE62)000SUM(AH57:AH62)000326.66871575013698SUM(AM57:AM62)00000000000-289.36583531999997-8.2509554712328761-15.210410958904115-7.0128000000000013-6.8287139999999997000-326.66871575013698SUM(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)032.083718118141988000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)32.083718118141988IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-32.08371811814198800000000SUM(AM65:BE65)-32.083718118141988IFERROR(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 thermal01.156948986795352200000000SUM(G66:P66)1.1569489867953522-1.156948986795352200000000000000016.1972858151349330SUM(S66:AJ66)15.040336828339580000000000-16.19728581513493300000000SUM(AM66:BE66)-16.19728581513493300SUM(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)1.156948986795352200000000SUM(G68:P68)1.1569489867953522SUM(S65:S67)-1.156948986795352232.2173119581419910000000000SUM(AE65:AE67)000SUM(AH65:AH67)016.1972858151349330SUM(S68:AJ68)47.257648786481568SUM(AM65:AM67)0000000000-48.281003933276921-0.133593840000000130000000SUM(AM68:BE68)-48.414597773276924SUM(BH65:BH67)0SUM(BI65:BI67)0SUM(BH68:BI68)0-7.1054273576010019E-15SUM(BO65:BO67)0SUM(BP65:BP67)00000000000000000000000000000000000000000000
00
16891324AB$40+AB$46+AB$51+AB$99+AB$55+AB$63+AB$68-66.996019931756763SUM(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-9.5708599902509661000IFERROR(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)0066.99601993175676300000000SUM(S71:AJ71)57.425159941505797IFERROR(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)-57.425159941505797IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-57.425159941505797Q71+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-9.5708599902509661000000066.9960199317567630AD710AE71000AH710AI7100SUM(S72:AJ72)57.425159941505797AM710AN71000000000000000000SUM(AM72:BE72)0BH71-57.425159941505797BI710SUM(BH72:BI72)-57.425159941505797Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16901318S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-679.53514658109339T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$72298.45048824398577SUM(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)0232.82496000000003000IFERROR(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)232.82496000000003IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-711.40960000000007000000000SUM(AM75:BE75)-711.40960000000007IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)455.30214400000006IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)23.282496000000005SUM(BH75:BI75)478.584640000000040IFERROR(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)0S750232.82496000000003000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)232.82496000000003AM750AN7500000000-711.40960000000007000000000SUM(AM76:BE76)-711.40960000000007BH75455.30214400000006BI7523.282496000000005SUM(BH76:BI76)478.584640000000040BO75000000000000000000000000000000000000000000000
00
16911318S$74+S$76-679.53514658109339T$74+T$76531.2754482439858100
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)0212.1332388961842-332.255102190612260-125.15759363531247IFERROR(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)-245.27945692974055IFERROR(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)214.50683582592472IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)30.772621103815801SUM(BH79:BI79)245.279456929740520IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)125.363568703606050.346783285538553810.956180894320966760000000000000000000000000000000000000-112.8272118332454400013.839321050220121
16921318S78+S79-679.53514658109339T78+T79743.4086871401700600
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+S810212.1332388961842-332.255102190612260-125.15759363531247000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-245.27945692974055AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81214.50683582592472BI79+BI8130.772621103815801SUM(BH82:BI82)245.279456929740520BO79+BO81125.363568703606050.346783285538553810.956180894320966760000000000000000000000000000000000000-112.8272118332454400013.839321050220121
SUM(AM83:BE83)00
1786249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$4601.156948986795352220.758268027559460000000SUM(G84:P84)21.915217014354813S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-28.078658360438126794.27336661421214-333.1534445304074-44.782771621887122-142.21818232438048120.55210480856815139.19102265793308106.27367243105833066.4061433376331680149.710890477034891.7849529541551032114.0588708841880568.53992644174813620.74571967279509716.19728581513493315.527031789573648SUM(S84:AJ84)1065.0279310469216AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-63.965000000000003-139.19102265793308-106.27367243105833000000-711.40960000000007-48.281003933276921-289.49942915999998-8.2509554712328761-15.210410958904115-7.0128000000000013-6.82871399999999970-153.44028787563445-257.98717736285494SUM(AM84:BE84)-1807.3500738508944BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46617.73524818875683BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$46102.67167760086141SUM(BH84:BI84)720.40692578961830BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46139.959411316749230.367789019029091951.16675190177598400.726224825697522671.35766442629118140000000000012.6687983178965220.16074579990524302.4982025716022500008.23912858365585341.5440083804208420000000000000-112.8272118332454400DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)75.861513309778317
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-678.37819759429806T$40+$S46+T$51+T$99+T$55+T$89-16.9363192451142370
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-50.864679474042191000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-50.864679474042191IFERROR(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)50.864679474042219SUM(BH91:BI91)50.8646794740422190IFERROR(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.88658523622599293.7816331435512681E-34.0673302957789691E-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-50.864679474042191000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-50.864679474042191AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9250.864679474042219SUM(BH93:BI93)50.8646794740422190BO$89+BO$91+BO$921.88658523622599293.7816331435512681E-34.0673302957789691E-300000000000000000000000000000000000000000SUM(BO93:DF93)1.8944341996653231
00
16941642(U$40+U$84+U$93)-381.78722566269323(V$40+V$84+V$93)-654.78097837357473(W$40+W$84+W$93)-272.25184008543522(AC$40+AC$84+AC$93)0149.710890477034891.7849529541551032114.0588708841880568.53992644174813620.7457196727950970
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)00250.581273293161790.5640451335130126679.004657148281012000000-149.71089047703489-1.7849529541551032-114.05887088418805-68.539926441748136-20.74571967279509700SUM(S96:AJ96)-24.690384854965465IFERROR(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)24.690384854965487IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)24.690384854965487Q96+AK96+BF96+BJ960IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-91.8569003729557640000000-91.856900372955764
16951642U$95+U$96-131.20595236953145V$95+V$96-654.21693324006173W$95+W$96-193.24718293715421AC$95+AC$96000000SUM(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)0031.44141162790697730.88425348837209600000000000000SUM(S98:AJ98)62.325665116279069IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-62.325665116279069000000000000000SUM(AM98:BE98)-62.325665116279069IFERROR(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-17.4050181534883710000000SUM(BO98:DF98)-17.405018153488371
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S9800282.0226849210687931.44829862188510879.004657148281012000000AD$96+AD98-149.71089047703489AE$96+AE98-1.7849529541551032-114.05887088418805-68.539926441748136AH$96+AH98-20.74571967279509700SUM(S99:AJ99)37.635280261313618AM$96+AM98000-62.325665116279069000000000000000SUM(AM99:BE99)-62.325665116279069BH$96+BH9824.690384854965487BI$96+BI980SUM(BH99:BI99)24.690384854965487Q99+AK99+BF99+BJ993.5527136788005009E-14BO$96+BO98000000000000000000000000000000000000-109.261918526444130000000-109.26191852644413
0
16961209(S$40+S$84+S$93+S$99)-679.5351465810935(T$40+T$84+T$93+T$99)743.40868714016995(U$40+U$84+U$93+U$99)-99.764540741624444(V$40+V$84+V$93+V$99)-623.33267975168962(W$40+W$84+W$93+W$99)-193.247182937154210
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)0099.764540741624444623.33267975168962193.24718293715421-99.764540741624444-623.33267975168962-195.474426345299920000000000SUM(S102:AJ102)-2.2272434081457106IFERROR(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.2272434081457129SUM(BH102:BI102)2.2272434081457129Q102+AK102+BF102+BJ1020IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000000.873288487594009570000IFERROR(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)000000000000000.87328848759400957
7931000INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)-63.873540559076446-(X$40+X$84+X$93+X$99+X$102)-20.787564066943702-(Y$40+Y$84+Y$93+Y$99+Y$102)484.14165709375652-(Z$40+Z$84+Z$93+Z$99+Z$102)89.200753914241588SUM(S103:AJ103)488.681306381978-T10363.873540559076446-V1030-X10320.787564066943702-Y103-484.14165709375652-Z103-89.200753914241588SUM(AM103:BE103)-488.681306381978SUM(BH103:BI103)00000000000000000000000000000000000000000000000
793998INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)0-63.87354055907644699.764540741624444623.33267975168962193.24718293715421-120.55210480856815-139.1910226579331-106.27367243105833000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)486.45406297383227SUM(AM102:AM103)000063.873540559076446020.787564066943702-484.14165709375652-89.2007539142415880000000000SUM(AM104:BE104)-488.681306381978SUM(BH102:BH103)0SUM(BI102:BI103)2.2272434081457129SUM(BH104:BI104)2.2272434081457129-2.6201263381153694E-14SUM(BO102:BO103)000000.87328848759400957000000000000000000000000000000000000000.87328848759400957
0
17871002G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-114.73822003311864381.78722566269323654.78097837357473272.25184008543522-120.55210480856815-139.1910226579331-106.27367243105833000-149.71089047703489-1.7849529541551032-114.05887088418805-68.539926441748136-20.74571967279509700SUM(S106:AJ106)473.22466376110373AM$93+AM$99+AM$104000-62.32566511627906963.873540559076446020.787564066943702-484.14165709375652-89.2007539142415880000000000SUM(AM106:BE106)-551.00697149825703BH$93+BH$99+BH$10424.690384854965487BI$93+BI$99+BI$10453.09192288218793SUM(BH106:BI106)77.7823077371534171.1368683772161603E-13BO$93+BO$99+BO$1041.88658523622599293.7816331435512681E-34.0673302957789691E-3000.87328848759400957000000000000000000000000000000-109.26191852644413000000DF$93+DF$1040SUM(BO106:DF106)-106.4941958391848
0
0
593G$40+G$84+G$106498.76999908978178181.21897756259611515.03291306602489207.0497813903820712.7870051164466514.09050942236227432.206096733453151209.1795176408344110.1964862976420SUM(G109:P109)1780.5312863195231S$40+S$84+S$106-679.5351465810935679.53514658109350000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-63.965000000000003-139.19102265793308-106.27367243105833-62.32566511627906963.873540559076446020.787564066943702-484.14165709375652-89.200753914241588-711.40960000000007-48.281003933276921-289.49942915999998-8.2509554712328761-15.210410958904115-7.0128000000000013-6.8287139999999997-220.36347449714324-153.44028787563445-257.98717736285494SUM(AM109:BE109)-2578.7205198462952BH$40+BH$84+BH$106642.42563304372231BI$40+BI$84+BI$106155.76360048304934SUM(BH109:BI109)798.189233526771660BO$40+BO$84+BO$106253.406944873056090.553989727905528582.662317954023675900.726224825697522672.23095291388519090016.673039181504990.125345250603208783.11422702899257064.30562326114670310000012.6687983178965220.16074579990524302.4982025716022500008.23912858365585341.5440083804208420000079.84400098461919.9405466021602717E-21.43655718530774120-109.26191852644413000-120.76998209435992000SUM(BO109:DF109)180.25761168544051
|
|
2329SUM(DH63,DH68,DH76,DH82)13.839321050220121
79310032330T109-MIN(T103,0)-T72752.97954713042088
2331DH112/DH1131.8379411636028225E-2
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D