| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | IMPORTANT: MAKE A COPY OF THIS SPREADSHEET TO BEGIN USING :) | |||||||||||||||||||||||||||
2 | INSTRUCTIONS | Full capacity | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | |||||||||||||||||||||
3 | Put the developer's full capacity for story points for a sprint in column B. | Developer 1 | 4 | 0.5 | 0.5 | 0.75 | 0.75 | 1 | ||||||||||||||||||||
4 | Put multipliers for a given developer for a given sprint in columns C-G. For example, if you know that someone is going to be out for half of the sprint, put 0.5. | Developer 2 | 4 | 0.5 | 0.5 | 0.5 | 0.75 | 0.75 | ||||||||||||||||||||
5 | Add as many columns as you need for the time period you're planning. | Developer 3 | 5 | 1 | 0.75 | 1 | 1 | 1 | ||||||||||||||||||||
6 | Developer 4 | 5 | 0 | 0 | 0 | 0.5 | 1 | |||||||||||||||||||||
7 | Developer 5 | 3 | 0.25 | 0.25 | 0.75 | 1 | 1 | |||||||||||||||||||||
8 | Numbers above this line are for calculations; focus below this line for actual plans. | |||||||||||||||||||||||||||
9 | Full capacity | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | ||||||||||||||||||||||
10 | If you do the above steps correctly, this section will now show you the total number of points a given developer will have in a sprint, adjusted for any hits to their velocity you inputted above (like vacation, help with recruiting, company retreat, etc.) | Developer 1 | 4 | 2 | 2 | 3 | 3 | 4 | ||||||||||||||||||||
11 | Developer 2 | 4 | 2 | 2 | 2 | 3 | 3 | |||||||||||||||||||||
12 | Developer 3 | 5 | 5 | 3.75 | 5 | 5 | 5 | |||||||||||||||||||||
13 | Developer 4 | 5 | 0 | 0 | 0 | 2.5 | 5 | |||||||||||||||||||||
14 | Developer 5 | 3 | 0.75 | 0.75 | 2.25 | 3 | 3 | |||||||||||||||||||||
15 | Total | 21 | 9.75 | 8.5 | 12.25 | 16.5 | 20 | |||||||||||||||||||||
16 | ||||||||||||||||||||||||||||
17 | Now that you know your team's velocity, this section is all about dividing your major projects up over your sprints. | Project | Planning Period Totals | Sprint 1 | Sprint 2 | Sprint 3 | Sprint 4 | Sprint 5 | Totals | Difference from plans | ||||||||||||||||||
18 | Use this row to make note of anything you have to do *every* sprint. For us, these are thigns like 1 pt of a production issue, 1 pt for selenium testing, etc. Add up the total number of points you'll spend on these things each sprint, and put each sprint's total in D17-H17. | Spoken for 1 pt PROD 1 pt Selenium/Regression Testing Urgent support issues | 19 | 4 | 4 | 3 | 4 | 4 | 19 | 0 | ||||||||||||||||||
19 | This row now shoes you the points you have each sprint to work on other things. Hooray! | Available pts | 48 | 5.75 | 4.5 | 9.25 | 12.5 | 16 | n/a | n/a | ||||||||||||||||||
20 | Use these rows to plan out how many points you'll spend on each project each sprint. First, put the total point estimate for a project in column C to help you remember the total. Then, spread that number of points out in columns D-H in a way that makes sense for your team (for example, if you've broken down the project into stories, you might put the point values for various stories that you want to accomplish each sprint in columns D-H). | Project 1 | 7.5 | 0 | 3 | 0 | 4.5 | 0 | 7.5 | 0 | ||||||||||||||||||
21 | Project 2 | 21.5 | 8 | 4.5 | 0 | 5 | 4 | 21.5 | 0 | |||||||||||||||||||
22 | Project 3 | 38.5 | 0 | 0 | 2 | 2 | 6 | 10 | -28.5 | |||||||||||||||||||
23 | Project 4 | 35 | 0 | 1 | 3.125 | 2 | 7 | 13.125 | -21.875 | |||||||||||||||||||
24 | Column I now shows you the total # of points you'll be spending for a given project over the whole planned period. If that total differs from the original estimate, you'll see that difference in column J. If column J is negative, you're in trouble - you're not going to complete the project in the alotted time. | Bugs | 7.5 | 0 | 0 | 0 | 2.5 | 5 | 7.5 | 0 | ||||||||||||||||||
25 | This row shows you the total points you'll spend during each sprint. | Total | 129 | 12 | 12.5 | 8.125 | 20 | 26 | 78.625 | -50.375 | ||||||||||||||||||
26 | This row shows you if you'll be spending more or less points in a given sprint than your team's capacity. If this row is negative, you're overcommitted. | Difference from available points | -41 | -2.25 | -4 | 4.125 | -3.5 | -6 | ||||||||||||||||||||
27 | ||||||||||||||||||||||||||||
28 | This section shows you how much of your actual effort over the course of the planned period goes to various projects (assuming you stick to the points allocated to a given project for a given sprint in C17:H23. | Project | % of Cumulative Velocity | |||||||||||||||||||||||||
29 | Spoken for | 24.17% | ||||||||||||||||||||||||||
30 | Project 1 | 9.54% | ||||||||||||||||||||||||||
31 | Project 2 | 27.34% | ||||||||||||||||||||||||||
32 | Project 3 | 12.72% | ||||||||||||||||||||||||||
33 | Project 4 | 16.69% | ||||||||||||||||||||||||||
34 | Bugs | 9.54% | ||||||||||||||||||||||||||
35 | Total | 100.00% | ||||||||||||||||||||||||||