The MS Spreadsheet continues to get daily revisions.
There are currently 2 versions of the snapshot MS Excel spreadsheet
FULL 12MB - All of it, keeps growing with each snapshot
LITE 3.5MB - Just current docs, no previous snapshots
PDF - Category Summary only with MIN and Headcount Ceilings percentages.
Category Summary for July 24, 2020, is available as an interactive web view with relative seniority here.
Note: The page has to calculate the matrix for your percentages. The results are stored in the database until the next snapshot is available.
The ALPA STATIC seniority list number from the yearly Seniority List is now used universally throughout all reports.
Click any category to show an interactive staffing list with awards and percentages:
Your relative seniority for any give category is marked with ()*.
Column Min/Max: Percentages for Min/Max Projected Staffing.
Column Ceiling: Percentages for 'Tentative Headcount Ceilings - Global Categories.'
Scroll to your position as indicated in the header, or type your name or employee ID in the search bar to instantly pull up your info.
Note: If you're using conditional bid entries (percentages) you must consider the Min number of the Min/Max bulletin. See ALPA SSC update for May 13, 2020 regarding displacement bid conditional bidding.
MS Excel Snapshot Spreadsheet is here
Note: For filters and sorting to work, you must use Microsoft Excel.
Microsoft Excel Website is here.
MS Excel for iPhone/iPad is here.
MS Excel for Android is here.
Combines various company reports.
Award count by category and totals.
You can sort by any column.
Seniority percentages based on MIN staffing in Bid 20-09D.
Seniority percentages based on global "Tentative Headcount Ceilings."
UPDATE: The JrMan Matrices for the daily Snapshot (Min/Max, Headcount Ceilings, and Category Summary Award List).
Bid 20-09D closes July 30, 2020, at noon CT.
Manpower Planning Documents:
Every pilot involved in or concerned with the process should read the relevant sections of the UPA (including section 8-E ). If you haven't read that section, you probably won't realize some important details and protections that are part of the displacement process.
The ALPA SSC published a document which is very helpful in explaining the process.
ALPA SSC update for May 13, 2020 regarding displacement bid conditional bidding.
ALPA SSC update for May 8, 2020 regarding 309 displacement bid cancellations.
ALPA SSC update for May 7, 2020 regarding relative seniority.