Maybe a stupid question, but do we still need a separate tool to track EQMs and EQDs now that AA has brought its website into this century and actually shows this info for each flight?

I think we do, for tracking purposes to where we are currently and going...it is a great planning tool..

+1
Very useful for planning.

It's actually an excel spreadsheet, change extension from .pdf to .xlsx. I buried that in my wall of text.

I can appreciate that! I'm mainly interested in the forecasting ability to determine when I will reach a status level or what I need to maintain levels along with the 500-mi upgrades. I have what I think I need for that from the older spreadsheet. And to the other persons pint, the website logs miles earned very well.
My example was showing how I thought the dollar calc could work for award miles. I can't figure out how to do it segment by segment based on how the website calculates it. That calculates only destination, by destination. It sounds like you are handling it only at the overall trip/ticket level.

I'd like to point out that I've probably learned more about excel by dissecting your spreadsheet than any other source! So for me this is probably more a question of "how can I?" Vs the pragmatics of tracking what is practical.

Selfishly, I only care about pure AA, but this isn't about me! :) although I am personally interested in seeing what you have so far, just for my own understanding.

I forgot to address this in my previous reply. I understand that per-segment mileage doesn't matter in terms of EQD and RDM... however, AA.com still does report it that way.

Same here. AA will track my RDM, and that's an after-the-fact thing for me. I want to be able to predict what travel I need for status, so I want to calculate EQM (and now EQD) in advance so that I know, months in advance, what I need for the rest of the year.


Yup. The EQM ares still segment-by segment. Also, the EQD for "special" fares (like AA vacations) are calculated as a percentage of miles flown, so that is also segment-by-segment. EQD for pure AA is based on cost.

Although, we have a flight in January that is AA (part on BA, but AA codeshare) that should be based on eligible spend, and I see no indication in my reservation for what that is. Fare is like $59 and the rest is "taxes and fees," so some of that would be included...but I see nothing.

Standing on the shoulders of giants. I took a spreadsheet originally created by McFlyPHL and did some things to it. I learned quite a lot from what he did and then added some unique stuff. But, without that excellent base, I'd not have been able to do this.

I think I will send what I have this weekend so that folks can see/use it. As I mentioned, it's only missing mixed AA/non-AA, but all AA, partner and "special" should work.

Cheers.

Except that it does matter for partner segments, and for "special fares".

Well, it does matter for partner itineraries as well as "special fares." We don't yet know what matters for partner segments on mixed AA/partner itineraries as they have not yet defined that formula.

Cheers.

Miles are what matter on partner segments. What we don't know -- and perhaps never will -- is the formula AA uses to assign the needed $ values to the AA segments on a mixed itinerary. That's my understanding, anyway.

Yes, as I already said. And, at some point, we will know. But, it is currently unknown and, so, can't be coded.

Cheers.

Forgot to come and post this. The newest version (v. 1.5) is available on Gargoyle's page linked in the OP (thanks Gargoyle!).

This encompasses EQD, although the calculations for the new RDM scheme have not been included simply because I don't care to do so.

This will calculate EQD for:

AA
Partner flights (a couple of partners are coded)
"special" fares (including vacation packages)

It does not do mixed AA/partner as the rules are not known.

As always, please let me know if you find any issues or (not bloody likely :D) bugs.

Cheers.

Thank you for sharing your hard work, brp! :-: (And a hat tip to Gargoyle for offering to host.)

The Aadvantage Miles Tracker, v. 1.6 is now available on Gargoyle's site (linked in the OP). Changes from v. 1.5:

• Coding of the "Unknown Data" portion of the "Special Fares" table from AA.com
• Use of Tables for the Airline Data and City Pair data. This really only matters if you're gonna add anything. Then do it the same way
• Substantial simplification of the formulas to get rid of page links in using the tables. Much cleaner

Note: Opening this will give some link resolution errors. This is because I have references to pages that exist in my version and are not in this version. They can be safely ignored. I will clean these up in the next version. Really :)

Cheers.

And as you suggested in The Suggestion Box forum, FlyerTalk will also be able to host these files in the very near future. https://www.flyertalk.com/forum/sugg...-can-host.html

A repeat hat tip to you and gargoyle! ^

Tracking spreadsheet, verion 1.7
 

Here is Version 1.7 of the sheet. Version 1.6 is noted above. Version 1.7 cleans up the link errors.

Changes from v. 1.5:

• Coding of the "Unknown Data" portion of the "Special Fares" table from AA.com
• Use of Tables for the Airline Data and City Pair data. This really only matters if you're gonna add anything. Then do it the same way
• Substantial simplification of the formulas to get rid of page links in using the tables. Much cleaner

Cheers.