4.3T2 Training Materials: Quiz "Crop Production" (original) (raw)
Quiz: "Crop Production"
(Please write down your answers in a notebook or a white sheet and compare them with the answers enlisted at the end of this section.)
The computation of crop production is the third calculation step in the FABLE Calculator, carried out in the worksheet 3_calc_crops. Let us trace the formulas which connect the different tables, while exercising reading and translating formulas into words, as well as understanding the causal links.
The following formulas make the link between how human demand of crops and livestock demand of feed are converted into planted area. Try to convert these into words to explain what they are actually doing.
1.- calc_crops[consohum] =SUMIFS(calc_hum_demand[cotot],calc_hum_demand[fproduct],[@FPRODUCT],calc_hum_demand[year],[@YEAR])
2.- calc_crops[ProdFproduct] =([@consohum]+[@feed]+[@finalExports])/(1-[@shlossfproduct])-[@stockvar]-[@finalImports]
3.- calc_crops[ProdCrop] =IF([@ProcCoef]=1,[@ProdFproduct],[@ProdInput])
4.- calc_crops[PlantArea] =IFERROR([@Harvarea]/[@HarvInt], "")
5.- calc_land_cor[CalcPlantArea]=SUMIFS(calc_crops[PlantArea],calc_crops[YEAR],[@Year]
Answers:
1.- The first step of the calculation of crop production is the calculation of human demand of crop products, done in the worksheet 1_calc_human_demand. This happens in the table calc_crops, in the last column of Table 3.C, called “consohum”, where a SUMIF function recalls the value from the table calc_hum_demand, calumn “cotot”, with matches the same FPRODUCT and year of the current row.
2.- The calculation of crop production entails the combination of the different economic processes which all agricultural goods undergo in a country. This calculation is captured in the table calc_crops, in the column “ProdFproduct”, which obtains the human demand of all crops, adds to it the feed demand and the final exports, and divides this sum by the share of loss of product. To this result, imports and stock variations is substracted
3.- The calculation of crop production entails two steps: production of final products and production of inputs to production. This differentiation is captured in the table calc_crops, in the column “ProdCrop”, with a logical formula that separates those goods that are considered processing inputs (when proccoef=1), from those who are not.
4.- The output of the calculation of crop production is the conversion of final production into the total planted area that this production requires. This is done in the following columns, between Prdo Crop and PlantArea, taking into account productivity and harvest intensity. The basic calculation of PlantArea is a division of harvested area by harvesting intensity. This division can sometimes yield a zero, or an undefined value if either of these indicators is equal to zero. For this reason, an Excel function called IFERROR is used, which will substitute any message of error given by such impossible division, for whatever value we indicate in the second part of the formula, in this case, a space “”.
5.- Finally, the values that result from the worksheet 3_calc_crops are those for calc_crops[PlantArea], which are recalled in the table[column] calc_land_cor[CalcPlantArea], by simply transferring values between both worksheets, for the same year of the current row.