I am using the Insert Subproject function to effectively pull in each individual source project into my overall master programme plan. I am having trouble merging the resources from each source project in the overall master plan. Resulting in ‘doubling up’ or ‘duplication’ of each project resource which has been copied in from each inserted source project plan.
Any idea on how to fix this?
The feature is called a Shared Resource Pool. It’s basically a separate schedule that contains resources, with other project schedules using (sharing) those resources for their schedule. Lots of articles and videos that can provide further details. Hope that helps…
If you just insert subprojects, you will always see duplication of resources, even if the resources have the same name: MS Project does not reconcile the resource names (without a shared resource pool). So, what you need to do first is, like Larry suggested, build a Shared Resource Pool. You can do this in one of two ways:
1) Create an MPP-file with resources only and then connect each subproject to this shared resource pool file for the resources (and all assignments). Then you create the master schedule by inserting the Shared Resource Pool file first, then all other subprojects. This solution is limited (because of its architecture and old code): You should not exceed more than 20 resources: so, it is only an option if you work with generic resources only.
2) Subscribe to Project Online for about USD $30/per month per project manager (“Project Plan 3”), which provides an enterprise-strength shared resource pool for you and you save all the subprojects into this central project repository. You can create generic AND actual resources in this shared resource pool. When you build your master schedule, MS Project will automatically reconcile all resources and aggregate their workloads for you. I recommend this route in most cases.
Hope this helps!