TIME HEADLIGHT IN PROJECT PLAN
*******************************
Project 2010 or later versions:
IIf([Scheduled Duration]=0;(IIf([% Complete]=100;5; IIf([Scheduled Finish]
=80;3;IIf([Scheduled Finish]=100*(Abs(ProjDateDiff([Scheduled Start];Now())/ProjDateDiff([Scheduled Start];[Scheduled Finish])));2;(IIf([Scheduled Finish]>Now();IIf([Scheduled Start]>Now();1;3);4)))))
1. In Field, click Task
2. In Type, select Number
3. Select a field not used (like Number 1)
4. Click in Rename
5. Type "Time Headlight"
6. Then click OK
7. In Custom attributes, click Formula
8. Type the formula
9. Click OK
10. Click OK in the message "Existing data in the...."
**********
* Set 1,5 for activities on time
* Set 2,5 for activities delayed without impact on downstream activities but no impact on the Project end date
* Set 3,5 for activities delayed with impact on the Project end date
* Set 4,5 for activities delayed without delaying downstream activities
**********
11. In Calculation for task and group summary rows, click Use formula
12. In Values to display click on Graphical Indicator
13. Click on the first line of Test for 'Time Headlight'and select Equals
14. On the first line, select equals, type 4,5 and select blue Headlight
15. On the second line, select equals, type 3,5 and select red Headlight
16. On the third line, select equals, type 2,5 and select yellow Headlight
17. On the fourth line, select equals, type 1,5 and select green Headlight
Project 2007 or earlier:
IIf([Finish]>[Baseline Finish];IIf([Free Slack]<>0;2;IIf([Total Slack]<>0;3;4;));1)
Tools->Customize->Fields
1. In Field, click Task
2. In Type, select Number
3. Select a field not used (like Number 1)
4. Click in Rename
5. Type "Time Headlight"
6. Then click OK
7. In Custom attributes, click Formula
8. Type the formula
9. Click OK
10. Click OK in the message "Existing data in the...."
**********
* Set 1 for activities on time
* Set 2 for activities delayed without delaying downstream activities
* Set 3 for activities delayed without impact on downstream activities but no impact on the Project end date
* Set 4 for activities delayed with impact on the Project end date
**********
11. In Calculation for task and group summary rows, click Use formula
12. In Values to display click on Graphical Indicator
13. Click on the first line of Test for 'Time Headlight'and select Equals
14. Click in Value(s) and type 1
15. Click in Image and select the green Headlight
16. On the second line, select equals, type 2 and select blue Headlight
17. On the third line, select equals, type 3 and select yellow Headlight
18. On the fourth line, select equals, type 4 and select red Headlight