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 Jan 18, 20, 5:41 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: Jumper Jack
Wiki Link
Full Feature Version
Excel version (for downloading to your own computer)
Print Wikipost

Old Jan 7, 20, 9:36 am
  #196  
 
Join Date: Jan 2020
Location: YOW
Programs: AC 75K; Marriott Gold
Posts: 2
Hi,

Originally Posted by Adam Smith View Post
Does anyone know how LH treats things like Turkey, Israel, Jordan, etc, for the purposes of the intra-European flights? Are those European or rest of world?
According to Aeroplan, Turkey would be intra, Israel and Jordan would be rest of world.

Also, here are some AQM missing in the spreadsheet:
CAI MUC 1628 (MS)
FCO CAI 1333 (MS)
IAH PBC 773 (UA)
VIE CPT 5676 (OS)
FRA MRS 482 (LH; 241 credited as intraEU in Y are at 50%)

Last edited by GeekyFlyer; Jan 7, 20 at 9:43 am
GeekyFlyer is offline  
Old Jan 7, 20, 11:08 am
  #197  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (Wave as you fly over)
Programs: AC*SE100K, wood level status in various other programs
Posts: 2,878
Originally Posted by Adam Smith View Post
Okay, so, I think I've figured out how to automate all the exceptions, pretty much.
That would be awesome.

I took a couple of stabs at that and pretty much gave up due to the arbitrary definitions of geographic zones by carrier (CX for example). Glad you may have it sorted. Just in time for the 'new' Aeroplan!
canadiancow likes this.
Bohemian1 is online now  
Old Jan 7, 20, 1:01 pm
  #198  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,249
Originally Posted by Bohemian1 View Post
Just in time for the 'new' Aeroplan!
Oh god
canadiancow is offline  
Old Jan 7, 20, 1:14 pm
  #199  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
Originally Posted by GeekyFlyer View Post
According to Aeroplan, Turkey would be intra, Israel and Jordan would be rest of world.
Welcome to FT!

I hadn't even checked the Aeroplan pages on mileage earning before posting that. Thanks

Also, here are some AQM missing in the spreadsheet:
Thanks for sharing this data, I'll add it to the sheet!

I won't add FRA-MRS though, since the true number could be 481 or 482.
GeekyFlyer likes this.
Adam Smith is online now  
Old Jan 11, 20, 11:16 am
  #200  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
New version uploaded. All mileage earning, including the weird exceptions (e.g. AC domestic, AV's intra-Central America, TP LIS-OPO, etc), should now be automatic.

I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.

I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.

I hope this is helpful for people.

If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
canadiancow and Bohemian1 like this.
Adam Smith is online now  
Old Jan 11, 20, 11:33 am
  #201  
 
Join Date: Mar 2008
Programs: AC SE100K
Posts: 599
Adam Smith Appreciate your efforts.

Edit: Apparently accolades are due for Bohemian1 as well.

Last edited by YVRtoYYZ; Jan 11, 20 at 12:07 pm
YVRtoYYZ is offline  
Old Jan 11, 20, 11:44 am
  #202  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
Originally Posted by YVRtoYYZ View Post
Adam Smith Appreciate your efforts
Thanks! Lots of credit for this latest update should also go to @Bohemian1, who did a lot of the heavy lifting and encouraged me to get this done - sorry for not mentioning it in the earlier post, although I did write a credit in to the instructions tab of the sheet
Adam Smith is online now  
Old Jan 11, 20, 11:50 am
  #203  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (Wave as you fly over)
Programs: AC*SE100K, wood level status in various other programs
Posts: 2,878
I just had a quick look and there is a TON of heavy lifting in there just to accommodate all of the weird regional and fare-based earning rates that defy easy rules.

Kudos to Adam for upping this tool to a new level!
Bohemian1 is online now  
Old Jan 11, 20, 11:59 am
  #204  
 
Join Date: Jun 2016
Location: ORD
Programs: AC E50K, Marriott Titanium
Posts: 90
Some new values:
YUL-ZBF 412
ATL-IAD 534
YUL-YYY 339
YYZ-BUD 4,444
lewis_m is offline  
Old Jan 11, 20, 1:53 pm
  #205  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
Originally Posted by lewis_m View Post
Some new values:
YUL-ZBF 412
ATL-IAD 534
YUL-YYY 339
YYZ-BUD 4,444
Thanks! I'll maybe see if this update flushes anyone else out and upload a new version in the next couple of days.
Adam Smith is online now  
Old Jan 11, 20, 2:00 pm
  #206  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Plat, Bonvoy Gold, HH Diamond
Posts: 31,249
Originally Posted by Adam Smith View Post
New version uploaded. All mileage earning, including the weird exceptions (e.g. AC domestic, AV's intra-Central America, TP LIS-OPO, etc), should now be automatic.

I've tested it with a bunch of airlines and routes and it seems like it's pretty solid, but if anyone finds any errors, let me know.

I accomplished it by breaking down the exceptions in to categories and then just checking if there was an exception for that airline/route combo in each exception category. Anyone who's interested in the nuts and bolts will see that there are now a zillion hidden helper columns to avoid having too many cells with massive formulae.

I hope this is helpful for people.

If anyone else has new mileage data, please share so that we can continue to improve the spreadsheet.
This is what you were so busy with that you couldn't come to Vegas?
canadiancow is offline  
Old Jan 11, 20, 2:01 pm
  #207  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
Originally Posted by canadiancow View Post
This is what you were so busy with that you couldn't come to Vegas?
Well, if I'm going to do that RTW, I'm going to need to know how many miles I'm going to earn, don't I?
ffsim, canadiancow and Bohemian1 like this.
Adam Smith is online now  
Old Jan 16, 20, 9:27 pm
  #208  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 6,590
New version uploaded including some additional mileage data.
Adam Smith is online now  
Old Jan 16, 20, 9:30 pm
  #209  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,587
Going to try and update the simplified calculator to the updated data source as well this weekend.
Update: Hmm... seems completely broken now. May have pushed Google Sheets to its limit? Gonna take my version offline now.

Last edited by Jumper Jack; Jan 18, 20 at 2:40 pm
Jumper Jack is online now  

Thread Tools
Search this Thread
Search Engine: