Comprehensive DPR Calculator (v2.0!)

[XZlayeD]

Would it be possible to implement something to make it possible to do calculations on attack types as the one seen on the two bird sling as seen in MOT? "When you make a ranged attack with this sling and hit a target, you can cause the ammunition to ricochet toward a second target within 10 feet of the first, and then make a ranged attack against the second target."

Basically it's an attack contingent on a previous attack, but it also needs to do a seperate roll to see if it hits as well, so it can't be lumped in with a "sneak attack" style calculation.

[Scipo0419]

Those are just extra damage dice, enter 'em like any other damage dice.

Thank you both for your work with this calculator, but the problem I'm seeing with something Like Hex or Booming Blade, is they are flat 1d6 or xd8's with no bonus damage respectively, but with the calculator, if I wanted to add my 1d6 from Hex to each attack it would still add the +6 bonus damage to my 1d8+6 Weapon calculations, turning Hex from 1d6 to 1d6+6. Using Bonus Actions to apply the effect has a similar issue where you can't really get the full value out of your turn because there's no where for these on hit effects to be calculated on top of your usual bonus actions that may apply a bonus to damage.

The other issue I found may not actually be an issue and simply my misunderstanding of the calculations, but I noticed that your damage formulas for Crit Damage are taking the +X Flat Modifier into account and everything I've read up on Damage in DND is that the modifier is not multiplied. So where an actual crit with a 1d8+6 with Hex would be (2*(1d8+1d6))+6, the calculator is calculating it as "2*((1d8+6)+(1d6+6))"

Any clarifications on these observations would be greatly appreciated!

[LudicSavant]

Any clarifications on these observations would be greatly appreciated!

Thank you both for your work with this calculator, but the problem I'm seeing with something Like Hex or Booming Blade, is they are flat 1d6 or xd8's with no bonus damage respectively, but with the calculator, if I wanted to add my 1d6 from Hex to each attack it would still add the +6 bonus damage to my 1d8+6 Weapon calculations, turning Hex from 1d6 to 1d6+6. Using Bonus Actions to apply the effect has a similar issue where you can't really get the full value out of your turn because there's no where for these on hit effects to be calculated on top of your usual bonus actions that may apply a bonus to damage.

Hex and Booming Blade already work on the calculator. If you want to add Hex to your 1d8+6 weapon attack, you would simply enter it like so:



This will make each attack do 1d8+1d6+6 damage... which is exactly how much you would do with Hex.

For Booming Blade, you would enter the initial "on-hit" bonus damage the same way. If you want to represent the "on-movement" rider activating, you would add that as a flat damage bonus instead (so that it doesn't get multiplied by crits).

The other issue I found may not actually be an issue and simply my misunderstanding of the calculations, but I noticed that your damage formulas for Crit Damage are taking the +X Flat Modifier into account and everything I've read up on Damage in DND is that the modifier is not multiplied. So where an actual crit with a 1d8+6 with Hex would be (2*(1d8+1d6))+6, the calculator is calculating it as "2*((1d8+6)+(1d6+6))"

This indeed appears to be a misunderstanding. Check the formula again: The calculator does not multiply flat damage on crits. It is already doing 2*(1d8+1d6))+6, not 2*((1d8+6)+(1d6+6)).

[quindraco]

Would it be possible to implement something to make it possible to do calculations on attack types as the one seen on the two bird sling as seen in MOT? "When you make a ranged attack with this sling and hit a target, you can cause the ammunition to ricochet toward a second target within 10 feet of the first, and then make a ranged attack against the second target."

Basically it's an attack contingent on a previous attack, but it also needs to do a seperate roll to see if it hits as well, so it can't be lumped in with a "sneak attack" style calculation.

Yes, that's easy. Make a new... here, I'll show you on my copy (I grabbed Ludic's sheet a while back to fix some minor bugs in it, like Elemental Adept out to more decimal places than most people care about, which may well be fixed in the current version from Ludic; my copy also uses a different interpretation of Critical Hit ranges than JC's does, so my copy doesn't have crits auto-hit, they only double damage).

https://docs.google.com/spreadsheets...it?usp=sharing

Note: What I did here was make a new field for number of attacks you try to make, and then I calculate actual attacks based on accuracy, to make a second set of attacks. Since I was doing this quick and dirty, I didn't do a full set for all advantage states, so I slapped on a drop-down for picking your advantage state for the calculation. That means the cells for calculating how your DPR changes with advantage won't work and neither will the ones for showing -5/+10, as none of them know that those changes also change your total attacks made. I also didn't bother with Bonus Action attacks (i.e. I didn't add a way for Bonus Action attacks to ricochet). That said, the DPR cell for the advantage state you picked in the drop-down will be correct (No Advantage is the same as Normal).

I'm assuming the sling can only ricochet once. Infinite ricochets would be a different formula.

Note 2: You can copy what I did over to Ludic's version and it should work fine. Please grab it soon if you're going to, as I may revert the changes I made for you at any time.

[LudicSavant]

(I grabbed Ludic's sheet a while back to fix some minor bugs in, like it assuming Champions auto-hit on a 19, but I didn't muck with the basic structure up top).

That is actually intended, as Champions automatically hit on a 19.

As JC puts it: "If a feature says you scored a critical hit, you hit."

[quindraco]

That is actually intended, as Champions automatically hit on a 19.

As JC puts it: "If a feature says you scored a critical hit, you hit."

Yes, I edited my post to clarify that I apparently interpret things differently from how JC does.

[Gotama]

Hi,
I tumbled over your guys work and I have a problem with copying the sheets. Every time I try to copy the first and the second sheet, I get the message #NAME! and the error Unknown function: (insert any function name here, like maxDamage, minDamage etc.). For some reason it worked with the third sheet, but I can`t seem to get it to work with the other two.
I did let it load till the end and everything, so I don`t understand why the functions don`t get copied. Pls Help, would be greatly appreciated. Have a nice Day!

[Omegon90]

Hello,

first I want to say, thank you for the great work with this sheet. it does amazing things.


now I have a question. Bladesinger can use booming blade/GFB on one attack when taking the attack action. I dont think the sheet can calculate that correctly, since the damage is not applied on the first hit, like sneak attack but is tied to a specific attack, regardless of where it hits or not. I can work aroudn this with using the bonus action attack, but if you do have a bonus action attack on top of this, it gets difficult. is there another way I'm not seeing? thanks for the help.

[NOMster]

on the HP if you have a periapt of wound closure, just double the number under HP recovered from HD, right?

[Sirgoulas]

[B]The documentation can be found here:
-Ludic

Edit: Now updated to version 2.51, with additional features! New features are described in replies to the thread. Feel free to suggest anything you'd like to see in the future!

Please explain the following:

''A halfling has a racial feature, Lucky, which gives them the ability to reroll one d20 (veryspecifically one d20 - the rule is on PHB 173) if they roll a 1. Success with this feature amounts to either succeeding without it, or failing but also rolling a 1, and then succeeding on the additional roll. This feature interacts with advantage and disadvantage, so we get the following formulas, which you may think of as adding a small bonus to the normal probability:

Lnorm=P+(1/20)P

X:The result of a D20 dice
In case of saving throws P(X>=x)=P(hit)=P for a given x E Z .
Failing doesn't necessarily means bringing a 1 in cases such as saves.

ex X>=3 success -> X<3 faillure and x=1 -> x=1
so Lnorm=P+(1/20)P=18/20+(1/20)18/20=0.9+0.05*0.9=0.945

ex2 X>=1 success ->X<1 faillure and x=1 -> null
Lnorm should be P+0*P=P=1 which is the correct answer
But if based on the formula it gives P+(1/20)P=1+0.05*1=1.05

Please explain. Your choice of words is confusing.
Maybe you meant to say: Success with this feature amounts to either succeeding without it, or rolling a 1, and then succeeding on the additional roll??
That would get P+(1/20)P=1+0.05*1=1.05 but is wrong because:


The formula Lnorm=P+(1/20)P works for X>=2 in case of saves (where 1 doesn't automatically mean faillure).
I cannot post links since less than 10 posts but basically to roll a 6 all I need is either roll a 6 on first dice or roll a 1 and roll a 6 on re-roll.
But to roll a 1 all I need is roll a 1 on first dice and 1 on re-roll:

So to roll a 1 : 1/20 * 1/20
A 5: 1/20+1/20 * 1/20

P(X>=1)=19*1/20+20(1/20)^2=1 correct, while by using P+(1/20)P=1+0.05*1=1.05

[AureusFulgens]

Please explain the following:

(...)

Hi! Apologies for the delay, I've been busy with grad school.

The halfling luck calculations as given in the documentation are correct for attacks. To see this, note that a 1 is ALWAYS a miss. So, rolling a hit and rolling a 1 are mutually exclusive. This means that we can add the cases "you roll a hit" (probability P) and "you roll a 1, then reroll and roll a hit" (probability 1/20 * P). In line with this, P *cannot* be 1.0: there will always be at least one d20 result that causes a miss. So you will never get that 1.05 result.

This does not work for saves, and my solution was a little clunky: I just case-split on whether 1 is a success. If it is, then EVERYTHING is a success, so just return 1.0. Otherwise, use the formula as given, and it works for the reasons given above.

I'll see if I can clarify the wording in the documentation.

[tmsduck]

Is there a chance that the piercer feat will be added as one of the advanced options?

[Psyren]

Thanks so much for this calculator, it's been added to my sig. Excellent work, easy to use and very detailed.

I had a potentially dumb question - is there an easy way to use this to calculate DPR across an entire 1-20 build? My understanding is that the attack calculator looks at a specific level; My idea was to make 20 copies of the attack calculator tab (adjusting the inputs for each level of the build) and then plot the average DPR numbers for each of those levels - is there a better way? Basically I wanted to compare two level 20 builds side by side and see whether one is better than the other all the way through, whether one is better than the other in some tiers but worse in others, whether one is better with or without feats or magic items etc.

Is there a chance that the piercer feat will be added as one of the advanced options?

As a workaround you can do the +1 die on a crit manually (row 30). The reroll 1 die per turn I'm not sure about but the difference is likely to be negligible anyway.

[the-real-orson]

I apologize if this question has been posed before, I perused several pages but did not see it...

What would be the best approach to account for Reaction based attacks? In particular, I'm finding it difficult to analyze how a rogue optimized to get sneak attack on a reaction might stack up against some other martials (because my DM is telling me my BM is OP in comparison).

[LudicSavant]

I apologize if this question has been posed before, I perused several pages but did not see it...

What would be the best approach to account for Reaction based attacks? In particular, I'm finding it difficult to analyze how a rogue optimized to get sneak attack on a reaction might stack up against some other martials (because my DM is telling me my BM is OP in comparison).

To determine how much damage you would do if you get the Reaction, just add it like any other attack.

As for how likely it is you will get said reaction, that's a judgment call you'd have to make yourself.

[the-real-orson]

To determine how much damage you would do if you get the Reaction, just add it like any other attack.

As for how likely it is you will get said reaction, that's a judgment call you'd have to make yourself.

Thanks! This calculator is awesome!

Would be super helpful with certain builds to have a Reaction block that is similar to the BA block, but I can certainly make due.

[ShockeyMIG]

This is really great work!
Very usefull for so many things.

It seams that when making multiple characters, or make a lot of changes, the google server kicks you out from using the scripts. (From earlier posts, i might not be the only one )
Could this be avoided with a button or function for recalculating, so it does not update everytime you change a number, but when you ask it to after you made all your changes?
Also could it help with the calculation time, if there was a checkmark for power attack (Great Weapon Master and Sharpshooter) so it only calculated these if the character actually had them?

Again, great work, and this is only stuff i have run into, because im getting addicted to using your calculater!

[freakybeak]

Amazing tool, thanks so much for your work Ludic!

Does anyone have an idea how one could calculate the Gloomstalker 11 feature "Stalker's Flurry" which allows you to attack again if you miss?

[stoutstien]

Amazing tool, thanks so much for your work Ludic!

Does anyone have an idea how one could calculate the Gloomstalker 11 feature "Stalker's Flurry" which allows you to attack again if you miss?

It's pretty close to having elven accuracy unless you already have EA then you have a little bit of math to do mostly because of critical hits.

[talldrummerboy]

I know it is a little specific, but how easy would it be to add custom dice to the bonus to hit portion? for instance, the wild magic barbarian is a d3 (don't ask why).

[Psyren]

I know it is a little specific, but how easy would it be to add custom dice to the bonus to hit portion? for instance, the wild magic barbarian is a d3 (don't ask why).

I'm not LS obviously, but the average of 1d3 is +2 so you can just add that to your attack bonus and come pretty close.

[Haggoroth]

Good day! I'm AureusFulgens, the other developer on this project. A lot of the more esoteric formulas on this sheet sprang out of the twisted eldritch depths of my mathematician brain, so I'm also on call to answer questions or complaints or corrections about the calculator!

(And if anything is wrong, then we seriously want to know. Every time a math error is published, Carl Friedrich Gauss rolls over in his grave, ad we don't want to do that to him.)

I'm on GitP a little less frequently than Ludic, so my responses might be a little more delayed than his, but I do promise to respond.

Hope this is of help to you!
Cheers,
Aureus

(Seriously, just call me Aureus. "Mr. Fulgens" just feels so formal, y'know?)

I started using your calculator, started with a very simple setup of a 14 AC target with just 1 attack, 6 to hit, 2d6+6 damage with no other options and I was noticing the DPR was off. So I looked a bit deeper and it appears to be off where you're calculating crits. For something simple like this, a crit should just be double the damage of a normal hit. And the average crit damage should be double the normal hit damage. When I get down to B205 and B208 I see that the normal avg damage is 13 and the crit avg damage is 20. It should be 13 and 26 for this simple setup. Due to it calculating the crit avg damage too low, the follow on formula of DPR is also off. I'm not exactly sure how to fix the error because you're using some formulas I'm not familiar with, I just know that it's off.

Good luck, and great work otherwise.

[LudicSavant]

I started using your calculator, started with a very simple setup of a 14 AC target with just 1 attack, 6 to hit, 2d6+6 damage with no other options and I was noticing the DPR was off. So I looked a bit deeper and it appears to be off where you're calculating crits. For something simple like this, a crit should just be double the damage of a normal hit. And the average crit damage should be double the normal hit damage. When I get down to B205 and B208 I see that the normal avg damage is 13 and the crit avg damage is 20. It should be 13 and 26 for this simple setup. Due to it calculating the crit avg damage too low, the follow on formula of DPR is also off. I'm not exactly sure how to fix the error because you're using some formulas I'm not familiar with, I just know that it's off.

Good luck, and great work otherwise.

That's not an error; 13 and 20 is correct. Keep in mind that crits in 5th edition only double the dice, not the bonuses, so if you're rolling 2d6+6 (13 average), a crit would increase it to 4d6+6 (20 average).

[Psyren]

While you're here Ludic - would it be possible to program a beta version that lets us calculate the expected damage increases from Graze, Cleave, and Vex?

[LudicSavant]

While you're here Ludic - would it be possible to program a beta version that lets us calculate the expected damage increases from Graze, Cleave, and Vex?

Maybe -- I haven't kept up with the latest 1D&D updates, so I'd have to look at what those do (I've sort of been taking a 'just wait and see how 1D&D turns out in the end' approach).

[Psyren]

Maybe -- I haven't kept up with the latest 1D&D updates, so I'd have to look at what those do (I've sort of been taking a 'just wait and see how 1D&D turns out in the end' approach).

That's perfectly fair. Just in case you want to look into it though:

Graze = each attack does some amount of damage even on a miss
Vex = each hit means the next attack with that weapon turn has advantage
Cleave = one hit per turn triggers another attack against an adjacent target

[serpentax2001]

so something I noticed is that the GWF style option on the calculator applies to all dice rolled when it should only apply to the damage dice of the weapon, so the d12 of a greataxe or both the d6s of a greatsword, and nothing else. so making it only apply to the dice values on rows 11 and 35 would fix it, especially since stuff like the 2d6 fire from a flame tongue can be rerolled with GWF, but not anything like brutal critical, superiority dice, or smites, it may not make a huge difference, but it does muddy the figures, which isn't good when trying to get accurate results

aside from that this calculator has been great, amazing work.

[Danish_raven]

Hi Ludic. I just found your work through d4: D&D Deep Dive on YouTube. I am currently working on a website that is supposed to do much of the same work. Would you mind if i borrow your documentation?

[Orvar]

I love this, thank you! All I have is a niche nitpick, can you add a working Lucky (feat) checkbox? I want to be able to calculate my DPR while burning luck points on top of elven accuracy. It's the only bit I can find that brings it short of perfection, though. Definitely the most comprehensive DPR calculator on the internet, thank you.

[q999]

Is 2.51 still most recent version? (Also is savage attacker implemented?)