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. :)

Here are some links which go into more detail about how poison works:

Calculating Poison Damage (http://diablo2.diablowiki.net/Guide:Calculating_Poison_Damage_v1.10,_by_onderdui ker)
Poison Skills Information (http://diablo.incgamers.com/forums/showthread.php?t=712653)
Rabies Mechanics (http://diablo.incgamers.com/forums/showthread.php?t=717215)

UPDATE 24 MARCH 2010 I've updated the calculator to take account of Poison Nova's increased damage in 1.13.

UPDATE 30 SEPTEMBER 2012 I've updated the calculator to correct poison length calculation for Multiple Shot, Strafe, Blade Sentinel, Blade Fury and Blade Shield. However, I experienced an error when attempting to upload the new version and unfortunately I had already deleted the old version. The updated calculator can be downloaded by clicking on the following link:


Poison damage calculator.xls (http://www.box.net/shared/s1knzg3hyh)


Those who do not have Microsoft Office can still access this spreadsheet by downloading OpenOffice (http://www.openoffice.org/) for free.

UPDATE 24 NOVEMBER 2012 I've updated the calculator to add poison damage and length from charms and jewels, following an error report from Zyr of the Amazon Basin forums.

[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).

[onderduiker]

I've now updated the calculator to take account of Poison Nova's increased damage in 1.13.

[Victus]

Hi,onderduiker! Can you attach a xls file for those who play v1.12?
Thanks in advance!

[onderduiker]

I've uploaded the 1.12 Poison damage calculator as requested. :)

[Strata]

First off, thank you for this! Stumbled across it and it is an impressive thing =)

So I think I did this correctly lol.

This look right?

I just saw the damage at the end and was surprised @_@

http://farm5.static.flickr.com/4043/4648763402_f387de8361_b.jpg

[onderduiker]

Yes, that's correct. Bear in mind that Poison Nova's base damage was increased by approximately 15% in 1.13, and -% Enemy Poison Resistance not only reduces Poison Resist % of monsters not Immune to Poison but also normally increases poison length.

That calculated damage would also only be applied to monsters with PR <28%: you need to enter values in the PR % column to see how much damage would actually be applied to, say, PR 50%, 75% or 100%.

[Strata]

Ah okay, I totally overlooked that column. Thanks for the help =)

[stra]

i was looking the poison duration of the 2/3 infernal set output of your calculator and i was surprised that showed 3.2 sec and not 1 second as the area summit stated. Anything worth?

[onderduiker]

I've double checked Sets.txt and this is the relevant information:



name version level PCode2a PParam2a PMin2a PMax2a
------------------------------------------------------------------
Infernal Tools 0 7 dmg-pois 80 25 25
So the Partial Set Bonus for equipping two items is 25 minimum and 25 maximum poison bit rate applied for 80 frames, resulting in 7 208/256 poison damage over 3.2 seconds (displayed as 8 Poison Damage Over 3 Seconds). The Arreat Summit lists this correctly under Complete Set Bonus for Infernal Tools (http://classic.battle.net/diablo2exp/items/sets/sets2.shtml#infernal), as it does with other Partial Set Bonuses for other sets, so the Partial Set Bonus is wrong (it should be 8 Poison Damage Over 3 Seconds):



http://img21.imageshack.us/img21/8599/infernaltools.jpg

[Zorakron]

Can I just use Open Office for the Calculator or do I have to purchase Excel?

[Zorakron]

Can I just use Open Office for the Calculator or do I have to purchase Excel?

OpenOffice works just fine as an alternative to Excel and it's FREE!

[DragonsDream]

I'm curious about something here. My understanding of Poison Dagger was that the rate of all other sources was added to the rate of pdagger, such that the duration could never be less than the base duration of pdagger alone. The calculator however, seems to count pdagger and just another source. am I misreading something here?

[onderduiker]

The poison damage rates of items and Venom add to that of Poison Dagger: rate is damage per unit time, the smallest unit of which is a frame, or 1/25 second. The smallest unit of damage is a bit, or 1/256 point.

However, the length for which this combined rate is applied is calculated by adding the lengths of all items to that of PD, then dividing by the number of items. This means that with a sufficient number of items with short lengths, the calculated length may actually be less than that of PD, which can result in less total poison damage (even though more poison damage is applied per frame).

When Venom is applied then length is just that of PD and Venom since Venom overrides poison lengths of items. Also bear in mind that -% Enemy Poison Resistance can increase poison length.

I'll add some links to the opening post which may prove useful in understanding how poison works.

[DragonsDream]

ok, damn, that is different than the way I remember it being. I need to rethink my daggermancer that I'm playing right now then. Here I've been saving up all my toxic small charms (and various poison pre & suffix small charms like a toxic small charm of anthrax) since I thought duration would always be at least the length of pdagger. so do I need to cast venom to use multiple sources or are they still not worth it?

Note, I am not soloing, my partner is playing a lightning zon so I'm more for support & dealing with lightning immunes

[onderduiker]

Ideally Venom should be cast since it significantly increases damage rate and guarantees that poison length will be at least that of Poison Dagger plus Venom's 10 frames. The most accessible and reliable source would be a Treachery rune word armour's 25% Chance to Cast Level 15 Venom on Striking.

Poison damage items will always increase damage rate, but when compared to the damage rate of PD and Venom it isn't really worth going out of your way to equip them. However, in the absence of Venom I'd advise using the calculator to see the effects of adding poison damage items: start with the item with the longest length and add items with progressively shorter lengths until your total damage is less than PD alone (although you'll almost certainly find that equipping the longest length item alone will result in maximum total damage).

[jhep]

hello everybody
i just found the last piece a trangoul's avatar, which made me respec my bonemancer into a poisonmancer...
then i tried using treachery instead of trangouls armor for venom (i use blackbog and no other source of poison
but i tried on mephisto and it seems that casting venom before changes very little the damage (about 3/4 of his life) so nothing close to the huge bitrate addition everybody talks about... is venom really compatible with pdagger ? looks like it does not.

[onderduiker]

Mephisto has 94,320 base life in Ladder and single player games, and Poison Resist 75%: level 40 Poison Dagger with 40 points in synergy skills, Blackbog's Sharp Unique Cinquedeas, +25% Poison Skill Damage, level 10 Lower Resist and -25% Enemy Poison Resistance applies 64,097-65,848 poison damage over 34.48 seconds to him at an approximate rate of 1,859-1,910 per second.

Casting level 15 Venom with +25% PSD results in 69,911-72,897 poison damage over 22.48 seconds to him (so only approximately 10% more total damage) at an approximate rate of 3,110-3,243 per second (approximately 69% more). Although only 10% more total damage is applied, it takes 12 seconds less to do so.

Casting Venom can allow you to equip Rainbow Facet Unique Jewels, the only other -% EPR source available when using PD, without their 2 second poison length adversely affecting poison length and thus total damage. Add 4 average Jewels (+16% PSD and -16% EPR for +41%/-41% in total) and without Venom only 25,409-26,070 poison damage over 10 seconds is applied at an approximate rate of 2,541-2,607 per second; with level 15 Venom, 110,954-115,680 poison damage over 25.36 seconds is applied at an approximate rate of 4,375-4,562 per second, which would kill Mephisto at base life with a single stab. :)

[Necromanticus]

Is the poison nova damage messed up? I've entered 20 poison dagger | 20 poison explosion | 20 poison nova, and only get 356 - 390 poison damage over 2 seconds O_O , explain me please if I did it wrong...

[onderduiker]

It seems like you put 20 in the Level column for the Poison Dagger, Poison Explosion and Poison Nova rows: put 40 in the Synergy column for the Poison Nova row to apply the synergy bonus of 40 points in Poison Dagger and Poison Explosion.

Level 20 Poison Nova currently displays 400-440 Poison Damage Over 2 Seconds, so you're also using the calculator for patch 1.12: if you're playing patch 1.13 then you'll need to download the updated calculator attached to the opening post.

[Necromanticus]

oookkk! thank you =)
So, if I'm playing 1.13d, and using 1.12 calculator, I'm using the wrond one? That means that I have to download the first one? there are two, the first one says simply poison damaghe calculator, and the second one is for 1.12, so that means I need to download the "non-1.12" right? thanks
Oh by the way... GREAT WORK DUDE :D

[Necromanticus]

I'm actually making a Poison Nova necro on Diablo 2 (classic, non-expansion, whatever you want, where there are no Assassins and Druids),
and it seems that he's going to have around 3k dmg without lower res, and around 5k with lower res (lvl 10 low res), do you people think it is viable? I've had a poison necro on LoD, with 12k - 13k damage on character screen, with around -75% res from gear + lower resist (-55), and he was cutting everything in hell, without a problem, doing hell travi 8 ppl faster than a hammerdin. Will it have such success on classic where there's no godly gear nor runewords? I love psn necro :D

[onderduiker]

As far as I know, Classic monster resistances and immunities are the same as those in Expansion, and level-adjusted stats like life are similar. So with fewer skill bonuses and no +% Poison Skill Damage or -% Enemy Poison Resistance, Poison Nova will be nowhere near as powerful as it is in Expansion, although it may still get the job done (at least in games with lower player counts). I'd recommend checking the Classic (http://diablo.incgamers.com/forums/forumdisplay.php?115-Classic) forum, though.

[Bashev]

Why I cannot download the poison calculator?

[onderduiker]

I don't know, but I removed the existing attachments and uploaded it again (although not the 1.12 version). You should be able to download it now (I could).

[rushnoise]

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

Thanks!

[onderduiker]

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

Thanks!

Weirdly, the same question was asked (and answered) three years ago, almost word for word:


Hello!

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

Thanks!

cc


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).

[onderduiker]

I've updated the calculator to correct poison length calculation for Multiple Shot, Strafe, Blade Sentinel, Blade Fury and Blade Shield. However, I experienced an error when attempting to upload the new version and unfortunately I had already deleted the old version. The updated calculator can be downloaded by clicking on the following link:


Poison damage calculator.xls (http://www.box.net/shared/s1knzg3hyh)

Those who do not have Microsoft Office can still access this spreadsheet by downloading OpenOffice (http://www.openoffice.org/) for free.

[onderduiker]

I've updated the calculator to add poison damage and length from charms and jewels, following an error report from Zyr of the Amazon Basin forums.