Hello
maybe I am not in the right place to ask this question. If so, please redirect me to another website.
I would like to create an automated excel spreadsheet for our sport event. We have many different teams form different countries and some game officials also from different countries.
I would like to organize game referees based on their nationality, regardful to this rules:
1. Game referee can't be the same nationality as the both teams are.
2. Same game referee can't officiate two games at the same time.
3. Same game referee can't officiate more than two games after each other.
Please find an rough draft of the schedule below in the attachments.
Basically what I would like to achieve is, that excel chooses a game official from the bank of officials by respecting those rules.
Thanks for all your support and help
Klemzy
