Re: Ho Do You Flag Tasks That Are Due To Start

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Quirky,

You're welcome Quirky and again, never apologize for asking questions --
that's how we all learn.

Why don't you post the formula you have tried and then we can narrow
down why you are seeing the error. That may help more than me just
posting another formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project


"Quirky" <Quirky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF2924E6-5377-478B-845D-9605520AF8B1@xxxxxxxxxxxxxxxx
Thanks Julie,

I think your right with the logic I will break this one down into two
fields
with seperate indicators for each. I think it might be possible to do
this
off the CPI and SPI I have tried using your previous entry to think up
my own
crtieria but getting syntex errors! I did try :(

I am now trying to say if CPI is less than 95% mark red, if more than
105%
mark amber and if CPI is between these mark green.

I also want the exact same again for SPI put I am presuming I swap the
CPI
feild with SPI.

Last Question I promise and thank you Julie you have been a terrific
help.

Quirky

"JulieS" wrote:

Hi Quirky,

Don't apologize for asking questions my friend, that is what we are
here
for! And you are definitely *not* computer illiterate -- don't judge
your knowledge of computers by your knowledge level of Project --
it's a
tough one sometimes :-)

To your question:

I often find it easier to break these kind of issues into smaller
pieces. So, if one criteria you need to watch for is cost overruns,
we
can calculate the percentage of cost overrun to budget by the
following
formula:

[Cost Variance]/[Cost]

Expanding that formula a bit further, you want to see if tasks are 5%
over budget. If the tasks are 5% overbudget, display the word "red",
if
less that 5% overbudget, display the word "ok".That formula would
read:

IIf([Cost Variance]/[Cost]>0.05, "red", "ok")

You also want to see if the task has a "schedule overrun". You don't
define exactly what criteria you are looking for but Finish Variance
shows any difference (positive or negative) of the task Finish as
compared to the Baseline Finish. So the following snippet of formula
may work

[Finish Variance]>0

Combining the two:

IIf([Cost Variance]/[Cost]>0.05 and [Finish Variance]>0, "red", rest
of
formula.....)

Going further:

If the task is 10% under budget and ahead of schedule:
IIf([Cost Variance]/[Cost]<=-0.1 and [Finish Variance]<=0, "green",
"no"

Putting the two together:

IIf[Cost Variance]/[Cost]>0.05 and [Finish Variance]>0, "red",
IIf([Cost
Variance]/[Cost]<=-0.1 and [Finish Variance]<=0, "green", "amber"))

The problem that I see with your scenario is one of logic. If a task
is
wildly overbudget but on schedule (no finish variance) wouldn't that
be
a concern? On the other hand, if the costs were okay but the task
was
scheduled to be 1 month late, wouldn't that be a concern?

I might suggest actually looking at the two variables separately.
Perhaps one field that tests for cost overruns and displays the
desired
flags and another that looks at finish variance and displays the
flags.
You could always create yet a third column that would combine the two
as
needed as well.

So, a bit long winded but I hope this helps. Let us know how you get
along.


Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project


"Quirky" <Quirky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DA8622F-3432-4A44-B6F6-94096768E83E@xxxxxxxxxxxxxxxx
Hi Julie,

Thanks for your help I have read the other comment and I have
looked
on the
website. I understand the basic aim but having real trouble
figuring
out the
formula which will indicate the differing tolerance levels.

Sorry but I am really computer illiterate please help!

Quirky

"JulieS" wrote:

Hi Quirky,

You're welcome and thanks for the feedback.

I see you have posted your new question as a new thread and it
looks
as
though Mike has given you some guidance.

If you have any follow up questions, go ahead and reply to your
latest
post and we'll pitch in again :-)

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project


"Quirky" <Quirky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D91A7282-B661-4AF3-A142-4787485AFB17@xxxxxxxxxxxxxxxx
Thanks Julie,

Sorry for the delay in replying but I have only just found the
time
to
implement this change! It worked perfectly thank you...

I am happy with this column but would like to add to it. I was
wondering if
you knew how I could build in my defined quality and reporting
tolerance
levels.

For example, I have tolerance levels of 5% over budget and
schedule
overrun
and would like these indicated red. Similarly I also have a 10%
under
budget
and ahead of schedule reporting criteria. I would like these to
be
marked
green. For the remaining tasks I would like these to appear
amber
to
signify
that they are same as baseline or within tolerance levels.

Do you or anyone else have any ideas to my problem?

Quirky


"JulieS" wrote:

Hi Quirky,

Insert a Text field (Text1 for example) and customize the field
with
the
following formula:

Switch([Start]<=ProjDateAdd([Current
Date],9600),"Soon",[Start]>ProjDateAdd([Current Date],9600) And
[Start]<=ProjDateAdd([Current Date],19200),"Next
Month",[Start]>ProjDateAdd([Current Date],19200),"Future")

The formula should show "Soon" for any task that starts within
the
next
20 working days. The formula should show "Next Month" for
tasks
that
start between 21 days and 40 working days from today's date.
The
formula should show "Future" for any tasks that starts more
than
40
days
from today's date.

You can modify the measurements used (20 days, 40 days) as
needed --
just remember that the formula adds minutes -- hence the need
to
multiply all values by 480 (8 hours * 60 minutes)

Then select the Graphical Indicators button in the Customize
fields
dialog box. Use the following tests:
Row 1
Text1 equals Soon - green indicator
Text1 equals Next month - yellow indicator
Text1 equals Future - red indicator


I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project


"Quirky" <Quirky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02A9D375-B806-474C-BA11-4A52AE83D645@xxxxxxxxxxxxxxxx
I am trying to Flag tasks using Traffic light system to
highlight
what
Tasks
are about to start (ie Green) what tasks are due to start in
1
Month
(amber)
and What Tasks are due to start in 3 Months (Red).

However finding it hard to understand what formula is needed
to
make
this
happen?

Any suggestions????











.

Quantcast