Round Robin Tournament Scheduling

Balanced Tournament

Calteq · 3 · 892

Calteq

  • Newbie
  • *
    • Posts: 0
on: March 17, 2025, 03:18:34 AM
Hi

I have only just found this forum :D

Thx for this spreadsheet

I have used it (the programming) to produce fixtures for Bowls Club Fixtures
(I can post the Spreadsheet if required)
 
I noticed with interest your reply to InnesW20

>>>>> Reply #3 on: February 22, 2025, 12:13:45 AM

The more venues there are, the easier things get.  With 6 venues you can have:

(H A) (---) (F G) (B C) (---) (D E)
(---) (H B) (---) (F E) (D G) (A C)
(E G) (D F) (H C) (---) (A B) (---)
(---) (A E) (---) (H D) (F C) (B G)
(F B) (C G) (D A) (---) (H E) (---)
(D C) (---) (B E) (A G) (---) (H F)



how is this acheived with the Round Robin spreadsheet?





Ian Wakeling

  • Forum Moderator
  • God Member
  • *****
    • Posts: 1140
Reply #1 on: March 17, 2025, 04:21:11 AM
Unfortunately, the spreadsheet does not make schedules like the one above - it is called a Howell Design and is generally possible for an even number of players 2n on a square grid with s rows and s columns - where s=n is the minimum size grid (no empty cells) and s=2n-1 is the maximum size grid (this includes all possible games exactly once). I am not aware of anything that you can use to make these schedules, but you are welcome to ask me to make some for you.
 
« Last Edit: March 17, 2025, 04:32:16 AM by Ian Wakeling »


Calteq

  • Newbie
  • *
    • Posts: 0
Reply #2 on: March 18, 2025, 04:32:35 AM
Thx for the prompt response

What you are talking about is way above my pay scale but I will do a bit of research based on your recommendation

Thx again