| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Document purpose | ||||||||||
2 | ||||||||||||
3 | This document is intended to collect and analyse the match results for tournaments run and recorded through the Sirlin Games and Morningstar Sanctuary Yomi forums. | |||||||||||
4 | ||||||||||||
5 | This is not intended to act as a match-up chart showing the theoretical/true difficulty of any specific match-ups! | |||||||||||
6 | This sheet is simply a convenient summary of historical tournament results - it makes no claims about how lopsided or even any match-up is in theoretical terms. | |||||||||||
7 | Hopefully it will provide some interesting numbers for people to dig into, such as which matchups are particularly common, and which are particularly lopsided for tournament participants. | |||||||||||
8 | As player information is collected in addition to character information, downloading a copy of this sheet can also serve as a player aid to identify difficult match-ups or opponents. | |||||||||||
9 | ||||||||||||
10 | If you have any questions, or if you find any issues with the sheet, please contact me on the forums by using @mysticjuicer, or by sending me a private message. Thank you! | |||||||||||
11 | ||||||||||||
12 | 2 | Summary tab | ||||||||||
13 | ||||||||||||
14 | This tab summarizes the match results recorded in the Detailed Results tab. | |||||||||||
15 | ||||||||||||
16 | Read the table from left to right for the character you are interested in, as shown below. | |||||||||||
17 | ||||||||||||
18 | Grave | Jaina | Midori | |||||||||
19 | % W L | % W L | % W L | |||||||||
20 | Grave | 5.0 7 7 | 5.5 16 13 | 3.3 12 24 | ||||||||
21 | Jaina | 4.5 13 16 | 5.0 4 4 | 4.4 12 15 | ||||||||
22 | ||||||||||||
23 | Read the table by row. | |||||||||||
24 | In the table above, it shows that Grave has a 50% winrate against Grave, a 55% winrate against Jaina, and a 33% winrate against Midori. | |||||||||||
25 | Each box shows you (1) the percentage winrate out of 10, (2) the total wins recorded, (3) the total losses recorded. | |||||||||||
26 | ||||||||||||
27 | In addition, you can filter the data displayed in a number of ways, using the fields at the top of the tab. | |||||||||||
28 | ||||||||||||
29 | Player | Enter a player's online name here to see only their results. | ||||||||||
30 | Opponent | Enter a player's online name here to see only their results. You only need to use this box if you are comparing two player's head-to-head results. | ||||||||||
31 | ||||||||||||
32 | Event | Enter the name of an event to see only results from that event. | ||||||||||
33 | From Date | Enter a date here to see only the results that happened on or after this date. | ||||||||||
34 | To Date | Enter a date here to see only the results that happened on or before this date. | ||||||||||
35 | ||||||||||||
36 | Char Select | Random | Select "exclude" to remove all results of events which required players to randomly select their characters. | |||||||||
37 | Char Select | Locked | Select "exclude" to remove all results of events which required players to play only a single character. | |||||||||
38 | Format | Team | Select "exclude" to remove all results of events which involved a team of players playing against another team. | |||||||||
39 | Format | Restricted | Select "exclude" to remove all results of events where only certain participants were allowed to enter. In other words, it was not open signup. | |||||||||
40 | Set Length | non-FT3/FT4 | Select "exclude" to remove all results of events that included sets shorter than 'first to 3' or longer than 'first to 4'. | |||||||||
41 | ||||||||||||
42 | Note that if no data is displayed, it's likely because the players haven't faced off, didn't participate in the event selected, or there is a "space" entered in one of the blank looking fields. | |||||||||||
43 | ||||||||||||
44 | This tab can be a starting point for improving your performance. | |||||||||||
45 | ||||||||||||
46 | In which match-ups did you perform better than the overall average? In which did you perform worse? | |||||||||||
47 | Were your bad match-ups spread across a lot of individual opponents, or against 1 or 2 specific players? | |||||||||||
48 | What was your most difficult opponent's worst match-up? | |||||||||||
49 | ||||||||||||
50 | Happy digging! | |||||||||||
51 | ||||||||||||
52 | 3 | Tournament List | ||||||||||
53 | ||||||||||||
54 | This tab lists the names of all tournaments recorded in the spreadsheet, as well as their start and end dates, the tournament winner, as well as a link to the results thread. | |||||||||||
55 | Enter the tournament name in the 'Event' field in the Summary tab to see results only for that specific event. | |||||||||||
56 | ||||||||||||
57 | ||||||||||||
58 | 4 | Detailed Results tab | ||||||||||
59 | ||||||||||||
60 | This tab collects the raw tournament match results. | |||||||||||
61 | If people don't change characters during their matches, the match can be summarized in a single line (as in the BBBstings vs MIDstory line below). | |||||||||||
62 | If one or more people change characters during the match, each unique character combination is recorded as a single line (as in the Chancey vs BBBstings lines below). | |||||||||||
63 | ||||||||||||
64 | Player names are recorded to make it easier for me to make sure I'm not recording matches more than once, as well as providing some additional data for analysis. | |||||||||||
65 | Note: double-KOs are not recorded in this spreadsheet - I believe it would be misleading to include them, as they would look the same as when taking a win and a loss in two matches. | |||||||||||
66 | ||||||||||||
67 | ex. | |||||||||||
68 | ||||||||||||
69 | Player 1 | Character 1 | Wins 1 | Wins 2 | Character 2 | Player 2 | ||||||
70 | Chancey | Lum | 1 | BBB | BBBstings | |||||||
71 | Chancey | Lum | 1 | 1 | DeGrey | BBBstings | ||||||
72 | Chancey | Lum | 1 | Argagarg | BBBstings | |||||||
73 | BBBStings | BBB | 3 | 1 | Midori | MIDstory | ||||||
74 |