Stop Light Code search?

[Bert]

Are there any basic codes to plug & Play for those of us who are programming
challenged? Project Server 2003
Definitions for stop light colors to be implemented in the Project Summary
View:

10 days ahead of schedule = Blue

< 10 days ahead of schedule Or equal to due date = Green

1 day to < 10 days behind schedule = Yellow
10 days behind schedule = Red

Is there any code written for this type of "stop light" decision tree or a
similar scenario that I could use

 

[Brad Harris]

Try using this:
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

Then setup the conditions for light changes.
Then, Baseline your project.
Hope this helps

 

[Bert]

Very nice Brad
Thank you
--
Bert

Try using this:
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

Then setup the conditions for light changes.
Then, Baseline your project.
Hope this helps

Are there any basic codes to plug & Play for those of us who are programming
challenged? Project Server 2003
Definitions for stop light colors to be implemented in the Project Summary
View:
< 10 days ahead of schedule Or equal to due date = Green
Is there any code written for this type of "stop light" decision tree or a
similar scenario that I could use

 

[NZ Projects]

It's also worth checking for tasks which are less than 100% complete where
the finish date is less than today. Whilst the task may be on schedule it's
important to know that there maybe an awaiting update.

Very nice Brad
Thank you
--
Bert

Try using this:
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

Then setup the conditions for light changes.
Then, Baseline your project.
Hope this helps

Are there any basic codes to plug & Play for those of us who are programming
challenged? Project Server 2003
Definitions for stop light colors to be implemented in the Project Summary
View:
10 days ahead of schedule = Blue
< 10 days ahead of schedule Or equal to due date = Green
1 day to < 10 days behind schedule = Yellow
10 days behind schedule = Red
Is there any code written for this type of "stop light" decision tree or a
similar scenario that I could use

 

[John Sitka]

Utilize two custom Enterprise Project Fields
One date which represents the deadline of the whole project
One number which represents the variance between the deadline and the last task [Project Finish}
here is the formula to calculate the Enterprise Project Custom Number Field,
Enterprise Project Date1 is the Enterprise Project Custom Date Field mentioned above.

IIf([Enterprise Project Date1]=ProjDateValue("NA"),0,Cint(DateDiff("d",[Project Finish],[Enterprise Project Date1])))

Apply appropriate color indicators to that value

Build Project center views as required (but there really is no need) or just click on the header in PWA and show
in the appropriate order. Also publish the One date which represents the deadline of the whole project and order by that,
it is after all the most common enterprise focus.