Resource Usage

[Joey]

Hi. I am fairly new to project and hope that someone can help me with this:

I have a project 2000 schedule which is broken down into many sub-sections
of approx. 250 tasks each. In some cases I use the same resource across
several sub-sections. i.e. I allocate a systems engineer to some tasks in
the design sub-section and in the review sub-section.

Is it possible to view a resource graph for a particular resource, for a
specific set of tasks i.e for just the design sub-section? I can only get it
to show the overall graph for that resrouce - across the whole schedule i.e.
includes the hours for both design and review.


Thanks for your help.

Joey.

 

[John]

Hi. I am fairly new to project and hope that someone can help me with this:

I have a project 2000 schedule which is broken down into many sub-sections
of approx. 250 tasks each. In some cases I use the same resource across
several sub-sections. i.e. I allocate a systems engineer to some tasks in
the design sub-section and in the review sub-section.

Is it possible to view a resource graph for a particular resource, for a
specific set of tasks i.e for just the design sub-section? I can only get it
to show the overall graph for that resrouce - across the whole schedule i.e.
includes the hours for both design and review.


Thanks for your help.

Joey.

Joey,
Here is a method that will work well if each task has only 1 resource
assigned. Display the Gantt Chart view. Then go to Window/Split and
select Resource Graph for the lower pane. With the upper pane active, go
to Project/Filtered For/More Filters. In the More Filters window hit
"New". In the Filter Definition window set up the following:
Field Name Test Value
Resource Names Contains "Enter a resource"?

Then hit "Ok" and "Apply". A interactive filter user query will pop up.
Enter a resource name and hit "Ok". Now select all the tasks in the
upper pane. The graph for the assignments (tasks) for the entered
Resource Name will show in the lower pane.

You might also like to Take a look at the FAQs on the MVP website at:
http://www.mvps.org/project/faqs.htm
In particular look at FAQ 38 - Combined Resource Graph

Hope this helps.
John
Project MVP

 

[Joey]

Hi John,


Thanks for the response.
Carrying out the steps that you describe doesnt quite give me the data that
I want. It shows the total work for that resource over all of the tasks in
the project. I need to distinguish between the systems engineering hours
specifically for design and those specifically for review.

With this method, I see the total systems engineering hours, in graphical
form, for both design and review.


Thanks,

Joey

 

[John]

Hi John,


Thanks for the response.
Carrying out the steps that you describe doesnt quite give me the data that
I want. It shows the total work for that resource over all of the tasks in
the project. I need to distinguish between the systems engineering hours
specifically for design and those specifically for review.

With this method, I see the total systems engineering hours, in graphical
form, for both design and review.


Thanks,

Joey

Joey,
My apologies, I didn't read your post carefully enough. To show only
selected tasks for a particular resource modify the filter as follows:
And/Or Field Name Test Value
Resource Names Contains "Enter a resource"?
And Flag1 equals Yes

Then set the Flag1 field for only those tasks you wish to see (e.g.
design sub-section) and apply the filter. The resource graph will now
show the data you need. Again, this only works if there is only one
resource per task.

If you want to view selected tasks for several different resources,
setting the flag field for each resource could be very tedious. In that
case, it may be more convenient to use a spare number field to encode
groups of tasks for different resources. For example, spare Number1
could be set to "1" for all design sub-section tasks, "2" for all test
review tasks, "3" for all assembly tasks, etc. Then the filter would be:
And/Or Field Name Test Value
Resource Names contains "Enter a resource"?
And Number1 equals "Enter code value"?

Hopefully this revised method will get what you want. If not, there is
another option that will - VBA. You mentioned that you are new to
Project so diving into a VBA solution may or may not be of interest to
you. Personally, I would go for a VBA solution right away because with
it any Project data can be plotted in virtually any form by exporting it
to Excel. With a VBA approach, it doesn't matter if one or several
resources are assigned to a task. The correct data can be pulled for the
graph.

Hope this helps.
John
Project MVP