Request for Custom FET, Fixed Course Sessions,Exact Staff load,Neglect Students

[hepishy]

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.