Subject: Talent prediction tool (excel sheet)

I made a tool to help to find out the talent af a youthplayer.

sheet

Feel free to ask for add ons or help.

I tried to make this one not to difficult. The only thing you need to do is to fill in the skillnumbers of the youthplayer, all the other data will be add automaticly.
The tool uses 3 formula's. simple line regression, line regression without first 3 weeks. (only usefull if the player played matches that period.) and line regression based on median number. That will cut out some extreme numbers.

/edit 18-02-2011:
It is now around 15 MB, so maybe some old computers will not like it very much

There is a new algoritm used. A template of 'real talent' is compared to the coachestimation, the 'real talent' that fits best (best and worse) is used in the picture and shown in the yellow lines)

/edit: 20-2-2011:
now zipped it. the actual file is as big as it was. but it is only 1.5 to download.


/edit: 23-2-2011:
bugfix: sheet is around 22 MB


/edit: 23-8-2011:
bugfix and small tweaks for better prediction.
(edited)

excellent work wybo!

used it immediately and seems i do have some talent in my team :p

Okay, so this doesn't work then :p

Nice to hear :)

/edit: LOL
(edited)

great work Wybo, i shall try it.

badass!

thanks that helps. too lazy to construct such charts =P

wonderful :)

I don't feel deference between yours macro and mine - the last post.. may be in interactive, but it isn't very important for me...


I'll repost ...

I got some problems with installation framework 3.5...

I wrote Excel macro for detecting YP talent . may be It' will useful for somebody

screen 1
user instruction

downloads:
1)rapidshare
2)megaupload

I'll get some problems with yours macro I got a NA in calculated fields ... It's strange...

I do not understand your sheet as it is in Russian... Most of those sheets use same kind of formula's. I tried to make one that is very easy to use and directly clear for the users. (And it uses the formula i think is best... med(5) lineair regression.)
I think some people will like yours, some like mines. It is all ok, as long as users can find out talent more easily :)

If you got errors on my sheet i am afraid you put numbers on other places then only on the green cells. You can download it again. If not please send me a screenshot.

I do not understand your sheet as it is in Russian...

hmm, It isn't in russian, all necessary fields in English and when you click "generate" yours Excel generate additional info in local language ...

If you got errors on my sheet i am afraid you put numbers on other places then only on the green cells. You can download it again. If not please send me a screenshot.

I got error when I open xls. file, after that working only graph and mid(5) row...
in N29,30,31 I haven't any formulas only "=N/A"

I do not understand and can not reproduce it.

Dit you only fill in skillnumbers in the green cells and fill in no other skills?

Otherwise, can you please send the xls to wyborowa@mail.com? so i can check?

Your sheet works perfect for me ! Couldn´t be easier...

I have found the problem of Agemiz

google docs*

I wil look to it tonight. If someone sees how to fix it imeadiately i would be glad :)


*The diagram does not work in google docs.

works great! Thx !!