Hi,
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:
and:
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:
And, here it is:
Regards!
Pingback: % Complete VS Physical % Complete in MS PROJECT 2013-6 | It's all about Project Management....
Good day to you sir. Regarding to this matter. I have enter the figure for my Physical %. However, the summary on the Physical remains zero. Can you help me Sir. Thank You
Yes it does. It make a sense because sum of Physical % is not logical
Dear Sir, This Ram from Bahrain. i had the same issue with Physical % complete field. i did all the steps which you stated above and in the project summery field overall physical % complete is not displaying. i entered the actual values only as all those are quantity based. can you help in this issue .
Thanks & Reg..
Ram.
Did you put standard rate for resource? did you assign resource to the Task? did you save the Baseline? dd you change the EMV method?
Hi you know why some tasks even thou you might put 100% the summarize doesn’t make it to 100% stays in 99%. Any idea why this might be happening? I been searching for something similar to implement as a physical 100% complete with summarize included. Thanks!
I should see your mpp file!
Pingback: % Complete VS Physical % Complete in MSP-2013 | It's all about Project Management....
Mr. Nenad Trajkovski
I am Siddeshwar from Mumbai, India, can you plz tel me if I enter 50% in % physical complete, will the roll up to project summary shows me the same 50%?
You should save a Baseline, and have std. rate for your resurces. Foloow the steps in my Post!