I'm sorry but I don't think you understand my question. My question is, have you tested the spreadsheet on a character with gear that I described? If you have not tested it personally, then I feel you might want to test it first. Theory is nice, but someone with actual experience is better. Please search the tal rasha set on the ah to see the stats I'm talking about. The reason I ask this is because some people might run into the problem that I ran into, and might need some clarification. And yes, the spreadsheet should work for other classes since we all use the same damage formula. The only thing that has to be changed besides gear and stats would be the passive damage bonus and weapon damage multipliers.
The spreadsheet is used to calculate what the damage value displayed in your character tab will be. The bonuses you are describing have no effect on that value.
I've recently changed my gear so I no longer have those bonuses, but when I have time tonight I'll go look for screenshots of my gear with those bonuses and then you can try it out.
I'm sorry but I don't think you understand my question. My question is, have you tested the spreadsheet on a character with gear that I described? If you have not tested it personally, then I feel you might want to test it first. Theory is nice, but someone with actual experience is better. Please search the tal rasha set on the ah to see the stats I'm talking about. The reason I ask this is because some people might run into the problem that I ran into, and might need some clarification. And yes, the spreadsheet should work for other classes since we all use the same damage formula. The only thing that has to be changed besides gear and stats would be the passive damage bonus and weapon damage multipliers.
Does this spreadsheet account for % increases damages of certain magic abilities such as a 6% increase in poison damage from the tal rasha neck and also a 3% increase in fire damage from the two set tal rasha bonus?
Well, that doesn't show in game, and also doesn't change with piece of gear is better, it's simply a multiplier.
If you really want to add it, change the "Total percentage dps increase from talents:" cell, instead of 20%, put 26, or 29% or whatever.
I don't think what you said is exactly true. From what I've seen in this spreadsheet so far, it seems to be using the formula (1+passive skill boosts)*(average weapon damage+((minimum damage bonus+maximum damage bonus)/2))*(weapon damage multipliers)*(attack speed)*(1+(crit %*crit damage %))*(1+(main stat/100)) as posted by Roflson on the battlenet forums and elsewhere. After using this formula in my own spreadsheet, the numbers that came out for my damage were much different from my character's in game damage. After speaking with Roflson, he concluded that his calculator (which uses this formula) did not seem to account for those bonuses I spoke of. I am currently using a 6% poison neck with 3% fire as the 2 set bonus. To account for all this, he calculated that I had to increase my passive bonus damage by 3.27%. If anyone has items like tal rasha's neck or the set bonuses, please try it and see what your results come out as.
Does this spreadsheet account for % increases damages of certain magic abilities such as a 6% increase in poison damage from the tal rasha neck and also a 3% increase in fire damage from the two set tal rasha bonus?
http://img69.imageshack.us/img69/7688/statsqp.jpg
Those are my stats, my neck adds 6% to poison damage and all attacks I use deal poison damage. The only thing I'm not sure is how much int/damage/attack speed I should sacrifice for crit chance/damage. Hopefully someone can come up with the numbers on how much each is weighted on our damage.
Critical hit chance is useless without critical hit damage. In my opinion you should at least have +100% crit damage, but you should be aiming at +200% crit damage. In my opinion you should have at least 25% crit chance as well.
It is pretty easy to find gear with all the good attributes and crit chance. For example: int, vit and crit chance.
Personally I have 40,5% crit chance and 115% crit damage, but I'm saving up for a ceremonial knife with 85-100% crit damage and 10-14 mana regen. Splinters is pretty awesome with this build already (I have over 2.0 attack speed as well)
200% crit damage means 3x the normal damage (100% doubles and 200% triples the damage). With 40% chance, it means almost my every other hit will do 3x damage. It's a very good way to increase the damage you deal.
I was wondering what the community thinks about crit (chance/hit damage) for a witch doctor. I noticed that a flawless square emerald increases damage more than a star ruby (on my weapon). I don't have a star emerald to compare but I will try to make one as soon as possible (once I get enough flawless square emeralds, only have 60 so far; donations of these are appreciated). I suppose crit hit damage might be worth more when you have more crit chance since a higher crit chance is a higher chance to "use" that crit hit damage. I'd like to hear what people think, as well as look at any calculations anyone has done. Please don't simply say "it sucks" or "it's good" without anything to back it up. Thanks.
0
0
0
0
0
0
0
0
0
0
Those are my stats, my neck adds 6% to poison damage and all attacks I use deal poison damage. The only thing I'm not sure is how much int/damage/attack speed I should sacrifice for crit chance/damage. Hopefully someone can come up with the numbers on how much each is weighted on our damage.
0
0