Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesProject & Task ManagementAgile & ScrumSprint Capacity Planner

SpreadsheetAgile & ScrumFree

Sprint Capacity Planner

Each person’s available days after leave and meetings, focus factor and the story points the sprint can take.

Shown with sample data

Colour

Sprint Capacity Planner

Each person’s available days after leave and meetings, focus factor and the story points the sprint can take.

Team capacity (points)
38
Planned (points)
42
Load
111%
Above 100% is overcommitted
Focus hours
230
Point capacity by person
  • Marco9
  • Sam9
  • Lena7
  • Jordan6
  • Tom4
  • Asha3

How to use it

  1. 1Set sprint length, hours per day and focus factor on the Settings sheet.
  2. 2Enter days off and allocation for each person.
  3. 3Compare capacity with the points you plan to commit.
  4. 4Commit to less than capacity when the sprint has unknowns.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Plan a sprint on real capacity, not optimism. Enter working days in the sprint, each person’s time off and share of time on the team; the planner calculates available hours after meetings and a focus factor, and converts them to a point capacity from your recent velocity.

Who it’s for

  • Sprint planning
  • Sprints with holidays or part-time members
  • Explaining why less fits this sprint

What’s included

  • Team sheet: One row per team member.
  • Settings sheet: Sprint assumptions.

How to use it

  1. 1Set sprint length, hours per day and focus factor on the Settings sheet.
  2. 2Enter days off and allocation for each person.
  3. 3Compare capacity with the points you plan to commit.
  4. 4Commit to less than capacity when the sprint has unknowns.
Related searchessprint capacitycapacity planningagile planningvelocityscrum

Details

Format
Spreadsheet
Category
Agile & Scrum
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAgile & ScrumFree

Sprint Capacity Planner

Each person’s available days after leave and meetings, focus factor and the story points the sprint can take.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Agile & Scrum
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More agile & scrum templates

View all
Sprint Backlog4 sheets

Committed

44

Done

15

Sprint progress

34%

ABCD
1StoryTypeEpicAssignee
2As a user I can reset my password by emailStoryAccountsAna
3Show order history with filtersStoryOrdersBen
4Checkout fails on expired cardBugPaymentsChen
5Upgrade logging libraryTech debtPlatformDee
Backlog
SpreadsheetAgile & Scrum

Sprint Backlog

User stories with points and status, a live burndown against the ideal line, and velocity from past sprints.

10 min setupPreview
Bug Tracker2 sheets

Open bugs

5

Open critical

1

SLA breached

4

ABCD
1TitleSeverityEnvironmentSteps to reproduce
2Checkout fails when card has expiredCriticalProductionAdd item, pay with expired test card
3Order history filter ignores date rangeMajorProductionFilter orders by last 30 days
4Typo on pricing pageTrivialProductionOpen /pricing
5Search is slow on large cataloguesMajorProductionSearch with 10,000+ products
Bugs
SpreadsheetAgile & Scrum

Bug Tracker

Bugs with severity, environment, owner and status, plus age, SLA breaches and time to resolve.

10 min setupPreview

Sprint Retrospective: Sprint 14

Date: Date · Facilitator: Name · Team: Team name

Sprint facts

Committed pointsCompleted pointsBugs found
31243

Last retro's actions

  • •Action: Done / Not done

What went well

  • •Item
  • •Item
DocumentAgile & Scrum

Sprint Retrospective

Run a focused retro: what went well, what to improve and owned actions.

15 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ