https://drive.google.com/open?id=0BxZy7 ... zlNSk9vczg
A couple of things to note:
- The last "Overall" stat is an arbitrary one made by me! It takes into account the things that I consider important, but the idea is that you do your own weighted average based on what you want. (And if you don't know what that is, look it up, it's pretty cool).
- Remember that Consistency and Precision are values that have to be looked relative to the Power stat. In this case, I already took that into account. So if the Forehand Power stat of a certain player is 85 and his precision is 83, the Forehand Precision will read "-2".
- The "Overall" FH, BH, and Serve stats are calculated as FH Power + FH Cons. + FH Prec, so for example: 84 FH Pow; 82 FH Cons.; 88 FH Prec. -> FH Overall = 86 (84 - 2 +4).
- It didn't take as much time as you might think. I was able to import all the data from the text files (*.Ini files) into Excel, so from there it was kind of automatic. You can get an idea of what I did by looking at page 2 of the file.
Enjoy!
