John
Fri Mar 02 19:34:19 CST 2007
In article <CEA44C93-9524-4AF0-AB71-5D22EF4FCAC1@microsoft.com>,
R Casali <R Casali@discussions.microsoft.com> wrote:
> Good Afternoon,
>
> The project plan that I am working on has a field ("text2") that has been
> set to capture one of about eight (8) project sub-codes, for the purposes of
> time tracking. This field is on the individual task level.
>
> I would like to be able to tie each resource name to the relevant project
> sub-codes, then to the sum of the work associated with all of the tasks
> sharing the same subcode.
>
> This is essestially the Resource Usage View, with the individual tasks
> grouped by my project sub-code fields.
>
> Any ideas? Thank you and have a great day!
R Casali,
First I recommend you go to our MVP website at:
http://project.mvps.org/faqs.htm, and take a look at FAQ 51 - Data
Types: Task, Resource and Assignment. Once you understand that you will
see that you need to translate task Text2 field sub-codes into
assignment Text2 field sub-codes and the quickest way to do that is with
a simple VBA macro (see FAQ 37).
Once you have all the data in place, you probably want to use Project's
grouping function (Project/Group By) to sum up the work for each project.
Hope this helps.
John
Project MVP