I'm working on a university‐level timetable with the following requirements:
1. Fixed Course–Timeslot Matrix
- Each course has a predefined number of parallel sessions in every timeslot (e.g., course01 needs two sections in Saturday Period 1, Period 2, etc.).
- These sessions must be "locked" into those exact day-period slots.
2. Exact Staff–Course Load Capacities
- Each instructor has a hard limit of sessions per course per week (e.g., staff01: 5 course01, 5 course02; staff02: 5 course01, 6 course03; etc.).
- Total staff-load constraints must be enforced exactly.
3. No Overlapping & Day-Off Constraints
- No teacher may be scheduled for more than one course in the same slot.
- One staff must not teach on Saturdays.
- Maximum of 4 periods per day per teacher.
4. Neglecting students and focus on distributing staff over sessions
5. Desired output
- Automatically assign qualified staff to all locked sessions under their capacity and availability constraints.
I can provide sample Excel files with my 17×7 course-timeslot matrix and 7×12 staff-capacity matrix to guide.
1. Fixed Course–Timeslot Matrix
- Each course has a predefined number of parallel sessions in every timeslot (e.g., course01 needs two sections in Saturday Period 1, Period 2, etc.).
- These sessions must be "locked" into those exact day-period slots.
2. Exact Staff–Course Load Capacities
- Each instructor has a hard limit of sessions per course per week (e.g., staff01: 5 course01, 5 course02; staff02: 5 course01, 6 course03; etc.).
- Total staff-load constraints must be enforced exactly.
3. No Overlapping & Day-Off Constraints
- No teacher may be scheduled for more than one course in the same slot.
- One staff must not teach on Saturdays.
- Maximum of 4 periods per day per teacher.
4. Neglecting students and focus on distributing staff over sessions
5. Desired output
- Automatically assign qualified staff to all locked sessions under their capacity and availability constraints.
I can provide sample Excel files with my 17×7 course-timeslot matrix and 7×12 staff-capacity matrix to guide.