Tools Menu


Set score column widths

Set the width of all score columns on the sheet.

If you leave the prompt blank Chartroom will toggle the sheet between For and For-Ag.


Set score formats to plain text

If not set to Plain Text a scores like 9-11 can be interpreted as a date, leading to an obtuse error.


Get card data

Creates a Cards data sheet with 1 row per game suitable for downloading as input to a scorecard print job.

Optional cards policy e.g. "cardsPolicy":{"groupTextSplit":2,"initialOnly":false}


Get field as entries

Writes the current state of competitors from a Pool play or Lives play sheet back to its associated Entries sheet, creating it if necessary.

This could be used for example if a day's qualifying was rained off and you intend to initialise the entire field as a knockout event.


Get eliminated as entries

Creates an Entries sheet populated by teams that have been eliminated from the main event suitable for initialising as a Plate event.

  • For Lives play prompts for a round range e.g. 1-4, and only selects teams eliminated in those rounds.
  • For Pool play selects all non-qualifiers (nothing in the Q column).

Move sheet max left

When copying sheets between spreadsheets they appear at the maximum right position in the destination spreadsheet. This job will move the active sheet to the leftmost position, and remove the "Copy of" if it exists.


Edit Policy

This provides a quick method to edit policy directly.

Use with caution as invalid policy json will break Chartroom.


Run overall trophies

See Overall trophies


Tools sidebar

Opens a sidebar with buttons to run useful utilities.