{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Signals model"],"not_rendered":{"charts":3,"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":0},{"$f":"H6+B29+B34","v":24.502216160082025},{"$f":"I27","v":0},{"$f":"J6+C29+C34","v":41.981182144632101}]
["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":12.478965984550072},0.2,{"$f":"J10+C44","v":33.502216160082028}]
["Minimum green, Gmin",5,5,"sec",null,"Green start",0.2,{"$f":"H11","v":12.478965984550072},0.2,{"$f":"J11","v":33.502216160082028}]
["Yellow time, Y",3,3,"sec",null,"Green end",0.2,{"$f":"H12+B43","v":21.502216160082025},0.2,{"$f":"J12+C43","v":40.981182144632101}]
["Red clearance, Rc",2,2,"sec",null,"Yellow start",0.2,{"$f":"H13","v":21.502216160082025}]
["Saturation flow rate, s",1900,1900,"veh/hr/green",null,"Yellow end",0.2,{"$f":"H14+B13","v":24.502216160082025}]
[null,null,null,null,null,"Red clear start",0.2,{"$f":"H15","v":24.502216160082025}]
["Intermediate values",null,null,null,null,"Red clear end",0.2,{"$f":"H16+B14","v":26.502216160082025},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":0},null,{"$f":"QueueAtEndOfGreen(C28,C15,C25,C11,C29,C34,C6)","v":0}]
["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":5.8080612200258415},null,{"$f":"UniformDelay(C2,C42,C29,C28,I27,C34,I22)","v":5.8861184644468008}]
["Queue service time, gs",{"$f":"QueueServiceTime(B23,B18,B3,B15,B19,B6,B11,B34)","v":5.6913555063919672},{"$f":"QueueServiceTime(C23,C18,C3,C15,C19,C6,C11,C34)","v":4.4584680757773318},"sec"]
["Number of extension before max out, n",{"$f":"NumberExtensionsBeforeMaxOut(B23,B11,B29,B6)","v":5.8762006241122275},{"$f":"NumberExtensionsBeforeMaxOut(C23,C11,C29,C6)","v":4.8379479915802959},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":12.478965984550072},3]
["Green extension, ge",{"$f":"GreenExtension(B33,B30,B23)","v":1.3318946691399844},{"$f":"GreenExtension(C33,C30,C23)","v":1.0204979087727395},"sec",null,"Green display",3,{"$f":"H33","v":12.478965984550072},3]
["Effective change interval, Y + Rc",{"$f":"B13+B14","v":5},{"$f":"C13+C14","v":5},"sec",null,null,3,{"$f":"H34+B43","v":21.502216160082025},3]
["Average green interval duration, G",{"$f":"AvgGreenDuration(B12,B11,B6,B29,B34)","v":9.0232501755319525},{"$f":"AvgGreenDuration(C12,C11,C6,C29,C34)","v":7.4789659845500713},"sec",null,"Yellow display",3,{"$f":"H35","v":21.502216160082025}]
["Phase duration, Dp",{"$f":"B36+B13+B14","v":14.023250175531953},{"$f":"C36+C13+C14","v":12.478965984550072},"sec",null,null,3,{"$f":"H36+B13","v":24.502216160082025}]
[null,null,null,null,null,"Red clearance display",3,{"$f":"H37","v":24.502216160082025}]
["Final values",null,null,null,null,null,3,{"$f":"H38+B14","v":26.502216160082025}]
["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":12.478965984550072}]
["Displayed green, G",{"$f":"B6+B29+B34","v":9.0232501755319525},{"$f":"C6+C29+C34","v":7.4789659845500713},"sec",null,null,3.2,{"$f":"H39","v":26.502216160082025}]
["Displayed red, R",{"$f":"B40-B43-B13","v":14.478965984550072},{"$f":"C40-C43-C13","v":16.023250175531953},"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":14.478965984550072}]
[null,null,null,null,null,null,1,{"$f":"H54+B6","v":16.478965984550072}]
[null,null,null,null,null,"Green service time, gs",1,{"$f":"H55","v":16.478965984550072}]
[null,null,null,null,null,null,1,{"$f":"H56+B29","v":22.17032149094204}]
[null,null,null,null,null,"Green extension time, ge",1,{"$f":"H57","v":22.17032149094204}]
[null,null,null,null,null,null,1,{"$f":"H58+B34","v":23.502216160082025}]
[null,null,null,null,null,"Y+Rc",1,{"$f":"H59","v":23.502216160082025}]
[null,null,null,null,null,null,1,{"$f":"H60+B13+B14","v":28.502216160082025}]