Hi Everyone,
I was trying to calculate whether or not my existing flights for 2017 would get me to MVP Gold 75K status this year and made an excel spreadsheet I thought I would share with everyone. Here is a Dropbox link to the file:
https://www.dropbox.com/s/0x2o4i4i52icscg/Voldoo_AS_StatusCalculator%20-%202018.xlsx?dl=0
The spreadsheet is pretty self-explanatory.........basically you enter your starting mileage and status levels. Afterwards, use the table to enter your individual flight segments be completing the following required fields:
- Airline
- Ticket Class
- Miles Flown
The spreadsheet will automatically calculate your EQMs, and MileagePlan miles based on the mileage flown and your status.
Please keep in mind this sheet calculates this based on CURRENT partner mileage redemption rates. I do not plan on updating the spreadsheet myself, but intermediate to advanced users should be able to make necessary adjustments to mileage rates and partners going forward.
I found this quite helpful in figuring which mileage runs would be most helpful so I figured I would share it in hopes some of you are able to use it as well.
Best,
Voldoo