I made a Google Spreadsheet that calculates the odds of various dice results. You can put in the number of attack/defense dice, Focus tokens, Target Locks, Evade tokens, and whether the attacker has the Gunner upgrade. The sheet will then give you detailed stats like Mean Damage, Hit%, Mean Critical Hits, and probability of each possible damage result.

Let me know if there are any additional stats you'd want to see or config options to change.

https://docs.google.com/spreadsheets/d/1YrPMS-cdTpd4ASeQrlh5sGDD_hjpF0SbNRh8VEwm9UA/edit?usp=sharing

This link is read-only, so to edit values make a copy into your own Drive folder.

Awesome! Nice work and thanks for sharing!

cool

Great job!

There are some apps and a website http://xwingdice.com/that do this, but the website is pretty dated and the pro version of the app costs $$.

If you get around to it it'd be awesome if you could add certain additional effects such as autothrusters or predator.

Awesome work.

Love it,

Thanks,

Updated with support for rerolling attack or defense dice due to card effects, and added Autothrusters on defense.

Is is possible to set it so you can spend focus tokens at the end, and not re-roll focus results? Currently it spends the focus token before the re-rolls happen right?

i.e. I roll hit-eye-blank with my 3 dice, re-roll the blank with predator or TL, get another eye, spend focus for 3 hits.

wunderbar!

Is is possible to set it so you can spend focus tokens at the end, and not re-roll focus results? Currently it spends the focus token before the re-rolls happen right?

i.e. I roll hit-eye-blank with my 3 dice, re-roll the blank with predator or TL, get another eye, spend focus for 3 hits.

Right. This should be an easy fix. I'll just change it to "Reroll focus?" and do the focus after the reroll. I'll change defense to do the same too.

I had a thought like this about a week ago, but in my thought there were graphs.

Yeah, now I got you thinking too...

this is awesome! but i think I found a bug

Attack Dice: 3

Attack Gunner: TRUE

All other Attack = 0

Defense Dice: 3

All other Defense = 0 or False

Mean Error and Mean Crit = #ERROR

Is is possible to set it so you can spend focus tokens at the end, and not re-roll focus results? Currently it spends the focus token before the re-rolls happen right?

i.e. I roll hit-eye-blank with my 3 dice, re-roll the blank with predator or TL, get another eye, spend focus for 3 hits.

Right. This should be an easy fix. I'll just change it to "Reroll focus?" and do the focus after the reroll. I'll change defense to do the same too.

This change is done. Defense still never rerolls focus results, but the Focus token is spent after any rerolls are done. If anyone can convince me there's a good reason to reroll Focus results on defense with the token I'll add it in, but I'm not seeing why you would other than to possibly keep the token around for future use (in which case that token isn't really "available" for the purposes if this spreadsheet).

this is awesome! but i think I found a bug

Attack Dice: 3

Attack Gunner: TRUE

All other Attack = 0

Defense Dice: 3

All other Defense = 0 or False

Mean Error and Mean Crit = #ERROR

Fixed, but expect it to take a while. It may even time out. I'm working on an idea for some performance improvements here, but it won't be simple.

Some performance improvements were done. Rolls are cached so that step can be done faster. The "Execute combat" phase (where e.g. tokens are spent) is still uncached, and Gunner can cause the number of possibilities to explode. Future versions will work to speed that up.

A deep and heartfelt thank you from all of us poor slobs that can't math!!!

Is is possible to set it so you can spend focus tokens at the end, and not re-roll focus results? Currently it spends the focus token before the re-rolls happen right?

i.e. I roll hit-eye-blank with my 3 dice, re-roll the blank with predator or TL, get another eye, spend focus for 3 hits.

Right. This should be an easy fix. I'll just change it to "Reroll focus?" and do the focus after the reroll. I'll change defense to do the same too.

This change is done. Defense still never rerolls focus results, but the Focus token is spent after any rerolls are done. If anyone can convince me there's a good reason to reroll Focus results on defense with the token I'll add it in, but I'm not seeing why you would other than to possibly keep the token around for future use (in which case that token isn't really "available" for the purposes if this spreadsheet).

Awesome! Appreciate the effort!

One thing I've been interested in is how much better a TL+Focus is then Predator/Lonewolf+Focus, so this gives me the numbers perfectly.

I just dramatically improved the performance of Gunner so it can handle 6 v 6 with Gunner no problem. So now if you want to sim "Whisper" with Gunner and Opportunist making a range 1 shot through an asteroid at a cloaked "Echo" with Stealth Device, you see your 80.87% hit chance in a few seconds. (If "Whisper" also has a Target Lock, though, it may still time out. I'm working on that.)

Accuracy Corrector added, as well as a display of standard deviation