Chimodzi mwa zochititsa chidwi kwambiri mu Microsoft Excel ndi kufufuza yankho. Komabe, ziyenera kudziwika kuti chida ichi sichingakhoze kutchulidwa ndi ogwiritsa ntchito kwambiri pakati pa ogwiritsa ntchito pulojekitiyi. Ndipo pachabe. Pambuyo pake, ntchitoyi, pogwiritsira ntchito deta yapachiyambi, ndi iteration, imapeza njira yabwino kwambiri ya zonse zomwe zilipo. Tiyeni tione momwe tingagwiritsire ntchito gawo la Solution Finder ku Microsoft Excel.
Thandizani mbali
Mukhoza kufufuza nthawi yayitali pa kaboni komwe kufunafuna yankho kuli, koma musapeze chida ichi. Mwachidule, kuti mutsegule ntchitoyi, muyenera kuigwiritsa ntchito pakusintha kwa pulogalamu.
Kuti muyambe kufufuza njira zothetsera machitidwe mu Microsoft Excel 2010 ndi matembenuzidwe amtsogolo, pitani ku "Fayilo" tab. Kwa ma 2007, muyenera kudinkhani pa batumiki a Microsoft Office kumbali yakumanzere yawindo. Pawindo lomwe limatsegulira, pitani ku gawo la "Parameters".
Muwindo la magawo, dinani pa chinthu "Add-ins". Pambuyo pa kusintha, pansi pazenera, kutsutsana ndi "Management" parameter, sankhani mtengo "Excel Add", ndipo dinani pa "Pitani" batani.
Fenera ndi zowonjezera zimatsegulidwa. Lembani kutsogolo kwa dzina lawonjezeredwa lomwe tikusowa - "Fufuzani yankho." Dinani pa batani "OK".
Pambuyo pake, batani kuyambitsa Search for Solutions ntchito idzawonekera pa Excel tab mu tabu ya Deta.
Kukonzekera kwa tebulo
Tsopano, titatsegula ntchitoyi, tiyeni tiwone momwe ikugwirira ntchito. Njira yosavuta yowonetsera izi ndi chitsanzo cha konkire. Kotero, ife tiri ndi tebulo la malipiro a antchito a malonda. Tiyenera kuwerengetsa bonasi ya wogwira ntchito aliyense, zomwe zimapangidwa kuchokera ku malipiro omwe amasonyezedwa pamtundu umodzi, ndi coefficient. Pa nthawi yomweyi, ndalama zonse zomwe zimaperekedwa kuti muyambe kupereka ndalamazo ndi 30000 ruble. Selo yomwe ndalamayi ilipo ili ndi dzina lalangizidwe, popeza cholinga chathu ndi kusankha deta yeniyeniyi.
Coefficient yomwe imagwiritsidwa ntchito kuwerengera kuchuluka kwake, tikuyenera kuwerengera pogwiritsira ntchito ntchito Funani njira. Selo limene limapezeka limatchedwa lofunikanso.
Selo lolunjika ndi zolingalira liyenera kulumikizana wina ndi mzake pogwiritsa ntchito njira. Momwe ife timakhalira, mndandandawu uli pamaselo omwe akugwiritsidwa ntchito, ndipo ili ndi mawonekedwe otsatirawa: "= C10 * $ G $ 3", pomwe $ G $ 3 ndi malo enieni a selo lofunidwa, ndipo "C10" ndi ndalama zonse zomwe malipirowo amawerengedwa antchito a malonda.
Yambitsani chida cha Solution Finder
Pambuyo pokonza tebulo, pokhala mu tabu ya "Deta", dinani pa "Sakani njira yothetsera", yomwe ili pa thaboni mu bokosi la zida "Analysis".
Fenera la magawo akuyamba momwe muyenera kulemba deta. Mu "Gwiritsani ntchito ndondomeko yowunikira" munda, lowetsani adiresi ya selo yeniyeni, komwe bonasi ya ndalama zonse kwa ogwira ntchito onse idzapezeka. Izi zikhoza kuchitidwa mwina polemba zolembazo pamanja, kapena podindira pa batani kumanzere kwa gawo lolowera deta.
Pambuyo pake, mawindo a magawowa amachepetsedwa, ndipo mungasankhe selo lopatsidwa. Ndiye, muyenera kudinanso kachiwiri pabokosi lomwelo kumanzere kwa mawonekedwewo ndi deta yomwe mwalembedwera kuti muonjezere mawindo azitsulo kachiwiri.
Pansi pazenera ndi adiresi ya selo lolunjika, muyenera kukhazikitsa magawo a makhalidwe omwe adzakhale mmenemo. Ikhoza kukhala yaikulu, yochepa, kapena mtengo wapadera. Kwa ife, iyi idzakhala njira yotsiriza. Kotero, ife timayika kusintha mu malo a "Makhalidwe", ndipo kumunda kumanzere kwake timapereka chiwerengero cha 30,000. Monga tikukumbukira, iyi ndi nambala yomwe, malinga ndi zikhalidwe, zimapanga kuchuluka kwa ndalama zonse kwa ogwira ntchito onse a malonda.
M'munsimu pali "Masinthani a masinthidwe". Pano mukuyenera kufotokoza adiresi ya selo yomwe mukufuna, kumene, monga tikukumbukira, ndi coefficient, pakuwonjezeka ndi zomwe malipiro oyamba adzawerengera kuchuluka kwake. Adilesi ingalembedwe mofanana ndi momwe tachitira pa selo lolunjika.
Mu "Mogwirizana ndi zoletsedwa" munda mukhoza kukhazikitsa malamulo ena pa deta, mwachitsanzo, pangani malamulowo kukhala abwino kapena osakhudzidwa. Kuti muchite izi, dinani pa "Add" batani.
Pambuyo pake, zenera likutsegula. Kumunda "Link ku maselo" timapereka adiresi ya maselo omwe amalembedwa. Kwa ife, ili ndilololo lofunidwa ndi coefficient. Kuwonjezera apo timayika chizindikiro chofunika: "chochepa kapena chofanana", "chachikulu kapena chofanana", "chofanana", "integer", "binary", ndi zina zotero. Kwa ife, tidzasankha chizindikiro chachikulu kapena chofanana kuti coefficient chiwerengero chabwino. Potero, timasonyeza nambala 0 mu "Chiletso". Ngati tikufuna kukonza chimodzi choletsedwa, ndiye dinani pa "Add". Pazifukwa zina, dinani pa batani "OK" kuti muzisunga zoletsedwa.
Monga momwe mukuonera, patatha izi, choletsedwa chikuwonekera pazenera zawindo lazomwe mukufuna kufufuza. Ndiponso, kuti mupange zinthu zosakhala zolakwika, mukhoza kuika nkhuku pafupi ndi parameter yomwe ili pansipa. Ndikofunika kuti choyimira chomwe chili pano sichikutsutsana ndi zomwe mwazifotokoza muzoletsedwa, mwinamwake kusagwirizana kungabwere.
Zowonjezera zosinthika zingathe kukhazikitsidwa ponyani pa batani "Parameters".
Pano mungathe kukhazikitsa zolondola ndi malire a yankho. Pamene ma data oyenera atalowa, dinani "Kulungama". Koma, chifukwa cha ife, sikofunikira kusintha izi magawo.
Pambuyo pokonza zonsezi, dinani pa "Sakani njira".
Komanso, pulogalamu ya Excel m'maselo amachita zowerengera zofunika. Pomwepo ndi zotsatira, mawindo amatsegulira momwe mungathe kupulumutsira njira yothetsera kapena kubwezeretsanso zoyambirirazo poyendetsa makinawo ku malo oyenera. Mosasamala kanthu mwa kusankha kosankhidwa, mwa kuyika "Kubwereranso ku bokosi la mawokosi", mukhoza kupitanso ku machitidwe kuti mupeze yankho. Pambuyo pa nkhupakupa ndi masinthidwe atsekedwa, dinani pakani "OK".
Ngati pazifukwa zilizonse zotsatira za kufufuza njira sizikusangalatseni, kapena zikawerengedwa, pulogalamuyi imapereka cholakwika, ndiye, pakadali pano, tibwerera mu bokosi lazamasamba monga momwe tafotokozera pamwambapa. Tikuyang'anitsitsa deta yonse yowaloledwa, ngati n'zotheka kuti pangakhale vuto linalake. Ngati cholakwikacho sichinapezeke, pitani ku parameter "Sankhani njira yothetsera". Pano mungasankhe njira imodzi yowerengera: "Fufuzani kuthetsa mavuto osagwirizana ndi njira ya OPG", "Fufuzani kuthetsa mavuto ovuta pogwiritsa ntchito njira yosavuta", ndi "Kusintha kwa njira zothetsera mavuto". Mwachinsinsi, njira yoyamba imagwiritsidwa ntchito. Timayesetsa kuthetsa vutoli, posankha njira ina iliyonse. Ngati mukulephera, yesetsani kugwiritsa ntchito njira yotsiriza. Chizoloŵezi cha zochita ndi chimodzimodzi, chomwe tachifotokozera pamwambapa.
Monga momwe mukuonera, kufufuza njira yothetsera ntchito ndi chida chokondweretsa, chomwe ngati chigwiritsidwe bwino, chingasunge nthawi yowonjezera pazosiyana zosiyanasiyana. Mwamwayi, osati wosuta aliyense amadziwa za kukhalapo kwake, osatchula momwe angadziwire bwino momwe angagwiritsire ntchito ndi izi. Mwa njira zina, chida ichi chikufanana ndi ntchito "Kusankhidwa kwapakati ..."koma panthawi imodzimodziyo ali ndi kusiyana kwakukulu ndi izo.
