Search the Community
Showing results for tags 'sports'.
Found 2 results
I'm trying to develop a Sports Competition Management System, which ties in with a few other features for my sports association. We have a number of leagues, based on Gender, Age, etc. which vary in team numbers, for example some leagues may have 12 teams, other only 7. Some teams play each other only once per season, other two + times, it depends on the size of the league. I have a few scripts which combined build the schedule of games (Time, Date, Round of Play) and my next step is how to create a Balanced Schedule for an Even Number of Teams, or a Cyclic Schedule for Odd Number of Teams. Obviously, an IF function determines which Scheduling Algorithm to use, based on the number of teams in that particular league. My problem now is to automatically assign the teams participating in the matches, in a way described at the following links I assume it involves a rather complex calculation at some point in the script, but after searching high and low for some inspiration, and a few trial and error attempts... Nothing tangible to show for it. Even # of Teams (Balanced) Odd # of Teams (Cyclic) My file can be downloaded from this link https://www.dropbox.com/s/3onnzm4w75s08r2/Association%20Admin.fmp12 Thanks in Advance
Let me first preface this by saying I am by no means an expert on Filemaker, more an enthusiast looking to save my small regional field hockey facility from purchasing an expensive shrink wrapped package. So... After searching high and low for a way in which to generate a sports leagues fixture, by using a combination of Custom Functions, Calculations and Scripting. I've also been working on my own to generate something that will get me closer to my goal. This forum post is VERY close, but I've come up with a few things that make for a little more flexibility. Also, the solution posted by Eos has an issue with calculating the fixtures for a league that has an odd number of teams. That being said some points within this solution have been invaluable in getting my solution to where it currently is, so a very big thanks to Eos for his assistance previously. Onto my solution... Posted Here There are two issues at this stage, no doubt more will pop up... 1) The Match List, which utilises a CF called UnorderedPairs found on Brian Dunning's site, is sequential meaning all the 1 | x values are generated first, and then the 2 | x values and so on... Instead the combinations need to come out in a series that allows each team to play only once, and balances the distribution of the fixtures over the time slots available during the season. Home and Away designations DO NOT Matter, since all games are played at a single venue, with the time being the only designation for each round of fixtures. 2) The Loop that creates the fixtures does not carry the previous values forward with the counter, so each round ends up being the same, the script needs to 'remember' the used values and then step forward to the next available value from the match list at the completion of each round. As an alternative, I have a Python Script that will create the schedule perfectly, but I have no idea how to integrate Python into a Filemaker Solution, so I've moved away from that, but I do still have the Script available should I need it. So if anyone out there is able to help out in that respect, please let me know. Any and all help is greatly appreciated Many Thanks