Home  5  Books  5  GBEzine  5  News  5  HelpDesk  5  Register  5  GreenBuilding.co.uk
Not signed in (Sign In)

Categories



Green Building Bible, Fourth Edition
Green Building Bible, fourth edition (both books)
These two books are the perfect starting place to help you get to grips with one of the most vitally important aspects of our society - our homes and living environment.

PLEASE NOTE: A download link for Volume 1 will be sent to you by email and Volume 2 will be sent to you by post as a book.

Buy individually or both books together. Delivery is free!


powered by Surfing Waves




Vanilla 1.0.3 is a product of Lussumo. More Information: Documentation, Community Support.

Welcome to new Forum Visitors
Join the forum now and benefit from discussions with thousands of other green building fans and discounts on Green Building Press publications: Apply now.




    • CommentAuthordereke
    • CommentTimeDec 26th 2020 edited
     
    There have been a few threads recently about Octopus Agile so I thought I might as well start one!

    I've recently been through the exercise of analysing my usage to figure out whether it would be cheaper to switch to the agile tariff. I ended up comparing my last 10mnths usage with the half hourly prices from octopus to determine how much it would have cost me with them. The result was around £500 cheaper and that was before load shifting. I have an EV and heatpump so use a lot of leccy, you might not save as much!

    Anyway long story short, I decided to build a website to let people compare their usage. At the moment it just straight up gives you a figure. I plan to add some more analysis like telling you how much peak usage you had so you can figure out how much you can load shift.

    Free to use, all the analysis happens in browser so you are not uploading any data. If you like it my referral code is there but no worries either way. If you happen to be with OVO there is also a link to a tool to help you download your OVO usage data.

    https://agilecomparison.com

    I hope this isn't too much self promotion :shamed:
    • CommentAuthorEd Davies
    • CommentTimeDec 27th 2020
     
    Interesting, what timezone is used in the CSV file? Just UTC (“GMT”) or does it use BST in the summer?
    • CommentAuthordereke
    • CommentTimeDec 27th 2020
     
    Posted By: Ed DaviesInteresting, what timezone is used in the CSV file? Just UTC (“GMT”) or does it use BST in the summer?


    The agile rates come as UTC so as long as you have UTC dates in the csv file it should match up!
    • CommentAuthorEd Davies
    • CommentTimeDec 27th 2020
     
    Wrote a little Python script to export readings from my CurrentCost meter in this format. First attempt failed with an error saying to open it in a spreadsheet and check it looked like a certain format but with no particular clue as to the actual problem. My first guess turned out to be right - it's sensitive to the number of decimal places in the energy readings, when I rounded them to 3 digits after the decimal point it no longer gave that error.

    However, after filling the other stuff, pressing the Calculate button didn't do anything (well, nothing apparent). Here's the data I was trying, from midday yesterday until I took a snapshot of my database earlier this evening:

    2020-12-26T12:00,2020-12-26T12:30,0.082
    2020-12-26T12:30,2020-12-26T13:00,0.072
    2020-12-26T13:00,2020-12-26T13:30,0.044
    2020-12-26T13:30,2020-12-26T14:00,0.223
    2020-12-26T14:00,2020-12-26T14:30,0.164
    2020-12-26T14:30,2020-12-26T15:00,0.188
    2020-12-26T15:00,2020-12-26T15:30,0.182
    2020-12-26T15:30,2020-12-26T16:00,0.151
    2020-12-26T16:00,2020-12-26T16:30,0.195
    2020-12-26T16:30,2020-12-26T17:00,0.186
    2020-12-26T17:00,2020-12-26T17:30,0.179
    2020-12-26T17:30,2020-12-26T18:00,0.196
    2020-12-26T18:00,2020-12-26T18:30,0.158
    2020-12-26T18:30,2020-12-26T19:00,0.755
    2020-12-26T19:00,2020-12-26T19:30,0.18
    2020-12-26T19:30,2020-12-26T20:00,0.175
    2020-12-26T20:00,2020-12-26T20:30,0.2
    2020-12-26T20:30,2020-12-26T21:00,0.189
    2020-12-26T21:00,2020-12-26T21:30,0.189
    2020-12-26T21:30,2020-12-26T22:00,0.214
    2020-12-26T22:00,2020-12-26T22:30,0.18
    2020-12-26T22:30,2020-12-26T23:00,0.112
    2020-12-26T23:00,2020-12-26T23:30,0.794
    2020-12-26T23:30,2020-12-27T00:00,0.017
    2020-12-27T00:00,2020-12-27T00:30,0.014
    2020-12-27T00:30,2020-12-27T01:00,0.013
    2020-12-27T01:00,2020-12-27T01:30,0.014
    2020-12-27T01:30,2020-12-27T02:00,0.014
    2020-12-27T02:00,2020-12-27T02:30,0.014
    2020-12-27T02:30,2020-12-27T03:00,0.014
    2020-12-27T03:00,2020-12-27T03:30,0.014
    2020-12-27T03:30,2020-12-27T04:00,0.032
    2020-12-27T04:00,2020-12-27T04:30,0.039
    2020-12-27T04:30,2020-12-27T05:00,0.02
    2020-12-27T05:00,2020-12-27T05:30,0.015
    2020-12-27T05:30,2020-12-27T06:00,0.015
    2020-12-27T06:00,2020-12-27T06:30,0.034
    2020-12-27T06:30,2020-12-27T07:00,0.062
    2020-12-27T07:00,2020-12-27T07:30,0.046
    2020-12-27T07:30,2020-12-27T08:00,0.07
    2020-12-27T08:00,2020-12-27T08:30,0.065
    2020-12-27T08:30,2020-12-27T09:00,0.066
    2020-12-27T09:00,2020-12-27T09:30,0.078
    2020-12-27T09:30,2020-12-27T10:00,0.085
    2020-12-27T10:00,2020-12-27T10:30,0.377
    2020-12-27T10:30,2020-12-27T11:00,0.526
    2020-12-27T11:00,2020-12-27T11:30,0.092
    2020-12-27T11:30,2020-12-27T12:00,0.06
    2020-12-27T12:00,2020-12-27T12:30,0.087
    2020-12-27T12:30,2020-12-27T13:00,0.067
    2020-12-27T13:00,2020-12-27T13:30,0.015
    2020-12-27T13:30,2020-12-27T14:00,0.016
    2020-12-27T14:00,2020-12-27T14:30,0.016
    2020-12-27T14:30,2020-12-27T15:00,0.015
    2020-12-27T15:00,2020-12-27T15:30,0.078
    2020-12-27T15:30,2020-12-27T16:00,0.24
    2020-12-27T16:00,2020-12-27T16:30,0.126
    2020-12-27T16:30,2020-12-27T17:00,0.076
    2020-12-27T17:00,2020-12-27T17:30,0.088
    2020-12-27T17:30,2020-12-27T18:00,0.065
    2020-12-27T18:00,2020-12-27T18:30,0.074
    2020-12-27T18:30,2020-12-27T19:00,0.447
    2020-12-27T19:00,2020-12-27T19:30,0.182
    • CommentAuthordereke
    • CommentTimeDec 27th 2020
     
    Thanks for testing this Ed!
    I think I've managed to fix it - the error was misleading.

    It seems in the few days since I last tested this the size of the the data files containing the rates had grown to a point where they were getting truncated.

    Anyway your sample file above is now giving me results so hopefully it will work OK for you now!
    • CommentAuthorborpin
    • CommentTimeDec 28th 2020
     
    The OpeneEnergy Monitor team have a piece of software called emoncms. Within that is an 'Agile' module that will tell you what your measured usage would have cost on Agile.
    • CommentAuthorjms452
    • CommentTimeDec 28th 2020
     
    'How to figure out if octopus agile is worth it?'

    Switch to octopus and try it for a couple of months.

    Like many energy companies they have a referral scheme where if you follow a link from an existing customer you get £50 credit - So worst case over a couple of months I predict it will be worth it.

    Whisper if you need a link ;)
    • CommentAuthorEd Davies
    • CommentTimeDec 28th 2020 edited
     
    Nice:

    Results
    1 Jan 2020 12:00AM to 27 Dec 2020 10:30PM
    Total Usage 1,675kWh
    Cost with current supplier £284.82
    Cost with Octopus Agile £197.76
    You would have saved £87.06 if you were on Octopus Agile


    That's a slight under-estimate of my electricity usage; from 18:00 on New Year's Eve at the end of 2019 until 18:42 this evening meter readings say I used 1788 kWh. The CurrentCost meter, as its name implies, only measures current. Maybe it's just experimental error or maybe the voltage is systematically higher than whatever the CC assumes (240 vs 230???). There're probably a few blocks of a few hours of missing data in there somewhere, too.

    Also, I just put 17p/kWh for my current price, I think it's 17.<something> but can't be bothered to look.

    Other than trying to run the washing machine on windy days (to use local organic electricity) I don't do anything particular to adjust my usage times. Actually, I don't think there's a lot I could do, anyway.

    BTW, why does it stop at 10:30 last night? The data I gave ran till about 17:30 today. Does Octopus regard more recent prices as “current” rather than “archive” or something?
    • CommentAuthordereke
    • CommentTimeDec 29th 2020 edited
     
    Oh great!
    It stopped the night before because I've not yet set up an automation to update the rates :facepalm:
    I really need to get the peak usage analysis in there. It may turn out that a small battery would get you through the peaks and if not save you money at least break even and save the grid some trouble.

    Posted By: jms452Switch to octopus and try it for a couple of months.


    The suck it and see approach is one way of doing it however you've got a lot more variables to account for. If you've got a smart meter then you can get hold of the data and get a definitive answer before switching with 0 risk, 0 cost AND you can still get a £50 credit if you follow a referral link - which is conveniently provided on my website :bigsmile:
Add your comments

    Username Password
  • Format comments as
 
   
The Ecobuilding Buzz
Site Map    |   Home    |   View Cart    |   Pressroom   |   Business   |   Links   
Logout    

© Green Building Press