tracking monthly utility bills: monthly charges, units/volumes, costs per unit, etc.

[Jiwei06xie]

I'm interested in tracking monthly utility bills....monthl y charges, units/volumes, costs per unit and so on, by monthly date. The data source would be mainly from an Excel Spreadsheet (or sometimes SQL database). Are there any sample projects out there that I might be able to adapt to what I'm interested in?

How would I chart the data, so I could see trends (i.e., cost per volume, etc.)

I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!

[NeoPa]

I'm interested in tracking monthly utility bills....monthl y charges, units/volumes, costs per unit and so on, by monthly date. The data source would be mainly from an Excel Spreadsheet (or sometimes SQL database). Are there any sample projects out there that I might be able to adapt to what I'm interested in?

I'm sorry no-one seems to know of anything to start you going with.

How would I chart the data, so I could see trends (i.e., cost per volume, etc.)

I'm not sure how I can answer that. The direct answer is that you would need to design your database structure to allow this analysis, and use queries to perform it. I doubt that's much help to you, but there's not much more I can suggest in response to that question (It's so open-ended that the answer is not much help). Obviously the design needs to include the data that you need to analyse, and all the data you want to analyse on.

An article that may be some help at the design stage is Normalisation and Table structures.