---
title: "CAPACITY AND SPRINT PLANNING AND TRACKING – 2 WEEKS ITERATION"
slug: capacity-planning-and-sprint-planning-tracking
url: https://agiledigest.perfectlyimperfectdigital.com/digital-downloads/capacity-planning-and-sprint-planning-tracking
type: paid
price: "US$110"
---

# CAPACITY AND SPRINT PLANNING AND TRACKING – 2 WEEKS ITERATION

## Description

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,1TeamDefine the Team Name and Focus Factor2Current SprintSprint Name and Cadence3Holiday ListThe list of Holidays falls under the sprint duration4Ceremony TimeCapture the time for each ceremony or planned meeting5Team MemberTeam Member’s Name, Role, and their allocation % to the Project6Individual VacationsCapture individual planned vacation time.7Default Sub TasksPossible Subtask the team will be working on8Task Flow StatusStatus of subtask in their from start to end9Task Status treat as DoneLast status of the task workflow10Starting Task StatusFirst Status pf the workflow11Stories to PlanList of initial stories to be planned, for quick populationThis 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 2 Weeks Holiday Rule Team Holiday Override – Individual HolidayDefinition The “Definition” sheet is the first sheet where you will configure the sprint for Capacity Planning This sheet have 11 sections to defineTeam Define the Team Name and Focus FactorCurrent Sprint: Sprint Name and CadenceHoliday List: List of Holidays fall under the sprint durationCeremony Time: Capture the time for each ceremony or planned meetingTeam Member: Team Members Name, Role and their allocation % to the ProjectIndividual Vacations: Capture individual planned vacation time.Default Sub Tasks: Possible Subtask the team will be working onTask Flow Status: Status of subtask in their from start to endTask Status: treat as Done Last status of the task workflowStarting Task Status: First Status pf the work flowStories to Plan: List of initial stories to be planned, for quick populationNote : There will be some default values when you are using it for the first time. Please change it accordinglyAnalytics The Sheet have the pivot table that you may need to refresh after any change on definition sheetCapacity 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 ExecutionTracking Data This worksheet is for Internal Calculation and Chart Population. Do not ChangePlanning Summary Story and Task distribution analysis among team members monitor the optimal capacity UtilizationSprint progress Summary A Quick dashboard for tracking the sprint progress Burn Down chart, Burnup chart, Capacity Utilization etcEstimation Accuracy This sheet is to refer on the last day of the sprint or after the sprint closure, to check the Over and Under EstimationMaster Format The master Sheet for copying the Formula and Formats to create rows in Planning & TrackingChange RequestIf you need any changes – drop us a mail at support@agiledigest.com – with a nominal fees we will make the changes for you. LimitationsTeam Membersx 15Sprint Duration2 WeeksHoliday RuleTeam Holiday Override – Individual HolidaySub TasksMax 10Status of SubtasksMax 10User Stories to Auto Populate with Sub TaskMax 25Max row of Tracking including Story and SubtaskMax 225FAQQ1. Can I have more than 15 members?Ans: 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 .Q2. If I need any support on customization, How can I reach you?Ans: You can email us at support@agiledigest.comQ3. Can I use this template for two or more teams?Ans: Yes You can, just make a copy and go ahead.Video Tutorial Download Brochure Gallery

## Details

- Price: US$110

## Authors

- [Niladri Mahapatra](https://agiledigest.perfectlyimperfectdigital.com/@niladri) — Founder Agile Digest