Staff Scheduler

Upload your workbook, run the optimizer, download the schedule. Powered by integer programming.

Mixed Integer Linear Program · CBC Solver · PuLP

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.

  1. Download the sample workbook below — it shows exactly what data goes in each sheet.
  2. Fill in your own data. Do not rename or delete any sheets.
  3. Upload your completed workbook and click Run Scheduler.
  4. 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)
⇣ Download sample workbook

2 Upload your workbook

📂
Choose file or drag & drop
.xlsm · .xlsx

Solving… this may take 30–60 seconds
Assignments
Staff Members
Solver Status

3 Schedule output