Re: [libreoffice-users] challenge...

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 <w@vanderworp.org> 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: 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

-- 


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