3. Burndown Chart Template.xlsx

	A	B	C	E	G	I
1	Burndown Chart Template
2
3	Velocity = Total Story Points Delivered over a Sprint
4	The example below illustrates a basic example of a 4 Sprint Project. Being the Sprints in this case 2 weeks long this is a 2 month project.
5	It has 15 user stories in total. I've used the name "User Story #" in the essence of time, but you would of course write the actual user story using the format described in the other tab
6	Assumption: The team discards the user stories which aren't delivered since after discussion they don't consider required any longer. Keep in mind, that if they were required they would be added to another Sprint
7
8
9	Sprint 1		Story Points
10	User Story 6		3		Note: this user story wasn't delivered in Sprint 1 since the team didn't have time to complete it
11	User Story 11		3
12	User Story 2		5
13	User Story 8		1
14		Total	12	Velocity Sprint 1	9
15
16	Sprint 2
17	User Story 1		5
18	User Story 13		1
19	User Story 5		1
20		Total	7	Velocity Sprint 2	7
21
22	Sprint 3
23	User Story 3		5
24	User Story 4		3
25	User Story 15		1
26		Total	9	Velocity Sprint 3	9
27
28	Sprint 4
29	User Story 9		3		Note: this user story wasn't delivered in Sprint 4 since the team didn't have time to complete it
30	User Story 7		5
31	User Story 14		3
32	User Story 10		1
33	User Story 12		1
34		Total	13	Velocity Sprint 4	10
35
36
37	Total Story Points		41	Average Velocity	9	Which means that on average the team is delivering 9 story points per Sprint. This is known as the project's Velocity
38						This is an indication of execution that allows for future planning and workload management.
39
40
41	Traditional
42	Burndown Chart
43	Sprint	Remaining Story Points
44	1	41
45	2	32
46	3	25
47	4	16
48	5	6
49
50
51
52
53
54
55
56
57
58
59
60
61
62	Another option
63	Burndown Chart
64	Sprint	Remaining Story Points	Story Points Delivered
65	1	41	9
66	2	32	7
67	3	25	9
68	4	16	10
69	5	6	0
70
71
72
73
74
75
76
77
78
79
80
81
82
83	Another option
84	Burndown Chart
85	Sprint	Remaining Story Points	Story Points Delivered
86	1	41	9
87	2	32	7
88	3	25	9
89	4	16	10
90	5	6	0
91
92
93
94
95
96
97
98
99
100