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 Master Data 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. Chartroom provides an easy way to do this, and also to perform the sort on demand.
You would typically enter all results for the round and then sort the pool, either from the Chartroom menu, or the Dashboard button, or by entering the shortcode
Players require 3 wins from 4 to qualify. Chartroom counts 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".
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.
As an example of customisation in bowls see this common scenario in chart 6-16 WES in Mastersheets.
If you copy and paste pool charts in Chartroom you must manually attend to the Rank formulas in the right hand side hidden columns to ensure they reference the correct range.
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 Sub groups of 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.