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

​

This 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