{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["A. Near Lane; PPB Only","B. Two-Lane Two-Way; PPB Only","C. Near Lane; Crash Wall","D. Two-Lane Two-Way; Crash Wall","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; PPB Only","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,3],[34,0,34,2]]}
["PIER PROTECTION BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-002",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB A:  SHIELDING OF NEAREST LANE USING PPB ONLY (No Crash Wall)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 Pier/Bent Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",30,"the lesser of the 30 foot setback distance or the distance to the back of the pier/bent, measured from the 'Edge of Traffic Lane'"]
["Lateral Offset of PPB, Y (Ft.)",10,"the PPB offset from the 'Edge of Traffic Lane', measured at the approach end of the PPB (Begin/End PPB Station point)"]
["Lateral Clearance, LC (Ft.)\n(Barrier to Pier/Bent)",10,"minimum distance from the back of barrier to the pier or bent structure (for determination of barrier and crash wall height per AASHTO LRFD 3.6.5.1)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":265}]
["Barrier/Crash Wall Height (In.)",{"$f":"IF(B27>10,44,54)","v":54}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B29)","v":176.66666666666666},"AASHTO RDG (5-3)"]
["Begin/End PPB Station \n(Near Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B31),(B24-B31))","v":1176.6666666666667}]
[]
["Trailing End Design Note:"]
["When the facility is a two-lane two-way road with the Pier or Bent within 30 feet of the \"Far Lane\", design the Begin/End Barrier Sta. or Crash Wall Sta. for the opposite end using Tabs B or D, respectively. \n\nFor cases where an opposing lane is not within 30 feet of the pier or bent, the trailing end of the barrier may be terminated adjacent to the trailing end of the pier or bent per the Standard Plans Example Layout. \n\nThis Spreadsheet considers Pier Protection only. Blunt ends of the PPB require crash worthiness considerations for vehicle benefit, such as shielding with Crash Cushions or continuation to Guardrail or Concrete Barrier. "]

{"sheet":"B. Two-Lane Two-Way; PPB Only","index":1,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,3],[34,0,34,2]]}
["PIER PROTECTION BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-002",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB B:  SHIELDING FOR FAR LANE OF 2-LANE 2-WAY ROAD USING PPB ONLY (No Crash Wall)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Far Lane Traffic","Eastbound","for relative stationing calculations\n(Eastbond shown, others similar)"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",65]
["Approach Face of Pier/Bent Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",30,"the lesser of the 30 foot setback distance or the distance to the back of the pier/bent, measured from the 'Edge of Traffic Lane'"]
["Lateral Offset of PPB, Y (Ft.)",10,"the PPB offset from the 'Edge of Traffic Lane', measured at the approach end of the PPB (Begin/End PPB Station point)"]
["Lateral Clearance, LC (Ft.)\n(Barrier to Pier/Bent)",10,"minimum distance from the back of barrier to the pier or bent structure (for determination of barrier and crash wall height per AASHTO LRFD 3.6.5.1)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":330}]
["Barrier/Crash Wall Height (In.)",{"$f":"IF(B27>10,44,54)","v":54}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B29)","v":220},"AASHTO RDG (5-3)"]
["Begin/End PPB Station\n(Far Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B31),(B24-B31))","v":780}]
[]
["Near Lane Design Note:"]
["For the opposing end, design the Begin/End PPB Sta. or Crash Wall Sta. for the \"Near Lane\" approach using Tabs A or C, respectively.\n\nThis Spreadsheet considers Pier Protection only. Blunt ends of the PPB require crash worthiness considerations for vehicle benefit, such as shielding with Crash Cushions or continuation to Guardrail or Concrete Barrier. "]

{"sheet":"C. Near Lane; Crash Wall","index":2,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,3],[34,0,34,2]]}
["PIER PROTECTION BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-002",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB C:  SHIELDING OF NEAREST LANE USING CRASH WALL EXTENSION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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)",65]
["Approach Face of Pier/Bent Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",30,"the lesser of the 30 foot setback distance or the distance to the back of the pier/bent, measured from the 'Edge of Traffic Lane'"]
["Lateral Offset of Crash Wall, Y (Ft.)",10,"the Crash Wall's offset from the 'Edge of Traffic Lane', measured from the approach end edge of the Crash Wall (Crash Wall Station Point)"]
["Lateral Clearance, LC (Ft.)\n(Barrier/Wall to Pier/Bent)",10,"minimum distance from the back of barrier or crash wall to the pier or bent structure (for determination of barrier and crash wall height per AASHTO LRFD 3.6.5.1)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":330}]
["Barrier/Crash Wall Height (In.)",{"$f":"IF(B27>10,44,54)","v":54}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B29)","v":220},"AASHTO RDG (5-3)"]
["Crash Wall Station\n(Near Lane Approach)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B31),(B24-B31))","v":1220}]
[]
["Trailing End Design Note:"]
["When the facility is a two-lane two way road with the Pier or Bent within 30 feet of the \"Far Lane\", design the Begin/End Barrier Sta. or Crash Wall Sta. for the opposite end using Tabs B or D, respectively. \n\nFor cases where an opposing lane is not within 30 feet of the pier or bent, the trailing end of the barrier may be terminated adjacent to the trailing end of the pier or bent per the Standard Plans Example Layout.\n\nThis Spreadsheet considers Pier Protection only. Crash Wall and blunt ends of the PPB require crash worthiness considerations for vehicle benefit, such as shielding with Crash Cushions or continuation to Guardrail or Concrete Barrier. "]

{"sheet":"D. Two-Lane Two-Way; Crash Wall","index":3,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,3],[34,0,34,2]]}
["PIER PROTECTION BARRIER LENGTH OF NEED v1.0 "]
["  For FDOT Standard Plans, Index 521-002",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["TAB D:  SHIELDING FOR FAR LANE OF 2-LANE 2-WAY ROAD USING CRASH WALL EXTENSION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 Pier/Bent Station",1000,"enter as total feet (do not input a plus sign)"]
["Lateral Area Concern, LA (Ft.)",30,"the lesser of the 30 foot setback distance or the distance to the back of the pier/bent, measured from the 'Edge of Traffic Lane'"]
["Lateral Offset of Crash Wall, Y (Ft.)",10,"the Crash Wall's offset from the 'Edge of Traffic Lane', measured from the approach end edge of the Crash Wall (Crash Wall Station Point)"]
["Lateral Clearance, LC (Ft.)\n(Barrier/Wall to Pier/Bent)",10,"minimum distance from the back of barrier or crash wall to the pier or bent structure (for determination of barrier and crash wall height per AASHTO LRFD 3.6.5.1)"]
[null,"Output:"]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":330}]
["Barrier/Crash Wall Height (In.)",{"$f":"IF(B27>10,44,54)","v":54}]
["Length of Need, X (Ft.)",{"$f":"(B25-B26)/(B25/B29)","v":220},"AASHTO RDG (5-3)"]
["Crash Wall Station\n(Far Lane Approach) ",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B31),(B24-B31))","v":780}]
[]
["Near Lane Design Note:"]
["For the opposing end, design the Begin/End PPB Sta. or Crash Wall Sta. for the \"Near Lane\" approach using Tabs A or C, respectively.\n\nThis Spreadsheet considers Pier Protection only. Crash Wall and blunt ends of the PPB require crash worthiness considerations for vehicle benefit, such as shielding with Crash Cushions or continuation to Guardrail or Concrete Barrier. "]

{"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\n\nThe required Barrier Height is based upon AASHTO LRFD Bridge Design Specifications, Seventh Edition 2014"]
[]
[]
[]
["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"]