Agile Capacity Planning (Download Template for free)


What is a Capacity Planning

The number of productive hours available for a sprint is called sprint capacity. The capacity is calculated before starting a sprint to identify how many stories team can accomplish for the upcoming sprint. This process is called capacity planning. This helps the team to make a commitment (How many story-points team would complete).

How to do Capacity Planning

You can download the template for capacity planning available at

Download AC Capacity Planning Template

Follow below steps

  1. Provide sprint start and end date. State daily total hours available each day for one person.
  2. Mention all the team member names (Column B11 onwards)
  3. Set high-level default percentages and click “Set Default Allocation” Button.
  4. The defaults will be set. These can be updated for individuals as per your team allocation.
  5.  Click “Plan Button”
  6. This would open capacity sheet with available hours for each individual for all days (Start to end of the sprint)
  7. You can make changes to individuals availability on specific days. Consider holidays, time off and other factors which affect hours for given days.
  8. Fill in details of past sprints if you have data. If not, you would start having that from next sprint onwards once you start using this planner.
  9. Based on past sprint data you get hours per story points in the Capacity sheet that would help us to derive how many story points we can really commit for upcoming sprint for which we are doing capacity planning.

Please note you can use the template I provided or any other template you or your company already have. My goal is just to make the process easy and make you understand the benefit.


  • The availability percentage help us to identify available hours which eventually help us to pick the right amount of work for a given sprint.
  • Many sprint team does this manually which has two disadvantages
    • The chances of making mistake are high.
    • The velocity is either considered by averaging past few sprints or simply picking velocity of the previous sprint.  The better way is to multiply your capacity of a team with focus factor.

Focus Factor    =    (Average Velocity of previous sprints)/(Average  Capacity of previous sprints)

  • Improves focus and commitment which in turn increases chances of sprint success.
  • The holistic view of data what you get for past sprints using capacity planning does help in taking decisions and continuous improvement.

In order to see the real benefit of this template, you are expected to use the template for at least 3-4 sprints. Further, as you move, you see more benefits.

There are multiple teams I know leveraging this template I shared and I see them getting befitted out of it. This is most basic template while if you think you want to add more to it, just provide the details in terms of what do you want and I will incorporate into my template.


3 Replies to “Agile Capacity Planning (Download Template for free)”

  1. I have modified the template to calculate the number of working hours rather than the total available hours in a sprint and I have added another column for team members that are involved in Kanban activities. I would like to update the macro to reflect the changes. Can you share the password for the protected sheets?

    1. My capacity planner online tool will be available in next few days that would have many customized options. I am sorry but I won’t be able to share with you, the password for protected sheets as it has many copyrights routine which would be used in building other products. You can share my spreadsheet with your updates and let me know the changes you want to make. I would be happy to do so only for you.

Leave a Reply

Your email address will not be published. Required fields are marked *