PlanningSpreadsheet · Excel & Google Sheets
Capacity planner
Team capacity per iteration, including time off, in normalized points.
| Team member | Role | Iteration 1 days | Iteration 2 days | Iteration 3 days | Iteration 4 days | Total days | Capacity (points) |
|---|---|---|---|---|---|---|---|
| Alex | Developer | 10 | 8 | 10 | 10 | auto | auto |
| Sam | Tester | 10 | 10 | 6 | 10 | auto | auto |
| auto | auto | ||||||
| auto | auto |
Preview with sample data. Columns marked “auto” are calculated by formula in the download.
What’s inside
- One row per team member
- Days available per iteration
- Normalized points (8 per full-time person per 10 days)
- Team totals
How to use it
- 1List everyone on the team
- 2Subtract holidays and time off
- 3Let the sheet convert days to points
- 4Use the totals in PI and iteration planning