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.

@mustermannfm

13 күн бұрын

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!

@FMNATICS

12 күн бұрын

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!

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

@mustermannfm

13 күн бұрын

Hopefully it's worth the wait!!

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!

@mustermannfm

12 күн бұрын

My eyes glazed over too, that's why it took an extra 2 weeks to do 😂

@FMNATICS

12 күн бұрын

His voice is indeed pleasing. 😅

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 😊

@mustermannfm

7 күн бұрын

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 🤣

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

@mustermannfm

11 күн бұрын

Oh, that's very kind, thank you! Hopefully it was worth it!

I always find myself waiting for Fridays, these videos are amazing

@mustermannfm

13 күн бұрын

Hopefully this will start the weekend right!!

To take something so data heavy and explain it in such a clear and consise way takes some doing! Another exceptional video, my man!

@mustermannfm

12 күн бұрын

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!!!

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. 😅

@mustermannfm

12 күн бұрын

There's no escaping the claims that Football Manager is actually "Spreadsheet Manager"

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!

@mustermannfm

12 күн бұрын

Glad you enjoyed it, dude!

This is brilliant! Thank you so much for sharing all this. ❤

@mustermannfm

13 күн бұрын

Thank you, dude! Glad you enjoyed it!

There it is. The perfect video. Many thanks Mustermann! 👏🏽

@mustermannfm

12 күн бұрын

Glad you enjoyed it, dude!

My fav FM channel right now, keep up the great work

@mustermannfm

13 күн бұрын

Thank you, dude!

Thanks for all the effort you put in. Top man👍

@mustermannfm

10 күн бұрын

Cheers, dude!!

Always excited to see a new Munstermann video! Keep up the good work ❤️

@mustermannfm

13 күн бұрын

Cheers, dude 🙏

Great video! ...and I see some formulas which will even benefit me at work!

@mustermannfm

13 күн бұрын

Ironically it's the other way around for me. I learn something for work and think "ooo, formulas I can use for FM" 🤣

I also do hate spreadsheets but look...this is incredibly useful and thank you for your sacrifice.

@mustermannfm

12 күн бұрын

There's no denying their utility, but I've spent far too much of my adult life looking at them!

@BrasilianFury

12 күн бұрын

@@mustermannfm YES, THAT! After a certain point, you just want the agony to end!

@mustermannfm

12 күн бұрын

@@BrasilianFury that certain point is usually only 5 minutes in!!

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 🍺

@mustermannfm

13 күн бұрын

Thank you, dude!

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!

@mustermannfm

12 күн бұрын

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.

@FMNATICS

12 күн бұрын

I consider myself decent with Spreadsheets, but this is another level. Love it!

This is incredible content.

@mustermannfm

12 күн бұрын

Thank you, 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 !

@mustermannfm

12 күн бұрын

Glad you enjoyed it! Thank you, dude!

This is insane attention to detail

@mustermannfm

12 күн бұрын

Thank you, dude!

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 :)

@mustermannfm

13 күн бұрын

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

@mustermannfm

11 күн бұрын

You rock!

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

@peoplesrepublicofjockistan4624

12 күн бұрын

Not saying yours isn’t easy. But as a complete tool myself it’s pretty straight forward 😅

@mustermannfm

12 күн бұрын

I should probably check my emails!!!

Mustermann School of Football Manager Stats 🙌🏿🙌🏿 I know I are tired of hearing this from me but u are so good at this.

@mustermannfm

12 күн бұрын

I will always appreciate it 🙏, thank you, 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

@mustermannfm

12 күн бұрын

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!!

@TheKvezh

12 күн бұрын

@@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.

@mustermannfm

12 күн бұрын

@@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 kinda love you man

@mustermannfm

12 күн бұрын

Spreadsheets do funny things to people!

Ooh should be a good one!

@mustermannfm

13 күн бұрын

Hopefully. A little nervous about this one; probably the toughest to write/co-ordinate.

Welcome to the Football Manager Academy ....

@mustermannfm

13 күн бұрын

Nerds assemble!!

@tarikat6870

13 күн бұрын

​@@mustermannfm 😁😁

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.

@mustermannfm

12 күн бұрын

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!

@mazssj

12 күн бұрын

@@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.

Musterband, my fav band

@mustermannfm

13 күн бұрын

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!

yoooohooo almost 18 min of joy. gimme that

@mustermannfm

13 күн бұрын

Spreadsheet nerds assemble!

None of us are beating the 'Spreadsheet Manager' allegations

@mustermannfm

13 күн бұрын

There's no point in hiding it!!

Hey man, enjoying the vids ! While explaining Real Zaragoza save you mentioned the disabled player search, how can I disable it for myself ?

@mustermannfm

6 күн бұрын

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:

@kizo3273

6 күн бұрын

@@mustermannfm Thanks ! Managed to make it work.

Average ‘Data God’ follower ritual:

@mustermannfm

13 күн бұрын

🙏

Just one small thing, you put Ctrl + P for paste, when it's Ctrl + V

@mustermannfm

12 күн бұрын

Oh FFS. I have indeed. Ironically the graphic is called "Ctrl V inverted". I just forgot to actually change the text in it 🤦

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?

@mustermannfm

12 күн бұрын

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

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

12 күн бұрын

Thank you, dude! Setup is going to depend entirely on your preferences. What I do is covered here: kzread.info/dash/bejne/mGF8lqmfd5zTeJM.html

@TN34RY

12 күн бұрын

@@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

@mustermannfm

11 күн бұрын

@@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.

@TN34RY

11 күн бұрын

@@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

@mustermannfm

10 күн бұрын

@@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

@mustermannfm

12 күн бұрын

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.

@jonathanconn214

12 күн бұрын

@@mustermannfm I made it work. Pasted it into the column beside the data and then pasted the values back into the transfer value column.

@mustermannfm

12 күн бұрын

@@jonathanconn214 Glad you got it working!

@EdenQQQ

3 күн бұрын

​@@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?

@mustermannfm

3 күн бұрын

@@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.

will you do one with a tableau analysis? I'm really interested in that

@mustermannfm

12 күн бұрын

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

12 күн бұрын

@@mustermannfm my bad i actually meant looker studio, but thanks anyway

@mustermannfm

12 күн бұрын

@@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?

@mustermannfm

9 күн бұрын

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.

9 күн бұрын

@@mustermannfm thanks but also the stand out players by stats just scroll and hope I see them?

@mustermannfm

9 күн бұрын

@@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.

9 күн бұрын

@@mustermannfm to be honest if it is like that then we may aswell create our own views which do the same thing

@mustermannfm

9 күн бұрын

@@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.

Who is this guy? 😮

@mustermannfm

12 күн бұрын

Not sure if that's good or bad, so I'll pretend it's the former!

Hi do you play your skin with attribute masking off?

@mustermannfm

Күн бұрын

@@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.

@harryyes1527

Күн бұрын

@@mustermannfm Great, thankyou!

@harryyes1527

2 сағат бұрын

You mentioned in another video that you have disabled the player search, how did you do that?

@mustermannfm

Сағат бұрын

@@harryyes1527 not at home today, but if you go to the skin video, and search recent comments the answer should be there somewhere.

@harryyes1527

Сағат бұрын

@@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?