Summarize assigned resources by Task

[Lyndon Loader]

In 2000, in the resource usage view how do I summarise or filter the
resources allocated to a range of subtasks. For example
If the tasks assigned are
1 Task 1 Resource
1.1 Subtask A Fred
1.2 Subtask B Jim
1.3 Subtask C Fred

2 Task 2
2.1 Subtask D Jim Fred
2.2 Subtask E Fred
2.3 Subtask F Jim Fred

How do I get project to summarise resources like this
Week1 Week 2
Task 1
Fred
Subtask A 1d 1d
Subtask C 1d 2d
Jim
Subtask B 0d 3d

Task 2
Fred
Subtask D 1d 0d
Subtask E 0d 3d
Subtask F 1d 1d

Jim
Subtask D 2d 0d
Subtask F 1d 3d

 

[John]

In 2000, in the resource usage view how do I summarise or filter the
resources allocated to a range of subtasks. For example
If the tasks assigned are
1 Task 1 Resource
1.1 Subtask A Fred
1.2 Subtask B Jim
1.3 Subtask C Fred

2 Task 2
2.1 Subtask D Jim Fred
2.2 Subtask E Fred
2.3 Subtask F Jim Fred

How do I get project to summarise resources like this
Week1 Week 2
Task 1
Fred
Subtask A 1d 1d
Subtask C 1d 2d
Jim
Subtask B 0d 3d

Task 2
Fred
Subtask D 1d 0d
Subtask E 0d 3d
Subtask F 1d 1d

Jim
Subtask D 2d 0d
Subtask F 1d 3d

Lyndon,
Well first of all, "Task 1" and "Task 2" are not tasks at all. They are
summary lines and hopefully do not have any resources assigned.
Therefore, they cannot be shown on the Resource Usage view. For
reference you might wan to go to our MVP website at:
http://www.mvps.org/project/faqs.htm
and take a look at FAQ 51 - Data Types: Task, Resource and Assignments.

It may be possible through some combination of filters, sorting and
grouping to get close to the report you want. I tried a few things
unsuccessfully but I didn't spend a lot of time on it. For sure, the
output you want can be achieved with VBA either by using spare flag
fields in combination with sorting or by exporting the data to another
application (e.g. Excel) and formatting the data any way needed.

John
Project MVP

 

[Jan De Messemaeker]

Hi,

I've already had a few customers with this demand and I had to use VBA
programming to solve it.
HTH