Pedroig Posted December 1, 2019 Share Posted December 1, 2019 Training Planner FM20 v1.5 spreadsheet (dropbox link, excel sheet, no macros) @FMathlete (Blog Here) did the initial version of this spreadsheet for FM19, he has given permission for me to share it here. I have updated it for the added modules in FM20. I've also added some "tweaks", which maybe used or ignored as you wish. Please note the disclaimer at the top of the Read Me page: This workbook was prepared independently of SI and FM. It is entirely my own interpretation of how I understand the training modules to work and i could very well be completely wrong! I am continuing to test it's success and will make adjustments to the maths as I learn more about the true impact of training sessions on player attributes. Please feel free to use the data as you see fit, and share your comments or suggestions for improvements with the community. Here is the current list of updates and features tweaks. Current updates:Added Bravery Attribute Added Attacking Overlap Added Defend from the Front Added Play from the Back Current tweaks:User Input page: You can now enter your League Reputation (0-5 stars) for a baseline training regime guide of intensity. You can now enter your squad's average attributes for Natural Fitness, Stamina, Work Rate, and Determination for a custom training regime guideline. (These attributes have been selected because they seem most applicable to the visible traits to how hard you can push your squad in training, disregards personalities) You can select up to 10 CORE DNA attributes. These will be highlighted on the Tactical Planner page for your convenience. Tactical Planner page: Added a Type for each DAY's training regime. This will quickly show the training intensity level (should be comparable to the ingame intensity) as well as the Tactical Periodization training type. Added a scale for intensity colors and a definition section for the Tactical Periodization terminology. Along with brief suggested usage. As noted above, the Core DNA attributes you have selected will be highlighted in the table. Read Me page: Moved notes around. Added change log Added To Do list 7 Link to post Share on other sites More sharing options...
Tiger666 Posted December 3, 2019 Share Posted December 3, 2019 Love the idea of this but is it working correctly? According to the in-game description of, for example, Attacking Patient. For the attacking unit It should train Finishing, First Touch, Passing, Technique, Composure, Decisions, Flair, Off The Ball, Vision, Teamwork. When entering Attacking Patient in the spreadsheet it doesn't train Finishing, First Touch, Passing, Technique. 1 Link to post Share on other sites More sharing options...
Pedroig Posted December 3, 2019 Author Share Posted December 3, 2019 @Tiger666 Ugh, had a wrong call up error for the attacking technical attributes. Thanks for the heads up. It is fixed now. I'll be travelling for the rest of the week, but should have an update over the weekend for Set Pieces and a verification that all attributes are accounted for in each training module. 1 Link to post Share on other sites More sharing options...
Tiger666 Posted December 3, 2019 Share Posted December 3, 2019 Yup working like a dream now. I am absolutely obsessive about details as you can see from my own spreadsheets: This is a brilliant tool, saves me having to work it all out manually. Thanks a lot for taking the time to update it. 1 Link to post Share on other sites More sharing options...
TheInvisibleMan Posted December 4, 2019 Share Posted December 4, 2019 (edited) This is really impressive. The tactical periodisation stuff is exactly how some coaches plan their training in real life and I've never seen anyone bring it to FM before. Going to give it a try, have a play about and see how I get on. Don't suppose there is a Mac version (numbers)? @Pedroig @FMathlete Tried opening it in Numbers but the formulas don't carry across. Edited December 4, 2019 by TheInvisibleMan Link to post Share on other sites More sharing options...
Pedroig Posted December 4, 2019 Author Share Posted December 4, 2019 @TheInvisibleMan I've been PC since I got off C64... So don't know about Numbers. As a random guess I'd bet it has something to so with the formulas looking at different sheets in the workbook. I'll see about putting it all on a single sheet and/or saving in Numbers format and throwing it up as an alternative, IF you promise to test it to see if it works.. Link to post Share on other sites More sharing options...
TheInvisibleMan Posted December 4, 2019 Share Posted December 4, 2019 56 minutes ago, Pedroig said: @TheInvisibleMan I've been PC since I got off C64... So don't know about Numbers. As a random guess I'd bet it has something to so with the formulas looking at different sheets in the workbook. I'll see about putting it all on a single sheet and/or saving in Numbers format and throwing it up as an alternative, IF you promise to test it to see if it works.. Sounds like a deal! Don't worry if it's too difficult. I had a play about with it on Numbers but it was a bit beyond me as how to fix it and make it work. Link to post Share on other sites More sharing options...
Snorks Posted December 5, 2019 Share Posted December 5, 2019 Definitely going to have a look in more detail at this. Link to post Share on other sites More sharing options...
Hovis Dexter Posted December 9, 2019 Share Posted December 9, 2019 @TheInvisibleMan I've only had a quick play but as far as I can see the spreadsheet seems to be working with Libreoffice Calc which is open source and will work on a Mac Link to post Share on other sites More sharing options...
Hovis Dexter Posted December 9, 2019 Share Posted December 9, 2019 @Pedroig Thank you for this. I've no clue as how to set up training and always leave it to the ass man. I'm now going to look to set up my own training schedules. The key attributes input looks to be great addition. Link to post Share on other sites More sharing options...
TheInvisibleMan Posted December 9, 2019 Share Posted December 9, 2019 19 minutes ago, Hovis Dexter said: @TheInvisibleMan I've only had a quick play but as far as I can see the spreadsheet seems to be working with Libreoffice Calc which is open source and will work on a Mac Interesting! Will look into that, cheers. Link to post Share on other sites More sharing options...
h3nrique_SEP Posted December 9, 2019 Share Posted December 9, 2019 it's missing the possesion overall training Link to post Share on other sites More sharing options...
Hovis Dexter Posted December 9, 2019 Share Posted December 9, 2019 So far as I can see determination is missing from the attributes being trained. Link to post Share on other sites More sharing options...
SpS_Zen Posted December 9, 2019 Share Posted December 9, 2019 what about amateur/semi professional clubs? Link to post Share on other sites More sharing options...
Tiger666 Posted December 10, 2019 Share Posted December 10, 2019 7 hours ago, Hovis Dexter said: So far as I can see determination is missing from the attributes being trained. No training block affects Determination Link to post Share on other sites More sharing options...
Hovis Dexter Posted December 10, 2019 Share Posted December 10, 2019 5 hours ago, Tiger666 said: No training block affects Determination Thank you ... didn’t know that Link to post Share on other sites More sharing options...
Hovis Dexter Posted December 10, 2019 Share Posted December 10, 2019 7 hours ago, SpS_Zen said: what about amateur/semi professional clubs? Just fill in the days on which the club trains and leave the other days blank Link to post Share on other sites More sharing options...
Guest Posted December 10, 2019 Share Posted December 10, 2019 This is really friggin' handy. Would yourself/FMAthlete allow us to post it also on FMBase? (or you can if you want :P) Link to post Share on other sites More sharing options...
Pedroig Posted December 11, 2019 Author Share Posted December 11, 2019 On 09/12/2019 at 12:27, h3nrique_SEP said: it's missing the possesion overall training Got called away this past weekend. Will take a look into it, and get it corrected. Thanks for the heads up! @Danwolf I've merely updated @FMathlete's original work, who gave me permission to post my modifications here. If you would contact him. for permission to post on your site, that would be proper channels and all. Link to post Share on other sites More sharing options...
Gunnersmoke Posted December 13, 2019 Share Posted December 13, 2019 Brilliant post, will look to add this to my thoughts Link to post Share on other sites More sharing options...
Pedroig Posted December 14, 2019 Author Share Posted December 14, 2019 (edited) Link file has been updated, should just need to go to same link and re-download. Added Possession to Training Planner. (All formulations were there, just lost the selection drop down) Formulated Set Pieces. This is not PRECISE. I defaulted to using the same general groups GK/DEF/ATT and then derived relevant attributes from it. Added Set Pieces to the Training Planner so they don't break everything else now. The Modules should be Pink. Overall daily sessions they should appear as Technical sessions if you were to do a whole day of them with either Recovery or Activation. Edited December 14, 2019 by Pedroig Link to post Share on other sites More sharing options...
LandoManSmash Posted December 14, 2019 Share Posted December 14, 2019 Hello, this is a great tool and I'm fooling around with it. Kind of like the last post, the Defending Wide module seems to be missing as well when you're next doing an update. Thanks for posting this! Link to post Share on other sites More sharing options...
alexcelsior Posted December 14, 2019 Share Posted December 14, 2019 I think there's still an issue with the "defending - wide" module not being in the list? Link to post Share on other sites More sharing options...
Pedroig Posted December 14, 2019 Author Share Posted December 14, 2019 @LandoManSmash and @alexcelsior y'all are correct. So good news: It's been fixed. File updated, link the same. Bad news: Going to reformat the dropdown list so it is in the same order as in game. This is going to take a while. Still going through verifying the data matches up FM20 from FM19. Have found a couple of slight differences, and am working through them. Lots of Alt Tabbing on the laptop. Thanks for all the double-checks and reports to all. (I really checked the modules I use all the time, and the others were under less scrutiny) 1 Link to post Share on other sites More sharing options...
divij13 Posted January 9, 2020 Share Posted January 9, 2020 (edited) This is absolutely fantastic! Looking forward to making a few custom schedules Edited January 9, 2020 by divij13 Link to post Share on other sites More sharing options...
Tiger666 Posted January 14, 2020 Share Posted January 14, 2020 You may want to double check these. I'm sure "Play From The Back" trains Teamwork but it doesn't highlight. Link to post Share on other sites More sharing options...
skam Posted February 6, 2020 Share Posted February 6, 2020 On 03/12/2019 at 20:06, Tiger666 said: Yup working like a dream now. I am absolutely obsessive about details as you can see from my own spreadsheets: This is a brilliant tool, saves me having to work it all out manually. Thanks a lot for taking the time to update it. Can you please upload/send me this spreadsheet, good man? Link to post Share on other sites More sharing options...
Egecann Posted February 6, 2020 Share Posted February 6, 2020 (edited) 49 minutes ago, skam said: Can you please upload/send me this spreadsheet, good man? @Tiger666 Yes please share it. I think he is related to Pep Guardiola or Bielsa Edited February 6, 2020 by Egecann Link to post Share on other sites More sharing options...
Tiger666 Posted February 6, 2020 Share Posted February 6, 2020 49 minutes ago, skam said: Can you please upload/send me this spreadsheet, good man? I can do but a lot of it is just for my personal use so probably won't make much sense to you. About to go to lunch, will sort it out in a bit. Link to post Share on other sites More sharing options...
Tiger666 Posted February 6, 2020 Share Posted February 6, 2020 Here you go. Not sure how useful it will be to you but knock yourself out. Football Manager.xlsx Link to post Share on other sites More sharing options...
skam Posted February 7, 2020 Share Posted February 7, 2020 22 hours ago, Tiger666 said: Here you go. Not sure how useful it will be to you but knock yourself out. Football Manager.xlsx 5.4 MB · 15 downloads I was looking to create something similar in my own career, so I was looking for a template. Yours is a very sophisticated one, so after some work it will be just right. Thank you. Link to post Share on other sites More sharing options...
Kurt Hoo Posted October 5, 2020 Share Posted October 5, 2020 is there a newest version, dude? Link to post Share on other sites More sharing options...
wooga21c Posted November 27, 2020 Share Posted November 27, 2020 PLZ update Terminate FM”21”: Handbook on Pep Guardiola's Barcelona 433 and the Tactic Pack Link to post Share on other sites More sharing options...
Robbo4891 Posted December 31, 2020 Share Posted December 31, 2020 (edited) As far as i know i have the latest version but after months of using it i've just noticed their is an issue with defensive shadow play, it's meant to hit Anticipation, Concentration, Decisions, Positioning, Teamwork for the defensive unit but when i input it into the planner it is giving a value to "off the ball" and not "positioning" ??? is their a newer version or is their any way we can correct this ourselfs in the planner??? Thanks Edited December 31, 2020 by Robbo4891 Link to post Share on other sites More sharing options...
Robbo4891 Posted January 1, 2021 Share Posted January 1, 2021 No worries i figured out how to do it my self. Link to post Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now