SPEARpesticides

2019.11

Fixed a bug in the log-transformation of abundance data (Correct: log10(4 * Abundance + 1) ). The bug was previously introduced in version 2019.10.

Renaming of the calculation file to 'SPEARpesticides' (OLD file name: 'SPEARpesticide')
Updated trait table
Changed log-transformation of abundance data ( log10(4*(Abundance+1)) )
Updated normalization factor which is quantified as the averaged SPEAR-value for uncontaminated reference sites (NEW: 0.27, OLD 0.31)
Fixed bug in the classification rule for the SPEAR trait 'sensitivity' (NEW: trait value >= THRESHOLD, OLD: trait value > THRESHOLD)
Class boundaries of EQ_pesticides are rounded to 2 decimal places
Updated quality classes with the following five levels:

Updated calculation with normalized SPEAR values from 0 to around 1.
For details see: Knillmann S, Orlinskiy P, Kaske O, Foit K, Liess M, 2018. Indication of pesticide effects and recolonization in streams. Science of the Total Environment. 630, pp. 1619–1627.
Updated trait database
Trait 'Migration' removed
Trait 'Refuge' added
Column 'Recovery' removed from calculation
File extension changed to .indicate
Updated url to online docs
Updated quality classes based on the concept of the ecological status (WFD) with the following five levels:

Taxa for which the SPEAR classification is undefined are now excluded from the calculation

Added extra taxa column in monitoring data as lookup fallback
Added button to link all taxa (overwriting/deleting previous links)
Type affinity of columns 'Name 1-3' in table 'Monitoring Data' set to 'Number' in order to allow for sorting by numbers
Trait Database unsorted by default
Updated labels and comments
Changed values and coding for trait migration