Exact formula for %Complete for task with multiple assignments??

[Carl Paul]

Hi
Anybody know the exact formula for %Complete of a task with multiple
assignments?

This is a more complicated question than it first appears. Internally, the
assignment table has no duration field. If you wanted to calculate the
duration of an assignment, you would have to iterate through all the
assignment detail records and even then the algorithm would be somewhat
arbitrary.

I suspect the %Complete for a task with multiple assignments is actually
based on assignment work and actual-work. Is this true??


Carl

 

[John]

Hi
Anybody know the exact formula for %Complete of a task with multiple
assignments?

This is a more complicated question than it first appears. Internally, the
assignment table has no duration field. If you wanted to calculate the
duration of an assignment, you would have to iterate through all the
assignment detail records and even then the algorithm would be somewhat
arbitrary.

I suspect the %Complete for a task with multiple assignments is actually
based on assignment work and actual-work. Is this true??


Carl

Carl,
No, it is not true. I think you are getting duration and work confused.
Duration has nothing to do with assignments - that's why there is no
duration field for assignments.

Percent Complete is duration based so it doesn't matter how many
resources are assigned to a given task. The formula is very simple - it
is simply:
% Complete = (Actual Duration)/Duration

Perhaps what you really want to look at is % Work Complete. However, the
formula is still trivial, it is:
% Work Complete = (sum of Actual Work for each assigned resource)/(Total
work for task)

John
Project MVP

 

[Carl Paul]

Hi John,

I am a programmer, and am interested in a programmer level algorithm.
Visualize a single task with multiple assignments with separate assignment
delays offsetting the start of each assignment. In addition, actual work has
come in on each assignment in fits and starts so that the detail assignment
records in MSP_TIMEPHASED_DATA represent a sparsely populated matrix with
many gaps – days where no one worked on the task at all.

In this situation, how is the actual duration aggregated across the
assignments?

 

[Jan De Messemaeker]

Hi,

This can readily be tested in a task usage view
From what I see
- Tasks with Work=Actual Work>0 count as a day in Actual duration
- Tasks with Actual Work=0 don't count at all
- Tasks with Actual Work>0 but <Work are prorated based on Work

So for the final level of detail you're right, Work seems to be taken into
account for Actual Duration.

Hope this helps,


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