{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Welcome","Introduction","Main","Input Ramp Terminals","Output Summary","Output Ramp Terminals","Calibration Factors","Temp"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,2,2,11],[11,1,13,12],[7,1,9,12],[32,1,34,12],[17,1,19,12],[22,1,23,12],[25,1,30,12]]}
[]
[]
[null,null,"HSM Methodology for Ramp Terminals for Chapter 19"]
[]
[]
[null,null,null,null,null,null,"Based on Build 06.10 from ISATe"]
[null,"FOREWORD"]
[null,"This software can be used to evaluate the relationship between various highway design configurations and the expected average crash frequency.  The profession's understanding of the influence of geometric design and traffic control features on safety is an evolving process.  As additional information becomes available, this software will be updated to include the latest findings."]
[]
[]
[]
[null,"The \"Introduction\" worksheet provides useful information about this software.  This information should be read prior to first use of the software.  The Introduction worksheet can be selected from the tabs at the bottom of the screen.   After reading the Introduction, the other worksheets can be used to evaluate a freeway facility."]
[]
[]
[]
[]
[null,"ACKNOWLEDGMENT OF SPONSORSHIP"]
[null,"This work was sponsored by the American Association of State Highway and Transportation Officials (AASHTO), in cooperation with the Federal Highway Administration, and was conducted in the National Cooperative Highway Research Program (NCHRP), which is administered by the Transportation Research Board of the National Academies of Sciences, Medicine, and Engineering (NASEM).  "]
[]
[]
[]
[null,"DISCLAIMER"]
[null,"This material represents the computational engine implementation of the interchange methodologies developed for the second edition of the Highway Safety Manual (HSM). \n"]
[]
[]
[null,"This computational engine is offered as is, without warranty or promise of support of any kind either expressed or implied. Under no circumstance will NASEM or the Transportation Research Board (TRB) be liable for any loss or damage caused by the installation or use of this product. NASEM, TRB, and the National Cooperative Highway Research Program (NCHRP) make no representation or warranty of any kind, expressed or implied, in fact or in law, including without limitations the warranty of merchantability or the warranty of fitness for a particular purpose, and shall not in any case be liable for any consequential or special damages. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This spreadsheet was originally developed as part of NCHRP Project 17-45 and was later modified during NCHRP Project 17-68"]
[null,"to implement strictly the HSM crash prediction methods for crossroad ramp terminals at interchanges, including crash prediction"]
[null,"models for crossroad ramp terminals at single-point and tight diamond interchanges developed as part of NCHRP 17-68."]
[null,"The changes to this spreadsheet tool were made by Dan Cook and Darren Torbic at MRIGlobal during NCHRP Project 17-68."]
[]
[]
[null,null,"Dan Cook, P.E.",null,null,null,"Darren Torbic, Ph.D."]
[null,null,"MRIGlobal",null,null,null,"MRIGlobal"]
[null,null,"425 Volker Boulevard",null,null,null,"2332 Raven Hollow Rd"]
[null,null,"Kansas City, MO",null,null,null,"State College, PA"]
[null,null,"64110-2241",null,null,null,16801]
[]
[null,null,"Email: dcook@mriglobal.org",null,null,null,"Email: dtorbic@mriglobal.org"]
[null,null,"Phone: 816-326-5127",null,null,null,"Phone: 814-237-8831"]

{"sheet":"Introduction","index":1,"n_rows":476,"n_cols":10,"rows_kept":476,"cut":false,"hidden":false,"merged":[[475,1,476,12],[377,1,379,12],[381,1,387,12],[422,1,427,12],[447,1,451,12],[472,1,473,12],[2,2,2,11],[6,1,9,12],[11,1,12,12],[14,1,18,12],[40,1,42,12],[72,1,73,12],[66,1,69,12],[75,1,76,12],[80,1,81,12],[83,1,85,12],[261,1,263,12],[112,1,114,12],[117,1,120,12],[106,1,109,12],[239,1,243,12],[221,1,222,12],[200,1,203,12],[174,1,179,12],[148,1,151,12],[143,1,145,12],[140,1,141,12]]}
[]
[]
[null,null,"INTRODUCTION"]
[]
[]
[null,"PREFACE"]
[null,"This software provides information about the relationship between geometric design features and safety.  It is based on research that quantified the relationship between various design elements (e.g., lane width) or design components (e.g., left-turn bay) and average crash frequency.  The information provided in this software is intended to help designers make informed judgments about the safety performance of design alternatives.  "]
[]
[]
[]
[]
[null,"This software does not define design controls and does not represent a design requirement.  It is not a substitute for engineering judgment.  Further, it does not represent a legal requirement for roadway design."]
[]
[]
[null,"As discussed in the Highway Safety Manual, analysts should be aware that variability in crash data is so large that crash counts averaged over only a few years may not reveal telling information about the true average crash frequency at a given site.  This large variability, combined with the subtle influence that most geometric features have on safety, can make it difficult to observe the safety effect of a change in geometry in the year or two following the change.  In many cases, the change must be implemented at many sites and monitored for several years before its true effect on safety can be detected using crash data."]
[]
[]
[]
[]
[]
[null,"EVALUATION SCOPE"]
[null,"This software can be used to evaluate the following interchange components:"]
[]
[null,"● Crossroad ramp terminals."]
[]
[]
[null,"WORKSHEET SELECTION"]
[null,"This software includes the following worksheets:"]
[]
[null,"● Welcome ",null,null,"Includes a foreword, acknowledgements, and disclaimer."]
[null,"● Introduction",null,null,"Brief overview of this software."]
[null,"● Main ",null,null,"Input data to describe evaluation and start calculations."]
[null,"● Input Ramp Terminals",null,null,"Input data describing crossroad ramp terminals."]
[null,"● Output Summary",null,null,"Summary of analysis results."]
[null,"● Output Ramp Terminals",null,null,"Detailed listing of analysis results for crossroad ramp terminals."]
[null,"● Calibration Factors",null,null,"Calibration factors for predictive models and crash type distributions."]
[]
[null,">>> Always proceed to the Main worksheet to start the evaluation process. <<<"]
[]
[null,"USER'S GUIDE"]
[null,"Each spreadsheet is designed in a consistent manner and their use is similar.  The cells with a blue background are for user input.   Most of the other cells are locked to prevent inadvertent changes to cell contents.  "]
[]
[]
[]
[null,"Main Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Place cursor over the red corner to obtain",null,null,null,null,"Drop-down list.  Click on grey square"]
[null,null,null,"a pop-up message with useful information.",null,null,null,null,"to show list. Click on input choice."]
[]
[null,"General Information"]
[null,"The analyst can enter any descriptive information about the location being analyzed.  Use the blue cells to enter this data."]
[]
[null,"Crash Data Description"]
[null,"Indicate whether crash data will be input.  If input, these data will provide a more reliable estimate of the expected crash frequency. The crash data can be provided for each site, or for the collective set of sites (i.e., for the entire project).  Of these two options, providing crash data for each site will provide a more reliable estimate of the expected crash frequency. "]
[]
[]
[]
[]
[null,"Study Period and Crash Period"]
[null,"All evaluations must have a specified study period.  This period represents the consecutive years for which an estimate of the crash frequency is desired.  It can represent past years, the current year, or some future years.  "]
[]
[]
[null,"The Study Period is defined by the \"First year of analysis\" and the \"Last year of analysis.\"  Input data (i.e., geometric design and traffic data) will need to be provided to describe conditions during the study period."]
[]
[]
[null,"The Crash Period is optional.  It is used if crash data are provided."]
[]
[null,"The Crash Period is defined by the \"First year of crash data\" and the \"Last year of crash data.\"  Input data (i.e., geometric design and traffic data) will need to be provided to describe conditions during the crash period."]
[]
[]
[null,"Note that if crash data are provided, then input data are needed for BOTH the study period and the crash period.  These periods may or may not represent the same time period.  Typically, the crash period is for some number of past years and the study period is for some number of future years."]
[]
[]
[]
[null,"Input Ramp Terminals Worksheet",null,null,null,null,null,null,"Click on a button to execute macro code."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Drop-down list.  Click on cell"]
[null,null,null,null,null,null,null,null,null,"to show list. Click on input choice."]
[]
[null,"Data entry in this worksheet should proceed from top to bottom. That is, it should proceed in the direction of increasing row number.  Worksheet macro code monitors each input value and adjusts the color of the cells in the rows below (i.e., it identifies the appropriate input cells by changing their background color to blue and eliminates the unneeded input cells by changing their background color to white)."]
[]
[]
[]
[]
[null,"Basic Intersection Data"]
[null,"Enter a value, or make a selection in a drop-down list, for each input variable.  Use the blue cells to enter this data. If the value entered is not within range, then a message is displayed indicating \"Out of Range!\". Re-enter a value that is within the indicated range."]
[]
[]
[]
[null,"Alignment Data"]
[null,"Data entry is the same as for Basic Intersection Data.  If an input value suggests the need for additional input, then additional cells in the same column may be converted to blue and require an input value.  Similarly, if an input value suggests that some input cells are not relevant, then these cells will be converted to white.  Only data in blue cells will be used in the analysis.  Data must be provided for all blue cells (unless stated otherwise)."]
[]
[]
[]
[]
[null,"Traffic Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AADT volume must be provided for one year in either the crash period or study period. Desirably, AADT volume is provided for each year of interest. The cells associated with the crash period and the study period have a blue background."]
[]
[]
[null,"In the graphic above, the crash period is for years 2005 to 2007 and the study period is for years 2013 to 2015.  If the AADT volume is unknown for one or more years, then the corresponding blue cell is left blank by the analyst. The missing AADT volumes are estimated using the rules described in Section C.5 in Part C of the Highway Safety Manual."]
[]
[]
[]
[null,"Output Ramp Terminals Worksheet"]
[null,"The output worksheet is divided into several sections. The first section lists the computed CMF values. The next section lists the estimated crash frequency, categorized by fatal-and-injury and property-damage-only crash severity categories. The next section lists the crash severity distribution. The next section lists some intermediate calculations and the last section lists the AADT values used in the calculations (including those values that were estimated because of missing AADT data)."]
[]
[]
[]
[]
[null,"Crash Modification Factors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This section summarizes the CMFs computed using the equations described in the Project 17-45 Final Report. Each CMF is associated with one geometric design or traffic control feature. Its value is 1.0 when the feature’s characteristics are the same as those used to define the base condition for the predictive model. The CMF value will be less than 1.0 if (1) the characteristics of associated feature are different from those of the base condition and (2) the sites that have this variation of the feature experience fewer crashes than otherwise similar sites but with feature characteristics consistent with base conditions.  The Highway Safety Manual provides additional discussion of CMFs."]
[]
[]
[]
[]
[]
[]
[null,"Fatal-and-Injury Crash Frequency"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The expected average crash frequency for the ramp terminal equals the sum of the expected multiple-vehicle and single-vehicle crashes.  It is an estimate of the long-run frequency of crashes for the terminal.  The expected fatal-and-injury crash frequency and the expected property-damage-only crash frequency are separately computed and summarized in the output worksheet. "]
[]
[]
[]
[]
[null,"Crash Severity Distribution"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This section provides the severity distribution of crashes for each ramp terminal.  The distribution for all terminals combined is provided in the Output Summary worksheet."]
[]
[]
[null,"Calibration Factors"]
[null,"Crash Frequency Models"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This section of the spreadsheet is intended for analysts that desire to adjust the predictive models to better match conditions in their jurisdiction.  The calibration factors and default model coefficients provided (in yellow shaded cells) are representative of several states.  The calibration factors should be used to calibrate the models to local conditions. Changes to the model coefficients should be made with care, and based on sound statistical modeling. Guidance for quantifying local calibration factors is provided in Appendix B to Part C in the 2014 Supplement to the Highway Safety Manual."]
[]
[]
[]
[]
[]
[null,"Crash Distribution"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Default values are provided for the distribution of crashes by area type, crash type, and crash type category.  The values shown are representative of roadways on the state highway system in several states.  Other values can be used, if desired, to tailor the estimates to local conditions."]
[]
[]
[]
[]
[null,"RAMP TERMINALS"]
[null,"Ramp Terminal Configurations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ramp Terminal Boundaries"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The graphic above illustrates two crossroad ramp terminals with the D4 configuration. Each terminal represents a separate site. The two terminals are shown in the context of a diamond interchange. The arrangement shown is intended to illustrate the ramp terminal boundaries used for safety evaluation–it is not necessarily typical ramp terminal geometry. "]
[]
[]
[]
[null,"The free-flow loop ramp associated with the four-quadrant parclos (i.e., the A4 and B4 configurations) is not considered to be part of the nearby ramp terminal. All subsequent discussions where “ramp AADT” is identified for these two configurations are referring to the AADT of the diagonal entrance ramp or the AADT of the diagonal exit ramp. With one exception, the loop ramp of the A4 and B4 configuration is not explicitly addressed by the ramp terminal models. The exception is the right-turn channelization that serves traffic entering the loop ramp at the A4 configuration. It can be part of the ramp terminal design and its associated crashes are addressed by the predictive models."]
[]
[]
[]
[]
[]
[]
[null,"Number of Lanes for Exit Ramps (nex)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The number of lanes serving the exit ramp (nex) is based on the count of lanes taken at the last point where all exiting movements are joined (i.e., at the channelization gore point if right-turn channelization is provided). All lanes counted need to be fully developed for 100 ft or more upstream from the point at which their respective movement intersects with the crossroad. The lane (or lanes) associated with the loop exit ramp at a B4 terminal configuration are not included in this count. The graphic above illustrates the application of this guidance."]
[]
[]
[]
[]
[]
[null,"Skew Angle"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Skew angle is measured for the exit ramp.  At a B4 terminal configuration, the skew angle represents that for the diagonal exit ramp (not the loop exit ramp). Skew angle is the acute angle between the crossroad centerline and a line along the center an imaginary vehicle stopped at the end of the exit ramp (i.e., where it joins the crossroad).  The vehicle is centered in the traveled way.  If vehicles can exit the ramp as left- or right-turn movements, then use a left-turning vehicle as the vehicle of reference. The skew angle is 0.0 degrees if the two reference lines intersect at 90 degrees."]
[]
[]
[]
[]
[]
[null,"Median Width and Turn Bay Width"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The crossroad median width at an intersection is measured between the near edges of the traveled way associated with the opposing through traffic streams. It includes the width of the left shoulder and any left-turn lanes that are present. "]
[]
[]
[null,"The left-turn bay width is measured from the near edge of the traveled way of the adjacent through lane to the lane marking (or curb face) that delineates the median."]

{"sheet":"Main","index":2,"n_rows":30,"n_cols":38,"rows_kept":30,"cut":false,"hidden":false,"merged":[[24,1,25,11],[5,10,5,11],[2,1,2,11],[4,3,4,11],[5,3,5,4],[5,6,5,7]]}
[]
[]
[null,"HSM Methodology for Chapter 19",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,null,"Freeway",null,null,null,"Ramp",null,null,null,"Ramp"]
[null,"General Information",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,null,"Segments",null,null,null,"Segments",null,null,null,"Terminals"]
[null,"Project description:",null,"Sample Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First year:",null,{"$f":"MIN($D7, AC7)","v":2015},null,null,null,{"$f":"MIN($D7, AG7)","v":2015},null,null,null,{"$f":"MIN($D7, AK7)","v":2015}]
[null,"Analyst:",null,"JAB",null,"Date:",{"$f":"NOW()","v":"2021-04-15T15:15:07.830"},null,"Area type:",null,"Urban",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last year:",null,{"$f":"MAX($D8,AC8)","v":2015},null,null,null,{"$f":"MAX($D8,AG8)","v":2015},null,null,null,{"$f":"MAX($D8,AK8)","v":2015}]
[null,"First year of analysis:",null,2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First crash data year:",null,{"$f":"AD7","v":2015},2015,null,null,{"$f":"AH7","v":2015},2015,null,null,{"$f":"AL7","v":2015},2015]
[null,"Last year of analysis:",null,2015,{"$f":"IF(D8<D7, \"Note: must equal or exceed first year of analysis.\", IF(D8-MIN(AC5,AG5,AK5)+1>24, \"Note: last year must be less than or equal to \"&TEXT(MIN(AC5,AG5,AK5)+24-1,\"0\"),\".\"))","v":"."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last crash data year:",null,{"$f":"MIN($D$8, AD8, AC7+4,YEAR(NOW()))","v":2015},2015,null,null,{"$f":"MIN($D$8, AH8, AG7+4,YEAR(NOW()))","v":2015},2015,null,null,{"$f":"MIN($D$8, AL8, AK7+4,YEAR(NOW()))","v":2015},2015]
[null,"Crash Data Description"]
[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,null,"Freeway Segments",null,null,null,"Ramp Segments",null,null,null,"Ramp Terminals"]
[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,null,"No crash data",null,"Data for each individual segment",null,"No crash data",null,"Data for each individual segment",null,"No crash data",null,"No crash data"]
[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,null,"Data for all segments combined",null,null,null,"Data for all segments combined",null,null,null,"Data for all terminals combined"]
[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,null,"Data for each individual segment",null,null,null,"Data for each individual segment",null,null,null,"Data for each individual terminal"]
[null,"Ramp terminals",null,null,null,null,{"$f":"IF(L15-I15>4, \"Upper limit of 5 years of crash data.\", \".\")","v":"."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data?",{"$f":"IF(AC11=AA11, FALSE, TRUE)","v":true},null,null,null,{"$f":"IF(AG11=AE11, FALSE, TRUE)","v":true},null,null,null,{"$f":"IF(AK11=AI11, FALSE, TRUE)","v":false}]
[null,null,null,null,null,null,"First year of crash data:",null,2015,"Last year of crash data:",null,2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project?",{"$f":"IF(AC11=AA12,TRUE,FALSE)","v":false},null,null,null,{"$f":"IF(AG11=AE12,TRUE,FALSE)","v":false},null,null,null,{"$f":"IF(AK11=AI12,TRUE,FALSE)","v":false}]
[]
[]
[null,"Program Control"]
[null,"1. Enter data in the Main and Input Ramp Terminals worksheets."]
[null,"2. Click Perform Calculations button to start calculation process."]
[]
[]
[]
[null,"3. Review results in the Output Summary worksheet. Optionally, click the Print buttons to print the summary worksheets."]
[null,"4. Optionally, detailed results can be reviewed in the Output Ramp Terminals worksheets."]
[]
[]
[]
[null,"Warning Messages",null,"     See note"]
[null,null,null,null,null,null,null,"Ramp Terminals"]

{"sheet":"Input Ramp Terminals","index":3,"n_rows":183,"n_cols":31,"rows_kept":183,"cut":false,"hidden":false,"merged":[[42,1,42,5],[4,26,5,26],[4,27,5,27],[4,28,5,28],[4,29,5,29],[4,30,5,30],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,23,5,23],[4,24,5,24],[4,25,5,25],[4,17,5,17],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,19,5,19],[4,15,5,15],[4,16,5,16],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[140,5,141,5],[4,14,5,14],[44,6,44,7],[45,6,45,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[53,6,53,7],[62,6,62,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[66,6,66,7],[67,6,67,7],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[52,8,52,9],[53,8,53,9],[54,8,54,9],[55,8,55,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[48,10,48,11],[49,10,49,11],[50,10,50,11],[51,10,51,11],[44,10,44,11],[45,10,45,11],[46,10,46,11],[47,10,47,11],[56,10,56,11],[57,10,57,11],[58,10,58,11],[59,10,59,11],[52,10,52,11],[53,10,53,11],[54,10,54,11],[55,10,55,11],[64,10,64,11],[65,10,65,11],[66,10,66,11],[67,10,67,11],[60,10,60,11],[61,10,61,11],[62,10,62,11],[63,10,63,11],[48,12,48,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[64,12,64,13],[65,12,65,13],[66,12,66,13],[67,12,67,13],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[56,12,56,13],[57,12,57,13],[58,12,58,13],[59,12,59,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[55,14,55,15],[64,14,64,15],[65,14,65,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[44,14,44,15],[45,14,45,15],[46,14,46,15],[47,14,47,15],[56,14,56,15],[66,14,66,15],[67,14,67,15],[60,14,60,15],[61,14,61,15],[62,14,62,15],[63,14,63,15],[48,16,48,17],[49,16,49,17],[50,16,50,17],[51,16,51,17],[64,16,64,17],[65,16,65,17],[66,16,66,17],[67,16,67,17],[60,16,60,17],[61,16,61,17],[62,16,62,17],[63,16,63,17],[57,14,57,15],[58,14,58,15],[59,14,59,15],[52,14,52,15],[53,14,53,15],[54,14,54,15],[44,16,44,17],[45,16,45,17],[46,16,46,17],[47,16,47,17],[56,16,56,17],[57,16,57,17],[58,16,58,17],[59,16,59,17],[52,16,52,17],[53,16,53,17],[54,16,54,17],[55,16,55,17],[79,6,79,7],[88,6,88,7],[89,6,89,7],[72,6,72,7],[73,6,73,7],[74,6,74,7],[75,6,75,7],[68,6,68,7],[69,6,69,7],[70,6,70,7],[71,6,71,7],[80,6,80,7],[90,6,90,7],[91,6,91,7],[84,6,84,7],[85,6,85,7],[86,6,86,7],[87,6,87,7],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[81,6,81,7],[82,6,82,7],[83,6,83,7],[76,6,76,7],[77,6,77,7],[78,6,78,7],[68,8,68,9],[69,8,69,9],[70,8,70,9],[71,8,71,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[79,10,79,11],[88,10,88,11],[89,10,89,11],[72,10,72,11],[73,10,73,11],[74,10,74,11],[75,10,75,11],[68,10,68,11],[69,10,69,11],[70,10,70,11],[71,10,71,11],[80,10,80,11],[90,10,90,11],[91,10,91,11],[84,10,84,11],[85,10,85,11],[86,10,86,11],[87,10,87,11],[72,12,72,13],[73,12,73,13],[74,12,74,13],[75,12,75,13],[88,12,88,13],[89,12,89,13],[90,12,90,13],[91,12,91,13],[84,12,84,13],[85,12,85,13],[86,12,86,13],[87,12,87,13],[81,10,81,11],[82,10,82,11],[83,10,83,11],[76,10,76,11],[77,10,77,11],[78,10,78,11],[68,12,68,13],[69,12,69,13],[70,12,70,13],[71,12,71,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[83,12,83,13],[76,12,76,13],[77,12,77,13],[78,12,78,13],[79,12,79,13],[79,14,79,15],[88,14,88,15],[89,14,89,15],[72,14,72,15],[73,14,73,15],[74,14,74,15],[75,14,75,15],[68,14,68,15],[69,14,69,15],[70,14,70,15],[71,14,71,15],[80,14,80,15],[90,14,90,15],[91,14,91,15],[84,14,84,15],[85,14,85,15],[86,14,86,15],[87,14,87,15],[72,16,72,17],[73,16,73,17],[74,16,74,17],[75,16,75,17],[88,16,88,17],[89,16,89,17],[90,16,90,17],[91,16,91,17],[84,16,84,17],[85,16,85,17],[86,16,86,17],[87,16,87,17],[81,14,81,15],[82,14,82,15],[83,14,83,15],[76,14,76,15],[77,14,77,15],[78,14,78,15],[68,16,68,17],[69,16,69,17],[70,16,70,17],[71,16,71,17],[80,16,80,17],[81,16,81,17],[82,16,82,17],[83,16,83,17],[76,16,76,17],[77,16,77,17],[78,16,78,17],[79,16,79,17],[103,6,103,7],[112,6,112,7],[113,6,113,7],[96,6,96,7],[97,6,97,7],[98,6,98,7],[99,6,99,7],[92,6,92,7],[93,6,93,7],[94,6,94,7],[95,6,95,7],[104,6,104,7],[114,6,114,7],[115,6,115,7],[108,6,108,7],[109,6,109,7],[110,6,110,7],[111,6,111,7],[96,8,96,9],[97,8,97,9],[98,8,98,9],[99,8,99,9],[112,8,112,9],[113,8,113,9],[114,8,114,9],[115,8,115,9],[108,8,108,9],[109,8,109,9],[110,8,110,9],[111,8,111,9],[105,6,105,7],[106,6,106,7],[107,6,107,7],[100,6,100,7],[101,6,101,7],[102,6,102,7],[92,8,92,9],[93,8,93,9],[94,8,94,9],[95,8,95,9],[104,8,104,9],[105,8,105,9],[106,8,106,9],[107,8,107,9],[100,8,100,9],[101,8,101,9],[102,8,102,9],[103,8,103,9],[103,10,103,11],[112,10,112,11],[113,10,113,11],[96,10,96,11],[97,10,97,11],[98,10,98,11],[99,10,99,11],[92,10,92,11],[93,10,93,11],[94,10,94,11],[95,10,95,11],[104,10,104,11],[114,10,114,11],[115,10,115,11],[108,10,108,11],[109,10,109,11],[110,10,110,11],[111,10,111,11],[96,12,96,13],[97,12,97,13],[98,12,98,13],[99,12,99,13],[112,12,112,13],[113,12,113,13],[114,12,114,13],[115,12,115,13],[108,12,108,13],[109,12,109,13],[110,12,110,13],[111,12,111,13],[105,10,105,11],[106,10,106,11],[107,10,107,11],[100,10,100,11],[101,10,101,11],[102,10,102,11],[92,12,92,13],[93,12,93,13],[94,12,94,13],[95,12,95,13],[104,12,104,13],[105,12,105,13],[106,12,106,13],[107,12,107,13],[100,12,100,13],[101,12,101,13],[102,12,102,13],[103,12,103,13],[103,14,103,15],[112,14,112,15],[113,14,113,15],[96,14,96,15],[97,14,97,15],[98,14,98,15],[99,14,99,15],[92,14,92,15],[93,14,93,15],[94,14,94,15],[95,14,95,15],[104,14,104,15],[114,14,114,15],[115,14,115,15],[108,14,108,15],[109,14,109,15],[110,14,110,15],[111,14,111,15],[96,16,96,17],[97,16,97,17],[98,16,98,17],[99,16,99,17],[112,16,112,17],[113,16,113,17],[114,16,114,17],[115,16,115,17],[108,16,108,17],[109,16,109,17],[110,16,110,17],[111,16,111,17],[105,14,105,15],[106,14,106,15],[107,14,107,15],[100,14,100,15],[101,14,101,15],[102,14,102,15],[92,16,92,17],[93,16,93,17],[94,16,94,17],[95,16,95,17],[104,16,104,17],[105,16,105,17],[106,16,106,17],[107,16,107,17],[100,16,100,17],[101,16,101,17],[102,16,102,17],[103,16,103,17],[127,6,127,7],[136,6,136,7],[137,6,137,7],[120,6,120,7],[121,6,121,7],[122,6,122,7],[123,6,123,7],[116,6,116,7],[117,6,117,7],[118,6,118,7],[119,6,119,7],[128,6,128,7],[138,6,138,7],[139,6,139,7],[132,6,132,7],[133,6,133,7],[134,6,134,7],[135,6,135,7],[120,8,120,9],[121,8,121,9],[122,8,122,9],[123,8,123,9],[136,8,136,9],[137,8,137,9],[138,8,138,9],[139,8,139,9],[132,8,132,9],[133,8,133,9],[134,8,134,9],[135,8,135,9],[129,6,129,7],[130,6,130,7],[131,6,131,7],[124,6,124,7],[125,6,125,7],[126,6,126,7],[116,8,116,9],[117,8,117,9],[118,8,118,9],[119,8,119,9],[128,8,128,9],[129,8,129,9],[130,8,130,9],[131,8,131,9],[124,8,124,9],[125,8,125,9],[126,8,126,9],[127,8,127,9],[127,10,127,11],[136,10,136,11],[137,10,137,11],[120,10,120,11],[121,10,121,11],[122,10,122,11],[123,10,123,11],[116,10,116,11],[117,10,117,11],[118,10,118,11],[119,10,119,11],[128,10,128,11],[138,10,138,11],[139,10,139,11],[132,10,132,11],[133,10,133,11],[134,10,134,11],[135,10,135,11],[120,12,120,13],[121,12,121,13],[122,12,122,13],[123,12,123,13],[136,12,136,13],[137,12,137,13],[138,12,138,13],[139,12,139,13],[132,12,132,13],[133,12,133,13],[134,12,134,13],[135,12,135,13],[129,10,129,11],[130,10,130,11],[131,10,131,11],[124,10,124,11],[125,10,125,11],[126,10,126,11],[116,12,116,13],[117,12,117,13],[118,12,118,13],[119,12,119,13],[128,12,128,13],[129,12,129,13],[130,12,130,13],[131,12,131,13],[124,12,124,13],[125,12,125,13],[126,12,126,13],[127,12,127,13],[127,14,127,15],[136,14,136,15],[137,14,137,15],[120,14,120,15],[121,14,121,15],[122,14,122,15],[123,14,123,15],[116,14,116,15],[117,14,117,15],[118,14,118,15],[119,14,119,15],[128,14,128,15],[138,14,138,15],[139,14,139,15],[132,14,132,15],[133,14,133,15],[134,14,134,15],[135,14,135,15],[120,16,120,17],[121,16,121,17],[122,16,122,17],[123,16,123,17],[136,16,136,17],[137,16,137,17],[138,16,138,17],[139,16,139,17],[132,16,132,17],[133,16,133,17],[134,16,134,17],[135,16,135,17],[129,14,129,15],[130,14,130,15],[131,14,131,15],[124,14,124,15],[125,14,125,15],[126,14,126,15],[116,16,116,17],[117,16,117,17],[118,16,118,17],[119,16,119,17],[128,16,128,17],[129,16,129,17],[130,16,130,17],[131,16,131,17],[124,16,124,17],[125,16,125,17],[126,16,126,17],[127,16,127,17]]}
[]
[]
[null,null,null,null,"Input Worksheet for Crossroad Ramp Terminals"]
[null,null,null,null,null,null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 1"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 2"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 3"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 4"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 5"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 6"},null,null,{"$f":"G4","v":"Terminal 1"},null,{"$f":"I4","v":"Terminal 2"},null,{"$f":"K4","v":"Terminal 3"},null,{"$f":"M4","v":"Terminal 4"},null,{"$f":"O4","v":"Terminal 5"},null,{"$f":"Q4","v":"Terminal 6"}]
[null,null,null,null,null,null,{"$f":"IF(Main!$AK$14=TRUE, \"Crash Period\", \"Study Period\")","v":"Study Period"},{"$f":"IF(Main!$AK$14=TRUE, \"Study Period\", \"\")","v":""},{"$f":"G5","v":"Study Period"},"","Study Period","","Study Period","","Study Period","","Study Period","",null,{"$f":"G5","v":"Study Period"},{"$f":"H5","v":""},{"$f":"I5","v":"Study Period"},{"$f":"J5","v":""},{"$f":"K5","v":"Study Period"},{"$f":"L5","v":""},{"$f":"M5","v":"Study Period"},{"$f":"N5","v":""},{"$f":"O5","v":"Study Period"},{"$f":"P5","v":""},{"$f":"Q5","v":"Study Period"},{"$f":"R5","v":""}]
[null,null,"      (View results in Column T)","(View results in Advisory Messages)"]
[null,"Basic Intersection Data"]
[null,"Ramp terminal configuration:",null,null,null,null,"TDI",{"$f":"G8","v":"TDI"},null,{"$f":"I8","v":0},null,{"$f":"K8","v":0},null,{"$f":"M8","v":0},null,{"$f":"O8","v":0},null,{"$f":"Q8","v":0},null,"SPUI","SPUI"]
[null,"Ramp terminal description:",null,null,null,null,"NB exit ramp at Main",null,"SB exit ramp at Main",null,null,"Alt 1",null,null,null,null,null,null,null,"NB exit ramp at Main"]
[null,"Ramp terminal traffic control type:",null,null,null,null,"Signal",{"$f":"G10","v":"Signal"},"One stop",{"$f":"I10","v":"One stop"},"One stop",{"$f":"K10","v":"One stop"},"All stop",{"$f":"M10","v":"All stop"},"One stop",{"$f":"O10","v":"One stop"},"Signal",{"$f":"Q10","v":"Signal"},null,"Signal","Signal"]
[null,"Is a non-ramp public street leg present at the terminal (Ips)?:",null,null,null,null,"No",{"$f":"G11","v":"No"},null,{"$f":"I11","v":0},null,{"$f":"K11","v":0},null,{"$f":"M11","v":0},null,{"$f":"O11","v":0},"No",{"$f":"Q11","v":"No"}]
[null,"Alignment Data"]
[null,"Exit ramp skew angle (Isk), degrees:",null,null,null,null,2,{"$f":"G13","v":2},1,{"$f":"I13","v":1},15,{"$f":"K13","v":15},35,{"$f":"M13","v":35},52,{"$f":"O13","v":52},null,{"$f":"Q13","v":0},null,0,0]
[null,"Distance to the next public street intersection on the outside crossroad leg (Lstr), mi:",null,null,null,null,0.02,{"$f":"G14","v":0.02},0.13,{"$f":"I14","v":0.13},0.56999999999999995,{"$f":"K14","v":0.56999999999999995},0.55000000000000004,{"$f":"M14","v":0.55000000000000004},0.12,{"$f":"O14","v":0.12},7.4999999999999997E-2,{"$f":"Q14","v":7.4999999999999997E-2},null,1.9999999552965164E-2,1.9999999552965164E-2]
[null,"Distance to the adjacent ramp terminal (Lrmp), mi:",null,null,null,null,0.12,{"$f":"G15","v":0.12},0.15,{"$f":"I15","v":0.15},0.15,{"$f":"K15","v":0.15},8.5000000000000006E-2,{"$f":"M15","v":8.5000000000000006E-2},0.16,{"$f":"O15","v":0.16},0.17,{"$f":"Q15","v":0.17},null,0,0.11999999731779099]
[null,"Traffic Control"]
[null,"Left-Turn Operational Mode"]
[null,"Crossroad","Inside approach","Protected-only mode (Ip,lt,in)?:",null,null,"Yes",{"$f":"G18","v":"Yes"},null,{"$f":"I18","v":0},null,{"$f":"K18","v":0},null,{"$f":"M18","v":0},null,{"$f":"O18","v":0},null,{"$f":"Q18","v":0}]
[null,null,"Outside approach","Protected-only mode (Ip,lt,out)?:",null,null,null,{"$f":"G19","v":0},null,{"$f":"I19","v":0},null,{"$f":"K19","v":0},null,{"$f":"M19","v":0},null,{"$f":"O19","v":0},null,{"$f":"Q19","v":0}]
[null,"Right-Turn Control Type"]
[null,"Ramp","Exit ramp approach","Right-turn control type:",null,null,"Signal",{"$f":"G21","v":"Signal"},"Stop",{"$f":"I21","v":"Stop"},"Stop",{"$f":"K21","v":"Stop"},"Stop",{"$f":"M21","v":"Stop"},"Stop",{"$f":"O21","v":"Stop"},"Yield",{"$f":"Q21","v":"Yield"}]
[null,"Cross Section Data"]
[null,"Crossroad median width (Wm), ft:",null,null,null,null,12,{"$f":"G23","v":12},15,{"$f":"I23","v":15},16,{"$f":"K23","v":16},0,{"$f":"M23","v":0},12,{"$f":"O23","v":12},0,{"$f":"Q23","v":0},null,0,12]
[null,"Number of Lanes"]
[null,"Crossroad","Both approaches","Lanes serving through vehicles (nth):",null,null,4,{"$f":"G25","v":4},2,{"$f":"I25","v":2},4,{"$f":"K25","v":4},2,{"$f":"M25","v":2},2,{"$f":"O25","v":2},5,{"$f":"Q25","v":5},null,4,4]
[null,null,"Inside approach","Lanes serving through vehicles (nth,in):",null,null,2,{"$f":"G26","v":2},null,{"$f":"I26","v":0},null,{"$f":"K26","v":0},null,{"$f":"M26","v":0},null,{"$f":"O26","v":0},2,{"$f":"Q26","v":2},null,0,0]
[null,null,"Outside approach","Lanes serving through vehicles (nth,out):",null,null,{"$f":"G25-G26","v":2},{"$f":"H25-H26","v":2},{"$f":"I25-I26","v":2},2,4,4,2,2,2,2,3,3,null,0,0]
[null,"Ramp","Exit ramp approach","All lanes (nex):",null,null,3,{"$f":"G28","v":3},1,{"$f":"I28","v":1},1,{"$f":"K28","v":1},1,{"$f":"M28","v":1},1,{"$f":"O28","v":1},2,{"$f":"Q28","v":2},null,0,0]
[null,"Right-Turn Channelization",null,null,"         see note:"]
[null,"Crossroad","Inside approach","Channelization present (Ich,in)?:",null,null,null,{"$f":"G30","v":0},null,{"$f":"I30","v":0},null,{"$f":"K30","v":0},null,{"$f":"M30","v":0},null,{"$f":"O30","v":0},"No",{"$f":"Q30","v":"No"}]
[null,null,"Outside approach","Channelization present (Ich,out)?:",null,null,"Yes",{"$f":"G31","v":"Yes"},null,{"$f":"I31","v":0},null,{"$f":"K31","v":0},null,{"$f":"M31","v":0},null,{"$f":"O31","v":0},"No",{"$f":"Q31","v":"No"}]
[null,"Ramp","Exit ramp approach","Channelization present (Ich,ex)?:",null,null,"No",{"$f":"G32","v":"No"},null,{"$f":"I32","v":0},null,{"$f":"K32","v":0},null,{"$f":"M32","v":0},null,{"$f":"O32","v":0},"Yes",{"$f":"Q32","v":"Yes"}]
[null,"Left-Turn Lane or Bay"]
[null,"Crossroad","Inside approach","Lane or bay present (Ibay,lt,in)?:",null,null,"No",{"$f":"G34","v":"No"},null,{"$f":"I34","v":0},null,{"$f":"K34","v":0},null,{"$f":"M34","v":0},"Yes",{"$f":"O34","v":"Yes"},null,{"$f":"Q34","v":0}]
[null,null,null,"Width of lane or bay (Wb,in), ft:",null,null,10,{"$f":"G35","v":10},null,{"$f":"I35","v":0},null,{"$f":"K35","v":0},null,{"$f":"M35","v":0},10,{"$f":"O35","v":10},null,{"$f":"Q35","v":0},null,0,0]
[null,null,"Outside approach","Lane or bay present (Ibay,lt,out)?:",null,null,null,{"$f":"G36","v":0},"Yes",{"$f":"I36","v":"Yes"},null,{"$f":"K36","v":0},null,{"$f":"M36","v":0},null,{"$f":"O36","v":0},null,{"$f":"Q36","v":0}]
[null,null,null,"Width of lane or bay (Wb,out), ft:",null,null,null,{"$f":"G37","v":0},12,{"$f":"I37","v":12},null,{"$f":"K37","v":0},null,{"$f":"M37","v":0},null,{"$f":"O37","v":0},null,{"$f":"Q37","v":0},null,0,0]
[null,"Right-Turn Lane or Bay"]
[null,"Crossroad","Inside approach","Lane or bay present (Ibay,rt,in)?:",null,null,null,{"$f":"G39","v":0},"Yes",{"$f":"I39","v":"Yes"},null,{"$f":"K39","v":0},null,{"$f":"M39","v":0},null,{"$f":"O39","v":0},"Yes",{"$f":"Q39","v":"Yes"}]
[null,null,"Outside approach","Lane or bay present (Ibay,rt,out)?:",null,null,"Yes",{"$f":"G40","v":"Yes"},null,{"$f":"I40","v":0},null,{"$f":"K40","v":0},null,{"$f":"M40","v":0},"No",{"$f":"O40","v":"No"},"Yes",{"$f":"Q40","v":"Yes"}]
[null,"Access Data"]
[null,"Number of driveways on the outside crossroad leg (ndw):",null,null,null,null,1,{"$f":"G42","v":1},null,{"$f":"I42","v":0},null,{"$f":"K42","v":0},null,{"$f":"M42","v":0},null,{"$f":"O42","v":0},3,{"$f":"Q42","v":3},null,0,0]
[null,"Number of public street approaches on the outside crossroad leg (nps); Number of exit ramps with free-flow right turns onto crossroad (SPUI Only):",null,null,null,null,0,{"$f":"G43","v":0},1,{"$f":"I43","v":1},0,{"$f":"K43","v":0},0,{"$f":"M43","v":0},0,{"$f":"O43","v":0},0,{"$f":"Q43","v":0},null,0,0]
[null,"Traffic Data",null,null,null,"Year"]
[null,"Inside Crossroad Leg Data ",null,null,null,{"$f":"Main!AK5","v":2015},31250,null,6985,null,null,null,3677,null,8814,null,23500,null,null,31250]
[null,"Average daily traffic (AADTin) by year, veh/d:",null,null,null,{"$f":"F45+1","v":2016},null,null,7000,null,null,null,null,null,null,null,null,null,null,0]
[null," (enter data only for those years for which",null,null,null,{"$f":"F46+1","v":2017},50000,null,null,null,7142,null,null,null,null,null,null,null,null,0]
[null,"  it is available, leave other years blank)",null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2024,52000,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2030,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2031,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2032,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2033,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2034,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2035,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2036,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2037,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2038,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Outside Crossroad Leg Data ",null,null,null,{"$f":"F45","v":2015},31250,null,null,null,null,null,3677,null,8814,null,null,null,null,31250]
[null,"Average daily traffic (AADTout) by year, veh/d:",null,null,null,{"$f":"F69+1","v":2016},null,null,6985,null,7142,null,null,null,null,null,null,null,null,0]
[null," (enter data only for those years for which",null,null,null,{"$f":"F70+1","v":2017},50000,null,7000,null,7142,null,null,null,null,null,23500,null,null,0]
[null,"  it is available, leave other years blank)",null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2030,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2031,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2032,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2033,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2034,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2035,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2036,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2037,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2038,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Exit Ramp Data ",null,null,null,{"$f":"F69","v":2015},10500,null,806,null,2580,null,958,null,1782,null,null,null,null,10500]
[null,"Average daily traffic (AADTex) by year, veh/d:",null,null,null,{"$f":"F93+1","v":2016},null,null,null,null,2580,null,null,null,null,null,2550,null,null,0]
[null," (enter data only for those years for which",null,null,null,{"$f":"F94+1","v":2017},null,null,null,null,2580,null,null,null,null,null,null,null,null,0]
[null,"  it is available, leave other years blank)",null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"For a B4 terminal configuration, enter the AADT for the ",null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"diagonal exit ramp (not the loop exit ramp).",null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"For a SPUI or TDI terminal configuration, enter AADT for both ",null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"exit ramps combined",null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2030,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2031,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2032,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2033,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2034,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2035,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2036,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2037,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2038,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Entrance Ramp Data ",null,null,null,{"$f":"F93","v":2015},8200,null,null,null,null,null,3437,null,null,null,5900,null,null,8200]
[null,"Average daily traffic (AADTen) by year, veh/d:",null,null,null,{"$f":"F117+1","v":2016},null,null,4050,null,null,null,null,null,4610,null,null,null,null,0]
[null," (enter data only for those years for which",null,null,null,{"$f":"F118+1","v":2017},7807,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"  it is available, leave other years blank)",null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"For an A4 terminal configuration, enter the AADT for the ",null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"diagonal entrance ramp (not the loop entrance ramp).",null,null,null,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2022,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"For a SPUI or TDI terminal configuration, enter AADT for both ",null,null,null,2023,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"entrance ramps combined",null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2029,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2030,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2031,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2032,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2033,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2034,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2035,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2036,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2037,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,2038,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Crash Data",null,null,"Year",{"$f":"IF(Main!$AK$15=TRUE, \"Project Crashes\", \"\")","v":""},"Ramp Terminal Crashes -->"]
[null,"Count of Fatal-and-Injury (FI) Crashes by Year"]
[null,null,"(No,w,ac,at,fi)",null,{"$f":"Main!AK7","v":2015},15,6,null,0,null,0,null,0,null,2,null,1,null,null,6]
[null,null,null,null,{"$f":"E143+1","v":2016},17,3,null,1,null,0,null,0,null,2,null,2,null,null,3]
[null,null,null,null,{"$f":"E144+1","v":2017},16,12,null,1,null,0,null,0,null,2,null,1,null,null,0]
[null,null,null,null,{"$f":"E145+1","v":2018},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"E146+1","v":2019},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Count of Property-Damage-Only (PDO) Crashes by Year"]
[null,null,"(No,w,ac,at,pdo)",null,{"$f":"E143","v":2015},14,12,null,0,null,1,null,0,null,1,null,2,null,null,12]
[null,null,null,null,{"$f":"E144","v":2016},15,13,null,1,null,1,null,0,null,1,null,2,null,null,13]
[null,null,null,null,{"$f":"E145","v":2017},13,10,null,0,null,0,null,0,null,0,null,3,null,null,0]
[null,null,null,null,{"$f":"E146","v":2018},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"E147","v":2019},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Advisory Messages"]
[null,"Average daily traffic (AADTin) by year, veh/d:",null,null,null,null,null,null,null,null,"Need AADT"]
[null,"Average daily traffic (AADTout) by year, veh/d:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Need AADT"]
[null,"Average daily traffic (AADTen) by year, veh/d:",null,null,null,null,null,null,null,null,"Need AADT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable Limits"]
[null,{"$f":"B24","v":"Number of Lanes"}]
[null,null,{"$f":"C25","v":"Both approaches"},null,null,null,{"$f":"IF(AND(Main!$K$6= \"Urban\", G$10=\"Signal\"),6, 4)","v":6},{"$f":"IF(AND(Main!$K$6= \"Urban\", H$10=\"Signal\"),6, 4)","v":6},{"$f":"IF(AND(Main!$K$6= \"Urban\", I$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", J$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", K$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", L$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", M$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", N$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", O$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", P$10=\"Signal\"),6, 4)","v":4},{"$f":"IF(AND(Main!$K$6= \"Urban\", Q$10=\"Signal\"),6, 4)","v":6},{"$f":"IF(AND(Main!$K$6= \"Urban\", R$10=\"Signal\"),6, 4)","v":6}]
[null,null,{"$f":"B28","v":"Ramp"},null,null,null,{"$f":"IF(G$10=\"Signal\",4, 2)","v":4},4,2,2,2,2,2,2,2,2,4,4]

{"sheet":"Output Summary","index":4,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[[2,13,2,23],[4,15,4,23],[5,15,5,16],[5,18,5,19],[5,22,5,23],[49,1,50,2],[49,3,50,5],[2,1,2,11],[4,3,4,11],[5,3,5,4],[5,6,5,7],[5,10,5,11],[49,6,49,11]]}
[]
[]
[null,"Output Summary",null,null,null,null,null,null,null,null,null,null,null,"Evaluation Site Summary"]
[null,"General Information",null,null,null,null,null,null,null,null,null,null,null,"General Information"]
[null,"Project description:",null,{"$f":"Main!D5","v":"Sample Data"},null,null,null,null,null,null,null,null,null,"Project description:",null,{"$f":"D5","v":"Sample Data"}]
[null,"Analyst:",null,{"$f":"Main!D6","v":"JAB"},null,"Date:",{"$f":"Main!G6","v":"2021-04-15T15:15:07.830"},null,"Area type:",null,{"$f":"Main!K6","v":"Urban"},null,null,"Analyst:",null,{"$f":"D6","v":"JAB"},null,"Date:",{"$f":"G6","v":"2021-04-15T15:15:07.830"},null,"Area type:",null,{"$f":"K6","v":"Urban"}]
[null,"First year of analysis:",null,{"$f":"Main!D7","v":2015},null,null,null,null,null,null,null,null,null,"First year of analysis:",null,{"$f":"D7","v":2015}]
[null,"Last year of analysis:",null,{"$f":"Main!D8","v":2015},null,null,null,null,null,null,null,null,null,"Last year of analysis:",null,{"$f":"D8","v":2015}]
[null,"Crash Data Description",null,null,null,null,null,null,null,null,null,null,null,"Site Description"]
[]
[]
[]
[]
[null,"Ramp terminals",null,"Site crash data available?",null,null,null,"No","First year of crash data:"]
[null,null,null,"Project-level crash data available?",null,null,null,"No","Last year of crash data:"]
[null,"Estimated Crash Statistics"]
[null,"Crashes for Entire Facility",null,null,null,null,"Total","K","A","B","C","PDO"]
[null,"Estimated number of crashes during Study Period, crashes:",null,null,null,null,13.503683090209961,1.1429481208324432E-2,0.23239944875240326,1.2534331083297729,2.3125650882720947,9.6938562393188477]
[null,"Estimated average crash freq. during Study Period, crashes/yr:",null,null,null,null,13.503683090209961,1.1429481208324432E-2,0.23239944875240326,1.2534331083297729,2.3125650882720947,9.6938562393188477]
[null,"Crashes by Facility Component",null,null,null,"Nbr. Sites","Total","K","A","B","C","PDO"]
[]
[]
[null,"Crossroad ramp terminals, crashes:",null,null,null,1,13.503683090209961,1.1429481208324432E-2,0.23239944875240326,1.2534331083297729,2.3125650882720947,9.6938562393188477]
[null,"Crashes for Entire Facility by Year",null,null,null,"Year","Total","K","A","B","C","PDO"]
[null,"Estimated number of crashes during",null,null,null,{"$f":"Main!D7","v":2015},13.503683090209961,1.1429481208324432E-2,0.23239944875240326,1.2534331083297729,2.3125650882720947,9.6938562393188477]
[null,"the Study Period, crashes:",null,null,null,{"$f":"F25+1","v":2016}]
[null,null,null,null,null,{"$f":"F26+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Distribution of Crashes for Entire Facility"]
[null,"Crash Type",null,"Crash Type Category",null,null,"Estimated Number of Crashes During the Study Period"]
[null,null,null,null,null,null,"Total","K","A","B","C","PDO"]
[null,"Multiple vehicle",null,"Head-on crashes:",null,null,8.6567550897598267E-2,1.142948167398572E-4,2.3239946458488703E-3,1.2534330599009991E-2,2.3125650361180305E-2,4.8469282686710358E-2]
[null,null,null,"Right-angle crashes:",null,null,3.9779162406921387,4.9832537770271301E-3,0.10132616013288498,0.54649680852890015,1.0082783699035645,2.3168315887451172]
[null,null,null,"Rear-end crashes:",null,null,7.3043060302734375,5.0746896304190159E-3,0.10318535566329956,0.55652427673339844,1.0267788171768188,5.6127429008483887]
[null,null,null,"Sideswipe crashes:",null,null,1.3087133169174194,3.2002548687160015E-4,6.5071848221123219E-3,3.5096127539873123E-2,6.4751818776130676E-2,1.2020381689071655]
[null,null,null,"Other multiple-vehicle crashes:",null,null,0.18143191933631897,1.3715378008782864E-4,2.7887935284525156E-3,1.5041196718811989E-2,2.7750780805945396E-2,0.13571399450302124,null,"Crossroad Ramp Terminals"]
[null,null,null,"   Total multiple-vehicle crashes:",null,null,12.85893440246582,1.0629418306052685E-2,0.21613149344921112,1.1656928062438965,2.1506853103637695,9.3157949447631836,null,"Number","Config.","Control",{"$f":"IF(Main!$AK$14=TRUE, \"Crash Period Description\", \"Study Period Description\")","v":"Study Period Description"},null,null,null,{"$f":"IF(Main!$AK$14=TRUE, \"Study Period Description\", \"\")","v":""}]
[null,"Single vehicle",null,"Crashes with animal:",null,null,0,0,0,0,0,0]
[null,null,null,"Crashes with fixed object:",null,null,0.35973116755485535,1.4858326176181436E-4,3.0211929697543383E-3,1.6294630244374275E-2,3.0063346028327942E-2,0.31020340323448181,null,1,{"$f":"'Input Ramp Terminals'!$G$8","v":"TDI"},{"$f":"'Input Ramp Terminals'!$G$10","v":"Signal"},{"$f":" 'Input Ramp Terminals'!$G$9","v":"NB exit ramp at Main"},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$H$9, \"\")","v":""}]
[null,null,null,"Crashes with other object:",null,null,9.6938563510775566E-3,0,0,0,0,9.6938563510775566E-3,null,{"$f":"N59+1","v":2},{"$f":"'Input Ramp Terminals'!$I$8","v":0},{"$f":"'Input Ramp Terminals'!$I$10","v":"One stop"},{"$f":" 'Input Ramp Terminals'!$I$9","v":"SB exit ramp at Main"},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$J$9, \"\")","v":""}]
[null,null,null,"Crashes with parked vehicle:",null,null,0,0,0,0,0,0,null,{"$f":"N60+1","v":3},{"$f":"'Input Ramp Terminals'!$K$8","v":0},{"$f":"'Input Ramp Terminals'!$K$10","v":"One stop"},{"$f":" 'Input Ramp Terminals'!$K$9","v":0},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$L$9, \"\")","v":""}]
[null,null,null,"Other single-vehicle crashes",null,null,0.27532327175140381,6.5148045541718602E-4,1.3246769085526466E-2,7.1445688605308533E-2,0.13181620836257935,5.816313624382019E-2,null,{"$f":"N61+1","v":4},{"$f":"'Input Ramp Terminals'!$M$8","v":0},{"$f":"'Input Ramp Terminals'!$M$10","v":"All stop"},{"$f":"'Input Ramp Terminals'!$M$9","v":0},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$N$9,\"\")","v":""}]
[null,null,null,"   Total single-vehicle crashes:",null,null,0.64474833011627197,8.0006371717900038E-4,1.6267962753772736E-2,8.7740316987037659E-2,0.16187955439090729,0.37806040048599243,null,{"$f":"N62+1","v":5},{"$f":"'Input Ramp Terminals'!$O$8","v":0},{"$f":"'Input Ramp Terminals'!$O$10","v":"One stop"},{"$f":" 'Input Ramp Terminals'!$O$9","v":0},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$P$9, \"\")","v":""}]
[null,null,null,null,"Total crashes:",null,13.503683090209961,1.1429481208324432E-2,0.23239944875240326,1.2534331083297729,2.3125650882720947,9.6938562393188477,null,{"$f":"N63+1","v":6},{"$f":"'Input Ramp Terminals'!$Q$8","v":0},{"$f":"'Input Ramp Terminals'!$Q$10","v":"Signal"},{"$f":" 'Input Ramp Terminals'!$Q$9","v":0},null,null,null,{"$f":"IF(Main!$AK$14=TRUE,  'Input Ramp Terminals'!$R$9, \"\")","v":""}]

{"sheet":"Output Ramp Terminals","index":5,"n_rows":756,"n_cols":18,"rows_kept":756,"cut":false,"hidden":false,"merged":[[561,4,561,5],[557,4,557,5],[558,4,558,5],[559,4,559,5],[560,4,560,5],[4,17,5,17],[553,4,554,5],[555,4,555,5],[556,4,556,5],[4,13,5,13],[4,14,5,14],[4,15,5,15],[4,16,5,16],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,4,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[]
[]
[null,null,null,null,"Output Worksheet for Crossroad Ramp Terminals"]
[null,"   Signal = signalized intersection model",null,null,null,null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 1"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 2"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 3"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 4"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 5"},null,{"$f":"\"Terminal \"& TEXT(INT((COLUMN()-5)/2),\"0\")","v":"Terminal 6"}]
[null,"   Unsig = unsignalized intersection model",null,null,"Applicable Models",null,{"$f":"IF(Main!$AK$14=TRUE, \"Crash Period\", \"Study Period\")","v":"Study Period"},{"$f":"IF(Main!$AK$14=TRUE, \"Study Period\", \"\")","v":""},{"$f":"G5","v":"Study Period"},"","Study Period","","Study Period","","Study Period","","Study Period",""]
[]
[null,"Crash Modification Factors"]
[null,"Fatal-and-Injury Crash CMFs"]
[null,"Non-ramp public street leg (CMF19,w,SG,at,fi):",null,null,"Signal"]
[null,"Segment length (CMF14,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,"Protected left-turn operation (CMF16,w,SG,at,fi):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F12+1","v":2016}]
[null,null,null,null,null,{"$f":"F13+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Channelized right turn on crossroad (CMF17,w,SG,at,fi):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F37+1","v":2016}]
[null,null,null,null,null,{"$f":"F38+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Channelized right turn on exit ramp (CMF18,w,SG,at,fi):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F62+1","v":2016}]
[null,null,null,null,null,{"$f":"F63+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Access point frequency (CMF13,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F87+1","v":2016}]
[null,null,null,null,null,{"$f":"F88+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Crossroad left-turn lane (CMF11,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F112+1","v":2016}]
[null,null,null,null,null,{"$f":"F113+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Crossroad right-turn lane (CMF12,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F137+1","v":2016}]
[null,null,null,null,null,{"$f":"F138+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Median width (CMF15,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F162+1","v":2016}]
[null,null,null,null,null,{"$f":"F163+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Exit ramp capacity (CMF10,w,x,at,fi):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F187+1","v":2016}]
[null,null,null,null,null,{"$f":"F188+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Skew angle (CMF20,w,ST,at,fi):",null,null,null,"Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F212+1","v":2016}]
[null,null,null,null,null,{"$f":"F213+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"All-way stop control (CMFawsc):",null,null,null,"Unsig"]
[null,"Property-Damage-Only Crash CMFs"]
[null,"Non-ramp public street leg (CMF19,w,SG,at,pdo):",null,null,"Signal"]
[null,"Segment length (CMF14,w,x,at,pdo):",null,null,"Signal"]
[null,"Protected left-turn operation (CMF16,w,SG,at,pdo):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F241+1","v":2016}]
[null,null,null,null,null,{"$f":"F242+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Channelized right turn on crossroad (CMF17,w,SG,at,pdo):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F266+1","v":2016}]
[null,null,null,null,null,{"$f":"F267+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Channelized right turn on exit ramp (CMF18,w,SG,at,pdo):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F291+1","v":2016}]
[null,null,null,null,null,{"$f":"F292+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Access point frequency (CMF13,w,x,at,pdo):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F316+1","v":2016}]
[null,null,null,null,null,{"$f":"F317+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Crossroad left-turn lane (CMF11,w,x,at,pdo):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F341+1","v":2016}]
[null,null,null,null,null,{"$f":"F342+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Crossroad right-turn lane (CMF12,w,x,at,pdo):",null,null,"Signal","Unsig"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F366+1","v":2016}]
[null,null,null,null,null,{"$f":"F367+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Median width (CMF15,w,x,at,pdo):",null,null,"Signal"]
[null,null,null,null,"Year:",{"$f":"Main!$AK$5","v":2015}]
[null,null,null,null,null,{"$f":"F391+1","v":2016}]
[null,null,null,null,null,{"$f":"F392+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,{"$f":"IF(Main!$AK$14=TRUE, \"Expected Average Crash Frequency\", \"Predicted Average Crash Frequency\")","v":"Predicted Average Crash Frequency"}]
[null,"Fatal-and-Injury Crash Frequency"]
[null,"Ramp Terminal Crash Analysis",null,null,null,"Year"]
[null,"Overdispersion parameter (kw,x,at,fi):"]
[null,"Observed crash count (N*o,w,x,at,fi), crashes:"]
[null,"Reference year (r):"]
[null,"Predicted average crash freq. for reference year (Np,w,x,at,fi,r), crashes/yr:"]
[null,"Equivalent years associated with crash count (Cb,w,x,at,fi,r), yr:"]
[null,"Expected average crash freq. for reference year given N*o (Na,w,x,at,fi,r), crashes/yr:"]
[null,{"$f":"IF(Main!$AK$14=TRUE, \"Expected average crash frequency\", \"Predicted average crash frequency\")","v":"Predicted average crash frequency"},null,null,null,{"$f":"Main!$AK$5","v":2015},3.8098270893096924]
[null,"  (Ne,w,x,at,fi), crashes/yr:","(Np,w,x,at,fi), crashes/yr:",null,null,{"$f":"F424+1","v":2016}]
[null,null,null,null,null,{"$f":"F425+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Project Level Crash Analysis",null,null,null,"Year","Project"]
[null,"Observed crash count (N*o,aS,ac,at,fi), crashes:"]
[null,"Reference year (r):"]
[null,"Predicted average crash freq. for reference year (Np,aS,ac,at,fi,r), crashes/yr:"]
[null,"Equivalent years associated with crash count (Cb,aS,ac,at,fi,r), yr:"]
[null,"Independent sites crash analysis"]
[null,"   Variance when site crash frequencies are independent (V0,aS,ac,at,fi):"]
[null,"   Weight associated with Np,...r (w0,aS,ac,at,fi):"]
[null,"   Expected average crash freq. for reference year given N*o (N0,aS,ac,at,fi,r), crashes/yr:"]
[null,"Correlated sites crash analysis"]
[null,"   Variance when site crash frequencies are correlated (V1,aS,ac,at,fi):"]
[null,"   Weight associated with Np,...r (w1,aS,ac,at,fi):"]
[null,"   Expected average crash freq. for reference year given N*o (N1,aS,ac,at,fi,r), crashes/yr:"]
[null,"Expected average crash frequency",null,null,null,{"$f":"F424","v":2015}]
[null,"  (Ne,aS,ac,at,fi), crashes/year:",null,null,null,{"$f":"F425","v":2016}]
[null,null,null,null,null,2017]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Property-Damage-Only Crash Frequency"]
[null,"Ramp Terminal Crash Analysis",null,null,null,"Year"]
[null,"Overdispersion parameter (kw,x,at,pdo):"]
[null,"Observed crash count (N*o,w,x,at,pdo), crashes:"]
[null,"Reference year (r):"]
[null,"Predicted average crash freq. for reference year (Np,w,x,at,pdo,r), crashes/yr:"]
[null,"Equivalent years associated with crash count (Cb,w,x,at,pdo,r), yr:"]
[null,"Expected average crash freq. for reference year given N*o (Na,w,x,at,pdo,r), crashes/yr:"]
[null,{"$f":"IF(Main!$AK$14=TRUE, \"Expected average crash frequency\", \"Predicted average crash frequency\")","v":"Predicted average crash frequency"},null,null,null,{"$f":"Main!$AK$5","v":2015},9.6938562393188477]
[null,"  (Ne,w,x,at,pdo), crashes/yr:","(Np,w,x,at,pdo), crashes/yr:",null,null,{"$f":"F493+1","v":2016}]
[null,null,null,null,null,{"$f":"F494+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Project Level Crash Analysis",null,null,null,"Year","Project"]
[null,"Observed crash count (N*o,aS,ac,at,pdo), crashes:"]
[null,"Reference year (r):"]
[null,"Predicted average crash freq. for reference year (Np,aS,ac,at,pdo,r), crashes/yr:"]
[null,"Equivalent years associated with crash count (Cb,aS,ac,at,pdo,r), yr:"]
[null,"Independent sites crash analysis"]
[null,"   Variance when site crash frequencies are independent (V0,aS,ac,at,pdo):"]
[null,"   Weight associated with Np,...r (w0,aS,ac,at,pdo):"]
[null,"   Expected average crash freq. for reference year given N*o (N0,aS,ac,at,pdo,r), crashes/yr:"]
[null,"Correlated sites crash analysis"]
[null,"   Variance when site crash frequencies are correlated (V1,aS,ac,at,pdo):"]
[null,"   Weight associated with Np,...r (w1,aS,ac,at,pdo):"]
[null,"   Expected average crash freq. for reference year given N*o (N1,aS,ac,at,pdo,r), crashes/yr:"]
[null,"Expected average crash frequency",null,null,null,{"$f":"F493","v":2015}]
[null,"  (Ne,aS,ac,at,pdo), crashes/year:",null,null,null,{"$f":"F494","v":2016}]
[null,null,null,null,null,2017]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Crash Severity Distribution",null,null,{"$f":"IF(Main!$AK$15=TRUE, \"Project Study Period\", \"\")","v":""}]
[null," (during Study Period)"]
[null,"Fatal crash frequency (N*e,w,x,at,K), crashes:",null,null,null,null,1.1429481208324432E-2]
[null,"Incapacitating injury crash freq. (N*e,w,x,at,A), crashes:",null,null,null,null,0.23239944875240326]
[null,"Non-incapacitating inj. crash freq. (N*e,w,x,at,B), crashes:",null,null,null,null,1.2534331083297729]
[null,"Possible injury crash freq. (N*e,w,x,at,C), crashes:",null,null,null,null,2.3125650882720947]
[null,"  Total fatal-and-injury crash freq. (N*e,w,x,at,fi), crashes:",null,null,null,null,3.8098270893096924]
[null,"Property-damage-only crash freq. (N*e,w,x,at,pdo), crashes:",null,null,null,null,9.6938562393188477]
[null,"  Total crash frequency (N*e,w,x,at,as), crashes:",null,null,null,null,13.503683090209961]
[null,"Intermediate Results",null,null,null,"Year"]
[null,"Proportion of total leg AADT on the crossroad (Pxrd):",null,null,null,{"$f":"Main!$AK$5","v":2015},0.76970446109771729]
[null,null,null,null,null,{"$f":"F564+1","v":2016}]
[null,null,null,null,null,{"$f":"F565+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Proportion of total leg AADT on the inside crossroad leg (Pin):",null,null,null,{"$f":"Main!$AK$5","v":2015},0.38485223054885864]
[null,null,null,null,null,{"$f":"F588+1","v":2016}]
[null,null,null,null,null,{"$f":"F589+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Proportion of total leg AADT on the outside crossroad leg (Pout):",null,null,null,{"$f":"Main!$AK$5","v":2015},0.38485223054885864]
[null,null,null,null,null,{"$f":"F612+1","v":2016}]
[null,null,null,null,null,{"$f":"F613+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Proportion of total leg AADT on the exit ramp leg (Pex):",null,null,null,{"$f":"Main!$AK$5","v":2015},0.12931033968925476]
[null,null,null,null,null,{"$f":"F636+1","v":2016}]
[null,null,null,null,null,{"$f":"F637+1","v":2017}]
[null,null,null,null,null,2018]
[null,null,null,null,null,2019]
[null,null,null,null,null,2020]
[null,null,null,null,null,2021]
[null,null,null,null,null,2022]
[null,null,null,null,null,2023]
[null,null,null,null,null,2024]
[null,null,null,null,null,2025]
[null,null,null,null,null,2026]
[null,null,null,null,null,2027]
[null,null,null,null,null,2028]
[null,null,null,null,null,2029]
[null,null,null,null,null,2030]
[null,null,null,null,null,2031]
[null,null,null,null,null,2032]
[null,null,null,null,null,2033]
[null,null,null,null,null,2034]
[null,null,null,null,null,2035]
[null,null,null,null,null,2036]
[null,null,null,null,null,2037]
[null,null,null,null,null,2038]
[null,"Traffic Data",null,null,null,"Year"]
[null,"Inside Crossroad Leg Data ",null,null,null,{"$f":"Main!$AK$5","v":2015},31250]
[null,"Average daily traffic (AADTin) by year, veh/d:",null,null,null,{"$f":"F661+1","v":2016},31250]
[null,null,null,null,null,{"$f":"F662+1","v":2017},31250]
[null,null,null,null,null,2018,31250]
[null,null,null,null,null,2019,31250]
[null,null,null,null,null,2020,31250]
[null,null,null,null,null,2021,31250]
[null,null,null,null,null,2022,31250]
[null,null,null,null,null,2023,31250]
[null,null,null,null,null,2024,31250]
[null,null,null,null,null,2025,31250]
[null,null,null,null,null,2026,31250]
[null,null,null,null,null,2027,31250]
[null,null,null,null,null,2028,31250]
[null,null,null,null,null,2029,31250]
[null,null,null,null,null,2030,31250]
[null,null,null,null,null,2031,31250]
[null,null,null,null,null,2032,31250]
[null,null,null,null,null,2033,31250]
[null,null,null,null,null,2034,31250]
[null,null,null,null,null,2035,31250]
[null,null,null,null,null,2036,31250]
[null,null,null,null,null,2037,31250]
[null,null,null,null,null,2038,31250]
[null,"Outside Crossroad Leg Data ",null,null,null,{"$f":"Main!$AK$5","v":2015},31250]
[null,"Average daily traffic (AADTout) by year, veh/d:",null,null,null,{"$f":"F685+1","v":2016},31250]
[null,null,null,null,null,{"$f":"F686+1","v":2017},31250]
[null,null,null,null,null,2018,31250]
[null,null,null,null,null,2019,31250]
[null,null,null,null,null,2020,31250]
[null,null,null,null,null,2021,31250]
[null,null,null,null,null,2022,31250]
[null,null,null,null,null,2023,31250]
[null,null,null,null,null,2024,31250]
[null,null,null,null,null,2025,31250]
[null,null,null,null,null,2026,31250]
[null,null,null,null,null,2027,31250]
[null,null,null,null,null,2028,31250]
[null,null,null,null,null,2029,31250]
[null,null,null,null,null,2030,31250]
[null,null,null,null,null,2031,31250]
[null,null,null,null,null,2032,31250]
[null,null,null,null,null,2033,31250]
[null,null,null,null,null,2034,31250]
[null,null,null,null,null,2035,31250]
[null,null,null,null,null,2036,31250]
[null,null,null,null,null,2037,31250]
[null,null,null,null,null,2038,31250]
[null,"Exit Ramp Data ",null,null,null,{"$f":"Main!$AK$5","v":2015},10500]
[null,"Average daily traffic (AADTex) by year, veh/d:",null,null,null,{"$f":"F709+1","v":2016},10500]
[null,null,null,null,null,{"$f":"F710+1","v":2017},10500]
[null,null,null,null,null,2018,10500]
[null,null,null,null,null,2019,10500]
[null,null,null,null,null,2020,10500]
[null,null,null,null,null,2021,10500]
[null,null,null,null,null,2022,10500]
[null,null,null,null,null,2023,10500]
[null,null,null,null,null,2024,10500]
[null,null,null,null,null,2025,10500]
[null,null,null,null,null,2026,10500]
[null,null,null,null,null,2027,10500]
[null,null,null,null,null,2028,10500]
[null,null,null,null,null,2029,10500]
[null,null,null,null,null,2030,10500]
[null,null,null,null,null,2031,10500]
[null,null,null,null,null,2032,10500]
[null,null,null,null,null,2033,10500]
[null,null,null,null,null,2034,10500]
[null,null,null,null,null,2035,10500]
[null,null,null,null,null,2036,10500]
[null,null,null,null,null,2037,10500]
[null,null,null,null,null,2038,10500]
[null,"Entrance Ramp Data ",null,null,null,{"$f":"Main!$AK$5","v":2015},8200]
[null,"Average daily traffic (AADTen) by year, veh/d:",null,null,null,{"$f":"F733+1","v":2016},8200]
[null,null,null,null,null,{"$f":"F734+1","v":2017},8200]
[null,null,null,null,null,2018,8200]
[null,null,null,null,null,2019,8200]
[null,null,null,null,null,2020,8200]
[null,null,null,null,null,2021,8200]
[null,null,null,null,null,2022,8200]
[null,null,null,null,null,2023,8200]
[null,null,null,null,null,2024,8200]
[null,null,null,null,null,2025,8200]
[null,null,null,null,null,2026,8200]
[null,null,null,null,null,2027,8200]
[null,null,null,null,null,2028,8200]
[null,null,null,null,null,2029,8200]
[null,null,null,null,null,2030,8200]
[null,null,null,null,null,2031,8200]
[null,null,null,null,null,2032,8200]
[null,null,null,null,null,2033,8200]
[null,null,null,null,null,2034,8200]
[null,null,null,null,null,2035,8200]
[null,null,null,null,null,2036,8200]
[null,null,null,null,null,2037,8200]
[null,null,null,null,null,2038,8200]

{"sheet":"Calibration Factors","index":6,"n_rows":283,"n_cols":18,"rows_kept":283,"cut":false,"hidden":false,"merged":[[2,1,2,13],[121,1,122,2],[121,3,122,3],[121,4,122,5],[121,6,122,7],[121,8,122,8],[4,12,5,12],[4,3,5,3],[4,13,5,13],[4,6,5,7],[4,4,5,5],[121,9,122,9],[121,10,122,10],[121,11,122,11],[121,12,122,12],[121,13,122,13],[4,1,5,2],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[241,16,241,17],[240,8,240,17],[277,1,277,2],[241,14,241,15],[270,1,270,2],[240,1,242,2],[240,3,242,4],[240,5,242,7],[241,8,241,9],[241,10,241,11],[241,12,241,13]]}
[]
[]
[null,"Ramp Terminal Model Calibration Factors and Default Values"]
[null,"Ramp Terminal Fatal-and-Injury Crash Frequency Models",null,null,null,null,null,"Model: exp(a + b ln[c AADTin/2 + c AADTout/2] + d ln[c AADTex + c AADTen])"]
[null,"Area Type",null,"Terminal Config.","Control Type",null,"Through Lanes",null,"a","b","c","d","Inverse Disp. (K)","Calib. Factor (C)"]
[]
[null,"Rural",null,"D3ex","One-way stop",null,null,2,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N7","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N8","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-1.672+0.16*H10","v":-1.3519999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-1.672+0.16*H11","v":-1.1919999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N10","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-1.672+0.16*H12","v":-1.032},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N11","v":1.1000000000000001}]
[null,null,null,"D3en","One-way stop",null,null,2,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N7","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N8","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.388+0.16*H16","v":-2.0680000000000001},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.388+0.16*H17","v":-1.9079999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.388+0.16*H18","v":-1.7479999999999998},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,"D4","One-way stop",null,null,2,{"$f":"-3.064+0.324","v":-2.74},1.008,1E-3,0.17699999999999999,2.58,{"$f":"N13","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.064+0.324","v":-2.74},1.008,1E-3,0.17699999999999999,2.58,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.064+0.324","v":-2.74},1.008,1E-3,0.17699999999999999,2.58,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.975+0.16*H22","v":-2.6550000000000002},1.1910000000000001,1E-3,0.13100000000000001,11.5,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.975+0.16*H23","v":-2.4950000000000001},1.1910000000000001,1E-3,0.13100000000000001,11.5,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.975+0.16*H24","v":-2.335},1.1910000000000001,1E-3,0.13100000000000001,11.5,1.1000000000000001]
[null,null,null,"A4","One-way stop",null,null,2,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N19","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.223+0.324","v":-2.899},0.58199999999999996,1E-3,0.89900000000000002,2.16,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-1.672+0.16*H28","v":-1.3519999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-1.672+0.16*H29","v":-1.1919999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-1.672+0.16*H30","v":-1.032},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,"B4","One-way stop",null,null,2,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N25","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.141+0.324","v":-2.8170000000000002},0.70899999999999996,1E-3,0.73,0.91800000000000004,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.388+0.16*H34","v":-2.0680000000000001},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.388+0.16*H35","v":-1.9079999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.388+0.16*H36","v":-1.7479999999999998},0.26500000000000001,1E-3,0.90500000000000003,5.37,1.1000000000000001]
[null,null,null,"A2","One-way stop",null,null,2,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N31","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-0.778+0.16*H40","v":-0.45800000000000002},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-0.778+0.16*H41","v":-0.29800000000000004},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-0.778+0.16*H42","v":-0.13800000000000001},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,null,null,"B2","One-way stop",null,null,2,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N37","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.687+0.324","v":-2.363},0.26,1E-3,0.94699999999999995,3.4,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-0.778+0.16*H46","v":-0.45800000000000002},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-0.778+0.16*H47","v":-0.29800000000000004},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-0.778+0.16*H48","v":-0.13800000000000001},0.32500000000000001,1E-3,0.21199999999999999,2.17,1.1000000000000001]
[null,"Urban",null,"D3ex","One-way stop",null,null,2,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N7","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N49","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-1.672+0.16*H52","v":-1.3519999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N10","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-1.672+0.16*H53","v":-1.1919999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-1.672+0.16*H54","v":-1.032},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,5,{"$f":"-1.672+0.16*H55","v":-0.87199999999999989},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,null,null,null,null,6,{"$f":"-1.672+0.16*H56","v":-0.71199999999999997},0.379,1E-3,0.39400000000000002,8.7200000000000006,1.1000000000000001]
[null,null,null,"D3en","One-way stop",null,null,2,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N49","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N50","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N51","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.388+0.16*H60","v":-2.0680000000000001},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N52","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.388+0.16*H61","v":-1.9079999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N60","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.388+0.16*H62","v":-1.7479999999999998},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N61","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.388+0.16*H63","v":-1.5879999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N62","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.388+0.16*H64","v":-1.4279999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N63","v":1.1000000000000001}]
[null,null,null,"D4","One-way stop",null,null,2,{"$f":"-3.064+0","v":-3.0640000000000001},1.008,1E-3,0.17699999999999999,2.58,{"$f":"N57","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.064+0","v":-3.0640000000000001},1.008,1E-3,0.17699999999999999,2.58,{"$f":"N58","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.064+0","v":-3.0640000000000001},1.008,1E-3,0.17699999999999999,2.58,{"$f":"N59","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.975+0.16*H68","v":-2.6550000000000002},1.1910000000000001,1E-3,0.13100000000000001,11.5,{"$f":"N60","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.975+0.16*H69","v":-2.4950000000000001},1.1910000000000001,1E-3,0.13100000000000001,11.5,{"$f":"N68","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.975+0.16*H70","v":-2.335},1.1910000000000001,1E-3,0.13100000000000001,11.5,{"$f":"N69","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.975+0.16*H71","v":-2.1749999999999998},1.1910000000000001,1E-3,0.13100000000000001,11.5,{"$f":"N70","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.975+0.16*H72","v":-2.0150000000000001},1.1910000000000001,1E-3,0.13100000000000001,11.5,{"$f":"N71","v":1.1000000000000001}]
[null,null,null,"A4","One-way stop",null,null,2,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N65","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N66","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.223+0","v":-3.2229999999999999},0.58199999999999996,1E-3,0.89900000000000002,2.16,{"$f":"N67","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-1.672+0.16*H76","v":-1.3519999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N68","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-1.672+0.16*H77","v":-1.1919999999999999},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N76","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-1.672+0.16*H78","v":-1.032},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N77","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-1.672+0.16*H79","v":-0.87199999999999989},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N78","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-1.672+0.16*H80","v":-0.71199999999999997},0.379,1E-3,0.39400000000000002,8.7200000000000006,{"$f":"N79","v":1.1000000000000001}]
[null,null,null,"B4","One-way stop",null,null,2,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N73","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N74","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.141+0","v":-3.141},0.70899999999999996,1E-3,0.73,0.91800000000000004,{"$f":"N75","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.388+0.16*H84","v":-2.0680000000000001},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N76","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.388+0.16*H85","v":-1.9079999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N84","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.388+0.16*H86","v":-1.7479999999999998},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N85","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.388+0.16*H87","v":-1.5879999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N86","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.388+0.16*H88","v":-1.4279999999999999},0.26500000000000001,1E-3,0.90500000000000003,5.37,{"$f":"N87","v":1.1000000000000001}]
[null,null,null,"A2","One-way stop",null,null,2,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N81","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N82","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N83","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-0.778+0.16*H92","v":-0.45800000000000002},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N84","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-0.778+0.16*H93","v":-0.29800000000000004},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N92","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-0.778+0.16*H94","v":-0.13800000000000001},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N93","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-0.778+0.16*H95","v":2.200000000000002E-2},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N94","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-0.778+0.16*H96","v":0.18199999999999994},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N95","v":1.1000000000000001}]
[null,null,null,"B2","One-way stop",null,null,2,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N89","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N90","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.687+0","v":-2.6869999999999998},0.26,1E-3,0.94699999999999995,3.4,{"$f":"N91","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-0.778+0.16*H100","v":-0.45800000000000002},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N92","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-0.778+0.16*H101","v":-0.29800000000000004},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N100","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-0.778+0.16*H102","v":-0.13800000000000001},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N101","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-0.778+0.16*H103","v":2.200000000000002E-2},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N102","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-0.778+0.16*H104","v":0.18199999999999994},0.32500000000000001,1E-3,0.21199999999999999,2.17,{"$f":"N103","v":1.1000000000000001}]
[null,null,null,"SPUI","One-way stop",null,null,0,-16.71,0.88,0.88,null,9.09,{"$f":"N97","v":1.1000000000000001}]
[null,null,null,null,null,null,null,1,-17.29,0.88,0.88,null,9.09,{"$f":"N98","v":1.1000000000000001}]
[null,null,null,null,null,null,null,2,-17.87,0.88,0.88,null,9.09,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,0,-16.71,0.88,0.88,null,9.09,{"$f":"N100","v":1.1000000000000001}]
[null,null,null,null,null,null,null,1,-17.29,0.88,0.88,null,9.09,{"$f":"N101","v":1.1000000000000001}]
[null,null,null,null,null,null,null,2,-17.87,0.88,0.88,null,9.09,1.1000000000000001]
[null,null,null,null,null,null,null,5,-16.71,0.88,0.88,-0.57999999999999996,9.09,1.1000000000000001]
[null,null,null,null,null,null,null,6,-16.71,0.88,0.88,-0.57999999999999996,9.09,1.1000000000000001]
[null,null,null,"TDI","One-way stop",null,null,2,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,3,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,4,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,3,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,4,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,5,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,6,-11.9,0.5,0.81,null,4.3499999999999996,1.1000000000000001]
[null,"Ramp Terminal Property-Damage-Only Crash Freq. Models",null,null,null,null,null,"Model: exp(a + b ln[c AADTin/2 + c AADTout/2] + d ln[c AADTex + c AADTen])"]
[null,"Area Type",null,"Terminal Config.","Control Type",null,"Through Lanes",null,"a","b","c","d","Inverse Disp. (K)","Calib. Factor (C)"]
[]
[null,"Rural",null,"D3ex","One-way stop",null,null,2,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N124","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N125","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.755+0.0879*H127+0.332","v":-2.2471999999999999},0.79700000000000004,1E-3,0.38400000000000001,4.05,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.755+0.0879*H128+0.332","v":-2.1593},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N127","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.755+0.0879*H129+0.332","v":-2.0714000000000001},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N128","v":1.1000000000000001}]
[null,null,null,"D3en","One-way stop",null,null,2,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N124","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N125","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.543+0.0879*H133+0.436","v":-2.9312},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-3.543+0.0879*H134+0.436","v":-2.8433000000000002},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.543+0.0879*H135+0.436","v":-2.7554000000000003},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,"D4","One-way stop",null,null,2,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,{"$f":"N130","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.058+0.0879*H139+0.634","v":-2.2481999999999998},0.879,1E-3,0.54500000000000004,7.21,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-3.058+0.0879*H140+0.634","v":-2.1602999999999999},0.879,1E-3,0.54500000000000004,7.21,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.058+0.0879*H141+0.634","v":-2.0724},0.879,1E-3,0.54500000000000004,7.21,1.1000000000000001]
[null,null,null,"A4","One-way stop",null,null,2,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N136","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.755+0.0879*H145+0.332","v":-2.2471999999999999},0.79700000000000004,1E-3,0.38400000000000001,4.05,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.755+0.0879*H146+0.332","v":-2.1593},0.79700000000000004,1E-3,0.38400000000000001,4.05,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.755+0.0879*H147+0.332","v":-2.0714000000000001},0.79700000000000004,1E-3,0.38400000000000001,4.05,1.1000000000000001]
[null,null,null,"B4","One-way stop",null,null,2,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N142","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.543+0.0879*H151+0.436","v":-2.9312},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-3.543+0.0879*H152+0.436","v":-2.8433000000000002},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.543+0.0879*H153+0.436","v":-2.7554000000000003},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},1.1000000000000001]
[null,null,null,"A2","One-way stop",null,null,2,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N148","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.309+0.0879*H157+0.596","v":-1.5371999999999999},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.309+0.0879*H158+0.596","v":-1.4493},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.309+0.0879*H159+0.596","v":-1.3614000000000002},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,null,null,"B2","One-way stop",null,null,2,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N154","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.309+0.0879*H163+0.596","v":-1.5371999999999999},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,3,{"$f":"-2.309+0.0879*H164+0.596","v":-1.4493},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,null,null,null,null,null,null,4,{"$f":"-2.309+0.0879*H165+0.596","v":-1.3614000000000002},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,1.1000000000000001]
[null,"Urban",null,"D3ex","One-way stop",null,null,2,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N124","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N166","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N167","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.755+0.0879*H169+0.332","v":-2.2471999999999999},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N127","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.755+0.0879*H170+0.332","v":-2.1593},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N169","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.755+0.0879*H171+0.332","v":-2.0714000000000001},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N170","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.755+0.0879*H172+0.332","v":-1.9835},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N171","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.755+0.0879*H173+0.332","v":-1.8955999999999997},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N172","v":1.1000000000000001}]
[null,null,null,"D3en","One-way stop",null,null,2,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N166","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N167","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N168","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.543+0.0879*H177+0.436","v":-2.9312},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N169","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.543+0.0879*H178+0.436","v":-2.8433000000000002},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N177","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.543+0.0879*H179+0.436","v":-2.7554000000000003},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N178","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-3.543+0.0879*H180+0.436","v":-2.6675000000000004},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N179","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-3.543+0.0879*H181+0.436","v":-2.5796000000000001},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N180","v":1.1000000000000001}]
[null,null,null,"D4","One-way stop",null,null,2,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,{"$f":"N174","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,{"$f":"N175","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.953+0.521","v":-2.4319999999999999},0.84499999999999997,1E-3,0.47599999999999998,4.2699999999999996,{"$f":"N176","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.058+0.0879*H185+0.634","v":-2.2481999999999998},0.879,1E-3,0.54500000000000004,7.21,{"$f":"N177","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.058+0.0879*H186+0.634","v":-2.1602999999999999},0.879,1E-3,0.54500000000000004,7.21,{"$f":"N185","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.058+0.0879*H187+0.634","v":-2.0724},0.879,1E-3,0.54500000000000004,7.21,{"$f":"N186","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-3.058+0.0879*H188+0.634","v":-1.9845000000000002},0.879,1E-3,0.54500000000000004,7.21,{"$f":"N187","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-3.058+0.0879*H189+0.634","v":-1.8965999999999998},0.879,1E-3,0.54500000000000004,7.21,{"$f":"N188","v":1.1000000000000001}]
[null,null,null,"A4","One-way stop",null,null,2,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N182","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N183","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.164+0.494","v":-2.67},0.59499999999999997,1E-3,0.93700000000000006,6.57,{"$f":"N184","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.755+0.0879*H193+0.332","v":-2.2471999999999999},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N185","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.755+0.0879*H194+0.332","v":-2.1593},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N193","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.755+0.0879*H195+0.332","v":-2.0714000000000001},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N194","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.755+0.0879*H196+0.332","v":-1.9835},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N195","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.755+0.0879*H197+0.332","v":-1.8955999999999997},0.79700000000000004,1E-3,0.38400000000000001,4.05,{"$f":"N196","v":1.1000000000000001}]
[null,null,null,"B4","One-way stop",null,null,2,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N190","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N191","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.961+0.603","v":-2.3579999999999997},0.88500000000000001,1E-3,0.35,3.9,{"$f":"N192","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-3.543+0.0879*H201+0.436","v":-2.9312},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N193","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.543+0.0879*H202+0.436","v":-2.8433000000000002},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N201","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.543+0.0879*H203+0.436","v":-2.7554000000000003},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N202","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-3.543+0.0879*H204+0.436","v":-2.6675000000000004},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N203","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-3.543+0.0879*H205+0.436","v":-2.5796000000000001},0.74099999999999999,1E-3,0.84499999999999997,{"$f":"1/0.269","v":3.7174721189591078},{"$f":"N204","v":1.1000000000000001}]
[null,null,null,"A2","One-way stop",null,null,2,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N198","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N199","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N200","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.309+0.0879*H209+0.596","v":-1.5371999999999999},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N201","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.309+0.0879*H210+0.596","v":-1.4493},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N209","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.309+0.0879*H211+0.596","v":-1.3614000000000002},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N210","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.309+0.0879*H212+0.596","v":-1.2735000000000003},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N211","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.309+0.0879*H213+0.596","v":-1.1856},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N212","v":1.1000000000000001}]
[null,null,null,"B2","One-way stop",null,null,2,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N206","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N207","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-3.595+0.54","v":-3.0550000000000002},0.77300000000000002,1E-3,0.878,5.49,{"$f":"N208","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,2,{"$f":"-2.309+0.0879*H217+0.596","v":-1.5371999999999999},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N209","v":1.1000000000000001}]
[null,null,null,null,null,null,null,3,{"$f":"-2.309+0.0879*H218+0.596","v":-1.4493},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N217","v":1.1000000000000001}]
[null,null,null,null,null,null,null,4,{"$f":"-2.309+0.0879*H219+0.596","v":-1.3614000000000002},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N218","v":1.1000000000000001}]
[null,null,null,null,null,null,null,5,{"$f":"-2.309+0.0879*H220+0.596","v":-1.2735000000000003},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N219","v":1.1000000000000001}]
[null,null,null,null,null,null,null,6,{"$f":"-2.309+0.0879*H221+0.596","v":-1.1856},0.59199999999999997,1E-3,0.51600000000000001,4.2699999999999996,{"$f":"N220","v":1.1000000000000001}]
[null,null,null,"SPUI","One-way stop",null,null,0,-15.6,0.61,1.1499999999999999,null,10,{"$f":"N214","v":1.1000000000000001}]
[null,null,null,null,null,null,null,1,-16.2,0.61,1.1499999999999999,null,10,{"$f":"N215","v":1.1000000000000001}]
[null,null,null,null,null,null,null,2,-16.8,0.61,1.1499999999999999,null,10,{"$f":"N216","v":1.1000000000000001}]
[null,null,null,null,"Signalized",null,null,0,-15.6,0.61,1.1499999999999999,null,10,{"$f":"N217","v":1.1000000000000001}]
[null,null,null,null,null,null,null,1,-16.2,0.61,1.1499999999999999,null,10,{"$f":"N218","v":1.1000000000000001}]
[null,null,null,null,null,null,null,2,-16.8,0.61,1.1499999999999999,null,10,1.1000000000000001]
[null,null,null,null,null,null,null,5,-15.6,0.61,1.1499999999999999,-0.6,10,1.1000000000000001]
[null,null,null,null,null,null,null,6,-15.6,0.61,1.1499999999999999,-0.6,10,1.1000000000000001]
[null,null,null,"TDI","One-way stop",null,null,2,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,3,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,4,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,"Signalized",null,null,2,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,3,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,4,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,5,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,null,null,null,null,null,null,6,-11.99,0.77,0.63,null,3.45,1.1000000000000001]
[null,"Ramp Terminal Crash Severity Model"]
[null,null,"Calibration factor for signal-controlled terminals:",null,null,null,null,1,"Calibration factor for one-way stop-controlled terminals:",null,null,null,null,1]
[null,"Ramp Terminal Crash Distribution"]
[null,"Area Type",null,"Crash Type",null,"Crash Type Category",null,null,"Proportion of Crashes by Severity Level for Specific Models"]
[null,null,null,null,null,null,null,null,"Signalized",null,"One-Way Stop",null,"All-Way Stop",null,"SPUI",null,"TDI"]
[null,null,null,null,null,null,null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
[null,"Rural",null,"Multiple vehicle",null,"Head-on",null,null,0,6.0000000000000001E-3,0.02,1.4999999999999999E-2,0,0,3.4000000000000002E-2,6.0000000000000001E-3]
[null,null,null,null,null,"Right-angle",null,null,0.33300000000000002,0.187,0.52200000000000002,0.372,0.5,0.375,0.129,0.08]
[null,null,null,null,null,"Rear-end",null,null,0.55200000000000005,0.46600000000000003,0.27500000000000002,0.27600000000000002,0.5,0.40500000000000003,0.66200000000000003,0.74399999999999999]
[null,null,null,null,null,"Sideswipe",null,null,0,0.219,0.02,0.107,0,9.4E-2,0.04,0.112]
[null,null,null,null,null,"Other multiple-vehicle crash",null,null,1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2,2.5999999999999999E-2,0,0,1.0999999999999999E-2,6.0000000000000001E-3]
[]
[null,null,null,"Single vehicle",null,"Crash with animal",null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Crash with fixed object",null,null,4.2999999999999997E-2,7.6999999999999999E-2,7.8E-2,0.158,0,6.3E-2,4.5999999999999999E-2,4.5999999999999999E-2]
[null,null,null,null,null,"Crash with other object",null,null,0,0,0,5.0000000000000001E-3,0,0,2E-3,1E-3]
[null,null,null,null,null,"Crash with parked vehicle",null,null,0,1.2999999999999999E-2,7.0000000000000001E-3,1.4999999999999999E-2,0,0,0,0]
[null,null,null,null,null,"Other single-vehicle crash",null,null,5.8000000000000003E-2,1.9E-2,6.5000000000000002E-2,2.5999999999999999E-2,0,6.3E-2,7.5999999999999998E-2,5.0000000000000001E-3]
[]
[null,null,null,null,null,null,null,"Total:",{"$f":"SUM(I250:I254)+SUM(I244:I248)","v":1},1,1,1,1,1,{"$f":"SUM(O250:O254)+SUM(O244:O248)","v":1},1,{"$f":"SUM(Q250:Q254)+SUM(Q244:Q248)","v":0},0]
[null,"Urban",null,"Multiple vehicle",null,"Head-on",null,null,1.0999999999999999E-2,7.0000000000000001E-3,1.7000000000000001E-2,1.2E-2,0,0,3.4000000000000002E-2,6.0000000000000001E-3,0.01,5.0000000000000001E-3]
[null,null,null,null,null,"Right-angle",null,null,0.26,0.22,0.45800000000000002,0.378,0.182,0.33300000000000002,0.129,0.08,0.436,0.23899999999999999]
[null,null,null,null,null,"Rear-end",null,null,0.625,0.54300000000000004,0.373,0.377,0.72699999999999998,0.5,0.66200000000000003,0.74399999999999999,0.44400000000000001,0.57899999999999996]
[null,null,null,null,null,"Sideswipe",null,null,4.2000000000000003E-2,0.14899999999999999,2.5000000000000001E-2,7.9000000000000001E-2,0,0,0.04,0.112,2.8000000000000001E-2,0.124]
[null,null,null,null,null,"Other multiple-vehicle crash",null,null,8.9999999999999993E-3,0.02,1.7000000000000001E-2,1.6E-2,0,0,1.0999999999999999E-2,6.0000000000000001E-3,1.2E-2,1.4E-2]
[]
[null,null,null,"Single vehicle",null,"Crash with animal",null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Crash with fixed object",null,null,3.3000000000000002E-2,0.05,8.5000000000000006E-2,0.11,0,0.16700000000000001,4.5999999999999999E-2,4.5999999999999999E-2,1.2999999999999999E-2,3.2000000000000001E-2]
[null,null,null,null,null,"Crash with other object",null,null,1E-3,2E-3,0,0,0,0,2E-3,1E-3,0,1E-3]
[null,null,null,null,null,"Crash with parked vehicle",null,null,1E-3,2E-3,0,8.0000000000000002E-3,0,0,0,0,0,0]
[null,null,null,null,null,"Other single-vehicle crash",null,null,1.7999999999999999E-2,7.0000000000000001E-3,2.5000000000000001E-2,0.02,9.0999999999999998E-2,0,7.5999999999999998E-2,5.0000000000000001E-3,5.7000000000000002E-2,6.0000000000000001E-3]
[]
[null,null,null,null,null,null,null,"Total:",{"$f":"SUM(I263:I267)+SUM(I257:I261)","v":1},1,1.0000000000000002,1,1,1,{"$f":"SUM(O263:O267)+SUM(O257:O261)","v":1},1,{"$f":"SUM(Q263:Q267)+SUM(Q257:Q261)","v":1},1]
[null,"SPUI Terminal Severity Distribution"]
[null,"Injury Severity"]
[null,"FI Total",null,null,1]
[null,"Fatal",null,null,6.0000000000000001E-3]
[null,"A Injury",null,null,4.7E-2]
[null,"B Injury",null,null,0.27800000000000002]
[null,"C Injury",null,null,0.66900000000000004]
[null,"TDI Terminal Severity Distribution"]
[null,"Injury Severity"]
[null,"FI Total",null,null,1]
[null,"Fatal",null,null,3.0000000000000001E-3]
[null,"A Injury",null,null,6.0999999999999999E-2]
[null,"B Injury",null,null,0.32900000000000001]
[null,"C Injury",null,null,0.60699999999999998]

{"sheet":"Temp","index":7,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]