I’m trying to figure out a means to report resource overallocation in a user friendly report. MS Project doesn’t seem to have one that I have seen. I am managing 12 Project work streams with 12 separate project plans in a single program and need to see what resources are overallocated and be able to tie it back to the workstream tasks that have the resource assigned. Each of the PMs assigned to a workstream has removed any overallocations from their respective plan. I am merging the 12 plans each week to run an overallocation report. MS Project shows me the overallocated resources but in a format that doesn’t show where the tasks are located so I can’t easily have discussions with the PMs about resource contention. Any pointers would be greatly appreciated. Saving Changes...
Sort By:
Stéphane ParentSelf Employed / Semi-retired| Leader MakerPrince Edward Island, Canada
Are you bringing in the twelve schedules into one master Microsoft Project schedule? That's the way I've done it in the past. By using the appropriate resource usage view, you can see the activities under each project. Saving Changes...
Yes, I’m bringing them in using the Project Subproject option and unchecking the checkbox, “Link to Project”. Then I go to the “Resource usage” view to view the overallocated resources. The problem is the Tasks listed under the resource name in the overallocation report don't display in a user friendly report. Saving Changes...
I wish I had access to the task table from which the task name is displayed when I toggle open a resource name to see the list of tasks. If I had access to the task table then I could display a custom task text field with the name of the workstream in it. That would satisfy my needs. Saving Changes...
"The secret of getting ahead is getting started. The secret of getting started is breaking your complex overwhelming tasks into small manageable tasks, and then starting on the first one."
