This is such a nice corner of the FM community, genuinely. In my opinion there's a lot of toxicity around at the minute, any discussion about tactics or players on Reddit is overrun with boring min-maxers yelling about how all you need is fast players, the match engine is broken, it isn't like real football at all, 4-2-3-1 gegenpress, blah blah. This style of playing the game that you've enabled with the skin and with all these incredible videos just removes all that and makes Football Manager about *football* again, not meta gaming.
It's easy to forget that it's a game, and by the very inherent nature of programming, there will always be a "meta". I've always found it odd, however, to chase such a thing. Games are about stories and ideas, and Football Manager allows you to explore both!
I agree Charles. I love this game and I’m always challenging myself with new experiments, new tactic, new data, etc. Content like this is quite inspiring!
Definitely one of the hardest ones to write. FM is my realm. I (sort of) know what I'm doing there. Google Sheets/Excel, not so much. I have a strong enough knowledge to use it, but guiding through it is much scarier!!!
Why am i even watching this? I suck at maths and numbers 😂 my eyes glazed over halfway through, thank god you have a pleasing voice. All joking aside its nice to see another way of fm play rather than the usual. Kudos!
That was so professional! And so advanced! I did experiment with some vlook ups last year (for FM of course) and I was exhausted. So, I stuck with the basics! But you are on another level! Thanks for that! Looking forward for more!
I'm not joking when I say I hate spreadsheets. They are exhausting, but mastering a few formula (or searching Google for something similar, then stealing it), they can be super helpful.
Thank you so much for this! I was waiting for this video to come out! Thank you once again, for showing me another way of playing FM and having so much fun! You’re content is amazing and I just to see more and more!
you are my fav fm content creator and you have transformed how i and many others play this game, give yourself a pat on the back and know that your recognition will come soon 🍺
Hey mate! Stumbled across this and it blew my mind. I’ve always wanted to incorporate data into how I play, so finding this was perfect. Following your video closely... so very closely (I havent used excel in 7+ years) I'm going to try my hand at making spreadsheets for fullbacks, mids, wingers etc. You've earned a new subscriber today, my friend 😊
Welcome aboard, dude!! One of the truly glorious things about Excel (and it's various clones) is that it probably hasn't changed much since you last used it! As mentioned at the top, I have a love-hate relationship with spreadsheets, and I can only apologise now if I've got you back into that murky world 🤣
I did my own excel sheet for your skin, so that i dont have to set up a specific one everytime i look for a player. It is maybe a bit more unspecific, as i use presets for each position. But i can weigh each critearia diffrently, so that I will get a ranked list depending on how good all the criteria are met for each player. Also I am still working on a sheet to compare players to each other or my own players. Anyway thank you for your good videos and the skin. It makes the game much more interesting for me :)
Hey Mustermann, love this. Sent an email through to you the other day. I’ve got a spreadsheet that’s scores players and compares between leagues. Would be great to show you how it works. Think it would really help the community in playing with data … but easily. Cheers, Ben
I don't know if you remember my comment from earlier about a league weighting to compare players between competition levels, based on FMs reputation scores. I have developed it further, and have a first draft of a video explaining how it's made and how to make use of it, if you are interested in learning about it. I can also share the document with weightings if you like (weightings adjust according to which league you are in). Btw, it's possible to use Excel to scan the possession table as a picture, which subsequently turns this into raw text in the spreasheet and ordered in cells as a proper table. Love your vids as always
I've found OCR readers to be unreliable with FM. Not awful, but not 100% - meaning I'm then having to double check and validate anyway, at that point I might as well just do it manually 😂 The weighting stuff does sound interesting!!
@@mustermannfm Don't know why, but I just knew you did it like that because of its tiny inaccuracy 😆Just hit me up if you want to see the document, I have adjusted it for CA now.
@@TheKvezh it would be fine for the example here where it's very few leagues. Probably easy to spot an error and correct. Had it been a shortlist of 14,000 players, I might not find the errors. There's also a good chance that I give up with possession-adjustments entirely to be fair. I think 12 leagues is my sanity breaking point 🤣
A tip to export the data for possession adjusted metrics is to use Power Toys (free utility software) which has an OCR function. You can take a screenshot of the in-game table with the data and convert it to a text format. Using higher scaling could improve accuracy of the OCR.
I've found OCR readers to be unreliable with FM. Not awful, but not 100% - meaning I'm then having to double check and validate anyway, at that point I might as well just do it manually 😂 In fact, a couple of years ago I was specifically trying to see if it was possible to design a skin that would make the game playable for those who are blind. Unfortunately it was too big a project to do!
@@mustermannfm OCR has improved at least slightly over the last couple of years, it also depends on the implementation. Haven't tested it yet on FM, but i've had quite good results in other scenarios, the more pixels you give it the better results it should produce also the constrast between the text you are interesed and the background also needs to be quite clear to improve results.
Amazing video! I’m definitely going to start a new non-attribute video and use your spreadsheet methodology for it. It’s like combining two passions into one: FM and Excel. 😅
Generally Excel/Sheets will have popup guides when you start entering formula which can help with syntax (the exact formats can change from country to country). I am no expert in this area, and if you're struggling, I would recommend ChatGPT or something similar to guide through any possible differences from what I've supplied.
Hi mate, I absolutely love this!! It's gonna create a whole new way to play to play FM, and I'm so excited to actually try it. I've tried to replicate your spreadsheet for myself, but stumbled into an issue. I try to compare players by a chosen set of metrics, like shown in the video. But despite using the numbers for one of the players in the Data-sheet, and selecting the rows from the data sheet and the comparison-sheet, I get an error-message telling me that no matches has been found, not even the player I've copied the stats from. I've also tried to set "matches" and "percentage" to 0, without luck. As it's my first time really trying to use a spreadsheet like this, I don't know what I'm doing wrong. Maybe someone knows where I'm going wrong? Because I can't wait to try this for myself!! Note: I've decided not to use the PAM-part, nor the transfer value, to make it all a little easier for myself. Here's the formula I've used, maybe someone can spot what's wrong? =FILTER(Data!A:V; (Data!E:E=K8*B3) + (Data!M:M>=M8*B3) + (Data!O:O>=O8*B3) + (Data!Q:Q>=Q8*B3) + (Data!R:R>=R8*B3)) >= B2)
That all looks fine assuming that without the transfer values those columns match up across the two sheets (e.g. the heading for column K is the same in the Comparison sheet as it is in the Data sheet). If not, you just need to align those accordingly, so if Clr/90 is column K in the Comparison sheet and column J in the Data sheet, then the formula for that little section would be: (Data!J:J=K8*B3) Otherwise the only thing I can see is the semicolon (;) in the filter. I believe this is commonplace in a lot of European countries, but in the UK we use a comma (,). Maybe worth checking the language settings (File -> Settings) in case this might be the cause.
@@mustermannfm Thanks for helping, changing the language was all that was needed. Again, I love this, brilliant work, can't wait to see how this will impact my scouting.
They're annoyingly inconsistent. You hear the same songs on different videos and they're all a slightly different arrangement and length. Just stick to your job!
If you wish to disable player search, you need to edit Mustermann Iconic/sections/sidebar sections.xml, line 487: This needs to be changed to: You'll then need to save the file, reload the skin with caching off. If you also want to disable staff search, that is line 709: This needs to be changed to:
Absolute banger, any chance you could share how to set up a save because I played my first season and then realised I didn’t make the leagues playable so stats aren’t pulling correctly :/ either way this moneyball style has re ignited my love of the game
@@mustermannfm hero mate thank you! Probably more what my computer can handle haha! Is there a version of your skin where you have attributes visible? I want a mix of the two :) if not I’ll take the no attribute plunge again much like you said on the podcast haha
@@TN34RY I'm afraid it's attributeless only. Well pseudo-attributeless, you still have a vague idea!! If you're more interested in things like the Pizza Charts instead of the overall aesthetics, then I gave WTCS and Electric Panther skins permission to include them, and I think they've done a great job of incorporating them in a way that fits their skin overall.
@@mustermannfm brill thanks man! I’ll give yours a go, just need to keep watching and learning what to look at, atm I’m like ahh that’s so cool but no knowledge of how to apply it to my own saves haha While you’re here, just thanks for the content man, you’re smashing it
@@TN34RY If you watch football, you know how to apply it. Just break it down by individual positions and phases of play. What should they do in possession? What should they do out of possession? Where are they in transition and how can they contribute? It all flows from there.
This is fantastic. Like an excel class as well. Speaking of Excel. I can't for the life of me get the transfer value thing working. I have replaced all of the *CELL* with I2. Is there a further step I haven't done? Do I need to paste it somewhere? Do I need to add equals? I am so confused
You will need to add "=" in front to make it a formula. There may also be some syntax differences between Excel and Google Sheets. If that is the case, unfortunately I can't help, as I don't have Excel to check.
@@mustermannfm I am so lost with this one, can't make it work. After replacing every *CELL* WITH I2 in the formula, do I go back to DATA and click on I2, type= then ctrl+v the formula?? Am I doing something wrong?
@@EdenQQQ if the value you are trying to convert is in cell I2, then create a new column to the right of it, paste the formula into J2, put "=" in front of the formula, change all instances of *CELL* to I2, press return. Copy the formula down the column.
I love this concept and your analytics in general, but at the end of the day since it’s a game with hard-coded player stats, wouldn’t the attributes be more telling than the stats of a player from the past season? Since their attributes are their attributes but but their performance stats are influenced by their team and such?
Attributes might tell you what they could potentially be capable of, with interdependency between them, influence from hidden stats and an element of RNG added in. Stats tell you what they are actually capable of. They will always be influenced by team tactics to some extent, but you can identify those who stand out relatively easily.
@@mustermannfm that makes sense. Just feels scary to go off of their season stats instead of attributes and stressing over 16 vs 17 finishing, but I’m going to try it your way + with your skin so I don’t have to get too caught up in the numbers. I see what it does for the realism, it’s not like we know irl whether isak is a 16 vs 17 finishing
@@Flexium_GG moreover, finishing does not happen in isolation. Getting into the right positions requires anticipating the pass, moving into the right space, speed to separate from the defender, decision making to make the right move, technique to strike the ball cleanly, composure, bravery and balance to not be put off by the defender, etc... Looking at shots (evidence of getting into shooting positions), xG (evidence of the quality of those shooting positions), and shot accuracy and xG over performance (evidence of finishing ability) is actually a lot easier.
@@Flexium_GG no it's not publically available as it breaks other areas in the game. But I spent a lot of time working on it, so I'm gonna find a way to shoehorn it in whenever I can 😂 Also, no I play all games. With the exception of the Moneyball Clinic series where I set the lineup and use Instant Result. The latter is only for TH-cam, I don't do it for any of my actual saves (as the best way to learn about what your players are doing is to watch them on the pitch)
Hey mate love the content. Im struggling to get the transfer value formula to work. I am a bit of a newb when it comes to excel/sheets. It possible to make a short video explaining on how to do it on google sheets? Thanks legend
"I am not particularly good at explaining the nuance of regular expression, so I’ll include the formula in the comments below and will be shared in the sheet itself." If you're not familiar with excel/sheets, I would recommend skipping this step.
@@mustermannfm I think just telling us where to paste is what he's after. Knowing the formula is all well and good but you don't tell us where to paste it
I don't use tableau, so unfortunately not. With regards to Looker Studio, which I do use, my position is still the same - there are YT videos out there by people considerably more familiar with the tool than me.
@@eugenetakyi-micah1420 A bit like the opening to the last Zaragoza video about the Dunning-Kruger effect; it's important to acknowledge where my knowledge is limited and not pretend I am an expert. I can use Looker Studio, but I am in no way informed enough about it to give advice. In fact, I am likely to give bad advice because I don't know better!
Hey, first of all forgive me if it appears that im stalking you across multiple videos. I mean, I am doing that but im still sorry about it. Anyway, in the above video you mention that you shouldn't compare the stats from leagues with full detail to leagues with Match Data set to None (lets call this Simulated Data) I understand why that is, but im wondering if it is ok to compare Simulated Data to itself? I have a bunch of leagues loaded but all of them have their Detail Level set to None. Im quite far into the save so dont want to lose it but also would love to try the methods you've laid out above. thanks as always and keep up the great content.
So let me get this straight, if we copy-paste the whole Google spreadsheet into a new one and then add our own details from the game, will we be able to use it also?
I've been meaning to figure out how to use spreadsheets. I always hear people talking about using them, but I've never used them myself. I think I'm going to from now on Will this work exactly the same in Excel?
The good news is before the formulas start, I say: "this is perfectly fine, we can work with the data as it is now, if we wanted to". At that point you have a spreadsheet with exported data that you can use however you want (simple filters, for example). And then, when you're feeling brave, you can come back and try the additional bits!!
If you wish to disable player search, you need to edit Mustermann Iconic/sections/sidebar sections.xml, line 487: This needs to be changed to: You'll then need to save the file, reload the skin with caching off. If you also want to disable staff search, that is line 709: This needs to be changed to:
I’m trying to copy the formula into Sheets, I’ve read the comment where you suggested creating another column to the right. I pasted the Formula in the new J2, used CTRL+H and replaced “CELL” with I2. Also ticked search within formulas and it still doesn’t work. Can anyone help please
@@harryyes1527 no, attribute masking is on, meaning I need to scout players for the ranges to be accurate. Until then, the estimates will be at the top of the range. E.g. if the scout says the attribute is 9-17, it will show the player to be Excellent (16-20) until he's been scouted and the actual value is revealed.
@@mustermannfm Thanks I will have a look. My other question was, is there a way so I can see the league reputation list on the league overview page like in the original skin?
I'm afraid not. Or at least not in a convenient manner. You can calculate it yourself, by exporting stats from the squad view after every game, and then subtracting the previous entry from the current one, but that is laborious and means you need to remember!
@@mustermannfmI get this: there’s a problem with this formula. Not trying to type a formula? When the first character is an equal(‘=‘) or minus(‘-‘) sign, Excel thinks its a formula: *you type =1+1, cell shows: 2 to get around this, type an apostrophe(‘) first: * you type ‘=1+1, cell shows: = 1+1. It works on the google spreadsheets. But when the Val is 1,5 mil 1 comes out of it from the formula
1,5m? It may well be possible that you would need to change the regextract in that case. In the UK, the format is 1.5m - with a full stop rather than a comma.
You apply the same principles. What do you require a player to do in each role in your tactic. What are they doing in possession? What are they doing out of possession? Where are they on the pitch when you are in transition and how can they contribute?
@@Georgewestron. Pretty much. If you have a lot of results, refine the criteria further. Maybe the player you're comparing them to is rubbish, so increase the percentage above 100%. Or maybe there's a specific metric you want to prioritise, so use a raw number as the filter rather than comparing to the incumbent. There is no hard and fast answer here. It's all about your tactic, your squad and the needs therein.
@@Georgewestron. Yes, you should. As mentioned in the video - I don't provide templates, because you should always be focussing on what is appropriate to your needs at that moment. What you need from a BPD in a 4-3-3 might be different to what I need from a BPD in a 3-4-1-2. What I need from a BPD in a 3-4-1-2 for Zaragoza is likely to even be different from what I need from a BPD in a 3-4-2-1 for Sevilla.
You paste it wherever you decide you want your calculated value column to be. That depends entirely on your data set and your decision as to where that column is.
There isn't an updated formula, I'm afraid, no. In fact this is the same formula I've used with FM for about 3 years. As it uses regextract to identify the final value (whether it is in a range, or just singular) and then the unit to work out what to multiply by, it shouldn't ever be able to return a mid value. It may have issues with non-English number formats (for example, if in a language that doesn't use m for millions), which would then return an error.
CTRL + V. CTRL + V. CTRL + V. You use CTRL + V to paste, not CTRL + P. I'm an idiot.
This is such a nice corner of the FM community, genuinely. In my opinion there's a lot of toxicity around at the minute, any discussion about tactics or players on Reddit is overrun with boring min-maxers yelling about how all you need is fast players, the match engine is broken, it isn't like real football at all, 4-2-3-1 gegenpress, blah blah. This style of playing the game that you've enabled with the skin and with all these incredible videos just removes all that and makes Football Manager about *football* again, not meta gaming.
It's easy to forget that it's a game, and by the very inherent nature of programming, there will always be a "meta". I've always found it odd, however, to chase such a thing. Games are about stories and ideas, and Football Manager allows you to explore both!
I agree Charles. I love this game and I’m always challenging myself with new experiments, new tactic, new data, etc. Content like this is quite inspiring!
To take something so data heavy and explain it in such a clear and consise way takes some doing! Another exceptional video, my man!
Definitely one of the hardest ones to write. FM is my realm. I (sort of) know what I'm doing there. Google Sheets/Excel, not so much. I have a strong enough knowledge to use it, but guiding through it is much scarier!!!
Why am i even watching this? I suck at maths and numbers 😂 my eyes glazed over halfway through, thank god you have a pleasing voice.
All joking aside its nice to see another way of fm play rather than the usual. Kudos!
My eyes glazed over too, that's why it took an extra 2 weeks to do 😂
His voice is indeed pleasing. 😅
I cant watch this until after work, but I already know this is going to be fantastic, because of course it is. It's Mustermann
Hopefully it's worth the wait!!
That was so professional! And so advanced! I did experiment with some vlook ups last year (for FM of course) and I was exhausted. So, I stuck with the basics! But you are on another level! Thanks for that! Looking forward for more!
I'm not joking when I say I hate spreadsheets. They are exhausting, but mastering a few formula (or searching Google for something similar, then stealing it), they can be super helpful.
I consider myself decent with Spreadsheets, but this is another level. Love it!
I always find myself waiting for Fridays, these videos are amazing
Hopefully this will start the weekend right!!
Thank you so much for this! I was waiting for this video to come out! Thank you once again, for showing me another way of playing FM and having so much fun! You’re content is amazing and I just to see more and more!
Glad you enjoyed it, dude!
You are a gold mine for all FM players ! the way how you play this game its so realistic and we love it man !!! thank you for all your work !
Glad you enjoyed it! Thank you, dude!
This is insane attention to detail
Thank you, dude!
you are my fav fm content creator and you have transformed how i and many others play this game, give yourself a pat on the back and know that your recognition will come soon 🍺
Thank you, dude!
Hey mate! Stumbled across this and it blew my mind. I’ve always wanted to incorporate data into how I play, so finding this was perfect. Following your video closely... so very closely (I havent used excel in 7+ years) I'm going to try my hand at making spreadsheets for fullbacks, mids, wingers etc. You've earned a new subscriber today, my friend 😊
Welcome aboard, dude!!
One of the truly glorious things about Excel (and it's various clones) is that it probably hasn't changed much since you last used it! As mentioned at the top, I have a love-hate relationship with spreadsheets, and I can only apologise now if I've got you back into that murky world 🤣
My fav FM channel right now, keep up the great work
Thank you, dude!
Saw your post about the algorithm not liking this upload
Exact reason I went to seek it out, always want to hear new unique views
Oh, that's very kind, thank you! Hopefully it was worth it!
Mustermann School of Football Manager Stats 🙌🏿🙌🏿
I know I are tired of hearing this from me but u are so good at this.
I will always appreciate it 🙏, thank you, dude!!
There it is. The perfect video. Many thanks Mustermann! 👏🏽
Glad you enjoyed it, dude!
Great video!
...and I see some formulas which will even benefit me at work!
Ironically it's the other way around for me. I learn something for work and think "ooo, formulas I can use for FM" 🤣
This is brilliant! Thank you so much for sharing all this. ❤
Thank you, dude! Glad you enjoyed it!
Always excited to see a new Munstermann video! Keep up the good work ❤️
Cheers, dude 🙏
i love you so much, thank you Professor Mustermann
You rock!
This is incredible content.
Thank you, dude!
This is the most useful video on the internet. 👍
Glad to hear it's been useful!!
I did my own excel sheet for your skin, so that i dont have to set up a specific one everytime i look for a player.
It is maybe a bit more unspecific, as i use presets for each position. But i can weigh each critearia diffrently, so that I will get a ranked list depending on how good all the criteria are met for each player. Also I am still working on a sheet to compare players to each other or my own players.
Anyway thank you for your good videos and the skin. It makes the game much more interesting for me :)
Great to hear. It's always nice when you find a system that works for you!
I also do hate spreadsheets but look...this is incredibly useful and thank you for your sacrifice.
There's no denying their utility, but I've spent far too much of my adult life looking at them!
@@mustermannfm YES, THAT! After a certain point, you just want the agony to end!
@@BrasilianFury that certain point is usually only 5 minutes in!!
Hey Mustermann, love this. Sent an email through to you the other day. I’ve got a spreadsheet that’s scores players and compares between leagues. Would be great to show you how it works. Think it would really help the community in playing with data … but easily. Cheers, Ben
Not saying yours isn’t easy. But as a complete tool myself it’s pretty straight forward 😅
I should probably check my emails!!!
Thanks for all the effort you put in. Top man👍
Cheers, dude!!
I don't know if you remember my comment from earlier about a league weighting to compare players between competition levels, based on FMs reputation scores. I have developed it further, and have a first draft of a video explaining how it's made and how to make use of it, if you are interested in learning about it. I can also share the document with weightings if you like (weightings adjust according to which league you are in). Btw, it's possible to use Excel to scan the possession table as a picture, which subsequently turns this into raw text in the spreasheet and ordered in cells as a proper table. Love your vids as always
I've found OCR readers to be unreliable with FM. Not awful, but not 100% - meaning I'm then having to double check and validate anyway, at that point I might as well just do it manually 😂
The weighting stuff does sound interesting!!
@@mustermannfm Don't know why, but I just knew you did it like that because of its tiny inaccuracy 😆Just hit me up if you want to see the document, I have adjusted it for CA now.
@@TheKvezh it would be fine for the example here where it's very few leagues. Probably easy to spot an error and correct. Had it been a shortlist of 14,000 players, I might not find the errors. There's also a good chance that I give up with possession-adjustments entirely to be fair. I think 12 leagues is my sanity breaking point 🤣
A tip to export the data for possession adjusted metrics is to use Power Toys (free utility software) which has an OCR function. You can take a screenshot of the in-game table with the data and convert it to a text format. Using higher scaling could improve accuracy of the OCR.
I've found OCR readers to be unreliable with FM. Not awful, but not 100% - meaning I'm then having to double check and validate anyway, at that point I might as well just do it manually 😂
In fact, a couple of years ago I was specifically trying to see if it was possible to design a skin that would make the game playable for those who are blind. Unfortunately it was too big a project to do!
@@mustermannfm OCR has improved at least slightly over the last couple of years, it also depends on the implementation. Haven't tested it yet on FM, but i've had quite good results in other scenarios, the more pixels you give it the better results it should produce also the constrast between the text you are interesed and the background also needs to be quite clear to improve results.
Amazing video! I’m definitely going to start a new non-attribute video and use your spreadsheet methodology for it. It’s like combining two passions into one: FM and Excel. 😅
There's no escaping the claims that Football Manager is actually "Spreadsheet Manager"
Great video!
Welcome to the Football Manager Academy ....
Nerds assemble!!
@@mustermannfm
😁😁
How do you make all the coding expressions work on Excel/Sheets? incredible video by the way, by far my favourite.
Generally Excel/Sheets will have popup guides when you start entering formula which can help with syntax (the exact formats can change from country to country). I am no expert in this area, and if you're struggling, I would recommend ChatGPT or something similar to guide through any possible differences from what I've supplied.
Hi mate, I absolutely love this!! It's gonna create a whole new way to play to play FM, and I'm so excited to actually try it.
I've tried to replicate your spreadsheet for myself, but stumbled into an issue. I try to compare players by a chosen set of metrics, like shown in the video. But despite using the numbers for one of the players in the Data-sheet, and selecting the rows from the data sheet and the comparison-sheet, I get an error-message telling me that no matches has been found, not even the player I've copied the stats from. I've also tried to set "matches" and "percentage" to 0, without luck.
As it's my first time really trying to use a spreadsheet like this, I don't know what I'm doing wrong. Maybe someone knows where I'm going wrong? Because I can't wait to try this for myself!!
Note: I've decided not to use the PAM-part, nor the transfer value, to make it all a little easier for myself. Here's the formula I've used, maybe someone can spot what's wrong?
=FILTER(Data!A:V;
(Data!E:E=K8*B3) + (Data!M:M>=M8*B3) + (Data!O:O>=O8*B3) + (Data!Q:Q>=Q8*B3) + (Data!R:R>=R8*B3)) >= B2)
That all looks fine assuming that without the transfer values those columns match up across the two sheets (e.g. the heading for column K is the same in the Comparison sheet as it is in the Data sheet). If not, you just need to align those accordingly, so if Clr/90 is column K in the Comparison sheet and column J in the Data sheet, then the formula for that little section would be:
(Data!J:J=K8*B3)
Otherwise the only thing I can see is the semicolon (;) in the filter. I believe this is commonplace in a lot of European countries, but in the UK we use a comma (,). Maybe worth checking the language settings (File -> Settings) in case this might be the cause.
@@mustermannfm Thanks for helping, changing the language was all that was needed. Again, I love this, brilliant work, can't wait to see how this will impact my scouting.
Musterband, my fav band
They're annoyingly inconsistent. You hear the same songs on different videos and they're all a slightly different arrangement and length. Just stick to your job!
Hey man, enjoying the vids ! While explaining Real Zaragoza save you mentioned the disabled player search, how can I disable it for myself ?
If you wish to disable player search, you need to edit Mustermann Iconic/sections/sidebar sections.xml, line 487:
This needs to be changed to:
You'll then need to save the file, reload the skin with caching off.
If you also want to disable staff search, that is line 709:
This needs to be changed to:
@@mustermannfm Thanks ! Managed to make it work.
I kinda love you man
Spreadsheets do funny things to people!
yoooohooo almost 18 min of joy. gimme that
Spreadsheet nerds assemble!
Absolute banger, any chance you could share how to set up a save because I played my first season and then realised I didn’t make the leagues playable so stats aren’t pulling correctly :/ either way this moneyball style has re ignited my love of the game
Thank you, dude!
Setup is going to depend entirely on your preferences. What I do is covered here: th-cam.com/video/f-H4GfG9mH0/w-d-xo.html
@@mustermannfm hero mate thank you! Probably more what my computer can handle haha! Is there a version of your skin where you have attributes visible? I want a mix of the two :) if not I’ll take the no attribute plunge again much like you said on the podcast haha
@@TN34RY I'm afraid it's attributeless only. Well pseudo-attributeless, you still have a vague idea!!
If you're more interested in things like the Pizza Charts instead of the overall aesthetics, then I gave WTCS and Electric Panther skins permission to include them, and I think they've done a great job of incorporating them in a way that fits their skin overall.
@@mustermannfm brill thanks man! I’ll give yours a go, just need to keep watching and learning what to look at, atm I’m like ahh that’s so cool but no knowledge of how to apply it to my own saves haha
While you’re here, just thanks for the content man, you’re smashing it
@@TN34RY If you watch football, you know how to apply it.
Just break it down by individual positions and phases of play. What should they do in possession? What should they do out of possession? Where are they in transition and how can they contribute?
It all flows from there.
This is fantastic. Like an excel class as well.
Speaking of Excel. I can't for the life of me get the transfer value thing working. I have replaced all of the *CELL* with I2. Is there a further step I haven't done? Do I need to paste it somewhere? Do I need to add equals? I am so confused
You will need to add "=" in front to make it a formula. There may also be some syntax differences between Excel and Google Sheets. If that is the case, unfortunately I can't help, as I don't have Excel to check.
@@mustermannfm I made it work. Pasted it into the column beside the data and then pasted the values back into the transfer value column.
@@jonathanconn214 Glad you got it working!
@@mustermannfm I am so lost with this one, can't make it work. After replacing every *CELL* WITH I2 in the formula, do I go back to DATA and click on I2, type= then ctrl+v the formula?? Am I doing something wrong?
@@EdenQQQ if the value you are trying to convert is in cell I2, then create a new column to the right of it, paste the formula into J2, put "=" in front of the formula, change all instances of *CELL* to I2, press return. Copy the formula down the column.
I love this concept and your analytics in general, but at the end of the day since it’s a game with hard-coded player stats, wouldn’t the attributes be more telling than the stats of a player from the past season? Since their attributes are their attributes but but their performance stats are influenced by their team and such?
Attributes might tell you what they could potentially be capable of, with interdependency between them, influence from hidden stats and an element of RNG added in.
Stats tell you what they are actually capable of. They will always be influenced by team tactics to some extent, but you can identify those who stand out relatively easily.
@@mustermannfm that makes sense. Just feels scary to go off of their season stats instead of attributes and stressing over 16 vs 17 finishing, but I’m going to try it your way + with your skin so I don’t have to get too caught up in the numbers. I see what it does for the realism, it’s not like we know irl whether isak is a 16 vs 17 finishing
@@Flexium_GG moreover, finishing does not happen in isolation. Getting into the right positions requires anticipating the pass, moving into the right space, speed to separate from the defender, decision making to make the right move, technique to strike the ball cleanly, composure, bravery and balance to not be put off by the defender, etc...
Looking at shots (evidence of getting into shooting positions), xG (evidence of the quality of those shooting positions), and shot accuracy and xG over performance (evidence of finishing ability) is actually a lot easier.
Also is that view you have to compare pizza charts of multiple players at a time still not available for public? Looks like an immensely useful view!
@@Flexium_GG no it's not publically available as it breaks other areas in the game. But I spent a lot of time working on it, so I'm gonna find a way to shoehorn it in whenever I can 😂
Also, no I play all games. With the exception of the Moneyball Clinic series where I set the lineup and use Instant Result. The latter is only for TH-cam, I don't do it for any of my actual saves (as the best way to learn about what your players are doing is to watch them on the pitch)
Ooh should be a good one!
Hopefully. A little nervous about this one; probably the toughest to write/co-ordinate.
Hey mate love the content. Im struggling to get the transfer value formula to work. I am a bit of a newb when it comes to excel/sheets. It possible to make a short video explaining on how to do it on google sheets? Thanks legend
"I am not particularly good at explaining the nuance of regular expression, so I’ll include the formula in the comments below and will be shared in the sheet itself." If you're not familiar with excel/sheets, I would recommend skipping this step.
@@mustermannfm I think just telling us where to paste is what he's after. Knowing the formula is all well and good but you don't tell us where to paste it
will you do one with a tableau analysis? I'm really interested in that
I don't use tableau, so unfortunately not. With regards to Looker Studio, which I do use, my position is still the same - there are YT videos out there by people considerably more familiar with the tool than me.
@@mustermannfm my bad i actually meant looker studio, but thanks anyway
@@eugenetakyi-micah1420 A bit like the opening to the last Zaragoza video about the Dunning-Kruger effect; it's important to acknowledge where my knowledge is limited and not pretend I am an expert. I can use Looker Studio, but I am in no way informed enough about it to give advice. In fact, I am likely to give bad advice because I don't know better!
None of us are beating the 'Spreadsheet Manager' allegations
There's no point in hiding it!!
The filter to compare the players doesnt work for me and there is written error everytime.What could be the possible problem?
It's difficult to say without knowing what you've done. What does the error say?
Hey, first of all forgive me if it appears that im stalking you across multiple videos. I mean, I am doing that but im still sorry about it.
Anyway, in the above video you mention that you shouldn't compare the stats from leagues with full detail to leagues with Match Data set to None (lets call this Simulated Data)
I understand why that is, but im wondering if it is ok to compare Simulated Data to itself? I have a bunch of leagues loaded but all of them have their Detail Level set to None. Im quite far into the save so dont want to lose it but also would love to try the methods you've laid out above.
thanks as always and keep up the great content.
I have you answered already in the video 😉
"...to reliably compare performance stats across leagues, the leagues need to have the same detail level."
This is incredible
But how do I do if I have not 4 but a lot more leagues' scale
Do I reduce my results or try without ?
You add the leagues via the filter. I explained why I chose those 4 leagues for this example, but that doesn't mean you can't do more.
managed to do the fm24 moneyball side on ps5 i see u can export data to cloud so ill have look see if u can download to maybe a mem stick
Great to hear!
@@mustermannfm thanks i can export data but nothing on tube or google about exporting data from fm24 on ps5
@@DavidVenters have you tried asking on the siforums: community.sigames.com/forums ?
So let me get this straight, if we copy-paste the whole Google spreadsheet into a new one and then add our own details from the game, will we be able to use it also?
Or even easier. Go File -> Make a Copy
@@mustermannfm amazing!! Great video man! You should make an app or a program based on those scouting tools! I would totally pay for that
I've been meaning to figure out how to use spreadsheets. I always hear people talking about using them, but I've never used them myself. I think I'm going to from now on
Will this work exactly the same in Excel?
I believe most of the language is universal, so it should do, but I can't say for certain as I don't have Excel
I think I have to watch 80 times to understand. I was understanding untill the formulas began
The good news is before the formulas start, I say: "this is perfectly fine, we can work with the data as it is now, if we wanted to". At that point you have a spreadsheet with exported data that you can use however you want (simple filters, for example).
And then, when you're feeling brave, you can come back and try the additional bits!!
@@mustermannfm Im gonna try!! Im simul half season so I take off with some and a challenge!
Muster, how to you disable player search option??
If you wish to disable player search, you need to edit Mustermann Iconic/sections/sidebar sections.xml, line 487:
This needs to be changed to:
You'll then need to save the file, reload the skin with caching off.
If you also want to disable staff search, that is line 709:
This needs to be changed to:
@@mustermannfm it worked! Thanks so much! 🩵
I’m trying to copy the formula into Sheets, I’ve read the comment where you suggested creating another column to the right. I pasted the Formula in the new J2, used CTRL+H and replaced “CELL” with I2. Also ticked search within formulas and it still doesn’t work.
Can anyone help please
Also, the comparison isn’t working. I’ve tried lowering and adjusting the values in “matches” “percentage” and no players show
Just one small thing, you put Ctrl + P for paste, when it's Ctrl + V
Oh FFS. I have indeed. Ironically the graphic is called "Ctrl V inverted". I just forgot to actually change the text in it 🤦
Hi do you play your skin with attribute masking off?
@@harryyes1527 no, attribute masking is on, meaning I need to scout players for the ranges to be accurate. Until then, the estimates will be at the top of the range. E.g. if the scout says the attribute is 9-17, it will show the player to be Excellent (16-20) until he's been scouted and the actual value is revealed.
@@mustermannfm Great, thankyou!
You mentioned in another video that you have disabled the player search, how did you do that?
@@harryyes1527 not at home today, but if you go to the skin video, and search recent comments the answer should be there somewhere.
@@mustermannfm Thanks I will have a look. My other question was, is there a way so I can see the league reputation list on the league overview page like in the original skin?
Average ‘Data God’ follower ritual:
🙏
Is there a way to export game level data?
I'm afraid not. Or at least not in a convenient manner.
You can calculate it yourself, by exporting stats from the squad view after every game, and then subtracting the previous entry from the current one, but that is laborious and means you need to remember!
Where do I need to put the formule for the values?
Wherever you like, just make sure it references the right column to calculate
@@mustermannfm oke
@@mustermannfmI get this: there’s a problem with this formula. Not trying to type a formula? When the first character is an equal(‘=‘) or minus(‘-‘) sign, Excel thinks its a formula: *you type =1+1, cell shows: 2 to get around this, type an apostrophe(‘) first: * you type ‘=1+1, cell shows: = 1+1. It works on the google spreadsheets. But when the Val is 1,5 mil 1 comes out of it from the formula
1,5m? It may well be possible that you would need to change the regextract in that case. In the UK, the format is 1.5m - with a full stop rather than a comma.
So what about center mids also how would i find the stand out players?
You apply the same principles. What do you require a player to do in each role in your tactic. What are they doing in possession? What are they doing out of possession? Where are they on the pitch when you are in transition and how can they contribute?
@@mustermannfm thanks but also the stand out players by stats just scroll and hope I see them?
@@Georgewestron. Pretty much. If you have a lot of results, refine the criteria further. Maybe the player you're comparing them to is rubbish, so increase the percentage above 100%. Or maybe there's a specific metric you want to prioritise, so use a raw number as the filter rather than comparing to the incumbent.
There is no hard and fast answer here. It's all about your tactic, your squad and the needs therein.
@@mustermannfm to be honest if it is like that then we may aswell create our own views which do the same thing
@@Georgewestron. Yes, you should. As mentioned in the video - I don't provide templates, because you should always be focussing on what is appropriate to your needs at that moment.
What you need from a BPD in a 4-3-3 might be different to what I need from a BPD in a 3-4-1-2. What I need from a BPD in a 3-4-1-2 for Zaragoza is likely to even be different from what I need from a BPD in a 3-4-2-1 for Sevilla.
This is just autism overload. Love it
Numbers. Numbers everywher!!
Where do you paste this formula? I cant seem to get mine to work tbh
You paste it wherever you decide you want your calculated value column to be. That depends entirely on your data set and your decision as to where that column is.
@@mustermannfm Is there a new updated formula? when entering mine it seems to not work, or give me a sort of middling value
There isn't an updated formula, I'm afraid, no. In fact this is the same formula I've used with FM for about 3 years. As it uses regextract to identify the final value (whether it is in a range, or just singular) and then the unit to work out what to multiply by, it shouldn't ever be able to return a mid value.
It may have issues with non-English number formats (for example, if in a language that doesn't use m for millions), which would then return an error.
@@mustermannfm very true, didn't end up being the issue, just something else I had messed up and forgotten to fix. Thanks anyway!
Who is this guy? 😮
Not sure if that's good or bad, so I'll pretend it's the former!