Entries

To get a new Entries sheet in Chartroom use the Entries menu > New entries sheet. Enter the name of your event and Chartroom will create the new sheet with the name Your Event Entries. This will become the active sheet. An Entries sheet's name must always end with " Entries".

Due to a quirk in Google Sheets you may have to horizontally scroll the list of sheets at the bottom of the screen.

Entries sheet structure

As with all Chartroom sheets Row 1 is reserved for system data and is hidden from view.

Row 2 contains column headings #, Id (hidden), Club or org, and Team.

  1. # is a sequential entry number, either entered manually or a formula such as =row(A3)-2.
  2. Id is not used at present.
  3. Club or org is the club or organisation for the team (if relevant), otherwise leave blank.
  4. Team is the only required field. Enter a single player or a list of players (skip to lead for bowls) comma-separated.

If your entries are just clubs or organisations put them in the Team column. You can always shift them later.

Random entries for testing purposes

Select Chartroom > Entries > Get random entries. You will be prompted to enter a number and an optional letter, e.g. 25s for 25 singles players. Other options are p for pairs, t for triples, and f for fours.

This will overwrite any existing entries on the sheet.

Set the policy for the event

Most events have policy, like the number of rounds to be played and the number of wins required to qualify. Chartroom also has options to control the draw and how you want your groups to look if you have more than 1.

Policy can be found in the Settings sidebar, accessible from the Chartroom menu.

There are separate areas for Scoring, Pool policy, Lives policy, Sides policy. These are covered in more detail later on.

You can set all the policy pertaining to your event on the Entries sheet and it will be carried forward to Pool play and/or Lives play.

Initialising Pool Play

If your event begins with pool play click Initialise pool play on the Entries menu. Chartroom performs the draw and creates the new sheet in accordance with the Pool policy.

Your event is now ready to go and you can hide the entries sheet if you like.

Initialising Lives Play

If your event begins with lives play click Initialise lives play on the Entries menu. Chartroom performs the draw and creates the new sheet in accordance with the Lives policy.

Your event is now ready to go and you can hide the entries sheet if you like.