DPS and EHP Spreadsheet

  • #161
    nice one man
  • #162
    Is it possible that the DPS display matters are differeing because the user's weapon happens to have the matching damage type to the helm/amulet's damage increase (+X-Y Lighting Damage on a Weapon with Storm Crow, or +X-Y Cold Damage on a Weapon with Tal'Rasha's amulet)?

    This is just a guess is all. Cause the downside to most all Wizard spells is, they do not carry the damage type through to the spells. The lone exception is Spectral Blades, being the only offensive ability we have that just does % weapon damage. All others convert the damage to a specific type, so they don't carry the elemental damage property over. This is easy to check due to +X-Y Cold Damage on a weapon snaring enemies, and that it will only snare with Spectral Blades and nothing else.

    Just an idea as to what would have the calculations off, since it would only apply to the bonus weapon damage, and not ALL the damage done by the weapon + stats... maybe...
  • #163
    i like aloot your dps calculator but i found a probleme with it.

    if you can fix will be great

    ther are ring's and armor with a bonus to elite mobs i found out that that bonus goes in the dmg in-game..

    if you like i can show some print's i took from my gear and the comparation...

    but for me 3 % dmg to elites its like 500 dps more

    can you see htat plx..
  • #164
    Quote from Mateite

    i like aloot your dps calculator but i found a probleme with it.

    if you can fix will be great

    ther are ring's and armor with a bonus to elite mobs i found out that that bonus goes in the dmg in-game..

    if you like i can show some print's i took from my gear and the comparation...

    but for me 3 % dmg to elites its like 500 dps more

    can you see htat plx..


    If I'm understanding the stat correctly, bonus to elite mobs does not show up in your damage number shown in game but instead only applies to the damage done to mobs. So one ring with 100 int and 3% damage to elites would give the same Damage Number as another ring with just 100 int. Equivalently weapons with similar dps values, one wth the bonus damage, one without, will yield the same damage number. I tested and have a screensot to show. Both weapons have the same dps and you can see that equipping the other weapon will not change the Damage. If you want the speadsheet to approximate the effects of that stat, just add the appropiate % in the Bonus Damage box. However, doing so will make the spreadsheet no longer match your in game Damage Number but should give an equivalent DPS on elites.

    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #165
    i see your point but i try it out with my gear and if i take of my skull grasp and add all stuff on the calculator is all good the dps math 100 %

    but if i equipe the skull grasp to my gear it get broken in the calculator i get less 500 dmg from in-game...

    idk if the problem is from ring's or if is only with the skull grasp.

    My point

    My gear with all equiped

    http://i.imgur.com/w9K3j.jpg
    http://i.imgur.com/q8wJf.png

    screen shoot from calculator with all gear equiped
    http://i.imgur.com/sPy5w.png



    same screenshoot but now without the stats from ring
    http://i.imgur.com/M71je.png

    Now my stats if i take off grasp

    http://i.imgur.com/LX1xd.jpg


    plx take a look, and tks for looking
  • #166
    Quote from Mateite

    i see your point but i try it out with my gear and if i take of my skull grasp and add all stuff on the calculator is all good the dps math 100 %

    but if i equipe the skull grasp to my gear it get broken in the calculator i get less 500 dmg from in-game...

    idk if the problem is from ring's or if is only with the skull grasp.

    My point

    My gear with all equiped

    http://i.imgur.com/w9K3j.jpg
    http://i.imgur.com/q8wJf.png

    screen shoot from calculator with all gear equiped
    http://i.imgur.com/sPy5w.png



    same screenshoot but now without the stats from ring
    http://i.imgur.com/M71je.png

    Now my stats if i take off grasp

    http://i.imgur.com/LX1xd.jpg


    plx take a look, and tks for looking


    I believe it is the bonus damage from the ring. I've seen a few cases where bonus damage on rings and amulets seems to not be the actual amount shown on the tooltip. Try increasing the min damage of the ring in the spreadsheet by 1 at a time and see if you can get an exact match between the spreadsheet and in game. If you can find an integer value that gives a match, then I believe there is a tooltip error for the ring.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #167
    Quote from Loroese

    Quote from Mateite

    i see your point but i try it out with my gear and if i take of my skull grasp and add all stuff on the calculator is all good the dps math 100 %

    but if i equipe the skull grasp to my gear it get broken in the calculator i get less 500 dmg from in-game...

    idk if the problem is from ring's or if is only with the skull grasp.

    My point

    My gear with all equiped

    http://i.imgur.com/w9K3j.jpg
    http://i.imgur.com/q8wJf.png

    screen shoot from calculator with all gear equiped
    http://i.imgur.com/sPy5w.png



    same screenshoot but now without the stats from ring
    http://i.imgur.com/M71je.png

    Now my stats if i take off grasp

    http://i.imgur.com/LX1xd.jpg


    plx take a look, and tks for looking


    I believe it is the bonus damage from the ring. I've seen a few cases where bonus damage on rings and amulets seems to not be the actual amount shown on the tooltip. Try increasing the min damage of the ring in the spreadsheet by 1 at a time and see if you can get an exact match between the spreadsheet and in game. If you can find an integer value that gives a match, then I believe there is a tooltip error for the ring.


    i try it and the value is "12" and it can be on max and on min dmg in any plce evem on weapon... so it may not be problem from calculator but from the game... idk
  • #168
    Yeah, because it is an integer value I expect the tooltip is wrong on your ring. In other words your ring says +19-37 but it is effectively +23-45 or something like that, or at least that is the value according to your damage number. In terms of DPS, +min damage = +max damage and it doesn't really matter where it shows up since all values are added directly to the weapon anyway and then averaged to calculate the effective weapon dps, that's why you could add the 12 damage to weapon damage, min damage, or max damage and still get the same results.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #169
    I made a minor addition today in the form of some quick and rough Life Steal/Life On Hit calculations. Basically I got a new wand and was curious what the equivalent Life On Hit would be for that weapon based on my current stats and Arcane Orb.

    There are 3 new boxes you can fill in are found in the "Equipped Items" tab: "Skill Weapon Damage %", "Life Steal", and "LoH Coefficient".

    The first box is just the weapon damage % of whatever skill you want to look at. For me it's Arcane orb and I don't use the obliterate rune so it does 175% weapon damage. The next box is simply how much Life Steal you have or how much you want to examine. The last box is the life gain coefficient for the rune you are using. For convenience I have copied and pasted the approximate coefficients found on the battle.net forums and provided a link the the source thread. I use Celestial Orb rune so my coefficient is 20%, found in the "LoH Coefficient" tab.

    The results are shown directly below the DPS. It reports your average hit from the skill in question, taking into account your crit info and attack speed. It uses that info and the Life Steal value to calculate how much life you gain per attack on average. Then it uses that info and what the LoH coefficient is for that skill to give you an equivalent LoH amount needed to equal the Life Steal. The idea being you can compare the two to see which will benefit you more or to simply compare the two values (LoH vs Life Steal).


    Use this information at your own discretion. It likely isn't very useful to many people but for those using a kiting spec and shopping for a LoH weapon, hopefully you can use this to see if you're better off getting a life steal weapon instead, which would hopefully be cheaper. Those using a melee type build might see greatly differing results depending on the skills used.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #170
    Another small update:

    7-17-12 Added logic box for Archon form to display EHP while the ability is active. Equipped Comparison tab also takes the box into account, but remember that EHP only applies while the form is active
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #171
    Hello, first off I want to say thank you so much for the effort you put into the spreadsheet it's really amazing! Thank you!
    I want to use this really badly but im having some trouble...

    https://docs.google.com/spreadsheet/ccc?key=0AircqRO_OFGzdDRab0pTSTFMZ2dwQzU2NmJWS3A2Z1E#gid=0

    here is a link to my spreadsheet
    im using the item comparison in the simple mode and i also tried it in the other one too... im trying to compare 2 pairs of gloves and some reason when i put them both in its showing -30k dps
    I dont understand what that means!!! I've been trying to figure out what this could mean or if i have it wrong and I just dont get it.. please help!!!!! in simple mode the item comparison has the 2 gloves (item 1) and (item2) values entered... please help with this... i just dont get why there is - or if its just +

    please let me know how this works when i just enter the values of 1 item and then enter the value of the 2nd i just want to know how much dps each one is or how much dps i will be gaining by the 2nd item. Thank you so much
  • #172
    Quote from hiyeon

    Hello, first off I want to say thank you so much for the effort you put into the spreadsheet it's really amazing! Thank you!
    I want to use this really badly but im having some trouble...

    https://docs.google....JWS3A2Z1E#gid=0

    here is a link to my spreadsheet
    im using the item comparison in the simple mode and i also tried it in the other one too... im trying to compare 2 pairs of gloves and some reason when i put them both in its showing -30k dps
    I dont understand what that means!!! I've been trying to figure out what this could mean or if i have it wrong and I just dont get it.. please help!!!!! in simple mode the item comparison has the 2 gloves (item 1) and (item2) values entered... please help with this... i just dont get why there is - or if its just +

    please let me know how this works when i just enter the values of 1 item and then enter the value of the 2nd i just want to know how much dps each one is or how much dps i will be gaining by the 2nd item. Thank you so much


    It's because you deleted the Max Weapon Damage in the Equipped collumn. Also, you don't have to input the same gloves into Item 2 since you already entered it into Equipped, but it is a good check to make sure it's worring correctly as it should give 0 dps change since it's the same as equipped.


    EDIT: Also, to use the "Equipped Comparison" tab, you have to enter your own gear in the "Equipped Items" tab, otherwise it will be comparing the stats of items to my current gear and use my own dps stats.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #173
    Thank you so much for this spreadsheet :)

    There's something that doesn't work for me. perhaps i'm doing something wrong, but the offhand min+max damage isn't calculated by my total DPS

    if i incrase the min+max dmg to my mainhand damage which normally is on my offhand, the dps is calculated spot on to my dps ingame

    Here's a link to the spreadsheet copy i made to my google docs
    https://docs.google.com/spreadsheet/ccc?key=0AmOUKYTlgfQQdHhmeWVUbG5RTUpVMXFZUmdWYUV5d2c

    so in short, it looks like it doesn't anticipate the min+max dmg from offhand waepons.

    Did i do something wrong here?
  • #174
    Quote from solipsist

    Thank you so much for this spreadsheet :)

    There's something that doesn't work for me. perhaps i'm doing something wrong, but the offhand min+max damage isn't calculated by my total DPS

    if i incrase the min+max dmg to my mainhand damage which normally is on my offhand, the dps is calculated spot on to my dps ingame

    Here's a link to the spreadsheet copy i made to my google docs
    https://docs.google....MXFZUmdWYUV5d2c

    so in short, it looks like it doesn't anticipate the min+max dmg from offhand waepons.

    Did i do something wrong here?


    Try putting the OH damage in the "Min+Dmg" and "Max+Dmg" box instead of the weapon damage boxes. The weapon damage boxes currently only work for the MH weapon while the other boxes work for all items.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • #175
    Quote from Loroese

    Quote from solipsist

    Thank you so much for this spreadsheet :)

    There's something that doesn't work for me. perhaps i'm doing something wrong, but the offhand min+max damage isn't calculated by my total DPS

    if i incrase the min+max dmg to my mainhand damage which normally is on my offhand, the dps is calculated spot on to my dps ingame

    Here's a link to the spreadsheet copy i made to my google docs
    https://docs.google....MXFZUmdWYUV5d2c

    so in short, it looks like it doesn't anticipate the min+max dmg from offhand waepons.

    Did i do something wrong here?


    Try putting the OH damage in the "Min+Dmg" and "Max+Dmg" box instead of the weapon damage boxes. The weapon damage boxes currently only work for the MH weapon while the other boxes work for all items.


    Thanks! i could of thought of that myself, i feel kinda stupid :P
    i can live with this workaround ;) Thanks :)
  • #176
    Thank you so much!!!!!! :D
  • #177
    Very cool, thanks a lot.
  • #178
    This thing is awsome, i can finally see how much of an upgrade an item is before i waste my hard earned gold on it xD
  • #179
    i love this thing, but i wish i could factor in my actual LOH and life per second, unless i'm not seeing it. Also since its for a wiz, i would like to know if there is a way to incorporate some kind of APoC slot. haha
    heavymetal#1322
    http://us.battle.net...22/hero/3153312 (wiz)
    http://us.battle.net/d3/en/profile/heavymetal-1322/hero/8654665 (monk)
    my twitch feed (just messing around, no super player or anything)
    http://www.justin.tv/heavymetalmak
  • #180
    Quote from heavymetalmak

    i love this thing, but i wish i could factor in my actual LOH and life per second, unless i'm not seeing it. Also since its for a wiz, i would like to know if there is a way to incorporate some kind of APoC slot. haha


    I don't plan to include those stats in my spreadsheet because they don't contribute to DPS or EHP and they tend to only be found on a few items, so it should be easy enough to keep track of. If you want to have that information available in your spreadsheet you can always add a row for it on the equipped items page. I actually added rows for MF and Life Regen in the copy I use for my MF set, just so I can see what my total Life Regen and MF is without having to enter a game.
    My EHP and DPS Spreadsheet, mostly useful for wizards.
    My wizard, mostly useful for killing demons and collecting loot.
    Wizard CM DPS Simulator, written in Matlab, release version 1.01
    Comprehensive CMWW Guide, including gear and build suggestions, plus Uber strats
    Arcane Mines Guide, detailed guide for the highest dps wizard build, including vids
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes