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

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 Hours | Total Recharge £
 | 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] | 44 | 44 | 44 | 44 | 37 | 37 | 37 | 49 | 37 | 37 | 29.6 | 37 | 37 | 29.6 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a
Doug Haynes | 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
Total PM
Project Managers (signature):
DBA SQL
[NAME] | 0 | 0 | 0 | 0 | 0 | 29.6 | 37 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 14.8 | 29.6 | 51.8 | 0 | 0 | 0 | 0 | 29.6 | 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
Total DBA SQL
Resource Manager (signature):
DBA Oracle
DBA Resource | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 15 | 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 | 0 | 0 | 0 | 0
Unassigned
Total DBA Oracle
Resource Manager (signature):
Systems Admin
Insert names
Unassigned
Total Systems Admin
Resource Manager (signature):
Networking
Insert names
Unassigned
Total Networking
Resource Manager (signature):
Client Devices
Insert names
Unassigned
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
[NAME] | 37 | 37 | 37 | 37 | 37 | 0 | 37 | 49 | 37 | 0 | 37 | 37 | 37 | 37 | 37 | 37 | 49 | 37 | 37 | 37 | 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 | 0
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
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 7.4 | 0 | 0 | 7.4 | 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 | 0 | 0 | 0 | 0
[NAME] | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 0 | 0 | 30 | 30 | 30 | 30 | 37 | 30 | 30 | 30 | 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 | 0
Total SI - App Development
Resource Manager (signature):
Grand Total of Hours/Recharge