Pool Play Menu

Sort pool by column A

Click a single cell in the body of the pool before running.

Shortcode: )=

Column A would be set to the pool rank either:

  1. By entering the policy option "sortable":true before initialising pool play, or
  2. By nanually entering the appropriate formula and copying down.

Sort pool by column A also works for sides events where the side spans several rows.

Sort pools for round

Click on a round header e.g. R1, R2 etc. before running.

Will sort all pools on the sheet by rink number for the selected round, preserving proper opponent order.

To return to the default sort order click on the leftmost cell in any round header, i.e. column A, and run again.

Set rinks single pool

Click in the body of a pool before running. Will set the rinks for the pool size and number of rounds.

Set rinks dependent pools

Set the rinks for multiple dependent pools if the rink data is available.

This would apply, for example, when 2 concurrent single-pool events are occupying the same green.

Toggle plate

Toggles between displaying Qs for qualifiers and Ps for non-qualifiers in the Q column.

Shortcode: )tp

Clear pool scores

Clears all scores for a single pool, useful for testing.

Remove team (creating byes)

When a team withdraws from pool play and no replacement is possible, you can permanently delete their row from the chart, thus producing a series of byes.

Initialise round 3

While not actually a menu item this is available via a shortcode.


  • 3-round pool play with
  • 2 wins required to qualify

After Round 2 enter the shortcode )ir3 (in the round 3 score column is a good place)

  • 2-winners are not required to play in round 3
  • 0-winners are eliminated and are not required to play
  • 1-winners play amongst themselves