Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A resource view 1 liner

Status
Not open for further replies.

Dirjampa

Technical User
Apr 25, 2012
3
GB
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.
Make sense?

Thanks

Dirjampa
 
Sorry, I don't think you are going to be able to come up with that out of the box.

The Task Usage view can show peak units, but it appears on the assignment line and does not roll up to the task line.

The best I can suggest is to see if you can use one of the visual reports to get the work by week or month and then convert the pivot table to formulas, and perform the conversion from hours to head count manually.

Julie
 
Unfortunatley thats the conclusion I have come to, but surely this is a common enough request. It is common to want to view the entire project in terms of the resource, so that those needs can be shown/justified to HR/Senior Management...surely.

For axample, to start a project a PM would need to assess the number of heads required. The PM would then stick a plan in place. That plan would then define when people are used. It should be a simple enough task for MSP to show how many heads are needed on any given day/week.

Rant over. Thanks for your input Julie.

Dirjampa in England.
 
I understand entirely. However (just to play a moment of Devil's Advocate) -- when I am planning projects (and attempting to get authorization) I talk work required -- not headcount. I so rarely get any resource full-time that often a one person headcount is spread across 2-3 people.

You're welcome for the input and thanks for the feedback.

JUlie
 
Hi Julie, I have a different problem. I have a 4 year time scale and I need and average of around 60 engineers. Senior management require heads. Tasks mean nothing to them. I need to show the head count as it rises an falls over 4 years. I have a four year plan. I want to give MSP a quick shake and out of the bottom I would like to drop a graph showing how those heads fluctuate. It should be simple enough of an algorithm.

Back to excel.

Regards
D
 
Ah, I see. Thanks for the reasoning. Did Jan's suggestion in the other forum help?

Julie
 
I've re-read your post and I just noticed that you are looking for a graph -- that you can do in Project!

Create the project, assign the engineers to broad tasks spanning the 4 years. Take a look at the resource graph view that is built in to Project. You may zoom out showing months as needed.

Julie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top