76INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))National renewable power generation1710INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Offshore wind134582613401340III.a.2.Scenario113421576Preferences.PowerUnits & " per annum, for subsequent period; nameplate capacity"GW per annum, for subsequent period; nameplate capacity13407944220072010201520202025203020352040204520501(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(F34:F35)0.316666666666666981.16799999999999995.66.47.411.11212121577Preferences.PowerUnits & " per annum, average, for subsequent period; nameplate capacity"GW per annum, average, for subsequent period; nameplate capacity13407944220072010201520202025203020352040204520501(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.47842717134079442200720102015202020252030203520402045205027180.316666666666666981.16799999999999995.56666662719000.10.41.45.09999999999999966661573Preferences.PowerUnitsGW715730442200720102015202020252030203520402045205088801090.3938*Unit.GW0.39379999999999998801715730442200720102015202020252030203520402045205088800.282999999999999970.350.350.370.40.430.450.450.450.4529278529315.8*Unit.MW5.7999999999999996E-3Preferences.PowerUnits&"peak"GWpeak2923118(2.5/30%)*Unit.W/Unit.m28.333333333333335E-3Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^244210987688287711787888315721182924813884Preferences.PowerUnitsGW7157944220072010201520202025203020352040204520508880F$400.39379999999999998F68+(G$67-F$67)*(INDEX(F$15:F$18, MATCH($E$7, $C$15:$C$18, 0))+INDEX(F$23:F$26, MATCH($E$7, $C$23:$C$26, 0)))1.3438000000000013.84380000000000086.34380000000000088.193800000000001374.52007311798880802Preferences.PowerUnitsGWF$680.393799999999999981.3438000000000013.84380000000000086.34380000000000088.193800000000001374.5200834801F$450.282999999999999970.350.350.370.40.430.450.450.450.458361263F76*F770.111445399999999990.47033000000000031.34533000000000012.34720600000000033.27752000000000093.012.02499999999999990.900548Preferences.EnergyUnitsTWhF78*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy0.976930376399999914.122912780000002711.79316278000000120.57560779600000328.7307403200000126.38565999999999817.7511499999999997.8894000000000002002928"Approximate total "&$F$50/Unit.MW&" MW turbines"Approximate total 5.8 MW turbines2929F76/$F$5067.896551724137936G76/$F$50231.68965517241398662.724137931034651093.75862068965531412.72413793103491206.8965517241379775.86206896551732344.8275862068965700"Approximate build rate of "&$F$50/Unit.MW&" MW turbines"Approximate build rate of 5.8 MW turbines2930(INDEX(F$15:F$18,MATCH($E$7,$C$15:$C$18,0)))/$F$5054.59770114942534786.20689655172414286.20689655172414268.96551724137931700000N8302925Preferences.AreaUnitskm^2F76/$F$5147.255999999999986G76/$F$51161.25600000000009461.25600000000003761.25599999999997983.25599999999997839.99999999999989539.99999999999989239.9999999999999400P76/P50#DIV/0!683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH(III.a.2.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F$790.97693037639999991G$794.122912780000002711.79316278000000120.57560779600000328.7307403200000126.38565999999999817.7511499999999997.8894000000000002008INDEX(Vectors[Description], MATCH(III.a.2.Outputs[Vector], Vectors[Code], 0))Wind-F$79-0.97693037639999991-G$79-4.1229127800000027-11.793162780000001-20.575607796000003-28.73074032000001-26.385659999999998-17.751149999999999-7.889400000000000200148SUBTOTAL(109,III.a.2.Outputs[2007])0SUBTOTAL(109,III.a.2.Outputs[2010])0SUBTOTAL(109,III.a.2.Outputs[2015])0SUBTOTAL(109,III.a.2.Outputs[2020])0SUBTOTAL(109,III.a.2.Outputs[2025])0SUBTOTAL(109,III.a.2.Outputs[2030])0SUBTOTAL(109,III.a.2.Outputs[2035])0SUBTOTAL(109,III.a.2.Outputs[2040])0SUBTOTAL(109,III.a.2.Outputs[2045])0SUBTOTAL(109,III.a.2.Outputs[2050])0270227087827034426916927207217227237247257267272764"offshore wind if "&ROUND($F$51*Unit.m2/Unit.W,0)&" Wpeak/m2"offshore wind if 8 Wpeak/m2Preferences.AreaUnitskm^2F8447.255999999999986G84161.25600000000009461.25600000000003761.25599999999997983.25599999999997839.99999999999989539.99999999999989239.999999999999940027102926Preferences.PowerUnitsGWF680.393799999999999981.3438000000000013.84380000000000086.34380000000000088.193800000000001374.52002711"Approximate number if "&$F$50/Unit.MW&" MW turbines"Approximate number if 5.8 MW turbines2929F8267.896551724137936G82231.68965517241398662.724137931034651093.75862068965531412.72413793103491206.8965517241379775.86206896551732344.8275862068965700