Hi Wiebe, I wouldn't use random numbers, but work with primes below 20. So, always starting with 1, and then increasing with the prime number until you reach 100.
You have the following prime numbers : 19,17,13,11,7 Time slot 1 : group A : 1, 20, 39, 58, 77, 96, (1)15, 34, 53, 72,... group B : starting with the lowest available number. group C : starting with the lowest available number. ... Time slot 2 : group A : 1, 18, 35, 52, 69, 86, (10)3, 20, 37, 54, 71, 88, (10)5, ... group B :starting with the lowest available number. group C : starting with the lowest available number. ... Time slot 3 : same, but with an increment of 13 Time slot 4 : same, but with an increment of 11 Time slot 5 : same, but with an increment of 7 It might be even more unique when you use even higher primes, but I guess this methodogy will be fair enough. It's up to you to write the formulas :) Good luck! Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com Watch our company movies on www.tvh.tv Business Innovation through Information Technology bi2t.tvh.com On 22 August 2016 at 16:37, Wiebe van der Worp <[email protected]> wrote: > 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 -- **** DISCLAIMER **** http://www.tvh.com/glob/en/email-disclaimer "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- 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
