76INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))National renewable power generation798INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Hydroelectric power stations133782513361339III.b.Scenario213382008Preferences.PowerUnitsGW133679442200720102015202020252030203520402045205011293*Unit.MW1.2929999999999999(Unit.GW)*1.61.61.61.61.61.61.61.61.61.621293*Unit.MW1.2929999999999999(Unit.GW)*1.61.6(Unit.GW)*1.71.7(Unit.GW)*1.81.8(Unit.GW)*1.851.85(Unit.GW)*1.91.9(Unit.GW)*1.951.95(Unit.GW)*22(Unit.GW)*2.052.0499999999999998(Unit.GW)*2.12.131293*Unit.MW1.2929999999999999(Unit.GW)*1.61.6(Unit.GW)*1.8251.825(Unit.GW)*2.052.0499999999999998(Unit.GW)*2.2752.2749999999999999(Unit.GW)*2.52.5(Unit.GW)*2.52.5(Unit.GW)*2.52.5(Unit.GW)*2.52.5(Unit.GW)*2.52.541293*Unit.MW1.2929999999999999(Unit.GW)*1.61.6(Unit.GW)*1.8251.825(Unit.GW)*2.16252.1625000000000001(Unit.GW)*2.668752.6687500000000002(Unit.GW)*3.4281253.4281250000000001(Unit.GW)*44(Unit.GW)*44(Unit.GW)*44(Unit.GW)*441280(INDEX(F$16:F$19,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(F$16:F$19,ROUNDUP($E$8,0))*MOD($E$8,1))1.2929999999999999(INDEX(G$16:G$19,ROUNDDOWN($E$8,0))*(1-MOD($E$8,1)))+(INDEX(G$16:G$19,ROUNDUP($E$8,0))*MOD($E$8,1))1.61.71.81.851.91.9522.04999999999999982.171710912452009201020117842007715730442200720102015202020252030203520402045205012INDEX(Vectors[Description], MATCH($C34, Vectors[Code], 0))Hydro0.362999999999999990.380.380.380.380.380.380.380.380.382738852743117100*Unit.MW0.1Preferences.PowerUnits&"peak"GWpeak2745118(0.2/36%)*Unit.W/Unit.m25.5555555555555566E-4Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^22746118(11/36%)*Unit.W/Unit.m23.0555555555555565E-2Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^24421092009117274411827503170180117993774343337743433336137753361377538172500178.43700000000001984.4799999999999603239Preferences.moneyunits&"/""100MWCapacity"£m/"100MWCapacity180117993176109D53*GBP*plantsize.III.b/Unit.kW250.00000000000003F53*GBP*plantsize.III.b/Unit.kW98.4479999999999933177E53*GBP*plantsize.III.b/Unit.kW17.843700000000005G53*GBP*plantsize.III.b/Unit.kW63831404421093240812762Preferences.PowerUnitsGW71579442200720102015202020252030203520402045205012INDEX(Vectors[Description], MATCH($C73, Vectors[Code], 0))HydroF201.2929999999999999G201.61.71.81.851.91.9522.04999999999999982.17312012801Preferences.PowerUnitsGWF$731.2929999999999999G$731.61.71.81.851.91.9522.04999999999999982.1833800F$340.36299999999999999G$340.380.380.380.380.380.380.380.380.388351260F81*F820.46935899999999997G81*G820.60800000000000010.646000000000000020.684000000000000050.703000000000000070.721999999999999980.740999999999999990.760.778999999999999910.79800000000000004548Preferences.EnergyUnitsTWhF$83*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy4.11440099400000045.32972800000000115.66283600000000045.99594400000000066.16249800000000116.32905199999999996.49560599999999956.66216000000000016.82871399999999976.995268000000001227392748"Approximate number of sites the size of Glendoe"Approximate number of sites the size of Glendoe2740F81/$F$3912.92999999999999816171818.518.99999999999999619.52020.499999999999996O81/$F$3921O88-F888.07000000000000212747Preferences.AreaUnitskm^2F81/$F$4142.31636363636361952.36363636363635355.63636363636361958.90909090909089260.54545454545453362.18181818181815963.81818181818179965.45454545454543967.09090909090906568.727272727272705O89-F8926.4109090909090872749Preferences.AreaUnitskm^2F81/$F$402327.39999999999962879.99999999999953059.99999999999953239.99999999999953329.99999999999953419.99999999999913509.99999999999913599.99999999999913689.99999999999913779.99999999999950O90-F901452.63825(G73+F73)/plantsize.III.b28.9299999999999963238(G88-F88)/(G72-F72)1.0233333333333341(H88-G88)/(H72-G72)0.20.20.19.9999999999999284E-20.100000000000000710.19.9999999999999284E-2(O88-N88+O92)/(O72-N72)5.886000000000000131832883176Preferences.moneyunits£mF93*$G$580G93*$G$58100.7451200000000719.68959999999999919.6895999999999999.84479999999999939.84479999999992839.84480000000007049.84479999999999939.8447999999999283579.464927999999993177Preferences.moneyunits£mF88*$G$5977.579999999999984G88*$G$5996102108111113.99999999999997117120122.999999999999971263184Preferences.moneyunits£mSUM(F96:F97)77.579999999999984SUM(G96:G97)196.74512000000007121.6896127.6896120.84479999999999123.84479999999991126.84480000000008129.84479999999999132.84479999999991705.4649279999999931853176Preferences.moneyunits£mF93*$F$580G93*$F$58255.8333333333335450.00000000000000750.00000000000000725.00000000000000424.99999999999982225.00000000000018125.00000000000000424.9999999999998221471.50000000000023177Preferences.moneyunits£mF88*$F$59230.71904100000003G88*$F$59285.49920000000009303.3429000000001321.18660000000011330.10845000000012339.03030000000007347.95215000000013356.87400000000014365.79585000000003374.717700000000093184Preferences.moneyunits£mSUM(F101:F102)230.71904100000003SUM(G101:G102)541.33253333333369353.3429000000001371.18660000000011355.10845000000012364.0302999999999372.9521500000003381.87400000000014390.795849999999861846.2177000000004683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F$854.1144009940000004G$855.32972800000000115.66283600000000045.99594400000000066.16249800000000116.32905199999999996.49560599999999956.66216000000000016.82871399999999976.995268000000001212INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Hydro-F85-4.1144009940000004-G85-5.3297280000000011-5.6628360000000004-5.9959440000000006-6.1624980000000011-6.3290519999999999-6.4956059999999995-6.6621600000000001-6.8287139999999997-6.9952680000000012148SUBTOTAL(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])0261326187826144426916927207217227237247257267272620"Approximate number of sites the size of Glendoe"Approximate number of sites the size of Glendoe2740F8812.92999999999999816171818.518.99999999999999619.52020.4999999999999962126152813Preferences.AreaUnitskm^242.31636363636361952.36363636363635355.63636363636361958.90909090909089260.54545454545453362.18181818181815963.81818181818179965.45454545454543967.09090909090906568.7272727272727052749Preferences.AreaUnitskm^22327.39999999999962879.99999999999953059.99999999999953239.99999999999953329.99999999999953419.99999999999913509.99999999999913599.99999999999913689.99999999999913779.999999999999531893190784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C130, CostVectors[Code], 0))Low estimate of capital costsF960G96100.7451200000000719.68959999999999919.6895999999999999.84479999999999939.84479999999992839.84480000000007049.84479999999999939.8447999999999283579.464927999999993133INDEX(CostVectors[Description], MATCH(C131, CostVectors[Code], 0))Low estimate of operating costsF9777.57999999999998496102108111113.99999999999997117120122.999999999999971263135INDEX(CostVectors[Description], MATCH(C132, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C133, CostVectors[Code], 0))High estimate of capital costsF1010G101255.8333333333335450.00000000000000750.00000000000000725.00000000000000424.99999999999982225.00000000000018125.00000000000000424.9999999999998221471.50000000000023142INDEX(CostVectors[Description], MATCH(C134, CostVectors[Code], 0))High estimate of operating costsF102230.71904100000003285.49920000000009303.3429000000001321.18660000000011330.10845000000012339.03030000000007347.95215000000013356.87400000000014365.79585000000003374.717700000000093144INDEX(CostVectors[Description], MATCH(C135, CostVectors[Code], 0))High estimate of fuel costs