|
[Full Release 1.0] FIFA Database
|
| coolrex |
Posted on 02-03-2015 15:37
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
sgdanny wrote:
Tbh your never gonna find a correct formula, so try one out and see if it works 
yeah that's what we are doing, we trying stuff.
and please don't double post LOL  |
| |
|
|
| knockout |
Posted on 02-03-2015 19:49
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
Spoiler https://pcmdaily.com/forum/viewthread.php?thread_id=38030&rowstart=140#post_1027781
Okay. To add to the discussion about my stat table
coolrex wrote:
yeah but what is the formula.
and i don't know if this is perfect.
I can answer this pretty easily. It isn't. It was just some input motivating you to work more on the stat formulas since it is possible to do better than what you had done before.
because that list you let us see.
has no formula or sense for anything.
It was just meant as an example of what could be possible.
I had formulas behind it:
Flat=Average/100* Strength/100*35+52
MO=Average/100* #SHO/100*35+52
HI=Average/100* #DRI/100*35+52
TT=Average/100* Heading Accuracy/100*35+52
PRL=Average/100* Jumping/100*35+52
COB=Average/100* Aggression/100*35+52
SP =Average/100* #DEF/100*35+52
ACC = Best of (Average/100* Interception/100*35+52) AND (Average/100* #PAC/100*35+52)
DH = Balance/100*35+52
FIG = Free Kick Accuracy / 100 * 35 +52
STA=Average/100* STA/100*35+52
REC=(#DEF+#PAC+#SHO+#DRI+#PHY+#PAS)/6*0,01*35+52
It is far from being perfect but it is a start for improving.
The ones with # are stat packages that i took from the UT cards but could get calculated with the normal stats, too. Jesleyh posted the formulas of them so you could replace those with these.
A few things I do not like about the formulas:
- Too many SP-TT combination.
- Some midfielders are too allround.
- I have no solution for goalkeepers. propably would end up as pure time-triallists.
- Passing should be included but i don't know where to put it. A possibility could be REC/RES since i didnt have any formula for RES and the variety in RES is too low.
- COB / DH / FIG could be overdone, too, since the stat combos are sometimes a bit off.
-> Fighter = something with the work rate? perhaps like this:
High/High = 78
High/Medium & Medium/High = 73
Medium/Medium = 68
Medium/Low & Low/Medium = 65
Low/Low =62
DH should be something that has not much too do with the overall ability of a player.
Bolly needs much more Sprinting
Akinfenwa needs to have the best Cobble
As Jesleyh pointed out I think this must not be the case.
In football the big stars are mostly the strikers or do you think Sergio Ramos/Mats Hummels/Philipp Lahm would have any chance against Messi/Ronaldo/Zlatan/... in a voting for best player? No.
In cycling the media attention is mostly on the GC riders so the superstars of football should be GC riders in your DB as well.
On top of that, it would seem ridiculous to me to see 195cm players battle each other up the Alpe d'huez while the 165 cm players are the best sprinters. Does not look right to me.
On the other side it would be ridiculous to see 4th UK league tanks and 2nd German league players compete for the monuments. This just is wrong. They should be not much over 70s in stats.
but we won´t do the FIFA Ultimate Team Cards Stats.
Those aren´t right calculated by FIFA, and are renamed to 1 stats.
like Pace = what you think speed and acceleration. but you´re wrong.
its also their agility and shit. so FIFA can´t do the math if you know what i
Actually, I think it is pretty cool if other stats are included in there instead of just one stat.
And i dont care if you take the stats from UT, FIFA or FM. It was just an idea of how to create the stat matrix 
@jerseys/stages/graphics/... Just focus on the very basics for now. It will be an immense amount of work already. You should concentrate on the cdb for now before adding anything more than needed. Otherwise the chances of releasing anything will be much more closer to 0% than it already is.
-----------------------------------
As said above all of this is just to give you some input and ideas. Take out what you want and ignore the rest. I just want to help a bit here since I will not help at all for the rest of the project.
In your position I would also think about making only a WT beta for now since you can then change some things better and it is easier to keep the motivation before doing 100 teams instantly.
Best of luck with this project. *flies away*
A Big Thank You To All MG Reporters! |
| |
|
|
| coolrex |
Posted on 02-03-2015 20:06
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
coolrex wrote:
@jesleyh maybe this could be the stat formulas:
Attackers:
Finishing - FL
Agility - ACC
Speed - CLI
Acceleration - HIL
Shotpower - PRO
Longshots - TT
Heading - DWH
Aggression - FTR
Stamina - STA
Balance - RES
SP = avg / 2 + 30
REC = (STA + (avg/2)) / 2 + 40
COB = Strength - 10 (Except for Akinfenwa)
Midfielders:
Long Passing = CLI
Short Passing = HIL
Long Shots = TT
Shotpower = PRO
Sprintspeed = SP
Acceleration = ACC
Heading = DWH
Aggression = FTR
Strength - 5 = COB
Stamina = STA
REC = (STA + (avg/2)) /2 + 40
RES = Balance
FL = Finishing ???
Defenders:
Heading = CLI
Marking = HIL
Standing Tackle = PRO
Sliding Tackle = TT
Reactions = ACC
Interceptions = FL
Strength = COB
Sprintspeed - 7 = SP
Acceleration = DWH
Aggression = FTR
Stamina = STA
Balance = RES
REC = (STA + (avg/2)) /2 + 40
Goalkeepers IDK YET!
Attackers do Climbing / Hills
Midfielders do Sprinting
Defenders do Cobble / Hills
Goalkeepers IDK YET!
Would this not be easier, and more related to the real world.
maybe this is just better, but i don't know what you think.
i don't like that big formula you jsut wrote.
just to complicated and most stats aren't related to each other.
idk what we gonna choose but it will be a hell of a discussion further
also you're formula is too much with Average, it will fuck the stats.
2nd i see some formula's
where some fifa players will get stats below 40.
so this is not the perfect way to do.
Edited by coolrex on 02-03-2015 20:09
|
| |
|
|
| Jesleyh |
Posted on 02-03-2015 20:56
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
I really like the way knockout thinks here and kinda agree with him.
Sure there might be stats under 50 his way but there's a solution for everything.
His formulas are not complicated. Wait for my formulas 
Taking average into account might not be a bad idea, as said we do not want Bolly and Akinfenwa to own the world of cycling.
By the way I made an extremely helpful Excel spreadsheet which I will link when I'm done. Basically I can make the formulas as complicated as I want but all you'd have to do is fill in their sofifa stats and everything will be generated automatically.
I'm definitely not done yet but here's a small preview(Just so you don't think I'm not working on it  )
https://prntscr.co...
Edited by Jesleyh on 02-03-2015 20:58
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| coolrex |
Posted on 02-03-2015 21:00
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
Jesleyh wrote:
I really like the way knockout thinks here and kinda agree with him.
Sure there might be stats under 50 his way but there's a solution for everything.
His formulas are not complicated. Wait for my formulas
Taking average into account might not be a bad idea, as said we do not want Bolly and Akinfenwa to own the world of cycling.
By the way I made an extremely helpful Excel spreadsheet which I will link when I'm done. Basically I can make the formulas as complicated as I want but all you'd have to do is fill in their sofifa stats and everything will be generated automatically.
I'm definitely not done yet but here's a small preview(Just so you don't think I'm not working on it )
https://prntscr.co...
jesleyh's thing looks the nicest of all
Yeah Chiellini!!!!!!
but akinfenwa still gets high cobble, and bolly much sprint.
but they both have so low stamina that they wont win Paris - Roubaix for example. |
| |
|
|
| TheManxMissile |
Posted on 02-03-2015 21:02
|
Tour de France Champion
Posts: 18187
Joined: 12-05-2012
PCM$: 0.00
|
Basically Akinfewa is a Bakari and Bolly is a Bos/Thorsen
|
| |
|
|
| coolrex |
Posted on 03-03-2015 09:18
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
TheManxMissile wrote:
Basically Akinfewa is a Bakari and Bolly is a Bos/Thorsen
For the moment i don´t know who bakari is,
but bolly being an theo bos can be true, although he is the best sprinter, bolly not bos |
| |
|
|
| Ian Butler |
Posted on 03-03-2015 09:21
|
Tour de France Champion
Posts: 21854
Joined: 01-05-2012
PCM$: 400.00
|
TheManxMissile wrote:
Basically Akinfewa is a Bakari and Bolly is a Bos/Thorsen
Genius |
| |
|
|
| coolrex |
Posted on 04-03-2015 16:12
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
Jesleyh wrote:
I really like the way knockout thinks here and kinda agree with him.
Sure there might be stats under 50 his way but there's a solution for everything.
His formulas are not complicated. Wait for my formulas
Taking average into account might not be a bad idea, as said we do not want Bolly and Akinfenwa to own the world of cycling.
By the way I made an extremely helpful Excel spreadsheet which I will link when I'm done. Basically I can make the formulas as complicated as I want but all you'd have to do is fill in their sofifa stats and everything will be generated automatically.
I'm definitely not done yet but here's a small preview(Just so you don't think I'm not working on it )
https://prntscr.co...
what is you're progress already?
have you find the right formula for everything? |
| |
|
|
| Ad Bot |
Posted on 24-11-2024 18:21
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| knockout |
Posted on 04-03-2015 16:13
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
coolrex wrote:
Jesleyh wrote:
I really like the way knockout thinks here and kinda agree with him.
Sure there might be stats under 50 his way but there's a solution for everything.
His formulas are not complicated. Wait for my formulas
Taking average into account might not be a bad idea, as said we do not want Bolly and Akinfenwa to own the world of cycling.
By the way I made an extremely helpful Excel spreadsheet which I will link when I'm done. Basically I can make the formulas as complicated as I want but all you'd have to do is fill in their sofifa stats and everything will be generated automatically.
I'm definitely not done yet but here's a small preview(Just so you don't think I'm not working on it )
https://prntscr.co...
what is you're progress already?
have you find the right formula for everything?
It's 42.
A Big Thank You To All MG Reporters! |
| |
|
|
| coolrex |
Posted on 04-03-2015 17:08
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
knockout wrote:
It's 42.
WTF are you talking about |
| |
|
|
| the_hoyle |
Posted on 04-03-2015 17:16
|
Grand Tour Champion
Posts: 7651
Joined: 28-05-2009
PCM$: 200.00
|
knockout wrote:
It's 42.
Hahaha I get it! Geek trolling!
Edited by the_hoyle on 04-03-2015 17:22
.: Manager of :.
.: My Awards :.
 |
| |
|
|
| matt17br |
Posted on 04-03-2015 18:58
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
coolrex wrote:
knockout wrote:
It's 42.
WTF are you talking about
https://en.wikipedia.org/wiki/Phrases_...g_.2842.29
|
| |
|
|
| knockout |
Posted on 04-03-2015 20:30
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
the_hoyle wrote:
knockout wrote:
It's 42.
Hahaha I get it! Geek trolling!
The worst thing is that I did not even watched the movie
A Big Thank You To All MG Reporters! |
| |
|
|
| Jesleyh |
Posted on 04-03-2015 20:36
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
I'm practically done, coolrex.
Will try to share everything tomorrow.
Although there are a few flaws in the formulas(I did test some ''extreme'' examples though, like Mertesacker, so there's bound to be flaws).
You'll need to edit some players manually when done, but I'm trying to limit the amount of that, most players should have good, playable stats.
Also finished up a formula for GKs which somewhat works I think, although most are either TTists that can cobble well or cobblers that TT well, couldn't really seperate that well.
Edited by Jesleyh on 04-03-2015 20:37
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| Jesleyh |
Posted on 05-03-2015 15:40
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Alright there we go.
First things first, here's the spreadsheet.
https://www.mediaf...mulas.xlsx
All you gotta fill in is names, overall(& pot, but pot is not used for stats but could be used for PCM potential in the future) and the Fifa stats.
Keeper have a seperate thing to fill in(in the bottom).
Stats will automatically get generated. You just gotta copy the formulas(just copy over Messi's PCM stats and stuff) to the rows of the next players you want to fill in(and it will automatically make the formulas work on the line you want, e.g. copy Messi's E5-Q5 to E33-Q33 and it will automatically generate the stats from line 33.
Second up, here's 2 pics of the result:
https://prntscr.co...
https://prntscr.co...
Well I could give the formulas but they're fucking complicated and are already in the spreadsheet, so I could better just tell what every PCM stat relates to.
I'll tell it from heavy to light influence.
FL: Strength, Overall, Defence, Stamina, Size, weight.
MO: Shooting and a little bit overall
HI: Dribbling, Passing, little bit overall
TT: Heading accuracy minus a little bit of defending(to make sure the defenders don't get too overpowered but the targetmen are good)
PRL: Lots of Jumping, some size(to compensate for giants that don't jump) and overall.
COB: Lots of Physical, some FL actually and negative MO correlation(was the only way to get guys like Ibra and Diego Costa not as COB favourites)
SP: Lots of defending and some pace.
ACC: Lots of pace and also very depending on the PCM SP stat. A small correlation with HI to top it off.
DH: Balance and weight
FTR: Aggression and overall
STA: Overall(lots actually) and Stamina
RES: Overall, and some FL and ACC
REC: Overall, MO and SP
Keepers:
FL: Overall, kicking, size, kg
MO: Strength, Overall, reactions and negative correlation with size.
HI: Jumping, Reactions, overall and negative correlation with size
TT: Diving & Overall
PRL: Reflexes & Overall
COB: Mainly positioning, also handling and FL
SP: sprint speed
ACC: Acceleration
DH: Handling
FTR: Aggression
STA: Stamina & Overall
RES: FL, TT & COB
REC: Mountain and overall
Note that GKs are designed to be TTists or cobblers. Their MO & HI stats will be quite low by default and only in rare cases they are good sprinters.
Some weird stuff in there, I admit, but most of it worked out.
Few things I'm unhappy with.
The keepers are a tad too allround, I mean, they're often both good at TT and COB and not often only in both of those.
Also guys like Ibra, Hulk and Diego Costa are too good at cobblestones.
There are some flaws, and there will be flaws.
There will also be some <50 stats, but with some ''clever'' formulas I hope that I've limited that to a minimum.
Truth is that it's very hard to convert Fifa to PCM, but overall I'm pretty damn happy with the results.
I suggest that when you get a few weird results, you don't go fix the formula but just note it down and edit the PCM stats manually when you're done. Balancing the stats took me a shitload of time and you might not want to lose that
Of course when it goes outta hand you can change it how you like, it's your DB after all. Just make sure to respect the time I spent
Edited by Jesleyh on 05-03-2015 15:41
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| Jesleyh |
Posted on 05-03-2015 15:49
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Had to be done to balance it out I'm afraid.
Obviously I can't make that difference when looking at kgs(although obviously strength stat definitely compensates for that
Don't forget that you can always edit specific cases after you're done anyway. These formulas will be sufficient for most players but there'll be a few that you want to adjust, for some reason
Edited by Jesleyh on 05-03-2015 15:50
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| coolrex |
Posted on 05-03-2015 15:52
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
Jesleyh wrote:
Had to be done to balance it out I'm afraid.
Obviously I can't make that difference when looking at kgs(although obviously strength stat definitely compensates for that
Don't forget that you can always edit specific cases after you're done anyway. These formulas will be sufficient for most players but there'll be a few that you want to adjust, for some reason
Nice job,
but do you really need to fill in card stats?
because card stats are the wrongest calculation made by fifa ever
(sorry had to delete last post  )
Edited by coolrex on 05-03-2015 15:52
|
| |
|
|
| Jesleyh |
Posted on 05-03-2015 15:53
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
You don't need to fill in card stats, they are calculated automatically.
Yes they are used for a few calculations, but imo they are actually calculated pretty well and I'm quite happy with them and their outcome.
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
| |
|
|
| coolrex |
Posted on 05-03-2015 16:03
|
Protected Rider
Posts: 1168
Joined: 01-01-2015
PCM$: 300.00
|
Jesleyh wrote:
You don't need to fill in card stats, they are calculated automatically.
Yes they are used for a few calculations, but imo they are actually calculated pretty well and I'm quite happy with them and their outcome.
ok nice job, i already saw that the card stats are calculated themselves,
this looks very nice.
with potential you mean that potential 8 = fifa potential above 90? |
| |
|
![imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg](https://imgur.com/KlJUqDx.jpg[/img[img]]https://imgur.com/yUygrQ.jpg)
