Originally Posted by adam.smith

Thanks to the help of DrunkCargo, who did most of the work, I've made some substantial changes to the calculator. It now includes a database of most, if not all, of the commercial airports you could ever fly to on *A and a formula that will automatically calculate distances for any where the official Aeroplan distance is not in the database.

That means no more needing to go to a source like WebFlyer or gcmap for missing distances! I think you'll agree that this makes the tool much more practical and useful.

I hope people find this helpful.

Link to Google Sheets version
Link to Excel version - in case you prefer to download and use on your own device (my preference, since Google Sheets is very limited in functionality)

Although the calculator now handles most of this stuff automatically, it would still be appreciated if people wanted to share distances for city pairs that aren't in the database.