Tools to track your team performance

[motrin]

I do something similar. I enter the ratings for each match and select the competition. A script will calculate the average per competition. It will change the color of the name based on which form of competition they perform best. Not sure if players perform better in specific competitions, but I made this when I suspected they did. It also does an overall average of ratings and has a sparkline I can quickly see there players overall trend. I don't keep long term stats. So I reset this spreadsheet every season.

Edit: I use Google sheets for all my t11 spreadsheets so I can access it from anywhere on my phone. If I export this to excel, the scripts won't transfer and the sheet is useless. And I'm not about to recreate this in excel. Additionally, I found no benefit from tracking the way this sheet does.

Sent from my SAMSUNG-SM-G900A using Tapatalk