Tag Archives: SBR denitrification calculations spreadsheet

MBBR MBR SBR Spreadsheets

Posted on by
Reply

Where to Find MBBR MBR SBR Spreadsheets

To obtain MBBR MBR SBR spreadsheets, click here to visit our spreadsheet store. You can buy your choice of several different MBBR MBR SBR spreadsheets as a convenient MBBR-MBR-SBR spreadsheet bundle or Excel spreadsheets for wastewater treatment design for MBBR wastewater treatment, MBR wastewater treatment or SBR wastewater treatment for very reasonable prices.  This Excel spreadsheet bundle include process design calculations for MBBR wastewater treatment processes, MBR wastewater treatment processed, SBR wastewater treatment processes.   These Excel spreadsheets are available in either U.S. units or S.I. units.  Read on for more information about MBBR MBR SBR Spreadsheets.

MBBR processes in Wastewater Treatment Spreadsheet Bundles

MBBR wastewater treatment process design spreadsheets are included in all of the MBBR-MBR-SBR spreadsheet bundle mentioned above.  The MBBR wastewater treatment process is quite flexible.  It is used for domestic and industrial wastewater treatment and can be designed for BOD removal alone or in combination with nitrification or with nitrification and denitrification.  It is used as a single stage process or as a two-stage or three-stage process.

The diagram below shows the general configuration of a Pre-anoxic nitrification denitrification MBBR wastewater treatment process.  Denitrification can also be carried out in a Post-Anoxic nitrification denitrification process.

MBBR MBR SBR Spreadsheets MBBR Flow Diagram

Figure 1. MBBR Wastewater Treatment Flow Diagram for Pre-Anoxic Deniitrification

MBR Processes in Wastewater Treatment Spreadsheet Bundles

A membrane bioreactor wastewater treatment system (MBR) can provide a compact alternative to the conventional activated sludge process. The MBR process uses filtration through a membrane instead of secondary clarification, so it produces a very high quality effluent.  Primary clarification is not typically used in a membrane bioreactor wastewater treatment system.  Fine screening is needed as a minimum pretreatment, and depending upon wastewater characteristics, coarse screening and grit removal may be needed also. The diagram below shows a general flow diagram for a MBR wastewater treatment system for BOD removal and nitrification.

MBBR MBR SBR Spreadsheet - MBR Process Flow DiagramFigure 2. MBR Wastewater Treatment Flow Diagram for BOD Removal and Nitrification

Currently the membrane module is typically immersed in the aeration tank as shown in the flow diagram.  Denitrification can also be carried out by adding a preanoxic tank before the aeration tank.

 References:

1. McQuarrie, J.P. and Boltz, J.P., Moving Bed Bio-film Reactor Technology: Process Design and Performance, Water Environment Research, Vol 83, No 6, June 2011.

2. Bengtson, Harlan, “MBBR-MBR-SBR Spreadsheet Bundle,” an online blog article

3. Bengtson, Harlan, “MBR Wastewater Treatment Process Design,” an online blog article

3. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,” available as an Amazon Kindle ebook or as a paperback.

SBR Denitrification Calculations Spreadsheet

Posted on by
Reply

Where to Find an SBR Denitrification Calculations Spreadsheet

To obtain an SBR Denitrification Calculations Spreadsheet, click here to visit our spreadsheet store.  This Excel spreadsheet is intended for making design calculations for either pre-anoxic or post-anoxic denitrification in a sequencing batch reactor. You can buy a convenient SBR denitrification 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 sequencing batch reactor denitrification process design calculations.

Background for an SBR Denitrification Calculations Spreadsheet

The sequencing batch reactor is a batch type, fill and draw alternative to the continuous flow activated sludge process for biological wastewater treatment, including BOD removal, nitrification and denitrification.  The typical components of a sequencing batch reactor operating cycle for BOD removal and nitrification are shown in the diagram below.

Typical SBR Cycle for SBR denitrification calculations spreadsheetAt least two tanks are typically used.  In that case, the length of the fill period would be equal to the sum of the times for the react, settle and decant periods.  Thus one tank would be filling while the other tank was going through the react, settle and decant periods and then the roles would be reversed.

In order to achieve denitrification, an anoxic period must be added.  A typical sequencing batch reactor cycle for a post-anoxic denitrification process is shown in the figure below.  A mixed anoxic react period is included after the aerobic react period.

post-anoxic SBR operating cycle for SBR denitrification calculations spreadsheetFor a pre-anoxic denitrification SBR process, some or all of the fill period would be anoxic and there would be no anoxic react period after the aerobic react period.

 Example SBR Denitrification Calculations Spreadsheet

An example SBR denitrification calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to set the times for the different parts of the SBR operating cycle, calculate the required tank size and check on the adequacy for nitrification and for denitrification.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

screenshot for SBR denitrification calculations spreadsheet

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.,  “Sequencing Batch Reactor Denitrification Calculations,” an online blog article.