{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["EarlyExit","Flowcharts","Overview","Instructions","Stage1A","Stage1B","Stage2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":2,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"EarlyExit","index":0,"n_rows":97,"n_cols":28,"rows_kept":97,"cut":false,"hidden":true,"merged":[[82,2,83,2],[90,2,91,2],[1,3,1,14],[6,4,6,5],[10,20,10,23],[58,2,59,2],[66,2,67,2],[74,2,75,2]]}
[]
[null,null,null,"4- LEGGED   EARLY EXIT- 13  INTERSECTION FORMS: SORTED BY AADT CROSS PRODUCT  AND TYPE- 76 OPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methodology:  Using the HCM expanded planning tool including conventional and alternative intersections"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Set default values for K,D, %Turns,PHF,%HV  and C-- remained fixed throughout"]
[null,null,null,"Fixed:","PHF=0.95","%RT=%LT=10%",0.1,"D=",0.5,"    D=0.5","%HV=5%","     K=0.1",null,null,null,null,null,null,null,null,"2. Selected AADT ratio and appropriate  lane configuration  (1:1, 2:1, 3:2, etc…)"]
[null,null,null,"Single LT Lane ON all approaches",null,null,null,null," Shared T+R  ON all approaches","Shared T+R Lanes",null,null,"Cycle Length="," C= 150 SEC",null,null,null,null,null,null,"3. In my spreadsheet  I Increased major street AADT until any lane group for the intersection form gets to v/c =1.1"]
[null,null,null,"Number of through lanes proportional to AADT ratio when possible",null,null,null,null,null,null,null,null,"Green times optimized","Greens Optimized",null,null,null,null,null,null,"4. Recorded the perlane AADT for both roads and generate SUM ADTs and their Cross Product (CP) in the table on the left"]
[null,null,null,null,"FAILURE AT   X = 1.10 ",null,"CROSS",null,null,null,"Major Rd","Minor Rd","OVERALL","Rounded ","AADT",null,null,null,null,null,"5. For application: Enter major and minor AADT for the subject intersection in the block below"]
[null,null,null,"AADT","Major AADT @ Failure","Minor AADT  @Failure","PRODUCT (in 10^6)","Sum","PERCENT","# Thru Lanes","AADT at Failure","AADT at Failure","SUM INTERSECTION","SUM-AADT            @Failure","CROSS PRODUCT AT FAILURE",null,null,null,null,null,"6. Table dynamically highlights types and designs meeting CP-Min**"]
[null,null,null,"RATIO","PER LANE","PER LANE","AT FAILURE","AADT/LANE","LEFT TURNS","Major x Minor",null,null,"AADT @Failure",null,"in Millions",null,null,null,null,null,"**CP Min includes a 30% conflation of actual CP to account for default values assumptions"]
[null,null,null,"D","E","F",null,"H","I","J","K","L","M","N","O"]
[null,null,"SIGNAL","1:1",7935,7935,{"$f":"E11*F11/10^6","v":62.964224999999999},{"$f":"E11+F11","v":15870},10,"1X1",{"$f":"E11*2","v":15870},{"$f":"F11*2","v":15870},{"$f":"K11+L11","v":31740},{"$f":"ROUND(M11/1000,0)*1000","v":32000},{"$f":"K11*L11/10^6","v":251.8569},null,null,null,{"$f":"IF(O11<$W$17,0,IF(O11>$W$18,0,1))","v":0},null,"INPUT SITE AND AADT FOR MAJOR AND MINOR RD.",null,null,null,null,null,null,"Verification with  Coventional Signal 1x 1,AADT Ratio  1:1"]
[null,null,null,"2:1",7905,7905,62.489024999999998,15810,10,"2X1",{"$f":"E12*4","v":31620},{"$f":"F12*2","v":15810},{"$f":"K12+L12","v":47430},47000,499.91219999999998,null,null,null,{"$f":"IF(O12<$W$17,0,IF(O12>$W$18,0,1))","v":0},null,"Glenwood and Milbrook (2021)",null,null,null,null,null,null,"Max AADT that causes a lane group v/c to  ~ 1.1"]
[null,null,null,"3:1",7500,7500,56.25,15000,10,"3X1",{"$f":"E13*6","v":45000},{"$f":"F13*2","v":15000},{"$f":"E13*8","v":60000},60000,675,null,null,null,0,null,"Major AADT",40000,"Minor AADT",15000,null,null,null,"Start with SUM AADT = 32000"]
[null,null,"Mean/Lane","1:1",6900,6900,47.61,13800,10,"2X2",{"$f":"E14*4","v":27600},{"$f":"F14*4","v":27600},{"$f":"E14*8","v":55200},55000,761.76,null,null,null,0,null,"Sum AADT=",null,{"$f":"V13+X13","v":55000},null,null,null,null,"Per street  per day= 16,000"]
[null,null,null,"4:1",7188,7188,51.667344,14376,10,"4X1",{"$f":"E15*8","v":57504},{"$f":"F15*2","v":14376},{"$f":"E15*10","v":71880},72000,826.677504,null,null,null,1,null,"AADT Ratio=",null,{"$f":"V13/X13","v":2.6666666666666665},"    to      1",null,null,null,"Per direction in street per day  = 16000x 0.5=8000"]
[null,null,{"$f":"AVERAGE(E11:F18)","v":7041.875},"3:2",6515,6515,{"$f":"E16*F16/10^6","v":42.445225000000001},{"$f":"E16+F16","v":13030},10,"3x2",{"$f":"E16*6","v":39090},{"$f":"F16*4","v":26060},{"$f":"E16*10","v":65150},{"$f":"ROUND(M16/1000,0)*1000","v":65000},{"$f":"K16*L16/10^6","v":1018.6854},null,null,null,1,null,"Actual AADT Cross Product=",null,{"$f":"V13*X13/10^6","v":600}," million",null,null,null,"Per peak hour per direction (TPC) = 8,000x0.1x1.05=840"]
[null,null,"Stdev","2:1",6250,6250,{"$f":"E17*F17/10^6","v":39.0625},{"$f":"E17+F17","v":12500},{"$f":"I14","v":10},"4x2",{"$f":"E17*8","v":50000},{"$f":"F17*4","v":25000},{"$f":"E17*12","v":75000},{"$f":"ROUND(M17/1000,0)*1000","v":75000},{"$f":"K17*L17/10^6","v":1250},null,null,null,0,null,"CP-Min=",null,{"$f":"1.3* V13*X13/10^6","v":780},null,null,null,null,"Per peak period one direction = 840/0.95= 885"]
[null,null,{"$f":"STDEV(E11:F18)","v":683.9546646769312},"1:1",6142,6142,{"$f":"E18*F18/10^6","v":37.724164000000002},{"$f":"E18+F18","v":12284},{"$f":"'[2]GLOBAL INPUTS'!F58","v":10},"3x3",{"$f":"E18*6","v":36852},{"$f":"F18*6","v":36852},{"$f":"E18*12","v":73704},{"$f":"ROUND(M18/1000,0)*1000","v":74000},{"$f":"K18*L18/10^6","v":1358.069904},null,null,null,0,null,"CP-Max=",null,{"$f":"1.8*W16","v":1080},"E. Exits",null,null,null,"Intersection Critical lane volume =885x2=1770"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Approximate X= 1,680/1600=1.07",null,null,null,null,null,null,"Approximate x= 1770/1650~ 1.08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"TWSC","1:1",6200,6200,{"$f":"E22*F22/10^6","v":38.44},{"$f":"E22+F22","v":12400},{"$f":"I11","v":10},"1x1",{"$f":"E22*2","v":12400},{"$f":"F22*2","v":12400},{"$f":"K22+L22","v":24800},{"$f":"ROUND(M22/1000,0)*1000","v":25000},{"$f":"K22*L22/10^6","v":153.76},null,null,null,0,null,"# Carry Over Alternatives=",null,{"$f":"SUM(S11:S97)","v":14},{"$f":"(76-W22)/76","v":0.81578947368421051}]
[null,null,"Mean/Lane","2:1",4437,4437,19.686969000000001,{"$f":"E23+F23","v":8874},10,"2x1",{"$f":"E23*4","v":17748},{"$f":"E23*2","v":8874},{"$f":"K23+L23","v":26622},{"$f":"ROUND(M23/1000,0)*1000","v":27000},{"$f":"K23*L23/10^6","v":157.49575200000001},null,null,null,0]
[null,null,{"$f":"AVERAGE(E22:F26)","v":4136.3999999999996},"3:1",3633,3633,13.198689,{"$f":"E24+F24","v":7266},10,"3x1",{"$f":"E24*6","v":21798},{"$f":"F24*2","v":7266},{"$f":"K24+L24","v":29064},{"$f":"ROUND(M24/1000,0)*1000","v":29000},{"$f":"K24*L24/10^6","v":158.38426799999999},null,null,null,0]
[null,null,"Stdev","1:1",3437,3437,11.812969000000001,{"$f":"E25+F25","v":6874},10,"2x2",{"$f":"E25*4","v":13748},{"$f":"F25*4","v":13748},{"$f":"K25+L25","v":27496},{"$f":"ROUND(M25/1000,0)*1000","v":27000},{"$f":"K25*L25/10^6","v":189.00750400000001},null,null,null,0]
[null,null,{"$f":"STDEV(E22:F26)","v":1196.3116650772911},"3:2",2975,2975,8.8506250000000009,{"$f":"E26+F26","v":5950},{"$f":"I17","v":10},"3x2",{"$f":"E26*6","v":17850},{"$f":"F26*4","v":11900},{"$f":"K26+L26","v":29750},{"$f":"ROUND(M26/1000,0)*1000","v":30000},{"$f":"K26*L26/10^6","v":212.41499999999999},null,null,null,0]
[null,null,"SLROUND","2:1",8250,{"$f":"E27/2","v":4125},34.03125,{"$f":"E27+F27","v":12375},{"$f":"I23","v":10},"1x1",{"$f":"E27*2","v":16500},{"$f":"F27*2","v":8250},{"$f":"K27+L27","v":24750},{"$f":"ROUND(M27/1000,0)*1000","v":25000},{"$f":"K27*L27/10^6","v":136.125},null,null,null,0]
[null,null,{"$f":"AVERAGE(E27:F28)","v":6368.75},"1:1",6550,6550,42.902500000000003,13100,{"$f":"I23","v":10},"1x1",{"$f":"E28*2","v":13100},{"$f":"F28*2","v":13100},26200,26000,171.61,null,null,null,0]
[null,null,"MLROUND","2:1",5390,5390,29.052099999999999,10780,{"$f":"I25","v":10},"2x1",{"$f":"E29*4","v":21560},{"$f":"F29*2","v":10780},32340,32000,232.41679999999999,null,null,null,0]
[null,null,{"$f":"AVERAGE(E29:F30)","v":5239},"1:1",5088,5088,25.887744000000001,10176,{"$f":"I25","v":10},"2x2",{"$f":"E30*4","v":20352},{"$f":"F30*4","v":20352},40704,41000,414.20390400000002,null,null,null,0]
[null,null,"AWSC","2:1",4250,{"$f":"E31/2","v":2125},9.03125,6375,{"$f":"I28","v":10},"1X1",{"$f":"E31*2","v":8500},{"$f":"F31*2","v":4250},12750,13000,36.125,null,null,null,0]
[null,null,{"$f":"AVERAGE(E31:F32)","v":3356.25},"1:1",3525,3525,12.425625,7050,{"$f":"I28","v":10},"1X1",{"$f":"E32*2","v":7050},{"$f":"F32*2","v":7050},14100,14000,49.702500000000001,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"RCUT","2:1",6250,6250,{"$f":"E34*F34/10^6","v":39.0625},{"$f":"E34+F34","v":12500},{"$f":"I30","v":10},"2X1",{"$f":"E34*4","v":25000},{"$f":"F34*2","v":12500},{"$f":"K34+L34","v":37500},{"$f":"ROUND(M34/1000,0)*1000","v":38000},{"$f":"K34*L34/10^6","v":312.5},null,null,null,0]
[null,null,"Mean/Lane","3:1",6535,6535,42.706225000000003,13070,{"$f":"I30","v":10},"3X1",{"$f":"E35*6","v":39210},{"$f":"F35*2","v":13070},52280,52000,512.47469999999998,null,null,null,0]
[null,null,{"$f":"AVERAGE(E34:F41)","v":6477.125},"3:2",5667,5667,32.114888999999998,11334,{"$f":"I38","v":10},"3x2",{"$f":"E36*6","v":34002},{"$f":"F36*4","v":22668},56670,57000,770.75733600000001,null,null,null,0]
[null,null,"Stdev","4:1",7100,7100,50.41,14200,10,"4x1",{"$f":"E37*8","v":56800},{"$f":"F37*2","v":14200},71000,71000,806.56,null,null,null,1]
[null,null,{"$f":"STDEV(E34:F41)","v":950.4141465697993},"1:1",4800,4800,23.04,9600,{"$f":"I35","v":10},"3X3",{"$f":"E38*6","v":28800},{"$f":"F38*6","v":28800},57600,58000,829.44,null,null,null,1,null,"Currently Signalized     3x 1,3x2"]
[null,null,null,"1:1",7965,7965,63.441225000000003,15930,10,"2X2",{"$f":"E39*4","v":31860},{"$f":"F39*4","v":31860},63720,64000,1015.0596,null,null,null,1]
[null,null,null,"5:1",7250,7250,52.5625,14500,{"$f":"I33","v":0},"5X1",{"$f":"E40*10","v":72500},{"$f":"F40*2","v":14500},87000,87000,1051.25,null,null,null,1]
[null,null,null,"2:1",6250,6250,39.0625,12500,{"$f":"I36","v":10},"4X2",{"$f":"E41*8","v":50000},{"$f":"F41*4","v":25000},75000,75000,1250,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"MUT","2:1",7540,7540,{"$f":"E43*F43/10^6","v":56.851599999999998},{"$f":"E43+F43","v":15080},{"$f":"I37","v":10},"2X1",{"$f":"E43*4","v":30160},{"$f":"F43*2","v":15080},{"$f":"K43+L43","v":45240},{"$f":"ROUND(M43/1000,0)*1000","v":45000},{"$f":"K43*L43/10^6","v":454.81279999999998},null,null,null,0]
[null,null,"Mean/Lane","3:1",7430,7430,55.204900000000002,14860,{"$f":"I38","v":10},"3X1",{"$f":"E44*6","v":44580},{"$f":"F44*2","v":14860},59440,59000,662.4588,null,null,null,0]
[null,null,null,"4:1",7875,7875,62.015625,15750,10,"4x1",{"$f":"E45*8","v":63000},{"$f":"F45*2","v":15750},78750,79000,992.25,null,null,null,1]
[null,null,{"$f":"AVERAGE(E43:F49)","v":7332.8571428571431},"1:1",5800,5800,33.64,11600,{"$f":"I42","v":0},"3X3",{"$f":"E46*6","v":34800},{"$f":"F46*6","v":34800},69600,70000,1211.04,null,null,null,0]
[null,null,"Stdev","3:2",7185,7185,51.624225000000003,14370,10,"3x2",{"$f":"E47*6","v":43110},{"$f":"F47*4","v":28740},71850,72000,1238.9813999999999,null,null,null,0]
[null,null,{"$f":"STDEV(E43:F49)","v":691.79730881488433},"5:1",7900,7900,62.41,15800,{"$f":"I39","v":10},"5X1",{"$f":"E48*10","v":79000},{"$f":"F48*2","v":15800},94800,95000,1248.2,null,null,null,0]
[null,null,null,"2:1",7600,7600,57.76,15200,{"$f":"I45","v":10},"4X2",{"$f":"E49*8","v":60800},{"$f":"F49*4","v":30400},91200,91000,1848.32,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"PMUT","2:1",6850,6850,{"$f":"E51*F51/10^6","v":46.922499999999999},{"$f":"E51+F51","v":13700},{"$f":"I46","v":0},"2X1",{"$f":"E51*4","v":27400},{"$f":"F51*2","v":13700},{"$f":"K51+L51","v":41100},{"$f":"ROUND(M51/1000,0)*1000","v":41000},{"$f":"K51*L51/10^6","v":375.38},null,null,null,0]
[null,null,null,"1:1",7000,7000,{"$f":"E52*F52/10^6","v":49},14000,{"$f":"I48","v":10},"1x1",{"$f":"E52*4","v":28000},{"$f":"F52*2","v":14000},42000,42000,392,null,null,null,0]
[null,null,"Mean/Lane","1:1",5200,5200,null,10400,10,"2x2",{"$f":"E53*4","v":20800},{"$f":"F53*4","v":20800},41600,42000,432.64,null,null,null,0]
[null,null,null,"3:1",6685,6685,{"$f":"E54*F54/10^6","v":44.689225},13370,10,"3X1",{"$f":"E54*6","v":40110},{"$f":"F54*2","v":13370},53480,53000,536.27070000000003,null,null,null,0]
[null,null,{"$f":"AVERAGE(E51:F57)","v":6167.5714285714284},"3:2",5133,5133,{"$f":"E55*F55/10^6","v":26.347688999999999},{"$f":"E55+F55","v":10266},10,"3x2",{"$f":"E55*6","v":30798},{"$f":"F55*4","v":20532},{"$f":"K55+L55","v":51330},{"$f":"ROUND(M55/1000,0)*1000","v":51000},{"$f":"K55*L55/10^6","v":632.34453599999995},null,null,null,0]
[null,null,"Stdev","4:1",7015,7015,{"$f":"E56*F56/10^6","v":49.210225000000001},{"$f":"E56+F56","v":14030},10,"4X1",{"$f":"E56*7","v":49105},{"$f":"F56*2","v":14030},{"$f":"K56+L56","v":63135},{"$f":"ROUND(M56/1000,0)*1000","v":63000},{"$f":"K56*L56/10^6","v":688.94314999999995},null,null,null,0]
[null,null,{"$f":"STDEV(E51:F57)","v":870.11738503276774},"2:1",5290,5290,{"$f":"E57*F57/10^6","v":27.984100000000002},{"$f":"E57+F57","v":10580},{"$f":"I52","v":10},"4X2",{"$f":"E57*8","v":42320},{"$f":"F57*4","v":21160},{"$f":"K57+L57","v":63480},{"$f":"ROUND(M57/1000,0)*1000","v":63000},{"$f":"K57*L57/10^6","v":895.49120000000005},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"CFI/DLT","1:1",8000,8000,{"$f":"E59*F59/10^6","v":64},{"$f":"E59+F59","v":16000},{"$f":"I56","v":10},"1x1",{"$f":"E59*2","v":16000},{"$f":"F59*2","v":16000},{"$f":"K59+L59","v":32000},{"$f":"ROUND(M59/1000,0)*1000","v":32000},{"$f":"K59*L59/10^6","v":256},null,null,null,0]
[null,null,null,"2:1",7915,7915,62.647224999999999,15830,{"$f":"I56","v":10},"2X1",{"$f":"E60*4","v":31660},{"$f":"F60*2","v":15830},47490,47000,501.17779999999999,null,null,null,0]
[null,null,"Mean/Lane","3:1",7750,7750,60.0625,15500,{"$f":"I57","v":10},"3X1",{"$f":"E61*6","v":46500},{"$f":"F61*2","v":15500},62000,62000,720.75,null,null,null,0]
[null,null,null,"1:1",7375,7375,54.390625,14750,10,"2x2",{"$f":"E62*4","v":29500},{"$f":"F62*4","v":29500},59000,59000,870.25,null,null,null,1]
[null,null,{"$f":"AVERAGE(E59:F65)","v":7671.4285714285716},"4:1",8040,8040,64.641599999999997,16080,10,"4X1",{"$f":"E63*8","v":64320},{"$f":"F63*2","v":16080},80400,80000,1034.2655999999999,null,null,null,1]
[null,null,"Stdev","3:2",7245,7245,52.490025000000003,14490,10,"3x2",{"$f":"E64*6","v":43470},{"$f":"F64*4","v":28980},72450,72000,1259.7606000000001,null,null,null,0]
[null,null,{"$f":"STDEV(E59:F65)","v":320.30891682530819},"2:1",7375,7375,54.390625,14750,{"$f":"I61","v":10},"4X2",{"$f":"E65*8","v":59000},{"$f":"F65*4","v":29500},88500,89000,1740.5,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"QRI- NE","1:1",8200,8200,{"$f":"E67*F67/10^6","v":67.239999999999995},{"$f":"E67+F67","v":16400},{"$f":"I63","v":10},"1x1",{"$f":"E67*2","v":16400},{"$f":"F67*2","v":16400},{"$f":"K67+L67","v":32800},{"$f":"ROUND(M67/1000,0)*1000","v":33000},{"$f":"K67*L67/10^6","v":268.95999999999998},null,null,null,0]
[null,null,null,"2:1",8225,8225,67.650625000000005,16450,{"$f":"I63","v":10},"2X1",{"$f":"E68*4","v":32900},{"$f":"F68*2","v":16450},49350,49000,541.20500000000004,null,null,null,0]
[null,null,"Mean/Lane","3:1",8235,8235,67.815224999999998,16470,{"$f":"I64","v":10},"3X1",{"$f":"E69*6","v":49410},{"$f":"F69*2","v":16470},65880,66000,813.78269999999998,null,null,null,1]
[null,null,null,"4:1",7530,7530,{"$f":"E70*F70/10^6","v":56.700899999999997},{"$f":"E70+F70","v":15060},10,"4X1",{"$f":"E70*8","v":60240},{"$f":"F70*2","v":15060},{"$f":"K70+L70","v":75300},{"$f":"ROUND(M70/1000,0)*1000","v":75000},{"$f":"K70*L70/10^6","v":907.21439999999996},null,null,null,1]
[null,null,{"$f":"AVERAGE(E67:F73)","v":7979.7142857142853},"1:1",8250,8250,{"$f":"E71*F71/10^6","v":68.0625},{"$f":"E71+F71","v":16500},10,"2x2",{"$f":"E71*4","v":33000},{"$f":"F71*4","v":33000},{"$f":"K71+L71","v":66000},{"$f":"ROUND(M71/1000,0)*1000","v":66000},{"$f":"K71*L71/10^6","v":1089},null,null,null,0]
[null,null,"Stdev","3:2",8233,8233,{"$f":"E72*F72/10^6","v":67.782289000000006},{"$f":"E72+F72","v":16466},10,"3x2",{"$f":"E72*6","v":49398},{"$f":"F72*4","v":32932},{"$f":"K72+L72","v":82330},{"$f":"ROUND(M72/1000,0)*1000","v":82000},{"$f":"K72*L72/10^6","v":1626.774936},null,null,null,0]
[null,null,{"$f":"STDEV(E67:F73)","v":419.68549187208282},"2:1",7185,7185,51.624225000000003,14370,{"$f":"I69","v":10},"4X2",{"$f":"E73*8","v":57480},{"$f":"F73*4","v":28740},86220,86000,1651.9752000000001,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Bowtie","1:1",7600,7600,{"$f":"E75*F75/10^6","v":57.76},{"$f":"E75+F75","v":15200},{"$f":"I69","v":10},"1x1",{"$f":"E75*2","v":15200},{"$f":"F75*2","v":15200},{"$f":"K75+L75","v":30400},{"$f":"ROUND(M75/1000,0)*1000","v":30000},{"$f":"K75*L75/10^6","v":231.04},null,null,null,0]
[null,null,null,"2:1",7125,7125,50.765625,14250,{"$f":"I69","v":10},"2X1",{"$f":"E76*4","v":28500},{"$f":"F76*2","v":14250},42750,43000,406.125,null,null,null,{"$f":"IF(O76<$W$17,0,IF(O76>$W$18,0,1))","v":0}]
[null,null,"Mean/Lane","3:1",6680,6680,44.622399999999999,13360,{"$f":"I72","v":10},"3X1",{"$f":"E77*6","v":40080},{"$f":"F77*2","v":13360},53440,53000,535.46879999999999,null,null,null,0]
[null,null,null,"4:1",6700,6700,44.89,13400,10,"4X1",{"$f":"E78*8","v":53600},{"$f":"F78*2","v":13400},67000,67000,718.24,null,null,null,0]
[null,null,{"$f":"AVERAGE(E76:F81)","v":6964.5},"1:1",7250,7250,{"$f":"E79*F79/10^6","v":52.5625},{"$f":"E79+F79","v":14500},10,"2x2",{"$f":"E79*4","v":29000},{"$f":"F79*4","v":29000},{"$f":"K79+L79","v":58000},{"$f":"ROUND(M79/1000,0)*1000","v":58000},{"$f":"K79*L79/10^6","v":841},null,null,null,1]
[null,null,"Stdev","3:2",6945,6945,{"$f":"E80*F80/10^6","v":48.233024999999998},{"$f":"E80+F80","v":13890},10,"3x2",{"$f":"E80*6","v":41670},{"$f":"F80*4","v":27780},{"$f":"K80+L80","v":69450},{"$f":"ROUND(M80/1000,0)*1000","v":69000},{"$f":"K80*L80/10^6","v":1157.5925999999999},null,null,null,0]
[null,null,{"$f":"STDEV(E76:F81)","v":223.01956701762128},"2:1",7087,7087,50.225569,14174,{"$f":"I77","v":10},"4X2",{"$f":"E81*8","v":56696},{"$f":"F81*4","v":28348},85044,85000,1607.218208,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Forward Jughandle","1:1",6460,6460,{"$f":"E83*F83/10^6","v":41.7316},{"$f":"E83+F83","v":12920},{"$f":"I76","v":10},"1x1",{"$f":"E83*2","v":12920},{"$f":"F83*2","v":12920},{"$f":"K83+L83","v":25840},{"$f":"ROUND(M83/1000,0)*1000","v":26000},{"$f":"K83*L83/10^6","v":166.9264},null,null,null,0]
[null,null,null,"1:1",3980,3980,15.840400000000001,7960,10,"2x2",{"$f":"E84*4","v":15920},{"$f":"F84*4","v":15920},31840,32000,253.44640000000001,null,null,null,0]
[null,null,"Mean/Lane","3:2",3460,3460,{"$f":"E85*F85/10^6","v":11.9716},{"$f":"E85+F85","v":6920},10,"3x2",{"$f":"E85*6","v":20760},{"$f":"F85*4","v":13840},{"$f":"K85+L85","v":34600},{"$f":"ROUND(M85/1000,0)*1000","v":35000},{"$f":"K85*L85/10^6","v":287.3184},null,null,null,0]
[null,null,"(STOPPED-LT)","2:1",6145,6145,{"$f":"E86*F86/10^6","v":37.761024999999997},{"$f":"E86+F86","v":12290},{"$f":"I77","v":10},"2X1",{"$f":"E86*4","v":24580},{"$f":"F86*2","v":12290},{"$f":"K86+L86","v":36870},{"$f":"ROUND(M86/1000,0)*1000","v":37000},{"$f":"K86*L86/10^6","v":302.08819999999997},null,null,null,0]
[null,null,{"$f":"AVERAGE(E83:F89)","v":4672.8571428571431},"2:1",3090,3090,{"$f":"E87*F87/10^6","v":9.5480999999999998},{"$f":"E87+F87","v":6180},{"$f":"I81","v":10},"4X2",{"$f":"E87*8","v":24720},{"$f":"F87*4","v":12360},{"$f":"K87+L87","v":37080},{"$f":"ROUND(M87/1000,0)*1000","v":37000},{"$f":"K87*L87/10^6","v":305.53919999999999},null,null,null,0]
[null,null,"Stdev","3:1",5125,5125,26.265625,10250,{"$f":"I79","v":10},"3X1",{"$f":"E88*6","v":30750},{"$f":"F88*2","v":10250},41000,41000,315.1875,null,null,null,0]
[null,null,{"$f":"STDEV(E83:F89)","v":1244.7856075610812},"4:1",4450,4450,19.802499999999998,8900,10,"4X1",{"$f":"E89*8","v":35600},{"$f":"F89*2","v":8900},44500,45000,316.83999999999997,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Reverse Jughandle","1:1",5975,5975,{"$f":"E91*F91/10^6","v":35.700625000000002},{"$f":"E91+F91","v":11950},{"$f":"I83","v":10},"1x1",{"$f":"E91*2","v":11950},{"$f":"F91*2","v":11950},{"$f":"K91+L91","v":23900},{"$f":"ROUND(M91/1000,0)*1000","v":24000},{"$f":"K91*L91/10^6","v":142.80250000000001},null,null,null,0]
[null,null,null,"2:1",5700,5700,32.49,11400,{"$f":"I83","v":10},"2X1",{"$f":"E92*4","v":22800},{"$f":"F92*2","v":11400},34200,34000,259.92,null,null,null,0]
[null,null,"Mean/Lane","3:1",5450,5450,29.702500000000001,10900,{"$f":"I84","v":10},"3X1",{"$f":"E93*6","v":32700},{"$f":"F93*2","v":10900},43600,44000,356.43,null,null,null,0]
[null,null,null,"4:1",5235,5235,27.405225000000002,10470,10,"4X1",{"$f":"E94*8","v":41880},{"$f":"F94*2","v":10470},52350,52000,438.48360000000002,null,null,null,0]
[null,null,{"$f":"AVERAGE(E91:F97)","v":5579.2857142857147},"1:1",5685,5685,{"$f":"E95*F95/10^6","v":32.319225000000003},{"$f":"E95+F95","v":11370},10,"2x2",{"$f":"E95*4","v":22740},{"$f":"F95*4","v":22740},{"$f":"K95+L95","v":45480},{"$f":"ROUND(M95/1000,0)*1000","v":45000},{"$f":"K95*L95/10^6","v":517.10760000000005},null,null,null,0]
[null,null,"Stdev","3:2",5560,5560,{"$f":"E96*F96/10^6","v":30.913599999999999},{"$f":"E96+F96","v":11120},10,"3x2",{"$f":"E96*6","v":33360},{"$f":"F96*4","v":22240},{"$f":"K96+L96","v":55600},{"$f":"ROUND(M96/1000,0)*1000","v":56000},{"$f":"K96*L96/10^6","v":741.92639999999994},null,null,null,0]
[null,null,{"$f":"STDEV(E91:F97)","v":226.90947994280029},"2:1",5450,5450,29.702500000000001,10900,{"$f":"I92","v":10},"4X2",{"$f":"E97*8","v":43600},{"$f":"F97*4","v":21800},65400,65000,950.48,null,null,null,1]

{"sheet":"Flowcharts","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":true,"merged":[[22,14,24,29],[53,0,53,13],[0,0,0,13],[2,14,2,28],[9,14,12,27],[17,14,19,29]]}
["Stage 1 (From Bastian)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bastian's 1st Draft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please take a look at this potential framework for Stage 1 based on the discussion this morning. I tried to capture the discussion related to Stage 0 and Stage 1, including sequence and decision points. In the framework, blue cells are steps in the method (and maybe tabs in the tool?), orange are data needs, and green are questions each step is trying to answer (we can discuss these further in the guide). The yellow cells are three decision points by the user:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2 Early Exits decides what to exclude early-on based on the initial feasibility"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5 decides on the relative weights for the stage 1 assessment method based on context and equity (we should develop some defaults for this)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.8 then decides what to move on to Stage 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"There is NOT a decision point between various components of Step 1.6 … idea is for a user to look at ALL assessment methods before jumping to any conclusions."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shannon's Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As someone who was not on the call last week but has a background on ICE, I think this graphic makes a lot of sense. My only comment is on the second question in 1.7 “What alternatives are feasible?” this seems more suited for 1.8. The way its laid out currently makes it seem like at 1.7 you need to make a cut of intersections (i.e. cut what is not feasible in 1.7, then in 1.8 take all the feasible and pick your preferred(s) for further assessment which feels a bit like putting your hand on the scale), but I think it makes more sense for there to be only 2 cuts (1.2 and 1.8)."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Paul's Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.1: Is functional class necessary as a data need? Won’t AADT give you similar information?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.2: In the question, add “forms” after “intersection/interchange”"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.3: Perhaps “Equity Assessment”, since the results of this step aren’t being used to screen out any intersection concepts in Stage 1. For data needs, suggest deleting “census data” since that is covered by “demographic data” and adding “travel modes and patterns” and “local history”. For questions: “What travel modes are present at the intersection?”, “What are the likely travel needs for users of each mode?”, “How have the surrounding neighborhoods and major road developed over time?”"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.4: In the first question, change “improvement” to “project”."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.5: Add as the second question, “What are the relative weights to be assigned to different intersection forms?” (for those agencies wanting to prioritize certain intersection forms)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After step 1.5, I think you need a step to develop initial concepts that set details of the form and control for each remaining intersection type (e.g., need for exclusive turn lanes, number of approach lanes, general footprint), as these will affect the results of all aspects of the Stage 1 analysis. This step may need to be iterative with step 1.6 (e.g., to make the v/c work, you need to add exclusive turn lanes, but doing so makes the ped/bike score worse or requires more ROW than is available)."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.6: Suggest changing “intersection form” to “intersection concept” from this point forward."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.6.4: Should a basic ROW screening be conducted as part of the environmental screening (e.g., is the roadway already built out to the limits of the ROW?)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stage 2 (From Paul)"]

{"sheet":"Overview","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,2,11],[3,1,3,12],[6,1,6,12],[8,1,8,12],[9,1,9,12],[22,1,22,12],[26,1,27,12],[29,1,29,12],[12,1,12,12],[15,1,15,12],[16,1,16,12],[18,1,18,12],[21,1,21,12],[19,1,19,12],[24,1,24,12]]}
[]
[]
[null,null,"NCHRP Project 17-98 "]
[null,"Intersection Control Evaluation (ICE)\nProcess Tool"]
[]
[]
[null,"Build: 2024-09"]
[]
[null,"NCHRP Project 17-98"]
[null,"© 2023 National Academy of Sciences"]
[]
[null,"ACKNOWLEDGMENT OF SPONSORSHIP"]
[null,"The National Cooperative Highway Research Program (NCHRP) produces ready-to-implement solutions to the challenges facing transportation professionals. NCHRP is sponsored by the individual state departments of transportation of the American Association of State Highway and Transportation Officials. NCHRP is administered by the Transportation Research Board (TRB), part of the National Academies of Sciences, Engineering, and Medicine, under a cooperative agreement with the Federal Highway Administration (FHWA).  "]
[]
[null,"COPYRIGHT"]
[null,"This material and the copyrights herein are owned by the National Academies of Sciences, Engineering, and Medicine. Permission to reproduce any copyrighted material included herein was obtained by the contractor. "]
[]
[null,"DISCLAIMER"]
[null,"Any opinions and conclusions expressed or implied in resulting research products are those of the individuals and organizations who performed the research and are not necessarily those of TRB; the National Academies of Sciences, Engineering, and Medicine; the FHWA; or NCHRP sponsors."]
[null,"The material has not been edited by TRB."]
[]
[null,"Any software included is offered as is, without warranty or promise of support of any kind either expressed or implied. Under no circumstance will the National Academy of Sciences or the Transportation Research Board (collectively “TRB”) be liable for any loss or damage caused by the installation or operation of this product. TRB makes no representation or warranty of any kind, expressed or implied, in fact or in law, including without limitation, the warranty of merchantability or the warranty of fitness for a particular purpose, and shall not in any case be liable for any consequential or special damages."]
[]
[null,"INSTRUCTIONS"]
[null,"The ICE Process Tool develops a short list of and recommendations for implementation of alternative intersection concepts. This is a research-grade software tool that does not provide the enhanced user interface and extensive error checking that commercial software would provide."]
[]
[null,"The spreadsheet consists of four tabs in addition to this overview. The Instructions tab provides guidance on when and how to use the tool. The Stage 1A worksheet eliminates intersection alternatives from consideration on the basis of high-level data, and the Stage 1B worksheet narrows intersection alternatives to a shortlist to be evaluate in greater detail.  The Stage 2 tab is used to document the detailed alternative analysis and the final project recommendation. "]
[]
[]
[null,"User-provided data are entered into the light yellow cells on each worksheet. Orange cells indicate optional inputs. The worksheets are password protected, with only the required user inputs being editable. The password for unlocking the engine may be requested from Bastian Schroeder, bschroeder@kittelson.com."]
[]
[null,"VERSION HISTORY"]
[null,"2023-07","Final submission to NCHRP"]
[null,"2024-09","Corrected cell reference in Stage 1A"]

{"sheet":"Instructions","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,2,3],[4,1,4,3],[9,1,9,3],[12,1,12,3]]}
[]
[null,"INTERSECTION EVALUATION TOOL (ICE) USER INSTRUCTIONS"]
[]
[null,"Stage/Workflow No.","Input Fields","External Tool(s) Used"]
[null,"STAGE 1A"]
[null,"1. Project Data","Enter basic project data in yellow fields including project name, location, intersecting road names, analyst, date of analysis and a brief description of the project purpose (250 characters max)","None"]
[null,"2. Project Context","Using text and drop down boxes, select context including applicability of interchange/grade separation, surrounding area context, number of lanes and short answers to equity context questions (225 characters max)","None"]
[null,"3. Roadway Data","Select roadway functional class, no. of lanes, AADT and ROW for each facility. Note: AADT values should be future design year volumes if user is intending on evaluating intersection alternative capacity through a project design year.","None"]
[null,"4. Intersection Feasibility","Based on the data from previous workflow items, the Tool will select which intersection alternatives should be carried into Stage 1A and which should be eliminated; however, in some cases, the used must decide if the intersection alternative is applicable by changing the --Yes/No-- cell value to either Yes or No. At the bottom of the page, the user can enter (write-in) a unique intersection alternative (excluded in list above) and select that alternate for consideration in Stage 1B.","None"]
[null,"STAGE 1B"]
[null,"5. Screening Data","Users input screening results using CAP-X, Safe Systems Intersection (SSI) and a high-level determination of environmental impacts (using drop-down menu choices) for each alternative. Users will use this data to evaluate and select which alternative should procced for further analysis in Stage 2 by selecting \"Yes\" in the far-right column.","CAP-X Tool\nCAP-X Bike/Ped Tool\nSSI Worksheet"]
[null,"6. Shortlist","The data from the previous workflow item is re-ordered according to SSI score, and the data inputs are color coded (shades of green, yellow, red) to rank the intersection alternatives for each category. In the box at the bottom of the worksheet, users should input the factors that led to the elimination of the alternatives not moving forward into Stage 2.","None"]
[null,"STAGE 2"]
[null,"Context of Stage 2:","The Stage 2 Worksheet is meant to be filled out and used at a Project Review Meeting to document the decision making process determine the final intersection alternative selection of the project. At the top of the form, fill in the date of the meeting and all project team members in attendance.","None"]
[null,"7. Context & Equity Summary","This workflow item summarizes the equity goals for the project input in Stage 1A and users are to include key findings from the Equity worksheet exercise.","Equity Worksheet"]
[null,"8. Selection Criteria","Users enter more detailed screening data, average peak hour delays (from detailed capacity analysis using HCS, Synchro etc.), results from the ped/bike 20-flags analysis, predictive safety scores, life cycle and Benefit-Cost ratios, the level of support from stakeholder and the public and a determination if the alternative meets project equity goals. ","Traffic analysis software/PPEAG\n20-Flags Calculator\nSPICE Tool\nLife Cycle Cost Estimation \nToolBike/Ped 20-Flags Method\nPredictive Safety Analysis\nCost estimating worksheet"]
[null,"9. Review Mtg Notes & Recommendations","The intent is to use this information to decide the Recommended Alternative (using drop-down box) and document the meeting notes, including why the Final Alternative is recommended.","None"]

{"sheet":"Stage1A","index":4,"n_rows":64,"n_cols":34,"rows_kept":64,"cut":false,"hidden":false,"merged":[[22,28,22,33],[21,12,23,12],[21,13,23,13],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[20,0,20,1],[21,0,21,1],[20,2,20,3],[21,2,21,3],[22,19,23,19],[22,22,22,27],[22,17,23,17],[22,18,23,18],[22,16,23,16],[18,0,18,6],[22,0,22,6],[22,14,23,14],[22,15,23,15],[12,0,12,5],[22,10,23,10],[22,11,23,11],[14,3,14,6],[15,3,15,6],[16,3,16,6],[23,2,23,5],[22,8,23,8],[22,9,23,9],[17,3,17,6],[7,0,9,0],[10,0,10,6],[5,1,5,3],[6,1,6,3],[10,15,10,16],[7,1,9,6],[22,20,23,20],[22,21,23,21],[1,25,1,30],[53,0,53,1],[54,0,54,1],[1,15,1,17],[2,0,2,6],[0,0,1,6],[1,21,1,22],[1,8,1,13],[6,5,6,6],[9,21,9,22],[3,1,3,6],[4,1,4,6],[5,5,5,6],[11,0,11,5]]}
["INTERSECTION EVALUATION (ICE) PROCESS TOOL STAGE 1A",null,null,null,null,null,null,null,"Hide","Hide","Hide","Hide",null,"Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide"]
[null,null,null,null,null,null,null,null,"STAGE 2 SHORTLIST (16 Max)",null,null,null,null,null,null,"Functional Roadway Classification",null,null,null,"Yes/No",null,"Area Context",null,"K-factor",null,"Estimated Turning Fractions"]
["1. PROJECT DATA",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J3),\"\",1)","v":1},{"$f":"_xlfn._xlws.FILTER(IntType,INDIRECT(G24)=\"Yes\",\"\")","v":{"$error":"#NAME?"}},null,null,null,null,null,"-- roadway type --",null,null,null,"--Yes/No--",null,"-- Area Context --",null,{"$f":"VLOOKUP(D14,V4:X8,3,0)","v":0.1},null,"From","To","Code","LT%","TH%","RT%"]
["Project Name:","State University Intersection Study",null,null,null,null,null,null,{"$f":"IF(ISBLANK(J4),\"\",2)","v":2},{"$error":"#NAME?"},null,null,null,null,null,"Freeway/Expressway",null,1,null,"Yes",null,"Urban Core",null,0.12,null,"Principal Arterial","Principal Arterial",11,0.2,0.51,0.28999999999999998]
["Location:","College Town, North Carolina",null,null,null,null,null,null,{"$f":"IF(ISBLANK(J5),\"\",3)","v":3},{"$error":"#NAME?"},null,null,null,null,null,"Principal Arterial",null,2,null,"No",null,"Urban",null,0.11,null,"Principal Arterial","Minor Arterial",12,0.14000000000000001,0.77,0.09]
["Major Road:","University Avenue",null,null,"Analyst:","Kittelson",null,null,{"$f":"IF(ISBLANK(J6),\"\",4)","v":4},{"$error":"#NAME?"},null,null,null,null,null,"Minor Arterial",null,3,null,null,null,"Suburban",null,0.1,null,"Principal Arterial","Major Collector",13,0.09,0.82,0.09]
["Crossing Street:","College Avenue",null,null,"Analysis Date:","2023-02-15",null,null,{"$f":"IF(ISBLANK(J7),\"\",5)","v":5},{"$error":"#NAME?"},null,null,null,null,null,"Collector",null,4,null,null,null,"Rural Town",null,0.09,null,"Principal Arterial","Local Road",14,0.06,0.92,0.02]
["Brief Description of Project Purpose:","[Provide brief description: 140 Characters Max]",null,null,null,null,null,null,{"$f":"IF(ISBLANK(J8),\"\",6)","v":6},{"$error":"#NAME?"},null,null,null,null,null,"Local Road",null,5,null,null,null,"Rural",null,0.08,null,"Principal Arterial","Principal Arterial",21,0.32,0.4,0.28000000000000003]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J9),\"\",7)","v":7},{"$error":"#NAME?"},null,null,null,null,null,"Crossing Road Code",null,{"$f":"VALUE(CONCATENATE(VLOOKUP(C22,P4:R7,3,0),VLOOKUP(C21,P4:R7,3,0)))","v":42},null,null,null,null,null,null,null,"Minor Arterial","Minor Arterial",22,0.22,0.59,0.19]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J10),\"\",8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Lane Adj Factor",null,null,null,"Minor Arterial","Major Collector",23,0.19,0.73,0.08]
["2. PROJECT CONTEXT",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J11),\"\",9)","v":""},null,null,null,null,null,null,"Peak Period",null,null,null,null,null,1,1,null,null,"Minor Arterial","Local Road",24,0.11,0.4,0.49]
["Is an interchange form present or viable given the local context?",null,null,null,null,null,"No",null,{"$f":"IF(ISBLANK(J12),\"\",10)","v":""},null,null,null,null,null,null,1,"AM Peak",null,null,null,null,2,1.81,null,null,"Major Collector","Principal Arterial",31,0.43,0.23,0.34]
["Is a grade separation form present or viable given the local context?",null,null,null,null,null,"Yes",null,{"$f":"IF(ISBLANK(J13),\"\",11)","v":""},null,null,null,null,null,null,2,"PM Peak",null,null,null,null,3,2.67,null,null,"Major Collector","Minor Arterial",32,0.34,0.33,0.33]
["What is surrounding intersection area context?",null,null,"Suburban","Number of intersection legs?",null,4,null,{"$f":"IF(ISBLANK(J14),\"\",12)","v":""},null,null,null,null,null,null,3,"Mid Day",null,null,null,null,4,3.5,null,null,"Major Collector","Major Collector",33,0.2,0.57999999999999996,0.22]
["What travel modes are present (or likely to be present) at the study location?",null,null,"[Provide short answer: 225 characters max]",null,null,null,null,{"$f":"IF(ISBLANK(J15),\"\",13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"MajLF",{"$f":"VLOOKUP(E21,V11:W14,2,0)","v":1.81},null,null,"Major Collector","Local Road",34,0.35,0.55000000000000004,0.1]
["What are the likely travel needs for users of each mode?",null,null,"[Provide short answer: 225 characters max]",null,null,null,null,{"$f":"IF(ISBLANK(J16),\"\",14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"MinLF",{"$f":"VLOOKUP(E22,V11:W14,2,0)","v":1},null,null,"Local Road","Principal Arterial",41,0.42,0.09,0.49]
["How have the surrounding neighborhoods and major road developed over time?",null,null,"[Provide short answer: 225 characters max]",null,null,null,null,{"$f":"IF(ISBLANK(J17),\"\",15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Road","Minor Arterial",42,0.75,0.02,0.23]
["What are the surrounding land-uses? Do they differ by side of the road? ",null,null,"[Provide short answer: 225 characters max]",null,null,null,null,{"$f":"IF(ISBLANK(J18),\"\",15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Road","Major Collector",43,0.14000000000000001,0.61,0.25]
["3. ROADWAY DATA",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J19),\"\",16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Road","Local Road",44,0.3,0.4,0.3]
["Roadway Name",null,"Functional Class",null,"Lanes","AADT","Right-of-Way"]
[{"$f":"Intersection","v":"University Avenue"},null,"Principal Arterial",null,2,12000,100]
[{"$f":"B7","v":"College Avenue"},null,"Collector",null,1,5000,50,null,null,null,null,null,"Exceeds Capacity? Check","Too Much Capacity? Check"]
["4. INTERSECTION FEASIBILITY",null,null,null,null,null,null,null,"Major Street AADT/lane","AADT/lane at Failure","Minor Street AADT/lane","AADT/lane at Failure",null,null,"Min Maj ST ROW","Exclusion Factor 1","Exclusion Factor 2","Exclusion Factor 3","Exclusion Factor 4-5","Proceed Factor 6-7","Proceed Factor 8","Cost","  MAJOR STREET NUMBER OF APPROACH THROUGH LANES",null,null,null,null,null,"  MINOR STREET NUMBER OF APPROACH THROUGH LANES"]
["Intersection Type",null,"Recommendations for Further Study",null,null,null,"Shortlist?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACILITY",1,2,3,4,5,null,1,2,3]
["All-Way Stop (AWS)",null,{"$f":"IF(P25<>0,VLOOKUP(P25,$I$57:$J$64,2,0),IF(Q25<>0,VLOOKUP(Q25,$I$57:$J$64,2,0),IF(R25<>0,VLOOKUP(R25,$I$57:$J$64,2,0),IF(S25<>0,VLOOKUP(S25,$I$57:$J$64,2,0),IF(T25<>0,VLOOKUP(T25,$I$57:$J$64,2,0),IF(U25<>0,VLOOKUP(U25,$I$57:$J$64,2,0),\"Consider in Stage 2 Analysis\"))))))","v":"Infeasible due to volumes exceeding intersection capacity"},null,null,null,{"$f":"IF(SUM(P25:U25)=0,\"Yes\",IF(SUM(P25:S25)=0,\"--Yes/No--\",\"No\"))","v":"No"},null,{"$f":"AADT_Maj","v":12000},{"$f":"VLOOKUP(A25,$A$25:$AB$40,($E$21+23),0)","v":7775},{"$f":"AADT_Min","v":5000},{"$f":"VLOOKUP(A25,$A$25:$AH$40,($E$22+29),0)","v":7775},{"$f":"IF(AND(I25<J25,K25<L25),0,1)","v":1},{"$f":"IF(AND(I25<J25*$O$22,K25<L25*$O$22),1,0)","v":0},null,0,0,0,{"$f":"IF(M25=1,4,IF(N25=1,5,0))","v":4},0,0,"$",{"$f":"A25","v":"All-Way Stop (AWS)"},7775,{"$f":"X25","v":7775},{"$f":"Y25","v":7775},7775,7775,{"$f":"A25","v":"All-Way Stop (AWS)"},7775,{"$f":"AD25","v":7775},{"$f":"AE25","v":7775}]
["Minor Street Stop (TWSC)",null,{"$f":"IF(P26<>0,VLOOKUP(P26,$I$57:$J$64,2,0),IF(Q26<>0,VLOOKUP(Q26,$I$57:$J$64,2,0),IF(R26<>0,VLOOKUP(R26,$I$57:$J$64,2,0),IF(S26<>0,VLOOKUP(S26,$I$57:$J$64,2,0),IF(T26<>0,VLOOKUP(T26,$I$57:$J$64,2,0),IF(U26<>0,VLOOKUP(U26,$I$57:$J$64,2,0),\"Consider in Stage 2 Analysis\"))))))","v":"Consider in Stage 2 Analysis"},null,null,null,{"$f":"IF(SUM(P26:U26)=0,\"Yes\",IF(SUM(P26:S26)=0,\"--Yes/No--\",\"No\"))","v":"Yes"},null,12000,{"$f":"VLOOKUP(A26,$A$25:$AB$40,($E$21+23),0)","v":15748},5000,{"$f":"VLOOKUP(A26,$A$25:$AH$40,($E$22+29),0)","v":9513},{"$f":"IF(AND(I26<J26,K26<L26),0,1)","v":0},0,null,0,0,0,0,0,0,"$",{"$f":"A26","v":"Minor Street Stop (TWSC)"},12400,15748,19824,{"$f":"Z26","v":19824},{"$f":"Z26","v":19824},{"$f":"A26","v":"Minor Street Stop (TWSC)"},9513,12824,{"$f":"AE26","v":12824}]
["Traffic Signal",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,29610,5000,14950,0,0,null,0,0,0,0,0,0,"$","Traffic Signal",{"$f":"15870","v":15870},29610,40314,53752,68500,"Traffic Signal",14950,26220,36350]
["Mini Roundabout",null,"Infeasible due to volumes exceeding intersection capacity",null,null,null,"No",null,12000,9074,5000,9074,1,0,null,0,0,0,4,0,0,"$","Mini Roundabout",9074,{"$f":"X28","v":9074},{"$f":"Y28","v":9074},9074,9074,"Mini Roundabout",9074,12580,{"$f":"AD28","v":9074}]
["Single Lane Roundabout",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,14800,5000,10675,0,0,null,0,0,0,0,0,0,"$","Single Lane Roundabout",14800,{"$f":"X29","v":14800},{"$f":"Y29","v":14800},14800,14800,"Single Lane Roundabout",10675,{"$f":"AD29","v":10675},{"$f":"AE29","v":10675}]
["Multilane Roundabout",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,20965,5000,10780,0,0,null,0,0,0,0,0,0,"$$","Multilane Roundabout",15566,20965,{"$f":"Y30","v":20965},{"$f":"Z30","v":20965},20965,"Multilane Roundabout",10780,20352,{"$f":"AE30","v":20352}]
["Bowtie Intersection",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,28750,5000,14053,0,0,null,0,0,0,0,0,0,"$$","Bowtie Intersection",15200,28750,40875,55148,{"$f":"AA31","v":55148},"Bowtie Intersection",14053,28376,28376]
["RCUT / J-Turn (stop control)",null,"Caution: Intersection type may not fit within current ROW",null,null,null,"--Yes/No--",null,12000,24165.5,5000,11945.05,0,0,150,0,0,0,0,{"$f":"IF($G$21<O32,6,0)","v":6},{"$f":"IF(OR($D$14=\"Dense Urban\",$D$14=\"Urban\"),8,0)","v":0},"$$","RCUT / J-Turn (stop control)",{"$f":"0.85*X33","v":12325},{"$f":"0.85*Y33","v":24165.5},28903.399999999998,45390,61625,"RCUT / J-Turn (stop control)",{"$f":"0.85*AD31","v":11945.05},{"$f":"0.85*AE31","v":24119.599999999999},24119.599999999999]
["RCUT / RCI (signalized)",null,"Caution: Intersection type may not fit within current ROW",null,null,null,"--Yes/No--",null,12000,28430,5000,13568,0,0,150,0,0,0,0,{"$f":"IF($G$21<O33,6,0)","v":6},0,"$$","RCUT / RCI (signalized)",{"$f":"AB33/5","v":14500},{"$f":"28430","v":28430},34004,53400,72500,"RCUT / RCI (signalized)",13568,26509,28800]
["Partial Median U-Turn",null,"Caution: Intersection type may not fit within current ROW",null,null,null,"--Yes/No--",null,12000,24100,5000,13775,0,0,150,0,0,0,0,6,0,"$$","Partial Median U-Turn",14000,24100,35454,45713,{"$f":"AA34","v":45713},"Partial Median U-Turn",13775,20831,{"$f":"AE34","v":20831}]
["Full Median U-Turn",null,"Caution: Intersection type may not fit within current ROW",null,null,null,"--Yes/No--",null,12000,30160,5000,15330,0,0,150,0,0,0,0,6,0,"$$","Full Median U-Turn",16000,30160,40830,61900,79000,"Full Median U-Turn",15330,24740,34800]
["Partial Displaced Left Turn (DLT)",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,30580,5000,15853,0,0,null,0,0,0,0,0,0,"$$","Partial Displaced Left Turn (DLT)",16000,30580,44985,56344,{"$f":"AA36","v":56344},"Partial Displaced Left Turn (DLT)",15853,27203,{"$f":"AE36","v":27203}]
["Full DLT",null,"Consider in Stage 2 Analysis",null,null,null,"Yes",null,12000,38225,5000,19816.25,0,0,null,0,0,0,0,0,0,"$$","Full DLT",{"$f":"1.25*X36","v":20000},{"$f":"1.25*Y36","v":38225},56231.25,70430,{"$f":"AA37","v":70430},"Full DLT",{"$f":"1.25*AD36","v":19816.25},{"$f":"1.25*AE36","v":34003.75},{"$f":"AE37","v":34003.75}]
["Quadrant Roadway",null,"Caution: Intersection type may impact ROW in quadrants",null,null,null,"--Yes/No--",null,12000,32950,5000,16047,0,0,null,0,0,0,0,7,0,"$$","Quadrant Roadway",16400,32950,49404,58860,{"$f":"AA38","v":58860},"Quadrant Roadway",16047,31557,31557]
["Jughandle",null,"Caution: Intersection type may impact ROW in quadrants",null,null,null,"--Yes/No--",null,12000,20250,5000,8872,0,0,null,0,0,0,0,7,{"$f":"IF(OR($D$14=\"Dense Urban\",$D$14=\"Urban\"),8,0)","v":0},"$$","Jughandle",12920,20250,25755,30160,{"$f":"AA39","v":30160},"Jughandle",8872,14040,14040]
["Continuous Green-T",null,"Infeasible due to the number of intersection legs",null,null,null,"No",null,12000,22207.5,5000,11212.5,0,0,null,0,0,{"$f":"IF(G14<>3,3,0)","v":3},0,0,0,"$","Continuous Green-T",{"$f":"X27*0.75","v":11902.5},{"$f":"Y27*0.75","v":22207.5},30235.5,40314,51375,"Continuous Green-T",{"$f":"0.75*AD27","v":11212.5},{"$f":"0.75*AE27","v":19665},27262.5]
["Split Intersection",null,"Infeasible due to volumes not requiring intersection type",null,null,null,"No",null,null,null,null,null,null,{"$f":"IF($F$21>$J$30,0,1)","v":1},null,0,{"$f":"IF($G$13=\"No\",2,0)","v":0},0,5,7,{"$f":"IF(OR($D$14=\"Dense Urban\",$D$14=\"Urban\"),8,0)","v":0},"$$$"]
["Echelon Grade Separation",null,"Infeasible due to volumes not requiring intersection type",null,null,null,"No",null,null,null,null,null,null,{"$f":"IF($F$21>$J$30,0,1)","v":1},null,0,{"$f":"IF($G$13=\"No\",2,0)","v":0},0,5,0,0,"$$$$"]
["Center Turn Overpass",null,"Infeasible due to volumes not requiring intersection type",null,null,null,"No",null,null,null,null,null,null,1,null,0,{"$f":"IF($G$13=\"No\",2,0)","v":0},0,5,0,0,"$$$$"]
["Single Quadrant Grade Separation",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,{"$f":"IF($G$12=\"No\",1,0)","v":1},0,0,5,{"$f":"IF($G$21<O44,6,7)","v":7},0,"$$$$"]
["Diamond Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Parclo A",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,7,0,"$$$$"]
["Parclo B",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,7,0,"$$$$"]
["Diverging Diamond",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Contraflow Left Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Single Point Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Single Roundabout Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Double Roundabout Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Displaced Left Interchange",null,"Infeasible due to non-interchange context",null,null,null,"No",null,null,null,null,null,null,1,null,1,0,0,5,0,0,"$$$$"]
["Other (User Defined)",null,{"$f":"IF(G54=\"Yes\",\"Consider in Stage 2 Analysis\",\"\")","v":""},null,null,null,"--Yes/No--"]
["Other (User Defined)",null,{"$f":"IF(G55=\"Yes\",\"Consider in Stage 2 Analysis\",\"\")","v":""},null,null,null,"--Yes/No--"]
[]
[null,null,null,null,null,null,null,null,1,"Infeasible due to non-interchange context"]
[null,null,null,null,null,null,null,null,2,"Infeasible due to non-grade separation interchange context"]
[null,null,null,null,null,null,null,null,3,"Infeasible due to the number of intersection legs"]
[null,null,null,null,null,null,null,null,4,"Infeasible due to volumes exceeding intersection capacity"]
[null,null,null,null,null,null,null,null,5,"Infeasible due to volumes not requiring intersection type"]
[null,null,null,null,null,null,null,null,6,"Caution: Intersection type may not fit within current ROW"]
[null,null,null,null,null,null,null,null,7,"Caution: Intersection type may impact ROW in quadrants"]
[null,null,null,null,null,null,null,null,8,"Caution: Intersection may not be feasible in given area type"]

{"sheet":"Stage1B","index":5,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,1,68,9],[42,1,42,9],[25,1,25,9],[7,3,7,5],[7,6,7,7],[7,8,8,8],[8,11,8,14],[5,11,5,13],[6,11,6,12],[0,0,8,0],[6,1,6,9],[0,1,1,9],[7,9,8,9],[2,2,2,9],[3,2,3,9],[4,2,4,9],[5,6,5,7],[5,2,5,5],[5,8,5,9]]}
["Rank by SSI","INTERSECTION EVALUATION TOOL (ICE) PROCESS TOOL STAGE 1B",null,null,null,null,null,null,null,null,null,"Hide","Hide","Hide","Hide","Hide","Hide","Hide"]
[]
[null,"Project Name:",{"$f":"ProjName","v":"State University Intersection Study"}]
[null,"Intersection:",{"$f":"CONCATENATE(Stage1A!B6,\" at \",Stage1A!B7)","v":"University Avenue at College Avenue"}]
[null,"Location:",{"$f":"Location","v":"College Town, North Carolina"},null,null,null,null,null,null,null,null,null,null,null,null,null,"ENV"]
[null,"Analyst:",{"$f":"Analyst","v":"Kittelson"},null,null,null,"Study Date:",null,{"$f":"StudyDate","v":"2023-02-15"},null,null,"Max/Min V/C",null,null,null,null,"--select--"]
[null,"5. SCREENING DATA",null,null,null,null,null,null,null,null,null,"Max V/C",null,1,null,null,"No perceived impacts"]
[null,null,null,"Cap-X V/C Results",null,null," Cap-X Bike/Ped Score",null,"Environmental Impacts","SSI      Score",null,null,null,null,null,null,"Needs investigation"]
[null,"Intersection Form",null,{"$f":"Peak_1","v":"AM Peak"},{"$f":"Peak_2","v":"PM Peak"},{"$f":"Peak_3","v":"Mid Day"},"Bike","Ped",null,null,null,"Max V/C Check",null,null,null,null,"Potentially infeasible"]
[{"$f":"IF($J10=\"\",\"\",RANK($J10,$J$10:$J$25,1)+COUNTIF($J$10:$J10,$J10)-1)","v":4},{"$f":"IF(Stage1A!J3<>0,Stage1A!J3,\"\")","v":{"$error":"#NAME?"}},null,0.6,0.7,0.6,3,4.8,"No perceived impacts",90,null,{"$f":"IF(D10>$N$7,1,0)","v":0},{"$f":"IF(E10>$N$7,1,0)","v":0},{"$f":"IF(F10>$N$7,1,0)","v":0},{"$f":"IF(SUM(L10:N10)=0,\"All\",IF(SUM(L10:N10)=1,\"2of3\",IF(SUM(L10:N10)=2,\"1of3\",\"No\")))","v":"All"},null,"Unacceptable impacts"]
[{"$f":"IF($J11=\"\",\"\",RANK($J11,$J$10:$J$25,1)+COUNTIF($J$10:$J11,$J11)-1)","v":1},{"$f":"IF(Stage1A!J4<>0,Stage1A!J4,\"\")","v":{"$error":"#NAME?"}},null,0.9,1.1000000000000001,0.8,4.9000000000000004,3.2,"Needs investigation",65,null,0,1,0,{"$f":"IF(SUM(L11:N11)=0,\"All\",IF(SUM(L11:N11)=1,\"2of3\",IF(SUM(L11:N11)=2,\"1of3\",\"No\")))","v":"2of3"}]
[{"$f":"IF($J12=\"\",\"\",RANK($J12,$J$10:$J$25,1)+COUNTIF($J$10:$J12,$J12)-1)","v":5},{"$f":"IF(Stage1A!J5<>0,Stage1A!J5,\"\")","v":{"$error":"#NAME?"}},null,0.4,0.5,0.4,4.5,4.0999999999999996,"Potentially infeasible",90,null,0,0,0,"All",null,"Yes/No"]
[{"$f":"IF($J13=\"\",\"\",RANK($J13,$J$10:$J$25,1)+COUNTIF($J$10:$J13,$J13)-1)","v":2},{"$f":"IF(Stage1A!J6<>0,Stage1A!J6,\"\")","v":{"$error":"#NAME?"}},null,0.3,0.4,0.3,2,3.7,"No perceived impacts",70,null,0,0,0,"All",null,"Yes"]
[{"$f":"IF($J14=\"\",\"\",RANK($J14,$J$10:$J$25,1)+COUNTIF($J$10:$J14,$J14)-1)","v":3},{"$f":"IF(Stage1A!J7<>0,Stage1A!J7,\"\")","v":{"$error":"#NAME?"}},null,0.4,0.5,0.4,4,2.9,"Potentially infeasible",75,null,0,0,0,"All",null,"No"]
[{"$f":"IF($J15=\"\",\"\",RANK($J15,$J$10:$J$25,1)+COUNTIF($J$10:$J15,$J15)-1)","v":""},{"$f":"IF(Stage1A!J8<>0,Stage1A!J8,\"\")","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J16=\"\",\"\",RANK($J16,$J$10:$J$25,1)+COUNTIF($J$10:$J16,$J16)-1)","v":""},{"$f":"IF(Stage1A!J9<>0,Stage1A!J9,\"\")","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J17=\"\",\"\",RANK($J17,$J$10:$J$25,1)+COUNTIF($J$10:$J17,$J17)-1)","v":""},{"$f":"IF(Stage1A!J10<>0,Stage1A!J10,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All",null,"99,190,123"]
[{"$f":"IF($J18=\"\",\"\",RANK($J18,$J$10:$J$25,1)+COUNTIF($J$10:$J18,$J18)-1)","v":""},{"$f":"IF(Stage1A!J11<>0,Stage1A!J11,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All",null,"255,235,132"]
[{"$f":"IF($J19=\"\",\"\",RANK($J19,$J$10:$J$25,1)+COUNTIF($J$10:$J19,$J19)-1)","v":""},{"$f":"IF(Stage1A!J12<>0,Stage1A!J12,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All",null,"251,170,119"]
[{"$f":"IF($J20=\"\",\"\",RANK($J20,$J$10:$J$25,1)+COUNTIF($J$10:$J20,$J20)-1)","v":""},{"$f":"IF(Stage1A!J13<>0,Stage1A!J13,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All",null,"248,105,107"]
[{"$f":"IF($J21=\"\",\"\",RANK($J21,$J$10:$J$25,1)+COUNTIF($J$10:$J21,$J21)-1)","v":""},{"$f":"IF(Stage1A!J14<>0,Stage1A!J14,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J22=\"\",\"\",RANK($J22,$J$10:$J$25,1)+COUNTIF($J$10:$J22,$J22)-1)","v":""},{"$f":"IF(Stage1A!J15<>0,Stage1A!J15,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J23=\"\",\"\",RANK($J23,$J$10:$J$25,1)+COUNTIF($J$10:$J23,$J23)-1)","v":""},{"$f":"IF(Stage1A!J16<>0,Stage1A!J16,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J24=\"\",\"\",RANK($J24,$J$10:$J$25,1)+COUNTIF($J$10:$J24,$J24)-1)","v":""},{"$f":"IF(Stage1A!J17<>0,Stage1A!J17,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[{"$f":"IF($J25=\"\",\"\",RANK($J25,$J$10:$J$25,1)+COUNTIF($J$10:$J25,$J25)-1)","v":""},{"$f":"IF(Stage1A!J18<>0,Stage1A!J18,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,0,0,"All"]
[null,"6. SHORTLIST "]
[null,"Intersection Form",null,"SSI       Score","Period Max V/C met","Bike Score","Ped Score","Cost","Environ Feasibility","Proceed"]
[{"$f":"MAX(A10:A25)","v":5},{"$f":"IFERROR(VLOOKUP(A28,$A$10:$J$25,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(A28,$A$10:$J$25,10,0),\"\")","v":90},{"$f":"IFERROR(VLOOKUP(A28,$A$10:$O$25,15,0),\"\")","v":"All"},{"$f":"IFERROR(VLOOKUP(A28,$A$10:$J$25,7,0),\"\")","v":4.5},{"$f":"IFERROR(VLOOKUP(A28,$A$10:$J$25,8,0),\"\")","v":4.0999999999999996},{"$f":"IFERROR(VLOOKUP(B28,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A28,$A$10:$J$25,9,0),\"\")","v":"Potentially infeasible"},"Yes"]
[{"$f":"A28-1","v":4},"",null,{"$f":"IFERROR(VLOOKUP(A29,$A$10:$J$25,10,0),\"\")","v":90},"All",3,{"$f":"IFERROR(VLOOKUP(A29,$A$10:$J$25,8,0),\"\")","v":4.8},{"$f":"IFERROR(VLOOKUP(B29,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A29,$A$10:$J$25,9,0),\"\")","v":"No perceived impacts"},"No"]
[{"$f":"A29-1","v":3},"",null,75,"All",4,{"$f":"IFERROR(VLOOKUP(A30,$A$10:$J$25,8,0),\"\")","v":2.9},{"$f":"IFERROR(VLOOKUP(B30,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},"Potentially infeasible","Yes"]
[2,"",null,70,"All",2,{"$f":"IFERROR(VLOOKUP(A31,$A$10:$J$25,8,0),\"\")","v":3.7},{"$f":"IFERROR(VLOOKUP(B31,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},"No perceived impacts","Yes"]
[1,"",null,65,"2of3",4.9000000000000004,{"$f":"IFERROR(VLOOKUP(A32,$A$10:$J$25,8,0),\"\")","v":3.2},{"$f":"IFERROR(VLOOKUP(B32,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},"Needs investigation","Yes"]
[0,"",null,"","","",{"$f":"IFERROR(VLOOKUP(A33,$A$10:$J$25,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B33,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-1,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B34,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-2,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B35,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-3,"",null,"","","",{"$f":"IFERROR(VLOOKUP(A36,$A$10:$J$25,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B36,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-4,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B37,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-5,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B38,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-6,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B39,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-7,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B40,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-8,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B41,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[-9,"",null,"","","","",{"$f":"IFERROR(VLOOKUP(B42,Stage1A!$A$23:'Stage1A'!$V$53,22,0),\"\")","v":""},""]
[null,"Factors Considered in Excluding Alternatives from Shortlist:"]
[null,"Shortlisted Alternatives for Stage 2 Analysis"]
[null,{"$f":"_xlfn._xlws.FILTER(IntType2,INDIRECT(J27)=\"Yes\",\"\")","v":{"$error":"#NAME?"}}]
[null,{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Describe why alternatives were not shortlisted"]

{"sheet":"Stage2","index":6,"n_rows":90,"n_cols":27,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,22,1,23],[4,7,6,8],[6,5,6,6],[1,0,2,17],[3,7,3,8],[3,1,3,6],[4,1,4,6],[5,1,5,6],[3,9,3,17],[4,9,6,17],[6,1,6,3],[30,0,30,1],[21,17,22,17],[33,3,33,17],[52,5,52,8],[1,19,1,20],[14,0,16,0],[8,1,10,6],[8,7,8,17],[9,7,19,17],[7,0,7,17],[27,0,27,1],[28,0,28,1],[8,0,10,0],[11,0,13,0],[17,0,19,0],[21,15,21,16],[58,5,58,8],[20,0,20,17],[21,4,21,6],[21,3,22,3],[21,7,21,9],[21,10,21,11],[21,12,21,13],[21,14,22,14],[32,0,32,17],[34,0,45,17],[53,9,53,11],[29,0,29,1],[31,0,31,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[21,2,22,2],[21,0,22,1],[11,1,13,6],[14,1,16,6],[17,1,19,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide","Hide","Hide","Hide","Hide","Hide","Hide","Hide"]
["INTERSECTION EVALUATION TOOL (ICE) PROCESS TOOL STAGE 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stakeholder Support",null,null,"Stakeholder Support",null,null,"99,190,123"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Strong",null,1,"Yes",null,"196,215,155"]
["Project Name:",{"$f":"ProjName","v":"State University Intersection Study"},null,null,null,null,null,"Review Mtg Date:",null,"2023-02-22",null,null,null,null,null,null,null,null,null,2,"Supportive",null,2,"No",null,"255,235,132"]
["Intersection:",{"$f":"Stage1B!C4","v":"University Avenue at College Avenue"},null,null,null,null,null,"Review Meeting Attendees (List):",null,"Joe Smith - Town Manager; Steve Jones - DOT Representative; Guy Smiley - Consultant",null,null,null,null,null,null,null,null,null,3,"Unknown",null,3,"Partially",null,"251,170,119"]
["Location:",{"$f":"Location","v":"College Town, North Carolina"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Negative",null,null,null,null,"248,105,107"]
["Analyst:",{"$f":"Analyst","v":"Kittelson"},null,null,"Date:",{"$f":"StudyDate","v":"2023-02-15"},null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Opposition"]
["7. CONTEXT & EQUITY SUMMARY"]
["Study area travel modes present and/or likely:",{"$f":"Stage1A!D15","v":"[Provide short answer: 225 characters max]"},null,null,null,null,null,"Summary of Equity Studies (from Equity Worksheet):"]
[null,null,null,null,null,null,null,"[Summary of Equity Study Results]"]
[]
["Travel needs for transporation mode(s):",{"$f":"Stage1A!D16","v":"[Provide short answer: 225 characters max]"}]
[]
[]
["History of neighborhood & road development:",{"$f":"Stage1A!D17","v":"[Provide short answer: 225 characters max]"}]
[]
[]
["Surrounding land uses / roadside development:",{"$f":"Stage1A!D18","v":"[Provide short answer: 225 characters max]"}]
[]
[]
["8. SELECTION CRITERIA"]
["Intersection Form",null,"Meets Equity Goals?","Stakeholder Support","Average Vehicle Delay",null,null,"Worst Vehicle Delay",null,null,"20-Flag Results",null,"Predictive Safety",null,"Construction Cost","Life Cycle Costs",null,"Environmental Feasibility"]
[null,null,null,null,{"$f":"Peak_1","v":"AM Peak"},{"$f":"Peak_2","v":"PM Peak"},{"$f":"Peak_3","v":"Mid Day"},{"$f":"Peak_1","v":"AM Peak"},{"$f":"Peak_2","v":"PM Peak"},{"$f":"Peak_3","v":"Mid Day"},"Ped","Bike","PDO","Fatal/Inj",null,"Costs","B/C"]
["<--Select Recommended Alternative-->",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(J24,$A$10:$J$25,9,0),\"\")","v":""}]
[{"$f":"IF(Stage1B!B45<>0,Stage1B!B45,\"\")","v":{"$error":"#NAME?"}},null,"Yes","Strong",50,60,55,50,60,55,0.05,0.08,2.2999999999999998,0.8,600000,4500000,{"$f":"O25/P25","v":0.13333333333333333},{"$f":"IF(A25=\"\",\"\",IFERROR(VLOOKUP(A25,Stage1B!$B$10:$J$25,8,0),\"\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(Stage1B!B46<>0,Stage1B!B46,\"\")","v":{"$error":"#NAME?"}},null,"No","Opposition",45,55,50,45,55,50,0.1,0.25,2.5,0.9,700000,5000000,{"$f":"O26/P26","v":0.14000000000000001},{"$f":"IF(A26=\"\",\"\",IFERROR(VLOOKUP(A26,Stage1B!$B$10:$J$25,8,0),\"\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(Stage1B!B47<>0,Stage1B!B47,\"\")","v":{"$error":"#NAME?"}},null,"Partially","Unknown",40,50,35,45,55,40,0.25,0.4,5.0999999999999996,1.2,300000,12000000,2.5000000000000001E-2,{"$f":"IF(A27=\"\",\"\",IFERROR(VLOOKUP(A27,Stage1B!$B$10:$J$25,8,0),\"\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(Stage1B!B48<>0,Stage1B!B48,\"\")","v":{"$error":"#NAME?"}},null,"Yes","Negative",65,65,50,65,65,50,0.2,0.35,4.7,1,400000,600000,0.66666666666666663,{"$f":"IF(A28=\"\",\"\",IFERROR(VLOOKUP(A28,Stage1B!$B$10:$J$25,8,0),\"\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(Stage1B!B49<>0,Stage1B!B49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A29=\"\",\"\",IFERROR(VLOOKUP(A29,Stage1B!$B$10:$J$25,8,0),\"\"))","v":""}]
[{"$f":"IF(Stage1B!B50<>0,Stage1B!B50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A30=\"\",\"\",IFERROR(VLOOKUP(A30,Stage1B!$B$10:$J$25,8,0),\"\"))","v":""}]
[{"$f":"IF(Stage1B!B53<>0,Stage1B!B53,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A31=\"\",\"\",IFERROR(VLOOKUP(A31,Stage1B!$B$10:$J$25,8,0),\"\"))","v":""}]
[{"$f":"IF(Stage1B!B54<>0,Stage1B!B54,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A32=\"\",\"\",IFERROR(VLOOKUP(A32,Stage1B!$B$10:$J$25,8,0),\"\"))","v":""}]
["9. REVIEW MEETING NOTES AND RECOMMENDATIONS"]
["Recommended Intersection Concept:",null,null,"Multilane Roundabout"]
["Notes from review team meeting:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Vehicle Delay - Intersection"]
["2.3.1",null,"#",null,"Form","Period 1","Period 2",null,"Period 3","Vehicle Delay - Worst Approach"]
[null,null,6,null,"Partial Median U-Turn",50,60,55,null,"Period 1","Period 2","Period 3"]
[null,null,5,null,"RCUT / RCI (signalized)",45,55,50,null,50,60,55]
[null,null,1,null,"Traffic Signal",70,80,75,null,45,55,50]
[null,null,null,null,null,null,null,null,null,70,80,75]
[null,null,null,null,null,"20-Flag Results"]
["2.3.2",null,"#",null,"Form","Ped","Bike"]
[null,null,6,null,"Partial Median U-Turn",0.05,0.08]
[null,null,5,null,"RCUT / RCI (signalized)",0.1,0.25]
[null,null,1,null,"Traffic Signal",0.25,0.4]
[]
[]
[null,null,null,null,null,"Veh. Safety"]
["2.3.3",null,"#",null,"Form","PDO","Fatal/Injury"]
[null,null,6,null,"Partial Median U-Turn",2.2999999999999998,0.8]
[null,null,5,null,"RCUT / RCI (signalized)",2.5,0.9]
[null,null,1,null,"Traffic Signal",5.0999999999999996,1.2]
[]
[]
[]
["2.3.4",null,"#",null,"Form","Const. Cost"]
[null,null,6,null,"Partial Median U-Turn",600000]
[null,null,5,null,"RCUT / RCI (signalized)",700000]
[null,null,1,null,"Traffic Signal",300000]
[]
[]
[null,null,null,null,null,"Life Cycle Cost"]
["2.3.5",null,"#",null,"Form","NPV $$","B/C"]
[null,null,6,null,"Partial Median U-Turn",4500000,1.2]
[null,null,5,null,"RCUT / RCI (signalized)",5000000,1.1000000000000001]
[null,null,1,null,"Traffic Signal",12000000,0.5]
[]
[]
["2.3.6",null,"#",null,"Form","Compatible with Env. Features/Constraints","Compatible with Context/Equity",null,"Stakeholder Outreach Results"]
[null,null,6,null,"Partial Median U-Turn","No","Yes",null,"OK"]
[null,null,5,null,"RCUT / RCI (signalized)","Yes","Yes",null,"OK"]
[null,null,1,null,"Traffic Signal","Yes","No",null,"OK"]