Re: Separting costs for internal and external resources
From: John (mjensen_at_theriver.com)
Date: 01/03/05
- Next message: gerry myers: "Editing Text w/in customized column"
- Previous message: JackD: "Re: can't outdent inserted projects"
- In reply to: toast88: "RE: Separting costs for internal and external resources"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 03 Jan 2005 10:49:06 -0800
In article <335A1344-B960-4A02-843B-999FEC871582@microsoft.com>,
"toast88" <toast88@discussions.microsoft.com> wrote:
> I, too, have the need to track costs by different categories of resources as
> ProjectFly stated. I have not found a way (or invested enough time yet to
> find it!) to avoid exporting to Excel for the calculations.
>
> Julie, hopefully you will be able to identify a solution within MS Project.
>
> "JulieS" wrote:
>
> > Hi ProjectFly,
> >
> > I can arrive at a partial answer using the Resource Group field in a task
> > view. Enter the Internal or External information on the resource sheet in
> > the Group Field. You may then add the Resource Group field to any task
> > view
> > and see which group the assigned resources are from.
> > You can then add one of the custom Cost fields and show costs where only
> > internal or external resources are assigned using a formula like:
> > IIf([Resource Group]= "Internal", [Cost], 0)
> > Use another cost field to test whether the resource group equal "External".
> >
> > The challenge becomes when you have both internal and external resources
> > assigned to a single task. I have not yet be able to come up with a way to
> > parse that information and determine which part of the cost belongs to
> > which
> > resource in Project.
> >
> > Another option is to start with the beginning suggestion (use the resource
> > Group field) and then export that information to Excel. I used the Export
> > Map "Task List with embedded assignment rows" and modified the map to add
> > the
> > Resource Group field. Once in Excel, it becomes much easier to manipulate
> > the data.
> >
> > Hope this helps partially and perhaps another reader can respond with a
> > better answer. I'll keep plugging away and will post with a possible
> > solution when I find one.
> >
> > Julie
People,
I know I answered a very similar post recently but for the life of me I
can't find the response. Maybe it was deleted or lost.
The problem of course is dealing with multiple resources on a single
task. As long as the number of different resource groups is not large,
say in excess of 10 or 15, an export to Excel is not needed, but VBA is
needed. The psuedo code to do what you need is as follows:
1. Set up custom fields for the cost of each resource group. There are
10 spare cost fields and 30 spare text fields so Project can actually
support more than the 10 to 15 resource groups I noted above.
2. In VBA set up a loop to cycle through all tasks with assigned
resources.
3. Within the task loop, set up another loop to cycle through each
assignment of that task.
4. For each assignment get the appropriate pay rate, apply it to the
work hours for that resource, and store the result in the designated
custom field as a running total.
That's it, pretty straightforward actually.
Hope this helps.
John
Project MVP
- Next message: gerry myers: "Editing Text w/in customized column"
- Previous message: JackD: "Re: can't outdent inserted projects"
- In reply to: toast88: "RE: Separting costs for internal and external resources"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
