{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Scour Eval Report Form","Drop Down"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":"Scour Eval Report Form","index":0,"n_rows":68,"n_cols":21,"rows_kept":68,"cut":false,"hidden":false,"merged":[[12,5,12,6],[35,5,35,6],[40,12,40,13],[29,12,29,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[23,5,23,6],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[33,5,33,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[2,10,2,15],[20,5,20,19],[23,21,29,26],[35,18,35,19],[36,18,36,19],[37,18,37,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[32,18,32,19],[33,18,33,19],[34,18,34,19],[35,12,35,13],[36,12,36,13],[37,12,37,13],[3,4,3,6],[4,4,4,6],[2,19,2,20],[3,19,3,20],[2,21,2,22],[38,5,38,6],[9,16,10,20],[67,11,67,12],[66,18,66,19],[67,18,67,19],[41,5,41,6],[42,5,42,6],[48,16,48,17],[49,16,49,17],[49,1,49,5],[47,1,47,5],[49,8,49,9],[49,10,49,11],[49,12,49,13],[49,14,49,15],[48,14,48,15],[43,5,43,6],[49,6,49,7],[57,1,63,19],[54,1,54,2],[50,1,50,5],[51,6,51,7],[50,8,50,9],[50,10,50,11],[51,8,51,9],[51,10,51,11],[51,12,51,13],[39,12,39,13],[50,6,50,7],[49,18,49,19],[50,18,50,19],[50,16,50,17],[48,6,48,7],[48,8,48,9],[48,10,48,11],[51,16,51,17],[51,14,51,15],[51,18,51,19],[44,5,44,6],[51,1,51,5],[39,18,39,19],[40,5,40,6],[38,12,38,13],[48,12,48,13],[48,18,48,19],[50,12,50,13],[50,14,50,15],[5,10,5,17],[6,10,6,17],[31,5,31,6],[29,1,30,6],[34,5,34,6],[32,5,32,6],[36,5,36,6],[37,5,37,6],[5,4,5,6],[6,4,6,6],[19,5,19,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[38,18,38,19],[39,5,39,6],[28,18,28,19],[27,12,27,13],[28,12,28,13]]}
[]
[null,"Structure Information:"]
[null,null,null,null,null,null,null,null,null,"Bridge Type:",null,null,null,null,null,null,null,null,"Completed by:"]
[null,null,null,"Structure ID:",null,null,null,null,null,"Span #:",null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,"Year Built:",null,null,null,null,null,"Length [ft]:"]
[null,null,null,"Highway:",null,null,null,null,null,"Abut. Foundation(s):"]
[null,null,null,"Waterbody Crossing:",null,null,null,null,null,"Pier Foundation(s):"]
[]
[null,"Hydraulics:",null,null,null,null,null,null,"Hydrology:",null,null,null,null,null,null,null,"Contraction Scour:"]
[null,null,null,null,"Method (HEC RAS, SMS, etc): ",null,null,null,null,null,null,"Scour Design Flood (flow, RI):",null,"cfs    Q:",null,null," (if computing overbank, print additional sheet(s) as needed)"]
[null,null,null,null,"Geometric Contraction Ratio:",null,null,null,null,null,null,"Scour Check Flood (flow, RI):",null,"cfs    Q:"]
[null,null,null,null,"Thalweg Elevation (at bridge):",null,null,"ft",null,null,null,"Incipient Overtopping Flood:",null,"cfs    Q:",null,null,null,"Scour type:",null,"Live Bed"]
[null,null,null,null,"Water Surface Elevation (at bridge):",null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,"Vertical"]
[null,null,null,null,null,null,null,null,"Geotechnical (values in mm):",null,null,null,null,null,null,null,null,null,null,"Clear Water"]
[null,null,null,null,null,null,null,null,null,null,"Left Overbank:","D50:",null," D84:",null,null,null,null,null,"Cohesive Soil"]
[null,null,null,null,null,null,null,null,null,null,"Main Channel:","D50:",null," D84:"]
[null,null,null,null,null,null,null,null,null,null,"Right Overbank:","D50:",null," D84:"]
[]
[null,"Long Term Aggradation/Degradation:"]
[null,null,null,null,"Estimated LTA/LTD:",null,null,"ft"]
[null,null,null,null,"Comments:"]
[]
[null,"Vertical Contraction (if applicable):",null,null,null,null,null,null,"Approach Section Hydraulics:",null,null,null,null,null,null,"Constricted Section Hydraulics (main channel):"]
[null,null,null,null,"T (Deck Thickness):",null,null,"ft",null,null,null,"Distance U/S of Constriction:",null,null,"ft",null,null,"V2 (avg velocity):",null,null,"ft/s"]
[null,null,null,null,"h0 (vertical opening size):",null,null,"ft",null,null,null,"Vc (critical velocity for D50):",null,null,"ft/s",null,null,"W2 (width of flow):",null,null,"ft"]
[null,null,null,null,"hu (flow depth u/s of bridge):",null,null,"ft",null,null,null,"V1 (average velocity):  ",null,null,"ft/s",null,null,"Q2 (channel flow):",null,null,"cfs"]
[null,null,null,null,"Low Chord elevation:",null,null,"ft",null,null,null,"W1 (width of flow):",null,null,"ft",null,null,"y0 (depth before scour):",null,null,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,"Y1 (avg channel depth):",null,null,"ft",null,null,"y2 (depth after scour):",null,null,"ft"]
[null,"Pier Scour:",null,null,null,null,null,null,null,null,null,"Q1 (flow carrying sediment):",null,null,"cfs",null,null,"ys (contr. scour depth):",null,null,"ft"]
[null,"(if thalweg can migrate, use max main channel hydraulic values)",null,null,null,null,null,null,null,null,null,"S (EGL slope @ approach):",null,null,"ft"]
[]
[null,null,null,null,"Method (HEC 18, Complex, FL):",null,null,null,"Abutment Scour:",null,null,null,null,null,null,"Contraction Scour – Cohesive Soil:"]
[null,null,null,null,"K1 (pier shape):",null,null,null,null,null,null,"Scour Condition (live, clear water):",null,null,null,null,null,"Soil Erodibility Class:"]
[null,null,null,null,"K2 (angle of attack):",null,null,"°",null,null,null,"Scour Condition Location (a or b):",null,null,null,null,null,"n (manning’s roughness):"]
[null,null,null,null,"Bed Condition (plane, dunes, etc):",null,null,null,null,null,null,"Abut Type (spill through, vertical):",null,null,null,null,null,"Y (avg channel depth, U/S):",null,null,"ft"]
[null,null,null,null,"K3 (bed condition):",null,null,null,null,null,null,"q1 (unit discharge approach):",null,null,"cfs",null,null,"V2 (avg velocity):",null,null,"ft/s"]
[null,null,null,null,"a (Pier width):",null,null,"ft",null,null,null,"q2 (unit discharge constricted):",null,null,"cfs",null,null,"τc (critical shear stress):",null,null,"lb/ft2 "]
[null,null,null,null,"L (Pier Length in direction of flow):",null,null,"ft",null,null,null,"y1 (avg depth approach):",null,null,"ft",null,null,"y0 (depth before scour):",null,null,"ft"]
[null,null,null,null,"V1 (velocity directly U/S of pier):",null,null,"ft/s",null,null,null,"y0 (avg depth constricted):",null,null,"ft",null,null,"t (duration of flow):",null,null,"ft"]
[null,null,null,null,"Y1 (depth directly U/S of pier):",null,null,"ft",null,null,null,"ys (abutment scour depth):",null,null,"ft",null,null,"ys (cohesive scour depth):",null,null,"ft"]
[null,null,null,null,"ys (Pier 1 scour depth):",null,null,"ft",null,null,null,"ymax (flow depth incl. abut. scour):",null,null,"ft"]
[null,null,null,null,"ys (Pier 2 scour depth):",null,null,"ft"]
[null,null,null,null,"ys (Pier 3 scour depth):",null,null,"ft"]
[null,null,null,null,"ys (Pier 4 scour depth):",null,null,"ft"]
[null,null,null,null,"ys (Pier 5 scour depth):",null,null,"ft"]
[null,null,"*If additional piers, fill out another form*"]
[]
[null,"Total Calculated Scour Elevation:"]
[null,null,null,null,null,null,"L  ABUTMENT",null,"PIER 1",null,"PIER 2",null,"PIER 3",null,"PIER 4",null,"PIER 5",null,"R  ABUTMENT"]
[null,"Scour Design Event"]
[null,"Scour Check Event"]
[null,"Incipient OT (if less than design event)"]
[]
[null,"Recommended SNBI Scour Vulnerability Code (B.AP.03):"]
[]
[]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checked By:"]
[null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2026-07-15"},null,null,null,null,null,"PE License #"]

{"sheet":"Drop Down","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}