Thanks - I actually finished this morning - not quite automatic, but from SQL, I read in the JSON schedules for the year, output to eight CSV files, which gets input into Google Calendar as individial calenders, these then get read from HA, depending on what stage it is, it references the relevant google calendar.
The google calendar process will take about 10 minutes to reload for a year if necessary.
View attachment 789219
Conditional card displays only when there is loadshedding
View attachment 789227
And then various automations to shut things down, and send notifications via telegram
How do you measure your whole house electricity?