POE Damage Calculator

I do damage calculations sometimes, and it can get a bit tedious. Not to mention, the more things you have to take into consideration in your calculations, the greater the likelihood you'll leave something out, or make a mistake somewhere. So I whipped up a little spreadsheet to do it for me.

The current version (and so far, only version) is located here:

https://docs.google.com/spreadsheet/ccc?key=0Aj1142IVfdwcdEpYSlFCQnNlVHJoOVJQYjZmVG9uT0E#gid=0

Instructions:

1) File -> Make a copy, name it whatever you want. It'll get saved automatically to your google drive, where you can work with it freely. The original is read-only.

2) Fill in the blue cells with relevant values. Pink cells have formulas in them, so don't touch them.

Damage bonuses/penalties should be entered in decimal form, not as percentages, with an additive bonus being some value over 0, and a multiplicative being some value over 1. So basically, "15% increased" is 0.15 additive, and "15% more" is 1.15 multiplicative. A bit weird, but it keeps the formulas clean and makes it easy for me to read and edit them if necesary.

Note that physical damage from weapons is handled differently from physical damage from other sources (such as rings), so they are separated into two different rows. Be sure to keep them separate. There should be no overlap between weapon and non-weapon bonuses.

Damage conversion should be entered as a decimal also, not as a percentage. Damage conversion from skill gems (Lightning arrow, for example) is treated a bit differently from damage conversion from other sources (such as Blackgleam quiver), so they are separated into two different columns.

Don't forget to enter your strength, if applicable, and percentage damage effectiveness of the skill.

You can use the Other row for any miscellaneous damage bonuses or penalties that affect both physical and elemental damage, such as 50% less damage from using Chain, increased projectile damage passives, and so on.

Some examples:

"45% increased physical damage with maces" is entered as 0.45 in additive column, in the Physical (weapon only) row

"95% increased physical damage" on level 20 heavy strike is entered as 0.95 in additive column, in the Physical (non-weapon) row

"50% increased elemental damage with weapons" from the Catalyze cluster is entered as 0.5 in additive column, in Elemental row

"80% more weapon elemental damage" from level 20 WED support gem is entered as 1.8 in multiplicative column, in Elemental row

"30% less projectile damage" from Lesser Multiple Projectiles support gem is entered as 0.7 in multiplicative column, in Other row

"50% damage converted to lightning" on Lightning Arrow is entered as 0.5 in Converted to (from skill gems) column in Lightning row

"39% damage added as fire" on Added Fire Damage support gem is entered as 0.39 in Added as column in Fire row


Missing features:
Dual wielding, crit, accuracy, attack speed, dps. None of these things are implemented yet. I'll probably add them soon.

Bugs, issues:
There may be some rounding errors when dealing with low amounts of damage, but the results should still be very close.

I tested this with my own character and the results perfectly matched the tooltip damage values in game, but there may certainly be some errors I didn't catch. Please let me know if you are getting incorrect results.

Anyone is free to make modifications or improvements to this and is highly encouraged to post a link to their modified version in this thread.

Are you still working on this? I'm trying to just theorycraft a build but I might try to understand the formula and make some improvements.

I wasn't logged into google on this browser so didn't get the Make a copy option and just downloaded the file. It ended up working fine in Excel, but I tried saving as .ODS and it breaks something with the formula. Just a warning for anyone who tries to use Open Office.

I think it would be a lot easier to use if there was dropdowns or something that already had each gem people use, at least common ones like WED or Conc. Effect, but that is a lot of work to do +increased damage for all skills.

I think I already have another spreadsheet with all skill gems for every level listed, but it only has the values for mana costs or multipliers I think. I might eventually add all sorts of values for damage and make a sort of comprehensive spreadsheet from a bunch of different ones, but it will be a lot of work.