Trololo said: I managed to DL with the view you said, I go to your Excel and add the file, I import my Milan team that I copy-paste in the "Squad_Data_N" tab but in the "Squad_Derivatives_N" view everything is at 0.

What am I doing wrong? Expand

To be honest, I have no clue... You could fiddle a bit with the file and see if something works out.

As for your earlier comment, when you edit the connection, you can change the 'Source' of input to the path of your .html squad export.

I just want to say that there is more progress being made with this project. There is a Korean version out there that changes way more variables than the Chinese one, resulting in a more positioning oriented match engine. And then there is a 'fusion' being worked on right now.

Check this reddit thread for the most recent discussion.

I use a modified version of this one: https://www.reddit.com/r/footballmanagergames/comments/17hkiip/fm_squad_assessment_spreadsheet_v7_fm24_ready/

Use the 'Export_squad'-view in this link: fm_squad_assessment_spreadsheet_v7. Export your squad through the game (Ctrl-P > Export to .html).

This is the excel-sheet I made:
Homebrew Player Rating Coefficients Excel-sheet

In Excel, in 'Data'>'Queries and Connections', change the 'Source' to the .html-file exported through the view.

Orion said: This is the result for linear model for STC in FM23 that uses all the features. Where would you put the line which features are still important and which are not? Expand

Thanks for the results. It seems to be a pretty linear decrease over the coefficients. It is not that difficult to put all of them into an excel sheet and use them for calculations, so that is a possibility too.

Right now I am using the results in the following way (can share if there is interest):



Note: PlaFac is potential playmaking versus defensive contribution with regards to these coefficients, SideFac is the potential side vs center contribution.

I've used it to designate one of my DMs to CD duty, and found out who was best as striker for my team.

It is up to you how many coeffecients you want to extract. Those that are significantly lower than the ones above it could be excluded, but I am sure right now there are more coefficients that are almost as important as the 8 you have shared here?

Right now I am scoring the players on the coefficients for the positions you have extracted, but any coefficient can be incorporated in the spreadsheet.

I wonder if you could share the full lists of coefficients (not only the 8 most prominent ones). This way I can use them to make a squad analysis sheet using the coefficients to score your players for suitability on each of these positions.