Popular Post gam945 Posted December 31, 2020 Popular Post Share Posted December 31, 2020 (edited) Hi fellow managers, I want to present you a new tool I'm working on that will enable us to use the data that FM provides us with at its full potential. Including attributes, diverse statistics, injuries data and many more, FM has more than 300 data points. Yet, I can bet any one of us doesn't even use the third of it to make decisions and manage our club. Maybe it's due to the fact that FM doesn't offer an easy way of presenting all those data points. Take the match statistics for example, like the assists, passes completed, cross completion ratio etc. Yes, we could create a view with all those stats and compare them to decide which player on our shortlist will be the transfer target. But it is neither visually appealing to have a view full of numbers nor easy to make comparisons. The app is now released! (2020/01/09) The V2 Update is now released! (2020/01/15) Following is a quick guide to get started with the app. Install R You do not need to know anything about R, everything is programmed for you. However, you need to install the software. I will not go into too much details for this section as there are plenty of good guide, and as a quick Google search will yield the result. When you install R, remember in which directory it was installed as you will need it later. Install R: https://cran.r-project.org/ > Download R for Windows > "install R for the first time" hyper link > "Download R 4.0.3 for Windows" hyperlink > follow the installation wizard instructions ** It is preferable to install R in a folder you have created in the C:\ directory (instead of installing it in "C:\Program Files") to avoid errors when running the batch file that launches the app For example: (1) Create the MyPrograms folder in C:\ (2) Install R in the following directory: C:\MyPrograms Do I need RStudio? NoDo I need to run something on R after installing it? No, patience is key, all what you need has been scripted by me I don't know how to program in R! You don't need to know! Install the app Go to my Github page: https://github.com/ybenadjal/FM-Data-Analytics > Repositories > FM-Data-Analytics Download the complete folder then unzip it in your computer: Unzip the zip folder you just downloaded (just copy the FM-Data-Analytics folder that is inside the .zip somewhere on your computer). Move the main folder(FM-Data-Analytics-main) wherever you want, but do not change the structure of the folder. Everything is now in the folder you just extracted: Walk-through & set up the app: data Contains the outputs you have exported from FM.(1) Do not delete shortlist.html or squad.html if you don't replace it. Later running the app without one of the files may cause errors.(2) Always name the outputs "shortlist" and "squad".* V3 UPDATE: Name the squad outputs as follows: "squad_yyyymmdd", where "yyyymmdd" is the in-game date. You can now store multiple squad outputs(3) When extracting the data from FM, be sure to scroll from top to bottom of the shortlist to get all the data when you use Ctrl+P to print and export. V2 UPDATE: The app now directly reads the FM outputs to extract the data, thus meaning the Excel tool is obsolete. It is no longer included in the download. Walk-through & set up the app: demo_videos Contains two video demos, one for the setup, and one for the data extract/use the app. V2 UPDATE: Update to reflect the new workflow Walk-through & set up the app: fmviews Contains the views you have to import in your FM game, then export the FM screen as a Web Page/html file (Ctrl+P in FM). completeview_shortlist_v4 is a view for the Shortlist in FM (Scouting > Shortlist).completeview_squad_v4 is a view for the Squad in FM (Squad). ** Do not change anything to avoid errors! V2 UPDATE: FFP Contribution and future time playing removed (5 columns) as they are user-specific Walk-through & set up the app: help Contains a data dictionary. All the data points exported from FM are described here. V2 UPDATE: The app now dynamically install required packages if needed. First thing the code does is check if there are missing required packages and installs them. This means the installpackages.bat batch file is now obsolete. It is no longer included in the download. Walk-through & set up the app: main Go back to the main file, there is the app: app.R, and another batch file to run the app: FMapp.bat **IMPORTANT STEP (ONE-TIME ONLY)** (1) Find your Rscript.exe file. It should be in the file you installed R > R-<version> > bin(2) copy the path (in yellow)(3) open FMapp.bat and replace your path in r_path1 (only replace the highlighted code in blue). That is the only adjustment you need to to!(4) Save FMapp.bat and close it. You're set to use the app. The instructions are repeated in the setupdemo video in \demo_videos ****V2 UPDATE: FMapp.bat now detects its current directory and uses it to launch the app. It is very important that you don't modify the file's structure! Instead of replacing 3 paths in the last version, you only need to replace 1, and it's a one-time process. V2 UPDATE: DNA Model subsection was added in the Squad Analysis section. This enables you to select key attributes for your playing style and calculate a "DNA rating". Similarly to the Scouting section, the color code is used in the tables and the plots. V2 UPDATE: dynamic package installation. V2 UPDATE: App reads html FM outputs instead of the Excel tool. V2 UPDATE: Added status messages to show the user what's going on before the app is launched in their browser. V2 UPDATE: Points in the plots have now a subtle black outline to make them more visible. You're now all set! Launch the app by double-clicking on the FMapp batch file, the app will open in your browser! The app will open in your browser. It is strongly recommended to set the zoom size as 90% and to maximize the browser's window ** When you close the app on your browser, also close the Command Prompt window that was opened by the batch file TIPS: (1) App interface The app will launch in your browser. Set the zoom at 90% to get an optimal view. Use the 3 bars at the top to hide/show the sidebar, thus leaving more space for the content. (2) Interacting with the plots Some plots have trend lines, some do not. Hovering on the points will show you more info about the player. You can zoom in, navigate on the plot. Double click on the plot to get back to the default view. Quick demo: Dots size: the more a player has games played (calculated by the total number of minutes ÷ 90), the bigger is the dot. Dots color: depends on the scouting recommendation. Makes it easier to notice badly rated players that are in fact performing and vice-versa. Non scouted players are assigned -1, as well as squad players. V2 UPDATE: The DNA ratings have the same color code. If the user doesn't specify a DNA model then players are assigned a rating of -1. (3) Shortlist builder In the scouting section, you have a shortlist builder. This enables you to select some players you notice in each subsection (general/passing/shooting/etc). Then in the last subsection, Shortlist, you'll have the intersection of all the players you selected. Let's say you want a goalscorer AM. You noticed: Player A, Player B, Player C, Player D as good playmakers in the passing subsection and selected these players in the bottom shortlist builder. In the shooting subsection, you selected Player B, Player D, Player E and Player F. You'll see that in the Shortlist subsection, you'll have a table with Player B, Player D, thus your shortlist have been built. ** Leave all other Shortlist builders with all players selected if you don't use them. If you want to begin a new analysis and create a new Shortlist, make sure that all the shortlist builders have all players selected before beginning. (4) Filters Want to analyze your loaned players? Squad Analysis > Filters > Clubs: deselect your club (should be the first entry) Want to analyze your players at the club? Squad Analysis > Filters > Clubs: deselect all then select your club (should be the first entry) Edited February 21, 2021 by gam945 V3 update is released (2021/02/21) 44 Link to post Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now