Round Robin Tournament Scheduling 09/22/17 at 09:25:36 News: Up and running!

Hello, and welcome to this Round Robin Tournament Scheduling community. Hosted by Richard A. DeVenezia

about round robin schedules, or look at some .

 Pages: 1 2
 Court Balanced Round Robin (Read 110036 times)
 Richard A. DeVenezia YaBB Administrator Posts: 44 Gender: Court Balanced Round Robin 03/12/06 at 10:11:52   Ian Wakeling's spreadsheet will generate a balanced schedule for up to 100 items. Thanks Ian!   Download version 5.1 of Ians Excel file from the paper clip link Back to top « Last Edit: 04/03/14 at 06:18:00 by Ian Wakeling »   The Administrator.   IP Logged
 Ian Wakeling YaBB Moderator Posts: 1127 Gender: Re: Court Balanced Round Robin Reply #2 - 12/10/06 at 05:57:29   Here is an update to the balanced round robin spreadsheet.   New in version 3.5   10 court balanced schedules, that could not be generated previously, have been added.  The mathematics for constructing these schedules is not easy to program, so complete schedules are read directly from the hidden worksheet called "library". There are library schedules for 10,16,22,28,34,40,46,52 and 64 players.   In Home/Away format the cells of schedule are linked using cell formulae to the row names in column A.  So editing column A will let you rewrite the schedule in terms of actual team names.  Note that any edits will be lost the next time a schedule is generated.   Click on the paperclip to download the zipped Excel workbook. Back to top IP Logged
 Ian Wakeling YaBB Moderator Posts: 1127 Gender: Re: Court Balanced Round Robin Reply #3 - 01/08/07 at 13:57:57   Here is a further update.   New in version 4.3   The ability to randomize your schedule.  A different version of the schedule each time you press generate.   The team with a bye is shown when there is an odd number of teams in court/field format.   Click on the paperclip to download the zipped Excel workbook. Back to top IanBalancedRoundRobin_v4_3.zip (attachment deleted)       IP Logged
 mkranitz YaBB Newbies Posts: 1 Re: Court Balanced Round Robin Reply #4 - 01/28/07 at 20:27:42   Ian, hello and hats off to a great little applet you built.     I am trying to build one for Coldfusion and the Web and was looking at your "Library" sheet.  I'm assuming that is encrypted??  If not, my mind will melt.     Can you help a guy out?     Specifically, I need to wrap my head around either a pure mathematical way of generating the tables OR doing it mechanically with arrays and loops.   Thanks in advance.   Oh, this is a nice one: http://www.hometeamsonline.com/sportswebsites/?scheduler   I would like to build something that accepts variables like these.   Michael Back to top IP Logged
 Ian Wakeling YaBB Moderator Posts: 1127 Gender: Re: Court Balanced Round Robin Reply #5 - 01/29/07 at 03:56:52   Michael,   There's no encryption! The library sheet which you can view by clicking on Format/Sheet/Unhide is arranged both to save space and to be easily readable by the VBA macro code.  For the difficult round-robins (10, 16,22... teams), the full schedule is given in the library where each round is represented by a string contained in a woksheet cell.  The team numbers in a round can be read by subtracting 47 from the ASCII character code of each character in the string.  If you have the randomization feature turned off, this is all the macro does, writing the resulting rounds to the main worksheet.   If you don't want one of the difficult schedules, the balanced round robin is relatively easy to construct mathematically.  Details of an algorithm are given here.  At the bottom of that posting is a reference to a text book which presents some general mathematical constructions that cover all the balanced round robins.   The extra variables that you introduce on your website, the variable number of locations, days per week and time slots all add considerable complexity to the problem, and  it's unlikely that combinatorial mathematics is going to be of any help.  For this you will need an algorithm that searches for reasonable solutions to the problem.  The algorithm would need to be "intelligent" in some way since the total number of schedules that are possible rapidly becomes astronomical, so searching them all is not an option.   Hope that helps,   Ian. Back to top IP Logged