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
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
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
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
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
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
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
No, but I don't use magic weapon
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