Blog Need help (1 Viewer)

Last season, we did Individual Stats on Sky Blues Talk based around Glicko-2, Elo, and the players who made an appearance on the pitch for each game compared to their opponent's team rating for that particular match, over the course of the 2019/20 season.

This year, I would like to carry on with this, just out of sheer curiosity to see if there are any patterns in the data. Two seasons of data excites me more than just one season worth.

An example of my ramblings can be shown using the City's Goalkeepers below.



To get to where I want to go, I need to keep filling this out for this season;



This one I think I can do.

Marko Marosi left at the end of the season and Simon Moore joined at the start of the season before the season started. So he can go in at Game 0 or Game 46.

I think this is correct, and no other person has played in the goalkeeper position this season.

This is the example. I also would like to do this for defenders, midfielders and attackers.

So to recap,

I need the below updated with the player's name for this season, and if applicable, the date the player has either joined or left on. Also, if the players are in the right groupings and if the groupings are correct.

Defenders



Midfielders



Forwards




Thanks for your help in advance.

That's what I'm after, shmmeee. Cheers!