[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 09/04/2024 at 16:22, TheProdigy2108 said:

Hey mate! hope you're well. I've downloaded the files/views and placed them in their folders but when I go to import them in game, the folders are empty. Any idea why?

Check private message 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 05/04/2024 at 21:28, SadBinder59 said:

I updated Excel and it still doesn't work... I am using version 2403 Microsoft Office Professional Plus 2019

Sorry to hear that you're still having problems using the spreadsheet. Unfortunately, I do not know how to fix this.

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

2 hours ago, SadBinder59 said:

For me everything works fine except the statistic profile and player profile screen.

Here is the dropbox link for my spreadsheet: https://www.dropbox.com/scl/fi/77ixstcbgj8prj68n0phk/Spielerauswahl_2024.xlsx?rlkey=i633fujwy9odfa7ab7qdllp1n&dl=0

i would be very happy if you can help me

Hi, I have had a look at your spreadsheet and it works perfectly fine for me. The problem might be because you need to use the latest version of Excel so you probably have to update your Excel. Let me know if this works 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

22 hours ago, milenec11 said:

nope the same at any skin 

Ah, have you tried clearing cache and reloading the skin then restarting the game?

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

7 hours ago, milenec11 said:

regardless i have choosen some in game data the game does not exported as suppose to do

any idea why

 

I think this might be due to the skin. My best solution is to clear cache, reload the skin and restart the game. 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 13/03/2024 at 13:56, Ti Ago said:

Full detail its mandatory ?

It is not mandatory but it is recommended if you want the statistics to be as accurate as possible

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

3 hours ago, Ti Ago said:

Hey 👋

Does this work with lower leagues ? Any league ? Or ONLY those top 5 and the other Next 5?

Yes, this should work with any league in the game provided there are statistics available for them.

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 10/03/2024 at 16:27, frogsplash said:

Hi mate

 

First of all on behalf of everyone can i say what a great bit of work this is

 

It seems to be working fine for me apart from goalkeepers

 

In the attached excel sheet the goalkeepers stats are their in the paste here tab, but they appear as zeros in both the raw data and percentiles tab - only save percentage works

 

I have added in a column instead of clearances as the view didn't match the excel spreadsheet but the goalkeeper stats seem to be the only ones affected

 

Sorry if i am doing something stupid and thanks again for the effort

 

FM24 FMSS Statistics Spreadsheet v2.xlsx

Untitled.html 3.14 MB · 1 download

Hi mate, I have had a look at this and there is not a problem in the formulas of my spreadsheet. It could possibly be due to your thousands and decimals separators in your FM or Excel settings or maybe you have accidentally tampered with the formulas by adding in a column. Maybe download a fresh copy of the spreadsheet or follow the instructions below.

Follow these steps:

1) Click File > Options

2) Go to the Advanced tab and uncheck Use system separators

3) You should set the decimal and thousands separator to match with the ones in your FM23 settings

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

18 hours ago, Bahnzo said:

Thanks for the work and sharing this. It might be helpful to specify here that depending on your settings, this might be something different. Instead of "km", I have "mi". Took a bit to figure that out, so could be helpful to others to mention that. 

 

Thanks again!

Thanks a lot, I have updated this now 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 17/02/2024 at 10:53, Lazija1389 said:

I did manage to fix it in Excel files when I was change coma to dot it somehow changed it to 0, but thanks anyway. And thanks for puting your time and effort in making something like this uts great

I'm glad it's now working for you. Thank you for the feedback, it's very much appreciated 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

2 hours ago, Lazija1389 said:

How do I fix this type of numbers and my average ratings are dates for example 7, july etc.

Can you please send the excel file?

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

16 hours ago, Sortibak said:

This happens when I try to import the view, its the same in scouting. Anyone has any idea why?

You have used the incorrect views. You have to use the view FM24 'FMSS Squad View' for the spreadsheet to work.

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 02/02/2024 at 10:54, James8973 said:

Hey mate. When loading players into the spreadsheet. Is there a maximum number of players before it can't handle it.

Also, have black boxes for almost everyone under line 104. Also from that line player names are "0" Any reason why? Happy to send the file. Only issue I can't attach the file due to its size

Hi, the maximum number of players it can handle is supposed to be 2000. Can you send your Excel file so I can see where the problem is?

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

18 hours ago, oliverbrowne626 said:

Hi, great spreadsheet it works great, all the data is filled in perfectly, but the coloring / formatting of the data inst working, so I cant view whether the players are better or worse unless i look through each cell, do you know why this could be ? Thanks. 

@oliverbrowne626 Hi, can you send the excel file?

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

16 hours ago, elfleo said:

Hi everyone, just a quick question, maybe someone can help: When printing the data as a web page, some data are entirely missing on the web page. I have several columns missing entirely that are used in the Excel sheet and therefore the copied data into the Excel sheet do not match at all. If I copy all the data from the web page the Excel sheet has only data until the column "DO", while the spreadsheet ends at column "EZ". And because of that the imported data do not match. Seems like while printing the data as web page some data are missing, although I use the filter and more importantly the "FM24 FM"" Player Search View" view. Any idea maybe?

I think the steps below might help you

On 19/11/2023 at 17:07, Fmplaya said:

2)  Select all players by left clicking and dragging it all the way down to the last player. Then scroll all the way up to the top player without deselecting any players.

3)  Press CTRL+P on your keyboard and print it as a web page. Save the name as you would like.

 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 23/01/2024 at 20:08, Shaun Howard said:

When i do the spreadsheet, for some reason all the per/90 stats are all blacked out and not showing. What is going wrong?

Are you using the latest version of Excel?

21 hours ago, ceefax the cat said:

It'd be really helpful to have a list of season end dates by country for this, so you can look at data from past seasons. It's pretty annoying that FM scrubs all stats at the end of each season and makes it impossible to scout by performance.

Even with a list of season end dates, you're looking at exporting from FM quite a few times each season to get complete data. Madness

Yeah I completely agree, it is very frustrating having to flick through multiple Excel sheets to keep a record of player data when it can be done by the game.

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

On 12/01/2024 at 21:45, KellettAKill said:

Hi! If i want to sort the columns, it doesn't let me because it says it's a locked column. What's the fix for this?

Hi! Thanks for pointing that out, I hadn't realised I had forgotten to unlock those columns. I have posted a link for the updated version of the spreadsheet which allows you to sort the tables.

https://www.mediafire.com/file/rtaxuq2x2k1xhjw/FM24_FMSS_Spreadsheet_v2.zip/file

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

23 hours ago, gpassosbh said:

Hello @Fmplaya,

I tried to import the data from my save, but I don't know what I do wrong. Can you tell me why Raw Table isn't showing all the data?

Thanks

FM24 FMSS Statistics Spreadsheet.zip 4.83 MB · 0 downloads

Hi, the problem is that the minutes column uses a point instead of a comma for the thousands separator.

On 19/11/2023 at 17:07, Fmplaya said:

Follow these steps:

1) Click File > Options

2) Go to the Advanced tab and uncheck Use system separators

3) You should set the decimal and thousands separator to match with the ones in your FM23 settings

If that doesn't work, you can select the whole column AP and press CTRL + H, and replace the dot with a comma.

[Statistics Spreadsheet (For those that love Moneyball)]

1 hour ago, Craigoh1 said:

brilliant. Are you by any chance an analytics professional?

Unfortunately I am not an analytics professional, I am just a busy university student . All the knowledge that I have gained in analytics and creating data visualisation was from using ideas from others such as @MattyLewis11 and self-experimentation .

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

2 hours ago, Craigoh1 said:

This is brilliant. I've been wanting to get my toes wet in exporting data from FM and play around in excel and tableau. You have a made a perfect little tool for me to dig straight away. Thanks!

Thank you very much, I hope you enjoy using it!

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

1 minute ago, BL1TZ_GT said:

Yeah it was my version. Upgraded from 2016 to 2021 & it now works in 2021. Cheers for fixing it.

Ah, that's brilliant and I'm glad it's working now 

 

@Jacob Palsgaard Looks like you may need to upgrade your version of Excel 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

1 hour ago, Jacob Palsgaard said:

Thanks @Fmplaya, that did it

Only thing missing now is that I can´t get any data on player profiles or statistics profile even though I am using the drop down menu with player names. Do you have any clue why ?

And thanks for a really nice tool that adds value to the game!  
 

Thank you and no problem! 

That is really weird as @BL1TZ_GT has had the same problem and I tried it with his Excel sheet and had no problems. This could possibly be due to the version of Excel you are using?

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

5 minutes ago, Jacob Palsgaard said:

Hi FmPlaya, 

I have really tried to make this spreadsheet work, but I can´t seem to get it right. I have been following your steps, but when I enter the Raw data table the values does not seem right? 

Hi, This could be an issue with your thousands and decimal separators not being the same as the ones used in FM.  The steps below should help.

On 19/11/2023 at 17:07, Fmplaya said:

For those of you who use languages different to English, it is important to ensure that your thousands and decimal separators are set correctly on Excel as this can issues with the spreadsheet

Follow these steps:

1) Click File > Options

2) Go to the Advanced tab and uncheck Use system separators

3) You should set the decimal and thousands separator to match with the ones in your FM23 settings

 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

39 minutes ago, BL1TZ_GT said:

Yeah, I click the drop down arrow, get a bunch of zero's, scroll up to the names click 1 & then blank.

But if works for you so it's something to do with my excel I guess, so I'll figure that out. Thanks for your help though.

It could also be due to having an older version of Excel? And no problem mate 

[FM24 Statistics Spreadsheet (For those that love Moneyball)]

1 hour ago, BL1TZ_GT said:

Yeah no bother. I have sent the original final, also sent the file with my squad pasted into it.

FM24 FMSS Statistics Spreadsheet - With My Squad.zip 4.82 MB · 0 downloads FM24 FMSS Statistics Spreadsheet.zip 4.73 MB · 0 downloads

I have had a look and it works completely fine for me.

 

 

Have you made sure to select the player from the dropdown list instead of just typing their name?