Really annoying spot from today. Doesn't seem like any option is good. Didn't matter in the end, would've lost regardless.
Also introducing yet another Triplechain spreadsheet! Rack odds calculator. I've had it for a long time, but never made it even close to user-friendly that it would make sense to make it public, until now that is. It still isn't that great, but should at least be usable. Added two more possible rack conditions too to make it a bit better. It is still limited to just one rack, and not everything can be calculated directly, complex situations have to be done in parts, or through some other method. But it should get the job done in not-so-complex situations. Haven't really tested it properly since making the changes, so there is >>0 chance that something doesn't work as supposed to. If anyone uses this, and finds a bug, please let me know.
DOWNLOAD LINK
Let's see how it is used. Using the two bonus numbers thing from yesterday as an example case.
So this is how it looks. The grey and yellow are the only cells that need to be modified, grey ones have a dropdown list and just two options. The overlap one doesn't matter if only the 1st condition is used. In this case the other two should obv be "NO". I've typed in "at least one 1" and "at least one 2" as 1st conditions. So the odds of getting a rack with at least one 1 and one 2 are 32.79 %.
Here I've added the 2nd condition of having "at least two 2s". With this I have to change the 2nd condition to be in use by choosing "YES", and since I want the odds for a scenario where the rack has at least one 1 and one 2 or at least two 2s, the overlap needs to be changed to "OR". Otherwise it would give the odds for a rack with at least two 2s and at least one 1.
Here I've added a 3rd condition of "at least two 1s" to get the odds of a rack having at least two bonus numbers. The conditions can't be different, both use the same "AND/OR".
Let's see the other option for overlap in use.
Here I've tried to get the odds for a rack with no 3s, no 4s, at least one 6 and at most two 6s. Unfortunately the calculator doesn't understand this, there can only be one option for a number used in each condition. So there is an "ERROR!" text to notify that something doesn't work. The errors don't cover all situations, so some responsibility is on the user. Ok, so how to get this done then?
By using the "AND" option for overlap and moving one of the options of 6s to the 2nd condition. And there we go.
As you can see, there can be multiple options chosen in the same condition, as long as they don't interfere with each other in a way that is impossible.