Hi All
This is a long one/complicated one... (for me anyway!)
I have been producing a spreadsheet to show resource availability for people on work projects. i.e. what they are doing with their time, when will they become free for more work.
I have been helped in previous posts to work out the formulas used for this. (thanks!).
Now i have a list of names and projects, and time they are spending on the project within a particular month.
Now i want to report on:
a) how many people are working on the project in a particular month
b) the percentage of time spent on the project compared to time spent on other projects.
I would suggest i need to
a) create a calculation/formula of no of employees divided by number on a particular project. (word specific?)
b) create a calculation/formula of time per individual working on that project compared to others times NOT working on the project.
I know it sounds complicated and i hope i have explained it sufficiently to get some responses..!?
Thanks very much
Chris
This is a long one/complicated one... (for me anyway!)
I have been producing a spreadsheet to show resource availability for people on work projects. i.e. what they are doing with their time, when will they become free for more work.
I have been helped in previous posts to work out the formulas used for this. (thanks!).
Now i have a list of names and projects, and time they are spending on the project within a particular month.
Now i want to report on:
a) how many people are working on the project in a particular month
b) the percentage of time spent on the project compared to time spent on other projects.
I would suggest i need to
a) create a calculation/formula of no of employees divided by number on a particular project. (word specific?)
b) create a calculation/formula of time per individual working on that project compared to others times NOT working on the project.
I know it sounds complicated and i hope i have explained it sufficiently to get some responses..!?
Thanks very much
Chris