• Home
  • About Us
  • Downloads
  • Contact Us
  • FAQ
  • Blog
  • Testimonials
  • Updates
  • Custom Spreadsheets

Secondary Wastewater Treatment Spreadsheets

This category includes spreadsheets for aeration tank design and operation calculations, completely mixed activated sludge design for BOD removal & nitrification, SBR design for BOD removal & nitrification, MBBR design for BOD removal & nitrification, Trickling Filter NRC formula calculations, WW treatment Lagoon design, and primary and secondary clarifier design.  Scroll down for descriptions of these spreadsheets in U.S. or S.I. units.

Shopping Cart
Biological-Secondary Wastewater Treatment Bundle_U.S. units$ 80.00 USDAdd to Cart
Microsoft Excel

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.

Biological-Secondary Wastewater Treatment Bundle_S.I. units$ 80.00 USDAdd to Cart
Microsoft Excel

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.

Aeration Tank Sizing - HRT - US or SI units$ 0.00 USDAdd to Cart
Microsoft Excel

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.

Activated Sludge Aeration Tank Calcns_US units$ 20.95 USDAdd to Cart
Microsoft Excel

 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.

Activated Sludge Aeration Tank Calculations_SI units$ 20.95 USDAdd to Cart
Microsoft Excel

 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.

Primary and Secondary Clarifier Design_U.S.$ 11.95 USDAdd to Cart
Microsoft Excel

 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.

Primary and Secondary Clarifier Design_S.I.$ 11.95 USDAdd to Cart
Microsoft Excel

 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.

Secondary Clarifier Design-U.S.$ 8.95 USDAdd to Cart
Microsoft Excel

 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 U.S. units.

Secondary Clarifier Design-S.I. Units$ 8.95 USDAdd to Cart
Microsoft Excel

 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.

Primary Clarifier Design-U.S.$ 8.95 USDAdd to Cart

 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.

Primary Clarifier Design-S.I. Units$ 8.95 USDAdd to Cart
Microsoft Excel

 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.

MBBR BOD and Nitrification Calcns-U.S.$ 35.95 USDAdd to Cart
Microsoft Excel

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.

MBBR BOD and Nitrification Calcns-S.I.$ 35.95 USDAdd to Cart
Microsoft Excel

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.

MBR Process Design Calculations-U.S. Units$ 35.95 USDAdd to Cart
Microsoft Excel

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.

MBR Process Design Calculations-S.I. Units$ 35.95 USDAdd to Cart
Microsoft Excel

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.

Wastewater Treatment Lagoon Design_U.S.$ 35.95 USDAdd to Cart
Microsoft Excel

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.

Wastewater Treatment Lagoon Design_S.I.$ 35.95 USDAdd to Cart
Microsoft Excel

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.

Trickling Filter NRC Formula Calcns_U.S.$ 20.95 USDAdd to Cart
Microsoft Excel

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.

Trickling Filter NRC Formula Calcns_S.I.$ 20.95 USDAdd to Cart
Microsoft Excel

 

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.

 

SBR BOD Removal and Nitrif. Design-U.S. Units$ 25.95 USDAdd to Cart
Microsoft Excel

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.

SBR BOD Removal and Nitrif. Design-S.I. Units$ 25.95 USDAdd to Cart
Microsoft Excel

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.

CMAS BOD Removal and Nitrification-U.S.$ 20.95 USDAdd to Cart
Microsoft Excel

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.

CMAS BOD Removal and Nitrification-S.I.$ 20.95 USDAdd to Cart
Microsoft Excel

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.

Aeration-Blower Calculations_U.S.$ 10.95 USDAdd to Cart
Microsoft Excel

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

Aeration Blower Calculations-S.I.$ 10.95 USDAdd to Cart
Microsoft Excel

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

Oxidation Ditch Design Calculations-U.S.$ 25.00 USDAdd to Cart
Microsoft Excel

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.

Oxidation Ditch Design Calculations-S.I.$ 25.00 USDAdd to Cart
Microsoft Excel

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.

  • Home
  • |
  • About Us
  • |
  • Downloads
  • |
  • Contact Us
  • |
  • FAQ
  • |
  • Blog
  • |
  • Testimonials
  • Updates
  • |
  • Custom Spreadsheets
  • |
  • Admin
Copyright © 2022 Engineering Excel Templates. All Rights Reserved.
Newsletter Subscribe Submitted
Your request to be added to our free Newsletter mailing list was successful. To confirm your subscription, please click the link in the email message that has just been sent to the address you entered.
Newsletter Unsubscribe Submitted
Your request to be unsubscribed from our free Newsletter mailing list was successful. To confirm your intentions to unsubscribe, please click the link in the email message that has just been sent to the address you entered.
Newsletter Unsubscribe Failure
Your request to be unsubscribed from our free Newsletter mailing list was unsuccessful. There is no current subscriber with the email address you entered.
Newsletter Subscribe Failure
Your request to subscribe to our free Newsletter mailing list was unsuccessful. There is already a current subscriber with the email address you entered.