Iyini i-Solver ku-Excel nokuthi isetshenziswa kanjani

Isixazululo

Uma usebenzisa Excel ngokujwayela okuthile, kungenzeka ukuthi uke waphendukela kukho Isixazululo, isengezo kuhlelo lwesipredishithi se-Microsoft Office esingenza ngaso izibalo ukuze sithole imiphumela ngendlela ehlukile necwengisiswe kakhulu. Kulokhu okuthunyelwe sizobona kahle ukuthi ingeyani nokuthi isebenza kanjani.

I-Solver, nge-Spanish okusho ukuthi "umxazululi" igama elisetshenziswa emkhakheni wekhompiyutha ukubhekisela kumathuluzi noma izinsimbi ezifakwe ohlelweni olunjongo yalo enkulu kuwu ukuxazulula inkinga yezibalo. 

Ngakho-ke, i-Excel Solver iyithuluzi lokubala elingase libe usizo ikakhulukazi ezimweni ezithile, insiza ebaluleke kakhulu lapho uhlela umsebenzi emkhakheni wezokuthutha noma wezinhlelo zokukhiqiza. Umsebenzi wayo oyinhloko ukunquma inani eliphezulu noma eliphansi leseli ngokushintsha amanani amanye amaseli, ukuthola izinjongo ezithuthukisiwe zamamodeli alayini nangawona mugqa. Sizoyichaza kabanzi ngezansi:

Amaseli aguquguqukayo namaseli aqondiwe

Ukuze uqonde ukuthi i-Solver isebenza kanjani nokuthi ingaba usizo kanjani kithi, kuyadingeka ukuthi siqale sichaze imiqondo emibili eyisisekelo: amaseli aguquguqukayo namaseli okuqondiwe kuwo.*

Isisekelo sendlela i-Solver esebenza ngayo ilele ku- amaseli aguquguqukayo, abizwa nangokuthi amaseli aguquguqukayo wesinqumo. Lawa maseli asetshenziselwa ukubala amafomula lapho amaseli okuqondiwe, eyaziwa nangokuthi "isithiyo". Okwenziwa yi-Solver ukulungisa amanani amaseli aguquguqukayo ukuze athobelane nemikhawulo ebekwe amaseli okucindezela, ngaleyo ndlela athole umphumela oyifunayo kuseli eliqondiwe.

(*) Igama elisetshenziswe ezinguqulweni ze-Solver ngaphambi kwe-Excel 2007 lalihlukile: amaseli aguquguqukayo ayebizwa ngokuthi "amaseli ashintshayo" noma "amaseli alungisekayo", kuyilapho iseli eliqondiwe lalibizwa ngokuthi "iseli eliqondiwe".

Indlela yokusebenzisa i-Solver: isibonelo sohlelo lokusebenza

Konke lokhu kungase kuzwakale kuyinkimbinkimbi, nokho, kuqondwa kangcono ngesibonelo. Lokhu kuzosisiza sibone ukuthi lesi sengezo se-Excel singaba usizo kangakanani:

xazulula ku-excel

Sicabanga ukuthi inkampani ekhiqizayo ineshidi le-Excel elinamakholomu amathathu, ngalinye lihambisana nomunye wemikhiqizo ekhiqizayo: A, B kanye no-C.

Ukuze wenze ngayinye yazo udinga inani elithile lezinhlobo ezintathu ezihlukene zezinto zokusetshenziswa, ezikhonjiswe emigqeni X, Y kanye no-Z. Ake sithi ukuze ukhiqize iyunithi eyodwa ka-A udinga iyunithi eyodwa yezinto ezibonakalayo X, ezimbili zika-Y kanye nezintathu kusuka. Z. Ukuze kukhiqizwe u-B no-C, ezinye izinhlanganisela zamanani nezinto ezingavuthiwe ziyadingeka.

Sengeza ikholomu entsha (asiyibize ngokuthi D) efaka ohlwini inani eliphakeme elitholakalayo laleyo naleyo mpahla. Siphinde sabeka umugqa omusha, ngezansi, lapho inzuzo ekhiqizwa iyunithi ngayinye yomkhiqizo odayisiwe inemininingwane eminingi. Kulula.

Ngayo yonke imininingwane esetafuleni, umbuzo esizibuza wona yilo olandelayo: Ungayithola kanjani inhlanganisela efanele yemikhiqizo ezokhiqizwa kucatshangelwa inani elilinganiselwe lezinto zokusetshenziswa? Nansi indlela okufanele siqhubeke ngayo:

  1. Okokuqala, siya kubha yamathuluzi futhi sifinyelele Isixazululo (kusukela Idatha, amaqembu Analysis).
  2. Bese sikhetha ifayela iseli eliqondiwe (H8) futhi, kuphaneli, sikhetha inketho «Ubukhulu» nasebhokisini Ukushintsha amaseli aguquguqukayo sibhala kithi, C10:E10.
  3. Sengeza imikhawulo ngokucindezela inkinobho "Faka"e ireferensi yeseli H5:H7, okungukuthi, ububanzi beseli ofuna ukukhawulela inani lalo; futhi ku Imikhawulo F5:F7.
  4. Ekugcineni, sicindezela inkinobho "Xazulula" ukuze imiphumela ivele kumaseli omugqa 10.

Lesi esisiphakamisile siyisibonelo esilula. Icala elethulwa ukukhombisa ukubaluleka nokusebenza kwaleli thuluzi. Empeleni, nge-Solver ungenza imisebenzi eyinkimbinkimbi kakhulu. Kungakho kuthakazelisa kakhulu ezinkampanini nakochwepheshe abaphatha amanani amakhulu edatha.

Ama-algorithms asetshenziswa iSolver

I-Solver isebenza ngama-algorithms amathathu ahlukene noma izindlela zokuxazulula, umsebenzisi angazikhetha ngebhokisi lengxoxo. Solver Amapharamitha. Zimi kanje:

  • I-LP Simplex, ukuxazulula izinkinga zomugqa.
  • Ukuziphendukela kwemvelo, ukuxazulula izinkinga ezingalungisiwe.
  • I-Generalized Reduced Gradient (GRG) Nonlinear, ekhonjiswe ukuxazulula izinkinga ezingaqondile ezibushelelezi.

Ungakhetha indlela eyodwa noma enye kokuthi Izinketho ebhokisini lengxoxo Solver nemingcele. Kamuva, kuyenzeka ulondoloze imiphumela ehlukene etholwe nge-Solver kumaspredishithi ahlukene. Ngayinye yazo ingaqukatha ukukhetha kwayo kweSolver, okuzoboniswana nayo kamuva. Kungenzeka futhi, ngisho nokutuswa, ukuchaza inkinga engaphezu kweyodwa kusipredishithi usebenzisa izinketho zokuthi Layisha/Londoloza futhi ngaleyo ndlela ulondoloze izinkinga ngazinye.


Yiba ngowokuqala ukuphawula

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.