Hi all,
Thanks for the kind comments, and thanks to
CheeseToastie for a few data sources (UK APD & a method for calculating the distance between airports).
As a result I've updated the tool to include a UK Air Passenger Duty calculation and miles between airports (you never know, it
might help you work out the longest leg for
some reason....)
I've also put in the following fixes;
- Taxes only included the first 5 flights - Now counts all 10
- The credit card payment was double counting with multiple passengers in some scenarios - tweaked the formula
Originally Posted by
baggageinhall
Tried running it on my Mac
Based on the comments around the Mac being slow (I can't test as I don't have one) I'd recommend;
- - Change the cell saying 'Calculate costs as you go along' to "No"
- - Complete all your flights etc
- - Manually run the (new in version 0.2) Macro called RunManualCalculation - not sure if it will work or not, I don't have a Mac to test.
Originally Posted by
anishub
May I suggest if someone could built a macro that can give the best routing/airline for a particular city pair? That would be very useful for folks who are building an itinerary, especially on *A carriers.
In my own view there are too many different factors (key being seat availability - but also the airline quality, taxes, cost in BD miles, distance, flight connections) to consider - whilst it would be feasible (with quite a lot of coding) I think you'd get much better feedback on the board by asking, rather than using an Excel calculator so I won't be spending the time adding this at the moment.
-----------------------------
And everyone is right, it would be much better on the web, sadly I've no web hosting (or desire to get) and this was only a bit of a refresher course in Excel for me - not a web programming exercise
. Feel free to develop one of your own, and you're quite welcome to reuse my code too - happy to help with that but sure it would be simple to do with PHP & MySQL.