| 9 people marked this as a favorite. |
I've been wanting to put together a comprehensive DPR calculator for a while now. I finally sat down this week and banged one out in excel, so I thought I would share it with everyone!
The site is using excel web app.
It isn't much to look at but it is very comprehensive. I expanded the original DPR olympics formula to include many different sources of discrete damage. So now if you have the "killer" trait, or "hammer the gap" feat there are places to put that damage.
Spreadsheet has a dropdown to choose your CR and will auto-populate the target AC and HP for all CR's 1-30. It will also take your DPR and tell you how many rounds for you to kill that opponent!
You can also download the excel file from the page. Just a note if you download it: I left the cells unlocked and there are some touchy formulas in there, so just be careful.
Any questions feel free to PM me or reply.
Overall I think it is a very useful tool and I offer it to the community for free and with no advertising on my site!
Thanks!
~BigDTBone
| 1 person marked this as a favorite. |
Sure. It isn't smart enough to take dice codes. But I'll give a run down of what type of info to put in each field.
Attack bonus - Just the number, so +12 to hit would be entered as '12' (no quotes)
Weapon damage - You must do the average yourself. So if you want to enter 1d8+3d6 then you first need to avg the dice 3d6 = 3*(3.5) = 10.5, and 1d8 = 4.5, 4.5+10.5= 15. So you would enter '15' (no quotes) in that field.
Non-crit damage - Works just like weapon damage.
Cumulative damage - Like hammer the gap. Add +1 damage for each consecutive hit scored this turn. So you would enter '1' if you had this ability. You may leave it blank if you do not have an ability like that.
Threat range - The lowest dice value where you threaten a critical hit. So if you had a scimitar it would be '18'
Bonus to confirm crit - if you have critical focus and get a +4 to confirm critical hits, you would enter '4'
Critical Multiplier - If you are using a longbow, you would enter '3'
Crit bonus damage - For abilities like the "killer" trait. If you had the killer trait and were using a bow, you would enter '3'
Thats about it!
Note that you can leave most fields blank and they default to 0 and the calculator will still function. So there is no need to fill in fields for abilities you don't have.
| 2 people marked this as a favorite. |
Very Nice! Thanks Big DT! Now I can make GM's cry even more of those sweet nectar tear drops!
It won't load.
| 1 person marked this as a favorite. |
Dang it, I pushed an update for a formula error. I'll check it when I get back to a computer and repost.
It won't load.
ok, the page is updated and seems to be working now :) Thanks for the heads up.
Also, if anyone wants to download the excel file with the locked fields and form clear macro you can get it here
The download link on the excel web app strips the advanced features out of the file.
| 1 person marked this as a favorite. |
| 2 people marked this as a favorite. |
Bit of a necro but I've only just found this. This is very nice to use while at work theorycrafting.
How goes incorporating my spreadsheet dice formula I emailed you?
I am waiting to see how you incorporate it.
/cevah
Sorry, just saw this post. Business has been keeping me busy but I plan to start fiddling with it this week. I'll keep the progress updated here.
This is really neat and I find this easier to use than the spreadsheet DPR one from awhile back.
Sorry, just saw this post. Business has been keeping me busy but I plan to start fiddling with it this week. I'll keep the progress updated here.
Busy is good. Lets you make more money to spend on pastimes like PF.
/cevah
Sorry, just saw this post. Business has been keeping me busy but I plan to start fiddling with it this week. I'll keep the progress updated here.Busy is good. Lets you make more money to spend on pastimes like PF.
/cevah
Indeed. I actually gave my first run at it today and I am running into some issues. I was going to shoot you a PM soon with a few questions.
Update on this - I am currently hosting this on some server space I had paid for with an old business venture. The domain and hosting are expiring in a few days. I'll be moving this tool to a new site after the new year but don't have details yet. I would suggest that anyone who uses this tool regularly to download it from the link in the excel web app.
Cevah has generously provided excel formulas to figure dice code averages automatically which will be in the new tool next year.
Thanks! Feel free to PM me if you can't dowload the sheet or if you don't get there before the site goes dark and I will email you a copy.
| 5 people marked this as a favorite. |
UPDATE:
I have new hosting and the app is back up. The changes to the damage line to allow for dice codes are complete. That means you can now enter "2d8+9" instead of "18.' Thanks again to Cevah for the help with that!
| 1 person marked this as a favorite. |
I provided code to handle stuff like:
d8+3d4+2d6+4
IIRC, I think it will handle up to 10 items added together.
/cevah
How would you do stuff like jabbing style and jabbing master?
How would you do stuff like jabbing style and jabbing master?
jabbing style add "d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
jabbing master add "2d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
The cumulative damage line determines damage based on every previous attack hitting, not just the current attack.
How would you do stuff like jabbing style and jabbing master?jabbing style add "d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
jabbing master add "2d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
The cumulative damage line determines damage based on every previous attack hitting, not just the current attack.
hrm :-/ it looks like I have a slight error in the cumulative damage formulas. Those numbers will be off by a little until I track it down.
This wont effect anyone not using cumulative damage, and if you are it will yield a very marginal error. I'm gonna get it fixed none the less. :)
Thanks
How would you do stuff like jabbing style and jabbing master?jabbing style add "d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
jabbing master add "2d6" into each of the 2nd and 3rd attack "cumulative damage" lines.
The cumulative damage line determines damage based on every previous attack hitting, not just the current attack.
hrm :-/ it looks like I have a slight error in the cumulative damage formulas. Those numbers will be off by a little until I track it down.
This wont effect anyone not using cumulative damage, and if you are it will yield a very marginal error. I'm gonna get it fixed none the less. :)
Ok, so it's not an error. I wrote the formula to specifically mimic hammer the gap. Ie, the damage increases on each successive attack (1, then 2, then 3) and the sheet is expecting the user to put "1" in each of those fields.
With the jabbing line of feats brought to my attention I will change that formula to work as I decribed in the first quoted post. Ie, the damage in this line will be added based on the chance that every previous attack hits. This is imperfect for hammer the gap (but it always has been) because it doesn't account for missing the 2nd attack and landing the 3rd and 4th. Correcting this would literally require having a "hammer the gap" line in the calculator. But, the new formula will work perfectly for the jabbing line.
This line can still be used for hammer the gap, but instead of using a "1" in every field; now users will need to put "1", "2", "3" etc in the cumulative damage fields for each successive attack. This will return a slightly lower actual damage than is your true DPR but it is so marginal that it is trivial (less than .1 dpr) and won't even occur with attack series with less than 4 attacks.
I'll make this change in the morning and post an update here.
Dot
| 1 person marked this as a favorite. |
I just sat down and worked out my first DPR forumula today. By the time I was done, I realized the value of a spreadsheet.
What you have here is very user friendly, and works quickly. Thank you SO much for making it. :)
No problem!
No problem! [At least for the fancy multi-die eval I made for BigDTBone]
/cevah
| 1 person marked this as a favorite. |
Great work BigDTBone and Cevah, works really smooth. Thankx.
Would that still be available somewhere?
"PrintBlaze.com is for sale"
...bugger. And here I was needing one of those things right about now.