{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Introduction","Project Information","Definitions","Control Strategy Selection","Ramp Terminal Inputs","RTI_Ranges","At-Grade Inputs","Calibration","ExistingData","CalibrationDefaults","Historical","HistoricalRTI","Results","ResultsRTI","Notes","User Selections","Labels","Changelog"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":514,"comments":6,"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":"Introduction","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,1,14,2],[3,1,3,2],[0,0,0,2],[1,0,1,2],[2,1,2,2],[5,0,5,2],[4,0,4,2],[6,0,6,2],[7,0,7,2],[10,0,10,2],[11,0,11,2],[13,0,13,2],[9,0,9,2],[8,0,8,2]]}
["Federal Highway Administration (FHWA)"]
["Safety Performance for Intersection Control Evaluation Tool"]
["Introduction","Overview"]
["The Safety Performance for Intersection Control Evaluation (SPICE) Tool was developed to provide an easy-to-use tool that automates the predictive safety analysis of intersections. This tool will allow analysts conducting Intersection Control Evaluations (ICE) to be equipped with necessary safety information during the decision-making process, without having to research a myriad of crash modification factors (CMFs) and Safety Performance Functions (SPFs) in multiple sources.  The SPICE tool will perform a comparative predictive safety analysis of different intersection control strategies. The results – crash frequency and severity for each alternative – will then enable safety performance of alternatives to be considered quantitatively like traffic operations, construction cost, maintenance cost, or other factors. ","The SPICE Tool performs safety analysis of at-grade intersection forms/control types and ramp terminal intersections of diamond interchanges. This user-friendly tool requires only data inputs that are readily available to the analyst. In addition, the SPICE tool has an option to conduct planning level analysis, where the tool assumes default values for data inputs that are challenging to obtain in the early stages of a project and/or have a very minor impact on the results.  The SPICE tool assumes that certain attributes of the intersection – AADT, facility type, and number of legs – are the same for all alternatives. If they are not, users will be required to use the tool twice to get results. The tool will not allow simultaneous evaluation of at-grade intersections and ramp terminal intersections. For projects where analysis of both intersections and interchanges is needed, users are required use the tool twice to get results."]
["Worksheets"]
["Project Information: Provide general project information for reference purposes only."]
["Definitions: Reference sheet with additional information related to inputs for the SPICE tool."]
["Control Strategy Selection: Choose between At-Grade or Ramp Terminal intersection types to be included in the SPICE analysis."]
["At-Grade Inputs: SPF and Part C CMF inputs for At-Grade intersections (hidden if Ramp Terminals are being analyzed)."]
["Ramp Terminal Inputs: SPF and Part C CMF inputs for Ramp Terminal intersections (hidden if At-Grade intersections are being analyzed)."]
["Calibration: Input optional override values for SPF calibration factors from locally-developed or updated information. "]
["Results: Summary of opening year and (if applicable) design year and total project life cycle crash frequency and crash severity. "]
[]
["Additional Worksheets: Additional worksheets to support the underlying Macros. Not to be updated by users unless updating future tool versions. "]
["Maintenance ","Input Legend"]
["Version: SPICE Tool 3.3     [Changelog]",null,"Required data entry field"]
["Maintained By: TBD",null,"Optional data entry field"]
["Contact Information: TBD",null,"Planning-Level Default Input"]
["Disclaimer",null,"Data entry field not used"]
["Disclaimers may be added, if needed."]

{"sheet":"Project Information","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,16,0],[0,0,0,2],[1,0,1,2],[2,1,2,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["Project Information"]
["Provide general project information for reference purposes only."]
["Project Name:"]
["Intersection:"]
["Agency: "]
["Project Reference:"]
["City:"]
["State:"]
["Date:"]
["Analyst:"]
["Use this button to clear all inputs/outputs and reset the tool to its initial defaults"]

{"sheet":"Definitions","index":2,"n_rows":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":false,"merged":[[51,1,52,1],[43,0,44,0],[47,0,48,0],[45,0,46,0],[51,0,52,0],[51,2,52,2],[7,3,7,5],[0,8,0,12],[1,8,1,12],[47,2,48,2],[0,0,0,5],[1,0,1,5],[41,2,42,2],[41,0,42,0],[41,1,42,1],[43,1,44,1],[45,1,46,1],[47,1,48,1],[28,9,28,10],[28,11,28,12],[2,11,2,12],[17,9,17,10],[17,11,17,12],[16,8,16,12],[2,9,2,10],[6,0,6,5],[9,9,9,10],[9,11,9,12],[8,8,8,12],[2,8,3,8],[9,8,10,8],[45,2,46,2],[43,2,44,2],[13,4,13,5],[2,3,2,5],[4,0,4,5],[2,0,3,0],[2,1,3,1],[2,2,3,2],[35,1,36,1],[31,2,32,2],[33,2,34,2],[35,2,36,2],[19,0,20,0],[21,0,22,0],[23,0,24,0],[25,0,26,0],[16,14,17,18],[18,14,19,14],[18,15,18,16],[18,17,18,18],[0,14,0,18],[1,15,1,16],[1,17,1,18],[27,0,28,0],[29,0,30,0],[31,0,32,0],[33,0,34,0],[35,0,36,0],[19,1,20,1],[21,1,22,1],[23,1,24,1],[19,2,20,2],[27,1,28,1],[29,1,30,1],[31,1,32,1],[33,1,34,1],[25,1,26,1],[21,2,22,2],[23,2,24,2],[25,2,26,2],[27,2,28,2],[29,2,30,2]]}
["Definitions",null,null,null,null,null,null,null,"At-Grade AADT Ranges for Traffic Signals and Minor Stops",null,null,null,null,null,"At-Grade AADT 1 and 2 Lane Roundabouts"]
["Definitions of values and variables required for SPICE analysis.",null,null,null,null,null,null,null,"Rural Two-Lane Highway",null,null,null,null,null,"Intersection Type","Major Road AADT",null,"Minor Road AADT"]
["User Input Variable","Units","Definition","Applicable Ranges",null,null,null,null,"Intersection Type","Major Road AADT",null,"Minor Road AADT",null,null,"1 Circulating Lane","Min","Max","Min","Max"]
[null,null,null,"Range for:","Lower Limit","Upper Limit",null,null,null,"Min","Max","Min","Max",null,"3Leg",675,17369,409,14000]
["Control Strategy Selection",null,null,null,null,null,null,null,"3ST",0,19500,0,4300,null,"4Leg",1000,19733,280,11239]
["Number of Major Street Lanes","lanes","Number of lanes on the major street (both directions - does not include turn lanes)","-","-","-",null,null,"4ST",0,14700,0,3500,null,"2 Circulating Lanes","Min","Max","Min","Max"]
["At-Grade Intersection Inputs",null,null,null,null,null,null,null,"3SG","--","--","--","--",null,"3Leg",1000,22050,476,15108]
["Major/Minor Road AADT","veh/day","Average annual daily traffic (AADT) volume for the major and minor street approaches (see table for ranges).","See table starting in column I (to the right).",null,null,null,null,"4SG",0,25200,0,12500,null,"4Leg",1000,28333,390,19371]
["Skew Angle","degrees","Intersecting angle between major street and minor street approaches (hover cursor for graphical representation)","-","-","-",null,null,"Rural Multilane Highway"]
["Number of Major Street Through Lanes","lanes","Number of through lanes on the major street (both directions - includes shared through lanes)","-","-","-",null,null,"Intersection Type","Major Road AADT",null,"Minor Road AADT"]
["Number of Minor Street Lanes","lanes","Number of lanes on the minor street (both directions - does not include turn lanes)","-","-","-",null,null,null,"Min","Max","Min","Max"]
["Right-turn Channelization","-","An approach is considered to have right-turn channelization when a marked or raised-curb island is present separating the turn from the adjacent movements.  A standard exclusive right-turn lane (bay) that does not have this separation is not considered channelized.","-","-","-"]
["Inscribed Circle Diameter","feet",null,"Roundabout",90,160,null,null,"3ST",0,78300,0,23000]
["Opening Year Entering AADT","veh/day",null,"Roundabout","See Table in Column O ",null,null,null,"4ST",0,78300,0,7400]
["Leg has Right-Turn Bypass","yes/no",null,"Roundabout","-","-",null,null,"3SG","--","--","--","--"]
["Access Point within 250' of Yield Line","-",null,"Roundabout",0,8,null,null,"4SG",0,43500,0,18500]
["Entering Width","feet",null,"Roundabout",24,34,null,null,"Urban and Suburban Arterials",null,null,null,null,null,"At-Grade AADT Ranges for Restricted Crossing U-Turn (RCUT)"]
["Number of Entering Lanes","lanes","Number of lanes entering a leg of the roundabout (hover cursor for graphical representation).","Roundabout",1,2,null,null,"Intersection Type","Major Road AADT",null,"Minor Road AADT"]
["Number of Circulating Lanes","lanes","Number of lanes circulating a leg of the roundabout (hover cursor for graphical representation).","Roundabout",1,2,null,null,"2x2 5 or Fewer Lanes","Min","Max","Min","Max",null,"Intersection Type","Major Road AADT",null,"Minor Road AADT"]
["Number of U-Turns","-","Number of U-turns of the RCUT intersection, either 1 or 2.","Signalized RCUT",1,2,null,null,"3ST",0,45700,0,9300,null,null,"Min","Max","Min","Max"]
[null,null,null,"Unsignalized RCUT",1,2,null,null,"4ST",0,46800,0,5900,null,"Signalized (3 & 4-leg)",9700,65500,1000,18218]
["Number of Major Road Lanes","lanes","Number of lanes on the major approach of the RCUT.  The highest number across both approaches was chosen (e.g. if one approach has 1 lane, and the other has 2, then 2 is chosen as the number of lanes).","Signalized RCUT",2,3,null,null,"3SG",0,58100,0,16400,null,"Unsignalized (3 & 4-leg)",2950,47722,40,11500]
[null,null,null,"Unsignalized RCUT","-","-",null,null,"4SG",0,67700,0,33400]
["Number of Minor Road Lanes","lanes","Number of lanes on the minor approach of the RCUT.  If the RCUT has two minor approaches, the highest number across both approaches is chosen.","Signalized RCUT",1,3,null,null,"2x2 6+ Lanes","Min","Max","Min","Max"]
[null,null,null,"Unsignalized RCUT","-","-",null,null,"3ST",0,66800,0,8600]
["Total Offset Distance","ft","The total distance between the center of the intersetion and the U-turn locations (e.g. if one approach has 800 ft. offset and the other one has 600 ft., then the total offset distance is 1400 ft.).","Signalized RCUT",650,2675,null,null,"4ST",0,54600,0,4600]
[null,null,null,"Unsignalized RCUT",600,5575,null,null,"3SG",0,94000,0,31000]
["Number of Driveways","-","The number of driveways within the whole footprint (including intersection center, U-turns, and segment between intersection center and U-turns) of the RCUT intersection.","Signalized RCUT",0,10,null,null,"4SG",0,137600,0,68400]
[null,null,null,"Unsignalized RCUT",0,6,null,null,"Intersection Type","Major Road AADT",null,"Minor Road AADT"]
["Total Deceleration Lane Length","ft","The total length of the deceleration lanes before U-turn locations (e.g. if one approach has 400 ft. deceleration lane and the other one has 250 ft., then total deceleration lane length is 650 ft.).","Signalized RCUT",300,2300,null,null,"1x2","Min","Max","Min","Max"]
[null,null,null,"Unsignalized RCUT",0,1525,null,null,"3ST",0,42700,0,13400]
["Total Acceleration Lane Length","ft","The maximum length of the deceleration lanes before U-turn locations (e.g. if one approach has 400 ft. deceleration lane and the other one has 250 ft., then 400 ft. is chosen as maximum deceleration lane length).","Signalized RCUT","-","-",null,null,"4ST",0,23400,0,19200]
[null,null,null,"Unsignalized RCUT",1,1600,null,null,"3SG",0,43800,0,58800]
["Total Median Width","ft","The total median width of the major approaches (e.g. if one approach has 40 ft. median and the other one has 25 ft., then total median width is 65 ft.).","Signalized RCUT",0,145,null,null,"4SG",0,77000,0,98900]
[null,null,null,"Unsignalized RCUT","-","-",null,null,"1x1","Min","Max","Min","Max"]
["Maximum Median Width","ft","The maximum median width of the major approaches (e.g. if one approach has 40 ft. median and the other one has 25 ft., then 40 ft. is chosen as maximum median width).","Signalized RCUT","-","-",null,null,"3ST",0,16900,0,11100]
[null,null,null,"Unsignalized RCUT",0,150,null,null,"4ST",0,11000,0,6800]
["Number of Left-Turn Lanes From Major Road","lanes","The maximum number of left turn lanes from major approach to minor approach.","Signalized RCUT",1,3,null,null,"3SG",0,20100,0,7500]
["Major Road Speed Limit","mph","Major approach speed limit.","Signalized RCUT",35,70,null,null,"4SG",0,24300,0,16900]
["Ramp Terminal Intersection Inputs"]
["Crossroad","-","References the major street of the ramp terminal intersection (i.e., the non-ramp terminal legs)","-","-","-"]
["Crossroad AADT - Inside Leg","veh/day","AADT volume of the crossroad leg located between the two ramp terminals of the interchange","Stop-Controlled",0,14000]
[null,null,null,"Signalized",14000,60000]
["Crossroad AADT - Outside Leg","veh/day","AADT volume of the crossroad leg located outside of the interchange","Stop-Controlled",0,14000]
[null,null,null,"Signalized",14000,60000]
["Ramp AADT - Exit","veh/day","AADT volume of the exit ramp","Stop-Controlled",0,10000]
[null,null,null,"Signalized",0,31000]
["Ramp AADT - Entrance","veh/day","AADT volume of the entrance ramp","Stop-Controlled",0,10000]
[null,null,null,"Signalized",0,31000]
["Exit Ramp Skew Angle","degrees","Skew angle equals 90 minus the intersection angle (in degrees) (hover cursor for graphical representation).","Stop-Controlled",0,70]
["Presence of Non-Ramp Public Street Leg","yes/no","Any ramp that has a fourth leg that: (1) is a public street serving two-way traffic and (2) intersects with the crossroad at the terminal. At most ramp terminals, the public street leg will be on the opposite side of the crossroad from the exit ramp.","-","-","-"]
["Effective number of lanes serving exit ramp","lanes","Varies depending on exit ramp configuration (hover cursor for graphical representation of nex,eff)","Stop-Controlled",1,2]
[null,null,null,"Signalized",1,4]
["Median Width","feet","Width of crossroad median measured from near edges of traveled way in both travel directions (hover cursor for graphical representation)","All",0,50]
["Left-turn lane (bay) Width for crossroad leg","feet","Width of crossroad left-turn lane (hover cursor for graphical representation)","All",0,26]
["Number of through traffic lanes that oppose the left-turn movement on the inside crossroad leg","lanes","Number of through lanes on crossroad outside leg that oppose crossroad inside leg left-turn movement","-","-","-"]
[{"$f":"'Ramp Terminal Inputs'!A30","v":"Distance (mi) to the adjacent ramp terminal"},"miles","Distance between subject ramp terminal and adjacent ramp terminal; measured along the crossroad from terminal center to terminal center (mi).","-","-","-"]
[{"$f":"'Ramp Terminal Inputs'!A31","v":"Distance (mi) to the next public street intersection on the outside crossroad leg"},"miles","Distance between subject ramp terminal and nearest public road intersection in a direction away form freeway; measured along the crossroad form terminal center to intersection center (mi).","-","-","-"]
["Protected operation for crossroad leg","yes/no","\"Yes\" if a crossroad leg (inside or outside) has protected left-turn operation.  \"No\" if the crossroad leg has permissive or permissive-protected operation"]

{"sheet":"Control Strategy Selection","index":3,"n_rows":69,"n_cols":24,"rows_kept":69,"cut":false,"hidden":false,"merged":[[59,4,59,5],[59,6,59,7],[58,0,58,7],[29,1,29,2],[24,1,24,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[28,1,28,2],[17,4,17,5],[17,6,17,7],[51,0,51,2],[52,0,52,2],[49,0,49,2],[43,0,43,2],[48,0,48,2],[50,0,50,2],[46,0,46,2],[47,0,47,2],[44,0,44,2],[30,1,30,2],[31,1,31,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[67,1,67,2],[68,1,68,2],[59,1,59,2],[60,1,60,2],[62,1,62,2],[63,1,63,2],[61,1,61,2],[65,1,65,2],[66,1,66,2],[64,1,64,2],[18,1,18,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[19,1,19,2],[0,0,0,7],[1,0,1,7],[16,0,16,4],[3,0,3,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[2,0,2,2],[4,4,4,7],[5,4,5,7],[12,4,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[7,4,10,7],[11,4,11,7],[17,1,17,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[12,0,12,2]]}
["Control Strategy Selection and Inputs"]
["Specify the Facility Level Inputs and the Control Strategies to be included in the SPICE Analysis."]
["Intersection Type",null,null,"At-Grade Intersections"]
["Analysis Year",null,null,"Opening and Design Year"]
["Opening Year",null,null,null,{"$f":"IF(NOT(ISNUMBER(Input_OpenYear)),\"Please specify a valid Opening Year\",\"\")","v":"Please specify a valid Opening Year"}]
["Design Year",null,null,null,{"$f":"IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(NOT(ISNUMBER(Input_DesignYear)),\"Please specify a valid Design Year\",IF(Input_OpenYear>=Input_DesignYear,\"The Design Year must be later than the Opening Year\",\"\")),\"\")","v":"Please specify a valid Design Year"}]
[]
["Facility Type",null,null,"On Urban and Suburban Arterial","For more information on how to determine these values, see the \"Definitions\" worksheet"]
["Number of Legs",null,null,"3-leg"]
["1-Way/2-Way",null,null,"2-way Intersecting 2-way"]
["# of Major Street Lanes (both directions)",null,null,"5 or fewer"]
["Major Street Approach Speed",null,null,"Less than 55 mph"]
["Opening Year - Major Road AADT",null,null,null,{"$f":"IF(Input_Base_OAADTMajor=\"\", \"Please specify a non-zero AADT value\",\"\")","v":"Please specify a non-zero AADT value"}]
["Opening Year - Minor Road AADT",null,null,null,{"$f":"IF(Input_Base_OAADTMinor=\"\", \"Please specify a non-zero AADT value\",\"\")","v":"Please specify a non-zero AADT value"}]
["Design Year - Major Road AADT",null,null,null,{"$f":"IF(AND(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,Input_Base_DAADTMajor=\"\"), \"Please specify a non-zero AADT value\",\"\")","v":"Please specify a non-zero AADT value"}]
["Design Year - Minor Road AADT",null,null,null,{"$f":"IF(AND(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,Input_Base_DAADTMinor=\"\"), \"Please specify a non-zero AADT value\",\"\")","v":"Please specify a non-zero AADT value"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AADT Within Range?"]
["Control Strategy","Include",null,"Base Intersection",null,null,null,null,null,null,null,null,null,null,"Opening","Design"]
["Traffic Signal","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K19)),\"No SPF Available\",IF(O19,\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":""},null,{"$f":"IF(NOT(ISNUMBER(M19)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P19,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":""},null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3},{"$f":"IF(Input_NumLegs=Notes!$A$49,\"4\",\"3\")&\"SG\"","v":"3SG"},{"$f":"VLOOKUP($J19,IF($I19=6,Range_USA_1x1,IF($I19=5,Range_USA_1x2,IF($I19=4,Range_USA_2x2_6P,IF($I19=3,Range_USA_2x2_5F,IF($I19=2,Range_RML, Range_R2L))))),2,FALSE)","v":0},{"$f":"VLOOKUP($J19,IF($I19=6,Range_USA_1x1,IF($I19=5,Range_USA_1x2,IF($I19=4,Range_USA_2x2_6P,IF($I19=3,Range_USA_2x2_5F,IF($I19=2,Range_RML, Range_R2L))))),3,FALSE)","v":58100},{"$f":"VLOOKUP($J19,IF($I19=6,Range_USA_1x1,IF($I19=5,Range_USA_1x2,IF($I19=4,Range_USA_2x2_6P,IF($I19=3,Range_USA_2x2_5F,IF($I19=2,Range_RML, Range_R2L))))),4,FALSE)","v":0},{"$f":"VLOOKUP($J19,IF($I19=6,Range_USA_1x1,IF($I19=5,Range_USA_1x2,IF($I19=4,Range_USA_2x2_6P,IF($I19=3,Range_USA_2x2_5F,IF($I19=2,Range_RML, Range_R2L))))),5,FALSE)","v":16400},{"$f":"AND(Input_Base_OAADTMajor>=K19,Input_Base_OAADTMajor<=L19,Input_Base_OAADTMinor>=M19,Input_Base_OAADTMinor<=N19)","v":true},{"$f":"AND(Input_Base_DAADTMajor>=K19,Input_Base_DAADTMajor<=L19,Input_Base_DAADTMinor>=M19,Input_Base_DAADTMinor<=N19)","v":true}]
["Traffic Signal (Alternative Configuration)","Yes",null,"--","",null,{"$f":"IF(NOT(ISNUMBER(M20)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P20,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":""},null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3},{"$f":"IF(Input_NumLegs=Notes!$A$49,\"4\",\"3\")&\"SG\"","v":"3SG"},{"$f":"VLOOKUP($J20,IF($I20=6,Range_USA_1x1,IF($I20=5,Range_USA_1x2,IF($I20=4,Range_USA_2x2_6P,IF($I20=3,Range_USA_2x2_5F,IF($I20=2,Range_RML, Range_R2L))))),2,FALSE)","v":0},{"$f":"VLOOKUP($J20,IF($I20=6,Range_USA_1x1,IF($I20=5,Range_USA_1x2,IF($I20=4,Range_USA_2x2_6P,IF($I20=3,Range_USA_2x2_5F,IF($I20=2,Range_RML, Range_R2L))))),3,FALSE)","v":58100},{"$f":"VLOOKUP($J20,IF($I20=6,Range_USA_1x1,IF($I20=5,Range_USA_1x2,IF($I20=4,Range_USA_2x2_6P,IF($I20=3,Range_USA_2x2_5F,IF($I20=2,Range_RML, Range_R2L))))),4,FALSE)","v":0},{"$f":"VLOOKUP($J20,IF($I20=6,Range_USA_1x1,IF($I20=5,Range_USA_1x2,IF($I20=4,Range_USA_2x2_6P,IF($I20=3,Range_USA_2x2_5F,IF($I20=2,Range_RML, Range_R2L))))),5,FALSE)","v":16400},{"$f":"AND(Input_Base_OAADTMajor>=K20,Input_Base_OAADTMajor<=L20,Input_Base_OAADTMinor>=M20,Input_Base_OAADTMinor<=N20)","v":true},{"$f":"AND(Input_Base_DAADTMajor>=K20,Input_Base_DAADTMajor<=L20,Input_Base_DAADTMinor>=M20,Input_Base_DAADTMinor<=N20)","v":true}]
["Minor Road Stop","Yes",null,"--","",null,{"$f":"IF(NOT(ISNUMBER(M21)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P21,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":""},null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3},{"$f":"IF(Input_NumLegs=Notes!$A$49,\"4\",\"3\")&\"ST\"","v":"3ST"},{"$f":"VLOOKUP($J21,IF($I21=6,Range_USA_1x1,IF($I21=5,Range_USA_1x2,IF($I21=4,Range_USA_2x2_6P,IF($I21=3,Range_USA_2x2_5F,IF($I21=2,Range_RML, Range_R2L))))),2,FALSE)","v":0},{"$f":"VLOOKUP($J21,IF($I21=6,Range_USA_1x1,IF($I21=5,Range_USA_1x2,IF($I21=4,Range_USA_2x2_6P,IF($I21=3,Range_USA_2x2_5F,IF($I21=2,Range_RML, Range_R2L))))),3,FALSE)","v":45700},{"$f":"VLOOKUP($J21,IF($I21=6,Range_USA_1x1,IF($I21=5,Range_USA_1x2,IF($I21=4,Range_USA_2x2_6P,IF($I21=3,Range_USA_2x2_5F,IF($I21=2,Range_RML, Range_R2L))))),4,FALSE)","v":0},{"$f":"VLOOKUP($J21,IF($I21=6,Range_USA_1x1,IF($I21=5,Range_USA_1x2,IF($I21=4,Range_USA_2x2_6P,IF($I21=3,Range_USA_2x2_5F,IF($I21=2,Range_RML, Range_R2L))))),5,FALSE)","v":9300},{"$f":"AND(Input_Base_OAADTMajor>=K21,Input_Base_OAADTMajor<=L21,Input_Base_OAADTMinor>=M21,Input_Base_OAADTMinor<=N21)","v":true},{"$f":"AND(Input_Base_DAADTMajor>=K21,Input_Base_DAADTMajor<=L21,Input_Base_DAADTMinor>=M21,Input_Base_DAADTMinor<=N21)","v":true}]
["All Way Stop","Yes",null,"--"]
["1-Lane Roundabout","Yes",null,"--","Opening Year AADT Outside of SPF Development Range",null,{"$f":"IF(NOT(ISNUMBER(M23)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P23,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":"Design Year AADT Outside of SPF Development Range"},null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3},{"$f":"IF(Input_NumLegs=Notes!$A$49,\"4\",\"3\")&\"Leg\"","v":"3Leg"},{"$f":"VLOOKUP($J23,Range_RAB1,2,FALSE)","v":675},{"$f":"VLOOKUP($J23,Range_RAB1,3,FALSE)","v":17369},{"$f":"VLOOKUP($J23,Range_RAB1,4,FALSE)","v":409},{"$f":"VLOOKUP($J23,Range_RAB1,5,FALSE)","v":14000},{"$f":"AND(Input_Base_OAADTMajor>=K23,Input_Base_OAADTMajor<=L23,Input_Base_OAADTMinor>=M23,Input_Base_OAADTMinor<=N23)","v":false},{"$f":"AND(Input_Base_DAADTMajor>=K23,Input_Base_DAADTMajor<=L23,Input_Base_DAADTMinor>=M23,Input_Base_DAADTMinor<=N23)","v":false}]
["2-Lane Roundabout","Yes",null,"--","Opening Year AADT Outside of SPF Development Range",null,{"$f":"IF(NOT(ISNUMBER(M24)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P24,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":"Design Year AADT Outside of SPF Development Range"},null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3},{"$f":"IF(Input_NumLegs=Notes!$A$49,\"4\",\"3\")&\"Leg\"","v":"3Leg"},{"$f":"VLOOKUP($J24,Range_RAB2,2,FALSE)","v":1000},{"$f":"VLOOKUP($J24,Range_RAB2,3,FALSE)","v":22050},{"$f":"VLOOKUP($J24,Range_RAB2,4,FALSE)","v":476},{"$f":"VLOOKUP($J24,Range_RAB2,5,FALSE)","v":15108},{"$f":"AND(Input_Base_OAADTMajor>=K24,Input_Base_OAADTMajor<=L24,Input_Base_OAADTMinor>=M24,Input_Base_OAADTMinor<=N24)","v":false},{"$f":"AND(Input_Base_DAADTMajor>=K24,Input_Base_DAADTMajor<=L24,Input_Base_DAADTMinor>=M24,Input_Base_DAADTMinor<=N24)","v":false}]
["Displaced Left Turn (DLT)","Yes",null,"Traffic Signal"]
["Median U-Turn (MUT)","Yes",null,"Traffic Signal"]
["Signalized Restricted Crossing U-Turn (RCUT)","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K27)),\"No SPF Available\",IF(NOT(O27),\"Opening Year AADT Outside of SPF Development Range\", IF(NOT(AND(Range_SRCUT_OAADT_Ratio)),\"Open Major/Minor AADT Ratio Outside of SPF Development Range\",\"\")))","v":"Opening Year AADT Outside of SPF Development Range"},null,{"$f":"IF(NOT(ISNUMBER(M27)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(NOT(P27),\"Design Year AADT Outside of SPF Development Range\",IF(NOT(AND(Range_SRCUT_DAADT_Ratio)),\"Design Major/Minor AADT Ratio Outside of SPF Development Range\",\"\")),\"\"))","v":"Design Year AADT Outside of SPF Development Range"},null,null,null,{"$f":"Definitions!P21","v":9700},{"$f":"Definitions!Q21","v":65500},{"$f":"Definitions!R21","v":1000},{"$f":"Definitions!S21","v":18218},{"$f":"AND(Input_Base_OAADTMajor>=K27,Input_Base_OAADTMajor<=L27,Input_Base_OAADTMinor>=M27,Input_Base_OAADTMinor<=N27)","v":false},{"$f":"AND(Input_Base_DAADTMajor>=K27,Input_Base_DAADTMajor<=L27,Input_Base_DAADTMinor>=M27,Input_Base_DAADTMinor<=N27)","v":false}]
["Unsignalized Restricted Crossing U-Turn (RCUT)","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K28)),\"No SPF Available\",IF(O28,\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":"Opening Year AADT Outside of SPF Development Range"},null,{"$f":"IF(NOT(ISNUMBER(M28)),\"No SPF\",IF(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign,IF(P28,\"\",\"Design Year AADT Outside of SPF Development Range\"),\"\"))","v":"Design Year AADT Outside of SPF Development Range"},null,null,null,{"$f":"Definitions!P22","v":2950},{"$f":"Definitions!Q22","v":47722},{"$f":"Definitions!R22","v":40},{"$f":"Definitions!S22","v":11500},{"$f":"AND(Input_Base_OAADTMajor>=K28,Input_Base_OAADTMajor<=L28,Input_Base_OAADTMinor>=M28,Input_Base_OAADTMinor<=N28)","v":false},{"$f":"AND(Input_Base_DAADTMajor>=K28,Input_Base_DAADTMajor<=L28,Input_Base_DAADTMinor>=M28,Input_Base_DAADTMinor<=N28)","v":false}]
["Continuous Green-T Intersection","Yes",null,"Traffic Signal"]
["Jughandle","Yes",null,"Traffic Signal"]
["Other 1","Yes",null,"Traffic Signal","*Please Select"]
["Other 2","Yes",null,"Minor Road Stop","*Please Select"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Freeway Orientation",null,null,"North-South"]
["Area Type",null,null,"Urban"]
[]
["Opening Year AADT",null,null,{"$f":"IF($D$44=Notes!$J$26,\"NB\",\"EB\") & \" Ramp Terminal\"","v":"NB Ramp Terminal"},{"$f":"IF($D$44=Notes!$J$26,\"SB\",\"WB\") & \" Ramp Terminal\"","v":"SB Ramp Terminal"}]
["Crossroad - Inside Leg",null,null,10000,15000]
["Crossroad - Outside Leg",null,null,10000,15000]
["Exit Ramp",null,null,4500,4500]
["Entrance Ramp",null,null,3000,3000]
["Design Year AADT",null,null,{"$f":"IF($D$44=Notes!$J$26,\"NB\",\"EB\") & \" Ramp Terminal\"","v":"NB Ramp Terminal"},{"$f":"IF($D$44=Notes!$J$26,\"SB\",\"WB\") & \" Ramp Terminal\"","v":"SB Ramp Terminal"}]
["Crossroad - Inside Leg",null,null,30000,30000]
["Crossroad - Outside Leg",null,null,30000,30000]
["Exit Ramp",null,null,5000,5000]
["Entrance Ramp",null,null,3250,3250]
[]
[]
["Ramp Terminal Intersections",null,null,null,null,null,null,null,null,null,"XRD IN",null,"XRD Out",null,"EXIT",null,"ENTR",null,"Terminal 1",null,"Terminal 2",null,"AADT Within Range?"]
["Traffic Control (both intersections)","Include",null,"Base Intersection",null,null,null,null,null,null,"Min","Max","Min","Max","Min","Max","Min","Max","Opening","Design","Opening","Design","Opening","Design"]
["Conventional Traffic Signal","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K61)),\"No SPF Available\",IF(OR(NOT(IsChecked_RTI_D4TS),W61),\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":"Opening Year AADT Outside of SPF Development Range"},null,{"$f":"IF(NOT(ISNUMBER(L61)),\"No SPF Available\",IF(OR(NOT(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign),NOT(IsChecked_RTI_D4TS),X61),\"\",\"Design Year AADT Outside of SPF Development Range\"))","v":""},null,null,null,{"$f":"Definitions!E43","v":14000},{"$f":"Definitions!F43","v":60000},{"$f":"Definitions!E45","v":14000},{"$f":"Definitions!F45","v":60000},{"$f":"Definitions!E47","v":0},{"$f":"Definitions!F47","v":31000},{"$f":"Definitions!E49","v":0},{"$f":"Definitions!F49","v":31000},{"$f":"AND(Input_RTI_OAADTIn1>=K61,Input_RTI_OAADTIn1<=L61,Input_RTI_OAADTOut1>=M61,Input_RTI_OAADTOut1<=N61,Input_RTI_OAADTEx1>=O61,Input_RTI_OAADTEx1<=P61,Input_RTI_OAADTEn1>=Q61,Input_RTI_OAADTEn1<=R61)","v":false},{"$f":"AND(Input_RTI_DAADTIn1>=K61,Input_RTI_DAADTIn1<=L61,Input_RTI_DAADTOut1>=M61,Input_RTI_DAADTOut1<=N61,Input_RTI_DAADTEx1>=O61,Input_RTI_DAADTEx1<=P61,Input_RTI_DAADTEn1>=Q61,Input_RTI_DAADTEn1<=R61)","v":true},{"$f":"AND(Input_RTI_OAADTIn2>=K61,Input_RTI_OAADTIn2<=L61,Input_RTI_OAADTOut2>=M61,Input_RTI_OAADTOut2<=N61,Input_RTI_OAADTEx2>=O61,Input_RTI_OAADTEx2<=P61,Input_RTI_OAADTEn2>=Q61,Input_RTI_OAADTEn2<=R61)","v":true},{"$f":"AND(Input_RTI_DAADTIn2>=K61,Input_RTI_DAADTIn2<=L61,Input_RTI_DAADTOut2>=M61,Input_RTI_DAADTOut2<=N61,Input_RTI_DAADTEx2>=O61,Input_RTI_DAADTEx2<=P61,Input_RTI_DAADTEn2>=Q61,Input_RTI_DAADTEn2<=R61)","v":true},{"$f":"AND(S61,U61)","v":false},{"$f":"AND(T61,V61)","v":true}]
["Conventional Traffic Signal (Alt)","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K62)),\"No SPF Available\",IF(OR(NOT(IsChecked_RTI_D4TSA),W62),\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":"Opening Year AADT Outside of SPF Development Range"},null,{"$f":"IF(NOT(ISNUMBER(L62)),\"No SPF Available\",IF(OR(NOT(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign),NOT(IsChecked_RTI_D4TSA),X62),\"\",\"Design Year AADT Outside of SPF Development Range\"))","v":""},null,null,null,{"$f":"K61","v":14000},{"$f":"L61","v":60000},14000,60000,0,31000,0,31000,{"$f":"S61","v":false},{"$f":"T61","v":true},{"$f":"U61","v":true},{"$f":"V61","v":true},{"$f":"W61","v":false},{"$f":"X61","v":true}]
["Crossover Traffic Signal (of DDI)","Yes",null,"--"]
["Single-Point Diamond Traffic Signal","Yes",null,"--","(SPF not available until fall)"]
["Minor Road (ramp) Stop","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K65)),\"No SPF Available\",IF(OR(NOT(IsChecked_RTI_D4MS),W65),\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":"Opening Year AADT Outside of SPF Development Range"},null,{"$f":"IF(NOT(ISNUMBER(L65)),\"No SPF Available\",IF(OR(NOT(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign),NOT(IsChecked_RTI_D4MS),X65),\"\",\"Design Year AADT Outside of SPF Development Range\"))","v":"Design Year AADT Outside of SPF Development Range"},null,null,null,{"$f":"Definitions!E42","v":0},{"$f":"Definitions!F42","v":14000},{"$f":"Definitions!E44","v":0},{"$f":"Definitions!F44","v":14000},{"$f":"Definitions!E46","v":0},{"$f":"Definitions!F46","v":10000},{"$f":"Definitions!E48","v":0},{"$f":"Definitions!F48","v":10000},{"$f":"AND(Input_RTI_OAADTIn1>=K65,Input_RTI_OAADTIn1<=L65,Input_RTI_OAADTOut1>=M65,Input_RTI_OAADTOut1<=N65,Input_RTI_OAADTEx1>=O65,Input_RTI_OAADTEx1<=P65,Input_RTI_OAADTEn1>=Q65,Input_RTI_OAADTEn1<=R65)","v":true},{"$f":"AND(Input_RTI_DAADTIn1>=K65,Input_RTI_DAADTIn1<=L65,Input_RTI_DAADTOut1>=M65,Input_RTI_DAADTOut1<=N65,Input_RTI_DAADTEx1>=O65,Input_RTI_DAADTEx1<=P65,Input_RTI_DAADTEn1>=Q65,Input_RTI_DAADTEn1<=R65)","v":false},{"$f":"AND(Input_RTI_OAADTIn2>=K65,Input_RTI_OAADTIn2<=L65,Input_RTI_OAADTOut2>=M65,Input_RTI_OAADTOut2<=N65,Input_RTI_OAADTEx2>=O65,Input_RTI_OAADTEx2<=P65,Input_RTI_OAADTEn2>=Q65,Input_RTI_OAADTEn2<=R65)","v":false},{"$f":"AND(Input_RTI_DAADTIn2>=K65,Input_RTI_DAADTIn2<=L65,Input_RTI_DAADTOut2>=M65,Input_RTI_DAADTOut2<=N65,Input_RTI_DAADTEx2>=O65,Input_RTI_DAADTEx2<=P65,Input_RTI_DAADTEn2>=Q65,Input_RTI_DAADTEn2<=R65)","v":false},{"$f":"AND(S65,U65)","v":false},false]
["1-lane Roundabout","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K66)),\"No SPF Available\",IF(OR(NOT(IsChecked_RTI_D4MS),W66),\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":""},null,{"$f":"IF(NOT(ISNUMBER(L66)),\"No SPF Available\",IF(OR(NOT(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign),NOT(IsChecked_RTI_D4MS),X66),\"\",\"Design Year AADT Outside of SPF Development Range\"))","v":"Design Year AADT Outside of SPF Development Range"},null,null,null,{"$f":"Definitions!$P$5","v":1000},{"$f":"Definitions!$Q$5","v":19733},{"$f":"Definitions!$P$5","v":1000},{"$f":"Definitions!$Q$5","v":19733},{"$f":"Definitions!$R$5","v":280},{"$f":"Definitions!$S$5","v":11239},{"$f":"Definitions!$R$5","v":280},{"$f":"Definitions!$S$5","v":11239},{"$f":"AND(Input_RTI_OAADTIn1>=K66,Input_RTI_OAADTIn1<=L66,Input_RTI_OAADTOut1>=M66,Input_RTI_OAADTOut1<=N66,Input_RTI_OAADTEx1>=O66,Input_RTI_OAADTEx1<=P66,Input_RTI_OAADTEn1>=Q66,Input_RTI_OAADTEn1<=R66)","v":true},{"$f":"AND(Input_RTI_DAADTIn1>=K66,Input_RTI_DAADTIn1<=L66,Input_RTI_DAADTOut1>=M66,Input_RTI_DAADTOut1<=N66,Input_RTI_DAADTEx1>=O66,Input_RTI_DAADTEx1<=P66,Input_RTI_DAADTEn1>=Q66,Input_RTI_DAADTEn1<=R66)","v":false},{"$f":"AND(Input_RTI_OAADTIn2>=K66,Input_RTI_OAADTIn2<=L66,Input_RTI_OAADTOut2>=M66,Input_RTI_OAADTOut2<=N66,Input_RTI_OAADTEx2>=O66,Input_RTI_OAADTEx2<=P66,Input_RTI_OAADTEn2>=Q66,Input_RTI_OAADTEn2<=R66)","v":true},{"$f":"AND(Input_RTI_DAADTIn2>=K66,Input_RTI_DAADTIn2<=L66,Input_RTI_DAADTOut2>=M66,Input_RTI_DAADTOut2<=N66,Input_RTI_DAADTEx2>=O66,Input_RTI_DAADTEx2<=P66,Input_RTI_DAADTEn2>=Q66,Input_RTI_DAADTEn2<=R66)","v":false},true,false]
["2-lane Roundabout","Yes",null,"--",{"$f":"IF(NOT(ISNUMBER(K67)),\"No SPF Available\",IF(OR(NOT(IsChecked_RTI_D4MS),W67),\"\",\"Opening Year AADT Outside of SPF Development Range\"))","v":""},null,{"$f":"IF(NOT(ISNUMBER(L67)),\"No SPF Available\",IF(OR(NOT(Input_AnalysisYearType=Label_AnalysisYearType_OpenAndDesign),NOT(IsChecked_RTI_D4MS),X67),\"\",\"Design Year AADT Outside of SPF Development Range\"))","v":"Design Year AADT Outside of SPF Development Range"},null,null,null,{"$f":"Definitions!$P$8","v":1000},{"$f":"Definitions!$Q$8","v":28333},{"$f":"Definitions!$P$8","v":1000},{"$f":"Definitions!$Q$8","v":28333},{"$f":"Definitions!$R$8","v":390},{"$f":"Definitions!$S$8","v":19371},{"$f":"Definitions!$R$8","v":390},{"$f":"Definitions!$S$8","v":19371},{"$f":"AND(Input_RTI_OAADTIn1>=K67,Input_RTI_OAADTIn1<=L67,Input_RTI_OAADTOut1>=M67,Input_RTI_OAADTOut1<=N67,Input_RTI_OAADTEx1>=O67,Input_RTI_OAADTEx1<=P67,Input_RTI_OAADTEn1>=Q67,Input_RTI_OAADTEn1<=R67)","v":true},{"$f":"AND(Input_RTI_DAADTIn1>=K67,Input_RTI_DAADTIn1<=L67,Input_RTI_DAADTOut1>=M67,Input_RTI_DAADTOut1<=N67,Input_RTI_DAADTEx1>=O67,Input_RTI_DAADTEx1<=P67,Input_RTI_DAADTEn1>=Q67,Input_RTI_DAADTEn1<=R67)","v":false},{"$f":"AND(Input_RTI_OAADTIn2>=K67,Input_RTI_OAADTIn2<=L67,Input_RTI_OAADTOut2>=M67,Input_RTI_OAADTOut2<=N67,Input_RTI_OAADTEx2>=O67,Input_RTI_OAADTEx2<=P67,Input_RTI_OAADTEn2>=Q67,Input_RTI_OAADTEn2<=R67)","v":true},{"$f":"AND(Input_RTI_DAADTIn2>=K67,Input_RTI_DAADTIn2<=L67,Input_RTI_DAADTOut2>=M67,Input_RTI_DAADTOut2<=N67,Input_RTI_DAADTEx2>=O67,Input_RTI_DAADTEx2<=P67,Input_RTI_DAADTEn2>=Q67,Input_RTI_DAADTEn2<=R67)","v":false},true,false]
["Other 1","Yes",null,{"$f":"A61","v":"Conventional Traffic Signal"},"*Please Select"]
["Other 2","Yes",null,"Minor Road (ramp) Stop","*Please Select"]

{"sheet":"Ramp Terminal Inputs","index":4,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":true,"merged":[[44,1,44,10],[2,7,2,8],[3,7,3,8],[2,9,2,10],[3,9,3,10],[13,7,13,8],[13,9,13,10],[2,5,2,6],[2,1,2,2],[2,3,2,4],[0,0,0,10],[1,0,1,10],[23,1,23,6],[3,1,3,2],[3,3,3,4],[3,5,3,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[45,6,67,6],[47,7,47,10],[54,7,54,10],[61,7,61,10],[45,1,67,1],[45,2,67,2],[45,3,67,3],[45,4,67,4],[45,5,67,5]]}
["Ramp Terminal Inputs"]
["Provide inputs needed to compute and apply Part C CMFs."]
["Alternative","Traffic Signal",null,"Traffic Signal (Alt)",null,"Minor Road (Ramp) Stop",null,"1-lane Roundabout",null,"2-lane Roundabout"]
[null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)"]
["Ramp Terminal  ",{"$f":"'Control Strategy Selection'!$D$47","v":"NB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$E$47","v":"SB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$D$47","v":"NB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$E$47","v":"SB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$D$47","v":"NB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$E$47","v":"SB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$D$47","v":"NB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$E$47","v":"SB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$D$47","v":"NB Ramp Terminal"},{"$f":"'Control Strategy Selection'!$E$47","v":"SB Ramp Terminal"}]
[{"$f":"'Control Strategy Selection'!$A$47:$C$47 & \" \" & 'Control Strategy Selection'!A48:C48","v":"Opening Year AADT Crossroad - Inside Leg"},{"$f":"Input_RTI_OAADTIn1","v":10000},{"$f":"Input_RTI_OAADTIn2","v":15000},{"$f":"Input_RTI_OAADTIn1","v":10000},{"$f":"Input_RTI_OAADTIn2","v":15000},{"$f":"Input_RTI_OAADTIn1","v":10000},{"$f":"Input_RTI_OAADTIn2","v":15000},{"$f":"Input_RTI_OAADTIn1","v":10000},{"$f":"Input_RTI_OAADTIn2","v":15000},{"$f":"Input_RTI_OAADTIn1","v":10000},{"$f":"Input_RTI_OAADTIn2","v":15000}]
[{"$f":"'Control Strategy Selection'!$A$47:$C$47 & \" \" & 'Control Strategy Selection'!A49:C49","v":"Opening Year AADT Crossroad - Outside Leg"},{"$f":"Input_RTI_OAADTOut1","v":10000},{"$f":"Input_RTI_OAADTOut2","v":15000},{"$f":"Input_RTI_OAADTOut1","v":10000},{"$f":"Input_RTI_OAADTOut2","v":15000},{"$f":"Input_RTI_OAADTOut1","v":10000},{"$f":"Input_RTI_OAADTOut2","v":15000},{"$f":"Input_RTI_OAADTOut1","v":10000},{"$f":"Input_RTI_OAADTOut2","v":15000},{"$f":"Input_RTI_OAADTOut1","v":10000},{"$f":"Input_RTI_OAADTOut2","v":15000}]
[{"$f":"'Control Strategy Selection'!$A$47:$C$47 & \" \" & 'Control Strategy Selection'!A50:C50","v":"Opening Year AADT Exit Ramp"},{"$f":"Input_RTI_OAADTEx1","v":4500},{"$f":"Input_RTI_OAADTEx2","v":4500},{"$f":"Input_RTI_OAADTEx1","v":4500},{"$f":"Input_RTI_OAADTEx2","v":4500},{"$f":"Input_RTI_OAADTEx1","v":4500},{"$f":"Input_RTI_OAADTEx2","v":4500},{"$f":"Input_RTI_OAADTEx1","v":4500},{"$f":"Input_RTI_OAADTEx2","v":4500},{"$f":"Input_RTI_OAADTEx1","v":4500},{"$f":"Input_RTI_OAADTEx2","v":4500}]
[{"$f":"'Control Strategy Selection'!$A$47:$C$47 & \" \" & 'Control Strategy Selection'!A51:C51","v":"Opening Year AADT Entrance Ramp"},{"$f":"Input_RTI_OAADTEn1","v":3000},{"$f":"Input_RTI_OAADTEn2","v":3000},{"$f":"Input_RTI_OAADTEn1","v":3000},{"$f":"Input_RTI_OAADTEn2","v":3000},{"$f":"Input_RTI_OAADTEn1","v":3000},{"$f":"Input_RTI_OAADTEn2","v":3000},{"$f":"Input_RTI_OAADTEn1","v":3000},{"$f":"Input_RTI_OAADTEn2","v":3000},{"$f":"Input_RTI_OAADTEn1","v":3000},{"$f":"Input_RTI_OAADTEn2","v":3000}]
[{"$f":"'Control Strategy Selection'!$A$52:$C$52 & \" \" & 'Control Strategy Selection'!A53:C53","v":"Design Year AADT Crossroad - Inside Leg"},{"$f":"Input_RTI_DAADTIn1","v":30000},{"$f":"Input_RTI_DAADTIn2","v":30000},{"$f":"Input_RTI_DAADTIn1","v":30000},{"$f":"Input_RTI_DAADTIn2","v":30000},{"$f":"Input_RTI_DAADTIn1","v":30000},{"$f":"Input_RTI_DAADTIn2","v":30000},{"$f":"Input_RTI_DAADTIn1","v":30000},{"$f":"Input_RTI_DAADTIn2","v":30000},{"$f":"Input_RTI_DAADTIn1","v":30000},{"$f":"Input_RTI_DAADTIn2","v":30000}]
[{"$f":"'Control Strategy Selection'!$A$52:$C$52 & \" \" & 'Control Strategy Selection'!A54:C54","v":"Design Year AADT Crossroad - Outside Leg"},{"$f":"Input_RTI_DAADTOut1","v":30000},{"$f":"Input_RTI_DAADTOut2","v":30000},{"$f":"Input_RTI_DAADTOut1","v":30000},{"$f":"Input_RTI_DAADTOut2","v":30000},{"$f":"Input_RTI_DAADTOut1","v":30000},{"$f":"Input_RTI_DAADTOut2","v":30000},{"$f":"Input_RTI_DAADTOut1","v":30000},{"$f":"Input_RTI_DAADTOut2","v":30000},{"$f":"Input_RTI_DAADTOut1","v":30000},{"$f":"Input_RTI_DAADTOut2","v":30000}]
[{"$f":"'Control Strategy Selection'!$A$52:$C$52 & \" \" & 'Control Strategy Selection'!A55:C55","v":"Design Year AADT Exit Ramp"},{"$f":"Input_RTI_DAADTEx1","v":5000},{"$f":"Input_RTI_DAADTEx2","v":5000},{"$f":"Input_RTI_DAADTEx1","v":5000},{"$f":"Input_RTI_DAADTEx2","v":5000},{"$f":"Input_RTI_DAADTEx1","v":5000},{"$f":"Input_RTI_DAADTEx2","v":5000},{"$f":"Input_RTI_DAADTEx1","v":5000},{"$f":"Input_RTI_DAADTEx2","v":5000},{"$f":"Input_RTI_DAADTEx1","v":5000},{"$f":"Input_RTI_DAADTEx2","v":5000}]
[{"$f":"'Control Strategy Selection'!$A$52:$C$52 & \" \" & 'Control Strategy Selection'!A56:C56","v":"Design Year AADT Entrance Ramp"},{"$f":"Input_RTI_DAADTEn1","v":3250},{"$f":"Input_RTI_DAADTEn2","v":3250},{"$f":"Input_RTI_DAADTEn1","v":3250},{"$f":"Input_RTI_DAADTEn2","v":3250},{"$f":"Input_RTI_DAADTEn1","v":3250},{"$f":"Input_RTI_DAADTEn2","v":3250},{"$f":"Input_RTI_DAADTEn1","v":3250},{"$f":"Input_RTI_DAADTEn2","v":3250},{"$f":"Input_RTI_DAADTEn1","v":3250},{"$f":"Input_RTI_DAADTEn2","v":3250}]
["Area Type",{"$f":"Input_RTI_AreaType","v":"Urban"},null,{"$f":"Input_RTI_AreaType","v":"Urban"},null,{"$f":"Input_RTI_AreaType","v":"Urban"},null,{"$f":"Input_RTI_AreaType","v":"Urban"},null,{"$f":"Input_RTI_AreaType","v":"Urban"}]
["Number of Crossroad Lanes",4,4,4,4,4,4,"N/A","N/A","N/A","N/A"]
["Number of through traffic lanes that oppose the left-turn movement on the inside crossroad leg",2,2,2,2,"N/A","N/A","N/A","N/A","N/A","N/A"]
["Number of through traffic lanes that oppose the left-turn movement on the outside crossroad leg",{"$f":"Input_D4TS_NLxst1-Input_D4TS_NLTOIn1","v":2},{"$f":"Input_D4TS_NLxst2-Input_D4TS_NLTOIn2","v":2},{"$f":"Input_D4TSA_NLxst1-Input_D4TSA_NLTOIn1","v":2},{"$f":"Input_D4TSA_NLxst2-Input_D4TSA_NLTOIn2","v":2},"N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
["CMF Inputs","Part C CMFs\nOptional For Stage 1 ICE, Required for Stage 2 ICE"]
["Exit Ramp Skew Angle","N/A","N/A","N/A","N/A",0,0]
["Is a non-ramp public street leg present?","No","No","No","No","N/A","N/A"]
["Exit ramp right turn control"," Signal/Stop/yield-controlled"," Signal/Stop/yield-controlled"," Signal/Stop/yield-controlled"," Signal/Stop/yield-controlled"," Signal/Stop/yield-controlled"," Signal/Stop/yield-controlled"]
["Effective number of lanes serving exit ramp",1,1,1,1,1,1]
["Number of unsignalized driveways on the outside crossroad leg within 250' of the interchange",0,0,0,0,"N/A","N/A"]
["Distance (mi) to the adjacent ramp terminal",0.1,0.1,0.1,0.1,0.1,0.1]
["Distance (mi) to the next public street intersection on the outside crossroad leg",0.15,0.15,0.15,0.15,0.15,0.15]
["# of unsignalized public street approaches on the outside crossroad leg within 250' (<0.05 mi) of the interchange",1,1,1,1,1,1]
["Median Width (ft)",12,12,12,12,12,12]
["Presence of right-turn lane/bay on \"in\" leg","N/A","N/A","N/A","N/A","N/A","N/A"]
["Presence of right-turn lane/bay on outside crossroad leg","Yes","Yes","Yes","Yes","Yes","Yes"]
["Presence of left-turn lane/bay on inside crossroad leg","Yes","Yes","Yes","Yes","Yes","Yes"]
["Left-turn lane/bay Width for inside crossroad leg",12,12,12,12,12,12]
["Presence of left-turn lane/bay on outside crossroad leg","N/A","N/A","N/A","N/A","N/A","N/A"]
["Left-turn lane/bay Width for outside crossroad leg",0,0,0,0,0,0]
["Protected Left-turn operation for inside crossroad leg","No","No","No","No","N/A","N/A"]
["Protected Left-turn operation for outside crossroad leg","N/A","N/A","N/A","N/A","N/A","N/A"]
["Right turn channelization for inside crossroad leg","N/A","N/A","N/A","N/A","N/A","N/A"]
["Right turn channelization for outside crossroad leg","No","No","No","No","N/A","N/A"]
["Right turn channelization for exit ramp","No","No","No","No","N/A","N/A"]
[null,"Roundabout CMF Inputs"]
["Inscribed Circle Diameter (ft)","N/A","N/A","N/A","N/A","N/A","N/A",130,130,125,125]
["Outbound Only Leg",null,null,null,null,null,null,"Yes","Yes","Yes","Yes"]
["Leg 1 (Crossroad Leg - Inside)",null,null,null,null,null,null,"Leg 1 (Crossroad Leg - Inside)"]
["Opening Year Entering AADT",null,null,null,null,null,null,{"$f":"'Control Strategy Selection'!$D$48*0.5","v":5000},{"$f":"'Control Strategy Selection'!$E$48*0.5","v":7500},{"$f":"'Control Strategy Selection'!$D$48*0.5","v":5000},{"$f":"'Control Strategy Selection'!$E$48*0.5","v":7500}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,"No","No","No","No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,0,0,0,0]
["Entering Width (ft)",null,null,null,null,null,null,29,29,29,29]
["# of Entering Lanes",null,null,null,null,null,null,2,2,2,2]
["# of Circulating Lanes",null,null,null,null,null,null,2,2,2,2]
["Leg 2 (Crossroad Leg - Outside)",null,null,null,null,null,null,"Leg 2 (Crossroad Leg - Outside)"]
["Opening Year Entering AADT",null,null,null,null,null,null,{"$f":"'Control Strategy Selection'!$D$49*0.5","v":5000},{"$f":"'Control Strategy Selection'!$E$49*0.5","v":7500},{"$f":"'Control Strategy Selection'!$D$49*0.5","v":5000},{"$f":"'Control Strategy Selection'!$E$49*0.5","v":7500}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,"No","No","No","No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,0,0,0,0]
["Entering Width (ft)",null,null,null,null,null,null,29,29,29,29]
["# of Entering Lanes",null,null,null,null,null,null,2,2,2,2]
["# of Circulating Lanes",null,null,null,null,null,null,2,2,2,2]
["Leg 3 (Exit Ramp Inside)",null,null,null,null,null,null,"Leg 3 (Exit Ramp Leg)"]
["Opening Year Entering AADT",null,null,null,null,null,null,{"$f":"('Control Strategy Selection'!$D$50)","v":4500},{"$f":"('Control Strategy Selection'!$E$50)","v":4500},{"$f":"('Control Strategy Selection'!$D$50)","v":4500},{"$f":"('Control Strategy Selection'!$E$50)","v":4500}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,"No","No","No","No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,0,0,0,0]
["Entering Width (ft)",null,null,null,null,null,null,29,29,29,29]
["# of Entering Lanes",null,null,null,null,null,null,2,2,2,2]
["# of Circulating Lanes",null,null,null,null,null,null,2,2,2,2]

{"sheet":"RTI_Ranges","index":5,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[[7,1,7,2],[7,3,7,4],[7,5,7,6],[17,1,17,6],[0,0,0,6],[1,0,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,1,3,2],[3,3,3,4],[3,5,3,6]]}
["Ramp Terminal Inputs"]
["Provide inputs needed to compute and apply Part C CMFs."]
["Alternative","Traffic Signal",null,"Traffic Signal (Alt)",null,"Minor Road (Ramp) Stop"]
[null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)",null,"4 Leg Terminal w/ Diagonal Ramps (D4)"]
["Ramp Terminal  ","NB","SB","NB","SB","NB","SB"]
["Crossroad AADT",18000,17000,{"$f":"B6","v":18000},{"$f":"C6","v":17000},{"$f":"B6","v":18000},{"$f":"C6","v":17000}]
["Ramp AADT",5000,4500,{"$f":"B7","v":5000},{"$f":"C7","v":4500},{"$f":"B7","v":5000},{"$f":"C7","v":4500}]
["Area Type","Urban",null,{"$f":"B8","v":"Urban"},null,{"$f":"B8","v":"Urban"}]
["# of Crossroad Lanes",2,2,2,2,2,2,"2-6  (5,6 Urban only)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Other CMF Inputs","Part C CMFs\nOptional For Stage 1 ICE, Required for Stage 2 ICE"]
["Crossroad Left Turn Lane Present?","Yes ","Yes ","Yes ","Yes ","Yes ","Yes "]
["Crossroad Right Turn Lane Present?","Yes ","Yes ","Yes ","Yes ","Yes ","Yes "]
["Skew Angle","skew","Planning","Double","Not/ Applicable","Include in MRS","Include in MRS"]
["Exit ramp right turn control","mergeRT","Planning","Merge/FF or Signal/Stop/yeild-controlled","Include in TS","Include in MRS","Include in MRS"]
["Effective number of lanes serving exit ramp","nex","Planning","1-2, see graphic","Include in TS","Include in MRS","Include in MRS"]
["Presence of left-turn bay on \"in\" leg","i_LTBayIn","Planning","Yes/No (<100 ft?)","Include in TS","Include in MRS","Include in MRS"]
["Presence of left-turn bay on \"out\" leg","i_LTBayOut","Planning","Yes/No (<100 ft?)","Include in TS","Include in MRS","Include in MRS"]
["Presence of right-turn bay on \"in\" leg","i_RTBayIn","Planning","Yes/No (<100 ft?)","Include in TS","Include in MRS","Include in MRS"]
["Presence of right-turn bay on \"out\" leg","i_RTBayOut","Planning","Yes/No (<100 ft?)","Include in TS","Include in MRS","Include in MRS"]
["Number of Stop-controlled public street approaches to the crossroad leg outside of the interchange and within 250 feet of the ramp terminal","n_ps","Planning","Integer","Include in TS","Include in MRS","Include in MRS"]
["Number of Stop-controlled driveways to the crossroad leg outside of the interchange and within 250 feet of the ramp terminal","n_dw","Planning","Integer","Include in TS","Not Applicable","Not Applicable"]
["Distance between subject ramp terminal and adjacent ramp terminal (from terminal center to terminal center)","l_rmp","Planning","Double","Include in TS","Include in MRS","Include in MRS"]
["distance between subject ramp terminal and nearest public road intersection in a direction away form the freeway","l_str","Planning","Double","Include in TS","Include in MRS","Include in MRS"]
["Width of median adjacent to turn lane for crossroad leg","w_m","Planning","Double","Include in TS","Include in MRS","Include in MRS"]
["Left-turn lane width for \"in\" crossroad leg","w_bkIn","Planning","Double (0.0 if not present)","Include in TS","Include in MRS","Include in MRS"]
["Left-turn lane width for \"out\" crossroad leg","w_bkOut","Planning","Double (0.0 if not present)","Include in TS","Include in MRS","Include in MRS"]
["Number of through traffic lanes that oppose the left-turn movement on the crossroad leg \"in\"","n_oppLTIn","Planning","Integer","Include in TS","Not Applicable","Not Applicable"]
["Number of through traffic lanes that oppose the left-turn movement on the crossroad leg \"out\"","n_oppLTOut","Planning","Integer","Include in TS","Not Applicable","Not Applicable"]
["Protected Left-turn operation indicator for crossroad leg \"in\"","i_protLTIn","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]
["Protected Left-turn operation indicator for crossroad leg \"out\"","i_protLTOut","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]
["Right turn channelization indicator for crossroad leg \"in\"","i_crtIn","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]
["Right turn channelization indicator for crossroad leg \"out\"","i_crtOut","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]
["Right turn channelization indicator for exit ramp","i_crtEx","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]
["Non-ramp public street leg indicator","i_ps","Planning","Boolean","Include in TS","Not Applicable","Not Applicable"]

{"sheet":"At-Grade Inputs","index":6,"n_rows":76,"n_cols":28,"rows_kept":76,"cut":false,"hidden":false,"merged":[[59,21,59,22],[60,19,60,20],[60,21,60,22],[61,19,61,20],[61,21,61,22],[62,19,62,20],[62,21,62,22],[33,15,33,16],[33,17,33,18],[33,19,33,20],[33,21,33,22],[54,21,54,22],[55,19,55,20],[55,21,55,22],[56,19,56,20],[56,21,56,22],[57,19,57,20],[57,21,57,22],[58,19,58,20],[58,21,58,22],[49,21,49,22],[50,19,50,20],[50,21,50,22],[51,19,51,20],[51,21,51,22],[52,19,52,20],[52,21,52,22],[53,19,53,20],[53,21,53,22],[44,21,44,22],[45,19,45,20],[45,21,45,22],[46,19,46,20],[46,21,46,22],[47,19,47,20],[47,21,47,22],[48,19,48,20],[48,21,48,22],[39,21,39,22],[40,19,40,20],[40,21,40,22],[41,19,41,20],[41,21,41,22],[42,19,42,20],[42,21,42,22],[43,19,43,20],[43,21,43,22],[34,21,34,22],[35,19,35,20],[35,21,35,22],[36,19,36,20],[36,21,36,22],[37,19,37,20],[37,21,37,22],[38,19,38,20],[38,21,38,22],[59,15,59,16],[59,17,59,18],[60,15,60,16],[60,17,60,18],[61,15,61,16],[61,17,61,18],[62,15,62,16],[62,17,62,18],[34,19,34,20],[39,19,39,20],[44,19,44,20],[49,19,49,20],[54,19,54,20],[59,19,59,20],[54,15,54,16],[54,17,54,18],[55,15,55,16],[55,17,55,18],[56,15,56,16],[56,17,56,18],[57,15,57,16],[57,17,57,18],[58,15,58,16],[58,17,58,18],[49,15,49,16],[49,17,49,18],[50,15,50,16],[50,17,50,18],[51,15,51,16],[51,17,51,18],[52,15,52,16],[52,17,52,18],[53,15,53,16],[53,17,53,18],[44,15,44,16],[44,17,44,18],[45,15,45,16],[45,17,45,18],[46,15,46,16],[46,17,46,18],[47,15,47,16],[47,17,47,18],[48,15,48,16],[48,17,48,18],[39,15,39,16],[39,17,39,18],[40,15,40,16],[40,17,40,18],[41,15,41,16],[41,17,41,18],[42,15,42,16],[42,17,42,18],[43,15,43,16],[43,17,43,18],[34,15,34,16],[34,17,34,18],[35,15,35,16],[35,17,35,18],[36,15,36,16],[36,17,36,18],[37,15,37,16],[37,17,37,18],[38,15,38,16],[38,17,38,18],[69,5,69,6],[69,7,69,8],[69,9,69,10],[69,11,69,12],[69,13,69,14],[69,15,69,16],[69,17,69,18],[71,3,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[71,13,71,14],[71,15,71,16],[71,17,71,18],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,9,74,10],[74,11,74,12],[74,13,74,14],[74,15,74,16],[74,17,74,18],[70,9,70,10],[70,11,70,12],[70,13,70,14],[70,15,70,16],[70,17,70,18],[63,19,64,22],[68,15,68,16],[68,17,68,18],[67,3,67,4],[67,5,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[67,13,67,14],[67,15,67,16],[67,17,67,18],[66,17,66,18],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[65,15,65,16],[65,17,65,18],[63,1,64,18],[65,1,65,2],[66,15,66,16],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[75,15,75,16],[75,17,75,18],[72,3,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,11,72,12],[72,13,72,14],[72,15,72,16],[72,17,72,18],[73,9,73,10],[73,11,73,12],[73,13,73,14],[73,15,73,16],[73,17,73,18],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,1,74,2],[75,1,75,2],[66,3,66,4],[66,5,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[66,13,66,14],[68,3,68,4],[68,5,68,6],[68,7,68,8],[68,9,68,10],[68,11,68,12],[68,13,68,14],[70,3,70,4],[70,5,70,6],[70,7,70,8],[66,1,66,2],[67,1,67,2],[68,1,68,2],[69,1,69,2],[70,1,70,2],[71,1,71,2],[69,3,69,4],[72,1,72,2],[74,19,74,20],[75,19,75,20],[65,21,65,22],[66,21,66,22],[67,21,67,22],[68,21,68,22],[69,21,69,22],[70,21,70,22],[71,21,71,22],[72,21,72,22],[73,21,73,22],[74,21,74,22],[75,21,75,22],[65,19,65,20],[66,19,66,20],[67,19,67,20],[68,19,68,20],[69,19,69,20],[70,19,70,20],[71,19,71,20],[72,19,72,20],[73,19,73,20],[73,1,73,2],[3,3,3,8],[16,25,32,26],[16,27,32,30],[19,3,19,4],[20,3,20,4],[27,3,27,4],[31,7,31,8],[31,9,31,10],[24,3,24,4],[16,15,32,16],[16,17,32,18],[16,19,32,20],[16,21,32,22],[16,23,32,24],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[18,7,18,8],[32,3,32,4],[26,11,26,12],[26,13,26,14],[30,7,30,8],[30,9,30,10],[12,9,12,10],[4,15,5,16],[4,17,5,18],[4,19,5,20],[4,21,5,22],[6,15,6,16],[7,15,7,16],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[6,11,6,12],[7,11,7,12],[8,11,8,12],[6,13,6,14],[7,13,7,14],[8,13,8,14],[9,13,9,14],[9,11,9,12],[10,27,11,30],[8,21,8,22],[9,21,9,22],[8,17,8,18],[6,25,6,26],[7,25,7,26],[8,25,8,26],[9,25,9,26],[6,23,6,24],[6,21,6,22],[4,23,5,24],[4,25,5,26],[8,15,8,16],[9,15,9,16],[6,17,6,18],[7,17,7,18],[6,27,9,30],[7,19,7,20],[8,19,8,20],[9,17,9,18],[9,19,9,20],[6,19,6,20],[32,13,32,14],[31,11,31,12],[4,0,5,0],[4,7,5,8],[4,9,5,10],[4,11,5,12],[4,13,5,14],[13,7,13,8],[11,9,11,10],[10,3,10,4],[4,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[11,3,11,4],[12,7,12,8],[10,9,10,10],[4,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[28,9,28,10],[21,13,21,14],[7,23,7,24],[8,23,8,24],[9,23,9,24],[15,1,15,14],[7,21,7,22],[23,11,23,12],[25,11,25,12],[25,13,25,14],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,1,32,2],[18,9,18,10],[18,11,18,12],[18,13,18,14],[21,7,21,8],[30,13,30,14],[29,7,29,8],[32,7,32,8],[32,9,32,10],[32,11,32,12],[19,13,19,14],[23,13,23,14],[19,7,19,8],[20,7,20,8],[19,9,19,10],[20,9,20,10],[31,13,31,14],[28,11,28,12],[28,7,28,8],[28,13,28,14],[30,11,30,12],[22,11,22,12],[22,13,22,14],[25,7,25,8],[20,13,20,14],[21,9,21,10],[21,11,21,12],[19,11,19,12],[20,11,20,12],[29,9,29,10],[29,11,29,12],[29,13,29,14],[26,9,26,10],[26,7,26,8],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[22,7,22,8],[18,3,18,4],[21,3,21,4],[22,3,22,4],[28,5,28,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[30,3,30,4],[31,3,31,4],[25,3,25,4],[29,3,29,4],[26,3,26,4],[28,3,28,4],[25,5,25,6],[6,1,9,2],[4,1,5,2],[10,1,13,2],[10,7,10,8],[11,7,11,8],[12,3,12,4],[13,3,13,4],[26,5,26,6],[27,5,27,6],[11,5,11,6],[12,5,12,6],[14,0,14,30],[13,9,13,10],[22,9,22,10],[23,7,23,8],[23,9,23,10],[23,3,23,4],[25,9,25,10],[16,3,16,4],[17,3,17,4],[24,5,24,6],[13,5,13,6],[16,5,16,6],[17,5,17,6],[33,1,33,14],[35,1,35,14],[42,1,42,14],[49,1,49,14],[56,1,56,14],[34,1,34,2],[34,3,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[36,1,36,2],[36,3,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[37,1,37,2],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[38,1,38,2],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[39,1,39,2],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[40,1,40,2],[40,3,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[41,1,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[44,1,44,2],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[45,1,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[50,1,50,2],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,1,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[52,1,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,1,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[55,1,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[57,1,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[58,1,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[59,1,59,2],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[60,1,60,2],[60,3,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[61,1,61,2],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[62,1,62,2],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[34,11,34,12],[34,13,34,14],[36,11,36,12],[36,13,36,14],[37,11,37,12],[37,13,37,14],[38,11,38,12],[38,13,38,14],[39,11,39,12],[39,13,39,14],[40,11,40,12],[40,13,40,14],[41,11,41,12],[41,13,41,14],[43,11,43,12],[43,13,43,14],[44,11,44,12],[44,13,44,14],[45,11,45,12],[45,13,45,14],[46,11,46,12],[46,13,46,14],[47,11,47,12],[47,13,47,14],[48,11,48,12],[48,13,48,14],[50,11,50,12],[50,13,50,14],[51,11,51,12],[51,13,51,14],[52,11,52,12],[52,13,52,14],[53,11,53,12],[53,13,53,14],[54,11,54,12],[54,13,54,14],[55,11,55,12],[55,13,55,14],[62,11,62,12],[62,13,62,14],[57,11,57,12],[57,13,57,14],[58,11,58,12],[58,13,58,14],[59,11,59,12],[59,13,59,14],[60,11,60,12],[60,13,60,14],[61,11,61,12],[61,13,61,14]]}
["At-Grade Intersection Inputs"]
["Provide inputs needed to compute and apply Part C CMFs."]
[]
[null,null,null,"Control Strategy"]
["Input",null,null,{"$f":"Label_AGI_TrafficSignal","v":"Traffic Signal"},null,{"$f":"Label_AGI_TrafficSignal&\" (Alt)\"","v":"Traffic Signal (Alt)"},null,{"$f":"Label_AGI_MinorStop","v":"Minor Road Stop"},null,{"$f":"Label_AGI_AllStop","v":"All Way Stop"},null,{"$f":"Label_AGI_1LnRdbt","v":"1-lane Roundabout"},null,{"$f":"Label_AGI_2LnRdbt","v":"2-lane Roundabout"},null,{"$f":"Label_AGI_DLT","v":"Displaced Left Turn (DLT)"},null,{"$f":"Label_AGI_MUT","v":"Median U-Turn (MUT)"},null,{"$f":"Label_AGI_RCUTSig","v":"Signalized RCUT"},null,{"$f":"Label_AGI_RCUTUnsig","v":"Unsignalized RCUT"},null,{"$f":"Label_AGI_GreenT","v":"Continuous Green-T Intersection"},null,{"$f":"Label_AGI_Jughandle","v":"Jughandle"}]
[]
["Opening Year Major Road AADT","Optional AADT Overrides",null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,{"$f":"Input_Base_OAADTMajor","v":0},null,"All strategies will have the same AADT as the Base Conditions unless overridden by user."]
["Opening Year Minor Road AADT",null,null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0},null,{"$f":"Input_Base_OAADTMinor","v":0}]
["Design Year Major Road AADT",null,null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0},null,{"$f":"Input_Base_DAADTMajor","v":0}]
["Design Year Minor Road AADT",null,null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0},null,{"$f":"Input_Base_DAADTMinor","v":0}]
["Number of Approaches with Left-Turn Lanes","Additional Required Control Strategy Inputs",null,0,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not include stop controlled approaches for minor stop"]
["Number of Approaches with Right-Turn Lanes",null,null,0,null,0,null,null,null,0]
["Number of Uncontrolled Approaches with Left-Turn Lanes",null,null,null,null,null,null,0]
["Number of Uncontrolled Approaches with Right-Turn Lanes",null,null,null,null,null,null,0]
["Keep default values below here for planning-level analysis, override with actual values for full HSM Analysis"]
[null,"Part C CMFS\nOptional For Stage 1 ICE, Required for Stage 2 ICE"]
["Skew Angle","A yellow cell indicates the value may be used in the SPF computation",null,"N/A",null,"N/A",null,0,null,"N/A",null,"N/A",null,"N/A",null,"CMF - No Inputs Required",null,"CMF - No Inputs Required",null,"Scroll Down for Signalized RCUT SPF Inputs",null,"Scroll Down for Unsignalized RCUT SPF Inputs",null,"CMF - No Inputs Required",null,"CMF - No Inputs Required",null,"All yellow cells will be automatically populated by a macro. If users want to do a planning-level analysis, they can leave the automatic inputs as-is"]
["Lighting Present",null,null,"Yes",null,"Yes",null,"Yes"]
["# of Approaches Permissive LT Signal Phasing",null,null,0,null,0,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["# of Approaches Perm/Prot LT Signal Phasing",null,null,0,null,0]
["# of Approaches Protected LT Signal Phasing",null,null,0,null,0]
["Number of Approaches with Right-Turn-on-Red Prohibited",null,null,0,null,0,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Red Light Cameras Present",null,null,"No",null,"No",null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Number of Major Street Through Lanes",null,null,0,null,0,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Number of Minor Street Lanes",null,null,0,null,0]
["# of Major St Approaches w/ Right-Turn Channelization",null,null,0,null,0,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Number of Approaches with U-Turn Prohibited",null,null,0,null,0,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Pedestrian Volume by Activity Level",null,null,"Low (20)",null,"Low (20)"]
["User Specified Sum of all daily pedestrian crossing volumes",null,null,20,null,20,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Max # of Lanes Crossed by Pedestrians",null,null,5,null,5,null,"N/A",null,"N/A",null,"N/A",null,"N/A"]
["Number of Bus Stops within 1000' of Intersection",null,null,0,null,0,null,{"$f":"Input_AGI_NumBusStops","v":0},null,{"$f":"Input_AGI_NumBusStops","v":0},null,{"$f":"Input_AGI_NumBusStops","v":0},null,{"$f":"Input_AGI_NumBusStops","v":0}]
["Schools within 1000' of intersection",null,null,"No",null,"No",null,{"$f":"Input_AGI_HasSchool","v":"No"},null,{"$f":"Input_AGI_HasSchool","v":"No"},null,{"$f":"Input_AGI_HasSchool","v":"No"},null,{"$f":"Input_AGI_HasSchool","v":"No"}]
["Number of Alcohol Sales Establishments within 1000' of Intersection",null,null,0,null,0,null,{"$f":"Input_AGI_NumABC","v":0},null,{"$f":"Input_AGI_NumABC","v":0},null,{"$f":"Input_AGI_NumABC","v":0},null,{"$f":"Input_AGI_NumABC","v":0}]
[null,"Roundabout CMF Inputs"]
["Inscribed Circle Diameter (ft)",null,null,null,null,null,null,null,null,null,null,130,null,125]
["Leg 1 (Major Leg #1)","Leg 1 (Major Leg #1)"]
["Opening Year Entering AADT",null,null,null,null,null,null,null,null,null,null,{"$f":"('Control Strategy Selection'!D13)*0.5","v":0},null,{"$f":"('Control Strategy Selection'!D13)*0.5","v":0}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,null,null,null,null,"No",null,"No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,null,null,null,null,0,null,0]
["Entering Width (ft)",null,null,null,null,null,null,null,null,null,null,29,null,29]
["# of Entering Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["# of Circulating Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["Leg 2 (Major Leg #2)","Leg 2 (Major Leg #2)"]
["Opening Year Entering AADT",null,null,null,null,null,null,null,null,null,null,{"$f":"('Control Strategy Selection'!$D$13)-Input_AGI_R1_AADT_L1","v":0},null,{"$f":"('Control Strategy Selection'!$D$13)-Input_AGI_R2_AADT_L1","v":0}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,null,null,null,null,"No",null,"No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,null,null,null,null,0,null,0]
["Entering Width (ft)",null,null,null,null,null,null,null,null,null,null,29,null,29]
["# of Entering Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["# of Circulating Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["Leg 3 (Minor Leg #1)","Leg 3 (Minor Leg #1)"]
["Opening Year Entering AADT",null,null,null,null,null,null,null,null,null,null,{"$f":"('Control Strategy Selection'!D14)*0.5","v":0},null,{"$f":"('Control Strategy Selection'!D14)*0.5","v":0}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,null,null,null,null,"No",null,"No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,null,null,null,null,0,null,0]
["Entering Width (ft)",null,null,null,null,null,null,null,null,null,null,29,null,29]
["# of Entering Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["# of Circulating Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["Leg 4 (Minor Leg #2)","Leg 4 (Minor Leg #2)"]
["Opening Year Entering AADT",null,null,null,null,null,null,null,null,null,null,{"$f":"('Control Strategy Selection'!$D$14)-Input_AGI_R1_AADT_L3","v":0},null,{"$f":"('Control Strategy Selection'!$D$14)-Input_AGI_R2_AADT_L3","v":0}]
["Leg has Right-Turn Bypass",null,null,null,null,null,null,null,null,null,null,"No",null,"No"]
["# of Access Points within 250' of Yield Line",null,null,null,null,null,null,null,null,null,null,0,null,0]
["Entering Width (ft)",null,null,null,null,null,null,null,null,null,null,29,null,29]
["# of Entering Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
["# of Circulating Lanes",null,null,null,null,null,null,null,null,null,null,2,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restricted Crossing U-Turn (RCUT) CMF Inputs"]
[]
["# U-Turns",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,2]
["# of Major Roadway Lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["# of Minor Roadway Lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Total Offset Distance (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1250,null,1250]
["Number of Driveways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,4]
["Total Deceleration Lane Length (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,null,750]
["Total Acceleration Lane Length (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750]
["Number of Left-Turn Lanes From Major Road",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Major Road Speed Limit (mph)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<=50"]
["Total Median Width (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
["Maximum Median Width (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]

{"sheet":"Calibration","index":7,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[50,8,50,9],[51,6,51,7],[51,8,51,9],[52,6,52,7],[52,8,52,9],[75,2,76,3],[58,2,58,3],[59,2,60,3],[61,2,62,3],[63,2,64,3],[65,2,66,3],[67,2,68,3],[69,2,70,3],[71,2,72,3],[73,2,74,3],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[58,8,58,9],[53,6,53,7],[53,8,53,9],[72,8,72,9],[29,8,29,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[7,1,8,1],[14,8,14,9],[8,6,8,7],[18,8,18,9],[18,6,18,7],[3,3,4,3],[3,4,4,4],[9,1,16,1],[28,8,28,9],[19,6,19,7],[24,6,24,7],[9,6,9,7],[15,8,15,9],[16,8,16,9],[17,8,17,9],[50,6,50,7],[0,0,0,9],[1,0,1,9],[2,0,2,9],[5,8,5,9],[6,8,6,9],[15,6,15,7],[16,6,16,7],[17,6,17,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[17,1,18,1],[3,5,4,5],[3,0,4,0],[3,1,4,1],[3,2,4,2],[5,0,18,0],[5,1,6,1],[62,0,62,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[55,6,55,7],[55,8,55,9],[59,8,59,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[39,6,39,7],[30,8,30,9],[31,8,31,9],[32,8,32,9],[36,6,36,7],[37,6,37,7],[38,6,38,7],[47,0,47,9],[40,6,40,7],[41,6,41,7],[37,1,38,1],[42,6,42,7],[40,8,40,9],[41,8,41,9],[42,8,42,9],[38,8,38,9],[39,8,39,9],[43,0,44,1],[45,0,46,1],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[48,6,49,7],[76,0,76,1],[67,0,67,1],[69,0,69,1],[75,0,75,1],[70,0,70,1],[68,0,68,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[54,0,55,0],[54,1,54,4],[55,1,55,4],[53,1,53,4],[56,0,56,9],[48,0,49,0],[54,6,54,7],[54,8,54,9],[66,0,66,1],[64,0,64,1],[61,0,61,1],[63,0,63,1],[65,0,65,1],[33,1,34,1],[35,1,36,1],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[35,6,35,7],[19,0,32,0],[33,6,33,7],[34,6,34,7],[19,1,20,1],[21,1,22,1],[23,1,30,1],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[68,6,68,7],[69,6,69,7],[70,6,70,7],[50,1,50,4],[51,1,51,4],[52,1,52,4],[57,0,57,9],[3,6,4,7],[3,8,4,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[48,8,49,9],[48,5,49,5],[31,1,32,1],[39,0,42,0],[39,1,40,1],[41,1,42,1],[48,1,49,4],[33,0,38,0],[76,8,76,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[67,8,67,9],[76,6,76,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[66,6,66,7],[67,6,67,7],[73,8,73,9],[74,8,74,9],[69,8,69,9],[70,8,70,9],[75,8,75,9],[75,6,75,7],[68,8,68,9],[71,6,71,7],[72,6,72,7],[73,6,73,7],[74,6,74,7],[71,8,71,9]]}
["Calibration"]
["Optional - Input locally-developed calibration factors for SPFs. "]
["At-Grade Intersection SPFs"]
["Traffic Control","Facility Type","# legs","1 way/ 2 way","# of lanes on arterial","Default Calibration Factor","Optional User Override",null,"Use Value"]
[]
["Traffic Signal\n\n(For more information on determining signal type, refer to the \"Definitions\" worksheet)","On Rural Two Lane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F6","v":1},null,null,{"$f":"IF(ISNUMBER(G6),G6,F6)","v":1}]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F7","v":0.92},null,null,{"$f":"IF(ISNUMBER(G7),G7,F7)","v":0.92}]
[null,"On Rural Multilane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F8","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F9","v":0.45},null,null,0.45]
[null,"On Urban and Suburban Arterial","3 leg","2x2","5 or fewer",{"$f":"CalibrationDefaults!F10","v":2.5},null,null,2.5]
[null,null,"4 leg","2x2","5 or fewer",{"$f":"CalibrationDefaults!F11","v":2.27},null,null,2.27]
[null,null,"3 leg","2x2","6 or more",{"$f":"CalibrationDefaults!F12","v":1},null,null,1]
[null,null,"4 leg","2x2","6 or more",{"$f":"CalibrationDefaults!F13","v":1},null,null,1]
[null,null,"3 leg","1x2","-",{"$f":"CalibrationDefaults!F14","v":1},null,null,1]
[null,null,"4 leg","1x2","-",{"$f":"CalibrationDefaults!F15","v":1},null,null,1]
[null,null,"3 leg","1x1","-",{"$f":"CalibrationDefaults!F16","v":1},null,null,1]
[null,null,"4 leg","1x1","-",{"$f":"CalibrationDefaults!F17","v":1},null,null,1]
[null,"On High Speed (50+ MPH) Urban and Suburban Arterial","3 leg","-","-",{"$f":"CalibrationDefaults!F18","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F19","v":1},null,null,1]
["Minor Road Stop","On Rural Two Lane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F20","v":1.27},null,null,1.27]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F21","v":0.74},null,null,0.74]
[null,"On Rural Multilane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F22","v":2.2000000000000002},null,null,2.2000000000000002]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F23","v":1.64},null,null,1.64]
[null,"On Urban and Suburban Arterial","3 leg","2x2","5 or fewer",{"$f":"CalibrationDefaults!F24","v":1.1399999999999999},null,null,1.1399999999999999]
[null,null,"4 leg","2x2","5 or fewer",{"$f":"CalibrationDefaults!F25","v":1.87},null,null,1.87]
[null,null,"3 leg","2x2","6 or more",{"$f":"CalibrationDefaults!F26","v":1},null,null,1]
[null,null,"4 leg","2x2","6 or more",{"$f":"CalibrationDefaults!F27","v":1},null,null,1]
[null,null,"3 leg","1x2","-",{"$f":"CalibrationDefaults!F28","v":1},null,null,1]
[null,null,"4 leg","1x2","-",{"$f":"CalibrationDefaults!F29","v":1},null,null,1]
[null,null,"3 leg","1x1","-",{"$f":"CalibrationDefaults!F30","v":1},null,null,1]
[null,null,"4 leg","1x1","-",{"$f":"CalibrationDefaults!F31","v":1},null,null,1]
[null,"On High Speed (50+ MPH) Urban and Suburban Arterial","3 leg","-","-",{"$f":"CalibrationDefaults!F32","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F33","v":1},null,null,1]
["All-Way Stop","On Rural Two Lane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F34","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F35","v":1},null,null,1]
[null,"On Rural Multilane Highway","3 leg","-","-",{"$f":"CalibrationDefaults!F36","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F37","v":1},null,null,1]
[null,"On Urban and Suburban Arterial","3 leg","-","-",{"$f":"CalibrationDefaults!F38","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F39","v":1},null,null,1]
["Roundabout","1-lane roundabout","3 leg","-","-",{"$f":"CalibrationDefaults!F40","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F41","v":1},null,null,1]
[null,"2-lane roundabout","3 leg","-","-",{"$f":"CalibrationDefaults!F42","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F43","v":1},null,null,1]
["Signalized Restricted Crossing U-Turn (RCUT), also known Superstreet",null,"3 leg","-","-",{"$f":"CalibrationDefaults!F44","v":1},null,null,{"$f":"IF(ISNUMBER(G44),G44,F44)","v":1}]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F45","v":1},null,null,1]
["Unsignalized Restricted Crossing U-Turn (RCUT), also known as J-Turn",null,"3 leg","-","-",{"$f":"CalibrationDefaults!F46","v":1},null,null,1]
[null,null,"4 leg","-","-",{"$f":"CalibrationDefaults!F47","v":1},null,null,1]
["Ramp Terminal Intersection SPFs"]
["Control","Ramp and Intersection Type",null,null,null,"SPF Calibration Factor","Optional User Override",null,"Use Value"]
[]
["Conventional Traffic Signal","Four-leg terminals with diagonal ramps (D4)",null,null,null,1,null,null,1]
["Crossover Traffic Signal (of Diverging Diamond Interchange)","All types",null,null,null,1,null,null,{"$f":"IF(ISNUMBER(G52),G52,F52)","v":1}]
["Single-Point Diamond Traffic Signal","All types",null,null,null,1,null,null,1]
["Minor Road (Ramp) Stop","Four-leg terminals with diagonal ramps (D4)",null,null,null,1,null,null,1]
["Roundabout","1-lane roundabout with 4 legs",null,null,null,1,null,null,1]
[null,"2-lane roundabout with 4 legs",null,null,null,1,null,null,1]
["Local CMFs"]
["Optional - Override default CMFs with locally-developed or new CMFs"]
["Control",null,"Default Base Intersection",null,"Type of Crashes","Default CMF","Optional User Override",null,"Use Value"]
["Displaced Left Turn (DLT)",null,"Traffic Signal",null,"Total",0.88,null,null,{"$f":"IF(ISNUMBER(G60),G60,F60)","v":0.88}]
[null,null,null,null,"Fatal-Injury",0.88,null,null,{"$f":"IF(ISNUMBER(G61),G61,F61)","v":0.88}]
["Median U-Turn (MUT)",null,"Traffic Signal",null,"Total",0.85,null,null,0.85]
[null,null,null,null,"Fatal-Injury",0.7,null,null,0.7]
["Signalized Restricted Crossing U-Turn (RCUT), also known Superstreet",null,"Traffic Signal",null,"Total",0.85,null,null,0.85]
[null,null,null,null,"Fatal-Injury",0.78,null,null,0.78]
["Unsignalized Restricted Crossing U-Turn (RCUT), also known as J-Turn",null,"Minor Road Stop (TWSC)",null,"Total",0.65,null,null,0.65]
[null,null,null,null,"Fatal-Injury",0.46,null,null,0.46]
["Continuous Green-T Intersection",null,"Traffic Signal",null,"Total",0.96,null,null,0.96]
[null,null,null,null,"Fatal-Injury",0.85,null,null,0.85]
["Jughandles",null,"Traffic Signal",null,"Total",0.74,null,null,0.74]
[null,null,null,null,"Fatal-Injury",0.74,null,null,0.74]
[{"$f":"Label_AGI_Other1","v":"Other 1"},null,"User Selection",null,"Total",1,null,null,{"$f":"IF(ISNUMBER(G72),G72,F72)","v":1}]
[null,null,null,null,"Fatal-Injury",1,null,null,1]
[{"$f":"Label_AGI_Other2","v":"Other 2"},null,"User Selection",null,"Total",1,null,null,1]
[null,null,null,null,"Fatal-Injury",1,null,null,1]
["Crossover Traffic Signal (of Diverging Diamond Interchange)",null,"Traffic Signal",null,"Total",0.67,null,null,{"$f":"IF(ISNUMBER(G76),G76,F76)","v":0.67}]
[null,null,null,null,"Fatal-Injury",0.59,null,null,{"$f":"IF(ISNUMBER(G77),G77,F77)","v":0.59}]

{"sheet":"ExistingData","index":8,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":true,"merged":[[2,5,2,8]]}
[]
[]
["Intersetion Type","Traffic Signal or Minor Road Stop"]
["Years of Data",5]
[null,null,null,null,null,null,null,null,1,"Predicted","Based on SPF only"]
[null,null,null,null,null,null,null,null,2,"Expected","Based on SPF w/ EB applied"]
[null,"Total ","FI","PDO","Ped",null,null,null,3,"Observed","Historical crash data"]
["Historical Crashes Year 1"]
["Historical Crashes Year 2"]
["Historical Crashes Year 3"]
["Historical Crashes Year 4"]
["Historical Crashes Year 5"]
[]
["Historical Crash Data (Sum Over All Years)",35,7,28,1]
["Average Crashes (per year)",{"$f":"B14/$B$4","v":7},{"$f":"C14/$B$4","v":1.4},5.6,0.2]

{"sheet":"CalibrationDefaults","index":9,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,0,0,10],[1,0,1,10],[3,7,4,7],[3,6,4,6],[3,8,4,8],[2,0,2,1],[2,2,2,4],[3,9,4,9],[3,10,4,10],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[5,0,18,0],[5,1,6,1],[7,1,8,1],[9,1,16,1],[17,1,18,1],[43,0,44,1],[45,0,46,1],[19,0,32,0],[19,1,20,1],[21,1,22,1],[23,1,30,1],[31,1,32,1],[33,0,38,0],[33,1,34,1],[35,1,36,1],[37,1,38,1],[39,0,42,0],[39,1,40,1],[41,1,42,1]]}
["Default Calibration ReferenceCalibration"]
["At-Grade Intersection SPFs"]
["Select From the Dropdown Menu:",null,"FDOT"]
["Traffic Control","Facility Type","# legs","1 way/ 2 way","# of lanes on arterial","Use Value","Empty","FDOT","Future1","Future2","Future3"]
[]
["Traffic Signal\n\n(For more information on determining signal type, refer to the \"Definitions\" worksheet)","On Rural Two Lane Highway","3 leg","-","-",{"$f":"IF(ISNUMBER(IF($C$3=$G$4,G6,IF($C$3=$H$4,H6,IF($C$3=$I$4,I6,IF($C$3=$J$4,J6,IF($C$3=$K$4,K6,1)))))),IF($C$3=$G$4,G6,IF($C$3=$H$4,H6,IF($C$3=$I$4,I6,IF($C$3=$J$4,J6,IF($C$3=$K$4,K6,1))))),1)","v":1},1,"--",1,1,1]
[null,null,"4 leg","-","-",{"$f":"IF(ISNUMBER(IF($C$3=$G$4,G7,IF($C$3=$H$4,H7,IF($C$3=$I$4,I7,IF($C$3=$J$4,J7,IF($C$3=$K$4,K7,1)))))),IF($C$3=$G$4,G7,IF($C$3=$H$4,H7,IF($C$3=$I$4,I7,IF($C$3=$J$4,J7,IF($C$3=$K$4,K7,1))))),1)","v":0.92},1,0.92,1,1,1]
[null,"On Rural Multilane Highway","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",0.45,1,0.45,1,1,1]
[null,"On Urban and Suburban Arterial","3 leg","2x2","5 or fewer",2.5,1,2.5,1,1,1]
[null,null,"4 leg","2x2","5 or fewer",2.27,1,2.27,1,1,1]
[null,null,"3 leg","2x2","6 or more",1,1,"--",1,1,1]
[null,null,"4 leg","2x2","6 or more",1,1,"--",1,1,1]
[null,null,"3 leg","1x2","-",1,1,"--",1,1,1]
[null,null,"4 leg","1x2","-",1,1,"--",1,1,1]
[null,null,"3 leg","1x1","-",1,1,"--",1,1,1]
[null,null,"4 leg","1x1","-",1,1,"--",1,1,1]
[null,"On High Speed (50+ MPH) Urban and Suburban Arterial","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
["Minor Road Stop","On Rural Two Lane Highway","3 leg","-","-",1.27,1,1.27,1,1,1]
[null,null,"4 leg","-","-",0.74,1,0.74,1,1,1]
[null,"On Rural Multilane Highway","3 leg","-","-",2.2000000000000002,1,2.2000000000000002,1,1,1]
[null,null,"4 leg","-","-",1.64,1,1.64,1,1,1]
[null,"On Urban and Suburban Arterial","3 leg","2x2","5 or fewer",1.1399999999999999,1,1.1399999999999999,1,1,1]
[null,null,"4 leg","2x2","5 or fewer",1.87,1,1.87,1,1,1]
[null,null,"3 leg","2x2","6 or more",1,1,"--",1,1,1]
[null,null,"4 leg","2x2","6 or more",1,1,"--",1,1,1]
[null,null,"3 leg","1x2","-",1,1,"--",1,1,1]
[null,null,"4 leg","1x2","-",1,1,"--",1,1,1]
[null,null,"3 leg","1x1","-",1,1,"--",1,1,1]
[null,null,"4 leg","1x1","-",1,1,"--",1,1,1]
[null,"On High Speed (50+ MPH) Urban and Suburban Arterial","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
["All-Way Stop","On Rural Two Lane Highway","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
[null,"On Rural Multilane Highway","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
[null,"On Urban and Suburban Arterial","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
["Roundabout","1-lane roundabout","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
[null,"2-lane roundabout","3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
["Signalized Restricted Crossing U-Turn (RCUT), also known Superstreet",null,"3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]
["Unsignalized Restricted Crossing U-Turn (RCUT), also known as J-Turn",null,"3 leg","-","-",1,1,"--",1,1,1]
[null,null,"4 leg","-","-",1,1,"--",1,1,1]

{"sheet":"Historical","index":10,"n_rows":92,"n_cols":27,"rows_kept":92,"cut":false,"hidden":false,"merged":[[82,19,86,19],[87,18,91,18],[87,19,91,19],[68,2,70,12],[71,1,76,1],[71,2,71,3],[72,18,86,18],[72,19,76,19],[76,2,76,12],[77,1,82,1],[77,2,77,3],[77,19,81,19],[82,2,82,12],[55,1,70,1],[55,2,55,3],[56,2,58,2],[52,2,54,12],[52,19,56,19],[57,18,71,18],[57,19,61,19],[59,2,61,2],[62,2,64,2],[62,19,66,19],[65,2,67,2],[67,19,71,19],[38,1,38,14],[38,18,41,20],[38,21,38,26],[39,1,54,1],[39,2,39,3],[39,21,41,21],[39,22,41,22],[39,23,41,23],[39,24,41,26],[40,2,42,2],[42,18,56,18],[42,19,46,19],[43,2,45,2],[46,2,48,2],[47,19,51,19],[49,2,51,2],[18,1,20,1],[0,0,0,13],[1,0,2,13],[4,1,5,2],[4,3,5,4],[6,3,6,4],[6,10,6,11],[7,3,7,4],[10,1,11,2],[10,3,10,12],[12,1,14,1],[15,1,17,1]]}
["Historical Crash Data Input"]
["Note: In order to use Empirical Bayes (EB), the historical intersection type must be a traffic signal or a minor road stop.  Additionally, this alternative must be selected to be included in the analysis, and the historical intersection specified below.  Up to 10 years of historical data can be used to perform the EB adjustment."]
[]
[]
[null,"Is historical crash data available?",null,"No"]
[]
[null,"Number of years available:",null,5,null,"(Up to 10)",null,"First Year Data is available: ",null,null,2010]
[null,"Historical Intx Type:",null,"4SG"]
[null,"Facility Type",null,{"$f":"IF(Input_FacilityType=FacilityType_Label_Rural2Ln,1,IF(Input_FacilityType=FacilityType_Label_RuralMultiLn,2,IF(Input_FacilityType=FacilityType_Label_Urban,IF(Input_1Way2Way=Notes!$A$54,IF(Input_NumMajorLanes=Notes!$A$60,3,4),IF(Input_1Way2Way=Notes!$A$55,5,6)))))","v":3}]
[]
[null,"Historical Crash Counts",null,"Year"]
[null,null,null,{"$f":"IF($D$7>0,$K$7,\"--\")","v":2010},{"$f":"IF($D$7>1,$K$7+1,\"--\")","v":2011},{"$f":"IF($D$7>2,$K$7+2,\"--\")","v":2012},{"$f":"IF($D$7>3,$K$7+3,\"--\")","v":2013},{"$f":"IF($D$7>4,$K$7+4,\"--\")","v":2014},{"$f":"IF($D$7>5,$K$7+5,\"--\")","v":"--"},{"$f":"IF($D$7>6,$K$7+6,\"--\")","v":"--"},{"$f":"IF($D$7>7,$K$7+7,\"--\")","v":"--"},{"$f":"IF($D$7>8,$K$7+8,\"--\")","v":"--"},{"$f":"IF($D$7>9,$K$7+9,\"--\")","v":"--"},"Total"]
[{"$f":"EB_Facility_Type<>3","v":false},"Combined","Total",{"$f":"IF(ISNUMBER(D$12),SUM(D14:D15),\"--\")","v":0},{"$f":"IF(ISNUMBER(E12),SUM(E14:E15),\"--\")","v":0},0,0,0,"--","--","--","--","--",{"$f":"IF(ISNUMBER(D13),SUM(D13:M13),\"--\")","v":0},{"$f":"IF(AND(A13,COUNTIF(D13:M13,\"=0\")>0),\"One or more years has 0 total crashes.\",\"\")","v":""}]
[null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(D14:M14,--(ISNUMBER($D$12:$M$12)))","v":0}]
[null,null,"PDO",null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"EB_Facility_Type=3","v":true},"Single-Vehicle","Total",{"$f":"IF(ISNUMBER(D$12),SUM(D17:D18),\"--\")","v":0},{"$f":"IF(ISNUMBER(E$12),SUM(E17:E18),\"--\")","v":0},0,0,0,"--","--","--","--","--",0,{"$f":"IF(AND(A16,COUNTIF(D16:M16,\"=0\")>0),\"One or more years has 0 total crashes.\",\"\")","v":"One or more years has 0 total crashes."}]
[null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"PDO",null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"EB_Facility_Type=3","v":true},"Multiple-Vehicle","Total",{"$f":"IF(ISNUMBER(D$12),SUM(D20:D21),\"--\")","v":0},{"$f":"IF(ISNUMBER(E$12),SUM(E20:E21),\"--\")","v":0},0,0,0,"--","--","--","--","--",0,{"$f":"IF(AND(A19,COUNTIF(D19:M19,\"=0\")>0),\"One or more years has 0 total crashes.\",\"\")","v":"One or more years has 0 total crashes."}]
[null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"PDO",null,null,null,null,null,null,null,null,null,null,0]
[true,"Veh-Ped","Fatal/Injury",null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"TRUE","v":true},"Veh-Bike","Fatal/Injury",null,null,null,null,null,null,null,null,null,null,0]
[null,"Total","All",{"$f":"IF($A$13,SUM(D14:D15),0)+IF($A$16,SUM(D20:D21),0)+IF($A$16,SUM(D17:D18),0)+IF($A$22,D22,0)+IF($A$23,D23,0)","v":0},{"$f":"IF(ISNUMBER(E12),IF($A$13,SUM(E14:E15),0)+IF($A$16,SUM(E20:E21),0)+IF($A$16,SUM(E17:E18),0)+IF($A$22,E22,0)+IF($A$23,E23,0),\"--\")","v":0},0,0,0,"--","--","--","--","--",{"$f":"IF($A$13,SUM(N14:N15),0)+IF($A$16,SUM(N20:N21),0)+IF($A$16,SUM(N17:N18),0)+IF($A$22,N22,0)+IF($A$23,N23,0)","v":0}]
[]
[]
[]
[]
[]
[null,"Computations Only Below This Point"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empirical Bayes Computations (No Data Entry)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dispersion Parameters",null,null,"At-Grade Intersection Facility Type"]
[null,{"$f":"IF($D$9<>3,\"Combined Collisions\",\"Single-Vehicle Only\")","v":"Single-Vehicle Only"},"Year",null,{"$f":"D$12","v":2010},2011,2012,2013,2014,"--","--","--","--","--","Total",null,null,null,null,null,null,"Rural Two-Lane Highways","Rural Multilane Highways","Urban/Suburban Arterials w/ 5 or Fewer Lanes","Urban/Suburban Arterials w/ 6 or More Lanes"]
[null,null,"Npredicted","Total",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(NPred_Total)),NPred_Total,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E44),SUM(E41:N41),\"--\")","v":0}]
[null,null,null,"Fatal/Injury",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(NPred_FI)),NPred_FI,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E45),SUM(E42:N42),\"--\")","v":0}]
[null,null,null,"PDO",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(NPred_PDO)),NPred_PDO,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E46),SUM(E43:N43),\"--\")","v":0},null,null,null,"Combined Multi and Single Vehicle","Total","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,"Dispersion Parameter (k)","Total",{"$f":"IF($D$9<>3,VLOOKUP(EB_Intx_Type,U44:AB47,$D$9+1,FALSE),VLOOKUP(EB_Intx_Type,U59:AA62,$D$9+1,FALSE))","v":0.36},{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E44)),E44,\"--\")","v":0.36},0.36,0.36,0.36,"--","--","--","--","--","--",null,null,null,null,null,"3ST",0.54,0.46,"--","--","--","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF($D$9<>3,VLOOKUP(EB_Intx_Type,U49:AB52,$D$9+1,FALSE),VLOOKUP(EB_Intx_Type,U64:AA67,$D$9+1,FALSE))","v":0.09},0.09,0.09,0.09,0.09,"--","--","--","--","--","--",null,null,null,null,null,"3SG","--","--","--","--","--","--"]
[null,null,null,"PDO",{"$f":"IF($D$9<>3,VLOOKUP(EB_Intx_Type,U54:AB57,$D$9+1,FALSE),VLOOKUP(EB_Intx_Type,U69:AA72,$D$9+1,FALSE))","v":0.44},0.44,0.44,0.44,0.44,"--","--","--","--","--","--",null,null,null,null,null,"4ST",0.24,0.49399999999999999,"--","--","--","--"]
[null,null,"Weighted Adjustment (w)","Total",{"$f":"IF(ISNUMBER(E44),1/(1+E44*E41),\"--\")","v":1},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(ISNUMBER(J44),1/(1+J44*J41),\"--\")","v":"--"},{"$f":"IF(ISNUMBER(K44),1/(1+K44*K41),\"--\")","v":"--"},"--","--","--","--",null,null,null,null,null,"4SG",0.11,0.27700000000000002,"--","--","--","--"]
[null,null,null,"Fatal/Injury",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--","--",null,null,null,null,"Fatal / Injury","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,"PDO",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--","--",null,null,null,null,null,"3ST","--",0.56899999999999995,"--",0.64935064935064934,2,2]
[null,null,"Nexpected","Total",{"$f":"IF(ISNUMBER(E44),E47*E41+(1-E47)*IF($D$9<>3,D13,D16),IF(ISNUMBER(E51),SUM(E51:E52),\"--\"))","v":0},{"$f":"IF(ISNUMBER(F44),F47*F41+(1-F47)*IF($D$9<3,E13,E16),IF(ISNUMBER(F51),SUM(F51:F52),\"--\"))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E44),SUM(E50:N50),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"3SG","--","--","--",0.5181347150259068,0.95238095238095233,0.95238095238095233]
[null,null,null,"Fatal/Injury",{"$f":"IF(ISNUMBER(E45),E48*E42+(1-E48)*IF($D$9<>3,D14,D17),\"--\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E45),SUM(E51:N51),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"4ST","--",0.74199999999999999,"--",0.5988023952095809,0.53191489361702127,0.53191489361702127]
[null,null,null,"PDO",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E46),SUM(E52:N52),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"4SG","--",0.218,"--",0.56497175141242939,1.3333333333333333,1.3333333333333333]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(AND(ISNUMBER(E41),ISNUMBER(E44)),O50/O41,1)","v":1},null,null,null,null,"PDO","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E42),ISNUMBER(E45)),O51/O42,1)","v":1},null,null,null,null,null,"3ST","--","--","--",0.74626865671641784,1.0309278350515465,1.0309278350515465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(E43),ISNUMBER(E46)),O52/O43,1)","v":1},null,null,null,null,null,"3SG","--","--","--",1,0.9009009009009008,0.9009009009009008]
[null,"Multiple-Vehicle Only \n(When Applicable)","Year",null,{"$f":"D$12","v":2010},2011,2012,2013,2014,"--","--","--","--","--","Total",null,null,null,null,null,"4ST","--","--","--",1.1363636363636365,0.96153846153846145,0.96153846153846145]
[null,null,"Npredicted","Total",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E57)),E57,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E60),SUM(E57:N57),\"--\")","v":0},null,null,null,null,null,"4SG","--","--","--",0.99009900990099009,2,2]
[null,null,null,"Fatal/Injury",null,"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E61),SUM(E58:N58),\"--\")","v":0},null,null,null,"Single-Vehicle","Total","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,"PDO",null,"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E62),SUM(E59:N59),\"--\")","v":0},null,null,null,null,null,"3ST","--","--",1.1399999999999999,"--","--","--"]
[null,null,"Dispersion Parameter (k)","Total",{"$f":"IF($D$9=3,VLOOKUP(EB_Intx_Type,U74:AA77,$D$9+1,FALSE),\"--\")","v":0.39},0.39,0.39,0.39,0.39,"--","--","--","--","--","--",null,null,null,null,null,"3SG","--","--",0.36,"--","--","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF($D$9=3,VLOOKUP(EB_Intx_Type,U79:AA82,$D$9+1,FALSE),\"--\")","v":0.33},0.33,0.33,0.33,0.33,"--","--","--","--","--","--",null,null,null,null,null,"4ST","--","--",0.65,"--","--","--"]
[null,null,null,"PDO",{"$f":"IF($D$9=3,VLOOKUP(EB_Intx_Type,U84:AA87,$D$9+1,FALSE),\"--\")","v":0.44},0.44,0.44,0.44,0.44,"--","--","--","--","--","--",null,null,null,null,null,"4SG","--","--",0.36,"--","--","--"]
[null,null,"Weighted Adjustment (w)","Total",{"$f":"IF(ISNUMBER(E60),1/(1+E60*E57),\"--\")","v":1},{"$f":"IF(ISNUMBER(F60),1/(1+F60*F57),\"--\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--","--",null,null,null,null,"Fatal / Injury","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,"Fatal/Injury",{"$f":"IF(ISNUMBER(E61),1/(1+E61*E58),\"--\")","v":1},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--","--",null,null,null,null,null,"3ST","--","--","--","--","--","--"]
[null,null,null,"PDO",{"$f":"IF(ISNUMBER(E62),1/(1+E62*E59),\"--\")","v":1},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--","--",null,null,null,null,null,"3SG","--","--",0.24,"--","--","--"]
[null,null,"Nexpected","Total",{"$f":"IF(ISNUMBER(E60),E63*E57+(1-E63)*D19,IF(ISNUMBER(E67),SUM(E67:E68),\"--\"))","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E60),SUM(E66:N66),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"4ST","--","--","--","--","--","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF(ISNUMBER(E61),E64*E58+(1-E64)*D20,\"--\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E61),SUM(E67:N67),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"4SG","--","--",0.09,"--","--","--"]
[null,null,null,"PDO",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(ISNUMBER(E62),SUM(E68:N68),\"--\")","v":{"$error":"#VALUE!"}},null,null,null,null,"PDO","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(AND(ISNUMBER(E57),ISNUMBER(E60)),O66/O57,1)","v":1},null,null,null,null,null,"3ST","--","--",0.28999999999999998,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E58),ISNUMBER(E61)),O67/O58,1)","v":1},null,null,null,null,null,"3SG","--","--",0.53,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(E59),ISNUMBER(E62)),O68/O59,1)","v":1},null,null,null,null,null,"4ST","--","--",0.54,"--","--","--"]
[null,"Vehicle-Pedestrian","Year",null,{"$f":"D$12","v":2010},2011,2012,2013,2014,"--","--","--","--","--","Total",null,null,null,null,null,"4SG","--","--",0.44,"--","--","--"]
[null,null,"Npredicted","Fatal/Injury",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E73)),E73,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E76),SUM(E73:N73),\"--\")","v":0},null,null,null,"Multiple-Vehicle","Total","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,"Disp. (k)","Fatal/Injury",{"$f":"IF($D$9>=3,VLOOKUP(EB_Intx_Type,U89:AB92,$D$9+1,FALSE),\"--\")","v":0.24},0.24,0.24,0.24,0.24,"--","--","--","--","--","--",null,null,null,null,null,"3ST","--","--",0.8,"--","--","--"]
[null,null,"Weight (w)","Fatal/Injury",{"$f":"IF(ISNUMBER(E74),1/(1+E74*E73),\"--\")","v":1},1,1,1,1,"--","--","--","--","--","--",null,null,null,null,null,"3SG","--","--",0.33,"--","--","--"]
[null,null,"Nexpected","Fatal/Injury",{"$f":"IF(ISNUMBER(E74),E75*E73+(1-E75)*D22,\"--\")","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"--","--","--","--","--",{"$f":"IF(AND(ISNUMBER(NPred_Ped),ISNUMBER(E74)),SUM(E76:N76),\"--\")","v":"--"},null,null,null,null,null,"4ST","--","--",0.4,"--","--","--"]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E73),ISNUMBER(E74)),O76/O73,1)","v":1},null,null,null,null,null,"4SG","--","--",0.39,"--","--","--"]
[null,"Vehicle-Bicylce","Year",null,{"$f":"D$12","v":2010},2011,2012,2013,2014,"--","--","--","--","--","Total",null,null,null,null,"Fatal / Injury","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,"Npredicted","Fatal/Injury",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E79)),E79,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E82),SUM(E79:N79),\"--\")","v":"--"},null,null,null,null,null,"3ST","--","--",0.69,"--","--","--"]
[null,null,"Disp. (k)","Fatal/Injury","--","--","--","--","--","--","--","--","--","--","--",null,null,null,null,null,"3SG","--","--",0.3,"--","--","--"]
[null,null,"Weight (w)","Fatal/Injury",{"$f":"IF(ISNUMBER(E80),1/(1+E80*E79),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--",null,null,null,null,null,"4ST","--","--",0.48,"--","--","--"]
[null,null,"Nexpected","Fatal/Injury",{"$f":"IF(ISNUMBER(E80),E81*E79+(1-E81)*E41,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E80),SUM(E82:N82),\"--\")","v":"--"},null,null,null,null,null,"4SG","--","--",0.33,"--","--","--"]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E79),ISNUMBER(E80)),O82/O79,1)","v":1},null,null,null,null,"PDO","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3ST","--","--",0.77,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3SG","--","--",0.36,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4ST","--","--",0.4,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG","--","--",0.44,"--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veh-Pedestrian","Fatal / Injury","Intx","R2L","RML","U/S Art.","2x2","1x2","1x1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3ST","--","--","--","--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3SG","--","--",0.52,0.52,0.52,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4ST","--","--","--","--","--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG","--","--",0.24,0.24,0.24,0.24]

{"sheet":"HistoricalRTI","index":11,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":true,"merged":[[52,2,54,12],[52,19,56,19],[55,1,70,1],[55,2,55,3],[56,2,58,2],[59,2,61,2],[62,2,64,2],[65,2,67,2],[68,2,70,12],[39,1,54,1],[39,2,39,3],[39,18,41,21],[40,2,42,2],[42,18,56,18],[42,19,46,19],[43,2,45,2],[46,2,48,2],[47,19,51,19],[49,2,51,2],[7,3,7,4],[10,1,11,2],[10,3,10,12],[12,1,14,1],[15,1,17,1],[38,1,38,14],[0,0,0,13],[1,0,2,13],[4,1,5,2],[4,3,5,4],[6,3,6,4],[6,10,6,11]]}
["Historical Crash Data Input"]
["Note: In order to use Empirical Bayes (EB), the historical intersection type must be a traffic signal or a minor road stop.  Additionally, this alternative must be selected to be included in the analysis, and the historical intersection specified below.  Up to 10 years of historical data can be used to perform the EB adjustment."]
[]
[]
[null,"Use historical Emprical Bayes Adjustment?",null,"No"]
[]
[null,"Number of years available:",null,2,null,"(Up to 10)",null,"First Year Data is available: ",null,null,2010]
[null,"Historical Intx Type:",null,"4SG"]
[]
[]
[null,"Historical Crash Counts",null,"Year"]
[null,null,null,{"$f":"IF($D$7>0,$K$7,\"--\")","v":2010},{"$f":"IF($D$7>1,$K$7+1,\"--\")","v":2011},{"$f":"IF($D$7>2,$K$7+2,\"--\")","v":"--"},{"$f":"IF($D$7>3,$K$7+3,\"--\")","v":"--"},{"$f":"IF($D$7>4,$K$7+4,\"--\")","v":"--"},{"$f":"IF($D$7>5,$K$7+5,\"--\")","v":"--"},{"$f":"IF($D$7>6,$K$7+6,\"--\")","v":"--"},{"$f":"IF($D$7>7,$K$7+7,\"--\")","v":"--"},{"$f":"IF($D$7>8,$K$7+8,\"--\")","v":"--"},{"$f":"IF($D$7>9,$K$7+9,\"--\")","v":"--"},"Total"]
[null,"NB Ramp Terminal","Total",{"$f":"IF(ISNUMBER(D$12),SUM(D14:D15),\"--\")","v":10},{"$f":"IF(ISNUMBER(E12),SUM(E14:E15),\"--\")","v":10},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(D13),SUM(D13:M13),\"--\")","v":20},{"$f":"IF(COUNTIF(D13:M13,\"=0\")>0,\"One or more years has 0 total crashes.\",\"\")","v":""}]
[null,null,"Fatal/Injury",5,5,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(D14:M14,--(ISNUMBER($D$12:$M$12)))","v":10}]
[null,null,"PDO",5,5,null,null,null,null,null,null,null,null,10]
[null,"SB Ramp Terminal","Total",{"$f":"IF(ISNUMBER(D$12),SUM(D17:D18),\"--\")","v":12},{"$f":"IF(ISNUMBER(E12),SUM(E17:E18),\"--\")","v":12},{"$f":"IF(ISNUMBER(F12),SUM(F17:F18),\"--\")","v":"--"},"--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(D16),SUM(D16:M16),\"--\")","v":24},{"$f":"IF(COUNTIF(D16:M16,\"=0\")>0,\"One or more years has 0 total crashes.\",\"\")","v":""}]
[null,null,"Fatal/Injury",6,6,null,null,null,null,null,null,null,null,12]
[null,null,"PDO",6,6,null,null,null,null,null,null,null,null,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Computations Only Below This Point"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Combined Colisions - \"&B13","v":"Combined Colisions - NB Ramp Terminal"},"Year",null,{"$f":"D$12","v":2010},2011,"--","--","--","--","--","--","--","--","Total",null,null,null,"Ramp Terminal\n Dispersion Parameters"]
[null,null,"Npredicted","Total",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_Total1)),Npred_RTI_Total1,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E44),SUM(E41:N41),\"--\")","v":"--"}]
[null,null,null,"Fatal/Injury",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_FI1)),Npred_RTI_FI1,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E45),SUM(E42:N42),\"--\")","v":0}]
[null,null,null,"PDO",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_PDO1)),Npred_RTI_PDO1,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E46),SUM(E43:N43),\"--\")","v":0},null,null,null,"Combined Multi and Single Vehicle","Total","Intx","D4"]
[null,null,"Dispersion Parameter (k)","Total",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U44:V47,2,FALSE)","v":"--"},{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E44)),E44,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",null,null,null,null,null,"3ST","--"]
[null,null,null,"Fatal/Injury",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U49:V52,2,FALSE)","v":8.6956521739130432E-2},8.6956521739130432E-2,"--","--","--","--","--","--","--","--","--",null,null,null,null,null,"3SG","--"]
[null,null,null,"PDO",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U54:V57,2,FALSE)","v":0.13869625520110956},0.13869625520110956,"--","--","--","--","--","--","--","--","--",null,null,null,null,null,"4ST","--"]
[null,null,"Weighted Adjustment (w)","Total",{"$f":"IF(AND(ISNUMBER(Npred_RTI_Total1),ISNUMBER(E44)),1/(1+E44*E41),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--",null,null,null,null,null,"4SG","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF(AND(ISNUMBER(Npred_RTI_FI1),ISNUMBER(E45)),1/(1+E45*E42),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--",null,null,null,null,"Fatal / Injury","Intx","D4"]
[null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(Npred_RTI_PDO1),ISNUMBER(E46)),1/(1+E46*E43),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--",null,null,null,null,null,"3ST","--"]
[null,null,"Nexpected","Total",{"$f":"IF(AND(ISNUMBER(Npred_RTI_Total1),ISNUMBER(E44)),E47*E41+(1-E47)*D13,IF(ISNUMBER(E51),SUM(E51:E52),\"--\"))","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E44),SUM(E50:N50),\"--\")","v":"--"},null,null,null,null,null,"3SG","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF(AND(ISNUMBER(Npred_RTI_FI1),ISNUMBER(E45)),E48*E42+(1-E48)*D14,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E45),SUM(E51:N51),\"--\")","v":0},null,null,null,null,null,"4ST",0.38759689922480617]
[null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(Npred_RTI_PDO1),ISNUMBER(E46)),E49*E43+(1-E49)*D15,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E46),SUM(E52:N52),\"--\")","v":0},null,null,null,null,null,"4SG",8.6956521739130432E-2]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(AND(ISNUMBER(E41),ISNUMBER(E44)),O50/O41,1)","v":1},null,null,null,null,"PDO","Intx","D4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E42),ISNUMBER(E45)),O51/O42,1)","v":1},null,null,null,null,null,"3ST","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(E43),ISNUMBER(E46)),O52/O43,1)","v":1},null,null,null,null,null,"3SG","--"]
[null,{"$f":"\"Combined Colisions - \"&B16","v":"Combined Colisions - SB Ramp Terminal"},"Year",null,{"$f":"D$12","v":2010},2011,"--","--","--","--","--","--","--","--","Total",null,null,null,null,null,"4ST",0.23419203747072601]
[null,null,"Npredicted","Total",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_Total2)),Npred_RTI_Total2,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E60),SUM(E57:N57),\"--\")","v":"--"},null,null,null,null,null,"4SG",0.13869625520110956]
[null,null,null,"Fatal/Injury",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_FI2)),Npred_RTI_FI2,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E61),SUM(E58:N58),\"--\")","v":0}]
[null,null,null,"PDO",null,{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(Npred_RTI_PDO2)),Npred_RTI_PDO2,\"--\")","v":"--"},"--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E62),SUM(E59:N59),\"--\")","v":0}]
[null,null,"Dispersion Parameter (k)","Total",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U44:V47,2,FALSE)","v":"--"},{"$f":"IF(AND(ISNUMBER(E$12),ISNUMBER(E60)),E60,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--"]
[null,null,null,"Fatal/Injury",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U49:V52,2,FALSE)","v":8.6956521739130432E-2},8.6956521739130432E-2,"--","--","--","--","--","--","--","--","--"]
[null,null,null,"PDO",{"$f":"VLOOKUP(EB_RTI_Intx_Type,U54:V57,2,FALSE)","v":0.13869625520110956},0.13869625520110956,"--","--","--","--","--","--","--","--","--"]
[null,null,"Weighted Adjustment (w)","Total",{"$f":"IF(AND(ISNUMBER(Npred_RTI_Total2),ISNUMBER(E60)),1/(1+E60*E57),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--"]
[null,null,null,"Fatal/Injury",{"$f":"IF(AND(ISNUMBER(Npred_RTI_FI2),ISNUMBER(E61)),1/(1+E61*E58),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--"]
[null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(Npred_RTI_PDO2),ISNUMBER(E62)),1/(1+E62*E59),\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","--"]
[null,null,"Nexpected","Total",{"$f":"IF(AND(ISNUMBER(Npred_RTI_Total2),ISNUMBER(E60)),E63*E57+(1-E63)*D16,IF(ISNUMBER(E67),SUM(E67:E68),\"--\"))","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E60),SUM(E66:N66),\"--\")","v":"--"}]
[null,null,null,"Fatal/Injury",{"$f":"IF(AND(ISNUMBER(Npred_RTI_FI2),ISNUMBER(E61)),E64*E58+(1-E64)*D17,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E61),SUM(E67:N67),\"--\")","v":0}]
[null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(Npred_RTI_PDO2),ISNUMBER(E62)),E65*E59+(1-E65)*D18,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--",{"$f":"IF(ISNUMBER(E62),SUM(E68:N68),\"--\")","v":0}]
[null,null,"Nexpected / Npredicted",null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF(AND(ISNUMBER(E57),ISNUMBER(E60)),O66/O57,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F/I",{"$f":"IF(AND(ISNUMBER(E58),ISNUMBER(E61)),O67/O58,1)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"IF(AND(ISNUMBER(E59),ISNUMBER(E62)),O68/O59,1)","v":1}]

{"sheet":"Results","index":12,"n_rows":43,"n_cols":24,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,6,42,6],[41,7,42,7],[39,6,40,6],[39,7,40,7],[33,6,34,6],[37,6,38,6],[33,7,34,7],[35,7,36,7],[37,7,38,7],[35,6,36,6],[23,6,24,6],[25,6,26,6],[27,6,28,6],[29,6,30,6],[31,6,32,6],[23,7,24,7],[25,7,26,7],[27,7,28,7],[29,7,30,7],[31,7,32,7],[5,4,5,5],[6,4,6,5],[7,4,7,5],[5,6,5,7],[6,6,6,7],[7,6,7,7],[13,0,13,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[8,6,8,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[10,1,10,3],[11,1,11,3],[12,1,12,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[39,0,40,0],[41,0,42,0],[39,5,40,5],[41,5,42,5],[19,0,20,0],[21,0,22,0],[23,0,24,0],[25,0,26,0],[29,0,30,0],[31,0,32,0],[33,0,34,0],[35,0,36,0],[15,0,16,0],[17,0,18,0],[37,0,38,0],[37,5,38,5],[27,5,28,5],[29,5,30,5],[31,5,32,5],[33,5,34,5],[35,5,36,5],[15,5,16,5],[19,5,20,5],[21,5,22,5],[23,5,24,5],[25,5,26,5],[17,5,18,5],[27,0,28,0],[15,6,16,6],[17,6,18,6],[19,6,20,6],[21,6,22,6],[15,7,16,7],[17,7,18,7],[19,7,20,7],[21,7,22,7]]}
["Federal Highway Administration (FHWA)"]
["Safety Performance for Intersection Control Evaluation Tool"]
["Results",null,null,null,null,null,null,null,{"$f":"IF(OR(OR(ISBLANK('Control Strategy Selection'!D5),ISBLANK('Control Strategy Selection'!D13),ISBLANK('Control Strategy Selection'!D14)),IF('Control Strategy Selection'!D4=Label_AnalysisYearType_OpenAndDesign,OR(ISBLANK('Control Strategy Selection'!D6),ISBLANK('Control Strategy Selection'!D15),ISBLANK('Control Strategy Selection'!D16)),FALSE)),\"Please complete the Opening/Design Year Inputs and AADTs Before Viewing Results\",\"\")","v":"Please complete the Opening/Design Year Inputs and AADTs Before Viewing Results"}]
["Summary of crash prediction results for each alternative"]
["Project Information"]
["Project Name:",{"$f":"IF(ISBLANK('Project Information'!B3:C3),\"\",'Project Information'!B3:C3)","v":""},null,null,"Intersection Type",null,{"$f":"'Control Strategy Selection'!D3","v":"At-Grade Intersections"}]
["Intersection:",{"$f":"IF(ISBLANK('Project Information'!B4:C4),\"\",'Project Information'!B4:C4)","v":""},null,null,"Opening Year",null,{"$f":"'Control Strategy Selection'!D5","v":0}]
["Agency: ",{"$f":"IF(ISBLANK('Project Information'!B5:C5),\"\",'Project Information'!B5:C5)","v":""},null,null,"Design Year",null,{"$f":"'Control Strategy Selection'!D6","v":0}]
["Project Reference:",{"$f":"IF(ISBLANK('Project Information'!B6:C6),\"\",'Project Information'!B6:C6)","v":""},null,null,"Facility Type",null,{"$f":"'Control Strategy Selection'!D8","v":"On Urban and Suburban Arterial"}]
["City:",{"$f":"IF(ISBLANK('Project Information'!B7:C7),\"\",'Project Information'!B7:C7)","v":""},null,null,"Number of Legs",null,{"$f":"'Control Strategy Selection'!D9","v":"3-leg"}]
["State:",{"$f":"IF(ISBLANK('Project Information'!B8:C8),\"\",'Project Information'!B8:C8)","v":""},null,null,"1-Way/2-Way",null,{"$f":"'Control Strategy Selection'!D10","v":"2-way Intersecting 2-way"}]
["Date:",{"$f":"IF(ISBLANK('Project Information'!B9:C9),\"\",'Project Information'!B9:C9)","v":""},null,null,"# of Major Street Lanes (both directions)",null,{"$f":"'Control Strategy Selection'!D11","v":"5 or fewer"}]
["Analyst:",{"$f":"IF(ISBLANK('Project Information'!B10:C10),\"\",'Project Information'!B10:C10)","v":""},null,null,"Major Street Approach Speed",null,{"$f":"'Control Strategy Selection'!D12","v":"Less than 55 mph"}]
["Crash Prediction Summary"]
["Control Strategy","Crash Type","Opening Year","Design Year","Total Project Life Cycle","Rank","AADT Within Prediction Range?","Source of Prediction",null,null,null,null,null,null,null,"Use Val (open vs design)",null,"Included","Total","FI",false]
[{"$f":"Label_AGI_TrafficSignal","v":"Traffic Signal"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C16),C16>0),AND(ISNUMBER(E16),E16>0)),X16,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O19:P19),\"Yes\",\"No\")","v":"Yes"},"Calibrated SPF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C16,Results!E16)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C17,Results!E17)","v":0},{"$f":"AND(IsChecked_AGI_TrafficSignal,ISNUMBER(P16))","v":true},{"$f":"IF(AND(P16>0,R16),P16,99999999999)","v":99999999999},{"$f":"IF(AND(Q16>0,R16),Q16,99999999999)","v":99999999999},{"$f":"RANK(S16,$S$16:$S$29,1)","v":1},{"$f":"RANK(T16,$T$16:$T$29,1)","v":1},{"$f":"IF($U$15,U16+0.01*V16,V16+0.01*U16)","v":1.01},{"$f":"RANK(W16,$W$16:$W$29,1)","v":1}]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C18,Results!E18)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C19,Results!E19)","v":0},{"$f":"AND(IsChecked_AGI_TrafficSignal2,ISNUMBER(P17))","v":true},99999999999,99999999999,{"$f":"RANK(S17,$S$16:$S$29,1)","v":1},{"$f":"RANK(T17,$T$16:$T$29,1)","v":1},1.01,{"$f":"RANK(W17,$W$16:$W$29,1)","v":1}]
[{"$f":"Label_AGI_TrafficSignal&\" (Alt)\"","v":"Traffic Signal (Alt)"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C18),C18>0),AND(ISNUMBER(E18),E18>0)),X17,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O20:P20),\"Yes\",\"No\")","v":"Yes"},"Calibrated SPF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C20,Results!E20)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C21,Results!E21)","v":0},{"$f":"AND(IsChecked_AGI_MinorStop,ISNUMBER(P18))","v":true},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C22,Results!E22)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C23,Results!E23)","v":0},{"$f":"AND(IsChecked_AGI_AllStop,ISNUMBER(P19))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_MinorStop","v":"Minor Road Stop"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C20),C20>0),AND(ISNUMBER(E20),E20>0)),X18,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O21:P21),\"Yes\",\"No\")","v":"Yes"},"Calibrated SPF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C24,Results!E24)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C25,Results!E25)","v":0},{"$f":"AND(IsChecked_AGI_Rdbt1Ln,ISNUMBER(P20))","v":true},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C26,Results!E26)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C27,Results!E27)","v":0},{"$f":"AND(IsChecked_AGI_Rdbt2Ln,ISNUMBER(P21))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_AllStop","v":"All Way Stop"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C22),C22>0),AND(ISNUMBER(E22),E22>0)),X19,\"--\")","v":"--"},"N/A","N/A",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C28,Results!E28)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C29,Results!E29)","v":0},{"$f":"AND(IsChecked_AGI_DLT,ISNUMBER(P22))","v":true},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C30,Results!E30)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C31,Results!E31)","v":0},{"$f":"AND(IsChecked_AGI_MUT,ISNUMBER(P23))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_1LnRdbt","v":"1-lane Roundabout"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C24),C24>0),AND(ISNUMBER(E24),E24>0)),X20,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O23:P23),\"Yes\",\"No\")","v":"No"},"Uncalibrated SPF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C32,Results!E32)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C33,Results!E33)","v":0},{"$f":"AND(IsChecked_AGI_RCUTSig,ISNUMBER(P24))","v":true},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C34,Results!E34)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C35,Results!E35)","v":0},{"$f":"AND(IsChecked_AGI_RCUTUnsig,ISNUMBER(P25))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_2LnRdbt","v":"2-lane Roundabout"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C26),C26>0),AND(ISNUMBER(E26),E26>0)),X21,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O24:P24),\"Yes\",\"No\")","v":"No"},"Uncalibrated SPF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C36,Results!E36)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C37,Results!E37)","v":0},{"$f":"AND(IsChecked_AGI_GreenT,ISNUMBER(P26))","v":true},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C38,Results!E38)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C39,Results!E39)","v":0},{"$f":"AND(IsChecked_AGI_Jughandle,ISNUMBER(P27))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_DLT","v":"Displaced Left Turn (DLT)"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C28),C28>0),AND(ISNUMBER(E28),E28>0)),X22,\"--\")","v":"--"},"N/A","CMF",null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C40,Results!E40)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C41,Results!E41)","v":0},{"$f":"AND(IsChecked_AGI_Other1,ISNUMBER(P28))","v":true},99999999999,99999999999,1,1,{"$f":"IF($U$15,U28+0.01*V28,V28+0.01*U28)","v":1.01},1]
[null,"Fatal & Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C42,Results!E42)","v":0},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,Results!C43,Results!E43)","v":0},{"$f":"AND(IsChecked_AGI_Other2,ISNUMBER(P29))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_AGI_MUT","v":"Median U-Turn (MUT)"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C30),C30>0),AND(ISNUMBER(E30),E30>0)),X23,\"--\")","v":"--"},"N/A","CMF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_RCUTSig","v":"Signalized RCUT"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C32),C32>0),AND(ISNUMBER(E32),E32>0)),X24,\"--\")","v":"--"},{"$f":"IF(OR(NOT(AND('Control Strategy Selection'!O27:P27)),NOT(AND(Range_SRCUT_OAADT_Ratio,Range_SRCUT_DAADT_Ratio))),\"No\",\"Yes\")","v":"No"},"Uncalibrated SPF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_RCUTUnsig","v":"Unsignalized RCUT"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C34),C34>0),AND(ISNUMBER(E34),E34>0)),X25,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!O28:P28),\"Yes\",\"No\")","v":"No"},"Uncalibrated SPF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_GreenT","v":"Continuous Green-T Intersection"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C36),C36>0),AND(ISNUMBER(E36),E36>0)),X26,\"--\")","v":"--"},"N/A","CMF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_Jughandle","v":"Jughandle"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C38),C38>0),AND(ISNUMBER(E38),E38>0)),X27,\"--\")","v":"--"},"N/A","CMF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_Other1","v":"Other 1"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C40),C40>0),AND(ISNUMBER(E40),E40>0)),X28,\"--\")","v":"--"},"N/A","CMF"]
[null,"Fatal & Injury"]
[{"$f":"Label_AGI_Other2","v":"Other 2"},"Total",null,null,null,{"$f":"IF(OR(AND(ISNUMBER(C42),C42>0),AND(ISNUMBER(E42),E42>0)),X29,\"--\")","v":"--"},"N/A","CMF"]
[null,"Fatal & Injury"]

{"sheet":"ResultsRTI","index":13,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":true,"merged":[[29,0,30,0],[29,5,30,5],[31,0,32,0],[31,5,32,5],[29,6,30,7],[31,6,32,7],[25,0,26,0],[25,5,26,5],[27,0,28,0],[27,5,28,5],[25,6,26,7],[27,6,28,7],[21,0,22,0],[21,5,22,5],[23,0,24,0],[23,5,24,5],[21,6,22,7],[23,6,24,7],[17,0,18,0],[17,5,18,5],[19,0,20,0],[19,5,20,5],[17,6,18,7],[19,6,20,7],[12,1,12,3],[12,4,12,5],[12,6,12,7],[13,0,13,7],[15,0,16,0],[15,5,16,5],[14,6,14,7],[15,6,16,7],[10,1,10,3],[10,4,10,5],[10,6,10,7],[11,1,11,3],[11,4,11,5],[11,6,11,7],[8,1,8,3],[8,4,8,5],[8,6,8,7],[9,1,9,3],[9,4,9,5],[9,6,9,7],[6,1,6,3],[6,4,6,5],[6,6,6,7],[7,1,7,3],[7,4,7,5],[7,6,7,7],[5,1,5,3],[5,4,5,5],[5,6,5,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7]]}
["Federal Highway Administration (FHWA)"]
["Safety Performance for Intersection Control Evaluation Tool"]
["Results",null,null,null,null,null,null,null,{"$f":"IF(OR(OR(ISBLANK('Control Strategy Selection'!D5),ISBLANK('Control Strategy Selection'!D13),ISBLANK('Control Strategy Selection'!D14)),IF('Control Strategy Selection'!D4=Label_AnalysisYearType_OpenAndDesign,OR(ISBLANK('Control Strategy Selection'!D6),ISBLANK('Control Strategy Selection'!D15),ISBLANK('Control Strategy Selection'!D16)),FALSE)),\"Please complete the Opening/Design Year Inputs and AADTs Before Viewing Results\",\"\")","v":"Please complete the Opening/Design Year Inputs and AADTs Before Viewing Results"}]
["Summary of crash prediction results for each alternative"]
["Project Information"]
["Project Name:",{"$f":"IF(ISBLANK('Project Information'!B3:C3),\"\",'Project Information'!B3:C3)","v":""},null,null,"Intersection Type",null,{"$f":"'Control Strategy Selection'!D3","v":"At-Grade Intersections"}]
["Intersection:",{"$f":"IF(ISBLANK('Project Information'!B4:C4),\"\",'Project Information'!B4:C4)","v":""},null,null,"Opening Year",null,{"$f":"'Control Strategy Selection'!D5","v":0}]
["Agency: ",{"$f":"IF(ISBLANK('Project Information'!B5:C5),\"\",'Project Information'!B5:C5)","v":""},null,null,"Design Year",null,{"$f":"'Control Strategy Selection'!D6","v":0}]
["Project Reference:",{"$f":"IF(ISBLANK('Project Information'!B6:C6),\"\",'Project Information'!B6:C6)","v":""},null,null,"Area Type",null,{"$f":"Input_RTI_AreaType","v":"Urban"}]
["City:",{"$f":"IF(ISBLANK('Project Information'!B7:C7),\"\",'Project Information'!B7:C7)","v":""}]
["State:",{"$f":"IF(ISBLANK('Project Information'!B8:C8),\"\",'Project Information'!B8:C8)","v":""}]
["Date:",{"$f":"IF(ISBLANK('Project Information'!B9:C9),\"\",'Project Information'!B9:C9)","v":""}]
["Analyst:",{"$f":"IF(ISBLANK('Project Information'!B10:C10),\"\",'Project Information'!B10:C10)","v":""}]
["Crash Prediction Summary"]
["Control Strategy","Crash Type","Opening Year","Design Year","Total Project Life Cycle","Rank","AADT Within range?",null,null,null,null,null,null,null,null,"Use Val (open vs design)",null,"Included","Total","FI",false]
[{"$f":"Label_RTI_D4TS","v":"Conventional Traffic Signal"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C16),C16>0),AND(ISNUMBER(E16),E16>0)),X16,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!W61:X61),\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C16,ResultsRTI!E16)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C17,ResultsRTI!E17)","v":"--"},{"$f":"AND(IsChecked_RTI_D4TS,ISNUMBER(P16))","v":false},{"$f":"IF(AND(P16>0,R16),P16,99999999999)","v":99999999999},{"$f":"IF(AND(Q16>0,R16),Q16,99999999999)","v":99999999999},{"$f":"RANK(S16,$S$16:$S$29,1)","v":1},{"$f":"RANK(T16,$T$16:$T$29,1)","v":1},{"$f":"IF($U$15,U16+0.01*V16,V16+0.01*U16)","v":1.01},{"$f":"RANK(W16,$W$16:$W$29,1)","v":1}]
[null,"Fatal & Injury",null,"--","--",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C18,ResultsRTI!E18)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C19,ResultsRTI!E19)","v":"--"},{"$f":"AND(IsChecked_RTI_D4TSA,ISNUMBER(P17))","v":false},99999999999,99999999999,{"$f":"RANK(S17,$S$16:$S$29,1)","v":1},{"$f":"RANK(T17,$T$16:$T$29,1)","v":1},1.01,{"$f":"RANK(W17,$W$16:$W$29,1)","v":1}]
[{"$f":"Label_RTI_D4TSA","v":"Conventional Traffic Signal (Alt)"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C18),C18>0),AND(ISNUMBER(E18),E18>0)),X17,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!W62:X62),\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C20,ResultsRTI!E20)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C21,ResultsRTI!E21)","v":"--"},{"$f":"AND(IsChecked_RTI_DDI,ISNUMBER(P18))","v":false},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,"--","--",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C22,ResultsRTI!E22)","v":-20999},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C23,ResultsRTI!E23)","v":-20999},{"$f":"AND(IsChecked_RTI_SPUI,ISNUMBER(P19))","v":true},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_RTI_DDI","v":"Crossover Traffic Signal (of DDI)"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C20),C20>0),AND(ISNUMBER(E20),E20>0)),X18,\"--\")","v":"--"},"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C24,ResultsRTI!E24)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C25,ResultsRTI!E25)","v":"--"},{"$f":"AND(IsChecked_RTI_D4MS,ISNUMBER(P20))","v":false},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,"--","--",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C26,ResultsRTI!E26)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C27,ResultsRTI!E27)","v":"--"},{"$f":"AND(IsChecked_RTI_Rdbt1Ln,ISNUMBER(P21))","v":false},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_RTI_SPUI","v":"Single-Point Diamond Traffic Signal"},"Total",-9999,-9999,-20999,{"$f":"IF(OR(AND(ISNUMBER(C22),C22>0),AND(ISNUMBER(E22),E22>0)),X19,\"--\")","v":"--"},"N/A",null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C28,ResultsRTI!E28)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C29,ResultsRTI!E29)","v":"--"},{"$f":"AND(IsChecked_RTI_Rdbt2Ln,ISNUMBER(P22))","v":false},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",-9999,-9999,-20999,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C30,ResultsRTI!E30)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C31,ResultsRTI!E31)","v":"--"},{"$f":"AND(IsChecked_RTI_Other1,ISNUMBER(P23))","v":false},99999999999,99999999999,1,1,1.01,1]
[{"$f":"Label_RTI_D4MS","v":"Minor Road (ramp) Stop"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C24),C24>0),AND(ISNUMBER(E24),E24>0)),X20,\"--\")","v":"--"},{"$f":"IF(AND('Control Strategy Selection'!W65:X65),\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C32,ResultsRTI!E32)","v":"--"},{"$f":"IF(Input_AnalysisYearType=Notes!$A$11,ResultsRTI!C33,ResultsRTI!E33)","v":"--"},{"$f":"AND(IsChecked_RTI_Other2,ISNUMBER(P24))","v":false},99999999999,99999999999,1,1,1.01,1]
[null,"Fatal & Injury",null,"--","--"]
[{"$f":"Label_RTI_1LnRdbt","v":"1-lane Roundabout"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C26),C26>0),AND(ISNUMBER(E26),E26>0)),X21,\"--\")","v":"--"},"N/A"]
[null,"Fatal & Injury",null,"--","--"]
[{"$f":"Label_RTI_2LnRdbt","v":"2-lane Roundabout"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C28),C28>0),AND(ISNUMBER(E28),E28>0)),X22,\"--\")","v":"--"},"N/A"]
[null,"Fatal & Injury",null,"--","--"]
[{"$f":"Label_RTI_Other1","v":"Other 1"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C30),C30>0),AND(ISNUMBER(E30),E30>0)),X23,\"--\")","v":"--"},"N/A"]
[null,"Fatal & Injury",null,"--","--"]
[{"$f":"Label_RTI_Other2","v":"Other 2"},"Total",null,"--","--",{"$f":"IF(OR(AND(ISNUMBER(C32),C32>0),AND(ISNUMBER(E32),E32>0)),X24,\"--\")","v":"--"},"N/A"]
[null,"Fatal & Injury",null,"--","--"]

{"sheet":"Notes","index":14,"n_rows":77,"n_cols":18,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Notes:"]
["Alternative Selection Sheet"]
["Number of Alternatives"]
[1]
[2]
[3]
[4]
[5]
[]
["Analysis Year"]
["Opening Year Only"]
["Opening and Design Year"]
[]
["Intersection Type"]
["At-Grade Intersections"]
["Ramp Terminal Intersections"]
[]
["At-Grade Intersctions",null,null,null,null,null,null,null,null,"Ramp Terminal Intersections",null,null,null,null,null,null,"Predictive Inputs"]
["Traffic Signal",null,null,null,null,null,null,null,null,"Conventional Traffic Signal",null,null,null,null,null,null,"Yes"]
["Minor Road Stop",null,null,null,null,null,null,null,null,"Crossover Traffic Signal (of Diverging Diamond Interchange)",null,null,null,null,null,null,"No"]
["All Way Stop",null,null,null,null,null,null,null,null,"Single-Point Diamond Traffic Signal",null,null,null,null,null,null,"N/A"]
["1-lane Roundabout",null,null,null,null,null,null,null,null,"Minor Road (ramp) Stop",null,null,null,null,null,null,"Left Turn Phasing"]
["2-lane Roundabout",null,null,null,null,null,null,null,null,"1-lane Roundabout",null,null,null,null,null,null,"Protected"]
["Displaced Left Turn (DLT)",null,null,null,null,null,null,null,null,"2-lane Roundabout",null,null,null,null,null,null,"Permissive"]
["Median U-Turn (MUT)",null,null,null,null,null,null,null,null,"Freeway Orientation",null,null,null,null,null,null,"Protected/Permissive or Permissive/Protected"]
["Signalized Restricted Crossing U-Turn (RCUT), also known Superstreet",null,null,null,null,null,null,null,null,"North-South",null,null,null,null,null,null,"N/A"]
["Unsignalized Restricted Crossing U-Turn (RCUT), also known as J-Turn",null,null,null,null,null,null,null,null,"East-West"]
["Continuous Green-T Intersection"]
["Jughandle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
["Facility Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
["On Rural Two Lane Highway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3]
["On Rural Multilane Highway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
["On Urban and Suburban Arterial",null,null,null,null,null,null,null,null,"Type",null,null,null,null,null,null,"N/A",5]
["N/A",null,null,null,null,null,null,null,null,"Three-leg terminals with diagonal exit ramp (D3ex)",null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,"Three-leg terminals with diagonal entrance ramp (D3en)",null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,"Four-leg terminals with diagonal ramps (D4)",null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,"Four-leg terminals at four-quadrant parclo A (A4)"]
[null,null,null,null,null,null,null,null,null,"Four-leg terminals at four-quadrant parclo B (B4)"]
[null,null,null,null,null,null,null,null,null,"Three-leg terminals at two-quadrant parclo A (A2)"]
[null,null,null,null,null,null,null,null,null,"Three-leg terminals at two-quadrant parclo B (B2)"]
[null,null,null,null,null,null,null,null,null,"All types"]
[null,null,null,null,null,null,null,null,null,"1-lane roundabout with 3 legs"]
[null,null,null,null,null,null,null,null,null,"1-lane roundabout with 4 legs"]
[null,null,null,null,null,null,null,null,null,"2-lane roundabout with 3 legs"]
[null,null,null,null,null,null,null,null,null,"2-lane roundabout with 4 legs"]
["Number of Legs"]
["3-leg",null,null,null,null,null,null,null,null,"Area Type"]
["4-leg",null,null,null,null,null,null,null,null,"Urban"]
["N/A",null,null,null,null,null,null,null,null,"Rural"]
[]
[]
["1-way/2-way"]
["2-way Intersecting 2-way",null,null,null,null,null,null,null,null,"Ramp Terminal \"Other\" Base Intersections"]
["1-way Intersecting 2-way",null,null,null,null,null,null,null,null,{"$f":"Label_RTI_D4TS","v":"Conventional Traffic Signal"}]
["1-way Intersecting 1-way",null,null,null,null,null,null,null,null,{"$f":"Label_RTI_D4TSA","v":"Conventional Traffic Signal (Alt)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"Label_RTI_D4MS","v":"Minor Road (ramp) Stop"}]
[]
["Number of Lanes"]
["5 or fewer"]
["6 or more"]
[]
[]
[]
["Major Street Approach Speed"]
["Less than 55 mph"]
["55+ mph"]
[]
[]
[]
[]
[]
[]
[]
["Ranking Priority"]
["Total Crashes"]
["Fatal/Injury Crashes"]

{"sheet":"User Selections","index":15,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[43,0,45,0],[41,4,41,5],[41,6,41,7]]}
["Alternatives"]
["At-Grade Selections"]
["Traffic Signal #1",{"$f":"IF('Control Strategy Selection'!B19:C19=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Traffic Signal #2",{"$f":"IF('Control Strategy Selection'!B20:C20=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Minor Road Stop",{"$f":"IF('Control Strategy Selection'!B21:C21=Notes!$Q$19,TRUE,FALSE)","v":true}]
["All Way Stop",{"$f":"IF('Control Strategy Selection'!B22:C22=Notes!$Q$19,TRUE,FALSE)","v":true}]
["1-lane Roundabout",{"$f":"IF('Control Strategy Selection'!B23:C23=Notes!$Q$19,TRUE,FALSE)","v":true}]
["2-lane Roundabout",{"$f":"IF('Control Strategy Selection'!B24:C24=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Displaced Left Turn (DLT)",{"$f":"IF('Control Strategy Selection'!B25:C25=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Median U-Turn (MUT)",{"$f":"IF('Control Strategy Selection'!B26:C26=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Signalized Restricted Crossing U-Turn (RCUT), also known Superstreet",{"$f":"IF('Control Strategy Selection'!B27:C27=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Unsignalized Restricted Crossing U-Turn (RCUT), also known as J-Turn",{"$f":"IF('Control Strategy Selection'!B28:C28=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Continuous Green-T Intersection",{"$f":"IF('Control Strategy Selection'!B29:C29=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Jughandle",{"$f":"IF('Control Strategy Selection'!B30:C30=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Other (Please Specify)",{"$f":"IF('Control Strategy Selection'!B31:C31=Notes!$Q$19,TRUE,FALSE)","v":true}]
["Other (Please Specify)",{"$f":"IF('Control Strategy Selection'!B32:C32=Notes!$Q$19,TRUE,FALSE)","v":true}]
[]
[]
[]
["Ramp Terminal Interchanges"]
[{"$f":"Label_RTI_D4TS","v":"Conventional Traffic Signal"},{"$f":"IF('Control Strategy Selection'!B61:C61=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_D4TSA","v":"Conventional Traffic Signal (Alt)"},{"$f":"IF('Control Strategy Selection'!B62:C62=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_DDI","v":"Crossover Traffic Signal (of DDI)"},{"$f":"IF('Control Strategy Selection'!B63:C63=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_SPUI","v":"Single-Point Diamond Traffic Signal"},{"$f":"IF('Control Strategy Selection'!B64:C64=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_D4MS","v":"Minor Road (ramp) Stop"},{"$f":"IF('Control Strategy Selection'!B65:C65=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_1LnRdbt","v":"1-lane Roundabout"},{"$f":"IF('Control Strategy Selection'!B66:C66=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_2LnRdbt","v":"2-lane Roundabout"},{"$f":"IF('Control Strategy Selection'!B67:C67=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_Other1","v":"Other 1"},{"$f":"IF('Control Strategy Selection'!B68:C68=Notes!$Q$19,TRUE,FALSE)","v":true}]
[{"$f":"Label_RTI_Other2","v":"Other 2"},{"$f":"IF('Control Strategy Selection'!B69:C69=Notes!$Q$19,TRUE,FALSE)","v":true}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Major","Allowable","Minor","Open",null,"Design"]
["RCUT AADT Ratios","Limit","Ratio","Limit","In Range","Under ratio","In Range","Under ratio"]
["This table is used to verify whether the ratio of major to minor AADT falls within the allowable ratios appropriate for the RCUT SPF methodology.",5000,{"$f":"D44/B44","v":1.06},5300,{"$f":"AND(Input_Base_OAADTMajor>0,Input_Base_OAADTMajor<=B44)","v":false},{"$f":"IF(E44,Input_Base_OAADTMinor/Input_Base_OAADTMajor<C44, TRUE)","v":true},{"$f":"AND(Input_Base_DAADTMajor>0,Input_Base_DAADTMajor<=B44)","v":false},{"$f":"IF(G44,Input_Base_DAADTMinor/Input_Base_DAADTMajor<C44, TRUE)","v":true}]
[null,15000,{"$f":"D45/B45","v":0.82466666666666666},12370,{"$f":"AND(Input_Base_OAADTMajor>B44,Input_Base_OAADTMajor<=B45)","v":false},true,{"$f":"AND(Input_Base_DAADTMajor>B44,Input_Base_DAADTMajor<=B45)","v":false},true]
[null,25000,0.64200000000000002,16050,false,true,false,true]
[null,35000,0.5,17500,false,true,false,true]
[null,45000,0.38955555555555554,17530,false,true,false,true]
[null,55000,0.30345454545454548,16690,false,true,false,true]
[null,65000,0.2363076923076923,15360,false,true,false,true]

{"sheet":"Labels","index":16,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Control Strategies"]
["At-Grade Selections"]
["Traffic Signal"]
["Minor Road Stop"]
["All Way Stop"]
["1-lane Roundabout"]
["2-lane Roundabout"]
["Displaced Left Turn (DLT)"]
["Median U-Turn (MUT)"]
["Signalized RCUT"]
["Unsignalized RCUT"]
["Continuous Green-T Intersection"]
["Jughandle"]
[{"$f":"'Control Strategy Selection'!A31","v":"Other 1"}]
[{"$f":"'Control Strategy Selection'!A32","v":"Other 2"}]
[]
["Ramp Terminal Interchanges"]
["Conventional Traffic Signal"]
["Crossover Traffic Signal (of Diverging Diamond Interchange)"]
["Single-Point Diamond Traffic Signal"]
["Minor Road (ramp) Stop"]
["1-lane Roundabout"]
["2-lane Roundabout"]
[]
[]
[]
[]
[]
[]
[]
["Facility Types"]
["On Rural Two Lane Highway"]
["On Rural Multilane Highway"]
["On Urban and Suburban Arterial"]
["On High Speed (50+ MPH) Urban and Suburban Arterial"]
[]
[]
[]
[]
[]
[]
["Analysis Year"]
["Opening Year Only"]
["Opening and Design Year"]
[]
[]
[]
[]
[null,null,null,false,{"$f":"NOT(D51)","v":true}]
["Pedestrian Activity",null,null,"4-Leg","3-Leg"]
[{"$f":"C53&\" (\" & IF($D$51,D53,E53) & \")\"","v":"High (1700)"},null,"High",3200,1700,4,{"$f":"IF(LEFT(Input_TrafficSignal_PedActivity,F53)=C53,TRUE, FALSE)","v":false},{"$f":"IF(LEFT(Input_TrafficSignal2_PedActivity,F53)=C53,TRUE, FALSE)","v":false}]
[{"$f":"C54&\" (\" & IF($D$51,D54,E54) & \")\"","v":"Med High (750)"},null,"Med High",1500,750,8,false,false]
["Medium (400)",null,"Medium",700,400,6,false,false]
["Med Low (120)",null,"Med Low",240,120,7,false,false]
["Low (20)",null,"Low",50,20,3,true,true]
[{"$f":"C58","v":"Other - Enter Below"},null,"Other - Enter Below",null,null,null,false,false]
[]
[]
[]
["High (1,700)"]
["Medium High (750)"]
["Medium (400)"]
["Medium Low (120)"]
["Low (20)"]
["Other - Enter Below"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Exit ramp right turn control"]
["Merge/Free Flow"]
[" Signal/Stop/yield-controlled"]
[]
["Effective number of lanes serving exit ramp"]
[1]
[2]
[3]
[4]
[]
["# of driveways (or public street approaches) on the crossroad leg outside of the interchange"]
[0]
[1]
[2]
[3]
[4]

{"sheet":"Changelog","index":17,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[28,0,30,1],[28,2,30,2],[28,3,30,11],[22,0,24,1],[22,2,24,2],[22,3,24,11],[25,0,27,1],[25,2,27,2],[25,3,27,11],[13,0,15,1],[13,2,15,2],[13,3,15,11],[16,0,18,1],[16,2,18,2],[16,3,18,11],[0,0,1,11],[19,0,21,1],[19,2,21,2],[19,3,21,11],[2,3,3,11],[7,3,9,11],[7,0,9,1],[7,2,9,2],[10,3,12,11],[10,2,12,2],[10,0,12,1],[4,3,6,11],[4,2,6,2],[4,0,6,1],[2,0,3,1],[2,2,3,2]]}
["FDOT SPICE Tool Changelog"]
[]
["Date",null,"Version #","Description"]
[]
["2019-04-23",null,3.1,"Added new safety performance function (SPF) computations for signalized and unsignalized restricted crossing u-turns (RCUTS).  These methods replaced the previous crash modification factor (CMF) based approach."]
[]
[]
["2015-07-01",null,3.2,"Follow-up update to the Signalized RCUT methodology. These updates provided new coefficients for the safety performance function and improved AADT range and ratio limits to relflect the removal of high AADT outlier RCUT sample data sites."]
[]
[]
["2019-07-15",null,3.3,"Small bug fix to remove the deprecated display-only RCUT crash modification factors in the Calibration tab, as well as include new optional inputs to apply a calibration factor to the safety performance functions for signalized and unsignalized RCUTs."]