Tema: Re: Q: MS Excel
Autorius: poviliuxs
Data: 2010-01-26 19:16:38
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.
> 
> 
>