GAS meter spreadsheet
I would be grateful if you could help me with this problem,
perhaps by suggesting suitable freeware,
or maybe by pointing me to sources of help.
SITUATION: I take gas meter readings at random intervals;
sometimes seven days might elapse between readings, sometimes seventeen.
It could be any number of days between readings.
REQUIREMENT: I want to know how much gas has been used in the year up to
any day. The day might not be one on which I took a meter reading. Also,
the day 365 days before that might also be one for which the meter was
not read. I would assume linear interpolation between two adjacent
readings.
QUESTIONS: What would be the best way of doing this?
Spreadsheet?
Database?
Python or similar?
Anything else?
I should point out that I am not experienced with any of the above,
which means that I would have to learn from scratch whatever method is
suggested!
You might even know of the existence of something that will do it
already?
--
Chris
Bookmarks