{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["basic setup shell - scenario 2","scenario 2 - comp engine","scenario 2 - example calc #4","scenario 2 - example calc #5","scenario 2 - example calc #6","problem01","problem06","problem07","problem08","problem10","problem11"],"not_rendered":{"charts":2,"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":"basic setup shell - scenario 2","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)"]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)"]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS"]
["xO"]
["xCL"]
["xCR"]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]"]
["P[C2]"]
["P[C3]"]
["P[C4]"]
["P[C5]"]
["ΣP[Ci]"]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)"]
["Degree of utilization (X)"]
["Iterations",42]

{"sheet":"scenario 2 - comp engine","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)"]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)"]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS"]
["xO"]
["xCL"]
["xCR"]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]"]
["P[C2]"]
["P[C3]"]
["P[C4]"]
["P[C5]"]
["ΣP[Ci]"]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)"]
["Degree of utilization (X)"]
["Iterations",1]

{"sheet":"scenario 2 - example calc #4","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",923,0,0,0]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.25638888888888889]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",0.99991666666666668]
["xO",0]
["xCL",0]
["xCR",0]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",1]
["P[C2]",0]
["P[C3]",0]
["P[C4]",0]
["P[C5]",0]
["ΣP[Ci]",1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",3.9]
["Degree of utilization (X)",0.99991666666666668]
["Iterations",2]

{"sheet":"scenario 2 - example calc #5","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",494,300,300,300]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.13722222222222222,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",1,0.65853722921074465,0.66715918397744289,0.66715918397744289]
["xO",0.65853722921074465,1,0.66715918397744289,0.66715918397744289]
["xCL",0.66715918397744289,0.66715918397744289,1,0.65853722921074465]
["xCR",0.66715918397744289,0.66715918397744289,0.65853722921074465,1]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",3.782938888867108E-2,0,0,0]
["P[C2]",7.2955737846025687E-2,0.11078512673469676,0,0]
["P[C3]",0.1516512483133588,0,0.11365501304535049,0.11365501304535049]
["P[C4]",0.4444521703536457,0.44411774171963425,0.44700028565321315,0.44700028565321315]
["P[C5]",0.29311145459829868,0.44509713154566899,0.43934470130143638,0.43934470130143638]
["ΣP[Ci]",1,1,1,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",7.2950389813788057,7.9024467505289362,8.0059102077293147,8.0059102077293147]
["Degree of utilization (X)",1.0010414602225362,0.65853722921074465,0.66715918397744289,0.66715918397744289]
["Iterations",17]

{"sheet":"scenario 2 - example calc #6","index":4,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",600,300,300,300]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.16666666666666666,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",1,0.65853777527515611,0.6671596756582191,0.6671596756582191]
["xO",0.65853777527515611,1,0.6671596756582191,0.6671596756582191]
["xCL",0.6671596756582191,0.6671596756582191,1,0.65853777527515611]
["xCR",0.6671596756582191,0.6671596756582191,0.65853777527515611,1]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",3.782892906563165E-2,0,0,0]
["P[C2]",7.295532530162098E-2,0.11078425436725263,0,0]
["P[C3]",0.15165029992561635,0,0.11365407902843983,0.11365407902843983]
["P[C4]",0.44445218898145245,0.44411686549945711,0.44699938145896123,0.44699938145896123]
["P[C5]",0.29311325672567856,0.4450988801332903,0.43934653951259894,0.43934653951259894]
["ΣP[Ci]",1,1,1,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",7.2950471792788374,7.9024533033018738,8.0059161078986296,8.0059161078986296]
["Degree of utilization (X)",1.2158411965464728,0.65853777527515611,0.6671596756582191,0.6671596756582191]
["Iterations",13]

{"sheet":"problem01","index":5,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB",null,"NBVol","X (NB)"]
["Volume (v, veh/hr)",200,200,200,200,null,1,0]
[null,null,null,null,null,null,50,7.0000000000000007E-2]
["Calculations","NB","SB","EB","WB",null,100,0.14000000000000001]
["Lambda (λ, veh/sec)",5.5555555555555552E-2,5.5555555555555552E-2,5.5555555555555552E-2,5.5555555555555552E-2,null,150,0.22]
[null,null,null,null,null,null,200,0.28999999999999998]
["Degree of utilization","NB","SB","EB","WB",null,250,0.37]
["xS",0.29357556614767477,0.29357556614767477,0.29357556614767477,0.29357556614767477,null,300,0.45]
["xO",0.29357556614767477,0.29357556614767477,0.29357556614767477,0.29357556614767477,null,350,0.53]
["xCL",0.29357556614767477,0.29357556614767477,0.29357556614767477,0.29357556614767477,null,400,0.61]
["xCR",0.29357556614767477,0.29357556614767477,0.29357556614767477,0.29357556614767477,null,450,0.69]
[null,null,null,null,null,null,500,0.77]
["Probability of DOC cases","NB","SB","EB","WB",null,550,0.86]
["P[C1]",0.35253340182367593,0.35253340182367593,0.35253340182367593,0.35253340182367593,null,600,0.94]
["P[C2]",0.14650448055833848,0.14650448055833848,0.14650448055833848,0.14650448055833848,null,650,1.03]
["P[C3]",0.29300896111667696,0.29300896111667696,0.29300896111667696,0.29300896111667696]
["P[C4]",0.18265131229525755,0.18265131229525755,0.18265131229525755,0.18265131229525755,null,629,1]
["P[C5]",2.5301844206051097E-2,2.5301844206051097E-2,2.5301844206051097E-2,2.5301844206051097E-2]
["ΣP[Ci]",1,1,1,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",5.2843601906581465,5.2843601906581465,5.2843601906581465,5.2843601906581465]
["Degree of utilization (X)",0.29357556614767477,0.29357556614767477,0.29357556614767477,0.29357556614767477]
["Iterations",9]

{"sheet":"problem06","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",440,425,250,350]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.12222222222222222,0.11805555555555555,6.9444444444444448E-2,9.7222222222222224E-2]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",0.99932336183184423,0.97153414046945485,0.63196788462689191,0.83439052695567661]
["xO",0.97153414046945485,0.99932336183184423,0.83439052695567661,0.83439052695567661]
["xCL",0.63196788462689191,0.83439052695567661,0.99932336183184423,0.97153414046945485]
["xCR",0.83439052695567661,0.63196788462689191,0.97153414046945485,0.99932336183184423]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",1.7356851564325987E-3,4.1840740058159176E-5,3.2372521367830616E-6,7.1938881314692394E-6]
["P[C2]",5.9218023635509286E-2,6.0911868051883727E-2,1.6309294281766039E-5,1.2352658287079859E-5]
["P[C3]",1.1724744416347429E-2,2.826388078244744E-4,4.8232492571986148E-3,1.0718323479418299E-2]
["P[C4]",0.4150393071772181,0.41182833323483081,0.18509067166009224,0.37571779792983917]
["P[C5]",0.51228223961449271,0.52693531916540293,0.81006653253629057,0.61354433204432401]
["ΣP[Ci]",1,1,1,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",8.1762820513514534,8.229465660447147,9.1003375386272438,8.5823025629726732]
["Degree of utilization (X)",0.99932336183184423,0.97153414046945485,0.63196788462689191,0.83439052695567661]
["Iterations",26]

{"sheet":"problem07","index":7,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",500,500,500,500]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.1388888888888889,0.1388888888888889,0.1388888888888889,0.1388888888888889]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",1,1,1,1]
["xO",1,1,1,1]
["xCL",1,1,1,1]
["xCR",1,1,1,1]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",0,0,0,0]
["P[C2]",0,0,0,0]
["P[C3]",0,0,0,0]
["P[C4]",0,0,0,0]
["P[C5]",1,1,1,1]
["ΣP[Ci]",1,1,1,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",9.6,9.6,9.6,9.6]
["Degree of utilization (X)",1.3333333333333333,1.3333333333333333,1.3333333333333333,1.3333333333333333]
["Iterations",4]

{"sheet":"problem08","index":8,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",923,0,0,0]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",0.25638888888888889]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",0.99991666666666668]
["xO",0]
["xCL",0]
["xCR",0]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",1]
["P[C2]",0]
["P[C3]",0]
["P[C4]",0]
["P[C5]",0]
["ΣP[Ci]",1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",3.9]
["Degree of utilization (X)",0.99991666666666668]
["Iterations",2]

{"sheet":"problem10","index":9,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB",null,"WBVol","X, WB"]
["Volume (v, veh/hr)",300,0,0,747,null,25,3.1437341661759287E-2]
[null,null,null,null,null,null,50,6.3006311091481609E-2]
["Calculations","NB","SB","EB","WB",null,100,0.12654356980151796]
["Lambda (λ, veh/sec)",8.3333333333333329E-2,null,null,0.20749999999999999,null,200,0.25523799551489562]
[null,null,null,null,null,null,300,0.38613856215781928]
["Degree of utilization","NB","SB","EB","WB",null,400,0.5193024489587309]
["xS",0.483299803902695,null,null,0.99979018067516434,null,500,0.65477934302545437]
["xO",0,null,null,0.99979018067516434,null,550,0.72341591845221798]
["xCL",0,null,null,0,null,600,0.79265101857020215]
["xCR",0.99979018067516434,null,null,0.483299803902695,null,625,0.82750699150825968]
[null,null,null,null,null,null,650,0.86250311099596066]
["Probability of DOC cases","NB","SB","EB","WB",null,675,0.8976648204620773]
["P[C1]",2.1176482508400429E-4,null,null,0.51670214159755345,null,700,0.93297723757976403]
["P[C2]",0,null,null,0,null,747,0.99979011381208494]
["P[C3]",0.999788235174916,null,null,0.48329785840244655]
["P[C4]",0,null,null,0]
["P[C5]",0,null,null,0]
["ΣP[Ci]",1,null,null,1]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",5.79959764683234,null,null,4.8182659309646478]
["Degree of utilization (X)",0.483299803902695,null,null,0.99979018067516434]
["Iterations",9]

{"sheet":"problem11","index":10,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs (Scenario 2)"]
[]
["Given Conditions","NB","SB","EB","WB"]
["Volume (v, veh/hr)",284,192,336,545]
[]
["Calculations","NB","SB","EB","WB"]
["Lambda (λ, veh/sec)",7.8888888888888883E-2,5.3333333333333337E-2,9.3333333333333338E-2,0.15138888888888888]
[]
["Degree of utilization","NB","SB","EB","WB"]
["xS",0.5904968892608049,0.4186983406269813,0.66222140101966487,0.99995533697072525]
["xO",0.4186983406269813,0.5904968892608049,0.99995533697072525,0.99995533697072525]
["xCL",0.66222140101966487,0.99995533697072525,0.5904968892608049,0.4186983406269813]
["xCR",0.99995533697072525,0.66222140101966487,0.4186983406269813,0.5904968892608049]
[]
["Probability of DOC cases","NB","SB","EB","WB"]
["P[C1]",1.0025262514590211E-5,7.0624165999204183E-6,1.2153994235469751E-5,8.0408815578941945E-2]
["P[C2]",7.2208742930822016E-6,1.0183720207751995E-5,0.23803633660501983,0.15763967502031337]
["P[C3]",0.19636471718752785,0.13833148371781681,2.6279701345983422E-5,0.17386215741587285]
["P[C4]",0.52636527411795453,0.47063704581259991,0.5147013512937999,0.42436522311883296]
["P[C5]",0.27725276255770998,0.39101422433277566,0.24722387840559881,0.16372412886603882]
["ΣP[Ci]",1,1,0.99999999999999989,0.99999999999999989]
[]
["Results","NB","SB","EB","WB"]
["Departure headway (hd, sec/veh)",7.4851718357003438,7.8505938867558989,7.0952292966392658,6.6052095653112133]
["Degree of utilization (X)",0.5904968892608049,0.4186983406269813,0.66222140101966487,0.99995533697072525]
["Iterations",17]