how to evenly distribute the resource workload among several tasks

[Elena Osipova]

Hi,

could you please advise me on how to do such a thing:
- we develop a plan (WBS + task dependencies + durations)
- assign several tasks to one resource
- at each moment of time the system recalculates the % of workload for every
task assigned to have always 100% per day for each resource

Is it possible at all? Or may be the algorithm should work differently? The
main goal is to escape resource overload.

thanks,
Elena

 

[CTA]

Hello,

You can change the units on the assignment to be a percentage of the
resource's total capacity:

Resource Name = Elena

Task 1 (Elena) Assignment Units = 50%
Task 2 (Elena) Assignment Units = 50%

Double click on the task to bring up that Task Information Dialog,
choose the Resources Tab and set the resource units there.

Hope this helps,

Colby Africa
http://colbyafrica.blogspot.com

 

[John]

Hi,

could you please advise me on how to do such a thing:
- we develop a plan (WBS + task dependencies + durations)
- assign several tasks to one resource
- at each moment of time the system recalculates the % of workload for every
task assigned to have always 100% per day for each resource

Is it possible at all? Or may be the algorithm should work differently? The
main goal is to escape resource overload.

thanks,
Elena

Elena,
By itself Project cannot automatically re-distribute workload so that
each resource is always at 100%. There are just to many variables to
consider. If you can capture all the variables you might be able to
develop an algorithm and write some VBA code to do what you want, but it
probably won't be easy or straightforward.

You can use Project's built-in leveling function to help eliminate
resource overallocation but using the leveling function requires the
project manager to review the resulting schedule and make manual
adjustments as necessary.

There just isn't any substitute for human intervention when working with
scheduling dynamics.

John
Project MVP

 

[Elena Osipova]

Thanks, John

That was my view also, so now I'm pretty sure that such things shouldn't be
automated.

Elena

 

[John]

Thanks, John

That was my view also, so now I'm pretty sure that such things shouldn't be
automated.

Elena

Elena,
You're welcome and thanks for the feedback.
John