671INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Bioenergy1674INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Bioenergy imports134582613401445V.b.Scenario16821212Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH(V.b.Inputs[Vector], Vectors[Code], 0))Solid hydrocarbonsINDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-477.47688574581014INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-489.42096395288434INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-424.10105220240871INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-330.01253462700402INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-189.30623768221534INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-75.991091551463768INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-51.052612761101457INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-45.351837686085183INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-42.800097675953488INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-40.37305226142360249INDEX(Vectors[Description], MATCH(V.b.Inputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsINDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-879.19249090171138INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-870.41221405982003INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-859.88806871106931INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-862.85804888351834INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-838.02822930186937INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-812.36508789739344INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-817.5367280114624INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-819.15843461219856INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-825.17627182240255INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-834.0330943954994650INDEX(Vectors[Description], MATCH(V.b.Inputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsINDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-961.32062695280331INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-973.97463097467073INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1041.4148171951324INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1133.6284176309214INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1265.7456104188914INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1406.8688137001402INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1513.6363619395906INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1598.3197844578183INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1685.1597523142461INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH(V.b.Inputs[Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-1748.521499491537313421678Preferences.EnergyUnitsTWh13407944220072010201520202025203020352040204520501378*Unit.ktoe4.3961399999999999$F25+($O25-$F25)/($O$24-$F$24)*(G$24-$F$24)4.089432558139535$F25+($O25-$F25)/($O$24-$F$24)*(H$24-$F$24)3.57825348837209313.06707441860465122.55589534883720942.04471627906976751.53353720930232561.02235813953488370.5111790697674418702378*Unit.ktoe4.3961399999999999$F26+($O26-$F26)/($O$24-$F$24)*(G$24-$F$24)6.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.441411627906977O27/2353378*Unit.ktoe4.3961399999999999$F27+($O27-$F27)/($O$24-$F$24)*(G$24-$F$24)8.973153488372092916.60150930232558224.22986511627906831.85822093023255539.48657674418604647.11493255813953654.74328837209302662.3716441860465170*Unit.TWh704378*Unit.ktoe4.3961399999999999$F28+($O28-$F28)/($O$24-$F$24)*(G$24-$F$24)13.85687441860465129.62476511627906845.39265581395348961.16054651162790676.92843720930233192.696327906976748108.46421860465117124.232109302325582*O271401679Preferences.EnergyUnitsTWh13407944220072010201520202025203020352040204520501-34*Unit.ktoe-0.39541999999999999$F33+($O33-$F33)/($O$24-$F$24)*(G$24-$F$24)-0.36783255813953486$F33+($O33-$F33)/($O$24-$F$24)*(H$24-$F$24)-0.32185348837209304-0.27587441860465117-0.2298953488372093-0.18391627906976743-0.13793720930232556-9.1958139534883687E-2-4.5979069767441871E-202-34*Unit.ktoe-0.39541999999999999$F34+($O34-$F34)/($O$24-$F$24)*(G$24-$F$24)2.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.884253488372096O35/2353-34*Unit.ktoe-0.39541999999999999$F35+($O35-$F35)/($O$24-$F$24)*(G$24-$F$24)4.515888372093023412.70140232558139620.88691627906976629.07243023255814137.25794418604651545.44345813953488353.62897209302325861.81448604651163270*Unit.TWh704-34*Unit.ktoe-0.39541999999999999$F36+($O36-$F36)/($O$24-$F$24)*(G$24-$F$24)9.399609302325581325.72465813953488142.04970697674418358.37475581395348574.69980465116279391.024853488372088107.34990232558138123.674951162790692*O3514029278529610.6*Unit.W/Unit.m26.0000000000000006E-4Preferences.PowerUnits&"/"&Preferences.AreaUnitsGW/km^271710916761677731117051263200720102015202020252030203520402045205047INDEX(Vectors[Description], MATCH($B54, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhINDEX(F$25:F$28, MATCH($E$7, $C$25:$C$28, 0))4.39613999999999994.0894325581395353.57825348837209313.06707441860465122.55589534883720942.04471627906976751.53353720930232561.02235813953488370.51117906976744187049INDEX(Vectors[Description], MATCH($B55, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhINDEX(F$33:F$36, MATCH($E$7, $C$33:$C$36, 0))-0.39541999999999999-0.36783255813953486-0.32185348837209304-0.27587441860465117-0.2298953488372093-0.18391627906976743-0.13793720930232556-9.1958139534883687E-2-4.5979069767441871E-2087347INDEX(Vectors[Description], MATCH($B58, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhMIN(F54, -F15)4.39613999999999994.0894325581395353.57825348837209313.06707441860465122.55589534883720942.04471627906976751.53353720930232561.02235813953488370.51117906976744187049INDEX(Vectors[Description], MATCH($B59, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhMIN(F55, -F16)-0.39541999999999999-0.36783255813953486-0.32185348837209304-0.27587441860465117-0.2298953488372093-0.18391627906976743-0.13793720930232556-9.1958139534883687E-2-4.5979069767441871E-2050627Preferences.EnergyUnitsTWhMIN(0,-F17)000000000MIN(0,-O17)016601063SUM(F$58:F$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))1.2551561199999999SUM(G$58:G$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))1.1675870883720929SUM(H$58:H$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))1.0216387023255813SUM(I$58:I$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.87569031627906957SUM(J$58:J$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.72974193023255796SUM(K$58:K$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.58379354418604645SUM(L$58:L$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.43784515813953484SUM(M$58:M$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.29189677209302323SUM(N$58:N$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))0.14594838604651161SUM(O$58:O$59*SUMIFS(EF[CO2], EF[Vector], $B$58:$B$59))02962Preferences.AreaUnitskm^2SUM(F58:F60)*Conversion.to.average.power/$F$41760.65100007605122707.58232565214064619.13453494562305530.68674423910545442.23895353258791353.79116282607032265.34337211955273176.8955814130351688.447790706517580683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH(V.b.Outputs[Vector], Vectors[Code], 0))Solid hydrocarbonsF584.3961399999999999G584.0894325581395353.57825348837209313.06707441860465122.55589534883720942.04471627906976751.53353720930232561.02235813953488370.51117906976744187049INDEX(Vectors[Description], MATCH(V.b.Outputs[Vector], Vectors[Code], 0))Liquid hydrocarbonsF59-0.39541999999999999G59-0.36783255813953486-0.32185348837209304-0.27587441860465117-0.2298953488372093-0.18391627906976743-0.13793720930232556-9.1958139534883687E-2-4.5979069767441871E-2050INDEX(Vectors[Description], MATCH(V.b.Outputs[Vector], Vectors[Code], 0))Gaseous hydrocarbonsF600G6000000000059INDEX(Vectors[Description], MATCH(V.b.Outputs[Vector], Vectors[Code], 0))Biomass oversupply (imports)-(F58+F59+F60)-4.0007200000000003-3.7216-3.2564000000000002-2.7911999999999999-2.3260000000000001-1.8608-1.3956-0.93040000000000012-0.4652-(O58+O59+O60)0148SUBTOTAL(109,V.b.Outputs[2007])0SUBTOTAL(109,V.b.Outputs[2010])0SUBTOTAL(109,V.b.Outputs[2015])0SUBTOTAL(109,V.b.Outputs[2020])0SUBTOTAL(109,V.b.Outputs[2025])0SUBTOTAL(109,V.b.Outputs[2030])0SUBTOTAL(109,V.b.Outputs[2035])0SUBTOTAL(109,V.b.Outputs[2040])0SUBTOTAL(109,V.b.Outputs[2045])0SUBTOTAL(109,V.b.Outputs[2050])0890106110641060103044269169272072172272372472572672710431039INDEX(IPCC[Sector_description], MATCH(V.b.Emissions[IPCC Sector], IPCC[Sector_code], 0))Bioenergy credit-F62-1.2551561199999999-G62-1.1675870883720929-1.0216387023255813-0.87569031627906957-0.72974193023255796-0.58379354418604645-0.43784515813953484-0.29189677209302323-0.145948386046511610148SUBTOTAL(109,V.b.Emissions[2007])-1.2551561199999999SUBTOTAL(109,V.b.Emissions[2010])-1.1675870883720929SUBTOTAL(109,V.b.Emissions[2015])-1.0216387023255813SUBTOTAL(109,V.b.Emissions[2020])-0.87569031627906957SUBTOTAL(109,V.b.Emissions[2025])-0.72974193023255796SUBTOTAL(109,V.b.Emissions[2030])-0.58379354418604645SUBTOTAL(109,V.b.Emissions[2035])-0.43784515813953484SUBTOTAL(109,V.b.Emissions[2040])-0.29189677209302323SUBTOTAL(109,V.b.Emissions[2045])-0.14594838604651161SUBTOTAL(109,V.b.Emissions[2050])02702270878270344269169272072172272372472572672730103021Preferences.AreaUnitskm^2F64760.65100007605122G64707.58232565214064619.13453494562305530.68674423910545442.23895353258791353.79116282607032265.34337211955273176.8955814130351688.447790706517580