Settings Sheet
Sheet used as reference for some scripts, you must fill the required inputs for the spreadsheet to work properly.
General Settings
| Setting | Valid Inputs | Description |
|---|---|---|
| Max. Player Count | A number between 1 and 8 (inclusive). | Maximum amount of players that are able to be in a team in the tournament. Or it can be the player count of your team in case it's lower than the maximum allowed by the tournament. |
| Format | "1v1", "2v2", "3v3" and "4v4" (Without quotation marks). | Team format of the tournament. |
| Mappool Count | A number between 1 and 9 (inclusive). | Amount of mappools that will be played during the tournament. |
| Tourney Spreadsheet URL / ID | A spreadsheet URL or a spreadsheet ID of the Main Sheet of the tournament. | Self-explanatory. (Example: https://docs.google.com/spreadsheets/d/.../edit#gid=...) |
Roster Setup
You need to input the usernames of the players in your team, the first player being the captain and the order of the rest doesn't matter.
Mappools Settings
If the script is completely unable to get the mappools from the tournament's Main Sheet then check the Manual Input? checkbox and ignore the first table, after running the Update Settings script, the Mappools Ctrl sheet will be visible, in this sheet you'll provide the inputs needed to display the data of each map in each mappool.
If you have no issues in loading mappools then ignore this checkbox and fill the inputs needed in the first table (listed below).
| Setting | Valid Inputs | Description |
|---|---|---|
| Map ID Column | The index letter of the column where all beatmap IDs can be found. | Find the column in the mappool sheet where you're able to find all beatmap IDs and that'll be your input. Letter must be capitalized. |
| Mod # Column | The index letter of the column where all mods can be found. | Find the column in the mappool sheet where you're able to find all mods (to be more specific, you're looking for the column containing: NM1, HR3, FM2, etc.) and that'll be your input. Letter must be captilized.
In the case the mod and number are in separate cells ("NM", "1"), then you'll input the columns containing both of these, separated by a comma and a space (still captilized). (Example: "A, B" (without quotation marks)). |
| First Map Of Every Mappool | The first mod # of each mappool. | In most cases the first map will be NM1, I made it an input in case it's a gimmick tournament with special mappools, otherwise your input will almost always be "NM1" (without quotation marks). |
| Mappool Sheet Name | Name of the sheet within the Main Sheet that contains all the mapools. | Usually, mappools are displayed in a single sheet, the name of that sheet will be your input (cap sensitive).
But in the case the mappool for each round is in it's own separate sheet, you're gonna input the list of all of those sheets, each sheet name (still cap sensitive) must be separated by a comma and a space. (Example: "Round of 32, Round of 16" (without quotation marks)). |
| Mappool Order | "Ascending Order" and "Descending Order". | Choose Ascending Order if the first mappool is found at the top of the mappool sheet in the Main Sheet. Choose Descending Order if the first mappool is found at the bottom of it. |
For the second table you need to input the mappool names in order (Example: 1st Mappool = Qualifiers, 2nd Mappool = Round of 32, etc.)
Score Inputs
Toggle inputs that you may or may not want from players when inputting their scores in the Scores Sheet by checking or unchecking the checkbox of each input.
FM Mods
If the tournament doesn't have FM modpools, you can leave this untouched.
The checkbox next to each mod indicates wether that mod or mod combination is allowed or banned for FM maps within the tournament. The multiplier column enables the use of calculating scores taking into account the multipliers for that tournament. If there's no multiplier for certain mods, leave it as it is. In the case it does have a multiplier, input the respective number that applies to that mod.
This can be very useful in case there's mods with large nerfs or buffs. For example: In some cases EZ is multiplied by 2. You'll be able to take that multiplier into account during a match for more accurate rosters and team score averages and sums for FM maps.
Apply Changes
To apply all these changes go to Spreadsheet Scripts > Update > Update Settings. The script will do the rest.
Mappools Sheet
This is where you'll be able to display all the tournaments mappools in this spreadsheet. It searches the Main Sheet for all the sheets (or the sheet in case it's only one) where mappools can be found, it finds it via input provided in Mappools Settings in the Settings Sheet, so make sure you have the necessary inputs before continuing.
Getting Mappools
As long as you have everything set up correctly, to display a mappool it should be as simple as going to Spreadsheet Scripts > Update > Update Mappools, a script will start running and should finish within a few seconds. Once ended, the mappools should have loaded into this sheet. You'll have to run this script each time a new mappool is added or a mappool is changed.
Availability Sheet
In this sheet, you'll be able to keep track of your team's availability for the tournament or for each stage in case you want to use one per each round. There's a comment section at the bottom so each player can clarify / justify any circumstance relating to scheduling.
To use it, simply copy the colors corresponding to each status at the top of sheet and paste it in the respective time.
Making A Copy
To make a copy from the Availability Sheet Template, go to Spreadsheet Scripts > Create > Create New Availability Sheet, you'll be prompted a name for the new sheet and with that done your new availability sheet is ready for use.
Scores Sheet
This is the sheet where you'll be able to keep track of your team's scores for each stage of the tournament.
Making A Copy
To make a copy from the Scores Sheet Template, go to Spreadsheet Scripts > Create > Create New Scores Sheet, you'll be prompted a name for the new sheet and the mappool you wish to submit scores for, the script will do the rest.
Score Submission
To submit scores, you don't need to input the last 3 digits of a score, as they aren't relevant, the sheet will then calculate the average of your score multiplied by 1000, so if you got a score of 241,903, you can input it as 241, and the sheet will then make it 241,000.
For FM maps, I mentioned that you can apply multipliers on score submission, to apply these, follow this syntax: =multiplier(modAcronym, score). Example: =multiplier(EZ, 132), if the EZ multiplier is 2, then the output will be 264 (which then gets multiplied by 1000).
Scouting Sheet
In this sheet you are able to compare your team's scores and your next opponent's scores from 2 multiplayer lobbies that share the same mappool to see which picks might favour you or your opponent.
Making A Copy
To make a copy from the Scores Sheet Template, go to Spreadsheet Scripts > Create > Create New Scouting Sheet, you'll be prompted a name for the new sheet and the mappool you wish to scout scores from, the script will do the rest.
Scouting
To compare scores, you need 2 MP lobby links, both have to be played using the same mappool, one link for your team and another one for your opponent to scout. You'll also need to provide the roster of the team to scout, your team's roster is automatically filled using the Settings Sheet as reference. I suggest inputting the roster before the MP links so the script doesn't run each time you update the opponent's roster.