{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Risk","Log_TPL","Log_Lists","Pests","Lists","Costs","Logos","Pest_Report","CBR","LS","SCL","TSWV","SM","SCR","NRN","PRN","SN","SSR","WDS","THRP"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":150,"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":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,13,2,16],[13,9,13,12],[13,17,13,20],[6,13,6,16],[6,17,6,20],[9,9,9,12],[9,13,9,16],[9,17,9,20],[20,6,22,20],[17,17,17,20],[32,4,34,4],[35,4,37,4],[1,5,1,6],[2,6,2,7],[2,9,2,12],[17,13,17,16],[6,6,6,7],[9,6,9,7],[13,6,13,7],[17,6,17,7],[17,9,17,12],[13,13,13,16],[2,17,2,20],[6,9,6,12]]}
[]
[]
[null,null,null,"Crop Cultivar","Bailey",null,"Arthropod",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Crop Plant Population","1 to 2 plants/row ft.",null,null,"Southern Corn Rootworm",{"$f":"SCR_RiskIndex","v":95},95,95,95,95,95,95,95,95,95,95,95,95]
[null,null,null,"Crop Planting Date","2020-05-05",null,null,"Spider Mites",{"$f":"SM_RiskIndex","v":70},70,70,70,70,70,70,70,70,70,70,70,70]
[null,null,null,"Crop Row Pattern","Single (32-38 inches)",null,null,"Thrips",{"$f":"THRP_RiskIndex","v":65},65,65,65,65,65,65,65,65,65,65,65,65]
[null,null,null,"Field Borders Early Season","Clean",null,"Disease (Foliar)",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Field Borders Late Season","Mowed",null,null,"Early/Late Leaf Spot",{"$f":"LS_RiskIndex","v":58},58,58,58,58,58,58,58,58,58,58,58,58]
[null,null,null,"Field Crop History 1 Year Ago","Cotton",null,null,"Tomato Spotted Wilt Virus",{"$f":"TSWV_RiskIndex","v":100},100,100,100,100,100,100,100,100,100,100,100,100]
[null,null,null,"Field Crop History 2 Years Ago","Sorghum",null,"Disease (Soil Borne)",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Field Crop History 3 Years Ago","Sorghum",null,null,"Cylindrocladium Black Rot",{"$f":"CBR_RiskIndex","v":65},65,65,65,65,65,65,65,65,65,65,65,65]
[null,null,null,"Field Crop History 4 Years Ago","Soybean",null,null,"Sclerotinia",{"$f":"SCL_RiskIndex","v":130},130,130,130,130,130,130,130,130,130,130,130,130]
[null,null,null,"Field Irrigation","Irrigated",null,null,"Southern Stem Rot",{"$f":"SSR_RiskIndex","v":50},50,50,50,50,50,50,50,50,50,50,50,50]
[null,null,null,"Field Previous Weed Control","Good",null,"Nematode",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Field Tillage","Conventional",null,null,"Northern Rootknot",{"$f":"NRN_RiskIndex","v":25},25,25,25,25,25,25,25,25,25,25,25,25]
[null,null,null,"Leaf Spot Chorothalonil Applications","3 or more",null,null,"Peanut Rootknot",{"$f":"PRN_RiskIndex","v":32},32,32,32,32,32,32,32,32,32,32,32,32]
[null,null,null,"Leaf Spot Management","Leafspot advisory throughout season",null,null,"Sting",{"$f":"SN_RiskIndex","v":45},45,45,45,45,45,45,45,45,45,45,45,45]
[null,null,null,"Pest History",null,null,"Plants",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Cylindrocladium Black Rot","No history",null,null,"Weeds",{"$f":"WDS_RiskIndex","v":145},145,145,145,145,145,145,145,145,145,145,145,145]
[null,null,null,"Early/Late Leaf Spot","Present but not a problem with a good fungicide program"]
[null,null,null,"Sclerotinia","No History",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,"Southern Corn Rootworm","No history"]
[null,null,null,"Southern Stem Rot","No history"]
[null,null,null,"Pest History Nematodes"]
[null,null,null,"Northern Rootknot","Very Low (NCDA index <  20)"]
[null,null,null,"Peanut Rootknot","Very Low (NCDA index <  20)"]
[null,null,null,"Sting","Very Low (NCDA index <  20)"]
[null,null,null,"Pest Hosts","Field Corn"]
[null,null,null,"Soil Drainage Class","Well"]
[null,null,null,"Soil pH",6]
[null,null,null,"Soil Texture","Loam"]
[null,null,null,"Treatments Fumigants","None"]
[null,null,null,"Treatments Post Emergence","None"]
[]
[]
[null,null,null,"Treatments Pre Emergence","None"]
[]
[]
[null,null,null,"Weed Management Practices","PRE + EPOST + MPOST + LPOST + Hand Weed"]
[null,null,null,"Weed Species","C. Ragweed and Palmer A. (ALS and PPO Resistant)"]

{"sheet":"Log_TPL","index":1,"n_rows":238,"n_cols":16,"rows_kept":238,"cut":false,"hidden":false,"merged":[[24,5,24,14],[0,0,0,14],[92,5,92,9],[92,10,92,17],[134,4,135,12]]}
["Field and Production Information"]
[]
[null,null,null,"Field Acreage (acres)"]
[]
[null,null,null,"Soil ","Mapped Series","% of Field"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tillage Practice","Date","Equipment"]
[]
[]
[]
[]
[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","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate"]
[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","Trade Name","Rate","Trade Name","Rate","Trade Name","Rate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Pest Treaments","Date","Trade Name","Rate","Trade Name","Rate"]
[null,null,null,"Sclerotina Blight"]
[]
[null,null,null,"CBR"]
[]
[null,null,null,"In-furrow Insecticide"]
[]
[null,null,null,"Foliar Insecticides"]
[]
[null,null,null,"Southern Corn Rootworm"]
[]
[null,null,null,"Spider Mites"]
[]
[]
[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($F94:$J94)=0,NA(),F94/(SUM($F94:$J94)))","v":{"$error":"#N/A"}},{"$f":"IF(SUM($F94:$J94)=0,NA(),G94/(SUM($F94:$J94)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"N94+O94","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(SUM($F95:$J95)=0,NA(),G95/(SUM($F95:$J95)))","v":{"$error":"#N/A"}},{"$f":"IF(SUM($F95:$J95)=0,NA(),H95/(SUM($F95:$J95)))","v":{"$error":"#N/A"}},{"$f":"IF(SUM($F95:$J95)=0,NA(),I95/(SUM($F95:$J95)))","v":{"$error":"#N/A"}},{"$f":"IF(SUM($F95:$J95)=0,NA(),J95/(SUM($F95:$J95)))","v":{"$error":"#N/A"}},{"$f":"N95+O95","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 ($)"]
[]
[null,null,null,"Grading Results","Grams (gr)","Percentage (%)"]
[null,null,null,"Foreign Material Sample"]
[null,null,null,"Foreign Material",null,{"$f":"IFERROR(E111/E110,0)","v":0}]
[null,null,null,"LSK",null,{"$f":"IFERROR(E112/E110,0)","v":0}]
[null,null,null,"Moisture"]
[]
[null,null,null,"Cleaned Sample"]
[null,null,null,"Fancy",null,{"$f":"IFERROR(E116/E115,0)","v":0}]
[null,null,null,"Kernels Riding ELK Screen"]
[null,null,null,"Total ELK Damage"]
[null,null,null,"Net ELK",{"$f":"E117-E118","v":0},{"$f":"IFERROR(E119/E115,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":"E122-E123","v":0},{"$f":"IFERROR(E124/E115,0)","v":0}]
[null,null,null,"Sound Splits",null,{"$f":"IFERROR(E125/E115,0)","v":0}]
[null,null,null,"Total SMK",null,{"$f":"F124+F125","v":0}]
[null,null,null,"Other Kernels",null,{"$f":"IFERROR(E127/E115,0)","v":0}]
[null,null,null,"Damage Splits"]
[null,null,null,"Total Damage",null,{"$f":"IFERROR(E129/E115,0)","v":0}]
[null,null,null,"Total Kernels",null,{"$f":"F126+F127+F128+F129","v":0}]
[null,null,null,"Hulls",null,{"$f":"IFERROR(E131/E115,0)","v":0}]
[null,null,null,"Total Kernels & Halls",null,{"$f":"F130+F131","v":0}]
[null,null,null,"Freeze Damage",null,{"$f":"IFERROR(E133/E115,0)","v":0}]
[null,null,null,"Concealed RMD",null,{"$f":"IFERROR(E134/E115,0)","v":0}]
[null,null,null,"Remarks"]
[]
[]
[null,null,null,"Rainfall/Irrigation","Date","Amount(in)","Month",null,null,"Amount(in)"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E139),\"\",TEXT(E139,\"mmm\"))","v":""},null,"Jan",{"$f":"SUMIF(G$139:G$238,\"=\" & I139,F$139:F$238)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E140),\"\",TEXT(E140,\"mmm\"))","v":""},null,"Feb",{"$f":"SUMIF(G$139:G$238,\"=\" & I140,F$139:F$238)","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(E204),\"\",TEXT(E204,\"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":"Log_Lists","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Tillage_Prac","Land_Plaster_Meth","Land_Plaster_Type","Digging_Eq","Combine","Moisture_Status"]
["Disk","Banded","Bagged","2 Row Digger","2 Row Pull Type Combine","Dry"]
["Chisel","Broadcast","Bulk","4 Row Digger","4 Row Pull Type Combine","Adequate"]
["Moldboard plow","Other","Granular","6 Row Digger","6 Row Pull Type Combine","Wet"]
["Cultivate",null,"Other","Other","6 Row Self-Propelled Combine"]
["Bed",null,null,null,"8 Row Self-Propelled Combine"]
["Rip",null,null,null,"Other"]
["Rip and Bed"]
["Strip Till"]
["No Till"]
["Other"]

{"sheet":"Pests","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["PestType","Pest","PestID"]
["Arthropod","Southern Corn Rootworm","SCR"]
["Arthropod","Spider Mites","SM"]
["Arthropod","Thrips","THRP"]
["Disease (Foliar)","Early/Late Leaf Spot","LS"]
["Disease (Foliar)","Tomato Spotted Wilt Virus","TSWV"]
["Disease (Soil Borne)","Cylindrocladium Black Rot","CBR"]
["Disease (Soil Borne)","Sclerotinia","SCL"]
["Disease (Soil Borne)","Southern Stem Rot","SSR"]
["Nematode","Northern Rootknot","NRN"]
["Nematode","Peanut Rootknot","PRN"]
["Nematode","Sting","SN"]
["Plants","Weeds","WDS"]

{"sheet":"Lists","index":4,"n_rows":39,"n_cols":38,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Category","Category_Pest","CategoryID","Category_List","Category_List_Type","Months","Crop","Soil_Texture","Pest_History_CBR","Pest_History_LS","Pest_History_SCL","Pest_History_SCR","Pest_History_SSR","Pest_History_Nematode","Soil_pH_CBR","Soil_pH_SCL","Leaf_Spot_Management","Leaf_Spot_Chorothalonil_Applications","Soil_Drainage_Class","Field_Borders_Early_Season","Field_Borders_Late_Season","Field_Irrigation","Field_Tillage","Treatments_Post_Emergence","Treatments_Pre_Emergence","Crop_Plant_Population","Crop_Row_Pattern","Crop_Cultivar","Crop_Planting_Date_CBR","Crop_Planting_Date_LS","Crop_Planting_Date_SCL","Crop_Planting_Date_SCR","Crop_Planting_Date_TSWV","Weed_Species","Field_Previous_Weed_Control","Weed_Management_Practices","Crop_Planting_Date_THRP","Treatments_Fumigants"]
["Crop_Cultivar",null,"Crop_Cultivar","Crop_Cultivar","Single","January","Clary Sage","Loam","High (incidence > 10%)","A problem even with good fungicide program","No History","High","A problem even with good fungicide program","High (NCDA index ≥ 60)","5.7 or lower","5.7 or lower","Calendar spray schedule","3 or more","Moderately Well","Clean","Mowed","Irrigated","Conventional","Acephate","Acephate","1 to 2 plants/row ft.","Single (32-38 inches)","Bailey","Jan 01 to May 05","Jan 01 to May 20","Jan 01 to May 20","Jan 01 to May 01","Jan 01 to May 05","Annual Grass","Fair","EPOST","Jan 01 to May 05","Metam Sodium"]
["Crop_Plant_Population",null,"Crop_Plant_Population","Crop_Plant_Population","Single","February","Cotton","Loamy Sand","Low (incidence < 5%)","No history","Present and requires 0 sprays per year","Low","No history","Low (20 ≤ NCDA index < 40)","5.8 or higher","5.8 to 6.5","Calendar spray schedule with skipping when dry","Less than 3","Poorly","Weeds/Brush","Not Mowed","Non-irrigated","Strip into Residue","Comite","Admire Pro","3 to 4 plants/row ft.","Twin (7 to 10 inches)","Champs","May 06 to May 20","May 21 to Dec 31","May 21 to Dec 31","May 02 to May 15","May 06 to May 15","Annual Grass (ACC and ALS Resistant)","Good","LPOST","May 06 to May 15","None"]
["Crop_Planting_Date","CBR","Crop_Planting_Date","Crop_Planting_Date_CBR","Date","March","Fallow","Sandy Loam","Moderate (incidence 5-10%)","Present but not a problem with a good fungicide program","Present and requires 1 spray per year","Moderate","Present but not a problem with a good fungicide program","Moderate (40 ≤ NCDA index < 60)",null,"6.6 or higher","Leafspot advisory throughout season",null,"Somewhat Poorly",null,null,"Periodic Irrigation",null,"Danitol","AgLogic","5 or more plants/row ft.",null,"Emery","May 21 or Dec 31",null,null,"May 16 to Dec 31","May 16 to Dec 31","Annual Grass (ACC Resistant)","Poor","MPOST","May 16 to Dec 31","Telone II"]
["Crop_Planting_Date","LS","Crop_Planting_Date","Crop_Planting_Date_LS","Date","April","Field Corn",null,"No history",null,"Present and requires 2 or more sprays per year","No history",null,"Very Low (NCDA index <  20)",null,null,null,null,"Well",null,null,null,null,"Lannate","Imidacloprid(Generic)",null,null,"Sullivan",null,null,null,null,null,"Annual Grass (ALS Resistant)",null,"None"]
["Crop_Planting_Date","SCL","Crop_Planting_Date","Crop_Planting_Date_SCL","Date","May","Forage Grasses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lorsban (Pilot 15 G)","None",null,null,"Wynne",null,null,null,null,null,"C. Lambsquarter",null,"PPI"]
["Crop_Planting_Date","SCR","Crop_Planting_Date","Crop_Planting_Date_SCR","Date","June","Melons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","Phorate 20G",null,null,null,null,null,null,null,null,"C. Ragweed",null,"PPI + PRE"]
["Crop_Planting_Date","THRP","Crop_Planting_Date","Crop_Planting_Date_THRP","Date","July","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-pyrethroids","Proline",null,null,null,null,null,null,null,null,"C. Ragweed (ALS and PPO Resistance)",null,"PPL"]
["Crop_Planting_Date","TSWV","Crop_Planting_Date","Crop_Planting_Date_TSWV","Date","August","Peanut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pyrethoids","Propulse",null,null,null,null,null,null,null,null,"C. Ragweed (ALS Resistance)",null,"PRE"]
["Crop_Row_Pattern",null,"Crop_Row_Pattern","Crop_Row_Pattern","Single","September","Small Grains",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thimet 20G",null,null,null,null,null,null,null,null,"C. Ragweed (PPO Resistance)",null,"PRE + EPOST"]
["Field_Borders_Early_Season",null,"Field_Borders_Early_Season","Field_Borders_Early_Season","Single","October","Sorghum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velum Total",null,null,null,null,null,null,null,null,"C. Ragweed and Palmer A. (ALS and PPO Resistant)",null,"PRE + EPOST + Hand Weed"]
["Field_Borders_Late_Season",null,"Field_Borders_Late_Season","Field_Borders_Late_Season","Single","November","Soybean",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C. Ragweed and Palmer A. (ALS Resistant)",null,"PRE + EPOST + MPOST"]
["Field_Crop_History_1_Year_Ago",null,"Field_Crop_History_1_Year_Ago","Crop","Single","December","Sweet Corn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C. Ragweed and Palmer A. (PPO Resistant)",null,"PRE + EPOST + MPOST + Hand Weed"]
["Field_Crop_History_2_Years_Ago",null,"Field_Crop_History_2_Years_Ago","Crop","Single",null,"Sweetpotato",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C. Ragweed and Palmer Amaranth",null,"PRE + EPOST + MPOST + LPOST"]
["Field_Crop_History_3_Years_Ago",null,"Field_Crop_History_3_Years_Ago","Crop","Single",null,"Tobacco",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eclipta",null,"PRE + EPOST + MPOST + LPOST + Hand Weed"]
["Field_Crop_History_4_Years_Ago",null,"Field_Crop_History_4_Years_Ago","Crop","Single",null,"Vegetables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Others"]
["Field_Irrigation",null,"Field_Irrigation","Field_Irrigation","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palmer Amaranth"]
["Field_Previous_Weed_Control",null,"Field_Previous_Weed_Control","Field_Previous_Weed_Control","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palmer Amaranth (ALS and PPO Resistant)"]
["Field_Tillage",null,"Field_Tillage","Field_Tillage","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palmer Amaranth (ALS Resistant)"]
["Leaf_Spot_Chorothalonil_Applications",null,"Leaf_Spot_Chorothalonil_Applications","Leaf_Spot_Chorothalonil_Applications","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Palmer Amaranth (PPO Resistant)"]
["Leaf_Spot_Management",null,"Leaf_Spot_Management","Leaf_Spot_Management","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sedges"]
["Pest_History","CBR","Pest_History_CBR","Pest_History_CBR","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sedges (ALS Resistant)"]
["Pest_History","LS","Pest_History_LS","Pest_History_LS","Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicklepod"]
["Pest_History","SCL","Pest_History_SCL","Pest_History_SCL","Single"]
["Pest_History","SCR","Pest_History_SCR","Pest_History_SCR","Single"]
["Pest_History","SSR","Pest_History_SSR","Pest_History_SSR","Single"]
["Pest_History_Nematodes","NRN","Pest_History_Nematodes_NRN","Pest_History_Nematode","Single"]
["Pest_History_Nematodes","PRN","Pest_History_Nematodes_PRN","Pest_History_Nematode","Single"]
["Pest_History_Nematodes","SN","Pest_History_Nematodes_SN","Pest_History_Nematode","Single"]
["Pest_Hosts",null,"Pest_Hosts","Crop","Single"]
["Soil_Drainage_Class",null,"Soil_Drainage_Class","Soil_Drainage_Class","Single"]
["Soil_pH","CBR","Soil_pH","Soil_pH_CBR","pH"]
["Soil_pH","SCL","Soil_pH","Soil_pH_SCL","pH"]
["Soil_Texture",null,"Soil_Texture","Soil_Texture","Single"]
["Treatments_Fumigants",null,"Treatments_Fumigants","Treatments_Fumigants","Single"]
["Treatments_Post_Emergence",null,"Treatments_Post_Emergence","Treatments_Post_Emergence","Multi"]
["Treatments_Pre_Emergence",null,"Treatments_Pre_Emergence","Treatments_Pre_Emergence","Multi"]
["Weed_Management_Practices",null,"Weed_Management_Practices","Weed_Management_Practices","Single"]
["Weed_Species",null,"Weed_Species","Weed_Species","Single"]

{"sheet":"Costs","index":5,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Category","Item","Cost","Multiplier",null,"Category","Max","Min","Cost","Selection"]
["Base_Cost",null,565,null,null,"Base_Cost",{"$f":"Cost_Base","v":565},{"$f":"Cost_Base","v":565},{"$f":"Cost_Base","v":565}]
["Crop_Cultivar","Bailey",45,null,null,"Crop_Cultivar | Crop_Plant_Population | Crop_Row_Pattern",{"$f":"calcCostMax(F3,J3)","v":172.5},{"$f":"calcCostMin(F3,J3)","v":45},{"$f":"calcCost(F3,J3)","v":45},{"$f":"CONCATENATE(IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar),\" | \",IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population),\" | \",IF(ISBLANK(sel_Crop_Row_Pattern),\"\",sel_Crop_Row_Pattern))","v":"Bailey | 1 to 2 plants/row ft. | Single (32-38 inches)"}]
["Crop_Cultivar","Champs",50,null,null,"Field_Irrigation",{"$f":"calcCostMax(F4,J4)","v":100},{"$f":"calcCostMin(F4,J4)","v":0},{"$f":"calcCost(F4,J4)","v":100},{"$f":"CONCATENATE(IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation))","v":"Irrigated"}]
["Crop_Cultivar","Emery",60,null,null,"Leaf_Spot_Management",83,51,51,{"$f":"CONCATENATE(IF(ISBLANK(sel_Leaf_Spot_Management),\"\",sel_Leaf_Spot_Management))","v":"Leafspot advisory throughout season"}]
["Crop_Cultivar","Sullivan",47,null,null,"Treatments_Fumigants",45,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Treatments_Fumigants),\"\",sel_Treatments_Fumigants))","v":"None"}]
["Crop_Cultivar","Wynne",60,null,null,"Treatments_Post_Emergence",137,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Treatments_Post_Emergence),\"\",sel_Treatments_Post_Emergence))","v":"None"}]
["Crop_Plant_Population","1 to 2 plants/row ft.",null,1,null,"Treatments_Pre_Emergence",162,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence))","v":"None"}]
["Crop_Plant_Population","3 to 4 plants/row ft.",null,1.75,null,"Weed_Management_Practices",90,0,75,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management_Practices),\"\",sel_Weed_Management_Practices))","v":"PRE + EPOST + MPOST + LPOST + Hand Weed"}]
["Crop_Plant_Population","5 or more plants/row ft.",null,2.5]
["Crop_Row_Pattern","Single (32-38 inches)",null,1,null,"Total",{"$f":"SUM($G$2:G9)","v":1354.5},{"$f":"SUM($H$2:H9)","v":661},{"$f":"SUM($I$2:I9)","v":836}]
["Crop_Row_Pattern","Twin (7 to 10 inches)",null,1.1499999999999999,null,"High Cost",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":1123.3356450000001}]
["Field_Irrigation","Irrigated",100,null,null,"Moderate Cost",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":892.164355}]
["Field_Irrigation","Non-irrigated",0]
["Field_Irrigation","Periodic Irrigation",50,null,null,"Base",{"$f":"Cost_Base","v":565}]
["Leaf_Spot_Management","Calendar spray schedule",83,null,null,"Low Range",{"$f":"Cost_Moderate-Cost_Base","v":327.164355}]
["Leaf_Spot_Management","Calendar spray schedule with skipping when dry",67,null,null,"Moderate Range",{"$f":"Cost_High-Cost_Moderate","v":231.17129000000011}]
["Leaf_Spot_Management","Leafspot advisory throughout season",51,null,null,"High Range",{"$f":"Cost_Max-Cost_High","v":231.16435499999989}]
["Treatments_Fumigants","Metam Sodium",30]
["Treatments_Fumigants","None",0,null,null,{"$f":"CONCATENATE(\"Estimated Cost: $\",Cost,\" per Acre\")","v":"Estimated Cost: $836 per Acre"}]
["Treatments_Fumigants","Telone II",45]
["Treatments_Post_Emergence","Acephate",8]
["Treatments_Post_Emergence","Comite",26]
["Treatments_Post_Emergence","Danitol",26]
["Treatments_Post_Emergence","Lannate",23]
["Treatments_Post_Emergence","Lorsban (Pilot 15 G)",35]
["Treatments_Post_Emergence","None",0]
["Treatments_Post_Emergence","Non-pyrethroids",15]
["Treatments_Post_Emergence","Pyrethoids",4]
["Treatments_Pre_Emergence","Acephate",15]
["Treatments_Pre_Emergence","Admire Pro",19]
["Treatments_Pre_Emergence","AgLogic",20]
["Treatments_Pre_Emergence","Imidacloprid(Generic)",12]
["Treatments_Pre_Emergence","None",0]
["Treatments_Pre_Emergence","Phorate 20G",12]
["Treatments_Pre_Emergence","Proline",22]
["Treatments_Pre_Emergence","Propulse",20]
["Treatments_Pre_Emergence","Thimet 20G",16]
["Treatments_Pre_Emergence","Velum Total",26]
["Weed_Management_Practices","EPOST",15]
["Weed_Management_Practices","LPOST",15]
["Weed_Management_Practices","MPOST",15]
["Weed_Management_Practices","None",0]
["Weed_Management_Practices","PPI",10]
["Weed_Management_Practices","PPI + PRE",25]
["Weed_Management_Practices","PPL",10]
["Weed_Management_Practices","PRE",15]
["Weed_Management_Practices","PRE + EPOST",30]
["Weed_Management_Practices","PRE + EPOST + Hand Weed",90]
["Weed_Management_Practices","PRE + EPOST + MPOST",45]
["Weed_Management_Practices","PRE + EPOST + MPOST + Hand Weed",75]
["Weed_Management_Practices","PRE + EPOST + MPOST + LPOST",60]
["Weed_Management_Practices","PRE + EPOST + MPOST + LPOST + Hand Weed",75]

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

{"sheet":"Pest_Report","index":7,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,30,1],[30,2,30,3],[31,3,33,3],[27,3,29,3],[35,0,35,3],[21,0,21,1],[21,2,21,3],[22,3,25,3],[26,0,26,1],[26,2,26,3],[13,3,15,3],[16,0,16,1],[16,2,16,3],[17,3,20,3],[0,0,0,3],[5,0,5,1],[5,2,5,3],[6,3,7,3],[8,0,8,1],[8,2,8,3],[9,3,11,3],[12,0,12,1],[12,2,12,3]]}
["Southern Corn Rootworm Risk Summary"]
[]
[]
[]
[]
["Crop Cultivar",null,"Risk Points"]
[null,"Bailey*, Emery, Sullivan, Wynne",20,20]
[null,"Champs",10]
["Crop Planting Date",null,"Risk Points"]
[null,"May 16 to Dec 31",15,10]
[null,"May 02 to May 15*",10]
[null,"Jan 01 to May 01",5]
["Field Irrigation",null,"Risk Points"]
[null,"Irrigated*",45,45]
[null,"Periodic Irrigation",20]
[null,"Non-irrigated",0]
["Pest History",null,"Risk Points"]
[null,"High",15,0]
[null,"Moderate",10]
[null,"Low",5]
[null,"No history*",0]
["Soil Drainage Class",null,"Risk Points"]
[null,"Poorly",20,5]
[null,"Somewhat Poorly",15]
[null,"Moderately Well",10]
[null,"Well*",5]
["Soil Texture",null,"Risk Points"]
[null,"Loam*",15,15]
[null,"Sandy Loam",10]
[null,"Loamy Sand",5]
["Treatments Post Emergence",null,"Risk Points"]
[null,"Comite, Danitol, None*",0,0]
[null,"Acephate, Lannate, Non-pyrethroids, Pyrethoids",-10]
[null,"Lorsban (Pilot 15 G)",-30]
[]
["* Selected options used in calculating pest risk.\r\nNote: Reduction in pest risk value by a pesticide application will be less under low risk conditions."]

{"sheet":"CBR","index":8,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,14,0,15],[0,0,0,3]]}
["Cylindrocladium Black Rot"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Champs",30,null,null,null,"Crop_Cultivar",30,20,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Cultivar",2,"Bailey, Emery, Sullivan, Wynne",20,null,null,null,"Pest_History",25,5,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Pest_History_CBR),\"\",sel_Pest_History_CBR)","v":"No history"}]
["Crop_Planting_Date",1,"Jan 01 to May 05",15,null,null,null,"Field_Crop_History_1_Year_Ago",24,2,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Crop_Planting_Date",2,"May 21 to Dec 31",10,null,null,null,"Field_Crop_History_2_Years_Ago",16,2,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Crop_Planting_Date",3,"May 06 to May 20",5,null,null,null,"Crop_Planting_Date",15,5,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Date\")","v":15},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Field_Crop_History_1_Year_Ago",1,"Peanut, Soybean, Tobacco",24,null,null,null,"Field_Irrigation",10,0,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Field_Crop_History_1_Year_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Sweet Corn, Sweetpotato, Vegetables",2,null,null,null,"Soil_Drainage_Class",10,0,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Soil_Drainage_Class),\"\",sel_Soil_Drainage_Class)","v":"Well"}]
["Field_Crop_History_2_Years_Ago",1,"Peanut, Soybean, Tobacco",16,null,null,null,"Soil_pH",10,5,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"pH\")","v":5},{"$f":"IF(ISBLANK(sel_Soil_pH),\"\",sel_Soil_pH)","v":6}]
["Field_Crop_History_2_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Sweet Corn, Sweetpotato, Vegetables",2,null,null,null,"Field_Crop_History_3_Years_Ago",8,2,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_3_Years_Ago),\"\",sel_Field_Crop_History_3_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_3_Years_Ago",1,"Peanut, Soybean, Tobacco",8,null,null,null,"Field_Tillage",5,0,{"$f":"getRiskValue(\"A:A\",H12,J12,L12,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Field_Crop_History_3_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Sweet Corn, Sweetpotato, Vegetables",2,null,null,null,"Field_Crop_History_4_Years_Ago",4,2,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Single\")","v":4},{"$f":"IF(ISBLANK(sel_Field_Crop_History_4_Years_Ago),\"\",sel_Field_Crop_History_4_Years_Ago)","v":"Soybean"}]
["Field_Crop_History_4_Years_Ago",1,"Peanut, Soybean, Tobacco",4,null,null,null,"Treatments_Fumigants",0,-50,{"$f":"getRiskValue(\"A:A\",H14,J14,L14,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Fumigants),\"\",sel_Treatments_Fumigants)","v":"None"}]
["Field_Crop_History_4_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Sweet Corn, Sweetpotato, Vegetables",2,null,null,null,"Treatments_Pre_Emergence",0,-10,{"$f":"getRiskValue(\"A:A\",H15,J15,L15,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Field_Irrigation",1,"Irrigated",10]
["Field_Irrigation",2,"Periodic Irrigation",5,null,null,null,"Total",{"$f":"SUMIF(I3:I15,\">0\")","v":157},{"$f":"SUMIF(J3:J15,\">0\")","v":43},{"$f":"MAX(CBR_MinRiskIndex,SUM(K3:K15))","v":65}]
["Field_Irrigation",3,"Non-irrigated",0]
["Field_Tillage",1,"Strip into Residue",5,null,null,null,"High Risk Index",110]
["Field_Tillage",2,"Conventional",0,null,null,null,"Moderate Risk Index",80]
["Pest_History",1,"High (incidence > 10%)",25]
["Pest_History",2,"Moderate (incidence 5-10%)",15]
["Pest_History",3,"Low (incidence < 5%)",10]
["Pest_History",4,"No history",5]
["Soil_Drainage_Class",1,"Poorly, Somewhat Poorly",10]
["Soil_Drainage_Class",2,"Moderately Well",5]
["Soil_Drainage_Class",3,"Well",0]
["Soil_pH",1,"5.7 or lower",10]
["Soil_pH",2,"5.8 or higher",5]
["Treatments_Fumigants",1,"None, Telone II",0]
["Treatments_Fumigants",2,"Metam Sodium",-50]
["Treatments_Pre_Emergence",1,"Acephate, Admire Pro, AgLogic, Imidacloprid(Generic), None, Phorate 20G, Thimet 20G",0]
["Treatments_Pre_Emergence",2,"Velum Total",-5]
["Treatments_Pre_Emergence",3,"Proline, Propulse",-10]

{"sheet":"LS","index":9,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,13,0,14],[0,0,0,3]]}
["Early/Late Leaf Spot"]
["Category","Risk Level","Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Champs",30,null,null,null,"Crop_Cultivar",30,10,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Cultivar",2,"Bailey, Emery, Sullivan, Wynne",10,null,null,null,"Field_Crop_History_1_Year_Ago",30,3,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":3},{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Crop_Planting_Date",1,"May 21 to Dec 31",10,null,null,null,"Pest_History",20,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Pest_History_LS),\"\",sel_Pest_History_LS)","v":"Present but not a problem with a good fungicide program"}]
["Crop_Planting_Date",2,"Jan 01 to May 20",5,null,null,null,"Field_Crop_History_2_Years_Ago",15,2,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_1_Year_Ago",1,"Peanut",30,null,null,null,"Field_Irrigation",15,5,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":15},{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Field_Crop_History_1_Year_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Soybean, Sweet Corn, Sweetpotato, Tobacco, Vegetables",3,null,null,null,"Crop_Planting_Date",10,5,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Date\")","v":5},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Field_Crop_History_2_Years_Ago",1,"Peanut",15,null,null,null,"Field_Tillage",10,5,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Field_Crop_History_2_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Soybean, Sweet Corn, Sweetpotato, Tobacco, Vegetables",2,null,null,null,"Field_Crop_History_3_Years_Ago",5,2,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_3_Years_Ago),\"\",sel_Field_Crop_History_3_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_3_Years_Ago",1,"Peanut",5,null,null,null,"Field_Crop_History_4_Years_Ago",3,1,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":1},{"$f":"IF(ISBLANK(sel_Field_Crop_History_4_Years_Ago),\"\",sel_Field_Crop_History_4_Years_Ago)","v":"Soybean"}]
["Field_Crop_History_3_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Soybean, Sweet Corn, Sweetpotato, Tobacco, Vegetables",2]
["Field_Crop_History_4_Years_Ago",1,"Peanut",3,null,null,null,"Total",{"$f":"SUMIF(I3:I11,\">0\")","v":138},{"$f":"SUMIF(J3:J11,\">0\")","v":38},{"$f":"MAX(LS_MinRiskIndex,SUM(K3:K11))","v":58}]
["Field_Crop_History_4_Years_Ago",2,"Clary Sage, Cotton, Fallow, Field Corn, Forage Grasses, Melons, Other, Small Grains, Sorghum, Soybean, Sweet Corn, Sweetpotato, Tobacco, Vegetables",1]
["Field_Irrigation",1,"Irrigated",15,null,null,null,"High Risk Index",80]
["Field_Irrigation",2,"Periodic Irrigation",10,null,null,null,"Moderate Risk Index",55]
["Field_Irrigation",3,"Non-irrigated",5]
["Field_Tillage",1,"Conventional",10]
["Field_Tillage",2,"Strip into Residue",5]
["Pest_History",1,"A problem even with good fungicide program",20]
["Pest_History",2,"Present but not a problem with a good fungicide program",10]
["Pest_History",3,"No history",5]

{"sheet":"SCL","index":10,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,13,0,14],[0,0,0,3]]}
["Sclerotinia"]
["Category","Risk Level","Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Champs",85,null,null,null,"Pest_History",145,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Pest_History_SCL),\"\",sel_Pest_History_SCL)","v":"No History"}]
["Crop_Cultivar",2,"Wynne",70,null,null,null,"Crop_Cultivar",85,55,55,{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Cultivar",3,"Bailey, Sullivan",55,null,null,null,"Field_Crop_History_1_Year_Ago",24,16,16,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Crop_Plant_Population",1,"5 or more plants/row ft.",10,null,null,null,"Leaf_Spot_Chorothalonil_Applications",20,0,20,{"$f":"IF(ISBLANK(sel_Leaf_Spot_Chorothalonil_Applications),\"\",sel_Leaf_Spot_Chorothalonil_Applications)","v":"3 or more"}]
["Crop_Plant_Population",2,"3 to 4 plants/row ft.",5,null,null,null,"Field_Crop_History_2_Years_Ago",16,8,8,{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Crop_Plant_Population",3,"1 to 2 plants/row ft.",0,null,null,null,"Crop_Plant_Population",10,0,0,{"$f":"IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population)","v":"1 to 2 plants/row ft."}]
["Crop_Planting_Date",1,"May 21 to Dec 31",10,null,null,null,"Crop_Planting_Date",10,5,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Date\")","v":5},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Crop_Planting_Date",2,"Jan 01 to May 20",5,null,null,null,"Field_Irrigation",10,5,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Crop_Row_Pattern",1,"Twin (7 to 10 inches)",5,null,null,null,"Leaf_Spot_Management",10,5,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management),\"\",sel_Leaf_Spot_Management)","v":"Leafspot advisory throughout season"}]
["Crop_Row_Pattern",2,"Single (32-38 inches)",0,null,null,null,"Soil_pH",10,0,{"$f":"getRiskValue(\"A:A\",H12,J12,L12,\"pH\")","v":5},{"$f":"IF(ISBLANK(sel_Soil_pH),\"\",sel_Soil_pH)","v":6}]
["Field_Crop_History_1_Year_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Vegetables",24,null,null,null,"Field_Crop_History_3_Years_Ago",8,2,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Single\")","v":2},{"$f":"IF(ISBLANK(sel_Field_Crop_History_3_Years_Ago),\"\",sel_Field_Crop_History_3_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_1_Year_Ago",2,"Tobacco",20,null,null,null,"Crop_Row_Pattern",5,0,{"$f":"getRiskValue(\"A:A\",H14,J14,L14,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Crop_Row_Pattern),\"\",sel_Crop_Row_Pattern)","v":"Single (32-38 inches)"}]
["Field_Crop_History_1_Year_Ago",3,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",16,null,null,null,"Field_Crop_History_4_Years_Ago",4,2,{"$f":"getRiskValue(\"A:A\",H15,J15,L15,\"Single\")","v":4},{"$f":"IF(ISBLANK(sel_Field_Crop_History_4_Years_Ago),\"\",sel_Field_Crop_History_4_Years_Ago)","v":"Soybean"}]
["Field_Crop_History_2_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Vegetables",16]
["Field_Crop_History_2_Years_Ago",2,"Tobacco",12,null,null,null,"Total",{"$f":"SUMIF(I3:I15,\">0\")","v":357},{"$f":"SUMIF(J3:J15,\">0\")","v":98},{"$f":"MAX(SCL_MinRiskIndex,SUM(K3:K15))","v":130}]
["Field_Crop_History_2_Years_Ago",3,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",8]
["Field_Crop_History_3_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Vegetables",8,null,null,null,"High Risk Index",245]
["Field_Crop_History_3_Years_Ago",2,"Tobacco",4,null,null,null,"Moderate Risk Index",215]
["Field_Crop_History_3_Years_Ago",3,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",2]
["Field_Crop_History_4_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Vegetables",4]
["Field_Crop_History_4_Years_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn, Tobacco",2]
["Field_Irrigation",1,"Irrigated",10]
["Field_Irrigation",2,"Periodic Irrigation",8]
["Field_Irrigation",3,"Non-irrigated",5]
["Leaf_Spot_Chorothalonil_Applications",1,"3 or more",20]
["Leaf_Spot_Chorothalonil_Applications",2,"Less than 3",0]
["Leaf_Spot_Management",1,"Calendar spray schedule, Calendar spray schedule with skipping when dry",10]
["Leaf_Spot_Management",2,"Leafspot advisory throughout season",5]
["Pest_History",1,"Present and requires 2 or more sprays per year",145]
["Pest_History",2,"Present and requires 1 spray per year",120]
["Pest_History",3,"Present and requires 0 sprays per year",95]
["Pest_History",4,"No History",0]
["Soil_pH",1,"6.6 or higher",10]
["Soil_pH",2,"5.8 to 6.5",5]
["Soil_pH",3,"5.7 or lower",0]

{"sheet":"TSWV","index":11,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,14,0,15],[0,0,0,3]]}
["Tomato Spotted Wilt Virus"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Champs",30,null,null,null,"Crop_Cultivar",30,20,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Cultivar",2,"Bailey, Emery, Sullivan, Wynne",20,null,null,null,"Crop_Plant_Population",25,5,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":25},{"$f":"IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population)","v":"1 to 2 plants/row ft."}]
["Crop_Plant_Population",1,"1 to 2 plants/row ft.",25,null,null,null,"Treatments_Pre_Emergence",25,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Multi\")","v":25},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Crop_Plant_Population",2,"3 to 4 plants/row ft.",15,null,null,null,"Crop_Planting_Date",20,10,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Date\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Crop_Plant_Population",3,"5 or more plants/row ft.",5,null,null,null,"Field_Tillage",10,5,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Crop_Planting_Date",1,"Jan 01 to May 05",20,null,null,null,"Treatments_Post_Emergence",0,-5,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Post_Emergence),\"\",sel_Treatments_Post_Emergence)","v":"None"}]
["Crop_Planting_Date",2,"May 16 to Dec 31",15]
["Crop_Planting_Date",3,"May 06 to May 15",10,null,null,null,"Total",{"$f":"SUMIF(I3:I8,\">0\")","v":110},{"$f":"SUMIF(J3:J8,\">0\")","v":45},{"$f":"MAX(TSWV_MinRiskIndex,SUM(K3:K8))","v":100}]
["Field_Tillage",1,"Conventional",10]
["Field_Tillage",2,"Strip into Residue",5,null,null,null,"High Risk Index",90]
["Treatments_Post_Emergence",1,"Comite, Danitol, Lannate, Lorsban (Pilot 15 G), None, Non-pyrethroids, Pyrethoids",0,null,null,null,"Moderate Risk Index",65]
["Treatments_Post_Emergence",2,"Acephate",-5]
["Treatments_Pre_Emergence",1,"None, Proline, Propulse",25]
["Treatments_Pre_Emergence",2,"Acephate, Admire Pro, AgLogic, Imidacloprid(Generic), Velum Total",10]
["Treatments_Pre_Emergence",3,"Phorate 20G, Thimet 20G",5]

{"sheet":"SM","index":12,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Spider Mites"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Field_Borders_Early_Season",1,"Weeds/Brush",15,null,null,null,"Treatments_Post_Emergence",40,5,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Multi\")","v":5},{"$f":"IF(ISBLANK(sel_Treatments_Post_Emergence),\"\",sel_Treatments_Post_Emergence)","v":"None"}]
["Field_Borders_Early_Season",2,"Clean",5,null,null,null,"Leaf_Spot_Management",30,10,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Leaf_Spot_Management),\"\",sel_Leaf_Spot_Management)","v":"Leafspot advisory throughout season"}]
["Field_Borders_Late_Season",1,"Mowed",20,null,null,null,"Field_Borders_Late_Season",20,5,20,{"$f":"IF(ISBLANK(sel_Field_Borders_Late_Season),\"\",sel_Field_Borders_Late_Season)","v":"Mowed"}]
["Field_Borders_Late_Season",2,"Not Mowed",5,null,null,null,"Field_Irrigation",20,5,5,{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Field_Irrigation",1,"Non-irrigated",20,null,null,null,"Pest_Hosts",20,5,15,{"$f":"IF(ISBLANK(sel_Pest_Hosts),\"\",sel_Pest_Hosts)","v":"Field Corn"}]
["Field_Irrigation",2,"Periodic Irrigation",13,null,null,null,"Field_Borders_Early_Season",15,5,5,{"$f":"IF(ISBLANK(sel_Field_Borders_Early_Season),\"\",sel_Field_Borders_Early_Season)","v":"Clean"}]
["Field_Irrigation",3,"Irrigated",5,null,null,null,"Leaf_Spot_Chorothalonil_Applications",10,5,10,{"$f":"IF(ISBLANK(sel_Leaf_Spot_Chorothalonil_Applications),\"\",sel_Leaf_Spot_Chorothalonil_Applications)","v":"3 or more"}]
["Leaf_Spot_Chorothalonil_Applications",1,"3 or more",10]
["Leaf_Spot_Chorothalonil_Applications",2,"Less than 3",5,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":155},{"$f":"SUMIF(J3:J9,\">0\")","v":40},{"$f":"MAX(SM_MinRiskIndex,SUM(K3:K9))","v":70}]
["Leaf_Spot_Management",1,"Calendar spray schedule",30]
["Leaf_Spot_Management",2,"Calendar spray schedule with skipping when dry",20,null,null,null,"High Risk Index",110]
["Leaf_Spot_Management",3,"Leafspot advisory throughout season",10,null,null,null,"Moderate Risk Index",80]
["Pest_Hosts",1,"Sweet Corn",20]
["Pest_Hosts",2,"Field Corn",15]
["Pest_Hosts",3,"Clary Sage, Cotton, Melons, Small Grains, Sorghum, Soybean, Tobacco, Vegetables",10]
["Pest_Hosts",4,"Fallow, Forage Grasses, Other, Sweetpotato",5]
["Treatments_Post_Emergence",1,"Lorsban (Pilot 15 G)",40]
["Treatments_Post_Emergence",2,"Lannate",20]
["Treatments_Post_Emergence",3,"Acephate, Pyrethoids",15]
["Treatments_Post_Emergence",4,"Danitol, Non-pyrethroids",10]
["Treatments_Post_Emergence",5,"Comite, None",5]

{"sheet":"SCR","index":13,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Southern Corn Rootworm"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Bailey, Emery, Sullivan, Wynne",20,null,null,null,"Field_Irrigation",45,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":45},{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Crop_Cultivar",2,"Champs",10,null,null,null,"Crop_Cultivar",20,10,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Planting_Date",1,"May 16 to Dec 31",15,null,null,null,"Soil_Drainage_Class",20,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Soil_Drainage_Class),\"\",sel_Soil_Drainage_Class)","v":"Well"}]
["Crop_Planting_Date",2,"May 02 to May 15",10,null,null,null,"Crop_Planting_Date",15,5,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Date\")","v":10},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Crop_Planting_Date",3,"Jan 01 to May 01",5,null,null,null,"Pest_History",15,0,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Pest_History_SCR),\"\",sel_Pest_History_SCR)","v":"No history"}]
["Field_Irrigation",1,"Irrigated",45,null,null,null,"Soil_Texture",15,5,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Single\")","v":15},{"$f":"IF(ISBLANK(sel_Soil_Texture),\"\",sel_Soil_Texture)","v":"Loam"}]
["Field_Irrigation",2,"Periodic Irrigation",20,null,null,null,"Treatments_Post_Emergence",0,-30,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Post_Emergence),\"\",sel_Treatments_Post_Emergence)","v":"None"}]
["Field_Irrigation",3,"Non-irrigated",0]
["Pest_History",1,"High",15,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":130},{"$f":"SUMIF(J3:J9,\">0\")","v":25},{"$f":"MAX(SCR_MinRiskIndex,SUM(K3:K9))","v":95}]
["Pest_History",2,"Moderate",10]
["Pest_History",3,"Low",5,null,null,null,"High Risk Index",70]
["Pest_History",4,"No history",0,null,null,null,"Moderate Risk Index",55]
["Soil_Drainage_Class",1,"Poorly",20]
["Soil_Drainage_Class",2,"Somewhat Poorly",15]
["Soil_Drainage_Class",3,"Moderately Well",10]
["Soil_Drainage_Class",4,"Well",5]
["Soil_Texture",1,"Loam",15]
["Soil_Texture",2,"Sandy Loam",10]
["Soil_Texture",3,"Loamy Sand",5]
["Treatments_Post_Emergence",1,"Comite, Danitol, None",0]
["Treatments_Post_Emergence",2,"Acephate, Lannate, Non-pyrethroids, Pyrethoids",-10]
["Treatments_Post_Emergence",3,"Lorsban (Pilot 15 G)",-30]

{"sheet":"NRN","index":14,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Northern Rootknot Nematode"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Field_Crop_History_1_Year_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",15,null,null,null,"Pest_History_Nematodes",40,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Pest_History_Nematodes_NRN),\"\",sel_Pest_History_Nematodes_NRN)","v":"Very Low (NCDA index <  20)"}]
["Field_Crop_History_1_Year_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",2,null,null,null,"Field_Crop_History_1_Year_Ago",15,2,2,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Field_Crop_History_2_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",10,null,null,null,"Field_Tillage",15,5,15,{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Field_Crop_History_2_Years_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",3,null,null,null,"Soil_Texture",15,5,5,{"$f":"IF(ISBLANK(sel_Soil_Texture),\"\",sel_Soil_Texture)","v":"Loam"}]
["Field_Tillage",1,"Conventional",15,null,null,null,"Field_Crop_History_2_Years_Ago",10,3,3,{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Field_Tillage",2,"Strip into Residue",5,null,null,null,"Treatments_Fumigants",0,-40,0,{"$f":"IF(ISBLANK(sel_Treatments_Fumigants),\"\",sel_Treatments_Fumigants)","v":"None"}]
["Pest_History_Nematodes",1,"High (NCDA index ≥ 60)",40,null,null,null,"Treatments_Pre_Emergence",0,-10,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Pest_History_Nematodes",2,"Moderate (40 ≤ NCDA index < 60)",30]
["Pest_History_Nematodes",3,"Low (20 ≤ NCDA index < 40)",20,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":95},{"$f":"SUMIF(J3:J9,\">0\")","v":15},{"$f":"MAX(NRN_MinRiskIndex,SUM(K3:K9))","v":25}]
["Pest_History_Nematodes",4,"Very Low (NCDA index <  20)",0]
["Soil_Texture",1,"Loamy Sand",15,null,null,null,"High Risk Index",65]
["Soil_Texture",2,"Sandy Loam",10,null,null,null,"Moderate Risk Index",40]
["Soil_Texture",3,"Loam",5]
["Treatments_Fumigants",1,"None",0]
["Treatments_Fumigants",2,"Metam Sodium",-25]
["Treatments_Fumigants",3,"Telone II",-40]
["Treatments_Pre_Emergence",1,"Acephate, Admire Pro, Imidacloprid(Generic), None, Phorate 20G, Proline, Thimet 20G",0]
["Treatments_Pre_Emergence",2,"AgLogic, Propulse, Velum Total",-10]

{"sheet":"PRN","index":15,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Peanut Rootknot Nematode"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Field_Crop_History_1_Year_Ago",1,"Clary Sage, Field Corn, Melons, Peanut, Sorghum, Soybean, Sweet Corn, Vegetables",15,null,null,null,"Pest_History_Nematodes",40,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Pest_History_Nematodes_PRN),\"\",sel_Pest_History_Nematodes_PRN)","v":"Very Low (NCDA index <  20)"}]
["Field_Crop_History_1_Year_Ago",2,"Cotton, Fallow, Other, Small Grains, Tobacco",2,null,null,null,"Field_Crop_History_1_Year_Ago",15,2,2,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Field_Crop_History_2_Years_Ago",1,"Clary Sage, Field Corn, Melons, Peanut, Sorghum, Soybean, Sweet Corn, Vegetables",10,null,null,null,"Field_Tillage",15,5,15,{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Field_Crop_History_2_Years_Ago",2,"Cotton, Fallow, Other, Small Grains, Tobacco",3,null,null,null,"Soil_Texture",15,5,5,{"$f":"IF(ISBLANK(sel_Soil_Texture),\"\",sel_Soil_Texture)","v":"Loam"}]
["Field_Tillage",1,"Conventional",15,null,null,null,"Field_Crop_History_2_Years_Ago",10,3,10,{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Field_Tillage",2,"Strip into Residue",5,null,null,null,"Treatments_Fumigants",0,-40,0,{"$f":"IF(ISBLANK(sel_Treatments_Fumigants),\"\",sel_Treatments_Fumigants)","v":"None"}]
["Pest_History_Nematodes",1,"High (NCDA index ≥ 60)",40,null,null,null,"Treatments_Pre_Emergence",0,-10,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Pest_History_Nematodes",2,"Moderate (40 ≤ NCDA index < 60)",30]
["Pest_History_Nematodes",3,"Low (20 ≤ NCDA index < 40)",25,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":95},{"$f":"SUMIF(J3:J9,\">0\")","v":15},{"$f":"MAX(PRN_MinRiskIndex,SUM(K3:K9))","v":32}]
["Pest_History_Nematodes",4,"Very Low (NCDA index <  20)",0]
["Soil_Texture",1,"Loamy Sand",15,null,null,null,"High Risk Index",65]
["Soil_Texture",2,"Sandy Loam",10,null,null,null,"Moderate Risk Index",40]
["Soil_Texture",3,"Loam",5]
["Treatments_Fumigants",1,"None",0]
["Treatments_Fumigants",2,"Metam Sodium",-25]
["Treatments_Fumigants",3,"Telone II",-40]
["Treatments_Pre_Emergence",1,"Acephate, Admire Pro, Imidacloprid(Generic), None, Phorate 20G, Proline, Thimet 20G",0]
["Treatments_Pre_Emergence",2,"AgLogic, Propulse, Velum Total",-10]

{"sheet":"SN","index":16,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Sting Nematode"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Field_Crop_History_1_Year_Ago",1,"Clary Sage, Cotton, Field Corn, Melons, Peanut, Sorghum, Soybean, Sweet Corn, Vegetables",15,null,null,null,"Pest_History_Nematodes",40,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Pest_History_Nematodes_SN),\"\",sel_Pest_History_Nematodes_SN)","v":"Very Low (NCDA index <  20)"}]
["Field_Crop_History_1_Year_Ago",2,"Fallow, Other, Small Grains, Tobacco",2,null,null,null,"Soil_Texture",20,5,5,{"$f":"IF(ISBLANK(sel_Soil_Texture),\"\",sel_Soil_Texture)","v":"Loam"}]
["Field_Crop_History_2_Years_Ago",1,"Clary Sage, Cotton, Field Corn, Melons, Peanut, Sorghum, Soybean, Sweet Corn, Vegetables",10,null,null,null,"Field_Crop_History_1_Year_Ago",15,2,15,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Field_Crop_History_2_Years_Ago",2,"Fallow, Other, Small Grains, Tobacco",3,null,null,null,"Field_Tillage",15,5,15,{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Field_Tillage",1,"Conventional",15,null,null,null,"Field_Crop_History_2_Years_Ago",10,3,10,{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Field_Tillage",2,"Strip into Residue",5,null,null,null,"Treatments_Fumigants",0,-40,0,{"$f":"IF(ISBLANK(sel_Treatments_Fumigants),\"\",sel_Treatments_Fumigants)","v":"None"}]
["Pest_History_Nematodes",1,"High (NCDA index ≥ 60)",40,null,null,null,"Treatments_Pre_Emergence",0,-10,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Pest_History_Nematodes",2,"Moderate (40 ≤ NCDA index < 60)",30]
["Pest_History_Nematodes",3,"Low (20 ≤ NCDA index < 40)",20,null,null,null,"Total",{"$f":"SUMIF(I3:I9,\">0\")","v":100},{"$f":"SUMIF(J3:J9,\">0\")","v":15},{"$f":"MAX(SN_MinRiskIndex,SUM(K3:K9))","v":45}]
["Pest_History_Nematodes",4,"Very Low (NCDA index <  20)",0]
["Soil_Texture",1,"Loamy Sand",20,null,null,null,"High Risk Index",65]
["Soil_Texture",2,"Sandy Loam",10,null,null,null,"Moderate Risk Index",45]
["Soil_Texture",3,"Loam",5]
["Treatments_Fumigants",1,"None",0]
["Treatments_Fumigants",2,"Metam Sodium",-25]
["Treatments_Fumigants",3,"Telone II",-40]
["Treatments_Pre_Emergence",1,"Acephate, Admire Pro, Imidacloprid(Generic), None, Phorate 20G, Proline, Thimet 20G",0]
["Treatments_Pre_Emergence",2,"AgLogic, Propulse, Velum Total",-10]

{"sheet":"SSR","index":17,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Southern Stem Rot"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Cultivar",1,"Champs",20,null,null,null,"Crop_Cultivar",20,5,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Crop_Cultivar),\"\",sel_Crop_Cultivar)","v":"Bailey"}]
["Crop_Cultivar",2,"Sullivan, Wynne",10,null,null,null,"Pest_History",20,5,5,{"$f":"IF(ISBLANK(sel_Pest_History_SSR),\"\",sel_Pest_History_SSR)","v":"No history"}]
["Crop_Cultivar",3,"Bailey",5,null,null,null,"Crop_Plant_Population",15,5,5,{"$f":"IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population)","v":"1 to 2 plants/row ft."}]
["Crop_Plant_Population",1,"5 or more plants/row ft.",15,null,null,null,"Field_Crop_History_1_Year_Ago",12,1,1,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Crop_Plant_Population",2,"3 to 4 plants/row ft.",10,null,null,null,"Crop_Row_Pattern",10,5,10,{"$f":"IF(ISBLANK(sel_Crop_Row_Pattern),\"\",sel_Crop_Row_Pattern)","v":"Single (32-38 inches)"}]
["Crop_Plant_Population",3,"1 to 2 plants/row ft.",5,null,null,null,"Field_Irrigation",10,5,10,{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Crop_Row_Pattern",1,"Single (32-38 inches)",10,null,null,null,"Field_Tillage",10,5,10,{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Crop_Row_Pattern",2,"Twin (7 to 10 inches)",5,null,null,null,"Field_Crop_History_2_Years_Ago",8,1,1,{"$f":"IF(ISBLANK(sel_Field_Crop_History_2_Years_Ago),\"\",sel_Field_Crop_History_2_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_1_Year_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",12,null,null,null,"Field_Crop_History_3_Years_Ago",4,1,1,{"$f":"IF(ISBLANK(sel_Field_Crop_History_3_Years_Ago),\"\",sel_Field_Crop_History_3_Years_Ago)","v":"Sorghum"}]
["Field_Crop_History_1_Year_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",1,null,null,null,"Field_Crop_History_4_Years_Ago",2,1,2,{"$f":"IF(ISBLANK(sel_Field_Crop_History_4_Years_Ago),\"\",sel_Field_Crop_History_4_Years_Ago)","v":"Soybean"}]
["Field_Crop_History_2_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",8,null,null,null,"Treatments_Pre_Emergence",0,-10,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Field_Crop_History_2_Years_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",1]
["Field_Crop_History_3_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",4,null,null,null,"Total",{"$f":"SUMIF(I3:I13,\">0\")","v":111},{"$f":"SUMIF(J3:J13,\">0\")","v":34},{"$f":"MAX(SSR_MinRiskIndex,SUM(K3:K13))","v":50}]
["Field_Crop_History_3_Years_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",1]
["Field_Crop_History_4_Years_Ago",1,"Clary Sage, Melons, Peanut, Soybean, Tobacco, Vegetables",2,null,null,null,"High Risk Index",85]
["Field_Crop_History_4_Years_Ago",2,"Cotton, Fallow, Field Corn, Other, Small Grains, Sorghum, Sweet Corn",1,null,null,null,"Moderate Risk Index",65]
["Field_Irrigation",1,"Irrigated",10]
["Field_Irrigation",2,"Periodic Irrigation",8]
["Field_Irrigation",3,"Non-irrigated",5]
["Field_Tillage",1,"Conventional",10]
["Field_Tillage",2,"Strip into Residue",5]
["Pest_History",1,"A problem even with good fungicide program",20]
["Pest_History",2,"Present but not a problem with a good fungicide program",15]
["Pest_History",3,"No history",5]
["Treatments_Pre_Emergence",1,"Acephate, Admire Pro, AgLogic, Imidacloprid(Generic), None, Phorate 20G, Thimet 20G, Velum Total",0]
["Treatments_Pre_Emergence",2,"Proline, Propulse",-10]

{"sheet":"WDS","index":18,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Weeds"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Plant_Population",1,"1 to 2 plants/row ft.",30,null,null,null,"Weed_Species",150,10,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":150},{"$f":"IF(ISBLANK(sel_Weed_Species),\"\",sel_Weed_Species)","v":"C. Ragweed and Palmer A. (ALS and PPO Resistant)"}]
["Crop_Plant_Population",2,"3 to 4 plants/row ft.",20,null,null,null,"Crop_Plant_Population",30,5,30,{"$f":"IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population)","v":"1 to 2 plants/row ft."}]
["Crop_Plant_Population",3,"5 or more plants/row ft.",5,null,null,null,"Field_Previous_Weed_Control",30,10,10,{"$f":"IF(ISBLANK(sel_Field_Previous_Weed_Control),\"\",sel_Field_Previous_Weed_Control)","v":"Good"}]
["Field_Crop_History_1_Year_Ago",1,"Soybean, Sweetpotato, Tobacco",15,null,null,null,"Weed_Management_Practices",30,-70,-70,{"$f":"IF(ISBLANK(sel_Weed_Management_Practices),\"\",sel_Weed_Management_Practices)","v":"PRE + EPOST + MPOST + LPOST + Hand Weed"}]
["Field_Crop_History_1_Year_Ago",2,"Sorghum",10,null,null,null,"Field_Irrigation",20,0,20,{"$f":"IF(ISBLANK(sel_Field_Irrigation),\"\",sel_Field_Irrigation)","v":"Irrigated"}]
["Field_Crop_History_1_Year_Ago",3,"Cotton",5,null,null,null,"Field_Crop_History_1_Year_Ago",15,0,5,{"$f":"IF(ISBLANK(sel_Field_Crop_History_1_Year_Ago),\"\",sel_Field_Crop_History_1_Year_Ago)","v":"Cotton"}]
["Field_Crop_History_1_Year_Ago",4,"Field Corn",0]
["Field_Irrigation",1,"Irrigated, Periodic Irrigation",20,null,null,null,"Total",{"$f":"SUMIF(I3:I8,\">0\")","v":275},{"$f":"SUMIF(J3:J8,\">0\")","v":25},{"$f":"MAX(WDS_MinRiskIndex,SUM(K3:K8))","v":145}]
["Field_Irrigation",2,"Non-irrigated",0]
["Field_Previous_Weed_Control",1,"Poor",30,null,null,null,"High Risk Index",150]
["Field_Previous_Weed_Control",2,"Fair",20,null,null,null,"Moderate Risk Index",85]
["Field_Previous_Weed_Control",3,"Good",10]
["Weed_Management_Practices",1,"EPOST, None, PPL",30]
["Weed_Management_Practices",2,"LPOST, PPI, PRE",-5]
["Weed_Management_Practices",3,"MPOST, PPI + PRE, PRE + EPOST",-30]
["Weed_Management_Practices",4,"PRE + EPOST + MPOST",-40]
["Weed_Management_Practices",5,"PRE + EPOST + MPOST + LPOST",-55]
["Weed_Management_Practices",6,"PRE + EPOST + Hand Weed, PRE + EPOST + MPOST + Hand Weed, PRE + EPOST + MPOST + LPOST + Hand Weed",-70]
["Weed_Species",1,"C. Ragweed and Palmer A. (ALS and PPO Resistant)",150]
["Weed_Species",2,"C. Ragweed and Palmer A. (PPO Resistant), Palmer Amaranth (ALS and PPO Resistant), Palmer Amaranth (PPO Resistant)",100]
["Weed_Species",3,"Annual Grass (ACC and ALS Resistant), C. Ragweed and Palmer A. (ALS Resistant), C. Ragweed and Palmer Amaranth, Palmer Amaranth, Palmer Amaranth (ALS Resistant)",70]
["Weed_Species",4,"Annual Grass (ACC Resistant), Annual Grass (ALS Resistant), C. Ragweed (ALS and PPO Resistance), C. Ragweed (PPO Resistance), Sedges (ALS Resistant)",50]
["Weed_Species",5,"Annual Grass, C. Lambsquarter, C. Ragweed, C. Ragweed (ALS Resistance), Eclipta, Sedges, Sicklepod",20]
["Weed_Species",6,"Others",10]

{"sheet":"THRP","index":19,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Thrips"]
["Category","Risk Level","Risk Level Description","Points",null,null,null,"Category","Max","Min","Risk","Selection"]
["Crop_Plant_Population",1,"1 to 2 plants/row ft.",20,null,null,null,"Crop_Planting_Date",30,10,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Date\")","v":30},{"$f":"IF(ISBLANK(sel_Crop_Planting_Date),\"\",sel_Crop_Planting_Date)","v":"2020-05-05"}]
["Crop_Plant_Population",2,"3 to 4 plants/row ft.",10,null,null,null,"Crop_Plant_Population",20,5,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Plant_Population),\"\",sel_Crop_Plant_Population)","v":"1 to 2 plants/row ft."}]
["Crop_Plant_Population",3,"5 or more plants/row ft.",5,null,null,null,"Field_Tillage",15,5,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":15},{"$f":"IF(ISBLANK(sel_Field_Tillage),\"\",sel_Field_Tillage)","v":"Conventional"}]
["Crop_Planting_Date",1,"Jan 01 to May 05",30,null,null,null,"Treatments_Post_Emergence",0,-15,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Post_Emergence),\"\",sel_Treatments_Post_Emergence)","v":"None"}]
["Crop_Planting_Date",2,"May 06 to May 15",15,null,null,null,"Treatments_Pre_Emergence",0,-25,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Multi\")","v":0},{"$f":"IF(ISBLANK(sel_Treatments_Pre_Emergence),\"\",sel_Treatments_Pre_Emergence)","v":"None"}]
["Crop_Planting_Date",3,"May 16 to Dec 31",10]
["Field_Tillage",1,"Conventional",15,null,null,null,"Total",{"$f":"SUMIF(I3:I7,\">0\")","v":65},{"$f":"SUMIF(J3:J7,\">0\")","v":20},{"$f":"MAX(THRP_MinRiskIndex,SUM(K3:K7))","v":65}]
["Field_Tillage",2,"Strip into Residue",5]
["Treatments_Post_Emergence",1,"Comite, Danitol, Lannate, Lorsban (Pilot 15 G), None, Non-pyrethroids, Pyrethoids",0,null,null,null,"High Risk Index",50]
["Treatments_Post_Emergence",2,"Acephate",-15,null,null,null,"Moderate Risk Index",35]
["Treatments_Pre_Emergence",1,"None, Proline, Propulse",0]
["Treatments_Pre_Emergence",2,"Acephate, Admire Pro, AgLogic, Imidacloprid(Generic), Phorate 20G, Thimet 20G, Velum Total",-25]