A
Axel07
I use an Excel 2007 table to keep a log of daily activities. (See the
simplified example below).
I want to construct for my own use a simple reporting system that will
quickly display the answers to such queries as this:
Show me the total hours I spent on each activity on 2009-11-13.
Show me how many hours I spent on running last week (or last month).
Show me a week-by-week breakdown since the beginning of the year of my
totals for writing and music.
How can I do this with minimum fuss? I don't expect anyone to walk me
through it step by step, but it would be helpful to know what tools will be
useful: PivotTables? Macros? I don't want to have to enter formulas
repeatedly. Ideally I'd like to be able to make choices from drop-down lists
or menus.
I'd welcome any guidance on the basic approach, as well as web addresses for
any useful demos or existing samples I can use as models.
Thanks.
David
THE DATA SOURCE:
DATE TASK HOURS
2009-11-13 music 1.5
2009-11-13 running 1.0
2009-11-13 music 0.7
2009-11-13 work 5.2
2009-11-13 work 2.0
2009-11-13 writing 2.5
2009-11-14 work 3.2
2009-11-14 writing 2.3
2009-11-14 music 1.6
2009-11-15 running 1.2
2009-11-15 work 4.5
2009-11-15 music 2.0
2009-11-15 music 0.5
2009-11-15 writing 2.2
simplified example below).
I want to construct for my own use a simple reporting system that will
quickly display the answers to such queries as this:
Show me the total hours I spent on each activity on 2009-11-13.
Show me how many hours I spent on running last week (or last month).
Show me a week-by-week breakdown since the beginning of the year of my
totals for writing and music.
How can I do this with minimum fuss? I don't expect anyone to walk me
through it step by step, but it would be helpful to know what tools will be
useful: PivotTables? Macros? I don't want to have to enter formulas
repeatedly. Ideally I'd like to be able to make choices from drop-down lists
or menus.
I'd welcome any guidance on the basic approach, as well as web addresses for
any useful demos or existing samples I can use as models.
Thanks.
David
THE DATA SOURCE:
DATE TASK HOURS
2009-11-13 music 1.5
2009-11-13 running 1.0
2009-11-13 music 0.7
2009-11-13 work 5.2
2009-11-13 work 2.0
2009-11-13 writing 2.5
2009-11-14 work 3.2
2009-11-14 writing 2.3
2009-11-14 music 1.6
2009-11-15 running 1.2
2009-11-15 work 4.5
2009-11-15 music 2.0
2009-11-15 music 0.5
2009-11-15 writing 2.2