delay estimation

[Stevan]

I show percent completion and progress line on gant bars. The differnce
beetwen status date and complete through point in fact is delay. I would like
to show that (delay) in a column. How can I do that? Is there formula
(customize fields) that can show delay or any other proposal?

Regrads,

Stevan

 

[Jim Aksel]

%Complete is a linear measurement of time as a % of task duration. In a
spare duration column, or text field, try a formula something like this:

([%Complete]*[Duration])-([Status Date]-[Start])

Positive values are ahead of schedule, negative represent behind. Keep in
mind that project calculates everything in minutes so yiou may need to divide
the entire answer by the number of work minutes in a day to get an answer.

Consider burying this formula inside an If statement so it only calculates
for tasks with a start less than the status date:

iif([start]<=[Status Date], ([%Complete]*[Duration])-([Status Date]-[Actual
Start]), "NA")

You could let the formula sit without the IF and it would show projected
delay or ahead. Play with the syntax if needed, I didn't check it.

Another way to do this would be using Schedule Performance Index assuming
you have a properly resource loaded schedule with costs. Using SPI and
Physical%complete would take into account the actual spread of the costs and
earned value.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Jim Aksel]

My first post gives you philosophy. Now that I've had coffee, putting this
formula in a spare *number* field will give you an answer in Days and include
the appropriate sign (negative being behind schedule, positive ahead)

([% Complete]*[Duration]/(100*[Minutes Per
Day]))-(ProjDateDiff([Start],[Status Date])/480)


--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project