{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ZoneConfigurationTable","332S Input File","Version History"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"ZoneConfigurationTable","index":0,"n_rows":75,"n_cols":20,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,19,3,19],[5,8,5,9],[1,0,3,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version History'!C1","v":"Form Updated: November 2025"}]
["332S default cabinet input configuration (radar using SDLC, standard Device, Phase, and Function are shown)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:  Signal Timer - for standard detection zone set up (using SDLC, with an ATC controller), place an \"x\" in column A only (blue shaded area).   Changes to the \"device\", \"function\", or \"phase\" is allowed as deemed necessary to accomidate site specific detection needs (note: any changes made to these default standards will be highlighted yellow to make them standout).  If SDLC is NOT used or if there is mixed detection (e.g. loops and SDLC), place an \"x\" in column A AND column B when a device will be installed in the input slot (blue shaded area).  If loops are used, write \"Loop\" in the \"Device\" column. Columns O through R can be customized as needed. Place an \"x\" in the blue shaded cells of Row 10 if the column is used. Note: this worksheet is formatted to properly print the table for field use if desired. Signal Designer - after signal timer has filled out table, just click            then paste selection into Microstation Connect cabinet print detector sheet.  To see the entire table again, click on \"show entire table\"."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Intersection:"]
[]
[null,null,null,null,null,null,null,null,"TSSU ID:",null,null,"Highway:",null,"Milepoint:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Place\"x\" if Column is used"]
["Place \"x\" if MT# is used ","Device different from default","Phase different than default","function different from default","restore default phase","restore default function","place \"x\" input slot is used","slot reference","Device","Phase             ","phase/device","Function","MT #","BIU or INPUT SLOT","software zone","software channel"]
[null,{"$f":"IF(I12<>\"A\",1,\"\")","v":""},{"$f":"IF(J12<>2,1,\"\")","v":""},null,2,null,null,"I3U","A",2,{"$f":"\"Ф\"&J12&\" - \"&I12","v":"Ф2 - A"},null,2,{"$f":"IF($G12=\"x\",H12,9)","v":9}]
[null,"","",null,2,null,null,"I3L","A",2,"Ф2 - A",null,3,{"$f":"IF($G13=\"x\",H13,9)","v":9}]
[null,"","",null,2,null,null,"I4U","A",2,"Ф2 - A",null,4,{"$f":"IF($G14=\"x\",H14,9)","v":9}]
[null,"","",null,2,null,null,"I4L","A",2,"Ф2 - A",null,5,{"$f":"IF($G15=\"x\",H15,9)","v":9}]
[null,"","",null,2,null,null,"I5U","A",2,"Ф2 - A",null,6,{"$f":"IF($G16=\"x\",H16,9)","v":9}]
[null,"","",null,2,null,null,"I5L","A",2,"Ф2 - A",null,31,{"$f":"IF($G17=\"x\",H17,10)","v":10}]
[null,"","",{"$f":"IF(L18<>\"YR*\",1,\"\")","v":""},2,"YR*",null,null,"A",2,"Ф2 - A","YR*",42,11]
[null,"",{"$f":"IF(J19<>5,1,\"\")","v":""},null,5,null,null,"J1U","A",5,"Ф5 - A",null,15,{"$f":"IF($G19=\"x\",H19,9)","v":9}]
[null,"",{"$f":"IF(J20<>5,1,\"\")","v":""},null,5,null,null,"J1L","A",5,"Ф5 - A",null,27,{"$f":"IF($G20=\"x\",H20,10)","v":10}]
[null,"",{"$f":"IF(J21<>5,1,\"\")","v":""},null,5,null,null,"J2U","A",5,"Ф5 - A",null,35,{"$f":"IF($G21=\"x\",H21,11)","v":11}]
[null,"",{"$f":"IF(J22<>5,1,\"\")","v":""},null,5,null,null,"J2L","A",5,"Ф5 - A",null,36,{"$f":"IF($G22=\"x\",H22,11)","v":11}]
[null,"",{"$f":"IF(J23<>5,1,\"\")","v":""},{"$f":"IF(L23<>\"YR*\",1,\"\")","v":""},5,"YR*",null,null,"A",5,"Ф5 - A","YR*",45,11]
[null,{"$f":"IF(I24<>\"B\",1,\"\")","v":""},{"$f":"IF(J24<>4,1,\"\")","v":""},null,4,null,null,"I8U","B",4,"Ф4 - B",null,8,{"$f":"IF($G24=\"x\",H24,9)","v":9}]
[null,"","",null,4,null,null,"I8L","B",4,"Ф4 - B",null,9,{"$f":"IF($G25=\"x\",H25,9)","v":9}]
[null,"","",null,4,null,null,"I9U","B",4,"Ф4 - B",null,10,{"$f":"IF($G26=\"x\",H26,9)","v":9}]
[null,"","",null,4,null,null,"I9L","B",4,"Ф4 - B",null,11,{"$f":"IF($G27=\"x\",H27,9)","v":9}]
[null,"","",null,4,null,null,"I10U","B",4,"Ф4 - B",null,12,{"$f":"IF($G28=\"x\",H28,9)","v":9}]
[null,"","",null,4,null,null,"I10L","B",4,"Ф4 - B",null,34,{"$f":"IF($G29=\"x\",H29,11)","v":11}]
[null,"","",{"$f":"IF(L30<>\"YR*\",1,\"\")","v":""},4,"YR*",null,null,"B",4,"Ф4 - B","YR*",44,11]
[null,"",{"$f":"IF(J31<>7,1,\"\")","v":""},null,7,null,null,"J6U","B",7,"Ф7 - B",null,21,{"$f":"IF($G31=\"x\",H31,10)","v":10}]
[null,"",{"$f":"IF(J32<>7,1,\"\")","v":""},null,7,null,null,"J6L","B",7,"Ф7 - B",null,28,{"$f":"IF($G32=\"x\",H32,10)","v":10}]
[null,"",{"$f":"IF(J33<>7,1,\"\")","v":""},null,7,null,null,"J7U","B",7,"Ф7 - B",null,38,{"$f":"IF($G33=\"x\",H33,11)","v":11}]
[null,"",{"$f":"IF(J34<>7,1,\"\")","v":""},null,7,null,null,"J7L","B",7,"Ф7 - B",null,39,{"$f":"IF($G34=\"x\",H34,11)","v":11}]
[null,"",{"$f":"IF(J35<>7,1,\"\")","v":""},{"$f":"IF(L35<>\"YR*\",1,\"\")","v":""},7,"YR*",null,null,"B",7,"Ф7 - B","YR*",47,11]
[null,{"$f":"IF(I36<>\"C\",1,\"\")","v":""},{"$f":"IF(J36<>1,1,\"\")","v":""},null,1,null,null,"I1U","C",1,"Ф1 - C",null,1,{"$f":"IF($G36=\"x\",H36,9)","v":9}]
[null,"",{"$f":"IF(J37<>1,1,\"\")","v":""},null,1,null,null,"I1L","C",1,"Ф1 - C",null,13,{"$f":"IF($G37=\"x\",H37,9)","v":9}]
[null,"",{"$f":"IF(J38<>1,1,\"\")","v":""},null,1,null,null,"I2U","C",1,"Ф1 - C",null,29,{"$f":"IF($G38=\"x\",H38,10)","v":10}]
[null,"",{"$f":"IF(J39<>1,1,\"\")","v":""},null,1,null,null,"I2L","C",1,"Ф1 - C",null,30,{"$f":"IF($G39=\"x\",H39,10)","v":10}]
[null,"",{"$f":"IF(J40<>1,1,\"\")","v":""},{"$f":"IF(L40<>\"YR*\",1,\"\")","v":""},1,"YR*",null,null,"C",1,"Ф1 - C","YR*",41,11]
[null,"",{"$f":"IF(J41<>6,1,\"\")","v":""},null,6,null,null,"J3U","C",6,"Ф6 - C",null,16,{"$f":"IF($G41=\"x\",H41,9)","v":9}]
[null,"","",null,6,null,null,"J3L","C",6,"Ф6 - C",null,17,{"$f":"IF($G42=\"x\",H42,10)","v":10}]
[null,"","",null,6,null,null,"J4U","C",6,"Ф6 - C",null,18,{"$f":"IF($G43=\"x\",H43,10)","v":10}]
[null,"","",null,6,null,null,"J4L","C",6,{"$f":"\"Ф\"&J44&\" - \"&I44","v":"Ф6 - C"},null,19,{"$f":"IF($G44=\"x\",H44,10)","v":10}]
[null,"","",null,6,null,null,"J5U","C",6,"Ф6 - C",null,20,{"$f":"IF($G45=\"x\",H45,10)","v":10}]
[null,"","",null,6,null,null,"J5L","C",6,"Ф6 - C",null,37,{"$f":"IF($G46=\"x\",H46,11)","v":11}]
[null,"","",{"$f":"IF(L47<>\"YR*\",1,\"\")","v":""},6,"YR*",null,null,"C",6,"Ф6 - C","YR*",46,11]
[null,{"$f":"IF(I48<>\"D\",1,\"\")","v":""},{"$f":"IF(J48<>3,1,\"\")","v":""},null,3,null,null,"I6U","D",3,"Ф3 - D",null,7,{"$f":"IF($G48=\"x\",H48,9)","v":9}]
[null,"",{"$f":"IF(J49<>3,1,\"\")","v":""},null,3,null,null,"I6L","D",3,"Ф3 - D",null,14,{"$f":"IF($G49=\"x\",H49,9)","v":9}]
[null,"",{"$f":"IF(J50<>3,1,\"\")","v":""},null,3,null,null,"I7U","D",3,"Ф3 - D",null,32,{"$f":"IF($G50=\"x\",H50,10)","v":10}]
[null,"",{"$f":"IF(J51<>3,1,\"\")","v":""},null,3,null,null,"I7L","D",3,"Ф3 - D",null,33,{"$f":"IF($G51=\"x\",H51,11)","v":11}]
[null,"",{"$f":"IF(J52<>3,1,\"\")","v":""},{"$f":"IF(L52<>\"YR*\",1,\"\")","v":""},3,"YR*",null,null,"D",3,"Ф3 - D","YR*",43,11]
[null,"",{"$f":"IF(J53<>8,1,\"\")","v":""},null,8,null,null,"J8U","D",8,"Ф8 - D",null,22,{"$f":"IF($G53=\"x\",H53,10)","v":10}]
[null,"","",null,8,null,null,"J8L","D",8,"Ф8 - D",null,23,{"$f":"IF($G54=\"x\",H54,10)","v":10}]
[null,"","",null,8,null,null,"J9U","D",8,"Ф8 - D",null,24,{"$f":"IF($G55=\"x\",H55,10)","v":10}]
[null,"","",null,8,null,null,"J9L","D",8,"Ф8 - D",null,25,{"$f":"IF($G56=\"x\",H56,10)","v":10}]
[null,"","",null,8,null,null,"J10U","D",8,"Ф8 - D",null,26,{"$f":"IF($G57=\"x\",H57,10)","v":10}]
[null,"","",null,8,null,null,"J10L","D",8,"Ф8 - D",null,40,{"$f":"IF($G58=\"x\",H58,11)","v":11}]
[null,"","",{"$f":"IF(L59<>\"YR*\",1,\"\")","v":""},8,"YR*",null,null,"D",8,"Ф8 - D","YR*",48,11]
[null,{"$f":"IF(I60<>\"E\",1,\"\")","v":""},{"$f":"IF(J60<>2,1,\"\")","v":""},{"$f":"IF(L60<>\"A*\",1,\"\")","v":""},2,"A*",null,null,"E",2,"Ф2 - E","A*",49,11]
[null,{"$f":"IF(I61<>\"E\",1,\"\")","v":""},{"$f":"IF(J61<>2,1,\"\")","v":""},{"$f":"IF(L61<>\"CO*\",1,\"\")","v":""},2,"CO*",null,null,"E",2,"Ф2 - E","CO*",50,12]
[null,{"$f":"IF(I62<>\"F\",1,\"\")","v":""},{"$f":"IF(J62<>4,1,\"\")","v":""},{"$f":"IF(L62<>\"A*\",1,\"\")","v":""},4,"A*",null,null,"F",4,"Ф4 - F","A*",53,12]
[null,{"$f":"IF(I63<>\"F\",1,\"\")","v":""},{"$f":"IF(J63<>4,1,\"\")","v":""},{"$f":"IF(L63<>\"CO*\",1,\"\")","v":""},4,"CO*",null,null,"F",4,"Ф4 - F","CO*",54,12]
[null,{"$f":"IF(I64<>\"G\",1,\"\")","v":""},{"$f":"IF(J64<>6,1,\"\")","v":""},{"$f":"IF(L64<>\"A*\",1,\"\")","v":""},6,"A*",null,null,"G",6,"Ф6 - G","A*",51,12]
[null,{"$f":"IF(I65<>\"G\",1,\"\")","v":""},{"$f":"IF(J65<>6,1,\"\")","v":""},{"$f":"IF(L65<>\"CO*\",1,\"\")","v":""},6,"CO*",null,null,"G",6,"Ф6 - G","CO*",52,12]
[null,{"$f":"IF(I66<>\"H\",1,\"\")","v":""},{"$f":"IF(J66<>8,1,\"\")","v":""},{"$f":"IF(L66<>\"A*\",1,\"\")","v":""},8,"A*",null,null,"H",8,"Ф8 - H","A*",55,12]
[null,{"$f":"IF(I67<>\"H\",1,\"\")","v":""},{"$f":"IF(J67<>8,1,\"\")","v":""},{"$f":"IF(L67<>\"CO*\",1,\"\")","v":""},8,"CO*",null,null,"H",8,"Ф8 - H","CO*",56,12]
[null,null,null,{"$f":"IF(L68<>\"misc\",1,\"\")","v":""},null,"misc",null,null,null,null,"Ф - ","misc",57,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",58,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",59,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",60,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",61,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",62,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",63,12]
[null,null,null,"",null,"misc",null,null,null,null,"Ф - ","misc",64,12]

{"sheet":"332S Input File","index":1,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,14],[3,11,3,12]]}
[null,"Instructions: Signal Timer - In yellow highlighted cells, select the appropriate device from drop down box if the input slot is used (all other info is auto populated from info entered in the \"ZoneConfigurationTable\").  In the blue highlighted cells, select the \"X\" from the drop down box to show the input is used.    "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version History'!C1","v":"Form Updated: November 2025"},null,"device list"]
[null,"I1","I2","I3","I4","I5","I6","I7","I8","I9","I10","I11","I12","I13","I14",null,"LEGEND:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(L5=\"x\",M5=\"x\"),\"VRCM\",\"\")","v":""},null,{"$f":"IF(OR(N5=\"x\",N16=\"x\"),242,\"\")","v":""},{"$f":"IF(OR(O5=\"x\",O16=\"x\"),242,\"\")","v":""},null,"Device (Select appropriate device in drop down list in each yellow highlighted cells only.  Note: VIP, 4 I/O, 764, and VRCM modules span two slots)   ",null,"RAD"]
[null,{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(1,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(1,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(29,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(29,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(2,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(2,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(4,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(4,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(6,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(6,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(7,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(7,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(32,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(32,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(8,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(8,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(10,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(10,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(12,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(12,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},null,null,null,null,null,"Use drop down list to check \"X\" in box if device is present (in blue highlighted cells only)",null,"VIP",null,255,"x",752]
[null,{"$f":"IF(B5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(1,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(29,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(2,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(4,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(6,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(7,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(32,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(8,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(10,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K5=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(12,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"funtion information (e.g. A, CO, P, YR, TH Zone, LT Count, etc.).  Info Imported from other worksheet",null,"4 I/O",null,null,null,2140]
[null,{"$f":"IF(B5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(1,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(29,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(2,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(4,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(6,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(7,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(32,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(8,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(10,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K5=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(12,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"Phase - Detector Unit.  Info imported from other worksheet",null,"2 I/O",null,null,null,762]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,null,null,null,764]
[null,"MT1","MT29","MT2","MT4","MT6","MT7","MT32","MT8","MT10","MT12","SPARE","SPARE","2 PED","6 PED"]
[null,"C1-56","C11-16","C1-39","C1-63","C1-47","C1-58","C11-18","C1-41","C1-65","C1-49","C11-23","C11-24","C1-67","C1-68"]
[null,"C1-60","C11-20","C1-43","C1-76","C11-10","C1-62","C11-22","C1-45","C1-78","C11-12","C11-25","C11-26","C1-69","C1-70"]
[null,"MT13","MT30","MT3","MT5","MT31","MT14","MT33","MT9","MT11","MT34","SPARE","SPARE","4 PED","8 PED"]
[]
[null,{"$f":"IF(B16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(13,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(30,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(3,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(5,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(31,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(14,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(33,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(9,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(11,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K16=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(34,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"Phase - Detector Unit"]
[null,{"$f":"IF(B16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(13,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(30,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(3,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(5,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(31,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(14,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(33,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(9,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(11,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K16=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(34,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"funtion information (e.g. TH Zone, LT Count, etc.)"]
[null,{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(13,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(13,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(30,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(30,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(3,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(3,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(5,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(5,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(31,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(31,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(14,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(14,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(33,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(33,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(9,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(9,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(11,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(11,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(34,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(34,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},null,null,null,null,null,"Use drop down list to check \"X\" in box if device is present (in blue highlighted cells only)"]
[]
[null,"J1","J2","J3","J4","J5","J6","J7","J8","J9","J10","J11","J12","J13","J14",null,"LEGEND:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M20=\"x\",M31=\"x\"),255,\"\")","v":""},null,null,null,"Device (Select appropriate device in drop down list in each yellow highlighted cells only.  Note: VIP, 4 I/O, 764, and VRCM modules span two slots)   "]
[null,{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(15,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(15,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(35,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(35,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(16,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(16,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(18,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(18,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(20,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(20,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(21,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(21,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(38,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(38,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(22,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(22,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(24,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(24,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(26,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(26,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},null,null,null,null,null,"Use drop down list to check \"X\" in box if device is present (in blue highlighted cells only)"]
[null,{"$f":"IF(B20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(15,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(35,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(16,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(18,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(20,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(21,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(38,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(22,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(24,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K20=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(26,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"funtion information (e.g. A, CO, P, YR, TH Zone, LT Count, etc.).  Info Imported from other worksheet"]
[null,{"$f":"IF(B20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(15,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(35,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(16,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(18,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(20,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(21,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(38,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(22,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(24,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K20=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(26,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"Phase - Detector Unit.  Info imported from other worksheet"]
[]
[null,"MT15","MT35","MT16","MT18","MT20","MT21","MT38","MT22","MT24","MT26","SPARE","PCOI","EVA","EVB"]
[null,"C1-55","C11-15","C1-40","C1-64","C1-48","C1-57","C11-17","C1-42","C1-66","C1-50","C1-54","C1-51","C1-71","C1-72"]
[null,"C1-59","C11-19","C1-44","C1-77","C11-11","C1-61","C11-21","C1-46","C1-79","C11-13","C1-75","C1-52","C1-73","C1-74"]
[null,"MT27","MT36","MT17","MT19","MT37","MT28","MT39","MT23","MT25","MT40","GPS","VCOI","EVC","EVD"]
[]
[null,{"$f":"IF(B31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(27,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(36,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(17,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(19,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(37,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(28,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(39,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(23,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(25,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K31=\"\",\"\",INDEX(ZoneConfigurationTable!$K$12:$K$75,MATCH(40,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"funtion information (e.g. TH Zone, LT Count, etc.).  Info Imported from other worksheet"]
[null,{"$f":"IF(B31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(27,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(C31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(36,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(D31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(17,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(E31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(19,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(F31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(37,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(G31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(28,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(H31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(39,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(I31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(23,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(J31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(25,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},{"$f":"IF(K31=\"\",\"\",INDEX(ZoneConfigurationTable!$L$12:$L$75,MATCH(40,ZoneConfigurationTable!$M$12:$M$75,0))&\"\")","v":""},null,null,null,null,null,"Phase - Detector Unit.  Info imported from other worksheet"]
[null,{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(27,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(27,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(36,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(36,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(17,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(17,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(19,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(19,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(37,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(37,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(28,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(28,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(39,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(39,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(23,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(23,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(25,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(25,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},{"$f":"IF(INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(40,ZoneConfigurationTable!$M$12:$M$75,0))=\"\",\"\",INDEX(ZoneConfigurationTable!$G$12:$G$75,MATCH(40,ZoneConfigurationTable!$M$12:$M$75,0)))","v":""},null,null,null,null,null,"Use drop down list to check \"X\" in box if device is present (in blue highlighted cells only)"]
[]
[null,"VD1","VD29","VD9","VD11","VD13","VD3","VD32","VD14","VD16","VD18"]
[null,"VD2","VD30","VD10","VD12","VD31","VD4","VD33","VD15","VD17","VD34"]
[]
[null,"VD5","VD35","VD19","VD21","VD23","VD7","VD38","VD24","VD26","VD28"]
[null,"VD6","VD36","VD20","VD22","VD37","VD8","VD39","VD25","VD27","VD40"]
[]
[null,"MT1","MT29","MT2","MT4","MT6","MT7","MT32","MT8","MT10","MT12"]
[null,"MT13","MT30","MT3","MT5","MT31","MT14","MT33","MT9","MT11","MT34"]
[]
[null,"MT15","MT35","MT16","MT18","MT20","MT21","MT38","MT22","MT24","MT26"]
[null,"MT27","MT36","MT17","MT19","MT37","MT28","MT39","MT23","MT25","MT40"]

{"sheet":"Version History","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Version Notes",null,"Form Updated: November 2025"]
[]
["Date","Notes"]
["2025-11-01","Added 762 and 764 to J13/J14 dropdown"]