I have created this spreadsheet to schedule games for a round robin tournament. All you have to do is enter the teams in the cells highlighted in yellow and the dates in the cells highlighted in gray. The dates are optional. I have formulas in the cells showing the schedule. They are locked so you can't accidentally type in them. If you wish to unlock them, goto Tools > Protect Document > Sheet. When the box comes up prompting you for a password, simply click OK. I did not use a password.
Here is a screen shot of the spreadsheet. You click on the image for a larger view.
If you would like a different number of teams or other features, please let me know in the comments. I will do my best to add them. You click on "Spreadsheet Files" under "Links" on the right hand side of the page to get this file. It is an Open Office Calc file. Let me know if you need an excel file and I will convert post it as soon as I can.
5 comments:
Hi there,
It would be great if you posted this as an Excel document. I'm planning an office bocce tournament and I could really use a tool like this!
Thanks!
Josephine
Josephine,
Thank you for your comment. I have just uploaded an excel version. You can go to "My Spreadsheet Files" under "Links" on the right hand side of the page.
Any other comments would be appreciated. Any additions or things you would change.
Just wanted to say thank you for allowing me to access this file. I run a darts comp and its been great. Any chance of making it available for a 16 team r/robin?
Hello,
I am a high school soccer coach and would like to find a round robin spreadsheet to use during soccer tryouts. I don't have a great deal of background with Excel, but have used it more than open office.
At tryouts numbers vary in any given year. It has ranged from 80-40 kids at tryouts depending on the economy and what the housing market is like as people move in our out of our area for jobs. I want to use it for a 1v1 tournament at tryouts and tabulate wins/losses/ties to have some "hard" data. The candidates will have numbers to provide anonymity once tryouts are over.
Do you have any thoughts on how I can solve this? One night you might have 50 kids and the next night you could 60 or even 45 depending on a host of factors.
Regards,
JJ
Hello JJ. Here is the link I used. Scroll down to scheduling algorithm. It shows how to set the match ups. Hope this helps.
http://en.wikipedia.org/wiki/Round-robin_tournament
Post a Comment