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 2, 2017, 8:57 pm
#91
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
Dec 2, 2017, 9:00 pm
#92
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,317
Dec 2, 2017, 9:03 pm
#93
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
Or.... Do we still need the full original version by Adam? As it is my understanding his frustration lies the fact the sheet gets broken all the time(which is addressed through my simplified version with locked cells).
Just thinking out loud here.
Dec 2, 2017, 9:04 pm
#94
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,317
Dec 3, 2017, 7:11 am
#96
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
What's with all of the obscene entries in both spreadsheets. I tried to clean up the simplified version, but it took forever. Hope I didn't break it.
--
13F
--
13F
Dec 3, 2017, 9:40 am
#97
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,765
I've uploaded new versions of both the Excel and Google Sheets "classic" calculators to fix that.
Dec 3, 2017, 12:43 pm
#98
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
As far as everything goes, as long as the intent is not malicious, the simplified version should be working 99.99% of the time.
Dec 3, 2017, 12:43 pm
#99
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
Whoever it was did that, I am very disappointed in you.
We are better than this, You can be better than that.
We are better than this, You can be better than that.
Last edited by Jumper Jack; Dec 3, 2017 at 3:37 pm
Dec 3, 2017, 4:03 pm
#101
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,317
I feel like I have a mostly-finished web-based AQM (not AQD) database somewhere from yesteryear. Maybe it could be tied in to the spreadsheet.
Dec 3, 2017, 6:40 pm
#102
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,317
Updated NRT-SFO (in both) to 5115.
I did notice that the simplified one has missing values from the mileage table. For example, NRT-SIN.
I did notice that the simplified one has missing values from the mileage table. For example, NRT-SIN.
Dec 3, 2017, 7:33 pm
#103
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
Update: Actually on a second thought I decided to lock the milage sheet to ensure it wont be tampered with, I granted access to Cow and will be updating the entries on my own, but if you are on FT for over one year and is in good standing with the community, PM me your email and I will grant access the milage table as well. Otherwise, as people comment on this thread with their additions, it will be updated on mine sheet promptly
Last edited by Jumper Jack; Dec 3, 2017 at 7:39 pm
Dec 3, 2017, 7:52 pm
#104
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,317
@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.
Honestly, I think making a website that can't be tampered with would be much better (and not very difficult), and I was somewhat close to getting it done at one point.
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
For example, you could have:
A-B 1000 AQM $1000 AQD
B-C 500 AQM $490 AQD
And I was too frustrated by that discrepancy to continue
Edit: I don't remember the last time I worked on this, but... http://flyertalk.canadiancow.com/acmileage/
Honestly, I think making a website that can't be tampered with would be much better (and not very difficult), and I was somewhat close to getting it done at one point.
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
For example, you could have:
A-B 1000 AQM $1000 AQD
B-C 500 AQM $490 AQD
And I was too frustrated by that discrepancy to continue
Edit: I don't remember the last time I worked on this, but... http://flyertalk.canadiancow.com/acmileage/
Dec 3, 2017, 7:56 pm
#105
Join Date: Jan 2016
Location: YYZ
Programs: Only J via Peasant Points, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,951
@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.
Honestly, I think making a website that can't be tampered with would be much better (and not very difficult), and I was somewhat close to getting it done at one point.
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
For example, you could have:
A-B 1000 AQM $1000 AQD
B-C 500 AQM $490 AQD
And I was too frustrated by that discrepancy to continue
Honestly, I think making a website that can't be tampered with would be much better (and not very difficult), and I was somewhat close to getting it done at one point.
The issue that stopped me was that the distances that AC uses for AQD is different than what is used for AQM.
For example, you could have:
A-B 1000 AQM $1000 AQD
B-C 500 AQM $490 AQD
And I was too frustrated by that discrepancy to continue
I could make out some of his code, but not all.
I think I am actually interested in taking a crack at this after my last exam on the 15th