{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["INTRODUCTION","Dry Weight Rank -SI","Double Sampling -SI","Calibration Form","Air Dry Conversion Table","Production Est.by species -SI","Total Production Worksheet","Cover Worksheet","Rangeland Health","Infiltration","Quick Forage Balance Check","Plant Census","Line Point Intercept","Landscape Appearance","Photo_Point","Photo_Point_Label_Sheet"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":17,"comments":3,"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":"INTRODUCTION","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["This workbook includes a variety of forms that can be used for rangeland inventories and monitoring the success of a grazing management plan.  The worksheets are grouped together to facilitate use of the forms."]
["Dry Weight Rank-SI, Double Sampling-SI and Production Est by species-SI are three methods that can be used to determine Similarity Index (comparison of the existing plant community to the reference plant community).  One of these three methods should be used when determining SI.  The calibration and air dry conversion table are tools that can be used when esitmating weight and/or dry weight.  (Yellow Tabs) "]
["Rangeland Health is the assessment tool to evaluate the majority of resource concerns on rangeland.  The Rangeland Health Worksheet is used to document RH assessments.  The total production worksheet and cover worksheet can be used to document the quantitive RH indicators.  (Dark Blue Tabs)"]
["The Infiltration worksheet can be used as one of the soil health metrics for rangeland. (Aqua Blue Tab)"]
["The Quick Forage Balance Worksheet can be used by the planner or producer as a rough estimate as to whether stocking rates (number of animals and time of grazing) are in balance with the averate forage supply.  (Purple Tab)"]
["The plant census and line point intercept can be used as initial assessments and for monitoring.  These with landscape appearance can be used by the producer to monitor the impacts of their grazing strategy.  (Light Green Tabs)"]
["The photo-point and photopoint label worksheets can be used for photo monitoring. (Light Red Tabs)"]

{"sheet":"Dry Weight Rank -SI","index":1,"n_rows":29,"n_cols":31,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,0,20,1],[21,0,21,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[19,0,19,1],[15,0,15,1],[16,0,16,1],[18,0,18,1],[28,0,28,1],[26,0,26,1],[27,0,27,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[2,30,3,38],[7,30,9,38],[4,28,6,28],[4,27,6,27],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[5,0,6,1],[4,0,4,24],[17,0,17,1],[0,0,0,1],[2,21,2,24],[1,17,1,26],[4,26,6,26],[4,25,6,25],[5,22,5,24],[5,2,5,21],[1,0,1,1],[1,2,1,10],[2,2,2,4],[2,0,2,1],[0,27,0,28],[0,2,0,26],[2,5,2,8],[2,9,2,10],[2,18,2,20],[2,15,2,17]]}
[null,null,"Similarity Index - Dry Weight Rank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2019"]
["Producer Name:",null,"John Q Rancher",null,null,null,null,null,null,null,null,null,null,"Transect Location:",null,null,null,"Enter GPS Coordinates or other Location Information"]
["Number of Quadrats:",null,20,null,null,"Size of Quadrats:",null,null,null,"1.92 ft2",null,null,"Ecological Site: ",null,null,"MLRA 73-LiS",null,null,"Observer:",null,null,"S. Q. Planner",null,null,null,"Date:","2019-08-01",null,null,null,"Instructions"]
[]
["Weight Factor for 1 rank = 7; for 2 rank = 2, for 3 rank = 1; Divide the weighted sum by (# quadrats x 10)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted    Sum (# tally X Wt factor)","% Comp.(Species Weighted / Sum of Weighted)","Max. % in the Reference Community from ESD","% Allowabe",null,"1.  Randomly locate a transect location in an area that represents the area being evaluated"]
["Species",null,"Quadrat Number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rank Tally",null,null,null,null,null,null,null,"2.  Evaluate 20 plots."]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"1 (x 7)","2 (x2)","3 (x1)",null,null,null,null,null,"3.  List the plants that occur in the plots."]
["Big Bluestem",null,1,null,null,null,1,null,1,null,null,null,1,2,null,3,null,null,null,3,null,null,4,1,2,{"$f":"SUM(W8*7)+(X8*2)+(Y8*1)","v":32},{"$f":"IF(Z8=\"\",\"\",Z8/$Z$29)","v":0.16},0.33,0.16,null,"4.  At each plot location designate the plant within the plot that will have the largest weight at the end of the growing season as \"1\", the plant within the plot that will have the 2nd most weight as \"2\" and the plant that will have the 3rd most weight as \"3\"."]
["Switchgrass",null,null,null,2,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,1,1,0,{"$f":"SUM(W9*7)+(X9*2)+(Y9*1)","v":9},4.4999999999999998E-2,0.01,0.01]
["Sideoats Grama",null,null,null,3,null,null,null,null,1,null,1,2,null,null,null,null,3,null,null,null,1,3,1,2,25,0.125,0.1,0.1]
["Smooth Brome",null,3,null,null,1,null,null,null,null,null,null,null,null,1,2,null,null,3,null,null,null,2,1,2,18,0.09,0,0,null,"5.  Determine the total for each rank (1, 2 or 3)."]
["Kentucky Bluegrass",null,null,null,1,null,null,null,null,null,2,null,null,null,null,null,2,null,null,null,3,null,1,2,1,12,0.06,0,0,null,"6.  Multiply the total of 1's by 7, 2's by 2 and 3's by 1 and add the 3 totals together."]
["Needleandthread",null,null,null,null,null,null,1,null,null,null,null,3,null,null,1,3,null,null,null,null,null,2,0,2,16,0.08,0.01,0.01,null,"7.  Divide the sum of the weighted for each species by the total of all weighted."]
["Prairie Junegrass",null,null,null,null,3,null,null,null,null,null,null,null,3,null,null,null,null,2,null,2,null,0,2,2,6,0.03,0.01,0.01,null,"8.  Determine the maximum found in the reference plant community (found in the ESD) for each species."]
["Wilcox's Panicum",null,null,null,null,null,2,2,null,null,null,2,null,null,null,null,null,null,null,null,null,null,0,3,0,6,0.03,0.01,0.01,null,"9.  Determine the % allowable which is the lesser of the % composition and the maximum % in the ESD."]
["Hairy Grama",null,null,1,null,null,null,null,null,null,3,null,null,1,null,null,1,null,1,null,null,2,4,1,1,31,0.155,0.01,0.01]
["Buffalograss",null,null,null,null,null,null,3,null,2,null,null,null,null,3,null,null,null,null,null,null,null,0,1,2,4,0.02,0,0]
["Cheatgrass",null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,2,0.01,0,0]
["Little Bluestem",null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,2,1,null,1,2,0,11,5.5E-2,0.22,0.06]
["Missouri Goldenrod",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,0,2,0,4,0.02,0.01,0.01]
["Nineanther Prairie Clover",null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,0,1,0,2,0.01,0.01,0.01]
["Nuttall's Sensitive Briar",null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,2,2,0.01,0.01,0.01]
["Scarlet Globemallow",null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,0,0,1,1,5.0000000000000001E-3,0.01,0.01]
["Slimflower Scurfpea",null,null,3,null,null,null,null,null,3,null,null,null,null,null,null,null,1,null,null,null,null,1,0,2,9,4.4999999999999998E-2,0.01,0.01]
["Rush Skelatonplant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
["Dotted Blazingstar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,1,0,0,7,3.5000000000000003E-2,0.01,0.01]
["Fringed Sagewort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
["White Sage",null,null,2,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,1,{"$f":"SUM(W28*7)+(X28*2)+(Y28*1)","v":3},1.4999999999999999E-2,0.01,0.01]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z8=\"\",\"\", SUM(Z8:Z28))","v":200},{"$f":"IF(AA8=\"\",\"\", SUM(AA8:AA28)*100)","v":100.00000000000003},null,{"$f":"IF(AC8=\"\",\"\", SUM(AC8:AC28)*100)","v":44.000000000000014}]

{"sheet":"Double Sampling -SI","index":2,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,1,3,7],[1,15,1,19],[2,1,2,4],[0,2,0,23],[2,10,2,12],[3,10,3,12],[0,24,0,25],[5,25,6,25],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24],[2,15,2,19],[5,0,9,0],[5,1,6,10],[5,12,6,12],[5,13,5,16],[5,17,6,17],[7,12,10,12],[7,13,10,13],[7,14,10,14],[7,15,10,15],[5,11,6,11],[7,11,10,11],[34,0,37,0],[34,1,37,9],[34,10,34,23],[35,10,35,24],[36,10,36,24],[37,10,37,25],[1,28,1,30],[7,24,10,24],[7,25,10,25],[8,1,8,10],[9,1,9,10],[7,18,10,18],[7,19,10,19],[7,20,10,20],[7,21,10,21],[7,22,8,22],[7,23,10,23],[7,1,7,6],[7,16,10,16],[7,17,10,17],[5,18,6,18],[2,6,2,9],[2,31,4,31],[5,31,8,31],[5,28,8,28],[5,29,8,30],[2,29,4,30],[2,28,4,28],[9,29,10,30],[9,28,10,28],[9,31,10,31],[11,31,14,31],[11,29,14,30],[11,28,14,28],[15,31,16,31],[15,28,16,28],[15,29,16,30],[17,29,18,30],[17,28,18,28],[17,31,18,31],[19,29,21,30],[19,28,21,28],[19,31,21,31],[22,28,23,28],[22,29,23,30],[22,31,23,31],[39,28,41,28],[28,31,30,31],[28,28,30,28],[28,29,30,30],[24,29,25,30],[24,28,25,28],[24,31,25,31],[26,28,27,28],[26,29,27,30],[26,31,27,31],[0,28,0,31],[42,29,42,30],[43,29,44,30],[43,28,44,28],[43,31,44,31],[31,31,33,31],[31,28,33,28],[31,29,33,30],[34,28,36,28],[34,29,36,30],[34,31,36,31],[37,31,38,31],[37,29,38,30],[37,28,38,28],[39,31,41,31],[39,29,41,30]]}
[null,null,"Similarity Index - Double Sampling ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2019",null,null,null,"INSTRUCTIONS"]
["Producer Name:","John Q Rancher",null,null,null,null,null,null,null,null,null,null,null,"Transect Location:",null,"Enter GPS Coordinates",null,null,null,null,null,"Plot Size ft2","Multiplier",null,"Plot Size ft2","Multiplier",null,null,"Column",null,null,"Instruction for Column"]
["Number of Quadrats:",10,null,null,null,null,"Size of Quadrats:",null,null,null,"1.92 ft2",null,null,"Ecological Site:",null,"MLRA 73 - Loamy Plains",null,null,null,null,null,1.92,50,null,2.4,40,null,null,"P 1-10","Estimated and/or Clipped Weight Per Species",null,"Enter the estimated and/or clipped weight of each species in each plot the species is found in .  "]
["Data Collector:","SJ Planner",null,null,null,null,null,null,null,"Date:","2019-08-01",null,null,null,null,null,null,null,null,null,null,4.8,20,null,9.6,10]
[]
["A","Transect Information",null,null,null,null,null,null,null,null,null,"A1","A2","Weight Clipped Plots",null,null,null,"B","C*","D*","E*","F*","G","H","I","J",null,null,"A-1","Average Plot Estimated Green Weight lbs./ac.",null,"Add up the green weights estimated for each species and divide by the number of plots in the transect then multiply by the plot size conversion factor.  This number gives you the average estimated green weight for each species.  For example if you estimated a total of 300 grams of blue grama in ten 9.6 sq. ft. plots you would enter 300 grams for blue grama in this column."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A3","A4","A5","A6"]
[null,"Number of Plots in Transect:",null,null,null,null,null,10,null,null,null,"Plot Size Conversion Factor (Multiplier)","Average Plot/   Estimated Green Wt. (lbs/ac)","Estimated Weight (grams)","Clipped Weight (grams)","Dry Weight (grams)","Clipped/ Estimated plot conversion factor","Clip/   Estimated corrected green weight (lbs/ac)","% dry weight","% current growth ungrazed","% growth curve completed","% of normal production","Recons-truction factor       ","Recons-tructed present weight (lbs/ac)","Weight in reference state (lbs/ac)","Weight allowable (lbs/ac)"]
[null,"Estimated or Clipped Weight Per Species"]
[null,"(circle plot numbers that are clipped)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"column c",null,null,null,null,null,"A-2","Plot Size Conversion and Factor Used.",null,"Under the heading Factor Used enter the plot size conversion factor used.  For example if you are using a 9.6 square foot plot you would enter 10 as the factor used.  "]
["Plant Name","P-1","P-2","P-3","P-4","P-5","P-6","P-7","P-8","P-9","P-10",null,null,null,"Estimated Weight",null,null,null,null,null,null,null,"(d)(e)(f)"]
["Big Bluestem",10,80,0,52,71,26,10,35,45,110,50,{"$f":"IF(A12=\"\",\"\",SUM(B12:K12)/$H$8*L12)","v":2195},235,186,95,{"$f":"IF(A12=\"\",\"\",O12/N12)","v":0.79148936170212769},{"$f":"IF(M12=\"\",\"\",M12*Q12)","v":1737.3191489361702},{"$f":"IF(N12=\"\",\"\",P12/O12)","v":0.510752688172043},0.3,0.9,1.1000000000000001,{"$f":"IF(A12=\"\",\"\",S12/(T12*U12*V12))","v":1.7197060207812893},{"$f":"IF(R12=\"\",\"\",R12*W12)","v":2987.6782004441575},660,660,null,null,"A-3, A-4","Clipped/Estimated Weight",null,"For those plots that are clipped enter the total clipped weights in A4 space and enter the total estimated weights A3.  For example if you clipped 2 plots you would add up the clipped weights from both plots and enter this figure in the A4.  You would then add up the estimated weights from both plots and enter this figure in A3.  "]
["Little  Bluestem",5,35,5,90,25,14,0,45,12,8,50,{"$f":"IF(A13=\"\",\"\",SUM(B13:K13)/$H$8*L13)","v":1195},105,75,43,{"$f":"IF(A13=\"\",\"\",O13/N13)","v":0.7142857142857143},{"$f":"IF(M13=\"\",\"\",M13*Q13)","v":853.57142857142856},{"$f":"IF(N13=\"\",\"\",P13/O13)","v":0.57333333333333336},0.6,0.9,1.1000000000000001,{"$f":"IF(A13=\"\",\"\",S13/(T13*U13*V13))","v":0.96520763187429848},{"$f":"IF(R13=\"\",\"\",R13*W13)","v":823.87365720699052},430,430]
["Prairie Junegrass",3,4,10,9,12,3,0,10,14,0,50,{"$f":"IF(A14=\"\",\"\",SUM(B14:K14)/$H$8*L14)","v":325},26,30,22,1.1538461538461537,374.99999999999994,0.73333333333333328,0.7,0.9,0.9,1.2933568489124043,485.00881834215153,20,20]
["Sideoats Grama",20,15,8,14,22,17,25,6,9,0,50,680,43,49,29,1.1395348837209303,774.88372093023258,0.59183673469387754,0.5,1,1.1000000000000001,1.0760667903525045,833.82663847780123,430,430]
["Cheatgrass",3,4,2,6,7,13,30,0,25,0,50,450,11,17,10,1.5454545454545454,695.45454545454538,0.58823529411764708,0.8,1,1,0.73529411764705876,511.36363636363626,0,0,null,null,"A-5","Dry Weight",null,"Enter the total air-dry weight of all species from clipped plots, or % of air dry matter from Exhibit 4-2 in NRPH.  Use only if clipped material is air-dried."]
["Needleandthread",35,10,3,10,7,15,12,21,1,0,50,570,38,40,23,1.0526315789473684,600,0.57499999999999996,0.7,0.9,0.9,1.0141093474426806,608.46560846560828,40,40]
["Western Wheatgrass",10,0,45,0,10,35,4,15,25,0,50,720,25,20,15,0.8,576,0.75,0.5,0.9,0.9,1.8518518518518516,1066.6666666666665,180,180,null,null,"A-6","Clipped/Estimated Conversion Factor",null,"Divide the clipped weight by the estimated weight for each species and enter the resulting clip/weight correction factor in this column."]
["Catclaw Sensitive Briar",3,3,0,0,0,0,0,5,0,0,50,55.000000000000007,8,10,4,1.25,68.750000000000014,0.4,1,1,1,0.4,27.500000000000007,10,10]
["Slim Flower Scurfpea",5,5,0,0,0,0,0,3,0,0,50,65,8,6,3,0.75,48.75,0.5,1,1,1,0.5,24.375,65,24,null,null,"B","Clipped/Estimated Corrected Green Weights",null,"Multiply column A1 by its associated clip/estimate correction factor in column A5.  This figure gives you the green weights that have been corrected for weight estimation errors."]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"","",null,null,null,null,"C ","% Dry Weight",null,"Enter the percent air dry weight or oven dry weight as a decimal value."]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"","",null,null,null,null,"D","% Current Growth Ungrazed",null,"Enter the estimated percent (as a decimal value) of the current growth that has not been removed by grazing or harvest."]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"","",null,null,null,null,"E","% Growth Curve Completed",null,"Enter the percent (as a decimal value) of the current years growth for each species that should normally have occurred by the date of this determination."]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"","",null,null,null,null,"F","% of Normal Production",null,"Enter an estimation of the current years forage production in comparison to normal expressed as a percent (as a decimal value) of normal.  Example: .9 means the year’s production is 90% of normal.  1.1 is 110% of normal."]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"","",null,null,null,null,"G","Reconstruction Factor",null,"This factor is calculated by dividing (C) Percent dry weight by the product obtained by multiplying (D) Percent current growth ungrazed times (E) Percent growth curve completed times (F)  Percent of normal production. (C/DxExF=G)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","","",null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"","",{"$f":"IF(N34=\"\",\"\",P34/O34)","v":""},null,null,null,"",""]
["Remarks:",null,null,null,null,null,null,null,null,null,"K. Total normal annual production in reference vegetation state (from ecological site description):",null,null,null,null,null,null,null,null,null,null,null,null,null,3000,null,null,null,"H","Reconstructed Present Weight",null,"This value is calculated by multiplying (B) Corrected green weight by (G) the Reconstruction factor. (BxG=H)"]
[null,null,null,null,null,null,null,null,null,null,"L.  Total weight of allowable present (total of weight in column J):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z12=\"\",\"\",SUM(Z12:Z34))","v":1794}]
[null,null,null,null,null,null,null,null,null,null,"M.  Similarity index (L divided by K x 100 = M):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z36=\"\",\"\",Z36/Y35*100)","v":59.8}]
[null,null,null,null,null,null,null,null,null,null,"*Express all percents as decimal values (Example: 60%=.6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I","Weight in Reference Vegetation State",null,"Enter the weight for each plant species as shown in the appropriate reference vegetation state in the ecological site description."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J","Weight Allowable",null,"Enter the lesser of (H) Reconstructed present weight or (I) weight in reference vegetation state.  No more than the weight in the reference vegetation state plant community may be counted in determining similarity index."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K","Normal Annual Production",null,"Enter the RV (Representative Value) for production for the site in the Reference Plant Community (see Ecological Site Description)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L","Total Weight of Allowable Present",null,"Total of all weights listed in column J"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","Similarity Index",null,"Divide column L by column K.  Mulitply by 100 for % SI"]

{"sheet":"Calibration Form","index":3,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,1,8,3],[0,1,1,2],[0,3,1,4],[0,5,1,5]]}
[null,null,null,"Species Composition by Weight Calibration "]
[]
["1.  Record the Name and estimated  weight in grams for a weight unit for each plant species in Columns 1 and 2.  "]
["2.  Estimate (using widht unit) and record the estimated weight unit in Column 3 for each species within the quadrat."]
["3.  Clip, weigh and record the weight for each species in Column 4."]
["4.  Compare the percernt over-estimates (positive number) or under-estimates (negative number)"]
["5.  If the over or under estimates are greater than 10% continue to clip and weigh until the weights are within 10%."]
[]
["Observer Name","SJ Planner",null,null,"Date:","2019-09-01"]
[]
["Record Species code or name","Record Weight Unit (g)","Record Number of Weight Units","Record clipped quadrat weight (g)","Total estimated weight for quadrat (g)","Percent over or under estimation"]
["Big Blue",10,8,110,{"$f":"IF(A12=\"\",\"\",B12*C12)","v":80},{"$f":"IF(A12=\"\",\"\",((E12/D12)*100)-100)","v":-27.272727272727266}]
["Sideoats",7,9,53,{"$f":"IF(A13=\"\",\"\",B13*C13)","v":63},{"$f":"IF(A13=\"\",\"\",((E13/D13)*100)-100)","v":18.867924528301884}]
["Blue Grama",5,4,18,20,11.111111111111114]
["Prairie June",4,3,10,12,20]
["Western Wheat",7,2,20,14,-30]
["Dotted gayfthr",10,3,22,30,36.363636363636346]
["Cutleaf Ironpl",4,3,12,12,0]
["Heath Aster",13,1,12,13,8.3333333333333286]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(A40=\"\",\"\",B40*C40)","v":""},{"$f":"IF(A40=\"\",\"\",((E40/D40)*100)-100)","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]

{"sheet":"Air Dry Conversion Table","index":4,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,11,21,12],[22,0,22,12],[23,0,24,2],[19,0,21,2],[19,3,21,4],[19,5,21,6],[19,7,21,8],[19,9,21,10],[23,3,24,4],[23,5,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[7,0,7,12],[8,0,9,2],[8,3,9,4],[8,5,9,6],[8,7,9,8],[8,9,9,10],[8,11,9,12],[0,0,2,12],[3,0,6,2],[3,3,6,4],[3,5,6,6],[3,7,6,8],[3,9,6,10],[3,11,6,12],[10,0,10,12],[11,0,11,2],[11,3,12,4],[11,5,12,6],[11,7,12,8],[11,9,12,10],[11,11,12,12],[12,0,12,2],[13,7,15,8],[13,9,15,10],[13,11,15,12],[16,0,16,2],[16,3,17,4],[16,5,17,6],[16,7,17,8],[16,9,17,10],[16,11,17,12],[14,0,15,2],[13,0,13,2],[13,3,15,4],[13,5,15,6],[17,0,17,2],[25,0,25,12],[26,0,27,2],[26,3,27,4],[26,5,27,6],[26,7,27,8],[26,9,27,10],[26,11,27,12],[28,0,28,12],[29,0,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[36,3,37,4],[36,5,37,6],[36,7,37,8],[36,9,37,10],[31,0,34,2],[31,3,34,4],[31,5,34,6],[31,7,34,8],[31,9,34,10],[30,0,30,12],[18,0,18,12],[41,0,41,10],[42,0,42,2],[42,3,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[38,0,38,10],[39,0,40,2],[39,3,40,4],[39,5,40,6],[39,7,40,8],[39,9,40,10],[35,0,35,10],[36,0,37,2]]}
["Exhibit 4-2 National Range and Pasture Handbook. Percentage of air-dry matter in harvested plant material at various stages of growth"]
[]
[]
["Grasses",null,null,"Before heading; initial growth to boot stage (%)",null,"Headed out; boot stage to flowering (%)",null,"Seed ripe; leaf tips drying (%)",null,"Leaves dry; stems partly dry (%)",null,"Apparent dormancy (%)"]
[]
[]
[]
["Cool season"]
["wheatgrasses, perennial bromes, bluegrasses, prairie junegrass",null,null,35,null,45,null,60,null,85,null,95]
[]
["Warm season"]
["Tall grasses",null,null,30,null,45,null,60,null,85,null,95]
["bluestem, switchgrass, indiangrass"]
["Midgrasses",null,null,40,null,55,null,65,null,90,null,95]
["side-oats grama, little bluestem, sand dropseed"]
[]
["Short grasses",null,null,45,null,60,null,80,null,90,null,95]
["blue grama, panicum, buffalo grass"]
[]
["Forbs",null,null,"Initial growth to flowering (%)",null,"Flowering to Seed Maturity (%)",null,"Seed ripe; leaf tips drying (%)",null,"Leaves dry; stems drying (%)",null,"Dry (%)"]
[]
[]
["Succulents"]
["Violets, waterleaf, buttercup, bluebells, wild onions, lilies",null,null,15,null,35,null,60,null,90,null,100]
[]
["Leafy"]
["lupines, lespedeza, compass plant, clovers, sunflowers",null,null,20,null,40,null,60,null,90,null,100]
[]
["Fibrous leaves or mat"]
["Phlox, pussytoes, mat eriogonum",null,null,30,null,50,null,75,null,90,null,100]
[]
["Shrubs",null,null,"New leaf & twig growth until leaves are full size (%)",null,"Older and full size green leaves (%)",null,"Green Fruit (%)",null,"Dry Fruit (%)"]
[]
[]
[]
["Evergreen"]
["sandsage, fringed sagewort, bitterbrush",null,null,55,null,65,null,35,null,85]
[]
["Deciduous"]
["snowberry, broom snakeweed, western sandcherry",null,null,35,null,50,null,30,null,85]
[]
["Yucca"]
["small soapweed",null,null,55,null,65,null,35,null,85]

{"sheet":"Production Est.by species -SI","index":5,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,5,32,6],[32,7,32,8],[19,5,19,6],[19,7,19,8],[20,5,20,6],[20,7,20,8],[27,5,27,6],[27,7,27,8],[21,5,21,6],[21,7,21,8],[22,5,22,6],[22,7,22,8],[23,5,23,6],[23,7,23,8],[24,5,24,6],[24,7,24,8],[25,5,25,6],[25,7,25,8],[26,5,26,6],[26,7,26,8],[10,5,10,6],[14,5,14,6],[14,7,14,8],[15,5,15,6],[15,7,15,8],[16,5,16,6],[16,7,16,8],[18,5,18,6],[18,7,18,8],[20,0,20,4],[3,0,3,2],[3,3,3,4],[8,5,8,6],[8,7,8,8],[8,0,8,4],[5,5,7,6],[5,7,7,8],[5,0,7,4],[3,7,3,9],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[17,5,17,6],[17,7,17,8],[10,7,10,8],[11,5,11,6],[11,7,11,8],[12,5,12,6],[12,7,12,8],[13,5,13,6],[13,7,13,8],[36,3,36,8],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[26,0,26,4],[27,0,27,4],[33,0,33,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[28,0,28,4],[28,5,28,6],[28,7,28,8],[33,5,33,6],[33,7,33,8],[29,5,29,6],[29,7,29,8],[34,0,34,8],[35,1,35,8],[30,5,30,6],[30,7,30,8],[31,5,31,6],[31,7,31,8],[0,11,0,19],[3,11,5,19],[6,11,7,19],[11,11,12,19],[21,0,21,4],[22,0,22,4],[2,5,2,6],[2,7,2,9],[0,0,0,2],[0,3,0,8],[5,9,7,9],[15,0,15,4],[16,0,16,4],[9,5,9,6],[9,7,9,8],[2,0,2,1],[2,2,2,4],[1,0,1,1],[1,2,1,7],[3,5,3,6],[9,0,9,4],[17,0,17,4],[18,0,18,4],[19,0,19,4]]}
[null,null,null,"Similarity Index - Estimated SI By Weight",null,null,null,null,null," August, 2019",null,"INSTRUCTIONS"]
["Producer Name:",null,"John Q Rancher",null,null,null,null,null,"Date:","2019-08-01",null,"1.  Identify a Key Monitoring Area that is representative for the site on the ranch being evaluated."]
["Ecological Site:",null,"MLRA 72 - Shallow Limy",null,null,"Plot Location:",null,"Enter GPS Coordinates",null,null,null,"2.  List all species present within the identified area. (A)"]
["Estimated Total Pounds / Ac:",null,null,1500,null,"Data Collector:",null,"S Q Planner",null,null,null,"3.  Estimate the pounds per acre (adjusted for end of season production - see Double sampling worksheet for reconstruction factors. (B)"]
[]
["A.  Species Name",null,null,null,null,"B.  estimated pounds/acre end-of-season reconstructed",null,"C.  pounds / acre listed in Ecological Site Description",null,"D.  Allowable Pounds / Acre"]
[null,null,null,null,null,null,null,null,null,null,null,"4.  List pounds per acre in the Reference Plant Community which are found in the Ecological Site Description ( C )"]
[]
["Big Bluestem",null,null,null,null,300,null,100,null,100,null,"5.  List the lesser of estimated pounds/ac for each species or the pounds / acre listed in the ESD. (D)"]
["Little Bluestem",null,null,null,null,250,null,325,null,250,null,"6.  List the Representative Production Value for the Reference Plant Community for the Ecological Site."]
["Sideoats Grama",null,null,null,null,150,null,300,null,150,null,"7.  List the sum of Column D (Allowable Pounds / Acre)"]
["Blue Grama",null,null,null,null,150,null,100,null,100,null,"8.  Divide the sum of the allowable pounds / acre (item F) by the RV (Representative Pounds of production) for the Reference Community.   This is the Similarity Index."]
["Hairy Grama",null,null,null,null,75,null,40,null,40]
["Needleandthread",null,null,null,null,80,null,25,null,25]
["Threadleaf Sedge",null,null,null,null,70,null,60,null,60]
["Slimflower Scurfpea",null,null,null,null,65,null,20,null,20]
["Purple Locoweed (Crazyweed)",null,null,null,null,30,null,5,null,5]
["Stemmy Four-Nerve Daisy",null,null,null,null,75,null,10,null,10]
["Dotted Gayfeather (Blazing star)",null,null,null,null,35,null,20,null,20]
["Small Soapweed",null,null,null,null,100,null,5,null,5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["E.  Production Representative value for in reference state (from Ecological Site Description:",null,null,null,null,null,null,null,null,1200]
[null,"F.  Total weight of allowable present (total of weight in column D :  ",null,null,null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",SUM(J9:J34))","v":785}]
[null,null,null,"Similarity Index = Item F/Item E * 100:",null,null,null,null,null,{"$f":"IF(J9=\"\",\"\",(J36/J35)*100)","v":65.416666666666671}]

{"sheet":"Total Production Worksheet","index":6,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,3,11,4],[11,6,11,7],[6,1,6,2],[6,5,6,6],[6,3,6,4],[7,1,7,2],[8,1,8,2],[7,3,7,4],[7,5,7,6],[8,3,8,4],[8,5,8,6],[6,7,9,9],[0,1,1,2],[2,0,2,1],[2,2,2,7],[0,3,0,8],[1,8,1,9],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[4,0,4,1],[4,2,4,4],[27,8,27,9],[18,1,18,2],[18,3,18,4],[25,1,25,2],[25,3,25,4],[22,1,22,2],[19,1,19,2],[18,6,18,7],[26,1,26,2],[26,3,26,4],[27,1,27,2],[27,3,27,4],[27,6,27,7],[21,1,21,2],[21,6,21,7],[21,8,21,9],[10,1,10,2],[10,3,10,4],[10,8,10,9],[10,6,10,7],[16,1,16,2],[16,3,16,4],[12,3,12,4],[13,3,13,4],[14,1,14,2],[14,6,14,7],[14,8,14,9],[15,1,15,2],[15,6,15,7],[15,8,15,9],[14,3,14,4],[16,6,16,7],[11,8,11,9],[12,1,12,2],[12,6,12,7],[12,8,12,9],[13,1,13,2],[13,6,13,7],[15,3,15,4],[22,3,22,4],[16,8,16,9],[17,6,17,7],[17,8,17,9],[18,8,18,9],[21,3,21,4],[20,1,20,2],[20,6,20,7],[20,8,20,9],[19,3,19,4],[20,3,20,4],[19,6,19,7],[19,8,19,9],[17,1,17,2],[17,3,17,4],[13,8,13,9],[0,11,0,19],[2,11,4,19],[5,11,5,19],[6,11,8,19],[9,11,9,19],[10,11,12,19],[28,0,29,7],[28,8,29,9],[4,6,4,7],[11,5,27,5],[23,1,23,2],[23,3,23,4],[23,6,23,7],[23,8,23,9],[24,1,24,2],[24,3,24,4],[24,6,24,7],[24,8,24,9],[22,6,22,7],[22,8,22,9],[25,6,25,7],[25,8,25,9],[26,6,26,7],[26,8,26,9]]}
[null,null,null,"CLIPPING FOR TOTAL PRODUCTION WORKSHEET",null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null," August, 2019",null,null,"1.  Identify a Key Monitoring Area that is representative for the site on the ranch being evaluated."]
["Producer Name:",null,null,null,null,null,null,null,"Date:",null,null,"2. Clip all vegetation located within the plot and place into a bag.  Clip to ground level and remove all standing dead (unless from earlier in the current growing season) and litter.  Clip a minimum of 5 plots and place all current year's growth into"]
["Ecological Site:",null,null,null,null,"Evaluation Location:"]
["Data Collector:",null,null,null,null,null,"Number of Plots:"]
[null,null,null,null,null,null,null,null,null,null,null,"3.  Allow the clippings to air dry."]
["Plot Size ft2","Multiplier",null,"Plot Size ft2",null,"Multiplier",null,"Multiply Grams clipped by the appropriate conversion factor based on plot size.  Obtain dry weight by drying after clipping OR convert to dry weight using the air dry conversion chart .",null,null,null,"4.  Alternatively, use the Air Dry table to estimate the % dry matter present in various structural/functional groups at selected growth stages to estimate dry matter.  This method is not recommended unless plants are sorted out by functional group."]
[1.92,50,null,2.4,null,40]
[4.8,20,null,9.6,null,10]
[null,null,null,null,null,null,null,null,null,null,null,"5.  Multiply the grams of herbage clipped and dried by the plot size multiplier to obtain pounds / acre."]
["Plot Number","Grams Clipped",null,"Grams Clipped x % Dry Weight From Conversion Table",null,"OR","Grams Dried",null,"Pounds / Acre",null,null,"6.  If end of season production figures are desired, use correction factors for % grazed, % of growth completed and % of normal.   See Double Sampling Worksheet instructions for explanation of how to reconstruct end of season production."]
[1,99,null,"N/A",null,null,43,null,{"$f":"42*50","v":2100}]
[2,98,null,"N/A",null,null,47,null,2350]
[3,72,null,"N/A",null,null,32,null,1600]
[4,76,null,"N/A",null,null,37,null,1850]
[5,108,null,"N/A",null,null,48,null,2400]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["AVERAGE PRODUCTION AT TIME OF CLIPPING:  ",null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",SUM(I12:J28)/I5)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Cover Worksheet","index":7,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[15,0,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[14,5,14,6],[14,7,14,8],[14,1,14,2],[14,3,14,4],[10,11,10,17],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[11,0,11,8],[8,11,9,17],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[0,8,1,8],[2,2,2,6],[3,2,3,4],[6,0,7,8],[0,11,1,17],[2,11,4,17],[0,1,1,2],[2,0,2,1],[3,0,3,1],[3,5,3,6],[3,7,3,8],[4,0,4,1],[4,2,4,4],[0,3,0,7],[1,3,1,7]]}
[null,null,null,"COVER CLASS WORKSHEET",null,null,null,null,"   August, 2019",null,null,"INSTRUCTIONS:  "]
[null,null,null,"For Rangeland Health Cover Classes"]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,"Date:","2019-08-01",null,null,"1.  Using a point intercept method (line-point intercept, step-point, modified step-point or 10-pin frame) read at least 100 points and record whether the pin drop hit vegetation, rock/gravel, litter or bare ground."]
["Ecological Site:",null,"MLRA 72 Loamy Tableland",null,null,"Evaluation Location:",null,"Enter GPS Coordinates"]
["Data Collector:",null,"S. Q. Planner"]
[]
["POINTS 1-50"]
[]
["Category","B ","Bare Ground","L","Litter","R","Rock, Gravel","V","Vegetation",null,null,"2.  In one pin drop, Vegetation, rock/gravel and/or litter may all be recorded.  Bare ground is ONLY recorded if no vegetation, no rock and no litter are intercepted by the pin as it is lowered to the ground surface."]
["Dot Count ","…...",null,"…..................................",null,".",null,"........................................."]
["Hits",6,null,37,null,1,null,41,null,null,null,"3.  This method is a quick way to record bare ground litter for Rangeland Health Assessments."]
["POINTS 51-100"]
["Category","B ","Bare Ground","L","Litter","R","Rock, Gravel","V","Vegetation"]
["Dot Count ",". . . . . . .",null,". . . . . . . . . . . . . . . . . . . . . .",null,null,null,". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
["Hits",7,null,22,null,0,null,37]
["SUMMARY"]
["% Cover",{"$f":"(B11+B15)/100","v":0.13},null,{"$f":"(D11+D15)/100","v":0.59},null,{"$f":"(F11+F15)/100","v":0.01},null,{"$f":"(H11+H15)/100","v":0.78}]
["Cover Type","Bare Ground",null,"Litter",null,"Rock",null,"Vegetatative"]

{"sheet":"Rangeland Health","index":8,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,8,1,9],[12,0,12,9],[10,4,10,9],[11,4,11,9],[10,0,10,2],[11,0,11,2],[7,4,7,9],[8,4,9,9],[0,1,1,2],[2,0,2,1],[2,2,2,7],[6,0,6,2],[6,4,6,9],[7,0,7,2],[8,0,8,2],[9,0,9,2],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[4,0,4,1],[4,2,4,4],[18,0,18,2],[18,3,18,5],[18,7,18,9],[19,0,19,2],[19,3,19,5],[19,7,19,9],[16,3,16,5],[16,7,16,9],[17,0,17,2],[17,3,17,5],[16,0,16,2],[17,7,17,9],[13,3,13,5],[14,0,14,2],[14,3,14,5],[14,7,14,9],[15,0,15,2],[15,3,15,5],[15,7,15,9],[13,0,13,2],[13,7,13,9],[20,3,20,5],[20,7,20,9],[21,0,21,2],[21,3,21,5],[21,7,21,9],[20,0,20,2],[24,0,24,2],[24,3,24,5],[24,7,24,9],[27,0,27,2],[27,3,27,5],[27,7,27,9],[26,0,26,2],[25,0,25,2],[25,3,25,5],[25,7,25,9],[26,7,26,9],[22,0,22,2],[22,3,22,5],[22,7,22,9],[23,0,23,2],[23,3,23,5],[23,7,23,9],[28,0,28,2],[28,3,28,5],[28,7,28,9],[29,0,29,2],[29,3,29,5],[29,7,29,9],[46,0,59,0],[60,0,73,0],[73,1,73,3],[73,4,73,5],[62,6,73,9],[46,6,47,9],[48,6,59,9],[0,12,0,18],[2,12,5,18],[6,12,7,18],[60,6,61,9],[59,1,59,3],[59,4,59,5],[30,0,30,2],[30,3,30,5],[30,7,30,9],[31,0,31,9],[32,0,45,0],[34,6,45,9],[32,6,33,9],[45,1,45,3],[45,4,45,5],[26,3,26,5]]}
[null,null,null,"RANGELAND HEALTH EVALUATION WORKSHEET",null,null,null,null,null,null,null,null,"INSTRUCTIONS:  See Latester version of Interpreting Indicators of Rangeland Health for detailed instructions."]
[null,null,null,null,null,null,null,null,"August, 2019",null,null,null,"1.  Confirm the Ecological Site (do not use Soil Survey use on-site observations)"]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,null,"Date:","2019-08-01",null,null,"2.  Rate each indicator based on the departure from Reference State using the Rangeland Health Worksheets found in the Ecological Site Descriptions and the RH Evaluation Matrix."]
["Ecological Site:",null,"MLRA 72 - Rolling Sands",null,null,"Evaluation Location:",null,"Enter GPS Coordinates"]
["Data Collector:",null,"S.Q. Planner"]
[]
["Departure from Expected",null,null,"Code","Instructions for Evaluation Sheet",null,null,null,null,null,null,null,"3.  On page 2, use the individual indicator rankings to create a histogram showing the indicators and levels of departures and evaluate to determine the level of departure for the three attributes.  Write the indicator numbers in the appropriate columns starting from the bottom and working up."]
["None to Slight",null,null,"N-S","1.  Assign the 17 indicator ratings.  If an indicator is not present, rate it None-Slight."]
["Slight to Moderate ",null,null,"S-M","2.  In the three grids on the back page, write the indicator number in the opposite column for each indicator that is applicable to the attribute."]
["Moderate",null,null,"M"]
["Moderate to Extreme",null,null,"M-E","3.  Assign an overall rating for each attribute based on the preponderance of evidence."]
["Extreme to Total",null,null,"E-T","4.  Justify each attribute rating in writing."]
[]
["Indicator",null,null,"Applicable Attribute",null,null,"Rating","Comments"]
["1.  Rills",null,null,"Soil and Hydrologic Function",null,null,"S-M","Scattered rills throughout the site"]
["2.  Water Flow Patterns",null,null,"Soil and Hydrologic Function",null,null,"N-S","Flow Patterns only found in the steepest areas"]
["3.  Pedestals /Terracettes",null,null,"Soil and Hydrologic Function",null,null,"N-S","No pedestals or terracettes found"]
["4. Bare Ground%",null,null,"Soil and Hydrologic Function",null,null,"S-M","25% bare ground measured throughout the site"]
["5.  Gullies",null,null,"Soil and Hydrologic Function",null,null,"N-S","No gullies on site"]
["6. Wind-scoured, blowouts, and/or deposition areas",null,null,"Soil Stability",null,null,"N-S","No evidence of wind erosion"]
["7.  Litter movement",null,null,"Soil Stability",null,null,"N-S","A few areas with litter movement, but litter is only moved short distances"]
["8. Soil surface resistance to erosion",null,null,"Soil, Hydrologic Function, Biotic Integrity",null,null,"N-S","All stability ratings are 5 or 6; average is 5.4"]
["9. Soil surface loss or degradation",null,null,"Soil, Hydrologic Function, Biotic Integrity",null,null,"N-S","No evidence of past erosion; soil structure is as should be, soil surface is approximately 6\" thick."]
["10. Plant community composition and distribution relative to infiltration",null,null,"Hydrologic Function",null,null,"S-M","There has been ssignificant replacement of cool-season bunch grasses by Kentucky bluegrass  but not enough to impact hydrologic function (N-S for rills, pedestals, water flow patterns)."]
["11. Compaction layer",null,null,"Soil, Hydrologic Function, Biotic Integrity",null,null,"N-S","No compaction layer"]
["12. Functional/structural groups",null,null,"Biotic Integrity",null,null,"S-M","All expected Structural/functional groups are present.  Tall rhizomatous grasses groupd is dominated by Switchgrass & no Indiangrass.  Kentucky bluegrass has invaded the site (5% of production)."]
["13. Plant mortality / decadence",null,null,"Biotic Integrity",null,null,"S-M","The re is excessive mortality in the centers of bunch grasses such as blue grama and death loss of threadleaf sedge."]
["14. Litter amount",null,null,"Hydrologic Function, Biotic Integrity",null,null,"S-M","Litter amounts are below that expected for the site (25% vs. 50%)"]
["15. Annual Production",null,null,"Biotic Integrity",null,null,"N-S","RV production is 2500/measured production is 2400"]
["16. Invasive Plants",null,null,"Biotic Integrity",null,null,"S-M","Kentucky bluegrass, Canada thistle  have invaded the site and Eastern red cedar is becoming a much larger component of the plant community than expected in reference."]
["17. Reproductive capability of perennial plants",null,null,"Biotic Integrity",null,null,"S-M","The number of fertile tillers of  big bluestem and sideoats grama are  less than expected.  The size of individual tillers is reduced from expected."]
[]
["Soil and Site Stability :  Indicator Ratings",null,null,null,null,null,"Attribute Rating Justification:  Soil and Site Stability"]
[]
[null,null,null,null,null,null,"The majority of the indicators are in the none-slight category.  The indicators that are in S-M are rills and % bare ground. While not serious enough to warrant designating this attibute as S-M, the amount of bare ground does indicate that there could be issues if the lack of cover continues.  Recommend monitoring the % bare ground each year and making adjustments in grazing utilization levels when bare ground exceeds 30%."]
[]
[null,null,null,null,null,11]
[null,null,null,null,null,9]
[null,null,null,null,null,8]
[null,null,null,null,null,7]
[null,null,null,null,null,6]
[null,null,null,null,null,5]
[null,null,null,null,4,3]
[null,null,null,null,1,2]
[null,"E-T","M-E","M","S-M","N-S"]
[null,"Attribute Rating:",null,null,"N-S"]
["Hydrologic Functions:  Indicator Ratings",null,null,null,null,null,"Attribute Rating Justification:  Hydrologic Function"]
[]
[null,null,null,null,null,null,"While the slight majority of the indicators are in N-S category, the indicators that are in S-M are more critical for this ecological site.  Water infiltration (related to bare ground and functional groups) is critical for production and health of this site."]
[]
[]
[]
[null,null,null,null,null,11]
[null,null,null,null,null,9]
[null,null,null,null,14,8]
[null,null,null,null,10,5]
[null,null,null,null,4,3]
[null,null,null,null,1,2]
[null,"E-T","M-E","M","S-M","N-S"]
[null,"Attribute Rating:",null,null,"S-M"]
["Biotic Integrity:  Indicator Ratings",null,null,null,null,null,"Attribute Rating Justification: Biotic Integrity"]
[]
[null,null,null,null,null,null,"Several indicators show that this site is on it's way toward reaching a threshold and is moving toward an less productive state.  While annual production is not less than the reference, the loss of species in the dominant functional group, the beginning invasion of Kentucky bluegrass and other invasive plants and the beginning loss of reproductive capacity of some perennial plants are warning signs.  At the current time this can realtively quickly be stopped, if not turned around with adustments to the grazing strategy."]
[]
[]
[]
[null,null,null,null,17]
[null,null,null,null,16]
[null,null,null,null,14,15]
[null,null,null,null,13,11]
[null,null,null,null,12,9]
[null,null,null,null,10,8]
[null,"E-T","M-E","M","S-M","N-S"]
[null,"Attribute Rating:",null,null,"S-M"]

{"sheet":"Infiltration","index":9,"n_rows":49,"n_cols":32,"rows_kept":49,"cut":false,"hidden":false,"merged":[[27,23,27,28],[32,5,32,10],[33,5,33,10],[34,5,34,10],[28,3,31,4],[32,3,35,4],[27,3,27,10],[32,11,32,16],[33,11,33,16],[34,11,34,16],[33,17,33,22],[34,17,34,22],[28,23,28,28],[29,23,29,28],[30,23,30,28],[27,11,27,16],[27,17,27,22],[28,11,28,16],[29,11,29,16],[30,11,30,16],[31,11,31,16],[28,17,28,22],[29,17,29,22],[30,17,30,22],[17,28,17,30],[17,31,17,32],[17,0,17,7],[7,4,7,33],[9,20,9,33],[9,0,9,3],[9,4,9,10],[9,11,9,13],[9,14,9,15],[8,26,8,27],[8,28,8,29],[8,30,8,33],[7,0,7,3],[9,16,9,19],[8,0,8,3],[8,4,8,14],[8,15,8,18],[8,19,8,22],[8,24,8,25],[14,15,14,17],[15,0,15,3],[12,0,12,6],[14,7,14,10],[15,7,15,10],[43,33,46,33],[42,0,42,2],[48,1,49,32],[48,33,50,33],[38,33,41,33],[20,18,22,28],[23,9,23,14],[23,1,23,8],[37,0,37,6],[28,5,28,10],[29,5,29,10],[30,5,30,10],[31,5,31,10],[35,5,35,10],[35,11,35,16],[35,17,35,22],[32,17,32,22],[31,23,31,28],[32,23,32,28],[33,23,33,28],[34,23,34,28],[35,23,35,28],[25,3,25,28],[26,3,26,28],[19,0,19,8],[19,9,19,14],[17,16,17,23],[17,24,17,26],[21,2,21,8],[21,9,21,14],[20,10,20,14],[17,8,17,14],[22,9,22,14],[31,17,31,22],[38,1,41,32],[43,1,46,32],[14,24,15,26],[15,15,15,23],[13,11,13,14],[14,11,14,14],[15,11,15,14],[11,0,11,33],[14,18,14,23],[12,24,12,26],[13,24,13,26],[12,27,12,29],[13,27,13,29],[12,30,12,33],[13,30,13,33],[14,30,14,33],[14,27,15,29],[15,30,15,33],[12,7,12,14],[15,4,15,6],[12,15,12,23],[13,15,13,17],[13,18,13,23],[13,0,13,3],[13,7,13,10],[14,0,14,3],[13,4,13,6],[14,4,14,6],[6,0,6,3],[6,4,6,23],[10,0,10,4],[10,5,10,10],[10,13,10,18],[10,19,10,24],[6,25,6,27],[6,28,6,31],[4,2,4,5],[4,7,4,13],[4,14,4,26],[4,27,4,33],[5,0,5,5],[5,6,5,10],[5,12,5,18],[5,19,5,22],[5,24,5,29],[5,30,5,33],[0,0,2,2],[1,28,1,33],[2,28,2,33],[3,5,3,9],[3,11,3,14],[4,0,4,1],[3,28,3,29],[3,30,3,33],[0,7,2,27],[3,15,3,26],[3,0,3,4]]}
[null,null,null,null,null,null,null,"Rangeland Soil Health Infiltration Record"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2019"]
["Date of Observation:",null,null,null,null,null,null,null,null,null,null,"Producer Name:",null,null,null,"Johnny Q. Rancher",null,null,null,null,null,null,null,null,null,null,null,null,"Legal:",null,"NWSW 12-1-41"]
["Site #: ",null,"#1",null,null,null,null,"Location or GPS Coordinates:",null,null,null,null,null,null,"Enter GPS Coordinates"]
["Date of Last Precipitation:",null,null,null,null,null,"2019-07-15",null,null,null,null,null,"Amount of Last Preciptation:",null,null,null,null,null,null,"1.25\"",null,null,null,null,"Type of Last Precipitation:",null,null,null,null,null,"Rain & Hail"]
["Current Mgt. Type:",null,null,null,"20 pasture rotation, twice through May - October",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years In:",null,null,2]
["Historic Mgt. Type:",null,null,null,"4 pasture, deferred rotation, once through"]
["Map Unit Name:",null,null,null,"Coly-Uly Silt Loams, 6-11% eroded",null,null,null,null,null,null,null,null,null,null,"Map Unit Symbol:",null,null,null,2557,null,null,null,null,"% Slope:",null,0.06,null,"Aspect:",null,"NW facing slope"]
["Ecological Site:",null,null,null,"Limy Slopes",null,null,null,null,null,null,"MLRA:",null,null,72,null,"Vegetation Type:",null,null,null,"Mid-Grass Prairie; 30% cool season, 70% warm season"]
["Date last field exam:",null,null,null,null,"N/A",null,null,null,null,null,null,null,"Compaction: (Yes/No)",null,null,null,null,null,"No"]
[]
["Soil Texture",null,null,null,null,null,null,"Soil Color",null,null,null,null,null,null,null,"Soil Aggregation Description",null,null,null,null,null,null,null,null,"Surface pH",null,null,"Shaded (Y/N)",null,null,"Slope Shape"]
["Surface [0 to 4\"]  ",null,null,null,"Silt Loam",null,null,"Surface [0 to 4\"] ",null,null,null,"10YR 3/1",null,null,null,"0-4\"   ",null,null,"Excellent",null,null,null,null,null,7.3,null,null,"No",null,null,"(Flat/Concave/Convex)"]
["Subsurface [4 to 8\"]  ",null,null,null,"Silt Loam",null,null,"Subsurface [4 to 8\"] ",null,null,null,"10YR 3/1, 2",null,null,null,"4-8\"   ",null,null,"Excellent",null,null,null,null,null,null,null,null,null,null,null,"Convex"]
["Subsoil [8 to 12\"]  ",null,null,null,"Loam",null,null,"Subsoil [8 to 12\"]",null,null,null,"N/A"]
[]
[">95% Surface Canopy (YES/NO):",null,null,null,null,null,null,null,"YES",null,null,null,null,null,null,null,"Earthworms or tunnels? (YES/NO)  ",null,null,null,null,null,null,null,"YES",null,null,null,"Number",null,null,2]
[]
["Infiltration Type (Single or Double Ring):  ",null,null,null,null,null,null,null,null,"Single"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attach photo showing approximate location of infiltration test(s)."]
[null,null,"Ring Size:",null,null,null,null,null,null,"6\""]
[]
[null,"Amount of H2O Used:",null,null,null,null,null,null,null,"444 ml."]
[]
[null,null,null," Infiltration Time"]
[null,null,null,"Expressed in Minutes and Seconds"]
[null,null,null,null,null,null,null,null,null,null,null,"Ring #1",null,null,null,null,null,"Ring #2",null,null,null,null,null,"Ring #3"]
[null,null,null,"First Inch",null,"Time for 1/2\"",null,null,null,null,null,"0' 30\"",null,null,null,null,null,"0' 45\"",null,null,null,null,null,"1' 30\""]
[null,null,null,null,null,"Time for 3/4\"",null,null,null,null,null,"2' 15\"",null,null,null,null,null,"3' 20\"",null,null,null,null,null,"4' 15\""]
[null,null,null,null,null,"Time for 7/8\"",null,null,null,null,null,"6' 15\"",null,null,null,null,null,"6' 30\"",null,null,null,null,null,"7' 15\""]
[null,null,null,null,null,"Time for 1 Inch",null,null,null,null,null,"7' 35\"",null,null,null,null,null,"8' 35\"",null,null,null,null,null,"9' 45\""]
[null,null,null,"Second Inch",null,"Time for 1/2\"",null,null,null,null,null,"3' 30\"",null,null,null,null,null,"5' 30\"",null,null,null,null,null,"6' 00\""]
[null,null,null,null,null,"Time for 3/4\"",null,null,null,null,null,"12' 00\"",null,null,null,null,null,"12' 30\"",null,null,null,null,null,"12' 30\""]
[null,null,null,null,null,"Time for 7/8\"",null,null,null,null,null,"17' 20\"",null,null,null,null,null,"20' 20\"",null,null,null,null,null,"18' 30\""]
[null,null,null,null,null,"Time for 1 Inch",null,null,null,null,null,"22' 25\"",null,null,null,null,null,"25' 25\"",null,null,null,null,null,"24' 25\""]
[]
["Species (%) Present at Site: "]
[null,"50% Big Bluestem, 20% Little Bluestem, 10% Sideoats Grama, 10% cool season grasses, 10% forbs."]
[]
[]
[]
["NOTES:"]
[null,"Soil aggregaes are large and strongly pronounced, but few macropores from old roots and earthworms.  "]
[]
[]
[]
[]
[null,"[Please note: If grass occurs within the ring--clip it down close to the surface.  Plastic wrap may or may not work to cover the whole ring. Simply lay plastic wrap in part of the ring and pour water on plastic to avoid pulverizing aggregates.  Start time as you pour in that case. ]"]

{"sheet":"Quick Forage Balance Check","index":10,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,14],[20,9,20,10],[27,3,27,5],[27,6,27,7],[8,0,8,2],[8,10,8,11],[17,9,17,10],[16,0,16,5],[3,0,3,2],[5,0,5,2],[7,0,7,2],[7,10,7,11],[1,16,1,21],[2,16,3,21],[4,16,5,21],[6,16,7,21],[34,0,34,2],[25,2,25,3],[28,3,28,4],[28,6,28,7],[32,2,32,3],[33,3,33,4],[1,0,1,14],[34,4,34,5],[9,16,10,21],[11,16,12,21]]}
["QUICK FORAGE BALANCE CALCULATOR"]
["TO COMPLETE THIS ESTIMATE FILL IN THE YELLOW HIGHLIGHTED CELLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.  This is a quick method of determining whether stocking rates are close to NRCS recommended stocking rates."]
["Number of grazing Animals:",null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.  Obtain the information about the herd and grazing program from the producer. "]
["Average Weight of Animals:",null,null,null,1300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.  Obtain average forage production values from the Ecological Site Description for the predominant ecological site(s)."]
["Adjusted animal units (AU):",null,null,null,{"$f":"E4","v":50},"animals","X",{"$f":"E6","v":1300},"lbs =",{"$f":"(E8*H8)/1000","v":65},"AU (animal Units)"]
["One animal eats 90% of:",null,null,null,{"$f":"E6","v":1300},"# / mo.","or",{"$f":"E6","v":1300},"x 0.9 =",{"$f":"E9*0.9","v":1170},"lbs. per month or ",null,{"$f":"J9/30","v":39},"per day",null,null,"4.  Type the operation specific numbers in the yellow highlighted cells."]
["The ",{"$f":"E8","v":50},"animals each eat",null,null,{"$f":"J9","v":1170},"lbs per month, so the herd eats",null,null,null,{"$f":"B10*F10","v":58500},"pounds each month",null,null,null,null,"5.  The number in the bottom row will indicate how current numbers compare to recommended stocking rates."]
[]
["Acres of land in the grazing unit:",null,null,null,265,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  This is tool to be used to make a quick check and not intended to be a final NRCS recommendation."]
[]
["The land on average produces:",null,null,null,3000,"lbs of forage per acre per year on average (RV from Ecological Site Description)"]
["The total forage production for the unit is:",null,null,null,null,{"$f":"E12","v":265},null,{"$f":"E14","v":3000},"lbs per acre =",null,{"$f":"F15*H15","v":795000},"total lbs per year on average"]
[]
["The Proper Grazing Use Factor or \"Take half, leave Half\":",null,null,null,null,null,null,0.5]
[null,{"$f":"K15","v":795000},"lbs total forage per year average",null,null,null,"X",0.5,"equals",{"$f":"B18*H18","v":397500},null,"pounds available forage per year."]
[]
["Utilization Factor ",null,"(50% continuous season long, 60% grazing system, 70% planted perennial grasses)"]
[null,{"$f":"J18","v":397500},"lbs availabe forage  X",null,null,0.5,"Utilization factor = ",null,null,{"$f":"B21*F21","v":198750},null,"utilizable forage per year"]
[]
["The carrying capacity of the grazig unit is:"]
[null,{"$f":"J21","v":198750},"lbs of utilizable forage / 30 lbs per day or 912 lbs/month",null,null,null,null,null,null,{"$f":"B24/912","v":217.92763157894737},"AUM for the grazing unit"]
[]
["The grazing season is ",null,4.25,null,"months"]
["The adjusted AU on the land is:",null,null,null,{"$f":"J8","v":65},"Animal units for based on the number and weight of the grazing animals"]
["The  AUM demand is:",null,{"$f":"C26*E27","v":276.25},"  Animal Unit Months or ",null,null,{"$f":"C28*30","v":8287.5},null,"Animal Unit Days"]
["The stocking rate is ",null,{"$f":"C28","v":276.25},"AUM",null," / ",{"$f":"E12","v":265},null,"Acres =",{"$f":"C29/G29","v":1.0424528301886793},"AUM/AC"]
[null,"OR",{"$f":"G29","v":265},"AC"," / ",{"$f":"C29","v":276.25},"=",{"$f":"C30/F30","v":0.95927601809954754},"Acres/ AUM"]
[]
["The length of time the land can support the herd while maintaing productivity, health and vigor is:"]
[null,null,{"$f":"J21","v":198750},null,"lbs. utilizable forage / ",null,null,{"$f":"K10","v":58500},"lbs. forage needed by the herd each month"]
[null,null,"or",{"$f":"C33/H33","v":3.3974358974358974},null,"months","or",{"$f":"D34*30","v":101.92307692307692},"days"]
["The forage balance is:  ",null,null,null,{"$f":"(D34-C26)/C26","v":-0.20060331825037708}]

{"sheet":"Plant Census","index":11,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,12,15,18],[16,12,17,18],[19,12,20,18],[0,12,1,18],[4,12,7,18],[8,12,10,18],[11,12,12,18],[8,0,8,3],[8,5,8,6],[9,0,9,3],[10,0,10,3],[11,0,11,3],[19,0,19,3],[19,5,19,6],[18,0,18,3],[18,5,18,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[12,0,12,3],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,0,17,3],[17,5,17,6],[15,0,15,3],[0,8,1,9],[7,5,7,6],[6,4,6,9],[3,5,4,7],[4,0,4,1],[4,2,4,4],[0,1,1,2],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,4],[0,3,1,7],[6,0,7,3],[4,8,4,9],[16,0,16,3],[13,0,13,3],[14,0,14,3],[27,5,27,6],[20,0,20,3],[20,5,20,6],[21,0,21,3],[21,5,21,6],[22,0,22,3],[22,5,22,6],[24,0,24,3],[24,5,24,6],[25,0,25,3],[25,5,25,6],[26,0,26,3],[26,5,26,6],[36,0,36,3],[36,5,36,6],[31,0,31,3],[31,5,31,6],[32,0,32,3],[33,0,33,3],[32,5,32,6],[33,5,33,6],[34,0,34,3],[34,5,34,6],[35,0,35,3],[35,5,35,6],[30,5,30,6],[23,0,23,3],[23,5,23,6],[28,0,28,3],[28,5,28,6],[27,0,27,3],[29,0,29,3],[29,5,29,6],[30,0,30,3]]}
[null,null,null,"PLANT CENSUS",null,null,null,null,"                 August, 2019",null,null,null,"INSTRUCTIONS"]
[]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,null,"Date:","2019-08-01"]
["Ecological Site:",null,"MLRA 72 - Shallow Limy",null,null,"Evaluation Location:",null,null,null,null,null,null,"1.  Identify Key Area"]
["Data Collector:",null,"S J Planner",null,null,null,null,null,"Enter GPS Coordinates",null,null,null,"2.  Determine size of area to be evaluated.  Area should be at least 150' in diameter (can identify this by setting 2' 150' tapes- one lined up E-W and one lined up N-S)"]
[]
["PLANT SPECIES",null,null,null,"Abundance Category (# plants in census area)"]
[null,null,null,null,"1 (1-10)","2 (11-100)",null,"3 (101-500)","4 (501-1000)","5 (> 1000)"]
["Western Wheatgrass",null,null,null,null,null,null,"X",null,null,null,null,"3.  Inspect the area being evaluated and list every plant found.  Limit time to 10 minutes.  If after 9 minutes new plants are still being found add an additional 2 minutes."]
["Prairie Junegrass",null,null,null,null,"X"]
["Blue Grama",null,null,null,null,null,null,"X"]
["Hairy Grama",null,null,null,null,"X",null,null,null,null,null,null,"4.  If there are unknown plants in the area, identify the plants later rather than using time designated for listing plants."]
["Sideoats Grama",null,null,null,null,null,null,null,"X"]
["Prairie Sandreed",null,null,null,"X",null,null,null,null,null,null,null,"5.  After the time is up, categorize each plant according to their abundance (number of individual plants) using the categories listed on the form."]
["Threadleaf Sedge",null,null,null,null,null,null,null,"X"]
["Little Bluestem"]
["Scarlet Globe Mallow",null,null,null,null,"X",null,null,null,null,null,null,"This is a quick method to determine if desired plants are increasing; or conversely if undesirable plants are increasing."]
["Lavendar Leaf Evening Primrose",null,null,null,null,"X"]
["Stemmy Hymenoxys",null,null,null,null,"X"]
["Green Milkweed",null,null,null,"X",null,null,null,null,null,null,null,"Recommend developing a list of common plants for a county or county/site combination and entering on this form."]
["Dwarf Milkweed",null,null,null,null,"X"]
["Carolina Larkspur",null,null,null,"X"]
["James Nailwort",null,null,null,null,"X"]
["Silky Milkvetch",null,null,null,null,"X"]
["Bractless Mentzelia",null,null,null,null,"X"]
["Lambert's Crazyweed",null,null,null,"X"]
["Textile Onion",null,null,null,"X"]
["Rush Skelaton Plant",null,null,null,null,"X"]
["Rayless Greenthread",null,null,null,"X"]
["Slimflower Scurfpea",null,null,null,null,"X"]
["Needleandthread",null,null,null,null,null,null,null,"X"]
["Scarlet Beeblossom",null,null,null,"X"]
["Silverleaf Scurfpea",null,null,null,null,"X"]
["Narrowleaf (Fringed)Gromwell",null,null,null,null,"X"]
["WavyLeaf Thistle",null,null,null,"X"]

{"sheet":"Line Point Intercept","index":12,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,14,12,20],[13,14,15,20],[3,14,3,20],[2,10,2,11],[0,14,1,20],[4,14,6,20],[7,14,10,20],[0,10,1,11],[0,4,0,8],[0,1,0,3],[6,8,6,10],[6,11,7,11],[34,0,34,11],[1,1,1,3],[3,5,3,7],[3,8,3,11],[4,0,4,2],[4,3,4,7],[1,4,1,8],[36,0,36,11],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,4],[6,2,6,4],[6,5,7,5],[6,0,7,0],[6,1,7,1],[6,6,7,6],[6,7,7,7],[5,0,5,11],[4,8,4,11]]}
[null,null,null,null,"POINT-INTERCEPT DATA SHEET",null,null,null,null,null,"August, 2019",null,null,null,"INSTRUCTIONS:  "]
[null,null,null,null,"For Line Point, Modified Step Point, or Point Frame"]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,null,null,"Date:","2019-08-01",null,null,null,"1.  Locate key area and randomly select a inventory point within the area."]
["Ecological Site:",null,"MLRA 72 - Sandy",null,null,"Evaluation Location:",null,null,"Enter GPS Coordinates",null,null,null,null,null,"2.  Layout a 150' tape with the center point at the random inventory point.  "]
["Data Collected by:",null,null,"S Q Planner",null,null,null,null,null,null,null,null,null,null,"3.  Slowly lower a flag or other thin pin/pointer device to the soil surface.  Record the plants that the flag touches while being lowered.  The top layer is the 1st foliar or canopy cover that the pin moves through."]
[]
["Point","Top Layer","Lower Layers",null,null,"Soil Surface","Point","Top Layer","Lower Layers",null,null,"Soil Surface"]
[null,null,"Code 1","Code 2","Code 3",null,null,null,"Code 1","Code 2","Code 3",null,null,null,"4.  Record in the lower layers boxes any other species encountered by the pin if these are different species from the 1st point.  If the 1st plant encountered is Blue Grama, the second is blue grama and the third is litter, record Blue Grama in the top layer box and litter in the 2nd box. "]
[1,"Big Blue","B. Grama",null,null,"S ",26,"N",null,null,null,"BG"]
[{"$f":"A9+1","v":2},"Big Blue",null,null,"HL","S",{"$f":"G9+1","v":27},"N",null,null,null,"BG"]
[{"$f":"A10+1","v":3},"N",null,null,"HL","S",{"$f":"G10+1","v":28},"N",null,null,null,"BR"]
[4,"N",null,null,null,"BG",29,"Big Blue",null,null,"HL","S ",null,null,"5.  The Soil surface will either be soil, rock, moss, lichen or if the pin encounters a plant base, the name of the plant.  "]
[5,"Sideoats","B. Grama","KBG",null,"S",30,"Big Blue","Sideoats","B Grama","HL","S"]
[6,"Sideoats","P. June",null,"OL","S",31,"Little Bl.",null,null,null,"S",null,null,"6.  If there is no foliar or canopy cover at the point and no litter then the top layer is N (none), the lower layers are blank, and the soil surface is BG (bare ground)."]
[7,"Breadrt.","B. Grama","KBG","HL","S",32,"Little Bl.",null,null,null,"S"]
[8,"Little Blue",null,null,null,"Little Bl.",33,"P June",null,null,"HL","S"]
[9,"Leadpl",null,null,null,"S",34,"B Grama",null,null,null,"S",null,null,"7.  Record data at 3' intevals"]
[10,"ERC","KBG",null,"HL","S",35,"N&Thr","B Grama",null,"HL","S"]
[11,"Western","B. Grama",null,"HL","S",36,"N&Thr",null,null,"HL","S"]
[12,"Western",null,null,"HL","S",37,"N",null,null,"HL","S"]
[13,"Scurfpea","Western","Blue G","HL","S",38,"N",null,null,null,"BG"]
[14,"N",null,null,"HL","S",39,"Western","B Grama",null,"HL","S"]
[15,"N",null,null,null,"BG",40,"KBG",null,null,"HL","S"]
[16,"Gromwell","B. Grama",null,"HL","S",41,"KBG",null,null,"HL","S"]
[17,"B.Grama",null,null,"HL","S",42,"Cheatgr",null,null,"HL","S"]
[18,"Western",null,null,"HL","S",43,"B Grama","Cheatgr",null,"HL","S"]
[19,"Western",null,null,null,"S",44,"N",null,null,"HL","S"]
[20,"B Grama",null,null,null,"B Grama",45,"P June","B Grama","Cheatgr","HL","S"]
[21,"Buffalogr",null,null,"HL","S",46,"Little Bl.",null,null,null,"Little Bl."]
[22,"P. S. Reed",null,null,"HL","S",47,"N",null,null,"HL","S"]
[23,"P. S. Reed","B. Grama",null,"HL","S",48,"N",null,null,"HL","BR"]
[24,"P. S. Reed",null,null,null,"S",49,"P. S. Reed","B Grama",null,null,"S"]
[{"$f":"A32+1","v":25},"B Grama",null,null,null,"S",50,"B Grama","Cheatgr",null,"HL","S"]
[]
["Record the species code or common name for each canopy hit of a different plant encountered as the pin is lowered.  The first canopy is recorded in the top layer box.  Other species encountered are recorded in Code 1, 2 and 3 boxes (lower layers).  Litter should be recorded in the lower layers box not in the soil surface box.  HL = herbaceous litter, WL=woody litter, NL=non-vegetative litter, OL=manure or other organic litter."]
["If no canopy or foliar cover:  Record \"N\" in the Top layer box."]
["Bare ground (BG) only occurs when the top layer is \"N\" and there is no litter.  A point with no canopy or foliar cover, but with litter would have the correct litter code recorded in Code 1 of the lower layer boxes."]
["Soil Surface Codes:  R=Rock, BR= Bedrock, D=Duff, M=Moss, LC= Visible lichen on soil, S=Soil or Plant Code if Basal hit."]

{"sheet":"Landscape Appearance","index":13,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,12,7,18],[10,12,11,18],[1,12,1,18],[2,12,3,18],[4,12,6,18],[34,6,39,9],[5,0,5,9],[6,6,9,9],[10,6,12,9],[13,6,15,9],[16,6,18,9],[19,6,21,9],[22,6,24,9],[25,6,29,9],[30,6,32,9],[33,6,33,9],[33,0,36,2],[33,3,36,3],[33,4,36,4],[33,5,36,5],[37,0,39,1],[37,4,39,4],[37,5,39,5],[30,0,32,1],[30,2,32,2],[30,3,32,3],[30,4,32,4],[30,5,32,5],[37,2,38,3],[39,2,39,3],[25,0,29,1],[25,2,29,2],[25,3,29,3],[25,4,29,4],[25,5,29,5],[22,0,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[19,0,21,1],[19,2,21,2],[19,3,21,3],[19,4,21,4],[19,5,21,5],[16,0,18,1],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[13,0,15,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[13,5,15,5],[10,0,12,1],[10,2,12,2],[10,3,12,3],[10,4,12,4],[10,5,12,5],[6,0,9,1],[6,2,9,2],[6,3,9,3],[6,4,9,4],[6,5,9,5],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[4,0,4,1],[4,2,4,4],[0,1,1,2],[2,0,2,1],[2,2,2,7],[0,3,0,8],[1,3,1,8]]}
[null,null,null,"Utilization Documentation"]
[null,null,null,"Landscape Appearance Worksheet",null,null,null,null,null," August, 2019",null,null,"Instructions"]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,null,"Date:","2019-08-01",null,null,"This form outlines a quick way for producers to determine average utilization for a pasture. "]
["Ecological Site:",null,"MLRA 72 - Loamy Tableland",null,null,"Evaluation Location:",null,"Enter GPS Coordinates"]
["Data Collector:",null,"S. Q. Planner",null,null,null,null,null,null,null,null,null," 1.  At random locations in a pasture determine the level of utilization using the grazed class description (minimum of 10 locations)."]
[]
["Class Interval",null,"Midpoint (M)","Dot Count","# by Class (C)","# * Midpoint (M*C)","Grazed Class Description"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2.  Multiply the number of each grazed class by the midpoint"]
[]
[]
["0-5%",null,2.5,null,0,{"$f":"IF(E11=\"\",\"\",C11*E11)","v":0},"(0-5%) The rangeland shows no evidence of grazing or negligible use.",null,null,null,null,null,"3.  Calculate the average utilization using the formula at the bottom of the form."]
[]
[]
["6-20%",null,13,"..",2,{"$f":"IF(E14=\"\",\"\",C14*E14)","v":26},"(6-20%) The rangeland has the appearance of very light grazing. The herbaceous forage plants may be topped or slightly used. Current seedstalks and young plants are little disturbed."]
[]
[]
["21-40%",null,30,".",1,{"$f":"IF(E17=\"\",\"\",C17*E17)","v":30},"(21-40%) The rangeland may be topped, skimmed, or grazed in patches. The low value herbaceous plants are ungrazed and 60-80% of the number of current seedstalks of herbaceous plants remain intact. Most young plants are undamaged."]
[]
[]
["41-60%",null,50,". . . .",4,{"$f":"IF(E20=\"\",\"\",C20*E20)","v":200},"(41-60%) The rangeland appears entirely covered as uniformly as natural features and facilities allow. 15-25% of the number of current seedstalks of herbaceous species remain intact. No more than 10% of the low-value herbaceous forage plants are utilized (Moderate use is not necessarily proper use)."]
[]
[]
["61-80%",null,70,". .",2,{"$f":"IF(E23=\"\",\"\",C23*E23)","v":140},"(61-80%) The rangeland has the appearance of complete use. Herbaceous species are almost completely utilized, with less than 10% of the current seedstalks remaining. Shoots of rhizomatous grasses are not present. More than 10% of the number of low-value herbaceous forage plants have been utilized."]
[]
[]
["81-94%",null,88,".",1,{"$f":"IF(E26=\"\",\"\",C26*E26)","v":88},"(81-94%) The rangeland has a mown appearance and there are indications of repeated coverage. There is no evidence of reproduction or current seedstalks of herbaceous species. Herbaceous forage species are completely utilized. The remaining stubble of preferred grasses is grazed to the soil surface."]
[]
[]
[]
[]
["95-100%",null,97.5,null,0,{"$f":"IF(E31=\"\",\"\",C31*E31)","v":0},"(95- 100%)  The rangeland appears to have been completely utilzed. More than 50% of the low-value herbaceous plants have been utilized."]
[]
[]
["Where C= the number of observations wihin each class interval (column C) and M= the class interval midpoint (column M), and S = the sum.",null,null,"TOTALS",{"$f":"SUM(E11:E33)","v":10},{"$f":"SUM(F11:F33)","v":484},"NOTES:"]
[]
[]
[]
["Average Utilization  ",null,"S (CM)",null,"=",{"$f":"IF(E34=\"\",\"\",(F34/E34)/100)","v":0.48399999999999999}]
[]
[null,null,"S (C)"]

{"sheet":"Photo_Point","index":14,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,14,7,21],[0,14,0,21],[4,5,4,6],[6,0,32,12],[4,2,4,4],[0,1,1,2],[2,0,2,1],[3,0,3,1],[3,2,3,4],[4,0,4,1],[0,3,1,10],[2,2,2,5],[0,11,1,12],[2,8,2,9],[2,10,2,11],[4,7,4,12]]}
[null,null,null,"Photo-Point Worksheet",null,null,null,null,null,null,null," August, 2019",null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert Key Area photograph into form by clicking in the center of the box.  From the menu ribbon, select \"Insert\", then select \"Pictures\".  Browse to the location where the photo is stored.  Click on the picture that you want to insert and then select \"Insert\".  Resize the photo by selecting the corner editing circles and dragging the corners to shape the photo to fit the cell."]
["Producer Name:",null,"Johnny Q Rancher",null,null,null,null,"Photo Date:","2019-08-01",null,"Photo Time:",null,"1:30pm"]
["Pasture Name/Number:",null,"Carol's Place - R15",null,null,null,null,"Transect #:",2]
["Photographer:",null,"SJ Planner",null,null,"Location:",null,"SWNW 17-5-19"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE:  You will need to manually delete the photo."]

{"sheet":"Photo_Point_Label_Sheet","index":15,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,11,0,17],[1,11,2,17],[3,11,5,17],[6,11,6,17],[9,11,10,17],[7,0,7,8],[8,0,8,8],[9,0,9,8],[0,1,1,2],[0,3,1,6],[0,7,1,8],[2,0,2,8],[4,0,4,8],[3,0,3,8],[5,0,5,8],[6,0,6,8]]}
[null,null,null,"Photo Documentation Sheet",null,null,null," August, 2019",null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,"This form can be used as a locator when taking photos at key areas.  Fill in the information and prop up on a clipboard so that the pertinent information is on the photo."]
["Pasture Name:"]
["Turtle Tank"]
["Location (Legal or GPS Coordinates or Other Description):"]
["SW4NW4 12-1-15"]
["Observer:"]
["S. J. Planner"]
["Date:"]
["2019-08-01"]