Sebenza ngezinkomba ze-cyclic ku-Excel

Kukholelwa ukuthi izinkomba ze-cyclic in accele ziyinkulumo eyiphutha. Ngempela, kaningi lokhu kunjalo, kepha namanje akuyona njalo. Kwesinye isikhathi zisebenza ngonembeza. Ake sibheke ukuthi yiziphi izixhumanisi ze-cyclic ukuthi zingazakhela kanjani ukuze zithole ukuthi zivele zivele kanjani kudokhumenti ukuthi ungasebenza kanjani nabo noma ungayisusa kanjani.

Ukusetshenziswa Kwezinkomba ZaseCyclic

Okokuqala, thola ukuthi yisiphi isixhumanisi se-cyclic. Ngamafuphi, le nkulumo, okuthi, ngokusebenzisa amafomula kwamanye amaseli, ayazibiza ngokwawo. Futhi, kungaba isixhumanisi esisendaweni yeqabunga elenayo uqobo.

Kufanele kuqashelwe ukuthi ngokuzenzakalelayo, izinguqulo zanamuhla ze-Excel zivimba ngokuzenzakalelayo inqubo yokwenza umsebenzi wokujikeleza. Lokhu kungenxa yokuthi izinkulumo ezinjalo ngobuningi zinephutha, futhi ukukhululwa kukhiqiza inqubo eqhubekayo yokuphindaphinda nokubala, okudala umthwalo owengeziwe ohlelweni.

Ukwakha isixhumanisi se-cyclic

Manje ake sibheke ukuthi ungawakha kanjani inkulumo elula yokubhaka. Lokhu kuzoba yisixhumanisi esisekholi efanayo lapho kubhekiswa khona.

1. Sigqamisa into yephepha le-A1 bese sibhala le nkulumo elandelayo kuyo:

   = A1.

   Okulandelayo, chofoza inkinobho ethi Enter kwikhibhodi.



2. Ngemuva kwalokho, kuvela ibhokisi lengxoxo yengxoxo ye-cyclic expression. Chofoza kuyo inkinobho ethi "Kulungile".



3. Ngakho-ke, sathola umsebenzi wokufundisa ekhasini lapho iseli lisho ngokwalo.

Umsebenzi omncane oxakanise kakhulu futhi wakhe isisho se-cyclic kusuka kumaseli amaningana.

1. Kunoma iyiphi into yeshidi, bhala inombolo. Akube yiseli A1, nenombolo 5.



2. Kwelinye iseli (B1) Bhala le nkulumo:

   = C1.



3. Entweni elandelayo (C1) Sizorekhoda ifomula enjalo:

   = A1.



4. Emva kwalokho, sibuyela esitokisini A1, lapho inombolo isethwe 5. Yibhekisa kuyo ku-Elemel B1:

   = B1.

   Chofoza inkinobho ethi Enter.



5. Ngakho-ke, umjikelezo uvaliwe, futhi sathola isixhumanisi se-cyclic classic. Ngemuva kokuthi iwindi lokuxwayisa livaliwe, siyabona ukuthi uhlelo luphawule isibopho se-cyclic ngemicibisholo eluhlaza okwesibhakabhaka eshidini, elibizwa ngokuthi yi-Trace Arrows.

Manje siphendukela ekwakheni inkulumo ye-cyclic ngokwesibonelo setafula. Sinetafula lokuqaliswa kwetafula. Siqukethe amakholomu amane, akhombisa igama lezimpahla, inani lemikhiqizo elithengisiwe, inani nenani lemali engenayo ekuthengisweni kwalo lonke ivolumu. Ithebula kukholamu lokugcina selivele linamafomula. Babala imali ngokuphindaphinda inani lentengo.

1. Ukukhulula ifomula emgqeni wokuqala, sigqamisa into eshidi ngenombolo yomkhiqizo wokuqala (B2). Esikhundleni senani elibi (6), faka ifomula lapho, elizocubungula inani lezimpahla ngokuhlukanisa inani eliphelele (D2) ngentengo (C2):

   = D2 / C2

   Chofoza inkinobho ethi Enter.



2. Siphume isixhumanisi sokuqala se-cyclic, ubudlelwano obujwayele umcibisholo we-trace. Kepha njengoba sibona, umphumela uba ngephutha futhi ulingana no-zero, njengoba sekushiwo ngaphambili, i-Excel ivimba ukubulawa kokusebenza kwe-cyclic.



3. Kopisha inkulumo kuwo wonke amanye amaseli wekholomu ngenani lemikhiqizo. Ukuze wenze lokhu, setha isikhombisi endaweni engezansi yesokudla yale nto esele iqukethe ifomula. Isikhombisi siguqulwa siye esiphambanweni, esibizwa ukuthi sibize umaki wokugcwalisa. Sula inkinobho yegundane kwesobunxele bese udonsa lesi siphambano kuze kube sekupheleni kwetafula phansi.



4. Njengoba ubona, le nkulumo yakopishwa kuzo zonke izakhi zekholomu. Kepha, ubudlelwano obunye kuphela obumakwe ngomcibisholo we-trace. Qaphela ngekusasa.

Sesha izixhumanisi ze-cyclic

Njengoba sesivele sikubonile ngaphezulu, hhayi kuzo zonke izimo uhlelo luphawule ubudlelwano benkomba ye-cyclic ngezinto, noma ngabe kuseshidini. Njengoba kunikezwe iqiniso lokuthi ekusebenzeni okukhulu kakhulu kwe-cyclic cirlic kuyingozi, kufanele zisuswe. Kepha kulokhu kufanele baqale bathole. Ungakwenza kanjani lokhu uma izinkulumo zingabhalwe ngomugqa womcibisholo? Masibhekane nalo msebenzi.

1. Ngakho-ke, uma uqala ifayela le-Excel, unewindi lolwazi eliqukethe isixhumanisi se-cyclic, kuyinto efiselekayo ukuyithola. Ukuze wenze lokhu, dlulela kuthebhu "yefomula". Chofoza ku-Ribbon kunxantathu, okutholakala ngakwesokudla 'kokuhlola amaphutha', atholakala "ekuthembekeni kokuxhomekeka kwe-" Ukuthembela Ukuthembela "Ithuluzi. Kuvulwa imenyu lapho isikhombisi kufanele sisingathwe khona ku- "Cyclic Links". Ngemuva kwalokho, imenyu elandelayo ivula uhlu lwamakheli eshidi lapho lolu hlelo lwathola khona izinkulumo ze-cyclic.



2. Lapho uchofoza ikheli elithile, iseli elihambisanayo likhethiwe eshidini.

Kunenye indlela yokuthola ukuthi isixhumanisi se-cyclic sitholakala kuphi. Umlayezo ophathelene nale nkinga nekheli lento equkethe inkulumo efanayo itholakala ohlangothini lwesobunxele lwentambo yesimo, isezansi kwewindi le-Excel. Kuliqiniso, ngokungafani nenguqulo yangaphambilini, amakheli azona zonke izinto eziqukethe izinkomba zesikebhe ezizoboniswa kubha yesimo, uma kukhona eziningi zazo, kodwa munye kuphela wazo, ovele phambi kwabanye.

Ngaphezu kwalokho, uma usencwadini equkethe inkulumo ye-cyclic, hhayi ephepheni lapho itholakala khona, futhi ngakolunye uhlangothi, khona-ke umyalezo mayelana nokuba khona kwephutha ozoboniswa kubha yesimo.

Isifundo: Ungazithola kanjani izixhumanisi ze-cyclic ukuze udlule

Ukulungiswa Kwezinkomba ZaseCyclic

Njengoba kushiwo ngenhla, kumacala amaningi amakhulu, ukusebenza kwe-cyclic kubi, lapho kufanele kuqedwe kalula. Ngakho-ke, kungokwemvelo ukuthi ngemuva kokuxhumeka kwe-cyclic kutholakele, kuyadingeka ukuyilungisa ukuletha ifomula kwifomu elijwayelekile.

Ukuze ulungise ukuncika kwe-cyclical, udinga ukulandelela konke ukuxhumana kwamaseli. Noma ngabe isheke libonisa iseli ethile, khona-ke iphutha kungenzeka lingamboziwe kulo ngokwalo, kodwa kwesinye isici sokuncika.

1. Kuthu, naphezu kweqiniso lokuthi uhlelo lukhombe kahle komunye wamangqamuzana omjikelezo (D6), iphutha langempela lilele kwelinye iseli. Khetha into ye-D6 ukuthola ukuthi imaphi amaseli adonsela inani. Sibheka le mpikiswano entanjeni yefomula. Njengoba sibona, inani kule nto eshidi lenziwa ngokuphindaphinda okuqukethwe kwamaseli we-B6 nama-C6.



2. Iya kwiseli le-C6. Sikugqamisa bese sibheka intambo yefomula. Njengoba sibona, yinani elijwayelekile le-static (1000), okungewona umkhiqizo ukubala ifomula. Ngakho-ke, kuphephile ukusho ukuthi into ebekiwe ayinawo amaphutha abangela ukusebenza kwe-cyclic.



3. Iya esitokisini esilandelayo (B6). Ngemuva kokukhethwa emugqeni wefomula, siyabona ukuthi inenkulumo ebaliwe (= D6 / C6), edonsa imininingwane evela kwezinye izinto zetafula, ikakhulukazi, kusuka ku-D6 cell. Ngakho-ke, i-D6 cell isho imininingwane ye-Elemel B6 nangokuphambene nalokho, okubangela ukuphanga.

   

   Lapha ubudlelwano besilibala ngokushesha ngokushesha, kepha empeleni kunezimo lapho amaseli amaningi ebandakanyeka enqubweni yokubalwa, hhayi izinto ezintathu njengoba sinazo. Lapho-ke ukusesha kungathatha isikhathi eside impela, ngoba kuzofanela kutadishe yonke into ye-cyclical.

4. Manje kudingeka siqonde ukuthi yiliphi iseli (B6 noma i-D6) liqukethe iphutha. Yize, ngokusemthethweni, akusikho ngisho nephutha, kepha ukusetshenziswa ngokweqile kwezinkomba eziholela ekungeneni. Ngesikhathi senqubo yokuxazulula ukuthi iyiphi iseli okufanele ihlelwe, udinga ukufaka uphawu lwengqondo. Alikho i-algorithm ecacile yesenzo. Esimweni ngasinye, le nto enengqondo izoba yayo.

   Isibonelo, uma itafula lethu labelana ngenani eliphelele kufanele libalwe ngokuphindaphinda inombolo yempahla ethengiswa ngentengo yayo, khona-ke singasho ukuthi isixhumanisi sibala inani lenani eliphelele lokuthengisa lihle kakhulu. Ngakho-ke, siyakususa futhi sikubuyise ngokubaluleka kwe-static.



5. Ukusebenza okunjalo kwenziwa phezu kwazo zonke ezinye izinkulumo ze-cyclic uma ziseshidi. Ngemuva kwazo zonke izixhumanisi ze-cyclic zisusiwe encwadini, umyalezo mayelana nokuba khona kwale nkinga kufanele anyamalale kusuka entanjeni yesimo.

   Ngaphezu kwalokho, izinkulumo ze-cyclic zisuswe ngokuphelele, ungathola usebenzisa ithuluzi lokuhlola iphutha. Yiya kuthebhu ethi "Amafomula" bese uqhafaza unxantathu osevele usijwayelene nelungelo le- "Ukuhlola amaphutha" eqenjini lensimbi "Ngokuya ngamafomula" . Uma into ethi "Izixhumanisi ze-Cyclic Lickints" kumenyu esebenzayo ayisebenzi, khona-ke, kusho ukuthi sisuse zonke izinto ezinjalo kusuka kudokhumenti. Esimweni esiphambene, kuzodingeka usebenzise inqubo yokususwa kwezinto ezifakwe kuhlu, okufanayo ngendlela efanayo.

Imvume yokwenziwa kokusebenza kwe-cyclic

Engxenyeni edlule yesifundo, satshelwa, ikakhulukazi ukuthi singabhekana kanjani nezinkomba zeCyclic, noma ukuthi uzithola kanjani. Kepha, phambilini, le ngxoxo ibikhuluma ngaleyo kwezinye izimo, kunalokho, ingaba wusizo futhi isetshenziswe ngumsebenzisi ngonembeza. Isibonelo, imvamisa le ndlela isetshenziselwa ukubalwa okuzayo lapho kwakha amamodeli ezomnotho. Kepha inkathazo ukuthi, kungakhathalekile ukuthi unokunye noma ngabe ungazi noma ngokungazi usebenzise inkulumo ye-cyclic, i-Excel isazovimba ukusebenza kubo ngokuzenzakalelayo, ukuze kungaholeli ekugcwaliseni ngokweqile kohlelo. Kulokhu, umbuzo wokuphoqelelwa ukukhubaza okunjalo okuvinjelwe kusebenza. Ake sibheke ukuthi singakwenza kanjani.

1. Okokuqala, sithuthela kuthebhu "yefayela" yohlelo lokusebenza lwe-Excel.



2. Okulandelayo, chofoza into "yepharamitha" etholakala ohlangothini lwesobunxele lwewindi elalivuliwe.



3. Iwindi lepharamitha elidingida liqala ukusebenza. Sidinga ukungena kuthebhu "yefomula".



4. Kusefasiteleni elivulwa lizovunyelwa ukwenza ukwenziwa kwemisebenzi ye-cyclic. Iya ku-block efanele yaleli windi, lapho amasethingi e-Excel eqondile. Sizosebenzisana ne- "computing parameters" izilungiselelo block, ezitholakala phezulu.

   Ukuvumela ukusetshenziswa kwezinkulumo ze-cyclic, udinga ukufaka umkhaza mayelana ne- "Nika amandla ukubala" ipharamitha. Ngaphezu kwalokho, ebhlokini efanayo, ungahlela inani lomkhawulo we-Iterations nephutha elihlobene. Ngokuzenzakalelayo, amanani abo angu-100 no-0.001, ngokulandelana. Ezimweni eziningi, la mapharamitha awadingi ukushintshwa, yize uma kunesidingo, kungenzeka ukwenza izinguquko ezinkambeni ezibekiwe. Kepha nakhu kubalulekile ukubheka ukuthi ama-Iterations amaningi kakhulu angaholela emthanjeni ongathi sína ohlelweni futhi uhlelo luphelele, ikakhulukazi uma usebenza ngefayela lapho kufakwa khona izinkulumo eziningi ze-cyclic.

   Ngakho-ke, sifaka umkhaza mayelana ne- "Vumela ukubala okuzayo" ipharamitha, khona-ke ukuthi izilungiselelo ezintsha zifakwe zisebenze, chofoza inkinobho ethi "Kulungile", ezansi kwewindows parameters ye-Excel Parameters.



5. Emva kwalokho, ngokuzenzakalelayo siye ephepheni lencwadi yamanje. Njengoba sibona, emangqamuzaneni lapho amafomula ama-cyclic atholakala khona, manje amanani abalwa kahle. Uhlelo aluvimbi ukubala kuwo.

Kepha noma kunjalo kufanelekile ukuthi ukubheka ukuthi ukufakwa kwemisebenzi ye-cyclic akufanele kuhlukunyezwe. Sebenzisa lesi sici kulandela kuphela lapho umsebenzisi eqiniseka ngokuphelele ngesidingo sawo. Ukufakwa okungenangqondo kokusebenza kwe-cyclic akunakuholela ekutholeni umthwalo ngokweqile ohlelweni futhi kunciphise ukubala lapho usebenza nge-decried, kepha umsebenzisi angavuma ngentokozo ebikhombisi, okungenzeka ukuthi kungavinjelwa yilolu hlelo.

Njengoba sibona, kubuningi bamacala amaningi, izethenjwa ze-cyclic ziyinto ethile okudingeka uyilwe nayo. Kulokhu, okokuqala, kufanele ubone ubuhlobo be-cyclical uqobo, bese ubala iseli lapho kutholakala khona iphutha, ekugcineni bakuqede ngokwenza izinguquko ezifanele. Kepha kwezinye izikhathi, imisebenzi yaseCyclic ingaba wusizo lapho kubalwa futhi kusetshenziswa umsebenzisi ngonembeza. Kodwa noma kunjalo, kufanelekile ukusebenzisa ukusetshenziswa kwazo ngokucophelela, ukulungiselela kahle i-Excel futhi ngazi isilinganiso ngokungezwa kwalezo zikholulo, okuthi, lapho isetshenziswa ngokusebenza kohlelo.