Copy of Forecast model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHJKLMNOP
1
2
ProjectProject%
Complete
Points RemainingPoints Remaining (Cumulative)Weeks Remaining (@ Current Velocity)Estimated Weeks Until DeliveryEstimated CompletionEstimated DeploymentNotes
3
1Project 183%13.313.30.5-57.13/18/20143/22/2014Change data in shaded cells only - Non-shaded cells are formulas
4
2Project 241%38.051.32.0-56.13/25/20143/29/2014- Points Remaining (Cumulative) = Includes points from projects with higher priority
5
3Project 344%23.074.32.9-55.14/1/20144/5/2014- Weeks Remaining = Points Remaining / Current Velocity. Note this may be higher than Weeks until Delivery as velocity is modeled to increase every week.
6
4Project 40%33.6107.94.2-54.14/8/20144/12/2014
7
5Project 50%50.6158.56.2-52.14/22/20144/26/2014- Estimated Weeks Until Delivery = Days until Estimated Completion Date, divided by 7
8
6Project 60%20.7179.27.0-51.14/29/20145/3/2014- Estimated Completion = Friday of the week in which project is scheduled to be completed, based on current priority
9
74
10
84
11
94
12
104
13
14
RemainingTotalCompleteIn ProgressPointedUnpointed
15
PriorityProjectStoriesPointsStoriesPointsStoriesPointsStoriesPointsStoriesPointsStoriesPoints
16
1Project 1613.33479.32866.0511.012.3
17
2Project 21438.02464.01026.02.05.01233.00.0
18
3Project 31123.01841.0718.01.03.01020.00.0
19
4Project 41733.61733.61529.024.6
20
5Project 52250.62250.62250.6
21
6Project 6920.7920.7920.7
22
700.000.00.0
23
800.000.00.0
24
900.000.00.0
25
1000.000.00.0
26
79.0179.2124.0289.245.0110.042.093.034.078.2
27
28
WeekWeek OfProductive PairsWeekly ImprovementVs. Base WeekPoints Per PairWeekly Roadmap PointsCumulative Points
30
13/13/201448.025.625.6Average Points Per Story2.3
31
23/20/201445%105.0%8.426.952.5Starting Velocity per Pair8
32
33/27/201445%110.3%8.828.280.7Buffer / Non Roadmap Time20%
33
44/3/201445%115.8%9.329.6110.3
34
54/10/201440%115.8%9.329.6140.0
35
64/17/201440%115.8%9.329.6169.6
36
74/24/201440%115.8%9.329.6199.2
37
85/1/201440%115.8%9.329.6228.9
38
95/8/201440%115.8%9.329.6258.5
39
105/15/201440%115.8%9.329.6288.2
40
115/22/201440%115.8%9.329.6317.8
41
125/29/201440%115.8%9.329.6347.4
42
136/5/201440%115.8%9.329.6377.1
43
146/12/201440%115.8%9.329.6406.7
44
156/19/201440%115.8%9.329.6436.3
45
166/26/201440%115.8%9.329.6466.0
46
177/3/201440%115.8%9.329.6495.6
47
187/10/201440%115.8%9.329.6525.2
48
197/17/201440%115.8%9.329.6554.9
49
207/24/201440%115.8%9.329.6584.5
50
217/31/201440%115.8%9.329.6614.1
51
228/7/201440%115.8%9.329.6643.8
52
238/14/201440%115.8%9.329.6673.4
53
248/21/201440%115.8%9.329.6703.0
54
258/28/201440%115.8%9.329.6732.7
55
269/4/201440%115.8%9.329.6762.3
Loading...
Main menu