Chris Bergeron's Blog

My projects, rants and general info

Solar: Update 2

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)