MS Project. Real progress of the project, % complete


Joined
Oct 31, 2019
Messages
1
Reaction score
0
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.
We would be fine with the results of the planned % completion formula if it could be tied to the task's % completion, not just the status date. But there's no way we can succeed. We call for the help of the collective mind. Is it possible to do such formula? Are there other methods for calculating the real progress of the project? Thank you!
 
Ad

Advertisements

Joined
Sep 23, 2021
Messages
1
Reaction score
0
Your model is primitive. You only have the task durations, and the start and finish date/time. You have no resources and therefore no work or costs associated with resources. You also have no costs directly assigned to tasks as fixed cost, and therefore your tasks and the project overall have no cost. What do you mean by "real progress of the project in %?". % of what? The only % available to you is the % complete, which is defined as actual duration/total duration. Anyway, you don't want it, you can't use it for anything meaningful. What you need is the actual start and the actual duration. and when you input these (and the actual finish if the task is finished) in the fields/columns in the tracking table, you will have what you need to report and interpret progress, to the extent that your model will allow it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top