Laserfiche WebLink
<br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br />I <br /> <br />001951 <br /> <br />Appendix A - Program Calculations <br /> <br />Some R2CROSS users may be <br />interested in the operation and layout of the <br />Lotus 1-2-3 macro, Figure L depicts the <br />sequence of operations performed within each <br />R2CROSS menu option. Figure M provides the <br />layout of the R2CROSS macro within the Lotus <br />I -2-3 worksheet. The four major computations <br />performed within the R2CROSS macro are sag- <br />tape corrections, estimation of Manning's "n", <br />calculation of a water line comparison table, <br />and calculation of a staging table. <br /> <br />Sal1- Tl\Pe Calculations, <br />Channel geometry measurements that <br />are taken using the sag-tape methodology must <br />be corrected to a level reference. R2CROSS <br />uses catenary curve formulas to compute these <br />corrections from a sagging tape that has been <br />leveled at each end, The use of the catenary <br />curve solution is based on the assumption that <br />the suspended, steel tape is analogous to, a' <br />suspended cable placed under a unidirectionaIly <br />distributed load (Laursen 1978), <br />The derivation of the catenary curve <br />solution is beyond the scope of this manuscript. <br />Basically, R2CROSS uses the length of tape in <br />suspension, the tension applied to the tape, and <br />the standard weight of one foot of tape to apply <br />the necessary vertical distance corrections to <br />each cell vertical within the cross section. <br />When using a level and stadia rod to <br />survey channel geometry, the tape weight and <br />tension defaults, supplied in the original <br />R2CROSS,WK4 worksheet, will simulate an <br /> <br />extremely light tape stretched at very high <br />tension. This results in a sag correction of <br />approximately zero at each cell vertical, <br /> <br />Use of Manninl1's EQJIation, <br />Manning's equation is defined as: <br /> <br />Q - 1.486*A*R2I3*SI/2 <br />n <br />where; <br />Q = discharge (cfs); <br />A = cross-sectional area (fe); <br />R = hydraulic radius (ft); <br />S = slope (ftIft); and <br />n = Manning's "n", a dimensionless <br />coefficient of roughness. <br /> <br />Manning's equation is used in two <br />separate R2CROSS calculations, It is fust used <br />within the "Verify" option to provide an initial <br />estimate of Manning's "n" using the rearranged <br />equation: <br />n = 1.486* A *R 213* S 1/2 <br />Q <br />The parameters Q, A, R, and S are I <br />calculated from the raw field data and used to <br />solve directly for "n" (Figures G and J). Once <br />estimated, Manning's "n" remains constant <br />throughout the remainder of the streamflow <br />modeling. <br />Manning's equation is also used within <br />the "Calculate" option to solve for Q at each <br />simulated water surface elevation within the <br />staging table (Table 4). <br /> <br />-30- <br />