Channel Assessment & Design

Spreadsheet Tools for River Evaluation, Assessment, and Monitoring (STREAM) Modules

Stream physical condition is increasingly a priority for resource managers. Assessment, monitoring and restoration techniques continue to be developed and standardized. Toward these ends a suite of spreadsheet tools, the STREAM Modules, has been developed by the Ohio Department of Natural Resources and Ohio State University. The modules, developed to assess and educate users on both channel form and channel function, can do the following actions:

  1. Reducing channel survey data and calculating basic bankfull hydraulic characteristics.
  2. Determining the dimensions of typical channel form and the equilibrium state of channel systems including meander pattern.
  3. Illustrating the difference between existing and proposed channel form.
  4. Calculating, via expanded and condensed forms, critical dimensionless shear, boundary roughness and common bed load equations.
  5. Computing hydraulic and bed load characteristics in a side-by-side comparison of two channels of different user-defined forms.

Channel Form

·   Meander Pattern 4-1 [xls 146Kb]

·   Reference Reach Survey 4-2 T [xls 2.3Mb]

·   Reference Reach Survey 4-3 L [xls 2.7Mb]

·   Regime Equations 4-0 [xls 78Kb]

Channel Process

·   Contrasting Channels 4-0 [xls 1.7Mb]

·   Dynamic Equilibrium Balance with Exercises [xls 476Kb]

·   Dynamic Equilibrium Balance [xls 448Kb]

·   Effective Discharge from Suspended Sediment [xls 18.8Mb]

·   Floodplain Hydraulics and Watershed Development [xls 931Kb]

·   Sediment Equations 4-0 [xls 61Kb]

More Information

·   ASAE STREAM Modules paper [doc 202Kb]

·   Example of Reference Reach Survey 4-0 T [xls 2.3Mb]

·   STREAM Modules Overview [doc 29Kb]

·   USFS RM-245 Guide to field technique [pdf 5.3Mb]

Appendix - Calculation Descriptions

·   Calculating Cross Section width and area [doc 21Kb]

·   Calculating D50 [doc 22Kb]

·   Develop a Total Station cross section line [doc 20Kb]