Stream Morphology

STREAM Modules
Spreadsheet Tools for River Evaluation, Assessment and Monitoring

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.

This ongoing project began in 1998 and currently freely provides the following modules:

1. Reference Reach Spreadsheet for reducing channel survey data and calculating basic bankfull hydraulic characteristics,
2. Regime Equations for determining the dimensions of typical channel form,
3. Meander Pattern that dimensions a simple arc and line best fit of the sine-generated curve,
4. Cross-section and Profile that can be used to illustrate the difference between existing and proposed channel form,
5. Sediment Equations which includes expanded and condensed forms of critical dimensionless shear, boundary roughness and common bed load equations, and finally
6. Contrasting Channels that computes hydraulic and bed load characteristics in a side-by-side comparison of two channels of different user defined forms.

Channel Form (in Microsoft Excel format)

Meander Pattern 4-1.xls

Reference Reach Survey 4-2 T.xls

Reference Reach Survey 4-3 L.xls

Regime Equations 4-0.xls

Two-Stage X-Section Plots 4-0.xls

Channel Process (in Microsoft Excel format)

Contrasting Channels 4-0.xls

Dynamic Equilibrium Balance with Exercises.xls

Dynamic Equilibrium Balance.xls

Miscellaneous (english units only)

         Effective Discharge from Suspended Sediment.xls

         Floodplain Hydraulics and Watershed Development.xls

Sediment Equations 4-0.xls

 

Information

Appendix - Calculation Description

         Calculating Cross Section width and area.doc

         Calculating D50.doc

         Develop a Total Station cross section line.doc

ASAE STREAM Modules paper.doc

Example of Reference Reach Survey 4-0 T.xls

STREAM Modules Overview.doc

USFS RM-245 Guide to field technique.pdf