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

PAGE 5 |  | PROJECT RESOURCES
PROJ ID: | ISP846 | PROJ NAME: | Hosted Sims Pilot Service |  |  |  | PROJ MANAGER: | [NAME] |  |  | DIRECTORATE: |  | Resources
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 (week ending Sunday)
Project Management
[NAME] | 9 | 0 | 23 | 32 | 31 | 24 | 27 | 0 | 0 | 0 | 6 | 6 | 14.5 | 0 | 7.5 | 0 | 0 | 35
Total PM
Project Managers (signature):
DBA SQL
Unassigned
Total DBA SQL
Resource Manager (signature):
DBA Oracle
None
Unassigned
Total DBA Oracle
Resource Manager (signature):
Systems Admin
Otte Koopmans | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time is recorded in Project Server but at time of highlight report unable to get to it so, with ottes agreement, 10 days is an estimate.
Unassigned
Total Systems Admin
Resource Manager (signature):
Networking
[NAME] |  |  |  |  |  |  |  |  |  |  | 7.4
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
Insert names
Unassigned
Total Business Apps - Core Apps
Resource Manager (signature):
Business Applications - IMS
[NAME] | 4 | 7.4 | 7.4 | 14.8 | 29.6 | 7.4 | 14.8 | 25 | 29.6 | 14.8 | 29.6 | 22.4 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] | 8 | 8 | 6 | 6 | 6 | 5 | 4 | 9 | 7 | 4 | 5.5 | 5.5 | 2 | 2 | 2 | 2 | 15 | 2
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):
Breakdown of Totals
Total PM hrs by Week
Total PM By Month
Conversion factor (£ per hr) | 350 | 7.4
Total Technical Hrs by Week
Total Technical Hrs By Month
Conversion factor (£ per hr) | 310 | 7.4