IPA furloughs gone for five years
#72
[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
#73
[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.
#74
[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
#75
[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.
#78
Gets Weekends Off
Joined APC: Jul 2007
Position: 744 CA
Posts: 4,772
I guess im depressed then.....LOL
Good Luck Guys!!
Good Luck Guys!!
#79
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.
#80
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