Sum Work for different Resource Groups

Question

Hi

I have 2 groups of work resources "Internal" and "External".  Many of my tasks have multiple work resources assigned to them - generally a mix of internal and external resources.

In my Gantt chart view I'd like to add two custom columns - one to sum the work for Internal resources and one to sum the work for external resources - to give me a quick view of how much work I have for the internal and external teams on each task.  Is it possible to create that formula or does it require VB?

Any pointers out there gratefully received.

Thx

Mike

Answer 1

A quick and easy is:

1. In the Resource Sheet enter Int or Ext against each resource in the Resource Initials column (or Resource Group if you already make use of the initials column. If you already use both then you need a VBA solution
2. In the Gantt View select View, Group by... New Group.
3. Name it Int-Ext
4. In the Group By row select Resource Initials
5. Check Show Summary Tasks and  Maintain Hierarchy (these are optional. You can edit the group and turn on or off one at a time to see their affect.
6. OK

However if you assign a Int and an Ext resource on the same task this solution doesn't work too well.

You can also show a Group in the resource Usage view, but that will only provide totals for the whole project, not by task.

A Group in the Resource Usage View may also be of use.

Otherwise VBA can do whatever you want.