VAD Tools

It is useful to summarize survey data for the purposes of reporting, data sharing and data entry into your own or other on-line databases.  To help, WV Save Our Streams has developed spreadsheets and Word documents for survey summaries. 

    1. Summaries: 
Level-1, Level-1ALevel-2 and Level-3
    2. Summaries (xlsx): Level-1, Level-2 and Level-3 
Index calculations (xls): calculates your stream scores (IBIs)
Pebble counts (xls): summarizes pebble count data
Latitude and Longitude conversions

: 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.


  • Macroinvertebrates: There is a section that requires all macroinvertebrates from the survey to be listed.  The VAD has drop-downs of the taxonomic names listed by their tolerance
  • Habitat: To satify the requirements of the database enter the rating of Optimal, Suboptimal, Marginal, or Poor for Level-1 if you used data sheets prior to 2010. The most recent data sheets use number scales typical of most biosurveys; the numbers should be entered instead of the rating. 
  • Mapping: A topo-map is provided if the latitude and longitude are entered in degrees-minutes-seconds format.  If your GPS records in decimal degrees or another format use this converter to find the correct values. 
  • VAD downloads: Summary survey data from the major watersheds.  

Microsoft added new file formats to Microsoft Word, Excel, and PowerPoint 2007 to reduce file size, improve security and reliability, and enhance integration with external sources. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft developed a Compatibility Pack for the Word, Office Excel, and Office PowerPoint file formats. This Compatibility Pack works with files created by Office 2010 and the 2007 Office system.

Privacy, Security and Accessibility | | | © 2017 State of West Virginia