Ib qho ntawm feem ntau nthuav nta nyob hauv Microsoft Excel yog Tshawb Fawb. Txawm li cas los xij, nws yuav tsum raug sau tseg tias qhov cuab yeej no tsis tuaj yeem ntaus nqi rau cov neeg nyiam nyob hauv daim ntawv thov no. Thiab nyob rau hauv vain. Tom qab tag nrho, qhov no muaj nuj nqi, siv cov ntaub ntawv tseem cia nrog, los ntawm qhov ntsuas, pom qhov kev kho tshuaj tshaj plaws ntawm tag nrho cov muaj. Cia peb kawm seb yuav siv cov Kev Txuas Txuas hauv Microsoft Excel li cas.
Pab txhawb
Koj tuaj yeem tshawb tau ntev rau ntawm qhov chaw uas muaj Kev Tshawb Fawb nyob rau hauv, tab sis tsis txhob nrhiav qhov cuab yeej no. Tsuas, mus qhib qhov haujlwm no, koj yuav tsum pab kom nws nyob rau hauv qhov chaw zov me nyuam.
Yuav kom qhib qhov kev tshawb xyuas rau hauv Microsoft Excel 2010 thiab tom qab versions, mus rau "Cov Ntaub Ntawv" tab. Rau xyoo 2007, koj yuav tsum nias ntawm Microsoft Office khawm nyob rau sab laug ntawm sab laug ntawm lub qhov rais. Nyob rau hauv lub qhov rais qhib, mus rau seem "Parameters".
Hauv qhov tsis muaj qhov rai, nyem rau ntawm qhov "Add-Ins". Tom qab qhov kev hloov, nyob rau sab qis dua ntawm lub qhov rais, rov qab ntawm "Tswj" parameter, xaiv tus nqi "Excel Add-ins", thiab nias rau ntawm "Go" khawm.
Ib lub qhov rais nrog cov add-ons opens. Muab zuam rau ntawm lub npe ntawm qhov ntxiv-peb xav tau - "Nrhiav kev daws teeb meem." Nias rau ntawm "OK" khawm.
Tom qab ntawd, ib lub pob pib lub Tshawb Nrhiav Kev Ntsuas yuav tshwm nyob rau hauv Excel tab nyob hauv Cov Ntawv Xaiv.
Cov lus npaj
Tam sim no, tom qab peb qhib lub zog, cia saib nws ua haujlwm li cas. Qhov yooj yim tshaj plaws los qhia qhov no yog nrog ib qho piv txwv. Yog li, peb muaj ib lub rooj ntawm cov nyiaj haujlwm ntawm cov neeg ua haujlwm ntawm lub tuam txhab. Peb yuav tsum xam cov nyiaj ntawm txhua tus neeg ua haujlwm, uas yog qhov khoom ntawm cov nyiaj hli uas tau teev nyob hauv ib kem, ntawm ib qho coefficient. Nyob rau tib lub sij hawm, tag nrho cov nyiaj uas tau muab tseg rau tus nqi them yog 30000 rubles. Lub xovtooj ntawm qhov nyiaj no nyob rau hauv lub npe ntawm lub hom phiaj, vim peb lub hom phiaj yog xaiv cov ntaub ntawv rau qhov no.
Cov coefficient uas yog siv los laij cov nqi ntawm tus nqi, peb yuav tsum xam siv cov kev nrhiav Nrhiav kev daws teeb meem. Lub cell nyob rau hauv uas nws yog nyob yog hu ua lub Desired ib.
Lub phiaj thiab lub hom phiaj ntawm lub hlwb yuav tsum txuas nrog lwm tus siv lub mis. Hauv peb cov ntaub ntawv, cov mis no nyob hauv lub hom phiaj ntawm tes, thiab muaj cov nram qab no: "= C10 * $ G $ 3", qhov twg $ G $ 3 yog qhov chaw nyob ntawm lub xovtooj ntawm xav tau, thiab "C10" yog tus nqi ntawm cov nyiaj haujlwm uas tus nqi them cov neeg ua haujlwm ntawm lub tuam txhab.
Tua lub Taw Finder tool
Tom qab ntawm lub rooj npaj, nyob hauv "Cov Ntaub Ntawv" tab, nias qhov "Search for solution" khawm, uas nyob rau ntawm daim qauv xov rau "Kev Ntsuas".
Lub qhov rai tsis pom ntawm qhov uas koj yuav tsum nkag mus rau cov ntaub ntawv. Hauv qhov "Optimize target Function", koj yuav tsum nkag mus rau qhov chaw nyob ntawm lub hom phiaj ntawm tes, qhov twg tag nrho cov nyiaj ntxiv rau tag nrho cov neeg ua hauj lwm yuav nyob. Qhov no yuav ua tau los ntawm kev sau lub koog haujlwm tus kheej, los yog txhaj rau lub pob mus rau sab laug ntawm cov ntaub ntawv nkag teb chaws.
Tom qab ntawd, lub qhov rais tsis muaj qhov me me, thiab koj tuaj yeem xaiv lub xov tooj ntawm cov khoom seem. Tom qab ntawd, nws yuav tsum nias dua rau tib lub khawm rau sab laug ntawm daim ntawv nrog rau cov ntaub ntawv nkag mus thiaj li yuav nthuav cov tsis qhov rai dua.
Nyob rau hauv lub qhov rais nrog qhov chaw nyob ntawm lub hom phiaj ntawm tes, koj yuav tsum teev cov ciaj ciam ntawm qhov tseem ceeb uas yuav nyob hauv. Nws yuav ua tau qhov siab tshaj plaws, yam tsawg kawg, lossis ib qho nqi. Nyob rau hauv peb cov ntaub ntawv, qhov no yog qhov kawg xaiv. Yog li, peb muab qhov kev hloov rau hauv qhov "Values" txoj hauj lwm, thiab nyob hauv thaj chaw mus rau sab laug ntawm peb tau sau tus naj npawb 30,000. Raws li peb nco, nws yog qhov no, raws li cov cai, ua kom tag nrho tus nqi ntawm tag nrho cov neeg ua hauj lwm ntawm lub tuam txhab.
Hauv qab no yog qhov "Hloov Lub Hlis ntawm Cov Qauv". Ntawm no koj yuav tsum qhia txog qhov chaw nyob ntawm lub xov tooj ntawm lub xov tooj, qhov twg, raws li peb nco, nws yog qhov coefficient, los ntawm kev muab cov nyiaj hlis yuav muab xam tus nqi ntawm tus nqi. Qhov chaw nyob tuaj yeem sau rau tib txoj kev raws li peb tau ua rau lub hom phiaj ntawm tes.
Hauv qhov "Ua raws li cov kev txwv" koj tuaj yeem teev qee cov kev txwv rau cov ntaub ntawv, piv txwv, ua rau qhov tseem ceeb tag nrho los yog tsis zoo. Ua li no, nyem rau ntawm "Add" khawm.
Tom qab ntawd, ntxiv qhov kev txwv qhov rais qhib. Nyob hauv thaj chaw "Txuas mus rau cov hlwb" peb tau sau txog qhov chaw nyob ntawm lub hlwb uas hais txog qhov kev txwv no. Nyob rau hauv peb cov ntaub ntawv, qhov no yog lub xov tooj ntawm tes nrog ib coefficient. Tsis tas li ntawd peb tso tseg qhov kos npe tsim nyog: "tsawg dua los yog vaj huam sib luag", "ntau dua los sis sib npaug", "sib npaug", "integer", "binary", etc. Hauv peb cov ntaub ntawv, peb yuav xaiv qhov kos npe ntau dua los sis sib npaug zos sib npaug los ua kom muaj tus zauv zoo. Yog li, peb qhia tus najnpawb 0 ntawm tus "Txiav Txim Siab" Yog tias peb xav tsim ib qho kev txwv, ces nias qhov "Add" button. Hauv cov lus sib tw, nyem rau ntawm "OK" khawm kom txuag tau cov kev txwv.
Raws li koj tuaj yeem pom, tom qab qhov no, qhov txwv tsis pub tuaj yeem tshwm sim ntawm qhov kev txiav txim siab tsis pom qhov rai. Kuj, ua kom tsis txhob muaj qhov txawv txav, koj tuaj yeem teem ib lub zuam tom ntej mus rau qhov ntsuas parameter hauv qab no. Nws yog ntshaw tias tus parameter teev ntawm no tsis yog cov tsis tau hais tias koj tau teev nyob rau hauv kev txwv, txwv tsis pub muaj teeb meem tshwm sim.
Ntxiv chaw tuaj yeem teem caij tau los ntawm tus "Parameters" khawm.
Ntawm no koj tuaj yeem tsim cov lus tseeb ntawm cov kev txwv thiab cov kev txwv ntawm kev daws. Thaum cov ntaub ntawv tsim nyog raug sau, nyem rau ntawm "OK" khawm. Tab sis, rau peb cov ntaub ntawv, nws tsis tas yuav hloov cov kev txwv no.
Tom qab tag nrho cov chaw teev, nyem rau ntawm "Find solution".
Tsis tas li ntawd, cov kev pabcuam Excel hauv lub hlwb ua cov kev suav uas tsim nyog. Ib lub sij hawm nrog cov txiaj ntsig, qhib qhov rais uas koj tuaj yeem txuag tau cov kua los yog muab qhov tseem ceeb hloov los ntawm kev hloov mus rau qhov chaw uas tsim nyog. Tsis hais txog qhov kev xaiv xaiv, los ntawm ticking "Rov qab mus rau qhov tsis sib txuas dialog box", koj tuaj yeem rov mus rau qhov chaw rau kev nrhiav kev daws. Tom qab ticks thiab keyboards raug teem, nyem rau ntawm "OK" khawm.
Yog tias yog vim li cas cov ntsiab lus ntawm kev tshawb nrhiav kev daws teeb meem tsis txaus siab rau koj, los yog thaum lawv suav, qhov kev zov me nyuam muab ib qho yuam kev, ces, hauv qhov no, peb rov qab mus rau hauv lub thawv tsis muaj ntxiv raws li tau piav saum toj no. Peb tab tom xyuas tag nrho cov ntaub ntawv nkag, raws li nws yog ua tau hais tias ib qho yuam kev lawm qhov chaw. Yog hais tias qhov yuam kev tsis pom, ces mus rau qhov ntsuas "Xaiv ib txoj kev daws teeb meem". Ntawm no koj tuaj yeem xaiv ib qho ntawm peb txoj kev xam: "Nrhiav kev daws cov teeb meem tsis yog-linear OPG", "Nrhiav kev daws teeb meem linear los ntawm simplex method", thiab "Evolutionary search for solutions". Yog vim li cas, thawj hom yog siv. Peb sim daws qhov teeb meem, xaiv lwm txoj kev. Yog tias tsis ua hauj lwm, sim rov qab siv hom txheej txheem kawg. Lub algorithm ntawm kev ua haujlwm yog tib yam, uas peb tau piav saum toj no.
Raws li koj tau pom, txoj kev nrhiav kev daws teeb meem yog ib qho uas zoo nkauj tshaj plaws, uas yog siv kom zoo, tuaj yeem txuag tau tus neeg siv sijhawm ntau yam suav. Hmoov tsis, tsis yog txhua tus neeg paub txog nws lub neej, tsis hais txog yuav ua li cas kom paub ua hauj lwm nrog qhov sib ntxiv ntawm no. Nyob rau hauv ib co txoj kev, qhov no twj zoo li lub txiaj ntsim "Kev xaiv kev xaiv ..."tab sis tib lub sijhawm nws muaj kev txawv txav nrog nws.
