MS Project 2016. Real progress of the project, % complete

Home Forums Microsoft Project Discussion Forum MS Project 2016. Real progress of the project, % complete

  • This topic is empty.
Viewing 4 reply threads
  • Author
    • #416724

      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!

    • #416726
      robert oler

      I would think that in the absence of the data you mentioned (hours, cost, etc.) the %WorkComplete field would suffice, no?

    • #416728
      Avatar photoLarry Christofaro

      Sasha, sorry I don’t have an answer for you that corrects your formula. have you tried just using the Physical % Complete field and manually updating your tasks…or maybe using that as an override for situations where you calculation doesn’t work (if Physical % complete exists, use that, else…)?

    • #485585
      Klais Surik

      As I have learned from my experience, it isn’t difficult to find a daily casino provided you have all the details you need. I’m happy to find one. I’m happy. I’m happy. I am really happy. I am very happy. By the way, by visiting parimatchwin you can find out more about incentives, which gives you all you need. I advise you to read it because I think it’s good for you. You should be able to gather many of the data you need. Good luck!

    • #486088
      Danish Khan

      I would say that festival is a good one in india where many people gather and celebrate it under the sky to send gifts, i have read an article on best dissertation writing research proposal writing service about the same where I got to know that culture is too great for people who need happening life.

Viewing 4 reply threads
  • You must be logged in to reply to this topic.