Command Buttons
Data Input
File Version:
Constant Manning's n
This Microsoft Excel program was written by the Water
Rights Investigations Section of the Colorado Water
Conservation Board. R2CROSS is used by the CWCB
the development of instream flow recommendations fo
Plots the State's Instream Flow Program. The macro uses
Manning's equation to estimate several hydraulic
parameters at unobserved streamflows. The CWCB st
Cross Section believes that the macro calculations are accurate
representations of Manning's equation. However, the
CWCB assumes no liability for any damages arising
Wetted Perimeter / Q from the use of or the inability to use this program
Print Preview For All Print Requests
Print Preview XL portion by
TRUE Mike@XLhelp.com
Colorado Water Conservation Board's
R2CROSS
Excel for Windows
File Version: February 12, 2002
This Microsoft Excel program was written by the Water
Rights Investigations Section of the Colorado Water
Conservation Board. R2CROSS is used by the CWCB in
the development of instream flow recommendations for
the State's Instream Flow Program. The macro uses
Manning's equation to estimate several hydraulic
parameters at unobserved streamflows. The CWCB staff
believes that the macro calculations are accurate
representations of Manning's equation. However, the
CWCB assumes no liability for any damages arising
from the use of or the inability to use this program
FEATUR VERT WATER Tape to
Data Input & Proofing GL=1 E DIST DEPTH DEPTH VEL A Q Water
2 Grasslines not entered! Total Data Points = 0 Sag Tape
STREAM NAME: 0.00 0.00 0.00 Level and Rod Survey
XS LOCATION: 2
XS NUMBER:
DATE: PrevNoDataPoints
OBSERVERS:
1/4 SEC:
SECTION:
TWP:
RANGE:
PM:
COUNTY:
WATERSHED:
DIVISION:
DOW CODE:
USGS MAP:
USFS MAP:
Level and Rod Survey
TAPE WT: 0.0106 lbs / ft
TENSION: 99999 lbs
SLOPE: ft / ft
CHECKED BY:..........…………………......DATE…………......
ASSIGNED TO: .......………………….......DATE…………......
FEATUR VERT WATER Tape to
Data Input & Proofing GL=1 E DIST DEPTH DEPTH VEL A Q Water
FEATUR VERT WATER Tape to
Data Input & Proofing GL=1 E DIST DEPTH DEPTH VEL A Q Water
FEATUR VERT WATER Tape to
Data Input & Proofing GL=1 E DIST DEPTH DEPTH VEL A Q Water
FEATUR VERT WATER Tape to
Data Input & Proofing GL=1 E DIST DEPTH DEPTH VEL A Q Water
Totals 0.00 0.00
COLORADO WATER CONSERVATION BOARD
INSTREAM FLOW / NATURAL LAKE LEVEL PROGRAM
STREAM CROSS-SECTION AND FLOW ANALYSIS
LOCATION INFORMATION
STREAM NAME: 0
XS LOCATION: 0
XS NUMBER: 0
DATE: 0-Jan-00
OBSERVERS: 0
1/4 SEC: 0
SECTION: 0
TWP: 0
RANGE: 0
PM: 0
COUNTY: 0
WATERSHED: 0
DIVISION: 0
DOW CODE: 0
USGS MAP: 0
USFS MAP: 0
SUPPLEMENTAL DATA *** NOTE ***
Leave TAPE WT and TENSION
at defaults for data collected
TAPE WT: 0.0106 with a survey level and rod
TENSION: 99999
CHANNEL PROFILE DATA
SLOPE: 0
CHECKED BY:..................DATE........
SAG PARAMETERS ASSIGNED TO: ................DATE........
INPUT DATA CHECKED BY: ......................................DATE.................... a ########
sag 1.000
ASSIGNED TO: …..............….…….............................DATE.................... b 6.850
STREAM NAME: 0 cen ########
XS LOCATION: 0 0 ="WATERLINE" USED FOR CALCS IN cos 1.000
XS NUMBER: 0 MINERROR AND STAGING TABLE max cor 0.000
# DATA POINTS= 0 VALUES COMPUTED FROM RAW FIELD DATA SAG CORRECTED CALCS FOR MINERROR AND STAGING TABLE Waterline Calculations VALUES USED BY GRAPH
CORRECTED
FEATURE VERT WATER WETTED WATER AREA Q %Q AREA Q WETTED TOP WATER TOTAL Sag Corr. Plane to Sag Corr. MINUS WATER FEATURE WATER GRASS AREA LEFT LEFT LEFT LEFT LEFT AREA RIGHT RIGHT RIGHT RIGHT RIGHT
DIST DEPTH DEPTH VEL PERIM. DEPTH (Am) (Qm) CELL (Ac) (Qc) PERIM. WIDTH DEPTH VERT DIST MINERROR Left Bank Water Right Bank SAG LINE PLOT LEVEL LINE LEFT HORIZ VERT INTERCEPTSQUARE TRIANGLE RIGHT HORIZ VERT INTERCEPT SQUARE TRIANGLE
S 0.00 1.00 0.00 0.00 0.00 #DIV/0! 0.27 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 -1.00 -1.00 -0.85 #N/A 0.00 0.27 0.25 0.18 1.18 0.25 0.02
1 G 0.50 1.35 0.00 0.00 0.00 #DIV/0! 0.32 0.00 2.35 1.93 1.35 1.35 0.00 0.00 0.00 -1.35 -1.35 -1.20 #N/A 1.35 0.32 0.25 0.18 1.18 0.29 0.02 0.00 1.35 0.00 0.00
13.00 1.50
1 S,G 13.70 1.30 0.00 0.00 0.00 #DIV/0! 0.34 0.00 1.48 0.70 1.30 1.30 0.00 0.00 0.00 -1.30 -1.30 -1.15 #N/A 1.30 0.34 0.35 0.65 0.65 0.23 0.11 0.00
TOTALS ---------------------- 0.00 0 0.00 0.00 #DIV/0! 0.93 0.00 3.83 2.63 1.35 1.35 #DIV/0! 0.00 0.00 1.35
(Max.) (Max.) (Max.)
Avg Waterline (WLm) = 0.0000
Manning's n = #DIV/0! Calc_r= 0.242455
Hydraulic Radius= #DIV/0!
Average Velocity= #DIV/0!
Calc_A_at_wl= Calc_WP_at_wl=
Calc TW_at wl= Calc_q_at_wl Max_D at_wl
STREAM NAME: 0 0.928750087 2.62857 3.830603 0 1.35
XS LOCATION: 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
XS NUMBER: 0
Calc_r_at_wl= #DIV/0!
WATER LINE COMPARISON TABLE Calc_d_at wl= #DIV/0!
Calc_v_at wl= #DIV/0!
WATER MEAS COMP AREA MINIMUM Calc_n_at_wl= #DIV/0!
LINE AREA AREA ERROR AREA ERROR
0.00 0.93 #DIV/0!
-0.25 0.00 1.14 #DIV/0! -0.25 -0.25
-0.23 0.00 1.12 #DIV/0! #DIV/0! -0.23
-0.21 0.00 1.11 #DIV/0! #DIV/0! -0.21
-0.19 0.00 1.09 #DIV/0! #DIV/0! -0.19
-0.17 0.00 1.07 #DIV/0! #DIV/0! -0.17
-0.15 0.00 1.06 #DIV/0! #DIV/0! -0.15
-0.13 0.00 1.04 #DIV/0! #DIV/0! -0.13
-0.11 0.00 1.02 #DIV/0! #DIV/0! -0.11
-0.09 0.00 1.01 #DIV/0! #DIV/0! -0.09
-0.07 0.00 0.99 #DIV/0! #DIV/0! -0.07
-0.05 0.00 0.97 #DIV/0! #DIV/0! -0.05
-0.04 0.00 0.96 #DIV/0! #DIV/0! -0.04
-0.03 0.00 0.95 #DIV/0! #DIV/0! -0.03
-0.02 0.00 0.95 #DIV/0! #DIV/0! -0.02
-0.01 0.00 0.94 #DIV/0! #DIV/0! -0.01
0.00 0.00 0.93 #DIV/0! #DIV/0! 0
0.01 0.00 0.92 #DIV/0! #DIV/0! 0.01
0.02 0.00 0.91 #DIV/0! #DIV/0! 0.02
0.03 0.00 0.90 #DIV/0! #DIV/0! 0.03
0.04 0.00 0.89 #DIV/0! #DIV/0! 0.04
0.05 0.00 0.89 #DIV/0! #DIV/0! 0.05
0.07 0.00 0.87 #DIV/0! #DIV/0! 0.07
0.09 0.00 0.85 #DIV/0! #DIV/0! 0.09
0.11 0.00 0.84 #DIV/0! #DIV/0! 0.11
0.13 0.00 0.82 #DIV/0! #DIV/0! 0.13
0.15 0.00 0.80 #DIV/0! #DIV/0! 0.15
0.17 0.00 0.78 #DIV/0! #DIV/0! 0.17
0.19 0.00 0.77 #DIV/0! #DIV/0! 0.19
0.21 0.00 0.75 #DIV/0! #DIV/0! 0.21
0.23 0.00 0.73 #DIV/0! #DIV/0! 0.23
0.25 0.00 0.72 #DIV/0! #DIV/0! 0.25
=========
WATERLINE AT ZERO #DIV/0! Inter for min error
AREA ERROR = #DIV/0!
STREAM NAME: 0
XS LOCATION: 0
XS NUMBER: 0
SUMMARY SHEET
MEASURED FLOW (Qm)= 0.00 cfs RECOMMENDED INSTREAM FLOW:
CALCULATED FLOW (Qc)= #DIV/0! cfs =============================
(Qm-Qc)/Qm * 100 = #DIV/0! %
FLOW (CFS) PERIOD
MEASURED WATERLINE (WLm)= 0.00 ft =========== ========
CALCULATED WATERLINE (WLc)= #DIV/0! ft
(WLm-WLc)/WLm * 100 = #DIV/0! % _____________________ ____________________
MAX MEASURED DEPTH (Dm)= 0.00 ft _____________________ ____________________
MAX CALCULATED DEPTH (Dc)= #DIV/0! ft
(Dm-Dc)/Dm * 100 #DIV/0! % _____________________ ____________________
MEAN VELOCITY= #DIV/0! ft/sec _____________________ ____________________
MANNING'S N= #DIV/0!
SLOPE= 0 ft/ft
.4 * Qm = 0.0 cfs
2.5 * Qm= 0.0 cfs
RATIONALE FOR RECOMMENDATION:
=============================
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________
RECOMMENDATION BY: .………………...………..……............................... AGENCY..……………………......……....…....……....... DATE:.......…...…......……………
CWCB REVIEW BY: ..…………………………....…………………………………………………...........................................….............. DATE:..................……………...…
---- ---------------- ---------------- ---------------- ------------------------------------------------------------------------ STREAM NAME: 0
THIS AREA RESERVED FOR STAGING TABLE >>>>>>>>>>>>>>> | XS LOCATION: 0
XS NUMBER: 0 Constant Manning's n
*GL* = lowest Grassline elevation corrected for sag
STAGING TABLE *WL* = Waterline corrected for variations in field measured water surface elevations and sag
DIST TO TOP AVG. MAX. WETTED PERCENT HYDR AVG.
WATER WIDTH DEPTH DEPTH AREA PERIM. WET PERIM RADIUS FLOW VELOCITY
(FT) (FT) (FT) (FT) (SQ FT) (FT) (%) (FT) (CFS) (FT/SEC)
THIS AREA RESERVED FOR STAGING TABLE >>>>>>>>>>>>>>> | *GL* 1.35 0.00 #DIV/0! 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.65
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.6
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.55
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.5
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.45
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.4
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.35
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.3
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.25
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.2
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.15
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.1
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.05
*WL* #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.05
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.1
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.15
THIS AREA RESERVED FOR STAGING TABLE >>>>>>>>>>>>>>> | #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.2
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.25
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.3
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.35
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.4
THIS AREA RESERVED FOR STAGING TABLE >>>>>>>>>>>>>>> | #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.45
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.5
THIS AREA RESERVED FOR STAGING TABLE >>>>>>>>>>>>>>> |
---- ---------------- ---------------- ---------------- ------------------------------------------------------------------------
delete
Good Copy of equations for use when deleting extra rows
WETTED WATER AREA Q %Q AREA Q WETTED TOP WATER TOTAL Sag Corr. Plane to Sag Corr. MINUS WATER FEATURE WATER GRASS AREA LEFT LEFT LEFT LEFT LEFT AREA RIGHT RIGHT RIGHT RIGHT RIGHT
PERIM. DEPTH (Am) (Qm) CELL (Ac) (Qc) PERIM. WIDTH DEPTH VERT DIST MINERROR Left Bank Water Right Bank SAG LINE PLOT LEVEL LINE LEFT HORIZ VERT INTERCEPTSQUARE TRIANGLE RIGHT HORIZ VERT INTERCEPT SQUARE TRIANGLE
========= ========= ========= ========= ========= ======== =================== ======== ======== ========== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== ======== === ======== ========== ========== ========== ========== ========== ========== ========== ==========
0.00 0.00 0.00 #DIV/0! 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.15 #N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 #DIV/0! 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.15 #N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 #DIV/0! 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.15 #N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Changes made to original equations
0 0.00
0
Range Name Cell Description
========= ========= ========= ========= 0
AREALEFT AG55 Area to left of cell vertical
AREARIGHT AN55 Area to right of cell vertical
CALC_A N61 Calculated area (sag corrected)
CALC_D R61 Calculated depth (sag corrected)
CALC_Q O61 Calculated Q (sag corrected)
CALC_TW Q61 Calculated top width (sag corrected)
CALC_WP P61 Calculated WP (sag corrected)
COPY F308 Number of cell formulae to copy
CORR_LB W61 Sag corrected left bank vertical
CORR_RB Y61 Sag corrected right bank vertical
COUNTY D23 Informational
DATA_EDIT F346 Macro to edit existing x-section data file
DATA_ENTRY F285 Macro to initialize x-section data entry
DATE D14 Informational
DIRECTORY F266 Macro to identify file storage directory
DIST1
ver_9 C55 Station of stake at left bank
DIST2 C58 Station of stake at right bank
DIVISION
ver_9 D25 Informational
DOT_MATRIX F281 Macro to format dot matrix printer
DOWCODE D26 Informational
ERRORMSG M463 Errormsg
ERRORTABLE
ver_9 B77..E108 Minerror Table
ERRORTRAP F426 Macro to trap errors and return to /m
FILES F262 Menu to choose path, new, or existing files
GENERAL_INFO B7..H45 General stream information (Page 1)
GLWP_PERCENT AQ185 Percent WP at grassline (=100%)
GRAPH_SAVE F411 Macro to save graphs
GRASSLINE AE61 Corrected vertical distance at lowest elevation grassline
GRASSLINE_WP AP185 Grassline to grassline WP
GRASS_CHECK F352 Macro to check for "1's" in column A of data input
GRASS_MSG J494 Message resulting if both grasslines are not indicated in column A
GRASS_NUM A60 Sum of Column A (=2 else grass_msg)
HIDE2
Ver_23 BG59..BN59 Hidden area in Proof Sheet during printing
HIDE3
Ver_23 B49 Hide G message during final printing
INITIALIZE F271 Macro to activate a blank R2CROSS worksheet for initial data entry
INPUTDATA C55..AS58 Data input and calculation range
INPUTROUTINE F341 Begin Input Data Table routine
INPUT_SUMMARY A50..F59 Data range to move to Summary (Proof) Sheet
INTRO_SCREEN A435 R2CROSS introductory screen
LASER F277 Macro to format laserjet printer
LEFT_SQUARE AL56 Cross sectional area calculation
LEFT_TRIANGLE AM56 Cross sectional area calculation
LEVELROUTINE F338 Begin survey level and rod data entry routine
LOOP1 F391 Loop to check staging table WL>Grassline
LOOP2 F397 Loop to check staging table WL
LOOP3 F402 Begin staging table operation (not really a loop)
MAINMENU C255 Main R2CROSS menu
MAXVERT T61 Maximum sag corrected vertical distance
MEAS_A J61 Raw data area calc.
MEAS_D I61 Raw data maximum depth
MEAS_Q K61 Raw data Q calc.
MEAS_S
ver_9 D39 Raw data slope measurment
MEAS_WP H61 Raw data WP calc.
MESSAGE1 A458 Message displayed while program formating worksheet
MESSAGE2
ver_9 A475 Message displayed while program summarizing data input
MESSAGE3 A492 Message displayed while program is calculating staging table
MESSAGE4 J476 Message displayed prior to EDITING data
MINERROR V61 Water line which produces the minumum area error between raw and sag corrected data
MINERROR_HEADER B77..I77 Formulae at top of Minerror table
N K64 Manning's n
NEW_FILE F376 Macro to save a new file
NEW_FILE_MSG J512 New_file Message
NEW_GRAPH F418 Macro to save a new graph
NUMBER F50 Number of x-section verticals collected
OBSERVERS D15 Informational
OVERWRITE F380 Macro to overwrite existing file
OVERWRITE_GRAPH F422 Macro to overwrite existing graph
PAGE1 A1..M45 Page 1 print range
PAGE2 A46..L65 Page 2 print range
PAGE3 A68..E111 Page 3 print range
PAGE4 AJ173..AU243Page 4 print range
PAGE5 A113..O163 Page 5 print range
PM D21 Informational
PRINTER F273 Macro to formate printer
Q% L55..L58 Percent Q in each cell
QSECTION D17 Informational
RANGE D20 Informational
RANGE_TABLE V432 Table of range names
RETRIEVE F269 Macro to retrieve existing data file
RIGHT_HORIZ AO56 Cross sectional area calculation
RIGHT_INTERCEPT
ver_9 AQ56 Cross sectional area calculation
RIGHT_SQUARE AR56 Cross sectional area calculation
RIGHT_TRIANGLE AS56 Cross sectional area calculation
ROWS F295 Number of rows to insert in input data range
SAG U44 Sag parameter
SAGROUTINE F332 Begin sag tape data entry routine
SAG_A U43 Sag parameter
SAG_B U45 Sag parameter
SAG_CEN U46 Sag parameter
SAG_COS U47 Sag parameter
SAG_MAX U48 Sag parameter
SAVE_FILE F372 Menu to save data input files
SECTION D18 Informational
STAGETABLE AK184..AT242Staging table range
STAGE_HEADER AK184..AU184Formulae at top of staging table
STREAMNAME D10 Informational
STREAMSLOPE D39 Informational
SUMMARY F367 Number of rows to print for Proof Sheet
SURVEY O328 Result of surveytype getlabel routine
SURVEYTYPE F328 Begin surveytype data entry routine
TABLE1 B77 Key cell for Minerror Table
TABLE2 AK184 Key cell for Staging Table
TAPE_TENSION D35 Field measured tape tension in pounds
TAPE_WT D34 Tape weight
TENSIONROUTINE F335 Begin tape tension data entry routine
TEST1 AK186 Cell in Staging Table to begin Loop 1 testing
TOP_ERRORMSG J457 Top Left Corner of Errormsg
TOWNSHIP D19 Informational
USFSMAP D29 Informational
USGSMAP D28 Informational
WATERLINE N47 Definition of "Waterline" used in all sag corrected calculations
WATERSHED D24 Informational
WLM Y63 Average sag-corrected field-measured waterline
XSLOCATION D11 Informational
XSNUMBER D12 Informational
ZEROINPUT B59 Last line of data input range (erased at end of \c macro)
\0 C247 Autoexec Macro
\C F385 Macro to run final calculations
\G
Ver_23 F351 Macro to return to mainmenu following data entry
\M C252 Macro to run Main menu
\Q F425 Macro to quit R2CROSS
\S F358 Macro to calculate and print initial data summary for insection
======== ======== ========
TAPE TO
A Q WATER
======== ======== ========
0.00 0.00 0.00
0.00 0.00 0.00 copy edge
BathurstD84 #DIV/0!
HeyD84 #DIV/0!
STREAM NAME: 0 STREAM NAME: 0
XS LOCATION: 0 XS LOCATION: 0
XS NUMBER: 0 Jarrett Variable Manning's n Correction Applied XS NUMBER: 0 Thorne-Zevenbergen D84 Correction Applied
Estimated D84= #DIV/0!
*GL* = lowest Grassline elevation corrected for sag *GL* = lowest Grassline elevation corrected for sag
STAGING TABLE *WL* = Waterline corrected for variations in field measured water surface elevations and sag STAGING TABLE *WL* = Waterline corrected for variations in field measured water surface elevations and sag
DIST TO TOP AVG. MAX. WETTED PERCENT HYDR AVG. DIST TO TOP AVG. MAX. WETTED PERCENT HYDR AVG.
WATER WIDTH DEPTH DEPTH AREA PERIM. WET PERIM RADIUS FLOW VELOCITY WATER WIDTH DEPTH DEPTH AREA PERIM. WET PERIM RADIUS FLOW VELOCITY
(FT) (FT) (FT) (FT) (SQ FT) (FT) (%) (FT) (CFS) (FT/SEC) (FT) (FT) (FT) (FT) (SQ FT) (FT) (%) (FT) (CFS) (FT/SEC)
*GL* 1.35 0.00 #DIV/0! 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0! *GL* 1.35 0.00 #DIV/0! 0.00 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.65 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.65
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.6 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.6
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.55 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.55
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.5 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.5
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.45 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.45
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.4 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.4
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.35 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.35
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.3
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.25 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.25
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.2
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.15 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.15
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.1
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.05 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! -0.05
*WL* #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 *WL* #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.05 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.05
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.1
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.15 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.15
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.2
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.25 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.25
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.3
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.35 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.35
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.4 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.4
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.45 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.45
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.5 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.5
Home Print 0
CROSS SECTION DATA ANALYSIS
-0.50
-0.60
-0.70
-0.80
VERTICAL DEPTH (FT)
-0.90
S
-1.00
-1.10
-1.20
13.70
-1.30 G
-1.40
-1.50
0.00 2.00 4.00 6.00 8.00 10.00 12.00 14.00
DISTANCE FROM STAKE (FT)
Channel Bottom Computed Water Line
ChartMin 0 ChartMinY -1.5
ChartMax 15 ChartMaxY -0.5
Home Print
Percent Wetted Perimeter vs. Discharge
100.0%
90.0%
80.0%
Percent Wetted Perimeter
70.0%
60.0%
50.0%
40.0%
30.0%
20.0%
10.0%
0.0%
0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00
Discharge (cfs)