Been throwing an Excel spreadsheet together as I wanted to have an idea of cost per kwh and the variance in the GivEnergy info versus the billing info from Octopus.
I've tried to get the total estimated cost to match the chart values on a couple of different days but the maths just doesn't add up. I've gone about it various way, starting with the total kwh and subtracting the usage outside of the Go tariff and the other way of adding up all the kwh usage in the Go tariff window.
End result is that I can't get the total cost to where it needs to be even by adding the standing charge - which I'm not entirely sure is there either. If I add the standing charge it does get closer and looking at the table data and not the chart some of my 30 minute low level consumption obviously isn't enough to show on the chart due to scaling, this will get me closer to that Estimated Total Cost figure but its still off.
Example: 26 Nov 21 using highest pricing value)
Total Kwh Used: 26.916 kwh (Table Value) Octopus recorded value of 26.92kwh
Total Estimated Cost: £2.003
Total peak kwh used: 2.133 @ £0.231395 = £0.49355 (from table not chart)
Total off peak kwh used: 24.783 @ £0.05 = £1.23945
Total off peak and on peak used: £1.733
Electricity used plus standing charge @ £0.1835 = £1.9165
@simon_swinburne can you advise if the standard charge is included in the 'Total Estimated Cost' figure and if there is a calculation error somewhere?
