?

Log in

No account? Create an account
home energy usage - new shiny graphs! - Greg [entries|archive|friends|userinfo]
Greg

[ website | gregstoll.com ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

Links
[Links:| * Homepage * Mobile apps (Windows Phone, Win8, Android, webOS) * Pictures * LJBackup * Same-sex marriage map * iTunesAnalysis * Where's lunch? ]

home energy usage - new shiny graphs! [Jul. 6th, 2010|11:09 am]
Greg
[Tags|]
[Current Mood |geekygeeky]

I've been wanting to play around with Tableau Public, so I decided to revamp my home energy usage graph.

Anyway, the new version is here, and I think it does a good job of showing the difference that having someone upstairs during the day makes, as well as the new A/C unit we bought a few months ago. I used a quadratic fit which seems to fit the data much better than the linear one I used before (you can mouseover the trend lines to see the equations!). Now I just need to wait to get some more data points!

You can click on points in either graph to see the corresponding one in the other, and Tableau makes it easy to download the raw data I used. If you select "True" for "Upstairs during day?" you can really see the effect of the new A/C. (green points vs. orange)

Thanks to Robert Morton for his help in getting it up and running!
LinkReply

Comments:
From: spchampion
2010-07-06 04:20 pm (UTC)
Very cool! Where are you getting the usage data? Is it your monthly bill or are you using some kind of measurement device?
(Reply) (Thread)
[User Picture]From: gregstoll
2010-07-06 05:59 pm (UTC)
Thanks! Just the monthly bill - Austin Energy has a nice online interface where you can easily see the kWH used/day of the cycle.
(Reply) (Parent) (Thread)
From: spchampion
2010-07-07 02:38 am (UTC)
Interesting. I can't say that National Grid has a similar system at all here in Massachusetts. Very sad, but then again so much of my energy consumption up here comes in the form of things like gas and heating oil. Figuring out how those are consumed is nearly hopeless.
(Reply) (Parent) (Thread)