On 22-08-16 20:16, Brian Barker wrote:
At 16:37 22/08/2016 +0200, Wiebe van der Worp wrote:
There is a group of ~100 people (n). In 5 time slots they visit 5
rooms in groups of ~20 people (n/5). The composition of the groups
should be as different as possible for each time slot. One person may
not visit a room more than once.
Here's an idea:
...
This will ensure that each person visits each room exactly once, but the
groups sizes will vary from exactly n/5. You could use COUNTIF() to list
the sizes of the twenty-five groups and determine the range of sizes
using MIN() and MAX(). Then you could use Recalculate Hard
(Ctrl+Shift+F9) repeatedly to regenerate the random numbers until you
were happy with the group sizes.
Your solution is way more elegant than mine and I will put these control
measures at work, thanks. On the other hand, the deviation of number of
people per room is quite unexpected, forcing a lot of Ctrl-Shift-F9 strokes.
This problem may be of the sort that would be much easier to solve
through programming that via a spreadsheet.
As Dave Liesse confirmed, driving in nails with the flat side of an axe.
But it works for one time usage ;-)
Thanks to everyone for helping.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
