Resource Leveling Macro

[pec]

The challenge is to have resources loaded according to allocation. For
example, a resource is assigned to a particular Cost Account at 50% with many
tasks, how can I add the resource to these tasks to equate to a total of 50%?
Is there a macro than can be created to automatically level the resource or
spread the resource equally across assignments as allocated and over the
total time period?

 

[Jan De Messemaeker]

Hi,

There is no spreading macro, at least not one I know of.
The way to handle this is
in the project set the working time to 4 h/d
assign teh resoruce 100% to all
Now use Project's leveling

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[pec]

Jan,

What if the resource is assigned to several different cost accounts on the
project? Would I be able to specify work hours for each cost account? calendar

 

[Jan De Messemaeker]

Hi,

"Cost account" is not a Project term, so sorry, could you clarify what you
mean? A summary task? A project file?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[pec]

Sorry, cost account is in reference to earned value. So, in this case it
would be work breakdown or summary task

 

[Jan De Messemaeker]

Hi,

If respecting this % of time is so important (which is shocking to me, I
would always allocate resources to the most urgent tasks, not in less
relevant percentages) , I see only a very complicated option, that doesn't
even work in all cases:

* Develop the necessary calendars representing the desired % of time.

Leave the resources at 100%, full day calendars
To the TASKS of a summary task, assign a task calendar representing the %
the resources will be allowed to work on this summary task

Level with a day by day setting

Note: this doesn't work if different resources have different allocation %
within the same summary task
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[pec]

Jan,

It is important based on the fact that this data is also extracted for
earned value. Therefore, the resource loading must equates to the baseline
as close as possible.

Thanks for feedback