Possibly helpful look at 'form'

[DrEvil1996]

Hey guys, I saw the chart about how different form arrows affect player ratings so I decided to make an excel spreadsheet to automatically change player ratings based on their 'form'. It ended up much more complicated than I imagined and I'm sure there are errors and problems, but I thought I'd post what I have after a half-day's work (still a work-in-progress).

http://rapidshare.de/files/24335488/Winning_Eleven_Spreadsheet.xls.html

Here's the idea: on the lineup sheet, you fill in your roster with player names/positions (which automatically update to the other sheets, although it is set up for my formation of 4-5-1 so you may have to do some shuffling to save time if you have more strikers). Anyway, from there you have to enter in all the ratings for your players on the next three sheets under the 'NORMAL' columns. Then, on the lineup sheet, click on the circles to indicate the form of each player. Assuming you have entered everything in, that should automatically update each 'W/ FORM' column to show you the new player ratings after taking form into account. Some ratings are made bigger to indicate what I feel to be most important for that position, although I may make more detailed changes to that later.

This is all based on the chart values (found in the multipliers sheet) from here and PESfan. Even if you don't want to waste the time putting names/ratings in there, it may be helpful to take a look at how my ML team looks to get an idea of how form really changes the player ratings. Things can change quite significantly, as you can see from the file.

Sorry if this is old news or has been done before, I looked but didn't find anything similar. I'm kinda new to WE, just picked up WE9 here in the states after having WE8 and getting caught up in the World Cup. What a great game!

Lastly, if this is actually something new and useful, please make/suggest edits, ask questions, provide feedback, and point out problems. I'm not the best with Excel (obviously), and if this is useless at least it gave me a chance to play around with Excel a bit and learn random stuff.

Thanks.

Edit: Just to be clear, the goal of this little project was to have a better idea of who to put in the starting lineup each game when you have a few players of similar ability. This at least gives some numbers to look at when deciding.

 

[123gamer321]

What the heck are you bazzling about?

 

[Huw]

I see what you are doing but is it really worth all that effort ? That must have taken you ages

 

[DrEvil1996]

It took me basically a couple hours at work while I was bored and an evening of fiddling with it while watching TV. If I thought it would take much longer I probably wouldn't have done it.

It just took time to figure out how to make excel give me the right output, after that it wasn't difficult. The formulas are all cut and paste.

I think it takes around 30 minutes to enter in all the player names/ratings, so that's the time you can put in to use this. Is it worth it? Well, considering how long a Master League takes, I think it may be worth it if you update ratings/new players maybe twice a season. Additionally, I may try to use it for help on transfers to find out how guys would fit with my team depending on their form.

 

[Mick03]

not considering theres a stick on the topic (in this section) and i belive there was a program already writen.

 

[DrEvil1996]

If it's proper to put it in the sticky, someone delete this and I can repost or something. I avoided it since it hadn't been posted in for a couple months.

What program was already written, all I could find was something by 'jmz' that wasn't all that useful for my purpose of comparing players for lineup decisions. Is there already something similar, and if so could you point me to it? Thanks.

 

[Stormrider]

I had a feeling u were gonna make this mistake. Abilities from 95 upward are in a class of their own. 99 is the max, so if a player is on red form and has a 92 ability like ur Zidan, he won't reach 103. He would probably reach 95. No one knows exactly how much percentage it is as Konami have not revealed it, but u can expect something like this. If a player has 95+ and he's on red form, u can expect only a 1 point jump, if its even possible to jump. Going from 95 to 96 is a huge jump, not like going from 93 to 94.

 

[DrEvil1996]

That's very interesting Stormrider, I had not heard of this. How does anyone know about how ratings above 95 are different like that? Did Konami just throw that out there, or is there some other evidence of this?

Either way, I think this spreadsheet may be useful purely from a comparison standpoint. Even if there are some differences in the highest ratings and some may be slightly off, things should still be close enough to be able to compare players with one another. Am I right on that?

 

[Stormrider]

Its in the Official Guide, which has a lot of input from Konami. Seabass (the game's father) mentioned it himself. Also once u play the master league, u'll know that once ur stats reach 95, it'll start going up painfully slow.

here's an excerp from the guide:

"stats of 95 to 99 are reserved for truly exceptional players. An increase from 96 to 97 in Shot Technique is simply not comparable to an increase from 86 to 87 in another player: the leap in actual ability is much, much higher. In the ML, ability levels that exceed 95 often increase at a painfully slow rate, or even stop growing altogether..."

so I'll go and say that on red form, 95 might improve to 96, but 96+ will stay the same. I like ur guide tho. Maybe u can fix this one problem, and maybe add some big name players and u might make a lot of people happy.

 

[Kirby#9]

Man, my brain is smokin!!!!!!!!!!!hmy:

 

[DrEvil1996]

Its in the Official Guide, which has a lot of input from Konami. Seabass (the game's father) mentioned it himself. Also once u play the master league, u'll know that once ur stats reach 95, it'll start going up painfully slow.

here's an excerp from the guide:

"stats of 95 to 99 are reserved for truly exceptional players. An increase from 96 to 97 in Shot Technique is simply not comparable to an increase from 86 to 87 in another player: the leap in actual ability is much, much higher. In the ML, ability levels that exceed 95 often increase at a painfully slow rate, or even stop growing altogether..."

so I'll go and say that on red form, 95 might improve to 96, but 96+ will stay the same. I like ur guide tho. Maybe u can fix this one problem, and maybe add some big name players and u might make a lot of people happy.

Thanks for the info, I really don't know how this could be incorporated into what I have done though (from an Excel standpoint it may be too complex unless someone knows macros). Knowing this helps, though, I'm glad I learned more about this.

I'm content leaving the spreadsheet how it is, because it serves my needs in my ML. I was hoping people might want to put in their own roster and use it, but if not that's alright too. Maybe someone can modify it to be better or something.

I am willing to explain how the big formula works if anyone wants to modify things and can't figure out what is going on in it, just shoot me a PM or post here.