So I finally got around to making a spreadsheet for expected damage. It can be downloaded here. Leave a comment if you would like to see it in a different format.
The formula for expected damage with criticals is now give by this equation:
The formula for expected damage with criticals is now give by this equation:
E{damage}=Phit*Mdmg+Pcrit*Phit*(CritM-1)*Mcrit,dmg
Phit = Probability of Hit = (20-(AC-Attack))/20; 1/20
Mdmg = Mean Damage =(Max Damage + Min Damage)/2
Mdmg, crit = Mean damage that is multiplied by a crit
Pcrit = Probability of a crit = Crit Rolls / 20
Crit Rolls = the number of side on the d20 that result in a crit (so 17-20 would be a crit roll of 4)
CritM = crit multiplier
Some example numbers:
Expected Damage | ED no Crit | Prob of Crit | Prob of Hit | Target AC | Attack Bonus | Critical Rolls | Crit Multiplier | Min Damage | Max Damage |
3.675 | 3.5 | 0.05 | 0.5 | 20 | 10 | 1 | 2 | 2 | 12 |
3.85 | 3.5 | 0.1 | 0.5 | 20 | 10 | 2 | 2 | 2 | 12 |
4.025 | 3.5 | 0.15 | 0.5 | 20 | 10 | 3 | 2 | 2 | 12 |
4.2 | 3.5 | 0.2 | 0.5 | 20 | 10 | 4 | 2 | 2 | 12 |
3.85 | 3.5 | 0.05 | 0.5 | 20 | 10 | 1 | 3 | 2 | 12 |
4.2 | 3.5 | 0.1 | 0.5 | 20 | 10 | 2 | 3 | 2 | 12 |
4.55 | 3.5 | 0.15 | 0.5 | 20 | 10 | 3 | 3 | 2 | 12 |
4.9 | 3.5 | 0.2 | 0.5 | 20 | 10 | 4 | 3 | 2 | 12 |
4.025 | 3.5 | 0.05 | 0.5 | 20 | 10 | 1 | 4 | 2 | 12 |
4.55 | 3.5 | 0.1 | 0.5 | 20 | 10 | 2 | 4 | 2 | 12 |
5.075 | 3.5 | 0.15 | 0.5 | 20 | 10 | 3 | 4 | 2 | 12 |
5.6 | 3.5 | 0.2 | 0.5 | 20 | 10 | 4 | 4 | 2 | 12 |
Comments
Post a Comment