In Excel, in 'Data'>'Queries and Connections', change the 'Source' to the .html-file exported through the view. Expand
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.
Mark said: For Importing select Data from Text, Select All file types, Select the File, Use "|" as qualifier. Should them align all the fields to columns. Hope this makes sense Expand
FREVKY said: That's what I thought, so I created pretty simple excel spreadsheet that make mass player comparison possible and easy.
Here's how it works: First, you need to import specified views. I created two sets of these: one for your team (for squad view) and one for scouting tab - both with CA & PA hidden - and another set with CA & PA visible for those who like to spoil the fun a little bit. Download and paste them into "views" folder in your Documents (C:\Users\your_name\Documents\Sports Interactive\Football Manager 2024\views is the default path).
When you load the view, you need to select every player, so click on one player and than ctrl+a to select everyone in the team or in the scouting range. Just bear in mind the more players you select, the more time it takes, so if you're about to select over 1000 players, give it a few seconds to work. Then, press cltr+p to "print" the selection into HTML file. Save it wherever you want, name it whatever you want. Then, you need the spreadsheet (MS Excel file). Open it and then in the Excel go to to File->Open and select the html file with your set of players. Copy it's whole contents (ctrl+a, then ctrl+c) and paste them into my spreadsheet in the blank sheet called "IMPORT" then switch the sheet to the one called "CALCULATION" and it should automatically calculate values for every player for each position using coefficients from this thread. Additionalli I added sections with CA, PA and difference between them (it will work only when you used views with PA and CA obviously).
Of course you can use whatever filters you want on the scouting section to narrow down the amount of players to whatever you really need.
At first glance it may sound complicated a bit but it's pretty easy to use. If you find any trouble using it, I'll try to help.
The spreadsheet is editable so do whatever you want with it, if you find any room for improvements, go for it. Expand
Can someone help me understand how to import the list of players into the excel file...? or is there a youtube tutorial for this ?
I downloaded the Excel file, and the 4 views, I go to FM, Squad tab of my team because I would like to analyze my squad first. I import the "Meta Own Team" view into FM, I select all the players and do CTRL P and text file.
This is the view I have in the IMPORT tab and I have nothing in CALCULATION, am I doing something wrong ?
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.
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?
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.
Hi,
in 'Data'>'Queries and Connections', how do you change the 'Source' to the .html-file ?
yes it works, tks !!
Here's how it works:
First, you need to import specified views. I created two sets of these: one for your team (for squad view) and one for scouting tab - both with CA & PA hidden - and another set with CA & PA visible for those who like to spoil the fun a little bit. Download and paste them into "views" folder in your Documents (C:\Users\your_name\Documents\Sports Interactive\Football Manager 2024\views is the default path).
When you load the view, you need to select every player, so click on one player and than ctrl+a to select everyone in the team or in the scouting range. Just bear in mind the more players you select, the more time it takes, so if you're about to select over 1000 players, give it a few seconds to work.
Then, press cltr+p to "print" the selection into HTML file. Save it wherever you want, name it whatever you want.
Then, you need the spreadsheet (MS Excel file). Open it and then in the Excel go to to File->Open and select the html file with your set of players. Copy it's whole contents (ctrl+a, then ctrl+c) and paste them into my spreadsheet in the blank sheet called "IMPORT" then switch the sheet to the one called "CALCULATION" and it should automatically calculate values for every player for each position using coefficients from this thread. Additionalli I added sections with CA, PA and difference between them (it will work only when you used views with PA and CA obviously).
Of course you can use whatever filters you want on the scouting section to narrow down the amount of players to whatever you really need.
At first glance it may sound complicated a bit but it's pretty easy to use. If you find any trouble using it, I'll try to help.
Spreadsheet link: https://www.mediafire.com/file/huj2qrmavoqnd6x/meta.xlsx/file
Updated spreadsheet including square root formula for M LR and ST: https://www.mediafire.com/file/j2rh3e6vk2hjw7i/meta.xlsx/file
The spreadsheet is editable so do whatever you want with it, if you find any room for improvements, go for it.
Can someone help me understand how to import the list of players into the excel file...?
or is there a youtube tutorial for this ?
I downloaded the Excel file, and the 4 views, I go to FM, Squad tab of my team because I would like to analyze my squad first.
I import the "Meta Own Team" view into FM, I select all the players and do CTRL P and text file.
This is the view I have in the IMPORT tab and I have nothing in CALCULATION, am I doing something wrong ?