How to Generate Underallocation Reports?

[SBC]

Is there any way to generate a report that shows where resources are not at
max. units? I've tried the resource graph but for some reason there are up
to 5 sets of data per person. They have different allocation amounts, but
they cover the same time period. Can someone help!?

 

[JulieS]

Hello SBC,

Have you looked at the Resource Usage view? You may add the field
Remaining Availability to the timescale (right) side of the view to see
how many additional "unused" hours the resource has. The timescale can
be zoomed out to show any timescale view that is useful.

You note there are "5 sets of data for each person" which is baffling.
Have you created a project which is consolidating mulitple project
files? Are the resources defined in each project? If so, you most
likely want to explore using resource pool files.

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

 

[SBC]

Thanks for your help.

Yes, I'm working on a project file that consolidates multiple files. I
guess there is no easy way to undo it at this point. Is there a way to
filter the Resource Usage view so I can view each individual resource?
Resource Usage currently lists out each person several times (most likely due
to the consolidation of several projects onto one file).

 

[JulieS]

Hello,

You're welcome and thanks for the feedback.

Unfortunately I don't think filtering is going to solve the problem for
you. Filtering can remove information temporarily from the view, but it
cannot consolidate information for you. So, for example if you had
three instances of the resource "Bob" in three different files, there is
no way short of creating the resource pool file to consolidate the
assignments (work) for all three Bobs into one. Without that
consolidation, it would be a manual process to track down what
assignments is Bob doing for each of the three files.

On the good news side, if you don't need to permanently consolidate the
projects you can follow the procedure outlined under the help topic
titled "Remove duplicate resources when consolidating projects" in Help
in Project 2003. You'll need to make sure the resources have the same
name (spelling counts) but it would avoid having to create the resource
pool.

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