Forum Discussion

chinthala91's avatar
chinthala91
Copper Contributor
Jun 17, 2024

hi i am having some issue in MS project progress update of fixed duration task

in the above schedule task-6 slab formwork is started before the predecessor task has finished. say it started on 05-06-2024 and i am updating the progress on end of 12th day i.e 16-06-2024. so in the update task dialouge box when i enter the following details 

% of complete as 50%

actual start as -05-06-2024 

remaining duration as 12days

actual duration as 12days 

once i press enter the result showing as 100% completed as per below picture , instead of showing 50% completion how it is possible i am doing anything wrong here please help .

 

  • John-project's avatar
    John-project
    Silver Contributor

    chinthala91

    A few questions are in order.

     

    If the task is 50% complete, why is the actual duration AND the remaining duration both set at 12d? The original duration was scheduled for 7 days so even though you enter a percent complete value of 50%, as soon as you set actual duration to 12d, Project re-calculates percent complete as 100% (percent complete = actual duration/duration or 100% maximum).

     

    So what really is the status of the task? It started early, I get that, but what about the 7 day planned duration versus the apparent 12d remaining duration? And if it's half done, is it now a 24d task?

     

    Are any resources assigned to the task? Bear in mind that percent complete is duration based and has nothing to do with how much work is preformed. The only type of tasks that are truly duration based are things such as concrete curing, paint drying, wounds healing, etc. The vast majority of "stuff" that gets accomplished is via effort (work) performed by labor or machine resources. And progress is measured by how much actual work is performed compared to the estimated work to accomplish the task (i.e. percent work complete).

     

    John

    • chinthala91's avatar
      chinthala91
      Copper Contributor

      HI John-project 

       

      First, thanks for taking the time to respond to an unknown. As you rightly asked the task was initially scheduled to be completed in 7 days, but the task was started a little early i.e 05-06-2024 and up to the status date i.e 16-06-2024 the elapsed duration is 12 days, in the 12 days say 50% of work is completed. The estimated duration for the balance work to be completed is 12 days. So the revised task duration will be 24 days. if this is the situation the % complete should show as 50% right?

      Please correct me If i am wrong.

       

      chinthala venkatesh 

       

      • John-project's avatar
        John-project
        Silver Contributor
        chinthala91,
        When you input actual duration and remaining duration Project will automatically calculate percent complete. So, don't try to force the issue by also inputting percent complete. In other words, use this process.
        1. input the actual start date
        2. input actual duration
        3. input remaining duration
        Project will then calculate the percent complete at 50%. Boom! you're done.

        I'm not sure what you were trying to ask in your private message (i.e. "clarify my doubts").

        John
  • Hi chinthala91 

    You can try these two options in this scenario you describe to obtain a result like the one you are looking for:

     

    Option A: If the task is of type Fixed Duration, and the Actual Duration exceeds the Duration of the task before its update Project will set the % Complete to 100%.
    In the event that the actual Duration is less than the previous one of its update, it takes as the final Duration of the task the working days between the Start and Finish dates, regardless of the interruption time that exists between them. Thus, and applying the formula, the % completed would be equal to 100 x Actual Duration / (Actual Duration + Remaining Duration), a value that may not be significant for the progress of the task, especially if the task is not continuous and has predecessors that interrupts the task and postpones the remaining Duration.

     

    In this case the solution would be to change the Type of task before updating, to Fixed Units or Fixed Work, instead of Fixed Duration.

     

    Option B: The other workaround is to delete, before updating, the predecessors that interrupt the task and postpone the Remaining Duration, in this case Id=5.

     

    I hope I've helped.

    Ignacio

Resources