Hey Guys
I have been looking at the maths behind rapid shot and am looking at setting up a spreadsheet to calculate the damage difference between rapid shot and non rapid shot attack routines.
If this is something you might be interested in seeing please let me know so I know to publish it
There are already spreadsheets for this, but if you want to make another DPR calculator feel free. That just gives us(the community) more options. <thumbs up>
| 1 person marked this as a favorite. |
I had a google for Rapidshot DMG calculators and didnt get any hits.
Looky here for what I have done so far
The people on this forum have made DPR calculators.
They do more than just rapid shot though.
| 1 person marked this as a favorite. |
Will have a look. Thanks. Will very possibly look at expanding mine to support things like haste and such
Just to make clear I wasnt intending to make a conclussive calculator, more a way of determining the viability of rapidshot against different ACs n such. It shouldnt be too difficult to expand it to cover other ideas like haste and dead shot and other aspects of dpr calcs. I could possibly include mellee damage calcs as well.
Would just need to include drop downs with what you actually want to include or not
Just to make clear I wasnt intending to make a conclussive calculator, more a way of determining the viability of rapidshot against different ACs n such. It shouldnt be too difficult to expand it to cover other ideas like haste and dead shot and other aspects of dpr calcs. I could possibly include mellee damage calcs as well.
Would just need to include drop downs with what you actually want to include or not
I wasn't sure which way you were going, or if you would be satisfied with what was already made so I figured I might save you some time. :)
I actually really like digging into the maths of pathfinder. Even if someone has done it I might be tempted to do it anyway.
I am actually currently writing a web applet to automate the kingdom building rules and taking care of the paperwork
Do you know if anyone has automated kingdom building yet?
I actually really like digging into the maths of pathfinder. Even if someone has done it I might be tempted to do it anyway.
I am actually currently writing a web applet to automate the kingdom building rules and taking care of the paperwork
Do you know if anyone has automated kingdom building yet?
There is an excel sheet for it.
I don't know which one is the best. Some may even be duplicates of the others.
Those all seem to be downloads. I am looking at online with cloud support and such. Also html based so easy to use on phones and tablets. Also with the actual map to place buildings and such
As a general rule, Rapid Shot is almost always worth it. The -2 to attacks for an extra attack (which will deal 1d8+str+extra) is usually worth the penalty. In general -1 to attack is balanced by 2 extra points of damage, but you must consider how much total damage is added vs the -2 to each attack.
If you download the excel sheet you can see I have done all the maths and have determined the same.
You can fiddle with my sheet, you could manually insert your attack routine and give it test CR's
Would seem so
Why excluding criticals?
Those all seem to be downloads. I am looking at online with cloud support and such. Also html based so easy to use on phones and tablets. Also with the actual map to place buildings and such
I don't think there is a website or anything like that.
Why excluding criticals?
Because maths is hard, and I couldnt figure out where to put it, but I do know where to put crits now.
To include crits you need to include the crit calculation into the average damage of first and subsequent shots on the top right of the sheet.
There is a lot of possibilities on attack damage so I am leaving that calc up to user at the moment.
@Woodoodoo
After fiddling with the values on my sheet for a while, rapidshot depreciates with number of attacks and higher AC as the effective penalty increases. Instead of only being -2 on 3 attacks its now -2 on like 5 or 6. That makes it a bit weaker.
Also my sheet was only capable of doing 5 attacks per turn, which you should not have had more than without haste. With haste and RS you should have had 6 attacks, which unless you adjusted the calc sheets only the first 5 would have been computed.
My sheet now includes a haste drop down and capacity to support 6 attacks
I just thought I would post my results here for fun if you don't mind.
Mutagenic warrior sling fighter
Stats: 20 point buy STR: 14 DEX: 18 CON: 12 INT: 12 WIS: 10 CHA: 9
lvl1 Point blank, precise
lvl2 weapon focus
lvl3 slipslinger style
lvl4 two weapon fighting(startoss 1)
lvl5 Advanced weapon training(Trained Throw)
lvl6 improoved two weapon fighting(startoss 2)
lvl7 deadly aim
lvl8 Rapid shot
lvl9 Clustered shots(startoss 3)AWT: focused weaponMagic items +1 Double sling(or sling), Gloves of dueling, +2 dex belt
Hit bonuses: 9 bab, 6 dex, 4 Weapon training, 2mutagen, 1pointblank, 1small, 1WF, 1Magicw = 25
Any reduction via TWF/rapid/deadly is accounted for in calculationsDamage bonuses: 2str, 8 weapon training, 6 deadly aim, 1 point blank, 1 magic, 1 slipslinger = 19
Any reduction via TWF is accounted forDPS
Sling only rapid(startoss style) lvl 9 CR 9: 75,89dpr.
lvl 9 CR 11: 66,60dpr
Double Sling only TWF lvl 9 CR 9: 74,18dpr
lvl 9 CR 11: 65,47dpr
Double Sling TWF w Rapid lvl 9 CR 9: 84,37dpr
lvl 9 CR 11: 73,08dpr+Haste
Sling only rapid(startoss style) lvl 9 CR 9: 109,96dpr
lvl 9 CR 11:97,57dpr
Double Sling only TWF lvl 9 CR 9: 102,40dpr
lvl 9 CR 11: 91,27dpr
Double Sling TWF w Rapid lvl 9 CR 9: 111,35dpr
lvl 9 CR 11: 97,65dprI know it's perhaps wierd to take a snapshot at lvl 9 but whatever.
I was surprised how small the difference was with a normal sling build with rapid/startoss and the full TWF rapid build, especially hasted. It gets even closer(slightly better with haste) once he starts meeting CR12/13 enemies.
Are you European? Why do you guys use the comma ',' instead of the period '.' to represent the decimal place. It messes me up real bad every time I see it, because Americans use the comma to group digits (as in 1,000).
I am Claxon I believe it is the other way around over here comma for decimals period to group digits.
Yeah, really messes me up every time I see it. Haha!
Here's a link to my Damage Calculator spreadsheet.
It has a tab for ranged and melee and can account for concealment, mirror image, precision damage, DR, etc. It also has a "basic" tab that lets you just quickly enter attack and damage modifiers if you already have them calculated out.
Instructions are in cell comments and in the accompanying Word document. (The Word document also breaks out the calculations.)