This is the Downloads page's introductory text. You can edit it, and the above page heading, from the Admin area's Downloads link located under the All-Access Area heading.
If you don't want your site to include this page, you can hide this entire page (and your site's link to it). To do that, log in to the Admin area and:
This spreadsheet bundle contains the U.S. version of all seven of the spreadsheets described below in this category, that is: 1) Pipe Flow Calcns-Incompressible Laminar or Turbulent Flow, 2) Natural Gas Pipeline Flow Calculations, 3) Compressible Pipe Flow-Fanno Flow Calculator, 4) Hazen Williams Pipe Flow Calculations Package, 5) Moody Friction Factor Calculator, 6) Min Pipe Wall Thickness-Max Pressure, 7) API 570-API 574 Piping Inspection Calculations.
This spreadsheet bundle contains the S.I. version of all seven of the spreadsheets described below in this category, that is: 1) Pipe Flow Calcns-Incompressible Laminar or Turbulent Flow, 2) Natural Gas Pipeline Flow Calculations, 3) Compressible Pipe Flow-Fanno Flow Calculator, 4) Hazen Williams Pipe Flow Calculations Package, 5) Moody Friction Factor Calculator, 6) Min Pipe Wall Thickness-Max Pressure, and 7) API 570-API 574 Piping Inspection Calculations.
FREE DOWNLOAD! Try this Excel spreadsheet to calculate the frictional head loss and pressure drop for specified flow rate, pipe diameter, pipe length, pipe roughness, liquid density and viscosity, and the value of the Moody friction factor. U.S. and S.I. units
This Excel spreadsheet makes pipe flow/friction factor calculation for either laminar or turbulent flow conditions. The spreadsheet has three tabs, one for head loss/frictional pressure drop in pipe calculation, one for calculating pipe flow rate and one for determining required pipe diameter. All three are for liquid flow and all are set up to include the effects of straight pipe losses and/or minor losses. This package includes the friction factor calculator. Calculations use the Darcy-Weisbach/friction factor equation and are in U.S. units.
This Excel spreadsheet makes pipe flow/friction factor calculation for either laminar or turbulent flow conditions. The spreadsheet has three tabs, one for head loss/frictional pressure drop in pipe calculation, one for calculating pipe flow rate and one for determining required pipe diameter. All three are for liquid flow and all are set up to include the effects of straight pipe losses and/or minor losses. This package includes the friction factor calculator. Calculations use the Darcy-Weisbach/friction factor equation and are in S.I. units.
This Excel spreadsheet bundle is a convection heat transfer coefficient calculator including both the forced convection heat transfer coefficient calculator spreadsheet package and the natural convection heat transfer coefficient calculator spreadsheet package (both described in more detail below), providing the means to calculate convection heat transfer coefficients for six different forced convection configurations and five different natural convection heat transfer coefficients, all in U.S. units.
This Excel spreadsheet bundle includes both the forced convection heat transfer coefficient spreadsheet package and the natural convection heat transfer coefficient spreadsheet package (both described in more detail below), providing the means to calculate convection heat transfer coefficients for six different forced convection configurations and five different natural convection heat transfer coefficients, all in S.I. units.
Six forced convection heat transfer coefficient calculator worksheets are included in this package. Forced convection heat transfer coefficients can be calculated for turbulent pipe flow, laminar pipe flow, turbulent flow in an annulus, turbulent flow in a non-circular duct, cross-flow past a circular cylinder, and flow parallel to a flat plate. These spreadsheets are set up for U.S. units.
FREE DOWNLOAD! Try this Excel Spreadsheet! Forced convection heat transfer coefficients for laminar flow in pipes can be calculated in either U.S. or S.I. units. Three different correlations for Nusselt number are used for determining forced convection heat transfer coefficients from values for Reynolds number, Prandtl number, and L/D.
This package includes six Excel templates for calculation of forced convection heat transfer coefficients for turbulent flow in pipes, laminar flow in pipes, turbulent flow in an annulus, turbulent flow in a non-circular duct, flow past a single cylinder and flow paralle to a flat plate. These Excel spreadsheets are set up to use S.I. units.
FREE DOWNLOAD! Try this Excel template to calculate the discharge and average velocity for partially full pipe flow with the pipe flowing less than half full with either U.S. or S.I. units using the Manning equation.
This partially full pipe flow calculator spreadsheet package contains worksheets to calculate 1) pipe flow rate, ii) normal depth, iii) required diameter for a target depth/diameter ratio, iv) required pipe slope, or v) Manning roughness coefficient, for partially full pipe flow of water, with calculations in U.S. units.
This partially full pipe flow calculator spreadsheet package has been newly updated to contain worksheets to calculate i) pipe flow rate, ii) normal depth, iii) required diameter for a target depth/diameter ratio, iv) required pipe slope, or v) Manning roughness coefficient, for partially full pipe flow of water, with calculations in S.I. units.
This Excel spreadsheet gives the NRCS dimensionless unit hydrograph, which can be used to develop a storm hydrograph for a specific basin based on information about that basin.
FREE DOWNLOAD! Use this Excel spreadsheet to calculate the travel time for overland sheet flow of storm water runoff, for known values of watershed slope, flow path length, Manning roughness, and 2 yr-24 hr rainfall amount. Calculations can be made in either U.S. or S.I. units.
This Manning equation Excel spreadsheet bundle has i) the Hydraulic Radius Calculator, ii) Q and V for Open Channel Flow, iii) Normal Depth for Open Channel Flow Spreadsheets and iv) trapezoidal channel with two side slopes, as described below. The spreadsheets in this bundle all use U.S. units.
This Excel spreadsheet bundle has i) the Hydraulic Radius Calculator, ii) Q and V for Open Channel Flow, iii) Normal Depth for Open Channel Flow, and iv) trapezoidal channel with two side slopes Spreadsheets as described below. The spreadsheets in this bundle all use S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation Excel Spreadsheet Bundle (described above) and in the Open Channel Flow Measurement Bundle (V-notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation Open Channel Flow Spreadsheet Bundle (described above) and in the Open Channel Flow Measurement Bundle (V-notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets). Calculations are in S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation and Open Channel Flow Meas Bundle (described above); and those in the NonUnif and Critical Open Chan Flow Bundle (spreadsheets for hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Manning Equation and Open Channel Flow Measurement Bundle (described above); and those in the NonUnif and Critical Open Chan Flow Bundle (spreadsheets for hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles). Calculations are in S.I. units.
This set of Excel spreadsheets makes it easy to calculate the hydraulic radius for open channel flow in a triangular, rectangular, or trapezoidal channel, or in a circular pipe flowing partially full (either less than half or more than half full). These calculations are in U.S. units.
FREE DOWNLOAD! This Excel spreadsheet calculates the volumetric flow rate and average velocity for open channel flow in a triangular channel for specified channel side slope, flow depth, Manning roughness coefficient, and channel bottom slope. The calculations are in either U.S. or S.I. units.
This package includes the spreadsheets for calculating flow rate and average velocity for open channel flow in a rectangular, trapezoidal, or triangular channel, with specified channel bottom slope, Manning roughness coefficient, and appropriate channel size/shape parameters. These spreadsheets use U.S. units.
These normal depth open channel flow Excel Spreadsheets include those for calculating normal depth in rectangular, trapezoidal, or triangular channels. The calculations use U.S. units.
These hydraulic radius calculator Excel spreadsheets makes it easy to calculate the hydraulic radius for open channel flow in a triangular, rectangular, or trapezoidal channel, or in a circular pipe flowing partially full (either less than half or more than half full). These calculations are in S.I. units.
This package includes the spreadsheets for calculating flow rate and average velocity for open channel flow in a rectangular, trapezoidal, or triangular channel, with specified channel bottom slope, Manning roughness coefficient, and appropriate channel size/shape parameters. These spreadsheets use S.I. units.
This set of Excel Spreadsheets includes those for calculating normal depth in rectangular, trapezoidal, or triangular channels. The calculations use S.I. units.
This Excel spreadsheet for natural gas pipeline flow calculations will carry out several pipeline flow calculations for natural gas, including calculation of natural gas properties, such as compressibility factor, density and viscosity. It has worksheets to calculate 1) natural gas flow rate, 2) required pipeline diameter, 3) outlet pressure, or 4) inlet pressure using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. U.S. units are used in the calculations.
This Excel spreadsheet for natural gas pipeline flow calculations will carry out several pipeline flow calculations for natural gas, including calculation of natural gas properties, such as compressibility factor, density and viscosity. It has worksheets to calculate 1) natural gas flow rate, 2) required pipeline diameter, 3) outlet pressure, or 4) inlet pressure using the Weymouth Equation, the Panhandle A Equation, and the Panhandle B Equation. S.I. units are used in the calculations.
This Fanno Flow Calculator Excel spreadsheet workbook carries out adiabatic compressible flow calculations for turbulent or laminar gas flow through a pipe, including minor losses. There are worksheets for calculating frictional pressure drop, gas flow rate, or minimum required pipe diameter. The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Needed gas properties are available in the workbook for 23 gases (acetylene, air, ammonia, argom. carbon dioxide, carbon monoxide, chlorine, ethane, ethylene, helium, hydrogen, hydrogen chloride, hydrogen sulphide, krypton, methane, methyl chloride, neon, nitric oxide, nitrogen, nitrous oxide, oxygen, sulphur dioxide, and xenon. ) Also the user may enter the needed gas properties for any other gas. Calculations use U.S. units.
This Fanno Flow Calculator Excel spreadsheet workbook carries out adiabatic compressible flow calculations for turbulent or laminar gas flow through a pipe, including minor losses. There are worksheets for calculating frictional pressure drop, gas flow rate, or minimum required pipe diameter. The worksheets each calculate "choked flow" conditions first to show the limits for the user input parameters. Needed gas properties are available in the workbook for 23 gases (acetylene, air, ammonia, argom. carbon dioxide, carbon monoxide, chlorine, ethane, ethylene, helium, hydrogen, hydrogen chloride, hydrogen sulphide, krypton, methane, methyl chloride, neon, nitric oxide, nitrogen, nitrous oxide, oxygen, sulphur dioxide, and xenon. ) Also the user may enter the needed gas properties for any other gas. Calculations use S.I. units.
This Excel spreadsheet package includes capability to calculate pipe flow rate, diameter, pressure drop, or length with the Hazen Williams equations, if the other parameters are specified. Calculations are in U.S. units
This set of Excel spreadsheets can calculate pipe flow rate, diameter, pressure drop, or length if the other parameters are specified, using the Hazen Williams equation in S.I. units.
These Excel spreadsheets calculate the head loss and pressure drop for flow of a liquid through an annulus, or a rectangular duct or a general non-circular duct. There are separate worksheets to calculate pressure drop/head loss or flow rate for each of the three non-circular duct configurations. The worksheets for flow through an annulus and for flow through a rectangular duct can handle either laminar flow or turbulent flow calculations. The general non-circular duct worksheets are useable only for turbulent flow. Calculations are in U.S. units.
These Excel spreadsheets calculate the head loss and pressure drop for flow of a liquid through an annulus, or a rectangular duct or a general non-circular duct. There are separate worksheets to calculate pressure drop/head loss or flow rate for each of the three non-circular duct configurations. The worksheets for flow through an annulus and for flow through a rectangular duct can handle either laminar flow or turbulent flow calculations. The general non-circular duct worksheets are useable only for turbulent flow. Calculations are in S.I. units.
This handy Excel spreadsheet will calculate the Moody friction factor for specified pipe diameter, length, roughness, and flow rate, along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in U.S. units.
This handy friction factor calculator is an Excel spreadsheet that will calculate the Moody friction factor for specified pipe diameter, length, diameter, roughness and flow rate along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in S.I. units.
FREE DOWNLOAD - Try this Excel template! The natural convection heat transfer coefficient between a fluid and a sphere can be calculated in either U.S. or S.I. units with this Excel spreadsheet. Input parameters are needed to allow calculation of the Prantl number and the Grashof number. The natural convection heat transfer coefficient is calculated from the Nusselt number, which comes from a correlation for Nusselt number in terms of Prantl and Grashof numbers.
Five natural convection heat transfer coefficient calculator spreadsheets are included in this package. Natural convection heat transfer coefficients can be calculated for heat transfer between a fluid and a vertical plate, a horizontal plate, an inclined plate, a horizontal cylinder or a sphere. These spreadsheets make the calculations in U.S. units
Five free convection heat transfer coefficient calculator spreadsheets are included in this package. Natural convection heat transfer coefficients can be calculated for heat transfer between a fluid and a vertical plate, a horizontal plate, an inclined plate, a horizontal cylinder or a sphere. These spreadsheets make the calculations in S.I. units
This Excel spreadsheet bundle includes the V-Notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets described below. This spreadsheet bundle uses U.S. units.
This Excel spreadsheet bundle includes the V-Notch Weir, Rectangular Weir, Sutro Weir, Broad-Crested Weir, and Parshall Flume spreadsheets described below. This spreadsheet bundle uses S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Open Channel Flow Measurement Bundle (described below) and in the Manning Equation Excel Spreadsheet Bundle (spreadsheets for Q and V calculation, normal depth calculation, hydraulic radius calculator, and trapezoidal channel with two side slopes.). Calculations are in U.S. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Open Channel Flow Measurement Bundle (described below) and in the Manning Equation - Open Channel Flow Spreadsheet Bundle (spreadsheets for Q and V calculation, normal depth calculation, hydraulic radius calculator, and trapezoidal channel with two side slopes.). Calculations are in S.I. units.
This Excel spreadsheet package includes the U.S. versions of the following five storm sewer calculations spreadsheets, which are described below: 1) Storm Sewer Hydraulic Design, 2) Rational Method-Stormwater Runoff, 3) Stormwater Inlet Size or Capacity Calcn, 4) Hydraulic Grade Line and Energy Grade Line Calculations, and 5) Partially Full Pipe Flow Calculations
This Excel spreadsheet package includes the S.I. versions of the following five storm sewer calculations spreadsheets, which are described below: 1) Storm Sewer Hydraulic Design, 2) Rational Method-Stormwater Runoff, 3) Stormwater Inlet Size or Capacity Calcn, 4) Hydraulic Grade Line and Energy Grade Line Calculations, and 5) Partially Full Pipe Flow Calculations
This Excel spreadsheet bundle includes the U.S. versions of the following five stormwater detention pond calculations spreadsheets, which are described below: 1) Detention Pond Routing Spreadsheets, 2) Design Storm Hyetograph Generation, 3) Rational Method - Stormwater Runoff, 4) Unit Hydrograph Calculations, 5) Direct Runoff Hydrograph Generation, and 6) Stormwater Detention Pond Calculations.
This Excel spreadsheet bundle includes the S.I. versions of the following five stormwater detention pond calculations spreadsheets, which are described below: 1) Detention Pond Routing Spreadsheets, 2) Design Storm Hyetograph Generation, 3) Rational Method Stormwater Runoff, 4) Unit Hydrograph Calculations, 5) Direct Runoff Hydrograph Generation, and 6) Stormwater Detention Pond Calculations.
This spreadsheet bundle includes the U.S. versions of all the spreadsheets in the Storm Water Calculations category, that is all of the spreadsheets listed in the Storm Sewer Calculations Package, all of the spreadsheets listed in the Stormwater Detention Pond Calculations Bundle, and the Culvert Design spreadsheet.
This spreadsheet bundle includes the S.I. versions of all the spreadsheets in the Storm Water Calculations category, that is all of the spreadsheets listed in the Storm Sewer Calculations Package, all of the spreadsheets listed in the Stormwater Detention Pond Calculations Bundle, and the Culvert Design spreadsheet.
These Excel spreadsheets carry out stormwater runoff routing calculations for a detention or retention pond. An outflow hydrograph is calculated using a given inflow hydrograph, stage-storage information, and outflow control information for the following outflow control options: i) rectangular weir, ii) orifice, iii) pipe outlet control, and two stage outlet flow control with an orifice and weir or pipe and weir. A plot showing the inflow and outflow hydrograph is provided. A stage-storage table can be generated based on specified pond bottom area and side slope. A composite inflow hydrograph can be generated from up to five separate inflow hydrographs. These calculations use U.S. units.
These Excel spreadsheets carry out stormwater runoff routing calculations for a detention or retention pond. An outflow hydrograph is calculated using a given inflow hydrograph, stage-storage information, and outflow control information for the following outflow control options: i) rectangular weir, ii) orifice, iii) pipe outlet control, and two stage outlet flow control with an orifice and weir or pipe and weir. A plot showing the inflow and outflow hydrograph is provided. A stage-storage table can be generated based on specified pond bottom area and side slope. A composite inflow hydrograph can be generated from up to five separate inflow hydrographs. These calculations use S.I. units.
These Excel Spreadsheets will generate design storm hyetographs based on input values for design recurrence interval, design storm duration, and a set of values for storm intensity vs duration for the design recurrence interval and location. The spreadsheet will generate a Chicago Storm Hyetograph, a triangular hyetograph, a hyetograph generated by the alternating block method and a rectangular (constant intensity) hyetograph. Calculations are in U.S. units.
These Excel Spreadsheets will generate design storm hyetographs based on input values for design recurrence interval, design storm duration, and a set of values for storm intensity vs duration for the design recurrence interval and location. The spreadsheet will generate a Chicago Storm Hyetograph, a triangular hyetograph, a hyetograph generated by the alternating block method and a rectangular (constant intensity) hyetograph. Calculations are in S.I. units.
These Excel spreadsheets calculate watershed time of concentration using 6 different equations/sets of equations. User selects the time of concentration to use based on the type of watershed. Also calculated are rainfall intensity by the Steel equation, derivation of an equation for rainfall intensity from IDF data, and peak storm water runoff rate with the Rational Method equation. Calculations are in U.S. units.
These Excel spreadsheets calculate watershed time of concentration using 6 different equations/sets of equations. User selects the time of concentration to use based on the type of watershed. Also calculated are rainfall intensity by the Steel equation, derivation of an equation for rainfall intensity from IDF data, and peak storm water runoff rate with the Rational Method equation. Calculations are in S.I. units.
Use this excel spreadsheet to carry out hydraulic design of a storm sewer line with several manholes, with an available manhole map showing the areas feeding to each manhole inlet. The output is design storm water runoff to each inlet, pipe diameter and slope between each pair of manholes, and invert elevation at each manhole. This spreadsheet uses U.S. units.
Use this excel spreadsheet to carry out hydraulic design of a storm sewer line with several manholes, with an available manhole map showing the areas feeding to each manhole inlet. The output is design storm water runoff to each inlet, pipe diameter and slope between each pair of manholes, and invert elevation at each manhole. This spreadsheet uses S.I. units.
This group of Excel spreadsheets includes all of the spreadsheets in the Open Channel Flow Measurement and Manning Equation Bundle (described above); and those in the NonUnif and Critical Open Chan Flow Bundle (spreadsheets for hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles). Calculations are in S.I. units.
This Excel spreadsheet package includes the spreadsheet described below for V-notch weir calculations and the one described below for rectangular weir calculations. This spreadsheet uses U.S. units.
This Excel spreadsheet package includes the spreadsheet described below for V-notch weir calculations and the one described below for rectangular weir calculations. This spreadsheet uses S.I. units
These Excel spreadsheets calculate the flow rate over a V-notch weir with a 90 degree notch angle (either fully contracted or partially contracted). A worksheet is also available for fully contracted flow through a notch angle of 20 to 100 degrees. Flow calculations are based on input for weir and channel dimensions, the head over the weir, and the notch angle if it is other than 90 degrees. A check on fully contracted flow conditions is included for flow over non-90 degree notches. Calculations are in U.S. units.
These Excel spreadsheets calculate the flow rate over a V-notch weir with a 90 degree notch angle (either fully contracted or partially contracted). A worksheet is also available for flow over a fully contracted notch angle between 20 and 100 degrees. Flow calculations are based on input for weir and channel dimensions, the head over the weir, and the notch angle, if it is other than 90 degrees. Checks on the "fully contracted" requirements are included. Calculations are in S.I. units.
These Excel spreadsheet templates can be used to generate a unit hydrograph from a storm hydrograph, to generate a storm hydrograph using storm information together with the NRCS dimensionless unit hydrograph, and to generate a design storm hydrograph from a basin unit hydrograph. The calculations include baseflow separation by the concave method for the unit hydrograph generation. These spreadsheets are set up for U.S. units.
These Excel spreadsheet templates can be used to generate a unit hydrograph from a storm hydrograph, to generate a storm hydrograph using storm information together with the NRCS dimensionless unit hydrograph, and to generate a design storm hydrograph from a basin unit hydrograph. The calculations include baseflow separation by the concave method for the unit hydrograph generation. These spreadsheets are set up for S.I. units.
This Excel spreadsheet will calculate flow rate through a Parshall flume based on head measurement(s) for both free flow and submerged flow. Calculations are in U.S. units.
This Excel spreadsheet calculates flow rate through a Parshall flume for either free flow or submerged flow, based on head measurement(s). Calculations are in S.I. units.
This Excel spreadsheet includes calculation of flow rate for flow over a sharp crested rectangular weir, either a suppressed rectangular weir or a contracted rectangular weir. Calculations are included for the simpler form of the equations for both the suppressed and contracted weirs as well as the use of the Kinsvater Carter equation for all rectangular, sharp crested weir configurations. This spreadsheet uses S.I. units.
This Excel spreadsheet includes calculation of flow rate for flow over a sharp crested rectangular weir, either a suppressed rectangular weir or a contracted rectangular weir. Calculations are included for the simpler form of the equations for both the suppressed and contracted weirs as well as the use of the Kinsvater Carter equation for all rectangular, sharp crested weir configurations. This spreadsheet uses U.S. units.
This Excel spreadsheet template calculates the heat transfer coefficient for condensation outside of a bank of horizontal tubes, using S.I. units.
This Excel spreadsheet template will calculate the overall heat transfer coefficient for heat transfer through a tube/pipe wall, based on input values for the inside and outside convection heat transfer coefficient, the pipe wall thermal conductivity and fouling resistaance values. Calculations are in U.S. units.
This Excel spreadsheet template will calculate the overall heat transfer coefficient for heat transfer across a tube/pipe wall, based on input values for the inside and outside convevtive heat transfer coefficient, the pipe wall thermal conductivity, and fouling resistances. Calculations are in S.I. units.
This Free Sample Excel spreadsheet Illustrates the type of calculations that can be made with the structural analysis spreadsheets that are available through this website.
This workbook has two tabs involving the allowable stress design of beams for a simply supported beam carrying a uniformly distributed load. In the first tab, input consists of span length, elastic modulus, live load, dead load, allowable bending stress, deflection limit for live load, and deflection limit for live plus dead load (serviceability requirements). The workbook then calculates the maximum moment, maximum shear, elastic section modulus, and minimum moments of inertia required to satisfy the constraints on deflection. In the second tab, a check is made of a known design to see if strength and deflection requirements are met. Input is the same as in the first tab, with the addition of the elastic section modulus and moment of inertia. The workbook then determines whether the maximum moment, deflection under live load, and deflection under live plus dead load are less than the corresponding allowables. Both SI and US Customary units are allowed. All formulas are given, and the Excel code can be easily customized to meet specialized requirements of a particular user.
This Excel workbook performs the structural analysis of simply supported beams. Loading consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This simply supported beam analysis spreadsheet is the U.S. units version of the workbook described above
This cantilever beam analysis spreadsheet performs the structural analysis of cantilever beams. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
U.S. units version of the workbook described above
This Excel workbook performs the structural analysis of beams with both ends fixed. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This Excel workbook performs the structural analysis of cantilever beams with one end fixed and the other end supported by a roller. Loadings consisting of concentrated forces, linearly varying distributed forces, and concentrated moments may be specified. Calculations are in S.I. units.
This Excel spreadsheet workbook performs the structural analysis of beams that overhang one support. Loadings consisting of concentrated and linearly varying distributed forces may be specified. Calculations are in S.I. units.
This Excel spreadsheet workbook performs the structural analysis of continuous beams with two spans (equal or unequal in length). Loadings consisting of concentrated or uniformly distributed forces may be specified. Calculations are in S.I. units.
This set of continuous beam analysis spreadsheets includes the six S.I. unit Excel workbooks that are available for $14.95 individually. These spreadsheets can do structural analysis of simply supported, cantilever, fixed end, overhang, continuous two-span, and propped cantilever beams. Beam deflections, shear diagrams and moment diagrams are plotted and also displayed in a table. This spreadsheet package comes as a .zip file. If you have a problem with unzipping the files, send an email message to hnkbengtson@yahoo.com, and I'll email the individual spreadsheets to you.
U.S. units version of the continuous beam analysis spreadsheet workbook described above
This Excel spreadsheet bundle has all of the U.S. unit spreadsheet packages in this category, including hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles.
This Excel spreadsheet bundle has all of the S.I. unit spreadsheet packages in this category, including hydraulic jump calculations, critical depth and critical slope calculations, M-1 surface profiles, and calculations of non-uniform flow surface profiles.
These Excel spreadsheets make hydraulic jump calculations for a horizontal, rectangular channel. This includes calculation of the sequent (downstream) depth for specified initial (upstream) depth, flow rate, and channel width (or flow rate per unit width). The length of the jump, the head loss across the jump, and the jump efficiency can also be calculated, as well as the flow rate under a sluice gate. Information on the type of jump to be expected for several ranges of initial Froude number is also provided. These spreadsheets use U.S. units
These Excel spreadsheets make hydraulic jump calculations for a horizontal, rectangular channel. This includes calculation of the sequent (downstream) depth for specified initial (upstream) depth, flow rate, and channel width (or flow rate per unit width). The length of the jump, the head loss across the jump, and the jump efficiency can also be calculated, as well as the flow rate under a sluice gate. Information on the type of jump to be expected for several ranges of initial Froude number is also provided. These spreadsheets use S.I. units
These Excel spreadsheets calculate the surface profile for the M-1 category of non uniform open channel flow in either a rectangular channel or a trapezoidal channel using U.S. units.
These Excel spreadsheets calculate the surface profile for the M-1 category of non uniform open channel flow in either a rectangular channel or a trapezoidal channel using S.I. units.
These Excel spreadsheets calculate the critical depth and critical slope for either a rectangular channel or a trapezoidal channel, with specified flow rate, Manning roughness coefficient, and channel size. The calculations are in U.S. units.
These spreadsheets calculate the critical depth and critical slope for either a rectangular or a trapezoidal channel with specified flow rate, Manning roughness coefficient, and channel size. Calculations are in S.I. units.
These Excel spreadsheets will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a rectangular trapezoidal, or triangular channel. Calculations are in U.S. units.
These Excel spreadsheets will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a rectangular, trapezoidal or triangular channel. Calculations are in S.I. units.
These Excel spreadsheets will calculate the required stormwater detention pond volume using the "loss of natural storage" method, the "generalized" method, and the "rational hydrograph" method. The outlet flow control can be designed for an orifice, a weir, or a pipe as the outlet control device. These calculations are in U.S. units.
These Excel spreadsheets will calculate the required stormwater detention pond volume using the "loss of natural storage" method, the "generalized" method, and the "rational hydrograph" method. The outlet flow control can be designed for an orifice, a weir, or a pipe as the outlet control device. These calculations are in S.I. units.
This Excel spreadsheet uses U.S. units in an iterative procedure for thermal design of a double pipe heat exchanger. The first iteration calculates the needed heat transfer area for an estimated value of the overall heat transfer coefficient. It also leads the user through selection of pipe diameters & lengths and number of passes and calculates the annulus and tubeside pressure drops. Additional worksheets then are used to calculate the tubeside heat transfer coefficient and the annulus heat transfer coefficient. The final worksheet then calculates the overall heat transfer coefficient. The inital estimate of overall heat transfer coefficient can then be adjusted to the calculated value.
This Excel spreadsheet uses S.I. units in an iterative procedure for thermal design of a double pipe heat exchanger. The first iteration calculates the needed heat transfer area for an estimated value of the overall heat transfer coefficient. It also leads the user through selection of pipe diameters & lengths and number of passes and calculates the annulus and tubeside pressure drops. Additional worksheets then are used to calculate the tubeside heat transfer coefficient and the annulus heat transfer coefficient. The final worksheet then calculates the overall heat transfer coefficient. The inital estimate of overall heat transfer coefficient can then be adjusted to the calculated value.
This Excel spreadsheet workbook has 4 worksheets. Two can be used to determine the size stormwater inlet needed for curb inlets or gutter inlets, using either an orifice model or weir model for sizing the opening. The other two worksheets can be used to calculate the capcity of either a curb inlet or a gutter inlet for specified inlet dimensions and stormwater depth at the inlet. The calculations are in U.S. units.
This Excel spreadsheet workbook has 4 worksheets. Two can be used to determine the size stormwater inlet needed for curb inlets or gutter inlets, using either an orifice model or weir model for sizing the opening. The other two worksheets can be used to calculate the capcity of either a curb inlet or a gutter inlet for specified inlet dimensions and stormwater depth at the inlet. The calculations are in S.I. units.
This Excel spreadsheet package includes the spreadsheet workbooks described below for gas flow and for liquid flow through a venturi meter that meets ISO 5167 standards. Calculations are in U.S. units.
This Excel spreadsheet package includes the spreadsheet workbooks described below for gas flow and for liquid flow through a venturi meter that meets ISO 5167 standards. Calculations are in S.I. units.
These Excel spreadsheets make venturi meter gas flow calculations, using ISO 5167 determination of the discharge coefficient. Three worksheets are available to calculate flow rate for specified pressure difference, pipe diameter and throat diameter; or to calculate pressure difference for specified flow rate, pipe diameter and throat diameter; or to calculate throat diameter needed for given flow rate, pipe diameter, and pressure difference, using U.S. units. The worksheets also check on whether the venturi meter and flow conditions satisfy ISO 5167 requirements for pipe diameter, diameter ratio and Reynolds number.
These Excel spreadsheets make venturi meter gas flow calculations, using ISO 5167 determination of the discharge coefficient. Three worksheets are available to calculate flow rate for specified pressure difference, pipe diameter and throat diameter; or to calculate pressure difference for specified flow rate, pipe diameter and throat diameter; or to calculate throat diameter needed for given flow rate, pipe diameter, and pressure difference, using S.I. units. The worksheets also check on whether the venturi meter and flow conditions satisfy ISO 5167 requirements for pipe diameter, diameter ratio and Reynolds number.
These Excel spreadsheets make venturi meter liquid flow calculations, using ISO 5167 for determination of the discharge coefficient. Three worksheets are available to calculate flow rate for specified pressure difference, pipe diameter and throat diameter; or to calculate pressure difference for specified flow rate, pipe diameter and throat diameter; or to calculate throat diameter needed for given flow rate, pipe diameter, and pressure difference, using U.S. units. The worksheets also check on whether the venturi meter and flow conditions satisfy ISO 5167 requirements for pipe diameter, diameter ratio and Reynolds number.
These Excel spreadsheets make venturi meter liquid flow calculations, using ISO 5167 determination of the discharge coefficient. Three worksheets are available to calculate flow rate for specified pressure difference, pipe diameter and throat diameter; or to calculate pressure difference for specified flow rate, pipe diameter and throat diameter; or to calculate throat diameter needed for given flow rate, pipe diameter, and pressure difference, using S.I. units. The worksheets also check on whether the venturi meter and flow conditions satisfy ISO 5167 requirements for pipe diameter, diameter ratio and Reynolds number.
This includes the U.S. versions of both of the gas flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (2 inch to 40 inch diameter) and the other uses ASME equations for small bore pipes (1/2 to 1 1/2 inch diameter).
This includes the S.I. versions of both of the gas flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (50 mm to 1000 mm diameter) and the other uses ASME equations for small bore pipes (12 to 40 mm diameter).
This includes the U.S. versions of both of the liquid flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (2 inch to 40 inch diameter) and the other uses ASME equations for small bore pipes (1/2 to 1 1/2 inch diameter).
This includes the S.I. versions of both of the liquid flow spreadsheet workbooks described below, one uses ISO 5167 equations for large bore pipes (50 mm to 1000 mm diameter) and the other uses ASME equations for small bore pipes (12 to 40 mm diameter).
This Excel spreadsheet package includes the U.S. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through large bore pipes (2 inch to 40 inch diameter). ISO 5167 - 1: 2003 equations are used for calculation of the orifice coefficient.
This Excel spreadsheet package includes the S.I. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through large bore pipes (50 mm to 1000 diameter). ISO 5167 - 1: 2003 equations are used for calculation of the orifice coefficient.
This Excel spreadsheet package includes the U.S. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through small bore pipes (1/2 to 1 1/2 inch diameter). ASME MFC-14M-2001 equations are used for calculation of the orifice coefficient.
This Excel spreadsheet package includes the S.I. versions of the gas flow and liquid flow spreadsheet workbooks as described below for flow through small bore pipes (12 to 40 mm diameter). ASME MFC-14M-2001 equations are used for calculation of the orifice coefficient.
This collection of Excel spreadsheet workbooks includes the U.S. version of all the orifice meter spreadsheets described in this section, including those for gas flow & liquid flow and for small bore & large bore pipes.
This collection of Excel spreadsheet workbooks includes the S.I. version of all the orifice meter spreadsheets described in this section, including those for gas flow & liquid flow and for small bore & large bore pipes.
This downloadable Excel spreadsheet package uses ISO 5167-2:2003 in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter. These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient and the expansion coefficient as part of the calculation. The pipe diameter may range from 2 inches to 40 inches. (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations). Calculations are made with U.S. units.
This downloadable Excel spreadsheet package uses ISO 5167-2:2003 in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter. These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient and the expansion coefficient as part of the calculation. The pipe diameter may range from 50 mm to 1000 mm. (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations). Calculations are made with S.I. units.
This downloadable Excel spreadsheet package uses ISO 5167-2:2003 equations in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter. These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient as part of the calculation. The pipe diameter may range from 2 inches to 40 inches. (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations). Calculations are made with U.S. units.
This downloadable Excel spreadsheet package uses ISO 5167-2:2003 equations in three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter. These three spreadsheets use ISO 5167-2:2003 to calculate the orifice coefficient as part of the calculation. The pipe diameter may range from 50 mm to 1000 mm. (The orifice meter must have one of the three standard ISO 5167 pressure tap configurations). Calculations are made with S.I. units.
This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter for small bore pipes. These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient and the expansion coefficient. The pipe diameter may range from 1/2 inches to 1 1/2 inches. (The orifice meter must have corner taps or flange taps). Calculations are made with U.S. units.
This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for gas flow through an orifice meter for small bore pipes. These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient and the expansion coefficient. The pipe diameter may range from 12 mm to 40 mm. (The orifice meter must have corner taps or flange taps). Calculations are made with S.I. units.
This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter for small bore pipes. These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient. The pipe diameter may range from 1/2 inches to 1 1/2 inches. (The orifice meter must have corner taps or flange taps). Calculations are made with U.S. units.
This downloadable Excel spreadsheet package contains three spreadsheets to calculate i) flow rate, ii) orifice diameter needed, or iii) pressure difference for liquid flow through an orifice meter for small bore pipes. These three spreadsheets use ASME MFC-14M-2001 equations to calculate the orifice coefficient. The pipe diameter may range from 12 mm to 40 mm. (The orifice meter must have corner taps or flange taps). Calculations are made with S.I. units.
This Excel spreadsheet will calculate the minimum required pipe wall thickness for specified fluid pressure, pipe O.D., yield strength of the pipe material, safety factor, and corrosion allowance. Also the maximum operating pressure and bursting pressure can be calculated for a specified pipe wall thickness. A table of O.D., wall thickness, and I.D. for schedule 10, schedule 40 and schedule 80 pipes is also included.These calculations use U.S. units.
This Excel spreadsheet package has Excel templates for calculation of i) orifice, flow nozzle or venturi flow rate, for measured pressure difference across the meter and known discharge coefficient, C; ii) density of a gas of known molecular weight, temperature, and pressure. Calculations are done with S.I. units.
The screenshot at the right shows part of the first spreadsheet in this package.
This Excel spreadsheet will calculate the minimum required pipe wall thickness for specified fluid pressure, pipe O.D., yield strength of the pipe material, safety factor, and corrosion allowance. Also the maximum operating pressure and bursting pressure can be calculated for a specified pipe wall thickness. A table of O.D., wall thickness, and I.D. for schedule 10, schedule 40 and schedule 80 pipes is also included.These calculations use S.I. units.
This bundle includes all of the spreadsheet workbooks in the Secondary Wastewater Treatment category: Activated Sludge Aeration Tank Calculations, Primary and Secondary Clarifier Design, Trickling Filter NRC Formula calculations, MBBR BOD Removal and Nitrification, MBR Process Design Calculatpons, SBR BOD Removal and Nitrification Design, Wastewater Treatment Lagoon Design, Oxidation Ditch Design Calculations and CMAS BOD Removal and Nitrification. All are in U.S. units. Descriptions of all these spreadsheets are given below.
This bundle includes all of the spreadsheet workbooks in the Secondary Wastewater Treatment category: Activated Sludge Aeration Tank Calculations, Primary and Secondary Clarifier Design, Trickling Filter NRC Formula calculations, MBBR BOD Removal and Nitrification, MBR Process Design Calculations, SBR BOD Removal and Nitrification Design, Wastewater Treatment Lagoon Design,Oxidation Ditch Design Calculations and CMAS BOD Removal and Nitrification. All are in S.I. units. Descriptions of all these spreadsheets are given below.
The Excel spreadsheet bundle includes all of the spreadsheet workbooks in the Nitrification and Denitrification WW Treatment category, MBBR Nitrification and Denitrification processes, MBR Process Design Calculations, Nitrification-Denitrification CMAS Design, Nitrification-Denitrification and EBPR CMAS Design, CMAS Tertiary Denitrification Design, and SBR Nitrification and Denitrification Design. Calculations are in U.S. units. Descriptions are given below.
The Excel spreadsheet bundle includes all of the spreadsheet workbooks in the Nitrification and Denitrification WW Treatment category, MBBR Nitrification and Denitrification processes, MBR Process Design Calculations, Nitrification-Denitrification CMAS Design, Nitrification-Denitrification CMAS-EBPR Design, CMAS Tertiary Denitrification Design, and SBR Nitrification and Denitrification Design. Calculations are in S.I. units. Descriptions are given below.
This Excel spreadsheet bundle includes all of the spreadsheets shown in the four Wastewater Treatment categories, Secondary Wastewater Treatment, Nitrification and Denitrification WW Treatment, MBBR MBR and SBR WW Treatment Spreadsheets, and Other Wastewater Treatment. These are worth over $300 if all of them were purchased individually. All calculations are in U.S. units. Descriptions of all of the spreadsheets are given in the listed four categories.
This Excel spreadsheet bundle includes all of the spreadsheets shown in the four Wastewater Treatment categories, Secondary Wastewater Treatment, Nitrification and Denitrification WW Treatment, MBBR MBR and SBR WW Treatment Spreadsheets, and Other Wastewater Treatment. These are worth over $300 if all of them were purchased individually. All calculations are in S.I. units. Descriptions of all of the spreadsheets are given in the listed four categories.
FREE DOWNLOAD! Try this Excel spreadsheet for calculating required activated sludge aeration tank volume based on user input wastewater flowrate, BOD concentration, and design value for hydraulic residence time. There is a worksheet for U.S. units and one for S.I. units.
These Excel spreadsheets will calculate the activated sludge aeration tank volume requirement, based on a specified volumetric loading, hydraulic retention time, or F:M ratio, and will calculate the other two design parameters for the calculated tank volume. Activated sludge operational calculations can be made also to find the required activated sludge wasting rate, activated sludge recycle rate, and an estimate of the resulting F:M ratio. There is also a worksheet to calculate the oxygen requirement and the blower ACFM, SCFM, & outlet pressure needed. Calculations use U.S. units.
These Excel spreadsheets will calculate the activated sludge aeration tank volume requirement, based on a specified volumetric loading, hydraulic retention time, or F:M ratio, and will calculate the other two design parameters for the calculated tank volume. Activated sludge operational calculations can be made also to find the required activated sludge wasting rate, activated sludge recycle rate, and an estimate of the resulting F:M ratio. There is also a worksheet to calculate oxygen requirement and blower air flow and outlet pressure requirements. Calculations use S.I. units.
This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. Similar calculations can be done for primary clarifiesrs. This spreadsheet uses U.S. units.
This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. Similar calculations can be made for primary clarifiers. This spreadsheet uses S.I. units.
This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. This spreadsheet uses U.S. units.
This Excel spreadsheet calculates the required secondary clarifier surface area based on specified values of surface overflow rate and solids loading rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. This spreadsheet uses S.I. units.
This Excel spreadsheet calculates the required primary clarifier surface area based on specified values of average and peak surface overflow rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. This spreadsheet uses U.S. units.
This Excel spreadsheet calculates the required primary clarifier surface area based on specified values of average and peak surface overflow rate. Based on a specified number of clarifiers the diameter of circular clarifiers is calculated. Based on the number of clarifiers and the length to width ratio, the length and width of rectangular clarifiers is calculated. Effluent weir calculations are included to ensure that the allowable weir overflow rate isn't surpassed. This spreadsheet uses S.I. units.
Convenient templates for calculating the standard compound-interest factors used in engineering economics and in finance: present value, future value, uniform series of payments, gradient series, and geometric series. This file has three tabs, one for discrete compounding, one for continuous compounding of discrete cash flows, and one for continuous compounding of continuous cash flows. Easier to use than a hand-held financial calculator and at a fraction of the cost.
This Excel spreadsheet package has Excel templates for calculation of i) orifice, flow nozzle or venturi flow rate, for measured pressure difference across the meter and known discharge coefficient, C; ii) density of a gas of known molecular weight, temperature, and pressure. Calculations are done with U.S. units.
This Excel spreadsheet template can be used to determine the Manning roughness coefficient for a natural channel based on a description of various aspects of the channel, such as its irregularity, cross section variations, the effect of obstructions, the effect of vegetation, and degree of meander. This spreadsheet is based on a method developed by W.L Cowan in 1956. Since the Manning roughness coefficient is dimensionless, the n value determined with this spreadsheet can be used for Manning equation calculations in either U.S. or S.I. units.
Spreadsheets for calculating the principal stresses, principal angle, maximum in-plane shear stress, and stresses acting on a plane inclined at an angle with respect to the coordinate axes, all for a state of plane stress. Faster, easier to use, and less prone to errors than using your calculator—with the spreadsheet you never have to re-enter your data and formulas to double-check your answer.
These Excel spreadsheets will calculate the hydraulic radius for a trapezoidal flume with unequal side slopes, that is with different side slopes on its two sides. There are also worksheets to calculate the flow rate and average velocity for specified Manning roughness coefficient, bottom slope, depth of flow, and side slopes, and to calculate normal depth for a specified flow rate. Calculations are in U.S. units.
These Excel spreadsheets will calculate the hydraulic radius for a trapezoidal flume with unequal side slopes, that is with different side slopes on its two sides. There are also worksheets to calculate the flow rate and average velocity for specified Manning roughness coefficient, bottom slope, depth of flow, and side slopes, and to calculate normal depth for a specified flow rate. Calculations are in S.I. units.
This MBBR calculations spreadsheet has four worksheets. One is for a single-stage BOD removal process, one is for two-stage BOD removal, one is for two-stage BOD removal/nitrification, and one is for single stage tertiary nitrification calculations. Each worksheet guides the calculation of tank volume and dimensions based on wastewater flow and characteristics, along with characteristics of the media (carrier) to be used. The worksheets also calculate detention time at design average flow and at peak hourly flow as well as estimated air requirements and alkalinity requirements for the nitrification processes.. The worksheet is set up for U.S. units.
This MBBR calculations spreadsheet has four worksheets. One is for a single-stage BOD removal process, one is for two-stage BOD removal, one is for two-stage BOD removal/nitrification, and one is for single stage tertiary nitrification calculations. Each worksheet guides the calculation of tank volume and dimensions based on wastewater flow and characteristics, along with characteristics of the media (carrier) to be used. The worksheets also calculate detention time at design average flow and at peak hourly flow as well as estimated air requirements and alkalinity requirements for the nitrification processes.. The worksheet is set up for S.I. units.
This Excel spreadsheet workbook includes a worksheet for a three-stage pre-anoxic denitrification MBBR process and one for a three-stage post-anoxic denitrification MBBR process. Each worksheet leads the user through calculation of the required carrier volume and tank volumes and dimensions. Aeration requirements for the BOD removal and nitrification stages is included as well as estimated alkalinity requirements. There is guidance on the choice between a pre-anoxic or post-anoxic process. The calculations use U.S. units.
This Excel spreadsheet workbook includes a worksheet for a three-stage pre-anoxic denitrification MBBR process and one for a three-stage post-anoxic denitrification MBBR process. Each worksheet leads the user through calculation of the required carrier volume and tank volumes and dimensions. Aeration requirements for the BOD removal and nitrification stages is included as well as estimated alkalinity requirements. There is guidance on the choice between a pre-anoxic or post-anoxic process. The calculations use S.I. units.
This Excel spreadsheet workbook has three worksheets to carry out basin sizing and aeration calculations for the membrane module(s), the aeration tank(s) and preanoxic denitrification tank(s). These calculations are based on the membrane module(s) being immersed in the aeration tank(s). There is also a worksheet for user input of wastewater flow and characteristics, and biological kinetic coefficients. The membrane module calculations require user input vaues of membrane module parameters that are typically available from the membrane module manufacturer or vendor. The aeration tank and preanoxic tank calculations use equations typically used for completely mixed activated sludge systems. Calculations are in U.S. units.
This Excel spreadsheet workbook has three worksheets to carry out basin sizing and aeration calculations for the membrane module(s), the aeration tank(s) and preanoxic denitrification tank(s). These calculations are based on the membrane module(s) being immersed in the aeration tank(s). There is also a worksheet for user input of wastewater flow and characteristics, and biological kinetic coefficients. The membrane module calculations require user input vaues of membrane module parameters that are typically available from the membrane module manufacturer or vendor. The aeration tank and preanoxic tank calculations use equations typically used for completely mixed activated sludge systems. Calculations are in S.I. units.
This spreadsheet makes calculations for sizing wastewater treatment lagoons, including anaerobic, facultative and maturation ponds. A worksheet is included to estimate evaporation rate. Calculations are done in U.S. units.
This spreadsheet makes calculations for sizing wastewater treatment lagoons, including anaerobic, facultative and maturation ponds. A worksheet is included to estimate evaporation rate. Calculations are done in S.I. units.
This Excel Spreadsheet makes a variety of trickling filter wastewater treatment calculations with the NRC formula. Included are calculation of required trickling filter diameter for a single stage system and calculation of the required trickling filter diameter for a two-stage system with both filters of the same diameter. There are also worksheets to calculate the estimated treatment efficiency for a single stage or for a two stage trickling filter system. These spreadsheets use U.S. units.
This Excel Spreadsheet makes a variety of trickling filter wastewater treatment calculations with the NRC formula. Included are calculation of required trickling filter diameter for a single stage system and calculation of the required trickling filter diameter for a two-stage system with both filters of the same diameter. There are also worksheets to calculate the estimated treatment efficiency for a single stage and for a two stage trickling filter system. These spreadsheets use S.I. units.
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, and 8-10 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014 This spreadsheet uses U.S. units.
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, and 8-10 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014 This spreadsheet uses S.I. units.
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, anaerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. U.S. units are used in this spreadsheet.
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, anaerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. S.I. units are used in this spreadsheet.
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system without a primary clarifier in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, aerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. U.S. units are used in this spreadsheet
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system without a primary clarifier in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, anaerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. S.I units are used in this spreadsheet
This Excel spreadsheet package includes a worksheet for calculating primary sludge and thickened waste activated sludge quantities, which will be the feed to the anaerobic digester. A second worksheet is used to calculate liquid volume needed for the anaerobic digested and to determine the side water depth and diameter for a specified number of tanks. Calculations are done in U.S. units
This Excel spreadsheet package includes a worksheet for calculating primary sludge and thickened waste activated sludge quantities, which will be the feed to the anaerobic digester. A second worksheet is used to calculate liquid volume needed for the anaerobic digested and to determine the side water depth and diameter for a specified number of tanks. Calculations are done in S.I. units
This fluid properties calculator spreadsheet bundle include all of the spreadsheet workbooks listed and described below.
This Excel spreadsheet workbook calculates the saturation dissolved oxygen concentration in water at user specifed water temperature and atmospheric pressure for water temperature ranging from 35 to 80 degrees F and atmospheric pressure from 600 to 760 mm Hg. Calculations are in U.S. units.
This Excel spreadsheet calculates the density of air at specified temperature and pressure using the ideal gas law, working in either U.S. units or S.I. units. It will also work for other gases of known molecular weight.
This Excel spreadsheet workbook calculates the saturation dissolved oxygen concentration in water at user specified water temperature and atmospheric pressure for water temperature from 0 to 40 degrees C and atmospheric pressure from 600 to 760 mm Hg. Calculations are in S.I. units.
These Excel spreadsheets will make dissolved oxygen sag equation calculations, including calculation of the reaeration rate constant, the deoxygenation rate constant, the critical DO and the downstream distance to the critical DO location, the dissolved oxygen concentration at a given distance downstream from a wastewater discharge point, and a plot of the DO sag curve. These calculations are all in S.I. units.
These Excel spreadsheets will make dissolved oxygen sag equation calculations, including calculation of the reaeration rate constant, the deoxygenation rate constant, the critical DO and the downstream distance to the critical DO location, the dissolved oxygen concentration at a given distance downstream from a wastewater discharge point, and a plot of the DO sag curve. These calculations are all in U.S. units.
This Excel spreadsheet workbook makes calculations for partially full pipe flow of a liquid of specified density and viscosity. It has worksheets to calculate, 1) liquid flow rate, 2) required diameter for a target depth/diameter ratio, 3) normal depth, 4) required pipe slope. These worksheet use the Darcy-Weisbach equation rather than the Manning equation for the calculations, thus allowing the calculations to be made for other liquids as well as for water. Calculations are in U.S. units.
This Excel spreadsheet workbook makes calculations for partially full pipe flow of a liquid of specified density and viscosity. It has worksheets to calculate, 1) liquid flow rate, 2) required diameter for a target depth/diameter ratio, 3) normal depth, 4) required pipe slope. These worksheet use the Darcy-Weisbach equation rather than the Manning equation for the calculations, thus allowing the calculations to be made for other liquids as well as for water. Calculations are in S.I. units.
An Excel workbook for calculating pipe diameters for partially full pipe flow in pipe sections for a system with multiple inlets (up to 30 inlets) along the pipeline using S.I. units
An Excel workbook for calculating pipe diameters for partially full pipe flow in pipe sections for a system with multiple inlets (up to 30 inlets) along the pipeline using U.S. units
These Excel spreadsheets will make calculations for water softening, using lime and caustic soda or just caustic soda, including dosages and daily requirements for lime (if used), caustic soda and carbon dioxide, as well as estimates of daily solids production. Such calculations are also available for lime soda softening with i) the two stage, excess lime process, ii) the single stage, selective calcium process, and iii) the split treatment process. Calculations are in U.S. units. NOTE: This workbook includes all of the worksheets in the Lime Soda Water Softening workbook described below, plus worksheets for softening with lime and caustic soda and for softening with only caustic soda.
These Excel spreadsheets will make calculations for water softening, using lime and caustic soda or just caustic soda, including dosages and daily requirements for lime (if used), caustic soda and carbon dioxide, as well as estimates of daily solids production. Such calculations are also available for lime soda softening with i) the two stage, excess lime process, ii) the single stage, selective calcium process, and iii) the split treatment process. Calculations are in S.I. units. NOTE: This workbook includes all of the worksheets in the Lime Soda Water Softening workbook described below, plus worksheets for softening with lime and caustic soda and for softening with only caustic soda.
A Sutro weir, also known as a proportional weir, produces flow over the weir that is proportional to the head over the weir. This spreadsheet carries out Sutro weir design calculations and calculates flow rate over a sutro weir for a specified sutro weir. Calculations are in U.S. units.
A Sutro weir, also known as a proportional weir, produces flow over the weir that is proportional to the head over the weir. This spreadsheet carries out Sutro weir design calculations and calculates flow rate over a sutro weir for a specified sutro weir. Calculations are in metric units.
These Excel spreadsheets will make calculations for lime soda water softening, including dosages and daily requirements for lime, soda ash and carbon dioxide, as well as estimates of daily solids production. Such calculations can be made for i) the two stage, excess lime process, ii) the single stage, selective calcium process, and iii) the split treatment process. Calculations are in U.S. units.
This Excel spreadsheet can be used for circular culvert design for either inlet control or outlet control situations. A specified maximum headwater depth can be used along with details about the culvert material and the site to calculate the required culvert diameter. This spreadsheet uses U.S. units.
This Excel spreadsheet can be used for circular culvert design for either inlet control or outlet control situations. A specified maximum headwater depth can be used along with details about the culvert material and the site to calculate the required culvert diameter. This spreadsheet uses S.I. units.
This Excel workbook will calculate the compressibility factor of a gas using the Redlich-Kwong equation of state, based on user input values for temperature and pressure of the gas and critical temperature and pressure of the gas. There is a worksheet for U.S. units and one for S.I. units.
This spreadsheet uses the Manning Equation to calculate the flow rate and velocity for a rectangular open channel with specified channel width, flow depth, channel slope and Manning roughness coefficient. Calculations use U.S. units
This spreadsheet uses the Manning Equation to calculate the flow rate and velocity for a rectangular open channel with specified channel width, flow depth, channel slope and Manning roughness coefficient. Calculations use S.I. units
This workbook has two tabs involving the allowable stress design of a simply supported beam carrying a uniformly distributed load. In the first tab, input consists of span length, elastic modulus, live load, dead load, allowable bending stress, deflection limit for live load, and deflection limit for live plus dead load (serviceability requirements). The workbook then calculates the maximum moment, maximum shear, elastic section modulus, and minimum moments of inertia required to satisfy the constraints on deflection. In the second tab, a check is made of a known design to see if strength and deflection requirements are met. Input is the same as in the first tab, with the addition of the elastic section modulus and moment of inertia. The workbook then determines whether the maximum moment, deflection under live load, and deflection under live plus dead load are less than the corresponding allowables. Both SI and US Customary units are allowed. All formulas are given, and the Excel code can be easily customized to meet specialized requirements of a particular user.
This Excel spreadsheet calculates the average atmospheric pressure at a specified elevation above sea level. The calculations may be in either U.S. units or S.I. units.
This Excel spreadsheet calculates air viscosity at a given temperature and pressure in either U.S. units or S.I. units.
This Excel spreadsheet will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a triangular channel. Calculations are in U.S. units.
This Excel spreadsheet will calculate the surface profile for any of the six possible non uniform flow configurations for flow on mild or steep slopes, in a triangularl channel. Calculations are in S.I units.
This excel spreadsheet calculates the required volume per aerated grit chamber tank as well as width, length and depth of the tank and the required air flow rate, based on user inputs for design average wastewater flow rate, the number of grit chambers, the design detention time at peak hourly flow, the tank depth, the length to width ratio, and the air flow needed per ft of tank length. A table showing typical values for the design parameters is provided. Also, there is a worksheet that may be used to estimate the peaking factor for the wastewater flow rate. The calculations are in U.S. units.
This excel spreadsheet calculates the required volume per aerated grit chamber tank as well as width, length and depth of the tank and the required air flow rate, based on user inputs for design average wastewater flow rate, the number of grit chambers, the design detention time at peak hourly flow, the tank depth, the length to width ratio, and the air flow needed per ft of tank length. A table showing typical values for the design parameters is provided. Also, there is a worksheet that may be used to estimate the peaking factor for the wastewater flow rate. The calculations are in S.I. units.
These Excel spreadsheets will make calculations for lime soda water softening, including dosages and daily requirements for lime, soda ash and carbon dioxide, as well as estimates of daily solids production. Such calculations can be made for i) the two stage, excess lime process, ii) the single stage, selective calcium process, and iii) the split treatment process. Calculations are in S.I. units.
This Excel spreadsheet calculates the viscosity of a gas at a specified gas temperture. User inputs required are the gas temperature, Sutherland's constant for the gas, and the viscosity of the gas at some specified reference temperature. A table with values for Sutherland's constant along with values for gas viscosity at one or more reference temperatures is provided for 25 gases. Calculations may be made in either S.I. or U.S. units.
This standalone program (not a spreadsheet) provides practice for learning the principles underlying shear and bending-moment diagrams. The program contains over 50 exercises, which have been chosen to represent all common boundary conditions and load cases. The program is highly interactive: starting 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 plots this point and specifies the type of curve connecting the two points. The user proceeds in a similar manner to plot the next point on fht diagram and connect it with the most recently plotted point. Continuing in this fashion, the user completes the shear diagram and then goes on to the moment diagram. Extensive Help screens are available which describe the theory and provide the answer for the current step when needed. A quiz facility is also provided for use of the program in a classroom setting.
Download and Installation: Note that this download is an exe program not an Excel spreadsheet. After you download the file, "VandM selfextract.exe," click on it and then on "Run." The program will unzip three files to a folder, which you should choose so that you can easily find it later. Your unzipped files should be: SETUP.LST, VandM.CAB, and setup.exe. Do not unzip VandM.CAB. Click on setup.exe and follow the instructions on the screen to install the program on your computer.
You may get a warning from your browser stating that the file is an exe file and asking if you want to continue. The file is safe and does not contain any viruses.
WinTri is a standalone computer program (not a spreadsheet) for the reduction of data arising from trilateration surveys; in particular, WinTri calculates the coordinates of stations. The program is general in that it will handle any 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.
WinTri 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.
In addition to the executable module that can be installed and run on the user's computer, the source code, consisting of about 5,000 statements in Visual Basic 6.0, is provided in case the user wants to customize the program to meet special needs.
Download and Installation: Note that this download is a standalone program not an Excel spreadsheet. After you download the file, "WinTri.zip," you need to unzip it to a folder which you should set up for this program. After unzipping the files, click on setup.exe and follow the instructions on the screen to install the program on your computer.
This Excel spreadsheet calculates and plots hydraulic grade line and energy grade line for up to 10 points along a storm sewer line, based on user input of values for invert elevation, upstream pipe slope, distance from previous point, pipe diameter, Manning roughness, design stormwater flow rate, and surface elevation. Calculations are in U.S. units
This Excel spreadsheet calculates and plots hydraulic grade line and energy grade line for up to 10 points along a storm sewer line, based on user input of values for invert elevation, upstream pipe slope, distance from previous point, pipe diameter, Manning roughness, design stormwater flow rate, and surface elevation. Calculations are in S.I. units
This partially full pipe flow calculator spreadsheet package contains worksheets to calculate 1) pipe flow rate, ii) normal depth, iii) required diameter for a target depth/diameter ratio, iv) required pipe slope, or v) Manning roughness coefficient, for partially full pipe flow, with calculations in U.S. units.
This partially full pipe flow calculator spreadsheet package has been newly updated to contain worksheets to calculate i) pipe flow rate, ii) normal depth, iii) required diameter for a target depth/diameter ratio, iv) required pipe slope, or v) Manning roughness coefficient, for partially full pipe flow, with calculations in S.I. units.
This is a custom spreadsheet to estimate the rate of natural gas leakage through a small slit in the pipe wall
This Excel spreadsheet calculates the density of a gas based on user input values for the gas temperature, gas pressure, molecular weight of the gas, critical temperature of the gas and critical pressure of the gas. The compressibility factor, Z, is calculated using the Redlich-Kwong equation and is used to calculate the gas density. There is a worksheet for U.S. units and one for S.I. units.
This Excel spreadsheet makes dissolved air flotation design calculations based on user input information about the flow being treated and design parameters. The spreadsheet includes calculation of the required air flow and the required DAF area based on either a design hydraulic loading rate or a design solids loading rate. The calculations are in U.S. units.
This Excel spreadsheet makes dissolved air flotation design calculations based on user input information about the flow being treated and design parameters. The spreadsheet includes calculation of the required air flow and the required DAF area based on either a design hydraulic loading rate or a design solids loading rate. The calculations are in S.I. units.
This Excel speadsheet makes design calculations for an Upflow Anaerobic Sludge Blanket (UASB) wastewater treatment reactor. Based on user input information about the wastewater to be treated, biological kinetic coefficients, methane stoichiometrry constants, and reactor configuration and design parameters, the spreadsheet calculate the required reactor volume and dimensions, the sludge production rate, the methane production rate and the required alkalinity addition. Calculations are in U.S. units.
This Excel speadsheet makes design calculations for an Upflow Anaerobic Sludge Blanket (UASB) wastewater treatment reactor. Based on user input information about the wastewater to be treated, biological kinetic coefficients, methane stoichiometrry constants, and reactor configuration and design parameters, the spreadsheet calculate the required reactor volume and dimensions, the sludge production rate, the methane production rate and the required alkalinity addition. Calculations are in S.I. units.
This spreadsheet is set up to make calculations for a design of a manifold/perforated lateral low pressure wastewater distribution system. There is one worksheet for an end manifold system and one for a center manifold system. Each of the worksheets calculates the flow rate per lateral and total flow rate for a user specified preliminary manifold/lateral layout, orifice spacing and target distal head pressure. The worksheets then calculate the minimum required lateral diameter and the minimum required manifold diameter. The user is guided in the selection of the dose volume and number of doses per day. Also the pump head and flow requirements and the pump chamber volume are calculated. This spreadsheet uses U.S. units.
This spreadsheet is set up to make calculations for a design of a manifold/perforated lateral low pressure wastewater distribution system. There is one worksheet for an end manifold system and one for a center manifold system. Each of the worksheets calculates the flow rate per lateral and total flow rate for a user specified preliminary manifold/lateral layout, orifice spacing and target distal head pressure. The worksheets then calculate the minimum required lateral diameter and the minimum required manifold diameter. The user is guided in the selection of the dose volume and number of doses per day. Also the pump head and flow requirements and the pump chamber volume are calculated. This spreadsheet uses S.I. units.
This Excel spreadsheet workbook generates a direct runoff hydrograph for a design storm based on user input information about the design storm and the watershed. There are three worksheets. The first is for setting the CN (curve number) value for the watershed. This can be done either as a single CN value for the watershed or as a calculated composite CN from user entered values of area and CN for up to 10 subareas in the watershed. The second worksheet calculates the total direct runoff from the design storm using the CN value from the first worksheet and a user input value for the total rainfall depth from the design storm. Values are obtained for AMC I, AMC II, and AMC III. The third worksheet generates the direct runoff hydrograph for the design storm, using the NRCS dimensionless unit hydrograph together with the calculated total direct runoff from the storm and user input values for watershed area and watershed time of concentration. Calculations are in U.S. units.
This Excel spreadsheet calculates the viscosity of a gas at a specified gas temperture. User inputs required are the gas temperature, Sutherland's constant for the gas, and the viscosity of the gas at some specified reference temperature. A table with values for Sutherland's constant, along with values for gas viscosity at one or more reference temperatures is provided for 25 gases. Calculations may be made in either U.S. or S.I. units.
This Excel spreadsheet package includes a worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for BOD removal and nitrification, The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in U.S. units.
This Excel spreadsheet package includes a worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for BOD removal and nitrification, The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in S.I. units.
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Example 8-3 from Metcalf & Eddy/Aecom, Wastewater Engineering Treatment and Resource Recovery,5th Ed, 2014 This spreadsheet uses U.S. units.
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Example 8-3 from Metcalf & Eddy/Aecom, Wastewater Engineering Treatment and Resource Recovery,5th Ed, 2014 This spreadsheet uses S.I. units.
This Excel spreadsheet workbook carries out the calculations for sizing a post-anoxic denitrification basin with methanol addition to treat a nitrified effluent from a seconday treatment process with methanol. Calculations are also included for anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Example 8-9 from Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Ed. This spreadsheet uses U.S. units.
This Excel spreadsheet bundle includes the U.S. versions of the MBBR BOD Removal and Nitrification, MBBR Nitrification-Denitrification, MBR Process Design Calculations, and SBR BOD Removal-Nitrification-Denitrification spreadsheet workbooks. Descriptions of all of these spreadsheets are given below.
This Excel spreadsheet bundle includes the S.I. versions of the MBBR BOD Removal and Nitrification, MBBR Nitrification-Denitrification, MBR Process Design Calculations, and SBR BOD Removal-Nitrification-Denitrification spreadsheet workbooks. Descriptions of all of these spreadsheets are given below.
This Excel spreadsheet workbook carries out the calculations for sizing a post-anoxic denitrification basin with methanol addition to treat a nitrified effluent from a seconday treatment process with methanol. Calculations are also included for anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Example 8-9 from Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Ed. This spreadsheet uses S.I. units.
This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification and ii) BOD removal, nitrification and denitrification. The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in U.S. units
This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification, ans ii) BOD removal, nitrification and denitrification. The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in S.I. units
This spreadsheet package includes the U.S. versions of both the MBBR BOD and Nitrification Calculatons and MBBR Nitrification-Denitrification Processes spreadsheets. Descriptions are given below.
This spreadsheet package includes the S.I. versions of both the MBBR BOD and Nitrification Calculatons and MBBR Nitrification-Denitrification Processes spreadsheets. Descriptions are given below.
This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification, and ii) BOD removal, nitrification and denitrification. The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in U.S. units
This Excel spreadsheet package includes worksheet to design a sequencing batch reactor (SBR) wastewater treatment system for i) BOD removal and nitrification, and ii) BOD removal, nitrification and denitrification. The calculations make use of biological kinetic models as described in Metcalf & Eddy's wastewater treatment textbooks. Typical values of the needed kinetic parameters for domestic wastewater are provided in a table in the spreadsheet. The spreadsheet calculates tank volume(s) and blower airflow and outlet pressure requirements based on user input of wastewater design flow and characteristics. It also checks on the adequacy of initial user estimates of the times for each part of the overall SBR cycle. Calculations are in S.I. units
This spreadsheet calculates the flow coefficient for an adjustable choke valve and also calculates the liquid flow rate through the valve for specified pressure difference and liquid specific gravity.
This Excel spreadsheet makes piping inspection calculations as described in API 570, API 574, and ASME B31.3. The calculations made in this spreadsheet workbook include pressure design wall thickness, required minimum wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP). Calculations are in U.S. units.
This Excel spreadsheet makes piping inspection calculations as described in API 570, API 574, and ASME B31.3. The calculations made in this spreadsheet workbook include pressure design wall thickness, required minimum wall thickness, long term corrosion rate, short term corrosion rate, remaining life, and maximum allowable working pressure (MAWP). Calculations are in S.I. units.
This worksheet makes calculations of oxygen/air/blower requirements for a biological wastewater treatment system based on user input information about wastewater and aeration system parameters, using U.S. Units
This worksheet makes oxygen/air/blower requirement calculations based on user input values for wastewater and aeration system parameters using S.I. units.
This is a custom spreadsheet for calculating EGL and HGL for a storm drain system with a series of catch basins.
Based on user input values for influent flow rate, plate angle, plate spacing, number of plates, length of plates, and design surface loading rate, this spreadsheet workseet calculates the area required for each plate, the plate width, and the module width, length and height. It also calculates the HRT between plates, the liquid velocity between plates and the Reynolds number for the flow between adjacent plates. This spreadsheet uses U.S. units.
Based on user input values for influent flow rate, plate angle, plate spacing, number of plates, length of plates, and design surface loading rate, this spreadsheet worksheet calculates the area required for each plate, the plate width, and the module width, length and height. It also calculates the HRT between plates, the liquid velocity between plates and the Reynolds number for the flow between adjacent plates. This spreadsheet uses S.I. units.
This is a custom spreadsheet prepared to make specific stage-storage calculations.
This is a custom spreadsheet for estimating the water evaporation rate from a sump.
A custom spreadsheet for soil storage calculations.
This spreadsheet calculates the minimum pipe bend wall thickness using ASME B31.3 equations, based on user input values for several required parameters. There is a worksheet for calculating the minimum wall thickness at the inside radius (intrados) and a worksheet for calculating the minimum wall thickness at the outside radius (extrados). The worksheets are set up to use S.I. units
This Excel Workbook is set up to calculate the capacity of a stormwater inlet based on input values for inlet dimensions and stormwater depth at the inlet. There is a worksheet to make the calculations for a curb inlet and a worksheet to make the calculations for a gutter (grate) inlet. Information is also provided in the workbook on how to handle the calculation of inlet capacity for a combination inlet. This spreadsheet is set up to use U.S. units.
This spreadsheet uses the Freundlich Isotherm equation to calculate the capacity of granular activated carbon for removal of a user specified organic compound from water. This spreadsheet is set up to use U.S. units.
This Excel spreadsheet for natural gas pipeline flow calculations will carry out several pipeline flow calculations for natural gas, including calculation of natural gas properties, such as compressibility factor, density and viscosity. It has worksheets to calculate 1) natural gas flow rate, 2) required pipeline diameter, 3) outlet pressure, or 4) inlet pressure using the General Flow Equation.
This spreadsheet uses the General Flow Equation to make pipeline flow calculations with the Hall Yarborough Correlation for calculating the compressibility factor and the CKB Correlation to calculate the Gas Viscosity. This spreadsheet is set up to use U.S. units.
This custom spreadsheet calculates minimum required pipe wall thickness based on user input information, and prepares a plot of pipe wall thickness with user input information on pipe wall thickness and time since the last measurement. The time to reach the minimum required pipe wall thickness is calculated from the input data and is shown on the graph. This spreadsheet is set up to use S.I. units
This Excel Spreadsheet calculates the head loss and pressure drop for liquid flow through a packed bed, based on user input values for the flow rate through the bed, bed dimensions, packing properties, and liquid density and viscosity. It also creates a plot of pressure drop vs flow rate through the bed for a series of user entered values for flow rate. The calculations are done using U.S. units
This Excel Spreadsheet calculates the head loss and pressure drop for liquid flow through a packed bed, based on user input values for the flow rate through the bed, bed dimensions, packing properties, and liquid density and viscosity. It also creates a plot of pressure drop vs flow rate through the bed for a series of user entered values for flow rate. The calculations are done using S.I. units
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Also included is a worksheet for making A2O EBPR (Enhanced Biological Phosphate Removal) design calculations. This is for the A2O process to go with a preanoxic denitrification CMAS process. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, 8-10 and 8-13 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014 This spreadsheet uses U.S. units.
This Excel spreadsheet workbook carries out the calculations for completely mixed aertion tank sizing for BOD removal and nitrification, for sizing of an accompanyingpre- anoxic basin for denitrification, and for sizing a post-anoxic denitrification basin with methanol addition. Also included is a worksheet for making A2O EBPR (Enhanced Biological Phosphate Removal) design calculations. This is for the A2O process to go with a preanoxic denitrification CMAS process. Calculations are also included for oxygen requirement, aeration system sizing, and anoxic mixing requirements. The calculations use biological kinetic coefficients and follow the steps in Examples 8-3, 8-7, 8-10 and 8-13 from Metcalf & Eddy/Aecom, Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., 2014 This spreadsheet uses S.I. units.
This spreadsheet makes process design calculations for an inclined tube settler based on user input information about the settler configuration and influent flow rate. The calculations use U.S. units
This spreadsheet makes process design calculations for an inclined tube settler based on user input information about the settler configuration and influent flow rate. The calculations use S.I. units
This spreadsheet calculates the head loss across bar screens, the head loss across fine screens, the estimated minimum, maximum, and average daily volume of screenings from a bar screen, and the estimated minimum, maximum, and typical daily volume of screenings from a fine screen. Calculations use U.S. units
This spreadsheet calculates the head loss across bar screens, the head loss across fine screens, the estimated minimum, maximum, and average daily volume of screenings from a bar screen, and the estimated minimum, maximum, and typical daily volume of screenings from a fine screen. Calculations use S.I. units
This spreadsheet calculates the minimum required wall thickness for a cylindrical pressure vessel, for a hemispherical head and for a ellipsoidal head using S.I. units. The calculations are based on requirements in ASME BPVC VIII-1-2015.
This spreadsheet carries out design calculations for a horizontal flow grit chamber, including calculation of the required length, width and depth of the grit chamber, based on user input values for design wastewater flowrate and several design parameters. There is a worksheet for calculation of the peaking factor based on the design average flow rate, and there is a worksheet for design of a Sutro weir for the effluent from the grit chamber. The calculations are done with U.S. units.
This spreadsheet carries out design calculations for a horizontal flow grit chamber, including calculation of the required length, width and depth of the grit chamber, based on user input values for design wastewater flowrate and several design parameters. There is a worksheet for calculation of the peaking factor based on the design average flow rate, and there is a worksheet for design of a Sutro weir for the effluent from the grit chamber. The calculations are done with S.I. units
This Excel workbook has a worksheet to make design calculations for MBBR BOD removal and Nitrification with CMAS post-anoxic denitrification. It also has a worksheet for pre-anoxic dentrification design calculations with the MBBR process for denitrification, BOD removal and Nitrification. This spreadsheets are set up to use S.I. units.
This Excel spreadsheet workbook uses 9 worksheets to make calculations for metal precipitation from wastewater. In the first worksheet there is provision for user entry of the wastewater flowrate and the concentration of each of seven metals (zinc, nickel, chrome, copper, cadmium, lead, and iron) in the wastewater. There is also provision for user entry of the design pH and a safety factor for the calculations, as well as selection between caustic or lime as the chemical to be used for the precipitation and specification of the concentration of the caustic or lime solution being used. Each of the worksheets 2 through 8 make calculations for one of the metals. Solubility vs pH data for each of the metals is used to generate an equation for the solubility of that metal as a function of pH. Then equilibrium values are calculated for the metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. Finally, the user-specified saftery factio is applied to get design values for metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. The last worksheet provides a summary of the calculated results for each of the seven metals. Calculations are made using U.S. units
This Excel spreadsheet workbook uses 9 worksheets to make calculations for metal precipitation from wastewater. In the first worksheet there is provision for user entry of the wastewater flowrate and the concentration of each of seven metals (zinc, nickel, chrome, copper, cadmium, lead, and iron) in the wastewater. There is also provision for user entry of the design pH and a safety factor for the calculations, as well as selection between caustic or lime as the chemical to be used for the precipitation and specification of the concentration of the caustic or lime solution being used. Each of the worksheets 2 through 8 make calculations for one of the metals. Solubility vs pH data for each of the metals is used to generate an equation for the solubility of that metal as a function of pH. Then equilibrium values are calculated for the metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. Finally, the user-specified saftery factio is applied to get design values for metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. The last worksheet provides a summary of the calculated results for each of the seven metals. Calculations are made using S.I. units
This Excel spreadsheet carries out design calculations for an oxidation ditch biological wastewater treatment system. The design calculations include calculation of the required oxidation ditch volume based on a user entered value for HRT, F:M, or volumetric loading, along with the design WW flowrate, influent BOD, oxidation ditch MLSS, and percent volatile. The spreadsheet also calculates the cross-sectional area and total length of the oxidation ditch for user entered liquid depth in channel, channel bottom width, and side slope, and it calculates the side length and end diameter for user entered ratio, L/D. Calculation are in U.S. units.
This Excel spreadsheet carries out design calculations for an oxidation ditch biological wastewater treatment system. The design calculations include calculation of the required oxidation ditch volume based on a user entered value for HRT, F:M, or volumetric loading, along with the design WW flowrate, influent BOD, oxidation ditch MLSS, and percent volatile. The spreadsheet also calculates the cross-sectional area and total length of the oxidation ditch for user entered liquid depth in channel, channel bottom width, and side slope, and it calculates the side length and end diameter for user entered ratio, L/D. Calculation are in S.I. units.
This Excel workbook is set up to make design calculations for a stormwater infiltration basin, with possible outflow from the basin also. This spreadsheet is set up to use S.I. units.
This Excel Workbook calculates outlet pressure for naural gas flow through each of 10 pipe sections in series. Calculations are made using U.S. units.
This custom spreadsheet uses the Talmage-Fitch approach with experimental batch settling data to calculate the cross-sectional area requirement for a gravity thickener. Calculations are in S.I. units
This cusom spreadsheet calculates the required volume for a flow equalization tank based on user input design values for hourly average incoming flow rate over a 24 hour period. Calculations are in S.I. units
This is a pdf version of the book, "Biological Wastewater Treatment Process Design Calculations", which includes information about Activated Sludge, MBBR, and MBR wastewater treatment processes and example calculations.
This is an update of a Solvent Tank Venting spreadsheet that includes estimation of the solvent discharge in the vapor leaving the tank. This spreadsheet is set up to use U.S. units
This spreadsheet makes calculations to use in selecting diameter and depth and number of soakwells. This spreadsheet is set up to use S.I. units.
This Excel spreadsheet calculates and plots hydraulic grade line and energy grade line for up to 11 points along a storm sewer or sanitary sewer line, based on user input of values for invert elevation, upstream pipe slope, distance from previous point, pipe diameter, Manning roughness, design stormwater flow rate, and surface elevation. If a section of sewer is flowing partially full, the calculations are made for partially full pipe flow. If a section of sewer is flowing full with the upstream manhole surcharged, then the calculations are made for full pipe flow. Calculations are in U.S. units.
This updated custom Excel spreadsheet carries out calculations for up to 10 lengths of storm sewer to calculate the EGL and HGL at each end of each section of storm sewer for full pipe flow in that section. A check is made to ensure that the HGL is greater than the pipe soffit elevation at the entrance to that pipe section to ensure that the pipe is flowing full. There is also a worksheet that prepares a plot of the invert elevation HGL, EGL, and surface elevation at each end of a user selected number of pipe sections to be plotted between 3 and 10 pipe sections. This spreadsheet is set up to use U.S. units.
This spreadsheet calculates the minimum required nozzle neck wall thickness for a nozzle connected to a pressurized cylindrical tank. The calculations are made according to the guidelines given in ASME BPVC.VIII. 1-2015. The spreadsheet is set up to make the calculations in S.I. units
A custom spreadsheet for Design Storm Hyetograph Generation
This Excel Spreadsheet calculates the flow rate over a broad-crested weir for either free flow or submerged flow for user specified values for weir length, weir height, weir coefficient, upstream depth of flow, and downstream depth of flow for the submerged flow calculation. Also the minimum required upstream head is calculated for free flow and for submerged flow. Calculations are in U.S. units
This Excel Spreadsheet calculates the flow rate over a broad-crested weir for either free flow or submerged flow for user specified values for weir length, weir height, weir coefficient, upstream depth of flow, and downstream depth of flow for the submerged flow calculation. Also the minimum required upstream head is calculated for free flow and for submerged flow. Calculations are in S.I. units
This custom spreadsheet calculates the dissolved oxygen solubility in fresh water for specified temperature and atmospheric pressure and calculates a salinity correction factor and dissolved oxygen solubility in salt water of specified salinity.
This spreadsheet calculates the the amount due for two loans, by month, based on daily interest compounding.
This is Water Treatment Spreadsheet Bundle, contains the S.I. version of all the spreadsheet listed in the Water Treatment Category,
This spreadsheet bundle contains the U.S. versions of all the spreadsheets in the Water Treatment category.
This is a custom spreadsheet for calculating the equilibrium concentration of ammonia in a room due to an ammonia leak into the room with air flow from the room.
This custom spreadsheet makes calculation of stormwater infiltration and storage for swales, using S.I. units.
This is a custom spreadsheet for calculating the required orifice diameter for a fire suppression system.
The worksheets in this Excel workbook calculate the head loss and pressure drop for flow of a gas through an annulus, or a rectangular duct, or through a general non-circular duct. There is an initial worksheet for selecting a gas and determinig its properties that are needed for the calculations. There are worksheets for calculating the flow rate or pressure drop through a rectangular duct, through an annuls, and through a general non-circular duct. For the annuls or rectangular duct calculations, the flow may be either laminar or turbulent, but for the general non-circular duct calculations turbulent flow is required. For each duct flow calculation, the choked flow conditions, which give the maximum flow rate of that gas through the duct, are calculated. This spreadsheet is set up to use U.S. units.
The worksheets in this Excel workbook calculate the head loss and pressure drop for flow of a gas through an annulus, or a rectangular duct, or through a general non-circular duct. There is an initial worksheet for selecting a gas and determinig its properties that are needed for the calculations. There are worksheets for calculating the flow rate or pressure drop through a rectangular duct, through an annuls, and through a general non-circular duct. For the annuls or rectangular duct calculations, the flow may be either laminar or turbulent, but for the general non-circular duct calculations turbulent flow is required. For each duct flow calculation, the choked flow conditions, which give the maximum flow rate of that gas through the duct, are calculated. This spreadsheet is set up to use S.I. units.