{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Sheet (Culvert - >=20 FT)","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 (Culvert - >=20 FT)","index":0,"n_rows":71,"n_cols":30,"rows_kept":71,"cut":false,"hidden":false,"merged":[[16,17,16,22],[23,16,23,19],[23,20,23,24],[68,12,68,23],[69,13,69,23],[46,10,46,16],[16,13,16,16],[66,13,66,23],[65,12,65,27],[20,8,20,11],[20,17,20,19],[20,20,20,23],[21,8,21,11],[21,17,21,19],[21,20,21,23],[23,8,23,11],[58,1,58,10],[58,11,58,14],[58,18,58,21],[60,1,60,29],[48,11,48,15],[31,3,31,27],[32,3,32,27],[34,1,34,29],[36,1,36,28],[38,11,38,15],[40,10,40,16],[42,4,42,6],[42,11,42,15],[43,11,43,15],[44,11,44,15],[62,6,62,8],[62,16,62,28],[49,11,49,15],[50,11,50,15],[52,7,52,27],[54,1,54,28],[56,3,56,7],[56,11,56,14],[56,18,56,21],[50,26,50,27],[44,26,44,27],[29,3,29,27],[30,3,30,27],[16,4,16,11],[18,1,18,29],[24,8,24,11],[24,20,24,24],[25,8,25,11],[25,20,25,24],[25,25,25,26],[26,8,26,11],[26,20,26,24],[27,8,27,11],[27,14,27,19],[27,20,27,24],[27,25,27,26],[12,16,12,27],[15,2,15,9],[15,15,15,20],[15,22,15,25],[15,26,15,27],[12,3,12,15],[1,1,1,29],[2,1,2,29],[4,1,4,7],[4,24,4,27],[5,24,5,27],[6,1,6,9],[6,10,6,27],[11,3,11,15],[11,16,11,27],[7,1,7,9],[7,10,7,27],[8,1,8,9],[8,10,8,27]]}
[]
[null,"Riverine Bridge-Sized Culvert ( ³ 20 ft)"]
[]
[]
[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 Culvert 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,"Culvert Information"]
[]
[null,"Box Dimension:",null,null,null,null,null,"Span:",null,null,null,null,"ft.",null,null,null,null,"Rise:",null,null,null,null,null,null,"ft."]
[null,"Extension:",null,null,null,null,null,"Right:",null,null,null,null,"ft.",null,null,null,null,"Left:",null,null,null,null,null,null,"ft."]
[]
[null,null,null,null,null,null,null,"Estimated Length:",null,null,null,null,"ft.",null,null,null,"  Diameter:"]
[null,null,null,null,null,null,null,"No. Barrels:",null,null,null,null,null,null,null,null,null,null,null,"Material type:"]
[null,null,null,null,null,null,null,"Skew Angle:",null,null,null,null,"°",null,null,null,null,null,null,"Centerline Station:"]
[null,null,null,null,null,null,null,"Inlet Invert Elev.:",null,null,null,null,"ft.",null,null,null,null,null,null,"Outlet Invert Elev.:",null,null,null,null,null,"ft."]
[null,null,null,null,null,null,null,"Riprap Required:",null,null,null,null,null,null," To Elevation:",null,null,null,null,null,null,null,null,null,null,"ft."]
[]
[null,"Comments:"]
[]
[]
[]
[]
[null,"Required Hydrology Information for 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(K41='Dropdown Lists'!E15,\"AEP-4%\",IF(K41='Dropdown Lists'!E16,\"AEP-2%\",\"AEP-_%\"))","v":"AEP-_%"},"=",null,null,null,null,null,"cfs"]
[null,null,null,null,null,null,null,null,"Vel.",{"$f":"J43","v":"AEP-_%"},"=",null,null,null,null,null,"ft/sec"]
[null,null,null,null,null,null,null,null,"Headwater Elev.",{"$f":"J43","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,"Headwater Elev.","Vel. AEP-1%","=",null,null,null,null,null,"ft."]
[]
[null,null,null,null,null,null,"Historical Highwater Elev. ="]
[]
[null,"BACKWATER UPSTREAM OF THE BRIDGE-SIZED CULVERT"]
[]
[null,null,null,{"$f":"IF(ISBLANK(K41),\"\",K41)","v":""},null,null,null,null,null,null,"HW Elev. =",null,null,null,null,null,"including",null,null,null,null,null,"ft.  Backwater"]
[]
[null,"1% AEP (100-Year) HW 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,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"]

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

{"sheet":"Definitions","index":2,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[15,1,15,2],[33,1,33,2],[0,1,0,2],[51,1,51,2]]}
[null,"Definition of Requested Information on Riverine Bridge-Sized Culvert (≥ 20 ft) 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"]
[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 Culvert Over:","Hydraulic feature (river, stream, creek, swamp, etc.) for which the culvert is being designed.  (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 culvert will be located on. (Example: S-32-58)"]
[null,"Project ID:","Project ID Number (Example: 26585)"]
[null,"Structure No.:","SCDOT Structure ID Number for culvert (County/System/Road/Direction/ID Locator/ID Auxiliary) (Example: 427005800200300)"]
[null,"Asset ID:","SCDOT Asset ID Number for Bridge  (Example: 5046)"]
[null,"Culvert Information"]
[null,"Box Dimension:"]
[null,"Span:","Span refers to the width of the box culvert.  N/A if a box culvert is not being used. (Example: 10)"]
[null,"Rise:","Rise refers to the height of the box culvert.   N/A if a box culvert is not being used. (Example: 10)"]
[null,"Extension:"]
[null,"Right:","This is only for existing culverts being retained and extended; leave this item blank for new construction.  The left and right side of the culvert is determined from the direction of the stationing. (Example: 10)"]
[null,"Left:","This is only for existing culverts being retained and extended; leave this item blank for new construction.  The left and right side of the culvert is determined from the direction of the stationing.  (Example: 10)"]
[null,"Estimated Length:","Centerline length of the culvert (upstream to downstream) used for the purposes of the hydraulic study performed on the culvert. (Example: 100)"]
[null,"No.  Barrels:","Number of culvert barrels at the site. (Example: 1)"]
[null,"Diameter:","Diameter refers to the length of a straight line through the center of the circular culvert.  N/A if a circular culvert is not being used. (Example: 10)"]
[null,"Material Type:","Material used to construct the culvert.  (Example: Concrete)"]
[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 N/A in the blank."]
[null,"Centerline Station:","The station where the culvert cross the centerline of the roadway. (Example: 100+00.00)"]
[null,"Inlet Invert Elev.:","Elevation of the culvert’s invert at the upstream end.  Box culverts are buried 1 foot below the natural ground line.  Circular culverts are buried 25% of the diameter up to a maximum of 1 foot below the natural ground line. (Example: 600.15)"]
[null,"Outlet Invert Elev.:","Elevation of the culvert’s invert at the downstream end.  Box culverts are buried 1 foot below the natural ground line. Circular culverts are buried 25% of the diameter up to a maximum of 1 foot below the natural ground line. (Example: 599.75)"]
[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 embankment 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 culvert, any issues related to the culvert, and additional historical highwater marks may be placed in the comments section. These comments may include the need for an energy dissipater or riprap pad and any unique features with the design.  Note if the design is preliminary."]
[null,"Required Hydrology Information for Plans"]
[null,"D. A.:","Total drainage area for the culvert."]
[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 average velocity at the culvert outlet for the design flood."]
[null,"Headwater Elev.AEP-__%: ","The water-surface elevation at the culvert inlet 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 average velocity at the culvert outlet for the 1% AEP (100-year) flood."]
[null,"Headwater Elev.AEP-1%: ","The water-surface elevation at the culvert inlet 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)\n      and 0.2% 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 (Culvert - >=20 FT)'!AD71","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":[[12,4,12,5],[4,1,6,1],[4,4,4,6],[6,4,6,6],[7,4,7,6],[8,4,8,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[14,4,14,5],[15,4,15,5]]}
[]
[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,null,null,null,"4% AEP (25-Year)"]
[null,"COUNTY",null,null,"2% AEP (50-Year)"]
[]
[null,"Abbeville"]
[null,"Aiken"]
[null,"Allendale",null,null,"Direction of Downstream Flow on Plans: "]
[null,"Anderson"]
[null,"Bamberg",null,null,"Downstream flow direction is to left of plan stationing"]
[null,"Barnwell",null,null,"Downstream flow direction is to right of plan stationing"]
[null,"Beaufort"]
[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," "]