Free Staff Scheduler
MILP PuLP + CBC Integer Programming Upload your workbook, run the optimizer, download the schedule.
What is the staff scheduling problem?
The staff scheduling problem asks how to assign staff members to clients and courses across a week at the lowest cost — subject to availability, certifications, simultaneous-session limits, and equipment constraints. This free tool solves it as a Mixed Integer Linear Program (MILP) using PuLP and the CBC solver.
Upload an Excel workbook with your staff, clients, courses, and availability, click Run, and you get an optimized weekly schedule in a pivot table — plus a downloadable CSV. No signup, no install, completely free.
1 How it works
1
Download the sample workbook — it shows the exact format for each sheet.
2
Fill in your own data. Do not rename or delete any sheets.
3
Upload and click Run. The solver finds the optimal assignment.
4
View the pivot table or full list, then download the CSV.
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