Originally Posted by Adam Smith

New version uploaded. All mileage earning, including the weird exceptions (e.g. AC domestic, AV's intra-Central America, TP LIS-OPO, etc), should now be automatic.

I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.

I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.

I hope this is helpful for people.

If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.