Club Ranking Assistant

The Club Ranking Assistant add-in for Microsoft Excel creates club rankings based on wins and losses in club matches. It is menu-driven and easy to use. It works only on PCs, and it is free forever.

If you are a chess club, use the Chess Ranking Assistant instead. The Club Ranking Assistant is a spin-off designed for any type of club where players or teams play each other: pool clubs, billiard clubs, ping pong clubs, pickleball clubs, tennis clubs, checkers clubs, bridge clubs, or any player-vs.-player or team-vs.-team club.

The Club Ranking Assistant uses the Glicko rating system developed by Mark Glickman for chess, described best by this paper.

With the Glicko rating system, if a player plays a stronger player and wins, their ranking goes up significantly. If they play a weak player and win, the ranking goes up only a little.

To use the Club Ranking Assistant, you will need Excel for Windows. After running the installation file, a new ribbon tab appears:

The Club Ranking Assistant is fully menu-driven. First, use the option “Create a Club Ranking Workbook”. This creates a new workbook with three sheets: a player list sheet, a match sheet, and a form to record matches played at your club. Use Add/Edit Players to add players, then Add Matches to add matches. Once that is done, run Update All. A number of sheets are created: a wins & losses sheet, a ranking by rank sheet, a ranking by player sheet, matches played, and individual player sheets showing who they have played.

You can display results sheets either for all players or for those who have played in the past X days — you control the X. Any or all of the sheets can be exported as a PDF file and e-mailed to players. Printing the wins and losses matrix on a color printer and taping the pages together is a great way to display standings at your club; for even more impressive output, print at 125% of regular size.

The Club Ranking Assistant works in Microsoft Excel and Office 365 for windows. It does not work on the Mac. If someone wants to convert it to the Mac, we will provide the source code, as long as the converted product is free.

Suggestions on improving the Club Ranking Assistant should be sent to us via our contact form.