Iteration spreadsheet

Document Sample
Iteration spreadsheet Powered By Docstoc
					Client                    Example Co
Project                   New website
Project Manager           Cathryn Symons
Iteration number                          4
Iteration start date              14-Jan-08
Iteration end date                25-Jan-08

Days in iteration                        10
Today                             27-Feb-12

Code complete by                  23-Jan-08
Client demo                       25-Jan-08

Iteration budget days                    25
Iteration budget hours                  200
Planned staff available                 189
Planned work                            152
Resource utilisation                   80%




Do Not Change
Status
Not Started
In Progress
Complete
Not required
Deferred

Idealized Line
day:                                         0   10
remaining                                  152    0
The name of the client company
The name of the project
Your name
Do a separate spreadsheet for each iteration
These are worked out from the iteration tasks list. Don't change them here




Even if you are doing continuous integration well, its is still worth setting a date for code completion before the end of the iteration


Enter your budget in days



This is overall Planned Work / Staff available. See Staff sheet for individual utilisation


Enter data in green cells only
Instructions
1. In iteration tasks, set up dates and columns
2. In Staff, set up the list of staff and their availability
3. In Staff, set up a max allocation %
4. Create the tasks, in Iteration tasks.

5. Once the project is underway, change only the numbers in the column for the current day in iteration
tasks, coloured lavendar. Other information will track.
e the end of the iteration
                                                      Iteration Burndown

                            160


                            140


                            120
Estimated Hours Remaining




                            100


                             80


                             60


                             40


                             20


                              0
                                  0   1   2   3   4         5         6    7   8   9   10

                                                                Day
Today         27-Feb                                                                  Estimated hours of work remaining
ID            Task Description                Staff    notes   Due      Status        Iteration    14-Jan-08 15-Jan-08 16-Jan-08 17-Jan-08 18-Jan-08 21-Jan-08 22-Jan-08 23-Jan-08 24-Jan-08 25-Jan-08
                                                                                      start
                                                                                      0            1          2         3         4         5         6         7         8         9         10
          1   Master page                     Martha           17-Jan   Not Started             16         16        16        16        16        16        16        16        16        16          16
          2   Home page                       Rose             23-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          3   Search page                     Donna            23-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          4   Results page                    Martha           23-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          5   Search component                Rose             18-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          6   Data import                     Donna            23-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          7   PL/SQL routines - part 1        Martha           18-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
          8   PL/SQL routine - part 2         Rose             23-Jan   Not Started          16         16        16        16         16        16         16        16         16        16         16
          9   Results page print              Martha           23-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
         10   Search page print               Donna            23-Jan   Not Started          16         16        16        16         16        16         16        16         16        16         16
              Tasks for every iteration
        100   Client demonstration            Rose             14-Jan   Not Started           4          4         4         4          4         4          4         4          4         4          4
        101   Iteration planning              Rose             15-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
        102   Iteration planning              Martha           15-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
        104   Iteration planning              Donna            15-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
        105   Integration,testing and setup   Rose             25-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8
        106   Integration,testing and setup   Martha           25-Jan   Not Started           4          4         4         4          4         4          4         4          4         4          4
        108   Integration,testing and setup   Donna            25-Jan   Not Started           8          8         8         8          8         8          8         8          8         8          8

              Total work to do                                                             152        152       152       152        152       152        152       152        152       152         152
              Total time available                                                         189        189       168       147        126       119         98        77         56        35          21

              Total work to do per staff
              Rose                                                                          52         52        52         52        52         52        52        52         52        52          52
              Martha                                                                        52         52        52         52        52         52        52        52         52        52          52
              Donna                                                                         48         48        48         48        48         48        48        48         48        48          48
Staff Availability
Name                 Total work    Total Hours % allocated   14-Jan-08   15-Jan-08   16-Jan-08   17-Jan-08 18-Jan-08 21-Jan-08 22-Jan-08 23-Jan-08 24-Jan-08 25-Jan-08
                                                                     1           2           3           4         5         6         7         8         9        10
Rose                          52            70      74.29%           7           7           7           7         7         7         7         7         7         7
Martha                        52            56      92.86%           7           7           7           0         7         7         7         7         0         7
Donna                         48            63      76.19%           7           7           7           0         7         7         7         7         7         7

Total today                                                        21          21          21           7        21         21       21        21        14        21
Total remaining                                                   189         168         147         126       119         98       77        56        35        21
Work to do                                                        152         152         152         152       152        152      152       152       152       152
Burndown                                                                        0           0           0         0          0        0         0         0         0
% burndown                                                                    0%          0%          0%        0%         0%       0%        0%        0%        0%
Max allocation %            80%

Staff Work to do
Rose                                                               52          52          52          52        52         52        52       52        52        52
Martha                                                             52          52          52          52        52         52        52       52        52        52
Donna                                                              48          48          48          48        48         48        48       48        48        48

Staff burndown
Rose                                                                            0           0           0          0         0         0         0        0         0
Martha                                                                          0           0           0          0         0         0         0        0         0
Donna                                                                           0           0           0          0         0         0         0        0         0

Staff % burndown
Rose                                                                           0%          0%          0%        0%        0%        0%        0%        0%        0%
Martha                                                                         0%          0%          0%        0%        0%        0%        0%        0%        0%
Donna                                                                          0%          0%          0%        0%        0%        0%        0%        0%        0%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/27/2012
language:
pages:6