Download of
• Computation Spread Sheets
• Empirical Models
• Data Banks

 
 

This page contains the links to downloadable spread sheets for various calculation routines introduced in this handbook. Note that the layout of some spread sheets differs from the example spreadsheet shown in the handbook to some extent.

Spread sheet file format:
- Microsoft EXCEL version 2004 or 2011. Please note that empirical models and data banks may use tailored macro routines, i.e. Windows users must disable "macro virus protection" when using these spread sheets.

Download file format:
- Downloadable files are ZIP compressed
  i.e. "filename.xls" has been compressed to "filename.zip"

  
 

Computation Spread Sheets

Mortality by size converted catch curve (SCCC)

Somatic production by
mass specific growth rate method (MSGRM)

Somatic production by
size frequency method (SFM)

Gonad production from
gonad mass - body size relations

Consumption by daily ration methods

Diet by points method

Oxygen %Saturation -> Abs. Content (Bense & Krause Model)
 
 

Empirical Models
!!! Excel spreadsheet and R versions available !!!
- R version (c) Henrike Andresen 2018 -

------ Excel: ProductivityANN01 ------

-------- R: BenthicPro_1.0.tar.gz --------

Production-to-biomass (P/B) ratio of macrobenthic invertebrate populations
Published 2012;
see Brey 2012, Limnology and Oceanography Methods 10: 581-589

 

---------- EMPRELAT04 ----------

Production, P/B, mortality, and other parameters
Version 4-04 published May 2004

 

---------- RespirationANN01 ----------

Mass specific respiration rate (MSR) of aquatic invertebrates
Published 2010;
see Brey 2010, Methods in Ecology and Evolution 1: 92-101

 

---------- RespirationANN_Euphausiacea ----------

Mass specific respiration rate (MSR) of Euphausiacea
Published 2014;
see Tremblay et al. 2014, Ecological Modeling 291: 233-241
 
 

Data Banks

 

---------- Conversion04 ----------

Mass-to-mass-to-energy conversion factors
(taxon specific search)
!!!!! Latest update 2012 !!!!!
see Brey et al. 2010, Journal of Sea Research 64: 334-340

 

---------- Conversion03 ----------

Mass-to-mass-to-energy conversion factors
(taxon specific search)
Published 2009;
see Brey et al. 2010, Journal of Sea Research 64: 334-340
Mass-to-mass-to-energy conversion factors
(taxon specific search)
Version 2-08 (May '08) < not longer available>