Your "Avg" Column should not have the Player's stats that are being compared to it contained inside that population. If there is a population of 6 players, there should be 6 different deviation from Avg columns so that no ones stats could skew the data of the entire population. For the deviation from Avg for the player I_hold_it (column B) it should be SUM(C2:G2)/5-B2, for PLOwned (column G) it should be SUM(B2:F2)/5-G2. Not to mention the population avg you are comparing to should probably only be I_hold, throne, lexum, and acidman as those 4 are almost certain to be bots, the last 2 are extremely questionable and should be left outside of the "BotAvg" population. If you compare PLOwned to the first 4 you will see that he has:
Much lower W$WSF
Nearly DOUBLE Steal SB stat
Significantly higher Fold vs Flop cbet
Significantly lower c/r turn
Significantly lower bet on both the Flop and Turn vs missed cbet (this would contribute to the lower W$WSF when compared to the bots)
Higher overall SQ %
Looking at these deviations you can tell he is thinking about the game in a much different manner and employing a strategy that significantly differs from the one that the first 4 players on the list are using, Trashman is also likely not a bot or at least not part of the same network as the first 4. Just look at The bet turn vs skipped cbet stat:
You should be doing this for all of the stats, add two more averages that you compare to, "BotAvg" for the first 4 and "HumanAvg" for the last 2, the data will be much more clear after you do this.
Btw the conditional formatting I used was:
If between -5 and 5 = pink
if !between -5 and 5 = yellow
You should probably switch to this when you redo the stats comparison so that number that deviate by > 10 aren't left in the default formatting.
I'll actually PM your my Skype so that you can send me the spreadsheet and I will do all the data comparisons.
Last edited by SeaKing; 11-07-2016 at 05:09 AM.