IPA furloughs gone for five years
03-10-2009 | 08:10 AM
#72
Gets Weekends Off
Joined: Mar 2006
Posts: 266
Likes: 0
[QUOTE=Roberto;575345]The counts are pretty easy, after you've pasted the 01Feb09 Seniority List into Excel. Change the text to columns, and then sort by age.[QUOTE]
Thanks Roberto...pretty slick. I did that, sorted the list and then wrote a formula for an extra column to display the current age of each pilot based on DOB and current date.
B2P
Thanks Roberto...pretty slick. I did that, sorted the list and then wrote a formula for an extra column to display the current age of each pilot based on DOB and current date.
B2P
03-10-2009 | 08:48 AM
#73
Gets Weekends Off
Joined: Jan 2007
Posts: 579
Likes: 0
From: 757/767
[quote=b2pilot186;575790][quote=Roberto;575345]The counts are pretty easy, after you've pasted the 01Feb09 Seniority List into Excel. Change the text to columns, and then sort by age.
Thanks Roberto...pretty slick. I did that, sorted the list and then wrote a formula for an extra column to display the current age of each pilot based on DOB and current date.
B2P
I've also got the 09-201 Seniority List converted to Excel, but I don't know where I can post it as an attachment since the old IPA forum went down. I don't like the company lists with the crewmembers in two side-by-side columns as it takes a while to format, cut and paste into one column. It took me about 3 hours for 09-201.
Thanks Roberto...pretty slick. I did that, sorted the list and then wrote a formula for an extra column to display the current age of each pilot based on DOB and current date.
B2P
Last edited by Roberto; 03-10-2009 at 09:06 AM.
03-10-2009 | 09:59 AM
#74
Gets Weekends Off
Joined: Mar 2006
Posts: 266
Likes: 0
[QUOTE=Roberto;575826][quote=b2pilot186;575790]
I hear ya...I tried it with that list myself but the delimiters couldn't make it look pretty without a lot of work...seems like it took some serioius time on your part to do it. Need to ask KH about attachments on the new forum board.
B2P
The counts are pretty easy, after you've pasted the 01Feb09 Seniority List into Excel. Change the text to columns, and then sort by age.
I've also got the 09-201 Seniority List converted to Excel, but I don't know where I can post it as an attachment since the old IPA forum went down. I don't like the company lists with the crewmembers in two side-by-side columns as it takes a while to format, cut and paste into one column. It took me about 3 hours for 09-201.
I've also got the 09-201 Seniority List converted to Excel, but I don't know where I can post it as an attachment since the old IPA forum went down. I don't like the company lists with the crewmembers in two side-by-side columns as it takes a while to format, cut and paste into one column. It took me about 3 hours for 09-201.
B2P
03-10-2009 | 10:30 AM
#75
Gets Weekends Off
Joined: Jan 2007
Posts: 579
Likes: 0
From: 757/767
[quote=b2pilot186;575883][quote=Roberto;575826]For those lists, I use Other for the delimeter and type in a space. That separates the columns nicely but then you have to delete all the extra cells in persons names that have more than two words, and then shift left to get them all to line up. (On reserve on the DC8 gives me plenty of time to do all this...)
Last edited by Roberto; 03-10-2009 at 10:42 AM.
03-10-2009 | 12:38 PM
#77
Gets Weekends Off
Joined: Mar 2005
Posts: 2,702
Likes: 0
From: 767 captain
repeat message
Last edited by 767pilot; 03-10-2009 at 05:03 PM.
03-10-2009 | 12:50 PM
#78
Gets Weekends Off
Joined: Jul 2007
Posts: 4,772
Likes: 1
From: 744 CA
I guess im depressed then.....LOL
Good Luck Guys!!
Good Luck Guys!!
03-10-2009 | 01:03 PM
#79
Line Holder
Joined: May 2005
Posts: 889
Likes: 0
From: Retired FDX MD11 Capt
Don't despair guys. I know of a man who immigrated to the US from Kenya as a child and despite having a zero balance in his debit account just seven short years ago and never in his life holding a nine to five job, he has managed to gain employment in a very high executive position. He is many times a millionaire now and even has several private jets.
Hard work and honesty can get us where we want to go!
Hard work and honesty can get us where we want to go!
BTW-
Illinois is now issuing BHO license plates.
03-10-2009 | 01:09 PM
#80
Proponent of Hysteria
Joined: Mar 2005
Posts: 1,052
Likes: 0
From: 3B
Only he didn't actually immigrate from Kenya, did he? I thought his father was Kenyan but that he was born in Hawaii. Couldn't immigrate and hold the office. Of course, we probably won't know the full story until 2017.
Thread
Thread Starter
Forum
Replies
Last Post
Jayps078
Regional
16
01-30-2009 08:15 PM
