Stoplight Chart Help PLEASE

K

Ken K

Whenever I research stoplight charts the examples given
are always for budget - llf([Baseline Cost]=0,0,(llf([Cost]
<([Baseline Cost]*1.2),llf([Cost]<([Baseline Cost]
*1.05),1,2),3)))) - What is the formula I would use if I
want to indicated whether or not a task is on schedule???
Would I still make sure that Task is checked and Number is
used as type in the Customize Fields dialog box? Also,
what values should I use in the Graphical Indicators box?
I've been struggling with this for quite some time now so
any help that can be provided would be greatly appreciated.

Thanks,

Ken
 
M

Martin SPIS

Use the field [Finish Variance] instead of Baseline Cost
and divide the result by the number of minutes in your
working day (my example is a 7 hour day so 7 x 60 = 420)
This will translate the variance into days rather than
minutes.
e.g. [Finish Variance]/420

In this scenario and where the above formula is
Enterprise Number 1 then the following formula will give
you a red indicator where a project or task is more than
10 days off schedule and otherwise a green indicator.

IIf([Enterprise Number1]>10,"RED",IIf([Enterprise Number1]
0,"AMBER","GREEN"))
Click to expand...

Hope this helps
-----Original Message-----
Whenever I research stoplight charts the examples given
are always for budget - llf([Baseline Cost]=0,0,(llf ([Cost]
<([Baseline Cost]*1.2),llf([Cost]<([Baseline Cost]
*1.05),1,2),3)))) - What is the formula I would use if I
want to indicated whether or not a task is on schedule???
Would I still make sure that Task is checked and Number is
used as type in the Customize Fields dialog box? Also,
what values should I use in the Graphical Indicators box?
I've been struggling with this for quite some time now so
any help that can be provided would be greatly appreciated.

Thanks,

Ken

.
Click to expand...
 
G

Gérard Ducouret

Hello Ken,
What are the criteria you want to test to say whether or not a task is on
schedule ?
A very simple one would be the [Finish Variance] :
The formula, in a Number field, could be : [Finish Variance]/480
where 480 is the number of minute in a 8hr day.
The graphical test indicator for Number1 could be :
- is greater than ... 5 .. red light
- equals ... 0 ... nothing
- is less than ... 0... green light

Hope this helps,

Gérard Ducouret
 
Top