673INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Electricity distribution, storage, and balancing772INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Electricity imports134182513361439VII.a.Scenario16822661Preferences.EnergyUnits&"e"TWhe7944220072010201520202025203020352040204520503731MAX(-INDIRECT(F13&"!T103"),0)0MAX(-INDIRECT(G13&"!T103"),0)5.6843418860808015E-140000024.40364719953879663.873540559076446103.25093663250482372037333732Preferences.PowerUnits&"e"GWe7944220072010201520202025203020352040204520507923734IFERROR(INDEX(INDIRECT($C19&".Info["&F$18&"]"), MATCH($N$16, INDIRECT($C19&".Info[Vector]"), 0)), 0)2.5IFERROR(INDEX(INDIRECT($C19&".Info["&G$18&"]"), MATCH($N$16, INDIRECT($C19&".Info[Vector]"), 0)), 0)2.5468101010101013382345Preferences.EnergyUnitsTWh133679200720102015202020252030203520402045205012346000000000022346000(30/140)*I312.57142857142857126.21428571428571359.85714285714285591520.14285714285714225.07142857142856930323460000.5*I31614.523354758.5704234600012*Unit.TWh12I31+(K31-I31)/(K$27-I$27)*(J$27-I$27)2946*Unit.TWh46K31+(M31-K31)/(M$27-K$27)*(L$27-K$27)7094*Unit.TWh94M31+(O31-M31)/(O$27-M$27)*(N$27-M$27)117140*Unit.TWh1401280(INDEX(F$28:F$31,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$28:F$31,ROUNDUP($E$7,0))*MOD($E$7,1))00000000006412199220078448Preferences.EnergyUnitsTWh78418442200720102015202020252030203520402045205046INDEX(Vectors[Description], MATCH($C43, Vectors[Code], 0))Electricity (supplied to grid)109($K$22+$K$23)*Unit.GWh000000000027388527781170.9527811180.152775440(15*Unit.W/Unit.m2)*Conversion.to.annual.energy*(1-$F$49)0.11176650000000002Preferences.EnergyUnits&"/"&Preferences.AreaUnits&"/y"TWh/km^2/y6431770109177111727791182782440277631703730323532423340Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW20072010201520202025203020352040204520503407150/Unit.GW*MGBP1501501501501501501501501501503408F68*$F$5016.764975000000003G68*$F$5016.76497500000000316.76497500000000316.76497500000000316.76497500000000316.76497500000000316.76497500000000316.76497500000000316.76497500000000316.76497500000000334893033113341Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW34090.3*MGBP/Unit.GW0.3334337413440335833571799180117991801344050%*150*(MGBP/Unit.GW)*MGBP*Price200097.140192726142374150%*150*(MGBP/Unit.GW)*Price2000291.4205781784270950%*0.298*(MGBP/Unit.GW)*Price20000.19298518288260283150%*0.298*(MGBP/Unit.GW)*Price20000.57895554864780852Preferences.moneyunits&"/"&Preferences.PowerUnits&"e"£m/GWe3489303311316917991801374230*GBP*Price2010/Unit.MWh3080*GBP*Price2010/Unit.MWh80Preferences.moneyunits&"/"&Preferences.EnergyUnits&"e"£m/TWhe8123735Preferences.EnergyUnitsTWh71579442200720102015202020252030203520402045205083407F320G320000000003736Preferences.PowerUnits&"e"GWe7944220072010201520202025203020352040204520503737F14*Conversion.to.average.power06.4845332946392885E-15000002.78389769558964067.286509304024233911.7785690888095833739-F92*Conversion.to.average.power00000000003738-F19-2.5-G19-2.5-4-6-8-10-10-10-10-103740MAX(SUM(F97:F99),0)0MAX(SUM(G97:G99),0)000000001.778569088809582973113746Preferences.EnergyUnitsTWhF$43+F320G$43+G3200000000027392780Preferences.PowerUnitsGW(F105*Conversion.to.average.power)/$F$48/(1-$F$49)00000000002777Preferences.AreaUnitskm^2F105/$F$500G105/$F$500000000003410(G109-F109)/50(H109-G109)/5000000003411G1110H1110I11103345SUM(G111:G112)0SUM(H111:H112)000000003183Preferences.moneyunits£m20072010201520202025203020352040204520503176F113*F69*50%00000000003177F108*$E$73*50%0G108*$E$73*50%0000000003184SUM(F116:F117)0SUM(G116:G117)0000000003185Preferences.moneyunits£m20072010201520202025203020352040204520503176F113*F69*150%00000000003177F108*$E$73*150%0G108*$E$73*150%0000000003184SUM(F121:F122)0SUM(G121:G122)00000000023747Preferences.EnergyUnitsTWhF140G145.6843418860808015E-140000024.40364719953879663.873540559076446103.25093663250482273920072010201520202025203020352040204520503748Preferences.PowerUnitsGWF1000G100000000001.77856908880958293749Preferences.PowerUnits&"/yr"GW/yrF128/$E$810G128/$E$81000000003755Preferences.PowerUnits&"/yr"GW/yrMAX((G128-F128)/(G127-F127),0)0MAX((H128-G128)/(H127-G127),0)00000000.355713817761916573750Preferences.PowerUnits&"/yr"GW/yrSUM(G129:G130)0SUM(H129:H130)00000000.355713817761916573183Preferences.moneyunits£m20072010201520202025203020352040204520503176F$131*$E$800G$131*$E$800000000034.554108812744463177F$128*$G$800G$128*$G$80000000000.343237480873261613752-F$125*$E$840-G125*$E$84-1.7053025658242404E-1200000-732.10941598616387-1916.2062167722934-3097.52809897514453184SUM(F134:F136)0SUM(G134:G136)-1.7053025658242404E-1200000-732.10941598616387-1916.2062167722934-3062.63075268152673185Preferences.moneyunits£m20072010201520202025203020352040204520503176F$131*$F$800G$131*$F$8000000000103.662326438233383177F$128*$H$860G$128*$H$860000000003751-F$125*$F$840-G$125*$F$84-4.5474735088646412E-1200000-1952.2917759631036-5109.8832447261157-8260.07493060038543184SUM(F140:F142)0SUM(G140:G142)-4.5474735088646412E-1200000-1952.2917759631036-5109.8832447261157-8156.4126041621521683Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$1050G$10500000000060INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity oversupply (imports)-F$1050-G$105000000000148SUBTOTAL(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])02613261878261444269169272072172272372472572672728072820Preferences.AreaUnitskm^2F1090G1090000000003732INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Interconnector capacityPreferences.PowerUnitsGWF108+F1280G108+G128000000001.778569088809582931893753Preferences.moneyunits£m784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C169, CostVectors[Code], 0))Low estimate of capital costsF1160G1160000000003133INDEX(CostVectors[Description], MATCH(C170, CostVectors[Code], 0))Low estimate of operating costsF11700000000003135INDEX(CostVectors[Description], MATCH(C171, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C172, CostVectors[Code], 0))High estimate of capital costsF1210G1210000000003142INDEX(CostVectors[Description], MATCH(C173, CostVectors[Code], 0))High estimate of operating costsF12200000000003144INDEX(CostVectors[Description], MATCH(C174, CostVectors[Code], 0))High estimate of fuel costs3754Preferences.moneyunits£m784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C179, CostVectors[Code], 0))Low estimate of capital costsF1340G1340000000034.554108812744463133INDEX(CostVectors[Description], MATCH(C180, CostVectors[Code], 0))Low estimate of operating costsF1350G135000000000.343237480873261613135INDEX(CostVectors[Description], MATCH(C181, CostVectors[Code], 0))Low estimate of fuel costsF1360G136-1.7053025658242404E-1200000-732.10941598616387-1916.2062167722934-3097.52809897514453140INDEX(CostVectors[Description], MATCH(C182, CostVectors[Code], 0))High estimate of capital costsF1400G14000000000103.662326438233383142INDEX(CostVectors[Description], MATCH(C183, CostVectors[Code], 0))High estimate of operating costsF1410G1410000000003144INDEX(CostVectors[Description], MATCH(C184, CostVectors[Code], 0))High estimate of fuel costsF1420G142-4.5474735088646412E-1200000-1952.2917759631036-5109.8832447261157-8260.0749306003854