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

Reply

Old Feb 10, 16, 9:48 pm
  #31  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
So I'm starting to think some kind of database/website/something would be way better/faster/easier than this spreadsheet
canadiancow is online now  
Reply With Quote
Old Feb 10, 16, 9:53 pm
  #32  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
Undoubtedly! But I'm just a simple finance guy, so Excel is all I can do. If we had some talented programmers around, maybe they could go and build that, but no one had done so, so I took it upon myself to at least create something
Adam Smith is offline  
Reply With Quote
Old Feb 10, 16, 10:37 pm
  #33  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Well the city pair distances would be easy. I haven't even really played around with the rest enough to even know what it does

Now I need to go add some distances.
canadiancow is online now  
Reply With Quote
Old Feb 10, 16, 10:38 pm
  #34  
 
Join Date: Jan 2010
Location: YVR
Posts: 1,341
Somewhat dumb question, but I have a couple mileages to add (YQU's in particular) - do you want the ACTUAL mileage, or 250, entered if it is below minimum? I assume the latter.
nomadic.relief is offline  
Reply With Quote
Old Feb 10, 16, 11:07 pm
  #35  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Originally Posted by nomadic.relief View Post
Somewhat dumb question, but I have a couple mileages to add (YQU's in particular) - do you want the ACTUAL mileage, or 250, entered if it is below minimum? I assume the latter.
It's what AC credits (at 100%), so 250.

However, I have a question about all the 500s in the spreadsheet.

Should we just delete those? YYZ-YAM is not 500, but it's listed as such. And this applies for many other city pairs.

Edit: I just updated all the ones I could, which included changing YUL-YHZ from 500 to 499. But there are still 54 city-pairs listed at 500, including YYZ-YUL, which I have apparently not flown on revenue tickets since they made the change. And I mention YYZ-YUL because I assume many people here know it off the top of their head.

Last edited by canadiancow; Feb 10, 16 at 11:19 pm
canadiancow is online now  
Reply With Quote
Old Feb 11, 16, 7:10 am
  #36  
 
Join Date: Sep 2014
Programs: AC SEMM
Posts: 1,379
As we have discovered in the other AQD thread it seems that AC uses 2 different values for inter-airport distances. One for AQM and another for AQD calculations. You probably don't want to complicate the spreadsheet further in order to get closer to being 100% accurate but I just thought I'd mention it.
Geoflying is offline  
Reply With Quote
Old Feb 11, 16, 7:23 am
  #37  
Original Member
 
Join Date: May 1998
Location: Canada
Programs: AC SE 2MM, HH Dd, SPG; IC Pl/A; AA; DL
Posts: 13,898
for the record to start filling in the blanks for those "500" figures

YUL-YYZ is 314
YYC-YVR is 426
BlondeBomber is offline  
Reply With Quote
Old Feb 11, 16, 10:03 am
  #38  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
Originally Posted by canadiancow View Post
However, I have a question about all the 500s in the spreadsheet.

Should we just delete those? YYZ-YAM is not 500, but it's listed as such. And this applies for many other city pairs.
I thought about that and figured it's better to leave something than nothing, but it's a good point. What I think might work is to add text to the error column warning that the mileage is likely out of date. I can do that tonight when I get back to my hotel.

Originally Posted by Geoflying View Post
As we have discovered in the other AQD thread it seems that AC uses 2 different values for inter-airport distances. One for AQM and another for AQD calculations. You probably don't want to complicate the spreadsheet further in order to get closer to being 100% accurate but I just thought I'd mention it.
You're correct, but once we got the updated mileage figure for MUC-YYZ in that example, we were within 0.1% of what AC provided, I think, which should be close enough.

I have though thought of a way to at least address the issue of inaccurate AQD calculations with routes that hit the 250-mile minimum without complicating the sheet much, because that's what will throw off the AQD allocation more than AC having changed the crediting for a route by a couple of miles.
Adam Smith is offline  
Reply With Quote
Old Feb 11, 16, 11:06 am
  #39  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Originally Posted by adam.smith View Post
I thought about that and figured it's better to leave something than nothing, but it's a good point. What I think might work is to add text to the error column warning that the mileage is likely out of date. I can do that tonight when I get back to my hotel.
I'm not even using the calculator - I'm just using the mileage table.

And I'm actually not convinced "500" is better than nothing, since 500 is almost certainly inaccurate.
canadiancow is online now  
Reply With Quote
Old Feb 16, 16, 8:56 am
  #40  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
I've added a few new mileage data points.

I also added comments to the Errors column that will warn if the mileage is 500, and therefore likely stale.

I've also built a workaround to more accurately calculate AQD on flights that hit the 250-mile minimum. Basically, you need to get the actual distance from gcmap and it will then use that for AQD proration instead of the 250 AQM number.
Adam Smith is offline  
Reply With Quote
Old Feb 17, 16, 2:57 pm
  #41  
 
Join Date: Jan 2003
Location: AC SE, SPG Lifetime Plat, ACMM
Posts: 3,520
Originally Posted by adam.smith View Post
I've added a few new mileage data points.

I also added comments to the Errors column that will warn if the mileage is 500, and therefore likely stale.

I've also built a workaround to more accurately calculate AQD on flights that hit the 250-mile minimum. Basically, you need to get the actual distance from gcmap and it will then use that for AQD proration instead of the 250 AQM number.
The other issue that this does not address is if I buy a RTW on 014 the AQD will be based on the price of the ticket and not the mileage--eg my CStar RTW starting from NRT on 014 stock gives YYZ-YOW as 64 AQD in Z class fare.
ac777 is offline  
Reply With Quote
Old Feb 17, 16, 4:39 pm
  #42  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
Originally Posted by ac777 View Post
The other issue that this does not address is if I buy a RTW on 014 the AQD will be based on the price of the ticket and not the mileage--eg my CStar RTW starting from NRT on 014 stock gives YYZ-YOW as 64 AQD in Z class fare.
I don't follow. AQD is always based on price of ticket and allocated between segments based on distance. Presumably if you fly NRT-YYZ-YOW-LHR-DEL-NRT or whatever on an RTW ticket, that same principle will apply. Seeing 64 AQD for a short flight like that isn't out of line with some of the other things we've been seeing to date.

If you were to enter the data in the spreadsheet, I'd bet it could come out pretty close to 64 AQD for that segment, it has been pretty accurate so far.
Adam Smith is offline  
Reply With Quote
Old Feb 17, 16, 9:39 pm
  #43  
 
Join Date: Jan 2003
Location: AC SE, SPG Lifetime Plat, ACMM
Posts: 3,520
Originally Posted by adam.smith View Post
I don't follow. AQD is always based on price of ticket and allocated between segments based on distance. Presumably if you fly NRT-YYZ-YOW-LHR-DEL-NRT or whatever on an RTW ticket, that same principle will apply. Seeing 64 AQD for a short flight like that isn't out of line with some of the other things we've been seeing to date.

If you were to enter the data in the spreadsheet, I'd bet it could come out pretty close to 64 AQD for that segment, it has been pretty accurate so far.
You are right that AQD is based on the price of the ticket. But a NRT-NRT RTW is about 8500 dollars but a YVR-YVR RTW is close to 15000 dollars. So the same sector will have different AQD although the mileage will be the same.
ac777 is offline  
Reply With Quote
Old Feb 17, 16, 11:43 pm
  #44  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, BA Silver, Marriott Platinum, Accor Platinum, Hilton Gold, Club Carlson Gold
Posts: 5,837
Originally Posted by ac777 View Post
You are right that AQD is based on the price of the ticket. But a NRT-NRT RTW is about 8500 dollars but a YVR-YVR RTW is close to 15000 dollars. So the same sector will have different AQD although the mileage will be the same.
There's no generic number of AQD for any given route and I'm not claiming that there is. The calculator doesn't tell you how much AQD you're going to earn in total, it helps you figure out how much AQD will be allocated to each segment after you tell it exactly what fare you paid and what segments you're flying.

So, let's say you buy an RTW touching NRT, YVR, FRA and NRT. Whether you buy this as NRT-YVR-FRA-BKK-NRT or YVR-FRA-BKK-NRT-YVR, you're flying the same segments with the same mileage. That means AQD will be allocated roughly 26% to NRT-YVR, 28% YVR-FRA, 31% FRA-BKK and 16% BKK-NRT (whether you actually earn AQD on those flights depends on them being AC metal or AC codeshares ticketed on 014, but that's how the AQD will be allocated). That split will hold whether you buy the ticket originating in NRT for $8K, YVR for $15K, FRA for $250K or BKK for $1.

That's all the calculator does - allocate the total AQD you give it, based on whatever you paid, among the different flight segments.
Adam Smith is offline  
Reply With Quote
Old Feb 18, 16, 7:44 am
  #45  
 
Join Date: Jan 2003
Location: AC SE, SPG Lifetime Plat, ACMM
Posts: 3,520
Originally Posted by adam.smith View Post
There's no generic number of AQD for any given route and I'm not claiming that there is. The calculator doesn't tell you how much AQD you're going to earn in total, it helps you figure out how much AQD will be allocated to each segment after you tell it exactly what fare you paid and what segments you're flying.

So, let's say you buy an RTW touching NRT, YVR, FRA and NRT. Whether you buy this as NRT-YVR-FRA-BKK-NRT or YVR-FRA-BKK-NRT-YVR, you're flying the same segments with the same mileage. That means AQD will be allocated roughly 26% to NRT-YVR, 28% YVR-FRA, 31% FRA-BKK and 16% BKK-NRT (whether you actually earn AQD on those flights depends on them being AC metal or AC codeshares ticketed on 014, but that's how the AQD will be allocated). That split will hold whether you buy the ticket originating in NRT for $8K, YVR for $15K, FRA for $250K or BKK for $1.



That's all the calculator does - allocate the total AQD you give it, based on whatever you paid, among the different flight segments.
Thanks for the explanation.Will try this out soon.
ac777 is offline  
Reply With Quote

Thread Tools
Search this Thread