{"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":23,"n_cols":21,"rows_kept":23,"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","Conventional",null,null,"Weeds",{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765},{"$f":"WDs_RiskIndex","v":765}]
[null,null,null,"Plant Density","3 plants per row foot"]
[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,"Field History"]
[null,null,null,"Previous Crop","Corn"]
[null,null,null,"Previous Weed Control","Good"]
[null,null,null,"Weed Herbicide Resistance","Palmer amaranth (ALS + Gly + Auxin)"]
[null,null,null,"Field Practices"]
[null,null,null,"Irrigation","None"]
[null,null,null,"Seedbed","Conventional"]
[null,null,null,"Pest Management"]
[null,null,null,"Thrips","None"]
[null,null,null,"Weed Management"]
[null,null,null,"Cultivation","None"]
[null,null,null,"Hand Weeding","None"]
[null,null,null,"POST Early","None"]
[null,null,null,"POST Late","None"]
[null,null,null,"POST Mid","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","Cotton"]
[]
["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 Cotton"]
["Subtitle"]
["Credit Lines"]
[null,"Charlie Cahoon, 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":184,"n_cols":20,"rows_kept":184,"cut":false,"hidden":true,"merged":[[58,5,58,9],[60,5,60,9],[22,5,22,14],[0,0,0,14],[55,5,55,9],[56,5,56,9],[57,5,57,9],[50,5,50,7],[51,5,51,7],[52,5,52,7]]}
["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":"Cotton"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillage_Pracs","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","No Control (<5%)"]
[null,null,null,"Soil ","Mapped Series","% of Field",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,null,null,null,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,"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/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,null,"Date","Trade Name"]
[null,null,null,"Growth Regulator"]
[null,null,null,"Defoliant"]
[]
[null,null,null,"Development Dates","Date","Crop Status"]
[null,null,null,"Planted"]
[null,null,null,"Emergence"]
[null,null,null,"First Pinhead Square"]
[null,null,null,"First Open Flower"]
[null,null,null,"First Open Boll"]
[null,null,null,"Harvest"]
[]
[null,null,null,"Weeds at Harvest"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Yield Goal","lbs/A"]
[null,null,null,"Lint"]
[null,null,null,"Seed"]
[]
[null,null,null,"Yield, Actual","lbs/A"]
[null,null,null,"Lint"]
[null,null,null,"Seed"]
[]
[null,null,null,"Selling Price ($/lb)","$/lb"]
[null,null,null,"Lint"]
[null,null,null,"Seed"]
[]
[null,null,null,"Rainfall/Irrigation","Date","Amount (in)","Month",null,"Month","Amount (in)"]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E85),\"\",TEXT(E85,\"mmm\"))","v":""},null,"Jan",{"$f":"SUMIF(G$85:G$184,\"=\" & I85,F$85:F$184)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISBLANK(E86),\"\",TEXT(E86,\"mmm\"))","v":""},null,"Feb",{"$f":"SUMIF(G$85:G$184,\"=\" & I86,F$85:F$184)","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(E150),\"\",TEXT(E150,\"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\\Plant_Density","Crop_Practices\\Herbicide_Traits","Field_History\\Weed_Herbicide_Resistance","Pest_Management\\Thrips","Field_Practices\\Seedbed","Weed_Management\\Cultivation","Weed_Management\\Hand_Weeding","Weed_Management\\PPL_or_PPI","Weed_Management\\PRE","Weed_Management\\POST_Early","Weed_Management\\POST_Mid","Weed_Management\\POST_Late"]
["Crop_Practices\\Herbicide_Traits",null,"Crop_Practices\\Herbicide_Traits","Crop_Practices\\Herbicide_Traits","Single","(01) January","ac","001 to 127","None","01|Poor","Corn","2 plants per row foot","Conventional","01|None","01|None","Conventional","01|None","01|None","01|None","01|None","01|None","01|None","01|None"]
["Crop_Practices\\Plant_Density",null,"Crop_Practices\\Plant_Density","Crop_Practices\\Plant_Density","Single","(02) February","ha","128 to 140","Yes","02|Fair","Cotton","3 plants per row foot","Glyphosate","02|Palmer amaranth (ALS + Gly + Auxin)","02|In-furrow","Fertilized Rye/No till","02|1 Cultivation","02|Minimal (2 person hrs/ac)","02|PPI","02|Residual PRE at planting","02|POST Only","02|POST Only","02|POST Only"]
["Crop_Practices\\Planting_Date",null,"Crop_Practices\\Planting_Date","Crop_Practices\\Planting_Date","Date","(03) March",null,"141 to 365",null,"03|Good","Grain Sorgham","4 plants per row foot","Glyphosate + Glufosinate","03|Palmer amaranth (ALS + Gly + Auxin + PPO)","03|In-furrow and POST","Fertilized Rye/Strip till","03|2 Cultivations","03|Moderate (4 person hrs/ac)","03|Residual PPL","03|POST + Residual PRE at planting","03|POST + Residual","03|POST + Residual","03|Layby"]
["Field_History\\Previous_Crop",null,"Field_History\\Previous_Crop","Field_History\\Previous_Crop","Single","(04) April",null,null,null,null,"Peanut",null,"Glyphosate + Glufosinate + 2,4-D","04|Palmer amaranth (ALS + Gly + Auxin + PPO + Glufosinate)","04|POST Only","No cover crop/No till","04|3 Cultivations","04|Intensive (6 person hrs/ac)","04|POST + Residual PPL early"]
["Field_History\\Previous_Weed_Control",null,"Field_History\\Previous_Weed_Control","Field_History\\Previous_Weed_Control","Single","(05) May",null,null,null,null,"Soybean",null,"Glyphosate + Glufosinate + Dicamba","05|Palmer amaranth or Common ragweed (ALS)",null,"No cover crop/Strip till"]
["Field_History\\Weed_Herbicide_Resistance",null,"Field_History\\Weed_Herbicide_Resistance","Field_History\\Weed_Herbicide_Resistance","Single","(06) June",null,null,null,null,"Sweetpotato",null,"Glyphosate + Glufosinate + HPPD","06|Palmer amaranth or Common ragweed (ALS + Gly)",null,"Rye/No till"]
["Field_Practices\\Irrigation",null,"Field_Practices\\Irrigation","Field_Practices\\Irrigation","Single","(07) July",null,null,null,null,"Tobacco",null,null,"07|Palmer amaranth or Common ragweed (ALS + Gly + PPO)",null,"Rye/Strip till"]
["Field_Practices\\Seedbed",null,"Field_Practices\\Seedbed","Field_Practices\\Seedbed","Single","(08) August",null,null,null,null,null,null,null,null,null,"Wheat/No till"]
["Pest_Management\\Thrips",null,"Pest_Management\\Thrips","Pest_Management\\Thrips","Single","(09) September",null,null,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_Early",null,"Weed_Management\\POST_Early","Weed_Management\\POST_Early","Single","(12) December"]
["Weed_Management\\POST_Late",null,"Weed_Management\\POST_Late","Weed_Management\\POST_Late","Single"]
["Weed_Management\\POST_Mid",null,"Weed_Management\\POST_Mid","Weed_Management\\POST_Mid","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":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[[0,7,0,9],[0,10,0,12],[17,7,17,9],[17,10,17,12],[21,7,21,9],[21,10,21,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,590.75,null,null,null,"Base_Cost",{"$f":"Cost_Base","v":590.75},{"$f":"Cost_Base","v":590.75},{"$f":"Cost_Base","v":590.75},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0},{"$f":"PersonHours_Base","v":0}]
["Crop_Practices\\Herbicide_Traits","Conventional",2.11,null,null,null,"Crop_Practices\\Herbicide_Traits | Crop_Practices\\Plant_Density",{"$f":"calcCostMax(G4,Category)","v":122.38},{"$f":"calcCostMin(G4)","v":61.19},{"$f":"calcCost(G4,N4,Category)","v":91.784999999999997},{"$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_Density),\"\",sel_Crop_Practices\\Plant_Density))","v":"Conventional | 3 plants per row foot"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate",2.11,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",2.11,null,null,null,"Field_Practices\\Seedbed",38.42,15,27.19,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Field_Practices\\Seedbed),\"\",sel_Field_Practices\\Seedbed))","v":"Conventional"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate + 2,4-D",2.11,null,null,null,"Pest_Management\\Thrips",22,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Pest_Management\\Thrips),\"\",sel_Pest_Management\\Thrips))","v":"None"}]
["Crop_Practices\\Herbicide_Traits","Glyphosate + Glufosinate + Dicamba",2.11,null,null,null,"Weed_Management\\Cultivation",12.03,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 + HPPD",2.11,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\\Plant_Density","2 plants per row foot",null,29,null,null,"Weed_Management\\POST_Early",30,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_Early),\"\",sel_Weed_Management\\POST_Early))","v":"None"}]
["Crop_Practices\\Plant_Density","3 plants per row foot",null,43.5,null,null,"Weed_Management\\POST_Late",30,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_Late),\"\",sel_Weed_Management\\POST_Late))","v":"None"}]
["Crop_Practices\\Plant_Density","4 plants per row foot",null,58,null,null,"Weed_Management\\POST_Mid",30,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\POST_Mid),\"\",sel_Weed_Management\\POST_Mid))","v":"None"}]
["Field_Practices\\Irrigation","None",0,null,null,null,"Weed_Management\\PPL_or_PPI",30,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\PPL_or_PPI),\"\",sel_Weed_Management\\PPL_or_PPI))","v":"None"}]
["Field_Practices\\Irrigation","Yes",100,null,null,null,"Weed_Management\\PRE",30,0,0,0,0,0,{"$f":"CONCATENATE(IF(ISBLANK(sel_Weed_Management\\PRE),\"\",sel_Weed_Management\\PRE))","v":"None"}]
["Field_Practices\\Seedbed","Conventional",27.19]
["Field_Practices\\Seedbed","Fertilized Rye/No till",15,null,null,null,"Total",{"$f":"SUM(H$3:H14)","v":1111.5999999999999},{"$f":"SUM(I$3:I14)","v":666.94},{"$f":"IF(ISERROR(SUM(J$3:J14)),0,SUM(J$3:J14))","v":709.72500000000002},{"$f":"SUM(K$3:K14)","v":0},{"$f":"SUM(L$3:L14)","v":0},{"$f":"IF(ISERROR(SUM(M$3:M14)),0,SUM(M$3:M14))","v":0}]
["Field_Practices\\Seedbed","Fertilized Rye/Strip till",38.42]
["Field_Practices\\Seedbed","No cover crop/No till",15,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\\Seedbed","No cover crop/Strip till",38.42,null,null,null,"High",{"$f":"Cost_Min + 0.66667*(Cost_Max-Cost_Min)","v":963.38148219999994},null,null,{"$f":"PersonHours_Min + 0.66667*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field_Practices\\Seedbed","Rye/No till",15,null,null,null,"Moderate",{"$f":"Cost_Min + 0.33333*(Cost_Max-Cost_Min)","v":815.15851780000003},null,null,{"$f":"PersonHours_Min + 0.33333*(PersonHours_Max-PersonHours_Min)","v":0}]
["Field_Practices\\Seedbed","Rye/Strip till",38.42]
["Field_Practices\\Seedbed","Wheat/No till",15,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","Wheat/Strip till",38.42,null,null,null,"Base",{"$f":"Cost_Base","v":590.75},null,null,{"$f":"PersonHours_Base","v":0}]
["Pest_Management\\Thrips","None",0,null,null,null,"Low",{"$f":"Cost_Moderate-Cost_Base","v":224.40851780000003},null,null,{"$f":"PersonHours_Moderate-PersonHours_Base","v":0}]
["Pest_Management\\Thrips","In-furrow",15,null,null,null,"Moderate",{"$f":"Cost_High-Cost_Moderate","v":148.22296439999991},null,null,{"$f":"PersonHours_High-PersonHours_Moderate","v":0}]
["Pest_Management\\Thrips","In-furrow and POST",22,null,null,null,"High",{"$f":"Cost_Max-Cost_High","v":148.21851779999997},null,null,{"$f":"PersonHours_Max-PersonHours_High","v":0}]
["Pest_Management\\Thrips","POST Only",7]
["Weed_Management\\Cultivation","None",0,null,null,null,{"$f":"CONCATENATE(\"Estimated Cost: $\",ROUNDUP(TRUNC(Cost,2),0),\"/\",sel_Land_Area_Units)","v":"Estimated Cost: $710/ac"}]
["Weed_Management\\Cultivation","1 Cultivation",4.01]
["Weed_Management\\Cultivation","2 Cultivations",8.02]
["Weed_Management\\Cultivation","3 Cultivations",12.03]
["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_Early","None",0]
["Weed_Management\\POST_Early","POST Only",15]
["Weed_Management\\POST_Early","POST + Residual",30]
["Weed_Management\\POST_Late","None",0]
["Weed_Management\\POST_Late","POST Only",15]
["Weed_Management\\POST_Late","Layby",30]
["Weed_Management\\POST_Mid","None",0]
["Weed_Management\\POST_Mid","POST Only",15]
["Weed_Management\\POST_Mid","POST + Residual",30]
["Weed_Management\\PPL_or_PPI","None",0]
["Weed_Management\\PPL_or_PPI","PPI",15]
["Weed_Management\\PPL_or_PPI","Residual PPL",15]
["Weed_Management\\PPL_or_PPI","POST + Residual PPL early",30]
["Weed_Management\\PRE","None",0]
["Weed_Management\\PRE","Residual PRE at planting",15]
["Weed_Management\\PRE","POST + Residual PRE at planting",30]

{"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":83,"n_cols":4,"rows_kept":83,"cut":false,"hidden":true,"merged":[[69,0,69,1],[69,2,69,3],[70,3,72,3],[73,0,73,1],[73,2,73,3],[37,0,37,1],[37,2,37,3],[38,3,39,3],[40,0,40,1],[40,2,40,3],[74,3,76,3],[77,0,77,1],[77,2,77,3],[78,3,80,3],[82,0,82,3],[30,3,36,3],[11,3,13,3],[14,0,14,1],[14,2,14,3],[15,3,17,3],[18,0,18,1],[18,2,18,3],[19,3,24,3],[25,0,25,1],[25,2,25,3],[26,3,28,3],[29,0,29,1],[29,2,29,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],[41,3,45,3],[46,0,46,1],[46,2,46,3],[47,3,50,3],[51,0,51,1],[51,2,51,3],[62,3,64,3],[65,0,65,1],[65,2,65,3],[66,3,68,3],[52,3,55,3],[56,0,56,1],[56,2,56,3],[57,3,60,3],[61,0,61,1],[61,2,61,3]]}
["Cotton - Weeds Risk Summary"]
[]
[]
[]
[]
["Crop Practices\\Herbicide Traits",null,"Risk Points"]
[null,"Conventional*",100,100]
[null,"Glyphosate",70]
[null,"Glyphosate + Glufosinate, Glyphosate + Glufosinate + HPPD",35]
[null,"Glyphosate + Glufosinate + 2,4-D, Glyphosate + Glufosinate + Dicamba",0]
["Crop Practices\\Plant Density",null,"Risk Points"]
[null,"2 plants per row foot",30,20]
[null,"3 plants per row foot*",20]
[null,"4 plants per row foot",10]
["Crop Practices\\Planting Date",null,"Risk Points"]
[null,"May 01 to May 05",40,20]
[null,"May 22 to Jul 15",30]
[null,"May 06 to May 21*",20]
["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,250]
[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,30]
[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]
["Pest Management\\Thrips",null,"Risk Points"]
[null,"None*",30,30]
[null,"POST Only",15]
[null,"In-furrow",10]
[null,"In-furrow and POST",5]
["Weed Management\\Cultivation",null,"Risk Points"]
[null,"None*",0,0]
[null,"1 Cultivation",-25]
[null,"2 Cultivations",-50]
[null,"3 Cultivations",-100]
["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 Early",null,"Risk Points"]
[null,"None*",60,60]
[null,"POST Only",-20]
[null,"POST + Residual",-100]
["Weed Management\\POST Late",null,"Risk Points"]
[null,"None*",20,20]
[null,"POST Only",-20]
[null,"Layby",-60]
["Weed Management\\POST Mid",null,"Risk Points"]
[null,"None*",40,40]
[null,"POST Only",-20]
[null,"POST + Residual",-80]
["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":62,"n_cols":12,"rows_kept":62,"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":250},{"$f":"IF(ISBLANK(sel_Field_History\\Weed_Herbicide_Resistance),\"\",sel_Field_History\\Weed_Herbicide_Resistance)","v":"Palmer amaranth (ALS + Gly + Auxin)"}]
["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":100},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Herbicide_Traits),\"\",sel_Crop_Practices\\Herbicide_Traits)","v":"Conventional"}]
["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_Density",1,"2 plants per row foot",30,null,null,null,"Weed_Management\\POST_Early",60,-100,{"$f":"getRiskValue(\"A:A\",H7,J7,L7,\"Single\")","v":60},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_Early),\"\",sel_Weed_Management\\POST_Early)","v":"None"}]
["Crop_Practices\\Plant_Density",2,"3 plants per row foot",20,null,null,null,"Crop_Practices\\Planting_Date",40,20,{"$f":"getRiskValue(\"A:A\",H8,J8,L8,\"Date\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Planting_Date),\"\",sel_Crop_Practices\\Planting_Date)","v":"2021-05-15"}]
["Crop_Practices\\Plant_Density",3,"4 plants per row foot",10,null,null,null,"Field_Practices\\Seedbed",40,10,{"$f":"getRiskValue(\"A:A\",H9,J9,L9,\"Single\")","v":30},{"$f":"IF(ISBLANK(sel_Field_Practices\\Seedbed),\"\",sel_Field_Practices\\Seedbed)","v":"Conventional"}]
["Crop_Practices\\Planting_Date",1,"001 to 127",40,null,null,null,"Weed_Management\\POST_Mid",40,-80,{"$f":"getRiskValue(\"A:A\",H10,J10,L10,\"Single\")","v":40},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_Mid),\"\",sel_Weed_Management\\POST_Mid)","v":"None"}]
["Crop_Practices\\Planting_Date",2,"141 to 365",30,null,null,null,"Crop_Practices\\Plant_Density",30,10,{"$f":"getRiskValue(\"A:A\",H11,J11,L11,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Crop_Practices\\Plant_Density),\"\",sel_Crop_Practices\\Plant_Density)","v":"3 plants per row foot"}]
["Crop_Practices\\Planting_Date",3,"128 to 140",20,null,null,null,"Field_History\\Previous_Crop",30,5,{"$f":"getRiskValue(\"A:A\",H12,J12,L12,\"Single\")","v":5},{"$f":"IF(ISBLANK(sel_Field_History\\Previous_Crop),\"\",sel_Field_History\\Previous_Crop)","v":"Corn"}]
["Field_History\\Previous_Crop",1,"Peanut",30,null,null,null,"Field_History\\Previous_Weed_Control",30,10,{"$f":"getRiskValue(\"A:A\",H13,J13,L13,\"Single\")","v":10},{"$f":"IF(ISBLANK(sel_Field_History\\Previous_Weed_Control),\"\",sel_Field_History\\Previous_Weed_Control)","v":"Good"}]
["Field_History\\Previous_Crop",2,"Sweetpotato",25,null,null,null,"Pest_Management\\Thrips",30,5,{"$f":"getRiskValue(\"A:A\",H14,J14,L14,\"Single\")","v":30},{"$f":"IF(ISBLANK(sel_Pest_Management\\Thrips),\"\",sel_Pest_Management\\Thrips)","v":"None"}]
["Field_History\\Previous_Crop",3,"Cotton",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"}]
["Field_History\\Previous_Crop",4,"Grain Sorgham|Tobacco",15,null,null,null,"Weed_Management\\POST_Late",20,-60,{"$f":"getRiskValue(\"A:A\",H16,J16,L16,\"Single\")","v":20},{"$f":"IF(ISBLANK(sel_Weed_Management\\POST_Late),\"\",sel_Weed_Management\\POST_Late)","v":"None"}]
["Field_History\\Previous_Crop",5,"Soybean",10,null,null,null,"Weed_Management\\Cultivation",0,-100,{"$f":"getRiskValue(\"A:A\",H17,J17,L17,\"Single\")","v":0},{"$f":"IF(ISBLANK(sel_Weed_Management\\Cultivation),\"\",sel_Weed_Management\\Cultivation)","v":"None"}]
["Field_History\\Previous_Crop",6,"Corn",5,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"}]
["Field_History\\Previous_Weed_Control",1,"Poor",30]
["Field_History\\Previous_Weed_Control",2,"Fair",20,null,null,null,"Total",{"$f":"SUMIF(I3:I18,\">0\")","v":1000},{"$f":"SUMIF(J3:J18,\">0\")","v":60},{"$f":"MAX(WDs_MinRiskIndex,SUM(K3:K18))","v":765}]
["Field_History\\Previous_Weed_Control",3,"Good",10]
["Field_History\\Weed_Herbicide_Resistance",1,"Palmer amaranth (ALS + Gly + Auxin + PPO + Glufosinate)",400,null,null,null,"High Risk Index",550]
["Field_History\\Weed_Herbicide_Resistance",2,"Palmer amaranth (ALS + Gly + Auxin + PPO)",300,null,null,null,"Moderate Risk Index",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]
["Pest_Management\\Thrips",1,"None",30]
["Pest_Management\\Thrips",2,"POST Only",15]
["Pest_Management\\Thrips",3,"In-furrow",10]
["Pest_Management\\Thrips",4,"In-furrow and POST",5]
["Weed_Management\\Cultivation",1,"None",0]
["Weed_Management\\Cultivation",2,"1 Cultivation",-25]
["Weed_Management\\Cultivation",3,"2 Cultivations",-50]
["Weed_Management\\Cultivation",4,"3 Cultivations",-100]
["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_Early",1,"None",60]
["Weed_Management\\POST_Early",2,"POST Only",-20]
["Weed_Management\\POST_Early",3,"POST + Residual",-100]
["Weed_Management\\POST_Late",1,"None",20]
["Weed_Management\\POST_Late",2,"POST Only",-20]
["Weed_Management\\POST_Late",3,"Layby",-60]
["Weed_Management\\POST_Mid",1,"None",40]
["Weed_Management\\POST_Mid",2,"POST Only",-20]
["Weed_Management\\POST_Mid",3,"POST + Residual",-80]
["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]