DPS and EHP Spreadsheet

  • #141
    Quote from b0ne123

    but i have a 824 dps 2h in my chest (200 int) it shows this dps value ingame and inah. thats confusing

    I'm sorry but I don't understand what the issue is. The weapon dps value is simply that: the weapon dps value. The actual damage you get from equipping the weapon is based on that weapon dps as well as additional stats like Int.


    Quote from rela

    hi, the spreadsheet works perfectly until i get the storm crow helm.

    not sure where to put to bonus +5% lightning damage.

    i tried placing it in to "bonus damage" box, but there is a dps discrepancy.

    the numbers match perfectly when i don't equip the helm.

    any suggestions?


    I haven't tried using any items with that kind of bonus so I'm not quite sure how they work. Would you mind sending me some data? I'll need the data used in the "Simple" tab to compute dps, namely weapon stats, total crit%, total crit damage%, total IAS, total int, total +bonus damage on other gear, as well as the stats of both helms and dps values with each helm. You can either post here or just pm me the data.
    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
  • #142
    oh wait, so the 5% lightning damage only applies to lightning spells???? which means i was told the wrong thing?
  • #143
    I don't know, and I haven't looked into it since I haven't been looking at any gear with those kind of stats, thus why I was asking for data.
    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
  • #144
    if it helps:

  • #145
    Thanks, but can you also post a screenshot of your weapon? And what is the damage of your OH+ any other bonus damage on jewelry?
    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
  • #146
    maybe you missed my last post :)
    will you look at the slightly discrepancy on the dps difference for int weapons?
  • #147
    Quote from b0ne123

    maybe you missed my last post :)
    will you look at the slightly discrepancy on the dps difference for int weapons?


    Sorry, I must have missed the post. I believe the anwer is the in game tooltip for damage comparison is wrong, as far as your damage number goes. If you equip the weapon you should see that the spreadsheet calculated the dps difference correctly but the in game difference shown in your screenshot is slightly off. I've noticed the same thing on most items I look at. It doesn't have anything to do with the Int, as far as I know.
    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
  • #148
    oh, will equip it and test it :)
  • #149
    First off, nice job on the spreadsheet :) Once I get it working I'm sure it will be an invaluable resource!

    I'm having a lot of trouble getting my DPS numbers to match up, in both the simple and the equipped items sheets. With full stats input, the simple calculation is about 2k DPS high, and the Equipped Items calculation is over 2 times too high. I've also tried getting naked except for a weapon, and the DPS numbers are still way off (though the spreadsheet may not work properly for this sort of thing, I don't know).

    I'm pretty sure I'm doing something simple very wrong, but I can't spot it. Could it be that i'm using a 1h?

    Note: In testing this, I found a bug where my ingame DPS varies by a few hundred dmg when I take of all my gear and then put it all back on again...

    image of weapon and stats: imgur.com/Uje5z

    Sample from Simple Calculations: All stats are unbuffed with no follower, no glass cannon
    Weapon (1h)
    795.2 DPS
    1.4 attacks/sec
    402-728
    +287 min dmg
    +319 max dmg
    No other DPS-relevant stats (AP on crit, LOH)

    Int: 1181
    Min+dmg 329
    Max+dmg 632
    (from weapon, above, ring 1: 13-24, ring 2: 13-24, amulet: 16-32, source 61-233)
    crit 31%
    crit dmg: 77%
    +Aspd 6%
    bonusdmg 0%
    Mod AS 1.484

    DPS total: 24619.16
    Ingame DPS: 19153.14

    Naked except for weapon:

    Weapon (1h)
    795.2 DPS
    1.4 attacks/sec
    402-728
    +287 min dmg
    +319 max dmg


    Int: 187
    Min+dmg 287
    Max+dmg 319
    (from weapon, above)
    crit 5%
    crit dmg: 50%
    +Aspd 0%
    bonusdmg 0%
    Mod AS 1.4

    Calculated DPS: 3587.17
    Ingame DPS: 2339.28

    edit: added a note
  • #150
    did you recast magic weapon after taking the gear off?


    @Loroese: awesome stuff. your sheet is better than the ingame dps difference calculation :)
  • #151
    Quote from b0ne123

    did you recast magic weapon after taking the gear off?



    No, but I don't use magic weapon :P
  • #152
    Quote from enilix

    Quote from b0ne123

    did you recast magic weapon after taking the gear off?



    No, but I don't use magic weapon :P


    I think I see a couple problems. First off, don't include your weapon +min or +max damage in the appropriate boxes, those are already included in the weapon damage range shown on the tooltip. Second, are you using a follower?

    I can't get the naked stats to work either, I still end up off by like 10 dps (2326.92 dps if I input weapon stats, int, and no +min/max dmg). Since your weapon has no +damage% it should match to within 0.01dps so I don't know what's going on, and have no idea why your dps would change when you remove and put gear back on. Do you have another weapon you can try? I've heard of some bugged tooltip displays where rings or such seem to give different +bonus damage than they display so I suppose it could be true for a weapon.
    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
  • #153
    Quote from Loroese

    Quote from enilix

    Quote from b0ne123

    did you recast magic weapon after taking the gear off?



    No, but I don't use magic weapon :P


    I think I see a couple problems. First off, don't include your weapon +min or +max damage in the appropriate boxes, those are already included in the weapon damage range shown on the tooltip. Second, are you using a follower?

    I can't get the naked stats to work either, I still end up off by like 10 dps (2326.92 dps if I input weapon stats, int, and no +min/max dmg). Since your weapon has no +damage% it should match to within 0.01dps so I don't know what's going on, and have no idea why your dps would change when you remove and put gear back on. Do you have another weapon you can try? I've heard of some bugged tooltip displays where rings or such seem to give different +bonus damage than they display so I suppose it could be true for a weapon.


    All values were obtained while not using a follower :( I played around with an old weapon, still not getting values to match up. Screencaps below, not sure where I'm going wrong. Sorry for not having direct links, forum won't let me.

    current stats and weapon: imgur.com/yWtH1,rlF5s#0
    spreadsheet input: imgur.com/FtVE2,ejxZw#0

    stats with old weapon imgur.com/yWtH1,rlF5s#1
    spreadsheet input: imgur.com/FtVE2,ejxZw#1
  • #154
    no classcannon?
  • #155
    Nope, no glass cannon, or familiar, or any other dps modifications as far as I can tell
  • #156
    Quote from enilix

    All values were obtained while not using a follower :( I played around with an old weapon, still not getting values to match up. Screencaps below, not sure where I'm going wrong. Sorry for not having direct links, forum won't let me.

    current stats and weapon: imgur.com/yWtH1,rlF5s#0
    spreadsheet input: imgur.com/FtVE2,ejxZw#0

    stats with old weapon imgur.com/yWtH1,rlF5s#1
    spreadsheet input: imgur.com/FtVE2,ejxZw#1


    I'm not entirely sure what is going on but if you add 60.8125 max damage to your total it makes the numbers work for both gear sets. Can you check the numbers without any of your +bonus damage gear (i.e., OH, amulet and rings)?
    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
  • #157
    Quote from Loroese

    I'm not entirely sure what is going on but if you add 60.8125 max damage to your total it makes the numbers work for both gear sets. Can you check the numbers without any of your +bonus damage gear (i.e., OH, amulet and rings)?


    took off rings, amulet, source, same weapon as in previous posts:
    int 1050
    crit 19%
    critdmg 77%
    Aspd 0%
    bonus dmg 0%
    calculated dps 10482.68
    ingame dps 10482.68

    great success :D

    I tested further - I sequentially added in my Off-hand, then rings, recalculating after each item was equipped, and the spreadsheet and ingame DPS continued to agree.

    UNTIL.. I added my amulet. Then the numbers started to be off. I took off all other sources of +dmg except for the amulet, and still the numbers were off. I suppose there could be something wonky in the way the spreadsheet calculates +dmg on amulets, though I think there is another more likely problem:

    I have a Tal Rasha amulet, which has "Adds 6% to Cold Damage" - it is possible that this may be being miscalculated somewhere, either in the ingame tooltip (probably lol) or on the spreadsheet.

    Full stats for the amulet are
    16-32dmg
    Adds 6% to Cold Damage
    131 int
    138 vit
    47 lightning res

    My simple spreadsheet stats with the amulet but no other +dmg gear are:
    attacks per second 1.4
    weap+ aspd 0
    min weap dmg 408
    max weap dmg 728
    int 1181
    min+dmg 16
    max+dmg 32
    crit% 19
    crit dmg% 77
    aspd% 0

    calculated dps 12170.18
    ingame dps 12795.27 (difference of 625.09)

    12795.26 * 0.06 = 767.7162 .. so its not directly a 6% bonus to dmg from the amulet. No idea what is happening.


    I'm going to play with the full gear calculator in a bit, I'm sure I'll find a way to mess it up too :)
  • #158
    Yeah, that +x% elemental damage is odd. I haven't messed with it a lot and so far can't quite figure out what it's doing to the damage number. So far I don't have any functionality for it in my spreadsheet.
    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
  • #159
    Well, to add to the weirdness of it...

    using the full equipment calculator, with all buffs set to 0, and no ingame buffs:
    all values (int, armour, AR etc) matched ingame and on the spreadsheet. The only value that doesn't match is the DPS.

    calculated DPS: 18114.43
    ingame DPS: 18712.07

    Same paramaters but with amulet removed:

    calculated DPS: 15821.89
    ingame DPS: 15821.89

    With my +goldfind amulet

    calculated DPS: 17151.81
    ingame DPS: 17151.81

    I'm no theorycrafting expert, but I would say that proves the +cold damage is the source of the discrepancy between the ingame DPS tooltip and the spreadsheet :o
  • #160
    yes the +ele damage is a bit weird.

    if it helps i realise there is a difference in the dps number btw
    1. equipping the storm crow helmet after wearing the magic source
    2. equipping the source after storm crow helmet
  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes