Spreadsheet: 185301d1349632627-tricky-puzzle-sum-and-indirect-formula-issue-resource_allocation_asim
Sheet: ISP772

PAGE 5 |  | PROJECT RESOURCES
PROJ ID: |  | PROJ NAME: |  |  |  |  | PROJ MANAGER: |  |  |  | DIRECTORATE:
Resource Types & Named Individuals | 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 | Hours forecast/worked per week
Project Management
[NAME] | 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
Total PM
Project Managers (signature):
DBA SQL
[NAME] |  |  |  |  | 4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
[NAME] |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 0.75
Total DBA SQL
Resource Manager (signature):
DBA Oracle
Insert names
Unassigned
Total DBA Oracle
Resource Manager (signature):
Systems Admin
[NAME] | 11.75 |  |  |  | 7.4 |  | 2 | 2 | 2 | 2 |  | 2 | 5 | 7.4 |  |  |  |  |  |  | 4
Unassigned
Total Systems Admin
Resource Manager (signature):
Networking
[NAME] | 2 |  |  |  | 1 | 1 | 1 | 0 | 0
[NAME] |  |  | 7.4 |  |  |  |  |  | 4 |  | 7.4 | 4
[NAME] |  |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  | 2 |  | 1 | 1 |  | 2
Total Networking
Resource Manager (signature):
Client Devices
[NAME] |  |  |  |  |  | 7.4 |  |  |  |  |  |  |  | 4 | 3
[NAME] |  |  |  |  |  |  |  |  | 15
[NAME] |  |  |  |  |  |  |  |  | 7.4 |  |  |  |  |  |  |  |  |  |  |  | 15
[NAME] | 22
[NAME] |  |  |  |  |  |  |  |  |  |  | 7.4
Total Client Devices
Resource Manager (signature):
Business Applications - GIS
Insert names
Unassigned
Total Business Apps - GIS
Resource Manager (signature):
Business Applications - LLPG
Insert names
Unassigned
Total Business Apps - LLPG
Resource Manager (signature):
Business Applications - Core Apps
Insert names
Unassigned
Total Business Apps - Core Apps
Resource Manager (signature):
Business Applications - IMS
Insert names
Unassigned
Total Business Apps - IMS
Resource Manager (signature):
Core Services
Insert names
Unassigned
Total Core Services
Resource Manager (signature):
Security
Insert names
Unassigned
Total Security
Resource Manager (signature):
Systems Integration - Integration
Insert names
Unassigned
Total SI - Integration
Resource Manager (signature):
Systems Integration - App Development
Insert names
Unassigned
Total SI - App Development
Resource Manager (signature):