Ukusebenza ngetafula elijwayelekile kuhilela ukudonsa amagugu kusuka kwamanye amathebula kuwo. Uma kukhona amatafula amaningi, ukudluliswa kwamandla kuzothatha isikhathi esiningi, futhi uma idatha ivuselelwa njalo, khona-ke lokhu kuzoba umsebenzi we-Sisyphean. Ngenhlanhla, kukhona umsebenzi we-CDF onika amandla okuzitholela ngokuzenzakalelayo idatha. Ake sibheke izibonelo ezithile zendlela lesi sici esisebenza ngayo.
Incazelo yemisebenzi ye-CDF
Igama lomsebenzi we-CDF libizwa ngokuthi "umsebenzi wokubuka oqondile". NgesiNgisi igama layo lizwakala - VLOOKUP. Lo msebenzi usesha idatha ekholini lesobunxele lohlu olufundwayo, bese ubuyisela inani eliphumela esitokisini esicacisiwe. Kulula nje, i-VPR ikuvumela ukuba uhlele kabusha amanani kusuka kuseli linye itafula kuya kwelinye itafula. Thola ukuthi ungasebenzisa kanjani umsebenzi we-VLOOKUP ku-Excel.
Isibonelo sokusebenzisa i-CDF
Ake sibheke ukuthi umsebenzi we-VLR usebenza kanjani nesibonelo esithile.
Sinamatafula amabili. Okwokuqala kubo ithebula lokuthenga lapho amagama okudla okubekwa khona abekwa khona. Kukholomu elilandelayo ngemuva kokuthi igama lingenani lobuningi bezimpahla ofuna ukuzithenga. Okulandelayo kuza inani. Futhi kukholomu yokugcina - izindleko eziphelele zokuthenga igama lomkhiqizo othize, elibalwe yindlela yokwandisa ubungakanani ngentengo kakade ifakwe esitokisini. Kodwa intengo esidinga ukuyikhuphula yona isebenzisa i-CDF kusuka etafuleni eliseduze, okuyinto uhlu lwamanani.
- Chofoza kuseli eliphezulu (C3) kukholomu "Intengo" etafuleni lokuqala. Bese uchofoza isithonjana "Faka umsebenzi"okuyinto ekhona phambi ibha yefomula.
- Kuwindidi yewindi yemisebenzi evula, khetha isigaba "Izixhumanisi nezigaba". Khona-ke, kusukela kusethi eveziwe yemisebenzi, khetha "CDF". Sicindezela inkinobho "Kulungile".
- Ngemuva kwalokho, iwindi livuleka lapho ungafaka khona izingxabano zomsebenzi. Chofoza inkinobho ekhona ngakwesokudla kwenkambu yokufaka idatha ukuze uqhubeke nokukhethwa kwempikiswano yenani elifunayo.
- Njengoba sinexabiso elifunwa seli seli C3, lokhu "Amazambane"bese ukhetha inani elihambelanayo. Siphindela ewindini lezingxoxo zokusebenza.
- Ngendlela efanayo, chofoza isithonjana ngakwesokudla kwenkambu yokufaka idatha ukuze ukhethe ithebula lapho amanani azokhipha khona.
- Khetha yonke indawo yetafula lesibili, lapho amanani azosesha, ngaphandle kwekhanda. Siphinda sibuyela efasiteleni lesivumelwano sokusebenza.
- Ukuze wenze amanani akhethiwe ahlobene ngokuphelele, futhi sidinga lokhu ukuze amanani angadluli lapho ithebula lishintshwa kamuva, mane ukhethe isixhumanisi ensimini "Ithebula"bese ucindezela ikhi yomsebenzi F4. Emva kwalokho, izimpawu ze dollar zengezwa kusixhumanisi futhi ziba ngokuphelele.
- Kukholomu elilandelayo "Inombolo yekholomu" sidinga ukucacisa inombolo yekholomu esizobonisa ngayo amanani. Le kholomu isendaweni eveziwe etafuleni. Njengoba ithebula liqukethe amakholomu amabili, kanti ikholomu ngamanani yiyesibili, sibeka inombolo "2".
- Kukholomu lokugcina "Ukubukwa kwesikhashana" sidinga ukucacisa inani "0" (FALSE) noma "1" (TRUE). Esikhathini sokuqala, ukufana okuqondile kuphela kuzoboniswa, futhi okwesibili - okulinganiselwa kakhulu. Njengoba amagama omkhiqizo ayedatha yombhalo, awakwazi ukulingana, ngokungafani nedatha yenombolo, ngakho-ke sidinga ukusetha inani "0". Okulandelayo, chofoza inkinobho "Kulungile".
Njengoba ubona, intengo yamazambane ihanjelwe etafuleni kusukela kuhlu lwamanani. Ukuze singenzi inkambiso enzima kangaka ngamanye amagama okuhweba, sivele sibe ekhoneni elingezansi elingakwesokudla leseli eligcwele ukuze isiphambano sibonakale. Sibheka lesi sivuno phansi kwetafula.
Ngakho-ke, sidonse yonke idatha edingekayo kusuka etafuleni eliya kwenye, sisebenzisa umsebenzi we-CDF.
Njengoba ungabona, umsebenzi we-CDF awuyinkimbinkimbi njengoba kubonakala ekuqaleni. Ukuqonda uhlelo lwakho lokusebenza akulona nzima kakhulu, kodwa ukuqonda leli thuluzi kuzokulondoloza isikhathi esiningi uma usebenza namatafula.
