ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
2
IterationUnits of Work CompletedAccumulated CompletedMVPTotal ScopeForecastLowHighInstructions
3
155550850Pre-requisitePre-requisite: Must have at least 3 iterations already completed.
4
21217550850
5
32138550850383838Step 1Update the Iteration column to reflect the current iteration, writting "Current" in the correct row
6
43068550850686868Step 2Enter the completed points for last iteration
7
52593550850939393Step 3DONT update anything else, everything is autocalculated. Go to to second tab to get the chart.
8
615108550850108108108
9
Current550850131124139OptionalOptional: replace Iteration numbers with dates
10
8550850155139170OptionalOptional: Update Total Scope if it has increased/decreased
11
9550850178155201OptionalOptional: Update MVP if it has increased/decreased
12
10550850201171232OptionalIf you believe the project will span beyond 39 sprints (1.5 years on 2w sprints), then you will need to update the Forecast and Chart tabs to extend the calculations
13
11550850225186263
14
12550850248202294Reference Only - Do not update
15
13550850271218325Last Iteration15
16
14550850295234356Last -125
17
15550850318249387Last -230
18
16550850341265418Average Completed (last 3 iterations)23
19
17550850365281449Standard Deviation (last 3 iterations)7.64
20
18550850388296480
21
19550850411312511
22
20550850435328542
23
21550850458343573
24
22550850481359604
25
23550850505375635
26
24550850528391665
27
25550850551406696
28
26550850575422727
29
27550850598438758
30
28550850621453789
31
29550850645469820
32
30550850668485851
33
31550850691500882
34
32550850715516913
35
33550850738532944
36
34550850761547975
37
355508507855631006
38
365508508085791037
39
375508508315951068
40
385508508556101099
41
395508508786261130
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