I don't travel for business anymore, but I still do a bunch for personal and fun, so I decided to keep maintaining status. However, this has necessitated a few mileage runs, and last year I didn't do the math until so late in the year, I spent Christmas in Vegas.
So I decided to make a spreadsheet so that I would always know where I was/will be.
First try was to take the ARPT.DAT out of the old Flying Fish program and calculate distance using various Great Circle formulas that I found throughout the web. However, I kept getting slight differences between the formulas and the AA / IATA distance (ORD-MCO was 1006 instead of 1005 and PHL-DUB was 3263 instead of 3273).
Then I got directed to this thread and was able to use the table of AA city pairs from one of the spreadsheets posted above. However, its from 2005 and especially with the US merger, there are tons of routes missing.
So... A) Anyone have any idea why none of these formulas work and all are slightly off base? The source data is from Flying Fish and that gets the right distance, so it's something in the calculation.
=3958*((2*ASIN(SQRT((SIN((RADIANS(H10)-RADIANS(J10))/2)^2)+ COS(RADIANS(H10))*COS(RADIANS(J10))* (SIN((RADIANS(I10)-RADIANS(K10))/2)^2)))))
=ACOS(COS(RADIANS(90-H10)) *COS(RADIANS(90-J10)) +SIN(RADIANS(90-H10)) *SIN(RADIANS(90-J10)) *COS(RADIANS(I10-K10))) *3958
=ACOS( SIN(H10*PI()/180)*SIN(J10*PI()/180) + COS(H10*PI()/180)*COS(J10*PI()/180)*COS(K10*PI()/180-I10*PI()/180) ) * 6371000 * 0.000621371
Or... B) Does anyone have an updated AA route chart, or something scrapable to create one with all the new routes?
