Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Air Canada | Aeroplan
Reload this Page >

Calculator for SQM, Aeroplan miles, & SQD

Community
Wiki Posts
Search
Old Jul 25, 2021, 6:09 pm
FlyerTalk Forums Expert How-Tos and Guides
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:
  • 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
Print Wikipost

Calculator for SQM, Aeroplan miles, & SQD

Thread Tools
 
Search this Thread
 
Old Apr 3, 2023, 12:07 am
  #676  
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
Small change. The GitHub repository is now at https://github.com/cowtool-llc/ac-sqd.

cowtool will continue to provide the hosting, and this is still an open source project (I should probably throw a license up there). I just wanted to get it off my personal account since it shares resources with the rest of cowtool.
canadiancow is offline  
Old Apr 3, 2023, 6:51 am
  #677  
 
Join Date: Feb 2020
Location: YYZ
Programs: AC SE MM, BW Diamond Select
Posts: 706
RDU-YUL and FLL-YYZ - new SQMs

RDU-YUL is 712 miles (a new one!) and FLL-YYZ is now 1215 miles.

😀
Adam Smith likes this.

Last edited by TTC900Rocket; Apr 3, 2023 at 7:50 am
TTC900Rocket is online now  
Old Apr 4, 2023, 9:06 am
  #678  
 
Join Date: Dec 2022
Posts: 385
YUL-NRT 6425 SQM
The 6434 in the calculator is (currently, at the time of posting) based on Haversine.
Adam Smith and TTC900Rocket like this.
JacFlyer is offline  
Old Apr 5, 2023, 6:23 pm
  #679  
 
Join Date: Mar 2023
Location: YDF
Programs: AC 50K
Posts: 99
YHZ-YDF, Flex Q, 415 SQM. Haversine was correct.
Adam Smith likes this.
salteen is offline  
Old Apr 5, 2023, 6:37 pm
  #680  
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
Originally Posted by salteen
YHZ-YDF, Flex Q, 415 SQM. Haversine was correct.
Does AC actually fly that route anymore, or is this an indication that the calculator also correctly handled a PAL segment?
Adam Smith is offline  
Old Apr 5, 2023, 6:50 pm
  #681  
 
Join Date: Mar 2023
Location: YDF
Programs: AC 50K
Posts: 99
Originally Posted by Adam Smith
Does AC actually fly that route anymore, or is this an indication that the calculator also correctly handled a PAL segment?
This was on AC8022. They're still flying it!
Adam Smith likes this.
salteen is offline  
Old Apr 5, 2023, 6:56 pm
  #682  
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
So I "feel" like I've had to adjust per-segment SQD in my spreadsheet by a dollar a lot.

Unfortunately, so many of my flights are FP bookings, so I don't actually have historical records of what the actual base fare was.

But if anyone has noticed this, where the calculator says you'll earn $100 but you end up with $99 or $101, I'd really appreciate knowing your base fare, surcharges, routing, and what you actually received, per segment.

I'm going to keep an eye out going forward.
canadiancow is offline  
Old Apr 5, 2023, 6:59 pm
  #683  
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
Originally Posted by canadiancow
So I "feel" like I've had to adjust per-segment SQD in my spreadsheet by a dollar a lot.

Unfortunately, so many of my flights are FP bookings, so I don't actually have historical records of what the actual base fare was.

But if anyone has noticed this, where the calculator says you'll earn $100 but you end up with $99 or $101, I'd really appreciate knowing your base fare, surcharges, routing, and what you actually received, per segment.

I'm going to keep an eye out going forward.
Some idiot probably botched the rounding calculations.
canadiancow likes this.
Adam Smith is offline  
Old Apr 5, 2023, 7:05 pm
  #684  
 
Join Date: Mar 2023
Location: YDF
Programs: AC 50K
Posts: 99
Originally Posted by canadiancow
So I "feel" like I've had to adjust per-segment SQD in my spreadsheet by a dollar a lot.

Unfortunately, so many of my flights are FP bookings, so I don't actually have historical records of what the actual base fare was.

But if anyone has noticed this, where the calculator says you'll earn $100 but you end up with $99 or $101, I'd really appreciate knowing your base fare, surcharges, routing, and what you actually received, per segment.

I'm going to keep an eye out going forward.
I would offer for my segment above, but it was booked by my employer in USD. I imagine the USD to CAD conversion would complicate things?
Adam Smith likes this.
salteen is offline  
Old Apr 5, 2023, 7:06 pm
  #685  
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
Originally Posted by salteen
I would offer for my segment above, but it was booked by my employer in USD. I imagine the USD to CAD conversion would complicate things?
Yeah, it needs to be booked in CAD or all bets are off.
canadiancow is offline  
Old Apr 5, 2023, 8:37 pm
  #686  
 
Join Date: Feb 2003
Location: FRA
Programs: AC SE 1MM, UA 1K, Hilton Lifetime Diamond, Marriott Gold Elite, Hertz PC
Posts: 2,943
FRA-SFO is now 5677 (was 5685).
Adam Smith likes this.

Last edited by ACflyerDE; Apr 5, 2023 at 8:42 pm
ACflyerDE is offline  
Old Apr 6, 2023, 6:51 am
  #687  
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
Originally Posted by canadiancow
So I "feel" like I've had to adjust per-segment SQD in my spreadsheet by a dollar a lot.

Unfortunately, so many of my flights are FP bookings, so I don't actually have historical records of what the actual base fare was.

But if anyone has noticed this, where the calculator says you'll earn $100 but you end up with $99 or $101, I'd really appreciate knowing your base fare, surcharges, routing, and what you actually received, per segment.

I'm going to keep an eye out going forward.
Okay with one example from me and three from Adam, I think AC always rounds SQD up to the next dollar, whether it's xx.01 or xx.99.

If no one objects to that in the next while, I'll push a change.
canadiancow is offline  
Old Apr 6, 2023, 9:19 am
  #688  
 
Join Date: Sep 2015
Posts: 1,190
Originally Posted by canadiancow
Okay with one example from me and three from Adam, I think AC always rounds SQD up to the next dollar, whether it's xx.01 or xx.99.

If no one objects to that in the next while, I'll push a change.
I have some examples that I can share too if you still want it. The main holdup is that I've deleted some of the booking emails so will need to go mine for fare info. Some are FP bookings.
vancouver25k is offline  
Old Apr 6, 2023, 2:50 pm
  #689  
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
At this point I wouldn't mind a few more that were off by a dollar, but a few that were correct would be useful too. I just want to make sure my test cases cover enough before I'm confident my "fix" actually fixes everything.
canadiancow is offline  
Old Apr 6, 2023, 6:53 pm
  #690  
 
Join Date: Dec 2011
Location: YYZ
Programs: AC SEMM / HH Diamond
Posts: 3,167
Originally Posted by canadiancow
So I "feel" like I've had to adjust per-segment SQD in my spreadsheet by a dollar a lot.

Unfortunately, so many of my flights are FP bookings, so I don't actually have historical records of what the actual base fare was.

But if anyone has noticed this, where the calculator says you'll earn $100 but you end up with $99 or $101, I'd really appreciate knowing your base fare, surcharges, routing, and what you actually received, per segment.

I'm going to keep an eye out going forward.
The problem is that AC seems to have botched the SQD calculation engine so badly that I don't trust any of their numbers anymore.

My last flight shows an SQD of 862 in the calculator - a number that exactly matches my own calculation based on the fare paid - and AC have granted me just 619 for that flight. I plan to email them about it (as is my new routine) but that whole issue & process makes the verification of the FT calculator, very hard.
canopus27 is offline  


Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.