I-AC3Filter - ukuhlela imiphumela yomsindo ku-GOM Player

Kukholelwa ukuthi izinkomba ezisekelwe ku-Excel ziyinkulumo engalungile. Ngempela, ngokuvamile lokhu kuyindaba, kodwa hhayi njalo. Ngezinye izikhathi zisetshenziswa ngokuzithandela. Ake sithole ukuthi yiziphi izixhumanisi zomsakazo, indlela yokuzidala, indlela yokuthola ezitholakalayo kudokhumenti, indlela yokusebenza nabo, noma ukuzisusa uma kunesidingo.

Usebenzisa izikhombisi eziyindilinga

Okokuqala, thola ukuthi yini ebonisa ukubhekisela kwesekhula. Eqinisweni, kubonisa ukuthi, ngokusebenzisa amafomu kwamanye amaseli, kubhekisela kuye. Kungase futhi kube isixhumanisi esitholakala kulesi sici esetshenziselwa yona ngokwayo.

Kumele kuqashelwe ukuthi ngokuzenzakalelayo, izinguqulo zanamuhla ze-Excel zivimbela ngokuzenzakalelayo inqubo yokwenza umsebenzi we-cyclic. Lokhu kungenxa yokuthi izinkulumo ezinjalo ziyiphutha kakhulu, futhi ukukhishwa kwakha inqubo eqhubekayo yokuvuselela nokubala, okwenza umthwalo owengeziwe ohlelweni.

Ukudala inkomba yombuthano

Manje ake sibone indlela yokudala inkulumo elula yokukhipha. Lokhu kuyoba isixhumanisi esisekeleni elifanayo lapho libhekisela kuyo.

1. Khetha into yeshidi A1 bese ubhala inkulumo elandelayo kulo:

   = A1

   Okulandelayo, chofoza inkinobho Ngena kwikhibhodi.



2. Emva kwalokhu, ibhokisi lengxoxo yokuxwayisa inkulumo ye-cyclic ivela. Sichofoza kukho inkinobho. "Kulungile".



3. Ngakho-ke, sithole ukusebenza kwe-cyclic kushidi lapho iseli libhekisela khona.

Masiqhube kancane umsebenzi bese sakha ukukhuluma kwe-cyclic kusuka kwamaseli amaningana.

1. Bhala inombolo kunoma yiluphi uhlamvu lweshidi. Masibe iseli A1kanye nenombolo 5.



2. Kwesinye iseli (B1) bhala le nkulumo:

   = C1



3. Into elandelayo (C1) bhala ifomula elandelayo:

   = A1



4. Emva kwalokhu sibuyela esitokisini. A1lapho inombolo isethwe khona 5. Sibhekisela kwisici sakhe B1:

   = B1

   Sicindezela inkinobho Ngena.



5. Ngakho, i-loop ivaliwe, futhi sithola isixhumanisi se-cyclic classic. Ngemuva kwewindi lokuxwayisa ivaliwe, sibona ukuthi uhlelo luye lwafaka ukuxhumeka kwe-cyclic ngemicibisholo eluhlaza okwesibhakabhaka kushidi, okubizwa ngokuthi imicibisholo yomkhondo.

Manje siphenduka ekudaleni inkulumo ye-cyclic kusibonelo setafula. Sinetafula lokuthengisa kokudla. Iqukethe amakholomu amane lapho igama lomkhiqizo, inani lemikhiqizo ethengiswayo, intengo kanye nenani lemali etholakalayo ekuthengisweni kwalo lonke ivolumu kubonisiwe. Kukhona amafomula kakade etafuleni kukholomu yokugcina. Balala imali engenayo ngokuphindaphinda inani ngenani.

1. Ukuze ulandele ifomula emgqeni wokuqala, khetha isici seshidi ngobuningi bomkhiqizo wokuqala (B2). Esikhundleni se-static value (6) singena lapho ifomu elizobala inani lempahla ngokuhlukanisa inani eliphelele (D2) ngentengo (C2):

   = D2 / C2

   Chofoza inkinobho Ngena.



2. Sithole isixhumanisi sokuqala se-cyclic, ubuhlobo obunjwayele umcibisholo wokulandelela. Kodwa njengoba ubona, umphumela uyiphutha futhi ulingana no-zero, njengoba sekushiwo ngaphambili, i-Excel ivimbela ukusebenza kwe-cyclic.



3. Kopisha le nkulumo kuwo wonke amanye amaseli ekholomu nenani lemikhiqizo. Ukuze wenze lokhu, setha isikhombisi ekhoneni elingezansi elingakwesokudla se-element esivele iqukethe ifomula. I-cursor iguqulwa esiphambanweni, esibizwa ngokuthi uphawu lokugcwalisa. Gwema inkinobho yesinxele yesinxele bese uhudulela lo mgwaqo phansi kuze kube sekupheleni kwetafula.



4. Njengoba ungabona, le nkulumo ikopishwe kuzo zonke izakhi zekholomu. Kodwa, ubuhlobo obulodwa kuphela bubekwe umcibisholo wokulandelela. Qaphela lokhu ngekusasa.

Sesha izinkomba eziyindilinga

Njengoba sesibonile ngaphambili, hhayi kuzo zonke izimo lolu hlelo lubonisa ukuhlanganiswa kokubhekisela kweseyingi ngezinto, ngisho noma kushicilelwe. Njengoba kunikezwe ukuthi imisebenzi yokunyathelisa eyingozi kakhulu iyingozi, kufanele isuswe. Kodwa lokhu kumele kuqala bathole. Lokhu kungenziwa kanjani uma izinkulumo zingabonakaliswa ngomugqa ngemicibisholo? Ake sibhekane nalo msebenzi.

1. Ngakho-ke, uma uqhuba ifayela le-Excel uma uvula iwindi lwazi ngokuthi liqukethe isixhumanisi esiyindilinga, kuphakanyiswa ukuyithola. Ukwenza lokhu, thuthela kuthebhu "Amafomula". Chofoza ku-riboni kunxantathu, ekhona ngakwesokudla kwenkinobho "Hlola amaphutha"etholakala ebhodini lamathuluzi "I-Formula Dependencies". Imenyu ivula lapho kufanele uhambise isikhombisi into "Izixhumanisi ze-Cyclic". Ngemuva kwalokho, imenyu elandelayo ivula uhlu lwamakheli ezakhi zetshe lapho uhlelo luye lwabona khona izinkulumo zomsakazo.



2. Uma uchofoza ekhelini elithile, iseli elihambelanayo kushidi likhethiwe.

Kukhona enye indlela yokuthola ukuthi isixhumanisi esiyindilinga sitholakala kuphi. Umlayezo ngale nkinga kanye nekheli lento equkethe inkulumo efanayo ifakwe ngakwesokunxele kwesibalo sesimo, esitholakala phansi kwefasitela le-Excel. Noma kunjalo, ngokungafani nenguqulo yangaphambilini, amakheli ebha yomumo azobonisa amakheli akuzona zonke izakhi eziqukethe izinkomba eziyindilinga, uma zikhona eziningi, kodwa enye yazo, eyabonakala ngaphambi kwabanye.

Ngaphezu kwalokho, uma usencwadini equkethe inkulumo yokuvula, hhayi eshadini lapho itholakala khona, kodwa kwenye, khona-ke kulokhu kuphela umlayezo mayelana nokuba khona kwephutha ngaphandle kwekheli kuzoboniswa kubha yesimo.

Isifundo: Indlela yokuthola izixhumanisi eziyindilinga ku-Excel

Lungisa izixhumanisi ze-cyclic

Njengoba kukhonjisiwe ngenhla, ezimweni eziningi kakhulu, ukusebenza kwe-cyclic kukhona okubi okumelwe kukhishwe. Ngakho-ke, kuyinto engokwemvelo ukuthi emva kokuba kutholakale uxhumano lwe-cyclic, kuyadingeka ukuyilungisa ukuze ulethe ifomula kwifomu evamile.

Ukuze ulungise ukuthembela kwe-cyclic, kubalulekile ukulandelela konke ukuhlangana kwamaseli. Ngisho noma isheke sibonisa iseli ethize, khona-ke iphutha lingase lingaboni ngokwalo, kodwa kwezinye izingxenye zohlu lokuxhomeka.

1. Esikhathini sethu, naphezu kokuthi uhlelo lukhomba ngokuqondile kwenye yamaseli omjikelezo (D6), iphutha langempela likhona kwenye iseli. Khetha into D6ukuthola ukuthi yiliphi amangqamuzana athola inani. Sibheka inkulumo ebhasini lefomula. Njengoba ubona, ukubaluleka kulesi sici seshidi kwakha ngokuphindaphinda okuqukethwe kwamaseli B6 futhi C6.



2. Iya esitokisini C6. Khetha bese ubheka ibha yefomula. Njengoba ungabona, lokhu kuyinani elijwayelekile le-static (1000), okuyinto engeyona umkhiqizo wefomula. Ngakho-ke, kuphephile ukusho ukuthi into ecacisiwe ayinayo iphutha elidala ukudala ukusebenza kwe-cyclic.



3. Iya kweseli elilandelayo (B6). Ngemva kokukhetha ifomula emgqeni, sibona ukuthi iqukethe inkulumo ebalwe (= D6 / C6), okudonsa idatha kusuka kwezinye izakhi zetafula, ikakhulukazi, kusuka kuseli D6. Ngakho iseli D6 ibhekisela kudatha yento B6 futhi ngokuphambene nalokho, okubangela ukuphazamiseka.

   

   Lapha, sibalwa ubuhlobo ngokushesha, kodwa empeleni kunezimo lapho inqubo yokubala ihilela amangqamuzana amaningi, hhayi izakhi ezintathu, njengezethu. Khona-ke ukusesha kungathatha isikhathi eside, ngoba kuzodingeka ufunde isici ngasinye somjikelezo.

4. Manje kudingeka siqonde ukuthi yiliphi iseli (B6 noma D6) iqukethe iphutha. Nakuba, ngokomthetho, lokhu akuyona neze iphutha, kodwa nje ukusebenzisa ngokweqile izixhumanisi, okuholela ekuguquleni. Phakathi nenqubo yokunquma ukuthi iyiphi iseli ukuhlela, udinga ukusebenzisa i-logic. Ayikho i-algorithm ecacile yesenzo. Esimeni ngasinye, lo logic izohluka.

   Isibonelo, uma etafuleni lethu inani eliphelele kufanele libalwe ngokuphindaphinda ubuningi bezimpahla empeleni bathengiswe ngentengo yalo, khona-ke singasho ukuthi isixhumanisi esilinganisela inani esivela esilinganisweni sokuthengiswa akucaci lutho. Ngakho-ke, siyisusa futhi siyishintshe nge-value static.



5. Senza umsebenzi ofanayo kuwo wonke amanye ama-cyclic expressions, uma eseshidi. Ngemuva kokuthi zonke izixhumanisi eziyindilinga zisusiwe encwadini, umlayezo mayelana nokuba khona kwalenkinga kufanele upheleke kubha yomumo.

   Ngaphezu kwalokho, kungakhathaliseki ukuthi ama-cyclical amazwi asuswe ngokuphelele, ungathola ukuthi usebenzisa ithuluzi lokuhlola iphutha. Iya kuthebhu "Amafomula" bese uchofoze unxantathu owaziwa kakade ngakwesokudla kwenkinobho "Hlola amaphutha" eqenjini lamathuluzi "I-Formula Dependencies". Uma kunemenyu yokuqala imenyu "Izixhumanisi ze-Cyclic" ngeke isebenze, kusho ukuthi sisuse zonke izinto ezinjalo kusuka kumqulu. Ngenkathi ehlukile, kuzodingeka usebenzise inqubo yokususa ezakhiweni ezikuloluhlu, ngendlela efanayo okucatshangwa ngaphambilini.

Ukuvumela ukusebenza kwe-cyclic

Engxenyeni yangaphambilini yesifundo, sichaza ngokuyinhloko indlela yokubhekana nezinkomba eziyindilinga, noma ukuthi ungayithola kanjani. Kodwa, ngaphambili ingxoxo yayiyiqiniso lokuthi kwezinye izimo, ngokuphambene nalokho, zingasiza futhi zisetshenziswe ngokucophelela ngumsebenzisi. Isibonelo, ngokuvamile le ndlela isetshenziselwa ukubalwa kwe-iterative ngenkathi ukwakhiwa kohlobo lwezomnotho. Kodwa inkathazo yukuthi, kungakhathaliseki ukuthi uyaziqaphela ngokungazi noma ngokungazi inkulumo ye-cyclic, i-Excel ngokuzenzakalelayo izobe ivimbele ukusebenza kuzo, ukuze ingadluli ekuqedeni ngokweqile kwesistimu. Kulesi simo, inkinga yokukhubaza ngokuqinile ukukhiya okunjalo iba efanele. Ake sibone ukuthi singayenza kanjani.

1. Okokuqala, hamba kuthebhu "Ifayela" Izinhlelo ze-Excel.



2. Okulandelayo, chofoza entweni "Izinketho"elisehlangothini lwesobunxele lwewindi elivula.



3. Iwindi ye-Excel Parameters iqala. Sidinga ukuya kuthebhu "Amafomula".



4. Kusewindini evuliwe ukuthi kuzokwenzeka ukukhiqiza imvume yokwenza umsebenzi we-cyclic. Yiya ebhokisini elilungile laleli festile, lapho izilungiselelo ze-Excel zikhona khona. Sizosebenza nezilungiselelo zokuvimba. "Izibalo zokubala"esitholakala phezulu.

   Ukuze unike amandla ukusetshenziswa kwezinkulumo, kufanele uhlole ibhokisi eceleni kwepharamitha "Nika amandla izibalo ezilinganayo". Ngaphezu kwalokho, ebhokisini elifanayo, ungakwazi ukumisa inombolo yokukhawulelwa kokubheka kanye nephutha elihlobene. Ngokuzenzakalelayo, amanani awo ayi-100 no-0.001, ngokulandelana. Ezimweni eziningi, lezi ziminganiso akudingeki zishintshwe, noma ngabe kunesidingo noma uma ufisa, ungenza izinguquko ezinkambu ezibonisiwe. Kodwa lapha kuyadingeka ukuthi ucabange ukuthi ukuphindaphindiwe okuningi kungabangela umthwalo ojulile ohlelweni futhi uhlelo lonke, ikakhulukazi uma usebenza nefayela eliqukethe izinkulumo eziningi.

   Ngakho, usethe uphawu eduze kweparitha "Nika amandla izibalo ezilinganayo"futhi ukuze izilungiselelo ezintsha zisebenze, chofoza inkinobho "Kulungile"etholakala phansi kwewindi yezinketho ze-Excel.



5. Ngemva kwalokho siya ngokuzenzakalelayo eshadini lencwadi yamanje. Njengoba ubona, kumaseli lapho amafomu ama-cyclic atholakalayo, manje amanani abalwa kahle. Uhlelo aluvimbeli izibalo kuzo.

Kodwa nokho kufanele kuqaphele ukuthi ukufakwa kokusebenza kwe-cyclic akufanele kusetshenziswe kabi. Lesi sici kufanele sisetshenziswe kuphela lapho umsebenzisi eqiniseka ngokuphelele ngesidingo sakhe. Ukufakwa okungaqondakali kwemisebenzi ye-cyclic kungase kungabangeli nje ukulayisha ngokweqile ohlelweni futhi kunciphisa izibalo lapho usebenza nedokhumenti, kodwa umsebenzisi angase angene ngokungavumelani inkulumo eyiphutha yama-cyclic ukuthi ngokuzenzakalelayo izovinjelwa ngokushesha ngohlelo.

Njengoba sibona, ezimweni eziningi kakhulu, izingcaphuno eziyinkimbinkimbi yinto okumelwe iphathwe ngayo. Ukuze wenze lokhu, okokuqala, kufanele uthole ubuhlobo obuseduze uqobo, bese ubala iseli eliqukethe iphutha, futhi, ekugcineni, liqede ngokwenza izilungiso ezifanele. Kodwa kwezinye izimo, ukusebenza kwe-cyclic kungasiza ekubaleni futhi kwenziwa ngomsebenzisi ngokucophelela. Kodwa noma kunjalo, kubalulekile ukusebenzisa indlela yokusebenzisa ngokuqapha, ukusetha kahle i-Excel nokwazi isilinganiso sokungeza izixhumanisi ezinjalo, okuthi, uma zisetshenziselwa kakhulu, zinganciphisa uhlelo.