Graphical Indicators

[eswar]

hi,

i am want a graphical indicator to show the project status. if the project
is running in time, then its going to be green, if its beign delayed thn its
red and its blue if its otherwise. please help me out.

regards
eswar

 

[Mike Glen]

Hi eswar ,

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 on Customizing 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 article 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

 

[eswar]

hi mike,

thank you very much for reply. that was an amazing source of information. i
am quite new this. even than i could understand it so well. i rated it 4.

can u pl extend some more help. can u get me out of the situation that i am
struck in. that is: indicators for project status.. i am struck and this is
an urgent requirement.
in one downloaded presentation i could find the following expression

Switch(ProjDateDiff([BaselineFinish ,
[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)

but i don know how to use it.. can u pl help me.

regards
eswar

 

[Mike Glen]

Hi Eswar,

Thanks for you kind coments.

You can't just jump in and insert someone else's formula because it looks
good! You need to evaluate the meaning of the functions (see the Help
pages) until you understand their usage. I'm no expert in these formulae,
but firstly you've got some errors in the syntax. There should be a closing
square bracket ] after the first BaselineFinish, and you need to delete a
space or carriage return between the second Baseline and Finish. Just copy
this:
Switch(ProjDateDiff([Baseline
Finish],[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)



To apply it, insert a Text field and customize it by pasting in the formula.
Then in the Graphical Indicators dialog, enter 3 Tests for equals 0, 1 and
2, with green, yellow and red images. The Switch function looks for the
first expression in a list that is True. In this case it is looking for the
number of days between the Baseline Finish and the scheduled Finish (the 480
converts from minutes to days). Thus, the first expression will prevail if
it is greater than or equal to 2, and the second to 1. If neither case
exisits the value returned is zero. You need like to change the values of 1
or 2 to suit your needs.


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

Mike Glen
MS Project MVP

hi mike,

thank you very much for reply. that was an amazing source of
information. i am quite new this. even than i could understand it so
well. i rated it 4.

can u pl extend some more help. can u get me out of the situation
that i am struck in. that is: indicators for project status.. i am
struck and this is an urgent requirement.
in one downloaded presentation i could find the following expression

Switch(ProjDateDiff([BaselineFinish ,
[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)

but i don know how to use it.. can u pl help me.

regards
eswar

Hi eswar ,

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 on Customizing 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 article 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

 

[eswar]

hi mike,

thnks for that. its working fine for its purpose. i have a small doubt.
which date difference should i calculate if the project tasks are not on
time. "not on time" - a task scheduled for today is not finished 100%. can u
pl guide me through.

thanks and regards
Eswar

Hi Eswar,

Thanks for you kind coments.

You can't just jump in and insert someone else's formula because it looks
good! You need to evaluate the meaning of the functions (see the Help
pages) until you understand their usage. I'm no expert in these formulae,
but firstly you've got some errors in the syntax. There should be a closing
square bracket ] after the first BaselineFinish, and you need to delete a
space or carriage return between the second Baseline and Finish. Just copy
this:
Switch(ProjDateDiff([Baseline
Finish],[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)



To apply it, insert a Text field and customize it by pasting in the formula.
Then in the Graphical Indicators dialog, enter 3 Tests for equals 0, 1 and
2, with green, yellow and red images. The Switch function looks for the
first expression in a list that is True. In this case it is looking for the
number of days between the Baseline Finish and the scheduled Finish (the 480
converts from minutes to days). Thus, the first expression will prevail if
it is greater than or equal to 2, and the second to 1. If neither case
exisits the value returned is zero. You need like to change the values of 1
or 2 to suit your needs.


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

Mike Glen
MS Project MVP

hi mike,

thank you very much for reply. that was an amazing source of
information. i am quite new this. even than i could understand it so
well. i rated it 4.

can u pl extend some more help. can u get me out of the situation
that i am struck in. that is: indicators for project status.. i am
struck and this is an urgent requirement.
in one downloaded presentation i could find the following expression

Switch(ProjDateDiff([BaselineFinish ,
[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)

but i don know how to use it.. can u pl help me.

regards
eswar

Hi eswar ,

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 on Customizing 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 article 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

eswar wrote:
hi,

i am want a graphical indicator to show the project status. if the
project is running in time, then its going to be green, if its beign
delayed thn its red and its blue if its otherwise. please help me
out.

regards
eswar

 

[Mike Glen]

Hi eswar,

I don't quite see your problem. If a task is running late, then presumably
you have entered the %Complete and the Remaining Duration (or the Work
equivalents) and then reschedulled your unfinished work to start after
today's date. This will create a new Finish date which you can still
compare with the Baseline Finish as before.


Mike Glen
Project MVP

hi mike,

thnks for that. its working fine for its purpose. i have a small
doubt. which date difference should i calculate if the project tasks
are not on time. "not on time" - a task scheduled for today is not
finished 100%. can u pl guide me through.

thanks and regards
Eswar

Hi Eswar,

Thanks for you kind coments.

You can't just jump in and insert someone else's formula because it
looks good! You need to evaluate the meaning of the functions (see
the Help pages) until you understand their usage. I'm no expert in
these formulae, but firstly you've got some errors in the syntax.
There should be a closing square bracket ] after the first
BaselineFinish, and you need to delete a space or carriage return
between the second Baseline and Finish. Just copy this:
Switch(ProjDateDiff([Baseline
Finish],[Finish])/480>=2,2,ProjDateDiff([Baseline
Finish],[Finish])/480>=1,1,True,0)