{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Step 1_Risk Calculator","Step 2-3_Benefit & Cost Calc","Other Parameter Lookup","Risk Factor Weights Lookup","CMF Lookup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[27,0,27,5],[21,0,22,1],[21,3,22,12],[24,3,24,12],[0,1,0,12],[1,1,1,12],[2,1,2,12],[4,0,4,12],[18,0,19,1],[18,3,19,12],[6,0,7,12],[3,0,3,12]]}
[null,"OREGON DEPARTMENT OF TRANSPORTATION"]
[null,"Highway Safety Projects "]
[null,"RISK-BASED CEI ANALYSIS WORKSHEET"]
["October 2023"]
["Instructions"]
["Background"]
["The risk factors and weighting factors contained in this tool were developed using a combination of national research, the Oregon Statewide Pedestrian and Bicycle Safety Plan, and statistical analysis (overrepresentation analysis) of bicycle and pedestrian crashes on state highways in Oregon. This worksheet should be used for all ARTS Systemic Bicycle/Pedestrian applications."]
[]
["Link to Oregon Pedestrian and Bicycle Plan"]
[]
["Worksheets"]
[]
["This spreadsheet contains following worksheets:"]
[]
["Worksheet Name",null,null,"When to Use"]
[]
["Instructions",null,null,"Current worksheet displaying overview and instructions on how to use this spreadsheet."]
[]
["Step 1_Risk Calculator",null,null,"This worksheet calculates a bicycle and pedestrian risk score based on site characteristics. Fill in all required site information for ALL sites included in a single application. This spreadsheet is designed to accommodate up to ten sites (intersections or segments) in one application. If your application includes more than ten sites, please contact Christina McDaniel-Wilson for a modified spreadsheet."]
[]
[]
["Step 2-3_Benefit & Cost Calculator",null,null,"This worksheet calculates the potential risk reduction based on the selected countermeasures. The final Risk Reducton-Cost Ratio is also displayed on this sheet. Fill in all required treatment and cost information for ALL sites included in a single application. Each site may have the same countermeasures or you may apply a mix of countermeasures to your sites; However, the risk assessment has a maximum of three unique countermeasures for your entire application. Applicants are encouraged to provide site-specific project costs. If only the total project cost is available, enter it under Site 1 and enter zero for all other sites."]
[]
[]
[]
["Important: an interest rate of 5% has been used to calculate Present Worth Factor (PWF)."]
[]
["COLOR CODING"]
[]
[null,null,null,"Auto calculated/generated fields"]
[]
[null,null,null,"Required user inputs"]
[]
[null,null,null,"Interim calculations used in the final RRC"]
[]
[null,null,null,"Supporting Information"]
[]
[]
[]
["Contact"]
[]
["If you have any questions on this workbook, please contact:"]
[]
["Christina McDaniel-Wilson, PE, RSP1"]
["State Traffic Safety Engineer"]
["Oregon Department of Transportation"]
["christina.a.mcdaniel-wilson@odot.state.or.us"]
["(503) 986-3573"]

{"sheet":"Step 1_Risk Calculator","index":1,"n_rows":25,"n_cols":34,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,4,23,5],[23,7,23,8],[23,10,23,11],[8,0,9,0],[11,0,13,0],[20,0,22,0],[14,0,19,0],[8,8,9,8],[8,14,9,14],[1,0,1,10],[4,0,7,0],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[6,7,6,8],[4,13,4,14],[8,11,9,11],[4,7,4,8],[7,7,7,8],[6,10,6,11],[5,10,5,11],[5,7,5,8],[4,10,4,11],[8,33,9,33],[24,4,24,5],[24,7,24,8],[24,10,24,11],[24,13,24,14],[24,16,24,17],[23,19,23,20],[23,16,23,17],[8,17,9,17],[8,20,9,20],[24,19,24,20],[23,13,23,14],[8,5,9,5],[23,22,23,23],[24,22,24,23],[23,25,23,26],[7,10,7,11],[7,19,7,20],[6,19,6,20],[5,19,5,20],[4,19,4,20],[7,13,7,14],[6,13,6,14],[5,13,5,14],[7,16,7,17],[6,16,6,17],[5,16,5,17],[4,16,4,17],[24,25,24,26],[4,22,4,23],[5,22,5,23],[6,22,6,23],[7,22,7,23],[8,23,9,23],[4,25,4,26],[5,25,5,26],[6,25,6,26],[7,25,7,26],[8,26,9,26],[23,28,23,29],[24,28,24,29],[4,31,4,32],[5,31,5,32],[6,31,6,32],[7,31,7,32],[8,32,9,32],[23,31,23,32],[24,31,24,32],[4,28,4,29],[5,28,5,29],[6,28,6,29],[7,28,7,29],[8,29,9,29]]}
[]
["   Step 1: Enter location details for each site included in your application. Risk scores are automatically calculated for each site."]
[]
[null,"Data Input","Notes",null,"Site 1","Site 1 Risk Score",null,"Site 2","Site 2 Risk Score",null,"Site 3","Site 3 Risk Score",null,"Site 4","Site 4 Risk Score",null,"Site 5","Site 5 Risk Score",null,"Site 6","Site 6 Risk Score",null,"Site 7","Site 7 Risk Score",null,"Site 8","Site 8 Risk Score",null,"Site 9","Site 9 Risk Score",null,"Site 10","Site 10 Risk Score","Total Score"]
["Project Site Details","Location Description","Include intersecting street names or segment start/end points. Include milepoints, if applicable.",null,null,null,null,null,null,"Market Street at Childs Place"]
[null,"Intersection or Segment"]
[null,"Segment Length (miles)","0.25 mile minimum"]
[null,"Context","Rural or Urban"]
["Crash History","Has a Minor or Possible Injury Crash involving a Bicyclist or Pedestrian occurred here?","Most recent five years of ODOT official data",null,null,{"$f":"IF(AND(E9=\"\",E10=\"\"),\"\",IF(E10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(E9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(H9=\"\",H10=\"\"),\"\",IF(H10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(H9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(K9=\"\",K10=\"\"),\"\",IF(K10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(K9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(N9=\"\",N10=\"\"),\"\",IF(N10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(N9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(Q9=\"\",Q10=\"\"),\"\",IF(Q10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(Q9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(T9=\"\",T10=\"\"),\"\",IF(T10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(T9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(W9=\"\",W10=\"\"),\"\",IF(W10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(W9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(Z9=\"\",Z10=\"\"),\"\",IF(Z10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(Z9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(AC9=\"\",AC10=\"\"),\"\",IF(AC10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(AC9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},null,null,{"$f":"IF(AND(AF9=\"\",AF10=\"\"),\"\",IF(AF10='Risk Factor Weights Lookup'!$B$6,'Risk Factor Weights Lookup'!$C$6*'Risk Factor Weights Lookup'!$C$2,IF(AF9='Risk Factor Weights Lookup'!$B$4,'Risk Factor Weights Lookup'!$C$4*'Risk Factor Weights Lookup'!$C$2,'Risk Factor Weights Lookup'!$C$3*'Risk Factor Weights Lookup'!$C$2)))","v":""},{"$f":"AVERAGE(F9,I9,L9,O9,R9,U9,X9,AA9,AD9,AG9)","v":{"$error":"#DIV/0!"}}]
[null,"Has a Fatal or Serious Injury Crash involving a Bicyclist or Pedestrian occurred here?","Most recent five years of ODOT official data"]
["Equity","Oregon Social Equity Index Disparity Level","Select  the highest disparity adjacent to the site. Click Here for ODOT Social Equity Web Map",null,null,{"$f":"IF(E11=\"\",\"\",IF(E11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(E11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(E11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(E11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(H11=\"\",\"\",IF(H11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(H11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(H11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(H11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(K11=\"\",\"\",IF(K11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(K11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(K11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(K11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(N11=\"\",\"\",IF(N11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(N11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(N11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(N11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(Q11=\"\",\"\",IF(Q11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(Q11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(Q11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(Q11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(T11=\"\",\"\",IF(T11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(T11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(T11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(T11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(W11=\"\",\"\",IF(W11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(W11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(W11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(W11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(Z11=\"\",\"\",IF(Z11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(Z11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(Z11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(Z11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(AC11=\"\",\"\",IF(AC11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(AC11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(AC11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(AC11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},null,null,{"$f":"IF(AF11=\"\",\"\",IF(AF11='Risk Factor Weights Lookup'!$B$59,'Risk Factor Weights Lookup'!$C$59*'Risk Factor Weights Lookup'!$C$58,IF(AF11='Risk Factor Weights Lookup'!$B$60,'Risk Factor Weights Lookup'!$C$60*'Risk Factor Weights Lookup'!$C$58,IF(AF11='Risk Factor Weights Lookup'!$B$61,'Risk Factor Weights Lookup'!$C$61*'Risk Factor Weights Lookup'!$C$58,IF(AF11='Risk Factor Weights Lookup'!$B$62,'Risk Factor Weights Lookup'!$C$62*'Risk Factor Weights Lookup'!$C$58)))))","v":""},{"$f":"AVERAGE(U11,R11,O11,L11,I11,F11,X11,AA11,AD11,AG11)","v":{"$error":"#DIV/0!"}}]
["Exposure","Crossing Distance (Number of Lanes)","Highest number of lanes crossed by a pedestrian on any leg. Include through and turn lanes, exclude medians.",null,null,{"$f":"IF(E12=\"\",\"\",IF(E12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(E12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(E12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(E12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(E12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(H12=\"\",\"\",IF(H12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(H12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(H12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(H12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(H12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(K12=\"\",\"\",IF(K12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(K12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(K12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(K12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(K12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(N12=\"\",\"\",IF(N12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(N12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(N12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(N12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(N12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(Q12=\"\",\"\",IF(Q12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(Q12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(Q12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(Q12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(Q12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(T12=\"\",\"\",IF(T12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(T12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(T12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(T12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(T12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(W12=\"\",\"\",IF(W12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(W12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(W12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(W12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(W12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(Z12=\"\",\"\",IF(Z12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(Z12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(Z12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(Z12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(Z12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(AC12=\"\",\"\",IF(AC12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(AC12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(AC12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(AC12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(AC12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},null,null,{"$f":"IF(AF12=\"\",\"\",IF(AF12='Risk Factor Weights Lookup'!$B$65,'Risk Factor Weights Lookup'!$C$65*'Risk Factor Weights Lookup'!$C$64,IF(AF12='Risk Factor Weights Lookup'!$B$66,'Risk Factor Weights Lookup'!$C$66*'Risk Factor Weights Lookup'!$C$64,IF(AF12='Risk Factor Weights Lookup'!$B$67,'Risk Factor Weights Lookup'!$C$67*'Risk Factor Weights Lookup'!$C$64,IF(AF12='Risk Factor Weights Lookup'!$B$68,'Risk Factor Weights Lookup'!$C$68*'Risk Factor Weights Lookup'!$C$64,IF(AF12='Risk Factor Weights Lookup'!$B$69,'Risk Factor Weights Lookup'!$C$69*'Risk Factor Weights Lookup'!$C$64))))))","v":""},{"$f":"AVERAGE(U12,R12,O12,L12,I12,F12,X12,AA12,AD12,AG12)","v":{"$error":"#DIV/0!"}}]
[null,"Average Annual Daily Traffic Volume ","For intersections, enter the AADT of the higher volume (major) roadway.",null,null,{"$f":"IF(E13=\"\",\"\",IF(E13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(E13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(E13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(E13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(E13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(H13=\"\",\"\",IF(H13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(H13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(H13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(H13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(H13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(K13=\"\",\"\",IF(K13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(K13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(K13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(K13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(K13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(N13=\"\",\"\",IF(N13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(N13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(N13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(N13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(N13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(Q13=\"\",\"\",IF(Q13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(Q13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(Q13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(Q13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(Q13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(T13=\"\",\"\",IF(T13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(T13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(T13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(T13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(T13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(W13=\"\",\"\",IF(W13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(W13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(W13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(W13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(W13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(Z13=\"\",\"\",IF(Z13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(Z13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(Z13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(Z13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(Z13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(AC13=\"\",\"\",IF(AC13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(AC13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(AC13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(AC13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(AC13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},null,null,{"$f":"IF(AF13=\"\",\"\",IF(AF13='Risk Factor Weights Lookup'!$B$9,'Risk Factor Weights Lookup'!$C$9*'Risk Factor Weights Lookup'!$C$8,IF(AF13='Risk Factor Weights Lookup'!$B$10,'Risk Factor Weights Lookup'!$C$10*'Risk Factor Weights Lookup'!$C$8,IF(AF13='Risk Factor Weights Lookup'!$B$11,'Risk Factor Weights Lookup'!$C$11*'Risk Factor Weights Lookup'!$C$8,IF(AF13='Risk Factor Weights Lookup'!$B$12,'Risk Factor Weights Lookup'!$C$12*'Risk Factor Weights Lookup'!$C$8,IF(AF13='Risk Factor Weights Lookup'!$B$13,'Risk Factor Weights Lookup'!$C$13*'Risk Factor Weights Lookup'!$C$8))))))","v":""},{"$error":"#DIV/0!"}]
[null,"Number of multimodal attractors within 1/4 mile","May include: high density residential, convenience store, fast food restaurant, school, park, offices, transit stop, parking garage",null,null,{"$f":"IF(E14=\"\",\"\",IF(E14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(E14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(E14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(E14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(H14=\"\",\"\",IF(H14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(H14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(H14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(H14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(K14=\"\",\"\",IF(K14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(K14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(K14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(K14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(N14=\"\",\"\",IF(N14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(N14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(N14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(N14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(Q14=\"\",\"\",IF(Q14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(Q14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(Q14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(Q14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(T14=\"\",\"\",IF(T14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(T14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(T14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(T14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(W14=\"\",\"\",IF(W14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(W14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(W14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(W14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(Z14=\"\",\"\",IF(Z14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(Z14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(Z14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(Z14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(AC14=\"\",\"\",IF(AC14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(AC14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(AC14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(AC14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},null,null,{"$f":"IF(AF14=\"\",\"\",IF(AF14='Risk Factor Weights Lookup'!$B$16,'Risk Factor Weights Lookup'!$C$16*'Risk Factor Weights Lookup'!$C$15,IF(AF14='Risk Factor Weights Lookup'!$B$17,'Risk Factor Weights Lookup'!$C$17*'Risk Factor Weights Lookup'!$C$15,IF(AF14='Risk Factor Weights Lookup'!$B$18,'Risk Factor Weights Lookup'!$C$18*'Risk Factor Weights Lookup'!$C$15,IF(AF14='Risk Factor Weights Lookup'!$B$19,'Risk Factor Weights Lookup'!$C$19*'Risk Factor Weights Lookup'!$C$15)))))","v":""},{"$error":"#DIV/0!"}]
["Roadway Characteristics","Sidewalk Facilities","Presence of sidewalks on both sides of the road/all intersection approaches",null,null,{"$f":"IF(E15=\"\",\"\",IF(E15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(E15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(E15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(H15=\"\",\"\",IF(H15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(H15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(H15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(K15=\"\",\"\",IF(K15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(K15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(K15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(N15=\"\",\"\",IF(N15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(N15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(N15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(Q15=\"\",\"\",IF(Q15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(Q15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(Q15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(T15=\"\",\"\",IF(T15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(T15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(T15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(W15=\"\",\"\",IF(W15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(W15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(W15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(Z15=\"\",\"\",IF(Z15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(Z15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(Z15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(AC15=\"\",\"\",IF(AC15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(AC15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(AC15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},null,null,{"$f":"IF(AF15=\"\",\"\",IF(AF15='Risk Factor Weights Lookup'!$B$54,'Risk Factor Weights Lookup'!$C$54*'Risk Factor Weights Lookup'!$C$53,IF(AF15='Risk Factor Weights Lookup'!$B$55,'Risk Factor Weights Lookup'!$C$55*'Risk Factor Weights Lookup'!$C$53,IF(AF15='Risk Factor Weights Lookup'!$B$56,'Risk Factor Weights Lookup'!$C$56*'Risk Factor Weights Lookup'!$C$53))))","v":""},{"$error":"#DIV/0!"}]
[null,"Bicycle Facilities","Presence of bicycle lanes (excludes shared lanes) on both sides of the road or all intersection approaches",null,null,{"$f":"IF(E16=\"\",\"\",IF(E16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(E16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(E16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(H16=\"\",\"\",IF(H16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(H16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(H16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(K16=\"\",\"\",IF(K16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(K16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(K16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(N16=\"\",\"\",IF(N16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(N16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(N16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(Q16=\"\",\"\",IF(Q16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(Q16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(Q16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(T16=\"\",\"\",IF(T16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(T16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(T16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(W16=\"\",\"\",IF(W16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(W16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(W16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(Z16=\"\",\"\",IF(Z16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(Z16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(Z16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(AC16=\"\",\"\",IF(AC16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(AC16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(AC16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},null,null,{"$f":"IF(AF16=\"\",\"\",IF(AF16='Risk Factor Weights Lookup'!$B$49,'Risk Factor Weights Lookup'!$C$49*'Risk Factor Weights Lookup'!$C$48,IF(AF16='Risk Factor Weights Lookup'!$B$50,'Risk Factor Weights Lookup'!$C$50*'Risk Factor Weights Lookup'!$C$48,IF(AF16='Risk Factor Weights Lookup'!$B$51,'Risk Factor Weights Lookup'!$C$51*'Risk Factor Weights Lookup'!$C$48))))","v":""},{"$error":"#DIV/0!"}]
[null,"Adjacent Signalized Crossing Spacing","Average spacing along a segment, or minimum spacing to next signal for intersections. RRFBs and PHBs are considered signalized crossings",null,null,{"$f":"IF(E17=\"\",\"\",IF(E17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(E17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(H17=\"\",\"\",IF(H17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(H17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",IF(K17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(K17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(N17=\"\",\"\",IF(N17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(N17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(Q17=\"\",\"\",IF(Q17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(Q17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(T17=\"\",\"\",IF(T17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(T17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(W17=\"\",\"\",IF(W17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(W17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(Z17=\"\",\"\",IF(Z17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(Z17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(AC17=\"\",\"\",IF(AC17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(AC17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},null,null,{"$f":"IF(AF17=\"\",\"\",IF(AF17='Risk Factor Weights Lookup'!$B$22,'Risk Factor Weights Lookup'!$C$22*'Risk Factor Weights Lookup'!$C$21,IF(AF17='Risk Factor Weights Lookup'!$B$23,'Risk Factor Weights Lookup'!$C$23*'Risk Factor Weights Lookup'!$C$21)))","v":""},{"$error":"#DIV/0!"}]
[null,"Access Density (accesses per mile)","Includes driveways, alleys, and public streets on both sides of the road",null,null,{"$f":"IF(E6=\"Intersection\",\"N/A\",IF(E18=\"\",\"\",IF(E18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(E18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(E18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(E18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(H6=\"Intersection\",\"N/A\",IF(H18=\"\",\"\",IF(H18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(H18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(H18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(H18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(K6=\"Intersection\",\"N/A\",IF(K18=\"\",\"\",IF(K18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(K18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(K18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(K18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(N6=\"Intersection\",\"N/A\",IF(N18=\"\",\"\",IF(N18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(N18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(N18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(N18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(Q6=\"Intersection\",\"N/A\",IF(Q18=\"\",\"\",IF(Q18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(Q18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(Q18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(Q18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(T6=\"Intersection\",\"N/A\",IF(T18=\"\",\"\",IF(T18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(T18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(T18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(T18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(W6=\"Intersection\",\"N/A\",IF(W18=\"\",\"\",IF(W18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(W18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(W18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(W18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(Z6=\"Intersection\",\"N/A\",IF(Z18=\"\",\"\",IF(Z18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(Z18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(Z18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(Z18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(AC6=\"Intersection\",\"N/A\",IF(AC18=\"\",\"\",IF(AC18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(AC18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(AC18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(AC18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},null,null,{"$f":"IF(AF6=\"Intersection\",\"N/A\",IF(AF18=\"\",\"\",IF(AF18='Risk Factor Weights Lookup'!$B$26,'Risk Factor Weights Lookup'!$C$26*'Risk Factor Weights Lookup'!$C$25,IF(AF18='Risk Factor Weights Lookup'!$B$27,'Risk Factor Weights Lookup'!$C$27*'Risk Factor Weights Lookup'!$C$25,IF(AF18='Risk Factor Weights Lookup'!$B$28,'Risk Factor Weights Lookup'!$C$28*'Risk Factor Weights Lookup'!$C$25,IF(AF18='Risk Factor Weights Lookup'!$B$29,'Risk Factor Weights Lookup'!$C$29*'Risk Factor Weights Lookup'!$C$25))))))","v":""},{"$error":"#DIV/0!"}]
[null,"Paved Shoulder Width","Narrowest shoulder width of any side",null,null,{"$f":"IF(E6=\"Intersection\",\"N/A\",IF(E19=\"\",\"\",IF(E19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(E19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(E19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(E19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(E19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(H6=\"Intersection\",\"N/A\",IF(H19=\"\",\"\",IF(H19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(H19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(H19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(H19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(H19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(K6=\"Intersection\",\"N/A\",IF(K19=\"\",\"\",IF(K19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(K19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(K19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(K19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(K19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(N6=\"Intersection\",\"N/A\",IF(N19=\"\",\"\",IF(N19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(N19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(N19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(N19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(N19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(Q6=\"Intersection\",\"N/A\",IF(Q19=\"\",\"\",IF(Q19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(Q19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(Q19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(Q19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(Q19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(T6=\"Intersection\",\"N/A\",IF(T19=\"\",\"\",IF(T19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(T19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(T19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(T19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(T19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(W6=\"Intersection\",\"N/A\",IF(W19=\"\",\"\",IF(W19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(W19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(W19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(W19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(W19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(Z6=\"Intersection\",\"N/A\",IF(Z19=\"\",\"\",IF(Z19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(Z19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(Z19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(Z19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(Z19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(AC6=\"Intersection\",\"N/A\",IF(AC19=\"\",\"\",IF(AC19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(AC19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(AC19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(AC19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(AC19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},null,null,{"$f":"IF(AF6=\"Intersection\",\"N/A\",IF(AF19=\"\",\"\",IF(AF19='Risk Factor Weights Lookup'!$B$72,'Risk Factor Weights Lookup'!$C$72*'Risk Factor Weights Lookup'!$C$71,IF(AF19='Risk Factor Weights Lookup'!$B$73,'Risk Factor Weights Lookup'!$C$73*'Risk Factor Weights Lookup'!$C$71,IF(AF19='Risk Factor Weights Lookup'!$B$74,'Risk Factor Weights Lookup'!$C$74*'Risk Factor Weights Lookup'!$C$71,IF(AF19='Risk Factor Weights Lookup'!$B$75,'Risk Factor Weights Lookup'!$C$75*'Risk Factor Weights Lookup'!$C$71,IF(AF19='Risk Factor Weights Lookup'!$B$76,'Risk Factor Weights Lookup'!$C$76*'Risk Factor Weights Lookup'!$C$71)))))))","v":""},{"$error":"#DIV/0!"}]
[null,"Posted Speed Limit","Highest posted speed limit of any side/leg",null,null,{"$f":"IF(E20=\"\",\"\",IF(E20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(E20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(E20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(E20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(E20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(E20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(H20=\"\",\"\",IF(H20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(H20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(H20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(H20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(H20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(H20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(K20=\"\",\"\",IF(K20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(K20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(K20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(K20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(K20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(K20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(N20=\"\",\"\",IF(N20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(N20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(N20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(N20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(N20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(N20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(Q20=\"\",\"\",IF(Q20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(Q20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(Q20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(Q20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(Q20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(Q20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(T20=\"\",\"\",IF(T20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(T20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(T20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(T20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(T20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(T20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(W20=\"\",\"\",IF(W20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(W20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(W20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(W20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(W20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(W20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(Z20=\"\",\"\",IF(Z20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(Z20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(Z20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(Z20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(Z20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(Z20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(AC20=\"\",\"\",IF(AC20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(AC20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(AC20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(AC20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(AC20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(AC20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},null,null,{"$f":"IF(AF20=\"\",\"\",IF(AF20='Risk Factor Weights Lookup'!$B$79,'Risk Factor Weights Lookup'!$C$79*'Risk Factor Weights Lookup'!$C$78,IF(AF20='Risk Factor Weights Lookup'!$B$80,'Risk Factor Weights Lookup'!$C$80*'Risk Factor Weights Lookup'!$C$78,IF(AF20='Risk Factor Weights Lookup'!$B$81,'Risk Factor Weights Lookup'!$C$81*'Risk Factor Weights Lookup'!$C$78,IF(AF20='Risk Factor Weights Lookup'!$B$82,'Risk Factor Weights Lookup'!$C$82*'Risk Factor Weights Lookup'!$C$78,IF(AF20='Risk Factor Weights Lookup'!$B$83,'Risk Factor Weights Lookup'!$C$83*'Risk Factor Weights Lookup'!$C$78,IF(AF20='Risk Factor Weights Lookup'!$B$84,'Risk Factor Weights Lookup'!$C$84*'Risk Factor Weights Lookup'!$C$78)))))))","v":""},{"$error":"#DIV/0!"}]
["Intersection Characteristics","Intersection Control Type",null,null,null,{"$f":"IF(E6=\"Segment\",\"N/A\",IF(E21=\"\",\"\",IF(E21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(E21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(E21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(H6=\"Segment\",\"N/A\",IF(H21=\"\",\"\",IF(H21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(H21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(H21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(K6=\"Segment\",\"N/A\",IF(K21=\"\",\"\",IF(K21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(K21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(K21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(N6=\"Segment\",\"N/A\",IF(N21=\"\",\"\",IF(N21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(N21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(N21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(Q6=\"Segment\",\"N/A\",IF(Q21=\"\",\"\",IF(Q21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(Q21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(Q21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(T6=\"Segment\",\"N/A\",IF(T21=\"\",\"\",IF(T21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(T21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(T21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(W6=\"Segment\",\"N/A\",IF(W21=\"\",\"\",IF(W21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(W21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(W21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(Z6=\"Segment\",\"N/A\",IF(Z21=\"\",\"\",IF(Z21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(Z21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(Z21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(AC6=\"Segment\",\"N/A\",IF(AC21=\"\",\"\",IF(AC21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(AC21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(AC21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},null,null,{"$f":"IF(AF6=\"Segment\",\"N/A\",IF(AF21=\"\",\"\",IF(AF21='Risk Factor Weights Lookup'!$B$32,'Risk Factor Weights Lookup'!$C$32*'Risk Factor Weights Lookup'!$C$31,IF(AF21='Risk Factor Weights Lookup'!$B$33,'Risk Factor Weights Lookup'!$C$33*'Risk Factor Weights Lookup'!$C$31,IF(AF21='Risk Factor Weights Lookup'!$B$34,'Risk Factor Weights Lookup'!$C$34*'Risk Factor Weights Lookup'!$C$31)))))","v":""},{"$error":"#DIV/0!"}]
[null,"Number of Pedestrian Enhancement Types at Traffic Signals ","Includes: LPI, protected left-turns, turn restrictions during ped calls, pedestrian-only phase, curb extentions, pedestrian lighting (count unique types of treatment, not individual installations. E.g., LPI on two approaches counts as one enhancement)",null,null,{"$f":"IF(E6=\"Segment\",\"N/A\",IF(E21=\"\",\"\",IF(E21<>\"Signalized\",\"N/A\",IF(E22=\"\",\"\",IF(E22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(E22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(E22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(E22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(H6=\"Segment\",\"N/A\",IF(H21=\"\",\"\",IF(H21<>\"Signalized\",\"N/A\",IF(H22=\"\",\"\",IF(H22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(H22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(H22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(H22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(K6=\"Segment\",\"N/A\",IF(K21=\"\",\"\",IF(K21<>\"Signalized\",\"N/A\",IF(K22=\"\",\"\",IF(K22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(K22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(K22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(K22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(N6=\"Segment\",\"N/A\",IF(N21=\"\",\"\",IF(N21<>\"Signalized\",\"N/A\",IF(N22=\"\",\"\",IF(N22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(N22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(N22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(N22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(Q6=\"Segment\",\"N/A\",IF(Q21=\"\",\"\",IF(Q21<>\"Signalized\",\"N/A\",IF(Q22=\"\",\"\",IF(Q22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(Q22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(Q22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(Q22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(T6=\"Segment\",\"N/A\",IF(T21=\"\",\"\",IF(T21<>\"Signalized\",\"N/A\",IF(T22=\"\",\"\",IF(T22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(T22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(T22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(T22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(W6=\"Segment\",\"N/A\",IF(W21=\"\",\"\",IF(W21<>\"Signalized\",\"N/A\",IF(W22=\"\",\"\",IF(W22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(W22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(W22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(W22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(Z6=\"Segment\",\"N/A\",IF(Z21=\"\",\"\",IF(Z21<>\"Signalized\",\"N/A\",IF(Z22=\"\",\"\",IF(Z22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(Z22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(Z22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(Z22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(AC6=\"Segment\",\"N/A\",IF(AC21=\"\",\"\",IF(AC21<>\"Signalized\",\"N/A\",IF(AC22=\"\",\"\",IF(AC22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(AC22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(AC22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(AC22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},null,null,{"$f":"IF(AF6=\"Segment\",\"N/A\",IF(AF21=\"\",\"\",IF(AF21<>\"Signalized\",\"N/A\",IF(AF22=\"\",\"\",IF(AF22='Risk Factor Weights Lookup'!$B$37,'Risk Factor Weights Lookup'!$C$37*'Risk Factor Weights Lookup'!$C$36,IF(AF22='Risk Factor Weights Lookup'!$B$38,'Risk Factor Weights Lookup'!$C$38*'Risk Factor Weights Lookup'!$C$36,IF(AF22='Risk Factor Weights Lookup'!$B$39,'Risk Factor Weights Lookup'!$C$39*'Risk Factor Weights Lookup'!$C$36,IF(AF22='Risk Factor Weights Lookup'!$B$40,'Risk Factor Weights Lookup'!$C$40*'Risk Factor Weights Lookup'!$C$36))))))))","v":""},{"$error":"#DIV/0!"}]
[null,"Number of Pedestrian Enhancement Types at Locations without a Traffic Signal","Includes: marked crossing, curb extensions, warning signs, pedestrian lighting, RRFB, PHB. (count unique types of treatment, not individual installations. E.g., curb extensions on three corners counts as one enhancement)",null,null,{"$f":"IF(E6=\"Segment\",\"N/A\",IF(E21=\"\",\"\",IF(E21=\"Signalized\",\"N/A\",IF(E23=\"\",\"\",IF(E23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(E23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(E23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(E23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(H6=\"Segment\",\"N/A\",IF(H21=\"\",\"\",IF(H21=\"Signalized\",\"N/A\",IF(H23=\"\",\"\",IF(H23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(H23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(H23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(H23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(K6=\"Segment\",\"N/A\",IF(K21=\"\",\"\",IF(K21=\"Signalized\",\"N/A\",IF(K23=\"\",\"\",IF(K23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(K23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(K23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(K23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(N6=\"Segment\",\"N/A\",IF(N21=\"\",\"\",IF(N21=\"Signalized\",\"N/A\",IF(N23=\"\",\"\",IF(N23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(N23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(N23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(N23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(Q6=\"Segment\",\"N/A\",IF(Q21=\"\",\"\",IF(Q21=\"Signalized\",\"N/A\",IF(Q23=\"\",\"\",IF(Q23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(Q23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(Q23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(Q23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(T6=\"Segment\",\"N/A\",IF(T21=\"\",\"\",IF(T21=\"Signalized\",\"N/A\",IF(T23=\"\",\"\",IF(T23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(T23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(T23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(T23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(W6=\"Segment\",\"N/A\",IF(W21=\"\",\"\",IF(W21=\"Signalized\",\"N/A\",IF(W23=\"\",\"\",IF(W23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(W23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(W23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(W23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(Z6=\"Segment\",\"N/A\",IF(Z21=\"\",\"\",IF(Z21=\"Signalized\",\"N/A\",IF(Z23=\"\",\"\",IF(Z23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(Z23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(Z23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(Z23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(AC6=\"Segment\",\"N/A\",IF(AC21=\"\",\"\",IF(AC21=\"Signalized\",\"N/A\",IF(AC23=\"\",\"\",IF(AC23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(AC23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(AC23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(AC23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},null,null,{"$f":"IF(AF6=\"Segment\",\"N/A\",IF(AF21=\"\",\"\",IF(AF21=\"Signalized\",\"N/A\",IF(AF23=\"\",\"\",IF(AF23='Risk Factor Weights Lookup'!$B$43,'Risk Factor Weights Lookup'!$C$43*'Risk Factor Weights Lookup'!$C$42,IF(AF23='Risk Factor Weights Lookup'!$B$44,'Risk Factor Weights Lookup'!$C$44*'Risk Factor Weights Lookup'!$C$42,IF(AF23='Risk Factor Weights Lookup'!$B$45,'Risk Factor Weights Lookup'!$C$45*'Risk Factor Weights Lookup'!$C$42,IF(AF23='Risk Factor Weights Lookup'!$B$46,'Risk Factor Weights Lookup'!$C$46*'Risk Factor Weights Lookup'!$C$42))))))))","v":""},{"$error":"#DIV/0!"}]
[null,"Total Risk Score",null,null,{"$f":"SUM(F9:F23)","v":0},null,null,{"$f":"SUM(I9:I23)","v":0},null,null,{"$f":"SUM(L9:L23)","v":0},null,null,{"$f":"SUM(O9:O23)","v":0},null,null,{"$f":"SUM(R9:R23)","v":0},null,null,{"$f":"SUM(U9:U23)","v":0},null,null,{"$f":"SUM(X9:X23)","v":0},null,null,{"$f":"SUM(AA9:AA23)","v":0},null,null,{"$f":"SUM(AD9:AD23)","v":0},null,null,{"$f":"SUM(AG9:AG23)","v":0}]
[null,"Normalized Risk Score",null,null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"Intersection\",(E24/'Risk Factor Weights Lookup'!$H$2)*100,IF(E6=\"Segment\",(E24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(H6=\"\",\"\",IF(H6=\"Intersection\",(H24/'Risk Factor Weights Lookup'!$H$2)*100,IF(H6=\"Segment\",(H24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(K6=\"\",\"\",IF(K6=\"Intersection\",(K24/'Risk Factor Weights Lookup'!$H$2)*100,IF(K6=\"Segment\",(K24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(N6=\"\",\"\",IF(N6=\"Intersection\",(N24/'Risk Factor Weights Lookup'!$H$2)*100,IF(N6=\"Segment\",(N24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(Q6=\"\",\"\",IF(Q6=\"Intersection\",(Q24/'Risk Factor Weights Lookup'!$H$2)*100,IF(Q6=\"Segment\",(Q24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(T6=\"\",\"\",IF(T6=\"Intersection\",(T24/'Risk Factor Weights Lookup'!$H$2)*100,IF(T6=\"Segment\",(T24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(W6=\"\",\"\",IF(W6=\"Intersection\",(W24/'Risk Factor Weights Lookup'!$H$2)*100,IF(W6=\"Segment\",(W24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(Z6=\"\",\"\",IF(Z6=\"Intersection\",(Z24/'Risk Factor Weights Lookup'!$H$2)*100,IF(Z6=\"Segment\",(Z24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(AC6=\"\",\"\",IF(AC6=\"Intersection\",(AC24/'Risk Factor Weights Lookup'!$H$2)*100,IF(AC6=\"Segment\",(AC24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""},null,null,{"$f":"IF(AF6=\"\",\"\",IF(AF6=\"Intersection\",(AF24/'Risk Factor Weights Lookup'!$H$2)*100,IF(AF6=\"Segment\",(AF24/'Risk Factor Weights Lookup'!$H$3)*100)))","v":""}]

{"sheet":"Step 2-3_Benefit & Cost Calc","index":2,"n_rows":32,"n_cols":32,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,12],[17,0,17,12],[18,0,18,12],[3,12,3,13],[3,15,3,16],[3,18,3,19],[3,9,3,10],[3,3,3,4],[3,6,3,7],[11,0,12,0],[13,18,13,19],[13,3,13,4],[13,6,13,7],[13,9,13,10],[13,12,13,13],[13,15,13,16],[4,18,4,19],[5,18,5,19],[6,18,6,19],[7,18,7,19],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[29,0,31,0],[4,12,4,13],[5,12,5,13],[6,12,6,13],[7,12,7,13],[4,15,4,16],[5,15,5,16],[6,15,6,16],[7,15,7,16],[20,12,20,13],[20,15,20,16],[3,1,3,2],[20,1,20,2],[20,3,20,4],[20,6,20,7],[13,0,13,1],[21,0,23,0],[21,3,21,4],[22,3,22,4],[23,3,23,4],[21,6,21,7],[23,6,23,7],[22,6,22,7],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[20,9,20,10],[8,0,10,0],[4,0,7,0],[20,18,20,19],[27,0,27,3],[21,15,21,16],[22,15,22,16],[23,15,23,16],[21,18,21,19],[22,18,22,19],[23,18,23,19],[21,9,21,10],[22,9,22,10],[23,9,23,10],[21,12,21,13],[22,12,22,13],[23,12,23,13],[13,21,13,22],[3,24,3,25],[4,24,4,25],[5,24,5,25],[6,24,6,25],[7,24,7,25],[13,24,13,25],[3,21,3,22],[4,21,4,22],[5,21,5,22],[6,21,6,22],[7,21,7,22],[13,27,13,28],[3,30,3,31],[4,30,4,31],[5,30,5,31],[6,30,6,31],[7,30,7,31],[13,30,13,31],[3,27,3,28],[4,27,4,28],[5,27,5,28],[6,27,6,28],[7,27,7,28],[20,27,20,28],[21,27,21,28],[22,27,22,28],[23,27,23,28],[20,30,20,31],[21,30,21,31],[22,30,22,31],[23,30,23,31],[20,21,20,22],[21,21,21,22],[22,21,22,22],[23,21,23,22],[20,24,20,25],[21,24,21,25],[22,24,22,25],[23,24,23,25]]}
[]
["                   Step 2: Enter the countermeasures that will be applied to each site. Note that benefit calculations are limited to three total countermeasures across all sites."]
[]
[null,"Data Input",null,"Site 1",null,null,"Site 2 ",null,null,"Site 3",null,null,"Site 4",null,null,"Site 5",null,null,"Site 6",null,null,"Site 7",null,null,"Site 8",null,null,"Site 9",null,null,"Site 10"]
["Project Site Details","Location Description",null,{"$f":"IF('Step 1_Risk Calculator'!E5=\"\",\"\",'Step 1_Risk Calculator'!E5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!H5=\"\",\"\",'Step 1_Risk Calculator'!H5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!K5=\"\",\"\",'Step 1_Risk Calculator'!K5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!N5=\"\",\"\",'Step 1_Risk Calculator'!N5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Q5=\"\",\"\",'Step 1_Risk Calculator'!Q5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!T5=\"\",\"\",'Step 1_Risk Calculator'!T5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!W5=\"\",\"\",'Step 1_Risk Calculator'!W5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Z5=\"\",\"\",'Step 1_Risk Calculator'!Z5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AC5=\"\",\"\",'Step 1_Risk Calculator'!AC5)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AF5=\"\",\"\",'Step 1_Risk Calculator'!AF5)","v":""}]
[null,"Intersection or Segment",null,{"$f":"IF('Step 1_Risk Calculator'!E6=\"\",\"\",'Step 1_Risk Calculator'!E6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!H6=\"\",\"\",'Step 1_Risk Calculator'!H6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!K6=\"\",\"\",'Step 1_Risk Calculator'!K6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!N6=\"\",\"\",'Step 1_Risk Calculator'!N6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Q6=\"\",\"\",'Step 1_Risk Calculator'!Q6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!T6=\"\",\"\",'Step 1_Risk Calculator'!T6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!W6=\"\",\"\",'Step 1_Risk Calculator'!W6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Z6=\"\",\"\",'Step 1_Risk Calculator'!Z6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AC6=\"\",\"\",'Step 1_Risk Calculator'!AC6)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AF6=\"\",\"\",'Step 1_Risk Calculator'!AF6)","v":""}]
[null,"Segment Length (miles)",null,{"$f":"IF('Step 1_Risk Calculator'!E7=\"\",\"\",'Step 1_Risk Calculator'!E7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!H7=\"\",\"\",'Step 1_Risk Calculator'!H7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!K7=\"\",\"\",'Step 1_Risk Calculator'!K7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!N7=\"\",\"\",'Step 1_Risk Calculator'!N7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Q7=\"\",\"\",'Step 1_Risk Calculator'!Q7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!T7=\"\",\"\",'Step 1_Risk Calculator'!T7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!W7=\"\",\"\",'Step 1_Risk Calculator'!W7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Z7=\"\",\"\",'Step 1_Risk Calculator'!Z7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AC7=\"\",\"\",'Step 1_Risk Calculator'!AC7)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AF7=\"\",\"\",'Step 1_Risk Calculator'!AF7)","v":""}]
[null,"Context",null,{"$f":"IF('Step 1_Risk Calculator'!E8=\"\",\"\",'Step 1_Risk Calculator'!E8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!H8=\"\",\"\",'Step 1_Risk Calculator'!H8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!K8=\"\",\"\",'Step 1_Risk Calculator'!K8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!N8=\"\",\"\",'Step 1_Risk Calculator'!N8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Q8=\"\",\"\",'Step 1_Risk Calculator'!Q8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!T8=\"\",\"\",'Step 1_Risk Calculator'!T8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!W8=\"\",\"\",'Step 1_Risk Calculator'!W8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!Z8=\"\",\"\",'Step 1_Risk Calculator'!Z8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AC8=\"\",\"\",'Step 1_Risk Calculator'!AC8)","v":""},null,null,{"$f":"IF('Step 1_Risk Calculator'!AF8=\"\",\"\",'Step 1_Risk Calculator'!AF8)","v":""}]
["Countermeasures Applied","Countermeasure 1   |   CRF",null,null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(G9=\"\",\"\",VLOOKUP(G9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(M9=\"\",\"\",VLOOKUP(M9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(P9=\"\",\"\",VLOOKUP(P9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(S9=\"\",\"\",VLOOKUP(S9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(V9=\"\",\"\",VLOOKUP(V9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(Y9=\"\",\"\",VLOOKUP(Y9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AB9=\"\",\"\",VLOOKUP(AB9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""}]
[null,"Countermeasure 2   |   CRF",null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(G10=\"\",\"\",VLOOKUP(G10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(M10=\"\",\"\",VLOOKUP(M10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(P10=\"\",\"\",VLOOKUP(P10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(S10=\"\",\"\",VLOOKUP(S10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(V10=\"\",\"\",VLOOKUP(V10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(Y10=\"\",\"\",VLOOKUP(Y10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AB10=\"\",\"\",VLOOKUP(AB10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""}]
[null,"Countermeasure 3   |   CRF",null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(M11=\"\",\"\",VLOOKUP(M11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(P11=\"\",\"\",VLOOKUP(P11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(S11=\"\",\"\",VLOOKUP(S11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(V11=\"\",\"\",VLOOKUP(V11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(Y11=\"\",\"\",VLOOKUP(Y11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AB11=\"\",\"\",VLOOKUP(AB11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""},null,null,{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AE11,'CMF Lookup'!$C$2:$I$32,7,FALSE))","v":""}]
["Influence Area","Intersection Coverage: Number of approaches receiving treatment   |  Effectiveness Percentage",null,null,{"$f":"IF(D6<>\"Intersection\",\"\",IF(D12=\"\",\"\",IF(D12=1,0.25,IF(D12=2,0.5,IF(D12=3,0.75,IF(D12>=4,1))))))","v":""},null,null,{"$f":"IF(G6<>\"Intersection\",\"\",IF(G12=\"\",\"\",IF(G12=1,0.25,IF(G12=2,0.5,IF(G12=3,0.75,IF(G12>=4,1))))))","v":""},null,null,{"$f":"IF(J6<>\"Intersection\",\"\",IF(J12=\"\",\"\",IF(J12=1,0.25,IF(J12=2,0.5,IF(J12=3,0.75,IF(J12>=4,1))))))","v":""},null,null,{"$f":"IF(M6<>\"Intersection\",\"\",IF(M12=\"\",\"\",IF(M12=1,0.25,IF(M12=2,0.5,IF(M12=3,0.75,IF(M12>=4,1))))))","v":""},null,null,{"$f":"IF(P6<>\"Intersection\",\"\",IF(P12=\"\",\"\",IF(P12=1,0.25,IF(P12=2,0.5,IF(P12=3,0.75,IF(P12>=4,1))))))","v":""},null,null,{"$f":"IF(S6<>\"Intersection\",\"\",IF(S12=\"\",\"\",IF(S12=1,0.25,IF(S12=2,0.5,IF(S12=3,0.75,IF(S12>=4,1))))))","v":""},null,null,{"$f":"IF(V6<>\"Intersection\",\"\",IF(V12=\"\",\"\",IF(V12=1,0.25,IF(V12=2,0.5,IF(V12=3,0.75,IF(V12>=4,1))))))","v":""},null,null,{"$f":"IF(Y6<>\"Intersection\",\"\",IF(Y12=\"\",\"\",IF(Y12=1,0.25,IF(Y12=2,0.5,IF(Y12=3,0.75,IF(Y12>=4,1))))))","v":""},null,null,{"$f":"IF(AB6<>\"Intersection\",\"\",IF(AB12=\"\",\"\",IF(AB12=1,0.25,IF(AB12=2,0.5,IF(AB12=3,0.75,IF(AB12>=4,1))))))","v":""},null,null,{"$f":"IF(AE6<>\"Intersection\",\"\",IF(AE12=\"\",\"\",IF(AE12=1,0.25,IF(AE12=2,0.5,IF(AE12=3,0.75,IF(AE12>=4,1))))))","v":""}]
[null,"Segment Coverage: Length of segment, in miles, receiving treatment (assume 0.5 mile treatment length for each enhanced crossing)   |  Effectiveness Percentage",null,null,{"$f":"IF(D6<>\"Segment\",\"\",IF(D13>D7,1,D13/D7))","v":""},null,null,{"$f":"IF(G6<>\"Segment\",\"\",IF(G13>G7,1,G13/G7))","v":""},null,null,{"$f":"IF(J6<>\"Segment\",\"\",IF(J13>J7,1,J13/J7))","v":""},null,null,{"$f":"IF(M6<>\"Segment\",\"\",IF(M13>M7,1,M13/M7))","v":""},null,null,{"$f":"IF(P6<>\"Segment\",\"\",IF(P13>P7,1,P13/P7))","v":""},null,null,{"$f":"IF(S6<>\"Segment\",\"\",IF(S13>S7,1,S13/S7))","v":""},null,null,{"$f":"IF(V6<>\"Segment\",\"\",IF(V13>V7,1,V13/V7))","v":""},null,null,{"$f":"IF(Y6<>\"Segment\",\"\",IF(Y13>Y7,1,Y13/Y7))","v":""},null,null,{"$f":"IF(AB6<>\"Segment\",\"\",IF(AB13>AB7,1,AB13/AB7))","v":""},null,null,{"$f":"IF(AE6<>\"Segment\",\"\",IF(AE13>AE7,1,AE13/AE7))","v":""}]
["Total Reduced Risk (Benefit)",null,null,{"$f":"IF(AND(E9=\"\",E10=\"\",E11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!E25-('Step 1_Risk Calculator'!E25*(1-IF(E9=\"\",0,E9))*(1-IF(E10=\"\",0,E10))*(1-IF(E11=\"\",0,E11)))))*MAX(E12:E13)","v":0},null,null,{"$f":"IF(AND(H9=\"\",H10=\"\",H11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!H25-('Step 1_Risk Calculator'!H25*(1-IF(H9=\"\",0,H9))*(1-IF(H10=\"\",0,H10))*(1-IF(H11=\"\",0,H11)))))*MAX(H12:H13)","v":0},null,null,{"$f":"IF(AND(K9=\"\",K10=\"\",K11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!K25-('Step 1_Risk Calculator'!K25*(1-IF(K9=\"\",0,K9))*(1-IF(K10=\"\",0,K10))*(1-IF(K11=\"\",0,K11)))))*MAX(K12:K13)","v":0},null,null,{"$f":"IF(AND(N9=\"\",N10=\"\",N11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!N25-('Step 1_Risk Calculator'!N25*(1-IF(N9=\"\",0,N9))*(1-IF(N10=\"\",0,N10))*(1-IF(N11=\"\",0,N11)))))*MAX(N12:N13)","v":0},null,null,{"$f":"IF(AND(Q9=\"\",Q10=\"\",Q11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!Q25-('Step 1_Risk Calculator'!Q25*(1-IF(Q9=\"\",0,Q9))*(1-IF(Q10=\"\",0,Q10))*(1-IF(Q11=\"\",0,Q11)))))*MAX(Q12:Q13)","v":0},null,null,{"$f":"IF(AND(T9=\"\",T10=\"\",T11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!T25-('Step 1_Risk Calculator'!T25*(1-IF(T9=\"\",0,T9))*(1-IF(T10=\"\",0,T10))*(1-IF(T11=\"\",0,T11)))))*MAX(T12:T13)","v":0},null,null,{"$f":"IF(AND(W9=\"\",W10=\"\",W11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!W25-('Step 1_Risk Calculator'!W25*(1-IF(W9=\"\",0,W9))*(1-IF(W10=\"\",0,W10))*(1-IF(W11=\"\",0,W11)))))*MAX(W12:W13)","v":0},null,null,{"$f":"IF(AND(Z9=\"\",Z10=\"\",Z11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!Z25-('Step 1_Risk Calculator'!Z25*(1-IF(Z9=\"\",0,Z9))*(1-IF(Z10=\"\",0,Z10))*(1-IF(Z11=\"\",0,Z11)))))*MAX(Z12:Z13)","v":0},null,null,{"$f":"IF(AND(AC9=\"\",AC10=\"\",AC11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!AC25-('Step 1_Risk Calculator'!AC25*(1-IF(AC9=\"\",0,AC9))*(1-IF(AC10=\"\",0,AC10))*(1-IF(AC11=\"\",0,AC11)))))*MAX(AC12:AC13)","v":0},null,null,{"$f":"IF(AND(AF9=\"\",AF10=\"\",AF11=\"\"),0,IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36),0))>3,\"Error\",'Step 1_Risk Calculator'!AF25-('Step 1_Risk Calculator'!AF25*(1-IF(AF9=\"\",0,AF9))*(1-IF(AF10=\"\",0,AF10))*(1-IF(AF11=\"\",0,AF11)))))*MAX(AF12:AF13)","v":0}]
[{"$f":"IF(SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/ COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36), 0))>3,_xlfn.CONCAT(\"You have selected a total of \",SUM(IF('Other Parameter Lookup'!$B$7:$B$36<>\"\",1/ COUNTIF('Other Parameter Lookup'!$B$7:$B$36,'Other Parameter Lookup'!$B$7:$B$36), 0)),\" countermeasures. Benefit calculations are limited to three unique countermeasures across all treated sites. Please reduce the number of countermeasures being applied.\"),\"\")","v":""}]
[]
[]
["            Step 3: Enter the total estimated cost of improvements at each site. Please include all cost components outlined in the Cost Estimator worksheet on the ODOT ARTS website."]
["            If you do not have individual costs for each site, you can enter the total project cost for all sites in Site 1 (make sure the costs for all other sites are zero)."]
[]
["Costs","Data Input",null,"Site 1",null,null,"Site 2 ",null,null,"Site 3",null,null,"Site 4",null,null,"Site 5",null,null,"Site 6",null,null,"Site 7",null,null,"Site 8",null,null,"Site 9",null,null,"Site 10"]
["Project \nCost","Total Project Cost"]
[null,"Annual Maintenance and Operations Costs"]
[null,"Total Cost (Present Value)",null,{"$f":"ROUND(D$22+D$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(D9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(D9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(G$22+G$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(G9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(G9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(J$22+J$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(J9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(J9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(M$22+M$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(M9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(M9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(P$22+P$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(P9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(P9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(S$22+S$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(S9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(S9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(V$22+V$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(V9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(V9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(Y$22+Y$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(Y9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(Y9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(AB$22+AB$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(AB9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(AB9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0},null,null,{"$f":"ROUND(AE$22+AE$23*(((1+IR)^(MAX(IFERROR(VLOOKUP(AE9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE11,'CMF Lookup'!$C:$F,4,FALSE),0)))-1)/(IR*(1+IR)^(MAX(IFERROR(VLOOKUP(AE9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE11,'CMF Lookup'!$C:$F,4,FALSE),0))))),-3)","v":0}]
[]
[]
[]
["                  RESULTS"]
[]
["FINAL RESULTS","Total Project Reduced Risk",null,{"$f":"IFERROR((IF('Step 1_Risk Calculator'!E6=\"\",0,IF('Step 1_Risk Calculator'!E6=\"intersection\",D14,D14*'Step 1_Risk Calculator'!E7))+IF('Step 1_Risk Calculator'!H6=\"\",0,IF('Step 1_Risk Calculator'!H6=\"intersection\",G14,G14*'Step 1_Risk Calculator'!H7))+IF('Step 1_Risk Calculator'!K6=\"\",0,IF('Step 1_Risk Calculator'!K6=\"intersection\",J14,J14*'Step 1_Risk Calculator'!K7))+IF('Step 1_Risk Calculator'!N6=\"\",0,IF('Step 1_Risk Calculator'!N6=\"intersection\",M14,M14*'Step 1_Risk Calculator'!N7))+IF('Step 1_Risk Calculator'!Q6=\"\",0,IF('Step 1_Risk Calculator'!Q6=\"intersection\",P14,P14*'Step 1_Risk Calculator'!Q7))+IF('Step 1_Risk Calculator'!T6=\"\",0,IF('Step 1_Risk Calculator'!T6=\"intersection\",S14,S14*'Step 1_Risk Calculator'!T7)))*MAX(IFERROR(VLOOKUP(D9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(D11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(G11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(J11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(M11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(P11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(S11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(V11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(Y11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AB11,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE9,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE10,'CMF Lookup'!$C:$F,4,FALSE),0),IFERROR(VLOOKUP(AE11,'CMF Lookup'!$C:$F,4,FALSE),0)),\"Error\")","v":0}]
[null,"Total Project Cost",null,{"$f":"D24+G24+J24+M24+P24+S24","v":0}]
[null,"Total Reduced Risk per $1,000 Spent (RRC)",null,{"$f":"IF(D30=\"Error\",\"Error\",(D30/D31)*1000)","v":{"$error":"#DIV/0!"}},null,null,"Enter this value on your ARTS application form"]

{"sheet":"Other Parameter Lookup","index":3,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Interest Rate"]
[null,0.05]
[]
[]
[]
[null,"List of Applied Countermeasures"]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!D9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!D9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!D10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!D10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!D11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!D11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!G9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!G9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!G10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!G10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!G11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!G11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!J9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!J9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!J10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!J10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!J11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!J11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!M9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!M9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!M10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!M10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!M11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!M11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!P9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!P9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!P10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!P10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!P11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!P11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!S9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!S9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!S10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!S10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!S11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!S11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!V9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!V9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!V10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!V10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!V11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!V11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!Y9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!Y9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!Y10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!Y10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!Y11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!Y11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AB9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AB9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AB10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AB10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AB11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AB11)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AE9=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AE9)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AE10=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AE10)","v":""}]
[null,{"$f":"IF('Step 2-3_Benefit & Cost Calc'!AE11=\"\",\"\",'Step 2-3_Benefit & Cost Calc'!AE11)","v":""}]

{"sheet":"Risk Factor Weights Lookup","index":4,"n_rows":84,"n_cols":8,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Minor or Possible Injury Crashes involing a Bicyclist or Pedestrian (5 Year Total)",20,null,null,null,"Intersection",{"$f":"C2+C8+C15+C21+C31+C36+C48+C53+C58+C64+C78","v":226}]
[null,"No",0,null,null,null,"Segment",{"$f":"C2+C8+C15+C21+C25+C48+C53+C58+C64+C71+C78","v":219}]
[null,"Yes",0.5]
[null,"Fatal or Serious Injury Crashes involing a Bicyclist or Pedestrian (5 Year Total)"]
[null,"Yes",1]
[]
[null,"Average Annual Daily Traffic",21]
[null,"0-500",0]
[null,"501-1,500",0.25]
[null,"1,501-7,000",0.5]
[null,"7,001-20,000",0.75]
[null,"More than 20,000",1]
[]
[null,"Number of Attractors",19]
[null,0,0]
[null,"1-3",0.33]
[null,"4-8",0.66]
[null,"More than 8",1]
[]
[null,"Signalized Crossing Spacing",20]
[null,"1/4 mi. or less",0]
[null,"More than 1/4 mi.",1]
[]
[null,"Access Density",21,"Only for Segments"]
[null,"Less than 20",0]
[null,"20-40",0.33]
[null,"40-60",0.66]
[null,"More than 60 ",1]
[]
[null,"Intersection Control Type",20,"Only for Intersections"]
[null,"Signalized",0]
[null,"All-way stop",0.5]
[null,"Two-way stop",1]
[]
[null,"Number of Signalized Pedestrian Enhancements",20,"Only for Intersections"]
[null,"5+",0]
[null,"3-4",0.33]
[null,"1-2",0.66]
[null,0,1]
[]
[null,"Number of Unsignalized Pedestrian Enhancements",20,"Only for Intersections"]
[null,"5+",0]
[null,"3-4",0.33]
[null,"1-2",0.66]
[null,0,1]
[]
[null,"Bike Lane",19]
[null,"Continuous Bike Lane",0]
[null,"Bike Lane with Gaps",0.5]
[null,"No Bike Lane",1]
[]
[null,"Sidewalks",20]
[null,"Continuous Sidewalk",0]
[null,"Sidewalk with Gaps",0.5]
[null,"No Sidewalk",1]
[]
[null,"Equity",18]
[null,"Low Disparity",0]
[null,"Low-Med Disparity",0.33]
[null,"Med-High Disparity",0.66]
[null,"High Disparity",1]
[]
[null,"Number of Lanes",24,"Highest of any leg"]
[null,1,0]
[null,2,0.25]
[null,3,0.5]
[null,4,0.75]
[null,"5+",1]
[]
[null,"Shoulder Width",12,"Only segments; lowest of any side"]
[null,"More than 10 ft.",0]
[null,"6.5 to 10 ft.",0.25]
[null,"4 to 6 ft.",0.5]
[null,"0.5 to 3.5 ft.",0.75]
[null,"No Shoulder",1]
[]
[null,"Speed",25,"Highest posted speed limit"]
[null,"20 mph or lower",0]
[null,"25 mph",0.2]
[null,"30 mph",0.4]
[null,"35 mph",0.6]
[null,"40 mph",0.8]
[null,"45 mph or higher",1]

{"sheet":"CMF Lookup","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["CM No","Name","Full Name","Target Crash","Target Severity","Service Life","Facility","Area type","CRF"]
["BP1","Install Pedestrian Countdown Timer(s)","BP1: Install Pedestrian Countdown Timer(s)","Pedestrian","All",20,"Signalized   ","Either",0.7]
["BP2","Provide Intersection Lighting (Bike & Ped)","BP2: Provide Intersection Lighting (Bike & Ped)","P & B Night","All Injury (Excludes PDO's)",20,"Signalized or Unsignalized","Either",0.42]
["BP3","Install Urban Leading Pedestrian or Bicycle Interval at Signalized Intersection","BP3: Install Urban Leading Pedestrian or Bicycle Interval at Signalized Intersection","P & B","All",10,"Signalized   ","Urban",0.37]
["BP4","Install No Pedestrian Phase Feature with Flashing Yellow Arrow","BP4: Install No Pedestrian Phase Feature with Flashing Yellow Arrow","Pedestrian","All",20,"Signalized   ","Either",0.43]
["BP5","Reduce Right Turn Permissive Conflicts (right turn arrow)","BP5: Reduce Right Turn Permissive Conflicts (right turn arrow)","P & B","All","20","Signalized   ","Either",0.2]
["BP6","Install Urban Green Bike Lanes at Conflict Points","BP6: Install Urban Green Bike Lanes at Conflict Points","Bicycle","All",10,"Signalized or Unsignalized","Urban",0.39]
["BP7","Install Bike Box at Conflict Points","BP7: Install Bike Box at Conflict Points","Bicycle","All",10,"Signalized   ","Either",0.35]
["BP8","Install Pedestrian Refuge Island","BP8: Install Pedestrian Refuge Island","Pedestrian","All",20,"None - Roadway","Either",0.31]
["BP9","Install Rectangular Rapid Flashing Beacon (2-Lane Road)","BP9: Install Rectangular Rapid Flashing Beacon (2-Lane Road)","Pedestrian","All",20,"None - Roadway","Either",0.1]
["BP10","Install Pedestrian Activated Beacon at Intersection","BP10: Install Pedestrian Activated Beacon at Intersection","P & B","All",20,"None - Roadway","Urban",0.1]
["BP11","Install Rectangular Rapid Flashing Beacon without Median (3-Lane or More Roadway)","BP11: Install Rectangular Rapid Flashing Beacon without Median (3-Lane or More Roadway)","Pedestrian","All",20,"None - Roadway","Either",0.1]
["BP12","Install Rectangular Rapid Flashing Beacon with Median (3-Lane or More Roadway)","BP12: Install Rectangular Rapid Flashing Beacon with Median (3-Lane or More Roadway)","Pedestrian","All",20,"None - Roadway","Either",0.56000000000000005]
["BP13","Install Pedestrian Activated Beacon Midblock","BP13: Install Pedestrian Activated Beacon Midblock","P & B","All",20,"None - Roadway","Urban",0.1]
["BP14","Install Pedestrian Activated Beacon (flashing Beacon in conjuction with median and stop bar)","BP14: Install Pedestrian Activated Beacon (flashing Beacon in conjuction with median and stop bar)","P & B","All",20,"None - Roadway","Urban",0.56000000000000005]
["BP15","Install Continental Crosswalk Markings and Advance Pedestrian Warning Signs at Uncontrolled Locations","BP15: Install Continental Crosswalk Markings and Advance Pedestrian Warning Signs at Uncontrolled Locations","Pedestrian","All",10,"None - Roadway","Either",0.15]
["BP16","Install Curb Ramps and Extensions with a Marked Crosswalk and Pedestrian Warning Signs ","BP16: Install Curb Ramps and Extensions with a Marked Crosswalk and Pedestrian Warning Signs ","Pedestrian","All",20,"None - Roadway","Either",0.37]
["BP17","Install Advance Pedestrian or Bicycle Warning Signs","BP17: Install Advance Pedestrian or Bicycle Warning Signs","P & B","All",10,"None - Roadway","Either",0.05]
["BP18","Install Pedestrian Signal","BP18: Install Pedestrian Signal","P & B","All",20,"None - Roadway","Either",0.55000000000000004]
["BP19","Install Pedestrian Hybrid Beacon","BP19: Install Pedestrian Hybrid Beacon","P & B","All",20,"None - Roadway","Urban",0.55000000000000004]
["BP20","Convert 4-Lane Roadway to 3-Lane Roadway with Center Turn Lane (Road Diet)","BP20: Convert 4-Lane Roadway to 3-Lane Roadway with Center Turn Lane (Road Diet)","All","All",20,"None - Roadway","Urban",0.28999999999999998]
["BP21","Install Bike Signal","BP21: Install Bike Signal","Bicycle","All",20,"Signalized   ","Either",0.45]
["BP22","Install Bike Lanes","BP22: Install Bike Lanes","Bicycle","All",20,"None - Roadway","Either",0.36]
["BP23","Install Cycle Tracks","BP23: Install Cycle Tracks","Bicycle","All Injury (Excludes PDO's)",20,"None - Roadway","Urban",0.59]
["BP24","Install Buffered Bike Lanes","BP24: Install Buffered Bike Lanes","Bicycle","All Injury (Excludes PDO's)",20,"None - Roadway","Urban",0.47]
["BP25","Prohibit Right-Turn-On-Red","BP25: Prohibit Right-Turn-On-Red","P & B","All",10,"Signalized   ","Either",0.41]
["BP26","Advanced Yield and Stop Markings & Signs","BP26: Advanced Yield and Stop Markings & Signs","P & B","All",10,"None - Roadway","Either",0.25]
["BP27","Install Bicycle Boulevard","BP27: Install Bicycle Boulevard","P & B","All",10,"None - Roadway","Either",0.63]
["BP28","Install Raised Crosswalk","BP28: Install Raised Crosswalk","P & B","All",20,"Signalized or Unsignalized","Urban",0.3]
["BP29","Sidewalk","BP29: Sidewalk","Pedestrian - walking along","All","20","None - Roadway","Either",0.2]
["BP30","Install Speed Humps/Table (not on state highways)","BP30: Install Speed Humps/Table (not on state highways)","P & B","All",20,"None - Roadway","Urban",0.15]
["BP31","Street Tree's (supports blueprint for Urban Design)","BP31: Street Tree's (supports blueprint for Urban Design)","All","All","20","None - Roadway","Urban",0.1]