{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Risk","Crop","Log_TPL","Pests","Lists","Costs","Logos","Pest_Report","WDS","SM","LS","SB","SMUT"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":116,"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":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,6,6,7],[6,9,6,12],[6,13,6,16],[6,17,6,20],[4,6,4,7],[4,9,4,12],[4,13,4,16],[4,17,4,20],[1,5,1,6],[2,6,2,7],[2,9,2,12],[2,13,2,16],[2,17,2,20],[9,6,9,7],[9,9,9,12],[9,13,9,16],[9,17,9,20],[12,6,14,20]]}
[]
[]
[null,null,null,"Crop Practices",null,null,"Arthropod",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Cultivar","MA-02",null,null,"Spider Mites",{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73},{"$f":"SM_RiskIndex","v":73}]
[null,null,null,"Plant Pattern","<6 plts/m (90 cm twin row)",null,"Disease (Foliar)",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Field",null,null,null,"Leaf Spot",{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284},{"$f":"LS_RiskIndex","v":284}]
[null,null,null,"Soil Smut Inoculum","1500 or greater spores/g soil",null,"Disease (Soil Borne)",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Tillage System","Reduced Tillage",null,null,"Sclerotinia Blight",{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228},{"$f":"SB_RiskIndex","v":228}]
[null,null,null,"Weeds and Herbicide Resistance","Palmer A. (ALS resistant)",null,null,"Smut",{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275},{"$f":"SMUT_RiskIndex","v":275}]
[null,null,null,"Field Crop History",null,null,"Plant",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Crop 1 Season Ago","Soybean",null,null,"Weeds",{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92},{"$f":"WDS_RiskIndex","v":92}]
[null,null,null,"Crop 2 Seasons Ago","Soybean"]
[null,null,null,"Crop 3 Seasons Ago","Soybean",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,"Leaf Spot Management"]
[null,null,null,"Chlorothalonil Applications","3 Sprays"]
[null,null,null,"Fungicide Resistance","Groups 3+7+11+M"]
[null,null,null,"Spray Schedule","Calendar"]
[null,null,null,"Pest History"]
[null,null,null,"Leaf Spot","Problem with good fungicide program"]
[null,null,null,"Sclerotoina Blight","Present"]
[null,null,null,"Smut","Problem with good fungicide program"]
[null,null,null,"Treatments"]
[null,null,null,"Iridium Applictions","None"]
[null,null,null,"Miticides","Abamectin"]
[null,null,null,"Weed Mgmt","PRE + EPOST + MPOST"]
[null,null,null,"Weather Pattern"]
[null,null,null,"Period 1 Sept and Oct","Moist"]
[null,null,null,"Period 2 Nov and Dec","Moist"]
[null,null,null,"Period 3 Jan and Feb","Moist"]
[null,null,null,"Period 4 Mar and Apr","Moist"]

{"sheet":"Crop","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[[11,1,11,5],[12,1,12,5],[13,1,13,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]]}
["Crop","Peanut"]
[]
["Planting Season","Date","Month","Day of Month","Day of Year"]
["Start","2021-10-10",{"$f":"MONTH(B4)","v":10},{"$f":"DAY(B4)","v":10},{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":283}]
["End","2021-11-20",{"$f":"MONTH(B5)","v":11},{"$f":"DAY(B5)","v":20},{"$f":"B5-DATE(YEAR(B5),1,1)+1","v":324}]
[]
["Title","Argentina Peanut Risk Management Tool"]
["Subtitle"]
["Credit Lines","Sergio A. Morichetti"]
[null,"Head of Technical Development in the Agricultural Business Unit"]
[null,"Aceitera General Deheza SA"]
[null,"Juan Paredes and Joaquin Monguillot"]
[null,"Agricultural Research Center-National Institute of Agricultural Technology"]
[null,"David Jordan and Greg 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":"Peanut"},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 (A)"]
[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 (lbs/acre)"]
[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,"lbs/acre"]
[]
[]
[]
[]
[]
[null,null,null,"Land Plaster","Date","Trade Name","Type","Method","Rate (lbs/acre)"]
[]
[]
[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 (lbs/acre)"]
[null,null,null,"Yield (lbs/acre)"]
[null,null,null,"Selling Price ($/lb)"]
[]
[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 (in)","Month",null,"Month","Amount (in)"]
[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":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["PestType","Pest","PestID"]
["Arthropod","Spider Mites","SM"]
["Disease (Foliar)","Leaf Spot","LS"]
["Disease (Soil Borne)","Sclerotinia Blight","SB"]
["Disease (Soil Borne)","Smut","SMUT"]
["Plant","Weeds","WDS"]

{"sheet":"Lists","index":4,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Category","Category_Pest","CategoryID","Category_List","Category_List_Type","Months","Land_Area_Units","Crop_Practices\\Plant_Pattern","Crop_Practices\\Cultivar","Field\\Soil_Smut_Inoculum","Crops","Field\\Tillage_System","Pest_History\\Leaf_Spot","Pest_History\\Sclerotoina_Blight","Treatments\\Weed_Mgmt","Leaf_Spot_Management\\Spray_Schedule","Leaf_Spot_Management\\Chlorothalonil_Applications","Pest_History\\Smut","Treatments\\Miticides","Field\\Weeds_and_Herbicide_Resistance","Weather_Pattern\\Period_1_Sept_and_Oct","Weather_Pattern\\Period_3_Jan_and_Feb","Weather_Pattern\\Period_4_Mar_and_Apr","Weather_Pattern\\Period_2_Nov_and_Dec","Treatments\\Iridium_Applictions","Leaf_Spot_Management\\Fungicide_Resistance"]
["Crop_Practices\\Cultivar",null,"Crop_Practices\\Cultivar","Crop_Practices\\Cultivar","Single","(01) January","ac","01|< 10 plts/m (70 cm single row)","ASEM 400","01|0 - 499 spores/g soil","Corn","Cover Crop","01|No history","01|No history","01|None","01|Calendar","01|None","01|No history","01|None","Annual Grass","01|Dry","01|Dry","01|Dry","01|Dry","01|None","01|Group M (Multi-site)"]
["Crop_Practices\\Plant_Pattern",null,"Crop_Practices\\Plant_Pattern","Crop_Practices\\Plant_Pattern","Single","(02) February","ha","02|> 10 plts/m (70 cm single row)","EC-191 RC","02|500 - 999 spores/g soil","Peanut","No-Till","02|Present but controlled with good fungicide program","02|Present","02|PPL","02|Calendar (Skip when dry)","02|1 Spray","02|Present but controlled with good fungicide program","02|Abamectin","Annual Grass (ACC and ALS resistant)","02|Moist","02|Moist","02|Moist","02|Moist","02|1 Spray","02|Groups 3+7"]
["Field\\Soil_Smut_Inoculum",null,"Field\\Soil_Smut_Inoculum","Field\\Soil_Smut_Inoculum","Single","(03) March",null,"03|<6 plts/m (90 cm twin row)","EC-214","03|1000 - 1499 spores/g soil","Soybean","Reduced Tillage","03|Problem with good fungicide program",null,"03|PRE",null,"02|2 Sprays","03|Problem with good fungicide program",null,"Annual Grass (ACC resistant)","03|Wet","03|Wet","03|Wet","03|Wet","03|2 Sprays","03|Groups 3+11"]
["Field\\Tillage_System",null,"Field\\Tillage_System","Field\\Tillage_System","Single","(04) April",null,"04|>6 plts/m (90 cm twin row)","EC-98","04|1500 or greater spores/g soil",null,null,null,null,"04|PRE + EPOST",null,"03|3 Sprays",null,null,"Annual Grass (ALS resistant)",null,null,null,null,null,"04|Groups 7+11"]
["Field\\Weeds_and_Herbicide_Resistance",null,"Field\\Weeds_and_Herbicide_Resistance","Field\\Weeds_and_Herbicide_Resistance","Single","(05) May",null,null,"Granoleico",null,null,null,null,null,"05|PRE + EPOST + MPOST",null,null,null,null,"Conyza",null,null,null,null,null,"05|Groups 3+7+11"]
["Field_Crop_History\\Crop_1_Season_Ago",null,"Field_Crop_History\\Crop_1_Season_Ago","Crops","Single","(06) June",null,null,"MA-02",null,null,null,null,null,"06|PRE + EPOST + MPOST + LPOST",null,null,null,null,"Conyza (Glyphosate resistant)",null,null,null,null,null,"06|Groups 3+7+11+M"]
["Field_Crop_History\\Crop_2_Seasons_Ago",null,"Field_Crop_History\\Crop_2_Seasons_Ago","Crops","Single","(07) July",null,null,"MA-757",null,null,null,null,null,"07|PRE + EPOST + Hand weed",null,null,null,null,"Others"]
["Field_Crop_History\\Crop_3_Seasons_Ago",null,"Field_Crop_History\\Crop_3_Seasons_Ago","Crops","Single","(08) August",null,null,"MA-88",null,null,null,null,null,"08|PRE + EPOST + MPOST + Hand weed",null,null,null,null,"Palmer A."]
["Leaf_Spot_Management\\Chlorothalonil_Applications",null,"Leaf_Spot_Management\\Chlorothalonil_Applications","Leaf_Spot_Management\\Chlorothalonil_Applications","Single","(09) September",null,null,null,null,null,null,null,null,"09|PRE + EPOST + MPOST + LPOST + Hand weed",null,null,null,null,"Palmer A. (ALS resistant)"]
["Leaf_Spot_Management\\Fungicide_Resistance",null,"Leaf_Spot_Management\\Fungicide_Resistance","Leaf_Spot_Management\\Fungicide_Resistance","Single","(10) October",null,null,null,null,null,null,null,null,"10|EPOST",null,null,null,null,"Pigweed"]
["Leaf_Spot_Management\\Spray_Schedule",null,"Leaf_Spot_Management\\Spray_Schedule","Leaf_Spot_Management\\Spray_Schedule","Single","(11) November",null,null,null,null,null,null,null,null,"11|MPOST",null,null,null,null,"Pigweed (ALS resistant)"]
["Pest_History\\Leaf_Spot",null,"Pest_History\\Leaf_Spot","Pest_History\\Leaf_Spot","Single","(12) December",null,null,null,null,null,null,null,null,"12|LPOST",null,null,null,null,"Sedges"]
["Pest_History\\Sclerotoina_Blight",null,"Pest_History\\Sclerotoina_Blight","Pest_History\\Sclerotoina_Blight","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteer Corn"]
["Pest_History\\Smut",null,"Pest_History\\Smut","Pest_History\\Smut","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volunteer Soybean"]
["Treatments\\Iridium_Applictions",null,"Treatments\\Iridium_Applictions","Treatments\\Iridium_Applictions","Single"]
["Treatments\\Miticides",null,"Treatments\\Miticides","Treatments\\Miticides","Single"]
["Treatments\\Weed_Mgmt",null,"Treatments\\Weed_Mgmt","Treatments\\Weed_Mgmt","Single"]
["Weather_Pattern\\Period_1_Sept_and_Oct",null,"Weather_Pattern\\Period_1_Sept_and_Oct","Weather_Pattern\\Period_1_Sept_and_Oct","Single"]
["Weather_Pattern\\Period_2_Nov_and_Dec",null,"Weather_Pattern\\Period_2_Nov_and_Dec","Weather_Pattern\\Period_2_Nov_and_Dec","Single"]
["Weather_Pattern\\Period_3_Jan_and_Feb",null,"Weather_Pattern\\Period_3_Jan_and_Feb","Weather_Pattern\\Period_3_Jan_and_Feb","Single"]
["Weather_Pattern\\Period_4_Mar_and_Apr",null,"Weather_Pattern\\Period_4_Mar_and_Apr","Weather_Pattern\\Period_4_Mar_and_Apr","Single"]

{"sheet":"Costs","index":5,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,7,0,9],[0,10,0,12],[6,7,6,9],[6,10,6,12],[10,7,10,9],[10,10,10,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,0,null,null,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}]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H$3:H3)","v":0},{"$f":"SUM(I$3:I3)","v":0},{"$f":"IF(ISERROR(SUM(J$3:J3)),0,SUM(J$3:J3))","v":0},{"$f":"SUM(K$3:K3)","v":0},{"$f":"SUM(L$3:L3)","v":0},{"$f":"IF(ISERROR(SUM(M$3:M3)),0,SUM(M$3:M3))","v":0}]
[]
[null,null,null,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)"}]
[null,null,null,null,null,null,"High",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":0},null,null,{"$f":"PersonHours_Min + 0.66667*(PersonHours_Max-PersonHours_Min)","v":0}]
[null,null,null,null,null,null,"Moderate",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":0},null,null,{"$f":"PersonHours_Min + 0.33333*(PersonHours_Max-PersonHours_Min)","v":0}]
[]
[null,null,null,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)"}]
[null,null,null,null,null,null,"Base",{"$f":"Cost_Base","v":0},null,null,{"$f":"PersonHours_Base","v":0}]
[null,null,null,null,null,null,"Low",{"$f":"Cost_Moderate-Cost_Base","v":0},null,null,{"$f":"PersonHours_Moderate-PersonHours_Base","v":0}]
[null,null,null,null,null,null,"Moderate",{"$f":"Cost_High-Cost_Moderate","v":0},null,null,{"$f":"PersonHours_High-PersonHours_Moderate","v":0}]
[null,null,null,null,null,null,"High",{"$f":"Cost_Max-Cost_High","v":0},null,null,{"$f":"PersonHours_Max-PersonHours_High","v":0}]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Estimated Cost: $\",ROUNDUP(TRUNC(Cost,2),0),\"/\",sel_Land_Area_Units)","v":"Estimated Cost: $0/ha"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Estimated Person Hours: \",ROUNDUP(TRUNC(PersonHours,2),0),\" hrs/\",sel_Land_Area_Units)","v":"Estimated Person Hours: 0 hrs/ha"}]

{"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":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":true,"merged":[[10,3,11,3],[19,0,19,1],[19,2,19,3],[16,0,16,1],[16,2,16,3],[0,0,0,3],[5,0,5,1],[5,2,5,3],[6,3,8,3],[9,0,9,1],[9,2,9,3],[28,0,28,1],[28,2,28,3],[25,0,25,1],[25,2,25,3],[26,3,27,3],[29,3,31,3],[47,0,47,1],[47,2,47,3],[48,3,50,3],[35,0,35,1],[35,2,35,3],[36,3,38,3],[39,0,39,1],[39,2,39,3],[32,0,32,1],[32,2,32,3],[33,3,34,3],[51,0,51,1],[51,2,51,3],[52,3,54,3],[56,0,56,3],[12,0,12,1],[12,2,12,3],[13,3,15,3],[17,3,18,3],[20,3,21,3],[22,0,22,1],[22,2,22,3],[23,3,24,3],[40,3,42,3],[43,0,43,1],[43,2,43,3],[44,3,46,3]]}
["Peanut - Leaf Spot Risk Summary"]
[]
[]
[]
[]
["Crop Practices\\Cultivar",null,"Risk Points"]
[null,"ASEM 400, EC-98",35,32]
[null,"Granoleico, MA-02*",32]
[null,"EC-191 RC, EC-214, MA-757, MA-88",30]
["Crop Practices\\Plant Pattern",null,"Risk Points"]
[null,"> 10 plts/m (70 cm single row), >6 plts/m (90 cm twin row)",12,10]
[null,"< 10 plts/m (70 cm single row), <6 plts/m (90 cm twin row)*",10]
["Field\\Tillage System",null,"Risk Points"]
[null,"Reduced Tillage*",15,15]
[null,"No-Till",10]
[null,"Cover Crop",5]
["Field Crop History\\Crop 1 Season Ago",null,"Risk Points"]
[null,"Peanut",50,20]
[null,"Corn, Soybean*",20]
["Field Crop History\\Crop 2 Seasons Ago",null,"Risk Points"]
[null,"Peanut",40,20]
[null,"Corn, Soybean*",20]
["Field Crop History\\Crop 3 Seasons Ago",null,"Risk Points"]
[null,"Peanut",30,20]
[null,"Corn, Soybean*",20]
["Leaf Spot Management\\Chlorothalonil Applications",null,"Risk Points"]
[null,"None",15,5]
[null,"1 Spray, 2 Sprays, 3 Sprays*",5]
["Leaf Spot Management\\Fungicide Resistance",null,"Risk Points"]
[null,"Groups 3+7+11+M*",100,100]
[null,"Group M (Multi-site), Groups 3+7+11",60]
[null,"Groups 3+7, Groups 3+11, Groups 7+11",30]
["Leaf Spot Management\\Spray Schedule",null,"Risk Points"]
[null,"Calendar (Skip when dry)",10,5]
[null,"Calendar*",5]
["Pest History\\Leaf Spot",null,"Risk Points"]
[null,"Problem with good fungicide program*",20,20]
[null,"Present but controlled with good fungicide program",10]
[null,"No history",5]
["Weather Pattern\\Period 1 Sept and Oct",null,"Risk Points"]
[null,"Wet",5,2]
[null,"Moist*",2]
[null,"Dry",0]
["Weather Pattern\\Period 2 Nov and Dec",null,"Risk Points"]
[null,"Wet",15,5]
[null,"Moist*",5]
[null,"Dry",0]
["Weather Pattern\\Period 3 Jan and Feb",null,"Risk Points"]
[null,"Wet",30,20]
[null,"Moist*",20]
[null,"Dry",10]
["Weather Pattern\\Period 4 Mar and Apr",null,"Risk Points"]
[null,"Wet",20,10]
[null,"Moist*",10]
[null,"Dry",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":"WDS","index":8,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Weeds"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Practices\\Cultivar",1,"MA-02",20,null,null,null,"Field\\Weeds_and_Herbicide_Resistance",150,20,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":150},{"$f":"IF(ISBLANK(sel_Field\\Weeds_and_Herbicide_Resistance),\"\",sel_Field\\Weeds_and_Herbicide_Resistance)","v":"Palmer A. (ALS resistant)"}]
["Crop_Practices\\Cultivar",2,"EC-191 RC|EC-214|MA-757|MA-88",15,null,null,null,"Crop_Practices\\Cultivar",20,10,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Cultivar),\"\",sel_Crop_Practices\\Cultivar)","v":"MA-02"}]
["Crop_Practices\\Cultivar",3,"ASEM 400|EC-98|Granoleico",10,null,null,null,"Field\\Tillage_System",15,10,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":15},{"$f":"IF(ISBLANK(sel_Field\\Tillage_System),\"\",sel_Field\\Tillage_System)","v":"Reduced Tillage"}]
["Crop_Practices\\Plant_Pattern",1,"<6 plts/m (90 cm twin row)",12,null,null,null,"Crop_Practices\\Plant_Pattern",12,5,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":12},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Plant_Pattern),\"\",sel_Crop_Practices\\Plant_Pattern)","v":"<6 plts/m (90 cm twin row)"}]
["Crop_Practices\\Plant_Pattern",2,"< 10 plts/m (70 cm single row)",10,null,null,null,"Treatments\\Weed_Mgmt",0,-150,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":-105},{"$f":"IF(ISBLANK(sel_Treatments\\Weed_Mgmt),\"\",sel_Treatments\\Weed_Mgmt)","v":"PRE + EPOST + MPOST"}]
["Crop_Practices\\Plant_Pattern",3,">6 plts/m (90 cm twin row)",8]
["Crop_Practices\\Plant_Pattern",4,"> 10 plts/m (70 cm single row)",5,null,null,null,"Total",{"$f":"SUMIF(I3:I7,\">0\")","v":197},{"$f":"SUMIF(J3:J7,\">0\")","v":45},{"$f":"MAX(WDS_MinRiskIndex,SUM(K3:K7))","v":92}]
["Field\\Tillage_System",1,"No-Till|Reduced Tillage",15]
["Field\\Tillage_System",2,"Cover Crop",10,null,null,null,"High Risk Index",90]
["Field\\Weeds_and_Herbicide_Resistance",1,"Annual Grass (ACC and ALS resistant)|Conyza (Glyphosate resistant)|Palmer A. (ALS resistant)|Pigweed (ALS resistant)",150,null,null,null,"Moderate Risk Index",62]
["Field\\Weeds_and_Herbicide_Resistance",2,"Annual Grass (ACC resistant)|Annual Grass (ALS resistant)|Volunteer Soybean",100]
["Field\\Weeds_and_Herbicide_Resistance",3,"Palmer A.|Pigweed",90]
["Field\\Weeds_and_Herbicide_Resistance",4,"Conyza|Volunteer Corn",70]
["Field\\Weeds_and_Herbicide_Resistance",5,"Annual Grass|Sedges",50]
["Field\\Weeds_and_Herbicide_Resistance",6,"Others",20]
["Treatments\\Weed_Mgmt",1,"None|PPL|EPOST",0]
["Treatments\\Weed_Mgmt",2,"PRE|LPOST",-55]
["Treatments\\Weed_Mgmt",3,"PRE + EPOST|MPOST",-90]
["Treatments\\Weed_Mgmt",4,"PRE + EPOST + MPOST",-105]
["Treatments\\Weed_Mgmt",5,"PRE + EPOST + MPOST + LPOST",-130]
["Treatments\\Weed_Mgmt",6,"PRE + EPOST + Hand weed|PRE + EPOST + MPOST + Hand weed|PRE + EPOST + MPOST + LPOST + Hand weed",-150]

{"sheet":"SM","index":9,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Spider Mites"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Leaf_Spot_Management\\Chlorothalonil_Applications",1,"3 Sprays",25,null,null,null,"Leaf_Spot_Management\\Spray_Schedule",40,20,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":40},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Spray_Schedule),\"\",sel_Leaf_Spot_Management\\Spray_Schedule)","v":"Calendar"}]
["Leaf_Spot_Management\\Chlorothalonil_Applications",2,"2 Sprays",15,null,null,null,"Leaf_Spot_Management\\Chlorothalonil_Applications",25,0,25,{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Chlorothalonil_Applications),\"\",sel_Leaf_Spot_Management\\Chlorothalonil_Applications)","v":"3 Sprays"}]
["Leaf_Spot_Management\\Chlorothalonil_Applications",3,"1 Spray",5,null,null,null,"Weather_Pattern\\Period_3_Jan_and_Feb",25,5,15,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_3_Jan_and_Feb),\"\",sel_Weather_Pattern\\Period_3_Jan_and_Feb)","v":"Moist"}]
["Leaf_Spot_Management\\Chlorothalonil_Applications",4,"None",0,null,null,null,"Weather_Pattern\\Period_2_Nov_and_Dec",15,5,10,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_2_Nov_and_Dec),\"\",sel_Weather_Pattern\\Period_2_Nov_and_Dec)","v":"Moist"}]
["Leaf_Spot_Management\\Spray_Schedule",1,"Calendar",40,null,null,null,"Weather_Pattern\\Period_4_Mar_and_Apr",15,0,8,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_4_Mar_and_Apr),\"\",sel_Weather_Pattern\\Period_4_Mar_and_Apr)","v":"Moist"}]
["Leaf_Spot_Management\\Spray_Schedule",2,"Calendar (Skip when dry)",20,null,null,null,"Weather_Pattern\\Period_1_Sept_and_Oct",10,0,5,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_1_Sept_and_Oct),\"\",sel_Weather_Pattern\\Period_1_Sept_and_Oct)","v":"Moist"}]
["Treatments\\Miticides",1,"None",0,null,null,null,"Treatments\\Miticides",0,-30,-30,{"$f":"IF(ISBLANK(sel_Treatments\\Miticides),\"\",sel_Treatments\\Miticides)","v":"Abamectin"}]
["Treatments\\Miticides",2,"Abamectin",-30]
["Weather_Pattern\\Period_1_Sept_and_Oct",1,"Dry",10,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":130},{"$f":"SUMIF(J3:J9,\">0\")","v":30},{"$f":"MAX(SM_MinRiskIndex,SUM(K3:K9))","v":73}]
["Weather_Pattern\\Period_1_Sept_and_Oct",2,"Moist",5]
["Weather_Pattern\\Period_1_Sept_and_Oct",3,"Wet",0,null,null,null,"High Risk Index",98]
["Weather_Pattern\\Period_2_Nov_and_Dec",1,"Dry",15,null,null,null,"Moderate Risk Index",67]
["Weather_Pattern\\Period_2_Nov_and_Dec",2,"Moist",10]
["Weather_Pattern\\Period_2_Nov_and_Dec",3,"Wet",5]
["Weather_Pattern\\Period_3_Jan_and_Feb",1,"Dry",25]
["Weather_Pattern\\Period_3_Jan_and_Feb",2,"Moist",15]
["Weather_Pattern\\Period_3_Jan_and_Feb",3,"Wet",5]
["Weather_Pattern\\Period_4_Mar_and_Apr",1,"Dry",15]
["Weather_Pattern\\Period_4_Mar_and_Apr",2,"Moist",8]
["Weather_Pattern\\Period_4_Mar_and_Apr",3,"Wet",0]

{"sheet":"LS","index":10,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Leaf Spot"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Practices\\Cultivar",1,"ASEM 400|EC-98",35,null,null,null,"Leaf_Spot_Management\\Fungicide_Resistance",100,30,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":100},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Fungicide_Resistance),\"\",sel_Leaf_Spot_Management\\Fungicide_Resistance)","v":"Groups 3+7+11+M"}]
["Crop_Practices\\Cultivar",2,"Granoleico|MA-02",32,null,null,null,"Field_Crop_History\\Crop_1_Season_Ago",50,20,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_1_Season_Ago),\"\",sel_Field_Crop_History\\Crop_1_Season_Ago)","v":"Soybean"}]
["Crop_Practices\\Cultivar",3,"EC-191 RC|EC-214|MA-757|MA-88",30,null,null,null,"Field_Crop_History\\Crop_2_Seasons_Ago",40,20,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_2_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_2_Seasons_Ago)","v":"Soybean"}]
["Crop_Practices\\Plant_Pattern",1,"> 10 plts/m (70 cm single row)|>6 plts/m (90 cm twin row)",12,null,null,null,"Crop_Practices\\Cultivar",35,30,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":32},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Cultivar),\"\",sel_Crop_Practices\\Cultivar)","v":"MA-02"}]
["Crop_Practices\\Plant_Pattern",2,"< 10 plts/m (70 cm single row)|<6 plts/m (90 cm twin row)",10,null,null,null,"Field_Crop_History\\Crop_3_Seasons_Ago",30,20,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_3_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_3_Seasons_Ago)","v":"Soybean"}]
["Field\\Tillage_System",1,"Reduced Tillage",15,null,null,null,"Weather_Pattern\\Period_3_Jan_and_Feb",30,10,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_3_Jan_and_Feb),\"\",sel_Weather_Pattern\\Period_3_Jan_and_Feb)","v":"Moist"}]
["Field\\Tillage_System",2,"No-Till",10,null,null,null,"Pest_History\\Leaf_Spot",20,5,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Pest_History\\Leaf_Spot),\"\",sel_Pest_History\\Leaf_Spot)","v":"Problem with good fungicide program"}]
["Field\\Tillage_System",3,"Cover Crop",5,null,null,null,"Weather_Pattern\\Period_4_Mar_and_Apr",20,5,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_4_Mar_and_Apr),\"\",sel_Weather_Pattern\\Period_4_Mar_and_Apr)","v":"Moist"}]
["Field_Crop_History\\Crop_1_Season_Ago",1,"Peanut",50,null,null,null,"Field\\Tillage_System",15,5,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":15},{"$f":"IF(ISBLANK(sel_Field\\Tillage_System),\"\",sel_Field\\Tillage_System)","v":"Reduced Tillage"}]
["Field_Crop_History\\Crop_1_Season_Ago",2,"Corn|Soybean",20,null,null,null,"Leaf_Spot_Management\\Chlorothalonil_Applications",15,5,{"$f":"getRiskValue(\"A:A\",H12,J12,L12,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Chlorothalonil_Applications),\"\",sel_Leaf_Spot_Management\\Chlorothalonil_Applications)","v":"3 Sprays"}]
["Field_Crop_History\\Crop_2_Seasons_Ago",1,"Peanut",40,null,null,null,"Weather_Pattern\\Period_2_Nov_and_Dec",15,0,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_2_Nov_and_Dec),\"\",sel_Weather_Pattern\\Period_2_Nov_and_Dec)","v":"Moist"}]
["Field_Crop_History\\Crop_2_Seasons_Ago",2,"Corn|Soybean",20,null,null,null,"Crop_Practices\\Plant_Pattern",12,10,{"$f":"getRiskValue(\"A:A\",H14,J14,L14,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Plant_Pattern),\"\",sel_Crop_Practices\\Plant_Pattern)","v":"<6 plts/m (90 cm twin row)"}]
["Field_Crop_History\\Crop_3_Seasons_Ago",1,"Peanut",30,null,null,null,"Leaf_Spot_Management\\Spray_Schedule",10,5,{"$f":"getRiskValue(\"A:A\",H15,J15,L15,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Spray_Schedule),\"\",sel_Leaf_Spot_Management\\Spray_Schedule)","v":"Calendar"}]
["Field_Crop_History\\Crop_3_Seasons_Ago",2,"Corn|Soybean",20,null,null,null,"Weather_Pattern\\Period_1_Sept_and_Oct",5,0,{"$f":"getRiskValue(\"A:A\",H16,J16,L16,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_1_Sept_and_Oct),\"\",sel_Weather_Pattern\\Period_1_Sept_and_Oct)","v":"Moist"}]
["Leaf_Spot_Management\\Chlorothalonil_Applications",1,"None",15]
["Leaf_Spot_Management\\Chlorothalonil_Applications",2,"1 Spray|2 Sprays|3 Sprays",5,null,null,null,"Total",{"$f":"SUMIF(I3:I16,\">0\")","v":397},{"$f":"SUMIF(J3:J16,\">0\")","v":165},{"$f":"MAX(LS_MinRiskIndex,SUM(K3:K16))","v":284}]
["Leaf_Spot_Management\\Fungicide_Resistance",1,"Groups 3+7+11+M",100]
["Leaf_Spot_Management\\Fungicide_Resistance",2,"Group M (Multi-site)|Groups 3+7+11",60,null,null,null,"High Risk Index",280]
["Leaf_Spot_Management\\Fungicide_Resistance",3,"Groups 3+7|Groups 3+11|Groups 7+11",30,null,null,null,"Moderate Risk Index",212]
["Leaf_Spot_Management\\Spray_Schedule",1,"Calendar (Skip when dry)",10]
["Leaf_Spot_Management\\Spray_Schedule",2,"Calendar",5]
["Pest_History\\Leaf_Spot",1,"Problem with good fungicide program",20]
["Pest_History\\Leaf_Spot",2,"Present but controlled with good fungicide program",10]
["Pest_History\\Leaf_Spot",3,"No history",5]
["Weather_Pattern\\Period_1_Sept_and_Oct",1,"Wet",5]
["Weather_Pattern\\Period_1_Sept_and_Oct",2,"Moist",2]
["Weather_Pattern\\Period_1_Sept_and_Oct",3,"Dry",0]
["Weather_Pattern\\Period_2_Nov_and_Dec",1,"Wet",15]
["Weather_Pattern\\Period_2_Nov_and_Dec",2,"Moist",5]
["Weather_Pattern\\Period_2_Nov_and_Dec",3,"Dry",0]
["Weather_Pattern\\Period_3_Jan_and_Feb",1,"Wet",30]
["Weather_Pattern\\Period_3_Jan_and_Feb",2,"Moist",20]
["Weather_Pattern\\Period_3_Jan_and_Feb",3,"Dry",10]
["Weather_Pattern\\Period_4_Mar_and_Apr",1,"Wet",20]
["Weather_Pattern\\Period_4_Mar_and_Apr",2,"Moist",10]
["Weather_Pattern\\Period_4_Mar_and_Apr",3,"Dry",5]

{"sheet":"SB","index":11,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Sclerotinia Blight"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Practices\\Cultivar",1,"EC-191 RC|Granoleico",40,null,null,null,"Pest_History\\Sclerotoina_Blight",50,5,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":50},{"$f":"IF(ISBLANK(sel_Pest_History\\Sclerotoina_Blight),\"\",sel_Pest_History\\Sclerotoina_Blight)","v":"Present"}]
["Crop_Practices\\Cultivar",2,"ASEM 400|EC-214|EC-98|MA-02|MA-757|MA-88",35,null,null,null,"Crop_Practices\\Cultivar",40,35,35,{"$f":"IF(ISBLANK(sel_Crop_Practices\\Cultivar),\"\",sel_Crop_Practices\\Cultivar)","v":"MA-02"}]
["Crop_Practices\\Plant_Pattern",1,"> 10 plts/m (70 cm single row)",15,null,null,null,"Field\\Tillage_System",40,30,40,{"$f":"IF(ISBLANK(sel_Field\\Tillage_System),\"\",sel_Field\\Tillage_System)","v":"Reduced Tillage"}]
["Crop_Practices\\Plant_Pattern",2,"< 10 plts/m (70 cm single row)|>6 plts/m (90 cm twin row)",10,null,null,null,"Weather_Pattern\\Period_4_Mar_and_Apr",30,5,15,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_4_Mar_and_Apr),\"\",sel_Weather_Pattern\\Period_4_Mar_and_Apr)","v":"Moist"}]
["Crop_Practices\\Plant_Pattern",3,"<6 plts/m (90 cm twin row)",5,null,null,null,"Weather_Pattern\\Period_3_Jan_and_Feb",25,5,15,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_3_Jan_and_Feb),\"\",sel_Weather_Pattern\\Period_3_Jan_and_Feb)","v":"Moist"}]
["Field\\Tillage_System",1,"Reduced Tillage",40,null,null,null,"Field_Crop_History\\Crop_1_Season_Ago",24,16,24,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_1_Season_Ago),\"\",sel_Field_Crop_History\\Crop_1_Season_Ago)","v":"Soybean"}]
["Field\\Tillage_System",2,"No-Till",35,null,null,null,"Field_Crop_History\\Crop_2_Seasons_Ago",16,8,16,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_2_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_2_Seasons_Ago)","v":"Soybean"}]
["Field\\Tillage_System",3,"Cover Crop",30,null,null,null,"Crop_Practices\\Plant_Pattern",15,5,5,{"$f":"IF(ISBLANK(sel_Crop_Practices\\Plant_Pattern),\"\",sel_Crop_Practices\\Plant_Pattern)","v":"<6 plts/m (90 cm twin row)"}]
["Field_Crop_History\\Crop_1_Season_Ago",1,"Peanut|Soybean",24,null,null,null,"Leaf_Spot_Management\\Chlorothalonil_Applications",15,0,15,{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management\\Chlorothalonil_Applications),\"\",sel_Leaf_Spot_Management\\Chlorothalonil_Applications)","v":"3 Sprays"}]
["Field_Crop_History\\Crop_1_Season_Ago",2,"Corn",16,null,null,null,"Weather_Pattern\\Period_2_Nov_and_Dec",15,0,5,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_2_Nov_and_Dec),\"\",sel_Weather_Pattern\\Period_2_Nov_and_Dec)","v":"Moist"}]
["Field_Crop_History\\Crop_2_Seasons_Ago",1,"Peanut|Soybean",16,null,null,null,"Field_Crop_History\\Crop_3_Seasons_Ago",8,2,8,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_3_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_3_Seasons_Ago)","v":"Soybean"}]
["Field_Crop_History\\Crop_2_Seasons_Ago",2,"Corn",8]
["Field_Crop_History\\Crop_3_Seasons_Ago",1,"Peanut|Soybean",8,null,null,null,"Total",{"$f":"SUMIF(I3:I13,\">0\")","v":278},{"$f":"SUMIF(J3:J13,\">0\")","v":111},{"$f":"MAX(SB_MinRiskIndex,SUM(K3:K13))","v":228}]
["Field_Crop_History\\Crop_3_Seasons_Ago",2,"Corn",2]
["Leaf_Spot_Management\\Chlorothalonil_Applications",1,"3 Sprays",15,null,null,null,"High Risk Index",162]
["Leaf_Spot_Management\\Chlorothalonil_Applications",2,"1 Spray|2 Sprays",5,null,null,null,"Moderate Risk Index",132]
["Leaf_Spot_Management\\Chlorothalonil_Applications",3,"None",0]
["Pest_History\\Sclerotoina_Blight",1,"Present",50]
["Pest_History\\Sclerotoina_Blight",2,"No history",5]
["Weather_Pattern\\Period_2_Nov_and_Dec",1,"Wet",15]
["Weather_Pattern\\Period_2_Nov_and_Dec",2,"Moist",5]
["Weather_Pattern\\Period_2_Nov_and_Dec",3,"Dry",0]
["Weather_Pattern\\Period_3_Jan_and_Feb",1,"Wet",25]
["Weather_Pattern\\Period_3_Jan_and_Feb",2,"Moist",15]
["Weather_Pattern\\Period_3_Jan_and_Feb",3,"Dry",5]
["Weather_Pattern\\Period_4_Mar_and_Apr",1,"Wet",30]
["Weather_Pattern\\Period_4_Mar_and_Apr",2,"Moist",15]
["Weather_Pattern\\Period_4_Mar_and_Apr",3,"Dry",5]

{"sheet":"SMUT","index":12,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Smut"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Practices\\Cultivar",1,"Granoleico",75,null,null,null,"Crop_Practices\\Cultivar",75,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":50},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Cultivar),\"\",sel_Crop_Practices\\Cultivar)","v":"MA-02"}]
["Crop_Practices\\Cultivar",2,"ASEM 400|MA-02|MA-88",50,null,null,null,"Field_Crop_History\\Crop_1_Season_Ago",70,30,40,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_1_Season_Ago),\"\",sel_Field_Crop_History\\Crop_1_Season_Ago)","v":"Soybean"}]
["Crop_Practices\\Cultivar",3,"EC-214|EC-98|MA-757",35,null,null,null,"Field_Crop_History\\Crop_2_Seasons_Ago",60,30,40,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_2_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_2_Seasons_Ago)","v":"Soybean"}]
["Crop_Practices\\Cultivar",4,"EC-191 RC",0,null,null,null,"Field_Crop_History\\Crop_3_Seasons_Ago",50,30,40,{"$f":"IF(ISBLANK(sel_Field_Crop_History\\Crop_3_Seasons_Ago),\"\",sel_Field_Crop_History\\Crop_3_Seasons_Ago)","v":"Soybean"}]
["Field\\Soil_Smut_Inoculum",1,"1500 or greater spores/g soil",40,null,null,null,"Field\\Soil_Smut_Inoculum",40,5,40,{"$f":"IF(ISBLANK(sel_Field\\Soil_Smut_Inoculum),\"\",sel_Field\\Soil_Smut_Inoculum)","v":"1500 or greater spores/g soil"}]
["Field\\Soil_Smut_Inoculum",2,"1000 - 1499 spores/g soil",25,null,null,null,"Pest_History\\Smut",30,8,30,{"$f":"IF(ISBLANK(sel_Pest_History\\Smut),\"\",sel_Pest_History\\Smut)","v":"Problem with good fungicide program"}]
["Field\\Soil_Smut_Inoculum",3,"500 - 999 spores/g soil",15,null,null,null,"Weather_Pattern\\Period_4_Mar_and_Apr",30,5,15,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_4_Mar_and_Apr),\"\",sel_Weather_Pattern\\Period_4_Mar_and_Apr)","v":"Moist"}]
["Field\\Soil_Smut_Inoculum",4,"0 - 499 spores/g soil",5,null,null,null,"Weather_Pattern\\Period_3_Jan_and_Feb",25,5,15,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_3_Jan_and_Feb),\"\",sel_Weather_Pattern\\Period_3_Jan_and_Feb)","v":"Moist"}]
["Field_Crop_History\\Crop_1_Season_Ago",1,"Peanut",70,null,null,null,"Weather_Pattern\\Period_2_Nov_and_Dec",15,0,5,{"$f":"IF(ISBLANK(sel_Weather_Pattern\\Period_2_Nov_and_Dec),\"\",sel_Weather_Pattern\\Period_2_Nov_and_Dec)","v":"Moist"}]
["Field_Crop_History\\Crop_1_Season_Ago",2,"Soybean",40,null,null,null,"Treatments\\Iridium_Applictions",0,-50,0,{"$f":"IF(ISBLANK(sel_Treatments\\Iridium_Applictions),\"\",sel_Treatments\\Iridium_Applictions)","v":"None"}]
["Field_Crop_History\\Crop_1_Season_Ago",3,"Corn",30]
["Field_Crop_History\\Crop_2_Seasons_Ago",1,"Peanut",60,null,null,null,"Total",{"$f":"SUMIF(I3:I12,\">0\")","v":395},{"$f":"SUMIF(J3:J12,\">0\")","v":113},{"$f":"MAX(SMUT_MinRiskIndex,SUM(K3:K12))","v":275}]
["Field_Crop_History\\Crop_2_Seasons_Ago",2,"Soybean",40]
["Field_Crop_History\\Crop_2_Seasons_Ago",3,"Corn",30,null,null,null,"High Risk Index",212]
["Field_Crop_History\\Crop_3_Seasons_Ago",1,"Peanut",50,null,null,null,"Moderate Risk Index",154]
["Field_Crop_History\\Crop_3_Seasons_Ago",2,"Soybean",40]
["Field_Crop_History\\Crop_3_Seasons_Ago",3,"Corn",30]
["Pest_History\\Smut",1,"Problem with good fungicide program",30]
["Pest_History\\Smut",2,"Present but controlled with good fungicide program",15]
["Pest_History\\Smut",3,"No history",8]
["Treatments\\Iridium_Applictions",1,"None",0]
["Treatments\\Iridium_Applictions",2,"1 Spray",-25]
["Treatments\\Iridium_Applictions",3,"2 Sprays",-50]
["Weather_Pattern\\Period_2_Nov_and_Dec",1,"Wet",15]
["Weather_Pattern\\Period_2_Nov_and_Dec",2,"Moist",5]
["Weather_Pattern\\Period_2_Nov_and_Dec",3,"Dry",0]
["Weather_Pattern\\Period_3_Jan_and_Feb",1,"Wet",25]
["Weather_Pattern\\Period_3_Jan_and_Feb",2,"Moist",15]
["Weather_Pattern\\Period_3_Jan_and_Feb",3,"Dry",5]
["Weather_Pattern\\Period_4_Mar_and_Apr",1,"Wet",30]
["Weather_Pattern\\Period_4_Mar_and_Apr",2,"Moist",15]
["Weather_Pattern\\Period_4_Mar_and_Apr",3,"Dry",5]