I have a "large" spreadsheet where I keep track of my natural gas billings. It goes back to 1983. The data is setup to follow the billing data so fields are not adjacent. What I want to do is select from this large table sub sets of data, i.e. month and gas usage so that I can review changes made to the house that would impact heating. I would want to create a table that shows a particular month and usage over the years. I guess in the end I would have 12 charts. The charts need to pickup new data as it gets added to the master spreadsheet dynamically.
I had thought of doing a SQL select to get the data for each month ( date format mm/dd/yyyy ) but I could not find any suggestions. Is there a better way to extract month and usage by month and create the input for a chart? I understand in Excel I can use MONTH get the data for Jan. etc.. My background is programming on the mainframes, COBOL, PLI, DB2, IMS etc. so my solutions are driven old thought processes that may not work with Excel.
Looking for some direction and possible solutions that I can understand :-).
Billing Date Billed Amt Water H Cust Chrg Delv Chg Suply Chg TranChg TranRate Qty M3 3rd Party rate PEF Adj M3 Current Reading
Prev Reading Usage Recal supply C harge BBP billed YTD Enbrige rate Recalc Enb usage Delta Site restoration Y/E Value Y/E Gas Usage
Bookmarks