How to use the Team Capacity Planner Excel
Follow the below steps start using the Team Capacity Planner Excel Template:
This template is calendar-based allows resource planning for the team by using the matrix of resources, dates, and tasks.
This template has two tabs -Plan and config
Plan tab
- Plan tab has a matrix for resources, tasks, and dates.
- Resource availability is highlighted in Green, leave in red, weekend work in red, Holiday is red.
- Availability, Leave, Holidays and tasks have been coded using the conditional formatting so changing any text for these types might affect the color display.
Config tab:
- This tab has a resource list and projects.
- The resource can be defined in the config tab.
- You can define Projects as tasks or projects.
- Some tasks are a default and should not be changed