Chris Bergeron's Blog

My projects, rants and general info

Archive for the ‘solar’ Category

Created new utility bill graph

Friday, January 28th, 2011

I updated the code that renders my utility bill graphs. You can see it here.

Here’s a screenshot:

Created utility tracking page

Saturday, June 12th, 2010

I created an executive dashboard of my overall energy expenditure. One of the graphs from it can be seen below. In this graph, you’ll find electricity, natural gas, and the aggregate (the red line). I’d like to overlay an average monthly temperature trendline on this graph, but it’s going to require me to install my own weather station (or a reliable source of data for my zipcode). Until then, here’s the graph at present:

utility usage

Created Energy summary page

Saturday, February 20th, 2010

I created an energy usage summary webpage to give me an ‘executive dashboard’ of my home energy usage.

Solar: Update 2

Tuesday, September 15th, 2009
Tracking electricity usage is an important component of solar power. In order to help me achieve this goal, I wrote some software to help me monitor my electricity usage. Each month when the electric bill arrives, I input the data into an iPhone applet. This applet records the data into a database. I'm not going to link to it for privacy reasons, but here's a picture of the applet:

Here are a couple of graphs produced from it. The first are the bill amounts: Bill amounts

The second is the number of kiloWatt hours used: kWh used

couldn't query: (SELECT count(svc_month) FROM electric)