How to avoid duplicated Resources in Project with Subprojects in MS PROJECT 2013?

Hi,

one of my Blog readers had a problem! He made a Project with Resource, and Subprojects with same resources, and then those Resources were duplicated. I will use MS PROJECT 2013, but it works in MS PROJECT 2010 in the same way. Let me show an example.

Firs I will open Main Project:

image

and I will add two resources in it:

image

Now I will open new Subproject and I will do the same:

image

and:

image

I will save my Subproject:

image

Now I will add Subproject in my main Project:

image

and I will get:

image

Now, I will show you a Resource Sheet:

image

John and Mary are duplicated, and that is not a Bug. Main Project and Subproject(s) are not sharing the same Resources if you will work with them as on example above.

But, if you want to share Resource among Main Project, and Subprojects you should create the Resource pool!

Here it is:

image

In this “Project” I will have no tasks, just resources, and I will save it like a ResPool file:

image

Now I will leave this Respool open, and I will crate main Project again:

image

and I will use a ResPool for resources:

image

and I will get:

image

and after that:

image

Now I will do the same thing with Subproject! Steps are identical so I will not copy pictures again. I will save a Subproject and after that I will insert it to a Main Project:

image

but when I open the Resource Sheet, I will get:

image

Why is it so important? Because if John and Mary in Main Project are the same Persons from the Subproject(s), and you will not use the Resource Pool, you will miss the over allocation feature in MS PROJECT! With Resource Pool there is only one John, and only one Mary, and if you assign them to multiple tasks which are going to run at the same time you will see the over allocation!

 

Regards,

Advertisement

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013 and tagged , . Bookmark the permalink.

13 Responses to How to avoid duplicated Resources in Project with Subprojects in MS PROJECT 2013?

  1. J Hima Bindu says:

    Hi , Thank you for the details to create Resource pool. I have a doubt, if same resource is being used for multiple sub projects, how can I see his combined usage?

  2. Fredrik says:

    Hi Nenad,
    I have a problem that I can´t seem to find a solution for. I´ve created a resource pool, a master project in which I have inserted sub projects into, and am now trying to share the resources. Problem is I don´t get the option to use resources from the resource pool inside the master project and subprojects, even though the resource pool is left opened. Do you have any idea of what can be causing this? Thanks!

  3. Jill Barclay says:

    Hi Nenad, I am fairly new to MS Project. I have a master file, a resource pool and 20 subprojects. These files have been copied and stored in several locations and now I am being asked to ensure the Resource pool is the correct version. How can I check the shared resource is looking for the right resource pool file?

    • Nenad Trajkovski says:

      I suggest that you always have your Resource pool in one place, and one place only. DO NOT MOVE THEM in other location. If you do that you should open all projects and tell PRoject where is the location of your Resorce pool

  4. Sunny Goklani says:

    Hello Nenad again,
    I followed the entire steps. Created resource pool, allocated linked pools into subprojects and then inserted all subprojects into the main sheet. But, still it is not allowing me to use the ‘To-Do List’ feature. It doesn’t allow me to select a resource in the process, and hence, not generating the To-Do List for a particular resource, which was one of the main reasons why I did all this.
    Please guide at the earliest 🙂
    Thanks and you’re doing a great work,
    Sunny Goklani

    • Nenad Trajkovski says:

      I think taha to can’t get what you want via to-do list. What you can do is following my steps, and then from resource usage, or task usage view, copy fields which you need to excel, and then make adjustments to have a report you want!

  5. Sunny Goklani says:

    Hello Nenad, first of all thankyou for your post!
    I am facing this problem and I found no other link on the ENTIRE Internet, more exactly describing my problem. Now, I run 15 residential projects. My aim was to generate ‘To-Do Lists’ for every personnel who works in my office. Hence, in the master sheet, I imported sub projects (all of which were created way before and had resources already allocated) and found these resources duplicated in Resource sheet. Now when I go for generating ‘To-Do list’, it doesn’t allow me to select a particular resource and the selection box is empty.
    I read through your post and got the solution, but allocating all the resources to tasks of all sub projects again will take a LOT of time. Is there any other way in which I am able to remove duplication, generate To-Do report for a particular resource, and not taking so much time?
    Later on, I wish to level the common resources too.
    Your suggestion would be gravely helpful! Please reply 🙂

    • Nenad Trajkovski says:

      Well, you have to spend a lot of time, because you are now using the Resource pool, and then you have to assign resources from the pool again

  6. J.m. Benedetto says:

    Hello, Nenad. First, I’d like to thank you by your posts. They are very helpful. Now, to my question. I have a central team coordinating and working in some local projects with local teams. I have one project file for each local project and one master file for them all, plus the central tasks. I have a pool for all resources, but is is getting crownded. I’d like to keep only the central team on the pool and have the local teams on each project file. I tried but each time I created a resource in the local file, it was also created in the pool. Do you know how to do it? Best regards.

    • Nenad Trajkovski says:

      There is no way to use local resources and Resource pool at a same time! 😦

      • Harsen Kocan says:

        Hi Nenad,

        Is it possible to use one resource in same time period, if I want to allocate a resource 80% on task1 and 20% on the task2.

        Thanks.

      • Nenad Trajkovski says:

        Yes, of course. Go to Resurce Tab, then assign Resurce, and in the Unit field pu 80% or 20% for a Task

Leave a Reply to J.m. Benedetto Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s