This spreadsheet puts mine to shame. Thanks.

A question for McFlyPHL: When I enter "bonus" miles from iDine, AA mastercard, etc - in column H - "Other Bonus" - I get the #N/A in the Flight Miles column and a bunch of others. I think it happens because the description I put into City Pairs column isn't an actual city pair (nor is it listed on the city pair tab).

The result is that the Q Miles in Col. K is #NA as well, and this interferes with YTD Q miles calculations.

Am I doing something wrong? Or is this fixable? No way can I fix this myself! (if it's not me messing it up to begin with)


Go Eagles.