DPR Calculator:
All-day project, this little bugger was. Hopefully enough people will get enough use out of it to be worth those sixteen hours! :D
With meabolex's help, I think the surface layer of bugs have been quashed. Further bug reports and feature requests may or may not be ignored due to spreadsheet rage, but you might as well mention them anyway. ;)
MAKE A COPY! This sheet is locked. Once you have your own copy, blue fields are for entry and red fields give you results. A few fields have little marks in the corner, those have hover text just in case their purpose isn't 100% clear.
Known limitations because I'm damn tired of staring at formulae:
Thanks! That'll help with deciding what feat works best when questions as I level up my monk.
Awesome tool. It makes archery so tempting to see these kind of numbers.
One bug I've found - Weapon focus level 3 doesn't seem to be calculating properly. Thus, most of the characters in the "DPR Olympics" thread are not reproducible unless you put Weapon Focus level 2 and just add a straight +1 to misc attack.
One bug I've found - Weapon focus level 3 doesn't seem to be calculating properly. Thus, most of the characters in the "DPR Olympics" thread are not reproducible unless you put Weapon Focus level 2 and just add a straight +1 to misc attack.
I'm not seeing that problem. Can you give me a specific situation where this happens?
However, the sheet is updated - there was a bug in +1-to-hit full-round DPR calculation, and nasty stupid bugs in full-round calculation for both primary natural attacks (doubled) and secondary natural attacks (not counted at all, d'oh). Anyone using this should snag a fresh copy!
I'm not seeing that problem. Can you give me a specific situation where this happens?
Just pulled a fresh copy.
Falchion Fred:
Power Attack 1, Critical Focus 1, Target AC 24, BAB 10, Str +6, Dex +2, Dice Average 5, Crit Threat 15, Crit Mult 2, Misc +attack 5, Misc +dmg 5.
(the misc +5's are +2 for fighter weapon training and +3 falchion)
Then either:
1) put a 3 in Focus Level and get DPR 55.30.
2) put a 2 in Focus Level and change Misc +attack to 6 and get DPR 59.25 which is exactly what MIB got.
Perhaps I misunderstood how this is supposed to work?
--zerothbase
Ahh... I see what happened. I was looking for an error in the hit calculation from focus, but it was in the damage from specialization. Check now, should be good?
angryscrub: I just discovered that myself, yes. Also fixed it. :)
fray: "Damage Per Round."
D'oh. Yeah, Vital Strike was all jacked up. Also fixed. Hooray for beta testers! ;)
What is DPR?
Similar to "DPS", which is a video game term.
More broken things I've found and not yet fixed:
Make me a list and I'll double-check, showing my arithmetic.
Falchion Fred checks out 100%. The other two I looked at were Tempest Ted and Farshot Fallon, both of whom were slightly off; your calculations were higher than mine in both cases. Spend the evening working on a different project so I don't remember precisely what the numbers were, but those would be the two to start with. Thanks!
Version 2.0 is up. Total rebuild, some changes to organization. Rather than select an overall attack routine, you select your primary weapon type (1H, 2H, ranged, natural) and then toggle off-hand and secondary-natural independently, which applies an appropriate penalty to the main hand; in addition to some organizational benefits, this allows two-weapon fighting with a two-handed weapon and armor spikes. There are fields on each weapon for enhancement bonus, weapon training, and miscellaneous +attack and +damage, in addition to the global +attack and +damage and a new global +dice so you don't have to add sneak attack to each weapon individually.
Flurry is now listed under feats, and will perform a two-weapon routine using only your main hand, adding extra attacks as appropriate with the assumption that BAB = monk level. Note that this will work with the main hand set to a two-handed weapon, in case your interpretation allows using a quarterstaff that way.
Calculations are broken up into more cells, so this version will be far easier to maintain when bugs show up or features are requested. As a side effect, various bits of extra data are available, such as your precise Manyshot damage, the actual to-hit bonuses (rather than fractional chances) for each iterative attack, and individual totals for primary, off-hand and secondary natural weapons.
2.03 - a few minor tweaks, mostly involving that dastardly Two-Weapon Rend.
Pending official clarification, everyone should know that this tool does not apply a Power Attack bonus to Rend damage.
There are arguments on both sides and my reading comes down to "no," but it's a very close call and the intention could easily be "yes." If you'd like to edit your copy to apply power attack, edit cell H21 and replace the formula with this:
=if(and(G1<2,E2>9),5.5+if(E3>0,floor(E3*1.5,1),0)+if(B7,J4*3,0),0)