I've just finished Version 0.4 in the last half hour, a real milestone and incorporates more bug fixes based on feedback, as well as improving the operating mode and dealing with lifetime statuses.

I'm pretty sure I've captured all the bugs and feedback of anat0l and medhed to date (once again, greatly appreciated gents).

I'll say from the outset there's a truckload of hidden columns in this spreadsheet and a bucket load of extra worksheets with data for lookups. This is to firstly enable the system to handle additional airlines or changes in information, and also for multiple calculations and evaluations to deliver the right result. It may not be the cleanest solution for achieving it right now, but the main thing is that it works well, and works consistently.

Improvements specific to V0.4

• full summary of results, including points/sc's earned, lifetime loyalty bonuses earned, and value proposition summary now included at top of sheet in full.
• Status calculations now fixed completely, will factor all statuses correctly relevant to the operating mode and starting status, and accounts for starting with or earning lifetime status.
• Lifetime loyalty bonus calculations now factored into the spreadsheet.
• GCM link corrected to ensure miles and not nautical miles returned.
• Additional MPG formula column fixes completed, cabin and status bonus points now correctly calculated on base points and not sector mileage.

Features

Currently the spreadsheet will:

• Allow you to enter/select the airline, departure and arrival airport, cabin class and number of miles flown.
• If number of miles is unknown, a single click will pass information on that sector thru to Great Circle Mapper to get the estimated mileage.
• Ensure you've entered in the valid arrival and departure airport codes
• Calculate miles based on the earning ratio you specify (this is soon to be automated to pre-fill with earning ratio for airline and cabin class specified). If flying a carrier in a cabin class where SC's aren't earned, a zero value for all fields after earning ratio while still ensuring rest of spreadsheet calculations remain valid.
• Work out if a minimum points guarantee is acceptable to the carrier, and apply accordingly based on the airline and cabin class.
• Calculate if status credits, cabin bonuses and status bonuses are earned and apply accordingly.
• Provide a running total of miles and SC's earned.
• With sector cost information entered, provide some decision-making information

Download
Feel free to download the spreadsheet (MS Excel, 471kb) and let me know what you think of the latest improvement set.

A sample spreadsheet tab is also included so you can get a better idea of how it works.