ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Note: This is a Shared Google Doc. Everyone has edit power. Feel free to change filters or use the drill downs in the data, but please do not mess with the columns unless you are confident that you are not going to break the pivot table. If you want to do any recreational research, I highly recommend that you create a copy of the googlesheet and play around with it. If you do mess anything up, please message me (Kaile) on discord and I can fix the pivot
2
3
4
5
Filters:There are pre-built slicers that can help you filter the data down to particular tournaments. Feel free to use
6
SeasonThis essentially refers to the calendar year that the tournament was played in. There are exceptions (the first Shuffle Bus Invitational was played in 2022, but I view it as the culmination of the 2021 season. AIL Season 6 started in 2021, but was a qualifier for the invitational in 2022, so it is counted as a 2022 season
7
Tour_SeriesThis is a bit arbitrary, but I have categorized series mostly by their format and organizer. For right now (3/23/22), the series are SB qualifier, SB inivtational, SB single day, AIL
8
Tour_NameName of the tournament
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Drilldown:The Plus and Minus signs let you drill into the line level data. They use the exact same fields as the filters, but it allows you to get the line by line data for an individual Card or Player or PB
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
Sorting Data:Sorting in Sheets is really annoying. You can't actually sort by clicking on the columns and doing A -> Z or vice versa. Instead, you have to edit the row of the pivot table to the column you are interested in sorting by
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
Column Definitions
64
65
Num_DecksNumber of Decks the PB or Card has been in
66
Num_CopiesSum of the number of copies of a card played across all decks
67
Avg_CopiesNum_Copies/Num_Decks
68
Deck_PctNum_Decks/Tot_Decks. Note: This metrics does EXCLUDE seasons for which a card or PB was unreleased
69
W, L, Win_PctRefers to Swiss wins and losses specifically. For Players wins include victories via bye or concession. For PB this only includes games that are reported
70
DDrops
71
Top_Cut_W, _L, _PctRefers to top cut (doesn't matter how many) wins, losses
72
Top_12/8/4/2/Tour WinnerCount of finishes in the top X. Note that because some tournaments have different size top cuts, you could make it to a "top 8" without ever being in a "top 12"
73
Adj_Win_PctWin_Pct after removing mirror matches (which always result in 1 win and 1 loss) from the equation
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100