Delta_AUS_Bagroom

Delta AUS Bagroom · Operations Trial

Flight · Pier

ETD

Status / Bags A/C By

⏱ Cutoff Timer

Cart Out / Variance

Gate

Crew / Lead

Carts / Workflow

Operations Entry

Flight (e.g. DL 1290)

Tail #

Destination

Gate (auto-assigns pier from gate)

Pier Side

Team Lead Initials

ETD (scheduled)

New ETD (if delayed)

Bagroom Agent Initials

Exit Scan Agent Initials

Cart Delivery Agent Initials

Carts to load

Cart Out Actual Time

Gate Arrival Time

Delay Reason (if any)

Missing Bags (count)

Flight Status

Reroute / Connection Notes

Click any flight to edit. Use Bulk Paste to load many at once.

Two formats are auto-detected — paste either one:

Format 1 — Delta Live System (copy/paste from the departures table)

DL ATL 1242 03 6:15 AM 6:10 AM 6:05 AM Complete 320 003274 196

Fields: Airline · Dest · Flight# · Gate · Sched · [Est Dept] · [Act Dept] · [Status] · [Equip] · [Ship] · [Pax]

✓ Status (Complete, Boarding, Routine…) is imported automatically. Gate and ETD are read correctly.

Format 2 — Manual entry

DL 1242 N322DN 6:15 AM 03 ATL 3 EP/MS AI AM EP

Fields: Flight · Tail · ETD · NewETD · Gate · Dest · Carts · Bagroom · ExitScan · Delivery · Lead

Import & Export CSV / Excel Import a .csv or .xlsx file instead of pasting (a header row is auto-detected: Flight, Gate, Dest, Sched ETD, New ETD, Carts, Bagroom, Exit Scan, Delivery, Lead, Pax, Equip, Status, Pier). Export writes the current board to a CSV in the same columns, so you can edit it in Excel and re-import. Excel import needs internet the first time; CSV works offline. (The detailed analytics report with timestamps & variance is in the Reports tab.)

Delay Analysis. Every flight that ran late, had a delay reason, or lost bags is broken down by stage (Pull → Scan → Run → Lead), reason, and the agents on it — so you can see exactly where the workflow is slipping.

Flights Today

Completed

On-Time Cart Out

—

Missing Bags

Station Code Shown in header (e.g. AUS)

Bag Cutoff Buffer (min before ETD) Bags must be at A/C this many min before departure (Delta domestic = 45)

Pull alert window (min) Row turns amber when cutoff is this close

Final-call window (min) Row turns orange when cutoff is this close

Auto-archive departed (min after) Hide flights that departed this long ago

On-Time Pull Target (%) Target for the KPI strip

Amber Warning Window (min before ETD) Row turns amber if cart hasn't gone out this close to departure

Show critical toast banner Big alert when bags hit cutoff window

Test clock (HH:MM 24h) Override the system clock for demo / training

Live Data Feed (auto-refresh) Paste the URL of your FlightAware AeroAPI proxy (your Cloudflare Worker that returns JSON). The board polls it on the interval below and updates schedule fields (ETD, gate, status) — your team's entries (agents, cart-out, workflow) are never overwritten. This cannot point at delta.com directly: browsers block cross-site reads and that page returns no data.

Feed URL Returns JSON (AeroAPI scheduled_departures, or a flat flight array)

Auto-refresh every (seconds) 0 = off. Recommended 60–120 to respect API limits

Feed status Not configured

Backup & Restore Export everything (flights, settings, handoff notes, feedback) to one JSON file, or import a file to replace all current data — useful for moving the board between devices or restoring a snapshot. This is a full JSON backup; to import a flight schedule from CSV or Excel, use Ops Entry → Paste tab.

Keyboard: E = Ops Entry · H = Handoff · F = Fullscreen