Nic Award Spreadsheet Anaysis Tool

[Pylit]

Useful analysis tool in excel with explanation on a PPT presentation.
Very illuminating. Select your number and check out the stats, then select the guy that's just senior to you on the merged list.
Numbers don't lie and these charts tell the tale.

Excel Analysis Tool

click on the link to download.

 

[Cactus737]

Useful analysis tool in excel with explanation on a PPT presentation.
Very illuminating. Select your number and check out the stats, then select the guy that's just senior to you on the merged list.
Numbers don't lie and these charts tell the tale.

Excel Analysis Tool

click on the link to download.

Very well done; impressive. You definitely get an A for effort, though I'd have to see your algorithms to verify validity. I trust it's pretty close.

Interesting results when I plugged in Colello's name. Mind you, he was on furlough on the date the merger was announced with no hope for a recall. It shows only a small marginal gain for him over the Nicloau award if the lists were NOT merged. Yet a date-of-hire list would be a HUGE gain for him.

Something that this chart doesn't account for is the fact that Colello was furloughed on the date the merger was announced, and had no hope for a recall. On the day the award came out, he was flying the 767 to Europe and has over 300 active pilots junior to him. Meanwhile, Dave Odell, the last AWA pilot ever hired, is still the junior active pilot on reserve on the B737.

 

[88 B.T.D.]

Interesting results when I plugged in Colello's name. Mind you, he was on furlough on the date the merger was announced with no hope for a recall. ....

Actually he was on property (US Certificate) and being paid by US Airways when the merger was announced, hence the legal argument for tossing the award.

 

[fly with US]

Interesting results when I plugged in Colello's name. Mind you, he was on furlough on the date the merger was announced with no hope for a recall.

Actually, he was an active mainline pilot on the day the merger was anounced...

 

[aquagreen73s]

Useful analysis tool in excel with explanation on a PPT presentation.
Very illuminating. Select your number and check out the stats, then select the guy that's just senior to you on the merged list.
Numbers don't lie and these charts tell the tale.

Excel Analysis Tool

click on the link to download.

The problem with your charts is that they look decades into the future and Nic was clearly not going to base his decision on such future speculation. Rather, Nic looked at what empirical facts existed at the time (namely jobs brought to the merger and types of aircraft) and went from there. There is a good reason he did this because if he had done what you suggest, Nic would have been awarding a tangible benefit in the present when there was no present right to that benefit (or no "equity" to justify/pay for that benefit). The only justification for the East to receive the benefit is based on pure projection and speculation; in other words you wanted to buy on credit. To make any award based on such speculation is not sound. Nor would it have been fair for either side. What he did was the better option which is to look at the snapshot for what it was, assumed no growth which is exactly what Parker was forecasting, and the result was a zippering of both seniority lists. It's not hard to understand Nic's reasoning. But it's a free country and a pilot need not agree with Nicolau. However, the AAA pilots did submit to his jurisdiction which means they are stuck with the award every bit as much as the West pilots.

Whatever "unfairness" the charts expose are not the fault of the AWA pilots. Rather, the fault lies with the recent history of AAA and the smashed expectations of anyone on that list. When you furlough 40% of your list, you cannot expect every pilot to realize their orgininal career expectations at the day they hired.

 

[Pylit]

Just to be clear...I did not create this stuff, just bringing it to the masses.

 

[Mike]

Just to be clear...I did not create this stuff, just bringing it to the masses.

Colello was an active USAirways pilot along with 400 or so other pilots flying for MidAtlantic. The company has admitted MidAtlantic was USAirways as well as ALPA saying the same. All pilots where there because they knew they would get recalled in a matter of time. Enough said. <_<

 

[JetMonkey]

Colello was an active USAirways pilot along with 400 or so other pilots flying for MidAtlantic. The company has admitted MidAtlantic was USAirways as well as ALPA saying the same. All pilots where there because they knew they would get recalled in a matter of time. Enough said. <_<

Ah! well then, you shouldn't be upset about the award, cause he's now flying a 767 with many below him. While our bottom guy is.....well, still on the bottom.

 

[Phoenix]

Colello was an active USAirways pilot along with 400 or so other pilots flying for MidAtlantic. The company has admitted MidAtlantic was USAirways as well as ALPA saying the same. All pilots where there because they knew they would get recalled in a matter of time. Enough said. <_<

Yes. They were Mainline pilots, and ALPA sent out many announcements of congratulations on their "return to Mainline" and "upon their recall".

Of course many of these pilot positions went junior while many people senior to them passed on the opportunity to return to Mainline. Hence the problem for Niky. To include them as active pilots would have required that furloughed pilots be placed ahead of AWA pilots, rather than having them all stapled.

But of course this whole conundrum of a Mainline airline that sucked so bad that many pilots passed on the opportunity... well it happened under the watch of dear ALPA... sorta like the situation now where most ALPA pilots are not accepting recall to ALPA "Mainline" jobs.