How to divide people into equal groups. Benchwarmers can only skip a round once.

[dekion]

Hi

I organize a card tournament, with over 100 participants in past editions.

The players are divided by 4 at a table, play a game and they are drawn again to play at another table.

When we can't have a table of 4, they have to sit on the bench.

So far no problem and using ROUNDUP & RANk and everything works out well.

Now comes the hard part. Players can only be benched once.

So I'm looking for a formula I can use for players who have been benched, come out to a table of 4 and so can't be a 2x benched player.

When a player loses a game 3x, they are excluded from the tournament.
This is how we build down until we finally have a table of 4 (people).

Anyone an idea in which direction I could go to fix this?

 

[Herakles]

When you say fix this, are you starting from scratch or have you already developed something?

 

[dekion]

I'll be starting from scratch, we changed our tournament process, but I maybe have an idea.

Based on a status in example benched. I'll rank them by giving a random number < 1000 the others will get a number > 1000

This would mean that benched people always should play.

I'll need to work it out to test my hypothesis.

Regards

 

[dekion]

I think I solved it by adding this

=IF(C2="Benched",RAND(),RAND()*100)

By doing so if you're benched, I give a number between 0-1 which is lower than 1-100