{"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":69,"n_cols":37,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,20,0,27],[0,28,0,39],[1,28,1,39],[2,28,2,39],[45,16,45,19],[44,36,44,39],[44,20,44,23],[45,20,45,23],[45,24,45,27],[45,28,45,31],[45,32,45,35],[33,17,33,39],[34,17,34,39],[0,8,0,19],[1,8,1,19],[2,8,2,19],[3,8,3,19],[3,20,3,27],[2,20,2,27],[1,20,1,27],[3,28,3,39],[44,28,44,31],[44,32,44,35],[45,36,45,39],[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[26,8,26,11],[27,8,27,11],[19,12,19,13],[19,14,19,15],[27,0,27,7],[24,0,24,7],[25,0,25,7],[26,0,26,7],[15,8,15,11],[16,8,16,11],[17,8,17,11],[14,8,14,11],[21,0,21,7],[49,0,49,3],[49,4,49,7],[49,12,49,15],[49,16,49,19],[50,0,50,3],[50,4,50,7],[50,8,50,11],[44,8,44,11],[29,0,29,7],[41,8,41,15],[41,0,41,7],[38,0,38,7],[39,0,39,7],[37,0,37,7],[26,28,26,31],[28,28,28,31],[15,28,15,31],[16,28,16,31],[17,28,17,31],[18,28,18,31],[19,28,19,29],[19,30,19,31],[53,16,53,19],[40,17,40,39],[41,17,41,39],[48,0,48,39],[47,0,47,39],[40,0,40,7],[53,0,53,3],[53,4,53,7],[53,8,53,11],[53,12,53,15],[52,16,52,19],[51,16,51,19],[51,0,51,3],[51,4,51,7],[51,8,51,11],[51,12,51,15],[18,24,18,27],[19,24,19,25],[19,26,19,27],[22,24,22,27],[13,28,13,31],[22,28,22,31],[23,28,23,31],[24,28,24,31],[25,28,25,31],[52,8,52,11],[52,12,52,15],[28,24,28,27],[29,24,29,27],[49,8,49,11],[34,8,34,15],[29,12,29,15],[40,8,40,15],[26,24,26,27],[50,16,50,19],[14,28,14,31],[9,24,9,27],[10,24,10,27],[11,24,11,27],[12,24,12,27],[5,24,5,27],[6,24,6,27],[7,24,7,27],[8,24,8,27],[9,28,9,31],[10,28,10,31],[11,28,11,31],[12,28,12,31],[5,28,5,31],[6,28,6,31],[7,28,7,31],[8,28,8,31],[5,36,5,39],[6,36,6,39],[7,36,7,39],[8,36,8,39],[13,36,13,39],[22,36,22,39],[23,36,23,39],[24,36,24,39],[25,36,25,39],[14,36,14,39],[15,36,15,39],[16,36,16,39],[17,36,17,39],[18,36,18,39],[19,36,19,37],[19,38,19,39],[28,16,28,19],[23,12,23,15],[24,12,24,15],[25,12,25,15],[22,12,22,15],[38,17,38,39],[43,8,43,39],[9,36,9,39],[10,36,10,39],[11,36,11,39],[12,36,12,39],[26,36,26,39],[13,24,13,27],[14,24,14,27],[15,24,15,27],[16,24,16,27],[17,24,17,27],[17,32,17,35],[18,32,18,35],[19,32,19,33],[19,34,19,35],[23,24,23,27],[24,24,24,27],[25,24,25,27],[22,20,22,23],[23,20,23,23],[24,20,24,23],[17,20,17,23],[18,20,18,23],[19,20,19,21],[19,22,19,23],[50,12,50,15],[26,32,26,35],[27,32,27,35],[28,32,28,35],[29,32,29,35],[22,32,22,35],[23,32,23,35],[24,32,24,35],[25,32,25,35],[25,20,25,23],[29,16,29,19],[25,16,25,19],[26,12,26,15],[27,12,27,15],[28,12,28,15],[26,16,26,19],[27,16,27,19],[5,32,5,35],[6,32,6,35],[7,32,7,35],[8,32,8,35],[9,32,9,35],[10,32,10,35],[14,20,14,23],[15,20,15,23],[16,20,16,23],[9,20,9,23],[10,20,10,23],[11,20,11,23],[12,20,12,23],[5,20,5,23],[6,20,6,23],[7,20,7,23],[8,20,8,23],[13,20,13,23],[11,32,11,35],[12,32,12,35],[13,32,13,35],[14,32,14,35],[15,32,15,35],[16,32,16,35],[19,16,19,17],[19,18,19,19],[22,16,22,19],[23,16,23,19],[24,16,24,19],[12,16,12,19],[13,16,13,19],[14,16,14,19],[15,16,15,19],[16,16,16,19],[17,16,17,19],[5,16,5,19],[6,16,6,19],[7,16,7,19],[8,16,8,19],[9,16,9,19],[10,16,10,19],[11,16,11,19],[18,12,18,15],[14,12,14,15],[15,12,15,15],[17,12,17,15],[9,12,9,15],[10,12,10,15],[11,12,11,15],[12,12,12,15],[5,12,5,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[13,12,13,15],[16,12,16,15],[18,16,18,19],[18,8,18,11],[28,0,28,7],[17,0,17,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[10,8,10,11],[7,0,7,7],[23,8,23,11],[24,8,24,11],[25,8,25,11],[28,36,28,39],[29,36,29,39],[29,28,29,31],[5,0,5,7],[27,24,27,27],[23,0,23,7],[14,0,14,7],[13,8,13,11],[19,8,19,9],[19,10,19,11],[16,0,16,7],[5,8,5,11],[22,0,22,7],[22,8,22,11],[6,8,6,11],[15,0,15,7],[12,8,12,11],[7,8,7,11],[8,8,8,11],[11,8,11,11],[9,8,9,11],[6,0,6,7],[13,0,13,7],[8,0,12,7],[27,28,27,31],[31,26,31,27],[32,16,32,39],[35,17,35,39],[54,16,54,19],[55,0,55,3],[55,4,55,7],[55,8,55,11],[55,12,55,15],[55,16,55,19],[54,0,54,3],[54,4,54,7],[54,8,54,11],[54,12,54,15],[36,17,36,39],[35,8,35,15],[39,17,39,39],[44,12,44,15],[37,8,37,15],[36,8,36,15],[39,8,39,15],[27,36,27,39],[31,28,31,29],[31,30,31,31],[58,0,58,3],[58,4,58,7],[58,8,58,11],[58,12,58,15],[61,1,61,10],[61,13,61,16],[62,1,62,10],[62,13,62,16],[56,0,56,3],[56,4,56,7],[56,8,56,11],[56,12,56,15],[57,0,57,3],[57,4,57,7],[57,8,57,11],[56,16,56,19],[57,16,57,19],[43,0,45,5],[43,6,45,7],[45,8,45,11],[45,12,45,15],[38,8,38,15],[36,0,36,7],[44,24,44,27],[58,16,58,19],[49,20,49,23],[50,20,50,23],[46,0,46,7],[58,20,58,23],[57,24,57,39],[44,16,44,19],[58,24,58,39],[55,20,55,23],[53,24,53,39],[54,24,54,39],[55,24,55,39],[56,24,56,39],[53,20,53,23],[54,20,54,23],[56,20,56,23],[57,20,57,23],[57,12,57,15],[31,34,31,35],[31,36,31,37],[31,38,31,39],[37,16,37,39],[31,16,31,17],[31,18,31,19],[31,20,31,21],[30,32,30,35],[30,36,30,39],[30,20,30,23],[31,12,31,13],[31,14,31,15],[31,22,31,23],[31,32,31,33],[49,24,49,39],[50,24,50,39],[51,20,51,23],[52,20,52,23],[51,24,51,39],[52,24,52,39],[42,0,42,39],[52,0,52,3],[52,4,52,7],[0,41,3,43],[35,0,35,7],[32,0,32,7],[31,24,31,25],[26,20,26,23],[27,20,27,23],[28,20,28,23],[30,0,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,24,30,27],[30,28,30,31],[32,8,32,15],[33,0,33,7],[34,0,34,7],[33,8,33,15],[29,20,29,23],[4,0,4,39],[31,0,31,7],[31,8,31,9],[31,10,31,11],[29,8,29,11],[28,8,28,11],[64,1,64,10],[64,13,64,16],[65,1,65,10],[65,13,65,16],[67,1,67,10],[67,13,67,16],[67,25,67,38],[68,1,68,10],[68,13,68,16],[68,25,68,38]]}
["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 CABINET",null,null,null,null,null,null,null,null,null,null,null,"SHEET NUMBER & REVISION"]
["SEQUENCE",null,null,null,null,null,null,null,"4 PHASE SEQUENTIAL",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,"ON",null,null,null,"ON",null,null,null,"ON",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,"A1->",null,null,null,null,null,null,null,"B1->"]
["OVERLAP",null,null,null,null,null,null,null,"A1 ",null,null,null,"A1 & A2",null,null,null,"B1 ",null,null,null,"B1 & B2"]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,6)","v":6},null,null,null,{"$f":"IF(M$7=\"OFF\",0,10)","v":10},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,6)","v":6},null,null,null,{"$f":"IF(U$7=\"OFF\",0,7)","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,3)","v":3},null,null,null,{"$f":"IF(M$7=\"OFF\",0,3)","v":3},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,3)","v":3},null,null,null,{"$f":"IF(U$7=\"OFF\",0,3)","v":3}]
["YELLOW",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["MAX I/MAX II"]
["MAXPLAN (1,2,3,4)",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 1'!I33)","v":0},{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 2'!I33)","v":0},{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 3'!I33)","v":0},{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 4'!I33)","v":0},{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 1'!M33)","v":0},{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 2'!M33)","v":0},{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 3'!M33)","v":0},{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 4'!M33)","v":0},{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 1'!Q33)","v":0},{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 2'!Q33)","v":0},{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 3'!Q33)","v":0},{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 4'!Q33)","v":0},{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 1'!U33)","v":0},{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 2'!U33)","v":0},{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 3'!U33)","v":0},{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 4'!U33)","v":0}]
["MAXPLAN (5,6,7,8)",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 5'!I33)","v":0},{"$f":"IF(I7=\"OFF\",\" \",'Coordination Sheet 6'!I33)","v":0},null,null,{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 5'!M33)","v":0},{"$f":"IF(M7=\"OFF\",\" \",'Coordination Sheet 6'!M33)","v":0},null,null,{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 5'!Q33)","v":0},{"$f":"IF(Q7=\"OFF\",\" \",'Coordination Sheet 6'!Q33)","v":0},null,null,{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 5'!U33)","v":0},{"$f":"IF(U7=\"OFF\",\" \",'Coordination Sheet 6'!U33)","v":0}]
["WALK",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,{"$f":"IF(Q7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PEDESTRIAN CLEAR",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,{"$f":"IF(Q7=\"OFF\",0,\"-----\")","v":"-----"},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","v":0}]
["WALK",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",0,\"STEADY\")","v":"STEADY"},null,null,null,{"$f":"IF(M7=\"OFF\",0,\"STEADY\")","v":"STEADY"},null,null,null,{"$f":"IF(Q7=\"OFF\",0,\"STEADY\")","v":"STEADY"},null,null,null,{"$f":"IF(U7=\"OFF\",0,\"STEADY\")","v":"STEADY"}]
["RECALL",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",0,\"OFF\")","v":"OFF"},null,null,null,{"$f":"IF(M7=\"OFF\",0,\"EXT\")","v":"EXT"},null,null,null,{"$f":"IF(Q7=\"OFF\",0,\"OFF\")","v":"OFF"},null,null,null,{"$f":"IF(U7=\"OFF\",0,\"OFF\")","v":"OFF"}]
["MEMORY",null,null,null,null,null,null,null,{"$f":"IF(I7=\"OFF\",0,\"OFF\")","v":"OFF"},null,null,null,{"$f":"IF(M7=\"OFF\",0,\"OFF\")","v":"OFF"},null,null,null,{"$f":"IF(Q7=\"OFF\",0,\"OFF\")","v":"OFF"},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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","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},null,null,null,null,null,{"$f":"'Calculation Sheet'!U34","v":0},null,{"$f":"'Calculation Sheet'!W34","v":0}]
["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(AND(M31=0,U31=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'!AC3=0,0,'Coordination Sheet 1'!AC3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 2'!AC3=0,0,'Coordination Sheet 2'!AC3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 3'!AC3=0,0,'Coordination Sheet 3'!AC3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 4'!AC3=0,0,'Coordination Sheet 4'!AC3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 5'!AC3=0,0,'Coordination Sheet 5'!AC3)","v":0},null,null,null,{"$f":"IF('Coordination Sheet 6'!AC3=0,0,'Coordination Sheet 6'!AC3)","v":0}]
["OFFSET (1 TO 4)",null,null,null,null,null,null,null,{"$f":"IF('Coordination Sheet 1'!$AC$3=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$3=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$3=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$3=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$3=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$3=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}]
[]
[]
[]
[]
[]
[null,"DESIGNED BY",null,null,null,null,null,null,null,null,null,null,null,"DATE"]
[]
[]
[null,"REVIEWED BY",null,null,null,null,null,null,null,null,null,null,null,"DATE"]
[]
[]
[null,"RECEIVED & DISTRIBUTED BY MOT",null,null,null,null,null,null,null,null,null,null,null,"DATE",null,null,null,null,null,null,null,null,null,null,null,"ENGINEER OF RECORD"]

{"sheet":"Calculation Sheet","index":1,"n_rows":34,"n_cols":37,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,36,20,39],[19,32,19,35],[19,36,19,39],[32,12,32,13],[32,14,32,15],[31,14,31,15],[30,14,30,15],[22,12,22,13],[20,22,20,23],[19,22,19,23],[19,20,19,21],[20,20,20,21],[31,12,31,13],[29,14,29,15],[26,14,26,15],[26,20,26,21],[27,20,27,21],[23,12,23,13],[22,14,22,15],[23,14,23,15],[19,12,19,13],[20,12,20,13],[20,14,20,15],[19,14,19,15],[13,0,13,7],[14,24,14,27],[13,20,13,23],[14,20,14,23],[13,24,13,27],[17,22,17,23],[13,36,13,39],[14,36,14,39],[13,28,13,31],[14,28,14,31],[13,32,13,35],[14,32,14,35],[15,28,15,31],[16,28,16,31],[17,20,17,21],[13,16,13,19],[14,16,14,19],[18,8,18,11],[18,12,18,15],[15,8,15,11],[16,8,16,11],[17,14,17,15],[19,24,19,27],[19,28,19,31],[15,12,15,13],[16,12,16,13],[13,8,13,11],[14,8,14,11],[13,12,13,15],[14,12,14,15],[18,24,18,27],[33,38,33,39],[33,36,33,37],[33,30,33,31],[3,0,3,7],[3,8,3,19],[19,0,19,7],[19,8,19,11],[20,8,20,11],[20,0,20,7],[18,16,18,19],[15,16,15,19],[16,16,16,19],[14,0,14,7],[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],[32,32,32,35],[27,36,27,39],[0,0,0,7],[0,8,0,19],[1,0,1,7],[1,8,1,19],[2,0,2,7],[2,8,2,19],[0,28,0,39],[2,28,2,39],[3,28,3,39],[0,20,0,27],[1,20,1,27],[2,20,2,27],[3,20,3,27],[1,28,1,39],[30,36,30,39],[32,36,32,39],[27,32,27,35],[28,32,28,35],[29,32,29,35],[30,32,30,35],[29,24,29,27],[30,24,30,27],[32,24,32,27],[29,28,29,31],[30,28,30,31],[32,28,32,31],[28,24,28,27],[31,24,31,27],[10,32,10,35],[10,36,10,39],[10,20,10,23],[30,16,30,19],[19,16,19,19],[20,16,20,19],[11,20,11,23],[18,20,18,23],[27,16,27,19],[28,16,28,19],[29,16,29,19],[11,24,11,27],[11,28,11,31],[11,32,11,35],[11,36,11,39],[15,22,15,23],[15,20,15,21],[24,16,24,19],[27,24,27,27],[12,24,12,27],[12,28,12,31],[12,32,12,35],[28,36,28,39],[29,36,29,39],[12,36,12,39],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[7,0,7,7],[7,8,7,11],[7,12,7,15],[7,16,7,19],[10,8,10,11],[10,12,10,15],[10,16,10,19],[11,8,11,11],[11,12,11,15],[11,16,11,19],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,32,8,35],[8,8,8,11],[8,12,8,15],[8,16,8,19],[10,24,10,27],[10,28,10,31],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,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],[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],[15,36,15,39],[16,36,16,39],[17,36,17,39],[18,36,18,39],[15,32,15,35],[24,24,24,27],[22,16,22,19],[23,16,23,19],[18,0,18,7],[17,16,17,19],[15,24,15,27],[16,24,16,27],[17,24,17,27],[16,20,16,21],[15,0,15,7],[16,0,16,7],[17,0,17,7],[16,22,16,23],[16,32,16,35],[17,32,17,35],[17,28,17,31],[18,28,18,31],[17,8,17,11],[20,24,20,27],[24,32,24,35],[26,32,26,35],[27,28,27,31],[28,28,28,31],[24,28,24,31],[26,24,26,27],[16,14,16,15],[15,14,15,15],[17,12,17,13],[22,20,22,21],[23,20,23,21],[23,22,23,23],[22,22,22,23],[20,28,20,31],[20,32,20,35],[18,32,18,35],[27,22,27,23],[26,22,26,23],[28,22,28,23],[28,20,28,21],[23,28,23,31],[24,12,24,15],[24,20,24,23],[29,0,29,7],[30,0,30,7],[26,12,26,13],[27,12,27,13],[28,12,28,13],[28,14,28,15],[27,14,27,15],[26,0,26,7],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,12,29,13],[30,12,30,13],[29,8,29,11],[30,8,30,11],[30,22,30,23],[29,22,29,23],[29,20,29,21],[30,20,30,21],[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],[26,16,26,19],[31,36,31,39],[27,0,27,7],[28,0,28,7],[22,8,22,11],[23,8,23,11],[24,8,24,11],[22,0,22,7],[23,0,23,7],[24,0,24,7],[31,16,31,19],[22,36,22,39],[23,36,23,39],[24,36,24,39],[26,28,26,31],[22,32,22,35],[23,32,23,35],[33,0,33,7],[33,8,33,11],[33,16,33,19],[33,24,33,27],[33,32,33,35],[31,32,31,35],[31,28,31,31],[31,0,31,7],[31,8,31,11],[32,0,32,7],[33,28,33,29],[33,22,33,23],[33,20,33,21],[33,12,33,13],[33,14,33,15],[32,8,32,11],[32,16,32,19],[32,20,32,21],[32,22,32,23],[31,22,31,23],[31,20,31,21]]}
["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 CABINET"},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":"4 PHASE SEQUENTIAL"},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":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["POSTED SPEED [km/h]"]
["APPROACH GRADE [+/- %]"]
["CLEARANCE DISTANCE [m]"]
["CONFLICT DISTANCE [m]"]
["WALKING SPEED [m/s]"]
["WALKING DISTANCE [m]"]
[]
["APPROACH SPEED [km/h]",null,null,null,null,null,null,null,{"$f":"IF(OR(I$7=\"OFF\",I$16=0),0,VLOOKUP(I$16,'Look-Up Tables'!$A$5:$C$8,2,FALSE))","v":0},null,null,null,{"$f":"IF(OR(M$7=\"OFF\",M$16=0),0,M$16)","v":0},null,{"$f":"IF(OR(O$7=\"OFF\",O$16=0),0,O$16)","v":0},null,{"$f":"IF(OR(Q$7=\"OFF\",Q$16=0),0,VLOOKUP(Q$16,'Look-Up Tables'!$A$5:$C$8,2,FALSE))","v":0},null,null,null,{"$f":"IF(OR(U$7=\"OFF\",U$16=0),0,U$16)","v":0},null,{"$f":"IF(OR(W$7=\"OFF\",W$16=0),0,W$16)","v":0}]
["CLEARANCE SPEED [km/h]",null,null,null,null,null,null,null,{"$f":"IF(OR(I$7=\"OFF\",I$16=0),0,VLOOKUP(I$16,'Look-Up Tables'!$A$5:$C$8,3,FALSE))","v":0},null,null,null,{"$f":"IF(OR(M$7=\"OFF\",M$16=0),0,M$16)","v":0},null,{"$f":"IF(OR(O$7=\"OFF\",O$16=0),0,O$16)","v":0},null,{"$f":"IF(OR(Q$7=\"OFF\",Q$16=0),0,VLOOKUP(Q$16,'Look-Up Tables'!$A$5:$C$8,3,FALSE))","v":0},null,null,null,{"$f":"IF(OR(U$7=\"OFF\",U$16=0),0,U$16)","v":0},null,{"$f":"IF(OR(W$7=\"OFF\",W$16=0),0,W$16)","v":0}]
["CONFLICT SPEED [km/h]",null,null,null,null,null,null,null,{"$f":"IF(OR(I$7=\"OFF\",I$16=0),0,I$16-10)","v":0},null,null,null,null,null,null,null,{"$f":"IF(OR(Q$7=\"OFF\",Q$16=0),0,Q$16-10)","v":0}]
[]
["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":[[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,19],[13,36,13,39],[14,20,14,23],[14,24,14,27],[14,28,14,31],[14,32,14,35],[14,36,14,39],[13,20,13,23],[13,32,13,35],[7,0,7,7],[7,8,7,11],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[12,16,12,19],[14,0,14,7],[14,8,14,11],[14,12,14,15],[27,36,27,39],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[26,0,26,39],[22,24,22,27],[23,8,23,11],[23,12,23,15],[22,0,22,7],[25,36,25,39],[24,36,24,39],[23,32,23,35],[23,36,23,39],[24,16,24,19],[24,20,24,23],[20,36,20,39],[19,16,19,19],[18,16,18,19],[18,20,18,23],[18,32,18,35],[18,36,18,39],[21,32,21,35],[21,36,21,39],[22,28,22,31],[22,32,22,35],[22,36,22,39],[21,28,21,31],[19,20,19,23],[21,16,21,19],[21,20,21,23],[21,24,21,27],[20,24,20,27],[19,24,19,27],[19,32,19,35],[19,36,19,39],[22,20,22,23],[17,0,17,7],[18,0,18,7],[19,0,19,7],[20,0,20,7],[21,0,21,7],[17,16,17,19],[17,20,17,23],[17,32,17,35],[17,24,17,27],[17,28,17,31],[18,24,18,27],[17,8,17,11],[17,12,17,15],[19,8,19,11],[19,12,19,15],[19,28,19,31],[20,8,20,11],[20,12,20,15],[20,16,20,19],[20,20,20,23],[20,28,20,31],[20,32,20,35],[16,0,16,7],[15,16,15,19],[15,20,15,23],[16,8,16,11],[16,12,16,15],[16,16,16,19],[16,20,16,23],[15,8,15,11],[15,0,15,7],[15,12,15,15],[5,0,5,7],[5,8,5,11],[5,12,5,15],[2,8,2,19],[4,0,4,39],[5,32,5,35],[5,36,5,39],[5,20,5,23],[5,24,5,27],[3,8,3,19],[5,16,5,19],[7,28,7,31],[7,32,7,35],[0,0,0,7],[0,8,0,19],[0,20,0,27],[1,0,1,7],[1,8,1,19],[2,0,2,7],[3,0,3,7],[5,28,5,31],[7,12,7,15],[7,16,7,19],[7,20,7,23],[7,24,7,27],[2,20,2,27],[3,20,3,27],[1,20,1,27],[0,28,0,39],[1,28,1,39],[2,28,2,39],[3,28,3,30],[3,31,3,33],[3,34,3,36],[3,37,3,39],[7,36,7,39],[6,20,6,23],[6,24,6,27],[6,28,6,31],[6,32,6,35],[6,36,6,39],[10,8,10,11],[10,12,10,15],[10,16,10,19],[9,8,9,11],[9,12,9,15],[9,16,9,19],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,32,8,35],[8,8,8,11],[8,12,8,15],[8,16,8,19],[9,20,9,23],[10,28,10,31],[10,32,10,35],[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],[12,32,12,35],[12,36,12,39],[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,8,12,11],[12,12,12,15],[10,20,10,23],[16,32,16,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],[16,24,16,27],[18,28,18,31],[12,24,12,27],[16,28,16,31],[15,24,15,27],[13,24,13,27],[13,28,13,31],[23,16,23,19],[22,8,22,11],[22,12,22,15],[22,16,22,19],[23,28,23,31],[23,20,23,23],[23,24,23,27],[21,8,21,11],[21,12,21,15],[18,8,18,11],[18,12,18,15],[14,16,14,19],[31,0,31,7],[32,0,32,7],[23,0,23,7],[28,0,28,7],[29,0,29,7],[30,0,30,7],[24,8,24,11],[24,12,24,15],[29,8,29,11],[28,12,28,15],[25,0,25,7],[25,8,25,11],[32,8,32,11],[31,8,31,11],[32,12,32,15],[31,12,31,15],[24,24,24,27],[24,28,24,31],[24,32,24,35],[28,20,28,23],[27,0,27,7],[27,12,27,15],[27,16,27,19],[27,8,27,11],[28,8,28,11],[24,0,24,7],[25,12,25,15],[25,16,25,19],[25,20,25,23],[25,32,25,35],[25,24,25,27],[25,28,25,31],[28,24,28,27],[28,28,28,31],[28,32,28,35],[28,36,28,39],[29,36,29,39],[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],[29,20,29,23],[29,24,29,27],[28,16,28,19],[29,12,29,15],[29,16,29,19],[29,28,29,31],[29,32,29,35],[32,16,32,19],[32,20,32,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[31,36,31,39],[31,16,31,19],[41,41,41,43],[40,41,40,43],[32,24,32,27],[32,28,32,31],[32,32,32,35],[32,36,32,39],[31,20,31,23]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,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":[[6,0,6,7],[6,8,6,11],[6,12,6,15],[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],[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],[3,8,3,19],[3,0,3,7],[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],[3,28,3,30],[3,31,3,33],[3,34,3,36],[3,37,3,39],[0,20,0,27],[0,28,0,39],[1,20,1,27],[1,28,1,39],[2,20,2,27],[2,28,2,39],[3,20,3,27],[2,0,2,7],[2,8,2,19],[1,0,1,7],[1,8,1,19],[0,0,0,7],[0,8,0,19],[12,16,12,19],[8,20,8,23],[8,24,8,27],[12,20,12,23],[12,24,12,27],[6,16,6,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,32,6,35],[6,24,6,27],[6,28,6,31],[8,36,8,39],[9,24,9,27],[9,28,9,31],[9,32,9,35],[9,36,9,39],[10,16,10,19],[9,8,9,11],[9,12,9,15],[9,16,9,19],[9,20,9,23],[10,32,10,35],[10,20,10,23],[10,8,10,11],[10,12,10,15],[8,28,8,31],[8,32,8,35],[8,8,8,11],[8,12,8,15],[8,16,8,19],[17,32,17,35],[12,28,12,31],[11,24,11,27],[11,28,11,31],[11,32,11,35],[10,28,10,31],[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],[10,36,10,39],[10,24,10,27],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[12,8,12,11],[12,12,12,15],[17,36,17,39],[15,32,15,35],[15,36,15,39],[16,28,16,31],[16,32,16,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[18,36,18,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],[17,24,17,27],[17,28,17,31],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[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],[21,28,21,31],[21,32,21,35],[19,24,19,27],[19,28,19,31],[19,32,19,35],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[22,24,22,27],[22,28,22,31],[22,32,22,35],[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],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[23,20,23,23],[23,24,23,27],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,0,24,7],[24,32,24,35],[24,36,24,39],[22,36,22,39],[23,28,23,31],[23,32,23,35],[23,36,23,39],[22,20,22,23],[25,8,25,11],[25,12,25,15],[25,16,25,19],[24,8,24,11],[24,12,24,15],[24,16,24,19],[27,0,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[29,24,29,27],[25,0,25,7],[27,36,27,39],[25,36,25,39],[25,20,25,23],[25,24,25,27],[25,28,25,31],[25,32,25,35],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[26,0,26,39],[29,28,29,31],[29,32,29,35],[29,36,29,39],[28,20,28,23],[28,24,28,27],[28,28,28,31],[28,32,28,35],[30,0,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[28,36,28,39],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[29,20,29,23],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[31,0,31,7],[31,8,31,11],[31,12,31,15],[31,16,31,19],[60,16,63,23],[31,36,31,39],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,32,30,35],[31,20,31,23],[31,24,31,27],[31,28,31,31],[31,32,31,35],[30,36,30,39],[40,41,40,43],[41,41,41,43],[32,36,32,39],[32,20,32,23],[32,24,32,27],[32,28,32,31],[32,32,32,35],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,null,2]

{"sheet":"Coordination Sheet 3","index":4,"n_rows":58,"n_cols":44,"rows_kept":58,"cut":false,"hidden":false,"merged":[[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],[7,16,7,19],[3,28,3,30],[3,31,3,33],[3,34,3,36],[3,37,3,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,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,28,14,31],[6,24,6,27],[6,28,6,31],[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],[0,20,0,27],[0,28,0,39],[1,20,1,27],[1,28,1,39],[2,20,2,27],[2,28,2,39],[3,20,3,27],[2,0,2,7],[2,8,2,19],[1,0,1,7],[1,8,1,19],[0,0,0,7],[0,8,0,19],[3,8,3,19],[3,0,3,7],[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,32,6,35],[10,16,10,19],[8,32,8,35],[8,36,8,39],[9,32,9,35],[9,36,9,39],[10,36,10,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,8,8,11],[8,12,8,15],[8,16,8,19],[9,24,9,27],[9,28,9,31],[10,24,10,27],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[9,20,9,23],[10,32,10,35],[10,20,10,23],[10,8,10,11],[10,12,10,15],[11,24,11,27],[11,28,11,31],[11,32,11,35],[10,28,10,31],[9,8,9,11],[9,12,9,15],[9,16,9,19],[17,32,17,35],[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],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[13,0,13,7],[13,8,13,11],[13,12,13,15],[13,16,13,19],[17,36,17,39],[15,32,15,35],[15,36,15,39],[16,28,16,31],[16,32,16,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[18,36,18,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],[17,24,17,27],[17,28,17,31],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[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],[21,28,21,31],[21,32,21,35],[19,24,19,27],[19,28,19,31],[19,32,19,35],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[22,24,22,27],[22,28,22,31],[22,32,22,35],[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],[23,0,23,7],[23,8,23,11],[23,12,23,15],[23,16,23,19],[23,20,23,23],[23,24,23,27],[24,20,24,23],[24,24,24,27],[24,28,24,31],[24,0,24,7],[22,36,22,39],[23,28,23,31],[23,32,23,35],[23,36,23,39],[22,20,22,23],[25,8,25,11],[25,12,25,15],[25,16,25,19],[24,8,24,11],[24,12,24,15],[24,16,24,19],[25,32,25,35],[27,20,27,23],[27,24,27,27],[27,28,27,31],[27,32,27,35],[26,0,26,39],[27,36,27,39],[25,36,25,39],[24,32,24,35],[24,36,24,39],[27,0,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[29,20,29,23],[25,0,25,7],[25,20,25,23],[25,24,25,27],[25,28,25,31],[28,32,28,35],[30,0,30,7],[30,8,30,11],[30,12,30,15],[30,16,30,19],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[28,0,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[32,0,32,7],[32,8,32,11],[32,12,32,15],[32,16,32,19],[28,36,28,39],[29,36,29,39],[31,28,31,31],[31,32,31,35],[30,20,30,23],[30,24,30,27],[30,28,30,31],[30,32,30,35],[31,0,31,7],[31,8,31,11],[31,12,31,15],[31,16,31,19],[31,20,31,23],[31,24,31,27],[29,24,29,27],[29,28,29,31],[29,32,29,35],[28,20,28,23],[28,24,28,27],[28,28,28,31],[40,41,40,43],[41,41,41,43],[32,36,32,39],[30,36,30,39],[31,36,31,39],[32,20,32,23],[32,24,32,27],[32,28,32,31],[32,32,32,35]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,null,2]

{"sheet":"Coordination Sheet 4","index":5,"n_rows":63,"n_cols":44,"rows_kept":63,"cut":false,"hidden":false,"merged":[[3,37,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],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[3,8,3,19],[2,28,2,39],[3,20,3,27],[3,28,3,30],[3,31,3,33],[3,34,3,36],[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],[6,24,6,27],[6,28,6,31],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,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,32,6,35],[10,16,10,19],[8,32,8,35],[8,36,8,39],[9,32,9,35],[9,36,9,39],[10,36,10,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,8,8,11],[8,12,8,15],[8,16,8,19],[9,24,9,27],[9,28,9,31],[10,24,10,27],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[9,20,9,23],[10,32,10,35],[10,20,10,23],[10,8,10,11],[10,12,10,15],[11,24,11,27],[11,28,11,31],[11,32,11,35],[10,28,10,31],[9,8,9,11],[9,12,9,15],[9,16,9,19],[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],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[15,36,15,39],[13,32,13,35],[13,36,13,39],[14,28,14,31],[14,32,14,35],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[14,36,14,39],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[15,24,15,27],[15,28,15,31],[15,32,15,35],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[21,28,21,31],[20,32,20,35],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[18,36,18,39],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,36,20,39],[19,20,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[19,36,19,39],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[21,32,21,35],[21,36,21,39],[20,20,20,23],[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],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[20,24,20,27],[20,28,20,31],[22,8,22,11],[22,12,22,15],[22,16,22,19],[21,20,21,23],[21,24,21,27],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,12,25,15],[25,16,25,19],[23,36,23,39],[25,36,25,39],[25,32,25,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],[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],[27,24,27,27],[27,28,27,31],[25,20,25,23],[25,24,25,27],[25,28,25,31],[24,32,24,35],[24,36,24,39],[30,0,30,7],[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],[30,32,30,35],[30,24,30,27],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[28,28,28,31],[28,32,28,35],[41,41,41,43],[31,36,31,39],[31,8,31,11],[31,12,31,15],[31,16,31,19],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[30,36,30,39],[30,28,30,31],[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],[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]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,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":[[3,37,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],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[3,8,3,19],[2,28,2,39],[3,20,3,27],[3,28,3,30],[3,31,3,33],[3,34,3,36],[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],[6,24,6,27],[6,28,6,31],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,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,32,6,35],[10,16,10,19],[8,32,8,35],[8,36,8,39],[9,32,9,35],[9,36,9,39],[10,36,10,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,8,8,11],[8,12,8,15],[8,16,8,19],[9,24,9,27],[9,28,9,31],[10,24,10,27],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[9,20,9,23],[10,32,10,35],[10,20,10,23],[10,8,10,11],[10,12,10,15],[11,24,11,27],[11,28,11,31],[11,32,11,35],[10,28,10,31],[9,8,9,11],[9,12,9,15],[9,16,9,19],[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],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[15,36,15,39],[13,32,13,35],[13,36,13,39],[14,28,14,31],[14,32,14,35],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[14,36,14,39],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[15,24,15,27],[15,28,15,31],[15,32,15,35],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[21,28,21,31],[20,32,20,35],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[18,36,18,39],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,36,20,39],[19,20,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[19,36,19,39],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[21,32,21,35],[21,36,21,39],[20,20,20,23],[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],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[20,24,20,27],[20,28,20,31],[22,8,22,11],[22,12,22,15],[22,16,22,19],[21,20,21,23],[21,24,21,27],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,12,25,15],[25,16,25,19],[23,36,23,39],[25,36,25,39],[25,32,25,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],[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],[27,24,27,27],[27,28,27,31],[25,20,25,23],[25,24,25,27],[25,28,25,31],[24,32,24,35],[24,36,24,39],[30,0,30,7],[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],[30,32,30,35],[30,24,30,27],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[28,28,28,31],[28,32,28,35],[41,41,41,43],[31,36,31,39],[31,8,31,11],[31,12,31,15],[31,16,31,19],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[30,36,30,39],[30,28,30,31],[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],[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]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,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":[[3,37,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],[2,8,2,19],[3,0,3,7],[2,0,2,7],[2,20,2,27],[3,8,3,19],[2,28,2,39],[3,20,3,27],[3,28,3,30],[3,31,3,33],[3,34,3,36],[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],[6,24,6,27],[6,28,6,31],[6,0,6,7],[6,8,6,11],[6,12,6,15],[6,16,6,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,32,6,35],[10,16,10,19],[8,32,8,35],[8,36,8,39],[9,32,9,35],[9,36,9,39],[10,36,10,39],[8,20,8,23],[8,24,8,27],[8,28,8,31],[8,8,8,11],[8,12,8,15],[8,16,8,19],[9,24,9,27],[9,28,9,31],[10,24,10,27],[11,36,11,39],[11,8,11,11],[11,12,11,15],[11,16,11,19],[11,20,11,23],[9,20,9,23],[10,32,10,35],[10,20,10,23],[10,8,10,11],[10,12,10,15],[11,24,11,27],[11,28,11,31],[11,32,11,35],[10,28,10,31],[9,8,9,11],[9,12,9,15],[9,16,9,19],[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],[12,8,12,11],[12,12,12,15],[12,16,12,19],[12,20,12,23],[12,24,12,27],[12,28,12,31],[15,36,15,39],[13,32,13,35],[13,36,13,39],[14,28,14,31],[14,32,14,35],[16,0,16,7],[16,8,16,11],[16,12,16,15],[16,16,16,19],[14,36,14,39],[15,0,15,7],[15,8,15,11],[15,12,15,15],[15,16,15,19],[15,20,15,23],[14,0,14,7],[14,8,14,11],[14,12,14,15],[14,16,14,19],[14,20,14,23],[14,24,14,27],[15,24,15,27],[15,28,15,31],[15,32,15,35],[17,24,17,27],[17,28,17,31],[17,32,17,35],[17,36,17,39],[16,20,16,23],[16,24,16,27],[16,28,16,31],[16,32,16,35],[18,0,18,7],[18,8,18,11],[18,12,18,15],[18,16,18,19],[16,36,16,39],[17,0,17,7],[17,8,17,11],[17,12,17,15],[17,16,17,19],[17,20,17,23],[21,28,21,31],[20,32,20,35],[20,0,20,7],[20,8,20,11],[20,12,20,15],[20,16,20,19],[18,36,18,39],[19,0,19,7],[19,8,19,11],[19,12,19,15],[19,16,19,19],[20,36,20,39],[19,20,19,23],[19,24,19,27],[19,28,19,31],[19,32,19,35],[19,36,19,39],[18,20,18,23],[18,24,18,27],[18,28,18,31],[18,32,18,35],[21,32,21,35],[21,36,21,39],[20,20,20,23],[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],[21,0,21,7],[21,8,21,11],[21,12,21,15],[21,16,21,19],[20,24,20,27],[20,28,20,31],[22,8,22,11],[22,12,22,15],[22,16,22,19],[21,20,21,23],[21,24,21,27],[23,20,23,23],[23,24,23,27],[23,28,23,31],[23,32,23,35],[25,12,25,15],[25,16,25,19],[23,36,23,39],[25,36,25,39],[25,32,25,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],[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],[27,24,27,27],[27,28,27,31],[25,20,25,23],[25,24,25,27],[25,28,25,31],[24,32,24,35],[24,36,24,39],[30,0,30,7],[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],[30,32,30,35],[30,24,30,27],[29,0,29,7],[29,8,29,11],[29,12,29,15],[29,16,29,19],[30,8,30,11],[30,12,30,15],[30,16,30,19],[30,20,30,23],[28,28,28,31],[28,32,28,35],[41,41,41,43],[31,36,31,39],[31,8,31,11],[31,12,31,15],[31,16,31,19],[28,36,28,39],[29,20,29,23],[29,24,29,27],[29,28,29,31],[29,32,29,35],[29,36,29,39],[30,36,30,39],[30,28,30,31],[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],[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]]}
["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:L7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!M7:P7","v":"ON"},null,null,null,{"$f":"'Signal Timing Sheet'!Q7:T7","v":"ON"},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,{"$f":"'Signal Timing Sheet'!I8:L8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M8:P8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q8:T8","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U8:X8","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I9:L9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M9:P9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q9:T9","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U9:X9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I10:L10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M10:P10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q10:T10","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U10:X10","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I11:L11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M11:P11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q11:T11","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U11:X11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I12:L12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M12:P12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q12:T12","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U12:X12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I13:L13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!M13:P13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q13:T13","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!U13:X13","v":0}]
["FUNCTION",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I14","v":"A1->"},null,null,null,{"$f":"'Signal Timing Sheet'!M14","v":0},null,null,null,{"$f":"'Signal Timing Sheet'!Q14","v":"B1->"},null,null,null,{"$f":"'Signal Timing Sheet'!U14","v":0}]
["OVERLAP",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I15","v":"A1 "},null,null,null,{"$f":"'Signal Timing Sheet'!M15","v":"A1 & A2"},null,null,null,{"$f":"'Signal Timing Sheet'!Q15","v":"B1 "},null,null,null,{"$f":"'Signal Timing Sheet'!U15","v":"B1 & B2"}]
["MINIMUM GREEN",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!M16","v":10},null,null,null,{"$f":"'Signal Timing Sheet'!Q16","v":6},null,null,null,{"$f":"'Signal Timing Sheet'!U16","v":7}]
["PASSAGE",null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!I17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!M17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!Q17","v":3},null,null,null,{"$f":"'Signal Timing Sheet'!U17","v":3}]
["CLEARANCE INTERVAL [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I27)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M27,'Calculation Sheet'!O27))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U27,'Calculation Sheet'!W27))","v":0}]
["YELLOW [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I28)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M28,'Calculation Sheet'!O28))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U28,'Calculation Sheet'!W28))","v":0}]
["RED [s]",null,null,null,null,null,null,null,{"$f":"IF(I$7=\"OFF\",0,'Calculation Sheet'!I29)","v":0},null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M29,'Calculation Sheet'!O29))","v":0},null,null,null,{"$f":"IF(Q$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0},null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U29,'Calculation Sheet'!W29))","v":0}]
["PED WALK [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M30,'Calculation Sheet'!O30))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U30,'Calculation Sheet'!W30))","v":0}]
["PED CLEAR [s]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M$7=\"OFF\",0,MAX('Calculation Sheet'!M31,'Calculation Sheet'!O31))","v":0},null,null,null,null,null,null,null,{"$f":"IF(U$7=\"OFF\",0,MAX('Calculation Sheet'!U31,'Calculation Sheet'!W31))","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},null,null,null,null,null,null,null,{"$f":"MAX('Calculation Sheet'!U33,'Calculation Sheet'!W33)","v":0}]
["COORDINATED PHASES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!M28","v":0},null,null,null,null,null,null,null,{"$f":"'Signal Timing Sheet'!U28","v":0}]
["TOTAL SPLIT"]
["TOTAL SPLIT GREEN",null,null,null,null,null,null,null,{"$f":"IF(OR(I7=\"OFF\",I25=0),0,I25-I23-I18)","v":0},null,null,null,{"$f":"IF(OR(M7=\"OFF\",M25=0),0,M25-M23-M18)","v":0},null,null,null,{"$f":"IF(OR(Q7=\"OFF\",Q25=0),0,Q25-Q23-Q18)","v":0},null,null,null,{"$f":"IF(OR(U7=\"OFF\",U25=0),0,U25-U23-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,{"$f":"ROUNDUP(IF(OR(I7=\"OFF\",I25=0),0,I26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(M7=\"OFF\",M25=0),0,M26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(Q7=\"OFF\",Q25=0),0,Q26),0)","v":0},null,null,null,{"$f":"ROUNDUP(IF(OR(U7=\"OFF\",U25=0),0,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",{"$f":"Q29","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 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",{"$f":"I29","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,null,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,null,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,null,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,null,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",{"$f":"Q31","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 4",{"$f":"U31","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",{"$f":"I31","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,null,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,null,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,null,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]