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 16, 18, 11:25 am
  #166  
FlyerTalk Evangelist
 
Join Date: Feb 2004
Location: YVR
Programs: AC E75K 2MM former 14-year SE; UA MP Premier Silver; Marriott Bonvoy Lifetime Titanium Elite
Posts: 28,133
Originally Posted by Adam Smith View Post
I'm a man of many talents

I also did a lot of work in creating the spreadsheet, so it seems natural.
Yeah Adam, how dare you create this database for us. How dare you contribute to this forum unlike those who complain about your databases while contributing nothing!
yyznomad is offline  
Old Dec 17, 18, 1:56 am
  #167  
 
Join Date: Nov 2018
Programs: AC 50K
Posts: 89
I for one would like to thank Adam for his meticulous work which allows us who are not well versed in the ff world to have some what of a grasp on what it takes to earn one of those shiny tags
marchelli is offline  
Old Dec 29, 18, 9:47 am
  #168  
 
Join Date: Jan 2008
Location: YYJ (Victoria BC, Canada)
Programs: Aeroplan (SE100K, 1MM), Executive Club (bronze), SkyPass, Fairmont President's Club (Platinum)
Posts: 30
I join the chorus of thanks to Adam (and his occasional collaborators) for this exceptional tool. As 2018 draws to an end I found myself in the unenviable (or enviable?) position of having flown less than usual during the year due to having been based in Europe for a few months. I had to concoct a SE100K mileage run (my AQD was already way over the top, no trouble there) and with the help of the spreadshhet I determined that dinner in Charlottetown, Prince Edward Island (YYG) would just do the trick from my home base in Victoria, BC (YYJ) - a jump clear across Canada. The total from the spreadsheet for 3 hops each way was spot on; kudos for the Haversine calculator that divined exactly the missing official mileage YUL-YYG. The only thing that the tool could not predict was the amazing quality of the oysters I enjoyed close to midnight at The Gahan House in Charlottetown, PEI; highly recommended.

Huge thanks again, and a happy new year to everyone!

P.S. If anyone is about to make revisions to the spreadsheet (a single addition to the AQM table hardly seems worth it), YUL-YYG is 513 miles.
WaytoomuchEurope likes this.
robertoYYJ is offline  
Old Dec 30, 18, 5:56 am
  #169  
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,073
Thanks @robertoYYJ and others for the praise, although I would definitely emphasize the community nature of the project - the group who originally built the mileage table kicked it off, the cow and DrunkCargo built the haversine component, Jack built the simplified online version. It takes a village.

But I'm glad to hear that calculator has been so useful, it's good to know that the efforts are productive.

I'll add the YUL-YYG mileage when I do the next upload. Thanks for that
robertoYYJ likes this.
Adam Smith is offline  
Old Dec 30, 18, 6:56 am
  #170  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,851
I don't know how much credit I'd take for haversine. DC and I played around with it for a while trying to build something better than a spreadsheet, but that never got anywhere. He made it work in the spreadsheet.

One of these days I may actually build something web-based that can't be defaced through incompetence or malice.
canadiancow is online now  
Old Dec 30, 18, 7:45 am
  #171  
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,073
Originally Posted by canadiancow View Post
I don't know how much credit I'd take for haversine. DC and I played around with it for a while trying to build something better than a spreadsheet, but that never got anywhere. He made it work in the spreadsheet.
And yet when I credited him, didn't your nose get out of joint since you both worked on it?

One of these days I may actually build something web-based that can't be defaced through incompetence or malice.
If you do, great. If I knew anything about building anything on the Internet, I'd do it myself, but I'm just a simple 20th century finance guy, so Excel is all I know
robertoYYJ and canadiancow like this.
Adam Smith is offline  
Old Dec 30, 18, 6:14 pm
  #172  
FlyerTalk Evangelist
 
Join Date: Feb 2004
Location: YVR
Programs: AC E75K 2MM former 14-year SE; UA MP Premier Silver; Marriott Bonvoy Lifetime Titanium Elite
Posts: 28,133
Originally Posted by Adam Smith View Post
And yet when I credited him, didn't your nose get out of joint since you both worked on it?
Sometimes when you go cow tipping, the cow's butt can get hurt... I'm calling PETA on you. How dare you.
yyznomad is offline  
Old Dec 31, 18, 4:28 am
  #173  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,851
Okay I played around with some stuff, extracted the airport data from Jack's spreadsheet, and made a little API for Haversine calculations:

https://api.ft.canadiancow.com/aqd/h...estination=YYZ

It's not too useful on its own, but it's the beginnings of a web app for this.
Jumper Jack likes this.
canadiancow is online now  
Old Jan 15, 19, 1:07 am
  #174  
 
Join Date: Jan 2019
Programs: Aeroplan
Posts: 2
Hello All... new to this site... and the collecting miles game and trying to get a better understanding of it.

For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.

Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.

I believe I saw one on the internet a while back, but not able to find it anywhere!!!

Any help would be appreciated... and Happy Travelling!
TLtravel is offline  
Old Jan 15, 19, 2:36 am
  #175  
 
Join Date: Jun 2018
Location: YVR
Programs: AC SE100K, Bonvoy Gold Elite, IHG Gold
Posts: 1,377
Originally Posted by TLtravel View Post
Hello All... new to this site... and the collecting miles game and trying to get a better understanding of it.

For different Ticket Codes (l, m, etc.) Does anyone have a chart or a link that shows the Qualifying Miles received for Aeroplan accounts when flying different Star Alliance partners? I like getting the discounted prices but depending on the savings don't want to lose out on the miles as I am going for 100k this year.

Trying to figure it out for a Turkish Airline flight we are currently booking... but the question will continue to come up I am sure.

I believe I saw one on the internet a while back, but not able to find it anywhere!!!

Any help would be appreciated... and Happy Travelling!
I hope this is what you mean

https://www.aeroplan.com/earn_miles/...velPartners_EN
flyquiet likes this.
WaytoomuchEurope is offline  
Old Jan 15, 19, 5:02 pm
  #176  
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,073
Originally Posted by TLtravel View Post
Hello All... new to this site...
WayTooMuchEurope has answered your question, but welcome to FT!
Adam Smith is offline  
Old Jan 20, 19, 11:24 pm
  #177  
 
Join Date: Jan 2019
Programs: Aeroplan
Posts: 2
Thanks! Sometimes the answers are in the most obvious spots =]
TLtravel is offline  
Old Jan 24, 19, 6:53 pm
  #178  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,851
I only received 250 for KIX-HND which is the largest discrepancy I've ever seen from the other calculated distances.

Haversine shows 268, and it posted to UA (different traveler) at 278.
canadiancow is online now  
Old Jan 25, 19, 9:05 pm
  #179  
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,073
Bizarre. I wonder whether there's a way to write in to somebody about that; it's quite a large discrepancy.
Adam Smith is offline  
Old Jan 30, 19, 1:18 am
  #180  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 29,851
Step two of my web app:

https://api.ft.canadiancow.com/aqd/d...estination=HKG

It now returns the stored Aeroplan distance (or -1 if we don't have one), the Haversine distance, and the "distance" field will give you whatever you should use for calculations (i.e. Aeroplan if available).

This uses all the data from the spreadsheet. I don't know if this can be tied in to the spreadsheet, but it would eliminate all the slow calculations in the mileage table.

Next step will be some kind of form like the spreadsheet to actually calculate everything.
Santander and Bohemian1 like this.
canadiancow is online now  

Thread Tools
Search this Thread