John
Wed May 21 21:14:29 CDT 2008
In article <ABF2262A-4EB4-4A90-ACAC-0E78F7619E81@microsoft.com>,
Richard <Richard@discussions.microsoft.com> 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@microsoft.com>,
> > Richard <Richard@discussions.microsoft.com> 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@microsoft.com>,
> > > > Richard <Richard@discussions.microsoft.com> 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
> > > >
> >