{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Startup","Quick Reference Guide","Hydrology","Hydrology FDC","Grain Size Distribution","Supply Reach","Design Reach"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Startup","index":0,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[24,2,24,3],[2,10,2,17],[3,16,3,17],[4,16,4,17],[23,2,23,3],[3,10,3,11],[3,12,3,13],[3,14,3,15],[4,10,4,11],[4,12,4,13],[4,14,4,15]]}
[]
[null,"CSR Stable Channel Design Tool"]
[null,null,null,null,null,null,null,null,null,null,"Project Info Summary (Optional)"]
[null,null,null,null,null,null,null,null,null,null,"Project Name",null,"Stream Name",null,"Location",null,"Date"]
[null,"Stream Type",null,null,null,null,"Steps to Run Program",null,null,null,"*",null,"*",null,"*",null,"*"]
[]
[null,null,null,null,null,null,"#1  Start New Project"]
[null,null,null,null,null,null,null,"Select the stream type of interest as Sand or Gravel/Cobble bed "]
[null,null,"Choose One",null,null,null,null,"Select the preferred Sediment Transport Equation"]
[null,null,null,null,null,null,null,"Select if you have a Gage Record or a Flow Duration Curve (FDC) for the \"Supply Reach\""]
[null,"Transport Relationship",null,null,null,null,null,"Select the preferred units for the inputs and outputs"]
[null,null,null,null,null,null,null,"Push Button named \"Start New Project\" "]
[null,null,null,null,null,null,"#2  Hydrology"]
[null,null,null,null,null,null,null,"If a flow record needs to be sorted enter the gage record on the \"Hydrology\" tab "]
[null,null,"Choose One",null,null,null,null,"Push Button named \"Sort Flow Record\" "]
[null,null,null,null,null,null,null,"If you already have a FDC enter it on the \"Hydrology FDC\" tab"]
[null,"Hydrology Info",null,null,null,null,null,"Consolidate the FDC for calculations by pushing button \"Consolidate FDC\""]
[null,null,null,null,null,null,"#3 Grain Size Distribution"]
[null,null,null,null,null,null,null,"If stream is Sand bed then enter D16,D50,D84 on the supply reach tab"]
[null,null,null,null,null,null,null,"If stream is Gravel bed then enter the entire distribution on the \"Grain  Size Distribution\" tab"]
[null,null,"Choose One",null,null,null,null,"Push Button named \"Run Grain Size\" to sort"]
[null,null,null,null,null,null,null,"If Parker(1990) is used then enter no sand fractions, if Wilcock-Crowe(2003) is used include sand fractions"]
[null,"Preferred Units",null,null,null,null,"#4  Supply Reach "]
[null,null,null,null,null,null,null,"Enter channel/floodplain characteristics for Supply Reach "]
[null,null,null,null,null,null,null,"Push Button named \"Run Supply Reach\""]
[null,null,null,null,null,null,"#5  Design Reach"]
[null,null,"Choose One",null,null,null,null,"Enter channel/floodplain characterics for Design Reach "]
[null,null,null,null,null,null,null,"Enter planform characteristics (optional) if you want outputs of sinuosity, braiding risk, and meander beltwidth"]
[null,null,null,null,null,null,null,"Push Button named \"Run CSR Tool\""]
[null,null,null,null,null,null,"#6  Results"]
[null,null,null,null,null,null,null,"Review the Stable Channel Design solutions on tab named \"Results\""]
[null,null,null,null,null,null,null,"Review each Slope/Width combination details on tab named \"Detailed Results\""]
[null,"*Resets/clears all inputs and previous results"]
[null,null,null,null,null,null,"*Refer to tab named \"Quick Reference Guide\" for overview of the concepts behind the tool "]
[null,"Gravel/Cobble","Parker (1990)"]
[null,"Sand Bed","Wilcock & Crowe (2003)"]
[null,null,"Brownlie (1981)"]
[null,"Flow Record","Metric"]
[null,"Pre-existing FDC","U.S. Customary"]

{"sheet":"Quick Reference Guide","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Quick Reference Guide:"]

{"sheet":"Hydrology","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[[11,3,11,8],[5,6,5,8],[5,3,5,5],[6,6,6,7],[7,6,7,7],[8,6,8,7],[9,6,9,7]]}
[]
[null,"Hydrology - Sort Flow Record:"]
[]
[null,"Enter Flow Record "]
[null,"Discharge (cfs)"]
[null,"*",null,"Sort Flow Record Summary",null,null,"Flow Record Info "]
[null,null,null,"# of Bins","*","default 25","Gage Name",null,"*"]
[null,null,null,"Min Q","-","cfs"," Start Date",null,"*"]
[null,null,null,"Max Q","-","cfs","End Date",null,"*"]
[null,null,null,"Bin Range","-","cfs","Data Type (Daily, 15min)",null,"*"]
[null,null,null,"* Required Inputs, *Optional Inputs"]
[null,null,null,"Hydrology"]
[null,null,null,"Bin #","Min Q (cfs)","Max Q (cfs)","Average (cfs)","Frequency","Probability Density"]

{"sheet":"Hydrology FDC","index":3,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[[3,1,3,2],[11,4,11,8],[5,7,5,8],[5,4,5,6]]}
[]
[null,"Hydrology - Flow Duration Curve (FDC):"]
[]
[null,"Enter FDC"]
[null,"Exceedance (%)","Discharge (cfs)"]
[null,"*","*",null,"Consolidated FDC Summary",null,null,"FDC Info"]
[null,null,null,null,"# of Bins","*","defualt 25","FDC Source","*"]
[null,null,null,null,"Min Q","-","cms","Date Created","*"]
[null,null,null,null,"Max Q","-","cms","Watershed Name","*"]
[null,null,null,null,"Bin Range","-","cms","Weather Station","*"]
[null,null,null,null,"* Required Inputs, *Optional Inputs"]
[null,null,null,null,"Consolidated FDC"]
[null,null,null,null,"Bin #","Discharge (cms)","Exceedance ","Non-Exceedance ","Probability Density"]

{"sheet":"Grain Size Distribution","index":4,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[[9,1,9,2],[3,1,3,2],[3,7,3,9],[5,7,5,9],[9,7,9,9],[7,8,7,9],[3,4,3,5]]}
[]
[null,"Grain Size Distribution:"]
[]
[null,"Grain Size Sample Info",null,null,"Distribution Summary (mm)",null,null,"Equation Boundaries Reference"]
[null,"Sampling Type","*",null,"Dg ",null,null,"Variable ","Minimum","Maximum"]
[null,"# Sampled","*",null,"sg",null,null,"Parker (1990)"]
[null,"Location","*",null,"Sand Fraction",null,null,"Gravel size particles (mm)",2,203]
[null,"Date ","*",null,"D90",null,null,"Sand size particles (mm)","Sand removed"]
[null,null,null,null,"D84",null,null,"(%) sand in mixture","3.3% (surface)","13% (Subsurface)"]
[null,"Inputs for Grain Size",null,null,"D70",null,null,"Wilcock/Crowe (2003)"]
[null,"Size Class, mm","% Finer",null,"D50",null,null,"Gravel size particles (mm)",2,64]
[null,256,null,null,"D30",null,null,"Sand size particles (mm)",0.5,2]
[null,128,null,null,"D16",null,null,"(%) sand in mixture",6.2,34.299999999999997]
[null,64,null,null,null,null,null,"Depth (m)",0.09,0.12]
[null,32,null,null,null,null,null,"Depth (ft)",0.28999999999999998,0.39]
[null,16]
[null,8]
[null,4]
[null,2]
[null,0.5]
[null,0.25]
[null,0.125]
[]
[]
[]
[]
[null,"* Required Inputs"]
[null,"* Optional Inputs"]

{"sheet":"Supply Reach","index":5,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":true,"merged":[[2,5,2,16],[3,7,3,13],[15,1,15,3],[3,16,4,16],[4,1,4,3],[3,15,4,15],[3,14,4,14],[3,1,3,3],[11,1,11,3],[3,5,3,6]]}
[]
[null,"Supply Reach:"]
[null,null,null,null,null,"Supply Reach Results"]
[null,"Inputs For Supply Reach",null,null,null,"Hydrology",null,"Hydraulics",null,null,null,null,null,null,"Concentration (ppm)","Sediment Yield (tons/day)","Effectiveness (tons/day)"]
[null,"Main Channel ",null,null,null,"Discharge (cfs)","Probability ","Depth (ft)","Over Bank (T/F)","R (ft)","Area (ft2)","Velocity (ft/s)","n Bed","Regime"]
[null,"Bottom Width","*","ft"]
[null,"Bank Height","*","ft"]
[null,"Bank Angle","*","H:V"]
[null,"Slope","*","ft/ft"]
[null,"Right Bank (n)","*"]
[null,"Left Bank (n)","*"]
[null,"Grain Size "]
[null,"D16","*","mm"]
[null,"D50","*","mm"]
[null,"D84","*","mm"]
[null,"Floodplain"]
[null,"Floodplain Angle","*","H:V"]
[null,"Floodplain (n)","*"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* Required Inputs"]
[null,"(-) Auto-updated values"]

{"sheet":"Design Reach","index":6,"n_rows":34,"n_cols":44,"rows_kept":34,"cut":false,"hidden":true,"merged":[[20,1,20,3],[3,5,3,9],[3,1,3,3],[4,1,4,3],[9,1,9,3],[13,1,13,3],[16,1,16,3]]}
[]
[null,"Design Reach:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rectangular"]
[null,"Inputs for Design Reach",null,null,null,"Summary from Supply Reach",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trapezoidal"]
[null,"Main Channel ",null,null,null,"Discharge (cfs)","Probabilty","Qs (ppm)","Qs (tons/day)","Effectiveness ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Stage Trapezoidal"]
[null,"Bank Height","*","ft"]
[null,"Bank Angle","*","H:V",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower"]
[null,"Right Bank (n) ","*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper"]
[null,"Left Bank (n) ","*"]
[null,"Grain Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plotting "]
[null,"D16","-","mm"]
[null,"D50","-","mm"]
[null,"D84","-","mm"]
[null,"Floodplain"]
[null,"Floodplain Angle","*","H:V"]
[null,"Floodplain (n)","*"]
[null,"Planform/ Valley (Optional)"]
[null,"Valley Slope, Sv","*","ft/ft"]
[null,"Max Meander Beltwidth","*","ft"]
[null,"Beltwidth Buffer","*","ft"]
[null,"Program Constraints"]
[null,"Min Bottom Width",3,"ft (default)"]
[null,"Max Bottom Width","*","ft"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* Required Inputs"]
[null,"* Optional Inputs"]
[null,"(-) Auto-updated values"]