Hello. I've made an Excel sheet that will tell you the dice you need to allocate to the Placement roll and to the Complexity roll that will give you the greatest chance to hit the target for a given Complexity Ob.
As of March 21st it will also tell you your expected damage on a hit, given your STR, weapon DR, their STA, Armor Value, and Placement roll MoS.
Input your values into the peach-colored cells, C2 to C8.
I used Excel 2010 to create this. I can't guarantee it works in any program besides that one.
Current version:
http://www.mediafire.com/download/cs4e4 ... v2.0p.xlsx
Old versions:
Minor update, fixed a word typo:
http://www.mediafire.com/download/woopd ... acros.xlsx
Ranged Attack Hit Chance Optimizer
-
myanbar
- Initiate
- Posts: 94
- Joined: 17 Jan 2016, 17:16
Ranged Attack Hit Chance Optimizer
Last edited by myanbar on 17 Sep 2016, 16:29, edited 2 times in total.
-
thirtythr33
- Editorial Inquisition
- Posts: 1266
- Joined: 12 Aug 2015, 03:23
Re: Ranged Attack Hit Chance Optimizer
Cool stuff. I've been thinking of how to properly incorporate exploding dice and I think I have some ideas. I'll let you know how it turns out.
"O happy dagger!
This is thy sheath; there rust, and let me die."
- Juliet Capulet
This is thy sheath; there rust, and let me die."
- Juliet Capulet
-
myanbar
- Initiate
- Posts: 94
- Joined: 17 Jan 2016, 17:16
Re: Ranged Attack Hit Chance Optimizer
I've added in the ability to measure your Expected Damage on Hit. It's very easy to compare how your expected damage rises and falls with your hit chances. I've updated the OP to have the new version.
As before, input your values into the peach-colored cells, C2 to C8. Let me know if there are any problems and I'll get to fixing them.
As before, input your values into the peach-colored cells, C2 to C8. Let me know if there are any problems and I'll get to fixing them.