This calculator will help you work out what savings or earnings might result from using Octopus Energy's Flux taruff with different types of solar and battery setup, as explained in the following video:
No warranty whatsoever is provided for use of any of the content referenced on this page. Use at your own risk. Check back here regularly for updates.
I've released a web-based utility, which does everything the spreadsheet does and more. If you'd like to try it out, click here.
V1.00 - initial release, as shown in the video (may still have bugs)
flux_calculator_ma_v1.xlsx - Mark A improvements:
Mark made some tweaks including the fix to the charge amount on the battery which was drawing too much. Mark also included a switch for the Go or Flux tariff (which is why he added the field for not fully charging the battery during the cheap window).