The Excel spreadsheet bundle includes all of the spreadsheet workbooks in the Nitrification and Denitrification WW Treatment category, MBBR Nitrification and Denitrification processes, MBR Process Design Calculations, Nitrification-Denitrification CMAS Design, Nitrification-Denitrification and EBPR CMAS Design, CMAS Tertiary Denitrification Design, and SBR Nitrification and Denitrification Design. Calculations are in U.S. units.  Descriptions are given below.

The Excel spreadsheet bundle includes all of the spreadsheet workbooks in the Nitrification and Denitrification WW Treatment  category, MBBR Nitrification and Denitrification processes, MBR Process Design Calculations, Nitrification-Denitrification CMAS Design, Nitrification-Denitrification CMAS-EBPR Design, CMAS Tertiary Denitrification Design, and SBR Nitrification and Denitrification Design. Calculations are in S.I. units.  Descriptions are given below.

This Excel spreadsheet workbook includes a worksheet for a three-stage pre-anoxic denitrification MBBR process and one for a three-stage post-anoxic denitrification MBBR process.  Each worksheet leads the user through calculation of the required carrier volume and tank volumes and dimensions.  Aeration requirements for the BOD removal and nitrification stages is included as well as estimated alkalinity requirements.  There is guidance on the choice between a pre-anoxic or post-anoxic process.  The calculations use U.S. units.

This Excel spreadsheet workbook includes a worksheet for a three-stage pre-anoxic denitrification MBBR process and one for a three-stage post-anoxic denitrification MBBR process.  Each worksheet leads the user through calculation of the required carrier volume and tank volumes and dimensions.  Aeration requirements for the BOD removal and nitrification stages is included as well as estimated alkalinity requirements.  There is guidance on the choice between a pre-anoxic or post-anoxic process.  The calculations use S.I. units.

This Excel spreadsheet workbook has three worksheets to carry out basin sizing and aeration calculations for the membrane module(s), the aeration tank(s) and preanoxic denitrification tank(s). These calculations are based on the membrane module(s) being immersed in the aeration tank(s).  There is also a worksheet for user input of wastewater flow and characteristics, and biological kinetic coefficients.   The membrane module calculations require user input vaues of membrane module parameters that are typically available from the membrane module manufacturer or vendor.  The aeration tank and preanoxic tank calculations use equations typically used for completely mixed activated sludge systems.  Calculations are in U.S. units.

This Excel spreadsheet workbook has three worksheets to carry out basin sizing and aeration calculations for the membrane module(s), the aeration tank(s) and preanoxic denitrification tank(s). These calculations are based on the membrane module(s) being immersed in the aeration tank(s).  There is also a worksheet for user input of wastewater flow and characteristics, and biological kinetic coefficients.   The membrane module calculations require user input vaues of membrane module parameters that are typically available from the membrane module manufacturer or vendor.  The aeration tank and preanoxic tank calculations use equations typically used for completely mixed activated sludge systems.  Calculations are in S.I. units.

This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition.  Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, and 8-10 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014  This spreadsheet uses U.S. units.

This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition.  Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, and 8-10 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014  This spreadsheet uses S.I. units.

This Excel spreadsheet workbook carries out the calculations for sizing a post-anoxic denitrification basin with methanol addition to treat a nitrified effluent from a seconday treatment process with methanol.  Calculations are also included for  anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Example 8-9 from Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Ed.  This spreadsheet uses U.S. units.

This Excel spreadsheet workbook carries out the calculations for sizing a post-anoxic denitrification basin with methanol addition to treat a nitrified effluent from a seconday treatment process with methanol.  Calculations are also included for  anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Example 8-9 from Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Ed.  This spreadsheet uses S.I. units.

This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification and  ii) BOD removal, nitrification and denitrification. The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks.  Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet.  The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics.  It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle.  Calculations are in U.S. units

This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification, ans ii) BOD removal, nitrification and denitrification.  The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks.  Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet.  The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics.  It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle.  Calculations are in S.I. units

This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Also included is a worksheet for making A2O EBPR (Enhanced Biological Phosphate Removal) design calculations.  This is for the A2O process to go with a preanoxic denitrification CMAS process.  Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, 8-10 and 8-13 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014  This spreadsheet uses U.S. units.

This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Also included is a worksheet for making A2O EBPR (Enhanced Biological Phosphate Removal) design calculations.  This is for the A2O process to go with a preanoxic denitrification CMAS process.  Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements.  The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, 8-10 and 8-13 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014  This spreadsheet uses S.I. units.