{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Virtual Sheet","Paper Sheet","Score Weighting","WeightReferences","References"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Virtual Sheet","index":0,"n_rows":52,"n_cols":118,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,40,42,55],[42,57,42,73],[34,50,35,73],[36,46,37,73],[36,40,37,45],[34,40,35,48],[39,39,40,45],[39,78,40,83],[24,61,24,73],[28,74,28,76],[27,60,27,73],[25,55,25,73],[25,74,25,76],[49,78,50,114],[28,48,28,73],[44,51,44,73],[35,78,38,114],[44,78,44,114],[46,78,47,114],[42,74,42,76],[36,74,37,76],[29,78,32,114],[43,55,43,73],[44,74,44,76],[32,53,33,73],[30,39,31,52],[32,74,33,76],[34,74,35,76],[41,78,41,114],[14,39,14,76],[21,58,21,73],[22,50,22,73],[23,52,23,73],[22,78,26,114],[15,39,19,76],[24,40,24,60],[26,40,27,59],[0,39,1,76],[5,39,5,75],[6,39,6,75],[4,51,4,75],[8,39,8,75],[0,116,1,153],[4,117,6,152],[8,117,51,152],[45,39,46,68],[47,39,51,76],[51,77,51,114],[0,77,1,114],[22,74,22,76],[21,74,21,76],[45,75,46,76],[45,70,46,74],[27,74,27,76],[24,74,24,76],[23,74,23,76],[43,74,43,76],[5,78,6,114],[5,0,6,38],[11,0,14,38],[20,0,21,38],[33,78,34,85],[32,40,33,52],[8,78,9,114],[20,74,20,76],[9,39,9,75],[10,39,10,75],[11,59,11,75],[12,39,12,75],[13,39,13,75],[11,78,13,114],[15,78,15,114],[17,78,18,114],[20,78,20,114]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Risk Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Evaluation Narrative"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location and Environmental Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed improvements:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proximity to Land Uses or Pedestrian Attractors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The following narrative repeats the information presented on the previous two pages in a format that may be suitable for use in a grant application narrative.  In addition, it may be benfecial to conduct the risk evaluation again for the future condition to demonstrate how the project will reduce risk and improve pedestrian safety."]
["DRAFT Project Risk Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$6:$G$9,MATCH(BG22,References!$E$6:$E$9,0),3),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How does the project enhance community connectivity? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Environment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Evaluation Narrative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$10:$G$13,MATCH(AY23,References!$E$10:$E$13,0),3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"The proposed project was evaluated for pedestrian safety using a risk evaluation tool developed from an analysis of crash data from all Tribal areas in the \",\"FHWA publication \"\"A Systemic Safety Study of Pedestrians in Tribal Areas\"\" (FHWA Reference No. HFL230008PR).  The evaluation produced a pedestrian risk evaluation score of \",BS46,BX46,\". The primary factors contributing to this score, which will be improved by the proposed project are:\n\",IF(BS46=\"\",\"\n********* This narrative will update when the evaluation on page 1 is completed electronically. *********\",\"\"),\nIFERROR(IF(AND(BW22<>\"\",BW22>2),\" • \"&CA6,\"\"),\"\"),\"\n\",IF(AND(BW23<>\"\",BW23>2),\" • \"&CA9,\"\"),\"\n\",IF(AND(BW24<>\"\",BW24>2),\" • \"&CA12,\"\"),\"\n\",IF(AND(BW25<>\"\",BW25>1),\" • \"&CA16,\"\"),\"\n\",IF(AND(BW26<>\"\",BW26>4),\" • \"&CA18,\"\"),\"\n\",IF(AND(BW28<>\"\",BW28>2),\" • \"&CA21,\"\"),\"\n\",IF(AND(BW29<>\"\",BW29>4),\" • \"&CA23,\"\"),\"\n\",IF(AND(BW33<>\"\",BW33>2),\" • \"&CA30,\"\"),\"\n\",IF(AND(BW35<>\"\",BW35>2),\" • \"&CA36,\"\"),\"\n\",IF(AND(BW37<>\"\",BW37>2),\" • \" &CA42,\"\"),\"\n\",IF(AND(BW43<>\"\",BW43>2),\" • \" &CA45,\"\"),\"\n\",IF(AND(BW44<>\"\",BW44>2),\" • \" &CA47,\"\"),\"\n\",IF(AND(BW45<>\"\",BW45>2),\" • \" &CA50,\"\"))","v":"The proposed project was evaluated for pedestrian safety using a risk evaluation tool developed from an analysis of crash data from all Tribal areas in the FHWA publication \"A Systemic Safety Study of Pedestrians in Tribal Areas\" (FHWA Reference No. HFL230008PR).  The evaluation produced a pedestrian risk evaluation score of / 62. The primary factors contributing to this score, which will be improved by the proposed project are:\n\n********* This narrative will update when the evaluation on page 1 is completed electronically. *********\n\n\n\n\n\n\n\n\n\n\n\n"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing Distance"]
["A Systemic Safety Study of Pedestrians in Tribal Areas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What land uses are adjacent to the project site? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$14:$G$17,MATCH(BA24,References!$E$14:$E$17,0),3),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Factor Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lighting Condition at Vehicle-Pedestrian Conflict Areas"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FHWA Reference No. HFL230008PR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:\nSelect the appropriate factor for the project location. The Pedestrian Risk Score and supporting risk statistics informed by the safety analysis will be provided on page 2. A narrative will be developed on page 3. Including maps or photos of the project, location may help others better understand this risk evaluation. The risk may change through a project area. Conducting a risk assessment every 1/2-mi or when the roadway cross section changes may be necessary to accurately reflect different roadway segments. Develop a risk evaluation of the location for both the existing and future conditions to demonstrate reduced risk scores. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$18:$G$20,MATCH(BJ25,References!$E$18:$E$20,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posted Speed Limit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$21:$G$24,MATCH(BD26,References!$E$21:$E$24,0),3),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Exposure to Vehicles or Vehicle Traffic on the Roadway"]
["When approved, the final version of this worksheet and the associated report will be posted at",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location and Environmental Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,null,{"$f":"IFERROR(INDEX(References!$E$25:$G$28,MATCH(BI28,References!$E$25:$E$28,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proximity to Land Uses or Pedestrian Attractors:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$6:$F$9,MATCH(BG22,References!$E$6:$E$9,0),2),\"\")","v":""},null,null,null,"Pedestrian Activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.tribalsafety.org/ped-study",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Environment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$10:$F$13,MATCH(AY23,References!$E$10:$E$13,0),2),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX(References!$E$29:$G$31,MATCH(AW29,References!$E$29:$E$31,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing Distance1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$14:$F$17,MATCH(BA24,References!$E$14:$E$17,0),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lighting Condition at Vehicle-Pedestrian Conflict Areas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$18:$F$20,MATCH(BJ25,References!$E$18:$E$20,0),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posted Speed Limit:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$21:$F$24,MATCH(BD26,References!$E$21:$E$24,0),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Exposure to Vehicles/Vehicle Traffic on the Roadway (Average Daily Traffic):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$25:$F$28,MATCH(BI28,References!$E$25:$E$28,0),2),\"\")","v":""},null,null,"Infrastructure Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Activity2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$29:$F$31,MATCH(AW29,References!$E$29:$E$31,0),2),\"\")","v":""},null,null,null,"Presence of Pedestrian Facilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$32:$G$35,MATCH(BB33,References!$E$32:$E$35,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infrastructure Factors"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presence of Pedestrian Facilities3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$32:$F$35,MATCH(BB33,References!$E$32:$E$35,0),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paved Shoulder Width"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paved Shoulder Width:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$36:$F$39,MATCH(AY35,References!$E$36:$E$39, 0),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$36:$G$39,MATCH(AY35,References!$E$36:$E$39, 0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Type:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$40:$F$43,MATCH(AU37,References!$E$40:$E$43,0),2),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior Vehicle-to-Pedestrian Crashes (or Near Misses) Within the Last 5 Yrs4:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$40:$G$43,MATCH(AU37,References!$E$40:$E$43,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$44:$F$47,MATCH(BF43,References!$E$44:$E$47,0),2),\"\")","v":""},null,null,"Other Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Availability of Public Safety Services5:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$48:$F$50,MATCH(BD44,References!$E$48:$E$50,0),2),\"\")","v":""},null,null,null,"Prior Vehicle-to-Pedestrian Crashes (or Near Misses) Within the Last 5 Yrs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Scale and Complexity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!E3:$F$5,MATCH(AZ45,References!$E$3:$E$5,0),2),\"\")","v":""},null,null,null,{"$f":"IFERROR(INDEX(References!$E$44:$G$47,MATCH(BF43,References!$E$44:$E$47,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Risk Evaluation Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(BW22:BY45)=0,\"\",SUM(BW22:BY45))","v":""},null,null,null,null,"/ 62",null,null,"Availability of Public Safety Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!$E$48:$G$50,MATCH(BD44,References!$E$48:$E$50,0),3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1: For a crossing-related project.\n2: Pedestrian activity, as defined in the FHWA Pedestrian Lighting Primer (April 2022):(64) \nHigh or medium: More than 10 pedestrians in a peak hour (examples may include downtown retail or office areas, libraries, community buildings, event centers, or transit stops).\nLow: 10 or fewer pedestrians in a peak hour (examples may include low-density residential areas, semirural or suburban areas, etc.).\n3: Some facilities: Fragmented sidewalk, sidewalk on only one side of the roadway, signage only for crossings.\nAdequate facilities: Sidewalks on both sides of roadway, separated sidewalk or paved path on one or both sides of roadway, marked (painted) crosswalk and signage.\nEnhanced facilities: Bulb-outs/curb extensions, median refuge island(s), pedestrian signal (PHB, RRFB) .\n4: Please attach crash reports or summaries, if available. If no formal reports are available, please attach a description of  events.\n5: Average time elapsed from crash to arrival at treatment facility."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Scale and Complexity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(References!E3:$G$5,MATCH(AZ45,References!$E$3:$E$5,0),3),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note any other relevant information for this project location and attach to this sheet."]

{"sheet":"Paper Sheet","index":1,"n_rows":50,"n_cols":151,"rows_kept":50,"cut":false,"hidden":false,"merged":[[25,78,28,85],[25,111,28,115],[21,111,24,115],[29,111,34,115],[23,117,25,124],[19,117,22,124],[7,145,7,149],[8,145,8,149],[9,145,9,149],[8,126,8,144],[22,126,22,144],[23,145,23,149],[24,145,24,149],[25,145,25,149],[20,145,20,149],[21,145,21,149],[14,145,14,149],[15,145,15,149],[11,126,11,144],[10,126,10,144],[9,126,9,144],[21,126,21,144],[20,126,20,144],[24,126,24,144],[34,40,35,53],[36,40,37,49],[38,40,39,45],[41,39,42,45],[43,40,44,57],[45,40,45,55],[33,87,34,105],[45,74,45,76],[29,106,30,110],[31,106,32,110],[33,106,34,110],[29,87,30,105],[31,87,32,105],[49,39,50,76],[47,75,48,76],[7,87,7,105],[8,87,8,105],[7,106,7,110],[8,106,8,110],[46,116,51,154],[34,116,35,143],[31,116,32,154],[27,126,28,144],[29,126,30,144],[26,145,26,149],[27,145,28,149],[29,145,30,149],[26,117,30,124],[26,126,26,144],[23,126,23,144],[29,78,34,85],[35,77,36,115],[46,51,46,73],[46,74,46,76],[27,40,28,58],[24,40,25,56],[32,39,33,50],[25,126,25,144],[25,106,25,110],[26,150,30,154],[23,150,25,154],[19,150,22,154],[14,150,17,154],[10,150,13,154],[6,150,9,154],[6,126,6,144],[28,106,28,110],[6,145,6,149],[17,145,17,149],[19,145,19,149],[12,126,12,144],[19,126,19,144],[17,126,17,144],[16,126,16,144],[15,126,15,144],[18,116,18,154],[7,126,7,144],[14,117,17,124],[10,117,13,124],[6,117,9,124],[28,87,28,105],[27,87,27,105],[26,87,26,105],[25,87,25,105],[24,87,24,105],[26,106,26,110],[27,106,27,110],[23,106,23,110],[24,106,24,110],[18,87,18,105],[22,145,22,149],[16,145,16,149],[6,111,9,115],[10,111,13,115],[14,111,17,115],[18,111,20,115],[21,78,24,85],[22,106,22,110],[19,106,19,110],[17,106,17,110],[18,106,18,110],[21,106,21,110],[14,126,14,144],[13,126,13,144],[13,145,13,149],[10,145,10,149],[11,145,11,149],[12,145,12,149],[3,116,4,124],[14,87,14,105],[6,87,6,105],[9,106,9,110],[3,106,4,110],[12,87,12,105],[13,87,13,105],[12,106,12,110],[13,106,13,110],[14,106,14,110],[5,116,5,154],[3,150,4,154],[3,145,4,149],[3,125,4,144],[20,74,20,76],[20,106,20,110],[5,0,6,38],[11,0,14,38],[20,0,21,38],[47,39,48,69],[44,77,50,115],[14,39,14,76],[11,106,11,110],[13,39,13,75],[12,39,12,75],[14,78,17,85],[15,39,19,76],[15,106,15,110],[16,106,16,110],[15,87,15,105],[16,87,16,105],[17,87,17,105],[18,78,20,85],[23,87,23,105],[22,87,22,105],[21,87,21,105],[20,87,20,105],[19,87,19,105],[0,77,1,115],[0,116,1,154],[11,59,11,75],[0,39,1,76],[4,51,4,75],[5,39,5,75],[6,39,6,75],[3,111,4,115],[3,77,4,85],[10,78,13,85],[10,39,10,75],[9,39,9,75],[8,39,8,75],[9,87,9,105],[10,87,10,105],[11,87,11,105],[5,77,5,115],[6,78,9,85],[6,106,6,110],[3,86,4,105],[10,106,10,110]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Safety Risk Evaluation ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Definitions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Definitions (continued)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Criteria",null,null,null,null,null,null,null,null,"Measurement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,null,null,"Location Score",null,null,null,null,"Risk Criteria",null,null,null,null,null,null,null,null,"Measurement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,null,null,"Location Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed improvements:"]
["DRAFT Project Risk Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location and Environmental Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infrastructure Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proximity to Land Uses or Pedestrian Attractors",null,null,null,null,null,null,null,null,"<¼ mi to residential or commercial land uses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"Presence of Pedestrian Facilities1",null,null,null,null,null,null,null,null,"No facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"How does the project enhance community connectivity? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¼ to ½ mi to residential or commercial land uses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Some facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"½ to 1 mi to residential or commercial land uses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adequate facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">1 mi to residential or commercial land uses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enhanced facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Environment",null,null,null,null,null,null,null,null,"6 or more lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,"Paved Shoulder Width",null,null,null,null,null,null,null,null,"0–1 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["A Systemic Safety Study of Pedestrians in Tribal Areas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"What land uses are adjacent to the project site? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4- or 5-lane undivided roadway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1–4 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2- or 3-lane undivided roadway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5–9 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-lane divided roadway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">10 ft, curb/gutter, or sidewalk/pathway present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Factor Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing Distance1",null,null,null,null,null,null,null,null,">73 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,"Median Type",null,null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"FHWA Reference No. HFL230008PR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:\nSelect the appropriate attribute for the location of interest; all risk scoring information is provided on pages 2 and 3. Including maps or photos of the project location may help others better understand this risk evaluation. The risk may change through a project area. Conducting a risk assessment every 1/4 mi or when the roadway cross section changes may be necessary to accurately reflect and prioritize different segments. Develop a risk evaluation of the location for both the existing and future conditions to demonstrate reduced risk scores. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51–72 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two-way left-turn lane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34–50 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Earth median (divided roadway)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<34 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrier/cable or pedestrian refuge island",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lighting Condition2",null,null,null,null,null,null,null,null,"No lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,"Other Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inadequate lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,"Prior Vehicle-to-Pedestrian Crashes (Or Near Misses) within the Last 5 Yrs2",null,null,null,null,null,null,null,null,"5 or more crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["When approved, the final version of this worksheet and the associated report will be posted at",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location and Environmental Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,"Adequate lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3–4 crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proximity to Land Uses or Pedestrian Attractors:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posted Speed Limit",null,null,null,null,null,null,null,null,">50 mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1–2 crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,"https://www.tribalsafety.org/ped-study",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Environment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 or 45 mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No crashes (or a history of near misses)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing Distance1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 or 35 mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,"Availability of Public Safety Services3",null,null,null,null,null,null,null,null,">1 h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lighting Condition at Vehicle-Pedestrian Conflict Areas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<25 mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16–60 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Exposure to Vehicles/Traffic on the Roadway",null,null,null,null,null,null,null,null,">25,000 average daily traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<15 min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posted Speed Limit:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5,001–25,000 average daily traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,"Project Scale and Complexity",null,null,null,null,null,null,null,null,"Low cost (<$200,000), simple countermeasures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Exposure to Vehicles/Vehicle Traffic on the Roadway (Average Daily Traffic):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,001–5,000 average daily traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium cost ($200,000 - $1,000,000), moderate countermeasures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<1,000 average daily traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Activity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Activity3",null,null,null,null,null,null,null,null,"High",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High cost (>$1,000,000), complex countermeasures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infrastructure Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presence of Pedestrian Facilities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note any other relevant information for this project location:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continues on page 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paved Shoulder Width:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Type:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Factors"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior Vehicle-to-Pedestrian Crashes (or Near Misses) Within the Last 5 Yrs2:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1: For a pedestrian-crossing project.\n2: Lighting condition at vehicle-pedestrian conflict areas.\n3: Pedestrian activity, as defined in the FHWA Pedestrian Lighting Primer (April 2022):(64) \nHigh or medium: More than 10 pedestrians in a peak hour (examples may include downtown retail or office areas, theaters, libraries, community buildings, concert halls, stadiums, and transit stops/stations).\nLow: 10 or fewer pedestrians in a peak hour (examples may include low-density residential areas, semirural or suburban areas, etc.).\n\nPlease note any unique circumstances that may have an influx of pedestrians (festivals, events, etc.).\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Availability of Public Safety Services3:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Scale and Complexity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1: Examples of pedestrian facilities include:\nSome facilities: Fragmented sidewalk, sidewalk on only one side of roadway, signage only for crossings.\t\t\t\t\nAdequate facilities: Sidewalks on both sides of roadway, separated sidewalk or paved path on one or both sides of roadway, marked (painted) crosswalk and static signage.\t\nEnhanced facilities: Bulb-outs/curb extensions, median refuge island(s), pedestrian signal (PHB, RRFB).\n2: Please attach crash reports or summaries, if available. If no formal reports are available, please attach a description of events.\n3: Average time elapsed from crash to arrival at treatment facility."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Safety Risk Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/ 62"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1: For a crossing-related project.\n2: Please attach crash reports or summaries, if available. If no formal reports are available, please attach a description of events.\n3: Average time elapsed from crash to arrival at treatment facility."]

{"sheet":"Score Weighting","index":2,"n_rows":37,"n_cols":45,"rows_kept":37,"cut":false,"hidden":true,"merged":[[33,38,34,40],[33,44,34,49],[33,0,34,17],[33,41,34,43],[0,0,2,49],[22,44,23,49],[24,44,25,49],[30,44,30,49],[31,44,31,49],[32,44,32,49],[8,44,8,49],[22,41,23,43],[24,41,25,43],[30,41,30,43],[31,41,31,43],[32,41,32,43],[9,44,9,49],[10,44,10,49],[11,44,11,49],[12,44,12,49],[13,44,13,49],[31,38,31,40],[8,41,8,43],[9,41,9,43],[10,41,10,43],[11,41,11,43],[12,41,12,43],[13,41,13,43],[15,41,15,43],[16,41,16,43],[20,41,21,43],[11,38,11,40],[10,38,10,40],[9,38,9,40],[13,38,13,40],[12,38,12,40],[24,38,25,40],[22,38,23,40],[32,38,32,40],[15,44,15,49],[16,44,16,49],[36,0,37,49],[31,16,31,34],[32,12,32,34],[27,0,28,6],[29,1,30,16],[30,18,30,34],[30,38,30,40],[22,1,23,9],[22,11,23,34],[24,1,25,6],[24,7,25,34],[15,21,15,34],[8,38,8,40],[20,44,21,49],[12,1,12,21],[12,22,12,34],[13,16,13,34],[14,1,15,20],[9,19,9,34],[10,11,10,34],[11,13,11,34],[15,38,15,40],[16,9,16,34],[16,38,16,40],[18,0,19,13],[20,1,21,13],[20,14,21,34],[20,38,21,40]]}
["Instructions:\nOnly edit the gray highlighted cells. Select the appropriate attribute for the location of interest. Adjust the Weight highlighted in gray to change the final weighted score. To edit the raw scores per each risk factor, edit the Scores column in the WeightedReference sheet."]
[]
[]
[]
[]
[]
[]
[]
["Location / Environmental Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,null,"Weight",null,null,"Weighted Score"]
[null,"Proximity to Land Uses or Pedestrian Attractors:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"½ to 1 mile to residential or commercial land uses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$3:$F$6,MATCH(T10,WeightReferences!$E$3:$E$6,0),2),\"\")","v":2},null,null,3,null,null,{"$f":"AM10*AP10","v":6}]
[null,"Operating Environment:",null,null,null,null,null,null,null,null,null,"2 or 3 lane undivided roadway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$7:$F$10,MATCH(L11,WeightReferences!$E$7:$E$10,0),2),\"\")","v":2},null,null,1,null,null,{"$f":"AM11*AP11","v":2}]
[null,"Pedestrian Crossing Distance1:",null,null,null,null,null,null,null,null,null,null,null,"< 34 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$11:$F$14,MATCH(N12,WeightReferences!$E$11:$E$14,0),2),\"\")","v":1},null,null,1,null,null,1]
[null,"Lighting Condition at Vehicle-Pedestrian Conflict Areas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$15:$F$17,MATCH(W13,WeightReferences!$E$15:$E$17,0),2),\"\")","v":2},null,null,2,null,null,4]
[null,"Vehicle Speed (Posted Speed Limit):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 or 45 MPH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$18:$F$21,MATCH(Q14,WeightReferences!$E$18:$E$21,0),2),\"\")","v":3},null,null,3,null,null,9]
[null,"Pedestrian Exposure to Vehicles/Vehicle Traffic on the Roadway (Average Daily Traffic):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 25,000 ADT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$22:$F$25,MATCH(V16,WeightReferences!$E$22:$E$25,0),2),\"\")","v":4},null,null,1,null,null,4]
[null,"Pedestrian Activity:",null,null,null,null,null,null,null,"Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$26:$F$28,MATCH(J17,WeightReferences!$E$26:$E$28,0),2),\"\")","v":2},null,null,3,null,null,6]
[]
["Infrastructure Factors"]
[]
[null,"Presence of Pedestrian Facilities:",null,null,null,null,null,null,null,null,null,null,null,null,"No Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$29:$F$32,MATCH(O21,WeightReferences!$E$29:$E$32,0),2),\"\")","v":4},null,null,3,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Paved Shoulder Width:",null,null,null,null,null,null,null,null,null,"1 - 4 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$33:$F$36,MATCH(L23,WeightReferences!$E$33:$E$36, 0),2),\"\")","v":3},null,null,3,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Median Type:",null,null,null,null,null,"None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$37:$F$40,MATCH(H25,WeightReferences!$E$37:$E$40,0),2),\"\")","v":4},null,null,3,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Other Factors"]
[]
[null,"Prior Vehicle-to-Pedestrian Crashes (Or Near Misses) within the Last Five Years2:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - 2 crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$41:$F$44,MATCH(S31,WeightReferences!$E$41:$E$44,0),2),\"\")","v":2},null,null,1,null,null,2]
[null,"Availability of Public Safety Services3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 - 60 minutes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$45:$F$47,MATCH(Q32,WeightReferences!$E$45:$E$47,0),2),\"\")","v":2},null,null,1,null,null,{"$f":"AM32*AP32","v":2}]
[null,"Project Scale & Complexity:",null,null,null,null,null,null,null,null,null,null,"High cost (> $1,000,000), complex countermeasures",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(WeightReferences!$E$48:$F$50,MATCH(M33,WeightReferences!$E$48:$E$50,0),2),\"\")","v":1},null,null,1,null,null,1]
["Risk Evaluation Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AM10:AO33)&\" /\"&WeightReferences!F51","v":"32 /50"},null,null,"or",null,null,{"$f":"SUM(AS10:AX33)&\" /\"&WeightReferences!H51","v":"70 /100"}]
[]
[]
["1: For a crossing related project\n2: Please attach crash reports or summaries, if available. If no formal reports are available, please attach a description of  events\n3: Average time elapsed from crash to arrival at treatment facility"]

{"sheet":"WeightReferences","index":3,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":true,"merged":[[21,3,24,3],[28,3,31,3],[32,3,35,3],[36,3,39,3],[40,3,43,3],[2,3,5,3],[6,3,9,3],[10,3,13,3],[14,3,16,3],[17,3,20,3],[40,1,49,1],[40,2,43,2],[40,8,43,8],[47,2,49,2],[47,8,49,8],[44,2,46,2],[47,3,49,3],[44,3,46,3],[28,1,39,1],[28,2,31,2],[28,8,31,8],[32,2,35,2],[32,8,35,8],[36,2,39,2],[36,8,39,8],[25,2,27,2],[25,8,27,8],[25,3,27,3],[2,1,27,1],[2,2,5,2],[2,8,5,8],[6,2,9,2],[6,8,9,8],[10,2,13,2],[10,8,13,8],[14,2,16,2],[14,8,16,8],[17,2,20,2],[17,8,20,8],[21,2,24,2],[21,8,24,8]]}
[]
[null,"Category","Criteria","Weight","Ranges","Scores","Weight","Weighted Score","Weight Reasoning / Additional Guidance"]
[null,null,"Proximity to Land Uses or Pedestrian Attractors",{"$f":"'Score Weighting'!$AP$10","v":3},"< ¼ mile to residential or commercial land uses",4,{"$f":"'Score Weighting'!$AP$10","v":3},{"$f":"F3*G3","v":12},"A majority (71%) of pedestrian fatal and serious injury crashes occurred within ¼ mile of an identified land use or potential pedestrian attractor—the most common identified land use was residential (64%), followed by commercial areas (14%), casinos (8%), and other community areas (e.g., government buildings, health centers, and Tribal buildings) (7%)"]
[null,null,null,null,"¼ to ½ mile to residential or commercial land uses",3,{"$f":"'Score Weighting'!$AP$10","v":3},9]
[null,null,null,null,"½ to 1 mile to residential or commercial land uses",2,{"$f":"'Score Weighting'!$AP$10","v":3},6]
[null,null,null,null,"> 1 mile to residential or commercial land uses",1,{"$f":"'Score Weighting'!$AP$10","v":3},3]
[null,null,"Operating Environment",{"$f":"'Score Weighting'!$AP$11","v":1},"6 or more lanes",4,{"$f":"'Score Weighting'!$AP$11","v":1},4]
[null,null,null,null,"4 or 5 lane undivided roadway",3,{"$f":"'Score Weighting'!$AP$11","v":1},3]
[null,null,null,null,"2 or 3 lane undivided roadway",2,{"$f":"'Score Weighting'!$AP$11","v":1},2]
[null,null,null,null,"4 lane divided roadway",1,{"$f":"'Score Weighting'!$AP$11","v":1},1]
[null,null,"Pedestrian Crossing Distance",{"$f":"'Score Weighting'!$AP$12","v":1},"> 73 ft",4,{"$f":"'Score Weighting'!$AP$12","v":1},4]
[null,null,null,null,"51 - 72 ft",3,{"$f":"'Score Weighting'!$AP$12","v":1},3]
[null,null,null,null,"34 - 50 ft",2,{"$f":"'Score Weighting'!$AP$12","v":1},2]
[null,null,null,null,"< 34 ft",1,{"$f":"'Score Weighting'!$AP$12","v":1},1]
[null,null,"Lighting Conditions at Vehicle-Pedestrian Conflict Areas",{"$f":"'Score Weighting'!$AP$13","v":2},"No lighting",2,{"$f":"'Score Weighting'!$AP$13","v":2},4,"A high proportion of total crashes (51%) occurred in dark conditions without lighting\nOf these crashes, most occurred where there were no other pedestrian facilities such as sidewalks for the pedestrian to use"]
[null,null,null,null,"Inadequate lighting",1,{"$f":"'Score Weighting'!$AP$13","v":2},2]
[null,null,null,null,"Adequate Lighting",0,{"$f":"'Score Weighting'!$AP$13","v":2},0]
[null,null,"Vehicle Speed (Posted Speed Limit)",{"$f":"'Score Weighting'!$AP$14","v":3},"> 50 MPH",4,{"$f":"'Score Weighting'!$AP$14","v":3},12,"Fewer fatal and serious injury crashes (10%) occurred on roadways with a posted speed limit of 25 mph or less"]
[null,null,null,null,"40 or 45 MPH",3,{"$f":"'Score Weighting'!$AP$14","v":3},9]
[null,null,null,null,"30 or 35 MPH",2,{"$f":"'Score Weighting'!$AP$14","v":3},6]
[null,null,null,null,"< 25 MPH",1,{"$f":"'Score Weighting'!$AP$14","v":3},3]
[null,null,"Pedestrian Exposure to Vehicles/Vehicle Traffic on the Roadway",{"$f":"'Score Weighting'!$AP$16","v":1},"> 25,000 ADT",4,{"$f":"'Score Weighting'!$AP$16","v":1},4]
[null,null,null,null,"5,001 - 25,000 ADT",3,{"$f":"'Score Weighting'!$AP$16","v":1},3]
[null,null,null,null,"1,001 - 5,000 ADT",2,{"$f":"'Score Weighting'!$AP$16","v":1},2]
[null,null,null,null,"< 1,000 ADT",1,{"$f":"'Score Weighting'!$AP$16","v":1},1]
[null,null,"Pedestrian Activity",{"$f":"'Score Weighting'!$AP$17","v":3},"High",4,{"$f":"'Score Weighting'!$AP$17","v":3},12,"Examples of “High” pedestrian activity includes the following locations:\n- Residential development with four or more housing units per acre interspersed with multifamily dwellings\n- Hotels located with ½ mile of other attractions such as retail stores, recreation areas, or senior centers\n- Downtown or Central Business District areas"]
[null,null,null,null,"Low",2,{"$f":"'Score Weighting'!$AP$17","v":3},6]
[null,null,null,null,"None",0,{"$f":"'Score Weighting'!$AP$17","v":3},0]
[null,"Infrastructure","Presence of Pedestrian Facilities",{"$f":"'Score Weighting'!$AP$21","v":3},"No Facilities",4,{"$f":"'Score Weighting'!$AP$21","v":3},12,"Most crashes occurred at locations without pedestrian facilities such as crosswalks, sidewalks, or shared-use paths.\nSome Facilities: Fragmented sidewalk, Sidewalk on only one side of roadway, Signage only\t\t\t\t\nAdequate Facilities: Sidewalks on both sides of roadway, Separated sidewalk or paved path on one side of roadway, Separated sidewalk or paved path on both sides of roadway, Marked (painted) crosswalk and static signage\t\t\nEnhanced Facilities: Bulb-outs/curb extensions, Median refuge island(s), Pedestrian signal (pedestrian hybrid beacon, rectangular rapid-flashing beacon) "]
[null,null,null,null,"Some Facilities",2,{"$f":"'Score Weighting'!$AP$21","v":3},6]
[null,null,null,null,"Adequate Facilities",1,{"$f":"'Score Weighting'!$AP$21","v":3},3]
[null,null,null,null,"Enhanced Facilities",0,{"$f":"'Score Weighting'!$AP$21","v":3},0]
[null,null,"Paved Shoulder Width",{"$f":"'Score Weighting'!$AP$23","v":3},"0 - 1 ft",4,{"$f":"'Score Weighting'!$AP$23","v":3},12,"Collected data show 3% of analyzed crashes occurred on unpaved roadway surfaces (dirt/gravel), which typically have reduced speeds compared to paved roads"]
[null,null,null,null,"1 - 4 ft",3,{"$f":"'Score Weighting'!$AP$23","v":3},9]
[null,null,null,null,"5 - 9 ft",2,{"$f":"'Score Weighting'!$AP$23","v":3},6]
[null,null,null,null,"> 10 ft",1,{"$f":"'Score Weighting'!$AP$23","v":3},3]
[null,null,"Median Type",{"$f":"'Score Weighting'!$AP$25","v":3},"None",4,{"$f":"'Score Weighting'!$AP$25","v":3},12,"A majority (52%) of fatal and serious injury pedestrian crashes occurred on undivided roadways with no median"]
[null,null,null,null,"Two-way left-turn lane",3,{"$f":"'Score Weighting'!$AP$25","v":3},9]
[null,null,null,null,"Earth median (divided roadway)",2,{"$f":"'Score Weighting'!$AP$25","v":3},6]
[null,null,null,null,"Barrier/Cable ",1,{"$f":"'Score Weighting'!$AP$25","v":3},3]
[null,"Other","Prior Vehicle-to-Pedestrian Crashes (or Near-Misses) within the Last Five Years",{"$f":"'Score Weighting'!$AP$31","v":1},"5 or more crashes",4,{"$f":"'Score Weighting'!$AP$31","v":1},4]
[null,null,null,null,"3 - 4 crashes",3,{"$f":"'Score Weighting'!$AP$31","v":1},3]
[null,null,null,null,"1 - 2 crashes",2,{"$f":"'Score Weighting'!$AP$31","v":1},2]
[null,null,null,null,"No crashes (or a history of near-misses)",1,{"$f":"'Score Weighting'!$AP$31","v":1},1]
[null,null,"Availability of Public Safety Services",{"$f":"'Score Weighting'!$AP$32","v":1},"> 1 hour",4,{"$f":"'Score Weighting'!$AP$32","v":1},4]
[null,null,null,null,"16 - 60 minutes",2,{"$f":"'Score Weighting'!$AP$32","v":1},2]
[null,null,null,null,"< 15 minutes",0,{"$f":"'Score Weighting'!$AP$32","v":1},0]
[null,null,"Project Scale and Complexity",{"$f":"'Score Weighting'!$AP$33","v":1},"Low cost (<$200,000), simple countermeasures",4,{"$f":"'Score Weighting'!$AP$33","v":1},4]
[null,null,null,null,"Medium cost ($200,000 - $1,000,000), moderate countermeasures",2,{"$f":"'Score Weighting'!$AP$33","v":1},2]
[null,null,null,null,"High cost (> $1,000,000), complex countermeasures",1,{"$f":"'Score Weighting'!$AP$33","v":1},1]
[null,null,null,null,null,{"$f":"F3+F7+F11+F15+F18+F22+F26+F29+F33+F37+F41+F45+F48","v":50},null,{"$f":"H3+H7+H11+H15+H18+H22+H26+H29+H33+H37+H41+H45+H48","v":100}]

{"sheet":"References","index":4,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[[31,1,42,1],[43,1,49,1],[2,1,30,1],[2,2,4,2],[5,2,8,2],[9,2,12,2],[13,2,16,2],[17,2,19,2],[20,2,23,2],[24,2,27,2],[28,2,30,2],[31,2,34,2],[35,2,38,2],[39,2,42,2],[43,2,46,2],[47,2,49,2],[2,3,4,3],[5,3,8,3],[9,3,12,3],[13,3,16,3],[17,3,19,3],[39,3,42,3],[43,3,46,3],[47,3,49,3],[20,3,23,3],[24,3,27,3],[28,3,30,3],[31,3,34,3],[35,3,38,3]]}
[null,null,null,null,null,null,null,null,null,"Previous"]
[null,"Category","Criteria","Guidance","Ranges","Scores","Supporting Information Responses",null,null,"Scores",null,"Changes"]
[null,"Location/Environment","Project Scale and Complexity",null,"Low cost (<$200,000), simple countermeasures",4,"The project could be implemented with simple countermeasures identified with relative low cost. Example countermeasures may include striping, signage, rumble strips, education/enforcement campaigns, planning studies, etc. ",null,null,4]
[null,null,null,null,"Medium cost ($200,000 - $1,000,000), moderate countermeasures",2,"The project includes moderate countermeasures that may require infrastructure changes. Examples may include widening paved shoulders, lighting, traffic calming, marked and signed pedestrian crossings, etc. ",null,null,2]
[null,null,null,null,"High cost (> $1,000,000), complex countermeasures",1,"The project includes complex countermeasures typically associated with infrastructure changes resulting in higher costs. Examples may include paving pathways, installing sidewalks, widening of roadways, grade-separating pedestrian facilities, new intersections, etc.  ",null,null,1]
[null,null,"Proximity to Land Uses or Pedestrian Attractors",null,"< ¼ mile to residential or commercial land uses",8,"This location is within a 1/4 mile of a pedestrian attractor or residential land use. A majority (71%) of pedestrian fatal and serious injury crashes in Tribal areas occurred within a ¼ mile of an identified land use or potential pedestrian attractor.",null,null,4]
[null,null,null,null,"¼ to ½ mile to residential or commercial land uses",2,"This location is between ¼ and ½ mile to pedestrian attractors or residential land uses.  Approximately 15% of fatal and serious injury crashes in Tribal areas occurred between 1/4 and 1/2 mile from an attractor or residential land use.",null,null,3]
[null,null,null,null,"½ to 1 mile to residential or commercial land uses",1,"This location is between ½  to 1 mile from pedestrian attractors or residential land uses.  Approximately 6% of fatal and serious injury crashes in Tribal areas occurred between 1/2 mile to a mile from an attractor or residential land use.",null,null,2]
[null,null,null,null,"> 1 mile to residential or commercial land uses",0,"This location is more than 1 mile from a pedestrian attractor or residential land use. Fewer pedestrian crashes occurred more than 1 mile away from attractors or residentila land uses (approximately 7%). ",null,null,1]
[null,null,"Operating Environment",null,"6 or more lanes",4,"6 or more lane roadways are often located in urban areas with many vehicle driveways/access locations. 6 or more lane roadways introduce sight issues between vehicles and pedestrians and increase exposure and crossing distances for pedestrians. 35% of crashes analyzed occurred on principal/major arterial roadways, typical of 6 or more lane roadways. ",null,null,4]
[null,null,null,null,"4 or 5 lane undivided roadway",3,"4 or 5 lane undivided roadways are often located in more urban areas with many vehicle driveways/access locations. 35% of crashes analyzed ocured on principal/major arterial roadways, typical of 4 or 5 lane roadways in urban areas. ",null,null,3]
[null,null,null,null,"2 or 3 lane undivided roadway",2,"Nearly 47% of pedestrian fatal or serious injury crashes analyzed occurred on two lane roadways. This operating environment may not include adequate pedestrian facilities and often have higher speed limits. ",null,null,2]
[null,null,null,null,"4 lane divided roadway",1,"4 lane divided roadways provide some directional separation but still pose a risk to pedestrians. Division allows for potential pedestrian refuge at crossings. These roadways introduce sight issues between vehicles and pedestrians. ",null,null,1]
[null,null,"Pedestrian Crossing Distance",null,"> 73 ft",4,"A crossing distance of 73 ft. or greater exposes the pedestrian to vehicles for a long period of time. A PHB (or other countermeasure) would be appropriate for this crossing distance if the roadway has between ~250 to 500 vehicles per hour.  Crossing distances and vehicle volumes are based on the typical crossing distances noted for pedestrian hybrid beacon warrants in the MUTCD (MUTCD Section 4J). 23% of crashes analyzed occurred at signalized or unsignalized intersections. ",null,null,4]
[null,null,null,null,"51 - 72 ft",3,"With a crossing distance of 51-72 ft., a PHB (or other countermeasure) would be appropriate if the roadway has between ~750-1000 vehicles per hour.  Crossing distances and vehicle volumes are based on the typical crossing distances noted for pedestrian hybrid beacon warrants in the MUTCD (MUTCD Section 4J). 23% of crashes analyzed occurred at signalized or unsignalized intersections. ",null,null,3]
[null,null,null,null,"34 - 50 ft",2,"With a crossing distance of 34-50 ft., a PHB (or other countermeasure) would be appropriate if the roadway has between ~1000 to 1500 vehicles per hour.  Crossing distances and vehicle volumes are based on the typical crossing distances noted for pedestrian hybrid beacon warrants in the MUTCD (MUTCD Section 4J). ",null,null,2]
[null,null,null,null,"< 34 ft",1,"Reducing the required pedestrian crossing distance reduces vehicle to pedestrian exposure and risk. With a crossing distance of 34 ft. or less, a PHB (or other countermeasure) would be appropriate if the roadway has more than ~1500 vehicles per hour.  Crossing distances and vehicle volumes are based on the typical crossing distances noted for pedestrian hybrid beacon warrants in the MUTCD (MUTCD Section 4J). ",null,null,1]
[null,null,"Lighting Conditions at Vehicle-Pedestrian Conflict Areas",null,"No lighting",2,"A high proportion (51%) of the fatal and serious injury pedestrian crashes reviewed occurred in dark, not lighted conditions. ",null,null,2]
[null,null,null,null,"Inadequate lighting",1,"Nearly 18% of the fatal and serious injury pedestrian crashes reviewed occurred in dark, lighted conditions. Although lighting may be present, it may not be focused on the potential vehicle to pedestrian conflict area. Lighting may not be focused on crossings, junctions, etc. ",null,null,1]
[null,null,null,null,"Adequate Lighting",0,"This location has adequate lighting at the vehicle-pedestrian conflict area (sidewalk, crossings, intersections, etc.). ",null,null,0]
[null,null,"Vehicle Speed (Posted Speed Limit)",null,"> 50 MPH",8,"This location has a posted speed limit of 50 mph or higher. Nearly half (47%) of fatal and serious injury pedestrian crashes evaluated occurred on roadways with a posted speed limit of 50 mph or greater. ",null,null,4]
[null,null,null,null,"40 or 45 MPH",4,"This location has a posted speed limit of 40 or 45mph.  12% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with a posted speed limit of 40 or 45 mph. ",null,null,3]
[null,null,null,null,"30 or 35 MPH",1,"This location has a posted speed limit of 30 or 35mph.  13% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with a posted speed limit of 30 or 35 mph. ",null,null,2]
[null,null,null,null,"< 25 MPH",0,"This location has a posted speed limit of 25mph or less.  Fewer fatal and serious injury pedestrian crashes (10%) occurred on roadways with posted speed limit of 25 MPH or less.",null,null,1]
[null,null,"Pedestrian Exposure to Vehicles/Vehicle Traffic on the Roadway",null,"> 25,000 ADT",4,"This location has average daily traffic exceeding 25,000 vehicles. Pedestrian exposure to vehicles is very high. 50% of crashes analyzed occurred on principal/major arterial or minor arterial roadways, typical of higher volume roadways.  ",null,null,4]
[null,null,null,null,"5,001 - 25,000 ADT",3,"This location has average daily traffic between 5,000 and 25,000 vehicles. Pedestrian exposure to vehicles is high. 50% of crashes analyzed occurred on principal/major arterial or minor arterial roadways, typical of higher volume roadways. ",null,null,3]
[null,null,null,null,"1,001 - 5,000 ADT",2,"This location has average daily traffic between 1,000 and 5,000 vehicles. Pedestrian exposure to vehicles is moderate. ",null,null,2]
[null,null,null,null,"< 1,000 ADT",1,"This location has average daily traffic of 1,000 vehicles or less. Pedestrian exposure to vehicles is low. ",null,null,1]
[null,null,"Pedestrian Activity","Pedestrian Activity, as defined in the FHWA Pedestrian Lighting Primer (April 2022): \nHigh/Medium: over 10 pedestrians in a peak hour (examples may include downtown retail or office areas, libraries, community buildings,event centers, or transit stops)\nLow: 10 or fewer pedestrians in a peak hour (examples may include low density residential areas, semi-rural or surburban areas, etc)","High",4,"The project will serve a \"high\" pedestrian activity area/location. \n71% of pedestrian crashes reviewed occurred within 1/4-mile of an identified land use or pedestrian attractor. \nPedestrian Activity, as defined in the FHWA Pedestrian Lighting Primer (April 2022): \nHigh/Medium: over 10 pedestrians in a peak hour (examples may include downtown retail or office areas, libraries, community buildings,event centers, or transit stops)\nLow: 10 or fewer pedestrians in a peak hour (examples may include low density residential areas, semi-rural or surburban areas, etc)",null,null,4]
[null,null,null,null,"Low",2,"The project will serve a pedestrian activity area/location, just not a \"high\" pedestrian location as defined below. \n71% of pedestrian crashes reviewed occurred within 1/4-mile of an identified land use or pedestrian attractor. Pedestrian Activity, as defined in the FHWA Pedestrian Lighting Primer (April 2022): \nHigh/Medium: over 10 pedestrians in a peak hour (examples may include downtown retail or office areas, libraries, community buildings,event centers, or transit stops)\nLow: 10 or fewer pedestrians in a peak hour (examples may include low density residential areas, semi-rural or surburban areas, etc) ",null,null,2]
[null,null,null,null,"None",0,"The project location does not typically serve pedestrians. 7% of crashes reviewed occurred at locations further than 1 mile away from a  pedestrian attractor. ",null,null,0]
[null,"Infrastructure","Presence of Pedestrian Facilities","Some Facilities: Fragmented sidewalk, Sidewalk on only one side of roadway, Signage only for crossings. \t\t\t\t\nAdequate Facilities: Sidewalks on both sides of roadway, Separated sidewalk or paved path on one side of roadway, Separated sidewalk or paved path on both sides of roadway, Marked (painted) crosswalk and signage\t\t\nEnhanced Facilities: Bulb-outs/curb extensions, Median refuge island(s), Pedestrian crossing signal (pedestrian hybrid beacon, rectangular rapid-flashing beacon) ","No Facilities",8,"The project location has no pedestrian facilities (crosswalk, sidewalk, shared-use path, etc.). Nearly 73% of pedestrian fatal and serious injury crashes occurred on a roadway segment or intersection with no pedestrian facilities. ",null,null,4]
[null,null,null,null,"Some Facilities",4,"The project location has limited or \"some\" facilities. Examples of \"some\" facilities includes fragmented sidewalk, sidewalk on only one side of the roadway, or signage only (no infrastructure). 23% of crashes evaluated occurred where pedestrian faciltiies were present. ",null,null,2]
[null,null,null,null,"Adequate Facilities",1,"The project location has adequate pedestrian facilities. Examples of \"adequate\" facilities may include sidewalks on both sides of a roadway, separated sidewalk or a shared-use path, marked (painted) crosswalk and signage, etc. 23% of crashes evaluated occurred where pedestrian faciltiies were present. ",null,null,1]
[null,null,null,null,"Enhanced Facilities",0,"The project location already has enhanced pedestrian facilities. Examples of \"enhanced\" facilities may include specific pedestrian infrastructure such as bulb-outs/curb extensions, median refuge island(s), or pedestrian signals such as a PHB or RRFBs. ",null,null,0]
[null,null,"Paved Shoulder Width",null,"0 - 1 ft",4,"16% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with no shoulder or a shoulder of 1 ft. or less. Shoulders less than 4 feet in width have an increased risk of pedestrian injury. ",{"$f":"62/392","v":0.15816326530612246},null,4]
[null,null,null,null,"1 - 4 ft",3,"15% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with paved shoulder widths of 1 to 4 ft. Shoulders less than 4 feet in width have an increased risk of pedestrian injury. ",{"$f":"58/392","v":0.14795918367346939},null,3]
[null,null,null,null,"5 - 9 ft",2,"29% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with paved shoulder widths of 5 to 9 ft. Shoulders less than 4 feet in width have an increased risk of pedestrian injury. ",{"$f":"112/392","v":0.2857142857142857},null,2]
[null,null,null,null,"> 10 ft, curb/gutter, or sidewalk/pathway present",1,"16% of fatal and serious injury pedestrian crashes evaluated occurred on roadways with shoulders 10 ft. wide or more.  Of crashes evaluated occurring on a roadway segment (not at intersection), 17% of crashes occurred where pedestrian facilities (sidewalk/pathway) were present. ",null,null,1]
[null,null,"Median Type",null,"None",4,"52% of fatal or serious injury pedestrian crashes evaluated occurred on undivided roadways with no center median. ",null,null,4]
[null,null,null,null,"Two-way left-turn lane",3,"11% of fatal or serious injury pedestrian crashes evaluated occurred where a TWLTL was present. ",null,null,3]
[null,null,null,null,"Earth median (divided roadway)",2,"9% of fatal or serious injury pedestrian crashes evaluated occurred where an earth median was present. ",{"$f":"30/392","v":7.6530612244897961E-2},null,2]
[null,null,null,null,"Barrier/cable or pedestrian refuge island",1,"8% of fatal or serious injury pedestrian crashes evaluated occurred where a center barrier or cable was present. ",{"$f":"+H42/392","v":1.9523115368596418E-4},null,1]
[null,"Other","Prior Vehicle-to-Pedestrian Crashes (or Near-Misses) within the Last Five Years",null,"5 or more crashes",4,"The project is in a location with a known history of many (5+) vehicle to pedestrian crashes within the last five years. ",null,null,4]
[null,null,null,null,"3 - 4 crashes",3,"The project is in a location with a known history of some (3-4) vehicle to pedestrian crashes within the last five years. ",null,null,3]
[null,null,null,null,"1 - 2 crashes",2,"The project is in a location with a known history (1-2 crashes) of vehicle to pedestrian crashes within the last five years. ",null,null,2]
[null,null,null,null,"No crashes (or a history of near-misses)",1,"The project is in a location with a history of near-misses but no actual recorded crashes. ",null,null,1]
[null,null,"Availability of Public Safety Services",null,"> 1 hour",4,"The project is in a location where the average time elapsed from a crash to arrival at a treatment facility exceeds 60 minutes. ",null,null,4]
[null,null,null,null,"16 - 60 minutes",2,"The project is in a location where the average time elapsed from a crash to arrival at a treatment facility is between 16 to 60 minutes. ",null,null,2]
[null,null,null,null,"< 15 minutes",0,"The project is in a location where the average time elapsed from a crash to arrival at a treatment facility is 15 minutes or less. ",null,null,0]
[null,null,null,null,null,{"$f":"F3+F6+F10+F14+F18+F21+F25+F29+F32+F36+F40+F44+F48","v":62},"Risk Score Points Available",null,null,109]