Indlela yokusetha izixhumanisi ku-AutoCAD

I-Excel ngokuyinhloko uhlelo lokucubungula idatha etafuleni. Umsebenzi we-VIEW ubonisa inani elifunayo kusuka etafuleni, ukucubungula ipharamitha eyaziwayo eyaziwa emgqeni noma ikholomu efanayo. Ngakho-ke, isibonelo, ungabonisa intengo yomkhiqizo eseceleni ehlukile, ecacisa igama layo. Ngokufanayo, ungathola inombolo yocingo ngegama lomuntu. Masihlole ukuthi umsebenzi we-VIEW usebenza kanjani.

Isicelo se-Operator VIEW

Ngaphambi kokuba uqale ukusebenzisa ithuluzi lokubuka, udinga ukudala itafula, lapho kuzoba khona amanani okudingayo ukuthola nokubeka amanani. Ngokwale mingcele, ukusesha kuzokwenziwa. Kunezindlela ezimbili zokusebenzisa umsebenzi: ukuma kwe-vector kanye nomumo wesakhiwo.

Indlela 1: Ifomu leVector

Le ndlela isetshenziswa kaningi phakathi kwabasebenzisi uma usebenzisa i-LOOKUP opharetha.

1. Ukuze kube lula, sakha itafula lesibili ngamakholomu "Inani elifunwa" futhi "Umphumela". Lokhu akudingekile, ngoba ngalezi zinhloso ungasebenzisa noma yimaphi amaseli eshidi. Kodwa kuyoba lula kakhulu.



2. Khetha iseli lapho umphumela wokugcina uzoboniswa khona. Kuyoba yindlela eqobo ngokwayo. Chofoza kusithonjana "Faka umsebenzi".



3. Iwindi ye-Function Wizard ivula. Kulolu hlu sibheke into "I-PROSMOTR" ukhethe bese uchofoza inkinobho "Kulungile".



4. Okulandelayo, iwindi elengeziwe livuleka. Kwamanye ama-opharetha, akuvamile. Lapha udinga ukukhetha eyodwa yefomu yokucubungula idatha exoxwa ngenhla: ifomu levector noma ifomu. Njengoba manje sicabangela ngokuqondile ukubuka kwe-vector, sikhetha ukhetho lokuqala. Sicindezela inkinobho "Kulungile".



5. Iwindi lempikiswano ivuleka. Njengoba ungabona, lo msebenzi unezimpikiswano ezintathu:
   • Inani elifunwa;
   • I-vector ebukwe;
   • Imiphumela yevector.

   Kulabo abasebenzisi abafisa ukusebenzisa lolu opharetha ngesandla, ngaphandle kokusebenzisa "Masters Imisebenzi", kubalulekile ukwazi i-syntax yokubhala kwayo. Kubonakala kanje:

   = VIEW (inani lokusesha, i-vector ebonakalayo, i-vector yemiphumela)

   Sizogxila ezindinganisweni okufanele zifakwe efasiteleni lezimpikiswano.

   Ensimini "Inani elifunwa" faka izixhumanisi zeseli lapho sizobhala khona ipharamitha ezosesha. Thina etafuleni lesibili elibizwa ngokuthi iseli elihlukile. Njengesijwayelekile, ikheli le-link lifakwe ensimini ngesandla ngokuvela kwikhibhodi noma ngokugqamisa indawo ehambelana nayo. Ukhetho lwesibili lungcono kakhulu.



6. Ensimini "Ibukwe Vector" ucacise ububanzi bamaseli, futhi kithi, ikholomu lapho amagama khona, okunye okuzorekhodwa esitokisini "Inani elifunwa". Ukufaka izixhumanisi kule nkambu kubuye kulula ngokukhetha indawo kushidi.



7. Ensimini "Vector Results" faka izixhumanisi zobubanzi lapho amanani esiwadingayo ukuze athole ayatholakala.



8. Ngemuva kokuthi yonke idatha ifakiwe, chofoza inkinobho "Kulungile".



9. Kodwa, njengoba singabona, kuze kube manje umsebenzi ubonisa imiphumela engalungile kuseli. Ukuze iqale ukusebenza, umuntu kufanele afake ipharamitha esiyidingayo kusukela ku-vector ebukwa esifundeni sexabiso elifunayo.

Ngemuva kokungena kwedatha, iseli lapho umsebenzi ukhona khona ugcwaliswa ngokuzenzekelayo ngombala ohambelana nomphumela wokuvota.

Uma singena elinye igama esitokisini senani elifunayo, umphumela, ngokulandelana, uzoshintsha.

Umsebenzi we-VIEWER ufana kakhulu neCDF. Kodwa ku-CDF, ikholomu ebhekwayo kufanele kube yiyona eyinxele. KULUNGILE lo mkhawulo awukho, njengoba sibona esibonelweni esingenhla.

Isifundo: I-Excel Function Wizard

Indlela 2: ifomu elihle

Ngokungafani nendlela eyedlule, le fomu isebenza ngokugcwele, okufaka ngokushesha ububanzi obubhekweyo nobubanzi bemiphumela. Ngesikhathi esifanayo, ububanzi obubukwayo kufanele bube yikhokho engakwesokunxele ye-array.

1. Ngemuva kweseli lapho umphumela uzoboniswa khona, uMphathi wemisebenzi uqalisiwe futhi ushintsho ku-VIEW opharetha lwenziwa, iwindi livula ukukhetha ifomu lomqhubi. Kulolu cala, khetha uhlobo lomqhubi we-opharetha, okuwukuthi, isikhundla sesibili kuhlu. Siyacindezela "Kulungile".



2. Iwindi lempikiswano ivuleka. Njengoba ungabona, lesi sigaba somsebenzi sinemibono emibili kuphela - "Inani elifunwa" futhi "Uhlu". Ngakho-ke, i-syntax yayo ilandelayo:

   = VIEWER (lookup_value; i-array)

   Ensimini "Inani elifunwa"njengendlela yangaphambilini, faka izixhumanisi zeseli lapho kuyofakwa khona umbuzo.



3. Kodwa ensimini "Uhlu" udinga ukucacisa izixhumanisi zendawo yonke, equkethe kokubili ububanzi obhekwayo kanye nobubanzi bemiphumela. Ngesikhathi esifanayo, ububanzi obubukwayo kumele bube yikholomu engakwesokunxele ye-array, ngaphandle kwalokho ifomula ngeke isebenze kahle.



4. Ngemuva kokuthi idatha ecacisiwe ifakiwe, chofoza inkinobho "Kulungile".



5. Manje, njengesikhathi sokugcina, ukuze usebenzise lo msebenzi, esitokisini ngenani elifunayo, faka elinye lamagama ebanga elibukwe.

Njengoba ungabona, emva kwalokhu, umphumela uboniswa ngokuzenzakalelayo endaweni ehambelana nayo.

Qaphela! Kumele kuqashelwe ukuthi ifomu lefomu ye-VIEW ye-array ayisasebenzi. Kuzinguqulo ezintsha ze-Excel, ikhona, kodwa ishiya kuphela ukuhambisana namadokhumenti akwenziwe izinguqulo zangaphambilini. Yize kungenzeka ukuthi usebenzise ifomu elihle ngezimo zesimanje zaloluhlelo, kunconywa kunconywa ukuthi usebenzise imisebenzi emisha ephezulu ye-CDF (ukuseshwa kukholomu yokuqala ebangeni) no-GPR (ngokusesha emgqeni wokuqala wobubanzi). Ngekho indlela ephansi ngaphansi kokusebenza kwefomu le-VIEW yamarrays, kodwa isebenza ngokuchanekile. Kodwa umqhubi we-vector VIEW usasebenza.

Isifundo: Izibonelo ze-cfr umsebenzi ku-Excel

Njengoba ubona, i-VIEW ye-opharetha ingumsizi omkhulu lapho efuna idatha ngenani elifunayo. Lesi sici siwusizo ikakhulukazi ematafuleni amade. Kumele kuqashelwe ukuthi kunezinhlobo ezimbili zalolu msebenzi - i-vector kanye ne-arrays. Iyokugcina isivele iphelelwe yisikhathi. Nakuba abanye abasebenzisi, lisetshenziswa kuze kube manje.