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 | ... | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | ... | 100

CJC

32 posts

Geek
+1 received by user: 5


  Reply # 1683874 7-Dec-2016 13:22
Send private message quote this post

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.


1493 posts

Uber Geek
+1 received by user: 131

Trusted

  Reply # 1684169 7-Dec-2016 19:25
Send private message quote this post

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: Intel 3770k| RAM: F3-2400C10D-16GTX G.Skill Trident X |MB:  Gigabyte Z77X-UD5H-WB | GFX: GV-N660OC-2GD gv-n660oc-2gd GeForce GTX 660 | Monitor: Qnix 27" 2560x1440

 

Want to be with an awesome ISP? Want $20 credit too? Use this link to sign up to BigPipe.


 
 
 
 


Try Wrike: fast, easy, and efficient project collaboration software
Meow
7284 posts

Uber Geek
+1 received by user: 3482

Moderator
Trusted
Lifetime subscriber

  Reply # 1684234 7-Dec-2016 19:55
Send private message quote this post
1493 posts

Uber Geek
+1 received by user: 131

Trusted

  Reply # 1684264 7-Dec-2016 20:25
Send private message quote this post

git push done. sorry





CPU: Intel 3770k| RAM: F3-2400C10D-16GTX G.Skill Trident X |MB:  Gigabyte Z77X-UD5H-WB | GFX: GV-N660OC-2GD gv-n660oc-2gd GeForce GTX 660 | Monitor: Qnix 27" 2560x1440

 

Want to be with an awesome ISP? Want $20 credit too? Use this link to sign up to BigPipe.


Meow
7284 posts

Uber Geek
+1 received by user: 3482

Moderator
Trusted
Lifetime subscriber

  Reply # 1684757 8-Dec-2016 16:57
Send private message quote this post

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.





1493 posts

Uber Geek
+1 received by user: 131

Trusted

  Reply # 1684857 8-Dec-2016 19:28
Send private message quote this post

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: Intel 3770k| RAM: F3-2400C10D-16GTX G.Skill Trident X |MB:  Gigabyte Z77X-UD5H-WB | GFX: GV-N660OC-2GD gv-n660oc-2gd GeForce GTX 660 | Monitor: Qnix 27" 2560x1440

 

Want to be with an awesome ISP? Want $20 credit too? Use this link to sign up to BigPipe.


757 posts

Ultimate Geek
+1 received by user: 64


  Reply # 1685626 10-Dec-2016 10:18
Send private message quote this post

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 

 

 

 

 


757 posts

Ultimate Geek
+1 received by user: 64


  Reply # 1685658 10-Dec-2016 11:04
Send private message quote this post

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 ?

 

 

 

 

 

 

 

 


1493 posts

Uber Geek
+1 received by user: 131

Trusted

  Reply # 1685964 11-Dec-2016 09:56
Send private message quote this post

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: Intel 3770k| RAM: F3-2400C10D-16GTX G.Skill Trident X |MB:  Gigabyte Z77X-UD5H-WB | GFX: GV-N660OC-2GD gv-n660oc-2gd GeForce GTX 660 | Monitor: Qnix 27" 2560x1440

 

Want to be with an awesome ISP? Want $20 credit too? Use this link to sign up to BigPipe.


66 posts

Master Geek
+1 received by user: 8


  Reply # 1691616 18-Dec-2016 00:59
Send private message quote this post

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


40 posts

Geek
+1 received by user: 5


  Reply # 1699723 7-Jan-2017 10:16
Send private message quote this post

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...


13749 posts

Uber Geek
+1 received by user: 2392

Trusted
Subscriber

  Reply # 1699751 7-Jan-2017 10:33
Send private message quote this post

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.





AWS Certified Solution Architect Professional, Sysop Administrator Associate, and Developer Associate
TOGAF certified enterprise architect
Professional photographer


40 posts

Geek
+1 received by user: 5


  Reply # 1699789 7-Jan-2017 11:25
Send private message quote this post

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. 


11654 posts

Uber Geek
+1 received by user: 2005

Trusted

  Reply # 1703412 15-Jan-2017 10:35
Send private message quote this post

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?


13749 posts

Uber Geek
+1 received by user: 2392

Trusted
Subscriber

  Reply # 1704456 17-Jan-2017 08:08
Send private message quote this post

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.





AWS Certified Solution Architect Professional, Sysop Administrator Associate, and Developer Associate
TOGAF certified enterprise architect
Professional photographer


1 | ... | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | ... | 100
View this topic in a long page with up to 500 replies per page Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Opera launches new mobile browser: Opera Touch
Posted 25-Apr-2018 20:45


TCF and Telcos Toughen Up on Scam Callers
Posted 23-Apr-2018 09:39


Amazon launches the International Shopping Experience in the Amazon Shopping App
Posted 19-Apr-2018 08:38


Spark New Zealand and TVNZ to bring coverage of Rugby World Cup 2019
Posted 16-Apr-2018 06:55


How Google can seize Microsoft Office crown
Posted 14-Apr-2018 11:08


How back office transformation drives IRD efficiency
Posted 12-Apr-2018 21:15


iPod laws in a smartphone world: will we ever get copyright right?
Posted 12-Apr-2018 21:13


Lightbox service using big data and analytics to learn more about customers
Posted 9-Apr-2018 12:11


111 mobile caller location extended to iOS
Posted 6-Apr-2018 13:50


Huawei announces the HUAWEI P20 series
Posted 29-Mar-2018 11:41


Symantec Internet Security Threat Report shows increased endpoint technology risks
Posted 26-Mar-2018 18:29


Spark switches on long-range IoT network across New Zealand
Posted 26-Mar-2018 18:22


Stuff Pix enters streaming video market
Posted 21-Mar-2018 09:18


Windows no longer Microsoft’s main focus
Posted 13-Mar-2018 07:47


Why phone makers are obsessed with cameras
Posted 11-Mar-2018 12:25



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.

Alternatively, you can receive a daily email with Geekzone updates.