Swiss Tournament Management Spreadsheet – updated 8th March 2024

Tournament Management Spreadsheet *Updated March 2024*

This a macro-driven Excel spreadsheet designed to assist Tournament Managers to run both formal and flexible Swiss tournaments.

It generates automated pairings, lawn allocations and results tabulation. Formal Swiss pairings are in accordance with the CA Tournament Regulations.

There is also an auto-management mode to allow the players to manage, whilst the Tournament Manager plays!

Download the spreadsheet: Swiss Tournament Management spreadsheet version 7.1.3.2

The following documents may also be downloaded: 

Tournament Management Manual V7.1

Tournament Management Quick Start Guide V7.1

Sample Auto Manage Player Instructions

FAQs

I am having problems downloading the spreadsheet?
As the spreadsheet contains macros you may have have to amend your virus software settings to allow it to be downloaded.  For example, With Norton anti virus software, Excel can give a 'file corrupt message' if opened automatically after the download but opens it OK if you subsequently manually open the file from your download directory.

How do I contact the developer?
Send an e-mail to secretary@worldcroquet.org
Does it work with Advantage GC?

One limitation is that it does not cope with Advantage GC games as it can not currently handle the possibility of a player having a -ve hoop score at the end of a game and  the winner of a game going to time actually having a lower hoop score than the loser.

Why does the downloaded spreadsheet already has data in it?
The download is set up as a partially complete tournament so you can see how the program looks and can immediately try entering results and scheduling games before having to set up your own tournament.

 

Launching Online GC Rules Training

Our smaller Members do not have the infrastructure or geography to support on lawn courses or exams. This material has been created to provide them with an online training course (and in due course a test). It will allow these countries to improve the quality of refereeing on offer.

The material covers all the GC Rules.  It has been designed so that it can be used by players wishing to understand the GC Rules better with additional modules for those wanting to become qualified referees. Laid out as a study plan it takes students through everything they would need to pass the written elements of a typical GC Referees exam. It also covers, via video links, some of the on-lawn material, but obviously this is limited.

This material has been created for the WCF by Ian Shore of the Chiltern Academy as a global resource that will be available to all. The WCF are extremely grateful to Ian for producing this useful resource. The material sometimes links to material published on the Croquet England website and we thank them also for access to these resources.

To find out more, and to access the Study Pack, go to webpage: Online Referee Study Pack

New Handicap Calculator – now available in Global Resources

Thank you to Brian Wainman for developing this Handicap Calculation tool.

By entering the type of game, such as GC 13pt or AC Handicap, and each players handicaps, the tool will quickly work out how many bisques you should have in AC handicap, how many extra strokes in GC handicap and the winner and loser points impact when playing AC advanced games.

Click here> https://chc.eu.pythonanywhere.com or access it from the Global Resources page of the WCF Website.


The operation of handicap systems is a matter for individual national governing bodies, however this calculator is believed to work in most WCF Member countries.

Brian welcomes any feedback or ideas for further development. Please contact him directly by email:  wanderingwainmans@blueyonder.co.uk