Hello
I have started chess tournament at a cafe in my city Stavanger in Norway. For that reason, I wanted a different tournament form than the usual one. In my system, the winner is always moving upwards , and the loser moving downwards, That means that everyone meets appropriate resistance at all times. The one with the lowest number calculated using average number of all positions during the evening has been the best player. And because some players are coming late and some going early I have different and overlapping parts of the chess evening as tournaments. ex. 2-10 , 6- 14, (4-12)
The day after this chess evening I made an overview so that each player could see how the their placements changed according to their wins (green) or losses (red). But it was also important to give each player a highlight of placements during the evening, framed in black.
Anyway, this table, ‘Highlights’, that I worked a lot with manually, I would have liked very much to see this sheet generate more automatically next time.
The placements is okay. The blue numbers in row 2 (blue) in ‘S 1-9’ can be transferred directly to row 5 in ‘Highlights’.
But I can’t quite see how to get the name of the opponent yet.
You can see the games in “1-9”:
What makes it difficult is that at odd numbers a player must have Walkover (gray), but still have a position. Also, there are players who get a placement but who have gone home (red) before the next game.
I spent a loooot of time on this. (I’ve removed many sheets to make it more clear to you).
So this time I had greatly appreciated if I could save time and avoid looking for features and creative solutions to this problem.
Can anyone show me an easy way from the overview to the sheet I have called Highlights?
If something is not clear, please ask me !