77INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))Distributed renewable power generation1574INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Small-scale wind1337825133613391.100000000000000113381996Preferences.PowerUnitsGW133679442200720102015202020252030203520402045205010(Unit.GW)*000000000020(Unit.GW)*0.0252.5000000000000001E-2(Unit.GW)*0.28146972656250.28146972656250002(Unit.GW)*0.6350.635000000000000010.635000000000000010.635000000000000010.635000000000000010.635000000000000010.635000000000000010.6350000000000000130(Unit.GW)*0.050.05(Unit.GW)*1.03906251.0390625(Unit.GW)*1.651.651.651.651.651.651.651.6540(Unit.GW)*0.050.05(Unit.GW)*1.03906251.0390625(Unit.GW)*4.14.09999999999999964.09999999999999964.09999999999999964.09999999999999964.09999999999999964.09999999999999964.09999999999999961280(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))0(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))2.5000000000000022E-32.8146972656250026E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-2717109124578480071573044220072010201520202025203020352040204520508INDEX(Vectors[Description], MATCH($C31, Vectors[Code], 0))Wind1090.240.240.240.240.240.240.240.240.240.2427388527425*Unit.kW4.9999999999999996E-6Preferences.PowerUnits&"peak"GWpeak2735(0.5/24%)*Unit.W/Unit.m22.0833333333333337E-3Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^24421098773170323532423340Preferences.moneyunits&"/"&Preferences.PowerUnits£m/GW200720102015202020252030203520402045205034051283.84/Unit.kW*GBP1283.83999999999991220.92*GBP/Unit.kW1220.921161.08*GBP/Unit.kW1161.081104.17*GBP/Unit.kW1104.171076.84*GBP/Unit.kW1076.83999999999991050.19*GBP/Unit.kW1050.191024.2*GBP/Unit.kW1024.2998.85*GBP/Unit.kW998.84999999999991974.13*GBP/Unit.kW974.13950.01*GBP/Unit.kW950.013406F50*$F$366.419199999999999E-3G50*$F$366.1046E-35.8053999999999988E-35.5208499999999999E-35.3841999999999987E-35.2509499999999999E-35.1209999999999997E-34.9942499999999987E-34.8706499999999998E-34.7500499999999996E-33341Preferences.moneyunits£m334227*GBP/Unit.kW*F361.3499999999999997E-43343812883Preferences.PowerUnitsGW7157944220072010201520202025203020352040204520508INDEX(Vectors[Description], MATCH($C63, Vectors[Code], 0))WindF200G202.5000000000000022E-32.8146972656250026E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-273120072010201520202025203020352040204520501997801Preferences.PowerUnitsGWF$630G$632.5000000000000022E-32.8146972656250026E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-2833800F$310.24G$310.240.240.240.240.240.240.240.240.248351260F71*F7206.0000000000000049E-46.7552734375000058E-31.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-21.5240000000000012E-2548Preferences.EnergyUnitsTWhF73*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy05.2596000000000049E-35.9216726953125048E-20.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000132739"Approximate total "&$F$36/Unit.kW&"kW turbines"Approximate total 5kW turbines2740F71/$F$360G71/$F$36500.000000000000515629.394531250005512700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.0000000000132736Preferences.AreaUnitskm^2F71/$F$370G71/$F$371.200000000000000813.5105468750000130.48000000000002230.48000000000002230.48000000000002230.48000000000002230.48000000000002230.48000000000002230.4800000000000223238(G77-F77)/(G69-F69)166.66666666666683(H77-G77)/(H69-G69)1025.8789062500009(I77-H77)/(I69-H69)1414.1210937500014(J77-I77)/(J69-I69)0000003344G80166.66666666666683H801025.8789062500009I801414.1210937500014J8003345SUM(G80:G81)166.66666666666683SUM(H80:H81)1025.87890625000091414.121093750001400166.666666666666831025.87890625000091414.12109375000140318331763161F82*F510G82*G511.0174333333333343H82*H515.95563740234375427.8071504404296945000.853500000000000815.12349572753906566.8876889052734436031773161$E$54*F770$E$54*G776.750000000000006E-20.759968261718750651.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.714500000000001531843161SUM(F85:F86)0SUM(G85:G86)1.08493333333333446.71560566406250469.52165044042969551.71450000000000151.71450000000000152.56800000000000236.83799572753906668.60218890527344551.7145000000000015318531763161F82*F510G82*G511.01743333333333435.95563740234375427.8071504404296945000.853500000000000815.12349572753906566.8876889052734436031773161$E$54*F770$E$54*G776.750000000000006E-20.759968261718750651.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.714500000000001531843161SUM(F90:F91)0SUM(G90:G91)1.08493333333333446.71560566406250469.52165044042969551.71450000000000151.71450000000000152.56800000000000236.83799572753906668.60218890527344551.7145000000000015683729Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Electricity (supplied to grid)F740G745.2596000000000049E-35.9216726953125048E-20.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000130.133593840000000138INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Wind-F740-G74-5.2596000000000049E-3-5.9216726953125048E-2-0.13359384000000013-0.13359384000000013-0.13359384000000013-0.13359384000000013-0.13359384000000013-0.13359384000000013-0.13359384000000013148SUBTOTAL(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])0261326187826144426916927207217227237247257267272615"micro wind if "&ROUND($F$37*Unit.m2/Unit.W,0)&" Wpeak/m2"micro wind if 2 Wpeak/m2Preferences.AreaUnitskm^2F780G781.200000000000000813.5105468750000130.48000000000002230.48000000000002230.48000000000002230.48000000000002230.48000000000002230.48000000000002230.4800000000000222620INDEX(Vectors[Description], MATCH([Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF6302.5000000000000022E-32.8146972656250026E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-26.3500000000000056E-22621C77Approximate total 5kW turbines2740F770G77500.000000000000515629.394531250005512700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.00000000001312700.00000000001331893190Preferences.moneyunits£m784184426916927207217227237247257267273131INDEX(CostVectors[Description], MATCH(C119, CostVectors[Code], 0))Low estimate of capital costsF850G851.0174333333333343H855.95563740234375427.8071504404296945000.853500000000000815.12349572753906566.887688905273443603133INDEX(CostVectors[Description], MATCH(C120, CostVectors[Code], 0))Low estimate of operating costsF860G866.750000000000006E-20.759968261718750651.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000153135INDEX(CostVectors[Description], MATCH(C121, CostVectors[Code], 0))Low estimate of fuel costs3140INDEX(CostVectors[Description], MATCH(C122, CostVectors[Code], 0))High estimate of capital costsF900G901.0174333333333343H905.95563740234375427.8071504404296945000.853500000000000815.12349572753906566.887688905273443603142INDEX(CostVectors[Description], MATCH(C123, CostVectors[Code], 0))High estimate of operating costsF910G916.750000000000006E-20.759968261718750651.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000151.71450000000000153144INDEX(CostVectors[Description], MATCH(C124, CostVectors[Code], 0))High estimate of fuel costs