BuildAuto Scheduler Engine

I run the monthly roster for 17 staff in AmIOn and have accumulated 32 non-negotiable rules—everything from strict rotation patterns to honouring every approved leave request. Manually weaving those constraints together each month is eating days I should be spending elsewhere, so I need a standalone automatic scheduler that respects all rules, lets me lock a few shifts by hand, and then fills the rest perfectly before I copy it into AmIOn.

Here is the outcome I’m after:

• A tool (spreadsheet, web app, or script—whatever is most robust) where I can enter next month’s parameters, press a button, and receive a fully populated schedule that satisfies every rotation and leave rule without exception.
• Simple controls to pre-assign certain people or shifts when I choose, with the engine back-filling the remainder.
• One-click export or copy-paste output formatted so I can drop it straight into AmIOn’s import screen. (not necessarily required, I don't mind manually entering)
• A brief walkthrough or video so I can tweak rules later without calling you every time.

Acceptance criteria: the generated schedule must meet 100 % of the stated rotation patterns and leave requests, cover the full month in under five minutes of processing, and allow manual overrides without breaking the remaining logic.

If you’ve built optimisation or scheduling engines before—whether in Python with pandas/OR-Tools, Google Sheets scripts, or similar—you’ll know exactly what to do. Let me know how you’d structure the rule logic and the kind of interface you’d deliver so I can finally reclaim my time each month.