Weekly Velocity Calculations
Week Person/Group Number Of Hours In Our Work Week Time Spent On Project Per Week Velocity
    ( Hours ) ( Hours )  
1 Group 40 0 0
1 Philip 5 0 0
1 Ron 5 0 0
1 Aric 30 0 0
2 Group 50 6 0.12
2 Philip 15 4 0.266666667
2 Ron 5 0 0
2 Aric 30 2 0.066666667
3 Group 55 25.5 0.463636364
3 Philip 14 8 0.571428571
3 Ron 8 6 0.75
3 Aric 33 11.5 0.348484848
4 Group 40 18.45 0.46125
4 Philip 15 5 0.333333333
4 Ron 10 8.3 0.83
4 Aric 15 5.15 0.343333333
5 Group 59 23.75 0.402542373
5 Philip 6 2.5 0.416666667
5 Ron 15 14 0.933333333
5 Aric 38 7.25 0.190789474
6 Group 35 20 0.571428571
6 Philip 10 9 0.9
6 Ron 5 5 1
6 Aric 20 6 0.3
7 Group 22 7 0.318181818
7 Philip 12 5 0.416666667
7 Ron 0 0 #DIV/0!
7 Aric 10 2 0.2
8 Group 83 82.5 0.993975904
8 Philip 23 22.5 0.97826087
8 Ron 30 30 1
8 Aric 30 30 1
9 Group 48 33.5 0.697916667
9 Philip 16 13.5 0.84375
9 Ron 12 10 0.833333333
9 Aric 20 10 0.5
10 Group 19 0 0
10 Philip 14   0
10 Ron 5   0
10 Aric     #DIV/0!
11 Group 5 0 0
11 Philip     #DIV/0!
11 Ron 5   0
11 Aric     #DIV/0!
12 Group 5 0 0
12 Philip     #DIV/0!
12 Ron 5   0
12 Aric     #DIV/0!