{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Information","Input&Findings","Vehicle","Pedestrian","W&L Examples"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":17,"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":"Information","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[29,2,29,11],[17,1,17,11],[18,1,20,11],[21,1,23,11],[24,1,25,11],[26,1,27,11],[1,0,1,11],[2,0,6,11],[8,0,9,11],[11,0,11,11],[16,0,16,11],[12,1,12,11],[13,1,14,11],[30,2,30,11],[31,2,31,11],[32,2,32,11],[33,2,33,11],[34,2,34,11]]}
[]
["Introduction"]
["The purpose of this workbook is to aid in the determination of adequate vehicle change and clearance intervals and/or pedestrian intervals for an existing or proposed signalized intersection.  The calculations and criteria contained within this workbook stem from Section 4.3 of PennDOT Publication 46, and Sections 4D.26 and 4E.06 of the 2009 MUTCD. All users shall reference these documents while completing this workbook to ensure workbook consistency and accuracy. This workbook is a tool to make a traffic engineering decision. This workbook is not a substitute for engineering judgment."]
[]
[]
[]
[]
[]
["Portions of the workbook require the user to exercise engineering judgment. Provide justification, where available, when varying from the above referenced regulations or when further explanation is necessary to support the user's findings."]
[]
[]
["Assumptions"]
[1,"The results of all timing calculations are automatically rounded up to the nearest tenth of a second."]
[2,"Default values for certain variables have been provided throughout the workbook but can be changed by the user to reflect intersection conditions. Provide justification for all deviations."]
[]
[]
["Instructions"]
[1,"This workbook accounts for a single signalized intersection."]
[2,"All pale yellow cells are available for the user to either input information or to provide a decision. Some of these input cells, when selected, provide additional information/drop-down lists for the user to input the correct information. Green cells are self calculating."]
[]
[]
[3,"Begin by filling out the top section of the \"Input&Findings\" tab. Next, complete the \"Vehicle\" and \"Pedestrian\" tabs based on field measurements, construction plans, and/or permit plans. The \"Left-Turn Movement Phases\" section of the \"Vehicle\" tab is provided to account for turn phases that have their own unique timings."]
[]
[]
[4,"Upon completion of the data entry, go back to the \"Input&Findings\" tab. Space has been provided in the Findings section of this tab to allow for engineering judgment as it relates to adjusting the calculated timings."]
[]
[5,"Print Output:  Users may either print one or more tabs using conventional Excel printing procedures or they may elect to use utilize the blue print buttons throughout the workbook (must enable macros first)."]
[]
[]
["Version #","Revision Date","Revision Description"]
[1,"2012-08-27","Original"]
[2,"2012-11-05","Per Clearance Transmittal T-12-016 Comments"]

{"sheet":"Input&Findings","index":1,"n_rows":132,"n_cols":50,"rows_kept":132,"cut":false,"hidden":false,"merged":[[0,0,0,43],[5,32,5,42],[2,32,2,42],[3,32,3,42],[7,12,8,42],[4,12,4,21],[4,32,4,42],[2,12,2,21],[3,12,3,21],[27,1,27,8],[27,12,27,17],[25,1,25,8],[26,1,26,8],[26,12,26,17],[24,12,24,17],[25,12,25,17],[24,9,24,11],[22,12,22,17],[23,12,23,17],[23,1,23,8],[24,1,24,8],[25,9,25,11],[26,9,26,11],[27,9,27,11],[23,9,23,11],[22,1,22,8],[19,12,19,17],[20,12,20,17],[21,12,21,17],[18,9,18,11],[19,9,19,11],[20,9,20,11],[21,9,21,11],[22,9,22,11],[16,39,16,41],[17,39,17,41],[19,1,19,8],[18,1,18,8],[18,12,18,17],[15,9,15,11],[16,9,16,11],[20,1,20,8],[21,1,21,8],[24,18,24,23],[25,18,25,23],[10,0,10,43],[12,0,12,43],[15,1,15,8],[16,1,16,8],[17,1,17,8],[14,12,15,17],[16,12,16,17],[17,12,17,17],[17,24,17,29],[17,9,17,11],[14,18,15,23],[14,24,15,29],[14,30,15,35],[16,18,16,23],[16,24,16,29],[16,30,16,35],[17,18,17,23],[14,36,14,41],[15,36,15,38],[15,39,15,41],[16,36,16,38],[17,36,17,38],[17,30,17,35],[18,18,18,23],[18,24,18,29],[18,30,18,35],[19,18,19,23],[19,24,19,29],[19,30,19,35],[22,18,22,23],[22,30,22,35],[26,18,26,23],[27,18,27,23],[22,24,22,29],[23,24,23,29],[24,24,24,29],[25,24,25,29],[26,24,26,29],[18,36,18,38],[19,36,19,38],[20,36,20,38],[21,36,21,38],[20,18,20,23],[20,24,20,29],[27,24,27,29],[20,30,20,35],[21,18,21,23],[21,24,21,29],[21,30,21,35],[23,30,23,35],[24,30,24,35],[25,30,25,35],[26,30,26,35],[27,30,27,35],[23,18,23,23],[18,39,18,41],[19,39,19,41],[20,39,20,41],[21,39,21,41],[25,36,25,38],[25,39,25,41],[26,36,26,38],[26,39,26,41],[27,36,27,38],[27,39,27,41],[22,36,22,38],[22,39,22,41],[23,36,23,38],[23,39,23,41],[24,36,24,38],[24,39,24,41],[43,1,43,11],[44,1,44,11],[45,1,45,11],[46,1,46,11],[47,1,47,11],[48,1,48,11],[36,0,36,43],[30,1,34,42],[41,1,41,11],[42,1,42,11],[45,17,45,21],[41,12,41,16],[42,12,42,16],[43,12,43,16],[44,12,44,16],[45,12,45,16],[46,12,46,16],[47,12,47,16],[48,12,48,16],[38,38,39,42],[40,38,40,39],[40,40,40,42],[41,38,41,39],[47,28,47,33],[48,28,48,33],[41,34,41,37],[42,34,42,37],[43,34,43,37],[44,34,44,37],[45,34,45,37],[46,34,46,37],[41,28,41,33],[42,28,42,33],[43,28,43,33],[44,28,44,33],[45,28,45,33],[46,28,46,33],[39,1,40,11],[38,12,40,16],[38,17,40,21],[38,22,40,27],[38,28,40,33],[38,34,40,37],[38,1,38,11],[47,34,47,37],[48,34,48,37],[46,22,46,27],[47,22,47,27],[48,22,48,27],[46,17,46,21],[47,17,47,21],[48,17,48,21],[41,22,41,27],[42,22,42,27],[43,22,43,27],[44,22,44,27],[45,22,45,27],[41,17,41,21],[42,17,42,21],[43,17,43,21],[44,17,44,21],[48,38,48,39],[41,40,41,42],[42,40,42,42],[43,40,43,42],[44,40,44,42],[45,40,45,42],[46,40,46,42],[47,40,47,42],[48,40,48,42],[42,38,42,39],[43,38,43,39],[44,38,44,39],[45,38,45,39],[46,38,46,39],[47,38,47,39],[58,12,58,16],[59,12,59,16],[60,12,60,16],[51,21,61,42],[57,1,57,11],[58,1,58,11],[59,1,59,11],[60,1,60,11],[50,12,52,16],[53,12,53,16],[54,12,54,16],[55,12,55,16],[56,12,56,16],[57,12,57,16],[50,1,50,11],[51,1,52,11],[53,1,53,11],[54,1,54,11],[55,1,55,11],[56,1,56,11]]}
["STUDY LOCATION AND ANALYSIS INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Municipality:","X Township",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Date:","2012-11-05"]
[null,null,null,null,null,null,null,null,null,null,null,"County:","Adams County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conducted By:","TJT"]
[null,null,null,null,null,null,null,null,null,null,null,"PennDOT Engineering District:",8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checked By:","DF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency/Company Name:","PennDOT Central Office, BOMO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Intersection Description:","Main Street (SR 0141) / Oak Street (SR 1006)"]
[]
[]
["VEHICLE AND PEDESTRIAN INTERVAL FINDINGS"]
[]
["Vehicle Change and Clearance Interval Findings"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Yellow Change Interval, Y",null,null,null,null,null,"User Defined Yellow Change Interval, Y",null,null,null,null,null,"Calculated All-Red Clearance Interval, AR",null,null,null,null,null,"User Defined All-Red Clearance Interval, AR",null,null,null,null,null,"To Be Implemented"]
[null,"Approach Description",null,null,null,null,null,null,null,"Direction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y (s)",null,null,"AR (s)"]
[null,{"$f":"IF(Vehicle!B22=\"\",\"\",Vehicle!B22)","v":"SR 1006 (Phase 4)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J22=\"\",\"\",Vehicle!J22)","v":"SB"},null,null,{"$f":"Vehicle!V22","v":4.1999999999999993},null,null,null,null,null,4.5,null,null,null,null,null,{"$f":"Vehicle!Y22","v":4.3999999999999995},null,null,null,null,null,4.5,null,null,null,null,null,{"$f":"IF(S17=\"\",M17,S17)","v":4.5},null,null,{"$f":"IF(AE17=\"\",Y17,AE17)","v":4.5}]
[null,{"$f":"IF(Vehicle!B23=\"\",\"\",Vehicle!B23)","v":"SR 1006 (Phase 8)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J23=\"\",\"\",Vehicle!J23)","v":"NB"},null,null,{"$f":"Vehicle!V23","v":3.3000000000000003},null,null,null,null,null,4.5,null,null,null,null,null,{"$f":"Vehicle!Y23","v":1.9000000000000001},null,null,null,null,null,4.5,null,null,null,null,null,{"$f":"IF(S18=\"\",M18,S18)","v":4.5},null,null,{"$f":"IF(AE18=\"\",Y18,AE18)","v":4.5}]
[null,{"$f":"IF(Vehicle!B24=\"\",\"\",Vehicle!B24)","v":"SR 0141 (Phase 2)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J24=\"\",\"\",Vehicle!J24)","v":"EB"},null,null,{"$f":"Vehicle!V24","v":4},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y24","v":4.3},null,null,null,null,null,4.5,null,null,null,null,null,4,null,null,4.5]
[null,{"$f":"IF(Vehicle!B25=\"\",\"\",Vehicle!B25)","v":"SR 0141 (Phase 6)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J25=\"\",\"\",Vehicle!J25)","v":"WB"},null,null,{"$f":"Vehicle!V25","v":3.8000000000000003},null,null,null,null,null,4,null,null,null,null,null,{"$f":"Vehicle!Y25","v":3.3000000000000003},null,null,null,null,null,4.5,null,null,null,null,null,4,null,null,4.5]
[null,{"$f":"IF(Vehicle!B26=\"\",\"\",Vehicle!B26)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J26=\"\",\"\",Vehicle!J26)","v":""},null,null,{"$f":"Vehicle!V26","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y26","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(Vehicle!B27=\"\",\"\",Vehicle!B27)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J27=\"\",\"\",Vehicle!J27)","v":""},null,null,{"$f":"Vehicle!V27","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y27","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(Vehicle!B30=\"\",\"\",Vehicle!B30)","v":"SR 0141 (Phase 5 Split)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J30=\"\",\"\",Vehicle!J30)","v":"EB"},null,null,{"$f":"Vehicle!V30","v":4},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y30","v":4.3999999999999995},null,null,null,null,null,4.5,null,null,null,null,null,{"$f":"IF(S23=\"\",M23,S23)","v":4},null,null,{"$f":"IF(AE23=\"\",Y23,AE23)","v":4.5}]
[null,{"$f":"IF(Vehicle!B31=\"\",\"\",Vehicle!B31)","v":"SR 0141 (Phase 1 Split)"},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J31=\"\",\"\",Vehicle!J31)","v":"WB"},null,null,{"$f":"Vehicle!V31","v":3.5},null,null,null,null,null,4,null,null,null,null,null,{"$f":"Vehicle!Y31","v":4.3},null,null,null,null,null,4.5,null,null,null,null,null,4,null,null,4.5]
[null,{"$f":"IF(Vehicle!B32=\"\",\"\",Vehicle!B32)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J32=\"\",\"\",Vehicle!J32)","v":""},null,null,{"$f":"Vehicle!V32","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y32","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(Vehicle!B33=\"\",\"\",Vehicle!B33)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J33=\"\",\"\",Vehicle!J33)","v":""},null,null,{"$f":"Vehicle!V33","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y33","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(Vehicle!B34=\"\",\"\",Vehicle!B34)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J34=\"\",\"\",Vehicle!J34)","v":""},null,null,{"$f":"Vehicle!V34","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y34","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[null,{"$f":"IF(Vehicle!B35=\"\",\"\",Vehicle!B35)","v":""},null,null,null,null,null,null,null,{"$f":"IF(Vehicle!J35=\"\",\"\",Vehicle!J35)","v":""},null,null,{"$f":"Vehicle!V35","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vehicle!Y35","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[]
[null,"Additional Comments/Justifications:"]
[]
[]
[]
[]
[]
[]
["Pedestrian Interval Findings"]
[]
[null,"WITH PEDESTRIAN SIGNALS",null,null,null,null,null,null,null,null,null,null,"Calculated Walk Interval, Tw",null,null,null,null,"User Defined Walk Interval, Tw",null,null,null,null,"Calculated Ped. Change Interval, Tpc",null,null,null,null,null,"User Defined Ped. Change Interval, Tpc",null,null,null,null,null,"Greater than (Tw+Tpc)min?",null,null,null,"To Be Implemented"]
[null,"Description of Pedestrian Crossing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tw (s)",null,"Tpc (s)"]
[null,{"$f":"IF(OR(Pedestrian!B20=\"\",Pedestrian!M20=\"No\"),\"\",Pedestrian!B20)","v":"Crossing of EB SR 0141 Leg 1"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",Pedestrian!S20)","v":5.8999999999999995},null,null,null,null,7,null,null,null,null,{"$f":"IF(B42=\"\",\"\",Pedestrian!V20)","v":5.8},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",IF((IF(R42=\"\",M42,R42)+IF(AC42=\"\",W42,AC42))>=Pedestrian!Y20,\"Yes\",\"No\"))","v":"Yes"},null,null,null,{"$f":"IF(AI42=\"Yes\",IF(R42=\"\",M42,R42),\"\")","v":7},null,{"$f":"IF(AC42=\"\",W42,AC42)","v":5.8}]
[null,{"$f":"IF(OR(Pedestrian!B21=\"\",Pedestrian!M21=\"No\"),\"\",Pedestrian!B21)","v":"Crossing of EB SR 0141 Leg 2"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",Pedestrian!S21)","v":6.6},null,null,null,null,7,null,null,null,null,{"$f":"IF(B43=\"\",\"\",Pedestrian!V21)","v":7.1999999999999993},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",IF((IF(R43=\"\",M43,R43)+IF(AC43=\"\",W43,AC43))>=Pedestrian!Y21,\"Yes\",\"No\"))","v":"Yes"},null,null,null,{"$f":"IF(AI43=\"Yes\",IF(R43=\"\",M43,R43),\"\")","v":7},null,{"$f":"IF(AC43=\"\",W43,AC43)","v":7.1999999999999993}]
[null,{"$f":"IF(OR(Pedestrian!B22=\"\",Pedestrian!M22=\"No\"),\"\",Pedestrian!B22)","v":"Crossing of WB SR 0141"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",Pedestrian!S22)","v":9.5},null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",Pedestrian!V22)","v":12.9},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",IF((IF(R44=\"\",M44,R44)+IF(AC44=\"\",W44,AC44))>=Pedestrian!Y22,\"Yes\",\"No\"))","v":"Yes"},null,null,null,9.5,null,12.9]
[null,{"$f":"IF(OR(Pedestrian!B23=\"\",Pedestrian!M23=\"No\"),\"\",Pedestrian!B23)","v":"Crossing of SB SR 1006"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",Pedestrian!S23)","v":7.3},null,null,null,null,7,null,null,null,null,{"$f":"IF(B45=\"\",\"\",Pedestrian!V23)","v":8.6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",IF((IF(R45=\"\",M45,R45)+IF(AC45=\"\",W45,AC45))>=Pedestrian!Y23,\"Yes\",\"No\"))","v":"Yes"},null,null,null,7,null,8.6]
[null,{"$f":"IF(OR(Pedestrian!B24=\"\",Pedestrian!M24=\"No\"),\"\",Pedestrian!B24)","v":"Crossing of NB SR 1006"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",Pedestrian!S24)","v":7.3},null,null,null,null,7,null,null,null,null,{"$f":"IF(B46=\"\",\"\",Pedestrian!V24)","v":8.6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",IF((IF(R46=\"\",M46,R46)+IF(AC46=\"\",W46,AC46))>=Pedestrian!Y24,\"Yes\",\"No\"))","v":"Yes"},null,null,null,7,null,8.6]
[null,{"$f":"IF(OR(Pedestrian!B25=\"\",Pedestrian!M25=\"No\"),\"\",Pedestrian!B25)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",Pedestrian!S25)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",Pedestrian!V25)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",IF((IF(R47=\"\",M47,R47)+IF(AC47=\"\",W47,AC47))>=Pedestrian!Y25,\"Yes\",\"No\"))","v":""},null,null,null,"",null,{"$f":"IF(AC47=\"\",W47,AC47)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B26=\"\",Pedestrian!M26=\"No\"),\"\",Pedestrian!B26)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",Pedestrian!S26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",Pedestrian!V26)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",IF((IF(R48=\"\",M48,R48)+IF(AC48=\"\",W48,AC48))>=Pedestrian!Y26,\"Yes\",\"No\"))","v":""},null,null,null,"",null,""]
[null,{"$f":"IF(OR(Pedestrian!B27=\"\",Pedestrian!M27=\"No\"),\"\",Pedestrian!B27)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",Pedestrian!S27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",Pedestrian!V27)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",IF((IF(R49=\"\",M49,R49)+IF(AC49=\"\",W49,AC49))>=Pedestrian!Y27,\"Yes\",\"No\"))","v":""},null,null,null,"",null,""]
[]
[null,"WITHOUT PEDESTRIAN SIGNALS",null,null,null,null,null,null,null,null,null,null,"Calculated Min. Green Interval, Tp",null,null,null,null,null,null,null,null,"Additional Comments/Justifications:"]
[null,"Description of Pedestrian Crossing"]
[]
[null,{"$f":"IF(OR(Pedestrian!B20=\"\",Pedestrian!M20=\"Yes\"),\"\",Pedestrian!B20)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",Pedestrian!AD20)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B21=\"\",Pedestrian!M21=\"Yes\"),\"\",Pedestrian!B21)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B55=\"\",\"\",Pedestrian!AD21)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B22=\"\",Pedestrian!M22=\"Yes\"),\"\",Pedestrian!B22)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B56=\"\",\"\",Pedestrian!AD22)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B23=\"\",Pedestrian!M23=\"Yes\"),\"\",Pedestrian!B23)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B57=\"\",\"\",Pedestrian!AD23)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B24=\"\",Pedestrian!M24=\"Yes\"),\"\",Pedestrian!B24)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B58=\"\",\"\",Pedestrian!AD24)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B25=\"\",Pedestrian!M25=\"Yes\"),\"\",Pedestrian!B25)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B59=\"\",\"\",Pedestrian!AD25)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B26=\"\",Pedestrian!M26=\"Yes\"),\"\",Pedestrian!B26)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B60=\"\",\"\",Pedestrian!AD26)","v":""}]
[null,{"$f":"IF(OR(Pedestrian!B27=\"\",Pedestrian!M27=\"Yes\"),\"\",Pedestrian!B27)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B61=\"\",\"\",Pedestrian!AD27)","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PennDOT Engineering Districts","Pennsylvania Counties"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Adams County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Allegheny County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Armstrong County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Beaver County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Bedford County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Berks County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Blair County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Bradford County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Bucks County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Butler County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Cambria County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cameron County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centre County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chester County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clarion County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearfield County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No/N/A Decision","Clinton County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","Columbia County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Crawford County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A","Cumberland County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dauphin County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delaware County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elk County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day of Week","Erie County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monday","Fayette County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuesday","Forest County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wednesday","Franklin County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thursday","Fulton County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friday","Greene County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saturday","Huntingdon County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday","Indiana County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juniata County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lackawanna County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lancaster County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lawrence County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lebanon County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lehigh County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Luzerne County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lycoming County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKean County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercer County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mifflin County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monroe County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montour County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northampton County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northumberland County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perry County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Philadelphia County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pike County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potter County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schuylkill County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Snyder County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somerset County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sullivan County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Susquehanna County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tioga County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Union County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Venango County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Westmoreland County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wyoming County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"York County"]

{"sheet":"Vehicle","index":2,"n_rows":48,"n_cols":51,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,14,10,19],[33,21,33,23],[33,24,33,26],[33,27,33,29],[33,30,33,42],[34,1,34,8],[34,9,34,11],[34,12,34,14],[34,15,34,17],[34,18,34,20],[34,21,34,23],[34,24,34,26],[34,27,34,29],[34,30,34,42],[33,1,33,8],[33,9,33,11],[33,12,33,14],[33,15,33,17],[33,18,33,20],[32,30,32,42],[27,1,27,42],[25,1,25,8],[25,9,25,11],[30,21,30,23],[30,24,30,26],[30,27,30,29],[31,21,31,23],[31,24,31,26],[31,27,31,29],[28,21,28,23],[28,24,28,26],[25,21,25,23],[25,24,25,26],[25,27,25,29],[25,30,25,42],[26,1,26,8],[26,9,26,11],[26,12,26,14],[26,15,26,17],[26,18,26,20],[26,21,26,23],[26,24,26,26],[26,27,26,29],[28,30,28,42],[20,30,20,42],[21,30,21,42],[22,30,22,42],[23,30,23,42],[24,30,24,42],[29,30,29,42],[30,30,30,42],[31,30,31,42],[26,30,26,42],[21,21,21,23],[21,24,21,26],[21,27,21,29],[22,21,22,23],[22,24,22,26],[22,27,22,29],[30,18,30,20],[31,18,31,20],[32,18,32,20],[28,27,28,29],[29,21,29,23],[29,24,29,26],[29,27,29,29],[23,21,23,23],[23,24,23,26],[23,27,23,29],[24,21,24,23],[24,24,24,26],[24,27,24,29],[32,21,32,23],[32,24,32,26],[32,27,32,29],[28,18,28,20],[22,18,22,20],[23,18,23,20],[24,18,24,20],[29,18,29,20],[25,18,25,20],[22,15,22,17],[23,15,23,17],[24,15,24,17],[29,15,29,17],[31,15,31,17],[32,15,32,17],[25,12,25,14],[25,15,25,17],[22,12,22,14],[23,12,23,14],[24,12,24,14],[29,12,29,14],[28,1,28,8],[28,9,28,11],[28,12,28,14],[28,15,28,17],[20,24,20,26],[20,27,20,29],[19,1,19,42],[30,9,30,11],[31,9,31,11],[32,9,32,11],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[21,9,21,11],[22,9,22,11],[23,9,23,11],[24,9,24,11],[29,9,29,11],[30,12,30,14],[31,12,31,14],[32,12,32,14],[20,15,20,17],[30,15,30,17],[2,0,2,43],[0,0,0,43],[4,1,4,42],[11,3,11,16],[11,17,11,19],[12,3,12,16],[21,12,21,14],[21,18,21,20],[8,1,8,20],[13,3,13,16],[13,17,13,19],[14,3,14,16],[21,15,21,17],[8,23,8,42],[17,0,17,43],[13,25,13,38],[13,39,13,41],[20,1,20,8],[20,9,20,11],[20,12,20,14],[20,18,20,20],[20,21,20,23]]}
["VEHICLE CHANGE AND CLEARANCE INTERVALS"]
[]
["Assumptions and Calibration Inputs"]
[]
[null,"Change and Clearance Intervals (CCI, seconds)"]
[]
[]
[]
[null,"Yellow Change Interval (Y, seconds)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All-Red Clearance Interval (AR, seconds)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(typ. 3-6 seconds)"]
[]
[null,"t","=","Perception-reaction time, s (1 second)",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"W","=","Width of the intersection, ft "]
[null,"V","=","Approach speed, MPH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(from the stop bar to the end of the farthest traveled lane)"]
[null,"a","=","Deceleration rate (10 ft/s2)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,"L","=","Length of Vehicle (20 ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,"g","=","Grade of approach, %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V","=","Approach speed, MPH"]
[]
[]
["Calculations"]
[]
[null,"Through Movement Phases"]
[null,"Approach Description",null,null,null,null,null,null,null,"Direction",null,null,"V",null,null,"g (%)",null,null,"W",null,null,"Y",null,null,"AR",null,null,"CCI",null,null,"Comments"]
[null,"SR 1006 (Phase 4)",null,null,null,null,null,null,null,"SB",null,null,35,null,null,-6,null,null,203,null,null,{"$f":"IF(OR(M22=\"\",P22=\"\"),\"\",ROUNDUP($R$12+(1.47*M22)/(2*$R$14+64.4*(P22/100)),1))","v":4.1999999999999993},null,null,{"$f":"IF(OR(M22=\"\",S22=\"\"),\"\",ROUNDUP((S22+$AN$14)/(1.47*M22),1))","v":4.3999999999999995},null,null,{"$f":"IF(OR(V22=\"\",Y22=\"\"),\"\",V22+Y22)","v":8.5999999999999979}]
[null,"SR 1006 (Phase 8)",null,null,null,null,null,null,null,"NB",null,null,35,null,null,5,null,null,75,null,null,{"$f":"IF(OR(M23=\"\",P23=\"\"),\"\",ROUNDUP($R$12+(1.47*M23)/(2*$R$14+64.4*(P23/100)),1))","v":3.3000000000000003},null,null,{"$f":"IF(OR(M23=\"\",S23=\"\"),\"\",ROUNDUP((S23+$AN$14)/(1.47*M23),1))","v":1.9000000000000001},null,null,{"$f":"IF(OR(V23=\"\",Y23=\"\"),\"\",V23+Y23)","v":5.2}]
[null,"SR 0141 (Phase 2)",null,null,null,null,null,null,null,"EB",null,null,35,null,null,-4,null,null,200,null,null,4,null,null,{"$f":"IF(OR(M24=\"\",S24=\"\"),\"\",ROUNDUP((S24+$AN$14)/(1.47*M24),1))","v":4.3},null,null,8.3000000000000007]
[null,"SR 0141 (Phase 6)",null,null,null,null,null,null,null,"WB",null,null,40,null,null,2,null,null,170,null,null,3.8000000000000003,null,null,{"$f":"IF(OR(M25=\"\",S25=\"\"),\"\",ROUNDUP((S25+$AN$14)/(1.47*M25),1))","v":3.3000000000000003},null,null,7.1000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M26=\"\",P26=\"\"),\"\",ROUNDUP($R$12+(1.47*M26)/(2*$R$14+64.4*(P26/100)),1))","v":""},null,null,{"$f":"IF(OR(M26=\"\",S26=\"\"),\"\",ROUNDUP((S26+$AN$14)/(1.47*M26),1))","v":""},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(OR(M27=\"\",S27=\"\"),\"\",ROUNDUP((S27+$AN$14)/(1.47*M27),1))","v":""},null,null,""]
[null,"Left-Turn Movement Phases"]
[null,"Approach Description",null,null,null,null,null,null,null,"Direction",null,null,"V",null,null,"g (%)",null,null,"W",null,null,"Y",null,null,"AR",null,null,"CCI",null,null,"Comments"]
[null,"SR 0141 (Phase 5 Split)",null,null,null,null,null,null,null,"EB",null,null,35,null,null,-4,null,null,203,null,null,{"$f":"IF(OR(M30=\"\",P30=\"\"),\"\",ROUNDUP($R$12+(1.47*M30)/(2*$R$14+64.4*(P30/100)),1))","v":4},null,null,{"$f":"IF(OR(M30=\"\",S30=\"\"),\"\",ROUNDUP((S30+$AN$14)/(1.47*M30),1))","v":4.3999999999999995},null,null,{"$f":"IF(OR(V30=\"\",Y30=\"\"),\"\",V30+Y30)","v":8.3999999999999986}]
[null,"SR 0141 (Phase 1 Split)",null,null,null,null,null,null,null,"WB",null,null,35,null,null,2,null,null,200,null,null,{"$f":"IF(OR(M31=\"\",P31=\"\"),\"\",ROUNDUP($R$12+(1.47*M31)/(2*$R$14+64.4*(P31/100)),1))","v":3.5},null,null,{"$f":"IF(OR(M31=\"\",S31=\"\"),\"\",ROUNDUP((S31+$AN$14)/(1.47*M31),1))","v":4.3},null,null,{"$f":"IF(OR(V31=\"\",Y31=\"\"),\"\",V31+Y31)","v":7.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(OR(M32=\"\",S32=\"\"),\"\",ROUNDUP((S32+$AN$14)/(1.47*M32),1))","v":""},null,null,{"$f":"IF(OR(V32=\"\",Y32=\"\"),\"\",V32+Y32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(OR(M33=\"\",S33=\"\"),\"\",ROUNDUP((S33+$AN$14)/(1.47*M33),1))","v":""},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(OR(M34=\"\",S34=\"\"),\"\",ROUNDUP((S34+$AN$14)/(1.47*M34),1))","v":""},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(OR(M35=\"\",S35=\"\"),\"\",ROUNDUP((S35+$AN$14)/(1.47*M35),1))","v":""},null,null,""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direction","Ltspeed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EB",25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NB",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-EB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-WB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S-EB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S-WB"]

{"sheet":"Pedestrian","index":3,"n_rows":27,"n_cols":36,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,22,6,37],[4,19,4,38],[8,35,8,37],[25,18,25,20],[18,1,18,11],[19,1,19,11],[20,1,20,11],[21,1,21,11],[22,1,22,11],[24,1,24,11],[25,1,25,11],[24,18,24,20],[23,18,23,20],[18,12,18,14],[19,12,19,14],[20,12,20,14],[21,21,21,23],[22,21,22,23],[23,21,23,23],[21,12,21,14],[22,12,22,14],[23,12,23,14],[22,18,22,20],[21,15,21,17],[21,18,21,20],[26,1,26,11],[23,1,23,11],[23,15,23,17],[24,12,24,14],[25,12,25,14],[26,12,26,14],[26,15,26,17],[20,21,20,23],[0,0,0,43],[2,0,2,43],[19,15,19,17],[22,15,22,17],[20,15,20,17],[20,18,20,20],[4,1,5,8],[6,1,6,8],[7,1,8,8],[9,1,9,8],[16,0,16,43],[10,1,11,8],[12,1,12,8],[11,19,12,26],[13,19,13,26],[20,29,20,31],[21,29,21,31],[22,29,22,31],[23,29,23,31],[24,29,24,31],[13,1,14,17],[14,19,15,35],[18,24,18,27],[19,24,19,27],[18,29,18,31],[19,29,19,31],[18,21,18,23],[19,21,19,23],[19,18,19,20],[18,15,18,17],[18,18,18,20],[18,33,18,42],[19,33,19,42],[24,15,24,17],[24,21,24,23],[25,21,25,23],[26,21,26,23],[26,18,26,20],[25,15,25,17],[25,33,25,42],[26,33,26,42],[25,29,25,31],[26,29,26,31],[20,24,20,27],[21,24,21,27],[22,24,22,27],[20,33,20,42],[21,33,21,42],[22,33,22,42],[23,33,23,42],[24,33,24,42],[23,24,23,27],[24,24,24,27],[25,24,25,27],[26,24,26,27]]}
["PEDESTRIAN INTERVALS"]
[]
["Assumptions and Calibration Inputs"]
[]
[null,"Walk Interval1       ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Interval Variables"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L","=","Pedestrian walking distance from the curb or edge of shoulder to the far edge of the traveled way, ft"]
[null,"(Tw, seconds)"]
[null,"Pedestrian Change Interval"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sw","=","Walking Speed, ft/s (3.5 ft/s)",null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"(Tpc, seconds)"]
[null,"Minimum Duration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum Green Interval2"]
[null,"((Tw+Tpc)min, seconds)"]
[null,"1) The walk interval should be at least 7 seconds, but where justified, a minimum 4 second interval may be used.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Tp, seconds)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Minimum green interval when no pedestrian signals are present or proposed"]
[]
["Calculations"]
[]
[null,"Description of Pedestrian Crossing",null,null,null,null,null,null,null,null,null,null,"Ped Signal",null,null,"L",null,null,"Tw",null,null,"Tpc",null,null,"(Tw+Tpc)min",null,null,null,null,"Tp",null,null,null,"Comments"]
[null,"Crossing of EB SR 0141 Leg 1",null,null,null,null,null,null,null,null,null,null,"Yes",null,null,20,null,null,{"$f":"IF(M20=\"Yes\",IF(P20=\"\",\"\",ROUNDUP(((0.5*P20)/$AJ$9+3),1)),IF(P20=\"\",\"\",\"N/A\"))","v":5.8999999999999995},null,null,{"$f":"IF(M20=\"Yes\",IF(P20=\"\",\"\",ROUNDUP(P20/$AJ$9,1)),IF(P20=\"\",\"\",\"N/A\"))","v":5.8},null,null,{"$f":"IF(M20=\"Yes\",IF(P20=\"\",\"\",ROUNDUP((P20+6)/3,1)),IF(P20=\"\",\"\",\"N/A\"))","v":8.6999999999999993},null,null,null,null,{"$f":"IF(M20=\"Yes\",IF(P20=\"\",\"\",\"N/A\"),IF(P20=\"\",\"\",ROUNDUP((P20/$AJ$9)+3,1)))","v":"N/A"}]
[null,"Crossing of EB SR 0141 Leg 2",null,null,null,null,null,null,null,null,null,null,"Yes",null,null,25,null,null,{"$f":"IF(M21=\"Yes\",IF(P21=\"\",\"\",ROUNDUP(((0.5*P21)/$AJ$9+3),1)),IF(P21=\"\",\"\",\"N/A\"))","v":6.6},null,null,{"$f":"IF(M21=\"Yes\",IF(P21=\"\",\"\",ROUNDUP(P21/$AJ$9,1)),IF(P21=\"\",\"\",\"N/A\"))","v":7.1999999999999993},null,null,{"$f":"IF(M21=\"Yes\",IF(P21=\"\",\"\",ROUNDUP((P21+6)/3,1)),IF(P21=\"\",\"\",\"N/A\"))","v":10.4},null,null,null,null,{"$f":"IF(M21=\"Yes\",IF(P21=\"\",\"\",\"N/A\"),IF(P21=\"\",\"\",ROUNDUP((P21/$AJ$9)+3,1)))","v":"N/A"}]
[null,"Crossing of WB SR 0141",null,null,null,null,null,null,null,null,null,null,"Yes",null,null,45,null,null,9.5,null,null,12.9,null,null,17,null,null,null,null,"N/A"]
[null,"Crossing of SB SR 1006",null,null,null,null,null,null,null,null,null,null,"Yes",null,null,30,null,null,7.3,null,null,8.6,null,null,12,null,null,null,null,"N/A"]
[null,"Crossing of NB SR 1006",null,null,null,null,null,null,null,null,null,null,"Yes",null,null,30,null,null,7.3,null,null,8.6,null,null,12,null,null,null,null,"N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,null,"",null,null,null,null,""]

{"sheet":"W&L Examples","index":4,"n_rows":84,"n_cols":49,"rows_kept":84,"cut":false,"hidden":false,"merged":[[79,34,80,47],[46,27,47,52],[60,36,60,43],[69,0,70,25],[0,0,1,25],[0,27,1,52],[23,0,24,25],[23,27,24,52],[46,0,47,25],[13,36,13,45],[13,9,13,15]]}
["Example 1: Width of Intersection (W)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example 2: Width of Intersection (W)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane"]
[]
[]
[]
["Example 3: Width of Intersection (W)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example 4: Width of Intersection (W) for Left-Turns"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"W",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT Lane",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LT Lane"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane"]
[]
[]
["Example 1: Pedestrian Walking Distance (L)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Example 2: Pedestrian Walking Distance (L)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[]
[]
[]
[]
[]
[]
[]
[]
["Example 3: Pedestrian Walking Distance (L)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"L"]
[]
[null,null,null,null,null,null,null,"↑",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reserved"]
[null,null,null,null,null,null,"Ped. Signal","o",null,null,null,null,null,null,null,"L",null,null,"No Ped. Signal"]
[null,null,null,null,null,null,null,"↓"]
[]
[null,null,null,null,null,null,null,null,null,null,"L"]