Power Ranking - Best way to calculate

So, I have created a spreadsheet to keep sort of a ranking between 20 of us that play tennis regularly. I have used the PWR method, where you just have a matrix and record the outcome of a match as a 1 for a win and 0 for loss.

This takes solves problems such as A defeats B, B defeats C but C defeats A and those sorts of thing. Also it takes into account if someone beats a higher ranked player, then that win is boosted since they beat a quality player.

Now, this is where it kind of gets trickier. Of course a win by 7-6 and 7-5 is completely different than a 6-0 6-0 win. I want to take these into account.

Should I record on the matrix for calculations, instead of 1 = Win, would it work recording the games won?

So for example

A B C D
A 0 1 0 0
B 0 0 1 0
C 1 0 0 0
D 0 0 0 0

Where A defeats B, B defeats C and C defeats A - here it's just recorded as simply win/loss outcome.

But let's say A vs B = 6-1 6-1 .... B defeats C 7-6 7-6 .... and C defeats A 6-2 6-2

Would it be better to put the games outcome where the matrix would then be:

A B C D
A 0 12 4 0
B 2 0 14 0
C 12 12 0 0
D 0 0 0 0

Would this work?

PS - I apologize before hand if this is not the best thread to ask this but really didn't know where to fit it
 
Last edited:

LGQ7

Hall of Fame
But let's say A vs B = 6-1 6-1 .... B defeats C 7-6 7-6 .... and C defeats A 6-2 6-2
A > B (6-1), (6-1)
B > C (7-6), (7-6)
C > A (6-2), (6,2)

A = 6 + 6 + 2 + 2 = 16
B = 7 + 7 + +1 +1 = 16
C = 6 + 6 + 6 + 6 = 24

16 + 16 + 24 = 56
56 ÷ 3 = average = 18.66

18.66 = 1500 set for average.

A = 18.66 - 16 = 1500 - 27 = 1473
B = 18.66 - 16 = 1500 - 27 = 1473
C = 24 - 18.66 = 1500 + 44 = 1544

https://tt.tennis-warehouse.com/ind...ls-have-you-accomplished.640872/post-13261405
 
Last edited:

LGQ7

Hall of Fame
The Chessmaster 2100 was theoretically 2100 in rating = 2100 -1500 = a 97% winning chance against an average player, or it is is in the 97th percentile.


 
Top