{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PROJECT INFO","CLEARANCE INT. With Speed Study","C. INT. Without Speed Study","LPI Duration"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":251,"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":"PROJECT INFO","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[5,0,6,2],[0,0,1,2],[2,2,4,2]]}
["PROJECT INFORMATION"]
[]
["PROJECT/PID:"]
["INTERSECTION NAME:"]
["STUDY DATE:"]

{"sheet":"CLEARANCE INT. With Speed Study","index":1,"n_rows":56,"n_cols":41,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,2,4,2],[2,3,3,3],[1,3,1,11],[0,3,0,17],[0,0,4,0],[0,1,4,1],[2,4,3,4],[0,18,0,31],[1,12,1,14],[1,15,1,17],[2,21,4,21],[2,31,3,31],[2,29,3,29],[2,23,3,23],[2,28,4,28],[1,26,1,29],[2,30,3,30],[1,30,1,31],[1,18,4,18],[1,19,4,19]]}
["ASSOCIATED PHASE","DIRECTION","MOVEMENT","TRAFFIC SIGNAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEDESTRIAN"]
[null,null,null,"FACTORS\n*(TEM 403-2)",null,null,null,null,null,null,null,null,"CALCULATED       (TEM 403-2)",null,null,"FINAL CLEARANCE",null,null,"PED MOVEMENT","ASSOCIATED PHASE",null,null,null,"OMUTCD 4E.06-12","OMUTCD 4E.06-07",null,"3 fps CHECKS\n(OMUTCD 4E.06, 01-14)",null,null,null,"FINAL PED TIMING"]
[null,null,null,"POSTED SPEED LIMIT","85th PERCENTILE SPEED\n(FROM SPEED STUDY)","PERCEPTION/REACTION TIME (1s TYP)","YELLOW CHANGE  APPROACH SPEED*"," RED APPROACH SPEED*","DECELERATION RATE\n(10 fps TYP)","WIDTH OF INTERSECTION*","LENGTH OF VEHICLE (20 ft TYP)","APPROACH GRADE","YELLOW"," RED","Y + R","YELLOW","RED","Y + R",null,null,"CROSSWALK LENGTH","PUSHBUTTON PROVIDED","DISTANCE TO PUSHBUTTON FROM CURB (furthest of the two corners)","WALK INTERVAL\n(4-7s TYP)","CALCULATED PED CLEARANCE","PED CHANGE INTERVAL (FDW)","(L+P)/(3 fps)  (NOTE: P=6 IF NO PUSHBUTTON)","WALK +  PED CHANGE  INTERVALS + YELLOW","IS Y>=X?","ADDITIONAL WALK INTERVAL REQUIRED","FINAL WALK INTERVAL","FINAL PED CHANGE INTERVAL (FDW)"]
[null,null,null,null,null,"t","VY","VR","a","W","L","g","Y","R","TOTAL","Y\n(3-6s TYP)","R\n (1-6s TYP)","TOTAL",null,null,"L",null,"P",null,"= 3.5 fps WALK TIME","= 3.5 fps WALK TIME - YELLOW","X","Y"]
[null,null,null,"MPH","MPH","SEC","MPH","MPH","FPS","FT","FT","%","SEC","SEC","SEC","SEC","SEC","SEC",null,null,"FT",null,"FT","SEC","SEC","SEC","SEC","SEC",null,"SEC","SEC","SEC",null,null,null,null,null,"-",null,"-","-"]
[1,"-","-","-","-",1,{"$f":"E6","v":"-"},{"$f":"E6","v":"-"},10,"-",20,"-",{"$f":"IF(L6=\"-\",\"-\",ROUND($F6+((1.47*$G6)/(2*($I6)+64.4*($L6*0.01))),1))","v":"-"},{"$f":"IF(J6=\"-\",\"-\",ROUND(((($J6+$K6)/(1.47*$H6))-1),1))","v":"-"},{"$f":"IF(M6=\"-\",\"-\",ROUND(($M6+$N6),1))","v":"-"},"-","-",{"$f":"IF(Q6=\"-\",\"-\",$P6+$Q6)","v":"-"},"-","-","-","-","-","-",{"$f":"IF($U6=\"-\",\"-\",$U6/3.5)","v":"-"},{"$f":"IF(Y6=\"-\",\"-\",$Y6-$P6)","v":"-"},{"$f":"IF(V6=\"NO\",(($U6+6)/3),IF(V6=\"YES\",(($U6+$W6)/3),\"-\"))","v":"-"},{"$f":"IF(X6=\"-\",\"-\",$X6+$Z6+$P6)","v":"-"},{"$f":"IF(AB6=\"-\",\"-\",IF($AB6>=$AA6,\"YES\",\"NO\"))","v":"-"},{"$f":"IF(AC6=\"-\",\"-\",IF($AC6=\"NO\",$AA6-$AB6,\"N/A\" ))","v":"-"},{"$f":"IF(AD6=\"-\",\"-\",IF(AD6=\"N/A\",ROUNDUP(X6,0),ROUNDUP(X6+AD6,0)))","v":"-"},{"$f":"IF(Z6=\"-\",\"-\",ROUNDUP(Z6,0))","v":"-"},null,null,null,"-",null,"NB",null,3,1]
[2,"-","-","-","-",1,{"$f":"E7","v":"-"},{"$f":"E7","v":"-"},10,"-",20,"-",{"$f":"IF(L7=\"-\",\"-\",ROUND($F7+((1.47*$G7)/(2*($I7)+64.4*($L7*0.01))),1))","v":"-"},{"$f":"IF(J7=\"-\",\"-\",ROUND(((($J7+$K7)/(1.47*$H7))-1),1))","v":"-"},{"$f":"IF(M7=\"-\",\"-\",ROUND(($M7+$N7),1))","v":"-"},"-","-",{"$f":"IF(Q7=\"-\",\"-\",$P7+$Q7)","v":"-"},"-","-","-","-","-","-",{"$f":"IF($U7=\"-\",\"-\",$U7/3.5)","v":"-"},{"$f":"IF(Y7=\"-\",\"-\",$Y7-$P7)","v":"-"},{"$f":"IF(V7=\"NO\",(($U7+6)/3),IF(V7=\"YES\",(($U7+$W7)/3),\"-\"))","v":"-"},{"$f":"IF(X7=\"-\",\"-\",$X7+$Z7+$P7)","v":"-"},{"$f":"IF(AB7=\"-\",\"-\",IF($AB7>=$AA7,\"YES\",\"NO\"))","v":"-"},{"$f":"IF(AC7=\"-\",\"-\",IF($AC7=\"NO\",$AA7-$AB7,\"N/A\" ))","v":"-"},{"$f":"IF(AD7=\"-\",\"-\",IF(AD7=\"N/A\",ROUNDUP(X7,0),ROUNDUP(X7+AD7,0)))","v":"-"},{"$f":"IF(Z7=\"-\",\"-\",ROUNDUP(Z7,0))","v":"-"},null,null,null,"YES",null,"SB",null,3.1,1.1000000000000001]
[3,"-","-","-","-",1,"-",{"$f":"E8","v":"-"},10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"NO",null,"EB",null,3.2,1.2]
[4,"-","-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,"WB",null,3.3,1.3]
[5,"-","-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"-",null,"NB LT",null,3.4,1.4]
[6,"-","-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"THROUGH/RT",null,"SB LT",null,3.5,1.5]
[7,"-","-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"LEFT TURN",null,"EB LT",null,3.6,1.6]
[8,"-","-","-","-",1,"-",{"$f":"E13","v":"-"},10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,"WB LT"," ",3.7,1.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE",null,3.8,1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NW",null,3.9,1.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE",null,4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW",null,4.0999999999999996,2.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEB LT",null,4.2,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWB LT",null,4.3,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEB LT",null,4.4000000000000004,2.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWB LT",null,4.5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5999999999999996,2.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7,2.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9000000000000004,2.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996,3.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2,3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3,3.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4,3.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6,3.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7,3.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8,3.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9,3.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]

{"sheet":"C. INT. Without Speed Study","index":2,"n_rows":56,"n_cols":40,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,27,4,27],[2,28,3,28],[2,29,3,29],[0,0,4,0],[0,1,4,1],[0,2,4,2],[0,3,0,16],[0,17,0,30],[1,3,1,10],[1,11,1,13],[1,14,1,16],[1,17,4,17],[1,18,4,18],[2,30,3,30],[1,25,1,28],[1,29,1,30],[2,3,3,3],[2,20,4,20],[2,22,3,22]]}
["ASSOCIATED PHASE","DIRECTION","MOVEMENT","TRAFFIC SIGNAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"PEDESTRIAN"]
[null,null,null,"FACTORS\n*(TEM 403-2)",null,null,null,null,null,null,null,"CALCULATED\n(TEM 403-2)",null,null,"FINAL CLEARANCE",null,null,"PED MOVEMENT","ASSOCIATED PHASE",null,null,null,"OMUTCD 4E.06-12","OMUTCD 4E.06-07",null,"3 fps CHECKS\n(OMUTCD 4E.06, 01-14)",null,null,null,"FINAL PED TIMING"]
[null,null,null,"POSTED SPEED LIMIT","PERCEPTION/REACTION TIME (1s TYP)","YELLOW CHANGE  APPROACH SPEED*"," RED APPROACH SPEED*","DECELERATION RATE\n(10 fps TYP)","WIDTH OF INTERSECTION*","LENGTH OF VEHICLE\n(20 ft TYP)","APPROACH GRADE","YELLOW"," RED","Y + R","YELLOW"," RED","Y + R",null,null,"CROSSWALK LENGTH","PUSHBUTTON PROVIDED","DISTANCE TO PUSHBUTTON FROM CURB (furthest of the two corners)","WALK INTERVAL\n(4-7s TYP)","CALCULATED PED CLEARANCE","PED CHANGE INTERVAL (FDW)","(L+P)/(3 fps)  (NOTE: P=6 IF NO PUSHBUTTON)","WALK +  PED CHANGE  INTERVALS + YELLOW","IS Y>=X?","ADDITIONAL WALK INTERVAL REQUIRED","FINAL WALK INTERVAL","FINAL PED CHANGE INTERVAL (FDW)"]
[null,null,null,null,"t","VY","VR","a","W","L","g","Y","R","TOTAL","Y\n(3-6s TYP)","R\n(1-6s TYP)","TOTAL",null,null,"L",null,"P",null,"= 3.5 fps WALK TIME","= 3.5 fps WALK TIME - YELLOW","X","Y"]
[null,null,null,"MPH","SEC","MPH","MPH","FPS","FT","FT","%","SEC","SEC","SEC","SEC","SEC","SEC",null,null,"FT",null,"FT","SEC","SEC","SEC","SEC","SEC",null,"SEC","SEC","SEC",null,null,null,null,null,"-",null,"-","-"]
[1,"-","-","-",1,{"$f":"IF($C6=\"-\",\"-\",IF($C6=\"THROUGH/RT\",$D6+7,$D6-5))","v":"-"},{"$f":"IF($C6=\"-\",\"-\",IF($C6=\"THROUGH/RT\",$D6+7,25))","v":"-"},10,"-",20,"-",{"$f":"IF(K6=\"-\",\"-\",ROUND($E6+((1.47*$F6)/(2*($H6)+64.4*($K6*0.01))),1))","v":"-"},{"$f":"IF(I6=\"-\",\"-\",ROUND(((($I6+$J6)/(1.47*$G6))-1),1))","v":"-"},{"$f":"IF(L6=\"-\",\"-\",ROUND(($L6+$M6),1))","v":"-"},"-","-",{"$f":"IF(P6=\"-\",\"-\",$O6+$P6)","v":"-"},"-","-","-","-","-","-",{"$f":"IF($T6=\"-\",\"-\",$T6/3.5)","v":"-"},{"$f":"IF(X6=\"-\",\"-\",$X6-$O6)","v":"-"},{"$f":"IF(U6=\"NO\",(($T6+6)/3),IF(U6=\"YES\",(($T6+$V6)/3),\"-\"))","v":"-"},{"$f":"IF(W6=\"-\",\"-\",$W6+$Y6+$O6)","v":"-"},{"$f":"IF(AA6=\"-\",\"-\",IF($AA6>=$Z6,\"YES\",\"NO\"))","v":"-"},{"$f":"IF(AB6=\"-\",\"-\",IF($AB6=\"NO\",$Z6-$AA6,\"N/A\" ))","v":"-"},{"$f":"IF(AC6=\"-\",\"-\",IF(AC6=\"N/A\",ROUNDUP(W6,0),ROUNDUP(W6+AC6,0)))","v":"-"},{"$f":"IF(Y6=\"-\",\"-\",ROUNDUP(Y6,0))","v":"-"},null,null,null,"-",null,"NB",null,3,1]
[2,"EB","THROUGH/RT",35,1,{"$f":"IF($C7=\"-\",\"-\",IF($C7=\"THROUGH/RT\",$D7+7,$D7-5))","v":42},{"$f":"IF($C7=\"-\",\"-\",IF($C7=\"THROUGH/RT\",$D7+7,25))","v":42},10,75,20,0,{"$f":"IF(K7=\"-\",\"-\",ROUND($E7+((1.47*$F7)/(2*($H7)+64.4*($K7*0.01))),1))","v":4.0999999999999996},{"$f":"IF(I7=\"-\",\"-\",ROUND(((($I7+$J7)/(1.47*$G7))-1),1))","v":0.5},{"$f":"IF(L7=\"-\",\"-\",ROUND(($L7+$M7),1))","v":4.5999999999999996},4.0999999999999996,1,{"$f":"IF(P7=\"-\",\"-\",$O7+$P7)","v":5.0999999999999996},"EB",2,36,"YES",17,7,10.285714285714286,6.1857142857142868,17.666666666666668,17.285714285714285,"NO",{"$f":"IF(AB7=\"-\",\"-\",IF($AB7=\"NO\",$Z7-$AA7,\"N/A\" ))","v":0.38095238095238315},{"$f":"IF(AC7=\"-\",\"-\",IF(AC7=\"N/A\",ROUNDUP(W7,0),ROUNDUP(W7+AC7,0)))","v":8},{"$f":"IF(Y7=\"-\",\"-\",ROUNDUP(Y7,0))","v":7},null,null,null,"YES",null,"SB",null,3.1,1.1000000000000001]
[3,"-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"NO",null,"EB",null,3.2,1.2]
[4,"SB","THROUGH/RT",25,1,32,32,10,73,20,0,3.4,1,4.4000000000000004,4.4000000000000004,1,5.4,"SB",4,56,"YES",11,7,16,11.6,22.333333333333332,23,"YES","N/A",7,12,null,null,null,null,null,"WB",null,3.3,1.3]
[5,"-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"-",null,"NB LT",null,3.4,1.4]
[6,"WB","THROUGH/RT",35,1,42,42,10,77,20,0,4.0999999999999996,0.6,4.7,4.0999999999999996,1,5.0999999999999996,"WB",6,40,"YES",18,7,11.428571428571429,7.3285714285714292,19.333333333333332,18.428571428571431,"NO",0.90476190476190155,8,8,null,null,null,"THROUGH/RT",null,"SB LT",null,3.5,1.5]
[7,"-","-","-",1,"-","-",10,"-",20,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,"LEFT TURN",null,"EB LT",null,3.6,1.6]
[8,"NB","THROUGH/RT",25,1,32,32,10,71,20,{"$f":"-(689-672)/175*100","v":-9.7142857142857135},4.4000000000000004,0.9,5.3,4.4000000000000004,1,5.4,"-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,null,null,null,null,"WB LT"," ",3.7,1.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE",null,3.8,1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NW",null,3.9,1.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SE",null,4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW",null,4.0999999999999996,2.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEB LT",null,4.2,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWB LT",null,4.3,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEB LT",null,4.4000000000000004,2.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWB LT",null,4.5,2.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5999999999999996,2.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7,2.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9000000000000004,2.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996,3.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2,3.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3,3.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4,3.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6,3.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7,3.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8,3.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9,3.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]

{"sheet":"LPI Duration","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,5,4,5],[0,0,4,0],[0,1,4,1],[0,2,4,2],[0,3,4,3],[0,4,4,4]]}
["ASSOCIATED PHASE","DIRECTION","WALKING SPEED (ft/sec)","WIDTH OF FIRST LANE OF MOVING TRAFFIC (ft)","WIDTH OF SHOULDER, BIKE LANE, AND/OR PARKING LANE (ft)","LPI DURATION (sec)"]
[]
[]
[]
[]
[1,"-",3.5,"-","-",{"$f":"IF(D6=\"-\",\"-\",IF(G6, MEDIAN(3,G6,6)))","v":"-"},{"$f":"IF(D6=\"-\",\"-\",ROUND((D6+E6)/C6,0))","v":"-"},"-"]
[2,"-",3.5,"-","-",{"$f":"IF(D7=\"-\",\"-\",IF(G7, MEDIAN(3,G7,6)))","v":"-"},{"$f":"IF(D7=\"-\",\"-\",ROUND((D7+E7)/C7,0))","v":"-"},"NB"]
[3,"-",3.5,"-","-","-","-","SB"]
[4,"-",3.5,"-","-","-","-","WB"]
[5,"-",3.5,"-","-","-","-","EB"]
[6,"-",3.5,"-","-","-","-","NWB"]
[7,"-",3.5,"-","-","-","-","NEB"]
[8,"-",3.5,"-","-","-","-","SWB"]
[null,null,null,null,null,null,null,"SEB"]