Last edit by: Adam Smith
If you have general questions about how to earn SQM/SQS/SQD, please see the status qualification thread.
If you have received an incorrect amount of SQx/points, please see the thread on missing/incorrect flight activity.
Calculator for SQM, SQD, and Aeroplan points
SQM/SQD Cowculator and its source code
canadiancow's TODO list:
Adam Smith's TODO list:
If you have received an incorrect amount of SQx/points, please see the thread on missing/incorrect flight activity.
Calculator for SQM, SQD, and Aeroplan points
SQM/SQD Cowculator and its source code
canadiancow's TODO list:
- SAS Go Light fares
- Basic economy on any airline other than AC (is it just need a fare basis that ends in GT?)
- Ineligible codeshares, like EY-marketed, EY-operated, AC-ticketed
Adam Smith's TODO list:
- Add earning for VA
- Check earning rates for AC basic economy
Calculator for SQM, Aeroplan miles, & SQD
#47
Join Date: Dec 2010
Location: YQB
Programs: AC MM E50, AF Flying Blue
Posts: 572
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
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
#50
Moderator, Air Canada; FlyerTalk Evangelist
Original Poster
Join Date: Feb 2015
Location: YYC
Programs: AC SE MM, FB Plat, WS Plat, BA Silver, DL GM, Marriott Plat, Hilton Gold, Accor Silver
Posts: 16,765
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...
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.
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...
I've uploaded a new version to fix that, along with a couple other minor things.
#52
Join Date: Sep 2005
Programs: AC MM E50 , Former SPG, now Marriott LT Plat
Posts: 6,261
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.
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.
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.
#53
Join Date: Jul 2008
Location: YVR
Programs: OZ Diamond, Jiffypark Manhattan Gold
Posts: 4,485
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.
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.
#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,284
#56
Moderator, Air Canada; FlyerTalk Evangelist
Original Poster
Join Date: Feb 2015
Location: YYC
Programs: AC SE MM, FB Plat, WS Plat, BA Silver, DL GM, Marriott Plat, Hilton Gold, Accor Silver
Posts: 16,765
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.
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, 2016 at 5:48 pm
#58
Join Date: May 2016
Posts: 2,494
^
^ thanks for all the hard work!
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.
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.
#59
Join Date: Jan 2015
Location: YQB
Programs: AC SE100K-1MM, Bonvoy Gold, HHonors Diamond, VIA Premier, NEXUS/GE
Posts: 816
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.
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.