Chess ladder spreadsheet or software

Updated

Many clubs run a ladder from a spreadsheet, and some always will. It works until the club grows and the organizer goes on holiday.

What a spreadsheet does well

  • It costs nothing and every organizer already knows how to use it.
  • It handles a challenge ladder: one column of names, one of ranks, and a swap when someone wins.
  • You can print it for the club wall.

Where it breaks

ProblemWhat happens
Ratings changeSomeone must look up each member's rating by hand and retype it. Most clubs stop after a month.
More than 20 playersSwaps and inactivity drops become daily work for one person.
Players on two sitesMembers with Lichess and chess.com accounts have two different ratings and the sheet shows one.
Members want to lookSharing the sheet shows every cell. Sharing a copy gives them a stale one.
The organizer leavesThe rules live in one person's head and the sheet has formulas nobody understands.

What to ask of any ladder software

  1. Does it work on every computer the organizer uses? Several older free ladder programs run only on Windows.
  2. Can members see the ladder without an account?
  3. Does it keep history, so you can see who improved and not only who is on top?
  4. Can you export the data? You own your club's records.
  5. What happens at 16 players, or 60? Check the price at the size you want to be.

The cost at club size

Free tools exist, and some are good. Rated Ladder is a free Windows program that lets players pair themselves and enter results. The Chess Ranking Assistant runs ladders with Glicko ratings. Both fit a club with Windows computers.

Club Ladder is a web page, so it runs on any device. It reads players' Lichess and chess.com ratings, so you don't type them. It is free for small clubs, and $22 a year for large ones. See the plans.

When to switch

Start with a spreadsheet for a new, small club. Move to software the first time you copy ratings by hand for the third week in a row. Export the sheet first and keep it.

Club Ladder vs a spreadsheet lists, row by row, what changes when the ratings come from both sites by themselves.

See your club's ratings on both sites.

Free for small clubs.