Tools Menu


Swap 2 teams

This will swap 2 teams on any sheet, and is useful for fine-tuning draws. Best used from the Dashboard.

Click on the first team, then select the second team with Ctrl+ click, then click the Dashboard button.


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.


Shuffle values

Select a range of data values and shuffle them vertically. Useful for pre-shuffling entries for example.


Entries write-back

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


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


Edit Policy

This provides a quick method to edit policy directly.

Use with caution as invalid policy json will break Chartroom.