Originally Posted by
Bohemian1
Any other significant mods I made to the excellent original spreadsheets were mostly around correctly calculating Altitude/Aeroplan miles based on fare class which should not impact the route-specific mileage table.
I actually did take what you had built on that front and add on to it somewhat. I got bogged down in handling the exceptions - it's relatively simple to create the basic table, but hard to automate the handling of all those weird one-offs, e.g. LH has one chart for intra-Europe, another for international, while NZ has one for domestic, one for Tasman, and another for international.
But I guess that I can just throw up a flag and let people go look those up themselves. It should enable most of them to be automated and only require manual input for a few, whereas right now it's 100% manual.
I'll do that in the next few days.