FlyerTalk Forums - View Single Post - Calculator for SQM, Aeroplan miles, & SQD
Old Feb 6, 2016 | 10:28 pm
  #5  
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,944
I've just thought of an issue. My formula allocates AQD based on the distances credited by Aeroplan. This shouldn't make a meaningful difference for most itineraries, even if the mileage AC uses for that purpose is slightly different, but there could be some distortion for itineraries with flights <250 miles, since AC presumably uses actual distance for splitting AQD, rather than the 250-mile minimum.

Problems for solving this are:
  • We don't know the actual distance AC uses for these (although we can get a close approximation).
  • Even if we did, off the top of my head, it would require essentially duplicating the table and the formulae, which seems extremely inefficient for something that's a pretty minor issue.

Unless someone else has a bright idea, it may not be worth putting a lot of effort into dealing with this issue given how few itineraries it should affect.

Originally Posted by 24left
Outstanding effort and thank you adam.smith ! ^.
Thanks!

Last edited by Adam Smith; Feb 7, 2016 at 11:04 am Reason: Corrected typo
Adam Smith is offline