Capacity Planning, Sprint Planning and Tracking – 3 Weeks Iteration

Capacity Planning Sprint Planning and Tracking - 3 Weeks Iteration

This Template is prepared for planning your scrum team capacity and Plan your Sprint and Track it as part of sprint execution

This is designed for the scrum team, who estimate their capacity in hours, and during sprint planning distribute the story into small subtasks and assign them to team members and validate that the team members’ allocation and estimation are in sync with their capacity.

There are 11 Sheets to capture the information. You will get the details of the sheet from the Details tab. below mentioned the list of Tabs you will,

  1. 1 Team Define the Team Name and Focus Factor
    2 Current Sprint Sprint Name and Candance
    3 Holiday List The list of Holidays falls under the sprint duration
    4 Ceremony Time Capture the time for each ceremony or planned meeting
    5 Team Member Team Member’s Name, Role, and their allocation % to the Project
    6 Individual Vacations Capture individual planned vacation time.
    7 Default Sub Tasks Possible Subtask the team will be working on
    8 Task Flow Status Status of subtask in their from start to end
    9 Task Status treat as Done Last status of the task workflow
    10 Starting Task Status First Status pf the workflow
    11 Stories to Plan List of initial stories to be planned, for quick population

For more posts like this follow Agile Digest social Pages or subscribe our newsletter:
Wesbite:   https://us.agiledigest.com/
Facebook: https://www.facebook.com/agiledigest/
LinkedIn : https://www.linkedin.com/company/agiledigest/
Youtube: https://www.youtube.com/@AgileDigest
Agile Digest Academy:   https://academy.agiledigest.com/ 

This Template is prepared for Plan your team capacity and optimize your commitment during Sprint Planning, and track your sprint Execution
Limitations
Max Team Member 15
Sprint Duration 3 Weeks
Holiday Rule Team Holiday Override – Individual Holiday

Definition
The “Definition” sheet is the first sheet where you will configure the sprint for Capacity Planning
This sheet have 11 sections to define

  • Team Define the Team Name and Focus Factor
  • Current Sprint: Sprint Name and Cadence
  • Holiday List: List of Holidays fall under the sprint duration
  • Ceremony Time: Capture the time for each ceremony or planned meeting
  • Team Member: Team Members Name, Role and their allocation % to the Project
  • Individual Vacations: Capture individual planned vacation time.
  • Default Sub Tasks: Possible Subtask the team will be working on
  • Task Flow Status: Status of subtask in their from start to end
  • Task Status: treat as Done Last status of the task workflow
  • Starting Task Status: First Status pf the work flow
  • Stories to Plan: List of initial stories to be planned, for quick population

Note : There will be some default values when you are using it for the first time. Please change it accordingly

Analytics
The Sheet have the pivot table that you may need to refresh after any change on definition sheet

Capacity
This Sheet is the Final output of the planned capacity. It’s a View only Sheet t calculate and represent the capacity. If any changes required, please change on the definition sheet.

Planning & Tracking
This is the main worksheet, where the team will Plan their work and update during sprint Execution

Tracking Data
This worksheet is for Internal Calculation and Chart Population. Do not Change

Planning Summary
Story and Task distribution analysis among team members monitor the optimal capacity Utilization

Sprint progress Summary
A Quick dashboard for tracking the sprint progress Burn Down chart, Burnup chart, Capacity Utilization etc

Estimation Accuracy
This sheet is to refer on the last day of the sprint or after the sprint closure, to check the Over and Under Estimation

Master Format
The master Sheet for copying the Formula and Formats to create rows in Planning & Tracking

Change Request

If you need any changes – drop us a mail at [email protected] – with a nominal fees we will make the changes for you.

Team Members x 15
Sprint Duration 3 Weeks
Holiday Rule Team Holiday Override – Individual Holiday
Sub Tasks Max 10
Status of Subtasks Max 10
User Stories to Auto Populate with Sub Task Max 25
Max row of Tracking including Story and Subtask Max 225
  • Can I have more than 15 members

    For that change, you need to make lots of modifications, If you are good at Excel, you can make the changes. or you can look for our another capacity planner template, designed for 40 members  .

  • If I need any support on customization, How can I reach you

    You can email us at [email protected]

  • Can I use this template for two or more teams

    Yes You can, just make a copy and go ahead.

Quick Glance

Price

Original price was: ₹11,000.00.Current price is: ₹8,500.00. + Tax

Add to Cart
Enquire now more information about
Capacity Planning, Sprint Planning and Tracking – 3 Weeks Iteration

We recognize that committing to training investments can be a challenging decision. Rest assured, our team is here to assist you. Kindly provide your information in the form below, and we will promptly reach out to you with the necessary details.

You May be Interested in

Shopping Cart
Scroll to Top