I know attack roll modifiers contribute to the equation but how? For example, say you get a +1 to attack and damage. Which is more important: the attack bonus or the damage bonus?
| 1 person marked this as a favorite. |
Which is more important will depend on what you need to roll to hit.
If you hit on a 2+, a +1 to hit won’t add much to DPR ( nominal from crit confirmation).
If you need a 20 to hit and the +1 lowers it to 19, you ~double your DPR.
| 4 people marked this as a favorite. |
DPR depends on many more variables, the AC of your opponent being the most important, but also the critical threat range and critical multiplier of your weapon. The full formula is quite complicated, and it's better to do it in steps.
First you need to calculate the chance of hitting the opponent. With ATT being your bonus to the attack roll, and AC being the AC of your opponent, the general formula is
P1 = (21+ATT-AC)/20
but if the formula above gives you a result smaller than 0.05 or greater than 0.95, the correct value is P1=0.05 or P1=0.95 respectively (because of the rule that Nat 1 is always a miss and Nat 20 is always a hit).
Then you need to calculate the chance of a critical threat. This depends also on your Critical Threat Range, CTR (CTR=1 for weapons that crit only on Nat 20, CTR=2 for weapons that threat on 19-20, and so on). USually it is equal to
P2 = CTR/20
However, if this formula gives you a result bigger than P1, then the correct value is P2=P1 (even if you roll inside your critical threat range, if you don't hit it doesn't matter).
Then you need to calculate the average damage dealth on a hit. If you roll 1dX+Y for damage, the average damage is
D = (1+X)/2+Y
Using these, and the critical multiplier of your weapon, let's call it M, you can calculate the average damage per attack. There's a chance equal to P1-P2 to hit with ana attack that isn't a critical threat (and deal D damage on average); a chance equal to P2*(1-P1) to hit, score a critical threat, but don't confirm (also D damage on average); and a chance equal to P2*P1 to hit and confirm a critical threat (dealing D*M damage on average). Therefore the formula for average Damage Per Attack looks like:
DPA = (P1-P2)*D + P2*(1-P1)*D + P2*P1*D*M = P1*D*(1 + P2*(M-1))
Then you need to repeat this calculation for every attack you make during the round and add it together to get your average damage per round.
If your weapon has some special abilities, or if you're using some feats, these formulas may require some adjustments.
Let's assume the simplest case, with one attack per round and no special effects in play, and assuming that you're in the range of variables where P1<0.95 and the equation P2=CTR/20 will hold whether you modify your ATT or not. Since P2 and M will be constants, then if you want to compare the DPR change from +1 to ATT and +1 to D, you just need to check whether (P1+0.05)*D is bigger or lesser than P1*(D+1). Solving this inequality gives the result:
If P1/D < 0.05, then increasing bonus to the attack roll by 1 is more efficient; if P1/D > 0.05, then increasing damage by 1 is more efficient.
or equivalently
If D-ATT > 21-AC, then increasing bonus to the attack roll by 1 is more efficient; if D-ATT < 21-AC, then increasing damage by 1 is more efficient.
| 2 people marked this as a favorite. |
You might want to check out my DPR calculator!
I don't understand the question. If you have +1 to hit it doesn't increase your damage directly (but will probably increase your average damage per turn since you'll hit more). If you have +1 to damage it does directly increase your damage per turn but doesn't make it any easier to hit.
You might want to check out my DPR calculator!I can't get that to work, any ways of getting a non pdf/excel sheet version?
You need to be logged in to a Google account, then click file -> make a copy.
But yeah, I've got an Excel spreadsheet version, grab it here. Feedback is appreciated. It's actually better, as Excel has more options than Google Docs (at least the latter added checkboxes a few months back). I only made the Google Docs version because some people apparently don't like Excel.
| 1 person marked this as a favorite. |
The simplified formula:
The damage formula is h(d+s)+tchd.
h = Chance to hit, expressed as a percentage
d = Damage per hit. Average damage is assumed.
s = Precision damage per hit (or other damage that isn't multiplied on a crit). Average damage is again assumed.
t = Chance to roll a critical threat, expressed as a percentage.
c = Critical hit bonus damage. x2 = 1, x3 = 2, x4 = 3.
Add up the damage you did. Divide by the number of turns it took you to do it.
Predicted damage per turn is a different thing of course.
| 1 person marked this as a favorite. |
I know attack roll modifiers contribute to the equation but how? For example, say you get a +1 to attack and damage. Which is more important: the attack bonus or the damage bonus?
Usually, attack bonus, especially if you have iteratives that regularly factor (i.e., pounce build or archer). Neither are as important as attrition, or the disparity between what you can dish out versus what you take in return.
Microsoft doesn't sell them anymore they rent them for like 100-200 bucks a year per program
That's why I'm still using Office 2007!
Sorry for putting forth so much info at one time.
On the contrary, I'm grateful for feedback!
Of course, I can't possibly add every option in the game, or the spreadsheets gets utterly unwieldy. All calculations are in plain sight (apart from an unseed calculation at E19-E21 that handles cases where the first attack does something different from other attacks at full BAB, e.g. with Furious Focus), and almost all relevant cells are named, so everyone with a bit of understanding of Excel should be able to edit the formulae when needed. For instance, for Two-Handed Fighter's 2xStr to damage, you could replace the "0.5" in cell N16 with a "1" (or the whole "(1+IF(MHType=2;0,5))" part with a "2").1) spirited charge, lance
2) other character options that allow you to get more than 1.5x str on an attack.
3) Vital strike on a charge
4) Flurry of blows/unchained flurry of blows
5) could also use a few more slots for the natural attack area
6) multiple areas for 1.5x str to dmg for some of the natural attack boxes
7) Order of the sword special ability to add mount str to attack damage
1) That might be common enough to warrant a box. SHould I put it up top, or individually for each attack?
2) Hm, what options are there? Dragon Style is a nightmare due to the increased damage on the first attack (it is included in my unMonk DPR calculator, though), and there's a Fighter archetype no one uses...3) Removing that limitation is the easiest thing in the world, but considering how many people fail to understand Vital Strike, I'm a bit worried. Of course, Vital Strike damage could always be added by using the Elemental Damage or Precision Damage boxes, same as all damage that doesn't get multiplied on a crit.
4a) Unchained Flurry can be done with the "Additional attacks" box.
4b) cFlurry is more difficult, because it's dependent on the Monk level, but unless you want to get two-handed power attack bonus, you can simply use TWF.
5) How many characters with more than four different natural attacks are there?
6) The Excel version actually does have have dropdown menues for the natural attacks, allowing selection of primary, secondary, primary with 1.5xStr, and primary with 2xStr. I guess I could replicate that for the Gdocs version using the same system Weapon Type, Size Mod, and Target AC have.
7) Simply add the mount's strength mod in the "bonus to damage" boxes at either the top or the weapon.
Well, now I'm feeling stupid. I've just now found out how to do dropdown lists in Gdocs, and it's identical to the normal method to do them in Excel. It's just that I haven't used them in years (and not at all in the DPR calculator spreadsheet), because the other version is more elegant.
I'm reworking parts of the spreadsheet, but as it's 3AM here, I'll go to sleep and continue working on it tomorrow.
Still, I don't want the spreadsheet become too big. Not only for fitting on the screen, but the formulae can easily become too long to understand. There's no way I could even get close to including everything Pathfinder has to offer, so keeping the formulae at a relatively low complexity so that they can be edited is mandatory.
For instance, just because it's possibly to apply Vital Strike to off-hand attacks (Gorum's Swordmanship Divine Fighting Techniqu + TWF with two small greatswords), doesn't mean I'm going to add Vital Strike to off-hand damage calculations.
It would certainly be possible to add in every single thing you've mentioned, but then I'd have like twice as many selectable options at the top and formulae that even I wouldn't understand anymore (I actually had such formulae in the past, which is an utter nightmare for troubleshooting).
I'm experimenting with adding dropdown lists to the checkboxes, which allows grouping feat chaines like Vital Strike without taking up more space. As I've also realized that my Dragon Style calculation is unnecessary complicated, so I'll probably add a Dragon Style/Dragon Ferocity "dropdown box".
I'm also thinking about TWF-style Flurry. I'll probably just add an overwritable level field to the checkbox text (Flurry needs a level check, but I can't just use regular level in case of multiclassing).
I'll respond to the rest later.
Microsoft doesn't sell them anymore they rent them for like 100-200 bucks a year per programThat's why I'm still using Office 2007!
I wish I could get Microsoft Word 5.1b to work in Win10. Best word-processor ever. They've steadily removed or buried features under layers of other commands ever since. It used to be you could publish a book with that one program, as it would properly split footnotes across page boundaries and permit font sizes in sub-integer increments.
I've made some changes, you might want to check out the newest version.
3)Maybe add a side annotation or a tracheary box that has to be toggled that says "I HAVE A FEAT/CLASS FEAUTRE THAT ALLOWS VITAL STRIKE ON A CHARGE"?
5)Trust me I have lot's(bite, gore, 4 wings (2 at one die value and 2 at another), 2 claws, tail and I think 2 talons) plus it would be a nice boon for dms creating custom monsters as well to make sure they have enough dpr to be threatening but not I kill a pc every round till combat is over type of monster.
8)Some abilities modify power attack values as well, 2h fighter makes it 100% instead of 50% but mythic power attack mods it as well, mythic vital strike also is a huge mod to the vital strike line and while me and my groups personally don't use mythic I know there are plenty of groups out there that do especially those that are running adventure paths were mythic is expected.
I've added checkboxes for Flurry of Blows, Dragon Style/Ferocity, Lance (affecting just the first attack), and Spirited Charge (affecting all attacks).
3) Such a check would take up way to much space. I did remove the condition, though - if some folk don't understand Vital Strike, that's their problem.5) No offense, but I don't see enough reason to add additional space just for some super munchkin-y build. And if a GM needs to calculate the DPR of a monster with more than four natural attacks, they're doing something seriously wrong.
8) No mythic stuff - that would require dozens of additional things.
I've added checkboxes for Flurry of Blows, Dragon Style/Ferocity, Lance (affecting just the first attack), and Spirited Charge (affecting all attacks).
Is this true? I was under the assumption that it only affected the first attack, since this FAQ says 'first melee attack'.
I've actually looked if there was an FAQ or something for Spirited Charge, overlooking that the Lance FAQ does also say that Spirited Charge only affects the first attack as well. Thanks, fixed it!