#### SalvadorVeiga

##### 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

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: