Boards›[ARCHIVED] Miscellaneous

Champion Chart!

Raid Boss Morde··4 votes·879 views
Champion Chart - Google Sheets

I thought I would share this again, the other one got buried in the nightly posts. I made a chart for every champion in League that lists:

  1. The number of skins they own
  2. The champion's latest skin (and date of their latest skin)
  3. The quality of skins they have, as well as the amount of them (example: 2 No particle skins, 1 skin that changes particles)

I'm also working on a bonus chart at the bottom that will list the number of CC skills a champ has, mobility skills, total AD/AP/Bonus AD Ratios, total True Damage, and total % Max Health damage.

It's updated daily, and whenever I think of new features, I will add them. If anyone spots any mistakes, please let me know! I will take suggestions too :D Hope this chart is useful!

4 Comments

Ariaflux1 votes

A suggestion, add a number of skins / number of days released stat as currently it doesn't take into account the fact that newer champions will have less skins. Also instead of just putting date of newest skin, make it number of days since last skin released as that is easier to read and compare.

Raid Boss Morde1 votes

I was thinking about that, so thank you for the suggestion :D i was wondering though, is there a function or easier way to have the "numbers of days since last skin" auto-update each day? It would be a pain to have to update every single champion each day.

Ariaflux1 votes

Oh yeah there is, but I only know the one for Excel. I'm not sure if Google Sheets have all the tools that Excel has. In Excel it's

=DAYS(TODAY(),A1)

Where A1 is the cell of the start date, or you can input the Excel date-time code directly.

Edit: Check out this spreadsheet, it should help https://docs.google.com/spreadsheet/ccc?key=0Arh3w_1KfCECdEl3UUUyZ0pFSFBWcmpaTDVfa1lBUGc#gid=0

Raid Boss Morde1 votes

You're awesome, man. I'll try adding that in now!

More from [ARCHIVED] Miscellaneous

Open Letter to Parents of League of Legends Players
[ARCHIVED] Miscellaneous860 comments
2,611
votes
Rewards for positive play
[ARCHIVED] Miscellaneous19,712 comments
1,337
votes
I don't like Boards
[ARCHIVED] Miscellaneous324 comments
809
votes
STOP ALLOWING LEVEL 1 ACCOUNTS TO SEND FRIEND REQUESTS!!!
[ARCHIVED] Miscellaneous291 comments
679
votes
Wanting to do something special for an awesome friend. Riot, please help? <3
[ARCHIVED] Miscellaneous220 comments
614
votes
People that are telling others to kill themselves has to stop! Please help me get this noticed!
[ARCHIVED] Miscellaneous605 comments
600
votes

More by Raid Boss Morde

I found out why NA players are so salty
[ARCHIVED] Miscellaneous95 comments
217
votes
Jax's Skill icons don't make sense
[ARCHIVED] Miscellaneous16 comments
34
votes
Finally giving in to the Vayne hate!
Gameplay40 comments
28
votes
[Gameplay] Mordekaiser does not gain any stats from target ghost
Report a Bug20 comments
27
votes
[Gameplay] Mordekaiser ult is not stealing 10% attack speed
Report a Bug7 comments
21
votes
[Gameplay] Mordekaiser E is not actually 675 range in-game like it was listed
Report a Bug22 comments
13
votes