This is a custom spreadsheet to estimate the rate of natural gas leakage through a small slit in the pipe wall
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 is a custom spreadsheet for calculating EGL and HGL for a storm drain system with a series of catch basins.
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 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 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 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 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 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 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.