Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tournament tie breaker
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tournament tie breaker
On Mar 20, 1:11*am, Nate wrote:
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 Correction: Sam's score in round 1 should be "B, 1, 95". I guess I'm having difficulty with math at 1:15 am. Nate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scoring Rank with Tie Breaker | Excel Worksheet Functions | |||
Function breaker tool | Excel Programming | |||
Password Breaker | Excel Programming | |||
Worksheet Security Breaker | Excel Discussion (Misc queries) | |||
Excel Sort Tie Breaker | Excel Worksheet Functions |