Pool Play Menu


Sort pool by column A

Click anywhere in the body of the pool before running. Also on the Dashboard.

Shortcode: )=

Column A must be set to the pool rank by either

  1. Manually entering the formula and copying down, or
  2. Running the job Sort all pools by rank.

Toggle qualifiers

Toggles the Qs in the Q column on and off. Also on the Dashboard.

Shortcode : )tq


Toggle plate

Toggles between displaying qualifiers and non-qualifiers i.e. will show Ps in the Q column. Also on the Dashboard.

Shortcode: )tp

Note: Ensure that the Qs are toggled on first.


Set average win

For a team receiving a win by forfeit, or a bye, click on their score cell before running. Also on the Dashboard.

Shortcode: )saw

Unlike the special score wf set average win does not require an opponent.


Set average loss

For a team losing by forfeit, click on their score cell before running. Also on the Dashboard.

Unlike the special score f set average loss does not require an opponent.


Set qualifier count

Manually insert a row above Pool 1 and clear formatting with Ctrl+\ then click in the Q column on that row.

Will insert the formula to count qualifiers below.


Set home background

Click on the leftmost of the 2 visible round columns (i.e. the 'grey' column) and run. Sets the default background colour that defines pool play.


Set away background

For sides play this is meant to indicate sides playing at their opponent's club by giving them a slightly darker grey background in that round.

Click on a grey cell in a round column and run. To continue it's quicker to use Paint format to replicate the background.


Sort all pools by rank

Sets the formula to copy the pool rank into column A for all pools and then does the sort.


Delete team

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.