User Tools

Site Tools


Course Overview

Applied Data Analysis: Introduction to and Application of the Partial Equilibrium Model CAPRI in Market and Policy Analysis 2022


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, Sebastian Neuenfeldt with contributions of core developers of the CAPRI network such as Maria Blanco, Mihaly Himics, Torbjörn Jansson, Jordan Hristov.

Format of the course

I: Self Study: Self-study tutorial using CAPRI (deadline for the home work: 29th of August 2022)

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

II: GAMS lectures (31.August 2022 - 2nd September)

Time/DateTopic of the lectureDownload pptx GAMS Example all exercises as zip
1st Day
09:00 - 09:45 GAMS modeling language. General introduction Slides
10:00 - 10:45 MyFarm LP modelin Excel; Main elements of a GAMS model Exercise 1 - MyFarm in Excel_solution
11:00 - 11:45 Coding MyFarm LP model in GAMS; Solver output Exercise 2 - MyFarm in GAMS
12:15 - 13:00 Solver output; Improving the efficiency. Sets, Subsets, Alias, Sum 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 Exercise 4_data export,Exercise 5_data import,Exercise 5_data.xlsx
11:00 - 11:45 Introducing common income support schemes Slides
12:15 - 13:00 Scenario analysis with GAMS for VCS and decoupling support schemes. Exercise 6
3rd Day.
09:00 - 09:45 Production Quota see Exercise 6
10:00 - 10:45 Crop nutrient need in MyFarm Exercise 7
11:00 - 11:45 Fertilizer pricing and purchasing Exercise 8,Exercise 9
12:15 - 13:00 Feedback round

III: An intensive 4-day: Lecture & Computer exercises (19th September - 22nd of September 2022)

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


Format TrainersTopic of the lecture
Monday 19. Sep
09:15-10:00pptAlex Gocht1.1. Overview of the course / Reminder Structure CAPRI and GUI
10:15-11:00ppt/hands-on Alex (breakout session) 1.2 GUI Policy editor
11:00-11:15 Coffee Break
11:15-12:00ppt/hands-on Alex Gocht (breakout session) 2.1. Shock: Input price changes for mineral fertilizer with and without market
12:00-13:00 lunch
13:00-13:45ppt/hands-on Alex Gocht 2.2. Data of the Supply Module
14:00-14:45ppt/hands-onMaria Blanco 2.3. Overview Supply Module

Second Day


Format Trainers Topic of the lecture
Tuesday 20. Sep
09:15-09:30ppt/hand-onAlex GochtSummary “learned so far”
09:30-10:30VL/ppt/Excel/GAMSDavit Stepanyan2.3. Calibration of the Supply module
10:30-11:00 Coffee Break
11:00-12:00VL/ppt/Excel/GAMSDavit Stepanyan 2.4 Test Calibration
12:00-13:30 Lunch
13:30-15:00ppt/hand-onAlex Gocht 2.5. Shock 1 price shock for cow milk

Third day


Format TrainersTopic of the lecture
Wednesday 21st Sep
09:15-09:30ppt/hand-on Alex GochtSummary “learned so far”
09:30-10:45ppt/hand-on (pr) Jordan Hristov (breakout session) 2.6. Shock 2 Yield with and without market
11:00-12:30ppt Torbjörn Jannson (SLU) Application with CAPRI
12:30-13:30 Lunch
13:30-15:00ppt Mihaly Himics 3. Introduction to market module

Fourth day


Format TrainersTopic of the lecture
Thursday 22nd Sep
09:15-09:30 ppt/Hand on Alex GochtSummary “learned so far”
09:30-10:30 ppt/Hand on Davide Pignotti (breakout session)3.1. Shock 1 GDP changes
10:45-11:45 ppt/Hand on Jörg Rieger (breakout session) 3.2. Shock 2 Human consumption
11:45-12:30 ppt/Hand on Mihaly Himics (breakout session)3.3. Shock 3 Biofuels
13:30-15:00 ppt/Hand on all tbd + feedback round

Download: all scenario files:
Download: batch file:
Download: all result gdx files: zip of all results
Download: Additional reading materials

IV: Student Course work

Format TrainersTopic of the lecture
26. September
15:15-16:30 discussion all definition of groups and first discussion for scenario implementation
27. September
10:00-16:00 discussion all group work supported by teachers
28. September
10:00-12:00 discussion all group work supported by teachers


start.txt · Last modified: 2022/11/07 10:23 by