{"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":"2017-10-25T11:51:43","modified_gmt":"2017-10-25T09:51:43","slug":"lecon-14-importer-et-exporter-des-donnees-et-des-resultats","status":"publish","type":"page","link":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon-14-importer-et-exporter-des-donnees-et-des-resultats\/","title":{"rendered":"Le\u00e7on 14 : Importer et exporter des donn\u00e9es et des r\u00e9sultats"},"content":{"rendered":"<p><em>Visionnez le premier diaporama et essayez seul de compl\u00e9ter le mod\u00e8le <a href=\"http:\/\/www.supagro.fr\/ModelEco\/modeles\/primal0.zip\">primal0.gms<\/a> avant de regarder la correction. <\/em><\/p>\n<table>\n<colgroup>\n<col span=\"2\" width=\"80\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td colspan=\"2\"><strong>Vid\u00e9o 1 : Comment exporter les donn\u00e9es sous Excel ?<br \/>\n<\/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\/S2\/C1\/L14_excelGAMS\/html5.html#\"><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>Vid\u00e9o 2 : Exemple en GAMS<br \/>\n<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>Modifiez le mod\u00e8le<\/strong><\/td>\n<td><strong>Visionnez la vid\u00e9o<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\n<ul>\n<li>\u00e0 partir du mod\u00e8le \u00e9crit dans la le\u00e7on 13 (o\u00f9 les contraintes ont d\u00e9j\u00e0 \u00e9t\u00e9 modifi\u00e9es), cr\u00e9er un param\u00e8tre de r\u00e9sultat avec l&rsquo;assolement, le revenu et le statut du mod\u00e8le<\/li>\n<li>puis exporter les r\u00e9sultats sous 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\/S2\/C1\/L14_excelGAMS_camtasia\/html5.html#\"><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>Vid\u00e9o 3 : Importer des donn\u00e9es d&rsquo;Excel<br \/>\n<\/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\/S2\/C1\/L13_RecourirAuMarche_partie3\/html5.html#\"><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\/modeleco\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/\" rel=\"attachment wp-att-869\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-869 alignright\" src=\"http:\/\/www.supagro.fr\/wordpress\/modeleco\/files\/2016\/08\/retourSommaireCours.png\" alt=\"retourSommaireCours\" width=\"211\" height=\"68\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Visionnez le premier diaporama et essayez seul de compl\u00e9ter le mod\u00e8le primal0.gms avant de regarder la correction. Vid\u00e9o 1 : Comment exporter les donn\u00e9es sous 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) Vid\u00e9o 2 : <a class=\"more-link\" href=\"https:\/\/www.supagro.fr\/wordpress\/modeleco\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon-14-importer-et-exporter-des-donnees-et-des-resultats\/\">Continuer la lecture <span class=\"screen-reader-text\">  Le\u00e7on 14 : Importer et exporter des donn\u00e9es et des r\u00e9sultats<\/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\/modeleco\/wp-json\/wp\/v2\/pages\/2939","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/users\/92"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/comments?post=2939"}],"version-history":[{"count":6,"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/pages\/2939\/revisions"}],"predecessor-version":[{"id":3206,"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/pages\/2939\/revisions\/3206"}],"up":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/pages\/387"}],"wp:attachment":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modeleco\/wp-json\/wp\/v2\/media?parent=2939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}