{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Roadside Hazard","Bridge Approach with C.C.","Bridge Approach with Terminal","Rigid Barrier Approach","RDG Data","Policy","Version History"],"not_rendered":{"charts":0,"images":9,"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":"Roadside Hazard","index":0,"n_rows":85,"n_cols":4,"rows_kept":85,"cut":false,"hidden":false,"merged":[[84,0,84,1],[79,3,84,3],[39,0,39,5],[37,0,37,1],[77,0,77,3],[80,0,80,1],[82,0,82,1]]}
["GUARDRAIL LENGTH OF NEED v1.2 - ROADSIDE HAZARD SHIELDING: "]
["  For FDOT Standard Plans, Index 536-001",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["PART A: LENGTH OF NEED FOR NEAR LANE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",50]
["Approach Face of Hazard Station",1000,"enter as total feet (do not input a plus sign)"]
["Length of Hazard, LH (Ft.)",10]
["Lateral Area Concern, LA (Ft.)",35,"the lesser distance  from the 'Edge of Traffic Lane' to the 'Clear Zone Limit' or 'Back of Hazard'"]
["Lateral Offset of Guardrail, LO (Ft.)",10,"the typical guardrail offset from the 'Edge of Traffic Lane,' near the 'Hazard' location (outside of flare)"]
["Length of Gating, LG (Ft.)",12.5,"\"Gating\" Terminals typically have a 'Start LON' at Post 3 or Post 4 per the APL Drawings. For \"Non-Gating\" Terminals, the 'Start LON' is at 'Post 1' (LG =0). \nNOTE: Prior to use of \"Non-Gating\" terminals, verify availability of applicable options on the APL (MASH required for new projects). "]
["Terminal Flare @ Post(1)  (Ft.)",0,"This input equals 0 Ft. where RDB18-02 applies for new projects with MASH terminals; flared terminals are not available. Otherwise, this input has a 4 Ft. max. for old NCHRP350 designs."]
["Flare's Taper Length (Ft.)",35,"default value is acceptable at 35'-0\", but this may be refined per specific APL drawing (Input used to calculate 'Y')"]
[null,"Output:"]
["End Treatment Offset, Y (Ft.)",{"$f":"IF(B30<B28,B27,B27+B29-(B28/IF(B30=0,1,B30))*B29)","v":10}]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":230}]
["Length of Need, X (Ft.)",{"$f":"(B26-B32)/(B26/B33)","v":164.28571428571428},"AASHTO RDG (5-3)"]
["Unadjusted Begin/End Guardrail Sta. \n@ Primary Approach Terminal",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B34+B28),(B24-B34-B28))","v":1176.7857142857142}]
["Unadjusted Begin/End Guardrail Sta. \n@ Trailing Anchorage (If Applicable)",{"$f":"IF(B60=\"No\",IF(OR(B21=\"Westbound\",B21=\"Southbound\"), (B24-B25-25),(B24+B25+25)),\"N.A.\")","v":965}]
[]
["*NOTE: If the Trailing Anchorage shown herein is in the Clear Zone of an opposing Traffic Lane,  use an Approach Terminal in its place."]
[]
["PART B: LENGTH OF NEED FOR FAR LANE - OPPOSING DIRECTION (IF APPLICABLE)\n('Part A' Extension, If Required For 2-Lane, 2-Way Road with Hazard in Far Lane's Clear Zone)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["PART B Required?\n(User Input Needed)","No","Is this a 2-lane, 2-way road with the Hazard in the Far Lane's Clear Zone limit? If \"No\" Part B will be excluded from the placement calculation output below."]
["Lateral Area Concern, LA (Ft.)",32,"the lesser distance  from the 'Edge of Traffic Lane' (Far Lane) to the 'Clear Zone Limit' or 'Back of Hazard'"]
["Lateral Offset of Guardrail, LO (Ft.)",22,"the typical guardrail offset from the 'Edge of Traffic Lane' (Far Lane), near the 'Hazard' location (outside of flare)"]
["Length of Gating, LG (Ft.)",12.5,"per the APL Drawings, \"Gating\" Terminals typically have a 'Start LON' at Post 3 or Post 4. For \"Non-Gating\" Terminals, the Start LON is at 'Post 1' (LG =0). \nNOTE: The flare rate effect on Lg, assumed parallel to the roadway, is negligible and may be omitted."]
["Terminal Flare @ Post(1)  (Ft.)",0,"This input equals 0 Ft. where RDB18-02 applies for new projects with MASH terminals; flared terminals are not available. Otherwise, this input has a 4 Ft. max. for old NCHRP350 designs."]
["Flare's Taper Length (Ft.)",35,"default value is acceptable at 35'-0\", but this may be refined per specific APL drawing (Input used to calculate 'Y')"]
[null,"Output:"]
["End Treatment Offset, Y (Ft.)",{"$f":"IF(B60=\"No\",\"N.A.\",IF(B65<B63,B62,B62+B64-(B63/IF(B65=0,1,B65))*B64))","v":"N.A."}]
["Direction of Far Lane Traffic",{"$f":"IF(B60=\"No\",\"N.A.\",IF(B21=\"Westbound\",\"Eastbound\",IF(B21=\"Eastbound\", \"Westbound\",IF(B21=\"Northbound\",\"Southbound\",IF(B21=\"Southbound\",\"Northbound\")))))","v":"N.A."}]
["Approach Face of Hazard Station (Far Lane)",{"$f":"IF(B60=\"Yes\",IF(OR(B21=\"Westbound\",B21=\"Southbound\"), (B24-B25),(B24+B25)),\"N.A.\")","v":"N.A."}]
["Runout Length, LR (Ft.)",{"$f":"IF(B60=\"Yes\",INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1)),\"N.A.\")","v":"N.A."}]
["Length of Need, X (Ft.)",{"$f":"IF(B60=\"Yes\",(B61-B67)/(B61/B70),\"N.A.\")","v":"N.A."},"AASHTO RDG (5-3)"]
["Unadjusted Begin/End Guardrail Sta.\n@ Secondary Approach Terminal",{"$f":"IF(B60=\"Yes\",IF(OR(B21=\"Westbound\",B21=\"Southbound\"), B24-B25-B71-B63,B24+B25+B71+B63),\"N.A.\")","v":"N.A."}]
[]
["Unadjusted Length",{"$f":"IF(B82=\"-\",ABS(B72-B35),ABS(B36-B35))","v":211.78571428571422}]
["Adjusted Length",{"$f":"ROUNDUP(B74/6.25, 0)*6.25","v":212.5}]
["Adjustment Reqd.",{"$f":"IF(B82=\"-\", (B75-B74)/2, (B75-B74))","v":0.71428571428577925},"Only added to approach ends, value automatically splits for two approach ends"]
["Total Length of Guardrail (Ft.)\n(Prior to Curve Adjustments)",{"$f":"IF(B82=\"-\",ABS(C80-C84),ABS(C80-C82))","v":212.5},"Program check based on outputs"]
["DESIGN OUTPUT SUMMARY: GUARDRAIL ROADSIDE HAZARD SHIELDING"]
[null,"Limit:","Output:"]
["Adjusted Begin/End Guardrail Sta.\n@ PRIMARY Approach Terminal\n(From Part A)",{"$f":"IF(OR(B21=\"Eastbound\",B21=\"Northbound\"),\"≤\", \"≥\")","v":"≥"},{"$f":"IF(B80=\"≤\",B35-B76,B35+B76)","v":1177.5},"Outputs assume linear stationing: To adjust for curvature, lengthen the guardrail with the Begin/End Guardrail stations placed outside of the stationing limits shown here. Use CADD measurement to bring the final guardrail length to a multiple of 6'-3\" panels."]
["    Guardrail Offset from Nearest Edge of Traffic Lane (Ft.) :  ",null,{"$f":"B27+B29","v":10}]
["Adjusted Begin/End Guardrail Sta. \n@ Trailing Anchorage \n(From Part A, If Applicable)",{"$f":"IF(B36=\"N.A.\",\"-\",IF(OR(B21=\"Eastbound\",B21=\"Northbound\"),\"≥\", \"≤\"))","v":"≤"},{"$f":"B36","v":965}]
["    Guardrail Offset from Nearest Edge of Traffic Lane (Ft.) :  ",null,{"$f":"IF(C82=\"N.A.\", \"N.A.\",B27)","v":10}]
["Adjusted Begin/End Guardrail Sta.\n@ SECONDARY Approach Terminal \n(From Part B, If Applicable)",{"$f":"IF(B72=\"N.A.\",\"-\",IF(OR(B21=\"Eastbound\",B21=\"Northbound\"),\"≥\", \"≤\"))","v":"-"},{"$f":"IF(B84=\"≥\",B72+B76,IF(B84= \"≤\", B72-B76, \"N.A.\"))","v":"N.A."}]
["    Guardrail Offset from Nearest Edge of Traffic Lane (Ft.) :  ",null,{"$f":"IF(C84=\"N.A.\", \"N.A.\",B27+B64)","v":"N.A."}]

{"sheet":"Bridge Approach with C.C.","index":1,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,0,2,0],[56,0,56,1],[53,0,53,1],[40,0,40,2],[4,0,4,3],[54,0,54,1],[55,0,55,1],[41,2,51,2],[52,0,52,1]]}
["GUARDRAIL LENGTH OF NEED v1.2 - BRIDGE CONCRETE RAILING SHIELDING"]
["  For FDOT Standard Plans, Index 536-001\n  (New or Compatible Rigid Barrier \n  End with No Approach Slab Conflict)",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["PART C: CROSSOVER GUARDRAIL WITH 'CRASH CUSHION' -  \nSHIELDING CONCRETE RAILING ACROSS MEDIAN (WITHIN CLEAR ZONE)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",50]
["Begin/End Rigid Barrier Sta. \n(@ Barrier Closest the Near Traffic Lane)",{"$f":"9900+7.25/12","v":9900.6041666666661},"enter as total feet (do not input a plus sign); located at the end of the 'Rigid Barrier' (not the Begin/End Guardrail Sta.)"]
["Lateral Offset of Guardrail, LO (Ft.)",6,"the starting guardrail offset from the 'Edge of Near Traffic Lane' at the location where the guardrail connects to the 'Rigid Barrier' (determined by the designer)"]
["Lateral Area Concern, LA (Ft.)",30,"the lateral distance from the 'Edge of Near Traffic Lane' to the far edge of the opposing 'Rigid Barrier' (i.e. Concrete Traffic Railing) across the median"]
["Parallel Approach Trans. Length, LP1 (Ft.)",{"$f":"12+6/12+6+3/12+9+4.5/12-7.25/12","v":27.520833333333332},"the length of the guardrail Approach Transition Connection prior to the start of the taper; per Index 536-001 options, \nTL-3=27.5 Ft.  and TL-2=18.2 Ft.\nNOTE: This is measured from the end of the 'Rigid Barrier' (not the 'Begin/End Guardrail Sta.')"]
["Parallel C.C. Trans. Length, LP2 (Ft.)",{"$f":"18+9/12+3+1.5/12","v":21.875},"the length of the parallel segment required for Guardrail Transition, just beyond the taper. This is the length between Post (1) and Post (10) per Index 430, 21.9 Ft. "]
["Taper Rate of Crossover, 1:TR (Ft.)",15,"the linear taper rate for the Median Crossover Segment; 1:10 for Design Speeds ≤  45 MPH and 1:15 for Design Speeds > 45 MPH."]
["Rigid Barrier Skew, S (Ft.)",10,"the longitudinal \"skew\" distance between the guardrail's connecting Rigid Barrier end and the 'Hazard' Rigid Barrier end (across the median). For the direction opposite the drawing dimension, use a negative value."]
["Parallel Length Total, LP",{"$f":"B27+B28","v":49.395833333333329}]
["Unadjusted Length of Need",{"$f":" (B29*B30*B26-B43*(B29*B25-B29*B26-B31))/(B43+B29*B26)","v":145.08976715686273}]
["Unadjusted Y",{"$f":"(B32-(B27+B28))/B29+B25","v":12.379595588235293}]
["Unadjusted Length Crossover Parallel",{"$f":"B32-B27-B28","v":95.693933823529406}]
["Unadjusted Length Crossover Panels",{"$f":"SQRT((B34)^2+(B33-B25)^2)","v":95.90635125210143}]
["Adjusted Length Crossover Panels",{"$f":"ROUNDUP(B35/6.25,0)*6.25","v":100}]
["Taper Angle",{"$f":"ATAN(1/B29)*180/3.14","v":3.8160093884230211}]
["Adjusted Length Crossover Parallel",{"$f":"COS(B37*3.14/180)*B36","v":99.778515785660886}]
["Adjusted Y",{"$f":"SIN(B37*3.14/180)*B36+B25","v":12.651901052377394}]
["Adjusted Length of Need",{"$f":"B38+B27+B28","v":149.1743491189942}]
["PART C: OUTPUT SUMMARY: "]
["End Treatment Offset, Y (Ft.)",{"$f":"B39","v":12.651901052377394},"The outputs assume stationing is linear and are adjusted to bring tapered segment panel lengths to a multiple of 6'-3\".\n\nThe output stations may be used directly in the Plans, assuming that roadway curvature does not cause a discrepancy of more than 3'-0\"  between the these output stations and the actual guardrail panel slot & post locations (Tolerance per Specification Section 536).\n\nIf adjustments for curvature are required to bring the stationing closer to the actual panel slot & post locations, use LP1 and  LP2, adjusted for curvature, and add additional length to the taper segment as needed."]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":230}]
["Length of Need, XS (Ft.)",{"$f":"B40","v":149.1743491189942}]
["Begin/End Guardrail Sta. \n@ Connection to Rigid Barrier",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24-7.25/12),(B24+7.25/12))","v":9900}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B25","v":6}]
["Begin/End Taper Sta.",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B27),(B24-B27))","v":9928.125}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B25","v":6}]
["Begin/End Taper Sta.",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B27+B38),(B24-B27-B38))","v":10027.903515785662}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B42","v":12.651901052377394}]
["Begin/End Guardrail Sta. \n@ Connection Post (1)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B44),(B24-B44))","v":10049.77851578566}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B42","v":12.651901052377394}]
[]
[]
["   Modified AASHTO RDG (5-3) Length of Need Equation:\n   (Solves for 'XS' given a Taper Rate 'TR' and Skew 'S')"]
[]
["    Where:"]

{"sheet":"Bridge Approach with Terminal","index":2,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,2,0],[56,0,56,1],[57,0,57,1],[53,0,53,1],[4,0,4,3],[41,0,41,2],[55,0,55,1],[42,2,52,2],[54,0,54,1]]}
["GUARDRAIL LENGTH OF NEED v1.2 - BRIDGE CONCRETE RAILING SHIELDING"]
["  For FDOT Standard Plans, Index 536-001\n  (New or Compatible Rigid Barrier \n  End with No Approach Slab Conflict)",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["PART D: CROSSOVER GUARDRAIL WITH 'APPROACH TERMINAL' - \nSHIELDING CONCRETE RAILING ACROSS MEDIAN (WITHIN CLEAR ZONE)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",50]
["Begin/End Rigid Barrier Sta. \n(@ Barrier Closest the Near Traffic Lane)",9000.6,"enter as total feet (do not input a plus sign); located at the end of the 'Rigid Barrier' (not the Begin/End Guardrail Sta.)"]
["Lateral Offset of Guardrail, LO (Ft.)",6,"the starting guardrail offset from the 'Edge of Near Traffic Lane' at the location where the guardrail connects to the 'Rigid Barrier' (determined by the designer)"]
["Lateral Area Concern, LA (Ft.)",30,"the lateral distance from the 'Edge of Near Traffic Lane' to the far edge of the opposing 'Rigid Barrier' (i.e. Concrete Traffic Railing) across the median"]
["Parallel Approach Trans. Length, LP1 (Ft.)",{"$f":"12+6/12+6+3/12+9+4.5/12-7.25/12","v":27.520833333333332},"the length of the guardrail Approach Transition Connection prior to the start of the taper; per Index 536-001 options, \nTL-3=27.5 Ft.  and TL-2=18.2 Ft.\nNOTE: This is measured from the end of the 'Rigid Barrier' (not the 'Begin/End Guardrail Sta.')"]
["Parallel Approach Terminal Length, LP2 (Ft.)",56.25,"the length of the parallel segment required for the Approach Terminal, just beyond the taper; Per Index 400, TL-3 = 56.3 Ft."]
["Length of Gating, LG (Ft.)",12.5,"\"Gating\" Terminals typically have a 'Start LON' at Post 3 or Post 4 per the APL Drawings. For \"Non-Gating\" Terminals, the 'Start LON' is at 'Post 1' (LG =0). \nNOTE: Prior to use of \"Non-Gating\" terminals, verify availability of applicable options on the APL (MASH required for new projects). "]
["Taper Rate of Crossover, 1:TR (Ft.)",15,"the linear taper rate for the Median Crossover Segment; 1:10 for Design Speeds ≤  45 MPH and 1:15 for Design Speeds > 45 MPH."]
["Rigid Barrier Skew, S (Ft.)",10,"the longitudinal \"skew\" distance between the guardrail's connecting Rigid Barrier end and the \"Hazard\" Rigid Barrier end (across the median). For the direction opposite the drawing dimension, use a negative value."]
["Parallel Length Total, LP",{"$f":"B27+B28-B29","v":71.270833333333329}]
["Unadjusted Length of Need",{"$f":" (B30*B31*B26-B44*(B30*B25-B30*B26-B32))/(B44+B30*B26)","v":152.48866421568627}]
["Unadjusted Y",{"$f":"(B33-(B27+B28-B29))/B30+B25","v":11.414522058823529}]
["Unadjusted Length Crossover Parallel",{"$f":"B33-B27-(B28-B29)","v":81.217830882352942}]
["Unadjusted Length Crossover Panels",{"$f":"SQRT((B35)^2+(B34-B25)^2)","v":81.398114857531993}]
["Adjusted Length Crossover Panels",{"$f":"ROUNDUP(B36/6.25,0)*6.25","v":87.5}]
["Taper Angle",{"$f":"ATAN(1/B30)*180/3.14","v":3.8160093884230211}]
["Adjusted Length Crossover Parallel",{"$f":"COS(B38*3.14/180)*B37","v":87.306201312453283}]
["Adjusted Y",{"$f":"SIN(B38*3.14/180)*B37+B25","v":11.820413420830219}]
["Adjusted Length of Need",{"$f":"B39+B27+(B28-B29)","v":158.57703464578663}]
["PART D: OUTPUT SUMMARY: "]
["End Treatment Offset, Y (Ft.)",{"$f":"B40","v":11.820413420830219},"The outputs assume stationing is linear and are adjusted to bring tapered segment panel lengths to a multiple of 6'-3\".\n\nThe stations provided here may be used directly in the Plans, assuming that roadway curvature does not cause a discrepancy of more than 3'-0\"  between the these output stations and the actual guardrail panel slot/post locations (Tolerance per Specification Section 536).\n\nIf adjustments for curvature are required to bring the stationing closer to the actual panel slot and post locations, use LP1 and LP2, adjusted for curvature, and add additional length to the taper segment as needed."]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":230}]
["Length of Need, XS (Ft.)",{"$f":"B41","v":158.57703464578663}]
["Begin/End Guardrail Sta. \n@ Connection to Rigid Barrier",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24-7.25/12),(B24+7.25/12))","v":8999.9958333333343}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B25","v":6}]
["Begin/End Taper Sta.",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B27),(B24-B27))","v":9028.1208333333343}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B25","v":6}]
["Begin/End Taper Sta.",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B27+B39),(B24-B27-B39))","v":9115.427034645787}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B43","v":11.820413420830219}]
["Begin/End Guardrail Sta. \n@ Post (1)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B24+B45+B29),(B24-B45-B29))","v":9171.677034645787}]
["Offset from Edge of Near Traffic Lane (Ft.)",{"$f":"B43","v":11.820413420830219}]
[]
[]
["   Modified AASHTO RDG (5-3) Length of Need Equation:\n   (Solves for 'XS' given a Taper Rate 'TR' and Skew 'S')"]
[]
["    Where:"]

{"sheet":"Rigid Barrier Approach","index":3,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,0,55,2],[49,3,51,3],[51,0,51,1],[4,0,4,3],[1,0,2,0]]}
["GUARDRAIL LENGTH OF NEED v1.2 - RIGID BARRIER & HAZARD SHIELDING: "]
["  For FDOT Standard Plans, Index 536-001\n  (New or Compatible Rigid Barrier \n  End with No Approach Slab Conflict)",null,"Roadway Name / Feature:"]
[null,null,"FPID:"]
[null,null,"Designer:"]
["PART E: LENGTH OF NEED FOR SIMPLE LAYOUT TO RIGID BARRIER - \n(ANY OPPOSING LANE'S RIGID BARRIER IS OUTSIDE OF CLEAR ZONE)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input:","Comment:"]
["Direction of Near Lane Traffic","Westbound","for relative stationing calculations"]
["AADT (Vehicles Per Day)",10000]
["Design Speed (MPH)",55]
["Approach Transition Connection Type","TL-3","from Index 536-001, either TL-2 or TL-3 length"]
["Begin/End Rigid Barrier Sta. ",10000.6,"enter as total feet (do not input a plus sign); located at the end of the 'Rigid Barrier' (not the Begin/End Guardrail Sta.)"]
["Approach Face of Hazard Sta.",9980,"enter as total feet (do not input a plus sign)"]
["Length of Hazard, LH (Ft.)",10]
["Lateral Area Concern, LA (Ft.)",35,"the lesser distance  from the 'Edge of Near Traffic Lane' to the 'Clear Zone Limit' or 'Back of Hazard'"]
["Lateral Offset of Guardrail, LO (Ft.)",10,"the typical guardrail offset from the 'Edge of Traffic Lane' at the connection point to the Approach Terminal segment (offset excludes Flare, if applicable)"]
["Approach Terminal Design Length (Ft.)",53.1,"from Index 536-001, predefined length is 53.1' for TL-3 and 40.6' for TL-2; values may be adjusted per specific SPI design length (requires specific Plans callout, see SPI)"]
["Length of Gating, LG (Ft.)",12.5,"\"Gating\" Terminals typically have a 'Start LON' at Post 3 or Post 4 per the APL Drawings. For \"Non-Gating\" Terminals, the 'Start LON' is at 'Post 1' (LG =0). \nNOTE: Prior to use of \"Non-Gating\" terminals, verify availability of applicable options on the APL (MASH required for new projects). "]
["Terminal Flare @ Post(1)  (Ft.)",0,"This input equals 0 Ft. where RDB18-02 applies for new projects with MASH terminals; flared terminals are not available. Otherwise, this input has a 4 Ft. max. for old NCHRP350 designs."]
["Flare's Taper Length (Ft.)",35,"default value is acceptable at 35'-0\", but this may be refined per specific APL drawing (Input used to calculate 'Y')"]
["delta Hazard to Rigid Barrier (Ft.)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B26-B25),(B25-B26))","v":-20.600000000000364}]
["Approach Trans. Length",{"$f":"IF(B24=\"TL-2\",21.875,31.25)","v":31.25}]
["XL + LG unadjusted",{"$f":"B43+B34+B31","v":181.18571428571391}]
["XL + LG adjusted to nearest panel",{"$f":"ROUNDUP((B36-B35-B30)/6.25,0)*6.25+B35+B30","v":184.35},null,"TL-2"]
["XL + LG adjusted for minimum length",{"$f":"IF(B36<(B35+B30),(B30+B35),B37)","v":184.35},null,"TL-3"]
[null,"Output:"]
["Approach Transition Length",{"$f":"B35","v":31.25}]
["End Treatment Offset, Y (Ft.)",{"$f":"IF(B33<B31,B29,B29+B32-(B31/IF(B33=0,1,B33))*B32)","v":10}]
["Runout Length, LR (Ft.)",{"$f":"INDEX(value,MATCH(B23,row,-1),MATCH(B22,col,1))","v":265}]
["Length of Need, X (Ft.)",{"$f":"(B28-B41)/(B28/B42)","v":189.28571428571428},"AASHTO RDG (5-3)"]
["Length of Need, XL (Ft.)",{"$f":"B43+B34","v":168.68571428571391}]
["Unadjusted Begin/End Guardrail Sta. \n@ Rigid Barrier",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B25-7.25/12),(B25+7.25/12))","v":9999.9958333333343}]
["Unadjusted Begin/End Guardrail Sta. \n@ Approach Terminal, Post(1)",{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B45+B44+B31),(B45-B44-B31))","v":10181.181547619048}]
[]
["DESIGN OUTPUT SUMMARY:"]
[null,"Limit:","Output:"]
["Adjusted Begin/End Guardrail Sta.\n@ Connection to Rigid Barrier","=",{"$f":"B45","v":9999.9958333333343},"Outputs assume linear stationing: \nTo adjust for curvature, lengthen the guardrail with the Begin/End Guardrail stations placed outside of the stationing limits shown here. Use CADD measurement to bring the final guardrail length to buildable length, including the Approach Transition, End Treatment, and 6'-3\" panel multiple."]
["*Adjusted Begin/End Guardrail Sta.\n@ Approach Terminal, Post(1)",{"$f":"IF(OR(B21=\"Eastbound\",B21=\"Northbound\"),\"≤\", \"≥\")","v":"≥"},{"$f":"IF(OR(B21=\"Westbound\",B21=\"Southbound\"),(B45+B38),(B45-B38))","v":10184.345833333335}]
["                  Guardrail Offset from Nearest Edge \n                              of Traffic Lane (Ft.) @ Post(1):  ",null,{"$f":"B29+B32","v":10}]
[]
["*NOTE: Stationing is automatically adjusted to the Approach Transition length plus the Approach Terminal length plus the 6'-3\" panel length increment (not accounting for curvature effects). Where 'Length of Need' does not govern, the minimum length of guardrail required is the Approach Transition length plus the Approach Terminal length (stationing outputs account for this)."]

{"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Version:","Released:","Changes:"]
["v1.0","2016-02-09","initial release"]
["v1.01","2016-03-01","Part D: updated default LP2 for TL-3 option to match Index 400 layout; removed TL-2 option"]
["v1.02","2016-03-07","added \"Rigid Barrier Approach\" (Part E) module for additional layout option"]
["v1.03","2016-05-10","corrected stationing output for \"Rigid Barrier Approach\" (Part E) to include Length of Gating, Lg"]
["v1.04","2017-10-31","updated for new nomenclature and Index renumbering \"Standard Plans, Index 536-001\""]
["v1.1","2018-11-01","updated departure line location for Crash Cushions per new FY2019-20 Index 544-001; \nremoved \"Type II\" designation from Trailing Anchorage and extended it 25 feet downstream of hazard"]
["v1.2","2019-11-01","removed flared terminal as default option from drawings per RDB18-02 for MASH terminals and added notes to explain limited usage; updated notes to explain current limited availability of gating terminals"]