Smogon Tour 28 Sheet Instructions

Tools:

The Sheet.
Notepad++ or any other program that allows regular expressions.
https://www.dcode.fr/duplicates-detector.

How the sheet works:

1. In the Points Pyramids fill in the size of the tour (96, 128, 196 or 256).
2. Fill in the players in the rows with the amount of points they got in the tour separated by a comma e.g. tjdaas, Djokra, Havens, Ampha
3. Add all the players that participated in the tour in the standings page.
4. Remove all duplicates (highlighted in purple), so if you see tjdaas twice, remove one of them.
5. Sort the column in the standing page of the tour you just added and check if all the players that joined the tour got their points. If not, then you need to check in which cell something went wrong/ask me. If everyone got their points correctly, you are done.

Step 2 substeps:

2.1 Use notepad++ to go from a list to the correct format. You can obtain a list by copying a rounds its pairings into notepad++ and  replace " vs " by "\r\n" (dont copy the "), when you allow regular expressions.

2.2 To obtain the round 1 losers, use a program that excludes duplicates and let it remove all the duplicates (use the EXCLUDE DUPLICATES function) of the two lists containing the round 1 and round 2 players (see step 2.1). The players that have just 1 instances are the players that lost in round 1.

2.3 To get the list in to the correct format replace "\r\n" by ", ".

2.4 repeat for the next round until you reach the winner.

Step 3 substeps:

3.1 Just copy the round 1 pairings and replace " vs " by "\r\n" and paste the list in the standings tab.

Step 4 substeps:

4.1 The easiest way to do it is to copy all the players that are already in the standing page and the player of the tour you just added into one list and use a duplicate checker (use the REMOVE DUPLICATES function) to remove the duplicates.