Round robin tournament, result comparisons

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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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
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

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

Forum statistics

Threads
1,223,240
Messages
6,170,951
Members
452,368
Latest member
jayp2104

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