Tools Menu

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).

Publish sheet

Moves a sheet e.g. from a private staging spreadsheet to a public production spreadsheet.

Firstly you must set up the url of the public spreadsheet in the staging spreadsheet.

  • Open the public spreadsheet and copy the url.
  • Open the staging spreadsheet, then open the Script Editor.
  • Run the function setPublishUrl.
  • Paste the public spreadsheet url.
  • To verify it has been set run the function showPublishSS.

Tools sidebar

Opens a sidebar with buttons to run useful utilities.

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

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.