Jump to content

Player Role Spreadsheet FM21 [UPDATE 1.5 RELEASED]


Recommended Posts

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.

Link to post
Share on other sites

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! :)

Link to post
Share on other sites

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

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 by jtaylor1409
Link to post
Share on other sites

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

On 30/01/2021 at 19:20, right_winger said:

jt_view.PNG.ecb454f7ccd0eebe482b2e4c528c5a84.PNG+

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

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

 

Link to post
Share on other sites

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 changed the title to Player Role Spreadsheet FM21 [UPDATED 1.3 RELEASED]
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

  • jtaylor1409 changed the title to Player Role Spreadsheet FM21 [UPDATE 1.4 RELEASED]
  • 2 weeks later...
  • jtaylor1409 changed the title to Player Role Spreadsheet FM21 [UPDATE 1.5 RELEASED]

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

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. 👍

Link to post
Share on other sites

  • 1 month later...
Posted (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 by woland
Link to post
Share on other sites

Posted (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 by woland
Link to post
Share on other sites

  • 1 month later...
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

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

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...