How do you make a top eleven spreadsheet

[talisman]

This is the spreadsheet I use, just the basic list of players, matches and record the performance ratings, the sheet then gives the average.



Red numbers denote MoM. Yellow/Red colour fill is for cards, Mid blue colour fill injured, lighter blue for the number of days. Grey shading denoted not at club for those days (new signing, player sold).

A second tab keeps the player appearances, goals, assists records.



Red colour fill for stats up to start of current season, blue colour fill for total to date.