DiabloFans

Quote from DrZey

Quote from verbatim21

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.

Quote from fr0d0b0ls0n

Quote from verbatim21

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?