"Start on Time" Indicator (2007)

[Sebastian Cordoba]

Hi everyone.

I need to implement a indicator which shows if a task started on time and
finished on time (comparing against Baseline values). I was thinking of this
formula:

ProjDateDiff([Baseline Start],[Actual Start])

Is it OK? What should I change?

Thanks for your help.

 

[Mauricio Iannini, PMP, MCITP]

Sebastian,

Check these two formulas

IIf([% Complete]=100, "Complete Project",IIf([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 25% over baseline
schedule",IIf(([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.1),[Project Calendar])) And [Finish]<ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 10% over baseline
schedule","On or under baseline schedule")))

IIf([% Complete]=100,"Complete Project",IIf(IsDate([Baseline
Finish]+0)=0,"No Baseline",IIf([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 25% over baseline
schedule",IIf(([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.1),[Project Calendar])) And [Finish]<ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 10% over baseline
schedule","On or under baseline schedule"))))HTH

You have to change [Project Calendar] for the calendar of your choice

Hope this helps,

Mauricio

 

[Jack Dahlgren]

This information is already available in the built-in "Start Variance"
field. There is a similar field for "Finish Variance"
No need to write a formula for this.

-Jack Dahlgren

 

[Jack Dahlgren]

Mauricio,

You certainly are going about it the hard way!

An easier way to write this:
(ProjDateDiff([Baseline Start],[Baseline Finish],[Project Calendar])

is:
[Baseline Duration]

A better way to do:
IIf(IsDate([Baseline Finish]+0)=0,"No Baseline"
is:
iif([Baseline Finish]=projdatevalue("NA"),"No Baseline"

-Jack Dahlgren

Sebastian,

Check these two formulas

IIf([% Complete]=100, "Complete
Project",IIf([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 25% over baseline
schedule",IIf(([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.1),[Project Calendar])) And [Finish]<ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 10% over baseline
schedule","On or under baseline schedule")))

IIf([% Complete]=100,"Complete Project",IIf(IsDate([Baseline
Finish]+0)=0,"No Baseline",IIf([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 25% over baseline
schedule",IIf(([Finish]>ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.1),[Project Calendar])) And [Finish]<ProjDateAdd([Baseline
Finish],(ProjDateDiff([Baseline Start],[Baseline Finish],[Project
Calendar])*0.25),[Project Calendar]),"At least 10% over baseline
schedule","On or under baseline schedule"))))HTH

You have to change [Project Calendar] for the calendar of your choice

Hope this helps,

Mauricio

Hi everyone.

I need to implement a indicator which shows if a task started on time and
finished on time (comparing against Baseline values). I was thinking of
this
formula:

ProjDateDiff([Baseline Start],[Actual Start])

Is it OK? What should I change?

Thanks for your help.

 

[Sebastian Cordoba]

Thanks Mauricio.

O mejor dicho: ¡Gracias Mauricio! No sé si te acuerdas de mí, pero en algún
momento te estuve haciendo unas consultas acerca de las PMO. Recuerda que nos
contactamos a través del PMOSIGroup.

Es buena contar con tu ayuda una vez más. Hasta pronto.

 

[Sebastian Cordoba]

Thanks your help Jack.

But I have a doubt: If the PM's don't save the baseline, the variance it's
always gonna be '0'. This also is gonna happen (Variance = 0) if the actual
start and the baseline start have the same value.

So, I suppose that I have to verify first if there's is a baseline, right?
(using a flag for example)

It could be something like:

iif([Baseline Start]=projdatevalue("NA"),"-9999999", Start Variance)

And then I could use graphical indicators for the value of this formula.

Am I right?

 

[Jack Dahlgren]

Sebastian,

You could treat it that way, but I'd probably just show the baseline column.

-Jack

 

[Mauricio Iannini, PMP, MCITP]

Hola Sebastian,

Claro que si me acuerdo. Por aqui a la orden en lo que te pueda ayudar con
Project y Project Server,

Saludos

Mauricio