Qhov wikiHow no qhia koj siv Microsoft Excel's Solver tool, uas tso cai rau koj hloov pauv qhov sib txawv hauv daim ntawv nthuav tawm kom ua tiav cov kev xav tau. Koj tuaj yeem siv Solver ob qho tib si Windows thiab Mac versions ntawm Excel, txawm hais tias koj yuav tau pab Solver ua ntej koj tuaj yeem pib siv nws.
Cov kauj ruam
Ntu 1 ntawm 2: Pab kom Solver
Kauj Ruam 1. Qhib Excel
Nyem lossis ob npaug nyem rau Excel lub cim app, uas zoo ib yam li lub thawv ntsuab nrog dawb "X" rau nws.
Solver los ua ntej teeb tsa nrog ob lub Windows thiab Mac versions ntawm Excel, tab sis koj yuav tsum tau ua kom nws ua haujlwm
Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug
Qhov no yuav qhib lub qhov rai Excel, los ntawm qhov uas koj tuaj yeem txuas ntxiv nrog ua kom Solver.
Yog tias koj muaj cov ntawv Excel uas twb muaj lawm koj xav siv Solver nrog, koj tuaj yeem qhib nws tsis txhob tsim cov ntawv tshiab
Kauj Ruam 3. Nyem Cov Ntaub Ntawv
Nws yog tab nyob rau sab saud sab laug ntawm lub qhov rais Excel.
Ntawm Mac, nyem Cov cuab yeej es tsis txhob, ces hla cov kauj ruam tom ntej.
Kauj Ruam 4. Nyem Xaiv
Koj yuav pom qhov kev xaiv no hauv qab ntawm Cov ntaub ntawv ntawv qhia zaub mov Ua li ntawd coj los rau Qhov Xaiv Qhov rai.
Kauj Ruam 5. Nyem Ntxiv-ins
Nws yog ib lub tab nyob rau sab qis-sab laug ntawm Options window.
Ntawm Mac, nyem Ntxiv Excel ntxiv hauv Cov cuab yeej ntawv qhia zaub mov
Kauj Ruam 6. Qhib qhov "Add-ins Available" window
Nco ntsoov tias lub thawv "Tswj" muaj "Excel Add-ins" teev nyob hauv nws, tom qab ntawd nyem Mus hauv qab ntawm nplooj ntawv.
Ntawm Mac, lub qhov rai no yuav qhib tom qab txhaj Ntxiv Excel ntxiv hauv Cov cuab yeej ntawv qhia zaub mov
Kauj Ruam 7. Nruab qhov Solver add-in
Khij lub npov "Solver" nyob rau nruab nrab ntawm nplooj ntawv, tom qab ntawd nyem OK. Tam sim no Solver yuav tsum tshwm sim ua cov cuab yeej hauv Cov ntaub ntawv tab uas nyob saum Excel.
Ntu 2 ntawm 2: Siv Solver
Kauj Ruam 1. Nkag siab txog Solver txoj kev siv
Solver tuaj yeem txheeb xyuas koj cov ntaub ntawv cov ntaub ntawv thiab ib qho kev txwv koj tau ntxiv los qhia koj cov kev daws teeb meem. Qhov no muaj txiaj ntsig yog tias koj ua haujlwm nrog ntau qhov sib txawv.
Kauj Ruam 2. Ntxiv koj cov ntaub ntawv rau hauv koj daim ntawv teev npe
Txhawm rau siv Solver, koj daim ntawv nthuav tawm yuav tsum muaj cov ntaub ntawv nrog cov sib txawv sib txawv thiab kev daws teeb meem.
- Piv txwv li, koj tuaj yeem tsim daim ntawv nthuav qhia koj cov nuj nqis ntau yam nyob hauv ib hlis nrog cov xov tooj ntawm tes uas ua rau koj cov nyiaj tshuav.
- Koj tsis tuaj yeem siv cov neeg daws teeb meem ntawm daim ntawv nthuav qhia uas tsis muaj cov ntaub ntawv daws tau (piv txwv li, koj cov ntaub ntawv yuav tsum muaj qhov sib npaug).
Kauj Ruam 3. Nyem rau Cov Ntaub Ntawv tab
Nws nyob rau sab saum toj ntawm Excel qhov rai. Qhov no yuav qhib qhov Cov ntaub ntawv toolbar.
Kauj Ruam 4. Nyem Solver
Koj yuav pom qhov kev xaiv no nyob rau sab xis-sab xis ntawm Cov ntaub ntawv toolbar. Ua li ntawd qhib qhov Solver window.
Kauj Ruam 5. Xaiv koj lub hom phiaj ntawm tes
Nyem rau ntawm tes uas koj xav tso saib koj cov Solver daws. Qhov no yuav ntxiv nws rau hauv "Set Objective" box.
Piv txwv li, yog tias koj tab tom tsim pob peev nyiaj qhov twg lub hom phiaj kawg yog koj li nyiaj tau los txhua lub hlis, koj yuav nyem qhov kawg "Cov Nyiaj Tau Los" ntawm tes
Kauj Ruam 6. Teem lub hom phiaj
Khij lub npov "Tus Nqi Ntawm", tom qab ntawd ntaus koj lub hom phiaj tus nqi rau hauv lub npov ntawv tom ntej ntawm "Tus Nqi Ntawm".
- Piv txwv, yog tias koj lub hom phiaj yog kom muaj $ 200 thaum kawg ntawm lub hlis, koj yuav ntaus 200 rau hauv lub thawv ntawv.
- Koj tseem tuaj yeem txheeb xyuas lub thawv "Max" lossis "Min" txhawm rau kom Solver txiav txim siab qhov siab tshaj plaws lossis tus nqi qis kawg nkaus.
- Thaum koj tau teeb tsa lub hom phiaj, Solver yuav sim ua kom tau raws li lub hom phiaj ntawd los ntawm kev kho lwm qhov hloov pauv hauv koj daim ntawv nthuav tawm.
Kauj Ruam 7. Ntxiv qhov txwv
Cov kev txwv teeb tsa kev txwv ntawm qhov muaj txiaj ntsig uas Solver tuaj yeem siv tau, uas tiv thaiv Solver los ntawm kev ua yuam kev nullifying ib lossis ntau ntawm koj daim ntawv teev npe qhov txiaj ntsig. Koj tuaj yeem ntxiv qhov txwv los ntawm kev ua cov hauv qab no:
- Nyem Ntxiv
- Nyem rau ntawm tes (lossis xaiv cov cell) uas qhov kev txwv siv.
- Xaiv ib hom kev txwv los ntawm cov ntawv qhia zaub mov nruab nrab.
- Nkag mus rau tus lej txwv (piv txwv li, qhov siab tshaj lossis yam tsawg kawg nkaus).
- Nyem OK
Kauj Ruam 8. Khiav Solver
Thaum koj tau ntxiv tag nrho koj cov kev txwv, nyem Daws hauv qab ntawm Solver qhov rai. Qhov no yuav ua rau Solver nrhiav qhov kev daws teeb meem zoo tshaj plaws rau koj qhov teeb meem.
Kauj Ruam 9. Txheeb xyuas qhov tshwm sim
Thaum Solver ceeb toom rau koj tias nws muaj lus teb, koj tuaj yeem pom cov lus teb los ntawm kev saib ntawm koj daim ntawv nthuav tawm kom pom qhov kev hloov pauv twg.
Kauj Ruam 10. Hloov koj li txheej txheem Solver
Yog tias qhov txiaj ntsig uas koj tau txais tsis zoo rau koj daim ntawv teev npe, nyem Ncua tseg hauv lub qhov rai pop-up, tom qab ntawd kho koj lub hom phiaj thiab txwv.
