Hi, I've got a challenge where I want Calc to do something for me. Here
I go:
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.
Suppose Column A contains id's, say 1..100
Col. B contains first time slot room numbers: =INT(RAND()*5+1)
C, D and E contain room numbers for time slot 2, 3 and 4
F contains time slot 5, for row 1: =15-SUM(B1:E1)
Does anyone have a suggestion for C1, D1 and E1?
--
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
