{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Risk","Crop","Log_TPL","Pests","Lists","Costs","Logos","Pest_Report","YLD","AFLTXN"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":0,"defined_names":104,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Risk","index":0,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,6,8,20],[1,5,1,6],[2,6,2,7],[2,9,2,12],[2,13,2,16],[2,17,2,20]]}
[]
[]
[null,null,null,"Crop",null,null,"Production",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Planting Date","2021-12-20",null,null,"Aflatoxin",{"$f":"AFLTXN_RiskIndex","v":435},435,435,435,435,435,435,435,435,435,435,435,435]
[null,null,null,"Plants per 1m of Row","5 plants (20 cm spacing)",null,null,"Yield",{"$f":"YLD_RiskIndex","v":535},535,535,535,535,535,535,535,535,535,535,535,535]
[null,null,null,"Seed Inoculant","No"]
[null,null,null,"Variety","Virginia Type",null,"Red Dots - Change practices to eliminate.\r\nYellow Dots - Consider adjusting practices to reduce risk.\r\nGreen Dots - Risk is acceptable for selected practices."]
[null,null,null,"Field"]
[null,null,null,"Crop Rotation","Groundnut : Groundnut : Groundnut"]
[null,null,null,"Fertilizer","None"]
[null,null,null,"Gypsum at Bloom","No"]
[null,null,null,"Soil Fertility","Low"]
[null,null,null,"Soil pH",5.6]
[null,null,null,"Tillage","Hand dug and ridging"]
[null,null,null,"Harvest"]
[null,null,null,"Digging Timimg","Optimum"]
[null,null,null,"Drying","Tarpulin"]
[null,null,null,"Method","Hand dug with hoe"]
[null,null,null,"Pest Management"]
[null,null,null,"Aphid Spray","No"]
[null,null,null,"Bird Protection","No"]
[null,null,null,"Fungicides","1 Spray"]
[null,null,null,"Rodent Protection","No"]
[null,null,null,"Weed Control","2 hand weedings during season"]
[null,null,null,"Storage"]
[null,null,null,"Groundnut Moisture","Less than 10%"]
[null,null,null,"Method","Sealed"]
[null,null,null,"Temperature","Lower than 28 °C"]

{"sheet":"Crop","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[[11,1,11,5],[14,1,14,5],[15,1,15,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[12,1,12,5],[13,1,13,5]]}
["Crop","Groundnut"]
[]
["Planting Season","Date","Month","Day of Month","Day of Year"]
["Start","2021-01-01",{"$f":"MONTH(B4)","v":1},{"$f":"DAY(B4)","v":1},{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":1}]
["End","2021-12-31",{"$f":"MONTH(B5)","v":12},{"$f":"DAY(B5)","v":31},{"$f":"B5-DATE(YEAR(B5),1,1)+1","v":365}]
[]
["Title","Groundnut Risk Tool - Malawi"]
["Subtitle"]
["Credit Lines","Justus Chintu, Wezi Mhango and Andrew Goodman"]
[null,"DARS Chitedze"]
[null,"Lilongwe Univ. of Agriculture and Nature Resources"]
[null,"Horizon Farms"]
[null,"Dave Hoisington and Jamie Rhoads"]
[null,"Peanut Innovation Lab"]
[null,"Rick Brandenburg, David Jordan, Dominic Reisig and Greg Buol"]
[null,"North Carolina State University, Raleigh NC"]

{"sheet":"Log_TPL","index":2,"n_rows":244,"n_cols":25,"rows_kept":244,"cut":false,"hidden":true,"merged":[[98,5,98,9],[98,10,98,17],[140,4,141,12],[0,0,0,14],[25,5,25,14]]}
["Field and Production Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Selection Lists"]
[null,null,null,"Crop",{"$f":"Crop","v":"Groundnut"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillage_Pracs","Land_Plaster_Meth","Land_Plaster_Type","Digging_Eq","Combine","Moisture_Status","Control_Rating"]
[null,null,null,"Field Area (ha)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bed","Banded","Bagged","2 Row Digger","2 Row Pull Type Combine","Dry","No Control (<5%)"]
[null,null,null,"Soil ","Mapped Series","% of Field",null,null,null,null,null,null,null,null,null,null,null,null,"Chisel","Broadcast","Bulk","4 Row Digger","4 Row Pull Type Combine","Adequate","Poor (5% to 20%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivate","Other","Granular","6 Row Digger","6 Row Pull Type Combine","Wet","Low (20% to 50%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disk",null,"Other","Other","6 Row Self-Propelled Combine",null,"Moderate (50% to 80%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moldboard Plow",null,null,null,"8 Row Self-Propelled Combine",null,"High (80% to 90%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Till",null,null,null,"Other",null,"Excellent (90% to 100%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rip"]
[null,null,null,"Tillage Practice","Date","Equipment",null,null,null,null,null,null,null,null,null,null,null,null,"Rip and Bed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strip Till"]
[]
[]
[]
[null,null,null,"Lime Applications","Date","Rate (kg/ha)"]
[null,null,null,"Current Year"]
[null,null,null,"Last Year"]
[]
[null,null,null,"Seed Inoculation","Date","Inoculant"]
[]
[]
[null,null,null,"Fertilizer","Date","N","P2O5","K2O","B","Cu","Fe","Mn","Mo","S","Zn"]
[null,null,null,null,null,"kg/ha"]
[]
[]
[]
[]
[]
[null,null,null,"Land Plaster","Date","Trade Name","Type","Method","Rate (kg/ha)"]
[]
[]
[null,null,null,"Herbicides","Date","Weeds","Weed Size","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate","Evaluation Date","Control Rating"]
[null,null,null,"Burndown"]
[null,null,null,"Preplant"]
[null,null,null,"Preemergence"]
[null,null,null,"At Cracking"]
[null,null,null,"First Postemergence"]
[null,null,null,"Second Postemergence"]
[null,null,null,"Third Postemergence"]
[]
[null,null,null,"Leaf Spot Program","Date","Severity","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate","Evaluation Date","Control Rating"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Pest Treaments","Date","Severity","Trade Name","Rate","Trade Name","Rate","Evaluation Date","Control Rating"]
[null,null,null,"Sclerotina Blight"]
[]
[null,null,null,"CBR"]
[]
[null,null,null,"Southern Corn Rootworm"]
[]
[null,null,null,"Spider Mites"]
[]
[]
[null,null,null,"Insecticide Treaments","Date","Pest","Severity","Trade Name","Rate","Trade Name","Rate","Evaluation Date","Control Rating"]
[null,null,null,"In-furrow"]
[null,null,null,"Foliar"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Development Dates","Date"]
[null,null,null,"Emergence"]
[null,null,null,"First Flower"]
[null,null,null,"First Peg"]
[null,null,null,"Last Flower"]
[]
[null,null,null,"Development Moisture Status"]
[null,null,null,"Planting to Emergence"]
[null,null,null,"Emergence to Flowering"]
[null,null,null,"Flowering to Pod Formation"]
[null,null,null,"Pod Formation to Harvest"]
[]
[null,null,null,"Weeds at Harvest"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Pod Blasting Data","Date","White","Yellow","Orange","Brown","Black","White","Yellow","Orange","Brown","Black","Brown/Black"]
[null,null,null,null,null,"Pod Count",null,null,null,null,"Percentage(%)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM($F100:$J100)=0,NA(),F100/(SUM($F100:$J100)))","v":{"$error":"#N/A"}},{"$f":"IF(SUM($F100:$J100)=0,NA(),G100/(SUM($F100:$J100)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"N100+O100","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"N101+O101","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,null,"Digging","Date","Equipment"]
[]
[]
[null,null,null,"Harvest","Date","Equipment"]
[]
[]
[null,null,null,"Yield Goal (kg/ha)"]
[null,null,null,"Yield (kg/ha)"]
[null,null,null,"Selling Price (MK/kg)"]
[]
[null,null,null,"Grading Results","Grams (gr)","Percentage (%)"]
[null,null,null,"Foreign Material Sample"]
[null,null,null,"Foreign Material",null,{"$f":"IFERROR(E117/E116,0)","v":0}]
[null,null,null,"LSK",null,{"$f":"IFERROR(E118/E116,0)","v":0}]
[null,null,null,"Moisture"]
[]
[null,null,null,"Cleaned Sample"]
[null,null,null,"Fancy",null,{"$f":"IFERROR(E122/E121,0)","v":0}]
[null,null,null,"Kernels Riding ELK Screen"]
[null,null,null,"Total ELK Damage"]
[null,null,null,"Net ELK",{"$f":"E123-E124","v":0},{"$f":"IFERROR(E125/E121,0)","v":0}]
[null,null,null,"Kernels Riding Prescribed Screen"]
[]
[null,null,null,"Total KRS"]
[null,null,null,"Damage KRS"]
[null,null,null,"SMKRS",{"$f":"E128-E129","v":0},{"$f":"IFERROR(E130/E121,0)","v":0}]
[null,null,null,"Sound Splits",null,{"$f":"IFERROR(E131/E121,0)","v":0}]
[null,null,null,"Total SMK",null,{"$f":"F130+F131","v":0}]
[null,null,null,"Other Kernels",null,{"$f":"IFERROR(E133/E121,0)","v":0}]
[null,null,null,"Damage Splits"]
[null,null,null,"Total Damage",null,{"$f":"IFERROR(E135/E121,0)","v":0}]
[null,null,null,"Total Kernels",null,{"$f":"F132+F133+F134+F135","v":0}]
[null,null,null,"Hulls",null,{"$f":"IFERROR(E137/E121,0)","v":0}]
[null,null,null,"Total Kernels & Halls",null,{"$f":"F136+F137","v":0}]
[null,null,null,"Freeze Damage",null,{"$f":"IFERROR(E139/E121,0)","v":0}]
[null,null,null,"Concealed RMD",null,{"$f":"IFERROR(E140/E121,0)","v":0}]
[null,null,null,"Remarks"]
[]
[]
[null,null,null,"Rainfall/Irrigation","Date","Amount (mm)","Month",null,"Month","Amount (mm)"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E145),\"\",TEXT(E145,\"mmm\"))","v":""},null,"Jan",{"$f":"SUMIF(G$145:G$244,\"=\" & I145,F$145:F$244)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E146),\"\",TEXT(E146,\"mmm\"))","v":""},null,"Feb",{"$f":"SUMIF(G$145:G$244,\"=\" & I146,F$145:F$244)","v":0}]
[null,null,null,null,null,null,"",null,"Mar",0]
[null,null,null,null,null,null,"",null,"Apr",0]
[null,null,null,null,null,null,"",null,"May",0]
[null,null,null,null,null,null,"",null,"Jun",0]
[null,null,null,null,null,null,"",null,"Jul",0]
[null,null,null,null,null,null,"",null,"Aug",0]
[null,null,null,null,null,null,"",null,"Sep",0]
[null,null,null,null,null,null,"",null,"Oct",0]
[null,null,null,null,null,null,"",null,"Nov",0]
[null,null,null,null,null,null,"",null,"Dec",0]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E210),\"\",TEXT(E210,\"mmm\"))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"Pests","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["PestType","Pest","PestID"]
["Production","Aflatoxin","AFLTXN"]
["Production","Yield","YLD"]

{"sheet":"Lists","index":4,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Category","Category_Pest","CategoryID","Category_List","Category_List_Type","Months","Land_Area_Units","Crop\\Variety","Crop\\Plants_per_1m_of_Row","Crop\\Seed_Inoculant","Field\\Crop_Rotation","Field\\Fertilizer","Field\\Soil_pH","Field\\Tillage","Harvest\\Digging_Timimg","Harvest\\Drying","Crop\\Planting_Date","Storage\\Groundnut_Moisture","Storage\\Temperature","Storage\\Method","Pest_Management\\Aphid_Spray","Pest_Management\\Bird_Protection","Pest_Management\\Rodent_Protection","Pest_Management\\Weed_Control","Pest_Management\\Fungicides","Field\\Gypsum_at_Bloom","Field\\Soil_Fertility","Harvest\\Method"]
["Crop\\Planting_Date",null,"Crop\\Planting_Date","Crop\\Planting_Date","Date","(01) January","ac","Spanish","01|5 plants (20 cm spacing)","No","Groundnut : Groundnut : Groundnut","01|None","4.4 or lower","Flat Beds (Conventional)","01|21 Days Early","Cemented floor","001 to 015","01|Less than 10%","01|Lower than 28 °C","Sealed","No","No","No","01|1 hand weeding during season","01|None","No","01|Low","01|Hand pulled"]
["Crop\\Plants_per_1m_of_Row",null,"Crop\\Plants_per_1m_of_Row","Crop\\Plants_per_1m_of_Row","Single","(02) February","ha","Spanish (GRDR)","02|7 plants (15 cm spacing)","Yes","Groundnut : Maize : Groundnut","02|50 kg/ha (Yara Legume)","4.5 to 5.0","Hand dug and ridging","02|14 Days Early","Ground","016 to 031","02|10 to 15%","02|28 to 32 °C","Traditional","Yes","Yes","Yes","02|2 hand weedings during season","02|1 Spray","Yes","02|Moderate","02|Hand dug with hoe"]
["Crop\\Seed_Inoculant",null,"Crop\\Seed_Inoculant","Crop\\Seed_Inoculant","Single","(03) March",null,"Spanish (GRDR,LSR)","03|10 plants (10 cm spacing, optimum)",null,"Groundnut : Tobacco : Groundnut","03|100 kg/ha (Yara Legume)","5.1 to 5.5","Plough and hand ridging","03|7 Days Early","Tarpulin","032 to 304","03|Greater than 15%","03|Higher than 32 °C",null,null,null,null,"03|3 hand weedings during season","03|2 Sprays",null,"03|High","03|Plow/Mechanical digger"]
["Crop\\Variety",null,"Crop\\Variety","Crop\\Variety","Single","(04) April",null,"Spanish (LSR)",null,null,"Maize : Maize : Groundnut","04|150 kg/ha (Yara Legume)","5.6 to 6.9","Plough and harrow (Improved)","04|Optimum",null,"305 to 319",null,null,null,null,null,null,"04|Pre herbicides followed by 1 hand weeding","04|3 Sprays"]
["Field\\Crop_Rotation",null,"Field\\Crop_Rotation","Field\\Crop_Rotation","Single","(05) May",null,"Virginia Type",null,null,"Maize : Soybean : Groundnut","05|200 kg/ha (Yara Legume)","7.0 or higher",null,"05|7 Days Late",null,"320 to 334",null,null,null,null,null,null,"05|Post herbicides followed by 1 hand weeding"]
["Field\\Fertilizer",null,"Field\\Fertilizer","Field\\Fertilizer","Single","(06) June",null,"Virginia Type (GRDR)",null,null,"Maize : Tobacco : Groundnut",null,null,null,"06|14 Days Late",null,"335 to 349"]
["Field\\Gypsum_at_Bloom",null,"Field\\Gypsum_at_Bloom","Field\\Gypsum_at_Bloom","Single","(07) July",null,"Virginia Type (GRDR,LSR)",null,null,"Soybean : Groundnut : Groundnut",null,null,null,"07|21 Days Late",null,"350 to 365"]
["Field\\Soil_Fertility",null,"Field\\Soil_Fertility","Field\\Soil_Fertility","Single","(08) August",null,"Virginia Type (LSR)",null,null,"Soybean : Maize : Groundnut"]
["Field\\Soil_pH",null,"Field\\Soil_pH","Field\\Soil_pH","pH","(09) September",null,null,null,null,"Soybean : Soybean : Groundnut"]
["Field\\Tillage",null,"Field\\Tillage","Field\\Tillage","Single","(10) October",null,null,null,null,"Tobacco : Maize : Groundnut"]
["Harvest\\Digging_Timimg",null,"Harvest\\Digging_Timimg","Harvest\\Digging_Timimg","Single","(11) November"]
["Harvest\\Drying",null,"Harvest\\Drying","Harvest\\Drying","Single","(12) December"]
["Harvest\\Method",null,"Harvest\\Method","Harvest\\Method","Single"]
["Pest_Management\\Aphid_Spray",null,"Pest_Management\\Aphid_Spray","Pest_Management\\Aphid_Spray","Single"]
["Pest_Management\\Bird_Protection",null,"Pest_Management\\Bird_Protection","Pest_Management\\Bird_Protection","Single"]
["Pest_Management\\Fungicides",null,"Pest_Management\\Fungicides","Pest_Management\\Fungicides","Single"]
["Pest_Management\\Rodent_Protection",null,"Pest_Management\\Rodent_Protection","Pest_Management\\Rodent_Protection","Single"]
["Pest_Management\\Weed_Control",null,"Pest_Management\\Weed_Control","Pest_Management\\Weed_Control","Single"]
["Storage\\Groundnut_Moisture",null,"Storage\\Groundnut_Moisture","Storage\\Groundnut_Moisture","Single"]
["Storage\\Method",null,"Storage\\Method","Storage\\Method","Single"]
["Storage\\Temperature",null,"Storage\\Temperature","Storage\\Temperature","Single"]

{"sheet":"Costs","index":5,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":true,"merged":[[0,7,0,9],[0,10,0,12],[20,7,20,9],[20,10,20,12],[24,7,24,9],[24,10,24,12]]}
["Land Area Units ","ha",null,null,null,null,null,{"$f":"Cost_Header","v":"Cost (MK/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hours (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hours (hrs/ha)"}]
["Category","Item",{"$f":"CONCATENATE(\"Cost (MK/\",sel_Land_Area_Units,\")\")","v":"Cost (MK/ha)"},"Multiplier",{"$f":"CONCATENATE(\"Person Hours (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hours (hrs/ha)"},null,"Category","Max","Min","Sel","Max","Min","Sel","Selection"]
["Base_Cost",null,0,null,0,null,"Base_Cost",{"$f":"Cost_Base","v":0},{"$f":"Cost_Base","v":0},{"$f":"Cost_Base","v":0},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0}]
["Crop\\Plants_per_1m_of_Row","5 plants (20 cm spacing)",null,0.5,35,null,"Crop\\Seed_Inoculant",{"$f":"calcCostMax(G4,Category)","v":16130},{"$f":"calcCostMin(G4)","v":0},{"$f":"calcCost(G4,N4,Category)","v":0},{"$f":"calcPersonHrsMax(G4,Category)","v":1},{"$f":"calcPersonHrsMin(G4)","v":0},{"$f":"calcPersonHrs(G4,N4,Category)","v":0},{"$f":"CONCATENATE(IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant))","v":"No"}]
["Crop\\Plants_per_1m_of_Row","7 plants (15 cm spacing)",null,0.7,45,null,"Crop\\Variety | Crop\\Plants_per_1m_of_Row",161290,56450,80645,55,35,35,{"$f":"CONCATENATE(IF(ISBLANK(sel_Crop\\Variety),\"\",sel_Crop\\Variety),\" | \",IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row))","v":"Virginia Type | 5 plants (20 cm spacing)"}]
["Crop\\Plants_per_1m_of_Row","10 plants (10 cm spacing, optimum)",null,1,55,null,"Field\\Fertilizer",96800,0,0,18,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Fertilizer),\"\",sel_Field\\Fertilizer))","v":"None"}]
["Crop\\Seed_Inoculant","No",0,null,0,null,"Field\\Gypsum_at_Bloom",48400,0,0,12,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Gypsum_at_Bloom),\"\",sel_Field\\Gypsum_at_Bloom))","v":"No"}]
["Crop\\Seed_Inoculant","Yes",16130,null,1,null,"Field\\Soil_pH",120900,0,80600,21,0,18,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH))","v":"5.6"}]
["Crop\\Variety","Spanish",112900,null,null,null,"Field\\Tillage",40300,8060,40300,5,5,50,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage))","v":"Hand dug and ridging"}]
["Crop\\Variety","Spanish (GRDR)",112900,null,null,null,"Harvest\\Drying",40300,0,16130,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Harvest\\Drying),\"\",sel_Harvest\\Drying))","v":"Tarpulin"}]
["Crop\\Variety","Spanish (GRDR,LSR)",112900,null,null,null,"Harvest\\Method",24180,8060,24180,5,5,30,{"$f":"CONCATENATE(IF(ISBLANK(sel_Harvest\\Method),\"\",sel_Harvest\\Method))","v":"Hand dug with hoe"}]
["Crop\\Variety","Spanish (LSR)",112900,null,null,null,"Pest_Management\\Aphid_Spray",12100,0,0,12,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray))","v":"No"}]
["Crop\\Variety","Virginia Type",161290,null,null,null,"Pest_Management\\Bird_Protection",16130,0,0,12,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Bird_Protection),\"\",sel_Pest_Management\\Bird_Protection))","v":"No"}]
["Crop\\Variety","Virginia Type (GRDR)",161290,null,null,null,"Pest_Management\\Fungicides",36300,0,12100,36,0,12,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides))","v":"1 Spray"}]
["Crop\\Variety","Virginia Type (GRDR,LSR)",161290,null,null,null,"Pest_Management\\Rodent_Protection",16130,0,0,12,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection))","v":"No"}]
["Crop\\Variety","Virginia Type (LSR)",161290,null,null,null,"Pest_Management\\Weed_Control",48390,16130,32260,75,40,75,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control))","v":"2 hand weedings during season"}]
["Field\\Fertilizer","None",0,null,0,null,"Storage\\Method",32260,4030,32260,4,4,8,{"$f":"CONCATENATE(IF(ISBLANK(sel_Storage\\Method),\"\",sel_Storage\\Method))","v":"Sealed"}]
["Field\\Fertilizer","50 kg/ha (Yara Legume)",24200,null,9]
["Field\\Fertilizer","100 kg/ha (Yara Legume)",48400,null,12,null,"Total",{"$f":"SUM(H$3:H17)","v":709610},{"$f":"SUM(I$3:I17)","v":92730},{"$f":"IF(ISERROR(SUM(J$3:J17)),0,SUM(J$3:J17))","v":318475},{"$f":"SUM(K$3:K17)","v":268},{"$f":"SUM(L$3:L17)","v":89},{"$f":"IF(ISERROR(SUM(M$3:M17)),0,SUM(M$3:M17))","v":228}]
["Field\\Fertilizer","150 kg/ha (Yara Legume)",72600,null,15]
["Field\\Fertilizer","200 kg/ha (Yara Legume)",96800,null,18,null,null,{"$f":"CONCATENATE(\"Cost Thresholds (MK/\",sel_Land_Area_Units,\")\")","v":"Cost Thresholds (MK/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hour Thresholds (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Thresholds (hrs/ha)"}]
["Field\\Gypsum_at_Bloom","No",0,null,0,null,"High",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":503985.38959999999},null,null,{"$f":"PersonHours_Min + 0.66667*(PersonHours_Max-PersonHours_Min)","v":208.33393000000001}]
["Field\\Gypsum_at_Bloom","Yes",48400,null,12,null,"Moderate",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":298354.61040000001},null,null,{"$f":"PersonHours_Min + 0.33333*(PersonHours_Max-PersonHours_Min)","v":148.66606999999999}]
["Field\\Soil_pH","4.4 or lower",0,null,0]
["Field\\Soil_pH","4.5 to 5.0",0,null,12,null,null,{"$f":"CONCATENATE(\"Cost Ranges (MK/\",sel_Land_Area_Units,\")\")","v":"Cost Ranges (MK/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hour Ranges (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Ranges (hrs/ha)"}]
["Field\\Soil_pH","5.1 to 5.5",40300,null,15,null,"Base",{"$f":"Cost_Base","v":0},null,null,{"$f":"PersonHours_Base","v":0}]
["Field\\Soil_pH","5.6 to 6.9",80600,null,18,null,"Low",{"$f":"Cost_Moderate-Cost_Base","v":298354.61040000001},null,null,{"$f":"PersonHours_Moderate-PersonHours_Base","v":148.66606999999999}]
["Field\\Soil_pH","7.0 or higher",120900,null,21,null,"Moderate",{"$f":"Cost_High-Cost_Moderate","v":205630.77919999999},null,null,{"$f":"PersonHours_High-PersonHours_Moderate","v":59.667860000000019}]
["Field\\Tillage","Flat Beds (Conventional)",8060,null,10,null,"High",{"$f":"Cost_Max-Cost_High","v":205624.61040000001},null,null,{"$f":"PersonHours_Max-PersonHours_High","v":59.666069999999991}]
["Field\\Tillage","Hand dug and ridging",40300,null,50]
["Field\\Tillage","Plough and hand ridging",20150,null,35,null,{"$f":"CONCATENATE(\"Estimated Cost (MK/\",sel_Land_Area_Units,\"): \",TEXT(ROUNDUP(TRUNC(Cost,2),0),\"#,##0\"))","v":"Estimated Cost (MK/ha): 318,475"}]
["Field\\Tillage","Plough and harrow (Improved)",8060,null,5]
["Harvest\\Drying","Cemented floor",40300]
["Harvest\\Drying","Ground",0]
["Harvest\\Drying","Tarpulin",16130]
["Harvest\\Method","Hand pulled",16120,null,20]
["Harvest\\Method","Hand dug with hoe",24180,null,30]
["Harvest\\Method","Plow/Mechanical digger",8060,null,5,null,{"$f":"CONCATENATE(\"Estimated Person Hours (hrs/\",sel_Land_Area_Units,\"): \",ROUNDUP(TRUNC(PersonHours,2),0))","v":"Estimated Person Hours (hrs/ha): 228"}]
["Pest_Management\\Aphid_Spray","No",0,null,0]
["Pest_Management\\Aphid_Spray","Yes",12100,null,12]
["Pest_Management\\Bird_Protection","No",0,null,0]
["Pest_Management\\Bird_Protection","Yes",16130,null,12]
["Pest_Management\\Fungicides","None",0,null,0]
["Pest_Management\\Fungicides","1 Spray",12100,null,12]
["Pest_Management\\Fungicides","2 Sprays",24200,null,24]
["Pest_Management\\Fungicides","3 Sprays",36300,null,36]
["Pest_Management\\Rodent_Protection","No",0,null,0]
["Pest_Management\\Rodent_Protection","Yes",16130,null,12]
["Pest_Management\\Weed_Control","1 hand weeding during season",16130,null,40]
["Pest_Management\\Weed_Control","2 hand weedings during season",32260,null,75]
["Pest_Management\\Weed_Control","3 hand weedings during season",48390,null,100]
["Pest_Management\\Weed_Control","Pre herbicides followed by 1 hand weeding",28255,null,75]
["Pest_Management\\Weed_Control","Post herbicides followed by 1 hand weeding",28255,null,75]
["Storage\\Method","Sealed",32260,null,8]
["Storage\\Method","Traditional",4030,null,4]

{"sheet":"Logos","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Pest_Report","index":7,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":true,"merged":[[52,3,54,3],[55,0,55,1],[55,2,55,3],[56,3,61,3],[46,0,46,1],[46,2,46,3],[47,3,50,3],[51,0,51,1],[51,2,51,3],[39,2,39,3],[40,3,41,3],[42,0,42,1],[42,2,42,3],[43,3,45,3],[21,3,24,3],[65,0,65,1],[65,2,65,3],[6,3,12,3],[13,0,13,1],[13,2,13,3],[14,3,16,3],[17,0,17,1],[17,2,17,3],[25,0,25,1],[25,2,25,3],[26,3,32,3],[33,0,33,1],[33,2,33,3],[34,3,38,3],[39,0,39,1],[0,0,0,3],[5,0,5,1],[5,2,5,3],[18,3,19,3],[20,0,20,1],[20,2,20,3],[62,0,62,1],[62,2,62,3],[63,3,64,3],[66,3,67,3],[68,0,68,1],[68,2,68,3],[69,3,70,3],[71,0,71,1],[71,2,71,3],[72,3,75,3],[76,0,76,1],[76,2,76,3],[77,3,78,3],[79,0,79,1],[79,2,79,3],[80,3,84,3],[86,0,86,3]]}
["Groundnut - Yield Risk Summary"]
[]
[]
[]
[]
["Crop\\Planting Date",null,"Risk Points"]
[null,"Feb 01 to Oct 31",100,5]
[null,"Jan 16 to Jan 31",60]
[null,"Jan 01 to Jan 15",40]
[null,"Dec 16 to Dec 31",30]
[null,"Dec 01 to Dec 15",20]
[null,"Nov 16 to Nov 30",10]
[null,"Nov 01 to Nov 15*",5]
["Crop\\Plants per 1m of Row",null,"Risk Points"]
[null,"5 plants (20 cm spacing)",80,5]
[null,"7 plants (15 cm spacing)",40]
[null,"10 plants (10 cm spacing, optimum)",5]
["Crop\\Seed Inoculant",null,"Risk Points"]
[null,"No*",15,15]
[null,"Yes",5]
["Crop\\Variety",null,"Risk Points"]
[null,"Spanish*, Virginia Type",50,50]
[null,"Spanish (GRDR), Virginia Type (GRDR)",30]
[null,"Spanish (LSR), Virginia Type (LSR)",15]
[null,"Spanish (GRDR,LSR), Virginia Type (GRDR,LSR)",5]
["Field\\Crop Rotation",null,"Risk Points"]
[null,"Groundnut : Groundnut : Groundnut*",50,50]
[null,"Soybean : Groundnut : Groundnut",45]
[null,"Soybean : Soybean : Groundnut",40]
[null,"Groundnut : Maize : Groundnut, Groundnut : Tobacco : Groundnut, Maize : Soybean : Groundnut",25]
[null,"Soybean : Maize : Groundnut",20]
[null,"Maize : Tobacco : Groundnut, Tobacco : Maize : Groundnut",15]
[null,"Maize : Maize : Groundnut",5]
["Field\\Fertilizer",null,"Risk Points"]
[null,"None*",50,50]
[null,"50 kg/ha (Yara Legume)",0]
[null,"100 kg/ha (Yara Legume)",-50]
[null,"150 kg/ha (Yara Legume)",-100]
[null,"200 kg/ha (Yara Legume)",-120]
["Field\\Gypsum at Bloom",null,"Risk Points"]
[null,"No",15,5]
[null,"Yes*",5]
["Field\\Soil Fertility",null,"Risk Points"]
[null,"Low",100,5]
[null,"Moderate",50]
[null,"High*",5]
["Field\\Soil pH",null,"Risk Points"]
[null,"4.4 or lower, 7.0 or higher",100,5]
[null,"4.5 to 5.0",50]
[null,"5.1 to 5.5",25]
[null,"5.6 to 6.9*",5]
["Field\\Tillage",null,"Risk Points"]
[null,"Flat Beds (Conventional)",20,15]
[null,"Hand dug and ridging*",15]
[null,"Plough and hand ridging, Plough and harrow (Improved)",10]
["Harvest\\Digging Timimg",null,"Risk Points"]
[null,"21 Days Early",60,5]
[null,"21 Days Late",40]
[null,"14 Days Early",25]
[null,"14 Days Late",15]
[null,"7 Days Early, 7 Days Late",10]
[null,"Optimum*",5]
["Harvest\\Method",null,"Risk Points"]
[null,"Hand pulled",15,5]
[null,"Hand dug with hoe*, Plow/Mechanical digger",5]
["Pest Management\\Aphid Spray",null,"Risk Points"]
[null,"No",20,10]
[null,"Yes*",10]
["Pest Management\\Bird Protection",null,"Risk Points"]
[null,"No",25,5]
[null,"Yes*",5]
["Pest Management\\Fungicides",null,"Risk Points"]
[null,"None",50,15]
[null,"1 Spray",25]
[null,"2 Sprays*",15]
[null,"3 Sprays",5]
["Pest Management\\Rodent Protection",null,"Risk Points"]
[null,"No",20,5]
[null,"Yes*",5]
["Pest Management\\Weed Control",null,"Risk Points"]
[null,"1 hand weeding during season",50,25]
[null,"2 hand weedings during season*",25]
[null,"3 hand weedings during season",15]
[null,"Post herbicides followed by 1 hand weeding",10]
[null,"Pre herbicides followed by 1 hand weeding",5]
[]
["* Selected options used in calculating pest risk.\r\nNote: Reduction in pest risk value by a control practice will be less under low risk conditions."]

{"sheet":"YLD","index":8,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Yield"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop\\Planting_Date",1,"032 to 304",100,null,null,null,"Crop\\Planting_Date",100,5,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Date\")","v":30},{"$f":"IF(ISBLANK(sel_Crop\\Planting_Date),\"\",sel_Crop\\Planting_Date)","v":"2021-12-20"}]
["Crop\\Planting_Date",2,"016 to 031",60,null,null,null,"Field\\Soil_Fertility",100,5,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":100},{"$f":"IF(ISBLANK(sel_Field\\Soil_Fertility),\"\",sel_Field\\Soil_Fertility)","v":"Low"}]
["Crop\\Planting_Date",3,"001 to 015",40,null,null,null,"Field\\Soil_pH",100,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"pH\")","v":5},{"$f":"IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH)","v":5.6}]
["Crop\\Planting_Date",4,"350 to 365",30,null,null,null,"Crop\\Plants_per_1m_of_Row",80,5,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":80},{"$f":"IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row)","v":"5 plants (20 cm spacing)"}]
["Crop\\Planting_Date",5,"335 to 349",20,null,null,null,"Harvest\\Digging_Timimg",60,5,5,{"$f":"IF(ISBLANK(sel_Harvest\\Digging_Timimg),\"\",sel_Harvest\\Digging_Timimg)","v":"Optimum"}]
["Crop\\Planting_Date",6,"320 to 334",10,null,null,null,"Crop\\Variety",50,5,50,{"$f":"IF(ISBLANK(sel_Crop\\Variety),\"\",sel_Crop\\Variety)","v":"Virginia Type"}]
["Crop\\Planting_Date",7,"305 to 319",5,null,null,null,"Field\\Crop_Rotation",50,5,50,{"$f":"IF(ISBLANK(sel_Field\\Crop_Rotation),\"\",sel_Field\\Crop_Rotation)","v":"Groundnut : Groundnut : Groundnut"}]
["Crop\\Plants_per_1m_of_Row",1,"5 plants (20 cm spacing)",80,null,null,null,"Field\\Fertilizer",50,-120,50,{"$f":"IF(ISBLANK(sel_Field\\Fertilizer),\"\",sel_Field\\Fertilizer)","v":"None"}]
["Crop\\Plants_per_1m_of_Row",2,"7 plants (15 cm spacing)",40,null,null,null,"Pest_Management\\Fungicides",50,5,25,{"$f":"IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides)","v":"1 Spray"}]
["Crop\\Plants_per_1m_of_Row",3,"10 plants (10 cm spacing, optimum)",5,null,null,null,"Pest_Management\\Weed_Control",50,5,25,{"$f":"IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control)","v":"2 hand weedings during season"}]
["Crop\\Seed_Inoculant",1,"No",15,null,null,null,"Pest_Management\\Bird_Protection",25,5,25,{"$f":"IF(ISBLANK(sel_Pest_Management\\Bird_Protection),\"\",sel_Pest_Management\\Bird_Protection)","v":"No"}]
["Crop\\Seed_Inoculant",2,"Yes",5,null,null,null,"Field\\Tillage",20,10,15,{"$f":"IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage)","v":"Hand dug and ridging"}]
["Crop\\Variety",1,"Spanish|Virginia Type",50,null,null,null,"Pest_Management\\Aphid_Spray",20,10,20,{"$f":"IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray)","v":"No"}]
["Crop\\Variety",2,"Spanish (GRDR)|Virginia Type (GRDR)",30,null,null,null,"Pest_Management\\Rodent_Protection",20,5,20,{"$f":"IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection)","v":"No"}]
["Crop\\Variety",3,"Spanish (LSR)|Virginia Type (LSR)",15,null,null,null,"Crop\\Seed_Inoculant",15,5,15,{"$f":"IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant)","v":"No"}]
["Crop\\Variety",4,"Spanish (GRDR,LSR)|Virginia Type (GRDR,LSR)",5,null,null,null,"Field\\Gypsum_at_Bloom",15,5,15,{"$f":"IF(ISBLANK(sel_Field\\Gypsum_at_Bloom),\"\",sel_Field\\Gypsum_at_Bloom)","v":"No"}]
["Field\\Crop_Rotation",1,"Groundnut : Groundnut : Groundnut",50,null,null,null,"Harvest\\Method",15,5,5,{"$f":"IF(ISBLANK(sel_Harvest\\Method),\"\",sel_Harvest\\Method)","v":"Hand dug with hoe"}]
["Field\\Crop_Rotation",2,"Soybean : Groundnut : Groundnut",45]
["Field\\Crop_Rotation",3,"Soybean : Soybean : Groundnut",40,null,null,null,"Total",{"$f":"SUMIF(I3:I19,\">0\")","v":820},{"$f":"SUMIF(J3:J19,\">0\")","v":90},{"$f":"MAX(YLD_MinRiskIndex,SUM(K3:K19))","v":535}]
["Field\\Crop_Rotation",4,"Groundnut : Maize : Groundnut|Groundnut : Tobacco : Groundnut|Maize : Soybean : Groundnut",25]
["Field\\Crop_Rotation",5,"Soybean : Maize : Groundnut",20,null,null,null,"High Risk Index",400]
["Field\\Crop_Rotation",6,"Maize : Tobacco : Groundnut|Tobacco : Maize : Groundnut",15,null,null,null,"Moderate Risk Index",200]
["Field\\Crop_Rotation",7,"Maize : Maize : Groundnut",5]
["Field\\Fertilizer",1,"None",50]
["Field\\Fertilizer",2,"50 kg/ha (Yara Legume)",0]
["Field\\Fertilizer",3,"100 kg/ha (Yara Legume)",-50]
["Field\\Fertilizer",4,"150 kg/ha (Yara Legume)",-100]
["Field\\Fertilizer",5,"200 kg/ha (Yara Legume)",-120]
["Field\\Gypsum_at_Bloom",1,"No",15]
["Field\\Gypsum_at_Bloom",2,"Yes",5]
["Field\\Soil_Fertility",1,"Low",100]
["Field\\Soil_Fertility",2,"Moderate",50]
["Field\\Soil_Fertility",3,"High",5]
["Field\\Soil_pH",1,"4.4 or lower|7.0 or higher",100]
["Field\\Soil_pH",2,"4.5 to 5.0",50]
["Field\\Soil_pH",3,"5.1 to 5.5",25]
["Field\\Soil_pH",4,"5.6 to 6.9",5]
["Field\\Tillage",1,"Flat Beds (Conventional)",20]
["Field\\Tillage",2,"Hand dug and ridging",15]
["Field\\Tillage",3,"Plough and hand ridging|Plough and harrow (Improved)",10]
["Harvest\\Digging_Timimg",1,"21 Days Early",60]
["Harvest\\Digging_Timimg",2,"21 Days Late",40]
["Harvest\\Digging_Timimg",3,"14 Days Early",25]
["Harvest\\Digging_Timimg",4,"14 Days Late",15]
["Harvest\\Digging_Timimg",5,"7 Days Early|7 Days Late",10]
["Harvest\\Digging_Timimg",6,"Optimum",5]
["Harvest\\Method",1,"Hand pulled",15]
["Harvest\\Method",2,"Hand dug with hoe|Plow/Mechanical digger",5]
["Pest_Management\\Aphid_Spray",1,"No",20]
["Pest_Management\\Aphid_Spray",2,"Yes",10]
["Pest_Management\\Bird_Protection",1,"No",25]
["Pest_Management\\Bird_Protection",2,"Yes",5]
["Pest_Management\\Fungicides",1,"None",50]
["Pest_Management\\Fungicides",2,"1 Spray",25]
["Pest_Management\\Fungicides",3,"2 Sprays",15]
["Pest_Management\\Fungicides",4,"3 Sprays",5]
["Pest_Management\\Rodent_Protection",1,"No",20]
["Pest_Management\\Rodent_Protection",2,"Yes",5]
["Pest_Management\\Weed_Control",1,"1 hand weeding during season",50]
["Pest_Management\\Weed_Control",2,"2 hand weedings during season",25]
["Pest_Management\\Weed_Control",3,"3 hand weedings during season",15]
["Pest_Management\\Weed_Control",4,"Post herbicides followed by 1 hand weeding",10]
["Pest_Management\\Weed_Control",5,"Pre herbicides followed by 1 hand weeding",5]

{"sheet":"AFLTXN","index":9,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Aflatoxin"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop\\Planting_Date",1,"032 to 304",90,null,null,null,"Harvest\\Drying",160,10,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Harvest\\Drying),\"\",sel_Harvest\\Drying)","v":"Tarpulin"}]
["Crop\\Planting_Date",2,"016 to 031",70,null,null,null,"Storage\\Method",160,20,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Storage\\Method),\"\",sel_Storage\\Method)","v":"Sealed"}]
["Crop\\Planting_Date",3,"001 to 015",50,null,null,null,"Crop\\Planting_Date",90,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Date\")","v":40},{"$f":"IF(ISBLANK(sel_Crop\\Planting_Date),\"\",sel_Crop\\Planting_Date)","v":"2021-12-20"}]
["Crop\\Planting_Date",4,"350 to 365",40,null,null,null,"Storage\\Groundnut_Moisture",80,5,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Storage\\Groundnut_Moisture),\"\",sel_Storage\\Groundnut_Moisture)","v":"Less than 10%"}]
["Crop\\Planting_Date",5,"335 to 349",20,null,null,null,"Storage\\Temperature",80,20,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Storage\\Temperature),\"\",sel_Storage\\Temperature)","v":"Lower than 28 °C"}]
["Crop\\Planting_Date",6,"320 to 334",10,null,null,null,"Harvest\\Digging_Timimg",70,5,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Harvest\\Digging_Timimg),\"\",sel_Harvest\\Digging_Timimg)","v":"Optimum"}]
["Crop\\Planting_Date",7,"305 to 319",5,null,null,null,"Field\\Crop_Rotation",50,5,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":50},{"$f":"IF(ISBLANK(sel_Field\\Crop_Rotation),\"\",sel_Field\\Crop_Rotation)","v":"Groundnut : Groundnut : Groundnut"}]
["Crop\\Plants_per_1m_of_Row",1,"5 plants (20 cm spacing)",30,null,null,null,"Field\\Soil_pH",50,5,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"pH\")","v":5},{"$f":"IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH)","v":5.6}]
["Crop\\Plants_per_1m_of_Row",2,"7 plants (15 cm spacing)",15,null,null,null,"Field\\Fertilizer",40,5,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":40},{"$f":"IF(ISBLANK(sel_Field\\Fertilizer),\"\",sel_Field\\Fertilizer)","v":"None"}]
["Crop\\Plants_per_1m_of_Row",3,"10 plants (10 cm spacing, optimum)",5,null,null,null,"Pest_Management\\Weed_Control",35,5,15,{"$f":"IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control)","v":"2 hand weedings during season"}]
["Crop\\Seed_Inoculant",1,"No",15,null,null,null,"Crop\\Plants_per_1m_of_Row",30,5,30,{"$f":"IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row)","v":"5 plants (20 cm spacing)"}]
["Crop\\Seed_Inoculant",2,"Yes",5,null,null,null,"Crop\\Variety",25,5,25,{"$f":"IF(ISBLANK(sel_Crop\\Variety),\"\",sel_Crop\\Variety)","v":"Virginia Type"}]
["Crop\\Variety",1,"Spanish|Virginia Type",25,null,null,null,"Field\\Gypsum_at_Bloom",25,5,25,{"$f":"IF(ISBLANK(sel_Field\\Gypsum_at_Bloom),\"\",sel_Field\\Gypsum_at_Bloom)","v":"No"}]
["Crop\\Variety",2,"Spanish (GRDR)|Virginia Type (GRDR)",20,null,null,null,"Pest_Management\\Bird_Protection",25,5,25,{"$f":"IF(ISBLANK(sel_Pest_Management\\Bird_Protection),\"\",sel_Pest_Management\\Bird_Protection)","v":"No"}]
["Crop\\Variety",3,"Spanish (LSR)|Virginia Type (LSR)",15,null,null,null,"Field\\Soil_Fertility",20,-20,20,{"$f":"IF(ISBLANK(sel_Field\\Soil_Fertility),\"\",sel_Field\\Soil_Fertility)","v":"Low"}]
["Crop\\Variety",4,"Spanish (GRDR,LSR)|Virginia Type (GRDR,LSR)",5,null,null,null,"Field\\Tillage",20,10,15,{"$f":"IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage)","v":"Hand dug and ridging"}]
["Field\\Crop_Rotation",1,"Groundnut : Groundnut : Groundnut",50,null,null,null,"Harvest\\Method",20,5,20,{"$f":"IF(ISBLANK(sel_Harvest\\Method),\"\",sel_Harvest\\Method)","v":"Hand dug with hoe"}]
["Field\\Crop_Rotation",2,"Soybean : Groundnut : Groundnut",45,null,null,null,"Pest_Management\\Fungicides",20,5,15,{"$f":"IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides)","v":"1 Spray"}]
["Field\\Crop_Rotation",3,"Soybean : Soybean : Groundnut",40,null,null,null,"Pest_Management\\Rodent_Protection",20,5,20,{"$f":"IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection)","v":"No"}]
["Field\\Crop_Rotation",4,"Groundnut : Maize : Groundnut|Groundnut : Tobacco : Groundnut|Maize : Soybean : Groundnut",25,null,null,null,"Crop\\Seed_Inoculant",15,5,15,{"$f":"IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant)","v":"No"}]
["Field\\Crop_Rotation",5,"Soybean : Maize : Groundnut",20,null,null,null,"Pest_Management\\Aphid_Spray",10,5,10,{"$f":"IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray)","v":"No"}]
["Field\\Crop_Rotation",6,"Maize : Tobacco : Groundnut|Tobacco : Maize : Groundnut",15]
["Field\\Crop_Rotation",7,"Maize : Maize : Groundnut",5,null,null,null,"Total",{"$f":"SUMIF(I3:I23,\">0\")","v":1045},{"$f":"SUMIF(J3:J23,\">0\")","v":140},{"$f":"MAX(AFLTXN_MinRiskIndex,SUM(K3:K23))","v":435}]
["Field\\Fertilizer",1,"None",40]
["Field\\Fertilizer",2,"50 kg/ha (Yara Legume)",20,null,null,null,"High Risk Index",600]
["Field\\Fertilizer",3,"100 kg/ha (Yara Legume)",15,null,null,null,"Moderate Risk Index",320]
["Field\\Fertilizer",4,"150 kg/ha (Yara Legume)|200 kg/ha (Yara Legume)",5]
["Field\\Gypsum_at_Bloom",1,"No",25]
["Field\\Gypsum_at_Bloom",2,"Yes",5]
["Field\\Soil_Fertility",1,"Low",20]
["Field\\Soil_Fertility",2,"Moderate",0]
["Field\\Soil_Fertility",3,"High",-20]
["Field\\Soil_pH",1,"4.4 or lower|7.0 or higher",50]
["Field\\Soil_pH",2,"4.5 to 5.0",30]
["Field\\Soil_pH",3,"5.1 to 5.5",20]
["Field\\Soil_pH",4,"5.6 to 6.9",5]
["Field\\Tillage",1,"Flat Beds (Conventional)",20]
["Field\\Tillage",2,"Hand dug and ridging",15]
["Field\\Tillage",3,"Plough and hand ridging|Plough and harrow (Improved)",10]
["Harvest\\Digging_Timimg",1,"21 Days Late",70]
["Harvest\\Digging_Timimg",2,"14 Days Late",50]
["Harvest\\Digging_Timimg",3,"21 Days Early",30]
["Harvest\\Digging_Timimg",4,"14 Days Early|7 Days Late",20]
["Harvest\\Digging_Timimg",5,"Optimum",10]
["Harvest\\Digging_Timimg",6,"7 Days Early",5]
["Harvest\\Drying",1,"Ground",160]
["Harvest\\Drying",2,"Cemented floor",50]
["Harvest\\Drying",3,"Tarpulin",10]
["Harvest\\Method",1,"Hand dug with hoe",20]
["Harvest\\Method",2,"Plow/Mechanical digger",10]
["Harvest\\Method",3,"Hand pulled",5]
["Pest_Management\\Aphid_Spray",1,"No",10]
["Pest_Management\\Aphid_Spray",2,"Yes",5]
["Pest_Management\\Bird_Protection",1,"No",25]
["Pest_Management\\Bird_Protection",2,"Yes",5]
["Pest_Management\\Fungicides",1,"None",20]
["Pest_Management\\Fungicides",2,"1 Spray",15]
["Pest_Management\\Fungicides",3,"2 Sprays",10]
["Pest_Management\\Fungicides",4,"3 Sprays",5]
["Pest_Management\\Rodent_Protection",1,"No",20]
["Pest_Management\\Rodent_Protection",2,"Yes",5]
["Pest_Management\\Weed_Control",1,"1 hand weeding during season",35]
["Pest_Management\\Weed_Control",2,"2 hand weedings during season|3 hand weedings during season|Post herbicides followed by 1 hand weeding",15]
["Pest_Management\\Weed_Control",3,"Pre herbicides followed by 1 hand weeding",5]
["Storage\\Groundnut_Moisture",1,"Greater than 15%",80]
["Storage\\Groundnut_Moisture",2,"10 to 15%",20]
["Storage\\Groundnut_Moisture",3,"Less than 10%",5]
["Storage\\Method",1,"Traditional",160]
["Storage\\Method",2,"Sealed",20]
["Storage\\Temperature",1,"Higher than 32 °C",80]
["Storage\\Temperature",2,"28 to 32 °C",40]
["Storage\\Temperature",3,"Lower than 28 °C",20]