PDA

View Full Version : Resource analysis



kebo23
10-14-2015, 10:49 AM
I am trying to look at a person's availability when they've been assigned to multiple projects. Right now, I'm bringing multiple sub projects into 1 blank master project then looking at the resource usage. This shows each person's total amount of time assigned per day for each project but doesn't sum up the time between multiple ones. I need to be able to see all of the projects they are assigned to in order to make resource allocation decisions. How might I do this?

Thanks,

SamT
10-14-2015, 02:49 PM
:dunno

Create a custom Table with Field Names ResourceName, ResourceID, and Work

You might try another table with Fields: Task, TaskProject, ResourceName, ResourceStart, and ResourceFinish, Then sort on ResourceName.

Paul_Hossler
10-14-2015, 05:54 PM
Is this a MS PowerPoint question or a MS Project question?

SamT
10-14-2015, 09:40 PM
Paul, Thanks. I'll move t.

kebo23
10-15-2015, 07:28 AM
:dunno

Create a custom Table with Field Names ResourceName, ResourceID, and Work

You might try another table with Fields: Task, TaskProject, ResourceName, ResourceStart, and ResourceFinish, Then sort on ResourceName.





Hmmm. Not getting the info I need. Is there a way that I can export the resource usage table into Excel in the same setup as displayed in Project? I haven't had luck doing that either.