76INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))National renewable power generation
1701INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Onshore wind
1341
|
8251336
1336III.a.1.Scenario2
|
1338
|
1567Preferences.PowerUnits & " per annum, for subsequent period; nameplate capacity"GW per annum, for subsequent period; nameplate capacity
|
1336794422007201020152020202520302035204020452050
1(Unit.GW)*0.6133333333333330.61333333333333295(Unit.GW)*0.550.55000000000000004(Unit.GW)*0.550.55000000000000004(Unit.GW)*0.550.550000000000000040(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00
2(Unit.GW)*0.7633333333333330.76333333333333298(Unit.GW)*111111111
3(Unit.GW)*0.7633333333333330.76333333333333298(Unit.GW)*1.441.44(Unit.GW)*1.61.61.61.61.61.61.61.6
4(Unit.GW)*0.7633333333333330.76333333333333298(Unit.GW)*1.521.52(Unit.GW)*2.12.1(Unit.GW)*2.52.52.52.52.52.52.5
1280(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.76333333333333298(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))111111110
|
1568Preferences.PowerUnits & " per annum, for subsequent period; nameplate capacity"GW per annum, for subsequent period; nameplate capacity
|
1336794422007201020152020202520302035204020452050
1(Unit.GW)*0000(Unit.GW)*-0.232-0.23200000000000001(Unit.GW)*-0.546-0.54600000000000004(Unit.GW)*-0.55-0.55000000000000004(Unit.GW)*-0.55-0.55000000000000004(Unit.GW)*-0.55-0.550000000000000040
2000(Unit.GW)*-0.232-0.23200000000000001(Unit.GW)*-0.636-0.63600000000000001(Unit.GW)*-1-1(Unit.GW)*-1-1(Unit.GW)*-1-1(Unit.GW)*-1-1
3000(Unit.GW)*-0.232-0.23200000000000001(Unit.GW)*-0.636-0.63600000000000001(Unit.GW)*-1.44-1.44(Unit.GW)*-1.6-1.6(Unit.GW)*-1.6-1.6(Unit.GW)*-1.6-1.6
4000(Unit.GW)*-0.232-0.23200000000000001(Unit.GW)*-0.636-0.63600000000000001(Unit.GW)*-1.52-1.52(Unit.GW)*-2.1-2.1(Unit.GW)*-2.5-2.5(Unit.GW)*-2.5-2.5
1280(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.23200000000000001-0.63600000000000001-1-1-1-10
|
|
784
|
1566Preferences.PowerUnitsGW
|
7157304422007201020152020202520302035204020452050
88781092.0834*Unit.GW2.0834000000000001
|
800
|
7157304422007201020152020202520302035204020452050
88781170.273000000000000020.30.30.30.30.30.30.30.30.3
|
2738
|
85
27422.5*Unit.MW2.5000000000000001E-3Preferences.PowerUnits&"peak"GWpeak
2775118(2.5)*Unit.W*Conversion.to.annual.energy/Unit.m22.1915000000000004E-2Preferences.EnergyUnits&"/"&Preferences.AreaUnitsTWh/km^2
|
442
109875
881
|
117877
882
1565
|
1183027
|
3170
18011799
3774343337743433
3361377533613775
3816185548.67734.5085470085468817.636363636363637
|
3193Preferences.moneyunits&"/ 2.5 MW capacity"£m/ 2.5 MW capacity
|
18011799
3176109D65*GBP*plantsize.III.a.1/Unit.kW4.6375000000000002F65*GBP*plantsize.III.a.1/Unit.kW1.8362713675213673
3177E65*GBP*plantsize.III.a.1/Unit.kW0.12167500000000002G65*GBP*plantsize.III.a.1/Unit.kW4.4090909090909097E-2
|
442
1093194
|
812
|
883Preferences.PowerUnitsGW
|
715794422007201020152020202520302035204020452050
8878F$372.0834000000000001F82+((G$81-F$81)*(F19+F28))4.37339999999999939.373400000000000214.373418.213420.033420.033420.033420.033420.0334
|
|
731
1797
|
8782007201020152020202520302035204020452050
801Preferences.PowerUnitsGWF$822.08340000000000014.37339999999999939.373400000000000214.373418.213420.033420.033420.033420.033420.0334
833800F$420.27300000000000002G$420.30.30.30.30.30.30.30.30.3
8351260F90*F910.568768200000000061.31201999999999972.812024.31201999999999955.46401999999999976.01001999999999996.01001999999999996.01001999999999996.01001999999999996.0100199999999999
548Preferences.EnergyUnitsTWhF92*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy4.985822041200000511.50116731999999724.65016731999999837.79916731999999547.89759931999999852.6838353252.6838353252.6838353252.6838353252.68383532
|
2739
"Approximate total "&$F$47/Unit.MW&" MW turbines"Approximate total 2.5 MW turbines2740F90/$F$47833.361749.35999999999973749.365749.367285.368013.368013.368013.368013.368013.36
"Approximate build rate of "&$F$47/Unit.MW&" MW turbines"Approximate build rate of 2.5 MW turbines2741F19/$F$47305.3333333333332G19/$F$47400400400400400400400400
2736Preferences.AreaUnitskm^2F93/$F$48227.50727999999998524.807999999999771124.80799999999981724.80799999999952185.60799999999972404.00799999999942404.00799999999942404.00799999999942404.00799999999942404.0079999999994
|
3183
3176Preferences.moneyunits£mF97*$G$700G97*$G$70560.67485754985728734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688
3177Preferences.moneyunits£mF96*$G$7136.743600000000008G96*$G$7177.130872727272731165.31269090909095253.4945090909091321.21814545454549353.31632727272734353.31632727272734353.31632727272734353.31632727272734353.31632727272734
3184Preferences.moneyunits£mSUM(F101:F102)36.743600000000008637.80573027713001899.82123791763786988.003056099455991055.72669246309241087.82487428127431087.82487428127431087.82487428127431087.82487428127431087.8248742812743
|
3185
3176Preferences.moneyunits£mF97*$F$7001415.983333333332718551855185518551855185518551855
3177Preferences.moneyunits£mF96*$F$71101.39907800000002G96*$F$71212.85337799999999456.2033780000001699.55337800000007886.44617800000015975.02557800000011975.02557800000011975.02557800000011975.02557800000011975.02557800000011
3184Preferences.moneyunits£mSUM(F106:F107)101.399078000000021628.83671133333272311.20337800000022554.55337800000012741.44617800000012830.02557800000022830.02557800000022830.02557800000022830.02557800000022830.0255780000002
683
|
729Preferences.EnergyUnitsTWh
|
78418442691692720721722723724725726727
46INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$934.985822041200000511.50116731999999724.65016731999999837.79916731999999547.89759931999999852.6838353252.6838353252.6838353252.6838353252.68383532
8INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wind-F$93-4.9858220412000005-11.501167319999997-24.650167319999998-37.799167319999995-47.897599319999998-52.68383532-52.68383532-52.68383532-52.68383532-52.68383532
148SUBTOTAL(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])0
|
2613
|
2618
|
782614442691692720721722723724725726727
2615"onshore wind if "&ROUND($F$48*Unit.m2/(Unit.W*Conversion.to.annual.energy),1)&" W/m2"onshore wind if 2.5 W/m2Preferences.AreaUnitskm^2F98227.50727999999998524.807999999999771124.80799999999981724.80799999999952185.60799999999972404.00799999999942404.00799999999942404.00799999999942404.00799999999942404.0079999999994
26202737Preferences.PowerUnitsGWF822.08340000000000014.37339999999999939.373400000000000214.373418.213420.033420.033420.033420.033420.0334
2621"Approximate number if "&$F$47/Unit.MW&" MW turbines"Approximate number if 2.5 MW turbines2740F96833.361749.35999999999973749.365749.367285.368013.368013.368013.368013.368013.36
|
|
3189
|
3190
|
78418442691692720721722723724725726727
3131INDEX(CostVectors[Description], MATCH(C136, CostVectors[Code], 0))Low estimate of capital costsF1010G101560.67485754985728734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688734.50854700854688
3133INDEX(CostVectors[Description], MATCH(C137, CostVectors[Code], 0))Low estimate of operating costsF10236.74360000000000877.130872727272731165.31269090909095253.4945090909091321.21814545454549353.31632727272734353.31632727272734353.31632727272734353.31632727272734353.31632727272734
3135INDEX(CostVectors[Description], MATCH(C138, CostVectors[Code], 0))Low estimate of fuel costs
3140INDEX(CostVectors[Description], MATCH(C139, CostVectors[Code], 0))High estimate of capital costsF1060G1061415.983333333332718551855185518551855185518551855
3142INDEX(CostVectors[Description], MATCH(C140, CostVectors[Code], 0))High estimate of operating costsF107101.39907800000002212.85337799999999456.2033780000001699.55337800000007886.44617800000015975.02557800000011975.02557800000011975.02557800000011975.02557800000011975.02557800000011
3144INDEX(CostVectors[Description], MATCH(C141, CostVectors[Code], 0))High estimate of fuel costs
|