Formaula Validation on COst /Schedule requested

[mike]

Hello, I was hoping to get some validation on this formula.

Customer wants to "warn" the PM when baseline costs and scheculre are
between 80 and 100 percent complted.

So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%

Details:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]

Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red


IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish

Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red

 

[Dale Howard [MVP]]

Mike --

I don't understand what your customer is trying to "warn" the PM about.
Your formulas are inconsistent with this requirement, or else you didn't
quote the complete formula. And based on your formulas, your Graphical
Indicators make no sense either. Please tell us more about this need and we
will try to help.

 

[mike]

Mike --

I don't understand what your customer is trying to "warn" the PM about.
Your formulas are inconsistent with this requirement, or else you didn't
quote the complete formula.  And based on your formulas, your Graphical
Indicators make no sense either.  Please tell us more about this need and we
will try to help.

Hello, I was hoping to get some validation on this formula.

Customer wants to "warn" the PM when baseline costs and scheculre are
between 80 and 100 percent complted.

So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%

Details:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]

Values
=                           999999                         Clock Face
less than or = to            .79                        Green
greater than or = to        .80                        Yellow
=                                1                             Green
greater than or = to      1.01                        Red

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish

Values
=                           999999                         Clock Face
less than or = to            .79                        Green
greater than or = to        .80                        Yellow
=                                1                             Green
greater than or = to      1.01                        Red- Hide quoted text -

- Show quoted text -

Dale:

the customer wants to show how much of a basline cost has been
consumed.

if 0-to 79% is consumed show green
wen 80 to 99% is consumed turn yellow.
When 100% show green
over 100% show red.

Mike

 

[mike]

Mike --

I don't understand what your customer is trying to "warn" the PM about.
Your formulas are inconsistent with this requirement, or else you didn't
quote the complete formula.  And based on your formulas, your Graphical
Indicators make no sense either.  Please tell us more about this needand we
will try to help.

news:96dfdb81-fd7e-4d76-aee0-6c36f8e6c362@w34g2000yqm.googlegroups.com....

Hello, I was hoping to get some validation on this formula.
Customer wants to "warn" the PM when baseline costs and scheculre are
between 80 and 100 percent complted.
So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%
Details:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]
Values
=                           999999                         Clock Face
less than or = to            .79                        Green
greater than or = to        .80                       Yellow
=                                1                             Green
greater than or = to      1.01                        Red
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish
Values
=                           999999                         Clock Face
less than or = to            .79                        Green
greater than or = to        .80                       Yellow
=                                1                             Green
greater than or = to      1.01                        Red- Hide quoted text -

- Show quoted text -

Dale:

the customer wants to show how much of a basline cost has been
consumed.

if 0-to 79% is consumed show green
wen 80 to 99% is consumed turn yellow.
When 100% show green
over 100% show red.

Mike- Hide quoted text -

- Show quoted text -

I changed the formulat to the following:

Task
Number

Formula:
[Actual Cost]/[Baseline Cost]

and dropped the clock everthing else on the .79 belwo green
..8to .99 yellow
100 green
100.01 red

 

[Dale Howard [MVP]]

Mike --

You still need to trip for the absence of a Baseline, so the correct cost
formula in a task Number field would be:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Actual Cost]/[Baseline
Cost])

I think your original set of Indicator Criteria should work, so revert back
to them including the clock face for the absense of a Baseline. I hope I
wasn't too hard on you in my original response. It's just that your
formulas made no sense given your reporting requirements. Hope this helps.

Mike --

I don't understand what your customer is trying to "warn" the PM about.
Your formulas are inconsistent with this requirement, or else you didn't
quote the complete formula. And based on your formulas, your Graphical
Indicators make no sense either. Please tell us more about this need and
we
will try to help.

news:96dfdb81-fd7e-4d76-aee0-6c36f8e6c362@w34g2000yqm.googlegroups.com...

Hello, I was hoping to get some validation on this formula.
Customer wants to "warn" the PM when baseline costs and scheculre are
between 80 and 100 percent complted.
So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%
Details:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red- Hide quoted text -

- Show quoted text -

Dale:

the customer wants to show how much of a basline cost has been
consumed.

if 0-to 79% is consumed show green
wen 80 to 99% is consumed turn yellow.
When 100% show green
over 100% show red.

Mike- Hide quoted text -

- Show quoted text -

I changed the formulat to the following:

Task
Number

Formula:
[Actual Cost]/[Baseline Cost]

and dropped the clock everthing else on the .79 belwo green
..8to .99 yellow
100 green
100.01 red

 

[mike]

Mike --

You still need to trip for the absence of a Baseline, so the correct cost
formula in a task Number field would be:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Actual Cost]/[Baseline
Cost])

I think your original set of Indicator Criteria should work, so revert back
to them including the clock face for the absense of a Baseline.  I hopeI
wasn't too hard on you in my original response.  It's just that your
formulas made no sense given your reporting requirements.  Hope this helps.

Mike --
I don't understand what your customer is trying to "warn" the PM about.
Your formulas are inconsistent with this requirement, or else you didn't
quote the complete formula. And based on your formulas, your Graphical
Indicators make no sense either. Please tell us more about this need and
we
will try to help.


Hello, I was hoping to get some validation on this formula.
Customer wants to "warn" the PM when baseline costs and scheculre are
between 80 and 100 percent complted.
So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%
Details:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red- Hide quoted text -
- Show quoted text -

Dale:

the customer wants to show how much of a basline cost has been
consumed.

if 0-to 79% is consumed show green
wen 80 to 99% is consumed turn yellow.
When 100% show green
over 100% show red.

Mike- Hide quoted text -

- Show quoted text -

I changed the formulat to the following:

Task
Number

Formula:
[Actual Cost]/[Baseline Cost]

and dropped the clock everthing else on the .79 belwo green
.8to .99 yellow
100 green
100.01 red- Hide quoted text -

- Show quoted text -

Dale,

You were not too hard on me at all. I'm not the biggest fan of this
specific formula, but it is for a very controlling stakeholder. I
knew the values could be done, its just folrmulas are not my stong
suit.

As always, thank you for your help !

I can use the same for Work, I assume.

Mike

 

[Dale Howard [MVP]]

Mike --

Yup, you surely can use the same type of formula for Work.

Mike --

You still need to trip for the absence of a Baseline, so the correct cost
formula in a task Number field would be:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Actual Cost]/[Baseline
Cost])

I think your original set of Indicator Criteria should work, so revert
back
to them including the clock face for the absense of a Baseline. I hope I
wasn't too hard on you in my original response. It's just that your
formulas made no sense given your reporting requirements. Hope this helps.

Mike --
I don't understand what your customer is trying to "warn" the PM
about.
Your formulas are inconsistent with this requirement, or else you
didn't
quote the complete formula. And based on your formulas, your Graphical
Indicators make no sense either. Please tell us more about this need
and
we
will try to help.


Hello, I was hoping to get some validation on this formula.
Customer wants to "warn" the PM when baseline costs and scheculre
are
between 80 and 100 percent complted.
So Gregg from 0 to 79%, yellow from 80 to 99%, Green on 100%, Red on
101%
Details:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Cost]
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Baseline Finish
Values
= 999999 Clock Face
less than or = to .79 Green
greater than or = to .80 Yellow
= 1 Green
greater than or = to 1.01 Red- Hide quoted text -
- Show quoted text -

Dale:

the customer wants to show how much of a basline cost has been
consumed.

if 0-to 79% is consumed show green
wen 80 to 99% is consumed turn yellow.
When 100% show green
over 100% show red.

Mike- Hide quoted text -

- Show quoted text -

I changed the formulat to the following:

Task
Number

Formula:
[Actual Cost]/[Baseline Cost]

and dropped the clock everthing else on the .79 belwo green
.8to .99 yellow
100 green
100.01 red- Hide quoted text -

- Show quoted text -

Dale,

You were not too hard on me at all. I'm not the biggest fan of this
specific formula, but it is for a very controlling stakeholder. I
knew the values could be done, its just folrmulas are not my stong
suit.

As always, thank you for your help !

I can use the same for Work, I assume.

Mike