{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["scenario 1-example calc03","example calc03 fig04","example calc03 fig05","problem 10"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"example calc03 fig04","index":1,"reason":"not_a_worksheet"},{"sheet":"example calc03 fig05","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":"scenario 1-example calc03","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 2 Single Lane Approaches"]
[]
["Example Calculation #1"]
["Calculations","NB","WB"]
["Volume (veh/hr)",300,200]
["Lambda (veh/sec)",{"$f":"B5/3600","v":8.3333333333333329E-2},{"$f":"C5/3600","v":5.5555555555555552E-2}]
["Departure headway (hd)",{"$f":"DepartureHeadway(B6,C6)","v":4.3849522105560528},{"$f":"DepartureHeadway(C6,B6)","v":4.5942841000047077}]
["Degree of utilization (X)",{"$f":"B6*B7","v":0.36541268421300438},{"$f":"C6*C7","v":0.2552380055558171}]
[]
[]
["Example Calculation #2"]
["Calculations","NB","WB"]
["Volume (veh/hr)",300,900]
["Lambda (veh/sec)",{"$f":"B13/3600","v":8.3333333333333329E-2},{"$f":"C13/3600","v":0.25}]
["Departure headway (hd)",{"$f":"DepartureHeadway(B14,C14)","v":6.220319891867538},{"$f":"DepartureHeadway(C14,B14)","v":4.8848839828790256}]
["Degree of utilization (X)",{"$f":"B14*B15","v":0.51835999098896146},{"$f":"C14*C15","v":1.2212209957197564}]
[]
[]
["Example Calculation #3"]
["Calculations","NB","WB"]
["Volume (veh/hr)",300,900]
["Lambda (veh/sec)",{"$f":"B21/3600","v":8.3333333333333329E-2},{"$f":"C21/3600","v":0.25}]
["Departure headway (hd)",{"$f":"DepartureHeadway(B22,C22)","v":6.220319891867538},{"$f":"DepartureHeadway(C22,B22)","v":4.8848839828790256}]
["Degree of utilization (X)",{"$f":"B22*B23","v":0.51835999098896146},{"$f":"C22*C23","v":1.2212209957197564}]
[]
[null,"vWB","hd,NB","hd,WB","XNB","XWB"]
[null,0,3.9,4.5174999999999992,0.32499999999999996,0]
[null,50,4.0197119910738142,4.5364543985866863,0.33497599925615118,6.3006311091481748E-2]
[null,100,4.1404327832115593,4.5555685240084962,0.34503606526762992,0.12654357011134712]
[null,150,4.2621751819684226,4.5748444038116665,0.3551812651640352,0.19061851682548608]
[null,200,4.3849522105560528,4.5942841000047077,0.36541268421300438,0.2552380055558171]
[null,250,4.5087771144866711,4.6138897097937219,0.37573142620722255,0.32040900762456404]
[null,300,4.6336633663366333,4.6336633663366333,0.38613861386138609,0.38613861386138609]
[null,350,4.7596246706329808,4.6536072395168881,0.39663538921941505,0.45243403717525305]
[null,400,4.8866749688667497,4.673723536737235,0.4072229140722291,0.51930261519302612]
[null,450,5.0148284446368656,4.6940145037341692,0.41790237038640543,0.58675181296677115]
[null,500,5.1440995289286136,4.7144824254136966,0.42867496074405109,0.65478922575190235]
[null,550,5.274502905530821,4.7351296267090461,0.43954190879423505,0.72342258185832653]
[null,600,5.4060535165959926,4.755958473461031,0.45050445971633268,0.79265974557683849]
[null,650,5.5387665683478771,4.7769713733217465,0.4615638806956564,0.8625087201830931]
[null,700,5.6726575369409682,4.7981707766823192,0.47272146141174731,0.93297765102156205]
[null,750,5.807742174476755,4.8195591776254858,0.48397851453972957,1.0040748286719763]
[null,800,5.9440365151815824,4.8411391149037497,0.49533637626513183,1.0758086922008332]
[null,850,6.0815568817512426,4.8629131729439461,0.50679640681260352,1.1481878325006538]
[null,900,6.220319891867538,4.8848839828790256,0.51835999098896146,1.2212209957197564]

{"sheet":"problem 10","index":3,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["AWSC Intersection Model - 2 Single Lane Approaches"]
[]
["Problem 10"]
["Calculations","NB","WB"]
["Volume (veh/hr)",300,747]
["Lambda (veh/sec)",{"$f":"B5/3600","v":8.3333333333333329E-2},{"$f":"C5/3600","v":0.20749999999999999}]
["Departure headway (hd)",{"$f":"DepartureHeadway(B6,C6)","v":5.7996031437415141},{"$f":"DepartureHeadway(C6,B6)","v":4.8182704977590722}]
["Degree of utilization (X)",{"$f":"B6*B7","v":0.48330026197845949},{"$f":"C6*C7","v":0.99979112828500749}]
[]
[]
[null,"WBVol","X, WB"]
[null,25,3.1437203880792623E-2]
[null,50,6.3006311091481748E-2]
[null,100,0.12654357011134712]
[null,200,0.2552380055558171]
[null,300,0.38613861386138609]
[null,400,0.51930261519302612]
[null,500,0.65478922575190235]
[null,550,0.72342258185832653]
[null,600,0.79265974557683849]
[null,625,0.82750725080140419]
[null,650,0.8625087201830931]
[null,675,0.8976651763537008]
[null,700,0.93297765102156205]
[null,747,{"$f":"$C$8","v":0.99979112828500749}]