Breaking Out Global Resource Cost from Local Resource Cost

D

Doug Schurman

We have projects where all of our internal staff are considered global
resources and subcontract vendors working on the project are added in as
local resources. We really want to track costs seperately between global
resource and local resources. Is there anyway to do that?

Thanks
 
R

Rod Gill

If you want to see the cost differences in Project Pro then you would need a
macro to do this. The macro would create a new Task cost by summing only
costs from Enterprise resources in one custom field and local resources in
another custom field.

In PWA you would need to create a new data analysis view that summed costs
for Enterprise resources, but the cube doesn't have local resource data.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
D

Doug Schurman

Thanks for the response. Here's a little different question. Is there a way I
can create a custom field to calculate resource hours x resource cost rate
for all the resources assigned to a task. I would like this calculation to
exclude anything on a task where units are used as opposed to hours.

Is that possible?
 
D

Doug Schurman

Rod, thanks for the response. I would like the costs from enterprise
resources to show up in PWA. I do not understand how you would "create a new
data analysis view that summed costs for Enterprise resources" I don't see
how any of the fields available for the views in PWA give me access to only
global resources.

I'm really looking for only resource hours x resource rate. This just happen
to all be global resources. All local resources ae seup to use units instead
of hours.

Thanks
 
R

Rod Gill

Units still creates hours. All local resources will also have hours of work.

Do you have a cube being built nightly? If so then your PWA Admin person can
create a new Data Analysis View for PWA.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
D

Doug Schurman

I understand more now. I happen to be the PWA Admin person also. I was really
looking for a calculation that would be done real time like the custom fields
when you publish a project that could be viewed in a PWA Project Center view.
 
R

Rod Gill

You can't have a calculation in Project pro as formulae work only at the
Task and Resource level. You could therefore sum Resource costs, but no
assignment costs. For PWA you would need a PSI programmer to develop
something.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
D

Doug Schurman

Okay Rod, here's another option to pursue.

Is there any calculation I can use in a custom field like a sumif type of
calculation where I could check to see if the resource is a global resource
and it multiplies resource rate x hours on a task by task basis and then I
create a custom field in project fields that sums all the tasks?

The other option instead of checking if the resource is global is to add a
resource source field where I record a labor rate for only global reosurce.
Then If I could do a sum all product of task hours x resource custom field
rate. The local resource would be zero and would not add to the calculation.
Is there a way to do this?

Thanks for indulging my questions.
 
D

Doug Schurman

Thanks for the response Paul. We don't currently use multiple rate. How would
I go about finding out how to report on these type of details in Reporting
Sevrvices or Excel?

Thanks
 
D

Doug Schurman

I hooked into the Project Server DB through Excel. It was fairly straight
forward to create the query to pull up all assignments related to a specific
project with a global resource assigned. So this does answer the need I have.
I would really rather have a way to make a Project view in PWA to see this
data but I don't think I can drill down to the assignemnt level nor can I
filter on resource type.

Cube views don't work because of the time delay of the data.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viewing Resource Cost in OLAP cube 1
Local Resources vs Enterprise Resources 3
Wrong total cost for Resource 0
Representing new, open positions in EPM 2003 for resource planning 2
Using cost resources 1
Cube data not showing correct actual costs for cost type resources 2
Cannot keep resources out for editing - Project Server 2003 5
PS 2003 Icon - Information for this resource has changed. 3

Top