Page 1 of 1
Help with 20 player round robin
Posted:
Fri Jan 13, 2012 7:39 amby Jippd
Okay for a tournament I'm running I want to do a 20 player round robin. It is going to be 4 batches of 5 games each.
My question is once I have a list of 20 items (my twenty players) is there something online where I can plug it in and it will give me every combination so I can make sure everybody plays everyone once. I just realized I don't know how to do this to make sure everyone gets 5 and only five games every round
Thanks.
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 7:42 amby barackattack
Excel
=RUNLIST(PosMatch)*[select the list of names you have]
You're welcome
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 7:50 amby Jippd
I don't have to tell it that I want groups of two for the list anywhere in the formula? I have never used excel so I'm fairly inept
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 7:55 amby Jippd
I'm not getting that to work...To test it I put the values
a through t in column a row 1-20. I tried entering that formula in b1 and all that came up was #NAME when i selected a1:a20
I then tried selecting b1-20 and entering the formula and then selecting cells a1:a20 but that did not work.
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 8:18 amby barackattack
You have to put the formula in b1 and then use the draw down method of pasting it, rather than posting the same formula in all 20 boxes.
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 8:30 amby Jippd
Not sure what draw down means.. and when I select cells A1:A20 i have to get rid of the [] brackets right? Or am I supposed to keep them and to be sure cell b1 should be =RUNLIST(PosMatch)*A1:A20
If I keep the brackets it tells me the name I entered is not valid
?
And I know how to copy and paste does draw down mean just hit copy and then paste what is in cell b1 in every cell b2 through b20?
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 8:56 amby greenoaks
use challonge.com or pm me your email and i'll send you a spreadsheet i use for my Best At Beta tournaments
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 9:02 amby barackattack
Sorry I meant normal brackets () not square brackets. You keep them.
If you highlight b1 then on the black border that pops up around the cell there's a black box in the corner. If you drag that down it fills in the formula as you drag it down the column.
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 9:03 amby Jippd
Ah sweet I have challonge I didn't know it did round robin too. Thanks!
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 9:22 amby greenoaks
Jippd wrote:Ah sweet I have challonge I didn't know it did round robin too. Thanks!
challonge is good because you can post the image in the thread for everyone to view
Re: Help with 20 player round robin
Posted:
Fri Jan 13, 2012 10:22 amby Qwert