{"id":2939,"date":"2017-08-28T12:12:20","date_gmt":"2017-08-28T10:12:20","guid":{"rendered":"http:\/\/www.supagro.fr\/wordpress\/modeleco\/?page_id=2939"},"modified":"2019-06-19T14:03:05","modified_gmt":"2019-06-19T12:03:05","slug":"lecon-14-importer-et-exporter-des-donnees-et-des-resultats","status":"publish","type":"page","link":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon-14-importer-et-exporter-des-donnees-et-des-resultats\/","title":{"rendered":"Lesson 14 : Importing and exporting data and results"},"content":{"rendered":"<p><em>Watch the first slideshow and try to complete the\u00a0<\/em><a href=\"https:\/\/www.supagro.fr\/ModelEco\/en\/modeles\/modelEco_primal0.zip\"><em>primal0.gms<\/em><\/a><em>\u00a0model on your own before you watch the correction.<\/em><\/p>\n<table>\n<colgroup>\n<col span=\"2\" width=\"80\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td colspan=\"2\"><strong>Video 1 : How to export data to Excel ?<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em> <a href=\"http:\/\/www.supagro.fr\/ModelEco\/en\/video\/L14_video1.mp4\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.supagro.fr\/wordpress\/modeleco\/files\/2016\/05\/video.png\" alt=\"video\" width=\"59\" height=\"67\" \/><\/a>(2 min)<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><strong>Video 2 : Example in GAMS<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Modify the model<\/strong><\/td>\n<td><strong>Watch the video<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\n<ul>\n<li>Using the model that you wrote in lesson 13 (in which constraints have already been modified), create a results parameter with cropping patterns, income, and model status,<\/li>\n<li>Then export the results to Excel.<\/li>\n<\/ul>\n<\/td>\n<td width=\"120\">\n<h6><\/h6>\n<h6><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/strong><\/h6>\n<h6><strong><em>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0\u00a0<\/em> <a href=\"http:\/\/www.supagro.fr\/ModelEco\/en\/video\/L14_video2.mp4\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.supagro.fr\/wordpress\/modeleco\/files\/2016\/05\/video.png\" alt=\"video\" width=\"59\" height=\"67\" \/><\/a><\/strong>(4 min)<\/h6>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><strong>Video 3 : Importing data from Excel<\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/em><a href=\"http:\/\/www.supagro.fr\/ModelEco\/en\/video\/L14_video3.mp4\"><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.supagro.fr\/wordpress\/modeleco\/files\/2016\/05\/video.png\" alt=\"video\" width=\"59\" height=\"67\" \/><\/a>(3 min)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"http:\/\/www.supagro.fr\/wordpress\/modelecoen\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4121 alignright\" src=\"http:\/\/www.supagro.fr\/wordpress\/modelecoen\/files\/2018\/11\/backUnit.png\" alt=\"\" width=\"211\" height=\"66\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch the first slideshow and try to complete the\u00a0primal0.gms\u00a0model on your own before you watch the correction. Video 1 : How to export data to Excel ? \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (2 min) Video 2 : <a class=\"more-link\" href=\"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon-14-importer-et-exporter-des-donnees-et-des-resultats\/\">Continue reading <span class=\"screen-reader-text\">  Lesson 14 : Importing and exporting data and results<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":92,"featured_media":0,"parent":387,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2939","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/comments?post=2939"}],"version-history":[{"count":9,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2939\/revisions"}],"predecessor-version":[{"id":4580,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2939\/revisions\/4580"}],"up":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/387"}],"wp:attachment":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/media?parent=2939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}