{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Form","Output Report","Report"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Instructions","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Spreadsheet Instructions for Calculation of Local Pier Scour"]
[]
["Inputs"]
[1,"Spreadsheet calculations are based on equations presented in the FDOT Scour Manual 2022."]
[2,"Enter dimensions of substructure geometry following figures located on the Form page."]
[3,"If the column or pile cap is out of the water, click the no pile cap and/or no column checkboxes."]
[4,"Elevations of the column, pile cap, and pile group are measured from the bed after accounting for degradation and contraction scour."]
[5,"The elevation of the pile cap should equal that of the pile group."]
["Outputs"]
[1,"The create report button will become active once scour is calculated."]
[2,"If the pier and return period fields are left blank, the output sheet will be titled Output Report."]
[3,"If the pier and return period fields are entered (e.g. Pier 1, 100-yr), the output sheet will be titled according to these fields (e.g., Pier 1 - 100)."]
[4,"The macros will ask if you are writing over a preexisting output report."]
[5,"Output reports are formatted to print on one page."]
["Best Practices"]
[1,"Copy this worksheet to your working directory and keep an unaltered version elsewhere. "]
[2,"Perfom all calculations for an individual bridge in one workbook with tabs for each pier and return period."]

{"sheet":"Form","index":1,"n_rows":27,"n_cols":30,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,7,4,10],[5,7,5,10],[18,2,18,3],[1,1,2,15],[8,2,8,3],[8,6,8,7],[8,10,8,11],[8,14,8,15],[4,11,4,13],[5,11,5,13]]}
[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,"Rectangular","Rectangular","Rectangular"]
[null,"This program was developed for use with cohesionless sediment.",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,"Rounded","Rounded","Circular"]
[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,"Pointed"]
[]
[null,null,null,null,null,null,null,"Effective Diameter, D* (ft)"]
[null,null,null,null,null,null,null,"Local Scour, ys (ft)"]
[]
[]
[null,null,"Flow and Sediment",null,null,null,"Column Data",null,null,null,"Pile Cap Data",null,null,null,"Pile Group Data"]
[null,null,"D50 (mm)",0.22,null,null,"bcol (ft)",20,null,null,"bpc (ft)",44,null,null,"n",6]
[null,null,"Angle of Attack  (o)",23,null,null,"Lcol (ft)",7,null,null,"Lpc (ft)",29,null,null,"m",4]
[null,null,"yo (ft)",25.3,null,null,"Hcol (ft)",22,null,null,"T (ft)",7.5,null,null,"b (ft)",2.5]
[null,null,"V (ft/s)",1,null,null,"Shape",null,null,null,"Hpc (ft)",14.5,null,null,"sn (ft)",7.5]
[null,null,null,null,null,null,null,null,null,null,"Shape",null,null,null,"sm (ft)",7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hpg (ft)",14.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shape"]
[]
[]
[null,null,"Project Information for Reporting"]
[]
[null,null,"Bridge Number"]
[null,null,"Route"]
[null,null,"Waterway"]
[null,null,"Pier Number"]
[null,null,"Return Period"]
[null,null,"Created By"]
[null,null,"Date"]

{"sheet":"Output Report","index":2,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[71,3,72,3],[55,6,56,10],[57,2,57,4],[57,7,58,7],[57,8,58,8],[57,9,58,9],[64,2,64,4],[45,9,45,10],[46,9,46,10],[48,2,48,11],[49,2,49,4],[50,6,51,10],[52,7,53,7],[52,8,53,8],[52,9,53,9],[40,2,40,3],[40,6,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[8,4,8,5],[8,8,8,9],[10,4,20,9],[21,2,21,11],[26,2,26,3],[32,2,32,3],[0,2,0,11],[2,4,2,5],[2,8,2,9],[4,4,4,5],[4,8,4,9],[6,4,6,5],[6,8,6,9]]}
[null,null,"FDOT Complex Pier Local Scour Calculator Version 6.4"]
[]
[null,null,null,"Bridge Number:",null,null,null,"Route:"]
[]
[null,null,null,"Pier Number:",null,null,null,"Waterway:"]
[]
[null,null,null,"Return Period:"]
[]
[null,null,null,"Calculated by:",null,null,null,"Date:"]
[]
[null,null,null,"Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Input Data"]
[]
[]
[]
[]
[null,null,"Flow and Sediment Data"]
[null,null,"D50 (mm)",0.22]
[null,null,"Angle of Attack, a (o)",23]
[null,null,"y0 (ft)",25.3]
[null,null,"V (ft/s)",1]
[]
[null,null,"Column Data"]
[null,null,"bcol (ft)",20]
[null,null,"Lcol (ft)",7]
[null,null,"Hcol (ft)",22]
[null,null,"Shape","Rectangular"]
[]
[]
[]
[null,null,"Pile Cap Data",null,null,null,"Pile Group Data"]
[null,null,"bpc (ft)",44,null,null,"n",null,null,6]
[null,null,"Lpc (ft)",29,null,null,"m",null,null,4]
[null,null,"T (ft)",7.5,null,null,"b (ft)",null,null,2.5]
[null,null,"Hpc (ft)",14.5,null,null,"sn (ft)",null,null,7.5]
[null,null,"Shape","Rounded",null,null,"sm (ft)",null,null,7.5]
[null,null,null,null,null,null,"Shape",null,null,"Rectangular"]
[]
[null,null,"Output Data"]
[null,null,"Column Data"]
[null,null,"Kcols",1.2,null,null,"Effective Diameter of Complex Pier "]
[null,null,"Kcolp (ft)",21.145214968473724]
[null,null,"Kcolh",1.4424262348976776E-3,null,null,null,"D*cs =",21.611247676480399,"ft"]
[null,null,"fratio",0.53229799613467688]
[null,null,"Kcolf",0]
[null,null,"KLOBcol",1,null,null,"Local Scour at Complex Pier"]
[null,null,"D*col (ft)",0]
[null,null,"Pile Cap Data",null,null,null,null,"yscs =",14.680637348071281,"ft"]
[null,null,"Kpcs",1.0966922094508311]
[null,null,"Kpcp (ft)",38.139033072660894]
[null,null,"Kpch",0.1073872424190348]
[null,null,"KLOBpc",1]
[null,null,"D*pc (ft)",4.49166261144555]
[]
[null,null,"Pile Group Data"]
[null,null,"Kpgs",1.4]
[null,null,"Kpgp (ft)",28.459990120134368]
[null,null,"Kpgpe (ft)",13.871269231763996]
[null,null,"Kpgh",0.88155415644674973]
[null,null,"D*pg (ft)",17.119585065034848]

{"sheet":"Report","index":3,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":true,"merged":[[21,2,21,11],[48,2,48,11],[49,2,49,4],[57,2,57,4],[64,2,64,4],[50,6,51,10],[52,7,53,7],[52,8,53,8],[52,9,53,9],[55,6,56,10],[57,7,58,7],[57,8,58,8],[57,9,58,9],[46,9,46,10],[41,9,41,10],[42,9,42,10],[6,4,6,5],[6,8,6,9],[8,4,8,5],[8,8,8,9],[10,4,20,9],[0,2,0,11],[2,4,2,5],[2,8,2,9],[4,4,4,5],[4,8,4,9],[26,2,26,3],[32,2,32,3],[40,2,40,3],[40,6,40,10],[71,3,72,3],[43,9,43,10],[44,9,44,10],[45,9,45,10]]}
[null,null,"FDOT Complex Pier Local Scour Calculator Version 6.4"]
[]
[null,null,null,"Bridge Number:",null,null,null,"Route:"]
[]
[null,null,null,"Pier Number:",null,null,null,"Waterway:"]
[]
[null,null,null,"Return Period:"]
[]
[null,null,null,"Calculated by:",null,null,null,"Date:"]
[]
[null,null,null,"Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Input Data"]
[]
[]
[]
[]
[null,null,"Flow and Sediment Data"]
[null,null,"D50 (mm)",0.22]
[null,null,"Angle of Attack, a (o)",23]
[null,null,"y0 (ft)",25.3]
[null,null,"V (ft/s)",1]
[]
[null,null,"Column Data"]
[null,null,"bcol (ft)",20]
[null,null,"Lcol (ft)",7]
[null,null,"Hcol (ft)",22]
[null,null,"Shape","Rectangular"]
[]
[]
[]
[null,null,"Pile Cap Data",null,null,null,"Pile Group Data"]
[null,null,"bpc (ft)",44,null,null,"n",null,null,6]
[null,null,"Lpc (ft)",29,null,null,"m",null,null,4]
[null,null,"T (ft)",7.5,null,null,"b (ft)",null,null,2.5]
[null,null,"Hpc (ft)",14.5,null,null,"sn (ft)",null,null,7.5]
[null,null,"Shape","Rounded",null,null,"sm (ft)",null,null,7.5]
[null,null,null,null,null,null,"Shape",null,null,"Rectangular"]
[]
[null,null,"Output Data"]
[null,null,"Column Data"]
[null,null,"Kcols",1.2,null,null,"Effective Diameter of Complex Pier "]
[null,null,"Kcolp (ft)",21.145214968473724]
[null,null,"Kcolh",1.4424262348976776E-3,null,null,null,"D*cs =",21.611247676480399,"ft"]
[null,null,"fratio",0.53229799613467688]
[null,null,"Kcolf",0]
[null,null,"KLOBcol",1,null,null,"Local Scour at Complex Pier"]
[null,null,"D*col (ft)",0]
[null,null,"Pile Cap Data",null,null,null,null,"yscs =",14.680637348071281,"ft"]
[null,null,"Kpcs",1.0966922094508311]
[null,null,"Kpcp (ft)",38.139033072660894]
[null,null,"Kpch",0.1073872424190348]
[null,null,"KLOBpc",1]
[null,null,"D*pc (ft)",4.49166261144555]
[]
[null,null,"Pile Group Data"]
[null,null,"Kpgs",1.4]
[null,null,"Kpgp (ft)",28.459990120134368]
[null,null,"Kpgpe (ft)",13.871269231763996]
[null,null,"Kpgh",0.88155415644674973]
[null,null,"D*pg (ft)",17.119585065034848]