HQ (and SQ) dice distributions and chances

[PJ_Maybe]

By Jove! Thanks Maurice, that seems to have done the trick! Much appreciated!

clmckay - thanks for the link! Coincidentally, I found your spreadsheet while hunting through the forums earlier this afternoon. It is also a very useful resource and I'm using both yours and Maurice's to crunch some numbers and look at how the coloured dice can change the game.

[Maurice76]

I've recently taken a look at the source code of my sheet to see what I needed to change to accomodate for rerolls. The main problem that I have is that a reroll is basically something that's evaluated after the roll is made. The reason for this is that:
a) One or more of the dice need to have an undesired result;
b) Based on which die or dice have the undesired result, a further subselection needs to be made based on preferred outcome to select which die or dice to reroll;

Especially the second one is tricky and simply implies that you need to evaluate all possible permutations to consider rerolls. My current code doesn't evaluate all permutations, it evaluates each die in sequence, totalling everything. My original code did consider all permutations, but from 7 or 8 dice onward, calculation times became quite prohibitive. At 10 dice, it ran for over an hour to get everything sorted - that's way too long.

I need to put some thought into optimizing this and maybe find a clever evaluation solution.