How to use the Team Resource Plan Excel Template
Follow the below steps start using the Team Resource Plan Excel Template:
Team Resource Plan Excel Template provides the clear view of team members allocation to multiple projects.
The template has two section tab Plan and Projects
Plan Section:
- Enter the Resource name in the Resource column
- Enter the project ID in the ID column (as per the Projects no. in the project tab)
- Do not Enter the Project name in the Project column as it is auto Populated when you enter the Project ID.
- An “X” denotes an allocation. Depending on the project selected the color of the cell will be highlighted as per the color in project tab.
- An “L” denotes a Leave and will be highlighted in red.
Project section:
- Enter the Project name in the Name column.
- Assign the no. to each project, this no. is used as project id in the plan section.