Originally Posted by
jrl767
< GEEK ALERT >
I started out with a pen-and-ink ledger ~1971, and typed everything into an Excel spreadsheet ~2014 ... haven't updated the paper version in a long time, but the book is in a plastic bin along with all my ticket envelopes (thru ~2016) and boarding passes with the aircraft registration noted
the main spreadsheet tab has running totals by airline, equipment type/model, routes -- city pairs, airports (latest info
here), direction -- and the like; there's another tab tracking tail numbers by type by airline; a third has last flights on a model/type (relevant to
the "Obsolete Aircraft" thread)
currently at 2775 flights (2409 commercial) and approaching 2.7M total miles flown
< / ALERT >
At least you're not the only geek - I do this too with all of the same info. I have a FlightMemory account and around the same time (2014-2015) I copied everything into an Excel Sheet in case FlightMemory ever goes offline one day. Then I don't lose everything with no back-up records. One tab in my spreadsheet is the primary with all the main info logged (including a column for cumulative mileage) and then I have sub-tabs in the spreadsheet that track city-pairs by number of times flown and aircraft types by number of times flown. What is interesting to me is that I can tell there's some sort of rounding that FlightMemory does to the whole number on the displaying of the distance but for total distance flown, uses a decimal figure because the total distance flown in my Excel Spreadsheet is about 10-20 miles off from what my FlightMemory shows as my cumulative mileage.
It was in this spreadsheet that I found out that on a couple different occasions, I sat in the exact same seat on the same tail number on flights a few years apart. Kinda funny to think about.