none
MS Project. real progress of the project, % complete RRS feed

  • Question

  • Hello! Is there a formula or some way to calculate the real progress of the project in %? Unfortunately, there are no resources, no money, no time spent, only tasks with their duration, start, finish, baseline and % completion. Tried through the formula of the planned % completion: 

    Round(IIf([Milestone],IIf([Start]>=[Status Date],0,100),IIf([Start]>=[Status Date],0,IIf(ProjDateDiff([Finish],[Status Date],[Project Calendar])>0,100,ProjDateDiff([Start],[Status Date],[Project Calendar])/[Duration]*100)))) & "%" 

    But it does not reflect reality, it is simply tied to the status date, and if we increase the % of completion as, for example, ahead of the plan, the indicator does not change.  We also tried another method, created 2 numerical fields, one assigned the values of the formula IIf([% Complete]=100,1,0), the second one - IIf([Milestone],0,1) then calculated by formula: IIf([Summary],Format([Number1]/[Number2],"###%")," ") , but still the calculations are not quite accurate, besides, with the increase in the percentage of completion tasks, the formula calculates 104% for some tasks. Are there other methods for calculating the real progress of the project? Thank you!
    Wednesday, October 30, 2019 8:01 AM

Answers

  • Hi, there are 3 % complete available in MS Project, and of course you can create your own.

    %Complete is a measure of the duration.

    %Work Complete is a measure of the work

    Physical % complete is a measure of what has been achieved.

    You may also wish to review this blog post. https://applepark.co.uk/how-to-calculate-planned-project-project-online/ 


    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Thursday, October 31, 2019 11:54 AM
    Moderator

All replies

  • Hi,

    Welcome to this Office forum, the forum is focuses more on questions related to Office deployment. Considering the issue is mainly about specific formula problem in Project, I will move the thread to Project forum. You may get more helpful replies there. 

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thanks for your kind understanding.

    In addition, I find an article How is project progress calculated. Maybe you could refer to it, there is a formula about the how to calculate the overall project with a weighted average. 

     (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

    If you have any updates, please feel free to let me know.

    Best Regards,

    Emily


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, October 31, 2019 4:54 AM
  • Hi, there are 3 % complete available in MS Project, and of course you can create your own.

    %Complete is a measure of the duration.

    %Work Complete is a measure of the work

    Physical % complete is a measure of what has been achieved.

    You may also wish to review this blog post. https://applepark.co.uk/how-to-calculate-planned-project-project-online/ 


    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Thursday, October 31, 2019 11:54 AM
    Moderator
  • Ben,

    I don't know why MS felt it necessary to move this post to the this forum. It was originally posted on the Project part of the MS Business forum (the old Answers forum). Both myself and Trevor responded on that forum, along with a third person as of this morning. Ref: https://answers.microsoft.com/en-us/msoffice/forum/all/ms-project-real-progress-of-the-project-complete/0357a6dd-f2b4-4e5b-bf1e-c5d7e6c74353

    John

    Thursday, October 31, 2019 3:46 PM