Latest Version: Currently 0.3a, Released on 13th February 2010
Latest version has all the latest *A flights, including CO/SN and differentiated Business/Economy pricing as well as seasonal routings.

Hi all,

I've created a simple BMI Redemption calculator in Excel to work out the likely approximate cost of a BMI award flight - it builds in the great work from salvadors(and now my own tax calculations from his inspiration) (http://www.flyertalk.com/forum/bmi-d...xes-chart.html) to add taxes, as well as a bit of my own code (I did this as part of a refresh of my Excel skills). CheeseToastie gave me a helping hand in getting more routings and a few other data points to make the tool more comprehensive - thanks!

So you put in your route, airline and class - In return it will tell you the expected airmiles, cash and taxes cost of that flight (for both a C+M and all miles routing).

Its not a replacement for ITA, but, it is (at least for me) a good way to quickly work out what routes/airlines are available for certain cities (it autopopulates with only valid routes), and an approximate cost of my potential redemptions (in miles and cash) before I dig down into the final pricing & availability plus being able to double check the ICC's sums.

You can download it here from a free hosting site (sorry about any ads, nothing to do with me);
http://www.mediafire.com/file/wigedn...ator-v0.3a.zip

If you notice any bugs, or would like me to add any features then please let me know - there is a list of data points that I'm looking for to expand it - if anyone can help me with the below please do let me know;

• An automatic check of the classes available on a route - this would require a list of airline routes and classes available (in no hurry to do this as it changes too frequently)
• Complete the list of countries that *A flies to, but for which I didn't know the BMI zone

Hope this is useful for someone - its been fun for me to quickly price up redemptions,

Regards

littlevoices

PS: It was much simpler to do the calculator using code, as such you'll need to enable Macros to let it work. I've left the code unprotected though so you can check there isn't anything malicious there.