← All use cases

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

Interview schedule · switch between days, interviewers and candidates (the page is in Chinese)Open full screen ↗
  • The change-notice tab added in the second round: who to tell, what changed and a message to copy

How it got made

What was asked, word for word

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.

  1. Put in the spreadsheet and send that one sentence

    Put in the spreadsheet and send that one sentence
  2. 25 min later: 13 of 14 candidates placed

    25 min later: 13 of 14 candidates placed
  3. One more sentence: interviewer B is off Wednesday, redo it

    One more sentence: interviewer B is off Wednesday, redo it
  4. 12 min later: rescheduled, and no candidate has to move

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