{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Signal Timing Sheet","Calculation Sheet","Coordination Sheet 1","Coordination Sheet 2","Coordination Sheet 3","Coordination Sheet 4","Coordination Sheet 5","Coordination Sheet 6","Look-Up Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":8,"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":"Signal Timing Sheet","index":0,"n_rows":64,"n_cols":37,"rows_kept":64,"cut":false,"hidden":false,"merged":[[43,0,45,5],[43,6,45,7],[32,16,32,39],[35,17,35,39],[44,32,44,35],[45,36,45,39],[44,12,44,15],[37,0,37,7],[40,8,40,15],[38,17,38,39],[41,17,41,39],[45,24,45,27],[45,28,45,31],[45,32,45,35],[43,8,43,39],[44,36,44,39],[41,8,41,15],[45,12,45,15],[2,8,2,19],[30,0,30,7],[30,8,30,11],[30,16,30,19],[6,28,6,31],[0,8,0,19],[1,8,1,19],[26,8,26,11],[29,12,29,15],[27,28,27,31],[30,20,30,23],[1,20,1,27],[30,24,30,27],[18,24,18,27],[31,22,31,23],[31,24,31,25],[5,28,5,31],[0,41,3,43],[0,28,0,39],[1,28,1,39],[2,28,2,39],[3,28,3,39],[2,20,2,27],[3,20,3,27],[30,12,30,15],[26,24,26,27],[28,0,28,7],[31,0,31,7],[27,36,27,39],[31,28,31,29],[31,30,31,31],[28,36,28,39],[29,36,29,39],[29,28,29,31],[31,34,31,35],[31,36,31,37],[30,32,30,35],[30,36,30,39],[31,38,31,39],[30,28,30,31],[31,32,31,33],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[7,28,7,31],[29,0,29,7],[23,28,23,31],[24,28,24,31],[25,28,25,31],[26,28,26,31],[3,8,3,19],[28,16,28,19],[29,16,29,19],[26,12,26,15],[27,12,27,15],[28,12,28,15],[26,16,26,19],[27,16,27,19],[28,28,28,31],[27,8,27,11],[26,20,26,23],[27,20,27,23],[27,24,27,27],[0,20,0,27],[14,36,14,39],[15,36,15,39],[16,36,16,39],[14,28,14,31],[15,28,15,31],[16,28,16,31],[17,28,17,31],[19,30,19,31],[22,28,22,31],[25,24,25,27],[8,28,8,31],[9,28,9,31],[10,28,10,31],[11,28,11,31],[12,28,12,31],[13,28,13,31],[23,24,23,27],[14,24,14,27],[15,24,15,27],[18,28,18,31],[19,28,19,29],[24,24,24,27],[19,24,19,25],[19,26,19,27],[22,24,22,27],[5,36,5,39],[6,36,6,39],[7,36,7,39],[8,36,8,39],[9,36,9,39],[10,36,10,39],[49,12,49,15],[49,16,49,19],[24,36,24,39],[25,36,25,39],[26,36,26,39],[18,36,18,39],[19,36,19,37],[19,38,19,39],[22,36,22,39],[23,36,23,39],[11,24,11,27],[12,24,12,27],[13,24,13,27],[5,24,5,27],[6,24,6,27],[7,24,7,27],[8,24,8,27],[9,24,9,27],[11,36,11,39],[12,36,12,39],[13,36,13,39],[50,0,50,3],[50,4,50,7],[50,8,50,11],[50,12,50,15],[26,32,26,35],[27,32,27,35],[28,32,28,35],[50,16,50,19],[49,0,49,3],[49,4,49,7],[37,16,37,39],[39,8,39,15],[36,0,36,7],[40,17,40,39],[16,24,16,27],[17,24,17,27],[17,36,17,39],[29,32,29,35],[22,32,22,35],[23,32,23,35],[28,24,28,27],[5,32,5,35],[6,32,6,35],[7,32,7,35],[8,32,8,35],[22,20,22,23],[23,20,23,23],[13,20,13,23],[14,20,14,23],[15,20,15,23],[16,20,16,23],[13,32,13,35],[14,32,14,35],[15,32,15,35],[16,32,16,35],[9,32,9,35],[10,32,10,35],[11,32,11,35],[12,32,12,35],[17,32,17,35],[18,32,18,35],[19,32,19,33],[19,34,19,35],[10,24,10,27],[5,20,5,23],[6,20,6,23],[7,20,7,23],[8,20,8,23],[9,20,9,23],[10,20,10,23],[24,20,24,23],[25,20,25,23],[17,20,17,23],[18,20,18,23],[19,20,19,21],[19,22,19,23],[11,20,11,23],[12,20,12,23],[22,16,22,19],[23,16,23,19],[24,16,24,19],[25,16,25,19],[17,16,17,19],[18,16,18,19],[19,16,19,17],[19,18,19,19],[12,12,12,15],[5,16,5,19],[6,16,6,19],[7,16,7,19],[8,16,8,19],[16,12,16,15],[17,12,17,15],[5,12,5,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[13,16,13,19],[14,16,14,19],[15,16,15,19],[16,16,16,19],[9,16,9,19],[10,16,10,19],[11,16,11,19],[12,16,12,19],[4,0,4,39],[5,8,5,11],[6,8,6,11],[15,0,15,7],[12,8,12,11],[7,8,7,11],[17,8,17,11],[18,8,18,11],[6,0,6,7],[13,0,13,7],[8,0,12,7],[7,0,7,7],[14,0,14,7],[11,8,11,11],[9,8,9,11],[10,8,10,11],[14,8,14,11],[15,8,15,11],[16,8,16,11],[17,0,17,7],[18,0,18,7],[18,12,18,15],[9,12,9,15],[10,12,10,15],[8,8,8,11],[14,12,14,15],[5,0,5,7],[23,12,23,15],[24,12,24,15],[25,12,25,15],[13,8,13,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[19,10,19,11],[22,8,22,11],[16,0,16,7],[22,0,22,7],[21,0,21,7],[19,8,19,9],[19,0,19,7],[20,0,20,7],[24,0,24,7],[25,0,25,7],[23,0,23,7],[19,12,19,13],[19,14,19,15],[11,12,11,15],[22,12,22,15],[15,12,15,15],[13,12,13,15],[54,8,54,11],[54,12,54,15],[29,8,29,11],[42,0,42,39],[44,24,44,27],[49,24,49,39],[50,24,50,39],[28,8,28,11],[27,0,27,7],[26,0,26,7],[24,32,24,35],[25,32,25,35],[51,0,51,3],[51,4,51,7],[51,8,51,11],[51,12,51,15],[52,8,52,11],[52,12,52,15],[29,24,29,27],[28,20,28,23],[29,20,29,23],[54,20,54,23],[52,20,52,23],[33,0,33,7],[57,0,57,3],[57,4,57,7],[57,8,57,11],[54,16,54,19],[55,0,55,3],[55,4,55,7],[55,8,55,11],[35,8,35,15],[53,0,53,3],[45,20,45,23],[53,4,53,7],[53,8,53,11],[53,12,53,15],[52,16,52,19],[49,8,49,11],[52,0,52,3],[48,0,48,39],[52,4,52,7],[41,0,41,7],[38,0,38,7],[39,0,39,7],[63,36,63,39],[62,36,62,39],[63,24,63,33],[62,24,62,33],[31,12,31,13],[32,8,32,15],[34,17,34,39],[31,20,31,21],[33,8,33,15],[34,8,34,15],[56,16,56,19],[57,16,57,19],[63,0,63,9],[63,12,63,15],[62,0,62,9],[62,12,62,15],[55,24,55,39],[56,24,56,39],[54,4,54,7],[53,16,53,19],[58,0,58,3],[58,4,58,7],[58,8,58,11],[58,12,58,15],[31,14,31,15],[31,16,31,17],[33,17,33,39],[31,26,31,27],[53,24,53,39],[49,20,49,23],[50,20,50,23],[53,20,53,23],[47,0,47,39],[40,0,40,7],[51,24,51,39],[52,24,52,39],[51,16,51,19],[51,20,51,23],[31,18,31,19],[31,8,31,9],[31,10,31,11],[45,8,45,11],[44,8,44,11],[38,8,38,15],[37,8,37,15],[36,8,36,15],[35,0,35,7],[45,16,45,19],[57,24,57,39],[58,24,58,39],[55,20,55,23],[56,12,56,15],[56,20,56,23],[57,20,57,23],[58,20,58,23],[44,28,44,31],[32,0,32,7],[34,0,34,7],[46,0,46,7],[44,16,44,19],[44,20,44,23],[36,17,36,39],[39,17,39,39],[56,0,56,3],[57,12,57,15],[58,16,58,19],[55,12,55,15],[55,16,55,19],[54,0,54,3],[56,4,56,7],[56,8,56,11],[54,24,54,39]]}
["DATE ISSUED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION"]
["CONTROLLER TYPE",null,null,null,null,null,null,null,"LMD 8000",null,null,null,null,null,null,null,null,null,null,null,"LOCATION"]
["CABINET TYPE",null,null,null,null,null,null,null,"\"M\" RACK",null,null,null,null,null,null,null,null,null,null,null,"SHEET NUMBER & REVISION"]
["SEQUENCE",null,null,null,null,null,null,null,"PEDESTRIAN",null,null,null,null,null,null,null,null,null,null,null,"PREVIOUS STS DATE"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,"OFF",null,null,null,"ON",null,null,null,"OFF",null,null,null,"ON",null,null,null,"OFF",null,null,null,"OFF",null,null,null,"OFF",null,null,null,"OFF"]
["DESCRIPTION"]
[]
[]
[]
[]
[]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,"PED"]
["OVERLAP"]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"-----\")","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"-----\")","v":"-----"}]
["YELLOW",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["MAX I/MAX II",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"-----\")","v":"-----"}]
["MAXPLAN (1,2,3,4)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$7=\"OFF\",0,\"--\")","v":"--"},"--","--","--",null,null,null,null,{"$f":"IF($U$7=\"OFF\",0,\"--\")","v":"--"},"--","--","--"]
["MAXPLAN (5,6,7,8)",null,null,null,null,null,null,null,null,null,null,null,"--","--","--","--",null,null,null,null,"--","--","--","--"]
["WALK",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!M30","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PEDESTRIAN CLEAR",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!M31","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["WALK",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"FLASH\")","v":"FLASH"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"STEADY\")","v":"STEADY"}]
["RECALL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"CNA1\")","v":"CNA1"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"OFF\")","v":"OFF"}]
["MEMORY",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,\"OFF\")","v":"OFF"},null,null,null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,\"OFF\")","v":"OFF"}]
["COORDINATION ON PHASE"]
["FIRST GREEN DISPLAY"]
["INTERSECTION FLASH"]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["AWF TIME [s] [CH1/CH2]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!M34","v":0},null,{"$f":"'Calculation Sheet'!O34","v":0},{"$f":"IF($M$7=\"OFF\",0,\"--\")","v":"--"}]
["DELAY DETECTION TIMING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROGRAMMING COMMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4."]
["PRE-EMPTION TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERATIONAL COMMENTS"]
["DELAY TIME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1."]
["PRE-EMPTION TIME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2."]
["VOLUME LOGGING & MOES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3."]
["SCM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4."]
[]
["PED PERMISSIVE",null,null,null,null,null,{"$f":"IF(M31=0,\"AUTO\",MAX(MIN('Coordination Sheet 1'!U32-'Coordination Sheet 1'!U30,'Coordination Sheet 2'!U32-'Coordination Sheet 2'!U30,'Coordination Sheet 3'!U32-'Coordination Sheet 3'!U30,'Coordination Sheet 4'!U32-'Coordination Sheet 4'!U30,'Coordination Sheet 5'!U32-'Coordination Sheet 5'!U30,'Coordination Sheet 6'!U32-'Coordination Sheet 6'!U30),1))","v":"AUTO"},null,"CYCLE (1 TO 8)"]
[null,null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
[null,null,null,null,null,null,null,null,{"$f":"IF('Coordination Sheet 1'!$AC$3=0,0,'Coordination Sheet 1'!$AC$3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 2'!$AC$3=0,0,'Coordination Sheet 2'!$AC$3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 3'!$AC$3=0,0,'Coordination Sheet 3'!$AC$3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 4'!$AC$3=0,0,'Coordination Sheet 4'!$AC$3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 5'!$AC$3=0,0,'Coordination Sheet 5'!$AC$3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 6'!$AC$3=0,0,'Coordination Sheet 6'!$AC$3)","v":0}]
["OFFSET (1 TO 4)",null,null,null,null,null,null,null,{"$f":"IF('Coordination Sheet 1'!$AC$4=0,0,IF('Coordination Sheet 1'!$AC$4-$M$31<0,'Coordination Sheet 1'!$AC$3+'Coordination Sheet 1'!$AC$4-$M$31,'Coordination Sheet 1'!$AC$4-$M$31))","v":0},null,null,null,{"$f":"IF('Coordination Sheet 2'!$AC$4=0,0,IF('Coordination Sheet 2'!$AC$4-$M$31<0,'Coordination Sheet 2'!$AC$3+'Coordination Sheet 2'!$AC$4-$M$31,'Coordination Sheet 2'!$AC$4-$M$31))","v":0},null,null,null,{"$f":"IF('Coordination Sheet 3'!$AC$4=0,0,IF('Coordination Sheet 3'!$AC$4-$M$31<0,'Coordination Sheet 3'!$AC$3+'Coordination Sheet 3'!$AC$4-$M$31,'Coordination Sheet 3'!$AC$4-$M$31))","v":0},null,null,null,{"$f":"IF('Coordination Sheet 4'!$AC$4=0,0,IF('Coordination Sheet 4'!$AC$4-$M$31<0,'Coordination Sheet 4'!$AC$3+'Coordination Sheet 4'!$AC$4-$M$31,'Coordination Sheet 4'!$AC$4-$M$31))","v":0},null,null,null,{"$f":"IF('Coordination Sheet 5'!$AC$4=0,0,IF('Coordination Sheet 5'!$AC$4-$M$31<0,'Coordination Sheet 5'!$AC$3+'Coordination Sheet 5'!$AC$4-$M$31,'Coordination Sheet 5'!$AC$4-$M$31))","v":0},null,null,null,{"$f":"IF('Coordination Sheet 6'!$AC$4=0,0,IF('Coordination Sheet 6'!$AC$4-$M$31<0,'Coordination Sheet 6'!$AC$3+'Coordination Sheet 6'!$AC$4-$M$31,'Coordination Sheet 6'!$AC$4-$M$31))","v":0}]
[]
["TIME CLOCK SETTINGS"]
["TIME OF",null,null,null,"DAY OF",null,null,null,"MAXPLAN",null,null,null,"CYCLE",null,null,null,"OFFSET",null,null,null,"SERVICEPLAN",null,null,null,"ADDITIONAL TIME CLOCK INFORMATION"]
["DAY",null,null,null,"WEEK",null,null,null,"(1 TO 8)",null,null,null,"(1 TO 8)",null,null,null,"(1 TO 8)",null,null,null,"(1 TO 8)"]
[{"$f":"'Coordination Sheet 1'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 1'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 1'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 1'!$AC$3=0,0,1)","v":0},{"$f":"IF('Coordination Sheet 1'!AF9=0,0,'Coordination Sheet 1'!AF9-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG9=0,0,'Coordination Sheet 1'!AG9-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH9=0,0,'Coordination Sheet 1'!AH9-($M$32+$O$32))","v":0}]
[{"$f":"'Coordination Sheet 2'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 2'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 2'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 2'!$AC$3=0,0,2)","v":0},{"$f":"IF('Coordination Sheet 1'!AF10=0,0,'Coordination Sheet 1'!AF10-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG10=0,0,'Coordination Sheet 1'!AG10-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH10=0,0,'Coordination Sheet 1'!AH10-($M$32+$O$32))","v":0}]
[{"$f":"'Coordination Sheet 3'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 3'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 3'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 3'!$AC$3=0,0,3)","v":0},{"$f":"IF('Coordination Sheet 1'!AF11=0,0,'Coordination Sheet 1'!AF11-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG11=0,0,'Coordination Sheet 1'!AG11-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH11=0,0,'Coordination Sheet 1'!AH11-($M$32+$O$32))","v":0}]
[{"$f":"'Coordination Sheet 4'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 4'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 4'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 4'!$AC$3=0,0,4)","v":0},{"$f":"IF('Coordination Sheet 1'!AF12=0,0,'Coordination Sheet 1'!AF12-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG12=0,0,'Coordination Sheet 1'!AG12-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH12=0,0,'Coordination Sheet 1'!AH12-($M$32+$O$32))","v":0}]
[{"$f":"'Coordination Sheet 5'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 5'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 5'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 5'!$AC$3=0,0,5)","v":0},{"$f":"IF('Coordination Sheet 1'!AF13=0,0,'Coordination Sheet 1'!AF13-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG13=0,0,'Coordination Sheet 1'!AG13-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH13=0,0,'Coordination Sheet 1'!AH13-($M$32+$O$32))","v":0}]
[{"$f":"'Coordination Sheet 6'!I4","v":0},null,null,null,{"$f":"'Coordination Sheet 6'!I3","v":0},null,null,null,{"$f":"'Coordination Sheet 6'!I2","v":0},null,null,null,{"$f":"IF('Coordination Sheet 6'!$AC$3=0,0,6)","v":0},{"$f":"IF('Coordination Sheet 1'!AF14=0,0,'Coordination Sheet 1'!AF14-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AG14=0,0,'Coordination Sheet 1'!AG14-($M$32+$O$32))","v":0},{"$f":"IF('Coordination Sheet 1'!AH14=0,0,'Coordination Sheet 1'!AH14-($M$32+$O$32))","v":0}]
[]
[]
[]
[]
[]
[]
["ENGINEER OF RECORD",null,null,null,null,null,null,null,null,null,null,null,"DATE",null,null,null,null,null,null,null,null,null,null,null,"RECEIVED & DISTRIBUTED BY MOT",null,null,null,null,null,null,null,null,null,null,null,"DATE"]

{"sheet":"Calculation Sheet","index":1,"n_rows":34,"n_cols":37,"rows_kept":34,"cut":false,"hidden":false,"merged":[[13,24,13,27],[14,24,14,27],[14,0,14,7],[13,8,13,11],[14,8,14,11],[13,12,13,15],[14,12,14,15],[13,0,13,7],[13,36,13,39],[14,36,14,39],[13,28,13,31],[14,28,14,31],[13,32,13,35],[14,32,14,35],[19,12,19,15],[20,0,20,7],[33,38,33,39],[33,36,33,37],[33,30,33,31],[33,28,33,29],[33,32,33,35],[19,32,19,35],[19,36,19,39],[32,32,32,35],[27,36,27,39],[28,36,28,39],[32,14,32,15],[28,14,28,15],[31,14,31,15],[26,14,26,15],[27,14,27,15],[24,12,24,15],[28,12,28,13],[22,12,22,13],[23,12,23,13],[0,0,0,7],[0,8,0,19],[0,28,0,39],[1,28,1,39],[2,28,2,39],[3,28,3,39],[3,0,3,7],[3,8,3,19],[2,0,2,7],[2,8,2,19],[1,0,1,7],[1,8,1,19],[0,20,0,27],[1,20,1,27],[2,20,2,27],[3,20,3,27],[30,36,30,39],[32,36,32,39],[27,32,27,35],[28,32,28,35],[29,32,29,35],[30,32,30,35],[31,32,31,35],[5,36,5,39],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[5,28,5,31],[5,32,5,35],[20,24,20,27],[20,28,20,31],[20,32,20,35],[20,36,20,39],[19,0,19,7],[19,8,19,11],[20,8,20,11],[20,12,20,15],[19,20,19,23],[27,24,27,27],[28,24,28,27],[19,24,19,27],[19,28,19,31],[11,28,11,31],[11,20,11,23],[10,20,10,23],[30,16,30,19],[29,20,29,23],[30,20,30,23],[19,16,19,19],[20,16,20,19],[20,20,20,23],[29,16,29,19],[30,24,30,27],[29,28,29,31],[30,28,30,31],[29,24,29,27],[11,24,11,27],[13,16,13,19],[14,16,14,19],[13,20,13,23],[14,20,14,23],[12,36,12,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[7,0,7,7],[7,8,7,11],[7,12,7,15],[6,36,6,39],[7,20,7,23],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[12,32,12,35],[12,8,12,11],[10,24,10,27],[10,28,10,31],[10,36,10,39],[11,32,11,35],[11,36,11,39],[7,16,7,19],[10,32,10,35],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[6,20,6,23],[6,24,6,27],[6,28,6,31],[6,32,6,35],[11,8,11,11],[11,12,11,15],[11,16,11,19],[8,24,8,27],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[8,36,8,39],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[8,20,8,23],[8,28,8,31],[8,32,8,35],[15,0,15,7],[16,0,16,7],[17,0,17,7],[18,0,18,7],[18,8,18,11],[18,12,18,15],[15,8,15,11],[16,8,16,11],[17,8,17,11],[15,12,15,13],[17,14,17,15],[16,12,16,13],[17,12,17,13],[15,14,15,15],[16,14,16,15],[18,16,18,19],[15,20,15,23],[16,20,16,23],[17,20,17,23],[18,20,18,23],[15,16,15,19],[16,16,16,19],[17,16,17,19],[18,24,18,27],[15,28,15,31],[16,28,16,31],[17,28,17,31],[18,28,18,31],[15,24,15,27],[16,24,16,27],[17,24,17,27],[28,0,28,7],[24,32,24,35],[26,8,26,11],[29,0,29,7],[30,0,30,7],[27,0,27,7],[27,8,27,11],[29,8,29,11],[30,8,30,11],[28,16,28,19],[26,0,26,7],[24,8,24,11],[28,8,28,11],[26,12,26,13],[27,12,27,13],[29,12,29,15],[30,12,30,15],[31,36,31,39],[26,16,26,19],[22,16,22,19],[23,16,23,19],[28,20,28,23],[22,20,22,23],[23,20,23,23],[26,32,26,35],[27,28,27,31],[28,28,28,31],[24,28,24,31],[26,20,26,23],[26,24,26,27],[24,24,24,27],[27,20,27,23],[24,20,24,23],[22,36,22,39],[23,36,23,39],[24,36,24,39],[26,28,26,31],[22,32,22,35],[23,32,23,35],[23,28,23,31],[29,36,29,39],[24,16,24,19],[27,16,27,19],[4,0,4,39],[25,0,25,39],[26,36,26,39],[21,0,21,39],[22,28,22,31],[22,24,22,27],[23,24,23,27],[15,36,15,39],[22,14,22,15],[23,14,23,15],[24,0,24,7],[22,8,22,11],[23,8,23,11],[22,0,22,7],[23,0,23,7],[18,36,18,39],[15,32,15,35],[16,32,16,35],[17,32,17,35],[18,32,18,35],[17,36,17,39],[16,36,16,39],[31,20,31,23],[31,28,31,31],[31,0,31,7],[31,16,31,19],[31,24,31,27],[33,0,33,7],[33,8,33,11],[33,16,33,19],[33,24,33,27],[33,12,33,13],[33,14,33,15],[33,22,33,23],[33,20,33,21],[32,0,32,7],[32,8,32,11],[31,12,31,13],[32,12,32,13],[31,8,31,11],[32,16,32,19],[32,20,32,23],[32,24,32,27],[32,28,32,31]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["CONTROLLER TYPE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I2","v":"LMD 8000"},null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["CABINET TYPE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I3","v":"\"M\" RACK"},null,null,null,null,null,null,null,null,null,null,null,"SHEET NUMBER & REVISION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC3","v":0}]
["SEQUENCE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I4","v":"PEDESTRIAN"},null,null,null,null,null,null,null,null,null,null,null,"SITE CODE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC4","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7:L7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7:X7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7:AB7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7:AF7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7:AJ7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7:AN7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["POSTED SPEED [km/h]",null,null,null,null,null,null,null,null,null,null,null,70,null,70]
["APPROACH GRADE [+/- %]",null,null,null,null,null,null,null,null,null,null,null,2,null,2]
["CLEARANCE DISTANCE [m]",null,null,null,null,null,null,null,null,null,null,null,33,null,33]
["CONFLICT DISTANCE [m]"]
["WALKING SPEED [m/s]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["WALKING DISTANCE [m]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[]
["APPROACH SPEED [km/h]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M16=0),0,M16)","v":70},null,{"$f":"IF(OR(O7=\"OFF\",O16=0),0,O16)","v":70},null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,U16)","v":0}]
["CLEARANCE SPEED [km/h]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M16=0),0,M16)","v":70},null,{"$f":"IF(OR(O7=\"OFF\",O16=0),0,O16)","v":70},null,null,null,null,null,{"$f":"IF(U7=\"OFF\",0,U16)","v":0}]
["CONFLICT SPEED [km/h]"]
[]
["CLEARANCE INTERVAL [s]"]
["YELLOW [s]"]
["RED [s]"]
["PED WALK [s]"]
["PED CLEAR [s]"]
["AWF DISTANCE [m]"]
["AWF TIME [s]"]
["AWF TIME [s] [CH1/CH2]"]

{"sheet":"Coordination Sheet 1","index":2,"n_rows":63,"n_cols":44,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,28,0,39],[1,28,1,39],[2,28,2,39],[3,31,3,33],[3,34,3,36],[3,37,3,39],[0,20,0,27],[1,20,1,27],[2,20,2,27],[3,20,3,27],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[13,16,13,19],[1,8,1,19],[22,28,22,31],[22,32,22,35],[22,36,22,39],[21,28,21,31],[14,32,14,35],[14,36,14,39],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[13,36,13,39],[14,20,14,23],[14,24,14,27],[20,20,20,23],[20,28,20,31],[20,32,20,35],[20,36,20,39],[19,16,19,19],[19,20,19,23],[21,16,21,19],[21,20,21,23],[21,24,21,27],[20,24,20,27],[19,24,19,27],[21,32,21,35],[21,36,21,39],[15,8,15,11],[15,12,15,15],[17,8,17,11],[17,12,17,15],[19,8,19,11],[18,36,18,39],[17,16,17,19],[17,20,17,23],[17,32,17,35],[17,24,17,27],[17,28,17,31],[18,24,18,27],[19,32,19,35],[19,36,19,39],[0,0,0,7],[0,8,0,19],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[4,0,4,39],[15,0,15,7],[5,0,5,7],[5,8,5,11],[5,12,5,15],[13,0,13,7],[13,8,13,11],[13,12,13,15],[7,0,7,7],[7,8,7,11],[7,12,7,15],[15,24,15,27],[5,28,5,31],[5,20,5,23],[5,24,5,27],[5,16,5,19],[7,16,7,19],[15,16,15,19],[5,32,5,35],[5,36,5,39],[1,0,1,7],[6,20,6,23],[6,24,6,27],[6,28,6,31],[6,32,6,35],[6,36,6,39],[3,28,3,30],[2,0,2,7],[3,0,3,7],[2,8,2,19],[8,20,8,23],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[8,0,12,7],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[10,12,10,15],[10,16,10,19],[12,8,12,11],[12,12,12,15],[12,16,12,19],[8,36,8,39],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[10,36,10,39],[10,24,10,27],[8,24,8,27],[8,28,8,31],[8,32,8,35],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[11,24,11,27],[12,20,12,23],[12,24,12,27],[10,28,10,31],[10,32,10,35],[16,36,16,39],[17,36,17,39],[11,28,11,31],[11,32,11,35],[11,36,11,39],[15,32,15,35],[15,36,15,39],[12,28,12,31],[15,28,15,31],[12,32,12,35],[12,36,12,39],[16,28,16,31],[14,28,14,31],[16,32,16,35],[30,0,30,7],[19,28,19,31],[16,24,16,27],[18,28,18,31],[16,0,16,7],[17,0,17,7],[18,0,18,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[19,12,19,15],[21,8,21,11],[21,12,21,15],[18,8,18,11],[15,20,15,23],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,32,18,35],[22,0,22,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[29,16,29,19],[29,8,29,11],[27,8,27,11],[28,12,28,15],[29,12,29,15],[28,16,28,19],[27,16,27,19],[20,8,20,11],[20,12,20,15],[20,16,20,19],[22,8,22,11],[22,12,22,15],[22,16,22,19],[22,24,22,27],[31,0,31,7],[32,0,32,7],[23,0,23,7],[28,0,28,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[29,0,29,7],[28,8,28,11],[22,20,22,23],[24,36,24,39],[25,32,25,35],[25,36,25,39],[25,24,25,27],[25,28,25,31],[28,20,28,23],[27,36,27,39],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[28,24,28,27],[28,28,28,31],[28,32,28,35],[23,32,23,35],[23,36,23,39],[10,20,10,23],[30,8,30,11],[30,36,30,39],[28,36,28,39],[29,28,29,31],[29,32,29,35],[29,36,29,39],[25,12,25,15],[24,8,24,11],[24,12,24,15],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,32,30,35],[26,0,26,39],[27,0,27,7],[27,12,27,15],[24,24,24,27],[24,28,24,31],[24,32,24,35],[32,24,32,27],[32,28,32,31],[32,8,32,11],[32,12,32,15],[32,16,32,19],[29,20,29,23],[29,24,29,27],[41,41,41,43],[40,41,40,43],[32,32,32,35],[32,36,32,39],[32,20,32,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[31,36,31,39],[31,8,31,11],[31,12,31,15],[31,16,31,19],[31,20,31,23],[24,16,24,19],[25,16,25,19],[25,20,25,23],[23,28,23,31],[23,20,23,23],[23,24,23,27],[24,20,24,23],[25,0,25,7],[25,8,25,11],[24,0,24,7]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,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," "]

{"sheet":"Coordination Sheet 2","index":3,"n_rows":58,"n_cols":44,"rows_kept":58,"cut":false,"hidden":false,"merged":[[14,36,14,39],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,36,13,39],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[2,0,2,7],[2,8,2,19],[2,20,2,27],[2,28,2,39],[3,0,3,7],[3,20,3,27],[3,28,3,39],[0,0,0,7],[0,8,0,19],[0,20,0,27],[0,28,0,39],[1,0,1,7],[1,8,1,19],[1,20,1,27],[1,28,1,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[4,0,4,39],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[5,28,5,31],[5,32,5,35],[5,36,5,39],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[12,8,12,11],[12,12,12,15],[12,16,12,19],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[9,8,9,11],[9,12,9,15],[9,16,9,19],[6,36,6,39],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[6,20,6,23],[6,24,6,27],[6,28,6,31],[6,32,6,35],[9,28,9,31],[9,32,9,35],[9,36,9,39],[10,36,10,39],[10,24,10,27],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,32,8,35],[9,20,9,23],[10,32,10,35],[10,20,10,23],[12,32,12,35],[12,36,12,39],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[15,28,15,31],[8,0,12,7],[12,20,12,23],[12,24,12,27],[12,28,12,31],[11,24,11,27],[11,28,11,31],[10,28,10,31],[11,32,11,35],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[8,36,8,39],[9,24,9,27],[15,32,15,35],[15,36,15,39],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[18,28,18,31],[18,32,18,35],[18,36,18,39],[19,24,19,27],[19,28,19,31],[19,32,19,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[19,36,19,39],[20,20,20,23],[20,24,20,27],[20,28,20,31],[20,32,20,35],[20,36,20,39],[19,20,19,23],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[21,36,21,39],[22,0,22,7],[22,8,22,11],[22,12,22,15],[22,16,22,19],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[23,20,23,23],[23,24,23,27],[23,36,23,39],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[22,36,22,39],[23,28,23,31],[23,32,23,35],[27,36,27,39],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[24,24,24,27],[24,28,24,31],[24,32,24,35],[25,8,25,11],[25,12,25,15],[25,16,25,19],[25,32,25,35],[24,36,24,39],[24,20,24,23],[26,0,26,39],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[27,0,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[24,0,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[25,0,25,7],[28,28,28,31],[28,32,28,35],[28,36,28,39],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[29,20,29,23],[29,24,29,27],[29,28,29,31],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[29,32,29,35],[29,36,29,39],[30,0,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,32,30,35],[30,36,30,39],[31,0,31,7],[31,8,31,11],[31,12,31,15],[31,16,31,19],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[31,36,31,39],[32,28,32,31],[32,32,32,35],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[60,16,63,23],[40,41,40,43],[41,41,41,43],[32,36,32,39],[32,20,32,23],[32,24,32,27]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,2]

{"sheet":"Coordination Sheet 3","index":4,"n_rows":58,"n_cols":44,"rows_kept":58,"cut":false,"hidden":false,"merged":[[14,36,14,39],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,36,13,39],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[2,0,2,7],[2,8,2,19],[2,20,2,27],[2,28,2,39],[3,0,3,7],[3,20,3,27],[3,28,3,39],[0,0,0,7],[0,8,0,19],[0,20,0,27],[0,28,0,39],[1,0,1,7],[1,8,1,19],[1,20,1,27],[1,28,1,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[4,0,4,39],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[5,28,5,31],[5,32,5,35],[5,36,5,39],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[12,8,12,11],[12,12,12,15],[12,16,12,19],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[9,8,9,11],[9,12,9,15],[9,16,9,19],[6,36,6,39],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[6,20,6,23],[6,24,6,27],[6,28,6,31],[6,32,6,35],[9,28,9,31],[9,32,9,35],[9,36,9,39],[10,36,10,39],[10,24,10,27],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,32,8,35],[9,20,9,23],[10,32,10,35],[10,20,10,23],[12,32,12,35],[12,36,12,39],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[15,28,15,31],[8,0,12,7],[12,20,12,23],[12,24,12,27],[12,28,12,31],[11,24,11,27],[11,28,11,31],[10,28,10,31],[11,32,11,35],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[8,36,8,39],[9,24,9,27],[15,32,15,35],[15,36,15,39],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[18,28,18,31],[18,32,18,35],[18,36,18,39],[19,24,19,27],[19,28,19,31],[19,32,19,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[19,36,19,39],[20,20,20,23],[20,24,20,27],[20,28,20,31],[20,32,20,35],[20,36,20,39],[19,20,19,23],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[21,36,21,39],[22,0,22,7],[22,8,22,11],[22,12,22,15],[22,16,22,19],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[23,20,23,23],[23,24,23,27],[23,36,23,39],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[22,36,22,39],[23,28,23,31],[23,32,23,35],[27,36,27,39],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[24,24,24,27],[24,28,24,31],[24,32,24,35],[25,8,25,11],[25,12,25,15],[25,16,25,19],[25,32,25,35],[24,36,24,39],[24,20,24,23],[26,0,26,39],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[27,0,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[24,0,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[25,0,25,7],[28,28,28,31],[28,32,28,35],[28,36,28,39],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[29,20,29,23],[29,24,29,27],[29,28,29,31],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[29,32,29,35],[29,36,29,39],[30,0,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,32,30,35],[30,36,30,39],[31,0,31,7],[31,8,31,11],[31,12,31,15],[31,16,31,19],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[31,36,31,39],[32,32,32,35],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[40,41,40,43],[41,41,41,43],[32,36,32,39],[32,20,32,23],[32,24,32,27],[32,28,32,31]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,2]

{"sheet":"Coordination Sheet 4","index":5,"n_rows":63,"n_cols":44,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,19],[0,20,0,27],[0,28,0,39],[3,20,3,27],[4,0,4,39],[3,28,3,39],[1,0,1,7],[1,8,1,19],[1,20,1,27],[1,28,1,39],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[2,28,2,39],[5,28,5,31],[5,32,5,35],[5,36,5,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[6,20,6,23],[6,24,6,27],[6,28,6,31],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[6,32,6,35],[6,36,6,39],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[8,0,12,7],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[12,8,12,11],[12,12,12,15],[8,32,8,35],[11,32,11,35],[11,36,11,39],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[10,32,10,35],[8,36,8,39],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[10,20,10,23],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[11,24,11,27],[11,28,11,31],[10,36,10,39],[10,24,10,27],[10,28,10,31],[12,32,12,35],[12,36,12,39],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[13,36,13,39],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[14,36,14,39],[15,28,15,31],[15,32,15,35],[15,36,15,39],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[16,32,16,35],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[18,36,18,39],[19,28,19,31],[19,32,19,35],[19,36,19,39],[20,24,20,27],[20,28,20,31],[20,32,20,35],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[19,20,19,23],[19,24,19,27],[20,36,20,39],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,36,21,39],[20,20,20,23],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[22,36,22,39],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[22,0,22,7],[22,8,22,11],[22,12,22,15],[22,16,22,19],[23,36,23,39],[24,0,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,32,24,35],[24,36,24,39],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,0,25,7],[25,8,25,11],[27,0,27,7],[27,8,27,11],[26,0,26,39],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[25,12,25,15],[25,16,25,19],[27,32,27,35],[27,36,27,39],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[28,28,28,31],[28,32,28,35],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[31,8,31,11],[31,12,31,15],[31,16,31,19],[30,32,30,35],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,0,30,7],[30,36,30,39],[40,41,40,43],[32,32,32,35],[32,36,32,39],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[41,41,41,43],[31,36,31,39],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[32,20,32,23],[32,24,32,27],[32,28,32,31],[31,0,31,7]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,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," "]

{"sheet":"Coordination Sheet 5","index":6,"n_rows":63,"n_cols":44,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,19],[0,20,0,27],[0,28,0,39],[3,20,3,27],[4,0,4,39],[3,28,3,39],[1,0,1,7],[1,8,1,19],[1,20,1,27],[1,28,1,39],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[2,28,2,39],[5,28,5,31],[5,32,5,35],[5,36,5,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[6,20,6,23],[6,24,6,27],[6,28,6,31],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[6,32,6,35],[6,36,6,39],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[8,0,12,7],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[12,8,12,11],[12,12,12,15],[8,32,8,35],[11,32,11,35],[11,36,11,39],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[10,32,10,35],[8,36,8,39],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[10,20,10,23],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[11,24,11,27],[11,28,11,31],[10,36,10,39],[10,24,10,27],[10,28,10,31],[12,32,12,35],[12,36,12,39],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[13,36,13,39],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[14,36,14,39],[15,28,15,31],[15,32,15,35],[15,36,15,39],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[16,32,16,35],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[18,36,18,39],[19,28,19,31],[19,32,19,35],[19,36,19,39],[20,24,20,27],[20,28,20,31],[20,32,20,35],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[19,20,19,23],[19,24,19,27],[20,36,20,39],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,36,21,39],[20,20,20,23],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[22,36,22,39],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[22,0,22,7],[22,8,22,11],[22,12,22,15],[22,16,22,19],[23,36,23,39],[24,0,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,32,24,35],[24,36,24,39],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,0,25,7],[25,8,25,11],[27,0,27,7],[27,8,27,11],[26,0,26,39],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[25,12,25,15],[25,16,25,19],[27,32,27,35],[27,36,27,39],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[28,28,28,31],[28,32,28,35],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[31,8,31,11],[31,12,31,15],[31,16,31,19],[30,32,30,35],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,0,30,7],[30,36,30,39],[40,41,40,43],[32,32,32,35],[32,36,32,39],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[41,41,41,43],[31,36,31,39],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[32,20,32,23],[32,24,32,27],[32,28,32,31],[31,0,31,7]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,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," "]

{"sheet":"Coordination Sheet 6","index":7,"n_rows":63,"n_cols":44,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,19],[0,20,0,27],[0,28,0,39],[2,28,2,39],[4,0,4,39],[3,20,3,27],[3,28,3,39],[1,0,1,7],[1,8,1,19],[1,20,1,27],[1,28,1,39],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[5,28,5,31],[5,32,5,35],[5,36,5,39],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[6,20,6,23],[6,24,6,27],[6,28,6,31],[5,0,5,7],[5,8,5,11],[5,12,5,15],[5,16,5,19],[5,20,5,23],[5,24,5,27],[6,32,6,35],[6,36,6,39],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[7,20,7,23],[7,24,7,27],[7,28,7,31],[7,32,7,35],[7,36,7,39],[8,0,12,7],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[12,8,12,11],[12,12,12,15],[8,32,8,35],[11,32,11,35],[11,36,11,39],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[10,32,10,35],[8,36,8,39],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[10,20,10,23],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[11,24,11,27],[11,28,11,31],[10,36,10,39],[10,24,10,27],[10,28,10,31],[12,32,12,35],[12,36,12,39],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[13,20,13,23],[13,24,13,27],[13,28,13,31],[13,32,13,35],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[13,36,13,39],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[14,36,14,39],[15,28,15,31],[15,32,15,35],[15,36,15,39],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[16,24,16,27],[16,28,16,31],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[15,24,15,27],[16,32,16,35],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[18,36,18,39],[19,28,19,31],[19,32,19,35],[19,36,19,39],[20,24,20,27],[20,28,20,31],[20,32,20,35],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[19,20,19,23],[19,24,19,27],[20,36,20,39],[21,20,21,23],[21,24,21,27],[21,28,21,31],[21,32,21,35],[21,36,21,39],[20,20,20,23],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[22,36,22,39],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[22,20,22,23],[22,24,22,27],[22,28,22,31],[22,32,22,35],[22,0,22,7],[22,8,22,11],[22,12,22,15],[22,16,22,19],[23,36,23,39],[24,0,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,32,24,35],[24,36,24,39],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,0,25,7],[25,8,25,11],[27,0,27,7],[27,8,27,11],[26,0,26,39],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[25,12,25,15],[25,16,25,19],[27,32,27,35],[27,36,27,39],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[28,28,28,31],[28,32,28,35],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[31,8,31,11],[31,12,31,15],[31,16,31,19],[30,32,30,35],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,0,30,7],[30,36,30,39],[40,41,40,43],[32,32,32,35],[32,36,32,39],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[41,41,41,43],[31,36,31,39],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[32,20,32,23],[32,24,32,27],[32,28,32,31],[31,0,31,7]]}
["DATE ISSUED",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,"INTERSECTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC1","v":0}]
["MAXPLAN (1 TO 8)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!AC2","v":0}]
["DAY OF WEEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CYCLE LENGTH [s]"]
["TIME OF DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFFSET TIME [s]"]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["PHASE SETTING",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!M7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!U7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Y7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AC7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AG7","v":"OFF"},null,null,null,{"$f":"'Signal Timing Sheet'!AK7","v":"OFF"}]
["DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":"A"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":"PED"}]
["OVERLAP",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":0}]
["MINIMUM GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U16:X16","v":"-----"}]
["PASSAGE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":"-----"},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U17:X17","v":"-----"}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U27","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U28","v":0}]
["RED [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29)","v":0},null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U29","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U30","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,"-----",null,null,null,null,null,null,null,{"$f":"'Calculation Sheet'!U31","v":0}]
["AWF TIME [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!M33,'Calculation Sheet'!O33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M7=\"OFF\",0,'Signal Timing Sheet'!M28)","v":0}]
["TOTAL SPLIT"]
["MINIMUM CYCLE LENGTH",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M18)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U18)","v":0}]
[]
["PHASE NUMBER",null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8]
["FORCE OFF (FO)"]
["START OF PERMISSIVE (SP)"]
["END OF PERMISSIVE (EP)"]
["END OF PED PERMISSIVE (EPP)"]
["MAXPLAN GREEN",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,ROUNDUP(M26,0))","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,ROUNDUP(U26,0))","v":0}]
[]
["Note:  Force Off and Permissive number corresponds to Phase number. "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORCE OFFS AND PERMISSIVES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COORDINATION SHEET 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,null,null,"Name","Value","Ring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FO 2",{"$f":"M29","v":0},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,null,null,"FO 3",null,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,null,null,"FO 4",{"$f":"U29","v":0},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,null,null,"FO 1",null,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,null,null,"FO 6",null,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,null,"FO 7",null,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,null,"FO 8",null,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,null,"FO 5",null,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,null,"EP 3",null,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,null,null,"EP 4",{"$f":"U32","v":0},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,null,null,"EP 1",null,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,null,null,"EP 7",null,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,null,"EP 8",null,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,null,"EP 5",null,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," "]

{"sheet":"Look-Up Tables","index":8,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,12,0,13],[1,12,1,13],[0,0,0,2],[1,0,1,2],[0,4,0,6],[0,8,0,10],[1,4,1,6],[1,8,1,10]]}
["POSTED SPEED",null,null,null,"THROUGH MOVEMENT",null,null,null,"TURNING MOVEMENT",null,null,null,"AWF"]
["ADJUSTMENT TABLE",null,null,null,"YELLOW-RED SPLIT TABLE",null,null,null,"YELLOW-RED SPLIT TABLE",null,null,null,"FRICTION FACTORS"]
["Posted","Approach","Clearance",null,"Clearance","Yellow","Red",null,"Clearance","Yellow","Red",null,"Posted","Friction "]
["Speed","Speed","Speed",null,"Interval",null,null,null,"Interval",null,null,null,"Speed","Factor"]
[50,40,40,null,4,3.5,0.5,null,3.5,3,0.5,null,40,0.38]
[60,45,45,null,4.0999999999999996,3.6,0.5,null,3.6,3.1,0.5,null,50,0.36]
[70,55,55,null,4.2,3.7,0.5,null,3.7,3.2,0.5,null,60,0.34]
[80,55,55,null,4.3,3.8,0.5,null,3.8,3.3,0.5,null,70,0.32]
[null,null,null,null,4.4000000000000004,3.9,0.5,null,3.9,3.4,0.5,null,80,0.31]
[null,null,null,null,4.5,4,0.5,null,4,3.5,0.5,null,90,0.3]
[null,null,null,null,4.5999999999999996,4,0.6,null,4.0999999999999996,3.5,0.6,null,100,0.3]
[null,null,null,null,4.7,4,0.7,null,4.2,3.5,0.7]
[null,null,null,null,4.8,4,0.8,null,4.3,3.5,0.8]
[null,null,null,null,4.9000000000000004,4,0.9,null,4.4000000000000004,3.5,0.9]
[null,null,null,null,5,4,1,null,4.5,3.5,1]
[null,null,null,null,5.0999999999999996,4.0999999999999996,1,null,4.5999999999999996,3.6,1]
[null,null,null,null,5.2,4.2,1,null,4.7,3.7,1]
[null,null,null,null,5.3,4.3,1,null,4.8,3.8,1]
[null,null,null,null,5.4,4.4000000000000004,1,null,4.9000000000000004,3.9,1]
[null,null,null,null,5.5,4.5,1,null,5,4,1]
[null,null,null,null,5.6,4.5,1.1000000000000001,null,5.0999999999999996,4.0999999999999996,1]
[null,null,null,null,5.7,4.5,1.2,null,5.2,4.2,1]
[null,null,null,null,5.8,4.5,1.3,null,5.3,4.3,1]
[null,null,null,null,5.9,4.5,1.4,null,5.4,4.4000000000000004,1]
[null,null,null,null,6,4.5,1.5,null,5.5,4.5,1]
[null,null,null,null,6.1,4.5999999999999996,1.5,null,5.6,4.5,1.1000000000000001]
[null,null,null,null,6.2,4.7,1.5,null,5.7,4.5,1.2]
[null,null,null,null,6.3,4.8,1.5,null,5.8,4.5,1.3]
[null,null,null,null,6.4,4.9000000000000004,1.5,null,5.9,4.5,1.4]
[null,null,null,null,6.5,5,1.5,null,6,4.5,1.5]
[null,null,null,null,null,null,null,null,6.1,4.5999999999999996,1.5]
[null,null,null,null,null,null,null,null,6.2,4.7,1.5]
[null,null,null,null,null,null,null,null,6.3,4.8,1.5]
[null,null,null,null,null,null,null,null,6.4,4.9000000000000004,1.5]
[null,null,null,null,null,null,null,null,6.5,5,1.5]