{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input","Stage 1","Stage 2","Stage 3","List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[56,4,56,6],[23,0,23,3],[58,0,58,3],[58,4,58,6],[28,4,28,6],[29,4,29,6],[33,4,33,6],[36,0,36,3],[37,0,37,3],[38,0,38,3],[35,0,35,3],[35,4,35,6],[36,4,36,6],[37,4,37,6],[40,0,40,3],[41,0,41,3],[43,0,43,3],[42,0,42,3],[40,4,40,6],[41,4,41,6],[42,4,42,6],[43,4,43,6],[54,0,54,3],[54,4,54,6],[56,0,56,3],[18,0,18,3],[18,4,18,6],[19,0,19,3],[20,0,20,3],[19,4,19,6],[20,4,20,6],[22,0,22,3],[22,4,22,6],[21,0,21,3],[24,0,24,3],[25,0,25,3],[28,0,28,3],[29,0,29,3],[33,0,33,3],[26,0,26,3],[27,0,27,3],[13,4,13,6],[14,4,14,6],[15,4,15,6],[26,4,26,6],[30,0,30,3],[30,4,30,6],[31,0,31,3],[31,4,31,6],[32,0,32,3],[32,4,32,6],[16,0,16,3],[17,0,17,3],[17,4,17,6],[21,4,21,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[14,0,14,3],[15,0,15,3],[12,4,12,6],[16,4,16,6],[0,0,0,11],[0,12,0,17],[1,0,1,12],[2,0,2,12],[3,0,3,17],[5,0,5,1],[5,2,5,7],[5,8,5,10],[5,11,5,15],[9,0,9,7],[9,8,9,17],[48,0,48,3],[48,4,48,6],[49,0,49,3],[4,0,4,1],[4,2,4,10],[4,11,4,13],[4,14,4,17],[6,0,6,1],[6,2,6,7],[6,8,6,10],[6,11,6,12],[6,13,6,14],[6,15,6,17],[7,0,7,4],[7,5,7,17],[8,0,8,2],[8,3,8,7],[8,8,8,12],[8,13,8,17],[27,4,27,6],[11,0,11,3],[11,4,11,6],[12,0,12,3],[13,0,13,3],[49,4,49,6],[57,0,57,3],[57,4,57,6],[55,0,55,3],[55,4,55,6],[39,0,39,3],[38,4,38,6],[39,4,39,6],[44,0,44,3],[44,4,44,6],[45,0,45,3],[45,4,45,6],[46,0,46,3],[46,4,46,6],[47,0,47,3],[47,4,47,6],[50,0,50,3],[50,4,50,6],[51,0,51,3],[51,4,51,6],[52,0,52,3],[52,4,52,6],[53,0,53,3],[53,4,53,6]]}
["Florida Department of Transportation",null,null,null,null,null,null,null,null,null,null,null,"Intersection Control Evaluation Form 750-010-30"]
["Intersection Control Evaluation (ICE) Form"]
["Initial Inputs"]
["This spreadsheet was developed by FDOT to support the ICE Policy. This spreadsheet tool shall be used to document the findings of the ICE procedure. A selection must be made in the \"Intersection Type\" cell below for the appropriate Stage 1 form to fully populate."]
["Project Name",null,null,null,null,null,null,null,null,null,null,"FDOT Project #"]
["Submitted By",null,null,null,null,null,null,null,"Agency/Company",null,null,null,null,null,null,null,"Date"]
["Email",null,null,null,null,null,null,null,"FDOT District",null,null,null,null,"County"]
["Project Locality (City/Town/Village)"]
["Intersection Type",null,null,null,null,null,null,null,"FDOT Context Classification"]
["Project Type"]
[]
["At Grade Control Strategies",null,null,null,"To Be Considered?"]
["Two-Way Stop-Control"]
["All-Way Stop-Control"]
["Signalized Control"]
["Roundabout \n(1-lane)"]
["Roundabout \n(2-lane)"]
["Median \nU-Turn"]
["Median U-Turn (Partial)"]
["Restricted Crossing U-turn (Signalized)"]
["Restricted Crossing U-turn (Unsignalized)"]
["Jughandle (Forward Ramps)"]
["Jughandle (Reverse Ramps)"]
["Displaced Left-Turn (Partial)"]
["Continuous Green Tee"]
["Quadrant Roadway"]
["Thru-Cut (Signalized)"]
["Thru-Cut (Unsignalized)"]
["Bowtie"]
["Other 1 (Type)"]
["Other 2 (Type)"]
["Other 3 (Type)"]
["Other 4 (Type)"]
["Other 5 (Type)"]
[]
["Ramp Terminal Control Strategies",null,null,null,"To Be Considered?"]
["Diamond Signalized"]
["Diamond Signalized (Alt)"]
["Diverging Diamond"]
["Single-Point Diamond"]
["Diamond Stop Control"]
["Signalized Tight Diamond"]
["Roundabout \n(1-lane)"]
["Roundabout \n(2-lane)"]
["Half Diamond Signalized"]
["Half Diamond Stop Control"]
["Two Quadrant Partial Cloverleaf A Signalized"]
["Two Quadrant Partial Cloverleaf A Stop Control"]
["Four Quadrant Partial Cloverleaf A Signalized"]
["Four Quadrant Partial Cloverleaf A Stop Control"]
["Two Quadrant Partial Cloverleaf B Signalized"]
["Two Quadrant Partial Cloverleaf B Stop Control"]
["Four Quadrant Partial Cloverleaf B Signalized"]
["Four Quadrant Partial Cloverleaf B Stop Control"]
["Other 1 (Type)"]
["Other 2 (Type)"]
["Other 3 (Type)"]
["Other 4 (Type)"]
["Other 5 (Type)"]

{"sheet":"Stage 1","index":1,"n_rows":173,"n_cols":18,"rows_kept":173,"cut":false,"hidden":false,"merged":[[125,10,125,11],[126,10,126,11],[131,10,131,11],[134,10,134,11],[129,10,129,11],[137,12,137,17],[157,0,157,1],[158,0,158,1],[149,10,149,11],[150,10,150,11],[151,10,151,11],[152,10,152,11],[129,12,129,17],[147,2,147,3],[147,4,147,5],[147,10,147,11],[147,12,147,17],[127,0,127,1],[136,0,136,1],[136,2,136,3],[136,4,136,5],[148,0,148,1],[148,2,148,3],[128,0,128,1],[124,0,124,1],[124,2,124,3],[124,4,124,5],[124,10,124,11],[124,12,124,17],[148,4,148,5],[148,10,148,11],[148,12,148,17],[136,10,136,11],[134,4,134,5],[137,10,137,11],[131,0,131,1],[140,2,140,3],[140,4,140,5],[126,4,126,5],[127,10,127,11],[128,10,128,11],[145,12,145,17],[146,0,146,1],[146,2,146,3],[146,4,146,5],[146,10,146,11],[146,12,146,17],[147,0,147,1],[162,0,162,1],[162,2,162,3],[162,4,162,5],[145,0,145,1],[145,2,145,3],[145,4,145,5],[159,10,159,11],[159,12,159,17],[142,12,142,17],[143,0,143,1],[143,2,143,3],[143,4,143,5],[143,10,143,11],[143,12,143,17],[144,0,144,1],[144,2,144,3],[144,4,144,5],[144,10,144,11],[144,12,144,17],[142,0,142,1],[142,2,142,3],[142,4,142,5],[142,10,142,11],[145,10,145,11],[117,6,118,6],[117,7,118,7],[112,0,112,17],[114,0,114,17],[115,0,115,17],[141,0,141,1],[141,2,141,3],[141,4,141,5],[141,10,141,11],[141,12,141,17],[132,8,132,9],[134,12,134,17],[136,12,136,17],[140,10,140,11],[140,0,140,1],[130,0,130,1],[134,2,134,3],[132,4,132,5],[132,10,132,11],[132,12,132,17],[127,2,127,3],[127,4,127,5],[133,0,133,1],[133,10,133,11],[65,13,65,16],[65,6,65,12],[135,0,135,1],[135,2,135,3],[135,4,135,5],[135,10,135,11],[135,12,135,17],[66,13,66,16],[66,6,66,12],[128,2,128,7],[130,2,130,3],[130,4,130,5],[133,4,133,5],[133,12,133,17],[133,2,133,3],[125,0,125,1],[125,2,125,3],[125,4,125,5],[126,12,126,17],[126,0,126,1],[130,12,130,17],[131,12,131,17],[130,10,130,11],[132,2,132,3],[163,0,163,1],[163,2,163,3],[163,4,163,5],[132,0,132,1],[134,0,134,1],[137,0,137,1],[137,2,137,3],[137,4,137,5],[129,0,129,1],[129,2,129,7],[131,2,131,3],[131,4,131,5],[138,0,138,1],[138,2,138,3],[138,4,138,5],[159,0,159,1],[159,2,159,3],[149,4,149,5],[150,4,150,5],[151,4,151,5],[152,4,152,5],[153,4,153,5],[154,4,154,5],[155,4,155,5],[171,9,171,15],[171,7,171,8],[166,0,166,17],[167,0,167,17],[172,0,172,1],[172,2,172,17],[169,2,169,6],[169,0,169,1],[169,7,169,8],[169,9,169,15],[171,0,171,1],[171,2,171,6],[18,6,18,12],[19,6,19,12],[38,6,38,12],[38,13,38,16],[39,6,39,12],[39,13,39,16],[25,12,25,13],[25,14,25,15],[24,14,24,15],[29,12,29,15],[26,12,26,15],[26,16,26,17],[24,12,24,13],[44,4,44,7],[44,8,44,10],[27,16,28,17],[30,14,30,15],[38,0,38,5],[39,0,39,5],[126,2,126,3],[2,0,2,12],[4,0,4,1],[5,0,5,1],[21,8,21,10],[22,1,22,3],[14,0,14,17],[15,0,15,1],[15,2,15,3],[15,4,15,5],[16,0,16,2],[3,0,3,17],[7,0,7,4],[10,0,10,4],[22,4,22,7],[20,16,21,17],[22,16,22,17],[18,13,18,16],[11,5,11,17],[12,5,12,17],[10,5,10,17],[17,11,17,17],[17,2,17,7],[11,0,11,4],[6,15,6,17],[25,1,25,3],[25,4,25,7],[21,1,21,3],[21,4,21,7],[20,8,20,11],[20,12,21,15],[22,8,22,10],[22,12,22,15],[23,1,23,3],[23,4,23,7],[23,8,23,10],[23,12,23,13],[23,14,23,15],[24,1,24,3],[24,4,24,7],[24,8,24,10],[19,13,19,16],[20,0,26,0],[44,12,44,13],[44,14,44,15],[36,13,36,16],[37,0,37,1],[37,2,37,7],[37,8,37,10],[37,11,37,17],[40,0,46,0],[40,1,40,3],[40,4,40,7],[40,8,40,11],[40,12,41,15],[46,16,46,17],[45,1,45,3],[45,4,45,7],[45,8,45,10],[45,12,45,13],[46,4,46,7],[46,8,46,10],[42,1,42,3],[43,14,43,15],[36,8,36,10],[36,11,36,12],[43,8,43,10],[43,12,43,13],[40,16,41,17],[41,1,41,3],[41,4,41,7],[41,8,41,10],[29,16,29,17],[34,0,34,17],[42,4,42,7],[42,8,42,10],[42,12,42,15],[33,1,33,3],[33,4,33,7],[33,8,33,10],[35,4,35,5],[35,6,35,13],[27,0,33,0],[42,16,42,17],[43,1,43,3],[43,4,43,7],[30,8,30,10],[30,12,30,13],[30,1,30,3],[30,4,30,7],[47,4,47,7],[47,8,47,11],[47,12,48,15],[51,1,51,3],[51,4,51,7],[51,8,51,10],[51,12,51,13],[51,14,51,15],[52,1,52,3],[52,4,52,7],[52,8,52,10],[52,12,52,13],[52,14,52,15],[48,1,48,3],[48,4,48,7],[48,8,48,10],[49,12,49,15],[63,8,63,10],[63,11,63,12],[63,13,63,16],[63,4,63,7],[63,0,63,3],[53,1,53,3],[53,4,53,7],[53,8,53,10],[58,12,58,13],[54,12,55,15],[55,1,55,3],[55,4,55,7],[56,1,56,3],[56,4,56,7],[53,12,53,15],[53,16,53,17],[47,0,53,0],[60,1,60,3],[60,4,60,7],[60,8,60,10],[58,1,58,3],[61,0,61,17],[62,0,62,1],[62,2,62,3],[64,0,64,1],[64,2,64,7],[60,12,60,15],[60,16,60,17],[54,0,60,0],[54,16,55,17],[55,8,55,10],[110,0,110,17],[111,0,111,17],[54,1,54,3],[54,4,54,7],[54,8,54,11],[58,14,58,15],[59,12,59,13],[59,14,59,15],[56,12,56,15],[57,1,57,3],[57,4,57,7],[57,8,57,10],[57,12,57,13],[57,14,57,15],[59,1,59,3],[59,4,59,7],[59,8,59,10],[123,0,123,1],[123,2,123,3],[123,4,123,5],[123,12,123,17],[116,2,116,7],[116,0,118,1],[119,0,119,1],[120,0,120,1],[121,0,121,1],[122,0,122,1],[116,12,118,17],[119,12,119,17],[119,2,119,3],[118,4,118,5],[117,2,117,5],[119,10,119,11],[116,10,118,11],[118,2,118,3],[119,4,119,5],[116,8,116,9],[117,8,118,8],[120,10,120,11],[120,2,120,3],[120,4,120,5],[16,11,16,12],[16,8,16,10],[16,3,16,7],[35,14,35,16],[31,1,31,3],[31,4,31,7],[31,8,31,10],[31,12,31,13],[31,14,31,15],[32,1,32,3],[32,14,32,15],[32,4,32,7],[32,8,32,10],[32,12,32,13],[35,2,35,3],[20,1,20,3],[26,8,26,10],[28,1,28,3],[28,4,28,7],[28,8,28,10],[27,1,27,3],[27,4,27,7],[20,4,20,7],[25,8,25,10],[6,0,6,1],[6,13,6,14],[8,13,8,17],[8,0,8,2],[8,8,8,12],[8,3,8,7],[7,5,7,17],[6,11,6,12],[9,0,9,12],[9,13,9,17],[122,10,122,11],[123,10,123,11],[121,10,121,11],[127,12,127,17],[128,12,128,17],[125,12,125,17],[0,12,0,17],[0,0,0,11],[1,0,1,12],[120,12,120,17],[121,2,121,3],[121,4,121,5],[121,12,121,17],[122,2,122,3],[122,4,122,5],[122,12,122,17],[5,11,5,15],[12,0,12,4],[46,12,46,15],[36,0,36,2],[36,3,36,7],[33,12,33,15],[33,16,33,17],[35,0,35,1],[64,8,64,10],[64,11,64,17],[5,8,5,10],[5,2,5,7],[4,11,4,13],[4,14,4,17],[4,2,4,10],[6,2,6,7],[27,8,27,11],[27,12,28,15],[29,1,29,3],[29,4,29,7],[29,8,29,10],[15,15,15,16],[15,6,15,14],[17,0,17,1],[16,13,16,16],[17,8,17,10],[19,0,19,5],[18,0,18,5],[26,1,26,3],[26,4,26,7],[44,1,44,3],[6,8,6,10],[62,4,62,5],[62,6,62,14],[49,16,49,17],[50,1,50,3],[50,4,50,7],[50,8,50,10],[50,12,50,13],[50,14,50,15],[49,1,49,3],[49,4,49,7],[49,8,49,10],[62,15,62,16],[56,8,56,10],[56,16,56,17],[45,14,45,15],[46,1,46,3],[58,4,58,7],[58,8,58,10],[47,16,48,17],[47,1,47,3],[65,0,65,5],[66,0,66,5],[67,0,73,0],[67,1,67,3],[67,4,67,7],[67,8,67,11],[67,12,68,15],[67,16,68,17],[68,1,68,3],[68,4,68,7],[68,8,68,10],[69,1,69,3],[69,4,69,7],[69,8,69,10],[69,12,69,15],[69,16,69,17],[70,1,70,3],[70,4,70,7],[70,8,70,10],[70,12,70,13],[70,14,70,15],[71,1,71,3],[71,4,71,7],[71,8,71,10],[71,12,71,13],[71,14,71,15],[72,1,72,3],[72,4,72,7],[72,8,72,10],[72,12,72,13],[72,14,72,15],[73,1,73,3],[73,4,73,7],[73,8,73,10],[73,12,73,15],[73,16,73,17],[74,0,80,0],[74,1,74,3],[74,4,74,7],[74,8,74,11],[74,12,75,15],[74,16,75,17],[75,1,75,3],[75,4,75,7],[75,8,75,10],[76,1,76,3],[76,4,76,7],[76,8,76,10],[76,12,76,15],[76,16,76,17],[77,1,77,3],[77,4,77,7],[77,8,77,10],[77,12,77,13],[77,14,77,15],[78,1,78,3],[78,4,78,7],[78,8,78,10],[78,12,78,13],[78,14,78,15],[79,1,79,3],[79,4,79,7],[79,8,79,10],[79,12,79,13],[79,14,79,15],[80,1,80,3],[80,4,80,7],[80,8,80,10],[80,12,80,15],[80,16,80,17],[88,0,88,17],[89,0,89,1],[89,2,89,3],[89,4,89,5],[89,6,89,13],[89,14,89,16],[83,1,83,3],[83,4,83,7],[83,8,83,10],[83,12,83,15],[83,16,83,17],[84,1,84,3],[84,4,84,7],[84,8,84,10],[86,12,86,13],[86,14,86,15],[87,1,87,3],[87,4,87,7],[87,8,87,10],[87,16,87,17],[90,11,90,12],[90,13,90,16],[90,4,90,7],[90,0,90,3],[84,12,84,13],[84,14,84,15],[85,1,85,3],[85,4,85,7],[85,8,85,10],[85,12,85,13],[85,14,85,15],[86,1,86,3],[86,4,86,7],[86,8,86,10],[81,0,87,0],[81,1,81,3],[81,4,81,7],[81,8,81,11],[81,12,82,15],[81,16,82,17],[82,1,82,3],[82,4,82,7],[82,8,82,10],[87,12,87,15],[100,12,100,15],[101,0,107,0],[101,1,101,3],[101,4,101,7],[101,8,101,11],[101,12,102,15],[102,1,102,3],[102,4,102,7],[102,8,102,10],[103,8,103,10],[104,14,104,15],[105,8,105,10],[105,12,105,13],[103,1,107,7],[90,8,90,10],[105,14,105,15],[106,8,106,10],[106,12,106,13],[106,14,106,15],[107,8,107,10],[104,12,104,13],[101,16,102,17],[91,0,91,1],[91,2,91,7],[91,8,91,10],[91,11,91,17],[92,0,92,5],[93,0,93,5],[93,6,93,12],[92,13,92,16],[92,6,92,12],[93,13,93,16],[94,0,100,0],[94,1,94,3],[95,1,95,3],[98,14,98,15],[96,1,100,7],[94,4,94,7],[117,9,118,9],[95,4,95,7],[94,8,94,11],[94,12,95,15],[94,16,95,17],[95,8,95,10],[96,8,96,10],[96,12,96,15],[96,16,96,17],[97,8,97,10],[97,12,97,13],[97,14,97,15],[98,8,98,10],[98,12,98,13],[107,12,107,15],[100,16,100,17],[99,8,99,10],[99,12,99,13],[99,14,99,15],[100,8,100,10],[103,12,103,15],[103,16,103,17],[104,8,104,10],[107,16,107,17],[138,10,138,11],[138,12,138,17],[162,10,162,11],[162,12,162,17],[139,0,139,1],[139,2,139,3],[139,4,139,5],[139,10,139,11],[139,12,139,17],[160,0,160,1],[160,2,160,3],[160,4,160,5],[160,10,160,11],[160,12,160,17],[140,12,140,17],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[153,0,153,1],[154,0,154,1],[155,0,155,1],[156,0,156,1],[159,4,159,5],[156,4,156,5],[149,2,149,3],[150,2,150,3],[151,2,151,3],[152,2,152,3],[153,2,153,3],[154,2,154,3],[155,2,155,3],[156,2,156,3],[149,12,149,17],[150,12,150,17],[151,12,151,17],[152,12,152,17],[153,12,153,17],[154,12,154,17],[155,12,155,17],[156,12,156,17],[157,12,157,17],[164,0,164,2],[164,3,164,17],[170,0,170,1],[170,2,170,17],[168,9,168,16],[168,0,168,7],[158,12,158,17],[153,10,153,11],[154,10,154,11],[155,10,155,11],[156,10,156,11],[157,10,157,11],[158,10,158,11],[158,2,158,3],[157,2,157,3],[157,4,157,5],[158,4,158,5],[163,10,163,11],[163,12,163,17],[161,0,161,1],[161,2,161,3],[161,4,161,5],[161,10,161,11],[161,12,161,17]]}
["Florida Department of Transportation",null,null,null,null,null,null,null,null,null,null,null,"Intersection Control Evaluation Form 750-010-30"]
["Intersection Control Evaluation (ICE) Form"]
["Stage 1: Screening"]
["To fulfill the requirements of Stage 1 (Screening) of FDOT's ICE procedures, complete the following form and append all supporting documentation. Completed forms are to be submitted to the District Traffic Operations Engineer (DTOE) and District Design Engineer (DDE) for the project's approval."]
["Project Name",null,{"$f":"IF(Input!C5=\"\",\"\",Input!C5)","v":""},null,null,null,null,null,null,null,null,"FDOT Project #",null,null,{"$f":"IF(Input!O5=\"\",\"\",Input!O5)","v":""}]
["Submitted By",null,{"$f":"IF(Input!C6=\"\",\"\",Input!C6)","v":""},null,null,null,null,null,"Agency/Company",null,null,{"$f":"IF(Input!L6=\"\",\"\",Input!L6)","v":""},null,null,null,null,"Date",{"$f":"IF(Input!R6=\"\",\"\",Input!R6)","v":""}]
["Email",null,{"$f":"IF(Input!C7=\"\",\"\",Input!C7)","v":""},null,null,null,null,null,"FDOT District",null,null,{"$f":"IF(Input!L7=\"\",\"\",Input!L7)","v":""},null,"County",null,{"$f":"IF(Input!P7=\"\",\"\",Input!P7)","v":""}]
["Project Locality (City/Town/Village)",null,null,null,null,{"$f":"IF(Input!F8=\"\",\"\",Input!F8)","v":""}]
["Intersection Type",null,null,{"$f":"IF(Input!D9=\"\",\"\",Input!D9)","v":""},null,null,null,null,"FDOT Context Classification",null,null,null,null,{"$f":"IF(Input!N9=\"\",\"\",Input!N9)","v":""}]
["Project Type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!I10=\"\",\"\",Input!I10)","v":""}]
["Project Purpose                                 (What is the catalyst for this project and why is it being undertaken?)"]
["Project Setting Description                                (Describe the area surrounding the intersection)"]
["Multimodal Context                                (Describe the pedestrian, bicycle, and transit activity in the area and the potential for activity based on surrounding land uses and development patterns)"]
[]
["Major Street Information"]
["Roadway ID",null,null,null,"Route Name(s)",null,null,null,null,null,null,null,null,null,null,"Milepoint"]
["Existing Control Type",null,null,null,null,null,null,null,"Existing AADT",null,null,null,null,"Design Year AADT"]
["Design Vehicle",null,null,null,null,null,null,null,"Control Vehicle"]
["Primary Functional Classification",null,null,null,null,null,null,null,null,null,null,null,null,"Design Speed (mph)"]
["Secondary Functional Classification (if app.)",null,null,null,null,null,null,null,null,null,null,null,null,"Target Speed (mph) [if app.]"]
["Approach #1","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through"]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #2","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Minor Street Information"]
["Roadway ID",null,null,null,"Route Name(s)",null,null,null,null,null,null,null,null,null,"Milepoint (if app.)"]
["Existing Control Type",null,null,{"$f":"IF(D17=\"\",\"\",D17)","v":""},null,null,null,null,"Existing AADT",null,null,null,null,"Design Year AADT"]
["Design Vehicle",null,null,null,null,null,null,null,"Control Vehicle"]
["Primary Functional Classification",null,null,null,null,null,null,null,null,null,null,null,null,"Design Speed (mph)"]
["Secondary Functional Classification (if app.)",null,null,null,null,null,null,null,null,null,null,null,null,"Target Speed (mph) [if app.]"]
["Approach #1","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #2","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #3","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Cross-Street Information"]
["Roadway ID",null,null,null,"Route Name(s)",null,null,null,null,null,null,null,null,null,null,"Milepoint"]
["Existing Ramp Control Type",null,null,null,null,null,null,null,"Existing AADT",null,null,null,null,"Design Year AADT"]
["Design Vehicle",null,null,null,null,null,null,null,"Control Vehicle"]
["Primary Functional Classification",null,null,null,null,null,null,null,null,null,null,null,null,"Design Speed (mph)"]
["Secondary Functional Classification (if app.)",null,null,null,null,null,null,null,null,null,null,null,null,"Target Speed (mph) [if app.]"]
["Approach #1","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through"]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #2","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #3","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Sidewalks along:",null,null,null,null,null,null,"Left-Turn"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,"On-Street Bike Facilities?",null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,"Multi-Use Path?",null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,"Scheduled Bus Service?",null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,"Bus Stop on Approach?",null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Exit Ramp Information"]
["Roadway ID",null,null,null,"Route Name(s)",null,null,null,null,null,null,null,null,null,"Milepoint (if app.)"]
["Existing Ramp Control Type",null,null,null,{"$f":"IF(E64=\"\",\"\",E64)","v":""},null,null,null,"Existing AADT",null,null,null,null,"Design Year AADT"]
["Design Vehicle",null,null,null,null,null,null,null,"Control Vehicle"]
["Primary Functional Classification",null,null,null,null,null,null,null,null,null,null,null,null,"Design Speed (mph)"]
["Secondary Functional Classification (if app.)",null,null,null,null,null,null,null,null,null,null,null,null,"Target Speed (mph) [if app.]"]
["Approach #1","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Turn"]
[null,null,null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$70=\"\",\"\",$M$70)","v":""},null,null,null,{"$f":"IF($Q$70=\"\",\"\",$Q$70)","v":""}]
[null,null,null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,null,null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,null,null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,null,null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
["Approach #2","Direction",null,null,null,null,null,null,"Number of Lanes",null,null,null,"Study Period #1 Traffic Volumes",null,null,null,"Study Period #2 Traffic Volumes"]
[null,"Crosswalk on Approach?",null,null,null,null,null,null,"Left-Turn"]
[null,null,null,null,null,null,null,null,"Left-Through",null,null,null,{"$f":"IF($M$23=\"\",\"\",$M$23)","v":""},null,null,null,{"$f":"IF($Q$23=\"\",\"\",$Q$23)","v":""}]
[null,null,null,null,null,null,null,null,"Through",null,null,null,"Left",null,null,null,"Left"]
[null,null,null,null,null,null,null,null,"Left-Through-Right",null,null,null,"Through",null,null,null,"Through"]
[null,null,null,null,null,null,null,null,"Through-Right",null,null,null,"Right",null,null,null,"Right"]
[null,null,null,null,null,null,null,null,"Right-Turn",null,null,null,"Daily Truck %"]
[]
[]
["Crash History (Existing Intersections Only)"]
["Append the most recent five-years of crash data for the intersection from the Signal Four (S4) Analytics. If the crash data evidences any issues relating to safety performance, discuss briefly here:"]
[]
[]
[{"$f":"IF(D9=\"At-Grade Intersection\", \"Control Strategy Evaluation\", \"Ramp Terminal Control Strategy Evaluation\")","v":"Ramp Terminal Control Strategy Evaluation"}]
["Provide a brief justification as to why each of the following control strategies should be advanced or not. Justification should consider potential environmental impacts."]
[{"$f":"IF(D9=\"At-Grade Intersection\", \"Control Strategy\", \"Ramp Terminal Control Strategy\")","v":"Ramp Terminal Control Strategy"},null,"CAP-X Outputs",null,null,null,null,null,"SPICE Outputs",null,"Strategy to be Advanced?",null,"Justification"]
[null,null,"V/C Ratio",null,null,null,"Ped Accom. Score","Bike Accom. Score","Crash Prediction Rank","SSI Rank"]
[null,null,{"$f":"IF(D9 = \"At-Grade Intersection\", IF($M$23=\"\",\"\",$M$23),IF(M70=\"\",\"\",M70))","v":""},null,{"$f":"IF(D9 = \"At-Grade Intersection\", IF($Q$23=\"\",\"\",$Q$23),IF(Q70=\"\",\"\",Q70))","v":""}]
[{"$f":"Input!A13","v":"Two-Way Stop-Control"}]
[{"$f":"Input!A14","v":"All-Way Stop-Control"}]
[{"$f":"Input!A15","v":"Signalized Control"}]
[{"$f":"Input!A16","v":"Roundabout \n(1-lane)"}]
[{"$f":"Input!A17","v":"Roundabout \n(2-lane)"}]
[{"$f":"Input!A18","v":"Median \nU-Turn"}]
[{"$f":"Input!A19","v":"Median U-Turn (Partial)"}]
[{"$f":"Input!A20","v":"Restricted Crossing U-turn (Signalized)"}]
[{"$f":"Input!A21","v":"Restricted Crossing U-turn (Unsignalized)"}]
[{"$f":"Input!A22","v":"Jughandle (Forward Ramps)"}]
[{"$f":"Input!A23","v":"Jughandle (Reverse Ramps)"}]
[{"$f":"Input!A24","v":"Displaced Left-Turn (Partial)"}]
[{"$f":"Input!A25","v":"Continuous Green Tee"}]
[{"$f":"Input!A26","v":"Quadrant Roadway"}]
[{"$f":"Input!A27","v":"Thru-Cut (Signalized)"}]
[{"$f":"Input!A28","v":"Thru-Cut (Unsignalized)"}]
[{"$f":"Input!A29","v":"Bowtie"}]
[{"$f":"Input!A30","v":"Other 1 (Type)"}]
[{"$f":"Input!A31","v":"Other 2 (Type)"}]
[{"$f":"Input!A32","v":"Other 3 (Type)"}]
[{"$f":"Input!A33","v":"Other 4 (Type)"}]
[{"$f":"Input!A34","v":"Other 5 (Type)"}]
[{"$f":"Input!A37","v":"Diamond Signalized"}]
[{"$f":"Input!A38","v":"Diamond Signalized (Alt)"}]
[{"$f":"Input!A39","v":"Diverging Diamond"}]
[{"$f":"Input!A40","v":"Single-Point Diamond"}]
[{"$f":"Input!A41","v":"Diamond Stop Control"}]
[{"$f":"Input!A42","v":"Signalized Tight Diamond"}]
[{"$f":"Input!A43","v":"Roundabout \n(1-lane)"}]
[{"$f":"Input!A44","v":"Roundabout \n(2-lane)"}]
[{"$f":"Input!A45","v":"Half Diamond Signalized"}]
[{"$f":"Input!A46","v":"Half Diamond Stop Control"}]
[{"$f":"Input!A47","v":"Two Quadrant Partial Cloverleaf A Signalized"}]
[{"$f":"Input!A48","v":"Two Quadrant Partial Cloverleaf A Stop Control"}]
[{"$f":"Input!A49","v":"Four Quadrant Partial Cloverleaf A Signalized"}]
[{"$f":"Input!A50","v":"Four Quadrant Partial Cloverleaf A Stop Control"}]
[{"$f":"Input!A51","v":"Two Quadrant Partial Cloverleaf B Signalized"}]
[{"$f":"Input!A52","v":"Two Quadrant Partial Cloverleaf B Stop Control"}]
[{"$f":"Input!A53","v":"Four Quadrant Partial Cloverleaf B Signalized"}]
[{"$f":"Input!A54","v":"Four Quadrant Partial Cloverleaf B Stop Control"}]
[{"$f":"Input!A55","v":"Other 1 (Type)"}]
[{"$f":"Input!A56","v":"Other 2 (Type)"}]
[{"$f":"Input!A57","v":"Other 3 (Type)"}]
[{"$f":"Input!A58","v":"Other 4 (Type)"}]
[{"$f":"Input!A59","v":"Other 5 (Type)"}]
["Recommendation"]
[]
["Resolution"]
["To be filled out by FDOT District Traffic Operations Engineer and District Design Engineer"]
["Accept Recommendation",null,null,null,null,null,null,null,false,"Reject Recommendation",null,null,null,null,null,null,null,false]
["DTOE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,"Date"]
["DTOE Comments"]
["DDE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,"Date"]
["DDE Comments"]

{"sheet":"Stage 2","index":2,"n_rows":127,"n_cols":24,"rows_kept":127,"cut":false,"hidden":false,"merged":[[46,0,46,11],[65,15,65,16],[66,15,66,16],[65,4,65,12],[66,4,66,12],[67,4,67,12],[68,4,68,12],[63,13,63,14],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14],[67,15,67,16],[68,15,68,16],[65,18,65,20],[66,18,66,20],[67,18,67,20],[68,18,68,20],[63,21,63,22],[64,21,64,22],[65,21,65,22],[66,21,66,22],[67,21,67,22],[68,21,68,22],[62,13,62,14],[62,18,62,20],[62,21,62,22],[61,13,61,17],[61,18,61,23],[61,4,62,12],[63,4,63,12],[64,4,64,12],[63,18,63,20],[64,18,64,20],[62,15,62,16],[63,15,63,16],[64,15,64,16],[47,5,47,7],[47,17,47,20],[47,14,47,16],[47,11,47,13],[47,8,47,10],[48,14,48,16],[49,14,49,16],[50,14,50,16],[48,17,48,20],[49,17,49,20],[50,17,50,20],[48,11,48,13],[50,11,50,13],[49,11,49,13],[48,8,48,10],[48,5,48,7],[49,5,49,7],[50,5,50,7],[49,8,49,10],[50,8,50,10],[52,8,52,10],[53,5,53,7],[53,8,53,10],[55,8,55,10],[56,8,56,10],[52,14,52,16],[53,14,53,16],[51,11,51,13],[51,17,51,20],[52,11,52,13],[52,17,52,20],[54,11,54,13],[54,14,54,16],[54,17,54,20],[55,5,55,7],[56,5,56,7],[72,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[77,0,77,3],[78,0,78,3],[79,0,79,3],[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,4,77,7],[78,4,78,7],[79,4,79,7],[72,4,73,7],[76,12,76,14],[76,15,76,16],[76,17,76,19],[83,7,83,10],[78,15,78,16],[78,17,78,19],[78,20,78,23],[79,12,79,14],[79,15,79,16],[79,17,79,19],[77,20,77,23],[77,12,77,14],[77,15,77,16],[77,17,77,19],[81,0,81,23],[73,20,73,23],[73,17,73,19],[73,15,73,16],[73,12,73,14],[74,12,74,14],[74,15,74,16],[74,17,74,19],[74,20,74,23],[75,12,75,14],[75,15,75,16],[75,17,75,19],[75,20,75,23],[86,4,86,9],[78,12,78,14],[84,7,84,10],[83,11,83,23],[84,11,84,23],[86,0,86,3],[115,7,115,23],[116,7,116,23],[117,7,117,23],[112,0,112,3],[90,0,90,3],[91,0,91,3],[92,0,92,3],[87,4,87,9],[97,0,97,3],[97,4,97,23],[90,4,90,9],[90,10,90,16],[90,17,90,23],[91,4,91,9],[91,10,91,16],[91,17,91,23],[92,4,92,9],[92,10,92,16],[123,22,123,23],[123,7,123,9],[123,10,123,20],[125,7,125,9],[125,10,125,20],[125,22,125,23],[115,4,115,6],[116,4,116,6],[117,4,117,6],[120,0,120,23],[123,2,123,6],[121,0,121,23],[123,0,123,1],[115,0,115,3],[116,0,116,3],[117,0,117,3],[125,0,125,1],[125,2,125,6],[122,22,122,23],[122,9,122,10],[122,11,122,21],[122,0,122,8],[124,0,124,1],[124,2,124,23],[92,17,92,23],[88,4,88,9],[88,10,88,16],[88,17,88,23],[89,4,89,9],[89,10,89,16],[89,17,89,23],[94,0,94,23],[93,0,93,23],[88,0,88,3],[22,14,22,16],[27,14,27,16],[24,13,24,16],[25,12,25,13],[26,12,26,13],[27,12,27,13],[54,5,54,7],[8,0,8,5],[9,0,9,5],[23,0,23,1],[23,2,23,3],[13,11,13,13],[13,2,13,10],[16,14,16,16],[13,14,13,23],[8,15,8,23],[18,8,18,10],[21,18,21,20],[22,18,22,20],[17,21,17,23],[18,21,18,23],[20,21,20,23],[21,21,21,23],[22,21,22,23],[18,6,18,7],[18,0,18,4],[17,14,17,16],[18,14,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[99,0,99,3],[100,0,100,3],[98,4,98,23],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,4,23,23],[24,0,25,4],[24,5,24,6],[24,7,24,10],[46,21,46,23],[48,0,50,2],[51,0,53,2],[48,3,48,4],[49,3,49,4],[27,0,27,4],[28,0,28,4],[26,0,26,4],[26,6,26,7],[26,8,26,10],[26,18,26,20],[26,21,26,23],[45,0,45,23],[50,3,50,4],[51,3,51,4],[52,3,52,4],[47,21,47,23],[48,21,48,23],[49,21,49,23],[50,21,50,23],[51,21,51,23],[52,21,52,23],[53,21,53,23],[53,11,53,13],[46,12,46,20],[55,11,55,13],[51,14,51,16],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[59,0,59,2],[58,3,58,4],[59,3,59,4],[47,0,47,4],[53,17,53,20],[56,11,56,13],[57,8,57,10],[58,8,58,10],[54,8,54,10],[55,17,55,20],[56,17,56,20],[55,14,55,16],[56,14,56,16],[51,5,51,7],[51,8,51,10],[52,5,52,7],[109,0,109,23],[110,0,110,23],[111,0,111,3],[111,4,111,6],[111,7,111,23],[112,4,112,6],[113,4,113,6],[114,4,114,6],[113,0,113,3],[114,0,114,3],[112,7,112,23],[113,7,113,23],[114,7,114,23],[105,0,105,23],[106,0,106,23],[107,0,107,23],[101,0,101,3],[102,0,102,3],[101,4,101,23],[102,4,102,23],[96,0,96,23],[95,0,95,23],[98,0,98,3],[15,11,15,12],[40,0,43,2],[29,0,29,4],[30,0,30,4],[40,3,43,23],[30,6,30,7],[30,8,30,10],[30,18,30,20],[30,21,30,23],[31,6,31,7],[31,8,31,10],[31,18,31,20],[31,21,31,23],[31,0,31,4],[29,14,29,16],[30,14,30,16],[31,14,31,16],[15,17,15,18],[15,19,15,23],[15,13,15,16],[24,17,24,18],[24,19,24,23],[25,14,25,16],[26,14,26,16],[22,8,22,10],[4,12,4,17],[9,15,9,23],[28,6,28,7],[28,8,28,10],[28,18,28,20],[28,21,28,23],[29,6,29,7],[29,8,29,10],[29,18,29,20],[29,21,29,23],[27,21,27,23],[27,6,27,7],[27,8,27,10],[27,18,27,20],[28,14,28,16],[5,7,5,10],[5,11,5,16],[5,18,5,23],[5,2,5,6],[8,6,8,14],[9,6,9,14],[24,11,24,12],[16,12,16,13],[16,21,16,23],[20,0,20,4],[21,0,21,4],[22,0,22,4],[25,6,25,7],[25,18,25,20],[25,21,25,23],[16,18,16,20],[17,18,17,20],[18,18,18,20],[19,18,19,20],[20,18,20,20],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[19,0,19,4],[25,8,25,10],[17,8,17,10],[17,0,17,4],[19,21,19,23],[19,8,19,10],[20,8,20,10],[21,8,21,10],[0,0,0,10],[1,0,1,17],[2,0,2,17],[3,0,3,23],[12,0,12,23],[16,8,16,10],[16,6,16,7],[17,6,17,7],[15,5,15,6],[15,7,15,10],[11,0,11,23],[14,0,14,1],[14,2,14,3],[15,0,16,4],[14,4,14,23],[0,14,0,23],[4,0,4,1],[5,0,5,1],[7,0,7,23],[13,0,13,1],[4,18,4,20],[4,21,4,23],[4,2,4,8],[4,9,4,11],[84,0,84,6],[83,0,83,6],[71,0,71,23],[70,0,70,23],[99,4,99,23],[100,4,100,23],[85,0,85,23],[82,0,82,23],[59,21,59,23],[59,5,59,7],[59,8,59,10],[59,11,59,13],[59,14,59,16],[59,17,59,20],[89,0,89,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[61,0,62,3],[60,0,60,23],[63,0,63,3],[64,0,64,3],[65,0,65,3],[87,0,87,3],[54,0,56,2],[57,0,57,2],[58,0,58,2],[54,21,54,23],[55,21,55,23],[56,21,56,23],[57,5,57,7],[58,5,58,7],[57,14,57,16],[58,14,58,16],[57,17,57,20],[58,17,58,20],[38,0,38,8],[38,10,38,12],[38,13,38,18],[39,0,39,8],[39,10,39,12],[39,13,39,18],[87,10,87,16],[87,17,87,23],[86,10,86,16],[86,17,86,23],[79,20,79,23],[72,8,73,11],[74,8,74,11],[75,8,75,11],[76,8,76,11],[77,8,77,11],[78,8,78,11],[79,8,79,11],[72,12,72,23],[76,20,76,23],[57,21,57,23],[58,21,58,23],[57,11,57,13],[58,11,58,13],[126,0,126,1],[126,2,126,23],[6,0,6,17],[6,18,6,23],[118,0,118,3],[118,4,118,23],[32,0,33,8],[32,9,32,12],[32,13,32,18],[32,19,39,23],[33,10,33,12],[33,13,33,18],[34,0,34,8],[34,10,34,12],[34,13,34,18],[35,0,35,8],[35,10,35,12],[35,13,35,18],[36,0,36,8],[36,10,36,12],[36,13,36,18],[37,0,37,8],[37,10,37,12],[37,13,37,18]]}
["Florida Department of Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Intersection Control Evaluation Form 750-010-30"]
["Intersection Control Evaluation (ICE) Form"]
["Stage 2: Initial Control Strategy Assessment"]
["To fulfill the requirements of Stage 2 (Intersection Control Strategy) of FDOT's ICE procedures, complete the following form and append all supporting documentation. A selection must be made in the \"Project Funding Source\" cell below for the Stage 2 form to fully populate. Completed forms are to be submitted to the District Traffic Operations Engineer (DTOE) and District Design Engineer (DDE) for the project's approval. "]
["Project Name",null,{"$f":"IF('Stage 1'!C5=\"\",\"\",'Stage 1'!C5)","v":""},null,null,null,null,null,null,"FDOT Project #",null,null,{"$f":"IF('Stage 1'!O5=\"\",\"\",'Stage 1'!O5)","v":""},null,null,null,null,null,"Date"]
["Submitted By",null,{"$f":"IF('Stage 1'!C6=\"\",\"\",'Stage 1'!C6)","v":""},null,null,null,null,"Agency/Company",null,null,null,{"$f":"IF('Stage 1'!L6=\"\",\"\",'Stage 1'!L6)","v":""},null,null,null,null,null,"Email",{"$f":"IF('Stage 1'!C7=\"\",\"\",'Stage 1'!C7)","v":""}]
["Project Funding Source"]
["List all viable intersection control strategies identified in Stage 1 (Screening):"]
[{"$f":"List!V1","v":""},null,null,null,null,null,{"$f":"List!V2","v":""},null,null,null,null,null,null,null,null,{"$f":"List!V3","v":""}]
[{"$f":"List!V4","v":""},null,null,null,null,null,{"$f":"List!V5","v":""},null,null,null,null,null,null,null,null,{"$f":"List!V6","v":""}]
[]
["Operational Analyses"]
["Summarize the results of the peak hour analysis performed for each control strategy. Select analysis year based on guidance in the ICE procedures document. Refer to Exhibit 19-8 of the Highway Capacity Manual, 6th Edition (HCM6) to determine the appropriate LOS based on intersection delay (hover over this cell for Exhibit 19-8)."]
["Design Vehicle",null,{"$f":"IF('Stage 1'!D9=\"At-Grade Intersection\",IF('Stage 1'!C18=\"\",\"\",'Stage 1'!C18), IF('Stage 1'!C65=\"\",\"\",'Stage 1'!C65))","v":""},null,null,null,null,null,null,null,null,"Control Vehicle",null,null,{"$f":"IF('Stage 1'!D9=\"At-Grade Intersection\",IF('Stage 1'!L18=\"\",\"\",'Stage 1'!L18), IF('Stage 1'!L65=\"\",\"\",'Stage 1'!L65))","v":""}]
["Opening Year"]
["Control Strategy",null,null,null,null,"Peak Hour",null,null,null,null,null,"Peak Hour",null,null,null,null,null,"Peak Hour"]
[null,null,null,null,null,"LOS","Delay (sec.)",null,"All Queues Accommodated?",null,null,"LOS","Delay (sec.)",null,"All Queues Accommodated?",null,null,"LOS","Delay (sec.)",null,null,"All Queues Accommodated?"]
[{"$f":"IF($A$9=\"\",\"\",$A$9)","v":""}]
[{"$f":"IF($G$9=\"\",\"\",$G$9)","v":""}]
[{"$f":"IF($P$9=\"\",\"\",$P$9)","v":""}]
[{"$f":"IF($A$10=\"\",\"\",$A$10)","v":""}]
[{"$f":"IF($G$10=\"\",\"\",$G$10)","v":""}]
[{"$f":"IF($P$10=\"\",\"\",$P$10)","v":""}]
["Design Year"]
["Control Strategy",null,null,null,null,"Peak Hour",null,{"$f":"IF(H16=\"\",\"\",H16)","v":""},null,null,null,"Peak Hour",null,{"$f":"IF(N16=\"\",\"\",N16)","v":""},null,null,null,"Peak Hour",null,{"$f":"IF(T16=\"\",\"\",T16)","v":""}]
[null,null,null,null,null,"LOS","Delay (sec.)",null,"All Queues Accommodated?",null,null,"LOS","Delay (sec.)",null,"All Queues Accommodated?",null,null,"LOS","Delay (sec.)",null,null,"All Queues Accommodated?"]
[{"$f":"A18","v":""}]
[""]
[""]
[""]
[""]
[""]
["Control Strategy",null,null,null,null,null,null,null,null,"Critical Peak Hour"]
[null,null,null,null,null,null,null,null,null,"LOS","Delay (sec.)",null,null,"All Queues Accommodated?"]
[{"$f":"IF($A$9=\"\",\"\",$A$9)","v":""}]
[{"$f":"IF($G$9=\"\",\"\",$G$9)","v":""}]
[{"$f":"IF($P$9=\"\",\"\",$P$9)","v":""}]
[{"$f":"IF($A$10=\"\",\"\",$A$10)","v":""}]
[{"$f":"IF($G$10=\"\",\"\",$G$10)","v":""}]
[{"$f":"IF($P$10=\"\",\"\",$P$10)","v":""}]
["Provide any additional discussion necessary regarding the results of the operational analysis:"]
[]
[]
[]
[]
["Safety Performance"]
["Enter the most recent five (5) years of crash data from the S4 Analytics.",null,null,null,null,null,null,null,null,null,null,null,"Most recent year of crash data available"]
["Crash Type",null,null,null,null,{"$f":"IF($V$47=\"\",\"\",I48-1)","v":""},null,null,{"$f":"IF($V$47=\"\",\"\",L48-1)","v":""},null,null,{"$f":"IF($V$47=\"\",\"\",O48-1)","v":""},null,null,{"$f":"IF($V$47=\"\",\"\",R48-1)","v":""},null,null,{"$f":"IF($V$47=\"\",\"\",V47)","v":""},null,null,null,"Total"]
["Combined",null,null,"Total",null,{"$f":"IF(COUNTBLANK(F50:H51)=6,\"\",SUM(F50:H51))","v":""},null,null,{"$f":"IF(COUNTBLANK(I50:K51)=6,\"\",SUM(I50:K51))","v":""},null,null,{"$f":"IF(COUNTBLANK(L50:N51)=6,\"\",SUM(L50:N51))","v":""},null,null,{"$f":"IF(COUNTBLANK(O50:Q51)=6,\"\",SUM(O50:Q51))","v":""},null,null,{"$f":"IF(COUNTBLANK(R50:U51)=8,\"\",SUM(R50:U51))","v":""},null,null,null,{"$f":"IF(COUNTBLANK(F49:U49)=16,\"\",SUM(F49:U49))","v":""}]
[null,null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(F50:U50)=16,\"\",SUM(F50:U50))","v":""}]
[null,null,null,"PDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Single-Vehicle",null,null,"Total",null,{"$f":"IF(COUNTBLANK(F53:H54)=6,\"\",SUM(F53:H54))","v":""},null,null,{"$f":"IF(COUNTBLANK(I53:K54)=6,\"\",SUM(I53:K54))","v":""},null,null,{"$f":"IF(COUNTBLANK(L53:N54)=6,\"\",SUM(L53:N54))","v":""},null,null,{"$f":"IF(COUNTBLANK(O53:Q54)=6,\"\",SUM(O53:Q54))","v":""},null,null,{"$f":"IF(COUNTBLANK(R53:U54)=8,\"\",SUM(R53:U54))","v":""},null,null,null,""]
[null,null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"PDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Multi-Vehicle",null,null,"Total",null,{"$f":"IF(COUNTBLANK(F56:H57)=6,\"\",SUM(F56:H57))","v":""},null,null,{"$f":"IF(COUNTBLANK(I56:K57)=6,\"\",SUM(I56:K57))","v":""},null,null,{"$f":"IF(COUNTBLANK(L56:N57)=6,\"\",SUM(L56:N57))","v":""},null,null,{"$f":"IF(COUNTBLANK(O56:Q57)=6,\"\",SUM(O56:Q57))","v":""},null,null,{"$f":"IF(COUNTBLANK(R56:U57)=8,\"\",SUM(R56:U57))","v":""},null,null,null,""]
[null,null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,"PDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Vehicle-Pedestrian",null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Vehicle-Bicycle",null,null,"Fatal/Injury",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Total",null,null,"All",null,{"$f":"IF(COUNTBLANK(F49:H59)=33,\"\",SUM(F49,F52,F55,F58,F59))","v":""},null,null,{"$f":"IF(COUNTBLANK(I49:K59)=33,\"\",SUM(I49,I52,I55,I58,I59))","v":""},null,null,{"$f":"IF(COUNTBLANK(L49:N59)=33,\"\",SUM(L49,L52,L55,L58,L59))","v":""},null,null,{"$f":"IF(COUNTBLANK(O49:Q59)=33,\"\",SUM(O49,O52,O55,O58,O59))","v":""},null,null,{"$f":"IF(COUNTBLANK(R49:U59)=44,\"\",SUM(R49,R52,R55,R58,R59))","v":""},null,null,null,{"$f":"IF(COUNTBLANK(V49:X59)=33,\"\",SUM(V49,V52,V55,V58,V59))","v":""}]
["Apply the FDOT SPICE Tool to model anticipated safety performance of each control strategy. For intersection types not accommodated in the tool, manually apply crash modification factors detailed in the ICE procedures document or qualitatively describe anticipated safety impacts."]
["Control Strategy",null,null,null,"Anticipated Impact on Safety Performance",null,null,null,null,null,null,null,null,"Opening Year",null,null,null,null,"Design Year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted Total Crashes",null,"Predicted Fatal+Injury Crashes",null,"SSI Score","Predicted Total Crashes",null,null,"Predicted Fatal+Injury Crashes",null,"SSI Score"]
[{"$f":"A18","v":""}]
[""]
[""]
[""]
[""]
[""]
[]
["Costs and Benefit/Cost Ratios"]
["Remaining cognizant of the current level of detail of each control strategy's conceptual design, provide a cost estimate for each. You may want to include costs for preliminary engineering, required right-of-way acquisitions, construction, and a contingency. Apply the FDOT Economic Analysis Tool for ICE to determine the delay benefit-cost ratio (B/C), safety B/C, overall B/C, and net-present value for each control strategy."]
["Control Strategy",null,null,null,"ROW Costs ($)",null,null,null,"Construction Costs ($)",null,null,null,"FDOT Economic Analysis Tool for ICE Outputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Delay B/C",null,null,"Safety B/C",null,"Overall B/C",null,null,"Net Present Value"]
[{"$f":"$A$18","v":""}]
[{"$f":"$A$19","v":""}]
[{"$f":"$A$20","v":""}]
[{"$f":"$A$21","v":""}]
[{"$f":"$A$22","v":""}]
[{"$f":"$A$23","v":""}]
[]
["Multimodal Accommodations"]
["Note the existing/anticipated level of pedestrian/bicyclist activity at the study intersection during a typical day. After filling in the daily number of pedestrians crossing, the activity level field will auto-populate."]
["Daily # of peds. crossing (all approaches):",null,null,null,null,null,null,null,null,null,null,"Pedestrian Volume by Activity Level"]
[" Daily # of bicyclists crossing (all approaches):",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H84>=3200,List!M1,IF(AND(H84<3200,H84>=1500),List!M2,IF(AND(H84<1500,H84>=700),List!M3,IF(AND(H84<700,H84>=240),List!M4,IF(AND(H84<240,H84>=1),List!M5,IF(AND(H84=\"\",H84=0),\"\",List!M6))))))","v":""}]
["Summarize the ability of each viable control strategy to accommodate the existing/anticipated level of:"]
["Control Strategy",null,null,null,"Pedestrians and Bicyclists",null,null,null,null,null,"Transit Services",null,null,null,null,null,null,"Freight Needs"]
[{"$f":"$A$18","v":""}]
[{"$f":"$A$19","v":""}]
[{"$f":"$A$20","v":""}]
[{"$f":"$A$21","v":""}]
[{"$f":"$A$22","v":""}]
[{"$f":"$A$23","v":""}]
[]
[]
["Environmental, Utility, and Right-of-Way Impacts"]
["Summarize any issues related to environmental, utility, or right-of-way (including relocation) impacts specific to each control strategy. Be sure to consider the NEPA requirements for each control type."]
[{"$f":"$A$18","v":""}]
[{"$f":"$A$19","v":""}]
[{"$f":"$A$20","v":""}]
[{"$f":"$A$21","v":""}]
[{"$f":"$A$22","v":""}]
[{"$f":"$A$23","v":""}]
[]
[]
["Public Input/Feedback (if appropriate)"]
["Summarize any agency or public input regarding the control strategies:"]
[]
[]
["Control Strategy Evaluation"]
["Provide a brief justification as to why each of the following is either viable or not viable. If a single control strategy is recommended, select it as the only strategy to be advanced."]
["Control Strategy",null,null,null,"Strategy to be Advanced?",null,null,"Justification"]
[{"$f":"$A$18","v":""}]
[{"$f":"$A$19","v":""}]
[{"$f":"$A$20","v":""}]
[{"$f":"$A$21","v":""}]
[{"$f":"$A$22","v":""}]
[{"$f":"$A$23","v":""}]
["Recommendation"]
[]
["Resolution"]
["To be filled out by FDOT District Traffic Operations Engineer and District Design Engineer"]
["Accept Recommendation",null,null,null,null,null,null,null,null,false,null,"Reject Recommendation",null,null,null,null,null,null,null,null,null,null,false]
["DTOE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["DTOE Comments"]
["DDE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["DDE Comments"]

{"sheet":"Stage 3","index":3,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[18,0,18,2],[19,0,19,2],[20,0,20,2],[28,0,28,16],[23,0,23,16],[9,0,9,16],[13,0,13,2],[14,0,14,2],[24,0,24,16],[25,0,25,16],[15,0,15,2],[13,3,13,16],[14,3,14,16],[15,3,15,16],[11,0,11,2],[11,3,11,16],[21,0,21,2],[18,3,18,16],[19,3,19,16],[20,3,20,16],[21,3,21,16],[10,0,10,16],[36,0,36,16],[37,0,37,16],[16,0,16,16],[12,0,12,2],[12,3,12,16],[29,0,29,16],[31,0,31,3],[31,4,31,5],[31,6,31,16],[32,0,32,3],[32,4,32,5],[32,6,32,16],[33,0,33,3],[17,0,17,2],[17,3,17,16],[6,0,6,16],[7,0,7,4],[7,5,7,10],[7,11,7,16],[4,0,4,1],[4,2,4,7],[4,8,4,9],[4,10,4,14],[5,0,5,1],[5,2,5,5],[5,6,5,8],[5,9,5,12],[5,14,5,16],[0,0,0,10],[0,11,0,16],[1,0,1,11],[2,0,2,11],[3,0,3,16],[39,0,39,1],[30,0,30,3],[30,4,30,5],[30,6,30,16],[39,2,39,6],[39,9,39,14],[33,4,33,5],[33,6,33,16],[39,7,39,8],[38,6,38,15],[38,0,38,4],[40,0,40,1],[40,2,40,16],[42,0,42,1],[42,2,42,16],[41,0,41,1],[41,2,41,6],[41,9,41,14],[41,7,41,8]]}
["Florida Department of Transportation",null,null,null,null,null,null,null,null,null,null,"Intersection Control Evaluation Form 750-010-30"]
["Intersection Control Evaluation (ICE) Form"]
["Stage 3: Detailed Control Strategy Assessment"]
["To fulfill the requirements of Stage 3 (Detailed Control Strategy Assessment) of FDOT's ICE procedures, complete the following form and append all supporting documentation, which may include detailed design plans of each control strategy analyzed. Completed forms are to be submitted to the District Traffic Operations Engineer (DTOE) and District Design Engineer (DDE) for the project's approval."]
["Project Name",null,{"$f":"IF('Stage 1'!C5=\"\",\"\",'Stage 1'!C5)","v":""},null,null,null,null,null,"FDOT Project #",null,{"$f":"IF('Stage 1'!O5=\"\",\"\",'Stage 1'!O5)","v":""},null,null,null,null,"Date"]
["Submitted By",null,{"$f":"IF('Stage 1'!C6=\"\",\"\",'Stage 1'!C6)","v":""},null,null,null,"Agency/Company",null,null,{"$f":"IF('Stage 1'!L6=\"\",\"\",'Stage 1'!L6)","v":""},null,null,null,"Email",{"$f":"IF('Stage 1'!C7=\"\",\"\",'Stage 1'!C7)","v":""}]
["List all viable intersection control strategies identified in Stage 2 (Initial Control Strategy Assessment):"]
[{"$f":"List!X1","v":""},null,null,null,null,{"$f":"List!X2","v":""},null,null,null,null,null,{"$f":"List!X3","v":""}]
[]
["Additional Analysis"]
["What issues and/or findings to date have led to a control strategy NOT being selected in Stage 2?"]
["Category",null,null,"Description of Issues/Findings"]
[]
[]
[]
[]
["Describe specific evaluation activities undertaken in Stage 3 analysis to identify a preferred control strategy and discuss the findings:"]
["Category",null,null,"Description of Issues/Findings"]
[{"$f":"IF(A13=\"\",\"\",A13)","v":""}]
[{"$f":"IF(A14=\"\",\"\",A14)","v":""}]
[""]
[""]
[]
["Public Input/Feedback"]
["If not discussed as a part of the preceding section, summarize public input received or stakeholder considerations regarding the control strategies:"]
[]
[]
[]
["Control Strategy Evaluation"]
["Provide a brief justification as to why each of the following was either selected or not selected after conducting the additional analysis. ICE Stage 3 activities should result in a single control strategy being selected."]
["Control Strategy",null,null,null,"Control Strategy Selected?",null,"Justification"]
[{"$f":"IF(A8=\"\",\"\",A8)","v":""}]
[{"$f":"IF(F8=\"\",\"\",F8)","v":""}]
[{"$f":"IF(L8=\"\",\"\",L8)","v":""}]
[]
[]
["Resolution"]
["To be filled out by FDOT District Traffic Operations Engineer and District Design Engineer"]
["Identified Alternative Approved",null,null,null,null,false,"Identified Alternative Not Approved (Re-evaluate control strategies)",null,null,null,null,null,null,null,null,null,false]
["DTOE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,"Date"]
["DTOE Comments"]
["DDE Name",null,null,null,null,null,null,"Signature",null,null,null,null,null,null,null,"Date"]
["DDE Comments"]

{"sheet":"List","index":4,"n_rows":67,"n_cols":36,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Northbound","C1 - Natural","Alachua","District 1","Safety Improvement Project","Two-way Stop-Control","Urban Principal Arterial - Interstate","Urban Principal Arterial - Interstate","Urban Principal Arterial - Other","Both sides of the approach","Yes","Two-way stop control","High (≥ 3,200 peds/day)","A","Construction Only","A single control strategy is recommended","Operations","Identified Alternative Approved",1,{"$f":"IF('Stage 1'!K120:L120=\"Yes\",'Stage 1'!A120:B120,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E13=\"Yes\"),T1,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V1))),\"\")","v":""},{"$f":"IF('Stage 2'!E113=\"YES\",'Stage 2'!A113,\"\")","v":""},{"$f":"IFERROR(INDEX($W$1:$W$6,SMALL(IF($W$1:$W$6<>\"\",ROW($W$1:$W$6)),ROW(X1))),\"\")","v":""},"Passenger car (P)","Weekday AM Peak",null,null,null,"Federal","At-Grade Intersection",null,null,{"$f":"IF(Input!E13=\"Yes\",Input!A13,\"\")","v":""},{"$f":"AH1","v":""},{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ1))),\"\")","v":""}]
["Southbound","C2 - Rural","Baker","District 2","Congestion Mitigation Project","All-way Stop-Control","Urban Principal Arterial - Freeway & Expressway","Urban Principal Arterial - Freeway & Expressway","Urban Minor Arterial","One side of the approach","No","All-way stop control","Med High (1,500 ≤ peds/day < 3,200)","B","PE & Construction","Multiple viable control strategies are identified: Continue to Stage 2","Costs","Identified Alternative Not Approved (Re-evaluate control strategies)",2,{"$f":"IF('Stage 1'!K121:L121=\"Yes\",'Stage 1'!A121:B121,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E14=\"Yes\"),T2,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V2))),\"\")","v":""},{"$f":"IF('Stage 2'!E114=\"YES\",'Stage 2'!A114,\"\")","v":""},{"$f":"IFERROR(INDEX($W$1:$W$6,SMALL(IF($W$1:$W$6<>\"\",ROW($W$1:$W$6)),ROW(X2))),\"\")","v":""},"Single Unit Truck (SU)","Weekday Midday Peak",null,null,null,"Non-federal","Ramp Terminal Intersection",null,null,{"$f":"IF(Input!E14=\"Yes\",Input!A14,\"\")","v":""},{"$f":"AH2","v":""},{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ2))),\"\")","v":""}]
["Eastbound","C2T - Rural Town","Bay","District 3","Corridor Improvement Project","Signal","Urban Principal Arterial - Other","Rural Principal Arterial - Interstate","Urban Major Collector","Neither side of the approach",null,"Traffic Signal","Medium (700 ≤ peds/day < 1,500)","C","ROW & Construction",null,"Safety Performance",null,3,{"$f":"IF('Stage 1'!K122:L122=\"Yes\",'Stage 1'!A122:B122,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E15=\"Yes\"),T3,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V3))),\"\")","v":""},{"$f":"IF('Stage 2'!E115=\"YES\",'Stage 2'!A115,\"\")","v":""},{"$f":"IFERROR(INDEX($W$1:$W$6,SMALL(IF($W$1:$W$6<>\"\",ROW($W$1:$W$6)),ROW(X3))),\"\")","v":""},"Inter-city Bus (BUS-40)","Weekday PM Peak",null,null,null,null,null,null,null,{"$f":"IF(Input!E15=\"Yes\",Input!A15,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ3))),\"\")","v":""}]
["Westbound","C3R - Suburban Residential","Bradford","District 4","Land Development Project","Roundabout","Urban Minor Arterial","Rural  Principal Arterial - Expressway","Urban Minor Collector (Fed Aid)",null,null,"Roundabout","Med Low (240 ≤ peds/day < 700)","D","PE, ROW, & Construction","A single control strategy is recommended","Bicycle/Pedestrian Accommodations",null,4,{"$f":"IF('Stage 1'!K123:L123=\"Yes\",'Stage 1'!A123:B123,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E16=\"Yes\"),T4,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V4))),\"\")","v":""},{"$f":"IF('Stage 2'!E116=\"YES\",'Stage 2'!A116,\"\")","v":""},{"$f":"IFERROR(INDEX($W$1:$W$6,SMALL(IF($W$1:$W$6<>\"\",ROW($W$1:$W$6)),ROW(X4))),\"\")","v":""},"Inter-city Bus (BUS-45)","Weekend AM Peak",null,null,null,null,null,null,null,{"$f":"IF(Input!E16=\"Yes\",Input!A16,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ4))),\"\")","v":""}]
["Northeastbound","C3C - Suburban Commercial","Brevard","District 5","Community/Streetscape Improvement","None/New Intersection","Urban Major Collector",null,"Urban Local",null,null,"Median U-Turn","Low (0 < peds/day < 240)","E","PE, ROW, Construction, Contingency","Multiple viable control strategies are identified: Continue to Stage 3","Transit Services",null,5,{"$f":"IF('Stage 1'!K124:L124=\"Yes\",'Stage 1'!A124:B124,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E17=\"Yes\"),T5,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V5))),\"\")","v":""},{"$f":"IF('Stage 2'!E117=\"YES\",'Stage 2'!A117,\"\")","v":""},null,"City Transit Bus (CITY-BUS)","Weekend Midday Peak",null,null,null,null,null,null,null,{"$f":"IF(Input!E17=\"Yes\",Input!A17,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ5))),\"\")","v":""}]
["Southeastbound","C4 - Urban General","Broward","District 6","Multimodal Improvement","Other","Urban Minor Collector (Fed Aid)",null,"Rural Principal Arterial - Other",null,null,"Median U-Turn (Partial)","Other","F",null,null,"Environmental",null,6,{"$f":"IF('Stage 1'!K125:L125=\"Yes\",'Stage 1'!A125:B125,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E18=\"Yes\"),T6,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V6))),\"\")","v":""},{"$f":"IF('Stage 2'!E118=\"YES\",'Stage 2'!A118,\"\")","v":""},null,"School Bus (S-BUS-36)","Weekend PM Peak",null,null,null,null,null,null,null,{"$f":"IF(Input!E18=\"Yes\",Input!A18,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ6))),\"\")","v":""}]
["Northwestbound","C5 - Urban Center","Calhoun","District 7","Other",null,"Urban Local",null,"Rural Minor Arterial",null,null,"RCUT (Signalized)",null,null,null,null,"Right-of-Way",null,7,{"$f":"IF('Stage 1'!K126:L126=\"Yes\",'Stage 1'!A126:B126,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E19=\"Yes\"),T7,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V7))),\"\")","v":""},null,null,"Intermediate Semitrailer (WB-40)","Other",null,null,null,null,null,null,null,{"$f":"IF(Input!E20=\"Yes\",Input!A20,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ7))),\"\")","v":""}]
["Southwestbound","C6 - Urban Core","Charlotte","District 8",null,null,"Rural Principal Arterial - Interstate",null,"Rural Major Collector",null,null,"RCUT (Unsignalized)",null,null,null,null,"Public Input/Political",null,8,{"$f":"IF('Stage 1'!K127:L127=\"Yes\",'Stage 1'!A127:B127,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E20=\"Yes\"),T8,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V8))),\"\")","v":""},null,null,"Intermediate Semitrailer (WB-50)",null,null,null,null,null,null,null,null,{"$f":"IF(Input!E21=\"Yes\",Input!A21,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ8))),\"\")","v":""}]
[null,null,"Citrus",null,null,null,"Rural  Principal Arterial - Expressway",null,"Rural Minor Collector",null,null,"Jughandle",null,null,null,null,"Other",null,9,{"$f":"IF('Stage 1'!K128:L128=\"Yes\",'Stage 1'!A128:B128,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E21=\"Yes\"),T9,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V9))),\"\")","v":""},null,null,"Interstate Semitrailer (WB-62)",null,null,null,null,null,null,null,null,{"$f":"IF(Input!E22=\"Yes\",Input!A22,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ9))),\"\")","v":""}]
[null,null,"Clay",null,null,null,"Rural Principal Arterial - Other",null,"Rural Local",null,null,"Displaced Left-Turn",null,null,null,null,null,null,10,{"$f":"IF('Stage 1'!K129:L129=\"Yes\",'Stage 1'!A129:B129,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E22=\"Yes\"),T10,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V10))),\"\")","v":""},null,null,"Florida Interstate Semitrailer (WB-62FL)",null,null,null,null,null,null,null,null,{"$f":"IF(Input!E24=\"Yes\",Input!A24,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ10))),\"\")","v":""}]
[null,null,"Collier",null,null,null,"Rural Minor Arterial",null,null,null,null,"Continuous Green Tee",null,null,null,null,null,null,11,{"$f":"IF('Stage 1'!K130:L130=\"Yes\",'Stage 1'!A130:B130,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E23=\"Yes\"),T11,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V11))),\"\")","v":""},null,null,"Interstate Semitrailer (WB-67)",null,null,null,null,null,null,null,null,{"$f":"IF(Input!E25=\"Yes\",Input!A25,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ11))),\"\")","v":""}]
[null,null,"Columbia",null,null,null,"Rural Major Collector",null,null,null,null,"Quadrant Roadway",null,null,null,null,null,null,12,{"$f":"IF('Stage 1'!K131:L131=\"Yes\",'Stage 1'!A131:B131,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E24=\"Yes\"),T12,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V12))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E26=\"Yes\",Input!A26,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ12))),\"\")","v":""}]
[null,null,"DeSoto",null,null,null,"Rural Minor Collector",null,null,null,null,"Other (Please type)",null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K132:L132=\"Yes\",'Stage 1'!A132:B132,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E25=\"Yes\"),T13,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V13))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E27=\"Yes\",Input!A27,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ13))),\"\")","v":""}]
[null,null,"Dixie",null,null,null,"Rural Local",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K133:L133=\"Yes\",'Stage 1'!A133:B133,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E26=\"Yes\"),T14,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V14))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E28=\"Yes\",Input!A28,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ14))),\"\")","v":""}]
[null,null,"Duval",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K134:L134=\"Yes\",'Stage 1'!A134:B134,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E27=\"Yes\"),T15,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V15))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E29=\"Yes\",Input!A29,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ15))),\"\")","v":""}]
[null,null,"Escambia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K135:L135=\"Yes\",'Stage 1'!A135:B135,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E28=\"Yes\"),T16,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V16))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E30=\"Yes\",Input!A30,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ16))),\"\")","v":""}]
[null,null,"Flagler",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K136:L136=\"Yes\",'Stage 1'!A136:B136,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E29=\"Yes\"),T17,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V17))),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!E34=\"Yes\",Input!A34,\"\")","v":""},"",{"$f":"IFERROR(INDEX($AI$1:$AI$17,SMALL(IF($AI$1:$AI$17<>\"\",ROW($AI$1:$AI$17)),ROW(AJ17))),\"\")","v":""}]
[null,null,"Franklin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K137:L137=\"Yes\",'Stage 1'!A137:B137,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E30=\"Yes\"),T18,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V18))),\"\")","v":""}]
[null,null,"Gadsden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K138:L138=\"Yes\",'Stage 1'!A138:B138,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E31=\"Yes\"),T19,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V19))),\"\")","v":""}]
[null,null,"Gilchrist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K139:L139=\"Yes\",'Stage 1'!A139:B139,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E32=\"Yes\"),T20,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V20))),\"\")","v":""}]
[null,null,"Glades",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K140:L140=\"Yes\",'Stage 1'!A140:B140,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E33=\"Yes\"),T21,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V21))),\"\")","v":""}]
[null,null,"Gulf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K141:L141=\"Yes\",'Stage 1'!A141:B141,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"At-Grade Intersection\",Input!E34=\"Yes\"),T22,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V22))),\"\")","v":""}]
[null,null,"Hamilton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K142:L142=\"Yes\",'Stage 1'!A142:B142,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E37=\"Yes\"),T23,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V23))),\"\")","v":""}]
[null,null,"Hardee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K143:L143=\"Yes\",'Stage 1'!A143:B143,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E38=\"Yes\"),T24,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V24))),\"\")","v":""}]
[null,null,"Hendry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K144:L144=\"Yes\",'Stage 1'!A144:B144,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E39=\"Yes\"),T25,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V25))),\"\")","v":""}]
[null,null,"Hernando",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K145:L145=\"Yes\",'Stage 1'!A145:B145,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E40=\"Yes\"),T26,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V26))),\"\")","v":""}]
[null,null,"Highlands",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K146:L146=\"Yes\",'Stage 1'!A146:B146,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E41=\"Yes\"),T27,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V27))),\"\")","v":""}]
[null,null,"Hillsborough",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K147:L147=\"Yes\",'Stage 1'!A147:B147,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E42=\"Yes\"),T28,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V28))),\"\")","v":""}]
[null,null,"Holmes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K148:L148=\"Yes\",'Stage 1'!A148:B148,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E43=\"Yes\"),T29,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V29))),\"\")","v":""}]
[null,null,"Indian River",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K149:L149=\"Yes\",'Stage 1'!A149:B149,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E44=\"Yes\"),T30,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V30))),\"\")","v":""}]
[null,null,"Jackson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K150:L150=\"Yes\",'Stage 1'!A150:B150,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E45=\"Yes\"),T31,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V31))),\"\")","v":""}]
[null,null,"Jefferson",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K151:L151=\"Yes\",'Stage 1'!A151:B151,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E46=\"Yes\"),T32,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V32))),\"\")","v":""}]
[null,null,"Lafayette",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K152:L152=\"Yes\",'Stage 1'!A152:B152,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E47=\"Yes\"),T33,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V33))),\"\")","v":""}]
[null,null,"Lake",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K153:L153=\"Yes\",'Stage 1'!A153:B153,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E48=\"Yes\"),T34,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V34))),\"\")","v":""}]
[null,null,"Lee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K154:L154=\"Yes\",'Stage 1'!A154:B154,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E49=\"Yes\"),T35,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V35))),\"\")","v":""}]
[null,null,"Leon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K155:L155=\"Yes\",'Stage 1'!A155:B155,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E50=\"Yes\"),T36,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V36))),\"\")","v":""}]
[null,null,"Levy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K156:L156=\"Yes\",'Stage 1'!A156:B156,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E51=\"Yes\"),T37,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V37))),\"\")","v":""}]
[null,null,"Liberty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K157:L157=\"Yes\",'Stage 1'!A157:B157,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E52=\"Yes\"),T38,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V38))),\"\")","v":""}]
[null,null,"Madison",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K158:L158=\"Yes\",'Stage 1'!A158:B158,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E53=\"Yes\"),T39,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V39))),\"\")","v":""}]
[null,null,"Manatee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K159:L159=\"Yes\",'Stage 1'!A159:B159,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E54=\"Yes\"),T40,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V40))),\"\")","v":""}]
[null,null,"Marion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K160:L160=\"Yes\",'Stage 1'!A160:B160,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E55=\"Yes\"),T41,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V41))),\"\")","v":""}]
[null,null,"Martin",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K161:L161=\"Yes\",'Stage 1'!A161:B161,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E56=\"Yes\"),T42,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V42))),\"\")","v":""}]
[null,null,"Miami-Dade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K162:L162=\"Yes\",'Stage 1'!A162:B162,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E57=\"Yes\"),T43,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V43))),\"\")","v":""}]
[null,null,"Monroe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K163:L163=\"Yes\",'Stage 1'!A163:B163,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E58=\"Yes\"),T44,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V44))),\"\")","v":""}]
[null,null,"Nassau",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Stage 1'!K164:L164=\"Yes\",'Stage 1'!A164:B164,\"\")","v":""},{"$f":"IF(AND('Stage 1'!$D$9 =\"Ramp Terminal Intersection\",Input!E59=\"Yes\"),T45,\"\")","v":""},{"$f":"IFERROR(INDEX($U$1:$U$45,SMALL(IF($U$1:$U$45<>\"\",ROW($U$1:$U$45)),ROW(V45))),\"\")","v":""}]
[null,null,"Okaloosa"]
[null,null,"Okeechobee"]
[null,null,"Orange"]
[null,null,"Osceola"]
[null,null,"Palm Beach"]
[null,null,"Pasco"]
[null,null,"Pinellas"]
[null,null,"Polk"]
[null,null,"Putnam"]
[null,null,"St. Johns"]
[null,null,"St. Lucie"]
[null,null,"Santa Rosa"]
[null,null,"Sarasota"]
[null,null,"Seminole"]
[null,null,"Sumter"]
[null,null,"Suwannee"]
[null,null,"Taylor"]
[null,null,"Union"]
[null,null,"Volusia"]
[null,null,"Wakulla"]
[null,null,"Walton"]
[null,null,"Washington"]