Spreadsheet: 870243d1716796889-project-resource-planner-lookup-and-count-sum-formulas-project-resource-plan-aligw
Sheet: Allocations

Project Resource Planner
 | ID | Project Name | Type | Go live |  | 2023-04-23 00:00:00 | 2023-05-23 00:00:00 | 2023-06-23 00:00:00 | 2023-07-23 00:00:00 | 2023-08-23 00:00:00 | 2023-09-23 00:00:00 | 2023-10-23 00:00:00 | 2023-11-23 00:00:00 | 2023-12-23 00:00:00 | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00 | 2024-11-23 00:00:00 | 2024-12-23 00:00:00
WORKING DAYS per MONTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 21 | 20 | 22 | 21 | 20 | 23 | 21 | 21 | 23 | 21 | 20
PERSON 1
Service Design |  | Project A |  |  |  | 08:24:00 | 08:24:00 | 04:48:00 |  |  | 02:24:00 | 02:24:00 | 02:24:00 |  | 0.2 |  |  |  | 0.1 | 0.2 | 0.2
Service Design |  | Project B |  |  |  | 06:00:00 | 08:24:00 | 12:00:00 |  |  | 21:36:00 | 20:24:00 | 21:36:00 | 21:36:00 | 0.25 |  |  |  | 0.05 | 0.05 | 0.05
Service Design |  | Project C |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  | 0.1 | 0.1 | 0.2 | 0.2 | 0.3 | 0.3
Service Design |  | Project D |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 |  |  |  | 0.05 | 0.05
Service Design |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.25 | 0.25 | 0.25
Service Design |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.1
Service Design |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
 |  | Training
 |  | Leave |  |  |  | 0.25 |  |  |  |  |  | 0.05 |  | 0.1
Total
PERSON 2
Service Design |  | Project A |  |  |  |  |  |  |  |  |  |  |  |  | 1
Service Design |  | Project B |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
Service Design |  | Project C |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
Service Design |  |  |  |  |  |  |  |  |  |  | 16:48:00 | 16:48:00 | 16:48:00 | 16:48:00
Service Design |  |  |  |  |  |  |  |  |  |  | 02:24:00 | 02:24:00 | 02:24:00 | 02:24:00
Service Design
Service Design |  |  |  |  |  |  |  |  |  |  | 04:48:00 | 04:48:00 | 04:48:00 | 04:48:00
 |  | Training
 |  | Leave |  |  |  | 0.25
Total
PERSON 3
Service Design |  | Project A |  |  |  |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  | 0.2 | 0.15 | 0.1 | 0.1
Service Design |  | Project B |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  | 0.05 | 0.1 | 0.1 | 0.15
Service Design |  | Project C |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  | 0.05 | 0.1 | 0.1 | 0.175
Service Design |  | Project D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | 0.1 | 0.1 | 0.175
Service Design |  |  |  |  |  |  |  | 09:36:00 | 09:36:00 | 12:00:00 | 12:00:00 | 12:00:00 |  |  |  |  |  |  | 0.05 | 0.1 | 0.15 | 0.15
Service Design |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.05 | 0.05 | 0.1
Service Design |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 0.4 | 0.4 | 0.4 | 0.15
 |  | Training |  |  |  |  |  |  | 0.05 | 0.05 | 0.05
 |  | Leave |  |  |  |  |  |  | 0.55
Total
PERSON 4
Project Management |  | Project A |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 09:36:00 | 09:36:00 | 09:36:00 | 09:36:00 | 0.15 |  |  |  | 0.17 | 0.17 | 0.17 | 0.17
Project Management |  | Project B |  |  |  |  |  |  |  | 12:00:00 | 09:36:00 | 09:36:00 | 09:36:00 | 09:36:00 | 0.1 |  |  |  | 0.16 | 0.16 | 0.16 | 0.16
Project Management |  | Project C |  |  |  |  |  |  | 1900-01-01 00:00:00 |  | 04:48:00 | 04:48:00 | 04:48:00 | 04:48:00 | 0.05 |  |  |  | 0.67 | 0.67 | 0.67 | 0.67
Project Management
Project Management
Project Management
Project Management
 |  | Training
 |  | Leave
Total
PERSON 5
Business Analysis |  | Project A |  |  |  | 03:36:00 | 03:36:00 | 00:28:48 | 00:28:48 | 02:24:00 | 02:24:00 | 02:24:00 | 02:24:00 | 02:24:00 | 0.15 |  |  |  | 0.2 | 0.2 | 0.2 | 0.2
Business Analysis |  | Project B |  |  |  | 00:00:00 | 01:12:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 |  |  |  | 0.1
Business Analysis |  | Project C |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 01:12:00 | 01:12:00 | 03:36:00 | 0.05 |  |  |  | 0.05 | 0.05 | 0.1 | 0.1
Business Analysis |  | Project D |  |  |  | 03:36:00 | 03:36:00 | 01:12:00 | 03:36:00 | 03:36:00 | 04:48:00 | 01:12:00
Business Analysis
Business Analysis |  |  |  |  |  |  |  | 04:48:00 | 04:48:00 | 04:48:00 | 01:12:00 | 02:24:00 | 02:24:00 | 02:24:00
Business Analysis |  |  |  |  |  |  |  |  |  |  | 01:12:00 | 01:12:00 | 01:12:00 | 01:12:00
 |  | Training
 |  | Leave |  |  |  |  |  |  | 0.25
Total
 |  | Training |  |  |  | 0.15 | 0.05 | 0.05 | 0.05 | 0.1 | 0 | 0.01 | 0.04 | 0.05
 |  | Leave |  |  |  | 0.5 | 0.1 | 0.1 | 0.15 | 0.1 | 0.01 | 0 | 0.01 | 0.05
Total |  | TOTAL