Resources

In project management, resources are required to carry out the project tasks. They can be people, equipment, facilities, funding, etc. required for the completion of a project activity.

Gantt Excel automatically calculates end dates for tasks based on resource holidays/ workdays.

If a resource is not assigned to a task then the Organization workdays and holidays are used to determine end dates.

Resources in Gantt Excel

You can manage resources in Gantt Excel in the Resource Form. Click on the Resources button in the Gantt menu to open the Resource Form.

Resource Button
Gantt Resource Management

Add Resource

To add a resource, type in the text box below the Resource List and then click the Add button.

Import Resources

You can also import resources by clicking on the Import Resources button.

Edit Resources

You can select a resource from the Resource List and you can change the Resource Name in the Resource Details section. Click on Save when done.

Delete Resource

You can select a resource from the Resource List and click on the Delete Resource button to delete the resource.

Assign Resource to Task

There are 3 ways you can assign resources to tasks. 

  1. Directly type the resource name in the Resource cell.

    Resource Cell

  2. You can double click the Resource Cell in the task grid to open the Resource Selector form.
    Select the Resource and click the Ok Button.

    Gantt Excel Resource Selector Form

  3. The third method is to edit a task and then select the Resource field to assign a resource.

    Task Form Resources

    Multiple Task Owners/ Resources

    Note: If two or more resources are assigned to a task then the automation will use the Organization holidays and workdays to determine the end date.

    Having multiple people responsible for a single task is not a good idea.
    The best practice is to define the parent task as a place holder and have each sub-task assigned to a single person for better accountability and tracking.

    Gantt Chart Task Owners

Watch this video tutorial on “How to Add & Assign Resources to Tasks in Gantt Excel”

Video Tutorial - How to Add Resources in Gantt Charts

Notes

  1. You can also set holidays and workdays for each resource.

  2. If a resource is not assigned to a task then the Organization workdays will be used.

Create Resource Calendar

Click on the link below to create a Resource Calendar using Gantt Excel

Resource Calendar

Resource Calendar