Another Power Move Homemade Spreadsheet

@waltyboy are you sure you are not ½ hour out? I was pasting the data in so 0:30 on the glowmarkt spreadsheet match 0:30 on yours. That is assuming that the 0:30 was the power used between 0:00 and 0:00. But that doesn’t seem to be right. I turned on the oven at 7pm last night, and the heater at 8. This is what I see on the ovo site

And this is what I get from glowmarkt

So it seems like the usage between 0:00 and 0:30 is marked as 0:00

Or have I misunderstood your data?

Hi @joanx, I’m not at all sure that I’m not half an hour out…it looks like you could well be right…I did notice that Noel @Firedog starts his daily segment at 00.00 and finishes at 23.30, and then I forgot!  So I may well have misunderstood the correct start and end of each day.

Back to the drawing board!

Many thanks for reminding me to re-examine this, it’s something I’ve never been entirely certain about.

And thank you for having a look at the spreadsheet…it’s very clunky anyway and needs a fair bit of streamlining, even apart from the wrong data entry points. There are some truly awful IF formulae lurking about, apart from anything else! 
 

 I noticed this morning a tiny bit of formatting at Cell AN58 weekday average kWh (needs formatting to be a number to three places of decimals, rather than auto) and for the corresponding weekday average kWh cell in each of the two tables in sheet 1 and sheet 2, and that’s just the tiny things. Goodness knows what else may be awry…but it’s been a good intro to Mac Numbers for me. I shall continue to play with it quietly on my own!!

I will ask Tim@OVO to remove the post, as the template is so misleading….

All the very best…thanks again…

you’re welcome. It made a huge difference to me. I went from 14.4% to 8.1% over the last 3 days when I corrected it. I have been waiting to 7 to turn things on.

Gosh, now that is one huge correction! Impressive, too.

Keep up the good work! 
 

All the best….

Hi @joanx, looking on the Glowmarkt forum, it seems the important thing is to start the day when the meter’s time is midnight, not necessarily “actual” BST or GMT, so starting the day at 00.00 is the way to go. Plus it’s more logical, anyway!

Could make a huge difference for those folk on Economy7, of course, and as you’ve demonstrated, for any consumer in fact.

Bests again….

I’ve now removed the link to the spreadsheet, @waltyboy - due to the popularity of this post in views and comments I’m reluctant to destroy the whole thing… 

Very kind of you, thank you @Tim_OVO