Data & analysis
A clash-free schedule for 14 candidates
- Time
- 25 min + 12 min
- What was said
- 2 sentences
- Delivered
- Schedule page + change notice
The finished work

How it got made
The spreadsheet “next week's interviews – free slots.xlsx” in the workspace has two sheets: the free slots of 5 interviewers for each day next week, and the times that suit 14 candidates and how they'll interview. Make me a clash-free interview schedule to send to the interviewers and candidates. Rules: two rounds per person; first round 60 minutes (front-end with A or B, back-end with B or C, product with D), second round 45 minutes (all with E); the second round comes after the first with at least 15 minutes between; for people coming in person, both rounds on the same day, and there are only 2 meeting rooms; each interviewer does at most 3 a day, E at most 4; start on the hour or half hour. Make it a web page (schedule/index.html) that can be viewed by day or by interviewer, opens offline and prints; list anyone who can't be fitted in separately, saying what's blocking them.
Put in the spreadsheet and send that one sentence

25 min later: 13 of 14 candidates placed

One more sentence: interviewer B is off Wednesday, redo it

12 min later: rescheduled, and no candidate has to move

