Another Performance Tracking Spreadsheet, fewer colors and more charts!
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
I like the metrics you are tracking, may totally steal some of this for my own sheet :) good stuff!