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

 

 

Compressible Pipe Flow Calculator Spreadsheet

Where to Find a Compressible Pipe Flow Calculator Spreadsheet

To obtain a Compressible Pipe Flow Calculator Spreadsheetclick 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.

Compressible Pipe Flow Calculator Spreadsheet Fanno Flow EquationsExample 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.

compressible pipe flow calculator spreadsheet screenshotReferences

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

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.

Sutherland Formula Viscosity Calculator

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.

Sutherland Formula for Gas Viscosity CalculationThe 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.

Sutherland Formula Viscosity Calculator SpreadsheetReferences

  1. Chapman, S. & Cowling, T. G., “The Mathematical Theory of Non-Uniform Gases, 3rd Ed, 1970, Cambridge Mathematical Library.
  2. National Physical Laboratory, Kaye & Laby, Tables of Physical and Chemical Constants, Chapter 2, Section 2.2, Subsection 2.2.3.
  3. Bengtson, Harlan, Sutherland Law Viscosity 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.

Gas Compressibility Factor Calculator Excel Spreadsheet

Where to Find a Gas Compressibility Factor Calculator Excel Spreadsheet

To obtain a gas compressibility factor calculator Excel spreadsheetclick 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:

Gas Compressibility Factor Calculator Excel Spreadsheet - Redlich-Kwong Equation of StateA, 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.

Gas Compressibility Factor Calculator Excel Spreadsheet ScreenshotReferences

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.

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

 

Flow Through Non Circular Ducts Spreadsheet

Where to Find a Spreadsheet for Flow Through Non Circular Ducts

To obtain a spreadsheet for  flow through non circular ductsclick here to visit our spreadsheet store.  Intended for use in calculating flow rate or frictional head loss and frictional pressure drop, you can buy a convenient spreadsheet for  flow through non circular ducts calculations for a very reasonable price.  This spreadsheet makes calculations with the Hagen Poiseuille equation for laminar flow and with the Moody friction factor and the Darcy Weisbach equation for turbulent flow for flow through an annulus and for flow through a rectangular duct.  Turbulent flow calculations can be made for a general non-circular duct with known cross-sectional area and wetted perimeter.  It is available in either U.S. or S.I. units.  Read on for information about a spreadsheet for flow through a non circular duct calculations.

Turbulent Flow Through Non Circular Ducts

The Moody friction factor is used in the Darcy Weisbach equation for turbulent flow through non circular ducts.  The Darcy Weisbach equation is:

Flow Through Non Circular Ducts Equation

Where the hydraulic diameter is used for D in the Darcy Weisbach equation for flow through non circular ducts.  For further discussion of the Moody friction factor and its use in the Darcy Weisbach equation for pipe flow calculations, see the post, “Pipe Flow-Friction Factor Calculations with Excel Spreadsheets.”

Laminar Flow Through Non Circular Ducts

For laminar flow in an annulus or laminar flow in a rectangular duct, the Hagen Poiseuille equation should be used.  For flow through an annulus, it is:

Flow Through Non Circular Ducts Laminar Equations

Hagen Poiseiulle equations for laminar flow through an annulus

 

 Example Spreadsheet for Flow Through Non Circular Ducts

A spreadsheet for flow through non circular ducts calculations is partially shown in the image below.  This Excel spreadsheet can be used to calculate the frictional pressure drop and head loss or flow rate for flow through an annulus (laminar or turbulent flow), flow through a rectangular duct (laminar or turbulent flow) or flow through a general non circular duct (turbulent flow only).  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.

Flow Through Non Circular Ducts - Annulus

 Reference:

1. Bengtson, Harlan, “Pressure Drop in a Non Circular Duct”, an online blog article

Hydraulic Grade Line and Energy Grade Line Spreadsheet

Where to Find a Hydraulic Grade Line and Energy Grade Line Spreadsheet

To obtain a spreadsheet for  hydraulic grade line and energy grade line calculations and plotting, click here to visit our spreadsheet store.  Intended for use in calculating and plotting HGL and EGL for up to 10 points of stormwater flow along a storm sewer line, you can buy a convenient spreadsheet to make HGL and EGL calculations and plots for a very reasonable price.  This spreadsheet is available in either U.S. or S.I. units.  Read on for information about a spreadsheet for calculating and plotting storm sewer hydraulic grade line and energy grade line.

Equations for Hydraulic Grade Line and Energy Grade Line

The equations for the Hydraulic Grade Line and Energy Grade Line (EGL) are:

Hydraulic Grade Line and Energy Grade Line equationsWhere:    HGL

HGL = hydraulic grade line in ft                EGL = energy grade line in ft

P = pressure in psf                                        γ = specific weight in lb/ft3

h = elevation in ft                                         V = velocity in ft/sec

g = acceleration of gravity in ft/sec2

Example Spreadsheet for Hydraulic Grade Line and Energy Grade Line Plots

A spreadsheet for Hydraulic Grade Line and Energy Grade Line calculations and plotting is partially shown in the image below.  This Excel spreadsheet can be used to calculate and plot the energy grade line and hydraulic grade line.  This Excel spreadsheet, as well as others for stormwater management calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

hydraulic grade line and energy grade line plot

Reference:

Bengtson, Harlan H., Hydraulic Grade Line Calculation Spreadsheet, an informational blog article

Trilateration Surveying Data Processing

Where to Find a Trilateration Surveying Data Processing Program

To obtain a  trilateration surveying data processing program click here to visit our download store.  Look for “WinTri – A Computer Program for Trilateration” in the “Surveying” category to find it.  This standalone program can be used for data reduction in connection with trilateration surveys.  You can buy this convenient data reduction program for trilateration surveys for a very reasonable price (only $79.95).

Introduction to WinTri – A Trilateration Surveying Data Processing Program

WinTri is a standalone computer program (not a spreadsheet) for trilateration surveying data processing.  It can be used for reduction of data from trilateration surveys; in particular WinTri calculates the coordinates of stations.  The program is general in that it will handle any surveying control figure that a user might specify.  Data validation is a key feature of the program.  Input data from surveys are extensively checked for errors, and warning messages are displayed on the screen when an error is encountered.  In calculating results, WinTri employs least-squares adjustment.

Win-Tri Help screens provide complete, annotated examples of all required input files.  Sufficient explanation is given so that someone who has never used the program before can prepare all input data solely by studying the Help screens.

How to Use WinTri – A Trilateration Surveying Data Processing Program

This trilateration surveying data processing program is simple to use.  Aside from Help screens, the program displays only three screens.  The first screen is the title screen, and the second is a screen with a single message directing the first-time user to the appropriate help screen designed for beginners.  The third screen displays seven command buttons: (1) Read master file, (2) Enter elevations, (3) Save elevations, (4) Read raw data, (5) Calculate coordinates (of stations), (6) Save results, and (7) Re-start.  The buttons are enabled and disabled automatically as the program user proceeds through the various steps of the analysis.  The “Save elevations” button allows the user to interrupt hand entry of elevation data, stop the program and subsequently start the program at a later time without having to re-enter those elevations that had already been entered.

Besides the command buttons, the third screen contains a textbox labeled “Program Log.”  If a step in the operation of the program is successfully completed, the program log displays a message to that effect.  If an error occurs, then the log displays a message describing the error.

A Screenshot of WinTri – A Trilateration Surveying Data Processing Program

The image below shows a screenshot of the introductory screen of WinTri a trilateration surveying data processing program.

WinTri Trilateration Surveying Data Processing Program Screenshot

Figure 1. Screenshot of WinTri, a Trilateration Surveying Data Processing Program

The Source Code for WinTri – A Trilateration Surveying Data Processing Program

In addition to an executable module that can be installed and run, the source code, consisting of about 5000 Visual Basic 6.0 statements is provided in case the user wants to revise the program to meet specialized needs.  The program is thoroughly documented with commen” are used throughout so that much of the code reads like ordinary English.

Anyone involved in trilateration surveys should find the program helpful.  It is easy to learn, it can be used for any control network that the user specifies, and – most important of all – it greatly lessens the tedious and time-consuming task of locating and identifying errors in the survey data.

Reference

Rossow, Mark, Trilateration Surveying Data Processing, An informational blog article.