Originally Posted by CelticFlyer
No just the actuaries, accountants and people on sales commission!
Don't forget the engineers!
2004 Rules: 70,857 = Gold
2005 Rules: 74,296 = Gold but I would have found a little MR for Platinum
The difference was a couple of Transcon LUT fares and a CO equivalent.
Originally Posted by sibley
I'm curious--for those of you who do tracking with your own spreadsheets, what all do you track? In what way has tracking been most advantageous to you? Did you create your own spreadsheet, or do you use something that's out on the market?
I created my own fairly simple spreadsheet last month. I simply cut and pasted the information from the Delta Website for July-November. I didn't fly that much from Jan - June (I hit 25K in September and 50K in October) and I just entered that information manually from my hardcopy statements. I have the following columns:
Date,
Type, Description,
Class of Service, Miles, Bonus Miles, Total Miles, MQM Earned,
Flights, and now
2005 MQMs.
The columns in Bold above are the ones that I added, the others are directly from the Delta Website. The "type" column is a field I used to categorize each type of mileage earned (my categories include Flight, Bonus, Idine, Rental Car, Credit Card, Promotions, Web Site, Award). The Description column includes a lot of information from the Delta website including flight number, origin, destination, and class of service). My "class of service" column is the class of service from the description column. I didn't bother breaking the other items out of the description column since I don't really need them for any calculations. My "flights" column has no data per entry, it just totals the number of segments based on the number of times the "type" is "Flight". And I just added the 2005 MQMs column where I manually entered the 2005 MQMs for each flight based on the new rules.
I have a number of calculations that use the "type" field to sum or count miles by type. I haven't created a column to track the running total so I can see my actual skymiles or MQM levels on each day of the year. However, if you highlight a group of cells, excel sums the highlighted cells. So I can easily check when I made 25K and 50K MQMs or check what my balance was on any given day.