Poison damage calculator.xls

[onderduiker]

I've recently finished work on a poison damage calculator for Diablo II. After a few revisions, I'm now reasonably confident that it's accurate (or at least, I've corrected all the errors that I've been able to identify myself).

It covers poison damage from both skills and items (and combinations thereof) with +% to Poison Skill Damage, -% to Enemy Poison Resistance, Lower Resist and the target's Poison Resist % and Poison Length Reduced by %. Unfortunately it doesn't really cover duelling, but it can still be used to help calculate poison damage to your opponents.

It's a Microsoft Excel worksheet. I've protected all the cells that don't need any input, and those that do require input are light grey or green. I've made some attempt to make it idiot-proof, but my expertise is limited (e.g. no list or check boxes) and it still operates mostly on the 'garbage in, garbage out' principle. It should (hopefully) be pretty self-explanatory and doesn't require in-depth knowledge (if you know that you can't equip two helms or socket a dagger with 6 perfect Emeralds, you shouldn't have any problems).

If you do have any problems, let me know and I'll see what I can do. :)

[stephan]

Hi and thanks. :)

Why is lower resist and -EPR disabled for disabled for Venom?

[onderduiker]

The row for Venom is only for when it's cast, so only skill level and +% to Poison Skill Damage are applied at that stage. You'll notice that when you enter values for Venom, its rate and length are added to all applicable skills, and then Lower Resist and -% to Enemy Poison Resistance (and +% PSD, where applicable) are applied to those skills.

Melee covers all melee attacks and Ranged covers all ranged attacks, with the exception of any poison skills and those that apply a fraction of weapon damage (with the exception of Lightning Bolt, which only applies lightning damage from converted physical damage and items).

[Corvus94]

Simply amazing. Good work! I've been looking for something like this for a long time. I've made a few poison nova necros the past few ladders and always wondered what the best gear setup was. After doing a few side by side comparisons, I'm happy to see I was on the right track. Thanks so much.

[crimsoncosmos]

Hello!

Would you mind explaining what should be entered in the Synergies column? I'm not entirely sure.

Thanks!

cc

[onderduiker]

The number of skill points invested in synergy skills should be entered in the synergy column. For example, if you're calculating Poison Dagger damage and you have 15 points in Poison Explosion and 10 points in Poison Nova, you should enter 25 (15+10).

Although you can enter any number you like, I'm imposed conditions on the calculation so that invalid entries won't be considered: entering negative numbers will have the same result as zero, and higher than maximum synergy points will have the same result as maximum synergy points (e.g. entering 400 for Poison Dagger has the same result as 40, or 20 points each in Poison Explosion and Nova).

[Crowd Control]

That thing is fantastic! Though I have to assume all your numbers are right. And on top of that I have to read back up on bitrate and stuff. But........this is a major contribution to this forums.

:thumbsup::thumbup:

[onderduiker]

I tested to confirm exactly how poison damage is calculated, and I'm personally satisfied that the calculator is as accurate as it can be: unfortunately, at this stage it's unlikely that someone will take the time to confirm this independently. :\

The Calculating Poison Damage (http://diablo.incgamers.com/forums/showthread.php?t=711678) thread should answer your questions on things like bit rate (and includes a link to an archived copy of the Tao of Poison).


While I'm at it, I'll also include links to the Poison Skills Information (http://diablo.incgamers.com/forums/showthread.php?t=712653) thread in the Necromancer forum and the Rabies Mechanics (http://diablo.incgamers.com/forums/showthread.php?t=717215) thread in the Druid forum, for those that are interested in those skills. :)

[Poisonous]

Ive returned to D2 after a decently long break, and after spending a few hours looking over the net trying to get caught up to speed this thread (and its related guides) have answered 99% of the questions I had. I am so glad I found this thread, and I want to extend my thanks for the hours of work put in to produce such a professional quality result. What more can I really say, thank you very much!

[Iss]

Ello,
This chart appears to quite sound. I have a question however...
After the Lower Resist cells, there is a PR% and a PLR%--I assume one of them has to do with psn length?
Could somebody smarter than I, please clarify?

[SnickerSnack]

The first is Poison Resist and the other is Poison Length Reduction. I'm pretty sure that they both affect poison length.

[onderduiker]

The first is Poison Resist and the other is Poison Length Reduction. I'm pretty sure that they both affect poison length.
Unlike Cold Resist %, Poison Resist % only applies to damage, not length: thus casting Lower Resist (which applies PR -%) only increases damage, not length.

The only monsters that can have Poison Length Reduced by % are Ancients who spawn with these affixes on their magic equipment: against all other monsters, -% to Enemy Poison Resistance will increase poison length by the displayed percentage, up to a limit of -100% EPR (doubling length).