Re: Roll-up tasks by person?
- From: John <mjensen@xxxxxxxxxxxx>
- Date: Mon, 13 Mar 2006 10:01:30 -0700
In article <448B4892-2B05-45C7-96CC-F7C3682FF490@xxxxxxxxxxxxx>,
Ali <Ali@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,
I was wondering if anyone knew how to create the following view (using out
of the box functionality, or macros, or even with plugins):
March 1 2 3 4 5 6 7 8 9 10 11
Person1 [--task1--][task2][----task3----]
Person2 [task4][-----------task5----------]
...
Basically, i want to be able to see what each person is going to be working
on for a period of time, with all of their tasks on the same line. there are
two views that are somewhat close:
a) the task rollup view gantt chart which rolls up subtasks by higher level
task.
b) the resource usage view that shows the number of hours worked by each
resource, but doesn't put the task names on one line.
I would think this would be very useful to everyone using Project, but i
can't seem to find a way to do it.
Please HELP!
thanks,
-=> Ali
Ali,
The only way to get the report you want with out-of-the-box
functionality is to use one of Project's advanced features, namely VBA.
Project does not provide for multiple tasks to show on the same row,
except in the case of Summary lines under certain circumstances. You
will need to export Project's data to another application and create the
report there. Excel would be a good candidate.
It might be possible to do the above export using a combination of
export maps and the built-in utility, "Analyze timescaled data in Excel"
in lieu of a custom VBA macro, but it all depends on how much work you
want to do (i.e. multiple exports and manipulation of the data, or write
VBA code).
There are some Project add-ons that might help get what you want. One
that comes to mind is "Milestones" by Kidasa. There may be others. You
can get more information about Milestones on Kidasa website at:
www.kisada.com
Hope this helps.
John
Project MVP
.
- Prev by Date: Re: Critical tasks
- Next by Date: Re: Inserting a Time Scale
- Previous by thread: Re: Critical tasks
- Next by thread: Re: Roll-up tasks by person?
- Index(es):
Relevant Pages
|
