...
Instructions how to fill in the markups and commissions for flights:
1. This file contains different rules for markup and commission calculation. Only if all conditions match to the current offer, the corresponding rule will apply.
2. Empty or "-" cell value means that this condition is not checked. In this case this condition has lower weight as compared with the cell with concrete value.
3. Commission is always calculated from basic fare (without taxes).
4. Its possible to use slash (/) for OR logic and expression NOT () to exclude some values (for example, "Everything except LON" can be written as NOT (LON)"
5. In order to apply several conditions at once, use "&" (for example, "all CIS countires except Russia can be written as "CIS & NOT (Russia)")
6. It's also possible to specify ranges, like "4001:4999"
7. For correct calculation it's important to keep current structure of file and order of columns. The lines can be added.
...
The sample you can find in the Excel file template.
...