Index of completeness on project/activity

• Question

• Hello

I have the following issue to solve. Has project server build-in functionality of calculating index of completeness on specific date.

For example I 've planed activity: Task1 starts on 1.3.2011 and ends on 31.3.2011. Current date is 29.3. so this task should be almost completed (29/31 if we are not counting in holidays) but actual duration on this task is 10 days. So I would like to calculate some sort index of completeness. In this particular case the index of completeness would be low. Is this possible out of the box?

Tuesday, March 29, 2011 12:25 PM

• So only 10d of actual duration done. What estimate is there for remaining duration? Simplest metric is progress= Actual Duration / Duration (make sure remaining duration is updated first).

This has obvious weaknesses such as most of the work will be done in the last week for whatever reason. You may therefore be on time, but your earned value is currently still low.

I think your first step is to make sure remaining duration is updated. If it's still 10d or more, then clearly the finish date moves out (I hope you've saved a baseline?).

After tracking each week, make sure there is no incomplete work in the past and no actual work in the future. This provides more accurate % complete and predictions of completion dates.

Rod Gill

The one and only Project VBA Book Rod Gill Project Management
Tuesday, March 29, 2011 7:51 PM

All replies

• If i am understanding correctly then you want to flag off or use some kind of metrics to track wether this task was suppose to be completed w.r.t. current date if it isn't then indicator should flag it off, correct me if i am wrong

But if i have understood correctly then it can be achieved OOB with a little configuration which would be configuring a formula field, to have comparison based on current date and flag off, if delayed how much delayed it is,

Just pasting a formula for reference, which could be modified for achieving the desired result, these custom fields can be pushed to enterprise
but remember these formula fields gets recalculated only when MS Project is opened and F9(Recalculation) is done

switch([% Complete]=100,"Completed",Len(CStr([Baseline Finish]))<3 Or Len(CStr([Baseline Start]))<3,"No Baseline",([% Complete]=0) And ([Actual Start]=ProjDateValue("NA")) And (DateDiff("d",[Baseline Start],Now())>0) And (DateDiff("d",[Baseline Start],Now())<=15),"Task Over Due <= 15 Days No Progress Reported",([% Complete]>0) And (DateDiff("d",[Baseline Finish],Now())>0) And (DateDiff("d",[Baseline Start],Now())<=15),"Task Over Due <= 15 Days Some Progress Reported",([% Complete]=0) And ([Actual Start]=ProjDateValue("NA")) And (DateDiff("d",[Baseline Start],Now())>15),"Task Over Due > 15 Days No Progress Reported",([% Complete]>0) And (DateDiff("d",[Baseline Finish],Now())>15),"Task Over Due > 15 Days Some Progress Reported",(DateDiff("d",[Baseline Start],Now())<1),"On Schedule")

Hope this helps

Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
• Proposed as answer by Tuesday, March 29, 2011 2:25 PM
Tuesday, March 29, 2011 1:50 PM
• I would investigate the OOB Earned Value performance indicators (specifically SPI) rather than trying to re-invent the wheel.  Though if you do not track cost in MSP, you'll need to either enter a resource cost or develop custom formulas to work off labor hours.
Terrie T - MCTS - PMP - MBA****PMO & Project Server Admin
Tuesday, March 29, 2011 2:25 PM
• So only 10d of actual duration done. What estimate is there for remaining duration? Simplest metric is progress= Actual Duration / Duration (make sure remaining duration is updated first).

This has obvious weaknesses such as most of the work will be done in the last week for whatever reason. You may therefore be on time, but your earned value is currently still low.

I think your first step is to make sure remaining duration is updated. If it's still 10d or more, then clearly the finish date moves out (I hope you've saved a baseline?).

After tracking each week, make sure there is no incomplete work in the past and no actual work in the future. This provides more accurate % complete and predictions of completion dates.

Rod Gill

The one and only Project VBA Book Rod Gill Project Management
Tuesday, March 29, 2011 7:51 PM