Spreadsheet: 185301d1349632627-tricky-puzzle-sum-and-indirect-formula-issue-resource_allocation_asim
Sheet: Total PM's time

 | Week 4 |  | Week 5 |  | Week 6 |  | Week 7 |  | Week 8 |  | Week 9 |  | Week 10 |  | Week 11 |  | Week 12
Resource
 | Apr |  |  |  | May |  |  |  |  | Jun |  |  |  | Jul |  |  |  | Aug |  |  |  |  | Sep |  |  |  | Oct |  |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  |  | Feb |  |  |  | Mar |  |  |  | Totals
 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | 2013-01-06 00:00:00 | 2013-01-13 00:00:00 | 2013-01-20 00:00:00 | 2013-01-27 00:00:00 | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2013-03-31 00:00:00
Week Ending
Project Management
[NAME] (IS OA Prog Manager) |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
[NAME] moves (see total row 45) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
[NAME] moves(see total row 47) |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
PM 01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
PM 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
PM 03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
Megan Rowland - office moves |  |  |  |  |  |  |  |  | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
TOTAL - Office Moves
[NAME] (ISP880) | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 6 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 22.2 | 22.2 | 10 | 10 | 5 | 2 | 2 | 10 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] (ISP871) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.25 | 5.25 | 3 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] (ISP867) | 0 | 0 | 0 | 0 | 3.5 | 0 | 7.5 | 5.25 | 1.5 | 8 | 5.25 | 3 | 3 | 7 | 2 | 3.25 | 6.5 | 4 | 5 | 5 | 0 | 0 | 5 | 10 | 10 | 10 | 10 | 15 | 15 | 15 | 15 | 15 | 10 | 5 | 5 | 5 | 5 | 5
[NAME] (ISP772) | 16.75 | 3 | 8 | 5.75 | 7.75 | 7.5 | 9.5 | 7.5 | 6.25 | 0 | 7 | 5.25 | 2.25 | 9.75 | 9.25 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] (ISP852) | 3 | 2 | 2 | 3 | 7.25 | 9 | 4.75 | 0 | 2.75 | 0 | 3.75 | 3.5 | 3.5 | 9 | 11.75 | 10 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] TOTAL
[NAME] (ISP877) | 20 | 15 | 15 | 10 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 7 | 0 | 0 | 0 | 10 | 10 | 5 | 5 | 7 | 30 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
[NAME] (ISP899) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 7 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
[NAME] (ISP859) | 5 | 0 | 15 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 15 | 15 | 15 | 15 | 15 | 0 | 0 | 0 | 15 | 15 | 7 | 7 | 7 | 7 | 7 | 7
[NAME] TOTAL
[NAME] (ISP829) |  |  | 39.83 | 41 | 37.65 |  | 40.92 |  |  | 0 | 40.32 | 37 | 37 |  | 20.42 | 7.95 | 11.87 | 0 | 0 | 18 | 30 | 0 | 30 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] (ISP845) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.4 | 20 | 31.8 | 47.46 | 0 | 0 | 18 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Doug Haynes TOTAL
[NAME] (ISP823) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 9.5 | 10.5 |  | 1 | 0 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] (ISP846) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 2 | 2
[NAME] (ISP903) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 4.5 |  |  | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5
[NAME] (ISP908) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3 | 2 |  |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
[NAME] (ISP911) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7.5 |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
[NAME] TOTAL
[NAME] | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
[NAME] TOTAL | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
[NAME] (ISP913) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] [ISP879] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 2 | 2 | 2 | 2
[NAME] TOTAL
[NAME] (ISP838) | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 18.5 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8
[NAME] (ISP862) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 1 | 1 | 0 | 1 | 0 | 2 | 2 | 2 | 0 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4
[NAME] (ISP861) | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 0 | 2 | 2 | 2 | 2 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1 | 11.1
[NAME] TOTAL
[NAME] (ISP864) | 1 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 18 | 18 | 20 | 20 | 20 | 20 | 2 | 7 | 7 | 7 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2 | 2 | 2 | 2
[NAME] (ISP870) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
[NAME] TOTAL
[NAME] (ISP883) | 0 | 1 | 0 | 4 | 1 | 0 | 2 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 0 | 7 | 12 | 0 | 5 | 7 | 1 | 7 | 5 | 7 | 7 | 7 | 15 | 15 | 15 | 15 | 15 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] TOTAL
[NAME] (ISP868)
[NAME] (ISP881)
[NAME] (ISP901)
[NAME] TOTAL
[NAME] (ISP844) | 37 | 37 | 32 | 28 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
[NAME] (ISP771) |  |  |  |  | 4 | 4 | 4 | 4
[NAME] TOTAL