implemented logic for first part of advanced water report