A most helpful guide, thanks for detailing your processes.
Gotta love your "WARNING: Do NOT download more than 1 year’s data at a time!" Yup, if all generation sources are selected, then at 5-minute intervals the resultant file is massive.
A few years ago I did a simple analysis of just one year's Wind vs Demand.
To make the data & file-size more manageable I culled 5 out of every 6 rows to represent ½-hourly settlement periods.
Then, I sorted the 'Wind' column Min>Max to trap a few examples of 'Zero'.
Those rows were temporarily colour-coded. Rows were resorted on Time/Date and the coloured Zeros manually infilled with a simple average between previous and subsequent non-zero readings.
That was sufficient for my needs of visually highlighting just how wildly variable the combined output of our fleet of geographically dispersed metered turbines is - on a per Settlement Period basis.
It showed that the claim "The wind is always blowing somewhere" was technically correct, but pragmatically near to useless.
Then along came Elexon's interactive Insights Solutions
It's not as finely tuneable as data from Gridwatch, but it saves a significant number of keystrokes and can produce a reasonable chart in less than a minute.
Hi Chris.
A most helpful guide, thanks for detailing your processes.
Gotta love your "WARNING: Do NOT download more than 1 year’s data at a time!" Yup, if all generation sources are selected, then at 5-minute intervals the resultant file is massive.
A few years ago I did a simple analysis of just one year's Wind vs Demand.
To make the data & file-size more manageable I culled 5 out of every 6 rows to represent ½-hourly settlement periods.
Then, I sorted the 'Wind' column Min>Max to trap a few examples of 'Zero'.
Those rows were temporarily colour-coded. Rows were resorted on Time/Date and the coloured Zeros manually infilled with a simple average between previous and subsequent non-zero readings.
That was sufficient for my needs of visually highlighting just how wildly variable the combined output of our fleet of geographically dispersed metered turbines is - on a per Settlement Period basis.
It showed that the claim "The wind is always blowing somewhere" was technically correct, but pragmatically near to useless.
Then along came Elexon's interactive Insights Solutions
https://bmrs.elexon.co.uk/generation-by-fuel-type
It's not as finely tuneable as data from Gridwatch, but it saves a significant number of keystrokes and can produce a reasonable chart in less than a minute.
Kind regards.