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.

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.

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.

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

did you recast magic weapon after taking the gear off?

No, but I don't use magic weapon

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.

did you recast magic weapon after taking the gear off?

No, but I don't use magic weapon

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

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)?

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

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

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.

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

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

Private Mod Note
():

Rollback Post to RevisionRollBack

To post a comment, please login or register a new account.

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.

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.

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

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.

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

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

@Loroese: awesome stuff. your sheet is better than the ingame dps difference calculation

No, but I don't use magic weapon

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.

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

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)?

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

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

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

Crusader DPS and EHP Spreadsheet, meant for Crusaders

My Wizard

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

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