Graphical Indicators Indicating Ranges of Value

[Stretch]

I would like to display Purple, Green, Yellow and Red for a range of values.

However, the choices seem to limit me to only 2 values. The ranges I am
trying to reflect with an indicator are:

Purple => Work is not baselined

Green => Work is <= (+/-) 3% of the baseline value

Yellow => Work is within <= (+/-) 5% of the baseline value
(i.e. 3% < Work <= 5% of Baseline

Red => Work is within > (+/-) 5% of the baseline value

TIA

Stretch

 

[Jim Aksel]

Mike Glenn (one of the MVPs) has some tutorials that might help you.
Basically, you need a switch statement and that will determine which color
icon to return to a custom field.

Try Tutorials 14 & 15 located here:
http://project.mvps.org/mike's_tutorials.htm

What you need is something similar to a Stoplight Chart.

If this post is helpful, please consider rating it!

Thanks

Jim

 

[Stretch]

Jim,

Thanks very much.

Stretch

Mike Glenn (one of the MVPs) has some tutorials that might help you.
Basically, you need a switch statement and that will determine which color
icon to return to a custom field.

Try Tutorials 14 & 15 located here:
http://project.mvps.org/mike's_tutorials.htm

What you need is something similar to a Stoplight Chart.

If this post is helpful, please consider rating it!

Thanks

Jim

 

[Stretch]

Jim,

The website that contains the articls timed out 3 times.

Do you have another link?

Thanks,

Stretch

 

[Jim Aksel]

Sorry I don't. It was timing out on me too. Here's Aksel's Intense Reader's
Digest version:

Insert a Text1 field
Customize Text1:
Right click on Text1 Column, select Custom Fields.
Use a Formula to calculate the values you want using a custom formula to
calculate Text1. The formula needs to return the values you want to grade
Change the box to "Graphical Indicators"
Use the next dialog box to capture the icon colors you wish to display based
on the calucations you performed.

You will have a unique challenge because of the +/- issues. It will be a
challenge to cover a range with a start and stop value but it can be done.
Consider using the Absolute Value function ABS(formula) if the windows are
symetric.

The trick is to remember the code is executed from the top down and Project
will display the *last* value meeting the criteria. For example, I have
assign grades to students like this:

If grade < 99 A
If < 90 B
if < 80 C
if <70 D
if <60 F.

So, everyone start with an "A" and then gets overwritten the dumber they
are. The logic can also be reversed to overwrite only in the case of
"smarter"

You will need this logic.

Mike's tutorial is much better than this .... post back if you have trouble.

If this post was helpful, please consider rating it.

Jim

 

[Mike Glen]

Hi Stretch,

Welcome to this Microsoft Project newsgroup

Try this direct link to the TechTrax ezine, look for particularly #14 & 15,
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

 

[Stretch]

Jim Mike:

Thanks, very informative.

I've written a Switch with 3 tests. The first 2 work, the last does not.
I am testing for the ABS(value <= 3),
ABS (3 < value <= 5)
ABS (value > 5)

Would one of you mind taking a look at the function I wrote? I am too close
to it to see the error. Here it is:

Switch
(Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=3,1,
3<Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=5,2,
Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))>5,3)

Thanks,

Stretch

 

[Jim Aksel]

It appears if Baseline Work=0 that you return 1 ... the same as if your
formula had calculated a % difference less than 3%. I suggest you change it
so that if Baseline Work=0 that you return some other value such as 4 ---
indicator would mean "No Baseline" (purple). I think that will give you what
you need. Post back if needed.

Jim

Jim Mike:

Thanks, very informative.

I've written a Switch with 3 tests. The first 2 work, the last does not.
I am testing for the ABS(value <= 3),
ABS (3 < value <= 5)
ABS (value > 5)

Would one of you mind taking a look at the function I wrote? I am too close
to it to see the error. Here it is:

Switch
(Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=3,1,
3<Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=5,2,
Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))>5,3)

Thanks,

Stretch

Hi Stretch,

Welcome to this Microsoft Project newsgroup

Try this direct link to the TechTrax ezine, look for particularly #14 & 15,
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

 

[Mike Glen]

You're welcome, Stretch

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

Jim Mike:

Thanks, very informative.

I've written a Switch with 3 tests. The first 2 work, the last does not.
I am testing for the ABS(value <= 3),
ABS (3 < value <= 5)
ABS (value > 5)

Would one of you mind taking a look at the function I wrote? I am too
close
to it to see the error. Here it is:

Switch
(Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=3,1,
3<Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=5,2,
Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))>5,3)

Thanks,

Stretch

Hi Stretch,

Welcome to this Microsoft Project newsgroup

Try this direct link to the TechTrax ezine, look for particularly #14 &
15,
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

 

[Stretch]

I varied the order of the parts of the switch. Come to find out, only 2 of
the 3 parts are being tested, or there is an error I cannot find.

Any suggestions for troubleshooting this situation?

TIA

Stretch

Jim Mike:

Thanks, very informative.

I've written a Switch with 3 tests. The first 2 work, the last does not.
I am testing for the ABS(value <= 3),
ABS (3 < value <= 5)
ABS (value > 5)

Would one of you mind taking a look at the function I wrote? I am too close
to it to see the error. Here it is:

Switch
(Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=3,1,
3<Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=5,2,
Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))>5,3)

Thanks,

Stretch

Hi Stretch,

Welcome to this Microsoft Project newsgroup

Try this direct link to the TechTrax ezine, look for particularly #14 & 15,
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

 

[Stretch]

Jim,

The reason I return a want to test for the baseine work = 0 which is the
case for a milestone.

I will also test for whether the baseline exists by testing baseline start
and finish.

Hope this clarifies my madness and thanks for your time and help.

Jim

It appears if Baseline Work=0 that you return 1 ... the same as if your
formula had calculated a % difference less than 3%. I suggest you change it
so that if Baseline Work=0 that you return some other value such as 4 ---
indicator would mean "No Baseline" (purple). I think that will give you what
you need. Post back if needed.

Jim

Jim Mike:

Thanks, very informative.

I've written a Switch with 3 tests. The first 2 work, the last does not.
I am testing for the ABS(value <= 3),
ABS (3 < value <= 5)
ABS (value > 5)

Would one of you mind taking a look at the function I wrote? I am too close
to it to see the error. Here it is:

Switch
(Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=3,1,
3<Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))<=5,2,
Abs(IIf([Baseline Work]=0,1,([Baseline Work]-[Work])/[Baseline
Work]*100))>5,3)

Thanks,

Stretch

Hi Stretch,

Welcome to this Microsoft Project newsgroup

Try this direct link to the TechTrax ezine, look for particularly #14 & 15,
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


Jim,

The website that contains the articls timed out 3 times.

Do you have another link?

Thanks,

Stretch

:

Mike Glenn (one of the MVPs) has some tutorials that might help you.
Basically, you need a switch statement and that will determine which
color
icon to return to a custom field.

Try Tutorials 14 & 15 located here:
http://project.mvps.org/mike's_tutorials.htm

What you need is something similar to a Stoplight Chart.

If this post is helpful, please consider rating it!

Thanks

Jim



:

I would like to display Purple, Green, Yellow and Red for a range of
values.

However, the choices seem to limit me to only 2 values. The ranges I
am
trying to reflect with an indicator are:

Purple => Work is not baselined

Green => Work is <= (+/-) 3% of the baseline value

Yellow => Work is within <= (+/-) 5% of the baseline value
(i.e. 3% < Work <= 5% of Baseline

Red => Work is within > (+/-) 5% of the baseline value

TIA

Stretch