{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["scenario 3 template","scenario3 formulas","scenario3 QAP example 25"],"not_rendered":{"charts":1,"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 3 template","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["QAP Delay Scenario 3"]
[]
["Given data","Value","Units",null,"Value","Units"]
["average arrival rate, v",null,"veh/hr",null,null,"veh/sec"]
["rate during red, vr",null,"veh/hr",null,null,"veh/sec"]
["rate during green, vg",null,"veh/hr",null,null,"veh/sec"]
["Cycle length, C",null,"sec"]
["Effective red, r",null,"sec"]
["Effective green, g",null,"sec"]
["Green ratio, g/C"]
["Red ratio, r/C"]
["Saturation flow rate, s",null,"veh/hr",null,null,"veh/sec"]
[]
["Calculated data - Delay"]
["Rate of queue clearance",null,"veh/hr",null,null,"veh/sec"]
["Maximum queue (vrr)",null,"veh"]
["Rate of queue formation",null,{"$f":"C5","v":"veh/hr"},0,null,"veh/sec"]
["Rate of queue clearance",null,"veh/hr",null,null,"veh/sec"]
["Queue service time (gs)",null,"sec"]
["Veh arrive in one cycle",null,"veh"]
["Total delay",null,"veh-sec"]
["Average delay per vehicle",null,"sec/veh"]

{"sheet":"scenario3 formulas","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["QAP Delay Scenario 3"]
[]
["Given data","Value","Units",null,"Value","Units"]
["average arrival rate, v",{"$f":"B5*B11+B6*B10","v":330},"veh/hr",null,{"$f":"B4/3600","v":9.166666666666666E-2},"veh/sec"]
["rate during red, vr",400,"veh/hr",null,{"$f":"B5/3600","v":0.1111111111111111},"veh/sec"]
["rate during green, vg",250,"veh/hr",null,6.9444444444444448E-2,"veh/sec"]
["Cycle length, C",75,"sec"]
["Effective red, r",40,"sec"]
["Effective green, g",35,"sec"]
["Green ratio, g/C",{"$f":"B9/B7","v":0.46666666666666667}]
["Red ratio, r/C",{"$f":"B8/B7","v":0.53333333333333333}]
["Saturation flow rate, s",1900,"veh/hr",null,{"$f":"B12/3600","v":0.52777777777777779},"veh/sec"]
[]
["Calculated data - Delay"]
["Rate of queue clearance",{"$f":"B12-B6","v":1650},"veh/hr",null,{"$f":"B15/3600","v":0.45833333333333331},"veh/sec"]
["Maximum queue (vrr)",{"$f":"E5*B8","v":4.4444444444444446},"veh"]
["Rate of queue formation",{"$f":"B5","v":400},{"$f":"C5","v":"veh/hr"},null,0.1111111111111111,"veh/sec"]
["Rate of queue clearance",{"$f":"B12-B6","v":1650},"veh/hr",null,{"$f":"B18/3600","v":0.45833333333333331},"veh/sec"]
["Queue service time (gs)",{"$f":"(E5*B8)/(E12-E6)","v":9.6969696969696972},"sec"]
["Veh arrive in one cycle",{"$f":"E4*B7","v":6.8749999999999991},"veh"]
["Total delay",{"$f":"0.5*(B8+B19)*B16","v":110.43771043771044},"veh-sec"]
["Average delay per vehicle",{"$f":"B21/(E4*B7)","v":16.063666972757883},"sec/veh"]

{"sheet":"scenario3 QAP example 25","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["QAP Delay Scenario 3"]
[]
["Given data","Value","Units",null,"Value","Units",null,null,"Queue Accumulation Polygon"]
["average arrival rate, v",{"$f":"B5*B11+B6*B10","v":330},"veh/hr",null,{"$f":"B4/3600","v":9.166666666666666E-2},"veh/sec",null,null,"Required data","Queue","Time",null,"Timing intervals","Y","X"]
["rate during red, vr",400,"veh/hr",null,{"$f":"B5/3600","v":0.1111111111111111},"veh/sec",null,null,"Origin",0,0,null,"Begin red",0,0]
["rate during green, vg",250,"veh/hr",null,6.9444444444444448E-2,"veh/sec",null,null,"End of red",{"$f":"B16","v":4.4444444444444446},{"$f":"B8","v":40},null,"End red",0,{"$f":"B8","v":40}]
["Cycle length, C",75,"sec",null,null,null,null,null,"Queue clears",0,{"$f":"K6+B19","v":49.696969696969695},null,"Begin green",0,{"$f":"O6","v":40}]
["Effective red, r",40,"sec",null,null,null,null,null,"End of green",0,{"$f":"B7","v":75},null,"End green",0,{"$f":"B7","v":75}]
["Effective green, g",35,"sec"]
["Green ratio, g/C",{"$f":"B9/B7","v":0.46666666666666667}]
["Red ratio, r/C",{"$f":"B8/B7","v":0.53333333333333333}]
["Saturation flow rate, s",1900,"veh/hr",null,{"$f":"B12/3600","v":0.52777777777777779},"veh/sec"]
[]
["Calculated data - Delay"]
["Rate of queue clearance",{"$f":"B12-B6","v":1650},"veh/hr",null,{"$f":"B15/3600","v":0.45833333333333331},"veh/sec"]
["Maximum queue (vrr)",{"$f":"E5*B8","v":4.4444444444444446},"veh"]
["Rate of queue formation",{"$f":"B5","v":400},{"$f":"C5","v":"veh/hr"},null,0.1111111111111111,"veh/sec"]
["Rate of queue clearance",{"$f":"B12-B6","v":1650},"veh/hr",null,{"$f":"B18/3600","v":0.45833333333333331},"veh/sec"]
["Queue service time (gs)",{"$f":"(E5*B8)/(E12-E6)","v":9.6969696969696972},"sec"]
["Veh arrive in one cycle",{"$f":"E4*B7","v":6.8749999999999991},"veh"]
["Total delay",{"$f":"0.5*(B8+B19)*B16","v":110.43771043771044},"veh-sec"]
["Average delay per vehicle",{"$f":"B21/(E4*B7)","v":16.063666972757883},"sec/veh"]