WBS Codes Not Applied to Resource Pool

[oisinirish]

I have used a resource pool project to assign resources to several projects,
each with their own unique code. Is it possible to look at ther resource
sheet in the "pool Project" and see the WBS code as it relates to each
resource. I have inserted the WBS column into the sheet but no data appears.

 

[Jan De Messemaeker]

Hi,

WBS is a task field, a resource caanot have one.
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[oisinirish]

Say for insatance:
1) all tasks are organized within a WBS that breaks down; Project#, Task#,
Subtask#. While Task#'s and Subtask#'s are the same across projects. ie each
project has a management task, a take out the garbage task etc.

2) resources are assigned to subtasks.

Is it possible to create a view that allows me to see all my resources at
once and where they have been assigned referencing a WBS?

Or do I need to create a code mask?
ps. not really sure how to go about this

 

[Jan De Messemaeker]

Hi,

We must nbe talking Resource Usage View now, not Resource Sheet.
Resource Sheet doesn't even show assignments and because a resource can be
assigned to more than one task, this view is totally inappropriate for what
you are looking for.

Resource usage shows the resources AND THEIR ASSIGNMENTS (not tasks,
assignments)
To understand this read Faq 51 on
http://www.mvps.org/.project/faqs.htm

Now for your question: you can't have that off the shelf, it needs some
work.
You can do it manually, it's quite a story.
If you know how to install and run a macro, this can help:

sub ShowWBS
dim Job as Task
Dim Whodunit as assignment
for each job in activeproject.tasks
if not job is nothing then
for each whodunit in job.assignments
whodunit.text1=job.wbs
next whodunit
end if
next job
end sub

After running that, show the text1 field in the resource usage view
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jan De Messemaeker]

Sorry this doesn't work for resource pools.
I'll think of a better solution and send it.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jan De Messemaeker]

Hi,

Here's a better macro, one that will work
The pool must be the activeproject
The sharer projects ghave to be open

Sub ShowWBS()
Dim Man As Resource
Dim Ass As Assignment
Dim Proj As Project
For Each Man In ActiveProject.Resources
For Each Ass In Man.Assignments
Set Proj = Ass.Parent
Ass.Text1 = Proj.Tasks(Ass.TaskID).WBS
Next Ass
Next Man
End Sub

Greetings,


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[JulieS]

Hi Jan & oisinirish,

Unless I am missing something here (*very possible*) I was able to add
the WBS field to the resource usage view and view the WBS codes from
the task list. I know it shouldn't work , but in testing using a pool
file and Project 2003 with sharer files, it worked and I was able to
see the task WBS on the assignment lines. I opened the pool file with
the third option (open the pool read/write and all other files into
master), displayed the Resource Usage view in the pool file and added
both the project field and the WBS field

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[JulieS]

Hello oisinirish,

If you open the pool project with the third option (Open the resource pool
and all other projects....) then display the Resource Usage view in the pool
file. By adding the [Project] field to the table (left side), you should see
the project files that the assignments come from. You can also add the WBS
field to the Resource Usage view to see the WBS codes for the assignments.

I hope this helps. Let us know how you get along.

Julie