{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["LA typenummer","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"LA typenummer","index":0,"n_rows":4,"n_cols":18,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,0,3,1],[2,8,1048575,12],[2,0,2,7],[3,2,3,7],[4,0,45,7]]}
["Type","Slag (mm)","Kracht (N)","Materiaal","Geluidslevel","Voltage (VDC)","Snelheid (mm/sec)","Kleur","Extra functies","Functie code","Protectieklasse","Ingetrokken lengte (mm)","Neusmontage",null,null,null,"Minimale slag",{"$f":"_xlfn.IFS(Gegevens[Type]=16,20,Gegevens[Type]=26,20,Gegevens[Type]=35,10,Gegevens[Type]=38,20,Gegevens[Type]=52,20)","v":20}]
[38,100,600,"S/S","Low Noise",24,{"$f":"IF(Gegevens[[#This Row],[Geluidslevel]]=\"Normaal\",INDEX(Kracht[Load Speed],MATCH(Gegevens[[#This Row],[Type]],IF(Gegevens[[#This Row],[Kracht (N)]]=Kracht[Kracht],Kracht[Type],0),0)),IF(Gegevens[[#This Row],[Type]]=35,INDEX(Kracht[Load Speed],MATCH(\"35-LN\",IF(Gegevens[[#This Row],[Kracht (N)]]=Kracht[Kracht],Kracht[Type],0),0)),INDEX(Kracht[Load Speed],MATCH(\"38-LN\",IF(Gegevens[[#This Row],[Kracht (N)]]=Kracht[Kracht],Kracht[Type],0),0))))","v":10.5},{"$f":"_xlfn.IFS(Gegevens[[#This Row],[Materiaal]]=\"AL\",\"Zwart\",Gegevens[[#This Row],[Materiaal]]=\"S/S\",\"Zilver\")","v":"Zilver"},"Limit Switch Output Signal",{"$f":"_xlfn.IFS(Gegevens[[#This Row],[Extra functies]]=\"None\",\"N\",Gegevens[[#This Row],[Extra functies]]=\"Limit Switch\",\"LSN\",Gegevens[[#This Row],[Extra functies]]=\"Hall Sensor\",\"H\",Gegevens[[#This Row],[Extra functies]]=\"Over Current Protection\",\"C\",Gegevens[[#This Row],[Extra functies]]=\"Limit Switch + Hall Sensor\", \"LSH\",Gegevens[[#This Row],[Extra functies]]=\"Limit Switch + Over Current Protection\",\"LSC\",Gegevens[[#This Row],[Extra functies]]=\"Limit Switch Output Signal\",\"LSS\")","v":"LSS"},"IP69K",{"$f":"_xlfn.IFS(Gegevens[[#This Row],[Type]]=16,Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(Gegevens[[#This Row],[Type]],IF(Gegevens[[#This Row],[Functie code]]=Lengte[Code],Lengte[Type],0),0)),Gegevens[[#This Row],[Type]]=26,IF(AND(Gegevens[[#This Row],[Kracht (N)]]=100,OR(Gegevens[[#This Row],[Functie code]]=\"LSN\",Gegevens[[#This Row],[Functie code]]=\"LSC\",Gegevens[[#This Row],[Functie code]]=\"LSH\")),\"100N met limit switch is niet mogelijk\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(Gegevens[[#This Row],[Type]],IF(Gegevens[[#This Row],[Functie code]]=Lengte[Code],Lengte[Type],0),0))),Gegevens[[#This Row],[Type]]=35,_xlfn.IFS(Gegevens[Kracht (N)]>800,IF(Gegevens[Geluidslevel]=\"Low Noise\",\"Low Noise niet mogelijk\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(\"35-800\",IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0))),Gegevens[[#This Row],[Kracht (N)]]<=800,IF(Gegevens[Geluidslevel]=\"Low Noise\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(\"35-LN\",IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0)),Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(Gegevens[Type],IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0)))),Gegevens[[#This Row],[Type]]=38,_xlfn.IFS(Gegevens[Kracht (N)]>800,IF(Gegevens[Geluidslevel]=\"Low Noise\",IF(OR(Gegevens[Functie code]=\"LSC\",Gegevens[Functie code]=\"C\"),\"Over Current en Low Noise niet mogelijk\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(\"38-800-LN\",IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0))),Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(\"38-800\",IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0))),Gegevens[Kracht (N)]<=800,IF(Gegevens[Geluidslevel]=\"Low Noise\",IF(OR(Gegevens[Functie code]=\"LSC\",Gegevens[Functie code]=\"C\"),\"Over Current en Low Noise niet mogelijk\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(\"38-LN\",IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0))),Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(Gegevens[Type],IF(Gegevens[Functie code]=Lengte[Code],Lengte[Type],0),0)))),Gegevens[[#This Row],[Type]]=52,IF(AND(Gegevens[[#This Row],[Kracht (N)]]>5000,Gegevens[[#This Row],[Voltage (VDC)]]=12),\"12 VDC en 6000N is niet mogelijk\",Gegevens[[#This Row],[Slag (mm)]]+INDEX(Lengte[Lengte],MATCH(Gegevens[[#This Row],[Type]],IF(Gegevens[[#This Row],[Functie code]]=Lengte[Code],Lengte[Type],0),0))))","v":310},"O-type",null,null,null,"Maximale slag",{"$f":"_xlfn.IFS(Gegevens[Type]=16,100,Gegevens[Type]=26,200,Gegevens[Type]=35,900,Gegevens[Type]=38,500,Gegevens[Type]=52,500)","v":500}]
[{"$f":"IF(AND(Gegevens[Ingetrokken lengte (mm)]>0,Gegevens[Ingetrokken lengte (mm)]<1200),\"LA\" & Gegevens[Type] & \"M-\"& Gegevens[Materiaal] &\"-\" & IF(Gegevens[Geluidslevel]=\"Low Noise\",\"L\",\"N\") & Gegevens[Voltage (VDC)] & \"-\" & Gegevens[Kracht (N)] & \"-\" & Gegevens[Snelheid (mm/sec)] & \"-\" & Gegevens[Slag (mm)] & \"-\" & Gegevens[Functie code]  & \"-\" & _xlfn.IFS(Gegevens[Protectieklasse]=\"IP67M\",\"W\",Gegevens[Protectieklasse]=\"IP66\",\"N\",Gegevens[Protectieklasse]=\"IP69K\",\"K\") & \"-\" & _xlfn.IFS(Gegevens[Neusmontage]=\"O-Type\",\"O\",Gegevens[Neusmontage]=\"Clevis\",\"C\",Gegevens[Neusmontage]=\"Ball Joint\",\"B\",Gegevens[Neusmontage]=\"Universal Joint\",\"U\"),\"Verkeerde selectie\")","v":"LA38M-S/S-L24-600-10,5-100-LSS-K-O"}]
["Typenummer",null,{"$f":"A3","v":"LA38M-S/S-L24-600-10,5-100-LSS-K-O"}]

{"sheet":"Data","index":1,"n_rows":49,"n_cols":24,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Type","Materiaal",null,"Type","Kracht","Load Speed",null,"Type","Geluidslevel",null,"Type","Voltage",null,"Type","Functies","Code",null,"Type","Protectie",null,"Type","Functies","Code","Lengte"]
[16,"AL",null,16,20,10,null,16,"Normaal",null,16,12,null,16,"None","N",null,16,"IP65",null,16,"None","N",100]
[26,"AL",null,16,50,5,null,26,"Normaal",null,26,12,null,16,"Limit Switch","LSN",null,26,"IP66",null,16,"Limit Switch","LSN",100]
[35,"AL",null,26,100,11,null,35,"Normaal",null,26,24,null,26,"None","N",null,35,"IP66",null,26,"None","N",150]
[35,"S/S",null,26,250,"7.5",null,35,"Low Noise",null,35,12,null,26,"Hall Sensor","H",null,35,"IP67M",null,26,"Hall Sensor","H",170]
[38,"AL",null,26,500,"3.8",null,38,"Normaal",null,35,24,null,26,"Over Current Protection","C",null,38,"IP66",null,26,"Over Current","C",170]
[38,"S/S",null,35,100,30,null,38,"Low Noise",null,38,12,null,26,"Limit Switch","LSN",null,38,"IP67M",null,26,"Limit Switch","LSN",165]
[52,"AL",null,35,300,17,null,52,"Normaal",null,38,24,null,26,"Limit Switch + Over Current Protection","LSC",null,38,"IP69K",null,26,"Limit Switch + Hall Sensor","LSH",170]
[52,"S/S",null,35,400,14,null,null,null,null,52,12,null,35,"None","N",null,52,"IP66",null,26,"Limit Switch + Over Current","LSC",170]
[null,null,null,35,600,9,null,null,null,null,52,24,null,35,"Hall Sensor","H",null,52,"IP67M",null,35,"None ≤ 800N","N",178]
[null,null,null,35,800,8,null,null,null,null,null,null,null,35,"Over Current Protection","C",null,null,null,null,"35-800","None > 800N","N",188]
[null,null,null,35,1200,5,null,null,null,null,null,null,null,38,"None","N",null,null,null,null,"35-LN","None + Low Noise ≤ 800N","N",188]
[null,null,null,35,1800,3,null,null,null,null,null,null,null,38,"Limit Switch","LSN",null,null,null,null,35,"Hall Sensor ≤ 800N","H",200]
[null,null,null,35,2300,"2.5",null,null,null,null,null,null,null,38,"Hall Sensor","H",null,null,null,null,"35-800","Hall Sensor > 800N","H",208]
[null,null,null,38,100,30,null,null,null,null,null,null,null,38,"Over Current Protection","C",null,null,null,null,"35-LN","Hall Sensor + Low Noise ≤ 800N","H",200]
[null,null,null,38,300,17,null,null,null,null,null,null,null,38,"Limit Switch + Hall Sensor","LSH",null,null,null,null,35,"Over Current ≤ 800N","C",200]
[null,null,null,38,400,14,null,null,null,null,null,null,null,38,"Limit Switch + Over Current Protection","LSC",null,null,null,null,"35-800","Over Current > 800N","C",208]
[null,null,null,38,600,9,null,null,null,null,null,null,null,38,"Limit Switch Output Signal","LSS",null,null,null,null,"35-LN","Over Current + Low Noise","C",208]
[null,null,null,38,800,8,null,null,null,null,null,null,null,52,"None","N",null,null,null,null,38,"None ≤ 800N","N",200]
[null,null,null,38,1200,5,null,null,null,null,null,null,null,52,"Limit Switch","LSN",null,null,null,null,"38-800","None > 800N","N",210]
[null,null,null,38,1800,3,null,null,null,null,null,null,null,52,"Hall Sensor","H",null,null,null,null,"38-LN","None + Low Noise ≤ 800N","N",210]
[null,null,null,38,2300,"2.5",null,null,null,null,null,null,null,52,"Over Current Protection","C",null,null,null,null,"38-800-LN","None + Low Noise > 800N","N",220]
[null,null,null,"35-LN",100,23,null,null,null,null,null,null,null,52,"Limit Switch + Hall Sensor","LSH",null,null,null,null,38,"Limit Switch ≤ 800N","LSN",200]
[null,null,null,"35-LN",300,20,null,null,null,null,null,null,null,52,"Limit Switch + Over Current Protection","LSC",null,null,null,null,"38-800","Limit Switch > 800N","LSN",210]
[null,null,null,"35-LN",400,14,null,null,null,null,null,null,null,52,"Limit Switch Output Signal","LSS",null,null,null,null,"38-LN","Limit Switch + Low Noise ≤ 800N","LSN",210]
[null,null,null,"35-LN",600,10.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800-LN","Limit Switch + Low Noise > 800N","LSN",220]
[null,null,null,"35-LN",800,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Limit Switch ≤ 800N + output signal","LSS",200]
[null,null,null,"35-LN",1200,4.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800","Limit Switch > 800N + output signal","LSS",210]
[null,null,null,"35-LN",1800,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-LN","Limit Switch + Low Noise ≤ 800N + output signal","LSS",210]
[null,null,null,"35-LN",2300,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800-LN","Limit Switch + Low Noise > 800N + output signal","LSS",220]
[null,null,null,"38-LN",100,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Hall Sensor ≤ 800N","H",220]
[null,null,null,"38-LN",300,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-LN","Hall Sensor ≤ 800N","H",220]
[null,null,null,"38-LN",400,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800","Hall Sensor > 800N","H",230]
[null,null,null,"38-LN",600,10.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800-LN","Hall Sensor + Low Noise > 800N","H",230]
[null,null,null,"38-LN",800,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Over Current ≤ 800N","C",220]
[null,null,null,"38-LN",1200,4.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800","Over Current > 800N","C",230]
[null,null,null,"38-LN",1800,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Limit Switch + Hall Sensor ≤ 800N","LSH",220]
[null,null,null,"38-LN",2300,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800","Limit Switch + Hall Sensor  > 800N","LSH",220]
[null,null,null,52,300,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-LN","Limit Switch + Hall Sensor + Low Noise ≤ 800N","LSH",220]
[null,null,null,52,1200,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800-LN","Limit Switch + Hall Sensor + Low Noise > 800N","LSH",230]
[null,null,null,52,1800,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Limit Switch + Over Current ≤ 800N","LSC",220]
[null,null,null,52,3000,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38-800","Limit Switch + Over Current  > 800N","LSC",230]
[null,null,null,52,4500,4.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"None","N",305]
[null,null,null,52,5000,3.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Limit Switch","LSN",305]
[null,null,null,52,6000,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Limit Switch + output signal","LSS",305]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Hall Sensor","H",325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Over Current","C",325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Limit Switch + Hall Sensor","LSH",325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"Limit Switch + Hall Sensor","LSC",325]