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.

MBBR Wastewater Treatment Design Spreadsheet

 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.

How to Draw V and M Diagrams – A Tutorial

Where to Find a Tutorial on How to Draw V and M Diagrams

To obtain a tutorial program on  how to draw V and M diagramsclick here to visit our download store.  Look for “Understanding V and M Diagrams” in the “Strength of Materials” category to find it.  This standalone program provides practice for learning the principles underlying shear diagrams and bending moment diagrams.  You can buy this convenient tutorial beam diagrams program on how to draw shear and bending moment diagrams for a very reasonable price (only $4.95).

A Description of the Tutorial Program on How to Draw V and M Diagrams

This standalone program contains over 50 exercises, which have been chosen to represent all common boundary conditions and load cases for structural beams.  The difficulty of the exercises ranges from easy to challenging.

The program is highly interactive: starting with a point at the origin of the shear diagram, the user calculates the coordinates of the next point where the diagram changes slope or direction.  Then the user employs the mouse cursor to plot this point on the screen.  After plotting the point, the user specifies the type of curve (for example, straight line or curved line concave up), connecting the two points.  The user proceeds in a similar manner to plot the next point on the diagram and connect it to the most recently plotted point.  Continuing in this fashion, the user completes the shear diagram and then goes on to the bending moment diagram.

Five kinds of Help screens are available:

  • A step-by-step tutorial on how to operate the program is provided which guides the user through a simple example on how to draw V and M diagrams.
  • Diagrams defining sign conventions for V (shear) and M (bending moment) are given.
  • Techniques for calculating V and M are described in terms of specific numerical calculations.
  • The answer for the current step in the diagram construction is given—the value of V or M or type of curve connecting two points on the diagram.  How the answer is calculated is explained in detail.
  • A complete numerical example showing both shear and bending moment diagrams with key values labeled on the diagrams is provided.  When the user positions the mouse cursor over any part of the diagram, a pop-up window opens containing an explanation of how that particular part of the diagram was constructed.  For example, positioning the cursor over the point of maximum moment on the beam (which is loaded with a distributed load) brings up the comment that the maximum moment occurs where the shear is zero.  Positioning the cursor over a jump in the shear diagram brings up the comment that the jump is caused by the support reaction acting on the beam.

A quiz facility is also provided for use of the program in a classroom setting.

Screenshot of Tutorial Program on How to Draw V and M Diagrams

The beginning of the tutorial on How to Draw V and M Diagrams is shown in the image below.  This program can be used to help understand shear and bending moment diagrams and how to construct them.

How to Draw V and M Diagrams Tutorial Screenshot

Figure 1. A Tutorial Program on How to Draw V and M Diagrams

Reference

Rossow, M., Shear and Bending Moment Diagrams – A Tutorial, a blog article at: http://www.engineeringexceltemplates.com/blog.aspx