{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["User Guide","Software Selection Tool","Tool Notes","Revision History","Scratchwork"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User Guide","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Version 1.2"]
[null,null,null,null,null,"Last Revised: 10/2022"]

{"sheet":"Software Selection Tool","index":1,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"a"]
[null,"Analysis Number","Analysis Category","Analysis Type","Over / Under Saturated","Location Type","MOE","Microsimulation Required","HCS","Synchro","SIDRA\nIntersection","FREEVAL","SimTraffic","VISSIM","TransModeler","Aimsun","Extended HSM Spreadsheets","IHSDM","ISATe","SSAM","NOTES","COMMENTS"]
[null,1,"Interrupted-Flow Operations Analyses","Arterial Operations","Oversaturated","Segment and Facility","Delay (Control Delay, Microsimulation Delay)","No","ü\nControl Delay","ü\nControl Delay",null,null,"ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay"]
[null,2,"Interrupted-Flow Operations Analyses","Arterial Operations","Oversaturated","Segment and Facility","Queue (95th Percentile Queue, Maximum Queue)","No","ü\n95th Percentile Queue","ü\n95th Percentile Queue",null,null,"ü\nMaximum Queue","ü\nMaximum Queue","ü\nMaximum Queue","ü\nMaximum Queue"]
[null,3,"Interrupted-Flow Operations Analyses","Unsignalized Intersection Operations (AWS and TWS)","Oversaturated","Segment and Facility","Delay (Control Delay, Microsimulation Delay)","No",null,"ü\nControl Delay",null,null,"ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay"]
[null,4,"Interrupted-Flow Operations Analyses","Unsignalized Intersection Operations (AWS and TWS)","Oversaturated","Segment and Facility","Speed (Time Mean Speed, Space Mean Speed)","No",null,"ü\nSpace Mean Speed",null,null,"ü\nSpace Mean Speed","ü\nSpace Mean Speed\nTime Mean Speed","ü\nSpace Mean Speed\nTime Mean Speed","ü\nSpace Mean Speed\nTime Mean Speed"]
[null,5,"Interrupted-Flow Operations Analyses","Unsignalized Intersection Operations (AWS and TWS)","Oversaturated","Point","Delay (Control Delay, Microsimulation Delay)","No","ü\nControl Delay","ü\nControl Delay",null,null,"ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay"]
[null,6,"Interrupted-Flow Operations Analyses","Signalized Intersection Operations","Oversaturated","Point","Delay (Control Delay, Microsimulation Delay)","No","ü\nControl Delay","ü\nControl Delay",null,null,"ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay","ü\nMicrosimulation Delay",null,null,null,null," 1. HCS/FREEVAL/Synchro may be used for screening purposes under oversaturated conditions."]

{"sheet":"Tool Notes","index":2,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Note","Analysis Cat","Analysis Type","N=All locations and Saturation\nP=Point,   S=Segments and Facilities, C=Corridor, Area, and System, U=Undersaturated, O=Oversaturated, M=Microsimulation,\nX=No Microsimulation,\nT=Travel Time, V=V/C Ratio, Y=Any MOE Except Travel Time and V/C Ratio\n\nN can only be combined with T, V, or Y","NOTE: For any '&' statements, list Location Type then Saturation"]
[null,null,null,"IF","OR","OR"]
[]
["Synchro is the preferred tool for this type of analysis.","Interrupted-Flow","Signalized Intersection Operations","U&X"]
["HCS/FREEVAL/Synchro may be used for screening purposes under oversaturated conditions.","Interrupted-Flow","Signalized Intersection Operations","O&X&P"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Signalized Intersection Preemption/Transit Priority","N"]
["HCS is the preferred tool for this type of analysis.","Interrupted-Flow","Unsignalized Intersection Operations (AWS and TWS)","P&U&X"]
["SIDRA Intersection or HCS may be used for this type of analysis. HCS has limitations related to complex roundabouts.  A SIDRA Intersection or HCS analysis is required to accompany any roundabout analysis completed using microsimulation tools.","Interrupted-Flow","Roundabout Operations","N"]
["Microsimulation is the preferred tool for networks including roundabouts.","Interrupted-Flow","Roundabout Operations","S","C"]
["If roundabouts are included in a study area analyzed by Synchro or Vistro, they should be analyzed using SIDRA Intersection or HCS.","Interrupted-Flow","Roundabout Operations","S&U&X","C&U&X",null,null,null,"ü","ü","ü",null,"ü","ü","ü","ü"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Non-Traditional Intersection Operations (5-Legs,SPUI)","N&T","N&Y",null,null,null,"ü","ü","ü",null,"ü","ü","ü","ü"]
["Synchro has the capability to model DDI, CFI, CGT, and 5-legged intersections for undersaturated conditions.","Interrupted-Flow","Non-Traditional Intersection Operations (5-Legs,SPUI)","U&X&Y","U&X&V",null,null,null,"ü","ü","ü",null,"ü","ü","ü","ü"]
["Synchro has the capability to model SPUI intersections for undersaturated conditions.","Interrupted-Flow","Non-Traditional Intersection Operations (5-Legs,SPUI)","U&X&Y","U&X&V"]
["SimTraffic has the capability to model DDI, SPUI, CFI, CGT, and 5-legged intersections.","Interrupted-Flow","Non-Traditional Intersection Operations (5-Legs,SPUI)","N&T","N&Y"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Parking Operations","N"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Public Transit Operations (BRT,LRT,etc.)","N"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Adaptive Signal Control Technologies (ASCT) Operations","N"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Pedestrian and Bicycle Simulation and Analysis","N"]
["Microsimulation is the preferred tool for this type of analysis.","Interrupted-Flow","Multimodal Facilities","N"]
["HCS or FREEVAL are the preferred tools for this type of analysis for all MOEs except queue, v/c ratio, and travel time.","Uninterrupted-Flow","Freeway Segment Operations (Limited Access)","S&U&X&Y"]
["HCS and FREEVAL may be used for screening purposes under oversaturated conditions.","Uninterrupted-Flow","Freeway Segment Operations (Limited Access)","S&U&M"]
["HCS and FREEVAL may be used for screening purposes under oversaturated conditions.","Uninterrupted-Flow","Freeway Segment Operations (Limited Access)","S&O"]
["The HCS Facilities Module is the only module that can output v/c ratio for this type of analysis.","Uninterrupted-Flow","Freeway Segment Operations (Limited Access)","S&U&X&V"]
["The HCS Facilities Module is the only module that can output travel time for this type of analysis.","Uninterrupted-Flow","Freeway Segment Operations (Limited Access)","S&U&X&T"]
["HCS and FREEVAL are the preferred tools for this type of analysis for all MOEs except queue, v/c ratio, and travel time.","Uninterrupted-Flow","Merge/Diverge Operations","S&U&X&Y"]
["The HCS Facilities Module is the only module that can output v/c ratio for this type of analysis.","Uninterrupted-Flow","Merge/Diverge Operations","S&U&X&V"]
["The HCS Facilities Module is the only module that can output travel time for this type of analysis.","Uninterrupted-Flow","Merge/Diverge Operations","S&U&X&T"]
["HCS and FREEVAL are the preferred tools for this type of analysis for all MOEs except queue and travel time.","Uninterrupted-Flow","Weaving Segment Operations","S&U&X&Y","S&U&X&V"]
["The HCS Facilities Module is the only module that can output travel time for this type of analysis","Uninterrupted-Flow","Weaving Segment Operations","S&U&X&T"]
["Microsimulation is the preferred tool for this type of analysis.","Uninterrupted-Flow","Freeway HOV/Ramp Metering Operations/Managed Lanes","N"]
["The HCS Facilities Module is the only module that can output travel time for this type of analysis.","Uninterrupted-Flow","Collector-Distributor Facilities","S&U&X&T"]
["The HCS Facilities Module is the only module that can output v/c ratio for this type of analysis.","Uninterrupted-Flow","Collector-Distributor Facilities","S&U&X&V"]
["HCS is the preferred tool for this type of analysis for all MOEs except queue and density.","Uninterrupted-Flow","Two-Lane Highway Operations","S&U&X"]
["HCS is the preferred tool for this type of analysis for all MOEs except queue and travel time.","Uninterrupted-Flow","Multi-Lane Highway Operations","S&U&X&Y"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Toll Plaza Operations","N"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Toll Plaza Operations","P","S"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Gated Operations","N"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Gated Operations","P","S"]
["Microsimulation is the preferred tool for this type of analysis when oversaturated conditions exist. ","Miscellaneous","Work Zone Traffic Operations (Arterials)","N"]
["Users should verify that work zones do not cause oversaturated conditions prior to selecting a traffic analysis tool.","Miscellaneous","Work Zone Traffic Operations (Arterials)","U"]
["The Missouri Department of Transportation has developed a spreadsheet that may be utilized for deterministic capacity, queue, and travel delay analyses at work zones: http://epg.modot.org/files/0/04/616.13_WZ_Impact_Dec_2016.xlsm","Miscellaneous","Work Zone Traffic Operations (Arterials)","N"]
["Microsimulation is the preferred tool for this type of analysis when oversaturated conditions exist. ","Miscellaneous","Work Zone Traffic Operations (Freeways)","N"]
["Users should verify that work zones do not cause oversaturated conditions prior to selecting a traffic analysis tool.","Miscellaneous","Work Zone Traffic Operations (Freeways)","U"]
["The Missouri Department of Transportation has developed a spreadsheet that may be utilized for deterministic capacity, queue, and travel delay analyses at work zones: http://epg.modot.org/files/0/04/616.13_WZ_Impact_Dec_2016.xlsm. The HCM 6th Edition freeway work zone capacity methodology should be utilized to determine site-specific capacity values.","Miscellaneous","Work Zone Traffic Operations (Freeways)","N"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Active Traffic Management (ATM)","N"]
["Microsimulation is the preferred tool for this type of analysis.","Miscellaneous","Dynamic Traffic Assignment (DTA)","N"]
["IHSDM is the preferred tool for this analysis type, especially when geometric data can be imported from CAD files","Safety","Rural Two-Lane Roads","N"]
["IHSDM is the preferred tool for this analysis type, especially when geometric data can be imported from CAD files","Safety","Rural Multi-Lane Roads","N"]
["IHSDM is the preferred tool for this analysis type, especially when geometric data can be imported from CAD files","Safety","Urban and Suburban Arterials","N"]
["IHSDM is the preferred tool for this analysis type, especially when geometric data can be imported from CAD files","Safety","Freeway Facilities and Interchanges","N"]
["Users should verify that other safety analysis tools are not applicable prior to selecting SSAM","Safety","Non-Traditional Safety Analyses","N"]

{"sheet":"Revision History","index":3,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Version 1.0 - April 2019"]
["1. Updated and rebranded VDOT SST for use in Kentucky"]
["2. Updated software versions relevant to this tool (listed under \"Disclaimers\"), including the addition of TransModeler and Aimsun"]
["3. Moved SST user interface to a single tab"]
["4. Updated the \"Notes\" applicable to each scenario"]
[]
["Version 1.1 - December 2021"]
["1. Updated VBA script for compatibility with 32- and 64-bit versions of Excel, resizing of User Form, and autosizing of table rows"]
[]
["Version 1.2 - HDR Edits - October 2022"]
["1. Allowed use of HCS for roundabouts (including \"Notes\" updates)"]
["2. Allowed use of HCS, FREEVAL, and Synchro under oversaturated conditions for screening"]

{"sheet":"Scratchwork","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,0,5,0],[4,2,5,2]]}
["Links"]
["Safety Tools","Link","Release Date"]
["Extended HSM Spreadsheets (Version 9)","http://safetyperformance.org/tools/","August 2016"]
["IHSDM - HSM Predictive Method (Version 14)","http://www.ihsdm.org/wiki/Welcome","March 2019"]
["SSAM (Version 3)","https://highways.dot.gov/safety/ssam/surrogate-safety-assessment-model-overview","January 2017"]
[null,"https://www.fhwa.dot.gov/publications/research/operations/17027/index.cfm"]
["ISATe (Build 6.10)","http://www.highwaysafetymanual.org/Pages/tools_sub.aspx","October 2011"]
[]
["Work Zone Tools"]
["(INSERT HERE)"]