AAdvantage Mileage Calculator (Beta Version)

Discussion in 'American Airlines AAdvantage' started by MatthewRob, May 2, 2007.

Thread Status:
Not open for further replies.
Welcome to Australia's leading independent Frequent Flyer and Travel Resource!
Our site contains tons of information that will improve your travel experience.
Joining AFF is fast, simple & ABSOLUTELY FREE -  join now by clicking on the JOIN NOW button, and take immediate advantage of these great BENEFITS.
Once registered, this box will disappear. And you will see fewer advertisements :)
  1. MatthewRob

    MatthewRob Junior Member

    Jan 12, 2007
    17
    0
    Melbourne
    I have created a mileage calculator for people to figure out what Q-points, Q-miles, etc they will earn with AA on all the airlines. It is currently Beta as I am sure it has bugs that somebody will figure out, so have a play and test and let me know if you discover any issues.
     

    Attached Files:


  2. Kiwi Flyer

    Kiwi Flyer Senior Member

    Sep 24, 2004
    5,453
    4
    :cool:

    I'm a bit busy right now but will take a look at this. I've been building a calculator for several FFPs so very interested to see yours.
     
  3. MatthewRob

    MatthewRob Junior Member

    Jan 12, 2007
    17
    0
    Melbourne
    Sounds good...I'm surprised nobody has done it before, there are a few around but they are too basic: only AA, don't look at fare buckets, dont take into account when you qualify for next status, etc, etc.

    Take your time, I'm sure it must have mistakes.
     
  4. tscharke

    tscharke Member

    Sep 28, 2006
    303
    0
    nice work mate!!!

    this has saved me scribbling on paper everytime I want to reassure myself that i will make exp this year :D
     
  5. openseat

    openseat Active Member

    Jun 1, 2006
    631
    76
    SYD
    Thanks very much MatthewRob.

    I found one small problem when I was entering a BA flights in WT+ and J. It was coming up with the CoS bonus in qmiles when I think it is just simply miles flown (at least that is what my Aadvtage statement works it out).
     
  6. MatthewRob

    MatthewRob Junior Member

    Jan 12, 2007
    17
    0
    Melbourne
    Try this one...
     

    Attached Files:

  7. straitman

    Moderator

    Apr 27, 2003
    16,604
    4,756
    SE Oz (Sale)
    Flight Map:
    View my flight map
    Matthew,

    Is this an update :?: If so then maybe a version number would be a goog idea.
     
  8. Kiwi Flyer

    Kiwi Flyer Senior Member

    Sep 24, 2004
    5,453
    4
    Nice one. You've given me some ideas for improvements to the spreadsheet I've been developing.

    There should be a way to override the calculation - eg where the comment indicates non-earning you should have a way to select/force non-earning.

    I'll have to check whether there are any OW cases, but certainly in *A there are some airline/booking class combinations where earning rate varies according to route. The way your calculation is structured will not be able to cope with those (unless you provide a way to override).
     
  9. MatthewRob

    MatthewRob Junior Member

    Jan 12, 2007
    17
    0
    Melbourne
    Yeah the problem is the spreadsheet doesn't take into account routes and all the possible variations of airports. It would be good if you could just put in the cities and it caulculated the mileage and knew if it was ineligible (ie JFK-LHR BA), but I think it is beyond my Excel skills!

    Would be good to see yours which is in development though.
     
  10. Kiwi Flyer

    Kiwi Flyer Senior Member

    Sep 24, 2004
    5,453
    4
    Mine does have routing data, although an ongoing struggle to keep up to date so will only ever equate to ~90% complete.

    I'll send something through once it is in better shape.
     
  11. Kiwi Flyer

    Kiwi Flyer Senior Member

    Sep 24, 2004
    5,453
    4
    MatthewRob YGPM

    My Beta is now ready - covers QFF, AAdvantage, Mileage Plus and Miles & More. More to be added when I have time.
     
  12. simongr

    simongr Enthusiast

    Jul 10, 2006
    14,229
    1,742
    I too will up mine - it has the mileage distance calculator for a lot of destination pairs (from mileage monkey) but very few Africa. Mine is aimed mostly at comparing AA and QF status and earning.
     
  13. ziggy

    ziggy Newbie

    Mar 28, 2007
    8
    0
    Sydney
    #13 ziggy, May 24, 2007
    Last edited: May 24, 2007
    Did I blink and miss the file attachment?

    Edit: Argh! I get it, you were quoting!

    Sorry for the dumbness


    Sadly the spreadsheet doesn't work with NeoOffice (OpenOffice.Org fork) on a Mac. The calculation cells all say Err:502 which is invalid arguement. I think it's the conversion of links to the control sheet. I can't actually see a control sheet in it here.

    Regards

    Ziggy
     
  14. MatthewRob

    MatthewRob Junior Member

    Jan 12, 2007
    17
    0
    Melbourne
    Control sheet is hidden in Excel
     
Loading...

Share This Page