%complete vs schedule

Home Forums Microsoft Project Discussion Forum %complete vs schedule

Viewing 4 reply threads
  • Author
    • #413630
      George Evans

      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!

    • #413631
      Carlos Santos

      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

      (from Portugal)

    • #413635
      Carlos Santos

      Hi George

      Your Feedback please.

    • #413637
      Trevor Rabey

      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?

    • #413663
      Carlos Santos

      Hi George

      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 cfps5001@gmail.com

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