Jump to content

Stats Tracking In Google Docs

2 replies to this topic

#1 Vidarion


  • PipPipPipPipPip
  • Philanthropist
  • Philanthropist
  • 101 posts

Posted 17 March 2017 - 08:40 PM

Not sure about the rest of you, but I've been cutting and pasting the data from my profile stats into a Google Sheets document for reference (and fun, but no profit). One thing I have noticed is that the number of matches played in a match doesn't always match with the sum of Wins and Losses. I know there are Ties, but I find it hard to believe the number of them. Additionally, my stats show some weapons with 0 matches, but time equipped and damage.

If you have ideas for other useful / interesting information that can be gleaned from our profile stats, I'd be interested to hear them. Barring access to the actual individual match data, this is what I came up with. If you find it useful for your own stats tracking, feel free to use any / all of the script.

On to the spreadsheet info:
I found it useful to have the following sheets in the document:
- Overview
- Mech Data
- Weapon Data
- Map Data
- Game Mode Data

I paste the Mech, Weapon, Map, and Mode data from my profile into the appropriate worksheet.

The Overview sheet is generated by a script that is triggered by changes to the document.

Script code (replace <document id> with the id value from the Google Docs URL docs.google.com/spreadsheets/d/<document id>/edit...) :

On the Mech Data page, I add the following columns (with appropriate formula):
  • Survival %
  • Avg Dmg
  • Kills / Match
  • XP / sec
  • Dmg / Sec
  • Dmg / Kill
  • XP / Match
  • Dmg / Match
  • Time / Match
  • Death %
  • Win %
On the Weapon Data page, I add the following columns:
  • Dmg / Match
  • Hits / Match
  • Shots / Match
  • Dmg / Sec
  • Dmg / Hit
  • Avg Time / Match
On the Map Data page, I add:
  • Avg Time / Match
  • Win %
On the Game Mode page, I add a column for Win %.

Even without API access, I'd love to see Draws, Assists, and KMDDs added to the stats in our profile. With API access to full match data, I'd love to be able to see hits or damage / hitbox area to be able to see how well you are able to hit specific locations.

#2 Tarogato


  • PipPipPipPipPipPipPipPipPipPip
  • Civil Servant
  • Civil Servant
  • 6,508 posts
  • LocationUSA

Posted 18 March 2017 - 07:24 AM

I do have my own sheet that does something very similar. I've been meaning to release it publicly so others can use it, but it's not completely polished and I'm bloody lazy.


#3 SedHurtYa


  • PipPip
  • Survivor
  • Survivor
  • 47 posts

Posted 13 September 2017 - 04:53 PM

Up vote for KMDD stats from MECH STATS page:

The match count discrepancy seems to stem from Faction Drops. In particular, the FW quad multi-drops with a single "match."

I posted a similar spreadsheet last year here:

And that post with an updated spreadsheet version (Excel 2016) with more Mechs and "current" weapons:
newer update with a nifty Loadout Estimate of Match Damage chart and loadout table:

A sample of that chart:

Edited by SedHurtYa, 15 September 2017 - 06:47 PM.

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users