====== Course Overview ====== ===== Applied Data Analysis: Introduction to and Application of the Partial Equilibrium Model CAPRI in Market and Policy Analysis 2023 ===== [[https://moodle.hu-berlin.de/course/view.php?id=119710|Moodle Link at HU Berlin]] %%|%% ==== Important other Links ==== * [[http://www.capri-model.org|CAPRI Main Webpage]] * [[https://www.capri-model.org/dokuwiki_help/doku.php|Wiki of CAPRI]] ==== Background ==== In collaboration with the CAPRI network, the Faculty of Life Sciences Thaer-Institute International Agricultural Trade And Development at the Humboldt University zu Berlin and the Thünen institute for farm economics organizes and offers this CAPRI course for beginners. CAPRI (Common Agricultural Policy Regional Impact Analysis) is a global agroeconomic model developed for policy impact assessment purposes. Operational for two decades, it supports decision-making related to the Common Agricultural Policy of the EU and its implementation at the Member State and regional levels. The effects of agricultural, environmental and trade policies on agricultural production, consumption, prices and trade, as well as environmental indicators, are analysed in a comparative-static framework in which the simulated results are compared to a baseline scenario. ==== Aims of the training session ==== The CAPRI course aims at bringing together students, modelers, developers and any individuals with a strong interest and background in agriculture related research to improve their knowledge about agricultural economics and quantitative modeling of agricultural, environmental and trade policies with the CAPRI system. Discussions on common issues on agricultural policy, policy modelling, model development and maintenance with CAPRI developers and users will support knowledge generation and exchange of experiences in the community. The focus of this course is to provide participants with fundamental knowledge of CAPRI model to support and foster its further independent use for educational and research purposes (at the advanced level). Participants will learn to use the CAPRI model for scenario analysis and get acquainted with its Graphical User Interface (GUI), its structural blocks and its development approach. Special attention will be given to hands-on exercises on ex-ante impact assessments of agricultural policy changes in the agricultural sector, agri-food markets and the environment. ==== Contact and Lectures ==== The course will be led by Alexander Gocht, Davit Stepanyan, Davide Pignotti, Ferike Thom with contributions of core developers of the CAPRI network such as Maria Blanco, Torbjörn Jansson, Jordan Hristov, Caetano Beber. ====Format of the course ==== ==== I: Self Study: Self-study tutorial using CAPRI (deadline for the home work: 20th of September 2023) ==== * {{ :Tutorial_2023_ag_dp_17082023.pdf| Tutorial 2023}} * Download Star 2.8.2: [[https://cloud.capri-model.org/index.php/s/R2rWZmwJEMrTaK8|STAR 2.8.2]] * Download result data base 2.8: [[https://cloud.capri-model.org/index.php/s/5i34dstm393NmQC|result- database for STAR 2.8.2]] Aim of the Self Study: * Model installation * Basic model understanding * Graphical user interface * This part should be completed off-campus, before the Block III starts This tutorial consists of the self-study part of the course. For students who enrolled in the course to receive credit points, this tutorial needs to be completed and the answers of all exercises (in written format) send to davide.pignotti@thuenen.de. Please submit the completed exercises using the following format: LASTNAME_TS23.pdf. In addition, upon request, you will have the possibility to meet us in zoom during the following week (21.-25. August 2023) to discuss the exercises of the tutorial. ==== II: GAMS lectures (6.September 2023 - 8.September 2023) ==== ^Time/Date^Topic of the lecture^Download pptx^ GAMS Example [[https://cloud.capri-model.org/index.php/s/Yzcxbw6ycSGL74r|all exercises as zip]]^ |1st Day | | | |09:00 - 09:45 |GAMS modeling language. General introduction |[[https://cloud.capri-model.org/index.php/s/Kc2y8LBaeXBaoRM|Slides]]| | |10:00 - 10:45 |MyFarm LP modelin Excel; Main elements of a GAMS model | |[[https://cloud.capri-model.org/index.php/s/5ym8jPXcBHyd8dg|Exercise 1 - MyFarm in Excel]]| |11:00 - 11:45 |Coding MyFarm LP model in GAMS; Solver output | |[[https://cloud.capri-model.org/index.php/s/D2zW2ySapSk658A|Exercise 2 - MyFarm in GAMS]]| |12:15 - 13:00 |Solver output; Improving the efficiency. Sets, Subsets, Alias, Sum | |[[https://cloud.capri-model.org/index.php/s/TKpKFZES3jd9i2x|Exercise 3 - MyFarm_sets&sum]]| |2nd Day | | | | |09:00 - 09:45 |Introducing Sets and the Sum operator in MyFarm LP & useful statements| |see Exercise 3 | |10:00 - 10:45 |Data exchange with Excel | |[[https://cloud.capri-model.org/index.php/s/gpWWrjgDfgCjn2c|Exercise 4_data export]],[[https://cloud.capri-model.org/index.php/s/Gz5A6B6w66mGxmY|Exercise 5_data import]],[[https://cloud.capri-model.org/index.php/s/tE747DMrzGTW5YP|Exercise 5_data.xlsx]]| |11:00 - 11:45 |Introducing common income support schemes | [[https://cloud.capri-model.org/index.php/s/bKBgxrPxWgbbGq9|Slides]]| |12:15 - 13:00 |Scenario analysis with GAMS for VCS and decoupling support schemes. | | [[https://cloud.capri-model.org/index.php/s/MBGE6oYmsc3C9yW|Exercise 6]] | |3rd Day. | | | | |09:00 - 09:45 |Production Quota | |see Exercise 6 | |10:00 - 10:45 |Crop nutrient need in MyFarm|[[https://cloud.capri-model.org/index.php/s/R9oFwJ4JmmK43wB|Slides]]|[[https://cloud.capri-model.org/index.php/s/fPdqArzJezmyrxK|Exercise 7]] | |11:00 - 11:45 |Fertilizer pricing and purchasing |[[https://cloud.capri-model.org/index.php/s/JZZajEBgAZqEsYS|Slides]] |[[https://cloud.capri-model.org/index.php/s/yDSTJQ8SA2qFLbx|Exercise 8]],[[https://cloud.capri-model.org/index.php/s/Q6XJkDcHFKeMwKg|Exercise 9]]| |12:15 - 13:00 |Feedback round | || ==== III: An intensive 4-day: Lecture & Computer exercises (25th September - 28th of September 2023) ==== The course will provide literature and hands-on exercises for theoretical knowledge about the model analyzing results and modifying and simulating scenarios. Readings and sessions will be individualized to the participant’s interest and competence. Final exam: written or oral exam, depends on the number of students ==== Agenda for the Lecture & Computer exercises ==== === First Day ==== download: [[https://cloud.capri-model.org/index.php/s/7W9EHHbQnn6dfJN|monday.zip]] ^ ^Format ^Trainers^Topic of the lecture ^ ^Monday |||| ^09:15-10:00|[[https://cloud.capri-model.org/index.php/s/GzHZPj6QmAiqi4R|ppt]]|[[https://www.thuenen.de/en/institutes/farm-economics/staff/scientific-staff/gocht-alexander-dr|Alex Gocht]]|[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=1.1._overview_of_the_course_reminder_capri_and_gui |1.1. Overview of the course / Reminder Structure CAPRI and GUI]]| ^10:15-11:00|[[https://cloud.capri-model.org/index.php/s/c3ckjdXQfPtepbC|ppt]]/hands-on| Alex (breakout session) | [[https://www.capri-model.org/ts/dokuwiki/doku.php?id=1.5._gui-policy-editor-run-exploit|1.2 GUI Policy editor]] | ^11:00-11:15| |Coffee Break|| ^11:15-12:00|[[https://cloud.capri-model.org/index.php/s/FYM5ooCxxQkoEAy|ppt]]/hands-on| Caetano Beber (breakout session) |[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.1._shock_3_input_price_changes_for_mineral_fertilizer_with_and_without_market |2.1. Shock: Input price changes for mineral fertilizer with and without market]]| ^12:00-13:00| |lunch|| ^13:00-13:45|[[https://cloud.capri-model.org/index.php/s/PYxMrSKMyofJ2FF|ppt]]/hands-on| Alex Gocht|[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.2._data_of_the_supply_module | 2.2. Data of the Supply Module]] | ^14:00-14:45|[[https://cloud.capri-model.org/index.php/s/pWFCTZiJ5oNfR8Q|ppt]]|[[https://blancomaria.com|Maria Blanco]] |[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.1._overview_supply_module | 2.3. Overview Supply Module]] | ==== Second Day ==== download: [[https://cloud.capri-model.org/index.php/s/pQm9yy9gFbMCkCo|tuesday.zip]] ^ ^ Format ^ Trainers ^ Topic of the lecture ^ ^Tuesday |||| ^09:15-09:30||Alex Gocht|Summary "learned so far" | ^09:30-10:30|VL/[[https://cloud.capri-model.org/index.php/s/LQxX2kQ4qKqe59j|ppt]]/[[https://cloud.capri-model.org/index.php/s/FMFLwDGRitGYBJQ|Excel]]/[[https://cloud.capri-model.org/index.php/s/Cp4q9tLxtWGWPiy|GAMS]]|Davit Stepanyan|[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.3._calibration_of_the_supply_module |2.3. Calibration of the Supply module]]| ^10:30-11:00| |Coffee Break|| ^11:00-12:00|VL/ppt/Excel/GAMS|Davit Stepanyan|[[ https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.4._test_calibration | 2.4 Test Calibration]]| ^12:00-13:30| |Lunch|| ^13:30-15:00|[[https://cloud.capri-model.org/index.php/s/Po4nySfFzsN39yc|ppt]]/hand-on|[[https://www.thuenen.de/de/fachinstitute/betriebswirtschaft/personal/wissenschaftliches-personal/pignotti-davide-m-sc|Davide Pignotti]] (breakout session)|[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=2.5._shock_1_price_shock_for_cow_milk | 2.5. Shock 1 price shock for cow milk]] | ==== Third day ==== * download 1: [[https://cloud.capri-model.org/index.php/s/RP4JztszE8Hwopp|wednesday_1_YieldShock.zip]] * download 2: [[https://cloud.capri-model.org/index.php/s/TG6K9iM7zoyFn7s|wednesday_2_Intro_market.zip]] ^ ^Format ^Trainers^Topic of the lecture ^ ^Wednesday |||| ^09:15-09:30|ppt/hand-on |Alex Gocht|Summary "learned so far" | ^09:30-10:45|[[https://cloud.capri-model.org/index.php/s/RATx3SAybj5kXrD | ppt]]/hand-on (pr) |[[https://scholar.google.com/citations?user=SqDp-D8AAAAJ&hl=en/|Jordan Hristov]] (breakout session) |[[2.6. Shock 2 Yield with and without market]]| ^11:00-12:30|[[https://cloud.capri-model.org/index.php/s/ooyDk82g9GRR8Si|ppt]]|[[|Davit & Alex]]|[[https://www.capri-model.org/ts/dokuwiki/doku.php?id=3._introduction_to_market_module | 3. Introduction to market module]] | ^12:30-13:30| |Lunch|| ^13:30-15:00|[[https://cloud.capri-model.org/index.php/s/RCwantsx4SqTxEe|ppt]]|[[https://agrifood.se/engStaffDetail.aspx?fKeyID=16|Torbjörn Jansson (SLU)]]|| ==== Fourth day ==== download 1: [[https://cloud.capri-model.org/index.php/s/Hk4YmgH7W53YP9M|biofuel.zip]] download 2: [[https://cloud.capri-model.org/index.php/s/5sJk7pTxX39HEc7|human_consumption.zip]] ^ ^Format ^Trainers^Topic of the lecture ^ ^ Thursday |||| ^09:15-09:30 |ppt/Hand on |Alex Gocht|Summary "learned so far"| ^09:30-10:30 |ppt/Hand on (continuation of the introduction to the market model) |Alex (breakout session)|3.1. Import Ban| ^10:45-11:45 |[[https://cloud.capri-model.org/index.php/s/5RH9NTe53pSTnn2 | ppt]]/Hand on |[[https://www.thuenen.de/en/institutes/farm-economics/staff/scientific-staff/rieger-joerg-dr |Jörg Rieger]] (breakout session) |[[3.2. Shock 2 Human consumption]]| ^11:45-12:30 |[[https://cloud.capri-model.org/index.php/s/R5YQar7ryMHEPbQ | ppt]]/Hand on |[[ https://www.thuenen.de/de/fachinstitute/betriebswirtschaft/personal/wissenschaftliches-personal/thom-ferike-m-sc|Ferike Thom]] (breakout session)|[[3.3. Shock 3 Biofuels]]| ^13:30-15:00 |ppt/Hand on |all |[[tbd + feedback round]]| Download: all result gdx files: [[https://cloud.capri-model.org/index.php/s/Y2mSHK2YaS82aAE | zip of all results]]\\ ==== IV: Student Course work ==== ^ ^Format ^Trainers^Topic of the lecture ^ ^2nd. October - 5th October |||| ^ full day | discussion| all| definition of groups and first discussion for scenario implementation|