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.
> 
> 
> 
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser