{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Risk","Crop","Log_TPL","Pests","Lists","Costs","Logos","Pest_Report"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":53,"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":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,5,1,6],[3,6,5,20]]}
[]
[]
[]
[null,null,null,null,null,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."]

{"sheet":"Crop","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5]]}
["Crop","Crop Name"]
[]
["Planting Season","Date","Month","Day of Month","Day of Year"]
["Start","2021-01-01",{"$f":"MONTH(B4)","v":1},{"$f":"DAY(B4)","v":1},{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":1}]
["End","2021-12-31",{"$f":"MONTH(B5)","v":12},{"$f":"DAY(B5)","v":31},{"$f":"B5-DATE(YEAR(B5),1,1)+1","v":365}]
[]
["Title","Crop Risk Management Tool"]
["Subtitle"]
["Credit Lines"]

{"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":"Crop Name"},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":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["PestType","Pest","PestID"]

{"sheet":"Lists","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Category","Category_Pest","CategoryID","Category_List","Category_List_Type","Months","Land_Area_Units"]
[null,null,null,null,null,"(01) January","ac"]
[null,null,null,null,null,"(02) February","ha"]
[null,null,null,null,null,"(03) March"]
[null,null,null,null,null,"(04) April"]
[null,null,null,null,null,"(05) May"]
[null,null,null,null,null,"(06) June"]
[null,null,null,null,null,"(07) July"]
[null,null,null,null,null,"(08) August"]
[null,null,null,null,null,"(09) September"]
[null,null,null,null,null,"(10) October"]
[null,null,null,null,null,"(11) November"]
[null,null,null,null,null,"(12) December"]

{"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 ","ac",null,null,null,null,null,{"$f":"Cost_Header","v":"Cost ($/ac)"},null,null,{"$f":"CONCATENATE(\"Person Hours (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hours (hrs/ac)"}]
["Category","Item",{"$f":"CONCATENATE(\"Cost ($/\",sel_Land_Area_Units,\")\")","v":"Cost ($/ac)"},"Multiplier",{"$f":"CONCATENATE(\"Person Hours (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hours (hrs/ac)"},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 ($/ac)"},null,null,{"$f":"CONCATENATE(\"Person Hour Thresholds (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Thresholds (hrs/ac)"}]
[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 ($/ac)"},null,null,{"$f":"CONCATENATE(\"Person Hour Ranges (hrs/\",sel_Land_Area_Units,\")\")","v":"Person Hour Ranges (hrs/ac)"}]
[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/ac"}]
[]
[]
[]
[]
[]
[]
[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/ac"}]

{"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":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":true,"merged":[[31,3,33,3],[35,0,35,3],[22,3,24,3],[25,0,25,1],[25,2,25,3],[26,3,29,3],[30,0,30,1],[30,2,30,3],[9,3,11,3],[12,0,12,1],[12,2,12,3],[13,3,15,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],[16,0,16,1],[16,2,16,3],[17,3,20,3],[21,0,21,1],[21,2,21,3]]}
["Peanut - Southern Corn Rootworm Risk Summary"]
[]
[]
[]
[]
["Crop Practices\\Cultivar",null,"Risk Points"]
[null,"Bailey, Bailey II*, Emery, Sullivan, Wynne",20,20]
[null,"Champs",10]
["Crop Practices\\Planting Date",null,"Risk Points"]
[null,"May 16 to Jun 30",15,10]
[null,"May 01 to May 15*",10]
[null,"Apr 23 to Apr 30",5]
["Field\\Irrigation",null,"Risk Points"]
[null,"Irrigated*",45,45]
[null,"Periodic Irrigation",20]
[null,"Non-Irrigated",0]
["Field Soil\\Drainage Class",null,"Risk Points"]
[null,"Poorly",20,5]
[null,"Somewhat Poorly",15]
[null,"Moderately Well",10]
[null,"Well*",5]
["Field Soil\\Texture",null,"Risk Points"]
[null,"Loam",15,5]
[null,"Sandy Loam",10]
[null,"Loamy Sand*",5]
["Pest History\\Southern Corn Rootworm",null,"Risk Points"]
[null,"High",15,0]
[null,"Moderate",10]
[null,"Low",5]
[null,"No History*",0]
["Treatments\\Post Insecticide",null,"Risk Points"]
[null,"None*, Brigade, Comite, Danitol, Portal",0,0]
[null,"Acephate, Lannate, Non-pyrethroids, Pyrethroids",-10]
[null,"Lorsban (Pilot 15 G)",-30]
[]
["* 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."]