GASP Stats

So here's a quick run through of how the new stats work: Calculate a z score for specific stats compared against everyone. This will tell us comparatively, how much better they are than everyone. Add up and multiply certain z scores. This will give us a total score. We then calculate how that person's score fits on a scale of 0-10 of every other player. So, the best player gets a 10, the worst gets a 0. Then there's a modifier to punish people who have played the least.
Alrighty, here's how the stats work. First, for every stat in a given time period, we calculate the mean and the standard deviation for every player with each stat. the MEAN and the STDEV calculate this for us.
Then we calculate the z score for each individual player on certain stats. The Z score is the number of standard deviations away from the mean a certain player's stats is. We use the STANDARDIZE function for this.
For the offensize portion, we calculate the Z score for CPM, Score %, Tags without returns Per Minute, total caps, and the number of minutes played. We use the multipliers 3CPM + 3Score% + TPM + Minutes + 4*Caps. This gives us our total offensive score.
For the defense part. we calculate RPM, KD, Tags without returns per minute, total returns, and number of minutes played. We use Multipliers 3RPM + 3KD + TPM + Min + 4* caps. This gives us out total defensive score.
For the total part, simply add up both the offensive score and the defensive score.
Now we need to calculate the ranking from 0-10. For any individual score, we apply: 10((score - minscore)/(maxscore-minscore)). The max score and min score are the min and max of every player for that score. We calculate this for the Offensive score, teh defensive score, and the total score. See this function: =10((V2 - MIN(V$2:V$83))/(MAX(V$2:V$83)-MIN(V$2:V$83)))
Now we need to apply Bull's minutes modifier. This will punish players who only play a little bit. First we need to set a minutes limit where anyone who plays less than this limit is punished, everyone else is fine. the punishment is applied logarithmically against your 0-10 score. So, if they are less than the specified minutes, their 0-10 score become scorelog(minutes10/minimumMinutes). We apply this to all of the 0-10 ranges. This becomes their final score. See this function: =if(E2>$AB$87,1AC2,log(E210/$AB$87)*AC2).