{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Sheet (Riverine Bridge)","Additional Comments","Definitions","Dropdown Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Data Sheet (Riverine Bridge)","index":0,"n_rows":70,"n_cols":31,"rows_kept":70,"cut":false,"hidden":false,"merged":[[2,1,2,29],[1,1,1,29],[34,1,34,28],[36,11,36,15],[25,3,25,7],[27,3,27,27],[29,3,29,27],[19,3,19,7],[18,1,18,29],[20,14,20,18],[16,4,16,11],[30,3,30,27],[25,15,25,18],[25,25,25,27],[28,3,28,27],[25,10,25,14],[67,13,67,23],[47,11,47,15],[48,11,48,15],[66,12,66,23],[58,1,58,29],[56,18,56,21],[50,7,50,27],[60,16,60,28],[60,6,60,8],[54,3,54,7],[56,1,56,10],[56,11,56,14],[52,1,52,28],[63,12,63,27],[4,1,4,7],[4,24,4,27],[5,1,5,7],[5,24,5,27],[22,4,22,27],[11,3,11,15],[11,16,11,27],[12,3,12,15],[12,16,12,27],[15,2,15,9],[15,15,15,20],[15,22,15,25],[15,26,15,27],[19,25,19,27],[20,3,20,7],[20,25,20,27],[23,5,23,27],[24,3,24,7],[24,10,24,14],[24,15,24,18],[54,11,54,14],[54,18,54,21],[32,1,32,29],[41,11,41,15],[42,11,42,15],[38,10,38,16],[44,10,44,16],[40,4,40,6],[40,11,40,15],[46,11,46,15],[21,7,21,27],[8,1,8,9],[7,1,7,9],[6,1,6,9],[6,10,6,27],[7,10,7,27],[8,10,8,27],[16,13,16,16],[16,17,16,22]]}
[]
[null,"Riverine Bridge"]
[]
[]
[null,"Memorandum to:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Submittal Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supersedes Submittal Date:"]
[null,"RPG Road Design Engineer:"]
[null,"RPG Structural Design Engineer:"]
[null,"RPG Geotechnical Design Engineer:"]
[]
[]
[null,"From:      ",null,"RPG Hydraulic Design Engineer:"]
[null,"Subject:  ",null,"Hydrology Data for Bridge over:"]
[]
[]
[null,"County: ",null,null,null,null,null,null,null,null,null,null,null,null,"Road/Route:",null,null,null,null,null,null,null,"     Project ID:"]
[null,"Structure No.:",null,null,null,null,null,null,null,null,null,null,null,"Asset ID:"]
[]
[null,"Bridge Information"]
[null,"Bridge Length:",null,null,null,null,null,null,"ft.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge Roadway Width:",null,null,null,"ft."]
[null,"Beg. Station:",null,null,null,null,null,null,null,null,null,null,null,"End Station:",null,null,null,null,null,null,null,null,null,null,"Skew Angle:",null,null,null,"°"]
[null,"Bridge Span Configuration:"]
[null,"Bridge Span Type:"]
[null,"Pier/Pile Type & Size:"]
[null,"Min. F.G. Elev.:",null,null,null,null,null,null,"ft.",null,"Min. Low Chord:",null,null,null,null,null,null,null,null,"ft."]
[null,"End Fill Slope:",null,null,null,null,null,null,null,null,"Riprap Required:",null,null,null,null,null,null,null,null,null,null,null,null,null," To Elevation:",null,null,null,"ft."]
[]
[null,"Comments:"]
[]
[]
[]
[]
[null,"Required Hydrology Information for Bridge Plans"]
[]
[null,"HYDROLOGY DATA:"]
[]
[null,null,null,null,null,null,null,null,null,"D.A.","=",null,null,null,null,null,"sq. mi."]
[]
[null,null,null,null,null,null,null,null,null,"Design Flood:"]
[]
[null,null,null,null,null,null,null,null,"Q",{"$f":"IF(K39='Dropdown Lists'!E15,\"AEP-4%\",IF(K39='Dropdown Lists'!E16,\"AEP-2%\",\"AEP-_%\"))","v":"AEP-_%"},"=",null,null,null,null,null,"cfs"]
[null,null,null,null,null,null,null,null,"Vel.",{"$f":"J41","v":"AEP-_%"},"=",null,null,null,null,null,"ft/sec"]
[null,null,null,null,null,null,null,null,"WSE",{"$f":"J41","v":"AEP-_%"},"=",null,null,null,null,null,"ft."]
[]
[null,null,null,null,null,null,null,null,null,null,"1% AEP (100-Year)"]
[]
[null,null,null,null,null,null,null,null,null,"Q AEP-1%","=",null,null,null,null,null,"cfs"]
[null,null,null,null,null,null,null,null,null,"Vel. AEP-1%","=",null,null,null,null,null,"ft/sec"]
[null,null,null,null,null,null,null,null,"WSE","AEP-1%","=",null,null,null,null,null,"ft."]
[]
[null,null,null,null,null,null,"Historical Highwater Elev. ="]
[]
[null,"BACKWATER ELEVATION UPSTREAM OF THE BRIDGE "]
[]
[null,null,null,{"$f":"IF(ISBLANK(K39),\"\",K39)","v":""},null,null,null,null,null,null,"H.W. Elev. =",null,null,null,null,null,"including",null,null,null,null,null,"ft.  Backwater"]
[]
[null,"1% AEP (100-Year) H.W. Elev. =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"including",null,null,null,null,null,"ft.  Backwater"]
[]
[null,"STRUCTURE OVERTOPPING FLOOD"]
[]
[null,null,null,null,null,"0.2% AEP (500-Year) flow =",null,null,null,"cfs",null,null,null,null,null,"Overtopping flow:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Direction of Downstream Flow on Plans: "]
[]
[]
[null,"ecc:  ",null,null,null,null,null,null,null,null,null,"Hydraulic Engineer in HDSO:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Modified: 1/8/2026"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Additional Comments","index":1,"n_rows":53,"n_cols":29,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,2,0,28],[2,3,2,9],[2,15,2,20],[2,22,2,26],[4,5,4,14],[4,20,4,27],[17,2,17,27],[6,1,6,28],[7,4,7,27],[8,2,8,27],[9,2,9,27],[10,2,10,27],[11,2,11,27],[12,2,12,27],[13,2,13,27],[14,2,14,27],[15,2,15,27],[16,2,16,27],[29,2,29,27],[18,2,18,27],[19,2,19,27],[20,2,20,27],[21,2,21,27],[22,2,22,27],[23,2,23,27],[24,2,24,27],[25,2,25,27],[26,2,26,27],[27,2,27,27],[28,2,28,27],[41,2,41,27],[30,2,30,27],[31,2,31,27],[32,2,32,27],[33,2,33,27],[34,2,34,27],[35,2,35,27],[36,2,36,27],[37,2,37,27],[38,2,38,27],[39,2,39,27],[40,2,40,27],[48,2,48,27],[49,2,49,27],[42,2,42,27],[43,2,43,27],[44,2,44,27],[45,2,45,27],[46,2,46,27],[47,2,47,27]]}
[]
[]
[null,null,"County: ",{"$f":"'Data Sheet (Riverine Bridge)'!C16","v":0},null,null,null,null,null,null,null,null,null,null,"Road/Route:",{"$f":"'Data Sheet (Riverine Bridge)'!P16:U16","v":0},null,null,null,null,null,null,"     Project ID:",null,null,null,null,{"$f":"'Data Sheet (Riverine Bridge)'!AA16","v":0}]
[]
[null,null,"Structure No.:",null,null,{"$f":"'Data Sheet (Riverine Bridge)'!E17","v":0},null,null,null,null,null,null,null,null,null,null,"Stream:",null,null,null,{"$f":"'Data Sheet (Riverine Bridge)'!Q13","v":0}]
[]
[null,"ADDITIONAL COMMENTS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Sheet (Riverine Bridge)'!AD69","v":"Date Modified: 1/8/2026"}]

{"sheet":"Definitions","index":2,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[[15,1,15,2],[30,1,30,2],[0,1,0,2],[48,1,48,2]]}
[null,"Definition of Requested Information on Riverine Bridge Data Sheet"]
[]
[null,"Requested Information","Definition"]
[null,"Submittal Date:","Date submitted to Road Design"]
[null,"Supersedes Submittal Date:","Date on previous submittal that is being superseded"]
[null,"RPG Road Design Engineer:","Road Design Engineer responsible for plan production"]
[null,"RPG Structural Design Engineer:","Structural Design Engineer responsible for plan production"]
[null,"RPG Geotechnical Design Engineer:","Geotechnical Design Engineer responsible for review of scour"]
[null,"RPG Hydraulic Design Engineer:","Hydraulic Design Engineer's name for in-house design.  Add consultant's name in parentheses. [Example: Smith (by URS)]"]
[null,"Hydrology Data for Bridge Over:","Hydraulic feature (river, stream, creek, swamp, etc.) for which the bridge is being designed for.  (Example: Broad River)"]
[null,"County:","County or counties where the bridge is to be located.  Note: Select county from dropdown menu.  If there are multiple counties, the county names can be manually typed in the cell.  (Example: Lee)"]
[null,"Road/Route:","The road or route that the bridge will be located on. (Example: S-32-58)"]
[null,"Project ID:","Project ID Number (Example: 26585)"]
[null,"Structure No.:","SCDOT Structure ID Number for bridge (County/System/Road/Direction/ID Locator/ID Auxiliary) (Example: 427005800200300)"]
[null,"Asset ID","SCDOT Asset ID Number for Bridge  (Example: 5046)"]
[null,"Bridge Information"]
[null,"Bridge Length:","Centerline length of the bridge"]
[null,"Bridge Roadway Width:","Width of the bridge measured out to out"]
[null,"Begin Station:","Road station at the beginning of the bridge.  (Example: 100+00.00)"]
[null,"End Station:","Road station at the end of the bridge. (Example: 260+00.00)"]
[null,"Skew Angle:","Angle measured from a line perpendicular to the roadway centerline and the centerline of the hydraulic  feature being crossed.  If there is no skew place 0 in the blank."]
[null,"Bridge Span Configuration:","Bridge span arrangement (Example: 40'-40'-40'-40' or 4-40's)"]
[null,"Bridge Span Type:","Type of superstructure used.  List largest beam type if multiple types exist.  (Example: Type II prestressed)"]
[null,"Pier/Pile Type & Size:","Type of and size of substructure (Example: 4 ft. diameter drilled shaft.)"]
[null,"Min F. G. Elev.:","Minimum Finished Grade is the lowest bridge deck elevation from the bridge study (taken from centerline of the bridge, even if in super.)"]
[null,"Min. Low Chord:","Minimum Low Chord is the lowest elevation of all the beams in the bridge study.  Note: May not be at the same location as the Min. F. G.  If the bridge is in super, location should be taken on the low side of the bridge."]
[null,"End Fill Slope:","Give the Horizontal (typically 2); Vertical assumed to be 1.  Note: The end fill slope is based on a line perpendicular to the centerline of the end bents for skewed and non-skewed bridges.   (Example: 2)"]
[null,"Riprap Required:","Select “Yes” or “No” from dropdown menu.  Explain the reason for any additional riprap in the comments section below.  (Example: Yes)"]
[null,"To Elevation:","This is the elevation where the required riprap should stop on the end fill slope.  The riprap should be placed a minimum of 2 ft above the design highwater elevation.  (Example: 650.5)"]
[null,"Comments:","Comments regarding the design of the bridge, any issues related to the bridge, or additional highwater marks may be placed in the comments section.  These comments may include the need for a special riprap design or any unusual features with the design.  Note if the design is preliminary."]
[null,"Required Hydrology Information for Bridge Plans"]
[null,"D. A.:","Total drainage area for the bridge."]
[null,"Design Flood:","Select design flood from dropdown menu:\n   -  4% AEP (25-Year)\n   -  2% AEP (50-Year)"]
[null,"QAEP-__%: ","The flowrate for the design flood."]
[null,"Vel.AEP-__%: ","The maximum average velocity through the bridge opening for the design flood."]
[null,"WS Elev.AEP-__%: ","The maximum water-surface elevation (WSE) at the design highwater location for the design flood."]
[null,"1% AEP (100-Year)","The 1% Annual Exceedance Probability (AEP) flood is equivalent to the 100-year flood."]
[null,"Q AEP-1%","The flowrate for the 1% AEP (100-year) flood."]
[null,"Vel. AEP-1%","The maximum average velocity through the bridge opening for the 1% AEP (100-year) flood."]
[null,"WS Elev.AEP-1%: ","The maximum water surface elevation (WSE) at the design highwater location for the 1% AEP (100-year) flood. "]
[null,"Historical Highwater Elev.:","The highwater elevation from old plans, USGS data, or property owners.  Note the date observed and source of the information (i.e. 1971 John Doe property owner, 1959 plans File # 21.105B)"]
[null,"__% AEP ( __-Year) HW Elev. =","Plot and compare the unconstricted run and proposed water surface elevations upstream of the bridge for the design flood, and identify the location with the greatest difference in water surface elevations (WSEs). The WSE from the proposed run at this location should be used to represent the design flood highwater (HW) elevation. "]
[null,"including _____ ft. Backwater:","Backwater is the difference between the proposed and unconstricted design flood WSEs at the location with the greatest difference between the two WSEs."]
[null,"1% AEP (100-Year) HW Elev.:","Plot and compare the unconstricted run and proposed water surface elevations upstream of the bridge for the 1% AEP flood, and identify the location with the greatest difference in water surface elevations (WSEs). The WSE from the proposed run at this location should be used to represent the 1% AEP flood highwater (HW) elevation."]
[null,"including _____ ft. Backwater:","Backwater is the difference between the proposed and unconstricted 1% AEP flood WSEs at the location with the greatest difference between the two WSEs."]
[null,"0.2% AEP (500-Year) flow","The flowrate for the 0.2% AEP (500-year) flood."]
[null,"Overtopping flow:","Use the dropdown menu to select one of the following categories:\n   -  If the overtopping flow is less than the 1% AEP (Q100) flow, select \"Less than 1% AEP (100-yr) flow.\"\n   -  If the overtopping flow is greater than the 0.2% AEP (Q500) flow, select \"Greater than 0.2% AEP (500-yr) flow.\"\n   -  If the overtopping flow is between the 1% AEP (Q100) and 0.2% AEP (Q500) flow, select \"Between 1% AEP (Q100) and 0.2%\n      AEP (Q500) flow.\""]
[null,"Direction of Downstream Flow on Plans: ","The direction of flow indictates if the left or right side of the bridge, with respect to the plan stationing, is the downstream side of the bridge.  An arrow, indicating the downstream direction of flow, should be placed on the bridge plans."]
[null,"Electronic Carbon Copies"]
[null,"Hydraulic Engineer in HDSO:","Hydraulic Policy Engineer in the Hydraulic Design Support Office"]
[null,null,{"$f":"'Data Sheet (Riverine Bridge)'!AD69","v":"Date Modified: 1/8/2026"}]

{"sheet":"Dropdown Lists","index":3,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":true,"merged":[[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[4,1,6,1],[12,4,12,5],[14,4,14,5],[8,4,8,6],[15,4,15,5],[4,4,4,6],[6,4,6,6],[7,4,7,6],[13,4,13,5],[5,4,5,6]]}
[]
[null,null,null,"Dropdown Lists"]
[]
[]
[null,"Dropdown List",null,null,"Overtopping Flow Category"]
[]
[null,null,null,null,"Less than 1% AEP (100-yr) flow"]
[null,null,null,null,"Between 1% AEP (Q100) and 0.2% AEP (Q500) flow"]
[null,"Yes",null,null,"Greater than 0.2% AEP (500-yr) flow"]
[null,"No"]
[]
[]
[null,null,null,null,"Design Flood"]
[]
[null,"COUNTY",null,null,"4% AEP (25-Year)"]
[null,null,null,null,"2% AEP (50-Year)"]
[null,"Abbeville"]
[null,"Aiken"]
[null,"Allendale"]
[null,"Anderson",null,null,"Direction of Downstream Flow on Plans: "]
[null,"Bamberg"]
[null,"Barnwell",null,null,"Downstream flow direction is to left of plan stationing"]
[null,"Beaufort",null,null,"Downstream flow direction is to right of plan stationing"]
[null,"Berkeley"]
[null,"Calhoun"]
[null,"Charleston"]
[null,"Cherokee"]
[null,"Chester"]
[null,"Chesterfield"]
[null,"Clarendon"]
[null,"Colleton"]
[null,"Darlington"]
[null,"Dillon"]
[null,"Dorchester"]
[null,"Edgefield"]
[null,"Fairfield"]
[null,"Florence"]
[null,"Georgetown"]
[null,"Greenville"]
[null,"Greenwood"]
[null,"Hampton"]
[null,"Horry"]
[null,"Jasper"]
[null,"Kershaw"]
[null,"Lancaster"]
[null,"Laurens"]
[null,"Lee"]
[null,"Lexington"]
[null,"Marion"]
[null,"Marlboro"]
[null,"McCormick"]
[null,"Newberry"]
[null,"Oconee"]
[null,"Orangeburg"]
[null,"Pickens"]
[null,"Richland"]
[null,"Saluda"]
[null,"Spartanburg"]
[null,"Sumter"]
[null,"Union"]
[null,"Williamsburg"]
[null,"York"]
[]
[]
[null," "]