# Power Ranking - Best way to calculate

##### Rookie
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
Elo rating system. Invented in 1960 by a physicist and a chess player in one person.

http://www.3dkingdoms.com/chess/elo.htm

Use games only for initial estimation. After that, count only win/loss/draw.

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.