I am a rank amateur on Project and have what I believe is an elementary question. Is there already a field or can a field be calculated that would show expected percent complete based on today’s date versus current start and finish dates? I would expect the calculation would be (today’s date-start date)/(finish date-start date). I would then like to compare that to a manually entered % complete and calculate a variance to that. Is this an existing capability or will I have to use custom fields?
Thank you in advance for any assistance you can offer!
Save column % complete (values manualy insetted) to a new column/field inserted ex: text1
Set status date, then right click on gantt chart see status date (choose colour red)
Matk all selected (you want to compare) tasks on track
Compare the two columns
Your Feedback please.
George, Carlos has described how to do it, but my interest is in why you would do it. What purpose does it serve? For example, what use is it to be 5 months into a 12 month project and still be referring to the plan that you had 5 months ago?
A way to compare planned progress to actual progress is a common request.
In my opinion it is a futile question and a pointless exercise.
Sure, it sounds like a good thing to have, and probably not hard to get.
But no one thinks it through.
It may be unavoidable if the question is associated with a claim or a dispute.
Otherwise, however, it is an unnecessary complication, extra difficult work etc for a limited payoff.
It is hard to get and does not yield useful information for project control.
Lawyers and their consultants love working on disputes and claims because they can spend vast amounts of billable hours on useless complicated calculations whose only purpose is usually to assign blame and fault, and to generate further dispute.
You must note that if someone wants the planned % complete as at some date, it will require that the plan be a version with no progress recorded.
That is, it will ideally be the early version that existed immediately before project execution started.
Also, this is not a one off exercise because the comparison of planned progress with actual progress will be required at other dates during the course of project execution or at, say, typically, every status date.
If you want please contact me email@example.com