the_capri_data_base
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
the_capri_data_base [2021/12/14 11:22] – [Annex: Testing procedure and checking intermediate steps in COCO (biofuels)] himics | the_capri_data_base [2021/12/14 13:32] – [Annex: Testing procedure and checking intermediate steps in COCO (dairy)] himics | ||
---|---|---|---|
Line 1201: | Line 1201: | ||
The COCO module produces various reporting files on the intermediate data processing steps. These files can be used to trace back potential errors in the COCO database to their origin. These debugging files also contain meta-information on the input data and settings used for producing the COCO database. | The COCO module produces various reporting files on the intermediate data processing steps. These files can be used to trace back potential errors in the COCO database to their origin. These debugging files also contain meta-information on the input data and settings used for producing the COCO database. | ||
+ | The following example is a walk-through on the typical data processing steps, covring biofuels data preparation in France. | ||
- | In addition | + | The reporting file ' |
+ | |||
+ | {{coco_biof_1.png? | ||
+ | |||
+ | The set // | ||
+ | |||
+ | {{coco_biof_2.png? | ||
+ | |||
+ | The complete list of the biofuel items in // | ||
| bioECere | Ethanol processed from cereals | | | bioECere | Ethanol processed from cereals | | ||
Line 1226: | Line 1235: | ||
| INDt | Sum of model results for BIOF and INDM | | | INDt | Sum of model results for BIOF and INDM | | ||
| BIOi, INDi, DOMi | intermediate activities to save data from model initialisation for later documentation. | | | BIOi, INDi, DOMi | intermediate activities to save data from model initialisation for later documentation. | | ||
+ | |||
+ | |||
+ | Biofuels production (levels) are calculated for biodiesel (BIOD) and bioethanol (BIOE). Input data and final initialization values before the consistency models are run are documented on the parameter // | ||
+ | |||
+ | |||
+ | |||
+ | **Example 1: Bioethanol** | ||
+ | |||
+ | The screenshot demonstrates the input data and final initialization values collected on parameter // | ||
+ | |||
+ | {{coco_biof_3.png? | ||
+ | |||
+ | The results of the model m_bioFitE (BIOE) are documented on the parameter p_biofDatatMS. | ||
+ | |||
+ | {{coco_biof_4.png? | ||
+ | |||
+ | We take soft wheat (SWHE) as an example for biofuel feedstock, and walk through the initialization and consistency model results. From data input (Eurostat and FAO) we received in 2002 an industrial use of 894 1000t, saved on INDi. For production of bio-ethanol 631 1000t were initialized, | ||
+ | |||
+ | |||
+ | |||
+ | **Example 2: Biodiesel** | ||
+ | |||
+ | |||
+ | The first dimension of the reporting parameter // | ||
+ | The second dimension of the parameter shows the activity. | ||
+ | |||
+ | {{coco_biof_5.png? | ||
+ | |||
+ | For Bio-diesels, | ||
+ | |||
+ | ^Data source code ^Data source description ^ | ||
+ | |Primes |PRIMES MODEL, EC3MLAB of ICCS, National University of Athens| | ||
+ | |||
+ | {{coco_biof_6.png? | ||
+ | |||
+ | The parameter // | ||
Line 1231: | Line 1276: | ||
====Annex: Testing procedure and checking intermediate steps in COCO (dairy)==== | ====Annex: Testing procedure and checking intermediate steps in COCO (dairy)==== | ||
- | The following three examples show how to use the intermediate reporting files to trace the data preparation steps. Screenshots demonstrate the arrangement of the reporting parameters by using the CAPRI Graphical User Interface. | + | The following three examples show how to use the intermediate reporting files to trace the data preparation steps. Screenshots demonstrate the arrangement of the reporting parameters by using the CAPRI Graphical User Interface. |
+ | |||
+ | |||
+ | **Example 1: Production of cow (COMI) and sheep (SGMI) milk** | ||
+ | |||
+ | In order to document the procedure of data consolidation and rebooking, we look at the reporting file for France “chk_estima_FR000.gdx”. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | The codes in the rows show the activity code, the product code and its status. For activity codes see Annex 1: Code list. | ||
+ | |||
+ | Status codes: | ||
+ | |||
+ | * INI: | ||
+ | * COCO1: | ||
+ | |||
+ | The initialization of the production of COMI and SGMI is done in the module // | ||
+ | |||
+ | * COMI: Milk from cows (CMLK) and buffaloes (BMLK) is added up. | ||
+ | * SGMI: Milk from ewes (EMLK) and goats (GMLK) is added up. | ||
+ | * If data on cow or sheep and goat milk is not available separately, but total milk production (RMLK) is available, then production of COMI is set equal to total milk production. | ||
+ | * Only COMI and SGMI are included in the estimation in // | ||
+ | * The production of RMLK and its components CMLK, BMLK, EMLK and GMLK are only copied from raw data tables into this check parameter for documentation purposes. | ||
+ | |||
+ | |||
+ | ** Example 2: data consolidation for cow milk** | ||
+ | |||
+ | The procedure of data consolidation and rebooking of all activities for the CAPRI product “COMI” (cow milk) is shown in the following screenshot (only part of the reporting parameter p_estimAnimMS is shown, but the full scope of the table is visible in the GUI). | ||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | The codes in the rows show the activity code and its status. For activity codes see Annex 1: Code list. | ||
+ | Additional codes for status include the following. | ||
+ | |||
+ | ^Status code | ||
+ | |StdeData |Final (small) Stde (standard deviation) attached to priors from raw data | | ||
+ | |StdeScale |Final (large) Stde attached to priors from trends but not from raw data | | ||
+ | |Upplim |Soft upper limits triggering extra penalties if violated | ||
+ | |Lowlim |Soft lower limits triggering extra penalties if violated | ||
+ | |Supps |Prior value = support: comes from raw data or trends plus HP filter | ||
+ | |Err2rev |Original error term from preest: to steer speed of bound opening | ||
+ | |||
+ | |||
+ | Under activity dairy cows (DCOW) the following items are reported: yield, total production (GROF), feed use (FEDM) and losses on market (LOSM). Eurostat’s //National Accounts of Agriculture (EAA)// only supply data for the aggregate milk (MILK). The equation // | ||
+ | |||
+ | <code gams> | ||
+ | e_EAAMLK(" | ||
+ | $ (p_NobsP(" | ||
+ | (p_NobsP(" | ||
+ | * | ||
+ | v_EstimY(" | ||
+ | | ||
+ | + v_EstimY(" | ||
+ | |||
+ | </ | ||
+ | |||
+ | Finally. the producer prices (UVAP) are calculated directly from the monetary EEA values and production. | ||
+ | The following picture shows the data processing steps (states) for the EAA values for milk. | ||
+ | |||
+ | {{: | ||
===== The Regionalised Data Base (CAPREG) ===== | ===== The Regionalised Data Base (CAPREG) ===== | ||
==== Data requirements and sources at the regional level ==== | ==== Data requirements and sources at the regional level ==== |
the_capri_data_base.txt · Last modified: 2024/07/05 06:24 by massfeller