Detailed Replay Data Analysis

[GreatGonzales]

(05-11-2014 10:30 AM)lawtai Wrote:  Yea, you could just create another column and add in the isleaguematch flag so it'd be something like this: IsLeagueMatch + Game Type + P1 + Result + Map.

Then make a check box to either include friendlies or not, and set everything in an IF() statement. It'd definitely make all the formulas messy though.

I might try to just update the Player Stats page first, since that was the one page I was looking more closely at, and would require fewer changes.

---

So I was able to fairly easily add in new columns that included "isleaguematch" in it. The results confused me at first since I was thinking only season 5 stats were included, and not all the data. But I was able to just delete out all but season 5. I only updated the player stats page since you have a ton of formulas in there.

Yeah, like I said it's absolutely something we could add to this spreadsheet across all areas, just will take some time to write all the formulas. Not hard, just time consuming (and maybe a little confusing unless you're familiar with how I have things organized). When you're done working on it, I'd love to see what you've done!