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:
- Reference Reach Spreadsheet for reducing channel survey data and calculating basic bankfull hydraulic characteristics,
- Regime Equations for determining the dimensions of typical channel form,
- Meander Pattern that dimensions a simple arc and line best fit of the sine-generated curve,
- Cross-section and Profile that can be used to illustrate the difference between existing and proposed channel form,
- Sediment Equations which includes expanded and condensed forms of critical dimensionless shear, boundary roughness and common bed load equations, and finally
- 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)
Reference Reach Spreadsheet v4.2 Level
Reference Reach Spreadsheet v4.2 Total Station
Regime Equations v4.0
Meander Pattern v4.1
Two-Stage X-Sections Plots v4.0
Channel Process (in Microsoft Excel format)
Sediment Equations v4.0
Contrasting Channels v4.0
Calculation Discussion Background (in Microsoft Word format)
Calculating D50
Calculating Cross Section Width and Area
Develop a Total Station Cross Section Line
Guides and References
RPaper-Rosgen.PDF(Acrobat Reader format)
Stream Channel Reference Sites: An Illustrated Guide to Field Technique
|