FlyerTalk Forums - View Single Post - Calculator for SQM, Aeroplan miles, & SQD
Old Oct 27, 2022 | 12:00 am
  #590  
Adam Smith
Moderator, Air Canada; FlyerTalk Evangelist
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE MM, FB Plat, WS Plat, BA Silver, Marriott Plat, Hilton Gold, Accor Gold
Posts: 18,943
Originally Posted by YSJ8ed
I'd offer to update this minor mileage info myself but there is a much higher likelihood I'd ruin the entire database as I essentially have no idea what I'd be doing.
That's okay, I'll use my l33t h4x0r sk1llz to do it

YSJ-YUL 381 (same, but I think this is the 'new' number already given the ",,381")
Yes, someone has given us 381 from the new program. You're confirming that it was also 381 in the Before Times?

YFC-YUL 349
Is this the old distance, the new one, or both?

YCD-YVR 250 (same as YYJ but didn't spot this particular pair so thought I'd include it)
We only store the real distances in here. The 250 only applies to those who have status, so the calculator has an override that bumps up the distance on any <250-mile routes for people with status. So the old YYJ-YVR distance, for instance, was 38. We're missing a lot of them, since we don't get a lot of people (a) with no status and (b) flying on >=100%-earning fares reporting data

Thanks to everyone who helps little flyers like me learn and plan and organize. This thread and others, it is greatly appreciated. Cheers!!
Thanks for your contribution to this project! While [MENTION=599574]canadiancow[/MENTION] did the vast majority of the work on the current iteration, the original database that I based the Excel calculator on was compiled by many FTers, and people continued to supply distances and functionality, then the cow took some of the data and used a bit of the logic of how I'd built the Excel version to build a much better online version. So the more people participating, the better these things tend to become
Adam Smith is offline