matt_leonard
Board Regular
- Joined
- Dec 20, 2004
- Messages
- 51
Hi all,
Im having a bit of blank day and have been staring at my screen for quite a while trying to think of some way to do this without it being to messy.
Anyway I need to setup a spreadsheet which does the following.....
I have a list of 5 jobs which are done every hour during the working day and a need a stat for how many was done at each hour. There are 4 people who do these jobs.
I need stats for - totals for each job, each day by each person.
- Overal total for each job each day
- Running totals of all stats during the month
Any ideas of how to lay to this out? We currently have a seperate sheet each day of the month in monthly spreadsheets but they get quite messy and doesn't look to great. I just need something to get me started. What sheets to have and how best to do it...
Any help on this would be great, its hard to explain on forum but thought I would give it a shot...
thank you
Matt
Im having a bit of blank day and have been staring at my screen for quite a while trying to think of some way to do this without it being to messy.
Anyway I need to setup a spreadsheet which does the following.....
I have a list of 5 jobs which are done every hour during the working day and a need a stat for how many was done at each hour. There are 4 people who do these jobs.
I need stats for - totals for each job, each day by each person.
- Overal total for each job each day
- Running totals of all stats during the month
Any ideas of how to lay to this out? We currently have a seperate sheet each day of the month in monthly spreadsheets but they get quite messy and doesn't look to great. I just need something to get me started. What sheets to have and how best to do it...
Any help on this would be great, its hard to explain on forum but thought I would give it a shot...
thank you
Matt