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

New & improved Calculator for AQM, Aeroplan miles & AQD

New & improved Calculator for AQM, Aeroplan miles & AQD

    Hide Wikipost
Old Dec 15, 18, 12:57 am   -   Wikipost
Please read: This is a community-maintained wiki post containing the most important information from this thread. You may edit the Wiki once you have been on FT for 90 days and have made 90 posts.
 
Last edit by: Adam Smith
Wiki Link
Full Feature Version
Excel version (for downloading to your own computer)

Simplified/Beginner Version (Google Sheet Version Click Here)
- Offers quick, simple search
- File is partially locked en ensure core functionality and consistency in UX
Print Wikipost

Old Dec 3, 17, 8:22 pm
  #106  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,946
Can you show me exactly where the code is that calculates the haversine distance?
canadiancow is online now  
Old Dec 3, 17, 8:51 pm
  #107  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,564
Originally Posted by canadiancow View Post
Can you show me exactly where the code is that calculates the haversine distance?
I didnt even knew what that was until I googled it, is that some thing that's needed or?
Jumper Jack is offline  
Old Dec 3, 17, 9:15 pm
  #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.

Last edited by Braindrain; Dec 3, 17 at 11:38 pm
MmmYeahBabe is offline  
Old Dec 3, 17, 10:40 pm
  #109  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor Platinum, Hilton/Radisson/NH Gold
Posts: 6,100
Originally Posted by Seat13F_AC_CRJ View Post
Added new airports ANU, PTP, KIN, MBJ. Added mileage to YYZ and/or YUL. Added some mileages from IST to SIN, BKK.
Since some jackass keeps vandalizing the sheet, would you mind just posting them here?

Originally Posted by canadiancow View Post
@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 /
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.

Originally Posted by canadiancow View Post
Can you show me exactly where the code is that calculates the haversine distance?
Column I on the calculator sheet.

Last edited by Braindrain; Dec 3, 17 at 11:39 pm Reason: Personal attack
Adam Smith is offline  
Old Dec 3, 17, 10:47 pm
  #110  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,564
Originally Posted by Adam Smith View Post
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.
Hey adam, can you restore it then give me full edit power(but lock everyone else out). I will lock the cells in except few enterable parts then reopen the full version.
Jumper Jack is offline  
Old Dec 3, 17, 10:53 pm
  #111  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor Platinum, Hilton/Radisson/NH Gold
Posts: 6,100
Originally Posted by Jumper Jack View Post
Hey adam, can you restore it then give me full edit power(but lock everyone else out). I will lock the cells in except few enterable parts then reopen the full version.
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.
Adam Smith is offline  
Old Dec 3, 17, 11:41 pm
  #112  
 
Join Date: Jun 2003
Location: YVR
Programs: AC E75, SPG Plat, HH peon-by-choice (ex Gold)
Posts: 8,090
Everyone, let's keep out the personal attacks.

Thanks
MmmYeahBabe likes this.
Braindrain is offline  
Old Dec 3, 17, 11:43 pm
  #113  
Suspended
 
Join Date: Nov 2017
Location: mmm yeah babe
Programs: mmm yeah babe
Posts: 13
Originally Posted by Braindrain View Post
Everyone, let's keep out the personal attacks.
Thank you, I appreciate the voice of reason.
Look forward to using the calculator via Excel download.
MmmYeahBabe is offline  
Old Dec 3, 17, 11:43 pm
  #114  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,946
Originally Posted by Adam Smith View Post
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.
canadiancow is online now  
Old Dec 4, 17, 12:00 am
  #115  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,564
Originally Posted by canadiancow View Post
Jumper Jack is offline  
Old Dec 4, 17, 4:13 am
  #116  
 
Join Date: May 2005
Location: YOW
Programs: AC*SE100K BA-S HH-D IHG-Plat Accor-G MR-S
Posts: 3,481
Originally Posted by Adam Smith View Post
Since some jackass keeps vandalizing the sheet, would you mind just posting them here?
No problem. From my 2017 flying, here goes:
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
Seat13F_AC_CRJ is online now  
Old Dec 6, 17, 3:04 pm
  #117  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,564
Fixed the problems with the simplified version after further vandalization, should be operational again.
Jumper Jack is offline  
Old Dec 11, 17, 12:14 pm
  #118  
 
Join Date: Sep 2009
Location: YYZ
Programs: AC S100K, SPG G, Hilton G,Nexus/GE, Amex MR Plat, Hyatt Plat,IHG Plat E
Posts: 3,564
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, 17 at 8:11 am
vernonc is offline  
Old Dec 14, 17, 8:11 am
  #119  
 
Join Date: Sep 2009
Location: YYZ
Programs: AC S100K, SPG G, Hilton G,Nexus/GE, Amex MR Plat, Hyatt Plat,IHG Plat E
Posts: 3,564
Originally Posted by vernonc View Post
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.
Anyone ?
vernonc is offline  
Old Dec 14, 17, 8:36 am
  #120  
 
Join Date: Mar 2001
Location: Toronto, ON
Programs: AC*A
Posts: 4,831
Here's a few more to add:

YYZ-CPH: 3894
DUS-CPH: 384
LHR-STR: 468
YYZ-EDI: 3321
YYZ-GLA: 3283
ChrisA330 is online now  

Thread Tools
Search this Thread