Hi all

I put together a quick and dirty spreadsheet to calculate (or recalculate) the MQD posted to my account.

I discovered that several complicated itineraries, mostly international flights and IROP-ed trips may or may not reflect accurately on the activity page. I figured I would start reporting the discrepancies now rather than in 2014 when they really count. Hopefully DL figures out what's causing the inaccurate posting and fixes it by then. I also learned how Delta applies the rules to reflect the MQD spend and build the spreadsheet off of that. Here is what I know:

1) MQD are allocated per segment distance based on the total base fare and trip distance
2) YQ and YR, if applicable, are applied per segment and in the same ration as the base fare MQD
3) The base fare is the sum of all fares in the fare construction line on the ticket receipts. YQ and YR are reported in total
4) In an open jaw scenario, the allocation per segment is based on total airfare, not the fare per direction (e.g. 1200 for NYC-MAD and 1400 for FRA-NYC is 2600 allocable base)
5) Great circle mapper is awesome. But we knew that.

If you are interested, feel free to open, tinker, and save for your enjoyment. I input an example trip to illustrate how the posting should work. Use the yellow cells only.

Also, feel free to merge with the main MQD thread.

https://docs.google.com/spreadsheet/...UE&usp=sharing