Plan your scrum team capacity and optimize during Sprint Planning

Exclusive offer for Academy Members


$ 45 One Time
$ 43 One Time
$ 34 One Time
$ 22
One Time
Capacity and Sprint Planning Template

How to Apply


Minimum 2 Months of Membership age

  1. Meet the Eligibility Criteria
  2. Apply for coupon code by filling out the Form
  3. Admin Validation
  4. Receive the Coupon Code
  5. Purchase from the Purchase link by applying the coupon code
  6. Download the Template 
Edit Content

This Capacity and Sprint Planning Template is prepared for Plan your scrum team capacity and optimize your commitment during Sprint Planning.

This Capacity and Sprint Planning Template  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 the team members allocation and estimation is in sync with their capacity.

There are 5 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. Definition
  2. Analytics
  3. Capacity
  4. Sprint Planning
  5. Estimation Accuracy

You will 6 different templates as below

9 Member Template (for 2 weeks and 3 Weeks sprint) – Two Template
15 Members Template (1 week to 4 weeks) – Four  Template

Edit Content

The details of each worksheet are mentioned below

The “Definition” sheet is the first sheet where you will configure the sprint for Capacity Planning
This sheet have 6 sections to define
1 Team Define the Team Name and Focus Factor
2 Current Sprint Sprint Name and Cadence
3 Holiday List List of Holidays fall under the sprint duration
4 Ceremony Time Capture the time for each ceremony or planned meeting
5 Team Member Team Members Name, Role and their allocation % to the Project
6 Individual Vacations Capture individual planned vacation time.
Note : There will be some default values when you are using it for the first time. Please change it accordingly

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

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

Sprint Planning
This sheet is you can use to plan your sprint my adding committed stories, with the task hours estimated by each team member, This Sheet will auto calculate the Planned Capacity and commitment Hours, with a graphical representation of utilization, and visual warning on over-commitment

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




Edit Content
Max Team Member 9 Member Template (for 2 weeks and 3 Weeks sprint) Total 6 Templates
15 Members Template (1 week to 4 weeks)
Sprint Duration 15 member : 1 Week, 2 Weeks, 3 Weeks & 4 Weeks
9 Members : 2 Weeks & 3 Weeks
Holiday Rule Team Holiday Override – Individual Holiday
Edit Content
 1. 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.

2. If I need any support on customizatio
n, How can I reach you

You can email us at [email protected]

3. Can I use this template for two or more teams

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


Explore the Screenshots

Apply for Coupon Code

Seems like You have not logged in yet, Please log in or sign up

    Scroll to Top
    Agile Digest Horizon