Horizontal Flow Grit Chamber Spreadsheet

Where to Find a Horizontal Flow Grit Chamber Spreadsheet

To obtain a spreadsheet for Horizontal Flow Grit Chamber Design, click here to visit our spreadsheet store.  This Excel spreadsheet has worksheets for calculating the peaking factor and for calculating the required dimensions for the horizontal flow grit chamber based on user input values for several parameters . There is also a worksheet for design of the exit sutro weir to control the horizontal velocity in the grit chamber. You can buy a convenient horizontal flow grit chamber spreadsheet for a very reasonable price.  It is available in either U.S. units or S.I. units.  Read on for background information about a Horizontal Flow Grit Chamber Design spreadsheet.

Background for a Horizontal Flow Grit Chamber Design Spreadsheet

The size and dimensions of a horizontal flow grit chamber are typically based on the detention time and horizontal velocity. Table 1, shown below, gives typical values for the design parameters, detention time and horizontal velocity, as well as typical added length for .the inlet and outlet.

Table 1. Typical Values for Design Parameters for Horizontal flow Grit Chamber

Exit Sutro Weir Design

A sutro weir is typically used as the exit from a horizontal flow grit chamber, because it maintains a constant horizontal velocity through the grit chamber. The diagram below shows the shape of a sutro weir, as plotted for an example horizontal flow grit chamber.

Sutro Weir pattern from spreadsheet

Example Horizontal Flow Grit Chamber Spreadsheet

An example Horizontal Flow Grit Chamber Design spreadsheet is partially shown in the image below.  .  This Excel spreadsheet can be used to calculate the required tank volume, tank length and tank depth, .based on user input values for wastewater flow rate, design horizontal velocity, detention time, and tank width..  This Excel spreadsheet, as well as others for water and wastewater treatment calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.n

Horizontal Flow Grit Chamber Spreadsheet Screenshot

References:

1. Metcalf & Eddy, Inc, (Revised by Tchobanoglous, G, Burton, F.L, Stensel, H.D.), Wastewater Engineering, Treatment and Resource Recovery, 5th Ed., New York, NY, 2014.

2. Bengtson, Harlan H.,  “Horizontal Flow Grit Chamber Design Calculations,” an online blog article.

Proportional Sutro Weir Design Calculation Excel Spreadsheet

Where to get a Proportional Sutro Weir Design Calculation Excel Spreadsheet

For a proportional sutro weir design calculation Excel spreadsheet in either U.S. or S.I. units, click here to visit our spreadsheet store.  Obtain convenient, easy to use spreadsheets for proportional sutro weir design calculations at reasonable prices. Read on for information about the use of a proportional sutro weir design calculation Excel spreadsheet.

Principles of a Proportional Sutro Weir Design Calculation Excel Spreadsheet

For the commonly used rectangular weir or V-notch weir, the flow rate over the weir Diagram for proportional sutro weir design calculation excel spreadsheetincreases as the head over the weir increases, but the flow rate increases at a faster rate than the head over the weir.  For some applications, it is desirable for the flow rate over a weir to be proportional to the head over the weir.  The sutro weir, also known as a proportional weir accomplishes this by having the width of the opening above the weir crest decrease with increasing head over the weir crest as shown in the diagram of a sutro weir at the right.  Equations that can be used for proportional sutro weir design are discussed in the next section.

Equations for Proportional Sutro Weir Design Calculation Excel Spreadsheet

Equations for the base width and base height of a sutro weir are as follows:

base height equation for proportional sutro weir design calculation Excel spreadsheet

base width equation for proportional sutro weir design calculation Excel spreadsheet

  • Wb  =  base width in ft (m for S.I. units)
  • Hb  =  base height in ft (m for S.I. units)
  • Hc  =  max height or curved portion of weir in ft (m for S.I. units)
  • Qmax  =  design maximum flow over the weir in cfs (m3/s for S.I. units)
  • Qmin  =  design minimum flow over the weir in cfs (m3/s for S.I. units)
  • g = acceleration of gravity = 32.17 ft/s/s (9.81 m/s/s for S.I. units)

The equation for the curved portion of a proportional sutro weir is:

Curve Equation for proportional sutro weir design calculation Excel spreadsheet

X and Z are position parameters as shown in the diagram above.  They will have the same units as Wb .

A Screenshot for a Proportional Sutro Weir Design Calculation Excel Spreadsheet

For a proportional sutro weir design calculation Excel spreadsheet with calculations in S.I. or U.S. units, or for other spreadsheets for open channel flow measurement calculations, see: www.engineeringexceltemplates.com

The Excel spreadsheet screenshot below shows part of a spreadsheet for proportional sutro weir design calculations, available  at our spreadsheet store in either U.S. or S.I. units at a very reasonable price.

 Screenshot of Proportional Sutro Weir Design Calculation Excel Spreadsheet

Reference

1, U.S. DOT, Fed Highway Admin, Urban Design Manual, Circular No. 22, 2nd Ed. 2001  (Publ. No. FHWA-NHI-010021-HEC-22)

2. Bengtson, Harlan H., Proportional Weir Design Equations,” an online blog article