• 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!

Tournament Match and Round Calculations?

metalmonstar

Smash Lord
Joined
Apr 30, 2008
Messages
1,081
Spreadsheet with come Match calculations

I am trying to calculate the number of matches each tournament format requires to complete given a number of participants, best of Matches, and setups. I created a spreadsheet with some formulas, but I am not quite sure if I did it correctly or not.

TOs, math wizards, or excel gurus can you look at the spreadsheet and confirm that the formulas are correct? If not what changes need to be made. What did I miss or do wrong and Why is it wrong?

Thanks for your help.
 

Zankoku

Never Knows Best
Administrator
BRoomer
Joined
Nov 8, 2006
Messages
22,906
Location
Milpitas, CA
NNID
SSBM_PLAYER
Just wondering, the third set of numbers, "Number of Rounds Factoring in TVs"... why would it take number of games per set into account?
 

metalmonstar

Smash Lord
Joined
Apr 30, 2008
Messages
1,081
Just wondering, the third set of numbers, "Number of Rounds Factoring in TVs"... why would it take number of games per set into account?
I was wondering why time looked a bit off. I feel dumb now, but I think what I was thinking was that number of rounds was simply matches divided by tvs.

Also I was wondering how to incorporate efficiency in. How well is the tournament going? Slower than expected or faster than expected. I was thinking making based off how you are doing in comparison to the last even ran compared to the maximum time allotted per event.
 
Top Bottom