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.
Filter this topic showing only the reply marked as answer 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 | ... | 120

CJC

43 posts

Geek
+1 received by user: 7


  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.


1579 posts

Uber Geek
+1 received by user: 154

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

 

 


Meow
7911 posts

Uber Geek
+1 received by user: 3930

Moderator
Trusted
Lifetime subscriber

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

Uber Geek
+1 received by user: 154

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

 

 


Meow
7911 posts

Uber Geek
+1 received by user: 3930

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.





1579 posts

Uber Geek
+1 received by user: 154

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

 

 


826 posts

Ultimate Geek
+1 received by user: 70

Trusted

  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 

 

 

 

 


826 posts

Ultimate Geek
+1 received by user: 70

Trusted

  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 ?

 

 

 

 

 

 

 

 


1579 posts

Uber Geek
+1 received by user: 154

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

 

 


71 posts

Master Geek
+1 received by user: 9


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

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


53 posts

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


14151 posts

Uber Geek
+1 received by user: 2546

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


53 posts

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


13430 posts

Uber Geek
+1 received by user: 2428

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?


14151 posts

Uber Geek
+1 received by user: 2546

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 | ... | 120
Filter this topic showing only the reply marked as answer 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:



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.