{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Analysis","Support Tables","Default Values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,3,12],[5,1,5,12],[7,1,7,12],[6,1,6,12]]}
[]
[null,"NCHRP 17-76 Speed Limit Setting Tool"]
[]
[]
[]
[null,"Developed by:  NCHRP 17-76 Research Team"]
[null,"(with Michael P. Pratt leading the spreadsheet development and Kay Fitzpatrick as Principal Investigator)"]
[null,"  Version 1"]
[null,"FOREWORD"]
[null,"This spreadsheet can be used to compute a suggested posted speed limit on roadway segments as a function of site"]
[null,"characteristics, traffic speed data, and crash data."]
[]
[null,"This spreadsheet is intended for use with the report identified below.  The user is encouraged to read the document so that he"]
[null,"or she will have an understanding of how best to use the spreadsheet and interpret its output."]
[]
[null,null,"Fitzpatrick, K., S. Das, T. Gates, M. P. Pratt, and K. Dixon (2021)"]
[null,null,"NCHRP Research Report 966: Posted Speed Limit Setting Procedure and Tool: User Guide"]
[null,null,"The National Academies of Sciences, Engineering, and Medicine."]
[]
[null,"The equations used in this spreadsheet are documented in this report.  Users should refer to the report whenever they have"]
[null,"questions about the modeling approach, assumptions, or limitations."]
[]
[null,"INSTRUCTIONS"]
[null,"This spreadsheet consists of four worksheets.  The Welcome worksheet (this one) provides an overview."]
[null,"The Analysis worksheet is used to calculate a suggested speed limit for a roadway segment of interest.  "]
[null,"The Support Tables worksheet contains data tables that are used in the calculations."]
[null,"The Default Values worksheet contains default data entry cell values."]
[]
[null,"Analysis Worksheet"]
[null,"This worksheet is used to enter input data and obtain analysis results.  Key cells on this worksheet have been color-coded"]
[null,"to indicate the type of data entered or displayed.  A color-coding legend is provided on the Analysis worksheet."]
[null,"Analysis worksheet cells that contain intermediate calculations or results are locked and cannot be changed."]
[]
[null,"The Analysis worksheet is programmed with macros to display required data input cells and hide unneeded data"]
[null,"input cells.  Macros must be enabled for the program to function properly."]
[]
[null,null,"Click the \"Test macros\" button to obtain a message box verifying proper macro operation."]
[]
[null,null,"Click the \"Clear all data\" button to clear all input data and results calculations from the Analysis worksheet."]
[]
[null,null,"Click the \"Enter default values\" button to populate the Analysis worksheet with default data values for a new segment."]
[null,null,"See the Important Notice on the Default Values worksheet for more information about the meaning and application of"]
[null,null,"the default values."]
[]
[null,"Support Tables Worksheet"]
[null,"This worksheet contains the following tables that are used in the Analysis calculations:"]
[null,null,"  •  Minimum Segment Lengths by Speed Limit"]
[null,null,"  •  Upper and Lower Speed Limits by Group"]
[null,null,"  •  HSIS Crash Rates"]
[null,null,"  •  Speed Limit Setting Groups"]
[null,"These tables contain yellow cells to indicate that the values can be altered, but should be altered only based on agency policy"]
[null,"or statistical analysis of field data."]
[]
[null,"Default Values Worksheet"]
[null,"This worksheet contains default data entry cell values.  If the user enters these values into the Analysis worksheet, the analysis "]
[null,"will yield a speed limit based on the closest 85th-percentile speed for limited-access, developed, or undeveloped segments,"]
[null,"or the closest 50th-percentile speed for full-access segments."]
[]
[null,"DISCLAIMER"]
[null,"No warranty is made by the developers or their employer as to the accuracy, completeness, or reliability of this spreadsheet"]
[null,"and its associated equations and documentation.  No responsibility is assumed by the developers for incorrect results or"]
[null,"damages resulting from the use of this spreadsheet."]
[]
[null,"COPYRIGHT © 2021"]
[null,"This spreadsheet is copyrighted.  All rights are reserved.  This product may not, in whole or in part, be copied, photocopied, "]
[null,"reproduced, translated, or reduced to any electronic medium or machine-readable form without prior consent, in writing, from"]
[null,"the National Academies of Sciences, Engineering, and Medicine.  This product is subject to change without notice and does not"]
[null,"represent a commitment on the part of the National Academies of Sciences, Engineering, and Medicine to notify any person of"]
[null,"such revision."]

{"sheet":"Analysis","index":1,"n_rows":70,"n_cols":38,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,19,1,29]]}
[]
[null,"NCHRP 17-76 Speed Limit Setting Tool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate Calculations — These cells are protected and should not be altered."]
[null,"Input Cells","Description","Output Cells"]
[null,"Site Description Data",null,null,null,"Color-Coding Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lists and limits",null,null,null,null,"Index","Calc","RD50","C50","RD85","Code",null,"Speed sum","RD50","C50","RD85",null,"Criterion","Speed"]
[null,null,"Roadway context",null,{"$f":"IF(LEN(B5)>0,\"\",\"O\")","v":"O"},"Aqua = basic input cell",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Support Tables'!C12","v":"Rural"},{"$f":"'Support Tables'!D12","v":"Rural town"},{"$f":"'Support Tables'!E12","v":"Suburban"},{"$f":"'Support Tables'!F12","v":"Urban"},{"$f":"'Support Tables'!G12","v":"Urban core"},null,null,null,null,null,null,null,"Limited access",0,{"$f":"SUM(AB$58:AB$70)+SUM(AB28:AB33)","v":0},{"$f":"SUM(AC$58:AC$70)+SUM(AC28:AC33)","v":2},null,"C85",{"$f":"5*INT((B21+2.5)/5)","v":0}]
[null,null,"Roadway type",null,{"$f":"IF(LEN(B6)>0,\"\",\"O\")","v":"O"},"Denim = basic input cell with drop-down menu",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE('Support Tables'!B13:B17)","v":"Freeway"},"Principal arterial","Minor arterial","Collector","Local",null,null,null,null,null,null,null,"Developed",0,{"$f":"SUM(AB$58:AB$70)+SUM(AB34:AB43)","v":0},{"$f":"SUM(AC$58:AC$70)+SUM(AC34:AC43)","v":0},null,"RD85",{"$f":"5*INT(B21/5)","v":0}]
[null,null,"Are crash data available?",null,{"$f":"IF(LEN(B7)>0,\"\",\"O\")","v":"O"},"Orange = optional input cell (not needed for calculations)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,{"$f":"IF(LEN(B7)>0,MATCH(B7,T7:U7,0),0)","v":0},null,null,null,null,null,null,"Undeveloped",0,{"$f":"SUM(AB$58:AB$70)+SUM(AB44:AB47)","v":0},{"$f":"SUM(AC$58:AC$70)+SUM(AC44:AC47)","v":0},null,"C50",{"$f":"5*INT((B22+2.5)/5)","v":0}]
[null,null,"Analyst",null,{"$f":"\"\"","v":""},"Green = optional input cell (use if data for agency & region are available, leave blank otherwise)",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,"Full access",{"$f":"SUM(AA$58:AA$70)+SUM(AA48:AA56)","v":1},0,0,null,"RD50",{"$f":"5*INT(B22/5)","v":0}]
[null,null,"Date",null,{"$f":"\"\"","v":""},"Rose = intermediate calculations",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,"Calc",{"$f":"IF(LEN($D16)=0,0,VLOOKUP($D16,$AF5:$AI8,2,FALSE))","v":0},{"$f":"IF(LEN($D16)=0,0,VLOOKUP($D16,$AF5:$AI8,3,FALSE))","v":0},{"$f":"IF(LEN($D16)=0,0,VLOOKUP($D16,$AF5:$AI8,4,FALSE))","v":0},null,"Suggested",{"$f":"IF(AG9>0,AL8,IF(AH9>0,AL7,IF(AI9>0,AL6,IF(Y16=4,AL7,AL5))))","v":0}]
[null,null,"Roadway name",null,{"$f":"\"\"","v":""},"Purple = final analysis results"]
[null,null,"Description",null,{"$f":"\"\"","v":""}]
[null,null,"Current speed limit (mph)",null,{"$f":"\"\"","v":""}]
[null,null,"Notes",null,{"$f":"\"\"","v":""},"Note: The \"Test macros\" button provides a message to verify proper macro operation."]
[]
[null,"Analysis Results",null,null,null,"Advisory, Calculated, or Warning Messages"]
[null,null,"Speed limit setting group",{"$f":"IF(AND(LEN(B5)>0,LEN(B6)>0),HLOOKUP(B5,'Support Tables'!B12:G17,MATCH(B6,'Support Tables'!B12:B17,0),FALSE),\"\")","v":""},null,{"$f":"IF(Z16>0,\"Specify roadway context and roadway type in cells B5 and B6.\", \"\")","v":"Specify roadway context and roadway type in cells B5 and B6."},null,null,null,null,null,null,null,null,null,null,null,null,null,"Limited access","Developed","Undeveloped","Full access",null,{"$f":"IF(LEN(D16)>0,MATCH(D16,T16:W16,0),0)","v":0},{"$f":"COUNTIF(E5:E6,\"O\")","v":2},null,null,null,{"$f":"SUMIF(AD28:AD56,Y16,AA28:AA56)+SUMIF(AD28:AD56,Y16,AB28:AB56)+SUMIF(AD28:AD56,Y16,AC28:AC56)","v":0}]
[null,null,"Suggested speed limit (mph)",{"$f":"IF(Z17=0,MAX(T17,MIN(AL9,MIN(U17,B20))),\"\")","v":""},null,{"$f":"IF(Z17=0,IF(AL9<T17,\"The calculated value is below the lower value for this speed limit setting group; therefore, the suggested speed limit reflects the assumed lower value.\",IF(AL9>U17,\"The calculated value exceeds the upper value for this speed limit setting group; therefore, the suggested speed limit reflects the assumed upper value.\", \"This value is determined by \" & IF(AL9>B20,\"the maximum speed limit.\", \"speed data\" & IF(AD16>0,IF(AND(Y7=1,SUM(AA67:AC70)>0),\", site characteristics, & crash data.\",\" & site characteristics.\"),IF(AND(Y7=1,SUM(AA67:AC70)>0), \" & crash data.\",\".\"))))),\"Enter values for all variables marked with O.\")","v":"Enter values for all variables marked with O."},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET('Support Tables'!C20,$Y16,0)","v":"Lower"},{"$f":"OFFSET('Support Tables'!D20,$Y16,0)","v":"Upper"},null,null,null,null,{"$f":"COUNTIF(E5:E70,\"O\")","v":12}]
[]
[null,"Speed Data",null,null,null,"Advisory, Calculated, or Warning Messages"]
[null,null,"Maximum speed limit (mph)",null,{"$f":"IF(ISNUMBER(B20),\"\",\"O\")","v":"O"},{"$f":"IF(Z17=0,IF(MOD(B20,5)<>0,\"Speed limits must be a multiple of 5 mph.\", IF(OR(B20<T20,B20>U20), \"Enter a value between \" & T20 & \" and \" & U20 & \" mph.\", IF(B20>U17,\"The assumed upper value for this speed limit setting group is \" & U17 & \" mph.\",IF(B20<T17,\"The assumed lower value for this speed limit setting group is \" & T17 & \" mph.\", \"\")))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN('Support Tables'!C21:C24)","v":15},{"$f":"MAX('Support Tables'!D21:D24)","v":85}]
[null,null,"85th-percentile speed (mph)",null,{"$f":"IF(AND(Y$16<4,ISNUMBER(B21)=FALSE),\"O\",\"\")","v":"O"},{"$f":"IF(AND(Z17=0,B21<B22),\"The 85th percentile must be greater than the 50th percentile.\",\"\")","v":""}]
[null,null,"50th-percentile speed (mph)",null,{"$f":"IF(ISNUMBER(B22),\"\",\"O\")","v":"O"},{"$f":"IF(AND(Z17=0,B21=B22+1),\"85th percentile is only 1 mph greater than 50th percentile.  Interpret results with caution.\",\"\")","v":""}]
[]
[null,"Site Characteristics",null,null,null,"Advisory, Calculated, or Warning Messages"]
[null,null,"Segment length (mi)",null,{"$f":"IF(ISNUMBER(B25),\"\",\"O\")","v":"O"},{"$f":"IF(AND(Z17=0,B25<Z25),\"For a suggested speed limit of \" & D17 & \" mph, minimum segment length = \" & Z25 & \" mi.\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B25,0.1)","v":0.1},{"$f":"VLOOKUP(IF(Z17=0,MAX(15,MIN(85,D17)),MAX('Support Tables'!B28:B42)),'Support Tables'!B28:C42,2,FALSE)","v":6.2}]
[null,null,"AADT (two-way total) (veh/d)",null,{"$f":"IF(AND(OR(Y$16=1,Y$16=3),ISNUMBER(B26)=FALSE),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 or 3"]
[null,null,"Number of lanes (two-way total)",null,{"$f":"IF(ISNUMBER(B27),\"\",\"O\")","v":"O"},{"$f":"IF(AND(Z17=0,OR(B27<T27,B27>U27)),\"Number of lanes must be between \" & T27 & \" and \" & U27 & \".\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=T16,4,2)","v":2},{"$f":"IF(D16=T16,12,IF(D16=V16,6,8))","v":8}]
[null,null,"Directional design-hour truck volume (trk/hr)",null,{"$f":"IF(AND(Y$16=1,ISNUMBER(B28)=FALSE),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Number of interchanges",null,"",{"$f":"IF(Z17=0,IF(AB29=1,\"Closest 50th (\" & T29 & \")\",IF(AC29=1,\"Rounded-Down 85th (\" & T29 & \")\",T29)),IF(ISNUMBER(B29),T29,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y29 & \" mile\" & IF(Y29=1,\"\",\"s\") & \" between interchanges\"","v":"0 miles between interchanges"},{"$f":"SUM(AA29:AC29)","v":0},null,null,null,{"$f":"ROUND(Z29,2)","v":0},{"$f":"B25/MAX(B29,0.1)","v":0},null,{"$f":"IF(AND(Z29<=0.5,B26>=180000),1,0)","v":0},{"$f":"IF(AND(Z29>0.5,Z29<=1,B26>=180000),1,0)","v":0},1]
[null,null,"Design speed (mph)",null,{"$f":"IF(AND(Y$16=1,LEN(B30)=0),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≤ 55 mph","≥ 60 mph",null,null,null,null,null,null,null,null,1]
[null,null,"Grade (%)",null,"",{"$f":"IF(AND(Z17=0,AC31=1),\"Rounded-Down 85th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(B30=U30,OR(B31>4)),AND(B30=T30,B31>5)),1,0)","v":0},1]
[null,null,"Outside shoulder width (ft)",null,"",{"$f":"IF(AND(Z17=0,AC32=1),\"Rounded-Down 85th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,14,null,null,null,null,null,null,null,{"$f":"IF(B32<8,1,0)","v":1},1]
[null,null,"Inside shoulder width (ft)",null,"",{"$f":"IF(AND(Z17=0,AC33=1),\"Rounded-Down 85th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,14,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(B28>250,B33<12),AND(B28<=250,B27>=6,B33<10),AND(B28<=250,B27<6,B33<4)),1,0)","v":1},1]
[null,null,"Median type",null,{"$f":"IF(AND(Y$16=2,LEN(B34)=0),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,AC34=1),\"Rounded-Down 85th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Undivided","TWLTL","Divided",null,null,{"$f":"IF(LEN(B34)>0,MATCH(B34,T34:V34,0),0)","v":0},null,null,null,{"$f":"IF(AND(Y34=1,B27>=4),1,0)","v":0},2]
[null,null,"Number of traffic signals",null,{"$f":"IF(AND(Y$16=2,ISNUMBER(B35)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB35=1,\"Closest 50th (\" & T35 & \")\",IF(AC35=1,\"Rounded-Down 85th (\" & T35 & \")\",T35)),IF(ISNUMBER(B35),T35,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z35,2) & \" signal\" & IF(ROUND(Z35,2)=1, \"\", \"s\") & \" / mi\"","v":"0 signals / mi"},{"$f":"SUM(AA35:AC35)","v":0},null,null,null,null,{"$f":"B35/Y25","v":0},null,{"$f":"IF(Z35>4,1,0)","v":0},{"$f":"IF(AND(Z35>3,Z35<=4),1,0)","v":0},2]
[null,null,"Number of access points (total of both directions)",null,{"$f":"IF(AND(Y$16=2,ISNUMBER(B36)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB36=1,\"Closest 50th (\" & T36 & \")\",IF(AC36=1,\"Rounded-Down 85th (\" & T36 & \")\",T36)),IF(ISNUMBER(B36),T36,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z36,2) & \" access point\" & IF(ROUND(Z36,2) = 1, \"\", \"s\") & \" / mi\"","v":"0 access points / mi"},{"$f":"SUM(AA36:AC36)","v":0},null,null,null,null,{"$f":"B36/Y25","v":0},null,{"$f":"IF(Z36>60,1,0)","v":0},{"$f":"IF(AND(Z36>40,Z36<=60),1,0)","v":0},2]
[null,null,"Bicyclist activity / bike lane type",null,{"$f":"IF(AND(Y$16=2,LEN(B37)=0),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB37=1,\"Closest 50th\",IF(AC37=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High / Not separated","High / Separated","Not high / Any type",null,null,{"$f":"IF(LEN(B37)>0,MATCH(B37,T37:V37,0),0)","v":0},null,null,{"$f":"IF(Y37=1,1,0)","v":0},{"$f":"IF(Y37=2,1,0)","v":0},2]
[null,null,"Sidewalk presence / width",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","Narrow","Adequate","Wide",null,{"$f":"IF(LEN(B38)>0,MATCH(B38,T38:W38,0),0)","v":0},null,null,null,null,2]
[null,null,"Sidewalk buffer",null,{"$f":"IF(AND(Y$16=2,LEN(B39)=0,Y38>1),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,Y38=1),\"This variable is not shown when the sidewalk presence / width variable is set to ‘None’.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Present","Not present",null,null,null,{"$f":"IF(LEN(B39)>0,MATCH(B39,T39:U39,0),0)","v":0},null,null,null,null,2]
[null,null,"Pedestrian activity",null,{"$f":"IF(AND(Y$16=2,LEN(B40)=0),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB40=1,\"Closest 50th\",IF(AC40=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Some","Negligible",null,null,{"$f":"IF(LEN(B40)>0,MATCH(B40,T40:V40,0),0)","v":0},null,null,{"$f":"IF(AND(Y40<3,OR(Y38=1,AND(Y38=2,Y39=2))),1,0)","v":0},{"$f":"IF(OR(AND(Y40=3,Y38=1),AND(Y40=1,OR(AND(Y38=3,Y39=2),AND(Y38=2,Y39=1)))),1,0)","v":0},2]
[null,null,"On-street parking activity",null,"",{"$f":"IF(AND(Z17=0,AB41=1),\"Closest 50th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Not high",null,null,null,{"$f":"IF(LEN(B41)>0,MATCH(B41,T41:U41,0),0)","v":0},null,null,{"$f":"IF(Y41=1,1,0)","v":0},null,2]
[null,null,"Parallel parking permitted?",null,"",{"$f":"IF(AND(Z17=0,AC42=1),\"Rounded-Down 85th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,{"$f":"IF(LEN(B42)>0,MATCH(B42,T42:U42,0),0)","v":0},null,null,null,{"$f":"IF(Y42=1,1,0)","v":0},2]
[null,null,"Angle parking present?",null,"",{"$f":"IF(Z17=0,IF(AB43=1,\"Closest 50th\",IF(AC43=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, ≥ 40% of segment length","Yes, < 40% of segment length","No",null,null,{"$f":"IF(LEN(B43)>0,MATCH(B43,T43:V43,0),0)","v":0},null,null,{"$f":"IF(Y43=1,1,0)","v":0},{"$f":"IF(Y43=2,1,0)","v":0},2]
[null,null,"Median type",null,{"$f":"IF(AND(Y$16=3,LEN(B44)=0, B27>2),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AC44=1,\"Rounded-Down 85th\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Undivided","Divided",null,null,null,{"$f":"IF(LEN(B44)>0,MATCH(B44,T44:U44,0),0)","v":0},null,null,null,{"$f":"IF(AND(B27>=4,Y44=1,B26>2000),1,0)","v":0},3]
[null,null,"Number of access points (total of both directions)",null,{"$f":"IF(AND(Y$16=3,ISNUMBER(B45)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB45=1,\"Closest 50th\",IF(AC45=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B45/Y25","v":0},null,null,{"$f":"IF(OR(AND(Z45>15,Y44=1),AND(Z45>20,Y44=2)),1,0)","v":0},3]
[null,null,"Lane width (ft)",null,{"$f":"IF(AND(Y$16=3,ISNUMBER(B46)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB46=1,\"Closest 50th\",IF(AC46=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B46<=9,B26>2000),1,0)","v":0},{"$f":"IF(AND(B46<11,B46>9,B26>2000),1,0)","v":0},3]
[null,null,"Shoulder width (ft)",null,{"$f":"IF(AND(Y$16=3,ISNUMBER(B47)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AB47=1,\"Closest 50th\",IF(AC47=1,\"Rounded-Down 85th\",\"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,14,null,null,null,null,null,null,{"$f":"IF(AND(B26>2000,B47<2),1,0)","v":0},{"$f":"IF(AND(B26>2000,B47<6,B47>=2),1,0)","v":0},3]
[null,null,"Median type",null,{"$f":"IF(AND(Y$16=4,LEN(B48)=0),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Undivided","TWLTL","Divided",null,null,{"$f":"IF(LEN(B48)>0,MATCH(B48,T48:V48,0),0)","v":0},null,null,null,null,4]
[null,null,"Number of traffic signals",null,{"$f":"IF(AND(Y$16=4,ISNUMBER(B49)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AA49=1,\"Rounded-Down 50th (\" & T49 & \")\",T49),IF(ISNUMBER(B49),T49,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z49,2) & \" signal\" & IF(ROUND(Z49,2)=1, \"\", \"s\") & \" / mi\"","v":"0 signals / mi"},{"$f":"SUM(AA49:AC49)","v":0},null,null,null,null,{"$f":"B49/Y25","v":0},{"$f":"IF(Z49>8,1,0)","v":0},null,null,4]
[null,null,"Number of access points (total of both directions)",null,{"$f":"IF(AND(Y$16=4,ISNUMBER(B50)=FALSE),\"O\",\"\")","v":""},{"$f":"IF(Z17=0,IF(AA50=1,\"Rounded-Down 50th (\" & T50 & \")\",T50),IF(ISNUMBER(B50),T50,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z50,2) & \" access point\" & IF(ROUND(Z50,2) = 1, \"\", \"s\") & \" / mi\"","v":"0 access points / mi"},{"$f":"SUM(AA50:AC50)","v":0},null,null,null,null,{"$f":"B50/Y25","v":0},{"$f":"IF(Z50>60,1,0)","v":0},null,null,4]
[null,null,"Bicyclist activity / bike lane type",null,{"$f":"IF(AND(Y$16=4,LEN(B51)=0),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,AA51=1),\"Rounded-Down 50th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High / Not separated","High / Separated","Not high / Any type",null,null,{"$f":"IF(LEN(B51)>0,MATCH(B51,T51:V51,0),0)","v":0},null,{"$f":"IF(Y51<3,1,0)","v":1},null,null,4]
[null,null,"Sidewalk presence / width",null,{"$f":"IF(AND(Y$16=4,LEN(B52)=0),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","Narrow","Adequate","Wide",null,{"$f":"IF(LEN(B52)>0,MATCH(B52,T52:W52,0),0)","v":0},null,null,null,null,4]
[null,null,"Sidewalk buffer",null,{"$f":"IF(AND(Y$16=4,LEN(B53)=0,Y52>1),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,Y52=1),\"This variable is not shown when the sidewalk presence / width variable is set to ‘None’.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Present","Not present",null,null,null,{"$f":"IF(LEN(B53)>0,MATCH(B53,T53:U53,0),0)","v":0},null,null,null,null,4]
[null,null,"Pedestrian activity",null,{"$f":"IF(AND(Y$16=4,LEN(B54)=0),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,AA54=1),\"Rounded-Down 50th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Some","Negligible",null,null,{"$f":"IF(LEN(B54)>0,MATCH(B54,T54:V54,0),0)","v":0},null,{"$f":"IF(OR(AND(Y54=1,OR(Y52<3,AND(Y52=3,Y53=2))),AND(Y54=2,OR(AND(Y52=2,Y53=2),Y52=1))),1,0)","v":0},null,null,4]
[null,null,"On-street parking activity",null,{"$f":"IF(AND(Y$16=4,LEN(B55)=0),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,AA55=1),\"Rounded-Down 50th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Not high",null,null,null,{"$f":"IF(LEN(B55)>0,MATCH(B55,T55:U55,0),0)","v":0},null,{"$f":"IF(Y55=1,1,0)","v":0},null,null,4]
[null,null,"Angle parking present?",null,{"$f":"IF(AND(Y$16=4,LEN(B56)=0),\"O\",\"\")","v":""},{"$f":"IF(AND(Z17=0,AA56=1),\"Rounded-Down 50th\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, ≥ 40% of segment length","Yes, < 40% of segment length","No",null,null,{"$f":"IF(LEN(B56)>0,MATCH(B56,T56:V56,0),0)","v":0},null,{"$f":"IF(Y56=1,1,0)","v":0},null,null,4]
[null,null,"Adverse alignment present?",null,{"$f":"\"\"","v":""},{"$f":"IF(AND(Z17=0,Y57=1),\"Consider location-specific advisory speed warnings.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,{"$f":"IF(LEN(B57)>0,MATCH(B57,T57:U57,0),0)","v":0}]
[]
[null,"Crash Data",null,null,null,"Advisory, Calculated, or Warning Messages",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,"HSIS rates","Crash","Injury","Match"]
[null,null,"Number of years of crash data",null,{"$f":"IF(AND(Y7<>2,ISNUMBER(B60)=FALSE),\"O\",\"\")","v":"O"},{"$f":"IF(Z17=0,IF(B60<=1,\"Calculations based on 1 year of crash data or less and should be interpreted with caution.\", IF(B60<3,\"Consider collecting at least 3 years of crash data.\", \"\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B60,0.1)","v":0.1},{"$f":"COUNTIF(E60:E70,\"O\")","v":4},null,null,null,null,null,"Limited access",{"$f":"VLOOKUP(Y61,'Support Tables'!K6:M13,MATCH(AI60,'Support Tables'!K6:M6,0),TRUE)","v":92.83},{"$f":"VLOOKUP(Y61,'Support Tables'!N6:P13,MATCH(AI60,'Support Tables'!N6:P6,0),TRUE)","v":24.74},{"$f":"IF(LEFT(B5,1) = \"R\",\"Rural\",\"Urban\")","v":"Urban"}]
[null,null,"Average AADT for crash data period (veh/d)",null,{"$f":"IF(AND(Y7<>2,ISNUMBER(B61)=FALSE),\"O\",\"\")","v":"O"},{"$f":"IF(AND(Z17=0,OR(B65>D69,B66>D70)),\"Critical rates should be higher than average rates.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(B61,1)","v":1},{"$f":"365*Y60*Y61*Y25/10^8","v":3.6500000000000003E-8},null,null,null,null,null,"Developed",{"$f":"VLOOKUP(Y61,'Support Tables'!G31:K42,MATCH(AI61,'Support Tables'!G31:K31,0),TRUE)","v":226.43},{"$f":"VLOOKUP(Y61,'Support Tables'!L31:P42,MATCH(AI61,'Support Tables'!L31:P31,0),TRUE)","v":72.02},{"$f":"IF(Y62=1,\"OW\",IF(B27=2,2,IF(Y34=1,\"MU\",\"MD\")))","v":"MD"}]
[null,null,"Is the segment a one-way street?",null,{"$f":"IF(AND(Y7<>2,OR(Y16=2,Y16=4),LEN(B62)=0),\"O\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,{"$f":"IF(LEN(B62)>0,MATCH(B62,T62:U62,0),0)","v":0},null,null,null,null,null,null,"Undeveloped",{"$f":"VLOOKUP(Y61,'Support Tables'!I16:L28,MATCH(AI62,'Support Tables'!I16:L16,0),TRUE)","v":102.55},{"$f":"VLOOKUP(Y61,'Support Tables'!M16:P28,MATCH(AI62,'Support Tables'!M16:P16,0),TRUE)","v":28.93},{"$f":"IF(B27=2,2,IF(Y44=1,\"MU\",\"MD\"))","v":"MD"}]
[null,null,"All (KABCO) crashes for crash data period",null,{"$f":"IF(AND(Y7<>2,ISNUMBER(B63)=FALSE),\"O\",\"\")","v":"O"},{"$f":"IF(AND(Y7=1,Z60=0,ISNUMBER(B63)),\"Observed KABCO crash rate = \" & ROUND(Z63,2) & \" crashes / 100 MVMT\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B63/Z$61","v":0},null,null,null,null,null,"Full access",{"$f":"VLOOKUP(Y61,'Support Tables'!G31:K42,MATCH(AI61,'Support Tables'!G31:K31,0),TRUE)","v":226.43},{"$f":"VLOOKUP(Y61,'Support Tables'!L31:P42,MATCH(AI61,'Support Tables'!L31:P31,0),TRUE)","v":72.02},{"$f":"IF(Y62=1,\"OW\",IF(B27=2,2,IF(Y48=1,\"MU\",\"MD\")))","v":"MD"}]
[null,null,"Fatal & injury (KABC) crashes for crash data period",null,{"$f":"IF(AND(Y7<>2,ISNUMBER(B64)=FALSE),\"O\",\"\")","v":"O"},{"$f":"IF(AND(Y7=1,Z60=0),IF(AND(ISNUMBER(B64),B64<=B63),\"Observed KABC crash rate = \" & ROUND(Z64,2) & \" crashes / 100 MVMT\",\"The number of KABC crashes must be less than or equal to the number of KABCO crashes.\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B64/Z$61","v":0}]
[null,null,"Average KABCO crash rate (crashes / 100 MVMT)",null,{"$f":"\"\"","v":""},{"$f":"IF(AND(LEN(D16)>0,Y7=1,Z60=0),IF(ISBLANK(B65),\"HSIS average KABCO crash rate = \" & ROUND(Z65,2) & \" crashes / 100 MVMT\",\"Average KABCO crash rate for agency & region (provided by user)\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(D$16)=0,0,IF(LEN(B65)>0,B65,VLOOKUP(D$16,AF$60:AH$63,2,FALSE)))","v":0}]
[null,null,"Average KABC crash rate (crashes / 100 MVMT)",null,{"$f":"\"\"","v":""},{"$f":"IF(AND(LEN(D16)>0,Y7=1,Z60=0),IF(ISBLANK(B66),\"HSIS average KABC crash rate = \" & ROUND(Z66,2) & \" crashes / 100 MVMT\",\"Average KABC crash rate for agency & region (provided by user)\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(D$16)=0,0,IF(LEN(B66)>0,B66,VLOOKUP(D$16,AF$60:AH$63,3,FALSE)))","v":0}]
[null,null,"1.3 x average KABCO crash rate (crashes / 100 MVMT)",{"$f":"IF(AND(Y16>0,Z60=0),1.3*Z65,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(AND(Z$17=0,SUM(AA67:AC67)=1),T67,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y$16<4,\"Rounded-Down 85th\",\"Rounded-Down 50th\")","v":"Rounded-Down 85th"},null,null,null,null,null,null,{"$f":"IF(AND(Y7=1,Y16=4,Z63>1.3*Z65,Z63<D69),1,0)","v":0},null,{"$f":"IF(AND(Y7=1,Y16<4,Z63>1.3*Z65,Z63<D69),1,0)","v":0}]
[null,null,"1.3 x average KABC crash rate (crashes / 100 MVMT)",{"$f":"IF(AND(Y16>0,Z60=0),1.3*Z66,\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(AND(Z$17=0,SUM(AA68:AC68)=1),T68,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y$16<4,\"Rounded-Down 85th\",\"Rounded-Down 50th\")","v":"Rounded-Down 85th"},null,null,null,null,null,null,{"$f":"IF(AND(Y7=1,Y16=4,Z64>1.3*Z66,Z64<D70),1,0)","v":0},null,{"$f":"IF(AND(Y7=1,Y16=4,Z64>1.3*Z66,Z64<D70),1,0)","v":0}]
[null,null,"Critical KABCO crash rate (crashes / 100 MVMT)",{"$f":"IF(AND(Y16>0,Z60=0),Z65+1.645*SQRT((Z65/Z61))+(1/2/Z61),\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(AND(Z$17=0,SUM(AA69:AC69)=1),T69,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y$16<4,\"Closest 50th\",\"Rounded-Down 50th\")","v":"Closest 50th"},null,null,null,null,null,null,{"$f":"IF(AND(Y7=1,Y16=4,Z63>D69),1,0)","v":0},{"$f":"IF(AND(Y7=1,Y16<4,Z63>D69),1,0)","v":0}]
[null,null,"Critical KABC crash rate (crashes / 100 MVMT)",{"$f":"IF(AND(Y16>0,Z60=0),Z66+1.645*SQRT((Z66/Z61))+(1/2/Z61),\"\")","v":""},{"$f":"\"\"","v":""},{"$f":"IF(AND(Z$17=0,SUM(AA70:AC70)=1),T70,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y$16<4,\"Closest 50th\",\"Rounded-Down 50th\")","v":"Closest 50th"},null,null,null,null,null,null,{"$f":"IF(AND(Y7=1,Y16=4,Z64>D70),1,0)","v":0},{"$f":"IF(AND(Y7=1,Y16<4,Z64>D70),1,0)","v":0}]

{"sheet":"Support Tables","index":2,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NCHRP 17-76 Speed Limit Setting Tool"]
[]
[null,null,null,null,null,null,null,null,null,null,"HSIS Crash Rates (crashes / 100 million vehicle-miles traveled)"]
[null,"Important Notice",null,null,null,null,null,null,null,null,"HSIS KABCO crashes, limited access",null,null,"HSIS KABC crashes, limited access"]
[null,"The yellow cells in this worksheet should be altered with caution and justification, only under the following circumstances:",null,null,null,null,null,null,null,null,"AADTmax (veh/d)","Urban","Rural","AADTmax (veh/d)","Urban","Rural"]
[null,"  •  The default value in the cell needs to be changed to conform to agency policy (i.e., for all sites, not just the site of interest).",null,null,null,null,null,null,null,null,0,92.83,49.2,0,24.74,13.39]
[null,"  •  A statistical analysis has been conducted to produce a value that more accurately describes sites in the jurisdiction of interest.",null,null,null,null,null,null,null,null,25000,79.8,51.23,25000,21.24,12.92]
[null,"  •  An updated value for the quantity of interest is available in a published, authoritative document.",null,null,null,null,null,null,null,null,50000,76.959999999999994,44.16,50000,21.37,14.41]
[null,null,null,null,null,null,null,null,null,null,75000,88.34,44.16,75000,25.15,14.41]
[null,"Speed Limit Setting Groups",null,null,null,null,null,null,null,null,100000,91.16,44.16,100000,27.69,14.41]
[null,"Type/Context","Rural","Rural town","Suburban","Urban","Urban core",null,null,null,150000,91.6,44.16,150000,29.25,14.41]
[null,"Freeway","Limited access","Limited access","Limited access","Limited access","Limited access",null,null,null,200000,104.51,44.16,200000,30.75,14.41]
[null,"Principal arterial","Undeveloped","Developed","Developed","Developed","Full access",null,"HSIS Crash Rates (crashes / 100 million vehicle-miles traveled)"]
[null,"Minor arterial","Undeveloped","Developed","Developed","Developed","Full access",null,"HSIS KABCO crashes, undeveloped",null,null,null,"HSIS KABC crashes, undeveloped"]
[null,"Collector","Undeveloped","Full access","Developed","Full access","Full access",null,"AADTmax (veh/d)",2,"MD","MU","AADTmax (veh/d)",2,"MD","MU"]
[null,"Local","Undeveloped","Full access","Full access","Full access","Full access",null,0,206.56,102.55,153.35,0,65.209999999999994,28.93,50]
[null,null,null,null,null,null,null,null,1250,166,102.55,153.35,1250,54.01,28.93,50]
[null,"Upper and Lower Speed Limits by Group (mph)",null,null,null,null,null,null,2500,147.22999999999999,102.55,153.35,2500,47.73,28.93,50]
[null,"Group","Lower","Upper",null,null,null,null,3750,133.96,102.55,153.35,3750,43.89,28.93,50]
[null,"Limited access",50,85,null,null,null,null,5000,128.57,76.77,145.63,5000,43.29,22.14,42.08]
[null,"Developed",25,55,null,null,null,null,6250,121.91,76.77,145.63,6250,41.46,22.14,42.08]
[null,"Undeveloped",25,70,null,null,null,null,7500,125.7,76.77,145.63,7500,44.14,22.14,42.08]
[null,"Full access",15,30,{"$f":"IF(OR(MOD(C21,5)<>0,MOD(D21,5)<>0),\"Speed limits must be a multiple of 5 mph.\",\"\")","v":""},null,null,null,8750,123.35,76.77,145.63,8750,43.46,22.14,42.08]
[null,null,null,null,{"$f":"IF(OR(MOD(C22,5)<>0,MOD(D22,5)<>0),\"Speed limits must be a multiple of 5 mph.\",\"\")","v":""},null,null,null,10000,98.16,73.900000000000006,124.54,10000,35.6,20.77,41.14]
[null,"Minimum Segment Lengths by Speed Limit",null,null,{"$f":"IF(OR(MOD(C23,5)<>0,MOD(D23,5)<>0),\"Speed limits must be a multiple of 5 mph.\",\"\")","v":""},null,null,null,15000,98.16,70.83,124.54,15000,35.6,20.79,41.14]
[null,"Speed limit (mph)","Length (mi)",null,{"$f":"IF(OR(MOD(C24,5)<>0,MOD(D24,5)<>0),\"Speed limits must be a multiple of 5 mph.\",\"\")","v":""},null,null,null,20000,98.16,70.59,124.54,20000,35.6,23.11,41.14]
[null,15,0.3,null,null,null,null,null,25000,98.16,65.36,124.54,25000,35.6,21.28,41.14]
[null,20,0.3,null,null,null,"HSIS Crash Rates (crashes / 100 million vehicle-miles traveled)"]
[null,25,0.3,null,null,null,"HSIS KABCO crashes, developed or full access",null,null,null,null,"HSIS KABC crashes, developed or full access"]
[null,30,0.3,null,null,null,"AADTmin (veh/d)",2,"MD","MU","OW","AADTmax (veh/d)",2,"MD","MU","OW"]
[null,35,0.35,null,null,null,0,263.17,226.43,452.14,245.12,0,67.319999999999993,72.02,131.02000000000001,60.21]
[null,40,0.4,null,null,null,2500,209.14,226.43,452.14,245.12,2500,64.31,72.02,131.02000000000001,60.21]
[null,45,0.45,null,null,null,5000,205.37,226.43,452.14,139.27000000000001,5000,63.75,72.02,131.02000000000001,37.29]
[null,50,0.5,null,null,null,7500,229.55,226.43,452.14,139.27000000000001,7500,70.260000000000005,72.02,131.02000000000001,37.29]
[null,55,0.55000000000000004,null,null,null,10000,246.62,202.46,452.26,72.180000000000007,10000,73.14,66.16,131.97999999999999,22.79]
[null,60,1.2,null,null,null,15000,253.25,202.46,452.26,58.31,15000,78.14,66.16,131.97999999999999,18.190000000000001]
[null,65,3,null,null,null,20000,225.17,228.69,431.09,57.36,20000,71.819999999999993,75.37,129,17.72]
[null,70,6.2,null,null,null,25000,225.17,228.69,431.09,63.87,25000,71.819999999999993,75.37,129,20.07]
[null,75,6.2,null,null,null,30000,225.17,228.37,431.25,54.63,30000,71.819999999999993,74.010000000000005,131.1,15.03]
[null,80,6.2,null,null,null,40000,225.17,205.73,431.25,54.63,40000,71.819999999999993,70.84,131.1,15.03]
[null,85,6.2,null,null,null,50000,225.17,158.16999999999999,431.25,54.63,50000,71.819999999999993,56.32,131.1,15.03]

{"sheet":"Default Values","index":3,"n_rows":63,"n_cols":6,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,"NCHRP 17-76 Speed Limit Setting Tool"]
[]
[null,"Color-Coding Legend"]
[null,"Aqua = basic input cell",null,null,"Important Notice"]
[null,"Denim = basic input cell with drop-down menu (menus are in Analysis worksheets only)",null,null,"Default values were developed by the Research Team based on the following principles:"]
[null,null,null,null,"  •  Maximum speed limit: maximum value allowed for the SLSG."]
[null,"Default Values for Limited-access Segments (urban roadway context)",null,null,"  •  85th-percentile speed: maximum speed limit - 2 mph."]
[null,"Urban","Roadway context",null,"  •  50th-percentile speed: maximum speed limit - 5 mph."]
[null,85,"Maximum speed limit (mph)",null,"  •  Segment length: minimum value allowed for the maximum speed limit."]
[null,83,"85th-percentile speed (mph)",null,"  •  AADTs: reasonable mid-range values for the SLSG."]
[null,80,"50th-percentile speed (mph)",null,"  •  Site characteristics: limiting values that will allow the speed limit to be based on"]
[null,7,"Segment length (mi)",null,"      the closest 85th-percentile speed for limited-access, developed, or undeveloped"]
[null,60000,"AADT (two-way total) (veh/d)",null,"      segments, or the closest 50th-percentile speed for full-access segments."]
[null,6,"Number of lanes (two-way total)",null,"  •  Crash counts: computed as the HSIS rates divided by three for limited-access,"]
[null,200,"Directional design-hour truck volume (trk/hr)",null,"      developed or undeveloped segments, or divided by eight for full-access segments."]
[null,7,"Number of interchanges"]
[null,"≥ 60 mph","Design speed (mph)",null,"The values are informational and are provided as advice for the rare cases where the user"]
[null,0,"Grade (%)",null,"is not able to obtain a value for the segment of interest."]
[null,10,"Outside shoulder width (ft)"]
[null,10,"Inside shoulder width (ft)",null,"Default Values for Developed Segments"]
[null,"No","Adverse alignment present?",null,55,"Maximum speed limit (mph)"]
[null,3,"Number of years of crash data",null,53,"85th-percentile speed (mph)"]
[null,60000,"Average AADT for crash data period (veh/d)",null,50,"50th-percentile speed (mph)"]
[null,27,"All (KABCO) crashes for crash data period",null,1,"Segment length (mi)"]
[null,7,"Fatal & injury (KABC) crashes for crash data period",null,4,"Number of lanes (two-way total)"]
[null,null,null,null,"Divided","Median type"]
[null,"Default Values for Limited-access Segments (rural roadway context)",null,null,3,"Number of traffic signals"]
[null,"Rural","Roadway context",null,40,"Number of access points (total of both directions)"]
[null,85,"Maximum speed limit (mph)",null,"Not high / Any type","Bicyclist activity / bike lane type"]
[null,83,"85th-percentile speed (mph)",null,"Adequate","Sidewalk presence / width"]
[null,80,"50th-percentile speed (mph)",null,"Present","Sidewalk buffer"]
[null,7,"Segment length (mi)",null,"Negligible","Pedestrian activity"]
[null,25000,"AADT (two-way total) (veh/d)",null,"Not high","On-street parking activity"]
[null,6,"Number of lanes (two-way total)",null,"No","Parallel parking permitted?"]
[null,200,"Directional design-hour truck volume (trk/hr)",null,"No","Angle parking present?"]
[null,7,"Number of interchanges",null,"No","Adverse alignment present?"]
[null,80,"Design speed (mph)",null,3,"Number of years of crash data"]
[null,0,"Grade (%)",null,30000,"Average AADT for crash data period (veh/d)"]
[null,10,"Outside shoulder width (ft)",null,"No","Is the segment a one-way street?"]
[null,10,"Inside shoulder width (ft)",null,53,"All (KABCO) crashes for crash data period"]
[null,"No","Adverse alignment present?",null,19,"Fatal & injury (KABC) crashes for crash data period"]
[null,3,"Number of years of crash data"]
[null,25000,"Average AADT for crash data period (veh/d)",null,"Default Values for Full-access Segments"]
[null,16,"All (KABCO) crashes for crash data period",null,30,"Maximum speed limit (mph)"]
[null,4,"Fatal & injury (KABC) crashes for crash data period",null,25,"50th-percentile speed (mph)"]
[null,null,null,null,1,"Segment length (mi)"]
[null,"Default Values for Undeveloped Segments",null,null,4,"Number of lanes (two-way total)"]
[null,70,"Maximum speed limit (mph)",null,"Divided","Median type"]
[null,68,"85th-percentile speed (mph)",null,8,"Number of traffic signals"]
[null,65,"50th-percentile speed (mph)",null,60,"Number of access points (total of both directions)"]
[null,7,"Segment length (mi)",null,"Not high / Any type","Bicyclist activity / bike lane type"]
[null,15000,"AADT (two-way total) (veh/d)",null,"Adequate","Sidewalk presence / width"]
[null,4,"Number of lanes (two-way total)",null,"Present","Sidewalk buffer"]
[null,"Divided","Median type",null,"Negligible","Pedestrian activity"]
[null,15,"Number of access points (total of both directions)",null,"Not high","On-street parking activity"]
[null,12,"Lane width (ft)",null,"No","Angle parking present?"]
[null,10,"Shoulder width (ft)",null,"No","Adverse alignment present?"]
[null,"No","Adverse alignment present?",null,3,"Number of years of crash data"]
[null,3,"Number of years of crash data",null,10000,"Average AADT for crash data period (veh/d)"]
[null,15000,"Average AADT for crash data period (veh/d)",null,"No","Is the segment a one-way street?"]
[null,22,"All (KABCO) crashes for crash data period",null,25,"All (KABCO) crashes for crash data period"]
[null,7,"Fatal & injury (KABC) crashes for crash data period",null,8,"Fatal & injury (KABC) crashes for crash data period"]