PESGaming Associates: Downloads Centre | Soccer Gaming
sponsored by: cedar park lawn service and landscaping
User Tag List

Reply
 
Thread Tools
Old 23-06-2018, 12:37   #1
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

FIFA -> PES stats converter

(Copy/paste of my evo web thread)

Hello, I tried to create a converter based on FIFA 18 (currently conversion has to be done manually), I would like to get some feedbacks on ratings/calculation.

FM converter is indeed very nice, but I think FIFA database fits more this kind of game

Thanks!

EDIT 25/06: many bugs corrected. Keepers' ratings is too low because of fifa calculation in terms of basic stats (passing/shooting/running,etc), I can't change anything. It looks like bad players in PES are very overrated when it comes to passing and stamina (even a sh***y guy has a 66) so I'll be kinder with low pass/lofted pass and stamina (especially for PES19)

NEW!
Automatic, you don't have to choose international/loan this kind of things. But there is a long loading time:
https://docs.google.com/spreadsheets...it?usp=sharing


!MAJOR UPDATE!
Now automatized process, just copy paste a sofifa player link (ex: https://sofifa.com/player/182521 ) in the right cell.

You must know if you're player is loaned or not (it's written on his page) and see if he's international or not.
LINK: https://docs.google.com/spreadsheets...it?usp=sharing

IF SOMEONE IS ALREADY USING IT, JUST COPY IT IN YOUR OWN DRIVE: "Files" -> "Create a copy"

How to choose the right category?




http://image.noelshack.com/fichiers/...5-capture4.jpg

23/06 update
- Tweaks performed on some formulas; should be more efficient.
- Added ALL FIFA traits. They do impact stats, player skills and COM playing style.
- Added COM playing styles.
- Goalkeeper stats converter added.

Old version (manual)
I don't own excel, tell me if it works by downloading it in google drive.
You can use it online or create a copy in your own drive (FILE -> Create a copy -> look for it in your own drive); it will work: https://docs.google.com/spreadsheets...it?usp=sharing
Fill everything under "FIFA player" with correct numbers, next to "skill stars" and "weak foot stars" with the digit only (4 for example), and every coloured squares next to traits with a "yes" (without capital or apostrophe) or leave it empty.
You just have to fill cells with thick borders in fact.


yoman38 is offline   Reply With Quote
Old 24-06-2018, 12:24   #2
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Major update!


Everything is now AUTOMATIC!
yoman38 is offline   Reply With Quote
Old 24-06-2018, 13:37   #3
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Doesn't work atm with player in loan or free agent; new versions will come this month

EDIT: corrected
yoman38 is offline   Reply With Quote
Old 05-07-2018, 15:26   #4
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Big update to formulas. Now consider the position. Only international/non international are up to date, I'll modernize loan/free agent by the end of the week
yoman38 is offline   Reply With Quote
Old 13-07-2018, 21:33   #5
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

now all in one file https://docs.google.com/spreadsheets...KUo/edit#gid=0
yoman38 is offline   Reply With Quote
Old 14-07-2018, 22:08   #6
beginner
Registered User
beginner's Avatar
  • Join Date: Nov 2011
  • Posts: 457

beginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfast

Thumbs up

Looks interesting.

Has anyone tested this???
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
beginner is offline   Reply With Quote
Old 15-07-2018, 22:37   #7
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Well it's not the exact same formulas (older version I think) and skills weren't taken into account yet, but here is an exemple: https://www.youtube.com/watch?v=1L4MpZ55FUw Not the best, I had better results with belgium or even France. Corluka is overatted and Lovren underrated I think, but hey; that's because of stat's spreading.


Btw new update, now it looks better
yoman38 is offline   Reply With Quote
Old 17-07-2018, 20:34   #8
beginner
Registered User
beginner's Avatar
  • Join Date: Nov 2011
  • Posts: 457

beginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfastbeginner is starting to get recognised at the PESGaming weekly breakfast

Quote:
Originally Posted by yoman38 View Post
Well it's not the exact same formulas (older version I think) and skills weren't taken into account yet, but here is an exemple: https://www.youtube.com/watch?v=1L4MpZ55FUw Not the best, I had better results with belgium or even France. Corluka is overatted and Lovren underrated I think, but hey; that's because of stat's spreading.


Btw new update, now it looks better
The formulas you use to convert the stats look very complicated.
Can you explain me, how you analyzed data and created that kind of formulas?
And how do you check, that conversion fits best for each category?

btw: I'm a bit impressed

EDIT: Can you also explain, why are there different sheets for "loan" and "international" players etc.??? Why do they need different formulas???
__________________

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
beginner is offline   Reply With Quote
Old 17-07-2018, 21:18   #9
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Quote:
Originally Posted by beginner View Post
The formulas you use to convert the stats look very complicated.
Can you explain me, how you analyzed data and created that kind of formulas?
And how do you check, that conversion fits best for each category?

btw: I'm a bit impressed

EDIT: Can you also explain, why are there different sheets for "loan" and "international" players etc.??? Why do they need different formulas???
First of all, the ambition was only to convert fifa stats to PES range (*60/100+40): 0-100 to 40-100.
Then I wanted to use multiple fifa ratings for one PES ratings, because there is less stats in PES. I started with a unique formula then after several tests everything was splitted to work with PES. Also, position is very much taken into account. Traits are important too, but they can only change a stat to +3/-3.

Unfortunaly I don't own excel and I face some troubles with importxml; that's why I ended up with different sheets. Because with =IMPORTXML(H16;"//li") I don't import only the stats, but also the squares just above with country/on loan/international rep and all this stuff. I don't need it (except weak foot) but I don't know how to import in more precise ways. Help required!
yoman38 is offline   Reply With Quote
Old 19-07-2018, 21:51   #10
ggdaris
Registered User
  • Join Date: Nov 2014
  • Location: Tucuman - Argentina
  • Supports: River Plate
  • PSN: send me MP
  • Posts: 1,502

ggdaris has discovered the General Forums. God help us.ggdaris has discovered the General Forums. God help us.

Quote:
Originally Posted by yoman38 View Post
First of all, the ambition was only to convert fifa stats to PES range (*60/100+40): 0-100 to 40-100.
Then I wanted to use multiple fifa ratings for one PES ratings, because there is less stats in PES. I started with a unique formula then after several tests everything was splitted to work with PES. Also, position is very much taken into account. Traits are important too, but they can only change a stat to +3/-3.

Unfortunaly I don't own excel and I face some troubles with importxml; that's why I ended up with different sheets. Because with =IMPORTXML(H16;"//li") I don't import only the stats, but also the squares just above with country/on loan/international rep and all this stuff. I don't need it (except weak foot) but I don't know how to import in more precise ways. Help required!
i used this formula =IMPORTXML(B3,"//ul") , beacuse if you said, the other formula import many things not necesary i think

here my own result, thanks for the idea, now i can use to do some teams i want and are in fifa

ggdaris is offline   Reply With Quote
Old 20-07-2018, 15:15   #11
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Quote:
Originally Posted by ggdaris View Post
i used this formula =IMPORTXML(B3,"//ul") , beacuse if you said, the other formula import many things not necesary i think

here my own result, thanks for the idea, now i can use to do some teams i want and are in fifa

Thanks for your formula, but I face the same problem: with an international player crossing for exemple will be in A10 and with a free agent in A5
yoman38 is offline   Reply With Quote
Old 20-07-2018, 17:11   #12
wyffy
Registered User
  • Join Date: Jul 2006
  • Location: Basque Country
  • Supports: Athletic Club, AC Milan
  • Posts: 108

wyffy is an unknown

Quote:
Originally Posted by yoman38 View Post
Thanks for your formula, but I face the same problem: with an international player crossing for exemple will be in A10 and with a free agent in A5
Try with =IMPORTXML(B3,"//a")
I think the stats positions will be the same in all of cases.
wyffy is offline   Reply With Quote
Old 20-07-2018, 18:57   #13
yoman38
Registered User
  • Join Date: Feb 2015
  • Location: France
  • Supports: Olympique Lyonnais
  • Posts: 88

yoman38 is an unknown

Quote:
Originally Posted by wyffy View Post
Try with =IMPORTXML(B3,"//a")
I think the stats positions will be the same in all of cases.
Yep, it doesn't import the useless text but unfortunaly even if there's a crazy amount of numbers they are not matching with stats
yoman38 is offline   Reply With Quote
Old 20-07-2018, 20:04   #14
wyffy
Registered User
  • Join Date: Jul 2006
  • Location: Basque Country
  • Supports: Athletic Club, AC Milan
  • Posts: 108

wyffy is an unknown

Quote:
Originally Posted by yoman38 View Post
Yep, it doesn't import the useless text but unfortunaly even if there's a crazy amount of numbers they are not matching with stats
Ok...
Then, why not scraping stat by stat, or all you want?
Do you know how Xpaths works?

For example, if you want to know the Crossing stat, put in a cell:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[1]/span")

If you want the Finishing stat:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[2]/span")

...
wyffy is offline   Reply With Quote
Old 20-07-2018, 20:15   #15
ggdaris
Registered User
  • Join Date: Nov 2014
  • Location: Tucuman - Argentina
  • Supports: River Plate
  • PSN: send me MP
  • Posts: 1,502

ggdaris has discovered the General Forums. God help us.ggdaris has discovered the General Forums. God help us.

Quote:
Originally Posted by wyffy View Post
Ok...
Then, why not scraping stat by stat, or all you want?
Do you know how Xpaths works?

For example, if you want to know the Crossing stat, put in a cell:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[1]/span")

If you want the Finishing stat:
=IMPORTXML(B3;"//div[3]/div[1]/div[1]/ul[1]/li[2]/span")

...
oh that be great, can you give a formular to take only this values



this is my stats converter
ggdaris is offline   Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 06:13.

Not yet a member? Register now.

.