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's script properties (PUBLISH_URL).
This will copy the selected rows to a published sheet of the same name. See Publish sheet above.
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.
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 r
.
For rotational triples and fours (skip moving to lead) enter 3,1,2
and 4,1,2,3
respectively.
Get an entries sheet that supports selecting teams from a list of players.
First select the pool you want to copy by clicking anywhere in the body of the pool.
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
.
Inserts a formula to calculate the average win for pool play. Click a cell in the row immediately above Pool 1 and in a score column. Enter the rounds in the cell first if desired. Example formula for 4 rounds:
=arrayformula(let(array,H5:AY118,for,choosecols(array,1,13,25,37),ag,choosecols(array,2,14,26,38),ends,choosecols(array,3,15,27,39),sumfor,sum(if(for>ag,for,0)),sumag,sum(if(for>ag,ag,0)),sumends,sum(if(for>ag,ends,0)),dash,if(sumends,"-","–"),count,sum(if(for>ag,1,0)),avgends,if(count,round(sumends/count,0),""),avgwin,if(count,round(sumfor/count,0)&dash&round(sumag/count,0),""),result,if(sumends,avgwin&","&avgends,avgwin),result))
If not set to Plain Text a scores like 9-11
can be interpreted as a date, leading to an obtuse error.
Sets 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.