Это видео недоступно.
Сожалеем об этом.
FM24 Guide: How to Export & Analyse Data | Moneyball Clinic | Football Manager 2024
HTML-код
- Опубликовано: 20 июн 2024
- CTRL + V. CTRL + V. CTRL + V. You use CTRL + V to paste, not CTRL + P. I'm an idiot.
You asked, I listened. A guide to exporting and analysing data from Football Manager 24, which is the same I approach I used in the Fluminense Moneyball Clinic episode.
EXPORT & ANALYSIS SPREADSHEET
This file is view only. You will need to make a copy to edit.
docs.google.co...
THE FORMULA
Find and Replace all instaces of CELL with the target that you are trying to convert. So, if the column for transfer value is D, then replace CELL with D2. Once done with the first cell, you can drag the formula down
"IF(OR(*CELL* = ""0"", CELL = ""Not for Sale"", CELL = ""Unknown""),
*CELL*,
IF(ISNUMBER(FIND("" - "", *CELL*)),
IF(RIGHT(REGEXEXTRACT(RIGHT(*CELL*, LEN(*CELL*) - FIND("" - "", *CELL*) - 3), ""\d+\.?\d*[MK]?""), 1) = ""M"",
VALUE(REGEXEXTRACT(RIGHT(*CELL*, LEN(*CELL*) - FIND("" - "", *CELL*) - 3), ""(\d+\.?\d*)M"")) * 1000000,
IF(RIGHT(REGEXEXTRACT(RIGHT(*CELL*, LEN(*CELL*) - FIND("" - "", *CELL*) - 3), ""\d+\.?\d*[MK]?""), 1) = ""K"",
VALUE(REGEXEXTRACT(RIGHT(*CELL*, LEN(*CELL*) - FIND("" - "", *CELL*) - 3), ""(\d+\.?\d*)K"")) * 1000,
VALUE(REGEXEXTRACT(RIGHT(*CELL*, LEN(*CELL*) - FIND("" - "", *CELL*) - 3), ""(\d+\.?\d*)""))
)
),
IF(RIGHT(REGEXEXTRACT(*CELL*, ""\d+\.?\d*[MK]?$""), 1) = ""M"",
VALUE(REGEXEXTRACT(*CELL*, ""(\d+\.?\d*)M$"")) * 1000000,
IF(RIGHT(REGEXEXTRACT(*CELL*, ""\d+\.?\d*[MK]?$""), 1) = ""K"",
VALUE(REGEXEXTRACT(*CELL*, ""(\d+\.?\d*)K$"")) * 1000,
VALUE(REGEXEXTRACT(*CELL*, ""(\d+\.?\d*)$""))
)
)
)
)
"
MONEYBALL CLINIC
A team guide series, using a statistic-led approach to squad assessment, tactic building and recruitment.
MUSTERMANNFM
A veteran of the FM series, going all the way back to Championship Manager Italia in 1993 (yes, I'm old). Creator of the Mustermann skins (links below) and recently started creating RUclips content. Awful sense of humour.
MODS USED
Mustermann Iconic Skin: bit.ly/46zPxAP
Cut Out Player Faces Megapack: sortitoutsi.ne...
Standard Kits Megapack: sortitoutsi.ne...
Background & Stadiums Megapack: sortitoutsi.ne...
FMG Standard Logos Megapack: sortitoutsi.ne...
Trophies Megapack: www.fmscout.co...
DONATIONS
If, for whatever reason, you are so enamoured with this skin you want to send me a coffee, feel free to donate via PayPal: www.paypal.com.... I would like to stress there is no obligation whatsoever!
MUSIC
Ode to Keinan Davis - The Musterband
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!
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!!
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!!!
I always find myself waiting for Fridays, these videos are amazing
Hopefully this will start the weekend right!!
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!
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 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 🤣
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!
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" 🤣
My fav FM channel right now, keep up the great work
Thank you, dude!
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!!
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!
Always excited to see a new Munstermann video! Keep up the good work ❤️
Cheers, dude 🙏
This is brilliant! Thank you so much for sharing all this. ❤
Thank you, dude! Glad you enjoyed it!
There it is. The perfect video. Many thanks Mustermann! 👏🏽
Glad you enjoyed it, dude!
This is insane attention to detail
Thank you, dude!
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"
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 love you so much, thank you Professor Mustermann
You rock!
This is incredible content.
Thank you, dude!
Thanks for all the effort you put in. Top man👍
Cheers, dude!!
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.
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!!!
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 🤣
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!!
Welcome to the Football Manager Academy ....
Nerds assemble!!
@@mustermannfm
😁😁
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.
yoooohooo almost 18 min of joy. gimme that
Spreadsheet nerds assemble!
Ooh should be a good one!
Hopefully. A little nervous about this one; probably the toughest to write/co-ordinate.
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.
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 kinda love you man
Spreadsheets do funny things to people!
None of us are beating the 'Spreadsheet Manager' allegations
There's no point in hiding it!!
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!
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: ruclips.net/video/f-H4GfG9mH0/видео.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.
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 🤦
Average ‘Data God’ follower ritual:
🙏
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 RUclips, 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)
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!
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.
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.
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?
Who is this guy? 😮
Not sure if that's good or bad, so I'll pretend it's the former!