Stats Spreadsheet - If you want more detailed offensive stats

(Amerika) #1

OK, so I enjoy stats and I wanted to see a few key things that the current stats page doesn’t show in regards to offensive stats. Things like my accuracy with certain weapon groups, KDR totals, KDR per merc, KDR with assists added (for the hell of it), win/loss percentage per merc etc. etc.

There is two pages. One for merc totals and one for weapon totals (tabs on the bottom).

Things I found interesting on the Merc page:

  1. I play way too much Fragger. My god.
  2. I thought my KDR on Sawbonez would have been higher since I feel like I live forever on him.
  3. I sometimes throw myself at Objectives and lemming a bit which is shown in my Proxy KDR.
  4. Phantom is my 2nd highest KDR Merc but he’s got the worst W/L % out of Mercs I actually use constantly. I honestly can’t explain this.
  5. I pretty much never play Aura or Fletcher. In fact, I can’t remember ever actually playing Aura intentionally so I can’t believe I have stats for her.
  6. Wins/losses per merc are different than the Overview. Most likely due to the Overview only counting total wins/losses but mercs getting their own win/loss total since you can have three. I have no clue if you have to use a merc for them to get a win or loss. Something is still pretty off with this as I’ve seen some people with as many games played total as me but half the time. And I pretty much stick to quick OBJ matches.

b - Ardez might have found out what it is. He’s only played Stoker one time but it was for 7 rounds of Execution. Each round counted as a win or a loss. Which would potentially explain why some people have a lot more games won/lost than they should and also some of the high or low w/l ratios if they played a lot of Execution. I don’t believe I’ve played a single round of Execution myself. I contact Nexon QA.[/b]

Things I found interesting on the Weapons page:

  1. I am pretty accurate across all of the primary weapons I consistently use (42.18% accuracy total).
  2. I hit WAY more than I thought I did with the DE .50 (51.6%) and pistols in general. I would have sworn before today that I never hit a gdamn thing with that gun.
  3. I think something might be wrong with the kill totals. I have 48,361 kills using regular weapons (any). The Overview shows that I have killed 54,592 people. I have a hard time believing that I have only 6,231 kills using special abilities. Especially with the amount of time I have in with Fragger and the crazy amount of grenade kills I’ve gotten.
  4. My sniper rifle accuracy is consistent with my lifetime records in almost every other game I’ve played. Between 55-60% accuracy. That’s also around the same average as my LAN Q3 railgun. Which is mostly interesting considering that most of those games use wildly different mechanics when shooting.

If you want to use this spreadsheet for yourself just save it over to your own Google drive and delete my values. For the Merc page input your own values for Kills, Deaths, Assists, Wins, Losses. For Weapons input Kills, Assists and Accuracy. The formulas will take care of all the rest. It will probably take you about 10-15 minutes if you do all of it. I’d recommend taking a screenshot of each screen for a quick reference. However, to get your death total you’ll have to hover over kills per merc and your deaths will be shown. So that one is a bit annoying.

And yes, I was really bored tonight.

(Mister__Wiggles) #2

Awesome, thanks for this I’ll be sure to try it out myself and post the results. Thanks again!

(XavienX) #3

But in all seriousness, thanks for da info :smiley:

(Bestfinlandball) #4

My accuracy is 27.9% lol

(Mister__Wiggles) #5

Mines 28%…0.1% better, Winning.

(Dwu) #6

Too bad most of the weapon accuracy data they show is quite irrelevant as headshot percentage isn’t shown. Hopefully thats added in future patches.

(fubar) #7

Stats are broken in more than one way. I have yet to figure out how they calculate the average accuracy, any formula I can think of doesn’t yield the same results.

Hours played don’t match the sum of hours on mercs. Wins/Losses don’t match the sum of mercs. Accuracies seem to be way skewed in general. Sum of weapon kills don’t match the total of kills, etc., etc., etc.

What I’d really be interested in, are proper stats. Really, while slightly interesting - the profile page we have is worthless.
I want per game/round based stats: I want damage given, damage received, revives, kills, deaths, assists, damage per kill, individual weapon kills, accuracy, headshots, headshot percentage, scores, gibs, team damage, team damage received, suicides, efficiency, damage per kill, damage per death, gibs per kill - For everyone. Most of these could be very easily achieved if the console was outputting the killfeed rather than the bastardized UI hackery we have right now. But, it wouldn’t be SD if they didn’t miss the point. As with every other patch or fix.

(Amerika) #8

Yeah, accuracy and a few other things are is a bit weird and not very telling which is one reason I made the spreadsheet…and I am not sure I can even trust those numbers (a few are being investigated). Also, I cheated a bit with accuracy as I didn’t drill down on the % per weapon and get the actual shots fired/shots hit per weapon which would yield slightly more accurate weighted results. I just didn’t feel like going to that trouble at the time.

And yes @fubar, I’ve long been asking for exactly that. A detailed stats page per match with everything you mentioned and more. Things like the time the HBS is out vs. how many was sensed (showing if you have good HBS’s or not) and frilly things like that which aren’t super useful to most people but great for anybody who is trying to analyze their play and fix issues or do better. I have a lot of weaknesses in a few areas of my play and the stats we have now has put a light on them…but I’d like more. Especially for the mercs I truly care about.

Extra stats per round that could easily be piped outside of DB for public collection would be amazing.