maximizing the use of resources when leveling

[Session]

Hi. I'm looking to assign a resource to multiple concurent tasks of
different durations. What I would like is for leveling to spread the
resource's unit usage equally across the tasks to cover an 8hr schedule every
working day: meaning that if he is working on 3 tasks at the same time, he
will be assigned at 33% for each, and once one of the tasks is over, than
he'll be assigned 50% for each of the remaining 2. So the unit usage won't
be constant for an entire task. Is that even possible with Project 2007, is
it possible in code?

Thanks,
Session

 

[John]

Hi. I'm looking to assign a resource to multiple concurent tasks of
different durations. What I would like is for leveling to spread the
resource's unit usage equally across the tasks to cover an 8hr schedule every
working day: meaning that if he is working on 3 tasks at the same time, he
will be assigned at 33% for each, and once one of the tasks is over, than
he'll be assigned 50% for each of the remaining 2. So the unit usage won't
be constant for an entire task. Is that even possible with Project 2007, is
it possible in code?

Thanks,
Session

Session.
Sorry but that's not how leveling works. Project's leveling algorithm
will allocate resource time based on the task priority. If all
concurrent tasks have equal task priority, it will schedule the longest
task first, but it will assign the resource to completely finish the
highest priority task first, then the next priority and so forth. Even
if you manually assign the resource at 33% to each of three tasks,
leveling will still take the tasks in priority order.

The only way I know to do what you want is with VBA. However, unless you
have Project VBA experience or have a compelling reason to want to do
this automatically, it may not be worth the effort to develop the code.

John
Project MVP