Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Index of completeness on project/activity RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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? 

    Thanks in advance

    Tuesday, March 29, 2011 12:25 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 Badal Ratra Tuesday, March 29, 2011 2:25 PM
    Tuesday, March 29, 2011 1:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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