Originally Posted by McFlyPHL
I'm new to AA, and while fewmiles' spreadsheet was useful, it didn't quite do what I wanted it to. Since it's been snowing here all weekend, I whipped up my own version of the same idea.
It was a great exercise in learning the AAdvantage system - and I caught an error that cost me 382 miles and points. (AA fixes the miled, but the points are another story it seems).
Anywho, since I made it, I figured maybe some others here might find it useful as well, so I
posted it on the web. If anyone finds it usefule and/or has suggestions for how to improve it, please let me know.
This is great - I have an improvement suggestion though that might save time:
In the Flight Miles column (D), if you use this formula (example for row 19):
=IF(ISNA(VLOOKUP(C19,'City Pair Info'!$A$4:$B$53,2,FALSE)),VLOOKUP(RIGHT(C19,3)&"-"&LEFT(C19,3),'City Pair Info'!$A$4:$B$53,2,FALSE),VLOOKUP(C19,'City Pair Info'!$A$4:$B$53,2,FALSE))
Then you don't need to add both directions in the city pair worksheet - SFO-DFW will also work for DFW-SFO. This of course assumes that every city code is three characters and that the user enters exactly xxx-yyy with no spaces or other characters.
Hope that helps
Matt