Originally Posted by
Adam Smith
But I guess that I can just throw up a flag and let people go look those up themselves. It should enable most of them to be automated and only require manual input for a few, whereas right now it's 100% manual.
Yeah, that's exactly what I do. I flag combinations of fare and carrier that could have more than one earning rate and then default to the lowest multiple unless the user (that's me!) overrides with a different one.
In your example, that means LH has two lines in my "Multipliers" spreadsheet one for Europe and one for ROW. Some not so cleaver logic on that sheet sets a flag for any carrier with more than one row of data. Crude, but it works and, like you said, the exceptions are relatively few.
My next project is to try and get the same tables / logic to accurately interpret AC branded fares. Maybe I will do a self-proof of Fermat's Theorem first just to limber up.