My Flyertalker Yearly Spreadsheet
 

I know that a lot of FT'ers track their travels on a spreadsheet. I started doing that at the beginning of 2006, and it has been very helpful. It guided my decisions as to which FF program to credit, how many extra segments to squeeze in, whether I need a mileage run, it let me know how I was doing in upgrades, etc.; I added notes about the segments, my personal opinions of seats, and whatever.

I'm not an Excel mavin; I normally don't use spreadsheets, and I've probably created less than 15 in all my computing years. Therefore mine is a primitive ugly mess, but it still has helped a lot. I know many of you have much better setups, so I'm posting my template just to get the discussion rolling. My hope is that some of you will rework mine, and others will share your spreadsheets, and others will modify the spreadsheets which you share. Eventually this can lead to the creation and sharing of a killer Flyertalker Mileage Spreadsheet. It will be handy as the new year starts.

I can host any spreadsheet templates on my site if you don't have web space.

http://stonecarver.com/flyertalk/spreadsheet.html

One thing I plan to keep for the next year is scheduled departure and arrival vs actuals. I want to see for a year just how much time delays are costing me!!!!

I track my AA free domestic upgrades on Yahoo notepad (53 of 54 cleared this year). As the AA website is pretty reliable with posting, haven't had the need to track actual flight miles (over 500,000 miles worth of flights have posted without a problem). Even with the little I track, I just found it too complicated to do it on an Excel spreadsheet on one specific computer. Google has an on-line spreadsheet application now that would be a good alternative to Yahoo notepad, as you can update as you're out traveling about. Have you tried it?

Suggest you have separate categories for EQM and RDM. Both important things to track.

Glenn

Thanks for posting your template. Great idea! :)

I've added Fastfil1's template to my Flyertalk Mileage Spreadsheet page. It includes some good ideas and better underlying programming than mine.

Anyone else care to share, or to rewrite either of these spreadsheets? I'd like to see this develop into some good choices before we all start logging our 2007 flights.

btw, if you e-mail your spreadsheet for posting, make sure it doesn't have personally identifiable data, and in particular look under file/properties/summary, delete your name and company name (unless you want everyone to be able to see that).

Bump.

I've added hmc's trip log template to the collection.

I only saw 2 flights since 2006. :D

These are just templates, so anyone can modify them to suit their needs. I'm making sure the data in the cells is pretty generic before I post them, no personal identifying info. hmc does a separate spreadsheet for each major trip, whereas I maintain one for each year.

nice, thanks :)

Thanks, very helpful.

I've updated the miles/flight tracking spreadsheet collection at http://stonecarver.com/flyertalk/spreadsheet.html with some exceptional contribs by McFlyPHL and BRP of the AA forum.

If anyone else has different spreadsheet templates, e-mail them to me through the link on that page and I'll include them.

United sheet for 2P and 1P
 

I've sent my United MP excel tracking sheet to Gargoyle for him to post on his page. I imagine it will show up there in a few days. [edit: it's there now. Thanks Gargoyle for posting it]

It is best for United 2P's and 1P's since I track BIS, E500 earns/burns/balance, EQM, RDM, and some other things. 1K/GS might find it lacking since I don't track instruments other than e500's.

If anyone wants to see it sooner, PM your email address and I will send it to you. This excel sheet is based on the original I created and maintain in Google Docs-Spreadsheets. Google makes it easy for me to track lots of data from any computer with connectivity, I don't need to have my own machine with me. I love Google Docs. [note: I don't work for Google, nor do I own GOOG]

Excellent point - thanks!! My spreadsheet tracking has been pretty simple, since there are no consumable upgrade instruments on US, but it would be nice to access and update that information from anywhere. I've used Google docs for workplace sharing - I don't know why I didn't think of putting the flight sheet up there earlier.

Thanks forthe contrib. Using a spreadsheet to track flights sure helps; especially this late in the year when getting close to a status level threshold, and you need to tweak those last few EQM's.

Not a bad way to pass the time... while you are waiting on the tarmac.

_______
http://StatusMatcher.com - Travel like a champ!

I've updated the spreadsheet collection with a nice contrib from N515CR, a spreadsheet which tracks multiple airline programs with miles/city pair data built in. http://stonecarver.com/flyertalk/spreadsheet.html

I've updated the spreadsheet collection once more, a couple new ones.

If you have a different spreadsheet template that you would like to share with the community, please PM me or e-mail me through the spreadsheet page. URL in my sig.

Now that is a resurrection!

Thanks, found somethings that gave me an idea.

Thanks for updating this. As most of the spreadsheets up to date with current program details, or if not which ones are the most recent?

Thanks, John

The most recent is Gobluetwo's 2012 mileage tracking template.

I'm personally a spreadsheet junkie... I'm sure some of these other ones are documented extensively elsewhere, but just in case anyone else is looking for them, here's some other good tables/spreadsheets:

MillionMileSecrets has a good section putting together many of the different award charts.

The Man of a Thousand Places blog has put together some excellent spreadsheets/resources as well, including:

• A churn planning tool that I used for my first 410,000 mile/point churn!
• Airline miles valuation
• Hotel points valuation
• Several others

Anyone have any other good spreadsheets/workbooks?

- John

Thanks for resurrecting this thread. This makes my little attempt look pretty feeble.

Cheers

I don't travel for business anymore, but I still do a bunch for personal and fun, so I decided to keep maintaining status. However, this has necessitated a few mileage runs, and last year I didn't do the math until so late in the year, I spent Christmas in Vegas.

So I decided to make a spreadsheet so that I would always know where I was/will be.

First try was to take the ARPT.DAT out of the old Flying Fish program and calculate distance using various Great Circle formulas that I found throughout the web. However, I kept getting slight differences between the formulas and the AA / IATA distance (ORD-MCO was 1006 instead of 1005 and PHL-DUB was 3263 instead of 3273).

Then I got directed to this thread and was able to use the table of AA city pairs from one of the spreadsheets posted above. However, its from 2005 and especially with the US merger, there are tons of routes missing.

So... A) Anyone have any idea why none of these formulas work and all are slightly off base? The source data is from Flying Fish and that gets the right distance, so it's something in the calculation.
=3958*((2*ASIN(SQRT((SIN((RADIANS(H10)-RADIANS(J10))/2)^2)+ COS(RADIANS(H10))*COS(RADIANS(J10))* (SIN((RADIANS(I10)-RADIANS(K10))/2)^2)))))
=ACOS(COS(RADIANS(90-H10)) *COS(RADIANS(90-J10)) +SIN(RADIANS(90-H10)) *SIN(RADIANS(90-J10)) *COS(RADIANS(I10-K10))) *3958
=ACOS( SIN(H10*PI()/180)*SIN(J10*PI()/180) + COS(H10*PI()/180)*COS(J10*PI()/180)*COS(K10*PI()/180-I10*PI()/180) ) * 6371000 * 0.000621371

Or... B) Does anyone have an updated AA route chart, or something scrapable to create one with all the new routes?

http://andysite.net/directory/aastatusexcel.PNG

Looks like a pretty sophisticated spreadsheet!

That looks like a Haversine formula, which is very close but not an exact match for the Earth's actual shape. I don't think you can get much more accurate in an Excel formula.

I've updated my page of mile tracking spreadsheets. It now includes the 2016 AA Flight Tracker, courtesy of JDiver. You can download a copy at http://stonecarver.com/flyertalk/spreadsheet.html

Thanks for sharing.