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 … as entries > 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 … as entries > Get qualifiers as entries

Writes qualifiers from a Pool play sheet back to its associated Entries sheet, creating it if necessary.

Get … as entries > 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.

Run overall trophies

See Overall trophies

Reorder teams

Select a team or group of teams for reordering. Prompts for the new team order.

E.g. given the fours team:

  • Stoke – Shannon McIlroy, Peter Hodson, Seamus Curtin (Stokes Valley), Tony Grantham (Browns Bay)
  • with Curtin moving to skip
  • the new order would be 2,3,1,4, and the resulting team:
  • Stokes Valley – Seamus Curtin, Shannon McIlroy (Stoke), Peter Hodson (Stoke), Tony Grantham (Browns Bay)

To reverse the team order enter r.

For rotational triples and fours (skip moving to lead) enter 3,1,2 and 4,1,2,3 respectively.

Chart Setup

Edit Policy

This provides a quick method to edit policy directly.

Use with caution as invalid policy json will break Chartroom.

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.

Set pool rank in column A

Sets formulas in column A (for all pools on the sheet) to the pool rank, useful for sorting (see Sort pool by column A).

Set pool rank formulas

Sets the pool ranks formulas for all pools. Useful if pools are manually copied and pasted for some reason.