Re: Status of summary tasks incorrect

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In article <ABF2262A-4EB4-4A90-ACAC-0E78F7619E81@xxxxxxxxxxxxx>,
Richard <Richard@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi John, orginal post said tasks that are complete, on shedule or future
task. I am not quite following how the timephased calculation works for
summary tasks. By my way of thinking a summary task should not show a late
status unless at least one of the subtasks is showing a late status? What is
that I am missing?

RIchard,
I played around with the Status field for summary lines and came up with
something that I think will shed some light on how Project determines if
the summary is late or not.

Add Actual Duration field and a spare text field as columns in a task
view (e.g. Gantt Chart or Task Usage). Customize the spare text field
with the following formula.
Text1= projdatediff([Start],[Status Date])/480-1
In the Customize fields window, select the option to use the formula for
calculating task summary rows.

Compare the value in the customized text1 field with the value displayed
in the Actual Duration field. If the custom field value is equal to or
greater than the Actual Duration, the summary line will show "On
schedule". If the calculated field is less, the summary line will show
"Late".

How does it work? Well, the formula calculates the expected progress the
day before the status date (i.e. cumulative percent complete by the end
of the day before the status date). It should be easier to understand
than deciphering the timescaled data.

Hope this helps.
John
Project MVP

"John" wrote:

In article <7A58B459-770C-4A63-B2B1-8204BC575D4B@xxxxxxxxxxxxx>,
Richard <Richard@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks for the reply John. The status date is set to today and the
cumulative
percent complete looks right , but the status still says late. I can
force it
to say complete by marking all subtasks as 100% complete anything less
than
100% complete for all the subtasks then the summary task will show late,
many
of the sub tasks are months out in the future. Let me know if you have
any
other ideas.

Thanks for your help
Richard

Richard,
Wait a minute, your original post said all subtasks are showing complete
but the summary is showing "late". Now your saying you can make the
summary show "complete" by making all subtasks complete. Did I miss
something?

You say the cumulative percent complete "looks right", but does it meet
the requirements spelled out by the help file? Use the Task Usage view
and set the timescale to show hours. You might want to use a three tier
timescale with week and day on the upper two tiers so it's easier to see
what day your looking at.

John
Project MVP

"John" wrote:

In article <2EB8F733-40B1-43CD-837A-1B931390FD21@xxxxxxxxxxxxx>,
Richard <Richard@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi, I am using the standard status field in MS project, the summary
task
shows the status as late when all of the sub tasks are showing
Complete ,
on
shedule or future task, none are showing late.

Can anyone tell me what I need to do to get the status of the sumary
task
to
show the corect status.

Richard

Richard,
Without seeing your actual file, I don't have a ready answer for what
you are seeing. Try the following. Hover your mouse over the column
heading for the Status field. In a moment the help file for the Status
field will appear. Take a look at the definitions Project uses for
assigning the various status designations. My guess is, you will see a
problem with the cumulative percent complete for the summary line
versus
the status date.

Hope this helps.
John
Project MVP


.

Relevant Pages

  • Project summary task show incorrect late status
    ... shedule or future task, none are showing late. ... Project MVP ... 100% complete for all the subtasks then the summary task will show late, ... I am not quite following how the timephased calculation works for ...
    (microsoft.public.project)
  • MS Project summary tasks show incorrect late status
    ... shedule or future task, none are showing late. ... Project MVP ... 100% complete for all the subtasks then the summary task will show late, ... Customize the spare text field ...
    (microsoft.public.project)
  • Re: Status of summary tasks incorrect
    ... Richard wrote: ... 100% complete for all the subtasks then the summary task will show late, ... your original post said all subtasks are showing complete ... Project MVP ...
    (microsoft.public.project)
  • Re: Re: Status of summary tasks incorrect
    ... shedule or future task, none are showing late. ... Project MVP ... 100% complete for all the subtasks then the summary task will show late, ... I am not quite following how the timephased calculation works for ...
    (microsoft.public.project)
  • Re: Status of summary tasks incorrect
    ... Richard wrote: ... I am not quite following how the timephased calculation works for ... calculated status of the subtasks. ... your original post said all subtasks are showing complete ...
    (microsoft.public.project)