Welcome to FMTV! FMTV is a new project aimed at helping people discover FM Content on YouTube. If you're a fan of FM use the links to find content organised in handy categories. If you're a creator you can add your videos to get access to an admin panel allowing you to categorise each video. Creators will need to login and categorise each video after it's uploaded. We're also looking for moderators to volunteer and help organise the app.
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.
*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 YouTube content. Awful sense of humour.
*MODS USED*
Mustermann Iconic Skin: https://bit.ly/46zPxAP
Cut Out Player Faces Megapack: https://sortitoutsi.net/graphics/style/1/cut-out-player-faces
Standard Kits Megapack: https://sortitoutsi.net/graphics/style/7/standard-kits
Background & Stadiums Megapack: https://sortitoutsi.net/graphics/style/17/sortitoutsi-backgrounds-megapack
FMG Standard Logos Megapack: https://sortitoutsi.net/graphics/style/25/fmg-standard-logos
Trophies Megapack: https://www.fmscout.com/a-fm23-trophies-megapack.html
*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: https://www.paypal.com/donate/?business=S4SBRQG4K5FNG&no_recurring=0¤cy_code=GBP. I would like to stress there is no obligation whatsoever!