# SBR Denitrification Calculations Spreadsheet

## 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.

At 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.

For 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.

## 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.

# Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

## Where to Find a Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

To obtain a Membrane Bioreactor Wastewater Treatment Calculations spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for making membrane bioreactor process design calculations. You can buy a convenient membrane bioreactor wastewater treatment calculations spreadsheet  for a very reasonable price.  This spreadsheet .  It is available in either U.S. units or S.I. units.  Read on for information about a membrane bioreactor wastewater treatment calculations spreadsheet.

## Background for Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

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.

Figure 1. 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.

## Example Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

An example membrane bioreactor wastewater treatment calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required volume and dimensions for the MBR aeration tank, membrane module, and preanoxic tank, based on user input membrane module information and wastewater design flow and characteristics.  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.

Figure 2. Screenshot of Membrane Bioreactor Wastewater Treatment 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. Zaerpour, Masoud, “Design, Cost & Benefit Analysis of a Membrane Bioreactor,” M.S. Thesis, Department of Environmental and Geomatic Engineering, Politecnico di Milan, Academic Year, 2013-2014.

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

4. Bengtson, Harlan H., “Spreadsheets for MBR Wastewater Treatment Process Design Calculations,” an Amazon Kindle ebook.

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

# MBBR Nitrification Denitrification Spreadsheet

## Where to Find an MBBR Nitrification  Denitrification Spreadsheet

To obtain an MBBR Nitrification Denitrification spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for MBBR nitrification denitrification process design calculations. You can buy a convenient MBBR Nitrification Denitrification spreadsheet  for a very reasonable price.  This spreadsheet makes MBBR process design calculations for BOD removal, nitrification, and denitrification. including both pre-anoxic and post-anoxic denitrification processes.  It is available in either U.S. units or S.I. units.  Read on for information about using an MBBR process design calculations spreadsheet for nitrification and denitrification.

## Background for MBBR Nitrification Denitrification Spreadsheet

The moving bed biological reactor (MBBR) appeared relatively recently on the wastewater treatment scene.  It was developed in the 1990’s, and is now used in many countries around the world.

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 Pre-Anoxic Nitrification Denitrification Flow Diagram

## Example MBBR Wastewater Treatment Design Spreadsheet

An example MBBR nitrification denitrification spreadsheet is partially shown in the two images below.  This Excel spreadsheet can be used to calculate the required MBBR tank volume and dimensions, based on user input media information and wastewater design flow and characteristics.  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.

Screenshot1 – Pre-anoxic Nitrification Denitrification

Screenshot2 – Pre-anoxic MBBR Nitrification Denitrification Spreadsheet

## 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 Denitrification Design Spreadsheet,” an online blog article

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

4. Bengtson, Harlan H., “Spreadsheets for MBBR Denitrification Design Calculations,” an Amazon Kindle ebook.

5. Bengtson, Harlan H., “Spreadsheets for MBBR Process Design Calculations,”  available as an Amazon Kindle ebook or as a paperback.

# Nitrification Denitrification Activated Sludge Process Spreadsheet

## Where to Find a Nitrification Denitrification Activated Sludge Process Excel Spreadsheet

To obtain a nitrification denitrification activated sludge process Excel spreadsheetclick here to visit our spreadsheet store.  Look in the wastewater treatment category on the Download page.  This Excel spreadsheet is intended for completely mixed activated sludge nitrification/denitrification calculations.  You can buy a convenient nitrification denitrification activated sludge process Excel spreadsheet  for a very reasonable price.  This spreadsheet calculates the completely mixed aeration tank volume for BOD removal and nitrification as well as the volume for a pre-anoxic tank to achieve denitrification..  It is available in either U.S. or S.I. units.  Read on for information about using a nitrification denitrification activated sludge process Excel spreadsheet.

## Background for Nitrification Denitrification Activated Sludge Process Excel Spreadsheet

The activated sludge wastewater treatment process can be designed for removal of BOD (organic matter that exerts an oxygen demand in the water), or for BOD removal and nitrification, or for BOD removal, nitrification and denitrification.  Nitrification is oxidation of ammonia nitrogen in the wastewater to nitrate and denitrification is removal of nitrate from the wastewater.

A flow diagram for a nitrification denitrification activated sludge process is shown below.  It includes a completely mixed activated sludge aeration tank for BOD removal and nitrification as well as an anoxic basin for denitrification.

Example Nitrification Denitrification Activated Sludge Process Excel Spreadsheet

An example nitrification denitrification activated sludge process Excel spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to make design calculations for a nitrification denitrification activated sludge process.  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.

# References

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

2. Bengtson, Harlan, Nitrification Denitrification Wastewater Treatment Process Spreadsheets,  an informational online blog article.

# MBBR Wastewater Treatment Design Spreadsheet

## Where to Find an MBBR Wastewater Treatment Design Spreadsheet

To obtain an MBBR wastewater treatment design spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for MBBR process design calculations. You can buy a convenient MBBR wastewater treatment design spreadsheet  for a very reasonable price.  This spreadsheet makes MBBR process design calculations for several configurations for BOD removal and for nitrification.  It is available in either U.S. or S.I. units.  Read on for information about using an MBBR Wastewater Treatment Design spreadsheet.

## Background for MBBR Wastewater Treatment Design Spreadsheet

The moving bed biological reactor (MBBR) is a relatively recently developed wastewater treatment process.  It was developed in the 1990’s, but is now in use in many countries around the world.

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.  It is used as a single stage process or as a two-stage or three-stage process.

## Example MBBR Wastewater Treatment Design Spreadsheet

An example MBBR wastewater treatment design spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required MBBR tank volume and dimensions, based in user input media information and wastewater design flow and characteristics.  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.

## References:

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

2. Bengtson, Harlan, “MBBR Process Design Calculations Spreadsheet,” an online blog article

3. Bengtson, Harlan H,, “Spreadsheets for MBBR Process Design Calculations“, Available as an Amazon Kindle e-book and as a paperback.

4. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,” available as an Amazon Kindle e-book or as a paperback.

# Sequencing Batch Reactor Design Calculation Spreadsheet

## Where to Find a Sequencing Batch Reactor Design Calculation Spreadsheet

To obtain a Sequencing Batch Reactor Design Calculation excel spreadsheet, click here to visit our spreadsheet store.  For use in wastewater treatment 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 design calculations.

## Sequencing Batch Reactor Design Calculation 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.

## Sequencing Batch Reactor Design Calculation 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.

## Example Sequencing Batch Reactor Design Calculation Excel Spreadsheet

The Sequencing Batch Reactor Design Calculation excel spreadsheet partially shown in the image below can be used to make a variety of design calculations for an SBR 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.

## Reference:

Bengtson, Harlan H.,  “SBR Wastewater Treatment Plant Design Spreadsheet,” an online blog article.