Re: Arithmetic sum of subtasks

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you don't have any resources assigned, then in a very real sense you don't have any man-days to summarize anyway. I see a task that is 3 days duration. That could be 3 man-days if one person is assigned, 6 man-days if two are assigned. 9 man-days if three, 1.5 man-days if one resource is on it 50%, and so forth. Summing duration days and arbitrarily calling the sum "total man-days" is mathematically incorrect and functionally completely meaningless until you know how many resources are working on each task and at what level they're working for each duration day.
--
Steve House
MS Project Trainer & Consultant



"Abraham" <Abraham@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2DF80267-732B-47E7-8F6A-6F16ABDB7D68@xxxxxxxxxxxxxxxx
Gerard,

Yes you are right. I forgot to mention that i have not assigned any
resources to the tasks. This will default to then i person full time for each
task as you said.



"Gérard Ducouret" wrote:

Abraham,

This formula doesn't give the total man days required to complete the
summary task, excepted when all the assignments are one person full time
evenly on each task.
Without any formula, you would have a best result by inserting the Work
column: Insert / Column / Work
You can choose between hours and days to display de work values: Tools /
Options / Schedule / Work is entered in: Days

Hope this helps,

Gérard Ducouret


"abraham" <abraham@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news: 026F9CA8-8ABF-46C2-ADA8-18D36B19E7A5@xxxxxxxxxxxxxxxx
> Dale,
>
> Thanks for your reply. It did the work. We want to know the total man > days
> required to complete the summary task.
>
> For example if you have three subtask under a summary task all starting > at
> the same time and having the same duration then the summary tasks in
> project
> will only show the diff b/n the start and finish dates. Say the > duration
> of
> the three subtasks is 10 days each. Then the duration of the summary > task
> will be 10 days and the man days required to complete the summary task
> will
> be 30 days.
>
> Best regards,
> Abraham
> "Gérard Ducouret" wrote:
>
>> Hello,
>>
>> To follow Dale's answer:
>>
>> Right click on the Duration1 (or other custom Duration field) then >> click
>> Customize Fields...
>> Click formula
>> Select the field: [Duration]
>> Calculation for tasks and group summary rows option: Rollup ... Sum
>> That's all.
>> But what is the use of such formula? Please tell us.
>> Thanks
>>
>> Gérard Ducouret
>>
>> "Abraham" <Abraham@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message >> de
>> news: 4D083AD9-9B69-4634-BDAA-3764DEA12B49@xxxxxxxxxxxxxxxx
>> >
>> > Is it possble you can show an example of how to use the custom >> > duration
>> > field to calculate the sum ofsubtask durations ?
>> >
>> >
>> > Thanks.
>> >
>> > "Dale Howard [MVP]" wrote:
>> >
>> >> RakeshK --
>> >>
>> >> What you are seeing in Microsoft Project is correct. The Duration >> >> of
>> >> any
>> >> summary task is NOT the sum of the Durations of the subtasks. The
>> >> Duration
>> >> of a summary task is calculated from the Start date of the earliest
>> >> starting
>> >> task to the Finish date of the latest finishing task. But if you
>> >> absolutely
>> >> need to calculate a custom Duration as the sum of the subtask
>> >> Durations,
>> >> you
>> >> would need to create a custom Duration field for this purpose. >> >> Hope
>> >> this
>> >> helps.
>> >>
>> >> -- >> >> Dale A. Howard [MVP]
>> >> VP of Educational Services
>> >> msProjectExperts
>> >> http://www.msprojectexperts.com
>> >> http://www.projectserverexperts.com
>> >> "We write the books on Project Server"
>> >>
>> >>
>> >> "RakeshK" <RakeshK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:D54BC069-FA12-43A9-B7DF-C4D97C299432@xxxxxxxxxxxxxxxx
>> >> > Hi,
>> >> > Presently the duration of a summary task is NOT the arithmetic >> >> > sum
>> >> > of
>> >> > the
>> >> > durations of its subtasks. It is calculated as the difference
>> >> > between
>> >> > the
>> >> > most end date and the least start date of the subtasks.
>> >> >
>> >> > How can i show the arithmetic sum of duration of subtasks in a
>> >> > summary
>> >> > tasks ?
>> >> >
>> >> > Please help.
>> >>
>> >>
>>
>>
>>




.

Relevant Pages

  • Re: crosstab for durations
    ... I'm not sure how you can do this in a cross tab. ... details section and summarize it in the group footer for the project ... Therefore I would like to produce with crystal reports a crosstab report ... the duration for the period. ...
    (microsoft.public.vb.crystal)
  • Re: Progress?
    ... produce a summary progress line that goes from Start to the Current Date? ... With regard to summary line Actual Duration. ... But do make sure to pick up ALL performance subtasks under the summary ... The intent of a summary line is to, well, summarize the data ...
    (microsoft.public.project)
  • Re: Progress?
    ... if you really want it there and you want it to show progress up to the ... The intent of a summary line is to, well, summarize the data ... contained in the subtasks under it. ... Task Start % Compl Actual Dur Duration Pred ...
    (microsoft.public.project)
  • Re: Isnt there a "Machine" Resource Type???
    ... to resources on a task, I may also have to go back and fix the duration ... assignments" checkbox is turned OFF, ... by leveling when resources are overallocated) and suspensions (the ... Leveling never changes the amount of a resource's work nor the duration ...
    (microsoft.public.project)
  • Re: Proj 2003 Import tool doesnt bring all data-rounds my duratio
    ... 2003 to a program that will then assign resources to my tasks and will not ... assignments either. ... Do I need to export a time function and a date function and import a time ... >> Proj is for some reason ignoring my duration and dates. ...
    (microsoft.public.project)