Spreadsheet: 807349d1669858709-how-to-eliminate-weekends-from-calculation-resource-planning-template-eliminate-weekends-from-calculation
Sheet: Resource Summary

Resource Bandwidth HeatMap
 | Select Project |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  | 1 |  |  |  | Year |  |  | 2022
 |  |  |  | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon
 | Reosorce Name |  |  | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-31 00:00:00
 |  |  |  | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 2 | 2 | 4
 | Person 2 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | Person 3 |  | 2 | 2 | 2 | 4 | 4 | 4 | 2 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 2
 | Person 4 |  | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 4 | 4 | 4 | 4
 | Person 5 |  | 1 | 1 | 1 | 3 | 3 | 0 | 0 | 1 | 1 | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 2 | 2 | 2 | 0 | 0
 | Person 6 |  | 1 | 1 | 1 | 3 | 3 | 4 | 2 | 4 | 4 | 4 | 4 | 2 | 2 | 3 | 3 | 3 | 3 | 5 | 4 | 4 | 1
 | Person 7 |  | 2 | 2 | 2 | 3 | 3 | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 2 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3
 | Person 8 |  | 2 | 2 | 2 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 0 | 1 | 1 | 0 | 2 | 4 | 4 | 4 | 4
 | Person 9 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 1 | 1 | 1
 | Person 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1
 | Person 11 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
 | Person 12 |  | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 3 | 2 | 2 | 2 | 3 | 3 | 1
 | Person 13 |  | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 2 | 0 | 0 | 1 | 1 | 0
 | Person 14 |  | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 4 | 2
 | Person 15 |  | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Person 16 |  | 0 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 2 | 2 | 2 | 2 | 3 | 1
 | Person 17 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 2
 | Person 18 |  | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 0
 | Person 19 |  | 0 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 0
 | Person 20 |  | 0 | 0 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 3 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0 | 0 | 2
 | Person 21 |  | 0 | 0 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 | Person 22 |  | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 2
 | Person 23 |  | 0 | 0 | 2 | 2 | 2 | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 2
 | Person 25 |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 0 | 2 | 2 | 2 | 0 | 1 | 1 | 1 | 1 | 2
 |  | *Showing Sum of Planned Hours Per Day
 |  | ***This is automated Resorce Bandwidth HeatMap based on the data in  'Data Sheet'. You can enter the actual data in the Data Sheet to see the HeatMap for your Team .