671INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Bioenergy1666INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Bioenergy imports3260134182513361439V.b.Scenario26821209Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([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([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-483.85140789915641INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-469.54881013698451INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-398.89465516284059INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-268.87226428669072INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-109.37220367217967INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-31.734935746086279INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-60.156248986755088INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-92.210668709401403INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-131.20595236953145INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-167.1578663606416649INDEX(Vectors[Description], MATCH([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([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-892.03442169570269INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-874.33643753519334INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-843.98839259379076INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-825.18842909756529INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-741.04898589629749INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-665.68784820846179INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-666.72693264614486INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-665.09573697911026INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-654.21693324006173INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-646.9902459373678350INDEX(Vectors[Description], MATCH([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([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-967.16729432391946INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-945.9344711372471INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-917.57761334500003INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-846.67429705427253INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-755.55248025501385INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-584.59254088863031INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-383.56089315047245INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-255.77235640890922INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-193.24718293715421INDEX(INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Matrix"), MATCH("Subtotal."&$A$2, INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Modules"), 0), MATCH([Vector], INDIRECT("'"&V.b.Inputs[#Headers]&"'!Year.Vectors"), 0))-121.9214008573615313381670Preferences.EnergyUnitsTWh13367944220072010201520202025203020352040204520501378*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*O271401280(INDEX(F$25:F$28,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$25:F$28,ROUNDUP($E$7,0))*MOD($E$7,1))4.3961399999999999(INDEX(G$25:G$28,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$25:G$28,ROUNDUP($E$7,0))*MOD($E$7,1))6.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.441411627906977351671Preferences.EnergyUnitsTWh13367944220072010201520202025203020352040204520501-34*Unit.ktoe-0.39541999999999999$F34+($O34-$F34)/($O$24-$F$24)*(G$24-$F$24)-0.36783255813953486$F34+($O34-$F34)/($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$F35+($O35-$F35)/($O$24-$F$24)*(G$24-$F$24)2.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.884253488372096O36/2353-34*Unit.ktoe-0.39541999999999999$F36+($O36-$F36)/($O$24-$F$24)*(G$24-$F$24)4.515888372093023412.70140232558139620.88691627906976629.07243023255814137.25794418604651545.44345813953488353.62897209302325861.81448604651163270*Unit.TWh704-34*Unit.ktoe-0.39541999999999999$F37+($O37-$F37)/($O$24-$F$24)*(G$24-$F$24)9.399609302325581325.72465813953488142.04970697674418358.37475581395348574.69980465116279391.024853488372088107.34990232558138123.674951162790692*O361401280(INDEX(F$34:F$37,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$34:F$37,ROUNDUP($E$7,0))*MOD($E$7,1))-0.39541999999999999(INDEX(G$34:G$37,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$34:G$37,ROUNDUP($E$7,0))*MOD($E$7,1))2.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.8842534883720963527388527720.6*Unit.W/Unit.m26.0000000000000006E-4Preferences.PowerUnits&"/"&Preferences.AreaUnitsGW/km^27171091668166931703261179918011437Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh(11*MGBP/Unit.PJ)*(Price2000)51.290021759403174(19*MGBP/Unit.PJ)*(Price2000)88.591855766241835230Preferences.moneyunits&"/"&Preferences.EnergyUnits£m/TWh(18*MGBP/Unit.PJ)*(Price2000)83.929126515387011(48*MGBP/Unit.PJ)*(Price2000)223.8110040410319932093260731116971260200720102015202020252030203520402045205047INDEX(Vectors[Description], MATCH($B64, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhF294.3961399999999999G296.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.4414116279069773549INDEX(Vectors[Description], MATCH($B65, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWhF38-0.39541999999999999G382.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.88425348837209635303947INDEX(Vectors[Description], MATCH($B68, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhMIN(F64, -F15)4.39613999999999996.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.4414116279069773549INDEX(Vectors[Description], MATCH($B69, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWh-0.395419999999999992.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.8842534883720963550627Preferences.EnergyUnitsTWhMIN(0,-F17)000000000MIN(0,-O17)0304047INDEX(Vectors[Description], MATCH($B73, Vectors[Code], 0))Solid hydrocarbonsPreferences.EnergyUnitsTWhIF((MIN(F68, -F15)>0),MIN(F68, -F15),0)4.39613999999999996.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.4414116279069773549INDEX(Vectors[Description], MATCH($B74, Vectors[Code], 0))Liquid hydrocarbonsPreferences.EnergyUnitsTWh02.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.8842534883720963550627Preferences.EnergyUnitsTWh0000000000216521060SUM(F$73:F$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))1.3540111199999998SUM(G$73:G$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))2.530145227906976SUM(H$73:H$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))4.655127074418604SUM(I$73:I$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))6.7801089209302319SUM(J$73:J$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))8.9050907674418589SUM(K$73:K$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))11.030072613953486SUM(L$73:L$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))13.155054460465115SUM(M$73:M$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))15.280036306976744SUM(N$73:N$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))17.405018153488371SUM(O$73:O$74*SUMIFS(EF[CO2],EF[Vector], $B$73:$B$74))19.5299999999999982773Preferences.AreaUnitskm^2SUM(F68:F70)*Conversion.to.average.power/$F$43760.651000076051221636.1169918306633095.22697808834984554.33696434603646013.44695060372317472.55693686140888931.666923119095410390.77690937678211849.88689563446913308.996881892155331891799200720102015202020252030203520402045205062Preferences.moneyunits£mF73*$F54225.47811625738268G73*$F54334.99016127982884517.51023631723911700.03031135464937882.550386392059641065.070461429471247.59053646688021430.11061150429051612.63068654170091795.150761579111163Preferences.moneyunits£mF74*$F550174.07135060109451519.50236028077597864.93336996045731210.36437964013861555.79538931982011901.22639899950152246.65740867918292592.08841835886412937.5194280385454148Preferences.moneyunits£mSUM(F84:F85)225.47811625738268SUM(G84:G85)509.061511880923381037.01259659801511564.96368131510672092.91476603219832620.86585074929013148.81693546638143676.76802018347374204.71910490056514732.67018961765641801200720102015202020252030203520402045205062Preferences.moneyunits£mF73*$G54389.46220080820638G73*$G54578.61936948334062893.881317275231031209.14326506712151524.4052128590121839.66716065090242154.92910844279282470.19105623468342785.45300402657363100.714951818464263Preferences.moneyunits£mF74*$G550464.190268269585261385.33962741540222306.4889865612193227.6383457070364148.78770485285265069.93706399866915991.08642314448666912.23578229030327833.3851414361197148Preferences.moneyunits£mSUM(F89:F90)389.46220080820638SUM(G89:G90)1042.80963775292592279.22094469063313515.63225162834084752.0435585660485988.45486550375527224.86617244146158461.27747937917059697.688786316877710934.100093254583683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672747INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Solid hydrocarbonsF684.39613999999999996.53129302325581410.08988139534883613.6484697674418617.20705813953488320.76564651162790724.3242348837209327.88282325581395331.4414116279069773549INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Liquid hydrocarbonsF69-0.395419999999999992.07402790697674446.189774418604652210.30552093023255914.42126744186046718.53701395348837322.6527604651162826.76850697674418830.8842534883720963550INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Gaseous hydrocarbonsF70000000000059INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Biomass oversupply (imports)-(F68+F69+F70)-4.0007200000000003-8.6053209302325584-16.279655813953489-23.953990697674421-31.628325581395352-39.302660465116276-46.976995348837207-54.651330232558138-62.325665116279069-(O68+O69+O70)-70148SUBTOTAL(109,[2007])0SUBTOTAL(109,[2010])0SUBTOTAL(109,[2015])0SUBTOTAL(109,[2020])0SUBTOTAL(109,[2025])0SUBTOTAL(109,[2030])0SUBTOTAL(109,[2035])0SUBTOTAL(109,[2040])0SUBTOTAL(109,[2045])0SUBTOTAL(109,[2050])0889105810611057102744269169272072172272372472572672710401036INDEX(IPCC[Sector_description], MATCH([IPCC Sector], IPCC[Sector_code], 0))Bioenergy credit-F77-1.3540111199999998-G77-2.530145227906976-4.655127074418604-6.7801089209302319-8.9050907674418589-11.030072613953486-13.155054460465115-15.280036306976744-17.405018153488371-19.529999999999998148SUBTOTAL(109,[2007])-1.3540111199999998SUBTOTAL(109,[2010])-2.530145227906976SUBTOTAL(109,[2015])-4.655127074418604SUBTOTAL(109,[2020])-6.7801089209302319SUBTOTAL(109,[2025])-8.9050907674418589SUBTOTAL(109,[2030])-11.030072613953486SUBTOTAL(109,[2035])-13.155054460465115SUBTOTAL(109,[2040])-15.280036306976744SUBTOTAL(109,[2045])-17.405018153488371SUBTOTAL(109,[2050])-19.5299999999999982613261878261444269169272072172272372472572672728072818Preferences.AreaUnitskm^2F79760.65100007605122G791636.1169918306633095.22697808834984554.33696434603646013.44695060372317472.55693686140888931.666923119095410390.77690937678211849.88689563446913308.99688189215531893190784184426916927207217227237247257267273135INDEX(CostVectors[Description], MATCH(C128, CostVectors[Code], 0))Low estimate of fuel costsF86225.47811625738268G86509.061511880923381037.01259659801511564.96368131510672092.91476603219832620.86585074929013148.81693546638143676.76802018347374204.71910490056514732.67018961765643144INDEX(CostVectors[Description], MATCH(C129, CostVectors[Code], 0))High estimate of fuel costsF91389.46220080820638G911042.80963775292592279.22094469063313515.63225162834084752.0435585660485988.45486550375527224.86617244146158461.27747937917059697.688786316877710934.100093254583