|
2007
Preferences.EnergyUnitsTWh74968910519321055
INDEX(Vectors[Description], MATCH(G$5,Vectors[Code],FALSE))Heating and coolingINDEX(Vectors[Description], MATCH(H$5,Vectors[Code],FALSE))Lighting & appliancesINDEX(Vectors[Description], MATCH(I$5,Vectors[Code],FALSE))IndustryINDEX(Vectors[Description], MATCH(J$5,Vectors[Code],FALSE))Road transportINDEX(Vectors[Description], MATCH(K$5,Vectors[Code],FALSE))Rail transportINDEX(Vectors[Description], MATCH(L$5,Vectors[Code],FALSE))Domestic aviationINDEX(Vectors[Description], MATCH(M$5,Vectors[Code],FALSE))National navigationINDEX(Vectors[Description], MATCH(N$5,Vectors[Code],FALSE))International aviationINDEX(Vectors[Description], MATCH(O$5,Vectors[Code],FALSE))International shippingINDEX(Vectors[Description], MATCH(P$5,Vectors[Code],FALSE))Food consumption [UNUSED]937INDEX(Vectors[Description], MATCH(S$5,Vectors[Code],FALSE))Electricity (delivered to end user)INDEX(Vectors[Description], MATCH(T$5,Vectors[Code],FALSE))Electricity (supplied to grid)INDEX(Vectors[Description], MATCH(U$5,Vectors[Code],FALSE))Solid hydrocarbonsINDEX(Vectors[Description], MATCH(V$5,Vectors[Code],FALSE))Liquid hydrocarbonsINDEX(Vectors[Description], MATCH(W$5,Vectors[Code],FALSE))Gaseous hydrocarbonsINDEX(Vectors[Description], MATCH(X$5,Vectors[Code],FALSE))Coal and fossil wasteINDEX(Vectors[Description], MATCH(Y$5,Vectors[Code],FALSE))Oil and petroleum productsINDEX(Vectors[Description], MATCH(Z$5,Vectors[Code],FALSE))Natural gasINDEX(Vectors[Description], MATCH(AA$5,Vectors[Code],FALSE))Blast furnace gasINDEX(Vectors[Description], MATCH(AB$5,Vectors[Code],FALSE))Heat transportINDEX(Vectors[Description], MATCH(AC$5,Vectors[Code],FALSE))Edible biomassINDEX(Vectors[Description], MATCH(AD$5,Vectors[Code],FALSE))Energy crops (second generation)INDEX(Vectors[Description], MATCH(AE$5,Vectors[Code],FALSE))Energy crops (first generation)INDEX(Vectors[Description], MATCH(AF$5,Vectors[Code],FALSE))Dry biomass and wasteINDEX(Vectors[Description], MATCH(AG$5,Vectors[Code],FALSE))Wet biomass and wasteINDEX(Vectors[Description], MATCH(AH$5,Vectors[Code],FALSE))Gaseous wasteINDEX(Vectors[Description], MATCH(AI$5,Vectors[Code],FALSE))Domestic solar thermalINDEX(Vectors[Description], MATCH(AJ$5,Vectors[Code],FALSE))H2685INDEX(Vectors[Description], MATCH(AM$5,Vectors[Code],FALSE))Coal reservesINDEX(Vectors[Description], MATCH(AN$5,Vectors[Code],FALSE))Oil reservesINDEX(Vectors[Description], MATCH(AO$5,Vectors[Code],FALSE))Gas reservesINDEX(Vectors[Description], MATCH(AP$5,Vectors[Code],FALSE))Biomass oversupply (imports)INDEX(Vectors[Description], MATCH(AQ$5,Vectors[Code],FALSE))Electricity oversupply (imports)INDEX(Vectors[Description], MATCH(AR$5,Vectors[Code],FALSE))Petroleum products oversupplyINDEX(Vectors[Description], MATCH(AS$5,Vectors[Code],FALSE))Coal oversupply (imports)INDEX(Vectors[Description], MATCH(AT$5,Vectors[Code],FALSE))Oil and petroleum products oversupply (imports)INDEX(Vectors[Description], MATCH(AU$5,Vectors[Code],FALSE))Gas oversupply (imports)INDEX(Vectors[Description], MATCH(AV$5,Vectors[Code],FALSE))Nuclear fissionINDEX(Vectors[Description], MATCH(AW$5,Vectors[Code],FALSE))SolarINDEX(Vectors[Description], MATCH(AX$5,Vectors[Code],FALSE))WindINDEX(Vectors[Description], MATCH(AY$5,Vectors[Code],FALSE))TidalINDEX(Vectors[Description], MATCH(AZ$5,Vectors[Code],FALSE))WaveINDEX(Vectors[Description], MATCH(BA$5,Vectors[Code],FALSE))GeothermalINDEX(Vectors[Description], MATCH(BB$5,Vectors[Code],FALSE))HydroINDEX(Vectors[Description], MATCH(BC$5,Vectors[Code],FALSE))Environmental heatINDEX(Vectors[Description], MATCH(BD$5,Vectors[Code],FALSE))AgricultureINDEX(Vectors[Description], MATCH(BE$5,Vectors[Code],FALSE))Waste686INDEX(Vectors[Description], MATCH(BH$5,Vectors[Code],FALSE))Conversion lossesINDEX(Vectors[Description], MATCH(BI$5,Vectors[Code],FALSE))Distribution losses and own use931INDEX(Vectors[Description], MATCH(BL$5,Vectors[Code],FALSE))UnallocatedINDEX(IPCC[Sector_description], MATCH(BO$5, IPCC[Sector_code], 0))Fuel CombustionINDEX(IPCC[Sector_description], MATCH(BS$5, IPCC[Sector_code], 0))Fugitive Emissions from FuelsINDEX(IPCC[Sector_description], MATCH(BW$5, IPCC[Sector_code], 0))Industrial ProcessesINDEX(IPCC[Sector_description], MATCH(CA$5, IPCC[Sector_code], 0))Solvent and Other Product UseINDEX(IPCC[Sector_description], MATCH(CE$5, IPCC[Sector_code], 0))AgricultureINDEX(IPCC[Sector_description], MATCH(CI$5, IPCC[Sector_code], 0))Land Use, Land-Use Change and ForestryINDEX(IPCC[Sector_description], MATCH(CM$5, IPCC[Sector_code], 0))WasteINDEX(IPCC[Sector_description], MATCH(CQ$5, IPCC[Sector_code], 0))OtherINDEX(IPCC[Sector_description], MATCH(CU$5, IPCC[Sector_code], 0))International Aviation and ShippingINDEX(IPCC[Sector_description], MATCH(CY$5, IPCC[Sector_code], 0))Bioenergy creditINDEX(IPCC[Sector_description], MATCH(DC$5, IPCC[Sector_code], 0))Carbon capture148
20065713363738399549554045464749506465661087517521780223875391722411319146498798898959607959799809817338910111210410155434356110531053105310531052105210521052222233334444555566667777103810381038103810391039103910391066106610661066
10431044104510461043104410451046104310441045104610431044104510461043104410451046104310441045104610431044104510461043104410451046104310441045104610431044104510461043104410451046
592
|
825INDEX(Modules[Module], MATCH($C9, Modules[Code], 0))Domestic space heating and hot waterIFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)382.53018590696547IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)382.53018590696547IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-31.0085465298884660-14.256803002247571-12.787029496861225-324.47780687796825IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S9:AJ9)-382.53018590696553IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM9:BE9)0IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ9-5.6843418860808015E-14IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)67.2917691644537110.136555048823782580.225131769415215340000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BY$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), CI$6, INDIRECT($C9&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), CS$6, INDIRECT($C9&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
886INDEX(Modules[Module], MATCH($C10, Modules[Code], 0))Domestic hot water [UNUSED - See IX.a]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
935SUM(G9:G10)382.53018590696547SUM(H9:H10)000000SUM(N9:N10)0SUM(O9:O10)00382.53018590696547SUM(S9:S10)-31.008546529888466SUM(T9:T10)0-14.256803002247571-12.787029496861225-324.47780687796825SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)0000SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)00-382.53018590696553SUM(AM9:AM10)000000000SUM(AV9:AV10)00000000SUM(BD9:BD10)000SUM(BH9:BH10)0SUM(BI9:BI10)00-5.6843418860808015E-14SUM(BO9:BO10)67.2917691644537110.136555048823782580.2251317694152153400000000000000000000000000000000000000000
933INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling115.89465262742715000000000115.89465262742715-28.55169789024786200-9.0805949109298663-78.262359826249423IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000-115.89465262742715IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)000000000000000000000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)16.6704229357623573.1691470049996472E-27.1890492881915569E-20000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BY$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), CI$6, INDIRECT($C12&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), CS$6, INDIRECT($C12&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
934INDEX(Modules[Module], MATCH($C13, Modules[Code], 0))Commercial hot water [UNUSED - See IX.c]00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
936SUM(G12:G13)115.89465262742715SUM(H12:H13)000000SUM(N12:N13)0SUM(O12:O13)00115.89465262742715SUM(S12:S13)-28.55169789024786200-9.0805949109298663-78.262359826249423SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)0000SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-115.89465262742715SUM(AM12:AM13)000000000SUM(AV12:AV13)00000000SUM(BD12:BD13)000SUM(BH12:BH13)0SUM(BI12:BI13)000SUM(BO12:BO13)16.6704229357623573.1691470049996472E-27.1890492881915569E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11498.42483853439262000000000498.42483853439262S14+S11-59.5602444201363280-14.256803002247571-21.867624407791091-402.74016670421770000000AE14+AE11000AH14+AH11000-498.42483853439268AM14+AM11000000000AV14+AV1100000000BD14+BD11000BH14+BH110BI14+BI1100-5.6843418860808015E-14BO14+BO1183.9621921002160720.168246518873779060.2970222622971309100000000000000000000000000000000000000000SUM(BO15:DF15)84.427460881386978
00
938INDEX(Modules[Module], MATCH($C17, Modules[Code], 0))Domestic lighting, appliances, and cookingIFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)094.74050617584410400000000SUM(G17:P17)94.740506175844104IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-86.725000238056495000-8.0155059377876015IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-94.740506175844104IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM17:BE17)0IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0SUM(BH17:BI17)00IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), BO$6, INDIRECT($C17&".Emissions[IPCC Sector]"), BO$5),0)1.47485309255291842.9563219459007228E-33.1796679789373723E-30000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), BY$6, INDIRECT($C17&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), CI$6, INDIRECT($C17&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C17&".Emissions["&this.Year&"]"), INDIRECT($C17&".Emissions[GHG]"), CS$6, INDIRECT($C17&".Emissions[IPCC Sector]"), CS$5),0)000000000000001.4809890824777565
939INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering081.62029588380174500000000SUM(G18:P18)81.620295883801745-72.634879079699601000-8.98541680410214380000000000000SUM(S18:AJ18)-81.6202958838017450000000000000000000SUM(AM18:BE18)0IFERROR(INDEX(INDIRECT($C18&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C18&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C18&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C18&".Outputs[Vector]"), 0)), 0)0SUM(BH18:BI18)001.65331669195479413.3140496803579565E-33.5644215488280567E-3000000000000000000000000000000000000000001.66019516318398
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18176.3608020596458300000N17+N180O17+O1800SUM(G19:P19)176.36080205964583S17+S18-159.35987931775611T17+T18000-17.000922741889745X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-176.36080205964586AM17+AM18000000000AV17+AV1800000000BD17+BD1800SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)0-2.8421709430404007E-14BO17+BO183.12816978450771286.2703716262586789E-36.7440895277654286E-3000000000000000000000000000000000000000003.1411842456617372
00
888INDEX(Modules[Module], MATCH($C21, Modules[Code], 0))Industrial processesIFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)00408.608664558684270000000SUM(G21:P21)408.60866455868427IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-114.372335461572940-54.553269110073614-81.623034879123125-150.05297390894643IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)00-8.00705119896818300000000SUM(S21:AJ21)-408.60866455868427IFERROR(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)64.8179128049295910.130107832161782680.575510216507878480000014.395659255118630.112887442351524122.762469210590723810.6202961518875260000000000000000000000000000000093.414842913547659
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210408.608664558684270000000SUM(G22:P22)408.60866455868427S21-114.372335461572940-54.553269110073614-81.623034879123125-150.052973908946430000-8.00705119896818300AE21000AH21000SUM(S22:AJ22)-408.60866455868427AM21000000000AV2100000000BD2100SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)00BO2164.8179128049295910.130107832161782680.575510216507878480000014.395659255118630.112887442351524122.762469210590723810.6202961518875260000000000000000000000000000000093.414842913547659
00
891INDEX(Modules[Module], MATCH($C24, Modules[Code], 0))Domestic passenger transportIFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000403.1991822574203813.4415938479828169.01983460870955160000SUM(G24:P24)425.66061071411275IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-8.580392457134546900-417.080218256978240IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S24:AJ24)-425.66061071411281IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM24:BE24)0IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)00SUM(BH24:BI24)0-5.6843418860808015E-14IFERROR(SUMIFS(INDIRECT($C24&".Emissions["&this.Year&"]"), INDIRECT($C24&".Emissions[GHG]"), BO$6, INDIRECT($C24&".Emissions[IPCC Sector]"), BO$5),0)104.270054564244560.129815806300254881.87603194040277120000000IFERROR(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)00000000000000106.27590231094759
904INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight00087.6548675210587192.4108529550428361018.817339999999998000108.88306047610156-0.1012000000000000100-108.7818604761015600000000000000-108.8830604761015600000000000000000000000027.1954651190253893.3858246712257449E-20.489302143464076580000000000000000000000000000000000000000027.718625509201722
907INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000152.9916754147913300152.99167541479133000-152.9916754147913300000000000000-152.991675414791330000000000000000000000000000000000000000000000000000000038.2479188536978334.7618507979587513E-20.6881584336302427600000000038.983695795307661
942INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G26:G27)0SUM(H26:H27)000000SUM(N26:N27)152.99167541479133SUM(O26:O27)00152.99167541479133SUM(S26:S27)000-152.9916754147913300000000SUM(AE26:AE27)000SUM(AH26:AH27)000-152.99167541479133SUM(AM26:AM27)000000000SUM(AV26:AV27)00000000SUM(BD26:BD27)000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000038.2479188536978334.7618507979587513E-20.6881584336302427600000000038.983695795307661
945INDEX(Modules[Module], MATCH($C29, Modules[Code], 0))International shipping (maritime bunkers)IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000029.222291428230907029.222291428230907000-29.2222914282309070IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-29.222291428230907IFERROR(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)007.30557285705772679.0954093664530975E-30.13144222547937170000000007.4461104919035517
947INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
949SUM(G29:G30)0000000029.222291428230907029.222291428230907SUM(S29:S30)000-29.22229142823090700000000SUM(AE29:AE30)000SUM(AH29:AH30)000-29.222291428230907SUM(AM29:AM30)000000000SUM(AV29:AV30)00000000SUM(BD29:BD30)000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)000000000000000000000000000000007.30557285705772679.0954093664530975E-30.13144222547937170000000007.4461104919035517
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000490.8540497784790715.8524468030256529.019834608709551618.817339999999998152.9916754147913329.2222914282309070716.7576380332365S24+S25+S28+S31-8.681592457134547300-708.0760455761020500000000AE24+AE25+AE28+AE31000AH24+AH25+AH28+AH31000-716.75763803323662AM24+AM25+AM28+AM31000000000AV24+AV25+AV28+AV3100000000BD24+BD25+BD28+BD31000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI3100-1.1368683772161603E-13BO24+BO25+BO28+BO31131.465519683269950.163674053012512342.3653340838668480000000000000000000000000000045.5534917107555595.6713917346040608E-20.81960065910961444000000000180.42433410736052
00
918INDEX(Modules[Module], MATCH($C34, Modules[Code], 0))Food consumption [UNUSED]IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000SUM(G34:P34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000000000SUM(S34:AJ34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM34:BE34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0SUM(BH34:BI34)00IFERROR(SUMIFS(INDIRECT($C34&".Emissions["&this.Year&"]"), INDIRECT($C34&".Emissions[GHG]"), BO$6, INDIRECT($C34&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
680INDEX(Workstreams[Workstream], MATCH($C35, Workstreams[Code], 0))Food consumption [UNUSED]G340H34000000N340O3400SUM(G35:P35)0S340T340000X340Y340Z340000AD340AE3400AG340AH340AI3400SUM(S35:AJ35)0AM34000000000AV3400000000BD3400SUM(AM35:BE35)0BH340BI340SUM(BH35:BI35)00BO34000000000000000000000000000000000000000000000
00
950INDEX(Modules[Module], MATCH($C37, Modules[Code], 0))GeosequestrationIFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000SUM(G37:P37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000000000SUM(S37:AJ37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM37:BE37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0SUM(BH37:BI37)00IFERROR(SUMIFS(INDIRECT($C37&".Emissions["&this.Year&"]"), INDIRECT($C37&".Emissions[GHG]"), BO$6, INDIRECT($C37&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
675INDEX(Workstreams[Workstream], MATCH($C38, Workstreams[Code], 0))GeosequestrationG370000000000SUM(G38:P38)0S3700000X370Y370Z370000AD370AE3700AG370AH370AI3700SUM(S38:AJ38)0AM37000000000AV3700000000BD3700SUM(AM38:BE38)0BH370BI370SUM(BH38:BI38)00BO37000000000000000000000000000000000000000000000
SUM(AM39:BE39)00
1793619G$15+G$19+G$22+G$32+G$35+G$38498.42483853439262176.36080205964583408.60866455868427490.8540497784790715.8524468030256529.019834608709551618.817339999999998152.9916754147913329.22229142823090701800.1519431859592S$15+S$19+S$22+S$32+S$35+S$38-341.974051656599950-68.81007211232118-811.5667048630163-569.79406335505382X$15+X$19+X$22+X$32+X$35+X$380Y$15+Y$19+Y$22+Y$32+Y$35+Y$380Z$15+Z$19+Z$22+Z$32+Z$35+Z$3800-8.00705119896818300000000SUM(S40:AJ40)-1800.1519431859595AM$15+AM$19+AM$22+AM$32+AM$35+AM$38000000000AV$15+AV$19+AV$22+AV$32+AV$35+AV$380000000000SUM(AM40:BE40)0BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)0-2.2737367544323206E-13BO$15+BO$19+BO$22+BO$32+BO$35+BO$38283.373794372923330.468298775674332763.2446106521996230000014.395659255118630.112887442351524122.762469210590723810.6202961518875260000000000000000000045.5534917107555595.6713917346040608E-20.81960065910961444000000000SUM(BO40:DF40)361.40782214795689
0
720
0
19011902AJ$4000SUM(BO44:DF44)0
969INDEX(Modules[Module], MATCH($C45, Modules[Code], 0))H2 Production for TransportIFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0000000000SUM(G45:P45)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)00000000000SUM(S45:AJ45)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM45:BE45)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)0IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)00000000000000000000000000000000000000000000
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45000000000000AE45000AH45000SUM(S46:AJ46)0AM450000000000000000000SUM(AM46:BE46)0BH450BI450SUM(BH46:BI46)0Q46+AK46+BF46+BJ460BO4500000000000000000000000000000000000000000000SUM(BO46:DF46)0
Q47+AK47+BF47+BJ4700
2227INDEX(Modules[Module], MATCH($C48, Modules[Code], 0))Marine algaeIFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000000SUM(G48:P48)0IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S48:AJ48)0IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM48:BE48)0IFERROR(INDEX(INDIRECT($C48&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C48&".Outputs[Vector]"), 0)), 0)00SUM(BH48:BI48)0IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), BO$6, INDIRECT($C48&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), BY$6, INDIRECT($C48&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), CI$6, INDIRECT($C48&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C48&".Emissions["&this.Year&"]"), INDIRECT($C48&".Emissions[GHG]"), CS$6, INDIRECT($C48&".Emissions[IPCC Sector]"), CS$5),0)00000000000000SUM(BO48:DF48)0
953INDEX(Modules[Module], MATCH($C49, Modules[Code], 0))Waste arising0000000000SUM(G49:P49)00000026.003927322234723000000010.4807320393649233.988938333333333918.28319655126789600SUM(S49:AJ49)58.756794246200883000000000000000000-58.756794246200883SUM(AM49:BE49)-58.75679424620088300SUM(BH49:BI49)0000000000000000000000000021.6718667680392051.24929999999999990000000000000000022.921166768039207
912INDEX(Modules[Module], MATCH($C50, Modules[Code], 0))Agriculture and land useIFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)0010.432110000000SUM(G50:P50)10.43211IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.17284400000000040-0.8345688-3.4425962999999999-1.98210090000000010000000.822222222222222194.05929999999999952.50903882199999950.97210936666666681000SUM(S50:AJ50)-2.0694395891111128000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-4.8815222222222214-3.4811481886666664SUM(AM50:BE50)-8.362670410888888700SUM(BH50:BI50)0Q50+AK50+BF50+BJ50-1.7763568394002505E-151.48240283099999992.5576655538874478E-31.8548175243751668E-20000000000000020.02673259999999523.280-1.82479539999999910000000000000000000000042.985445871797637
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.432110000000SUM(G51:P51)10.43211SUM(S48:S50)-4.17284400000000040-0.8345688-3.4425962999999999-1.982100900000000126.003927322234723000000.82222222222222219SUM(AE48:AE50)4.059299999999999512.9897708613649234.9610477000000008SUM(AH48:AH50)18.28319655126789600SUM(S51:AJ51)56.68735465708977SUM(AM48:AM50)00000000000000000-4.8815222222222214-62.237942434867549SUM(AM51:BE51)-67.119464657089765SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ510SUM(BO48:BO50)1.48240283099999992.5576655538874478E-31.8548175243751668E-20000000000000020.02673259999999523.280-1.8247953999999991000021.6718667680392051.24929999999999990000000000000000065.906612639836851
Q52+AK52+BF52+BJ5200
959INDEX(Modules[Module], MATCH($C53, Modules[Code], 0))Petroleum refineriesIFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000000000SUM(G53:P53)0IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)-6.864816135126631900-56.266685142190759-2.5031151912581922IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)03.323191319488159900-0.8061419376226353100000000SUM(S53:AJ53)-63.117567086710061IFERROR(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)-3.3231913194880929IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)66.440758406198228SUM(BH53:BI53)63.117567086710132Q53+AK53+BF53+BJ537.1054273576010019E-14IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)14.5272444807391971.8436162606187682E-20.25408120011739060000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BY$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), CI$6, INDIRECT($C53&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), CS$6, INDIRECT($C53&".Emissions[IPCC Sector]"), CS$5),0)0000000000000014.799761843462775
977INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0065.9088969690386790000000SUM(G54:P54)65.908896969038679-1.54341221880345580-4.4692473051785787E-20-64.320792277183429124.39544583847987975.89120834979803838.809293214191710000000000SUM(S54:AJ54)1873.1870504334311-124.39544583847987-975.89120834979803-838.809293214191710000000000000000SUM(AM54:BE54)-1939.0959474024696IFERROR(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)011.8182817790017512.3689576922962512E-22.5479291685726012E-205.09168198602343042.64031296125177750000000000000000000000000000000000000019.599445594885644
957INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)065.9088969690386790000000SUM(G55:P55)65.908896969038679SUM(S53:S54)-8.40822835393008820-4.4692473051785787E-2-56.266685142190759-66.823907468441618SUM(X53:X54)124.39544583847987SUM(Y53:Y54)979.21439966928619SUM(Z53:Z54)838.809293214191710-0.806141937622635310SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)1810.069483346721SUM(AM53:AM54)-124.39544583847987-975.89120834979803-838.80929321419171000000SUM(AV53:AV54)00000000SUM(BD53:BD54)00SUM(AM55:BE55)-1939.0959474024696SUM(BH53:BH54)-3.3231913194880929SUM(BI53:BI54)66.440758406198228SUM(BH55:BI55)63.117567086710132Q55+AK55+BF55+BJ552.6290081223123707E-13SUM(BO53:BO54)26.345526259740954.2125739529150191E-20.279560491803116605.09168198602343042.64031296125177750000000000000000000000000000000000000034.399207438348427
Q56+AK56+BF56+BJ5600
1709INDEX(Modules[Module], MATCH($C57, Modules[Code], 0))Onshore windIFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000SUM(G57:P57)0IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)04.9858220412000005000IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S57:AJ57)4.9858220412000005IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00000000000-4.98582204120000050000000SUM(AM57:BE57)-4.9858220412000005IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00SUM(BH57:BI57)00IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), BO$6, INDIRECT($C57&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), BY$6, INDIRECT($C57&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), CI$6, INDIRECT($C57&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C57&".Emissions["&this.Year&"]"), INDIRECT($C57&".Emissions[GHG]"), CS$6, INDIRECT($C57&".Emissions[IPCC Sector]"), CS$5),0)000000000000000
1710INDEX(Modules[Module], MATCH($C58, Modules[Code], 0))Offshore wind0000000000SUM(G58:P58)000.976930376399999910000000000000000SUM(S58:AJ58)0.9769303763999999100000000000-0.976930376399999910000000SUM(AM58:BE58)-0.9769303763999999100SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
799INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric0000000000004.114400994000000400000000000000004.1144009940000004000000000000000-4.1144009940000004000-4.11440099400000040000000000000000000000000000000000000000000000000
804INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Wave and Tidal000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
805INDEX(Modules[Module], MATCH($C61, Modules[Code], 0))Geothermal000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
806INDEX(Modules[Module], MATCH($C62, Modules[Code], 0))Tidal [UNUSED - See III.c]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
76INDEX(Workstreams[Workstream], MATCH($C63, Workstreams[Code], 0))National renewable power generationSUM(G57:G62)00000000000SUM(S57:S62)010.0771534116000010000000000SUM(AE57:AE62)000SUM(AH57:AH62)00010.077153411600001SUM(AM57:AM62)00000000000-5.9627524176000009000-4.1144009940000004000-10.077153411600001SUM(BH57:BH62)0SUM(BI57:BI62)000SUM(BO57:BO62)000000000000000000000000000000000000000000000
0
964INDEX(Modules[Module], MATCH($C65, Modules[Code], 0))Distributed solar PVIFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000SUM(G65:P65)0IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)01.700604E-2000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)1.700604E-2IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-1.700604E-200000000SUM(AM65:BE65)-1.700604E-2IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)00SUM(BH65:BI65)0Q65+AK65+BF65+BJ650IFERROR(SUMIFS(INDIRECT($C65&".Emissions["&this.Year&"]"), INDIRECT($C65&".Emissions[GHG]"), BO$6, INDIRECT($C65&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
1317INDEX(Modules[Module], MATCH($C66, Modules[Code], 0))Distributed solar thermal0000000000SUM(G66:P66)0000000000000000000SUM(S66:AJ66)00000000000000000000SUM(AM66:BE66)000SUM(BH66:BI66)00000000000000000000000000000000000000000000000
1582INDEX(Modules[Module], MATCH($C67, Modules[Code], 0))Micro wind0000000000SUM(G67:P67)0000000000000000000SUM(S67:AJ67)00000000000000000000SUM(AM67:BE67)000SUM(BH67:BI67)00000000000000000000000000000000000000000000000
77INDEX(Workstreams[Workstream], MATCH($C68, Workstreams[Code], 0))Distributed renewable power generationSUM(G65:G67)0SUM(H65:H67)000000000SUM(G68:P68)0SUM(S65:S67)01.700604E-20000000000SUM(AE65:AE67)000SUM(AH65:AH67)000SUM(S68:AJ68)1.700604E-2SUM(AM65:AM67)0000000000-1.700604E-200000000SUM(AM68:BE68)-1.700604E-2SUM(BH65:BH67)0SUM(BI65:BI67)0SUM(BH68:BI68)00SUM(BO65:BO67)0SUM(BP65:BP67)00000000000000000000000000000000000000000000
00
16971328AB$40+AB$46+AB$51+AB$99+AB$55+AB$63+AB$68-8.8131931365908187SUM(BH70:BI70)000
1326INDEX(Modules[Module], MATCH($C71, Modules[Code], 0))District heating effective demandIFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0000000000SUM(G71:P71)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0-1.2590275909415456000IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)008.813193136590818700000000SUM(S71:AJ71)7.5541655456492727IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM71:BE71)0IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)-7.5541655456492727IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-7.5541655456492727Q71+AK71+BF71+BJ710IFERROR(SUMIFS(INDIRECT($C71&".Emissions["&this.Year&"]"), INDIRECT($C71&".Emissions[GHG]"), BO$6, INDIRECT($C71&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
1324INDEX(Workstreams[Workstream], MATCH($C72, Workstreams[Code], 0))District heatingG710H71000000000SUM(G72:P72)0S710-1.259027590941545600000008.81319313659081870AD710AE71000AH710AI7100SUM(S72:AJ72)7.5541655456492727AM710AN71000000000000000000SUM(AM72:BE72)0BH71-7.5541655456492727BI710SUM(BH72:BI72)-7.5541655456492727Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16981322S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-354.55512401053005T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$72-12.534825528977441SUM(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)057.469895999999999000IFERROR(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)57.469895999999999IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-163.91620313701554000000000SUM(AM75:BE75)-163.91620313701554IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)100.64454872612754IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)5.8017584108879987SUM(BH75:BI75)106.446307137015540IFERROR(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)0S75057.4698959999999990000000000AE75000AH75000SUM(S76:AJ76)57.469895999999999AM75000000000-163.91620313701554000000000SUM(AM76:BE76)-163.91620313701554BH75100.64454872612754BI755.8017584108879987SUM(BH76:BI76)106.446307137015540BO75000000000000000000000000000000000000000000000
00
16991322S$74+S$76-354.55512401053005T$74+T$7644.93507047102255600
869INDEX(Modules[Module], MATCH($C79, Modules[Code], 0))Carbon Capture Storage (CCS)IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0000000000SUM(G79:P79)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)00000000000SUM(S79:AJ79)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM79:BE79)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)0SUM(BH79:BI79)00IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
17001322S78+S79-354.55512401053005T78+T7944.93507047102255600
740INDEX(Modules[Module], MATCH($C81, Modules[Code], 0))Biomass/Coal powerIFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0000000000SUM(G81:P81)0IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)0309.62005353950747-419.47834613566562-9.4791098187266236-344.72453755557569IFERROR(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)-464.06193997046046IFERROR(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)452.75116987470909IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)11.310770095751497SUM(BH81:BI81)464.06193997046057Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)194.998422974692570.509634462573162811.323899803241170200000000000000000000000000000000000000000196.83195724050691
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810309.62005353950747-419.47834613566562-9.4791098187266236-344.72453755557569000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-464.06193997046046AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81452.75116987470909BI79+BI8111.310770095751497SUM(BH82:BI82)464.061939970460570BO79+BO81194.998422974692570.509634462573162811.323899803241170200000000000000000000000000000000000000000196.83195724050691
SUM(AM83:BE83)00
1794249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$460076.3410069690386730000000SUM(G84:P84)76.341006969038673S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-12.581072353930089375.92508140016594-420.3576074087174-69.188391260917385-413.5305459240173150.39937316071459979.21439966928619838.8092932141917108.00705119896818300.822222222222222194.059299999999999512.9897708613649234.961047700000000818.28319655126789600SUM(S84:AJ84)1477.8131190305994AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-124.39544583847987-975.89120834979803-838.80929321419171000000-163.91620313701554-1.700604E-2-5.9627524176000009000-4.11440099400000040-4.8815222222222214-62.237942434867549SUM(AM84:BE84)-2180.2257746481746BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46542.51836173569927BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4683.55328691283772SUM(BH84:BI84)626.071648648537010BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46222.826352065433530.554317867656200391.622008470288038405.09168198602343042.64031296125177750000000000020.02673259999999523.280-1.8247953999999991000021.6718667680392051.24929999999999990000000000000000DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)297.1377773186922
0
9750
0
|
772INDEX(Modules[Module], MATCH($C89, Modules[Code], 0))Electricity imports / exportsIFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(G89:P89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)05.2145242500000002000IFERROR(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)5.2145242500000002IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000-5.21452425000000020000IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM89:BE89)-5.2145242500000002IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0SUM(BH89:BI89)0Q89+AK89+BF89+BJ890IFERROR(SUMIFS(INDIRECT($C89&".Emissions["&this.Year&"]"), INDIRECT($C89&".Emissions[GHG]"), BO$6, INDIRECT($C89&".Emissions[IPCC Sector]"), BO$5),0)00000000000000000000000000000000000000000000
17011323S$40+$S46+S$51+S$99+S$55+S$89-354.55512401053005T$40+$S46+T$51+T$99+T$55+T$895.21452425000000020
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-26.584481639635896000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-26.584481639635896IFERROR(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)26.584481639635886SUM(BH91:BI91)26.5844816396358860IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BO$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BY$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CI$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CS$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
792INDEX(Modules[Module], MATCH($C92, Modules[Code], 0))Storage, demand shifting, backup0000000000SUM(G92:P92)0000000000000000000SUM(S92:AJ92)00000000000000000000SUM(AM92:BE92)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0SUM(BH92:BI92)0000000000000000000000000000000000000000000000
673INDEX(Workstreams[Workstream], MATCH($C93, Workstreams[Code], 0))Electricity distribution, storage, and balancingG$89+G$91+G$920000000000SUM(G93:P93)0S$89+S$91+S$920-21.369957389635896000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-21.369957389635896AM$89+AM$91+AM$920000-5.21452425000000020000AV$89+AV$91+AV$920000000000SUM(AM93:BE93)-5.2145242500000002BH$89+BH$91+BH$920BI$89+BI$91+BI$9226.584481639635886SUM(BH93:BI93)26.5844816396358860BO$89+BO$91+BO$9200000000000000000000000000000000000000000000SUM(BO93:DF93)0
00
17021650(U$40+U$84+U$93)-489.16767952103856(V$40+V$84+V$93)-880.75509612393364(W$40+W$84+W$93)-983.32460927907118(AC$40+AC$84+AC$93)00.822222222222222194.059299999999999512.9897708613649234.961047700000000818.283196551267896BE40+BE46+BE51-62.237942434867549SUM(AM95:BE95)-62.2379424348675490
951INDEX(Modules[Module], MATCH($C96, Modules[Code], 0))Biomass to fuel conversionIFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0000000000SUM(G96:P96)0IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0011.690793775228431.56260522222222222.003982326267895000000-0.82222222222222219-4.0592999999999995-12.989770861364923-4.9610477000000008-18.28319655126789600SUM(S96:AJ96)-5.8581560111364972IFERROR(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)5.8581560111364936IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)5.8581560111364936Q96+AK96+BF96+BJ960IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-8.04014853635920450000000-8.0401485363592045
17031650U$95+U$96-477.47688574581014V$95+V$96-879.19249090171138W$95+W$96-961.32062695280331AC$95+AC$96000000BE42+BE49+BE53-58.756794246200883SUM(AM97:BE97)-58.756794246200883SUM(BO97:DF97)0
1674INDEX(Modules[Module], MATCH($C98, Modules[Code], 0))Bioenergy importsIFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0000000000SUM(G98:P98)0IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)004.3961399999999999-0.3954199999999999900000000000000SUM(S98:AJ98)4.0007200000000003IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-4.0007200000000003000000000000000SUM(AM98:BE98)-4.0007200000000003IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)0SUM(BH98:BI98)0Q98+AK98+BF98+BJ980IFERROR(SUMIFS(INDIRECT($C98&".Emissions["&this.Year&"]"), INDIRECT($C98&".Emissions[GHG]"), BO$6, INDIRECT($C98&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-1.25515611999999990000000SUM(BO98:DF98)-1.2551561199999999
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S980016.0869337752284311.167185222222221922.003982326267895000000AD$96+AD98-0.82222222222222219AE$96+AE98-4.0592999999999995-12.989770861364923-4.9610477000000008AH$96+AH98-18.28319655126789600SUM(S99:AJ99)-1.857436011136496AM$96+AM98000-4.0007200000000003000000000000000SUM(AM99:BE99)-4.0007200000000003BH$96+BH985.8581560111364936BI$96+BI980SUM(BH99:BI99)5.8581560111364936Q99+AK99+BF99+BJ990BO$96+BO98000000000000000000000000000000000000-9.2953046563592050000000-9.295304656359205
0
17041650(S$40+S$84+S$93+S$99)-354.55512401053005(T$40+T$84+T$93+T$99)354.55512401053005(U$40+U$84+U$93+U$99)-473.08074574581013(V$40+V$84+V$93+V$99)-879.58791090171144(W$40+W$84+W$93+W$99)-961.320626952803310
1001INDEX(Modules[Module], MATCH($C102, Modules[Code], 0))Fossil fuel transfersIFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0000000000SUM(G102:P102)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)00473.08074574581013879.58791090171144961.32062695280331-473.08074574581013-879.58791090171144-972.400193531486370000000000SUM(S102:AJ102)-11.079566578682943IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM102:BE102)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C102&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C102&".Outputs[Vector]"), 0)), 0)11.079566578683007SUM(BH102:BI102)11.079566578683007Q102+AK102+BF102+BJ1026.3948846218409017E-14IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000004.37065136408846390000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BY$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), CI$6, INDIRECT($C102&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), CS$6, INDIRECT($C102&".Emissions[IPCC Sector]"), CS$5),0)000000000000004.3706513640884639
7941002INDEX(Modules[Module], MATCH($C103, Modules[Code], 0))Balancing importsSUM(G103:P103)0-(T$101+S$101)0-(X$40+X$84+X$93+X$99+X$102)322.68137258509557-(Y$40+Y$84+Y$93+Y$99+Y$102)-99.626488767574756-(Z$40+Z$84+Z$93+Z$99+Z$102)133.59090031729465SUM(S103:AJ103)356.64578413481547-T1030-V1030-X103-322.68137258509557-Y10399.626488767574756-Z103-133.59090031729465SUM(AM103:BE103)-356.64578413481547SUM(BH103:BI103)00000000000000000000000000000000000000000000000
7941000INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0000000000SUM(G104:P104)0SUM(S102:S103)00473.08074574581013879.58791090171144961.32062695280331-150.39937316071456-979.21439966928619-838.809293214191710000SUM(AE102:AE103)000SUM(AH102:AH103)000SUM(S104:AJ104)345.56621755613241SUM(AM102:AM103)000000-322.6813725850955799.626488767574756-133.590900317294650000000000SUM(AM104:BE104)-356.64578413481547SUM(BH102:BH103)0SUM(BI102:BI103)11.079566578683007SUM(BH104:BI104)11.079566578683007-4.9737991503207013E-14SUM(BO102:BO103)000004.3706513640884639000000000000000000000000000000000000004.3706513640884639
0
17951004G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-21.369957389635896489.16767952103856880.75509612393364983.32460927907118-150.39937316071456-979.21439966928619-838.80929321419171000-0.82222222222222219-4.0592999999999995-12.989770861364923-4.9610477000000008-18.28319655126789600SUM(S106:AJ106)322.33882415535993AM$93+AM$99+AM$104000-4.0007200000000003-5.21452425000000020-322.6813725850955799.626488767574756-133.590900317294650000000000SUM(AM106:BE106)-365.86102838481548BH$93+BH$99+BH$1045.8581560111364936BI$93+BI$99+BI$10437.664048218318896SUM(BH106:BI106)43.52220422945539-1.6342482922482304E-13BO$93+BO$99+BO$104000004.3706513640884639000000000000000000000000000000-9.295304656359205000000DF$93+DF$1040SUM(BO106:DF106)-4.9246532922707411
0
0
593G$40+G$84+G$106498.42483853439262176.36080205964583484.94967152772296490.8540497784790715.8524468030256529.019834608709551618.817339999999998152.9916754147913329.2222914282309070SUM(G109:P109)1876.492950154998S$40+S$84+S$106-354.55512401053005354.555124010530050000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-124.39544583847987-975.89120834979803-838.80929321419171-4.0007200000000003-5.21452425000000020-322.6813725850955799.626488767574756-133.59090031729465-163.91620313701554-1.700604E-2-5.9627524176000009000-4.11440099400000040-4.8815222222222214-62.237942434867549SUM(AM109:BE109)-2546.0868030329902BH$40+BH$84+BH$106548.37651774683582BI$40+BI$84+BI$106121.21733513115662SUM(BH109:BI109)669.593852877992390BO$40+BO$84+BO$106506.200146438356851.0226166433305334.866619122487660905.09168198602343047.01096432534024140014.395659255118630.112887442351524122.762469210590723810.6202961518875260000020.02673259999999523.280-1.8247953999999991000021.6718667680392051.24929999999999990000045.5534917107555595.6713917346040608E-20.819600659109614440-9.2953046563592050000000SUM(BO109:DF109)653.62094617437833
|
|
2352SUM(DH63,DH68,DH76,DH82)196.83195724050691
79410052353T109-MIN(T103,0)-T72355.81415160147162
2354DH112/DH1130.5531875456740345
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D