% Complete and % Work Complete

[Ehsan Khan]

Dear All,

I have created a graphical indicator for Task Progress which is as follows.

IIf([%Complete]=100,IIf([Finish Variance]>0,â€Late
Completionâ€,â€Completedâ€),IIf(ProjDateDiff([Current Date],[Baseline
Start])/480>0 AND [%Complete]=0,â€Not Startedâ€,IIf(ProjDateDiff([Baseline
Finish],[Current Date])/480>0,â€Lateâ€,â€On Timeâ€)))

Equals ‘Late : “Red Ballâ€
Equals ‘On Time’ : “Yellow Ballâ€
Equals ‘Completed’: “Green Ballâ€
Equals ‘Not Started’: “White Ballâ€
Equals ‘Late Completion’: “Black Ballâ€

Now the problem is that the team members report the progress on % Work
Complete and these indicators are based on % Complete. I know that % Complete
= % Duration Complete but I want to know whether there is some link between %
COmplete and % work complete because sometimes if the resources send their
progress on % Work COmplete it updates % complete as well (which is wht I
want) thus reflecting the progress in the indicator and gantt chart however
in some cases % complete does not get updated.... How can this be handled ...
I donot want the project manager to update the % complete by hand......

Also I would like to know the details related to triggers in Risks.......
wht do they
explain.. how can you created ur own value.... ?? wht is meant by date?? wht
is meant by task?? etc .. please give me some details realted to that.....

Thanks for any help........
Regards
Ehsan
EPM Consulant

 

[Dale Howard [MVP]]

Ehsan --

If you open a project and click Tools - Options, and then select the
Calculation tab, you will see an option called "Updating Task Status Updates
Resource Status." This option synchronizes the calculation of the %
Complete and % Work Complete values in the project. Here's how it works
when this option is selected:

1. If you manually enter a % Complete value for a task, Microsoft Project
automatically enters the same value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project automatically enters the same value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan, then
the software calculates the % Work Complete value for the task and
recalculates the % Complete value accordingly

Here's how it works when the option is NOT selected:

1. If you manually enter a % Complete value for a task, Microsoft Project
DOES NOT change the value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project DOES NOT change the value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan, then
the software calculates the % Work Complete value for the task and DOES NOT
recalculate the % Complete value

If your PM's are updating progress into the project plan by receiving task
updates through PWA, and the % Complete value is not recalculated
automatically, I would suspect the above option is deselected in their
projects. If this is the case, they need to select this option before
proceeding any further.

Regarding the Triggers section of a Risk, the information you enter here is
entirely related to your organization's methodologies for tracking and
managing risks. A trigger is the warning sign that a risk is about to
occur, is occuring, or has already occured in the project. If you want to
formally track triggers, your organization needs to define what behavior
constitutes a trigger, whether the behavior is related to dates or other
warning signs. Project Server does not use this information in any manner
other than simply listing it for the risk. The monitoring of risk triggers
belongs entirely to the project manager, project team members, and other
parties who have an interest in the project.

Ehsan, now a word of unsolicited advice: If you are really an EPM
consultant, then you need to learn a lot more about Microsoft Project and
Project Server, and about project management. From the questions you
asked, it sounds like your client is paying you to learn how to use the
software, rather than vice versa. Hope this helps.

Dear All,

I have created a graphical indicator for Task Progress which is as
follows.

IIf([%Complete]=100,IIf([Finish Variance]>0,"Late
Completion","Completed"),IIf(ProjDateDiff([Current Date],[Baseline
Start])/480>0 AND [%Complete]=0,"Not Started",IIf(ProjDateDiff([Baseline
Finish],[Current Date])/480>0,"Late","On Time")))

Equals 'Late : "Red Ball"
Equals 'On Time' : "Yellow Ball"
Equals 'Completed': "Green Ball"
Equals 'Not Started': "White Ball"
Equals 'Late Completion': "Black Ball"

Now the problem is that the team members report the progress on % Work
Complete and these indicators are based on % Complete. I know that %
Complete
= % Duration Complete but I want to know whether there is some link
between %
COmplete and % work complete because sometimes if the resources send their
progress on % Work COmplete it updates % complete as well (which is wht I
want) thus reflecting the progress in the indicator and gantt chart
however
in some cases % complete does not get updated.... How can this be handled
...
I donot want the project manager to update the % complete by hand......

Also I would like to know the details related to triggers in Risks.......
wht do they
explain.. how can you created ur own value.... ?? wht is meant by date??
wht
is meant by task?? etc .. please give me some details realted to that.....

Thanks for any help........
Regards
Ehsan
EPM Consulant

 

[Ehsan Khan]

Thanks Dale for your answers..... and for the advice ... I guess I made
mysylf misunderstood .... my question was how the calculation is being
done..... I already know wht u told.. and I know wht triggers are .... all I
wanted to know was

1) How is the calculation being done i.e. the logic it uses to do the
calculation ..... in calculating % Complete when % work complete is provided
as it is evident that % complete and % work complete are not always the same
because they refer to different values....... you gave the answer to my
question in the other post.... refer to Relation between % Complete and %
Work Complete.. I have a question coming for you again on that...

2) As I said.. I know wht triggers are .. all I wanted to know how are they
used in Project Server ... as it seemed to be (when I was testing it) the
case that they have no effect at all other then the listing purpose which u
already told.......

Just for to let you ... I have a pretty good experience of PM and have been
workin in this field for a while...

Sorry for the confusion......

Thanks Man!!!

Ehsan --

If you open a project and click Tools - Options, and then select the
Calculation tab, you will see an option called "Updating Task Status Updates
Resource Status." This option synchronizes the calculation of the %
Complete and % Work Complete values in the project. Here's how it works
when this option is selected:

1. If you manually enter a % Complete value for a task, Microsoft Project
automatically enters the same value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project automatically enters the same value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan, then
the software calculates the % Work Complete value for the task and
recalculates the % Complete value accordingly

Here's how it works when the option is NOT selected:

1. If you manually enter a % Complete value for a task, Microsoft Project
DOES NOT change the value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project DOES NOT change the value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan, then
the software calculates the % Work Complete value for the task and DOES NOT
recalculate the % Complete value

If your PM's are updating progress into the project plan by receiving task
updates through PWA, and the % Complete value is not recalculated
automatically, I would suspect the above option is deselected in their
projects. If this is the case, they need to select this option before
proceeding any further.

Regarding the Triggers section of a Risk, the information you enter here is
entirely related to your organization's methodologies for tracking and
managing risks. A trigger is the warning sign that a risk is about to
occur, is occuring, or has already occured in the project. If you want to
formally track triggers, your organization needs to define what behavior
constitutes a trigger, whether the behavior is related to dates or other
warning signs. Project Server does not use this information in any manner
other than simply listing it for the risk. The monitoring of risk triggers
belongs entirely to the project manager, project team members, and other
parties who have an interest in the project.

Ehsan, now a word of unsolicited advice: If you are really an EPM
consultant, then you need to learn a lot more about Microsoft Project and
Project Server, and about project management. From the questions you
asked, it sounds like your client is paying you to learn how to use the
software, rather than vice versa. Hope this helps.

Dear All,

I have created a graphical indicator for Task Progress which is as
follows.

IIf([%Complete]=100,IIf([Finish Variance]>0,"Late
Completion","Completed"),IIf(ProjDateDiff([Current Date],[Baseline
Start])/480>0 AND [%Complete]=0,"Not Started",IIf(ProjDateDiff([Baseline
Finish],[Current Date])/480>0,"Late","On Time")))

Equals 'Late : "Red Ball"
Equals 'On Time' : "Yellow Ball"
Equals 'Completed': "Green Ball"
Equals 'Not Started': "White Ball"
Equals 'Late Completion': "Black Ball"

Now the problem is that the team members report the progress on % Work
Complete and these indicators are based on % Complete. I know that %
Complete
= % Duration Complete but I want to know whether there is some link
between %
COmplete and % work complete because sometimes if the resources send their
progress on % Work COmplete it updates % complete as well (which is wht I
want) thus reflecting the progress in the indicator and gantt chart
however
in some cases % complete does not get updated.... How can this be handled
...
I donot want the project manager to update the % complete by hand......

Also I would like to know the details related to triggers in Risks.......
wht do they
explain.. how can you created ur own value.... ?? wht is meant by date??
wht
is meant by task?? etc .. please give me some details realted to that.....

Thanks for any help........
Regards
Ehsan
EPM Consulant

 

[Dale Howard [MVP]]

Ehsan --

You are more than welcome, my friend!

Thanks Dale for your answers..... and for the advice ... I guess I made
mysylf misunderstood .... my question was how the calculation is being
done..... I already know wht u told.. and I know wht triggers are .... all
I
wanted to know was

1) How is the calculation being done i.e. the logic it uses to do the
calculation ..... in calculating % Complete when % work complete is
provided
as it is evident that % complete and % work complete are not always the
same
because they refer to different values....... you gave the answer to my
question in the other post.... refer to Relation between % Complete and %
Work Complete.. I have a question coming for you again on that...

2) As I said.. I know wht triggers are .. all I wanted to know how are
they
used in Project Server ... as it seemed to be (when I was testing it) the
case that they have no effect at all other then the listing purpose which
u
already told.......

Just for to let you ... I have a pretty good experience of PM and have
been
workin in this field for a while...

Sorry for the confusion......

Thanks Man!!!

Ehsan --

If you open a project and click Tools - Options, and then select the
Calculation tab, you will see an option called "Updating Task Status
Updates
Resource Status." This option synchronizes the calculation of the %
Complete and % Work Complete values in the project. Here's how it works
when this option is selected:

1. If you manually enter a % Complete value for a task, Microsoft
Project
automatically enters the same value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project automatically enters the same value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan,
then
the software calculates the % Work Complete value for the task and
recalculates the % Complete value accordingly

Here's how it works when the option is NOT selected:

1. If you manually enter a % Complete value for a task, Microsoft
Project
DOES NOT change the value in the % Work Complete field
2. If you manually enter a % Work Complete value for a task, Microsoft
Project DOES NOT change the value in the % Complete field
3. If a team member submits Actual Work hours or a % Work Complete value
through PWA, and the value is updated into the Microsoft Project plan,
then
the software calculates the % Work Complete value for the task and DOES
NOT
recalculate the % Complete value

If your PM's are updating progress into the project plan by receiving
task
updates through PWA, and the % Complete value is not recalculated
automatically, I would suspect the above option is deselected in their
projects. If this is the case, they need to select this option before
proceeding any further.

Regarding the Triggers section of a Risk, the information you enter here
is
entirely related to your organization's methodologies for tracking and
managing risks. A trigger is the warning sign that a risk is about to
occur, is occuring, or has already occured in the project. If you want
to
formally track triggers, your organization needs to define what behavior
constitutes a trigger, whether the behavior is related to dates or other
warning signs. Project Server does not use this information in any
manner
other than simply listing it for the risk. The monitoring of risk
triggers
belongs entirely to the project manager, project team members, and other
parties who have an interest in the project.

Ehsan, now a word of unsolicited advice: If you are really an EPM
consultant, then you need to learn a lot more about Microsoft Project and
Project Server, and about project management. From the questions you
asked, it sounds like your client is paying you to learn how to use the
software, rather than vice versa. Hope this helps.

Dear All,

I have created a graphical indicator for Task Progress which is as
follows.

IIf([%Complete]=100,IIf([Finish Variance]>0,"Late
Completion","Completed"),IIf(ProjDateDiff([Current Date],[Baseline
Start])/480>0 AND [%Complete]=0,"Not
Started",IIf(ProjDateDiff([Baseline
Finish],[Current Date])/480>0,"Late","On Time")))

Equals 'Late : "Red Ball"
Equals 'On Time' : "Yellow Ball"
Equals 'Completed': "Green Ball"
Equals 'Not Started': "White Ball"
Equals 'Late Completion': "Black Ball"

Now the problem is that the team members report the progress on % Work
Complete and these indicators are based on % Complete. I know that %
Complete
= % Duration Complete but I want to know whether there is some link
between %
COmplete and % work complete because sometimes if the resources send
their
progress on % Work COmplete it updates % complete as well (which is wht
I
want) thus reflecting the progress in the indicator and gantt chart
however
in some cases % complete does not get updated.... How can this be
handled
...
I donot want the project manager to update the % complete by hand......

Also I would like to know the details related to triggers in
Risks.......
wht do they
explain.. how can you created ur own value.... ?? wht is meant by
date??
wht
is meant by task?? etc .. please give me some details realted to
that.....

Thanks for any help........
Regards
Ehsan
EPM Consulant