{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["Design-Culvert","Home","Parameters-Rational Method","Parameters-Area_Velocity Method","Parameters-Existing Structure","Lacey Regime Section","Q-Flood Discharge","Design","Lacey's Silt Factor","Q-Rational Method","Q-AV Method","Q-Flood Marks","Afflux","Database"],"not_rendered":{"charts":0,"images":60,"macros":1,"external_links":0,"defined_names":131,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Design-Culvert","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":true,"merged":[[6,2,6,9],[0,2,0,9],[1,2,1,8],[2,2,2,8],[3,2,3,8],[5,2,5,8],[4,2,4,3],[4,5,4,7],[20,2,20,9],[19,2,19,8],[18,2,18,8],[7,2,7,9],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[12,2,12,9],[13,2,14,7],[15,2,15,8],[16,2,16,8],[17,2,17,8],[35,2,35,9],[34,2,34,8],[29,2,29,8],[21,2,21,8],[22,2,22,8],[23,2,23,8],[24,2,24,8],[26,2,26,9],[27,2,27,8],[25,2,25,8],[28,2,28,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,2,33,8]]}
[null,null,"Design of Culvert",{"$nulls":7},{"$f":"AND(K2:K6)","v":false}]
[null,null,"Operating H (m) : H",{"$nulls":7},{"$f":"J2<>\"\"","v":false}]
[null,null,"Length of the Culvert (m) : L",{"$nulls":7},{"$f":"J3<>\"\"","v":false}]
[null,null,"Type of Culvert",{"$nulls":7},false]
[null,null,"Dia of Pipe Culvert (m)",null,null,"Width (m) X Depth (m) of Box Culvert",{"$nulls":4},{"$f":"OR(AND(Culvert=\"Pipe\",E5<>\"\"),AND(Culvert=\"Box\",I5<>\"\",J5<>\"\"))","v":false}]
[null,null,"Culvert Entry Condition",{"$nulls":7},false]
["Design"]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"Pipe Culvert"]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"Internal Diameter of Pipe Culvert (m) : D",{"$nulls":6},{"$f":"IF(Culvert=\"Pipe\",E5,0)","v":0}]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"Cross Sectional Area (sqm): ",{"$nulls":6},{"$f":"ROUND(PI()*(J9^2)/4,2)","v":0}]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"Wetted Perimeter (m): ",{"$nulls":6},{"$f":"ROUND(PI()*J9,2)","v":0}]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"Hydraulic Mean Radius (m): R = A/P = ",{"$nulls":6},{"$f":"IFERROR(ROUND(J10/J11,2),0)","v":0}]
[{"$f":"Culvert=\"Box\"","v":false},null,"Box Culvert"]
[false,null,"Dimensions of the Box Culvert (m)",{"$nulls":5},"Width (w)",{"$f":"IF(Culvert=\"Box\",I5,0)","v":0}]
[false,{"$nulls":7},"Depth (d)",{"$f":"IF(Culvert=\"Box\",J5,0)","v":0}]
[false,null,"Cross Sectional Area (sqm) A = w x d =",{"$nulls":6},{"$f":"ROUND(J14*J15,2)","v":0}]
[false,null,"Wetted Perimeter (m): ",{"$nulls":6},{"$f":"2*(J14+J15)","v":0}]
[false,null,"Hydraulic Mean Radius (m): R = A/P = ",{"$nulls":6},{"$f":"IFERROR(ROUND(J16/J17,2),0)","v":0}]
[{"$f":"FALSE","v":false},null,"Cross Sectional Area",{"$nulls":6},{"$f":"J10+J16","v":0}]
[{"$f":"FALSE","v":false},null,"Hydraulic Mean Radius",{"$nulls":6},{"$f":"J12+J18","v":0}]
[{"$f":"TRUE","v":true},null,"Entry Coeffocient Ke"]
[{"$f":"AND(Culvert=\"Pipe\",Entry=\"Square\")","v":false},null,"For Circular Pipe-Square Entry: ",{"$nulls":6},{"$f":"IF(AND($J$4=\"Pipe\",$J$6=\"Square\"),ROUND(1.107*SQRT($J$20),3),0)","v":0}]
[{"$f":"AND(Culvert=\"Pipe\",Entry=\"Bevelled\")","v":false},null,"For Circular Pipe-Bevelled Entry : ke = 0.10",{"$nulls":6},{"$f":"IF(AND($J$4=\"Pipe\",$J$6=\"Bevelled\"),0.1,0)","v":0}]
[{"$f":"AND(Culvert=\"Box\",Entry=\"Square\")","v":false},null,"For Box Culvert-Square Entry: ",{"$nulls":6},{"$f":"IF(AND($J$4=\"Box\",$J$6=\"Square\"),ROUND(0.527*($J$20^0.3),3),0)","v":0}]
[{"$f":"AND(Culvert=\"Box\",Entry=\"Bevelled\")","v":false},null,"For Box Culvert-Bevelled Entry : ke = 0.05",{"$nulls":6},{"$f":"IF(AND($J$4=\"Box\",$J$6=\"Bevelled\"),0.05,0)","v":0}]
[{"$f":"FALSE","v":false},null,"Entry Coefficient",{"$nulls":6},{"$f":"SUM(J22:J25)","v":0}]
[{"$f":"TRUE","v":true},null,"Friction Coeffocient Kf"]
[{"$f":"Culvert=\"Pipe\"","v":false},null,"For Circular Pipe : ",{"$nulls":6},{"$f":"IFERROR(IF(J4=\"Pipe\",0.0039*J3/(J20)^1.2,0),0)","v":0}]
[{"$f":"Culvert=\"Box\"","v":false},null,"For Box Culvert : ",{"$nulls":6},{"$f":"IFERROR(IF(J6=\"Box\",0.0035*J4/(#REF!)^1.25,0),0)","v":0}]
[{"$f":"FALSE","v":false},null,"Friction Coefficient",{"$nulls":6},{"$f":"J28+J29","v":0}]
[{"$f":"TRUE","v":true},null,"Velocity of the Flow in the Culvert (m/s)",{"$nulls":6},{"$f":"IFERROR(ROUND(4.43*SQRT(J2/(1+J26+J30)),2),0)","v":0}]
[{"$f":"TRUE","v":true},null,"Discharge through single barrel (cum/sec) : Q - A x V =",{"$nulls":6},{"$f":"J19*J31","v":0}]
[{"$f":"TRUE","v":true},null,"Total Flood Discharge",{"$nulls":6},{"$f":"Design_Discharge","v":0}]
[{"$f":"TRUE","v":true},null,"No of Vents/Rows Required = ",{"$nulls":6},{"$f":"IFERROR(CEILING(J33/J32,1),0)","v":0}]
[{"$f":"TRUE","v":true},{"$nulls":8},{"$f":"IFERROR(ROUND(J34*J32/J33,2),0)","v":0}]
[{"$f":"TRUE","v":true}]

{"sheet":"Home","index":1,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,7,4,8],[7,0,7,2],[0,0,0,9],[1,0,1,1],[1,2,1,9],[4,3,4,4],[4,1,4,2],[2,1,2,2],[3,0,3,9],[6,2,6,5],[6,6,6,9],[2,5,2,7],[2,3,2,4],[9,11,9,19],[0,11,0,19],[4,11,4,19],[3,11,3,19],[7,11,7,19],[8,3,8,4],[8,5,8,6],[8,7,8,8],[5,5,5,8],[16,1,16,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[14,1,14,9],[15,1,15,9],[5,0,5,3]]}
["Design of Small Bridges & Culverts\n[As per IRC-SP-13 (2022)]",{"$nulls":9},{"$f":"AND(K2:K8)","v":false},{"$f":"\"Overall Data Entry -  \"& IF(Valid,\"Valid & Sufficient, and Design Discharge is Dedtermined & Design Document can be Printed\",\"Invalid/Insufficient\")","v":"Overall Data Entry -  Invalid/Insufficient"}]
["Project/Work",{"$nulls":9},{"$f":"Project<>\"\"","v":false}]
["Program",null,null,"Package/Work_ID",{"$nulls":4},"RD  (km)",null,{"$f":"AND(Program<>\"\",Work_ID<>\"\",CD_ID<>\"\",RD<>\"\")","v":false}]
["Stream/Catchment Details",{"$nulls":9},{"$f":"AND(K5:K6)","v":false},{"$f":"\"Entry of Catchment Area and Boundary Conditions - \" & IF(K4,\"Complete/Valid\",\"Incomplete/Invalid\")","v":"Entry of Catchment Area and Boundary Conditions - Incomplete/Invalid"}]
["Stream","Boundary Conditions",null,null,null,"Width (m)",null,"Average Depth (m)",null,null,{"$f":"AND(Stream_Boundary<>\"\",OR(AND(Stream_Boundary=\"Undefined Channel\",Stream_Width=\"\",Stream_Depth=\"\"),AND(Stream_Boundary<>\"Undefined Channel\",Stream_Width<>\"\",Stream_Depth<>\"\")))","v":false}]
["Catchment Area (Ha)",{"$nulls":4},"Cross Sectional Area of the Stream (sqm)",null,null,null,{"$f":"ROUND(Stream_Width*Stream_Depth,2)","v":0},{"$f":"Catchment_Area<>\"\"","v":false}]
["CD_Type",null,"Proposed Type of Small Bridge/Slab Culvert",{"$nulls":7},{"$f":"AND(CD_ID<>\"\",OR(AND(CD_ID=\"Pipe/Box Culvert\",Proposed_Bridge_Type=\"\"),AND(CD_ID<>\"Pipe/Box Culvert\",Proposed_Bridge_Type<>\"\")))","v":false}]
["Design Discharge(By at least one method)",{"$nulls":9},{"$f":"OR(Direct_Discharge<>\"\",Rational_Valid,AV_Valid,Existing_Valid)","v":false},{"$f":"\"Design Discharge Specification is - \" & IF(K8,\"Complete/Valid\",\"Incomplete/Invalid\")","v":"Design Discharge Specification is - Incomplete/Invalid"}]
[null,null,null,{"$f":"Rational_Valid","v":false},null,{"$f":"AV_Valid","v":false},null,{"$f":"Existing_Valid","v":false}]
[{"$nulls":9},{"$f":"IF(Rational_Valid,1,0)+IF(AV_Valid,1,0)+IF(Existing_Valid,1,0)","v":0},null,{"$f":"\"Flood Discharge is determined by \" & IF(J10=0,\" zero \",IF(J10=1,\" one \",IF(J10=2,\" two \", \" three \"))) & \" methods\"","v":"Flood Discharge is determined by  zero  methods"}]
["Legend"]
[null,"Data Input Cell"]
[null,"On Mouse-Over the Cell, Explanatory Notes on the Cell Data is available"]
[null,"Data Entry Completed/Valid in the adjoining Cell/Row/Procedure"]
[null,"Data Entry Incompleted/Invalid in the adjoining Cell/Row/Procedure"]
["Culvert","Cross Drainage structure having a total length of 6.0 M or less between the interface of dirt walls or extreme vent way boundaries."]
["Small Bridge","Cross Drainage structure having a total length  from 6.0-30.0 M between the interface of dirt walls or extreme vent way boundaries."]

{"sheet":"Parameters-Rational Method","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[10,2,10,8],[0,0,0,9],[6,2,6,8],[7,2,7,8],[9,2,9,8],[1,0,1,9],[2,2,2,8],[3,2,3,8],[4,2,4,8],[5,0,5,1],[5,2,5,9],[8,2,8,8]]}
["Determination of Peak Run-Off/Flood Discharge\n[Design of Small Bridges and Culverts as per IRC-SP-13 (2022)]"]
["Rational Method [Catchment Area & Rainfall (Enter F&T values OR I0 vlaue only)Particulars]"]
["M","Ha","Catchment Area",{"$nulls":6},{"$f":"Catchment_Area","v":0}]
["D","km","Distance from farthest (critical) point on catchment area to structure"]
["H","m","Fall from farthest (critical) point on catchment area to structure"]
["Catchment Area Characteristics"]
["F","cm","Rain Fall of severst storm in return period"]
["T","Hour","Duration of severest rainfall in return period"]
["I0","cm/hour","Calculated Value from F and T",{"$nulls":6},{"$f":"IFERROR(ROUND((Rain_Fall/2)*(1+1/Duration),2),\"\")","v":""}]
["I0","cm/hour","One-Hour Rainfall Intensity of the Region (if F and T values not entered)"]
["I0","cm/hour","Obtained from Above Two Options",{"$nulls":6},{"$f":"IF(J9<>\"\",J9,IF(Direct_Rainfall_Intensity<>\"\",Direct_Rainfall_Intensity,\"\"))","v":""}]
[{"$nulls":9},{"$f":"AND(Catchment_Area<>\"\",Critical_Distance<>\"\",Critical_Fall<>\"\",Catchment_Characterstics<>\"\",Rainfall_Intensity<>\"\")","v":false}]

{"sheet":"Parameters-Area_Velocity Method","index":3,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,1,6,8],[1,0,1,9],[2,0,2,1],[2,2,2,9],[0,0,0,9],[3,0,3,8],[4,2,4,8],[5,2,5,8]]}
["Determination of Peak Run-Off/Flood Discharge\n[Design of Small Bridges and Culverts as per IRC-SP-13 (2022)]"]
["Areav-Velocity/Conveyance Factor Method [Charactristics of Stream and Cross Section & Slope]"]
["Rugosity Condition of the Stream"]
["Rugosity Condition of the Stream Surface"]
["A","sqm","Cross Sectional Area of the Stream @ MFL"]
["P","m","Wetted Perimeter @ MFL"]
["S",{"$f":"\"Slope of the Stream taken over not less than \" & CS_Distance(Catchment_Area) & \" meters on both U/S and D/S of the CD work Location\"","v":"Slope of the Stream taken over not less than 100 meters on both U/S and D/S of the CD work Location"}]
[{"$nulls":9},{"$f":"AND(Rugosity_Stream<>\"\",Rugosity_Surface<>\"\",Stream_Area_AV<>\"\",Wetted_Perimeter<>\"\",Stream_Slope<>\"\")","v":false}]

{"sheet":"Parameters-Existing Structure","index":4,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"merged":[[5,2,5,8],[6,0,6,1],[6,2,6,9],[1,0,1,8],[0,0,0,9],[2,2,2,8],[3,2,3,8],[4,2,4,8]]}
["Determination of Peak Run-Off/Flood Discharge\n[Design of Small Bridges and Culverts as per IRC-SP-13 (2022)]"]
["Flood Marks on Existing Structure Method  (if any within 500 m of selected site)",{"$nulls":8},{"$f":"AND(Stream_Width_Bridge<>\"\",Linear_Waterway_Bridge<>\"\",Afflux_Bridge<>\"\",Depth_DS_Bridge<>\"\",Bridge_Type<>\"\")","v":false}]
["w","m","Un-Obstrcted width of the Stream at Bridge @ MFL"]
["L","m","Linear Waterway of the Bridge Structure "]
["h","m","Afflux (Upstream Depth - Downstream Depth: Du - Dd) @ MFL"]
["Dd","m","Depth (Average) of the Stream Downstream of the Bridge @ MFL"]
["Existing Bridge Type"]

{"sheet":"Lacey Regime Section","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[[6,2,6,5],[7,2,7,5],[8,2,8,5],[3,0,3,6],[0,2,0,5],[1,2,1,5],[2,2,2,5],[4,2,4,5],[5,2,5,5]]}
["Symbol","Units","Parameter",null,null,null,"Value"]
["Q","cum/sec","Design Discharge",null,null,null,{"$f":"Design_Discharge","v":0}]
["ksf",null,"Lacey' Silt Factor",null,null,null,{"$f":"Lacey_Silt_Factor","v":0}]
["Regime Section "]
["P","m","Wetted Perimeter",null,null,null,{"$f":"ROUND(4.8*G2^0.5,2)","v":0}]
["R","m","Hydraulic Mean Radius/Depth",null,null,null,{"$f":"IFERROR(ROUND(0.473*(G2/Lacey_Silt_Factor)^(1/3),2),0)","v":0}]
["S",null,"Longitudinal Slope",null,null,null,{"$f":"IFERROR(ROUND((0.0003*(Lacey_Silt_Factor)^(5/3))/G2^(1/6),2),0)","v":0}]
["V","m/s","Velocity",null,null,null,{"$f":"ROUND(0.44*(G2^(1/6))*Lacey_Silt_Factor^(1/3),2)","v":0}]
["A","sqm","Cross Sectional Area",null,null,null,{"$f":"IFERROR(ROUND(2.3*(G2^(5/6))/(Lacey_Silt_Factor^(1/3)),2),0)","v":0}]

{"sheet":"Q-Flood Discharge","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[11,0,11,6],[1,0,1,6],[4,0,4,5],[5,0,5,5],[6,0,6,5],[8,0,8,5],[2,0,2,5],[7,0,7,5]]}
[]
[{"$f":"\"Name of the Project/Work: \"&Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
["Determination of Flood Discharge/Peak-Runoff"]
[]
["By Rational Method",{"$nulls":5},{"$f":"Q_Rational","v":0}]
["By Conveyance-Factor (Area-Velocity) Method",{"$nulls":5},{"$f":"Q_Area_Velocity","v":0}]
["By Flood Marks on Exsting Structure",{"$nulls":5},{"$f":"Q_Floodmarks","v":0}]
["By Direct Entry",{"$nulls":5},{"$f":"Direct_Discharge","v":0}]
["Flood Discharge [as per 6.2.1 of IRC-SP-13 (2022)]",{"$nulls":5},{"$f":"IF(G8>0,G8,IF(SUM(G5:G7) = MAX(G5:G7), MAX(G5:G7),IF(MAX(G5:G7) > 1.5*LARGE(G5:G7,2),1.5*LARGE(G5:G7,2),MAX(G5:G7))))","v":0}]
[{"$nulls":6},"cum/sec"]
[]
["Note: Flood discharges can be estimated in three different ways - Rational Method, Conveyance Factor (Area-Velocity) Method, and from Flood marks on existing structure. The values obtained should be compared.  The highest of these values should be adopted as the design discharge Q, provided it does not exceed the next  highest discharge by more than 50%. If it does then restrict to that limit. That is 1.50 times the second highest value"]

{"sheet":"Design","index":7,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":true,"merged":[[32,2,32,10],[70,2,70,10],[71,2,71,10],[72,2,72,10],[73,2,73,10],[65,2,65,10],[64,2,64,11],[66,2,66,10],[67,2,67,10],[68,2,68,10],[69,2,69,10],[61,2,61,11],[58,2,58,10],[51,2,51,10],[53,2,53,11],[54,2,54,10],[56,2,56,10],[57,2,57,10],[38,2,38,10],[46,2,46,11],[40,2,40,10],[41,2,41,10],[42,2,42,10],[43,2,43,10],[55,2,55,10],[3,9,3,11],[2,2,2,10],[0,2,0,11],[1,2,1,11],[15,2,17,10],[12,2,12,10],[13,2,13,10],[14,2,14,10],[6,2,6,11],[11,2,11,11],[16,11,17,11],[3,2,3,8],[4,2,4,10],[9,2,9,10],[30,11,31,11],[29,2,31,10],[25,2,25,11],[26,2,26,10],[27,2,27,10],[28,2,28,10],[22,2,24,10],[19,2,19,10],[21,2,21,10],[18,2,18,11],[23,11,24,11],[20,2,20,10],[62,2,62,6],[59,2,59,10],[44,2,44,10],[5,2,5,11],[8,2,8,10],[10,2,10,10],[48,2,48,10],[49,2,49,10],[50,2,50,10],[47,2,47,10],[33,2,33,10],[34,2,34,10],[36,2,36,11],[37,6,37,11],[37,2,37,5],[39,2,39,10]]}
[null,null,"Design of Cross Drainage Structure"]
[null,null,{"$f":"\"Name of the Project/Work: \" & Project & \" at km \" & RD","v":"Name of the Project/Work:  at km "}]
[null,null,"Q (cum/sec) = Design Discharge =",{"$nulls":8},{"$f":"Design_Discharge","v":0}]
[null,null,"Stream Boundary (Bed and Banks) Condition (Rigid/Alluvial)",{"$nulls":6},{"$f":"Stream_Boundary","v":0}]
["Silt Factor",null,"ksf = Lacey's Silt Factor for Alluvial and Quasi-Alluvial Streams",{"$nulls":8},{"$f":"Lacey_Silt_Factor","v":0}]
["Header_LWW",null,"Determination of Linear Water Way (L) and Normal Scour Depth (dsm)\n[considering stream contraction if any]"]
["Rigid_Boundaries",null,"Stream with Rigid Boundaries (Consisting of non-erodible banks and bed)"]
["Rigid_Boundaries"]
["Rigid_Boundaries",null,"W (m) = Width between Rigid Boundaries",{"$nulls":8},{"$f":"IF(Stream_Boundary=\"Rigid Boundaries\", Stream_Width,0)","v":0}]
[null,null,"L (m) = Linear Water Way (Default Value is Stream Width)",{"$nulls":8},{"$f":"L9","v":0}]
["Rigid_Boundaries",null,"dsm (m) = Average Normal Scour Depth = Cross Scetion Area/Width = A/W =",{"$nulls":8},{"$f":"IFERROR(ROUND(Stream_Area/Stream_Width,2),0)","v":0}]
["Alluvial_Wide",null,"Wholly Alluvial Wide Stream \n(Consisting of erodible banks and bed with width very large compared to depth)"]
["Alluvial_Wide",null,"W (m) = Lacey's Regime Width = Lacey's Wetted Perimeter P =",{"$nulls":8},{"$f":"IF(Stream_Boundary = \"Alluvial (Wide)\",ROUND(4.8*SQRT(Design_Discharge),2),0)","v":0}]
["Alluvial_Wide",null,"L (m) = Linear Water Way (Limited by the Lacey's Regime Width above)",{"$nulls":8},{"$f":"L13","v":0}]
["Alluvial_Wide",null,"Db (cum/sec per meter width) = Discharge/m = Q/L",{"$nulls":8},{"$f":"IFERROR(ROUND(Design_Discharge/L14,2),0)","v":0}]
["Alluvial_Wide",null,"dsm (m) = Average Normal Scour Depth (considering stream contraction if any) ="]
["Alluvial_Wide",{"$nulls":10},{"$f":"IFERROR(ROUND(1.34*(L15^2/Lacey_Silt_Factor)^0.333,2),0)","v":0}]
["Alluvial_Wide"]
["Quasi_Alluvial",null,"Quasi-Alluvial Stream \n(Consisting of non-erodible banks and erodible bed)"]
["Quasi_Alluvial",null,"W (m) = Width between Boundaries",{"$nulls":8},{"$f":"IF(Stream_Boundary=\"Quasi-Alluvial\", Stream_Width,0)","v":0}]
[null,null,"L (m) = Linear Water Way (Default Value is Stream Width)",{"$nulls":8},{"$f":"L20","v":0}]
["Quasi_Alluvial",null,"Db (cum/sec per meter width) = Discharge/m = Q/L",{"$nulls":8},{"$f":"IFERROR(ROUND(Design_Discharge/L21,2),0)","v":0}]
["Quasi_Alluvial",null,"dsm (m) = Average Normal Scour Depth (considering stream contraction if any) ="]
["Quasi_Alluvial",{"$nulls":10},{"$f":"IFERROR(ROUND(1.34*(L22^2/Lacey_Silt_Factor)^0.333,2),0)","v":0}]
["Quasi_Alluvial"]
["Alluvial_Non_Wide",null,"Wholly Alluvial Non-Wide Stream \n(Consisting of erodible banks and bed where width  is NOT large compared to depth)"]
["Alluvial_Non_Wide",null,"W (m) =Lacey's Regime Width for non-wide streams [Proportional to Lacey's Wetted Perimeter]",{"$nulls":8},{"$f":"IFERROR(IF(Stream_Boundary = \"Alluvial (Non-Wide)\", MIN(Stream_Width,Stream_Width*4.8*SQRT(Design_Discharge)/(Stream_Width + 2*Stream_Depth)),0),0)","v":0}]
["Alluvial_Non_Wide",null,"L (m) = Linear Water Way as per site conditions",{"$nulls":8},{"$f":"L27","v":0}]
["Alluvial_Non_Wide",null,"Db (cum/sec per meter width) = Discharge/m = Q/L",{"$nulls":8},{"$f":"IFERROR(ROUND(Design_Discharge/L28,2),0)","v":0}]
["Alluvial_Non_Wide",null,"dsm (m) = Average Normal Scour Depth (considering stream contraction if any) ="]
["Alluvial_Non_Wide",{"$nulls":10},{"$f":"IFERROR(ROUND(1.34*(L29^2/Lacey_Silt_Factor)^0.333,2),0)","v":0}]
["Alluvial_Non_Wide"]
[null,null,"W (m) = Un-Obstructed Width/Regime Width of Stream = ",{"$nulls":8},{"$f":"L9+L13+L20+L27","v":0}]
["LWW_ScourDepth",null,"∴ L (m) = Linear Water Way = ",{"$nulls":8},{"$f":"L10+L14+L21+L28","v":0}]
["LWW_ScourDepth",null,"∴ dsm (m) = Average Normal Scour Depth (considering stream contraction if any) = ",{"$nulls":8},{"$f":"L11+L17+L24+L31","v":0}]
[]
["Header_MaxScour",null,"Determination of Maximum Scour Depth \n[considering stream contraction if any]"]
["Alluvial_MaxScour",null,"Stream in Straight Reach/Bends",{"$nulls":9},"Mandatory Field"]
["Alluvial_MaxScour",null,"Overtopping/Outflanking Condition at Banks OR Spans are Small",{"$nulls":9},"Optional Field"]
["Alluvial_MaxScour",null,"Maximum depth of observed scour hole (beyond normal scour depth if any)  in the bed (m)",{"$nulls":9},"Optional Field"]
["Alluvial_MaxScour",null,"Maximum Scour Depth at Piers ",{"$nulls":8},{"$f":"ROUND(MAX(2*L35,L40),2)","v":0}]
["Alluvial_MaxScour",null,"Maximum Scour Depth at Abutments",{"$nulls":8},{"$f":"ROUND(MAX(IF(OR(G38=\"Stream is located in 'Bends' with 'Cross Currents'\",L39=\"Yes\"),2*L35,1.27*L35),L40),2)","v":0}]
["Rigid_MaxScour",null,"Since the Stream has rigid bed the Maximum Scour Depth at piers & abutments is deemed the Depth of the Stream itself",{"$nulls":8},{"$f":"L35","v":0}]
["MaxScour",null,"∴ Maximum Scour Depth at Piers",{"$nulls":8},{"$f":"IF(Stream_Boundary=\"Rigid Boundaries\",$L$43,L41)","v":0}]
["MaxScour",null,"∴ Maximum Scour Depth at abutments",{"$nulls":8},{"$f":"IF(Stream_Boundary=\"Rigid Boundaries\",$L$43,L42)","v":0}]
[]
["Strata",null,"Determination of Soil Strata for Open Foundations"]
["Strata",null,"Enter in any one of the following 3 cells",{"$nulls":8},{"$f":"IF(L49=\"\",0,1)+IF(L50=\"\",0,1)+IF(L51=\"\",0,1)","v":0}]
["Strata",null,"Depth at which Hard Rock with 10 MPa bearing capacity available within 2 m from Max. Scour Depth"]
["Strata",null,"Depth at which SDR etc available within 2 m from Max. Scour Depth"]
["Strata",null,"Depth at which required bearing capacity for foundations is available in ordinary soils from Max. scour depth"]
["Strata",null,{"$f":"\"Depth of Foundations from Maximum Scour depth - \"&IF(L49<>\"\",\"Anchor the foundations 0.60 m in hard rock\",IF(L50<>\"\",\"Anchor the foundations in SDR/strong soils for 1.50 m\",\" in Ordinary Soils\"))","v":"Depth of Foundations from Maximum Scour depth -  in Ordinary Soils"},{"$nulls":8},{"$f":"IF(L49<>\"\",L49,IF(L50<>\"\",L50,MAX(2,L51)))","v":2}]
[]
["Foundation_Spans",null,"Determination of Depth of Foundations (m) "]
["Foundation_Spans",null,{"$f":"\"Required Vertical Clearance/Free Board (mm) for the given Design Discharge \" & Design_Discharge & \" =\"","v":"Required Vertical Clearance/Free Board (mm) for the given Design Discharge 0 ="},{"$nulls":8},{"$f":"Vertical_Clearance(Design_Discharge)","v":150}]
[null,null,"Afflux (In case of Bridge Contraction -> Linear Water Way < Unobstructed/Regime Width of Channel) in mm",{"$nulls":8},{"$f":"IF(Linear_Waterway<Regime_Width,1000*MAX(Afflux,0),0)","v":0}]
["Foundation_Spans",null,"∴ Total Depth of Foundations (m) at piers, including vertical clearance, from MFL",{"$nulls":8},{"$f":"ROUND(Max_Scour_Depth_Pier+$L$52+($L$55+$L$56)/1000,2)","v":2.15}]
["Foundation_Spans",null,"∴ Total Depth of Foundations (m) at Abutments, including vertical clearance, from MFL",{"$nulls":8},{"$f":"ROUND(Max_Scour_Depth_Abutment+$L$52+$L$55/1000,2)","v":2.15}]
["Foundation_Spans",null,"Economical Span (M) = 1.50 x Total Depth of Foundations",{"$nulls":8},{"$f":"CEILING(1.5*L58,0.25)","v":3.25}]
["Foundation_Spans",null,"Total Discharge Area = Linear Water Way x (Total Depth of Fondation - Max. Scour Depth - Vertical Clearance) =",{"$nulls":8},{"$f":"Linear_Waterway*(MAX(Foundation_Depth_Pier,Foundation_Depth_Abutment) - MIN(Max_Scour_Depth_Pier,Max_Scour_Depth_Abutment) - (L55/1000))","v":0}]
["Foundation_Spans"]
["Foundation_Spans",null,"Determination of Vents and Span of Slab Culverts/Small Bridges "]
["Foundation_Spans",null,{"$f":"\"Hence Provide \" & CD_ID & \" of \"","v":"Hence Provide  of "},{"$nulls":4},{"$f":"CEILING(Linear_Waterway/Span,1)","v":0},"Vents of",{"$f":"L59","v":3.25},"m Span",{"$f":"IFERROR(ROUND(H63*J63/Linear_Waterway,2),\"\")","v":""}]
[]
["Design_Summary",null,"Summary of Design Parameters"]
["Design_Summary",null,"Parameter",{"$nulls":8},"Value"]
["Design_Summary",null,"Linear Waterway (m)",{"$nulls":8},{"$f":"Linear_Waterway","v":0}]
["Design_Summary",null,"Normal Scour Depth (m)",{"$nulls":8},{"$f":"Normal_Scour_Depth","v":0}]
["Design_Summary",null,"Maximum Scour Depth (m) at Piers",{"$nulls":8},{"$f":"Max_Scour_Depth_Pier","v":0}]
["Design_Summary",null,"Maximum Scour Depth (m) at Abutments",{"$nulls":8},{"$f":"Max_Scour_Depth_Abutment","v":0}]
["Design_Summary",null,{"$f":"\"Foundation Depth at Piers \"&IF($L$49<>\"\",\"(Anchor to a depth of 0.60 m in Hard Rock)\",IF($L$50<>\"\",\"(Anchor to a depth of 1.50 m in SDR/Non-erodible strata)\",\"(In Ordinary Soils)\"))","v":"Foundation Depth at Piers (In Ordinary Soils)"},{"$nulls":8},{"$f":"Foundation_Depth_Pier","v":2.15}]
["Design_Summary",null,{"$f":"\"Foundation Depth at Abutments \"&IF($L$49<>\"\",\"(Anchor to a depth of 0.60 m in Hard Rock)\",IF($L$50<>\"\",\"(Anchor to a depth of 1.50 m in SDR/Non-erodible strata)\",\"(In Ordinary Soils)\"))","v":"Foundation Depth at Abutments (In Ordinary Soils)"},{"$nulls":8},{"$f":"Foundation_Depth_Abutment","v":2.15}]
["Design_Summary",null,{"$f":"\"No. of \" & IF(OR(CD_ID = \"Piped Causeway\",CD_ID = \"Pipe Culvert\"), \"Rows\",\"Vents\")","v":"No. of Vents"},{"$nulls":8},{"$f":"Vents","v":0}]
["Design_Summary",null,{"$f":"IF(OR(CD_ID = \"Piped Causeway\",CD_ID = \"Pipe Culvert\"), \"Diameter\",\"Span\") & \" in m\"","v":"Span in m"},{"$nulls":8},{"$f":"Span","v":3.25}]
["Design_Summary"]

{"sheet":"Lacey's Silt Factor","index":8,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,2,0,7],[19,2,19,7],[20,2,20,5],[21,2,21,5],[37,2,37,7],[5,6,5,7],[16,2,16,7],[6,2,6,7],[23,2,23,7],[33,2,33,4],[34,2,34,6],[36,2,36,6],[2,2,2,7],[5,2,5,5],[11,2,11,4],[12,2,12,4],[38,2,38,6],[39,2,39,6],[14,2,14,6],[7,2,7,7],[15,2,15,7],[8,2,8,3],[8,5,8,6],[9,2,9,4],[10,2,10,4]]}
[null,null,{"$f":"\"Name of the Project/Work: \"&Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
[]
[null,null,"Determination of Lacey's Silt Factor ksf"]
[null,null,"Enter Directly value of Lacey's Silt Factor if available",{"$nulls":5},"OR"]
[]
["Methods",null,"Nature of Bed Material"]
[]
["Clayey",null,"Set Parameters for Clayey Soils"]
["Clayey",null,"Angle of Repose ϕ(o)",null,null,"Cohesiveness (kg/cm2) (c)"]
["Clayey",null,"ϕ Value",null,null,"F","∴  F =",{"$f":"IF(OR(E9=\"\",H9=\"\"),0,IF(E9<=5,2,IF(E9<=10,1.75,1.5)))","v":0}]
["Clayey",null,"Up to 5o",null,null,2]
["Clayey",null,"Above 5o, but up to 10o",null,null,1.75]
["Clayey",null,"Above 10o, but up to 15o",null,null,1.5]
["Clayey"]
["Clayey",null,"∴ Lacey's Silt Factor  =",{"$nulls":4},{"$f":"ROUND(H10*(1+SQRT(H9)),3)","v":0}]
["Non-Clayey",null,"Set method of Determination of silt factor for Non-Clayey Soils"]
["Non-Clayey"]
[]
[]
["Empirical",null,"Method : Empirically based on the type of bed material"]
["Empirical",null,"Select type of bed material",null,null,null,"dm","ksf"]
["Empirical",{"$nulls":5},{"$f":"IFERROR(VLOOKUP(Stream_Bed_Material,Lacey_Factors,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Stream_Bed_Material,Lacey_Factors,7,FALSE),0)","v":0}]
["Empirical"]
["Sieve Analysis",null,"Method : From the sieve analysis of the bed material\n[As per Appendix 2 of IRC-5/Plate 4 of IRC-SP-13 (2022)]"]
["Sieve Analysis",null,"IS Sieve","Sieve Opening (mm)","Average Size of Particle (mm)","Weight of Soil Retained (gm)","% Weight of Soil Retained ","Weighted Mean dia of Soil Particle(%)"]
["Sieve Analysis",null,"5.6 mm",5.6,0,0,{"$f":"IFERROR(ROUND(100*F26/$F$34,2),0)","v":0},{"$f":"ROUND(E26*G26,3)","v":0}]
["Sieve Analysis",null,"4 mm",4,{"$f":"AVERAGE(D26,D27)","v":4.8},null,{"$f":"IFERROR(ROUND(100*F27/$F$34,2),0)","v":0},0]
["Sieve Analysis",null,"2.8 mm",2.8,{"$f":"AVERAGE(D27,D28)","v":3.4},null,0,0]
["Sieve Analysis",null,"1 mm",1,1.9,null,0,0]
["Sieve Analysis",null,"425 µ",0.42499999999999999,0.71250000000000002,null,0,0]
["Sieve Analysis",null,"180 µ",0.18,0.30249999999999999,null,0,0]
["Sieve Analysis",null,"75 µ",7.4999999999999997E-2,0.1275,null,0,0]
["Sieve Analysis",null,"PAN",0,3.7499999999999999E-2,null,0,0]
["Sieve Analysis",null,"Total Weight of Sample",null,null,{"$f":"SUM(F26:F33)","v":0},{"$f":"SUM(G26:G33)","v":0},{"$f":"SUM(H26:H33)","v":0}]
["Sieve Analysis",null,"Weighted Mean Diameter (mm) of the bed soil dm =",{"$nulls":4},{"$f":"ROUND(H34/100,3)","v":0}]
["Sieve Analysis"]
["Sieve Analysis",null,"∴ Lacey's Silt Factor =",{"$nulls":4},{"$f":"ROUND(1.76*SQRT(H35),3)","v":0}]
["Mean Dia",null,"Method : Based on Mean Diameter of Bed Material"]
["Mean Dia",null,"Mean Dia of Bed Material dm (mm) "]
["Mean Dia",null,"∴ Lacey's Silt Factor =",{"$nulls":4},{"$f":"ROUND(1.76*(H39)^0.5,3)","v":0}]
[]
[{"$nulls":7},{"$f":"ROUND(H4+H22+H37+H40+H15,3)","v":0}]

{"sheet":"Q-Rational Method","index":9,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":true,"merged":[[18,0,21,0],[13,0,13,3],[0,0,0,3],[1,0,1,3],[10,0,12,0],[7,0,7,3],[10,3,12,3],[6,1,6,3]]}
[{"$f":"\"Name of the Project/Work: \" &Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
["Estimation of Flood Discharge from Catchment Area and Rainfall Characteristics by Rational Method"]
["Symbol","Description","Value","Units"]
["M","Catchment Area",{"$f":"Catchment_Area","v":0},"Ha"]
["D","Distance from farthest (critical) point on catchment area to structure",{"$f":"Critical_Distance","v":0},"km"]
["H","Fall from farthest (critical) point on catchment area to structure",{"$f":"Critical_Fall","v":0},"m"]
["Catchment Characteristics",{"$f":"Catchment_Characterstics","v":0}]
["Determination of One-Hour Rainfall Intensity (I0) for the Region based on severest storm of Return Period"]
["F","Rain Fall of severst storm in return period",{"$f":"Rain_Fall","v":0},"cm"]
["T","Duration of severest rainfall in return period",{"$f":"Duration","v":0},"Hour"]
["I0\n[Rainfall Intensity]","One-Hour Rain Fall Intensity\n of the Region",{"$f":"IFERROR((C9/2)*(1+ 1/C10),\"\")","v":""},"cm/hour"]
[null,"OR Enter Value of I0 Directly",{"$f":"Direct_Rainfall_Intensity","v":0}]
[null,"∴ One-Hour Rainfall Intensity I0 =",{"$f":"IF(C11<>\"\",C11,IF(C12<>\"\",C12,\"\"))","v":0}]
["Calculations"]
["tc","Concentration Time =",{"$f":"IFERROR(ROUND((0.87*(Critical_Distance^3)/Critical_Fall)^0.385,3),\"\")","v":""},"Hour"]
["IC","Critical Intensity of rainfall corresponding to concentration time",{"$f":"IFERROR(ROUND(One_Hour_Rainfall*(2/(1+Concentration_Time)),3),\"\")","v":""},"cm/hour"]
["P","Run_Off Coefficient for the given Catchment",{"$f":"IFERROR(VLOOKUP(B7,Run_Off_Coefficient,2,FALSE),\"\")","v":""}]
["f","Mean Intensity Factor = function of Area of Catchment",{"$f":"ROUND(Interpolated_Value(Catchment_Area,Area_Mean_Intensity,2),4)","v":1}]
["Q","Peak Run-Off = "]
[null,"="]
[null,"Let λ= ",{"$f":"IFERROR(ROUND((0.056*Mean_Intensity_Factor*Coefficient_Runoff)/(1+Concentration_Time),3),\"\")","v":""}]
[null,"=",{"$f":"IFERROR(ROUND(Catchment_Area*One_Hour_Rainfall*Lambda,3),0)","v":0},"cum/sec"]

{"sheet":"Q-AV Method","index":10,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[[12,2,12,9],[11,2,11,9],[0,0,0,10],[8,2,8,9],[9,2,9,9],[10,2,10,9],[5,0,5,9],[3,2,3,9],[4,2,4,10],[7,2,7,9],[1,0,1,10],[2,0,2,10],[4,0,4,1],[6,2,6,9]]}
[{"$f":"\"Name of the Project/Work: \" & Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
["Estimation of Maximum Flood Discharge from Stream Conveyance Factor and Slope"]
["Charactristics of Stream and Cross Section & Slope"]
["Symbol","Units","Description",{"$nulls":7},"Value"]
["Rugosity Stream",null,{"$f":"Rugosity_Stream","v":0}]
["Stream Surface",{"$nulls":9},{"$f":"Rugosity_Surface","v":0}]
["S",null,"Stream Slope",{"$nulls":7},{"$f":"Stream_Slope","v":0}]
["n",null,"Coefficient of Rugosity (Manning's Formula) for given Stream type and surface as per table 5.1 of IRC SP-13",{"$nulls":7},{"$f":"IFERROR(INDEX(Rugosity_Coefficients,MATCH(C5,Rugosity_Streams,FALSE),MATCH(K6,Rugosity_Surfaces,FALSE)),\"\")","v":""}]
["A","m2","Cross Sectional Area of the Stream for MFL (Maximum Flood Level)",{"$nulls":7},{"$f":"Stream_Area_AV","v":0}]
["P","m","Wetteted Perimeter of the Stream for MFL (Maximum Flood Level)",{"$nulls":7},{"$f":"Wetted_Perimeter","v":0}]
["R","m","Hydraulic Mean Depth/Radius of the Stream = Cross Sectional Area (A)/Wetted Perimeter (P) =",{"$nulls":7},{"$f":"IFERROR(ROUND(K9/K10,2),0)","v":0}]
["V","m/s","Velocity of the Stream as per Manning's formula = ",{"$nulls":7},{"$f":"IFERROR(ROUND((K11^(2/3))*(K7^0.5)/K8,2),0)","v":0}]
["Q","cum/sec","Maximum Flood Discharge = Cross Sectional Area (A) x Velocity (V) =",{"$nulls":7},{"$f":"ROUND(K9*K12,2)","v":0}]

{"sheet":"Q-Flood Marks","index":11,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,0,1,9],[2,0,2,9],[35,0,35,7],[34,0,34,8],[11,1,11,6],[26,7,26,9],[30,7,30,9],[23,0,23,9],[33,0,33,7],[22,1,22,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[16,1,16,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5]]}
[]
[{"$f":"\"Name of the Project/Work: \"&Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
["Determination of Flood Discharge based on Flood Marks on Existing Bridge Structure"]
["Discharge Upstream of Bridge"]
[]
["Discharge through the Bridge - Weir Formula"]
[]
[]
["Discharge through the Bridge - Orifice Formula"]
[]
["Where"]
[null,"Q = Discharge in cum/sec & u = Approach Velocity in m/s"]
[null,"W = Un-Obstructed Width of the Stream in m",{"$nulls":4},{"$f":"Stream_Width_Bridge","v":0}]
[null,"L = Linear Waterway of the Bridge",{"$nulls":4},{"$f":"Linear_Waterway_Bridge","v":0}]
[null,"Dd = Downstream Depth of stream in m",{"$nulls":4},{"$f":"Depth_DS_Bridge","v":0}]
[null,"h = Afflux of the stream in m",{"$nulls":4},{"$f":"Afflux_Bridge","v":0}]
[null,"h/Dd =",{"$nulls":4},{"$f":"IFERROR(ROUND(G16/G15,3),0)","v":0}]
[null,"Du = Upstream Depth of stream in m = Dd + h =",{"$nulls":4},{"$f":"G15+G16","v":0}]
[null,"A = Cross Sectional Area of the Stream in sqm = WDu",{"$nulls":4},{"$f":"ROUND(G13*G18,3)","v":0}]
[null,"L/W = Ratio for determination of Orifice Formula coefficients ",{"$nulls":4},{"$f":"IFERROR(ROUND(G14/G13,3),0)","v":0}]
[null,"Cw = Coefficient of Standing Wave ",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(Bridge_Type,Weir_Coefficients,2,FALSE),0)","v":0}]
[null,"C0 = f(L/W) =",{"$nulls":4},{"$f":"IFERROR(ROUND(Interpolated_Value(Contraction_Bridge,Orifice_Coefficients,3),3),0)","v":0}]
[null,"e = f(L/W) = ",{"$nulls":4},{"$f":"IFERROR(ROUND(Interpolated_Value(Contraction_Bridge,Orifice_Coefficients,2),3),0)","v":0}]
["Equating Upstream Discharge and Discharge through the Bridge and rearranging the same for approach velocity 'u' and solving by iteration"]
[]
[]
["Weir Formula",{"$nulls":4},{"$f":"\"=\"","v":"="},{"$f":"IFERROR(ROUND(1.706*Weir_CW*Linear_Waterway_Bridge/Cross_Section_US,3),0)","v":0},{"$f":"\"x[\" &Depth_US&\" + square(u)/19.60]^3/2 =\"","v":"x[0 + square(u)/19.60]^3/2 ="}]
[{"$nulls":7},{"$f":"U_Weir","v":0},{"$f":"G27*(Depth_US+(H28^2/19.6))^1.5","v":0},"m/sec"]
[]
[]
["Orifice Formula",{"$nulls":4},{"$f":"\"=\"","v":"="},{"$f":"IFERROR(ROUND(G22*(2*9.8)^0.5*G14*G15/G19,3),0)","v":0},{"$f":"\"x[\"&Afflux_Bridge&\"+(1+\"&Orifice_e&\")Square(u)/19.60]^0.50 =\"","v":"x[+(1+0)Square(u)/19.60]^0.50 ="}]
[{"$nulls":7},{"$f":"U_Orifice","v":0},{"$f":"G31*(Afflux_Bridge+(1+Orifice_e)*(H32^2/19.6))^0.5","v":0},"m/sec"]
[]
["∴ Approach Velocity u=",{"$nulls":7},{"$f":"ROUND(IF(Afflux_Ratio>0.25,MAX(U_Weir,U_Orifice),U_Orifice),2)","v":0},"m/sec"]
["Note: If h/Dd >0.25, then Approach Velocity is given by maximum of that given by Weir & Orifice Formulas, Else it is given by Orifice Formula"]
["Q = Flood Discharge based on Flood Markings on existing structure = Au =",{"$nulls":7},{"$f":"ROUND(Cross_Section_US*Approach_Velocity,2)","v":0},"cum/sec"]

{"sheet":"Afflux","index":12,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,9],[1,0,1,9],[11,1,11,5],[12,1,12,5],[13,1,13,5],[33,0,33,8],[34,0,34,7],[10,1,10,5],[16,1,16,5],[17,1,17,5],[19,0,19,9],[28,7,28,9],[32,0,32,7],[14,1,14,5],[15,1,15,5],[24,0,24,7],[20,0,20,3],[26,0,26,3],[30,0,30,7]]}
[{"$f":"\"Name of the Project/Work: \"&Project&\" at km \"&RD","v":"Name of the Project/Work:  at km "}]
["Determination of Afflux through the Bridge"]
["Discharge Upstream of Bridge"]
[]
["Discharge through the Bridge - Weir Formula"]
[]
[]
["Discharge through the Bridge - Orifice Formula"]
[]
["Where"]
[null,"Q = Discharge in cum/sec",{"$nulls":4},{"$f":"Design_Discharge","v":0}]
[null,"W = Un-Obstructed Width of the Stream in m",{"$nulls":4},{"$f":"Regime_Width","v":0}]
[null,"L = Linear Waterway of the Bridge in m",{"$nulls":4},{"$f":"Linear_Waterway","v":0}]
[null,"Dd = Depth of stream in m",{"$nulls":4},{"$f":"Stream_Depth","v":0}]
[null,"L/W = Ratio for determination of Orifice Formula coefficients ",{"$nulls":4},{"$f":"IFERROR(ROUND(G13/G12,3),0)","v":0}]
[null,"Cw = Coefficient of Standing Wave(as per proposed bridge type)",{"$nulls":4},{"$f":"IFERROR(VLOOKUP(Proposed_Bridge_Type,Weir_Coefficients,2,FALSE),0)","v":0}]
[null,"C0 = f(L/W) =",{"$nulls":4},{"$f":"IFERROR(ROUND(Interpolated_Value(Contraction_Proposed_Bridge,Orifice_Coefficients,3),3),0)","v":0}]
[null,"e = f(L/W) = ",{"$nulls":4},{"$f":"IFERROR(ROUND(Interpolated_Value(Contraction_Proposed_Bridge,Orifice_Coefficients,2),3),0)","v":0}]
[null,"h = Afflux of the stream in m (Post-Construction)"]
["Equating Upstream Discharge and Discharge through the Bridge and rearranging the same for Afflux 'h' and solving by iteration"]
["Afflux Calculation by Weir Formula (m)"]
[]
[]
[{"$nulls":7},{"$f":"U_Weir","v":0}]
[{"$f":"\"= [\"&G11&\"/(1.706 x \" &Weir_CW& \" x \" &G13& \")]^0.667 - (1/2x9.80)[\"&G11&\"/(\"&G12&\" x (\"&G14&\" + h)]^2 - \" & G14 & \" =\"","v":"= [0/(1.706 x 0 x 0)]^0.667 - (1/2x9.80)[0/(0 x (0 + h)]^2 - 0 ="},{"$nulls":7},{"$f":"IFERROR(ROUND(((G11/(1.706*Weir_CW*G13))^(2/3)) - (((G11/(G12*(G14+J25)))^2)/19.6) - G14,2),0)","v":0},{"$f":"Afflux_Weir","v":0}]
[]
["Afflux Calculation by Orifice Formula (m)"]
[]
[]
[]
[{"$f":"\"= (\"&G11&\"^2)/2g) { (1/(\"&Orifice_C0&\" x \" &G13& \" x \" &G14&\")^2) - (1 + \" & Orifice_e&\")/[\"&G12&\"(\"&G14&\" + h)]^2} = \"","v":"= (0^2)/2g) { (1/(0 x 0 x 0)^2) - (1 + 0)/[0(0 + h)]^2} = "},{"$nulls":7},{"$f":"IFERROR(ROUND(((G11^2)/(19.6))*((1/((Orifice_C0*G13*G14)^2))-(1+Orifice_e)/(((G12*(G14+J31))^2))),2),0)","v":0},{"$f":"Afflux_Orifice","v":0}]
[]
["∴ Afflux h=",{"$nulls":7},{"$f":"IFERROR(IF(Afflux_Weir/G14 > 0.25,Afflux_Weir,Afflux_Orifice),0)","v":0},"m"]
["Note: If h/Dd >0.25, then afflux is  given by Weir formula, Else it is given by Orifice Formula"]

{"sheet":"Database","index":13,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,0,0,1],[13,0,13,1],[0,3,1,3],[0,4,0,7],[0,9,0,11],[29,5,29,6],[20,4,20,6],[20,7,20,9],[19,3,19,9],[20,3,21,3]]}
["\nP - Maximum value of Coefficient of Run-off for catchment characteristics\n'Run_Off_Coefficient'",null,null,"Type of Stream","Surface Conditions",{"$nulls":4},"Orifice Energy Coefficient"]
["Catchment Characteristics","P",null,null,"Perfect","Good","Fair","Bad",null,"a/A (L/W)","e","C0"]
["Steep, bare rock and also city pavements",0.9,null,"Clean, straight bank, full stage, no rifts or deep pools",2.5000000000000001E-2,2.75E-2,0.03,3.3000000000000002E-2,null,0.5,1.05,0.89200000000000002]
["Rock, steep but wooded",{"$f":"B3-0.1","v":0.8},null,"Clean, straight bank, full stage, no rifts or deep pools, but with some weeds and stones",0.03,3.3000000000000002E-2,3.5000000000000003E-2,0.04,null,{"$f":"J3+0.05","v":0.55000000000000004},1.03,0.88]
["Plateaus, lightly covered",{"$f":"B4-0.1","v":0.70000000000000007},null,"Winding, some pools and shoals, clean",3.5000000000000003E-2,0.04,4.4999999999999998E-2,0.05,null,{"$f":"J4+0.05","v":0.60000000000000009},1.01,0.87]
["Clayey soils, stiff and bare",0.60000000000000009,null,"Winding, some pools and shoals, clean,  lower stages, more ineffective  slope and sections",0.04,4.4999999999999998E-2,0.05,5.5E-2,null,0.65000000000000013,0.97,0.86499999999999999]
["Clayey soils, stiff and bare lightly covered",0.50000000000000011,null,"Winding, some pools and shoals, clean, but with some weeds and stones",3.3000000000000002E-2,3.5000000000000003E-2,0.04,4.4999999999999998E-2,null,0.70000000000000018,0.92,0.86499999999999999]
["Loam, lightly cultivated or covered",0.40000000000000013,null,"Winding,  some pools and shoals,  clean,   lower stages,  more ineffective slope and stoney sections",4.4999999999999998E-2,0.05,5.5E-2,0.06,null,0.75000000000000022,0.85,0.86699999999999999]
["Loam, largely cultivated or covered",0.30000000000000016,null,"Sluggish river reaches, rather weedy or with very deep pools",0.05,0.06,7.0000000000000007E-2,0.08,null,0.80000000000000027,0.72,0.875]
["Sandy soil, light growth",0.20000000000000015,null,"Very weedy reaches",7.4999999999999997E-2,0.1,0.125,0.15,null,0.85000000000000031,0.5,0.9]
["Sandy soil, light growth covered heavy brush",0.10000000000000014,{"$nulls":7},0.90000000000000036,0.3,0.92500000000000004]
[{"$nulls":9},0.9500000000000004,0.14000000000000001,0.96]
[{"$nulls":9},1.0000000000000004,0,1]
["f - Catchment Area - Mean Intensity factor",null,null,"Bridge Weir Condition","Coefficient Cw"]
["Area (Ha)","f",null,"Narrow Bridge Opening with or without floors",0.94]
[0,1,null,"Wide Bridge Opening with floors",0.96]
[500,0.98329999999999995,null,"Wide Bridge Opening with no bed floors",0.98]
[1000,0.96660000000000001]
[1500,0.9]
[1665,0.88500000000000001,null,"Lacey's Mean Dia (dm) and Silt Factor (f) based on type of Bed Material"]
[2100,0.875,null,"Type of Bed Material","dm",null,null,"f"]
[2600,0.85,null,null,"From","To","Average","From","To","Average"]
[3300,0.84,null,"Coarse Silt",0.04,0.04,{"$f":"AVERAGE(E23,F23)","v":0.04},0.35,0.35,{"$f":"AVERAGE(H23,I23)","v":0.35}]
[3800,0.82499999999999996,null,"Silt/Fine Sand",8.1000000000000003E-2,0.158,{"$f":"AVERAGE(E24,F24)","v":0.1195},0.5,0.6,{"$f":"AVERAGE(H24,I24)","v":0.55000000000000004}]
[5000,0.8,null,"Medium Sand",0.23300000000000001,0.505,0.36899999999999999,0.8,1.25,1.0249999999999999]
[5500,0.79,null,"Coarse Sand",0.72499999999999998,0.72499999999999998,0.72499999999999998,1.5,1.5,1.5]
[6000,0.77500000000000002,null,"Fine Bajri/Sand",0.98799999999999999,0.98799999999999999,0.98799999999999999,1.75,1.75,1.75]
[6665,0.76649999999999996,null,"Heavy Sand",1.29,2,1.645,2,2.42,2.21]
[7000,0.75849999999999995]
[7500,0.75,null,"Stream Boundaries"]
[8335,0.73899999999999999,null,"Undefined Channel"]
[8800,0.73299999999999998,null,"Rigid Boundaries"]
[9400,0.72499999999999998,null,"Alluvial (Wide)"]
[10000,0.72219999999999995,null,"Alluvial (Non-Wide)"]
[11660,0.70499999999999996,null,"Quasi-Alluvial"]
[13330,0.68879999999999997]
[15000,0.67500000000000004]
[16660,0.66659999999999997]
[18330,0.6583]
[20000,0.65]
[21660,0.64439999999999997]
[23330,0.63890000000000002]
[25000,0.63500000000000001]
[26660,0.63329999999999997]
[28830,0.62770000000000004]
[30000,0.625]
[31660,0.62219999999999998]
[33330,0.61799999999999999]
[35000,0.61660000000000004]
[36660,0.61250000000000004]
[38330,0.61]
[40000,0.60499999999999998]
[50000,0.6]