Hi there,
I am wanting to do some analysis of some data on player performance, specifically which partnerships of players work best together. Basically there is a pool of players in the group, but only 10 people play each week and they are split into 2 teams of 5 who play each other. So someone may play 3 weeks in a row then doesnt play for a few weeks, it also means some people might play 35 games a season or some might play 45 etc. I was wanting to find some way to show which partnerships of players win the most... Is this possible?
We play once a week max and we play over 1 year, so technically there could be 52 games a year, some weeks there is no game (NG) though.
If you need anymore info please let me know, hopefully you get where i am coming from! The basic data set is below - it doesnt show the whole of the data.
Many thanks
Pete
<TBODY>
</TBODY>
I am wanting to do some analysis of some data on player performance, specifically which partnerships of players work best together. Basically there is a pool of players in the group, but only 10 people play each week and they are split into 2 teams of 5 who play each other. So someone may play 3 weeks in a row then doesnt play for a few weeks, it also means some people might play 35 games a season or some might play 45 etc. I was wanting to find some way to show which partnerships of players win the most... Is this possible?
We play once a week max and we play over 1 year, so technically there could be 52 games a year, some weeks there is no game (NG) though.
If you need anymore info please let me know, hopefully you get where i am coming from! The basic data set is below - it doesnt show the whole of the data.
Many thanks
Pete
| Players | 14/06/2012 | 21/06/2012 | 28/06/2012 | 05/07/2012 | 12/07/2012 | 19/07/2012 | 26/07/2012 | 02/08/2012 | 09/08/2012 | 16/08/2012 | 23/08/2012 | 30/08/2012 | 06/09/2012 | 13/09/2012 | 20/09/2012 | 27/09/2012 | 04/10/2012 | 11/10/2012 | 18/10/2012 |
| Ben | NG | D | L | N | NG | L | L | W | L | L | L | N | W | L | N | N | L | W | W |
| Chris | NG | N | N | N | NG | L | N | L | L | W | W | N | N | N | N | N | L | W | N |
| Sagar | NG | D | L | W | NG | N | L | W | W | N | L | L | W | N | D | N | N | N | L |
| Tom M | NG | D | W | N | NG | W | N | N | W | W | N | W | N | L | D | W | L | N | W |
| Hugo WS | NG | N | N | W | NG | L | W | L | W | L | N | L | L | W | D | L | W | N | W |
| Pete R | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Nico | NG | N | N | W | NG | W | W | L | W | L | N | N | W | W | D | N | L | N | N |
| Stefan | NG | D | L | L | NG | N | N | N | N | W | W | L | L | L | D | W | W | W | L |
| Nick | NG | D | W | N | NG | N | L | N | N | N | N | N | N | N | N | N | N | N | N |
| Grant | NG | D | W | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Dan | NG | N | N | N | NG | W | L | N | L | N | N | N | W | N | D | L | L | L | N |
| Pete G | NG | N | W | N | NG | N | W | L | N | L | W | W | L | W | N | W | N | N | L |
| Tom W | NG | D | N | L | NG | L | N | N | N | W | L | N | L | L | D | L | N | W | W |
| Dave | NG | N | W | N | NG | L | N | N | L | N | N | N | N | W | D | L | N | L | N |
| Will T | NG | N | L | L | NG | N | N | W | L | W | L | W | N | L | N | N | W | W | L |
| Johnny B | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Gav | NG | N | N | N | NG | N | W | N | N | N | N | N | N | N | N | N | W | N | N |
| Hugo S | NG | N | N | L | NG | N | N | W | N | N | N | N | L | N | N | W | N | N | W |
| Freeman | NG | N | N | W | NG | W | W | W | W | N | W | W | N | N | N | W | N | L | L |
| Rowson Jr | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Matt | NG | D | N | W | NG | W | N | N | N | L | W | N | w | W | D | N | N | N | N |
| Mark | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Jimmy | NG | D | N | N | NG | N | L | L | N | N | N | N | N | N | N | L | N | N | N |
| Good Will | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| John | NG | D | W | N | NG | N | N | N | N | N | N | N | N | N | D | N | W | N | N |
| Ross | NG | N | N | L | NG | N | N | N | N | N | N | N | N | N | N | N | N | L | N |
| Chris S | NG | N | N | N | NG | N | N | N | N | N | L | W | N | N | N | N | N | N | N |
| Chris (Chris S' mate) | NG | N | N | N | NG | N | N | N | N | N | N | L | N | N | N | N | N | N | N |
| Alex Hurrel | NG | N | N | N | NG | N | N | N | N | N | N | L | N | N | N | N | N | N | N |
| Jonny Original | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | L | N |
| Mike | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
| Piers | NG | N | N | N | NG | N | N | N | N | N | N | N | N | N | N | N | N | N | N |
<TBODY>
</TBODY>
