As I mentioned towards the start of the BCS season, I have a spreadsheet collecting data from the event reports; with the season being over at this point (except for Worlds, which has a different banlist), this spreadsheet is mostly complete.
So first off, here’s the link to the spreadsheet.
While most of the data is from Bushiroad’s event reports, there’s quite a bit more to it than that. There’s a small amount of improvement to the raw data, like corrected decklogs for a couple players that entered the wrong one (and failed deck check as a result); and of course, gathering all this data into a spreadsheet makes it easier to search and filter. But also, I went through and recorded the climax lineups of each deck, as well as stuff like which banlist choices they made, and tried to categorize common decks within a title that might not have the exact same climax lineup. So in the Deck Breakdown tab, you can see what sorts of decks within the individual titles were most popular (or alternatively, what spicy builds people cooked up).
There are also a variety of charts. Perhaps the biggest one is conversion from a title’s overall representation to its number of tops; wanting to know this was one of the things that originally made me interested in this sort of data.
It’s important to keep in mind that this mostly gives us an idea of how good a deck is compared to how popular it is, and of course there are other variables as well; but it’s still, I think, significantly better than just counting up the raw number of tops (and that information is here as well, at least once you add the ones from Rosemont).
One thing that stands out to me is that Gun Gale Online has quite good conversion; that might just be a fluke (its overall representation is quite low, so variance has a greater impact), but it may well be that this deck is better than people think.
Overall representation is a fairly basic chart, but it’s an easy way to see what most people were playing in this season (and can help you know what to expect to see in a regional, though that was more true during the BCS season than looking forward to BSF).
Individual regionals can have their own quirks, and so there’s also a graph showing representation separately. Rather than making a graph for each regional like I’ve done in the past, this time I limited it to the 10 most common titles overall and put them all in one graph. (I was initially thinking it might be a good way to see changes over time, but I don’t think there were any clear patterns there.)
One chart that I’m rather proud of (though I’m not sure how useful it ultimately is) is what I call “Placement Proportions”:
It’s basically a bar graph of the representation of each title, with each bar split up into sections for different results (1st place, 2nd/3rd, other tops, other X-2s, and the rest). It gets quite a lot of data onto one graph while still being fairly readable (though the top slices tend to be pretty thin). It’s not too easy to compare titles with significantly different overall representation (except to see that one was in fact played much more than the other), but for titles with similar representation, you can visually compare their results to some extent.
There are some caveats to all this data; the biggest one, of course, is that it doesn’t include Rosemont, the first regional, which didn’t have the full event report that the others had. (You can see most of the top 16 decks on Weiss Tea Time, but putting those in the spreadsheet without the full representation data would have skewed the conversion statistics.) There are also a few decks that weren’t registered, and one case where the event report duplicated the same player on two different rows (I was able to find out which one was the correct row, but not what the other row should have been). And in general, there’s a decent chance that there are more errors that I’m not aware of, whether from Bushiroad making the event reports, players entering their deck logs, or of course me entering data in this spreadsheet. If you notice any, don’t hesitate to let me know; you can reach me on Discord as alexander9104, or just make a comment here.
Leave a comment