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 May 20, 20, 1: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)




Print Wikipost

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,624
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  
Old Oct 15, 18, 12:36 am
  #152  
 
Join Date: Jan 2018
Location: Windsor/Detroit
Programs: AC*SE100K, Wyndham dimond, Amex Plat Cnd & USA, Canadian army vet, Yoga teacher.
Posts: 114
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  
Old Oct 15, 18, 8:44 am
  #153  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Gold, Bonvoy Gold, HH Diamond
Posts: 32,722
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 offline  
Old Oct 15, 18, 9:29 am
  #154  
 
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,207
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  
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: 718
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  
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: 718
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  
Old Nov 29, 18, 6:40 pm
  #157  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,095
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 online now  
Old Nov 29, 18, 8:04 pm
  #158  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, Accor Gold, Bonvoy Gold, HH Diamond
Posts: 32,722
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 offline  
Old Dec 15, 18, 8:58 am
  #159  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,095
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 online now  
Old Dec 15, 18, 9:07 am
  #160  
 
Join Date: Jun 2018
Location: YVR
Programs: AC SE100K, Bonvoy Platinum Elite, IHG Gold, Hertz 5*
Posts: 1,786
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 offline  
Old Dec 15, 18, 9:44 am
  #161  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,095
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 online now  
Old Dec 15, 18, 12:13 pm
  #162  
 
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,207
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  
Old Dec 15, 18, 3:23 pm
  #163  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,095
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 online now  
Old Dec 15, 18, 5:30 pm
  #164  
 
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,207
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  
Old Dec 15, 18, 8:15 pm
  #165  
Original Poster
 
Join Date: Feb 2015
Location: YYC
Programs: AC SE100K, WS Gold, BA Silver, Marriott Titanium, Accor/Hilton/Radisson/NH Gold
Posts: 8,095
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 online now  

Thread Tools
Search this Thread
Search Engine: