Click a single cell in the body of the pool before running.
Column A would be set to the pool rank either:
"sortable":truebefore initialising pool play, or
Sort pool by column A also works for sides events where the side spans several rows.
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 chick on the leftmost cell in any round header, i.e. column A, and run again.
Toggles the Qs in the Q column on or off for a single pool.
Toggles all Qs in the Q column on or off.
Toggles between displaying qualifiers and non-qualifiers i.e. will show Ps in the Q column.
Note: Ensure that the Qs are toggled on first.
Toggles the visibility of the 'ends' columns.
In home and away pool play toggles the shade of grey to indicate an 'away' game or match. Select 1 or more discrete 'rink' cells (the grey ones).
You can select multiple discrete cells with Ctrl+click.
There are 3 steps:
Set qualifier count will insert the formula to count qualifiers below.
Click in the body of a pool before running. Will reset the rinks for the pool size and number of rounds.
Sets formulas in column A (for all pools on the sheet) to the pool rank, useful for sorting.
Click in the body of a pool before running. Will clear all scores for the pool.
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.