{"id":964,"date":"2012-02-10T07:26:13","date_gmt":"2012-02-10T06:26:13","guid":{"rendered":"http:\/\/jpgarcia.blogs.upv.es\/?p=383"},"modified":"2012-02-10T07:26:13","modified_gmt":"2012-02-10T06:26:13","slug":"uso-del-solver-de-excel","status":"publish","type":"post","link":"https:\/\/jpgarcia.webs.upv.es\/?p=964","title":{"rendered":"Uso del solver de excel"},"content":{"rendered":"<p>Para poder utilizar el solver de excel (adem\u00e1s de estar instalado) es necesario disponer de una manera relativamente ordenada los datos y las variables.<\/p>\n<p>Recomiendo para ello escribir primero el modelo en formato &#8220;modelo de programaci\u00f3n matem\u00e1tica&#8221; y despu\u00e9s transformarlo poco a poco.<\/p>\n<p>Aqu\u00ed teneis dos ejemplos.<\/p>\n<p>Uno sobre un plan de producci\u00f3n (versi\u00f3n ampliada del problema &#8220;\u00bfCuanto gana la empresa?&#8221;)\u00a0<a href=\"http:\/\/youtu.be\/eDt1XgUafAM\">eDt1XgUafAM<\/a><\/p>\n<p>y otro sobre el problema BAING 717 \u00a0http:\/\/youtu.be\/X4Qhd3b6dxQ<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Para poder utilizar el solver de excel (adem&aacute;s de estar instalado) es necesario disponer de una manera relativamente ordenada los datos y las variables. Recomiendo para ello escribir primero el modelo en formato &ldquo;modelo de programaci&oacute;n matem&aacute;tica&rdquo; y despu&eacute;s transformarlo poco a poco. Aqu&iacute; teneis dos ejemplos. Uno sobre un plan de producci&oacute;n (versi&oacute;n ampliada [&hellip;]<\/p>\n<\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,30],"tags":[],"class_list":["post-964","post","type-post","status-publish","format-standard","hentry","category-docencia-e-investigacion","category-ejemplos-y-videos"],"_links":{"self":[{"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/posts\/964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=964"}],"version-history":[{"count":9,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/posts\/964\/revisions"}],"predecessor-version":[{"id":3311,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=\/wp\/v2\/posts\/964\/revisions\/3311"}],"wp:attachment":[{"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpgarcia.webs.upv.es\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}