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
#107
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,953
#108
Suspended
Join Date: Nov 2017
Location: mmm yeah babe
Programs: mmm yeah babe
Posts: 13
Two things:
1. I have looked multiple times today, and each time there are pornographic images and vulgar language posted in either of the links.
2. All of the mileage is messed up on the non-simplified one. Not sure about you, but last I checked YVR-YYZ was not over 10K miles.
1. I have looked multiple times today, and each time there are pornographic images and vulgar language posted in either of the links.
2. All of the mileage is messed up on the non-simplified one. Not sure about you, but last I checked YVR-YYZ was not over 10K miles.
Last edited by Braindrain; Dec 3, 2017 at 11:38 pm
#109
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,775
@Jumper Jack, do you know if the spreadsheet could be updated to query a MySQL database instead of using that mileage table? I have one that I made a long time ago, and it should be fairly easy to import updated values.
[...]
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
[...]
And I was too frustrated by that discrepancy to continue /
[...]
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
[...]
And I was too frustrated by that discrepancy to continue /
Column I on the calculator sheet.
Last edited by Braindrain; Dec 3, 2017 at 11:39 pm Reason: Personal attack
#110
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,953
Since some jackass keeps vandalizing the sheet, would you mind just posting them here?
Your fears are overblown. Using AQM distances has been accurate within fractions of a percentage point in every case that I've tried, as long as one has the correct amount for AQD. Also, when I've challenged them a couple of times on itineraries, they've showed me their math and they use the AQM distance. Maybe that's only for manual verification or re-calculation cases, but the bottom line is that this works just fine.
Column I on the calculator sheet.
The sheet wouldn't have pornographic images and vulgar language in it if you didn't keep putting them in there.
Your fears are overblown. Using AQM distances has been accurate within fractions of a percentage point in every case that I've tried, as long as one has the correct amount for AQD. Also, when I've challenged them a couple of times on itineraries, they've showed me their math and they use the AQM distance. Maybe that's only for manual verification or re-calculation cases, but the bottom line is that this works just fine.
Column I on the calculator sheet.
The sheet wouldn't have pornographic images and vulgar language in it if you didn't keep putting them in there.
#111
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,775
Jack, don't worry about it. I'm going to make some tweaks and lock it down then upload again. For now, I'll probably just take down the Sheets version and those who really want to use it can just use the Excel file.
#113
Suspended
Join Date: Nov 2017
Location: mmm yeah babe
Programs: mmm yeah babe
Posts: 13
#114
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,345
#115
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,953
#116
Join Date: May 2005
Location: YOW
Programs: AC-SE100K MM, BA-S HH-D, MB-G LT Sil, IHG-Plt, Nexus, Global Entry
Posts: 3,803
SJU-YYZ: 1915
YUL-PTP: 2138
ANU-YYZ: 2110
ARN-BRU: 800
FRA-LHR: 406
YOW-DCA: 452
DCA-CLE: 309
LHR-IST: 1561
IST-SIN: 5382
KUL-BKK: 749
BKK-IST: 4646
YYZ-MBJ: 1743
KIN-YYZ: 1787
--
13F
#118
Join Date: Sep 2009
Location: YYZ
Programs: AC SE MM, Bonvoy Plat, Hilton G,Nexus, Amex MR Plat,IHG Plat
Posts: 4,428
Anyone know the actual AQM for YYZ-BOM. Calc shows 7763. Flying in J and want to know the AQM as I am close to a Threshold.
Last edited by vernonc; Dec 13, 2017 at 8:11 am
#119
Join Date: Sep 2009
Location: YYZ
Programs: AC SE MM, Bonvoy Plat, Hilton G,Nexus, Amex MR Plat,IHG Plat
Posts: 4,428