|
| 2 people marked this as a favorite. |
https://drive.google.com/file/d/0B1ZzyIXywWzNNmJ4LVN3c1hTSTg/view?usp=shari ng
Not really sure the best way to make this available. If this doesn’t work or there are better ways please let me know. Anyhow, I offer this to the community hoping it may be of some use. I know there are a lot of dpa calculaters out there, but every one I have seen, even the most complex, require numerous iterations calculated one at a time. These can’t be directly compared to each other. This calculator allowes you to compare almost any number of complex examples side by side.
This dpa calculator is based on the formula h(d+s)+tchd, where
h=chance to hit, expressed as a decimal percentage,
d=average damage per hit,
s=average precision damage per hit (or other damage that is not multiplied on a crit),
t=chance to roll a critical threat, expressed as a decimal percentage, and
c=critical hit bonus dice, e.g. x2=1, x3=2, etc.
However this formula assumes chance to hit is already calculated based on the attackers BAB and the defenders AC. Meaningful results require numerous iterations. This calculator gives results for any BAB over the full range of defender’s AC from AC 10 to AC 40.
In order to do this the input variable are modified from the variables in the dpa formula as follows,
ab= attack bonus (the number the attacker adds to his to hit d20 roll),
d=average damage per hit, as defined above,
s=average precision damage per hit, as defined above,
threat=the lower limit of the threat range, e.g. 17-20=17,
multiplier=the critical multiplier, e.g. x3=3.
Each column on the spreadsheet calculates the dpa of any particular attack over a range of defender’s AC. You can compare different attack options side by side over the full range of to hit probabilities. By adding the results across rows, you can calculate the total dpa for a full attack action.
The example provided compares the Hound Arhon’s two full-attack options.
Yellow-These are the only numerical cells that should be adjusted.
Blue-These cells should not be modified in anyway, other than duplicating columns if needed.
Orange-These cells should not be modified. This compares the two different full-attack options.
Columns can be copied and duplicated as needed to cover almost any imaginable example.
The second sheets shows the following examples;
This example shows the difference between several different weapon types. It assumes the attack bonus is the same regardless of which weapon is used, and that damage bonus is +4 (i.e. Str 18) for one-handed weapons and +6 for weapons used in two hands.
This example compares one-weapon fighting with two-weapon fighting. It compares a rogue fighting with a rapier to a rogue fighting with two shortswords and Two-weapon Fighting. In either case they have the appropriate Weapon Focus feat. These stats do not include sneak attack!!! As these are per attack numbers, the two shortsword columns must be summed and compared to the rapier column in order to obtain meaningful results.
This example compares the different threat range/crit multipliers while holding chance to hit and damage equal. Please note while these numbers are accurate the comparison is unrealistic because weapons with different threat range/crit multipliers do not do the same amount of base damage.
This example compares the different weapons with different threat range/crit multipliers while holding chance to hit and static damage equal.