Please contact me for any Excel project work that you need. Written 10/27/2020.
My email address: dhExcel1@gmail.com
The creation of a round robin tournament is a common topic in a Google search of the subject, and there are a myriad of different levels and complexites demonstrated. I decided to make a calculation model that would make this easy to do.
Starting in cell AK2, the names of the teams in the tournament are listed. For every name entered, a consecutive number must also be entered, starting with 0 in cell AL2. See the following figure.
And, that’s all you have to do!
The process runs entirely on Excel formulas – no VBA is used.
The resulting tournament schedule is shown in the following figure (partial view).
The workbook is completely unprotected, so feel free to discover how to works. There are a number of interesting and complex formulas used in the design of this model, both on the worksheet, in conditional formatting and in defined name formulas.
It is difficult to visualize the entire tournament bracket at once. Perhaps I will leave that issue as an exercise for the user.
The file can be downloaded here.
Enjoy!
Pingback: #Excel Super Links #54 – shared by David Hager | Excel For You
Pingback: #Excel For You Blog Posts Having Downloadable Workbook Files by David Hager | Excel For You
Dave, Excellent Job on the Round Robin Scheduler. Very elegant use of functions!
Best Regards
Greg
Pingback: #Excel Super Links #150 – Special Edition | Excel For You
Excelent Dave, I just can’t figure out how you did A1:AH35 matrix (=@TeamToPlay)??? How do you get numbers and BYE???
Thank you so much for this, I just used this to create a schedule for a speed networking event I am planning. This has saved me a huge headache!
How would one create a pickleball doubles Round Robin using your well thought through spreadsheet? The example I would like to create as 16 entrants playing on 4 courts. Is it possible to create a random draw using it?
Functions refer to cell B5,B6….How can we see the value of those cell and change it.
I would type a:aj in the name box and press Enter.
Thanks for this spreadsheet and I understand how it works. However I am looking for a round robin spreadsheet scheduler for tennis doubles parings. Individuals sign up and then are randomly paired with a partner to play, for example, 6 to 8 games. The Round Robin is completed in a few hours. I realize that all players will not get paired with a different partner, nor can they play against every other pairing as the number of games it would take would far exceed the allotted time. I would just take the pairings, for example, of the first 6 rounds (weeks in your example). Please let me know if this is possible. Thank you.