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

# CAPACITY PLANNING, SPRINT PLANNING AND TRACKING – 3 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 population Details This Template is prepared to Plan your team capacity and optimize your commitment during Sprint Planning, and track your sprint ExecutionLimitationsMax Team Member 15Sprint Duration 3 WeeksHoliday Rule Team Holiday Override – Individual HolidayDefinitionThe “Definition” sheet is the first sheet where you will configure the sprint for Capacity PlanningThis sheet have 11 sections to defineTeam Define the Team Name and Focus FactorCurrent Sprint: Sprint Name and CadanceHoliday List: A list of Holidays that fall under the sprint durationCeremony Time: Capture the time for each ceremony or planned meetingTeam Member: Team Member’s 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 there from start to endTask Status: treat as Done Last status of the task workflowStarting Task Status: First Status of the workflowStories 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 accordinglyAnalyticsThe Sheet has the pivot table that you may need to refresh after any change on the definition sheetCapacityThis 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 & TrackingThis is the main worksheet, where the team will Plan their work and update during sprint ExecutionTracking DataThis worksheet is for Internal Calculation and Chart Population. Do not ChangePlanning SummaryStory and Task distribution analysis among team members monitor the optimal capacity UtilizationSprint progress SummaryA Quick dashboard for tracking the sprint progress Burn Down chart, Burnup chart, Capacity Utilization, etcEstimation AccuracyThis sheet is to refer on the last day of the sprint or after the sprint closure, to check the Over and Under EstimationMaster FormatThe 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 fee we will make the changes for you.LimitationsTeam Membersx 15Sprint Duration3 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 225 FAQQ1. 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$140

## Authors

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