Excel 2007. Kuwana mhinduro muna Excel 2007

Solver muna Excel 2007 haisi kutevedzerwa. It rakagadzirirwa Masvomhu yakaoma, kana pane zvinopfuura chimwe USINGAZIKAMWI. Saka, hazvina vanobatanidzwa senguva siyana chirongwa nzira. Asi kana uchida izvozvo, ipapo anokwanisa kupa inodzidzisa vakarongeka kushanda uye yakakwirira yauinayo.

Chii kutsvaka dambudziko?

Kuwana mhinduro muna Excel 2007 ane chirongwa kuwedzera munyika. Izvi zvinoreva kuti riri mumufananidzo configuration, zvinoberekwa mugadziri, pasuru iyi haisi iiswe. Inofanira akatakura uye configured yoga. Chokwadi ndechokuti vanoshandisa vakawanda pasina izvozvo. Uyewo kuwedzera-mberi anowanzonzi "Solver", sezvo anokwanisa kuramba yakarurama uye anokurumidza Masvomhu, kazhinji zvisinei yakaoma sei basa chinopiwa kwaari.

Kana shanduro Microsoft Office ndiye yepakutanga, ipapo nezvinetso chokugadza hazvizoitiki. The mushandisi anofanira kuti akawanda kuchinja:

Settings → Tools → Wedzerai-Ons → Management → Wedzerai-dzi Excel.

Izvi anozarura hwindo umo kusvetuka bhatani. Pashure nekudzvanya pamusoro payo ichava kuratidza mazita ose yaida wedzera-Ons yakaiswa, uye tsva. Zvino unofanira kuwana kutsvaka zvinogadzirisa, akabva aisa maki. The turusi iri kusashanda, unogona kurishandisa chero nguva.

Sei ndichida solver?

Chii unogona kutsvaga zvingaitwa muna Excel 2007, uye kana zvakakodzera kuisa nayo? Kana mushandisi aripo chinangwa basa, izvo anoenderana parameters anoverengeka, superstructure Achasarudza dambudziko zvinogadzirisa achitevedza chepakuvamba mashoko. Pakati izvi zvingava shanduka kana kuzivikanwa, yakadai yokupedzisira ukoshi. Kureva, inodzidzisa vanogona kutanga unhu uye mhinduro, uye Software achasarudza nzira zvinogadzirisa, anopa nzira.

Saka, maererano superstructure anogona kuwanikwa:

• Anobudirira kuparadzirwa kushanda zvinhu, kuti awane kunonyanyisa purofiti kubva mabasa kambani kana munhu wedhipatimendi, bazi.
• Kuparadzira oupfumi pamwe kushoma nengozi.
• Zvinetso, apo pane zvinopfuura chimwe asingazivikanwi (zvatichapa mhinduro zvinobvira wandei, iyo inodzidzisa pachake Achasarudza zvikuru rakakodzera).
• Kuchengetedza vachizvitakudza mhinduro womuenzaniso. The yakanakisisa kuita vashandi vari kumanikidzwa kuti kuramba kushandura kombiyuta kana tablet.
• Kugadzirisa Zvinetso dzakati siyana variables, unknowns, Masvomhu uye integrals.

Chirongwa iguru mukana, asi zvinokosha kuti udzidze kuishandisa zvakanaka.

Sei solver?

Kuwedzera solver muna Excel ane basa sezvo kusarudzwa parameter. Zvinokurudzirwa kushandisa muzviitiko apo pane chimwe chete kuzivikanwa ukoshi. Ichi chiri chirongwa kunoda ndoda kombiyuta zvekuvaka mari, saka akapa mugumisiro nokukurumidza.

Kuwana mhinduro muna Excel 2007 rinoshandiswa nokuda kwazvo mabasa, apo pane variables wandei vasingazivikanwi zvinowanzoitika. Ari mukuru mashoko inogona muchidimbu sezvinotevera:

1. Kuwana vasingazivikanwi → «X».
2. Akapa → payakavakirwa kana kushanda.
3. → Kana Kazhinji mitemo zvinoratidzwa kusaruramisira, kana zvishoma / kunonyanyisa tsika.

Unofanirawo kuratidza sero dzakasvikwa kukarukureta yaifanira. Pane mukana kugadzirisa mabasa akasiyana siyana, kana iwe kuisa program ukama pazviruva.

Setting mikana inoitwa

Kuwana mhinduro mashandiro ari Excel 2007 aishanda inodzidzisa zvinodiwa, unofanira kupinda kwakarurama pazviruva. vari kazhinji chete 1-3 waivako, asi yakawanda mabasa akaoma anoda pose pazvinoita.

Search nzira muna Office Excel 2007 Software mhinduro inogona sezvinotevera:

• Kunonyanyisa nguva - uwandu mumasekonzi kuti rokushandisa anosarudza chirongwa chisarudzo. It zvinoenderana kunzwisisa dambudziko.
• The kunonyanyisa uwandu integrations. Ndiwo uwandu unotii, iyo inoita purogiramu nzira kugadzirisa dambudziko. Kana zvikava kuti mhinduro haagamuchirwi.
• Kururama kana zvakarurama, chinonyanya inowanzoshandiswa mhinduro pamusoro decimals (semuenzaniso, 0.0001).
• Kubvumidza. Kushandiswa kana kushanda muzana.
• Non-akaipa tsika. Richishandiswa kana basa kunokwanisika nemhinduro yakarurama maviri (semuenzaniso, +/- X).
• Achiratidza Pamusana kusangana. marongero ichi rinoti kana mugumisiro kunokosha kwete chete dambudziko asi nzira dzavo.
• Search Method - kusarudzwa Optimization algorithm. "Newton kuti nzira" inowanzoshandiswa.

Kamwe zvose pazviruva vanosarudzwa, iva nechokwadi kuti tinya kuponesa bhatani.

Basa parameters ari kutsvaka basa rokugadzirisa

Kushanda superstructure akadai mhinduro kutsvaka muna Excel, akaita maererano chaiyo kukarukureta. Anokosha aya ndiwo nzira. Pane dzakasiyana vaviri. "Newton kuti nzira" ndiyo default ezvinhu. Anokwanisa kushanda zvikuru ndangariro, asi zvishoma kusangana. Saka, zviri zvikuru akakodzera mureza uye kwete zvakaoma chaizvo equations.

"Conjugate Gradient Method" sezvo iri. Pano tinokumbira zvishoma ndangariro, asi kunoda zvakawanda kusangana. Naizvozvo, kana imi kuishandisa unogona kugadzirisa yakaomesesa equations kushandisa pamwero mukuru Masvomhu uye mabasa.

The fomura muna Excel

Pane mutemo unoti Kufananidzira, pasina iro haikwanise kushanda Solver kuwedzera-mu mu Excel 2007 chirongwa - fomura. Dzinomirira mashoko anoita chimwe kukarukureta. Pasina kuenzana hapana nzira. Saka, purogiramu hakutangi kucherechedza vakadaro, kana pasina runoenzanirana chiratidzo.

The yemaitiro zvingasanganisira zvinotevera:

1. Basa. Uyu mwero inonyatsoita, apo pane chaicho uye yakananga nezvaaiita, usingagoni kuchinjwa.
2. Link. Inoratidza uwandu masero kuti zvinoda kugadziriswa. Panyaya iyi, masero dzinogona kurongwa randomly kana kuti.
3. Operator. Rinofananidzira iyo rinoti iri mhando kukarukureta (+ - Uyezve, * - chokuwanziridza, etc.).
4. Constant. Constant ukoshi kuti haambochinji. Uyewo, kuti vawane hazvina zvakakodzera kuita Masvomhu.

Solution zvokuimba kubva kuruboshwe kuenda kurudyi kana zvose akarongeka mitemo.

Kutanga fomura

Masvomhu vari equations kuti pave Implementation purogiramu Masvomhu. Kana izvi usapinda, musingadi kumhanya Solver muna Excel. Mabasa, ukuwo, uyewo haazoiti kugadziriswa. Naizvozvo, nokuti kuzadzika anobudirira mabasa unofanira kupinda yakarurama payakavakirwa.

Kukarukureta kunotanga chiratidzo zvakaenzana. Somuenzaniso, kana sero zvinoratidzwa "= ROOT (foni nhamba)", kuti runoenzanirana basa inoshandiswa.

Kamwe chikuru payakavakirwa pamwe chiratidzo "=" kwave kudhindwa, zvakakodzera achibva Data izvo zvichava dyidzana. Zvinogona masero mumwe kana kupfuura. Kana nzira iri rakakodzera nokuti 2-3 masero, zvinokwanisika chokubatanidza kwavari achishandisa "+" chiratidzo.

Kuti uwane mamwe mashoko, unogona kushandisa kutsvaka basa. Somuenzaniso, kana uchida kuva nzira kuti tsamba «A», ipapo zvakafanira kuti tsanangurai uye. Ipapo mushandisi achapiwa zvakabayirwa ose Data kunosanganisira.

mhedziso

In mhedziso, muna Excel 2007, unofanira kuchengetedza yakatarwa parameters kugadzirisa matambudziko. Unogona kuita izvi munzira dzakawanda. The Shona aine tinya runoenzanirana bhatani kushanda muna chiitiko kuti kuverenga nzira inoshandiswa nokuda mashoko ose.

Kana zvakakodzera kugadzirisa equations wandei Somuenzaniso, kuwana shoma uye kunonyanyisa basa, unofanira kuponesa, kwete kukarukureta zvose, uye ayo muenzaniso. Ipapo mushandisi achakwanisa kushandisa kuti imwe sarudzo.