Reserve Trip Analysis
When & how much — daily Reserve trip counts over the selected month. Three analytical layers help separate signal from noise:
- Bar height — raw deduplicated Reserve trips for each day. Days with zero trips either had no reserve usage or fell outside the scraped data window.
- 7-day rolling average — the amber line smooths over weekend and day-of-week effects to reveal the underlying trend. A rising rolling average that persists across multiple weeks is a stronger signal of increased reserve pressure than a single high-count day.
- 1.5σ threshold — the dashed red line marks mean + 1.5 standard deviations computed across all historical days in the filtered dataset. Orange bars on days above this line flag statistically unusual reserve demand. The threshold recalculates whenever filters change, so it always reflects the correct historical baseline for the current selection.
Daily Reserve Activity
Reserve trips per day. Orange bars = >1.5σ above historical mean. Amber line = 7-day rolling average. Threshold recomputes on every filter change.
Recent Reserve Activity (60 days, all bases)
60-day rolling view of total daily Reserve trips across all bases — unfiltered, showing the broad trend.
Who — identifies which seniority numbers are being used most and which are being used least. Three statistical signals work together to surface both ends of that pattern:
- Dual outlier thresholds — the Reserve Trips by Seniority Number chart shows two dashed lines: an upper threshold (mean + 1.5σ) flagging seniority numbers used at unusually high frequency, and a lower threshold (mean − 1.5σ, floored at zero) flagging seniority numbers assigned significantly fewer Reserve trips. Large orange points are heavily used; large blue points were lightly used.
- Z-score — shown in the Reserve Usage by Seniority Number table for every seniority number. A z-score of −2.0 means that seniority number was used for far fewer Reserve trips than the group average for the period. Compare z-scores across seniority numbers to see if low or high scores cluster.
- Seniority burden index — the summary bar compares Reserve trip load between the higher-numbered and lower-numbered halves of the filtered seniority group. A healthy distribution shows roughly equal trips-per-seniority-number across both halves; a large gap flags that one half is carrying a disproportionate share.
Reserve Trips by Seniority Number
Each point is one seniority number, plotted high-to-low. Large orange points exceed the upper 1.5σ threshold (heavily used). Large blue points fall below the lower 1.5σ threshold (lightly used). Points near the mean appear in amber.
Reserve Usage by Seniority Number
Sorted by trip count descending. Z-scores below −1.5 appear in blue (lightly used); z-scores above +1.5 appear in orange (heavily used). Pay reflects Reserve hours credited (HH:MM).
| Seniority | Base | Aircraft | Seat | Division | Reserve Trips | Z-Score | Pay | Flag |
|---|
Where & how much — total Reserve hours by month and how they are distributed across bid groups for any selected month. Two analytical layers surface trends and anomalies:
- Month-over-month delta — the table shows both absolute change (HH:MM) and percentage change from the prior month. A green arrow means more Reserve hours were used than the month before; red means fewer. Persistent green arrows across multiple months are a stronger signal of worsening Reserve utilization than any single month spike. The Demand column flags months that exceed the 1.5σ threshold computed across all months in the dataset — these represent statistically abnormal Reserve demand periods worth investigating.
- Bid group distribution — the bar chart shows how Reserve hours are split across seat/base/aircraft/division combinations for the selected month. Dominance by a single bid group can indicate localized scheduling stress or staffing gaps concentrated in one fleet or domicile. Use the filters to isolate a specific base or aircraft type to drill into its contribution.
Month-over-Month Reserve Hours
Total Reserve hours per month with change from prior month. Base/Aircraft/Seat/Division filters apply. Green = increase, red = decrease.
Reserve Hours by Bid Group
Reserve hours broken down by bid group for the selected month and filters, sorted highest to lowest.