{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["NJ Guidance","NJ Cover Crop Design Worksheet","Cover Crop Certification Sheet","Cover Crop Nutrient Sheet","Seed PLS Calculation Example","Data Table","Cover Crop Characteristics","References"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"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":"NJ Guidance","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["New Jersey Cover Crop Design Worksheet Guidance"]

{"sheet":"NJ Cover Crop Design Worksheet","index":1,"n_rows":59,"n_cols":27,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[23,0,23,11],[46,6,46,7],[47,6,47,7],[2,8,2,11],[3,8,3,11],[4,8,4,11],[8,10,8,11],[9,10,9,11],[10,10,10,11],[12,10,12,11],[9,5,9,9],[9,0,9,3],[10,0,10,3],[25,8,25,11],[25,0,25,7],[12,0,12,3],[0,8,0,11],[48,6,48,7],[49,6,49,7],[21,0,21,11],[6,1,6,11],[19,0,19,3],[19,5,19,9],[41,6,41,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[26,7,26,9],[26,4,26,6],[8,5,8,9],[8,0,8,3],[22,0,22,11],[11,0,11,11],[13,0,13,3],[13,5,13,9],[14,0,14,3],[14,5,14,9],[13,10,13,11],[7,0,7,11],[50,6,50,7],[51,6,51,7],[38,6,39,7],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[58,0,58,11],[57,2,57,7],[57,9,57,11],[55,0,55,11],[24,0,24,9],[54,0,54,11],[56,0,56,1],[57,0,57,1],[56,9,56,11],[56,2,56,7],[52,11,53,11],[52,8,53,9],[52,6,52,7],[32,6,32,8],[32,9,32,11],[5,8,5,11],[20,0,20,11],[51,1,51,2],[40,1,40,2],[41,1,41,2],[10,5,10,9],[12,5,12,9],[28,7,28,9],[27,0,27,3],[27,4,27,6],[27,7,27,9],[33,1,33,5],[15,0,15,11],[16,0,16,3],[38,0,39,0],[33,9,33,11],[32,1,32,5],[33,6,33,8],[30,1,30,11],[28,0,28,3],[28,4,28,6],[17,0,17,3],[18,0,18,3],[16,5,16,9],[17,5,17,9],[18,5,18,9],[82,16,82,17],[70,16,70,18],[74,16,74,17],[72,16,72,18],[38,3,39,3],[38,4,39,4],[38,5,39,5],[38,9,39,9],[38,11,39,11],[38,14,39,14],[38,12,39,12],[53,0,53,3],[50,1,50,2],[53,4,53,5],[49,1,49,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[42,1,42,2],[43,1,43,2],[52,0,52,2],[44,1,44,2],[45,1,45,2],[40,6,40,7],[38,21,39,21],[38,20,39,20],[38,17,39,17],[38,16,39,16],[38,13,39,13],[38,8,39,8],[38,19,39,19],[38,18,39,18],[36,1,36,2],[38,15,39,15],[38,1,39,2],[38,10,39,10],[34,8,36,11],[34,6,36,7],[36,3,36,4],[34,1,34,5]]}
["NEW JERSEY COVER CROP DESIGN WORKSHEET PAGE 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program","Fertilizer","Seeding Meth.","Termination","Site Prep"]
[]
["Name:",null,null,null,null,null,"Program:",null,null,null,null,null,null,null,null,null,null,null,null,"EQIP - Cropland"]
["Address:",null,null,null,null,null,"Contract#:",null,null,null,null,null,null,null,null,null,null,null,null,"EQIP - RCCP"]
["Field Number(s):",null,null,null,null,null,"CIN(s):",null,null,null,null,null,null,null,null,null,null,null,null,"EQIP - Soil Health"]
["Tract Number (s):",null,null,null,null,null,"Farm # (s):",null,null,null,null,null,null,null,null,null,null,null,null,"EQIP - Organic"]
["Location:","The location of the planned cover crops is shown on the Conservation Plan Map included in the folder.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMA"]
["Purpose(s) of the cover crop (check all that apply):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CTA","None","Drill / Planter","Frost"]
["Minimize Soil Compaction ",null,null,null,null,"Suppress Weeds and Break Pest Cycles",null,null,null,null,null,null,null,null,null,null,null,null,null,"CSP","Fertilizer","Broadcast","Mow","None - Aerial"]
["Maintain or Increase Soil Health and Organic Matter Content",null,null,null,null,"Reduce Erosion\n% Full Rate must be between 130% to 160%\nSmall grain based seedings must have a minimum of 25 seeds/ft2\nAnnual ryegrass based seedings must have a minimum of 125 seeds/ft2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Innoculate",null,"Tillage","Chemical Burn Down"]
["Utilize Excessive Nutrients",null,null,null,null,"Improve Soil Moisture Effeciency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer and Innoculant",null,"Burn Down","Disk - in After Broadcast"]
["Additional considerations for planning cover crop (check all that apply):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harvest - Graze","Harrow or Cultipacker After Broadcast"]
["Biological Nitrogen Fixation",null,null,null,null,"Seedbed Preparation for Grass Seeding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harvest - Hay/Straw","Tillage"]
["Attract Pollinators",null,null,null,null,"Increase Biodiversity",null,null,null,null,null,null,null,null,null,null,null,null,null,"Check ",null,null,"Crimper","No-till after burn down"]
["Supplemental Hay or Grazing\n% Full Rate must be ≥ 150%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,"No-till without other site prep"]
["Soil Health Concerns (Only applicable to EQIP - Soil Health contracts)"]
["Nutrient Losses",null,null,null,null,"Weeds"]
["Nitrogen Fixation",null,null,null,null,"Subsoil Compaction and Infiltration"]
["Organic Matter and Overall Structure",null,null,null,null,"Topsoil Compaction and Infiltration"]
["Erosion"]
["Description of Work"]
["A cover crop will be planted for either fall/winter or spring/summer cover. The cover crop will be planted between growing seasons when the ground is traditionally bare or non-active. The cover crop will not be harvested for seed or burned. The cover crop must be terminated according to the NRCS Cover Crop Termination Guidelines.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Management Considerations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
["Are soil ammendments needed or will soil ammendments be used? \nIf yes, use the NJ Cover Crop Nutrient Sheet to document nutrient recommendations, or attach nutrient recommendations."]
["NEW JERSEY COVER CROP DESIGN WORKSHEET PAGE 2"]
[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":""},{"$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(Z2=\"\",\"\",\"Be aware of forage value and potential nutritional side effects such as bloat or high nitrates\")","v":""},null,{"$f":"IF(AA2=\"\",\"\",\"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:",null,null,null,null,null,"Termination Method:"]
["Seeding Date(s):",null,null,null,null,null,"Fertilizer and/or innoculant:"]
["Seeding Method:",null,null,null,null,null,"Termination Growth Stage:",null,"Terminate cover crop at or within 5 days after planting but before crop emergence."]
[]
["Acres to be seeded:",null,null,"Hardiness Zone:"]
[]
["Species List","Minimum Rate",null,"Lbs PLS / Acre","% Full Rate","% by # seed","Seed/ft2",null,"Crop Type","Seed Size",null,"Average Seeding Depth","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(A41=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U41,U41,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V41,V41,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A2:$S35,15,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(D41>0,D41/B41,0)","v":0},{"$f":"IF(D41>0,G41/G53,0)","v":0},{"$f":"M41*N41/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A41=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A41,'Data Table'!A3:S33,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A41=\"\",0,VLOOKUP(A41,'Data Table'!A3:J30,10,FALSE))","v":0},{"$f":"$B$37*D41","v":0},{"$f":"IF(A41=\"\",\"\",(N41/M53))","v":""},{"$f":"IF(D41>0,D41/B41,0)","v":0},{"$f":"IF(A41=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A41,'Data Table'!A2:S35,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A41,'Data Table'!A2:S35,15,FALSE)))))","v":""},{"$f":"IF(A41=\"\",\"\",((O41+P41)/2)*(Q41))","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A41=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A41,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A41,'Data Table'!A3:C30,3,FALSE)))))","v":""},{"$f":"IF(A41=\"\",\"\",(U41*1.5))","v":""}]
[null,{"$f":"IF(A42=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U42,U42,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V42,V42,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A3:$S36,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D42>0,G42/G53,0)","v":0},{"$f":"M42*N42/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A42=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A42,'Data Table'!A3:S34,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A42=\"\",0,VLOOKUP(A42,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A42=\"\",\"\",(N42/M53))","v":""},0,{"$f":"IF(A42=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A42,'Data Table'!A2:S36,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A42,'Data Table'!A2:S36,15,FALSE)))))","v":""},"",{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A42=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A42,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A42,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A43=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U43,U43,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V43,V43,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A4:$S37,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D43>0,G43/G53,0)","v":0},{"$f":"M43*N43/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A43=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A43,'Data Table'!A3:S35,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A43=\"\",0,VLOOKUP(A43,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A43=\"\",\"\",(N43/M53))","v":""},0,{"$f":"IF(A43=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A43,'Data Table'!A2:S37,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A43,'Data Table'!A2:S37,15,FALSE)))))","v":""},"",{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A43=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A43,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A43,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A44=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U44,U44,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V44,V44,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A5:$S38,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D44>0,G44/G53,0)","v":0},{"$f":"M44*N44/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A44=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A44,'Data Table'!A3:S36,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A44=\"\",0,VLOOKUP(A44,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A44=\"\",\"\",(N44/M53))","v":""},0,{"$f":"IF(A44=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A44,'Data Table'!A2:S38,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A44,'Data Table'!A2:S38,15,FALSE)))))","v":""},"",{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A44=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A44,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A44,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A45=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U45,U45,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V45,V45,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A6:$S39,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D45>0,G45/G53,0)","v":0},{"$f":"M45*N45/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A45=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A45,'Data Table'!A3:S37,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A45=\"\",0,VLOOKUP(A45,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A45=\"\",\"\",(N45/M53))","v":""},0,{"$f":"IF(A45=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A45,'Data Table'!A2:S39,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A45,'Data Table'!A2:S39,15,FALSE)))))","v":""},"",{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A45=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A45,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A45,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A46=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U46,U46,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V46,V46,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A6:$S40,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D46>0,G46/G53,0)","v":0},{"$f":"M46*N46/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A46=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A46,'Data Table'!A3:S38,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A46=\"\",0,VLOOKUP(A46,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A46=\"\",\"\",(N46/M53))","v":""},0,{"$f":"IF(A46=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A46,'Data Table'!A2:S40,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A46,'Data Table'!A2:S40,15,FALSE)))))","v":""},"",{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A46=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A46,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A46,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A47=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U47,U47,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V47,V47,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A6:$S41,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D47>0,G47/G53,0)","v":0},{"$f":"M47*N47/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A47=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A47,'Data Table'!A3:S39,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A47=\"\",0,VLOOKUP(A47,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A47=\"\",\"\",(N47/M53))","v":""},0,{"$f":"IF(A47=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A47,'Data Table'!A2:S41,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A47,'Data Table'!A2:S41,15,FALSE)))))","v":""},"",{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A47=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A47,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A47,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A48=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U48,U48,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V48,V48,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A6:$S42,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D48>0,G48/G53,0)","v":0},{"$f":"M48*N48/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A48=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A48,'Data Table'!A3:S40,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A48=\"\",0,VLOOKUP(A48,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A48=\"\",\"\",(N48/M53))","v":""},0,{"$f":"IF(A48=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A48,'Data Table'!A2:S42,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A48,'Data Table'!A2:S42,15,FALSE)))))","v":""},"",{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A48=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A48,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A48,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A49=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U49,U49,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V49,V49,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A7:$S43,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D49>0,G49/G53,0)","v":0},{"$f":"M49*N49/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A49=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A49,'Data Table'!A3:S41,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A49=\"\",0,VLOOKUP(A49,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A49=\"\",\"\",(N49/M53))","v":""},0,{"$f":"IF(A49=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A49,'Data Table'!A2:S43,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A49,'Data Table'!A2:S43,15,FALSE)))))","v":""},"",{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A49=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A49,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A49,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A50=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U50,U50,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V50,V50,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A8:$S44,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D50>0,G50/G53,0)","v":0},{"$f":"M50*N50/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A50=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A50,'Data Table'!A3:S42,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A50=\"\",0,VLOOKUP(A50,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A50=\"\",\"\",(N50/M53))","v":""},0,{"$f":"IF(A50=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A50,'Data Table'!A2:S44,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A50,'Data Table'!A2:S44,15,FALSE)))))","v":""},"",{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A50=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A50,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A50,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A51=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U51,U51,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V51,V51,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A11:$S45,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D51>0,G51/G53,0)","v":0},{"$f":"M51*N51/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A51=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A51,'Data Table'!A3:S43,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A51=\"\",0,VLOOKUP(A51,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A51=\"\",\"\",(N51/M53))","v":""},0,{"$f":"IF(A51=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A51,'Data Table'!A2:S45,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A51,'Data Table'!A2:S45,15,FALSE)))))","v":""},"",{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A51=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A51,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A51,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
[null,{"$f":"IF(A52=\"\",\"\",IF(B35=\"Drill / Planter\",(VLOOKUP(U52,U52,1,FALSE)),IF(B35=\"Broadcast\",(VLOOKUP(V52,V52,1,FALSE)))))","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,'Data Table'!$A11:$S46,15,FALSE))","v":{"$error":"#REF!"}},null,0,{"$f":"IF(D52>0,G52/G53,0)","v":0},{"$f":"M52*N52/(B37*43560)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,'Data Table'!A3:B30,2,FALSE))","v":""},{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,'Data Table'!$A3:$S33,11,FALSE))","v":""},null,{"$f":"IF(A52=\"\",\"\",IF(B35=\"Drill / Planter\",VLOOKUP(A52,'Data Table'!A3:S44,7,FALSE),(IF(B35=\"Broadcast\",\"Surface\"))))","v":""},{"$f":"IF(A52=\"\",0,VLOOKUP(A52,'Data Table'!A3:J30,10,FALSE))","v":0},0,{"$f":"IF(A52=\"\",\"\",(N52/M53))","v":""},0,{"$f":"IF(A52=\"\",\"\",IF(J37=\"Early to Mid Vegetative\",(VLOOKUP(A52,'Data Table'!A2:S46,14,FALSE)),IF(J37=\"Late Vegatative\",\"\",(VLOOKUP(A52,'Data Table'!A2:S46,15,FALSE)))))","v":""},"",{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,'Data Table'!A2:Q35,7,FALSE))","v":""},null,{"$f":"IF(A52=\"\",\"\",IF(F37=\"6a to 6b\",(VLOOKUP(A52,'Data Table'!A3:C30,3,FALSE)),IF(F37=\"7a to 7b\",(VLOOKUP(A52,'Data Table'!A3:C30,3,FALSE)))))","v":""},""]
["LBS PLS/ ACRE = ",null,null,{"$f":"SUM(D41:D52)","v":0},{"$f":"SUM(E41:E52)","v":0},null,{"$f":"SUM(G41:G52)","v":{"$error":"#DIV/0!"}},null,"Total lbs. Needed:",null,null,{"$f":"SUM(N41:N52)","v":0},null,null,null,null,null,{"$f":"SUM(R41:R52)","v":0},{"$f":"IF(L41=\"\",\"\",SUM(S41:S52)/COUNTIF(S41:S52,\">0\"))","v":""}]
["Planned Average Seeding Depth (in):\n(if Drilled/Planted)",null,null,null,{"$f":"IF(A41=\"\",\"\",IF(S53<=0.5,\"0.25 - 0.5\",IF(S53<=0.75,\"0.5 - 0.75\",IF(AND(S53>0.75,S53<=1),\"0.75 - 1.0\",IF(AND(S53>1,S53<=1.75),\"1.0 - 1.75\",\"1.75 - 3\")))))","v":""},{"$f":"IF(#REF!=\"\",\"\",IF(G56=0.5,\"0.25 - 0.5\",IF(G56<=0.75,\"0.5 - 0.75\",IF(AND(G56>0.75,G56<=1),\"0.75 - 1.0\",IF(AND(G56>1,G56<=1.75),\"1.0 - 1.75\",\"1.75 - 3\")))))","v":{"$error":"#REF!"}}]
["All seed rates are represented in Pure Live Seed. It is the responsibility of the producer to ensure the purity, germination, and amount of seed applied equals the planned seeding rates."]
["Operation and Maintenance\nEvaluate the cover crop to determine if the cover crop is meeting the planned purpose(s). If the cover crop is not meeting the purpose(s) adjust the management, change the species of cover crop, or choose a different technology."]
["Planned by:",null,null,null,null,null,null,null,"Date: ",{"$f":"TODAY()","v":"2019-01-10"}]
["*Producer Signature:",null,null,null,null,null,null,null,"Date: "]
["*The producer is only required to sign the Cover Crop Design Worksheet if it is modified from the original conservation plan."]

{"sheet":"Cover Crop Certification Sheet","index":2,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,0,46,10],[47,0,47,10],[48,1,48,6],[48,7,48,8],[48,9,48,10],[45,1,45,6],[45,7,45,8],[45,9,45,10],[29,0,29,10],[30,0,32,10],[33,0,33,10],[34,0,34,10],[35,0,35,10],[36,0,36,10],[37,0,37,10],[38,0,38,10],[39,0,39,10],[40,0,43,10],[44,0,44,10],[21,0,21,1],[21,7,21,8],[28,0,28,10],[22,0,22,1],[22,7,22,8],[23,0,23,1],[23,7,23,8],[24,0,24,1],[24,7,24,8],[25,0,25,1],[25,7,25,8],[26,0,26,1],[26,7,26,8],[27,0,27,1],[16,0,16,1],[16,7,16,8],[17,0,17,1],[17,7,17,8],[18,0,18,1],[18,7,18,8],[19,0,19,1],[19,7,19,8],[20,0,20,1],[20,7,20,8],[15,0,15,1],[15,7,15,8],[11,0,14,1],[11,2,14,2],[11,3,14,3],[11,4,14,4],[11,5,14,5],[11,6,14,6],[11,7,14,8],[2,1,2,5],[2,6,2,7],[2,8,2,10],[3,1,3,5],[3,6,3,7],[3,8,3,10],[4,1,4,5],[4,6,4,7],[4,8,4,10],[0,0,0,7],[11,9,14,9],[11,10,14,10],[7,0,10,10],[1,12,1,19],[5,12,5,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[9,12,9,15],[10,12,10,15],[11,12,11,15],[12,12,12,15],[13,12,13,15],[14,12,14,15],[2,12,2,15],[3,12,3,15],[5,1,5,5],[5,6,5,7],[5,8,5,10],[6,5,6,8],[2,16,2,19],[3,16,3,19],[5,16,5,19],[6,16,6,19],[7,16,7,19],[8,16,8,19],[9,16,9,19],[10,16,10,19],[11,16,11,19],[16,16,16,19],[4,12,4,19],[17,12,17,19],[18,12,18,15],[19,12,19,15],[18,16,18,19],[19,16,19,19],[15,12,15,15],[16,12,16,15],[12,16,12,19],[13,16,13,19],[14,16,14,19],[15,16,15,19],[20,16,20,19],[21,16,21,19],[22,16,22,19],[23,16,23,19],[24,16,24,19],[25,12,25,15],[26,12,26,15],[27,12,27,15],[28,12,28,15],[20,12,20,15],[21,12,21,15],[22,12,22,15],[23,12,23,15],[24,12,24,15],[30,12,30,19],[31,12,31,15],[32,12,32,15],[33,12,33,15],[34,12,34,15],[25,16,25,19],[26,16,26,19],[27,16,27,19],[28,16,28,19],[29,16,29,19],[29,12,29,15],[40,12,40,15],[41,12,41,15],[42,12,42,15],[31,16,31,19],[32,16,32,19],[33,16,33,19],[34,16,34,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,19],[42,16,42,19],[35,12,35,15],[36,12,36,15],[37,12,37,15],[38,12,38,15],[39,12,39,15]]}
["NJ Cover Crop Certification"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pounds Planted Calculator"]
["Name:",{"$f":"'NJ Cover Crop Design Worksheet'!B3","v":0},null,null,null,null,"Program:",null,{"$f":"'NJ Cover Crop Design Worksheet'!J3","v":0},null,null,null,"Weight of Bag ="]
["Address:",{"$f":"'NJ Cover Crop Design Worksheet'!B4","v":0},null,null,null,null,"Contract #:",null,{"$f":"'NJ Cover Crop Design Worksheet'!J4","v":0},null,null,null,"Lbs Planted/Acre of Mix ="]
["Field Number(s):",{"$f":"'NJ Cover Crop Design Worksheet'!B5","v":0},null,null,null,null,"CIN (s):",null,{"$f":"'NJ Cover Crop Design Worksheet'!J5","v":0},null,null,null,"% of Species in Mix (decimal form) "]
["Tract Number (s):",{"$f":"'NJ Cover Crop Design Worksheet'!B6","v":0},null,null,null,null,"Farm # (s):",null,{"$f":"'NJ Cover Crop Design Worksheet'!J6","v":0},null,null,null,{"$f":"A16","v":0}]
[null,null,null,null,{"$f":"IF('NJ Cover Crop Design Worksheet'!E4=\"\",\"\",'NJ Cover Crop Design Worksheet'!E4)","v":""},null,null,null,null,null,null,null,{"$f":"A17","v":0}]
["Document producer's actual cover crop planting information below.  \nCollect seed tags for the cover crops planted or enter the purity and germination information in the boxes below.\nAttach photos of the cover crop.\nRed Line on the Conservation Plan Map areas where seeded (if not the entire field) or use GPS.",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Species ",null,"Pounds Planned PLS/Acre","Pounds Planted/Acre","Purity","Germination","lbs/ac PLS","Actual Seeding Rate PLS",null,"Lbs Needed to Meet Required PLS","Amount Over Planned PLS Rate",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'NJ Cover Crop Design Worksheet'!A41","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D41","v":0},null,null,null,{"$f":"(E16*F16)/100","v":0},{"$f":"(G16/100)*D16","v":0},null,{"$f":"(1/(G16/100))*C16","v":{"$error":"#DIV/0!"}},{"$f":"H16-C16","v":0},null,0]
[{"$f":"'NJ Cover Crop Design Worksheet'!A42","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D42","v":0},null,null,null,{"$f":"(E17*F17)/100","v":0},{"$f":"(G17/100)*D17","v":0},null,{"$f":"(1/(G17/100))*C17","v":{"$error":"#DIV/0!"}},{"$f":"H17-C17","v":0},null,0]
[{"$f":"'NJ Cover Crop Design Worksheet'!A43","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D43","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,"Lbs of Species/Bag"]
[{"$f":"'NJ Cover Crop Design Worksheet'!A44","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D44","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,{"$f":"A16","v":0},null,null,null,{"$f":"Q3*Q6","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A45","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D45","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,{"$f":"A17","v":0},null,null,null,{"$f":"Q3*Q7","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A46","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D46","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q8","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A47","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D47","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q9","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A48","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D48","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q10","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A49","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D49","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q11","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A50","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D50","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q12","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A51","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D51","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q13","v":0}]
[{"$f":"'NJ Cover Crop Design Worksheet'!A52","v":0},null,{"$f":"'NJ Cover Crop Design Worksheet'!D52","v":0},null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,0,null,null,null,{"$f":"Q3*Q14","v":0}]
["Total Lbs:",null,{"$f":"SUM(C16:C27)","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"Q3*Q15","v":0}]
["Practice Check-Out Conditions",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"Q3*Q16","v":0}]
["Seeding Method",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"Q3*Q17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lbs Planted/Acre by Species (enter values in column D)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A16","v":0},null,null,null,{"$f":" Q19*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A17","v":0},null,null,null,{"$f":" Q20*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
["Date Seeded",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q21*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q22*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
["Acres Seeded With This Mix",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q23*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q24*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
["Nutrients Applied (if applicable)",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q25*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
["Refer to the Cover Crop Nutrient Sheet to document nutrients and ammendments applied, or a attach nutrient recommendations and applied records. ",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q26*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
["Additional Notes or Comments",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q27*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q28*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q29*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":" Q30*(Q4/Q3)","v":{"$error":"#DIV/0!"}}]
[]
["This practice was implemented according to the signed Conservation Plan and the NJ Cover Crop Design Worksheet. The practice meets the Standards and Specifications and/or any additional requirements set forth in state policy needed to meet the criteria for the planned purpose(s) of the practice. The Operation and Maintenance requirements of the practice have been effectively communicated to the client and prompt follow through is reasonably expected."]
["NRCS Certifying Planner:",null,null,null,null,null,null,"Date Certified:"]
["This practice was not implemented according to the specifications in the signed Conservation Plan/and or Implementation Requirements. The deficiencies of the practice are not acceptable and do not meet the Standards, Specifications, and/or any additional requirements set forth in state policy. This practice as implemented can not be certified. The following deficiencies are listed below:"]
[]
["NRCS Certifying Planner:",null,null,null,null,null,null,"Date Certified:"]

{"sheet":"Cover Crop Nutrient Sheet","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["Cover Crop Nutrient Sheet"]
["Soil Ammendments (if needed) or attach nutrient management recommendations"]
["Field #","N (lbs./acre)","K2O (lbs./acre)","P2O5 (lbs./acre)","Lime (tons/acre)"]

{"sheet":"Seed PLS Calculation Example","index":4,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,0,23,4],[23,5,23,10],[24,0,24,4],[25,0,25,4],[24,5,24,10],[25,5,25,10],[15,0,15,10],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[16,0,16,2],[17,4,17,7],[18,4,18,7],[19,4,19,7],[16,4,16,10],[4,7,4,8],[5,7,5,8],[6,7,6,8],[12,7,12,8],[13,7,13,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[13,0,13,1],[9,0,9,1],[10,0,10,1],[7,0,7,1],[8,0,8,1],[1,7,1,8],[0,0,0,10],[1,0,1,1],[2,0,2,1],[3,0,3,1],[2,7,2,8],[3,7,3,8],[4,0,4,1],[5,0,5,1],[26,0,26,4],[26,5,26,10],[27,0,27,4],[27,5,27,10],[22,0,22,10],[20,4,20,7],[17,8,17,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[14,0,14,1],[6,0,6,1],[11,0,11,1],[12,0,12,1]]}
["Mixed Species Cover Crop PLS Example"]
["Species ",null,"Pounds Planned PLS/Acre","Pounds Planted/Acre","Purity","Germination","lbs/ac PLS","Actual Seeding Rate PLS",null,"Lbs Needed to Meet Required PLS","Amount Over Planned PLS Rate"]
["Annual Ryegrass",null,10,23.4,100,90,{"$f":"(E3*F3)/100","v":90},{"$f":"(G3/100)*D3","v":21.06},null,{"$f":"(1/(G3/100))*C3","v":11.111111111111111},{"$f":"H3-C3","v":11.059999999999999}]
["Crimson Clover",null,4,4.7300000000000004,100,85,{"$f":"(E4*F4)/100","v":85},{"$f":"(G4/100)*D4","v":4.0205000000000002},null,{"$f":"(1/(G4/100))*C4","v":4.7058823529411766},{"$f":"H4-C4","v":2.0500000000000185E-2}]
["Radish",null,3,4.55,100,90,90,4.0949999999999998,null,3.3333333333333335,1.0949999999999998]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0,null,"  "]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,null,{"$error":"#DIV/0!"},0]
["Total Lbs:",null,{"$f":"SUM(C3:C14)","v":17}]
["Seeding Mix Calculations"]
["Cover Crop Mix Information",null,null,null,"Lbs/Species/Bag = (Bag Weight)(% species in decimal form)"]
["Bag Weight",null,"50 lbs",null,"Lbs Annual Ryegrass",null,null,null,"(50)(.669) = 33.45"]
["% Annual Ryegrass",null,0.66900000000000004,null,"Lbs Crimson Clover",null,null,null,"(50)(.134) = 6.75"]
["% Crimson Clover",null,0.13400000000000001,null,"Lbs Radish",null,null,null,"(50)(.130) = 6.5"]
["% Radish",null,0.13,null,"Total lbs PLS/Bag",null,null,null,46.7]
[]
["Seeding Rate/Species/Acre = (Lbs/Species in bag)(% lbs of bag planted)"]
["Planned Seeding Rate",null,null,null,null,35]
["% Lbs of bag planted\nSeeding Rate/Bag Weight",null,null,null,null,"35/50 = .7"]
["Lbs Annual Ryegrass Planted",null,null,null,null,"(33.45)(.7) = 23.42 "]
["Lbs Crimson Clover Planted",null,null,null,null,"(6.75)(.7) = 4.73"]
["Lbs Radish Planted",null,null,null,null,"(6.5)(.7) = 4.55"]
[]
["Weight of Bag"]
["Planned Seeding Rate"]
["% Purity Species 1",null,"Weight times percent"]
["% Purity Species 2"]
["% Purity Species 3"]

{"sheet":"Data Table","index":5,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,15,1,15],[0,16,1,16],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,0,14],[0,7,1,7],[0,3,0,4],[0,6,1,6],[31,0,31,2],[32,0,32,1],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,5,1,5]]}
["Cover Crop Spp.","Crop Type","Full Rate Drill/Planter lbs/ac  ","Plant Hardiness Zones",null,"Seeding Depth","Average Seeding Depth","Winter Hardy","Allelopathic","Seeds per lb","seed size","C:N Ratios at Termination of the Growing Cover Crop",null,null,null,"N Fixation","Erosion Reduction"]
[null,null,null,"6a to 6b","7a to 7b",null,null,null,null,null,null,"C:N Ratio (Early to Mid Vegetative)","C:N Ratio (late Vegetative)","C:N Ratio value #  Early to Mid Vegetative","C:N Ratio value #  Late Vegetative to reproductive"]
["barley","CG",95,"8/1 - 9/31","8/15 - 10/15","0.75 - 2.0",1.5,"to 15-20o F","Y",13600,"M","M","H",15,25,"N","G"]
["buckwheat","WB",50,"7/1 - 8/1","6/15 - 7/30","0.5 - 1.5",1,"No","Y",18000,"M","L","L",5,5,"N","G"]
["canola /rapeseed","CB",5,"8/1 - 9/15","9/1 - 10/1","0.25 - 0.75",0.5,"to 10-15o F","Y",140000,"S","L","L",5,5,"N","F"]
["clover, Berseem","CBL",7,"8/1 - 8/31","8/15 - 9/15","0.25 - 0.75",0.5,"to 20o F",null,162000,"S","L","L",5,5,"Y","G"]
["clover, Crimson","CBL",15,"8/15 - 9/15","9/1 - 10/1","0.25 - 0.75",0.5,"to -10o F",null,150000,"S","L","L",5,5,"Y","G"]
["clover, red","CBL (P)",10,"8/15 - 9/15","9/1 - 10/1","0.25 - 0.75",0.5,"to -20o F","Y",270000,"S","L","L",5,5,"Y","G"]
["clover, subterranean","CBL",24,"10/1 - 10/15","10/1 - 10/15",".25 - .5",0.375,"to 15oF","Y",54000,"S","L","L",5,5,"Y","G"]
["clover, white","CBL (P)",3,"8/1 - 9/15","8/15 - 10/1","0.25 - 1",0.625,null,"Y",504000,"S","L","L",5,5,"Y","G"]
["cowpea","WBL",50,"Up to 6/15","Up to 7/1","1.0 - 1.5",1.25,"No","Y",4000,"L","L","L",5,5,"Y","P"]
["millet, proso","WG",14,"5/1 - 6/15","5/15 - 7/1","0.25 - 0.75",0.5,"No",null,965000,"M","M","M",15,15,"N","F"]
["mustards","CB",12,"7/15 - 9/1","7/15 - 9/1","0.25 - 0.75",0.5,"No","Y",100000,"S","M","M",15,15,"N","F"]
["oats (spring)","CG",90,"8/1 - 10/15","9/1 - 10/31","0.5 - 1.5",1,"to 25o F","Y",15000,"M","L","M",5,15,"N","F"]
["pea, austrian winter","CBL",50,"8/1 - 9/15","8/15 - 10/1","1.5 - 3.0",2.25,"to -10o F",null,4100,"L","L","L",5,5,"Y","P"]
["Phacelia","CB",7,"3/15-5/15 or 8/1-9/1","3/15-5/15 or 8/1-9/1","0.25 - 0.5",0.375,"to 20-25o F",null,225000,"S","L","L",5,5,"N","G"]
["radish","CB",6,"8/1 - 9/15","9/1 - 10/1","0.25 - 0.5",0.375,"to 15-20o F",null,30000,"M","L","L",5,5,"N","G"]
["rye (cereal)","CG",90,"8/1 - 10/31","9/1 - 10/31","0.75 - 2.0",1.375,"to -30o F","Y",18000,"M","M","H",15,25,"N","G"]
["ryegrass (annual)","CG",20,"8/1 - 9/15","9/1 - 10/31","0.25 - 0.5",0.375,"to 0o F",null,163000,"S","M","M",15,15,"N","G"]
["safflower","WB",15,"4/1 - 5/1","4/1 - 5/1","1.0 - 1.5",1.25,"to 25o F",null,15000,"M","M","M",15,15,"N","G"]
["soybean","WBL",50,"5/15 - 7/1","5/1-7/15","1.0 - 1.5",1.25,"No",null,2500,"L","L","L",5,5,"Y","F"]
["sudan-sorghum hybrid","WB",35,"5/1 - 5/31","4/15 - 4/30","0.5 - 1.5",1,"No","Y",18000,"M","H","H",35,25,"N","G"]
["sunflower","WB",5,"5/15 - 8/15","5/15 - 8/15","0.5 - 1.0",0.75,"No","Y",6000,"L","M","M",15,15,"N","P"]
["Sunn Hemp","WBL",10,"Up to 8/15","Up to 9/15","0.5 - 1.0",0.75,"No",null,15000,"M","M","H",15,25,"Y","G"]
["sweetclover","CBL (B)",10,"8/1 - 9/15","8/15 - 10/1","0.25 - 1.0",0.625,"to -20o F","Y",238000,"S","L","L",5,5,"Y","G"]
["teff grass","CG",5,"5/15 - 7/1","5/15 - 7/1",0.25,0.25,"to 32o F",null,1300000,"S","L","L",5,5,"N","F"]
["triticale","CB",90,"8/1-10/31","9/1-10/31","0.5 - 1.5",1,"to -20o F",null,15000,"M","M","H",15,25,"N","G"]
["turnip","CB",3,"8/1 - 9/15","9/1 - 10/1","0.25 - 0.5",0.375,"to 10-15o F",null,207000,"S","L","L",5,5,"N","F"]
["vetch, hairy or crown","CBL",20,"8/1 - 9/15","9/1 - 10/1","0.5 - 1.5",1,"to -20o F","Y",18000,"M","L","L",5,5,"Y","G"]
["wheat (winter)","CG",110,"8/1 - 10/31","9/1 - 10/31","0.75 - 2.0",1.375,"to -20o F","Y",12000,"M","M","H",15,25,"N","G"]
[]
["Cover Crop - Crop Type Symbology"]
["CG - Cool season grass\nCB - Cool season broadleaf\nCBL - Leguminous cool season broadleaf\nWG - Warm season grass\nWB - Warm season broadleaf\nWBL - Leguminous warm season broadleaf\n(P) - Perennial\n(B) - Biennial\n"]

{"sheet":"Cover Crop Characteristics","index":6,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,16],[34,0,34,11],[35,0,35,11],[36,0,36,11],[37,0,37,11],[32,0,32,2],[31,0,31,2]]}
["Cover Crop Species Selection Guide"]
["Cover Crop","Crop Type","Biomass Production (lbs/ac)","N Scavenger","Promote biological nitrogen fixation ","Total N (lbs/ac)","Organic Matter and Structure","Erosion Reduction","Weed suppression","Subsoil Compaction and Infiltration","Topsoil Compaction and Infiltration","Lasting Residue","Improve availablity of P & K","Allelopathic","Provide supplemental grazing/hay","Attract Beneficial Insects1","Pollinator Habitat1"]
["barley, spring","CG","2000-9000",4,null,null,4,5,4,3,4,5,3,4,4,2]
["buckwheat","WB","2000-4000",1,null,null,3,2,5,1,4,1,5,4,1,5,"Y"]
["canola /rapeseed","CB","2000-5000",4,null,null,3,4,4,3,3,3,2,4,3,4,"Y"]
["clover, Berseem","CBL","6000-10000",4,5,"75-220",4,4,5,2,4,3,4,2,5,3,"Y"]
["clover, Crimson","CBL","3500-5500",3,4,"70-130",4,4,4,2,3,3,3,2,5,4,"Y"]
["clover, red","CBL (P)","2000-5000",3,4,"70-150",4,3,4,4,4,2,4,3,4,4,"Y"]
["clover, subterranean","CBL","3000 - 8500",2,5,"75-200",4,4,5,1,2,4,2,4,4,4,"N"]
["clover, white","CBL (P)","2000 - 6000",2,5,"80 - 200",3,4,4,2,4,2,2,3,5,3,"Y"]
["cowpea","WBL","2500-4500",2,5,"100-150",3,5,5,4,4,2,3,1,3,4,"Y"]
["millet, proso","WG","3000 - 5000",3,null,null,4,3,3,2,4,null,null,null,4,null,"N"]
["mustards2","CB","3000-9000",3,null,null,4,4,4,2,4,2,3,4,3,3,"Y"]
["oats","CG","2000-10000",4,null,null,3,4,5,1,4,3,2,4,4,1,"N"]
["pea, austrian winter","CBL","4000-5000",2,5,"90-150",3,4,3,2,4,2,2,2,4,4,"Y"]
["Phacelia","CB","3300-6000",4,null,null,3,3,4,1,5,null,null,null,null,5,"Y"]
["radish","CB","4000-7000",5,null,null,3,4,5,5,3,2,4,4,3,4,"Y"]
["rye (cereal)","CG","3000-10000",5,null,null,5,5,5,2,5,5,4,5,3,2,"N"]
["ryegrass (annual)","CG","2000-9000",4,null,null,4,4,4,3,5,4,3,3,4,2,"N"]
["safflower","WB",null,5,null,null,3,3,3,4,3,null,null,null,3,null,"Y"]
["soybean3","WBL","5000-10000",2,4,"50-80",1,1,3,2,3,null,null,null,3,4,"N"]
["sudan-sorghum hybrid","WB","8000-10000",5,null,null,5,5,4,5,3,4,3,5,4,3,"Y"]
["sunflower","WB",null,5,null,null,3,3,3,3,2,null,null,3,null,5,"Y"]
["Sunn Hemp","WBL","5000-14000",3,5,"100-200",5,3,4,5,3,null,4,4,4,4,"Y"]
["sweetclover","CBL (B)","3000-5000",2,5,"90-170",5,4,4,5,5,4,5,2,4,4,"Y"]
["teff","CG",null,4,null,null,5,4,5,1,3,null,null,null,5,null,"N"]
["triticale","CB","4000 - 7000",5,null,null,5,5,5,3,5,5,null,null,3,null,"N"]
["turnip","CB","4000 - 6700",5,null,null,1,2,4,5,5,2,3,3,3,null,"N"]
["vetch, hairy or crown","CBL","2300-5000",2,5,"90-200",4,3,3,3,4,2,3,3,3,5,"Y"]
["wheat (winter)4","CG","3000-8000",4,null,null,4,4,4,3,4,4,4,2,4,3,"N"]
[]
["Cover Crop - Crop Type Symbology"]
["CG - Cool season grass\nCB - Cool season broadleaf\nCBL - Leguminous cool season broadleaf\nWG - Warm season grass\nWB - Warm season broadleaf\nWBL - Leguminous warm season broadleaf\n(P) - Perennial\n(B) - Biennial\n"]
[]
["1 Any species planted for beneficial insects or for pollinator habitat needs to be planted in the spring/summer or allowed to flower before termination for insects to benefit. "]
["2  While mustards can utilized for pollinator habitat, they can be an alternate host for cabbage root maggott and flea beetles."]
["3 Attracts beneficial insects, especially when there is an abundance of prey. Seed treated with systemic insecticides could have a negative effect."]
["4 Provides good winter cover for beneficial insects"]

{"sheet":"References","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["References"]
["Barnes, M., J. Andrae, D. Gunter, and G. Yarrow. 2014. Quick Reference Guide to Wildlife Plantings. Clemson Cooperative Extension.\n\nClark, Andy. 2007. Managing cover crops profitably. 3rd ed.  Sustainable Agriculture Research and Education.\n\nClark, Shawna. 2011 A Comprehensive Guide to Cover Crop Species Used in the Northeast United States. USDA - NRCS Big Flats Plant Materials Center. \n\nCurran, B. and D. Lingenfelter. 2015. The Penn State Agronomy Guide 2015 - 2016. Penn State University College of Agricultural Sciences.\n\nGill, Kelly, personal communication, 2015.\n\nLiebig, 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\n\nMidwest Cover Crop Council. Midwest Cover Crops Field Guide.\n\nNyamusamba, Rutendo. 2014. Growing Teff Grass. South Dakota University Extension. http://igrow.org/agronomy/other-crops/growing-teff-grass/\n\nSheahan, Chris, personnal communication, 2015."]