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
1.673.001.670.831.502.503.003.000.832.5020.502.052
22
1.503.001.670.835.003.000.831.671.505.0024.002.402.5
23
1.501.500.830.831.502.505.001.500.830.8316.831.681.5
24
0.830.830.831.501.675.001.671.500.830.8315.501.551.5
25
2.500.830.830.835.001.502.502.501.501.5019.501.952
26
5.003.001.671.501.501.670.831.503.005.0024.672.472.5
27
1.500.830.835.000.831.503.001.670.835.0021.002.102
28
1.503.005.001.501.672.500.831.501.502.5021.502.152
29
0.835.001.672.501.502.500.832.503.001.5021.832.182
30
1.501.503.001.500.835.005.005.001.670.8325.832.582.5
31
1.671.505.005.005.001.505.001.502.505.0033.673.373.5
32
3.003.001.675.003.000.835.000.831.502.5026.332.632.5
33
0.831.505.003.002.501.673.003.000.832.5023.832.382.5
34
5.001.671.672.505.003.005.000.833.003.0030.673.073
35
0.831.671.673.003.000.831.501.671.500.8316.501.651.5
36
5.001.670.835.001.675.005.003.005.001.6733.833.383.5
37
1.675.002.503.003.002.501.501.671.671.5024.002.402.5
38
5.001.675.002.501.670.832.505.000.835.0030.003.003
39
1.671.670.835.001.675.003.001.670.835.0026.332.632.5
40
0.835.002.501.502.503.001.500.830.833.0021.502.152
41
2.502.500.833.001.502.502.500.832.500.8319.501.952
42
1.672.505.005.005.001.501.500.833.000.8326.832.682.5
43
1.501.500.833.001.670.833.002.501.671.6718.171.822
44
5.002.503.005.001.500.833.001.670.833.0026.332.632.5
45
5.001.501.501.673.001.673.000.831.671.6721.502.152
46
2.505.000.832.502.501.671.505.005.001.5028.002.803
47
3.003.000.831.505.001.673.001.501.503.0024.002.402.5
48
1.672.501.503.005.000.831.675.005.000.8327.002.702.5
49
0.830.833.002.502.501.500.831.501.505.0020.002.002
50
1.503.003.002.500.830.830.831.502.503.0019.501.952
51
1.672.500.830.830.831.672.502.503.001.6718.001.802
52
3.001.505.005.003.001.670.832.502.505.0030.003.003
53
5.005.002.505.000.830.831.675.001.671.5029.002.903
54
1.501.501.501.501.501.500.831.670.830.8313.171.321.5
55
0.835.001.500.833.000.830.833.001.500.8318.171.822
56
2.501.500.831.671.671.670.835.000.832.5019.001.902
57
2.502.505.001.500.832.501.671.673.003.0024.172.422.5
58
3.001.675.001.672.501.673.002.501.671.5024.172.422.5
59
1.501.501.501.675.001.502.500.832.505.0023.502.352.5
60
1.503.001.505.001.671.670.832.500.831.6720.172.022
61
3.000.833.001.671.670.830.830.835.001.5019.171.922
62
2.501.501.671.501.672.501.501.672.501.6718.671.872
63
2.502.501.672.502.505.001.501.673.003.0025.832.582.5
64
5.003.003.003.000.831.501.672.502.503.0026.002.602.5
65
1.505.001.671.673.005.003.001.671.502.5026.502.652.5
66
2.501.671.671.501.502.505.005.002.505.0028.832.883
67
3.001.503.000.831.500.831.505.005.002.5024.672.472.5
68
3.001.505.001.675.001.670.833.001.505.0028.172.823
69
1.505.005.001.503.001.500.832.501.672.5025.002.502.5
70
0.831.671.501.670.831.501.505.000.835.0020.332.032
71
0.835.000.833.003.001.670.835.000.835.0026.002.602.5
72
1.500.831.503.001.500.833.003.002.503.0020.672.072
73
3.005.000.835.003.003.005.003.000.833.0031.673.173
74
3.001.501.672.501.671.505.001.502.501.5022.332.232
75
5.000.835.000.833.003.003.000.830.831.5023.832.382.5
76
1.505.001.503.001.670.831.500.832.503.0021.332.132
77
0.832.503.002.500.831.671.671.670.830.8316.331.631.5
78
0.831.671.671.671.501.501.501.671.671.5015.171.521.5
79
1.671.675.000.830.831.675.001.673.001.6723.002.302.5
80
3.002.502.503.005.003.000.831.671.675.0028.172.823
81
1.673.005.000.830.832.501.500.832.501.5020.172.022
82
0.831.501.500.835.001.671.505.001.675.0024.502.452.5
83
2.503.000.830.830.831.673.000.835.000.8319.331.932
84
1.505.003.001.670.830.833.001.671.673.0022.172.222
85
5.005.000.831.503.000.831.670.835.001.6725.332.532.5
86
3.003.001.502.502.500.830.835.002.501.5023.172.322.5
87
3.005.003.001.503.002.505.001.671.671.6728.002.803
88
5.000.832.501.670.831.675.003.002.500.8323.832.382.5
89
0.835.002.501.671.670.832.500.831.670.8318.331.832
90
2.505.000.830.832.502.501.500.831.671.5019.671.972
91
3.001.675.003.001.505.002.502.500.830.8325.832.582.5
92
1.505.001.671.675.003.001.670.832.501.6724.502.452.5
93
1.672.503.002.502.501.505.001.672.505.0027.832.783
94
3.002.500.832.502.501.505.003.000.832.5024.172.422.5
95
1.505.005.005.003.000.831.673.001.671.6728.332.833
96
1.503.001.670.830.833.001.671.675.001.6720.832.082
97
1.671.671.672.505.000.830.832.505.001.6723.332.332.5
98
5.005.001.671.502.503.001.505.001.672.5029.332.933
99
0.831.500.835.003.003.003.001.673.000.8322.672.272.5
100
1.672.501.671.670.831.672.501.670.833.0018.001.802