{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["A. Near Lane; Crash Cush","B. Two-Lane Two-Way; Crash Cush","C. Near Lane; Sloped End","D. Two-Lane Two-Way; Sloped End","RDG Data","Policy","Version History"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":34,"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":"A. Near Lane; Crash Cush","index":0,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,3],[32,0,32,2]]}
["CONCRETE BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-001",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB A:  SHIELDING OF NEAREST LANE USING CONCRETE BARRIER & CRASH CUSHION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations\n(Westbound shown, others similar)"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",55]
["Approach Face of Hazard Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",24,"the lesser distance  to the 'Clear Zone Limit' or 'Back of Hazard', measured from the 'Edge of Traffic Lane' "]
["Lateral Offset of Crash Cushion, Y (Ft.)",10,"the Crash Cushion's offset from the 'Edge of Traffic Lane', measured from the face of Crash Cushion at the Start LON location (see Index 544-001 and corresponding APL drawing)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":265}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B28)","v":154.58333333333334},"AASHTO RDG (5-3)"]
["Begin/End LON Station \n(Near Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B29),(B24-B29))","v":1154.5833333333333}]
[]
["Trailing End Design Note:"]
["When the facility is a two-lane two-way road with the Hazard or barrier within the Far Lane's Clear Zone Limit, design the Begin/End LON Station for a Crash Cushion on the opposite barrier end using Tab B. \n\nFor cases where an opposing lane is not within the Clear Zone distance from the Hazard or barrier, the trailing end of the barrier may be terminated adjacent to the trailing end of the Hazard.\n\nFor Guardrail Approach Terminals, See Index 536-001."]

{"sheet":"B. Two-Lane Two-Way; Crash Cush","index":1,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,3],[32,0,32,2]]}
["CONCRETE BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-001",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB B:  SHIELDING FOR FAR LANE OF 2-LANE 2-WAY ROAD: \n               CONCRETE BARRIER & CRASH CUSHION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Far Lane Traffic","Eastbound","for relative stationing calculations\n(Eastbound shown, others similar)"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",65]
["Approach Face of Hazard Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",24,"the lesser distance  to the 'Clear Zone Limit' or 'Back of Hazard', measured from the 'Edge of Traffic Lane' \n(Far Lane)"]
["Lateral Offset of Crash Cushion, Y (Ft.)",10,"the Crash Cushion's offset from the 'Edge of Traffic Lane' (Far Lane), measured from the face of Crash Cushion at the Start LON location (see Index 544-001 and corresponding APL drawing)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":330}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B28)","v":192.5},"AASHTO RDG (5-3)"]
["Begin/End LON Station\n(Far Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B29),(B24-B29))","v":807.5}]
[]
["Near Lane Design Note:"]
["If only the barrier is within the Clear Zone Limit of the \"Far Lane\" (Hazard is outside the Clear Zone Limit), apply a Crash Cushion with the Begin/End LON Station located 10 Ft. in advance of the Approach Face of Hazard Station (Locate at X = 10 Ft., as shown on this Tab)\n\nFor the opposite end of the barrier, design the Begin/End LON Station of a Crash Cushion for the  \"Near Lane\" approach using Tab A.\n\nFor Guardrail Approach Terminals, See Index 536-001."]

{"sheet":"C. Near Lane; Sloped End","index":2,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,3],[32,0,32,2]]}
["CONCRETE BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-001",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB C:  SHIELDING OF NEAREST LANE: CURB & GUTTER BARRIER WITH SLOPED END TREATMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations\n(Westbound shown, others similar)"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",45,"45 MPH is maximum permitted for Curb and Gutter Barrier"]
["Approach Face of Hazard Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",24,"the lesser distance  to the 'Clear Zone Limit' or 'Back of Hazard', measured from the 'Edge of Traffic Lane' "]
["Lateral Offset of Barrier, Y (Ft.)",10,"the Barrier's offset from the 'Edge of Traffic Lane', measured from the Barrier Gutter Line at the Begin/End LON Station"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":195}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B28)","v":113.75},"AASHTO RDG (5-3)"]
["Begin/End LON Station\n(Near Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B29),(B24-B29))","v":1113.75}]
[]
["Trailing End Design Note:"]
["When the facility is a two-lane two-way road with the Hazard or barrier within the Far Lane's Clear Zone Limit, design the Begin/End LON Station for a Sloped End Treatment on the opposite barrier end using Tab D. \n\nFor cases where an opposing lane is not within the Clear Zone distance from the Hazard or barrier, the trailing end of the barrier may be terminated adjacent to the trailing end of the Hazard.\n\nFor Guardrail Approach Terminals, See Index 536-001."]

{"sheet":"D. Two-Lane Two-Way; Sloped End","index":3,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,3],[32,0,32,2]]}
["CONCRETE BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-001",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB D:  SHIELDING FOR FAR LANE OF 2-LANE 2-WAY ROAD:\n               CURB & GUTTER BARRIER WITH SLOPED END TREATMENT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Far Lane Traffic","Eastbound","for relative stationing calculations\n(Eastbound shown, others similar)"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",35,"per the FDM, 35 MPH is maximum permitted for Curb and Gutter Barrier with a Sloped End Treatment"]
["Approach Face of Hazard Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",24,"the lesser distance  to the 'Clear Zone Limit' or 'Back of Hazard', measured from the 'Edge of Traffic Lane' \n(Far Lane)"]
["Lateral Offset of Barrier, Y (Ft.)",10,"the Barrier's offset from the 'Edge of Traffic Lane' (Far Lane), measured from the Barrier Gutter Line at the Begin/End LON Station"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":135}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B28)","v":78.75},"AASHTO RDG (5-3)"]
["Begin/End LON Station\n(Far Lane Approach) ",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B29),(B24-B29))","v":921.25}]
[]
["Near Lane Design Note:"]
["If only the barrier is within the Clear Zone Limit of the \"Far Lane\" (Hazard is outside the Clear Zone Limit), apply a Sloped End Treatment with the Begin/End LON Station located adjacent to the Approach Face of Hazard Station (Locate the end tip of the Sloped End Treatment at X = 25 Ft. or X = 10 Ft. for the 25 Ft length and 10 Ft. length Sloped End Treatment options, respectively)\n\nFor the opposite end of the barrier, design the Begin/End LON Station of a Sloped End Treatment for the  \"Near Lane\" approach using Tab C.\n\nFor Guardrail Approach Terminals, See Index 536-001"]

{"sheet":"RDG Data","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,4],[0,0,0,4],[1,0,2,0],[15,0,15,4]]}
["Runout Lengths, LR (Ft.):"]
["Design Speed\n(MPH)","ADT (VPD Threshold)"]
[null,0,1000,5000,10000]
[80,330,380,430,470]
[75,{"$f":"(B4+B6)/2","v":290},{"$f":"(C4+C6)/2","v":335},{"$f":"(D4+D6)/2","v":380},{"$f":"(E4+E6)/2","v":415}]
[70,250,290,330,360]
[65,{"$f":"(B6+B8)/2","v":225},{"$f":"(C6+C8)/2","v":250},{"$f":"(D6+D8)/2","v":290},{"$f":"(E6+E8)/2","v":330}]
[60,200,210,250,300]
[55,{"$f":"(B8+B10)/2","v":175},{"$f":"(C8+C10)/2","v":185},{"$f":"(D8+D10)/2","v":220},{"$f":"(E8+E10)/2","v":265}]
[50,150,160,190,230]
[45,{"$f":"(B10+B12)/2","v":125},{"$f":"(C10+C12)/2","v":135},{"$f":"(D10+D12)/2","v":160},{"$f":"(E10+E12)/2","v":195}]
[40,100,110,130,160]
[35,{"$f":"(B14+B12)/2","v":85},{"$f":"(C14+C12)/2","v":95},{"$f":"(D14+D12)/2","v":110},{"$f":"(E14+E12)/2","v":135}]
[30,70,80,90,110]
[]
["NOTE: The above values are taken from the\n               AASHTO RDG, Table 5-10(b)"]
[]
[]
["Northbound"]
["Eastbound"]
["Westbound"]
["Southbound"]
[]
["Yes"]
["No"]

{"sheet":"Policy","index":5,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,8],[0,0,0,7]]}
["Design Basis: The standard method of determining guardrail placement for shielding hazards is based on the Runout Length and the Length of Need calculation in the AASHTO Roadside Design Guide (RDG), 4th Edition"]
[]
[]
[]
["FDOT Design Tool Note: No warranty, expressed or implied, is made by the Florida Department of Transportation as to the accuracy and functioning of any programs or the results they produce, nor shall the fact of distribution constitute any such warranty, and no responsibility is assumed by the Florida Department of Transportation in any connection therewith.\n\nBy using this program, you are agreeing to the above disclaimer."]

{"sheet":"Version History","index":6,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version:","Released:","Changes:"]
["v1.0","2017-11-01","initial release"]