Here's a video going over the basics of the spreadsheet, if you'd like to hear my partially sick voice. You can tell I never practice in front of a mic. XD
The DPS calculator spreadsheet should be fairly straightforward to use. Most of the calculations are in hidden columns or on separate sheets, and they account for ALMOST everything, including:
Base damage per attack based on level
Base attack speed per second based on level
Item power/damage
Item attack speed
God-specific AS steroids (max rank only)
Crit % / Crit damage, including Deathbringer's bonus damage
Qin's Sais bonus damage based on enemy health
Protection reduction and penetration (including Titan's Bane's variable % pen) calculated in correct order of prioritization (% protection reduction, flat protection reduction, % penetration, flat penetration)
Enemy health (adjustable)
Enemy protections (adjustable)
The only things it isn't set up to handle are certain situational passives, such as Silverbranch Bow's bonus power (above 2.5 AS) and Odysseus' Bow's chain lightning on every 4th hit. It also doesn't factor in certain god bonuses, such as Art's bonus damage against CCd enemies, Cern's Summer stance, etc.
If you think you find any errors, please let us know and we'll check it out. Hope you find this useful!
If you're curious on some of the calculations...
As an FYI, item AS boost to actual AS is based on item AS% * base AS (not AS of your current level).
Power is a 1:1 ratio to basic attack damage before mitigations are calculated.
Here's the fun calculation for Titan's Bane's effect, which I posted in some long lost post somewhere on SF: (((Enemy Prots - 65) / 135) * 25) + 15) / 100. Additional rules in the spreadsheet need to be created to prevent TB's % pen from dropping below 15%, or going above 40%.
Qin's bonus damage calculation is actually extremely similar to TB, believe it or not. Just different values.
Is this supposed to ask some "permission" to be downloaded?
Edit: Ok, now it is showing on my Google Drive, but I can't edit. Tried to download (excel format .xlsx) but the check boxes appears as a simple text wrote "False".
Alright...I've been making some adjustments. If you downloaded before, do so again. Has some added functions and info, extra notes explaining things, etc.
SMITEFire is the place to find the perfect build guide to take your game to the next level. Learn how to play a new god, or fine tune your favorite SMITE gods’s build and strategy.
DV-8
<Veteran>
Awards Showcase
Prominent (35)
Posts: 701
<Administrator>
Awards Showcase
Exalted (394)
Posts: 8709
View My Blog
xmysterionz
<Sharpshooter>
Awards Showcase
Distinguished (71)
Posts: 2383
View My Blog
<Administrator>
Awards Showcase
Exalted (394)
Posts: 8709
View My Blog
xmysterionz
<Sharpshooter>
Awards Showcase
Distinguished (71)
Posts: 2383
View My Blog
<Administrator>
Awards Showcase
Exalted (394)
Posts: 8709
View My Blog
Gulfwulf
<Guardian Master>
Awards Showcase
Esteemed (81)
Posts: 3927
View My Blog
Tlaloc1050
<Veteran>
Awards Showcase
Established (17)
Posts: 948
View My Blog
<Administrator>
Awards Showcase
Exalted (394)
Posts: 8709
View My Blog
xmysterionz
<Sharpshooter>
Awards Showcase
Distinguished (71)
Posts: 2383
View My Blog