{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["DistanceEstimator","Sheet2","ReferenceList","Plot"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"DistanceEstimator","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,1,32,7],[34,2,34,5],[0,0,0,7],[3,0,3,7],[19,0,19,7],[1,1,1,6],[2,1,2,6],[4,2,4,7],[15,0,15,7]]}
["BOUNDARY DISTANCE INFLUENCE OF HYDRAULIC STRUCTURE"]
[null,"Uses MACRO function: BoundaryDistance(Q_RATIO,A_RATIO,SLOPE,SKEW,CURVE)"]
[null,"Enable Macros for the Spreadsheet to work "]
["INPUT"]
["VARIABLE","VALUE","DESCRIPTION"]
["Q_REF",500,"<= Reference discharge value (CFS)  (Method A)"]
["Q_TEST",1500,"<= Test discharge value (CFS)  (Method A)"]
["A_OPENING",23,"<= Structure opening area (SQ. FT.)  (Method A)"]
["A_FAR-FIELD",100,"<= Cross sectional flow area away from structure (SQ.FT.)  (Method A)"]
["T_FAR-FIELD",100,"<= Flow width away from structure (FT.)  (Method A)"]
["D_BANKFULL",1,"<= Bankfull Depth (FT.) (Method D)"]
["T_BANKFULL",100,"<= Bankfull Width (FT.)  (Method B)"]
["SLOPE",0.02,"<= Dimensionless slope in vicinity of structure  (Method A and D)"]
["ORIENTATION","SKEW","<= Structure orientation (Pull Down)  (Method A)"]
["CURVATURE","STRAIGHT","<= Channel curvature (Pull Down)  (Method A)"]
["FLOW AND AREA RATIOS (COMPUTED)"]
["Q_RATIO",{"$f":"B7/B6","v":3},"Q_TEST/Q_REF  (Method A)"]
["A_RATIO",{"$f":"B8/B9","v":0.23},"A_TEST/A_REF  (Method A)"]
[]
["OUTPUT"]
["DISTANCE ESTIMATE A",{"$f":"(BoundaryDistance(B7/B6,B8/B9,B13,IF(B14=\"NO SKEW\",0,1),IF(B15=\"STRAIGHT\",0,1)))","v":{"$error":"#NAME?"}},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method A - Low Value)"]
["DISTANCE ESTIMATE A",{"$f":"10^(0.3)*B21","v":{"$error":"#NAME?"}},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method A - High Value)"]
[]
["DISTANCE ESTIMATE B",{"$f":"20*B12","v":2000},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method B - Low Value)"]
["DISTANCE ESTIMATE B",{"$f":"30*B12","v":3000},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method B - High Value)"]
[]
["DISTANCE ESTIMATE C",300,"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method C - Low Value)"]
["DISTANCE ESTIMATE C",1500,"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method C - High Value)"]
[]
["DISTANCE ESTIMATE D",{"$f":"40*0.2*(B11)/(B13)","v":400},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method D - Low Value)"]
["DISTANCE ESTIMATE D",{"$f":"10^(0.3)*B30","v":798.10492598755195},"<= Distance away from structure beyond which backwater influence is negligible (FT.) (Method D - High Value)"]
[]
["METHOD SELECT (Pull Down)","Method D: (Hybrid) Samuels, P. (1989). Backwater Lengths in Rivers. Proceedings of the Institution of Civil Engineers (p. 571582). Great Britian: Hydraulics Research. AND Castellarin, A., Baldassarre, G. D., Bates, P., and Brath, A. (2009). Optimal Cross- Sectional Spacing in Preissmann Scheme 1D Hydrodynamic Models. Journal of Hydraulic Engineering , 96-105."]
[]
[null,null,"SELECTED METHOD VALUES (FROM ABOVE)"]
[null,null,"MIN/MAX DISTANCE","MIN","MAX"]
[null,{"$f":"MATCH(LEFT(B33,8),ReferenceList!E2:E5,0)","v":4},"FEET",{"$f":"INDEX(ReferenceList!B2:B5,DistanceEstimator!B37)","v":400},{"$f":"INDEX(ReferenceList!C2:C5,DistanceEstimator!B37)","v":798.10492598755195}]

{"sheet":"Sheet2","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["NO SKEW","SKEW"]
[0,1]
[]
["CURVED","STRAIGHT"]
[0,1]

{"sheet":"ReferenceList","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["REFERENCES","LOW","HIGH"]
[null,{"$f":"DistanceEstimator!B21","v":{"$error":"#NAME?"}},{"$f":"DistanceEstimator!B22","v":{"$error":"#NAME?"}},"Method A:  Clevleand, T.G., Schwarz, M. R., and Tay, C. C. 2016. Modeling a Change in Flowrate through Detention or Additional Pavement on the Receiving Stream. Research Report 0-6841-1",{"$f":"LEFT(D2,8)","v":"Method A"}]
[null,{"$f":"DistanceEstimator!B24","v":2000},{"$f":"DistanceEstimator!B25","v":3000},"Method B: Wildland Hydrology, 2013. References in support of stream restoration, erosion control, and geomorphology. Accessed on July 7, 2013 at http://www.wildlandhydrology.com/html/references_.html",{"$f":"LEFT(D3,8)","v":"Method B"}]
[null,{"$f":"DistanceEstimator!B27","v":300},{"$f":"DistanceEstimator!B28","v":1500},"Method C: Nebraska Department of Roads. (2015). Hydraulic Analysis Guidelines. Bridge Division. ","Method C"]
[null,{"$f":"DistanceEstimator!B30","v":400},{"$f":"DistanceEstimator!B31","v":798.10492598755195},"Method D: (Hybrid) Samuels, P. (1989). Backwater Lengths in Rivers. Proceedings of the Institution of Civil Engineers (p. 571582). Great Britian: Hydraulics Research. AND Castellarin, A., Baldassarre, G. D., Bates, P., and Brath, A. (2009). Optimal Cross- Sectional Spacing in Preissmann Scheme 1D Hydrodynamic Models. Journal of Hydraulic Engineering , 96-105.","Method D"]

{"sheet":"Plot","index":3,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["DIST",{"$f":"DistanceEstimator!B21","v":{"$error":"#NAME?"}}]
["INC",{"$f":"B1/10","v":{"$error":"#NAME?"}}]
["X",null,"X","Z1","Z2",null,"X2","Z3"]
[-20,{"$f":"B1+B1","v":{"$error":"#NAME?"}},{"$f":"-1*B4","v":{"$error":"#NAME?"}},1,1,null,{"$f":"-B1","v":{"$error":"#NAME?"}},0]
[-19,{"$f":"B4-$B$2","v":{"$error":"#NAME?"}},{"$f":"-1*B5","v":{"$error":"#NAME?"}},1,1,null,{"$f":"-B1","v":{"$error":"#NAME?"}},5]
[-18,{"$f":"B5-$B$2","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},1,1]
[-17,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1,null,"X3","Z4"]
[-16,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1,null,{"$f":"B1","v":{"$error":"#NAME?"}},0]
[-15,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1,null,{"$f":"B1","v":{"$error":"#NAME?"}},5]
[-14,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[-13,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[-12,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[-11,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[-10,{"$f":"B1","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},1,1.01]
[-9,{"$f":"B14-$B$2","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},1,1.1499999999999999]
[-8,{"$f":"B15-$B$2","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},1,1.3]
[-7,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1.5]
[-6,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1.68]
[-5,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1.9]
[-4,{"$error":"#NAME?"},{"$error":"#NAME?"},1,2.25]
[-3,{"$error":"#NAME?"},{"$error":"#NAME?"},1,3]
[-2,{"$error":"#NAME?"},{"$error":"#NAME?"},1,3.8]
[-1,{"$error":"#NAME?"},{"$error":"#NAME?"},1,4.4000000000000004]
[0,{"$error":"#NAME?"},{"$f":"0","v":0},1,5]
[1,{"$f":"B24+$B$2","v":{"$error":"#NAME?"}},{"$f":"1*B25","v":{"$error":"#NAME?"}},1,1]
[2,{"$f":"B25+$B$2","v":{"$error":"#NAME?"}},{"$f":"1*B26","v":{"$error":"#NAME?"}},1,1]
[3,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[4,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[5,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[6,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[7,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[8,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[9,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[10,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[11,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[12,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[13,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[14,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[15,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[16,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[17,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[18,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[19,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]
[20,{"$error":"#NAME?"},{"$error":"#NAME?"},1,1]