Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
View this topic in a long page with up to 500 replies per page Create new topic
1 | ... | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | ... | 132

CJC

CJC
53 posts

Master Geek


  #1683874 7-Dec-2016 13:22
Send private message

michaelmurfy:

 

Just battled Ruby (I hate Ruby so much... it never agrees with me) and got @mentalinc's script running. If anyone wants to try it then here is what you're needing to do:

 

Install Xubuntu (lightweight FTW). I went to the extreme and did the absolute minimum to get it going.

 

sudo apt purge firefox && apt autoremove
sudo apt update && apt install ruby ruby-dev firefox=45.0.2+build1-0ubuntu1 git

 

Grab the goods. Under a regular (non-root) user do:

 

cd ~/
git clone https://github.com/mentalinc/flick_scrape_halfhour.git
cd flick_scrape_halfhour
bundle install

 

On your influxdb host:

 

sudo influx
CREATE DATABASE FlickUsage
exit

 

Next, edit your main.rb file and give your Flick deets as well as point it to your influx database. Run with "bundle exec ruby main.rb" and it should work no problems. Generally follow the readme on the GitHub repo from this point.

 

I've noticed that with me the data Flick provides is missing quite a bit - I've manually vetted this and as it turns out I've got quite a few missing days in a row which also messes up the script so not sure what is going on with my readings... Such a shame as many people here seem to have more up-to-date data.

 

Click to see full size

 

 

Cheers, will give this a try.  Attempted to get it running the other day (on a less than ideal setup), but the CSV only got the date and time, no power details.


mentalinc
2916 posts

Uber Geek

Trusted

  #1684169 7-Dec-2016 19:25
Send private message

Posted updated code to Github updated readme with @michaelmurfy guide.

 

Also included code so you can store the costs of each 1/2 hours power in the database as well. which will enable the blank graph space "summary graph" in @michaelmurfy screenshot.

 

Please report back any issues.





CPU: AMD 5900x | RAM: GSKILL Trident Z Neo RGB F4-3600C16D-32GTZNC-32-GB | MB:  Asus X570-E | GFX: EVGA FTW3 Ultra RTX 3080Ti| Monitor: LG 27GL850-B 2560x1440

 

Quic: https://account.quic.nz/refer/473833 R473833EQKIBX 


michaelmurfy
meow
12654 posts

Uber Geek

Moderator
ID Verified
Trusted
Lifetime subscriber

  #1684234 7-Dec-2016 19:55
Send private message

@mentalinc it doesn't look like you did a git push :)





Michael Murphy | https://murfy.nz
Referral Links: Octopus Energy ($50 Credit) | Tesla | Quic Broadband (use R122101E7CV7Q for free setup)

Are you happy with what you get from Geekzone? Please consider supporting us by subscribing.
Opinions are my own and not the views of my employer.


mentalinc
2916 posts

Uber Geek

Trusted

  #1684264 7-Dec-2016 20:25
Send private message

git push done. sorry





CPU: AMD 5900x | RAM: GSKILL Trident Z Neo RGB F4-3600C16D-32GTZNC-32-GB | MB:  Asus X570-E | GFX: EVGA FTW3 Ultra RTX 3080Ti| Monitor: LG 27GL850-B 2560x1440

 

Quic: https://account.quic.nz/refer/473833 R473833EQKIBX 


michaelmurfy
meow
12654 posts

Uber Geek

Moderator
ID Verified
Trusted
Lifetime subscriber

  #1684757 8-Dec-2016 16:57
Send private message

Thanks @mentalinc your changes have worked well:

 

Click to see full size

 

It appears you may be scraping the whole graph however - in the source there is some nicely formatted JSON (under the graph source) that could help mitigate some of the unknown scraping errors.





Michael Murphy | https://murfy.nz
Referral Links: Octopus Energy ($50 Credit) | Tesla | Quic Broadband (use R122101E7CV7Q for free setup)

Are you happy with what you get from Geekzone? Please consider supporting us by subscribing.
Opinions are my own and not the views of my employer.


mentalinc
2916 posts

Uber Geek

Trusted

  #1684857 8-Dec-2016 19:28
Send private message

Indeed there is a table which I parse instead of the json.

 

Can't remember why I did it that way... think it was the table has the date and time stored in it which can be used to feed through to influxdb. the json you have to assume the times and programatically add in the date and time (parsed or stored from somewhere else). The library for parsing each row in the table was super easy...





CPU: AMD 5900x | RAM: GSKILL Trident Z Neo RGB F4-3600C16D-32GTZNC-32-GB | MB:  Asus X570-E | GFX: EVGA FTW3 Ultra RTX 3080Ti| Monitor: LG 27GL850-B 2560x1440

 

Quic: https://account.quic.nz/refer/473833 R473833EQKIBX 


xlinknz
1119 posts

Uber Geek

Trusted

  #1685626 10-Dec-2016 10:18
Send private message

The Powerswitch calculator gives me an error [server down or didn't like what I entered] when I try to use it to compare my current Flick rates

 

Are there any other sites I can use to compare ?

 

This is so I can see the impact of Flick no longer offering a night rate due to the WEL notification 

 

 

 

 


xlinknz
1119 posts

Uber Geek

Trusted

  #1685658 10-Dec-2016 11:04
Send private message

xlinknz:

 

The Powerswitch calculator gives me an error [server down or didn't like what I entered] when I try to use it to compare my current Flick rates

 

Are there any other sites I can use to compare ?

 

This is so I can see the impact of Flick no longer offering a night rate due to the WEL notification  

 

 

Edit/update: The powerswitch calculator does not like using the option for Flick uncontrolled low user + night rate as if I just use uncontrolled low user it works. I have emailed powerswitch to let them know

 

How do I see what my Flick Usage is per hour e.g. between 6-7am ?

 

 

 

 

 

 

 

 


mentalinc
2916 posts

Uber Geek

Trusted

  #1685964 11-Dec-2016 09:56
Send private message

What better way to spend Sunday morning than making your graphs even better?

 

 

 

So I figured out I had some issues with the costs being presented in the cost line. (It wasn't going what I thought it was doing).

 

Never fear I've found the answer... updated readme and .json now on github!

 

Basically run two queries to remove then add the last 24hrs, 7 days and 30 days of data.

 

JSON file updated to better display the costs... SUggest importing this one and deleting your old one if you've not changed it too much..

 

 





CPU: AMD 5900x | RAM: GSKILL Trident Z Neo RGB F4-3600C16D-32GTZNC-32-GB | MB:  Asus X570-E | GFX: EVGA FTW3 Ultra RTX 3080Ti| Monitor: LG 27GL850-B 2560x1440

 

Quic: https://account.quic.nz/refer/473833 R473833EQKIBX 


allune
108 posts

Master Geek


  #1691616 18-Dec-2016 00:59
Send private message

Moved houses and switched to flick from Powershop. Hopefully more savings!


luckiestmanalive
54 posts

Master Geek


  #1699723 7-Jan-2017 10:16
Send private message

Just noted the prices for Wed, 5 Jan 2017 are as flat as a pancake now the Wellington Electricity peak/off-peak rates are off!!! Guess it's back to turning appliances on anytime of the day now...


timmmay
19757 posts

Uber Geek

Trusted
Lifetime subscriber

  #1699751 7-Jan-2017 10:33
Send private message

Not sure you can generalise from one days power. The few days leading up to it had quite a lot of variety in prices, not all because of line charge.


luckiestmanalive
54 posts

Master Geek


  #1699789 7-Jan-2017 11:25
Send private message

I like your optimism, T, but I bet there will be little difference now the WE shelf has been removed. One-off days here and there will be worth chasing but that is a different kettle of fish. I just don't think it is likely there will be a regular day/night price difference worth expending any set-up time and cost. 


tdgeek
28931 posts

Uber Geek

Trusted
Lifetime subscriber

  #1703412 15-Jan-2017 10:35
Send private message

I don't get this.

 

At Genesis I pay 33.33c per day and 25.92c per unit.  The Flick ad on here tells me 40c per day and 1.5c per kWh and checking Genesis, a unit is a kwH. How can the rates drop from 25c to 1.5c per unit???? 

 

The last bill was low at Genesis as HW is solar only at the moment, we used 298 units. Is there a decimal point issue here?


timmmay
19757 posts

Uber Geek

Trusted
Lifetime subscriber

  #1704456 17-Jan-2017 08:08
Send private message

luckiestmanalive:

 

Just noted the prices for Wed, 5 Jan 2017 are as flat as a pancake now the Wellington Electricity peak/off-peak rates are off!!! Guess it's back to turning appliances on anytime of the day now...

 

 

Looking at the graphs for the past couple of weeks I think what's happening is we just happen to have stable power prices at the moment. Once we get into winter with the peaks we'll see more variability. But right now I run loads any time I feel like it, because there's no benefit to running them off peak. The "weather bomb" (which doesn't look so bad according to current forecasts) hitting tomorrow might increase usage slightly, but that'll be windy and wet, not really cold.

 

I wanted to compare with last year, but the Flick website won't show anything more than 11 months old for me today.

 

Wellington Electric customers should all try to run their large loads, like clothes drying, during peak times while the variable cost is flat.


1 | ... | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | ... | 132
View this topic in a long page with up to 500 replies per page Create new topic



News and reviews »

One New Zealand Extends 3G Switch-off Date
Posted 11-Apr-2024 08:56


Amazon Echo Hub Review
Posted 10-Apr-2024 18:57


Epson Launches New Versatile A4 Desktop Scanners
Posted 10-Apr-2024 15:31


Motorola Mobility Launches New Android Phones in New Zealand
Posted 10-Apr-2024 14:59


Logitech G Unveils the PRO X 60 Gaming Keyboard
Posted 9-Apr-2024 19:01


Logitech Unveils Signature Slim Keyboard and Combo
Posted 9-Apr-2024 13:33


ExpressVPN Launches Aircove Go Portable Router With Built-in VPN
Posted 26-Mar-2024 21:25


Shure MoveMic Review
Posted 25-Mar-2024 12:47


reMarkable 2 Launches at JB Hi-Fi New Zealand
Posted 20-Mar-2024 08:36


Samsung Galaxy S24 Ultra review
Posted 19-Mar-2024 11:37


Google Nest Wifi Pro Review
Posted 16-Mar-2024 11:28


Samsung Galaxy A55 5G and Galaxy A35 5G
Posted 12-Mar-2024 12:41


Cricut EasyPress Mini Zen Blue launches at Spotlight New Zealand
Posted 12-Mar-2024 12:32


Logitech Introduces MX Brio Webcam
Posted 12-Mar-2024 12:24


HP Unveils Broadest Consumer Portfolio of AI-Enhanced Laptops
Posted 3-Mar-2024 18:09



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.