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.
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.
Writes qualifiers from a Pool play sheet back to its associated Entries sheet, creating it if necessary.
Creates an Entries sheet populated by teams that have been eliminated from the main event suitable for initialising as a Plate event.
1-4, and only selects teams eliminated in those rounds.
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.
Opens a sidebar with buttons to run useful utilities.
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.
See Overall trophies
Select a team or group of teams for reordering. Prompts for the new team order.
E.g. given the fours team:
2,3,1,4, and the resulting team:
To reverse the team order enter
For rotational triples and fours (skip moving to lead) enter
This provides a quick method to edit policy directly.
Use with caution as invalid policy json will break Chartroom.
Set the width of all score columns on the sheet.
If you leave the prompt blank Chartroom will toggle the sheet between
If not set to Plain Text a scores like
9-11 can be interpreted as a date, leading to an obtuse error.
Sets formulas in column A (for all pools on the sheet) to the pool rank, useful for sorting (see Sort pool by column A).
Sets the pool ranks formulas for all pools. Useful if pools are manually copied and pasted for some reason.