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