{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["template","problem01","problem02"],"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":"template","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Inputs/Given Data"]
["vNB",null,"veh/hr"]
["vWB",null,"veh/hr"]
["ss1",3.9,"sec/veh"]
["ss3",5.8,"sec/veh"]
[]
["Calculations"]
["hNB",null,"sec/veh"]
["hWB",null,"sec/veh"]
[]
["Results","NB","WB"]
["h",null,null,"sec/veh"]
["X"]

{"sheet":"problem01","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Inputs/Given Data"]
["vNB",300,"veh/hr"]
["vWB",900,"veh/hr"]
["ss1",3.9,"sec/veh"]
["ss3",5.8,"sec/veh"]
[]
["Calculations"]
["hNB",{"$f":"DepartureHeadway(B2,B3)","v":6.2203198918675371},"sec/veh"]
["hWB",{"$f":"DepartureHeadway(B3,B2)","v":4.8848839828790265},"sec/veh"]
[]
["Results","NB","WB"]
["h",{"$f":"B8","v":6.2203198918675371},{"$f":"B9","v":4.8848839828790265},"sec/veh"]
["X",{"$f":"(B2/3600)*B12","v":0.51835999098896135},{"$f":"(B3/3600)*B9","v":1.2212209957197566}]

{"sheet":"problem02","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Inputs/Given Data",null,null,null,null,"Analysis"]
["vNB",300,"veh/hr",null,null,"Change in WB X as WB volume increases"]
["vWB",900,"veh/hr"]
["ss1",3.9,"sec/veh",null,null,"vWB","hNB","hWB","XNB","XWB",null,"Notes"]
["ss3",5.8,"sec/veh",null,null,0,3.9,4.5175000000000001,0.32499999999999996,0,null,"1. As the volume on the WB approach increases, the departure headway on the NB approach increases as its degree of conflict increases."]
[null,null,null,null,null,50,4.019711991073815,4.5364543985866872,0.33497599925615124,6.3006311091481762E-2,null,"2. When X on the WB approach reaches 1.00, it has reached capacity."]
["Calculations",null,null,null,null,100,4.1404327832115593,4.5555685240084971,0.34503606526762992,0.12654357011134715,null,"3. Thus for these conditions (NB vol = 300 veh/hr), the capacity of the WB approach is 750 veh/hr."]
["hNB",{"$f":"DepartureHeadway(B2,B3)","v":6.2203198918675371},"sec/veh",null,null,150,4.2621751819684235,4.5748444038116673,0.35518126516403525,0.19061851682548614]
["hWB",{"$f":"DepartureHeadway(B3,B2)","v":4.8848839828790265},"sec/veh",null,null,200,4.3849522105560528,4.5942841000047085,0.36541268421300438,0.2552380055558171]
[null,null,null,null,null,250,4.5087771144866711,4.6138897097937228,0.37573142620722255,0.32040900762456409]
["Results","NB","WB",null,null,300,4.6336633663366342,4.6336633663366342,0.38613861386138615,0.38613861386138615]
["h",{"$f":"B8","v":6.2203198918675371},{"$f":"B9","v":4.8848839828790265},"sec/veh",null,350,4.7596246706329808,4.653607239516889,0.39663538921941505,0.4524340371752531]
["X",{"$f":"(B2/3600)*B12","v":0.51835999098896135},{"$f":"(B3/3600)*B9","v":1.2212209957197566},null,null,400,4.8866749688667497,4.6737235367372358,0.4072229140722291,0.51930261519302623]
[null,null,null,null,null,450,5.0148284446368656,4.6940145037341701,0.41790237038640543,0.58675181296677126]
[null,null,null,null,null,500,5.1440995289286144,4.7144824254136974,0.4286749607440512,0.65478922575190246]
[null,null,null,null,null,550,5.274502905530821,4.735129626709047,0.43954190879423505,0.72342258185832664]
[null,null,null,null,null,600,5.4060535165959926,4.7559584734610318,0.45050445971633268,0.7926597455768386]
[null,null,null,null,null,650,5.5387665683478779,4.7769713733217474,0.46156388069565646,0.86250872018309321]
[null,null,null,null,null,700,5.6726575369409682,4.7981707766823201,0.47272146141174731,0.93297765102156227]
[null,null,null,null,null,750,5.807742174476755,4.8195591776254867,0.48397851453972957,1.0040748286719765]
[null,null,null,null,null,800,5.9440365151815833,4.8411391149037506,0.49533637626513194,1.0758086922008334]
[null,null,null,null,null,850,6.0815568817512426,4.862913172943947,0.50679640681260352,1.148187832500654]
[null,null,null,null,null,900,6.2203198918675371,4.8848839828790265,0.51835999098896135,1.2212209957197566]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Answers"]
[null,null,null,null,null,null,null,null,null,null,null,"1. The capacity of the WB approach occurs when X = 1.0; the WB volume is 750 veh/hr when X = 1.0."]
[null,null,null,null,null,null,null,null,null,null,null,"2. X on the NB approach increases somewhat as the WB volume increases, from 0.33 to 0.52."]
[null,null,null,null,null,null,null,null,null,null,null,"3. X on the NB approach is 0.48 when the WB approach reaches capacity."]