# Swiss Pairing algorithm in excel to organize a chess tournament

1. ## Swiss Pairing algorithm in excel to organize a chess tournament

Hello masters,
For now I try to figure out but maybe someone has already the answer; I want to use excel to pair chess players using swiss system for tournament, in my case it will be maximum 30 players(player1, player2...), in first round they will be randomly paired, then rules are as below:
Winner : +1 point
Draw: 0.5 points both
Loose: 0 point

a
The number of rounds to be played is declared beforehand: In our case "5" rounds is OK.

b
Two players shall not play each other more than once

c
Should the total number of players be (or become) odd, one player is unpaired. He receives a bye: no color and as many points as are rewarded for a win

d
A player who, for whatever reason, has received any number of points without playing, shall not receive a bye.

e
In general, players are paired to others with the same score, if it is impossible they should pair with scores as close as possible, meaning for example at the final round (5th round) the strongest player can not match the player at 10th place or further, it must be someone around 3rd-6th place.

f
For each player the difference of the number of black and the number of white games shall not be greater than 2 or less than –2.
Each system may have exceptions to this rule in the last round of a tournament.

g
No player will receive the same color three times in a row.
Each system may have exceptions to this rule in the last round of a tournament.

h
1.In general, a player is given a color as many times as he is given the other color.
2.In general, a player is given the color other than that he was given the previous round.

3. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

OK, as the subject looked interesting, I did some "homework" over the weekend.

And here it is - may be not a quick one, but the sport is also not skatering-quick.
After short testing seems to do the job. I only not implemented one of features mentioned in the description: Once the tournament starts, all scheduled matches are completed. No chance to quit between rounds (or during a round).

The buttons "Just for test ..." on Players Sheet and "Generate" on Rounds Sheet shall be removed before using worksheet during real tournament.

4. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi Kaper, Thanks a lot, even that I could not help any from my side.
I will try it on our amateur tournament and share if any problem appears, probably not, it seems to work like a charm!
Now I will try to add a live rating calculator in your file, it is much more easier so I hope I can sort it out.
Thanks again!

5. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

As for live rating calculator - you mean after each round?
If only collected points count - it is already there.
See what happens, as you save the results of any round to statistics sheet. Column I is sorted descending by points. (I have not sorted row 2 as this would be just duplicating info).
So comments right/down to J3 are relative to player in column I

6. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi, in fact rating data that I am talking about is according to ELO formula: http://everything2.com/title/Elo+rating, indeed: Rn = Ro + (K * (W - We))
In any case I manually added it in the file(attached) as example, as I am not expert on macros I couldn't manage to integrate it in your macros so far.
Idea is:
- to have ratings and K factor written at the beginning with player names on "Players" sheet.
- Then to add old & new ratings after each round for each player.

7. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

There's an Elo ranking workbook at https://app.box.com/s/40zgcunukurwnn8mdcdw that you may be able to adapt.

8. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi Kaper,
After an awful lot of searching I found your spreadsheet that goes a long way to answering my 'need'. Unfortunately, it's written for chess which has draws (no big deal) but backgammon has scores, 5/4, 5/3, 7/2, 11/6 etc. depending on the round you're playing and/or the tournament structure (all rounds might be the same i.e. to 5, 7, 9, .....23 points)
Thanks,
John

9. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Wow, it's pretty old thread "reheated".
Please be more specific, and attach a sample showing output odf current approach and expected output (together with explanation why shall it be different than current).
Remember that I'm for sure not fluent in chees/backgammon nor in swiss pairing (as a matter of fact - any pairing) algorithm so what seems quite specific for you: backgammon has scores, 5/4, 5/3, 7/2, 11/6 etc. depending on the round you're playing and/or the tournament structure (all rounds might be the same i.e. to 5, 7, 9, .....23 points). etc. means not-a-lot for me.

Please note also rule 2 of our http://www.excelforum.com/forum-rule...rum-rules.html

10. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi,
apologies if a new thread would be more appopriate - tell me if so. I am interested in an expansion to this spreadsheet, in the similar way to the backgammon question. It is like rugby, where the score that a team gets is a combination of the number of tries and the number of kicks - so instead of just entering "win" for white, you enter "2 tries, 7 kicks" and that gives a score of 2x5 + 7x3 (5 for a try, 3 for a kick). I would like to be able to enter the number of tries and the number of kicks. I will have a go at doing this myself, but if you were able to have another look at it that would be amazing.
Thank you,
Mike

11. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

sann0638 welcome to the forum

Refer back to this if you think it is relevant

13. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

I love this excel spreadsheet for Swiss System tourney. It's perfect for our in house Elementary school chess club tourney. Thanks so much!

14. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi Kaper, Im new to excel and VBA im looking to do a random draw for darts in a round robin competition, with 20 players playing each other 3 times. and really not sure where to start. If at all possible help is very much needed.

Rowdy

15. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi Rowdy,

Have you tried to use (parts of) the files above or from the links in posts above?

By the way, it's pretty old thread, so rule 2 of https://www.excelforum.com/forum-rul...rum-rules.html shall be observed strictly.

16. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi Kaper really sorry , very new to this

17. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Is "Owner" of this algorithm here? I need some answers, sugetion and more...

18. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Originally Posted by TasicV
Is "Owner" of this algorithm here? I need some answers, sugetion and more...

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

19. ## Re: Swiss Pairing algorithm in excel to organize a chess tournament

Hi all... there is rule for swiss pairing system. This algorithm have some little errors. You must find and look what say in the Rule of Swiss system pairing.
Please make correction in pairing. Like, in first round List of player must have index by rating, then make group 1, and group 2 of list, then first player against last player of group...
Thanks on very interesting algorithm! I am chess player and chess arbiter, so I have "Swiss Manager" software, but I think this is good alternative of algorithm for make Android software.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1