|
2015
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)424.18249375469532IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(H$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)000000000SUM(G9:P9)424.18249375469532IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)-36.3558175963721690-10.751675360666219-9.6432552203913531-367.43174557726559IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S9:AJ9)-424.18249375469532IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM9:BE9)0IFERROR(INDEX(INDIRECT($C9&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C9&".Outputs[Vector]"), 0)), 0)00SUM(BH9:BI9)0Q9+AK9+BF9+BJ90IFERROR(SUMIFS(INDIRECT($C9&".Emissions["&this.Year&"]"), INDIRECT($C9&".Emissions[GHG]"), BO$6, INDIRECT($C9&".Emissions[IPCC Sector]"), BO$5),0)73.3297710023998950.148247640641786640.218466947764238580000000IFERROR(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)424.18249375469532SUM(H9:H10)000000000424.18249375469532SUM(S9:S10)-36.355817596372169SUM(T9:T10)0-10.751675360666219-9.6432552203913531-367.43174557726559SUM(X9:X10)0SUM(Y9:Y10)0SUM(Z9:Z10)0000SUM(AD9:AD10)0SUM(AE9:AE10)00SUM(AG9:AG10)0SUM(AH9:AH10)0SUM(AI9:AI10)00-424.18249375469532SUM(AM9:AM10)00000000000000000000SUM(BH9:BH10)0SUM(BI9:BI10)000SUM(BO9:BO10)73.3297710023998950.148247640641786640.2184669477642385800000000000000000000000000000000000000000
933INDEX(Modules[Module], MATCH($C12, Modules[Code], 0))Commercial heating and cooling129.92787034452689000000000129.92787034452689-35.1694648501225800-9.3601915660227526-85.398213928381523IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)0000000000000-129.92787034452687IFERROR(INDEX(INDIRECT($C12&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C12&".Outputs[Vector]"), 0)), 0)000000000000000000000002.8421709430404007E-14IFERROR(SUMIFS(INDIRECT($C12&".Emissions["&this.Year&"]"), INDIRECT($C12&".Emissions[GHG]"), BO$6, INDIRECT($C12&".Emissions[IPCC Sector]"), BO$5),0)18.0533192543278853.4410378264801728E-27.5978841297249272E-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)129.92787034452689SUM(H12:H13)000000000129.92787034452689SUM(S12:S13)-35.1694648501225800-9.3601915660227526-85.398213928381523SUM(X12:X13)0SUM(Y12:Y13)0SUM(Z12:Z13)0000SUM(AD12:AD13)0SUM(AE12:AE13)00SUM(AG12:AG13)0SUM(AH12:AH13)0SUM(AI12:AI13)00-129.92787034452687SUM(AM12:AM13)0000000SUM(AT12:AT13)0000000000000SUM(BH12:BH13)0SUM(BI12:BI13)002.8421709430404007E-14SUM(BO12:BO13)18.0533192543278853.4410378264801728E-27.5978841297249272E-200000000000000000000000000000000000000000
676INDEX(Workstreams[Workstream], MATCH($C15, Workstreams[Code], 0))HeatingG14+G11554.11036409922224000000000554.11036409922224S14+S11-71.5252824464947420-10.751675360666219-19.003446786414106-452.82995950564714000AA14+AA11000AD14+AD110AE14+AE1100AG14+AG110AH14+AH110AI14+AI1100-554.11036409922224AM14+AM110000000AT14+AT110000000000000BH14+BH110BI14+BI11000BO14+BO1191.3830902567277830.182658018906588370.2944457890614878800000000000000000000000000000000000000000SUM(BO15:DF15)91.860194064695861
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)097.49406703210152600000000SUM(G17:P17)97.494067032101526IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)-89.4785198583305000-8.0155471737710187IFERROR(INDEX(INDIRECT($C17&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C17&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S17:AJ17)-97.494067032101526IFERROR(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.47486067997386732.9563371547775778E-33.1796843368238326E-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.4809967014654688
939INDEX(Modules[Module], MATCH($C18, Modules[Code], 0))Commercial lighting, appliances, and catering084.15345336146985700000000SUM(G18:P18)84.153453361469857-75.158187531929585000-8.99526582954027810000000000000SUM(S18:AJ18)-84.1534533614698570000000000000000000SUM(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.6551289126354113.3176822508125831E-33.568328554954986E-3000000000000000000000000000000000000000001.6620149234411785
677INDEX(Workstreams[Workstream], MATCH($C19, Workstreams[Code], 0))Lighting and appliancesG17+G180H17+H18181.6475203935713700000000SUM(G19:P19)181.64752039357137S17+S18-164.63670739026009T17+T18000-17.010813003311299X17+X180Y17+Y180Z17+Z180000AD17+AD180AE17+AE1800AG17+AG180AH17+AH180AI17+AI1800SUM(S19:AJ19)-181.64752039357137AM17+AM180000000000000000000SUM(AM19:BE19)0BH17+BH180BI17+BI180SUM(BH19:BI19)00BO17+BO183.12998959260927826.2740194055901609E-36.7480128917788186E-3000000000000000000000000000000000000000003.1430116249066473
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)00415.846035988053070000000SUM(G21:P21)415.84603598805307IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)-116.398124791992030-55.519529264302946-83.068761002553643-152.71074698244044IFERROR(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.148873946764034300000000SUM(S21:AJ21)-415.84603598805307IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM21:BE21)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C21&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C21&".Outputs[Vector]"), 0)), 0)0SUM(BH21:BI21)00IFERROR(SUMIFS(INDIRECT($C21&".Emissions["&this.Year&"]"), INDIRECT($C21&".Emissions[GHG]"), BO$6, INDIRECT($C21&".Emissions[IPCC Sector]"), BO$5),0)65.965982708812760.132412332259062320.585703786932437630000014.4036879919609010.112122160576156142.76188359003191639.27409598505177610000000000000000000000000000000093.23588855562501
678INDEX(Workstreams[Workstream], MATCH($C22, Workstreams[Code], 0))IndustryG210H210415.846035988053070000000SUM(G22:P22)415.84603598805307S21-116.398124791992030-55.519529264302946-83.068761002553643-152.71074698244044000AA210-8.14887394676403430AD210AE2100AG210AH210AI2100SUM(S22:AJ22)-415.84603598805307AM210000000000000000000SUM(AM22:BE22)0BH210BI210SUM(BH22:BI22)00BO2165.965982708812760.132412332259062320.585703786932437630000014.4036879919609010.112122160576156142.76188359003191639.27409598505177610000000000000000000000000000000093.23588855562501
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)000345.0829350887767114.60033135556526110.1637164230892920000SUM(G24:P24)369.84698286743128IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)-8.135991134987593300-361.686831062696970IFERROR(INDEX(INDIRECT($C24&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C24&".Outputs[Vector]"), 0)), 0)000000000000-2.4160669746738729E-2SUM(S24:AJ24)-369.84698286743128IFERROR(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)90.4217077656742420.112574669205862081.62687180497879690000000IFERROR(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)0000000000000092.161154239858888
904INDEX(Modules[Module], MATCH($C25, Modules[Code], 0))Domestic freight000100.033472643575012.5831174845651748025.383064556311584000SUM(G25:P25)127.99965468445177-0.1084624596826620100-127.891192224769100000000000000-127.99965468445176000000000000000000000001.4210854715202004E-1431.9727980561922753.9806007359308546E-20.575256152191876650000000000000000000000000000000000000000032.587860215743461
907INDEX(Modules[Module], MATCH($C26, Modules[Code], 0))International aviation0000000174.0209706988312900SUM(G26:P26)174.02097069883129000-174.0209706988312900000000000000-174.020970698831290000000000000000000000000000000000000000000000000000000043.5052426747078235.4163855382138699E-20.782748461903203800000000044.342154991993162
942INDEX(Modules[Module], MATCH($C27, Modules[Code], 0))Domestic aviation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
948SUM(G26:G27)0SUM(H26:H27)000000174.0209706988312900174.02097069883129SUM(S26:S27)000-174.020970698831290000SUM(AA26:AA27)000SUM(AD26:AD27)0SUM(AE26:AE27)00SUM(AG26:AG27)0SUM(AH26:AH27)0SUM(AI26:AI27)00-174.02097069883129SUM(AM26:AM27)00000000000000000000SUM(BH26:BH27)0SUM(BI26:BI27)000SUM(BO26:BO27)0000000000000000000000000000000043.5052426747078235.4163855382138699E-20.782748461903203800000000044.342154991993162
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)0000000041.824074726648497041.824074726648497000-41.8240747266484970IFERROR(INDEX(INDIRECT($C29&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C29&".Outputs[Vector]"), 0)), 0)0000000000000-41.824074726648497IFERROR(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)0010.4560186816621241.3017701980909393E-20.1881252014130308200000000010.657161585056064
947INDEX(Modules[Module], MATCH($C30, Modules[Code], 0))National navigation [UNUSED - see XII.a]000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
949SUM(G29:G30)0SUM(H29:H30)000000041.824074726648497041.824074726648497SUM(S29:S30)000-41.8240747266484970000SUM(AA29:AA30)000SUM(AD29:AD30)0SUM(AE29:AE30)00SUM(AG29:AG30)0SUM(AH29:AH30)0SUM(AI29:AI30)00-41.824074726648497SUM(AM29:AM30)00000000000000000000SUM(BH29:BH30)0SUM(BI29:BI30)000SUM(BO29:BO30)0000000000000000000000000000000010.4560186816621241.3017701980909393E-20.1881252014130308200000000010.657161585056064
679INDEX(Workstreams[Workstream], MATCH($C32, Workstreams[Code], 0))TransportG24+G25+G28+G31000445.1164077323517217.18344884013043510.16371642308929225.383064556311584174.0209706988312941.8240747266484970713.6916829773628S24+S25+S28+S31-8.244453594670256200-705.423068712945910000AA24+AA25+AA28+AA31000AD24+AD25+AD28+AD310AE24+AE25+AE28+AE3100AG24+AG25+AG28+AG310AH24+AH25+AH28+AH310AI24+AI25+AI28+AI310-2.4160669746738729E-2-713.69168297736292AM24+AM25+AM28+AM310000000AT24+AT25+AT28+AT310000000000000BH24+BH25+BH28+BH310BI24+BI25+BI28+BI3100-1.1368683772161603E-13BO24+BO25+BO28+BO31122.394505821866520.152380676565170632.20212795717067330000000000000000000000000000053.9612613563699456.7181557363048094E-20.97087366331623459000000000179.74833103265161
00
918INDEX(Modules[Module], MATCH($C34, Modules[Code], 0))Food consumption [UNUSED]IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000SUM(G34:P34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)00000000000SUM(S34:AJ34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM34:BE34)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C34&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C34&".Outputs[Vector]"), 0)), 0)0SUM(BH34:BI34)00IFERROR(SUMIFS(INDIRECT($C34&".Emissions["&this.Year&"]"), INDIRECT($C34&".Emissions[GHG]"), BO$6, INDIRECT($C34&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
680INDEX(Workstreams[Workstream], MATCH($C35, Workstreams[Code], 0))Food consumption [UNUSED]G340H34000000000SUM(G35:P35)0S340T340000X340Y340Z340000AD340AE3400AG340AH340AI3400SUM(S35:AJ35)0AM340000000000000000000SUM(AM35:BE35)0BH340BI340SUM(BH35:BI35)00BO34000000000000000000000000000000000000000000000
00
950INDEX(Modules[Module], MATCH($C37, Modules[Code], 0))GeosequestrationIFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000SUM(G37:P37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)00000000000SUM(S37:AJ37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0000000000000000000SUM(AM37:BE37)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C37&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C37&".Outputs[Vector]"), 0)), 0)0SUM(BH37:BI37)00IFERROR(SUMIFS(INDIRECT($C37&".Emissions["&this.Year&"]"), INDIRECT($C37&".Emissions[GHG]"), BO$6, INDIRECT($C37&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000000000000
675INDEX(Workstreams[Workstream], MATCH($C38, Workstreams[Code], 0))GeosequestrationG370H37000000000SUM(G38:P38)0S3700000X370Y370Z370000AD370AE3700AG370AH370AI3700SUM(S38:AJ38)0AM370000000AT37000000000000SUM(AM38:BE38)0BH370BI370SUM(BH38:BI38)00BO37000000000000000000000000000000000000000000000
SUM(AM39:BE39)00
1793619G$15+G$19+G$22+G$32+G$35+G$38554.11036409922224181.64752039357137415.84603598805307445.1164077323517217.18344884013043510.16371642308929225.383064556311584174.0209706988312941.82407472664849701865.2956034582094S$15+S$19+S$22+S$32+S$35+S$38-360.804568223417110-66.271204624969158-807.49527650191362-622.55151949139884X$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.14887394676403430000000-2.4160669746738729E-2SUM(S40:AJ40)-1865.2956034582094AM$15+AM$19+AM$22+AM$32+AM$35+AM$380000000000000000000SUM(AM40:BE40)0BH$15+BH$19+BH$22+BH$32+BH$35+BH$380BI$15+BI$19+BI$22+BI$32+BI$35+BI$380SUM(BH40:BI40)00BO$15+BO$19+BO$22+BO$32+BO$35+BO$38282.873568380016310.47372504713641153.08902554605637780000014.4036879919609010.112122160576156142.76188359003191639.27409598505177610000000000000000000053.9612613563699456.7181557363048094E-20.97087366331623459000000000SUM(BO40:DF40)367.98742527787908
0
720
0
19011902AJ$40-2.4160669746738729E-20SUM(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)-4.0701435957967548E-3000-3.0416388256654117E-2IFERROR(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)00000000002.4160669746738729E-2SUM(S45:AJ45)-1.0325862105712146E-2IFERROR(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)1.0325862105712146E-2IFERROR(INDEX(INDIRECT($C45&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C45&".Outputs[Vector]"), 0)), 0)0SUM(BH45:BI45)1.0325862105712146E-2IFERROR(SUMIFS(INDIRECT($C45&".Emissions["&this.Year&"]"), INDIRECT($C45&".Emissions[GHG]"), BO$6, INDIRECT($C45&".Emissions[IPCC Sector]"), BO$5),0)5.5966154392243566E-31.1218335662914252E-51.2065865402041525E-500000000000000000000000000000000000000000SUM(BO45:DF45)5.6198996402893123E-3
674INDEX(Workstreams[Workstream], MATCH($C46, Workstreams[Code], 0))H2 ProductionG450H45000000000SUM(G46:P46)0S45-4.0701435957967548E-3000-3.0416388256654117E-2000000AD450AE4500AG450AH450AI4502.4160669746738729E-2SUM(S46:AJ46)-1.0325862105712146E-2AM450AN45000000000000000000SUM(AM46:BE46)0BH451.0325862105712146E-2BI450SUM(BH46:BI46)1.0325862105712146E-2Q46+AK46+BF46+BJ460BO455.5966154392243566E-31.1218335662914252E-51.2065865402041525E-500000000000000000000000000000000000000000SUM(BO46:DF46)5.6198996402893123E-3
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)00000052.991703495171834000000022.5204889330055774.209484040384761118.09047322124454400SUM(S49:AJ49)97.812149689806716000000000000000000-97.812149689806731SUM(AM49:BE49)-97.81214968980673100SUM(BH49:BI49)0000000000000000000000000021.4992911717090961.31837295345152760000000000000000022.817664125160626
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.7140169595675020000000SUM(G50:P50)10.714016959567502IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)-4.28560678382700110-0.85712135676540013-3.5356255966572756-2.03566322231782550000003.77465074763744560.918194490839583824.313274539333332510.297803168268684000SUM(S50:AJ50)8.5899059865115426000000000IFERROR(INDEX(INDIRECT($C50&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C50&".Outputs[Vector]"), 0)), 0)00000000-4.6928452384770294-14.611077707602018SUM(AM50:BE50)-19.30392294607904800SUM(BH50:BI50)0Q50+AK50+BF50+BJ50-3.5527136788005009E-151.52246180995454192.626781362663136E-31.9049402674107679E-20000000000000019.31873682079691422.11559163272466905.93354498809666710000000000000000000000048.912011435609571
672INDEX(Workstreams[Workstream], MATCH($C51, Workstreams[Code], 0))Agriculture and wasteSUM(G48:G50)0SUM(H48:H50)010.7140169595675020000000SUM(G51:P51)10.714016959567502SUM(S48:S50)-4.28560678382700110-0.85712135676540013-3.5356255966572756-2.035663222317825552.991703495171834000003.7746507476374456SUM(AE48:AE50)0.9181944908395838226.83376347233890914.507287208653445SUM(AH48:AH50)18.09047322124454400SUM(S51:AJ51)106.40205567631824SUM(AM48:AM50)00000000000000000-4.6928452384770294-112.42322739740875SUM(AM51:BE51)-117.11607263588579SUM(BH48:BH50)0SUM(BI48:BI50)0SUM(BH51:BI51)0Q51+AK51+BF51+BJ51-4.2632564145606011E-14SUM(BO48:BO50)1.52246180995454192.626781362663136E-31.9049402674107679E-20000000000000019.31873682079691422.11559163272466905.9335449880966671000021.4992911717090961.31837295345152760000000000000000071.729675560770204
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.165940163591878700-50.538427681284524-2.2482843222706577IFERROR(INDEX(INDIRECT($C53&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C53&".Outputs[Vector]"), 0)), 0)0000-0.724072262519744100000000SUM(S53:AJ53)-59.676724429666798IFERROR(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)59.676724429666798SUM(BH53:BI53)59.676724429666798Q53+AK53+BF53+BJ530IFERROR(SUMIFS(INDIRECT($C53&".Emissions["&this.Year&"]"), INDIRECT($C53&".Emissions[GHG]"), BO$6, INDIRECT($C53&".Emissions[IPCC Sector]"), BO$5),0)13.0482912356189311.6559260035288102E-20.228214338997521420000000IFERROR(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)0000000000000013.293064834651741
977INDEX(Modules[Module], MATCH($C54, Modules[Code], 0))Indigenous fossil-fuel production0045.2367424890932030000000SUM(G54:P54)45.236742489093203-1.36461431073228320-4.4692473051785787E-20-43.827435705309135124.39544583847987664.52033513004915508.983552519651540000000000SUM(S54:AJ54)1252.6625909990873-124.39544583847987-664.52033513004915-508.983552519651540000000000000000SUM(AM54:BE54)-1297.8993334881807IFERROR(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)08.04750416977687881.6131107096000703E-21.7349789920236686E-203.4671141524569762.64031296125177750000000000000000000000000000000000000014.188412180501871
957INDEX(Workstreams[Workstream], MATCH($C55, Workstreams[Code], 0))Fossil fuel productionSUM(G53:G54)0SUM(H53:H54)045.2367424890932030000000SUM(G55:P55)45.236742489093203SUM(S53:S54)-7.53055447432416170-4.4692473051785787E-2-50.538427681284524-46.075720027579791SUM(X53:X54)124.39544583847987SUM(Y53:Y54)664.52033513004915SUM(Z53:Z54)508.983552519651540-0.72407226251974410SUM(AD53:AD54)0SUM(AE53:AE54)00SUM(AG53:AG54)0SUM(AH53:AH54)0SUM(AI53:AI54)00SUM(S55:AJ55)1192.9858665694205SUM(AM53:AM54)-124.39544583847987-664.52033513004915-508.983552519651540000000000000000SUM(AM55:BE55)-1297.8993334881807SUM(BH53:BH54)0SUM(BI53:BI54)59.676724429666798SUM(BH55:BI55)59.676724429666798Q55+AK55+BF55+BJ55-2.4868995751603507E-13SUM(BO53:BO54)21.0957954053958123.2690367131288804E-20.2455641289177581103.4671141524569762.64031296125177750000000000000000000000000000000000000027.481477015153608
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)017.549707319999996000IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S57:AJ57)17.549707319999996IFERROR(INDEX(INDIRECT($C57&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C57&".Outputs[Vector]"), 0)), 0)00000000000-17.5497073199999960000000SUM(AM57:BE57)-17.549707319999996IFERROR(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)0011.7931627800000010000000000000000SUM(S58:AJ58)11.79316278000000100000000000-11.7931627800000010000000SUM(AM58:BE58)-11.79316278000000100SUM(BH58:BI58)0Q58+AK58+BF58+BJ58000000000000000000000000000000000000000000000SUM(BO58:DF58)0
799INDEX(Modules[Module], MATCH($C59, Modules[Code], 0))Hydroelectric0000000000005.329728000000001100000000000000005.3297280000000011000000000000000-5.3297280000000011000-5.32972800000000110000000000000000000000000000000000000000000000000
804INDEX(Modules[Module], MATCH($C60, Modules[Code], 0))Wave and Tidal0000000000002.3015753424657545E-200000000000000002.3015753424657545E-2000000000000-2.0013698630136998E-2-3.0020547945205484E-300000-2.3015753424657545E-20000000000000000000000000000000000000000000000000
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)034.6956138534246610000000000SUM(AE57:AE62)000SUM(AH57:AH62)00034.695613853424661SUM(AM57:AM62)00000000000-29.342870099999999-2.0013698630136998E-2-3.0020547945205484E-30-5.3297280000000011000-34.695613853424661SUM(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.3604831999999999E-2000IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S65:AJ65)1.3604831999999999E-2IFERROR(INDEX(INDIRECT($C65&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C65&".Outputs[Vector]"), 0)), 0)0000000000-1.3604831999999999E-200000000SUM(AM65:BE65)-1.3604831999999999E-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.3604831999999999E-20000000000SUM(AE65:AE67)000SUM(AH65:AH67)000SUM(S68:AJ68)1.3604831999999999E-2SUM(AM65:AM67)0000000000-1.3604831999999999E-200000000SUM(AM68:BE68)-1.3604831999999999E-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.8729462092837785SUM(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.2675637441833969000IFERROR(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.872946209283778500000000SUM(S71:AJ71)7.6053824651003819IFERROR(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.6053824651003819IFERROR(INDEX(INDIRECT($C71&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C71&".Outputs[Vector]"), 0)), 0)0SUM(BH71:BI71)-7.6053824651003819Q71+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.267563744183396900000008.87294620928377850AD710AE71000AH710AI7100SUM(S72:AJ72)7.6053824651003819AM710AN71000000000000000000SUM(AM72:BE72)0BH71-7.6053824651003819BI710SUM(BH72:BI72)-7.6053824651003819Q72+AK72+BF72+BJ720BO71000000000000000000000000000000000000000000000
0
16981322S$40+S$46+S$51+S$99+S$55+S$93+S$63+S$68+S$72-372.62479962516409T$40+T$46+T$51+T$99+T$55+T$93+T$63+T$68+T$725.5023121613186241SUM(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)044.180639999999997000IFERROR(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)44.180639999999997IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)000000000-134.99639999999999000000000SUM(AM75:BE75)-134.99639999999999IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)86.397695999999996IFERROR(INDEX(INDIRECT($C75&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C75&".Outputs[Vector]"), 0)), 0)4.4180640000000002SUM(BH75:BI75)90.8157599999999970IFERROR(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)0S75044.180639999999997000000000AD750AE7500AG750AH750AI7500SUM(S76:AJ76)44.180639999999997AM750AN7500000000-134.99639999999999000000000SUM(AM76:BE76)-134.99639999999999BH7586.397695999999996BI754.4180640000000002SUM(BH76:BI76)90.8157599999999970BO75000000000000000000000000000000000000000000000
00
16991322S$74+S$76-372.62479962516409T$74+T$7649.68295216131862400
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)05.0797874250000001-6.77372727272727460-5.7810258620689661IFERROR(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)-7.4749657097962405IFERROR(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)6.2213181347962401IFERROR(INDEX(INDIRECT($C79&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C79&".Outputs[Vector]"), 0)), 0)1.2536475750000002SUM(BH79:BI79)7.47496570979624050IFERROR(SUMIFS(INDIRECT($C79&".Emissions["&this.Year&"]"), INDIRECT($C79&".Emissions[GHG]"), BO$6, INDIRECT($C79&".Emissions[IPCC Sector]"), BO$5),0)3.15001675862068978.2610079664597533E-32.0774860385333167E-20000000000000000000000000000000000000-2.83501508275862070000.34403754421386168
17001322S78+S79-372.62479962516409T78+T7954.76273958631862400
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)0317.86206003884547-374.304693600000060-393.91141083124478IFERROR(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)-450.35404439239937IFERROR(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)440.25375625562242IFERROR(INDEX(INDIRECT($C81&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C81&".Outputs[Vector]"), 0)), 0)10.100288136776911SUM(BH81:BI81)450.35404439239932Q81+AK81+BF81+BJ810IFERROR(SUMIFS(INDIRECT($C81&".Emissions["&this.Year&"]"), INDIRECT($C81&".Emissions[GHG]"), BO$6, INDIRECT($C81&".Emissions[IPCC Sector]"), BO$5),0)187.765545221749050.483952674876652441.177521779196777400000000000000000000000000000000000000000189.42701967582249
74INDEX(Workstreams[Workstream], MATCH($C82, Workstreams[Code], 0))Hydrocarbon fuel power generationG79+G810000000000SUM(G82:P82)0S79+S810322.94184746384548-381.078420872727350-399.69243669331377000000AD79+AD810AE79+AE81000AH79+AH81000SUM(S82:AJ82)-457.82901010219564AM79+AM810000000000000000000SUM(AM82:BE82)0BH79+BH81446.47507439041868BI79+BI8111.353935711776911SUM(BH82:BI82)457.829010102195580BO79+BO81190.915561980369740.492213682843112181.19829663958211060000000000000000000000000000000000000-2.8350150827586207000189.77105722003634
SUM(AM83:BE83)00
1794249G$51+G$55+G$63+G$68+G$72+G$76+G$82+G$460055.9507594486607050000000SUM(G84:P84)55.950759448660705S$51+S$55+S$63+S$68+S$72+S$76+S$82+S$46-11.820231401746959400.56414240508673-381.98023470254452-54.0740532779418-447.83423633146799177.38714933365171664.52033513004915508.9835525196515408.148873946764034303.77465074763744560.9181944908395838226.83376347233890914.50728720865344518.09047322124454402.4160669746738729E-2SUM(S84:AJ84)928.04382743196254AM$51+AM$55+AM$63+AM$68+AM$72+AM$76+AM$82+AM$46-124.39544583847987-664.52033513004915-508.98355251965154000000-134.99639999999999-1.3604831999999999E-2-29.342870099999999-2.0013698630136998E-2-3.0020547945205484E-30-5.32972800000000110-4.6928452384770294-112.42322739740875SUM(AM84:BE84)-1584.7210248094912BH$51+BH$55+BH$63+BH$68+BH$72+BH$76+BH$82+BH$46525.27771378742398BI$51+BI$55+BI$63+BI$68+BI$72+BI$76+BI$82+BI$4675.448724141443705SUM(BH84:BI84)600.726437928867650BO$51+BO$55+BO$63+BO$68+BO$72+BO$76+BO$82+BO$46213.539415811159330.5275420496727271.462922237039378603.4671141524569762.64031296125177750000000000019.31873682079691422.11559163272466905.9335449880966671000021.4992911717090961.31837295345152760000000000000-2.835015082758620700DF$51+DF$99+DF$55+DF$63+DF$68+DF$76+DF$82+DF$460SUM(BO84:DF84)288.98782969560045
0
9750
0
|
772INDEX(Modules[Module], MATCH($C89, Modules[Code], 0))Electricity imports / exportsIFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(G89:P89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)00000IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(Y$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(Z$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)00000000000SUM(S89:AJ89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM89:BE89)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C89&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C89&".Outputs[Vector]"), 0)), 0)0SUM(BH89:BI89)0Q89+AK89+BF89+BJ890IFERROR(SUMIFS(INDIRECT($C89&".Emissions["&this.Year&"]"), INDIRECT($C89&".Emissions[GHG]"), BO$6, INDIRECT($C89&".Emissions[IPCC Sector]"), BO$5),0)00000000000000000000000000000000000000000000
17011323S$40+$S46+S$51+S$99+S$55+S$89-372.62479962516409T$40+$S46+T$51+T$99+T$55+T$89-4.0701435957967548E-30
782INDEX(Modules[Module], MATCH($C91, Modules[Code], 0))Electricity grid distributionIFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(G$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000SUM(G91:P91)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(S$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0-27.93934277992264000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(X$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000000SUM(S91:AJ91)-27.93934277992264IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)000000000IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(AV$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0000000000SUM(AM91:BE91)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C91&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C91&".Outputs[Vector]"), 0)), 0)27.939342779922629SUM(BH91:BI91)27.9393427799226290IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BO$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BO$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), BY$6, INDIRECT($C91&".Emissions[IPCC Sector]"), BY$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CI$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CI$5),0)0000000000IFERROR(SUMIFS(INDIRECT($C91&".Emissions["&this.Year&"]"), INDIRECT($C91&".Emissions[GHG]"), CS$6, INDIRECT($C91&".Emissions[IPCC Sector]"), CS$5),0)00000000000000
792INDEX(Modules[Module], MATCH($C92, Modules[Code], 0))Storage, demand shifting, backup0000000000SUM(G92:P92)0000000000000000000SUM(S92:AJ92)00000000000000000000SUM(AM92:BE92)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BH$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0IFERROR(INDEX(INDIRECT($C92&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C92&".Outputs[Vector]"), 0)), 0)0SUM(BH92:BI92)0000000000000000000000000000000000000000000000
673INDEX(Workstreams[Workstream], MATCH($C93, Workstreams[Code], 0))Electricity distribution, storage, and balancingG$89+G$91+G$920000000000SUM(G93:P93)0S$89+S$91+S$920-27.93934277992264000X$89+X$91+X$920Y$89+Y$91+Y$920Z$89+Z$91+Z$9200000000000SUM(S93:AJ93)-27.93934277992264AM$89+AM$91+AM$920000000000000000000SUM(AM93:BE93)0BH$89+BH$91+BH$920BI$89+BI$91+BI$9227.939342779922629SUM(BH93:BI93)27.9393427799226290BO$89+BO$91+BO$9200000000000000000000000000000000000000000000SUM(BO93:DF93)0
00
17021650(U$40+U$84+U$93)-448.25143932751371(V$40+V$84+V$93)-861.56932977985548(W$40+W$84+W$93)-1070.3857558228669(AC$40+AC$84+AC$93)03.77465074763744560.9181944908395838226.83376347233890914.50728720865344518.090473221244544BE40+BE46+BE51-112.42322739740875SUM(AM95:BE95)-112.423227397408750
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)0024.150387125105021.681261068786125828.970938627734625000000-3.7746507476374456-0.91819449083958382-26.833763472338909-14.507287208653445-18.09047322124454400SUM(S96:AJ96)-9.3217823190881575IFERROR(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)9.3217823190881575IFERROR(INDEX(INDIRECT($C96&".Outputs["&this.Year&"]"), MATCH(BI$5, INDIRECT($C96&".Outputs[Vector]"), 0)), 0)0SUM(BH96:BI96)9.3217823190881575Q96+AK96+BF96+BJ960IFERROR(SUMIFS(INDIRECT($C96&".Emissions["&this.Year&"]"), INDIRECT($C96&".Emissions[GHG]"), BO$6, INDIRECT($C96&".Emissions[IPCC Sector]"), BO$5),0)000000000000000000000000000000000000-13.1892872092320450000000-13.189287209232045
17031650U$95+U$96-424.10105220240871V$95+V$96-859.88806871106931W$95+W$96-1041.4148171951324AC$95+AC$96000000BE42+BE49+BE53-97.812149689806731SUM(AM97:BE97)-97.812149689806731SUM(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)003.5782534883720931-0.3218534883720930400000000000000SUM(S98:AJ98)3.2564000000000002IFERROR(INDEX(INDIRECT($C98&".Outputs["&this.Year&"]"), MATCH(AM$5, INDIRECT($C98&".Outputs[Vector]"), 0)), 0)000-3.2564000000000002000000000000000SUM(AM98:BE98)-3.2564000000000002IFERROR(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.02163870232558130000000SUM(BO98:DF98)-1.0216387023255813
671INDEX(Workstreams[Workstream], MATCH($C99, Workstreams[Code], 0))BioenergyG$96+G980H$96+H98000000000SUM(G99:P99)0S$96+S980027.7286406134771111.359407580414032928.970938627734625000000AD$96+AD98-3.7746507476374456AE$96+AE98-0.91819449083958382-26.833763472338909-14.507287208653445AH$96+AH98-18.09047322124454400SUM(S99:AJ99)-6.0653823190881582AM$96+AM98000-3.2564000000000002000000000000000SUM(AM99:BE99)-3.2564000000000002BH$96+BH989.3217823190881575BI$96+BI980SUM(BH99:BI99)9.3217823190881575Q99+AK99+BF99+BJ990BO$96+BO98000000000000000000000000000000000000-14.2109259115576270000000-14.210925911557627
0
17041212(S$40+S$84+S$93+S$99)-372.62479962516409(T$40+T$84+T$93+T$99)372.62479962516409(U$40+U$84+U$93+U$99)-420.52279871403658(V$40+V$84+V$93+V$99)-860.20992219944139(W$40+W$84+W$93+W$99)-1041.41481719513240
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)00420.52279871403658860.209922199441391041.4148171951324-420.52279871403658-860.20992219944139-1053.41749817339770000000000SUM(S102:AJ102)-12.002680978265289IFERROR(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)12.002680978265277SUM(BH102:BI102)12.002680978265277Q102+AK102+BF102+BJ1020IFERROR(SUMIFS(INDIRECT($C102&".Emissions["&this.Year&"]"), INDIRECT($C102&".Emissions[GHG]"), BO$6, INDIRECT($C102&".Emissions[IPCC Sector]"), BO$5),0)000004.73480019437813570000IFERROR(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.7348001943781357
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)243.13564938038488-(Y$40+Y$84+Y$93+Y$99+Y$102)195.68958706939225-(Z$40+Z$84+Z$93+Z$99+Z$102)544.43394565374615SUM(S103:AJ103)983.25918210352324-T1030-V1030-X103-243.13564938038488-Y103-195.68958706939225-Z103-544.43394565374615SUM(AM103:BE103)-983.25918210352324SUM(BH103:BI103)00000000000000000000000000000000000000000000000
7941000INDEX(Workstreams[Workstream], MATCH($C104, Workstreams[Code], 0))TransfersSUM(G102:G103)0SUM(H102:H103)000000000SUM(G104:P104)0SUM(S102:S103)00420.52279871403658860.209922199441391041.4148171951324-177.38714933365171-664.52033513004915-508.98355251965154000SUM(AD102:AD103)0SUM(AE102:AE103)00SUM(AG102:AG103)0SUM(AH102:AH103)0SUM(AI102:AI103)00SUM(S104:AJ104)971.2565011252575SUM(AM102:AM103)000000-243.13564938038488-195.68958706939225-544.433945653746150000000000SUM(AM104:BE104)-983.25918210352324SUM(BH102:BH103)0SUM(BI102:BI103)12.002680978265277SUM(BH104:BI104)12.002680978265277-4.6718184876226587E-13SUM(BO102:BO103)000004.7348001943781357000000000000000000000000000000000000004.7348001943781357
0
17951004G$93+G$99+G$1040000000000SUM(G106:P106)0S$93+S$99+S$1040-27.93934277992264448.25143932751371861.569329779855481070.3857558228669-177.38714933365171-664.52033513004915-508.98355251965154000-3.7746507476374456-0.91819449083958382-26.833763472338909-14.507287208653445-18.09047322124454400SUM(S106:AJ106)937.25177602624694AM$93+AM$99+AM$104000-3.256400000000000200-243.13564938038488-195.68958706939225-544.433945653746150000000000SUM(AM106:BE106)-986.51558210352323BH$93+BH$99+BH$1049.3217823190881575BI$93+BI$99+BI$10439.942023758187908SUM(BH106:BI106)49.263806077276065-2.2026824808563106E-13BO$93+BO$99+BO$104000004.7348001943781357000000000000000000000000000000-14.210925911557627000000DF$93+DF$1040SUM(BO106:DF106)-9.4761257171794924
0
0
593G$40+G$84+G$106554.11036409922224181.64752039357137471.79679543671375445.1164077323517217.18344884013043510.16371642308929225.383064556311584174.0209706988312941.8240747266484970SUM(G109:P109)1921.2463629068702S$40+S$84+S$106-372.62479962516409372.624799625164090000000000000000SUM(S109:AJ109)0AM$40+AM$84+AM$106-124.39544583847987-664.52033513004915-508.98355251965154-3.256400000000000200-243.13564938038488-195.68958706939225-544.43394565374615-134.99639999999999-1.3604831999999999E-2-29.342870099999999-2.0013698630136998E-2-3.0020547945205484E-30-5.32972800000000110-4.6928452384770294-112.42322739740875SUM(AM109:BE109)-2571.2366069130144BH$40+BH$84+BH$106534.59949610651211BI$40+BI$84+BI$106115.39074789963161SUM(BH109:BI109)649.990244006143710BO$40+BO$84+BO$106496.412984191175611.00126709680913844.551947783095756403.4671141524569767.37511315562991320014.4036879919609010.112122160576156142.76188359003191639.27409598505177610000019.31873682079691422.11559163272466905.9335449880966671000021.4992911717090961.31837295345152760000053.9612613563699456.7181557363048094E-20.970873663316234590-14.210925911557627000-2.8350150827586207000SUM(BO109:DF109)647.49912925629997
|
|
2352SUM(DH63,DH68,DH76,DH82)189.77105722003634
79410052353T109-MIN(T103,0)-T72373.89236336934749
2354DH112/DH1130.50755531755157046
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
&L&"+,Regular"Pathways to 2050 -- Energy Flow Model&R&"+,Regular"&F | This version printed &D