{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Guidance","Seed Mix","Data Table","Species Guide","Photo Sheet","Veg Zones"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":"Guidance","index":0,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[13,2,13,4],[13,5,13,7],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[40,0,40,9],[44,0,44,9],[46,0,46,9],[48,0,48,9],[14,2,14,7],[31,0,31,9],[42,0,42,9],[50,0,50,9],[54,0,54,9],[56,0,56,9],[0,0,0,9],[1,8,1,9],[3,0,3,9],[6,0,6,9],[16,0,16,9],[18,0,18,9],[34,0,34,9],[21,0,21,9],[23,0,23,9],[26,0,26,9],[28,0,28,9],[36,0,36,9],[38,0,38,9]]}
["Cover Crop Guidance"]
[null,null,null,null,null,null,null,null,"revised: 11-14-18"]
["Single Species:"]
["At a minimum, the seeding rate must equal the recommended seeding rate for the cover crop being seeded. Higher rates are acceptable depending on the purpose and location in the state."]
[]
["Multiple species:"]
["For cover crop mixes the sum of the Percent Full Rate column on the jobsheet should never be less than 100% since it is the sum of the percent of the recommended rate for each species.  It will normally be greater than 100% but should not exceed the upper limit listed on the table below  depending on your location in the state of if the field is irrigatd."]
[]
[null,null,"Recommended Percent Full Rate based on Vegetative Zone"]
[null,null,"Zone I",null,null,"100-125%"]
[null,null,"Zone II",null,null,"100-150%"]
[null,null,"Zone III",null,null,"100-175%"]
[null,null,"Zone IV",null,null,"100-200%"]
[null,null,"Irrigated Fields",null,null,"100-200%"]
[null,null,"Note: The sum of the Percent Full Rate column is easily skewed by species with low (< 10 lbs/ac) recommended seeding rates such as turnip, radish & sunflower. It is recommended that these not be included in determining if the mix meets the criteria based on the sum of the Percent Full Rate column."]
[]
["The seeding rate for any single species in the mix should not exceed the recommended rate for that species."]
[]
["If two similar species are being plated the maximum seeding rate for both species combined should not exceed the average recommended rate for both species. For example, if both rye and triticale are being seeded the maximum rate for both species combined should not exceed (36+45)/2 = 40 lbs/ac."]
[]
["Minimum Seeds per Square Foot:"]
["The number of seeds per square foot will vary depending on the species selected, however, for erosion control mixes based on cereal grains such as oats, rye, wheat or triticale a minimum of 25 seeds per square foot is required. For mixes based on annual ryegrass the minimum seeds per square foot would be 125."]
[]
["For ephemeral erosion control a minimum of 30 seeds per square foot is required for mixtures based on cereal grains.  Annual ryegrass is not recommended for ephemeral erosion control."]
[]
["Adjustments to Seeding Rates:"]
["Broadcast rates will be 1.5 times the recommended seeding rates.  The jobsheet will  automatically adjust the recommended seeding rate if broadcast is selected as the seeding method."]
[]
["Seeding rates for single species cover crops may be increased by up to 50% if grazing is a purpose and should be increased 30-60% if erosion control is the primary purpose. For critical areas such as ephemeral gully erosion control the seeding rate should be doubled.  For cover crop mixes consider the number of seeds per square foot required based on the predominant single species in the mix and adjust accordingly.  For example, if the mix is based on cereal rye and is to be drilled in concentrated flow areas, the recommended rate for rye would be 90 lbs/ac which would be 31 seeds per square foot so a rye based cover crop mix should have at least 31 seeds per square foot."]
[]
["Seeding Dates:"]
["Some flexibility in seeding dates is allowed.  Depending on the year cover crops could be seeded as much as 7-10 days before or after the recommended seeding dates listed in the data table.  Cereal rye may be seeded 2-4 weeks following harvest of corn or soybeans to facilitate early spring establishment.  Cover crops that frost terminate should be seeded at least 6-8 weeks prior to first killing frost."]
[]
["Species Diversity:"]
["For determining the species diversity of a cover crop mix, use the Percent by Number of Seeds column (% by # seeds).  If increasing biodiversity is an objective the mix should contain a variety of crop types and they should be fairly evenly represented based on number of seeds.  In selecting a cover crop species be sure it includes at least one different crop type then the crop that it follows."]
[]
["Note: The C:N ratio column is currently in draft form put will provide some general guidance for planning cover crop mixes."]
[]
["Species Selection Guide"]
[]
["A cover crop species selection guide has been added to NE-CPA-7 to aid in the selection of cover crop species for a selected purpose.  Most of the information included on the table came from Table 1 that was included with the old cover crop standard, Charts 2 and 4A from “Managing Cover Crops Profitably”, the “Midwest Cover Crops Field Guide”, and the ARS Cover Crop Chart.  The table is not complete because there is a limited amount of information about some of the species included on the table. A brief description of some of the columns follows."]
[]
["Dormant Seeding – Planting seed after the soil temperature is below that temperature at which the seed will germinate. The window of time to dormant seed is important. If done too early, some seed will germinate late in the season and those immature seedlings often won't survive the winter. Cover crop seed must be drilled while the ground is not completely frozen but is still cold enough so germination of the seed will not occur until soil temperatures rise, usually the next spring. Soil temperatures typically decrease below seed germination temperatures between mid­November to mid-March depending on your location within the state.   "]
[]
["Biomass Production – A quantitative estimate of the range of dry matter produced in lbs/ac/yr. As some of the data is based on research plots, irrigated systems or multi-cut systems and the cover crops were grown to flowering or maturity, on farm results will probably be toward the lower end of the range."]
[]
["Lasting Residue – Rates the effectiveness of the cover crop in providing long lasting mulch and assumes that the cover crop is grown to the reproductive stage."]
[]
["Erosion Reduction – Rates how extensive and how quickly a root system develops and how well it holds the soil. Applies primarily to when the cover crop is actively growing.  Long term erosion control should be based on biomass production and lasting residue."]
[]
["Total N – A quantitative estimate of the total N provided by a pure legume stand from all biomass (above and below ground) in lbs/ac. This is total N, not the fertilizer replacement value."]
[]
["Additional information can be found in “Managing Cover Crops Profitably”."]
["REFERENCES"]
["A. Clark (ed.). 2007. Managing cover crops profitably. 3rd ed.  Sustainable Agriculture Network Handbook Series; bk 9."]
[]
["Liebig, M.A., H.A. Johnson, D.W. Archer, J.R. Hendrickson, K.A. Nichols, M.R. Schmer, and D.L. Tanaka.  2013.  Cover Crop Chart: An intuitive educational resource for extension professionals.  Journal of Extension [Online], 51(3) Article 3TOT7.  Available at http://www.joe.org/joe/2013june/tt7.php"]
[]
["Midwest Cover Crop Council. Midwest Cover Crops Field Guide."]

{"sheet":"Seed Mix","index":1,"n_rows":93,"n_cols":27,"rows_kept":93,"cut":false,"hidden":false,"merged":[[62,6,62,7],[55,9,55,10],[61,6,61,10],[62,8,62,10],[64,8,64,10],[68,0,68,2],[72,8,72,10],[74,8,74,10],[64,6,64,7],[61,0,61,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,0,65,2],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[71,3,71,4],[72,3,72,4],[20,4,20,6],[60,0,60,10],[58,5,58,6],[56,1,56,6],[52,1,52,6],[52,8,52,9],[44,1,44,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[53,0,53,11],[55,1,55,6],[57,1,57,2],[56,7,56,8],[55,7,55,8],[45,0,45,2],[57,4,57,7],[37,1,37,2],[38,1,38,2],[57,9,57,10],[49,1,49,10],[50,0,50,10],[51,0,51,10],[31,21,32,21],[31,20,32,20],[31,17,32,17],[31,16,32,16],[31,13,32,13],[31,7,32,7],[31,19,32,19],[31,18,32,18],[56,9,56,10],[42,1,42,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[29,1,29,2],[31,15,32,15],[31,1,32,2],[29,6,29,8],[29,9,29,10],[31,10,32,10],[31,6,32,6],[29,3,29,4],[31,14,32,14],[31,12,32,12],[7,0,7,11],[47,0,47,3],[43,1,43,2],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[20,7,20,9],[14,0,14,1],[9,5,9,9],[10,5,10,9],[11,5,11,9],[12,5,12,9],[45,8,45,9],[18,0,18,11],[31,0,32,0],[25,1,25,5],[27,9,27,10],[26,9,26,10],[23,1,23,10],[27,6,27,8],[14,2,14,10],[15,0,15,10],[47,4,47,5],[1,0,1,11],[19,7,19,9],[19,4,19,6],[8,5,8,9],[5,1,5,2],[8,0,8,3],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,8,32,8],[31,9,32,9],[31,11,32,11],[4,1,4,8],[3,1,3,8],[5,4,5,8],[26,1,26,5],[27,1,27,5],[26,6,26,8],[16,0,16,10],[17,0,17,10],[21,0,21,3],[21,4,21,6],[21,7,21,9],[20,0,20,3],[78,16,78,17],[66,16,66,18],[71,0,71,2],[72,0,72,2],[73,0,73,2],[72,6,72,7],[68,6,68,7],[66,0,66,2],[66,6,66,7],[69,0,69,2],[70,0,70,2],[67,0,67,2],[70,16,70,17],[68,16,68,18],[70,6,70,7],[66,8,66,10],[68,8,68,10],[70,8,70,10],[73,3,73,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[90,0,91,4],[88,0,88,11],[76,7,77,8],[76,0,76,2],[90,6,91,10],[74,6,74,7],[76,4,76,5],[84,0,85,4],[78,6,78,7],[84,6,85,10],[75,6,75,7],[74,0,74,2],[75,0,75,2],[77,0,77,2],[77,3,77,6],[76,9,77,10],[80,0,80,10],[81,0,81,10],[82,0,82,10],[83,0,83,10],[74,3,74,4],[75,3,75,4]]}
[]
["COVER CROP DESIGN WORKSHEET"]
[]
["Name:",null,null,null,null,null,null,null,null,"Program:",null,null,null,null,null,null,null,null,null,"CRP"]
["Address:",null,null,null,null,null,null,null,null,"Contract #:",null,null,null,null,null,null,null,null,null,"CSP"]
["Field Number (s)",null,null,"Legal:",null,null,null,null,null,"CIN:",null,null,null,null,null,null,null,null,null,"CTA"]
[]
["Indicate the decision - makers objectives for applying cover crop in priority order 1,2,3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQIP","Starter only","Drill / Planter","Crimp","none"]
["Reduce Erosion: ",null,null,null,null,"Provide Supplemental Hay or Grazing:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FRPP","Starter & inoculant","Broadcast","Frost","shred"]
["Biological Nitrogen Fixation:",null,null,null,null,"Increase Biodiversity:",null,null,null,null,null,null,null,null,null,null,null,null,null,"SWCA","None",null,"Harvest","chemical burn down"]
["Pest Suppression:",null,null,null,null,"Attract Beneficial Insects:",null,null,null,null,null,null,null,null,null,null,null,null,null,"WHIP","Inoculant only",null,"Herbicide","field cultivator"]
["Increase Soil Organic Matter:",null,null,null,null,"Minimize and Reduce Soil Compaction:",null,null,null,null,null,null,null,null,null,null,null,null,null,"WRP",null,null,"Mow","disk"]
["Seedbed Prep for grass seeding:",null,null,null,null,"Capture, Recycle, Redistribute Nutrients:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tillage"]
[]
["Management Considerations:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$10=\"\",\"\",\"Add inoculant to legume seed as needed or recommended\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$9=\"\",\"\",\"Terminate cover crops only after they have achieved 8 to 10 inches of growth for erosion control\")","v":""},""]
[null,null,null,null,"Without Cover Crop",null,null,"With Cover Crop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$12=\"\",\"\",\"Single specie cover crops will generally produce less total biomass than cover crop mixes containing multiple crop types\")","v":""},""]
["Soil Erosion - ton/ac/yr (wind, water):",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z3=\"\",\"\",\"Be aware of forage value and potential nutritional side effects such as bloat or high nitrates\")","v":""},null,{"$f":"IF(AA3=\"\",\"\",\"Be aware of forage value and potential nutritional side effects such as bloat or high nitrates\")","v":""},"","","","","","","","","",""]
["Soil Condition Index:"]
[]
["Design Soil mapunit(s):"]
[]
["Site Preparation:"]
["Seeding Date(s):",null,null,null,null,null,"Termination Method:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]
["Seeding Method:",null,null,null,null,null,"Fertilizer and/or innoculant:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Early to Mid Vegetative","II"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Vegatative ","III"]
["Acres to be seeded:",null,null,"Vegetative Zone:",null,null,"Termination Growth Stage:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IV"]
[]
["Species List","Full Rate (lbs/ac)",null,"Planned Rate (lbs/ac)","% Full Rate","% by # seed","Seeds / ft² ","Crop Type","Seed Size","Seeding Depth","Total Pounds","C:N RATIO","Seeds/lb","Lbs/spp.","% seed by weight","% Full Rate","C:N Ratio #","C:N Ratio factor ","Seed Depth Ave","blank","Full rate Drill / Planter","Full rate Broadcast"]
[]
[null,{"$f":"IF(A34=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U34,U34,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V34,V34,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A1:$M50,15,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(D34>0,D34/B34,0)","v":0},{"$f":"IF(D34>0,G34/G46,0)","v":0},{"$f":"M34*N34/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A34=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A34,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D34","v":0},null,{"$f":"IF(A34=\"\",0,VLOOKUP(A34,'Data Table'!A2:M65,3,FALSE))","v":0},{"$f":"$B$30*D34","v":0},{"$f":"IF(A34=\"\",\"\",(N34/K46))","v":""},{"$f":"IF(D34>0,D34/B34,0)","v":0},null,null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A34=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A34,'Data Table'!A2:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A34,'Data Table'!A2:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A34,'Data Table'!A2:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A34,'Data Table'!A2:M65,8,FALSE))))))","v":""},{"$f":"IF(A34=\"\",\"\",(U34*1.5))","v":""}]
[null,{"$f":"IF(A35=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U35,U35,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V35,V35,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A2:$M51,15,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(D35>0,D35/B35,0)","v":0},{"$f":"IF(D35>0,G35/G46,0)","v":0},{"$f":"M35*N35/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A35=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A35,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D35","v":0},null,{"$f":"IF(A35=\"\",0,VLOOKUP(A35,'Data Table'!A2:M65,3,FALSE))","v":0},{"$f":"$B$30*D35","v":0},{"$f":"IF(A35=\"\",\"\",(N35/K46))","v":""},{"$f":"IF(D35>0,D35/B35,0)","v":0},null,null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A35=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A35,'Data Table'!A2:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A35,'Data Table'!A2:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A35,'Data Table'!A2:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A35,'Data Table'!A2:M65,8,FALSE))))))","v":""},{"$f":"IF(A35=\"\",\"\",(U35*1.5))","v":""}]
[null,{"$f":"IF(A36=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U36,U36,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V36,V36,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A3:$M52,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D36>0,G36/G46,0)","v":0},{"$f":"M36*N36/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A36=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A36,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D36","v":0},null,{"$f":"IF(A36=\"\",0,VLOOKUP(A36,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A36=\"\",\"\",(N36/K46))","v":""},0,null,null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A36=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A36,'Data Table'!A2:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A36,'Data Table'!A2:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A36,'Data Table'!A2:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A36,'Data Table'!A2:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A37=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U37,U37,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V37,V37,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A4:$M53,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D37>0,G37/G46,0)","v":0},{"$f":"M37*N37/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A37=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A37,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D37","v":0},null,{"$f":"IF(A37=\"\",0,VLOOKUP(A37,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A37=\"\",\"\",(N37/K46))","v":""},0,null,null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A37=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A37,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A37,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A37,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A37,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A38=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U38,U38,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V38,V38,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A5:$M54,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D38>0,G38/G46,0)","v":0},{"$f":"M38*N38/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A38,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D38","v":0},null,{"$f":"IF(A38=\"\",0,VLOOKUP(A38,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A38=\"\",\"\",(N38/K46))","v":""},0,null,null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A38=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A38,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A38,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A38,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A38,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A39=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U39,U39,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V39,V39,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A6:$M55,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D39>0,G39/G46,0)","v":0},{"$f":"M39*N39/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A39=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A39,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D39","v":0},null,{"$f":"IF(A39=\"\",0,VLOOKUP(A39,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A39=\"\",\"\",(N39/K46))","v":""},0,null,null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A39=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A39,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A39,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A39,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A39,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A40=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U40,U40,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V40,V40,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A7:$M56,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D40>0,G40/G46,0)","v":0},{"$f":"M40*N40/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A40=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A40,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D40","v":0},null,{"$f":"IF(A40=\"\",0,VLOOKUP(A40,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A40=\"\",\"\",(N40/K46))","v":""},0,null,null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A40=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A40,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A40,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A40,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A40,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A41=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U41,U41,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V41,V41,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A8:$M57,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D41>0,G41/G46,0)","v":0},{"$f":"M41*N41/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A41,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D41","v":0},null,{"$f":"IF(A41=\"\",0,VLOOKUP(A41,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A41=\"\",\"\",(N41/K46))","v":""},0,null,null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A41=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A41,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A41,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A41,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A41,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A42=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U42,U42,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V42,V42,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A9:$M58,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D42>0,G42/G46,0)","v":0},{"$f":"M42*N42/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A42,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D42","v":0},null,{"$f":"IF(A42=\"\",0,VLOOKUP(A42,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A42=\"\",\"\",(N42/K46))","v":""},0,null,null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A42=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A42,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A42,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A42,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A42,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A43=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U43,U43,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V43,V43,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A10:$M59,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D43>0,G43/G46,0)","v":0},{"$f":"M43*N43/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A43,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D43","v":0},null,{"$f":"IF(A43=\"\",0,VLOOKUP(A43,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A43=\"\",\"\",(N43/K46))","v":""},0,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A43=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A43,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A43,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A43,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A43,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A44=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U44,U44,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V44,V44,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A11:$M60,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D44>0,G44/G46,0)","v":0},{"$f":"M44*N44/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A44=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A44,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D44","v":0},null,{"$f":"IF(A44=\"\",0,VLOOKUP(A44,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A44=\"\",\"\",(N44/K46))","v":""},0,null,null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A44=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A44,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A44,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A44,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A44,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
[null,{"$f":"IF(A45=\"\",\"\",IF(B28=\"Drill / Planter\",(VLOOKUP(U45,U45,1,FALSE)),IF(B28=\"Broadcast\",(VLOOKUP(V45,V45,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A12:$M61,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D45>0,G45/G46,0)","v":0},{"$f":"M45*N45/(B30*43560)","v":{"$error":"#DIV/0!"}},{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!$A1:$M65,2,FALSE))","v":""},{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!$A2:$M65,4,FALSE))","v":""},{"$f":"IF(A45=\"\",\"\",IF(B28=\"Drill / Planter\",VLOOKUP(A45,'Data Table'!A2:M65,9,FALSE),(IF(B28=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"B30*D45","v":0},null,{"$f":"IF(A45=\"\",0,VLOOKUP(A45,'Data Table'!A2:M65,3,FALSE))","v":0},0,{"$f":"IF(A45=\"\",\"\",(N45/K46))","v":""},0,null,null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!A1:M65,10,FALSE))","v":""},null,{"$f":"IF(A45=\"\",\"\",IF(F30=\"I\",(VLOOKUP(A45,'Data Table'!A1:M65,5,FALSE)),IF(F30=\"II\",(VLOOKUP(A45,'Data Table'!A1:M65,6,FALSE)),IF(F30=\"III\",(VLOOKUP(A45,'Data Table'!A1:M65,7,FALSE)),IF(F30=\"IV\",VLOOKUP(A45,'Data Table'!A1:M65,8,FALSE))))))","v":""},""]
["LBS / ACRE = ",null,null,{"$f":"SUM(D34:D45)","v":0},{"$f":"SUM(E34:E45)","v":0},null,{"$f":"SUM(G34:G45)","v":{"$error":"#DIV/0!"}},null,"Total lbs needed:",null,{"$f":"SUM(K34:K45)","v":0},null,null,null,null,null,null,{"$f":"SUM(R34:R45)","v":0},{"$f":"IF(J34=\"\",\"\",SUM(S34:S45)/COUNTIF(S34:S45,\">0\"))","v":""}]
[]
["Planned Average Seeding Depth (inch):",null,null,null,{"$f":"IF(A34=\"\",\"\",IF(S46<=0.5,\"0.25 - 0.5\",IF(S46<=0.75,\"0.5 - 0.75\",IF(AND(S46>0.75,S46<=1),\"0.75 - 1.0\",IF(AND(S46>1,S46<=1.75),\"1.0 - 1.75\",\"1.75 - 3\")))))","v":""},{"$f":"IF(#REF!=\"\",\"\",IF(G48=0.5,\"0.25 - 0.5\",IF(G48<=0.75,\"0.5 - 0.75\",IF(AND(G48>0.75,G48<=1),\"0.75 - 1.0\",IF(AND(G48>1,G48<=1.75),\"1.0 - 1.75\",\"1.75 - 3\")))))","v":{"$error":"#REF!"}}]
[]
["NOTES:"]
[]
[]
["Planned by:",null,null,null,null,null,null,"Date: "]
["Cover Crop Certification Worksheet"]
[]
["Name:",{"$f":"B4&\"\"","v":""},null,null,null,null,null,"Program:",null,{"$f":"K4&\"\"","v":""}]
["Address:",{"$f":"B5&\"\"","v":""},null,null,null,null,null,"Contract #:",null,{"$f":"K5&\"\"","v":""}]
["Field Number(s):",{"$f":"B6&\"\"","v":""},null,"Legal:",{"$f":"E6&\"\"","v":""},null,null,null,"CIN:",{"$f":"K6&\"\"","v":""}]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":""},null,{"$f":"IF(E5=\"\",\"\",E5)","v":""}]
[]
["Instructions: Document producer's actual cover crop planting information below.  Attach or include photos of the cover crop on the Photos Sheet."]
["Species ",null,null,"Pounds Planted",null,null,"Practice Check-Out Conditions"]
[{"$f":"IF(A34>0,A34,\"\")","v":""},null,null,null,null,null,"Site Preparation:"]
[{"$f":"IF(A35>0,A35,\"\")","v":""}]
["",null,null,null,null,null,"Fertility Used:"]
[""]
["",null,null,null,null,null,"Date Seeded:"]
[""]
["",null,null,null,null,null,"Acres Seeded:"]
[""]
["",null,null,null,null,null,"Seeding Depth:"]
[""]
["",null,null,null,null,null,"Seeding Method:"]
[""]
[null,null,null,null,null,null,"Irrigated:"]
[]
["Total Lbs:",null,null,null,null,null,null,"Average Cover Crop Height at Termination"]
["Termination Date & Method:"]
[]
["Notes and Comments:"]
[]
[]
[]
[]
[]
[]
["Producer Signature",null,null,null,null,null,"Date"]
[]
["I certify that the above information does / does not meet NRCS specifications for design and installation."]
[]
[]
[]
["NRCS Signature",null,null,null,null,null,"Date"]

{"sheet":"Data Table","index":2,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Cover Crop Spp.","Crop Type","Seeds per lb","seed size","Full Rate lbs/ac  Zone I","Full Rate lbs/ac  Zone II","Full Rate lbs/ac  Zone III","Full Rate lbs/ac Zone IV","SEEDING DEPTH","Ave Seed Depth","Planting Date Zone I, II","Planting Date Zone III, IV","Winter Hardy","Dormant Seeding"]
["African Cabbage","CB (Br)",180000,"S",4,4,4,4,"0.25 - 0.5",0.5,"7/15-9/1","7/15-9/15","to 15-20o F"]
["Alfalfa","WB (L)",185000,"S",12,12,12,12,"0.25 - 0.5",0.5,"4/15-5/15 or 8/1-8/31","4/1-5-15 or 8/1-9/15","Yes"]
["barley, spring","CG",13500,"M",50,50,55,55,"0.75 - 2.0",1.25,"3/15-5/15 or 8/1-9/1","3/15-5/15 or 8/1-9/15","to 15-20o F"]
["barley, winter","CG",13500,"M",50,50,55,55,"0.75 - 2.0",1.25,"8/15-9/15","8/15-10/15","to -5o F"]
["buckwheat","WB",19000,"M",30,30,30,30,"0.5 - 1.5",1,"5/1-9/1","5/1-9/1","No"]
["camelina","CB (Br)",400000,"VS",3,4,5,6,"0 - 0.5",0.25,"4/1-5/15 or 8/1-9/15 or 11/15-3/15","3/15-5/15 or 8/1-10/15 or 11/15 - 3/15","to 10-15o F","Yes"]
["chickling vetch","CB (L)",2500,"L",50,50,50,50,"0.5 - 1.5",1,"3/15-4/15 or 8/1-9/1","3/15-4/15 or 8/1-9/15","to 15-20o F"]
["chickpea (desi-type)","WB (L)",2200,"L",80,80,0,0,"1.5 - 3.0",2.25,"4/15-5/15","4/15 - 5/15","No"]
["chicory","WB",400000,"VS",4,4,5,5,"0 - 0.5",0.25,"4/15-6/1","4/1-6/1","to 0o F"]
["clover, arrowleaf","CB (L)",200000,"S",8,8,8,8,"0.25 - 0.75",0.5,"3/15-5/15 or 8/15-9/15","3/15-5/15 or 8/15-9/15","No"]
["clover, Balansa","CB (L)",500000,"VS",5,6,7,8,"0.25 - 0.75",0.5,"8/1-9/15","8/1-10/1","to -10o F"]
["clover, Berseem","CB (L)",200000,"S",8,8,8,8,"0.25 - 0.75",0.5,"4/15-5/15 or 7/15-9/1","4/1-5/15 or 7/15-9/15","to 20-25o F"]
["clover, Crimson","CB (L)",150000,"S",10,10,10,10,"0.25 - 0.75",0.5,"3/15-5/15 or 7/15-9/1","3/15-5/15 or 7/15-9/15","to 5o F"]
["clover, Persian","CB (L)",185000,"S",8,8,8,8,"0.25 - 0.75",0.5,"3/15-5/15 or 7/15-9/1","3/15-5/15 or 7/15-9/15","to 10-15o F"]
["clover, red","CB (P, L)",250000,"S",0,0,6,6,"0.25 - 0.75",0.5,"NA","3/15-5/15 or 8/15-10/1 or 11/15-3/15","Yes","Yes"]
["clover, sweet","CB (B, L)",260000,"S",8,8,8,8,"0.25 - 1.0",0.5,"3/15-5/15 or 8/1-9/15 or 11/15-3/15","3/15/-5/15 or 8/1-10/1 or 11/15-3/15","Yes","Yes"]
["corn (BMR)","WG",2500,"L",34,34,34,34,"1.5 - 3.0",2.25,"6/1-8/15","5/15-8/15","No"]
["cowpea","WB (L)",4000,"L",0,20,30,30,"1.0 - 1.5",1.25,"6/1-8/15","5/15-8/15","No"]
["faba bean","CB (L)",2500,"L",50,50,50,50,"1.5 - 3.0",2.25,"3/15-4/15 or 7/15-9/1","3/15-4/15 or 7/15-9/1","to 20-25o F"]
["flax","CB",80000,"M",20,20,20,20,"0.25 - 0.75",0.5,"3/15-5/10 or 7/1-9/1","3/15-5/10 or 7/1-9/15","to 20-25o F"]
["Forage collards","CB (Br)",175000,"S",4,5,6,7,"0.25 - 0.5",0.5,"3/15-5/10 or 7/15-9/1","3/15-5/10 or 7/15-9/15","to 5o F"]
["Kale","CB (Br)",175000,"S",4,5,6,7,"0.25 - 0.5",0.5,"7/15-9/1","7/1-9/15","to 5o F"]
["lentil, spring","CB (L)",20000,"M",15,15,15,15,"1.0 - 1.5",1,"3/15-4/15 or 7/1-9/1","3/15-4/15 or 7/1-9/15","to 10-15o F"]
["lentil, winter","CB (L)",15000,"M",15,15,15,15,"1.0 - 1.5",1,"8/1-9/15","8/1-10/1","to 0o F"]
["millet, foxtail (German)","WG",190000,"S",10,10,10,10,"0.25 - 0.75",0.5,"5/15-8/1","5/15-8/1","No"]
["millet, pearl","WG",80000,"M",15,15,15,15,"0.25 - 0.75",0.5,"5/15-8/15","5/15-8/15","No"]
["millet, proso","WG",120000,"M",10,10,10,10,"0.25 - 0.75",0.5,"5/1-8/1","5/1-8/1","No"]
["mung beans","WB (L)",12000,"L",15,15,20,20,"1.5-3.0",2.25,"5/15-8/1","5/1-8/15","No"]
["mustard, brown, oriental or yellow","CB (Br)",140000,"S",3,3,3,3,"0.25 - 0.75",0.5,"3/15-4/1 or 7/15-9/1","3/15-4/1 or 7/15-9/15","No"]
["oats, black","CG",22000,"M",35,35,40,40,"0.5 - 1.5",1,"8/1-9/15","8/1-10/1","to 5o F"]
["oats, spring","CG",15000,"M",45,45,50,50,"0.5 - 1.5",1,"3/15-5/1 or 8/1-9/1","3/15-5/1 or 8/1-9/15","to 25o F"]
["oats, winter","CG",18000,"M",40,40,45,45,"0.5 - 1.5",1,"8/1-9/15","8/1-10/1","to 5o F"]
["pea, spring field ","CB (L)",2500,"L",40,40,40,40,"1.5 - 3.0",2.25,"3/15-4/15 or 7/15-9/1","3/15-4/15 or 7/15-9/1","No"]
["pea, spring forage","CB (L)",3500,"L",30,30,30,30,"1.5 - 3.0",2.25,"3/15-4/15 or 7/15-9/1","3/15-4/15 or 7/15-9/1","to 10-15o F"]
["pea, winter","CB (L)",4000,"L",30,30,30,30,"1.5 - 3.0",2.25,"7/15-10/15 or 11/15 - 3/15","7/15-10/15 or 11/15-3/15","to -10o F","Yes"]
["Phacelia","CB",225000,"S",4,4,4,4,"0.25 - 0.5",0.5,"3/15-5/15 or 7/15-8/15","3/15-5/15 or 7/15-9/1","to 20-25o F"]
["radish","CB (Br)",25000,"M",4,4,6,6,"0.25 - 0.5",0.5,"3/15 - 5/15 or 7/15-8/20","3/15 -  5/15 or 7/1-9/15","to 15-20o F"]
["rapeseed/canola","CB (Br)",140000,"S",4,4,4,4,"0.25 - 0.75",0.5,"3/15-5/15 or 7/1-9/15","3/15-5/15 or 7/1-10-1","to 10-15o F"]
["Rye, Cereal:  Elbon","CG",22000,"M",35,35,40,40,"0.75 - 2.0",1.5,"8/1-10/15 or 11/15 - 3/15","8/1-11/1 or 11/15-3/15","Yes","Yes"]
["Rye, Cereal: VNS Northern","CG",15000,"M",45,45,50,50,"0.75 - 2.0",1.5,"8/1-10/15 or 11/15 - 3/15","8/1-11/1 or 11/15-3/15","Yes","Yes"]
["ryegrass (annual)","CG",190000,"S",15,15,15,15,"0.25 - 0.5",0.5,"3/15-5/15 or 8/1-9/15","3/15-5/15 or 8/1-11/1","to 0o F"]
["safflower","WB",15000,"M",15,15,15,15,"1.0 - 1.5",1.25,"3/15-5/1 or 8/1-9/1","3/15-5/1 or 8/1-9/15","to 25o F"]
["sorghum, forage","WG",16000,"M",5,5,5,5,"0.5 - 1.5",1,"5/15-8/15","5/15-8/15","No"]
["sorghum, grain","WG",16000,"M",5,5,5,5,"0.5 - 1.5",1,"5/15-8/15","5/15-8/15","No"]
["sorghum-sudan hybrid","WG",17000,"M",20,20,20,20,"0.5 - 1.5",1,"5/15-8/15","5/15-8/15","No"]
["soybean","WB (L)",3000,"L",0,30,45,45,"1.0 - 1.5",1.25,"6/1-8/15","5/1-8/15","No"]
["sudangrass","WG",30000,"M",12,12,12,12,"0.5 - 1.5",1,"5/15-8/15","5/15-8/15","No"]
["sunflower","WB",8000,"L",3,3,3,3,"0.5 - 1.0",0.75,"5/15-8/15","5/15-8/15","No"]
["Sunn Hemp","WB (L)",15000,"M",10,10,10,10,"0.5 - 1.0",0.75,"6/1-8/1","6/1-8/1","No"]
["Teff","WG",1000000,"VS",8,8,8,8,"0 - 0.25",0.125,"6/1-7/1","5/15-7/15","No"]
["triticale, winter","CG",15000,"M",45,45,50,50,"0.5 - 1.5",1,"8/1-9/15","8/1-10/15","Yes"]
["triticale,spring","CG",15000,"M",45,45,50,50,"0.5 - 1.5",1,"3/15-5/1 or 8/1-9/1","3/15-5/1 or 8/1-9/15","to 15-20o F"]
["turnip","CB (Br)",170000,"S",3,3,3,3,"0.25 - 0.5",0.5,"3/15 - 5/15 or 7/15-8/20","3/15 -  5/15 or 7/1-9/15","to 10-15o F"]
["Turnip, Hybrid Grazing","CB (Br)",160000,"S",4,4,6,6,"0.25 - 0.75",0.5,"3/15-5/10 or 7/1-8/20","3/15-5/10 or 7/1-9/15","to 10-15o F"]
["vetch, common","CB (L)",8000,"L",20,20,20,20,"1.0 - 2.0",1.5,"3/15-4/15 or 7/1-9/15","3/15-4/15 or 7/1-9/15","to 10-15o F"]
["vetch, hairy","CB (L)",14000,"M",0,15,15,15,"0.5 - 1.5",1,"3/15 - 5/15 or 8/1-9/1 or 11/15-3/15","3/15 - 5/15 or 8/1-10/15 or 11/15 - 3/15","Yes","Yes"]
["vetch, woolypod (Lana)","CB (L)",10000,"L",15,15,15,15,"0.5 - 1.0",0.75,"3/15-4/15 or 7/1-9/1","3/15-4/15 or 7/1-9/15","to 10-15o F"]
["wheat (winter)","CG",15000,"M",45,45,50,50,"0.75 - 2.0",1.25,"8/15-9/20","8/15-10/15","Yes"]

{"sheet":"Species Guide","index":3,"n_rows":68,"n_cols":21,"rows_kept":68,"cut":false,"hidden":false,"merged":[[62,0,62,3],[62,6,62,7]]}
["Cover Crop","Crop Type","Biomass Production (lbs/ac)","Lasting Residue","Erosion Reduction","Soil Builder","N Scavenger","Improve availablity of P & K","Capture, recycle, redistribute nutrients in the soil profile","Promote biological nitrogen fixation ","Total N (lbs/ac)","Weed suppression","Allelopathic","Provide supplemental hay","Provide supplemental grazing","Plant Water Use *","Minimize / reduce soil compaction","Attract Beneficial Insects","Pollinator Habitat","Seedbed for grass seeding","Dormant Seeding"]
["African Cabbage","CB (Br)","200-3000",2,3,3,3,1,2,null,"0-75",3,1,1,2,5,3,1,null,1]
["Alfalfa","WB (L)","200-10000",2,3,4,3,3,5,"Y","70-220",4,3,5,5,4,3,4,"Y",1]
["barley, spring","CG","1000-9000","4",4,4,4,4,3,null,"5-40",4,3,4,4,2,3,1,null,3]
["barley, winter","CG","1000-9000","4",4,4,4,4,3,null,"5-41",4,3,4,4,2,3,1,null,3]
["buckwheat","WB","1000-5000","1",1,2,1,5,5,null,"10-50",2,3,1,1,2,1,5,"Y",1]
["camelina","CB","200-9000",2,3,4,3,3,3,null,"5-65",4,4,2,3,1,3,3,"Y",1,"Yes"]
["chickling vetch","CB (L)","200-4000",1,3,3,1,5,5,"Y","5-100",3,3,2,3,1,3,4,"Y",0]
["chickpea (desi-type)","WB (L)","150-2000",1,1,1,2,4,4,"Y","5-40",2,2,1,1,1,2,3,"Y",1]
["chicory","WB","150-5000",4,1,2,2,2,1,null,"5-50",2,1,1,1,4,2,3,"Y",1]
["clover, arrowleaf","CB (L)","3000-4000",2,3,4,2,3,5,"Y","5-100",2,2,4,5,3,3,3,"Y",1]
["clover, Balansa","CB (L)","150-3000",2,3,4,2,4,5,"Y","5-220",4,2,3,5,3,3,3,"Y",1]
["clover, Berseem","CB (L)","150-3000","2",3,4,4,4,5,"Y","5-220",4,2,4,5,3,3,3,"Y",1]
["clover, Crimson","CB (L)","200-5500","2",3,3,3,4,5,"Y","5-130",4,2,5,5,3,3,4,"Y",1]
["clover, Persian","CB (L)","200-3000",2,3,3,2,4,5,"Y","5-150",3,2,4,5,3,3,4,"Y",1]
["clover, red","CB (P, L)","200-5000","2",3,3,3,4,5,"Y","5-150",3,3,4,5,2,3,4,"Y",1,"Yes"]
["clover, sweet","CB (B, L)","200-5000",2,4,3,2,4,5,"Y","5-100",3.5,2,4,5,3,4,4,"Y",1,"Yes"]
["corn (BMR)","WG","750-12000",4,4,5,5,4,5,null,"10-100",3,3,3,5,5,5,1,null,5]
["cowpea","WB (L)","500-5000","2",3,2,4,3,3,"Y","10-150",2,3,3,5,4,3,4,"Y",1]
["faba bean","CB (L)","500-5000","2",3,2,2,3,3,"Y","10-100",2,2,3,5,4,3,4,"Y",1]
["flax","CB","150-1500",4,3,3,3,3,3,null,"5-20",1,3,1,1,3,2,3,"Y",1]
["Forage collards","CB (Br)","500-3000",1,2,5,4,4,5,null,"5-100",3,4,0,4,5,5,2,null,1]
["Kale","CB (Br)","500-3001",1,2,3,4,4,5,null,"5-100",3,4,0,4,5,5,null,null,1]
["lentil, spring","CB (L)","200-1000",2,1,1,2,3,1,"Y","0-20",3,1,1,1,1,1,2,"Y",1]
["lentil, winter","CB (L)","200-1001",2,1,1,2,3,1,"Y","0-20",3,2,1,1,1,1,2,"Y",1]
["millet, foxtail (German)","WG","500-8000",4,3,3,4,3,3,null,"10-120",3,3,4,3,1,3,1,null,1]
["millet, pearl","WG","1000-10000",4,4,5,4,3,3,null,"10-151",5,1,4,4,1,3,1,null,3]
["millet, proso","WG","500-4000",3,3,3,4,3,3,null,"10-65",3,1,4,3,2,3,1,null,3]
["mung beans","CB (L)","500-5000","2",2,1,1,3,3,"Y","10-150",2,2,3,5,5,3,4,"Y",1]
["mustard, brown, oriental or yellow","CB (Br)","200-9000",2,3,4,3,3,3,null,"5-100",4,4,2,3,2,3,4,"Y",1]
["oats, black","CG","200-10000",3,4,4,4,2,3,null,"10-120",4,4,5,5,3,4,1,null,3]
["oats, spring","CG","200-10000",3,4,4,4,2,3,null,"10-120",4,4,5,5,3,4,1,null,3]
["oats, winter","CG","200-10000",3,4,4,4,2,3,null,"10-120",4,4,5,5,3,4,1,null,3]
["pea, spring field ","CB (L)","200-5000",1,2,3,1,3,3,"Y","90-150",2,2,5,4,1,2,4,"Y",2]
["pea, spring forage","CB (L)","200-5000",1,2,3,1,3,3,"Y","90-150",2,2,5,4,1,2,4,"Y",2]
["pea, winter","CB (L)","200-5000",1,2,3,1,3,3,"Y","90-150",1,2,5,4,1,2,4,"Y",2,"Yes"]
["Phacelia","CB","150-5000",3,5,5,3,3,3,null,"5-50",4,1,2,1,3,4,4,"Y",1]
["radish","CB (Br)","200-7000",1,2,2,5,4,5,null,"5-100",2,4,0,4,5,5,3,"Y",1]
["rapeseed/canola","CB (Br)","200-5000",1,2,5,4,4,5,null,"5-100",3,4,0,4,3,5,3,"Y",1]
["Rye, Cereal: Elbon","CG","200-10000",5,5,5,5,4,5,null,"5-50",5,3,4,5,5,4,1,null,1,"Yes"]
["Rye, Cereal: VNS Northern","CG","200-10001",5,5,5,5,4,5,null,"5-50",5,3,4,4,5,4,1,null,1,"Yes"]
["ryegrass (annual)","CG","200-9000",4,5,5,4,3,5,null,"5-50",5,3,3,3.5,4,4,2,null,3]
["safflower","WB","200-5000",2,3,4,4,4,5,null,"5-100",3,3,0,1,3,4,3,"Y",1]
["sorghum, forage","WG","1000-12000",4,5,5,4,3,5,null,"15-150",5,5,5,5,5,5,3,null,3]
["sorghum, grain","WG","200-8000",4,5,5,4,3,5,null,"15-150",5,5,5,5,3,5,3,null,5]
["soybean","WB (L)","500-5000",2,2,1,4,3,3,"Y","50-80",3,3,3,5,3,1,3,null,3]
["sudangrass","WG","1000-8000",4,5,5,4,3,5,null,"15-150",5,5,5,5,4,5,3,null,5]
["sudan-sorghum hybrid","WG","1000-12000",4,5,5,4,3,5,null,"15-150",5,5,5,5,5,5,3,null,3]
["sunflower","WB","200-5000",5,3,3,3,4,3,null,"10-100",2,2,0,2,4,3,5,"Y",1]
["Sunn Hemp","WB (L)","1000-7000",4,2,3,2,4,2,"Y","100-200",3,3,0,2,4,3,3,null,0]
["Teff",null,"200-5000",3,2,3,2,3,3,null,"5-40",2,0,3,3,4,4,2,null,1]
["triticale, winter","CG","200-6000",4,4,4,3,3,5,null,"5-50",4,3,4,3,5,3,2,null,3]
["triticale,spring","CG","200-5000","4",3,4,3,3,5,null,"5-51",4,0,3,3,5,3,2,null,3]
["turnip","CB (Br)","200-2000",1,2,1,4,4,5,null,"5-100",2,1,0,4,5,5,3,"Y",1]
["Turnip, Hybrid Grazing","CB (Br)","200-3000",1,2,1,4,4,5,null,"5-100",1,1,0,4,5,5,null,null,1]
["vetch, common","CB (L)","200-2000",1,3,3,2,4,5,"Y","5-100",3,3,3,3,2,3,5,"Y",0]
["vetch, hairy","CB (L)","200-5000",1,3,3,2,4,5,"Y","5-200",3,3,3,3,2,3,5,"Y",0,"Yes"]
["vetch, woolypod (Lana)","CB (L)","4000-8000",1,3,3,3,3,5,"Y","5-250",3,3,2,5,2,3,4,"Y",0]
["wheat (winter)","CG","200-8000",4,5,4,4,3,3,null,"5-50",4,2,4,3,4,3,2,null,1]
[]
["* Most data taken from ARS Cover Crop Chart"]
[]
["Crop types",null,null,null,null,null,"Ratings"]
["CG = cool season grass",null,"B = Biennial",null,null,null,"1 - poor/low"]
["CB - cool season broadleaf",null,"P = Perennial",null,null,null,"2 - fair/med low"]
["WB = warm season broadleaf",null,"Br = Brassica",null,null,null,"3 - good/medium"]
["WG = warm season grass",null,"L = Legume",null,null,null,"4 - very good/med high"]
[null,null,null,null,null,null,"5 - excellent/high"]

{"sheet":"Photo Sheet","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Insert Photo(s) or additional planning specifications on this page."]

{"sheet":"Veg Zones","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}