Fish Hatchery Management, appendices

Prepared by Dr. John Colt, National Marine Fisheries Service, Seattle

PURPOSE: The following is a series of tables written in Excel as a complement to the book “Fish Hatchery Management, Second Edition .” These spreadsheets perform many of the routine computations that are needed for hatchery research and operations.

There are two general types of spreadsheets here. The first type generates a tabular output over a wide range of conditions. This is more appropriate where the expected range is known and extreme accuracy is not needed. The second type computes the required parameter for a single condition.

List of Spreadsheets:

  • Table 1: Length-Weight Calculator (to compute length, weight, and condition factor)
  • Table 2: Length-Weight Table (generates a table of length-weights relations for a specific species)
  • Table 3: Dissolved Oxygen Spreadsheet (F) (to compute equilibrium concentration of dissolved oxygen as a function of elevation [pressure], temperature [Fahrenheit], and salinity)
  • Table 4: Dissolved Oxygen Spreadsheet (C) (to compute equilibrium concentration of dissolved oxygen as a function of elevation [pressure], temperature [Celsius], and salinity)
  • Table 5: Gas Supersaturation Calculator (to compute the values of partial pressures for oxygen and nitrogen + argon, total gas pressure, percent saturation oxygen, percent saturation nitrogen + argon, and the nitrogen/oxygen ratio)
  • Table 6: Partial Pressure Calculator (to compute the partial pressure of oxygen in mm Hg)
  • Table 7: Ammonia Table (Freshwater) (generates a table of the mole fraction of un-ionized ammonia as a function of temperature, pH, and ionic composition)
  • Table 8: Ammonia Table (Seawater) (generates a table of the mole fraction of un-ionized ammonia as a function of temperature, pH, and ionic composition)
  • Table 9: Ammonia Calculator (Freshwater) (computes the concentration of un-ionized ammonia as a function of temperature, pH, and salinity)
  • Table 10: Ammonia Calculator (Seawater) (computes the concentration of un-ionized ammonia as a function of temperature, pH, and salinity)
  • Table 11: Oxygen Calculator (to compute the partial pressure of oxygen from concentration units)
Visit us on Google+