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.

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.

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.

nitrification denitrification activated sludge process

 

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.

nitrification denitrification activated sludge process spreadsheet

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.

Screenshot-BOD Removal-Single Stage

 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.