Apologies for the delay in replying to this I have been incredibly busy at work. What you say is correct although I would only like to collate the statistics of my own side for the season, the league collect all players data but I am collecting data in more depth than is really required, this is to aid our captain in team selection. I will attach one of the home matches from last season so you can see the data that we do collate, it is the same data that I would like to put into a single master stats sheet throughout the season, I will also attach last season's completed stats sheet that I had to compile manually.
As you can see in the player stats book, I collate the data for each player individually showing their performances against each team and then a team data sheet that shows just their totals.
Bookmarks