DPS Spreadsheet for LoL *under construction*

12345 ... 7
Comment below rating threshold, click here to show it.

toomad

Senior Member

10-08-2009

DPS & Tank Calculator for LoL v0.94 by toomad

Features:

-All Champions fully included!
-Calculate the (physical, autoattack) DPS from the champion of your choice
-Includes masteries, runes, and items to change
-All (well, almost as of now) abilities and spells to calculate their dmg! That includes scaling from AP, attack damage and other stats!
-Compare the results easily with other champions and builds
-Some basic stats comparisons
-A basic tankstats comparison
-Advanced Tankstats
-Dodge calculator (7 values) with effective (average) HP multplier by dodge etc.
-List of all abilities for easy add to dps calc
-Includes Rammus' passive for dps calc
-Includes Corki's passive for dps calc
-Comfortable rune selection function
-Detailed info on attacks with comfortable champion selection
-Support for Atma's Impaler
-Item list easy selection (only in it's own tab as of now, soon working with other tabs)


Not implemented yet:

-more nice explanations (feedback required)
-item selection instead writing and calculating these stats and then typing in +
-add (more) comfort functions +
-add comfortable support for other champions abilities -
-add comfortable ability selection (this is madness!) -

"+" means higher priority to me and "-" less.

Feedback: post here or mail me.

As a reminder: If you have any feedback or wishes on the calc, let me know.

Some newer screenshots are attached too now.

Download as 2 seperate zipfiles, one as ods ( for openoffice in which I created it) and one as xls (for excel). Seperate because these forums don't support zipfiles over 97.7KB size.

http://*******.com/lolcalc for easy linking to this thread

Have fun fellow theorycrafters

I will keep it updated as I get feedback

*UPDATES*

now tracking DL's of calc

Code:
DPS Calculator for LoL v0.67 by toomad.zip (64.7 KB, 30 views)
DPS Calculator for LoL v0.71 by toomad.zip (74.4 KB, 46 views)
DPS Calculator for LoL v0.77 by toomad.zip (81.7 KB, 16 views)
DPS & Tank Calculator for LoL v0.80 by toomad.zip (93.5 KB, 146 views)
DPS & Tank Calculator for LoL v0.85 by toomad ods & xls.zip (88 views)
DPS & Tank Calculator for LoL v0.88 by toomad ods & xls.zip (218 views)
changes in v0.66

-corrected several (minor) calculation mistakes
-added Rammus' passive into calc (with comfortable rune function)
-added all abilities in textform with their values for easier adding
(only those that are not affected by AP/magical damage like „Pick a Card“)

changes in v0.67

-quick change back for example line
-added little dodge calculator (3 values)

changes in v0.71

-fixed a major flaw in dps calculation when crit chance was too high (why didn't anyone tell me? :P )
-fixed more bugs
-added all current champions, some values are still missing (help)
-added detailed infos for attacks (with comfortable selection of champion coming later)
-added more lines for future champions

changes in v0.77

-gathered and calculated missing data on the newer champions
-updated sections for new champions
-comfortable champion celection for "detailed infos for attacks" is now implemented
-dodge calculator updated for use with up to 5 values

changes in v0.80

-New name: DPS & Tank Calculator for LoL
-New feature: Advanced Tankstats!
-added Singed's passive (empowered bulwark)
-added Soraka's passive (consecration)
-added Corki's passive (Hextech Shrapnel Shells) into dps calc (note: doesn't work on turrets)
-added effective (average) HP multplier by dodge to the dodge calculator

changes in v0.85

-added armor equivalent and real HP multiplier from dodge to dodge calc
-dodge calc simplified and now supports 7 dodge values (should be enough now)
-removed "stuff" tab as it's for my use only ;P
-item list for dmg/crit/IAS added (no comfort function yet)
-restored Rammus' passive functionality (it now uses the value from the "advanced tankstats" section)
-added support for Atma's Impaler (uses hp value from advanced tankstats section)
-advanced tankstats section now uses level from the dps calc main section
-gathered and added Shaco's values
-gathered and added Heimerdinger's values

changes in v0.88

-fixed Corki's passive so it won't be reduced by armor anymore (as it should be)
-removed "real hp multiplier from dodge" in dodge calc as it was confusing
-added total hp multiplier (for phys dmg) to dodge calc (which should be less confusing)
-added total phys hp multiplier and total magic hp multiplier to advanced tankstats section
-added "Formulas" tab if you want to look up some formulas
-Formulas tab has as of now: Armor/MR, attack speed, dodge
-moved base stats to own tab
-moved basic and tankstats comparison to base stats tab
-moved adv. tankstats to own tab
-moved dodge calc to tankstats tab
-moved changelog and additional info to it's own tab ("changelog")
-renamed tab "Main" to "Phys DPS"

changes in v0.94

-new tab: Abilities
-added all AP ratios to Abilties tab (credits to Motas)
-Detailed info on attacks after armor now working for Heimerdinger and Shaco
-added (almost) all abilities dmg and mana costs for every rank to abilities tab
-updated Rammus base stats according to League of Legends 1.0.0.52 changelog
-updated abilites according to League of Legends 1.0.0.52
-item list now working (only in it's own tab and only items that directly affect autoattack dmg)
-added Shaco's abilities with dmg, scaling, manacosts, cooldowns
-added sheen and trinity force buffs to "detailed info on attacks after armor"

changes in v0.941

-little cosmetic fixes I forgot :>


remember to post for bumping and feedback!

Quote:
Originally Posted by Fenrel View Post
Depressingly little action in this thread for how awesome this is :/
Quote:
Originally Posted by sluys View Post
nice work dude. this is pretty in depth
Quote:
Originally Posted by fOxstylez View Post
Very nice job
Quote:
Originally Posted by ech0z View Post
this is genius, good work man
Quote:
Originally Posted by AwesomeMcRad View Post
This is awesome sauce good work.


Comment below rating threshold, click here to show it.

Sehnder

Senior Member

10-08-2009

Attachment 3926Very nice! I'll give it a look and post some feedback later.

Edit2: Ah, you are correct, it is included. Lousy work Vista machine!


Comment below rating threshold, click here to show it.

toomad

Senior Member

10-08-2009

Thanks, but it's already in the zipfile as xls for excel too ( if I didn't mess it up )


Comment below rating threshold, click here to show it.

toomad

Senior Member

10-09-2009

*UPDATE*

changes in v0.66

-corrected several (minor) calculation mistakes
-added Rammus' passive into calc (with comfortable rune function)
-added all abilities in textform with their values for easier adding
(only those that are not affected by AP/magical damage like „Pick a Card“)

changes in v0.67

-quick change back for example line
-added little dodge calculator (3 values)


Comment below rating threshold, click here to show it.

Fenrel

Junior Member

10-09-2009

Depressingly little action in this thread for how awesome this is :/


Comment below rating threshold, click here to show it.

Mecklin

Senior Member

10-09-2009

mmm you should convert this into an actual program.

C++ ftw!


Comment below rating threshold, click here to show it.

UrQuan

This user has referred a friend to League of Legends, click for more information

Senior Member

10-09-2009

Or put it on google docs (I don't know if this is against the NDA...)


Comment below rating threshold, click here to show it.

Mecklin

Senior Member

10-09-2009

Quote:
Originally Posted by urquan View Post
Or put it on google docs (I don't know if this is against the NDA...)
Yeah but making it into a program will be so much cooler


Comment below rating threshold, click here to show it.

toomad

Senior Member

10-09-2009

Quote:
Originally Posted by urquan View Post
Or put it on google docs (I don't know if this is against the NDA...)
Google docs doesn't let me share, because it I need to verify my account and it doesn't send me the email for it.

update: it finally sent the mail and I verified, but it still says that I need to verify my account to share -.-''

Quote:
Originally Posted by Mecklin View Post
Yeah but making it into a program will be so much cooler
Sorry, I'm not that much into programming If anyone would do the port, I'd support that.

If someone could give me the missing values for the new champions (base AS & per level and same for dmg), then I could implement them fully.

And please give me some feedback so I can improve it (or tell me what is good about it to motivate me )


Comment below rating threshold, click here to show it.

MaximalBeast

Senior Member

10-09-2009

I noticed that you're missing such heroes as Nasus, Corki, Katarina, etc. Any particular reason why, or just haven't gotten to it yet?

Quote:
If someone could give me the missing values for the new champions (base AS & per level and same for dmg), then I could implement them fully.
Whoops, only skimmed your post and didn't catch that part, my bad, but can't you still check out their stats in-game when you press C?


12345 ... 7