Round robin tournament, result comparisons

R

Rowboat

New Member
Joined
Jul 27, 2017
Messages
4
Hello,

I'm running a round robin tournament with following table:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
1
6613-70.32

<tbody>
[TD="align: center"]Group A[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]MW[/TD]
[TD="align: center"]ML[/TD]
[TD="align: center"]FW[/TD]
[TD="align: center"]FL[/TD]
[TD="align: center"]FD[/TD]
[TD="align: center"]FA[/TD]
[TD="align: center"]POS[/TD]

[TD="align: center"]1[/TD]
[TD="align: center"]Player 1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]4[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]Player 2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0.76[/TD]
[TD="align: center"]1[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Player 3[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="bgcolor: #9FC5E8, align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Player 4[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #9FC5E8, align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-1[/TD]
[TD="bgcolor: #B6D7A8, align: center"]0.48[/TD]
[TD="align: center"]5[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]Player 5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFE599, align: center"]2[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]-4[/TD]
[TD="align: center"]0.39[/TD]
[TD="align: center"]7[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]Player 6[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]4[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0.56[/TD]
[TD="align: center"]3[/TD]

[TD="align: center"]7[/TD]
[TD="align: center"]Player 7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #595959, align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFE599, align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0.53[/TD]
[TD="align: center"]2[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]Player 8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="bgcolor: #595959"][/TD]
[TD="bgcolor: #FFE599, align: center"]1[/TD]

[TD="align: center"]8[/TD]

</tbody>

First criteria to pick a group winner is the number of Matches Won (MW), followed by Frame Average (FA). I've managed to do this with a combination of rank.eq- and sumproduct -functions (by watching a video on youtube). POS: (=RANK.EQ(K2,$K$2:$K$9,0)+sumproduct(--(K2=$K$2:$K$9),--(P2<$P$2:$P$9))

What I'd like to know is how to compare the two players' (3 and 4) match result with same Frame Average, and take it into account in the POS-criteria.

As you can see in the POS-column, they both have position 5, which I'd like to solve with the result of their respective encounter, highlighted in blue.
So Player 3 would be No.5 and 4 No.6.

Just curious about this, I can easily check their positions from the table, but this stuck to my mind a bit, and I'd like to know if there's a solution :).

Cheers,
Rowboat
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
Couple of things, it's tricky enough without using vba to workout the HTH results what happens if more than two players tie

Secondly you could simplify the current ranking by making the MW and FA a decimal and ranking on that
Eg (MW*2) + FA in a column and rank on that or just MW+FA and again Rank on that

Visually might only be the easiest option
 
Last edited:
Upvote 0
jimrward said:
Couple of things, it's tricky enough without using vba to workout the HTH results what happens if more than two players tie

Secondly you could simplify the current ranking by making the MW and FA a decimal and ranking on that
Eg (MW*2) + FA in a column and rank on that or just MW+FA and again Rank on that

Visually might only be the easiest option
Click to expand...

I can see your point about the simplification. The first idea was to have three criteria, so MW and Frame Difference (FD) would come before Frame Average, but I feel the FA will handle the tie situation just by itself, unless of course the MW/FA are equal. But then the frame difference has to be equal as well (I guess). Also, as you mentioned, three or more ties would complicate things quite a bit.

I'll have to stick to the visual on this one! Thanks for the comment.
 
Upvote 0
If you want to add further tie break options you can create a longer decimal

In general terms points + (crit1/100)+(crit2/10000) etc if you have a criteria which can be positive or negative I always subtract from 500 again depends on magnitude of the criteria value
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
20 team round robin golf league schedule - 3 courses
Replies
0
Views
412
dep1969
D
J
  • Question Question
help with combinations
Replies
3
Views
394
skillilea
S
S
  • Question Question
Cost Per Person Per Attendance
Replies
3
Views
98
Eric W
Eric W
Joneye
  • Question Question
Index & Match or Other Look up Advice
Replies
2
Views
67
Joneye
Joneye
H
  • Question Question
Transposing Data - Evaluating formula to an array error.
Replies
1
Views
59
Skyybot
Skyybot

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,021
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top