Table of Contents
Course Overview
Applied Data Analysis: Introduction to and Application of the Partial Equilibrium Model CAPRI in Market and Policy Analysis 2025
Registration in moodle | Agnes
Create new external moodle account: here
Online Participation - Zoom Link: here
GAMS License: here
Important other Links
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 with the support of Davit Stepanyan, Davide Pignotti, Ferike Thom, Jörg Rieger with contributions of core developers of the CAPRI network such as Maria Blanco, Torbjörn Jansson, Caetano Beber.
Download CAPRI
- Download Version: model250512114725.zip
- Download result data base: results250512114725.zip
- Download result scenario NoVCS: Novcs_withMM.zip
- Download xml file: new_xml_file
- Download reference file for whole supply model: ref.zip
2nd Exam Zoom Link
Please join the exam by the following link: Link
1. Introduction to CAPRI and GAMS course – First day: 17 April 2025, 12:00–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides_Lecture1 | Ferike ThomDavide Pignotti | GAMS modeling language; General introduction |
| 13:00 - 13:45 | Exercise 1 - MyFarm in ExcelExercise 1 - Solution | Ferike ThomDavide Pignotti | MyFarm LP modeling Excel; Main elements of a GAMS model |
| 14:15 - 15:00 | Exercise 2 - MyFarm in GAMS | Ferike ThomDavide Pignotti | Coding MyFarm LP model in GAMS; Solver output |
| 15:15 - 16:00 | Exercise 3 - MyFarm_sets&sumExercise 3 from scratch | Ferike ThomDavide Pignotti | Solver output; Improving the efficiency. Sets, Subsets, Alias, Sum |
2. GAMS Course – Second day: 24 April 2025, 12:00–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides_Lecture2 | Davit Stepanyan | Introducing Sets and the Sum operator in MyFarm LP & useful statements |
| 13:00 - 13:45 | Exercise 4_data export,Exercise 5_data import,Exercise 5_data.xlsx | Davit Stepanyan | Data exchange with Excel |
| 14:15 - 15:00 | Exercise 6 | Davit Stepanyan | Scenario analysis with GAMS for VCS and decoupling support schemes |
| 15:15 - 16:00 | see Exercise 6 | Davit Stepanyan | Production Quota |
3. GAMS Course – Third day: 15 May 2025, 12:00–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides_Ex7-11,Exercise 7 | Alex GochtFerike Thom | Crop nutrient need in MyFarm |
| 13:00 - 13:45 | Exercise 8,Exercise 9 | Alex GochtFerike Thom | Fertilizer pricing and purchasing |
| 14:15 - 15:00 | Exercise 10 | Alex GochtFerike Thom | Intro to partial equilibrium market model |
| 15:15 - 16:00 | Exercise 11 | Alex GochtFerike Thom | Intro to CAPRI market model |
4. CAPRI Introduction - Forth day: 22 May 2025, 12:00-16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides | Alex GochtDavide Pignotti | Setting up the system |
| 13:00 - 13:45 | Torbjörn Jansson (SLU) | Structure of CAPRI | |
| 14:15 - 15:00 | Alex GochtDavide Pignotti | Using CAPRI with the GUI | |
| 15:15 - 16:00 | Alex GochtDavide Pignotti | Running your first simulation | |
5. CAPRI Introduction: Analyzing results - Fifth day: 05 June 2025, 12:00-16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides | Davit StepanyanDavide Pignotti | Loading Results |
| 13:00 - 13:45 | Davit StepanyanDavide Pignotti | Navigating the Result Viewer | |
| 14:15 - 15:00 | Davit StepanyanDavide Pignotti | In-depth exercises | |
| 15:15 - 16:00 | Davit StepanyanDavide Pignotti | In-depth exercises | |
6. Presentation of Selected Studies with CAPRI – Sixth day: 12 June 2025, 12:00-16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:00 - 12:45 | Slides | Torbjörn Jansson (SLU) | Border Carbon Adjustments in agri-food markets |
| 13:00 - 13:45 | Slides | Prof. Harald Grethe (HU Berlin, AgoraAgrar) | Agriculture, forestry and food in a climate neutral EU |
| 14:15 - 15:00 | Slides | Peter Witzke (EuroCARE) | Implementation options for partial ETS variants for the agri-food sector |
| 15:15 - 16:00 | Slides | Alex Gocht (Thuenen Institute) | Fertilizing Climate Policy |
7. CAPRI Supply Module – Seventh day: 19 June 2025, 12:15–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:15-13:15 | ppt | Alex Gocht | 2.1. Shock: Input price changes for mineral fertilizer with and without market |
| 13:30-14:15 | ppt | Alex Gocht | 2.3. Overview Supply Module |
| 14:30-15:15 | ppt | Alex Gocht | 2.2. Data of the Supply Module |
| 15:30-16:00 | Slides | Torbjörn Jansson (SLU) | Input and output accounting in the supply model Excel_Demo |
8. CAPRI Supply Module – Eighth day: 26 June 2025, 12:15–16:00.
file conopt4.opt to be copied to the gams folder in CAPRI
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:15-12:30 | Davit Stepanyan | Summary “learned so far” | |
| 12:30-13:30 | VL/ppt/Excel/GAMS | Davit Stepanyan | 2.3. Calibration of the Supply module |
| 13:45-14:30 | VL/ppt/Excel/GAMS | Davit Stepanyan | 2.4 Test Calibration |
| 14:45-16:00 | Slides | Davide Pignotti | 2.5. Shock 1 price shock for cow milk |
9. CAPRI Market Module – Ninth day: 3 July 2025, 12:15–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:15-12:30 | ppt/hand-on | Alex Gocht | Summary “learned so far” |
| 12:30-13:45 | ppt | Caetano Beber (JRC) | 2.6. Shock 2 Yield with and without market |
| 14:15-16:15 | pdf, pptx, DatabaseofCAPRI.gdx, res_2_1730_tradeWarwithChinadefaultA.gdx, res_2_1730cap_after_2014_refdefaultA.gdx | Torbjoern Jansson & Alex Gocht | 3. Introduction to market module |
10. CAPRI Market Module – Tenth day: 10 July 2025, 12:15–16:00.
| Time | Material | Trainers | Topic of the lecture |
|---|---|---|---|
| 12:15-13:15 | pdf pptx/Hand on (continuation of the introduction to the market model) | Ferike Thom | 3.1. Import Ban Soy in China |
| 13:15-14:15 | ppt/Hand on | Jörg Rieger | 3.2. Shock 2 Human consumption |
| 14:15-15:15 | ppt/Hand on | Ferike Thom | 3.3. Shock 3 Biofuels |
| 15:15-16:00 | all | Wrap-Up + feedback round |
Slidos for Exam Preparation
The slido questions are exemplary of the exam questions, so we will not share any additional “mock exam questions” beforehand. slido 2.3 Calibration of supply module| slido GAMS intro M| slido 3.1 Market model Intro|
Acknowledgment
| BrightSpace and ACT4CAP27 are funded by the European Union. Horizon Europe Grant Agreement Numbers: BrightSpace 101060705/ACT4CAP27 101134874. Views and opinions expressed are however those of the authors only and do not necessarily reflect those of the European Union or the European Commission. Neither the European Union nor the granting authority can be held responsible for them. |  |