{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Input and Results","Ditch Analysis","Flow Splits","Lists"],"not_rendered":{"charts":0,"images":1,"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":"Instructions","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["HOW TO USE THIS SPREADSHEET"]
[]
["Background"]
[]
["This spreadsheet is very simple-minded an can only deal with two ditch configurations.  The \"V\" ditch has"]
["five specific data points and the trapezoidal ditch has six.  The configuration and data point locations for each"]
["configuration are illustrated to the right."]
[]
["If you don't enter cross section data according to these configurations, your results will be mush at best."]
[]
["This spreadsheet does use a macro and may thus create security issues on your computer."]
[]
[]
["Data Entry"]
[]
["The only location where data is to be entered into this spreadsheet is in the upper left portion of the \"Input"]
["and Results\" tab.  The only locations where data is to be entered are marked with boxes."]
[]
["The first four input variables are as follows:"]
[]
[null,null,"Ditch Type =  ","This is used to select the ditch configuration as discussed above.  There are two "]
[null,null,null,"choices that are offered in a drop-down menu."]
[]
[null,null,"Inlet side =  ","Specifies which side of the ditch the P-12A inlet will be on.  On the left side, the"]
[null,null,null,"bottom of the inlet is assumed to be at point 3 and to extend up towards point 2."]
[null,null,null,"On the right side, the inlet begins at point 3 in the \"V\" ditch and point 4 in the"]
[null,null,null,"trapezoidal ditch.  From the beginning point, the inlet will extend towards the"]
[null,null,null,"next point to the right."]
[]
[null,null,"Discharge =  ","Flow rate (in case not obvious)"]
[]
[null,null,"Longitudinal slope =  ","The slope of the ditch parallel to the roadway."]
[]
["Below these four data entry points is the table for entering the ditch cross section data.  There are three columns:"]
[]
[null,null,"x =  ","The horizontal distance from left to right."]
[]
[null,null,"Elevation =  ","Elevation, of course."]
[]
[null,null,"Manning's n =  ","The Manning's roughness coefficient for the particular segment.  The data is"]
[null,null,null,"entered based on assuming that the roughness extends to the right from the"]
[null,null,null,"point it is entered for.  Thus, the last point does not need a roughness value."]
[]
[]
[]
["By using this spreadsheet, the user"]
["agrees to take full responsibility to"]
["evaluate the results and ensure that"]
["they are correct."]

{"sheet":"Input and Results","index":1,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,9,1,14],[2,9,2,11],[5,0,5,3],[13,0,13,2],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[2,2,2,3]]}
["P-12A INLETS ON GRADE - FLOW INTERCEPTION"]
[null,null,null,null,null,null,null,null,"Project:  "]
[null,"Computed by:  ",null,null,null,"Date:  ",null,null,"Str. #:  "]
[]
["DATA ENTRY",null,null,null,null,null,null,null,null,null,"Background"]
["To use, fill in yellow highlighted cells."]
[]
[null,"Ditch Type:  ",null,null,null,null,null,null,null,null,"Grate width:  ",2.39,"feet (along flow direction)"]
[null,"Inlet side:  ",null,null,null,null,null,null,null,null,"Grade Length:  ",3.77,"feet (along ditch slope)"]
[null,"Discharge:  ",null,null,"cfs",null,null,null,null,null,"Splash-over velocity:  ",4.84,"ft/sec"]
[null,"Longitudinal slope:  ",null,null,"ft/ft"]
[]
[]
["Enter ditch cross section data:"]
[null,null,null,null,null,null,null,null,null,null,null,"By using this spreadsheet, the user"]
["Point",null,null,null,null,"Mannings",null,null,null,null,null,"agrees to take full responsibility to"]
["Number","Segment Type*",null,"X","Elevation","n",null,null,null,null,null,"evaluate the results and ensure that"]
[1,"Left shoulder",null,null,null,null,null,"Check:  Will inlet fit?",null,null,null,"they are correct."]
[2,"Left slope",null,null,null,null,null,"Left:  ",{"$f":"IF(((D19-D20)^2+(E19-E20)^2)^0.5<$L$9,\"No\",\"Yes\")","v":"No"}]
[3,{"$f":"IF(C8=\"Trapezoidal\",\"Bottom\",\"Right slope\")","v":"Right slope"},null,null,null,null,null,{"$f":"IF(C8=\"Trapezoidal\",\" \",\"Right:  \")","v":"Right:  "},{"$f":"IF(C8=\"Trapezoidal\",\" \",IF(((D20-D21)^2+(E20-E21)^2)^0.5<$L$9,\"No\",\"Yes\"))","v":"No"}]
[4,{"$f":"IF(C8=\"Trapezoidal\",\"Right slope\",\"Right shoulder\")","v":"Right shoulder"},null,null,null,null,null,{"$f":"IF(C8=\"Trapezoidal\",\"Right:  \",\" \")","v":" "},{"$f":"IF(C8=\"Trapezoidal\",IF(((D21-D22)^2+(E21-E22)^2)^0.5<$L$9,\"No\",\"Yes\"),\" \")","v":" "}]
[5,{"$f":"IF(C8=\"Trapezoidal\",\"Right shoulder\",\"-End point-\")","v":"-End point-"}]
[{"$f":"IF(C8=\"Trapezoidal\",6,\"-\")","v":"-"},{"$f":"IF(C8=\"Trapezoidal\",\"-End point-\",\" \")","v":" "}]
[]
["* Type is marked at the start of the segment"]
[]
[]
["RESULTS SUMMARY"]
[]
[null,"Flow depth:  ",{"$f":"'Ditch Analysis'!C10-MIN('Input and Results'!E18:E22)","v":{"$error":"#VALUE!"}},"feet"]
[]
[null,null,"Left of",null,"Right of","Total","Bypass"]
[null,null,"grate","On grate","grate","flow","flow"]
[]
[null,"Inflow:  ",{"$f":"C46","v":{"$error":"#VALUE!"}},{"$f":"C53","v":{"$error":"#VALUE!"}},{"$f":"C59","v":{"$error":"#VALUE!"}},{"$f":"SUM(C35:E35)","v":{"$error":"#VALUE!"}}]
[null,"Intercepted flow:  ",{"$f":"C49","v":{"$error":"#VALUE!"}},{"$f":"C55","v":{"$error":"#VALUE!"}},{"$f":"C62","v":{"$error":"#VALUE!"}},{"$f":"SUM(C36:E36)","v":{"$error":"#VALUE!"}},{"$f":"C10-F36","v":{"$error":"#VALUE!"}}]
[]
[]
["INLET COMPUTATIONS"]
[]
[]
[null,null,"Average flow velocity:  ",{"$f":"C10/'Flow Splits'!I17","v":{"$error":"#VALUE!"}},"ft/sec"]
[]
["Left side flow:"]
[]
[null,"Discharge:  ",{"$f":"'Flow Splits'!J34","v":{"$error":"#VALUE!"}},"cfs"]
[null,"Side slope:  ",{"$f":"(E19-E20)/(D20-D19)","v":{"$error":"#DIV/0!"}},"ft/ft"]
[null,"Efficiency:  ",{"$f":"1/(1+0.15*$D$42^1.8/C47/$L$8^2.3)","v":{"$error":"#VALUE!"}}]
[null,"Q in:  ",{"$f":"C46*C48","v":{"$error":"#VALUE!"}},"cfs"]
[]
["Frontal flow on grate:"]
[]
[null,"Discharge:  ",{"$f":"'Flow Splits'!J35","v":{"$error":"#VALUE!"}},"cfs"]
[null,"Efficiency:  ",{"$f":"MIN(1-0.09*(D42-L10),1)","v":{"$error":"#VALUE!"}}]
[null,"Q in:  ",{"$f":"C54*C53","v":{"$error":"#VALUE!"}},"cfs"]
[]
["Right side flow:"]
[]
[null,"Discharge:  ",{"$f":"'Flow Splits'!J36","v":{"$error":"#VALUE!"}},"cfs"]
[null,"Side slope:  ",{"$f":"IF(C8=\"Trapezoidal\",(E22-E21)/(D22-D21),(E21-E20)/(D21-D20))","v":{"$error":"#DIV/0!"}},"ft/ft"]
[null,"Efficiency:  ",{"$f":"1/(1+0.15*$D$42^1.8/C60/$L$8^2.3)","v":{"$error":"#VALUE!"}}]
[null,"Q in:  ",{"$f":"C59*C61","v":{"$error":"#VALUE!"}},"cfs"]

{"sheet":"Ditch Analysis","index":2,"n_rows":177,"n_cols":11,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
["DETERMINE FLOW DEPTH IN DITCH:"]
[]
["Elevation range:",null,null,null,"Ratiing curve:",null,null,null,null,"Make sure the cross section points"]
[null,"Bottom:  ",{"$f":"MIN('Input and Results'!E18:E23)","v":0},null,null,null,null,null,null,"match the pattern described in the"]
[null,"Top:  ",{"$f":"MIN('Input and Results'!E18,MAX('Input and Results'!E22:E23))","v":0},null,"Rating",null,null,null,null,"instructions!  If not, you will get mush."]
[null,null,null,null,"Number","Elevation","K"]
[null,null,null,null,0,{"$f":"C4","v":0},0]
["Required conveyance:",null,null,null,1,{"$f":"F7+($C$5-$C$4)/10","v":0},{"$f":"K33","v":{"$error":"#VALUE!"}}]
[null,"K = ",{"$f":"'Input and Results'!C10:D10/'Input and Results'!C11:D11^0.5","v":{"$error":"#DIV/0!"}},null,2,{"$f":"F8+($C$5-$C$4)/10","v":0},{"$f":"K49","v":{"$error":"#VALUE!"}}]
[null,"Elev. = ",{"$f":"linterp(C9,G7:G17,F7:F17,11)","v":{"$error":"#VALUE!"}},null,3,0,{"$f":"K65","v":{"$error":"#VALUE!"}}]
[null,null,null,null,4,0,{"$f":"K81","v":{"$error":"#VALUE!"}}]
[null,null,null,null,5,0,{"$f":"K97","v":{"$error":"#VALUE!"}}]
[null,null,null,null,6,0,{"$f":"K113","v":{"$error":"#VALUE!"}}]
[null,null,null,null,7,0,{"$f":"K129","v":{"$error":"#VALUE!"}}]
[null,null,null,null,8,0,{"$f":"K145","v":{"$error":"#VALUE!"}}]
[null,null,null,null,9,0,{"$f":"K161","v":{"$error":"#VALUE!"}}]
[null,null,null,null,10,0,{"$f":"K177","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",1,null,null,"Start X:  ",{"$f":"linterpdown(B21,C26:C28,B26:B28,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B20,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C8=\"Trapezoidal\",linterp('Ditch Analysis'!B21,'Ditch Analysis'!C29:C31,'Ditch Analysis'!B29:B31,3),linterp('Ditch Analysis'!B21,'Ditch Analysis'!C28:C30,'Ditch Analysis'!B28:B30,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B27,MAX(B26,F20))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B27,MAX(B26,F21))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B21-C26,0)","v":0},{"$f":"MAX(B21-C27,0)","v":0},{"$f":"(G26+H26)/2*(F26-E26)","v":{"$error":"#VALUE!"}},{"$f":"((F26-E26)^2+(H26-G26)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J26*D26^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B28,MAX(B27,F20))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B28,MAX(B27,F21))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B21-C27,0)","v":0},{"$f":"MAX(B21-C28,0)","v":0},{"$f":"(G27+H27)/2*(F27-E27)","v":{"$error":"#VALUE!"}},{"$f":"((F27-E27)^2+(H27-G27)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J27*D27^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B29,MAX(B28,F20))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B29,MAX(B28,F21))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B21-C28,0)","v":0},{"$f":"MAX(B21-C29,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B30,MAX(B29,F20))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B30,MAX(B29,F21))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B21-C29,0)","v":0},{"$f":"MAX(B21-C30,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B31,MAX(B30,F20))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B31,MAX(B30,F21))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B21-C30,0)","v":0},{"$f":"MAX(B21-C31,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I26:I31)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J26:J31)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K26:K30)/J32)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I32*(I32/J32)^(2/3)/K32","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",2,null,null,"Start X:  ",{"$f":"linterpdown(B37,C42:C44,B42:B44,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B36,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C24=\"Trapezoidal\",linterp('Ditch Analysis'!B37,'Ditch Analysis'!C45:C47,'Ditch Analysis'!B45:B47,3),linterp('Ditch Analysis'!B37,'Ditch Analysis'!C44:C46,'Ditch Analysis'!B44:B46,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B43,MAX(B42,F36))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B43,MAX(B42,F37))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B37-C42,0)","v":0},{"$f":"MAX(B37-C43,0)","v":0},{"$f":"(G42+H42)/2*(F42-E42)","v":{"$error":"#VALUE!"}},{"$f":"((F42-E42)^2+(H42-G42)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J42*D42^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B44,MAX(B43,F36))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B44,MAX(B43,F37))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B37-C43,0)","v":0},{"$f":"MAX(B37-C44,0)","v":0},{"$f":"(G43+H43)/2*(F43-E43)","v":{"$error":"#VALUE!"}},{"$f":"((F43-E43)^2+(H43-G43)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J43*D43^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B45,MAX(B44,F36))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B45,MAX(B44,F37))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B37-C44,0)","v":0},{"$f":"MAX(B37-C45,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B46,MAX(B45,F36))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B46,MAX(B45,F37))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B37-C45,0)","v":0},{"$f":"MAX(B37-C46,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B47,MAX(B46,F36))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B47,MAX(B46,F37))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B37-C46,0)","v":0},{"$f":"MAX(B37-C47,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I42:I47)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J42:J47)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K42:K46)/J48)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I48*(I48/J48)^(2/3)/K48","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",3,null,null,"Start X:  ",{"$f":"linterpdown(B53,C58:C60,B58:B60,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B52,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C51=\"Trapezoidal\",linterp('Ditch Analysis'!B53,'Ditch Analysis'!C61:C63,'Ditch Analysis'!B61:B63,3),linterp('Ditch Analysis'!B53,'Ditch Analysis'!C60:C62,'Ditch Analysis'!B60:B62,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B59,MAX(B58,F52))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B59,MAX(B58,F53))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B53-C58,0)","v":0},{"$f":"MAX(B53-C59,0)","v":0},{"$f":"(G58+H58)/2*(F58-E58)","v":{"$error":"#VALUE!"}},{"$f":"((F58-E58)^2+(H58-G58)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J58*D58^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B60,MAX(B59,F52))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B60,MAX(B59,F53))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B53-C59,0)","v":0},{"$f":"MAX(B53-C60,0)","v":0},{"$f":"(G59+H59)/2*(F59-E59)","v":{"$error":"#VALUE!"}},{"$f":"((F59-E59)^2+(H59-G59)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J59*D59^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B61,MAX(B60,F52))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B61,MAX(B60,F53))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B53-C60,0)","v":0},{"$f":"MAX(B53-C61,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B62,MAX(B61,F52))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B62,MAX(B61,F53))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B53-C61,0)","v":0},{"$f":"MAX(B53-C62,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B63,MAX(B62,F52))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B63,MAX(B62,F53))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B53-C62,0)","v":0},{"$f":"MAX(B53-C63,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I58:I63)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J58:J63)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K58:K62)/J64)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I64*(I64/J64)^(2/3)/K64","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",4,null,null,"Start X:  ",{"$f":"linterpdown(B69,C74:C76,B74:B76,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B68,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C67=\"Trapezoidal\",linterp('Ditch Analysis'!B69,'Ditch Analysis'!C77:C79,'Ditch Analysis'!B77:B79,3),linterp('Ditch Analysis'!B69,'Ditch Analysis'!C76:C78,'Ditch Analysis'!B76:B78,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B75,MAX(B74,F68))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B75,MAX(B74,F69))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B69-C74,0)","v":0},{"$f":"MAX(B69-C75,0)","v":0},{"$f":"(G74+H74)/2*(F74-E74)","v":{"$error":"#VALUE!"}},{"$f":"((F74-E74)^2+(H74-G74)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J74*D74^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B76,MAX(B75,F68))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B76,MAX(B75,F69))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B69-C75,0)","v":0},{"$f":"MAX(B69-C76,0)","v":0},{"$f":"(G75+H75)/2*(F75-E75)","v":{"$error":"#VALUE!"}},{"$f":"((F75-E75)^2+(H75-G75)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J75*D75^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B77,MAX(B76,F68))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B77,MAX(B76,F69))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B69-C76,0)","v":0},{"$f":"MAX(B69-C77,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B78,MAX(B77,F68))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B78,MAX(B77,F69))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B69-C77,0)","v":0},{"$f":"MAX(B69-C78,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B79,MAX(B78,F68))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B79,MAX(B78,F69))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B69-C78,0)","v":0},{"$f":"MAX(B69-C79,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I74:I79)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J74:J79)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K74:K78)/J80)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I80*(I80/J80)^(2/3)/K80","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",5,null,null,"Start X:  ",{"$f":"linterpdown(B85,C90:C92,B90:B92,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B84,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C83=\"Trapezoidal\",linterp('Ditch Analysis'!B85,'Ditch Analysis'!C93:C95,'Ditch Analysis'!B93:B95,3),linterp('Ditch Analysis'!B85,'Ditch Analysis'!C92:C94,'Ditch Analysis'!B92:B94,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B91,MAX(B90,F84))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B91,MAX(B90,F85))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B85-C90,0)","v":0},{"$f":"MAX(B85-C91,0)","v":0},{"$f":"(G90+H90)/2*(F90-E90)","v":{"$error":"#VALUE!"}},{"$f":"((F90-E90)^2+(H90-G90)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J90*D90^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B92,MAX(B91,F84))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B92,MAX(B91,F85))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B85-C91,0)","v":0},{"$f":"MAX(B85-C92,0)","v":0},{"$f":"(G91+H91)/2*(F91-E91)","v":{"$error":"#VALUE!"}},{"$f":"((F91-E91)^2+(H91-G91)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J91*D91^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B93,MAX(B92,F84))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B93,MAX(B92,F85))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B85-C92,0)","v":0},{"$f":"MAX(B85-C93,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B94,MAX(B93,F84))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B94,MAX(B93,F85))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B85-C93,0)","v":0},{"$f":"MAX(B85-C94,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B95,MAX(B94,F84))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B95,MAX(B94,F85))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B85-C94,0)","v":0},{"$f":"MAX(B85-C95,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I90:I95)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J90:J95)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K90:K94)/J96)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I96*(I96/J96)^(2/3)/K96","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",6,null,null,"Start X:  ",{"$f":"linterpdown(B101,C106:C108,B106:B108,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B100,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C99=\"Trapezoidal\",linterp('Ditch Analysis'!B101,'Ditch Analysis'!C109:C111,'Ditch Analysis'!B109:B111,3),linterp('Ditch Analysis'!B101,'Ditch Analysis'!C108:C110,'Ditch Analysis'!B108:B110,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B107,MAX(B106,F100))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B107,MAX(B106,F101))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B101-C106,0)","v":0},{"$f":"MAX(B101-C107,0)","v":0},{"$f":"(G106+H106)/2*(F106-E106)","v":{"$error":"#VALUE!"}},{"$f":"((F106-E106)^2+(H106-G106)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J106*D106^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B108,MAX(B107,F100))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B108,MAX(B107,F101))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B101-C107,0)","v":0},{"$f":"MAX(B101-C108,0)","v":0},{"$f":"(G107+H107)/2*(F107-E107)","v":{"$error":"#VALUE!"}},{"$f":"((F107-E107)^2+(H107-G107)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J107*D107^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B109,MAX(B108,F100))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B109,MAX(B108,F101))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B101-C108,0)","v":0},{"$f":"MAX(B101-C109,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B110,MAX(B109,F100))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B110,MAX(B109,F101))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B101-C109,0)","v":0},{"$f":"MAX(B101-C110,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B111,MAX(B110,F100))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B111,MAX(B110,F101))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B101-C110,0)","v":0},{"$f":"MAX(B101-C111,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I106:I111)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J106:J111)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K106:K110)/J112)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I112*(I112/J112)^(2/3)/K112","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",7,null,null,"Start X:  ",{"$f":"linterpdown(B117,C122:C124,B122:B124,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B116,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C115=\"Trapezoidal\",linterp('Ditch Analysis'!B117,'Ditch Analysis'!C125:C127,'Ditch Analysis'!B125:B127,3),linterp('Ditch Analysis'!B117,'Ditch Analysis'!C124:C126,'Ditch Analysis'!B124:B126,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B123,MAX(B122,F116))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B123,MAX(B122,F117))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B117-C122,0)","v":0},{"$f":"MAX(B117-C123,0)","v":0},{"$f":"(G122+H122)/2*(F122-E122)","v":{"$error":"#VALUE!"}},{"$f":"((F122-E122)^2+(H122-G122)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J122*D122^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B124,MAX(B123,F116))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B124,MAX(B123,F117))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B117-C123,0)","v":0},{"$f":"MAX(B117-C124,0)","v":0},{"$f":"(G123+H123)/2*(F123-E123)","v":{"$error":"#VALUE!"}},{"$f":"((F123-E123)^2+(H123-G123)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J123*D123^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B125,MAX(B124,F116))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B125,MAX(B124,F117))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B117-C124,0)","v":0},{"$f":"MAX(B117-C125,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B126,MAX(B125,F116))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B126,MAX(B125,F117))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B117-C125,0)","v":0},{"$f":"MAX(B117-C126,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B127,MAX(B126,F116))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B127,MAX(B126,F117))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B117-C126,0)","v":0},{"$f":"MAX(B117-C127,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I122:I127)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J122:J127)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K122:K126)/J128)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I128*(I128/J128)^(2/3)/K128","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",8,null,null,"Start X:  ",{"$f":"linterpdown(B133,C138:C140,B138:B140,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B132,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C131=\"Trapezoidal\",linterp('Ditch Analysis'!B133,'Ditch Analysis'!C141:C143,'Ditch Analysis'!B141:B143,3),linterp('Ditch Analysis'!B133,'Ditch Analysis'!C140:C142,'Ditch Analysis'!B140:B142,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B139,MAX(B138,F132))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B139,MAX(B138,F133))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B133-C138,0)","v":0},{"$f":"MAX(B133-C139,0)","v":0},{"$f":"(G138+H138)/2*(F138-E138)","v":{"$error":"#VALUE!"}},{"$f":"((F138-E138)^2+(H138-G138)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J138*D138^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B140,MAX(B139,F132))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B140,MAX(B139,F133))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B133-C139,0)","v":0},{"$f":"MAX(B133-C140,0)","v":0},{"$f":"(G139+H139)/2*(F139-E139)","v":{"$error":"#VALUE!"}},{"$f":"((F139-E139)^2+(H139-G139)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J139*D139^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B141,MAX(B140,F132))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B141,MAX(B140,F133))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B133-C140,0)","v":0},{"$f":"MAX(B133-C141,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B142,MAX(B141,F132))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B142,MAX(B141,F133))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B133-C141,0)","v":0},{"$f":"MAX(B133-C142,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B143,MAX(B142,F132))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B143,MAX(B142,F133))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B133-C142,0)","v":0},{"$f":"MAX(B133-C143,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I138:I143)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J138:J143)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K138:K142)/J144)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I144*(I144/J144)^(2/3)/K144","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",9,null,null,"Start X:  ",{"$f":"linterpdown(B149,C154:C156,B154:B156,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B148,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C147=\"Trapezoidal\",linterp('Ditch Analysis'!B149,'Ditch Analysis'!C157:C159,'Ditch Analysis'!B157:B159,3),linterp('Ditch Analysis'!B149,'Ditch Analysis'!C156:C158,'Ditch Analysis'!B156:B158,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B155,MAX(B154,F148))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B155,MAX(B154,F149))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B149-C154,0)","v":0},{"$f":"MAX(B149-C155,0)","v":0},{"$f":"(G154+H154)/2*(F154-E154)","v":{"$error":"#VALUE!"}},{"$f":"((F154-E154)^2+(H154-G154)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J154*D154^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B156,MAX(B155,F148))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B156,MAX(B155,F149))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B149-C155,0)","v":0},{"$f":"MAX(B149-C156,0)","v":0},{"$f":"(G155+H155)/2*(F155-E155)","v":{"$error":"#VALUE!"}},{"$f":"((F155-E155)^2+(H155-G155)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J155*D155^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B157,MAX(B156,F148))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B157,MAX(B156,F149))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B149-C156,0)","v":0},{"$f":"MAX(B149-C157,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B158,MAX(B157,F148))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B158,MAX(B157,F149))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B149-C157,0)","v":0},{"$f":"MAX(B149-C158,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B159,MAX(B158,F148))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B159,MAX(B158,F149))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B149-C158,0)","v":0},{"$f":"MAX(B149-C159,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I154:I159)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J154:J159)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K154:K158)/J160)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I160*(I160/J160)^(2/3)/K160","v":{"$error":"#VALUE!"}}]
[]
[]
["Rating #:  ",10,null,null,"Start X:  ",{"$f":"linterpdown(B165,C170:C172,B170:B172,3)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"VLOOKUP(B164,$E$7:$F$17,2)","v":0},null,null,"End X:  ",{"$f":"IF('Input and Results'!C163=\"Trapezoidal\",linterp('Ditch Analysis'!B165,'Ditch Analysis'!C173:C175,'Ditch Analysis'!B173:B175,3),linterp('Ditch Analysis'!B165,'Ditch Analysis'!C172:C174,'Ditch Analysis'!B172:B174,3))","v":{"$error":"#VALUE!"}}]
[]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B171,MAX(B170,F164))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B171,MAX(B170,F165))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B165-C170,0)","v":0},{"$f":"MAX(B165-C171,0)","v":0},{"$f":"(G170+H170)/2*(F170-E170)","v":{"$error":"#VALUE!"}},{"$f":"((F170-E170)^2+(H170-G170)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J170*D170^1.5","v":{"$error":"#VALUE!"}}]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B172,MAX(B171,F164))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B172,MAX(B171,F165))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B165-C171,0)","v":0},{"$f":"MAX(B165-C172,0)","v":0},{"$f":"(G171+H171)/2*(F171-E171)","v":{"$error":"#VALUE!"}},{"$f":"((F171-E171)^2+(H171-G171)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J171*D171^1.5","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B173,MAX(B172,F164))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B173,MAX(B172,F165))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B165-C172,0)","v":0},{"$f":"MAX(B165-C173,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B174,MAX(B173,F164))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B174,MAX(B173,F165))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B165-C173,0)","v":0},{"$f":"MAX(B165-C174,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B175,MAX(B174,F164))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B175,MAX(B174,F165))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B165-C174,0)","v":0},{"$f":"MAX(B165-C175,0)","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I170:I175)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J170:J175)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K170:K174)/J176)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I176*(I176/J176)^(2/3)/K176","v":{"$error":"#VALUE!"}}]

{"sheet":"Flow Splits","index":3,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["DETERMINE FRONTAL AND SIDE FLOWS"]
[]
["Ditch flow:"]
[]
[null,null,null,null,"Start X:  ",{"$f":"linterpdown(B6,C11:C13,B11:B13,3)","v":{"$error":"#VALUE!"}},null,{"$f":"MATCH(F5,B11:B16)","v":{"$error":"#VALUE!"}}]
["Elev:  ",{"$f":"'Ditch Analysis'!C10","v":{"$error":"#VALUE!"}},null,null,"End X:  ",{"$f":"IF('Input and Results'!C8=\"Trapezoidal\",linterp(B6,C14:C16,B14:B16,3),linterp(B6,C13:C15,B13:B15,3))","v":{"$error":"#VALUE!"}},null,{"$f":"MATCH(F6,B11:B16)","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Rating for comp's:"]
[null,null,null,null,null,null,null,null,null,null,null,"Cumulative",null,null,null,"Cumulative"]
["Point",null,null,null,"Start","End","Start","End",null,"Wetted",null,"K by",null,"Point",null,"K by"]
["Number","X","Elev.","n","X","X","Depth","Depth","Area","Perimeter","Pxn^1.5","segment",null,"Number","X","segment"]
[]
[1,{"$f":"'Input and Results'!$D$18","v":0},{"$f":"'Input and Results'!$E$18","v":0},{"$f":"'Input and Results'!$F$18","v":0},{"$f":"MIN(B12,MAX(B11,F5))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B12,MAX(B11,F6))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C11,0)","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C12,0)","v":{"$error":"#VALUE!"}},{"$f":"(G11+H11)/2*(F11-E11)","v":{"$error":"#VALUE!"}},{"$f":"((F11-E11)^2+(H11-G11)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J11*D11^1.5","v":{"$error":"#VALUE!"}},{"$f":"IF(J11>0,1.486*I11*(I11/J11)^(2/3)/D11,0)","v":{"$error":"#VALUE!"}},null,{"$f":"H5","v":{"$error":"#VALUE!"}},{"$f":"F5","v":{"$error":"#VALUE!"}},0]
[2,{"$f":"'Input and Results'!$D$19","v":0},{"$f":"'Input and Results'!$E$19","v":0},{"$f":"'Input and Results'!$F$19","v":0},{"$f":"MIN(B13,MAX(B12,F5))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B13,MAX(B12,F6))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C12,0)","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C13,0)","v":{"$error":"#VALUE!"}},{"$f":"(G12+H12)/2*(F12-E12)","v":{"$error":"#VALUE!"}},{"$f":"((F12-E12)^2+(H12-G12)^2)^0.5","v":{"$error":"#VALUE!"}},{"$f":"J12*D12^1.5","v":{"$error":"#VALUE!"}},{"$f":"IF(J12>0,1.486*I12*(I12/J12)^(2/3)/D12,0)+L11","v":{"$error":"#VALUE!"}},null,{"$f":"IF(N11+1>$H$6+1,\"n/a\",N11+1)","v":{"$error":"#VALUE!"}},{"$f":"IF(INDEX($B$11:$B$16,N12)>$F$6,$F$6,INDEX($B$11:$B$16,N12))","v":{"$error":"#VALUE!"}},{"$f":"INDEX($L$11:$L$15,N12-1)","v":{"$error":"#VALUE!"}}]
[3,{"$f":"'Input and Results'!$D$20","v":0},{"$f":"'Input and Results'!$E$20","v":0},{"$f":"'Input and Results'!$F$20","v":0},{"$f":"MIN(B14,MAX(B13,F5))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B14,MAX(B13,F6))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C13,0)","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C14,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(J13>0,1.486*I13*(I13/J13)^(2/3)/D13,0)+L12","v":{"$error":"#VALUE!"}},null,{"$f":"IF(N12+1>$H$6+1,\"n/a\",N12+1)","v":{"$error":"#VALUE!"}},{"$f":"IF(INDEX($B$11:$B$16,N13)>$F$6,$F$6,INDEX($B$11:$B$16,N13))","v":{"$error":"#VALUE!"}},{"$f":"INDEX($L$11:$L$15,N13-1)","v":{"$error":"#VALUE!"}}]
[4,{"$f":"'Input and Results'!$D$21","v":0},{"$f":"'Input and Results'!$E$21","v":0},{"$f":"'Input and Results'!$F$21","v":0},{"$f":"MIN(B15,MAX(B14,F5))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B15,MAX(B14,F6))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C14,0)","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C15,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,{"$f":"'Input and Results'!$D$22","v":0},{"$f":"'Input and Results'!$E$22","v":0},{"$f":"'Input and Results'!$F$22","v":0},{"$f":"MIN(B16,MAX(B15,F5))","v":{"$error":"#VALUE!"}},{"$f":"MIN(B16,MAX(B15,F6))","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C15,0)","v":{"$error":"#VALUE!"}},{"$f":"MAX(B6-C16,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[6,{"$f":"'Input and Results'!$D$23","v":0},{"$f":"'Input and Results'!$E$23","v":0},{"$f":"'Input and Results'!$F$23","v":0},null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,"Totals -->  ",{"$f":"SUM(I11:I16)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J11:J16)","v":{"$error":"#VALUE!"}},{"$f":"(SUM(K11:K15)/J17)^(2/3)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"Conveyance -->",{"$f":"1.486*I17*(I17/J17)^(2/3)/K17","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["Grate stations:"]
[]
[null,"Bottom station:  ",{"$f":"IF('Input and Results'!C9=\"Left\",B13,IF('Input and Results'!C8=\"Trapezoidal\",B14,B13))","v":0}]
[null,"Ditch side slope:  ",{"$f":"IF('Input and Results'!C9=\"Left\",ABS(('Flow Splits'!B12-'Flow Splits'!B13)/('Flow Splits'!C12-'Flow Splits'!C13)),IF('Input and Results'!C8=\"Trapezoidal\",ABS(('Flow Splits'!B14-'Flow Splits'!B15)/('Flow Splits'!C14-'Flow Splits'!C15)),ABS(('Flow Splits'!B13-'Flow Splits'!B14)/('Flow Splits'!C13-'Flow Splits'!C14))))","v":{"$error":"#DIV/0!"}},":1"]
[null,"Width on slope:  ",{"$f":"COS(ATAN(1/C25))*'Input and Results'!L9","v":{"$error":"#DIV/0!"}},"feet"]
[null,"Top station:  ",{"$f":"IF('Input and Results'!C9=\"Left\",'Flow Splits'!C24-'Flow Splits'!C26,'Flow Splits'!C24+'Flow Splits'!C26)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Locations for conveyance computations:"]
[]
[null,null,null,"Cumulative",null,"Discharges:",null,"Net K","% of Total","Q"]
[null,null,"Station","K"]
[null,null,null,null,null,null,"Left of grate:  ",{"$f":"D36-D35","v":{"$error":"#VALUE!"}},{"$f":"H34/$D$38","v":{"$error":"#VALUE!"}},{"$f":"I34*'Input and Results'!C10","v":{"$error":"#VALUE!"}}]
[null,"Left edge water  ",{"$f":"MIN(F5,MIN(C24,C27))","v":{"$error":"#DIV/0!"}},{"$f":"linterp(C35,$O$11:$O$16,$P$11:$P$16,($H$6-$H$5+2))","v":{"$error":"#VALUE!"}},null,null,"On grate:  ",{"$f":"D37-D36","v":{"$error":"#VALUE!"}},{"$f":"H35/$D$38","v":{"$error":"#VALUE!"}},{"$f":"I35*'Input and Results'!C10","v":{"$error":"#VALUE!"}}]
[null,"start of grate  ",{"$f":"MIN(C24,C27)","v":{"$error":"#DIV/0!"}},{"$f":"linterp(C36,$O$11:$O$16,$P$11:$P$16,($H$6-$H$5+2))","v":{"$error":"#VALUE!"}},null,null,"Right of grate:  ",{"$f":"D38-D37","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"I36*'Input and Results'!C10","v":{"$error":"#VALUE!"}}]
[null,"end of grate  ",{"$f":"MIN(F6,MAX(C24,C27))","v":{"$error":"#DIV/0!"}},{"$error":"#VALUE!"}]
[null,"right edge of water  ",{"$f":"MAX(F6,MAX(C24,C27))","v":{"$error":"#DIV/0!"}},{"$error":"#VALUE!"}]

{"sheet":"Lists","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"V-Ditch"]
[null,"Trapezoidal"]
[]
[]
[null,"Left"]
[null,"Right"]