Stream Metrics

 Note: Most of the tools on this page use Excel (xls or xlsx files)

It is very important to correctly assess the data that you collect in order to interpret the results.  To be consistent you must maintain a certain level of precision and accuracy in the field and use standard methods when performing all protocols.  This will result in comparable data and enable you to monitor trends over time.  To aid in the interpretation of stream survey data, WV Save Our Streams provides a variety of spreadsheets that simplify the metric calculations and evaluations.  Most of the resources below are Excel spreadsheets but there are also some on-line tools and appelets,
Benthic metrics 
  • Level-1: Calculates 3 metrics and combines the results into an overall score; requires an estimate of abundance and diversity (number of different kinds (families)).  
  • Level-2: Calculates 6 metrics and combines the results into an overall score; requires a count and the ability to perform streamside ID on a wide variety of macroinvertebrates; must be able to ID to family-level or at a minimum into similar groups.
  • Level-3: Calculates 6 metrics and combines the results into an overall score; also provides the results of additional metrics; level-3 requires a complete count or sub-sample and family-level ID.
  • Benthic lab sheet: A laboratoy sheet for recording macroinvertebrates from a family level ID.  
  • A benthic spreadsheet that calculates multiple family-level metrics often associated with benthic communities (Univerity of Massachusetts). 

  • Stream index calculations: Multiple levels are included within this spreadsheet; and, it includes a basic pebble count.

Additional information 
  • Diversity IndexAn online applet that calculates a vareity of metrics associated with biodiversity and information theory. 
  • Discharge calculations: Calculates stream velocities and overall discharges for 3 different procedures (Flow meter, VHR and Float method).
  • Pebble counts: Calculates the percentage in each major category, provides a cumulative frequency graph, and calculates an overall index and the percentage of fine materials. 
  • Pollutant loads: Learn more abouot pollutant loads and download a spreadsheet that calculates loads based on concentration and discharge.
  • STEPL is a program which generates watershed information and is often used to calculate loads.
  • Reference reach survey: Helps to assess profile, dimension and material measurements, it is useful for geomorphologic surveys; Spreadsheet tools for river evaluation, assessment and monitoring.  
  • Streambank erosion: Calculates erosion rates based on measurement protocols from the NPS Program.
  • Click-Here for simple comparison purposes and to analyze trends it is often useful to determine percent increase, decrease or difference. Click-Here to download the spreadsheet.  
  • Click-Here for latitude and longitude conversions or HERE to download a conversion spreadsheet (Note: converts from DMS to DD).    

Note: A log-in window may appear; simply click cancel (you may need to click several times) to continue, or right-click the link to save the file to your computer's hard drive.  Contact the Coordinator if you have difficulties downloading any of the files available.  Simply request the file you are attempting to download.