WIKIPOST CREATED (December 11, 2016)
Scroll up to wiki for latest versions.
NEW VERSION UPLOADED (November 11, 2016)
I've uploaded a new version of the calculator that's substantially better. Details and new links in this post.
Original post:
--------------------------------------------------------------------------------------
Given AC's unwillingness or inability to provide AQM and AQD before booking (or any time before having flown the itinerary), I thought it might be useful to have an ability to forecast these things.
A few years ago, some FTers built an Excel database containing the Aeroplan-credited mileage between numerous AC/*A destinations (see
this thread).
I decided to expand on that idea, and that database, to build something more user-friendly and with more functionality.
This spreadsheet ([old link deleted]) will, with just a couple of inputs, calculate AQM, Aeroplan miles and AQD for a wide variety of routings that you feed it. (For those who would prefer to download the Excel version rather than access the Google Sheets version, use [old link deleted]).
New features relative to the previous data table:
- Calculator function which will give you both AQM and Aeroplan miles for one or multiple flights (up to 15 on a single itinerary). Unless you're adding or correcting data, there's no longer any need to scroll through the table itself.
- No longer requires entering data in both halves of the table - enter once and it's automatically mirrored.
There are a lot of routes for which we don't have data or that were subject to the old 500-mile minimum and now need updating. I may also have inadvertently killed some data that was only in one half of the previous spreadsheet (a lot of people weren't matching their columns and rows properly and putting data in the wrong cells).
Please feel free to fill things in, the more people contributing, the more this becomes an accurate and reliable resource.
There are some detailed instructions in the spreadsheet to hopefully keep this a clean and useful resource, so please follow them.
If you would like to contribute data but don't feel comfortable editing the spreadsheet yourself, or don't have time, or whatever, feel free to post mileages in this thread and I or someone else will update the spreadsheet.
I hope this will be helpful. Thoughts and feedback appreciated.
P.S. Google Sheets sucks. This file was built in Excel and I've had to spend a bunch of time trying to get it back to work out some of the kinks for using it in Sheets. The one thing I haven't gotten rid of is the #REF error in the Aeroplan Distance column, which makes absolutely no sense. The file is much easier to use in Excel, so feel free to download it and then upload a new version.