Tema: Re: Q: MS Excel
Autorius: Kiaule voras
Data: 2010-01-27 10:14:45
Tinka, super, aciu apbiems ;)



"gintasma" <gintasma@freemail.lt> wrote in message 
news:hjoobr$rpg$1@trimpas.omnitel.net...
>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.
>>>
>>>
>>>
>
>
>