Excel inofadza vashandisi vayo nemidziyo yakawanda inobatsira uye mabasa. Imwe yeiyi hapana mubvunzo Kusarudzwa kweparameter. Ichi chishandiso chinokubvumira kuti uwane kukosha kwekutanga zvichienderana nemutengo wekupedzisira waunoronga kugamuchira. Ngationei kuti tingashanda sei nebasa iri muExcel.
gutsikana
Sei basa richidiwa
Sezvataurwa pamusoro apa, basa rebasa Kusarudzwa kweparameter inosanganisira kutsvaga kukosha kwekutanga kubva kwakapihwa mugumisiro wekupedzisira unogona kuwanikwa. Kazhinji, basa iri rakafanana ne Tsvaga Solutions (iwe unogona kuiverenga zvakadzama munyaya yedu -), zvisinei, zviri nyore.
Iwe unogona kushandisa basa racho mune imwechete mafomula, uye kana iwe uchida kuita masvomhu mune mamwe masero, uchafanirwa kuita zviito zvese mazviri zvakare. Zvakare, kushanda kunogumira nehuwandu hwe data iri kugadziriswa - imwechete yekutanga uye yekupedzisira kukosha.
Kushandisa basa
Ngatienderere mberi kune muenzaniso unoshanda unozokupa kunzwisisa kwakanyanya kwemabatiro anoita basa racho.
Saka, tine tafura ine runyorwa rwezvinhu zvemitambo. Isu tinongoziva iyo yakaderedzwa mari (560 rub. panzvimbo yekutanga) nehukuru hwayo, hwakafanana pazvinhu zvese. Iwe unofanirwa kutsvaga mutengo wakazara wezvinhu. Panguva imwecheteyo, zvakakosha kuti muchitokisi, iyo inozoratidza chiyero chekuderedzwa, chimiro chekuverenga kwayo chakanyorwa (munyaya yedu, kuwedzera huwandu hwese nehukuru hwekuderedzwa).
Saka, iyo algorithm yezviito ndeyotevera:
- Enda kune tab "Dhata"umo tinodzvanya bhatani “ko kana” kuongorora muboka rekushandisa "Forecast"…Mukudonhedza pasi, sarudza "Parameter sarudzo" (mune mavhezheni ekutanga, bhatani rinogona kunge riri muboka "Kushanda nedata").
- Iwindo richaonekwa pachiratidziro chekusarudza iyo parameter inoda kuzadzwa mairi:
- mumutengo wemunda “Garai muchitokisi” tinonyora kero ine data rekupedzisira ratinoziva, kureva kuti iyi ndiyo sero ine mari yekuderedzwa. Panzvimbo pekuisa macoordinates nemaoko, unogona kungodzvanya pane yaunoda sero mutafura pachayo. Muchiitiko ichi, chitubu chinofanira kunge chiri mundima inoenderana nekupinda ruzivo.
- Semutengo, tinoratidza huwandu hwemutengo wakaderera, watinoziva - 560 rub.
- Mu "Kuchinja kukosha kwesero" nemaoko kana nekudzvanya negonzo, tsanangura zvinorongeka zvesero (inofanirwa kutora chikamu mune fomula yekuverenga iyo yakaderedzwa mari), umo isu tinoronga kuratidza kukosha kwekutanga.
- dzvanya kana wagadzirira OK.
- Iyo purogiramu ichaita masvomhu uye inoratidza mhedzisiro muhwindo diki rinogona kuvharwa nekudzvanya bhatani. OK. Zvakare, iwo akawanikwa hunhu anozozviratidza otomatiki mumaseru akatsanangurwa etafura.
- Saizvozvo, isu tinokwanisa kuverenga mutengo usingaverengeki wezvimwe zvigadzirwa kana isu tichiziva iyo chaiyo huwandu hwekuderedzwa kune chimwe nechimwe chazvo.
Kugadzirisa Equations Uchishandisa Parameter Sarudzo
Pasinei nokuti iyi haisi iyo nzira huru yekushandisa basa, mune dzimwe nguva, kana zvasvika kune imwe isingazivikanwe, inogona kubatsira mukugadzirisa equations.
Somuenzaniso, tinofanira kugadzirisa equation: 7x+17x-9x=75.
- Isu tinonyora chirevo musero remahara, tichitsiva chiratidzo x kukero yesero ine kukosha kwaunoda kuwana. Nekuda kweizvozvo, iyo formula inoita seizvi:
=7*D2+17*D2-9*D2. - Kubva pinda uye uwane mhedzisiro senhamba 0, zvinova zvine musoro, sezvo tichingofanira kuverenga kukosha kwesero D2, inova “x” mukuenzanisa kwedu.
- Sezvakatsanangurwa muchikamu chekutanga chechinyorwa, mune tab "Dhata" pusha bhatani “ko kana” kuongorora uye sarudza "Parameter sarudzo".
- Muhwindo rinoonekwa, zadza parameters:
- Mumunda kukosha “Garai muchitokisi” ratidza kurongeka kwesero kwatakanyora equation (kureva B4).
- Mukukosha, maererano nekuenzanisa, tinonyora nhamba 75.
- Mu “Kuchinja Kwemasero” tsanangura zvinorongeka zvesero rine kukosha kwaunoda kuwana. Muchiitiko chedu, izvi ndizvo D2.
- Kana zvese zvagadzirwa, tinya OK.
- Sezviri mumuenzaniso wakurukurwa pamusoro apa, kuverenga kuchaitwa uye mugumisiro uchawanikwa, sezvinoratidzwa nehwindo duku.
- Saka, takakwanisa kugadzirisa equation uye kuwana kukosha x, izvo zvakava 5.
mhedziso
Kukodzera ibasa rinogona kukubatsira kuwana nhamba isingazivikanwe mutafura, kana kugadzirisa equation neisingazivikanwe. Chinhu chikuru ndechekuziva hunyanzvi hwekushandisa chishandiso ichi, uye ipapo chinova mubatsiri akakosha panguva yekuita mabasa akasiyana.