I made a minor change to the spreadsheet today. I added a box for +attack speed % in the MH column in the Item Comparison tab. This is mainly for anyone wanting to compare a new 1h+OH combo with current 2h.
Fixed an error in which I was using the 1.0.5 values for Energy Armor and Prismatic Armor. The current version of the spreadsheet should be using the 1.0.4 values.
The EHP Threshhold table has also been corrected. I had accounted for the expected 25% inferno nerf in the separate version of the spreadsheet I update continually with my gear before converting to the published version.
hi, for some reason the calculator shows that my DPS is ~120k, but in game it's only a bit over half of that... what am i missing? the char profile - eu.battle.net/d3/en/profile/Sanzi-2486/hero/17847684
Edit: k, found it - i was putting the the +49% damage to the "bonus damage %" field, where it's not suppose to be.. where should i put the +% damage bonus from weapon? or it doesn't matter?
so i took the "+% damage" away, but still, it shows like 20k more DPS than it's in game. The character stats (green in the spreadsheet) all match the in game ones, but the DPS is off..
If you read the notes or the first post, it clearly says to not put your bonus damage % anywhere in the spreadsheet. If you dont have it listed anywhere but are still having issues, I'll need to see a screenshot or something of your entries.
EDIT: I'm going to take a guess and assume you're putting in the bonus damage from your weapon somewhere. Don't do that. I dont just mean the bonus damage % but also the +min and +max damage. If that's not the case, just post a screenshot of your Equipped Items page and I should be able to figure out what's going on.
hi, for some reason the calculator shows that my DPS is ~120k, but in game it's only a bit over half of that... what am i missing? the char profile - eu.battle.net/d3/en/profile/Sanzi-2486/hero/17847684
Edit: k, found it - i was putting the the +49% damage to the "bonus damage %" field, where it's not suppose to be.. where should i put the +% damage bonus from weapon? or it doesn't matter?
so i took the "+% damage" away, but still, it shows like 20k more DPS than it's in game. The character stats (green in the spreadsheet) all match the in game ones, but the DPS is off..
If you read the notes or the first post, it clearly says to not put your bonus damage % anywhere in the spreadsheet. If you dont have it listed anywhere but are still having issues, I'll need to see a screenshot or something of your entries.
EDIT: I'm going to take a guess and assume you're putting in the bonus damage from your weapon somewhere. Don't do that. I dont just mean the bonus damage % but also the +min and +max damage. If that's not the case, just post a screenshot of your Equipped Items page and I should be able to figure out what's going on.
Yeah, i rushed a bit with the post, before reading the notes clearly. Yes, you're right, i was putting the +min +max damage in the wrong place. Are these stats entered in the spreadsheet at all? i have +228 min and +245 max dmg and +48% damage on my weapon, does that affect the DPS at all, where do i put them?
No, for the weapon those are not entered at all. If you have bonus elemental damage instead, you would enter it because it plays a role with dps calculation involving "Adds +x elemental damage" affixes. The reason those aren't entered is they are already taken into account to calculate the damage range of your weapon in the tooltip.
Now with the problem: the spreadsheet is showing a DPS value that is about 1.2k DPS under what is shown in-game. I triple checked every value, and couldn't find the culprit (my weapon does not have +% dmg). I'll leave a screenshot.
If you (or anyone) can help me figure it out, it'd be much appreciated.
Do you have a link to your online profile I can see to check everything out? You're welcome to PM it if you'd prefer to keep it off the forums.
EDIT: Do you have some bonus damage on jewelery, in some combination of min and max damage that totals 67? If so you should include those values in the min+damage and max+damage boxes.
I fixed some bugs with the Item Comparison when using the 2h compare option with a 1h+OH equipped. The bugs were mostly EHP related but also the socket wasn't being treated correctly if one was present on OH. Instead it was being carried over to the new 2h setup in the item comparison.
I added DPS and EHP stat weights to the Equipped Items tab because the values in the Simple tab don't take everything into account since it is no longer being updated. I also included stat weights relative to 1 Int for reference so you can get an idea of how much Int 1% crit is worth (for my gear, 1% crit is effectively the same as 32.7 Int).
Note that these stat weights are only exact for adding one specific stat. If you add 1% crit AND 1 Int, the weights won't be exact. For an example, 10% crit is worth 327 Int for me, dropping 10% crit for 327 Int won't necessarily give me the same dps. They're more useful as a rough guide when searching for upgrades on the AH but to get more precise results, use the Equipped Comparison tab.
Hello, very nice spreadsheet!
Used it for a while and everything was calculated perfectly. But now dps differs significantly from the number shown in game.
Here is my spreadsheet (i reverted colors): docs google com/spreadsheet/ccc?key=0AniZnRV_QC-zdDBQQ2JYWHZMU2VyTElkQURVT2s5R2c
And here is my in game screenshot: ompldr org/vZmw2ZQ
The difference started with new Ring 2 shown at the screenshot. If i put it off dps is exact. Am i doing something wrong?
Hello, very nice spreadsheet!
Used it for a while and everything was calculated perfectly. But now dps differs significantly from the number shown in game.
Here is my spreadsheet (i reverted colors): docs google com/spreadsheet/ccc?key=0AniZnRV_QC-zdDBQQ2JYWHZMU2VyTElkQURVT2s5R2c
And here is my in game screenshot: ompldr org/vZmw2ZQ
The difference started with new Ring 2 shown at the screenshot. If i put it off dps is exact. Am i doing something wrong?
P.S. can't post urls, LOL
I don't think you're doing anything wrong if it works exactly for everything if you remove the ring. It might be the ring. I've seen a few instances where the actual damage range shown on a ring doesn't really match with the dps gained from the ring. Just to be clear, you don't have any follower selected in the screenshot?
If you add 22 damage somewhere, like change the ring damage from 11-24 to 22-35, it should give you the correct dps value. Try that, and remove a couple pieces and see if it still keeps the correct dps. I think you just got one of those strange rings that doesn't display the correct damage.
If you add 22 damage somewhere, like change the ring damage from 11-24 to 22-35, it should give you the correct dps value. Try that, and remove a couple pieces and see if it still keeps the correct dps. I think you just got one of those strange rings that doesn't display the correct damage.
Yes, this solved my problem! Thanks! I was lucky to buy even better ring than it looks like:)
I updated EHP threshold tables to take the previous damage reduction in Inferno to be multiplied by (1-0.15) instead of divided by (1+0.15). This is based on the expected upcoming damage reduction and how it was presented in a blue post.
Also at some point I had added the upcoming Inferno damage reduction to the EHP table but it has now been corrected.
EDIT: I finally looked up how to correctly spell threshold, so my apologies if it was driving anyone crazy.
Ah, been using this for a while, just haven't yet offered my thanks for this. Sure helped making my decisions a hell of a lot easier.
Sold off my Zuni Marrow and one of my trifecta rings, switched to Tal Rasha's chest and Zuni Pox, all while gaining a hefty amount of gold in profit (who would've thought?). Would've really regretted that decision if it didn't work out in my favor.
Hey, AMAZING work on this spreadsheet.
It has helped me SO MUCH in choosing my gear.
I'm having an issue where in the Equipped Comparison tab, It thinks an Echoing Fury will increase my DPS by 10,829, but in game it only actually increases it by 558. Luckily I got it cheap so it wasn't a devastating purchase, but I'd like to know whats wrong.
I have no idea how "+0.24 attacks per second" works on the Echoing Fury, and did not put it anywhere into the spreadsheet.
I'm guessing the weapon's tool tip attack speed is already updated with it.
I double checked all of the stats on the Equipped Items page.
Everything lines up except my overall dps without magic weapon or sparkflint is listed as: 50563.85 vs. in-game: 50579.60. I don't care about that small difference.
Do you have any idea whats going wrong? If you need any other info let me know.
(I'm not allowed to post URLs yet unfortunately)
http:// i.imgur.com/jTzJz.jpg
http:// i.imgur.com/JTjhG.jpg
Hey, AMAZING work on this spreadsheet.
It has helped me SO MUCH in choosing my gear.
I'm having an issue where in the Equipped Comparison tab, It thinks an Echoing Fury will increase my DPS by 10,829, but in game it only actually increases it by 558. Luckily I got it cheap so it wasn't a devastating purchase, but I'd like to know whats wrong.
I have no idea how "+0.24 attacks per second" works on the Echoing Fury, and did not put it anywhere into the spreadsheet.
I'm guessing the weapon's tool tip attack speed is already updated with it.
I double checked all of the stats on the Equipped Items page.
Everything lines up except my overall dps without magic weapon or sparkflint is listed as: 50563.85 vs. in-game: 50579.60. I don't care about that small difference.
Do you have any idea whats going wrong? If you need any other info let me know.
(I'm not allowed to post URLs yet unfortunately)
http:// i.imgur.com/jTzJz.jpg
http:// i.imgur.com/JTjhG.jpg
You need to put the +0.24 attacks per second into the +attack speed box, in addition to putting the tooltip displayed attacks per second in the top box. Also, don't put anything in the min+ dmg and max +dmg boxes. That's only meant to be used when you're trying to compare a 1h+OH to an equipped 2h. Those values are already included in the weapon damage range.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
The EHP Threshhold table has also been corrected. I had accounted for the expected 25% inferno nerf in the separate version of the spreadsheet I update continually with my gear before converting to the published version.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
If you read the notes or the first post, it clearly says to not put your bonus damage % anywhere in the spreadsheet. If you dont have it listed anywhere but are still having issues, I'll need to see a screenshot or something of your entries.
EDIT: I'm going to take a guess and assume you're putting in the bonus damage from your weapon somewhere. Don't do that. I dont just mean the bonus damage % but also the +min and +max damage. If that's not the case, just post a screenshot of your Equipped Items page and I should be able to figure out what's going on.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
No, for the weapon those are not entered at all. If you have bonus elemental damage instead, you would enter it because it plays a role with dps calculation involving "Adds +x elemental damage" affixes. The reason those aren't entered is they are already taken into account to calculate the damage range of your weapon in the tooltip.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Do you have a link to your online profile I can see to check everything out? You're welcome to PM it if you'd prefer to keep it off the forums.
EDIT: Do you have some bonus damage on jewelery, in some combination of min and max damage that totals 67? If so you should include those values in the min+damage and max+damage boxes.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I fixed some bugs with the Item Comparison when using the 2h compare option with a 1h+OH equipped. The bugs were mostly EHP related but also the socket wasn't being treated correctly if one was present on OH. Instead it was being carried over to the new 2h setup in the item comparison.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I added DPS and EHP stat weights to the Equipped Items tab because the values in the Simple tab don't take everything into account since it is no longer being updated. I also included stat weights relative to 1 Int for reference so you can get an idea of how much Int 1% crit is worth (for my gear, 1% crit is effectively the same as 32.7 Int).
Note that these stat weights are only exact for adding one specific stat. If you add 1% crit AND 1 Int, the weights won't be exact. For an example, 10% crit is worth 327 Int for me, dropping 10% crit for 327 Int won't necessarily give me the same dps. They're more useful as a rough guide when searching for upgrades on the AH but to get more precise results, use the Equipped Comparison tab.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I once again had the wrong Energy Armor and Prismatic Armor coefficients. They should be correct for 1.0.4 now.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
You'll have to save a copy of it to your hard drive to be able to use it.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Used it for a while and everything was calculated perfectly. But now dps differs significantly from the number shown in game.
Here is my spreadsheet (i reverted colors): docs google com/spreadsheet/ccc?key=0AniZnRV_QC-zdDBQQ2JYWHZMU2VyTElkQURVT2s5R2c
And here is my in game screenshot: ompldr org/vZmw2ZQ
The difference started with new Ring 2 shown at the screenshot. If i put it off dps is exact. Am i doing something wrong?
P.S. can't post urls, LOL
I don't think you're doing anything wrong if it works exactly for everything if you remove the ring. It might be the ring. I've seen a few instances where the actual damage range shown on a ring doesn't really match with the dps gained from the ring. Just to be clear, you don't have any follower selected in the screenshot?
If you add 22 damage somewhere, like change the ring damage from 11-24 to 22-35, it should give you the correct dps value. Try that, and remove a couple pieces and see if it still keeps the correct dps. I think you just got one of those strange rings that doesn't display the correct damage.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Yes, this solved my problem! Thanks! I was lucky to buy even better ring than it looks like:)
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Corrected the Bonus Damage and +Damage% as Elemental boxes in the MH column of the Equipped Comparison tab.
Also fixed the relative dps gain from +max damage since it was setting the new +max damage to 1 instead of just adding 1 to the existing value.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
I updated EHP threshold tables to take the previous damage reduction in Inferno to be multiplied by (1-0.15) instead of divided by (1+0.15). This is based on the expected upcoming damage reduction and how it was presented in a blue post.
Also at some point I had added the upcoming Inferno damage reduction to the EHP table but it has now been corrected.
EDIT: I finally looked up how to correctly spell threshold, so my apologies if it was driving anyone crazy.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard
Sold off my Zuni Marrow and one of my trifecta rings, switched to Tal Rasha's chest and Zuni Pox, all while gaining a hefty amount of gold in profit (who would've thought?). Would've really regretted that decision if it didn't work out in my favor.
Armory | YouTube | Twitter | Clan Site
It has helped me SO MUCH in choosing my gear.
I'm having an issue where in the Equipped Comparison tab, It thinks an Echoing Fury will increase my DPS by 10,829, but in game it only actually increases it by 558. Luckily I got it cheap so it wasn't a devastating purchase, but I'd like to know whats wrong.
I have no idea how "+0.24 attacks per second" works on the Echoing Fury, and did not put it anywhere into the spreadsheet.
I'm guessing the weapon's tool tip attack speed is already updated with it.
I double checked all of the stats on the Equipped Items page.
Everything lines up except my overall dps without magic weapon or sparkflint is listed as: 50563.85 vs. in-game: 50579.60. I don't care about that small difference.
Do you have any idea whats going wrong? If you need any other info let me know.
(I'm not allowed to post URLs yet unfortunately)
http:// i.imgur.com/jTzJz.jpg
http:// i.imgur.com/JTjhG.jpg
You need to put the +0.24 attacks per second into the +attack speed box, in addition to putting the tooltip displayed attacks per second in the top box. Also, don't put anything in the min+ dmg and max +dmg boxes. That's only meant to be used when you're trying to compare a 1h+OH to an equipped 2h. Those values are already included in the weapon damage range.
Crusader DPS and EHP Spreadsheet, meant for Crusaders
My Wizard