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 Oct 13, 18, 2:10 pm
  #151  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,517
Originally Posted by LesDorgo View Post
the calculator is amazing. Any way to put in a cost per mile on the next update.
Thats a pretty simple feature to add in. I can do that.
Are you looking for cost per mile as in price paid for fare per mile or aqd per mile?
Jumper Jack is offline  
Reply With Quote
Old Oct 15, 18, 12:36 am
  #152  
 
Join Date: Jan 2018
Location: Windsor/Detroit
Programs: AC*SE100K, Mariot gold, Hilton gold, Wyndham dimond, Amex Plat Cnd & USA, Canadian army vet.
Posts: 33
Originally Posted by Jumper Jack View Post
Thats a pretty simple feature to add in. I can do that.
Are you looking for cost per mile as in price paid for fare per mile or aqd per mile?
Both would not be hard to add and the extra info could help people when EYW comes out again.
LesDorgo is offline  
Reply With Quote
Old Oct 15, 18, 8:44 am
  #153  
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 LesDorgo View Post
Both would not be hard to add and the extra info could help people when EYW comes out again.
That's not how EYW works.
canadiancow is online now  
Reply With Quote
Old Oct 15, 18, 9:29 am
  #154  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint
Programs: AC*SE100K, wood level status in various other programs
Posts: 2,021
Originally Posted by LesDorgo View Post
Both would not be hard to add and the extra info could help people when EYW comes out again.
Different things. In the past, we had the generously provided 'Cowculator' for that ....
Bohemian1 is online now  
Reply With Quote
Old Nov 21, 18, 7:38 pm
  #155  
 
Join Date: Jan 2005
Location: YOW
Programs: AC SEMM; AA,DL, Hyatt and Starwood. Ex-status:SQ PPS,CSA,Hilton,AA,UA
Posts: 701
Can anyone confirm AQM for the (soon-to-be-removed) direct YYZ-EZE flight.

The Google Sheets calculator gives a Haversine distance of 5584. The mileage table *queried* by the calculator gives 5573, but for some reason this doesn't pop up on the calculator tab. gcmap.com gives 5563, which is weird since usually AC cheats on the mileage versus gcmap. Anyone know from personal experience what gets credited?

(Trying to plan whether my wife needs to do some creative routings to get over 100K for the first time - having been my 50K nominee for about 5 years now. Of course, will build in a bit of leeway but would prefer to use as accurate info as possible and she has YYZ-EZE-YYZ upcoming already booked.)

Thanks!
montrealer is offline  
Reply With Quote
Old Nov 29, 18, 5:18 am
  #156  
 
Join Date: Jan 2005
Location: YOW
Programs: AC SEMM; AA,DL, Hyatt and Starwood. Ex-status:SQ PPS,CSA,Hilton,AA,UA
Posts: 701
Originally Posted by montrealer View Post
Can anyone confirm AQM for the (soon-to-be-removed) direct YYZ-EZE flight.
No one answered my question, but for whenever someone updates, noting that Aeroplan awarded us 5572.
montrealer is offline  
Reply With Quote
Old Nov 29, 18, 6:40 pm
  #157  
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 montrealer View Post
No one answered my question, but for whenever someone updates, noting that Aeroplan awarded us 5572.
Sorry, I thought I had replied on the weekend.

For flights where the data table has been populated, the data has almost always been accurate right to the mile (once I cleaned out a bunch of mistakes where people had put things in the wrong cell). I'm a bit surprised it was off by 1 in this case, but perhaps AC has changed it.

As for why EZE was in the data table but not pulled by the calculator, it turns out that there was a rogue space in the EZE header cell, which meant that typing "EZE" in the calculator tab didn't find any results since it was in the data table as " EZE" (or "EZE ", I forget which).

I've fixed that and will upload a new version in the next few days.

Also, people, if you're going to contribute to the data tab, great, but please be careful. For example, someone has added YYR to SFO mileage as 800. I'm sure this well-meaning person wanted to add the YVR to SFO mileage, but it's sloppiness like that that can muck the whole thing up. So feel free to just post in this thread and I'll update the sheet.
montrealer and canadiancow like this.
Adam Smith is offline  
Reply With Quote
Old Nov 29, 18, 8:04 pm
  #158  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
I'd argue that if you think a COMMON route has missing data (i.e. YVR-SFO), then you're probably doing something wrong.

YYR-YQX, maybe. BOM-GOI, sure.

But YVR-SFO? You've entered a city wrong.
Adam Smith likes this.
canadiancow is online now  
Reply With Quote
Old Dec 15, 18, 8:58 am
  #159  
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 uploaded a new version that's back to working, after someone broke the sheet again.

I've taken down the Google Sheets version since people were consistently messing it up.

If you have any new distances, please post them in the thread here and I'll add them to the master version.
Adam Smith is offline  
Reply With Quote
Old Dec 15, 18, 9:07 am
  #160  
 
Join Date: Jun 2018
Location: YVR
Programs: AC SE100K, Bonvoy Gold Elite, IHG Gold
Posts: 1,038
Originally Posted by Adam Smith View Post
I've uploaded a new version that's back to working, after someone broke the sheet again.

I've taken down the Google Sheets version since people were consistently messing it up.

If you have any new distances, please post them in the thread here and I'll add them to the master version.
I assumed it was user error on my part the other day when it kept telling me it didn't recognize (common) airport codes.

Now I'll just assume I'm the idiot that broke it.
WaytoomuchEurope is online now  
Reply With Quote
Old Dec 15, 18, 9:44 am
  #161  
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 WaytoomuchEurope View Post
I assumed it was user error on my part the other day when it kept telling me it didn't recognize (common) airport codes.

Now I'll just assume I'm the idiot that broke it.
I don't know who did it or how or why people do it. Not really important.
Adam Smith is offline  
Reply With Quote
Old Dec 15, 18, 12:13 pm
  #162  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint
Programs: AC*SE100K, wood level status in various other programs
Posts: 2,021
Originally Posted by Adam Smith View Post
I've uploaded a new version that's back to working, after someone broke the sheet again.

I've taken down the Google Sheets version since people were consistently messing it up.

If you have any new distances, please post them in the thread here and I'll add them to the master version.

Thanks Adam!

The Google Sheets version has bee fubar for a while.
Bohemian1 is online now  
Reply With Quote
Old Dec 15, 18, 3:23 pm
  #163  
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 Bohemian1 View Post
Thanks Adam!

The Google Sheets version has bee fubar for a while.
If only someone had told me
Adam Smith is offline  
Reply With Quote
Old Dec 15, 18, 5:30 pm
  #164  
 
Join Date: Aug 2013
Location: YVR - MILLS Waypoint
Programs: AC*SE100K, wood level status in various other programs
Posts: 2,021
Originally Posted by Adam Smith View Post
If only someone had told me

My bad.

I thought your job responsibilities were only arranging YYC Dos and acting as scotch ambassador. Now I know to add spreadsheet maintenance to your duties.
Bohemian1 is online now  
Reply With Quote
Old Dec 15, 18, 8:15 pm
  #165  
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 Bohemian1 View Post
My bad.

I thought your job responsibilities were only arranging YYC Dos and acting as scotch ambassador. Now I know to add spreadsheet maintenance to your duties.
I'm a man of many talents

I also did a lot of work in creating the spreadsheet, so it seems natural.
Adam Smith is offline  
Reply With Quote

Thread Tools
Search this Thread