Gases in water – Excel

Lab 2 deals with the solubility of gases in water. The concentration of a gas in water is related to the partial pressure of this gas in the gas phase (Henry’s law).
The concentration of oxgen in water is calculated with PHREEQC for different conditions (temperature, salt content). Thereafter the concentrations of gases in water are calculated assuming equilibrium with ambient air (gas mixture with O2, N2, CO2, Ar). Then the solubilty of CO2 is related to the pH of the water and to the gas pressure in soda bottles.
Mass balance between water and a gase phase is demonstratated by calculating the volume of gas bubbles formed by pressure reduction, by temperature increase and by biodegradation.
Finally the kinetics in PHREEQC are demonstrated by the reduction in O2 and NO3 content due to biodegradation.

Content	Slides	Video
Intro – program 2a. Gases in water 2a. Solubility of gases in water – oxygen 2a. Solubility of gases in water – Mixed gases 2a. Solubility of gases in water – CO2 and pH 2b. Gases in water and gas 2b. Gas bubbles in water – Negative-pressure 2b. Gas bubbles in water – Higher temperature 2b. Gas bubbles in water – Biodegradation 2c. Biodegradation – Monod kinetics	1 – 3 4 – 5 6 – 9 10 – 16 17 – 23 24 – 26 27 – 31 32 – 36 37 – 42 43 – 52	1:10:46 – 1:11:42 1:11:42 – 1:12:48 1:12:48 – 1:19:42 1:19:42 – 1:24:10 1:24:10 – 1:29:52 1:29:52 – 1:31:51 1:31:51 – 1:38:04 1:38:04 – 1:41:54 1:41:54 – 1:48:14 1:48:14 – 1:54:20