4.2T2 Training Materials: Quiz "Livestock Production" (original) (raw)
Quiz: "Livestock 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 the production from the livestock sector is the second step in the FABLE Calculator. The livestock sector supplies animal food products and consumes other agricultural products for animal feed. These calculations in the FABLE model are carried out in the worksheet 2_calc_livestock. 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.
For each of the following formulas making this link between Herd and Pasture, please convert them into words and explain what they are actually doing.
1.- calc_livestocknb [RealHerd]=IFERROR([@herdcount]*[@herd],"")
2.- calc_feed[herd] =SUMIFS(calc_livestocknb[RealHerd],calc_livestocknb[ANIMAL_GLOBIOM],[@[ANIMAL_GLOBIOM]],calc_livestocknb[YEAR],[@YEAR])
3.- calc_feed[cofeed]= [@feedreq]*[@herd]
4.- Calc_pasture[Herd] =SUMIFS(calc_livestocknb[RealHerd],calc_livestocknb[ANIMAL_GLOBIOM],[@[ANIMAL_GLOBIOM]],calc_livestocknb[YEAR],[@YEAR])
5.- Calc_pasture[Pasture] =[@Herd]/[@RumDensity]
Answers:
1.- The first column to calculate the amount of herd needed to satisfy human demand of livestock products is in table 2.A called calc_livestocknb, in the column called “RealHerd”. It does so by multiplying a column called “herd” with another one called “herdcount”. This multiplication 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 “”.
2.- The value obtained in question 1.- is then recalled into the table calc_feed, column called “herd”, in order to calculate total feed requirements. This is done by recalling with a SUMIFS function, from table 2.A called calc_livestocknb, in the column called “RealHerd”, for the ANIMAL_GLOBIOM category of the same row, and for the same year, in both tables. Please note the content of the column ANIMAL_GLOBIOM. Trace back the table from where these categories are defined, called “MapAnimal” and have a clear idea of what this column is pointing to.
3.- The computation of livestock feed requirements takes place in the table calc_feed, in the column [cofeed], which is basically a multiplication between the feed requirements per animal, times the total amount of animals, or herd.
4.- The value obtained in question 1.- is then recalled into the table calc_pasture column called “Herd”, in order to calculate total feed requirements. This is done by recalling with a SUMIFS function, from table 2.A called calc_livestocknb, in the column called “RealHerd”, for the ANIMAL_GLOBIOM category of the same row, and for the same year, in both tables. Please note the content of the column ANIMAL_GLOBIOM. Trace back the table from where these categories are defined, called “MapAnimal” and have a clear idea of what this column is pointing to.
5.- The final output of the 2_calc_livestock worksheet is pasture, measured in 1000 ha. This calculation takes place in table 2.I called calc_pasture, in the column called “Pasture”, and is basically a division between the amount of herd and the ruminant density, both columns found in the same table 2.1