Air Force / Flight Scheduling
Replacing spreadsheets and paper with one view of who can fly
Scheduling crews for training flights is one of the Air Force's most tedious jobs. Schedulers cross-referenced spreadsheets and paper to work out who was available, who was qualified, and who needed training most.
Another team had already built scheduling for the flights themselves. Our team was spun up for the people side: helping schedulers choose who goes on each flight.
Mapping a scheduler's workflow, step by step
I interviewed schedulers, our subject matter expert and our main stakeholder, then mapped every step of their workflow, its pains and its opportunities in a service blueprint.
Putting the team's domain knowledge to work
With so much cross-team expertise on hand, I ran a design sprint to give ideation real time. On day one we agreed the long-term goal: a system that suggests the right people who are also available for each mission.
From sprint sketches to testable prototypes
After a few days of sprinting we had a wall of ideas. I turned the strongest into prototypes, tested them with users, and refined them into one flow. Schedulers start from the short range schedule above, where every sortie shows whether it still needs crew.
01 Day view


Click into a day to see how many crew each sortie still needs. Selecting one lists every position, with conflicts like crew rest flagged.
02 Add a sortie


Choose the mission type, aircraft and times. Crew positions are set automatically, so the scheduler goes straight to building the crew.
03 Build the crew


Build the crew from every candidate's qualifications at a glance (green current, amber expiring, red expired), with leave, TDY and other sorties flagged before anyone is committed.