Excel spreadsheets for descritive statistics of wastewater treatment performance
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Excel spreadsheets for descritive statistics of wastewater treatment performance

Excel spreadsheets for descritive statistics of wastewater treatment performance 04 Mar 2014 20:51 #7627

  • marcos
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 6
  • Likes received: 12
  • Karma: 1
Dear colleagues,

I would like to share with you simple Excel spreadsheets that we developed for doing descriptive statistics of wastewater treatment plant performance. They are very simple to use, and the user has only to fill in cells marked in yellow with information and monitoring data (copy from your own spreadsheet and paste as VALUES). The spreadsheets are entirely open (no macros or anything protected), and you can adapt them to your own conditions.

After inserting the monitoring data, the spreadsheets calculate removal efficiencies, applied loads (HRT, surface hydraulic load, surface mass load, volumetric mass load), descriptive statistics of concentrations, efficiencies and loads, time series graphs, box-plot graphs, percentile graphs, monthly averages, yearly averages, compliance with discharge standards.

There are basically two types of spreadsheets:

- One unit – Various parameters
Use this spreadsheet if you want to investigate one treatment unit (or system) and monitor several quality parameters only at its INLET (influent) and OUTLET (effluent)

- One parameter - Various units
Use this spreadsheet if you want to investigate one quality parameter (e.g. BOD) in several treatment units at the INLET (influent) and OUTLET (effluent) of each unit. The units can be in parallel or in series.

The instructions are in the spreadsheets themselves. Go to the first worksheet (Data), where the instructions are, and where most of the data needs to be inserted in the yellow cells.

For each spreadsheet there are two versions: one Blank (without any data, and to be used by you after inserting your own data) and one Example (filled in with data - please note that I simply invented data to be filled in in order to develop and test the spreadsheets; they are not real data and may not have physical meaning).

Text that is in yellow may be translated to any language, and the tables and graphs will automatically update.

Be welcome to adapt the spreadsheets to your own needs.

Best regards,

Marcos von Sperling

This attachment is hidden for guests. Please log in or register to see it.
The following user(s) like this post: jonpar, nelsonlibardi, Makgatha, Juergen, jankn

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance 05 Mar 2014 15:15 #7650

  • prthomas
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 3
  • Likes received: 1
  • Karma: 0
Unable to open the spreadsheet
Last Edit: 05 Mar 2014 15:16 by prthomas.

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance 05 Mar 2014 15:36 #7651

  • marcos
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 6
  • Likes received: 12
  • Karma: 1
Hi,
There are four files, which have been zipped into one. I have just tried now, and was able to download and unzip the files. Have you logged in in SuSanA Forum system (with password etc) before trying to access the file? Otherwise it will not appear available for downloading.
Regards,
Marcos

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance 07 Mar 2014 18:39 #7683

  • jankn
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 8
  • Likes received: 3
  • Karma: 2
Thank you for sharing these Excel files, I will play around a bit with them this weekend.
Jan Knappe
Doctoral Researcher at Mathematics Applications Consortium for Science and Industry (MACSI), University of Limerick, and Department of Civil, Structural and Environmental Engineering at Trinity College Dublin
Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance 10 Mar 2014 09:42 #7714

  • odirilep
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 1
  • Likes received: 0
  • Karma: 0
Thank you for sharing these Excel files. They are really coming in handy...

Phil

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance 11 Mar 2014 20:19 #7745

  • marcos
  • This button allows you to contact another forum user directly by sending a private message.
    Message
  • Posts: 6
  • Likes received: 12
  • Karma: 1
Hi,
Good to know that the spreadsheets seem to be useful. That´s the idea.
Cheers,
Marcos
  • Page:
  • 1
Time to create page: 0.32 seconds