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
Jan 4, 2023, 2:57 pm
#616
Join Date: Dec 2012
Location: YHZ
Programs: AE*SE, *AGold, UA Silver, Marriott Bonvoy Titanium, Hilton Gold, Hertz PC
Posts: 61
Is there a primer on how to look up what route data is still needing updates? I may have a few odd routes last year and I already have a spreadsheet so I could easily look up what I have and contribute anything useful.
Last edited by Adam Smith; Jan 4, 2023 at 5:54 pm Reason: Remove off topic content
Jan 4, 2023, 2:58 pm
#617
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,353
There's nothing to gain by registering for this. It's open source, it's freely available.
Jan 4, 2023, 5:44 pm
#618
Join Date: Dec 2012
Location: YHZ
Programs: AE*SE, *AGold, UA Silver, Marriott Bonvoy Titanium, Hilton Gold, Hertz PC
Posts: 61
Here are my DPs from 2022:
EWR-YUL 330
LHR-YHZ2866 2846 (Standard fare reported 1423 SQM)
LIS-YUL 3249
LIS-YYZ 3562
NRT-YVR 4674
NRT-YYZ 6415
SCL-YYZ 5332
SFO-YVR 800
SFO-YYZ 2259
YHZ-YOW 592 (740 sqm on Lat - B fare)
Edit: SFO and SCL were award fares so my spreadsheet wasn't from my AP activity history. NRT was a PY fare and when I double-checked the numbers the current calculator is correct.
EWR-YUL 330
LHR-YHZ
LIS-YUL 3249
LIS-YYZ 3562
NRT-YYZ 6415
SFO-YYZ 2259
YHZ-YOW 592 (740 sqm on Lat - B fare)
Edit: SFO and SCL were award fares so my spreadsheet wasn't from my AP activity history. NRT was a PY fare and when I double-checked the numbers the current calculator is correct.
Last edited by cwhitt; Jan 12, 2023 at 5:42 pm Reason: Corrected SQM
Jan 4, 2023, 5:51 pm
#619
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,353
I don't have time to check this right now, but both your SFO-xxx numbers are wrong.
Last edited by Adam Smith; Jan 4, 2023 at 5:56 pm Reason: Remove off topic content
Jan 4, 2023, 6:05 pm
#621
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,353
Jan 4, 2023, 6:06 pm
#622
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,778
Jan 7, 2023, 8:13 pm
#624
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,353
Jan 8, 2023, 11:47 am
#625
Join Date: Dec 2012
Location: YHZ
Programs: AE*SE, *AGold, UA Silver, Marriott Bonvoy Titanium, Hilton Gold, Hertz PC
Posts: 61
Sorry, all. I thought I was being helpful, but clearly made several mistakes. NRT flights were PY fares. I thought I had taken the actual SQM and divided out the COS bonus, but clearly I did not (I must have left the GCMap numbers in my spreadsheet). YVR-NRT 4656 and NRT-YYZ 6391 matches what's in the calculator. I'll be more careful in the future.
Last edited by cwhitt; Jan 8, 2023 at 12:00 pm
Jan 8, 2023, 12:07 pm
#626
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,778
Indeed you are correct. That was an award trip and I forgot that I just copied the gcmap number into my spreadsheet. Speaking of which, the SCL numbers will be wrong too. I think those are the only two award trips in my list, but I'll double-check. I thought about screen-capping distances from my AP history but decided not to. That was perhaps a mistake (I'll edit my post to strike those out and verify the rest separately)
Sorry, all. I thought I was being helpful, but clearly made several mistakes. NRT flights were PY fares. I thought I had taken the actual SQM and divided out the COS bonus, but clearly I did not (I must have left the GCMap numbers in my spreadsheet). YVR-NRT 4656 and NRT-YYZ 6391 matches what's in the calculator. I'll be more careful in the future.
Sorry, all. I thought I was being helpful, but clearly made several mistakes. NRT flights were PY fares. I thought I had taken the actual SQM and divided out the COS bonus, but clearly I did not (I must have left the GCMap numbers in my spreadsheet). YVR-NRT 4656 and NRT-YYZ 6391 matches what's in the calculator. I'll be more careful in the future.
Jan 8, 2023, 6:23 pm
#627
Join Date: Aug 2019
Location: Montreal & Nashville
Programs: Aeroplan SE100K, Accor Platinum, Bonvoy Titanium Elite, BW Diamond, Hertz President's Circle
Posts: 391
Anything without a value in the "distance" column in https://github.com/scottkennedy/ac-a..._distances.csv
YUL-MEX AC995 1,152 miles
MTY-IAH UA6037 411 miles
IAH-YUL QK8948 791 miles
BRU-BIO SN3711 314 miles
BIO-FRA LH1147 357 miles
Jan 9, 2023, 3:08 am
#628
Join Date: Feb 2003
Location: FRA
Programs: AC SE 1MM, UA 1K, Hilton Lifetime Diamond, Marriott Gold Elite, Hertz PC
Posts: 2,943
Jan 9, 2023, 6:26 pm
#630
Join Date: Aug 2019
Location: Montreal & Nashville
Programs: Aeroplan SE100K, Accor Platinum, Bonvoy Titanium Elite, BW Diamond, Hertz President's Circle
Posts: 391
Ah yes, my bad! I usually never book out of flex except that time I called in instead of doing online an forgot to tell them...