{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Step 100","Step 50"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Step 100","index":1,"n_rows":93,"n_cols":20,"rows_kept":93,"cut":false,"hidden":false,"merged":[[7,9,8,9],[41,9,42,9],[41,3,42,3],[75,2,75,3],[41,7,42,7],[41,8,42,8],[7,7,8,7],[7,8,8,8],[75,4,75,5],[75,8,75,10],[7,10,8,10],[91,8,91,10],[83,7,83,10],[85,2,85,4],[85,8,85,10],[86,2,86,4],[86,8,86,10],[87,2,87,4],[87,8,87,10],[90,8,90,10],[88,2,88,4],[88,8,88,10],[89,8,89,10],[84,2,84,4],[84,8,84,10],[82,8,82,10],[81,8,81,10],[76,2,76,3],[77,2,77,3],[78,2,78,3],[78,4,78,5],[79,2,79,4],[76,8,76,10],[77,8,77,10],[78,8,78,10],[79,8,79,10],[80,8,80,10],[7,11,8,11],[41,0,42,0],[41,1,42,1],[41,2,42,2],[41,4,42,4],[41,5,42,5],[41,6,42,6],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,4,8,4],[7,5,8,5],[7,6,8,6],[41,10,42,10],[41,11,42,11],[7,3,8,3],[0,18,0,19],[6,0,6,1],[6,2,6,5],[0,0,1,4],[2,0,3,4],[5,7,6,11],[5,6,6,6],[0,5,3,11],[4,2,4,5],[4,6,4,11],[5,0,5,1],[5,2,5,5]]}
["NRCS",null,null,null,null,"Step Point Worksheet",null,null,null,null,null,null,null,null,null,null,null,"Enter state as applicable:","Indiana"]
[]
[{"$f":"S1","v":"Indiana"}]
[]
["Date:",null,"Client:"]
["Point Step No.:",null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"A","Alive or dormant plant cover"]
["Pasture name/number: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Dead plant material"]
["Point          #","Plant Species","Soil Cover?","Live Cover?","Preference?","Group?","Point          #","Plant Species","Soil Cover?","Live Cover?","Preference?","Group?",null,null,null,null,null,null,"N","No Cover"]
[]
[1,null,null,null,null,null,26]
[2,null,null,null,null,null,27,null,null,null,null,null,null,null,null,null,null,null,"R","Residue or Litter"]
[3,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,null,null,"S","Stone or rock"]
[4,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"B","Bare ground"]
[5,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,"O","Other cover"]
[6,null,null,null,null,null,31]
[7,null,null,null,null,null,32]
[8,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,"D","Desirable"]
[9,null,null,null,null,null,34,null,null,null,null,null,null,null,null,null,null,null,"I","Intermediate"]
[10,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,"U","Undesirable"]
[11,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,"N","No plant"]
[12,null,null,null,null,null,37]
[13,null,null,null,null,null,38,null,null,null,null,null,null,null,null,null,null,null,"CSG","Coolseason grass"]
[14,null,null,null,null,null,39,null,null,null,null,null,null,null,null,null,null,null,"WSG","Warmseason grass"]
[15,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,null,null,"LEG","Legumes"]
[16,null,null,null,null,null,41,null,null,null,null,null,null,null,null,null,null,null,"FORB","Forb"]
[17,null,null,null,null,null,42,null,null,null,null,null,null,null,null,null,null,null,"T/S","Tree, shrub, or brush"]
[18,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"S/R","Sedge or rush"]
[19,null,null,null,null,null,44,null,null,null,null,null,null,null,null,null,null,null,"None","No plant"]
[20,null,null,null,null,null,45]
[21,null,null,null,null,null,46]
[22,null,null,null,null,null,47]
[23,null,null,null,null,null,48]
[24,null,null,null,null,null,49]
[25,null,null,null,null,null,50]
[null,null,{"$f":"COUNTIF(C10:C34,\"R\")","v":0},{"$f":"COUNTIF(D10:D34,\"A\")","v":0},{"$f":"COUNTIF(E10:E34,\"D\")","v":0},{"$f":"COUNTIF(F10:F34,\"CSG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"R\")","v":0},{"$f":"COUNTIF(J10:J34,\"A\")","v":0},{"$f":"COUNTIF(K10:K34,\"D\")","v":0},{"$f":"COUNTIF(L10:L34,\"CSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"S\")","v":0},{"$f":"COUNTIF(D10:D34,\"D\")","v":0},{"$f":"COUNTIF(E10:E34,\"I\")","v":0},{"$f":"COUNTIF(F10:F34,\"WSG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"S\")","v":0},{"$f":"COUNTIF(J10:J34,\"D\")","v":0},{"$f":"COUNTIF(K10:K34,\"I\")","v":0},{"$f":"COUNTIF(L10:L34,\"WSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"B\")","v":0},{"$f":"COUNTIF(D10:D34,\"N\")","v":0},{"$f":"COUNTIF(E10:E34,\"U\")","v":0},{"$f":"COUNTIF(F10:F34,\"LEG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"B\")","v":0},{"$f":"COUNTIF(J10:J34,\"N\")","v":0},{"$f":"COUNTIF(K10:K34,\"U\")","v":0},{"$f":"COUNTIF(L10:L34,\"LEG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"O\")","v":0},null,{"$f":"COUNTIF(E11:E35,\"N\")","v":0},{"$f":"COUNTIF(F10:F34,\"FORB\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"O\")","v":0},null,{"$f":"COUNTIF(K11:K35,\"N\")","v":0},{"$f":"COUNTIF(L10:L34,\"FORB\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F10:F34,\"T/S\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L10:L34,\"T/S\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F10:F34,\"S/R\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L10:L34,\"S/R\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F11:F35,\"None\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L11:L35,\"None\")","v":0}]
["Point          #","Plant Species","Cover?","Live Cover?","Preference?","Group?","Point          #","Plant Species","Cover?","Live Cover?","Preference?","Group?"]
[]
[51,null,null,null,null,null,76]
[52,null,null,null,null,null,77]
[53,null,null,null,null,null,78]
[54,null,null,null,null,null,79]
[55,null,null,null,null,null,80]
[56,null,null,null,null,null,81]
[57,null,null,null,null,null,82]
[58,null,null,null,null,null,83]
[59,null,null,null,null,null,84]
[60,null,null,null,null,null,85]
[61,null,null,null,null,null,86]
[62,null,null,null,null,null,87]
[63,null,null,null,null,null,88]
[64,null,null,null,null,null,89]
[65,null,null,null,null,null,90]
[66,null,null,null,null,null,91]
[67,null,null,null,null,null,92]
[68,null,null,null,null,null,93]
[69,null,null,null,null,null,94]
[70,null,null,null,null,null,95]
[71,null,null,null,null,null,96]
[72,null,null,null,null,null,97]
[73,null,null,null,null,null,98]
[74,null,null,null,null,null,99]
[75,null,null,null,null,null,100]
[null,null,{"$f":"COUNTIF(C44:C68,\"R\")","v":0},{"$f":"COUNTIF(D44:D68,\"A\")","v":0},{"$f":"COUNTIF(E44:E68,\"D\")","v":0},{"$f":"COUNTIF(F44:F68,\"CSG\")","v":0},null,null,{"$f":"COUNTIF(I44:I68,\"R\")","v":0},{"$f":"COUNTIF(J44:J68,\"A\")","v":0},{"$f":"COUNTIF(K44:K68,\"D\")","v":0},{"$f":"COUNTIF(L44:L68,\"CSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C44:C68,\"S\")","v":0},{"$f":"COUNTIF(D44:D68,\"D\")","v":0},{"$f":"COUNTIF(E44:E68,\"I\")","v":0},{"$f":"COUNTIF(F44:F68,\"WSG\")","v":0},null,null,{"$f":"COUNTIF(I44:I68,\"S\")","v":0},{"$f":"COUNTIF(J44:J68,\"D\")","v":0},{"$f":"COUNTIF(K44:K68,\"I\")","v":0},{"$f":"COUNTIF(L44:L68,\"WSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C44:C68,\"B\")","v":0},{"$f":"COUNTIF(D44:D68,\"N\")","v":0},{"$f":"COUNTIF(E44:E68,\"U\")","v":0},{"$f":"COUNTIF(F44:F68,\"LEG\")","v":0},null,null,{"$f":"COUNTIF(I44:I68,\"B\")","v":0},{"$f":"COUNTIF(J44:J68,\"N\")","v":0},{"$f":"COUNTIF(K44:K68,\"U\")","v":0},{"$f":"COUNTIF(L44:L68,\"LEG\")","v":0}]
[null,null,{"$f":"COUNTIF(C44:C68,\"O\")","v":0},null,{"$f":"COUNTIF(E45:E69,\"N\")","v":0},{"$f":"COUNTIF(F44:F68,\"FORB\")","v":0},null,null,{"$f":"COUNTIF(I44:I68,\"O\")","v":0},null,{"$f":"COUNTIF(K45:K69,\"N\")","v":0},{"$f":"COUNTIF(L44:L68,\"FORB\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F44:F68,\"T/S\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L44:L68,\"T/S\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F44:F68,\"S/R\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L44:L68,\"S/R\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F45:F69,\"None\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L45:L69,\"None\")","v":0}]
[null,"Residue or Litter:",{"$f":"IF(C85>0,C85,\"\")","v":""},null,"Desir:",null,{"$f":"IF(G85>0,G85,\"\")","v":""},"Coolseason grass:",{"$f":"IF(I85>0,I85,\"\")","v":""}]
[null,"Stone or rock:",{"$f":"IF(C86>0,C86,\"\")","v":""},null,null,"Interm:",{"$f":"IF(G86>0,G86,\"\")","v":""},"Warmseason grass:",""]
[null,"Bare ground:","",null,null,"Unders:",{"$f":"IF(G87>0,G87,\"\")","v":""},"Legumes:",""]
[null,"Other cover:","",null,"No Plant:",null,{"$f":"IF(G88>0,G88,\"\")","v":""},"Forb:",""]
[null,null,"",null,null,null,{"$f":"IF(G89>0,G89,\"\")","v":""},"Tree, shrub, or brush:",""]
[null,null,null,null,null,"Live Plant:",{"$f":"IF(G91>0,G91,\"\")","v":""},"Sedge or rush:",""]
[null,null,null,null,null,"Dead:",{"$f":"IF(G92>0,G92,\"\")","v":""},"No Plant:",""]
[null,null,null,null,null,"No Cover:","",null,{"$f":"IF(I92>0,I92,\"\")","v":""}]
[]
[null,null,{"$f":"(C69/100)+(I69/100)+(C35/100)+(I35/100)","v":0},null,null,null,{"$f":"(E69/100)+(K69/100)+(E35/100)+(K35/100)","v":0},null,{"$f":"(F69/100)+(L69/100)+(F35/100)+(L35/100)","v":0}]
[null,null,{"$f":"(C70/100)+(I70/100)+(C36/100)+(I36/100)","v":0},null,null,null,{"$f":"(E70/100)+(K70/100)+(E36/100)+(K36/100)","v":0},null,0]
[null,null,{"$f":"(C71/100)+(I71/100)+(C37/100)+(I37/100)","v":0},null,null,null,{"$f":"(E71/100)+(K71/100)+(E37/100)+(K37/100)","v":0},null,0]
[null,null,{"$f":"(C72/100)+(I72/100)+(C38/100)+(I38/100)","v":0},null,null,null,{"$f":"(E72/100)+(K72/100)+(E38/100)+(K38/100)","v":0},null,0]
[null,null,{"$f":"SUM(C85:E88)","v":0},null,null,null,{"$f":"SUM(G85:G88)","v":0},null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"(D69/100)+(J69/100)+(D35/100)+(J35/100)","v":0},null,0]
[null,null,null,null,null,null,{"$f":"(D70/100)+(J70/100)+(D36/100)+(J36/100)","v":0},null,{"$f":"SUM(I76:L82)","v":0}]
[null,null,null,null,null,null,0]

{"sheet":"Step 50","index":2,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":false,"merged":[[46,2,46,4],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[45,4,45,5],[42,4,42,5],[0,0,1,4],[2,0,3,4],[5,6,6,6],[5,7,6,11],[7,7,8,7],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,6,8,6],[7,3,8,3],[7,9,8,9],[6,0,6,1],[6,2,6,5],[5,0,5,1],[7,0,8,0],[7,1,8,1],[56,8,56,10],[57,8,57,10],[50,7,50,10],[51,2,51,4],[52,8,52,10],[52,2,52,4],[53,8,53,10],[53,2,53,4],[54,8,54,10],[51,8,51,10],[50,2,50,4],[54,2,54,4],[55,8,55,10],[47,8,47,10],[49,8,49,10],[48,8,48,10],[58,8,58,10],[0,5,3,11],[4,2,4,5],[4,6,4,11],[5,2,5,5],[7,2,8,2],[7,4,8,4],[7,5,8,5],[42,8,42,10],[43,8,43,10],[44,8,44,10],[45,8,45,10],[46,8,46,10]]}
["NRCS",null,null,null,null,"Step Point Worksheet"]
[]
[{"$f":"'Step 100'!S1","v":"Indiana"}]
[]
["Date:",null,"Client:"]
["Point Step No.:",null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,"A","Alive or dormant plant cover"]
["Pasture name/number: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","Dead plant material"]
["Point          #","Plant Species","Soil Cover?","Live Cover?","Preference?","Group?","Point          #","Plant Species","Soil Cover?","Live Cover?","Preference?","Group?",null,null,null,null,null,null,"N","No Cover"]
[]
[1,null,null,null,null,null,26]
[2,null,null,null,null,null,27,null,null,null,null,null,null,null,null,null,null,null,"R","Residue or Litter"]
[3,null,null,null,null,null,28,null,null,null,null,null,null,null,null,null,null,null,"S","Stone or rock"]
[4,null,null,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,"B","Bare ground"]
[5,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,"O","Other cover"]
[6,null,null,null,null,null,31]
[7,null,null,null,null,null,32]
[8,null,null,null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,"D","Desirable"]
[9,null,null,null,null,null,34,null,null,null,null,null,null,null,null,null,null,null,"I","Intermediate"]
[10,null,null,null,null,null,35,null,null,null,null,null,null,null,null,null,null,null,"U","Undesirable"]
[11,null,null,null,null,null,36,null,null,null,null,null,null,null,null,null,null,null,"N","No plant"]
[12,null,null,null,null,null,37]
[13,null,null,null,null,null,38,null,null,null,null,null,null,null,null,null,null,null,"CSG","Coolseason grass"]
[14,null,null,null,null,null,39,null,null,null,null,null,null,null,null,null,null,null,"WSG","Warmseason grass"]
[15,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,null,null,"LEG","Legumes"]
[16,null,null,null,null,null,41,null,null,null,null,null,null,null,null,null,null,null,"FORB","Forb"]
[17,null,null,null,null,null,42,null,null,null,null,null,null,null,null,null,null,null,"T/S","Tree, shrub, or brush"]
[18,null,null,null,null,null,43,null,null,null,null,null,null,null,null,null,null,null,"S/R","Sedge or rush"]
[19,null,null,null,null,null,44,null,null,null,null,null,null,null,null,null,null,null,"None","No plant"]
[20,null,null,null,null,null,45]
[21,null,null,null,null,null,46]
[22,null,null,null,null,null,47]
[23,null,null,null,null,null,48]
[24,null,null,null,null,null,49]
[25,null,null,null,null,null,50]
[null,null,{"$f":"COUNTIF(C10:C34,\"R\")","v":0},{"$f":"COUNTIF(D10:D34,\"A\")","v":0},{"$f":"COUNTIF(E10:E34,\"D\")","v":0},{"$f":"COUNTIF(F10:F34,\"CSG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"R\")","v":0},{"$f":"COUNTIF(J10:J34,\"A\")","v":0},{"$f":"COUNTIF(K10:K34,\"D\")","v":0},{"$f":"COUNTIF(L10:L34,\"CSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"S\")","v":0},{"$f":"COUNTIF(D10:D34,\"D\")","v":0},{"$f":"COUNTIF(E10:E34,\"I\")","v":0},{"$f":"COUNTIF(F10:F34,\"WSG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"S\")","v":0},{"$f":"COUNTIF(J10:J34,\"D\")","v":0},{"$f":"COUNTIF(K10:K34,\"I\")","v":0},{"$f":"COUNTIF(L10:L34,\"WSG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"B\")","v":0},{"$f":"COUNTIF(D10:D34,\"N\")","v":0},{"$f":"COUNTIF(E10:E34,\"U\")","v":0},{"$f":"COUNTIF(F10:F34,\"LEG\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"B\")","v":0},{"$f":"COUNTIF(J10:J34,\"N\")","v":0},{"$f":"COUNTIF(K10:K34,\"U\")","v":0},{"$f":"COUNTIF(L10:L34,\"LEG\")","v":0}]
[null,null,{"$f":"COUNTIF(C10:C34,\"O\")","v":0},null,{"$f":"COUNTIF(E11:E35,\"N\")","v":0},{"$f":"COUNTIF(F10:F34,\"FORB\")","v":0},null,null,{"$f":"COUNTIF(I10:I34,\"O\")","v":0},null,{"$f":"COUNTIF(K11:K35,\"N\")","v":0},{"$f":"COUNTIF(L10:L34,\"FORB\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F10:F34,\"T/S\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L10:L34,\"T/S\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F10:F34,\"S/R\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L10:L34,\"S/R\")","v":0}]
[null,null,null,null,null,{"$f":"COUNTIF(F11:F35,\"None\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(L12:L36,\"None\")","v":0}]
[]
[null,"Residue or Litter:",{"$f":"IF(C51>0,C51,\"\")","v":""},null,"Desir:",null,{"$f":"IF(G51>0,G51,\"\")","v":""},"Coolseason grass:",{"$f":"IF(I52>0,I52,\"\")","v":""}]
[null,"Stone or rock:",{"$f":"IF(C52>0,C52,\"\")","v":""},null,null,"Interm:",{"$f":"IF(G52>0,G52,\"\")","v":""},"Warmseason grass:",""]
[null,"Bare ground:","",null,null,"Unders:",{"$f":"IF(G53>0,G53,\"\")","v":""},"Legumes:",""]
[null,"Other cover:","",null,"No Plant:",null,{"$f":"IF(G54>0,G54,\"\")","v":""},"Forb:",""]
[null,null,"",null,null,null,{"$f":"IF(G56>0,G56,\"\")","v":""},"Tree, shrub, or brush:",""]
[null,null,null,null,null,"Live Plant:",{"$f":"IF(G58>0,G58,\"\")","v":""},"Sedge or rush:",""]
[null,null,null,null,null,"Dead:",{"$f":"IF(G59>0,G59,\"\")","v":""},"No Plant:",""]
[null,null,null,null,null,"No Cover:","",null,""]
[null,null,{"$f":"(C35/100)*2+(I35/100)*2","v":0},null,null,null,{"$f":"(E35/100)*2+(K35/100)*2","v":0}]
[null,null,{"$f":"(C36/100)*2+(I36/100)*2","v":0},null,null,null,{"$f":"(E36/100)*2+(K36/100)*2","v":0},null,{"$f":"(F35/100)*2+(L35/100)*2","v":0}]
[null,null,{"$f":"(C37/100)*2+(I37/100)*2","v":0},null,null,null,{"$f":"(E37/100)*2+(K37/100)*2","v":0},null,0]
[null,null,{"$f":"(C38/100)*2+(I38/100)*2","v":0},null,null,null,{"$f":"(E38/100)*2+(K38/100)*2","v":0},null,0]
[null,null,{"$f":"SUM(C51:E54)","v":0},null,null,null,{"$f":"(E39/100)*2+(K39/100)*2","v":0},null,0]
[null,null,null,null,null,null,{"$f":"SUM(G51:G54)","v":0},null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"(D35/100)*2+(J35/100)*2","v":0},null,{"$f":"(F42/100)*2+(L41/100)*2","v":0}]
[null,null,null,null,null,null,{"$f":"(D36/100)*2+(J36/100)*2","v":0},null,{"$f":"SUM(I52:K58)","v":0}]
[null,null,null,null,null,null,0]