Spreadsheet: 850196d1700576340-formula-not-including-partial-weeks-example-data-workbook
Sheet: Summary

 |  |  | 2023-10-23 00:00:00 | 2023-10-30 00:00:00 | 2023-11-06 00:00:00 | 2023-11-13 00:00:00 | 2023-11-20 00:00:00 | 2023-11-27 00:00:00 | 2023-12-04 00:00:00 | 2023-12-11 00:00:00 | 2023-12-18 00:00:00 | 2023-12-25 00:00:00 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00 | 2024-02-05 00:00:00 | 2024-02-12 00:00:00 | 2024-02-19 00:00:00 | 2024-02-26 00:00:00 | 2024-03-04 00:00:00 | 2024-03-11 00:00:00 | 2024-03-18 00:00:00 | 2024-03-25 00:00:00
 |  |  | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 | 2023-11-26 00:00:00 | 2023-12-03 00:00:00 | 2023-12-10 00:00:00 | 2023-12-17 00:00:00 | 2023-12-24 00:00:00 | 2023-12-31 00:00:00 | 2024-01-07 00:00:00 | 2024-01-14 00:00:00 | 2024-01-21 00:00:00 | 2024-01-28 00:00:00 | 2024-02-04 00:00:00 | 2024-02-11 00:00:00 | 2024-02-18 00:00:00 | 2024-02-25 00:00:00 | 2024-03-03 00:00:00 | 2024-03-10 00:00:00 | 2024-03-17 00:00:00 | 2024-03-24 00:00:00 | 2024-03-31 00:00:00
Resource Name | Role | Weekly Hours | Wk43 | Wk44 | Wk45 | Wk46 | Wk47 | Wk48 | Wk49 | Wk50 | Wk51 | Wk52 | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | Wk7 | Wk8 | Wk9 | Wk10 | Wk11 | Wk12 | Wk13
Employee1 | Engineer | 20 | 0 | 1.333333333333333 | 1.333333333333333 | 1.333333333333333 | 1.333333333333333 | 1.333333333333333 | 1.333333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wkly capacity |  |  | 0 | 0.06666666666666667 | 0.06666666666666667 | 0.06666666666666667 | 0.06666666666666667 | 0.06666666666666667 | 0.06666666666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 20 | 18.66666666666667 | 18.66666666666667 | 18.66666666666667 | 18.66666666666667 | 18.66666666666667 | 18.66666666666667 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Employee2 | Technician | 40 | 0 | 0 | 0 | 0 | 0 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wkly capacity |  |  | 0 | 0 | 0 | 0 | 0 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 40 | 40 | 40 | 40 | 40 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Employee13 | Engineer | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wkly capacity |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Employee4 | Senior Technician | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wkly capacity |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
Employee5 | Senior Project Co-Ordinator | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wkly capacity |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
 | Empolyee | Need/Wk