Excel spreadsheets for calculating the daily integral of photosynthesis or daily integral of growth of phytoplankton populations

By A. E. Walsby

Conditions for use: freely available but please cite the appropriate publications.

There are 5 spreadsheets available at this Web site. Each opens at an Excel set of spreadsheets, the last of which is a set of instructions. The full instructions are given in the cited publication.

1. Original spreadsheets in first publication

INTEGRAL.XLS and COMPLEX.XLS

WALSBY, A. E. 1997. Numerical integration of phytoplankton through depth and time in a water column. New Phytologist, 136, 189-209.
Original Web page: http://www.bio.bris.ac.uk/research/walsby/integral.htm

Each contains a set of 5 spreadsheets for calculations and Sheet 6 giving instructions. INTEGRAL.XLS is a simpler form of COMPLEX.XLS and is appropriate for most calculations of the daily integral of photosynthesis over 1-10 days. For longer periods the combinations in the next section should be used,

2. Spreadsheets for analysing larger data sets

The combination of PS-INT.XLS and DATA-SET.XLS.

WALSBY, A. E. 2001. Determining the photosynthetic productivity of a stratified phytoplankton population. Aquatic Sciences 63: 18-43.
Original Web page: http://www.bio.bris.ac.uk /research/walsby/ps-int.htm.

The data for each day is assembled in DATA-SET.XLS and is transferred one column (for each day) at a time to PS-INT.XLS for analysis.

3. Spreadsheets for analysing potential population changes from growth rates.

GROW-INT.XLS and GROWRATE.XLS.

BRIGHT, D., & WALSBY, A. E. 2000. The daily integral of growth by Planktothrix rubescens calculated from growth rate in culture and irradiance in Lake Zürich. New Phytologist 146: 301-316.
Original Web pages:
http://www.bio.bris.ac.uk /research/walsby/ps-int.htm
http://www.bio.bris.ac.uk /research/walsby/grow-int.htm.

Publications describing use of the spreadsheets

WALSBY, A. E. 1997. Numerical integration of phytoplankton through depth and time in a water column. New Phytologist, 136, 189-209.
WALSBY, A. E., HAYES, P. K., BOJE, R. & STAL, L. J. 1997. The selective advantage of buoyancy provided by gas vesicles for planktonic cyanobacteria in the Baltic Sea. New Phytologist, 136, 407-417.
WALSBY, A. E. 1997. Modelling the daily integral of photosynthesis by phytoplankton: its dependence on the mean depth of the population. Hydrobiologia 349: 65-74.
MICHELETTI, S., SCHANZ, F. & WALSBY, A. E. 1998. The daily integral of photosynthesis by Planktothrix rubescens during summer stratification and autumnal mixing in Lake Zürich. New Phytologist, 138: 233-249.
STAL, L. J. & WALSBY, A. E. 1998. The daily integral of nitrogen fixation by planktonic cyanobacteria in the Baltic Sea. New Phytologist 139: 665-671.
BRIGHT, D., & WALSBY, A. E. 2000. The daily integral of growth by Planktothrix rubescens calculated from growth rate in culture and irradiance in Lake Zürich. New Phytologist 146: 301-316.
STAL, L. J. & WALSBY, A. E. 2000. Photosynthesis and nitrogen fixation in a cyanobacterial bloom in the Baltic Sea. European Journal of Phycology 35: 97-108.
WALSBY, A. E. 2001. Determining the photosynthetic productivity of a stratified phytoplankton population. Aquatic Sciences 63: 18-43.