Here you will find informational articles on topics related to the Excel spreadsheets for civil and mechanical engineering calculations available from the DOWNLOADS page. This includes articles in the clickable categories below: pipe flow calculations, open channel flow, heat transfer/heat exchangers, storm water/hydrology, continuous beam analysis and design, open channel flow measurement, and pipe flow measurement topics. Scroll down on each category page to see all of the articles.
Similar blog articles are available at our companion site, www.EngineeringExcelSpreadsheets.com.
To obtain a MBR Wastewater Treatment Process Design 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 MBR wastewater treatment process design 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.
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.
An example MBR wastewater treatment process design 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
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, "Membrane Bioreactor Wastewater Treatment Calculations Spreadsheet," an online blog article
To obtain a Fanno Compressible 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 fanno compressible 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 fanno compressible 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 Fanno Compressible Flow Calculator Spreadsheet
An example fanno compressible 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. Compressible Pipe Flow Calculatior Spreadsheet , An online blog article.
4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.
To obtain a Dissolved Oxygen Solubility 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 solubility in water calculator Excel spreadsheet for a very reasonable price. This spreadsheet calculates dissolved oxygen saturation concentration 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 solubility 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 Solubility 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.
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).
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.
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.
The image below shows a screenshot of the introductory screen of WinTri a trilateration surveying data processing program.
Figure 1. Screenshot of 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.
Rossow, Mark, Trilateration Surveying Data Processing, An informational blog article.
To obtain a tutorial program on shear and bending moment diagrams, click 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 V and M diagrams for a very reasonable price (only $4.95).
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 quiz facility is also provided for use of the program in a classroom setting.
The beginning of the tutorial on Shear and Bending Moment Diagrams is shown in the image below. This program can be used to help understand V and M diagrams and how to construct them.
Figure 1. A Tutorial Program on Shear and Bending Moment Diagrams
Rossow, M, How to Draw V and M Diagrams - A Tutorial, a blog article at http://www.engineeringexcelspreadsheets.com/2014/12/how-to-draw-v-and-m-diagrams-a-tutorial/