Placekicker From United States of America, joined Apr 2008, 22 posts, RR: 0 Posted (4 years 3 months 1 week 1 day 8 hours ago) and read 3309 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,
0NEWAIR0 From United States of America, joined May 2007, 836 posts, RR: 0 Reply 1, posted (4 years 3 months 1 week 1 day 6 hours ago) and read 3267 times:
Simairlinenet From United States of America, joined Oct 2005, 813 posts, RR: 2 Reply 2, posted (4 years 3 months 1 week 1 day 6 hours ago) and read 3242 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.
0NEWAIR0 From United States of America, joined May 2007, 836 posts, RR: 0 Reply 3, posted (4 years 3 months 1 week 1 day 6 hours ago) and read 3216 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."
MOBflyer From United States of America, joined Sep 2007, 1209 posts, RR: 5 Reply 4, posted (4 years 3 months 1 week 1 day 6 hours ago) and read 3197 times:
Timz From United States of America, joined Sep 1999, 6468 posts, RR: 8 Reply 5, posted (4 years 3 months 1 week 1 day 6 hours ago) and read 3194 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.
Viscount724 From Switzerland, joined Oct 2006, 21488 posts, RR: 24 Reply 6, posted (4 years 3 months 1 week 1 day 5 hours ago) and read 3147 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.
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.
DeltAirlines From United States of America, joined May 1999, 8771 posts, RR: 13 Reply 7, posted (4 years 3 months 1 week 1 day 5 hours ago) and read 3121 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.
Sponsor Message: 
From United States of America, joined Apr 2008, 22 posts, 
From Switzerland, joined Oct 2006, 21488 posts, 
Printer friendly format 
