Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

To explain my comment above I attach a reworked version of the supplied spreadsheet document.
ask85388SelectRandomlyUnderConditions_1.ods
This attachment may later get removed!

To explain my comment above I attach a reworked version of the supplied spreadsheet document.
ask85388SelectRandomlyUnderConditions_1.ods
This attachment may later get removed!

To explain my comment above I attach a reworked version of the supplied spreadsheet document.
ask85388SelectRandomlyUnderConditions_1.ods
This attachment may later get removed!removed!

(Editing with respect to the first comment below:)

"Is it possible to have the doc generate all possible outcomes?"
Of course. Its just a bit boring. The generator I made is ugly, rather inefficient and has about 25MiB on disk. If I understood your conditions correctly there are 83776 combinations meeting them based on the 5 x 10 scheme you gave. The collection of the results without any formulae has 999KiB here. Let's try if I can attach it.
ask85388ResultsValidCombinations_3.ods