1 How it works
This tool solves a staff scheduling problem using integer programming. It reads your workbook, finds the optimal assignment of staff to clients and courses across the week, and returns a complete schedule.
- Download the sample workbook below — it shows exactly what data goes in each sheet.
- Fill in your own data. Do not rename or delete any sheets.
- Upload your completed workbook and click Run Scheduler.
- View the schedule in the pivot table or full list, then download the CSV.
Required input sheets:
clients
courses
staff
days
timings
equipment
slots
availability
requirements
simultaneous
schedule (output)
report (output)
2 Upload your workbook
📂
Choose file or drag & drop
.xlsm · .xlsx
Solving… this may take 30–60 seconds