Welcome to the Forum Archive!

Years of conversation fill a ton of digital pages, and we've kept all of it accessible to browse or copy over. Whether you're looking for reveal articles for older champions, or the first time that Rammus rolled into an "OK" thread, or anything in between, you can find it here. When you're finished, check out the boards to join in the latest League of Legends discussions.

GO TO BOARDS


Damage Calculator

1
Comment below rating threshold, click here to show it.

Fbsunny

Senior Member

03-01-2010

So I was bored today so I decided to make an Excel file that calculates the damage a spell or auto attack will do based on your characters stats. Currently it works for most spells, except for those whose damage is based upon weird things (enemies hp, your mana, etc.). There is also a second sheet which has auto-attack damage and a 3rd sheet made specifically for Parrrley.

On both of the first two sheets there is calculations for the increased damage per 1 of each stat, as well as a place to input two different items and it shows the damage gained and the damage gained/gold efficiency of that item.

Currently the only calculations you have to do is adding up individual stats (aka you need to know your total damage and total crit chance etc.).

Hopefully this will be useful to someone, if you have any questions or ways i can improve it let me know.


Comment below rating threshold, click here to show it.

FeLpZ

Recruiter

03-01-2010

man you must've been really bored


Comment below rating threshold, click here to show it.

thecooltodd

Junior Member

09-09-2011

I love Excel. The UI could use some improvement. When you make a sheet you should try to make it so the user won't have to scroll by condensing everything. If the user does have to scroll, it should be horizontal, not vertical.

The formulas can use VLOOKUP and a dropdown to get the stats from each champion, so you can fill in a champion name and have it automatically fill in the stats.


1