Staff Scheduling Optimizer
Supply-to-demand scheduling. Edit the data below (auto-saved in this browser), or import/export Excel — then Solve.
The tables below ARE your data. Type in them directly, paint the grids, import a workbook, or start from a sample — Solve always runs on what you see here. Your data auto-saves in this browser and will be here when you come back. Solved results are NOT saved (and are not part of the data export) — after solving, use Download results or just re-solve.
Demands
penalty = cost per uncovered unit per slot (higher = more important). concurrent = a person already assigned elsewhere can also cover this (presence-style).
People
One row per person: cost/hr (lower = assigned first) and their work-rule limits.
Skills
Which demands each person can serve, and at what rate (units per slot). A bilingual person gets two rows here — but only one row in People.
Schedules grid — paint with:
Click or drag to paint cells. default schedule: numbers are importance weights (higher = more important). Demand grids: required units per slot. Supply grids: availability (a) or fixed (f).
Bulk fill / paste from Excel
Days
from
to
value
Or paste a range copied from Excel (first column = times like 08:00, header row = day names):