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 30, 17, 1:00 am
  #76  
 
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 Adam Smith View Post
Thank you to @flyquiet and @ACflyerDE for contributing to the mileage table in the calculator.

But I weep at the never-ending ways in which some people continue to butcher the Google Sheets version of this tool.

Seriously, why are you people deleting formulae and entire rows? There are only a handful of cells in this sheet that need to be edited to get the results. If the text isn't blue, don't touch it.

Don't delete rows. Don't change the font and colour of the input cells. Don't do random calculations in other cells. There's a whole instructions tab, even.

It's not complicated.

Please remember that Google Sheets saves all changes, so every little dumb thing you do and little breakage you create screws up the functionality for everyone else.

</rant>

Now that that's said, I'd appreciate some feedback from those of you who actually use the sheet. What can I do to make things clearer?

Or would I be better off to kill the Sheets version and just let people download the Excel file? This thread could be used for people to post mileage changes for me to incorporate.

That's really not what I wanted, because I had hoped this would become more of a community-based project, but I'm really not sure that's working out...
May I suggest you lock the sheet and have people fill out a form instead. The results of form would automatically be filled into pre-determined cells and feed into the formulas you have made.
It would involve some formulas and it would keep going, but as long as the form list is searchable should not be too hard. It would require a constant clean house from time to time so that the list wont get too long.

If you give me edit access I can take a crack at it after my exam on Tuesday.

On the other hand, you could also look at building a webapp around it(but would also cost you some $$ to store and access the database). I am not sure if I am good enough to write loops for it yet though.
Jumper Jack is offline  
Reply With Quote
Old Oct 30, 17, 12:13 pm
  #77  
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 Jumper Jack View Post
On the other hand, you could also look at building a webapp around it(but would also cost you some $$ to store and access the database). I am not sure if I am good enough to write loops for it yet though.
I have one half written. I never got around to it though. After they started counting AQD for all flights on 014 tickets, I lost interest.

I don't think you need any loops for this though
canadiancow is online now  
Reply With Quote
Old Oct 30, 17, 2:31 pm
  #78  
 
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 canadiancow View Post
I have one half written. I never got around to it though. After they started counting AQD for all flights on 014 tickets, I lost interest.

I don't think you need any loops for this though
Really?
Well you are def more of an expert than me on this matter.
But I thought we need to standardize the input? As well as calculating based off different status levels and bonus using else...
Jumper Jack is offline  
Reply With Quote
Old Oct 30, 17, 3:09 pm
  #79  
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 Jumper Jack View Post
Really?
Well you are def more of an expert than me on this matter.
But I thought we need to standardize the input? As well as calculating based off different status levels and bonus using else...
Okay I suppose a loop is necessary because you'll have N segments.
canadiancow is online now  
Reply With Quote
Old Oct 30, 17, 6:44 pm
  #80  
 
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 canadiancow View Post
Okay I suppose a loop is necessary because you'll have N segments.
Yeah I think I have to create an empty list to store whatever was fed out of the loop first. The loop will run as long as there is a segment left from the original input.

I may know a way to build this out but have no skills/experiences in actually deploying the web app though.

Utilizing Google forms and link it with Adam's existing sheet will resolve most of his/her pain I think
Jumper Jack is offline  
Reply With Quote
Old Oct 30, 17, 8:01 pm
  #81  
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
Jack, I've thought about locking parts of the sheet and only making a small amount editable. I don't love that it goes against the openness of the project, but the bigger issue is that I don't actually work on this in Sheets, I do everything in Excel and upload it. There are plenty of things that Sheets can't properly use from Excel and I don't know whether the protections will carry over. If anyone has any experience with that, it would be good to know to save me experimenting myself.

As for an app, I'm a finance guy. I have no idea how to write an app, on the web or otherwise. The cow made fun of me early on in this process for how easy an app this would be to write and how I was being silly in doing it in Excel, but he never took me up on my goading to execute the project himself.

If someone with more expertise on that front wants to program something, they're more than welcome.
canadiancow likes this.
Adam Smith is offline  
Reply With Quote
Old Oct 30, 17, 8:31 pm
  #82  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,517
EDIT: Encountered too much issue in an attempt to migrate over to Google Form. I have instead chosen to update the sheet with locked ranges so the tool should be functional at all times now.

Last edited by Jumper Jack; Nov 1, 17 at 12:24 am
Jumper Jack is offline  
Reply With Quote
Old Oct 31, 17, 11:23 pm
  #83  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,517
Deleted

Last edited by Jumper Jack; Nov 1, 17 at 12:23 am
Jumper Jack is offline  
Reply With Quote
Old Nov 1, 17, 12:18 am
  #84  
 
Join Date: Jan 2016
Location: YYZ
Programs: Eupgrade4Lyfe, Gifted E50K, 777HDPeasant or The Unexpected Virtue of Ignorance and Narcissism.
Posts: 5,517
Okay I am slightly drunk at the moment, but here is a my quick fix with refreshed visuals.
https://docs.google.com/spreadsheets...it?usp=sharing


@Adam Smith, please let me you your thoughts.
Jumper Jack is offline  
Reply With Quote
Old Nov 16, 17, 10:37 am
  #85  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Just added YYZ-BOS at 445.
canadiancow is online now  
Reply With Quote
Old Nov 27, 17, 5:11 pm
  #86  
FlyerTalk Evangelist
 
Join Date: Sep 2012
Location: SFO
Programs: AC S100K, A3*S, SPG Gold, CC Gold, HH Diamond
Posts: 28,077
Added HND-SYD: 4857
canadiancow is online now  
Reply With Quote
Old Dec 2, 17, 8:33 pm
  #87  
Suspended
 
Join Date: Nov 2017
Location: mmm yeah babe
Programs: mmm yeah babe
Posts: 13
Thumbs down Disgusted

Uhm, what happened to the calculator, guys? The current version is not quite what I remembered.
MmmYeahBabe is offline  
Reply With Quote
Old Dec 2, 17, 8:46 pm
  #88  
 
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 canadiancow View Post
Just added YYZ-BOS at 445.
Did you just update the full version or both?
Jumper Jack is offline  
Reply With Quote
Old Dec 2, 17, 8:47 pm
  #89  
 
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 MmmYeahBabe View Post
Uhm, what happened to the calculator, guys? The current version is not quite what I remembered.
Do you have any feedback regarding the simplified version?
Dat user name though lawl
Jumper Jack is offline  
Reply With Quote
Old Dec 2, 17, 8:52 pm
  #90  
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 Jumper Jack View Post
Did you just update the full version or both?
Just full.
canadiancow is online now  
Reply With Quote

Thread Tools
Search this Thread