Project Team - Total Allocated Effort and Total Actual Effort

    The Project Team consists of the resources (user, contact or queue) you are assigning tasks to. Tasks can assigned to resources either automatically or manually.

     

    Automatic Task Assignment

    When a Project Team record is created where a Role is defined for the resource, Inspire Planner automatically assigns Tasks with the same Role (for more information, please see Auto Assign Tasks to Project Team Members using Roles). 

     

    Manual Task Assignment

    Tasks can be manually assigned to a resource by manually populating the "Assigned To" cell for a project task. When you manually assign tasks, and if there is no existing project team record, Inspire Planner will automatically create the project team record based on the following:

     

    Task Multi-RoleResource Project Team RecordResult
    Is blankDoes not existNew project team record is created for the resource and Role is set to blank in the Project Team record
    Has a valueDoes not existNew project team record is created for the resource and Role is set to blank in the Project Team record
    Is blankExistsNo new project team record is created
    Has a valueExists but the Role is differentNew project team record is created for the resource and Role is set to blank in the Project Team record
    Has a valueExists and the Role is the same as the task Mult-RoleNo new project team record is created

     

     

    Total Allocated Effort and Actual Effort Rollup

    If there are tasks assigned to resources where the task Planned Effort has a value, it rolls up the Total Allocated Effort to the project team record of the resource. When the resource logs time for their assigned tasks, it also rolls up the Total Actual Effort to the resource's project team record.

     

    The Project Team Record contains the following rollup fields:

    Total Allocated Effort = SUM (Task Planned Effort * % Allocation) of the resource's assigned tasks

    Total Actual Effort = SUM (Time Entries) logged by the resource against their assigned tasks

     

    The rollup to the Project Team record occurs when:

    • Task Planned Effort is populated or edited
    • % Allocation is edited
    • Role is edited
    • Task is assigned or unassigned
    • Task is deleted
    • Time Entries are created, edited or deleted

     

    Resource Project Team RecordRoleResult
    ExistsProject Team Role and Task Multi-Role MatchTask Allocated Effort and Actual Effort rollup to the project team record for the resource with the same role.
    ExistsProject Team Role is blank or does not match the Task Multi-RoleTask Allocated Effort and Actual Effort rollup to the project team record for the resource where Role is blank.

     

    Please Note:

    • If the project team record does not exist for the resource, it will create the project team record according to the conditions listed under Manual Task Assignment.
       
    • The rollup of both Allocated Effort and Time Entries are handled by the Inspire Planner Beacon. This means that if you create, edit or delete records, you will need to wait until the Beacon runs before you can see the updates to Project Team Total Allocated Effort and Total Actual Effort.

     

     

     

     

     

     

     

     

     


    Tags

    Project Task AssignmentProject Teams & Roles

    « Previous ArticleNext Article »