ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
2
SprintWork Days in sprintStories
Completed
Program FocusTo get started on your own forecast, choose :

"Make a copy..."

from the File menu.
3
1933
<<< Start by adding your Sprint data
here. The number of days in each
sprint and the number of stories
completed in each. Edit WHITE
cells only. 5 sprints is enough if it's
all you have.

If ZERO stories are completed in
any sprint, the sheet defaults to
ONE, giving us a conservative,
but calculable Takt for the sprint.
4
21066
5
3101212
6
4966
7
51044
8
61022
9
7
10
8Project Focus<<< Adjust this % if it's likely
the team will not get to
focus full time on the
project. Leave the
Sprint data the same...
11
9100%
12
10
13
14
LOOK AT WHAT'S HAPPENING BELOW HERE, BUT DON'T EDIT ANY OF IT
15
16
Cycle Time Values for sprints above (days)
17
3.001.670.831.502.505.00
18
19
Extrapolation from random selection of values (x1000)
20
ABCDEFGHIJDays TotalTakt for this SampleRounded to half-day
21
0.832.502.500.831.501.673.000.831.675.0020.332.032
22
1.501.673.003.000.831.501.502.500.830.8317.171.721.5
23
2.505.003.002.503.000.835.001.672.503.0029.002.903
24
0.832.501.671.670.830.832.500.831.505.0018.171.822
25
1.503.003.003.001.671.501.505.001.505.0026.672.672.5
26
5.001.670.831.675.002.501.500.835.002.5026.502.652.5
27
1.502.501.673.005.003.001.502.502.503.0026.172.622.5
28
1.501.500.835.001.671.501.670.833.002.5020.002.002
29
1.675.001.501.670.832.501.670.831.500.8318.001.802
30
2.503.001.672.502.501.503.000.831.675.0024.172.422.5
31
2.501.500.831.500.831.671.671.501.502.5016.001.601.5
32
1.671.672.501.675.005.002.501.672.501.5025.672.572.5
33
5.003.001.672.501.673.002.503.002.501.6726.502.652.5
34
1.505.002.503.001.503.001.675.003.005.0031.173.123
35
0.830.833.003.001.671.500.835.002.503.0022.172.222
36
1.501.505.005.000.832.502.502.502.505.0028.832.883
37
3.002.502.503.000.833.001.505.003.005.0029.332.933
38
5.000.831.673.005.005.001.673.001.675.0031.833.183
39
1.671.500.832.501.670.830.832.505.001.5018.831.882
40
1.675.001.673.005.000.835.000.831.501.6726.172.622.5
41
0.832.501.500.833.000.833.005.000.831.5019.831.982
42
1.503.001.501.503.001.671.501.505.001.6721.832.182
43
2.501.502.505.002.505.001.673.001.501.5026.672.672.5
44
1.503.001.672.501.671.505.000.833.000.8321.502.152
45
3.005.001.505.001.500.835.002.501.670.8326.832.682.5
46
3.002.501.502.502.501.500.835.000.832.5022.672.272.5
47
1.502.502.500.835.003.003.005.001.500.8325.672.572.5
48
0.833.000.831.670.831.670.832.505.000.8318.001.802
49
1.675.001.671.670.833.002.502.505.002.5026.332.632.5
50
1.675.000.831.672.502.500.831.503.001.5021.002.102
51
5.002.502.502.502.505.001.670.832.505.0030.003.003
52
1.501.672.505.000.830.833.001.503.005.0024.832.482.5
53
0.830.833.005.002.500.832.503.001.501.5021.502.152
54
1.501.500.832.500.831.503.002.501.501.5017.171.721.5
55
1.675.002.501.672.502.505.003.003.001.6728.502.853
56
0.835.003.001.673.003.003.001.671.671.6724.502.452.5
57
5.003.001.500.831.501.671.501.501.672.5020.672.072
58
5.000.830.830.831.671.500.830.830.831.5014.671.471.5
59
5.000.833.001.670.832.501.500.835.001.6722.832.282.5
60
3.002.502.502.501.671.670.831.501.503.0020.672.072
61
1.502.503.001.671.673.003.001.673.002.5023.502.352.5
62
2.502.505.001.503.001.670.833.003.003.0026.002.602.5
63
3.005.001.505.001.671.672.500.835.000.8327.002.702.5
64
3.003.005.005.000.833.005.001.505.002.5033.833.383.5
65
1.501.675.001.670.835.003.005.003.002.5029.172.923
66
2.501.505.002.505.002.505.000.831.672.5029.002.903
67
1.671.503.002.505.000.831.670.832.503.0022.502.252.5
68
1.675.000.835.000.831.502.501.673.005.0027.002.702.5
69
1.503.005.001.505.003.005.003.001.671.5030.173.023
70
5.001.503.001.503.002.505.005.005.000.8332.333.233
71
1.671.503.001.671.500.831.670.835.000.8318.501.852
72
0.831.502.500.830.835.000.831.501.501.5016.831.681.5
73
1.503.003.001.501.671.502.503.002.502.5022.672.272.5
74
1.503.005.000.832.501.500.833.001.503.0022.672.272.5
75
1.671.671.672.501.501.670.832.503.002.5019.501.952
76
5.005.003.005.001.501.671.505.002.500.8331.003.103
77
5.001.502.505.001.673.001.672.505.005.0032.833.283.5
78
1.675.001.505.005.000.833.000.832.503.0028.332.833
79
3.002.505.002.503.000.835.000.833.001.5027.172.722.5
80
2.503.003.001.501.501.673.000.830.831.6719.501.952
81
1.671.670.831.502.503.000.830.831.505.0019.331.932
82
1.670.830.835.001.670.830.833.002.500.8318.001.802
83
0.835.002.501.673.002.503.002.501.675.0027.672.773
84
2.503.000.832.503.005.000.831.505.005.0029.172.923
85
1.675.005.002.502.503.001.670.831.672.5026.332.632.5
86
2.502.505.001.675.003.005.003.002.503.0033.173.323.5
87
5.005.003.005.003.001.505.001.501.503.0033.503.353.5
88
0.832.501.673.000.835.001.673.001.672.5022.672.272.5
89
0.830.830.833.001.675.002.500.833.001.5020.002.002
90
1.673.003.001.673.001.671.500.835.001.6723.002.302.5
91
3.003.000.831.671.501.671.501.501.500.8317.001.701.5
92
0.831.672.505.001.505.001.670.831.672.5023.172.322.5
93
0.830.830.831.670.830.832.502.501.672.5015.001.501.5
94
5.003.005.003.000.831.670.831.671.671.5024.172.422.5
95
1.673.001.501.505.001.500.830.833.001.6720.502.052
96
2.505.002.501.675.001.500.835.001.502.5028.002.803
97
2.501.501.502.505.001.670.833.001.671.5021.672.172
98
1.500.831.502.503.002.503.002.502.502.5022.332.232
99
1.500.832.501.675.001.500.832.502.501.5020.332.032
100
2.502.501.501.672.501.671.675.000.831.6721.502.152