Graphical Indicators
in [Project]
|
From: eswar on 15 Jul 2005 02:11 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
From: Mike Glen on 15 Jul 2005 04:41 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
From: eswar on 15 Jul 2005 05:05 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" wrote: > > 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 > > > >
From: Mike Glen on 15 Jul 2005 12:55 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 eswar wrote: > 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" wrote: > >> >> 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
From: eswar on 19 Jul 2005 01:54 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 "Mike Glen" wrote: > > 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 > > > > eswar wrote: > > 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" wrote: > > > >> > >> 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 > > > >
|
Next
|
Last
Pages: 1 2 Prev: How to open MSPJ.MTM Next: MS Project gives gbui://blank.htm error. Registry patch not work |