Nonsensical target for Power Move Plus

@Firedog

Last night i went through the 3DP meter readings and they round up to the totals when you go into the half hrly daily break down table at the top. Also showed that rounding up is as per normal 5 to 9 goes up a digit and 4 and under stays the same.

However i still dont match the ovo mid mth email figure of 13.90%.

My 2DP half hrly figures 1st to 15th 4-6.30pm inclusive figure is 4.62 kwh (A)

My cumulative daily 3DP figure from meter readings is 33.039 kwh (B) and using the daily 2DP figure is 33.05 kwh (C)

A ÷ B = 13.983%

A ÷ C = 13.978%

So i would have expected to see my mid mth email target figure to be 13.98% 

Yes i realise its in my favour, but what am i doing wrong? 

I have a bit of OCD when it comes to things with figures, i find even 1p if my home accounts dont balance, i would never dream of writing in a balancing entry.🤣

Incidentally i am currently back under the target. Also my Sep figures matched for mid and end of mth, but Oct was further out than above yet the end of mth matched. It frustrated me then. Sep though had very little variance day to day in usage, whereas Oct started to towards end of the month.

You could try looking at the 3 dp half hourly figures from one of the 3rd party sources if you are only using 2 dp half hourly figures from ovo.

Join the club   🤗

That’s most probably where the error creeps in. If you’re seeing 3DP figures anywhere - in the meter readings, as you say - then the meter is most probably sending 3DP half-hourly usage figures. I’ll tack on at the bottom how you can find these without resorting to third-party data, although they should all be identical. I use n3rgy’s figures, helpfully provided as CSV by Guy Lipman’s excellent utility.

Brilliant!

Find OVO’s half-hourly data for your account to three places of decimals
  

This assumes you’re using Windows and Excel. The process will be similar for other software combinations. 

1. Open a new browser session in Microsoft Edge (Chrome should work, too, but I don’t know about other browsers).
2. Visit account.ovoenergy.com and sign in to cache an access token*.
3. Open a new tab in the same session and copy this URL into the address bar:
   https://smartpaymapi.ovoenergy.com/usage/api/half-hourly/1234567?date=2023-11-21
4. Substitute your own OVO account number for 1234567 and change the date to suit, then press Enter to open the page.

You should see a page of JSON with one set of data for each of the 48 half-hourly periods. You can copy the entire page and paste it as plain text into a fresh Excel worksheet, where it’s easy to extract the figures you need.

I massage it a bit by using Find & replace to get rid of some of the awkward bits: find space and replace with nothing, then find comma and replace with nothing. 

Select all the data and apply Filter, selecting only the rows starting with “consumption”

Then use Data > Text to columns > Delimited and select Other | colon (:).

You should end up with a column of 3DP figures for the 48 half-hours starting at midnight, ready to copy and paste into your working sheet.  
 

*  This token only lasts half an hour. If it expires while you’re working, you’ll see an error. Return to the account page and sign in again to clear it.
  

Get half-hourly data as CSV from n3rgy
  

Visit Smart Meter Reports (guylipman.com) and follow the prompts to create an n3rgy.com account. The steps to get CSV consumption data from Guy’s pages are pretty clear, but come back and ask for directions if you get lost.

The data are also available direct from the n3rgy site, but they’re not quite so simple to unravel.

To be clear n3rgy is a 3rd party @Firedog 

@Firedog 

@Jeffus 

Thank you for the instructions, which i will follow as funnily enough i just know the basics, well maybe a teeny bit more, but wouldnt  manage without them. I will have a play around this evening/tomorrow, so watch this space.😊

@Ria vote for this and add any comments if you think it would be useful 

OK, my language might have been a bit clumsy. I meant to point out that while it’s easy to access the data via third-party aggregators, it’s not the only way. I just happen to find the n3rgy/Lipman route the quickest and easiest.  

“Never have so few decimal places been scrutinised so closely by so many”

PS. I got my background from 18/19 watts up to 20/21 watts by switching on a kitchen switch that has a neon indicator. (Greedy one). I'll watch the online figures but I do expect those overnight 0.01s to become 0.02s

Yes, exactly.  Too many people getting bogged down by unnecessary analysis of figures. The whole point of a scheme like this is it should be simple.  You achieve the targets and get rewards, or you don't, and OVO must be in a position to clarify what is right or wrong.

I made a complaint to OVO based on the simple FACTS I have detailed earlier in this thread.  OVO checked the FACTS, not speculation about this decimal point or that, and promptly gave me compensation to cover all their failures. Result!  Simples!

How does anyone hit the power move target. Such a swizz. My house was empty with nothing on but the fridge and we didn’t hit the target. Very disappointed in OVO. 😡😡