The attached spreadsheet contains Excel macros (VBA) and web links.
This sheet is in no way affiliated with or endorsed by OneWorld, FlyerTalk, me, my kids, or anyone else.
Use at your own risk.
Provided "AS IS"
Version 0.9.5a is a work in progress that is almost ready for general use, it requires Excel 2007.
Version 0.9.6b has been uploaded, it supports Excel 2007 (.xlsm extension) and an untested Excel 2003 version (.xls extension)
Version 0.9.6c (bug fixes) has been uploaded, supports Excel 2007 and Excel 2003.
Features (some only work with macros are enabled:
- Ability to sort and filter by fare and/or country of origin
- Highlighting of ten best fares within a fare type (xONEx or xGLOBxx)
- Choice of country of origin
- Choice of class of service and number of continents (number of miles for Global explorer)
- Choice of "home" currency
- Automatic comparison of fares from chosen country of origin to best available fare at the chosen fare type
- Automatic comparison of fares in different classes of service for country of origin
- By running a macro (using OneWorld.com):
- <Ctrl-o>: Update fares from a single country (the country associated with the row of the selected cell is one).
- <Ctrl-u>: Update all fares (over 125 countries).
- Update of each country fares takes 3-15 seconds, updating all fares can take a very long time.
- Automatic update of exchange rates every time the file is opened (using CoinMill.com)
- Ability to override exchange rates
- Calculate cost per Elite Qualifying and Redeemable mile
Please report any issues, suggestions and enhancement requests on FlyerTalk: xONEx and xGLOBxx Fares analysis spreadsheet
known issues:
- When changing base currency, formatting might not work until user causes a refresh (i.e.. Sort, "Format" a price cell)
|