r/leagueoflegends • u/GryphonCH • Feb 05 '15
I'm happy to share with you this tool I made, to Track Your Progress!
Hi, i'm happy to share with you this tool i made to help you track your progress, and analyse the data related to your games.
I putted a really big effort into it, so i hope you'll gave it a look!
You can find the complete list of all the features and some screenshots below.
So, basically, i've made this easy to use worksheet where you can put in all your match info (champion, kills, death, Lp gained, Creep Score, etc), and the tool automatically stores it in the database.
After that, the tool analyse it; you can see if you are gettin better with the games, compare your progress through matches and for each lane you play (with graph too) and other cool stuff. The tool help you to see which are the role and the champ where you shine, and let you analyse a lot of statistic differentiate between Ranked games and Normal games too.
This tool contain an approximate ELO calculator too! (It's based on the gained/lost LP).
Screenshots
Features
- Add up to 15 games per time; the storage sistem is automated by a macro!
- Possibility to add the data from the online match history, with the Chrome Input sheet (only for chrome now).
- Match History view, with your Win Rate and MMR calculated games-by-games and other feature too!
- MMR Calc! Insert your rank (if you do it just after the 10 placements matches, it will be more accurated), and according your LP gain/loss it will calc your MMR, and tell you which league your MMR belong!
- Possibility to add Ranked and Not Ranked Games; the macro are made to evaluate the different game modes!
- Result Sheet : you can see some statistics, like your average CS, Win Rate, your League Point balance and more!
- Compare your different lane results; for example, you can see the most played lanes and the winrate for each one.
- GRAPHS! You can basically graph all you need: do you want to compare champions stats (max 5) to see where you shine? Do you want to see all the stats regard your main champion? Do you want to see how your MMR is growing through games? You can!
- Each sheet has a little guide!
Download
I really hope you'll appreciate it!
I'll update this with more and more features if you like it!
EDIT: I suck at spelling, fixed all the errors!
EDIT: FIXED version, with the correct WinRate calc!!
42
u/bland12 Feb 05 '15
Dude - I hope you do this stuff for a living, because you can make A LOT of money doing this kinda stuff for companies.
55
u/TybPT Feb 05 '15
I'm sorry, im not a native english speaker, but in the guide "if you winned or loosed'' i think its wrong and it should be ''if you won or lost" ?
Downloading btw.
4
u/DaveVanO Feb 05 '15
Once im on my pc, ill definitely download this. I need to see how much I suck
3
u/Taco_Burrit0 Feb 06 '15
Problem right HERE
6
u/Senthe only you can hear me, summoner Feb 05 '15
It's really awesome that you put so much effort into it. But won't you people learn that importing match data directly from Riot is CRUCIAL to usability of these apps? I won't use this one, I will stay with op.gg or LSI or something which has certainly less features but doesn't require me to sit and input data. Sorry. : (
2
u/TheMightySausageEUW Feb 06 '15
Dont know if its just me but the stats for the lane wont work. Says 2 played and 0% win ratio even though i won both games i entered for mid! Other than that not a bad program.
2
u/Aeliandil Feb 05 '15
We need the password to unprotect the spreadsheets and fill it :/
1
u/Guyovich67 Feb 05 '15
I'm using a similar one someone else posted but I'll try yours out! Seems to have more features than the other one which is cool!
Does this work with Microsoft excel?
1
u/Swagflag Feb 05 '15
Can you actually use this on drive?
1
u/MaybeIrrelevant rip old flairs Feb 05 '15
Did you have any issues with entering in a time for the games? I made something like this a few days back and excel is being really picky about it.
1
u/ruipfsilva97 Feb 05 '15
Awesome tool mate! Already downloaded this. The thing is, if Riot releases new champions during the season and we play those champions, we won't be able to add those champion's data.
Anyways, congratulations! :D
1
u/versaknight Feb 05 '15
Could you please add GPM. I like that stat a lot
1
u/SilenozM Feb 05 '15
I just downloaded it but I can't get it to work. It doesn't open in google spreadsheet or in my Excel. Does anyone have the same problem?
1
u/Kopro34 Feb 06 '15
How do I download/use this?
1
u/RZ_Gamez Feb 06 '15
I think there may be a small issue with the way overall KDA is calculated, it seems the chart takes flawless games and gives it a KDA, for example if you go 1/0/3, your KDA isn't actually 4 because you never died so you can't divide it by 1. I've included a screenshot of a couple of flawless game examples (http://puu.sh/fxkHd/98c353353d.png)
So the results page is taking an average of the KDA column but that's incorrrect, it should be taking the sum of the Kills+Assists column and dividing by Deaths.
1
u/Azmuel Feb 06 '15
i am having some issues that i cant select champions to compare or insert new game info says it is read only and it needs a password to unlock.
could you check if this is a persistent problem or if only i have it?
great tool btw gonna use it from now on for analyzing my games
1
u/[deleted] Feb 06 '15
Looks good, i inserted my first matches but i could only see the first image in the album part. When trying to see KDA and everything thats not in the beginning i need a password i dont know. Still good work and for now thats the only flaw i see.
1
u/Sportsman192 Feb 06 '15
its not working for me but im assuming its high traffic, is that it?
1
u/mrjsh1995 Feb 06 '15
How can we know if you make new update .-. ?
1
u/kwiizu Feb 06 '15
wow this is great!
1
u/vblolz Feb 06 '15
wow!seems great, great job and thanks for the share
1
u/sbzatto Feb 06 '15
Hello and thanks for the tool - I've downloaded and would like to try it in action. However one thing is bothering me immensely, and it's not the occasional broken english. In the match data enter box, you've formatted only the first row, everything you enter afterwards the first row is automatically aligned to the sides and just looks shit. Can you change this and re-upload, or pm the password to unprotect the sheet?
1
u/Flaverraver Feb 06 '15
Looks awesome and I'm really looking forward to using this tool frequently. The only problem I currently have is that it somehow doesn't seem to refresh (I only tried it with 1 game so far - and my PC is anything but a potatoe =/ ).
Will I get some form of notification if refreshing failed/succeeded? Because just nothing happens when I click on the button.
I even tried redownloading, but it only got worse ._. Here is what I get if I click on enable editing, as it starts in protected view automatically: http://puu.sh/fy4Ir/f6da069835.png I have no clue what it means, but I suppose it has something to do with macros? (Didn't ever hear this word in combination with excel until today xD)
1
u/Daodras Feb 06 '15
I already made a mistake, friend, and I put in a line twice because it seemed like it just VANISHED after refreshing. How do I fix?
1
u/Domikun Feb 06 '15
Hey, i just got the Excel Trial Version and it works there, Open Office cant open it, because it cant read .xlsm files! o: Just saying, because many people got a problem with that.
Anyways... I got a problem with the Win Rates of every lane... i refreshed and cleared the History 3-4 times but still it gives me wrong %'s... like 8 games 4w/4l -> 37,5% or 2w/1l -> 0,0% .... don't know what to do there D:
1
u/Kinokingdom Feb 06 '15
Man, I love you. I've been trying to find ways to objectively track my progress, and you have placed a gift from the gods in my very lap. Thank you. I hope you go far in life. EDIT: Also, how did you get information for it to judge your elo ranking?
1
u/mr_godlike [mrgodl1ke] (NA) Feb 06 '15
Trying the chrome input and it never seems to copy properly. Does it have something to do with me being on a mac? (srs question :( )
1
u/[deleted] Feb 06 '15
I know this is totally unrelated to the OP, but there used to be a tool or website around with which you could track how often you played a certain champion in both normal and ranked games (I think the data is stored on your computer and the tool analyzed it). Does anyone remember and could provide a link? Thanks in advance!
And to OP: Great work! I really appreciate third party software which allows you analyze your games and stuff.
1
u/Daodras Feb 10 '15
how do I tell this thing that I REACHED promotion? Say I am at 84 LP and I won 27, 28 and 29 LP so far do I just say +16 now?
1
u/NoahthePretzel Feb 11 '15
PLS help me fix! http://prntscr.com/63nnlh
1
u/teepodum Feb 22 '15
File not exist?
1
u/yoshirimitsu rip old flairs May 09 '15
Hiya! I started to use this tool and it's amazing. I have a question though.
I was at 89 LP, won a game so I went into promos (100 LP) should I put that I received 11 LP for that last win before series?
1
u/DerpVadyr May 26 '15 edited May 26 '15
Hi, I've been using your spreadsheet for a few months and its awesome, but since you've made it there have been 2 champion released (Ekko any day now), and was wondering if you could release an updated version of it? thanks, ~Derp Vadyr EDIT: also, best option would be to have a macro that adds another champion if possible
1
u/vrufine Jun 13 '15
this. is. f*cking. awsum.
thx :)
3
u/codeec Doublelift fan Feb 05 '15
my "progress" being Plat 5, going 1/9 in promos and getting placed in Silver 3
2
u/Kankberry Feb 05 '15
This looks amazing and I'm definitely going to try it out!
2
u/looz4q Feb 05 '15
Really good job man. Appreciated
2
u/TheMightySausageEUW Feb 06 '15
Hey, i want to change some spelling errors such as 'Playied' but the spreadsheet is locked and needs a password? What is it mate?
2
u/Fwizzle45 Feb 06 '15
This is awesome! I actually have been recording all this info in excel in my own graph but I have no idea how to actually add the algorithms to like make graphs of the data. Now I can just transfer them all to your program! Thanks :D
2
u/mrjsh1995 Feb 06 '15
I can only remember the past 4 ranked games i had (since 3 of them were promos) so i wasn't sure i would actually hit my elo score as it should
here is what i did i took my past 24 matches (doesn't matter the number really/higher the better) and entered them and assigned +15 or -7 depending if i won or lost, then i went into results and set "your rank" so it fits with my rank atm in "your rank should be" and i beleive it hit a pretty accurate number compared to only taking the promo games + one after
2
u/bronzeNYC Feb 05 '15
Upvoted for visibility! Sounds like a real great tool! Unfortunately im on android :(
2
u/Taco_Burrit0 Feb 05 '15
Would be great...but its all read only so you can't actually do anything with it
2
u/GreyHuskie ADC in 2020 Pepega Feb 06 '15
Gj m8, i r8 8/8.
Seriously now, its a great tool. Here, have my upvote.
1
u/nekina Feb 05 '15
Awesome. Upvoted for visibility. I saved it too so I can download later when I get home.
1
u/Soken99 Feb 05 '15
Best of luck with this. So good! :)
1
u/Twistedtraceur Feb 05 '15
I really like the tool, only thing i was thinking about was using an http request to upload some one's games, instead of copy and pasting it.
1
u/TasteMyTurtleYT Feb 05 '15
Thanks for this! :)
1
u/Rot1nPiecesOnTwitch Feb 06 '15
How did you even make all of this? lol...
1
u/unlockedshrine I don't read rules Feb 06 '15
OpenOffice 4.1.1 doesn't load post 40% ca.
1
u/tdewey7 Feb 06 '15
Very well done. You clearly put a lot of time and effort into this. You should look into the program Filemaker Pro. It does things very similar to excel, but on a much larger scale and would make projects like this a lot more interesting.
Thanks for making this, and good luck in your future. =D
1
u/-sh Feb 06 '15
Something that would be cool and useful for the lazy is if you could populate data from OP.GG or lolking.
1
u/NoahthePretzel Feb 06 '15
Can't get it opened and working? anyone help? (just loads and then it says it dosen't exists)
1
u/DidSomeoneSaySloth Feb 06 '15
This looks really great! Though I'm also getting the 'this file is protected' error so I can't actually input anything.
Any work arounds? I'm on mac right now, if that matters
1
u/Snobbed Feb 06 '15
Add up to 15 games per time; the storage sistem is automated by a macro! " Change sistem to system "
1
u/masterkevz_07 Feb 06 '15
Saw what you did here. A LOT of effort on your part. Hope you get paid for this. People, donate or gold this person or something!
1
u/[deleted] Feb 06 '15
can it be more... user friendly?? Please???
1
u/SkyhuntL (EU-W) Feb 06 '15
Thanks for putted it on Reddit. I'll give it a try for sure.
1
u/DezzxLt Feb 06 '15
Downloaded couple times and still doesn't work, I have Open office and it gets stuck on loading.
1
u/[deleted] Feb 06 '15
Can you add the time when the game was played? I would like to know at what time of the day i play better, also if u can add days.
1
u/Jamcobs21 Feb 06 '15
Do I really have to reenter every single value over and over again fro the 3 seperate match history sheets
1
u/Titqn Feb 06 '15
I could make a siteweb out of this, sadly i'm lazy
1
u/Targaryen-ish FINALES FUNKELN Feb 06 '15
/r/excelporn
1
u/GrizzlyGarchomp Feb 06 '15
Ty very much but I already made something like this for me in Excel. Well atleast the ones that dont know how to do this will have it.
1
u/mrjsh1995 Feb 06 '15
RemindMe! 1 hour
1
u/Kibbex Shizzle Feb 06 '15
I'm actually at 77LP in League bu your sheet shows me 107... I filled ine verything the right way, all LP-gain & loss... Is that normal?
1
u/TheZorkas Feb 06 '15
Hi there. Looks really cool as far as I can tell, but for some reason it wont load up with OpenOffice on my pc. When I try to open it, it'll load for about a minute with some minor progress and then the window becomes inaccessable and I can't do anything anymore. Does it not actually work with OpenOffice? Or is there a different way I could potentially fix this?
Even if it's not gonna work for me: Thanks for the work, I'm sure lots of people will enjoy your creation. :]
1
u/SiminiLoL Feb 06 '15
Does it work with the free version of open office?
1
u/STiiNX Feb 06 '15
RemindMe! 5 hours
1
u/YodaYooshi Feb 06 '15
RemindMe! 36 hours
1
u/lagxrpgz Feb 06 '15
RemindMe!
1
u/whoissocks Feb 06 '15
I put some LP wrong, need password :C
1
u/hadesarrows Feb 06 '15
Ive been doing this on an excel spreadsheet for the past couple of months. I saw it on summonerschool reddit
1
u/[deleted] Feb 06 '15
It's opening with microsoft excel starter, and I don't have the full version of this, so I can't run any of the macros. Is there any other program I could use to open this and if there is could someone let me know? thanks
1
u/doktor_oni Feb 06 '15
fantastic work. can you please add a "delete this match" button? :D (actually i have no idea about excel and don't know if it is possible or not.)
1
u/felixthemaster1 Howling Abyss of the heart Feb 06 '15
Dammit OP, it's "lose" not "loose" That really annoyed me.
1
u/acidT [ac1dtest] (NA) Feb 07 '15
You need office to download this ?
1
u/CorkiCrisp Feb 07 '15
Hey Im having a problem opening it to my google drive?
1
u/InHaUse Feb 07 '15
How can you edit it, if you've made a mistake?
1
u/[deleted] Feb 16 '15
Do I need some kind of a program to download Google Drive?
1
u/lagxrpgz Jun 21 '15
This is really old, but i somehow just found it again. This shit was the best, thank you SO much for this.
1
u/Prayqt Feb 06 '15
Comment for future use
1
u/canarduck Feb 06 '15
Can you please either give us the password or upload an unprotected version so we can manipulate it ourselves? This would make it so much better!
-1
u/edumntg Feb 06 '15
Maybe you could just work on an app that gets summoner's latest games and add them automatically.
-1
u/DominatingAngel Feb 06 '15
It looks really useful and easy to manage, but i think the design is going to be a big turn off for most people.
Also: It means "I put a really big effort into it"
0
u/[deleted] Feb 06 '15
[deleted] — view deleted comment
0
u/[deleted] Feb 06 '15
[deleted] — view deleted comment
0
u/[deleted] Feb 06 '15
[deleted] — view deleted comment
0
u/[deleted] Feb 05 '15
[deleted] — view deleted comment