For the record, I've been using this calculator now on my own travels for several months and am finding that it's generally allocating the AQD down to within a few cents, sometimes exactly on the nose, so for those frustrated with not knowing what their AQD is going to be, I think this is a good resource.
Of course, it depends on putting in the right data and not mucking around with the model, but that shouldn't be too difficult, there are detailed instructions in the Instructions tab...
Originally Posted by
flyquiet
Since you are only supposed to edit the blue cells, shouldn't the fare be blue?
I've sort of neglected this thread for a while and not really checked the uploaded version. Yes, unfortunately someone who was using the spreadsheet to calculate some stuff got rid of the blue font on the fare.
I've uploaded a new version to fix that, along with a couple other minor things.