Hi Team,
I have this roster prepared based on my seats available in my office. I have total 3 floors across where each team are decided on their weekly off across 7 days . However i want to know how each seats are available daily across all floors daily. Also i would like to know how many can be adjusted extra on each floor.
<colgroup><col><col><col><col span="7"></colgroup><tbody>
</tbody>
I have this roster prepared based on my seats available in my office. I have total 3 floors across where each team are decided on their weekly off across 7 days . However i want to know how each seats are available daily across all floors daily. Also i would like to know how many can be adjusted extra on each floor.
Team Name | Shift | Week Off | 16-Feb | 17-Feb | 18-Feb | 19-Feb | 20-Feb | 21-Feb | 22-Feb |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T3 | 11:30 TO 20:30 | ThruFri | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T5 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T3 | 11:30 TO 20:30 | ThruFri | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T3 | 11:30 TO 20:30 | ThruFri | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T3 | 11:30 TO 20:30 | ThruFri | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T3 | 11:30 TO 20:30 | ThruFri | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
X0 | General | SatSun | General | General | General | General | General | WO | WO |
X0 | General | SatSun | General | General | General | General | General | WO | WO |
X0 | General | SatSun | General | General | General | General | General | WO | WO |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T4 | 11:30 TO 20:30 | SunMon | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T1 | 07:00 TO 16:00 | SunSat | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO |
T2 | 07:00 TO 16:00 | TueWed | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
T3 | 11:30 TO 20:30 | ThruFri | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 |
T6 | 07:00 TO 16:00 | ThruFri | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | WO | WO | 07:00 TO 16:00 |
T5 | 11:30 TO 20:30 | TueWed | 11:30 TO 20:30 | 11:30 TO 20:30 | WO | WO | 11:30 TO 20:30 | 11:30 TO 20:30 | 11:30 TO 20:30 |
T7 | 07:00 TO 16:00 | SunMon | WO | WO | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 | 07:00 TO 16:00 |
16-Feb | 17-Feb | 18-Feb | 19-Feb | 20-Feb | 21-Feb | 22-Feb | |||
Ground Floor | 14 | 14 | 14 | 14 | 14 | 14 | 14 | ||
First Floor | 26 | 26 | 26 | 26 | 26 | 26 | 26 | ||
Second Floor | 36 | 36 | 36 | 36 | 36 | 36 | 36 | ||
Seats Defict - Second Floor | |||||||||
Seats Defict - First Floor | |||||||||
Seats Defict - Ground Floor |
<colgroup><col><col><col><col span="7"></colgroup><tbody>
</tbody>