{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Signals model","study-lambda","study-queue service time","study-MAH","study-extensions before max out","study-probability of green ext","study-green ext time","study-probability of phase call"],"not_rendered":{"charts":10,"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":"Signals model","index":0,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,8,2,9]]}
["Input variables","Phase 2","Phase 4",null,null,"Queue Accumulation Polygon (QAP)"]
["Arrival rate, v",500,400,"veh/hr"]
["Proportion vehicles arriving on green, P",0.5,0.5,null,null,null,"Phase 2",null,"Phase 4"]
["Headway of bunched vehicles, Δ",1.5,1.5,"veh/sec",null,"Points on QAP","Queue","Time","Queue","Time"]
["Bunching factor, b",0.6,0.6,null,null,"Origin",0,0,0,{"$f":"B42","v":17.478965984550072}]
["Lost time, l1",2,2,"sec",null,"Maximum queue",{"$f":"B28","v":1.845350287439053},{"$f":"B42","v":17.478965984550072},{"$f":"C28","v":1.4762802299512423},{"$f":"J5+C42","v":36.502216160082028}]
["Passage time, PT",2.5,2.5,"sec",null,"Queue at end of green",{"$f":"G27","v":{"$error":"#VALUE!"}},{"$f":"H6+B29+B34","v":{"$error":"#VALUE!"}},{"$f":"I27","v":{"$error":"#VALUE!"}},{"$f":"J6+C29+C34","v":{"$error":"#VALUE!"}}]
["Detection zone length, Lds",22,22,"feet"]
["Vehicle length, Lv",20,20,"feet",null,"Display indications","Queue","Time","Queue","Time"]
["Speed, Sa",30,30,"mi/hr",null,"Red start",0.2,0,0.2,{"$f":"J5","v":17.478965984550072}]
["Maximum green, Gmax",50,50,"sec",null,"Red end",0.2,{"$f":"B44-B14","v":{"$error":"#VALUE!"}},0.2,{"$f":"J10+C44","v":{"$error":"#VALUE!"}}]
["Minimum green, Gmin",5,5,"sec",null,"Green start",0.2,{"$f":"H11","v":{"$error":"#VALUE!"}},0.2,{"$f":"J11","v":{"$error":"#VALUE!"}}]
["Yellow time, Y",3,3,"sec",null,"Green end",0.2,{"$f":"H12+B43","v":{"$error":"#VALUE!"}},0.2,{"$f":"J12+C43","v":{"$error":"#VALUE!"}}]
["Red clearance, Rc",2,2,"sec",null,"Yellow start",0.2,{"$f":"H13","v":{"$error":"#VALUE!"}}]
["Saturation flow rate, s",1900,1900,"veh/hr/green",null,"Yellow end",0.2,{"$f":"H14+B13","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Red clear start",0.2,{"$f":"H15","v":{"$error":"#VALUE!"}}]
["Intermediate values",null,null,null,null,"Red clear end",0.2,{"$f":"H16+B14","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,1,null,0]
["Cycle length,  C",26.573044139122363,26.573044139122363,"sec"]
["Effective green, g",9.0662612925795756,7.5067828465427882,"sec"]
["Effective red, r",17.506782846542787,19.066261292579576,"sec",null,"Capacity calculation"]
[null,null,null,null,null,"Effective green, g",{"$f":"B41","v":9.0232501755319525},null,{"$f":"C41","v":7.4789659845500713}]
["Calculated variables",null,null,null,null,"Cycle length,  C",{"$f":"B40","v":26.502216160082025},null,{"$f":"C40","v":26.502216160082025}]
["Arrival rate, q",{"$f":"B2/3600","v":0.1388888888888889},{"$f":"C2/3600","v":0.1111111111111111},"veh/sec",null,"Saturation flow rate, s",{"$f":"B15","v":1900},null,{"$f":"C15","v":1900}]
["Arrival rate during red, qr",{"$f":"qr(B3,B23,B18,B20)","v":0.10540773274076853},{"$f":"qr(C3,C23,C18,C20)","v":7.7428930994761822E-2},"veh/sec",null,"Capacity, c",{"$f":"(G21/G22)*G23","v":646.89591353244953},null,{"$f":"(I21/I22)*I23","v":536.18290956544502}]
["Arrival rate during green, qg",{"$f":"qg(B3,B23,B18,B19)","v":0.20354038207010525},{"$f":"qg(C3,C23,C18,C19)","v":0.1966595091572598},"veh/sec",null,"Arrival rate, v",{"$f":"B2","v":500},null,{"$f":"C2","v":400}]
["Proportion of free vehicles, ϕ",{"$f":"_xludf.phi(B5,B4,B23)","v":0.88249690258459546},{"$f":"_xludf.phi(C5,C4,C23)","v":0.90483741803595963},null,null,"Degree of saturation",{"$f":"G25/G24","v":0.77292187126317202},null,{"$f":"I25/I24","v":0.74601408001643343}]
["Flow rate parameter, λ",{"$f":"lambda(B26,B23,B4)","v":0.15482401799729748},{"$f":"lambda(C26,C23,C4)","v":0.12064498907146128},"veh/sec",null,"Queue at end of green",{"$f":"QueueAtEndOfGreen(B28,B15,B25,B11,B29,B34,B6)","v":{"$error":"#VALUE!"}},null,{"$f":"QueueAtEndOfGreen(C28,C15,C25,C11,C29,C34,C6)","v":{"$error":"#VALUE!"}}]
["Queue at end of red, Qr",{"$f":"B24*B20","v":1.845350287439053},{"$f":"C24*C20","v":1.4762802299512423},"veh",null,"Uniform delay, sec/veh",{"$f":"UniformDelay(B2,B42,B29,B28,G27,B34,G22)","v":{"$error":"#VALUE!"}},null,{"$f":"UniformDelay(C2,C42,C29,C28,I27,C34,I22)","v":{"$error":"#VALUE!"}}]
["Queue service time, gs",{"$f":"QueueServiceTime(B23,B18,B3,B15,B19,B6,B11,B34)","v":{"$error":"#VALUE!"}},{"$f":"QueueServiceTime(C23,C18,C3,C15,C19,C6,C11,C34)","v":{"$error":"#VALUE!"}},"sec"]
["Number of extension before max out, n",{"$f":"NumberExtensionsBeforeMaxOut(B23,B11,B29,B6)","v":{"$error":"#VALUE!"}},{"$f":"NumberExtensionsBeforeMaxOut(C23,C11,C29,C6)","v":{"$error":"#VALUE!"}},null,null,"Time calculations","Y-axis","X-axis","Y-axis","X-axis"]
["ProbSubjectPhaseCalled, pv",{"$f":"ProbSubjectPhaseCalled(B23,B18)","v":0.97504548658824775},{"$f":"ProbSubjectPhaseCalled(C23,C18)","v":0.94779413634791787},null,null,"Red and Phase Duration"]
["MAH",{"$f":"MAH(B7,B8,B9,B10)","v":3.4523809523809526},{"$f":"MAH(C7,C8,C9,C10)","v":3.4523809523809526},"sec",null,"Red display",3,0,3]
["ProbGreenExtension, p",{"$f":"ProbGreenExtension(B26,B27,B32,B4)","v":0.3477161530499121},{"$f":"ProbGreenExtension(C26,C27,C32,C4)","v":0.2850516514325343},null,null,null,3,{"$f":"H32+B44-B14","v":{"$error":"#VALUE!"}},3]
["Green extension, ge",{"$f":"GreenExtension(B33,B30,B23)","v":{"$error":"#VALUE!"}},{"$f":"GreenExtension(C33,C30,C23)","v":{"$error":"#VALUE!"}},"sec",null,"Green display",3,{"$f":"H33","v":{"$error":"#VALUE!"}},3]
["Effective change interval, Y + Rc",{"$f":"B13+B14","v":5},{"$f":"C13+C14","v":5},"sec",null,null,3,{"$f":"H34+B43","v":{"$error":"#VALUE!"}},3]
["Average green interval duration, G",{"$f":"AvgGreenDuration(B12,B11,B6,B29,B34)","v":{"$error":"#VALUE!"}},{"$f":"AvgGreenDuration(C12,C11,C6,C29,C34)","v":{"$error":"#VALUE!"}},"sec",null,"Yellow display",3,{"$f":"H35","v":{"$error":"#VALUE!"}}]
["Phase duration, Dp",{"$f":"B36+B13+B14","v":{"$error":"#VALUE!"}},{"$f":"C36+C13+C14","v":{"$error":"#VALUE!"}},"sec",null,null,3,{"$f":"H36+B13","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Red clearance display",3,{"$f":"H37","v":{"$error":"#VALUE!"}}]
["Final values",null,null,null,null,null,3,{"$f":"H38+B14","v":{"$error":"#VALUE!"}}]
["Cycle length,  C",26.502216160082025,26.502216160082025,"sec",null,"Cycle length",4,0]
["Effective green, g",9.0232501755319525,7.4789659845500713,"sec",null,null,4,{"$f":"B40","v":26.502216160082025}]
["Effective red, r",17.478965984550072,19.023250175531953,"sec",null,"Phase duration",3.2,{"$f":"H34","v":{"$error":"#VALUE!"}}]
["Displayed green, G",{"$f":"B6+B29+B34","v":{"$error":"#VALUE!"}},{"$f":"C6+C29+C34","v":{"$error":"#VALUE!"}},"sec",null,null,3.2,{"$f":"H39","v":{"$error":"#VALUE!"}}]
["Displayed red, R",{"$f":"B40-B43-B13","v":{"$error":"#VALUE!"}},{"$f":"C40-C43-C13","v":{"$error":"#VALUE!"}},"sec"]
["Displayed yellow, Y",{"$f":"B13","v":3},{"$f":"C13","v":3},"sec",null,"Effective times"]
[null,null,null,null,null,"Effective red1",2,0]
[null,null,null,null,null,null,2,{"$f":"H46+B42","v":17.478965984550072}]
[null,null,null,null,null,"Effective green",2,{"$f":"H47","v":17.478965984550072}]
[null,null,null,null,null,null,2,{"$f":"H48+B41","v":26.502216160082025}]
[null,null,null,null,null,"Effective red2",2,{"$f":"H49","v":26.502216160082025}]
[null,null,null,null,null,null,2,{"$f":"H50+B13+B14-2","v":29.502216160082025}]
[]
[null,null,null,null,null,"Phase duration components"]
[null,null,null,null,null,"Lost time, l1",1,{"$f":"B44","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,1,{"$f":"H54+B6","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Green service time, gs",1,{"$f":"H55","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,1,{"$f":"H56+B29","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Green extension time, ge",1,{"$f":"H57","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,1,{"$f":"H58+B34","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"Y+Rc",1,{"$f":"H59","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,1,{"$f":"H60+B13+B14","v":{"$error":"#VALUE!"}}]

{"sheet":"study-lambda","index":1,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Study: Lambda, call rate to extend green"]
["Assumed:"]
["Δ",null,1.5]
["b",null,0.6]
[]
["v","q","λ","λ (veh/hr)"]
[0,{"$f":"A7/3600","v":0},{"$f":"(B7*EXP(-0.9*B7))/(1-1.5*B7)","v":0},{"$f":"C7*3600","v":0}]
[50,{"$f":"A8/3600","v":1.3888888888888888E-2},{"$f":"(B8*EXP(-0.9*B8))/(1-1.5*B8)","v":1.4008195751686261E-2},{"$f":"C8*3600","v":50.429504706070539}]
[100,2.7777777777777776E-2,2.8269852522560365E-2,101.77146908121732]
[150,4.1666666666666664E-2,4.2808640787592077E-2,154.11110683533147]
[200,5.5555555555555552E-2,5.7650268151558423E-2,207.54096534561032]
[250,6.9444444444444448E-2,7.2822718047556259E-2,262.16178497120251]
[300,8.3333333333333329E-2,8.835652250748123E-2,318.08348102693242]
[350,9.7222222222222224E-2,0.10428507482205111,375.42626935938398]
[400,0.1111111111111111,0.12064498907146128,434.3219606572606]
[450,0.125,0.13747651493977164,494.9154537831779]
[500,0.1388888888888889,0.15482401799729748,557.36646479027092]
[550,0.15277777777777779,0.17273653783727455,621.8515362141884]
[600,0.16666666666666666,0.19126843920556838,688.56638114004613]
[650,0.18055555555555555,0.21048017472247951,757.72862900092628]
[700,0.19444444444444445,0.23043918217193932,829.58105581898155]
[750,0.20833333333333334,0.25122094490315167,904.39540165134599]
[800,0.22222222222222221,0.27291025102599392,982.47690369357815]
[850,0.2361111111111111,0.29560269628956326,1064.1697066424276]
[900,0.25,0.31940648750375084,1149.863355013503]
[950,0.2638888888888889,0.34444461904920592,1240.0006285771412]
[1000,0.27777777777777779,0.37085751574828807,1335.087056693837]
[]
["Reflections:"]
["1. The effect of bunching increases as the arrival flow rate increases."]
["2. Little or no effect when arrival rate is below 250 veh/hr."]
["3. At 750 veh/hr, the difference becomes substantial: the flow rate parameter is 20 percent higher than the arrival flow rate."]

{"sheet":"study-queue service time","index":2,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Study: Queue service time"]
["Assumed:"]
["C",60,"sec"]
["s",1900,"veh/hr"]
["g/C",0.5]
["g",{"$f":"B5*B3","v":30}]
[]
[null,"P",0.25,0.5,0.75]
["v","q","gs","gs","gs"]
[0,{"$f":"A10/3600","v":0},{"$f":"QueueServiceTime($B10,$B$3,C$8,$B$4,$B$6,2,50,1)","v":0},{"$f":"QueueServiceTime($B10,$B$3,D$8,$B$4,$B$6,2,50,1)","v":0},0]
[50,{"$f":"A11/3600","v":1.3888888888888888E-2},{"$f":"QueueServiceTime($B11,$B$3,C$8,$B$4,$B$6,2,50,1)","v":1.2},0.81081081081081063,0.41095890410958902]
[100,2.7777777777777776E-2,2.432432432432432,1.6666666666666665,0.8571428571428571]
[150,4.1666666666666664E-2,3.6986301369863015,2.5714285714285716,1.3432835820895521]
[200,5.5555555555555552E-2,5,3.5294117647058822,1.8749999999999998]
[250,6.9444444444444448E-2,6.3380281690140841,4.545454545454545,2.459016393442623]
[300,8.3333333333333329E-2,7.7142857142857144,5.625,3.103448275862069]
[350,9.7222222222222224E-2,9.1304347826086953,6.7741935483870961,3.8181818181818183]
[400,0.1111111111111111,10.588235294117647,7.9999999999999991,4.6153846153846141]
[450,0.125,12.08955223880597,9.3103448275862064,5.5102040816326525]
[500,0.1388888888888889,13.636363636363635,10.714285714285715,6.5217391304347831]
[550,0.15277777777777779,15.230769230769232,12.222222222222223,7.6744186046511658]
[600,0.16666666666666666,16.875,13.846153846153845,9]
[650,0.18055555555555555,18.571428571428573,15.600000000000001,10.540540540540542]
[700,0.19444444444444445,20.322580645161288,17.499999999999996,12.352941176470589]
[750,0.20833333333333334,22.131147540983608,19.565217391304348,14.516129032258064]
[800,0.22222222222222221,24,21.818181818181813,17.142857142857139]
[850,0.2361111111111111,25.932203389830509,24.285714285714285,20.399999999999999]
[900,0.25,27.931034482758619,27,24.545454545454543]
[]
["Reflections"]
["1. The higher the P (proportion arriving on green), the lower the queue service time."]

{"sheet":"study-MAH","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Study: Maximum Allowable Headway"]
["Assumed"]
["Lv",20,"ft"]
["Sa",25,"mi/hr"]
[]
[]
["PT",1.5,2,2.5,3]
["Lds","MAH","MAH","MAH","MAH"]
[22,{"$f":"B$7+($A9+$B$3)/(1.47*$B$4)","v":2.6428571428571428},{"$f":"C$7+($A9+$B$3)/(1.47*$B$4)","v":3.1428571428571428},3.6428571428571428,4.1428571428571423]
[44,{"$f":"B$7+($A10+$B$3)/(1.47*$B$4)","v":3.2414965986394559},3.7414965986394559,4.2414965986394559,4.7414965986394559]
[66,3.8401360544217686,4.3401360544217686,4.8401360544217686,5.3401360544217686]
[88,4.4387755102040813,4.9387755102040813,5.4387755102040813,5.9387755102040813]

{"sheet":"study-extensions before max out","index":4,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Study: Number of extensions before maxout"]
["Assumed:"]
["C",60,"sec"]
["s",1900,"veh/hr"]
["g/C",0.5]
["g",{"$f":"B5*B3","v":30},"sec"]
["Gmax",50,"sec"]
["l1",2,"sec"]
[]
[null,"P",0.25,0.5,0.75,null,"P",0.25,0.5,0.75]
["v","q","gs","gs","gs",null,null,"n","n","n"]
[0,{"$f":"A12/3600","v":0},{"$f":"QueueServiceTime($B12,$B$3,C$10,$B$4,$B$6,2,50,1)","v":0},{"$f":"QueueServiceTime($B12,$B$3,D$10,$B$4,$B$6,2,50,1)","v":0},0,null,null,{"$f":"$B12*($B$7-C12-$B$8)","v":0},{"$f":"$B12*($B$7-D12-$B$8)","v":0},0]
[50,{"$f":"A13/3600","v":1.3888888888888888E-2},{"$f":"QueueServiceTime($B13,$B$3,C$10,$B$4,$B$6,2,50,1)","v":1.2},0.81081081081081063,0.41095890410958902,null,null,{"$f":"$B13*($B$7-C13-$B$8)","v":0.64999999999999991},0.65540540540540537,0.66095890410958902]
[100,2.7777777777777776E-2,2.432432432432432,1.6666666666666665,0.8571428571428571,null,null,1.2657657657657657,1.287037037037037,1.3095238095238095]
[150,4.1666666666666664E-2,3.6986301369863015,2.5714285714285716,1.3432835820895521,null,null,1.845890410958904,1.8928571428571428,1.9440298507462686]
[200,5.5555555555555552E-2,5,3.5294117647058822,1.8749999999999998,null,null,2.3888888888888888,2.4705882352941173,2.5625]
[250,6.9444444444444448E-2,6.3380281690140841,4.545454545454545,2.459016393442623,null,null,2.8931924882629114,3.0176767676767677,3.1625683060109289]
[300,8.3333333333333329E-2,7.7142857142857144,5.625,3.103448275862069,null,null,3.3571428571428568,3.53125,3.7413793103448274]
[350,9.7222222222222224E-2,9.1304347826086953,6.7741935483870961,3.8181818181818183,null,null,3.7789855072463769,4.008064516129032,4.295454545454545]
[400,0.1111111111111111,10.588235294117647,7.9999999999999991,4.6153846153846141,null,null,4.1568627450980395,4.4444444444444446,4.8205128205128203]
[450,0.125,12.08955223880597,9.3103448275862064,5.5102040816326525,null,null,4.4888059701492535,4.8362068965517242,5.3112244897959187]
[500,0.1388888888888889,13.636363636363635,10.714285714285715,6.5217391304347831,null,null,4.7727272727272734,5.1785714285714288,5.7608695652173916]
[550,0.15277777777777779,15.230769230769232,12.222222222222223,7.6744186046511658,null,null,5.0064102564102564,5.4660493827160499,6.1608527131782944]
[600,0.16666666666666666,16.875,13.846153846153845,9,null,null,5.1875,5.6923076923076916,6.5]
[650,0.18055555555555555,18.571428571428573,15.600000000000001,10.540540540540542,null,null,5.3134920634920633,5.85,6.7635135135135132]
[700,0.19444444444444445,20.322580645161288,17.499999999999996,12.352941176470589,null,null,5.381720430107527,5.9305555555555554,6.9313725490196081]
[750,0.20833333333333334,22.131147540983608,19.565217391304348,14.516129032258064,null,null,5.389344262295082,5.9239130434782608,6.9758064516129039]
[800,0.22222222222222221,24,21.818181818181813,17.142857142857139,null,null,5.333333333333333,{"$f":"$B28*($B$7-D28-$B$8)","v":5.8181818181818192},{"$f":"$B28*($B$7-E28-$B$8)","v":6.8571428571428577}]
[850,0.2361111111111111,25.932203389830509,24.285714285714285,20.399999999999999,null,null,5.2104519774011298,5.5992063492063497,6.5166666666666666]
[900,0.25,27.931034482758619,27,24.545454545454543,null,null,5.0172413793103452,5.25,5.8636363636363642]
[]
["Reflections"]
["1. ???"]

{"sheet":"study-probability of green ext","index":5,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Study: Probability of green extension"]
["Assumed:"]
["C",60,"sec"]
["s",1900,"veh/hr"]
["g/C",0.5]
["g",{"$f":"B5*B3","v":30},"sec"]
["Δ",1.5]
["b",0.6]
["MAH",3,"sec"]
[]
["v","q","ϕ","λ","λ (veh/hr)","p"]
[0,{"$f":"A12/3600","v":0},{"$f":"EXP(-$B$8*$B$7*B12)","v":1},{"$f":"(B12*EXP(-0.9*B12))/(1-1.5*B12)","v":0},{"$f":"D12*3600","v":0},{"$f":"1-C12*EXP(-D12*($B$9-$B$7))","v":0}]
[50,{"$f":"A13/3600","v":1.3888888888888888E-2},{"$f":"EXP(-$B$8*$B$7*B13)","v":0.98757780049388144},{"$f":"(B13*EXP(-0.9*B13))/(1-1.5*B13)","v":1.4008195751686261E-2},{"$f":"D13*3600","v":50.429504706070539},{"$f":"1-C13*EXP(-D13*($B$9-$B$7))","v":3.2956977308399416E-2}]
[100,2.7777777777777776E-2,0.97530991202833273,2.8269852522560365E-2,101.77146908121732,6.5183269235877472E-2]
[150,4.1666666666666664E-2,0.96319441772082182,4.2808640787592077E-2,154.11110683533147,9.6711206590999077E-2]
[200,5.5555555555555552E-2,0.95122942450071402,5.7650268151558423E-2,207.54096534561032,0.12757222022411585]
[250,6.9444444444444448E-2,0.93941306281347581,7.2822718047556259E-2,262.16178497120251,0.15779689549097631]
[300,8.3333333333333329E-2,0.92774348632855286,8.835652250748123E-2,318.08348102693242,0.18741502348028116]
[350,9.7222222222222224E-2,0.91621887165087768,0.10428507482205111,375.42626935938398,0.21645564876409829]
[400,0.1111111111111111,0.90483741803595963,0.12064498907146128,434.3219606572606,0.24494711332269825]
[450,0.125,0.89359734710851568,0.13747651493977164,494.9154537831779,0.27291709616204318]
[500,0.1388888888888889,0.88249690258459546,0.15482401799729748,557.36646479027092,0.30039264797568543]
[550,0.15277777777777779,0.87153434999715784,0.17273653783727455,621.8515362141884,0.32740021999393443]
[600,0.16666666666666666,0.86070797642505781,0.19126843920556838,688.56638114004613,0.35396568589998356]
[650,0.18055555555555555,0.85001609022539815,0.21048017472247951,757.72862900092628,0.38011435535986171]
[700,0.19444444444444445,0.83945702076920736,0.23043918217193932,829.58105581898155,0.4058709772907404]
[750,0.20833333333333334,0.82902911818040037,0.25122094490315167,904.39540165134599,0.43125973045448307]
[800,0.22222222222222221,0.81873075307798193,0.27291025102599392,982.47690369357815,0.45630419827682678]
[850,0.2361111111111111,0.80856031632145253,0.29560269628956326,1064.1697066424276,0.48102732391350256]
[900,0.25,0.79851621875937706,0.31940648750375084,1149.863355013503,0.50545134045584938]
[950,0.2638888888888889,0.78859689098107666,0.34444461904920592,1240.0006285771412,0.52959766971546041]
[1000,0.27777777777777779,0.77880078307140488,0.37085751574828807,1335.087056693837,0.55348678115256167]
[]
[]
[]
["Reflections"]
["1. ???"]

{"sheet":"study-green ext time","index":6,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Study: Green extension time"]
["Assumed:"]
["C",60,"sec"]
["s",1900,"veh/hr"]
["g/C",0.5]
["g",{"$f":"B5*B3","v":30},"sec"]
["Δ",1.5]
["b",0.6]
["MAH",3,"sec"]
[]
["v","q","ϕ","λ","λ (veh/hr)","p","gs","n","ge"]
[1,{"$f":"A12/3600","v":2.7777777777777778E-4},{"$f":"EXP(-$B$8*$B$7*B12)","v":0.99975003124739603},{"$f":"(B12*EXP(-0.9*B12))/(1-1.5*B12)","v":2.7782410205568874E-4},{"$f":"D12*3600","v":1.0001667674004795},{"$f":"1-C12*EXP(-D12*($B$9-$B$7))","v":6.66513933924473E-4},{"$f":"QueueServiceTime(B12,$B$3,F12,$B$4,$B$6,2,50,2)","v":3.1557921700817691E-2},{"$f":"B12*(50-G12-2)","v":1.3324567243971996E-2},{"$f":"((F12^2)*(1-F12^H12))/(B12*(1-F12))","v":1.4859255480891356E-4}]
[50,{"$f":"A13/3600","v":1.3888888888888888E-2},{"$f":"EXP(-$B$8*$B$7*B13)","v":0.98757780049388144},{"$f":"(B13*EXP(-0.9*B13))/(1-1.5*B13)","v":1.4008195751686261E-2},{"$f":"D13*3600","v":50.429504706070539},{"$f":"1-C13*EXP(-D13*($B$9-$B$7))","v":3.2956977308399416E-2},{"$f":"QueueServiceTime(B13,$B$3,F13,$B$4,$B$6,2,50,2)","v":1.5295631820964279},{"$f":"B13*(50-G13-2)","v":0.64542273358199409},{"$f":"((F13^2)*(1-F13^H13))/(B13*(1-F13))","v":7.193107605725628E-2}]
[100,2.7777777777777776E-2,0.97530991202833273,2.8269852522560365E-2,101.77146908121732,6.5183269235877472E-2,2.9724479789288241,1.2507653339186435,0.15824661090830866]
[150,4.1666666666666664E-2,0.96319441772082182,4.2808640787592077E-2,154.11110683533147,9.6711206590999077E-2,4.3450866914114075,1.8189547211911912,0.24495890910575707]
[200,5.5555555555555552E-2,0.95122942450071402,5.7650268151558423E-2,207.54096534561032,0.12757222022411585,{"$f":"QueueServiceTime(B16,$B$3,F16,$B$4,$B$6,2,50,2)","v":5.6621400355432909},{"$f":"B16*(50-G16-2)","v":2.3521033313587059},{"$f":"((F16^2)*(1-F16^H16))/(B16*(1-F16))","v":0.33313364775989834}]
[250,6.9444444444444448E-2,0.93941306281347581,7.2822718047556259E-2,262.16178497120251,0.15779689549097631,6.9370357474000972,2.8515947397638826,0.42353803511069421]
[300,8.3333333333333329E-2,0.92774348632855286,8.835652250748123E-2,318.08348102693242,0.18741502348028116,8.1824404968756355,3.3181299585936967,0.51670155305983301]
[350,9.7222222222222224E-2,0.91621887165087768,0.10428507482205111,375.42626935938398,0.21645564876409829,9.4107004561850669,3.7517374556486738,0.61307340573164959]
[400,0.1111111111111111,0.90483741803595963,0.12064498907146128,434.3219606572606,0.24494711332269825,10.634283656521584,4.1517462603864903,0.71309116007938056]
[450,0.125,0.89359734710851568,0.13747651493977164,494.9154537831779,0.27291709616204318,11.866259457788017,4.5167175677764977,0.81721083733062305]
[500,0.1388888888888889,0.88249690258459546,0.15482401799729748,557.36646479027092,0.30039264797568543,13.120857774358623,4.8443253091168579,0.92592084247193684]
[550,0.15277777777777779,0.87153434999715784,0.17273653783727455,621.8515362141884,0.32740021999393443,14.41416507236498,5.1311692250553502,1.0397467678279944]
[600,0.16666666666666666,0.86070797642505781,0.19126843920556838,688.56638114004613,0.35396568589998356,15.765039419626696,5.3724934300622174,1.1592467338605312]
[650,0.18055555555555555,0.85001609022539815,0.21048017472247951,757.72862900092628,0.38011435535986171,17.196370261171968,5.5617664806217286,1.2849905546338289]
[700,0.19444444444444445,0.83945702076920736,0.23043918217193932,829.58105581898155,0.4058709772907404,18.736883806602858,5.6900503709383337,1.4175052497359113]
[750,0.20833333333333334,0.82902911818040037,0.25122094490315167,904.39540165134599,0.43125973045448307,20.423828611870547,5.7450357058603032,1.5571449624448919]
[800,0.22222222222222221,0.81873075307798193,0.27291025102599392,982.47690369357815,0.45630419827682678,22.307122132342879,5.7095284150349155,1.7037806484380578]
[850,0.2361111111111111,0.80856031632145253,0.29560269628956326,1064.1697066424276,0.48102732391350256,24.456012638055128,5.5589970160147617,1.8560286059717039]
[900,0.25,0.79851621875937706,0.31940648750375084,1149.863355013503,0.50545134045584938,26.97027104879648,5.25743223780088,2.0091870086771322]
[950,0.2638888888888889,0.78859689098107666,0.34444461904920592,1240.0006285771412,0.52959766971546041,30.000000000000004,4.7499999999999991,2.1491007476983568]
[1000,0.27777777777777779,0.77880078307140488,0.37085751574828807,1335.087056693837,0.55348678115256167,33.782976023750521,3.9491733267359663,2.2310449594599588]
[]
[]
[]
["Reflections"]
["1. ???"]

{"sheet":"study-probability of phase call","index":7,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Study: Green extension time"]
["Assumed:"]
["C",60,"sec"]
["s",1900,"veh/hr"]
["g/C",0.5]
["g",{"$f":"B5*B3","v":30},"sec"]
["Δ",1.5]
["b",0.6]
["MAH",3,"sec"]
[]
["v","q","pv"]
[1,{"$f":"A12/3600","v":2.7777777777777778E-4},{"$f":"1-EXP(-B12*$B$3)","v":1.6528546178382508E-2}]
[50,{"$f":"A13/3600","v":1.3888888888888888E-2},{"$f":"1-EXP(-B13*$B$3)","v":0.56540179149292169}]
[100,2.7777777777777776E-2,0.81112439716243812]
[150,4.1666666666666664E-2,0.91791500137610116]
[200,5.5555555555555552E-2,0.96432600665274759]
[250,6.9444444444444448E-2,0.9844961464009907]
[300,8.3333333333333329E-2,0.99326205300091452]
[350,9.7222222222222224E-2,0.99707170030518177]
[400,0.1111111111111111,0.9987273661986602]
[450,0.125,0.99944691562985222]
[500,0.1388888888888889,0.99975963052358052]
[550,0.15277777777777779,0.9998955358561683]
[600,0.16666666666666666,0.99995460007023751]
[650,0.18055555555555555,0.9999802692718589]
[700,0.19444444444444445,0.99999142506089733]
[750,0.20833333333333334,0.99999627334682795]
[800,0.22222222222222221,0.99999838040320765]
[850,0.2361111111111111,0.99999929612613558]
[900,0.25,0.99999969409767953]
[950,0.2638888888888889,0.99999986705539956]
[1000,0.27777777777777779,0.99999994222251476]
[]
[]
[]
["Reflections"]
["1. ???"]