top of page

This macro was built into our MS access database after the frustration of manually entering thousands of species occurrences. What it does:​

​

  • Opens (user-queried) table in current Access database, and Excel datasheet from the parent directory (containing taxa metadata)

  • Scans table fields for distinct site names 

  • Iterates a taxa/abundance search over each site in the table

  • If a taxa’s terminal ID is not found in Excel, it moves up an ID level until it is met

  • Populates the IBI calculator file with taxa/abundances for each distinct site

  • Records the IBI calculation for each site and populates the IBI field in the database

 

Why?

Effectively removes the human component from IBI score calculations with as few errors as possible. Each time a complete site is added to the database, the script will calculate a comprehensive IBI score (according to Brett Marshall's EPA standard).

bottom of page