Having had a few more requests (apologies for the delay), I've finally found time to create a quick spreadsheet for generating the data required for setting export schedules to maximise battery usage, and hopefully provide the most income.
Here's the link *:
https://docs.google.com/spreadsheets/d/1oOK-O3XxgLdF2rp2sPY7Fg8gReSeukx-fq_pPa42PeE/edit?usp=sharing
It's protected, so please make a copy, so as not to mess up the original for others.
It's not very sophisticated, and I have a backup, so no real harm done, just a PIA.
When you open the "Calculation" page, it should look like this:
If it doesn't, someone has broken it.
You only need to enter 4 pieces of info (5 if you want to change the end time) in the green cells, the rest is calculated.
Then, create a schedule, like this:
Don't forget to save the schedule.
Having created as many schedules as you need, you should have something like this:
Depending on how sunny it's been, and how much household consumption you've had, the schedules will either run or not based on the current battery SoC.
However, by fully using the battery everyday, this should also reduce/eliminate SoC jumps (where the battery doesn't know how much charge it really has).
On a good day, you'll end up with full battery utilisation, having maximised your export.
I've been fine tuning mine a little, and typically end up with this sort of thing:
Please feel free to use, ignore, adjust as you like, and offer any feedback or suggestions that may help others.
Good luck!
Disclaimer:
I'm not a software specialist, IT guru, spreadsheet nerd. Don't shoot me if it doesn't work.
You may get a small amount of grid draw between the last export and start of the cheap period, it will be a few pence, don't panic. If this bothers you, shorten the last period by 5 mins.
If you're wondering why so many schedules, you have more granular control with a large number of short blocks compared to a smaller number of long blocks.
Anyone with an AIO or plant setup may want to consider running 15 or 20 min slots, rather than the 30, to give the same level of control due to the higher discharge rates.
Although designed for Intelligent Octopus Go, you could use with other tariffs but, check your import/export rates to see if it's worth it.
- Link updated 19/06/25
now protected, so you must "make a copy"
