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)
|