My Flyertalker Yearly Spreadsheet
#1
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
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
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
#2
In memoriam
Join Date: May 2005
Location: DAL
Programs: SWA A list preferred and CP, Hilton Lifetime Diamond, Hertz President's club
Posts: 9,803
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!!!!
#3
In Memoriam, FlyerTalk Evangelist
Join Date: Jun 2000
Location: Benicia CA
Programs: Alaska MVP Gold 75K, AA 3.8MM, UA 1.1MM, enjoying the retired life
Posts: 31,849
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?
#6
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
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).
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).
#7
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
#9
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
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.
#12
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
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.
If anyone else has different spreadsheet templates, e-mail them to me through the link on that page and I'll include them.
#13
Join Date: Dec 2002
Location: Omaha
Programs: UA/*A nobody, Bonvoy Plat, SW A-list, Hertz 5* (but who isn't???)
Posts: 677
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]
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]
Last edited by omahajim; Oct 18, 2007 at 4:55 pm
#14
Join Date: Jun 2006
Programs: Various
Posts: 6,526
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.
#15
FlyerTalk Evangelist
Original Poster
Join Date: Mar 2004
Location: Under an ORD approach path
Programs: DL PM, MM. Coffee isn't a drug, it's a vitamin.
Posts: 12,935
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.