{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Design PERCENT","Design LBS","Sheet1","Table 1 - Seeding Rates","Table 2-Characteristics-OLD","Table 2 -Characteristics Sept23","Help","Sheet2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":24,"comments":2,"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":"Design PERCENT","index":0,"n_rows":112,"n_cols":36,"rows_kept":112,"cut":false,"hidden":false,"merged":[[109,1,110,4],[103,1,104,4],[74,9,74,10],[75,9,75,10],[76,9,76,10],[77,9,77,10],[78,9,78,10],[79,9,79,10],[80,9,80,10],[81,9,81,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[109,6,110,10],[107,1,107,2],[107,4,107,10],[76,1,76,2],[77,1,77,2],[103,6,104,10],[86,11,86,27],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[85,1,85,2],[98,1,101,27],[82,13,82,14],[97,1,97,2],[95,6,95,8],[95,9,95,12],[95,13,95,27],[96,2,96,7],[90,4,90,5],[84,11,84,12],[82,11,82,12],[84,13,84,27],[95,3,95,5],[80,11,80,12],[82,26,82,27],[46,7,46,8],[47,7,47,8],[48,7,48,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[80,13,80,27],[77,11,77,27],[45,7,45,8],[58,1,60,27],[62,8,62,10],[54,1,54,2],[48,11,48,12],[45,1,45,2],[46,1,46,2],[40,5,40,6],[40,13,40,14],[41,11,41,12],[40,9,40,10],[47,13,47,14],[48,13,48,14],[49,13,49,14],[7,4,7,5],[70,4,70,5],[14,0,17,27],[19,0,23,27],[26,0,26,27],[33,7,34,8],[50,5,50,6],[29,13,29,27],[30,9,30,12],[29,9,29,12],[30,6,30,8],[29,6,29,8],[30,3,30,5],[29,3,29,5],[54,7,54,8],[47,1,47,2],[33,27,34,27],[33,9,34,10],[45,11,45,12],[46,11,46,12],[37,13,37,14],[36,7,36,8],[45,13,45,14],[46,13,46,14],[50,13,50,14],[51,13,51,14],[52,13,52,14],[47,11,47,12],[54,9,54,10],[51,1,51,2],[52,1,52,2],[56,1,56,3],[56,4,56,6],[55,5,55,6],[52,9,52,10],[53,9,53,10],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[55,7,55,8],[55,12,55,14],[54,13,54,14],[53,13,53,14],[50,9,50,10],[51,9,51,10],[18,2,18,27],[10,2,10,27],[11,2,11,27],[12,2,12,27],[13,2,13,27],[27,1,27,27],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,9,28,12],[28,13,28,27],[24,2,24,5],[24,6,24,7],[24,12,24,27],[24,8,24,10],[30,1,30,2],[29,1,29,2],[30,13,30,27],[43,7,43,8],[44,7,44,8],[38,5,38,6],[39,5,39,6],[38,1,38,2],[39,1,39,2],[40,1,40,2],[44,5,44,6],[40,7,40,8],[41,7,41,8],[40,11,40,12],[44,13,44,14],[33,13,34,14],[36,5,36,6],[33,5,34,6],[33,3,34,3],[33,1,34,2],[35,1,35,2],[35,5,35,6],[37,5,37,6],[31,2,31,5],[69,11,69,14],[70,9,70,11],[70,12,70,14],[70,7,70,8],[62,2,62,5],[65,1,65,14],[64,13,64,14],[64,8,64,10],[68,2,68,7],[5,8,5,10],[5,11,5,14],[67,11,67,14],[67,2,67,7],[39,13,39,14],[38,13,38,14],[39,11,39,12],[38,9,38,10],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[67,8,67,10],[35,7,35,8],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[42,7,42,8],[1,1,1,14],[5,2,5,7],[4,8,4,10],[42,5,42,6],[42,13,42,14],[43,5,43,6],[42,11,42,12],[43,11,43,12],[41,13,41,14],[41,9,41,10],[43,9,43,10],[6,6,6,10],[35,9,35,10],[37,9,37,10],[35,13,35,14],[36,13,36,14],[4,2,4,7],[36,9,36,10],[36,1,36,2],[33,4,34,4],[4,11,4,14],[6,11,6,14],[7,11,7,14],[32,1,32,27],[6,2,6,5],[7,7,7,8],[38,11,38,12],[41,5,41,6],[44,11,44,12],[44,9,44,10],[50,1,50,2],[54,5,54,6],[53,1,53,2],[48,1,48,2],[49,1,49,2],[37,1,37,2],[33,11,34,12],[37,11,37,12],[35,11,35,12],[36,11,36,12],[49,11,49,12],[52,5,52,6],[53,5,53,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[109,12,110,14],[97,7,97,8],[64,2,64,5],[39,9,39,10],[55,9,55,10],[42,9,42,10],[43,13,43,14],[90,9,90,10],[78,1,78,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[93,9,93,12],[93,13,93,27],[94,1,94,2],[94,3,94,5],[94,6,94,8],[94,9,94,12],[94,13,94,27],[95,1,95,2],[51,5,51,6],[78,11,78,27],[87,11,88,27],[92,1,92,27],[93,1,93,2],[93,3,93,5],[93,6,93,8],[54,11,54,12],[53,7,53,8],[73,1,73,2],[74,1,74,2],[75,1,75,2],[73,9,73,10],[73,11,73,27],[74,11,74,27],[75,11,75,27],[66,19,69,19],[66,20,69,20],[72,1,72,14],[68,11,68,14],[68,8,68,10],[69,7,69,10],[69,2,69,3],[66,17,69,17],[66,18,69,18]]}
[]
[null,"810 - Minnesota Annual Forages for Grazing Systems Design Worksheet"]
[null,"Note: Yellow areas indicate required data.  Blue areas indicate optional data."]
[]
[null,"Name:",null,null,null,null,null,null,"Program:"]
[null,"Address:",null,null,null,null,null,null,"Contract #:"]
[null,"Field No.:",null,null,null,null,"Contract Item No.:"]
[null,"Section:",null,"TWP:",null,null,"R:",null,null,null,"Acres:"]
[null,"Indicate the decision-maker's objective(s) for applying annual forages, in priority order (1, 2, 3,etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,"Provide or increase forage supply during periods of low forage production or to extend the grazing season."]
[null,null,"Provide temporary cover to reduce wind and water erosion and forage for sites where perennial forages will be re-established."]
[null,null,"Reduce excess nutrients from the soil."]
[null,null,"Improve soil microbial life and soil aggregate stability."]
[]
[]
[]
[]
[null,"Seeding Method:","-"]
[]
[]
[]
[]
[]
[null,"Seeding Window:",null,null,null,null,"Legume \nInoculant Needed:",null,"-",null,null,"Weed Control:","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starter & inoculant",null,"Broadcast/Incorporate",null,"Aug 15-Sep 20",null,"Harvest",null,"onions",0.5]
[]
[null,"Soil Amendments"]
[null,"N Fertilizer needed \n(lbs/acre)",null,"K2O Fertilizer needed (lbs/acre)",null,null,"P205  Fertilizer needed (lbs/acre)",null,null,"Other Nutrients needed (lbs/acre)",null,null,null,"Planned Time of Application"]
[]
[]
[null,"-","Soil test attached (Soil test is required)"]
[null,"Planned Annual Forages Mixture"]
[null,"Annual Forage Species",null,"Full Seed Rate of PLS lb/ac","Acres","Percent of Full Rate of PLS",null,"Rate of PLS lb/ac",null,"Total PLS lbs",null,"Crop Type",null,"Seeding Depth (inches)",null,null,null,null,null,"CRP",null,null,null,null,null,null,null,"Seeds per Sq/Ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSP"]
[null,"-",null,{"$f":"VLOOKUP(B36,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B36=\"-\",\"\",L8)","v":""},null,null,{"$f":"IF(B36=\"-\",\"\",D36*F36)","v":""},null,{"$f":"IF(F36=\"\",\"\",E36*H36)","v":""},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,$Q$71:$V$103,6,FALSE))","v":{"$error":"#N/A"}},null,null,null,"CTA",null,null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B36=\"-\",\"-\",(VLOOKUP(B36,Sheet1!$A$3:$G$47,7,FALSE))*H36/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B37,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B37=\"-\",\"\",L8)","v":""},null,null,{"$f":"IF(B37=\"-\",\"\",D37*F37)","v":""},null,{"$f":"IF(F37=\"\",\"\",E37*H37)","v":""},null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"ECP",null,null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B37=\"-\",\"-\",(VLOOKUP(B37,Sheet1!$A$3:$G$47,7,FALSE))*H37/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B38,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B38=\"-\",\"\",L8)","v":""},null,null,"",null,{"$f":"IF(F38=\"\",\"\",E38*H38)","v":""},null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"EQIP",null,null,null,null,null,null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B38=\"-\",\"-\",(VLOOKUP(B38,Sheet1!$A$3:$G$47,7,FALSE))*H38/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B39,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B39=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"FRPP",null,null,null,null,null,null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B39=\"-\",\"-\",(VLOOKUP(B39,Sheet1!$A$3:$G$47,7,FALSE))*H39/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B40,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B40=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"GRP",null,null,null,null,null,null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B40=\"-\",\"-\",(VLOOKUP(B40,Sheet1!$A$3:$G$47,7,FALSE))*H40/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B41,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B41=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"SWCA",null,null,null,null,null,null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B41=\"-\",\"-\",(VLOOKUP(B41,Sheet1!$A$3:$G$47,7,FALSE))*H41/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B42,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B42=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"WHIP",null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B42=\"-\",\"-\",(VLOOKUP(B42,Sheet1!$A$3:$G$47,7,FALSE))*H42/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B43,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B43=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"WRP",null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B43=\"-\",\"-\",(VLOOKUP(B43,Sheet1!$A$3:$G$47,7,FALSE))*H43/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B44,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B44=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B44=\"-\",\"-\",(VLOOKUP(B44,Sheet1!$A$3:$G$47,7,FALSE))*H44/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B45,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B45=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B45=\"-\",\"-\",(VLOOKUP(B45,Sheet1!$A$3:$G$47,7,FALSE))*H45/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B46,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B46=\"-\",\"\",L8)","v":""},null,null,"",null,{"$f":"IF(F46=\"\",\"\",E46*H46)","v":""},null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B46=\"-\",\"-\",(VLOOKUP(B46,Sheet1!$A$3:$G$47,7,FALSE))*H46/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B47,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B47=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B47=\"-\",\"-\",(VLOOKUP(B47,Sheet1!$A$3:$G$47,7,FALSE))*H47/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B48,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B48=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B48=\"-\",\"-\",(VLOOKUP(B48,Sheet1!$A$3:$G$47,7,FALSE))*H48/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B49,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B49=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B49=\"-\",\"-\",(VLOOKUP(B49,Sheet1!$A$3:$G$47,7,FALSE))*H49/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B50,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B50=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B50=\"-\",\"-\",(VLOOKUP(B50,Sheet1!$A$3:$G$47,7,FALSE))*H50/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B51,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B51=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B51=\"-\",\"-\",(VLOOKUP(B51,Sheet1!$A$3:$G$47,7,FALSE))*H51/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B52,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B52=\"-\",\"\",L8)","v":""},null,null,"",null,{"$f":"IF(F52=\"\",\"\",E52*H52)","v":""},null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B52=\"-\",\"-\",(VLOOKUP(B52,Sheet1!$A$3:$G$47,7,FALSE))*H52/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B53,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B53=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B53=\"-\",\"-\",(VLOOKUP(B53,Sheet1!$A$3:$G$47,7,FALSE))*H53/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B54,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B54=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B54=\"-\",\"-\",(VLOOKUP(B54,Sheet1!$A$3:$G$47,7,FALSE))*H54/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B55,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B55=\"-\",\"\",L8)","v":""},null,null,"",null,"",null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,$Q$71:$V$103,6,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B55=\"-\",\"-\",(VLOOKUP(B55,Sheet1!$A$3:$G$47,7,FALSE))*H55/43560)","v":"-"}]
[null,null,null,null,null,{"$f":"SUM(F36:G55)","v":0},null,"Total lbs/PLS",null,{"$f":"SUM(J36:K55)","v":0},null,null,"Total Seeds per Sq/Ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB36:AB55)","v":0}]
[null,"Estimated PLS seeding rate (lbs/acre):",null,null,{"$f":"IF(L8=\"\",\"\",SUM(J56/L8))","v":""},null,null,null,null,null,null,null,null,"Planned Seeding Depth (inches):",{"$f":"IFERROR(AVERAGEIF(AA36:AA55,\">0\"),0)","v":0},{"$f":"IF(N36=\"\",\"\",SUM(P36:P55)/COUNTIF(P36:P55,\">0\"))","v":{"$error":"#N/A"}}]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Planned By:",null,null,null,null,null,"Date:"]
[]
[null,"Approved By:",null,null,null,null,null,"Date:",null,null,null,null,"JAA:"]
[null,"Annual Forages Certification Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crop Type*","Seeding rate, lbs/acre","Seeding depth, inches","Seed Size"]
[null,"Name:",{"$f":"IF(C5=\"\",\"\",C5)","v":""},null,null,null,null,null,"Program:",null,null,{"$f":"IF(L5=\"\",\"\",L5)","v":""}]
[null,"Address:",{"$f":"IF(C6=\"\",\"\",C6)","v":""},null,null,null,null,null,"Contract #:",null,null,{"$f":"IF(L6=\"\",\"\",L6)","v":""},null,null,null,null,"Species"]
[null,"Site location:",{"$f":"IF(C7=\"\",\"\",C7)","v":""},null,null,null,null,"Contract Item #:",null,null,null,{"$f":"IF(L7=\"\",\"\",L7)","v":""}]
[null,"Section:",{"$f":"IF(C8=\"\",\"\",C8)","v":""},"TWP:",{"$f":"IF(E8=\"\",\"\",E8)","v":""},null,"R:",{"$f":"IF(H8=\"\",\"\",H8)","v":""},null,"Acres Planted:",null,null,null,null,null,null,"alfalfa","CB",10,"0.25 - 0.75","F",0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"barley","CG",50,"0.75 - 2","L",1.25]
[null,"Instructions: Document producer's actual forages planting information below.  Attach or include photos of the forages to this Job Sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"buckwheat","WB",48,"0.5 - 1.5","F",1]
[null,"Species ",null,"Total Pounds Planted","% \nGerm","%\n Purity","Total PLS # Planted","PLS\nLB/AC","% of Full Rate","Seeds/ \nSq Ft",null,"Practice Check Out Conditions"]
[null,{"$f":"IF(B36=\"\",\"\",B36)","v":"-"},null,null,null,null,{"$f":"IF(B75=\"-\",\"\",(D75*E75*F75))","v":""},{"$f":"IF(B75=\"-\",\"\",(G75/$M$71))","v":""},{"$f":"IF(B75=\"-\",\"\",(H75/(IF($AJ$9=1,VLOOKUP(B75,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B75,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B75,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B75=\"-\",\"\",(VLOOKUP(B75,Sheet1!$A$3:$G$47,7,FALSE))*H75/43560)","v":""},null,"Site Preparation:"]
[null,"-",null,null,null,null,{"$f":"IF(B76=\"-\",\"\",(D76*E76*F76))","v":""},{"$f":"IF(B76=\"-\",\"\",(G76/$M$71))","v":""},{"$f":"IF(B76=\"-\",\"\",(H76/(IF($AJ$9=1,VLOOKUP(B76,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B76,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B76,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B76=\"-\",\"\",(VLOOKUP(B76,Sheet1!$A$3:$G$47,7,FALSE))*H76/43560)","v":""}]
[null,{"$f":"IF(B38=\"\",\"\",B38)","v":"-"},null,null,null,null,{"$f":"IF(B77=\"-\",\"\",(D77*E77*F77))","v":""},"",{"$f":"IF(B77=\"-\",\"\",(H77/(IF($AJ$9=1,VLOOKUP(B77,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B77,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B77,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B77=\"-\",\"\",(VLOOKUP(B77,Sheet1!$A$3:$G$47,7,FALSE))*H77/43560)","v":""}]
[null,{"$f":"IF(B39=\"\",\"\",B39)","v":"-"},null,null,null,null,"","",{"$f":"IF(B78=\"-\",\"\",(H78/(IF($AJ$9=1,VLOOKUP(B78,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B78,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B78,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B78=\"-\",\"\",(VLOOKUP(B78,Sheet1!$A$3:$G$47,7,FALSE))*H78/43560)","v":""},null,"Planting Method:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B79=\"-\",\"\",(H79/(IF($AJ$9=1,VLOOKUP(B79,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B79,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B79,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B79=\"-\",\"\",(VLOOKUP(B79,Sheet1!$A$3:$G$47,7,FALSE))*H79/43560)","v":""},null,"-"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B80=\"-\",\"\",(H80/(IF($AJ$9=1,VLOOKUP(B80,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B80,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B80,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B80=\"-\",\"\",(VLOOKUP(B80,Sheet1!$A$3:$G$47,7,FALSE))*H80/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B81=\"-\",\"\",(H81/(IF($AJ$9=1,VLOOKUP(B81,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B81,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B81,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B81=\"-\",\"\",(VLOOKUP(B81,Sheet1!$A$3:$G$47,7,FALSE))*H81/43560)","v":""},null,"Date Planted:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B82=\"-\",\"\",(H82/(IF($AJ$9=1,VLOOKUP(B82,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B82,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B82,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B82=\"-\",\"\",(VLOOKUP(B82,Sheet1!$A$3:$G$47,7,FALSE))*H82/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B83=\"-\",\"\",(H83/(IF($AJ$9=1,VLOOKUP(B83,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B83,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B83,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B83=\"-\",\"\",(VLOOKUP(B83,Sheet1!$A$3:$G$47,7,FALSE))*H83/43560)","v":""},null,"Planting Depth:",null,null,null,null,"flax","CB",35,"0.25 - 0.75","F",0.5,null,null,null,null,"Inches"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B84=\"-\",\"\",(H84/(IF($AJ$9=1,VLOOKUP(B84,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B84,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B84,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B84=\"-\",\"\",(VLOOKUP(B84,Sheet1!$A$3:$G$47,7,FALSE))*H84/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B85=\"-\",\"\",(H85/(IF($AJ$9=1,VLOOKUP(B85,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B85,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B85,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B85=\"-\",\"\",(VLOOKUP(B85,Sheet1!$A$3:$G$47,7,FALSE))*H85/43560)","v":""},null,"Weed Control:",null,"-"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B86=\"-\",\"\",(H86/(IF($AJ$9=1,VLOOKUP(B86,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B86,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B86,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B86=\"-\",\"\",(VLOOKUP(B86,Sheet1!$A$3:$G$47,7,FALSE))*H86/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B87=\"-\",\"\",(H87/(IF($AJ$9=1,VLOOKUP(B87,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B87,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B87,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B87=\"-\",\"\",(VLOOKUP(B87,Sheet1!$A$3:$G$47,7,FALSE))*H87/43560)","v":""},null,"Legume Inoculant:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B88=\"-\",\"\",(H88/(IF($AJ$9=1,VLOOKUP(B88,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B88,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B88,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B88=\"-\",\"\",(VLOOKUP(B88,Sheet1!$A$3:$G$47,7,FALSE))*H88/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B89=\"-\",\"\",(H89/(IF($AJ$9=1,VLOOKUP(B89,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B89,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B89,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B89=\"-\",\"\",(VLOOKUP(B89,Sheet1!$A$3:$G$47,7,FALSE))*H89/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B90=\"-\",\"\",(H90/(IF($AJ$9=1,VLOOKUP(B90,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B90,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B90,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B90=\"-\",\"\",(VLOOKUP(B90,Sheet1!$A$3:$G$47,7,FALSE))*H90/43560)","v":""}]
[null,null,null,null,null,null,"Totals:",{"$f":"SUM(H75:H90)","v":0},{"$f":"SUM(I75:I90)","v":0},{"$f":"SUM(J75:K90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ryegrass (itialian)","CG",25,"0.25 - 0.5","L",0.5]
[null,"Soil Amendments Applied"]
[null,"N Fertilizer applied \n(lbs/acre)",null,"K2O Fertilizer applied (lbs/acre)",null,null,"P205  Fertilizer applied (lbs/acre)",null,null,"Other Nutrients applied (lbs/acre)",null,null,null,"Application Date"]
[]
[]
[null,"-","Fertilizer application record attached (Required)"]
[null,"Notes and Comments:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wheat","CG",60,"0.75 - 2.0","L",1.25]
[]
[]
[null,"Producer Signature",null,null,null,null,"Date"]
[]
[null,"I certify that the above information ",null,"-","meet NRCS specifications for design and installation."]
[]
[]
[]
[null,"Conservationist Signature",null,null,null,null,"Date",null,null,null,null,null,"JAA"]

{"sheet":"Design LBS","index":1,"n_rows":112,"n_cols":36,"rows_kept":112,"cut":false,"hidden":false,"merged":[[12,2,12,27],[13,2,13,27],[14,0,17,27],[18,2,18,27],[6,2,6,5],[6,6,6,10],[6,11,6,14],[7,4,7,5],[7,7,7,8],[7,11,7,14],[1,1,1,14],[4,2,4,7],[4,8,4,10],[4,11,4,14],[5,2,5,7],[5,8,5,10],[5,11,5,14],[10,2,10,27],[11,2,11,27],[28,6,28,8],[28,9,28,12],[28,13,28,27],[19,0,23,27],[25,1,25,2],[25,3,25,5],[25,6,25,10],[25,11,25,14],[24,2,24,5],[24,6,24,7],[24,8,24,10],[24,12,24,27],[26,0,26,27],[27,1,27,27],[28,1,28,2],[28,3,28,5],[29,1,29,2],[29,3,29,5],[29,6,29,8],[29,9,29,12],[29,13,29,27],[30,1,30,2],[30,3,30,5],[30,6,30,8],[30,9,30,12],[30,13,30,27],[32,1,32,27],[33,1,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,6],[33,7,34,8],[33,9,34,10],[33,11,34,12],[33,13,34,14],[36,1,36,2],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[33,27,34,27],[35,1,35,2],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[38,1,38,2],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[37,1,37,2],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[40,1,40,2],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[39,1,39,2],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[42,1,42,2],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[41,1,41,2],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[44,1,44,2],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[43,1,43,2],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[46,1,46,2],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[45,1,45,2],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[48,1,48,2],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[47,1,47,2],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[50,1,50,2],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[49,1,49,2],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[52,1,52,2],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[51,1,51,2],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[54,1,54,2],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[53,1,53,2],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[58,1,60,27],[62,2,62,5],[62,8,62,10],[64,2,64,5],[64,8,64,10],[64,13,64,14],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,12,55,14],[56,1,56,3],[56,4,56,6],[72,1,72,14],[68,11,68,14],[69,2,69,3],[69,7,69,10],[69,11,69,14],[70,4,70,5],[70,7,70,8],[70,9,70,11],[70,12,70,14],[65,1,65,14],[66,17,69,17],[66,18,69,18],[66,19,69,19],[66,20,69,20],[67,2,67,7],[67,8,67,10],[67,11,67,14],[68,2,68,7],[68,8,68,10],[74,9,74,10],[73,1,73,2],[74,1,74,2],[74,11,74,27],[73,11,73,27],[85,9,85,10],[86,9,86,10],[80,13,80,27],[82,13,82,14],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[75,11,75,27],[75,9,75,10],[76,9,76,10],[77,9,77,10],[87,1,87,2],[88,1,88,2],[89,1,89,2],[82,11,82,12],[87,9,87,10],[88,9,88,10],[89,9,89,10],[80,11,80,12],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[109,6,110,10],[103,1,104,4],[109,1,110,4],[109,12,110,14],[90,4,90,5],[93,1,93,2],[92,1,92,27],[93,3,93,5],[93,6,93,8],[93,9,93,12],[93,13,93,27],[94,1,94,2],[94,3,94,5],[94,6,94,8],[94,9,94,12],[94,13,94,27],[95,1,95,2],[95,3,95,5],[95,6,95,8],[95,9,95,12],[95,13,95,27],[96,2,96,7],[107,1,107,2],[107,4,107,10],[97,1,97,2],[98,1,101,27],[97,11,97,27],[103,6,104,10],[31,2,31,5],[77,11,77,27],[78,11,78,27],[82,26,82,27],[84,11,84,12],[84,13,84,27],[86,11,86,27],[87,11,88,27],[90,9,90,10],[78,9,78,10],[79,9,79,10],[80,9,80,10],[81,9,81,10],[82,9,82,10],[83,9,83,10],[84,9,84,10],[73,9,73,10],[84,1,84,2],[85,1,85,2],[86,1,86,2]]}
[]
[null,"810 - Minnesota Annual Forages for Grazing Systems Design Worksheet"]
[null,"Note: Yellow areas indicate required data.  Blue areas indicate optional data."]
[]
[null,"Name:",null,null,null,null,null,null,"Program:"]
[null,"Address:",null,null,null,null,null,null,"Contract #:"]
[null,"Field No.:",null,null,null,null,"Contract Item No.:"]
[null,"Section:",null,"TWP:",null,null,"R:",null,null,null,"Acres:"]
[null,"Indicate the decision-maker's objective(s) for applying annual forages, in priority order (1, 2, 3,etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,"Provide or increase forage supply during periods of low forage production or to extend the grazing season."]
[null,null,"Provide temporary cover to reduce wind and water erosion and forage for sites where perennial forages will be re-established."]
[null,null,"Reduce excess nutrients from the soil."]
[null,null,"Improve soil microbial life and soil aggregate stability."]
[]
[]
[]
[]
[null,"Seeding Method:","-"]
[]
[]
[]
[]
[]
[null,"Seeding Window:",null,null,null,null,"Legume \nInoculant Needed:",null,"-",null,null,"Weed Control:","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starter & inoculant",null,"Broadcast/Incorporate",null,"Aug 15-Sep 20",null,"Harvest",null,"onions",0.5]
[]
[null,"Soil Amendments"]
[null,"N Fertilizer needed \n(lbs/acre)",null,"K2O Fertilizer needed (lbs/acre)",null,null,"P205  Fertilizer needed (lbs/acre)",null,null,"Other Nutrients needed (lbs/acre)",null,null,null,"Planned Time of Application"]
[]
[]
[null,"-","Soil test attached (Soil test required)"]
[null,"Planned Annual Forages Mixture"]
[null,"Annual Forage Species",null,"Full Seed Rate of PLS lb/ac","Acres","Percent of Full Rate of PLS",null,"Rate of PLS lb/ac",null,"Total PLS lbs",null,"Crop Type",null,"Seeding Depth (inches)",null,null,null,null,null,"CRP",null,null,null,null,null,null,null,"Seeds per Sq/Ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSP"]
[null,"-",null,{"$f":"VLOOKUP(B36,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B36=\"-\",\"\",L8)","v":""},{"$f":"IF(B36=\"-\",\"\",H36/D36)","v":""},null,null,null,{"$f":"IF(F36=\"\",\"\",E36*H36)","v":""},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,$Q$71:$V$103,6,FALSE))","v":{"$error":"#N/A"}},null,null,null,"CTA",null,null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",VLOOKUP(B36,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B36=\"-\",\"-\",(VLOOKUP(B36,Sheet1!$A$3:$G$47,7,FALSE))*H36/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B37,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B37=\"-\",\"\",L8)","v":""},{"$f":"IF(B37=\"-\",\"\",H37/D37)","v":""},null,null,null,{"$f":"IF(F37=\"\",\"\",E37*H37)","v":""},null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"ECP",null,null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",VLOOKUP(B37,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B37=\"-\",\"-\",(VLOOKUP(B37,Sheet1!$A$3:$G$47,7,FALSE))*H37/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B38,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B38=\"-\",\"\",L8)","v":""},"",null,null,null,{"$f":"IF(F38=\"\",\"\",E38*H38)","v":""},null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"EQIP",null,null,null,null,null,null,{"$f":"IF(B38=\"\",\"\",VLOOKUP(B38,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B38=\"-\",\"-\",(VLOOKUP(B38,Sheet1!$A$3:$G$47,7,FALSE))*H38/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B39,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B39=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"FRPP",null,null,null,null,null,null,{"$f":"IF(B39=\"\",\"\",VLOOKUP(B39,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B39=\"-\",\"-\",(VLOOKUP(B39,Sheet1!$A$3:$G$47,7,FALSE))*H39/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B40,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B40=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"GRP",null,null,null,null,null,null,{"$f":"IF(B40=\"\",\"\",VLOOKUP(B40,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B40=\"-\",\"-\",(VLOOKUP(B40,Sheet1!$A$3:$G$47,7,FALSE))*H40/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B41,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B41=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"SWCA",null,null,null,null,null,null,{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B41=\"-\",\"-\",(VLOOKUP(B41,Sheet1!$A$3:$G$47,7,FALSE))*H41/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B42,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B42=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"WHIP",null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B42=\"-\",\"-\",(VLOOKUP(B42,Sheet1!$A$3:$G$47,7,FALSE))*H42/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B43,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B43=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,"WRP",null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B43=\"-\",\"-\",(VLOOKUP(B43,Sheet1!$A$3:$G$47,7,FALSE))*H43/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B44,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B44=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",VLOOKUP(B44,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B44=\"-\",\"-\",(VLOOKUP(B44,Sheet1!$A$3:$G$47,7,FALSE))*H44/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B45,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B45=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B45=\"-\",\"-\",(VLOOKUP(B45,Sheet1!$A$3:$G$47,7,FALSE))*H45/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B46,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B46=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B46=\"-\",\"-\",(VLOOKUP(B46,Sheet1!$A$3:$G$47,7,FALSE))*H46/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B47,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B47=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B47=\"-\",\"-\",(VLOOKUP(B47,Sheet1!$A$3:$G$47,7,FALSE))*H47/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B48,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B48=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",VLOOKUP(B48,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B48=\"-\",\"-\",(VLOOKUP(B48,Sheet1!$A$3:$G$47,7,FALSE))*H48/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B49,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B49=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B49=\"-\",\"-\",(VLOOKUP(B49,Sheet1!$A$3:$G$47,7,FALSE))*H49/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B50,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B50=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B50=\"-\",\"-\",(VLOOKUP(B50,Sheet1!$A$3:$G$47,7,FALSE))*H50/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B51,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B51=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B51=\"-\",\"-\",(VLOOKUP(B51,Sheet1!$A$3:$G$47,7,FALSE))*H51/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B52,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B52=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B52=\"\",\"\",VLOOKUP(B52,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B52=\"-\",\"-\",(VLOOKUP(B52,Sheet1!$A$3:$G$47,7,FALSE))*H52/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B53,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B53=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B53=\"\",\"\",VLOOKUP(B53,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B53=\"-\",\"-\",(VLOOKUP(B53,Sheet1!$A$3:$G$47,7,FALSE))*H53/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B54,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B54=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",VLOOKUP(B54,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B54=\"-\",\"-\",(VLOOKUP(B54,Sheet1!$A$3:$G$47,7,FALSE))*H54/43560)","v":"-"}]
[null,"-",null,{"$f":"VLOOKUP(B55,Sheet1!A3:C47,3,FALSE)","v":"-"},{"$f":"IF(B55=\"-\",\"\",L8)","v":""},"",null,null,null,"",null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$F$47,5,FALSE))","v":"-"},null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$F$47,6,FALSE))","v":"-"},null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,$Q$71:$V$103,6,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B55=\"\",\"\",VLOOKUP(B55,Sheet1!$A$3:$J$47,10,FALSE))","v":0},{"$f":"IF(B55=\"-\",\"-\",(VLOOKUP(B55,Sheet1!$A$3:$G$47,7,FALSE))*H55/43560)","v":"-"}]
[null,null,null,null,null,{"$f":"SUM(F36:G55)","v":0},null,"Total lbs/PLS",null,{"$f":"SUM(J36:K55)","v":0},null,null,"Total Seeds per Sq/Ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB36:AB55)","v":0}]
[null,"Estimated PLS seeding rate (lbs/acre):",null,null,{"$f":"IF(L8=\"\",\"\",SUM(J56/L8))","v":""},null,null,null,null,null,null,null,null,"Planned Seeding Depth (inches):",{"$f":"IFERROR(AVERAGEIF(AA36:AA55,\">0\"),0)","v":0},{"$f":"IF(N36=\"\",\"\",SUM(P36:P55)/COUNTIF(P36:P55,\">0\"))","v":{"$error":"#N/A"}}]
[null,"Notes:"]
[]
[]
[]
[]
[null,"Planned By:",null,null,null,null,null,"Date:"]
[]
[null,"Approved By:",null,null,null,null,null,"Date:",null,null,null,null,"JAA:"]
[null,"Annual Forages Certification Worksheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crop Type*","Seeding rate, lbs/acre","Seeding depth, inches","Seed Size"]
[null,"Name:",{"$f":"IF(C5=\"\",\"\",C5)","v":""},null,null,null,null,null,"Program:",null,null,{"$f":"IF(L5=\"\",\"\",L5)","v":""}]
[null,"Address:",{"$f":"IF(C6=\"\",\"\",C6)","v":""},null,null,null,null,null,"Contract #:",null,null,{"$f":"IF(L6=\"\",\"\",L6)","v":""},null,null,null,null,"Species"]
[null,"Site location:",{"$f":"IF(C7=\"\",\"\",C7)","v":""},null,null,null,null,"Contract Item #:",null,null,null,{"$f":"IF(L7=\"\",\"\",L7)","v":""}]
[null,"Section:",{"$f":"IF(C8=\"\",\"\",C8)","v":""},"TWP:",{"$f":"IF(E8=\"\",\"\",E8)","v":""},null,"R:",{"$f":"IF(H8=\"\",\"\",H8)","v":""},null,"Acres Planted:",null,null,null,null,null,null,"alfalfa","CB",10,"0.25 - 0.75","F",0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"barley","CG",50,"0.75 - 2","L",1.25]
[null,"Instructions: Document producer's actual forages planting information below.  Attach or include photos of the forages to this Job Sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"buckwheat","WB",48,"0.5 - 1.5","F",1]
[null,"Species ",null,"Total Pounds Planted","% \nGerm","%\n Purity","Total PLS # Planted","PLS\nLB/AC","% of Full Rate","Seeds/ \nSq Ft",null,"Practice Check Out Conditions"]
[null,{"$f":"IF(B36=\"\",\"\",B36)","v":"-"},null,null,null,null,{"$f":"IF(B75=\"-\",\"\",(D75*E75*F75))","v":""},{"$f":"IF(B75=\"-\",\"\",(G75/$M$71))","v":""},{"$f":"IF(B75=\"-\",\"\",(H75/(IF($AJ$9=1,VLOOKUP(B75,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B75,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B75,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B75=\"-\",\"\",(VLOOKUP(B75,Sheet1!$A$3:$G$47,7,FALSE))*H75/43560)","v":""},null,"Site Preparation:"]
[null,{"$f":"IF(B37=\"\",\"\",B37)","v":"-"},null,null,null,null,{"$f":"IF(B76=\"-\",\"\",(D76*E76*F76))","v":""},{"$f":"IF(B76=\"-\",\"\",(G76/$M$71))","v":""},{"$f":"IF(B76=\"-\",\"\",(H76/(IF($AJ$9=1,VLOOKUP(B76,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B76,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B76,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B76=\"-\",\"\",(VLOOKUP(B76,Sheet1!$A$3:$G$47,7,FALSE))*H76/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B77=\"-\",\"\",(H77/(IF($AJ$9=1,VLOOKUP(B77,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B77,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B77,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B77=\"-\",\"\",(VLOOKUP(B77,Sheet1!$A$3:$G$47,7,FALSE))*H77/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B78=\"-\",\"\",(H78/(IF($AJ$9=1,VLOOKUP(B78,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B78,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B78,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B78=\"-\",\"\",(VLOOKUP(B78,Sheet1!$A$3:$G$47,7,FALSE))*H78/43560)","v":""},null,"Planting Method:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B79=\"-\",\"\",(H79/(IF($AJ$9=1,VLOOKUP(B79,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B79,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B79,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B79=\"-\",\"\",(VLOOKUP(B79,Sheet1!$A$3:$G$47,7,FALSE))*H79/43560)","v":""},null,"-"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B80=\"-\",\"\",(H80/(IF($AJ$9=1,VLOOKUP(B80,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B80,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B80,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B80=\"-\",\"\",(VLOOKUP(B80,Sheet1!$A$3:$G$47,7,FALSE))*H80/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B81=\"-\",\"\",(H81/(IF($AJ$9=1,VLOOKUP(B81,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B81,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B81,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B81=\"-\",\"\",(VLOOKUP(B81,Sheet1!$A$3:$G$47,7,FALSE))*H81/43560)","v":""},null,"Date Planted:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B82=\"-\",\"\",(H82/(IF($AJ$9=1,VLOOKUP(B82,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B82,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B82,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B82=\"-\",\"\",(VLOOKUP(B82,Sheet1!$A$3:$G$47,7,FALSE))*H82/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B83=\"-\",\"\",(H83/(IF($AJ$9=1,VLOOKUP(B83,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B83,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B83,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B83=\"-\",\"\",(VLOOKUP(B83,Sheet1!$A$3:$G$47,7,FALSE))*H83/43560)","v":""},null,"Planting Depth:",null,null,null,null,"flax","CB",35,"0.25 - 0.75","F",0.5,null,null,null,null,"Inches"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B84=\"-\",\"\",(H84/(IF($AJ$9=1,VLOOKUP(B84,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B84,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B84,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B84=\"-\",\"\",(VLOOKUP(B84,Sheet1!$A$3:$G$47,7,FALSE))*H84/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B85=\"-\",\"\",(H85/(IF($AJ$9=1,VLOOKUP(B85,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B85,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B85,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B85=\"-\",\"\",(VLOOKUP(B85,Sheet1!$A$3:$G$47,7,FALSE))*H85/43560)","v":""},null,"Weed Control:",null,"-"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B86=\"-\",\"\",(H86/(IF($AJ$9=1,VLOOKUP(B86,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B86,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B86,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B86=\"-\",\"\",(VLOOKUP(B86,Sheet1!$A$3:$G$47,7,FALSE))*H86/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B87=\"-\",\"\",(H87/(IF($AJ$9=1,VLOOKUP(B87,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B87,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B87,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B87=\"-\",\"\",(VLOOKUP(B87,Sheet1!$A$3:$G$47,7,FALSE))*H87/43560)","v":""},null,"Legume Inoculant:"]
[null,"-",null,null,null,null,"","",{"$f":"IF(B88=\"-\",\"\",(H88/(IF($AJ$9=1,VLOOKUP(B88,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B88,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B88,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B88=\"-\",\"\",(VLOOKUP(B88,Sheet1!$A$3:$G$47,7,FALSE))*H88/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B89=\"-\",\"\",(H89/(IF($AJ$9=1,VLOOKUP(B89,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B89,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B89,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B89=\"-\",\"\",(VLOOKUP(B89,Sheet1!$A$3:$G$47,7,FALSE))*H89/43560)","v":""}]
[null,"-",null,null,null,null,"","",{"$f":"IF(B90=\"-\",\"\",(H90/(IF($AJ$9=1,VLOOKUP(B90,Sheet1!$A$3:$D$47,3,FALSE),IF($AJ$9=2,VLOOKUP(B90,Sheet1!$A$3:$D$47,4,FALSE),VLOOKUP(B90,Sheet1!$A$3:$D$47,4,FALSE))))))","v":""},{"$f":"IF(B90=\"-\",\"\",(VLOOKUP(B90,Sheet1!$A$3:$G$47,7,FALSE))*H90/43560)","v":""}]
[null,null,null,null,null,null,"Totals:",{"$f":"SUM(H75:H90)","v":0},{"$f":"SUM(I75:I90)","v":0},{"$f":"SUM(J75:K90)","v":0}]
[]
[null,"Soil Amendments Applied"]
[null,"N Fertilizer applied \n(lbs/acre)",null,"K2O Fertilizer applied (lbs/acre)",null,null,"P205  Fertilizer applied (lbs/acre)",null,null,"Other Nutrients applied (lbs/acre)",null,null,null,"Application Date"]
[]
[]
[null,"-","Fertilizer application record attached (Required)"]
[null,"Notes and Comments:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wheat","CG",60,"0.75 - 2.0","L",1.25]
[]
[]
[null,"Producer Signature",null,null,null,null,"Date"]
[]
[null,"I certify that the above information ",null,"-","meet NRCS specifications for design and installation."]
[]
[]
[]
[null,"Conservationist Signature",null,null,null,null,"Date",null,null,null,null,null,"JAA"]

{"sheet":"Sheet1","index":2,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[[54,0,54,11],[0,0,0,11],[49,0,49,11],[50,0,50,11],[51,0,51,11],[52,0,52,11],[53,0,53,11]]}
[]
["DESIGN TOOL Crops","Crops","1Minimum Seeding Rate in lbs./ac PLS (Incorporated Seed)","2Minimum Seeding Rate in lbs./ac PLS                                          (Non-Incorporated Seed)","Crop Type","Seeding Depth","seeds per pound","Seeds per sq/ft (Incorporated)","Seeds per sq/ft (Non-Incorporated)",null,"North I-94","South I-94"]
["-",null,"-","-","-","-",0,"-","-",0]
["Barley, Spring","Barley, Spring*",90,75,"CG","0.75 - 1.5",13599,{"$f":"(C4*G4)/43560","v":28.097107438016529},{"$f":"(D4*G4)/43560","v":23.414256198347108},1.125,"April 15 - August 15","April 1-June 15 and July 15-September 1 "]
["Barley, Winter","Barley, Winter",90,75,"CG","0.75 - 1.5",13600,28.099173553719009,23.415977961432507,1.125,"August 15-October 1","August 15-October 15 "]
["Buckwheat ","Buckwheat 1/ 3",25,68,"WB","0.50 - 1",20400,11.707988980716253,31.84573002754821,0.75,"June 15-August 15","June 1-September 1"]
["Cabbage","Cabbage",3,8,"CB","0.25 - 0.5",180000,12.396694214876034,33.057851239669418,0.375,"April 15-September 1","April 1-September 1"]
["Chickpea","Chickpea",80,120,"CB","0.25 - 0.5",2200,4.0404040404040407,6.0606060606060606,0.375,"June 1-September 1","May 15-September 1"]
["Clover, Balansa","Clover, Balansa",5,8,"CB","0.25 - 0.5",500000,57.392102846648299,91.827364554637285,0.375,"May 15-September 1","May 1-September 1"]
["Clover, Berseem","Clover, Berseem",8,12,"CB","0.25 - 0.5",206880,37.994490358126718,56.991735537190081,0.375,"May 15-September 1","May 1-September 1"]
["Clover, Crimson","Clover, Crimson",15,15,"CB","0.25 - 0.5",149760,51.570247933884296,51.570247933884296,0.375,"May 15-September 1","May 1-September 1"]
["Clover, Red","Clover, Red",10,12,"CB","0.25 - 0.5",272160,62.47933884297521,74.975206611570243,0.375,"April 15-August 15 ","April 1-August 15 "]
["Clover, White","Clover, White",4,8,"CB","0.25 - 0.5",784000,71.992653810835634,143.98530762167127,0.375,"April 15-August 15","April 1-August 15 "]
["Forage Collards","Cowpeas 3",3,5,"CB","0.25 - 0.5",175000,12.052341597796143,20.087235996326907,0.375,"April 20-September 1 ","April 15-September 1 "]
["Corn","Cowpeas 3",30,45,"WB","2.0-3.0",2450,1.6873278236914599,2.53099173553719,2.5,"May 15-August 1","May 1 -August 1"]
["Cowpeas","Cowpeas 3",45,45,"WB","1 - 1.5",3600,3.71900826446281,3.71900826446281,1.25,"June 1-August 15","May 15-September 1"]
["Fava Bean","Fava Bean",80,120,"CB","2 - 4",2500,4.5913682277318637,6.887052341597796,3,"June 15-August 15","June 1-September 1"]
["Kale","Kale",3,5,"CB","0.25 - 0.5",175000,12.052341597796143,20.087235996326907,0.375,"April 15-September 15","April 1-October 1"]
["Lentils","Lentils",40,75,"CB","1 - 1.5",15000,13.774104683195592,25.826446280991735,1.25,"April 15-September 15","April 1-October 1"]
["Millet, Foxtail","Millet, Foxtail 3",20,30,"WG","0.5 - 1",220000,101.01010101010101,151.5151515151515,0.75,"June 1-August 1","May 15-August 1"]
["Millet, Japanese","Millet, Japanese 3",20,30,"WG","0.5 - 0.75",142880,65.601469237832873,98.40220385674931,0.625,"June 1-August 1","May 15-August 1"]
["Millet, Pearl","Millet, Pearl 3",20,30,"WG","0.5 - 1",82320,37.796143250688708,56.694214876033058,0.75,"June 1-August 1","May 15-August 1"]
["Millet, Proso","Millet, Proso 3",20,30,"WG","0.5 - 1",80000,36.73094582185491,55.096418732782368,0.75,"June 1-August 1","May 15-August 1"]
["Mustard","Mustard, Yellow 3",5,6,"CB","0.25 - 0.75",180000,20.66115702479339,24.793388429752067,0.5,"April 15-September 1","April 1-September 1"]
["Non GMO Beets","Non GMO Beets",4,5,"CB","0.25 - 0.5",10000,0.91827364554637281,1.1478420569329659,0.375,"April 15-September 15","April 1-September 1"]
["Oats","Oats*",90,45,"CG","0.5 - 1",19600,40.495867768595041,20.24793388429752,0.75,"April 15-June 15 and July 15-August 15 ","April 1-June 15 and July 15-September 1 "]
["Pea, Field/Winter","Pea, Field/Winter 3",50,45,"CB","1 - 1.5",5000,5.7392102846648303,5.1652892561983474,1.25,"April 15-September 15","April 1-October 1"]
["Phacelia","Phacelia",6,8,"CB","0.12 - 0.25",235000,32.369146005509641,43.158861340679522,0.185,"April 15-August 15","April 1-September 1"]
["Radish","Radish, Oilseed or Forage",5,6,"CB","0.5 - 0.75",34000,3.9026629935720845,4.6831955922865012,0.625,"June 25-September 1 ","June 25-September 1 "]
["Rapeseed/Canola","Rapeseed/Canola",3,3,"CB","0.25 - 0.5",156960,10.809917355371901,10.809917355371901,0.375,"April 20-September 1 ","April 15-September 1 "]
["Rye, Winter Cereal","Rye, Winter Cereal",90,83,"CG","0.75 - 1.5",18160,37.52066115702479,34.602387511478419,1.125,"July 15-October 15","July 15-October 15"]
["Ryegrass, Annual","Ryegrass, Annual",20,23,"CG","0 - 0.5",190280,87.364554637281913,100.4692378328742,0.25,"April 15-June 15 and July 15-August 15 ","April 1-June 15 and July 15-September 1 "]
["Safflower","Safflower",30,38,"WB","1 - 1.5",15000,10.330578512396695,13.085399449035812,1.25,"April 15-August 1","April 15-August 1"]
["Sainfoin","Sainfoin",40,60,"CB","0.25 - 0.75",18500,16.988062442607898,25.482093663911847,0.5,"April 15- September 1","April 1-September 1"]
["Sorghum","Sorghum-Sudangrass 3",28,38,"WG","0.5 - 1.5",14000,8.9990817263544542,12.213039485766759,1,"June 1-August 1","May 15-August 1"]
["Sorghum-Sudangrass","Sorghum-Sudangrass 3",28,38,"WG","0.5 - 1.5",17280,11.107438016528926,15.074380165289256,1,"June 1-August 1","May 15-August 1"]
["Soybean","Soybean 3",40,45,"WB","0.5 - 1",3000,2.7548209366391183,3.0991735537190084,0.75,"June 15-August 15","June 1-September1"]
["Sudangrass","Sudangrass 3",28,38,"WG","0.5 - 1",42240,27.151515151515152,36.848484848484851,0.75,"June 1-August 1","May 15-August 1"]
["Sunflower","Sunflower",4,2,"WB","1 - 3.5",8000,0.7346189164370982,0.3673094582185491,2.25,"June 1-August 1","June 1-August 1"]
["Sunnhemp","Sunnhemp",20,30,"WB","0.5 - 2.5",15000,6.887052341597796,10.330578512396695,1.5,"June 1-August 1","June 1-August 1"]
["Teff","Triticale, Winter",8,12,"WG",0.25,1300000,238.75114784205692,358.12672176308541,0.25,"June 1-August 1","May 15-August 1"]
["Triticale, Spring",null,90,75,"CG","0.75 - 1.5",15000,30.991735537190081,25.826446280991735,1.125,"April 15-June 15 and July 15-August 15 ","April 1-June 15 and July 15-September 1 "]
["Triticale, Winter","Triticale, Winter",90,75,"CG","0.75 - 1.5",16000,33.057851239669418,27.548209366391184,1.125,"July 15-October 15","July 15-October 15"]
["Turnip","Turnip",3,2,"CB","0.25 - 0.5",192800,13.278236914600551,8.8521579430670343,0.375,"April 15-September 1 ","April 1-September 1"]
["Vetch","Vetch, Hairy",20,23,"CB","0.5 - 1.5",16320,7.4931129476584024,8.6170798898071617,1,"April 15-August 15","April 1-August 15 "]
["Wheat, Spring","Wheat, Spring*",90,75,"CG","0.75 - 1.5",11360,23.471074380165291,19.55922865013774,1.125,"April 15-June 15 and July 15-August 15 ","April 1-June 15 and July 15-September 1 "]
["Wheat, Winter","Wheat, Winter",90,75,"CG","0.75 - 1.5",11360,23.471074380165291,19.55922865013774,1.125,"July 15-October 15","July 15-October 15"]
[]
[]
["LEGEND"]
["CROP TYPE: CG=COOL SEASON GRASS, CB= COOL SEASON BROADLEAF, WG=WARM SEASON GRASS, WB=WARM SEASON BROADLEAF"]
["1 Incorporated seed--Seeding methods used that provide good seed to soil contact"]
["2 Non-incorporated seed--Seeding methods used when broadcasting seed without mechanical incorporation"]
["1/ Plantings containing buckwheat may not be seeded within 30 feet of an existing commodity wheat field, or in a field with a planned rotation to commodity wheat within two years."]
["ALL INFORMATION FROM MIDWEST COVER CROPS COUNCIL WEBSITE http://www.mccc.msu.edu/index.htm "]
[]
[]
["Option",null,"Planting Method","Weed Control",null,"Programs","Termination","Planting method abbr"]
["-",null,"-","-",null,319,"-","-"]
["Yes",null,"Drilled into prepared seedbed:  Seedbed should be tilled and clean of all vegetation and weeds, packed and firm enough to make a ½” or less boot imprint.","Chemical",null,"ALE","Herbicide","Drilled into prepared seedbed"]
["No",null,"No-till drill into crop residue or dead sod:  Seedbed preparation will vary from site to site.  The most common seedbed preparation method includes herbicide application to kill existing sod or weeds.","Mechanical",null,"CRP","Mechanical","No-till drill into crop residue or dead sod"]
["N/A",null,"Broadcast with Incorporation:  Seedbed should be tilled and clean of all vegetation and weeds, packed and firm enough to make a ½” or less boot imprint.  Roll/pack or harrow following application to ensure proper seed to soil contact.  ","Mechanical & Chemical",null,"CSP","Winter Kill","Broadcast with Incorporation"]
[null,null,null,null,null,"CTA"]
[null,null,null,null,null,"ECP"]
["-",null,null,null,null,"EQIP"]
["does",null,null,null,null,"FRPP"]
["does not",null,null,null,null,"WRE"]

{"sheet":"Table 1 - Seeding Rates","index":3,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,0,57,5],[36,0,36,5],[51,0,51,5],[52,0,52,5],[53,0,53,5],[54,0,54,5],[55,0,55,5],[56,0,56,5],[0,3,1,3],[0,4,0,5],[2,0,2,5],[21,0,21,5],[34,3,35,3],[34,4,34,5]]}
[null," FULL SEEDING RATES",null,"CROP TYPE","SEEDING DATES "]
["SPECIES","1Minimum Seeding Rate in lbs./ac PLS (Incorporated Seed)","PLANTING DEPTH     (inches)",null,"NORTH OF INTERSTATE 94","SOUTH OF INTERSTATE 94"]
["GRASSES"]
["SPRING BARLEY","90 lbs/acre PLS","0.75-1.5","CG","April 15-June 15 and \nJuly 15-August 15 ","April 1-June 15 and \nJuly 15-September 1 "]
["WINTER BARLEY","90 lbs/acre PLS","0.75-1.5","CG","August 15-October 1 ","August 15-October 15 "]
["OATS","90 lbs/acre PLS","0.5-1","CG","April 15-June 15 and \nJuly 15-August 15 ","April 1-June 15 and \nJuly 15-September 1 "]
["ANNUAL RYEGRASS","20 lbs/acre PLS","0-0.5","CG","April 15-June 15 and \nJuly 15-August 15 ","April 1-June 15 and \nJuly 15-September 1 "]
["WINTER CEREAL RYE","90 lbs/acre PLS","0.75-1.5","CG","July 15-October 15","July 15-October 15"]
["SPRING TRITICALE","90 lbs/acre PLS","0.75-1.5","CG","April 15-June 15 and \nJuly 15-August 15 ","April 1-June 15 and \nJuly 15-September 1 "]
["WINTER TRITICALE","90 lbs/acre PLS","0.75-1.5","CG","July 15-October 15","July 15-October 15"]
["SPRING WHEAT","90 lbs/acre PLS","0.75-1.5","CG","April 15-June 15 and \nJuly 15-August 15 ","April 1-June 15 and \nJuly 15-September 1 "]
["WINTER WHEAT","90 lbs/acre PLS","0.75-1.5","CG","July 15-October 15","July 15-October 15"]
["CORN 3","30 lbs/acre PLS","2.0-3.0","WG","May 15-August 1","May 1-August 1"]
["FOXTAIL MILLET ","20 lbs/acre PLS","0.5-1","WG","June 1-August 1","May 15-August 1"]
["JAPANESE MILLET ","20 lbs/acre PLS","0.5-0.75","WG","June 1-August 1","May 15-August 1"]
["PEARL MILLET ","20 lbs/acre PLS","0.5-1","WG","June 1-August 1","May 15-August 1"]
["PROSO MILLET ","20 lbs/acre PLS","0.5-1","WG","June 1-August 1","May 15-August 1"]
["SORGHUM","28 lbs/acre PLS","0.5-1.5","WG","June 1-August 1","May 15-August 1"]
["SORGHUM-SUDANGRASS ","28 lbs/acre PLS","0.5-1.5","WG","June 1-August 1","May 15-August 1"]
["SUDANGRASS ","28 lbs/acre PLS","0.5-1","WG","June 1-August 1","May 15-August 1"]
["TEFF","8 lbs/acre PLS",0.25,"WG","June 1-August 1","May 15-August 1"]
["NON-LEGUME BROADLEAVES 1"]
["BEETS (Non GMO)","4 lbs/acre PLS","0.25-0.5","CB","April 15-September 15","April 1-September 1"]
["CABBAGE","3 lbs/acre PLS","0.25-0.5","CB","April 15-September 1","April 1-September 1"]
["KALE","3 lbs/acre PLS","0.25-0.5","CB","April 15-September 15","April 1-October 1"]
["FORAGE COLLARDS","3 lbs/acre PLS","0.25-0.5","CB","April 20-September 1 ","April 15-September 1 "]
["MUSTARD ","5 lbs/acre PLS","0.25-0.75","CB","April 15-September 1","April 1-September 1"]
["PHACELIA","6 lbs/acre PLS","0.12-0.25","CB","April 15-August 15","April 1-September 1"]
["RADISH ","5 lbs/acre PLS","0.5-0.75","CB","June 25-September 1 ","June 25-September 1 "]
["RAPESEED/CANOLA","3 lbs/acre PLS","0.25-0.5","CB","April 20-September 1 ","April 15-September 1 "]
["TURNIP","3 lb/acre PLS","0.25-0.5","CB","April 15-September 1 ","April 1-September 1"]
["BUCKWHEAT 2","25 lbs/acre PLS","0.5-1","WB","June 15-August 15","June 1-September 1"]
["SAFFLOWER","30 lbs/acre PLS","1-1.5","WB","April 15-August 1","April 15-August 1"]
["SUNFLOWER","4 lb/acre PLS","1-3.5","WB","June 1-August 1","June 1-August 1"]
[null," FULL SEEDING RATES",null,"CROP TYPE","SEEDING DATES "]
["SPECIES","1Minimum Seeding Rate in lbs./ac PLS (Incorporated Seed)","PLANTING DEPTH     (inches)",null,"NORTH OF INTERSTATE 94","SOUTH OF INTERSTATE 94"]
["LEGUMES 1"]
["CHICKPEA","80 lbs/acre PLS","0.25-0.5","CB","June 1-September 1","May 15-September 1"]
["BALANSA CLOVER","5 lbs/acre PLS","0.25-0.5","CB","May 15-September 1","May 1-September 1"]
["BERSEEM CLOVER","8 lbs/acre PLS","0.25-0.5","CB","May 15-September 1","May 1-September 1"]
["CRIMSON CLOVER","15 lbs/acre PLS","0.25-0.5","CB","May 15-September 1","May 1-September 1"]
["RED CLOVER","10 lbs/acre PLS","0.25-0.5","CB","April 15-August 15 ","April 1-August 15 "]
["WHITE CLOVER","4 lbs/acre PLS","0.25-0.5","CB","April 15-August 15","April 1-August 15 "]
["FAVA BEAN","80 lbs/acre PLS","2-4","CB","June 15-August 15","June 1-September 1"]
["FIELD/WINTER PEA ","50 lbs/acre PLS","1-1.5","CB","April 15-September 15","April 1-October 1"]
["LENTILS","40 lbs/acre PLS","1-1.5","CB","April 15-September 15","April 1-October 1"]
["SAINFOIN","40 lbs/acre PLS","0.25-0.75","CB","April 15- September 1","April 1-September 1"]
["VETCH","20 lbs/acre PLS","0.5-1.5","CB","April 15-August 15","April 1-August 15 "]
["COWPEA ","45 lbs/acre PLS","1-1.5","WB","June 1-August 15","May 15-September 1"]
["SOYBEANS ","40 lbs/acre PLS","0.5-1","WB","June 15-August 15","June 1-September1"]
["SUNNHEMP","20 lbs/acre PLS","0.5-2.5","WB","June 1-August 1","June 1-August 1"]
["LEGEND"]
["CROP TYPE: CG=COOL SEASON GRASS, CB= COOL SEASON BROADLEAF, WG=WARM SEASON GRASS, WB=WARM SEASON BROADLEAF"]
["1 Incorporated seed--Seeding methods used that provide good seed to soil contact.  PLS=Pure Live Seed"]
["1 All Non-Legume Broadleaves and Legume species should always be considered as part of a multi-species annual forage and rarely planted as a single species"]
["2 Plantings containing buckwheat may not be seeded within 30 feet of an existing commodity wheat field, or in a field with a planned rotation to commodity wheat within two years."]
["3 These species are to be used for grazing only."]
["INFORMATION from Midwest Cover Crops Council (MCCC) Website, MCCC Cover Crop Field Guide, Green Cover Seed, SARE-Managing Cover Crops Profitably, SARE-Cover Cropping for Pollinators and Beneficial Insects, USDA-ARS Cover Crops Chart, USDA-NRCS PLANTS Guide"]

{"sheet":"Table 2-Characteristics-OLD","index":4,"n_rows":75,"n_cols":25,"rows_kept":75,"cut":false,"hidden":true,"merged":[[70,0,70,24],[74,1,74,24],[59,0,59,24],[67,0,67,24],[68,1,68,7],[68,8,68,17],[68,18,68,19],[68,20,68,23],[48,0,48,24],[51,0,51,24],[56,0,56,24],[57,1,57,7],[57,8,57,17],[57,18,57,19],[57,20,57,23],[38,0,38,24],[45,0,45,24],[46,1,46,7],[46,8,46,17],[46,18,46,19],[46,20,46,23],[26,0,26,24],[30,0,30,24],[34,0,34,24],[35,1,35,7],[35,8,35,17],[35,18,35,19],[35,20,35,23],[15,0,15,24],[23,0,23,24],[24,1,24,7],[24,8,24,17],[24,18,24,19],[24,20,24,23],[4,0,4,24],[12,0,12,24],[13,1,13,7],[13,8,13,17],[13,18,13,19],[13,20,13,23],[0,0,0,24],[1,0,1,24],[2,1,2,7],[2,8,2,17],[2,18,2,19],[2,20,2,23]]}
["Identification and Comparison of Cover Crop Performance and Benefits by Species"]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles I",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["GRASSES"]
["SPRING BARLEY",0,0,"2000-5000 ",3,3,2,"Never",2,2,1,2,2,"Cool Season, Annual","Upright","6-8","Low",2,2,2,"20:1","hay 10-15%, Grain 11-15%",13600,35,"If small grains are planted too early  in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)  Self Pollinator (wind).  "]
["WINTER BARLEY",0,0,"2000-10,000",3,3,2,"Seldom",2,2,1,2,"N/A","Cool Season, Annual","Upright","6-8","N/A",3,2,2,"20:1",0.12,13600,35,"Tolerates moderately alkaline conditions but does poorly in acid soils of less than 6 pH.   If small grains are planted too early in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)."]
["OATS",0,0,"2000-6000",4,4,3,"Never",2,2,2,2,1,"Cool Season, Annual","Upright","4.5-7","Medium",3,0,3,"33:1","Hay 9-15%, Grain 13-18%",19600,38,"Prone to lodging in N rich soil. Self Pollinator (wind).  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.   Host for Penetrans Root-Lesion Nematode.  Slow to release Nitrogen to following crop unless growth terminated in mid-vegetative stage (12-18 in). "]
["ANNUAL RYEGRASS",0,0,"1000-6000",3,4,3,"Seldom",1,1,3,3,"N/A","Cool Season, Annual","Upright","5.5-7","N/A",2,1,3,"20:1-31:1",0.09,190280,40,"Heavy Nitrogen and water user.  Cutting boosts dry matter significantly.  Not advised for wheat rotations.  May take two applications to chemically terminate.  Must be killed before it joints.  Host for Penetrans Root-Lesion Nematode."]
["WINTER CEREAL RYE",0,0,"2500-6000",4,4,3,"Expected",2,3,2,3,2,"Cool Season, Annual","Upright","5-7","High",3,1,3,"14:1 young 40:1 boot","Straw 4%, Grain 14%",18160,34,"Kill 1.5-2 weeks before planting corn.  Not recommended before corn due to allelopathy.  Corn seed maggot/armyworm, cutworm  could be issues.  Tolerates triazine herbicides.  Self Pollinator (wind).  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.   Host for Penetrans Root-Lesion Nematode."]
["WINTER TRITICALE",0,0,"2000-5000",3,4,3,"Expected",2,2,2,2,2,"Cool Season, Annual","Upright","5.2-7","High",2,1,3,"20:1","Hay 9-16%, Grain-17%",22700,38,"Self Pollinator (wind).  Non-host for sugarbeet cyst nematode, soybean cyst nematode, and root knot nematode.  Host for Penetrans Root-Lesion Nematode."]
["SPRING WHEAT",0,0,"1200-3000",3,3,3,"Never",2,2,2,2,2,"Cool Season, Annual","Upright","6-7","Medium",2,1,3,"15-95:1","Straw 4-10%, Grain 12-16%",11360,38,"Heavy Nitrogen and water user in spring. Absorbs Nitrogen and Water heavily during stem growth, so kill before then.  Carbon: Nitrogen Ratio--Leaf 15-29, Stem 31-65, Root 24-74, Straw 80-95 (end of season).  Self Pollinator (wind).  Southern MN has Hessian Fly-free planting dates to be heeded.   Host for Penetrans Root-Lesion Nematode."]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["GRASSES (continued)"]
["WINTER WHEAT",0,0,"2000-5000",3,4,3,"Expected",2,2,2,2,"N/A","Cool Season, Annual","Upright","6-7","N/A",2,1,3,"20:1",0.09,11360,38,"Kill 1.5-2 weeks before planting corn.  Corn seed maggot, armyworm, and cutworm could be insect issues.  Heavy Nitrogen and water user in spring.  Southern MN has Hessian Fly-free planting dates to be heeded.  Non-host for sugarbeet nematode, soybean cyst nematode, and root knot nematode.  Wheat curl mite can spread wheat streak mosaic virus.  Use 2 weeks of broken green bridge to break the pest cycle (cover crops can harbor the pest, allowing transfer from spring to winter crops).  If small grains are planted too early in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)."]
["CORN",0,0,"1000-12000",4,3,2,"Never",4,2,3,1,1,"Warm Season, Annual","Upright","5.5-7.5","High",1,"NA","NA","57:1","6.5-8.5%",2450,50]
["FOXTAIL MILLET",0,0,"4000-8000",4,2,2,"Never",4,4,1,1,0,"Warm Season, Annual","Upright","5.5-7","Low",3,1,3,"44:1",0.15,220000,65,"Self Pollinator (wind).  Do not feed to horses as it may have a laxative effect."]
["JAPANESE MILLET",0,0,"1500-3500",4,3,2,"Never",4,4,1,1,"N/A","Warm Season, Annual","Upright","4.6-7","N/A",3,1,3,"42:1",0.16,142880,65,"Does not germinate or thrive in cold soil.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  Host for Penetrans Root-Lesion Nematode"]
["PEARL MILLET",0,0,"2000-6000",4,4,2,"Never",4,4,1,1,0,"Warm Season, Annual","Upright","5.5-7","Low",3,1,3,"50:1",0.13,82320,65,"Self Pollinator (wind).  Slower to establish than sudan or sorghum-sudangrass.  Does not germinate or thrive in cold soil.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  It is the best known cover crop for reduction of population densities of Penetrans Root-Lesion Nematode, but this can be variety specific.  "]
["PROSO MILLET",0,0,"2000-4000",4,3,2,"Never",4,4,2,2,0,"Warm Season, Annual","Upright","5.5-7","Medium",3,1,3,"12-35:1",0.1,80000,65,"Carbon: Nitrogen Ratio--Leaf 12-16, Stem 12-35, Root 17-26.  Self Pollinators (wind).  "]
["SORGHUM",0,0,"3000-8000",4,3,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,3,"10-30:1","5-10%",14000,65,"Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Don't graze until it's 24\" tall and for 2 weeks after a killing frost-prussic acid  Be wary of prussic acid toxicity if using for forage/grazing.  "]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["GRASSES (continued)"]
["SORGHUM-SUDANGRASS",0,0,"3000-8000",4,3,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,3,"10-30:1","Hay 7%, Stover 5%, Grain 10%",17280,65,"Alternate Name Grain Sorghum.  Carbon: Nitrogen Ratio--Leaf 11-17, Stem 10-27, Root 22-30.  Self Pollinator (wind).  Mature, frost-killed plants become quite woody.  Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Don't graze until it's 24\" tall and for 2 weeks after a killing frost-prussic acid  Be wary of prussic acid toxicity if using for forage/grazing.  Mid-season cutting increase yield and root penetration.  Has been used in tree fruit, small fruit and vegetable production systems since the middle 1960s for management of Penetrans Root-Lesion Nematode and root knot nematode.  Non-host for soybean cyst nematode and sugarbeet cyst nematode.  "]
["SUDANGRASS",0,0,"3000-8000",4,4,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,3,"48-63:1","Hay 7-11%, Silage 6-17%",42240,65,"Self Pollinator (wind).  Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Be wary of prussic acid toxicity if using for forage/grazing.  Drought stressed plants can cause nitrate poisoning.  Known allelopathic effects on annual ryegrass.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  Host for Penetrans Root-Lesion Nematode."]
["TEFF",0,0,"2,000-8000",4,4,4,"Never",4,4,1,2,2,"Warm Season, Annual","Upright","5.0-7.0","Medium",2,"NA","NA","20:1",0.18,1300000,65]
["NON-LEGUME BROADLEAVES"]
["BEETS ",1,"N/A","N/A",4,4,3,"N/A",1,2,3,3,1,"Cool Season, Biennial ","Upright and Spreading","N/A","High",1,"N/A",4,"Tops 11-14:1","Tops 12-15%, Root 7-10%","N/A",40,"Self Pollinator (wind)"]
["CABBAGE",1,"N/A","N/A",3,4,3,"N/A",3,2,3,4,"N/A","Cool Season, Annual","Upright and Spreading","N/A","N/A",1,"N/A",1,"12-30:1","N/A","N/A",42]
["FORAGE COLLARDS",0,"N/A","N/A",3,4,3,"N/A",4,4,3,2,2,"Cool Season, Annual","Upright and Spreading","N/A","N/A",2,"N/A",1,"12-30:1","N/A",175000,42]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["KALE",0,"N/A","N/A","N/A",4,"N/A","Seldom","N/A","N/A","N/A",0,1,"Cool Season, Annual","Upright and Spreading","N/A","Medium","N/A","N/A","N/A","10-30:1",0.3,"N/A",45,"Introduce slowly to livestock because it is highly digestible.  Should never be more than 35% of diet.  Likes seed to soil contact so incorporated seeding at a shallow depth is best."]
["NON-LEGUME BROADLEAVES (continued)"]
["MUSTARD",0,"30-100","1200-3000",3,0,0,"Never",2,2,1,1,0,"Cool Season, Annual","Upright","5.5-8","Low",2,3,1,"10-30:1","Hay 10%, Grain 24-35%",180000,40,"Host soybean cyst nematode, don't plant with other brassicas, can be harmful to livestock.  Surpasses nematodes and weeds.  "]
["PHACELIA",0,"N/A","N/A",3,4,1,"Seldom",3,3,2,4,0,"Cool Season, Annual","Upright","N/A","Low",1,4,1,"10-15:1","N/A",235000,42]
["RADISH ",0,"30-100","1200-3000",4,3,0,"Never",2,2,2,1,0,"Cool Season, Annual","Upright","6-7","High",2,1,1,"19-20:1","26-30%",34000,45,"Good Nitrogen scavenging and weed control; Nitrogen released rapidly.  Winter kills at 25 degrees F.  Odor during decay.  Attracts earthworms.  Non-host for soybean cyst nematode.  Some species are commonly used as a trap crop for sugarbeet cyst nematode.  Host for root knot nematode, Penetrans Root-Lesion Nematode and sugarbeet cyst nematode. "]
["RAPESEED/CANOLA",0,"30-100","1000-2500",3,0,1,"Seldom",2,2,1,1,2,"Cool Season, Annual","Upright","5.5-8","Medium",2,2,1,"12-37:1","Shoots 20-30%, Hay 16%, Grain 21%, Silage 12%, Pasture 17%",156960,41,"Suppresses Rhizoctonia.  Carbon: Nitrogen Ratio-Leaf 12-16, Stem 21-37, Root 24-43  Rapeseed is a non-host for root knot nematode and sugarbeet cyst nematode.  Essex rape is used as a non-host for control of dagger nematodes in tree fruit production.  Rapeseed is a host for Penetrans Root-Lesion Nematode."]
["TURNIP",0,"30-100","1200-3000",2,4,1,"Never",2,1,1,1,0,"Cool Season, Annual","Upright","5.3-6","High",1,1,0,"20-30:1","Tops 16%, Roots 12-14%",192800,45,"High producing forage for grazing.  Can become a serious weed if let to go to seed. Non-host for soybean cyst nematode.   Carbon: Nitrogen Ratio-shoots 20-30, Roots 10-20.  Host for root knot nematode.  Penetrans Root-Lesion Nematode and sugarbeet cyst nematode."]
["BUCKWHEAT",0,0,"1500-2500",4,2,0,"Never",4,2,1,1,0,"Warm Season, Annual","Upright to Semi-Upright","5-7","Medium",3,4,0,"8-32:1","Straw 5%, Grain 13%",20400,50,"Cool Season but has Warm Season Growth Characteristics.  Enhances soil Phosphorus availability.  Carbon: Nitrogen Ratio--Leaf 8-10, Stem 12-32, Root 28-47.  Summer smother crop, breaks down quickly.  Buckwheat sets seed quickly.  Potential honey income.  Very frost sensitive.  Does not germinate or thrive in cold soil.  One variety of buckwheat has been successfully developed for use as a sugarbeet cyst nematode trap crop."]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["NON-LEGUME BROADLEAVES (continued)"]
["SAFFLOWER",0,"N/A","N/A",3,3,3,"N/A",4,4,1,0,2,"Warm Season, Annual","Upright","N/A","High",3,4,1,"21-56:1","Hay 10-13%, Grain 18%","N/A",40,"Deep Rooted.   Effective at mining mobile nutrients deep in the soil profile.   Carbon: Nitrogen Ratio--Leaf 21, Stem 56, Root 73."]
["SUNFLOWER",0,"N/A","N/A",3,3,3,"Seldom",3,2,0,0,1,"Warm Season, Annual","Upright","N/A","High",3,4,0,"11-46:1","Silage 11-12%., Grain 20-28%","N/A",39,"Deep Rooted.  Effective at mining mobile nutrients deep in the soil profile.  Carbon: Nitrogen Ratio--Leaf 11-14, Stem 41-46, Root 50-68, Flower 14-19. "]
["LEGUMES"]
["CHICKPEA",3,"N/A","N/A",3,4,3,"N/A",3,2,3,4,2,"Cool Season, Annual ","Upright and Spreading","N/A","Low",1,4,1,"10-56:1","Straw 6%, Grain 22%","N/A",42,"Carbon: Nitrogen Ratio-Leaf 10-15, Stem 25-56, root 16-27. "]
["BALANSA CLOVER",3,"N/A","N/A",2,4,4,"N/A",3,2,3,3,2,"Cool Season, Annual","Upright, Spreading, or Prostrate","4-8","N/A",1,4,1,"15:1","15-20%","N/A",42,"Multibranched Rosette but Prostrate when grazed.  Requires inoculation with root-nodule bacterium Rhizobium sp. at planting."]
["BERSEEM CLOVER",4,"70-100","1200-3000",1,4,3,"Never",3,2,2,1,1,"Cool Season, Annual","Upright","6-8","Low",1,3,1,"18-23:1","27-29%",206880,42,"May cause bloat.  Excellent as greenchop, less impressive as dry harvested forage.  "]
["CRIMSON CLOVER",3,"50-90","3500-5500",2,2,3,"Never",3,2,2,1,0,"Cool Season, Annual","Upright to Semi-Upright","5.5-7","Medium",2,3,1,"16-19:1",0.18,149760,42,"Establishes easily, grows quickly if planted early in fall; matures early in spring.  May cause bloat.  Excellent as greenchop, less impressive as dry harvested forage.  Good for interseeding, easy to kill by tillage or mowing.  Non-host for sugarbeet cyst nematode.  Host for root knot nematode, soybean cyst nematode, and Penetrans Root-Lesion Nematode."]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["LEGUMES (continued)"]
["RED CLOVER",4,"70-100","2000-5000",3,4,3,"Expected",3,2,3,2,0,"Cool Season, Perennial","Upright","5.5-7","Medium",2,3,2,"15-23:1",0.15,272160,42,"Can cause bloat in livestock.  Excellent forage, easily established; widely adapted.  Excellent as a greenchop, less impressive as dry harvested forage. Excellent for interseeding into small grains, less reliable in corn and soybeans.  Great option for frost seeding/rapid establishment.   Non-host for sugarbeet cyst nematode and a poor host for soybean cyst nematode.  Host for root knot nematode and Penetrans Root-Lesion Nematode."]
["WHITE CLOVER",2,"50-90","2000-6000",1,3,3,"Expected",3,2,3,3,0,"Cool Season, Perennial","Upright","5.5-7","Medium",2,3,2,"13-23:1","24-30%",784000,42,"Causes bloat in horses.  May cause bloat in cattle/sheep.  Excellent as a greenchop, less impressive as dry harvested forage.  Aggressive growth in some regions or habitats."]
["FAVA BEAN","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0,"N/A","N/A",2,"Cool Season, Annual","Upright Vine","N/A","Medium","N/A",4,"N/A","N/A",0.17,"N/A","N/A"]
["FIELD/WINTER PEA",2,"50-100","1200-3000",3,2,3,"Never",1,1,1,1,0,"Cool Season, Annual","Climbing","6-7","Low",1,2,1,"13-83:1","Hay 14%, Grain 24%, Silage 15%",1840,41,"Poor host for soybean cyst nematode.  Carbon: Nitrogen Ratio---Leaf 13-25, Stem 27-83, root 17-27.  Biomass breaks down quickly; early planting reduces winter survival.  Mixes well with grains when grown for forage.  Late planting increases heaving/overcrowding.  Host for root knot nematode, Penetrans Root-Lesion Nematode and sugarbeet cyst nematode."]
["LENTILS","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0,"Cool Season, Annual","Upright and Spreading","N/A","Low","N/A",3,"N/A","11-49:1","Hay 14%, Grain 28%, Silage 15%","N/A","N/A","Carbon: Nitrogen Ratio--leaf 11-21, Stem 25-49, Root 22-30"]
["SAINFOIN",4,"N/A","N/A",3,4,4,"N/A",3,3,1,4,0,"Cool Season, Perennial","Upright","6-8.5","Medium",1,4,1,"N/A","13-20%",18000,42,"Is nonbloating and preferred forage for cattle, sheep, deer and elk."]
[" VETCH",4,"50-120","1800-4000",1,0,1,"Expected",1,2,2,2,0,"Cool Season, Annual","Climbing","5.5-7","Low to Medium",2,4,1,"10-19:1","13-20%",16320,60,"Host soybean cyst nematode, high % of hard seed-can become weedy.  Seeds are toxic to livestock.  Tolerates low fertility, wide pH range, cold or fluctuating winters.   Non-host for sugarbeet cyst nematode.   Do not plant in fields where small grains are grown for a cash crop since seed contamination decreases small grain value.  Hairy vetch is a host for root knot nematode, soybean cyst nematode, and Penetrans Root-Lesion Nematode.  Cutworm can also be a problem."]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles",null,null,null,null,null,null,"Cultural Traits"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Quick Growth","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Attracts Beneficials","Bears Traffic","C:N Ratio","Crude Protein","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["LEGUMES (continued)"]
["COWPEA",3,"50-100","2000-3600",2,3,2,"Never",4,3,2,1,1,"Warm Season, Annual","Semi-Upright to Climbing","5.5-6","Low",2,3,0,"18-22:1","Grain and Leaves 19-30%, Stems 13-17%",3600,58,"Season length, habit vary by cultivar.  Some cultivars, nematode resistant.  Host soybean cyst nematode."]
["SOYBEANS ",2,"20-50","3000-6000",2,2,2,"Never",3,3,2,1,0,"Warm Season, Annual","Upright","5.8-7","Medium",2,3,1,"14-39:1","Hay 17%, Grain 42%",3000,50,"Self-Pollinated but flowers may attract pollinators.  Host plant for soybean cyst nematode  Carbon: Nitrogen Ratio--Leaf 14, Stem 39, root 34."]
["SUNNHEMP",4,"50-100","2000-5000",3,3,1,"Never",4,3,1,2,0,"Warm Season, Annual","Upright","5-8","Low",2,1,2,"14-30","N/A",15000,42,"Self Pollinates (wind) as well as cross pollinates (insects/birds).  Certain Cultivars contain alkaloids which are poisonous to livestock.  Avoid grazing after flowering.  Has an extensive taproot."]
[null,"INFORMATION from Midwest Cover Crops Council (MCCC) Website, MCCC Cover Crop Field Guide, Green Cover Seed, SARE-Managing Cover Crops Profitably, SARE Cover Cropping for Pollinators and Beneficial Insects, USDA-ARS Cover Crops Chart, and USDA-NRCS PLANTS Guide"]

{"sheet":"Table 2 -Characteristics Sept23","index":5,"n_rows":63,"n_cols":35,"rows_kept":63,"cut":false,"hidden":false,"merged":[[51,0,51,34],[62,1,62,34],[32,0,32,34],[33,1,33,8],[33,9,33,12],[33,13,33,22],[33,23,33,28],[33,29,33,33],[35,0,35,34],[43,0,43,34],[48,0,48,34],[49,1,49,8],[49,9,49,12],[49,13,49,22],[49,23,49,28],[49,29,49,33],[19,0,19,34],[26,0,26,34],[3,0,3,34],[16,0,16,34],[17,1,17,8],[17,9,17,12],[17,13,17,22],[17,23,17,28],[17,29,17,33],[0,0,0,34],[1,1,1,8],[1,9,1,12],[1,13,1,22],[1,23,1,28],[1,29,1,33]]}
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles I",null,null,null,null,null,null,null,"Performance and Roles II",null,null,null,"Cultural Traits",null,null,null,null,null,null,null,null,null,"Potential Advantages"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Nitrogen Scavenger","Soil Builder","Erosion Fighter","Weed Fighter","Quick Growth","Lasting Residue","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Subsoiler","Allelopathic","Choke Weeds","Attracts Beneficials","Bears Traffic","Short Windows","C:N Ratio","Crude Protein","Arbuscular Mycorrhizal Associations","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["GRASSES"]
["SPRING BARLEY",0,0,"2000-5000 ",3,3,3,3,3,3,3,2,"Never",2,2,1,2,2,"Cool Season, Annual","Upright","6-8","Low",2,2,3,3,2,2,4,"20:1","hay 10-15%, Grain 11-15%","Benefits from",13600,35,"If small grains are planted too early  in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)  Self Pollinator (wind).  "]
["WINTER BARLEY",0,0,"2000-10,000",4,3,4,3,3,4,3,2,"Seldom",2,2,1,2,"N/A","Cool Season, Annual","Upright","6-8","N/A",3,2,3,4,2,2,4,"20:1",0.12,"Benefits from",13600,35,"Tolerates moderately alkaline conditions but does poorly in acid soils of less than 6 pH.   If small grains are planted too early in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)."]
["OATS",0,0,"2000-6000",3,3,3,2,4,2,4,3,"Never",2,2,2,2,1,"Cool Season, Annual","Upright","4.5-7","Medium",3,2,2,3,0,3,4,"33:1","Hay 9-15%, Grain 13-18%","Forms",19600,38,"Prone to lodging in N rich soil. Self Pollinator (wind).  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.   Host for Penetrans Root-Lesion Nematode.  Slow to release Nitrogen to following crop unless growth terminated in mid-vegetative stage (12-18 in). "]
["ANNUAL RYEGRASS",0,0,"1000-8000",3,3,3,2,3,3,4,3,"Seldom",1,1,3,3,"N/A","Cool Season, Annual","Upright","5.5-7","N/A",2,2,2,4,1,3,3,"20:1-31:1",0.09,"N/A",190280,40,"Heavy Nitrogen and water user.  Cutting boosts dry matter significantly.  Not advised for wheat rotations.  May take two applications to chemically terminate.  Must be killed before it joints.  Host for Penetrans Root-Lesion Nematode."]
["WINTER CEREAL RYE",0,0,"2500-6000",4,4,4,4,4,4,4,3,"Expected",2,3,2,3,2,"Cool Season, Annual","Upright","5-7","High",3,2,4,4,1,3,4,"14:1 young 40:1 boot","Straw 4%, Grain 14%","Forms",18160,34,"Kill 1.5-2 weeks before planting corn.  Not recommended before corn due to allelopathy.  Corn seed maggot/armyworm, cutworm  could be issues.  Tolerates triazine herbicides.  Self Pollinator (wind).  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.   Host for Penetrans Root-Lesion Nematode."]
["SPRING TRITICALE",0,0,"2000-5000",4,3,4,3,3,4,4,3,"Never",2,2,2,2,2,"Cool Season, Annual","Upright","5.2-7","High",2,2,2,4,1,3,4,"20:1","Hay 9-16%, Grain-17%","Forms",15000,38]
["WINTER TRITICALE",0,0,"2000-5000",4,3,4,3,3,4,4,3,"Expected",2,2,2,2,2,"Cool Season, Annual","Upright","5.2-7","High",2,2,2,4,1,3,4,"20:1","Hay 9-16%, Grain-17%","Forms",16000,38,"Self Pollinator (wind).  Non-host for sugarbeet cyst nematode, soybean cyst nematode, and root knot nematode.  Host for Penetrans Root-Lesion Nematode."]
["SPRING WHEAT",0,0,"1200-3000",3,3,3,2,3,3,3,3,"Never",2,2,2,2,2,"Cool Season, Annual","Upright","6-7","Medium",2,2,1,3,1,3,4,"15-95:1","Straw 4-10%, Grain 12-16%","Benefits from",11360,38,"Heavy Nitrogen and water user in spring. Absorbs Nitrogen and Water heavily during stem growth, so kill before then.  Carbon: Nitrogen Ratio--Leaf 15-29, Stem 31-65, Root 24-74, Straw 80-95 (end of season).  Self Pollinator (wind).  Southern MN has Hessian Fly-free planting dates to be heeded.   Host for Penetrans Root-Lesion Nematode."]
["WINTER WHEAT",0,0,"2000-5000",4,3,4,3,3,4,4,3,"Expected",2,2,2,2,"N/A","Cool Season, Annual","Upright","6-7","N/A",2,2,1,4,1,3,4,"20:1",0.09,"N/A",11360,38,"Kill 1.5-2 weeks before planting corn.  Corn seed maggot, armyworm, and cutworm could be insect issues.  Heavy Nitrogen and water user in spring.  Southern MN has Hessian Fly-free planting dates to be heeded.  Non-host for sugarbeet nematode, soybean cyst nematode, and root knot nematode.  Wheat curl mite can spread wheat streak mosaic virus.  Use 2 weeks of broken green bridge to break the pest cycle (cover crops can harbor the pest, allowing transfer from spring to winter crops).  If small grains are planted too early in the fall, depending on the crop rotation there can be disease problems (especially with tan spot)."]
["CORN",0,0,"1000-12000",3,2,3,4,4,4,3,2,"Never",3,2,3,1,1,"Warm Season, Annual","Upright","5.5-7.5","High",1,2,1,4,"NA","NA","NA","57:1","6.5-8.5%","Good",2450,50]
["FOXTAIL MILLET",0,0,"4000-8000",3,3,3,3,4,3,2,2,"Never",4,4,1,1,0,"Warm Season, Annual","Upright","5.5-7","Low",3,2,2,4,1,3,4,"44:1",0.15,"Forms",220000,65,"Self Pollinator (wind).  Do not feed to horses as it may have a laxative effect."]
["JAPANESE MILLET",0,0,"1500-5500",3,3,3,3,4,3,3,2,"Never",4,4,1,1,"N/A","Warm Season, Annual","Upright","4.6-7","N/A",3,2,2,4,1,3,4,"42:1",0.16,"N/A",142880,65,"Does not germinate or thrive in cold soil.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  Host for Penetrans Root-Lesion Nematode"]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles I",null,null,null,null,null,null,null,"Performance and Roles II",null,null,null,"Cultural Traits",null,null,null,null,null,null,null,null,null,"Potential Advantages"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Nitrogen Scavenger","Soil Builder","Erosion Fighter","Weed Fighter","Quick Growth","Lasting Residue","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Subsoiler","Allelopathic","Choke Weeds","Attracts Beneficials","Bears Traffic","Short Windows","C:N Ratio","Crude Protein","Arbuscular Mycorrhizal Associations","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["GRASSES (continued)"]
["PEARL MILLET",0,0,"2000-6000",3,3,3,3,4,3,4,2,"Never",4,4,1,1,0,"Warm Season, Annual","Upright","5.5-7","Low",3,2,2,4,1,3,3,"50:1",0.13,"Forms",82320,65,"Self Pollinator (wind).  Slower to establish than sudan or sorghum-sudangrass.  Does not germinate or thrive in cold soil.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  It is the best known cover crop for reduction of population densities of Penetrans Root-Lesion Nematode, but this can be variety specific.  "]
["PROSO MILLET",0,0,"2000-4000",3,3,3,3,4,3,3,2,"Never",4,4,2,2,0,"Warm Season, Annual","Upright","5.5-7","Medium",3,2,2,4,1,3,4,"12-35:1",0.1,"Forms",80000,65,"Carbon: Nitrogen Ratio--Leaf 12-16, Stem 12-35, Root 17-26.  Self Pollinators (wind).  "]
["SORGHUM",0,0,"3000-11000",4,4,3,4,4,4,3,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,2,4,2,3,4,"10-30:1","5-10%","Forms",14000,65,"Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Don't graze until it's 24\" tall and for 2 weeks after a killing frost-prussic acid  Be wary of prussic acid toxicity if using for forage/grazing.  "]
["SORGHUM-SUDANGRASS",0,0,"3000-11000",4,4,3,4,4,4,3,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,2,4,2,3,4,"10-30:1","Hay 7%, Stover 5%, Grain 10%","Forms",17280,65,"Alternate Name Grain Sorghum.  Carbon: Nitrogen Ratio--Leaf 11-17, Stem 10-27, Root 22-30.  Self Pollinator (wind).  Mature, frost-killed plants become quite woody.  Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Don't graze until it's 24\" tall and for 2 weeks after a killing frost-prussic acid  Be wary of prussic acid toxicity if using for forage/grazing.  Mid-season cutting increase yield and root penetration.  Has been used in tree fruit, small fruit and vegetable production systems since the middle 1960s for management of Penetrans Root-Lesion Nematode and root knot nematode.  Non-host for soybean cyst nematode and sugarbeet cyst nematode.  "]
["SUDANGRASS",0,0,"3000-11000",4,4,3,4,4,4,4,4,"Never",4,4,1,2,1,"Warm Season, Annual","Upright","5.5-7","Medium",2,2,2,4,2,3,4,"48-63:1","Hay 7-11%, Silage 6-17%","Forms",42240,65,"Self Pollinator (wind).  Stress conditions that limit growth (e.g. drought, frost) can contribute to prussic acid accumulation in leaves.  Be wary of prussic acid toxicity if using for forage/grazing.  Drought stressed plants can cause nitrate poisoning.  Known allelopathic effects on annual ryegrass.  Non-host for root knot nematode, soybean cyst nematode, and sugarbeet cyst nematode.  Host for Penetrans Root-Lesion Nematode."]
["TEFF",0,0,"2000-8000",2,3,3,3,4,3,4,4,"Never",4,4,1,2,2,"Warm Season, Annual","Upright","5.0-7.0","Medium",2,2,1,3,"NA","NA","NA","20:1",0.18,"Forms",1300000,65]
["NON-LEGUME BROADLEAVES"]
["BEETS ",1,"N/A","N/A",3,1,1,"N/A",4,1,4,3,"N/A",1,2,3,3,1,"Cool Season, Biennial ","Upright and Spreading","N/A","High",1,2,2,1,"N/A",4,4,"Tops 11-14:1","Tops 12-15%, Root 7-10%","Does Not Form","N/A",40,"Self Pollinator (wind)"]
["CABBAGE",1,"N/A","N/A",2,3,3,"N/A",3,3,4,3,"N/A",3,2,3,4,"N/A","Cool Season, Annual","Upright and Spreading","N/A","N/A",1,1,1,3,"N/A",1,3,"12-30:1","N/A","N/A","N/A",42]
["FORAGE COLLARDS",0,"N/A","N/A","N/A",3,3,4,3,1,4,3,"N/A",4,4,3,2,2,"Cool Season, Annual","Upright and Spreading","N/A","N/A",2,3,1,4,"N/A",1,"N/A","12-30:1","N/A","N/A",175000,42]
["KALE",0,"N/A","N/A","N/A","N/A","N/A",3,"N/A","N/A",4,"N/A","Seldom","N/A","N/A","N/A",0,1,"Cool Season, Annual","Upright and Spreading","N/A","Medium","N/A","N/A","N/A",3,"N/A","N/A","N/A","10-30:1",0.3,"Does Not Form","N/A",45,"Introduce slowly to livestock because it is highly digestible.  Should never be more than 35% of diet.  Likes seed to soil contact so incorporated seeding at a shallow depth is best."]
["MUSTARD",0,"30-100","1200-3000",3,2,2,3,3,1,0,0,"Never",2,2,1,1,0,"Cool Season, Annual","Upright","5.5-8","Low",2,2,2,3,3,1,4,"10-30:1","Hay 10%, Grain 24-35%","Does Not Form",180000,40,"Host soybean cyst nematode, don't plant with other brassicas, can be harmful to livestock.  Surpasses nematodes and weeds.  "]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles I",null,null,null,null,null,null,null,"Performance and Roles II",null,null,null,"Cultural Traits",null,null,null,null,null,null,null,null,null,"Potential Advantages"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Nitrogen Scavenger","Soil Builder","Erosion Fighter","Weed Fighter","Quick Growth","Lasting Residue","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Subsoiler","Allelopathic","Choke Weeds","Attracts Beneficials","Bears Traffic","Short Windows","C:N Ratio","Crude Protein","Arbuscular Mycorrhizal Associations","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["NON-LEGUME BROADLEAVES (continued)"]
["PHACELIA",0,"N/A","N/A",2,2,3,"N/A",3,1,4,1,"Seldom",3,3,2,4,0,"Cool Season, Annual","Upright","N/A","Low",1,1,1,2,4,1,3,"10-15:1","N/A","Forms",235000,42]
["RADISH ",0,"30-100","1200-3000",3,3,2,3,4,0,3,0,"Never",2,2,2,1,0,"Cool Season, Annual","Upright","6-7","High",2,3,2,3,1,1,3,"19-20:1","26-30%","Does Not Form",34000,45,"Good Nitrogen scavenging and weed control; Nitrogen released rapidly.  Winter kills at 25 degrees F.  Odor during decay.  Attracts earthworms.  Non-host for soybean cyst nematode.  Some species are commonly used as a trap crop for sugarbeet cyst nematode.  Host for root knot nematode, Penetrans Root-Lesion Nematode and sugarbeet cyst nematode. "]
["RAPESEED/CANOLA",0,"30-100","1000-2500",3,2,2,2,3,1,0,1,"Seldom",2,2,1,1,2,"Cool Season, Annual","Upright","5.5-8","Medium",2,2,2,2,2,1,2,"12-37:1","Shoots 20-30%, Hay 16%, Grain 21%, Silage 12%, Pasture 17%","Does Not Form",156960,41,"Suppresses Rhizoctonia.  Carbon: Nitrogen Ratio-Leaf 12-16, Stem 21-37, Root 24-43  Rapeseed is a non-host for root knot nematode and sugarbeet cyst nematode.  Essex rape is used as a non-host for control of dagger nematodes in tree fruit production.  Rapeseed is a host for Penetrans Root-Lesion Nematode."]
["TURNIP",0,"30-100","1200-3000",3,2,2,2,2,1,4,1,"Never",2,1,1,1,0,"Cool Season, Annual","Upright","5.3-6","High",1,0,2,2,1,0,2,"20-30:1","Tops 16%, Roots 12-14%","Does Not Form",192800,45,"High producing late-season forage for grazing.  Can become a serious weed if let to go to seed. Non-host for soybean cyst nematode.   Carbon: Nitrogen Ratio-shoots 20-30, Roots 10-20.  Host for root knot nematode.  Penetrans Root-Lesion Nematode and sugarbeet cyst nematode."]
["BUCKWHEAT",0,0,"1500-2500",3,2,2,3,4,0,2,0,"Never",4,2,1,1,0,"Warm Season, Annual","Upright to Semi-Upright","5-7","Medium",3,1,1,4,4,0,4,"8-32:1","Straw 5%, Grain 13%","Does Not Form",20400,50,"Cool Season but has Warm Season Growth Characteristics.  Enhances soil Phosphorus availability.  Carbon: Nitrogen Ratio--Leaf 8-10, Stem 12-32, Root 28-47.  Summer smother crop, breaks down quickly.  Buckwheat sets seed quickly.  Potential honey income.  Very frost sensitive.  Does not germinate or thrive in cold soil.  One variety of buckwheat has been successfully developed for use as a sugarbeet cyst nematode trap crop."]
["SAFFLOWER",0,"N/A","N/A",4,3,1,"N/A",3,1,3,3,"N/A",4,4,1,0,2,"Warm Season, Annual","Upright","N/A","High",3,4,2,3,4,1,0,"21-56:1","Hay 10-13%, Grain 18%","Forms","N/A",40,"Deep Rooted.   Effective at mining mobile nutrients deep in the soil profile.   Carbon: Nitrogen Ratio--Leaf 21, Stem 56, Root 73."]
["SUNFLOWER",0,"N/A","N/A",4,3,3,"N/A",3,3,3,3,"Seldom",3,2,0,0,1,"Warm Season, Annual","Upright","N/A","High",3,4,0,2,4,0,4,"11-46:1","Silage 11-12%., Grain 20-28%","Forms","N/A",39,"Deep Rooted.  Effective at mining mobile nutrients deep in the soil profile.  Carbon: Nitrogen Ratio--Leaf 11-14, Stem 41-46, Root 50-68, Flower 14-19. "]
["LEGUMES"]
["CHICKPEA",3,"N/A","N/A",2,2,3,"N/A",3,2,4,3,"N/A",3,2,3,4,2,"Cool Season, Annual ","Upright and Spreading","N/A","Low",1,1,1,1,4,1,3,"10-56:1","Straw 6%, Grain 22%","Forms","N/A",42,"Carbon: Nitrogen Ratio-Leaf 10-15, Stem 25-56, root 16-27. "]
["BALANSA CLOVER",3,"N/A","N/A",2,3,3,"N/A",2,2,4,4,"N/A",3,2,3,3,2,"Cool Season, Annual","Upright, Spreading, or Prostrate","4-8","N/A",1,1,1,4,4,1,3,"15:1","15-20%","N/A","N/A",42,"Multibranched Rosette but Prostrate when grazed.  Requires inoculation with root-nodule bacterium Rhizobium sp. at planting."]
["BERSEEM CLOVER",4,"70-100","1200-3000",2,3,3,2,1,2,4,3,"Never",3,2,2,1,1,"Cool Season, Annual","Upright","6-8","Low",1,1,1,2,3,1,1,"18-23:1","27-29%","Forms",206880,42,"May cause bloat.  Excellent as greenchop, less impressive as dry harvested forage.  "]
["CRIMSON CLOVER",3,"50-90","3500-5500",2,3,2,2,2,2,2,3,"Never",3,2,2,1,0,"Cool Season, Annual","Upright to Semi-Upright","5.5-7","Medium",2,2,1,3,3,1,1,"16-19:1",0.18,"Forms",149760,42,"Establishes easily, grows quickly if planted early in fall; matures early in spring.  May cause bloat.  Excellent as greenchop, less impressive as dry harvested forage.  Good for interseeding, easy to kill by tillage or mowing.  Non-host for sugarbeet cyst nematode.  Host for root knot nematode, soybean cyst nematode, and Penetrans Root-Lesion Nematode."]
["ATTRIBUTE RATINGS: 0=POOR, 1= FAIR, 2=GOOD, 3=VERY GOOD, 4=EXCELLENT"]
[null,"Performance and Roles I",null,null,null,null,null,null,null,"Performance and Roles II",null,null,null,"Cultural Traits",null,null,null,null,null,null,null,null,null,"Potential Advantages"]
["SPECIES","Nitrogen Source","Total Nitrogen (lb/ac)","Dry Matter (lbs/ac/yr)","Nitrogen Scavenger","Soil Builder","Erosion Fighter","Weed Fighter","Quick Growth","Lasting Residue","Grazing","Mechanical Forage Harvest  Value","winter Survival","Heat Tolerance","Drought Tolerance","Shade Tolerance","Flood Tolerance","Salinity Tolerance","Life Cycle","Growth Habit","Preferred Soil pH","Water Use","Low Fert Tolerance","Subsoiler","Allelopathic","Choke Weeds","Attracts Beneficials","Bears Traffic","Short Windows","C:N Ratio","Crude Protein","Arbuscular Mycorrhizal Associations","Seed Count (seeds/lb)","Germination Temperature (F)","Notes"]
["LEGUMES (continued)"]
["RED CLOVER",4,"70-100","2000-5000",3,3,4,3,3,2,4,3,"Expected",3,2,3,2,0,"Cool Season, Perennial","Upright","5.5-7","Medium",2,2,1,3,3,2,2,"15-23:1",0.15,"Forms",272160,42,"Can cause bloat in livestock.  Excellent forage, easily established; widely adapted.  Excellent as a greenchop, less impressive as dry harvested forage. Excellent for interseeding into small grains, less reliable in corn and soybeans.  Great option for frost seeding/rapid establishment.   Non-host for sugarbeet cyst nematode and a poor host for soybean cyst nematode.  Host for root knot nematode and Penetrans Root-Lesion Nematode."]
["WHITE CLOVER",2,"50-90","2000-6000",2,3,3,2,1,1,3,3,"Expected",3,2,3,3,0,"Cool Season, Perennial","Upright","5.5-7","Medium",2,1,1,3,3,2,1,"13-23:1","24-30%","Forms",784000,42,"Causes bloat in horses.  May cause bloat in cattle/sheep.  Excellent as a greenchop, less impressive as dry harvested forage.  Aggressive growth in some regions or habitats."]
["FAVA BEAN","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0,"N/A","N/A",2,"Cool Season, Annual","Upright Vine","N/A","Medium","N/A","N/A","N/A","N/A",4,"N/A","N/A","N/A",0.17,"Forms","N/A","N/A"]
["FIELD/WINTER PEA",2,"50-100","1200-3000",2,2,2,1,3,1,2,3,"Never",1,1,1,1,0,"Cool Season, Annual","Climbing","6-7","Low",1,2,1,3,2,1,3,"13-83:1","Hay 14%, Grain 24%, Silage 15%","Forms",1840,41,"Poor host for soybean cyst nematode.  Carbon: Nitrogen Ratio---Leaf 13-25, Stem 27-83, root 17-27.  Biomass breaks down quickly; early planting reduces winter survival.  Mixes well with grains when grown for forage.  Late planting increases heaving/overcrowding.  Host for root knot nematode, Penetrans Root-Lesion Nematode and sugarbeet cyst nematode."]
["LENTILS","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0,"Cool Season, Annual","Upright and Spreading","N/A","Low","N/A","N/A","N/A","N/A",3,"N/A","N/A","11-49:1","Hay 14%, Grain 28%, Silage 15%","Forms","N/A","N/A","Carbon: Nitrogen Ratio--leaf 11-21, Stem 25-49, Root 22-30"]
["SAINFOIN",4,"N/A","N/A",2,3,3,"N/A",3,1,4,4,"N/A",3,3,1,4,0,"Cool Season, Perennial","Upright","6-8.5","Medium",1,1,1,4,4,1,3,"N/A","13-20%","Forms",18000,42,"Is nonbloating and preferred forage for cattle, sheep, deer and elk."]
[" VETCH",4,"50-120","1800-4000",2,2,2,2,1,1,0,1,"Expected",1,2,2,2,0,"Cool Season, Annual","Climbing","5.5-7","Low to Medium",2,1,2,3,4,1,1,"10-19:1","13-20%","Forms",16320,60,"Host soybean cyst nematode, high % of hard seed-can become weedy.  Seeds are toxic to livestock.  Tolerates low fertility, wide pH range, cold or fluctuating winters.   Non-host for sugarbeet cyst nematode.   Do not plant in fields where small grains are grown for a cash crop since seed contamination decreases small grain value.  Hairy vetch is a host for root knot nematode, soybean cyst nematode, and Penetrans Root-Lesion Nematode.  Cutworm can also be a problem."]
["COWPEA",3,"50-100","2000-3600",1,2,2,2,2,1,3,2,"Never",4,3,2,1,1,"Warm Season, Annual","Semi-Upright to Climbing","5.5-6","Low",2,2,0,4,3,0,4,"18-22:1","Grain and Leaves 19-30%, Stems 13-17%","Forms",3600,58,"Season length, habit vary by cultivar.  Some cultivars, nematode resistant.  Host soybean cyst nematode."]
["SOYBEANS ",2,"20-50","3000-6000",2,2,0,2,2,2,2,2,"Never",3,3,2,1,0,"Warm Season, Annual","Upright","5.8-7","Medium",2,2,0,3,3,1,3,"14-39:1","Hay 17%, Grain 42%","Forms",3000,50,"Self-Pollinated but flowers may attract pollinators.  Host plant for soybean cyst nematode  Carbon: Nitrogen Ratio--Leaf 14, Stem 39, root 34."]
["SUNNHEMP",4,"50-100","2000-5000",2,3,3,1,3,3,3,1,"Never",4,3,1,2,0,"Warm Season, Annual","Upright","5-8","Low",2,2,3,3,1,2,3,"14-30","N/A","Forms",15000,42,"Self Pollinates (wind) as well as cross pollinates (insects/birds).  Certain Cultivars contain alkaloids which are poisonous to livestock.  Avoid grazing after flowering.  Has an extensive taproot."]
[null,"INFORMATION from Midwest Cover Crops Council (MCCC) Website, MCCC Cover Crop Field Guide, Green Cover Seed, SARE-Managing Cover Crops Profitably, SARE Cover Cropping for Pollinators and Beneficial Insects, University of Minnesota Alternative Annual Forages webpage, USDA-ARS Cover Crops Chart, and USDA-NRCS PLANTS Guide"]

{"sheet":"Help","index":6,"n_rows":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Security Risk Error "]
[]
["If you see an error for a security risk that blocks macros, follow the steps below to fix the issue. "]
[]
[]
["1. Save any changes that you have made and close the document. "]
[]
["2. Open file location and right click the document and select 'Properties'.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Check the 'Unblock' box next to Security and click 'OK'."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Reopen document and the problem should be resolved.  "]

{"sheet":"Sheet2","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Planned Cover Crop Mix by Group"]
[]
[null,"Cool Season Grasses","Warm Season Grasses"]
[1]
[2]
[3]
[5]
[6]
[7]
[8]
[9]
[null,"Cool Season Broadleafs","Warm Season Broadleafs"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]