UASB Design Calculations Spreadsheet

Posted on May 17, 2017 by Harlan Bengtson

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:

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.

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, “Upflow Anaerobic Sludge Blanket Wastewater Treatment,” an online blog article

Dissolved Air Flotation Design Calculations Spreadsheet

Posted on April 24, 2017 by Harlan Bengtson

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:Where: 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.

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

Posted on December 3, 2016 by Harlan Bengtson

Where to Find a Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet

To obtain a Membrane Bioreactor Wastewater Treatment Calculations spreadsheet, click 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.

Figure 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.

Figure 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.

API 570 Piping Inspection Calculations Spreadsheet

Posted on October 3, 2016 by Harlan Bengtson

Where to Find an API 570 Piping Inspection Calculations Spreadsheet

To obtain an API 570 Piping Inspection Calculations spreadsheet, click here to visit our spreadsheet store. This Excel spreadsheet is intended for making piping inspection calculations from API 570 and API 574.. You can buy a convenient API 570 piping Inspection calculations spreadsheet for a very reasonable price. This spreadsheet calculates required minimum pipe wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP). It is available in either U.S. units or S.I. units. Read on for information about using an API 570 piping inspection calculations spreadsheet.

Formulas for API 570 Piping Inspection Calculations Spreadsheet

The required minimum wall thickness for piping being inspected must be the greater of the calculated pressure design wall thickness and the structural minimum wall thickness. The pressure design wall thickness is sometimes calculated with the Barlow formula and sometimes it is calculated with the ASME B31.3 formula. Both are shown below.

In the Barlow formula and the ASME B31.3 formula, P is the design fluid pressure in psig, D is the pipe O.D. in inches, S is the allowable unit stress of the pipe material in psi, E is a longitudinal quality factor, and Y is a coefficient that is a function of the pipe material and the operating temperature.

The structural minimum wall thickness is available in API 574 Table 6 for some pipe materials. The required minimum pipe wall thickness is the greater of the calculated pressure design wall thickness and the structural minimum wall thickness.

The long term corrosion rate and short term corrosion rate are calculated from values for the current measured pipe wall thickness, a previous pipe wall thickness or the initial pipe wall thickness and the time between the two. The remaining life of the pipe is calculated as the difference between the current measured pipe wall thickness minus the required minimum pipe wall thickness divided by the corrosion rate.

The maximum allowable working pressure for a pipe is calculated from the formula:

MAWP = 2SEt/D

In this formula, S, E, and D are as defined above and t is the measured pipe wall thickness in inches.

Example API 570 Piping Inspection Calculations Spreadsheet

An example API Piping Inspection Calculatons spreadsheet is partially shown in the image below. This Excel spreadsheet can be used to calculate the required minimum pipe wall thickness, corrosion rate, remaining life, and maximum allowable working pressure (MAWP). This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References:

1. American Piping Institute, AP! 570, Piping Inspection Code: In-service Inspection, Rating, Repair, and Alteration of Piping Systems, 3rd Ed, Nov, 2009

2. American Piping Institute, API 574, Inspection Practices for Piping System Components, 3rd Ed, Nov, 2009.

3. Bengtson, Harlan H., Spreadsheet for API Piping Inspection Calculations, an informational blog article at www.EngineeringExcelTemplates.com

MBBR Nitrification Denitrification Spreadsheet

Posted on August 6, 2016 by Harlan Bengtson

Where to Find an MBBR Nitrification Denitrification Spreadsheet

To obtain an MBBR Nitrification Denitrification spreadsheet, click 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 biofilm 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.

Compressible Pipe Flow Calculator Spreadsheet

Posted on December 5, 2015 by Harlan Bengtson

Where to Find a Compressible Pipe Flow Calculator Spreadsheet

To obtain a Compressible Pipe Flow Calculator Spreadsheet, click here to visit our spreadsheet store. Look in the Pipe Flow Calculations category on the Download page. This Excel spreadsheet is intended to calculate the frictional pressure drop, gas flow rate, or minimum required diameter for adiabatic compressible pipe flow. You can buy a convenient compressible pipe flow calculator spreadsheet for a very reasonable price. Calculations may be made in either U.S. or S.I. units. Read on for information about using a compressible pipe flow calculator spreadsheet.

Background for Compressible Pipe Flow Calculator Spreadsheet

Compressible pipe flow calculations are needed for gas flow if the density of the gas changes during the flow through the pipe. The fanno flow equations shown below can be used for calculations with a gas flow that has no heat transfer with surroundings. Frictional losses are taken into account. The fanno flow equations are shown below.

Example Compressible Pipe Flow Calculator Spreadsheet

An example compressible pipe flow calculator spreadsheet is partially shown in the image below. This Excel spreadsheet can be used to calculate the frictional pressure drop, or the gas flow rate, or the required minimum pipe diameter. This Excel spreadsheet, as well as others for pipe flow calculations, is available for both U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References

1. Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Darcy Weisbach equation history – http://biosystems.okstate.edu/darcy/DarcyWeisbach/Darcy-WeisbachHistory.htm

3. Bengtson, Harlan H. Fanno Compressible Flow Calculator Spreadsheet, An online blog article.

4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.

Dissolved Oxygen Saturation in Water Calculator Speadsheet

Posted on November 13, 2015 by Harlan Bengtson

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.

References

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

Sutherland Formula Viscosity Calculator

Posted on October 29, 2015 by Harlan Bengtson

Where to Find a Sutherland Formula Viscosity Calculator Excel Spreadsheet

To obtain a Sutherland formula viscosity calculator Excel spreadsheet, click here to visit our spreadsheet store. Look in the Fluid Properties category on the Download page. This Excel spreadsheet is intended to calculate gas viscosity at a specified temperature using Sutherland’s formula. You can buy a convenient Sutherland formula viscosity calculator Excel spreadsheet for a very reasonable price. This spreadsheet calculates a gas viscosity based on a reference temperature and reference viscosity.. Calculations may be made in either U.S. or S.I. units. Read on for information about using a Sutherland formula viscosity calculator Excel spreadsheet.

Background for Sutherland Formula Viscosity Calculator Excel Spreadsheet

Sutherland’s formula for calculating the viscosity of a gas at a specified gas temperature is shown below along with an explanation of the parameters in the equation.

The parameters in Sutherland’s formula are as follows:

To = reference temperature, K

μo = viscosity of the gas at temperature, To

C = Sutherland’s constant for the gas, K

T = the temperature of the gas, K

μ = the viscosity of the gas at temperature, T, in the same units as μo.

Example Sutherland Formula Viscosity Calculator Excel Spreadsheet

An example Sutherland formula viscosity calculator Excel spreadsheet is partially shown in the image below. This Excel spreadsheet can be used to calculate the viscosity of a specified gas at a specified tempeerature. This Excel spreadsheet, as well as others for fluid property calculations, is available for both U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References

Chapman, S. & Cowling, T. G., “The Mathematical Theory of Non-Uniform Gases, 3rd Ed, 1970, Cambridge Mathematical Library.
National Physical Laboratory, Kaye & Laby, Tables of Physical and Chemical Constants, Chapter 2, Section 2.2, Subsection 2.2.3.
Bengtson, Harlan, Sutherland Law Viscosity Calculator, an informational blog article.
Bengtson, Harlan H., “Gas Property Calculator Spreadsheet,” an Amazon Kindle e-book.

Nitrification Denitrification Activated Sludge Process Spreadsheet

Posted on August 25, 2015 by Harlan Bengtson

Where to Find a Nitrification Denitrification Activated Sludge Process Excel Spreadsheet

To obtain a nitrification denitrification activated sludge process Excel spreadsheet, click 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.

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.

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.

Gas Compressibility Factor Calculator Excel Spreadsheet

Posted on July 6, 2015 by Harlan Bengtson

Where to Find a Gas Compressibility Factor Calculator Excel Spreadsheet

To obtain a gas compressibility factor calculator Excel spreadsheet, click here to visit our spreadsheet store. Look in the Fluid Properties category on the Download page. This Excel spreadsheet is intended for calculation of the compressibility factor of a gas using the Redlich-Kwong equation of state. You can buy a convenient gas compressibility factor calculator Excel spreadsheet for a very reasonable price. This spreadsheet calculates the compressibility factor of a gas from the gas temperature, gas pressure, and the critical pressure and critical temperature of the gas. It is available in either U.S. or S.I. units. Read on for information about using a gas compressibility factor calculator Excel spreadsheet.

Background for Gas Compressibility Factor Calculator Excel Spreadsheet

The compressibility factor of a gas is used in several types of calculations including calculation of real gas density. The Ideal Gas Law, PV = nRT, can be used to calculate the density of a gas that exhibits ideal gas behavior by introducing the molecular weight of the gas and solving for gas density to give: ρ = MW*P/R*T.
For information on the use of the ideal gas to calculate gas density, see the article, “Air Density Calculator Excel Spreadsheet.”

Conditions required for ideal gas behavior are pressure << critical pressure and/or temperature >> critical temperature. For gases that don’t exhibit ideal gas behavior, the compressibility factor, Z can be introduced to give: ρ = Z*MW*P/R*T.

The Redlich-Kwong Equation of State

One possibility for a gas compressibility factor calculator Excel spreadsheet is through the use of the Redlich-Kwong equation of state, which is shown below:

A, B, and h are constants calculated as shown. The compressibility factor, Z, can be calculated for known values of the gas temperature, T, the gas temperature, P, and the critical temperature and pressure of the gas. The temperatures should be in K and the pressures in atm for use of the equations given above. Calculation of Z requires an iterative calculation because the equations can’t be solved explicitly for Z.

Example Gas Compressibility Factor Calculator Excel Spreadsheet

An example gas compressibility factor calculator Excel spreadsheet is partially shown in the image below. This Excel spreadsheet can be used to calculate the compressibility factor of a gas, based on user input values for gas temperature, gas pressure, and the critical temperature and pressure of the gas. This Excel spreadsheet, as well as others for fluid property calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

References

1. Otto Redlich, and J.N.S. Kwong, “On the Thermodynamics of Solutions. V. An Equation of State. Fugacities of Gaseous Solutions”, Chemical Reviews 44 pp. 233-244 (1949).

2. Bengtson, Harlan H., Redlich Kwong Compressibility Factor Spreadsheet, an informational online blog article.