Dala ijeneretha yephasiwedi engahleliwe ku-Excel ngamafomula

Ukudala amaphasiwedi aqinile ngokuqondile ku-Excel kulula kunalokho okubonakala.Ngemisebenzi embalwa kanye nobuhlakani obuncane, ungenza amaphasiwedi angahleliwe ahlanganisa izinhlamvu, izinombolo, nezimpawu ngaphandle kokufaka enye into. Uma futhi udinga amafomethi athile, njengezinhlamvu ezimbili, amadijithi amane, nezinye izinhlamvu ezimbili, ungakwazi futhi ukwenza lokhu ngokuzenzakalelayo ngamafomula.

Kulo mhlahlandlela uzothola inhlanganisela ephelele zezindlela: kusukela ekusebenziseni okulinganayo kwe-Excel yeSpanishi nesiNgisi (i-CHAR ne-RANDBETWEEN), isibonelo esisebenzayo sezinhlamvu ezi-2 + izinombolo ezi-4 + izinhlamvu ezingu-2, ukudala amaphasiwedi anezimpawu, enye indlela esheshayo yamaphasiwedi ezinombolo kuphela, nokuthi ungayenza kanjani ngethuluzi le-Kutools '"Faka Okungahleliwe" Ithuluzi. Siphinde sibuyekeze ukuthi kungani kuwumqondo omuhle ukusebenzisa amagama ayimfihlo aqinile nokuthi ungagwema kanjani amaphutha ajwayelekile.

Imiqondo eyinhloko: Amakhodi we-ASCII nemisebenzi ozoyisebenzisa

Ukuze sikhiqize izinhlamvu ngezinombolo ku-Excel sincike kuthebula le-ASCII. Uhlamvu ngalunye lunenombolo ehlobene phakathi kuka-1 no-255; isibonelo, u-48 kuya ku-57 izinombolo 0 kuya ku-9, 65 kuya ku-90 izinhlamvu ezinkulu A–Z, kanti u-97 kuya ku-122 yizinhlamvu ezincane u-a–z. Lokhu kuvumela "buza" izinhlamvu noma izinombolo ezingahleliwe ezibonisa ububanzi bezinombolo.

Umsebenzi we-CHAR (noma i-CHAR ku-Excel) ubuyisela uphawu lwekhodi oyidlulisela kuyo.. Uma ufuna ukubona ukuxhumana okuphelele, yakha ikholomu enezinombolo ezisuka ku-1 kuye ku-255 (isibonelo, ku-N1 kuya phansi) bese ubhala ku-M1. =CARACTER(N1); donsela phansi futhi uzoba netafula ekubukeni. Njengelukuluku, ku Windows Ungathayipha uhlamvu nge-Alt + ikhodi yezinombolo.

Ukuthola izinombolo ezingahleliwe ngesikhathi esithile sisebenzisa i-RANDBETWEEN. Isibonelo =ALEATORIO.ENTRE(1;100) ibuyisela inombolo ephakathi kuka-1 no-100. Lesi isisekelo sokukhetha, ngelotho, noma yiluphi uhlamvu, inombolo noma uphawu olukhomba ebangeni elifanele le-ASCII.

Uma ungaboni RANDOM.BETWEEN esigabeni Sezibalo (into eyenzekayo kuzinguqulo ezindala), ivule ngokuya ku Amathuluzi> Ama-plugins kanye nokumaka Amathuluzi okuhlaziyaUma isivuliwe, umsebenzi uzovela ku-Excel yakho.

Khiqiza ukhiye ngefomethi yezinhlamvu ezi-2 + izinombolo ezi-4 + nezinhlamvu ezi-2

Ikesi lakudala lidala amaphasiwedi anephethini engashintshiCabanga nje udinga izinhlamvu ezimbili ncamashi ekuqaleni, izinombolo ezine phakathi nendawo, nezinhlamvu ezimbili ekugcineni. Ngokulungiselela okuncane kanye namafomula athile alula, uzowalungisa emizuzwini embalwa.

Okokuqala, chaza ububanzi be-ASCII ozobusebenzisa. Kuseli E5, thayipha u-48 naku-F5, thayipha u-57 (izinombolo 0 kuya ku-9). Ku-E6, thayipha u-65 naku-F6, thayipha u-90 (izinhlamvu A–Z). Ngale ndlela, ungakwazi ukubhekisela kule mikhawulo ngaphandle kokuyibhala ngaso sonke isikhathi.

Ikhiqiza izinhlamvu ezingahleliwe kumaseli ngamanye. Ku-E2 faka: =CARACTER(ALEATORIO.ENTRE($E$6;$F$6)). Kopisha leyo fomula ku-D2, K2, kanye no-L2 ukuze uhlanganise izinhlamvu ezimbili zokuqala nezimbili zokugcina. Ngamunye uzobuyisela uhlamvu olukhulu olungahleliwe.

Manje dala izinombolo ezine eziphakathi nendawo. Ku-G2 bhala: =CARACTER(ALEATORIO.ENTRE($E$5;$F$5)) bese uhudulela kwesokudla uye ku-J2. Uzothola izinhlamvu zezinombolo ezine ezingahleliwe (0–9).

Ihlanganisa ukwenza iphasiwedi kuseli eyodwaKu-B2 ungajoyina yonke into ne-opharetha: =E2&F2&G2&H2&I2&J2&K2&L2. Uma ukhetha ifomula eyodwa, ithi, B4, ungayiqamba ngokuhlanganisa izingcingo eziya ku-CHAR + RANDBETWEEN ngesegimenti ngayinye: =CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$5;$F$5))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6))&CARACTER(ALEATORIO.ENTRE($E$6;$F$6)).

Ngaso sonke isikhathi uma i-Excel ibala kabusha, ukhiye uyashintshaCindezela u-F9 ukuze uphoqelele umdwebo omusha. Uma ufuna ukumisa igama eliyimfihlo elikhiqiziwe, kopisha iseli bese ulinamathisela njengamavelu ukuze iyeke ukubuyekeza ngokubala kabusha.

Amagama okuyimfihlo ahlanganisa osonhlamvukazi, osonhlamvukazi abancane, izinombolo, nezimpawu

Uma ngabe izinqubomgomo zakho zokuphepha zidinga izinhlobo zezinhlamvu ezahlukahlukene (osonhlamvukazi, abancane, amadijithi nezinhlamvu ezikhethekile), ungakha iphasiwedi enezindawo eziyi-8 ngokuhlanganisa ububanzi obufanele be-ASCII.

Nge-Excel ngeSpanishi Ungasebenzisa ifomula enjengale, ebuyisela izinhlamvu ezingosonhlamvukazi ezi-2, izinhlamvu ezi-2 ezincane, izinombolo ezi-2, nezimpawu ezikhethekile ezi-2: =CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(97;122))&3;CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(33;47))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(97;122))&3;CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(58;64)). Ukuze uthole ireferensi ebonakalayo yobubanzi, vakashela okokufundisa kwethu Phatha amaphasiwedi alondoloziwe ku-Edge.

Uma i-Excel yakho ingesiNgisi, ifomu elilingana ne-CHAR kanye ne-RANDBETWEEN lizoba: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(33,47)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(58,64))Ukuze uthole ukwaziswa okwengeziwe, sicela uhlole futhi isihloko sethu vimbela iziphequluli ekukhumbuleni amagama ayimfihlo.

Okukhiqizwa yisigaba ngasinye:

• 65-90: ufeleba olungahleliwe (A–Z).
• 97-122: uhlamvu oluncane olungahleliwe (a–z).
• 48-57: idijithi engahleliwe (0–9).
• 33–47 kanye 58–64: izinhlamvu ezikhethekile ezifana !, «, #, $, %, &, ', (, ), *, +, , , -, ., /, :, ;, <, =, >, ?, @, njll.

Hlela ubude nokusabalalisa ukulungisa ukuthi uphinda kangaki ibhulokhi ngayinye kanye nokuhlelwa okuvela ngakho. Ukuze umbe ujule ekuvikelekeni kwamaphasiwedi akho, hlola okokufundisa kwethu brute force izinhlelo ukwambula amaphasiwedi.

Khumbula ukuthi lawa mafomula abalwa kabushaUkuze ugcine ukhiye othile, kopisha iseli bese ulinamathisele njengamavelu. Ungakwazi futhi ukushintsha imodi yokubala ibe mathupha uma ukhiqiza amaqoqo amakhulu futhi ungafuni ukuthi ashintshe uze unqume.

Amaphasiwedi ezinombolo kuphela (asheshayo futhi angenazinkinga)

Uma okudingayo kuwukhiye wezinombolo onobude obugxilile, ungasebenzisa ububanzi. Isibonelo, ngamadijithi ayi-8: ku-Excel ngesiNgisi dala amaphasiwedi ku-Windows console ngefomula =RANDBETWEEN(10000000,99999999), nangeSpanishi =ALEATORIO.ENTRE(10000000;99999999). Ifomula izobuyisela inombolo enamadijithi ayisishiyagalombili.

Qaphela ngoziro abaholayoUma noma iyiphi inhlanganisela enoziro abaholayo ilungile, inketho eyodwa yile: =TEXTO(ALEATORIO.ENTRE(0;99999999);"00000000")Lokhu kuqinisekisa ukuthi umphumela uzohlala unezinombolo eziyi-8, ngisho noma iqala ngo-0. Ukuze ulawule amagama ayimfihlo alondoloziwe, ungabheka okokufundisa kwethu.

I-Kutools ye-Excel: Khiqiza amaphasiwedi ngokuchofoza okumbalwa

Uma ukhetha isixazululo esine-interface elula futhi ngaphandle kwamafomulaI-Kutools ye-Excel inikeza insiza ethi "Faka I-Random Data" eyenza amaphasiwedi ayinkimbinkimbi ngokukhetha izinhlobo zezinhlamvu nobude.

Indlela yokwenza ngayo:

1. Khetha ububanzi lapho ufuna ukufaka khona amaphasiwedi nokufinyelela I-Kutools> Faka> Faka Idatha Engahleliwe.
2. Kuthebhu ye-Chain, maka izinhlobo zezinhlamvu ozidingayo (osonhlamvukazi, abancane, izinombolo, izimpawu) bese uchaza ubude beketango.
3. Cindezela okuthi Yamukela futhi amaseli azogcwaliswa ngokuzenzakalela ngamaphasiwedi angahleliwe azinzile (angashintshi lapho elungiswa noma elayishwa kabusha).

Lolu hlelo lokusebenza lusebenza neminye imisebenzi: Faka izinombolo ezingahleliwe, amadethi, izikhathi, noma uhlu lwangokwezifiso, udale idatha yokuhlola eyahlukahlukene ngomzamo omncane.

Iyini i-password generator futhi kungani kufanele uyisebenzise?

Ijeneretha yephasiwedi idala okhiye ngokuzenzakalelayo ukulandela imithetho oyikhethayo (isb., okuhlanganisa izimpawu, osonhlamvukazi, ubude obuncane, njll.). Kuyindlela esebenzayo yokuqinisekisa ukuvikeleka okuqinile kwedijithali ngokulawula ukungahleliwe ngokwezidingo zakho.

Ukusebenzisa amagama ayimfihlo aqinile kubalulekileUkusebenzisa kabusha iphasiwedi efanayo kuwo wonke amasevisi amaningi kubangela ingozi enkulu: uma othile eyithola, angafinyelela ama-akhawunti amaningi. Ngaphezu kwalokho, kukhona inhlanganisela ebikezelwayo nesengozini efana ne-123456, Iphasiwedi, 1111, i-qwerty, noma i-admin okufanele igwenywe njalo.

Ukuze kube lula ukuphatha, kukhona izifanekiso, ngokusebenzisa isixhumi esibonakalayo esilula, ezikuvumela ukuthi ukhiqize amaphasiwedi ahambisana nezinqubomgomo ezithile zenhlangano ngayinye, ukwenza kube lula ukulawula okufanayo nokuphumelela.

Amathiphu asebenzayo nemikhuba engcono kakhulu yokwenza amaphasiwedi ku-Excel

Ukuze ugweme ukulahlekelwa amaphasiwedi akho akhiqiziweUma usunazo, zikopishe futhi uzinamathisele njengamavelu ukuze uzivikele ekushintsheni lapho ubala kabusha. Lokhu kuqinisekisa ukuthi igama-mfihlo lihlala lingashintshiwe, ngaphandle kokuguqulwa ngephutha.

Thuthukisa ukuphepha ngokuxuba i-odaNgisho noma usebenzisa amasegimenti athile kuphethini yakho, ungawahlela kabusha noma uwashove usebenzisa ukuhlunga noma imisebenzi ye-randomization, wenze amaphethini abe nzima kakhulu futhi ukhulise i-entropy.

Hlola ubunkimbinkimbi. Qiniseka ukuthi amafomula akho ahlangabezana nezidingo zokuba okungenani nohlamvu olulodwa lohlobo ngalunye (osonhlamvukazi, abancane, uphawu, inombolo) ngokuya ngezinqubomgomo zendawo yakho.

Yenza kusebenze i-plugin yokuhlaziya uma i-RANDBETWEEN ingekho. Ekufakeni okudala, yiya ku Amathuluzi> Ama-plugins nomkhiqizo Amathuluzi okuhlaziya. Isici sizobe sesitholakala esigabeni Sezibalo.

Khiqiza amanani amakhulu kalula. Sebenzisa isibambo sokugcwalisa ukukopisha amafomula phansi futhi udale amaphasiwedi amaningi ngesikhathi esisodwa. Nge-Kutools, mane ukhethe futhi ugcwalise konke ngezinyathelo ezisheshayo.

Ukulingana Komsebenzi (I-Excel nge-Spanish vs. English)

Uma usebenza ezinguqulweni zezilimi ezahlukene ze-Excel, khumbula lokho UMLINGISI = CHAR y RANDBETWEEN = RANDBETWEENNgeSipanishi, izimpikiswano zisebenzisa ama-semicolon (;), ngesiNgisi, okhefana (,).

Uhlu lokhiye lwe-ASCII lwamaphasiwedi Amagama ayimfihlo anochungechunge lwephasiwedi njengokuthi 48–57 (izinombolo), 65–90 (osonhlamvukazi), 97–122 (osonhlamvukazi abancane), kanye neyunithi yezinhlamvu zesimbuli efana no-33–47 kanye no-58–64 abalulekile ekudaleni amagama ayimfihlo aqinile futhi ahlukahlukene. Ungalungisa lokhu ngokuya ngenqubomgomo yakho yangaphakathi.

Qedela izibonelo ezilungele ukukopishwa

Izinhlamvu ezi-2 + Izinombolo ezi-4 + Iphethini Yezinhlamvu ezi-2 ku-Excel ngeSpanishi: Kusampula yefomula ku-B4, bhala: =CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(48;57))&CARACTER(ALEATORIO.ENTRE(65;90))&CARACTER(ALEATORIO.ENTRE(65;90)).

Iphasiwedi exutshwe enamadijithi ayi-8 enezimpawu ku-Excel ngesiNgisi: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(33,47)&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(48,57)&RANDBETWEEN(58,64))Uma i-Excel yakho inge-Spanish, shintsha u-CHAR ufake u-CHARACTER kanye no-RANDBETWEEN ufake i-RANDOM.BETWEEN, usebenzisa isemikholoni njengesihlukanisi.

Izinombolo ezinamadijithi angu-8 kuphela: ngeSpanishi =ALEATORIO.ENTRE(10000000;99999999), ngesiNgisi =RANDBETWEEN(10000000,99999999). Ukuze ufake oziro abaholayo, sebenzisa =TEXTO(ALEATORIO.ENTRE(0;99999999);"00000000"). Ukuze uqhubeke uthuthukisa ukuphathwa kwephasiwedi yakho, ungabheka okokufundisa kwethu Phatha ama-adaptha enethiwekhi ebonakalayo ku-Windows.

Khumbula: Yakha amatafula nge =CARACTER(N1) ukuhlola ukuthi yiziphi izinhlamvu ezihambisana nekhodi ngayinye, ukusiza ukulungisa ububanzi obufunekayo nezimpawu.

Ngakho konke lokhu, unesethi ebanzi yezinketho ukudala amaphasiwedi ku-Excel: kusuka emaphethini ahleliwe kuya ekuhlanganisweni okuhlukahlukene ngezinhlamvu, izinombolo, izimpawu, nobude obuhlukene, usebenzisa amafomula noma amathuluzi ahambisanayo afana ne-Kutools; ukuzivumelanisa nezidingo zakho zokuphepha.

I-athikili ehlobene:

Ungazivimba kanjani iziphequluli zewebhu ukuthi zingakhumbuli amaphasiwedi akho

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.