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.
To add a resource, type in the text box below the Resource List and then click the Add button.
You can also import resources by clicking on the Import Resources button.
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.
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.
- Directly type the resource name in the Resource cell.
- 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.
- The third method is to edit a task and then select the Resource field to assign a resource.
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.
Watch this video tutorial on “How to Add & Assign Resources to Tasks in Gantt Excel”
Video Tutorial - How to Add Resources in Gantt Charts
- You can also set holidays and workdays for each resource.
- 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