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

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] | 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
Total PM
Project Managers (signature):
DBA SQL
Insert names
Unassigned
Total DBA SQL
Resource Manager (signature):
DBA Oracle
Insert names
Unassigned
Total DBA Oracle
Resource Manager (signature):
Systems Admin
Insert names
Unassigned
Total Systems Admin
Resource Manager (signature):
Networking
Insert names
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  |  |  |  |  |  |  |  |  | 3.7
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Unassigned
Total Networking
Resource Manager (signature):
Client Devices
Insert names
Unassigned
Total Client Devices
Resource Manager (signature):
Business Applications - GIS
Insert names
[NAME] | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7 | 1.7
Total Business Apps - GIS
Resource Manager (signature):
Business Applications - LLPG
[NAME] | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 3.7 | 3.7 | 0 | 0 | 0 | 0 | 7.4 | 7.4 | 0 | 0 | 0 | 7.4 |  |  |  |  |  |  |  |  |  | 3.7
[NAME] | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 3.7 | 3.7 | 0 | 0 | 0 | 0 | 3.7 | 3.7 | 0 | 0 | 0 | 3.7
Total Business Apps - LLPG
Resource Manager (signature):
Business Applications - Core Apps
[NAME] | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2
[NAME]
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
Angus Macrae
Unassigned
Total Security
Resource Manager (signature):
Systems Integration - Integration
Sean Kearon & [NAME] | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 44.4 | 44.4 | 44.4 | 44.4 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6
Kev Lawrence & Rachel Hill | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 29.6 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3 | 33.3
Total SI - Integration
Resource Manager (signature):
Systems Integration - App Development
Insert names
Unassigned
Total SI - App Development
Resource Manager (signature):