Excel spreadsheets for descritive statistics of wastewater treatment performance

8806 views

Page selection:
  • marcos
  • marcos's Avatar
    Topic Author
  • Working with wastewater treatment and fascinated about knowledge dissemination
  • Posts: 21
  • Karma: 3
  • Likes received: 30

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance

Hi,
Good to know that the spreadsheets seem to be useful. That´s the idea.
Cheers,
Marcos
Professor at the Federal University of Minas Gerais, Brazil

Please Log in to join the conversation.

You need to login to reply
  • odirilep
  • Posts: 1
  • Likes received: 0

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance

Thank you for sharing these Excel files. They are really coming in handy...

Phil

Please Log in to join the conversation.

You need to login to reply
  • jankn
  • jankn's Avatar
  • Posts: 35
  • Karma: 8
  • Likes received: 21

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance

Thank you for sharing these Excel files, I will play around a bit with them this weekend.
Jan Knappe

Doctoral Researcher on environmental performance assessment and modeling of on-site wastewater treatment systems
Trinity College Dublin & University of Limerick
Email: jan.knappe(at)tcd.ie, Twitter: @JanKnappe

Please Log in to join the conversation.

You need to login to reply
  • marcos
  • marcos's Avatar
    Topic Author
  • Working with wastewater treatment and fascinated about knowledge dissemination
  • Posts: 21
  • Karma: 3
  • Likes received: 30

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance

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
Professor at the Federal University of Minas Gerais, Brazil

Please Log in to join the conversation.

You need to login to reply
  • prthomas
  • Posts: 3
  • Likes received: 1

Re: Excel spreadsheets for descritive statistics of wastewater treatment performance

Unable to open the spreadsheet

Please Log in to join the conversation.

You need to login to reply
  • marcos
  • marcos's Avatar
    Topic Author
  • Working with wastewater treatment and fascinated about knowledge dissemination
  • Posts: 21
  • Karma: 3
  • Likes received: 30

Excel spreadsheets for descritive statistics of wastewater treatment performance

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.
Professor at the Federal University of Minas Gerais, Brazil

This message has an attachment file.
Please log in or register to see it.

The following user(s) like this post: jonpar, nelsonlibardi, Makgatha, Juergen, jankn

Please Log in to join the conversation.

You need to login to reply
Page selection:
Share this thread:
Recently active users. Who else has been active?
Time to create page: 0.078 seconds
Powered by Kunena Forum