Excel

excelSome routines that might help automate your competitions. They’ve been acquired, googled, donated, invented and we’re happy to receive more. Available in a couple of different formats. Improvements welcome.

Triangular.xlsx 3 clubs, 4 teams. Some automation. Also 3 clubs 2 teams.

Triangular.xls 3 clubs, 4 teams. Some automation. Also 3 clubs 2 teams.

Any competition scoresheet.xls Accepts scores and the rest is done for you. Needs a macro to sort at the end otherwise sort manually.

Any competition scoresheet.xlsx Accepts scores and the rest is done for you. Needs a macro to sort at the end otherwise sort manually.

Season Long Melee.xlsx Run a regular melee for club members. Keep the scores. Produces league table. 2 scoring systems.

Season Long Melee.xls Run a regular melee for club members. Keep the scores. Produces league table. 2 scoring systems.

Added 2016. My own club decided they didn’t like either of the suggested scoring systems above. They substituted best 3 scores count then later they said winner on the day will get 13 points down to 13th place receiving  1 point. Anyone 14th and below that will not record a score.

Fixture list generator.xls Uses macros to draw a league for any number of clubs. Not available in xlsx.

small KO. Use for Wimbouledon event or any other knockout.

16 player Knockout with seeding.xlsx Found on the web. Untested.

Meli Melo.xlsx Acquired from a french club with many pistes and big numbers every week. The aim is to provide melee fixtures where no-one plays with or against the same person over a 3 round melee. Not thoroughly tested. Print out and keep as reference work. On the day count the players, give everyone a number they retain for the session. Look for relevant fixtures in your printed copy. Write figures on blackboard. Keep scores. After round one rub out fixtures and write next ones.

Cup draw.xlsx For competitions where all rounds are known all the way to the final. (not like the FA Cup). Includes qualifying rounds.

 

 

 

Advertisements