{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intensity & Diversity","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Intensity & Diversity","index":0,"n_rows":159,"n_cols":17,"rows_kept":159,"cut":false,"hidden":false,"merged":[[110,7,110,9],[81,8,82,8],[95,8,96,8],[42,1,42,10],[50,8,51,8],[106,8,107,8],[106,3,106,5],[106,10,107,10],[6,1,6,7],[106,7,107,7],[31,6,32,6],[103,3,103,5],[107,3,107,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[12,4,12,6],[20,7,23,7],[103,8,104,8],[31,7,32,7],[103,10,104,10],[18,10,28,10],[18,1,18,7],[31,8,32,10],[7,10,15,10]]}
[]
["Interval Average","grass & broadleaf","winter & spring","cool & warm","grass interval","broadleaf interval"]
[{"$f":"K68","v":0},{"$f":"K70","v":0},{"$f":"K71","v":0},{"$f":"K72","v":0},{"$f":"K102","v":0},{"$f":"K88","v":0}]
[]
[]
[]
[null,"Crop Rotation Intensity and Diversity Worksheet"]
[null,null,null,null,null,null,null,null,null,null,"Make entries or selections in the yellow-shaded areas of the worksheet."]
[null,"Name:",null,null,null,null,"Date:"]
[null,"Tract:"]
[null,"Fields:",null,null,null,null,"Total Acres:"]
[]
[null,"Rotation Intensity Rating:",null,{"$f":"IF(ISERR(H32)=TRUE,0,H32)","v":0},"Rotation Diversity Rating:",null,null,{"$f":"IF(ISERR(K111)=TRUE,0,K111)","v":0}]
[]
[null,null,null,null,"No. of seeding time conflicts"]
[null,null,null,null,"No. of planting vs. harvest, or harvest vs. harvest conflicts"]
[]
[]
[null,"Crop Rotation Intensity Rating for soil water storage and use",null,null,null,null,null,null,null,null,"For additional instructions, click on the \"Instructions\" tab at the lower left of the screen."]
[]
[null,null,null,null,null,null,null,"Choose Crops in Rotation below"]
[null,"Short Season","Full Season","Cover Crops"]
[null,"Crops 1 point:","Crops 2 points:","1 point:"]
[null,null,null,null,null,"Points"]
[null,"Barley","Alfalfa","CS (Cool Season) Broadleaf",null,{"$f":"IF(H25=\"\",$C$122,LOOKUP(H25,$B$122:$B$157,$C$122:$C$153))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H25,$F$122:$I$159,4))=TRUE,0,VLOOKUP(H25,$F$122:$I$159,4))","v":0}]
[null,"Canary Seed","Amaranth","CS (Cool Season) Grass",null,{"$f":"IF(H26=\"\",$C$122,LOOKUP(H26,$B$122:$B$157,$C$122:$C$153))","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H26,$F$122:$I$159,4))=TRUE,0,VLOOKUP(H26,$F$122:$I$159,4))","v":0}]
[null,"Canola","Buckwheat","WS (Warm Season) Broadleaf",null,0,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(H27,$F$122:$I$159,4))=TRUE,0,VLOOKUP(H27,$F$122:$I$159,4))","v":0}]
[null,"Crambe","Chickpea","WS (Warm Season) Grass",null,0,null,null,null,null,null,null,null,null,0]
[null,"Durum Wheat","Corn",null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Field Pea","Cotton",null,null,0,null,null,null,null,null,null,null,null,0]
[null,"Flax","Dry Edible Bean",null,null,0,null,null,null,null,"            ",null,null,null,0]
[null,"Lentil ","Peanut",null,"Total Intensity Points  = ",{"$f":"SUM(F25:F31)","v":0},"=",{"$f":"IF(ISERR(F32/F33)=TRUE,0,F32/F33)","v":0},"  Intensity Rating",null,null,null,null,null,{"$f":"SUM(O25:O31)","v":0}]
[null,"Lupine","Perennial Grass",null,"      Number of Years  = ",{"$f":"COUNTIF(H25:H31,\"*\")","v":0}]
[null,"Millet ","Potato"]
[null,"Mustard","Safflower",null,null,null,"Acres of each crop =",{"$f":"IF(ISERR(H11/F33),0,H11/F33)","v":0},null,null,"            "]
[null,"Oat","Sorghum"]
[null,"Spring Wheat","Soybean",null,null,null,null,null,null,null,"            "]
[null,"Winter Rye","Sudangrass",null," "]
[null,"Winter Wheat","Sugar Beet",null,null,null,null,null,null,null,"            "]
[null,null,"Sunflower"]
[null,null,"Sweetclover "]
[null,null," Summer-Fallow: Score 0 points"]
[null,"Diversity Index for Crop Rotations"]
[]
[null,"1.  Count the number of crops since the same type of crop is used in the rotation for each crop (not to exceed 4)."]
[null,"Add .5 to each broadleaf-type crop if the rotation includes any other broadleaf crop."]
[null,"Add .5 to each grass-type crop if the rotation includes different grass crops of the same crop type."]
[]
[]
[null,{"$f":"IF(ISNA($B$62+(IF($B$56=0,0,IF($B$58>$J$52,($B$58-(7-$J$52)),$B$61))))=TRUE,0,$B$62+(IF($B$56=0,0,IF($B$58>=$J$52,($B$58-(7-$J$52)),$B$61))))","v":0},{"$f":"IF(ISNA(C62+(IF(C56=0,0,IF(C58>$J$52,(C58-(7-$J$52)),C61))))=TRUE,0,C62+(IF(C56=0,0,IF(C58>=$J$52,(C58-(7-$J$52)),C61))))","v":0},0,0,0,0,0,null,null,null,null,null,null,"                                                                                             "]
[null,{"$f":"IF(B50>4,(4+B62),B50)","v":0},0,0,0,0,0,0,"=",{"$f":"SUM(B51:H51)","v":0},"Total Points",null,null,null,"  "]
[null,{"$f":"INDEX(H25:H31,1)","v":0},{"$f":"INDEX(H25:H31,2)","v":0},{"$f":"INDEX(H25:H31,3)","v":0},{"$f":"INDEX(H25:H31,4)","v":0},{"$f":"INDEX(H25:H31,5)","v":0},{"$f":"INDEX(H25:H31,6)","v":0},{"$f":"INDEX(H25:H31,7)","v":0},null,{"$f":"F33","v":0},"Number of Crops"]
["# same type",{"$f":"VLOOKUP(B56,$A$63:$B$66,2)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,"Crops"]
["curr c/w",{"$f":"IF(ISNA(VLOOKUP(B52,$F$123:$H$159,3))=TRUE,0,VLOOKUP(B52,$F$123:$H$159,3))","v":0},0,0,0,0,0,0]
["curr g/b",{"$f":"IF(ISNA(VLOOKUP(B52,$F$123:$H$159,2))=TRUE,0,VLOOKUP(B52,$F$123:$H$159,2))","v":0},0,0,0,0,0,0]
["type code",{"$f":"IF(ISNA(SUM(B54:B55))=TRUE,0,SUM(B54:B55))","v":0},{"$f":"IF(ISNA(SUM(C54:C55))=TRUE,0,SUM(C54:C55))","v":0},0,0,0,0,0]
[null,{"$f":"IF(ISNA(IF(B56=5,\"cool grass\",IF(B56=8,\"warm grass\",IF(B56=9,\"warm broadleaf\",\"cool broadleaf\"))))=TRUE,0,IF(B56=5,\"cool grass\",IF(B56=8,\"warm grass\",IF(B56=9,\"warm broadleaf\",\"cool broadleaf\"))))","v":"cool broadleaf"},"cool broadleaf","cool broadleaf","cool broadleaf","cool broadleaf","cool broadleaf","cool broadleaf"]
["yrs between crop type",{"$f":"IF(B56=H56,0,IF(B56=G56,1,IF(B56=F56,2,IF(B56=E56,3,IF(B56=D56,4,IF(B56=C56,5,6))))))","v":0},{"$f":"IF(C56=B56,0,IF(C56=H56,1,IF(C56=G56,2,IF(C56=F56,3,IF(C56=E56,4,IF(C56=D56,5,6))))))","v":0},{"$f":"IF(D56=C56,0,IF(D56=B56,1,IF(D56=H56,2,IF(D56=G56,3,IF(D56=F56,4,IF(D56=E56,5,6))))))","v":0},{"$f":"IF(E56=D56,0,IF(E56=C56,1,IF(E56=B56,2,IF(E56=H56,3,IF(E56=G56,4,IF(E56=F56,5,6))))))","v":0},{"$f":"IF(F56=E56,0,IF(F56=D56,1,IF(F56=C56,2,IF(F56=B56,3,IF(F56=H56,4,IF(F56=G56,5,6))))))","v":0},{"$f":"IF(G56=F56,0,IF(G56=E56,1,IF(G56=D56,2,IF(G56=C56,3,IF(G56=B56,4,IF(G56=H56,5,6))))))","v":0},{"$f":"IF(H56=G56,0,IF(H56=F56,1,IF(H56=E56,2,IF(H56=D56,3,IF(H56=C56,4,IF(H56=B56,5,6))))))","v":0}]
["same crop > once",{"$f":"IF(B52=H52,1,IF(B52=G52,1,IF(B52=F52,1,IF(B52=E52,1,IF(B52=D52,1,IF(B52=C52,1,0))))))","v":1},{"$f":"IF(C52=B52,1,IF(C52=H52,1,IF(C52=G52,1,IF(C52=F52,1,IF(C52=E52,1,IF(C52=D52,1,0))))))","v":1},{"$f":"IF(D52=C52,1,IF(D52=B52,1,IF(D52=H52,1,IF(D52=G52,1,IF(D52=F52,1,IF(D52=E52,1,0))))))","v":1},{"$f":"IF(E52=D52,1,IF(E52=C52,1,IF(E52=B52,1,IF(E52=H52,1,IF(E52=G52,1,IF(E52=F52,1,0))))))","v":1},{"$f":"IF(F52=E52,1,IF(F52=D52,1,IF(F52=C52,1,IF(F52=B52,1,IF(F52=H52,1,IF(F52=G52,1,0))))))","v":1},{"$f":"IF(G52=F52,1,IF(G52=E52,1,IF(G52=D52,1,IF(G52=C52,1,IF(G52=B52,1,IF(G52=H52,1,0))))))","v":1},{"$f":"IF(H52=G52,1,IF(H52=F52,1,IF(H52=E52,1,IF(H52=D52,1,IF(H52=C52,1,IF(H52=B52,1,0))))))","v":1}]
["same type+crop",{"$f":"B53+B59","v":{"$error":"#N/A"}},{"$f":"C53+C59","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF(B58<1,B58,IF(B56=H56,0,IF(B56=G56,1-(7-$F$33),IF(B56=F56,2-(7-$F$33),IF(B56=E56,3-(7-$F$33),IF(B56=D56,4-(7-$F$33),IF(B56=C56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(C58<1,C58,IF(C56=B56,0,IF(C56=H56,1-(7-$F$33),IF(C56=G56,2-(7-$F$33),IF(C56=F56,3-(7-$F$33),IF(C56=E56,4-(7-$F$33),IF(C56=D56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(D58<2,D58,IF(D56=C56,0,IF(D56=B56,1-(7-$F$33),IF(D56=H56,2-(7-$F$33),IF(D56=G56,3-(7-$F$33),IF(D56=F56,4-(7-$F$33),IF(D56=E56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(E58<3,E58,IF(E56=D56,0,IF(E56=C56,1-(7-$F$33),IF(E56=B56,2-(7-$F$33),IF(E56=H56,3-(7-$F$33),IF(E56=G56,4-(7-$F$33),IF(E56=F56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(F58<4,F58,IF(F56=E56,0,IF(F56=D56,1-(7-$F$33),IF(F56=C56,2-(7-$F$33),IF(F56=B56,3-(7-$F$33),IF(F56=H56,4-(7-$F$33),IF(F56=G56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(G58<5,G58,IF(G56=F56,0,IF(G56=E56,1-(7-$F$33),IF(G56=D56,2-(7-$F$33),IF(G56=C56,3-(7-$F$33),IF(G56=B56,4-(7-$F$33),IF(G56=H56,5-(7-$F$33),6-(7-$F$33))))))))","v":0},{"$f":"IF(H58<6,H58,IF(H56=G56,0,IF(H56=F56,1-(7-$F$33),IF(H56=E56,2-(7-$F$33),IF(H56=D56,3-(7-$F$33),IF(H56=C56,4-(7-$F$33),IF(H56=B56,5-(7-$F$33),6-(7-$F$33))))))))","v":0}]
[null,{"$f":"IF(B53>1,IF(B59=0,0.5,0),0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$f":"COUNTIF($B$56:$H$56,5)","v":0}]
[6,{"$f":"COUNTIF($B$56:$H$56,6)","v":0}]
[8,{"$f":"COUNTIF($B$56:$H$56,8)","v":0}]
[9,{"$f":"COUNTIF($B$56:$H$56,9)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(ISERR(J51/J52)=TRUE,0,(J51/J52))","v":0}]
[]
[null,"2.  Score .5 if rotation includes both grass and broadleaf crop types:",null,null,null,null,null,null,null,null,{"$f":"IF(Q70=2,0.5,0)","v":0},null,null,null,{"$f":"COUNTIF($B$55:$H$55,\"=1\")","v":0},{"$f":"COUNTIF($B$55:$H$55,\"=2\")","v":0},{"$f":"COUNTIF(O70:P70,\">0\")","v":0}]
[null,"3.  Score .5 if rotation includes both fall and spring seeded crops:",null,null,null,null,null,null,null,null,{"$f":"IF(O32>0,0.5,0)","v":0}]
[null,"4.  Score .5 if rotation includes both cool and warm season crops:",null,null,null,null,null,null,null,null,{"$f":"IF(Q72=2,0.5,0)","v":0},null,null,null,{"$f":"COUNTIF($B$54:$H$54,\"=4\")","v":0},{"$f":"COUNTIF($B$54:$H$54,\"=7\")","v":0},{"$f":"COUNTIF(O72:P72,\">0\")","v":0}]
[]
[null,"5.  Broadleaf crop interval (Do not use interval values from step #1)."]
[null,"Total scores for each broadleaf crop and divide by the number of broadleaf crops in the rotation. "]
[null,"Score:","2   if 4 or more years between broadleaf crops in the rotation.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H25=\"\",C121,VLOOKUP(H25,F122:G159,2))","v":0}]
[null,null,"1   if 3 years between broadleaf crops in the rotation.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H26=\"\",C121,VLOOKUP(H26,F122:G159,2))","v":0}]
[null,null,"0   if 2 years between broadleaf crops in the rotation.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H27=\"\",C121,VLOOKUP(H27,F122:G159,2))","v":0}]
[null,null,"-1   if 1 year between broadleaf crops in the rotation.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",C121,VLOOKUP(H28,F122:G159,2))","v":0}]
[null,null,"-2   if 0 years between broadleaf crops in the rotation.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H29=\"\",C121,VLOOKUP(H29,F122:G159,2))","v":0}]
[]
[null,{"$f":"IF(B83=0,0,IF(B86=4,2,IF(B86=3,1,IF(B86=2,0,IF(B86=1,-1,-1)))))","v":0},0,0,0,0,0,0,"=",{"$f":"SUM(B82:H82)","v":0},"Total Points",null,null,null,{"$f":"IF(H30=\"\",C121,VLOOKUP(H30,F122:G159,2))","v":0}]
[null,{"$f":"IF($B$55=2,$B$52,0)","v":0},{"$f":"IF(C55=2,C52,0)","v":0},0,0,0,0,0,null,{"$f":"P70","v":0},"broad-leaf crops",null,null,null,{"$f":"IF(H31=\"\",C121,VLOOKUP(H31,F122:G159,2))","v":0}]
[null,{"$f":"IF(B$55=H$55,0,IF(B$55=G$55,1,IF(B$55=F$55,2,IF(B$55=E$55,3,IF(B$55=D$55,4,IF(B$55=C$55,5,6))))))","v":0},{"$f":"IF(C$55=B$55,0,IF(C$55=H$55,1,IF(C$55=G$55,2,IF(C$55=F$55,3,IF(C$55=E$55,4,IF(C$55=D$55,5,6))))))","v":0},{"$f":"IF(D$55=C$55,0,IF(D$55=B$55,1,IF(D$55=H$55,2,IF(D$55=G$55,3,IF(D462=F$55,4,IF(D$55=E$55,5,6))))))","v":0},{"$f":"IF(E$55=D$55,0,IF(E$55=C$55,1,IF(E$55=B$55,2,IF(E$55=H$55,3,IF(E$55=G$55,4,IF(E$55=F$55,5,6))))))","v":0},{"$f":"IF(F$55=E$55,0,IF(F$55=D$55,1,IF(F$55=C$55,2,IF(F$55=B$55,3,IF(F$55=H$55,4,IF(F$55=G$55,5,6))))))","v":0},{"$f":"IF(G$55=F$55,0,IF(G$55=E$55,1,IF(G462=D$55,2,IF(G$55=C$55,3,IF(G$55=B$55,4,IF(G$55=H$55,5,6))))))","v":0},{"$f":"IF(H$55=G$55,0,IF(H$55=F$55,1,IF(H$55=E$55,2,IF(H$55=D$55,3,IF(H$55=C$55,4,IF(H$55=B$55,5,6))))))","v":0}]
[{"$f":"F33","v":0},{"$f":"IF(ISNA(IF(B$56=0,0,IF(B$58>$J$52,(B$58-(7-$J$52)),B$61)))=TRUE,0,(IF(B$56=0,0,IF(B$58>=$J$52,(B$58-(7-$J$52)),B$61))))","v":0},{"$f":"IF(ISNA(IF(C$56=0,0,IF(C$58>$J$52,(C$58-(7-$J$52)),C$61)))=TRUE,0,(IF(C$56=0,0,IF(C$58>=$J$52,(C$58-(7-$J$52)),C$61))))","v":0},0,0,0,0,0]
[null,{"$f":"IF(E57=F21,0,IF(B83=0,0,(B84-(7-$F$33))))","v":0},{"$f":"IF(C83=0,0,IF(C84>C85,(C84-(7-$F$33)),C84))","v":0},{"$f":"IF(D83=0,0,IF(D84>D85,D85,D84))","v":0},{"$f":"IF(E83=0,0,IF(E84>E85,E85,E84))","v":0},{"$f":"IF(F83=0,0,IF(F84>F85,F85,F84))","v":0},{"$f":"IF(G83=0,0,IF(G84>G85,G85,G84))","v":0},{"$f":"IF(H83=0,0,IF(H84>H85,H85,H84))","v":0}]
[]
[null,"6.   Grass crop interval (Do not use interval values from step #1).",null,null,null,null,null,null,null,"=",{"$f":"IF(J83=0,0,J82/J83)","v":0}]
[null,"Total scores for each grass crop and divide by the number of grass crops in the rotation"]
[null,"Score:","1   if there are 4 or more years  between grass crops in the rotation. "]
[null,null,".5   if there are 3 years between grass crops in the rotation. "]
[null,null,"0   if there are 2 years between grass crops in the rotation. "]
[null,null,"-.5   if there is 1 year between grass crops in the rotation. "]
[null,null,"-1   if there are 0 years between grass crops in the rotation. "]
[]
[null,{"$f":"IF(B97=0,0,IF(B100=4,1,IF(B100=3,0.5,IF(B100=2,0,IF(B100=1,-0.5,-1)))))","v":0},{"$f":"IF(C97=0,0,IF(C100=4,1,IF(C100=3,0.5,IF(C100=2,0,IF(C100=1,-0.5,-1)))))","v":0},0,0,0,0,0,"=",{"$f":"SUM(B96:H96)","v":0},"Total Points"]
[null,{"$f":"IF(B$55=1,B$52,0)","v":0},{"$f":"IF(C$55=1,C$52,0)","v":0},0,0,0,0,0,null,{"$f":"O70","v":0},"grass crops"]
[null,{"$f":"IF(B$55=H$55,0,IF(B$55=G$55,1,IF(B$55=F$55,2,IF(B$55=E$55,3,IF(B$55=D$55,4,IF(B$55=C$55,5,6))))))","v":0},{"$f":"IF(C$55=B$55,0,IF(C$55=H$55,1,IF(C$55=G$55,2,IF(C$55=F$55,3,IF(C$55=E$55,4,IF(C$55=D$55,5,6))))))","v":0},{"$f":"IF(D$55=C$55,0,IF(D$55=B$55,1,IF(D$55=H$55,2,IF(D$55=G$55,3,IF(D474=F$55,4,IF(D$55=E$55,5,6))))))","v":0},{"$f":"IF(E$55=D$55,0,IF(E$55=C$55,1,IF(E$55=B$55,2,IF(E$55=H$55,3,IF(E$55=G$55,4,IF(E$55=F$55,5,6))))))","v":0},{"$f":"IF(F$55=E$55,0,IF(F$55=D$55,1,IF(F$55=C$55,2,IF(F$55=B$55,3,IF(F$55=H$55,4,IF(F$55=G$55,5,6))))))","v":0},{"$f":"IF(G$55=F$55,0,IF(G$55=E$55,1,IF(G474=D$55,2,IF(G$55=C$55,3,IF(G$55=B$55,4,IF(G$55=H$55,5,6))))))","v":0},{"$f":"IF(H$55=G$55,0,IF(H$55=F$55,1,IF(H$55=E$55,2,IF(H$55=D$55,3,IF(H$55=C$55,4,IF(H$55=B$55,5,6))))))","v":0}]
[null,{"$f":"IF(ISNA(IF(B$56=0,0,IF(B$58>$J$52,(B$58-(7-$J$52)),B$61)))=TRUE,0,(IF(B$56=0,0,IF(B$58>=$J$52,(B$58-(7-$J$52)),B$61))))","v":0},{"$f":"IF(ISNA(IF(C$56=0,0,IF(C$58>$J$52,(C$58-(7-$J$52)),C$61)))=TRUE,0,(IF(C$56=0,0,IF(C$58>=$J$52,(C$58-(7-$J$52)),C$61))))","v":0},0,0,0,0,0]
[null,{"$f":"IF(O70=F33,0,IF(B97=0,0,(B98-(7-$F$33))))","v":0},{"$f":"IF(C97=0,0,IF(C98>C99,(C98-(7-$F$33)),C98))","v":0},{"$f":"IF(D97=0,0,IF(D98>D99,D99,D98))","v":0},{"$f":"IF(E97=0,0,IF(E98>E99,E99,E98))","v":0},{"$f":"IF(F97=0,0,IF(F98>F99,F99,F98))","v":0},{"$f":"IF(G97=0,0,IF(G98>G99,G99,G98))","v":0},{"$f":"IF(H97=0,0,IF(H98>H99,H99,H98))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(ISERR(J96/J97)=TRUE,0,J96/J97)","v":0}]
[]
[null,"7.  Seeding time conflict score:   ",null,"No. of seeding time conflicts",null,null,{"$f":"D15","v":0},null,"=",null,{"$f":"IF(ISERR((G104/G105)*-1)=TRUE,0,((G104/G105)*-1))","v":0}]
[null,null,null,null,"No. of crops in the rotation",null,{"$f":"LOOKUP(F33,F33)","v":0}]
[]
[null,"8.   Other conflict score:",null,"No. of planting vs. harvest, or harvest vs. harvest conflicts",null,null,{"$f":"D16","v":0},0.5,"=",null,{"$f":"IF(ISERR(((G107/G108)*H107)*-1)=TRUE,0,(((G107/G108)*H107)*-1))","v":0}]
[null,null,null,"No. of crops in the rotation",null,null,{"$f":"LOOKUP(F33,F33)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Diversity Index",null,null,{"$f":"SUM(K68,K70,K71,K72,K88,K102,K104+K107)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       "]
[]
[]
[null,"Intensity Rating",null,null,null,null,"Grass/Broadleaf","Cool/Warm Season","Fall Seeded"]
[null,null,0]
[null,"Alfalfa",2,null,null,"Alfalfa",2,7]
[null,"Amaranth",2,null,null,"Amaranth",2,7]
[null,"Barley",1,null,null,"Barley",1,4]
[null,"Buckwheat",2,null,null,"Buckwheat",2,7]
[null,"Canary Seed",1,null,null,"Canary Seed",1,7]
[null,"Canola",1,null,null,"Canola",2,4]
[null,"CC CS Broadleaf",1,null,null,"CC CS Broadleaf",2,4]
[null,"CC CS Grass",1,null,null,"CC CS Grass",1,4]
[null,"CC WS Broadleaf",2,null,null,"CC WS Broadleaf",2,7]
[null,"CC WS Grass",2,null,null,"CC WS Grass",1,7]
[null,"Chickpea",2,null,null,"Chickpea",2,7]
[null,"Corn",2,null,null,"Corn",1,7]
[null,"Cotton",2,null,null,"Cotton",2,7]
[null,"Crambe",1,null,null,"Crambe",2,4]
[null,"Dry Edible Bean",2,null,null,"Dry Edible Bean",2,7]
[null,"Durum Wheat",1,null,null,"Durum Wheat",1,4]
[null,"Field Pea",1,null,null,"Field Pea",2,4]
[null,"Flax",1,null,null,"Flax",2,4]
[null,"Lentil ",1,null,null,"Lentil ",2,4]
[null,"Lupine",1,null,null,"Lupine",2,7]
[null,"Millet ",1,null,null,"Millet ",1,7]
[null,"Mustard",1,null,null,"Mustard",2,4]
[null,"Oat",1,null,null,"Oat",1,4]
[null,"Peanut",2,null,null,"Peanut",2,7]
[null,"Perennial Grass",2,null,null,"Perennial Grass",1,4]
[null,"Potato",2,null,null,"Potato",2,4]
[null,"Safflower",2,null,null,"Safflower",2,7]
[null,"Sorghum",2,null,null,"Sorghum",1,4]
[null,"Soybean",2,null,null,"Soybean",2,7]
[null,"Spring Wheat",1,null,null,"Spring Wheat",1,4]
[null,"Sudangrass",2,null,null,"Sudangrass",1,7]
[null,"Sugar Beet",2,null,null,"Sugar Beet",2,4]
[null,"Summer Fallow",0,null,null,"Summer Fallow",100,0]
[null,"Sunflower",2,null,null,"Sunflower",2,7]
[null,"Sweetclover ",2,null,null,"Sweetclover ",2,7]
[null,"Winter Rye",1,null,null,"Winter Rye",1,4,1]
[null,"Winter Wheat",1,null,null,"Winter Wheat",1,4,1]

{"sheet":"Instructions","index":1,"n_rows":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[[12,0,15,10],[24,0,25,10],[27,0,28,10],[36,0,39,10],[33,0,33,10],[34,0,34,10],[75,0,75,1],[75,2,75,3],[75,4,75,5],[75,6,75,7],[53,0,53,10],[54,0,54,10],[72,4,72,5],[72,6,72,7],[74,0,74,1],[74,2,74,3],[74,4,74,5],[74,6,74,7],[72,0,72,1],[72,2,72,3],[55,0,55,10],[62,0,63,10],[57,0,58,10],[59,0,61,10],[46,0,47,10],[48,0,51,10],[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[8,1,8,9],[7,2,7,7],[69,0,70,10],[67,0,68,10],[83,6,83,7],[84,6,84,7],[87,0,88,9],[78,4,78,5],[78,0,78,1],[76,2,76,3],[77,4,77,5],[76,4,76,5],[82,6,82,7],[79,0,79,1],[80,0,80,1],[79,4,79,5],[80,4,80,5],[81,4,81,5],[91,0,92,9],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,6,79,7],[80,6,80,7],[78,2,78,3],[77,0,77,1],[77,2,77,3],[76,0,76,1],[89,0,90,9],[81,6,81,7]]}
["Natural Resources Conservation Service"]
[]
["Crop Rotation Intensity and Diversity Fact Sheet"]
[]
["For more information on crop rotation diversity and intensity logon to:"]
[null,null,null,null,null,"http://www.dakotalakes.com/crop_rotations.htm"]
[]
[null,null,"For a copy of this worksheet logon to:"]
[null,"http://www.ag.ndsu.nodak.edu/dickinso/agronomy/agronomy_research.htm"]
[]
["Where this practice applies:"]
[]
["To agricultural lands where annual and perennial crops are grown for food, fiber, or forage.  Crops will be grown in a recurring sequence on the same land with sufficient diversity and intensity of crop types to; control erosion, maintain or improve soil organic matter,  manage plant nutrient needs, optimize water use efficiency, manage plant pests (weeds, insects, and diseases) and maintain or improve overall soil quality.  "]
[]
[]
[]
[]
["Planning considerations:"]
[]
[" Use soil survey information to evaluate soil potentials for soil water storage."]
[" Manage crop residues to facilitate soil water storage. "]
[" Manage crop nutrients to ensure strong crop competition with weeds and achieve crop yield goals. "]
[" Utilize available animal wastes to manage nutrients and improve soil quality."]
[" Minimize wind and water erosion. "]
[" Evaluate available equipment and labor and anticipate different or additional equipment or labor requirements to grow new crops."]
[]
[" It is usually easier to control grassy weeds in a broadleaf crop, and broadleaf weeds in a grass crop."]
[" Perennial crops such as grass or alfalfa provide excellent weed suppression in a rotation, particularly if the crop following them is planted no-till with minimal soil disturbance."]
[]
[]
["Plan development:"]
[]
["1.  Evaluate various crops you are willing to grow and the management and marketing of them."]
["2.  Arrange crops in a rotation to include; the maximum number of years between crops of the same crop type (particularly years between broadleaf crops),  crops that produce large amounts of residue (and trap and hold more soil water) followed by low-residue and/or high water use crops, high water use crops followed by low water use crops, nitrogen-producing legumes followed by high nitrogen-use crops."]
["3.  Arrange crops in a rotation to avoid; crops of the same type following each other more than two years in a row (particularly broadleaf crops), consecutive years of high or low residue producing crops,  consecutive years of high water-use crops,  conflicts with; crops that need to be seeded at the same time, seeding one crop when another needs to be harvested, or harvesting two crops at the same time, and herbicides whose carry-over may be detrimental to the next crop. "]
[]
["Following are some points to help you complete the “Intensity Rating for Crop Rotations for soil water storage and use” and “Diversity Index for Crop Rotations” worksheets for crop rotations you are considering for your farm.  The Intensity and Diversity Index concept was developed by Dr. Dwayne Beck, and the worksheets developed by Jason Miller, NRCS, Dakota Lakes Research Farm, Pierre, SD, and Jon Sitka, NRCS, Dickinson, ND."]
[]
[]
[]
[]
["Points to consider and worksheet instructions …"]
[]
[]
["Intensity"]
[]
[" Crop rotation intensity means growing a combination of crops that will match soil water storage with crop water use under your local climatic conditions. "]
[]
[" The native vegetation will show what the long-term climate is like in your area.  Adjust crop intensity rating to match a score that reflects the native vegetation in your area.  (The ratings below are based on no-till farming methods that conserve moisture through residue management.  Farming systems that rely on tillage should limit intensity ratings to at least .5 points lower than those shown below.)"]
[]
[]
[]
[]
["Western North Dakota - short grass prairie = intensity rating of 1.0 to 1.5"]
["Central North Dakota - mixed, short/tall grass prairie = intensity rating of 1.3 to 1.75"]
["Eastern North Dakota - tall grass prairie = intensity rating of 1.5 or greater"]
[]
[" Include enough full season, perennial, or deep-rooted crops in the rotation to achieve appropriate water use of stored soil water and nutrients left by short season annual crops."]
[]
[" When calculating a crop rotation intensity rating, summer-fallow counts as “0” because it does not use soil water.  However, tilled fallow does cause organic matter to be destroyed, resulting in the release of significant amounts of nitrogen."]
[]
[]
[" Score 1 point for short-season crops, and 2 points for full-season crops.   Total the points for the rotation, and divide by the total number of years in the rotation."]
[]
[]
["Diversity "]
[]
[" Crop rotation diversity means growing a combination of crops that compliment each other as much as possible to prevent disease, weed, and insect problems and maximize productivity, profitability, and soil quality."]
[]
[" Include as wide a variety of crops and crop types as possible.  Below are some commonly grown crops among four main crop types: "]
[]
[]
[" Cool-Season Grass",null,"Warm-Season Grass",null,"Cool-Season Broadleaf",null,"Warm-Season Broadleaf"]
[]
["Barley",null,"Corn",null,"Crambe",null,"Alfalfa "]
["Canary Seed ",null,"Millet",null,"Field Pea",null,"Amaranth"]
["Durum Wheat",null,"Perennial Grass",null,"Flax ",null,"Chickpea"]
["Oat",null,"Sorghum",null,"Lentil",null,"Cotton"]
["Spring Wheat",null,"Sudangrass",null,"Lupine",null,"Dry Edible Bean"]
["Winter Rye",null,null,null,"Mustard",null,"Peanut"]
["Winter Wheat",null,null,null,"Sweetclover",null,"Potato"]
[null,null,null,null,"Canola",null,"Safflower "]
[null,null,null,null,null,null,"Soybean"]
[null,null,null,null,null,null,"Sugar Beet"]
[null,null,null,null,null,null,"Sunflower"]
[]
[" Maintain at least a two-year interval between broadleaf crops to limit disease and insect problems."]
[" Avoid conflicts among seeding and harvest times of different crops (for example; trying to seed one crop when harvesting another, or harvesting more than one crop at a time)."]
[]
[" Count perennial crops as occurring once in a rotation even though they may occupy more than one year of time in the rotation. "]
[]
[" Follow the scoring instructions for each of the eight items on the “Diversity Index for Crop Rotations” worksheet.  Note that items 7 and 8 result in negative numbers and will affect the total accordingly."]
[]
[" Strive to achieve a diversity index of at least 2.  An index of 3 or more is a good goal!"]