{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Project Name","Local Controller Data","Volume Data","Coordination Timing - EXISTING","Coordination Timing - PROPOSED"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Project Name","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[2,0,2,3],[0,0,0,3]]}
[]
[null,"PROJECT NAME:"]

{"sheet":"Local Controller Data","index":1,"n_rows":268,"n_cols":47,"rows_kept":268,"cut":false,"hidden":false,"merged":[[69,0,70,2],[69,3,69,4],[69,6,69,7],[69,8,69,10],[70,3,70,4],[71,1,71,2],[71,3,72,6],[71,7,72,7],[71,8,72,8],[71,9,72,9],[71,10,72,10],[72,0,72,1],[73,1,73,2],[77,0,77,2],[73,3,75,6],[73,7,75,7],[73,8,75,8],[73,9,75,9],[73,10,75,10],[74,1,74,2],[75,0,75,2],[76,0,76,2],[76,3,76,10],[114,3,114,6],[114,7,114,9],[115,3,115,6],[115,7,115,9],[111,3,111,6],[111,7,111,9],[112,3,112,6],[112,7,112,9],[113,3,113,6],[113,7,113,9],[108,3,108,6],[108,7,108,9],[109,3,109,6],[109,7,109,9],[110,3,110,6],[110,7,110,9],[105,3,105,6],[105,7,105,9],[106,3,106,6],[106,7,106,9],[107,3,107,6],[107,7,107,9],[104,0,104,1],[104,3,104,9],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,96,0],[98,0,98,10],[99,0,101,10],[102,0,102,10],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[81,0,81,1],[83,0,83,1],[79,0,79,1],[80,1,80,2],[82,0,82,1],[78,0,78,2],[0,0,0,10],[1,0,1,10],[48,3,48,6],[49,3,49,6],[40,3,40,9],[41,3,41,6],[42,3,42,6],[43,3,43,6],[44,3,44,6],[50,3,50,6],[51,3,51,6],[41,7,41,9],[42,7,42,9],[47,7,47,9],[48,7,48,9],[49,7,49,9],[50,7,50,9],[43,7,43,9],[44,7,44,9],[45,7,45,9],[51,7,51,9],[45,3,45,6],[46,3,46,6],[47,3,47,6],[46,7,46,9],[64,0,64,10],[65,0,65,10],[67,0,67,2],[67,3,67,10],[68,0,68,2],[40,0,40,1],[9,9,11,9],[34,0,34,10],[30,0,32,0],[29,0,29,1],[28,0,28,1],[26,0,26,1],[35,0,37,10],[68,3,68,10],[38,0,38,10],[27,0,27,1],[7,10,8,10],[9,7,11,7],[9,8,11,8],[9,10,11,10],[7,7,8,7],[7,8,8,8],[7,9,8,9],[24,0,24,1],[25,0,25,1],[11,0,11,2],[16,1,16,2],[15,0,15,1],[7,3,8,6],[23,0,23,1],[5,8,5,10],[3,0,3,2],[4,0,4,2],[3,3,3,10],[4,3,4,10],[5,3,5,4],[6,3,6,4],[9,3,11,6],[22,0,22,1],[5,6,5,7],[7,1,7,2],[8,0,8,1],[9,1,9,2],[10,1,10,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[5,0,6,2],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[12,3,12,10]]}
[{"$f":"'Project Name'!$C$2","v":0}]
["Proposed Local Controller Data"]
[]
["INTERSECTION:",null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,"MANUAL PATTERN","SYSTEM SOURCE","SPLITS IN","TRANSITION","DWELL/ADD TIME","OFFSET REFERNECE","PED RECALL","LOCAL ZERO OVERRIDE","RE-SYNC COUNT","ECPI COORD","SYSTEM FORMAT ","OFFSET IN","MAX SELECT","FORCE OFF","USE PED TIME","PED RESERVICE","FO ADD INI GRN","MULTISYNC",null,"OPERATION","MODE (NORMAL)","MAXIMUM","CORRECTION","OFFSET MODE","FORCE MODE","MAX DWELL TIME","YIELD PERIOD","MANUAL CONTROL: DIAL","MANUAL CONTROL: SPLIT","MANUAL CONTROL: OFFSET"]
["MAINTAINING AGENCY:",null,null,null,null,null,null,null,null,null,null,null,null,"YES",null,null,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-","-","-","-"]
["START UP",null,null,"DUAL ENTRY: ",null,"-","PHASES:",null,"-",null,null,null,null,"NO",null,null,null,"AUTO","HDW","SECONDS","DWELL",0,"LEAD","NO","NO",0,"NO","STD","SECONDS","MAXINH","FIXED ","NO","NO","NO","NO",null,"0 - FREE","0 - PERMISSIVE","0 - INHIBIT","0 - DWELL","0 - BEG GREEN","0 - PLAN"]
[null,null,null,"REST IN RED: ",null,null,"RING 1","-",null,"RING 2","-",null,null,null,null,"-",null,"FREE","TBC",null,"SMOOTH",1,"LAG","YES","YES",1,"YES","TS2",null,"MAX 1","FLOAT","YES","YES","YES","YES",null,"1 - AUTO","1 - YIELD","1 - MAX I","1 - MAX DWELL","1 - END GREEN","1 - CYCLE"]
["START IN: ","-",null,"OVERLAP",null,null,null,"A","B","C","D",null,null,null,null,"NB",null,"FLASH","SYS",null,"ADD ONLY",2,"YIELD",null,null,2,null,"PTN",null,"MAX 2",null,null,null,null,null,null,"2 - MANUAL","2 - PERMISSIVE YIELD","2 - MAX II","2 - SHORT WAY",null,"2 - FLOATING"]
["TIME FOR: FLASH , ALL RED (SEC.):   ",null,"9, 6",null,null,null,null,null,null,null,null,null,null,"-",null,"SB",null,1,null,null,null,3,"YELLOW",null,null,3,null,null,null,"MAX 3 ",null,null,null,null,null,null,null,"3 - PERMISSIVE OMIT",null,"3 - ADD ONLY",null,"3 - FIXED"]
["FIRST PHASE(S):","-",null,"PHASES",null,null,null,"-","-","-","-",null,null,"YELLOW/RED FLASH",null,"EB",null,2,null,null,null,4,"RING 1",null,null,4,null,null,null,null,null,null,null,null,null,null,null,"4 - SEQUENTIAL OMIT",null,"4 - SHORT WAY 2"]
["COLOR DISPLAYED:","-",null,null,null,null,null,null,null,null,null,null,null,"ALL-RED FLASH",null,"WB",null,3,null,null,null,5,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,"5 - FULLY ACTUATED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NB LT",null,4,null,null,null,6,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,"6 - MUTUAL COORD"]
["INTERVAL OR FEATURE",null,null,"CONTROLLER MOVEMENT NO.",null,null,null,null,null,null,null,null,null,"-",null,"SB LT",null,5,null,null,null,7,null,null,null,7]
["INTERSECTION MOVEMENT (PHASE)",null,null,1,2,3,4,5,6,7,8,null,null,"GREEN",null,"EB LT",null,6,null,null,null,8,null,null,null,8]
["DIRECTION",null,null,"-","-","-","-","-","-","-","-",null,null,"YELLOW",null,"WB LT",null,7,null,null,null,9,null,null,null,9]
["MINIMUM GREEN (INITIAL) ",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,8,null,null,null,10,null,null,null,10]
["ADDED INITIAL","*(SEC./ACTUATION)",null,"-","-","-","-","-","-","-","-",null,null,null,null,null,null,9,null,null,null,11,null,null,null,11]
["MAXIMUM INITIAL",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,10,null,null,null,12,null,null,null,12]
["PASSAGE TIME (PRESET GAP)",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,11,null,null,null,13,null,null,null,13]
["TIME BEFORE REDUCTION",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,12,null,null,null,14,null,null,null,14]
["MINIMUM GAP",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,13,null,null,null,15,null,null,null,15]
["TIME TO REDUCE",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,14,null,null,null,16,null,null,null,16]
["MAXIMUM GREEN I",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,15,null,null,null,17,null,null,null,17]
["MAXIMUM GREEN II",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,16,null,null,null,18,null,null,null,18]
["YELLOW CHANGE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,17,null,null,null,19,null,null,null,19]
["ALL RED CLEARANCE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,18,null,null,null,20,null,null,null,20]
["DELAYED GREEN (LPI) #",null,"(SEC.)","-","-","-","-","-","-","-","-"]
["FLASHING YELLOW ARROW DELAY^",null,"(SEC.)","-","-","-","-","-","-","-","-"]
["WALK",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,19,null,null,null,21,null,null,null,21]
["PEDESTRIAN CLEARANCE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,20,null,null,null,22,null,null,null,22]
["RECALL","MAXIMUM","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,21,null,null,null,23,null,null,null,23]
[null,"MINIMUM","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,22,null,null,null,24,null,null,null,24]
[null,"PEDESTRIAN","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,23,null,null,null,25,null,null,null,25]
["MEMORY    ",null,"(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,24,null,null,null,26,null,null,null,26]
["*VOLUME DENSITY CONTROLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,27,null,null,null,27]
["# FOR CROSSINGS WITH PEDESTRIAN PUSHBUTTONS, LPI'S (LEADING PEDESTRIAN INTERVALS) MAY BE IMPLEMENTED (3-6 SEC.) IN ACCORDANCE WITH LPI DURATION TIME PER THE ODOT SIGNAL CALCULATIONS - CLEARANCE INTERVALS SPREADSHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,null,null,28,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,null,null,29,null,null,null,29]
[]
["^ WHEN IMPLEMENTING FYA, A MINIMUM 3 SEC. DELAY SHALL BE PROGRAMMED PER FYA PHASE. "]
[]
["ECONOLITE COORD SETTINGS",null,null,"SIEMENS COORD SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,null,null,30,null,null,null,30]
["MANUAL PATTERN","-",null,"OPERATION",null,null,null,"-",null,null,null,null,null,null,null,null,null,29,null,null,null,31,null,null,null,31]
["SYSTEM SOURCE","-",null,"MODE (NORMAL)",null,null,null,"-",null,null,null,null,null,null,null,null,null,30,null,null,null,32,null,null,null,32]
["SPLITS IN","-",null,"MAXIMUM",null,null,null,"-",null,null,null,null,null,null,null,null,null,31,null,null,null,33,null,null,null,33]
["TRANSITION","-",null,"CORRECTION",null,null,null,"-",null,null,null,null,null,null,null,null,null,32,null,null,null,34,null,null,null,34]
["DWELL/ADD TIME","-",null,"OFFSET MODE",null,null,null,"-",null,null,null,null,null,null,null,null,null,33,null,null,null,35,null,null,null,35]
["OFFSET REFERENCE","-",null,"FORCE MODE",null,null,null,"-",null,null,null,null,null,null,null,null,null,34,null,null,null,36,null,null,null,36]
["PED RECALL","-",null,"MAX DWELL TIME",null,null,null,"-",null,null,null,null,null,null,null,null,null,35,null,null,null,37,null,null,null,37]
["LOCAL ZERO OVERRIDE","-",null,"YIELD PERIOD",null,null,null,"-",null,null,null,null,null,null,null,null,null,36,null,null,null,38,null,null,null,38]
["RE-SYNC COUNT","-",null,"MANUAL CONTROL: DIAL",null,null,null,"-",null,null,null,null,null,null,null,null,null,37,null,null,null,39,null,null,null,39]
["ECPI COORD","-",null,"MANUAL CONTROL: SPLIT",null,null,null,"-",null,null,null,null,null,null,null,null,null,38,null,null,null,40,null,null,null,40]
["SYSTEM FORMAT ","-",null,"MANUAL CONTROL: OFFSET",null,null,null,"-",null,null,null,null,null,null,null,null,null,39,null,null,null,41,null,null,null,41]
["OFFSET IN","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,null,42,null,null,null,42]
["MAX SELECT","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,null,null,null,43,null,null,null,43]
["FORCE OFF","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,null,null,null,44,null,null,null,44]
["USE PED TIME","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,null,null,null,45,null,null,null,45]
["PED RESERVICE","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,null,null,null,46,null,null,null,46]
["FO ADD INI GRN","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,null,null,null,47,null,null,null,47]
["MULTISYNC","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,null,null,null,48,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,null,null,null,49,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,null,null,null,50,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,null,null,null,51,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,52,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,null,null,null,53,null,null,null,53]
[{"$f":"'Project Name'!$C$2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,null,null,null,54,null,null,null,54]
["Proposed Local Controller Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,null,null,null,55,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,null,null,null,56,null,null,null,56]
["INTERSECTION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,null,null,57,null,null,null,57]
["MAINTAINING AGENCY:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,58,null,null,null,58]
["START UP",null,null,"DUAL ENTRY: ",null,"-","PHASES:",null,"-",null,null,null,null,null,null,null,null,57,null,null,null,59,null,null,null,59]
[null,null,null,"REST IN RED: ",null,null,"RING 1","-",null,"RING 2","-",null,null,null,null,null,null,58,null,null,null,60,null,null,null,60]
["START IN: ","-",null,"OVERLAP",null,null,null,"A","B","C","D",null,null,null,null,null,null,59,null,null,null,61,null,null,null,61]
["TIME FOR FLASH / ALL RED (SEC.):   ",null,"9, 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,62,null,null,null,62]
["FIRST PHASE(S):","-",null,"PHASES",null,null,null,"-","-","-","-",null,null,null,null,null,null,61,null,null,null,63,null,null,null,63]
["COLOR DISPLAYED:","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,null,null,null,64,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,65,null,null,null,65]
["INTERVAL OR FEATURE",null,null,"CONTROLLER MOVEMENT NO.",null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,null,66,null,null,null,66]
["INTERSECTION MOVEMENT (PHASE)",null,null,1,2,3,4,5,6,7,8,null,null,null,null,null,null,65,null,null,null,67,null,null,null,67]
["DIRECTION",null,null,"-","-","-","-","-","-","-","-",null,null,null,null,null,null,66,null,null,null,68,null,null,null,68]
["MINIMUM GREEN (INITIAL) ",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,67,null,null,null,69,null,null,null,69]
["ADDED INITIAL","*(SEC./ACTUATION)",null,"-","-","-","-","-","-","-","-",null,null,null,null,null,null,68,null,null,null,70,null,null,null,70]
["MAXIMUM INITIAL",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,69,null,null,null,71,null,null,null,71]
["PASSAGE TIME (PRESET GAP)",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,70,null,null,null,72,null,null,null,72]
["TIME BEFORE REDUCTION",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,71,null,null,null,73,null,null,null,73]
["MINIMUM GAP",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,72,null,null,null,74,null,null,null,74]
["TIME TO REDUCE",null,"*(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,73,null,null,null,75,null,null,null,75]
["MAXIMUM GREEN I",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,74,null,null,null,76,null,null,null,76]
["MAXIMUM GREEN II",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,75,null,null,null,77,null,null,null,77]
["YELLOW CHANGE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,76,null,null,null,78,null,null,null,78]
["ALL RED CLEARANCE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,77,null,null,null,79,null,null,null,79]
["DELAYED GREEN (LPI) #",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,78,null,null,null,80,null,null,null,80]
["FLASHING YELLOW ARROW DELAY^",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,79,null,null,null,81,null,null,null,81]
["WALK",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,80,null,null,null,82,null,null,null,82]
["PEDESTRIAN CLEARANCE",null,"(SEC.)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,81,null,null,null,83,null,null,null,83]
["RECALL","MAXIMUM","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,82,null,null,null,84,null,null,null,84]
[null,"MINIMUM","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,83,null,null,null,85,null,null,null,85]
[null,"PEDESTRIAN","(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,84,null,null,null,86,null,null,null,86]
["MEMORY    ",null,"(ON/OFF)","-","-","-","-","-","-","-","-",null,null,null,null,null,null,85,null,null,null,87,null,null,null,87]
["*VOLUME DENSITY CONTROLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,null,null,null,88,null,null,null,88]
["# FOR CROSSINGS WITH PEDESTRIAN PUSHBUTTONS, LPI'S (LEADING PEDESTRIAN INTERVALS) MAY BE IMPLEMENTED (3-6 SEC.) IN ACCORDANCE WITH LPI DURATION TIME PER THE ODOT SIGNAL CALCULATIONS - CLEARANCE INTERVALS SPREADSHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,null,null,null,89,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,null,null,null,90,null,null,null,90]
[]
["^ WHEN IMPLEMENTING FYA, A MINIMUM 3 SEC. DELAY SHALL BE PROGRAMMED PER FYA PHASE. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,null,null,null,91,null,null,null,91]
[]
["ECONOLITE COORD SETTINGS",null,null,"SIEMENS COORD SETTINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,null,null,92,null,null,null,92]
["MANUAL PATTERN","-",null,"OPERATION",null,null,null,"-",null,null,null,null,null,null,null,null,null,91,null,null,null,93,null,null,null,93]
["SYSTEM SOURCE","-",null,"MODE (NORMAL)",null,null,null,"-",null,null,null,null,null,null,null,null,null,92,null,null,null,94,null,null,null,94]
["SPLITS IN","-",null,"MAXIMUM",null,null,null,"-",null,null,null,null,null,null,null,null,null,93,null,null,null,95,null,null,null,95]
["TRANSITION","-",null,"CORRECTION",null,null,null,"-",null,null,null,null,null,null,null,null,null,94,null,null,null,96,null,null,null,96]
["DWELL/ADD TIME","-",null,"OFFSET MODE",null,null,null,"-",null,null,null,null,null,null,null,null,null,95,null,null,null,97,null,null,null,97]
["OFFSET REFERENCE","-",null,"FORCE MODE",null,null,null,"-",null,null,null,null,null,null,null,null,null,96,null,null,null,98,null,null,null,98]
["PED RECALL","-",null,"MAX DWELL TIME",null,null,null,"-",null,null,null,null,null,null,null,null,null,97,null,null,null,99,null,null,null,99]
["LOCAL ZERO OVERRIDE","-",null,"YIELD PERIOD",null,null,null,"-",null,null,null,null,null,null,null,null,null,98,null,null,null,100,null,null,null,100]
["RE-SYNC COUNT","-",null,"MANUAL CONTROL: DIAL",null,null,null,"-",null,null,null,null,null,null,null,null,null,99,null,null,null,101,null,null,null,101]
["ECPI COORD","-",null,"MANUAL CONTROL: SPLIT",null,null,null,"-",null,null,null,null,null,null,null,null,null,100,null,null,null,102,null,null,null,102]
["SYSTEM FORMAT ","-",null,"MANUAL CONTROL: OFFSET",null,null,null,"-",null,null,null,null,null,null,null,null,null,101,null,null,null,103,null,null,null,103]
["OFFSET IN","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,null,null,null,104,null,null,null,104]
["MAX SELECT","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,null,null,null,105,null,null,null,105]
["FORCE OFF","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,null,null,null,106,null,null,null,106]
["USE PED TIME","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,null,null,null,107,null,null,null,107]
["PED RESERVICE","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,null,null,null,108,null,null,null,108]
["FO ADD INI GRN","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,null,null,null,109,null,null,null,109]
["MULTISYNC","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,null,null,null,110,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,null,null,null,111,null,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,null,null,null,112,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,null,null,null,113,null,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,null,null,null,114,null,null,null,114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,null,null,null,115,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,null,null,null,116,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,null,null,null,117,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,null,null,null,118,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,null,null,null,119,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,null,null,null,120,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,null,null,null,121,null,null,null,121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,null,null,null,122,null,null,null,122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,null,null,null,123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,null,null,null,124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,null,null,null,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,null,null,null,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,null,null,null,127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,null,null,null,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,null,null,null,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,null,null,null,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,null,null,null,131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,null,null,null,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,null,null,null,133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,null,null,null,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,null,null,null,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,null,null,null,136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,null,null,null,137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,null,null,null,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,null,null,null,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,null,null,null,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,null,null,null,141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,null,null,null,142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,null,null,null,143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,null,null,null,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,null,null,null,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,null,null,null,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,null,null,null,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,null,null,null,148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,null,null,null,149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,null,null,null,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,null,null,null,151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,null,null,null,152]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,153,null,null,null,153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154,null,null,null,154]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,null,null,null,155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156,null,null,null,156]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157,null,null,null,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158,null,null,null,158]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159,null,null,null,159]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,null,null,null,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,161,null,null,null,161]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162,null,null,null,162]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,163,null,null,null,163]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,164,null,null,null,164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165,null,null,null,165]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,166,null,null,null,166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167,null,null,null,167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,null,null,null,168]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,169,null,null,null,169]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,null,null,null,170]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,171,null,null,null,171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,172,null,null,null,172]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,173,null,null,null,173]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,174,null,null,null,174]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,null,null,null,175]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,176,null,null,null,176]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,177,null,null,null,177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,178,null,null,null,178]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,179,null,null,null,179]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,null,null,null,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,181,null,null,null,181]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,182,null,null,null,182]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,183,null,null,null,183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,184,null,null,null,184]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,null,null,null,185]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,186,null,null,null,186]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,187,null,null,null,187]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,188,null,null,null,188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,189,null,null,null,189]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,null,null,null,190]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191,null,null,null,191]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,192,null,null,null,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,193,null,null,null,193]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,194,null,null,null,194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195,null,null,null,195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,196,null,null,null,196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,197,null,null,null,197]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,198,null,null,null,198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,199,null,null,null,199]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201,null,null,null,201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,202,null,null,null,202]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,203,null,null,null,203]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,204,null,null,null,204]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205,null,null,null,205]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,206,null,null,null,206]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,207,null,null,null,207]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,null,null,null,208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,209,null,null,null,209]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,null,null,null,210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,211,null,null,null,211]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,212,null,null,null,212]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,213,null,null,null,213]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,214,null,null,null,214]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,null,null,null,215]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,216,null,null,null,216]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,217,null,null,null,217]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,218,null,null,null,218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,219,null,null,null,219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,null,null,null,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,221,null,null,null,221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,null,null,null,222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,223,null,null,null,223]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,224,null,null,null,224]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,225,null,null,null,225]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,226,null,null,null,226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,227,null,null,null,227]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,228,null,null,null,228]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229,null,null,null,229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,null,null,null,230]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,231,null,null,null,231]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,232,null,null,null,232]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,233,null,null,null,233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,234,null,null,null,234]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,235,null,null,null,235]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,236,null,null,null,236]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237,null,null,null,237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,238,null,null,null,238]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,239,null,null,null,239]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,null,null,null,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,241,null,null,null,241]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,242,null,null,null,242]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,243,null,null,null,243]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,244,null,null,null,244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,245,null,null,null,245]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,246,null,null,null,246]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,247,null,null,null,247]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,248,null,null,null,248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,249,null,null,null,249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,null,null,null,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,251,null,null,null,251]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,252,null,null,null,252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,253,null,null,null,253]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,254,null,null,null,254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,255,null,null,null,255]

{"sheet":"Volume Data","index":2,"n_rows":144,"n_cols":14,"rows_kept":144,"cut":false,"hidden":false,"merged":[[78,2,78,13],[85,0,85,13],[46,0,46,1],[137,0,137,1],[11,2,11,7],[12,1,12,5],[97,0,97,1],[106,0,106,1],[107,0,107,1],[116,0,116,1],[117,0,117,1],[76,0,76,1],[77,0,77,1],[86,0,86,1],[87,0,87,1],[96,0,96,1],[68,2,68,13],[75,0,75,13],[57,0,57,1],[66,0,66,1],[47,0,47,1],[56,0,56,1],[67,0,67,1],[0,0,0,13],[125,0,125,13],[14,0,14,8],[15,0,15,8],[1,0,1,13],[8,7,8,8],[6,0,6,8],[10,2,10,4],[9,1,9,8],[8,1,8,3],[88,2,88,13],[55,0,55,13],[58,2,58,13],[45,0,45,13],[48,2,48,13],[65,0,65,13],[128,2,128,13],[135,0,135,13],[138,2,138,13],[95,0,95,13],[98,2,98,13],[105,0,105,13],[108,2,108,13],[115,0,115,13],[118,2,118,13],[127,0,127,1],[136,0,136,1],[126,0,126,1]]}
[{"$f":"'Project Name'!$C$2","v":0}]
["Volume Data"]
["General Notes:"]
["1. Volumes are per hour"]
["2. Corresponding Plan No.'s are shown on Timing Summary"]
[]
["COUNT INFORMATION"]
[]
["Month/Year:   ",null,null,null,null,"Day of Week:"]
["Time Period(s):"]
["Total Number of Hours:"]
["Method of Obtaining Counts1:"]
["Type of Count2:"]
[]
["1 Count Board, Video, Tube Counts, etc."]
["2 Turning Movement Count (TMC), Average Daily Traffic (ADT), etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\"INTERSECTION 1\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 2\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 3\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 4\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 5\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 6\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 7\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 8\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 9\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
["\"INTERSECTION 10\""]
["PHASE",null,1,2,"2/PED",3,4,"4/PED",5,6,"6/PED",7,8,"8/PED"]
["DIRECTION",null,"-","-","-","-","-","-","-","-","-","-","-","-"]
["EX. PLAN NO.","PROP. PLAN NO.","VEHICULAR/PED PEAK HOURLY VOLUME"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["-","-","-","-","-","-","-","-","-","-","-","-","-","-"]

{"sheet":"Coordination Timing - EXISTING","index":3,"n_rows":167,"n_cols":19,"rows_kept":167,"cut":false,"hidden":false,"merged":[[134,11,135,12],[134,13,135,14],[134,15,135,16],[143,11,143,16],[144,11,145,12],[144,13,145,14],[144,15,145,16],[123,11,123,16],[124,11,125,12],[124,13,125,14],[124,15,125,16],[133,11,133,16],[104,11,105,12],[104,13,105,14],[104,15,105,16],[113,11,113,16],[114,11,115,12],[114,13,115,14],[114,15,115,16],[93,11,93,16],[94,11,95,12],[94,13,95,14],[94,15,95,16],[103,11,103,16],[74,11,75,12],[74,13,75,14],[74,15,75,16],[83,11,83,16],[84,11,85,12],[84,13,85,14],[84,15,85,16],[63,11,63,16],[64,11,65,12],[64,13,65,14],[64,15,65,16],[73,11,73,16],[54,11,55,12],[54,13,55,14],[54,15,55,16],[53,11,53,16],[0,0,0,10],[11,0,11,10],[12,1,12,2],[12,3,12,4],[12,5,12,7],[12,8,12,10],[13,1,13,2],[13,3,13,4],[13,5,13,7],[13,8,13,10],[14,1,14,2],[14,3,14,4],[14,5,14,7],[14,8,14,10],[15,1,15,2],[15,3,15,4],[15,5,15,7],[15,8,15,10],[53,9,55,9],[53,10,55,10],[55,1,55,8],[62,0,62,10],[63,9,65,9],[63,10,65,10],[65,1,65,8],[72,0,72,10],[16,1,16,2],[16,3,16,4],[16,5,16,7],[16,8,16,10],[17,1,17,2],[17,3,17,4],[17,5,17,7],[17,8,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,7],[18,8,18,10],[93,9,95,9],[93,10,95,10],[95,1,95,8],[102,0,102,10],[103,9,105,9],[103,10,105,10],[105,1,105,8],[112,0,112,10],[19,1,19,2],[19,3,19,4],[19,5,19,7],[19,8,19,10],[20,1,20,2],[20,3,20,4],[20,5,20,7],[20,8,20,10],[73,9,75,9],[73,10,75,10],[75,1,75,8],[21,1,21,2],[21,3,21,4],[21,5,21,7],[21,8,21,10],[52,0,52,10],[3,0,3,4],[3,5,3,9],[4,0,4,2],[1,0,1,10],[142,0,142,10],[143,9,145,9],[143,10,145,10],[145,1,145,8],[122,0,122,10],[123,9,125,9],[123,10,125,10],[125,1,125,8],[132,0,132,10],[133,9,135,9],[133,10,135,10],[135,1,135,8],[113,9,115,9],[113,10,115,10],[115,1,115,8],[82,0,82,10],[83,9,85,9],[83,10,85,10],[85,1,85,8],[92,0,92,10]]}
[{"$f":"'Project Name'!$C$2","v":0}]
["Signal Timing Summary - EXISTING"]
["General Notes:"]
["1.  All offsets are measured from the referenced phase",null,null,null,null,"END OF GREEN / BEGINNING OF YELLOW",null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["2.  All offsets are measured from",null,null,"φ 2","&","φ 6",null,null,null,null,null,null,null,null,null,null,null,null,"END OF GREEN / BEGINNING OF YELLOW"]
["3.  Shared schedules of the Week listed (ex. Mon-Fri)"]
["4.  Plan Name shall denote AM Plan, PM Plan, Midday, etc."]
["5.  Hours shall be listed in military time (ex. 0600-01300)"]
["6.  Plan No. or C/S/O shall be listed programmed in Controller (follow template if provided)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEGINNING OF GREEN"]
["COORDINATION TIMING PLANS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"170 STYLE"]
["DAY(S) OF WEEK","PLAN NAME",null,"HOURS",null,"PLAN NO. OR\nCYCLE/SPLIT/OFFSET",null,null,"CYCLE LENGTH (SEC)"]
["MON - FRI",1,null,"0000 - 0600",null,"1/1/1",null,null,75,null,null,null,null,null,null,null,null,null,"-"]
["MON - FRI",5,null,"0600 - 1500",null,"3/3/1",null,null,120,null,null,null,null,null,null,null,null,null,"φ 1"]
["MON - FRI",6,null,"1500 - 1830",null,"4/1/1",null,null,130,null,null,null,null,null,null,null,null,null,"φ 2"]
["MON - FRI",5,null,"1830 - 2100",null,"3/3/1",null,null,120,null,null,null,null,null,null,null,null,null,"φ 3"]
["MON - FRI",3,null,"2100 - 0000",null,"2/1/1",null,null,100,null,null,null,null,null,null,null,null,null,"φ 4"]
["SAT - SUN",1,null,"0000 - 0700",null,"1/1/1",null,null,75,null,null,null,null,null,null,null,null,null,"φ 5"]
["SAT - SUN",3,null,"0700 - 1000",null,"2/1/1",null,null,100,null,null,null,null,null,null,null,null,null,"φ 6"]
["SAT - SUN",5,null,"1000 - 2000",null,"3/3/1",null,null,120,null,null,null,null,null,null,null,null,null,"φ 7"]
["SAT - SUN",3,null,"2000 - 0000",null,"2/1/1",null,null,100,null,null,null,null,null,null,null,null,null,"φ 8"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"&"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"*Note: Calculation checks do not account for split phasing."]
["\"U.S. 20 & McCORD RD. INTERSECTION\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","WB LT","EB","NB LT","SB","EB LT","WB","SB LT","NB",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["1/1/1",14,27,12,22,14,27,12,22,14,"-",{"$f":"(IF(B57=\"-\",0,B57))+(IF(C57=\"-\",0,C57))+(IF(D57=\"-\",0,D57))+(IF(E57=\"-\",0,E57))","v":75},{"$f":"(IF(F57=\"-\",0,F57))+(IF(G57=\"-\",0,G57))+(IF(H57=\"-\",0,H57))+(IF(I57=\"-\",0,I57))","v":75},{"$f":"(IF(B57=\"-\",0,B57))+(IF(C57=\"-\",0,C57))","v":41},{"$f":"(IF(F57=\"-\",0,F57))+(IF(G57=\"-\",0,G57))","v":41},{"$f":"(IF(D57=\"-\",0,D57))+(IF(E57=\"-\",0,E57))","v":34},{"$f":"(IF(H57=\"-\",0,H57))+(IF(I57=\"-\",0,I57))","v":34}]
["2/1/1",16,40,15,29,16,40,15,29,70,"-",{"$f":"(IF(B58=\"-\",0,B58))+(IF(C58=\"-\",0,C58))+(IF(D58=\"-\",0,D58))+(IF(E58=\"-\",0,E58))","v":100},{"$f":"(IF(F58=\"-\",0,F58))+(IF(G58=\"-\",0,G58))+(IF(H58=\"-\",0,H58))+(IF(I58=\"-\",0,I58))","v":100},{"$f":"(IF(B58=\"-\",0,B58))+(IF(C58=\"-\",0,C58))","v":56},{"$f":"(IF(F58=\"-\",0,F58))+(IF(G58=\"-\",0,G58))","v":56},{"$f":"(IF(D58=\"-\",0,D58))+(IF(E58=\"-\",0,E58))","v":44},{"$f":"(IF(H58=\"-\",0,H58))+(IF(I58=\"-\",0,I58))","v":44}]
["3/3/1",23,45,16,36,16,52,12,40,108,"-",120,120,68,68,52,52]
["4/1/1",22,56,20,32,24,54,18,34,57,"-",130,130,78,78,52,52]
[null,null,null,null,null,null,null,null,null,null,"-",0,0,0,0,0,0]
[]
["\"INTERSECTION 2\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B67=\"-\",0,B67))+(IF(C67=\"-\",0,C67))+(IF(D67=\"-\",0,D67))+(IF(E67=\"-\",0,E67))","v":0},{"$f":"(IF(F67=\"-\",0,F67))+(IF(G67=\"-\",0,G67))+(IF(H67=\"-\",0,H67))+(IF(I67=\"-\",0,I67))","v":0},{"$f":"(IF(B67=\"-\",0,B67))+(IF(C67=\"-\",0,C67))","v":0},{"$f":"(IF(F67=\"-\",0,F67))+(IF(G67=\"-\",0,G67))","v":0},{"$f":"(IF(D67=\"-\",0,D67))+(IF(E67=\"-\",0,E67))","v":0},{"$f":"(IF(H67=\"-\",0,H67))+(IF(I67=\"-\",0,I67))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B68=\"-\",0,B68))+(IF(C68=\"-\",0,C68))+(IF(D68=\"-\",0,D68))+(IF(E68=\"-\",0,E68))","v":0},{"$f":"(IF(F68=\"-\",0,F68))+(IF(G68=\"-\",0,G68))+(IF(H68=\"-\",0,H68))+(IF(I68=\"-\",0,I68))","v":0},{"$f":"(IF(B68=\"-\",0,B68))+(IF(C68=\"-\",0,C68))","v":0},{"$f":"(IF(F68=\"-\",0,F68))+(IF(G68=\"-\",0,G68))","v":0},{"$f":"(IF(D68=\"-\",0,D68))+(IF(E68=\"-\",0,E68))","v":0},{"$f":"(IF(H68=\"-\",0,H68))+(IF(I68=\"-\",0,I68))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 3\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B77=\"-\",0,B77))+(IF(C77=\"-\",0,C77))+(IF(D77=\"-\",0,D77))+(IF(E77=\"-\",0,E77))","v":0},{"$f":"(IF(F77=\"-\",0,F77))+(IF(G77=\"-\",0,G77))+(IF(H77=\"-\",0,H77))+(IF(I77=\"-\",0,I77))","v":0},{"$f":"(IF(B77=\"-\",0,B77))+(IF(C77=\"-\",0,C77))","v":0},{"$f":"(IF(F77=\"-\",0,F77))+(IF(G77=\"-\",0,G77))","v":0},{"$f":"(IF(D77=\"-\",0,D77))+(IF(E77=\"-\",0,E77))","v":0},{"$f":"(IF(H77=\"-\",0,H77))+(IF(I77=\"-\",0,I77))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B78=\"-\",0,B78))+(IF(C78=\"-\",0,C78))+(IF(D78=\"-\",0,D78))+(IF(E78=\"-\",0,E78))","v":0},{"$f":"(IF(F78=\"-\",0,F78))+(IF(G78=\"-\",0,G78))+(IF(H78=\"-\",0,H78))+(IF(I78=\"-\",0,I78))","v":0},{"$f":"(IF(B78=\"-\",0,B78))+(IF(C78=\"-\",0,C78))","v":0},{"$f":"(IF(F78=\"-\",0,F78))+(IF(G78=\"-\",0,G78))","v":0},{"$f":"(IF(D78=\"-\",0,D78))+(IF(E78=\"-\",0,E78))","v":0},{"$f":"(IF(H78=\"-\",0,H78))+(IF(I78=\"-\",0,I78))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 4\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B87=\"-\",0,B87))+(IF(C87=\"-\",0,C87))+(IF(D87=\"-\",0,D87))+(IF(E87=\"-\",0,E87))","v":0},{"$f":"(IF(F87=\"-\",0,F87))+(IF(G87=\"-\",0,G87))+(IF(H87=\"-\",0,H87))+(IF(I87=\"-\",0,I87))","v":0},{"$f":"(IF(B87=\"-\",0,B87))+(IF(C87=\"-\",0,C87))","v":0},{"$f":"(IF(F87=\"-\",0,F87))+(IF(G87=\"-\",0,G87))","v":0},{"$f":"(IF(D87=\"-\",0,D87))+(IF(E87=\"-\",0,E87))","v":0},{"$f":"(IF(H87=\"-\",0,H87))+(IF(I87=\"-\",0,I87))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B88=\"-\",0,B88))+(IF(C88=\"-\",0,C88))+(IF(D88=\"-\",0,D88))+(IF(E88=\"-\",0,E88))","v":0},{"$f":"(IF(F88=\"-\",0,F88))+(IF(G88=\"-\",0,G88))+(IF(H88=\"-\",0,H88))+(IF(I88=\"-\",0,I88))","v":0},{"$f":"(IF(B88=\"-\",0,B88))+(IF(C88=\"-\",0,C88))","v":0},{"$f":"(IF(F88=\"-\",0,F88))+(IF(G88=\"-\",0,G88))","v":0},{"$f":"(IF(D88=\"-\",0,D88))+(IF(E88=\"-\",0,E88))","v":0},{"$f":"(IF(H88=\"-\",0,H88))+(IF(I88=\"-\",0,I88))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 5\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B97=\"-\",0,B97))+(IF(C97=\"-\",0,C97))+(IF(D97=\"-\",0,D97))+(IF(E97=\"-\",0,E97))","v":0},{"$f":"(IF(F97=\"-\",0,F97))+(IF(G97=\"-\",0,G97))+(IF(H97=\"-\",0,H97))+(IF(I97=\"-\",0,I97))","v":0},{"$f":"(IF(B97=\"-\",0,B97))+(IF(C97=\"-\",0,C97))","v":0},{"$f":"(IF(F97=\"-\",0,F97))+(IF(G97=\"-\",0,G97))","v":0},{"$f":"(IF(D97=\"-\",0,D97))+(IF(E97=\"-\",0,E97))","v":0},{"$f":"(IF(H97=\"-\",0,H97))+(IF(I97=\"-\",0,I97))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B98=\"-\",0,B98))+(IF(C98=\"-\",0,C98))+(IF(D98=\"-\",0,D98))+(IF(E98=\"-\",0,E98))","v":0},{"$f":"(IF(F98=\"-\",0,F98))+(IF(G98=\"-\",0,G98))+(IF(H98=\"-\",0,H98))+(IF(I98=\"-\",0,I98))","v":0},{"$f":"(IF(B98=\"-\",0,B98))+(IF(C98=\"-\",0,C98))","v":0},{"$f":"(IF(F98=\"-\",0,F98))+(IF(G98=\"-\",0,G98))","v":0},{"$f":"(IF(D98=\"-\",0,D98))+(IF(E98=\"-\",0,E98))","v":0},{"$f":"(IF(H98=\"-\",0,H98))+(IF(I98=\"-\",0,I98))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 6\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B107=\"-\",0,B107))+(IF(C107=\"-\",0,C107))+(IF(D107=\"-\",0,D107))+(IF(E107=\"-\",0,E107))","v":0},{"$f":"(IF(F107=\"-\",0,F107))+(IF(G107=\"-\",0,G107))+(IF(H107=\"-\",0,H107))+(IF(I107=\"-\",0,I107))","v":0},{"$f":"(IF(B107=\"-\",0,B107))+(IF(C107=\"-\",0,C107))","v":0},{"$f":"(IF(F107=\"-\",0,F107))+(IF(G107=\"-\",0,G107))","v":0},{"$f":"(IF(D107=\"-\",0,D107))+(IF(E107=\"-\",0,E107))","v":0},{"$f":"(IF(H107=\"-\",0,H107))+(IF(I107=\"-\",0,I107))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B108=\"-\",0,B108))+(IF(C108=\"-\",0,C108))+(IF(D108=\"-\",0,D108))+(IF(E108=\"-\",0,E108))","v":0},{"$f":"(IF(F108=\"-\",0,F108))+(IF(G108=\"-\",0,G108))+(IF(H108=\"-\",0,H108))+(IF(I108=\"-\",0,I108))","v":0},{"$f":"(IF(B108=\"-\",0,B108))+(IF(C108=\"-\",0,C108))","v":0},{"$f":"(IF(F108=\"-\",0,F108))+(IF(G108=\"-\",0,G108))","v":0},{"$f":"(IF(D108=\"-\",0,D108))+(IF(E108=\"-\",0,E108))","v":0},{"$f":"(IF(H108=\"-\",0,H108))+(IF(I108=\"-\",0,I108))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 7\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B117=\"-\",0,B117))+(IF(C117=\"-\",0,C117))+(IF(D117=\"-\",0,D117))+(IF(E117=\"-\",0,E117))","v":0},{"$f":"(IF(F117=\"-\",0,F117))+(IF(G117=\"-\",0,G117))+(IF(H117=\"-\",0,H117))+(IF(I117=\"-\",0,I117))","v":0},{"$f":"(IF(B117=\"-\",0,B117))+(IF(C117=\"-\",0,C117))","v":0},{"$f":"(IF(F117=\"-\",0,F117))+(IF(G117=\"-\",0,G117))","v":0},{"$f":"(IF(D117=\"-\",0,D117))+(IF(E117=\"-\",0,E117))","v":0},{"$f":"(IF(H117=\"-\",0,H117))+(IF(I117=\"-\",0,I117))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B118=\"-\",0,B118))+(IF(C118=\"-\",0,C118))+(IF(D118=\"-\",0,D118))+(IF(E118=\"-\",0,E118))","v":0},{"$f":"(IF(F118=\"-\",0,F118))+(IF(G118=\"-\",0,G118))+(IF(H118=\"-\",0,H118))+(IF(I118=\"-\",0,I118))","v":0},{"$f":"(IF(B118=\"-\",0,B118))+(IF(C118=\"-\",0,C118))","v":0},{"$f":"(IF(F118=\"-\",0,F118))+(IF(G118=\"-\",0,G118))","v":0},{"$f":"(IF(D118=\"-\",0,D118))+(IF(E118=\"-\",0,E118))","v":0},{"$f":"(IF(H118=\"-\",0,H118))+(IF(I118=\"-\",0,I118))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 8\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B127=\"-\",0,B127))+(IF(C127=\"-\",0,C127))+(IF(D127=\"-\",0,D127))+(IF(E127=\"-\",0,E127))","v":0},{"$f":"(IF(F127=\"-\",0,F127))+(IF(G127=\"-\",0,G127))+(IF(H127=\"-\",0,H127))+(IF(I127=\"-\",0,I127))","v":0},{"$f":"(IF(B127=\"-\",0,B127))+(IF(C127=\"-\",0,C127))","v":0},{"$f":"(IF(F127=\"-\",0,F127))+(IF(G127=\"-\",0,G127))","v":0},{"$f":"(IF(D127=\"-\",0,D127))+(IF(E127=\"-\",0,E127))","v":0},{"$f":"(IF(H127=\"-\",0,H127))+(IF(I127=\"-\",0,I127))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B128=\"-\",0,B128))+(IF(C128=\"-\",0,C128))+(IF(D128=\"-\",0,D128))+(IF(E128=\"-\",0,E128))","v":0},{"$f":"(IF(F128=\"-\",0,F128))+(IF(G128=\"-\",0,G128))+(IF(H128=\"-\",0,H128))+(IF(I128=\"-\",0,I128))","v":0},{"$f":"(IF(B128=\"-\",0,B128))+(IF(C128=\"-\",0,C128))","v":0},{"$f":"(IF(F128=\"-\",0,F128))+(IF(G128=\"-\",0,G128))","v":0},{"$f":"(IF(D128=\"-\",0,D128))+(IF(E128=\"-\",0,E128))","v":0},{"$f":"(IF(H128=\"-\",0,H128))+(IF(I128=\"-\",0,I128))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 9\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B137=\"-\",0,B137))+(IF(C137=\"-\",0,C137))+(IF(D137=\"-\",0,D137))+(IF(E137=\"-\",0,E137))","v":0},{"$f":"(IF(F137=\"-\",0,F137))+(IF(G137=\"-\",0,G137))+(IF(H137=\"-\",0,H137))+(IF(I137=\"-\",0,I137))","v":0},{"$f":"(IF(B137=\"-\",0,B137))+(IF(C137=\"-\",0,C137))","v":0},{"$f":"(IF(F137=\"-\",0,F137))+(IF(G137=\"-\",0,G137))","v":0},{"$f":"(IF(D137=\"-\",0,D137))+(IF(E137=\"-\",0,E137))","v":0},{"$f":"(IF(H137=\"-\",0,H137))+(IF(I137=\"-\",0,I137))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B138=\"-\",0,B138))+(IF(C138=\"-\",0,C138))+(IF(D138=\"-\",0,D138))+(IF(E138=\"-\",0,E138))","v":0},{"$f":"(IF(F138=\"-\",0,F138))+(IF(G138=\"-\",0,G138))+(IF(H138=\"-\",0,H138))+(IF(I138=\"-\",0,I138))","v":0},{"$f":"(IF(B138=\"-\",0,B138))+(IF(C138=\"-\",0,C138))","v":0},{"$f":"(IF(F138=\"-\",0,F138))+(IF(G138=\"-\",0,G138))","v":0},{"$f":"(IF(D138=\"-\",0,D138))+(IF(E138=\"-\",0,E138))","v":0},{"$f":"(IF(H138=\"-\",0,H138))+(IF(I138=\"-\",0,I138))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 10\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B147=\"-\",0,B147))+(IF(C147=\"-\",0,C147))+(IF(D147=\"-\",0,D147))+(IF(E147=\"-\",0,E147))","v":0},{"$f":"(IF(F147=\"-\",0,F147))+(IF(G147=\"-\",0,G147))+(IF(H147=\"-\",0,H147))+(IF(I147=\"-\",0,I147))","v":0},{"$f":"(IF(B147=\"-\",0,B147))+(IF(C147=\"-\",0,C147))","v":0},{"$f":"(IF(F147=\"-\",0,F147))+(IF(G147=\"-\",0,G147))","v":0},{"$f":"(IF(D147=\"-\",0,D147))+(IF(E147=\"-\",0,E147))","v":0},{"$f":"(IF(H147=\"-\",0,H147))+(IF(I147=\"-\",0,I147))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B148=\"-\",0,B148))+(IF(C148=\"-\",0,C148))+(IF(D148=\"-\",0,D148))+(IF(E148=\"-\",0,E148))","v":0},{"$f":"(IF(F148=\"-\",0,F148))+(IF(G148=\"-\",0,G148))+(IF(H148=\"-\",0,H148))+(IF(I148=\"-\",0,I148))","v":0},{"$f":"(IF(B148=\"-\",0,B148))+(IF(C148=\"-\",0,C148))","v":0},{"$f":"(IF(F148=\"-\",0,F148))+(IF(G148=\"-\",0,G148))","v":0},{"$f":"(IF(D148=\"-\",0,D148))+(IF(E148=\"-\",0,E148))","v":0},{"$f":"(IF(H148=\"-\",0,H148))+(IF(I148=\"-\",0,I148))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,"0000 - 0700"]
[null,null,null,null,"0700 - 1000"]
[null,null,null,null,"1000 - 2000"]
[null,null,null,null,"2000 - 0000"]
[]
[]
[]
[]
[null,null,null,null,"0600 - 1500"]
[null,null,null,null,"1500 - 1830"]
[null,null,null,null,"1830 - 2100"]
[null,null,null,null,"2100 - 0000"]

{"sheet":"Coordination Timing - PROPOSED","index":4,"n_rows":151,"n_cols":19,"rows_kept":151,"cut":false,"hidden":false,"merged":[[142,0,142,10],[143,9,145,9],[143,10,145,10],[143,11,143,16],[144,11,145,12],[144,13,145,14],[144,15,145,16],[145,1,145,8],[132,0,132,10],[133,9,135,9],[133,10,135,10],[133,11,133,16],[134,11,135,12],[134,13,135,14],[134,15,135,16],[135,1,135,8],[122,0,122,10],[123,9,125,9],[123,10,125,10],[123,11,123,16],[124,11,125,12],[124,13,125,14],[124,15,125,16],[125,1,125,8],[112,0,112,10],[113,9,115,9],[113,10,115,10],[113,11,113,16],[114,11,115,12],[114,13,115,14],[114,15,115,16],[115,1,115,8],[102,0,102,10],[103,9,105,9],[103,10,105,10],[103,11,103,16],[104,11,105,12],[104,13,105,14],[104,15,105,16],[105,1,105,8],[92,0,92,10],[93,9,95,9],[93,10,95,10],[93,11,93,16],[94,11,95,12],[94,13,95,14],[94,15,95,16],[95,1,95,8],[82,0,82,10],[83,9,85,9],[83,10,85,10],[83,11,83,16],[84,11,85,12],[84,13,85,14],[84,15,85,16],[85,1,85,8],[72,0,72,10],[73,9,75,9],[73,10,75,10],[73,11,73,16],[74,11,75,12],[74,13,75,14],[74,15,75,16],[75,1,75,8],[62,0,62,10],[63,9,65,9],[63,10,65,10],[63,11,63,16],[64,11,65,12],[64,13,65,14],[64,15,65,16],[65,1,65,8],[52,0,52,10],[53,9,55,9],[53,10,55,10],[53,11,53,16],[54,11,55,12],[54,13,55,14],[54,15,55,16],[55,1,55,8],[20,1,20,2],[20,3,20,4],[20,5,20,7],[20,8,20,10],[21,1,21,2],[21,3,21,4],[21,5,21,7],[21,8,21,10],[18,1,18,2],[18,3,18,4],[18,5,18,7],[18,8,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,7],[19,8,19,10],[16,1,16,2],[16,3,16,4],[16,5,16,7],[16,8,16,10],[17,1,17,2],[17,3,17,4],[17,5,17,7],[17,8,17,10],[14,1,14,2],[14,3,14,4],[14,5,14,7],[14,8,14,10],[15,1,15,2],[15,3,15,4],[15,5,15,7],[15,8,15,10],[12,1,12,2],[12,3,12,4],[12,5,12,7],[12,8,12,10],[13,1,13,2],[13,3,13,4],[13,5,13,7],[13,8,13,10],[0,0,0,10],[1,0,1,10],[3,0,3,4],[3,5,3,9],[4,0,4,2],[11,0,11,10]]}
[{"$f":"'Project Name'!$C$2","v":0}]
["Signal Timing Summary - PROPOSED"]
["General Notes:"]
["1.  All offsets are measured from the referenced phase",null,null,null,null,"END OF GREEN / BEGINNING OF YELLOW",null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["2.  All offsets are measured from",null,null,"φ 2","&","φ 6",null,null,null,null,null,null,null,null,null,null,null,null,"END OF GREEN / BEGINNING OF YELLOW"]
["3.  Shared schedules of the Week listed (ex. Mon-Fri)"]
["4.  Plan Name shall denote AM Plan, PM Plan, Midday, etc."]
["5.  Hours shall be listed in military time (ex. 0600-01300)"]
["6.  Plan No. or C/S/O shall be listed programmed in Controller (follow template if provided)"]
["7.  Plans should be provided for each weekday for the following time periods: AM, Midday, PM, and Off-peak. "]
["     If authorized, additional plans shall be developed for Weekend Peak/Off-Peaks or High Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEGINNING OF GREEN"]
["COORDINATION TIMING PLANS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"170 STYLE"]
["DAY(S) OF WEEK","PLAN NAME",null,"HOURS",null,"PLAN NO. OR\nCYCLE/SPLIT/OFFSET",null,null,"CYCLE LENGTH (SEC)"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"-"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 1"]
["-","-",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,"φ 3"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 4"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 5"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 6"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 7"]
["-","-",null,"-",null,"-",null,null,"-",null,null,null,null,null,null,null,null,null,"φ 8"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"&"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"*Note: Calculation checks do not account for split phasing."]
["\"INTERSECTION 1\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B57=\"-\",0,B57))+(IF(C57=\"-\",0,C57))+(IF(D57=\"-\",0,D57))+(IF(E57=\"-\",0,E57))","v":0},{"$f":"(IF(F57=\"-\",0,F57))+(IF(G57=\"-\",0,G57))+(IF(H57=\"-\",0,H57))+(IF(I57=\"-\",0,I57))","v":0},{"$f":"(IF(B57=\"-\",0,B57))+(IF(C57=\"-\",0,C57))","v":0},{"$f":"(IF(F57=\"-\",0,F57))+(IF(G57=\"-\",0,G57))","v":0},{"$f":"(IF(D57=\"-\",0,D57))+(IF(E57=\"-\",0,E57))","v":0},{"$f":"(IF(H57=\"-\",0,H57))+(IF(I57=\"-\",0,I57))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B58=\"-\",0,B58))+(IF(C58=\"-\",0,C58))+(IF(D58=\"-\",0,D58))+(IF(E58=\"-\",0,E58))","v":0},{"$f":"(IF(F58=\"-\",0,F58))+(IF(G58=\"-\",0,G58))+(IF(H58=\"-\",0,H58))+(IF(I58=\"-\",0,I58))","v":0},{"$f":"(IF(B58=\"-\",0,B58))+(IF(C58=\"-\",0,C58))","v":0},{"$f":"(IF(F58=\"-\",0,F58))+(IF(G58=\"-\",0,G58))","v":0},{"$f":"(IF(D58=\"-\",0,D58))+(IF(E58=\"-\",0,E58))","v":0},{"$f":"(IF(H58=\"-\",0,H58))+(IF(I58=\"-\",0,I58))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 2\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B67=\"-\",0,B67))+(IF(C67=\"-\",0,C67))+(IF(D67=\"-\",0,D67))+(IF(E67=\"-\",0,E67))","v":0},{"$f":"(IF(F67=\"-\",0,F67))+(IF(G67=\"-\",0,G67))+(IF(H67=\"-\",0,H67))+(IF(I67=\"-\",0,I67))","v":0},{"$f":"(IF(B67=\"-\",0,B67))+(IF(C67=\"-\",0,C67))","v":0},{"$f":"(IF(F67=\"-\",0,F67))+(IF(G67=\"-\",0,G67))","v":0},{"$f":"(IF(D67=\"-\",0,D67))+(IF(E67=\"-\",0,E67))","v":0},{"$f":"(IF(H67=\"-\",0,H67))+(IF(I67=\"-\",0,I67))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B68=\"-\",0,B68))+(IF(C68=\"-\",0,C68))+(IF(D68=\"-\",0,D68))+(IF(E68=\"-\",0,E68))","v":0},{"$f":"(IF(F68=\"-\",0,F68))+(IF(G68=\"-\",0,G68))+(IF(H68=\"-\",0,H68))+(IF(I68=\"-\",0,I68))","v":0},{"$f":"(IF(B68=\"-\",0,B68))+(IF(C68=\"-\",0,C68))","v":0},{"$f":"(IF(F68=\"-\",0,F68))+(IF(G68=\"-\",0,G68))","v":0},{"$f":"(IF(D68=\"-\",0,D68))+(IF(E68=\"-\",0,E68))","v":0},{"$f":"(IF(H68=\"-\",0,H68))+(IF(I68=\"-\",0,I68))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 3\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B77=\"-\",0,B77))+(IF(C77=\"-\",0,C77))+(IF(D77=\"-\",0,D77))+(IF(E77=\"-\",0,E77))","v":0},{"$f":"(IF(F77=\"-\",0,F77))+(IF(G77=\"-\",0,G77))+(IF(H77=\"-\",0,H77))+(IF(I77=\"-\",0,I77))","v":0},{"$f":"(IF(B77=\"-\",0,B77))+(IF(C77=\"-\",0,C77))","v":0},{"$f":"(IF(F77=\"-\",0,F77))+(IF(G77=\"-\",0,G77))","v":0},{"$f":"(IF(D77=\"-\",0,D77))+(IF(E77=\"-\",0,E77))","v":0},{"$f":"(IF(H77=\"-\",0,H77))+(IF(I77=\"-\",0,I77))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B78=\"-\",0,B78))+(IF(C78=\"-\",0,C78))+(IF(D78=\"-\",0,D78))+(IF(E78=\"-\",0,E78))","v":0},{"$f":"(IF(F78=\"-\",0,F78))+(IF(G78=\"-\",0,G78))+(IF(H78=\"-\",0,H78))+(IF(I78=\"-\",0,I78))","v":0},{"$f":"(IF(B78=\"-\",0,B78))+(IF(C78=\"-\",0,C78))","v":0},{"$f":"(IF(F78=\"-\",0,F78))+(IF(G78=\"-\",0,G78))","v":0},{"$f":"(IF(D78=\"-\",0,D78))+(IF(E78=\"-\",0,E78))","v":0},{"$f":"(IF(H78=\"-\",0,H78))+(IF(I78=\"-\",0,I78))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 4\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B87=\"-\",0,B87))+(IF(C87=\"-\",0,C87))+(IF(D87=\"-\",0,D87))+(IF(E87=\"-\",0,E87))","v":0},{"$f":"(IF(F87=\"-\",0,F87))+(IF(G87=\"-\",0,G87))+(IF(H87=\"-\",0,H87))+(IF(I87=\"-\",0,I87))","v":0},{"$f":"(IF(B87=\"-\",0,B87))+(IF(C87=\"-\",0,C87))","v":0},{"$f":"(IF(F87=\"-\",0,F87))+(IF(G87=\"-\",0,G87))","v":0},{"$f":"(IF(D87=\"-\",0,D87))+(IF(E87=\"-\",0,E87))","v":0},{"$f":"(IF(H87=\"-\",0,H87))+(IF(I87=\"-\",0,I87))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B88=\"-\",0,B88))+(IF(C88=\"-\",0,C88))+(IF(D88=\"-\",0,D88))+(IF(E88=\"-\",0,E88))","v":0},{"$f":"(IF(F88=\"-\",0,F88))+(IF(G88=\"-\",0,G88))+(IF(H88=\"-\",0,H88))+(IF(I88=\"-\",0,I88))","v":0},{"$f":"(IF(B88=\"-\",0,B88))+(IF(C88=\"-\",0,C88))","v":0},{"$f":"(IF(F88=\"-\",0,F88))+(IF(G88=\"-\",0,G88))","v":0},{"$f":"(IF(D88=\"-\",0,D88))+(IF(E88=\"-\",0,E88))","v":0},{"$f":"(IF(H88=\"-\",0,H88))+(IF(I88=\"-\",0,I88))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 5\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B97=\"-\",0,B97))+(IF(C97=\"-\",0,C97))+(IF(D97=\"-\",0,D97))+(IF(E97=\"-\",0,E97))","v":0},{"$f":"(IF(F97=\"-\",0,F97))+(IF(G97=\"-\",0,G97))+(IF(H97=\"-\",0,H97))+(IF(I97=\"-\",0,I97))","v":0},{"$f":"(IF(B97=\"-\",0,B97))+(IF(C97=\"-\",0,C97))","v":0},{"$f":"(IF(F97=\"-\",0,F97))+(IF(G97=\"-\",0,G97))","v":0},{"$f":"(IF(D97=\"-\",0,D97))+(IF(E97=\"-\",0,E97))","v":0},{"$f":"(IF(H97=\"-\",0,H97))+(IF(I97=\"-\",0,I97))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B98=\"-\",0,B98))+(IF(C98=\"-\",0,C98))+(IF(D98=\"-\",0,D98))+(IF(E98=\"-\",0,E98))","v":0},{"$f":"(IF(F98=\"-\",0,F98))+(IF(G98=\"-\",0,G98))+(IF(H98=\"-\",0,H98))+(IF(I98=\"-\",0,I98))","v":0},{"$f":"(IF(B98=\"-\",0,B98))+(IF(C98=\"-\",0,C98))","v":0},{"$f":"(IF(F98=\"-\",0,F98))+(IF(G98=\"-\",0,G98))","v":0},{"$f":"(IF(D98=\"-\",0,D98))+(IF(E98=\"-\",0,E98))","v":0},{"$f":"(IF(H98=\"-\",0,H98))+(IF(I98=\"-\",0,I98))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 6\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B107=\"-\",0,B107))+(IF(C107=\"-\",0,C107))+(IF(D107=\"-\",0,D107))+(IF(E107=\"-\",0,E107))","v":0},{"$f":"(IF(F107=\"-\",0,F107))+(IF(G107=\"-\",0,G107))+(IF(H107=\"-\",0,H107))+(IF(I107=\"-\",0,I107))","v":0},{"$f":"(IF(B107=\"-\",0,B107))+(IF(C107=\"-\",0,C107))","v":0},{"$f":"(IF(F107=\"-\",0,F107))+(IF(G107=\"-\",0,G107))","v":0},{"$f":"(IF(D107=\"-\",0,D107))+(IF(E107=\"-\",0,E107))","v":0},{"$f":"(IF(H107=\"-\",0,H107))+(IF(I107=\"-\",0,I107))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B108=\"-\",0,B108))+(IF(C108=\"-\",0,C108))+(IF(D108=\"-\",0,D108))+(IF(E108=\"-\",0,E108))","v":0},{"$f":"(IF(F108=\"-\",0,F108))+(IF(G108=\"-\",0,G108))+(IF(H108=\"-\",0,H108))+(IF(I108=\"-\",0,I108))","v":0},{"$f":"(IF(B108=\"-\",0,B108))+(IF(C108=\"-\",0,C108))","v":0},{"$f":"(IF(F108=\"-\",0,F108))+(IF(G108=\"-\",0,G108))","v":0},{"$f":"(IF(D108=\"-\",0,D108))+(IF(E108=\"-\",0,E108))","v":0},{"$f":"(IF(H108=\"-\",0,H108))+(IF(I108=\"-\",0,I108))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 7\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B117=\"-\",0,B117))+(IF(C117=\"-\",0,C117))+(IF(D117=\"-\",0,D117))+(IF(E117=\"-\",0,E117))","v":0},{"$f":"(IF(F117=\"-\",0,F117))+(IF(G117=\"-\",0,G117))+(IF(H117=\"-\",0,H117))+(IF(I117=\"-\",0,I117))","v":0},{"$f":"(IF(B117=\"-\",0,B117))+(IF(C117=\"-\",0,C117))","v":0},{"$f":"(IF(F117=\"-\",0,F117))+(IF(G117=\"-\",0,G117))","v":0},{"$f":"(IF(D117=\"-\",0,D117))+(IF(E117=\"-\",0,E117))","v":0},{"$f":"(IF(H117=\"-\",0,H117))+(IF(I117=\"-\",0,I117))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B118=\"-\",0,B118))+(IF(C118=\"-\",0,C118))+(IF(D118=\"-\",0,D118))+(IF(E118=\"-\",0,E118))","v":0},{"$f":"(IF(F118=\"-\",0,F118))+(IF(G118=\"-\",0,G118))+(IF(H118=\"-\",0,H118))+(IF(I118=\"-\",0,I118))","v":0},{"$f":"(IF(B118=\"-\",0,B118))+(IF(C118=\"-\",0,C118))","v":0},{"$f":"(IF(F118=\"-\",0,F118))+(IF(G118=\"-\",0,G118))","v":0},{"$f":"(IF(D118=\"-\",0,D118))+(IF(E118=\"-\",0,E118))","v":0},{"$f":"(IF(H118=\"-\",0,H118))+(IF(I118=\"-\",0,I118))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 8\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B127=\"-\",0,B127))+(IF(C127=\"-\",0,C127))+(IF(D127=\"-\",0,D127))+(IF(E127=\"-\",0,E127))","v":0},{"$f":"(IF(F127=\"-\",0,F127))+(IF(G127=\"-\",0,G127))+(IF(H127=\"-\",0,H127))+(IF(I127=\"-\",0,I127))","v":0},{"$f":"(IF(B127=\"-\",0,B127))+(IF(C127=\"-\",0,C127))","v":0},{"$f":"(IF(F127=\"-\",0,F127))+(IF(G127=\"-\",0,G127))","v":0},{"$f":"(IF(D127=\"-\",0,D127))+(IF(E127=\"-\",0,E127))","v":0},{"$f":"(IF(H127=\"-\",0,H127))+(IF(I127=\"-\",0,I127))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B128=\"-\",0,B128))+(IF(C128=\"-\",0,C128))+(IF(D128=\"-\",0,D128))+(IF(E128=\"-\",0,E128))","v":0},{"$f":"(IF(F128=\"-\",0,F128))+(IF(G128=\"-\",0,G128))+(IF(H128=\"-\",0,H128))+(IF(I128=\"-\",0,I128))","v":0},{"$f":"(IF(B128=\"-\",0,B128))+(IF(C128=\"-\",0,C128))","v":0},{"$f":"(IF(F128=\"-\",0,F128))+(IF(G128=\"-\",0,G128))","v":0},{"$f":"(IF(D128=\"-\",0,D128))+(IF(E128=\"-\",0,E128))","v":0},{"$f":"(IF(H128=\"-\",0,H128))+(IF(I128=\"-\",0,I128))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 9\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B137=\"-\",0,B137))+(IF(C137=\"-\",0,C137))+(IF(D137=\"-\",0,D137))+(IF(E137=\"-\",0,E137))","v":0},{"$f":"(IF(F137=\"-\",0,F137))+(IF(G137=\"-\",0,G137))+(IF(H137=\"-\",0,H137))+(IF(I137=\"-\",0,I137))","v":0},{"$f":"(IF(B137=\"-\",0,B137))+(IF(C137=\"-\",0,C137))","v":0},{"$f":"(IF(F137=\"-\",0,F137))+(IF(G137=\"-\",0,G137))","v":0},{"$f":"(IF(D137=\"-\",0,D137))+(IF(E137=\"-\",0,E137))","v":0},{"$f":"(IF(H137=\"-\",0,H137))+(IF(I137=\"-\",0,I137))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B138=\"-\",0,B138))+(IF(C138=\"-\",0,C138))+(IF(D138=\"-\",0,D138))+(IF(E138=\"-\",0,E138))","v":0},{"$f":"(IF(F138=\"-\",0,F138))+(IF(G138=\"-\",0,G138))+(IF(H138=\"-\",0,H138))+(IF(I138=\"-\",0,I138))","v":0},{"$f":"(IF(B138=\"-\",0,B138))+(IF(C138=\"-\",0,C138))","v":0},{"$f":"(IF(F138=\"-\",0,F138))+(IF(G138=\"-\",0,G138))","v":0},{"$f":"(IF(D138=\"-\",0,D138))+(IF(E138=\"-\",0,E138))","v":0},{"$f":"(IF(H138=\"-\",0,H138))+(IF(I138=\"-\",0,I138))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
[]
["\"INTERSECTION 10\""]
["PHASE",1,2,3,4,5,6,7,8,"OFFSET 1 (SEC)","OFFSET 2 (SEC)","CALCULATION CHECKS"]
["DIRECTION","-","-","-","-","-","-","-","-",null,null,"1+2+3+4 = 5+6+7+8?",null,"1+2 = 5+6?",null,"3+4 = 7+8?"]
["PLAN NO. OR C/S/O","SPLITS (G+Y+AR) IN SECONDS"]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B147=\"-\",0,B147))+(IF(C147=\"-\",0,C147))+(IF(D147=\"-\",0,D147))+(IF(E147=\"-\",0,E147))","v":0},{"$f":"(IF(F147=\"-\",0,F147))+(IF(G147=\"-\",0,G147))+(IF(H147=\"-\",0,H147))+(IF(I147=\"-\",0,I147))","v":0},{"$f":"(IF(B147=\"-\",0,B147))+(IF(C147=\"-\",0,C147))","v":0},{"$f":"(IF(F147=\"-\",0,F147))+(IF(G147=\"-\",0,G147))","v":0},{"$f":"(IF(D147=\"-\",0,D147))+(IF(E147=\"-\",0,E147))","v":0},{"$f":"(IF(H147=\"-\",0,H147))+(IF(I147=\"-\",0,I147))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",{"$f":"(IF(B148=\"-\",0,B148))+(IF(C148=\"-\",0,C148))+(IF(D148=\"-\",0,D148))+(IF(E148=\"-\",0,E148))","v":0},{"$f":"(IF(F148=\"-\",0,F148))+(IF(G148=\"-\",0,G148))+(IF(H148=\"-\",0,H148))+(IF(I148=\"-\",0,I148))","v":0},{"$f":"(IF(B148=\"-\",0,B148))+(IF(C148=\"-\",0,C148))","v":0},{"$f":"(IF(F148=\"-\",0,F148))+(IF(G148=\"-\",0,G148))","v":0},{"$f":"(IF(D148=\"-\",0,D148))+(IF(E148=\"-\",0,E148))","v":0},{"$f":"(IF(H148=\"-\",0,H148))+(IF(I148=\"-\",0,I148))","v":0}]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]
["-","-","-","-","-","-","-","-","-","-","-",0,0,0,0,0,0]