Closed Thread
Results 1 to 21 of 21

Swiss Pairing algorithm in excel to organize a chess tournament

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    Romania
    MS-Off Ver
    2010 English
    Posts
    6

    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.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

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

    May be not_so_excel suggestion, but if no more than 30 players are expected, than why not use for free http://www.vegachess.com/tl/index.php/downloaden.html ?
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    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).

    Test and share your comments/experience.

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

  4. #4
    Registered User
    Join Date
    12-02-2014
    Location
    Romania
    MS-Off Ver
    2010 English
    Posts
    6

    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. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    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. #6
    Registered User
    Join Date
    12-02-2014
    Location
    Romania
    MS-Off Ver
    2010 English
    Posts
    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. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    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.
    Last edited by shg; 09-30-2015 at 12:25 PM.
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Registered User
    Join Date
    09-27-2014
    Location
    Sydney, Australia
    MS-Off Ver
    2007
    Posts
    16

    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)
    Would I be asking a lot to have this capability added to your algorithm, please?
    Thanks,
    John

  9. #9
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    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
    Last edited by Kaper; 04-25-2016 at 03:44 AM.

  10. #10
    Registered User
    Join Date
    06-18-2016
    Location
    Swindon, UK
    MS-Off Ver
    365
    Posts
    4

    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. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    sann0638 welcome to the forum

    Yes, please start your own thread for your question (otherwise it's eeek hijacking lol)
    Refer back to this if you think it is relevant
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  12. #12
    Registered User
    Join Date
    06-18-2016
    Location
    Swindon, UK
    MS-Off Ver
    365
    Posts
    4

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


  13. #13
    Registered User
    Join Date
    03-02-2017
    Location
    Wheaton, IL
    MS-Off Ver
    7
    Posts
    1

    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. #14
    Registered User
    Join Date
    12-06-2017
    Location
    england
    MS-Off Ver
    2016
    Posts
    2

    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.
    Thanks in advance

    Rowdy

  15. #15
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    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. #16
    Registered User
    Join Date
    12-06-2017
    Location
    england
    MS-Off Ver
    2016
    Posts
    2

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

    Hi Kaper really sorry , very new to this

  17. #17
    Registered User
    Join Date
    11-29-2020
    Location
    Serbia
    MS-Off Ver
    2019
    Posts
    2

    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. #18
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    Quote Originally Posted by TasicV View Post
    Is "Owner" of this algorithm here? I need some answers, sugetion and more...
    Administrative Note:

    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.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

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

  19. #19
    Registered User
    Join Date
    11-29-2020
    Location
    Serbia
    MS-Off Ver
    2019
    Posts
    2

    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...
    Please also make corection abouth FLOATS playaers.
    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.

  20. #20
    Registered User
    Join Date
    01-06-2022
    Location
    OHIO
    MS-Off Ver
    Office 2016
    Posts
    1

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

    I tried to use this but I have an extra problem. Since there is no Bye option for the win lose or draw, where do I put the student's name so they win? If they have no opponent what do I put in the opponent column? Would I do the opposite for a loss? I had a few that didn't come to the first round of tournaments. How do I score them? I hope this makes sense. Thank you,

  21. #21
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

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

    Administrative Note:

    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.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel algorithm help
    By Kyle1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2014, 01:48 PM
  2. Selectively pairing down an Excel list
    By freemasen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2014, 03:42 PM
  3. Using Excel for tournament
    By dswa85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2014, 01:48 PM
  4. how to get the chess notations in columns?
    By sumesh56 in forum Excel General
    Replies: 38
    Last Post: 05-01-2014, 07:53 AM
  5. Replies: 1
    Last Post: 10-04-2012, 09:26 PM
  6. Pinochle Tournament Pairing
    By vbianchini3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2012, 03:53 PM
  7. Excel SUMPRODUCT, INDEX function pairing
    By jcountzler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2009, 04:01 PM

Bookmarks

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