I will explain hot to track Physical % Complete in MS PROJECT 2013.
In MS PROJECT you can Track %Complete, % Work Complete, and Physical % Complete. Where are the differences?
- % Complete is about Duration
- % Work Complete is about how much work (in hours, for example) is done
- Physical % Complete is how much Physical work is done
Let’s go! First I will make a brand new Project with one Task:
I’ll now add John as Resource and I’ll assign him to the Task:
I’ll switch to the Task Usage View, and I’ll add Actual work field:
and I’ll get:
I’ll now change Work field, so John will have to work only 4 hours at Monday, and Tuesday:
Now, I’ll add %Complete, %Work Complete, and Physical % Complete fields on the right part of the screen:
Let say that it was 50% spent on the Task 1:
As you can see, %Complete is 50%, but % Work Complete is 38%. Where is the difference?
%Complete is 50%, and that means that John has worked 50% of duration, e.g. 5 Days * 50% = 2,5 days! So, if he worked only 2,5 days Actual work (in hours) is 4 hours at Monday, 4 hours at Tuesday, and 4 hours at Wednesday (half day, because John has to work 8 hours at Wednesday). This is what %Complete means = %Duration
On the other hand, John is supposed to work 32 hours to complete his Task. Hi already worked 12 hours (4 hours at Monday, 4 hours at Tuesday, and 4 hours at Wednesday). Simple math: %Work = 12 hours (Sum of Actual hours)/ 32 (Sum of work) = 0,375 = 38%
OK! I know that, you idiot, you will say. You had the same example few days ago! I know! But what about Physical % Complete?
John spent 2,5 days (50% of Duration) and 12 hours (38% of %Work Completed), but, just for example, he completed 90% of Task! So next 2,5 days, he will spend 20 hours for finishing 10% of his physical work. If the Task is, for example, Publishing the Book, he might wrote in 2,5 days, but next 2,5 days (and 2’0 hours), he need for reviewing it with editor, fix misspelling etc.
For that purpose I will put 90% in Physical % Complete!
OK! What can you do with that? You can calculate EVM on that way! I’m not going to show you here EVM report, because I have to leave something for my further Posts.
But, as you can see there is 0% of Physical Complete in Project Summary Task. To have it roll up, you should follow this steps:
- Make sure that you have put value greater than 0 in Standard Rate in Resource Sheet.
- Change Earned Value Method to Physical % Complete:
3. Save the Baseline:
And, here it is: