Popular Post jtaylor1409 45 Posted January 20 Popular Post Share Posted January 20 (edited) Afternoon guys. I have been working on this for my own personal save and have been getting a great deal of enjoyment out of it. It's fairly basic and entry level in regards skills but may be of use to some of you perhaps? Let me know if you'd like me to upload a copy when I've finished working on it and I will. It's in the form of an Excel spreadsheet. At the moment it has ratings for each position and role, it pulls in the Attributes and sets a DNA rating too accompanied with Radar graph. Current version 1.4: Download here Update Log v1.4– Fixed formulas giving incorrect ratings to positions L-S, L-A, W-S, W-A, TM-S, TM-A.– Added ‘Abilities’ tab which gives a squad overview of the abilities area on the Dashboard page.– Added Gold, Silver and Bronze colours to Squad Positional Analysis section of Dashboard to highlight 1st, 2nd and 3rd best options for each position.– Removed previous profile view to decrease file size and enhance load speed. Update Log v1.3– Removed ‘Positions’ tab from selectable options– Reworked the profile view tab and added ‘Dashboard’ tab.– Added Abilities tab on Dashboard view to see a players ability for specific areas of their game.– Added players Best & Worst positions which will automatically update for each individual player. Update Log v1.2– Added ‘Positions’ tab which will evaluate your squad on one page and their abilities for selected positions. Update Log v1.1– Added ability to highlight attributes based on role.– Added the ability to get ratings for Goalkeepers.– Corrected issue with NAT and PAC appearing the wrong way round with view. Edited February 10 by jtaylor1409 16 Link to post Share on other sites
CharlieTZR 2 Posted January 21 Share Posted January 21 I'd be very interested, please upload it. Link to post Share on other sites
CARRERA 34 Posted January 21 Share Posted January 21 Where does the data actually come from? Do player stats need to be added manually? Link to post Share on other sites
jtaylor1409 45 Posted January 21 Author Share Posted January 21 1 hour ago, CARRERA said: Where does the data actually come from? Do player stats need to be added manually? The data is pulled from FM squad view screen, where I've created a custom view. It then gets exported to a webpage file, and you copy and paste it into the spreadsheet. It'll then auto populate. 5 hours ago, CharlieTZR said: I'd be very interested, please upload it. I will upload a copy of it when it's complete. 2 Link to post Share on other sites
Christopher S 66 Posted January 21 Share Posted January 21 18 minutes ago, jtaylor1409 said: The data is pulled from FM squad view screen, where I've created a custom view. It then gets exported to a webpage file, and you copy and paste it into the spreadsheet. It'll then auto populate. I will upload a copy of it when it's complete. I'd definitely be interested in a copy! 1 Link to post Share on other sites
poobington 23 Posted January 21 Share Posted January 21 Looks very nice mate, count me interested. Link to post Share on other sites
LHurlz 30 Posted January 21 Share Posted January 21 Fascinating, I'd definitely take a copy! Link to post Share on other sites
Mr_Demus 334 Posted January 21 Share Posted January 21 4 hours ago, jtaylor1409 said: The data is pulled from FM squad view screen, where I've created a custom view. It then gets exported to a webpage file, and you copy and paste it into the spreadsheet. It'll then auto populate. I will upload a copy of it when it's complete. How do you export a page from FM? I tried looking for a solution, but couldn't figure it out Link to post Share on other sites
right_winger 23 Posted January 21 Share Posted January 21 And me, me! Good job @jtaylor1409 !!! Link to post Share on other sites
jtaylor1409 45 Posted January 22 Author Share Posted January 22 (edited) 14 hours ago, Mr_Demus said: How do you export a page from FM? I tried looking for a solution, but couldn't figure it out When you've assigned the view on your squad page, you'd press CTRL and P on your keyboard this will bring up an option to print to Printer/Web Page/Text File. Edited January 22 by jtaylor1409 Link to post Share on other sites
Mr_Demus 334 Posted January 22 Share Posted January 22 52 minutes ago, jtaylor1409 said: When you've assigned the view on your squad page, you'd press CTRL and P on your keyboard this will bring up an option to print to Printer/Web Page/Text File. Jeebus, it had to be that easy. I feel stupid now. Cheers. Link to post Share on other sites
jtaylor1409 45 Posted January 26 Author Share Posted January 26 I have now released the first version. You can find the download link in the first post. Hope you like it! Link to post Share on other sites
tsatsee 11 Posted January 26 Share Posted January 26 My link isn't working. Could you check it? I downloaded the squad view, but couldn't download the xlsx file. Link to post Share on other sites
jtaylor1409 45 Posted January 27 Author Share Posted January 27 12 hours ago, tsatsee said: My link isn't working. Could you check it? I downloaded the squad view, but couldn't download the xlsx file. Seems to be working fine for me? Link to post Share on other sites
tsatsee 11 Posted January 28 Share Posted January 28 It is working now. Thanx for the work. It is a great tool. Link to post Share on other sites
jtaylor1409 45 Posted January 29 Author Share Posted January 29 Version 1.1 of the spreadsheet has just been released. See first post. 👍 Link to post Share on other sites
right_winger 23 Posted January 30 Share Posted January 30 + Anyone knows whether this is because I play FM Touch or it shouldn't matter? Link to post Share on other sites
jtaylor1409 45 Posted February 2 Author Share Posted February 2 On 30/01/2021 at 19:20, right_winger said: + Anyone knows whether this is because I play FM Touch or it shouldn't matter? I'm not sure to be honest mate I've not played FM Touch before. Can anyone help? Link to post Share on other sites
jtaylor1409 45 Posted February 2 Author Share Posted February 2 Version 1.2 released - see first post. Link to post Share on other sites
bulldog 11 Posted February 3 Share Posted February 3 For those having trouble in FM Touch I think I just created a custom Squad View in the game instead of importing the view. It works for me 1 Link to post Share on other sites
jtaylor1409 45 Posted February 3 Author Share Posted February 3 24 minutes ago, bulldog said: For those having trouble in FM Touch I think I just created a custom Squad View in the game instead of importing the view. It works for me Thanks Bulldog. Link to post Share on other sites
jtaylor1409 45 Posted February 5 Author Share Posted February 5 Version 1.3 released featuring new layout design. 2 Link to post Share on other sites
Christopher S 66 Posted February 5 Share Posted February 5 2 hours ago, jtaylor1409 said: Version 1.3 released featuring new layout design. Really nice work, bud. Using it to prep and build my squad for the new season now. Link to post Share on other sites
jtaylor1409 45 Posted February 6 Author Share Posted February 6 15 hours ago, Christopher S said: Really nice work, bud. Using it to prep and build my squad for the new season now. Excellent stuff Christopher. I hope it helps with team performance & enjoyment of your save. 👍 Link to post Share on other sites
Kung 0 Posted February 6 Share Posted February 6 Great job, very useful. Link to post Share on other sites
jtaylor1409 45 Posted February 10 Author Share Posted February 10 Version 1.4 released. 1 Link to post Share on other sites
Al Bundy 4 Posted February 25 Share Posted February 25 Great job, was using something similar but yours is way advanced so I'm switching. Thanks Link to post Share on other sites
TelcontarTargaryen 5 Posted February 25 Share Posted February 25 This is awesome, thank you. Link to post Share on other sites
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