This Excel spreadsheet bundle includes the U.S. versions of the MBBR BOD Removal and Nitrification, MBBR Nitrification-Denitrification, MBR Process Design Calculations, and SBR BOD Removal-Nitrification-Denitrification spreadsheet workbooks.  Descriptions of all of these spreadsheets are given below.

This Excel spreadsheet bundle includes the S.I. versions of the MBBR BOD Removal and Nitrification, MBBR Nitrification-Denitrification, MBR Process Design Calculations, and SBR BOD Removal-Nitrification-Denitrification spreadsheet workbooks.  Descriptions of all of these spreadsheets are given below.

This spreadsheet package includes the U.S. versions of both the MBBR BOD and Nitrification Calculatons and MBBR Nitrification-Denitrification Processes spreadsheets.  Descriptions are given  below.

This spreadsheet package includes the S.I. versions of both the MBBR BOD and Nitrification Calculatons and MBBR Nitrification-Denitrification Processes spreadsheets.  Descriptions are given below.

This MBBR calculations spreadsheet has four worksheets.  One is for a single-stage BOD removal process, one is for two-stage BOD removal, one is for two-stage BOD removal/nitrification, and one is for single stage tertiary nitrification calculations.  Each worksheet guides the calculation of tank volume and dimensions based on wastewater flow and characteristics, along with characteristics of the media (carrier) to be used.  The worksheets also calculate detention time at design average flow and at peak hourly flow as well as estimated air requirements and alkalinity requirements for the nitrification processes..  The worksheet is set up for U.S. units.

This MBBR calculations spreadsheet has four worksheets.  One is for a single-stage BOD removal process, one is for two-stage BOD removal, one is for two-stage BOD removal/nitrification, and one is for single stage tertiary nitrification calculations.  Each worksheet guides the calculation of tank volume and dimensions based on wastewater flow and characteristics, along with characteristics of the media (carrier) to be used.  The worksheets also calculate detention time at design average flow and at peak hourly flow as well as estimated air requirements and alkalinity requirements for the nitrification processes..  The worksheet is set up for S.I. 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 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 package includes a worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for  BOD removal and nitrification,  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 a worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for  BOD removal and nitrification,  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 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, 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 S.I. units