76INDEX(Workstreams[Workstream], MATCH($A1, Workstreams[Code], 0))National renewable power generation804INDEX(Modules[Module], MATCH($A2, Modules[Code], 0))Wave and Tidal134582613401340III.c.Scenario113422376Preferences.PowerUnitsGW134079442200720102015202020252030203520402045205010(Unit.GW)*00(Unit.GW)*0.00152207001522071.5220700152207001E-3(Unit.GW)*0.08033147302553698.0331473025536906E-2(Unit.GW)*0.2008286825638420.20082868256384201(Unit.GW)*0.2008286825638420.20082868256384201(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00(Unit.GW)*0020(Unit.GW)*00(Unit.GW)*0.0152207001522071.5220700152207001E-2(Unit.GW)*0.08033147302553698.0331473025536906E-2(Unit.GW)*0.2008286825638420.20082868256384201(Unit.GW)*0.4016573651276850.40165736512768502(Unit.GW)*1.606629460510741.6066294605107401(Unit.GW)*3.614916286149163.6149162861491599(Unit.GW)*7.711821410451557.7118214104515497(Unit.GW)*9.639776763064439.639776763064430730(Unit.GW)*00(Unit.GW)*0.0535543153503585.3554315350357998E-2(Unit.GW)*0.1071086307007160.107108630700716(Unit.GW)*0.535543153503580.53554315350357995(Unit.GW)*1.071086307007161.0710863070071599(Unit.GW)*3.213258921021483.2132589210214801(Unit.GW)*6.962060995546546.9620609955465396(Unit.GW)*15.423642820903115.423642820903099(Unit.GW)*19.279553526128919.279553526128940(Unit.GW)*00(Unit.GW)*0.1801116184677830.18011161846778301(Unit.GW)*0.7804836800270590.78048368002705903(Unit.GW)*1.801116184677831.8011161846778301(Unit.GW)*3.602232369355663.6022323693556602(Unit.GW)*7.204464738711317.2044647387113097(Unit.GW)*15.009301538981915.0093015389819(Unit.GW)*28.817858954845228.8178589548452(Unit.GW)*36.022323693556636.0223236935566012377Preferences.PowerUnitsGW134079442200720102015202020252030203520402045205010(Unit.GW)*0.001585489599188231.5854895991882301E-3(Unit.GW)*0.006341958396752926.3419583967529204E-3(Unit.GW)*0.01585489599188231.5854895991882299E-2(Unit.GW)*0.03963723997970573.9637239979705703E-2(Unit.GW)*0.03963723997970573.9637239979705703E-2(Unit.GW)*00(Unit.GW)*00(Unit.GW)*00(Unit.GW)*0020(Unit.GW)*0.001585489599188231.5854895991882301E-3(Unit.GW)*0.006341958396752926.3419583967529204E-3(Unit.GW)*0.01585489599188231.5854895991882299E-2(Unit.GW)*0.03963723997970573.9637239979705703E-2(Unit.GW)*0.07927447995941157.9274479959411503E-2(Unit.GW)*0.3170979198376460.31709791983764601(Unit.GW)*0.7134703196347030.71347031963470298(Unit.GW)*1.52207001522071.5220700152207001(Unit.GW)*1.902587519025881.902587519025880130(Unit.GW)*0.001585489599188231.5854895991882301E-3(Unit.GW)*0.02642482665313722.6424826653137199E-2(Unit.GW)*0.05284965330627435.2849653306274301E-2(Unit.GW)*0.2642482665313720.26424826653137201(Unit.GW)*0.5284965330627430.52849653306274302(Unit.GW)*1.585489599188231.5854895991882301(Unit.GW)*3.435227464907833.4352274649078298(Unit.GW)*7.61035007610357.6103500761034999(Unit.GW)*9.512937595129389.512937595129379540(Unit.GW)*0.001585489599188231.5854895991882301E-3(Unit.GW)*0.10781329274480.1078132927448(Unit.GW)*0.4671909352274650.46719093522746502(Unit.GW)*1.0781329274481.078132927448(Unit.GW)*2.156265854895992.1562658548959899(Unit.GW)*4.312531709791984.3125317097919798(Unit.GW)*8.984441062066638.9844410620666295(Unit.GW)*17.250126839167917.250126839167901(Unit.GW)*21.562658548959921.5626585489598992381Preferences.PowerUnitsGW134079442200720102015202020252030203520402045205010(Unit.GW)*000000000020(Unit.GW)*000(Unit.GW)*0.30.3(Unit.GW)*0.30.3(Unit.GW)*0.70.7(Unit.GW)*0.70.7(Unit.GW)*1.7251.7250000000000001(Unit.GW)*1.7251.7250000000000001(Unit.GW)*1.7251.72500000000000013000(Unit.GW)*0.80.8(Unit.GW)*0.80.8(Unit.GW)*4.34.3(Unit.GW)*4.34.3(Unit.GW)*1313(Unit.GW)*1313(Unit.GW)*13134000(Unit.GW)*4.34.3(Unit.GW)*1313(Unit.GW)*1313(Unit.GW)*1414(Unit.GW)*1616(Unit.GW)*1919(Unit.GW)*20207842643Preferences.PowerUnitsGW13407944220072010201520202025203020352040204520501011111111120111111111301111111114011111110.842105263157894690.8202771573044220072010201520202025203020352040204520501020.250.250.250.250.250.250.250.250.250.25923790.40.40.40.40.40.40.40.40.40.4926440.240.240.240.240.240.240.240.240.240.24926450.20.20.20.20.20.20.20.20.20.244210923782382192371573044220072010201520202025203020352040204520501020.90.90.90.90.90.90.90.90.90.9923790.90.90.90.90.90.90.90.90.90.9923800.950.950.950.950.950.950.950.950.950.952927852943117750*2*Unit.kW1.5E-3Preferences.PowerUnits&"peak"GWpeak294211840*Unit.kW*25%*Conversion.to.annual.energy*1000*90%7.8894000000000006E-2Preferences.EnergyUnits&"/km wavefront/y"TWh/km wavefront/y2945440240*Unit.MW0.24Preferences.PowerUnits&"peak"GWpeak2947454(3.5/25%)*Unit.W/Unit.m21.4000000000000002E-2Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^230554622*Unit.MW2E-3Preferences.PowerUnits&"peak"GWpeak2951464(6/40%)*Unit.W/Unit.m21.5000000000000003E-2Preferences.PowerUnits&"peak/"&Preferences.AreaUnitsGWpeak/km^244211729441183104440294645429484622952464295381373117982383802Preferences.PowerUnitsGWINDEX(F$15:F$18, MATCH($E$7, $C$15:$C$18, 0))0INDEX(G$15:G$18, MATCH($E$7, $C$15:$C$18, 0))01.5220700152207001E-38.0331473025536906E-20.200828682563842010.200828682563842010000834771F$560.25G$560.250.250.250.250.250.250.250.250.258341923F$680.9G$680.90.90.90.90.90.90.90.90.98362012F99*F100*F1010G99*G100*G10103.4246575342465754E-41.8074581430745803E-24.5186453576864453E-24.5186453576864453E-20000548Preferences.EnergyUnitsTWhF102*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy003.0020547945205484E-30.15844178082191770.396104452054793830.3961044520547938300002384802Preferences.PowerUnitsGWINDEX(F$25:F$28, MATCH($E$7, $C$25:$C$28, 0))0INDEX(G$25:G$28, MATCH($E$7, $C$25:$C$28, 0))1.5854895991882301E-36.3419583967529204E-31.5854895991882299E-23.9637239979705703E-23.9637239979705703E-20000834771F$570.4G$570.40.40.40.40.40.40.40.40.48341923F$690.9G$690.90.90.90.90.90.90.90.90.98362012F107*F108*F1090G107*G108*G1095.7077625570776296E-42.2831050228310518E-35.7077625570776287E-31.4269406392694054E-21.4269406392694054E-20000548Preferences.EnergyUnitsTWhF110*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy05.0034246575342495E-32.0013698630136998E-25.0034246575342486E-20.125085616438356080.1250856164383560800002385802Preferences.PowerUnitsGWINDEX(F$35:F$38, MATCH($E$7, $C$35:$C$38, 0))0000000000834771(INDEX($F$48:$O$51,MATCH($E$7,$C$48:$C$51,0),MATCH(F$67,$F$47:$O$47,0))*F$58)+((1-(INDEX($F$48:$O$51,MATCH($E$7,$C$48:$C$51,0),MATCH(F$67,$F$47:$O$47,0))))*F$59)0.2(INDEX($F$48:$O$51,MATCH($E$7,$C$48:$C$51,0),MATCH(G$67,$F$47:$O$47,0))*G$58)+((1-(INDEX($F$48:$O$51,MATCH($E$7,$C$48:$C$51,0),MATCH(G$67,$F$47:$O$47,0))))*G$59)0.240.240.240.240.240.240.240.240.248341923F$700.95G$700.950.950.950.950.950.950.950.950.958361263F115*F116*F1170G115*G116*G117000000000548Preferences.EnergyUnitsTWhF118*Preferences.Unit.Power*Unit.year/Preferences.Unit.Energy00000000002928294029572929F99/$F$750G99/$F$7501.014713343480466753.554315350357939133.88578837589466133.88578837589466000029411368F104/$F$760G104/$F$7603.8051750380517509E-22.00828682563842255.02071706409605065.02071706409605060000295029582929F107/$F$7900.792744799594115033.17097919837646017.927447995941149919.81861998985285219.81861998985285200002960Preferences.AreaUnitskm^2F107/$F$8000.105699306612548660.422797226450194631.05699306612548652.64248266531371322.64248266531371320000294929592929F115/$F$770G115/$F$770000000003056Preferences.AreaUnitskm^2F115/$F$780G115/$F$780000000006832720Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH(III.c.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F104+F120+F1120G104+G120+G1125.0034246575342495E-3H104+H120+H1122.3015753424657545E-20.208476027397260180.521190068493149860.52119006849314986000O104+O120+O112010INDEX(Vectors[Description], MATCH(III.c.Outputs[Vector], Vectors[Code], 0))Wave-F1040-G1040-3.0020547945205484E-3-0.1584417808219177-0.39610445205479383-0.3961044520547938300009INDEX(Vectors[Description], MATCH(III.c.Outputs[Vector], Vectors[Code], 0))Tidal-(F120+F112)0-(G120+G112)-5.0034246575342495E-3-2.0013698630136998E-2-5.0034246575342486E-2-0.12508561643835608-0.125085616438356080000148SUBTOTAL(109,III.c.Outputs[2007])0SUBTOTAL(109,III.c.Outputs[2010])0SUBTOTAL(109,III.c.Outputs[2015])0SUBTOTAL(109,III.c.Outputs[2020])0SUBTOTAL(109,III.c.Outputs[2025])0SUBTOTAL(109,III.c.Outputs[2030])0SUBTOTAL(109,III.c.Outputs[2035])0SUBTOTAL(109,III.c.Outputs[2040])0SUBTOTAL(109,III.c.Outputs[2045])0SUBTOTAL(109,III.c.Outputs[2050])02721Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH(III.c.Wave.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F1040G10403.0020547945205484E-30.15844178082191770.396104452054793830.39610445205479383000O104010INDEX(Vectors[Description], MATCH(III.c.Wave.Outputs[Vector], Vectors[Code], 0))Wave-F1040-G1040-3.0020547945205484E-3-0.1584417808219177-0.39610445205479383-0.39610445205479383000-O10409INDEX(Vectors[Description], MATCH(III.c.Wave.Outputs[Vector], Vectors[Code], 0))Tidal0000000000148SUBTOTAL(109,III.c.Wave.Outputs[2007])0SUBTOTAL(109,III.c.Wave.Outputs[2010])0SUBTOTAL(109,III.c.Wave.Outputs[2015])0SUBTOTAL(109,III.c.Wave.Outputs[2020])0SUBTOTAL(109,III.c.Wave.Outputs[2025])0SUBTOTAL(109,III.c.Wave.Outputs[2030])0SUBTOTAL(109,III.c.Wave.Outputs[2035])0SUBTOTAL(109,III.c.Wave.Outputs[2040])0SUBTOTAL(109,III.c.Wave.Outputs[2045])0SUBTOTAL(109,III.c.Wave.Outputs[2050])02722Preferences.EnergyUnitsTWh7841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH(III.c.TidalStream.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F1120G1125.0034246575342495E-32.0013698630136998E-25.0034246575342486E-20.125085616438356080.12508561643835608000010INDEX(Vectors[Description], MATCH(III.c.TidalStream.Outputs[Vector], Vectors[Code], 0))Wave00000000009INDEX(Vectors[Description], MATCH(III.c.TidalStream.Outputs[Vector], Vectors[Code], 0))Tidal-F1120-G112-5.0034246575342495E-3-2.0013698630136998E-2-5.0034246575342486E-2-0.12508561643835608-0.125085616438356080000148SUBTOTAL(109,III.c.TidalStream.Outputs[2007])0SUBTOTAL(109,III.c.TidalStream.Outputs[2010])0SUBTOTAL(109,III.c.TidalStream.Outputs[2015])0SUBTOTAL(109,III.c.TidalStream.Outputs[2020])0SUBTOTAL(109,III.c.TidalStream.Outputs[2025])0SUBTOTAL(109,III.c.TidalStream.Outputs[2030])0SUBTOTAL(109,III.c.TidalStream.Outputs[2035])0SUBTOTAL(109,III.c.TidalStream.Outputs[2040])0SUBTOTAL(109,III.c.TidalStream.Outputs[2045])0SUBTOTAL(109,III.c.TidalStream.Outputs[2050])027237841844269169272072172272372472572672746INDEX(Vectors[Description], MATCH(III.c.TidalRange.Outputs[Vector], Vectors[Code], 0))Electricity (supplied to grid)F1200G12000000000010INDEX(Vectors[Description], MATCH(III.c.TidalRange.Outputs[Vector], Vectors[Code], 0))Wave00000000009INDEX(Vectors[Description], MATCH(III.c.TidalRange.Outputs[Vector], Vectors[Code], 0))Tidal-F1200-G120000000000148SUBTOTAL(109,III.c.TidalRange.Outputs[2007])0SUBTOTAL(109,III.c.TidalRange.Outputs[2010])0SUBTOTAL(109,III.c.TidalRange.Outputs[2015])0SUBTOTAL(109,III.c.TidalRange.Outputs[2020])0SUBTOTAL(109,III.c.TidalRange.Outputs[2025])0SUBTOTAL(109,III.c.TidalRange.Outputs[2030])0SUBTOTAL(109,III.c.TidalRange.Outputs[2035])0SUBTOTAL(109,III.c.TidalRange.Outputs[2040])0SUBTOTAL(109,III.c.TidalRange.Outputs[2045])0SUBTOTAL(109,III.c.TidalRange.Outputs[2050])027022954782703442691692720721722723724725726727301230201368F1250G12503.8051750380517509E-22.00828682563842255.02071706409605065.020717064096050600002710INDEX(Vectors[Description], MATCH(III.c.Wave.info[Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF990G9901.5220700152207001E-38.0331473025536906E-20.200828682563842010.200828682563842010000271129572929F1240G12401.014713343480466753.554315350357939133.88578837589466133.885788375894660000295578270344269169272072172272372472572672727643019Preferences.AreaUnitskm^2F1290G1290.105699306612548660.422797226450194631.05699306612548652.64248266531371322.642482665313713200002710INDEX(Vectors[Description], MATCH(III.c.TidalStream.info[Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF1070G1071.5854895991882301E-36.3419583967529204E-31.5854895991882299E-23.9637239979705703E-23.9637239979705703E-20000271130582929F1280G1280.792744799594115033.17097919837646017.927447995941149919.81861998985285219.8186199898528520000295678270344269169272072172272372472572672727643057Preferences.AreaUnitskm^2F1330G1330000000002710INDEX(Vectors[Description], MATCH(III.c.TidalRange.info[Vector], Vectors[Code], 0))Installed Capacity Preferences.PowerUnitsGWF1150G115000000000271130592929F1320G132000000000