Seniority calculator
#11
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
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.
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.
#12
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
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.
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.
#13
Gets Weekends Off
Joined APC: May 2017
Posts: 1,793
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.
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.
Sent from my SM-G950U using Tapatalk
#14
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
Update May8
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.
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.
#16
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
Update July 7
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.
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.
#17
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.
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.
#18
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
1805
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.
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.
#19
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.
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.
#20
Gets Weekends Off
Thread Starter
Joined APC: Dec 2017
Posts: 2,767
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.
Thread
Thread Starter
Forum
Replies
Last Post
DLax85
Cargo
14
06-26-2008 03:26 PM