Resource Usage view: how display assigned rescources?

[Ralf]

Dear MS Project Experts,

The "Resource Usage" view displays a list of resources and the tasks
assigned to them. But for every task I'd also like to see the other
resources assigned to the same task. The "insert column" dialog doesn't
have a "Resources" option. So how can I add a resources column to the view?

Like this:

Resource Name Resources
- Harry
task 1 Harry
task 2 Harry; Fred
- Fred
task 2 Harry; Fred


I'd appreciate any comment.
Thank you!

Ralf.

(MS Project Prof. 2002)

 

[Rod Gill]

Hi,

The resource Usage view can't show this, that's what the Task Usage view's
for, but it doesn't group by resource.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

 

[Ralf]

Hi,

The resource Usage view can't show this, that's what the Task Usage
view's for, but it doesn't group by resource.

Thanks for the response, Rod. I can't believe there's no solution to such
a simple problem. Not even a macro that can create such a report?

Am I the first person who cares about who does what in his project?
(sorry, slight exaggeration, but that's how I feel ...)


Thanks again!

Ralf.

 

[Jan De Messemaeker]

Hi,

This macro lists all resources of the parent tak in the assignment's text1
field.
If you display this field in any Usage view you will see what you need.

HTH


Sub ListOthers()
Dim Mustbedone As Task
Dim Whodunit As Assignment
For Each Mustbedone In ActiveProject.Tasks
If Not Mustbedone Is Nothing Then
For Each Whodunit In Mustbedone.Assignments
Mustbedone.Text1 = Mustbedone.Text1 & " - " & ActiveProject.Resources
_(Whodunit.ResourceID).Name
Next Whodunit
For Each Whodunit In Mustbedone.Assignments
Whodunit.Text1 = Mustbedone.Text1
Next Whodunit
End If
Next Mustbedone
End Sub

 

[Steve House]

Task usage shows all the resources assigned to each task. Resource usage
shows all the tasks a given resource is assigned to. If you use both views,
switching back and forth when appropriate, what additional information would
you gain combining them as you suggest? I look at Jim in Resource Usage and
see he's working on fidgeting the widgets next week. If I want to see who
else is working with him, I'd just switch over to Task Usage and look at the
resources assigned under fidgeting widgets.

If you do want to see them together for some reason, split the screen, open
the Resource Usage view in the top window and the Task usage view in the
bottom. When you click on a task indented under a resource in the top
window, the bottom pane will automatically show the task with the list of
all resources assigned to it detailed under the task name. About four mouse
clicks to set up the combined view, what's the big deal? I have complete
and accurate information on who's doing what with whom when using only the
standard views.

 

[Ralf]

Dear Jan,

Thanks for your response. It looks like this could work, but when running
it I get this error:

Run time error '438':
Object doesn't support this property or method

in line 7.

Do you have an idea what could be the problem?

Thank you!

Cheers,
Ralf.



1> Sub ListOthers()
2> Dim Mustbedone As Task
3> Dim Whodunit As Assignment
4> For Each Mustbedone In ActiveProject.Tasks
5> If Not Mustbedone Is Nothing Then
6> For Each Whodunit In Mustbedone.Assignments

7> Mustbedone.Text1 = Mustbedone.Text1 & " - " &
ActiveProject.Resources_(Whodunit.ResourceID).Name

8> Next Whodunit
9> For Each Whodunit In Mustbedone.Assignments
10> Whodunit.Text1 = Mustbedone.Text1
11> Next Whodunit
12> End If
13> Next Mustbedone
14> End Sub

 

[Ralf]

Steve,

Thanks for the response and the offered solution. In the way you describe,
I can certainly find out who's doing what for myself. What I want though,
is to give a list of who does what to my colleagues on paper. If I print
the two lists you mention, everyone can figure it out, of course. But with
a complete single list there'd be no more need to figure anything out
anymore, but it'd be right there ...
Like you said, I wouldn't gain information. I could only present it more
clearly, without switching and clicking ...

Cheers,
Ralf.

 

[Steve House]

For hard copy, have you looks at the standard set of provided reports?
There's a "who does what when" report that gives you what I think you need.

 

[Ralf]

Yes! Got it. So it was only a "_" in line 7 that I had to delete.
Also I added the line
Mustbedone.Text1 = ""
after line 4 to clear Text1 if it's not empty.

This is exactly what I needed, thanks a lot Jan!

There is still a minor bug: The macro doesn't work correctly for linked
subprojects. But running it in a subproject itself works fine.

Cheers,
Ralf.