Wednesday, April 25, 2012 1:18 PM
I am looking for a way to view an entire project in one line which shows the total number of heads per week/month. There are a number of resource views as we all know, but I want the most basic of information to drop out of the plan.
I can get close to what I need in the task view, if I minimise everything into the parent task. This gives me a view in hours. I want that same view but heads instead of hours. Obviously the number of heads is simply the total number of hours per day/week divided by the the number of hours in a working day/week. This would give me the number of heads. However I need project to do the maths for me and present it in a 1 liner.
- Moved by Leonid GanelineMVP Wednesday, April 25, 2012 3:53 PM (From:BizTalk Server General)
Wednesday, April 25, 2012 2:26 PMYou have posted the question in a wrong forum. Use this link instead for the project server forum http://social.msdn.microsoft.com/Forums/en-US/projectserver2010general/threads
Wednesday, April 25, 2012 6:38 PMModerator
When you say total number of hours per day divided by number of working hours in a day, do you mean say 10 resources working on 1 day tasks so their effort would be divided by 8 (working hrs./day) i.e. 10 resources work will accumulated as 80 hrs. now you want this to be divided by 8 to get 10 heads?
If that is the case, I would like to make few points :
1) This may not be realistic calculation as number of resources can't be calculated just by dividing the total Work by working hrs/day. as Units or Effort driving Work depends on the Task Type. It also include overtime & overallocation.
2) Head Count can be pulled directly by counting resources in resource sheet and populating in a Custom Field at Project level by a small macro.
3) Total Work represent total effort of a Project and not the number of heads. These are entirely 2 different entities.
If I'm not hitting the correct logic and you asked for something else, please clarify.
Wednesday, April 25, 2012 7:27 PMModerator
1. Make a resource group by say Text1 but leave text1 blank
2. Resource Usage, click on the right side, detail styles; in detail styles select Percent Allocaton as show, then hide work.
3. Apply the group; the group summary line shows what you want, even in a timephased way.
Note that in the options, you can decide to show perentallocation as decimal rther than %, then it will show FTE directly.
- Marked As Answer by Mike GlenModerator Saturday, June 30, 2012 8:57 PM