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 ...
30th November 2011, 12:31 PM #1
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?
20th March 2012, 11:31 AM #2
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.
20th March 2012, 11:37 AM #3
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?
20th March 2012, 12:17 PM #4
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!
By steve in forum Educational Software
Last Post: 16th May 2006, 03:49 PM
By woody in forum Educational Software
Last Post: 14th February 2006, 02:34 PM
By pinemarten in forum How do you do....it?
Last Post: 20th January 2006, 10:22 AM
By Norphy in forum Windows
Last Post: 17th January 2006, 11:19 AM
By GrumbleDook in forum Windows
Last Post: 24th August 2005, 11:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)