Big Team – Capacity Planner

4,800.00 + Tax

Big Team Capacity Planning template, supports up to 40 members


This template is prepared to Plan your Big Team (up to 40 members) capacity and optimize your commitment during Sprint Planning.


Max team Members40
Sprint Duration in Weeks1 week, 2 weeks, 3 weeks, 4 weeks
Holiday RuleTeam Holiday Override – Individual Holiday

Quick Tutorial (Prepared for 9 Members Team)

Worksheet Information’s


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

1TeamDefine the Team Name and Focus Factor
2Current SprintSprint Name and Cadence
3Holiday ListList of Holidays fall under the sprint duration
4Ceremony TimeCapture the time for each ceremony or planned meeting
5Team MemberTeam Members Name, Role and their allocation % to the Project
6Individual VacationsCapture individual planned vacation time.

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


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


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

Sprint Planning

This sheet is you can use to plan your sprint my adding commited stories, with the task hours estimated by each team member, This Sheet will auto calculate the Planned Capacity and commitment Hours, with 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

Video Tutorial

Follow the Video Tutorial on Youtube to learn how to work on this template.

Change Request

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