Where to Find a Wastewater Screening Calculations Spreadsheet

To obtain a Wastewater Screening Calculations Spreadsheet, click here to visit our spreadsheet store.  This Excel spreadsheet has worksheets for calculating the head loss through a bar screen, head loss through a fine screen, estimated daily volume of screenings collected for a fine screen and for a bar screen, based on user input values for several parameters . You can buy a convenient wastewater screening calculations spreadsheet for a very reasonable price.  It is available in either U.S. units or S.I. units.  Read on for background information about a Wastewater Screening Calculations Spreadsheet.

Background for a Wastewater Screening Calculations Spreadsheet

For information about making calculations for wastewater screening, including bar screens and perforated screens (also known as fine screens).  The equation used to calculate the head loss across a bar screen is:

Where:

The liquid velocity in the approach channel can be calculated using the Manning Equation and the liquid velocity going through the screen can be calculated if information about the number of bars, space between bars, channel width, and flow depth are known.

An equation for calculating the head loss across a fine screen is also available as a function of the flow rate through the screen, the discharge coefficient for the screen (typically 0.6 for a clean screen, and the effective open area of the submerged screen.

Example Wastewater Screening Calculations Spreadsheet

An example wastewater screening calculations spreadsheet is partially shown in the image below.  .  This Excel spreadsheet can be used to calculate the head loss across either a bar screen or a perforated screen and an estimate of the daily screenings volume for either a bar screen or a perforated screen.based on several user input values.  This Excel spreadsheet, as well as others for water and wastewater treatment calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Reuse, 4th Ed., New York, NY, 2003.

2. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., New York, NY, 2014.

3. Bengtson, Harlan H.,  “Fine Screen and Bar Screen Calculations,” an online blog article.