Future Task indicators in PWA

[Ram Uppu]

I used following formula for showing stop light indicators for tasks whether
they are running late or on time based on % work completed and thier duration
and remaing duration.

IIf([% Work Complete] = 100, -9999, (IIf([% Work Complete]<>100 And
[Duration]>0,(cDbl([Remaining
Duration])/480)-(ProjDateDiff(CDate(Date()),[Baseline Finish]))/480,0)))

Logic follows as this,
if work is complete already show Green smiley ( value -9999)
If work is not completed and duration is more than 0 (not a mile stone task)
and
remaining duration in days - remaing days left in scheduled from today based
on baseline finish > 10 red light
remaining duration in days - remaing days left in scheduled from today based
on baseline finish > 5 yellow light
remaining duration in days - remaing days left in scheduled from today based
on baseline finish <= 0 green light

This is working well for the tasks that are already completed and running
late.

I have two issues, future tasks which are dependent on the tasks that shows
red light still shoes green as they are not started yet. I want them to show
the light based on ther parent taks status. Obvisously since parent task is
running late they are also in danger of missing the date. I want to reflect
that in the indicator.

Second issue is mile stone are always green as my formula uses duration > 0,
i want to show mile stone status based on the tasks its preeding. If any one
task before it is red it should shoe red.

 

[Guidho]

To get all those conditions in one formula will be very difficult.
You might want to use a macro to accomplish this:
- create a custom field with possible values 1,2 and 3
- assign graphical indicators (1=green,2=yellow,3=red)
- create a macro which will et this field to 1,2or three based on you
conditions.
In pseudo code, the
macro would look like

For each Task in Project.Tasks
If (your formula) > 10 then 1
else > 5 then 2
else then 3
OR
if predecessor = red then also red
...
Next

Hope this helps,
Guidho