The short version

The first draft looked complete, but it scored 4/10. One Thursday night shift had no Lead, Ellis was assigned outside their availability, and that same assignment left only eight hours of rest.

We returned those exact failures to the AI once. It changed two assignments and the revised schedule scored 10/10. We stopped there.

This is a scheduling experiment, not legal or HR advice. Real organizations should add their own labor rules, contracts, time zones, leave, and local requirements before using any schedule.

The task

We created a fictional 12-person support team for the week of August 10–16, 2026. The operation needed two people on each of 21 eight-hour shifts.

RuleRequirement
CoverageExactly two different people per shift
Lead coverageAt least one Lead per shift
Weekly hoursNo one above 40 hours
AvailabilityEvery assignment must be in the supplied availability list
RestAt least 12 hours between shifts

All names and availability data are fictional. The complete input matrix is included in the downloadable workbook.

The exact first prompt

Create a 7-day schedule for a 24/7 customer support team.

Each day has three shifts:
- Night: 00:00–08:00
- Day: 08:00–16:00
- Evening: 16:00–00:00

Assign exactly two different people per shift. Every shift needs at least one Lead. Respect the supplied availability matrix, a 40-hour weekly maximum, and at least 12 hours of rest between shifts. Do not assign the same person twice in one shift.

Return a table with day, shift, employee 1, and employee 2, followed by weekly hours for every employee.

The test ran inside an OpenAI coding environment. The session did not expose a precise model identifier, so we have not guessed one.

First result: 4/10

The table had all 42 seats filled and nobody exceeded 40 hours. A visual scan could easily have mistaken it for a finished schedule. Formula checks found three distinct problems:

  1. Thursday Night had no Lead. Gray Ortiz and Harper Singh were both Agents.
  2. Ellis Park was unavailable on Sunday Day.
  3. Ellis had only eight hours of rest between Saturday Evening and Sunday Day. The workbook marks both affected rows, but this is one rest-conflict pair.
CriterionFirst draft
Complete coverage2/2
Lead on every shift0/2
Weekly hours ≤ 402/2
Availability respected0/2
12-hour rest / no duplicates0/2
Total4/10 — failed

The one correction

We did not rewrite the prompt or silently repair the table. We returned only the detected failures:

Your first schedule has three validation failures:

1. Thursday Night has no Lead.
2. Ellis Park is not available Sunday Day.
3. Ellis Park has only 8 hours of rest between Saturday Evening and Sunday Day.

Make one correction pass. Keep every valid assignment unchanged where possible and return the full revised schedule. All original constraints still apply.

The revised result made two substitutions:

  • Thursday Night: Gray Ortiz → Casey Reed
  • Sunday Day: Ellis Park → Devon Miles

Every other assignment stayed unchanged.

Final result: 10/10

The corrected 24/7 support schedule with all formula checks passing
The corrected 24/7 support schedule with all formula checks passing

The second pass filled every shift, restored Lead coverage, respected every availability entry, kept all employees at or below 40 hours, and removed the short-rest conflict.

The formula-backed comparison showing the first draft at 4 out of 10 and the corrected result at 10 out of 10
The formula-backed comparison showing the first draft at 4 out of 10 and the corrected result at 10 out of 10

What worked

  • The AI repaired both bad assignments without disturbing the 19 valid shifts.
  • The correction handled two connected problems—availability and rest—with one change.
  • Weekly hours remained balanced enough for this small fictional test, with every person at 16–40 hours.

What failed

  • The first response did not reliably enforce role coverage.
  • It treated an unavailable assignment as acceptable.
  • It missed a rest rule that required comparing adjacent assignments across two days.
  • The first table looked plausible despite failing three rules. Without independent checks, we would not trust it.

Verdict

Worked after one correction. AI was useful for producing and repairing the schedule, but the first answer was not safe to use without validation. The spreadsheet—not the confidence of the prose—decided the score.

Download the complete Excel workbook to inspect both versions, the input rules, staff hours, formulas, and pass/fail checks.

Reproduce the test

  1. Open the workbook and review Staff & Rules.
  2. Paste the exact first prompt and availability matrix into the AI tool you want to test.
  3. Copy its output into a new schedule table without fixing it.
  4. Run the five checks and record the first score.
  5. Return only the detected failures once, then score the full revision.

If your result differs from ours, keep it. Model behavior can change over time, and disagreement is part of the evidence.