Sign in
 
HomeOnline20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Microsoft Project - A Resource 1 liner

Answered Microsoft Project - A Resource 1 liner

  • Wednesday, April 25, 2012 1:18 PM
     
     
    Sign In to Vote
    0

    Hi Folks,

    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.

    Make sense?

    Thanks

    Dirjampa 

    • Moved by Leonid GanelineMVP Wednesday, April 25, 2012 3:53 PM (From:BizTalk Server General)
    •  
     

All Replies

  • Wednesday, April 25, 2012 2:26 PM
     
     
    Sign In to Vote
    0
    You 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

    Regards, Pa445

     
  • Wednesday, April 25, 2012 6:38 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Dirjampa,

    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. 

    Sapna S

     
  • Wednesday, April 25, 2012 7:27 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    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.

    Greetings,