Hi @_Ben_.
Thanks @danielgear for looping me in on this!
This is absolutely excellent and I love it. As others have also said, I especially love the presentation. It's so clear to read and looks more dashboard than spreadsheet, which makes it appealing and accessible.
I love the parts which drop simple insight on your lap that FM doesn't natively give you. Like:
and
These are great, and provide a different (and ultra-useful) perspective when trying to compare individual players from high-performing teams vs ones in low-performing sides, as per @Shrewnaldo's earlier observation.
I also LOVE that you've managed to incorporate the possession adjusted variants in your sheet. That's something I should really figure out how to do. I assume the team's average possession so far this season needs aggregated manually and input somewhere for each individual player analysis?
I've done a similar thing to your 'as a creator,' 'as a finisher,' 'as a defender' sections, just with different names (creative efficiency, striking efficiency, defensive interferences), but the concept is the same. I've tied in the player's salary to try and tie the defensive or offensive actions to a value, almost in line with the "trying to buy points" value-driven stats analysis recruitment philosophy, but not sure if something like that fits in with your intentions here?
I am writing a guide just now for my Excel bit, but my main frustration is wishing I could automate multiple 'find and replace' commands to occur the moment the user hits 'paste.' I don't know VB though I wish I did! Does your automation involve any clever macros? If so, teach me!
I am keen to help however I can on this, even if it's just as a sounding board for feedback.
What's your Twitter @_Ben_, so I can follow?