Hello everyone. I am currently trying to create an Excel spreadsheet
that will allow someone to organise a tournament (a videogaming
tournament)

Basically, the tournament starts with the players being split into 4
groups, in each group a player must play every other player twice,
someone can either win 2-0 or the two opponents can draw 1-1.

At the end of the four groups the four highest placing participants are
entered into a 16 man knockout tournament (single elimination)

I am stuck with trying to think of a viable method for organising the
group stages. Players need to be given 1 point per match they win, so
if two people draw they both receive one point and if one person beats
another they receive 2 points. Relatively straightforward.

The only way I can think of doing this is by creating a league table
per group and having a button next to each name which, when pressed,
will add 1 point to their current total and would need to be pressed
twice for two wins etc.

Obviously this system is flawed as anyone can press the button to award
themsevles a point when noone is looking and mistakes can be made
(adding a minus 1 button as well may just be long winded)

I think that once this problem is solved the rest will be fairly
straightforward, organise groups according to number of points and then
use a macro to copy and paste the group finalists into a 16 man knockout
grid.

Can anyone think up better methods of approaching this problem?

(I hope this is in the right forum)


--
SunGod87
------------------------------------------------------------------------
SunGod87's Profile: http://www.excelforum.com/member.php...o&userid=29736
View this thread: http://www.excelforum.com/showthread...hreadid=494492

As far as your buttons go, you can lock them and then protect your sheet
so that users can only enter data into the unlocked cells and not tamper
with the locked cells/controls. There are a ton of tournament
scheduling programs available online as well. Maybe do a search to
pick the one that's right for your project.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=494492