Team Status Report Template - Resource Plan

by Nash V

Team Status Report

As a team leader, it is important that you effectively communicate your team's tasks' status. Providing transparency on the resource plan for your teams helps you to manage your stakeholders effectively.

      Team Status Report, Team Status Report Template, Resource Plan
      Team Status Report Dashboard

      Key Features about the Team Status Report Dashboard

      • Can handle up to 10 resources and 5 projects for 3 weeks.
      • The status report is a combination of PowerPoint(Dashboard) and Excel(Resource Plan).
      • Tasks completed and planned for next week will cover the tasks the team is planned to work on.
      • The key updates can be used to highlight team issues, leave plans, general news, etc.,
      • Project allocations display the resource allocation in terms of days for projects.
      • Covers tasks completed this week, tasks planned next week, and other key updates for the team.

      How To Use The Team Status Report Dashboard

      As mentioned earlier, the dashboard is made of two parts - PowerPoint (Dashboard), which contains the actual report, and excel sheet (Resource Plan), which contains the actual resource allocations.

      The Task Completed, Tasks Planned, and Other Key Updates section is a table in the PowerPoint and updated in the PowerPoint. The remaining Sections should be updated in the resource plan.

      Resource Plan - Steps

      To start with, the resource plan needs to be updated with the details for resources and projects. In the resource, the data section adds the resource names. Make sure you use short names, or the graphs and allocations will not be aligned.

      The resource plan is for 3 weeks. The allocations for last week and the upcoming two weeks. If the total number of hours allocated is more than 8 (max hours per day), that cell is highlighted in red. The max hours per is configurable and can be set in the config tab. Similarly, in the Projects Data, you can add the project names. 

      Team Status Report Template, Resource Plan ,week report format
      Resource Data
      Team Status Report Dashboard, Project Data, week report format
      Project Data

      After you set up the resource and projects, you can proceed to do the allocations to the Resource Plan tab. Do not update the allocations data in Resource Data or Project Data. The allocations should be updated only in the Resource Plan tab.

      In the resource plan tab, you need to allocate resources to projects. The resource plan also looks forward to 3 weeks. You can allocate the resource on hours per day. So, if a resource is 100% on a project, then you allocate 8 hours. If the resource is allocated 50%, then you allocate 4 hours to the project.

      Resource Plan, week report format
      Resource Plan

      Integrating resource plan and the dashboard

      This is the trickiest part as it requires you to copy-paste the table and charts from the spreadsheet. Follow these steps to integrate -

      • Download the zip file and unzip it at a location of your choice. Delete the charts and table.
      • Copy the graphs present in the Project Data tab and then, using the Paste Special(top left-hand corner), paste the charts.
      • Copy the tabular data and paste it into the lower section of the dashboard.
      • Any updates to the sheet will be reflected in the dashboard. If not, then you can right-click and then click on the Update Link option.
      Team Status Report Dashboard, Team Status Report Template
      Copying graphs
      Team Status Report Dashboard
      Paste Special Options
      Resource and Capacity Plans Pack