Jul 25, 2021, 6:09 pm
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
Dec 16, 2018, 11:25 am
#166
FlyerTalk Evangelist
Join Date: Feb 2004
Location: YVR
Programs: AC SE 2MM; UA MP Premier Silver; Marriott Bonvoy LT Titanium Elite; Radisson; Avis PC
Posts: 35,255
Dec 29, 2018, 9:47 am
#168
Join Date: Jan 2008
Location: YYJ (Victoria BC, Canada)
Programs: Aeroplan (SE100K, 1MM), Executive Club, SkyPass, Accor Live Limitless (Gold)
Posts: 35
I join the chorus of thanks to Adam (and his occasional collaborators) for this exceptional tool. As 2018 draws to an end I found myself in the unenviable (or enviable?) position of having flown less than usual during the year due to having been based in Europe for a few months. I had to concoct a SE100K mileage run (my AQD was already way over the top, no trouble there) and with the help of the spreadshhet I determined that dinner in Charlottetown, Prince Edward Island (YYG) would just do the trick from my home base in Victoria, BC (YYJ) - a jump clear across Canada. The total from the spreadsheet for 3 hops each way was spot on; kudos for the Haversine calculator that divined exactly the missing official mileage YUL-YYG. The only thing that the tool could not predict was the amazing quality of the oysters I enjoyed close to midnight at The Gahan House in Charlottetown, PEI; highly recommended.
Huge thanks again, and a happy new year to everyone!
P.S. If anyone is about to make revisions to the spreadsheet (a single addition to the AQM table hardly seems worth it), YUL-YYG is 513 miles.
Huge thanks again, and a happy new year to everyone!
P.S. If anyone is about to make revisions to the spreadsheet (a single addition to the AQM table hardly seems worth it), YUL-YYG is 513 miles.
Dec 30, 2018, 5:56 am
#169
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,764
Thanks @robertoYYJ and others for the praise, although I would definitely emphasize the community nature of the project - the group who originally built the mileage table kicked it off, the cow and DrunkCargo built the haversine component, Jack built the simplified online version. It takes a village.
But I'm glad to hear that calculator has been so useful, it's good to know that the efforts are productive.
I'll add the YUL-YYG mileage when I do the next upload. Thanks for that
But I'm glad to hear that calculator has been so useful, it's good to know that the efforts are productive.
I'll add the YUL-YYG mileage when I do the next upload. Thanks for that
Dec 30, 2018, 6:56 am
#170
A FlyerTalk Posting Legend
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, BA Gold, SQ Silver, Bonvoy Tit LTG, Hyatt Glob, HH Diamond
Posts: 44,314
I don't know how much credit I'd take for haversine. DC and I played around with it for a while trying to build something better than a spreadsheet, but that never got anywhere. He made it work in the spreadsheet.
One of these days I may actually build something web-based that can't be defaced through incompetence or malice.
One of these days I may actually build something web-based that can't be defaced through incompetence or malice.
Dec 30, 2018, 7:45 am
#171
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,764
One of these days I may actually build something web-based that can't be defaced through incompetence or malice.
Dec 30, 2018, 6:14 pm
#172
FlyerTalk Evangelist
Join Date: Feb 2004
Location: YVR
Programs: AC SE 2MM; UA MP Premier Silver; Marriott Bonvoy LT Titanium Elite; Radisson; Avis PC
Posts: 35,255
Dec 31, 2018, 4:28 am
#173
A FlyerTalk Posting Legend
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, BA Gold, SQ Silver, Bonvoy Tit LTG, Hyatt Glob, HH Diamond
Posts: 44,314
Okay I played around with some stuff, extracted the airport data from Jack's spreadsheet, and made a little API for Haversine calculations:
https://api.ft.canadiancow.com/aqd/h...estination=YYZ
It's not too useful on its own, but it's the beginnings of a web app for this.
https://api.ft.canadiancow.com/aqd/h...estination=YYZ
It's not too useful on its own, but it's the beginnings of a web app for this.
Jan 15, 2019, 1:07 am
#174
Join Date: Jan 2019
Programs: Aeroplan
Posts: 2
Hello All... new to this site... and the collecting miles game and trying to get a better understanding of it.
For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.
Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.
I believe I saw one on the internet a while back, but not able to find it anywhere!!!
Any help would be appreciated... and Happy Travelling!
For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.
Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.
I believe I saw one on the internet a while back, but not able to find it anywhere!!!
Any help would be appreciated... and Happy Travelling!
Jan 15, 2019, 2:36 am
#175
Join Date: Jun 2018
Location: YVR
Programs: AC SE100K, Bonvoy Platinum Elite, IHG Gold, Hertz 5*
Posts: 2,132
Hello All... new to this site... and the collecting miles game and trying to get a better understanding of it.
For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.
Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.
I believe I saw one on the internet a while back, but not able to find it anywhere!!!
Any help would be appreciated... and Happy Travelling!
For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.
Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.
I believe I saw one on the internet a while back, but not able to find it anywhere!!!
Any help would be appreciated... and Happy Travelling!
https://www.aeroplan.com/earn_miles/...velPartners_EN
Jan 15, 2019, 5:02 pm
#176
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,764
Jan 24, 2019, 6:53 pm
#178
A FlyerTalk Posting Legend
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, BA Gold, SQ Silver, Bonvoy Tit LTG, Hyatt Glob, HH Diamond
Posts: 44,314
I only received 250 for KIX-HND which is the largest discrepancy I've ever seen from the other calculated distances.
Haversine shows 268, and it posted to UA (different traveler) at 278.
Haversine shows 268, and it posted to UA (different traveler) at 278.
Jan 25, 2019, 9:05 pm
#179
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,764
Bizarre. I wonder whether there's a way to write in to somebody about that; it's quite a large discrepancy.
Jan 30, 2019, 1:18 am
#180
A FlyerTalk Posting Legend
Join Date: Sep 2012
Location: SFO
Programs: AC SE MM, BA Gold, SQ Silver, Bonvoy Tit LTG, Hyatt Glob, HH Diamond
Posts: 44,314
Step two of my web app:
https://api.ft.canadiancow.com/aqd/d...estination=HKG
It now returns the stored Aeroplan distance (or -1 if we don't have one), the Haversine distance, and the "distance" field will give you whatever you should use for calculations (i.e. Aeroplan if available).
This uses all the data from the spreadsheet. I don't know if this can be tied in to the spreadsheet, but it would eliminate all the slow calculations in the mileage table.
Next step will be some kind of form like the spreadsheet to actually calculate everything.
https://api.ft.canadiancow.com/aqd/d...estination=HKG
It now returns the stored Aeroplan distance (or -1 if we don't have one), the Haversine distance, and the "distance" field will give you whatever you should use for calculations (i.e. Aeroplan if available).
This uses all the data from the spreadsheet. I don't know if this can be tied in to the spreadsheet, but it would eliminate all the slow calculations in the mileage table.
Next step will be some kind of form like the spreadsheet to actually calculate everything.