SBR Denitrification Calculations Spreadsheet

Where to Find an SBR Denitrification Calculations Spreadsheet

To obtain an SBR Denitrification Calculations Spreadsheet, click here to visit our spreadsheet store.  This Excel spreadsheet is intended for making design calculations for either pre-anoxic or post-anoxic denitrification in a sequencing batch reactor. You can buy a convenient SBR denitrification calculations spreadsheet for a very reasonable price.  It is available in either U.S. units or S.I. units.  Read on for background information about sequencing batch reactor denitrification process design calculations.

Background for an SBR Denitrification Calculations Spreadsheet

The sequencing batch reactor is a batch type, fill and draw alternative to the continuous flow activated sludge process for biological wastewater treatment, including BOD removal, nitrification and denitrification.  The typical components of a sequencing batch reactor operating cycle for BOD removal and nitrification are shown in the diagram below.

Typical SBR Cycle for SBR denitrification calculations spreadsheetAt least two tanks are typically used.  In that case, the length of the fill period would be equal to the sum of the times for the react, settle and decant periods.  Thus one tank would be filling while the other tank was going through the react, settle and decant periods and then the roles would be reversed.

In order to achieve denitrification, an anoxic period must be added.  A typical sequencing batch reactor cycle for a post-anoxic denitrification process is shown in the figure below.  A mixed anoxic react period is included after the aerobic react period.

post-anoxic SBR operating cycle for SBR denitrification calculations spreadsheetFor a pre-anoxic denitrification SBR process, some or all of the fill period would be anoxic and there would be no anoxic react period after the aerobic react period.

 Example SBR Denitrification Calculations Spreadsheet

An example SBR denitrification calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to set the times for the different parts of the SBR operating cycle, calculate the required tank size and check on the adequacy for nitrification and for denitrification.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

screenshot for SBR denitrification calculations spreadsheet

References:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Reuse, 4th Ed., New York, NY, 2003.

2. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., New York, NY, 2014.

3. Bengtson, Harlan H.,  “Sequencing Batch Reactor Denitrification Calculations,” an online blog article.

UASB Design Calculations Spreadsheet

Where to Find a UASB Design Calculations Spreadsheet

To obtain a UASB Design Calculations Spreadsheet, click here to visit our spreadsheet store.  This Excel spreadsheet is intended for making design calculations for the upflow anaerobic sludge blanket wastewater treatment process. You can buy a convenient spreadsheet for making USAB design calculations  for a very reasonable price.  It is available in either U.S. units or S.I. units.  Read on for background information about upflow anaerobic sludge blanket wastewater treatment design calculations.

Background for a UASB Design Calculations Spreadsheet

The upflow anaerobic sludge blanket wastewater treatment process is typically used for treatment or pretreatment of wastewaters with a high BOD concentration.  The process has a sludge blanket in the reactor zone, through which the influent wastewater flows.  Also, the top part of the reactor includes a means for collecting the methane biogas generated by the anaerobic process.  A schematic flow diagram of the process is shown here:

UASB Design Calculations Spreadsheet Flow Diagram

 Example UASB Design Calculations Spreadsheet

An example UASB design calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required UASB reactor volume and dimensions, sludge production rate, methane production rate, and required alkalinity addition based on user input information on wastewater flow and characteristics, biokinetic parameters, methane stoichiometry parameters, and reactor configuration and design parameters.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

UASB Design Calculations Spreadsheet ScreenshotReferences:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Reuse, 4th Ed., New York, NY, 2003.

2. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., New York, NY, 2014.

3. Bengtson, Harlan, “Upflow Anaerobic Sludge Blanket Wastewater Treatment,” an online blog article

 

Dissolved Air Flotation Design Calculations Spreadsheet

Where to Find a Dissolved Air Flotation Design Calculations Spreadsheet

To obtain a Dissolved Air Flotation Design Calculations Spreadsheet, click here to visit our spreadsheet store.  This Excel spreadsheet is intended for making DAF design calculations. You can buy a convenient spreadsheet for making DAF design calculations  for a very reasonable price.  It is available in either U.S. units or S.I. units.  Read on for background information about dissolved air flotation design calculations.

Background for Dissolved Air Flotation Design Calculations

Dissolved air flotation is an alternative to clarification for removal of fine suspended mater from a water or wastewater stream. It is especially good for fine suspended matter that doesn’t settle out well with regular clarification. The air-solids ratio, A/S, is typically calculated with the following equation:dissolved air flotation design calculations equation for air-solids ratioWhere:  sa is the air solubility, f is an efficiency factor, P is the recycle pressure, R is the recycle flow rate, Sa is the influent suspended solids concentration, and Q is the influent flow rate.  The required DAF area can be calculated based on a design value for DAF hydraulic loading rate or based on a design value for DAF solids loading rate.

 Example Dissolved Air Flotation Design Calculations Spreadsheet

An example dissolved air flotation design calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate A/S, the needed air to solids ratio, and the required DAF area based on user input information on influent design flow and characteristics.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

Dissolved Air Flotation Design Calculation Spreadsheet Screenshot References:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Reuse, 4th Ed., New York, NY, 2003.

2. Bengtson, Harlan, “DAF Design Calculations Spreadsheet,” an online blog article

Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

Where to Find a Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

To obtain a Membrane Bioreactor Wastewater Treatment Calculations spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for making membrane bioreactor process design calculations. You can buy a convenient membrane bioreactor wastewater treatment calculations spreadsheet  for a very reasonable price.  This spreadsheet .  It is available in either U.S. units or S.I. units.  Read on for information about a membrane bioreactor wastewater treatment calculations spreadsheet.

Background for Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

A membrane bioreactor wastewater treatment system (MBR) can provide a compact alternative to the conventional activated sludge process. The MBR process uses filtration through a membrane instead of secondary clarification, so it produces a very high quality effluent.  Primary clarification is not typically used in a membrane bioreactor wastewater treatment system.  Fine screening is needed as a minimum pretreatment, and depending upon wastewater characteristics, coarse screening and grit removal may be needed also. The diagram below shows a general flow diagram for a MBR wastewater treatment system for BOD removal and nitrification.

membrane bioreactor wastewater treatment calculations spreadsheet flow diagramFigure 1. MBR Wastewater Treatment Flow Diagram for BOD Removal and Nitrification

Currently the membrane module is typically immersed in the aeration tank as shown in the flow diagram.  Denitrification can also be carried out by adding a preanoxic tank before the aeration tank.

 Example Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

An example membrane bioreactor wastewater treatment calculations spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required volume and dimensions for the MBR aeration tank, membrane module, and preanoxic tank, based on user input membrane module information and wastewater design flow and characteristics.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet ScreenshotFigure 2. Screenshot of Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

 References:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Reuse, 4th Ed., New York, NY, 2003.

2. Zaerpour, Masoud, “Design, Cost & Benefit Analysis of a Membrane Bioreactor,” M.S. Thesis, Department of Environmental and Geomatic Engineering, Politecnico di Milan, Academic Year, 2013-2014.

3. Bengtson, Harlan, “MBR Wastewater Treatment Process Design Spreadsheet,” an online blog article.

4. Bengtson, Harlan H., “Spreadsheets for MBR Wastewater Treatment Process Design Calculations,” an Amazon Kindle ebook.

5. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,”  available at Amazon as a Kindle ebook or as a paperback.

MBBR Nitrification Denitrification Spreadsheet

Where to Find an MBBR Nitrification  Denitrification Spreadsheet

To obtain an MBBR Nitrification Denitrification spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for MBBR nitrification denitrification process design calculations. You can buy a convenient MBBR Nitrification Denitrification spreadsheet  for a very reasonable price.  This spreadsheet makes MBBR process design calculations for BOD removal, nitrification, and denitrification. including both pre-anoxic and post-anoxic denitrification processes.  It is available in either U.S. units or S.I. units.  Read on for information about using an MBBR process design calculations spreadsheet for nitrification and denitrification.

Background for MBBR Nitrification Denitrification Spreadsheet

The moving bed biological reactor (MBBR) appeared relatively recently on the wastewater treatment scene.  It was developed in the 1990’s, and is now used in many countries around the world.

The MBBR wastewater treatment process is quite flexible.  It is used for domestic and industrial wastewater treatment and can be designed for BOD removal alone or in combination with nitrification or with nitrification and denitrification.  It is used as a single stage process or as a two-stage or three-stage process.

The diagram below shows the general configuration of a Pre-anoxic nitrification denitrification MBBR wastewater treatment process.  Denitrification can also be carried out in a Post-Anoxic nitrification denitrification process.

MBBR Nitrification Denitrification Spreadsheet flow diagram

MBBR Pre-Anoxic Nitrification Denitrification Flow Diagram

 Example MBBR Wastewater Treatment Design Spreadsheet

An example MBBR nitrification denitrification spreadsheet is partially shown in the two images below.  This Excel spreadsheet can be used to calculate the required MBBR tank volume and dimensions, based on user input media information and wastewater design flow and characteristics.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

MBBR Nitrification Denitrification Spreadsheet Screenshot1

Screenshot1 – Pre-anoxic Nitrification Denitrification

MMBR Nitrification Denitrification Spreadsheet Screenshot2

Screenshot2 – Pre-anoxic MBBR Nitrification Denitrification Spreadsheet

 References:

1. McQuarrie, J.P. and Boltz, J.P., Moving Bed Bio-film Reactor Technology: Process Design and Performance, Water Environment Research, Vol 83, No 6, June 2011.

2. Bengtson, Harlan, “MBBR Denitrification Design Spreadsheet,” an online blog article

3. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,” available as an Amazon Kindle ebook or as a paperback.

4. Bengtson, Harlan H., “Spreadsheets for MBBR Denitrification Design Calculations,” an Amazon Kindle ebook.

5. Bengtson, Harlan H., “Spreadsheets for MBBR Process Design Calculations,”  available as an Amazon Kindle ebook or as a paperback.

Dissolved Oxygen Saturation in Water Calculator Speadsheet

Where to Find a Dissolved Oxygen Saturation in Water Calculator Spreadsheet

To obtain a Dissolved Oxygen Saturation in Water Calculator Excel spreadsheet, click here to visit our spreadsheet store.  Look in the Dissolved Oxygen category on the Download page.  This Excel spreadsheet is intended to calculate the dissolved oxygen solubility at a specified water temperature and atmospheric pressure for water temperature of 35 to 80 degrees F and atmospheric pressure of 600 to 760 mm Hg.  You can buy a convenient dissolved oxygen saturation in water calculator Excel spreadsheet  for a very reasonable price.  This spreadsheet calculates dissolved oxygen saturation  based on user specified water temperature and atmospheric pressure.  Calculations may be made in either U.S. or S.I. units.  Read on for information about using a dissolved oxygen saturation in water calculator spreadsheet.

Background for Dissolved Oxygen Saturation in Water Calculator Spreadsheet

There are many tables available with values for the dissolved oxygen solubility in water over a range of water temperatures and atmospheric pressures.  With an Excel spreadsheet, formulas can be derived using Excels graph plotting capability, for saturation dissolved oxygen concentration as a function of water temperature for a range of different values for atmospheric pressure.  The spreadsheet can then conveniently calculate the dissolved oxygen solubility (saturation concentration) at user specified values for water temperature and atmospheric pressure. That is done in the spreadsheet being discussed here.  The

Example Dissolved Oxygen Saturation in Water Calculator Excel Spreadsheet

An example dissolved oxygen saturation in water calculator Excel spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the dissolved oxygen solubility in water at a specified water temperature and atmospheric pressure.  This Excel spreadsheet, as well as others for wastewater treatment calculations, is available for both U.S. or S.I. units for a very reasonable price in our spreadsheet store.

dissolved oxygen saturation in water calculator spreadsheet screenshot

References

  1. United States Geological Survey, DOTABLES (Dissolved oxygen solubility tables),  www.water.usgs.gov/software/DOTABLES/.
  2. Bengtson, Harlan, Dissolved Oxygen Solubility in Water Calculator, an informational blog article.

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.

MBBR Wastewater Treatment Design Spreadsheet

Where to Find an MBBR Wastewater Treatment Design Spreadsheet

To obtain an MBBR wastewater treatment design spreadsheetclick here to visit our spreadsheet store.  This Excel spreadsheet is intended for MBBR process design calculations. You can buy a convenient MBBR wastewater treatment design spreadsheet  for a very reasonable price.  This spreadsheet makes MBBR process design calculations for several configurations for BOD removal and for nitrification.  It is available in either U.S. or S.I. units.  Read on for information about using an MBBR Wastewater Treatment Design spreadsheet.

Background for MBBR Wastewater Treatment Design Spreadsheet

The moving bed biological reactor (MBBR) is a relatively recently developed wastewater treatment process.  It was developed in the 1990’s, but is now in use in many countries around the world.

The MBBR wastewater treatment process is quite flexible.  It is used for domestic and industrial wastewater treatment and can be designed for BOD removal alone or in combination with nitrification.  It is used as a single stage process or as a two-stage or three-stage process.

 Example MBBR Wastewater Treatment Design Spreadsheet

An example MBBR wastewater treatment design spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the required MBBR tank volume and dimensions, based in user input media information and wastewater design flow and characteristics.  This Excel spreadsheet, as well as others for wastewater treatment process design calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

Screenshot-BOD Removal-Single Stage

 References:

1. McQuarrie, J.P. and Boltz, J.P., Moving Bed Biofilm Reactor Technology: Process Design and Performance, Water Environment Research, Vol 83, No 6, June 2011.

2. Bengtson, Harlan, “MBBR Process Design Calculations Spreadsheet,” an online blog article

3. Bengtson, Harlan H,, “Spreadsheets for MBBR Process Design Calculations“, Available as an Amazon Kindle e-book and as a paperback.

4. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,” available as an Amazon Kindle e-book or as a paperback.

Trickling Filter Design Calculations Spreadsheet

Where to Find a Trickling Filter Design Calculations Spreadsheet using the NRC Formula

To obtain a trickling filter design calculations spreadsheet using the NRC formula, click here to visit our spreadsheet store.  For use in making trickling filter design calculations with the NRC equation, you can buy a convenient trickling filter design calculations spreadsheet for a very reasonable price.  This spreadsheet will use the NRC equations to calculate the trickling filter diameter needed for either a single stage or a two stage system and will calculate the estimated treatment efficiency for a specified trickling filter system, in either U.S. or S.I. units.  Read on for information about a trickling filter design calculation spreadsheet that uses the NRC formula.

Trickling Filter Design Calculations Background

The trickling filter process is widely used for biological wastewater treatment all over the world.  It is an attached growth biological wastewater treatment process.  The aerobic microorganisms grow on a solid medium and the wastewater to be treated flows through the bed.  A flow diagram for a typical single stage trickling filter wastewater treatment plant is shown in the diagram below.  The diagram shows the typical flow pattern through the primary clarifier, trickling filter and secondary clarifier.

trickling filter design calculations spreadsheet flow diagram

Example Trickling Filter Design Calculations Spreadsheet

A trickling filter design calculations spreadsheet  is partially shown in the image below.  It can be used to calculate the trickling filter diameter needed for either a single stage or a two stage trickling filter system using the  NRC formula.  The spreadsheet will also calculate an estimated treatment efficiency for a specified single stage or two stage trickling filter system. 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.

Trickling Filter Design Calculations Spreadsheet Screenshot

References for Further Information:

1. Metcalf & Eddy, Inc, (revised by Tchobanoglous, G, Burton, F.L., Stensel, H.D., Wastewater Engineering Treatment and Reuse, 4th Edition, New York, NY, 2003.

2. Vesilind, P.A. and Morgan, S.M., Introduction to Environmental Engineering, 2nd Edition, Belmont, CA, Brooks/Cole, 2004.

3. Bengtson, H. H., “Trickling Filter NRC Equation Spreadsheet“, a blog article at www.EngineeringExcelTemplates.com

A Spreadsheet to Calculate Oxygen Requirement Activated Sludge Process

Where to Find a Spreadsheet to Calculate Oxygen Requirement Activated Sludge Process

To obtain a spreadsheet to calculate oxygen requirement activated sludge processclick here to visit our spreadsheet store.  For use in calculating oxygen requirements and blower specifications, you can buy a convenient spreadsheet to calculate oxygen requirement activated sludge for a very reasonable price.  This spreadsheet will calculate the oxygen requirement and blower specifications for BOD removal or for BOD removal and nitrification for specified wastewater flow and characteristics and diffuser characteristics, in either U.S. or S.I. units.  Read on for information about Excel spreadsheets that can be used to calculate oxygen requirement activated sludge process parameters.

Oxygen Requirement Activated Sludge Background

The theoretical oxygen requirement for BOD removal can be approximated as ranging from  0.90 lb O2/lb BOD removed at an SRT of 5 days to 1.3 lb O2/lb BOD removed at an SRT of 20 days.  This leads to the equation:

O2 requirement in lb/day  =  0.90  +  [(SRT – 5)/(20 – 5)](1.3 – 0.9)(lb/day BOD removed)

A design increase factor (safety factor) is typically multiplied times the calculated oxygen requirement to get the design oxygen transfer rate.  The design oxygen transfer efficiency and the air density at design conditions can then be used to calculate the design air flow rate.  The blower horsepower can then be calculated from the following equation:

Blower hp  =  (Qair)(ΔP)/(229*η)

Where:

  • Qair is the air flow rate in cfm to be delivered by the blower
  • ΔP is the pressure rise across the blower in psi  = outlet pressure – inlet pressure
  • η is the blower efficiency

If oxygen is to be provided for nitrification as well as BOD removal, then additional calculations are needed to estimate the oxygen requirement for nitrification.

Example Spreadsheet to Calculate Oxygen Requirement Activated Sludge Process

A spreadsheet to Calculate oxygen requirement activated sludge process is partially shown in the image below.  It can be used to calculate the oxygen requirement and blower specifications for an activated sludge wastewater treatment system.  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.

A spreadsheet to calculate oxygen requirement activated sludge process

References:

  1.  Bengtson, Harlan H., “Activated Sludge Oxygen Requirement,”  an online blog article.
  2. Bengtson, Harlan H., “Activated Sludge Calculations Spreadsheet: Aeration Tank Calculations,”  an Amazon Kindle e-book.
  3. Bengtson, Harlan H., “Biological Wastewater Treatment Process Design Calculations,”  available as a paperback book or Amazon Kindle e-book