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 7, 2020, 8:36 am
#196
Join Date: Jan 2020
Location: BOS
Programs: AC SE (P); Marriott Plat; Accor Plat; KQ Plat
Posts: 76
Hi,
According to Aeroplan, Turkey would be intra, Israel and Jordan would be rest of world.
Also, here are some AQM missing in the spreadsheet:
Also, here are some AQM missing in the spreadsheet:
CAI MUC 1628 (MS)
FCO CAI 1333 (MS)
IAH PBC 773 (UA)
VIE CPT 5676 (OS)
FRA MRS 482 (LH; 241 credited as intraEU in Y are at 50%)
FCO CAI 1333 (MS)
IAH PBC 773 (UA)
VIE CPT 5676 (OS)
FRA MRS 482 (LH; 241 credited as intraEU in Y are at 50%)
Last edited by GeekyFlyer; Jan 7, 2020 at 8:43 am
Jan 7, 2020, 10:08 am
#197
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,213
I took a couple of stabs at that and pretty much gave up due to the arbitrary definitions of geographic zones by carrier (CX for example). Glad you may have it sorted. Just in time for the 'new' Aeroplan!
Jan 7, 2020, 12:14 pm
#199
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,741
I hadn't even checked the Aeroplan pages on mileage earning before posting that. Thanks 
Also, here are some AQM missing in the spreadsheet:
I won't add FRA-MRS though, since the true number could be 481 or 482.
Jan 11, 2020, 10:16 am
#200
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,741
New version uploaded. All mileage earning, including the weird exceptions (e.g. AC domestic, AV's intra-Central America, TP LIS-OPO, etc), should now be automatic.
I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.
I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.
I hope this is helpful for people.
If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.
I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.
I hope this is helpful for people.
If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
Jan 11, 2020, 10:33 am
#201
Join Date: Mar 2008
Programs: AC SE MM, Marriott Titanium
Posts: 904
Last edited by YVRtoYYZ; Jan 11, 2020 at 11:07 am
Jan 11, 2020, 10:44 am
#202
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,741
Adam Smith Appreciate your efforts
Jan 11, 2020, 10:50 am
#203
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,213
I just had a quick look and there is a TON of heavy lifting in there just to accommodate all of the weird regional and fare-based earning rates that defy easy rules.
Kudos to Adam for upping this tool to a new level!
Kudos to Adam for upping this tool to a new level!
Jan 11, 2020, 12:53 pm
#205
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,741
Jan 11, 2020, 1:00 pm
#206
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,302
New version uploaded. All mileage earning, including the weird exceptions (e.g. AC domestic, AV's intra-Central America, TP LIS-OPO, etc), should now be automatic.
I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.
I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.
I hope this is helpful for people.
If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.
I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.
I hope this is helpful for people.
If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
Jan 11, 2020, 1:01 pm
#207
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,741
Jan 16, 2020, 8:30 pm
#209
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
Going to try and update the simplified calculator to the updated data source as well this weekend.
Update: Hmm... seems completely broken now. May have pushed Google Sheets to its limit? Gonna take my version offline now.
Update: Hmm... seems completely broken now. May have pushed Google Sheets to its limit? Gonna take my version offline now.
Last edited by Jumper Jack; Jan 18, 2020 at 1:40 pm
Feb 14, 2020, 6:30 pm
#210
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,741
New version uploaded with a bunch of new mileage data and a few small fixes.