so im a coach and i need an effective way to organize data from vods into spreadsheets and whatnot?
dmg spreads. dmg per min, gold gen per min, dmg dealt in teamfight, etc etc.
anything out there to do this for me because my brain is very bad
Hello! I work on the NA LCS Broadcast Stats team, and while we use a mix of programs we've created and our API - I can give you a little bit of a hand as to how you can utilize Pivot Tables (in Excel or Google Sheets) to quickly organize data that makes it easy to digest all at once!
The first thing you need to do is figure out what format you're going to be getting your data in - as ChompyWulf suggested above, using sites like OP.GG/Lolking.net/etc is a good starting point - but you can look at the Advanced Match Histories (as long as the games end and arr not quit out of) or if your programming skills are up to par, you can access the Riot API to pull stats (the same way many websites do it).
The biggest thing is to figure out how the information is displayed, so every time you copy-paste new info into your sheet it's in the same format so you don't have to rearrange the data. Some of the information you may have to input manually, but other information you can have formulas set up to calculate. For example, if you're looking at per minute stats, you can take the column that your damage is located in (or your gold) and divide it by the column your game time is located in, and make this a new row in your data collection so you can very easily copy-paste your normal "data pull" and let the formulas do the rest of the work! From there, you can Data -> Pivot Table and add all the info you need to the
I've attached a "sample table" of my Season 7 solo queue games (no judgerino pls) as to how I would set up a "data pull" and what the Pivot Table that gets spit out looks like.
I'm also sure there are 3rd party programs out there that will organize or arrange data from your own games, or games players you enter play in. I however, do not know of any such programs/sites off the top of my head.
Something like OP.GG is a starting point.
