Actual Work by Resource

[jay]

Desktop: MS Project Professional 2002 SP-1
Server: MS Project Server 2003 SP-1

Both the Resource Usage view and the Resource Usage report allow one to
determine total actual work by Resource (by time period) if and only if all
of the projects that the Resource(s) have been assigned to have been
identified and opened prior to execution of either the view or the report.
For a project manager with 6-10 open projects, the above process is
inefficient. Also, excluding a project could yield incomplete information.

Is there a more efficient way to determine this information with the base
product?

Thanks in advance for your feedback.

 

[Dale Howard [MVP]]

Jay --

Have you considered using the View resource assignments page in PWA for this
purpose? To access this page, navigate to the Resource Center page in PWA
and then click the View resource assignments link in the sidepane on the
left side of the page.

The View resource assignments page allows the PM to select the resources
whose assignments he/she wants to see, and then shows all resource
assignments across all projects to which the resources are assigned. If the
default Summary view for View resource assignments does not show the exact
information that the PM needs to see, the Project Server administrator could
create a custom Assignments view for this purpose. Hope this helps.

 

[jay]

Hi Dale,

You are a gentleman and a scholar! The method you propose seems to head us
in the right direction...I am testing this method as such:

Display “All assignmentsâ€
Select “Timesheet formatâ€
Under “View Optionsâ€, specify date range, units = weeks

What I can't seem to arrive with (via this method in PWA) is total actual
work for the specified date range. Total actual work is available when using
either Resource Usage View or Resource Usage Report on Project Server.

I may very well have missed something here...please advise.

Thanks,
Jay

 

[Dale Howard [MVP]]

Jay --

Are you using Project Server 2003? If so, are you are using the default
Summary view? If so, look in the timesheet portion on the right side of the
view. Don't you see Work and Actual Work totaled for each resource by
project? I'm looking at the View resource assignments page right now and
see totals form each resource during each weekly time period. Let us know.
--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We wrote the books on Project Server"

 

[jay]

Hello Dale,

It's a beautiful Indian Summer day here in Columbus, OH...hope it's a great
day where you are...

Yes, MS Project Server 2003 SP-1

Yes, actual work is totaled for each resource by project/task by (units:
entire period) with this method in PWA; however, there is NOT an final total
by Resource for the units/entire period. Recall that a final total figure IS
available by Resource by period on either the Resource Usage View or Resource
Usage Report on Project Server. Recall that these prior methods are
inefficient and error prone as ALL projects that a Resource is assigned to
must have been identified and opened PRIOR to executing the view or the
report (elegant design)...or the results are meaningless...

p.s. I know, you didn't design/write it <g>

Regards,
Jay

 

[jay]

Hi Dale,

I have the solution...using the method you had suggested...

Under “Filter, Group, Searchâ€, specify Group by Resource (allows total by
Resource)

Thanks again for your assistance and have a great day.

Jay

 

[Dale Howard [MVP]]

Jay --

Go Buckeyes! I used to live in the Dayton area. You are more than welcome
for the help, my friend!

 

[Dale Howard [MVP]]

Jay --

Go Buckeyes! I used to live in the Dayton area. You are more than welcome
for the help, my friend!

 

[owp^3]

While this works for targeted research its not so useful for larger efforts.

You can only select 100 resources.

I have about 400 resources in my pool and I want to look at all of them at
the same time using the export to grid function.

Even worse the availability view only allows you to select 10.