+ Post New Thread
Results 1 to 4 of 4
Coding Thread, Excel Team Fixtures in Coding and Web Development; I'm playing around with an old Excel Spreadsheet to give it a little more functionality. The 5 a side league ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,218
    Thank Post
    230
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    31

    Excel Team Fixtures

    I'm playing around with an old Excel Spreadsheet to give it a little more functionality. The 5 a side league I play in has two divisions currently First Division has 10 teams and Second Division has 9. I want all the teams in either division to play at least 1 game, 1 team will of course have to play 2 games on that particular night. I've set the spreadsheet up to take upto 35 teams per division the sheet with all the team names has details of how many teams are in each division (three divisions maximum) what I would like to know is has anyone ever written an algorithm to setup fixtures until all teams have played each other at least once possibly twice (depending on what you would enter in a cell on the main sheet)? Or could anyone help me find some information on how to start this?





    Wes

  2. #2
    HMCTech's Avatar
    Join Date
    Apr 2008
    Posts
    618
    Thank Post
    37
    Thanked 48 Times in 35 Posts
    Rep Power
    23
    Did you ever get anywhere with this? I was asked to create something that a teacher would input number of teams and how many available courts there are and it would create fixtures for each round. Not given it much thought yet but if you have got anywhere and have any tips.
    Last edited by HMCTech; 20th March 2012 at 11:38 AM.

  3. #3
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,218
    Thank Post
    230
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    31
    I'll have to dig it out bump the post tomorrow if I haven't got back to you. The spreadsheet I have is for a set of 40 teams (maximum) in each division. The other one creates fixtures based on a number of teams however it works on the basis of each round being on the same day with no proviso for how many pitches or courts?

  4. #4
    HMCTech's Avatar
    Join Date
    Apr 2008
    Posts
    618
    Thank Post
    37
    Thanked 48 Times in 35 Posts
    Rep Power
    23
    An example would be at the start of games there would be 9 teams and 8 courts. So there would be 8 rounds with one team always sitting out. Fixtures would be generated for each round so that each team plays one another over the course of the 8 rounds.

    That's my requirement as far as I know so far!



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Macro - Edexcel GCE Exams
    By steve in forum Educational Software
    Replies: 0
    Last Post: 16th May 2006, 03:49 PM
  2. RANDBETWEEN in MS Excel
    By woody in forum Educational Software
    Replies: 3
    Last Post: 14th February 2006, 02:34 PM
  3. Web query in Excel
    By pinemarten in forum How do you do....it?
    Replies: 2
    Last Post: 20th January 2006, 10:22 AM
  4. Bizzare Excel Problem
    By Norphy in forum Windows
    Replies: 3
    Last Post: 17th January 2006, 11:19 AM
  5. Excel frustration
    By GrumbleDook in forum Windows
    Replies: 3
    Last Post: 24th August 2005, 11:01 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •