ABCD
1
Sheet Template by D I O, Script Template by LeoFLT, Modification / Styling by Nathaniel
2
Host Instructions
3
4
5
SettingsGo to the 'Settings' tab and fill in all the red cells, as well as information for each Round of the tourney.
6
MappoolGo to 'Mappool' and copy/paste map pool data.
7
ScheduleGo to 'Schedule' and add your match IDs, preferably with a format of a round name followed by a match number to make the creation of matches easier.
8
Inserting TeamsGo to 'Team Listing' and put down the teams participating in the tournament.
9
Refreshing Sheet LinksThe match links on the left do not update automatically unfortunately. To refresh the sheet links, go to the 'Admin' menu and run the 'Refresh Match Links' function.
10
TemplateGo to 'Template' and change the mappool to the current week on the right side.
11
Authorizing ScriptsClick the 'Admin' menu tab and run any function to prompt authorization for the script to access your google account. Rest assured that your google account will not be used for anything in this script.
12
Match PrefixesClick the 'Admin' menu then run 'Change Match Prefix' to add non-numerical portions to created matches. You must have a prefix (create an empty one if you don't want one). Don't forget to include a space if there is one. You can change the prefix by clicking the button again and remove it by selecting 'Remove Match Prefix'.
13
Creating MatchesAfter this, you can go to the 'Admin' menu and run 'Create Match' or 'Create Range of Matches' to make matches.
14
Hiding MatchesOnce a set of matches with the same prefix are finished, you can run 'Hide Multiple Sheets' or 'Unhide Multiple Sheets' in the 'Admin' menu to change the visibility of the sheets to remove clutter.
15