We have 10 developers and approximately 16 projects.
I need a pivot table based spreadsheet that can show who is available to be assigned and re-assigned if needed to a particular project.
I need this to be shown in a dashboard type report as well.
5 day work week
37.5 hour day
US holidays only