Kupanga vuto
Tiyerekeze kuti tifunika kupanga manambala osawerengeka osabwerezabwereza mumitundu yosiyanasiyana. Zitsanzo poyenda:
- kupanga ma code apadera azinthu kapena ogwiritsa ntchito
- kugawira anthu ntchito (iliyonse mwachisawawa kuchokera pamndandanda)
- kuloledwa kwa mawu muzofufuza (moni seo-shnikam)
- kusewera lotto etc.
Njira 1. Zosavuta
Poyamba, tiyeni tilingalire njira yosavuta: tifunika kupeza magawo 10 mwachisawawa kuyambira 1 mpaka 10. Pogwiritsa ntchito ntchito yomangidwa mu Excel. PAKATI PA Mlandu (M'mphepete) zapadera sizotsimikizika. Ngati mulowetsa mu cell cell ndikuyikopera m'maselo 10, kubwerezabwereza kumatha kuchitika:
Choncho, tidzapita njira ina.
Mabaibulo onse a Excel ali ndi ntchito SANKHA (RANG), yolinganizidwa kusanja kapena, mwa kuyankhula kwina, kudziwa malo apamwamba a nambala mu seti. Nambala yaikulu kwambiri pamndandandawu ili ndi renki=1, yachiwiri pamwamba ili ndi renki=2, ndi zina zotero.
Tiyeni tilowetse ntchitoyi mu cell A2 SLCHIS (RAND) popanda mikangano ndi kukopera chilinganizo pansi 10 maselo. Ntchitoyi itipangira manambala 10 osasinthika kuchokera pa 0 mpaka 1:
Mu ndime yotsatira tikuwonetsa ntchitoyo SANKHAkuti mudziwe malo omwe ali pamndandanda wa nambala iliyonse yolandilidwa mwachisawawa:
Timapeza mugawo B zomwe tinkafuna - nambala iliyonse yomwe mukufuna ya manambala osabwereza osabwereza kuyambira 1 mpaka 10.
Mwachidziwitso, vuto likhoza kuchitika pamene SLCHIS adzatipatsa manambala awiri ofanana mwachisawawa mu ndime A, masanjidwe awo adzafanana ndipo tidzabwereza kubwereza mugawo B. Komabe, kuthekera kwa zochitika ngati izi ndi kochepa kwambiri, chifukwa chakuti kulondola kwake ndi malo 15 a decimal.
Njira 2. Zovuta
Njirayi ndi yovuta kwambiri, koma imagwiritsa ntchito njira imodzi yokha. Tiyerekeze kuti tikufunika kupanga mndandanda wa nambala 9 zosabwerezabwereza mwachisawawa kuyambira 1 mpaka 50 papepala.
Lowetsani fomula ili mu cell A2, dinani kumapeto Ctrl + Shift + Lowani (kuti muyiyike ngati chilinganizo chotsatira!)
Njira 3. Macro
Ndipo, zowona, mutha kuthana ndi vutoli pogwiritsa ntchito mapulogalamu mu Visual Basic. Mu imodzi mwazolemba zakale zokhudzana ndi sampuli mwachisawawa, ndidatchulapo kale ntchito ya Lotto array macro, yomwe imapanga nambala yofunikira ya manambala osabwerezabwereza pakanthawi kochepa.
- Momwe mungawerengere kuchuluka kwazinthu zapadera mumitundu yosiyanasiyana
- Zosankha mwachisawawa kuchokera pamndandanda