Chimodzi mwazinthu zosangalatsa kwambiri mu Microsoft Excel ndi Kufunafuna yankho. Komabe, ziyenera kudziwa kuti chida ichi sichingatchulidwe kuti ndiotchuka kwambiri mwa ogwiritsa ntchito pulogalamuyi. Koma pachabe. Kupatula apo, ntchitoyi, pogwiritsa ntchito gwero, pofufuza, imapeza yankho lolondola kwambiri pazomwe zilipo. Tiyeni tiwone momwe mungagwiritsire ntchito gawo la Get Solution mu Microsoft Excel.
Yambitsani ntchito
Mutha kusaka nthawi yayitali pa tepi pomwe Solution Search ili, koma simungapeze chida ichi. Mwachidule, kuti mutsegule ntchitoyi, muyenera kuyiyika pazosintha pulogalamu.
Kuti muyambitse Kusaka mayankho mu Microsoft Excel 2010, ndipo pambuyo pake, pitani ku "File" tabu. Mwa mtundu wa 2007, dinani batani la Microsoft Office pakona yakumanzere ya zenera. Pazenera lomwe limatsegulira, pitani gawo la "Zosankha".
Muwindo la zosankha, dinani pa "Zowonjezera". Pambuyo pa kusinthaku, m'munsi mwa zenera, moyang'anizana ndi "Management", sankhani phindu "Excel Add-ons" ndikudina "batani la" Go ".
Windo lokhala ndi zowonjezera limatseguka. Timayika chizindikiro pamaso pa dzina la owonjezera omwe tikufuna - "Sakani yankho." Dinani pa "Chabwino" batani.
Pambuyo pake, batani loyambitsa ntchito ya Solution Search liziwoneka pa ribongo la Excel mu tabu ya "Data".
Kukonzekera kwa tebulo
Tsopano, titayambitsa ntchitoyo, tiwone momwe imagwirira ntchito. Izi ndizosavuta kulingalira ndi chitsanzo cha konkriti. Chifukwa chake, tili ndi tebulo la malipiro kwa ogwira ntchito pabizinesiyo. Tikuyenera kuwerengera bonasi ya wogwira ntchito aliyense, yomwe ndi chinthu chomwe amalandila pamlingo wina, wolandila ndala inayake. Nthawi yomweyo, ndalama zonse zomwe zimaperekedwa kwa premium ndi ma ruble 30,000. Selo yomwe ili ndalamayi ili ndi dzina la chandamale, chifukwa cholinga chathu ndikusankha tsatanetsatane wa nambalayi.
Chuma chomwe chimagwiritsidwa ntchito kuwerengera kuchuluka kwa bonasi, tikuyenera kuwerengera pogwiritsa ntchito Kusaka mayankho. Selo yomwe imakhalamo imatchedwa yofunika.
Cholojekiti ndi foni chandamale ziyenera kulumikizana wina ndi mnzake pogwiritsa ntchito fomula. M'malo mwathu, fomulamu ili mgulu lomwe lili ndi chandamale, ndipo ili ndi mawonekedwe awa: "= C10 * $ G $ 3", pomwe $ G $ 3 ndiye kero lenileni la foni yomwe mukufuna, ndipo "C10" ndiyo ndalama yonse yomwe bonasi imawerengeredwa. ogwira ntchito pabizinesi.
Yambitsani Zowunikira Solution
Pambuyo patebulo litakonzedwa, kukhala mu "Data" tabu, dinani batani la "Search for solution", lomwe lili kumbali yake mu "zida za" Analysis ".
Windo la magawo limatsegulidwa, momwe muyenera kulowetsamo deta. Mu gawo "Sinthani cholinga cha ntchito" yomwe mukufuna kuti mulowetse adilesi yomwe mukufuna, momwe bonasi yonse ya onse ogwira ntchito adzakhalire. Izi zitha kuchitika posindikiza ma manejara pamanja, kapena mwa kuwonekera pa batani lomwe lili kumanzere kwa gawo lolowera deta.
Pambuyo pake, zenera la magawo lidzachepetsedwa, ndipo mudzatha kusankha tsamba lomwe mukufuna. Kenako, muyenera dinani batani lomwelo kumanzere kwa fomuyo ndikusunga deta kuti mulimbikitse zenera linanso.
Pansi pazenera ndi adilesi ya chandamale chandamale, muyenera kukhazikitsa magawo azomwe azikhala momwemo. Izi zitha kukhala zochuluka, zochepa, kapena mtengo wake. Kwa ife, iyi ndi njira yomaliza. Chifukwa chake, timayika kusintha kwa "Maadili", ndipo kumanzere kwake ndikulemba nambala ya 30000. Pomwe timakumbukira, nambalayi nambala yomwe ili pansi pazomwe zimapanga ndalama zonse za bonasi kwa onse ogwira ntchito.
Pansipa pali gawo "Kusintha maselo a zosintha". Apa muyenera kutchula adilesi ya foni yomwe mukufuna, komwe, monga momwe timakumbukirira, mgulowo umapezeka ndikuchulukitsa momwe malipiro oyambira adzawerengera kuchuluka kwa bonasi. Adilesiyi ingalembetsedwe monga momwe tidachitira cell yomwe tikujambulira.
Mu gawo la "Malinga ndi zoletsa", mutha kukhazikitsa ziletso zina, mwachitsanzo, muzipanga zowonjezera kukhala zosafunikira kapena zopanda pake. Kuti muchite izi, dinani batani la "Onjezani".
Pambuyo pake, zenera lowonjezera limatsegulidwa. Mu gawo la "Lumikizanani ndi maselo", nenani adilesi ya maselo molumikizana ndi zomwe ziletso zimayambitsidwa. M'malo mwathu, iyi ndi khungu lomwe mukufuna ndi chokwanira. Kenako, tinaika chikwangwani chomwe tikufuna: "chocheperako kapena chofanana ndi", "chachikulu kuposa kapena chofanana ndi", "ofanana", "toter", "binary", ndi zina. M'malo mwathu, tidzasankha chizindikirocho "chokulirapo kapena chofanana ndi" kuti apangitse mgulowo akhale chiwerengero chabwino. Chifukwa chake, mundawo "Constraint" tchulani nambala 0. Ngati tikufuna kukhazikitsa malire ena, dinani batani "Add". Kupanda kutero, dinani batani "Chabwino" kuti musunge zoletsa zomwe zalowetsedwa.
Monga mukuwonera, zitatha izi, kuletsa kumawonekera pagawo lolingana la zenera zofunafuna njira. Komanso, kupanga zosiyanazi kukhala zopanda pake, mutha kuyang'ana bokosilo pafupi ndi gawo lomwe likugwirizana pang'ono. Ndikofunikira kuti gawo lomwe lakhazikitsidwa pano silikutsutsana ndi zomwe mwatchula mu ziletso, apo ayi, mkangano ungabuke.
Zokonda zina zitha kukhazikitsidwa mwa kuwonekera pa batani la "Zosankha".
Apa mutha kukhazikitsa kulondola kwa zovuta komanso malire a yankho. Pamene zofunika zofunika adalowa, dinani batani "Chabwino". Koma, kwa ife, sikofunikira kusintha magawo awa.
Pambuyo pazosanjidwa zonse zakonzedwa, dinani batani "Pezani yankho".
Kenako, pulogalamu ya Excel m'maselo imachita kuwerengera kofunikira. Nthawi yomweyo ndi kutulutsa kwa zotsatira, zenera limatseguka momwe mungasungire yankho lomwe mwapeza kapena kubwezeretsa zomwe zinali zoyambirira posunthira pamalo oyenera. Ngakhale mutasankha bwanji, ndikayang'ana pa bokosi la "Return to the sets dialog", mutha kupitanso pazosaka zosankha. Pambuyo poyang'ana mabokosi ndi masinthidwe, dinani batani "Chabwino".
Ngati pazifukwa zina zotsatira zakusaka mayankho sizikukukhutiritsani, kapena pulogalamuyo ikupereka vuto mukawerengera, ndiye, pankhaniyi, tikubwerera, monga tafotokozera pamwambapa, ku bokosi la zokambirana. Tikuyang'ana zonse zomwe zidalowetsedwa, chifukwa zinali zotheka kuti cholakwika chidapangidwa kwina. Ngati cholakwika sichinapezeke, pitani pa "Sankhani njira yankho". Apa mutha kusankha imodzi mwanjira zitatu zowerengera: "Fufuzani mayankho pamavuto osatengera ndi njira ya OPG", "Fufuzani mayankho a mavuto omwe akuchitika ndi njira yosavuta", ndi "Kusintha kwa mayankho". Mwachisawawa, njira yoyamba imagwiritsidwa ntchito. Tikuyesera kuthetsa vutoli posankha njira ina iliyonse. Ngati zalephera, yesaninso pogwiritsa ntchito njira yomaliza. Momwe machitidwe a algorithm akadali ofanana monga tafotokozera pamwambapa.
Monga mukuwonera, ntchito ya Solution Search ndi chida chosangalatsa, chomwe, ngati chikugwiritsidwa ntchito molondola, chimatha kupulumutsa nthawi ya wogwiritsa ntchito masamu osiyanasiyana. Tsoka ilo, sikuti wogwiritsa ntchito aliyense amadziwa za kupezeka kwake, osatchula momwe angagwirire bwino ntchito ndi pulogalamu yowonjezera iyi. Njira iyi, chida ichi chikufanana ndi ntchito "Kusankhidwa kwamalire ...", koma nthawi yomweyo, ali ndi kusiyana kwakukulu ndi izi.
