SBR Wastewater Treatment Plant Design Spreadsheet
Posted on Tuesday, March 26, 2013 at 12:14 PM

 

Where to Find a SBR Wastewater Treatment Plant Design Spreadsheet

To obtain a SBR Wastewater Treatment Plant Design excel spreadsheet, click here to visit our spreadsheet store.  For use in SBR wastewater treatment plant design calculations, you can buy a convenient sequencing batch reactor design calculation excel spreadsheet for a very reasonable price?  This spreadsheet will make calculations for BOD removal, nitrification, denitrification, and biological phosphorus removal for given information about wastewater flow rate and characteristics, in either U.S. or S.I. units.  Read on for information about Excel spreadsheets that can be used for SBR wastewater treatment plant design calculations.

SBR Wastewater Treatment Plant Design Background

SBR Wastewater Treatment Plant Design Background

A typical activated sludge wastewater treatment process operates as a continuous flow process, with incoming wastewater flow coming into a primary clarifier and treated effluent continuously coming off from the secondary clarifier.  A sequencing batch reactor wastewater treatment system, on the other hand, operates as a batch system.  Two or more tanks are required.  While one tank is receiving influent wastewater (the "fill" part of the cycle), another tank is undergoing aeration (the "react" part of the cycle), settling (the "settle" part of the cycle) and decanting of treated effluent (the "decant" part of the cycle).  This is illustrated in the diagram below.

SBR Wastewater Treatment Plant Design Cycle Diagram

SBR Wastewater Treatment Plant Design Applications

SBR Wastewater Treatment Plant Design Applications

A sequencing batch reactor wastewater treatment system has a great deal of flexibility.  It can be used for traditional BOD removal and nitrification using the four cycle components shown above.  In that case there may be aeration for at least part of the fill cycle.  If denitrification is to be accomplished also, then there should be no aeration during the fill cycle.  If the SBR wastewater treatment system is to be designed for biological phosphorus removal as well, then an anaerobic react period is needed after the fill portion of the cycle, and an anoxic react is needed after the aerobic react part of the cycle, as shown in the diagram below.

SBR Wastewater Treatment Plant Design Diagram for phosphorus removal

Example SBR Wastewater Treatment Plant Design Excel Spreadsheet

Example SBR Wastewater Treatment Plant Design Excel Spreadsheet

The SBR Wastewater Treatment Plant Design excel spreadsheet partially shown in the image below can be used to make a variety of design calculations for a Sequencing Batch Reactor wastewater treatment system.  Based on input information about the wastewater flow rate and characteristics, as well as the treatment objectives, the spreadsheet leads the user through calculations for deciding on times for each part of the SBR cycle, tank number and size, and checks on the adequacy of the design.  This Excel spreadsheet, as well as others for wastewater treatment calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

SBR Wastewater Treatment Pland Design Spreadsheet Screenshot

 REFERENCE:  Bengtson, Harlan H., "Sequencing Batch Reactor Design Calculation Spreadsheet,"  an online blog article.

SBR Wastewater Treatment Plant Design Spreadsheet

Where to Find an SBR Wastewater Treatment Plant Design Spreadsheet