{"id":2491,"date":"2017-04-11T15:12:27","date_gmt":"2017-04-11T13:12:27","guid":{"rendered":"http:\/\/www.supagro.fr\/wordpress\/modeleco\/?page_id=2491"},"modified":"2019-07-01T18:55:20","modified_gmt":"2019-07-01T16:55:20","slug":"activite-13-creer-un-fichier-excel-pour-importer-des-donnees-dans-gams","status":"publish","type":"page","link":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon13\/activite-13-creer-un-fichier-excel-pour-importer-des-donnees-dans-gams\/","title":{"rendered":"Activity 14 : \u00ab Paris basin \u00bb model \u2013 Importing data"},"content":{"rendered":"<h4 style=\"text-align: right\"><u>Length : around 35 minutes<\/u><\/h4>\n<p><strong>Using what you wrote in exercise 11 or the following correction <a href=\"https:\/\/www.supagro.fr\/ModelEco\/en\/modeles\/modelEco_ParisBasin_technic.zip\">\u00a0modelEco_ParisBasin_technic.gms<\/a>,<\/strong><br \/>\n<strong>1) create an Excel file using the model data (yields, working time and costs)<\/strong><br \/>\n<strong>2) import the data into your model<\/strong><\/p>\n<p><em>\u00ab A farmer in the Paris basin has a large-scale 100 ha farm. He can grow soft wheat (cleT), rapeseed, spring barley (orgeP) and winter barley (orgeH). For each crop, he can choose between three management systems :<\/em><\/p>\n<ul>\n<li><em>Intensive (written \u00ab\u00a0intens\u00a0\u00bb)\u00a0: it is the most intensive system in terms of chemical inputs, with a \u201cpreventive\u201d use of phytosanitary products.<\/em><\/li>\n<li><em>Sustainable (written \u00ab\u00a0rais\u00a0\u00bb)\u00a0: it involves \u201csustainable\u201d practices. \u00bb. Phytosanitary treatments are determined following the observation of diseases or pests in the plot. The quantities used are adapted to the situation.<\/em><\/li>\n<li><em>Integrated pest management ( written \u00ab\u00a0protI\u00a0\u00bb)\u00a0: such practices integrate prophylactic agronomic measures which contribute to a decrease in the pressure caused by pests. They can involve considerations concerning sowing dates, variety choices, crop successions in a plot, etc\u2026<\/em><\/li>\n<\/ul>\n<p><em>The farmer knows the expected yields, the variable costs, and the working time required for each system and each crop.<br \/>\nHe can work 2000 hours a year.<\/em><\/p>\n<p><em>\u00a0<\/em><\/p>\n<table width=\"317\">\n<tbody>\n<tr>\n<td colspan=\"4\" width=\"317\">Yields (q\/ha) per crop and management system<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"84\">aa<br \/>\nCrop<\/td>\n<td colspan=\"3\" width=\"233\"><em>Management system<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"64\"><em>Intensive<\/em><\/td>\n<td width=\"79\"><em>Sustainable<\/em><\/td>\n<td width=\"90\"><em>Integrated pest management<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>bleT<\/em><\/td>\n<td width=\"64\">72,8<\/td>\n<td width=\"79\">71<\/td>\n<td width=\"90\">65<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>rapeseed<\/em><\/td>\n<td width=\"64\">31<\/td>\n<td width=\"79\">29<\/td>\n<td width=\"90\">26,3<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>orgeP<\/em><\/td>\n<td width=\"64\">62,6<\/td>\n<td width=\"79\">62<\/td>\n<td width=\"90\">56<\/td>\n<\/tr>\n<tr>\n<td width=\"84\">orgeH<\/td>\n<td width=\"64\">71<\/td>\n<td width=\"79\">70<\/td>\n<td width=\"90\">64<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table width=\"377\">\n<tbody>\n<tr>\n<td colspan=\"4\" width=\"377\">Working time (hours per ha) per crop and management system<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"84\">aa<br \/>\nCrop<\/td>\n<td colspan=\"3\" width=\"293\"><em>Management system<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"64\"><em>Intensive<\/em><\/td>\n<td width=\"79\"><em>Sustainable<\/em><\/td>\n<td width=\"150\"><em>Integrated pest management<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>bleT<\/em><\/td>\n<td width=\"64\">3,2<\/td>\n<td width=\"79\">3,1<\/td>\n<td width=\"150\">3,1<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>rapeseed<\/em><\/td>\n<td width=\"64\">4<\/td>\n<td width=\"79\">3,6<\/td>\n<td width=\"150\">4<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>orgeP<\/em><\/td>\n<td width=\"64\">3,1<\/td>\n<td width=\"79\">3,1<\/td>\n<td width=\"150\">3,3<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>orgeH<\/em><\/td>\n<td width=\"64\">3,3<\/td>\n<td width=\"79\">3<\/td>\n<td width=\"150\">3<\/td>\n<\/tr>\n<tr>\n<td colspan=\"4\" width=\"377\">Total costs (\u20ac\/ha) per crop and management system<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" width=\"84\">aa<br \/>\nCrop<\/td>\n<td colspan=\"3\" width=\"293\"><em>Management system<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"64\"><em>Intensive<\/em><\/td>\n<td width=\"79\"><em>Sustainable<\/em><\/td>\n<td width=\"150\"><em>Integrated pest management<\/em><\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>bleT<\/em><\/td>\n<td width=\"64\">652<\/td>\n<td width=\"79\">611<\/td>\n<td width=\"150\">534<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>rapeseed<\/em><\/td>\n<td width=\"64\">724<\/td>\n<td width=\"79\">635<\/td>\n<td width=\"150\">576<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>orgeP<\/em><\/td>\n<td width=\"64\">668<\/td>\n<td width=\"79\">676<\/td>\n<td width=\"150\">594<\/td>\n<\/tr>\n<tr>\n<td width=\"84\"><em>orgeH<\/em><\/td>\n<td width=\"64\">746<\/td>\n<td width=\"79\">680<\/td>\n<td width=\"150\">587<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>The selling prices of the different crops are : 180\u20ac\/t for soft wheat, 365\u20ac\/t for rapeseed, 170\u20ac\/t for spring barley and 155\u20ac\/t for winter barley.<br \/>\nThe objective of the farmer is to maximize his income. \u00bb<\/em><\/p>\n<p><em>\u00a0<\/em><\/p>\n<p><em>The data come from : Ecophyto R&amp;D vers des syst\u00e8mes de culture \u00e9conomes en produits phytosanitaires \u2013\u00a0 Volet 1. Tome II : Analyse comparative de diff\u00e9rents syst\u00e8mes en grandes cultures. Janvier 2009. INRA et le minist\u00e8re de l\u2019\u00e9cologie, de l\u2019\u00e9nergie, du d\u00e9veloppement durable et de l\u2019am\u00e9nagement du territoire.<\/em><\/p>\n<p><strong>Solution<\/strong> :<br \/>\n<a href=\"https:\/\/www.supagro.fr\/ModelEco\/en\/modeles\/modelEco_dataParisBasin.zip\"><strong>modelEco_dataParisBasin.xlsx<\/strong><\/a><br \/>\n<a href=\"https:\/\/www.supagro.fr\/ModelEco\/en\/modeles\/modelEco_ParisBasin_technic_excel.zip\"><strong>modelEco_ParisBasin_technic_excel.gms<\/strong><\/a><\/p>\n<p style=\"text-decoration: underline\"><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>Length : around 35 minutes Using what you wrote in exercise 11 or the following correction \u00a0modelEco_ParisBasin_technic.gms, 1) create an Excel file using the model data (yields, working time and costs) 2) import the data into your model \u00ab A <a class=\"more-link\" href=\"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/auto-formation\/sequence2\/cours1-enrichir-le-modele-de-base\/lecon13\/activite-13-creer-un-fichier-excel-pour-importer-des-donnees-dans-gams\/\">Continue reading <span class=\"screen-reader-text\">  Activity 14 : \u00ab Paris basin \u00bb model \u2013 Importing data<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":92,"featured_media":0,"parent":397,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2491","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2491","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=2491"}],"version-history":[{"count":18,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2491\/revisions"}],"predecessor-version":[{"id":4698,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/2491\/revisions\/4698"}],"up":[{"embeddable":true,"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/pages\/397"}],"wp:attachment":[{"href":"https:\/\/www.supagro.fr\/wordpress\/modelecoen\/wp-json\/wp\/v2\/media?parent=2491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}