I would like to compare %Complete to where I should be using MS Project 2013

[Tokor13]

I have a project with different tasks.
Someone fills the column "% Complete" to reflect the work that it's been done.
Sometimes those tasks are late and sometimes are ahead in time.
what I would like to know is where I should be (%-wise) for each task and summarise that for the whole project (summary task)

Thanks

 

[johnherman]

As you probably know, you can't just add the percentages because not all tasks are "equal". Whether you can get anything useful depends on whether your tasks are Work, Duration, or Effort driven. If they are a mix of two or more, then you have a very difficult problem. However, if all tasks are the same type, then you can us Project's calculation to sum the raw numbers.

====================================
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[JulieInMaine]

Hi Tokor13,

See

http://www.msprojectblog.com/References/Celeris What Percent Complete Shoud I be.pdf

. The short answer is you need Earned Value. See the white paper for a indepth discussion.

 

[Tokor13]

Hi
Thanks!

I read that paper because I think that´s what I need but the formulas they are using are not working
I think when you customise formulas, if you mix number an durations the result is wrong
So I haven´t found the way to adapt those formulas to something that works for me..

Thanks to all the people who answered

 

[JulieInMaine]

You're not giving us a lot to go on here. What about the formulas is not working? Why don't the formulas as written work for you?

 

[SkipVought]

hi,

Theoretically, where you should be is
[tt]
[Today - PlannedStart] / [PlannedEnd - PlannedStart]
or
[Today - PlannedStart] / [Duration]
[/tt]
So lets say that the PlannedStart is day 5 and Today is day 11 and the task duration is 10 days, then you should be 6 days into your task and the PlannedComp% = (6/10)*100 or 60%

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[johnherman]

In addition to Skip's calculation on duration, there are also effort and work calculations.
(Hours Planned - Hours Spent) / Hours Planned (or days or weeks instead of hours)

But JulieInMaine is correct that Earned Value is the most accurate, objective, and widely accepted measure of project progress.

====================================
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw