Edit: The latest version, for version 1.2 of the game, is here:
Here is a new version of the damage spreadsheet, updated for the beta branch (v1.0.5):
Notes re the 1.2 changes:
- There are a lot of changes, but the majority of them are buffs to headshot damage against armor, damage against large (a.k.a. “monsters”), and increased stagger for pushes.
- The (non-elven) 2-handed sword has been overall buffed as per the patch notes, but it did lose the LINESMAN cleave modifier from its heavy attacks. Edit: LINESMAN was replaced by HEAVY_LINESMAN (as per CommissarTyr’s comment below) which isn’t included in the spreadsheet yet.
- The charged attack on the drakefire pistols no longer has damage dropoff with range (possibly a bug).
- The fireball staff’s charged attack got a buff to headshot damage against berserk rather than armored (again, possibly a bug).
Notes from previous versions:
- You will probably want to make a copy of the spreadsheet (File -> Make a copy …) so you can modify the settings in the top row (Hero Power Level, Difficulty, Values).
- Hero power below 120 is not supported because the damage doesn’t scale linearly below that which makes things too difficult for me.
- The stagger values are just a relative indication of stagger power. They may let you compare weapons but they don’t let you work out, for example, if a given attack will interrupt an enemy during a particular one of its attacks. Unfortunately that’s a complicated calculation that in some cases is situational, so I doubt it can be put in a spreadsheet (I don’t intend to attempt it, that’s for sure).
- The “# Targets” calculation doesn’t currently take into account mass modifiers like LINESMAN, which reduce the mass of applicable enemies by some percentage.
- I’ve added a ‘power multiplier’ field you can change to simulate buffs, e.g. for a ‘+7% Power’ buff use a multiplier of 1.07.
- The power level caps for difficulties are included in the calculation.