Resource analysis

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,

: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.

Is this a MS PowerPoint question or a MS Project question?

Paul, Thanks. I'll move t.

Quote:

---

Originally Posted by SamT

: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.