Team Capacity Planner Excel
When managing a small team it is vital that a manager has all the tools required to do capacity or workload planning. This template which is calendar based allows resource planning for the team by using a matrix of resources, dates and tasks.
- The excel version has two tabs - plan and config.
- The plan tab has the matrix for resources, tasks, and dates.
- The config tab has a resource list and projects. Resources can be defined in the config tab.
- Resource availability is highlighted in green, leave in red, weekend work in red, Holiday is red.
- The projects can be tasks or projects.