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 Apr 16, 16, 2:23 pm
  #46  
 
Join Date: Aug 2012
Programs: AC Altitude E50K (*G), NEXUS
Posts: 4,013
Since you are only supposed to edit the blue cells, shouldn't the fare be blue?
flyquiet is offline  
Reply With Quote
Old Apr 24, 16, 10:08 am
  #47  
 
Join Date: Dec 2010
Location: YQB
Programs: AC SEMM
Posts: 481
AQMs on short domestic flights in Flex on AC

Hi all,

I have lost track of all the changes to Aeroplan AQM earnings. How many AQMs do we get for short domestic flights (<250 miles) in Flex on AC (express)? Not sure if it is real distance or 250... I know this is written somewhere, so sorry about asking!

Thanks,

R&F
run&fly is offline  
Reply With Quote
Old Apr 24, 16, 11:05 pm
  #48  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
If you have status, 250.
canadiancow is online now  
Reply With Quote
Old Apr 25, 16, 7:48 am
  #49  
 
Join Date: Dec 2010
Location: YQB
Programs: AC SEMM
Posts: 481
Originally Posted by canadiancow View Post
If you have status, 250.
OK, thanks for taking the time to respond. Thought that there was something with status. R&F
run&fly is offline  
Reply With Quote
Old May 19, 16, 11:29 pm
  #50  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
For the record, I've been using this calculator now on my own travels for several months and am finding that it's generally allocating the AQD down to within a few cents, sometimes exactly on the nose, so for those frustrated with not knowing what their AQD is going to be, I think this is a good resource.

Of course, it depends on putting in the right data and not mucking around with the model, but that shouldn't be too difficult, there are detailed instructions in the Instructions tab...

Originally Posted by flyquiet View Post
Since you are only supposed to edit the blue cells, shouldn't the fare be blue?
I've sort of neglected this thread for a while and not really checked the uploaded version. Yes, unfortunately someone who was using the spreadsheet to calculate some stuff got rid of the blue font on the fare.

I've uploaded a new version to fix that, along with a couple other minor things.
Adam Smith is offline  
Reply With Quote
Old May 20, 16, 4:36 am
  #51  
 
Join Date: Apr 2015
Programs: AC SE 100K, Marriott Platinum, IHG Spire Ambassador
Posts: 10
Since I've been using this for a little while myself I thought I'd help out. I've added a couple of new airports and mileage.
DeathRabbit is offline  
Reply With Quote
Old May 20, 16, 4:43 am
  #52  
 
Join Date: Sep 2005
Programs: AC MM E50 , Former SPG, now Marriott LT Plat
Posts: 5,179
Originally Posted by adam.smith View Post
There's no generic number of AQD for any given route and I'm not claiming that there is. The calculator doesn't tell you how much AQD you're going to earn in total, it helps you figure out how much AQD will be allocated to each segment after you tell it exactly what fare you paid and what segments you're flying.

So, let's say you buy an RTW touching NRT, YVR, FRA and NRT. Whether you buy this as NRT-YVR-FRA-BKK-NRT or YVR-FRA-BKK-NRT-YVR, you're flying the same segments with the same mileage. That means AQD will be allocated roughly 26% to NRT-YVR, 28% YVR-FRA, 31% FRA-BKK and 16% BKK-NRT (whether you actually earn AQD on those flights depends on them being AC metal or AC codeshares ticketed on 014, but that's how the AQD will be allocated). That split will hold whether you buy the ticket originating in NRT for $8K, YVR for $15K, FRA for $250K or BKK for $1.

That's all the calculator does - allocate the total AQD you give it, based on whatever you paid, among the different flight segments.
Not quite.

I started one RTW ticket in Jan. that had a FRA-YYZ segement on AC
that I was credited $969.00 for. Last week, ON THE SAME TICKET, I flew
AC YYZ-SFO, and was credited $989.00.

The first flight was some 4000 miles, the second was some 2000 miles.
I have absolutely no idea how they are getting the AQD values.
IluvSQ is offline  
Reply With Quote
Old May 22, 16, 11:34 pm
  #53  
 
Join Date: Jul 2008
Location: YVR
Programs: OZ Diamond, Jiffypark Manhattan Gold
Posts: 3,895
Ok, so is there a place to dispute AQD?

I probably won't bother since I likely won't make status anyway, but I feel like I was overcredited to the tune of like 400% on a previous ticket which I now can't see in the history the AQD column simply says no available for every flight. But I just bought a YVR-SFO return in Flex on an EMCO which I believe we were told would be treated like cash when it came to bookings were we not? I got $11 for YVR-SFO. The total ticket cost was around $558, with the base fare around $425, so unless I'm going to be credited $300+ for SFO-YVR, which would make no sense, I can't figure out what's going on here.
drvannostren is offline  
Reply With Quote
Old May 23, 16, 11:09 am
  #54  
Suspended
 
Join Date: Jun 2009
Location: YYZ
Programs: AC E50K (*G) WS Gold | SPG/Fairmont Plat Hilton/Hyatt Diamond Marriott Silver | National Exec Elite
Posts: 19,285
Originally Posted by drvannostren View Post
Ok, so is there a place to dispute AQD?
Yes.

https://www.aircanada.com/en/aeropla.../aqd_form.html
superangrypenguin is offline  
Reply With Quote
Old May 25, 16, 12:05 pm
  #55  
 
Join Date: Jul 2008
Location: YVR
Programs: OZ Diamond, Jiffypark Manhattan Gold
Posts: 3,895
Thanks SAP, I looked around but kept getting directed to AP pages that didn't offer any help. Now I wait to see where my AQD shakes out on the return segment.
drvannostren is offline  
Reply With Quote
Old Nov 11, 16, 12:20 am
  #56  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
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 [old link deleted]
Link to Excel version [old link deleted] - 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.

Last edited by Adam Smith; Dec 11, 16 at 5:48 pm
Adam Smith is offline  
Reply With Quote
Old Nov 11, 16, 12:49 am
  #57  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Originally Posted by adam.smith View Post
Thanks to the help of DrunkCargo, who did most of the work
Wow
canadiancow is online now  
Reply With Quote
Old Nov 11, 16, 1:37 am
  #58  
 
Join Date: May 2016
Posts: 2,472
Originally Posted by adam.smith View Post
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.
thanks for all the hard work!
quantumofforce is offline  
Reply With Quote
Old Nov 11, 16, 7:17 am
  #59  
 
Join Date: Jan 2015
Location: YQB
Programs: AC SE100K-1MM, Marriott Gold, HHonors Diamond, VIA Premier, NEXUS/GE
Posts: 742
Originally Posted by adam.smith View Post
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.
Wow that's great. Thanks to both of you for all the work.
DNAwizard is offline  
Reply With Quote
Old Nov 11, 16, 8:09 am
  #60  
FlyerTalk Evangelist
 
Join Date: Sep 2014
Programs: AC SE100K, 1MM, NH, DL, AA, GE/Nexus, APEC..
Posts: 15,281
Originally Posted by DNAwizard View Post
Wow that's great. Thanks to both of you for all the work.
+1 and Thanks mucho!!!
24left is offline  
Reply With Quote

Thread Tools
Search this Thread