{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Limitations","Entrance","Exit","Factors and Tables"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":1,"defined_names":2,"comments":3,"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":"Welcome","index":0,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,1,3,12],[5,1,5,12],[6,1,6,12]]}
[]
[null,"NCHRP 15-56 Ramp Speed Profile Model"]
[]
[]
[]
[null,"Developed by:  Michael P. Pratt, Marcus A. Brewer, and Darren J. Torbic"]
[null,"  Version 1"]
[null,"FOREWORD"]
[null,"The RSPM software can be used to estimate vehicle speeds on freeway service interchange ramps and compare these speeds with "]
[null,"design speeds for ramp elements.  It is intended for use by engineers and technicians responsible for ramp design and traffic operations."]
[]
[null,"The RSPM software is intended for use with the report identified below.  The analyst is encouraged to read Sections 4 and 5 of the"]
[null,"guidelines so that he or she will have an understanding of how best to use the software and interpret its output."]
[]
[null,null,"Torbic, Darren J., Marcus A. Brewer, and Michael P. Pratt.  Guidelines for Selecting Ramp Design Speeds."]
[null,null,"NCHRP Project 15-56."]
[null,null,"MRIGlobal, Kansas City, Missouri; Texas A&M Transportation Institute, College Station, Texas; 2021."]
[]
[null,"The equations used in the RSPM software are documented in this report.  Analysts should refer to the report whenever they have "]
[null,"questions about the modeling approach, assumptions, or limitations."]
[]
[null,"INSTRUCTIONS"]
[]
[null,"The RSPM software consists of two analysis worksheets -- \"Entrance\" for entrance ramps, and \"Exit\" for exit ramps.  Key cells on these"]
[null,"worksheets have been color-coded to indicate the type of data entered or displayed.  The following list indentifies the meaning of each"]
[null,"cell color."]
[]
[null,"Blue cells represent \"input data.\"  Each time the worksheet is used, the values in these cells should be changed to represent the"]
[null,null,"ramp being evaluated.  Input data must be provided by the analyst."]
[null,"Orange cells represent \"optional input data.\"  Each time the worksheet is used, the values in these cells should be changed to"]
[null,null,"represent the ramp being evaluated.  Input data should be provided by the analyst if available."]
[null,"Yellow cells represent \"calibration factors.\"  The values in these cells represent reasonable values for most situations and do not "]
[null,null,"need to be changed.  Calibration factors can be changed to more accurately reflect local conditions; however, field data "]
[null,null,"from sites local to the agency should be the basis for this change."]
[null,"Purple cells represent \"key output variables.\"  The values are computed using the input data, calibration factors, and default values."]
[null,"White cells contain labels and other descriptive information."]
[]
[null,"Note:  white and purple cells are not intended to be changed by the analyst.  Only blue, orange, and yellow cells should be changed"]
[null,"as described in these instructions."]
[]
[null,"Whenever new information is entered into an analysis worksheet, the analyst will need to click the                                 button at"]
[null,"the top of the worksheet to produce updated analysis results."]
[]
[null,"The analyst may also click the                                 button to generate a new speed profile while keeping the previously-calculated"]
[null,"speed profile visible."]
[]
[null,"DISCLAIMER"]
[null,"No warranty is made by the developers or their employer as to the accuracy, completeness, or reliability of this software and its"]
[null,"associated equations and documentation.  No responsibility is assumed by the developers for incorrect results or damages resulting"]
[null,"from the use of this software."]
[]
[null,"COPYRIGHT © 2021"]
[null,"This software is copyrighted.  All rights are reserved.  This product may not, in whole or in part, be copied, photocopied, reproduced, "]
[null,"translated, or reduced to any electronic medium or machine-readable form without prior consent, in writing, from Darren J. Torbic."]
[null,"This product is subject to change without notice and does not represent a commitment on the part of Darren J. Torbic to notify"]
[null,"any person of such revision."]

{"sheet":"Limitations","index":1,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,1,3,12]]}
[]
[null,"NCHRP 15-56 Ramp Speed Profile Model"]
[]
[]
[]
[null,"LIMITATIONS"]
[]
[null,"Intended Use"]
[null,"The RSPM is intended to be used to assess the adequacy of a ramp design or design alternatives during the design or reconstruction"]
[null,"process.  With the capability to adjust several input parameters, the RSPM can be used to predict vehicle speeds based upon anticipated"]
[null,"driver behaviors or design conditions.  The output from the RSPM should not be viewed as absolute truth but should be interpreted by the"]
[null,"analyst to help design an interchange ramp in a consistent manner that meets driver expectations."]
[]
[null,"Applicable Analysis Sites"]
[null,"The RSPM is designed to address the most common types of entrance and exit ramps at service interchanges including diagonal, loop,"]
[null,"and outer connection ramps.  The RSPM does not address other types of ramps or ramps with more complex geometrics."]
[]
[null,"The RSPM does not address the design of ramps for system interchanges."]
[]
[null,"Speed Prediction Models"]
[null,"The RSPM incorporates several regression models for tangents and curves that predict vehicle speeds at specific locations along the"]
[null,"ramp, including:"]
[null,null,"Entrance ramp:"]
[null,null,null,"At the midpoint of the curve (MC)."]
[null,null,null,"At the end of the curve (PT)."]
[null,null,null,"At the end of a tangent with a subsequent curve."]
[null,null,null,"At the end of a tangent without a subsequent curve."]
[null,null,"Exit ramp:"]
[null,null,null,"At the midpoint of the curve (MC)."]
[null,null,null,"At the end of the curve (PT)."]
[null,null,null,"At the end of a tangent with a subsequent curve."]
[null,null,null,"At the end of a tangent without a subsequent curve."]
[]
[null,"Most of the models were developed based on observations of 500 or more vehicles across multiple sites.  However, the model that predicts"]
[null,"vehicle speeds at the end of a tangent without a subsequent curve for exit ramps is based on data for 77 vehicles at one location."]
[null,"Therefore, when modeling an exit ramp that includes a tangent without a subsequent curve, the analyst should be aware that predicted"]
[null,"speeds for this design condition may be less reliable than for other design conditions."]
[]
[null,"The 85th percentile of the distribution of observed operating speeds is a frequently-used measure associated with the design of geometric"]
[null,"features.  The speed prediction models incorporated in the RSPM yield estimates of average operating speeds, not the 85th percentile of"]
[null,"operating speeds."]
[]
[null,"Input Variable Ranges"]
[null,"The speed prediction models are limited with respect to the range of site characteristics where actual speed data were collected.  In most"]
[null,"cases, the RSPM allows analysts to enter site characteristics outside of the limits from which the models were calibrated (e.g., curve"]
[null,"length).  The RSPM simply provides a message, showing the range of values for which the models were calibrated and prompts the "]
[null,"analyst to continue or modify the input value, before estimating speeds for conditions outside of the range of site characteristics from "]
[null,"which the models were calibrated (i.e., extrapolation of speed estimates)."]

{"sheet":"Entrance","index":2,"n_rows":66,"n_cols":20,"rows_kept":66,"cut":false,"hidden":false,"merged":[[10,1,10,5]]}
[]
[null,"NCHRP 15-56 Ramp Speed Calculations - Entrance Ramp",null,null,null,null,null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,"Alternate Profile"]
[null,null,null,null,null,null,null,null,null,null,null,"The merge speed is more than 5 mph below the freeway operating speed."]
[null,"Location:","Sample Entrance Ramp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On"]
[null,"Component","Variable","Input Value","Unit",null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,"On"]
[null,"Speeds","VDS Hwy",55,"mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Off"]
[null,null,"VOS Hwy",60,"mph"]
[null,null,"VSL Hwy",55,"mph"]
[null,null,"VXRoad",15,"mph"]
[null,"General Characteristics","Ramp grade",3,"%"]
[null,"Variables for Curves and Tangents on Ramp Proper"]
[null,"VDS Tan (mph)","VDS Curve (mph)","XPC (mi)","R (ft)","Lc (mi)"]
[null,20,25,0.02,500,0.05,"Curve 1"]
[null,28,30,0.12,500,0.05,"Curve 2"]
[null,35,40,0.26,750,0.06,"Curve 3"]
[]
[]
[]
[]
[]
[null,"Freeway Mainline","XG",0.4,"mi"]
[null,"Ramp Terminal","LGap Acpt",7.0000000000000007E-2,"mi"]
[null,null,"LTaper",0.05,"mi"]
[null,null,"LAcc Length RP",0,"mi"]
[null,null,"PGap Acpt",{"$f":"'Factors and Tables'!E24","v":0.5}]
[]
[null,"Plotted Speed Data",null,null,null,null,null,null,"Previous Data",null,null,"Segment Data",null,null,"Speed, mph",null,"Average Acceleration",null,"Design Acceleration"]
[null,"Point Type","Milepost","Profile, mph","Milepost","Design, mph","Milepost","Alt profile, mph","Milepost","Profile, mph",null,"Number","Type","Length, mi","Initial","Final","mph/s","ft/s2","ft/s2","Notes"]
[null,"Xrd",0,15,0,20,0,15.000000000000002,null,null,null,1,"Tangent",1.9999999552965164E-2,15,15,0,0,7.5,"OK"]
[null,"Tan",1.9999999552965164E-2,15,1.9999999552965164E-2,20,1.9999999552965164E-2,27.118447910655629,null,null,null,2,"Curve",2.5000002235174179E-2,15,15.666788101196289,0.11360137909650803,0.16661535203456879,7.5,"OK"]
[null,"Cmc",4.5000001788139343E-2,15.666788101196289,1.9999999552965164E-2,25,7.0000000298023224E-2,39.443037726662375,null,null,null,3,"Curve",2.4999998509883881E-2,15.666788101196289,19.265947341918945,0.69849157333374023,1.0244543552398682,7.1807951927185059,"OK"]
[null,"Cpt",7.0000000298023224E-2,19.265947341918945,7.0000000298023224E-2,25,0.11999999731779099,46.842706853693187,null,null,null,4,"Tangent",4.9999997019767761E-2,19.265947341918945,26.464267730712891,0.91439098119735718,1.3411067724227905,5.8393182754516602,"OK"]
[null,"Tan",0.11999999731779099,26.464267730712891,7.0000000298023224E-2,28,0.17000000178813934,40.38883729414507,null,null,null,5,"Curve",2.4999998509883881E-2,26.464267730712891,25.735052108764648,-0.21146978437900543,-0.31015568971633911,4.2510151863098145,"OK"]
[null,"Cmc",0.14499999582767487,25.735052108764648,0.11999999731779099,28,0.25999999046325684,51.979460282759234,null,null,null,6,"Curve",2.5000005960464478E-2,25.735052108764648,25.793180465698242,1.6640281304717064E-2,2.4405745789408684E-2,4.3714694976806641,"OK"]
[null,"Cpt",0.17000000178813934,25.793180465698242,0.11999999731779099,30,0.31999999284744263,45.613007978959523,null,null,null,7,"Tangent",8.9999988675117493E-2,25.793180465698242,32.57904052734375,0.6112743616104126,0.89653575420379639,4.3616180419921875,"OK"]
[null,"Tan",0.25999999046325684,32.57904052734375,0.17000000178813934,30,0.51999998092651367,60.000000000000007,null,null,null,8,"Curve",3.0000001192092896E-2,32.57904052734375,32.126422882080078,-0.1355871856212616,-0.19886121153831482,3.4531402587890625,"OK"]
[null,"Cmc",0.28999999165534973,32.126422882080078,0.17000000178813934,35,null,null,null,null,null,9,"Curve",3.0000001192092896E-2,32.126422882080078,32.341808319091797,6.4284801483154297E-2,9.4284377992153168E-2,3.5017905235290527,"OK"]
[null,"Cpt",0.31999999284744263,32.341808319091797,0.25999999046325684,35,null,null,null,null,null,10,"Tangent",8.0000013113021851E-2,32.341808319091797,38.988140106201172,0.82305973768234253,1.2071542739868164,3.4784696102142334,"OK"]
[null,"Tan",0.40000000596046448,38.988140106201172,0.25999999046325684,40,null,null,null,null,null,11,"Speed-change",3.4999996423721313E-2,38.988140106201172,44.408096313476563,1.7936666011810303,2.6307110786437988,2.8854928016662598,"OK"]
[null,"SCm",0.43500000238418579,44.408096313476563,0.31999999284744263,40,null,null,null,null,null,12,"Speed-change",3.4999996423721313E-2,44.408096313476563,44.408096313476563,0,0,2.5333218574523926,"OK"]
[null,"SCe",0.4699999988079071,44.408096313476563,0.31999999284744263,55,null,null,null,null,null,13,"Taper",4.9999982118606567E-2,44.408096313476563,44.408096313476563,0,0,2.5333218574523926,"OK"]
[null,"Tpr",0.51999998092651367,44.408096313476563,0.51999998092651367,55]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0.40000000596046448,38.988140106201172,"XG",null,null,null,null,0.27361088991165161,40]
[null,0.27361088991165161,32.373687744140625,"XA",null,null,null,null,0.40000000596046448,38.988140106201172]

{"sheet":"Exit","index":3,"n_rows":71,"n_cols":20,"rows_kept":71,"cut":false,"hidden":false,"merged":[[15,1,15,5]]}
[]
[null,"NCHRP 15-56 Ramp Speed Calculations - Exit Ramp",null,null,null,null,null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,"Alternate Profile"]
[]
[null,"Location:","Sample Exit Ramp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On"]
[null,"Component","Variable","Input Value","Unit",null,"Notes",null,null,null,null,null,null,null,null,null,null,null,null,"On"]
[null,"Speeds","VDS Hwy",55,"mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Off"]
[null,null,"VOS Hwy",65,"mph"]
[null,null,"VSL Hwy",60,"mph"]
[null,null,"VXRoad",15,"mph"]
[null,"General Characteristics","Ramp grade",3,"%"]
[null,null,"Ramp type","Diagonal"]
[null,"Freeway Mainline","LTaper",0.05,"mi"]
[null,"Ramp Terminal","LDiv Zone",0.05,"mi"]
[null,null,"LDec Length RP",0,"mi"]
[null,null,"SCL type","Taper"]
[null,"Variables for Curves and Tangents on Ramp Proper"]
[null,"VDS Tan (mph)","VDS Curve (mph)","XPC (mi)","R (ft)","Lc (mi)"]
[null,45,45,0.05,1000,0.05,"Curve 1"]
[null,30,35,0.18,600,0.05,"Curve 2"]
[null,15,20,0.26,600,0.06,"Curve 3"]
[]
[]
[]
[]
[]
[null,"Crossroad","XXRoad",0.4,"mi"]
[null,null,"LQ Storage",0.05,"mi"]
[null,null,"PSCL",{"$f":"'Factors and Tables'!E45","v":0.1}]
[]
[null,"Plotted Speed Data",null,null,null,null,null,null,"Previous Data",null,null,"Segment Data",null,null,"Speed, mph",null,"Average Acceleration",null,"Design Acceleration"]
[null,"Point Type","Milepost","Profile, mph","Milepost","Design, mph","Milepost","Alt profile, mph","Milepost","Profile, mph",null,"Number","Type","Length, mi","Initial","Final","mph/s","ft/s2","ft/s2","Notes"]
[null,"Tpr",-0.10000000149011612,65,-0.15000000596046448,55,0,49.207233082164421,null,null,null,1,"Speed-change",9.9999979138374329E-3,65,60.900001525878906,-7.169304370880127,-10.514979362487793,-11.535333633422852,"OK"]
[null,"SCd",-9.0000003576278687E-2,60.900001525878906,5.000000074505806E-2,55,5.000000074505806E-2,43.087231896140359,null,null,null,2,"Speed-change",9.0000003576278687E-2,60.900001525878906,49.207233428955078,-1.9868184328079224,-2.9140002727508545,-10.807720184326172,"OK"]
[null,"Gor",0,49.207233428955078,5.000000074505806E-2,45,0.10000000149011612,36.967230710116304,null,null,null,3,"Tangent",5.000000074505806E-2,49.207233428955078,46.495372772216797,-0.72092258930206299,-1.057353138923645,-8.7326440811157227,"OK"]
[null,"Tan",5.000000074505806E-2,46.495372772216797,0.10000000149011612,45,0.18000000715255737,27.175231413407761,null,null,null,4,"Curve",2.5000002235174179E-2,46.495372772216797,46.495372772216797,0,0,-8.2513790130615234,"OK"]
[null,"Cmc",7.5000002980232239E-2,46.495372772216797,0.10000000149011612,45,0.23000000417232513,21.055231527848679,null,null,null,5,"Curve",2.4999998509883881E-2,46.495372772216797,40.917758941650391,-2.7086484432220459,-3.972684383392334,-8.2513790130615234,"OK"]
[null,"Cpt",0.10000000149011612,40.917758941650391,0.18000000715255737,45,0.25999999046325684,17.383232116699219,null,null,null,6,"Tangent",8.0000005662441254E-2,40.917758941650391,40.917758941650391,0,0,-7.2615385055541992,"OK"]
[null,"Tan",0.18000000715255737,40.917758941650391,0.18000000715255737,35,0.31999999284744263,15.000000000000002,null,null,null,7,"Curve",2.4999991059303284E-2,40.917758941650391,40.917758941650391,0,0,-7.2615385055541992,"OK"]
[null,"Cmc",0.20499999821186066,40.917758941650391,0.23000000417232513,35,0.40000000596046448,15.000000000000002,null,null,null,8,"Curve",2.5000005960464478E-2,40.917758941650391,34.0174560546875,-2.8726420402526855,-4.2132081985473633,-7.2615385055541992,"OK"]
[null,"Cpt",0.23000000417232513,34.0174560546875,0.23000000417232513,30,null,null,null,null,null,9,"Tangent",2.9999986290931702E-2,34.0174560546875,32.394538879394531,-0.4989871084690094,-0.73184776306152344,-6.0369644165039063,"OK"]
[null,"Tan",0.25999999046325684,32.394538879394531,0.25999999046325684,30,null,null,null,null,null,10,"Curve",3.0000001192092896E-2,32.394538879394531,32.394538879394531,0,0,-5.7489509582519531,"OK"]
[null,"Cmc",0.28999999165534973,32.394538879394531,0.25999999046325684,20,null,null,null,null,null,11,"Curve",3.0000001192092896E-2,32.394538879394531,24.747011184692383,-2.0231091976165771,-2.9672267436981201,-5.7489509582519531,"OK"]
[null,"Cpt",0.31999999284744263,24.747011184692383,0.31999999284744263,20,null,null,null,null,null,12,"Tangent",3.0000001192092896E-2,24.747011184692383,0,-2.8352525234222412,-4.1583704948425293,-4.3917694091796875,"OK"]
[null,"Qst",0.34999999403953552,0,0.31999999284744263,15,null,null,null,null,null,13,"Queue",5.0000011920928955E-2,0,0,0,0,0,"OK"]
[null,"Xrd",0.40000000596046448,0,0.40000000596046448,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0,49.207233428955078,"XG",null,null,null,null,-9.0000003576278687E-2,55]
[null,-9.0000003576278687E-2,60.900001525878906,"XA",null,null,null,null,-9.0000003576278687E-2,60.900001525878906]

{"sheet":"Factors and Tables","index":4,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worksheet","Model","Coefficient","Value","Notes",null,"Green Book Table 10-4"]
[null,"Entrance","VMC","Intercept",-8.7255000000000003,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,"VPC",1.0125,null,null,30,180,140]
[null,null,null,"R",4.7053000000000003,null,null,35,280,220,160]
[null,null,null,"R2",-2.0183,null,null,40,360,300,270,210,120]
[null,null,null,"VSL Frwy",0.13159999999999999,null,null,45,560,490,440,380,280,160]
[null,null,null,"Lc",0,null,null,50,720,660,610,550,450,350,130]
[null,null,null,"Lr",0,null,null,55,960,900,810,780,670,550,320,150]
[null,null,"VPT","Intercept",-12.117900000000001,null,null,60,1200,1140,1100,1020,910,800,550,420,180]
[null,null,null,"VPC",1.0126999999999999,null,null,65,1410,1350,1310,1220,1120,1000,770,600,370]
[null,null,null,"R",8.3558000000000003,null,null,70,1620,1560,1520,1420,1350,1230,1000,820,580]
[null,null,null,"R2",-3.5183,null,null,75,1790,1730,1630,1580,1510,1420,1160,1040,780]
[null,null,null,"VSL Frwy",0.18820000000000001,null,null,80,2000,1900,1800,1750,1680,1600,1340,1240,980]
[null,null,null,"Lc",0]
[null,null,null,"Lr",0,null,null,"Green Book Table 10-5 for entrance with 3-4% upgrade",null,null,null,null,"downgrade",null,"exit"]
[null,null,"Vt,e,c","Vt,b",0.9667,null,null,"Des/Init",20,30,40,50,"Des/Init","Down","Grade","Adj. factor"]
[null,null,null,"Lt",143.96639999999999,null,null,40,1.3,1.3,null,null,40,0.7,"3-4% up",0.9]
[null,null,null,"I55",-5.3121999999999998,null,null,45,1.3,1.35,null,null,45,0.67500000000000004,"3-4% down",1.2]
[null,null,null,"I60",-2.6027999999999998,null,null,50,1.3,1.4,1.4,null,50,0.65]
[null,null,null,"I65",{"$f":"7.915*1","v":7.915},null,null,55,1.35,1.45,1.45,null,55,0.625]
[null,null,"Vt,e,nc","Vt,b",1.0118,null,null,60,1.4,1.5,1.5,1.6,60,0.6]
[null,null,null,"Lt",78.308700000000002,null,null,65,1.45,1.55,1.6,1.7,65,0.6]
[null,null,"Factor","PGap Acpt",0.5,null,null,70,1.5,1.6,1.7,1.8,70,0.6]
[null,"Exit","VMC","Intercept",-13.4726,null,null,75,1.6,1.7,1.8,2,75,0.6]
[null,null,null,"VPC",0.59509999999999996,null,null,80,1.7,1.8,2,2.1,80,0.6]
[null,null,null,"R",208.5633]
[null,null,null,"R2",-521.30730000000005,null,null,"Green Book Table 10-5 for entrance with 5-6% upgrade",null,null,null,null,"downgrade",null,"exit"]
[null,null,null,"VSL Frwy",0.2361,null,null,"Des/Init",20,30,40,50,"Des/Init","Down","Grade","Adj. factor"]
[null,null,null,"IDN",2.1981000000000002,null,null,40,1.5,1.5,null,null,40,0.6,"5-6% up",0.8]
[null,null,null,"ILV",0.75070000000000003,null,null,45,1.5,1.6,null,null,45,0.57499999999999996,"5-6% down",1.35]
[null,null,null,"IUP",-2.9487999999999999,null,null,50,1.5,1.7,1.9,null,50,0.55000000000000004]
[null,null,"VPT","Intercept",-0.62719999999999998,null,null,55,1.6,1.8,2.0499999999999998,null,55,0.52500000000000002]
[null,null,null,"VPC",0.86370000000000002,null,null,60,1.7,1.9,2.2000000000000002,2.5,60,0.5]
[null,null,null,"R",108.0929,null,null,65,1.85,2.0499999999999998,2.4,2.75,65,0.5]
[null,null,null,"R2",-265.97469999999998,null,null,70,2,2.2000000000000002,2.6,3,70,0.5]
[null,null,null,"Lc",-190.89410000000001,null,null,75,2.15,2.35,2.8,3.25,75,0.5]
[null,null,null,"Lr",0,null,null,80,2.2999999999999998,2.5,3,3.5,80,0.5]
[null,null,"Vt,e,c","Vt,b",0.79800000000000004]
[null,null,null,"Rnext",228.61959999999999,null,null,"Green Book Table 10-6"]
[null,null,null,"Rnext2",-575.21450000000004,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,"Lt",-645.43970000000002,null,null,30,235,200,170,140]
[null,null,null,"Lt2",6733.5203000000001,null,null,35,280,250,210,185,150]
[null,null,"Vt,e,nc","Vt,b",0.48899999999999999,null,null,40,320,295,265,235,185,155]
[null,null,"Factor","PSCL",0.1,null,null,45,385,350,325,295,250,220]
[null,null,"Factor","aSCL",-2.9140000000000001,null,null,50,435,405,385,355,315,285,225,175]
[null,null,"Mean speed differentials for speed-change lane (ΔV)",null,null,null,null,55,480,455,440,410,380,350,285,235]
[null,null,"Ramp type","Merge type","Combined","Value",null,60,530,500,480,460,430,405,350,300,240]
[null,null,"Loop","Parallel",{"$f":"C49&\", \"&D49","v":"Loop, Parallel"},-4.4000000000000004,null,65,570,540,520,500,470,440,390,340,280]
[null,null,"Loop","Taper",{"$f":"C50&\", \"&D50","v":"Loop, Taper"},-5.7,null,70,615,590,570,550,520,490,440,390,340]
[null,null,"Straight","Parallel","Straight, Parallel",-1.6,null,75,660,635,620,600,575,535,490,440,390]
[null,null,"Straight","Taper","Straight, Taper",-4.0999999999999996,null,80,705,680,665,645,620,580,535,490,440]
[]
[null,null,null,null,null,null,null,"NCHRP Report 730 Table 27, acceleration rate (ft/s2) for 0-2% grade"]
[null,null,null,null,null,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,35,null,null,null,null,3.39]
[null,null,null,null,null,null,null,40,null,null,null,null,3.28,2.88]
[null,null,null,null,null,null,null,45,null,null,null,null,3.22,2.97]
[null,null,null,null,null,null,null,50,null,null,null,null,3.24,2.9,2.69]
[null,null,null,null,null,null,null,55,null,null,null,null,3.4,2.72,2.68,2.4700000000000002]
[null,null,null,null,null,null,null,60,null,null,null,null,null,2.68,2.66,2.36,1.97]
[null,null,null,null,null,null,null,65,null,null,null,null,null,3.18,2.57,2.36,1.96]
[null,null,null,null,null,null,null,70,null,null,null,null,null,null,2.62,2.4900000000000002,2.0499999999999998]
[null,null,null,null,null,null,null,75,null,null,null,null,null,null,2.76,2.6,2.12]
[]
[]
[null,null,null,null,null,null,null,"NCHRP Report 730 Table 27, acceleration rate (ft/s2) for 0-2% grade"]
[null,null,null,null,null,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,null,null,null,null,"Average",{"$f":"$H70","v":"Average"},{"$f":"$H70","v":"Average"},{"$f":"$H70","v":"Average"},{"$f":"$H70","v":"Average"},{"$f":"AVERAGE(M56:M65)","v":3.306},{"$f":"AVERAGE(N56:N65)","v":2.8883333333333336},{"$f":"AVERAGE(O56:O65)","v":2.6633333333333336},{"$f":"AVERAGE(P56:P65)","v":2.456},{"$f":"AVERAGE(Q56:Q65)","v":2.0249999999999999}]
[]
[null,null,null,null,null,null,null,"NCHRP Report 730 Table 27, acceleration rate (ft/s2) for 3-4% grade"]
[null,null,null,null,null,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,null,null,null,null,30,{"$f":"J74","v":2.46},2.46,2.83,2.94]
[null,null,null,null,null,null,null,35,{"$f":"J75","v":2.5299999999999998},2.5299999999999998,3.07,3.12,3.16]
[null,null,null,null,null,null,null,40,2.48,2.48,3.07,3.18,3.16,3.17]
[null,null,null,null,null,null,null,45,2.31,2.31,3.01,3.11,3.12,3.06]
[null,null,null,null,null,null,null,50,2.41,2.41,2.97,3.08,3.04,3,2.78]
[null,null,null,null,null,null,null,55,2.94,{"$f":"K79","v":2.94},2.94,3.09,3.01,2.96,2.81,2.57]
[null,null,null,null,null,null,null,60,3,3,3,3.1,3.02,2.99,2.89,2.83,2.48]
[null,null,null,null,null,null,null,65,3.11,3.11,3.11,3.18,3.15,3.11,2.91,2.83,2.67]
[null,null,null,null,null,null,null,70,3.1,3.1,3.1,3.27,3.28,3.21,3.07,2.91,2.8]
[null,null,null,null,null,null,null,75,3.29,3.29,3.29,3.37,3.38,3.36,3.37,3.21,3]
[null,null,null,null,null,null,null,80,3.29,3.29,3.29,3.37,3.38,3.36,3.37,3.21,3]
[]
[null,null,null,null,null,null,null,"NCHRP Report 730 Table 27, acceleration rate (ft/s2) for 3-4% grade"]
[null,null,null,null,null,null,null,"Des / Init",0,14,18,22,26,30,36,40,44]
[null,null,null,null,null,null,null,"Average",{"$f":"J88","v":2.7630000000000003},{"$f":"AVERAGE(J74:J83)","v":2.7630000000000003},3.0390000000000001,3.1440000000000001,3.1466666666666665,3.1075000000000004,2.9716666666666671,2.87,2.7374999999999998]