A couple of years ago I made a similar post revealing my mileage tracking spreadsheet for United (or any airline for that matter). And while I love technology and my favorite app that still tracks my United balance (and so much more: PageOnce), I get a certain satisfaction out of my old school method.
I made a couple of changes since the last time I posted it, so I thought I’d share my updated version below – click it for a full view.
Each line represents mileage earning or redemption (none currently showing) activity and I currently track redeemable miles (RDMs), elite/Premier qualifying miles (PQMs), cents-per-mile (CPM) fare information and lifetime miles.
The first line is my beginning MileagePlus balance as of January 1, 2013. My first flight of the year on January 19 was United Express flight number 6228 at a purchased fare class of “T” on a Canadair CRJ-200. I use the leading letter of the fare basis code – “T” in this case – as it’s the one that determines mileage accrual rates. I geek out tracking aircraft registrations, so I keep a record of those in the next column.
Continuing on, it shows I was seated in 4B, I earned 500 “butt-in-seat” miles for the flight, another 500 miles as my 100% elite Premier 1K bonus, and zero for any fare bonus to total 1,000 redeemable miles for the flight. I keep a running tally of those miles to quickly compare my spreadsheet amounts against what United shows online.
Next, I record my individual PQMs for each flight and a corresponding tally. After that comes the cents-per-mile (CPM) calculation, which is a formula dividing my out-of-pocket cost (the $ SPENT column) by the total PQMs for the itinerary. And since I’m oh so close to million-miler status, I have a lifetime mileage column that progressively adds each line’s flight mileage (so long as it’s United metal).
I add everything booked and not yet flown (the redacted portion) to reveal a total CPM and airfare spend for the calendar year, along with the amount of miles remaining to hit million-miler.
And this year I decided to add e-cert data at the bottom as a back up to my paper versions filed away.
Do you maintain a spreadsheet or have you gone totally online to track your miles & points with a service provider?