o taip netinka?



"poviliuxs" <poviliuxxs@gmail.com> wrote in message 
news:hjn81m$jrh$1@trimpas.omnitel.net...
> nZn tokios
> bet brute force, jei jau reikia
>
> --- formules ---
> =SUM(C2:C23)+1
>                 10000
> =RANDBETWEEN(0;D2-1) =D2-C3
> =RANDBETWEEN(0;D3-1) =D3-C4
> =RANDBETWEEN(0;D4-1) =D4-C5
> =RANDBETWEEN(0;D5-1) =D5-C6
> =RANDBETWEEN(0;D6-1) =D6-C7
> =RANDBETWEEN(0;D7-1) =D7-C8
> =RANDBETWEEN(0;D8-1) =D8-C9
> =RANDBETWEEN(0;D9-1) =D9-C10
> =RANDBETWEEN(0;D10-1) =D10-C11
> =RANDBETWEEN(0;D11-1) =D11-C12
> =RANDBETWEEN(0;D12-1) =D12-C13
> =RANDBETWEEN(0;D13-1) =D13-C14
> =RANDBETWEEN(0;D14-1) =D14-C15
> =RANDBETWEEN(0;D15-1) =D15-C16
> =RANDBETWEEN(0;D16-1) =D16-C17
> =RANDBETWEEN(0;D17-1) =D17-C18
> =RANDBETWEEN(0;D18-1) =D18-C19
> =RANDBETWEEN(0;D19-1) =D19-C20
> =RANDBETWEEN(0;D20-1) =D20-C21
> =RANDBETWEEN(0;D21-1) =D21-C22
> =RANDBETWEEN(0;D22-1) =D22-C23
>
> -- rezultatas (kadangi yra random, tokio niekada negausi) :) --------
>
> 10000
> 10000
> 5864 4136
> 851 3285
> 551 2734
> 1465 1269
> 271 998
> 510 488
> 225 263
> 174 89
> 64 25
> 14 11
> 1 10
> 5 5
> 4 1
> 0 1
> 0 1
> 0 1
> 0 1
> 0 1
> 0 1
> 0 1
> 0 1
>
>
> On 2010.01.26 14:50, Kiaule voras wrote:
>> Sveiki,
>> ar yra tokia komandine eilute, kuria uzrasius, is bendros sumos
>> aukstesniuose langeliuose sugeneruoje atsitiktinius skaicius, kad juos
>> sudejus gautusi suma kuri parasyta?
>> Tarkim uzrasau 100 i narveli. Auksciau yra duota tarkim 6 narveliai.
>> Parasius 100 i galutini narveli, programa bet kaip padalina ta 100 ir
>> paskirsto i auksciau esancius narvelius. Jei yra taip kaip ta komandine
>> eilute turetu atrodyti?
>>
>> Is anksto dekoju.
>>
>>
>>