FILE GUIDE: PILOT SCHEDULE BIDDING TOOL

What each file is, what it does, and where it sits in the process

Three files, one project. Each covers a different part of the same tool: one is the plan, one is what a pilot sees, one is what you set up before anyone can bid. This page is the map between them. Open this alongside the other three.
1

Where Each File Sits in the Quarter

1. LINES GET BUILT Bidding Calendar: Rotation Setup Once per quarter 2. PILOTS BID Quarterly Bid, Pilot View Window open, about 30 days 3. ENGINE ASSEMBLES Covered in the framework document Automatic, after cutoff 4. YOU REVIEW Approve, override, publish You do this Pilots do this You do this Before the window opens During the window After cutoff

The framework document does not sit at one point on this timeline. It explains the whole thing, including the part in step 3 that has no mockup yet because it runs on the server rather than on a screen.

The three files

1
Framework: Pilot Schedule Bidding Tool
framework.html
Reference throughout For you
What it is
A written document, not an interactive tool. It lays out the plan: the pairing rules in priority order, how the automated engine will work, what is settled versus still open, and what I am assuming until you confirm otherwise.
What it does
Gives you one place to check the logic before any of it gets built. Nothing in this file runs; it is the spec the other two files, and the eventual real engine, get built against.
Timeline
Not tied to a single step. It covers the whole quarter, including the part that happens automatically after the bid window closes, which has no visual mockup because it runs on the server.
Who it's for
You. It is the document to read first and the one to send comments back on.
2
Bidding Calendar: Rotation Setup
rotation-setup.html
Step 1 For you
What it is
A clickable mockup, preloaded with the four lines (A, B, C, HB) from the current Q4 spreadsheet so you can check the math against what you already know.
What it does
Lets you define a rotation line with four fields: fleet, days on, days off, and a start date. It generates every on-duty block for the whole quarter automatically, for all four slots on the line, so you are not hand-building 15 date ranges per line the way the spreadsheet requires. Also handles reposition days for home-based lines, and a toggle to compare Phenom-only or Praetor-only cycles side by side.
Timeline
This has to happen first, before the bid window opens. Pilots cannot bid on a line that does not exist yet.
Who it's for
You. Pilots never see this screen; they only see the lines once you have set them up.
3
Quarterly Bid: Pilot View
pilot-bid.html
Step 2 For pilots
What it is
A clickable mockup of what a pilot opens to submit a bid, using the same real Q4 line data as the setup screen so the two match.
What it does
Opens on a short first page: name, plus any approved PTO for the quarter, entered as date ranges. That feeds the second page, which shows every line and slot a pilot is qualified for, with the actual on-duty dates listed as well as a visual bar. Any slot that overlaps approved PTO gets grayed out automatically and marked "PTO conflict," so a pilot never ranks a choice they cannot actually work. Slots they are not qualified for are grayed out the same way, marked "Not qualified." Ranks up to five choices, plus optional crew preference and a sell-days field held off pending your answer.
Timeline
Used during the bid window, after lines are published and before the cutoff.
Who it's for
Pilots. You would only open this to see it from their side.

If a rename would make this clearer on your end, for example matching file names to what pilots and schedulers actually call these screens, say so and I will update it. Nothing here is locked in.