Scrum: Capacity Planning Template

	A	B	C	D	G	H	M
1
2					Hi,
3					Welcome to the Scrum Capacity Planning sheet.
4					Below you can find an explanation of it's structure:
5					The "Example: Sprint Week 02-03" tab consists of example data,
6					that explains the functionality and how to use it.		Scroll down to the
7					The "Template (pls duplicate)" tab is the empty version.		documentation
8					Feel free to adjust and use it according to your needs and rhythms.
9					The "Roles/Skills" tab allows you to add the different skills or
10					roles of your team members.
11					Please reach out to me for feedback via:
12					Linkedin:	https://www.linkedin.com/in/christianstrunk/
13					Mail:	contact@christianstrunk.com
14
15					Best,
16					Christian Strunk
17	(Cropped) Photo by Olga Guryanova on Unsplash
18					Disclaimer: This sheet is not a guarantee to finish sprints.
19					You can use it as an inspiration, template, or something to build upon :-)
20					Google “Scrum Capacity Planning” and you’ll find more examples.
21
22		Documentation of "Example: Sprint Week 02-03":
23
24		Cell:	Name:	Explanation:
25		B3	Team Members	Add your team members below. Fee free to adjust the rows to your personal needs and cycles.
26		C3	Roles/Skills	Chose the role of your colleague. This will be reflected in the pie-chart below. You can add more roles in the "Roles"-Tab. Do not forget to adjust/check the "data validation".
27		T2:U3	Availablity meeting	This is the sum of the row minus the sum of the hours of all team meetings. In case the team member is not working (0 h) on that day, the hours of team meetings for that particular day will be added again.
28		V2:W3	Availablity buffer	This is R2/R3 minus the buffer (calculated: 1-"buffer, Example 1-"10%" = 90%).
29		D2/E2	Working days	Enter the number of working days per sprint.
30		D3	Hours per day	Enter the hours per day per person.
31		E3	Allocation	This explains how much a person contributes to a sprint. Calculation: ("Availablity minus buffer") devided by ("Hours per day" multiplied with "Working days" minus "Time in meetings")
32		B13	Buffer	If you're already tracking/subtracting additional work on team-member-level you can set the buffer (T11) to 0%. Some team members work on other projects, chapers or guilds and therefore can't contribute to 100%.
33		F4-S12	Hours	Enter the hours a person is available per day. Conditional formatting: 0-1 = red (because the person will not really work/be productive on that day) 2-6= yellow (person works but not the full day) 7-8= green (person works fully dedicated on the sprint) Feel free to adjust it to your own/team preferences.
34		B17	Team Meetings	You can rename/change the team meetings according to your ceremonies.
35		B25	One-on-Ones	If every team member has 1:1s on different days you can just add them flat in one of the fields.
36		F18	Time	0.25 = 15 minutes
37		B28	Available hours: Roles & Skills	This chart can help you beforehand to better know what to prioritize based on the available roles/skills.
38		J28	Available hours: Team members	Here you can see how much each person will contribute to the sprint. In case some people have specific knowledge/are needed you should plan how share the knowledge or handover responsibilities and plan accordingly.
39		Y2	Roles/Skill Distribution	This is a list of all roles from the Tab "Roles/Skills". You can remove or add more roles/skills. Don't forget to adjust the data validation for: C4-C10 & W4-W10, as well as adding new rows in case you add more roles/skills + new columns if you add more team members.
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100