In team racing events with a large number of teams ‘swiss league’ provides for better competition by scheduling teams with similar win loss records to race each other. The format does not require every team to sail every other team to determine a winner. However, a specialize computer program or spreadsheet is required to record the previous rounds results and generate the next rounds schedule.
- Has anyone run a team racing event using a ‘swiss league’ format?
- What software or spreadsheet did you use to manage the results and the schedule?
As I said it originated in the UK but we have used it in AUS for maybe 20 years and it is a great program. Some other contributors to this forum may have a copy to share. Bob always provided it free of charge so sharing should be ok.
In Australian schools' events they use the Sail100 Excel spreadsheet mentioned by Nick.
I think it was downloaded from here https://sites.google.com/site/uktra1/Running-Events but i cant see it, although its name may have changed.
Have a look on the site and perhaps contact them and see.
Failing that contact me and i can arrange for a copy to be sent to you.
As it happens i started writing a system 2 years ago that i didnt finished but during my recent isolation have dusted it off again and i hope to finish it soon.
.... just found Bob's email (it may also me 20 yrs old), i will email him a link to this blog and see if he can help.
Ross.
The purple button "Results Program" will download the file.
It's not obvious how to use it.
I agree with Craig that it is not obvious how to use it but to be fair to Bob it was written a long time ago and no doubt was best of breed in its day. And as i said it is still used in Australia.
Whoops, i dont think that has worked... can i link a PDF that others can download?
https://sailcup.com/result/help/index.html
They have also recently customised their system to run a national schools on-line virtual team racing event for me.
Have a chat to John Pratt he uses Sail100 for teams racing events in the east. He was looking to get someone to update it to newer version of excel.
There are ways and means of running Sail100 even though Bob is no longer actively supporting it. It was built on an Excel VBA system. I do have a copy of it which I'm more than happy to share should it be needed. I built an additional add-on for the British Universities Sailing Association event to more easily present the output online. Please see http://events.ksail.co.uk/2019/BUSAFinals/ for the 2019 event. In the UK, there are only a few events that use the Swiss League; the Wilson Trophy, BUSA Finals and the NSSA Single Handed Team Racing.
Running a Swiss League has advantages and disadvantages. It does well to promote quick peer-to-peer racing and creates an exciting event. The legendary "bounce" effect does mean that for fairness Quarter Finals should be run before going to Semi Finals. Event level success depends on many factors, some venues are more appropriate than others, there are venues where a Swiss League simply can't work. There are a range of technology and communication requirements both afloat and ashore.
I'm more than happy to discuss Team Racing Scheduling options and ideas; do drop me an email on keith@ksail.co.uk.
Additional resources for team racing are available via https://www.ksail.co.uk/ or through the kSail Events Portal at http://events.ksail.co.uk/.