Hi all…the International Water Association (IWA) has just made a 639 page guide for the “Assessment of Treatment Plant Performance and Water Quality Data” freely available for download. They state that “this book presents the basic principles for evaluating water quality and treatment plant performance in a clear, innovative and didactic way, using a combined approach that involves the interpretation of monitoring data associated with (i) the basic processes that take place in water bodies and in water and wastewater treatment plants and (ii) data management and statistical calculations to allow a deep interpretation of the data.” It is dated 2020 and comes with 75 Excel pre-formatted spreadsheets which are available to download here. The spreadsheets look pretty impressive but I have not assessed any of them and therefore cannot provide an endorsement or comment.
Assessment of Treatment Plant Performance and Water Quality Data: A Guide for Students, Researchers and Practitioners
Marcos von Sperling; Matthew E. Verbyla; Sílvia M. A. C. Oliveira
IWA Publishing, 2020
“This book is problem-oriented and works from practice to theory, covering most of the information you will need, such as (a) obtaining flow data and working with the concept of loading, (b) organizing sampling programmes and measurements, (c) connecting laboratory analysis to data management, (e) using numerical and graphical methods for describing monitoring data (descriptive statistics), (f) understanding and reporting removal efficiencies, (g) recognizing symmetry and asymmetry in monitoring data (normal and log-normal distributions), (h) evaluating compliance with targets and regulatory standards for effluents and water bodies, (i) making comparisons with the monitoring data (tests of hypothesis), (j) understanding the relationship between monitoring variables (correlation and regression analysis), (k) making water and mass balances, (l) understanding the different loading rates applied to treatment units, (m) learning the principles of reaction kinetics and reactor hydraulics and (n) performing calibration and verification of models.
The major concepts are illustrated by 92 fully worked-out examples, which are supported by 75 freely-downloadable Excel spreadsheets. Each chapter concludes with a checklist for your report. If you are a student, researcher or practitioner planning to use or already using treatment plant and water quality monitoring data, then this book is for you!”