Originally Posted by
Chato
For someone in management I would think this is easy to get, for a regular line pilot you would probably have to go through ALPA to get specific attrition information and they usually take a long time to reply. I’ve had to email them several times on certain things until they eventually reply.
It sounds like you already did so why don't you tell us what he said. I do know of guys running their own list then again I don’t know how accurate this would be, prob don’t trust those numbers as they get not back up from the union like that one guy does.
Why the author hasn't shared his information with others, I don't know. But it is his prerogative to keep that to himself.
But why not do it yourself?
Easy: You get the movement from one seat to another and new hires from the flow plan, then you run a DECS script that runs a *4 for every pilot on the list and finds the people who has a RE/DE/RT in there. And then parse all these results into a .CSV file.
The flow date calculation is a simple excel formula.
The list could use additional features as well. You could run a 21 for everyone and see who has what line. That way it could list the junior lineholder for each seat.
Now that you know one way to do it, why won't you go ahead and take the project on? I can guarantee the Union would support you fully with this.