{"id":4755,"date":"2024-10-17T08:55:49","date_gmt":"2024-10-17T08:55:49","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=4755"},"modified":"2024-10-17T08:55:49","modified_gmt":"2024-10-17T08:55:49","slug":"a-complete-guide-to-using-solver-in-excel-for-problem-solving","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/a-complete-guide-to-using-solver-in-excel-for-problem-solving\/","title":{"rendered":"Piln\u012bga rokasgr\u0101mata, k\u0101 izmantot programmu Excel probl\u0113mu risin\u0101\u0161anai"},"content":{"rendered":"<p>Programma Microsoft Excel ir apr\u012bkota ar da\u017e\u0101d\u0101m funkcij\u0101m, kas racionaliz\u0113 apr\u0113\u0137inu veik\u0161anas un vien\u0101dojumu risin\u0101\u0161anas procesu, t\u0101d\u0113j\u0101di uzlabojot produktivit\u0101ti. Viena no \u0161\u012bm funkcij\u0101m ir Risin\u0101t\u0101ja r\u012bks, kam ir l\u012bdz\u012bbas ar Goal Seek funkciju.<\/p>\n<p>Risin\u0101t\u0101js, ko parasti izmanto \u201ck\u0101 b\u016btu, ja\u201d anal\u012bzei, \u013cauj lietot\u0101jiem noskaidrot konkr\u0113tas \u0161\u016bnas v\u0113rt\u012bbu, iev\u0113rojot vair\u0101kus ierobe\u017eojumus. To var izmantot, lai noteiktu konkr\u0113tu v\u0113rt\u012bbu, minim\u0101lo slieksni vai maksim\u0101lo skait\u013ca ierobe\u017eojumu. Lai gan tas var neatrisin\u0101t visas probl\u0113mas, Solver ir nenov\u0113rt\u0113jams resurss optimiz\u0101cijas scen\u0101rijiem, kuros ir \u013coti svar\u012bgi atrast lab\u0101ko iesp\u0113jamo l\u0113mumu.<\/p>\n<p>\u0160is r\u012bks darbojas, izkl\u0101jlap\u0101 piel\u0101gojot konkr\u0113tu \u0161\u016bnu v\u0113rt\u012bbas, kas paz\u012bstamas k\u0101 l\u0113muma main\u012bgie, lai noteiktu citas \u0161\u016bnas maksim\u0101lo vai minim\u0101lo v\u0113rt\u012bbu, ko d\u0113v\u0113 par m\u0113r\u0137a \u0161\u016bnu. Solver ir piem\u0113rojams da\u017e\u0101diem programm\u0113\u0161anas veidiem, tostarp line\u0101rai un neline\u0101rai programm\u0113\u0161anai, veselu skait\u013cu programm\u0113\u0161anai un m\u0113r\u0137a mekl\u0113\u0161anas uzdevumiem.<\/p>\n<p>Tipiski Solver pielietojumi ietver transporta izdevumu samazin\u0101\u0161anu, optim\u0101lu darba grafiku izstr\u0101di, lab\u0101k\u0101 bud\u017eeta izveidi rekl\u0101mas iniciat\u012bv\u0101m vai invest\u012bciju atdeves palielin\u0101\u0161anu, lai nosauktu tikai da\u017eus.<\/p>\n<h2 id=\"adding-solver-to-excel\">Solver aktiviz\u0113\u0161ana programm\u0101 Excel<\/h2>\n<p>Lai s\u0101ktu lietot Solver, vispirms ir j\u0101iesp\u0113jo \u0161\u012b pievienojumprogramma, jo t\u0101 nav aktiviz\u0113ta p\u0113c noklus\u0113juma, piem\u0113ram, funkcija Goal Seek. Par laimi, process ir diezgan vienk\u0101r\u0161s.<\/p>\n<ul>\n<li>S\u0101ciet, ekr\u0101na aug\u0161da\u013c\u0101 atlasot izv\u0113lni Fails un p\u0113c tam noklik\u0161\u0137iniet uz Opcijas.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"515\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-210-1.webp\" title=\"\" width=\"915\"\/><\/figure>\n<ul>\n<li>P\u0113c tam noklik\u0161\u0137iniet uz &#8216;Papildin\u0101jumi&#8217;, kas atrodas opciju loga kreisaj\u0101 pus\u0113.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"579\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-211-1.webp\" title=\"\" width=\"1029\"\/><\/figure>\n<ul>\n<li>Tagad apak\u0161\u0101 eso\u0161aj\u0101 nolai\u017eamaj\u0101 izv\u0113ln\u0113 \u201cP\u0101rvald\u012bt\u201d atlasiet \u201cExcel pievienojumprogrammas\u201d un noklik\u0161\u0137iniet uz \u201cAiziet\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"475\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-212-1.webp\" title=\"\" width=\"845\"\/><\/figure>\n<ul>\n<li>N\u0101kamaj\u0101 dialoglodzi\u0146\u0101 atz\u012bm\u0113jiet izv\u0113les r\u016bti\u0146u blakus &#8216;Risin\u0101t\u0101ja pievienojumprogramma&#8217;, lai to iesp\u0113jotu, un p\u0113c tam nospiediet &#8216;Labi&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"465\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-213-1.webp\" title=\"\" width=\"827\"\/><\/figure>\n<ul>\n<li>Tagad programm\u0101 Excel noklik\u0161\u0137inot uz cilnes Dati, jums vajadz\u0113tu redz\u0113t, ka ir pieejams risin\u0101jums.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"533\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-214-1.webp\" title=\"\" width=\"947\"\/><\/figure>\n<h2 id=\"components-of-solver\">Risin\u0101t\u0101ja galven\u0101s sast\u0101vda\u013cas<\/h2>\n<p>Pirms Risin\u0101t\u0101js var noteikt optim\u0101lo v\u0113rt\u012bbu jebkurai probl\u0113mai, ir j\u0101izveido tr\u012bs galvenie komponenti:<\/p>\n<ul>\n<li><strong>M\u0113r\u0137a \u0161\u016bna:<\/strong> \u0161aj\u0101 \u0161\u016bn\u0101 ir formula, kas atspogu\u013co probl\u0113mas m\u0113r\u0137i vai m\u0113r\u0137i, lai samazin\u0101tu, palielin\u0101tu vai sasniegtu noteiktu v\u0113rt\u012bbu.<\/li>\n<li><strong>Main\u012bgo \u0161\u016bnas:<\/strong> \u0161aj\u0101s \u0161\u016bn\u0101s ir main\u012bgie, kurus Solver piel\u0101gos, lai sasniegtu m\u0113r\u0137i. Programm\u0101 Solver var nor\u0101d\u012bt ne vair\u0101k k\u0101 200 main\u012bgas \u0161\u016bnas.<\/li>\n<li><strong>Ierobe\u017eojumi:<\/strong> Ierobe\u017eojumi ir parametri, kuru ietvaros Solver j\u0101darbojas, lai sasniegtu v\u0113lamo rezult\u0101tu. Tie nosaka nosac\u012bjumus, kas j\u0101iev\u0113ro, nosakot nepiecie\u0161am\u0101s v\u0113rt\u012bbas.<\/li>\n<\/ul>\n<h2 id=\"using-solver\">Risin\u0101t\u0101ja pielieto\u0161ana<\/h2>\n<p>Kad programmai Excel ir pievienots Solver, varat turpin\u0101t to izmantot. \u0160aj\u0101 piem\u0113r\u0101 m\u0113s izmantosim Solver, lai apr\u0113\u0137in\u0101tu pale\u0161u ra\u017eo\u0161anas uz\u0146\u0113muma pe\u013c\u0146u, pamatojoties uz zin\u0101m\u0101m resursu v\u0113rt\u012bb\u0101m, piem\u0113ram, uz paleti nepiecie\u0161amajiem resursiem, k\u0101 ar\u012b da\u017e\u0101du pale\u0161u veidu pieejam\u012bbu.<\/p>\n<ul>\n<li>\u0160\u016bn\u0101s B3 l\u012bdz E3 ir uzskait\u012bti da\u017e\u0101di pale\u0161u veidi, kas uz\u0146\u0113mumam ir j\u0101ra\u017eo. Tie\u0161i zem\u0101k eso\u0161aj\u0101 rind\u0101 ir nor\u0101d\u012bts katram tipam sara\u017eojamo pale\u0161u skaits, kas inicializ\u0113ts uz nulli. N\u0101kamaj\u0101 rind\u0101 ir nor\u0101d\u012bta pe\u013c\u0146a, kas saist\u012bta ar katru paletes veidu. M\u016bsu m\u0113r\u0137is ir noteikt, cik pale\u0161u ra\u017eot katram veidam, kop\u0113jo pe\u013c\u0146u att\u0113lojot \u0161\u016bn\u0101 F5. Ierobe\u017eojumi \u0161eit ir pieejamie resursi, kas nosaka, cik pale\u0161u uz\u0146\u0113mums var sara\u017eot.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"451\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-243-1.webp\" title=\"\" width=\"802\"\/><\/figure>\n<ul>\n<li>Lai s\u0101ktu, noklik\u0161\u0137iniet uz &#8220;Solver&#8221;, kas atrodas aug\u0161\u0113j\u0101 labaj\u0101 st\u016br\u012b, kas par\u0101d\u012bs dialoglodzi\u0146u Risin\u0101t\u0101js. Ievadiet m\u0113r\u0137a \u0161\u016bnas nosaukumu vai \u0161\u016bnas atsauci, nodro\u0161inot, ka taj\u0101 ir formula. \u0160aj\u0101 scen\u0101rij\u0101 Cell F5 kalpo k\u0101 m\u0113r\u0137a funkcija, kas dod kop\u0113jo pe\u013c\u0146u visiem pale\u0161u veidiem kop\u0101, \u0146emot v\u0113r\u0101 gan pieejamos resursus, gan sara\u017eojam\u0101s paletes.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"525\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-244-1-1.webp\" title=\"\" width=\"933\"\/><\/figure>\n<ul>\n<li>Lauk\u0101 Mainot main\u012bg\u0101s \u0161\u016bnas atlasiet diapazonu B4:E4, velkot peli vai tie\u0161i ierakstot \u0161\u016bnu nosaukumus. \u0160\u012bs \u0161\u016bnas att\u0113lo pale\u0161u skaitu katram veidam, un pa\u0161laik t\u0101s ir iestat\u012btas uz nulli. Risin\u0101t\u0101js izpildes laik\u0101 piel\u0101gos \u0161\u012bs v\u0113rt\u012bbas.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"525\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-245-1.webp\" title=\"\" width=\"933\"\/><\/figure>\n<ul>\n<li>P\u0113c tam noklik\u0161\u0137iniet uz pogas &#8220;Pievienot&#8221;, lai ieviestu ierobe\u017eojumus. Solver apr\u0113\u0137in\u0101s, cik pale\u0161u uz\u0146\u0113mums var sara\u017eot, pamatojoties uz t\u0101du materi\u0101lu pieejam\u012bbu k\u0101 l\u012bme, pres\u0113\u0161ana, priedes skaidas un ozola skaidas. J\u016bs iev\u0113rosiet, ka v\u0113rt\u012bbas kolonn\u0101 \u201cIzmantots\u201d, kas pa\u0161laik ir nulle, main\u012bsies, izpildot Solver.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"525\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-246-1.webp\" title=\"\" width=\"933\"\/><\/figure>\n<ul>\n<li>Lauk\u0101 Ierobe\u017eojums ierakstiet F8:F11 slejai \u201c\u0160\u016bnas atsauce\u201d, kas atbilst kolonnai \u201cLietots\u201d, un G8:G11 kolonnai \u201cPieejams\u201d. P\u0101rliecinieties, ka attiec\u012bba ir iestat\u012bta uz <code>&lt;=<\/code>noklus\u0113juma v\u0113rt\u012bbu, nor\u0101dot, ka v\u0113rt\u012bb\u0101m kolonn\u0101 Lietots ir j\u0101b\u016bt maz\u0101k\u0101m vai vien\u0101d\u0101m ar kolonn\u0101 Pieejamaj\u0101m v\u0113rt\u012bb\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"438\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-247-1.webp\" title=\"\" width=\"778\"\/><\/figure>\n<ul>\n<li>P\u0113c visu main\u012bgo un ierobe\u017eojumu ievad\u012b\u0161anas dialoglodzi\u0146\u0101 Pievienot ierobe\u017eojumu v\u0113lreiz noklik\u0161\u0137iniet uz &#8216;Pievienot&#8217; un p\u0113c tam aizveriet to. J\u016bs ar\u012b iev\u0113rosit, ka opcija \u201cPadar\u012bt neierobe\u017eotus main\u012bgos k\u0101 nenegat\u012bvus\u201d ir iesp\u0113jota p\u0113c noklus\u0113juma dialoglodzi\u0146\u0101 Risin\u0101t\u0101ja parametri, nodro\u0161inot, ka visi main\u012bgie paliek nenegat\u012bvi pat tad, ja nav iestat\u012bti konkr\u0113ti ierobe\u017eojumi.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"438\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-248-1.webp\" title=\"\" width=\"778\"\/><\/figure>\n<ul>\n<li>P\u0113c ierakstu aizpild\u012b\u0161anas dialoglodzi\u0146\u0101 Risin\u0101t\u0101ja parametri noklik\u0161\u0137iniet uz pogas &#8220;Risin\u0101t&#8221; un gaidiet, l\u012bdz programma Excel pieg\u0101d\u0101s rezult\u0101tus.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"570\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-252-1.webp\" title=\"\" width=\"1014\"\/><\/figure>\n<ul>\n<li>Kad rezult\u0101ti ir \u0123ener\u0113ti, par\u0101d\u012bsies dialoglodzi\u0146\u0161 Risin\u0101t\u0101ja rezult\u0101ti, atkl\u0101jot jaun\u0101s v\u0113rt\u012bbas \u0161\u016bn\u0101s B4 l\u012bdz E4. \u0145emiet v\u0113r\u0101, ka Solver maina j\u016bsu datus; ja v\u0113laties atgriezties pie s\u0101kotn\u0113j\u0101m v\u0113rt\u012bb\u0101m, varat atlas\u012bt opciju Atjaunot s\u0101kotn\u0113j\u0101s v\u0113rt\u012bbas. Kad esat izl\u0113mis, vai saglab\u0101t risin\u0101jumu vai atgriezties pie s\u0101kotn\u0113jiem datiem, p\u0101rliecinieties, vai labaj\u0101 pus\u0113 ir atz\u012bm\u0113ta opcija &#8220;Atbilde&#8221;, p\u0113c tam noklik\u0161\u0137iniet uz &#8220;OK&#8221;, lai izietu no dialoglodzi\u0146a.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"470\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-255-1.webp\" title=\"\" width=\"835\"\/><\/figure>\n<ul>\n<li>Ja izv\u0113l\u0113sities saglab\u0101t jauno risin\u0101jumu, tas tiks atspogu\u013cots j\u016bsu izkl\u0101jlap\u0101, aizverot dialoglodzi\u0146u Risin\u0101t\u0101js. Uz\u0146\u0113muma produkcij\u0101 b\u016bs 23 Tahoe paletes, 15 Pacific paletes, 39 Savannah paletes un neviena no Aspen palet\u0113m, kas tiks nor\u0101d\u012btas rind\u0101 Paletes no B4 l\u012bdz D4. Turkl\u0101t kop\u0113j\u0101 pe\u013c\u0146as \u0161\u016bna tiks atjaunin\u0101ta no nulles l\u012bdz 58 800 USD.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"455\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-343-1.webp\" title=\"\" width=\"809\"\/><\/figure>\n<h3 id=\"things-to-know\">Svar\u012bgi apsv\u0113rumi<\/h3>\n<ul>\n<li>T\u0101pat k\u0101 programma Excel Goal Seek, ar\u012b Solver ir nepiecie\u0161ams iepriek\u0161 izveidot nepiecie\u0161am\u0101s formulas, lai tas pareizi darbotos.<\/li>\n<li>Probl\u0113mu risin\u0101\u0161anas metodi var ietekm\u0113t, dialoglodzi\u0146\u0101 Risin\u0101t\u0101ja parametri atlasot pogu Opcijas, kur varat nor\u0101d\u012bt v\u0113rt\u012bbas &#8220;Visas metodes&#8221;, &#8220;GRG Neline\u0101rs&#8221; un &#8220;Evolucion\u0101rs&#8221;.<\/li>\n<li>Turkl\u0101t Solver \u013cauj saglab\u0101t un iel\u0101d\u0113t mode\u013cus v\u0113l\u0101kai lieto\u0161anai. Iel\u0101d\u0113jot eso\u0161os mode\u013cus, noteikti ievadiet atsauci visam \u0161\u016bnu diapazonam, kas attiecas uz konkr\u0113to probl\u0113mu.<\/li>\n<li>Lietojot Solver, ieteicams str\u0101d\u0101t ar datu kopiju, jo tas maina s\u0101kotn\u0113jos datus p\u0113c izpildes, un p\u0113c izmai\u0146u veik\u0161anas \u0161o datu atkop\u0161ana var neb\u016bt iesp\u0113jama.<\/li>\n<\/ul>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-solver-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Avots<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Programma Microsoft Excel ir apr\u012bkota ar da\u017e\u0101d\u0101m funkcij\u0101m, kas racionaliz\u0113 apr\u0113\u0137inu veik\u0161anas un vien\u0101dojumu risin\u0101\u0161anas procesu, t\u0101d\u0113j\u0101di uzlabojot produktivit\u0101ti. Viena no \u0161\u012bm funkcij\u0101m ir Risin\u0101t\u0101ja r\u012bks, kam ir l\u012bdz\u012bbas ar Goal Seek funkciju. Risin\u0101t\u0101js, ko parasti izmanto \u201ck\u0101 b\u016btu, ja\u201d anal\u012bzei, \u013cauj lietot\u0101jiem noskaidrot konkr\u0113tas \u0161\u016bnas v\u0113rt\u012bbu, iev\u0113rojot vair\u0101kus ierobe\u017eojumus. To var izmantot, lai noteiktu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[62,130,286],"class_list":["post-4755","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/4755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=4755"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/4755\/revisions"}],"predecessor-version":[{"id":4756,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/4755\/revisions\/4756"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=4755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=4755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=4755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}