{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Risk","Crop","Log_TPL","Pests","Lists","Costs","Logos","Pest_Report","YLD","AFLTXN"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":102,"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":27,"n_cols":21,"rows_kept":27,"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-09-30",null,null,"Aflatoxin",{"$f":"AFLTXN_RiskIndex","v":460},460,460,460,460,460,460,460,460,460,460,460,460]
[null,null,null,"Plants per 1m of Row","10 plants (10 cm spacing, optimum)",null,null,"Yield Reduction",{"$f":"YLD_RiskIndex","v":680},680,680,680,680,680,680,680,680,680,680,680,680]
[null,null,null,"Seed Inoculant","Yes"]
[null,null,null,"Variety","Yenyawoso (Span-GRDR)",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,"Calciprill Application","No"]
[null,null,null,"Crop Rotation","Groundnut : Groundnut : Groundnut"]
[null,null,null,"Fertilizer","None"]
[null,null,null,"Soil Fertility","Low"]
[null,null,null,"Soil pH",4.5999999999999996]
[null,null,null,"Tillage","Flat Beds (Conventional)"]
[null,null,null,"Harvest"]
[null,null,null,"Digging Timimg","Optimum"]
[null,null,null,"Drying","Tarpulin"]
[null,null,null,"Pest Management"]
[null,null,null,"Aphid Spray","Yes"]
[null,null,null,"Bird Protection","No"]
[null,null,null,"Fungicides","2 Sprays"]
[null,null,null,"Rodent Protection","Yes"]
[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","Traditional"]
[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":[[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5]]}
["Crop","Groundnut"]
[]
["Planting Season","Date","Month","Day of Month","Day of Year"]
["Start","2021-08-15",{"$f":"MONTH(B4)","v":8},{"$f":"DAY(B4)","v":15},{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":227}]
["End","2021-09-30",{"$f":"MONTH(B5)","v":9},{"$f":"DAY(B5)","v":30},{"$f":"B5-DATE(YEAR(B5),1,1)+1","v":273}]
[]
["Title","Groundnut Risk Tool - Southern Ghana"]
["Subtitle","(MINOR SEASON)"]
["Credit Lines","J.A. Nboyine, R. Oteng-Frimpong and A. Seidu"]
[null,"CSIR - SARI"]
[null,"M.B. Mochiah and S. Arthur"]
[null,"CSIR - CRI"]
[null,"R. Akromah"]
[null,"KNUST"]
[null,"D. Jordan, R. Brandenburg and G.S. Buol"]
[null,"North Carolina State University, Raleigh NC USA"]

{"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 (₵/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 Reduction","YLD"]

{"sheet":"Lists","index":4,"n_rows":21,"n_cols":27,"rows_kept":21,"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\\Method","Pest_Management\\Aphid_Spray","Pest_Management\\Bird_Protection","Pest_Management\\Fungicides","Pest_Management\\Rodent_Protection","Pest_Management\\Weed_Control","Storage\\Groundnut_Moisture","Storage\\Temperature","Field\\Soil_Fertility","Field\\Calciprill_Application"]
["Crop\\Planting_Date",null,"Crop\\Planting_Date","Crop\\Planting_Date","Date","(01) January","ac","Chinese (Span)","01|5 plants (20 cm spacing)","No","Groundnut : Groundnut : Groundnut","01|None","4.4 or lower","Flat Beds (Conventional)","01|15 Days Early","Cemented floor","001 to 243","Sealed","No","No","01|None","No","01|1 hand weeding during season","01|Less than 10%","01|Lower than 28 °C","01|Low","No"]
["Crop\\Plants_per_1m_of_Row",null,"Crop\\Plants_per_1m_of_Row","Crop\\Plants_per_1m_of_Row","Single","(02) February","ha","Konkoma (Span)","02|7 plants (15 cm spacing)","Yes","Groundnut : Maize : Groundnut","02|50 kg/ha (Yara Legume)","4.5 to 5.0","Plough and harrow (Improved)","02|7 Days Early","Ground","244 to 257","Traditional","Yes","Yes","02|1 Spray","Yes","02|2 hand weedings during season","02|10 to 15%","02|28 to 32 °C","02|Moderate","Yes"]
["Crop\\Seed_Inoculant",null,"Crop\\Seed_Inoculant","Crop\\Seed_Inoculant","Single","(03) March",null,"Yenyawoso (Span-GRDR)","03|10 plants (10 cm spacing, optimum)",null,"Maize : Groundnut : Groundnut","03|100 kg/ha (Yara Legume)","5.1 to 5.5",null,"03|Optimum","Tarpulin","258 to 365",null,null,null,"03|2 Sprays",null,"03|Pre herbicides followed by 1 hand weeding","03|Greater than 15%","03|Higher than 32 °C","03|High"]
["Crop\\Variety",null,"Crop\\Variety","Crop\\Variety","Single","(04) April",null,null,null,null,"Maize : Groundnut : Maize","04|150 kg/ha (Yara Legume)","5.6 to 6.9",null,"04|7 Days Late",null,null,null,null,null,"04|3 Sprays",null,"04|Post herbicides followed by 1 hand weeding"]
["Field\\Calciprill_Application",null,"Field\\Calciprill_Application","Field\\Calciprill_Application","Single","(05) May",null,null,null,null,"Maize : Maize : Groundnut",null,"7.0 or higher",null,"05|15 Days Late"]
["Field\\Crop_Rotation",null,"Field\\Crop_Rotation","Field\\Crop_Rotation","Single","(06) June"]
["Field\\Fertilizer",null,"Field\\Fertilizer","Field\\Fertilizer","Single","(07) July"]
["Field\\Soil_Fertility",null,"Field\\Soil_Fertility","Field\\Soil_Fertility","Single","(08) August"]
["Field\\Soil_pH",null,"Field\\Soil_pH","Field\\Soil_pH","pH","(09) September"]
["Field\\Tillage",null,"Field\\Tillage","Field\\Tillage","Single","(10) October"]
["Harvest\\Digging_Timimg",null,"Harvest\\Digging_Timimg","Harvest\\Digging_Timimg","Single","(11) November"]
["Harvest\\Drying",null,"Harvest\\Drying","Harvest\\Drying","Single","(12) December"]
["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":46,"n_cols":14,"rows_kept":46,"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 (₵/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hours (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hours (hrs/ha)"}]
["Category","Item",{"$f":"CONCATENATE(\"Cost (₵/\",sel_Land_Area_Units,\")\")","v":"Cost (₵/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,1000,null,null,null,"Base_Cost",{"$f":"Cost_Base","v":1000},{"$f":"Cost_Base","v":1000},{"$f":"Cost_Base","v":1000},{"$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,null,null,"Crop\\Seed_Inoculant | Crop\\Plants_per_1m_of_Row",{"$f":"calcCostMax(G4,Category)","v":90},{"$f":"calcCostMin(G4)","v":0},{"$f":"calcCost(G4,N4,Category)","v":90},{"$f":"calcPersonHrsMax(G4,Category)","v":0},{"$f":"calcPersonHrsMin(G4)","v":0},{"$f":"calcPersonHrs(G4,N4,Category)","v":0},{"$f":"CONCATENATE(IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant),\" | \",IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row))","v":"Yes | 10 plants (10 cm spacing, optimum)"}]
["Crop\\Plants_per_1m_of_Row","7 plants (15 cm spacing)",null,0.7,null,null,"Crop\\Variety | Crop\\Plants_per_1m_of_Row",635,317.5,635,0,0,0,{"$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":"Yenyawoso (Span-GRDR) | 10 plants (10 cm spacing, optimum)"}]
["Crop\\Plants_per_1m_of_Row","10 plants (10 cm spacing, optimum)",null,1,null,null,"Field\\Calciprill_Application",625,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Calciprill_Application),\"\",sel_Field\\Calciprill_Application))","v":"No"}]
["Crop\\Seed_Inoculant","No",0,null,null,null,"Field\\Fertilizer",750,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Fertilizer),\"\",sel_Field\\Fertilizer))","v":"None"}]
["Crop\\Seed_Inoculant","Yes",90,null,null,null,"Field\\Soil_pH",0,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH))","v":"4.6"}]
["Crop\\Variety","Chinese (Span)",635,null,null,null,"Field\\Tillage",600,300,300,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage))","v":"Flat Beds (Conventional)"}]
["Crop\\Variety","Konkoma (Span)",635,null,null,null,"Harvest\\Drying",100,0,100,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Harvest\\Drying),\"\",sel_Harvest\\Drying))","v":"Tarpulin"}]
["Crop\\Variety","Yenyawoso (Span-GRDR)",635,null,null,null,"Pest_Management\\Aphid_Spray",110,0,110,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray))","v":"Yes"}]
["Field\\Calciprill_Application","No",0,null,null,null,"Pest_Management\\Bird_Protection",120,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Bird_Protection),\"\",sel_Pest_Management\\Bird_Protection))","v":"No"}]
["Field\\Calciprill_Application","Yes",625,null,null,null,"Pest_Management\\Fungicides",480,0,320,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides))","v":"2 Sprays"}]
["Field\\Fertilizer","None",0,null,null,null,"Pest_Management\\Rodent_Protection",500,0,500,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection))","v":"Yes"}]
["Field\\Fertilizer","50 kg/ha (Yara Legume)",310,null,null,null,"Pest_Management\\Weed_Control",1000,500,1000,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control))","v":"2 hand weedings during season"}]
["Field\\Fertilizer","100 kg/ha (Yara Legume)",530,null,null,null,"Storage\\Method",300,60,60,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Storage\\Method),\"\",sel_Storage\\Method))","v":"Traditional"}]
["Field\\Fertilizer","150 kg/ha (Yara Legume)",750,null,null,null,"Storage\\Temperature",0,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Storage\\Temperature),\"\",sel_Storage\\Temperature))","v":"Lower than 28 °C"}]
["Field\\Soil_pH","4.4 or lower",0]
["Field\\Soil_pH","4.5 to 5.0",0,null,null,null,"Total",{"$f":"SUM(H$3:H17)","v":6310},{"$f":"SUM(I$3:I17)","v":2177.5},{"$f":"IF(ISERROR(SUM(J$3:J17)),0,SUM(J$3:J17))","v":4115},{"$f":"SUM(K$3:K17)","v":0},{"$f":"SUM(L$3:L17)","v":0},{"$f":"IF(ISERROR(SUM(M$3:M17)),0,SUM(M$3:M17))","v":0}]
["Field\\Soil_pH","5.1 to 5.5",0]
["Field\\Soil_pH","5.6 to 6.9",0,null,null,null,null,{"$f":"CONCATENATE(\"Cost Thresholds (₵/\",sel_Land_Area_Units,\")\")","v":"Cost Thresholds (₵/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hour Thresholds (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Thresholds (hrs/ha)"}]
["Field\\Soil_pH","7.0 or higher",0,null,null,null,"High",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":4932.5137749999994},null,null,{"$f":"PersonHours_Min + 0.66667*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field\\Tillage","Flat Beds (Conventional)",300,null,null,null,"Moderate",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":3554.9862250000001},null,null,{"$f":"PersonHours_Min + 0.33333*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field\\Tillage","Plough and harrow (Improved)",600]
["Harvest\\Drying","Cemented floor",20,null,null,null,null,{"$f":"CONCATENATE(\"Cost Ranges (₵/\",sel_Land_Area_Units,\")\")","v":"Cost Ranges (₵/ha)"},null,null,{"$f":"CONCATENATE(\"Person Hour Ranges (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Ranges (hrs/ha)"}]
["Harvest\\Drying","Ground",0,null,null,null,"Base",{"$f":"Cost_Base","v":1000},null,null,{"$f":"PersonHours_Base","v":0}]
["Harvest\\Drying","Tarpulin",100,null,null,null,"Low",{"$f":"Cost_Moderate-Cost_Base","v":2554.9862250000001},null,null,{"$f":"PersonHours_Moderate-PersonHours_Base","v":0}]
["Pest_Management\\Aphid_Spray","No",0,null,null,null,"Moderate",{"$f":"Cost_High-Cost_Moderate","v":1377.5275499999993},null,null,{"$f":"PersonHours_High-PersonHours_Moderate","v":0}]
["Pest_Management\\Aphid_Spray","Yes",110,null,null,null,"High",{"$f":"Cost_Max-Cost_High","v":1377.4862250000006},null,null,{"$f":"PersonHours_Max-PersonHours_High","v":0}]
["Pest_Management\\Bird_Protection","No",0]
["Pest_Management\\Bird_Protection","Yes",120,null,null,null,{"$f":"CONCATENATE(\"Estimated Cost (₵/\",sel_Land_Area_Units,\"): \",ROUNDUP(TRUNC(Cost,2),0))","v":"Estimated Cost (₵/ha): 4115"}]
["Pest_Management\\Fungicides","None",0]
["Pest_Management\\Fungicides","1 Spray",160]
["Pest_Management\\Fungicides","2 Sprays",320]
["Pest_Management\\Fungicides","3 Sprays",480]
["Pest_Management\\Rodent_Protection","No",0]
["Pest_Management\\Rodent_Protection","Yes",500]
["Pest_Management\\Weed_Control","1 hand weeding during season",500,null,null,null,{"$f":"CONCATENATE(\"Estimated Person Hours (hrs/\",sel_Land_Area_Units,\"): \",ROUNDUP(TRUNC(PersonHours,2),0))","v":"Estimated Person Hours (hrs/ha): 0"}]
["Pest_Management\\Weed_Control","2 hand weedings during season",1000]
["Pest_Management\\Weed_Control","Pre herbicides followed by 1 hand weeding",500]
["Pest_Management\\Weed_Control","Post herbicides followed by 1 hand weeding",500]
["Storage\\Method","Sealed",300]
["Storage\\Method","Traditional",60]
["Storage\\Temperature","Lower than 28 °C",0]
["Storage\\Temperature","28 to 32 °C",0]
["Storage\\Temperature","Higher than 32 °C",0]

{"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":79,"n_cols":4,"rows_kept":79,"cut":false,"hidden":true,"merged":[[74,3,76,3],[78,0,78,3],[70,0,70,1],[70,2,70,3],[71,3,72,3],[73,0,73,1],[73,2,73,3],[35,0,35,1],[35,2,35,3],[36,3,37,3],[30,0,30,1],[30,2,30,3],[24,3,25,3],[26,0,26,1],[26,2,26,3],[27,3,29,3],[31,3,34,3],[13,3,17,3],[18,0,18,1],[18,2,18,3],[19,3,22,3],[23,0,23,1],[23,2,23,3],[38,0,38,1],[38,2,38,3],[39,3,42,3],[43,0,43,1],[43,2,43,3],[44,3,46,3],[47,0,47,1],[47,2,47,3],[48,3,49,3],[54,3,57,3],[58,0,58,1],[58,2,58,3],[59,3,60,3],[50,0,50,1],[50,2,50,3],[51,3,52,3],[53,0,53,1],[53,2,53,3],[62,3,65,3],[66,0,66,1],[66,2,66,3],[67,3,69,3],[61,0,61,1],[61,2,61,3],[10,3,11,3],[12,0,12,1],[0,0,0,3],[5,0,5,1],[5,2,5,3],[6,3,8,3],[9,0,9,1],[9,2,9,3],[12,2,12,3]]}
["Groundnut - Aflatoxin Risk Summary"]
[]
[]
[]
[]
["Crop\\Plants per 1m of Row",null,"Risk Points"]
[null,"5 plants (20 cm spacing)",80,15]
[null,"7 plants (15 cm spacing)",40]
[null,"10 plants (10 cm spacing, optimum)",15]
["Crop\\Seed Inoculant",null,"Risk Points"]
[null,"No",15,5]
[null,"Yes*",5]
["Field\\Crop Rotation",null,"Risk Points"]
[null,"Groundnut : Groundnut : Groundnut*",50,50]
[null,"Maize : Groundnut : Groundnut",45]
[null,"Groundnut : Maize : Groundnut",40]
[null,"Maize : Groundnut : Maize",15]
[null,"Maize : Maize : Groundnut",5]
["Field\\Fertilizer",null,"Risk Points"]
[null,"None*",40,40]
[null,"50 kg/ha (Yara Legume)",20]
[null,"100 kg/ha (Yara Legume)",15]
[null,"150 kg/ha (Yara Legume)",5]
["Field\\Gypsum at Bloom",null,"Risk Points"]
[null,"No*",10,10]
[null,"Yes",5]
["Field\\Soil Fertility",null,"Risk Points"]
[null,"Low*",20,20]
[null,"Moderate",0]
[null,"High",-20]
["Field\\Soil pH",null,"Risk Points"]
[null,"4.4 or lower, 7.0 or higher",50,30]
[null,"4.5 to 5.0*",30]
[null,"5.1 to 5.5",20]
[null,"5.6 to 6.9",5]
["Field\\Tillage",null,"Risk Points"]
[null,"Flat Beds (Conventional)*",20,20]
[null,"Plough and harrow (Improved)",10]
["Harvest\\Digging Timimg",null,"Risk Points"]
[null,"15 Days Late",60,10]
[null,"15 Days Early",40]
[null,"7 Days Early, 7 Days Late",15]
[null,"Optimum*",10]
["Harvest\\Drying",null,"Risk Points"]
[null,"Ground",80,15]
[null,"Cemented floor",20]
[null,"Tarpulin*",15]
["Pest Management\\Aphid Spray",null,"Risk Points"]
[null,"No",10,5]
[null,"Yes*",5]
["Pest Management\\Bird Protection",null,"Risk Points"]
[null,"No*",25,25]
[null,"Yes",5]
["Pest Management\\Fungicides",null,"Risk Points"]
[null,"None",20,10]
[null,"1 Spray",15]
[null,"2 Sprays*",10]
[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",35,15]
[null,"Post herbicides followed by 1 hand weeding",20]
[null,"2 hand weedings during season*",15]
[null,"Pre herbicides followed by 1 hand weeding",10]
["Storage\\Groundnut Moisture",null,"Risk Points"]
[null,"Greater than 15%",120,5]
[null,"10 to 15%",40]
[null,"Less than 10%*",5]
["Storage\\Method",null,"Risk Points"]
[null,"Traditional*",160,160]
[null,"Sealed",10]
["Storage\\Temperature",null,"Risk Points"]
[null,"Higher than 32 °C",160,20]
[null,"28 to 32 °C",80]
[null,"Lower than 28 °C*",20]
[]
["* 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":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Yield Reduction"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop\\Planting_Date",1,"258 to 365",160,null,null,null,"Crop\\Planting_Date",160,35,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Date\")","v":160},{"$f":"IF(ISBLANK(sel_Crop\\Planting_Date),\"\",sel_Crop\\Planting_Date)","v":"2021-09-30"}]
["Crop\\Planting_Date",2,"244 to 257",80,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 243",35,null,null,null,"Field\\Soil_pH",100,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"pH\")","v":50},{"$f":"IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH)","v":4.5999999999999996}]
["Crop\\Plants_per_1m_of_Row",1,"5 plants (20 cm spacing)",80,null,null,null,"Harvest\\Digging_Timimg",100,10,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Harvest\\Digging_Timimg),\"\",sel_Harvest\\Digging_Timimg)","v":"Optimum"}]
["Crop\\Plants_per_1m_of_Row",2,"7 plants (15 cm spacing)",40,null,null,null,"Pest_Management\\Bird_Protection",100,20,100,{"$f":"IF(ISBLANK(sel_Pest_Management\\Bird_Protection),\"\",sel_Pest_Management\\Bird_Protection)","v":"No"}]
["Crop\\Plants_per_1m_of_Row",3,"10 plants (10 cm spacing, optimum)",15,null,null,null,"Pest_Management\\Fungicides",100,-50,-25,{"$f":"IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides)","v":"2 Sprays"}]
["Crop\\Seed_Inoculant",1,"No",10,null,null,null,"Pest_Management\\Weed_Control",100,10,20,{"$f":"IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control)","v":"2 hand weedings during season"}]
["Crop\\Seed_Inoculant",2,"Yes",5,null,null,null,"Crop\\Plants_per_1m_of_Row",80,15,15,{"$f":"IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row)","v":"10 plants (10 cm spacing, optimum)"}]
["Crop\\Variety",1,"Chinese (Span)|Konkoma (Span)",55,null,null,null,"Field\\Tillage",80,20,80,{"$f":"IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage)","v":"Flat Beds (Conventional)"}]
["Crop\\Variety",2,"Yenyawoso (Span-GRDR)",35,null,null,null,"Pest_Management\\Aphid_Spray",80,10,10,{"$f":"IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray)","v":"Yes"}]
["Field\\Calciprill_Application",1,"No",15,null,null,null,"Crop\\Variety",55,35,35,{"$f":"IF(ISBLANK(sel_Crop\\Variety),\"\",sel_Crop\\Variety)","v":"Yenyawoso (Span-GRDR)"}]
["Field\\Calciprill_Application",2,"Yes",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"}]
["Field\\Crop_Rotation",1,"Groundnut : Groundnut : Groundnut",50,null,null,null,"Field\\Fertilizer",50,-100,50,{"$f":"IF(ISBLANK(sel_Field\\Fertilizer),\"\",sel_Field\\Fertilizer)","v":"None"}]
["Field\\Crop_Rotation",2,"Maize : Groundnut : Groundnut",45,null,null,null,"Pest_Management\\Rodent_Protection",40,5,5,{"$f":"IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection)","v":"Yes"}]
["Field\\Crop_Rotation",3,"Groundnut : Maize : Groundnut",40,null,null,null,"Field\\Calciprill_Application",15,5,15,{"$f":"IF(ISBLANK(sel_Field\\Calciprill_Application),\"\",sel_Field\\Calciprill_Application)","v":"No"}]
["Field\\Crop_Rotation",4,"Maize : Groundnut : Maize",15,null,null,null,"Crop\\Seed_Inoculant",10,5,5,{"$f":"IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant)","v":"Yes"}]
["Field\\Crop_Rotation",5,"Maize : Maize : Groundnut",5]
["Field\\Fertilizer",1,"None",50,null,null,null,"Total",{"$f":"SUMIF(I3:I18,\">0\")","v":1220},{"$f":"SUMIF(J3:J18,\">0\")","v":185},{"$f":"MAX(YLD_MinRiskIndex,SUM(K3:K18))","v":680}]
["Field\\Fertilizer",2,"50 kg/ha (Yara Legume)",0]
["Field\\Fertilizer",3,"100 kg/ha (Yara Legume)",-50,null,null,null,"High Risk Index",800]
["Field\\Fertilizer",4,"150 kg/ha (Yara Legume)",-100,null,null,null,"Moderate Risk Index",350]
["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)",80]
["Field\\Tillage",2,"Plough and harrow (Improved)",20]
["Harvest\\Digging_Timimg",1,"15 Days Late",100]
["Harvest\\Digging_Timimg",2,"15 Days Early",90]
["Harvest\\Digging_Timimg",3,"7 Days Early|7 Days Late",20]
["Harvest\\Digging_Timimg",4,"Optimum",10]
["Pest_Management\\Aphid_Spray",1,"No",80]
["Pest_Management\\Aphid_Spray",2,"Yes",10]
["Pest_Management\\Bird_Protection",1,"No",100]
["Pest_Management\\Bird_Protection",2,"Yes",20]
["Pest_Management\\Fungicides",1,"None",100]
["Pest_Management\\Fungicides",2,"1 Spray",5]
["Pest_Management\\Fungicides",3,"2 Sprays",-25]
["Pest_Management\\Fungicides",4,"3 Sprays",-50]
["Pest_Management\\Rodent_Protection",1,"No",40]
["Pest_Management\\Rodent_Protection",2,"Yes",5]
["Pest_Management\\Weed_Control",1,"1 hand weeding during season",100]
["Pest_Management\\Weed_Control",2,"2 hand weedings during season|Post herbicides followed by 1 hand weeding",20]
["Pest_Management\\Weed_Control",3,"Pre herbicides followed by 1 hand weeding",10]

{"sheet":"AFLTXN","index":9,"n_rows":56,"n_cols":12,"rows_kept":56,"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\\Plants_per_1m_of_Row",1,"5 plants (20 cm spacing)",80,null,null,null,"Storage\\Method",160,10,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":160},{"$f":"IF(ISBLANK(sel_Storage\\Method),\"\",sel_Storage\\Method)","v":"Traditional"}]
["Crop\\Plants_per_1m_of_Row",2,"7 plants (15 cm spacing)",40,null,null,null,"Storage\\Temperature",160,20,20,{"$f":"IF(ISBLANK(sel_Storage\\Temperature),\"\",sel_Storage\\Temperature)","v":"Lower than 28 °C"}]
["Crop\\Plants_per_1m_of_Row",3,"10 plants (10 cm spacing, optimum)",15,null,null,null,"Storage\\Groundnut_Moisture",120,5,5,{"$f":"IF(ISBLANK(sel_Storage\\Groundnut_Moisture),\"\",sel_Storage\\Groundnut_Moisture)","v":"Less than 10%"}]
["Crop\\Seed_Inoculant",1,"No",15,null,null,null,"Crop\\Plants_per_1m_of_Row",80,15,15,{"$f":"IF(ISBLANK(sel_Crop\\Plants_per_1m_of_Row),\"\",sel_Crop\\Plants_per_1m_of_Row)","v":"10 plants (10 cm spacing, optimum)"}]
["Crop\\Seed_Inoculant",2,"Yes",5,null,null,null,"Harvest\\Drying",80,15,15,{"$f":"IF(ISBLANK(sel_Harvest\\Drying),\"\",sel_Harvest\\Drying)","v":"Tarpulin"}]
["Field\\Calciprill_Application",1,"No",10,null,null,null,"Harvest\\Digging_Timimg",60,10,10,{"$f":"IF(ISBLANK(sel_Harvest\\Digging_Timimg),\"\",sel_Harvest\\Digging_Timimg)","v":"Optimum"}]
["Field\\Calciprill_Application",2,"Yes",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"}]
["Field\\Crop_Rotation",1,"Groundnut : Groundnut : Groundnut",50,null,null,null,"Field\\Soil_pH",50,5,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"pH\")","v":30},{"$f":"IF(ISBLANK(sel_Field\\Soil_pH),\"\",sel_Field\\Soil_pH)","v":4.5999999999999996}]
["Field\\Crop_Rotation",2,"Maize : Groundnut : Groundnut",45,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"}]
["Field\\Crop_Rotation",3,"Groundnut : Maize : Groundnut",40,null,null,null,"Pest_Management\\Weed_Control",35,10,15,{"$f":"IF(ISBLANK(sel_Pest_Management\\Weed_Control),\"\",sel_Pest_Management\\Weed_Control)","v":"2 hand weedings during season"}]
["Field\\Crop_Rotation",4,"Maize : Groundnut : Maize",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"}]
["Field\\Crop_Rotation",5,"Maize : Maize : Groundnut",5,null,null,null,"Field\\Soil_Fertility",20,-20,20,{"$f":"IF(ISBLANK(sel_Field\\Soil_Fertility),\"\",sel_Field\\Soil_Fertility)","v":"Low"}]
["Field\\Fertilizer",1,"None",40,null,null,null,"Field\\Tillage",20,10,20,{"$f":"IF(ISBLANK(sel_Field\\Tillage),\"\",sel_Field\\Tillage)","v":"Flat Beds (Conventional)"}]
["Field\\Fertilizer",2,"50 kg/ha (Yara Legume)",20,null,null,null,"Pest_Management\\Fungicides",20,5,10,{"$f":"IF(ISBLANK(sel_Pest_Management\\Fungicides),\"\",sel_Pest_Management\\Fungicides)","v":"2 Sprays"}]
["Field\\Fertilizer",3,"100 kg/ha (Yara Legume)",15,null,null,null,"Pest_Management\\Rodent_Protection",20,5,5,{"$f":"IF(ISBLANK(sel_Pest_Management\\Rodent_Protection),\"\",sel_Pest_Management\\Rodent_Protection)","v":"Yes"}]
["Field\\Fertilizer",4,"150 kg/ha (Yara Legume)",5,null,null,null,"Crop\\Seed_Inoculant",15,5,5,{"$f":"IF(ISBLANK(sel_Crop\\Seed_Inoculant),\"\",sel_Crop\\Seed_Inoculant)","v":"Yes"}]
["Field\\Soil_Fertility",1,"Low",20,null,null,null,"Field\\Calciprill_Application",10,5,10,{"$f":"IF(ISBLANK(sel_Field\\Calciprill_Application),\"\",sel_Field\\Calciprill_Application)","v":"No"}]
["Field\\Soil_Fertility",2,"Moderate",0,null,null,null,"Pest_Management\\Aphid_Spray",10,5,5,{"$f":"IF(ISBLANK(sel_Pest_Management\\Aphid_Spray),\"\",sel_Pest_Management\\Aphid_Spray)","v":"Yes"}]
["Field\\Soil_Fertility",3,"High",-20]
["Field\\Soil_pH",1,"4.4 or lower|7.0 or higher",50,null,null,null,"Total",{"$f":"SUMIF(I3:I20,\">0\")","v":975},{"$f":"SUMIF(J3:J20,\">0\")","v":140},{"$f":"MAX(AFLTXN_MinRiskIndex,SUM(K3:K20))","v":460}]
["Field\\Soil_pH",2,"4.5 to 5.0",30]
["Field\\Soil_pH",3,"5.1 to 5.5",20,null,null,null,"High Risk Index",700]
["Field\\Soil_pH",4,"5.6 to 6.9",5,null,null,null,"Moderate Risk Index",350]
["Field\\Tillage",1,"Flat Beds (Conventional)",20]
["Field\\Tillage",2,"Plough and harrow (Improved)",10]
["Harvest\\Digging_Timimg",1,"15 Days Late",60]
["Harvest\\Digging_Timimg",2,"15 Days Early",40]
["Harvest\\Digging_Timimg",3,"7 Days Early|7 Days Late",15]
["Harvest\\Digging_Timimg",4,"Optimum",10]
["Harvest\\Drying",1,"Ground",80]
["Harvest\\Drying",2,"Cemented floor",20]
["Harvest\\Drying",3,"Tarpulin",15]
["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,"Post herbicides followed by 1 hand weeding",20]
["Pest_Management\\Weed_Control",3,"2 hand weedings during season",15]
["Pest_Management\\Weed_Control",4,"Pre herbicides followed by 1 hand weeding",10]
["Storage\\Groundnut_Moisture",1,"Greater than 15%",120]
["Storage\\Groundnut_Moisture",2,"10 to 15%",40]
["Storage\\Groundnut_Moisture",3,"Less than 10%",5]
["Storage\\Method",1,"Traditional",160]
["Storage\\Method",2,"Sealed",10]
["Storage\\Temperature",1,"Higher than 32 °C",160]
["Storage\\Temperature",2,"28 to 32 °C",80]
["Storage\\Temperature",3,"Lower than 28 °C",20]