R
RMP
Hello,
Please can you provide me with some ideas. I am trying to create a
spreadsheet which shows the throughput of a team of 7 people and calculates
weekly and monthly totals keeping manual input to a minimum.
We deal with 25 different types of tasks on the team and what I need to do
is create a spreadshhet where you enter the totals of work completed by each
team member, by type of work and insert formulas that create weekly and
monthly totals.
I'm trying to avoid having a complex spreadsheet and want to make it as time
efficient as possible. Basically entering the data under each members name
showing the type and amount of work completed each day but feeding the totals
through to another worksheet (which i can handle)
My main problem is that I would have to have 7 columns (1 for each member)
for each day and by the end of the month the spreadsheet would be too busy
and too complicated.
Are you able to help.
Thanks
Please can you provide me with some ideas. I am trying to create a
spreadsheet which shows the throughput of a team of 7 people and calculates
weekly and monthly totals keeping manual input to a minimum.
We deal with 25 different types of tasks on the team and what I need to do
is create a spreadshhet where you enter the totals of work completed by each
team member, by type of work and insert formulas that create weekly and
monthly totals.
I'm trying to avoid having a complex spreadsheet and want to make it as time
efficient as possible. Basically entering the data under each members name
showing the type and amount of work completed each day but feeding the totals
through to another worksheet (which i can handle)
My main problem is that I would have to have 7 columns (1 for each member)
for each day and by the end of the month the spreadsheet would be too busy
and too complicated.
Are you able to help.
Thanks