N
Nate
I'm working on a spreadsheet for a student tournament and having
trouble with the code to break ties. In the tournament there are 3
rounds and may be mulitple sections per round (usually 2, but maybe
more) - each section would have up to 8 students. The students are
scored in each round with a rank and points so Student1 may have a 1
rank and 100 points where Student2 has a 2 rank and 95 points. For
rounds 2 & 3, the students are mixed up in different sections so they
all get to compete against everyone else. When the ranks and points
are added up for each student there may be a multiple-way tie. If
that happens I need to look if the tying students went head-to-head in
any of the rounds (in the same section) and the better rank in that
round would be the winner of the tie. If the tie can't be broken by
rank, then I'll look at the points. If that doesn't work, then it may
be an unbreakable tie.
Example below (A, 1, 100) would be section A, rank 1, points 100.
Rnd 1 Rnd 2 Rnd 3 Total Tie?
Fred A, 1, 95 B, 2, 95 A, 1, 100 4, 290 Y
Sam B, 2, 95 A, 1, 100 A, 2, 95 4, 290 Y
In this case, Fred would be the winner because they went head-to-head
in round 3 and Fred had the better rank. In the spreadsheet, I do
have separate columns for the section, rank, and points (I'm not
concatenating them like above).
I'm thinking that this needs to be some kind of looping code that
looks at all the combinations of tying students, especially if there
are 3+ way ties; A-B, A-C, B-C, etc. Whomever wins on the most
combinations would be the winner. I hope this makes sense! Any
ideas?
Thanks,
Nate
trouble with the code to break ties. In the tournament there are 3
rounds and may be mulitple sections per round (usually 2, but maybe
more) - each section would have up to 8 students. The students are
scored in each round with a rank and points so Student1 may have a 1
rank and 100 points where Student2 has a 2 rank and 95 points. For
rounds 2 & 3, the students are mixed up in different sections so they
all get to compete against everyone else. When the ranks and points
are added up for each student there may be a multiple-way tie. If
that happens I need to look if the tying students went head-to-head in
any of the rounds (in the same section) and the better rank in that
round would be the winner of the tie. If the tie can't be broken by
rank, then I'll look at the points. If that doesn't work, then it may
be an unbreakable tie.
Example below (A, 1, 100) would be section A, rank 1, points 100.
Rnd 1 Rnd 2 Rnd 3 Total Tie?
Fred A, 1, 95 B, 2, 95 A, 1, 100 4, 290 Y
Sam B, 2, 95 A, 1, 100 A, 2, 95 4, 290 Y
In this case, Fred would be the winner because they went head-to-head
in round 3 and Fred had the better rank. In the spreadsheet, I do
have separate columns for the section, rank, and points (I'm not
concatenating them like above).
I'm thinking that this needs to be some kind of looping code that
looks at all the combinations of tying students, especially if there
are 3+ way ties; A-B, A-C, B-C, etc. Whomever wins on the most
combinations would be the winner. I hope this makes sense! Any
ideas?
Thanks,
Nate