{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["basic setup shell","example calc #4","Chart1","results"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":2,"reason":"not_a_worksheet"}],"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","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs"]
[]
["Given Conditions","Volume"]
["NB"]
["SB"]
["EB"]
["WB"]
[]
["Calculations","NB","SB","EB","WB"]
["Volume"]
["Lambda"]
[]
["xS"]
["xO"]
["xCL"]
["xCR"]
[]
["P[C1]"]
["P[C2]"]
["P[C3]"]
["P[C4]"]
["P[C5]"]
[]
[]
["Results","NB","SB","EB","WB"]
["Departure headway"]
["Degree of utilization"]

{"sheet":"example calc #4","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 4 Legs"]
[]
["Given Conditions","Volume"]
["NB",493]
["SB",300]
["EB",300]
["WB",300]
[]
["Calculations","NB","SB","EB","WB"]
["Volume",923,0,0,0]
["Lambda",{"$f":"B10/3600","v":0.25638888888888889},{"$f":"C10/3600","v":0},{"$f":"D10/3600","v":0},{"$f":"E10/3600","v":0}]
[]
["xS",{"$f":"IF(B27>1,1,B27)","v":0.99991666666666668},{"$f":"IF(C27>1,1,C27)","v":0},{"$f":"IF(D27>1,1,D27)","v":0},{"$f":"IF(E27>1,1,E27)","v":0}]
["xO",{"$f":"IF(C27>1,1,C27)","v":0},{"$f":"IF(B27>1,1,B27)","v":0.99991666666666668},{"$f":"IF(E27>1,1,E27)","v":0},{"$f":"IF(D27>1,1,D27)","v":0}]
["xCL",{"$f":"IF(D27>1,1,D27)","v":0},{"$f":"IF(E27>1,1,E27)","v":0},{"$f":"IF(B27>1,1,B27)","v":0.99991666666666668},{"$f":"IF(C27>1,1,C27)","v":0}]
["xCR",{"$f":"IF(E27>1,1,E27)","v":0},{"$f":"IF(D27>1,1,D27)","v":0},{"$f":"IF(C27>1,1,C27)","v":0},{"$f":"IF(B27>1,1,B27)","v":0.99991666666666668}]
[]
["P[C1]",{"$f":"(1-B14)*(1-B15)*(1-B16)","v":1},{"$f":"(1-C14)*(1-C15)*(1-C16)","v":8.3333333333324155E-5},{"$f":"(1-D14)*(1-D15)*(1-D16)","v":8.3333333333324155E-5},{"$f":"(1-E14)*(1-E15)*(1-E16)","v":8.3333333333324155E-5}]
["P[C2]",{"$f":"B14*(1-B15)*(1-B16)","v":0},{"$f":"C14*(1-C15)*(1-C16)","v":0.99991666666666668},{"$f":"D14*(1-D15)*(1-D16)","v":0},{"$f":"E14*(1-E15)*(1-E16)","v":0}]
["P[C3]",{"$f":"(1-B14)*B15*(1-B16)+(1-B14)*(1-B15)*B16","v":0},{"$f":"(1-C14)*C15*(1-C16)+(1-C14)*(1-C15)*C16","v":0},{"$f":"(1-D14)*D15*(1-D16)+(1-D14)*(1-D15)*D16","v":0.99991666666666668},{"$f":"(1-E14)*E15*(1-E16)+(1-E14)*(1-E15)*E16","v":0.99991666666666668}]
["P[C4]",{"$f":"B14*(1-B15)*B16+B14*B15*(1-B16)+(1-B14)*B15*B16","v":0},{"$f":"C14*(1-C15)*C16+C14*C15*(1-C16)+(1-C14)*C15*C16","v":0},{"$f":"D14*(1-D15)*D16+D14*D15*(1-D16)+(1-D14)*D15*D16","v":0},{"$f":"E14*(1-E15)*E16+E14*E15*(1-E16)+(1-E14)*E15*E16","v":0}]
["P[C5]",{"$f":"B14*B15*B16","v":0},{"$f":"C14*C15*C16","v":0},{"$f":"D14*D15*D16","v":0},{"$f":"E14*E15*E16","v":0}]
[null,{"$f":"SUM(B18:B22)","v":1},{"$f":"SUM(C18:C22)","v":1},{"$f":"SUM(D18:D22)","v":1},{"$f":"SUM(E18:E22)","v":1}]
[]
["Results","NB","SB","EB","WB"]
["Departure headway",{"$f":"B18*3.9+B19*4.7+B20*5.8+B21*7+B22*9.6","v":3.9},{"$f":"C18*3.9+C19*4.7+C20*5.8+C21*7+C22*9.6","v":4.699933333333334},5.7998416666666666,5.7998416666666666]
["Degree of utilization",{"$f":"B26*B11","v":0.99991666666666668},{"$f":"C26*C11","v":0},{"$f":"D26*D11","v":0},{"$f":"E26*E11","v":0}]
[]
["Problem:"]
["Assume an intersection with 300 veh/hr on each approach.  What is the capacity of the NB approach?"]
[]
["Solution:"]
["Increase the volume on the NB approach until the degree of utilization reaches 1.  When this occurs"]
["the NB volume is the capacity of the approach."]

{"sheet":"results","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["What is capacity of NB approach"]
[]
["NB vol","XNB","Delay"]
[100,0.17199999999999999,10.5]
[200,0.35599999999999998,12.9]
[300,0.55400000000000005,17.600000000000001]
[400,0.77200000000000002,29.6]
[425,0.83,35.700000000000003]
[450,0.89,44.3]
[475,0.95199999999999996,56.2]
[480,0.96499999999999997,59]
[490,0.99099999999999999,65.3]
[492,0.996,66.099999999999994]
[493,0.999,67.3]
[494,1.0009999999999999,67.900000000000006]