show all the resources (or initials) at summary-task level

H

Henk

Hi all,

Is it possible to show all the resources (or initials) at summary-task
level that are working on the underlying tasks?

Best Regards, Henk
 
J

Jan De Messemaeker

Hi Henk,

First, not directly, you will need VBA to do that.
Even then, it is wise to put all units to 0% or you may double-count work.
Groeten,
 
H

Henk

Hi Henk,

First, not directly, you will need VBA to do that.
Even then, it is wise to put all units to 0% or you may double-count work.
Groeten,

--
Jan De Messemaeker







- Tekst uit oorspronkelijk bericht weergeven -


Hi,

Jan and Mike (via mail) thanks for the replys. I will write them down
manualy in a separately text field. I was aware of the double count
work.

Best regards, Henk
 
N

Nick Haws

Where can I find VBA tips on this issue? Is there ANY way to have summary
tasks SUM the hours of the resources below in the sub-tasks...isn't that what
"summary" means? We shouldn't be forced to enter 0% for the master summary
task, the program should be able to look below to the sub-tasks for each week
and add the resources, no? Also, is there a way for the Gantt bars to
display gaps when there are no sub-tasks occuring underneath? I am new to MS
Project, and these two issues are the most frustrating I have with summary
tasks...am I asking/expecting too much here? Our company may look for new
software that can meet our needs if we cannot find a way to achieve this in
MS Project.

Anyone...please HELP! Thanks.

 
M

Mike Glen

OK, Nick, back to basics. In Project, the summary by definition, shows the
Duration in working time between the earliest task start and the finish of
the latest task that it summarizes. Nothing more and nothing less. It will
only equal the sum of the Durations of its tasks when each task is scheduled
Finish-to-Start in a chain. The summary's Duration is thus calculated by
Project and cannot be entered.

Whilst Project allows you to assign resources to summaries, you should not
do so if the same resources are assigned to its tasks, as it will be adding
itself to the summarized data giving an erroneous double count.

As for the Gantt splits, Project won't show splits from the Gantt bars it
summarizes. After all, this would be pretty useless if you had lots of
split which overlapped. However, if you have only a few tasks or
non-overlapping tasks, you can select to roll up the Gantt bars to summary
via the Task Information dialogs, which will show the splits.

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top