{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Information","Planned","Actual","Data","Cover crop periodic table"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":102,"n_cols":9,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,0,2,4],[67,0,67,3],[67,5,67,8]]}
[]
["Cover Crop (340) "]
[]
["Natural Resource Conservation Service - Wyoming",null,null,null,null,null,null,null,"2017-11-01"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Example 7-way cool season multi-species mix.",null,null,null,null,"Example 8-way warm season multi-species mix."]
[]
[null,"Cover crop"," PLS Lbs/ac",null,null,"Cover crop","PLS Lbs/ac"]
[null,"Vetch, Hairy ",5,null,null,"Proso Millet",3]
[null,"Pea, Austrian",15,null,null,"Grazing corn",5]
[null,"Clover, Crimson",2,null,null,"Sunflower",1]
[null,"Triticale",10,null,null,"Radish",1]
[null,"Oats",5,null,null,"Favabean",15]
[null,"Turnip",1,null,null,"Sunn Hemp",5]
[null,"Radish",1,null,null,"Crimson clover",2]
[null,"Total",{"$f":"SUM(C71:C77)","v":39},null,null,"BMR sorghum",5]
[null,null,null,null,null,"Total ",{"$f":"SUM(G71:G78)","v":37}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"replace photo caitlin"]

{"sheet":"Planned","index":1,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,2,2,3],[46,2,46,4],[46,6,46,9],[25,6,25,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[1,1,1,3],[34,0,34,1],[0,0,0,7],[11,6,11,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7]]}
["Cover Crop 340  Design Job Sheet - NRCS Wyoming"]
["Name:"," "]
["Tract and Field Number: ",null," "]
["Acres:"," "]
["Soil map unit:",null," "]
["Purposes: indicate the decision-makers objectives for applying cover crops",null,null,null,null,null,null,null," "]
[" ","Reduced erosion from wind and water",null,null,null,null," ","Improve soil moisture efficiency"]
[" ","Maintain or increase soil health and organic matter",null,null,null,null," ","Minimize soil compaction"]
[null,"Reduce water quality degradation by utilizing excessive soil nutrients"]
[" ","Suppress excessive weed pressure and break pest cycles",null,null,null,null," "]
[null,null,null,null,null,null," ","Provide supplemental grazing"]
["Plant Species",null,"Cultivar","Seed Rate                            PLS                                         Lbs/ac","Seeds                           per                                Lbs","Seed                         per                            Acre","Total PLS Planned Lbs/field"]
["LEGUMES"]
["",null," "," ",{"$f":"IF(OR(A14=\"\",A14=0),\"\",VLOOKUP(A14,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},{"$f":"IF(OR(A14=\"\",A14=0,D14=\"\",D14=0),\"\",E14*D14)","v":""},{"$f":"IF(OR(A14=\"\",A14=0,D14=\"\",D14=0),\"\",D14*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A15=\"\",A15=0),\"\",VLOOKUP(A15,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",""]
["",null,null,null,{"$f":"IF(OR(A16=\"\",A16=0),\"\",VLOOKUP(A16,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",""]
["",null," "," ",{"$f":"IF(OR(A17=\"\",A17=0),\"\",VLOOKUP(A17,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},{"$f":"IF(OR(A17=\"\",A17=0,D17=\"\",D17=0),\"\",E17*D17)","v":""},""]
["",null," "," ",{"$f":"IF(OR(A18=\"\",A18=0),\"\",VLOOKUP(A18,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",""]
["",null,null,null,{"$f":"IF(OR(A19=\"\",A19=0),\"\",VLOOKUP(A19,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",""]
["GRASSES"]
["",null," "," ",{"$f":"IF(OR(A21=\"\",A21=0),\"\",VLOOKUP(A21,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A21=\"\",A21=0,D21=\"\",D21=0),\"\",D21*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A22=\"\",A22=0),\"\",VLOOKUP(A22,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A22=\"\",A22=0,D22=\"\",D22=0),\"\",D22*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A23=\"\",A23=0),\"\",VLOOKUP(A23,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A23=\"\",A23=0,D23=\"\",D23=0),\"\",D23*$B$4)","v":""}]
[null,null,null,null,{"$f":"IF(OR(A24=\"\",A24=0),\"\",VLOOKUP(A24,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},{"$f":"IF(OR(A24=\"\",A24=0,D24=\"\",D24=0),\"\",E24*D24)","v":""},{"$f":"IF(OR(A24=\"\",A24=0,D24=\"\",D24=0),\"\",D24*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A25=\"\",A25=0),\"\",VLOOKUP(A25,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},{"$f":"IF(OR(A25=\"\",A25=0,D25=\"\",D25=0),\"\",E25*D25)","v":""},{"$f":"IF(OR(A25=\"\",A25=0,D25=\"\",D25=0),\"\",D25*$B$4)","v":""}]
["BRASSICAS"]
["",null,"  ",null,{"$f":"IF(OR(A27=\"\",A27=0),\"\",VLOOKUP(A27,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A27=\"\",A27=0,D27=\"\",D27=0),\"\",D27*$B$4)","v":""}]
["",null," ",null,{"$f":"IF(OR(A28=\"\",A28=0),\"\",VLOOKUP(A28,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A28=\"\",A28=0,D28=\"\",D28=0),\"\",D28*$B$4)","v":""}]
["",null,null," ",{"$f":"IF(OR(A29=\"\",A29=0),\"\",VLOOKUP(A29,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A29=\"\",A29=0,D29=\"\",D29=0),\"\",D29*$B$4)","v":""}]
["",null,null," ",{"$f":"IF(OR(A30=\"\",A30=0),\"\",VLOOKUP(A30,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A30=\"\",A30=0,D30=\"\",D30=0),\"\",D30*$B$4)","v":""}]
["BROADLEAFS"]
["",null,null,null,{"$f":"IF(OR(A32=\"\",A32=0),\"\",VLOOKUP(A32,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A32=\"\",A32=0,D32=\"\",D32=0),\"\",D32*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A33=\"\",A33=0),\"\",VLOOKUP(A33,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A33=\"\",A33=0,D33=\"\",D33=0),\"\",D33*$B$4)","v":""}]
["",null,null,null,{"$f":"IF(OR(A34=\"\",A34=0),\"\",VLOOKUP(A34,Data!$A$3:$E$120,Data!C$121,FALSE))","v":""},"",{"$f":"IF(OR(A34=\"\",A34=0,D34=\"\",D34=0),\"\",D34*$B$4)","v":""}]
["Total",null,null,{"$f":"SUM(D14:D34)","v":0},null,{"$f":"SUM(F14:F34)","v":0},{"$f":"IF(A35=\"\",\"\",D35*$B$4)","v":{"$error":"#VALUE!"}}]
[]
["Planned Seeding date:",null," "]
["Planned termination date:",null," "]
["Planned termination method:"]
["Additional specifications and notes: (planting method, rate & application method of nutrients)."]
["If grazed leave 40% above ground biomass."]
[]
[]
[]
[]
["The producer has received a copy of the planned practice specifications and understands the contents and requirements."]
[null,"Producer:",null,null,null,"Planner:"]
[null,"Date:"," "]
[null,null,null,null,null,null,null,null,null,"NRCS, WY"]
[null,null,null,null,null,null,null,null,null,"2017-11-01"]

{"sheet":"Actual","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,0,29,1],[1,1,1,4],[2,2,2,4],[6,0,6,1],[4,1,4,3]]}
["Cover Crop 340  Certification Job Sheet - NRCS Wyoming"]
["Name:"]
["Tract and Field(s) Number: ",null,{"$f":"IF(Planned!C3=\"\",\"\",Planned!C3)","v":" "}]
["Acres:"]
["Soil map unit:",{"$f":"IF(Planned!C5=\"\",\"\",Planned!C5)","v":" "}]
[]
["Actual Plant Species",null,"Actual Seeding Rate         Lbs/ac","Percent Pure Seed","Percent Germination","Actual Total PLS Planted lbs/ac"]
["LEGUMES"]
["",null," "," "," ",{"$f":"IF(A9=\"\",\"\",IF(OR(#REF!=\"\",D9=\"\",E9=\"\"),\"\",#REF!*D9/100*E9/100))","v":""}]
["",null,null," "," ",{"$f":"IF(A10=\"\",\"\",IF(OR(C9=\"\",D10=\"\",E10=\"\"),\"\",C9*D10/100*E10/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(OR(C11=\"\",D11=\"\",E11=\"\"),\"\",C11*D11/100*E11/100))","v":""}]
["",null,null,null,null,""]
["",null,null,null,null,""]
["",null,null,null,null,""]
["GRASSES"]
["",null,null,null,null,{"$f":"IF(A16=\"\",\"\",IF(OR(C16=\"\",D16=\"\",E16=\"\"),\"\",C16*D16/100*E16/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A17=\"\",\"\",IF(OR(C17=\"\",D17=\"\",E17=\"\"),\"\",C17*D17/100*E17/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A18=\"\",\"\",IF(OR(C18=\"\",D18=\"\",E18=\"\"),\"\",C18*D18/100*E18/100))","v":""}]
[null,null,null,null,null,{"$f":"IF(A19=\"\",\"\",IF(OR(C19=\"\",D19=\"\",E19=\"\"),\"\",C19*D19/100*E19/100))","v":""}]
[null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",IF(OR(C20=\"\",D20=\"\",E20=\"\"),\"\",C20*D20/100*E20/100))","v":""}]
["BRASSICAS"]
["",null,null,null,null,{"$f":"IF(A22=\"\",\"\",IF(OR(C22=\"\",D22=\"\",E22=\"\"),\"\",C22*D22/100*E22/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A23=\"\",\"\",IF(OR(C23=\"\",D23=\"\",E23=\"\"),\"\",C23*D23/100*E23/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A24=\"\",\"\",IF(OR(C24=\"\",D24=\"\",E24=\"\"),\"\",C24*D24/100*E24/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A25=\"\",\"\",IF(OR(C25=\"\",D25=\"\",E25=\"\"),\"\",C25*D25/100*E25/100))","v":""}]
["BROADLEAFS"]
["",null,null,null,null,{"$f":"IF(A27=\"\",\"\",IF(OR(C27=\"\",D27=\"\",E27=\"\"),\"\",C27*D27/100*E27/100))","v":""}]
["",null," "," "," ",{"$f":"IF(A28=\"\",\"\",IF(OR(C28=\"\",D28=\"\",E28=\"\"),\"\",C28*D28/100*E28/100))","v":""}]
["",null,null,null,null,{"$f":"IF(A29=\"\",\"\",IF(OR(C29=\"\",D29=\"\",E29=\"\"),\"\",C29*D29/100*E29/100))","v":""}]
["TOTAL",null,{"$f":"SUM(C9:C29)","v":0},null,null,{"$f":"SUM(F9:F29)","v":0}]
[]
["Certification:  "]
["I (planner) certify that this practice has been installed in accordance with NRCS standards and specifications."]
[]
["Producer:"]
["Planner:"]
["Date:",null,null,null,null,null,null,null,"NRCS,  WY"]
[null,null,null,null,null,null,null,null,"2017-11-01"]

{"sheet":"Data","index":3,"n_rows":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"approximate Seeds /lbs"]
["Legumes"]
["Alfalfa",null,220000,227000]
["Bean, Faba",null,2000]
["Bean, Mung",null,7000]
["Bean, Pinto",null,1500]
["Clover, Arrowleaf",null,270000]
["Clove, Alsike",null,450000]
["Clover, Crimson",null,120000]
["Clover, Red",null,240000]
["Clover, sweet",null,220000]
["Clover, Ladino",null,502500]
["Clover, Balansa",null,500000]
["Clover, Subterrinean",null,150000]
["Clover, Rose"]
["Clover, Persian",null,150000]
["Clover Berseem",null,175000]
["Cowpeas",null,4100]
["Quar",null,12000]
["Lentils, spring",null,21000]
["Lentils, winter",null,15000]
["Medic",null,300000]
["Pea, spring",null,3200]
["Pea, Austrian winter",null,4000]
["Pea, chick",null,2200]
["Pea, forage",null,3500]
["Soybean",null,3000]
["Sainfoin",null,18500]
["Sunn Hemp",null,15000]
["Vetch, common",null,8000]
["Vetch, Hairy",null,16300]
["Vetch, Woolly Pod",null,10000]
["Vetch, Chickling",null,2500]
[]
[]
["Grasses"]
[]
["Annual Ryegrass",null,190000]
["Barley, Forage",null,13000]
["Barley, spring",null,13000]
["Barley, winter",null,13600]
["Oats, ",null,19600]
["Oats, Black",null,22000]
["Oats, forage",null,19600]
["Rye, Cereal",null,18200]
["Ryegrass",null,190000]
["Triticale, winter",null,22700]
["Triticale. Spring",null,22700]
["Wheat, spring",null,11400]
["Wheat, winter",null,11400]
[" Millet, Pearl",null,82300]
["Corn",null,2500,"varies"]
["Corn, BMR Grazing",null,2500,"varies"]
["Millet, Brown Top",null,180000]
["Millet, Foxtail",null,220000]
["Millet, German",null,180000]
["Millet, Japanese",null,120000]
["Millet, Proso",null,120000]
["Sorgum",null,18000]
["Sorghum, Forage",null,18000]
["Sorgum, Brown Mid Rib",null,18000]
["Sorghum, grain",null,17000]
["Sudangrass",null,22000]
["Sorghum Sudangrass",null,18000]
["Teff",null,1300000]
["Eqyptian wheat , (sorghum)",null,18000]
["Brassicas"]
["Arugula",null,180000]
["Beets, sugar",null,10000]
["Brassica, Hybrid forage",null,175000]
["Cabbage, Africian",null,180000]
["Camelina",null,400000]
["Canola, Winter RR",null,100000]
["Collards, Impact Forage",null,175000]
["Kale",null,175000]
["Mustard, Brown",null,100000]
["Mustard, FL Broadleaf",null,100000]
["Mustard, Spirng",null,100000]
["Mustard, white",null,100000]
["Mustard, Winter",null,100000]
["Mustard, Yellow",null,100000]
["Radish",null,25000]
["Radish, Defender",null,25000]
["Radish, Diakon,",null,25000]
["Radish, Graza",null,25000]
["Radish, Tillage",null,25000]
["Rape",null,175000]
["Turnip, ",null,175000]
["Turnip, Purple top",null,175000]
["Turnip, Winfred hybrid",null,175000]
["Tyfon"]
[]
[]
["Broadleaf"]
["Buckwheat",null,20000]
["Chicory",null,400000]
["Flax",null,80000]
["Flower mix",null,750000,"varies"]
["Okra",null,7200]
["Phacelia",null,225000]
["Plantain",null,200000]
["Safflower, \"Baldy\" spineless",null,15000]
["Sugar Beet, Non GMO",null,36000]
["Sunflower, Black oil",null,8000]
["Amaranth",null,27000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["cc","password protect"]
[]
[1,2,3,4,5]

{"sheet":"Cover crop periodic table","index":4,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,0,24,4],[14,2,14,3],[1,1,1,8],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[2,6,3,8],[2,0,2,5]]}
[]
[null,"Cover Crop Periodic Table, Wyoming NRCS Soil Health"]
["Cool Season",null,null,null,null,null,"Warm Season"]
[]
[null,null,null,null,"Broadleaf"]
["Grass","Brassica ",null,null,null,null,null,null,"Grass"]
["Italian Ryegrass","Camalina",null,null,null,null,null,null,"Teff"]
["Annual Ryegrass","Africian Cabbage",null,null,null,null,null,null,"Browntop Millet"]
["Black Oat","Hybrid Brassicas",null,null,null,"    Legumes",null,null,"German Millet"]
["Cereal Rye","Kale","Phacelia",null,"Ladino Clover","Balansa Clover","Sunn Hemp","Chicory","Foxtail Millet"]
["Winter Triticale","Rapeseed","Plantain",null,"Alsike Clover","Arrow leaf Clover","Guar","Pollinator Mix","Proso Millet"]
["Spring Triticale","Turnips","Pollinator Plants",null,"Alfalfa","Red Clover","Mungbean","Buckwheat","Japanese Millet"]
["Oat ","Hybrid Turnips","Flax",null,"Sweet Clover","Persian Clover","Cowpea","Safflower","Pearl Millet"]
["Forage Oat","Forage Collards","Beets",null,"Berseem Clover","Crimson Clover","Soybean","Sunflower","Sudangrass"]
["Winter Wheat","Canola"," ",null,"Winter Lentil","Spring Lentil",null,"Okra","Sorghum Sudan"]
["Spring Wheat","Broadleaf\nMustard",null,null,"Hariy Vetch","Woolypod Vetch",null,"Melons & Squash","Forage Sorghum"]
["Spring Forage\nBarley","Mustard",null,null,"Common Vetch","Winter Pea",null,null,"Egyptian Wheat"]
["Winter Barley","Radish",null,null,"Spring Pea","Chickpea",null,null,"Grain Sorghum"]
["Beardless: Triticale, Barley, Wheat","Oil Seed Radish  ",null,null,"Chickling Vetch","Faba Bean",null,null,"BMR Grazing types "]
[null,null,null,null,null,null,null,null,"Corn"]
["Cover crops listed from smallest seed to largest in columns.  (many seeds are very similar like brassica family)"]
["Not an all-inclusive list, but should provide the producer with alternatives to develop cover crop mixes."]
["Developed by:"]
["Roger Stockton, NRCS WY, State Agronomist"]
["Marlon Winger, NRCS Soil Health Division WY, MT, & ID"]
[]
["2018-11-14"]
["Revised from: USDA-ARS, staff of the Northern Great Plains Research Laboratory at Mandan, ND."]