Question: How to calculate % Complete and % Work Complete?

[Merry]

Hi,

Who can give me an answer to my question?

Thanks
Merry

 

[Jan De Messemaeker]

Hi,

My first reaction is: Don't. Never do. Project does that, it's not your job.
This being said, this is how Project does it
%Complete = 100 * Actual Duration / Duration
%Work Complete= 100 * Actual Work / Work

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

 

[Merry]

Thanks Jan.

The following question is how to calculate the Actual Duration?

Thanks,
Merry

 

[Jan De Messemaeker]

Hi,

You ask the resource who did it: during how many days has there been any
work on this task?

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

 

[Merry]

Hi Jan,

I mean the whole project's Actual Duration. Is there any formula to do this?

Thanks,
Merry

 

[Jan De Messemaeker]

Hi,

Customize one of the custom duration fields with the formula =[Actual
Duration] and make sure the formula is applied to summary tasks and the
project summary task. The latter will show the project total.
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

 

[JulieS]

Pardon me for bumping in. If you display the project summary task
( Tools > Options, View tab) and then show the tracking table,
you'll see total actual duration is already calculated for you at
the project summary task line as well as for all other summary
tasks.

Julie

 

[Jan De Messemaeker]

Hi,

Oh God. I thoght he meant the total of all actual Durations for the
different tasks.
Greetings,

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