Spreadsheet: 135286d1325896788-match-values-in-2-columns-and-return-the-sum-im-data
Sheet: Niku

As at 06/1/12
Resource | Task Phase | Task Activity | Task Name | Metrics | Week | TOTALS | 03/10/2011 | 10/10/2011 | 17/10/2011 | 24/10/2011 | 31/10/2011 | 07/11/2011 | 14/11/2011 | 21/11/2011 | 28/11/2011 | 05/12/2011 | 12/12/2011 | 19/12/2011 | 26/12/2011
B, Adam | CS Implementation Management | CS Implementation Management | Meetings | Actual Hours |  | 9.75 | 8.75 | 1
B, Adam | CS Implementation Management | CS Implementation Management | Operational | Actual Hours |  | 9 | 2 | 7
B, Adam | GEM Resources | GEM Resources | GEM Resources | Actual Hours |  | 0 |  |  |  |  |  |  |  | 1 | 0.5 | 0.25
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Co-Leading | Actual Hours |  | 8.5 |  | 5 |  | 2 | 1.5 |  |  | 0.3 | 1.25 | 1.25 | 1 | 1
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | External Consultancy | Actual Hours |  | 8.75 | 7.5 |  | 0.75 | 0.5 |  |  |  |  |  |  | 2
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Impact Assessment & Problem Mgt Reviews | Actual Hours |  | 1.25 |  |  |  | 0.75 | 0.5 |  |  |  | 0.25
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Internal Consultancy | Actual Hours |  | 9.5 |  | 1 | 5.5 |  | 3
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Knowledge Management | Actual Hours |  | 0 |  |  |  |  |  |  |  | 1.5 | 2.5 | 1
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Multi Regional Liaison & Consultancy | Actual Hours |  | 0.5 |  |  |  |  | 0.5 |  |  |  |  | 1
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Operational | Actual Hours |  | 30.5 |  |  | 7.5 | 10 | 13 |  |  | 13.5 | 15 | 19 | 15 | 17
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Surgeries | Actual Hours |  | 1.25 |  | 0.25 |  | 1 |  |  |  | 0.25 | 0.25
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Training Creation | Actual Hours |  | 0.25 | 0.25
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Training Delivery | Actual Hours |  | 5.25 | 2.75 | 2.5 |  |  |  |  |  |  |  |  |  | 0.25
B, Adam | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | VECSS Support | Actual Hours |  | 54.5 | 7 | 11 | 12 | 15.5 | 9 |  |  | 9.5 | 15 | 11 | 14 | 12
s, [NAME] | CS Implementation Management | CS Implementation Management | Meetings | Actual Hours |  | 6.5 |  |  | 1.5 | 5
s, [NAME] | CS Implementation Management | CS Implementation Management | Training | Actual Hours |  | 0.5 |  | 0.5 |  |  |  |  |  | 4
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Administrative Activities | Actual Hours |  | 0 |  |  |  |  |  |  |  |  |  |  | 3
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Co-Leading | Actual Hours |  | 2 |  | 1.5 | 0.5
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Impact Assessment & Problem Mgt Reviews | Actual Hours |  | 4 |  | 1.5 | 2.5 |  |  |  |  |  |  | 0.5
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Internal Consultancy | Actual Hours |  | 2 |  |  | 2
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Knowledge Management | Actual Hours |  | 1 |  |  |  | 1
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Mobile Implementations | Actual Hours |  | 13 |  |  |  | 5 | 1 | 4.5 | 2.5 |  | 3 | 3 | 1.5 | 3
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Multi Regional Liaison & Consultancy | Actual Hours |  | 0 |  |  |  |  |  |  |  |  | 1
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Operational | Actual Hours |  | 15.5 |  | 4 |  |  | 9 | 1.5 | 1 | 2 | 4.5 | 10.5 | 3.5 | 7.5 | 7
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | People Management | Actual Hours |  | 2 |  | 0.5 | 1 |  | 0.5
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Surgeries | Actual Hours |  | 25 | 6 | 3.5 | 4 | 4 | 2.5 | 5 |  |  | 2.5 | 1 | 3 | 2
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Training Creation | Actual Hours |  | 6 |  |  |  | 6
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Training Delivery | Actual Hours |  | 3.5 |  |  |  |  | 3.5
s, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | VECSS Support | Actual Hours |  | 7 |  |  |  |  | 1 | 2.5 | 3.5 | 0.5
m, [NAME] | CS Service Implementation | CS Service Implementation | Double checking/Approving Packets | Actual Hours |  | 18.75 | 5.75 | 2.25 | 3.5 | 2.75 | 3 | 0.5 | 1 | 0.75 | 1.5 | 3.25
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Co-Leading | Actual Hours |  | 1.25 |  |  |  |  | 0.25 | 0.5 | 0.5 |  | 0.75 | 0.25
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Impact Assessment & Problem Mgt Reviews | Actual Hours |  | 17 | 3.5 | 0.5 | 3 | 1 | 2.5 | 1.75 | 4.75 | 2.25 | 2.5 | 2
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Internal Consultancy | Actual Hours |  | 15 | 0.25 | 9.5 | 1 |  |  | 1.25 | 3 | 2 | 3 | 0.25
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Knowledge Management | Actual Hours |  | 6 | 6 |  |  |  |  |  |  | 1.5 | 1.5
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Multi Regional Liaison & Consultancy | Actual Hours |  | 3.25 | 0.5 | 2.75 |  |  |  |  |  | 1.25 | 0.5
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Operational | Actual Hours |  | 71 | 10.5 | 9 | 8.5 | 8.75 | 16.25 | 7.75 | 10.25 | 7 | 14 | 22.5
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Personal Development | Actual Hours |  | 1.5 |  |  |  |  |  | 1.5 |  | 2 | 1.5 | 2
GALVIN, [NAME] | PP&C BAU Tasks FY12 | PP&C BAU Tasks FY12 | Surgeries | Actual Hours |  | 20 | 2.25 | 1.75 | 4.25 | 3.5 | 1.75 | 3.75 | 2.75 | 4.75 | 2 | 3