Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Air Canada | Aeroplan
Reload this Page >

New & improved Calculator for AQM, Aeroplan miles & AQD

New & improved Calculator for AQM, Aeroplan miles & AQD

    Hide Wikipost
Old Dec 15, 18, 12:57 am   -   Wikipost
Please read: This is a community-maintained wiki post containing the most important information from this thread. You may edit the Wiki once you have been on FT for 90 days and have made 90 posts.
 
Last edit by: Adam Smith
Wiki Link
Full Feature Version
Excel version (for downloading to your own computer)

Simplified/Beginner Version (Google Sheet Version Click Here)
- Offers quick, simple search
- File is partially locked en ensure core functionality and consistency in UX
Print Wikipost

Reply

Old Feb 6, 16, 9:26 pm
  #1  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,847
New & improved Calculator for AQM, Aeroplan miles & AQD

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.

Last edited by Adam Smith; Dec 11, 16 at 7:29 pm Reason: Uploaded new version
Adam Smith is offline  
Reply With Quote
Old Feb 6, 16, 9:34 pm
  #2  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,529
Just some feedback on the actual calculator, maybe have the AQD input field actually built into each flight segment
Jumper Jack is offline  
Reply With Quote
Old Feb 6, 16, 9:39 pm
  #3  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,847
Originally Posted by Jack Jia View Post
Just some feedback on the actual calculator, maybe have the AQD input field actually built into each flight segment
The purpose of the calculator is to allocate the AQD between segments of a multi-segment itinerary paid all at once (which I think is more of a problem for people than allocating AQD on one-segment tickets), which means you should only input it once, which is how it's built now.

This isn't meant as a running tally for all of your future flying, it's a tool to estimate mileage and AQD from a given itinerary. If you want to calculate the AQD for multiple itineraries, just run through the calculator multiple times.

Last edited by Adam Smith; Feb 6, 16 at 10:20 pm
Adam Smith is offline  
Reply With Quote
Old Feb 6, 16, 10:11 pm
  #4  
FlyerTalk Evangelist
 
Join Date: Sep 2014
Programs: AC SE100K, 1MM, NH, DL, AA, GE/Nexus, APEC..
Posts: 15,281
Originally Posted by adam.smith View 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.....

1. Outstanding effort and thank you adam.smith !

2. "Given AC's unwillingness or inability to provide AQM and AQD before booking..."

.
24left is offline  
Reply With Quote
Old Feb 6, 16, 10:28 pm
  #5  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,847
I've just thought of an issue. My formula allocates AQD based on the distances credited by Aeroplan. This shouldn't make a meaningful difference for most itineraries, even if the mileage AC uses for that purpose is slightly different, but there could be some distortion for itineraries with flights <250 miles, since AC presumably uses actual distance for splitting AQD, rather than the 250-mile minimum.

Problems for solving this are:
  • We don't know the actual distance AC uses for these (although we can get a close approximation).
  • Even if we did, off the top of my head, it would require essentially duplicating the table and the formulae, which seems extremely inefficient for something that's a pretty minor issue.

Unless someone else has a bright idea, it may not be worth putting a lot of effort into dealing with this issue given how few itineraries it should affect.

Originally Posted by 24left View Post
Outstanding effort and thank you adam.smith ! .
Thanks!

Last edited by Adam Smith; Feb 7, 16 at 11:04 am Reason: Corrected typo
Adam Smith is offline  
Reply With Quote
Old Feb 7, 16, 10:44 am
  #6  
Original Member
 
Join Date: May 1998
Location: Vancouver, Canada
Posts: 6,126
Wirelessly posted (Mozilla/5.0 (BlackBerry; U; BlackBerry 9780; en-US) AppleWebKit/534.8+ (KHTML, like Gecko) Version/6.0.0.666 Mobile Safari/534.8+)

Originally Posted by adam.smith
I've just thought of an issue. My formula allocates AQD based on the distances credited by Aeroplan. This shouldn't make a meaningful distance for most itineraries, even if the mileage AC uses for that purpose is slightly different, but there could be some distortion for itineraries with flights <250 miles, since AC presumably uses actual distance for splitting AQD, rather than the 250-mile minimum.

Problems for solving this are:
  • We don't know the actual distance AC uses for these (although we can get a close approximation).
  • Even if we did, off the top of my head, it would require essentially duplicating the table and the formulae, which seems extremely inefficient for something that's a pretty minor issue.

Unless someone else has a bright idea, it may not be worth putting a lot of effort into dealing with this issue given how few itineraries it should affect.

Originally Posted by 24left View Post
Outstanding effort and thank you adam.smith ! .
Thanks!
Typo?

"This shouldn't make a meaningful difference?
KenHamer is offline  
Reply With Quote
Old Feb 7, 16, 10:46 am
  #7  
Original Member
 
Join Date: May 1998
Location: Vancouver, Canada
Posts: 6,126
Wirelessly posted (Mozilla/5.0 (BlackBerry; U; BlackBerry 9780; en-US) AppleWebKit/534.8+ (KHTML, like Gecko) Version/6.0.0.666 Mobile Safari/534.8+)

Originally Posted by 24left
Originally Posted by adam.smith View 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.....

1. Outstanding effort and thank you adam.smith !

2. "Given AC's unwillingness or inability to provide AQM and AQD before booking..."

.
Someone forgot to add "or both".

Nevertheless, an excellent resource!
KenHamer is offline  
Reply With Quote
Old Feb 7, 16, 10:55 am
  #8  
FlyerTalk Evangelist
 
Join Date: Sep 2014
Programs: AC SE100K, 1MM, NH, DL, AA, GE/Nexus, APEC..
Posts: 15,281
Originally Posted by adam.smith View Post
Given AC's unwillingness or inability to provide AQM and AQD before booking (or any time before having flown the itinerary).......
(bolding mine)


Meanwhile.....in "post-game" adventures, where AC cannot even manage to post a flight on their own ticket and their own metal......


24left is offline  
Reply With Quote
Old Feb 7, 16, 11:06 am
  #9  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,847
Originally Posted by KenHamer View Post
Typo?

"This shouldn't make a meaningful difference?
Yes, thanks, I fixed it.
Adam Smith is offline  
Reply With Quote
Old Feb 7, 16, 11:35 am
  #10  
 
Join Date: Jan 2015
Location: YQB
Programs: AC SE100K-1MM, Marriott Gold, HHonors Diamond, VIA Premier, NEXUS/GE
Posts: 743
Wow thank you adam.smith for creating this. Great resource for sure
DNAwizard is offline  
Reply With Quote
Old Feb 7, 16, 8:56 pm
  #11  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,847
Link to Excel version added (up in the original post) for those who prefer to use that version (Google Sheets messes some stuff up).
Adam Smith is offline  
Reply With Quote
Old Feb 8, 16, 9:36 am
  #12  
 
Join Date: Jul 2009
Location: YWG
Programs: Free Agent
Posts: 1,326
thanks for the effort! this is what makes FT a community.
canolakid is offline  
Reply With Quote
Old Feb 8, 16, 9:46 am
  #13  
 
Join Date: Oct 2009
Location: YUL
Programs: AC*E50 (*A Gold), Accor Platinum, Bonvoy Gold Elite, Hilton Gold, Amex Platinum, NEXUS, Global Entry
Posts: 5,274
Awesome spreadsheet, thanks so much!
ffsim is offline  
Reply With Quote
Old Feb 8, 16, 9:51 am
  #14  
 
Join Date: Jun 2009
Programs: Air Canada Aeroplan
Posts: 1,710
Thanks! (And nice mention in The Globe and Mail today).
Mauricio23 is offline  
Reply With Quote
Old Feb 8, 16, 10:12 am
  #15  
 
Join Date: Oct 2009
Location: YUL
Programs: AC*E50 (*A Gold), Accor Platinum, Bonvoy Gold Elite, Hilton Gold, Amex Platinum, NEXUS, Global Entry
Posts: 5,274
Originally Posted by Mauricio23 View Post
(And nice mention in The Globe and Mail today).
I dunno, our Mr. Smith flies far, far more than the dude they mentioned in the article

Smith, who flies more than 100,000 kilometres a year...
ffsim is offline  
Reply With Quote

Thread Tools
Search this Thread