Hey folks,

Recently, mainly for my own amusement, I put together a quick spreadsheet in Google Sheets to track my progress towards AA elite status. You type in your flight dates and mileage, and it calculates running totals and percentages, with some other fun features.

I'm a lowly non-elite flier who until 2015 never bothered consolidating all my travel on to one FF program, and I didn't realize until I found FT that I had been throwing away a lot of benefits. My 2015 resolution is to hit at least Gold (shooting for Plat though) and I thought it'd be fun to see my progress. THEN I thought there might be a couple other FTers who might want to take my spreadsheet and fill it in with their own data.

So I made a duplicate blank version of it, and here it is:

BLANK STATUS TRACKER DOC:
https://docs.google.com/spreadsheets...ndY/edit#gid=0

To use this you must be signed into a Google account and go to File->Make a copy. You will not be able to edit it directly at this link!

—The reason it has all that garish red is to make it really clear that you should not change or delete those red cells because they include all the complex formulas that make the whole thing work.
—Red cells mean don't edit or delete that cell. Yellow cells are drop-down menus. (Drop-down menus only work when viewing on desktop browsers, not mobile, in my experience.)
—If you want to delete data you put into the spreadsheet, delete the data from the non-red cells and the red cells will also empty out automatically.
—Until there is at least one flight's worth of data, there will be several "#DIV/0!" errors. These will go away once there there actual numbers to crunch.

Here is my non-editable filled in sheet showing an example of what real data looks like:

MY EXAMPLE STATUS TRACKER DOC:
https://docs.google.com/spreadsheets...3Og/edit#gid=0



Basically, you fill this up line by line with your flight information (you'll have to do the per-flight EQP calculation based on booking code yourself; I was going to automate it but the differences with all the partner airlines made it too much of a pain), and as you put in more flights, the spreadsheet will update with your progress based on EQM, EQP, and segments.

—There is a drop-down menu under "CHOOSE TIER" to change the goal between GLD, PLT, and EXP. (It's really fun to switch between them and see all the percentages update!)
—Departure, Arrival, Flight Number, Airline, and Booking Code columns don't actually do anything, but I thought they were useful to have a record of.
—You can also add in any EQM, EQP, or segment bonuses you might be receiving under the "BONUS" field, and you can choose whether bonuses are included in your calculations with the "Use/Don't Use" toggle underneath. (For example, I entered 10,000 bonus EQM because I plan to hit $40k spend on my Citi Exec this year.)
—Average Stats show you, on average, how many EQM you're earning per segment, how many EQP per day, how many segments per week, and so on and so on. Projections gives you a VERY ROUGH indication as to how many days, weeks, or segments it will take for you to qualify for the selected tier by EQM, EQP, or segments, based on your current rates. This is mainly for fun, not meant as any kind of real prediction.
—Your average earnings per day/week/segment do not take into account any bonuses you have input, since bonuses aren't accrued from your actual activity. However, bonuses will still affect your projections for how much time you have remaining.
—Data and projections are calculated based on all flights you have entered, NOT only on flights up to the current date. So your stats per day reflect your stats from January 1 to the date of the last flight you have entered. Dates that have already passed in your list of flights will be highlighted green to show your progress.
—Similarly, the "TIME" stats will show how many days/weeks have passed or are left in the year based on the last flight you have entered.


I haven't shown this to anyone except my fiancee so I apologize if it's unclear or confusing. Again, I just made it as a fun tool for myself, not for public consumption, but hey, maybe someone else might find it useful. If you have any questions I'll try to address them, although I can't really promise I'll implement any feature requests.