Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Local resources limit (for each project)

12 replies [Last post]
Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Hi guys,

I'm having several resources that are being used in different projects (same resource ID). Is is possible in P6 to set different limits  on same resource for each project?

Replies

Rafael Davila
User offline. Last seen 4 hours 14 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

Resource Pooling:

  • One case is the one being discussed in this thread; a single pool (A), multiple projects (P1/P2/P3/…), each with their maximum availability (A/ P1/P2/P3/…).
  • Money on the bank is a case of pooling financial resources where availability can be determined by fixed dates or by activities not fixed in time.

    https://www.slideshare.net/davilara11/financial-resources-leveling-111213157
  • Another case can be when resources are constrained on a periodic basis, similar to renewable resources, as well as for the total project duration, as with the consumable resources.  An example is a total budget with an extra restriction of a maximum limit per period.
  • Another case can be when multiple pools (A/B/C/…) each with their maximum availability provide resources to multiple projects (P1/P2/P3/…) and each project can only draw a particular resource from a particular set. This can be because of geographical proximity among the resource pools and the projects, you might wish to fly some resources while others must commute by car/train. 
  • Resources from different pools might have different production rates and when used the activity duration must be adjusted accordingly.  In some cases where the difference in production rates is significant it might be desirable to substitute 1 high production rate resource with 2 lower production rate resources.  
  • Spatial resources are an interesting case of resource pooling. Spatial resources are required by a group of activities, rather than a single activity as renewable resources. The spatial resource is occupied from the first moment an activity from the group starts until the finish of all activities from that group, can be dry docks in a ship yard or elevated slab forms that will remain in a building unless their use finishes on the building and only then will be available for use in another building. Do not ever try to resource level these as if regular renewable resources.

    https://www.slideshare.net/davilara11/spatial-resources-r1

  • Other.
  • A combination of the above.

Each scenario has its particular solution for automatic resource leveling, manual leveling of resources upon every update can be a nightmare, manual leveling of a combination can be worst of nightmares. 

Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Thanks guys! About making replica, is there a way to quickly duplicate a resource with all of its properties? I'm analysing a schedule created by other planner so it will be a real pain for me to manually reassign every single resource.

Alexandre,

local and global are just terms.

Rafael suggested to duplicate resource assignments: to assign resource worker and another resource worker at certain location with the same workloads.

Then to set limits to local resources (total number of workers at some location) but not to "global" resources that work with the local resources together.

After resource leveling reports will show total number of workers and the number of all local workers required at any moment.

In Spider Project this is not necessary, Creating resource center "Workers" that includes all local workers the user may get any reports on all local resources and on resource center (overall number of workers).

Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Thanks guys! I'll try to implement your suggestions.

Yes Ollie,

Rafael suggested very elegant solution for P6.

You shall create local resources, add local resource assignments to global resource assignments (duplicate) and set limits to local resources.

This way you will get reports on both local and global resources and take into account local resource constraints.

In Spider Project global resources are not needed if local resources are included in the resource center.

Yes Ollie,

Rafael suggested very elegant solution for P6.

You shall create local resources, add local resource assignments to global resource assignments (duplicate) and set limits to local resources.

This way you will get reports on both local and global resources and take into account local resource constraints.

In Spider Project global resources are not needed if local resources are included in the resource center.

Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Thank you for your reply Rafael. So basically, I have to create new resource ID and then reassign them?

Rafael Davila
User offline. Last seen 4 hours 14 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229

If everything else fails try the following:

Use pair of resources to limit allocations, assign the global resource and assign the local resource as shown in the following figure.  If using P6 instead of resource quantity (ea) use effort (hrs.).

  Global-and-Local-Resources-Limits

Good Luck.

Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Hi Zoltan,

I did try your method, however, the modified Max Units/Time value could not be imported back into P6 (it still shows old values).

And if there are more than 1 limit for a certain resource (due to error in input, for example), will P6 prefer the lower cap?

Ollie Lecm
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 25 Jul 2019
Posts: 10
Groups: None

Thank you Zoltan! Seem like the only possible solution now is to either create unique resource ID for each project or manually change them

Zoltan Palffy
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

no resource are global but can be assigned to a specific project since they are global they can not have differnt limits for the resource itself.

What you can do is that AFTER you assign the activities you can change the Max Units/Time within the resource assigned too the activities. 

Unfortunely you can't change these with a column fill down or a global change. The fastest way to do this would be to export the activities and resources to excel making sure to incluse the Max Units/Time in the export and change them in excel amd import them back into P6.

So to answer your question NO not at the resource level but YES at the activity level.