This webpage provides an Excel to compute the IBICAT2b fish index. The Excel is given as a Supplement to García-Berthou et al. (2016) and might be updated in the future. The IBICAT2b index was originally described (in Catalan) in Sostoa et al. (2010), in work funded by the Catalan Water Agency, and is summarized in English in García-Berthou et al. (2016). This index has only been validated for the Ebro and Catalan rivers so far (it might work in other river basins but it should be validated with environmental pressures). Please check the book chapter for further information and a detailed protocol. Please contact or if you encounter any difficulty or problem with the Excel.
Excel file for computation – Template Excel for data input – Manual (English) – Manual en español
(last updated 3 March 2015)
Disclaimer: Hopefully there are no errors but the abovementioned Excel is provided ‘as is’ without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of fitness for a purpose, or the warranty of non-infringement. The use of the Excel is done at your own discretion and risk.
If you use this Excel, please cite the book chapter, e.g. something like “We computed the IBICAT2b fish index, using the Excel provided by García-Berthou et al. (2016) and available at http://www.invasiber.org/IBICAT2b.html.”
Suggested citation:
García-Berthou E., Bae M.-J., Benejam L., Alcaraz C., Casals F., Sostoa A. de, Solà C. & Munné A. 2016. Fish-based indices in Catalan Rivers: intercalibration and comparison of approaches. p. 125-147 in Munné A., Ginebreda A. & Prat N. (eds.) Experiences from Surface Water Quality Monitoring: The EU Water Framework Directive Implementation in the Catalan River Basin District (Part I). Springer International Publishing, Cham, Switzerland. [.PDF]