none
Direct Vs. Indirect Labor Hours RRS feed

  • Question

  • Hi,

    I have both direct and indirect resources working together on the same tasks and charging labor to my project.

    I'd like to be able to sum the scheduled labor hours per month on my project but separate direct from indirect labor hour sums. In the "Task Usage" view it nicely shows the monthly total for scheduled labor hours at the top of the details section on the right, but when I filter out resources I know are indirect it still includes their hours in the monthly total. Is there a way to show only the monthly hour totals for filtered resources: i.e., direct hours only?

    Thanks,

    Larry

    Monday, March 19, 2012 3:46 PM

Answers

  • Hello Larry,

    Have you tried working with groups -- not filtering?  If you have entered "internal" or "external" in the Group field on the Resource Sheet view, you should be able to create a group in the Task Usage view.

    Try:

    Group first by: ID (to keep your task data together)

    Then by: Resource Group - and set the Field type to "Assignment" after selecting "group assignments not tasks".

    I hope this helps.

    Julie

    • Marked as answer by LawAnderson Friday, March 23, 2012 6:56 PM
    Monday, March 19, 2012 4:06 PM
    Moderator

All replies

  • Hello Larry,

    Have you tried working with groups -- not filtering?  If you have entered "internal" or "external" in the Group field on the Resource Sheet view, you should be able to create a group in the Task Usage view.

    Try:

    Group first by: ID (to keep your task data together)

    Then by: Resource Group - and set the Field type to "Assignment" after selecting "group assignments not tasks".

    I hope this helps.

    Julie

    • Marked as answer by LawAnderson Friday, March 23, 2012 6:56 PM
    Monday, March 19, 2012 4:06 PM
    Moderator
  • You could set up a custom number field to capture the calculate direct work, and a macro to populate it.

    1 - Rename the Tasks custom field Number1 as "Direct Work"

    2 - On the same field, set the Calculation for task and group summary rows to "Roll-up: Sum"

    3 - Rename the Resources custom field Flag1 as "Direct Resource", and tick it for all the direct resources

    4 - Paste the following code into a VBA module:

    Sub QuantifyDirectOnly()
        Dim obj_t As Task
        Dim obj_pj As Project
        Dim obj_a As Assignment
        Dim int_TaskDirTotal
        
        Set pj = ActiveProject
        
        For Each obj_t In ActiveProject.Tasks
            
            If obj_t.Summary Then
                GoTo NEXT_TASK
            End If
            
            int_TaskDirTotal = 0
        
            For Each obj_a In obj_t.Assignments
                If obj_a.Resource.Flag1 = True Then
                    obj_a.Number1 = obj_a.Work / 60
                    int_TaskDirTotal = int_TaskDirTotal + obj_a.Work / 60
                Else
                    obj_a.Number1 = 0
                End If
                
            Next obj_a
        
            obj_t.Number1 = int_TaskDirTotal
        
    NEXT_TASK:
        
        Next obj_t
    End Sub

    Now when you run the macro titled "QuantifyDirectOnly", it will count the number of hours for direct resources only and put this in the "Direct Work" field against tasks and assignments

    Monday, March 19, 2012 4:39 PM
  • Thank you both for all of the help and fast replies.

    I'll give them a try.

    Larry

    Monday, March 19, 2012 6:27 PM
  • You're welcome Larry.  Feel free to post back with further questions as needed.

    Julie

    Monday, March 19, 2012 6:53 PM
    Moderator