Help with 20 player round robin

by **Jippd** on Fri Jan 13, 2012 7:39 am

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.

by **barackattack** on Fri Jan 13, 2012 7:42 am

Excel

=RUNLIST(PosMatch)*[select the list of names you have]

You're welcome

by **Jippd** on Fri Jan 13, 2012 7:50 am

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

by **Jippd** on Fri Jan 13, 2012 7:55 am

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.

by **barackattack** on Fri Jan 13, 2012 8:18 am

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.

by **Jippd** on Fri Jan 13, 2012 8:30 am

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?

by **greenoaks** on Fri Jan 13, 2012 8:56 am

use challonge.com or pm me your email and i'll send you a spreadsheet i use for my Best At Beta tournaments

by **barackattack** on Fri Jan 13, 2012 9:02 am

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.