League of Legends Tracker Spreadsheet

League of Legends Tracker Spreadsheet

I’m tracking every League of Legends game to see my standings and to improve my results.

Things which I’m tracking:

• my elo – to see how it changes (maybe I will promote to challanger one day:))
• champion I’m playing – I prefer Mid or Bot myself
• result of game – if it is win or lose
• information about my line opponent with his/her elo
• my subjective opinion about line result (won, lost or even)
• kills
• deaths
• assists
• KDA – I’m using Excel formula =(kills+assists)/deaths
• farm – how many minions I killed
• duration of game in minutes
• CS/Min – Excel calculates it by Excel formula =CS/Duration
• vision score
• my comments
• thing to improve – I’m always trying to improve and put attention on one the most important thing

It is taking only a few moments to fill in the spreadsheet and I’m still having fun. I’m doing it waiting in the queue before the next game.

There are much more things which can be tracked:

• played position if you are not focusing one
• links to the game if you are Facebook or Twitch streamer or putting games of YouTube
• gold earned
• gold difference
• build which you bought (eg. attack speed, ad, ap, tank)
• first items bought to see the difference based on chosen item
• specific items you chose eg. boots to see results for specific kind of boots (eg. playing with Ionians or Mobilities several games in a row)
• strategy chosen (eg. late game, mid game, objectives, outscale, offensive, gank, bait)
• damage (dealt, taken, healed, mitigated)
• objectives – if Baron and Elder Dragon was killed and how many dragons
• short description in the given moment eg. situation in 15 minutes every game
• and much more…

The League of Legends Tracker spreadsheet is colorful. I like it to have green and red to differentiate the results. If you don’t like conditional formatting you can remove it if you want. Then the spreadsheet will look like this.

Also you can drop a comment there or help me to improve this LoL tracking spreadsheet.

Let’s play and learn Excel. I hope we will play together. GG

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References