76INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))National renewable power generation1702INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Offshore wind134182513361336III.a.2.Scenario213381569Preferences.PowerUnits & " per annum, for subsequent period; nameplate capacity"GW per annum, for subsequent period; nameplate capacity13367944220072010201520202025203020352040204520501(Unit.GW)*0.3166666666666670.31666666666666698(Unit.GW)*0.50.5(Unit.GW)*0.50.5(Unit.GW)*0.40.4(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00(Unit.GW)*002(Unit.GW)*0.3166666666666670.31666666666666698(Unit.GW)*1.1681.1679999999999999(Unit.GW)*1.761.76(Unit.GW)*33333333(Unit.GW)*0.3166666666666670.31666666666666698(Unit.GW)*1.1681.1679999999999999(Unit.GW)*3.483.48(Unit.GW)*4.24.2(Unit.GW)*55(Unit.GW)*55(Unit.GW)*55(Unit.GW)*55(Unit.GW)*554(Unit.GW)*SUM(F36:F37)0.316666666666666981.16799999999999995.66.47.411.11212121280(INDEX(F$15:F$18,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$15:F$18,ROUNDUP($E$7,0))*MOD($E$7,1))0.31666666666666698(INDEX(G$15:G$18,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$15:G$18,ROUNDUP($E$7,0))*MOD($E$7,1))1.16799999999999991.7633333301570Preferences.PowerUnits & " per annum, average, for subsequent period; nameplate capacity"GW per annum, average, for subsequent period; nameplate capacity13367944220072010201520202025203020352040204520501(Unit.GW)*0000(Unit.GW)*-0.03-0.03-0.23876000000000022-G15-0.5-0.5-0.402000(Unit.GW)*-0.03-0.03-0.23876000000000022-1.1679999999999999-1.76-3-33000(Unit.GW)*-0.03-0.03-0.23876000000000022-1.1679999999999999-3.48-4.2-54000(Unit.GW)*-0.03-0.03-0.23876000000000022-1.1679999999999999-5.6-6.4-7.41280(INDEX(F$24:F$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(F$24:F$27,ROUNDUP($E$7,0))*MOD($E$7,1))0(INDEX(G$24:G$27,ROUNDDOWN($E$7,0))*(1-MOD($E$7,1)))+(INDEX(G$24:G$27,ROUNDUP($E$7,0))*MOD($E$7,1))00-0.03-0.23876000000000022-1.1679999999999999-1.76-3-307842626133679442200720102015202020252030203520402045205026270.316666666666666981.16799999999999995.56666662628000.10.41.45.09999999999999966661566Preferences.PowerUnitsGW715730442200720102015202020252030203520402045205088791090.3938*Unit.GW0.39379999999999998800715730442200720102015202020252030203520402045205088790.282999999999999970.350.350.370.40.430.450.450.450.4527388527425.8*Unit.MW5.7999999999999996E-3Preferences.PowerUnits&"peak"GWpeak2735118(2.5)*Unit.W*Conversion.to.annual.energy/Unit.m22.1915000000000004E-2Preferences.EnergyUnits&"/"&Preferences.AreaUnitsTWh/km^2442109875881876117877882156511830273170180117993774343337743433336137753361377531974155159.75525353195Preferences.moneyunits&"/ 5.8 MW capacity"£m/ 5.8 MW capacity180117993176109D70*GBP*plantsize.III.a.2/Unit.kW24.099F70*GBP*plantsize.III.a.2/Unit.kW3.04499999999999993177E70*GBP*plantsize.III.a.2/Unit.kW0.92654999999999987G70*GBP*plantsize.III.a.2/Unit.kW0.202999999999999994421093196812883Preferences.PowerUnitsGW7157944220072010201520202025203020352040204520508879F$420.39379999999999998F89+(G$88-F$88)*(F19+F28)1.3438000000000017.183800000000000615.98380000000000230.83380000000000444.6453.86060607311797879801Preferences.PowerUnitsGWF$890.393799999999999981.3438000000000017.183800000000000615.98380000000000230.83380000000000444.6453.8606060833800F$470.282999999999999970.350.350.370.40.430.450.450.450.458351260F97*F980.111445399999999990.47033000000000032.51433000000000025.914006000000000512.33352000000000219.195224.21272727548Preferences.EnergyUnitsTWhF99*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy0.976930376399999914.122912780000002722.04061678000000451.842176596000009108.11563632000002168.26512319999998212.22486000000001236.68199999999999236.68199999999999236.681999999999992739"Approximate total "&$F$52/Unit.MW&" MW turbines"Approximate total 5.8 MW turbines2740F97/$F$5267.896551724137936G97/$F$52231.689655172413981238.58620689655192755.82758620689725316.17241379310427696.55172413793219275.862068965518110344.82758620689710344.82758620689710344.827586206897"Approximate build rate of "&$F$52/Unit.MW&" MW turbines"Approximate build rate of 5.8 MW turbines2741F19/$F$5254.597701149425347G19/$F$52201.37931034482759303.44827586206901517.24137931034488517.24137931034488517.24137931034488517.24137931034488517.24137931034488517.241379310344882736Preferences.AreaUnitskm^2F100/$F$5344.57815999999999G100/$F$53188.132000000000091005.7322365.60239999999984933.40800000000047678.07999999999729683.999999999998210799.99999999999810799.99999999999810799.99999999999831833176Preferences.moneyunits£mF104*$G$760G104*$G$76166.25000000000017H104*$G$76613.20000000000005924.000000000000111575.00000000000021575.00000000000021575.00000000000021575.00000000000021575.00000000000021575.00000000000023177Preferences.moneyunits£mF103*$G$7713.782999999999999G103*$G$7747.033000000000037H103*$G$77251.43300000000002559.433000000000111079.1831562.418832100210021003184Preferences.moneyunits£mSUM(F108:F109)13.782999999999999SUM(G108:G109)213.28300000000021864.633000000000041483.43300000000022654.1833137.4000000000005345836753675367531853176Preferences.moneyunits£mF104*$F$760G104*$F$761315.75000000000144853.047312.800000000001112465.00000000000212465.00000000000212465.00000000000212465.00000000000212465.00000000000212465.0000000000023177Preferences.moneyunits£mF103*$F$7762.909549999999996G103*$F$77214.672050000000161147.612052553.41205000000044925.69955000000037131.248594.54999999999939584.99999999999829584.99999999999829584.99999999999823184Preferences.moneyunits£mSUM(F113:F114)62.909549999999996SUM(G113:G114)1530.42205000000156000.65204999999979866.212050000001917390.69955000000119596.24000000000221059.550000000003220502205022050683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$1000.97693037639999991G$1004.122912780000002722.04061678000000451.842176596000009108.11563632000002168.26512319999998212.22486000000001236.68199999999999236.68199999999999236.681999999999998INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wind-F$100-0.97693037639999991-G$100-4.1229127800000027-22.040616780000004-51.842176596000009-108.11563632000002-168.26512319999998-212.22486000000001-236.68199999999999-236.68199999999999-236.68199999999999148SUBTOTAL(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])0261326187826144426916927207217227237247257267272662"offshore wind area if "&ROUND($F$53*Unit.m2/(Unit.W*Conversion.to.annual.energy),1)&" W/m2"offshore wind area if 2.5 W/m2Preferences.AreaUnitskm^2F10544.57815999999999G105188.132000000000091005.7322365.60239999999984933.40800000000047678.07999999999729683.999999999998210799.99999999999810799.99999999999810799.99999999999826202737Preferences.PowerUnitsGWF890.393799999999999981.3438000000000017.183800000000000615.98380000000000230.83380000000000444.6453.86060602621"Approximate number if "&$F$52/Unit.MW&" MW turbines"Approximate number if 5.8 MW turbines2740F10367.896551724137936G103231.689655172413981238.58620689655192755.82758620689725316.17241379310427696.55172413793219275.862068965518110344.82758620689710344.82758620689710344.82758620689731893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C144, CostVectors[Code], 0))Low estimate of capital costsF1080G108166.25000000000017613.20000000000005924.000000000000111575.00000000000021575.00000000000021575.00000000000021575.00000000000021575.00000000000021575.00000000000023133INDEX(CostVectors[Description], MATCH(C145, CostVectors[Code], 0))Low estimate of operating costsF10913.78299999999999947.033000000000037251.43300000000002559.433000000000111079.1831562.418832100210021003135INDEX(CostVectors[Description], MATCH(C146, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C147, CostVectors[Code], 0))High estimate of capital costsF1130G1131315.75000000000144853.047312.800000000001112465.00000000000212465.00000000000212465.00000000000212465.00000000000212465.00000000000212465.0000000000023142INDEX(CostVectors[Description], MATCH(C148, CostVectors[Code], 0))High estimate of operating costsF11462.909549999999996214.672050000000161147.612052553.41205000000044925.69955000000037131.248594.54999999999939584.99999999999829584.99999999999829584.99999999999823144INDEX(CostVectors[Description], MATCH(C149, CostVectors[Code], 0))High estimate of fuel costs