EBPR A2O Design Calculations Spreadsheet

Where to Find an EBPR A2O Design Calculations Spreadsheet

To obtain an EBPR A2O Design Calculations Spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for making design calculations for pre-anoxic denitrification and enhanced biological phosphorus removal in a CMAS (completely mixed activated sludge) system. You can buy a convenient EBPR A2O Design 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 EBPR A2O Design Calculations.

Background for an EBPR A2O Design Calculations Spreadsheet

Enhanced Biological Phosphorus Removal  can be carried out with the A2O (Anaerobic, Anoxic process, as shown in the diagram below.

EBPR A2O Design Calculations Spreadsheet process flow diagramThe primary effluent goes first to an anaerobic tank, then to an anoxic tank and then to the aerated activated sludge tank.  The recycle flows include an internal reycle (IR) flow from the aeration tank effluent to the anoxic tank, and recycle activated sludge from the secondary clarifier underflow to the anaerobic tank.

 Example EBPR A2O Design Calculations Spreadsheet

An example EBPR design calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required anaerobic tank size, and calculate the phosphorus removal rate and sludge production rate.  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.

EBPR A2O Design Calculations Spreadsheet ScreenshotReferences:

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

2. Bengtson, Harlan H.,  “EPBR Design Calculations Spreadsheet” 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.