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.
You must set up the url of the public spreadsheet in the staging spreadsheet.
var publish_url = "";paste the url between the double quotes.
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, i.e. fixes, the pool rank formula for all pools on the sheet. This is useful if pools are manually copied and pasted.
Optionally will set column A to the pool rank, useful for sorting.