https://1drv.ms/x/s!Aqzmds6j4G4gjB43ZihCjXewHvXZ
Updated with Jay's new memo, included a total of what they are staffing for (planning) v what they have (total=bidlist+in pipeline). Keep in mind the numbers are based off the ISL only, and if someone doesn't pass or takes 75 hours of IOE to complete their upgrade they will appear in the calc, but not really appear.
Updated Winter numbers so those will reflect from this winter (used Jan and March, Jan was still split NY base so compiled as best as I could). ATL 200 March Reserve levels were wild, so after looking at Feb and April I decided to use the April reserve levels to mimic a real staffing model. ATL-2 might be suffering from lower than realistic reserve levels on the calc for winter. JFK-2 has opposite problem as everyone abandons ship.
Summer numbers are kind of updated, they should be reliable; used May and July.
PM me for corrections or additions there were some MAJOR overhauls this time it's possible there is a function call is to the wrong cell and I didn't see it.
Next time, I hope I get to add a RJ85 MSP column. I've said too much already. Only airplane propelled by 5 APU's!
PLEASE PM, do not reply on thread.