Squash Scores into leader board and individual stats

[oztexs]

hi all,

At work we currently have 6 players who currently play squash against each other every week. the amount of games each player played usually varies with some players playing 2-3 times more games then others.

the scores are currently inputted into excel using a table.

columns = game number
rows = score against name

the more games the more columns.

Name 1 2 3 4 5 6 7 8 9 10 .......
Player 1 3 2
Player 2 4 2
Player 3 2
Player 4 1 0 3 0
Player 5 1 0
Player 6 3

So based on the above .. 6 games have been played

Player 1 = played 2 times winning 1 and drawing the other. Beat player 4 .. 3-1 and drew against player 2 .. 2-2
etc etc

My question is, how can I get stats using the above type of scoring system that will allow me to see the following;

1. Whats the scores between player 4 and player 5
2. How many games has player 4 played
3. How many times has player 4 played player 5

and a ladder for those with the best winning percentage

ive done a search and I cant find anything for this type of scoring system ??

Thanks in advance

[JeteMc]

Looking at the way that the data is set up I do not know how you would know who played who.
For instance looking at the data how do you know that player 1 played, and beat, player 4?
Against whom did player 4 play her/his 3rd and 4th games?
I have restructured the data (notice I gave names to the players i.e. Al = Player1, Fred = Player6),
so that you can then make a ladder by sorting the data as in the attached file.

Squash Leader Board.xlsx

[oztexs]

wow this looks promising !

I will check it out today.

when I posted the thread I didn't realise it reformatted the table, hence your confusion over player 4.

I will upload my actual table from home tonight as I cant do so from work.

Thanks heaps !!!