Here is the Spreadsheet for you all. I was simply amazed how you all reacted and that you took the time to give me some propz :).
First of all, though, I copy pasted the data, not the functions etc, so there is nothing to do for anyone in this sheet but me. The original sheet will stay offline, unless someone wants to and will work with me on whatever that might be. Please contact me on Discord or on Smogon if there is something wrong.
You can search for your personal stats using the Dropdown in the “Find your Stats” sheet. Also, there are rankings for the three advanced stats and a sheet with most of the important data all in one.
Second of all: There was an arithmetic mistake in my first post. Some numbers changed a bit from yesterday, sorry!
@ all the team tour managers: I would love to be part of a team in the future. So maybe you might consider contacting me for some Pokemon John Hollinger stuff :D!
For those who want to understand what I did, I’ll try my very best, so here it goes:
W: wins
G: games
P: player
O: opponent
OO: opponent’s opponents
W%: Win Percentage = W(P)/G(P)
OW%: Opponent’s Win Percentage = W(O)/G(O)
OOW%: Opponent’s Opponents’ Win Percentage = average of all 1 to 9 W(OO)/G(OO)
SOS: Strength of Schedule = 2/3 x OW% + 1/3 x OOW%
Source of stat:
https://en.wikipedia.org/wiki/Strength_of_schedule
(BCS type because of lack of some data)
Explanation:
„How hard was your road?“
This stat describes how good the opponents you fought were. It takes into consideration how they did overall and how hard their road was to a somewhat lesser extend. This stat does not say anything about your performance, just analyzes how tough your enemies were along the road. In regular season, the SOS differed between .375 and .608, so there is quite the variety. Nonetheless, the fewer games you played, the less this stat does mean anything.
RPI: Relative Percent Index = 1/2 x OW% + 1/4 x OOW% + 1/4 W%
Source of stat:
http://www.espn.com/nba/stats/rpi
Explanation:
“How well did you do considering your opponents?”
The RPI takes your own playing into account, so unlike the SOS, the RPI does tell you something about your performance. The problem here is: You could go 9-0 and would not even be Top10 because of the aforementioned variety. Also, more often than not, it is not your fault, you played “worse” player and if you are the best, none of your own opponents push this rating as high as you do it for them.
To overcome the problems the best players of every tier are naturally underrepresented in that stat, I tried his:
PER: Pokemon Efficiency Rating = RPI x {1 / [1 + (L/W)^1,83 ]}
Explanation:
“How did you do considering your opponents with more emphasis on your own performance?”
This stat is far from perfect and additionally “my creation” (yeah, I multiplied two numbers, sheesh), but it is needed because of the aforementioned problems. The RPI is multiplied with something that is called the “Expected Win Percentage”. Every sport follows this formula if you chose the Pythagorean method. The problem however, this exponent of 1.83 is obviously undefined for Pokemon (it varies from 1.83 for baseball to 16.5 for Basketball) and the stat usually does not take W-L, but runs, points, you name it… The lack of data forced me to use this standard exponent and the W-L-ratio, though. It is a skewed stat but in my opinion fixes the problem of underrepresentation of the “Tier winners”. The stat was normalized to compare it easier, which means the worst record corresponded to a clean 0 and the best record to 100. The non-normalized version is in the sheet as well, too.
So without further ado: ENJOY!
https://docs.google.com/spreadsheets/d/1wTSBfcoub8jWXLUqg11tT8amALZF6FgfiqzayZFQXvM/edit?usp=sharing
Shoutouts to all people who feed backed me yesterday. I found some mistakes, adjusted some numbers and I am still aware of the PER’s flaws. {1 / [1 + (L/W)1,83 ]} (aka Expected Winning Percentage) is in my opinion still the way to go with the exception of the 1,83 exponent, but there is nothing to find (at least for me) to get a better one. Feel free to suggest an alternative.