View Single Post
Old 11-08-10, 12:21 PM   #4
strider3700
Master EcoRenovator
 
Join Date: Dec 2008
Location: Vancouver Island BC
Posts: 745
Thanks: 23
Thanked 37 Times in 30 Posts
Default

I track the following for electric usage

billing date, days on bill, kwh used, usage cost, taxes, fees, total cost(calculated), kwh/h(calc), kwh/day(calc), usage percentage( usage cost/total cost), co2 produced (calc), HDD, CDD, KWH/HDD(calc), KWH/CDD(calc), Notes

for the C02 production it would be best if we could enter and store the co2/kwh. My electric is 22 grams c02/kwh but everwhere is going to be different of course.

we're now in a tiered system but I haven't implemented that into my spread sheet yet. Ours works that you pay rate X for the first tiers worth of kwh and then rate Y. I believe they do it by averaging your usage/day and basing it off of that. at the moment I just enter =tier1+tier2 but proper handling would be great. That would mean I need to store two costs as well.

Other note, I get billed bi-monthly and it's split across years, so the next bill will be december 2010/ january 2011 and it never lines up with the start of the month.

Different worksheet I track water usage
Date, number of days on bill, current meter reading, previous meter reading, consumption in cubic meters, consumption in gallons (calc), gallons/day(calc), cost of water, cost/gallon(calc), gallons/day(calc)
strider3700 is offline   Reply With Quote