Esinye sezici ezithakazelisayo kunazo zonke ku-Microsoft Excel nguSesha isisombululo. Noma kunjalo, kufanele kuqashelwe ukuthi leli thuluzi alikwazi ukubhekwa kubasebenzisi abadume kakhulu kulolu hlelo lokusebenza. Futhi kuyize. Phela, lo msebenzi, usebenzisa idatha yangempela, nge-iteration, uthola isisombululo esihle kunawo wonke sawo wonke. Ake sithole ukuthi singayisebenzisa kanjani isici Solution Finder ku-Microsoft Excel.
Nika amandla isici
Ungasesha isikhathi eside ku-Ribbon lapho kusesha isisombululo khona, kepha ungalokothi uthole leli thuluzi. Kulula, ukuze usebenze lo msebenzi, udinga ukuwunika amandla kuzilungiselelo zohlelo.
Ukuze usebenze usesho lwezixazululo ku-Microsoft Excel 2010 nezinguqulo zamuva, iya kuthebhu ethi "Ifayela". Ngomhla ka-2007, kufanele uchofoze inkinobho ye-Microsoft Office engxenyeni engenhla kwesokunxele kwewindi. Ewindini evulekayo, iya esigabeni se "Parameters".
Ewindini lemingcele, chofoza entweni "Engeza-ukungena". Ngemuva kokuguquka, engxenyeni engezansi yewindi, ngokuphambene nepharamitha "Yokuphatha", khetha inani "I-Excel Add-ins", bese uchofoza inkinobho ethi "Hamba".
Iwindi enezengezo zivula. Beka uphawu ngaphambi kwegama le-add-on esiyidingayo - "Sesesha isixazululo." Chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, inkinobho yokuqala umsebenzi wokusesha izixazululo izovela kuthebhu ye-Excel kuthebhu yedata.
Ukulungiselela ithebula
Manje, ngemva kokuthi sisebenze umsebenzi, ake sibone ukuthi isebenza kanjani. Indlela elula yokuveza lokhu kunesibonelo sokhonkolo. Ngakho-ke, sinetafula leholo labasebenzi bebhizinisi. Kufanele sibone ibhonasi yesisebenzi ngasinye, okuwumkhiqizo wehora okuboniswe kukholomu ehlukile, nge-coefficient ethile. Ngesikhathi esifanayo, inani lemali eyabelwe i-premium yi-rubber 30000. Iseli lapho lesi samba sitholakala khona negama lesikhangiso, ngoba umgomo wethu ukukhetha idatha yile namba ngqo.
I-coefficient esetshenziselwa ukubala inani le-premium, kufanele sibalwe ngokusebenzisa umsebenzi wokusesha izixazululo. Iseli lapho itholakala khona libizwa ngokuthi oyifunayo.
Amaseli ahlosiwe namatheksthi kumele axhumeke komunye nomunye usebenzisa ifomula. Esikhathini sethu esithile, ifomula itholakala esitokisini esilitshe, futhi ifomu elilandelayo: "= C10 * $ G $ 3", lapho i $ $ $ ikheli eliphelele leseli elifunayo, futhi "i-C10" yinani lemali ekhokhwa ngalo i-premium abasebenzi bebhizinisi.
Qalisa ithuluzi leSolution Finder
Ngemuva kokuthi ithebula lilungiselelwe, bese usethe ithebhu ethi "Idatha", chofoza inkinobho ethi "Sesha isisombululo", esitholakala ku-Ribbon ebhokisini le-"Analysis".
Iwindi lemingcele ivuleka lapho udinga ukufaka idatha. Emkhakheni we-"Kulungiselela umsebenzi wesikhangiso", udinga ukungena ikheli leseli elitsheliwe, lapho inani lebhonasi labo bonke abasebenzi lizobe selikhona khona. Lokhu kungenziwa ngokuthayipha izixhumanisi ngesandla, noma ngokuchofoza inkinobho ngakwesokunxele kwenkambu yokungena kwedatha.
Emva kwalokho, ifasitela yemingcele iyancishiswa, futhi ungakhetha iseli elifunayo ithebula. Khona-ke, udinga ukuchofoza futhi ku-inkinobho efanayo ngakwesokunxele kwefomu nedatha efakiwe ukuze ukwandise iwindi lezimingcele futhi.
Ngaphansi kwewindi ngekheli leseli elitsheliwe, udinga ukusetha imingcele yamanani azoba kuwo. Kungaba okuphezulu, ubuncane, noma inani elithile. Esikhathini sethu, lokhu kuzoba yindlela yokugcina. Ngakho-ke, sibeka inkinobho esikhundleni se- "Values", futhi ensimini ngakwesobunxele sinikeza inombolo engu-30,000. Njengoba sikhumbula, yile namba ukuthi, ngokwezimo, yakha inani eliphelele le-premium kubo bonke abasebenzi bebhizinisi.
Ngezansi "i-Shintsha amaseli wezinguquko". Lapha udinga ukucacisa ikheli leseli elifunayo, lapho, njengoba sikhumbula, yi-coefficient, ngokuphindaphinda lapho umholo oyisisekelo uzobalwa khona inani le-premium. Ikheli lingabhalwa ngendlela efanayo ngendlela esenze ngayo esitokisini esilitshe.
Ku "Ngokuhambisana nemikhawulo" insimu ungasetha imingcele ethile yedatha, isibonelo, yenza amanani aphelele noma awanamabi. Ukwenza lokhu, chofoza inkinobho ethi "Engeza".
Emva kwalokho, iwindi lokungeniswa lokufaka livula. Emkhakheni "Xhumanisa amangqamuzana" sidala ikheli lamaseli mayelana nokuthi imingcele iqaliswa kanjani. Esikhathini sethu, lokhu kuyiseli elifunayo nge-coefficient. Ngokuqhubekayo sibeka uphawu oludingekayo: "okuncane noma okulingana", "okukhulu noma okulinganayo", "okulinganayo", "integer", "kanambambili", njll. Esikhathini sethu, sizokhetha uphawu olukhulu noma olulinganayo ukwenza i-coefficient ibe nenombolo enhle. Ngakho-ke, sikhombisa inombolo ye-0 ensimini ethi "Ukuthintela." Uma sifuna ukulungisa umkhawulo owodwa, chofoza inkinobho ethi "Engeza". Ngenkathi ehlukile, chofoza inkinobho ethi "Kulungile" ukuze ulondoloze imikhawulo engenisiwe.
Njengoba ungabona, emva kwalokhu, umkhawulo ubonakala ensimini ehambelana newindi yemingcele yokucinga yokusesha. Futhi, ukuze wenze iziguquko ezingezona okungalungile, ungabeka uphawu ngokulandela ipharamitha ehambelana ngezansi. Kuyinto efiselekayo ukuthi ipharamitha elibekiwe lapha aliphikisana nalabo oye lachaza emingceleni, kungenjalo ingxabano ingavela.
Izilungiselelo ezengeziwe zingasethiwe ngokuchofoza inkinobho ethi "Parameters".
Lapha ungakwazi ukubeka ukunemba kwemingcele nemikhawulo yesisombululo. Uma idatha edingekayo ingenwe, chofoza inkinobho ethi "Kulungile". Kodwa, ngenxa yethu, akudingekile ukushintsha lezi zimingcele.
Emva kwakho konke okulungiselelwe, chofoza inkinobho ethi "Thola isixazululo".
Ngaphezu kwalokho, uhlelo lwe-Excel kumaseli lwenza izibalo ezidingekayo. Ngesikhathi esifanayo nemiphumela, iwindi livuleka lapho ungagcina khona isisombululo esitholiwe noma ubuyisele amanani okuqala ngokuhambisa umshini endaweni efanele. Kungakhathaliseki ukuthi ukhetho olukhethiweyo, ngokufaka uphawu "Buyela ebhokisini lengxoxo yemingcele", ungaphinda uye ezilungiselelweni zokuthola isisombululo. Ngemuva kwemikhakha kanye noshintsho, chofoza inkinobho ethi "Kulungile".
Uma nganoma yisiphi isizathu imiphumela yokusesha izixazululo akukwanelisi, noma uma ibala, uhlelo lunikeza iphutha, ngakho-ke, kulokhu, sibuyela ebhokisini lengxoxo yemingcele, njengoba kuchazwe ngenhla. Sibukeza yonke idatha efakiwe, kungenzeka ukuthi iphutha lenziwa kwenye indawo. Uma iphutha lingatholakali, yiya ku-parameter "Khetha indlela yesisombululo". Lapha ungakhetha enye yezindlela ezintathu zokubala: "Cinga ukuxazulula izinkinga ezingekho emthethweni ngendlela ye-OPG", "Cinga ukuxazulula izinkinga ezilinganiselwe ngendlela ye-simplex", ne-"Search for solutions". Ngokuzenzakalelayo, indlela yokuqala isetshenziswa. Sizama ukuxazulula le nkinga, sikhethe noma iyiphi enye indlela. Uma kwenzeka ukwehluleka, zama futhi usebenzisa indlela yokugcina. I-algorithm yezenzo zifanayo, esizichazile ngenhla.
Njengoba ungabona, umsebenzi wokusesha isisombululo uyithuluzi elithakazelisayo, okuthi, uma lisetshenziswe kahle, lingalondoloza kakhulu isikhathi somsebenzisi ngezibalo ezihlukahlukene. Ngeshwa, akuwona wonke umsebenzisi owaziyo ngokukhona kwawo, ukungasho ukuthi wazi kahle kanjani ukusebenza nalokhu okungenayo. Ngezinye izindlela, leli thuluzi lifana nomsebenzi "Ukukhetha kwepharamitha ..."kodwa ngesikhathi esifanayo kunemibono ephawulekayo nayo.
