Another Performance Tracking Spreadsheet, fewer colors and more charts!

Advice/Tips

There are a few different similar spreadsheets(that I borrowed heavily from) that have been floating around for a while, but none of them seemed to fit my needs. I couldn't get past the color schemes, or the necessity to use Excel/Libre. So I made my own and I'm happy to share it with the community.

My main goals were to simplify and minimize per-game data that needs to be entered, and extrapolate as much data from that as possible. I settled on just 4 entries for each game: Rank, Group Size, Map, and Primary Hero. Several more things are provided from this information like Game Mode and Weapon Types, as well as comparisons for certain heroes on certain maps, etc.

Step 1.) Open Document below, and "Make a Copy"

Step 2.) Fill out the 3 green cells at the top of the "Analysis" sheet

Step 3.) Enter Data for each game in the first 4 columns of the "Data Entry" sheet

Step 4.) Avoid the "Trends" sheet, Dragons...

Blank Season 3 Template: https://docs.google.com/spreadsheets/d/109-zajLcN4NVW-9PapHSpBpS0MUCaLmnpB1BBplJrlI/edit?usp=sharing

Season 2 Example: https://docs.google.com/spreadsheets/d/1zM3oCgBzewsTce9jHxM6lwHUyxnyatBDyZ-XLI-kC54/edit?usp=sharing

Posted Dec 1, 2016, 12:21 AM UTC

146
Nadnerb5•

I like the metrics you are tracking, may totally steal some of this for my own sheet :) good stuff!

1
SapphicStar•

I'd like to add a column to my copy for notes about each match, on the Data Entry tab. Is that safe to do or will it mess up any of the formulas?

1
randullOP•

I added a "Notes" column, haven't seen any negative consequences from it.

2
SapphicStar•

Great, thanks.

1
creedfeed•

What are you supposed to put in the Target Skill Rank field?

1
randullOP•

It's not used for anything yet, the intention is to build in some formulas to try to gauge your progress. For the time being you can fill it out or leave it blank. The rank above your current rank, in my case I've only reached Platinum so I put my Target Rank at 3000.

1