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.