• Welcome to Smashboards, the world's largest Super Smash Brothers community! Over 250,000 Smash Bros. fans from around the world have come to discuss these great games in over 19 million posts!

    You are currently viewing our boards as a visitor. Click here to sign up right now and start on your path in the Smash community!

MLG Brawl 2010 Matchslip Statistics and Analysis

wWw Dazwa

#BADMAN
Joined
Feb 23, 2006
Messages
5,569
Location
maine
Some of you may already know this, but for MLG 2010, I was a referee for Brawl. The only event I didn't referee was Orlando because they hadn't hired anyone from Smashboards yet, and after Brawl's removal, I've continued to referee in Starcraft 2. It's a pretty sweet job. At the end of the final event of the 2010 circuit (MLG Dallas), AlphaZealot mentioned in a mini-community meeting that he still had every single matchslip from this circuit (again, barring the Orlando event), but did not have the spare time to organize it into a database. I accepted, not realizing just how many matchslips I was going to be dealing with. (A lot)

What exactly is a matchslip?

A matchslip is what MLG referees used to keep track of the specifics from each match we were officiating at the time. The characters you used, the stages you played on, the stages you banned, winners, ending stock, ending percent, even ledge grabs were occasionally kept track of (when applicable). And now that's all publicly available in an online-viewer, using Google Spreadsheets. Additionally, you can download the file, if you wish.

What secrets of our metagame did you uncover?
Well, I'll be perfectly honest, I'm not really well-versed in taking a spreadsheet and turning it into a beautiful graph for everyone to use to support their rage-fueled arguments over, but thankfully to a tip that was given to AlphaZealot by MK26, and afterward stolen by Dazwa, I'm at the very least able to provide you with a lot of the easy data. Here's what I uncovered.

CHARACTERS​



Pie graph (large image)
I'm going to be perfectly honest: nothing shown above should come as a surprise to anyone. While I was a little heartbroken that the least commonly played character was Captain Falcon, everything here seems to be reasonable, barring that unusually high Lucas. While it's possible that characters may have "earned" additional games to their tally by simply entering game 3, the effect that has isn't nearly as influential as simply advancing in the bracket. The game 3 effect might sway the lower portion of the cast, but it's not a terribly major factor.


STAGES​



The most commonly played stages were Smashville, Battlefield, and Final Destination. Not really a surprise. What may be a shocker, however..


Final Destination is also the most commonly banned stage, leading the way for Brinstar and Rainbow Cruise. While it's commonly known that Final Destination can be polarizing for a lot of matchups (fighting against Falco, Ice Climbers, Diddy Kong, or playing as Meta Knight), its high status in both categories is definitely worth note. Also, no one seems to want to touch Pokemon Stadium 2. Barely any times played, barely any bans. A bunch of stagecists if you ask me.

Alternatively, here's a side-by-side comparison of stage bans vs times played:


MISCELLANEOUS​


Number of sets played (not separating continuation sets): 1544
Number of sets that went to game 3: 420
Game 4 (via continuation set, extended championship series set, etc) : 42
Game 5: 28
Game 6: 7
Game 7: 2
Game 8 and Game 9: 1 (Rich Brown vs ADHD at MLG DC)
Total individual games played: 3589
The most commonly used character is Meta Knight at 1298 uses. The least is Captain Falcon, at a whopping 3 uses.
The most commonly played stage, Smashville (833 games), is also the 2nd least commonly banned stage (35 bans)
The most commonly banned stage, Final Destination (584 bans) is also the third most commonly played stage (373 games)
The least commonly banned stage, Pokemon Stadium 2 (14 bans) is also the least commonly played stage (22 games)
Number of JV4 stocks (winning with 3 stock, 0 percent): 1
Number of times a player was late for a match, or a "No show": 330
Number of times a game went to the time limit: 28




With all of that out of the way, I implore anyone that can find interesting data with their actual spreadsheet skills, to do so. As far as I know, aside from a few spreadsheets done by Glenn over at getyourtournament for SFIV, this is the first time a fighting game has had expansive data from a tournament or series of tournaments to work with. Don't let my lack of spreadsheet knowledge squander it. :dazwa:

Online Spreadsheet Viewer

Since the large majority of the project is over (for me), here's a bunch of shoutouts to people that helped:
- AlphaZealot for both providing me and trusting me with the opportunity to mangle my fingers for glory
- MLG_JV for hiring me in the first place, leading me to my opportunity to mangle my fingers for glory
- Solid Jake, Pierce, Brendan, and Joel, my fellow Smash refs. It was a blast working with you all.
- Cheese, Atomsk, Anti, Chibo, Vex Kasrani: these 5 had incorrect matchslip data (a character or a stage were missing or misreported by the referee), but they're all elephants and didn't forget a single detail of the matches (seriously, some of them gave detailed analysis of each individual stock in the game, I was frightened)
- Anyone that showed their support for the community by attending. While it may have proven naught in the end due to other factors, you gave us a fighting chance and that's more than enough for my respect.
- New England Brawl and Melee, BECAUSE THIS IS MY THREAD I CAN DO WHAT I WANT
 

Nidtendofreak

Smash Hero
Joined
Feb 10, 2006
Messages
7,265
Location
Belleville, Ontario
NNID
TheNiddo
3DS FC
3668-7651-8940
*looks at number of times FD was banned*

Heh, and people still think its starter material.

inb4argument

Cool info though.
 

Sinister Slush

❄ I miss my kind ❄
Moderator
BRoomer
Joined
Sep 1, 2009
Messages
14,008
Location
The land that never Snows
NNID
SinisterSlush
Norfair's amount of uses seems about right.
I'm Actually surprised that Green Greens had more uses then Pokemon Stadium 2, as for Meta Knight almost surpassing 1400... this is no surprise to me.
 

-Ran

Smash Master
Joined
Feb 16, 2008
Messages
3,198
Location
Baton Rouge
I'm going to be changing this into an Access database for more detailed datamining.
 

Luigi player

Smash Master
Joined
Jul 29, 2004
Messages
4,106
Location
Austria
I kind of think FD got banned so much, because ppl don't know how stupid some other stages can be...

But it's not really surprising since people were already saying it, the surprising thing to me is that even though it got banned most of the time it's still the 3rd most played stage...
 

John12346

Smash Master
Joined
Jan 24, 2009
Messages
3,534
Location
New York, NY
NNID
JohnNumbers
FD was banned so many times because MK was used so many times.

It's not a hard concept to grasp...
 

OverLade

Smash Hero
Joined
Jun 19, 2006
Messages
8,225
Location
Tampa, FL
Castle Siege is still hella underrated. Wow at how infrequently it was used.

And FD was def banned because of how many MKs there were.
 

Luigi player

Smash Master
Joined
Jul 29, 2004
Messages
4,106
Location
Austria
Makes sense... MK wouldn't need to ban any (other) stage. Would be interesting to see how much % of the players that banned FD were MKs..
 

wWw Dazwa

#BADMAN
Joined
Feb 23, 2006
Messages
5,569
Location
maine
I like stuff like this. Do more! =D
Never!

At the very least I'll have a template of the matchslips up in a bit, it'll be a little modified...our matchslips didn't have a box for stage ban: we had to mark it in the margins, and oftentimes, referees wouldn't signify whose ban was whose. Luckily nearly everytime that came up, it was with an easy to guess matchup.

The important thing is, we'll be able to start recording data for player-hosted tournaments as well.
 

stingers

Smash Obsessed
Joined
Oct 21, 2006
Messages
26,796
Location
Raleigh, NC
example
mk is used 1000 times.

the MK users ban FD every time (1000 times)
the people that fight the MK users ban rainbow and brin 500 times each stage

that is why fd is banned so much lol. (at least as much as rainbow and brin combined as BPC said)

this should be provable, you can just make a graph of which characters banned which stages. i have no idea how to go about doing that though
 

AlphaZealot

Former Smashboards Owner
Administrator
Premium
BRoomer
Joined
Jul 6, 2003
Messages
12,731
Location
Bellevue, Washington
Really great work Dazwa. I'm sure this took probably 50 hours, if not more, of work. Few people in this community put that much time into things so major, major props man!

Thank you for all the hard work you have done for the community!
 
Joined
Mar 15, 2008
Messages
10,050
I would like to see exact numbers next to these graphs in the future, just sayin'.
 

MK26

Smash Master
Joined
Jun 29, 2008
Messages
4,450
Location
http://www.mediafire.com/?zj2oddmz0yy for ZSS fix!
The tables only apply to people who picked their character game 1
if you have a pocket mk, your stage ban counts toward whichever main you use

Thats also why the numbers are much lower than total usage - using a character 3 times in a 3-game set counts as a 3 in total usage, but a 1 in stage bans

[collapse=Stage Bans By Character]Asterisks are beside significantly high numbers


Meta Knight|Number
Battlefield|24
Brinstar|27
Castle Siege|11
Delfino Plaza|9
Final Destination|214*
Frigate Orpheon|4
Green Greens|25
Halberd|59*
Lylat Cruise|10
Norfair|16
Pictochat|13
PokemonStadium1|15
PokemonStadium2|3
Rainbow Cruise|33
Smashville|5
Yoshi's Island|30
NOT LISTED|17


Snake|Number
Battlefield|11
Brinstar|68*
Castle Siege|4
Delfino Plaza|10
Final Destination|53*
Frigate Orpheon|1
Green Greens|8
Halberd|10
Lylat Cruise|0
Norfair|8
Pictochat|2
PokemonStadium1|1
PokemonStadium2|2
Rainbow Cruise|31*
Smashville|5
Yoshi's Island|6
NOT LISTED|2


Diddy Kong|Number
Battlefield|2
Brinstar|22*
Castle Siege|3
Delfino Plaza|1
Final Destination|7
Frigate Orpheon|11
Green Greens|11
Halberd|11
Lylat Cruise|6
Norfair|35*
Pictochat|1
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|11
Smashville|0
Yoshi's Island|5
NOT LISTED|3


Falco|Number
Battlefield|2
Brinstar|75*
Castle Siege|2
Delfino Plaza|6
Final Destination|12
Frigate Orpheon|16
Green Greens|4
Halberd|7
Lylat Cruise|11
Norfair|15
Pictochat|2
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|26*
Smashville|1
Yoshi's Island|4
NOT LISTED|3


Wario|Number
Battlefield|5
Brinstar|2
Castle Siege|1
Delfino Plaza|7
Final Destination|38*
Frigate Orpheon|3
Green Greens|3
Halberd|8
Lylat Cruise|2
Norfair|10
Pictochat|2
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|7
Smashville|1
Yoshi's Island|5
NOT LISTED|6


Marth|Number
Battlefield|1
Brinstar|12
Castle Siege|6
Delfino Plaza|1
Final Destination|14
Frigate Orpheon|9
Green Greens|10
Halberd|21*
Lylat Cruise|2
Norfair|6
Pictochat|2
PokemonStadium1|6
PokemonStadium2|0
Rainbow Cruise|23*
Smashville|1
Yoshi's Island|7
NOT LISTED|3


Ice Climbers|Number
Battlefield|2
Brinstar|28*
Castle Siege|0
Delfino Plaza|2
Final Destination|2
Frigate Orpheon|0
Green Greens|3
Halberd|10
Lylat Cruise|1
Norfair|35*
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|10
Smashville|1
Yoshi's Island|3
NOT LISTED|2


Olimar|Number
Battlefield|4
Brinstar|26*
Castle Siege|1
Delfino Plaza|2
Final Destination|16
Frigate Orpheon|3
Green Greens|0
Halberd|8
Lylat Cruise|1
Norfair|12
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|23*
Smashville|0
Yoshi's Island|8
NOT LISTED|5


Pikachu|Number
Battlefield|8
Brinstar|38*
Castle Siege|3
Delfino Plaza|0
Final Destination|9
Frigate Orpheon|0
Green Greens|3
Halberd|6
Lylat Cruise|4
Norfair|5
Pictochat|1
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|3
Smashville|3
Yoshi's Island|2
NOT LISTED|2


King Dedede|Number
Battlefield|13
Brinstar|27*
Castle Siege|0
Delfino Plaza|5
Final Destination|18*
Frigate Orpheon|1
Green Greens|4
Halberd|4
Lylat Cruise|9
Norfair|8
Pictochat|5
PokemonStadium1|2
PokemonStadium2|1
Rainbow Cruise|5
Smashville|1
Yoshi's Island|4
NOT LISTED|3


Game and Watch|Number
Battlefield|2
Brinstar|3
Castle Siege|2
Delfino Plaza|1
Final Destination|23*
Frigate Orpheon|4
Green Greens|4
Halberd|11
Lylat Cruise|5
Norfair|6
Pictochat|2
PokemonStadium1|1
PokemonStadium2|1
Rainbow Cruise|8
Smashville|4
Yoshi's Island|6
NOT LISTED|4


Lucario|Number
Battlefield|8
Brinstar|8
Castle Siege|1
Delfino Plaza|1
Final Destination|17*
Frigate Orpheon|0
Green Greens|6
Halberd|5
Lylat Cruise|2
Norfair|3
Pictochat|0
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|10
Smashville|0
Yoshi's Island|0
NOT LISTED|0


Zero Suit Samus|Number
Battlefield|8
Brinstar|9
Castle Siege|4
Delfino Plaza|1
Final Destination|14
Frigate Orpheon|12
Green Greens|4
Halberd|10
Lylat Cruise|0
Norfair|6
Pictochat|2
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|2
Smashville|0
Yoshi's Island|3
NOT LISTED|1


Toon Link|Number
Battlefield|2
Brinstar|9
Castle Siege|1
Delfino Plaza|2
Final Destination|12
Frigate Orpheon|8
Green Greens|3
Halberd|12
Lylat Cruise|1
Norfair|2
Pictochat|1
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|7
Smashville|1
Yoshi's Island|3
NOT LISTED|2


Kirby|Number
Battlefield|3
Brinstar|8
Castle Siege|4
Delfino Plaza|1
Final Destination|8
Frigate Orpheon|0
Green Greens|2
Halberd|5
Lylat Cruise|1
Norfair|0
Pictochat|1
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|0
Smashville|0
Yoshi's Island|1
NOT LISTED|2


Fox|Number
Battlefield|3
Brinstar|8
Castle Siege|3
Delfino Plaza|1
Final Destination|1
Frigate Orpheon|1
Green Greens|0
Halberd|1
Lylat Cruise|3
Norfair|0
Pictochat|1
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|4
Smashville|1
Yoshi's Island|3
NOT LISTED|3


ROB|Number
Battlefield|9
Brinstar|13
Castle Siege|4
Delfino Plaza|7
Final Destination|7
Frigate Orpheon|3
Green Greens|9
Halberd|6
Lylat Cruise|0
Norfair|10
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|5
Smashville|0
Yoshi's Island|2
NOT LISTED|3


Pit|Number
Battlefield|0
Brinstar|9
Castle Siege|3
Delfino Plaza|2
Final Destination|7
Frigate Orpheon|2
Green Greens|5
Halberd|9
Lylat Cruise|2
Norfair|1
Pictochat|1
PokemonStadium1|6
PokemonStadium2|0
Rainbow Cruise|5
Smashville|0
Yoshi's Island|10
NOT LISTED|5


Peach|Number
Battlefield|2
Brinstar|4
Castle Siege|0
Delfino Plaza|4
Final Destination|7
Frigate Orpheon|2
Green Greens|2
Halberd|7
Lylat Cruise|1
Norfair|5
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|8
Smashville|1
Yoshi's Island|2
NOT LISTED|3


Donkey Kong|Number
Battlefield|3
Brinstar|4
Castle Siege|1
Delfino Plaza|3
Final Destination|19*
Frigate Orpheon|2
Green Greens|2
Halberd|4
Lylat Cruise|2
Norfair|3
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|7
Smashville|2
Yoshi's Island|0
NOT LISTED|2


Luigi|Number
Battlefield|0
Brinstar|14*
Castle Siege|2
Delfino Plaza|1
Final Destination|21*
Frigate Orpheon|1
Green Greens|1
Halberd|1
Lylat Cruise|1
Norfair|4
Pictochat|1
PokemonStadium1|2
PokemonStadium2|1
Rainbow Cruise|2
Smashville|0
Yoshi's Island|3
NOT LISTED|5


Wolf|Number
Battlefield|2
Brinstar|8
Castle Siege|3
Delfino Plaza|4
Final Destination|10
Frigate Orpheon|3
Green Greens|0
Halberd|5
Lylat Cruise|7
Norfair|3
Pictochat|2
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|10
Smashville|1
Yoshi's Island|2
NOT LISTED|6


Sonic|Number
Battlefield|4
Brinstar|20*
Castle Siege|0
Delfino Plaza|7
Final Destination|3
Frigate Orpheon|1
Green Greens|2
Halberd|6
Lylat Cruise|1
Norfair|5
Pictochat|0
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|3
Smashville|2
Yoshi's Island|1
NOT LISTED|4


Ike|Number
Battlefield|2
Brinstar|5
Castle Siege|0
Delfino Plaza|1
Final Destination|8
Frigate Orpheon|2
Green Greens|2
Halberd|1
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|4
Smashville|0
Yoshi's Island|5
NOT LISTED|1


Sheik|Number
Battlefield|0
Brinstar|3
Castle Siege|1
Delfino Plaza|2
Final Destination|2
Frigate Orpheon|2
Green Greens|3
Halberd|0
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|3
Smashville|0
Yoshi's Island|0
NOT LISTED|2


Ness|Number
Battlefield|1
Brinstar|2
Castle Siege|0
Delfino Plaza|0
Final Destination|12*
Frigate Orpheon|3
Green Greens|0
Halberd|3
Lylat Cruise|0
Norfair|2
Pictochat|0
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|4
Smashville|3
Yoshi's Island|4
NOT LISTED|0


Pokemon Trainer|Number
Battlefield|1
Brinstar|0
Castle Siege|0
Delfino Plaza|0
Final Destination|1
Frigate Orpheon|2
Green Greens|1
Halberd|6
Lylat Cruise|0
Norfair|1
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|3
Smashville|0
Yoshi's Island|0
NOT LISTED|1


Yoshi|Number
Battlefield|1
Brinstar|4
Castle Siege|0
Delfino Plaza|0
Final Destination|10
Frigate Orpheon|0
Green Greens|1
Halberd|2
Lylat Cruise|0
Norfair|2
Pictochat|1
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|7
Smashville|0
Yoshi's Island|0
NOT LISTED|0


Lucas|Number
Battlefield|1
Brinstar|3
Castle Siege|0
Delfino Plaza|0
Final Destination|7
Frigate Orpheon|2
Green Greens|2
Halberd|4
Lylat Cruise|3
Norfair|1
Pictochat|2
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|11
Smashville|1
Yoshi's Island|5
NOT LISTED|4


Mario|Number
Battlefield|0
Brinstar|1
Castle Siege|0
Delfino Plaza|0
Final Destination|2
Frigate Orpheon|2
Green Greens|2
Halberd|3
Lylat Cruise|2
Norfair|4
Pictochat|0
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|5
Smashville|0
Yoshi's Island|0
NOT LISTED|1


Bowser|Number
Battlefield|0
Brinstar|0
Castle Siege|0
Delfino Plaza|0
Final Destination|2
Frigate Orpheon|0
Green Greens|0
Halberd|1
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|0
Smashville|1
Yoshi's Island|0
NOT LISTED|0


Captain Falcon|Number
Battlefield|0
Brinstar|0
Castle Siege|0
Delfino Plaza|0
Final Destination|1*
Frigate Orpheon|0
Green Greens|0
Halberd|0
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|0
Smashville|0
Yoshi's Island|0
NOT LISTED|0


Samus|Number
Battlefield|2
Brinstar|0
Castle Siege|0
Delfino Plaza|2
Final Destination|0
Frigate Orpheon|0
Green Greens|0
Halberd|0
Lylat Cruise|0
Norfair|2
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|3
Smashville|0
Yoshi's Island|4
NOT LISTED|0


Jigglypuff|Number
Battlefield|0
Brinstar|0
Castle Siege|0
Delfino Plaza|0
Final Destination|1
Frigate Orpheon|0
Green Greens|3
Halberd|0
Lylat Cruise|1
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|1
Smashville|0
Yoshi's Island|0
NOT LISTED|1


Link|Number
Battlefield|1
Brinstar|2
Castle Siege|3
Delfino Plaza|0
Final Destination|1
Frigate Orpheon|1
Green Greens|2
Halberd|0
Lylat Cruise|1
Norfair|0
Pictochat|1
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|6
Smashville|0
Yoshi's Island|0
NOT LISTED|1


Zelda|Number
Battlefield|0
Brinstar|0
Castle Siege|1
Delfino Plaza|0
Final Destination|1
Frigate Orpheon|0
Green Greens|0
Halberd|0
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|0
Smashville|0
Yoshi's Island|1
NOT LISTED|0


Ganondorf|Number
Battlefield|0
Brinstar|1
Castle Siege|0
Delfino Plaza|0
Final Destination|2
Frigate Orpheon|0
Green Greens|0
Halberd|0
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|1
Smashville|0
Yoshi's Island|0
NOT LISTED|0
[/collapse]
 

xDD-Master

Smash Champion
Joined
Sep 22, 2008
Messages
2,992
Location
Berlin
If we could ban Characters MK would be banned over 9000 times.
Lets ban MK :troll:


@MK26: The only times MKs didnt ban FD SHOULD be vs. other MKs xD
 

TP

Smash Master
Joined
Sep 28, 2008
Messages
3,341
Location
St. Louis, MO
Great work. I'm proud to say I contributed to both the number of times Ganon was used and the number for Jigglypuff. Of course, I went MK for the majority of my games, so that sorta dilutes the point.

It's nice to see data backing up my choice to not have FD as a starter at my tournaments. However, at the last one I noticed how obviously it deserved to be a starter in doubles. Is it worth having separate starter lists for the two events, or is it better to just accept an imperfect doubles list?
 

stingers

Smash Obsessed
Joined
Oct 21, 2006
Messages
26,796
Location
Raleigh, NC
its better to just have fd as a starter.
weird stagecraft theorists are icky
just leave fd on lol
 

Tarmogoyf

Smash Master
Joined
Jul 15, 2008
Messages
3,003
Location
My house, NM
Is there any way these matchslips could be used to show the win % of each character against each character? AKA, Empyrical MUs rather than the 100% theorycraft SWf spews?

Obviously a lot of work, but think how useful this would be....
 

-Ran

Smash Master
Joined
Feb 16, 2008
Messages
3,198
Location
Baton Rouge
Is there any way these matchslips could be used to show the win % of each character against each character? AKA, Empyrical MUs rather than the 100% theorycraft SWf spews?

Obviously a lot of work, but think how useful this would be....
The entire spread sheet needs to be reformatted into an Access database. Every set has to become one entry. It's doable, just there's going to be a great deal of work going into it.
 

MK26

Smash Master
Joined
Jun 29, 2008
Messages
4,450
Location
http://www.mediafire.com/?zj2oddmz0yy for ZSS fix!
@philnye: yes to the first question, no to the second
but its safe to say if you banned a neutral you would have struck it, not be playing on it game 1 lol

The charts only apply to people who picked their character game 1
if you have a pocket mk, your stage ban counts toward whichever main you use

Thats also why the numbers are much lower than total usage - using a character 3 times in a 3-game set counts as a 3 in total usage, but a 1 in stage bans

dazwa if you want to count characters used in game 1 of a set, i can help you with that (PM me)
and if you want to count characters used in subsequent games in the set (i can calculate all characters used in games 2, 3, 4, and 5 combined, but not individually)

you did a damn good job of formatting it :)

EDIT: actually, just count the total stage bans as im writing above, subtract from total usage, and thats the number of times used in subsequent games lol
 

John12346

Smash Master
Joined
Jan 24, 2009
Messages
3,534
Location
New York, NY
NNID
JohnNumbers
So statistically speaking, MK banned FD about 40% of the time?
Not exactly. We don't know which characters banned which stages, but we can draw a conclusion that there was a tendency towards more FD bans because MK was used a ****load of times.

We can't really say more than that.
 

Nidtendofreak

Smash Hero
Joined
Feb 10, 2006
Messages
7,265
Location
Belleville, Ontario
NNID
TheNiddo
3DS FC
3668-7651-8940
The tables only apply to people who picked their character game 1
if you have a pocket mk, your stage ban counts toward whichever main you use

Thats also why the numbers are much lower than total usage - using a character 3 times in a 3-game set counts as a 3 in total usage, but a 1 in stage bans

[collapse=Stage Bans By Character]Asterisks are beside significantly high numbers


Meta Knight|Number
Battlefield|24
Brinstar|27
Castle Siege|11
Delfino Plaza|9
Final Destination|214*
Frigate Orpheon|4
Green Greens|25
Halberd|59*
Lylat Cruise|10
Norfair|16
Pictochat|13
PokemonStadium1|15
PokemonStadium2|3
Rainbow Cruise|33
Smashville|5
Yoshi's Island|30
NOT LISTED|17


Snake|Number
Battlefield|11
Brinstar|68*
Castle Siege|4
Delfino Plaza|10
Final Destination|53*
Frigate Orpheon|1
Green Greens|8
Halberd|10
Lylat Cruise|0
Norfair|8
Pictochat|2
PokemonStadium1|1
PokemonStadium2|2
Rainbow Cruise|31*
Smashville|5
Yoshi's Island|6
NOT LISTED|2


Diddy Kong|Number
Battlefield|2
Brinstar|22*
Castle Siege|3
Delfino Plaza|1
Final Destination|7
Frigate Orpheon|11
Green Greens|11
Halberd|11
Lylat Cruise|6
Norfair|35*
Pictochat|1
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|11
Smashville|0
Yoshi's Island|5
NOT LISTED|3


Falco|Number
Battlefield|2
Brinstar|75*
Castle Siege|2
Delfino Plaza|6
Final Destination|12
Frigate Orpheon|16
Green Greens|4
Halberd|7
Lylat Cruise|11
Norfair|15
Pictochat|2
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|26*
Smashville|1
Yoshi's Island|4
NOT LISTED|3


Wario|Number
Battlefield|5
Brinstar|2
Castle Siege|1
Delfino Plaza|7
Final Destination|38*
Frigate Orpheon|3
Green Greens|3
Halberd|8
Lylat Cruise|2
Norfair|10
Pictochat|2
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|7
Smashville|1
Yoshi's Island|5
NOT LISTED|6


Marth|Number
Battlefield|1
Brinstar|12
Castle Siege|6
Delfino Plaza|1
Final Destination|14
Frigate Orpheon|9
Green Greens|10
Halberd|21*
Lylat Cruise|2
Norfair|6
Pictochat|2
PokemonStadium1|6
PokemonStadium2|0
Rainbow Cruise|23*
Smashville|1
Yoshi's Island|7
NOT LISTED|3


Ice Climbers|Number
Battlefield|2
Brinstar|28*
Castle Siege|0
Delfino Plaza|2
Final Destination|2
Frigate Orpheon|0
Green Greens|3
Halberd|10
Lylat Cruise|1
Norfair|35*
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|10
Smashville|1
Yoshi's Island|3
NOT LISTED|2


Olimar|Number
Battlefield|4
Brinstar|26*
Castle Siege|1
Delfino Plaza|2
Final Destination|16
Frigate Orpheon|3
Green Greens|0
Halberd|8
Lylat Cruise|1
Norfair|12
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|23*
Smashville|0
Yoshi's Island|8
NOT LISTED|5


Pikachu|Number
Battlefield|8
Brinstar|38*
Castle Siege|3
Delfino Plaza|0
Final Destination|9
Frigate Orpheon|0
Green Greens|3
Halberd|6
Lylat Cruise|4
Norfair|5
Pictochat|1
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|3
Smashville|3
Yoshi's Island|2
NOT LISTED|2


King Dedede|Number
Battlefield|13
Brinstar|27*
Castle Siege|0
Delfino Plaza|5
Final Destination|18*
Frigate Orpheon|1
Green Greens|4
Halberd|4
Lylat Cruise|9
Norfair|8
Pictochat|5
PokemonStadium1|2
PokemonStadium2|1
Rainbow Cruise|5
Smashville|1
Yoshi's Island|4
NOT LISTED|3


Game and Watch|Number
Battlefield|2
Brinstar|3
Castle Siege|2
Delfino Plaza|1
Final Destination|23*
Frigate Orpheon|4
Green Greens|4
Halberd|11
Lylat Cruise|5
Norfair|6
Pictochat|2
PokemonStadium1|1
PokemonStadium2|1
Rainbow Cruise|8
Smashville|4
Yoshi's Island|6
NOT LISTED|4


Lucario|Number
Battlefield|8
Brinstar|8
Castle Siege|1
Delfino Plaza|1
Final Destination|17*
Frigate Orpheon|0
Green Greens|6
Halberd|5
Lylat Cruise|2
Norfair|3
Pictochat|0
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|10
Smashville|0
Yoshi's Island|0
NOT LISTED|0


Zero Suit Samus|Number
Battlefield|8
Brinstar|9
Castle Siege|4
Delfino Plaza|1
Final Destination|14
Frigate Orpheon|12
Green Greens|4
Halberd|10
Lylat Cruise|0
Norfair|6
Pictochat|2
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|2
Smashville|0
Yoshi's Island|3
NOT LISTED|1


Toon Link|Number
Battlefield|2
Brinstar|9
Castle Siege|1
Delfino Plaza|2
Final Destination|12
Frigate Orpheon|8
Green Greens|3
Halberd|12
Lylat Cruise|1
Norfair|2
Pictochat|1
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|7
Smashville|1
Yoshi's Island|3
NOT LISTED|2


Kirby|Number
Battlefield|3
Brinstar|8
Castle Siege|4
Delfino Plaza|1
Final Destination|8
Frigate Orpheon|0
Green Greens|2
Halberd|5
Lylat Cruise|1
Norfair|0
Pictochat|1
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|0
Smashville|0
Yoshi's Island|1
NOT LISTED|2


Fox|Number
Battlefield|3
Brinstar|8
Castle Siege|3
Delfino Plaza|1
Final Destination|1
Frigate Orpheon|1
Green Greens|0
Halberd|1
Lylat Cruise|3
Norfair|0
Pictochat|1
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|4
Smashville|1
Yoshi's Island|3
NOT LISTED|3


ROB|Number
Battlefield|9
Brinstar|13
Castle Siege|4
Delfino Plaza|7
Final Destination|7
Frigate Orpheon|3
Green Greens|9
Halberd|6
Lylat Cruise|0
Norfair|10
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|5
Smashville|0
Yoshi's Island|2
NOT LISTED|3


Pit|Number
Battlefield|0
Brinstar|9
Castle Siege|3
Delfino Plaza|2
Final Destination|7
Frigate Orpheon|2
Green Greens|5
Halberd|9
Lylat Cruise|2
Norfair|1
Pictochat|1
PokemonStadium1|6
PokemonStadium2|0
Rainbow Cruise|5
Smashville|0
Yoshi's Island|10
NOT LISTED|5


Peach|Number
Battlefield|2
Brinstar|4
Castle Siege|0
Delfino Plaza|4
Final Destination|7
Frigate Orpheon|2
Green Greens|2
Halberd|7
Lylat Cruise|1
Norfair|5
Pictochat|1
PokemonStadium1|0
PokemonStadium2|2
Rainbow Cruise|8
Smashville|1
Yoshi's Island|2
NOT LISTED|3


Donkey Kong|Number
Battlefield|3
Brinstar|4
Castle Siege|1
Delfino Plaza|3
Final Destination|19*
Frigate Orpheon|2
Green Greens|2
Halberd|4
Lylat Cruise|2
Norfair|3
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|7
Smashville|2
Yoshi's Island|0
NOT LISTED|2


Luigi|Number
Battlefield|0
Brinstar|14*
Castle Siege|2
Delfino Plaza|1
Final Destination|21*
Frigate Orpheon|1
Green Greens|1
Halberd|1
Lylat Cruise|1
Norfair|4
Pictochat|1
PokemonStadium1|2
PokemonStadium2|1
Rainbow Cruise|2
Smashville|0
Yoshi's Island|3
NOT LISTED|5


Wolf|Number
Battlefield|2
Brinstar|8
Castle Siege|3
Delfino Plaza|4
Final Destination|10
Frigate Orpheon|3
Green Greens|0
Halberd|5
Lylat Cruise|7
Norfair|3
Pictochat|2
PokemonStadium1|2
PokemonStadium2|0
Rainbow Cruise|10
Smashville|1
Yoshi's Island|2
NOT LISTED|6


Sonic|Number
Battlefield|4
Brinstar|20*
Castle Siege|0
Delfino Plaza|7
Final Destination|3
Frigate Orpheon|1
Green Greens|2
Halberd|6
Lylat Cruise|1
Norfair|5
Pictochat|0
PokemonStadium1|1
PokemonStadium2|0
Rainbow Cruise|3
Smashville|2
Yoshi's Island|1
NOT LISTED|4


Ike|Number
Battlefield|2
Brinstar|5
Castle Siege|0
Delfino Plaza|1
Final Destination|8
Frigate Orpheon|2
Green Greens|2
Halberd|1
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|4
Smashville|0
Yoshi's Island|5
NOT LISTED|1


Sheik|Number
Battlefield|0
Brinstar|3
Castle Siege|1
Delfino Plaza|2
Final Destination|2
Frigate Orpheon|2
Green Greens|3
Halberd|0
Lylat Cruise|0
Norfair|0
Pictochat|0
PokemonStadium1|0
PokemonStadium2|0
Rainbow Cruise|3
Smashville|0
Yoshi's Island|0
NOT LISTED|2


Ness|Number
Battlefield|1
Brinstar|2
Castle Siege|0
Delfino Plaza|0
Final Destination|12
Frigate Orpheon|3
Green Greens|0
Halberd|3
Lylat Cruise|0
Norfair|2
Pictochat|0
PokemonStadium1|3
PokemonStadium2|0
Rainbow Cruise|4
Smashville|3
Yoshi's Island|4
NOT LISTED|0
[/collapse]
So FD was the most banned stage for 12/26 (Went only to Ness when I made this list) characters in that list (46.2%), and within the top 3 most commonly banned stages for 19/26 characters (73.1%). I am counting ties as within that top level/most banned level, except for in the case of Sheik, who's bans were too spread out evenly, with no stage banned more than 3 times.

In comparison:

FD being most banned: 12/26 (46.2%)
FD being top 3 banned: 19/26 (73.1%)

Brinstar being most banned: 9/26 (34.6%)
Brinstar being top 3 ban: 18/26 (69.2%)

Rainbow Cruise being most banned: 3/26 (11.5%)
Rainbrow Cruise being top 3 ban: 13/26 (50.0%)

Norfair being most banned: 2/26 (7.7%)
Norfair being top 3 ban: 6/26 (23.1%)

Green Greens being most banned: 0/26 (0.0%)
Green Greens being top 3 ban: 2/26 (7.7%)

Obviously not complete, as not all characters where in that list, but food for thought. Also a funny note: Yoshi Island was the most banned stage once, more so than Green Greens. Silly Pit mains.
 

Nidtendofreak

Smash Hero
Joined
Feb 10, 2006
Messages
7,265
Location
Belleville, Ontario
NNID
TheNiddo
3DS FC
3668-7651-8940
@niddo: meh, the rest of the characters dont really matter
(im finishing them up now)
I'm not going back through the chart to update the numbers: my eyes hurt from the constant scrolling and squinting at numbers, so it's a good thing they don't matter. >_>
 

Blacknight99923

Smash Champion
Joined
Jan 1, 2009
Messages
2,315
Location
UCLA
so metaknights are banning FD vs everyone except snake,

considering snake was the second most used character i am not at all suprised by this.


Over half the bans

Every character other than like wario/ness are banning brinstar/RC

I mean marth bans FD a lot but he still banned halberd (against snake not suprsing) and RC more than FD


Honestly I see this as more reason to keep Fd as a starter to balence the metaknights, I mean if mk doesn't have any reason to start on smashville why would he

edit if its a 3 stage starter i'd be ok with no FD
Shoutouts to Dazwa
 

BSP

Smash Legend
Joined
May 23, 2009
Messages
10,246
Location
Louisiana
^^If it's going to get struck anyway, what will keeping it do? It's pretty obvious that it's not considered a neutral

with these bans, it's pretty obvious that everyone's in fear of that pocket MK lol
 

MK26

Smash Master
Joined
Jun 29, 2008
Messages
4,450
Location
http://www.mediafire.com/?zj2oddmz0yy for ZSS fix!
so i have the formula for which stages were counterpicked by which characters

but im not interested in doing more grunt work tonight

so i can either put it off until tomorrow

or ill put the formulas you need in the collapse box below and someone else can do it if theyve downloaded the file

this will only work with office <= 2007

and if nobody uses it at least its a reference for myself

1) place this formula in v2:v5133
Code:
=IF(I2="no show","",IF(J2="no show","",IF(A2="","",IF(F2="",IF(L1=B1,I2,J2),""))))
2) place this formula in w2:w5133
Code:
=IF(V2="","",H2)
3) place this formula in x2:x5133
Code:
=IF(V2=$Z$1,W2,"")
4) order the stages alphabetically in z2:z17

5) place this formula in aa2:aa17
Code:
=COUNTIF(X:X,Z2)
6) Type in "Number" (no quotes) in AA1

7) In Z1, type in each character's name, starting with Meta Knight

At this point, you should see a few numbers pop up beside the stage list
If you did it right, you'd see that Brinstar was cp'd by MKs 46 times, Battlefield 56 times, RC 47 times, and Smashville 37 times
If you did it wrong, you'd get errors

8) Copy the resulting chart into Word
(ideally youre copying it twice, once to leave as a table and once to continue with the steps)

9) Convert Table to Text using | as the divider

10) Place [noparse]
and
[/noparse] around the resulting text then copy to swf
OR
copy to the advanced editor on swf and select the
button

11) Repeat steps 7 to 10, simply changing the name in Z1, the rest is done automatically

12) Post results
I can also quickly change this to calculate by stage (ie see who counterpicked brinstar most) and by counterpicked character (ie see who switched to which character when they were counterpicked to each stage, or which character people were originally playing when they were counterpicked to a stage)
 
Top Bottom