Reporting Project Schedule Variance with a Stoplight View

[dunatl]

I'm trying to create a Stoplight view of deliverables based on a schedule
variance? Can anyone give me some step by step directions or point me to a
location or reference material.

 

[Mike Glen]

Hi dunatl ,

Welcome to this Microsoft Project newsgroup

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 & 15 - Customising Fields, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

 

[JulieD]

Hi

Mike Glen in his tutorial on Project uses the stoplight concept in relation
to costs...
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=403

and here's a formula i developed in response to another post on a similar
question
IIf([% Complete]<>"100",IIf([Finish]-[Baseline Finish]>7,"over
week",IIf([Finish]-[Baseline Finish]<=0,"on target","week")),"NA")

which compares (and returns text) based on the difference between finish &
baseline finish. You can use the text outputted by this formula (modified
to what you want) to link to the graphical indicators.

see how you go with this and if you require further assistance, please feel
free to post back.

Cheers
JulieD