About the author

Ewan Currie

Self confessed geek. I once unintentionally climaxed upon the discovery of a new excel function; true story, but please keep this to yourself. Anyone who spends a significant amount of time with me finds me disagreeable (according to my mum). EA data reviewer for Kilmarnock & Hibernian

Related Articles

73 Comments

  1. 1

    PK

    Awesome table, Ewan. I’m not sure if I agree with all your choices for “top 4″ and “secondary 5″ attributes for each position, but I guess it depends on each person’s style of play.

    Nevertheless it’s a great tool to see which players are overrated/underrated. It makes me want to make my own formula that I can use when building my teams! Cheers.

    Reply
    1. 1.1

      Colin

      i too would like those spreadsheets if i can get them

      Reply
  2. 2

    Ewan Currie

    Cheers PK. I can give you the raw spreadhseets and show you how to formulate your own rating system if you’d like.

    Reply
    1. 2.1

      PK

      Sure, it would be fun to fool around with it

      Reply
    2. 2.2

      Steve Brookes

      This is awesome Ewan.I only play with bronze could you give me the raw spreadsheets and how to formulate my own rating system.This is exciting.

      Reply
      1. 2.2.1

        Ewan Currie

        Steve, I’ll email a link to a file that has a filter on the Fifa “Overall” stats so you can then filter for players who are only bronze. Leave it with me

        Reply
      2. 2.2.2

        Ewan Currie

        There are now filters on all columns. To see only bronze players, click on the Overall column, select number filters, then less than and put in 65.

        Reply
    3. 2.3

      PF

      Could I also get a copy of the spreadsheet? its so useful!
      Or maybe you could make the file downloadable?

      Reply
  3. 3

    Rory Mcgowan

    Thanks Ewan i really like this table i was wondering if you could send me the raw spreadsheets so i could define the attributes that define the Z score to heading, strength, tackling etc for defenders and have a unique Z score system for each position in the game. i think this is a great idea and i think it would be great to for people looking a building teams.

    Reply
    1. 3.1

      Ewan Currie

      Hi Rory, I am happy to do this for you and send you a link to the modified sheets. Can you let me know what you would like changed?

      Reply
  4. 4

    Chico Dudu

    Nice.

    Cheers From Rio de Janeiro.

    Reply
  5. 5

    John Wilson

    Its a nice table some players i knew were better than there rating and a few that i will need to try looking at this, am not sure it works that well for strikers i dont find longshots that important and some players get hammered for it i.e Matri who is great in the game. But great effort and really useful so thanks!!

    Reply
  6. 6

    John Wilson

    Not sure how this would affect ur scores but if u swapped positioning for longshots it might show how players are at ST and comparing the two scores from there might show wht players are better ST and which are better CF’s. Hope that made sense.

    Reply
    1. 6.1

      Ewan Currie

      Hi John, thanks for your feedback. I have e-mailed you a link to sheet with your desired information. Let me know if I can help with anything else.

      Reply
  7. 7

    Ewan Currie

    Thanks for all the feedback. John I will send you a link to a spreadsheet with your request (Matri moves from a 76 to 79). I am working on the other requests for the raw spreadsheets so please bare with me. Cheers.

    Reply
  8. 8

    Rob

    Great table, really useful. Could I trouble you to email me the spreadsheet with the raw data please? I’d like to alter it slightly based on how I play, for example the sliding tackle stat is not of use to me as I tackle pretty much exclusively with the contain buttons. Thanks, much appreciated.

    Reply
    1. 8.1

      Ewan Currie

      Hi Rob, I am happy to do this for you and send you a link to the modified sheets. Can you let me know what you would like changed?

      Reply
  9. Pingback: .:: FIFA 13 News ::. |

  10. 9

    Iltisanni

    Hey,

    Nice Table but something is wrong with your Heading/Jumping Column I think….

    Reply
    1. 9.1

      Iltisanni

      At the CB Position

      Reply
  11. 10

    Sam

    Hey buddy great work. Miccoli was always good, I knew it. Can you please tell me what is the z score of In Form Miccoli.

    Reply
    1. 10.1

      Ewan Currie

      Sorry I don’t have access to the stats for in form players.

      Reply
  12. 11

    Iltisanni

    Where did you get all the players and stats from? I wanted to add the correct heading stats for cb position but you have much more players in your table than http://ultimatedb.nl/ for example has….

    Reply
    1. 11.1

      Ewan Currie

      “The following information is taken from the standard database of the PC version of FIFA 13″ – I had to extract the data from big files included with the game, and then import into excel and did a lot of work to pull all the information together.

      I think you’re right, I have made a mistake with the CB Heading/Jumping stat. I will correct this this morning for you.

      Thanks for your input.

      Reply
    2. 11.2

      Ewan Currie

      Once again Iltisanni, thanks for spotting this for me. I have now amended the tables to correct this and also made them easier to view and sort. Cheers

      Reply
  13. 12

    speedwayy

    Could you please send me the excel sheet? I want to use it offline, to discover new players when i dont have internet connection, thanks a lot!

    Reply
  14. 13

    Brent Curry

    This is great stuff. Thank you or the work!

    I am not sure what you had to do to get the data out of the system but I was wondering two things.

    a) First, I would love to get the raw data if you can share that
    b) Is there any way to get this data but specific to FUT players and include In-Form versions?

    I’ve seen some pretty large differences in stats in at least a few instances

    Reply
    1. 13.1

      Ewan Currie

      Hi Brent. As I stated in the overview, the information was obtained from the PC version of Fifa 13. This involved extracting various files from the installation files and then building my own database from the content and importing the relevant information into Excel

      I was unaware there were “large differences” in the stats, can you please back up your claims with examples?

      At present I have no way to exclusively filter “FUT” data so I can not include in form players. If you let me know what you want to see in the tables I am happy to do this work for you.

      Reply
      1. 13.1.1

        brent Curry

        Ewan,

        Yep I’ve been trying to find the players where the stats seemed strange. For some reason Soldado stands out in my mind (maybe Llorente as well I can’t recall now) but the stats look correct now the only discrepancy i see now would be how is it Soldado isn’t on the Top50 Headers page :-)

        Any chance I can get a copy of the raw data that shows all the columns of stats per player? I love what you’ve done combining certain stats but sometimes I am finding that I wish more stats were on the page. For instance not being able to see Heading/Jumping stats on the ST/CF page has come up for me, or wanting to see Strength as well. The Top50 Headers tab has helped but I’m just the kind of guy who likes to play in the data sometimes.

        Reply
  15. 14

    Lee Hutchinson

    Hello fifa, im sorry to bother you but my fifa 13 online (FUT) has been playing up the past 2 weeks, in the middle of games its signing out of fifa and i have lost a lot of coins and contracts. Im a fut founder and i had no difficulties before. Second of all today i bought a premium pack with my money it worked, but my second pack dissaperd, in the pack i had a few contracts and stuff i had 2 gold normal players then i had inform fnaymar da silva then ea server went of, i got back on a few minutes later and my pack was nowere to be seen, i am discusted, can you help?

    Reply
    1. 14.1

      Ewan Currie

      Hello. First of all, this is a fan based website. No one here is associated or employed by EA or FIFA. I would suggest you direct your complaints to EA thought the relevant channels.

      Reply
  16. 16

    Ivan

    Thanks for sharing this, really helpful.

    Can you provide an offline excel of this?
    Also, you mentioned key attributes for each position, would you please list all attributes used for each position?

    thanks

    Reply
  17. 17

    Ivan

    sorry, ignore my request, I have just realized that the attributes are listed.

    Would you still provide a downloadable offline excel sheet?

    thanks

    Reply
  18. 18

    Chris

    I really appreciate the work you put in to this and also interested in obtaining a copy of the spreadsheet. Would you mind e-mailing me a copy as well?

    Many thanks.

    Reply
  19. 19

    Jake

    This is a great idea and I loved it. Keep up the good work.

    Reply
  20. 20

    Philipp

    Hello Ewan,
    great work. Was thinking to do something alike, but since I only have the PS3 Version it would be a lot of work to get all the data out of the system. Is there a way you could send me the raw excel data? Or can someone else do that? I would like to include traits into the data and give them points to help me with my decisions.

    Reply
    1. 20.1

      Ewan Currie

      Hi Philipp. Thanks for your feedback! To get the data into excel took a lot of work, and unfortunately I don’t have the trait information converted. I have the “raw” trait stats, but unfortunately this is just a long string number that I couldn’t easily correlate; even players with the same trait have a different number which I can’t work it out, and none of the database tables appear to contain information on these traits. To give you an example of what I mean, for a players preferred foot they either had a 1 or 2 in the database. I looked at Ryan Giggs, he has a 2, so I know all players with a 2 were left footed. The trait information is not that simple unfortunately. The numbers range from nul to 134545408. For the other stats I could find a table I needed to refer to so I could understand what this number meant, but as I said no such “traits” table appears to exist.

      Reply
      1. 20.1.1

        Philipp

        Hey Ewan,
        at the moment I am doing the table all by hand – so anything you could provide me with would be greatly appreciated. I would probably type in the traits etc. by hand for the top players that I am interested in.

        I can understand that you don’t want to give away the table that you worked so hard on, just to any stranger… I just want to make sure to build up a good squad at FUT :-) and because of my work, I don’t mind using large excel tables for that :-/

        Anyway I think you did a great job. Maybe if you don’t want to share the raw excel sheet, you could just provide all the players with all stats and people could weight the corresponding attributes/skills etc. on their own, depending on their style of play. In an excel that would be pretty easy and from that point on noone would need the raw excel sheet anymore – and your homepage would probably get a lot of hits :-)

        Just as a thought…

        Reply
  21. 21

    Sam

    Hey Ewan,

    I have been having such a tough time trying to sort out a dream team based on stats because it just not possible to filter based on specific stats.

    i would love a copy of the raw data sheets so i can form my own overall ratings. Would you kindly forward me a copy.

    I would be happy to give you my feedback as well once i have a look at it.

    Thanks a bunch

    Reply
    1. 21.1

      Ewan Currie

      Hi Sam,

      Sure you can filter on the stats, just click the down arrow next to the header. You have equal to, less than, greater than or any custom filter.

      Reply
  22. Pingback: Melhores jogadores no modo UT | Arte Virtual Futebol Clube

  23. 22

    MAX

    Hi ewan. Good system. Please could you email me the raw spreadsheets because id like to make my own system. Thanks a lot
    Max

    Reply
  24. 23

    Jeff Dieffenbach

    Hey, Ewan,

    Please email me the raw spreadsheet. Thanks much.

    Jeff D.

    Reply
  25. 24

    BETVAZ

    Hey, Ewan,

    Please email me the raw spreadsheet. i can’t see the ZRating List

    Thanks much

    Betvaz

    Reply
    1. 24.1

      Ewan Currie

      It’s the column called “Z Rating”, next to the FIFA overall rating. It’s highlighted in yellow, the green numbers indicate their Z Rating is higher than their FIFA rating, and red numbers is the opposite.

      Reply
  26. 25

    Todd7

    Excellent spreadsheet. Now, if only I can make up my mind on what I’m looking for in a team….

    Reply
  27. 26

    paddy

    it only gives goalkeepers

    Reply
    1. 26.1

      Craig Cole

      Use the tabs at the bottom of the spreadsheet to see other positions.

      Reply
  28. 27

    Livefyre

    Use the tabs at the bottom of the spreadsheet to see other positions.

    Reply
  29. 28

    guest

    This is great and very useful, how often is this updated?

    Reply
    1. 28.1

      Ewan_Currie

      Hi, this was created when FIFA 13 was released. Player’s stats don’t change all that much, except for “In Forms” etc.

      Reply
  30. 29

    stefan

    Great work! I’m really going to test this on my FUT team!
     
    I’ve one suggestion to make this better. Implement also other important stuff into your calculation like heigt, work-rate, weak-foot and skill level.
    Because for example heigt is, in my opinion, one of the most important attributes for a keeper.

    Reply
    1. 29.1

      Ewan_Currie

      Hi Stefan. Thanks for your comments. I tired to stick to a limited number of attributes (4 primary and 5 secondary) so it was easy for people to understand the rating system. I agree that some of the “physical” stats can be important, but there are too many to include them all in the calculation. I agree that height can be important for a keeper, but I don’t agree that it’s 1 of the most important stats. De Gea is a decent goalkeeper in the game with a height of 192. Casillas is a tremendous keeper with only a height of 185. 
       
      If you let me know how you would like the stats calculated I would be happy to create a version for you. Let me know

      Reply
  31. 30

    no skill just luck

    hopefully this helps but I’ve found out that the best rated team AND SUBS it’s this. squad: full toty 4-3-1-2 with messi as cf and Ronaldo as lf. subs: if ribery-91, if rooney-90, if ibrahimovic-89, if David silva-89, normal vidic-89, if thiago silva-88 and if fabregas.

    Reply
  32. 31

    no skill just luck

    oh and by the way the team costs millions

    Reply
  33. 32

    RayZ

    Ewan, thanks for all of your hard work…I like to keep it simple, so your spreadsheet fits the bill perfectly. All the stats that are needed are a mouse click away, well put together and thought out. Awesome job. No request for an “offline version”, don’t need it, I just bookmarked your page!  Thanks again!  Ray

    Reply
    1. 32.1

      Ewan_Currie

      @RayZ

      Reply
    2. 32.2

      Ewan_Currie

      @RayZ Thanks for the feedback, it’s refreshing to get a comment that is all positive :)

      Reply
  34. 33

    Sushil

    Thanks for posting the File. Managed to Download the Fifa13_ZScore.xlsx from the post. I think you need to account for week foot for striker as a secondry rating may be a column AA2 ==IF(Y6>4,”100″,IF(Y6>3,”90″,IF(Y6>2,”80″,IF(Y6>1,”70″,”60″))))

    Reply
  35. 34

    totyheskey

    This is so helpful, i would’ve never thought marco rues was so good without this. Thanks for making this, it looks like you put a lot of hard work into it.

    Reply
  36. 35

    Answer Me Pls

    Can you think of any CM in the BPL that would work well as a CDM, and what do you think their rating will be as a CDM?

    Reply
    1. 35.1

      Ewan_Currie

      @Answer Me Pls Leave this with me and I’ll have a look for you

      Reply
      1. 35.1.1

        Ewan_Currie

        Ok I’ve had a look for you and below is a list of the top Z rated CM/CAM in the EPL with the CDM formula applied:
        Yaya Touré – 85
        Marouane Fellaini – 80
        Darren Fletcher – 80
        Mohamed Diamé – 79
        Ramires – 79
        Tom Huddlestone – 79
        Abou Diaby – 78
        Steven Gerrard – 78
        Michael Carrick – 78
        Jack Wilshere – 78
        Yohan Cabaye – 77
        Lee Cattermole – 77
        James Milner – 77
        Alejandro Faurlín – 77
        Jack Rodwell – 76
        Steve Sidwell – 76
        Moussa Dembélé – 76
        Dean Whitehead – 75
        Raúl Meireles – 75
        Alexander Tettey – 75
        Leon Britton – 75
        Steven Davis – 75

        Reply
        1. 35.1.1.1

          Answer Me Pls

          Ewan_Currie Thank you so much

          Reply
  37. 36

    PanchoBachofner

    how do you filter
    f.ex. if you wanna search for Bundesliga only

    Reply
    1. 36.1

      Ewan_Currie

      PanchoBachofner Click on the down arrow next to League then on filter and it will let you select the specific league you are interested in

      Reply
  38. 37

    Danilo Herrera

    How do I download it?

    Reply
  39. 38

    Quick Question

    Will there be a Fifa 14 version of this?

    Reply
  40. 39

    Craig Cole

    @Quick Question Hopefully. I spoke to Ewan the other day and he’s got something in the works.

    Reply
  41. 40

    Brent Curry

    Any chance you’re doing this for FIFA14?

    Reply
  42. 41

    Brent Curry

    Craig Cole Sorry i didnt read before I posted

    Reply
  43. 42

    chris_nimmer

    Can you do this for fifa 14?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *


2014 Powered By Wordpress, Goodnews Theme By Momizat Team