Ranged Attack Hit Chance Optimizer
Posted: 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
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