Ranged Attack Hit Chance Optimizer

Talk about any rules that don't directly fall under personal combat
Post Reply
myanbar
Initiate
Posts: 94
Joined: 17 Jan 2016, 17:16

Ranged Attack Hit Chance Optimizer

Post by myanbar » 18 Mar 2016, 20:27

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
Last edited by myanbar on 17 Sep 2016, 16:29, edited 2 times in total.
User avatar
thirtythr33
Editorial Inquisition
Posts: 1241
Joined: 12 Aug 2015, 03:23

Re: Ranged Attack Hit Chance Optimizer

Post by thirtythr33 » 18 Mar 2016, 22:20

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
myanbar
Initiate
Posts: 94
Joined: 17 Jan 2016, 17:16

Re: Ranged Attack Hit Chance Optimizer

Post by myanbar » 21 Mar 2016, 04:00

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.
Post Reply