Project Resources \ Splitting Resources

K

KRL

Hopefully someone may be able to help me,

Working on Project 2000, with task schedules linked to a resource pool does
anyone know if the following is possible? The change itself is simple but
because of the number of tasks that need to be changed I wondered if anyone
new of a quick way of splitting work on tasks? I've was thinking of writing
code to do this but I just want to check first:

Hypothetical situation, 4 named resources in a resource pool, all involved
with the same tasks and the same percentage of work on each task (For cost
reasons they can't grouped). I need to add a fifth resource to each of the
tasks the 4 resources are working on, which will reduce the work amount of
each of the 4 resources and not increase the overall work of the tasks

For example:
Task 1: Duration 1 day and work 1 day. 5 resources assigned to the task, 1st
resource has 40% of the resource units the other 4 (the 4 mentioned above)
have 15% each (or 0.15 days of work each).
I need to add a resource that will share the work of the 4 resources that
have the 15% share, in effect the task needs to become:
Task 1: Duration 1 day and work 1 day. 6 resources assigned to the task, 1st
resource has 40% of the resource units the other 5 have 12% each (or 0.12
days of work each).

Thanks in advance.
 
J

Jan De Messemaeker

Hi,

If the 6th rfesoruce could take its share of all fuive of the other ones you
cauld have used fixed duration, effort driven, but twhat you propopse is
indeed only feasible through code.
HTH
 
S

Steve House [MVP]

One thing you need to double check right away is the way you are
interpretting the resource assignment percentage. If I have a resource
assigned 40%, that means he's producing the equivalent of 40% of the total
duration in man-hours, NOT that he's doing 40% of the total work required on
the task. In your example it happens to work out the same but it is by no
means universal that it will.

Essentially you are asking Project to exhibit a mixture of non-effort driven
and effort driven behaviors. AFAIK, that'll either have to be done by hand
or though VB.

Steve House [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top