I've been tracking my frequent flyer miles and doing "what-if" planning using a simple spreadsheet in excel. I've been meaning to write some kind of program for taking a list of airports (mht-phl-sfo-phl-mht) and calculating the distances covered and the various bonus and status miles from it.

Last night I got some extra energy and whipped together smiles.zip which is an excel spreadsheet (with about 700k of airport data) that does just that. Also learned some new tricks in excel and dusted off my visual basic skills. The download is a 279k zip file. Enjoy!

info