This is also known in various parts of the world as section play, sectional play, block play, group play, league play etc. In Chartroom it's all Pool play.
Play continues for a set number of rounds and teams either win the event, or qualify for the next phase, on some pre-established criteria. Such details are specified in the sheet's Pool Policy.
Here is typical pool play from the 2016–17 New Zealand Open Nationals.
You can have as many pools as necessary on a single sheet.
These charts come fully-configured with all necessary formulas and are are ready for you to start entering scores.
The first column (A) is always a number, either the team number or the team's rank within the pool if this is relevant.
The next 2 columns are for club or organisation, and then player or team. If club is not relevant this column can be hidden.
Next come each round of play across the sheet with 12 columns per round. Looking at the column headers and you'll see that 10 of the 12 columns are hidden from view.
In bowls the 2 opponents are paired by the rink the game occupies, but in general terms this is just a generic game number. Chartroom comes with standard rink tables from bowls (known as Masterdata to determine who plays who in each round (although you can supply your own data).
Important – Don't change the formatting of these round columns, or copy them elsewhere in the sheet.
The purple columns to the right are all about team totals, rankings, and qualifying indicators.
If the pools are to be sorted by team rank the easiest way is to copy the Pos value to column A. In the above chart you would set cell A5 to
=BY5 and copy down.
You would enter all results for the round and then sort the pool, either from the Chartroom menu (Pool play > Sort pool by column A), or by entering the shortcode
Players require 3 wins from 4 to qualify. Chartroom sums wins (including draws), shot differential (±), and total shots for. Qualifiers have a Q in the Q column.
Very similar, except the "Q" indicators would be turned off by default. After all rounds have been completed you would run the job Toggle qualifiers to turn these on, and then initialise lives play.
This event has 232 entries (14 pools of 16 and 1 pool of 8). Let our policy be that the top 100 qualify for lives play. Using the magic of random scores we can quickly enter all 464 game scores.
Chartroom automatically changes the Pos column to overall rank and highlights the top 100.
Teams are ranked by:
After toggling qualifiers on we get exactly 100 qualifiers. By happy accident the 100th and 101st player were in adjacent pools.
Clearly Lance Tasker (Pos 101) has missed out by 1 shot from Conrad Jagusch (Pos 100). Had they been tied in position 100 there would have been 101 qualifiers, so "Top 100" means "Top 100 including ties".
No. Scores are always entered as "for-against", but if you change cell A1 from "ForAg" to "For" only the shots for will be displayed, as in the World Bowls 2016 charts.
Pool play is the most flexible part of Chartroom. There is infinite scope for designing your own charts within the Chartroom framework.
All the above charts are standard pool play. This is what Chartroom produces when you Initialise pool play, but go ahead and modify them if you like.
Specify Ends in the Pool Policy, initialise pool play, and the chaits will be set up accordingly.
If your pool play was to be followed by lives play you would:
This involves linking 2 or more pool play charts together and carrying forward the totals used to rank teams.
A good example is the Bowls Tawa Winter Triples Series which allows for 45 rounds played over 15 days using 5 inter-linked charts.
To make these charts sortable use the vlookup formula to carry the data forward rather than a direct cell reference.
In some events it is convenient to split pools into sub-pools for visual clarity, especially if they are playing a "mini-round-robin". Such an event couldn't use Pool rank as the qualifying criterion, but could use Overall rank.
In the Pool policy set subGroupsOf to the size of your sub-pools.
Sub-pools are common in NZ indoor bowls, where there are typically sub-pools of 5 playing a round-robin over 5 rounds, and pools of 20 or 25 playing on a block of mats.