{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["scenario 2 template","scenario 2 formulas","scenario 2 example 12","scenario 2 example 13","scenario 2 example 23","scenario 2 example 24"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"scenario 2 template","index":0,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[20,1,22,1],[2,2,2,5],[2,6,2,9],[16,2,16,5],[16,6,16,9],[17,1,19,1],[26,1,29,1],[29,3,29,5],[29,7,29,9],[30,1,33,1],[33,3,33,5],[33,7,33,9],[47,10,47,11],[47,14,47,15],[60,1,60,6],[38,2,38,3],[38,4,38,5],[39,1,44,1],[39,7,42,7],[42,9,42,11],[42,13,42,15],[43,7,46,7],[45,1,50,1],[46,9,46,11],[46,13,46,15]]}
["CMA computational engine - scenario 2"]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",null,"v2",null,"v3",null,"v4"]
[null,"Ring 2","v5",null,"v6",null,"v7",null,"v8"]
[]
["LT phasing, EW concurrency group"]
["LT phasing, NS concurrency group"]
["Cycle length",null,"sec"]
["Lost time per phase",null,"sec"]
["Saturation flow rate, TH",null,"veh/hr"]
["Saturation flow rate, protected LT",null,"veh/hr"]
["Saturation flow rate, permitted LT",null,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",null,"v2",null,"v3",null,"v4"]
[null,null,"s1",null,"s2",null,"s3",null,"s4"]
[null,null,"Y1",null,"Y2",null,"Y3",null,"Y4"]
[null,"Ring 2","v5",null,"v6",null,"v7",null,"v8"]
[null,null,"s5",null,"s6",null,"s7",null,"s8"]
[null,null,"Y5",null,"Y6",null,"Y7",null,"Y8"]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of permitted LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",null,"v2",null,"v3",null,"v4"]
[null,null,"s1",null,"s2",null,"s3",null,"s4"]
[null,null,"Y1",null,"Y2",null,"Y3",null,"Y4"]
[null,null,"YEW1",null,null,null,"YNS1"]
[null,"Ring 2","v5",null,"v6",null,"v7",null,"v8"]
[null,null,"s5",null,"s6",null,"s7",null,"s8"]
[null,null,"Y5",null,"Y6",null,"Y7",null,"Y8"]
[null,null,"YEW2",null,null,null,"YNS2"]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Permitted\",D18,\"\")","v":""},"v3",{"$f":"IF(B7=\"Permitted\",H18,\"\")","v":""},null,"Ring 1","v1",null,"v2",null,"v3",null,"v4"]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",D19,\"\")","v":""},"s3",{"$f":"IF(B7=\"Permitted\",H19,\"\")","v":""},null,null,"s1",null,"s2",null,"s3",null,"s4"]
[null,null,"Y1",{"$f":"IF(B7=\"Permitted\",D40/D41,\"\")","v":""},"Y3",{"$f":"IF(B7=\"Permitted\",F40/F41,\"\")","v":""},null,null,"Y1",null,"Y2",null,"Y3",null,"Y4"]
[null,null,"v2",{"$f":"IF(B7=\"Permitted\",F18,\"\")","v":""},"v4",{"$f":"IF(B7=\"Permitted\",J18,\"\")","v":""},null,null,"YEW1",null,null,null,"YNS1"]
[null,null,"s2",{"$f":"IF(B7=\"Permitted\",F19,\"\")","v":""},"s4",{"$f":"IF(B7=\"Permitted\",J19,\"\")","v":""},null,"Ring 2","v5",null,"v6",null,"v7",null,"v8"]
[null,null,"Y2",{"$f":"IF(B7=\"Permitted\",D43/D44,\"\")","v":""},"Y4",{"$f":"IF(B7=\"Permitted\",F43/F44,\"\")","v":""},null,null,"s5",null,"s6",null,"s7",null,"s8"]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Permitted\",D21,\"\")","v":""},"v7",{"$f":"IF(B7=\"Permitted\",H21,\"\")","v":""},null,null,"Y5",null,"Y6",null,"Y7",null,"Y8"]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",D22,\"\")","v":""},"s7",{"$f":"IF(B7=\"Permitted\",H22,\"\")","v":""},null,null,"YEW2",null,null,null,"YNS2"]
[null,null,"Y5",{"$f":"IF(B7=\"Permitted\",D46/D47,\"\")","v":""},"Y7",{"$f":"IF(B7=\"Permitted\",F46/F47,\"\")","v":""},null,null,null,"YEW-critical",null,null,null,"YNS-critical"]
[null,null,"v6",{"$f":"IF(B7=\"Permitted\",F21,\"\")","v":""},"v8",{"$f":"IF(B7=\"Permitted\",J21,\"\")","v":""}]
[null,null,"s6",{"$f":"IF(B7=\"Permitted\",F22,\"\")","v":""},"s8",{"$f":"IF(B7=\"Permitted\",J22,\"\")","v":""}]
[null,null,"Y6",{"$f":"IF(B7=\"Permitted\",D49/D50,\"\")","v":""},"Y8",{"$f":"IF(B7=\"Permitted\",F49/F50,\"\")","v":""}]
[null,null,"YEW-critical",{"$f":"IF(B7=\"Permitted\",MAX(D42,D45,D48,D51),\"\")","v":""},"YNS-critical",{"$f":"IF(B7=\"Permitted\",MAX(F42,F45,F48,F51),\"\")","v":""}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection."]
["YEW-critical"]
["YNS-critical"]
["Lost time"]
["Xc"]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity"," "]

{"sheet":"scenario 2 formulas","index":1,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,1,60,6],[38,2,38,3],[38,4,38,5],[38,8,38,11],[38,12,38,15],[39,1,44,1],[39,7,42,7],[42,9,42,11],[42,13,42,15],[43,7,46,7],[45,1,50,1],[46,9,46,11],[46,13,46,15],[47,10,47,11],[47,14,47,15],[30,1,33,1],[33,3,33,5],[33,7,33,9],[2,2,2,5],[2,6,2,9],[16,2,16,5],[16,6,16,9],[17,1,19,1],[20,1,22,1],[25,2,25,5],[25,6,25,9],[26,1,29,1],[29,3,29,5],[29,7,29,9]]}
["CMA computational engine - scenario 2"]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",150,"v2",400,"v3",350,"v4",450]
[null,"Ring 2","v5",200,"v6",400,"v7",300,"v8",600]
[]
["LT phasing, EW concurrency group","Protected",null,null,"LT phasing options"]
["LT phasing, NS concurrency group","Protected",null,null,"Permitted"]
["Cycle length",90,"sec",null,"Protected"]
["Lost time per phase",4,"sec"]
["Saturation flow rate, TH",1900,"veh/hr"]
["Saturation flow rate, protected LT",1900,"veh/hr"]
["Saturation flow rate, permitted LT",450,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"D4","v":150},"v2",{"$f":"F4","v":400},"v3",{"$f":"H4","v":350},"v4",{"$f":"J4","v":450}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":1900},"s2",{"$f":"B11","v":1900},"s3",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":1900},"s4",{"$f":"B11","v":1900}]
[null,null,"Y1",{"$f":"D18/D19","v":7.8947368421052627E-2},"Y2",{"$f":"F18/F19","v":0.21052631578947367},"Y3",{"$f":"H18/H19","v":0.18421052631578946},"Y4",{"$f":"J18/J19","v":0.23684210526315788}]
[null,"Ring 2","v5",{"$f":"D5","v":200},"v6",{"$f":"F5","v":400},"v7",{"$f":"H5","v":300},"v8",{"$f":"J5","v":600}]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":1900},"s6",{"$f":"B11","v":1900},"s7",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":1900},"s8",{"$f":"B11","v":1900}]
[null,null,"Y5",{"$f":"D21/D22","v":0.10526315789473684},"Y6",{"$f":"F21/F22","v":0.21052631578947367},"Y7",{"$f":"H21/H22","v":0.15789473684210525},"Y8",{"$f":"J21/J22","v":0.31578947368421051}]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of protected LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Protected\",D18,\"\")","v":150},"v2",{"$f":"IF(B7=\"Protected\",F18,\"\")","v":400},"v3",{"$f":"IF(B8=\"Protected\",H18,\"\")","v":350},"v4",{"$f":"IF(B8=\"Protected\",J18,\"\")","v":450}]
[null,null,"s1",{"$f":"IF(B7=\"Protected\",D19,\"\")","v":1900},"s2",{"$f":"IF(B7=\"Protected\",F19,\"\")","v":1900},"s3",{"$f":"IF(B8=\"Protected\",H19,\"\")","v":1900},"s4",{"$f":"IF(B8=\"Protected\",J19,\"\")","v":1900}]
[null,null,"Y1",{"$f":"IF(B7=\"Protected\",D20,\"\")","v":7.8947368421052627E-2},"Y2",{"$f":"IF(B7=\"Protected\",F20,\"\")","v":0.21052631578947367},"Y3",{"$f":"IF(B8=\"Protected\",H20,\"\")","v":0.18421052631578946},"Y4",{"$f":"IF(B8=\"Protected\",J20,\"\")","v":0.23684210526315788}]
[null,null,"YEW1",{"$f":"IF(B7=\"Protected\",D29+F29,\"\")","v":0.28947368421052633},null,null,"YNS1",{"$f":"IF(B8=\"Protected\",H29+J29,\"\")","v":0.42105263157894735}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Protected\",D21,\"\")","v":200},"v6",{"$f":"IF(B7=\"Protected\",F21,\"\")","v":400},"v7",{"$f":"IF(B8=\"Protected\",H21,\"\")","v":300},"v8",{"$f":"IF(B8=\"Protected\",J21,\"\")","v":600}]
[null,null,"s5",{"$f":"IF(B7=\"Protected\",D22,\"\")","v":1900},"s6",{"$f":"IF(B7=\"Protected\",F22,\"\")","v":1900},"s7",{"$f":"IF(B8=\"Protected\",H22,\"\")","v":1900},"s8",{"$f":"IF(B8=\"Protected\",J22,\"\")","v":1900}]
[null,null,"Y5",{"$f":"IF(B7=\"Protected\",D23,\"\")","v":0.10526315789473684},"Y6",{"$f":"IF(B7=\"Protected\",F23,\"\")","v":0.21052631578947367},"Y7",{"$f":"IF(B8=\"Protected\",H23,\"\")","v":0.15789473684210525},"Y8",{"$f":"IF(B8=\"Protected\",J23,\"\")","v":0.31578947368421051}]
[null,null,"YEW2",{"$f":"IF(B7=\"Protected\",D33+F33,\"\")","v":0.31578947368421051},null,null,"YNS2",{"$f":"IF(B8=\"Protected\",H33+J33,\"\")","v":0.47368421052631576}]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Permitted\",D18,\"\")","v":""},"v3",{"$f":"IF(B7=\"Permitted\",H18,\"\")","v":""},null,"Ring 1","v1",{"$f":"D27","v":150},"v2",{"$f":"F27","v":400},"v3",{"$f":"H27","v":350},"v4",{"$f":"J27","v":450}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",D19,\"\")","v":""},"s3",{"$f":"IF(B7=\"Permitted\",H19,\"\")","v":""},null,null,"s1",{"$f":"D28","v":1900},"s2",{"$f":"F28","v":1900},"s3",{"$f":"H28","v":1900},"s4",{"$f":"J28","v":1900}]
[null,null,"Y1",{"$f":"IF(B7=\"Permitted\",D40/D41,\"\")","v":""},"Y3",{"$f":"IF(B7=\"Permitted\",F40/F41,\"\")","v":""},null,null,"Y1",{"$f":"D29","v":7.8947368421052627E-2},"Y2",0.21052631578947367,"Y3",{"$f":"H29","v":0.18421052631578946},"Y4",0.23684210526315788]
[null,null,"v2",{"$f":"IF(B7=\"Permitted\",F18,\"\")","v":""},"v4",{"$f":"IF(B7=\"Permitted\",J18,\"\")","v":""},null,null,"YEW1",{"$f":"D30","v":0.28947368421052633},null,null,"YNS1",{"$f":"H30","v":0.42105263157894735}]
[null,null,"s2",{"$f":"IF(B7=\"Permitted\",F19,\"\")","v":""},"s4",{"$f":"IF(B7=\"Permitted\",J19,\"\")","v":""},null,"Ring 2","v5",{"$f":"D31","v":200},"v6",{"$f":"F31","v":400},"v7",{"$f":"H31","v":300},"v8",{"$f":"J31","v":600}]
[null,null,"Y2",{"$f":"IF(B7=\"Permitted\",D43/D44,\"\")","v":""},"Y4",{"$f":"IF(B7=\"Permitted\",F43/F44,\"\")","v":""},null,null,"s5",{"$f":"D32","v":1900},"s6",{"$f":"F32","v":1900},"s7",{"$f":"H32","v":1900},"s8",{"$f":"J32","v":1900}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Permitted\",D21,\"\")","v":""},"v7",{"$f":"IF(B7=\"Permitted\",H21,\"\")","v":""},null,null,"Y5",0.10526315789473684,"Y6",0.21052631578947367,"Y7",0.15789473684210525,"Y8",0.31578947368421051]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",D22,\"\")","v":""},"s7",{"$f":"IF(B7=\"Permitted\",H22,\"\")","v":""},null,null,"YEW2",{"$f":"D34","v":0.31578947368421051},null,null,"YNS2",{"$f":"H34","v":0.47368421052631576}]
[null,null,"Y5",{"$f":"IF(B7=\"Permitted\",D46/D47,\"\")","v":""},"Y7",{"$f":"IF(B7=\"Permitted\",F46/F47,\"\")","v":""},null,null,null,"YEW-critical",{"$f":"IF(B7=\"Protected\",MAX(J43,J47),\"\")","v":0.31578947368421051},null,null,"YNS-critical",{"$f":"IF(B8=\"Protected\",MAX(N43,N47),\"\")","v":0.47368421052631576}]
[null,null,"v6",{"$f":"IF(B7=\"Permitted\",F21,\"\")","v":""},"v8",{"$f":"IF(B7=\"Permitted\",J21,\"\")","v":""}]
[null,null,"s6",{"$f":"IF(B7=\"Permitted\",F22,\"\")","v":""},"s8",{"$f":"IF(B7=\"Permitted\",J22,\"\")","v":""}]
[null,null,"Y6",{"$f":"IF(B7=\"Permitted\",D49/D50,\"\")","v":""},"Y8",{"$f":"IF(B7=\"Permitted\",F49/F50,\"\")","v":""}]
[null,null,"YEW-critical",{"$f":"IF(B7=\"Permitted\",MAX(D42,D45,D48,D51),\"\")","v":""},"YNS-critical",{"$f":"IF(B7=\"Permitted\",MAX(F42,F45,F48,F51),\"\")","v":""}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection.","volume-to-capacity ratio Xc for the intersection.","for the intersection."]
["YEW-critical",{"$f":"IF(B7=\"Protected\",K48,D52)","v":0.31578947368421051}]
["YNS-critical",{"$f":"IF(B7=\"Protected\",O48,F52)","v":0.47368421052631576}]
["Lost time",{"$f":"LostTime(B7,B8)","v":16}]
["Xc",{"$f":"Xc(B55,B56,B9,B57)","v":0.96017069701280233}]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity",{"$f":"IF(B58<0.85,\"Intersection is operating under capacity\",IF(B58<0.95,\"Intersection is operating near capacity\",IF(B58<1,\"Unstable flow results in wide variety of delay\",\"The demand exceeds available capacity of the intersection\")))","v":"Unstable flow results in wide variety of delay"}]

{"sheet":"scenario 2 example 12","index":2,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[26,6,26,9],[39,8,39,11],[39,12,39,15],[30,3,30,5],[26,2,26,5],[61,1,61,6],[3,2,3,5],[3,6,3,9],[39,4,39,5],[34,7,34,9],[30,7,30,9],[17,6,17,9],[40,1,45,1],[46,1,51,1],[39,2,39,3],[18,1,20,1],[21,1,23,1],[31,1,34,1],[17,2,17,5],[34,3,34,5],[27,1,30,1],[48,10,48,11],[48,14,48,15],[40,7,43,7],[43,9,43,11],[43,13,43,15],[44,7,47,7],[47,9,47,11],[47,13,47,15]]}
["CMA computational engine - scenario 2"]
[]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",150,"v2",400,"v3",350,"v4",450]
[null,"Ring 2","v5",200,"v6",400,"v7",300,"v8",600]
[]
["LT phasing, EW concurrency group","Protected",null,null,"LT phasing options"]
["LT phasing, NS concurrency group","Protected",null,null,"Permitted"]
["Cycle length",90,"sec",null,"Protected"]
["Lost time per phase",4,"sec"]
["Saturation flow rate, TH",1900,"veh/hr"]
["Saturation flow rate, protected LT",1900,"veh/hr"]
["Saturation flow rate, permitted LT",450,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"D5","v":150},"v2",{"$f":"F5","v":400},"v3",{"$f":"H5","v":350},"v4",{"$f":"J5","v":450}]
[null,null,"s1",{"$f":"IF(B8=\"Permitted\",B14,B13)","v":1900},"s2",{"$f":"B12","v":1900},"s3",{"$f":"IF(B9=\"Permitted\",B14,B13)","v":1900},"s4",{"$f":"B12","v":1900}]
[null,null,"Y1",{"$f":"D19/D20","v":7.8947368421052627E-2},"Y2",{"$f":"F19/F20","v":0.21052631578947367},"Y3",{"$f":"H19/H20","v":0.18421052631578946},"Y4",{"$f":"J19/J20","v":0.23684210526315788}]
[null,"Ring 2","v5",{"$f":"D6","v":200},"v6",{"$f":"F6","v":400},"v7",{"$f":"H6","v":300},"v8",{"$f":"J6","v":600}]
[null,null,"s5",{"$f":"IF(B8=\"Permitted\",B14,B13)","v":1900},"s6",{"$f":"B12","v":1900},"s7",{"$f":"IF(B9=\"Permitted\",B14,B13)","v":1900},"s8",{"$f":"B12","v":1900}]
[null,null,"Y5",{"$f":"D22/D23","v":0.10526315789473684},"Y6",{"$f":"F22/F23","v":0.21052631578947367},"Y7",{"$f":"H22/H23","v":0.15789473684210525},"Y8",{"$f":"J22/J23","v":0.31578947368421051}]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of protected LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B8=\"Protected\",D19,\"\")","v":150},"v2",{"$f":"IF(B8=\"Protected\",F19,\"\")","v":400},"v3",{"$f":"IF(B9=\"Protected\",H19,\"\")","v":350},"v4",{"$f":"IF(B9=\"Protected\",J19,\"\")","v":450}]
[null,null,"s1",{"$f":"IF(B8=\"Protected\",D20,\"\")","v":1900},"s2",{"$f":"IF(B8=\"Protected\",F20,\"\")","v":1900},"s3",{"$f":"IF(B9=\"Protected\",H20,\"\")","v":1900},"s4",{"$f":"IF(B9=\"Protected\",J20,\"\")","v":1900}]
[null,null,"Y1",{"$f":"IF(B8=\"Protected\",D21,\"\")","v":7.8947368421052627E-2},"Y2",{"$f":"IF(B8=\"Protected\",F21,\"\")","v":0.21052631578947367},"Y3",{"$f":"IF(B9=\"Protected\",H21,\"\")","v":0.18421052631578946},"Y4",{"$f":"IF(B9=\"Protected\",J21,\"\")","v":0.23684210526315788}]
[null,null,"YEW1",{"$f":"IF(B8=\"Protected\",D30+F30,\"\")","v":0.28947368421052633},null,null,"YNS1",{"$f":"IF(B9=\"Protected\",H30+J30,\"\")","v":0.42105263157894735}]
[null,"Ring 2","v5",{"$f":"IF(B8=\"Protected\",D22,\"\")","v":200},"v6",{"$f":"IF(B8=\"Protected\",F22,\"\")","v":400},"v7",{"$f":"IF(B9=\"Protected\",H22,\"\")","v":300},"v8",{"$f":"IF(B9=\"Protected\",J22,\"\")","v":600}]
[null,null,"s5",{"$f":"IF(B8=\"Protected\",D23,\"\")","v":1900},"s6",{"$f":"IF(B8=\"Protected\",F23,\"\")","v":1900},"s7",{"$f":"IF(B9=\"Protected\",H23,\"\")","v":1900},"s8",{"$f":"IF(B9=\"Protected\",J23,\"\")","v":1900}]
[null,null,"Y5",{"$f":"IF(B8=\"Protected\",D24,\"\")","v":0.10526315789473684},"Y6",{"$f":"IF(B8=\"Protected\",F24,\"\")","v":0.21052631578947367},"Y7",{"$f":"IF(B9=\"Protected\",H24,\"\")","v":0.15789473684210525},"Y8",{"$f":"IF(B9=\"Protected\",J24,\"\")","v":0.31578947368421051}]
[null,null,"YEW2",{"$f":"IF(B8=\"Protected\",D34+F34,\"\")","v":0.31578947368421051},null,null,"YNS2",{"$f":"IF(B9=\"Protected\",H34+J34,\"\")","v":0.47368421052631576}]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B8=\"Permitted\",D19,\"\")","v":""},"v3",{"$f":"IF(B8=\"Permitted\",H19,\"\")","v":""},null,"Ring 1","v1",{"$f":"D28","v":150},"v2",{"$f":"F28","v":400},"v3",{"$f":"H28","v":350},"v4",{"$f":"J28","v":450}]
[null,null,"s1",{"$f":"IF(B8=\"Permitted\",D20,\"\")","v":""},"s3",{"$f":"IF(B8=\"Permitted\",H20,\"\")","v":""},null,null,"s1",{"$f":"D29","v":1900},"s2",{"$f":"F29","v":1900},"s3",{"$f":"H29","v":1900},"s4",{"$f":"J29","v":1900}]
[null,null,"Y1",{"$f":"IF(B8=\"Permitted\",D41/D42,\"\")","v":""},"Y3",{"$f":"IF(B8=\"Permitted\",F41/F42,\"\")","v":""},null,null,"Y1",{"$f":"D30","v":7.8947368421052627E-2},"Y2",0.21052631578947367,"Y3",{"$f":"H30","v":0.18421052631578946},"Y4",0.23684210526315788]
[null,null,"v2",{"$f":"IF(B8=\"Permitted\",F19,\"\")","v":""},"v4",{"$f":"IF(B8=\"Permitted\",J19,\"\")","v":""},null,null,"YEW1",{"$f":"D31","v":0.28947368421052633},null,null,"YNS1",{"$f":"H31","v":0.42105263157894735}]
[null,null,"s2",{"$f":"IF(B8=\"Permitted\",F20,\"\")","v":""},"s4",{"$f":"IF(B8=\"Permitted\",J20,\"\")","v":""},null,"Ring 2","v5",{"$f":"D32","v":200},"v6",{"$f":"F32","v":400},"v7",{"$f":"H32","v":300},"v8",{"$f":"J32","v":600}]
[null,null,"Y2",{"$f":"IF(B8=\"Permitted\",D44/D45,\"\")","v":""},"Y4",{"$f":"IF(B8=\"Permitted\",F44/F45,\"\")","v":""},null,null,"s5",{"$f":"D33","v":1900},"s6",{"$f":"F33","v":1900},"s7",{"$f":"H33","v":1900},"s8",{"$f":"J33","v":1900}]
[null,"Ring 2","v5",{"$f":"IF(B8=\"Permitted\",D22,\"\")","v":""},"v7",{"$f":"IF(B8=\"Permitted\",H22,\"\")","v":""},null,null,"Y5",0.10526315789473684,"Y6",0.21052631578947367,"Y7",0.15789473684210525,"Y8",0.31578947368421051]
[null,null,"s5",{"$f":"IF(B8=\"Permitted\",D23,\"\")","v":""},"s7",{"$f":"IF(B8=\"Permitted\",H23,\"\")","v":""},null,null,"YEW2",{"$f":"D35","v":0.31578947368421051},null,null,"YNS2",{"$f":"H35","v":0.47368421052631576}]
[null,null,"Y5",{"$f":"IF(B8=\"Permitted\",D47/D48,\"\")","v":""},"Y7",{"$f":"IF(B8=\"Permitted\",F47/F48,\"\")","v":""},null,null,null,"YEW-critical",{"$f":"IF(B8=\"Protected\",MAX(J44,J48),\"\")","v":0.31578947368421051},null,null,"YNS-critical",{"$f":"IF(B9=\"Protected\",MAX(N44,N48),\"\")","v":0.47368421052631576}]
[null,null,"v6",{"$f":"IF(B8=\"Permitted\",F22,\"\")","v":""},"v8",{"$f":"IF(B8=\"Permitted\",J22,\"\")","v":""}]
[null,null,"s6",{"$f":"IF(B8=\"Permitted\",F23,\"\")","v":""},"s8",{"$f":"IF(B8=\"Permitted\",J23,\"\")","v":""}]
[null,null,"Y6",{"$f":"IF(B8=\"Permitted\",D50/D51,\"\")","v":""},"Y8",{"$f":"IF(B8=\"Permitted\",F50/F51,\"\")","v":""}]
[null,null,"YEW-critical",{"$f":"IF(B8=\"Permitted\",MAX(D43,D46,D49,D52),\"\")","v":""},"YNS-critical",{"$f":"IF(B8=\"Permitted\",MAX(F43,F46,F49,F52),\"\")","v":""}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection."]
["YEW-critical",{"$f":"IF(B8=\"Protected\",K49,D53)","v":0.31578947368421051}]
["YNS-critical",{"$f":"IF(B8=\"Protected\",O49,F53)","v":0.47368421052631576}]
["Lost time",{"$f":"LostTime(B8,B9)","v":16}]
["Xc",{"$f":"Xc(B56,B57,B10,B58)","v":0.96017069701280233}]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity",{"$f":"IF(B59<0.85,\"Intersection is operating under capacity\",IF(B59<0.95,\"Intersection is operating near capacity\",IF(B59<1,\"Unstable flow results in wide variety of delay\",\"The demand exceeds available capacity of the intersection\")))","v":"Unstable flow results in wide variety of delay"}]

{"sheet":"scenario 2 example 13","index":3,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[21,1,23,1],[26,6,26,9],[26,2,26,5],[39,8,39,11],[39,12,39,15],[27,1,30,1],[30,3,30,5],[30,7,30,9],[31,1,34,1],[34,3,34,5],[34,7,34,9],[3,2,3,5],[3,6,3,9],[17,2,17,5],[17,6,17,9],[18,1,20,1],[48,10,48,11],[48,14,48,15],[61,1,61,6],[39,2,39,3],[39,4,39,5],[40,1,45,1],[40,7,43,7],[43,9,43,11],[43,13,43,15],[44,7,47,7],[46,1,51,1],[47,9,47,11],[47,13,47,15]]}
["CMA computational engine - scenario 2"]
[]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",100,"v2",450,"v3",75,"v4",550]
[null,"Ring 2","v5",75,"v6",600,"v7",150,"v8",250]
[]
["LT phasing, EW concurrency group","Permitted",null,null,"LT phasing options"]
["LT phasing, NS concurrency group","Permitted",null,null,"Permitted"]
["Cycle length",90,"sec",null,"Protected"]
["Lost time per phase",4,"sec"]
["Saturation flow rate, TH",1900,"veh/hr"]
["Saturation flow rate, protected LT",1900,"veh/hr"]
["Saturation flow rate, permitted LT",450,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"D5","v":100},"v2",{"$f":"F5","v":450},"v3",{"$f":"H5","v":75},"v4",{"$f":"J5","v":550}]
[null,null,"s1",{"$f":"IF(B8=\"Permitted\",B14,B13)","v":450},"s2",{"$f":"B12","v":1900},"s3",{"$f":"IF(B9=\"Permitted\",B14,B13)","v":450},"s4",{"$f":"B12","v":1900}]
[null,null,"Y1",{"$f":"D19/D20","v":0.22222222222222221},"Y2",{"$f":"F19/F20","v":0.23684210526315788},"Y3",{"$f":"H19/H20","v":0.16666666666666666},"Y4",{"$f":"J19/J20","v":0.28947368421052633}]
[null,"Ring 2","v5",{"$f":"D6","v":75},"v6",{"$f":"F6","v":600},"v7",{"$f":"H6","v":150},"v8",{"$f":"J6","v":250}]
[null,null,"s5",{"$f":"IF(B8=\"Permitted\",B14,B13)","v":450},"s6",{"$f":"B12","v":1900},"s7",{"$f":"IF(B9=\"Permitted\",B14,B13)","v":450},"s8",{"$f":"B12","v":1900}]
[null,null,"Y5",{"$f":"D22/D23","v":0.16666666666666666},"Y6",{"$f":"F22/F23","v":0.31578947368421051},"Y7",{"$f":"H22/H23","v":0.33333333333333331},"Y8",{"$f":"J22/J23","v":0.13157894736842105}]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of permitted LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B8=\"Protected\",D19,\"\")","v":""},"v2",{"$f":"IF(B8=\"Protected\",F19,\"\")","v":""},"v3",{"$f":"IF(B9=\"Protected\",H19,\"\")","v":""},"v4",{"$f":"IF(B9=\"Protected\",J19,\"\")","v":""}]
[null,null,"s1",{"$f":"IF(B8=\"Protected\",D20,\"\")","v":""},"s2",{"$f":"IF(B8=\"Protected\",F20,\"\")","v":""},"s3",{"$f":"IF(B9=\"Protected\",H20,\"\")","v":""},"s4",{"$f":"IF(B9=\"Protected\",J20,\"\")","v":""}]
[null,null,"Y1",{"$f":"IF(B8=\"Protected\",D21,\"\")","v":""},"Y2",{"$f":"IF(B8=\"Protected\",F21,\"\")","v":""},"Y3",{"$f":"IF(B9=\"Protected\",H21,\"\")","v":""},"Y4",{"$f":"IF(B9=\"Protected\",J21,\"\")","v":""}]
[null,null,"YEW1",{"$f":"IF(B8=\"Protected\",D30+F30,\"\")","v":""},null,null,"YNS1",{"$f":"IF(B9=\"Protected\",H30+J30,\"\")","v":""}]
[null,"Ring 2","v5",{"$f":"IF(B8=\"Protected\",D22,\"\")","v":""},"v6",{"$f":"IF(B8=\"Protected\",F22,\"\")","v":""},"v7",{"$f":"IF(B9=\"Protected\",H22,\"\")","v":""},"v8",{"$f":"IF(B9=\"Protected\",J22,\"\")","v":""}]
[null,null,"s5",{"$f":"IF(B8=\"Protected\",D23,\"\")","v":""},"s6",{"$f":"IF(B8=\"Protected\",F23,\"\")","v":""},"s7",{"$f":"IF(B9=\"Protected\",H23,\"\")","v":""},"s8",{"$f":"IF(B9=\"Protected\",J23,\"\")","v":""}]
[null,null,"Y5",{"$f":"IF(B8=\"Protected\",D24,\"\")","v":""},"Y6",{"$f":"IF(B8=\"Protected\",F24,\"\")","v":""},"Y7",{"$f":"IF(B9=\"Protected\",H24,\"\")","v":""},"Y8",{"$f":"IF(B9=\"Protected\",J24,\"\")","v":""}]
[null,null,"YEW2",{"$f":"IF(B8=\"Protected\",D34+F34,\"\")","v":""},null,null,"YNS2",{"$f":"IF(B9=\"Protected\",H34+J34,\"\")","v":""}]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B8=\"Permitted\",D19,\"\")","v":100},"v3",{"$f":"IF(B8=\"Permitted\",H19,\"\")","v":75},null,"Ring 1","v1",{"$f":"D28","v":""},"v2",{"$f":"F28","v":""},"v3",{"$f":"H28","v":""},"v4",{"$f":"J28","v":""}]
[null,null,"s1",{"$f":"IF(B8=\"Permitted\",D20,\"\")","v":450},"s3",{"$f":"IF(B8=\"Permitted\",H20,\"\")","v":450},null,null,"s1",{"$f":"D29","v":""},"s2",{"$f":"F29","v":""},"s3",{"$f":"H29","v":""},"s4",{"$f":"J29","v":""}]
[null,null,"Y1",{"$f":"IF(B8=\"Permitted\",D41/D42,\"\")","v":0.22222222222222221},"Y3",{"$f":"IF(B8=\"Permitted\",F41/F42,\"\")","v":0.16666666666666666},null,null,"Y1",{"$f":"D30","v":""},"Y2","","Y3",{"$f":"H30","v":""},"Y4",""]
[null,null,"v2",{"$f":"IF(B8=\"Permitted\",F19,\"\")","v":450},"v4",{"$f":"IF(B8=\"Permitted\",J19,\"\")","v":550},null,null,"YEW1",{"$f":"D31","v":""},null,null,"YNS1",{"$f":"H31","v":""}]
[null,null,"s2",{"$f":"IF(B8=\"Permitted\",F20,\"\")","v":1900},"s4",{"$f":"IF(B8=\"Permitted\",J20,\"\")","v":1900},null,"Ring 2","v5",{"$f":"D32","v":""},"v6",{"$f":"F32","v":""},"v7",{"$f":"H32","v":""},"v8",{"$f":"J32","v":""}]
[null,null,"Y2",{"$f":"IF(B8=\"Permitted\",D44/D45,\"\")","v":0.23684210526315788},"Y4",{"$f":"IF(B8=\"Permitted\",F44/F45,\"\")","v":0.28947368421052633},null,null,"s5",{"$f":"D33","v":""},"s6",{"$f":"F33","v":""},"s7",{"$f":"H33","v":""},"s8",{"$f":"J33","v":""}]
[null,"Ring 2","v5",{"$f":"IF(B8=\"Permitted\",D22,\"\")","v":75},"v7",{"$f":"IF(B8=\"Permitted\",H22,\"\")","v":150},null,null,"Y5","","Y6","","Y7","","Y8",""]
[null,null,"s5",{"$f":"IF(B8=\"Permitted\",D23,\"\")","v":450},"s7",{"$f":"IF(B8=\"Permitted\",H23,\"\")","v":450},null,null,"YEW2",{"$f":"D35","v":""},null,null,"YNS2",{"$f":"H35","v":""}]
[null,null,"Y5",{"$f":"IF(B8=\"Permitted\",D47/D48,\"\")","v":0.16666666666666666},"Y7",{"$f":"IF(B8=\"Permitted\",F47/F48,\"\")","v":0.33333333333333331},null,null,null,"YEW-critical",{"$f":"IF(B8=\"Protected\",MAX(J44,J48),\"\")","v":""},null,null,"YNS-critical",{"$f":"IF(B9=\"Protected\",MAX(N44,N48),\"\")","v":""}]
[null,null,"v6",{"$f":"IF(B8=\"Permitted\",F22,\"\")","v":600},"v8",{"$f":"IF(B8=\"Permitted\",J22,\"\")","v":250}]
[null,null,"s6",{"$f":"IF(B8=\"Permitted\",F23,\"\")","v":1900},"s8",{"$f":"IF(B8=\"Permitted\",J23,\"\")","v":1900}]
[null,null,"Y6",{"$f":"IF(B8=\"Permitted\",D50/D51,\"\")","v":0.31578947368421051},"Y8",{"$f":"IF(B8=\"Permitted\",F50/F51,\"\")","v":0.13157894736842105}]
[null,null,"YEW-critical",{"$f":"IF(B8=\"Permitted\",MAX(D43,D46,D49,D52),\"\")","v":0.31578947368421051},"YNS-critical",{"$f":"IF(B8=\"Permitted\",MAX(F43,F46,F49,F52),\"\")","v":0.33333333333333331}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection."]
["YEW-critical",{"$f":"IF(B8=\"Protected\",K49,D53)","v":0.31578947368421051}]
["YNS-critical",{"$f":"IF(B8=\"Protected\",O49,F53)","v":0.33333333333333331}]
["Lost time",{"$f":"LostTime(B8,B9)","v":8}]
["Xc",{"$f":"Xc(B56,B57,B10,B58)","v":0.71245186136071892}]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity",{"$f":"IF(B59<0.85,\"Intersection is operating under capacity\",IF(B59<0.95,\"Intersection is operating near capacity\",IF(B59<1,\"Unstable flow results in wide variety of delay\",\"The demand exceeds available capacity of the intersection\")))","v":"Intersection is operating under capacity"}]

{"sheet":"scenario 2 example 23","index":4,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[30,1,33,1],[33,3,33,5],[33,7,33,9],[2,2,2,5],[2,6,2,9],[16,2,16,5],[16,6,16,9],[17,1,19,1],[20,1,22,1],[25,2,25,5],[25,6,25,9],[26,1,29,1],[29,3,29,5],[29,7,29,9],[38,2,38,3],[38,4,38,5],[38,8,38,11],[38,12,38,15],[39,1,44,1],[39,7,42,7],[42,9,42,11],[42,13,42,15],[43,7,46,7],[45,1,50,1],[46,9,46,11],[46,13,46,15],[47,10,47,11],[47,14,47,15],[60,1,60,6]]}
["CMA computational engine - scenario 2"]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",125,"v2",600,"v3",175,"v4",550]
[null,"Ring 2","v5",275,"v6",550,"v7",250,"v8",675]
[]
["LT phasing, EW concurrency group","Protected",null,null,"LT phasing options"]
["LT phasing, NS concurrency group","Protected",null,null,"Permitted"]
["Cycle length",90,"sec",null,"Protected"]
["Lost time per phase",4,"sec"]
["Saturation flow rate, TH",1900,"veh/hr"]
["Saturation flow rate, protected LT",1900,"veh/hr"]
["Saturation flow rate, permitted LT",450,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"D4","v":125},"v2",{"$f":"F4","v":600},"v3",{"$f":"H4","v":175},"v4",{"$f":"J4","v":550}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":1900},"s2",{"$f":"B11","v":1900},"s3",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":1900},"s4",{"$f":"B11","v":1900}]
[null,null,"Y1",{"$f":"D18/D19","v":6.5789473684210523E-2},"Y2",{"$f":"F18/F19","v":0.31578947368421051},"Y3",{"$f":"H18/H19","v":9.2105263157894732E-2},"Y4",{"$f":"J18/J19","v":0.28947368421052633}]
[null,"Ring 2","v5",{"$f":"D5","v":275},"v6",{"$f":"F5","v":550},"v7",{"$f":"H5","v":250},"v8",{"$f":"J5","v":675}]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":1900},"s6",{"$f":"B11","v":1900},"s7",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":1900},"s8",{"$f":"B11","v":1900}]
[null,null,"Y5",{"$f":"D21/D22","v":0.14473684210526316},"Y6",{"$f":"F21/F22","v":0.28947368421052633},"Y7",{"$f":"H21/H22","v":0.13157894736842105},"Y8",{"$f":"J21/J22","v":0.35526315789473684}]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of protected LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Protected\",D18,\"\")","v":125},"v2",{"$f":"IF(B7=\"Protected\",F18,\"\")","v":600},"v3",{"$f":"IF(B8=\"Protected\",H18,\"\")","v":175},"v4",{"$f":"IF(B8=\"Protected\",J18,\"\")","v":550}]
[null,null,"s1",{"$f":"IF(B7=\"Protected\",D19,\"\")","v":1900},"s2",{"$f":"IF(B7=\"Protected\",F19,\"\")","v":1900},"s3",{"$f":"IF(B8=\"Protected\",H19,\"\")","v":1900},"s4",{"$f":"IF(B8=\"Protected\",J19,\"\")","v":1900}]
[null,null,"Y1",{"$f":"IF(B7=\"Protected\",D20,\"\")","v":6.5789473684210523E-2},"Y2",{"$f":"IF(B7=\"Protected\",F20,\"\")","v":0.31578947368421051},"Y3",{"$f":"IF(B8=\"Protected\",H20,\"\")","v":9.2105263157894732E-2},"Y4",{"$f":"IF(B8=\"Protected\",J20,\"\")","v":0.28947368421052633}]
[null,null,"YEW1",{"$f":"IF(B7=\"Protected\",D29+F29,\"\")","v":0.38157894736842102},null,null,"YNS1",{"$f":"IF(B8=\"Protected\",H29+J29,\"\")","v":0.38157894736842107}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Protected\",D21,\"\")","v":275},"v6",{"$f":"IF(B7=\"Protected\",F21,\"\")","v":550},"v7",{"$f":"IF(B8=\"Protected\",H21,\"\")","v":250},"v8",{"$f":"IF(B8=\"Protected\",J21,\"\")","v":675}]
[null,null,"s5",{"$f":"IF(B7=\"Protected\",D22,\"\")","v":1900},"s6",{"$f":"IF(B7=\"Protected\",F22,\"\")","v":1900},"s7",{"$f":"IF(B8=\"Protected\",H22,\"\")","v":1900},"s8",{"$f":"IF(B8=\"Protected\",J22,\"\")","v":1900}]
[null,null,"Y5",{"$f":"IF(B7=\"Protected\",D23,\"\")","v":0.14473684210526316},"Y6",{"$f":"IF(B7=\"Protected\",F23,\"\")","v":0.28947368421052633},"Y7",{"$f":"IF(B8=\"Protected\",H23,\"\")","v":0.13157894736842105},"Y8",{"$f":"IF(B8=\"Protected\",J23,\"\")","v":0.35526315789473684}]
[null,null,"YEW2",{"$f":"IF(B7=\"Protected\",D33+F33,\"\")","v":0.43421052631578949},null,null,"YNS2",{"$f":"IF(B8=\"Protected\",H33+J33,\"\")","v":0.48684210526315785}]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Permitted\",D18,\"\")","v":""},"v3",{"$f":"IF(B7=\"Permitted\",H18,\"\")","v":""},null,"Ring 1","v1",{"$f":"D27","v":125},"v2",{"$f":"F27","v":600},"v3",{"$f":"H27","v":175},"v4",{"$f":"J27","v":550}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",D19,\"\")","v":""},"s3",{"$f":"IF(B7=\"Permitted\",H19,\"\")","v":""},null,null,"s1",{"$f":"D28","v":1900},"s2",{"$f":"F28","v":1900},"s3",{"$f":"H28","v":1900},"s4",{"$f":"J28","v":1900}]
[null,null,"Y1",{"$f":"IF(B7=\"Permitted\",D40/D41,\"\")","v":""},"Y3",{"$f":"IF(B7=\"Permitted\",F40/F41,\"\")","v":""},null,null,"Y1",{"$f":"D29","v":6.5789473684210523E-2},"Y2",0.31578947368421051,"Y3",{"$f":"H30","v":0.38157894736842107},"Y4",0.28947368421052633]
[null,null,"v2",{"$f":"IF(B7=\"Permitted\",F18,\"\")","v":""},"v4",{"$f":"IF(B7=\"Permitted\",J18,\"\")","v":""},null,null,"YEW1",{"$f":"D30","v":0.38157894736842102},null,null,"YNS1",{"$f":"H30","v":0.38157894736842107}]
[null,null,"s2",{"$f":"IF(B7=\"Permitted\",F19,\"\")","v":""},"s4",{"$f":"IF(B7=\"Permitted\",J19,\"\")","v":""},null,"Ring 2","v5",{"$f":"D31","v":275},"v6",{"$f":"F31","v":550},"v7",{"$f":"H31","v":250},"v8",{"$f":"J31","v":675}]
[null,null,"Y2",{"$f":"IF(B7=\"Permitted\",D43/D44,\"\")","v":""},"Y4",{"$f":"IF(B7=\"Permitted\",F43/F44,\"\")","v":""},null,null,"s5",{"$f":"D32","v":1900},"s6",{"$f":"F32","v":1900},"s7",{"$f":"H32","v":1900},"s8",{"$f":"J32","v":1900}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Permitted\",D21,\"\")","v":""},"v7",{"$f":"IF(B7=\"Permitted\",H21,\"\")","v":""},null,null,"Y5",0.14473684210526316,"Y6",0.28947368421052633,"Y7",0.13157894736842105,"Y8",0.35526315789473684]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",D22,\"\")","v":""},"s7",{"$f":"IF(B7=\"Permitted\",H22,\"\")","v":""},null,null,"YEW2",{"$f":"D34","v":0.43421052631578949},null,null,"YNS2",{"$f":"H34","v":0.48684210526315785}]
[null,null,"Y5",{"$f":"IF(B7=\"Permitted\",D46/D47,\"\")","v":""},"Y7",{"$f":"IF(B7=\"Permitted\",F46/F47,\"\")","v":""},null,null,null,"YEW-critical",{"$f":"IF(B7=\"Protected\",MAX(J43,J47),\"\")","v":0.43421052631578949},null,null,"YNS-critical",{"$f":"IF(B8=\"Protected\",MAX(N43,N47),\"\")","v":0.48684210526315785}]
[null,null,"v6",{"$f":"IF(B7=\"Permitted\",F21,\"\")","v":""},"v8",{"$f":"IF(B7=\"Permitted\",J21,\"\")","v":""}]
[null,null,"s6",{"$f":"IF(B7=\"Permitted\",F22,\"\")","v":""},"s8",{"$f":"IF(B7=\"Permitted\",J22,\"\")","v":""}]
[null,null,"Y6",{"$f":"IF(B7=\"Permitted\",D49/D50,\"\")","v":""},"Y8",{"$f":"IF(B7=\"Permitted\",F49/F50,\"\")","v":""}]
[null,null,"YEW-critical",{"$f":"IF(B7=\"Permitted\",MAX(D42,D45,D48,D51),\"\")","v":""},"YNS-critical",{"$f":"IF(B7=\"Permitted\",MAX(F42,F45,F48,F51),\"\")","v":""}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection."]
["YEW-critical",{"$f":"IF(B7=\"Protected\",K48,D52)","v":0.43421052631578949}]
["YNS-critical",{"$f":"IF(B7=\"Protected\",O48,F52)","v":0.48684210526315785}]
["Lost time",{"$f":"LostTime(B7,B8)","v":16}]
["Xc",{"$f":"Xc(B55,B56,B9,B57)","v":1.1201991465149359}]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity",{"$f":"IF(B58<0.85,\"Intersection is operating under capacity\",IF(B58<0.95,\"Intersection is operating near capacity\",IF(B58<1,\"Unstable flow results in wide variety of delay\",\"The demand exceeds available capacity of the intersection\")))","v":"The demand exceeds available capacity of the intersection"}]

{"sheet":"scenario 2 example 24","index":5,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[30,1,33,1],[33,3,33,5],[33,7,33,9],[2,2,2,5],[2,6,2,9],[16,2,16,5],[16,6,16,9],[17,1,19,1],[20,1,22,1],[25,2,25,5],[25,6,25,9],[26,1,29,1],[29,3,29,5],[29,7,29,9],[38,2,38,3],[38,4,38,5],[38,8,38,11],[38,12,38,15],[39,1,44,1],[39,7,42,7],[42,9,42,11],[42,13,42,15],[43,7,46,7],[45,1,50,1],[46,9,46,11],[46,13,46,15],[47,10,47,11],[47,14,47,15],[60,1,60,6]]}
["CMA computational engine - scenario 2"]
[]
["Step 0: Given Data",null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
["Volume data","Ring 1","v1",50,"v2",225,"v3",100,"v4",250]
[null,"Ring 2","v5",75,"v6",200,"v7",75,"v8",325]
[]
["LT phasing, EW concurrency group","Permitted",null,null,"LT phasing options"]
["LT phasing, NS concurrency group","Permitted",null,null,"Permitted"]
["Cycle length",90,"sec",null,"Protected"]
["Lost time per phase",4,"sec"]
["Saturation flow rate, TH",1900,"veh/hr"]
["Saturation flow rate, protected LT",1900,"veh/hr"]
["Saturation flow rate, permitted LT",450,"veh/hr"]
[]
[]
["Step 1: Compute the flow ratio Y for each movement present at the intersection"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"D4","v":50},"v2",{"$f":"F4","v":225},"v3",{"$f":"H4","v":100},"v4",{"$f":"J4","v":250}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":450},"s2",{"$f":"B11","v":1900},"s3",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":450},"s4",{"$f":"B11","v":1900}]
[null,null,"Y1",{"$f":"D18/D19","v":0.1111111111111111},"Y2",{"$f":"F18/F19","v":0.11842105263157894},"Y3",{"$f":"H18/H19","v":0.22222222222222221},"Y4",{"$f":"J18/J19","v":0.13157894736842105}]
[null,"Ring 2","v5",{"$f":"D5","v":75},"v6",{"$f":"F5","v":200},"v7",{"$f":"H5","v":75},"v8",{"$f":"J5","v":325}]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",B13,B12)","v":450},"s6",{"$f":"B11","v":1900},"s7",{"$f":"IF(B8=\"Permitted\",B13,B12)","v":450},"s8",{"$f":"B11","v":1900}]
[null,null,"Y5",{"$f":"D21/D22","v":0.16666666666666666},"Y6",{"$f":"F21/F22","v":0.10526315789473684},"Y7",{"$f":"H21/H22","v":0.16666666666666666},"Y8",{"$f":"J21/J22","v":0.17105263157894737}]
[]
["Step 2: Determine the flow ratio sums for the phase sequences in each ring for each concurrency group (for the case of protected LTs only)"]
[null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Protected\",D18,\"\")","v":""},"v2",{"$f":"IF(B7=\"Protected\",F18,\"\")","v":""},"v3",{"$f":"IF(B8=\"Protected\",H18,\"\")","v":""},"v4",{"$f":"IF(B8=\"Protected\",J18,\"\")","v":""}]
[null,null,"s1",{"$f":"IF(B7=\"Protected\",D19,\"\")","v":""},"s2",{"$f":"IF(B7=\"Protected\",F19,\"\")","v":""},"s3",{"$f":"IF(B8=\"Protected\",H19,\"\")","v":""},"s4",{"$f":"IF(B8=\"Protected\",J19,\"\")","v":""}]
[null,null,"Y1",{"$f":"IF(B7=\"Protected\",D20,\"\")","v":""},"Y2",{"$f":"IF(B7=\"Protected\",F20,\"\")","v":""},"Y3",{"$f":"IF(B8=\"Protected\",H20,\"\")","v":""},"Y4",{"$f":"IF(B8=\"Protected\",J20,\"\")","v":""}]
[null,null,"YEW1",{"$f":"IF(B7=\"Protected\",D29+F29,\"\")","v":""},null,null,"YNS1",{"$f":"IF(B8=\"Protected\",H29+J29,\"\")","v":""}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Protected\",D21,\"\")","v":""},"v6",{"$f":"IF(B7=\"Protected\",F21,\"\")","v":""},"v7",{"$f":"IF(B8=\"Protected\",H21,\"\")","v":""},"v8",{"$f":"IF(B8=\"Protected\",J21,\"\")","v":""}]
[null,null,"s5",{"$f":"IF(B7=\"Protected\",D22,\"\")","v":""},"s6",{"$f":"IF(B7=\"Protected\",F22,\"\")","v":""},"s7",{"$f":"IF(B8=\"Protected\",H22,\"\")","v":""},"s8",{"$f":"IF(B8=\"Protected\",J22,\"\")","v":""}]
[null,null,"Y5",{"$f":"IF(B7=\"Protected\",D23,\"\")","v":""},"Y6",{"$f":"IF(B7=\"Protected\",F23,\"\")","v":""},"Y7",{"$f":"IF(B8=\"Protected\",H23,\"\")","v":""},"Y8",{"$f":"IF(B8=\"Protected\",J23,\"\")","v":""}]
[null,null,"YEW2",{"$f":"IF(B7=\"Protected\",D33+F33,\"\")","v":""},null,null,"YNS2",{"$f":"IF(B8=\"Protected\",H33+J33,\"\")","v":""}]
[]
["Step 3: Within each concurrency group, identify the movements with the maximum flow ratio sum (for protected left turns)"]
["or the movement with the maximum flow ratio (for permitted left turns).  These movements are the critical movements"]
["for each concurrency group."]
[null,null,"EW ConGrp",null,"NS ConGrp",null,null,null,"East-West Concurrency Group",null,null,null,"North-South Concurrency Group"]
[null,"Ring 1","v1",{"$f":"IF(B7=\"Permitted\",D18,\"\")","v":50},"v3",{"$f":"IF(B7=\"Permitted\",H18,\"\")","v":100},null,"Ring 1","v1",{"$f":"D27","v":""},"v2",{"$f":"F27","v":""},"v3",{"$f":"H27","v":""},"v4",{"$f":"J27","v":""}]
[null,null,"s1",{"$f":"IF(B7=\"Permitted\",D19,\"\")","v":450},"s3",{"$f":"IF(B7=\"Permitted\",H19,\"\")","v":450},null,null,"s1",{"$f":"D28","v":""},"s2",{"$f":"F28","v":""},"s3",{"$f":"H28","v":""},"s4",{"$f":"J28","v":""}]
[null,null,"Y1",{"$f":"IF(B7=\"Permitted\",D40/D41,\"\")","v":0.1111111111111111},"Y3",{"$f":"IF(B7=\"Permitted\",F40/F41,\"\")","v":0.22222222222222221},null,null,"Y1",{"$f":"D29","v":""},"Y2","","Y3",{"$f":"H30","v":""},"Y4",""]
[null,null,"v2",{"$f":"IF(B7=\"Permitted\",F18,\"\")","v":225},"v4",{"$f":"IF(B7=\"Permitted\",J18,\"\")","v":250},null,null,"YEW1",{"$f":"D30","v":""},null,null,"YNS1",{"$f":"H30","v":""}]
[null,null,"s2",{"$f":"IF(B7=\"Permitted\",F19,\"\")","v":1900},"s4",{"$f":"IF(B7=\"Permitted\",J19,\"\")","v":1900},null,"Ring 2","v5",{"$f":"D31","v":""},"v6",{"$f":"F31","v":""},"v7",{"$f":"H31","v":""},"v8",{"$f":"J31","v":""}]
[null,null,"Y2",{"$f":"IF(B7=\"Permitted\",D43/D44,\"\")","v":0.11842105263157894},"Y4",{"$f":"IF(B7=\"Permitted\",F43/F44,\"\")","v":0.13157894736842105},null,null,"s5",{"$f":"D32","v":""},"s6",{"$f":"F32","v":""},"s7",{"$f":"H32","v":""},"s8",{"$f":"J32","v":""}]
[null,"Ring 2","v5",{"$f":"IF(B7=\"Permitted\",D21,\"\")","v":75},"v7",{"$f":"IF(B7=\"Permitted\",H21,\"\")","v":75},null,null,"Y5","","Y6","","Y7","","Y8",""]
[null,null,"s5",{"$f":"IF(B7=\"Permitted\",D22,\"\")","v":450},"s7",{"$f":"IF(B7=\"Permitted\",H22,\"\")","v":450},null,null,"YEW2",{"$f":"D34","v":""},null,null,"YNS2",{"$f":"H34","v":""}]
[null,null,"Y5",{"$f":"IF(B7=\"Permitted\",D46/D47,\"\")","v":0.16666666666666666},"Y7",{"$f":"IF(B7=\"Permitted\",F46/F47,\"\")","v":0.16666666666666666},null,null,null,"YEW-critical",{"$f":"IF(B7=\"Protected\",MAX(J43,J47),\"\")","v":""},null,null,"YNS-critical",{"$f":"IF(B8=\"Protected\",MAX(N43,N47),\"\")","v":""}]
[null,null,"v6",{"$f":"IF(B7=\"Permitted\",F21,\"\")","v":200},"v8",{"$f":"IF(B7=\"Permitted\",J21,\"\")","v":325}]
[null,null,"s6",{"$f":"IF(B7=\"Permitted\",F22,\"\")","v":1900},"s8",{"$f":"IF(B7=\"Permitted\",J22,\"\")","v":1900}]
[null,null,"Y6",{"$f":"IF(B7=\"Permitted\",D49/D50,\"\")","v":0.10526315789473684},"Y8",{"$f":"IF(B7=\"Permitted\",F49/F50,\"\")","v":0.17105263157894737}]
[null,null,"YEW-critical",{"$f":"IF(B7=\"Permitted\",MAX(D42,D45,D48,D51),\"\")","v":0.16666666666666666},"YNS-critical",{"$f":"IF(B7=\"Permitted\",MAX(F42,F45,F48,F51),\"\")","v":0.22222222222222221}]
[]
["Step 4. Determine the critical volume-to-capacity ratio Xc for the intersection."]
["YEW-critical",{"$f":"IF(B7=\"Protected\",K48,D52)","v":0.16666666666666666}]
["YNS-critical",{"$f":"IF(B7=\"Protected\",O48,F52)","v":0.22222222222222221}]
["Lost time",{"$f":"LostTime(B7,B8)","v":8}]
["Xc",{"$f":"Xc(B55,B56,B9,B57)","v":0.42682926829268286}]
[]
["Step 5: Based on the value of Xc calculated in step 4, determine the sufficiency of capacity."]
["Sufficiency of capacity",{"$f":"IF(B58<0.85,\"Intersection is operating under capacity\",IF(B58<0.95,\"Intersection is operating near capacity\",IF(B58<1,\"Unstable flow results in wide variety of delay\",\"The demand exceeds available capacity of the intersection\")))","v":"Intersection is operating under capacity"}]