This bundle includes all of the spreadsheet workbooks in the Secondary Wastewater Treatment category: Activated Sludge Aeration Tank  Calculations, Primary and Secondary Clarifier Design, Trickling Filter NRC Formula calculations, MBBR BOD Removal and Nitrification, MBR Process Design Calculatpons, SBR BOD Removal and Nitrification Design, Wastewater Treatment Lagoon Design, Oxidation Ditch Design Calculations and CMAS BOD Removal and Nitrification.  All are in U.S. units.  Descriptions of all these spreadsheets are given below.

This bundle includes all of the spreadsheet workbooks in the Secondary Wastewater Treatment category: Activated Sludge Aeration Tank  Calculations, Primary and Secondary Clarifier Design, Trickling Filter NRC Formula calculations, MBBR BOD Removal and Nitrification, MBR Process Design Calculations, SBR BOD Removal and Nitrification Design, Wastewater Treatment Lagoon Design,Oxidation Ditch Design Calculations and CMAS BOD Removal and Nitrification.  All are in S.I. units.  Descriptions of all these spreadsheets are given below.

FREE DOWNLOAD!  Try this Excel spreadsheet for calculating required activated sludge aeration tank volume based on user input wastewater flowrate, BOD concentration, and design value for hydraulic residence time.  There is a worksheet for U.S. units and one for S.I. units.

 These Excel spreadsheets will calculate the activated sludge aeration tank volume requirement, based on a specified volumetric loading, hydraulic retention time, or F:M ratio, and will calculate the other two design parameters for the calculated tank volume. Activated sludge operational calculations can be made also to find the required activated sludge wasting rate, activated sludge recycle rate, and an estimate of the resulting F:M ratio. There is also a worksheet to calculate the oxygen requirement and the blower ACFM, SCFM, & outlet pressure needed.  Calculations use U.S. units.

 These Excel spreadsheets will calculate the activated sludge aeration tank volume requirement, based on a specified volumetric loading, hydraulic retention time, or F:M ratio, and will calculate the other two design parameters for the calculated tank volume. Activated sludge operational calculations can be made also to find the required activated sludge wasting rate, activated sludge recycle rate, and an estimate of the resulting F:M ratio. There is also a worksheet to calculate oxygen requirement and blower air flow and outlet pressure requirements.  Calculations use S.I. units.

 This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate.  Based on a specified number of clarifiers the diameter of circular clarifiers is calculated.  Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated.  Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed.  Similar calculations can be done for primary clarifiesrs.  This spreadsheet uses U.S. units.

 This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate.  Based on a specified number of clarifiers the diameter of circular clarifiers is calculated.  Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated.  Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. Similar calculations can be made for primary clarifiers.  This spreadsheet uses S.I. units.

 This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate.  Based on a specified number of clarifiers the diameter of circular clarifiers is calculated.  Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated.  Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed.    This spreadsheet uses S.I. units.

 This Excel spreadsheet calculates the required primary clarifier surface area based on specified values of average and peak surface overflow rate.  Based on a specified number of clarifiers the diameter of circular clarifiers is calculated.  Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated.  Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed.    This spreadsheet uses U.S. units.

 This Excel spreadsheet calculates the required primary clarifier surface area based on specified values of average and peak surface overflow rate.  Based on a specified number of clarifiers the diameter of circular clarifiers is calculated.  Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated.  Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed.    This spreadsheet uses S.I. 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 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 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 spreadsheet makes calculations for sizing wastewater treatment lagoons, including anaerobic, facultative and maturation ponds.  A worksheet is included to estimate evaporation rate.  Calculations are done in U.S. units.

This spreadsheet makes calculations for sizing wastewater treatment lagoons, including anaerobic, facultative and maturation ponds.  A worksheet is included to estimate evaporation rate.  Calculations are done in S.I. units.

This Excel Spreadsheet makes a variety of trickling filter wastewater treatment calculations with the NRC formula.  Included are calculation of required trickling filter diameter for a single stage system and calculation of the required trickling filter diameter for a two-stage system with both filters of the same diameter.  There are also worksheets to calculate the estimated treatment efficiency for a single stage or for a two stage trickling filter system.  These spreadsheets use U.S. units.

This Excel Spreadsheet makes a variety of trickling filter wastewater treatment calculations with the NRC formula.  Included are calculation of required trickling filter diameter for a single stage system and calculation of the required trickling filter diameter for a two-stage system with both filters of the same diameter.  There are also worksheets to calculate the estimated treatment efficiency for a single stage and for a two stage trickling filter system.  These spreadsheets use 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 workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification.  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 Example 8-3 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.  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 Example 8-3 from Metcalf & Eddy/Aecom, Wastewater Engineering Treatment and Resource Recovery,5th Ed, 2014    This spreadsheet uses  S.I. units.

This worksheet makes calculations of oxygen/air/blower requirements for a biological wastewater treatment system based on user input information about wastewater and aeration system parameters, using U.S. Units

This worksheet makes oxygen/air/blower requirement calculations based on user input values for wastewater and aeration system parameters using S.I. units.

This Excel spreadsheet carries out design calculations for an oxidation ditch biological wastewater treatment system.  The design calculations include calculation of the required oxidation ditch volume based on a user entered value for HRT, F:M, or volumetric loading, along with the design WW flowrate, influent BOD, oxidation ditch MLSS, and percent volatile.  The spreadsheet also calculates the cross-sectional area and total length of the oxidation ditch for user entered liquid depth in channel, channel bottom width, and side slope, and it calculates the side length and end diameter for user entered ratio, L/D.  Calculation are in U.S. units.

This Excel spreadsheet carries out design calculations for an oxidation ditch biological wastewater treatment system.  The design calculations include calculation of the required oxidation ditch volume based on a user entered value for HRT, F:M, or volumetric loading, along with the design WW flowrate, influent BOD, oxidation ditch MLSS, and percent volatile.  The spreadsheet also calculates the cross-sectional area and total length of the oxidation ditch for user entered liquid depth in channel, channel bottom width, and side slope, and it calculates the side length and end diameter for user entered ratio, L/D.  Calculation are in S.I. units.