Use this spreadsheet for a quick analysis of your macroinvertebrate count.
This excell spreadsheet will automatically calculate water quality based on macroinvertebrate data collected.
The spreadsheet is also set up to make a pie graph so students can immediately see the percentages of sensitive, somewhat sensitive, and tolerant organisms that they have collected.