{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Table 1","Table 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table 1","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,2,2,4],[3,23,3,24],[3,43,3,44],[4,2,4,4]]}
["Table 1. National level crop yield data for 1995-2014 (FAOSTAT, 2017). Yields are converted to 'edible' equivalents using FAO technical conversion factors (FAO, 1972, Technical Conversion Factors for Agricultural Commodities)"]
[]
[null,"FAOSTAT item","FAO technical conversion factors"]
[null,null,"Waste","Extraction and seeding rate","Value fraction","Yields (kg/ha)","Edible yields (kg/ha)"]
[null,null,"Proportion",null,null,2014,2014]
[null,"Apples",0.1,1,1,7978.8,{"$f":"F6*(1-$C6)*$D6*(1/$E6)","v":7180.92}]
[null,"Bananas",0.2,1,1,37036.699999999997,{"$f":"F7*(1-$C7)*$D7*(1/$E7)","v":29629.360000000001}]
[null,"Barley",0,0.7,1,2723.2,{"$f":"F8*(1-$C8)*$D8*(1/$E8)","v":1906.2399999999998}]
[null,"Beans, dry",0.04,0.92,1,411,{"$f":"F9*(1-$C9)*$D9*(1/$E9)","v":362.99520000000001}]
[null,"Cabbages and other brassicas",0.05,1,1,22590.1,{"$f":"F10*(1-$C10)*$D10*(1/$E10)","v":21460.594999999998}]
[null,"Cassava",0.05,1,1,35655.5,{"$f":"F11*(1-$C11)*$D11*(1/$E11)","v":33872.724999999999}]
[null,"Chick peas",0.02,0.95,1,995.3,{"$f":"F12*(1-$C12)*$D12*(1/$E12)","v":926.62429999999983}]
[null,"Chillies and peppers, green",0.1,1,1,8491.6,{"$f":"F13*(1-$C13)*$D13*(1/$E13)","v":7642.4400000000005}]
[null,"Cocoa, beans",0,0.53,1,211.3,{"$f":"F14*(1-$C14)*$D14*(1/$E14)","v":111.98900000000002}]
[null,"Coconuts",0.03,1,1,5177,{"$f":"F15*(1-$C15)*$D15*(1/$E15)","v":5021.6899999999996}]
[null,"Coffee, green",1.4999999999999999E-2,1,1,798.6,{"$f":"F16*(1-$C16)*$D16*(1/$E16)","v":786.62099999999998}]
[null,"Fruit, citrus nes",0.1,1,1,13078.9,{"$f":"F17*(1-$C17)*$D17*(1/$E17)","v":11771.01}]
[null,"Fruit, tropical fresh nes",0.15,1,1,11329.9,{"$f":"F18*(1-$C18)*$D18*(1/$E18)","v":9630.4149999999991}]
[null,"Grapefruit (inc. pomelos)",0.1,1,1,23288,{"$f":"F19*(1-$C19)*$D19*(1/$E19)","v":20959.2}]
[null,"Grapes",0.1,1,1,21773.1,{"$f":"F20*(1-$C20)*$D20*(1/$E20)","v":19595.79}]
[null,"Groundnuts, with shell",0.03,0.62,1,1399.6,{"$f":"F21*(1-$C21)*$D21*(1/$E21)","v":841.71943999999985}]
[null,"Lemons and limes",0.1,1,1,9898.5,{"$f":"F22*(1-$C22)*$D22*(1/$E22)","v":8908.65}]
[null,"Maize",2.3E-2,0.8,1,2556.6999999999998,{"$f":"F23*(1-$C23)*$D23*(1/$E23)","v":1998.31672}]
[null,"Mangoes, mangosteens, guavas",0.1,1,1,7325.7,{"$f":"F24*(1-$C24)*$D24*(1/$E24)","v":6593.13}]
[null,"Millet",0.01,0.93,1,1282.5999999999999,{"$f":"F25*(1-$C25)*$D25*(1/$E25)","v":1180.8898199999999}]
[null,"Oilseeds nes",0,0.36,1,317.39999999999998,{"$f":"F26*(1-$C26)*$D26*(1/$E26)","v":114.26399999999998}]
[null,"Onions, dry",0.05,1,1,16120.1,{"$f":"F27*(1-$C27)*$D27*(1/$E27)","v":15314.094999999999}]
[null,"Oranges",0.1,1,1,11005.4,{"$f":"F28*(1-$C28)*$D28*(1/$E28)","v":9904.86}]
[null,"Peas, dry",0.1,1,1,821.9,{"$f":"F29*(1-$C29)*$D29*(1/$E29)","v":739.71}]
[null,"Pepper (piper spp.)",0.1,1,1,411.3,{"$f":"F30*(1-$C30)*$D30*(1/$E30)","v":370.17}]
[null,"Pineapples",0.1,1,1,15805.8,{"$f":"F31*(1-$C31)*$D31*(1/$E31)","v":14225.22}]
[null,"Potatoes",0.16,0.92,1,22922.400000000001,{"$f":"F32*(1-$C32)*$D32*(1/$E32)","v":17714.43072}]
[null,"Rice, paddy",0,0.66,1,3584.5,{"$f":"F33*(1-$C33)*$D33*(1/$E33)","v":2365.77}]
[null,"Sesame seed",2.2000000000000002E-2,0.99,1,456.1,{"$f":"F34*(1-$C34)*$D34*(1/$E34)","v":441.605142}]
[null,"Sorghum",0.01,0.95,1,926.1,{"$f":"F35*(1-$C35)*$D35*(1/$E35)","v":870.99705000000006}]
[null,"Soybeans",4.4999999999999998E-2,0.94,1,965.2,{"$f":"F36*(1-$C36)*$D36*(1/$E36)","v":866.46003999999994}]
[null,"Spices, nes",0,1,1,2211.8000000000002,{"$f":"F37*(1-$C37)*$D37*(1/$E37)","v":2211.8000000000002}]
[null,"Sugar cane",0,0.11,1,70259.8,{"$f":"F38*(1-$C38)*$D38*(1/$E38)","v":7728.5780000000004}]
[null,"Sweet potatoes",0.05,1,1,10275.6,{"$f":"F39*(1-$C39)*$D39*(1/$E39)","v":9761.82}]
[null,"Tea",0.01,1,1,1998.9,{"$f":"F40*(1-$C40)*$D40*(1/$E40)","v":1978.9110000000001}]
[null,"Tomatoes",0.1,1,1,21241.8,{"$f":"F41*(1-$C41)*$D41*(1/$E41)","v":19117.62}]
[null,"Wheat",1.4999999999999999E-2,0.9,0.8,3145.7,{"$f":"F42*(1-$C42)*$D42*(1/$E42)","v":3485.8288124999995}]
[null,"Oilcrops Primary",0,1,1,278.8,{"$f":"F43*(1-$C43)*$D43*(1/$E43)","v":278.8}]
[null,"Treenuts,Total",0.02,1,1,763.9,{"$f":"F44*(1-$C44)*$D44*(1/$E44)","v":748.62199999999996}]

{"sheet":"Table 2","index":1,"n_rows":25,"n_cols":24,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,3,7,11],[7,16,7,18],[4,16,4,18],[5,3,5,5],[5,8,5,10],[5,17,5,18],[5,20,5,21]]}
["Table 2. (a) Components of feed and feed conversion efficiencies for livestock products [Mekonnen & Hoekstra (2010) The green, blue and grey water footprint of farm animals and animal products. Value of Water Research Report Series No. 48]. (b) Conversion of root products to derived products. The product fraction is defined as the quantity of the processed product obtained per quantity of root product; the value fraction is defined as the ratio of the market value of the product to the aggregated market value of all the products obtained from the root product [Hoekstra & Chapagain, Globalization of Water: Sharing the Planet's Freshwater Resources. Blackwell Publishing, 2008 - Appendix I - Analytical Framework for the Assessment of Virtual-Water Content, Virtual-Water Flows, Water Savings, Water Footprints, and Water Dependencies]. For example, the root product of ghee is milk, and 5 g of ghee can be derived from 100 g of milk, with the ghee representing 28% of the economic value of the derived products. "]
[]
[]
[null,"(a) Components of feed and feed conversion efficiencies for livestock products"]
[{"$nulls":14},"Feed conversion efficiency",null,"Feed requirement"]
[null,null,"Production system","Concentrates",{"$nulls":4},"Roughages",{"$nulls":7},"Concentrate","Roughage",null,null,"Yield",null,null,"Land requirement grass"]
[null,null,null,"cereals","oilmeals","other concentrates","All concentrates",null,"Residues and fodder","Grass","Scavenging","All roughages",{"$nulls":5},"grass","non-grass",null,null,"Grass"]
[null,null,null,"%-age of total feed",{"$nulls":10},"mass feed:product",null,"kg/kg product",null,null,null,"t feed/ha",null,null,"ha/kg feed"]
[null,"Dairy cattle/buffalo","Average",1.8222985759912462,0.27054406339081288,0.91114516061794082,3.0039878,null,36.557314015273249,30.239289742363379,30.239289742363379,97.0358935,null,"Dairy cattle/buffalo",2.2000000000000002,null,{"$f":"(G9/100)*$O9","v":6.6087731600000005E-2},{"$f":"(J9/100)*$O9","v":0.66526437433199437},{"$f":"((I9+K9)/100)*$O9","v":1.4695252826680061},null,null,4,null,{"$f":"R9/(V9*1000)","v":1.6631609358299859E-4}]
[null,"Sheep/goat","Average",1.4850486112603882,0,2.475069806999612,3.9601184182600004,null,4.9401775689238097,45.059822444802847,46.047060286273336,96.047060299999998,null,"Sheep/goat",21.8,null,{"$f":"(G10/100)*$O10","v":0.86330581518068006},{"$f":"(J10/100)*$O10","v":9.8230412929670212},{"$f":"((I10+K10)/100)*$O10","v":11.115217852432977},null,null,4,null,{"$f":"R10/(V10*1000)","v":2.4557603232417554E-3}]
[null,"Pig","Average",23.227619165004484,3.9038987941274601,13.147649404057258,40.279167363189202,null,59.720832636810798,0,0,59.720832636810798,null,"Pig",5.8,null,{"$f":"(G11/100)*$O11","v":2.3361917070649736},{"$f":"(J11/100)*$O11","v":0},{"$f":"((I11+K11)/100)*$O11","v":3.4638082929350258},null,null,4,null,{"$f":"R11/(V11*1000)","v":0}]
[null,"Poultry_broiler","Average",58.210539877552499,18.613788674441949,14.552569048005557,91.376897599999992,null,8.6231024000000005,0,0,8.6231024000000005,null,"Poultry_broiler",5.8,null,{"$f":"(G12/100)*$O12","v":5.2998600607999995},{"$f":"(J12/100)*$O12","v":0},{"$f":"((I12+K12)/100)*$O12","v":0.50013993919999999},null,null,4,null,{"$f":"R12/(V12*1000)","v":0}]
[null,"Poultry_layer","Average",58.210539877552499,18.613788674441949,14.552569048005557,91.376897599999992,null,8.6231024000000005,0,0,8.6231024000000005,null,"Poultry_layer",3.6,null,{"$f":"(G13/100)*$O13","v":3.2895683135999998},{"$f":"(J13/100)*$O13","v":0},{"$f":"((I13+K13)/100)*$O13","v":0.31043168640000002},null,null,4,null,{"$f":"R13/(V13*1000)","v":0}]
[]
[]
[null,"(b) Conversion of root products to derived products"]
[]
[null,null,"Proportion wasted","Product fraction","Value fraction"]
[null,"Ghee",1.2000000000000011E-2,5.3999999999999999E-2,0.27503882958715858]
[null,"High fat dairy",1.2000000000000011E-2,0.214,0.50231842843563923]
[null,"Low fat dairy",1.2000000000000011E-2,1,1]
[null,"Egg",0,0.97,1]
[null,"Mutton",0,0.5,0.88622147079293823]
[null,"Other meat",0,0.76,0.32749425563008561]
[null,"Poultry",0,0.86666666999999997,1]