After some time of using our recipe calculator we added an option which tries to get even probabilities for selected effects. Using is almost the same as in original post, but there is additional checkbox to switch the logic:
My version uses solver addon; the one with the similar UI as yours is from Silly Bubbles, and its main pros that it can work directly in google sheets, sad that it's outdated.