Overallocated Resource Report

[rive]

Hi

Can anyone provide me some assistance in creating a MS Project 2002
overallocated resource report? What I would like is a text report showing
which resource is overallocated (i.e. > 8 hours per day) for which activities
and on what dates. Maybe I need MS Project 2003 to do this? Any assistance
would be most appreciated.

thank you

 

[JulieS]

Hi rive,

Have you looked at the Overallocated Resource report in View > Reports >
Assignments?

It does not show which specific activities and which dates but it may be a
start. MS Project 2003 is not needed.

I hope this helps. Let us know how you get along and please post back with
any further questions.

Julie

 

[rive]

Hi Julie

Yes I have - but it does not give me the details I need. The only way to
spot the conflicts is to print out the report under Reports/Workload/Resource
Usage and visually inspect and highlight which resources are overallocated by
date. When you are scheduling hundreds of tasks with over 75 resouces for a
year, the paperwork this report generates is impressive, and to read through
it and highlight the overallocated resouces is second only to Hercules
cleaning the Agean stables out - only I have no river. Seems like a valuable
report to have, just cannot figure out how to generate it. Any additional
insights would be greatly appreciated.

thank you

 

[JulieS]

Hi rive,

I'm afraid I don't have a magic answer to your question -- and alas, no
river. A couple of thoughts that may assist somewhat.

Instead of using the Resource Usage report available under View > Reports, I
suggest printing out the Resource Usage view directly with a couple of
modifications:
1) Sort the view by the Overallocation field in descending order. (I
probably wouldn't renumber the resource IDs). That should place all of the
overallocated resources at the top of the view.
2) Add the Overallocated field to the time-scaled portion of the view to
help gauge how severe the overallocation is.

I think printing the view versus the report is *somewhat* more helpful in
that the overallocations appear in red font making them much easier to spot.

Another option is to use the Analyze Timescaled data to export the data into
Excel. The problem is that doesn't bring over the information on the
assignment names, so unless you know VBA (and I don't), you may be reduced
to copy and paste. Perhaps one of the VBA "gurus" will weigh in.

Sorry, I know it isn't exactly what you wanted.

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

Julie