Could you be the Wind God?

Scenario: You have been appointed the UK Government's minister responsible for smoothing out the intermittent output from renewable wind and solar PV electricity generation. You're going to do this by specifying storage technology that can store and release power according to variations in supply, rather than relying on coal and gas power stations stopping and starting to balance the grid. Your policy will then be tested against actual 2019 daily data provided courtesy of GRIDWATCH

Unofficially your job title is THE WIND GOD

Minister, we now need you to make some policy decisions, including the total storage capacity (in MW-h) and its instantaneous power rating (in MW). The storage facility (or facilities) can either consume power to charge the storage or generate power, as the storage is discharged. For example if you specified 144,000 MW-h of storage and a 2,000 MW power rating, that is 3 days storage full-to-empty (2,000 MW x 24 h/d x 3 d)

The average power output from wind and solar PV is 6700 MW - and we'd like you to treat that as a target - but it won't be easy.

In 2019, minimum output has been as low as 1,000 MW, maximum in excess of 12,000 MW. On days when wind and solar PV power exceeds the target, the excess will be automatically put into storage, up to the maximum power rating you specified - and provided there is spare capacity in the store. On days when wind and solar PV power is below the target, power will be drawn automatically from storage, again up to the maximum power rating, on condition the store is not completely depleted at the time.

However much storage you allocate, we'll ensure it is 50% charged at the start of day 1 (January 1st 2019)

What power rating should the system have in MW?
And how much storage should be allocated in MW-h?

Your assessment, minister: Net output was 1000 MW or more over the target on 46 days out of 212. On such days we would have to pay generators to shut down operation. Net output fell 1000 MW or more under target on 44 days out of 212 and on these days we would have to purchase standby power most likely using fossil fuel. Your proposed storage would require 10 Coire Glas scale storage schemes at an estimated cost of £8 billion

Overall, we'd rate your performance at 50 % - quite good, Minister! Here are the full results:

2019WindSolarWind+SolarIn/OutReserveNet W+S
Day:MWMWMWMWMW-hMW
1626370169642001443006764
221424962638-2000963004638
313663521718-2000483003718
424027053107-20003005107
5268885277303002773
61651300195103001951
710257230104872000483008487
893001000103002000963008300
9420310765279-1400627006679
1032552493504-2000147005504
1149843535337-6003005937
1210868214110822000483009082
1310642418110602000963009060
14636463369972001011006797
1598425011034320001491008343
168810254906420001971007064
1768641583844716002355006847
186011651666202355006662
1938794394318-20001875006318
20181510342849-20001395004849
2149908645854-8001203006654
2243399665305-1200915006505
23163411232757-2000435004757
246913671058-18003002858
25905170497552000483007755
26929347697692000963007769
2799258481077320001443008773
2860671822788910001683006889
2944843924876-18001251006676
30239816244022-2000771006022
3130008533853-2000291005853
3249097105619-100051006619
3353281672700020099006800
34581014997309600243006709
35744979882471400579006847
3657693176086-600435006686
37641710807497600579006897
3875371693923020001059007230
39112104681167820001539009678
40980614291123520002019009235
4152779016178-4001923006578
42263415694203-20001443006203
437907940884720001923006847
4485531389994220002403007942
455507197074776002547006877
4667882774956210002787008562
477962796875802787008758
489892149911391027870011391
49945794310400027870010400
5070181714873202787008732
519162103010192027870010192
5262061583778902787007789
5363552217857202787008572
5463022050835202787008352
55234828685216-14002451006616
56210528594964-16002067006564
57178932044993-16001683006593
58106629424008-20001203006008
5918808112691-2000723004691
6019788122790-2000243004790
617560108686461800675006846
628404491889520001155006895
63947118011127220001635009272
6463292336866518002067006865
658759731949020002547007490
669772134311115100027870010115
6767401230797002787007970
688970248211452027870011452
6973452042938702787009387
709356315212508027870012508
71999674510741027870010741
7210207186912076027870012076
739871210611977027870011977
749431139310824027870010824
758228656888402787008884
769175230111476027870011476
77236517804145-20002307006145
78388415935477-12002019006677
7949471656660302019006603
80343313394772-18001587006572
81667676974456001731006845
82424721086355-2001683006555
83717533781055320002163008553
8461863453963920002643007639
85403522586293-4002547006693
86387218405712-8002355006512
87373326706403-2002307006603
883860322870882002355006888
89237122904661-20001875006661
90420421076311-2001827006511
9150452724776910002067006769
92270617124418-20001587006418
93445919276386-2001539006586
9473081371867918001971006879
9576101604921420002451007214
96303320235056-16002067006656
97384214865328-12001779006528
98402320896112-4001683006512
995708158172894001779006889
10035713287685801779006858
101206235485610-10001539006610
102410123386439-2001491006639
103686532461011120001971008111
104810622751038120002451008381
1058740343712177140027870010777
10652041593679702787006797
10737113233694402787006944
10849403376831602787008316
10932493802705102787007051
110177533865161-14002451006561
111307333166389-2002403006589
11252252989821414002739006814
1135884216780512002787007851
11461211985810602787008106
11556731859753202787007532
11676402073971302787009713
11779861930991602787009916
118330119915292-14002451006692
119120622343440-20001971005440
120107026983768-20001491005768
12156317392302-20001011004302
122258320284611-2000531006611
123355613734929-1600147006529
12474422992104342000627008434
1254351225566060627006606
126163823864024-2000147006024
127112321523275-6003003875
1286841120980501200291006850
129317215344706-12003005906
1306822433311503003115
13118252735456003004560
1327963471426703004267
13314203576499603004996
13414323838527003005270
13518583471532903005329
1364936320981451400339006745
137372214765198-14003006598
1389651679264403002644
1396582067272503002725
14013672645401203004012
14118403526536603005366
14225562006456203004562
143405933207379600147006779
144335327876140-40051006540
145185827514609-2003004809
1467282186291442000483007144
147380622956101-400387006501
148204824224470-16003006070
14938951583547803005478
1506864238092442000483007244
1515878198878661000723006866
152316928826051-600579006651
15371972140933720001059007337
15468632877974020001539007740
155247015434013-20001059006013
156312621525278-1400723006678
157221931255344-1200435006544
158474413696113-400339006513
1596429188083091600723006709
160191725674484-2000243006484
161262014144034-10003005034
1626215952716740099006767
16362579997256400195006856
164632711017428600339006828
165408622466332-200291006532
166391221416053-600147006653
167484823487196400243006796
1686334246387972000723006797
169334319335276-1400387006676
170158618353421-16003005021
17138442626647003006470
17224412808524903005249
17315273304483103004831
17444741727620103006201
17529501638458803004588
17636171223484003004840
17736561982563803005638
178358337457328600147006728
1794654326179151200435006715
180317130406211-400339006611
18184352769112042000819009204
182812423971052120001299008521
183371925546273-4001203006673
184262434946118-4001107006518
1854179349076698001299006869
186347329976470-2001251006670
187290719644871-1800819006671
188162926754304-2000339006304
189104327013744-14003005144
19010971735283203002832
19115332580411303004113
19216532527418003004180
19333562912626803006268
19431482161530903005309
19518722120399203003992
1968562497335303003353
1976812746342703003427
19837922132592403005924
19935762209578503005785
20039821060504203005042
2015566240279681200291006768
202494324137356600435006756
20381582402105602000915008560
2044315299873136001059006713
20540872643673001059006730
2064912268475968001251006796
207315115764727-1800819006527
208291510994014-2000339006014
209397214085380-120051006580
210210425744678-2003004878
21142911458574903005749
212584516247469600147006869