Lies, damned lies, and statistics

I’ve been using a 1 wire network for quite some time now, but when I deleted a directory to much on my server, I lost a lot of the stats that I had gathered. A couple of weeks ago I finally got my behind in gear again and rebuild my network, this time making sure it all gets backed up ;)

One day I’ll write something about how it’s all been done, but for now you’ll have to suffice with some pretty graphs.

Here’s the daily graph for the temperatures in our bedrooms for the past 24 hours:

Daily temperatures Bedrooms

And recently I added a Current Cost meter to my network, which gives me the shocking facts about my electricity usage for the past 24 hours:

Daily electricy usage

The above graphs are updated hourly, and I’ve got other graphs too, extending the period of graphing. You can find them here for the time being.

Update 25.1.2009

And now you’re able to follow the stats on twitter: http://twitter.com/awoogadotnl

  • By Mark Harrison, January 24, 2009 @ 17:04

    I’ve never been sure how accurate (in absolute terms) the 1-wire sensors are. I’m wondering, if you physically swapped the Senna, Bedroom, and Justin sensors, would you STILL have the consistent temperature difference between the three locations in the same order?

  • By Q, January 25, 2009 @ 15:28

    According to http://www.maxim-ic.com/quick_view2.cfm/qv_pk/2815 they are accurate to ±0.5°C, so theoratically it should not matter.

    I should add, that Justin’s bedroom is above our garage and cools down really quickly. That’s why you see the odd spikes in the evening/night as he has a small portable heater ‘topping up’.

  • By Mark Phelan, February 17, 2009 @ 14:24

    I have my CC twittering my consumption in kWh at the end of each 24 hours, and once i can figure out my tariff it’ll show me what it’s cost me each day. Scary!
    I pull the daily consumption from sql with the following query in a shell script:

    query=”SELECT round(sum((\`watts\` / 1000) / 600),2) FROM \`power\` WHERE \`timestamp\` > ((select max(\`timestamp\`) from \`power\`) – 86400)”

    I’ll get round to putting all the graphs and data on a website eventually…!

  • By Q, February 17, 2009 @ 14:45

    That’s a good idea (the tariff/costs calculations). One thing, I reckon you can make your query slightly better:

    SELECT AVG(watts) FROM power WHERE timestamp > NOW() – INTERVAL 24 HOUR

    That’s what I use for my daily tweets.

  • By Kieran, February 1, 2012 @ 15:59

    Would you mind sharing your CurrentCost Data & Graph templates?

    I’m almost there, but can’t get it to show w & kw like your graph does.

Other Links to this Post