{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Risk","Crop","Log_TPL","Pests","Lists","Costs","Logos","Pest_Report","WDs"],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":0,"defined_names":84,"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":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[5,6,7,20],[1,5,1,6],[2,6,2,7],[2,9,2,12],[2,13,2,16],[2,17,2,20]]}
[]
[]
[null,null,null,"Crop Practices",null,null,"Pest",null,"Index","Low",null,null,null,"Med",null,null,null,"High"]
[null,null,null,"Herbicide Traits","Glyphosate + Glufosinate",null,null,"Weeds",{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445},{"$f":"WDs_RiskIndex","v":445}]
[null,null,null,"Plant Population","60,000 plants/ac"]
[null,null,null,"Planting Date","2021-05-15",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,"Row Pattern","Drilled - 7.5 inches"]
[null,null,null,"Field History"]
[null,null,null,"Previous Crop","Corn"]
[null,null,null,"Previous Weed Control","Good"]
[null,null,null,"Weed Herbicide Resistance","None"]
[null,null,null,"Field Practices"]
[null,null,null,"Irrigation","None"]
[null,null,null,"Seedbed","Fertilized Rye/No till"]
[null,null,null,"Weed Management"]
[null,null,null,"Cultivation","None"]
[null,null,null,"Hand Weeding","None"]
[null,null,null,"POST V2 Growth Stage","None"]
[null,null,null,"POST V4 Growth Stage","None"]
[null,null,null,"POST V6 Growth Stage or Later","None"]
[null,null,null,"PPL or PPI","None"]
[null,null,null,"PRE","None"]

{"sheet":"Crop","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4]]}
["Crop","Soybean"]
[]
["Planting Season","Date","Month","Day of Month","Day of Year"]
["Start","2021-04-15",{"$f":"MONTH(B4)","v":4},{"$f":"DAY(B4)","v":15},{"$f":"B4-DATE(YEAR(B4),1,1)+1","v":105}]
["End","2021-07-15",{"$f":"MONTH(B5)","v":7},{"$f":"DAY(B5)","v":15},{"$f":"B5-DATE(YEAR(B5),1,1)+1","v":196}]
[]
["Title","Weed Risk Management Tool - NC Soybean"]
["Subtitle"]
["Credit Lines"]
[null,"Wes Everman, David Jordan, Greg Buol"]
[null,"Department of Crop and Soil Sciences"]
[]
[null,"North Carolina State University, Raleigh NC"]

{"sheet":"Log_TPL","index":2,"n_rows":177,"n_cols":20,"rows_kept":177,"cut":false,"hidden":true,"merged":[[56,5,56,9],[59,5,59,9],[24,5,24,14],[0,0,0,14],[53,5,53,9],[54,5,54,9],[55,5,55,9]]}
["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":"Soybean"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillage_Pracs","Control_Rating"]
[null,null,null,"Variety"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bed","No Control (<5%)"]
[null,null,null,"Field Area (A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chisel","Poor (5% to 20%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivate","Low (20% to 50%)"]
[null,null,null,"Soil ","Mapped Series","% of Field",null,null,null,null,null,null,null,null,null,null,null,null,"Disk","Moderate (50% to 80%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moldboard Plow","High (80% to 90%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Till","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,null,null,null,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,"Tillage Practice","Date","Equipment"]
[]
[]
[]
[]
[null,null,null,"Lime Applications","Date","Rate (lbs/A)"]
[null,null,null,"Current Year"]
[null,null,null,"Last Year"]
[]
[null,null,null,"Fertilizer","Date","N","P2O5","K2O","B","Cu","Fe","Mn","Mo","S","Zn"]
[null,null,null,null,null,"lbs/A"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Weed Control","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,"Cultivation"]
[]
[]
[null,null,null,"Postemergence"]
[]
[]
[null,null,null,"Hand Weeding"]
[]
[]
[null,null,null,"Pest Treaments","Date","Pest","Severity","Trade Name","Rate","Trade Name","Rate","Evaluation Date","Control Rating"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Development Dates","Date","Crop Status"]
[null,null,null,"Planted"]
[null,null,null,"Emergence (VE)"]
[null,null,null,"First Flower(R1)"]
[null,null,null,"First Pod (R3)"]
[null,null,null,"First Seed (R5)"]
[null,null,null,"Maturity (R7)"]
[null,null,null,"Harvest (R8)"]
[]
[null,null,null,"Weeds at Harvest"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Yield","Bu/ac","% Moisture"]
[null,null,null,"Goal"]
[null,null,null,"Actual"]
[]
[null,null,null,"Selling Price ($/Bu)"]
[]
[null,null,null,"Rainfall/Irrigation","Date","Amount (in)","Month",null,"Month","Amount (in)"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E78),\"\",TEXT(E78,\"mmm\"))","v":""},null,"Jan",{"$f":"SUMIF(G$78:G$177,\"=\" & I78,F$78:F$177)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E79),\"\",TEXT(E79,\"mmm\"))","v":""},null,"Feb",{"$f":"SUMIF(G$78:G$177,\"=\" & I79,F$78:F$177)","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(E143),\"\",TEXT(E143,\"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":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["PestType","Pest","PestID"]
["Pest","Weeds","WDs"]

{"sheet":"Lists","index":4,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Category","Category_Pest","CategoryID","Category_List","Category_List_Type","Months","Land_Area_Units","Crop_Practices\\Planting_Date","Field_Practices\\Irrigation","Field_History\\Previous_Weed_Control","Field_History\\Previous_Crop","Crop_Practices\\Herbicide_Traits","Field_History\\Weed_Herbicide_Resistance","Field_Practices\\Seedbed","Weed_Management\\Cultivation","Weed_Management\\Hand_Weeding","Weed_Management\\PPL_or_PPI","Weed_Management\\PRE","Crop_Practices\\Row_Pattern","Weed_Management\\POST_V2_Growth_Stage","Weed_Management\\POST_V4_Growth_Stage","Weed_Management\\POST_V6_Growth_Stage_or_Later","Crop_Practices\\Plant_Population"]
["Crop_Practices\\Herbicide_Traits",null,"Crop_Practices\\Herbicide_Traits","Crop_Practices\\Herbicide_Traits","Single","(01) January","ac","001 to 120","None","01|Poor","Corn","Conventional","01|None","Conventional","01|None","01|None","01|None","01|None","01|Drilled - 7.5 inches","01|None","01|None","01|None","01|60,000 plants/ac"]
["Crop_Practices\\Plant_Population",null,"Crop_Practices\\Plant_Population","Crop_Practices\\Plant_Population","Single","(02) February","ha","121 to 140","Yes","02|Fair","Cotton","Glyphosate","02|Palmer amaranth (ALS + Gly + Auxin)","Fertilized Rye/No till","02|1 Cultivation","02|Minimal (2 person hrs/ac)","02|PPI","02|Residual PRE at planting","02|Planter - 15 inches","02|POST Only","02|POST Only","02|POST Only","02|80,000 plants/ac"]
["Crop_Practices\\Planting_Date",null,"Crop_Practices\\Planting_Date","Crop_Practices\\Planting_Date","Date","(03) March",null,"141 to 166",null,"03|Good","Grain Sorgham","Glyphosate + Glufosinate","03|Palmer amaranth (ALS + Gly + Auxin + PPO)","Fertilized Rye/Strip till","03|2 Cultivations","03|Moderate (4 person hrs/ac)","03|Residual PPL","03|POST + Residual PRE at planting","03|Planter - 18 inches","03|POST + Residual","03|POST + Residual",null,"03|100,000 plants/ac"]
["Crop_Practices\\Row_Pattern",null,"Crop_Practices\\Row_Pattern","Crop_Practices\\Row_Pattern","Single","(04) April",null,"167 to 365",null,null,"Peanut","Glyphosate + Glufosinate + 2,4-D","04|Palmer amaranth (ALS + Gly + Auxin + PPO + Glufosinate)","No cover crop/No till",null,"04|Intensive (6 person hrs/ac)","04|POST + Residual PPL early",null,"04|Planter - 20 inches",null,null,null,"04|120,000 plants/ac"]
["Field_History\\Previous_Crop",null,"Field_History\\Previous_Crop","Field_History\\Previous_Crop","Single","(05) May",null,null,null,null,"Soybean","Glyphosate + Glufosinate + Dicamba","05|Palmer amaranth or Common ragweed (ALS)","No cover crop/Strip till",null,null,null,null,"05|Planter - 24 inches",null,null,null,"05|140,000 plants/ac"]
["Field_History\\Previous_Weed_Control",null,"Field_History\\Previous_Weed_Control","Field_History\\Previous_Weed_Control","Single","(06) June",null,null,null,null,"Sweetpotato","Glyphosate + Glufosinate + HPPD","06|Palmer amaranth or Common ragweed (ALS + Gly)","Rye/No till",null,null,null,null,"06|Planter - 30 inches",null,null,null,"06|160,000 plants/ac"]
["Field_History\\Weed_Herbicide_Resistance",null,"Field_History\\Weed_Herbicide_Resistance","Field_History\\Weed_Herbicide_Resistance","Single","(07) July",null,null,null,null,"Tobacco",null,"07|Palmer amaranth or Common ragweed (ALS + Gly + PPO)","Rye/Strip till",null,null,null,null,"07|Planter - 36 inches",null,null,null,"07|180,000 plants/ac"]
["Field_Practices\\Irrigation",null,"Field_Practices\\Irrigation","Field_Practices\\Irrigation","Single","(08) August",null,null,null,null,null,null,null,"Wheat/No till",null,null,null,null,"08|Twin Row Planter - 36 inches"]
["Field_Practices\\Seedbed",null,"Field_Practices\\Seedbed","Field_Practices\\Seedbed","Single","(09) September",null,null,null,null,null,null,null,"Wheat/Strip till"]
["Weed_Management\\Cultivation",null,"Weed_Management\\Cultivation","Weed_Management\\Cultivation","Single","(10) October"]
["Weed_Management\\Hand_Weeding",null,"Weed_Management\\Hand_Weeding","Weed_Management\\Hand_Weeding","Single","(11) November"]
["Weed_Management\\POST_V2_Growth_Stage",null,"Weed_Management\\POST_V2_Growth_Stage","Weed_Management\\POST_V2_Growth_Stage","Single","(12) December"]
["Weed_Management\\POST_V4_Growth_Stage",null,"Weed_Management\\POST_V4_Growth_Stage","Weed_Management\\POST_V4_Growth_Stage","Single"]
["Weed_Management\\POST_V6_Growth_Stage_or_Later",null,"Weed_Management\\POST_V6_Growth_Stage_or_Later","Weed_Management\\POST_V6_Growth_Stage_or_Later","Single"]
["Weed_Management\\PPL_or_PPI",null,"Weed_Management\\PPL_or_PPI","Weed_Management\\PPL_or_PPI","Single"]
["Weed_Management\\PRE",null,"Weed_Management\\PRE","Weed_Management\\PRE","Single"]

{"sheet":"Costs","index":5,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,7,0,9],[0,10,0,12],[16,7,16,9],[16,10,16,12],[20,7,20,9],[20,10,20,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,210,null,null,null,"Base_Cost",{"$f":"Cost_Base","v":210},{"$f":"Cost_Base","v":210},{"$f":"Cost_Base","v":210},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0}]
["Crop_Practices\\Herbicide_Traits","Conventional",30,null,null,null,"Crop_Practices\\Herbicide_Traits | Crop_Practices\\Plant_Population",{"$f":"calcCostMax(G4,Category)","v":70.95},{"$f":"calcCostMin(G4)","v":12.9},{"$f":"calcCost(G4,N4,Category)","v":23.65},{"$f":"calcPersonHrsMax(G4,Category)","v":0},{"$f":"calcPersonHrsMin(G4)","v":0},{"$f":"calcPersonHrs(G4,N4,Category)","v":0},{"$f":"CONCATENATE(IF(ISBLANK(sel_Crop_Practices\\Herbicide_Traits),\"\",sel_Crop_Practices\\Herbicide_Traits),\" | \",IF(ISBLANK(sel_Crop_Practices\\Plant_Population),\"\",sel_Crop_Practices\\Plant_Population))","v":"Glyphosate + Glufosinate | 60,000 plants/ac"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate",30,null,null,null,"Field_Practices\\Irrigation",100,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field_Practices\\Irrigation),\"\",sel_Field_Practices\\Irrigation))","v":"None"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate",55,null,null,null,"Field_Practices\\Seedbed",50,0,50,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field_Practices\\Seedbed),\"\",sel_Field_Practices\\Seedbed))","v":"Fertilized Rye/No till"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate + 2,4-D",55,null,null,null,"Weed_Management\\Cultivation",12,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\Cultivation),\"\",sel_Weed_Management\\Cultivation))","v":"None"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate + Dicamba",55,null,null,null,"Weed_Management\\Hand_Weeding",76.02,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\Hand_Weeding),\"\",sel_Weed_Management\\Hand_Weeding))","v":"None"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate + HPPD",55,null,null,null,"Weed_Management\\POST_V2_Growth_Stage",35,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_V2_Growth_Stage),\"\",sel_Weed_Management\\POST_V2_Growth_Stage))","v":"None"}]
["Crop_Practices\\Plant_Population","60,000 plants/ac",null,0.43,null,null,"Weed_Management\\POST_V4_Growth_Stage",35,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_V4_Growth_Stage),\"\",sel_Weed_Management\\POST_V4_Growth_Stage))","v":"None"}]
["Crop_Practices\\Plant_Population","80,000 plants/ac",null,0.56999999999999995,null,null,"Weed_Management\\POST_V6_Growth_Stage_or_Later",20,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_V6_Growth_Stage_or_Later),\"\",sel_Weed_Management\\POST_V6_Growth_Stage_or_Later))","v":"None"}]
["Crop_Practices\\Plant_Population","100,000 plants/ac",null,0.71,null,null,"Weed_Management\\PPL_or_PPI",35,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\PPL_or_PPI),\"\",sel_Weed_Management\\PPL_or_PPI))","v":"None"}]
["Crop_Practices\\Plant_Population","120,000 plants/ac",null,0.86,null,null,"Weed_Management\\PRE",35,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\PRE),\"\",sel_Weed_Management\\PRE))","v":"None"}]
["Crop_Practices\\Plant_Population","140,000 plants/ac",null,1]
["Crop_Practices\\Plant_Population","160,000 plants/ac",null,1.1399999999999999,null,null,"Total",{"$f":"SUM(H$3:H13)","v":678.97},{"$f":"SUM(I$3:I13)","v":222.9},{"$f":"IF(ISERROR(SUM(J$3:J13)),0,SUM(J$3:J13))","v":283.64999999999998},{"$f":"SUM(K$3:K13)","v":0},{"$f":"SUM(L$3:L13)","v":0},{"$f":"IF(ISERROR(SUM(M$3:M13)),0,SUM(M$3:M13))","v":0}]
["Crop_Practices\\Plant_Population","180,000 plants/ac",null,1.29]
["Field_Practices\\Irrigation","None",0,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)"}]
["Field_Practices\\Irrigation","Yes",100,null,null,null,"High",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":526.9481869},null,null,{"$f":"PersonHours_Min + 0.66667*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field_Practices\\Seedbed","Conventional",20,null,null,null,"Moderate",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":374.92181310000001},null,null,{"$f":"PersonHours_Min + 0.33333*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field_Practices\\Seedbed","Fertilized Rye/No till",50]
["Field_Practices\\Seedbed","Fertilized Rye/Strip till",50,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)"}]
["Field_Practices\\Seedbed","No cover crop/No till",15,null,null,null,"Base",{"$f":"Cost_Base","v":210},null,null,{"$f":"PersonHours_Base","v":0}]
["Field_Practices\\Seedbed","No cover crop/Strip till",0,null,null,null,"Low",{"$f":"Cost_Moderate-Cost_Base","v":164.92181310000001},null,null,{"$f":"PersonHours_Moderate-PersonHours_Base","v":0}]
["Field_Practices\\Seedbed","Rye/No till",35,null,null,null,"Moderate",{"$f":"Cost_High-Cost_Moderate","v":152.02637379999999},null,null,{"$f":"PersonHours_High-PersonHours_Moderate","v":0}]
["Field_Practices\\Seedbed","Rye/Strip till",35,null,null,null,"High",{"$f":"Cost_Max-Cost_High","v":152.02181310000003},null,null,{"$f":"PersonHours_Max-PersonHours_High","v":0}]
["Field_Practices\\Seedbed","Wheat/No till",35]
["Field_Practices\\Seedbed","Wheat/Strip till",35,null,null,null,{"$f":"CONCATENATE(\"Estimated Cost: $\",ROUNDUP(TRUNC(Cost,2),0),\"/\",sel_Land_Area_Units)","v":"Estimated Cost: $284/ac"}]
["Weed_Management\\Cultivation","None",0]
["Weed_Management\\Cultivation","1 Cultivation",6]
["Weed_Management\\Cultivation","2 Cultivations",12]
["Weed_Management\\Hand_Weeding","None",0]
["Weed_Management\\Hand_Weeding","Minimal (2 person hrs/ac)",25.35]
["Weed_Management\\Hand_Weeding","Moderate (4 person hrs/ac)",50.58]
["Weed_Management\\Hand_Weeding","Intensive (6 person hrs/ac)",76.02,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"}]
["Weed_Management\\POST_V2_Growth_Stage","None",0]
["Weed_Management\\POST_V2_Growth_Stage","POST Only",20]
["Weed_Management\\POST_V2_Growth_Stage","POST + Residual",35]
["Weed_Management\\POST_V4_Growth_Stage","None",0]
["Weed_Management\\POST_V4_Growth_Stage","POST Only",20]
["Weed_Management\\POST_V4_Growth_Stage","POST + Residual",35]
["Weed_Management\\POST_V6_Growth_Stage_or_Later","None",0]
["Weed_Management\\POST_V6_Growth_Stage_or_Later","POST Only",20]
["Weed_Management\\PPL_or_PPI","None",0]
["Weed_Management\\PPL_or_PPI","PPI",20]
["Weed_Management\\PPL_or_PPI","Residual PPL",20]
["Weed_Management\\PPL_or_PPI","POST + Residual PPL early",35]
["Weed_Management\\PRE","None",0]
["Weed_Management\\PRE","Residual PRE at planting",20]
["Weed_Management\\PRE","POST + Residual PRE at planting",35]

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

{"sheet":"Pest_Report","index":7,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":true,"merged":[[71,3,73,3],[74,0,74,1],[74,2,74,3],[82,3,84,3],[86,0,86,3],[75,3,76,3],[77,0,77,1],[77,2,77,3],[78,3,80,3],[81,0,81,1],[81,2,81,3],[67,3,69,3],[70,0,70,1],[70,2,70,3],[58,3,60,3],[62,3,65,3],[66,0,66,1],[66,2,66,3],[11,3,16,3],[17,0,17,1],[17,2,17,3],[18,3,21,3],[22,0,22,1],[22,2,22,3],[0,0,0,3],[5,0,5,1],[5,2,5,3],[6,3,9,3],[10,0,10,1],[10,2,10,3],[23,3,28,3],[29,0,29,1],[29,2,29,3],[30,3,35,3],[36,0,36,1],[36,2,36,3],[37,3,39,3],[40,0,40,1],[40,2,40,3],[41,3,47,3],[48,0,48,1],[48,2,48,3],[49,3,50,3],[51,0,51,1],[51,2,51,3],[61,0,61,1],[61,2,61,3],[52,3,56,3],[57,0,57,1],[57,2,57,3]]}
["Soybean - Weeds Risk Summary"]
[]
[]
[]
[]
["Crop Practices\\Herbicide Traits",null,"Risk Points"]
[null,"Conventional",100,35]
[null,"Glyphosate",70]
[null,"Glyphosate + Glufosinate*, Glyphosate + Glufosinate + HPPD",35]
[null,"Glyphosate + Glufosinate + 2,4-D, Glyphosate + Glufosinate + Dicamba",0]
["Crop Practices\\Plant Population",null,"Risk Points"]
[null,"60,000 plants/ac*",45,45]
[null,"80,000 plants/ac",35]
[null,"100,000 plants/ac",25]
[null,"120,000 plants/ac",20]
[null,"140,000 plants/ac",15]
[null,"160,000 plants/ac, 180,000 plants/ac",10]
["Crop Practices\\Planting Date",null,"Risk Points"]
[null,"Apr 15 to Apr 30",40,30]
[null,"May 01 to May 20*",30]
[null,"May 21 to Jun 15",20]
[null,"Jun 16 to Jul 15",10]
["Crop Practices\\Row Pattern",null,"Risk Points"]
[null,"Planter - 36 inches",50,10]
[null,"Planter - 30 inches, Twin Row Planter - 36 inches",40]
[null,"Planter - 24 inches",30]
[null,"Planter - 18 inches, Planter - 20 inches",25]
[null,"Planter - 15 inches",20]
[null,"Drilled - 7.5 inches*",10]
["Field History\\Previous Crop",null,"Risk Points"]
[null,"Peanut",30,5]
[null,"Sweetpotato",25]
[null,"Cotton",20]
[null,"Grain Sorgham, Tobacco",15]
[null,"Soybean",10]
[null,"Corn*",5]
["Field History\\Previous Weed Control",null,"Risk Points"]
[null,"Poor",30,10]
[null,"Fair",20]
[null,"Good*",10]
["Field History\\Weed Herbicide Resistance",null,"Risk Points"]
[null,"Palmer amaranth (ALS + Gly + Auxin + PPO + Glufosinate)",400,0]
[null,"Palmer amaranth (ALS + Gly + Auxin + PPO)",300]
[null,"Palmer amaranth (ALS + Gly + Auxin)",250]
[null,"Palmer amaranth or Common ragweed (ALS + Gly + PPO)",150]
[null,"Palmer amaranth or Common ragweed (ALS + Gly)",100]
[null,"Palmer amaranth or Common ragweed (ALS)",70]
[null,"None*",0]
["Field Practices\\Irrigation",null,"Risk Points"]
[null,"None*",20,20]
[null,"Yes",0]
["Field Practices\\Seedbed",null,"Risk Points"]
[null,"No cover crop/No till",40,10]
[null,"Conventional, No cover crop/Strip till, Rye/Strip till, Wheat/Strip till",30]
[null,"Wheat/No till",25]
[null,"Fertilized Rye/Strip till, Rye/No till",20]
[null,"Fertilized Rye/No till*",10]
["Weed Management\\Cultivation",null,"Risk Points"]
[null,"None*",0,0]
[null,"1 Cultivation",-25]
[null,"2 Cultivations",-50]
["Weed Management\\Hand Weeding",null,"Risk Points"]
[null,"None*",0,0]
[null,"Minimal (2 person hrs/ac)",-50]
[null,"Moderate (4 person hrs/ac)",-100]
[null,"Intensive (6 person hrs/ac)",-200]
["Weed Management\\POST V2 Growth Stage",null,"Risk Points"]
[null,"None*",60,60]
[null,"POST Only",-20]
[null,"POST + Residual",-100]
["Weed Management\\POST V4 Growth Stage",null,"Risk Points"]
[null,"None*",40,40]
[null,"POST Only",-20]
[null,"POST + Residual",-80]
["Weed Management\\POST V6 Growth Stage or Later",null,"Risk Points"]
[null,"None*",20,20]
[null,"POST Only",-20]
["Weed Management\\PPL or PPI",null,"Risk Points"]
[null,"None*",80,80]
[null,"PPI, Residual PPL",-20]
[null,"POST + Residual PPL early",-80]
["Weed Management\\PRE",null,"Risk Points"]
[null,"None*",80,80]
[null,"Residual PRE at planting",-40]
[null,"POST + Residual PRE at planting",-80]
[]
["* 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":66,"n_cols":12,"rows_kept":66,"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\\Herbicide_Traits",1,"Conventional",100,null,null,null,"Field_History\\Weed_Herbicide_Resistance",400,0,{"$f":"getRiskValue(\"A:A\",H3,J3,L3,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Field_History\\Weed_Herbicide_Resistance),\"\",sel_Field_History\\Weed_Herbicide_Resistance)","v":"None"}]
["Crop_Practices\\Herbicide_Traits",2,"Glyphosate",70,null,null,null,"Crop_Practices\\Herbicide_Traits",100,0,{"$f":"getRiskValue(\"A:A\",H4,J4,L4,\"Single\")","v":35},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Herbicide_Traits),\"\",sel_Crop_Practices\\Herbicide_Traits)","v":"Glyphosate + Glufosinate"}]
["Crop_Practices\\Herbicide_Traits",3,"Glyphosate + Glufosinate|Glyphosate + Glufosinate + HPPD",35,null,null,null,"Weed_Management\\PPL_or_PPI",80,-80,{"$f":"getRiskValue(\"A:A\",H5,J5,L5,\"Single\")","v":80},{"$f":"IF(ISBLANK(sel_Weed_Management\\PPL_or_PPI),\"\",sel_Weed_Management\\PPL_or_PPI)","v":"None"}]
["Crop_Practices\\Herbicide_Traits",4,"Glyphosate + Glufosinate + 2,4-D|Glyphosate + Glufosinate + Dicamba",0,null,null,null,"Weed_Management\\PRE",80,-80,{"$f":"getRiskValue(\"A:A\",H6,J6,L6,\"Single\")","v":80},{"$f":"IF(ISBLANK(sel_Weed_Management\\PRE),\"\",sel_Weed_Management\\PRE)","v":"None"}]
["Crop_Practices\\Plant_Population",1,"60,000 plants/ac",45,null,null,null,"Weed_Management\\POST_V2_Growth_Stage",60,-100,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":60},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_V2_Growth_Stage),\"\",sel_Weed_Management\\POST_V2_Growth_Stage)","v":"None"}]
["Crop_Practices\\Plant_Population",2,"80,000 plants/ac",35,null,null,null,"Crop_Practices\\Row_Pattern",50,10,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Row_Pattern),\"\",sel_Crop_Practices\\Row_Pattern)","v":"Drilled - 7.5 inches"}]
["Crop_Practices\\Plant_Population",3,"100,000 plants/ac",25,null,null,null,"Crop_Practices\\Plant_Population",45,10,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":45},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Plant_Population),\"\",sel_Crop_Practices\\Plant_Population)","v":"60,000 plants/ac"}]
["Crop_Practices\\Plant_Population",4,"120,000 plants/ac",20,null,null,null,"Crop_Practices\\Planting_Date",40,10,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"Date\")","v":30},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Planting_Date),\"\",sel_Crop_Practices\\Planting_Date)","v":"2021-05-15"}]
["Crop_Practices\\Plant_Population",5,"140,000 plants/ac",15,null,null,null,"Field_Practices\\Seedbed",40,10,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_Practices\\Seedbed),\"\",sel_Field_Practices\\Seedbed)","v":"Fertilized Rye/No till"}]
["Crop_Practices\\Plant_Population",6,"160,000 plants/ac|180,000 plants/ac",10,null,null,null,"Weed_Management\\POST_V4_Growth_Stage",40,-80,{"$f":"getRiskValue(\"A:A\",H12,J12,L12,\"Single\")","v":40},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_V4_Growth_Stage),\"\",sel_Weed_Management\\POST_V4_Growth_Stage)","v":"None"}]
["Crop_Practices\\Planting_Date",1,"001 to 120",40,null,null,null,"Field_History\\Previous_Crop",30,5,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Field_History\\Previous_Crop),\"\",sel_Field_History\\Previous_Crop)","v":"Corn"}]
["Crop_Practices\\Planting_Date",2,"121 to 140",30,null,null,null,"Field_History\\Previous_Weed_Control",30,10,{"$f":"getRiskValue(\"A:A\",H14,J14,L14,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_History\\Previous_Weed_Control),\"\",sel_Field_History\\Previous_Weed_Control)","v":"Good"}]
["Crop_Practices\\Planting_Date",3,"141 to 166",20,null,null,null,"Field_Practices\\Irrigation",20,0,{"$f":"getRiskValue(\"A:A\",H15,J15,L15,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Field_Practices\\Irrigation),\"\",sel_Field_Practices\\Irrigation)","v":"None"}]
["Crop_Practices\\Planting_Date",4,"167 to 365",10,null,null,null,"Weed_Management\\POST_V6_Growth_Stage_or_Later",20,-20,{"$f":"getRiskValue(\"A:A\",H16,J16,L16,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_V6_Growth_Stage_or_Later),\"\",sel_Weed_Management\\POST_V6_Growth_Stage_or_Later)","v":"None"}]
["Crop_Practices\\Row_Pattern",1,"Planter - 36 inches",50,null,null,null,"Weed_Management\\Cultivation",0,-50,{"$f":"getRiskValue(\"A:A\",H17,J17,L17,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Weed_Management\\Cultivation),\"\",sel_Weed_Management\\Cultivation)","v":"None"}]
["Crop_Practices\\Row_Pattern",2,"Planter - 30 inches|Twin Row Planter - 36 inches",40,null,null,null,"Weed_Management\\Hand_Weeding",0,-200,{"$f":"getRiskValue(\"A:A\",H18,J18,L18,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Weed_Management\\Hand_Weeding),\"\",sel_Weed_Management\\Hand_Weeding)","v":"None"}]
["Crop_Practices\\Row_Pattern",3,"Planter - 24 inches",30]
["Crop_Practices\\Row_Pattern",4,"Planter - 18 inches|Planter - 20 inches",25,null,null,null,"Total",{"$f":"SUMIF(I3:I18,\">0\")","v":1035},{"$f":"SUMIF(J3:J18,\">0\")","v":55},{"$f":"MAX(WDs_MinRiskIndex,SUM(K3:K18))","v":445}]
["Crop_Practices\\Row_Pattern",5,"Planter - 15 inches",20]
["Crop_Practices\\Row_Pattern",6,"Drilled - 7.5 inches",10,null,null,null,"High Risk Index",425]
["Field_History\\Previous_Crop",1,"Peanut",30,null,null,null,"Moderate Risk Index",240]
["Field_History\\Previous_Crop",2,"Sweetpotato",25]
["Field_History\\Previous_Crop",3,"Cotton",20]
["Field_History\\Previous_Crop",4,"Grain Sorgham|Tobacco",15]
["Field_History\\Previous_Crop",5,"Soybean",10]
["Field_History\\Previous_Crop",6,"Corn",5]
["Field_History\\Previous_Weed_Control",1,"Poor",30]
["Field_History\\Previous_Weed_Control",2,"Fair",20]
["Field_History\\Previous_Weed_Control",3,"Good",10]
["Field_History\\Weed_Herbicide_Resistance",1,"Palmer amaranth (ALS + Gly + Auxin + PPO + Glufosinate)",400]
["Field_History\\Weed_Herbicide_Resistance",2,"Palmer amaranth (ALS + Gly + Auxin + PPO)",300]
["Field_History\\Weed_Herbicide_Resistance",3,"Palmer amaranth (ALS + Gly + Auxin)",250]
["Field_History\\Weed_Herbicide_Resistance",4,"Palmer amaranth or Common ragweed (ALS + Gly + PPO)",150]
["Field_History\\Weed_Herbicide_Resistance",5,"Palmer amaranth or Common ragweed (ALS + Gly)",100]
["Field_History\\Weed_Herbicide_Resistance",6,"Palmer amaranth or Common ragweed (ALS)",70]
["Field_History\\Weed_Herbicide_Resistance",7,"None",0]
["Field_Practices\\Irrigation",1,"None",20]
["Field_Practices\\Irrigation",2,"Yes",0]
["Field_Practices\\Seedbed",1,"No cover crop/No till",40]
["Field_Practices\\Seedbed",2,"Conventional|No cover crop/Strip till|Rye/Strip till|Wheat/Strip till",30]
["Field_Practices\\Seedbed",3,"Wheat/No till",25]
["Field_Practices\\Seedbed",4,"Fertilized Rye/Strip till|Rye/No till",20]
["Field_Practices\\Seedbed",5,"Fertilized Rye/No till",10]
["Weed_Management\\Cultivation",1,"None",0]
["Weed_Management\\Cultivation",2,"1 Cultivation",-25]
["Weed_Management\\Cultivation",3,"2 Cultivations",-50]
["Weed_Management\\Hand_Weeding",1,"None",0]
["Weed_Management\\Hand_Weeding",2,"Minimal (2 person hrs/ac)",-50]
["Weed_Management\\Hand_Weeding",3,"Moderate (4 person hrs/ac)",-100]
["Weed_Management\\Hand_Weeding",4,"Intensive (6 person hrs/ac)",-200]
["Weed_Management\\POST_V2_Growth_Stage",1,"None",60]
["Weed_Management\\POST_V2_Growth_Stage",2,"POST Only",-20]
["Weed_Management\\POST_V2_Growth_Stage",3,"POST + Residual",-100]
["Weed_Management\\POST_V4_Growth_Stage",1,"None",40]
["Weed_Management\\POST_V4_Growth_Stage",2,"POST Only",-20]
["Weed_Management\\POST_V4_Growth_Stage",3,"POST + Residual",-80]
["Weed_Management\\POST_V6_Growth_Stage_or_Later",1,"None",20]
["Weed_Management\\POST_V6_Growth_Stage_or_Later",2,"POST Only",-20]
["Weed_Management\\PPL_or_PPI",1,"None",80]
["Weed_Management\\PPL_or_PPI",2,"PPI|Residual PPL",-20]
["Weed_Management\\PPL_or_PPI",3,"POST + Residual PPL early",-80]
["Weed_Management\\PRE",1,"None",80]
["Weed_Management\\PRE",2,"Residual PRE at planting",-40]
["Weed_Management\\PRE",3,"POST + Residual PRE at planting",-80]