[libreoffice-users] challenge...

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: 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