SPEND MORE TIME FOCUSING ON YOUR SURROUNDINGS, STOP TUNNEL VISIONING INDIVIDUAL HEROES.
Git Gud
This tracker was created by LeCorbuisoverrated but is now abandoned. However I try to keep it updated with the new maps and heroes added to the game.
IMPORTANT: I am only adding new maps and heroes. I'm avoiding fixing bugs or errors in the trackers because I really don't have too much time for that, but you can take the sheets and improve them for your own use.
The tracker still uses the old SR system, but I have added this table that indicate which rank is matematically similar to the old numbered rank (This is merely a numerical translation, and is not related to skill )
You only need to locate your rank and add the percentage after each match. If you have demotion protection, just take the average SR losses/wins from the home page and subtract/add that from your last match.
You can get a blank sheet from here:
If you want to see one that's already filled, here's a sample.
• If you wanna get a copy of the blank one, click File > Make a copy. It should save it to your Google Drive account.
• Click File > Settings and change your time zone for the one you are, don't change anything else.
1. After your placements (that you'll be able to log this time around!) you should fill is this cell with your first SR once you have managed to rank.
2. Then proceed to fill the rows you want to after each match: the more you fill, the more useful the spreadsheet will become: Map, hero(es), AVG SR per team, notes, etc. After a few matches you'll be able to get some useful data from the Home sheet and the Progression sheets.
• I usually take two screenshots during the game, one at the beginning, to get the SR per team and one at the end, to get the score and the hero stats. Everything is set up in order to get the screenshots saved in a folder, so I'm free to do the logging after the end the game session, though, most of the time I do it between games.
This is the info that LeCorbuisoverrated previously shared in his posts.
This is the sheet where you'll be able to get a quick status on most of your stats.
This sheet is where you log your games, the more data you write down, the more useful everything else will become.
• You can add up to five heroes per match, just remember, that might skew most of the other stats.
• There are two customizable (C1 and C2, rename them as you see fit) columns in between the stats, so that you can keep track on your [rezzes/aim/sleeps/etc] more easily, just edit AY5 and BD5 to add the title to each column (the spreadsheet will replicate them everywhere else that is needed).
• Please, remember that the cells that need to be filled are blue and the ones that should not be touched are light blue.
• A big white button that says "Next Match" will pop-up in the top bar after the placements, for it to work, it is needed for you, my dear user, to copy the document's url in the cell next to it (I've left a message for you to remember it), once you do it, the link should go invisible.
• The tips change daily.
• If you need some help about filling the sheet, check the next image. (Also, no need to write the date manually, it should do it by its own).
This is the sheet that will have everything you need to know about Maps: best/worst maps, best hero per map, winrates, etc.
• Here you'll find everything you use to have in the Map Dashboard, the Starting Point Detail and some of the charts from the Dashboard.
This is the sheet that will have everything you need to know about Heroes: best/worst heroes, average SR won/lost per hero, winrates, etc.
• 'Stat per hero' will enable you to see the total, the average and the progression of each stat per hero.
• Take these with a gran of salt as the spreadsheet (when you play more than one hero per match) CAN'T possibly know to whom (and how much of it) does each statis relates. For example: if during one match you play both Mercy and Winston, you'll see that Winston's row will have some heals.
This is the sheet that will tell you how well do you do when in groups and with each player.
• Every player you list in the tracker will be here for you to see how are you doing when you play with them.
This sheet will have a chart that cross-references the days and times in which you play.
• Bellow that chart, you'll be find a log of your performance per day.
This sheet will enable you to get the log of certain hero or map.
• It will show your stats per minute and your Custom Stats.
This graph will show your SR/WR progression through games.
This graph will show you how much SR have you been winning/losing, and how has that changed through the season.
For those of you who want to either to get more data or to know how everything is tied together, if you go to the little burger button in the bottom left corner it will show you a list of every sheet included, even the hidden ones that do some of the backstage work:
-This is the sheet where you'll be able to get a quick status on most of your stats.
-ASSETS_TIMES sheet help keeping the timing in all the sheets.
-There is a bridge between your spreadsheet and the server (see below), so that you'll get the new heroes and maps when Blizz releases them.
-This one will take note of your most used heroes and filter some advices that are useful to you.
-By using the old server, I can keep updated even older versions of the sheet.
• "Hey, those tips seem useful, but you should add this one." - At this moment, I'm not adding new tips to the spreadsheet, but I may do so in the future for both the webpage and the spreadsheet!
• "Hey, How can I save Overwatch's screenshots?" - Overwatch itself saves screenshots in 'Documents\Overwatch\ScreenShots\Overwatch'.
• "Hey, How do I do to get a blank copy?" - ****If you wanna get a copy of the blank one, click File > Make a copy. It should save it to your Google Drive account.
• "Hey, you said something about customizable columns, How do I do that?" - Edit AY5 and BD5, then the text to have there will mirror in the rest of thre spreadsheet, try to keep it short though.
• "Hey, Can I use this file in Excel/Calc/Numbers/1-2-3/VisiCalc?" - Due to some features that might be unique to Google Sheets (see Query) it might not work in other apps.
• "Hey, WTF is Paramillo?" - Paramillo is a massif located in Colombia. The original author of this spreadsheet named each version after a geographical feature of their country, Argentina. I've followed suit, using names from my country. (Aconcagua, Bonete Chico, Chuscha, Calinga, Colangüil and Piltriquitrón for 1.3, 1.4, 1.8.3, 1.8.5, 1.8.6 and 1.9 respectively).
• "Hey, Do I have to fill this myself? Really, I feel like an accountant!" - Well, yeah. It will be that way till the day Blizz releases an API in the shape of something that works with Google Sheets or something like that. If you don't like it, webs like Overbuff and MasterOverwatch can track plenty of your stats without any input.
• "Hey, What kind of information does it provide that other available tools (such as Overbuff for example) don't?" - A few seasons ago, u/WumpaWolfy provided an excellent answer to this question:
I imagine using this chart would allow you to notice a bunch of patterns about your play you otherwise may have never realized, such as maybe your win rate tanks after midnight, rises after your first half hour, or that you have a horrible win rate defending Numbani point A as Reinhardt. In these cases changing when you play, how long you play (and warm up), and who you play and where can all be informed better with this method. Not to mention I find that taking notes and being so focused on improvement during a session can really help you see past just winning and losing to diagnose the real problems holding you back.
• "Hey, Is there someplace where I could see the average SR gained/lost per hero?" - You can either go to "Heroes" and see the values for every hero, or by going to "Hero Progression" you'll be able to select the hero you're interested in, and see the average SR won/lost on the top right corner. There's also a little graph that will show you the evolution of that stat.