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
Oct 13, 2018, 2:10 pm
#151
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,953
Oct 15, 2018, 12:36 am
#152
Join Date: Jan 2018
Location: Windsor/Detroit
Programs: AC*SE, Wyndham Dimond, Marriott Plat, Amex Plat CND & USA, active military, Yoga teacher.
Posts: 148
Oct 15, 2018, 8:44 am
#153
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,331
Oct 15, 2018, 9:29 am
#154
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (It's the third house on the left)
Programs: AC*SE100K, wood level status in various other programs
Posts: 6,232
Nov 21, 2018, 7:38 pm
#155
Join Date: Jan 2005
Location: YOW
Programs: AC SEMM; AA,DL, Hyatt and Starwood. Ex-status:SQ PPS,CSA,Hilton,AA,UA
Posts: 743
Can anyone confirm AQM for the (soon-to-be-removed) direct YYZ-EZE flight.
The Google Sheets calculator gives a Haversine distance of 5584. The mileage table *queried* by the calculator gives 5573, but for some reason this doesn't pop up on the calculator tab. gcmap.com gives 5563, which is weird since usually AC cheats on the mileage versus gcmap. Anyone know from personal experience what gets credited?
(Trying to plan whether my wife needs to do some creative routings to get over 100K for the first time - having been my 50K nominee for about 5 years now. Of course, will build in a bit of leeway but would prefer to use as accurate info as possible and she has YYZ-EZE-YYZ upcoming already booked.)
Thanks!
The Google Sheets calculator gives a Haversine distance of 5584. The mileage table *queried* by the calculator gives 5573, but for some reason this doesn't pop up on the calculator tab. gcmap.com gives 5563, which is weird since usually AC cheats on the mileage versus gcmap. Anyone know from personal experience what gets credited?
(Trying to plan whether my wife needs to do some creative routings to get over 100K for the first time - having been my 50K nominee for about 5 years now. Of course, will build in a bit of leeway but would prefer to use as accurate info as possible and she has YYZ-EZE-YYZ upcoming already booked.)
Thanks!
Nov 29, 2018, 5:18 am
#156
Join Date: Jan 2005
Location: YOW
Programs: AC SEMM; AA,DL, Hyatt and Starwood. Ex-status:SQ PPS,CSA,Hilton,AA,UA
Posts: 743
Nov 29, 2018, 6:40 pm
#157
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,774
For flights where the data table has been populated, the data has almost always been accurate right to the mile (once I cleaned out a bunch of mistakes where people had put things in the wrong cell). I'm a bit surprised it was off by 1 in this case, but perhaps AC has changed it.
As for why EZE was in the data table but not pulled by the calculator, it turns out that there was a rogue space in the EZE header cell, which meant that typing "EZE" in the calculator tab didn't find any results since it was in the data table as " EZE" (or "EZE ", I forget which).
I've fixed that and will upload a new version in the next few days.
Also, people, if you're going to contribute to the data tab, great, but please be careful. For example, someone has added YYR to SFO mileage as 800. I'm sure this well-meaning person wanted to add the YVR to SFO mileage, but it's sloppiness like that that can muck the whole thing up. So feel free to just post in this thread and I'll update the sheet.
Nov 29, 2018, 8:04 pm
#158
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,331
I'd argue that if you think a COMMON route has missing data (i.e. YVR-SFO), then you're probably doing something wrong.
YYR-YQX, maybe. BOM-GOI, sure.
But YVR-SFO? You've entered a city wrong.
YYR-YQX, maybe. BOM-GOI, sure.
But YVR-SFO? You've entered a city wrong.
Dec 15, 2018, 8:58 am
#159
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,774
I've uploaded a new version that's back to working, after someone broke the sheet again.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
Dec 15, 2018, 9:07 am
#160
Join Date: Jun 2018
Location: YVR
Programs: AC SE100K, Bonvoy Platinum Elite, IHG Gold, Hertz 5*
Posts: 2,132
I've uploaded a new version that's back to working, after someone broke the sheet again.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
Now I'll just assume I'm the idiot that broke it.
Dec 15, 2018, 9:44 am
#161
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,774
Dec 15, 2018, 12:13 pm
#162
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (It's the third house on the left)
Programs: AC*SE100K, wood level status in various other programs
Posts: 6,232
I've uploaded a new version that's back to working, after someone broke the sheet again.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
I've taken down the Google Sheets version since people were consistently messing it up.
If you have any new distances, please post them in the thread here and I'll add them to the master version.
Thanks Adam!
The Google Sheets version has bee fubar for a while.
Dec 15, 2018, 3:23 pm
#163
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,774
Dec 15, 2018, 5:30 pm
#164
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (It's the third house on the left)
Programs: AC*SE100K, wood level status in various other programs
Posts: 6,232
Dec 15, 2018, 8:15 pm
#165
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,774
