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 Jun 23, 20, 12:53 pm   -   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: canadiancow
Wiki Link
Download Version
Excel version (full-featured for downloading to your own computer)

Online Version
AQM Cowculator and its source code

canadiancow's TODO list:
  • SAS Go Light fares
  • Basic economy on any airline other than AC (is it just need a fare basis that ends in GT?)
  • Ineligible codeshares, like EY-marketed, EY-operated, AC-ticketed
Print Wikipost

Old Mar 22, 19, 6:29 pm
  #181  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K MM, Accor Gold, Bonvoy Gold, HH Diamond
Posts: 33,037
I have some new airport locations based on AC data, rather than wherever the ones in the calculator came from. It should help with calculating distances the way AC does.


Code:
ABV,9.006792,7.263172
ACY,39.4575,-74.577225
AEX,31.3274,-92.549835
AMS,52.308056,4.764167
ANC,61.174168,-149.99834
ATH,37.93639,23.947222
ATL,33.636665,-84.428055
AUA,12.501389,-70.01528
AUS,30.194445,-97.67
AZS,19.27,-69.7375
BCN,41.296944,2.078333
BDA,32.364166,-64.67861
BDL,41.939167,-72.683334
BGI,13.074722,-59.4925
BNA,36.126667,-86.681946
BNE,-27.383333,153.11833
BOG,4.701389,-74.14694
BOS,42.363056,-71.006386
BRO,25.906944,-97.425835
BRU,50.90139,4.484444
BUD,47.439445,19.261944
BWI,39.175278,-76.668335
CCC,22.461111,-78.32861
CDG,49.009724,2.547778
CFU,39.601944,19.911667
CLE,41.411667,-81.849724
CLT,35.21389,-80.943054
CMH,39.99818,-82.884964
CMN,33.36722,-7.589722
CPH,55.618057,12.656111
CUN,21.036667,-86.876945
CUR,12.188889,-68.959724
CVG,39.04889,-84.66778
CYO,21.616112,-81.545555
CZM,20.515,-86.92889
DBV,42.56139,18.268333
DCA,38.852222,-77.03778
DEL,28.568611,77.11222
DEN,39.861668,-104.67306
DFW,32.896942,-97.038055
DGO,24.124166,-104.53139
DTW,42.2125,-83.35333
DUB,53.42139,-6.27
DUJ,41.1783,-78.8987
DXB,25.252777,55.364445
EDI,55.95,-3.3725
EGE,39.6425,-106.91778
EWR,40.68954,-74.17451
EZE,-34.822224,-58.53583
FCO,41.800278,12.238889
FDF,14.592222,-60.996387
FLL,26.0725,-80.15278
FRA,50.033333,8.570556
GCM,19.2925,-81.35917
GDN,54.3775,18.46611
GGT,23.563334,-75.873055
GIG,-22.81,-43.250557
GLA,55.871944,-4.433056
GND,12.004167,-61.78611
GRU,-23.435556,-46.473057
GVA,46.238335,6.109444
HAV,22.989166,-82.409164
HKG,22.30889,113.914444
HND,35.553333,139.78111
HNL,21.318611,-157.9225
HOG,20.785557,-76.315
HUX,15.775278,-96.2625
IAH,29.984444,-95.34139
ICN,37.463333,126.44
IND,39.71722,-86.29444
IST,40.976112,28.814167
JFK,40.641296,-73.77819
KIN,17.935556,-76.7875
KIX,34.434166,135.23277
KOA,19.73889,-156.04556
KRK,50.077778,19.784721
KTW,50.47425,19.080044
LAS,36.08,-115.15222
LAX,33.9425,-188.40805
LGA,40.774017,-73.87208
LGW,51.148056,-0.190278
LHR,51.4775,-0.461389
LIM,12.021944,-77.11444
LIR,10.593056,-85.545555
LIS,38.774166,-9.134167
LRM,18.452162,-68.91118
LYS,45.725555,5.081111
MAD,40.47222,-3.560833
MAN,53.35389,-2.275
MBJ,18.50361,-77.91333
MCI,39.2975,-94.71389
MCO,28.429443,-81.30889
MDT,40.193054,-76.763336
MEX,19.436111,-99.071945
MIA,25.793333,-80.29056
MKE,42.947224,-87.89667
MLM,19.85,-101.02556
MSP,44.881943,-93.221664
MSY,29.993334,-90.25806
MUC,48.35389,11.786111
MXP,45.63,8.723056
NAS,25.038889,-77.46611
NCE,43.66528,7.215
NRT,35.765278,140.38556
OGG,20.898611,-156.43056
ORD,41.97861,-87.904724
PAP,18.58,-72.2925
PBI,26.683056,-80.09556
PDX,45.58861,-122.5975
PEK,40.08,116.58444
PHL,39.871944,-75.24111
PHX,33.434166,-112.011665
PIT,40.49139,-80.23278
PLS,21.773611,-72.26583
POP,19.757778,-70.57
PRG,50.100834,14.26
PTP,16.264168,-61.525833
PTY,9.071389,-79.38361
PUJ,18.566668,-68.351944
PVG,31.143333,121.805275
PVR,20.68,-105.254166
RDU,35.877777,-78.7875
ROC,43.11889,-77.6725
RSW,26.536112,-81.75528
SAN,32.733612,-117.18972
SAP,15.452778,-87.923615
SCL,-33.392776,-70.78555
SEA,47.44889,-122.30944
SFO,37.61889,-122.375
SJD,23.151667,-109.72083
SJO,9.993889,-84.208885
SJU,18.439167,-66.001945
SKB,17.31139,-62.718613
SNU,22.492222,-79.94361
SPU,43.538889,16.298056
SRQ,27.395555,-82.55444
STL,38.747223,-90.36139
SXM,18.040833,-63.109444
SYD,-33.94611,151.17722
SYR,43.11111,-76.10639
TLV,32.009445,34.88278
TPA,27.975555,-82.53333
UKB,34.632778,135.223889
UVF,13.733333,-60.9525
VCE,45.50528,12.351944
VRA,23.034445,-81.43528
WAW,52.165833,20.967222
YAM,46.485,-84.509445
YBC,49.1325,-68.204445
YBG,48.330555,-70.99694
YBL,49.951942,-125.273056
YCD,49.054443,-123.87
YCG,49.296112,-117.6325
YDF,49.209167,-57.394444
YEG,53.31,-113.579445
YFC,45.86889,-66.537224
YGK,44.225834,-76.596664
YGP,48.775276,-64.47972
YGR,47.425,-61.778057
YHZ,44.879723,-63.510277
YKA,50.7025,-120.44861
YLW,49.957222,-119.37778
YMM,56.65333,-111.223335
YOW,45.3225,-75.66722
YPR,54.28583,-130.44472
YQB,46.79111,-71.39333
YQF,52.18222,-113.89445
YQG,42.27611,-82.95528
YQL,49.63028,-112.79972
YQM,46.11611,-64.67861
YQQ,49.710835,-124.886665
YQR,50.43222,-104.666115
YQT,48.371944,-89.32167
YQU,55.18,-118.88472
YQX,48.936943,-54.568054
YQY,46.16139,-60.048058
YQZ,53.02611,-122.51028
YSB,46.625557,-80.797775
YSJ,45.316113,-65.89
YTM,46.40917,-74.78
YTS,48.570557,-81.37666
YTZ,43.6275,-79.39611
YUL,45.45767,-73.749825
YUY,48.206112,-78.835556
YVO,48.053333,-77.782776
YVR,49.19669,-123.18151
YWG,49.91,-97.24
YWK,52.92278,-66.86472
YWL,52.183334,-122.05444
YXC,49.61222,-115.781944
YXE,52.170834,-106.7
YXH,50.01889,-110.72083
YXJ,56.238335,-120.74028
YXS,53.884167,-122.6775
YXT,54.468613,-128.57834
YXU,43.033054,-81.15111
YXX,49.025276,-122.36
YXY,60.709442,-135.06721
YYB,46.363888,-79.424164
YYC,51.1225,-114.013336
YYD,54.82528,-127.18278
YYF,49.4625,-119.60222
YYG,46.289165,-63.119167
YYJ,48.64722,-123.425835
YYR,53.319168,-60.425835
YYT,47.61861,-52.7525
YYY,48.60889,-68.2075
YYZ,43.67775,-79.62482
YZF,62.463055,-114.44028
YZP,53.254166,-131.81389
YZR,42.99972,-82.30944
YZV,50.22333,-66.26556
ZAG,45.743057,16.06889
ZBF,47.629723,-65.73889
ZIH,17.601389,-101.46028
ZRH,47.46472,8.549167
ZSA,24.063334,-74.52389
canadiancow is online now  
Old Jun 25, 19, 1:37 am
  #182  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K MM, Accor Gold, Bonvoy Gold, HH Diamond
Posts: 33,037
Okay I've finally put some more effort into this.

https://api.ft.canadiancow.com/aqd/b...3&lastName=Cow

It works for bookings made on AC.com. No promises elsewhere yet. Error handling is crap, but it works on 3 of my bookings.

It doesn't calculate anything yet, but it has the total cost and the distance for each segment.
Plumber likes this.
canadiancow is online now  
Old Nov 18, 19, 11:23 pm
  #183  
FlyerTalk Evangelist
 
Join Date: Feb 2004
Location: YVR
Programs: AC S100K 2MM; UA MP Premier Silver; Marriott Bonvoy Lifetime Titanium Elite
Posts: 29,334
I have to say, this calculator has been immensely helpful in planning my MR binge. Thanks again to Adam Smith canadiancow and DrunkCargo ^
yyznomad is offline  
Old Jan 4, 20, 4:00 pm
  #184  
 
Join Date: Mar 2008
Programs: AC SE100K
Posts: 658
I have used this spreadsheet so much and gotta say a sincere "thank you" to those who created and maintained it.

As the Nomad said, helped with my 2019 mileage run and most recently trying to determine if YYZ-YVR-HNL in Comfort will yield more AQM than YYZ-FRA-BRU in PE.
YVRtoYYZ is offline  
Old Jan 5, 20, 8:20 am
  #185  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Glad to hear people are still finding this useful. To the extent that's the case, please feel free to post here if you have new mileage data, i.e. routes you've flown where the spreadsheet currently is relying on the haversine formula rather than the official AC distance.

I have a bunch of new ones and will upload a new copy of the spreadsheet soon that contains them, but can always incorporate more.
Adam Smith is offline  
Old Jan 5, 20, 8:20 am
  #186  
 
Join Date: Dec 2019
Programs: AC 75K, Marriott Bovoy Platinum Elite, NEXUS / GE
Posts: 2
The work on this calculator by Adam Smith, canadiancow, DrunkCargo, and any other contributors should be rewarded with automatic SE status for life - assuming they aren't already there
insearchof_SE is offline  
Old Jan 5, 20, 8:30 am
  #187  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Originally Posted by insearchof_SE View Post
The work on this calculator by Adam Smith, canadiancow, DrunkCargo, and any other contributors should be rewarded with automatic SE status for life - assuming they aren't already there
Thanks

2/3 of us aren't even 1MM, let alone anywhere close to 3MM, sadly. Not sure about the 3rd.
Adam Smith is offline  
Old Jan 5, 20, 11:18 am
  #188  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (Wave as you fly over)
Programs: AC*SE100K, wood level status in various other programs
Posts: 3,275
Originally Posted by Adam Smith View Post
Glad to hear people are still finding this useful. To the extent that's the case, please feel free to post here if you have new mileage data, i.e. routes you've flown where the spreadsheet currently is relying on the haversine formula rather than the official AC distance.

I have a bunch of new ones and will upload a new copy of the spreadsheet soon that contains them, but can always incorporate more.
I have at least of few of these but will probably wait for the next update and then figure out some kind of diff against that to make it easier to incorporate.

Any other significant mods I made to the excellent original spreadsheets were mostly around correctly calculating Altitude/Aeroplan miles based on fare class which should not impact the route-specific mileage table.
Bohemian1 is online now  
Old Jan 5, 20, 11:32 am
  #189  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Originally Posted by Bohemian1 View Post
Any other significant mods I made to the excellent original spreadsheets were mostly around correctly calculating Altitude/Aeroplan miles based on fare class which should not impact the route-specific mileage table.
I actually did take what you had built on that front and add on to it somewhat. I got bogged down in handling the exceptions - it's relatively simple to create the basic table, but hard to automate the handling of all those weird one-offs, e.g. LH has one chart for intra-Europe, another for international, while NZ has one for domestic, one for Tasman, and another for international.

But I guess that I can just throw up a flag and let people go look those up themselves. It should enable most of them to be automated and only require manual input for a few, whereas right now it's 100% manual.

I'll do that in the next few days.
Adam Smith is offline  
Old Jan 5, 20, 11:39 am
  #190  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (Wave as you fly over)
Programs: AC*SE100K, wood level status in various other programs
Posts: 3,275
Originally Posted by Adam Smith View Post

But I guess that I can just throw up a flag and let people go look those up themselves. It should enable most of them to be automated and only require manual input for a few, whereas right now it's 100% manual.
Yeah, that's exactly what I do. I flag combinations of fare and carrier that could have more than one earning rate and then default to the lowest multiple unless the user (that's me!) overrides with a different one.

In your example, that means LH has two lines in my "Multipliers" spreadsheet one for Europe and one for ROW. Some not so cleaver logic on that sheet sets a flag for any carrier with more than one row of data. Crude, but it works and, like you said, the exceptions are relatively few.

My next project is to try and get the same tables / logic to accurately interpret AC branded fares. Maybe I will do a self-proof of Fermat's Theorem first just to limber up.
Bohemian1 is online now  
Old Jan 5, 20, 11:44 am
  #191  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Originally Posted by Bohemian1 View Post
Yeah, that's exactly what I do. I flag combinations of fare and carrier that could have more than one earning rate and then default to the lowest multiple unless the user (that's me!) overrides with a different one.

In your example, that means LH has two lines in my "Multipliers" spreadsheet one for Europe and one for ROW. Some not so cleaver logic on that sheet sets a flag for any carrier with more than one row of data. Crude, but it works and, like you said, the exceptions are relatively few.
Yeah, I've seen it, you sent it to me. I think I may have come up with something slightly cleaner

I'm in OPO finishing up a vacation right now, so in a few days, probably, I'll put it up for all to see

My next project is to try and get the same tables / logic to accurately interpret AC branded fares. Maybe I will do a self-proof of Fermat's Theorem first just to limber up.
I just added the branded fares to the list of letter fare classes in the dropdown - so you select Business if the segment is AC metal, but Z or P or whatever if it's LH, OZ, etc
Bohemian1 likes this.
Adam Smith is offline  
Old Jan 5, 20, 11:46 am
  #192  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint (Wave as you fly over)
Programs: AC*SE100K, wood level status in various other programs
Posts: 3,275
On vacation and still beavering away on FT - very dedicated!

Have a Porto Tónico for me.
Bohemian1 is online now  
Old Jan 5, 20, 11:55 am
  #193  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Killing time while on another delayed TP flight
Adam Smith is offline  
Old Jan 5, 20, 2:27 pm
  #194  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K MM, Accor Gold, Bonvoy Gold, HH Diamond
Posts: 33,037
One of these days I'll catch up to the spreadsheet... https://api.ft.canadiancow.com/aqd/c...O&cost=4250.00

What is that missing to catch up? Input for status/bonus, ticketing/operating airline info, and earning rate?
canadiancow is online now  
Old Jan 7, 20, 7:42 am
  #195  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,476
Okay, so, I think I've figured out how to automate all the exceptions, pretty much.

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?

Originally Posted by canadiancow View Post
One of these days I'll catch up to the spreadsheet... https://api.ft.canadiancow.com/aqd/c...O&cost=4250.00

What is that missing to catch up? Input for status/bonus, ticketing/operating airline info, and earning rate?
Right now, looks like this is just allocating AQD by segment? So yes, all those things, plus or including whether it's eligible for AQD at all.
canadiancow and Bohemian1 like this.
Adam Smith is offline  

Thread Tools
Search this Thread
Search Engine: