{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Scour Appraisal Summary","Drop Down"],"not_rendered":{"charts":0,"images":2,"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 Appraisal Summary","index":0,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":false,"merged":[[37,3,37,7],[39,3,39,7],[6,4,6,6],[2,21,2,22],[4,4,4,6],[5,4,5,6],[2,19,2,20],[3,19,3,20],[2,10,2,15],[3,4,3,6],[6,10,6,17],[5,10,5,17],[12,9,12,17],[33,3,33,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[34,14,34,15],[34,16,34,17],[29,4,32,15],[34,18,34,19],[35,3,35,7],[35,8,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,15],[35,16,35,17],[35,18,35,19],[67,18,67,19],[68,11,68,12],[68,18,68,19],[40,16,40,17],[51,5,52,17],[55,2,60,17],[40,18,40,19],[41,3,41,7],[38,16,38,17],[38,18,38,19],[36,3,36,7],[36,8,36,9],[36,10,36,11],[38,3,38,7],[40,3,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[36,16,36,17],[36,18,36,19],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[36,12,36,13],[36,14,36,15]]}
[]
[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,"Data Collection/Review (check all that apply):"]
[null,null,null,"Structure Plan",null,null,null,null,"Subsurface Report"]
[null,null,null,"Inspection Reports",null,null,null,null,"Pile Driving Records"]
[null,null,null,"Underwater Profiles",null,null,null,null,"Previous Scour Assessment/Documentation"]
[null,null,null,"Historical Aerial Imagery",null,null,null,null,"Other:"]
[]
[null,"Scour Appraisal (check all that apply):"]
[null,null,null,"LEVEL 1a ASSESSMENT"]
[null,null,null,null,null,"Stability Total"]
[]
[null,null,null,"LEVEL 1b ASSESSMENT"]
[null,null,null,null," If Level 1b resulted in low risk designation, select reasoning:"]
[null,null,null,null,null,"bridge spans ditch with flat slope"]
[null,null,null,null,null,"bridge over still water"]
[null,null,null,null,null,"single span bridge, on piles, stable streambed after design level event"]
[null,null,null,null,null,"bridge over concrete lined channel"]
[null,null,null,null,null,"multi span bridge, on piles >20’, aligned with flow, stable streambed after design level event"]
[null,null,null,null,null,"bridge with piles embedded into non-erodible material/rock"]
[null,null,null,null,null,"bridge with spread footings on non-erodible material/rock"]
[]
[null,null,null,"LEVEL 2 ASSESSMENT"]
[null,null,null,null,"In table below include total calculated scour depths and bottom of foundation elevations. If needed, attach a table for larger bridges. In summary narrative, briefly describe any geotechnical (soil strata) or structural elements (foundation type, etc.) that informed scour risk designation. If reviewing an existing structure, include any documented scour history."]
[]
[]
[]
[null,null,null,"Total Calculated Scour Evaluation"]
[null,null,null,null,null,null,null,null,"L  ABUTMENT",null,"PIER 1",null,"PIER 2",null,"PIER 3",null,"PIER 4",null,"R  ABUTMENT"]
[null,null,null,"Bot. of Foundation Elev. (piles, footings)"]
[null,null,null,"Total Scour - Design Event Elev."]
[null,null,null,"Unbraced Length | Remaining Embed. [ft]"]
[null,null,null,"Total Scour - Check Event Elev."]
[null,null,null,"Unbraced Length | Remaining Embed. [ft]"]
[null,null,null,"Incipient OT (if less than design event) Elev."]
[null,null,null,"Unbraced Length | Remaining Embed. [ft]"]
[]
[null,"Scour Risk Designation: Based on examination of the above information select a category below for the structure."]
[null,null,null,"Low Risk"]
[null,null,null,"Unknown Foundation"]
[null,null,null,"Scour Critical"]
[]
[null,"Recommended SNBI Scour Vulnerability Code (Item B.AP.03)"]
[null,null,null,"A",null,"B",null,"C",null,"D",null,"E",null,"U"]
[]
[null,null,null,null,"Justification for Coding:"]
[]
[]
[null,"Summary Narrative:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Recommended Action(s):"]
[null,null,null,"Develop POA"]
[null,null,null,"Increase Monitoring Frequency"]
[null,null,null,"Install Countermeasures"]
[null,null,null,"None (Low Risk)"]
[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-05-28"},null,null,null,null,null,"PE License # (for Level 1b/2):"]

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