Sponsor Message:
Civil Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Distance - Excel File  
User currently offlinePlacekicker From United States of America, joined Apr 2008, 22 posts, RR: 0
Posted (5 years 6 months 1 week 2 days 14 hours ago) and read 4554 times:

Is there anywhere specific I can go to download, for free of charge, an Excel spreadsheet which gives the distance between the top 100 (busiest) airports (by ICAO code)?


Should anyone know of such a place, please let me know,


Thanks!

7 replies: All unread, jump to last
 
User currently offline0NEWAIR0 From United States of America, joined May 2007, 939 posts, RR: 0
Reply 1, posted (5 years 6 months 1 week 2 days 12 hours ago) and read 4512 times:

http://www.transtats.bts.gov/distance.asp

There is indeed an excel spreadsheet somewhere (I'm still searching for it). The link above may also help you though.



"The future belongs to those who believe in the beauty of their dreams."
User currently offlineSimairlinenet From United States of America, joined Oct 2005, 912 posts, RR: 2
Reply 2, posted (5 years 6 months 1 week 2 days 12 hours ago) and read 4487 times:

At work, we use an Excel add-in originally developed by Boeing that allows users to enter two airport codes and receive the GC distance between them. Obviously there's a big database behind it.

User currently offline0NEWAIR0 From United States of America, joined May 2007, 939 posts, RR: 0
Reply 3, posted (5 years 6 months 1 week 2 days 12 hours ago) and read 4461 times:

Well, I can't find the spreadsheet; however, for the most traveled US Domestic and Int'l routes you can download the T-100 Market data base to find out distances a little bit quicker. I know it's not exactly what you're asking for, but I tried.

Just select number of passengers, distance, origin, and destination when downloading and when you go to create a query add the "totals" function and select "sum" for passengers and "group by" for everything else.

[Edited 2009-02-14 16:23:12]


"The future belongs to those who believe in the beauty of their dreams."
User currently offlineMOBflyer From United States of America, joined Sep 2007, 1209 posts, RR: 4
Reply 4, posted (5 years 6 months 1 week 2 days 12 hours ago) and read 4442 times:

PM me your email. I'll send you one.

User currently offlineTimz From United States of America, joined Sep 1999, 6813 posts, RR: 7
Reply 5, posted (5 years 6 months 1 week 2 days 12 hours ago) and read 4439 times:

You would need to decide whether you want actual distance or the distance that IATA or some other entity is accustomed to using and prefers not to change. Like the link in Reply 1, which probably isn't intended to give true distance.

Quoting Simairlinenet (Reply 2):
Obviously there's a big database behind it.

A database of the lat-lons of each airport; wouldn't you guess that and the distance formulas would be the only data they'd bother with?


User currently offlineViscount724 From Switzerland, joined Oct 2006, 25117 posts, RR: 22
Reply 6, posted (5 years 6 months 1 week 2 days 11 hours ago) and read 4392 times:



Quoting Simairlinenet (Reply 2):
At work, we use an Excel add-in originally developed by Boeing that allows users to enter two airport codes and receive the GC distance between them. Obviously there's a big database behind it.

This site lets you do that easily.
http://gc.kls2.com/

Enter the desired routing (any number of points) in the box at top left and click the "Display Map" button. Can display the result in miles, nautical miles, or kilometers. Can use either IATA or ICAO airport codes, or latitude and longitude.


User currently offlineDeltAirlines From United States of America, joined May 1999, 8897 posts, RR: 12
Reply 7, posted (5 years 6 months 1 week 2 days 10 hours ago) and read 4366 times:



Quoting Viscount724 (Reply 6):
Enter the desired routing (any number of points) in the box at top left and click the "Display Map" button. Can display the result in miles, nautical miles, or kilometers. Can use either IATA or ICAO airport codes, or latitude and longitude.

Great Circle Mapper is great for getting the info, but not if you're working in Excel and want to do VLookups to pull information.


Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
B6 E190 Sets Distance Record ANC-BUF posted Fri Nov 7 2008 14:00:24 by Chumley
Pilots File Suit Vs US Airways posted Sat Sep 20 2008 13:03:16 by MKE22
Futura - Futura Gael File Bankruptcy Protection posted Sun Sep 7 2008 12:52:00 by Acelanzarote
Air Berlin To Reduce Long-distance Flights.. posted Thu May 29 2008 02:57:57 by Beaucaire
Mesa Admits It May Have To File For Bankruptcy posted Thu May 22 2008 07:03:37 by Apodino
Eos' Ex-Employees File Class Action Lawsuit posted Mon May 19 2008 06:37:48 by ThirteenRight
Bankruptcy: How An Airline Decides To File Ch 7 Or 11? posted Fri Apr 11 2008 05:00:14 by Tavong
Excel Airlines Aircraft Used To SSH? posted Tue Apr 1 2008 12:23:04 by BAMAN77
ExpressJet Fails To File Annual Report posted Wed Mar 19 2008 10:28:09 by LAXintl
Excel Airways DC-10 Gatwick-Sanford? posted Fri Feb 1 2008 11:24:26 by MIAMIx707