Re: [libreoffice-users] challenge...

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: users+unsubscribe@global.libreoffice.org
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