One Resource, Many Projects, One View

N

Nicole

Hi there,

Looking at the Resource Sheet, I can see all of my resources, and a column
showing the number of hours work allocated to each resource.

I happen to know that Resource A, is working on 10 different projects, and
the Resource Sheet is tell me my resource is overallocated. (Clearly
possible :)

How can is drill down to see what projects my resource is working on, and
how busy each one is keeping him ? e.g. like a pie chart showing different
slices proportionate to his allocation in the different plans ? A less
visual report would also be useful, if that's possible.
 
J

Jim Aksel

Use the Resource Usage View. From the main menu:
View/Resource Usage...

A list appears with each resource name and their assigned tasks subordinate
to the name.

If you need more grouping than you may need to make some additional
adjustments. Please post back as needed.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
J

JulieS

Hello Nicole,

I am assuming you are working with a resource pool file containing
your list of resources and sharer files which contain the list of
tasks for the 10 projects you have going on.

To add to Jim's answer, add the Project field to the Resource Usage
view to be able to see which assignment is coming from which project
file. You may also want to create a custom group to group the view by
resource name then by project. This would give you total work by
resource but subtotals for each project.

Sorry, as far as the pie chart -- that is not possible in Project.
You could export the data from the project file into Excel and then
use Excel's capabilities to create the pie chart.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project
 
J

JulieS

You're welcome Jim. I just added a few more words onto your already
good reply :)

Julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Share resource between projects with different std cost 4
Automated Resource Allocation Mngmnt from a flat file mpp 1
Resources Sheet view for rolled up projects 2
How to allocate a part time resource in MS Project Professional 2010? 1
Custom report with filters 3
Protecting a resource's allocation percentage across multiple proj 7
Newbie Q: Resource optimization 2
one resource many projects 4

Top