Resource duplicated in a master project file

Home Forums Microsoft Project Discussion Forum Resource duplicated in a master project file

Viewing 2 reply threads
  • Author
    • #417195

      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?

    • #417196
      Larry Christofaro

      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…

    • #417216
      Eric Uyttewaal

      Hi Msua,
      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!


Viewing 2 reply threads
  • You must be logged in to reply to this topic.