Detailed Replay Data Analysis

[GreatGonzales]

(05-11-2014 09:39 AM)lawtai Wrote:  So I was trying to take a look at your formulas to see how you calculated things. It looks like you parse out the data into new columns in your Master sheet, basically starting at column AK. Would you be willing to post how you are consolidating those numbers down?

I was hoping to be able to see if it was possible to add in a box that let you separate the Friendly matches and the League matches as the winning % may be skewed if people are goofing off with the friendly matches.

Yeah I did not control for league/friendly matches with any of these stats, that is one weakness. My thought was that - at least at our level - friendly matches are generally taken as seriously as league matches - I am referring to forum tournament matches. But, it would be nice to have those breakouts, I agree.

Yeah, basically what I am doing is creating a column which contains all the relevant data elements for a particular statistic. These are all noted in the column headings. For example: Game Type + P1 + Result + Map. And then my countif functions are looking for particular combinations of these elements, e.g. "2 GreatGonzales 1 4" for all my wins as P1 on Glitch.

It will take some time for you to separate friendly/league matches for all of the statistics I am currently calculating, since you pretty much will have to manually edit most of the formulas. BTW, I have preserved the actual formulas on the master tab in the very last row, something like 155,555.

Hope that helps!