{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Two-way segments","One-way segments","Intersections","Totals"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,3,12],[5,1,5,12],[6,1,6,12]]}
[]
[null,"HSM Chapter 12 NCHRP 17-58 Spreadsheet"]
[]
[]
[]
[null,"Developed by:  Michael P. Pratt, Srinivas R. Geedipally, Hadi Khazraee, and Dominique Lord"]
[null,"  Version 2"]
[null,"FOREWORD"]
[null,"This software can be used to assist with the assessment of the safety performance of urban and suburban arterial facilities,"]
[null,"including segments and intersections.  It is intended for use by engineers and technicians responsible for safety analysis or "]
[null,"management of urban streets."]
[]
[null,"This software is intended for use with the updated Chapter 12 of the Highway Safety Manual.  The analyst is encouraged to read "]
[null,"the document so that he or she will have an understanding of how best to use the software and interpret its output."]
[]
[null,"The equations used in this software are documented in this chapter.  Analysts should refer to the chapter whenever they have"]
[null,"questions about the modeling approach, assumptions, or limitations."]
[]
[null,"INSTRUCTIONS"]
[]
[null,"Each cell on the analysis worksheets has been color-coded to indicate the type of data entered or displayed.  The following list"]
[null,"indentifies the meaning of each cell color."]
[]
[null,"Blue cells represent \"input data.\"  Each time the worksheet is used, the values in these cells should be changed to represent the"]
[null,null,"segment or intersection being evaluated.  Input data must be provided by the analyst."]
[null,"Yellow cells represent \"calibration factors.\"  The values in these cells represent reasonable values for most situations and do not "]
[null,null,"need to be changed.  Calibration factors can be changed to more accurately reflect local conditions.  However, field data "]
[null,null,"from sites local to the agency should be the basis for this change."]
[null,"Purple cells represent \"key output variables.\"  The values are computed using the input data, calibration factors, and default values."]
[null,"Note:  White, gray, and purple cells are locked and cannot be changed."]
[]
[null,"DISCLAIMER"]
[null,"No warranty is made by the developers or their employer as to the accuracy, completeness, or reliability of this software and its"]
[null,"associated equations and documentation.  No responsibility is assumed by the developers for incorrect results or damages resulting"]
[null,"from the use of this software."]
[]
[null,"COPYRIGHT © 2015"]
[null,"This software is copyrighted.  All rights are reserved.  This product may not, in whole or in part, be copied, photocopied, reproduced, "]
[null,"translated, or reduced to any electronic medium or machine-readable form without prior consent, in writing, from Michael P. Pratt."]
[null,"This product is subject to change without notice and does not represent a commitment on the part of Michael P. Pratt to notify"]
[null,"any person of such revision."]

{"sheet":"Two-way segments","index":1,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[9,10,9,12],[8,10,8,12],[7,10,7,12],[6,10,6,12],[9,3,9,5],[8,3,8,5],[7,3,7,5],[6,3,6,5]]}
[]
[]
[null,null,"Safety Prediction Worksheet for Two-Way Urban and Suburban Arterial Segments"]
[]
[null,null,"General Information",null,null,null,null,null,"Site Information"]
[]
[null,null,"Analyst","MPP",null,null,null,null,"Street number",null,"SH 1",null,null,null,null,null,null,null,null,"Intercept",null,"AADT coefficient",null,null,"Intercept"]
[null,null,"Agency","TTI",null,null,null,null,"Street name",null,"Main Street",null,null,null,null,null,null,null,null,"F+I","PDO","F+I","PDO",null,"Segment type","Multiple,F+I","Single,F+I","Multiple,PDO","Single,PDO"]
[null,null,"Date",{"$f":"TODAY()","v":"2015-12-09"},null,null,null,null,"Segment number",null,1,null,null,null,null,null,null,null,"Multiple",{"$f":"VLOOKUP($H$27,$Y$8:$AC$12,MATCH($S9&\",\"&T$8,$Y$8:$AC$8,0),FALSE)","v":-11.56},{"$f":"VLOOKUP($H$27,$Y$8:$AC$12,MATCH($S9&\",\"&U$8,$Y$8:$AC$8,0),FALSE)","v":-9.2100000000000009},{"$f":"VLOOKUP($H$27,$Y$15:$AC$19,MATCH($S9&\",\"&V$8,$Y$15:$AC$15,0),FALSE)","v":1.24},{"$f":"VLOOKUP($H$27,$Y$15:$AC$19,MATCH($S9&\",\"&W$8,$Y$15:$AC$15,0),FALSE)","v":1.06},null,"6U",-15.42,-4.54,-15.68,-3.98]
[null,null,"Location","City of Fillmore",null,null,null,null,"Analysis year",null,2011,null,null,null,null,null,null,null,"Single",{"$f":"VLOOKUP($H$27,$Y$8:$AC$12,MATCH($S10&\",\"&T$8,$Y$8:$AC$8,0),FALSE)","v":-5.26},{"$f":"VLOOKUP($H$27,$Y$8:$AC$12,MATCH($S10&\",\"&U$8,$Y$8:$AC$8,0),FALSE)","v":-4.71},{"$f":"VLOOKUP($H$27,$Y$15:$AC$19,MATCH($S10&\",\"&V$8,$Y$15:$AC$15,0),FALSE)","v":0.46},{"$f":"VLOOKUP($H$27,$Y$15:$AC$19,MATCH($S10&\",\"&W$8,$Y$15:$AC$15,0),FALSE)","v":0.43},null,"6D",-11.56,-5.26,-9.2100000000000009,-4.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7T",-11.44,-4.54,-9.1999999999999993,-3.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K","A","B",null,null,"8D",-11.38,-5.36,-8.84,-4.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constant",-5.1142000000000003,-1.7346999999999999,-0.57509999999999994]
[null,null,"Output Summary",null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,"Combined CMF",null,null,null,null,null,null,"Area type",-0.47139999999999999,-0.2505,-0.2505,null,null,"AADT coefficient"]
[null,null,null,null,null,"F+I","PDO","Total",null,null,null,"F+I","PDO",null,null,null,null,null,"Speed",4.4200000000000003E-2,0,0,null,null,"Segment type","Multiple,F+I","Single,F+I","Multiple,PDO","Single,PDO"]
[null,null,null,null,"Total crashes",{"$f":"SUM(F17:F20)","v":6.7850662541133877},{"$f":"SUM(G17:G18)","v":8.5556984879026334},{"$f":"F16+G16","v":15.34076474201602},null,null,"Multiple-vehicle crashes",{"$f":"PRODUCT(H58:H67)","v":1.0348432852132634},{"$f":"PRODUCT(K58:K67)","v":1.0348432852132634},null,null,null,null,null,"6D",-0.3327,-0.2923,-9.3799999999999994E-2,null,null,"6U",1.63,0.37,1.7,0.34]
[null,null,null,null,"Multiple-vehicle crashes",{"$f":"$H51*$H$28*EXP(T9+V9*LN($H$29))*L16","v":5.492259873130509},{"$f":"$H51*$H$28*EXP(U9+W9*LN($H$29))*M16","v":7.3888943867518488},null,null,null,"Single-vehicle crashes",{"$f":"PRODUCT(I58:I67)","v":2.3996101281298938},{"$f":"PRODUCT(L58:L67)","v":2.3996101281298938},null,null,null,null,null,"8D",-0.2296,-0.52300000000000002,-0.23730000000000001,null,null,"6D",1.24,0.46,1.06,0.43]
[null,null,null,null,"Single-vehicle crashes",{"$f":"$H51*$H$28*EXP(T10+V10*LN($H$29))*L17","v":0.94790160183686833},{"$f":"$H51*$H$28*EXP(U10+W10*LN($H$29))*M17","v":1.1668041011507841},null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"T13+T14*IF($H$26=\"Urban\",1,0)+T15*$H$31+T16*IF($H$27=\"6D\",1,0)+T17*IF($H$27=\"8D\",1,0)","v":-3.4579000000000004},{"$f":"U13+U14*IF($H$26=\"Urban\",1,0)+U15*$H$31+U16*IF($H$27=\"6D\",1,0)+U17*IF($H$27=\"8D\",1,0)","v":-2.0270000000000001},-0.66889999999999994,null,null,"7T",1.24,0.37,1.06,0.34]
[null,null,null,null,"Vehicle-pedestrian crashes",{"$f":"SUM(F17:G18)*$H52","v":0.22493789944305015},null,null,null,"Severity distribution for F+I crashes",null,null,null,null,null,null,null,null,"P",{"$f":"EXP(T18)/(1/$H54+EXP($T18)+EXP($U18)+EXP($V18))","v":1.8797897181170083E-2},{"$f":"EXP(U18)/(1/$H54+EXP($T18)+EXP($U18)+EXP($V18))","v":7.8621485265399402E-2},{"$f":"EXP(V18)/(1/$H54+EXP($T18)+EXP($U18)+EXP($V18))","v":0.3057430402758472},null,null,"8D",1.24,0.46,1.06,0.43]
[null,null,null,null,"Vehicle-bicycle crashes",{"$f":"SUM(F17:G18)*$H53","v":0.11996687970296009},null,null,null,"K","A","B","C"]
[null,null,null,null,null,null,null,null,null,{"$f":"$F16*T19","v":0.1275449778122503},{"$f":"$F16*U19","v":0.53345198652253445},2.0744867850056812,{"$f":"F16*(1-SUM(T19:V19))","v":4.0495825047729221}]
[]
[null,null,"Input Data",null,null,null,null,"Value",null,"Advisory Messages"]
[]
[null,null,"Basic Roadway Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum","Maximum",null,"Segment type","Minimum","Maximum"]
[null,null,"Area type",null,null,null,null,"Suburban",null,".",null,null,null,null,null,null,null,null,null,null,null,"6U",0,78000]
[null,null,"Segment type",null,null,null,null,"6D",null,{"$f":"IF(H27=\"7T\",\"6 lanes + two-way left-turn lane.\",\".\")","v":"."},null,null,null,null,null,null,null,null,null,null,null,"6D",0,118000]
[null,null,"Segment length, mi",null,null,null,null,0.4,null,".",null,null,null,null,null,null,null,null,null,null,null,"7T",0,94000]
[null,null,"Annual average daily traffic (AADT), veh/day",null,null,null,null,90000,{"$f":"IF(OR(H29<S29,H29>T29),\"Check\",\"\")","v":""},".",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($H$27,$V$25:$X$29,MATCH(S$25,$V$25:$X$25,0),FALSE)","v":0},{"$f":"VLOOKUP($H$27,$V$25:$X$29,MATCH(T$25,$V$25:$X$25,0),FALSE)","v":118000},null,"8D",0,152000]
[null,null,"Number of highway-rail grade crossings present",null,null,null,null,0,null,{"$f":"IF(H30>0,ROUND(H30/H28,0)&\" crossings per mile.\",\".\")","v":"."},null,null,null,null,null,null,null,null,0,3]
[null,null,"Posted speed limit, mi/h",null,null,null,null,45,null,{"$f":"IF(AND(H31<=30,H27=\"8D\"),\"Estimated ped/bike factors.\",\".\")","v":"."}]
[null,null,"Automated speed enforcement present?",null,null,null,null,"No",null,"."]
[]
[null,null,"Access Data"]
[null,null,"Driveway count",null,"Major commercial",null,null,6,{"$f":"IF(OR(H35<S35,H35>T35),\"Check\",\"\")","v":""},{"$f":"IF(H35>0,ROUND(H35/H$28,0)&\" major comm. driveways per mile.\",\".\")","v":"15 major comm. driveways per mile."},null,null,null,null,null,null,null,null,0,{"$f":"138.8*H28","v":55.52000000000001}]
[null,null,null,null,"Major industrial",null,null,1,"",{"$f":"IF(H36>0,ROUND(H36/H$28,0)&\" major industrial driveways per mile.\",\".\")","v":"3 major industrial driveways per mile."},null,null,null,null,null,null,null,null,0,{"$f":"100*H28","v":40}]
[null,null,null,null,"Minor",null,null,7,"",{"$f":"IF(H37>0,ROUND(H37/H$28,0)&\" minor driveways per mile.\",\".\")","v":"18 minor driveways per mile."},null,null,null,null,null,null,null,null,0,{"$f":"119.2*H28","v":47.680000000000007}]
[]
[null,null,"Cross Section Data"]
[null,null,"Lane width, ft",null,null,null,null,11,{"$f":"IF(OR(H40<S40,H40>T40),\"Check\",\"\")","v":""},".",null,null,null,null,null,null,null,null,9,27]
[null,null,"Outside shoulder width, ft",null,null,null,null,1.5,"",".",null,null,null,null,null,null,null,null,0,14]
[null,null,"Median width, ft",null,null,null,null,13,"",{"$f":"IF(AND(H27<>\"6U\",H42=0),\"Must enter nonzero median width.\",\".\")","v":"."},null,null,null,null,null,null,null,null,0,240]
[null,null,"Median barrier present?",null,null,null,null,"Yes",null,"."]
[]
[null,null,"Roadside Data"]
[null,null,"Roadside fixed object count",null,null,null,null,18,{"$f":"IF(OR(H46<S46,H46>T46),\"Check\",\"\")","v":""},{"$f":"IF(H46>0,ROUND(H46/H28,0)&\" objects per mile.\",\".\")","v":"45 objects per mile."},null,null,null,null,null,null,null,null,0,{"$f":"508*H28","v":203.20000000000002}]
[null,null,"Average roadside fixed object offset, ft",null,null,null,null,7,"",".",null,null,null,null,null,null,null,null,0,30]
[]
[null,null,"Calibration Factors",null,null,null,null,"Value",null,null,"Default Values",null,null,null,null,null,null,null,"Segment type","fped, ≤ 30 mph","fped, ≥ 35 mph","fbike, ≤ 30 mph","fbike, ≥ 35 mph"]
[]
[null,null,"Local calibration factor (C)",null,null,null,null,{"$f":"K51","v":1},null,null,1,null,null,null,null,null,null,null,"6U",1.7999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,7.0000000000000001E-3]
[null,null,"Adjustment factor for pedestrians (fped)",null,null,null,null,{"$f":"K52","v":1.4999999999999999E-2},null,null,{"$f":"VLOOKUP($H$27,$S$51:$W$54,IF($H$31<=30,2,3),FALSE)","v":1.4999999999999999E-2},null,null,null,null,null,null,null,"6D",2.9000000000000001E-2,1.4999999999999999E-2,7.0000000000000001E-3,8.0000000000000002E-3]
[null,null,"Adjustment factor for bicyclists (fbike)",null,null,null,null,{"$f":"K53","v":8.0000000000000002E-3},null,null,{"$f":"VLOOKUP($H$27,$S$51:$W$54,IF($H$31<=30,4,5),FALSE)","v":8.0000000000000002E-3},null,null,null,null,null,null,null,"7T",3.4000000000000002E-2,1.4E-2,2.5000000000000001E-2,1E-3]
[null,null,"Severity distribution calibration factor (Csdf,tws)",null,null,null,null,{"$f":"K54","v":1},null,null,1,null,null,null,null,null,null,null,"8D",{"$f":"U54","v":2.3E-2},2.3E-2,{"$f":"W54","v":1.4E-2},1.4E-2]
[]
[null,null,"Crash Modification Factors",null,null,null,null,"F+I",null,null,"PDO",null,null,null,null,null,null,null,null,null,null,"F+I coefficients",null,null,"PDO coefficients"]
[null,null,null,null,null,null,null,"Multiple","Single",null,"Multiple","Single",null,null,null,null,null,null,"Value","Base",null,"Multiple","Single",null,"Multiple","Single"]
[null,null,"Lane width",null,null,null,null,{"$f":"EXP(V58*($S58-$T58))","v":1.0221415652030397},{"$f":"EXP(W58*($S58-$T58))","v":1.0221415652030397},null,{"$f":"EXP(Y58*($S58-$T58))","v":1.0221415652030397},{"$f":"EXP(Z58*($S58-$T58))","v":1.0221415652030397},null,null,null,null,null,null,{"$f":"H40","v":11},12,null,-2.1899999999999999E-2,{"$f":"V58","v":-2.1899999999999999E-2},null,-2.1899999999999999E-2,{"$f":"Y58","v":-2.1899999999999999E-2}]
[null,null,"Outside shoulder width",null,null,null,null,{"$f":"EXP(V59*($S59-$T59))","v":1},{"$f":"EXP(W59*($S59-$T59))","v":1},null,{"$f":"EXP(Y59*($S59-$T59))","v":1},{"$f":"EXP(Z59*($S59-$T59))","v":1},null,null,null,null,null,null,{"$f":"H41","v":1.5},1.5,null,-2.8500000000000001E-2,{"$f":"V59","v":-2.8500000000000001E-2},null,-2.8500000000000001E-2,{"$f":"Y59","v":-2.8500000000000001E-2}]
[null,null,"Median width",null,null,null,null,{"$f":"IF(OR($H$27=\"6D\",$H$27=\"8D\"),EXP(V60*($S60-$T60)),1)","v":1.011465227629341},{"$f":"IF(OR($H$27=\"6D\",$H$27=\"8D\"),EXP(W60*($S60-$T60)),1)","v":1.011465227629341},null,{"$f":"IF(OR($H$27=\"6D\",$H$27=\"8D\"),EXP(Y60*($S60-$T60)),1)","v":1.011465227629341},{"$f":"IF(OR($H$27=\"6D\",$H$27=\"8D\"),EXP(Z60*($S60-$T60)),1)","v":1.011465227629341},null,null,null,null,null,null,{"$f":"H42","v":13},15,null,-5.7000000000000002E-3,-5.7000000000000002E-3,null,-5.7000000000000002E-3,-5.7000000000000002E-3]
[null,null,"Median barrier",null,null,null,null,{"$f":"IF(OR($H$27=\"6U\",$H$27=\"7T\"),1,EXP(V61*$S61))","v":0.60013538953256818},{"$f":"IF(OR($H$27=\"6U\",$H$27=\"7T\"),1,EXP(W61*$S61))","v":1.9671779440349244},null,{"$f":"IF(OR($H$27=\"6U\",$H$27=\"7T\"),1,EXP(Y61*$S61))","v":0.60013538953256818},{"$f":"IF(OR($H$27=\"6U\",$H$27=\"7T\"),1,EXP(Z61*$S61))","v":1.9671779440349244},null,null,null,null,null,null,{"$f":"IF(H43=\"Yes\",1,0)","v":1},null,null,-0.51060000000000005,0.67659999999999998,null,-0.51060000000000005,0.67659999999999998]
[null,null,"Highway-rail grade crossing",null,null,null,null,{"$f":"EXP(V62*$S62)","v":1},{"$f":"EXP(W62*$S62)","v":1},null,{"$f":"EXP(Y62*$S62)","v":1},{"$f":"EXP(Z62*$S62)","v":1},null,null,null,null,null,null,{"$f":"H30/H28","v":0},0,null,3.8800000000000001E-2,3.8800000000000001E-2,null,3.8800000000000001E-2,{"$f":"Y62","v":3.8800000000000001E-2}]
[null,null,"Major commercial driveways",null,null,null,null,{"$f":"EXP(V63*($S63-$T63))","v":1.5761733830339912},null,null,{"$f":"EXP(Y63*($S63-$T63))","v":1.5761733830339912},null,null,null,null,null,null,null,{"$f":"H35/H28","v":15},2,null,3.5000000000000003E-2,null,null,3.5000000000000003E-2]
[null,null,"Major industrial driveways",null,null,null,null,1.0161794931105472,null,null,1.0161794931105472,null,null,null,null,null,null,null,{"$f":"H36/H28","v":2.5},1,null,1.0699999999999999E-2,null,null,1.0699999999999999E-2]
[null,null,"Minor driveways",null,null,null,null,1.0413313097025174,null,null,1.0413313097025174,null,null,null,null,null,null,null,{"$f":"H37/H28","v":17.5},10,null,5.4000000000000003E-3,null,null,5.4000000000000003E-3]
[null,null,"Automated speed enforcement",null,null,null,null,{"$f":"IF($S66=0,1,V66)","v":1},{"$f":"IF($S66=0,1,W66)","v":1},null,{"$f":"IF($S66=0,1,Y66)","v":1},{"$f":"IF($S66=0,1,Z66)","v":1},null,null,null,null,null,null,{"$f":"IF(H32=\"Yes\",1,0)","v":0},0,null,0.83,0.83,null,1,1]
[null,null,"Roadside fixed objects",null,null,null,null,null,{"$f":"1+0.01*$H46/$H28/EXP(W67*$S67)","v":1.1798723770021604},null,null,{"$f":"1+0.01*$H46/$H28/EXP(Z67*$S67)","v":1.1798723770021604},null,null,null,null,null,null,{"$f":"H47","v":7},null,null,null,0.13100000000000001,null,null,0.13100000000000001]

{"sheet":"One-way segments","index":2,"n_rows":66,"n_cols":30,"rows_kept":66,"cut":false,"hidden":false,"merged":[[9,10,9,12],[8,10,8,12],[7,10,7,12],[6,10,6,12],[9,3,9,5],[8,3,8,5],[7,3,7,5],[6,3,6,5]]}
[]
[]
[null,null,"Safety Prediction Worksheet for One-Way Urban and Suburban Arterial Segments"]
[]
[null,null,"General Information",null,null,null,null,null,"Site Information"]
[]
[null,null,"Analyst","MPP",null,null,null,null,"Street number",null,"SH 1",null,null,null,null,null,null,null,null,"Intercept",null,"AADT coefficient",null,null,"Intercept"]
[null,null,"Agency","TTI",null,null,null,null,"Street name",null,"Main Street",null,null,null,null,null,null,null,null,"F+I","PDO","F+I","PDO",null,"Segment type","Multiple,F+I","Single,F+I","Multiple,PDO","Single,PDO"]
[null,null,"Date",{"$f":"TODAY()","v":"2015-12-09"},null,null,null,null,"Segment number",null,1,null,null,null,null,null,null,null,"Multiple",{"$f":"VLOOKUP($H$27,$Y$8:$AC$11,MATCH($S9&\",\"&T$8,$Y$8:$AC$8,0),FALSE)","v":-11.49},{"$f":"VLOOKUP($H$27,$Y$8:$AC$11,MATCH($S9&\",\"&U$8,$Y$8:$AC$8,0),FALSE)","v":-8.27},1.26,1.02,null,"2O",-11.48,-5.32,-8.26,-4.71]
[null,null,"Location","City of Fillmore",null,null,null,null,"Analysis year",null,2011,null,null,null,null,null,null,null,"Single",{"$f":"VLOOKUP($H$27,$Y$8:$AC$11,MATCH($S10&\",\"&T$8,$Y$8:$AC$8,0),FALSE)","v":-4.93},{"$f":"VLOOKUP($H$27,$Y$8:$AC$11,MATCH($S10&\",\"&U$8,$Y$8:$AC$8,0),FALSE)","v":-4.72},0.42,0.43,null,"3O",-11.49,-4.93,-8.27,-4.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4O",-11.74,-4.93,-8.68,-4.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K+A","B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constant",0.29330000000000001,-0.38100000000000001]
[null,null,"Output Summary",null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,"Combined CMF",null,null,null,null,null,null,"Lane",-0.1226,0]
[null,null,null,null,null,"F+I","PDO","Total",null,null,null,"F+I","PDO",null,null,null,null,null,"R Shld",-0.126,-5.7549999999999997E-2]
[null,null,null,null,"Total crashes",{"$f":"SUM(F17:F20)","v":1.6382550931726068},{"$f":"SUM(G17:G18)","v":3.2946954915946196},{"$f":"F16+G16","v":4.9329505847672266},null,null,"Multiple-vehicle crashes",{"$f":"PRODUCT(H60:H66)","v":1.3700537874749996},{"$f":"PRODUCT(K60:K66)","v":1.3700537874749996},null,null,null,null,null,"Area type",-0.39939999999999998,0]
[null,null,null,null,"Multiple-vehicle crashes",{"$f":"$H52*$H$28*EXP(T9+V9*LN($H$30))*L16","v":1.2444628980119277},{"$f":"$H52*$H$28*EXP(U9+W9*LN($H$30))*M16","v":2.9859398390324539},null,null,null,"Single-vehicle crashes",{"$f":"PRODUCT(I60:I66)","v":1.2969359226026758},{"$f":"PRODUCT(L60:L66)","v":1.2969359226026758},null,null,null,null,null,"Bike lane",0.99690000000000001,0.504]
[null,null,null,null,"Single-vehicle crashes",{"$f":"$H52*$H$28*EXP(T10+V10*LN($H$30))*L17","v":0.22697744108642517},{"$f":"$H52*$H$28*EXP(U10+W10*LN($H$30))*M17","v":0.30875565256216558},null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"T13+T14*H39+T15*H40+T16*IF($H$26=\"Urban\",1,0)+T17*IF($H$29=\"Yes\",1,0)","v":-1.2443},{"$f":"U13+U14*H39+U15*H40+U16*IF($H$26=\"Urban\",1,0)+U17*IF($H$29=\"Yes\",1,0)","v":-0.46732499999999999}]
[null,null,null,null,"Vehicle-pedestrian crashes",{"$f":"SUM(F17:G18)*$H53","v":0.11438725993663135},null,null,null,"Severity distribution for F+I crashes",null,null,null,null,null,null,null,null,"P",{"$f":"EXP(T18)/(1/$H55+EXP($T18)+EXP($U18))","v":0.1504803057846803},{"$f":"EXP(U18)/(1/$H55+EXP($T18)+EXP($U18))","v":0.32727710143509842}]
[null,null,null,null,"Vehicle-bicycle crashes",{"$f":"SUM(F17:G18)*$H54","v":5.2427494137622696E-2},null,null,null,"K","A","B","C"]
[null,null,null,null,null,null,null,null,null,{"$f":"F16*T19*H56","v":2.4405987610018456E-2},{"$f":"F16*T19*(1-H56)","v":0.22211913976390535},{"$f":"F16*U19","v":0.53616337830481786},{"$f":"F16*(1-SUM(T19:U19))","v":0.85556658749386505}]
[]
[null,null,"Input Data",null,null,null,null,"Value",null,"Advisory Messages"]
[]
[null,null,"Basic Roadway Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum","Maximum",null,"Segment type","Minimum","Maximum"]
[null,null,"Area type",null,null,null,null,"Suburban",null,".",null,null,null,null,null,null,null,null,null,null,null,"2O",0,34000]
[null,null,"Segment type",null,null,null,null,"3O",null,".",null,null,null,null,null,null,null,null,null,null,null,"3O",0,29000]
[null,null,"Segment length, mi",null,null,null,null,0.4,null,".",null,null,null,null,null,null,null,null,null,null,null,"4O",0,29000]
[null,null,"Bicycle lanes present?",null,null,null,null,"No",null,"."]
[null,null,"Annual average daily traffic (AADT), veh/day",null,null,null,null,17500,{"$f":"IF(OR(H30<S30,H30>T30),\"Check\",\"\")","v":""},".",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($H$27,$V$25:$X$28,MATCH(S$25,$V$25:$X$25,0),FALSE)","v":0},{"$f":"VLOOKUP($H$27,$V$25:$X$28,MATCH(T$25,$V$25:$X$25,0),FALSE)","v":29000}]
[null,null,"Posted speed limit, mi/h",null,null,null,null,30,null,"."]
[null,null,"Automated speed enforcement present?",null,null,null,null,"No",null,"."]
[]
[null,null,"Access Data"]
[null,null,"Driveway count",null,"Major commercial",null,null,6,{"$f":"IF(OR(H35<S35,H35>T35),\"Check\",\"\")","v":""},{"$f":"IF(H35>0,ROUND(H35/H$28,0)&\" major comm. driveways per mile.\",\".\")","v":"15 major comm. driveways per mile."},null,null,null,null,null,null,null,null,0,{"$f":"58.3*H28","v":23.32}]
[null,null,null,null,"Minor",null,null,7,"",{"$f":"IF(H36>0,ROUND(H36/H$28,0)&\" minor driveways per mile.\",\".\")","v":"18 minor driveways per mile."},null,null,null,null,null,null,null,null,0,{"$f":"100*H28","v":40}]
[]
[null,null,"Cross Section Data"]
[null,null,"Lane width, ft",null,null,null,null,11,{"$f":"IF(OR(H39<S39,H39>T39),\"Check\",\"\")","v":""},".",null,null,null,null,null,null,null,null,9,27]
[null,null,"Right shoulder width, ft",null,null,null,null,1.5,"",".",null,null,null,null,null,null,null,null,0,20]
[]
[null,null,"Roadside Data"]
[null,null,"On-street parallel parking length on right side, mi",null,null,null,null,0,{"$f":"IF(OR(H43<S43,H43>T43),\"Check\",\"\")","v":""},{"$f":"IF(H$43+H$44>2*H$28,\"Right-side park length > segment length.\",\".\")","v":"."},null,null,null,null,null,null,null,null,0,{"$f":"H28","v":0.4}]
[null,null,"On-street angle parking length on right side, mi",null,null,null,null,0,"",{"$f":"IF(H27=\"4O\",\"Effect not known for 4O segments.\",IF(H$43+H$44>2*H$28,\"Right-side park length > segment length.\",\".\"))","v":"."},null,null,null,null,null,null,null,null,0,{"$f":"H28","v":0.4}]
[null,null,"On-street parallel parking length on left side, mi",null,null,null,null,0,{"$f":"IF(OR(H45<S45,H45>T45),\"Check\",\"\")","v":""},{"$f":"IF(H$45+H$46>2*H$28,\"Left-side park length > segment length.\",\".\")","v":"."},null,null,null,null,null,null,null,null,0,{"$f":"H28","v":0.4}]
[null,null,"On-street angle parking length on left side, mi",null,null,null,null,0,"",{"$f":"IF(H29=\"4O\",\"Effect not known for 4O segments.\",IF(H$45+H$46>2*H$28,\"Left-side park length > segment length.\",\".\"))","v":"."},null,null,null,null,null,null,null,null,0,{"$f":"H28","v":0.4}]
[null,null,"Roadside fixed object count",null,null,null,null,18,"",{"$f":"IF(H47>0,ROUND(H47/H28,0)&\" objects per mile.\",\".\")","v":"45 objects per mile."},null,null,null,null,null,null,null,null,0,{"$f":"300*H28","v":120}]
[null,null,"Average roadside fixed object offset, ft",null,null,null,null,7,"",".",null,null,null,null,null,null,null,null,0,{"$f":"IF($H$27=\"4O\",25,30)","v":30}]
[]
[null,null,"Calibration Factors",null,null,null,null,"Value",null,null,"Default Values"]
[]
[null,null,"Local calibration factor (C)",null,null,null,null,{"$f":"K52","v":1},null,null,1,null,null,null,null,null,null,null,"Segment type","fped, ≤ 30 mph","fped, ≥ 35 mph","fbike, ≤ 30 mph","fbike, ≥ 35 mph"]
[null,null,"Adjustment factor for pedestrians (fped)",null,null,null,null,2.4E-2,null,null,{"$f":"VLOOKUP($H$27,$S$53:$W$55,IF($H$31<=30,2,3),FALSE)","v":2.4E-2},null,null,null,null,null,null,null,"2O",1.7000000000000001E-2,1.7999999999999999E-2,1.0999999999999999E-2,1.6E-2]
[null,null,"Adjustment factor for bicyclists (fbike)",null,null,null,null,1.0999999999999999E-2,null,null,{"$f":"VLOOKUP($H$27,$S$53:$W$55,IF($H$31<=30,4,5),FALSE)","v":1.0999999999999999E-2},null,null,null,null,null,null,null,"3O",2.4E-2,1.7000000000000001E-2,1.0999999999999999E-2,1.2E-2]
[null,null,"Severity distribution calibration factor (Csdf,ows)",null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,"4O",2.1000000000000001E-2,0.03,2.1000000000000001E-2,7.0000000000000001E-3]
[null,null,"Probability of fatality given K+A severity (PK|K+A)",null,null,null,null,9.9000000000000005E-2,null,null,9.9000000000000005E-2]
[]
[null,null,"Crash Modification Factors",null,null,null,null,"F+I",null,null,"PDO",null,null,null,null,null,null,null,null,null,null,"F+I coefficients",null,null,"PDO coefficients"]
[null,null,null,null,null,null,null,"Multiple","Single",null,"Multiple","Single",null,null,null,null,null,null,"Value","Base",null,"Multiple","Single",null,"Multiple","Single",null,"Parallel parking CMF coefficients"]
[null,null,"Right shoulder width",null,null,null,null,{"$f":"EXP(V60*($S60-$T60))","v":1.0515339470050777},{"$f":"EXP(W60*($S60-$T60))","v":1.0515339470050777},null,{"$f":"EXP(Y60*($S60-$T60))","v":1.0515339470050777},{"$f":"EXP(Z60*($S60-$T60))","v":1.0515339470050777},null,null,null,null,null,null,{"$f":"H40","v":1.5},4,null,-2.01E-2,{"$f":"V60","v":-2.01E-2},null,-2.01E-2,{"$f":"Y60","v":-2.01E-2},null,"Segment type","F+I coefficients","PDO coefficients"]
[null,null,"On-street parallel parking",null,null,null,null,{"$f":"1+$S61*(V61-1)","v":1},{"$f":"1+$S61*(W61-1)","v":1},null,{"$f":"1+$S61*(Y61-1)","v":1},{"$f":"1+$S61*(Z61-1)","v":1},null,null,null,null,null,null,{"$f":"(H43+H45)/2/H28","v":0},null,null,{"$f":"VLOOKUP($H$27,$AB$60:$AD$63,MATCH(V$58,$AB$60:$AD$60,0),FALSE)","v":1.359},{"$f":"VLOOKUP($H$27,$AB$60:$AD$63,MATCH(V$58,$AB$60:$AD$60,0),FALSE)","v":1.359},null,{"$f":"VLOOKUP($H$27,$AB$60:$AD$63,MATCH(Y$58,$AB$60:$AD$60,0),FALSE)","v":1.359},{"$f":"VLOOKUP($H$27,$AB$60:$AD$63,MATCH(Y$58,$AB$60:$AD$60,0),FALSE)","v":1.359},null,"2O",1.1120000000000001,1.1120000000000001]
[null,null,"On-street angle parking",null,null,null,null,{"$f":"IF($H$27=\"4O\",1,1+$S62*(V62-1))","v":1},{"$f":"IF($H$27=\"4O\",1,1+$S62*(W62-1))","v":1},null,{"$f":"IF($H$27=\"4O\",1,1+$S62*(Y62-1))","v":1},{"$f":"IF($H$27=\"4O\",1,1+$S62*(Z62-1))","v":1},null,null,null,null,null,null,{"$f":"(H44+H46)/2/H28","v":0},null,null,4.3639999999999999,4.3639999999999999,null,4.3639999999999999,4.3639999999999999,null,"3O",1.359,1.359]
[null,null,"Major commercial driveways",null,null,null,null,{"$f":"EXP(V63*($S63-$T63))","v":1.2587258762236806},null,null,{"$f":"EXP(Y63*($S63-$T63))","v":1.2587258762236806},null,null,null,null,null,null,null,{"$f":"H35/H28","v":15},2,null,1.77E-2,null,null,1.77E-2,null,null,"4O",1.359,1.359]
[null,null,"Minor driveways",null,null,null,null,{"$f":"EXP(V64*($S64-$T64))","v":1.0351020283761143},null,null,{"$f":"EXP(Y64*($S64-$T64))","v":1.0351020283761143},null,null,null,null,null,null,null,{"$f":"H36/H28","v":17.5},10,null,4.5999999999999999E-3,null,null,4.5999999999999999E-3]
[null,null,"Automated speed enforcement",null,null,null,null,{"$f":"IF($S65=0,1,V65)","v":1},{"$f":"IF($S65=0,1,W65)","v":1},null,{"$f":"IF($S65=0,1,Y65)","v":1},{"$f":"IF($S65=0,1,Z65)","v":1},null,null,null,null,null,null,{"$f":"IF(H32=\"Yes\",1,0)","v":0},0,null,0.83,0.83,null,1,1]
[null,null,"Roadside fixed objects",null,null,null,null,null,{"$f":"1+0.01*$H47/$H28/EXP(W66*$S66)","v":1.2333752289182283},null,null,{"$f":"1+0.01*$H47/$H28/EXP(Z66*$S66)","v":1.2333752289182283},null,null,null,null,null,null,{"$f":"H48","v":7},null,null,null,9.3799999999999994E-2,null,null,9.3799999999999994E-2]

{"sheet":"Intersections","index":3,"n_rows":80,"n_cols":57,"rows_kept":80,"cut":false,"hidden":false,"merged":[[61,2,61,4],[60,2,60,4],[57,2,57,4],[56,5,56,12],[32,7,32,8],[33,7,33,8],[34,7,34,8],[26,7,26,8],[25,7,25,8],[27,7,27,8],[28,7,28,8],[31,7,31,8],[30,7,30,8],[29,7,29,8],[9,10,9,12],[8,10,8,12],[7,10,7,12],[6,10,6,12],[9,3,9,5],[8,3,8,5],[7,3,7,5],[6,3,6,5]]}
[]
[]
[null,null,"Safety Prediction Worksheet for Urban and Suburban Arterial Intersections"]
[]
[null,null,"General Information",null,null,null,null,null,"Site Information",null,null,null,null,null,null,null,null,null,{"$f":"Y23&\",\"&T$7","v":"2x2,F+I"},{"$f":"Y23&\",\"&U$7","v":"2x2,PDO"}]
[]
[null,null,"Analyst","MPP",null,null,null,null,"Major street name",null,"Main Street",null,null,null,null,null,null,null,{"$f":"H27&IF(H28=\"Signalized\",\"SG\",\"ST\")","v":"4SG"},"F+I","PDO",null,null,"3SG","4SG",null,null,"Coefficients by intersection type",null,null,null,null,null,null,null,"K+A","Two-way Signalized","One-way Signalized","Two-way stop",null,"B","Two-way Signalized","One-way Signalized","Two-way stop",null,"Max AADTs","Major","Minor"]
[null,null,"Agency","TTI",null,null,null,null,"Minor street name",null,"Cross Street",null,null,null,null,null,null,null,"Intercept",{"$f":"VLOOKUP($S$7,$AB$8:$AF$12,MATCH($S$5,$AB$8:$AF$8,0),FALSE)","v":-4.63},{"$f":"VLOOKUP($S$7,$AB$8:$AH$12,MATCH($T$5,$AB$8:$AH$8,0),FALSE)","v":-3.77},null,"Intercept",-6.6,-9.5299999999999994,{"$f":"VLOOKUP(W8,$W$7:$Y$12,MATCH($S$7,$W$7:$Y$7,0),FALSE)","v":-9.5299999999999994},null,"Intercept","2x2,F+I","1x2,F+I","1x1,F+I","2x2,PDO","1x2,PDO","1x1,PDO",null,"Constant",-1.7669999999999999,-2.0419999999999998,-1.1060000000000001,null,"Constant",-0.72499999999999998,-0.74099999999999999,-0.36099999999999999,null,"2x2,3ST",66800,8600]
[null,null,"Date",{"$f":"TODAY()","v":"2015-12-09"},null,null,null,null,"Intersection number",null,1,null,null,null,null,null,null,null,"Major AADT",{"$f":"VLOOKUP($S$7,$AB$13:$AF$17,MATCH($S$5,$AB$13:$AF$13,0),FALSE)","v":0.36},{"$f":"VLOOKUP($S$7,$AB$13:$AH$17,MATCH($T$5,$AB$13:$AH$13,0),FALSE)","v":0.27},null,"Total AADT",0.05,0.4,{"$f":"VLOOKUP(W9,$W$7:$Y$12,MATCH($S$7,$W$7:$Y$7,0),FALSE)","v":0.4},null,"3ST",-15.03,-9.1199999999999992,-9.2200000000000006,-14.97,-17.600000000000001,-17.989999999999998,null,"Area type",-0.11600000000000001,-0.40699999999999997,-0.38200000000000001,null,"Area type",-0.11600000000000001,-9.9000000000000005E-2,-0.27800000000000002,null,"2x2,4ST",54600,4600]
[null,null,"Location","City of Fillmore",null,null,null,null,"Analysis year",null,2011,null,null,null,null,null,null,null,"Minor AADT",{"$f":"VLOOKUP($S$7,$AB$18:$AF$22,MATCH($S$5,$AB$18:$AF$18,0),FALSE)","v":0.27},{"$f":"VLOOKUP($S$7,$AB$18:$AH$22,MATCH($T$5,$AB$18:$AH$18,0),FALSE)","v":0.27},null,"AADT ratio",0.24,0.26,0.26,null,"3SG",-7.11,-11.21,-11.31,-5.07,-7.07,-7.46,null,"RTOR",-1.1659999999999999,null,null,null,"RTOR",-1.0740000000000001,null,null,null,"2x2,3SG",94000,31000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPF",{"$f":"$H50*EXP(T8+T9*LN($H40)+T10*LN($I40))","v":4.1455995378521315},{"$f":"$H50*EXP(U8+U9*LN($H40)+U10*LN($I40))","v":4.0177961849898693},null,"PedVol",0.41,0.45,0.45,null,"4ST",-10.08,-10.83,-10.93,-12.01,-12.06,-12.46,null,"U-turn",-0.14199999999999999,null,null,null,"U-turn",-6.9000000000000006E-2,null,null,null,"2x2,4SG",137600,68400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H28=\"Two-way stop\",H28,H39&\" \"&H28)","v":"Two-way Signalized"},"K+A","B",null,"Lanes",0.09,0.04,0.04,null,"4SG",-4.63,-5.47,-5.57,-3.77,-5.92,-6.31,null,"Major LT",-0.17799999999999999,-0.29599999999999999,null,null,"Major LT",-0.108,-0.255,null,null,"1x2,3ST",42700,13400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constant",{"$f":"VLOOKUP($S13,$AJ$7:$AM$16,MATCH($S$12,$AJ$7:$AM$7,0),FALSE)","v":-1.7669999999999999},{"$f":"VLOOKUP($S13,$AO$7:$AR$16,MATCH($S$12,$AO$7:$AR$7,0),FALSE)","v":-0.72499999999999998},null,"Npedbase",null,null,null,null,"Major AADT","2x2,F+I","1x2,F+I","1x1,F+I","2x2,PDO","1x2,PDO","1x1,PDO",null,"Lighting",-0.33100000000000002,null,-0.91800000000000004,null,"Lighting",null,null,-0.39700000000000002,null,"1x2,4ST",23400,19200]
[null,null,"Output Summary",null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,"Combined CMF",null,null,null,null,null,null,"Area type",-0.11600000000000001,-0.11600000000000001,null,null,null,null,null,null,"3ST",1.0900000000000001,0.65,0.65,1.35,1.53,1.53,null,"Minor LT",null,null,null,null,"Minor LT",null,null,-0.434,null,"1x2,3SG",43800,58800]
[null,null,null,null,null,"F+I","PDO","Total",null,null,null,"F+I","PDO",null,null,null,null,null,"RTOR",-1.1659999999999999,-1.0740000000000001,null,null,null,null,null,null,"3SG",0.65,0.59,0.59,0.47,0.49,0.49,null,"Minor RT channel",null,-0.30599999999999999,null,null,"Minor RT channel",null,-0.504,null,null,"1x2,4SG",77000,98900]
[null,null,null,null,"Total crashes",{"$f":"SUM(F17:F19)","v":3.0636057888899826},{"$f":"G17","v":2.7737482508737688},{"$f":"F16+G16","v":5.8373540397637509},null,null,"Total-vehicle crashes",{"$f":"PRODUCT(H69:H75)","v":0.69036559426191069},{"$f":"PRODUCT(K69:K75)","v":0.69036559426191069},null,null,null,null,null,"U-turn",-0.14199999999999999,-6.9000000000000006E-2,null,null,null,null,null,null,"4ST",0.57999999999999996,0.67,0.67,0.67,0.86,0.86,null,"Major RT channel",null,null,null,null,"Major RT channel",null,0.55700000000000005,null,null,"1x1,3ST",16900,11100]
[null,null,null,null,"Total-vehicle crashes",{"$f":"T11*L16","v":2.861979288521189},{"$f":"U11*M16","v":2.7737482508737688},null,null,null,"Vehicle-pedestrian crashes",{"$f":"PRODUCT(H78:H80)","v":1},null,null,null,null,null,null,"Major LT",-0.17799999999999999,-0.108,null,null,null,null,null,null,"4SG",0.36,0.18,0.18,0.27,0.38,0.38,null,null,null,null,null,null,null,null,null,null,null,"1x1,4ST",11000,6800]
[null,null,null,null,"Vehicle-pedestrian crashes",{"$f":"IF(H28=\"Signalized\",EXP(Z8+Z9*LN(H40+I40)+Z10*LN(MIN(H40:I40)/MAX(H40:I40))+Z11*LN(H31)+Z12*H32)*L17,(F17+G17)*H51)","v":9.4547677120289553E-2},null,null,null,null,null,null,null,null,null,null,null,null,"Lighting",-0.33100000000000002,0,null,null,null,null,null,null,"Minor AADT","2x2,F+I","1x2,F+I","1x1,F+I","2x2,PDO","1x2,PDO","1x1,PDO",null,null,null,null,null,null,null,null,null,null,null,"1x1,3SG",20100,7500]
[null,null,null,null,"Vehicle-bicycle crashes",{"$f":"(F17+G17)*H52","v":0.10707882324850421},null,null,null,"Severity distribution for F+I crashes",null,null,null,null,null,null,null,null,"Minor LT",0,0,null,null,null,null,null,null,"3ST",0.53,0.11,0.11,0.15,0.31,0.31,null,null,null,null,null,null,null,null,null,null,null,"1x1,4SG",24300,16900]
[null,null,null,null,null,null,null,null,null,"K","A","B","C",null,null,null,null,null,"Minor RT channel",0,0,null,null,null,null,null,null,"3SG",0.16,0.56000000000000005,0.56000000000000005,0.14000000000000001,0.35,0.35]
[null,null,null,null,null,null,null,null,null,{"$f":"F16*T23*H55","v":1.5477616492511935E-2},{"$f":"F16*T23*(1-H55)","v":0.14917787810867889},{"$f":"F16*U23","v":0.74759050859438458},{"$f":"F16*(1-SUM(T23:U23))","v":2.1513597856944071},null,null,null,null,null,"Major RT channel",0,0,null,null,null,null,null,null,"4ST",0.6,0.41,0.41,0.75,0.51,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"T13+IF($H26=\"Urban\",1,0)*T14+IF(SUM($H44:$I44)=H27,1,0)*T15+H45*T16+$H42*T17+IF($H29=\"Yes\",1,0)*T18+$I42*T19+IF($I46>0,1,0)*T20+$H46*T21","v":-2.57},{"$f":"U13+IF($H26=\"Urban\",1,0)*U14+IF(SUM($H44:$I44)=H27,1,0)*U15+H45*U16+$H42*U17+IF($H29=\"Yes\",1,0)*U18+$I42*U19+IF($I46>0,1,0)*U20+$H46*U21","v":-1.0569999999999999},null,"Major config","Minor config","Config","Check",null,"4SG",0.27,0.37,0.37,0.27,0.36,0.36]
[null,null,"Input Data",null,null,null,null,"Value",null,"Advisory Messages",null,null,null,null,null,null,null,null,"P",{"$f":"EXP(T22)/(1/$H53+EXP($T22)+EXP($U22))","v":5.3745653307715358E-2},{"$f":"EXP(U22)/(1/$H53+EXP($T22)+EXP($U22))","v":0.24402307611034202},null,{"$f":"IF(H39=\"Two-way\",2,1)","v":2},{"$f":"IF(I39=\"Two-way\",2,1)","v":2},{"$f":"W23&\"x\"&X23","v":"2x2"},{"$f":"VLOOKUP(I41,S27:AA35,MATCH(H41,S27:AA27,0),FALSE)","v":1}]
[]
[null,null,"Intersection Data"]
[null,null,"Area type",null,null,null,null,"Urban",null,".",null,null,null,null,null,null,null,null,"Check values","Major",null,null,null,null,null,null,null,null,"2x2","Major",null,null,null,null,null,null,null,null,"1x2","Major",null,null,null,null,null,null,null,null,"1x1","Major"]
[null,null,"Number of legs",null,null,null,null,4,null,{"$f":"S7& \" intersection type\"","v":"4SG intersection type"},null,null,null,null,null,null,null,null,"Minor",1,2,3,4,5,6,7,8,null,"Minor",1,2,3,4,5,6,7,8,null,"Minor",1,2,3,4,5,6,7,8,null,"Minor",1,2,3,4,5,6,7,8]
[null,null,"Traffic control type",null,null,null,null,"Signalized",null,".",null,null,null,null,null,null,null,null,1,{"$f":"IF($Y$23=\"2x2\",AD28,IF($Y$23=\"1x2\",AN28,AX28))","v":0},0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0,null,1,0,0,0,0,0,0,0,0]
[null,null,"Lighting present?",null,null,null,null,"Yes",null,".",null,null,null,null,null,null,null,null,2,0,0,0,0,0,1,0,1,null,2,0,0,0,0,0,1,0,1,null,2,0,1,1,1,0,0,0,0,null,2,0,1,1,1,0,0,0,0]
[null,null,"Red-light cameras present?",null,null,null,null,"No",null,".",null,null,null,null,null,null,null,null,3,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,null,3,0,0,0,0,0,0,0,0,null,3,0,1,1,1,0,0,0,0]
[null,null,"Daily pedestrian volume crossing all legs (peds/day)",null,null,null,null,700,null,".",null,null,null,null,null,null,null,null,4,0,0,0,0,0,1,0,1,null,4,0,0,0,0,0,1,0,1,null,4,0,1,1,1,0,0,0,0,null,4,0,1,1,1,0,0,0,0]
[null,null,"Maximum number of lanes crossed by a pedestrian",null,null,null,null,7,null,".",null,null,null,null,null,null,null,null,5,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0,null,5,0,0,0,0,0,0,0,0]
[null,null,"Number of bus stops within 1,000 ft of intersection",null,null,null,null,0,null,".",null,null,null,null,null,null,null,null,6,0,0,0,1,0,1,0,1,null,6,0,0,0,1,0,1,0,1,null,6,0,1,1,1,0,0,0,0,null,6,0,0,0,0,0,0,0,0]
[null,null,"School(s) present within 1,000 ft of intersection?",null,null,null,null,"No",null,".",null,null,null,null,null,null,null,null,7,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0,null,7,0,0,0,0,0,0,0,0]
[null,null,"Alcohol sales establishments within 1,000 ft",null,null,null,null,0,null,".",null,null,null,null,null,null,null,null,8,0,1,0,1,0,1,0,1,null,8,0,1,0,1,0,1,0,1,null,8,0,1,1,1,0,0,0,0,null,8,0,0,0,0,0,0,0,0]
[]
[null,null,"Street Data",null,null,null,null,"Major","Minor",{"$f":"IF(AND(OR(H31>V45,MAX(H40:I40)>MAX(T45:U45),MIN(H40:I40)>MIN(T45:U45)),H28=\"Signalized\"),\"Beyond range of veh-ped crash model\", \".\")","v":"."},null,null,null,null,null,null,null,null,"Major",null,null,"Minor"]
[]
[null,null,"Street configuration",null,null,null,null,"Two-way","Two-way",{"$f":"IF(AND(H39=\"Two-way\",I39=\"One-way\"), \"Major street must be one-way.\",Y23&\" intersection configuration\")","v":"2x2 intersection configuration"},null,null,null,null,null,null,null,null,"Minimum","Maximum","Check","Minimum","Maximum","Check"]
[null,null,"Annual average daily traffic (AADT), veh/day",null,null,null,null,20000,10000,{"$f":"IF(AND(OR(Y23=\"1x1\",Y23=\"2x2\"),H40<I40),\"Major AADT must exceed minor AADT.\",IF(U40=0,\"Check major\" & IF(X40=0,\" & minor volume.\", \" volume.\"),IF(X40=0,\"Check minor volume.\",\".\")))","v":"."},null,null,null,null,null,null,null,null,0,{"$f":"VLOOKUP(Y23&\",\"&S7,AT8:AV19,2,FALSE)","v":137600},{"$f":"IF(AND(H40>S40,H40<T40),1,0)","v":1},0,{"$f":"VLOOKUP(Y23&\",\"&S7,AT8:AV19,3,FALSE)","v":68400},{"$f":"IF(AND(I40>V40,I40<W40),1,0)","v":1}]
[null,null,"Number of through lanes",null,null,null,null,6,4,{"$f":"IF(Z23=0,\"Invalid lane count combination.\",\".\")","v":"."}]
[null,null,"Number of approaches with left-turn lanes",null,null,null,null,2,2,{"$f":"IF(OR(AND(W23=1,H42=2),AND(X23=1,I42=2)),\"Can only have one left-turn lane.\",\".\")","v":"."},null,null,null,null,null,null,null,null,"Ped max values","Major","Minor","PedVol"]
[null,null,"Number of left-turn movements with protected phasing",null,null,null,null,2,0,{"$f":"IF(AND(Y23=\"1x1\",H43>0,I43>0),\"Can only have one left-turn movement.\",\".\")","v":"."},null,null,null,null,null,null,null,null,"3SG",74300,51500,34200]
[null,null,"Number of right-turn movements prohibited on red",null,null,null,null,2,0,{"$f":"IF(AND(Y23=\"1x1\",H44>0,I44>0),\"Can only have one right-turn movement.\",\".\")","v":"."},null,null,null,null,null,null,null,null,"4SG",80200,49100,12600]
[null,null,"Number of U-turn movements prohibited",null,null,null,null,0,2,".",null,null,null,null,null,null,null,null,"Value",{"$f":"VLOOKUP($S7,$S43:$V44,2,FALSE)","v":80200},{"$f":"VLOOKUP($S7,$S43:$V44,3,FALSE)","v":49100},{"$f":"VLOOKUP($S7,$S43:$V44,4,FALSE)","v":12600}]
[null,null,"Number of approaches with right-turn channelization",null,null,null,null,0,2,{"$f":"IF(AND(Y23=\"1x1\",H46>0, I46>0),\"Can only have one right-turn movement.\",\".\")","v":"."}]
[]
[null,null,"Calibration Factors",null,null,null,null,"Value",null,null,"Default Values"]
[]
[null,null,"Local calibration factor (C)",null,null,null,null,{"$f":"K50","v":1},null,null,1,null,null,null,null,null,null,null,"Configuration","PK|K+A",null,"fped for ST",3,4,null,"fbike","Two-way","One-way"]
[null,null,"Adjustment factor for pedestrians for stop control (fped)",null,null,null,null,4.9000000000000002E-2,null,null,{"$f":"VLOOKUP(H39,V50:X52,MATCH(H27,V50:X50,0),FALSE)","v":4.9000000000000002E-2},null,null,null,null,null,null,null,"Two-way Signalized",9.4E-2,null,"Two-way",5.0999999999999997E-2,4.9000000000000002E-2,null,"3ST",4.8000000000000001E-2,1.7999999999999999E-2]
[null,null,"Adjustment factor for bicyclists (fbike)",null,null,null,null,1.9E-2,null,null,{"$f":"VLOOKUP(S7,Z50:AB54,MATCH(H39,Z50:AB50,0),FALSE)","v":1.9E-2},null,null,null,null,null,null,null,"One-way Signalized",4.5999999999999999E-2,null,"One-way",1.4999999999999999E-2,0.02,null,"3SG",2.9000000000000001E-2,1.6E-2]
[null,null,"Severity distribution calibration factor, 2-way (Csdf,twi)",null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,"Two-way stop",4.2999999999999997E-2,null,null,null,null,null,"4ST",3.9E-2,2.1999999999999999E-2]
[null,null,"Severity distribution calibration factor, 1-way (Csdf,owi)",null,null,null,null,1,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG",1.9E-2,1.2E-2]
[null,null,"Probability of fatality given K+A severity (PK|K+A)",null,null,null,null,9.4E-2,null,null,{"$f":"VLOOKUP(S12,S51:T53,2,FALSE)","v":9.4E-2}]
[]
[null,null,null,null,null,"Manner of Collision Proportions"]
[null,null,"2x2 intersections",null,null,"3ST, F+I","3ST, PDO","3SG, F+I","3SG, PDO","4ST, F+I","4ST, PDO","4SG, F+I","4SG, PDO"]
[null,null,"Rear-end collision proportion",null,null,9.4E-2,0.154,0.12,0.189,7.9000000000000001E-2,9.8000000000000004E-2,8.3000000000000004E-2,0.14799999999999999]
[null,null,"Angle colllision proportion",null,null,0.76400000000000001,0.629,0.67600000000000005,0.55400000000000005,0.80600000000000005,0.70699999999999996,0.746,0.55200000000000005]
[]
[null,null,"1x2 or 1x1 intersections",null,null,"3ST, F+I","3ST, PDO","3SG, F+I","3SG, PDO","4ST, F+I","4ST, PDO","4SG, F+I","4SG, PDO"]
[null,null,"Rear-end collision proportion",null,null,0.1,0.1,0.111,0.14299999999999999,4.7E-2,6.5000000000000002E-2,0.03,5.8999999999999997E-2]
[null,null,"Angle colllision proportion",null,null,0.3,0.25,0.88900000000000001,0.57099999999999995,0.82199999999999995,0.70599999999999996,0.83699999999999997,0.73299999999999998]
[]
[null,null,"Crash Modification Factors",null,null,null,null,"F+I",null,null,"PDO"]
[]
[null,null,"Total-vehicle crash CMFs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value","F+I","PDO","Two-way,F+I","One-way,F+I","Two-way,PDO","One-way,PDO",null,null,"Proportions",{"$f":"VLOOKUP(S7,AB71:AC74,2,FALSE)","v":0.23499999999999999},null,"Street","Base #","P",null,"pra(mv+sv)(FI)",{"$f":"IF(Y23=\"2x2\",HLOOKUP(S7&\", F+I\", F58:M60,3,FALSE), HLOOKUP(S7&\", F+I\", F62:M64,3,FALSE))","v":0.746}]
[null,null,"Lighting",null,null,null,null,{"$f":"1-$T69*$S69*$AC68","v":0.91070000000000007},null,null,{"$f":"1-$U69*$S69*$AC68","v":0.91070000000000007},null,null,null,null,null,null,null,{"$f":"IF(H29=\"Yes\",1,0)","v":1},{"$f":"IF(H$39=\"Two-way\",V69,W69)","v":0.38},{"$f":"IF(H$39=\"Two-way\",X69,Y69)","v":0.38},0.38,0.38,0.38,0.38,null,null,null,null,null,"Major",{"$f":"IF(W23=2,6,2)","v":6},{"$f":"H40/(H40+I40)","v":0.66666666666666663},null,"pra(mv+sv)(PDO)",{"$f":"IF(Y23=\"2x2\",HLOOKUP(S7&\", PDO\", F58:M60,3,FALSE), HLOOKUP(S7&\", F+I\", F62:M64,3,FALSE))","v":0.55200000000000005}]
[null,null,"Red-light cameras",null,null,null,null,{"$f":"IF(H30=\"Yes\",1-AJ72*(1-AJ74)-AJ73*(1-AJ75),1)","v":1},null,null,{"$f":"IF(H30=\"Yes\",1-AJ72*(1-AJ74)-AJ73*(1-AJ75),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Configuration","Lighting",null,"Minor",2,{"$f":"I40/(H40+I40)","v":0.33333333333333331},null,"pre(mv+sv)(FI)",{"$f":"IF(Y23=\"2x2\",HLOOKUP(S7&\", F+I\", F58:M60,2,FALSE), HLOOKUP(S7&\", F+I\", F62:M64,2,FALSE))","v":8.3000000000000004E-2}]
[null,null,"Left-turn signal phasing",null,null,null,null,{"$f":"IF($H$28=\"Signalized\",$T71^$S71,1)","v":0.73959999999999992},null,null,{"$f":"IF($H$28=\"Signalized\",$U71^$S71,1)","v":0.73959999999999992},null,null,null,null,null,null,null,{"$f":"SUM(H43:I43)","v":2},{"$f":"IF(H$39=\"Two-way\",V71,W71)","v":0.86},{"$f":"IF(H$39=\"Two-way\",X71,Y71)","v":0.86},0.86,1,0.86,1,null,null,"3ST",0.23799999999999999,null,null,null,null,null,"pre(mv+sv)(PDO)",{"$f":"IF(Y23=\"2x2\",HLOOKUP(S7&\", PDO\", F58:M60,2,FALSE), HLOOKUP(S7&\", F+I\", F62:M64,2,FALSE))","v":0.14799999999999999}]
[null,null,"Right-turn-on-red",null,null,null,null,{"$f":"IF($H$28=\"Signalized\",$T72^$S72,1)","v":0.96039999999999992},null,null,{"$f":"IF($H$28=\"Signalized\",$U72^$S72,1)","v":0.96039999999999992},null,null,null,null,null,null,null,{"$f":"SUM(H44:I44)","v":2},{"$f":"IF(H$39=\"Two-way\",V72,W72)","v":0.98},{"$f":"IF(H$39=\"Two-way\",X72,Y72)","v":0.98},0.98,0.98,0.98,0.98,null,null,"3SG",0.23499999999999999,null,null,null,null,null,"pra",{"$f":"(AJ68*T11+AJ69*U11)/(T11+U11)","v":0.65051859907917386}]
[null,null,"U-turn prohibition",null,null,null,null,{"$f":"IF($H$28=\"Signalized\",$T73^$S73,1)","v":0.92159999999999997},null,null,{"$f":"IF($H$28=\"Signalized\",$U73^$S73,1)","v":0.92159999999999997},null,null,null,null,null,null,null,{"$f":"SUM(H45:I45)","v":2},{"$f":"IF(H$39=\"Two-way\",V73,W73)","v":0.96},{"$f":"IF(H$39=\"Two-way\",X73,Y73)","v":0.96},0.96,1,0.96,1,null,null,"4ST",0.22900000000000001,null,null,null,null,null,"pre",{"$f":"(AJ70*T11+AJ71*U11)/(T11+U11)","v":0.11499119103017373}]
[null,null,"Right-turn channelization",null,null,null,null,{"$f":"IF($H$28=\"Signalized\",EXP($T74*$S74),1)","v":1},null,null,{"$f":"IF($H$28=\"Signalized\",EXP($T74*$S74),1)","v":1},null,null,null,null,null,null,null,{"$f":"H46","v":0},{"$f":"IF(H$39=\"Two-way\",V74,W74)","v":0.2175},{"$f":"IF(H$39=\"Two-way\",X74,Y74)","v":0.2175},0.2175,0,0.2175,0,null,null,"4SG",0.23499999999999999,null,null,null,null,null,"cra",0.74]
[null,null,"Number of lanes",null,null,null,null,{"$f":"IF($H$28=\"Signalized\",(EXP(T75*(H41-AF69))*AG69+1-AG69)*(EXP(T75*(I41-AF70))*AG70+1-AG70),1)","v":1.158009928096047},null,null,{"$f":"IF($H$28=\"Signalized\",(EXP(U75*(H41-AF69))*AG69+1-AG69)*(EXP(U75*(I41-AF70))*AG70+1-AG70),1)","v":1.158009928096047},null,null,null,null,null,null,null,null,{"$f":"IF(H$39=\"Two-way\",V75,W75)","v":0.19400000000000001},{"$f":"IF(H$39=\"Two-way\",X75,Y75)","v":0.19400000000000001},0.19400000000000001,0.24199999999999999,0.19400000000000001,0.24199999999999999,null,null,null,null,null,null,null,null,null,"cre",1.18]
[]
[null,null,"Vehicle-pedestrian crash CMFs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value",0,1,2,3,4,5,6,7,8,"Max"]
[null,null,"Bus stops",null,null,null,null,{"$f":"HLOOKUP(S78,T$77:AC$80,2,FALSE)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H33<2,H33,\"Max\")","v":0},1,2.78,null,null,null,null,null,null,null,4.1500000000000004]
[null,null,"Schools",null,null,null,null,{"$f":"HLOOKUP(S79,T$77:AC$80,3,FALSE)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H34=\"No\",0,\"Max\")","v":0},1,null,null,null,null,null,null,null,null,1.35]
[null,null,"Alcohol sales establishments",null,null,null,null,{"$f":"HLOOKUP(S80,T$77:AC$80,4,FALSE)","v":1},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H35<9,H35,\"Max\")","v":0},1,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.56]

{"sheet":"Totals","index":4,"n_rows":40,"n_cols":100,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,17,3,26],[3,5,3,6],[7,17,7,18],[6,17,6,18],[8,8,8,13],[7,8,7,13],[6,8,6,13],[5,8,5,13],[4,8,4,13],[3,8,3,15],[4,21,4,22],[4,19,4,20],[8,17,8,18],[4,17,5,18],[46,46,46,47],[46,50,46,51],[29,52,29,55],[41,46,41,47],[41,50,41,51],[42,46,42,47],[42,50,42,51],[43,46,43,47],[43,50,43,51],[44,46,44,47],[44,50,44,51],[45,46,45,47],[45,50,45,51],[36,46,36,47],[36,50,36,51],[37,46,37,47],[37,50,37,51],[38,46,38,47],[38,50,38,51],[39,46,39,47],[39,50,39,51],[40,46,40,47],[40,50,40,51],[32,50,32,51],[32,46,32,47],[31,50,31,51],[31,46,31,47],[33,46,33,47],[33,50,33,51],[34,46,34,47],[34,50,34,51],[35,46,35,47],[35,50,35,51],[32,42,32,43],[31,42,31,43],[35,42,35,43],[36,42,36,43],[37,42,37,43],[38,42,38,43],[39,42,39,43],[40,42,40,43],[41,42,41,43],[42,38,42,39],[43,38,43,39],[44,38,44,39],[45,38,45,39],[46,38,46,39],[34,42,34,43],[33,42,33,43],[42,42,42,43],[43,42,43,43],[44,42,44,43],[45,42,45,43],[46,42,46,43],[34,38,34,39],[33,38,33,39],[32,38,32,39],[31,38,31,39],[35,38,35,39],[36,38,36,39],[37,38,37,39],[38,38,38,39],[39,38,39,39],[45,5,45,6],[45,7,45,8],[45,15,45,16],[45,17,45,18],[45,19,45,20],[45,27,45,28],[41,5,41,6],[41,7,41,8],[41,15,41,16],[41,17,41,18],[41,19,41,20],[41,27,41,28],[42,5,42,6],[40,38,40,39],[41,38,41,39],[42,7,42,8],[42,15,42,16],[46,5,46,6],[46,7,46,8],[46,15,46,16],[46,17,46,18],[46,19,46,20],[46,27,46,28],[43,5,43,6],[43,7,43,8],[43,15,43,16],[43,17,43,18],[43,19,43,20],[43,27,43,28],[44,5,44,6],[44,7,44,8],[44,15,44,16],[44,17,44,18],[44,19,44,20],[44,27,44,28],[44,21,44,22],[46,21,46,22],[46,23,46,24],[44,23,44,24],[45,21,45,22],[45,23,45,24],[42,17,42,18],[42,19,42,20],[42,27,42,28],[39,5,39,6],[39,7,39,8],[39,15,39,16],[39,17,39,18],[39,19,39,20],[39,27,39,28],[40,5,40,6],[40,7,40,8],[40,15,40,16],[40,17,40,18],[40,19,40,20],[40,27,40,28],[39,21,39,22],[39,23,39,24],[40,21,40,22],[40,23,40,24],[41,21,41,22],[41,23,41,24],[42,21,42,22],[42,23,42,24],[37,5,37,6],[37,7,37,8],[37,15,37,16],[37,17,37,18],[37,19,37,20],[37,27,37,28],[38,5,38,6],[38,7,38,8],[38,15,38,16],[38,17,38,18],[38,19,38,20],[38,27,38,28],[37,9,37,10],[38,9,38,10],[37,21,37,22],[37,23,37,24],[38,21,38,22],[38,23,38,24],[33,15,33,16],[32,15,32,16],[35,19,35,20],[35,27,35,28],[36,5,36,6],[36,7,36,8],[36,15,36,16],[36,17,36,18],[36,19,36,20],[36,27,36,28],[35,23,35,24],[36,21,36,22],[36,23,36,24],[35,5,35,6],[35,7,35,8],[35,15,35,16],[35,17,35,18],[35,21,35,22],[32,21,32,22],[34,5,34,6],[33,5,33,6],[32,5,32,6],[36,9,36,10],[31,5,31,6],[34,27,34,28],[33,27,33,28],[32,27,32,28],[31,27,31,28],[34,19,34,20],[33,19,33,20],[32,19,32,20],[31,19,31,20],[32,23,32,24],[33,21,33,22],[33,23,33,24],[31,15,31,16],[34,7,34,8],[33,7,33,8],[32,7,32,8],[34,21,34,22],[34,23,34,24],[31,7,31,8],[34,17,34,18],[33,17,33,18],[32,17,32,18],[31,17,31,18],[34,15,34,16],[10,48,10,51],[11,48,11,49],[11,50,11,51],[10,40,10,43],[11,40,11,41],[11,42,11,43],[10,36,10,39],[4,23,4,24],[11,38,11,39],[10,44,10,47],[11,44,11,45],[11,46,11,47],[10,35,12,35],[11,23,11,24],[11,9,11,10],[11,11,11,12],[29,34,31,34],[29,29,30,30],[10,29,11,30],[10,25,10,28],[11,25,11,26],[11,27,11,28],[10,34,12,34],[11,17,11,18],[11,19,11,20],[30,17,30,20],[30,11,30,12],[10,5,10,12],[10,13,10,16],[11,15,11,16],[11,13,11,14],[16,9,16,10],[30,13,30,14],[30,15,30,16],[29,13,29,16],[11,7,11,8],[30,5,30,8],[24,21,24,22],[5,1,5,2],[11,5,11,6],[15,9,15,10],[14,9,14,10],[13,9,13,10],[18,9,18,10],[19,9,19,10],[29,44,29,47],[10,52,10,56],[29,40,29,43],[10,17,10,24],[27,11,27,12],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[24,11,24,12],[25,11,25,12],[26,11,26,12],[29,1,30,4],[10,1,11,4],[29,5,29,12],[30,9,30,10],[22,23,22,24],[23,21,23,22],[23,23,23,24],[18,23,18,24],[19,21,19,22],[19,23,19,24],[30,38,30,39],[30,21,30,22],[30,23,30,24],[29,25,29,28],[20,21,20,22],[20,23,20,24],[27,21,27,22],[27,23,27,24],[29,36,29,39],[30,36,30,37],[24,23,24,24],[25,21,25,22],[25,23,25,24],[26,21,26,22],[26,23,26,24],[30,25,30,26],[30,27,30,28],[30,52,31,52],[30,53,30,54],[11,55,11,56],[11,53,11,54],[11,52,12,52],[29,48,29,51],[30,48,30,49],[30,50,30,51],[30,44,30,45],[30,46,30,47],[30,40,30,41],[30,42,30,43],[11,36,11,37],[12,21,12,22],[12,23,12,24],[31,21,31,22],[31,23,31,24],[13,21,13,22],[13,23,13,24],[14,21,14,22],[14,23,14,24],[15,21,15,22],[15,23,15,24],[16,21,16,22],[16,23,16,24],[17,21,17,22],[17,23,17,24],[18,21,18,22],[21,21,21,22],[21,23,21,24],[22,21,22,22],[29,35,31,35],[29,17,29,24],[11,21,11,22],[43,21,43,22],[43,23,43,24],[12,9,12,10],[12,11,12,12],[31,9,31,10],[31,11,31,12],[33,11,33,12],[32,11,32,12],[33,9,33,10],[32,9,32,10],[17,11,17,12],[16,11,16,12],[15,11,15,12],[14,11,14,12],[13,11,13,12],[17,9,17,10],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[25,9,25,10],[26,9,26,10],[44,9,44,10],[27,9,27,10],[45,9,45,10],[46,9,46,10],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[34,9,34,10],[35,9,35,10]]}
[null,{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},{"$f":"COLUMN()","v":46},{"$f":"COLUMN()","v":47},{"$f":"COLUMN()","v":48},{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50},{"$f":"COLUMN()","v":51},{"$f":"COLUMN()","v":52},{"$f":"COLUMN()","v":53},{"$f":"COLUMN()","v":54},{"$f":"COLUMN()","v":55},{"$f":"COLUMN()","v":56},{"$f":"COLUMN()","v":57},{"$f":"COLUMN()","v":58},{"$f":"COLUMN()","v":59},{"$f":"COLUMN()","v":60},{"$f":"COLUMN()","v":61},{"$f":"COLUMN()","v":62},{"$f":"COLUMN()","v":63},{"$f":"COLUMN()","v":64},{"$f":"COLUMN()","v":65},{"$f":"COLUMN()","v":66},{"$f":"COLUMN()","v":67},{"$f":"COLUMN()","v":68},{"$f":"COLUMN()","v":69},{"$f":"COLUMN()","v":70},{"$f":"COLUMN()","v":71},{"$f":"COLUMN()","v":72},{"$f":"COLUMN()","v":73},{"$f":"COLUMN()","v":74},{"$f":"COLUMN()","v":75},{"$f":"COLUMN()","v":76},{"$f":"COLUMN()","v":77},{"$f":"COLUMN()","v":78},{"$f":"COLUMN()","v":79},{"$f":"COLUMN()","v":80},{"$f":"COLUMN()","v":81},{"$f":"COLUMN()","v":82},{"$f":"COLUMN()","v":83},{"$f":"COLUMN()","v":84},{"$f":"COLUMN()","v":85},{"$f":"COLUMN()","v":86},{"$f":"COLUMN()","v":87},{"$f":"COLUMN()","v":88},{"$f":"COLUMN()","v":89},{"$f":"COLUMN()","v":90},{"$f":"COLUMN()","v":91},{"$f":"COLUMN()","v":92},{"$f":"COLUMN()","v":93},{"$f":"COLUMN()","v":94},{"$f":"COLUMN()","v":95},{"$f":"COLUMN()","v":96},{"$f":"COLUMN()","v":97},{"$f":"COLUMN()","v":98},{"$f":"COLUMN()","v":99},{"$f":"COLUMN()","v":100}]
[null,"Crash Totals Tabulation"]
[]
[null,"Empirical Bayes",null,null,null,"Facility Totals",null,null,"Project-Level Observed Crash Totals",null,null,null,null,null,null,null,null,"Total Predicted Crash Frequency, crashes / year",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,null,null,null,null,null,null,null,null,"Npredicted:",null,"w0:"]
[null,"adjustment type:",null,null,null,"MV+SV:",null,null,"Crash type",null,null,null,null,null,"F+I","PDO",null,"Site type",null,"Multiple-vehicle",null,"Single-vehicle",null,"Total-vehicle",null,"Veh-ped","Veh-bike",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,"Nobserved:",null,"N0:"]
[null,"None",null,null,null,"VP+VB:",null,null,"Multiple-vehicle crashes on segments:",null,null,null,null,null,9,12,null,null,null,"F+I","PDO","F+I","PDO","F+I","PDO","F+I","F+I",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,"Npredictedw0:",null,"w1:"]
[null,null,null,null,null,"F+I:",null,null,"Single-vehicle crashes on segments:",null,null,null,null,null,3,4,null,"Segments:",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,null,null,null,null,null,null,null,null,"Npredictedw1:",null,"N1:",null,"Nexpected:"]
[null,null,null,null,null,"PDO:",null,null,"Total-vehicle crashes at all intersections:",null,null,null,null,null,7,9,null,"Intersections:"]
[null,null,null,null,null,"Total:",null,null,"Vehicle-pedestrian crashes at signalized intersections:",null,null,null,null,null,2,null,null,"Total:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Archived 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,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,null,null,null,null,null,null,null,null,null,null,null,null,"Origin sheet",null,"Values"]
[null,"Segment Site Information",null,null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,null,null,"Site-specific observed crash totals",null,null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,null,null,"Combined CMF",null,null,null,"Location information",null,null,null,null,"Length","Sum lookup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inverse dispersion parameter coefficients"]
[null,null,null,null,null,"Multiple-vehicle",null,"Single-vehicle",null,"Vehicle-pedestrian",null,"Vehicle-bicycle",null,"Multiple-vehicle",null,"Single-vehicle",null,"Multiple-vehicle",null,"Single-vehicle",null,"Vehicle-pedestrian",null,"Vehicle-bicycle",null,"Multiple-vehicle",null,"Single-vehicle",null,null,null,null,null,null,null,null,"Multiple-vehicle",null,"Single-vehicle",null,"Multiple-vehicle",null,"Single-vehicle",null,"Multiple-vehicle",null,"Single-vehicle",null,"Multiple-vehicle",null,"Single-vehicle",null,"Type","Multiple-vehicle",null,"Single-vehicle",null,null,null,"Multiple-vehicle",null,"Single-vehicle"]
[null,"Number","Year","Type","Street number","F+I","PDO","F+I","PDO","F+I",null,"F+I",null,"F+I","PDO","F+I","PDO","F+I","PDO","F+I","PDO","F+I",null,"F+I",null,"F+I","PDO","F+I","PDO","Location","Street name",null,null,null,null,null,"MV F+I","MV PDO","SV F+I","SV PDO","MV F+I","MV PDO","SV F+I","SV PDO","MV F+I","MV PDO","SV F+I","SV PDO","MV F+I","MV PDO","SV F+I","SV PDO",null,"MV F+I","MV PDO","SV F+I","SV PDO",null,"Type","MV F+I","MV PDO","SV F+I","SV PDO"]
[null,1,2011,"6D","SH 1",5.492259873130509,7.3888943867518488,0.94790160183686833,1.1668041011507841,0.22493789944305015,null,0.11996687970296009,null,7,9,2,3,null,null,null,null,null,null,null,null,1.0348432852132634,1.0348432852132634,2.3996101281298938,2.3996101281298938,"City of Fillmore","Main Street",null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Npredicted",null,null,null,null,null,"6U",2.87,3,3.08,1.97,null,"Two-way segments",null,"MPP","TTI","2015-11-06","City of Fillmore","SH 1","Main Street",1,2011,"Suburban","6D",0.4,90000,0,45,"No",6,1,7,11,1.5,13,"Yes",18,7]
[null,1,2011,"3O","SH 1",1.2444628980119277,2.9859398390324539,0.22697744108642517,0.30875565256216558,0.11438725993663135,null,5.2427494137622696E-2,null,2,3,1,1,null,null,null,null,null,null,null,null,1.3700537874749996,1.3700537874749996,1.2969359226026758,1.2969359226026758,"City of Fillmore","Main Street",null,null,null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nobserved",null,null,null,null,null,"6D",2.0499999999999998,1.91,1.5,2,null,"One-way segments",null,"MPP","TTI","2015-11-06","City of Fillmore","SH 1","Main Street",1,2011,"Suburban","3O",0.4,"No",17500,30,"No",6,7,11,1.5,0,0,0,0,18,7]
[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,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,"Npredictedw0",null,null,null,null,null,"7T",1.3,1.08,3.08,1.97]
[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,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,"Npredictedw1",null,null,null,null,null,"8D",2.4900000000000002,1.67,2.0099999999999998,1.84]
[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,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,null,null,null,null,null,null,"2O",2.12,2.46,1.19,2.12]
[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,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,null,null,null,null,null,null,"3O",2.57,2.4500000000000002,1.94,1.98]
[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,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,null,null,null,null,null,null,"4O",2.46,2.52,1.94,1.98]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Intersection Site Information",null,null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,null,null,"Site-specific observed crash totals",null,null,null,"Predicted crash frequency, crashes / year",null,null,null,null,null,null,null,"Combined CMF",null,null,null,"Location information",null,null,null,null,"Type","Sum lookup",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inverse dispersion parameter coefficients"]
[null,null,null,null,null,"Total-vehicle",null,null,null,"Vehicle-pedestrian",null,"Vehicle-bicycle",null,"Total-vehicle",null,"Vehicle-pedestrian",null,"Total-vehicle",null,null,null,"Vehicle-pedestrian",null,"Vehicle-bicycle",null,"Total-vehicle",null,"Vehicle-pedestrian",null,null,null,null,null,null,null,null,"Total-vehicle",null,"Vehicle-pedestrian",null,"Total-vehicle",null,"Vehicle-pedestrian",null,"Total-vehicle",null,"Vehicle-pedestrian",null,"Total-vehicle",null,"Vehicle-pedestrian",null,"Type","Total-vehicle",null,"Veh-ped",null,null,null,"Total-vehicle",null,"Veh-ped"]
[null,"Number","Year","Type","Configuration","F+I",null,"PDO",null,"F+I",null,"F+I",null,"F+I","PDO","F+I",null,"F+I",null,"PDO",null,"F+I",null,"F+I",null,"F+I","PDO","F+I",null,"Major street name","Minor street name",null,null,null,null,null,"TV F+I","TV PDO","VP F+I",null,"TV F+I","TV PDO","VP F+I",null,"TV F+I","TV PDO","VP F+I",null,"TV F+I","TV PDO","VP F+I",null,null,"TV F+I","TV PDO","VP F+I",null,null,"Type & configuration","TV F+I","TV PDO","VP F+I"]
[null,1,2011,"4SG","Two-way",2.1766675903098558,null,2.1095638062689228,null,9.4547677120289553E-2,null,8.1438396534996793E-2,null,3,3,2,null,null,null,null,null,null,null,null,null,0.52505495777761613,0.52505495777761613,1,null,"Main Street","Cross Street",null,null,null,"4SG, Two-way",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Npredicted",null,null,null,null,null,"3ST, Two-way",1.54,1.34,null,null,null,"Intersections",null,"MPP","TTI","2015-11-06","City of Fillmore","Main Street","Cross Street",1,2011,"Urban",4,"Signalized","Yes","No",700,7,0,"No",0,"Two-way",20000,6,2,2,2,0,0,"Two-way",10000,4,2,0,0,2,2]
[null,1,2011,"4ST","Two-way",3.4760224008788354,null,4.8976406411371336,null,0.41030948905878256,null,0.32657285863862284,null,4,6,null,null,null,null,null,null,null,null,null,null,1.0572399041531291,1.0572399041531291,1,null,"Main Street","Cross Street",null,null,null,"4ST, Two-way",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nobserved",null,null,null,null,null,"3SG, Two-way",1.93,1,0.52,null,null,"Intersections",null,"MPP","TTI","2015-11-06","City of Fillmore","Main Street","Cross Street",1,2011,"Urban",4,"Two-way stop","Yes","No",700,7,0,"No",0,"Two-way",20000,6,2,2,2,0,0,"Two-way",10000,4,2,0,0,2,2]
[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,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,"Npredictedw0",null,null,null,null,null,"4ST, Two-way",1.67,0.88]
[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,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,"Npredictedw1",null,null,null,null,null,"4SG, Two-way",1.77,1.01,0.24]
[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,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,null,null,null,null,null,null,"3ST, One-way",0.5,0.97]
[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,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,null,null,null,null,null,null,"3SG, One-way",1.05,1.1100000000000001,0.52]
[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,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,null,null,null,null,null,null,"4ST, One-way",1.88,1.04]
[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,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,null,null,null,null,null,null,"4SG, One-way",0.75,0.5,0.24]