A possible solution in edited workbook.

Added a calendar table and a calculated column into 1st table.


Btw, having a table you add a new column per week is a waste and after some time will be cumbersome! Why not design a report sheet, where you select a week (you can use data validation list), and a table for this week is filled (list of active employees in column A, list of active streams at top, and percents in table, plus additional column for person total).

Attached Files

resource_utilization.xlsx (494.6 KB, 12 views)