Skip to main content
A
Anonymous
September 28, 2023
Solved

Calculating whether you have hit the 12.5% target or not

  • September 28, 2023
  • 34 replies
  • 1568 views

The FAQ on this says:

 

Challenge Type: Peak Move - shift your non-essential electricity usage out of the peak (4-7pm each weekday). Your peak electricity usage must be 12.5% or less of your daily use to be rewarded £10 per month.

You may use 10kWh of electricity on a weekday (Monday to Friday). If, between 4pm and 7pm, you then use 2kWh of electricity, your peak electricity consumption for Monday would be 20%. 

A customer needs to average out to 12.5% or less of their monthly peak electricity usage to be successful.

 

However this still leaves some ambiguity. Are Ovo averaging the daily %ages (e.g. 10% on one day, 20% on another and 27% on a third averages out to 19%) or are they summing the peak hours usage for the month and dividing that by the total weekday usage?

The two methods may give quite different results.

 

    Best answer by ima

    All the advice on how to calculate this is all great! Another method not mentioned is to connect to their API and get the half hourly usage from there - no need to manually write down or calculate anything.

     

     

    … but it still baffles me why Ovo just doesn’t provide a running tally on their website. 

    34 replies

    Show previous replies
    BPLightlog
    Super User
    BPLightlogSuper User
    Super User
    October 7, 2023

    Whilst overall the data is recovered, it’s not always back filled with half hour slots as this is not as important for billing (except for ToU)

    ToU billing depends on meter readings on the different ToU registers, not on the Hh usage figures.
      

    Not sure about that .. my tariff now has different half hourly pricing but my meter only has 2 registers as far as I know. 
     

    Having looked in detail at my pre-move data, I can see lots of days with missing data. I can see it’s there via Hugo/Bright etc but missing in the OVO feed

     

    Bring me Sunshine ~ E&E {Solar PV, Battery Storage, Hybrid EV, ASHP and Home Assistant automation}
    A
    Newcomer
    Alandamore
    Newcomer
    October 8, 2023

    It does seem a rather hit and miss - will try again later in the month; I’ve got two Ovo accounts, glowmarkt is the only fully working 30min 3-digit download for both, here’s my experience, yours clearly vary! Downloads from all of the non-Ovo sources below can be pasted straight into my Power Move spreadsheet (Guylipman format needs columns A&E, all others A&B).

    Home account:

    • smarttariffsmartcomparison.org: no data after 2nd Oct - emailed, got a swift reply saying prototype service, try my account, now activated on glowmarkt.
    • glowmarkt.com: All 30min data available - so far working a treat!
    • n3rgy.com: 30min 3 digit available BUT has a 2-day missing block (02/03 Oct) - emailed support Fri PM.
    • guylipman.com: (not surprisingly) same gaps as n3rgy.com @Firedog 
    • Ovo Website and app: All recent 30min data visible (to 2 digits), app's 30min download only possible day-by-day and then not datestamped (so not suitable for easy Excel processing). That itself is the subject of this forum.

    Shared Driveway account:

    • smarttariffsmartcomparison.org: Same issue as above, so asked for glowmarkt activation, again got a very quick positive reply.
    • glowmarkt.com: All 30min data available - so far working a treat!
    • n3rgy.com: Keeps saying "Unsuccessful Consent" retry later.
    • Ovo Website and app: Same as above

     

    A
    Anonymous
    October 8, 2023

    Somebody has marked this solved by a post that is clearly not solving it. Can this be undone?


    I would say that my original query was solved a long time ago in this thread but by far the most useful contribution has come from @Alandamore who deserves great credit for both his spreadsheet and his work on data access. 

    A
    Anonymous
    October 11, 2023

    More about monitoring…

     

    Building on the excellent work done by @Alandamore (and stealing his spreadsheet), I have produced a visual monitoring tool which you are welcome to access by clicking here.

     

    Instructions:

    1. Set parameters (currently set for Autumn PM Challenge)
    2. Download data from Glowmarkt and paste into the appropriate sheet
    3. Adjust the size of the Calculations table to accommodate all the data up to the end of the last full day’s data (you can leave a part day but it will give a zero reading for that day at the end of the graph)
    4. Right click anywhere on the pivot table and click Refresh
    5. View monitoring chart.

    I hope you find this useful.

      Terms & ConditionsAccessibility statement

      OVO Energy Ltd, Floor 5, Crescent, Temple Back, Redcliffe, BS1 6EZ, (Company no. 06890795) registered in England and Wales.

      OVO (S) Gas Limited is registered in England and Wales (Company No. 02716495) at Floor 5, Crescent, Temple Back, Redcliffe, BS1 6EZ.

      OVO (S) Gas Limited is part of OVO Group Ltd