Entries

To get a new Entries sheet in Chartroom use the menu or Dashboard > Entries > 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.

Sample entries for testing purposes

To get a sample list of singles players (men & women) select Dashboard > Entries > Get sample data. You will be prompted to enter the number required.

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 or the Dashboard.

There are separate areas for Pool policy, Lives policy, Sides policy and Random scores. 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.

Setting the display score format

The hidden cell A1 contains the score format and is initially set to For-Ag. This is fine for most charts.

If you are initialising pool play with many rounds you may want to save some chart real estate and use format For, which can have narrower columns. You can set this manually on the Entries sheet (after unhiding row 1) and it will also be carried forward.

Initialising Pool Play

If your event begins with pool play click Initialise pool play on the Dashboard. 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 Dashboard. 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.