{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Configurator","Wiring Table","Heads & Actuator","Wiring Requirements","QD","List Price"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Configurator","index":0,"n_rows":119,"n_cols":43,"rows_kept":119,"cut":false,"hidden":false,"merged":[[105,9,105,10],[106,9,106,10],[116,9,116,10],[117,9,117,10],[107,9,107,10],[108,9,108,10],[109,9,109,10],[114,9,114,10],[115,9,115,10],[110,9,110,10],[111,9,111,10],[112,9,112,10],[113,9,113,10],[101,9,101,10],[102,9,102,10],[103,9,103,10],[104,9,104,10],[100,9,100,10],[18,13,18,23],[34,13,34,23],[47,6,47,7],[48,6,48,7],[20,4,20,7],[21,4,21,7],[24,4,24,7],[25,4,25,7],[27,4,27,7],[18,4,18,7],[32,7,33,7],[38,7,39,7],[34,7,37,7],[23,3,23,7],[28,4,28,7],[24,2,28,2],[30,2,39,2],[59,2,95,2],[99,2,117,2],[53,6,53,7],[54,6,54,7],[56,4,56,7],[57,4,57,7],[47,2,54,2],[56,2,57,2],[49,6,49,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[58,3,58,7],[98,3,98,7],[1,10,1,11],[0,8,1,9],[11,2,15,2],[17,2,18,2],[20,2,21,2],[10,4,10,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[17,4,17,7],[11,4,11,7],[12,4,12,7],[7,5,7,7]]}
[null,null,null,null,null,null,null,null,"Weight"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Wiring Requirements'!AY16","v":0},null,"Kg"]
[]
[null,null,null,null,null,null,null,null,"Head",1,2,3,4,5,6,7,8,9,10,"Base"]
[null,null,null,null,null,null,null,null,{"$f":"'Heads & Actuator'!C14","v":0},{"$f":"IF(ISNA(VLOOKUP(J4,$B$21:$H$58,3,FALSE)),K5,VLOOKUP(J4,$B$21:$H$58,3,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(K4,$B$21:$H$58,3,FALSE)),L5,VLOOKUP(K4,$B$21:$H$58,3,FALSE))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(AND(M19=1,M41+M28+M29=0),1,0)","v":0},null,null,null,{"$f":"HLOOKUP(J4,$M$59:$V$98,40,FALSE)","v":0},{"$f":"HLOOKUP(K4,$M$59:$V$98,40,FALSE)","v":0},{"$f":"HLOOKUP(L4,$M$59:$V$98,40,FALSE)","v":0},{"$f":"HLOOKUP(M4,$M$59:$V$98,40,FALSE)","v":0},{"$f":"HLOOKUP(N4,$M$59:$V$98,40,FALSE)","v":0},0,0,0,0,0,{"$f":"VLOOKUP(1,$M$100:$W$118,11,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(J6),1,IF(AND(J6=0,J5<>0),1,0))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(OR(I8=0,T8=0,AND(T8<>0, M20=0)),\"Error - You need a Head & Base\",IF(AB119=1,\"Error - Base is not valid\",IF(AND(M23>=1,M41=0),\"You must select safety contacts to go with IR\",IF(F6=1,\"Error-Head has no lock or switch\",\"\"))))","v":"Error - You need a Head & Base"},null,null,{"$f":"I5","v":0},{"$f":"IF(J7=0,IF(J6=0,0,RIGHT(J6,2)),IF(J5=0,0,IF(LEN(J5)=3,RIGHT(J5,2),IF(J5=K5,MID(J5,2,2),RIGHT(J5,2)))))","v":0},{"$f":"IF(K7=0,IF(K6=0,0,RIGHT(K6,2)),IF(K5=0,0,IF(LEN(K5)=3,RIGHT(K5,2),IF(K5=L5,MID(K5,2,2),RIGHT(K5,2)))))","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(ISNA(T6),0,RIGHT(T6,2))","v":0},null,null,{"$f":"IF(ISNA(T8),0,IF(OR((MAX(A21:A57)+SUM(M60:V96))+M58=7,(MAX(A21:A57)+SUM(M60:V96))+M58=9),1,0))","v":0}]
[]
[]
[null,null,null,"Part No","Description / Information",null,null,null,"Number of Bays Used","tGard Input (I)","tGard Output (O)","Safety Circuits","Selection"]
[null,null,"Actuators","TAF","Fixed Actuator",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$17-M12=1,$M$18=1),0,1)","v":1},0]
[null,null,null,"TAH","Hinged Actuator",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$17-M13=1,$M$18=1),0,1)","v":1},0]
[null,null,null,"TAS","Sliding Actuator",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$17-M14=1,$M$18=1),0,1)","v":1},0]
[null,null,null,"TEN","Handle Actuator (No internal knob)",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$17-M15=1,$M$18=1),0,1)","v":1},0]
[null,null,null,"TEH ","Handle Actuator",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$17-M16=1,$M$18=1),0,1)","v":1},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12:M16)","v":0}]
[null,null,"Head","THC","Cap",null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M17=1,M19=1),0,1)","v":1},0]
[null,null,null,"THM","Head",null,null,null,0,0,0,0,null,{"$f":"IF(M19=1,IF(M17=0,\"Are you sure you don't want an Actuator to go with your Head?\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M18=1,0,1)","v":1},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M18:M19)","v":0}]
[{"$f":"IF(M21=1,1,0)","v":0},{"$f":"A21","v":0},"IR","TRX","Standard 60mm Internal Release",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($M$19=1,M22=0,M15=0),1,0)","v":0},0]
[{"$f":"IF(M22=1,1,0)","v":0},{"$f":"A22","v":0},null,"TRZ","Variable Length Internal Release",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($M$19=1,M21=0,M15=0),1,0)","v":0},0]
[null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M21:M22)","v":0}]
[null,0,null,"Safety Lock",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9]
[{"$f":"IF(M25>0,M25+MAX(A$21:A24),0)","v":0},0,"Locks","TSN","Standard Safety Lock (No Key)",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($AI25>=Z$24,Z$24,0)","v":1},{"$f":"IF($AI25>=AA$24,AA$24,0)","v":2},3,4,5,6,7,8,9,{"$f":"10-($A$60-M25)","v":10}]
[{"$f":"IF(M26>0,M26+MAX(A$21:A25),0)","v":0},0,null,"TGN","Master Safety Lock (No Key)",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($AI26>=Z$24,Z$24,0)","v":1},2,3,4,5,6,7,8,9,{"$f":"10-($A$60-M26)","v":10}]
[null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:M26)","v":0}]
[{"$f":"IF(M28>0,M28+MAX(A$21:A27),0)","v":0},0,null,"TAB","Standard Access Lock (No Key)",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($AI28>=Z$24,Z$24,0)","v":1},2,3,4,5,6,7,8,9,{"$f":"10-($A$60-M28)","v":10}]
[{"$f":"IF(M29>0,M29+MAX(A$21:A28),0)","v":0},0,null,"TQB","Master Access Lock (No Key)",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,{"$f":"10-($A$60-M29)","v":10}]
[null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M28:M29)","v":0}]
[{"$f":"IF(M31>0,M31+MAX(A$21:A30),0)","v":0},0,"Safety Switches & Solenoids","TSM","Safety Switch",null,null,null,1,0,1,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$41-M31=1,SUM($M$52:$M$55)+$M$57>1),0,IF(AND(($M$19+$M$27+$M$30)>0,MAX($A$21:$A$60)-M31<10),1,0))","v":0},0]
[{"$f":"IF(M32>0,M32+MAX(A$21:A31),0)","v":0},0,null,"TSS","Safety Switch","No Monitor",null,null,1,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$41-M32=1,SUM($M$52:$M$55)+$M$57>1),0,IF(AND(($M$19+$M$27+$M$30)>0,MAX($A$21:$A$60)-M32<10),1,0))","v":0},0]
[{"$f":"IF(M33>0,(2*M33)+MAX(A$21:A32),0)","v":0},0,null,"TSMDU","Sol. PTU",null,"Option 1","When locked Sol. Mon. = 0v",2,1,2,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($M$41-M33=1),0,IF(AND(($M$19+$M$27+$M$30)>0,(MAX($A$21:$A$60)-2*M33)<9),1,0))","v":0},0]
[{"$f":"IF(M34>0,(2*M34)+MAX(A$21:A33),0)","v":0},0,null,"TSMDL","Sol. PTL",null,"Option 1",null,2,1,2,2,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M35>0,(2*M35)+MAX(A$21:A34),0)","v":0},0,null,"TSSEU","Sol. PTU","No Monitor","Option 2","When locked, Solenoid Monitor Output = 24v",2,1,1,2,null,{"$f":"IF(AND(M23>=1,M41=0),\"You must select safety contacts to go with IR\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M36>0,(2*M36)+MAX(A$21:A35),0)","v":0},0,null,"TSSEL","Sol. PTL","No Monitor","Option 2",null,2,1,1,2,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M37>0,(2*M37)+MAX(A$21:A36),0)","v":0},0,null,"TSMEU","Sol. PTU",null,"Option 2",null,2,1,2,2,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M38>0,(2*M38)+MAX(A$21:A37),0)","v":0},0,null,"TSMEL","Sol. PTL",null,"Option 2",null,2,1,2,2,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M39>0,(2*M39)+MAX(A$21:A38),0)","v":0},0,null,"TSMFU","Sol. PTU",null,"4 Channel","When locked Sol. Mon. = 0v",2,1,2,4,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(M40>0,(2*M40)+MAX(A$21:A39),0)","v":0},0,null,"TSMFL","Sol. PTL",null,"4 Channel",null,2,1,2,4,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:M40)","v":0}]
[null,0,null,"TDU",null,null,null,null,null,1,1,0.1]
[null,0,null,"TDL",null,null,null,null,null,1,1,0.1]
[null,0,null,"TEU",null,null,null,null,null,1,1,0]
[null,0,null,"TEL",null,null,null,null,null,1,1,0]
[null,0,null,"TFU",null,null,null,null,null,1,1,2]
[null,0,null,"TFL",null,null,null,null,null,1,1,2]
[{"$f":"IF(M48>0,M48+MAX(A$21:A41),0)","v":0},0,"e-Stop","TEC","Twist",null,"Series Wiring (with head)",null,1,0,0,0.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M48=1,$M$41=0,MAX($A$21:$A$60)-M48>9),0,1)","v":0},0]
[{"$f":"IF(M49>0,M49+MAX(A$21:A48),0)","v":0},0,null,"TEW","Pull",null,"Series Wiring (with head)",null,1,0,0,0.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M49=1,$M$41=0,MAX($A$21:$A$60)-M49>9),0,1)","v":0},0]
[{"$f":"IF(M50>0,M50+MAX(A$21:A49),0)","v":0},0,null,"TED","Twist","Monitored","Series Wiring (with head)",null,1,0,1,0.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M50=1,$M$41=0,MAX($A$21:$A$60)-M50>9),0,1)","v":0},0]
[{"$f":"IF(M51>0,M51+MAX(A$21:A50),0)","v":0},0,null,"TEV","Twist","Illuminated","Series Wiring (with head)",null,1,1,0,0.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M51=1,$M$41=0,MAX($A$21:$A$60)-M51>9),0,1)","v":0},0]
[{"$f":"IF(M52>0,M52+MAX(A$21:A51),0)","v":0},0,null,"TET","Twist",null,"Independent Wiring",null,1,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M52=1,SUM($M$39:$M$40)>0,MAX($A$21:$A$60)-M52>9),0,1)","v":1},0]
[{"$f":"IF(M53>0,M53+MAX(A$21:A52),0)","v":0},0,null,"TEP","Pull",null,"Independent Wiring",null,1,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$56-M53=1,SUM($M$39:$M$40)>0,MAX($A$21:$A$60)-M53>9),0,1)","v":1},0]
[{"$f":"IF(M54>0,M54+MAX(A$21:A53),0)","v":0},{"$f":"IF(T54=\"Yes\",A60,A54)","v":0},null,"TEM","Twist","Monitored","Independent Wiring",null,1,0,1,2,null,null,null,null,null,null,"Locate at bottom of stack?",null,null,null,null,null,{"$f":"IF(OR($M$56-M54=1,SUM($M$39:$M$40)>0,MAX($A$21:$A$60)-M54>9),0,1)","v":1},0,null,{"$f":"IF(M54=1,\"Yes\",\"\")","v":""},{"$f":"IF(M54=1,\"No\",\"\")","v":""}]
[{"$f":"IF(M55>0,M55+MAX(A$21:A54),0)","v":0},{"$f":"IF(T55=\"Yes\",A60,A55)","v":0},null,"TEI","Twist","Illuminated","Independent Wiring",null,1,1,0,2,null,null,null,null,null,null,"Locate at bottom of stack?",null,null,null,null,null,{"$f":"IF(OR($M$56-M55=1,SUM($M$39:$M$40)>0,MAX($A$21:$A$60)-M55>9),0,1)","v":1},0,null,{"$f":"IF(M55=1,\"Yes\",\"\")","v":""},{"$f":"IF(M55=1,\"No\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48:M55)","v":0}]
[{"$f":"IF(M57>0,M57+MAX(A$21:A56),0)","v":0},{"$f":"IF(OR(T54=\"Yes\",T55=\"Yes\"),A57-1,A57)","v":0},"Misc","TSR","Blue Re-Start Switch",null,null,null,1,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M39+M40+M41+SUM(M52:M55)>=2,MAX($A$21:$A$60)-M57>9),0,1)","v":1},0]
[{"$f":"IF(M119=0,M58+MAX(A$21:A57),M58+MAX(A$21:A57)+W8)","v":0},{"$f":"IF(OR(T54=\"Yes\",T55=\"Yes\"),A58-1,A58)","v":0},null,"TEB","Blank (To allow expansion in future)",null,null,null,1,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF($AI58>=Z$24,Z$24,0)","v":1},2,3,4,5,6,7,8,9,{"$f":"10-($A$60-M58)","v":10}]
[{"$f":"MAX(A21:A58)","v":0},null,null,"Control",null,null,null,null,null,null,null,null,{"$f":"IF(A59<10,IF(OR(T54=\"yes\",T55=\"Yes\"),A59,A59+1),0)","v":1},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:M59)<9,M59+1,0),IF(MAX($M$59:M59)<10,M59+1,0))","v":2},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:N59)<9,N59+1,0),IF(MAX($M$59:N59)<10,N59+1,0))","v":3},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:O59)<9,O59+1,0),IF(MAX($M$59:O59)<10,O59+1,0))","v":4},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:P59)<9,P59+1,0),IF(MAX($M$59:P59)<10,P59+1,0))","v":5},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:Q59)<9,Q59+1,0),IF(MAX($M$59:Q59)<10,Q59+1,0))","v":6},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:R59)<9,R59+1,0),IF(MAX($M$59:R59)<10,R59+1,0))","v":7},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:S59)<9,S59+1,0),IF(MAX($M$59:S59)<10,S59+1,0))","v":8},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:T59)<9,T59+1,0),IF(MAX($M$59:T59)<10,T59+1,0))","v":9},{"$f":"IF(OR($T$54=\"Yes\",$T$55=\"Yes\"),IF(MAX($M$59:U59)<9,U59+1,0),IF(MAX($M$59:U59)<10,U59+1,0))","v":10}]
[{"$f":"A59+SUM(M60:V96)","v":0},null,"Control","TP1","P. Button","Red","illuminated",null,1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TP1",0,{"$f":"IF(OR(M$97-M60=1,M$59=0),0,IF((MAX($A$21:$A$60)-M60)<10,1,0))","v":1},0,{"$f":"IF(OR(N$97-N60=1,N$59=0),0,IF((MAX($A$21:$A$60)-N60)<10,1,0))","v":1},0,{"$f":"IF(OR(O$97-O60=1,O$59=0),0,IF((MAX($A$21:$A$60)-O60)<10,1,0))","v":1},0,{"$f":"IF(OR(P$97-P60=1,P$59=0),0,IF((MAX($A$21:$A$60)-P60)<10,1,0))","v":1},0,{"$f":"IF(OR(Q$97-Q60=1,Q$59=0),0,IF((MAX($A$21:$A$60)-Q60)<10,1,0))","v":1},0,{"$f":"IF(OR(R$97-R60=1,R$59=0),0,IF((MAX($A$21:$A$60)-R60)<10,1,0))","v":1},0,{"$f":"IF(OR(S$97-S60=1,S$59=0),0,IF((MAX($A$21:$A$60)-S60)<10,1,0))","v":1},0,{"$f":"IF(OR(T$97-T60=1,T$59=0),0,IF((MAX($A$21:$A$60)-T60)<10,1,0))","v":1},0,{"$f":"IF(OR(U$97-U60=1,U$59=0),0,IF((MAX($A$21:$A$60)-U60)<10,1,0))","v":1},0,{"$f":"IF(OR(V$97-V60=1,V$59=0),0,IF((MAX($A$21:$A$60)-V60)<10,1,0))","v":1}]
[null,null,null,"TP2","P. Button","Yellow","illuminated",null,1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TP2",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TP3","P. Button","Green","illuminated",null,1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TP3",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TP6","P. Button","Blue","illuminated",null,1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TP6",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TP7","P. Button","White","illuminated",null,1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TP7",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TG1","P. Button","Red","illuminated","Protruding",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TG1",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TG5","P. Button","Yellow","illuminated","Protruding",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TG5",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TG3","P. Button","Green","illuminated","Protruding",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TG3",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TG6","P. Button","Blue","illuminated","Protruding",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TG6",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TG7","P. Button","White","illuminated","Protruding",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"TG7",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPB","P. Button","Black",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPB",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPR","P. Button","Red",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPR",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPG","P. Button","Green",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPG",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPW","P. Button","White",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPW",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPY","P. Button","Yellow",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPY",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TPZ","P. Button","Blue",null,null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TPZ",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGB","P. Button","Black",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGB",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGR","P. Button","Red",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGR",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGG","P. Button","Green",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGG",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGW","P. Button","White",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGW",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGY","P. Button","Yellow",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGY",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TGZ","P. Button","Blue",null,"Protruding",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TGZ",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TLB","LED Lamp","Blue",null,null,1,1,0,0,null,null,null,null,null,null,null,null,null,null,"TLB",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TLG","LED Lamp","Green",null,null,1,1,0,0,null,null,null,null,null,null,null,null,null,null,"TLG",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TLR","LED Lamp","Red",null,null,1,1,0,0,null,null,null,null,null,null,null,null,null,null,"TLR",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TLW","LED Lamp","White",null,null,1,1,0,0,null,null,null,null,null,null,null,null,null,null,"TLW",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TLY","LED Lamp","Yellow",null,null,1,1,0,0,null,null,null,null,null,null,null,null,null,null,"TLY",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T2E","Sel Switch","2 Pos.","Latching","illuminated",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"T2E",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T2F","Sel Switch","2 Pos.","Momentary","illuminated",1,1,1,0,null,null,null,null,null,null,null,null,null,null,"T2F",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T2A","Sel Switch","2 Pos.","Latching",null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"T2A",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T2D","Sel Switch","2 Pos.","Momentary",null,1,0,1,0,null,null,null,null,null,null,null,null,null,null,"T2D",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TK5","Sel Switch","2 Pos.","Latching","Key",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TK5",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"TK6","Sel Switch","2 Pos.","Momentary","Key",1,0,1,0,null,null,null,null,null,null,null,null,null,null,"TK6",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T3A","Sel Switch","3 Pos.","Latching",null,1,0,2,0,null,null,null,null,null,null,null,null,null,null,"T3A",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T3D","Sel Switch","3 Pos.","Momentary",null,1,0,2,0,null,null,null,null,null,null,null,null,null,null,"T3D",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T3E","Sel Switch","3 Pos.","Latching","illuminated",1,1,2,0,null,null,null,null,null,null,null,null,null,null,"T3E",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,"T3F","Sel Switch","3 Pos.","Momentary","illuminated",1,1,2,0,null,null,null,null,null,null,null,null,null,null,"T3F",0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M60:M96)","v":0},{"$f":"SUM(N60:N96)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97=1,VLOOKUP(1,M$60:$W$96,11,FALSE),0)","v":0},{"$f":"IF(N97=1,VLOOKUP(1,N$60:$W$96,10,FALSE),0)","v":0},{"$f":"IF(O97=1,VLOOKUP(1,O$60:$W$96,9,FALSE),0)","v":0},{"$f":"IF(P97=1,VLOOKUP(1,P$60:$W$96,8,FALSE),0)","v":0},{"$f":"IF(Q97=1,VLOOKUP(1,Q$60:$W$96,7,FALSE),0)","v":0},{"$f":"IF(R97=1,VLOOKUP(1,R$60:$W$96,6,FALSE),0)","v":0},{"$f":"IF(S97=1,VLOOKUP(1,S$60:$W$96,5,FALSE),0)","v":0},{"$f":"IF(T97=1,VLOOKUP(1,T$60:$W$96,4,FALSE),0)","v":0},{"$f":"IF(U97=1,VLOOKUP(1,U$60:$W$96,3,FALSE),0)","v":0},{"$f":"IF(V97=1,VLOOKUP(1,V$60:$W$96,2,FALSE),0)","v":0}]
[]
[null,null,"Base","TBF","Foot",null,null,null,0,0,0,"No",null,null,null,null,null,null,null,null,null,null,"TBF",null,{"$f":"IF(SUM('Wiring Requirements'!G18:G19)=0,1,0)","v":1},0,null,{"$f":"IF(M100=1,IF(Y100=0,1,0),0)","v":0}]
[null,null,null,"TQ1","QD","5 Pin M12","Safety",null,0,0,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ1",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,($M$119-M101)=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18=0),1,0))","v":0},0,null,0]
[null,null,null,"TQ2","QD","8 Pin M12",null,"Control",0,5,null,"No",null,null,null,null,null,null,null,null,null,null,"TQ2",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M102=1),0,IF(AND('Wiring Requirements'!$G$19=0,'Wiring Requirements'!$G$18<=5),1,0))","v":0},0,null,0]
[null,null,null,"TQ3","QD","8 Pin M12","Safety","Control",0,1,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ3",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M103=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=1),1,0))","v":0},0,null,0]
[null,null,null,"TQ4","QD","12 Pin M23",null,"Control",0,9,null,"No",null,null,null,null,null,null,null,null,null,null,"TQ4",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M104=1),0,IF(AND('Wiring Requirements'!$G$19=0,'Wiring Requirements'!$G$18<=9),1,0))","v":0},0,null,0]
[null,null,null,"TQ5","QD","12 Pin M23","Safety","Control",0,5,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ5",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M105=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=5),1,0))","v":0},0,null,{"$f":"IF(M105=1,IF(Y105=0,1,0),0)","v":0}]
[null,null,null,"TQ6","QD","14 Pin 7/8\" UN2","Safety","Control",0,7,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ6",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M106=1,(A60-MAX(A21:A40))<4),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=7),1,0))","v":0},0,null,{"$f":"IF(M106=1,IF(Y106=0,1,0),0)","v":0}]
[null,null,null,"TQ7","QD","14 Pin 7/8\" UN2","Safety","Control",0,7,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ7",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M107=1,(A60-MAX(A21:A40))>3),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=7),1,0))","v":0},0,null,0]
[null,null,null,"TQ8","QD","19 Pin M23","Safety","Control",0,12,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TQ8",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M108=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=12),1,0))","v":0},0,null,0]
[null,null,null,"TQ9","QD","19 Pin M23","Dual Safety","Control",0,8,null,"Y x 2",null,null,null,null,null,null,null,null,null,null,"TQ9",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M109=1),0,IF(AND('Wiring Requirements'!$G$19<=4,'Wiring Requirements'!$G$18<=8),1,0))","v":0},0,null,0]
[null,null,null,"TW1","Selfwire","12 Terminals","Safety","Control",0,6,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TW1",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M110=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=6),1,0))","v":0},0,null,0]
[null,null,null,"TW2","Selfwire","12 Terminals",null,"Control",0,10,null,"No",null,null,null,null,null,null,null,null,null,null,"TW2",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M111=1),0,IF(AND('Wiring Requirements'!$G$19=0,'Wiring Requirements'!$G$18<=10),1,0))","v":0},0,null,0]
[null,null,null,"TW3","Selfwire","24 Terminals","Dual Safety","Control",0,14,null,"Y x 2",null,null,null,null,null,null,null,null,null,null,"TW3",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M112=1),0,IF(AND('Wiring Requirements'!$G$19<=4,'Wiring Requirements'!$G$18<=14),1,0))","v":0},0,null,0]
[null,null,null,"TC2","2m Cable","8 Core",null,"Control",0,5,null,"No",null,null,null,null,null,null,null,null,null,null,"TC2",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M113=1),0,IF(AND('Wiring Requirements'!$G$19=0,'Wiring Requirements'!$G$18<=5),1,0))","v":0},0,null,0]
[null,null,null,"TC3","2m Cable","8 Core","Safety","Control",0,1,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TC3",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M114=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=1),1,0))","v":0},0,null,0]
[null,null,null,"TC4","2m Cable","12 Core",null,"Control",0,9,null,"No",null,null,null,null,null,null,null,null,null,null,"TC4",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M115=1),0,IF(AND('Wiring Requirements'!$G$19=0,'Wiring Requirements'!$G$18<=9),1,0))","v":0},0,null,0]
[null,null,null,"TC5","2m Cable","12 Core","Safety","Control",0,5,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TC5",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M116=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=5),1,0))","v":0},0,null,0]
[null,null,null,"TC8","2m Cable","19 Core","Safety","Control",0,12,null,"Yes",null,null,null,null,null,null,null,null,null,null,"TC8",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M117=1),0,IF(AND('Wiring Requirements'!$G$19<=2,'Wiring Requirements'!$G$18<=12),1,0))","v":0},0,null,0]
[null,null,null,"TC9","2m Cable","19 Core","Dual Safety","Control",0,8,null,"Y x 2",null,null,null,null,null,null,null,null,null,null,"TC9",null,{"$f":"IF(OR(SUM('Wiring Requirements'!$G$18:$G$19)=0,$M$119-M118=1),0,IF(AND('Wiring Requirements'!$G$19<=4,'Wiring Requirements'!$G$18<=8),1,0))","v":0},0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M100:M118)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB100:AB118)","v":0}]

{"sheet":"Wiring Table","index":1,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Head",1,2,3,4,5,6,7,8,9,10,"Base"]
[null,{"$f":"IF(Configurator!I8=0,\"\",Configurator!I8)","v":""},{"$f":"IF(Configurator!J8=0,\"\",Configurator!J8)","v":""},{"$f":"IF(Configurator!K8=0,\"\",Configurator!K8)","v":""},{"$f":"IF(Configurator!L8=0,\"\",Configurator!L8)","v":""},{"$f":"IF(Configurator!M8=0,\"\",Configurator!M8)","v":""},{"$f":"IF(Configurator!N8=0,\"\",Configurator!N8)","v":""},{"$f":"IF(Configurator!O8=0,\"\",Configurator!O8)","v":""},{"$f":"IF(Configurator!P8=0,\"\",Configurator!P8)","v":""},{"$f":"IF(Configurator!Q8=0,\"\",Configurator!Q8)","v":""},{"$f":"IF(Configurator!R8=0,\"\",Configurator!R8)","v":""},{"$f":"IF(Configurator!S8=0,\"\",Configurator!S8)","v":""},{"$f":"IF(Configurator!T8=0,\"\",Configurator!T8)","v":""}]
[]
[null,null,"Input","Output","2nd\nOutput","SC1 in","SC2 in","SC1 out","SC2 out","SC3 in","SC4 in","SC3 out","SC4 out","+24V","0V","Earth"]
[null,{"$f":"IF('Wiring Requirements'!E5=0,\"\",'Wiring Requirements'!E5)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P5,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q5,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R5,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U5=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U5=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V5=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V5=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W5=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W5=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X5=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X5=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X5=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X5=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E6=0,\"\",'Wiring Requirements'!E6)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P6,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q6,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R6,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U6=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U6=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V6=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V6=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W6=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W6=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X6=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X6=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X6=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X6=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E7=0,\"\",'Wiring Requirements'!E7)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P7,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q7,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R7,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U7=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U7=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V7=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V7=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W7=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W7=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X7=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X7=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X7=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X7=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E8=0,\"\",'Wiring Requirements'!E8)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P8,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q8,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R8,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U8=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U8=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V8=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V8=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W8=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W8=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X8=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X8=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X8=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X8=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E9=0,\"\",'Wiring Requirements'!E9)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P9,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q9,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R9,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U9=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U9=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V9=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V9=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W9=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W9=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X9=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X9=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X9=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X9=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E10=0,\"\",'Wiring Requirements'!E10)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P10,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q10,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R10,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U10=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U10=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V10=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V10=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W10=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W10=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X10=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X10=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X10=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X10=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E11=0,\"\",'Wiring Requirements'!E11)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P11,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q11,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R11,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U11=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U11=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V11=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V11=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W11=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W11=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X11=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X11=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X11=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X11=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E12=0,\"\",'Wiring Requirements'!E12)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P12,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q12,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R12,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U12=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U12=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V12=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V12=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W12=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W12=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X12=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X12=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X12=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X12=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E13=0,\"\",'Wiring Requirements'!E13)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P13,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q13,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R13,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U13=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U13=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V13=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V13=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W13=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W13=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X13=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X13=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X13=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X13=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"IF('Wiring Requirements'!E14=0,\"\",'Wiring Requirements'!E14)","v":""},{"$f":"VLOOKUP('Wiring Requirements'!P14,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!Q14,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('Wiring Requirements'!R14,'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF('Wiring Requirements'!U14=1,VLOOKUP(F$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!U14=1,VLOOKUP(G$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!U14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V14=1,VLOOKUP(H$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!V14=1,VLOOKUP(I$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!V14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W14=1,VLOOKUP(J$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!W14=1,VLOOKUP(K$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!W14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X14=1,VLOOKUP(L$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X14=2,\"******\",\"-\"))","v":"-"},{"$f":"IF('Wiring Requirements'!X14=1,VLOOKUP(M$5,'Wiring Requirements'!$Z$5:$AA$30,2,FALSE),IF('Wiring Requirements'!X14=2,\"******\",\"-\"))","v":"-"}]
[null,{"$f":"'Wiring Requirements'!E15","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"+ 24v\",'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(\"0 v\",'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(\"Earth\",'Wiring Requirements'!$Z$5:$AB$30,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Note: 2nd Output = Anti Clock turn on 3 Pos. Switch"]
[null,"Note: ***** denotes safety element is wired in series to other safety elements"]

{"sheet":"Heads & Actuator","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
["Head",{"$f":"Configurator!M19","v":0}]
[]
[{"$f":"Configurator!M12","v":0},"TAF","THF","Head + Fixed Actuator"]
[{"$f":"Configurator!M13","v":0},"TAH","THH","Head + Hinged Actuator"]
[{"$f":"Configurator!M14","v":0},"TAS","THS","Head + Sliding Actuator"]
[{"$f":"Configurator!M15","v":0},"TEN","THN","Head + Handle Actuator (No red handle)",null,"THE"]
[{"$f":"Configurator!M16","v":0},"TEH ","THE","Head + Handle Actuator"]
[]
[1,{"$f":"VLOOKUP(A10,A4:C8,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A10,A4:C8,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"IF(B2=1,C10,B10)","v":{"$error":"#N/A"}}]
[]
[null,null,{"$f":"IF(Configurator!M18=1,Configurator!D18,IF(Configurator!M17=1,C12,IF(AND(Configurator!M17=0,Configurator!M19=1),Configurator!D19,0)))","v":0}]

{"sheet":"Wiring Requirements","index":3,"n_rows":33,"n_cols":51,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,null,null,null,null,{"$f":"RIGHT(Z4)+1-1","v":0},null,null,null,null,null,null,"List Price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight"]
["Head",{"$f":"Configurator!I8","v":0},null,null,null,"Input","Output","Safety",null,"Input","Std Output","Anti Clock Output","Safety",null,null,"Input","Std Output","Anti Clock Output",null,null,"1&2 in","1&2 out","3&4 in","3&4 out",null,{"$f":"E15","v":0},{"$f":"IF(LEFT(Z4,2)=\"TC\",1,0)","v":0},"Pin",null,null,null,null,null,{"$f":"IF(B4=0,0,VLOOKUP(B4,'List Price'!$B$3:$C$98,2,FALSE))","v":0},null,2,3,4,5,8,9,null,null,null,null,null,null,null,null,null,{"$f":"IF(B4=0,0,VLOOKUP(B4,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[1,{"$f":"Configurator!J8","v":0},"T",{"$f":"B5","v":0},{"$f":"IF(D5=0,0,CONCATENATE(C5,D5))","v":0},{"$f":"IF(E5=0,0,VLOOKUP($E5,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E5=0,0,VLOOKUP($E5,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E5=0,0,VLOOKUP($E5,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,{"$f":"F5","v":0},{"$f":"IF(G5=0,0, IF(G5=1,1, IF(G5=2,1)))","v":0},{"$f":"IF(G5=2,1,0)","v":0},{"$f":"H5","v":0},{"$f":"M5-MROUND(M5,1)","v":0},{"$f":"MAX($P6:R$14)","v":0},{"$f":"IF(J5=1,O5+J5,0)","v":0},{"$f":"IF(K5=1,MAX(O5:P5)+K5,0)","v":0},{"$f":"IF(L5=1,MAX(O5:Q5)+L5,0)","v":0},{"$f":"IF(M5=0,0,M5)","v":0},{"$f":"S5-MROUND(S5,1)","v":0},{"$f":"IF(M5=0,0,IF(N5=0,IF(S5<3,1,0),2))","v":0},{"$f":"IF(M5=0,0,IF(N5=0,IF(S5>3,0,IF(T5=$N$16,1,2)),IF(T5=$N$16,1,2)))","v":0},{"$f":"IF(M5=0,0,IF(S5<3,0,IF(N5=0,1,0)))","v":0},{"$f":"IF(M5=0,0,IF(S5<3,0,IF(N5=0,1,0)))","v":0},null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB5+1,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Z5=0,\"-\",IF($AA$4=1,(HLOOKUP($AA$3,$AJ$4:$AO$23,$AI5,FALSE)),AB5))","v":{"$error":"#N/A"}},1,{"$f":"HLOOKUP($AA$3,$AJ$4:$AO$23,$AI5,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(LEN(AF4)=4,0,IF(AND(OR(B5=\"SS\",B5=\"SM\"),OR(RIGHT(B6,1)=\"L\",RIGHT(B6,1)=\"U\")),CONCATENATE(B5,B6),B5))","v":0},{"$f":"IF(AF5=0,0,CONCATENATE(C5,AF5))","v":0},{"$f":"IF(AG5=0,0,VLOOKUP(AG5,'List Price'!$B$3:$C$98,2,FALSE))","v":0},2,"White","White","BROWN","BROWN","VIOLET","VIOLET",null,null,"White","White","Brown","Brown","Orange","Orange",null,{"$f":"IF(AG5=0,0,VLOOKUP(AG5,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[2,{"$f":"Configurator!K8","v":0},"T",{"$f":"B6","v":0},{"$f":"IF(D6=0,0,CONCATENATE(C6,D6))","v":0},{"$f":"IF(E6=0,0,VLOOKUP($E6,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E6=0,0,VLOOKUP($E6,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E6=0,0,VLOOKUP($E6,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,{"$f":"F6","v":0},{"$f":"IF(G6=0,0, IF(G6=1,1, IF(G6=2,1)))","v":0},0,{"$f":"H6","v":0},{"$f":"M6-MROUND(M6,1)","v":0},{"$f":"MAX($P7:R$14)","v":0},0,0,0,{"$f":"IF(M6=0,0,MAX(S$5:$S5)+M6)","v":0},{"$f":"S6-MROUND(S6,1)","v":0},0,0,{"$f":"IF(M6=0,0,IF(S6<3,0,IF(N6=0,1,0)))","v":0},{"$f":"IF(M6=0,0,IF(S6<3,0,IF(N6=0,1,0)))","v":0},null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB6+1,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(Z6=0,\"-\",IF($AA$4=1,(HLOOKUP($AA$3,$AJ$4:$AO$23,$AI6,FALSE)),AB6))","v":{"$error":"#N/A"}},2,null,null,null,0,{"$f":"IF(AF6=0,0,CONCATENATE(C6,AF6))","v":0},{"$f":"IF(AG6=0,0,VLOOKUP(AG6,'List Price'!$B$3:$C$98,2,FALSE))","v":0},3,"Brown","Brown","BN / WT","BN / WT","RED","RED",null,null,"Brown","Brown","White","White","Pink","Pink",null,{"$f":"IF(AG6=0,0,VLOOKUP(AG6,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[3,{"$f":"Configurator!L8","v":0},"T",0,0,{"$f":"IF(E7=0,0,VLOOKUP($E7,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E7=0,0,VLOOKUP($E7,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E7=0,0,VLOOKUP($E7,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P8:R$14)","v":0},0,0,0,{"$f":"IF(M7=0,0,MAX(S$5:$S6)+M7)","v":0},{"$f":"S7-MROUND(S7,1)","v":0},0,{"$f":"IF(M7=0,0,IF(N7=0,IF(S7>3,0,IF(T7=$N$16,1,2)),IF(T7=$N$16,1,2)))","v":0},0,0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB7+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},3,null,null,null,0,0,{"$f":"IF(AG7=0,0,VLOOKUP(AG7,'List Price'!$B$3:$C$98,2,FALSE))","v":0},4,"Green","Green","BLUE","BLUE","GREY","GREY",null,null,"Green","Green","Blue","Blue","White","White",null,{"$f":"IF(AG7=0,0,VLOOKUP(AG7,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[4,{"$f":"Configurator!M8","v":0},"T",0,0,{"$f":"IF(E8=0,0,VLOOKUP($E8,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E8=0,0,VLOOKUP($E8,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E8=0,0,VLOOKUP($E8,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P9:R$14)","v":0},0,0,0,{"$f":"IF(M8=0,0,MAX(S$5:$S7)+M8)","v":0},{"$f":"S8-MROUND(S8,1)","v":0},0,{"$f":"IF(M8=0,0,IF(N8=0,IF(S8>3,0,IF(T8=$N$16,1,2)),IF(T8=$N$16,1,2)))","v":0},0,0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB8+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},4,null,null,null,0,0,{"$f":"IF(AG8=0,0,VLOOKUP(AG8,'List Price'!$B$3:$C$98,2,FALSE))","v":0},5,"Yellow","Yellow","WHITE","WHITE","RD / BL","RD / BL",null,null,"Yellow","Yellow","Yellow","Violet","Yellow","Yellow",null,{"$f":"IF(AG8=0,0,VLOOKUP(AG8,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[5,{"$f":"Configurator!N8","v":0},"T",0,0,{"$f":"IF(E9=0,0,VLOOKUP($E9,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E9=0,0,VLOOKUP($E9,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E9=0,0,VLOOKUP($E9,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P10:R$14)","v":0},0,0,0,{"$f":"IF(M9=0,0,MAX(S$5:$S8)+M9)","v":0},{"$f":"S9-MROUND(S9,1)","v":0},0,0,0,0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB9+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},5,null,null,null,0,0,{"$f":"IF(AG9=0,0,VLOOKUP(AG9,'List Price'!$B$3:$C$98,2,FALSE))","v":0},6,"Grey","Grey","GREEN","GREEN","GREEN","GREEN",null,null,"Grey","Orange","Orange","Orange","Green","Green",null,{"$f":"IF(AG9=0,0,VLOOKUP(AG9,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[6,{"$f":"Configurator!O8","v":0},"T",0,0,{"$f":"IF(E10=0,0,VLOOKUP($E10,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E10=0,0,VLOOKUP($E10,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E10=0,0,VLOOKUP($E10,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P11:R$14)","v":0},0,0,0,{"$f":"IF(M10=0,0,MAX(S$5:$S9)+M10)","v":0},{"$f":"S10-MROUND(S10,1)","v":0},0,0,0,0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB10+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},6,null,null,null,0,0,{"$f":"IF(AG10=0,0,VLOOKUP(AG10,'List Price'!$B$3:$C$98,2,FALSE))","v":0},7,"Pink","Pink","YELLOW","YELLOW","BLUE","BLUE",null,null,"Pink","Pink","Pink","Pink","Blue","Blue",null,{"$f":"IF(AG10=0,0,VLOOKUP(AG10,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[7,{"$f":"Configurator!P8","v":0},"T",0,0,{"$f":"IF(E11=0,0,VLOOKUP($E11,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E11=0,0,VLOOKUP($E11,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E11=0,0,VLOOKUP($E11,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P12:R$14)","v":0},0,0,0,{"$f":"IF(M11=0,0,MAX(S$5:$S10)+M11)","v":0},0,0,0,{"$f":"IF(M11=0,0,IF(S11<3,0,IF(N11=0,1,0)))","v":0},0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB11+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},7,null,null,null,0,0,{"$f":"IF(AG11=0,0,VLOOKUP(AG11,'List Price'!$B$3:$C$98,2,FALSE))","v":0},8,"Blue","Blue","GREY","GREY","GY / PK","GY / PK",null,null,"Blue","Blue","Grey","Grey","Grey/Pink","Grey/Pink",null,{"$f":"IF(AG11=0,0,VLOOKUP(AG11,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[8,{"$f":"Configurator!Q8","v":0},"T",0,0,{"$f":"IF(E12=0,0,VLOOKUP($E12,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E12=0,0,VLOOKUP($E12,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E12=0,0,VLOOKUP($E12,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P13:R$14)","v":0},0,0,0,{"$f":"IF(M12=0,0,MAX(S$5:$S11)+M12)","v":0},0,{"$f":"IF(M12=0,0,IF(N12=0,IF(S12<3,1,0),2))","v":0},{"$f":"IF(M12=0,0,IF(N12=0,IF(S12>3,0,IF(T12=$N$16,1,2)),IF(T12=$N$16,1,2)))","v":0},{"$f":"IF(M12=0,0,IF(S12<3,0,IF(N12=0,1,0)))","v":0},{"$f":"IF(M12=0,0,IF(S12<3,0,IF(N12=0,1,0)))","v":0},null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB12+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},8,null,null,null,0,0,{"$f":"IF(AG12=0,0,VLOOKUP(AG12,'List Price'!$B$3:$C$98,2,FALSE))","v":0},9,"Red","Red","PINK","PINK","WT / GN","WT / GN",null,null,"Red","Red","Pink","Pink","White/Green","White/Green",null,{"$f":"IF(AG12=0,0,VLOOKUP(AG12,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[9,{"$f":"Configurator!R8","v":0},"T",0,0,{"$f":"IF(E13=0,0,VLOOKUP($E13,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E13=0,0,VLOOKUP($E13,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E13=0,0,VLOOKUP($E13,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,{"$f":"MAX($P$14:R14)","v":0},{"$f":"IF(J13=1,O13+J13,0)","v":0},{"$f":"IF(K13=1,MAX(O13:P13)+K13,0)","v":0},{"$f":"IF(L13=1,MAX(O13:Q13)+L13,0)","v":0},{"$f":"IF(M13=0,0,MAX(S$5:$S12)+M13)","v":0},0,0,0,{"$f":"IF(M13=0,0,IF(S13<3,0,IF(N13=0,1,0)))","v":0},0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB13+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},9,null,null,null,0,0,{"$f":"IF(AG13=0,0,VLOOKUP(AG13,'List Price'!$B$3:$C$98,2,FALSE))","v":0},10,null,null,"RED","RED","WT / YL","WT / YL",null,null,null,null,"Red","Red","White/Yellow","White/Yellow",null,{"$f":"IF(AG13=0,0,VLOOKUP(AG13,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[10,{"$f":"Configurator!S8","v":0},"T",0,0,{"$f":"IF(E14=0,0,VLOOKUP($E14,Configurator!$D$12:$L$118,7,FALSE))","v":0},{"$f":"IF(E14=0,0,VLOOKUP($E14,Configurator!$D$12:$L$118,8,FALSE))","v":0},{"$f":"IF(E14=0,0,VLOOKUP($E14,Configurator!$D$12:$L$118,9,FALSE))","v":0},null,0,0,0,0,0,null,{"$f":"J14","v":0},{"$f":"IF(K14=1,P14+K14,0)","v":0},{"$f":"IF(L14=1,MAX(P14:Q14)+L14,0)","v":0},{"$f":"IF(M14=0,0,MAX(S$5:$S13)+M14)","v":0},0,0,0,{"$f":"IF(M14=0,0,IF(S14<3,0,IF(N14=0,1,0)))","v":0},0,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB14+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},10,null,null,null,0,0,{"$f":"IF(AG14=0,0,VLOOKUP(AG14,'List Price'!$B$3:$C$98,2,FALSE))","v":0},11,null,null,"BLACK","BLACK","WT / GY","WT / GY",null,null,null,null,"Black","Black","White/Grey","White/Grey",null,{"$f":"IF(AG14=0,0,VLOOKUP(AG14,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
["Base",{"$f":"Configurator!T8","v":0},null,null,{"$f":"IF(ISNA(Configurator!T6),0,Configurator!T6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB15+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},11,null,null,null,null,null,{"$f":"IF(E15=0,0,VLOOKUP(E15,'List Price'!$B$3:$C$98,2,FALSE))","v":0},12,null,null,"VIOLET","VIOLET","BLACK","BLACK",null,null,null,null,"Violet","Violet","Black","Black",null,{"$f":"IF(E15=0,0,VLOOKUP(E15,'List Price'!$B$3:$D$98,3,FALSE))","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F14)","v":0},{"$f":"SUM(G5:G14)","v":0},{"$f":"SUM(H5:H14)","v":0},null,null,null,{"$f":"MROUND(M16,1)","v":0},{"$f":"SUM(M5:M15)","v":0},{"$f":"SUM(N5:N14)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB16+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},12,null,null,null,null,null,{"$f":"SUM(AH4:AH15)","v":0},13,null,null,"GN / YL","GN / YL","GN / YL","GN / YL",null,null,null,null,"Green/Yellow","Green/Yellow","Green/Yellow","Green/Yellow",null,{"$f":"SUM(AY4:AY15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB17+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},13,null,null,null,null,null,null,14,null,null,null,null,"YL / BN","YL / BN",null,null,null,null,null,null,"Yellow/Brown","Yellow/Brown"]
[null,null,null,null,null,"Control",{"$f":"G16+F16","v":0},null,null,"nowt",0,null,null,"Head","DU/L","FU/L","Indi e","Series e","Restart",null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB18+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},14,null,null,null,null,null,null,15,null,null,null,null,"BN / GN","BN / GN",null,null,null,null,null,null,"Brown/Green","Brown/Green"]
[null,null,null,null,null,"Safety",{"$f":"MROUND(H16,1)","v":0},null,null,"lookup",1,2,null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB19+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},15,null,null,null,null,null,null,16,null,null,null,null,"WHITE","WHITE",null,null,null,null,null,null,"White","Orange"]
[null,null,null,null,null,null,null,null,null,"*****",2,2,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB20+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},16,null,null,null,null,null,null,17,null,null,null,null,"YELLOW","YELLOW",null,null,null,null,null,null,"Yellow","Pink"]
[null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB21+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},17,null,null,null,null,null,null,18,null,null,null,null,"PINK","PINK",null,null,null,null,null,null,"Pink","White"]
[null,null,null,null,null,null,null,null,null,null,null,2.1,null,1,1,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB22+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},18,null,null,null,null,null,null,19,null,null,null,null,"GY / BN","GY / BN",null,null,null,null,null,null,"Grey/Brown","Yellow"]
[null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,null,1,null,null,null,1,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB23+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},19,null,null,null,null,null,null,20,null,null,null,null,"BROWN","BROWN",null,null,null,null,null,null,"Brown","Brown"]
[null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998,null,1,1,null,null,1,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB24+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},20]
[null,null,null,null,null,null,null,null,null,null,null,4,null,1,null,1,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB25+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},21]
[null,null,null,null,null,null,null,null,null,null,null,4,null,1,null,null,1,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB26+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},22]
[null,null,null,null,null,null,null,null,null,null,null,4,null,1,null,null,null,null,1,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB27+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},23]
[null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,1,null,1,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB28+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},24]
[null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,null,1,1,null,1,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB29+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},25]
[null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,null,1,1,null,null,null,1,null,null,null,null,null,null,{"$f":"HLOOKUP($Z$4,QD!$B$1:$S$27,AB30+1,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},26]
[null,null,null,null,null,null,null,null,null,null,null,4.2,null,1,null,1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,4.2,null,1,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,4.3,null,1,1,null,null,1,1]

{"sheet":"QD","index":4,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,7,19,7]]}
["Part #","TQ1","TQ2","TQ3","TQ4","TQ5","TQ6","TQ7","TQ8","TQ9","TW1","TW2","TW3","TC2","TC3","TC4","TC5","TC8","TC9"]
[null,"SC1 in",1,"SC1 in","+ 24v","+ 24v",4,4,"SC1 in","SC1 in","+ 24v","+ 24v","+ 24v",1,"SC1 in","+ 24v","+ 24v","SC1 in","SC1 in"]
[null,"SC2 in","+ 24v","+ 24v",1,"SC1 in",3,3,"SC2 in","SC2 in","0 v","0 v","0 v","+ 24v","+ 24v",1,"SC1 in","SC2 in","SC2 in"]
[null,"SC1 out","Earth","Earth","0 v","0 v",2,2,"SC1 out","SC1 out","SC1 in",1,"SC1 in","Earth","Earth","0 v","0 v","SC1 out","SC1 out"]
[null,"SC2 out",2,"SC2 in",2,"SC2 in","+ 24v","+ 24v","SC2 out","SC2 out","SC2 in",2,"SC2 in",2,"SC2 in",2,"SC2 in","SC2 out","SC2 out"]
[null,"Earth",3,"SC1 out",3,"SC1 out","SC2 in","SC2 in",1,1,"SC1 out",3,"SC1 out",3,"SC1 out",3,"SC1 out",1,1]
[null,null,4,"SC2 out",4,"SC2 out","0 v","0 v","0 v","0 v","SC2 out",4,"SC2 out",4,"SC2 out",4,"SC2 out","0 v","0 v"]
[null,null,"0 v","0 v",5,1,7,7,2,2,1,5,1,"0 v","0 v",5,1,2,2]
[null,null,5,1,6,2,6,6,3,3,2,6,2,5,1,6,2,3,3]
[null,null,null,null,7,3,5,5,4,4,3,7,3,null,null,7,3,4,4]
[null,null,null,null,8,4,"SC1 in","SC1 in",5,5,4,8,4,null,null,8,4,5,5]
[null,null,null,null,9,5,1,1,6,6,5,9,5,null,null,9,5,6,6]
[null,null,null,null,"Earth","Earth","SC2 out","SC2 out","Earth","Earth",6,10,6,null,null,"Earth","Earth","Earth","Earth"]
[null,null,null,null,null,null,"SC1 out","SC1 out",7,7,"Earth","Earth",7,null,null,null,null,7,7]
[null,null,null,null,null,null,"Earth","Earth",8,8,null,null,8,null,null,null,null,8,8]
[null,null,null,null,null,null,null,"Use TQ7 for stacks with 3 or less push buttons",9,"SC3 in",null,null,9,null,null,null,null,9,"SC3 in"]
[null,null,null,null,null,null,null,null,10,"SC4 in",null,null,10,null,null,null,null,10,"SC4 in"]
[null,null,null,null,null,null,null,null,11,"SC3 out",null,null,11,null,null,null,null,11,"SC3 out"]
[null,null,null,null,null,null,null,null,12,"SC4 out",null,null,12,null,null,null,null,12,"SC4 out"]
[null,null,null,null,null,null,null,null,"+ 24v","+ 24v",null,null,13,null,null,null,null,"+ 24v","+ 24v"]
[null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,"SC3 in"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SC4 in"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SC3 out"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SC4 out"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Earth"]

{"sheet":"List Price","index":5,"n_rows":98,"n_cols":4,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Weight"]
[null,"TAF",null,0.02]
[null,"TAH",null,0.4]
[null,"TAS",null,0.4]
[null,"TEN",null,0.55000000000000004]
[null,"TEH ",null,0.73]
[null,"THC",null,0.11]
[null,"THM",null,0.25]
[null,"THF",null,{"$f":"D3+$D$9","v":0.27}]
[null,"THH",null,{"$f":"D4+$D$9","v":0.65}]
[null,"THS",null,{"$f":"D5+$D$9","v":0.65}]
[null,"THN",null,{"$f":"D6+$D$9","v":0.8}]
[null,"THE",null,{"$f":"D7+$D$9","v":0.98}]
[null,"TRX",null,0.26]
[null,"TRZ",null,0.36]
[null,"TSN",null,0.17]
[null,"TGN",null,0.17]
[null,"TAB",null,0.17]
[null,"TQB",null,0.17]
[null,"TSM",null,0.11]
[null,"TSS",null,0.11]
[null,"TSMDU",null,0.38]
[null,"TSMDL",null,0.38]
[null,"TSSEU",null,0.38]
[null,"TSSEL",null,0.38]
[null,"TSMEU",null,0.38]
[null,"TSMEL",null,0.38]
[null,"TSMFU",null,0.38]
[null,"TSMFL",null,0.38]
[null,"TEC",null,0.09]
[null,"TEW",null,0.09]
[null,"TED",null,0.09]
[null,"TEV",null,0.09]
[null,"TET",null,0.09]
[null,"TEP",null,0.09]
[null,"TEM",null,0.09]
[null,"TEI",null,0.09]
[null,"TSR",null,0.08]
[null,"TEB",null,0.08]
[null,"TP1",null,7.0000000000000007E-2]
[null,"TP2",null,7.0000000000000007E-2]
[null,"TP3",null,7.0000000000000007E-2]
[null,"TP6",null,7.0000000000000007E-2]
[null,"TP7",null,7.0000000000000007E-2]
[null,"TG1",null,7.0000000000000007E-2]
[null,"TG5",null,7.0000000000000007E-2]
[null,"TG3",null,7.0000000000000007E-2]
[null,"TG6",null,7.0000000000000007E-2]
[null,"TG7",null,7.0000000000000007E-2]
[null,"TPB",null,7.0000000000000007E-2]
[null,"TPR",null,7.0000000000000007E-2]
[null,"TPG",null,7.0000000000000007E-2]
[null,"TPW",null,7.0000000000000007E-2]
[null,"TPY",null,7.0000000000000007E-2]
[null,"TPZ",null,7.0000000000000007E-2]
[null,"TGB",null,7.0000000000000007E-2]
[null,"TGR",null,7.0000000000000007E-2]
[null,"TGG",null,7.0000000000000007E-2]
[null,"TGW",null,7.0000000000000007E-2]
[null,"TGY",null,7.0000000000000007E-2]
[null,"TGZ",null,7.0000000000000007E-2]
[null,"TLB",null,7.0000000000000007E-2]
[null,"TLG",null,7.0000000000000007E-2]
[null,"TLR",null,7.0000000000000007E-2]
[null,"TLW",null,7.0000000000000007E-2]
[null,"TLY",null,7.0000000000000007E-2]
[null,"T2E",null,7.0000000000000007E-2]
[null,"T2F",null,7.0000000000000007E-2]
[null,"T2A",null,7.0000000000000007E-2]
[null,"T2D",null,7.0000000000000007E-2]
[null,"TK5",null,0.09]
[null,"TK6",null,0.09]
[null,"T3A",null,7.0000000000000007E-2]
[null,"T3D",null,7.0000000000000007E-2]
[null,"T3E",null,7.0000000000000007E-2]
[null,"T3F",null,7.0000000000000007E-2]
[null,"TBF",null,0.06]
[null,"TQ1",null,7.0000000000000007E-2]
[null,"TQ2",null,7.0000000000000007E-2]
[null,"TQ3",null,7.0000000000000007E-2]
[null,"TQ4",null,0.1]
[null,"TQ5",null,0.1]
[null,"TQ6",null,0.1]
[null,"TQ7",null,0.08]
[null,"TQ8",null,0.13]
[null,"TQ9",null,0.13]
[null,"TW1",null,0.25]
[null,"TW2",null,0.26]
[null,"TW3",null,0.3]
[null,"TC2",null,0.19]
[null,"TC3",null,0.19]
[null,"TC4",null,0.37]
[null,"TC5",null,0.37]
[null,"TC8",null,0.48]
[null,"TC9",null,0.48]
[null,"TKS",null,0.02]
[null,"TKM",null,0.02]