Popular Post jtaylor1409 Posted January 20, 2021 Popular Post Share Posted January 20, 2021 (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. virto.mp4 Current version 1.5: Download here Updated Log v1.52- Dropdown menu on the 'Scouting' tab for Positional Analysis now working.Updated Log v1.51- Removed Link from the spreadsheet linking back to the previous file.- Made it so DNA only has to be input on DASHBOARD & SCOUTING pages ONLY. Update Log v1.5– Addition of weighted attributes to increase the reliability of ratings.– Redesigned the look– Scouting aspect added.– Abilities tab expanded and the Comparison tab added. 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 March 8, 2021 by jtaylor1409 Updated to 1.5 18 Link to post Share on other sites More sharing options...
CharlieTZR Posted January 21, 2021 Share Posted January 21, 2021 I'd be very interested, please upload it. Link to post Share on other sites More sharing options...
CARRERA Posted January 21, 2021 Share Posted January 21, 2021 Where does the data actually come from? Do player stats need to be added manually? Link to post Share on other sites More sharing options...
jtaylor1409 Posted January 21, 2021 Author Share Posted January 21, 2021 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 More sharing options...
Christopher S Posted January 21, 2021 Share Posted January 21, 2021 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 More sharing options...
poobington Posted January 21, 2021 Share Posted January 21, 2021 Looks very nice mate, count me interested. Link to post Share on other sites More sharing options...
LHurlz Posted January 21, 2021 Share Posted January 21, 2021 Fascinating, I'd definitely take a copy! Link to post Share on other sites More sharing options...
Mr_Demus Posted January 21, 2021 Share Posted January 21, 2021 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 More sharing options...
right_winger Posted January 21, 2021 Share Posted January 21, 2021 And me, me! Good job @jtaylor1409 !!! Link to post Share on other sites More sharing options...
jtaylor1409 Posted January 22, 2021 Author Share Posted January 22, 2021 (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, 2021 by jtaylor1409 Link to post Share on other sites More sharing options...
Mr_Demus Posted January 22, 2021 Share Posted January 22, 2021 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 More sharing options...
jtaylor1409 Posted January 26, 2021 Author Share Posted January 26, 2021 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 More sharing options...
tsatsee Posted January 26, 2021 Share Posted January 26, 2021 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 More sharing options...
jtaylor1409 Posted January 27, 2021 Author Share Posted January 27, 2021 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 More sharing options...
tsatsee Posted January 28, 2021 Share Posted January 28, 2021 It is working now. Thanx for the work. It is a great tool. Link to post Share on other sites More sharing options...
jtaylor1409 Posted January 29, 2021 Author Share Posted January 29, 2021 Version 1.1 of the spreadsheet has just been released. See first post. 👍 Link to post Share on other sites More sharing options...
right_winger Posted January 30, 2021 Share Posted January 30, 2021 + Anyone knows whether this is because I play FM Touch or it shouldn't matter? Link to post Share on other sites More sharing options...
jtaylor1409 Posted February 2, 2021 Author Share Posted February 2, 2021 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 More sharing options...
jtaylor1409 Posted February 2, 2021 Author Share Posted February 2, 2021 Version 1.2 released - see first post. Link to post Share on other sites More sharing options...
bulldog Posted February 3, 2021 Share Posted February 3, 2021 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 More sharing options...
jtaylor1409 Posted February 3, 2021 Author Share Posted February 3, 2021 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 More sharing options...
jtaylor1409 Posted February 5, 2021 Author Share Posted February 5, 2021 Version 1.3 released featuring new layout design. 2 Link to post Share on other sites More sharing options...
Christopher S Posted February 5, 2021 Share Posted February 5, 2021 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 More sharing options...
jtaylor1409 Posted February 6, 2021 Author Share Posted February 6, 2021 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 More sharing options...
Kung Posted February 6, 2021 Share Posted February 6, 2021 Great job, very useful. Link to post Share on other sites More sharing options...
jtaylor1409 Posted February 10, 2021 Author Share Posted February 10, 2021 Version 1.4 released. 1 Link to post Share on other sites More sharing options...
Al Bundy Posted February 25, 2021 Share Posted February 25, 2021 Great job, was using something similar but yours is way advanced so I'm switching. Thanks Link to post Share on other sites More sharing options...
TelcontarTargaryen Posted February 25, 2021 Share Posted February 25, 2021 This is awesome, thank you. Link to post Share on other sites More sharing options...
jtaylor1409 Posted March 6, 2021 Author Share Posted March 6, 2021 Updated to v1.5 and many more features have been added. Link to post Share on other sites More sharing options...
Britrock Posted March 6, 2021 Share Posted March 6, 2021 Am I doing this wrong - if I change my DNA attributes on the dashboard sheet, they don't get updated on any of the other sheets and I have to go through and change them 3 times? If so I would recommend you set them up on one sheet and then just reference that list elsewhere Link to post Share on other sites More sharing options...
jtaylor1409 Posted March 7, 2021 Author Share Posted March 7, 2021 16 hours ago, Britrock said: Am I doing this wrong - if I change my DNA attributes on the dashboard sheet, they don't get updated on any of the other sheets and I have to go through and change them 3 times? If so I would recommend you set them up on one sheet and then just reference that list elsewhere That's a good point raised and isn't something I've tried out for myself as I use mine as is on the sheet. Will look into it further but makes perfect sense what you are saying. 👍 1 Link to post Share on other sites More sharing options...
jtaylor1409 Posted March 8, 2021 Author Share Posted March 8, 2021 Version 1.52 released! Link to post Share on other sites More sharing options...
cornal2169 Posted March 11, 2021 Share Posted March 11, 2021 Hi, having issues with some formulas updating. Link to post Share on other sites More sharing options...
woland Posted May 10, 2021 Share Posted May 10, 2021 (edited) On 08/03/2021 at 18:29, jtaylor1409 said: Version 1.52 released! Hi @jtaylor1409 i think you have error in your "stats" sheet. First two columns "A" and "B" are hide, so Technical Attributes are beginning from column "D", but in your formula it is "=AVERAGE(G3:T3)". So you calculate Agg, Ant and Bra as Technical, but do not calculate Cor, Cro and Dri. Obviously all another "average" like Mental and Physical are calculated wrong. Does this shift affect Role Ratings? By the way, you allow to change set of DNA attributes, but it is not affect "Stats" sheet. it has always your set. Also i have one small question. When you calculate Role Rating in "Squad" sheet, you always divide last attribute by some "magical" number. For example, in False 9 role, you divide Bal by 4,719. Why is that? Edited May 10, 2021 by woland Link to post Share on other sites More sharing options...
woland Posted May 12, 2021 Share Posted May 12, 2021 (edited) Hi @jtaylor1409 and another issue. in Abilities sheet DNA column has formula "=IFERROR(VLOOKUP($B4;STATS!$C$3:$BO$500;55;FALSE);0)*5" So we look in column 55 in Stats sheet for current player. Do you know what column has index 55? It is BC, "Men" column, not DNA, DNA is BE, index 57. Your file full of errors, mate, sorry. Edited May 12, 2021 by woland Link to post Share on other sites More sharing options...
drhay53 Posted July 3, 2021 Share Posted July 3, 2021 On 12/05/2021 at 07:15, woland said: Hi @jtaylor1409 and another issue. in Abilities sheet DNA column has formula "=IFERROR(VLOOKUP($B4;STATS!$C$3:$BO$500;55;FALSE);0)*5" So we look in column 55 in Stats sheet for current player. Do you know what column has index 55? It is BC, "Men" column, not DNA, DNA is BE, index 57. Your file full of errors, mate, sorry. the 55 counts from the first index of the array passed to the VLOOKUP, which starts on column C. Link to post Share on other sites More sharing options...
Christopher S Posted October 30, 2023 Share Posted October 30, 2023 On 20/01/2021 at 16:44, jtaylor1409 said: 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. virto.mp4 1.26 MB · 81 downloads Current version 1.5: Download here Updated Log v1.52 - Dropdown menu on the 'Scouting' tab for Positional Analysis now working. Updated Log v1.51 - Removed Link from the spreadsheet linking back to the previous file. - Made it so DNA only has to be input on DASHBOARD & SCOUTING pages ONLY. Update Log v1.5 – Addition of weighted attributes to increase the reliability of ratings. – Redesigned the look – Scouting aspect added. – Abilities tab expanded and the Comparison tab added. 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. Hey! Your download link is dead, any chance of a reupload? Link to post Share on other sites More sharing options...
Abaddon879 Posted October 31, 2023 Share Posted October 31, 2023 On 30/10/2023 at 16:16, Christopher S said: Hey! Your download link is dead, any chance of a reupload? I'm not the creator, but it looks like their website domain has expired. Here is a copy of the spreadsheet that I downloaded previously. Hope it helps. I still used it for FM23 so it's still useful. FM21 Player Roles Spreadsheet v1.52.xlsx 1 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