"I wrecked your metal guy, boss. But look! I made you an ashtray!"
k0dy on MODO; k0dydraven on the twitch chat.
- Original Sheet: https://docs.google.com/spreadsheets/d/1bywx8Uu5zuPx5jQx7hArmD6bummMOv1tlYSpIt4YGnk
- Top 8 / 16 / 32 analysis per player: (Thanks @IamActuallyLvL1 for the idea!)
- Source data folder: (Vintage Challenge Results only)
Note: I am actively working on a clean solution to the data filtering problem. (If you try to filter the data everything turns to mush because of formula's) The best solution might just be to download the raw data and work from there. To do this:
Click 'File' -> 'Download As' -> 'Tab separated values (.txv)' and then you can either open it in your favorite viewer/editor, or upload/paste into your own Google Sheet.
@smmenen The 'Overall Match Win %' is the total win% for that archetype over all matches (including those where the opponents deck is not known). The 'Known Match win %' is the win % against top 32 decks, which are the only ones we know.
To be very specific on the data included:
- For Archetypes/Decks: We only have the top 32 decks from each challenge, and while we have records of every match for those archetypes ('Overall Match' numbers), we only know the opponent archetype if the match was against another top 32 deck ('Known Match' numbers).
- For Players: Because we don't include archetype in these numbers, all matches played by that player that we have record of are included, even if it is using or against an unrecorded deck (non top 32 decks).
- Byproducts: I chose to include the overall win% and known match win % in all archetype numbers, as they are both technically skewed in opposite directions.
- Overall win % (against all decks) is skewed upward because it only contains results for when the archetype top 32'd a tournament.
- Known match win % (against top 32 opponents) is skewed downward because it is against only the stronger performing opponents.
- The 'Unknown' archetype represents all of the results for what ends up being 33rd place and below, showing the overall win% for those decks, and the win% against known decks.
- Exact data collected:
- Full match lists with player, opponent, and overall game results from every vintage challenge I was able to pull (I did miss 8 weeks or so over the last 11 months)
- Full deck lists from every Top 32 Vintage Challenge since 1/1/2018.
While I recognize this does taint the results to some extent, the relative numbers over enough time I think still give a good picture of each archetype's strengths and weaknesses.
A final note: If people think it would catch on, the solution to the missing data problem would likely be the creation of a form allowing players to submit their deck lists (or even just the general archetype) and pushing it to the spreadsheet. I'm hesitant to put the time into it if it's not going to be used, but would still very much like an avenue to complete the missing data.
Howdy again, thanks for the kind words @Smmenen and everyone who has taken the time to take a peak. I wanted to make a few notes here about changes / updates to the sheets.
- While the sheets are locked, it is not fully read only. Any sheet containing date ranges at the top has those cells unlocked so you can update the views accordingly.
- Almost all of the formulas are dynamic enough to update whenever I push new data to the spreadsheet, which should now be occurring weekly. (Saturday night for Vintage Challenge data, Sunday /Monday night for published deck lists).
- Feel free to make suggestions / ask questions either in this thread or directly in the comments area of the spreadsheet, I am always open to adding features or views that others feel are useful, and willing to help out with any questions anyone has.
@diophan Thanks again for the scripts! I used the classifications and built the archetype and tagging into the spreadsheet formulas. For anyone out there up to debating classifications of different archetypes I am open to suggestions for improving the current setup.
The current systems uses the presence of certain cards to generate a score for each deck, and the highest scoring archetype wins.
If we want to take this further a few ideas I have are:
- Adding a weighting factor to each card in a given deck archetype. This would allow certain cards to weight towards the score higher than others (things like Oath of Druids and Survival would be prime candidates for this)
- Either adding a sub-archetype that is more specific than the current overall archetypes, or expanding the current archetypes.
The tagging system works at the moment, but doesn't have an associated win % breakdown, but that will be coming in the near future.
That would be excellent, I'd appreciate it greatly! That's exactly what I'm looking to build as my previous method of classification was based on spreadsheet formulas and very painstaking to update. I'll be able to build it into the Google Scripts backing the spreadsheet so it can update whenever new results are imported.
Howdy Vintage Community!
A while back I took over gathering results from the weekly MTGO Vintage Challenge and compiling the data from the fantastic Matt Murray. It's been a long time coming but I have a rough draft of the data compilation. It includes:
- Tab 'MTGO Results': All MTGO Vintage Challenge Results starting in March 2018 (I did miss a handful of weeks over the last year)
- Tab 'Decklists': Decklists from all top 32 competitors
- Tab 'Deck Breakdown': Top 32 players and deck archetypes as classified by MTGGoldfish
- Tab 'MTGGoldfish Archetype Breakdown': An archetype vs. archetype breakdown that can be filtered over a data range
- Tab 'MTGGoldfish Archetype Analysis': A specific archetype breakdown that gives it's win % over other archetypes per week
- Tab 'MTGGoldfish Metagame Breakdown': A breakdown of archetype % per week.
- Tab 'Card Usage': Full list of cards and occurrence over the full history in the sheet
My intention is to keep this updated with no more than a 1-2 week lag time to keep this as real time as I can.
Feel free to consume as you see fit:
Some things I'm hoping to add in the future, but feel free to make suggestions and I'll try to keep up!
- Data filters for the card breakdowns
- Better deck classification algorithm to get archetype and sub archetype granularity in the comparisons - Completed
- Some variety of tagging system seen in previous spreadsheets used to compare deck performance with certain characteristics. (taxing effects, null rod, FOW, etc.) - Completed (Thanks @diophan!)
UPDATE: The updated archetype classifications and tagging system is now active. Tabs have been added for the following:
- Archetype Breakdown: Breakdown of win% vs other archetypes
- Archetype Breakdown - Delta: Same as above but with two data ranges to run the delta for two time periods.
- Archetype Breakdown Detail: Details per archetype of match win %; mirror match wins; field win %; sweep %; swept %; game 3 win %.
- Archetype Breakdown Detail - Delta: Same as above but with two data ranges to run the delta for two time periods.
- Tag Breakdown: Same as Archetype breakdown except for tags: win% vs other tags
- Pilot Breakdown Detail: For those of you interested in your historical data.
In the effort of recording online challenge events I stumbled upon some differences in the MTGO tiebreak system and the current MTR recommendations that I felt would be better off living in the public realm. Not looking to start a debate over whether or not this is correct for WotC to implement this way or anything of the sort, merely looking to add to the list of differences between IRL and MTGO tournaments (Top 8 Play / Draw I'm looking at you). As far as I can tell this is accurate, but does not reflect any discrepancies that are caused by results outside of the norm (draws are a particular area that I cannot confirm or deny any difference as I don't know if this is even possible in the MTGO tournament structure.)
The differences form the MTR Tie Breaker Explanation appendix are as follows:
- The minimum match win percentage for a player is 0.3333 (As opposed to 0.33 in the MTR)
- The rounding precision is 4 decimal places
- Bye's count as 1 game won in the Game Win Percentage calculation (As opposed to 2 game wins in the MTR), and are still ignored in the 'Opponents GWP' calculations.
I know these aren't huge differences, but due to the small size of the Vintage Challenge events I have seen all of these differences have an impact on the order of the top 32. Although I haven't seen a top 8, 16, or 32 group affected by this, it's likely to happen at some point.
Anyway.. that's all, thanks for letting me nerd out a little bit!