theUpsideDown

https://1drv.ms/x/s!Aqzmds6j4G4gjBph36mEa3DxrIcF

After 18-01, with separations from CLR accounted for (assuming I wasn't completely lazy and sloppy)

when 18-02 comes out there will be a new ISL and that'll get plugged in for a cleaned up sheet.

theUpsideDown

https://1drv.ms/x/s!Aqzmds6j4G4gjBxinunv_mJZ2Q29

New update for SL calc. I will go back through last 3 months and redo averages for winter flying possibly. NYC for CA is weird, we continue to have way more captains than planning said they wanted, obviously there will be some attrition but it's more likely whatever new airplanes are coming will go to NYC or theyll be hoping NYC CA's (and FO's I suppose) will bail out of NY base for wherever new planes land.

Remember, DON'T use your bid number, use your number off the newly published SL from vacancy.

Casualinterest

As always, thank you

Sent from my SM-G950U using Tapatalk

theUpsideDown

https://1drv.ms/x/s!Aqzmds6j4G4gjB32iDeWAJ7Ffmgg

No excuse why so late, I didn't even see the vacancy was out. Hopefully everyone is getting used to their new bases or new place in their old base due to the MSP 2 closure.

I took off the memo projection line because we're getting beyond that point, hopefully they'll get us more information soon and I would incorporate that. I did not redo the historic reserve averages for winter, I'd suggest you keep it on summer numbers with the understanding the ATL (and possibly all base) averages might be as low as last summer. By next bid I'll have some ambition, I promise (*fingers crossed*)

Remember, DON'T use your monthly bid pack number, use the number off the newly published seniority list.

old72

Thank you for posting this

theUpsideDown

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.

Avroman

Those guys would forge birth certificates and stay until 80 if that happened.

theUpsideDown

https://1drv.ms/x/s!Aqzmds6j4G4gjxvJGCMwW2TpFc5w

Read notes. Make sure you put in your number from published seniority list part of 1805 vac, not from bid packet or anywhere else.

Good luck, fill out your bid cards.

Notes: with cdo/cnos going away i dont know if my historic averages are all junk now. Its a small vacancy, when we get another one i might redo averages.

KaiserSoze

You Sir, are a Rock Star!!!

theUpsideDown

This was really only intended for the MSP pilots dealing with their 200 base closing, i wanted to return the favor because someone did it for us MEM pilots. Ive been a little surprised the usage really hasnt gone down a lot, so I'll keep doing them.