| 1 person marked this as a favorite. |
link! Just make a copy of it for your own use, because I don't want internet people breaking this copy in case other internet people who come after end up needing it.
Basically, I wanted to figure out what kind of DPR I was doing as a magus, but I ended up being unable to figure out where to put my spellstrike damage. The difficulty is that the dpr is heavily affected if I put the spellstrike damage on one attack, because missing that attack would have the calculator return that the spell does no damage, when in reality the spell can end up doing damage if the next attack hits.
So basically, you can calculate all your iteratives separately, then the sheet will calculate the chance of at least one attack hitting, and then multiply that percentage against your spell damage for how much extra DPR your spell does.
key:
-to hit is your bonus to attack.
-Target AC is what you're trying to hit. For the purpose of this sheet, you probably want to compare this number against the average AC of an appropriately CR'd enemy.
-"Damage" is the average amount of damage your hit will deal on a hit, that can be multiplied by a crit. So if you deal 1d6+8 damage on a hit, the average damage is 11.5.
-"Precision" is the average amount of damage your hit will deal that cannot be multiplied on a crit. Sneak attack, "flaming" property, etc all fall under this. (as a note, this sheet doesn't calculate "flaming burst" and similar enchantments properly. I'll probably figure out how to fix that tomorrow)
-"Crit multiplier" is pretty self explanatory.
-"crit range" is the minimum number that you threaten a critical on. So if your attack threatens a critical on an 18 or higher, put "18" into the box.
Green cells are freely editable
Red cells contain formulas and will break the sheet if you mess with them
Leaving a "blank" in the "to-hit" box will turn off that row for total dpr calculation.
And that's about everything. Anyone see any mistakes?
It looks correct to me.