Scrum Sprint - Master v1.1 Updated 12th July 2012

	A	B
1	1. During Sprint Planning:	Enter Sprint start date,length, and any public holidays during the sprint
2		Enter team members and hours that they have available for work
3		Enter hours per person for Review/Retrospective, Grooming, and Sickness
4		Enter expected swim lane hours for BAU
5		This should now give you the available hours for your team, and 70% of those are what is available for team for estimating which stories will be accepted into the sprint
6
7	2. Once you've tasked out the stories that are going to be part of the sprint:	Record Story Numbers (Starting with a #) and descriptions (with a space before it) in the Stories tab, with task descriptions and estimations underneath the story name and number.
8		The only changes you should need to make on the review tab are the story points against the stories.
9
10	3. On a daily basis	Get the team to enter the hours worked, and hours remaining on the day that they work on the story on the Stories tab - This is supposed to show the state of play at the end of the day that you enter figures for. Note: The spreadsheet currently doesn't allow entering on hours on the day that the sprint starts (e.g. planning day), so any hours worked on that day, should be keyed in the following days column.
11
12	4. Review/Retrospective	Use the Review tab to identify stories that blew out from their initial estimates.
13
14	See Blog Post For Details On Spreadsheet:	http://www.littlebluemonkey.com/blog/online-scrum-tools-part-1-the-scrum-board/
15
16	If you wish to support the developer AND get a great iOS App, then consider purchasing Tooth Camp:	www.littlebluemonkey.com/apps/tooth_camp
17

	A	B	C	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	AR	AS	AT	AU
1	Sprint Backlog	Estimated Hours: 59 of 53	Assigned To	Mon 08/08		Tue 09/08		Wed 10/08		Thu 11/08		Fri 12/08		Mon 15/08		Tue 16/08		Wed 17/08		Thu 18/08		Work Fields:	Story	Hours Remaining	Hours Spent
2	Sprint Backlog	Estimated Hours: 59 of 53	Assigned To	Spent	Left	Spent	Left	Spent	Left	Spent	Left	Spent	Left	Spent	Left	Spent	Left	Spent	Left	Spent	Left

3	#001 - First Story																						#001	0	0
4	Code	1			1		1		1		1		1		1		1		1		1		#001	1	0
5	Review	2			2		2		2		2		2		2		2		2		2		#001	2	0
6	Test	3			3		3		3		3		3		3		3		3		3		#001	3	0
7																							#001	0	0
8																								0	0
9																								0	0
10																								0	0
11	#002 - Second Story																						#002	0	0
12	Task1	6			6		6		6		6		6		6		6		6		6		#002	6	0
13	Task2	6			6		6		6		6		6		6		6		6		6		#002	6	0
14	Task3	2			2		2		2		2		2		2		2		2		2		#002	2	0
15	Task4	3			3		3		3		3		3		3		3		3		3		#002	3	0
16																								0	0
17	#003 - 3rd Story																						#003	0	0
18	Testing	3			3		3		3		3		3		3		3		3		3		#003	3	0
19																								0	0
20	#004 - 4th Story																						#004	0	0
21	Development	5			5		5		5		5		5		5		5		5		5		#004	5	0
22	Peer Review	1			1		1		1		1		1		1		1		1		1		#004	1	0
23	Testing	2			2		2		2		2		2		2		2		2		2		#004	2	0
24																							#004	0	0
25																								0	0
26	#005 - 5th Story																						#005	0	0
27	Task1	4			4		4		4		4		4		4		4		4		4		#005	4	0
28	Task2	7			7		7		7		7		7		7		7		7		7		#005	7	0
29	Task3	5			5		5		5		5		5		5		5		5		5		#005	5	0
30	Task4	4			4		4		4		4		4		4		4		4		4		#005	4	0
31																								0	0
32	#006 - Story taken in during sprint																						#006	0	0
33	Dev	3			3		3		3		3		3		3		3		3		3		#006	3	0
34	Test	2			2		2		2		2		2		2		2		2		2		#006	2	0
35																								0	0
36																								0	0
37																								0	0
38	#Swimlane																						#swimlane	0	0
39	something swimmy			4																			#swimlane	0	4
40																								0	0
41																								0	0
42																								0	0
43																								0	0
44																								0	0
45																								0	0
46																								0	0
47																								0	0
48																								0	0
49																								0	0
50																								0	0
51																								0	0
52																								0	0
53																								0	0
54																								0	0
55																								0	0
56																								0	0
57																								0	0
58	#foundWork																						#foundwork	0	0
59	#00 Sample - Must have leading and space after number - Enter Estimate in the "Left" column on the date that it was added																						*#00	0	0
60																								0	0
61																								0	0
62																								0	0
63																								0	0
64																								0	0
65																								0	0
66																								0	0
67																								0	0
68																								0	0
69																								0	0
70																								0	0
71																								0	0
72																								0	0
73																								0	0
74																								0	0
75																								0	0
76																								0	0
77																								0	0
78																								0	0
79																								0	0
80																								0	0
81																								0	0
82																								0	0
83																								0	0
84																								0	0
85																								0	0
86																								0	0
87																								0	0
88																								0	0
89																								0	0
90																								0	0
91																								0	0
92																								0	0
93																								0	0
94																								0	0
95																								0	0
96																								0	0
97																								0	0
98																								0	0
99																								0	0
100																								0	0
101																								0	0
102																								0	0
103																								0	0
104																								0	0
105																								0	0
106																								0	0
107																								0	0
108																								0	0
109																								0	0
110																								0	0
111																								0	0
112																								0	0
113																								0	0
114																								0	0
115																								0	0
116																								0	0
117																								0	0
118																								0	0
119																								0	0
120																								0	0
121																								0	0
122																								0	0
123																								0	0
124																								0	0
125																								0	0
126																								0	0
127																								0	0
128																								0	0
129																								0	0
130																								0	0
131																								0	0
132																								0	0
133																								0	0
134																								0	0
135																								0	0
136																								0	0
137																								0	0
138																								0	0
139																								0	0
140																								0	0
141																								0	0
142																								0	0
143																								0	0
144																								0	0
145																								0	0
146																								0	0
147																								0	0
148																								0	0
149																								0	0
150																								0	0
151																								0	0
152																								0	0
153																								0	0
154																								0	0
155																								0	0
156																								0	0
157																								0	0
158																								0	0
159																								0	0
160																								0	0
161																								0	0
162																								0	0
163																								0	0
164																								0	0
165																								0	0
166																								0	0
167																								0	0
168																								0	0
169																								0	0
170																								0	0
171																								0	0
172																								0	0
173																								0	0
174																								0	0
175																								0	0
176																								0	0
177																								0	0
178																								0	0
179																								0	0
180																								0	0
181																								0	0
182																								0	0
183																								0	0
184																								0	0
185																								0	0
186																								0	0
187																								0	0
188																								0	0
189																								0	0
190																								0	0
191																								0	0
192																								0	0
193																								0	0
194																								0	0
195																								0	0
196																								0	0
197																								0	0
198																								0	0
199																								0	0
200	#																						#	0	0
201	Days for burndown chart			Mon	08/08/2011	Tue	09/08/2011	Wed	10/08/2011	Thu	11/08/2011	Fri	12/08/2011	Mon	15/08/2011	Tue	16/08/2011	Wed	17/08/2011	Thu	18/08/2011
202	Hours Remaining For Burndown			59		59		59		59		59		59		59		59		59
203	Total Hours Remaining			53		47		41		35		29		23		17		11		5
204	Swimlane Totals			4		4		4		4		4		4		4		4		4
205	Swimlane Projected			2.22		4.44		6.66		8.88		11.1		13.32		15.54		17.76		19.98

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2	Plan				Extra Stories				Extra Work		Total Hours		% Of Estimate	% Complete	Capitalisable	Release Comments (For Capex)
3	PBI	Description	Story Pts	Hours	Date	PBI	Story Pts	Hours	Hours	Tasks	Worked	To Complete Story	% Of Estimate	% Complete	Capitalisable	Release Comments (For Capex)
4	#001	- First Story	5	6								6.0	100%	0%
5	#002	- Second Story	3	17								17.0	100%	0%
6	#003	- 3rd Story	5	3								3.0	100%	0%
7	#004	- 4th Story	3	8								8.0	100%	0%
8	#005	- 5th Story	5	20								20.0	100%	0%
9		- Story taken in during sprint			17/08/2011	#006	3	5				5.0	100%	0%
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29	Totals		21	54			3	5	0	0	0	59		Capex Hours	0
30		% Of Available Hours		71.05%	0.00%			% Of Available Hours			0.00%	0.00%
31
32	Swimlane											4	20.00%
33
34
35
36

	B	C	D	E	F
1
2	#	Impediment	Action/Update	Status	ETA
3	1
4	2
5	3
6	4
7	5
8	6
9	7
10	8
11	9
12	10
13	11
14	12
15	13
16	14
17	15
18	16
19	17
20	18
21	19
22	20
23	21
24

	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Sprint Start Date	05/08/2011	Name	Initials		Total	Mon	Tue	Wed	Thu	Fri	Mon	Tue	Wed	Thu
2	Sprint Start Date	Fri	Dev 1			54	6	6	6	6	6	6	6	6	6
3	Sprint Length (weeks)	2	Dev 2			54	6	6	6	6	6	6	6	6	6
4	Sprint Length (weeks)	2	Tester			13.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5	1.5
5	Sprint Planning 1	05/08/2011
6	Sprint Planning 2	05/08/2011
7	Sprint Review	18/08/2011
8	Sprint Retrospective	18/08/2011
9	Public Holidays
10
11
12			Less		/ Person	Total
13
14	Days Available	9	Sprint Review & Retrospective		4	12
15			Backlog grooming		2.5	7.5
16			Sickness		2	6
17
18
19
20
21
22			#Swimlane	20.83%		20
23						76
24				70% Of Available		53
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Days During Sprint	Working Days	Days and names	Fri	05/08/2011	Mon	08/08/2011	Tue	09/08/2011	Wed	10/08/2011	Thu	11/08/2011	Fri	12/08/2011	Mon	15/08/2011	Tue	16/08/2011	Wed	17/08/2011	Thu	18/08/2011
2	05/08/2011	05/08/2011	Fri,05/08/2011,	Fri,05/08/2011,Mon,08/08/2011,Tue,09/08/2011,Wed,10/08/2011,Thu,11/08/2011,Fri,12/08/2011,Mon,15/08/2011,Tue,16/08/2011,Wed,17/08/2011,Thu,18/08/2011,
3	06/08/2011	08/08/2011	Mon,08/08/2011,
4	07/08/2011	09/08/2011	Tue,09/08/2011,
5	08/08/2011	10/08/2011	Wed,10/08/2011,
6	09/08/2011	11/08/2011	Thu,11/08/2011,
7	10/08/2011	12/08/2011	Fri,12/08/2011,					Burndown Chart	Fri	Mon	Tue	Wed	Thu	Fri	Mon	Tue	Wed	Thu
8	11/08/2011	15/08/2011	Mon,15/08/2011,					Burn Down	59	59	59	59	59	59	59	59	59	59
9	12/08/2011	16/08/2011	Tue,16/08/2011,					Project Burn Down	59	53	47	41	35	29	23	17	11	5
10	13/08/2011	17/08/2011	Wed,17/08/2011,					Burn Up	0	4	4	4	4	4	4	4	4	4
11	14/08/2011	18/08/2011	Thu,18/08/2011,					Projected Burn Up	0	2.22	4.44	6.66	8.88	11.1	13.32	15.54	17.76	19.98
12	15/08/2011
13	16/08/2011
14	17/08/2011
15	18/08/2011
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32	story	total_estimate	hours remaining	hours spent	Over/Under		Story List
33	#001	6	6	0		#001 - First Story	#001	- First Story
34	#002	17	17	0		#002 - Second Story	#002	- Second Story
35	#003	3	3	0		#003 - 3rd Story	#003	- 3rd Story
36	#004	8	8	0		#004 - 4th Story	#004	- 4th Story
37	#005	20	20	0		#005 - 5th Story	#005	- 5th Story
38	#006	5	5	0		#006 - Story taken in during sprint	#006	- Story taken in during sprint
39	#FOUNDWORK		0	0
40	#SWIMLANE		0	4	4
41	*#00		0	0
42	STORY
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

	A	B	C	D	E	F	G	H
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35