Page 1 of 1

Ranged Attack Hit Chance Optimizer

Posted: 18 Mar 2016, 20:27
by myanbar
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

Re: Ranged Attack Hit Chance Optimizer

Posted: 18 Mar 2016, 22:20
by thirtythr33
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.

Re: Ranged Attack Hit Chance Optimizer

Posted: 21 Mar 2016, 04:00
by myanbar
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.