{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["CopyPaste","Merkmalsausprägung","Makro-Info","Eingabe","Einstellungen","Zeichnung","Artikelstamm","Berechnung","Text - Sprache","Übergabe","PSIPENTA"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":4,"comments":6,"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":"CopyPaste","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Merkmalsausprägung","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"'Text - Sprache'!D5&\" => ' OK ' => \"&'Text - Sprache'!E5&\":\"","v":"Eingabe => ' OK ' => Ergebnis:"},892,{"$f":"LEFT(Berechnung!E44,1)","v":"1"},{"$f":"RIGHT(Berechnung!E44,1)","v":"7"},{"$f":"LEFT(Berechnung!E103,1)","v":"7"},{"$f":"RIGHT(Berechnung!E103,1)","v":"1"},{"$f":"Berechnung!E36","v":18},"L",{"$f":"Berechnung!C20","v":495},{"$f":"Berechnung!E53","v":"R"},{"$f":"IF(L2=\"\",\"\",\"G\")","v":""},{"$f":"MID(Berechnung!E58,2,2)","v":""},{"$f":"IF(N2=\"\",\"\",\"H\")","v":""},{"$f":"MID(Berechnung!E68,2,4)","v":""},{"$f":"Berechnung!E32","v":""}]
[{"$f":"'Text - Sprache'!D5&\":\"","v":"Eingabe:"},892,"#","#","#","#","##","L","####","#","G","##","H","####","#",null,null,null,"Spalte"]
[null,null,"*","*","*","*","*",null,"*","*",null,null,null,null,null,null,null,"1. Länge","I",{"$f":"IF(I3=\"####\",\"#\",I3)","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Kug/Rol-Leiste","D",{"$f":"IF(OR(D3=5,D3=6),2,IF(OR(D3=7,D3=8),1,\"#\"))","v":"#"}]
[null,null,null,null,null,null,null,null,{"$f":"\"* = \"&'Text - Sprache'!E77","v":"* = Pflichtfelder"},null,null,null,null,null,null,null,null,"2.1 Rollenausr.","O",{"$f":"IF(O3=\"X\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Nutbreite","G",{"$f":"IF(G3=18,1,IF(G3=22,2,IF(G3=28,3,IF(G3=36,4,IF(G3=13,5,IF(G3=17,6,\"#\"))))))","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Betätigung","D",{"$f":"IF(OR(D3=5,D3=7),1,IF(OR(D3=6,D3=8),2,\"#\"))","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Hub","C",{"$f":"IF(C3=1,C3,IF(C3=2,C3,\"#\"))","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6. Befestigung","J",{"$f":"IF(OR(J3=\"R\",J3=\"S\"),1,IF(J3=\"K\",2,\"#\"))","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7. Abst.Einsatz","L",{"$f":"IF(OR(L3=\"##\",L3=\"\",L3=\" \"),Berechnung!C63,U11)","v":50},{"$f":"Berechnung!C60-L3+Berechnung!C63","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8. Nuttiefe","N",{"$f":"IF(OR(N3=\"####\",N3=\"\",N3=\" \"),Berechnung!C79,U12)","v":300},{"$f":"(Berechnung!C75-N3)*10+Berechnung!C79","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.1 Druck","D",{"$f":"IF(D3=7,Artikelstamm!AC8,IF(D3=5,Artikelstamm!AC20,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.2 Temperatur","E",{"$f":"IF(OR(E3=6,E3=7),Artikelstamm!E39,IF(E3=5,Artikelstamm!E40,IF(E3=4,Artikelstamm!E41,\"#\")))","v":"#"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9.3 Material","E",{"$f":"IF(OR(E3=4,E3=5,E3=6),2,IF(E3=7,1,\"#\"))","v":"#"}]

{"sheet":"Makro-Info","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"'Text - Sprache'!F77","v":"ACHTUNG"}]
[null,{"$f":"'Text - Sprache'!G77","v":"Diese Datei enthält Makros! Die Ausführung von Makros wird jedoch verhindert! Bitte stellen Sie sicher, dass Makros ausgeführt werden können!"}]
[]
[null,{"$f":"IF(Berechnung!C7=2,\"\",'Text - Sprache'!F80)","v":"ATTENTION"}]
[null,{"$f":"IF(Berechnung!C7=2,\"\",'Text - Sprache'!G80)","v":"This file contains macros! The execution of macros is prevented! Please make sure that macros can be executed!"}]

{"sheet":"Eingabe","index":3,"n_rows":281,"n_cols":17,"rows_kept":281,"cut":false,"hidden":true,"merged":[[42,6,42,9],[40,6,41,9],[43,6,43,9],[24,12,25,12],[24,9,26,9],[39,12,41,12],[36,6,36,9],[37,7,38,7],[37,6,38,6],[44,11,48,12],[10,12,10,13],[39,13,41,13],[44,13,48,14],[43,13,43,14],[24,13,25,13],[14,2,14,5],[20,3,21,4],[22,6,22,7],[19,2,19,5],[1,5,1,6],[1,7,1,12],[19,6,20,6],[2,13,2,14],[3,13,3,14],[4,13,4,14],[7,2,7,9],[10,2,10,3],[39,14,41,15],[24,14,25,14],[32,6,34,9],[29,6,30,6],[29,7,30,7],[44,15,48,15],[3,12,4,12],[15,13,16,14],[32,13,34,14],[10,14,10,15],[12,12,13,15],[30,15,31,15],[32,15,34,15],[32,12,34,12],[15,12,16,12]]}
[60459]
[19571,null,{"$f":"'Text - Sprache'!C5&\": \"&'Text - Sprache'!J23","v":"Auswahl: Sprache"}]
[51457,null,{"$f":"Einstellungen!$B$6","v":0},"Info Vorzugslängen"]
[71881,null,{"$f":"Einstellungen!$B$8","v":0},"Verkaufspreis"]
[31109,null,{"$f":"Einstellungen!$B$10","v":true},"Optionen/vergr.Hub",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Einstellungen!E2","v":"18042017"}]
[85670,null,{"$f":"IF(Einstellungen!B12=TRUE,1,0)","v":0},"PDF/Penta"]
[44003]
[46707,null,{"$f":"'Text - Sprache'!D5&\" \"&'Text - Sprache'!F5&\" / \"&'Text - Sprache'!G5&\" :    1.  =>  9.\"","v":"Eingabe Kugelleiste / Rollenleiste :    1.  =>  9."},null,null,null,null,null,null,null,null,null,{"$f":"'Text - Sprache'!E5&\": \"&Berechnung!D28","v":"Ergebnis: Kugelleiste"},null,null,{"$f":"TODAY()","v":"2017-04-18"}]
[74234]
[78489,null,{"$f":"\"1. \"&'Text - Sprache'!D5&\": \"&'Text - Sprache'!R5","v":"1. Eingabe: gewünschte Leistenlänge"},null,null,null,{"$f":"\"7. \"&'Text - Sprache'!C5&\": \"&Berechnung!C58","v":"7. Auswahl: Kugelabstand"},null,null,null,null,null,{"$f":"'Text - Sprache'!Q59&\":\"","v":"Merkmalsausprägung:"}]
[23968,null,500,null,"mm",null,{"$f":"Berechnung!D58&\" mm\"","v":"30 mm"},"+",{"$f":"Berechnung!C64","v":50},null,null,null,{"$f":"Berechnung!D5&Berechnung!E5","v":"892177118L495R"}]
[56545,null,{"$f":"Berechnung!D24","v":2925},"mm max.",null,null,{"$f":"Berechnung!C61&\" mm max.\"","v":"60 mm max."},null,{"$f":"Berechnung!C63","v":50},null,null,null,{"$f":"'Text - Sprache'!C41&\":\"","v":"Gehäusematerial:"},{"$f":"Berechnung!D103","v":"Aluminium"}]
[20526,null,{"$f":"Berechnung!D23","v":105},"mm min.",null,null,{"$f":"Berechnung!C60&\" mm Standard\"","v":"30 mm Standard"},null,{"$f":"Berechnung!D58","v":30},null,null,null,{"$f":"Berechnung!D28&\", \"&Berechnung!D44&IF(AND(Berechnung!C69=TRUE,Berechnung!C71=TRUE),\" (\"&'Text - Sprache'!M23&\" \"&'Text - Sprache'!L23&\")\",\"\")","v":"Kugelleiste, hydraulisch"}]
[37195,null,null,null,null,null,{"$f":"Berechnung!C59&\" mm min.\"","v":"20 mm min."},null,{"$f":"Berechnung!C60","v":30}]
[80102,null,{"$f":"\"2. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!F5&\" / \"&'Text - Sprache'!G5","v":"2. Auswahl: Kugelleiste / Rollenleiste"},null,null,null,null,"- ",null,null,null,null,{"$f":"'Text - Sprache'!K23","v":"Rollenausrichtung"},{"$f":"Berechnung!D32","v":"0°"}]
[16391,null,null,{"$f":"Berechnung!C28","v":1},null,null,null,null,null,null,null,null,{"$f":"'Text - Sprache'!K5&\":\"","v":"Befestigung:"},{"$f":"Berechnung!D53","v":"Riegel"}]
[81248,null,null,{"$f":"Berechnung!C32","v":false}]
[59254]
[26253,null,null,null,null,null,{"$f":"\"8. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!P5","v":"8. Auswahl: Nuttiefe"},null,null,null,null,null,{"$f":"'Text - Sprache'!O5&\":\"","v":"Nutbreite:"},{"$f":"Artikelstamm!G6","v":18},{"$f":"ROUND(Artikelstamm!G6*0.039369964,3)&\" in\"","v":"0,709 in"}]
[65948,null,{"$f":"\"2.1 \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!K23&\" 0° / 90°\"","v":"2.1 Auswahl: Rollenausrichtung 0° / 90°"},null,null,null,{"$f":"Berechnung!D68&\" mm\"","v":"30 mm"},"+",{"$f":"Berechnung!C80","v":300},null,null,null,{"$f":"'Text - Sprache'!P5&\":\"","v":"Nuttiefe:"},{"$f":"Berechnung!D68","v":30},{"$f":"ROUND(Berechnung!D68*0.039369964,3)&\" in\"","v":"1,181 in"}]
[93538,null,null,{"$f":"'Text - Sprache'!K23&\" \"&Berechnung!D32","v":"Rollenausrichtung 0°"},null,null,null,null,{"$f":"Berechnung!C79","v":300},null,null,null,{"$f":"'Text - Sprache'!Q5&\":\"","v":"Leistenlänge:"},{"$f":"Berechnung!D20","v":498.5},{"$f":"ROUND(Berechnung!D20*0.039369964,3)&\" in\"","v":"19,626 in"},{"$f":"\"(\"&'Text - Sprache'!H41&\" \"&Artikelstamm!AL6&\" mm \"&'Text - Sprache'!I41&\")\"","v":"(inkl. 3,5 mm Verschlussschraube)"}]
[64497,null,null,null,null,null,null,null,{"$f":"Berechnung!D68","v":30}]
[9182,null,null,null,null,null,{"$f":"Berechnung!C76&\" mm max. \"&IF(AND(Berechnung!C103=1,Einstellungen!B10=TRUE),\"(\"&Artikelstamm!AH6&\" mm \"&Berechnung!B105&\")\",\"\")","v":"30 mm max. (45 mm Stahl)"},null,{"$f":"Berechnung!C75","v":30},{"$f":"OR(Berechnung!D70=TRUE,AND(Berechnung!C28=1,Berechnung!C44=2,Berechnung!E36=36))","v":false},null,null,{"$f":"Berechnung!C58&\":\"","v":"Kugelabstand:"},{"$f":"Berechnung!D58","v":30},{"$f":"ROUND(Berechnung!D58*0.039369964,3)&\" in\"","v":"1,181 in"}]
[46189,null,{"$f":"\"3. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!O5","v":"3. Auswahl: Nutbreite"},null,null,null,{"$f":"Berechnung!C75&\" mm Standard\"","v":"30 mm Standard"},null,null,{"$f":"'Text - Sprache'!M23","v":"Variante mit"},null,null,{"$f":"Berechnung!C110&\":\"","v":"Kugeleinsatz:"},{"$f":"Berechnung!D114","v":16}]
[90729,null,null,null,null,null,{"$f":"Berechnung!C74&\" \"&Berechnung!D72&\" mm min.\"","v":"29,5  mm min."},"- ",null,{"$f":"'Text - Sprache'!L23&\"!\"","v":"Tellerfedern!"},null,null,{"$f":"'Text - Sprache'!C23&\":\"","v":"Hub:"},{"$f":"Berechnung!D48","v":1},{"$f":"ROUND(Berechnung!D48*0.039369964,3)&\" in\"","v":"0,039 in"}]
[84180,null,null,{"$f":"Berechnung!C36","v":1}]
[41370]
[920,null,null,null,null,null,{"$f":"\"9. \"&'Text - Sprache'!R23","v":"9. Optionen"},{"$f":"\"9.2+9.3 \"&'Text - Sprache'!P41","v":"9.2+9.3 nicht verfügbar"},null,null,null,null,{"$f":"'Text - Sprache'!H23&\":\"","v":"Tragkraft pro Einsatz:"},{"$f":"Berechnung!C130","v":0.79},{"$f":"ROUND(Berechnung!C130*224.8089,1)&\" lbf\"","v":"177,6 lbf"},{"$f":"\"( \"&ROUND(Berechnung!C130*1000/9.81,1)&\" kg / \"&ROUND(Berechnung!C130*1000/9.81*2.20462,1)&\" lb. )\"","v":"( 80,5 kg / 177,5 lb. )"}]
[97655,null,null,null,null,null,{"$f":"\"9.1 \"&'Text - Sprache'!D5&\": \"&'Text - Sprache'!N23","v":"9.1 Eingabe: Betriebsdruck"},null,null,null,null,null,{"$f":"'Text - Sprache'!I23&\":\"","v":"Gesamttragkraft:"},{"$f":"Berechnung!C131","v":12.64},{"$f":"ROUND(Berechnung!C131*224.8089,1)&\" lbf\"","v":"2841,6 lbf"},{"$f":"\"( \"&ROUND(Berechnung!C131*1000/9.81,0)&\" kg / \"&ROUND(Berechnung!C131*1000/9.81*2.20462,0)&\" lb. )\"","v":"( 1288 kg / 2841 lb. )"}]
[75046,null,null,null,null,null,100,"bar",null,{"$f":"Artikelstamm!AC6","v":100},null,null,{"$f":"'Text - Sprache'!L41&\":\"","v":"Ölbedarf:"},{"$f":"Berechnung!D133","v":1.6},{"$f":"ROUND(Berechnung!D133*0.06102374,4)&\" in³\"","v":"0,0976 in³"}]
[58834,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Text - Sprache'!N23&\":\"","v":"Betriebsdruck:"},{"$f":"Berechnung!D84","v":100},{"$f":"ROUND(Berechnung!D84*14.50377,0)&\" PSI\"","v":"1450 PSI"},{"$f":"'Text - Sprache'!J41&\" \"&Berechnung!D86&\" bar \"&'Text - Sprache'!K41&\"!\"","v":"reduzierter Betriebsdruck  bar empfohlen!"}]
[3339,null,{"$f":"\"4. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!H5","v":"4. Auswahl: Betätigungsart"},null,null,null,{"$f":"Artikelstamm!AC6&\" bar max. (= Standard)\"","v":"100 bar max. (= Standard)"},null,null,{"$f":"Berechnung!C84","v":true},null,null,{"$f":"'Text - Sprache'!G41&\":\"","v":"Anschlussgewinde:"},{"$f":"Artikelstamm!AB6","v":"G1/8"}]
[50968,null,null,null,null,null,{"$f":"'Text - Sprache'!O23","v":"Druck zu hoch!"},null,null,null,null,null,{"$f":"\"max. \"&'Text - Sprache'!P23&\":\"","v":"max. Einsatztemperatur:"},{"$f":"Berechnung!C89","v":"100 °C"},null,{"$f":"IF(Berechnung!C96=0,\"\",ROUND(Berechnung!C96*1.8+32,3)&\" °F\")","v":"212 °F"}]
[58392,null,null,{"$f":"Berechnung!C44","v":1}]
[3937]
[7604]
[44449,null,{"$f":"\"5. \"&'Text - Sprache'!P41","v":"5. nicht verfügbar"},null,null,null,{"$f":"\"9.2 \"&'Text - Sprache'!D5&\": \"&'Text - Sprache'!P23","v":"9.2 Eingabe: Einsatztemperatur"},null,null,null,null,null,{"$f":"'Text - Sprache'!F41&\":\"","v":"Kolbendichtung:"},{"$f":"Berechnung!C98","v":"NBR"}]
[84126,null,{"$f":"\"5. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!C23&\" (mm)\"","v":"5. Auswahl: Hub (mm)"},null,null,null,100,"°C",null,{"$f":"Artikelstamm!E39","v":100},null,null,{"$f":"'Text - Sprache'!M41&\" / \"&Berechnung!D28&\":\"","v":"Masse / Kugelleiste:"},{"$f":"\"ca. \"&Berechnung!D138&\" kg\"","v":"ca. 0,9 kg"},{"$f":"ROUND(Berechnung!D138*2.20462,3)&\" lb.\"","v":"1,984 lb."}]
[33206,null,null,null,null,null,null,null,null,{"$f":"Berechnung!D97","v":false}]
[25389]
[99320,null,null,{"$f":"Berechnung!C48","v":1},null,null,{"$f":"Artikelstamm!E37&\" -\"&Artikelstamm!E39&\" °C Standard\"&\" / \"&Artikelstamm!E41&\" °C max.\"","v":"0 -100 °C Standard / 250 °C max."}]
[19832]
[50136,null,null,null,null,null,{"$f":"'Text - Sprache'!Q23&\"!\"","v":"unzulässige Temperatur!"}]
[27454,null,{"$f":"\"6. \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!K5","v":"6. Auswahl: Befestigung"},null,null,null,{"$f":"\"9.3 \"&'Text - Sprache'!C5&\": \"&'Text - Sprache'!C41","v":"9.3 Auswahl: Gehäusematerial"}]
[59556]
[64832,null,null,{"$f":"Berechnung!C53","v":1},null,null,null,null,{"$f":"Berechnung!C103","v":1}]
[63011,null,null,null,null,null,null,null,{"$f":"OR(G38>J38,I46=2)","v":false}]
[70201]
[12199]
[89250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Einstellungen!A1","v":0}]
[67711]
[47239]
[32672]
[98073]
[55526]
[65948]
[55085]
[20212]
[45969]
[49039]
[67557]
[22568]
[44587]
[61117]
[32519]
[49094]
[25778]
[60245]
[32033]
[84853]
[40596]
[74506]
[38103]
[45085]
[49571]
[3564]
[7985]
[89271]
[80516]
[45227]
[4504]
[60188]
[11341]
[47012]
[41361]
[47981]
[77870]
[82704]
[53450]
[79218]
[6646]
[53920]
[92170]
[30955]
[72748]
[16673]
[45734]
[69800]
[82604]
[32931]
[84484]
[15975]
[81801]
[47182]
[31207]
[32375]
[87897]
[87999]
[56439]
[38636]
[48240]
[94594]
[98786]
[50194]
[22770]
[68391]
[10231]
[42348]
[91841]
[49582]
[26449]
[39322]
[89028]
[18689]
[62120]
[28330]
[58942]
[23132]
[31239]
[98636]
[40041]
[28785]
[92429]
[5617]
[72443]
[96543]
[19257]
[59826]
[30740]
[83883]
[95542]
[41053]
[81808]
[71427]
[35670]
[37392]
[67621]
[14502]
[29907]
[9298]
[13062]
[19707]
[14707]
[78651]
[58739]
[46471]
[68032]
[42820]
[18792]
[33620]
[29659]
[13727]
[63713]
[50933]
[46492]
[81905]
[28150]
[75714]
[42879]
[5563]
[43725]
[94344]
[15920]
[24647]
[96847]
[28851]
[55782]
[99908]
[11520]
[88469]
[91013]
[76955]
[57159]
[46204]
[58849]
[75327]
[81403]
[40391]
[532]
[2550]
[67925]
[1260]
[81619]
[93198]
[19245]
[2501]
[37298]
[72964]
[64544]
[37819]
[42696]
[47711]
[92476]
[22504]
[8197]
[17543]
[8980]
[19990]
[99747]
[15866]
[20092]
[93418]
[84175]
[73446]
[39758]
[82198]
[99499]
[7478]
[22647]
[3573]
[50243]
[35643]
[21965]
[79180]
[27744]
[15174]
[72263]
[86612]
[55472]
[6918]
[97252]
[35983]
[59336]
[64395]
[42619]
[71489]
[62998]
[47865]
[33833]
[97970]
[8189]
[63391]
[58961]
[32473]
[18]
[26895]
[76482]
[80814]
[77283]
[53227]
[48095]
[39143]
[7791]
[70226]
[96537]
[20502]
[8659]
[57780]
[88391]
[6392]
[91639]
[11892]
[41899]
[23332]
[33421]
[33740]
[59779]
[44425]
[70949]
[43740]
[87031]
[15916]
[21734]
[20608]
[93754]
[8760]
[29166]
[65426]
[82957]
[95178]
[32826]

{"sheet":"Einstellungen","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":true,"merged":[[14,1,14,2],[34,0,34,1],[33,0,33,1],[34,2,34,6],[35,0,35,1],[35,2,35,6],[37,0,37,1],[37,2,37,6],[36,0,36,1],[36,2,36,6],[41,0,41,1],[41,2,41,6],[38,0,38,1],[38,2,38,6],[42,0,42,1],[42,2,42,6],[39,0,39,1],[39,2,39,6],[40,0,40,1],[40,2,40,6],[45,0,45,1],[45,2,45,6],[46,0,46,1],[46,2,46,6],[43,0,43,1],[43,2,43,6],[44,0,44,1],[44,2,44,6],[49,0,49,1],[49,2,49,6],[50,0,50,1],[50,2,50,6],[47,0,47,1],[47,2,47,6],[48,0,48,1],[48,2,48,6],[53,0,53,1],[53,2,53,6],[54,0,54,1],[54,2,54,6],[51,0,51,1],[51,2,51,6],[52,0,52,1],[52,2,52,6],[57,0,57,1],[57,2,57,6],[58,0,58,1],[58,2,58,6],[55,0,55,1],[55,2,55,6],[56,0,56,1],[56,2,56,6],[61,0,61,1],[61,2,61,6],[62,0,62,1],[62,2,62,6],[59,0,59,1],[59,2,59,6],[60,0,60,1],[60,2,60,6],[65,0,65,1],[65,2,65,6],[66,0,66,1],[66,2,66,6],[63,0,63,1],[63,2,63,6],[64,0,64,1],[64,2,64,6],[69,0,69,1],[69,2,69,6],[70,0,70,1],[70,2,70,6],[67,0,67,1],[67,2,67,6],[68,0,68,1],[68,2,68,6],[73,0,73,1],[73,2,73,6],[74,0,74,1],[74,2,74,6],[71,0,71,1],[71,2,71,6],[72,0,72,1],[72,2,72,6],[77,0,77,1],[77,2,77,6],[78,0,78,1],[78,2,78,6],[75,0,75,1],[75,2,75,6],[76,0,76,1],[76,2,76,6],[81,0,81,1],[81,2,81,6],[82,0,82,1],[82,2,82,6],[79,0,79,1],[79,2,79,6],[80,0,80,1],[80,2,80,6],[85,0,85,1],[85,2,85,6],[86,0,86,1],[86,2,86,6],[83,0,83,1],[83,2,83,6],[84,0,84,1],[84,2,84,6],[89,0,89,1],[89,2,89,6],[90,0,90,1],[90,2,90,6],[87,0,87,1],[87,2,87,6],[88,0,88,1],[88,2,88,6],[93,0,93,1],[93,2,93,6],[94,0,94,1],[94,2,94,6],[91,0,91,1],[91,2,91,6],[92,0,92,1],[92,2,92,6],[97,0,97,1],[97,2,97,6],[98,0,98,1],[98,2,98,6],[95,0,95,1],[95,2,95,6],[96,0,96,1],[96,2,96,6],[101,0,101,1],[101,2,101,6],[102,0,102,1],[102,2,102,6],[99,0,99,1],[99,2,99,6],[100,0,100,1],[100,2,100,6],[105,0,105,1],[105,2,105,6],[106,0,106,1],[106,2,106,6],[103,0,103,1],[103,2,103,6],[104,0,104,1],[104,2,104,6],[109,0,109,1],[109,2,109,6],[110,0,110,1],[110,2,110,6],[107,0,107,1],[107,2,107,6],[108,0,108,1],[108,2,108,6],[113,0,113,1],[113,2,113,6],[114,0,114,1],[114,2,114,6],[111,0,111,1],[111,2,111,6],[112,0,112,1],[112,2,112,6],[117,0,117,1],[117,2,117,6],[118,0,118,1],[118,2,118,6],[115,0,115,1],[115,2,115,6],[116,0,116,1],[116,2,116,6],[121,0,121,1],[121,2,121,6],[122,0,122,1],[122,2,122,6],[119,0,119,1],[119,2,119,6],[120,0,120,1],[120,2,120,6],[125,0,125,1],[125,2,125,6],[126,0,126,1],[126,2,126,6],[123,0,123,1],[123,2,123,6],[124,0,124,1],[124,2,124,6],[129,0,129,1],[129,2,129,6],[130,0,130,1],[130,2,130,6],[127,0,127,1],[127,2,127,6],[128,0,128,1],[128,2,128,6],[133,0,133,1],[133,2,133,6],[134,0,134,1],[134,2,134,6],[131,0,131,1],[131,2,131,6],[132,0,132,1],[132,2,132,6],[137,0,137,1],[137,2,137,6],[138,0,138,1],[138,2,138,6],[135,0,135,1],[135,2,135,6],[136,0,136,1],[136,2,136,6],[141,0,141,1],[141,2,141,6],[142,0,142,1],[142,2,142,6],[139,0,139,1],[139,2,139,6],[140,0,140,1],[140,2,140,6],[145,0,145,1],[145,2,145,6],[146,0,146,1],[146,2,146,6],[143,0,143,1],[143,2,143,6],[144,0,144,1],[144,2,144,6],[149,0,149,1],[149,2,149,6],[147,0,147,1],[147,2,147,6],[148,0,148,1],[148,2,148,6]]}
[null,{"$f":"IF(Eingabe!M4=0,\"name\",Eingabe!M4)","v":"name"}]
[null,"Einstellungen",null,"Stand","18042017"]
[null,null,null,null,null,null,"Bennennung","aktuell"]
[null,null,null,null,null,null,"1. Leistenlänge",{"$f":"PSIPENTA!F4","v":500}]
[null,null,null,null,null,null,"2. Auswahl Kugel- / Rollenleiste",{"$f":"PSIPENTA!F5","v":1}]
[null,null,null,null,null,null,"2.1 Rollenausrichtung",{"$f":"PSIPENTA!F6","v":false}]
[null,null,null,null,null,null,"3. Nutbreite",{"$f":"PSIPENTA!F7","v":1}]
[null,null,null,null,null,null,"4. Betätigungsart",{"$f":"PSIPENTA!F8","v":1}]
[null,null,null,null,null,null,"5. Hub",{"$f":"PSIPENTA!F9","v":1}]
["3.",true,null,null,null,null,"6. Befestigung",{"$f":"PSIPENTA!F10","v":1}]
[null,null,null,null,null,null,"7. Abstand Einsätze",{"$f":"PSIPENTA!F11","v":50}]
[null,null,null,null,null,null,"8. Nuttiefe",{"$f":"PSIPENTA!F12","v":300}]
[null,null,null,null,null,null,"9.1 Betriebsdruck",{"$f":"PSIPENTA!F13","v":100}]
[null,null,null,null,null,null,"9.2 Einsatztemperatur",{"$f":"PSIPENTA!F14","v":100}]
[null,null,null,null,null,null,"9.3 Gehäusematerial",{"$f":"PSIPENTA!F15","v":1}]
[null,null,null,null,null,null,"Basismusternummer",{"$f":"PSIPENTA!F16","v":""}]
[null,null,null,null,null,null,"Konfigurationszeitstempel TT.MM.JJJJ hh:mm:ss",{"$f":"PSIPENTA!F17","v":0}]
[null,null,null,null,null,null,"PDF-Zeichnungen erzeugt?",{"$f":"PSIPENTA!F18","v":""}]
[null,null,null,null,null,null,"Grundpreis Basismuster",{"$f":"PSIPENTA!F19","v":100}]
[null,null,null,null,null,null,"Rabattgruppe Basismuster",{"$f":"PSIPENTA!F20","v":"K"}]
[null,null,null,null,null,null,"Zu- / Abschlag aus Rabattgruppe",{"$f":"PSIPENTA!F21","v":0}]
[null,null,null,null,null,null,"Status",{"$f":"PSIPENTA!F22","v":2}]
[null,null,null,null,null,null,"Anwender aktuell",{"$f":"PSIPENTA!F23","v":""}]
[null,null,null,null,null,null,"Bearbeiter Konfiguration aus PSI-Penta",{"$f":"PSIPENTA!F24","v":""}]
[null,null,null,null,null,null,"Dateiname Excelergebnistabelle",{"$f":"PSIPENTA!F25","v":0}]
[null,null,null,null,null,null,"Pfad Excelergebnistabelle",{"$f":"PSIPENTA!F26","v":0}]
[null,"Arbeitsmappe wird immer mit Schreibschutz geöffnet! (kein Speichern möglich)",null,null,null,null,"Datapool-String PSI-Penta",{"$f":"PSIPENTA!F27","v":0}]
[null,"Für Änderungen: ",null,"Schreibschutz EIN"]
[null,"mit \"OK + Speichern\" wird Schreibschutz wieder eingeschaltet!"]
[]
[]
[]
[null,null,"Programmhistorie"]
["Datum",null,"Änderung"]
["2015-04-02",null,"Nutbreitenangabe Ergebnisseite EINGABE berichtigt"]
["2015-09-30",null,"Drehfeldformatierung Nuttiefe von 0-330 statt 0-310, Mittelwert 170 statt 150 (max. Nuttiefe war bei manchen Varianten nicht möglich)"]
["2016-02-22",null,"max. Leistenlänge bei Stahlleisten angepaßt (bei Fa. Schneidmüller längere Tieflochbohrung möglich): 2400 war 1220 / 3000 war 1680 / 4000 war 1920"]
["2016-03-18",null,"max. Leistenhöhe bei 18er Stahlleiste von 40 auf 45 erhöht"]
["2016-03-24",null,"Tabellenblatt \"Zeichnung\" neu hinzu (Wunsch USA)"]
["2016-08-16",null,"max. Leistenhöhe bei 1 1/16\" Stahlleiste von 55 auf 58 erhöht"]
["2017-04-18",null,"Umstellung der Konfigurationsdatei von .xls auf .xlsm (neues Excel Dataiformat)"]

{"sheet":"Zeichnung","index":5,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":true,"merged":[[21,6,21,7],[28,9,28,10],[44,1,44,6],[44,7,44,8],[44,10,45,10],[45,1,45,6]]}
[null,{"$f":"Einstellungen!E2","v":"18042017"},null,null,null,null,null,null,null,null,"Hilma-Römheld GmbH - Schützenstraße 74 - 57271 Hilchenbach - www.roemheld-gruppe.de"]
[null,{"$f":"Eingabe!M13&\" [ \"&Artikelstamm!C6&\" ]\"","v":"Kugelleiste, hydraulisch [ 18 mm ]"},null,null,null,null,null,null,null,null,"Bild nur als Beispiel - optische Änderungen vorbehalten   Image for example only - subject to optical changes"]
[null,{"$f":"IF(Berechnung!C28=1,\"\",Eingabe!M15)","v":""},null,{"$f":"IF(Berechnung!C28=1,\"\",Berechnung!D32)","v":""}]
[null,{"$f":"Eingabe!M12","v":"Gehäusematerial:"},{"$f":"Berechnung!D103","v":"Aluminium"}]
[null,{"$f":"Eingabe!M16","v":"Befestigung:"},{"$f":"Berechnung!D53&IF(AND(Berechnung!C44=2,Berechnung!C53=1),\" (ISO 4762 - M\"&Artikelstamm!BJ6&\" x \"&Berechnung!D185&\" - 8.8)\",\"\")&IF(AND(Berechnung!C44=1,Berechnung!C53=1),\" (\"&'Text - Sprache'!M5&\" M\"&D8&\" x \"&Berechnung!D199&\")\",\"\")","v":"Riegel (Schraube M5 x 12)"}]
[null,null,{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"C\",\"\")","v":"C"},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),Artikelstamm!BB6,\"\")","v":5},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"( \"&ROUND(D6*0.039369964,3)&\" in )\",\"\")","v":"( 0,197 in )"},"Befestigungslochbild Riegel [C]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"D\",\"\")","v":"D"},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),Artikelstamm!BC6,\"\")","v":36},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"( \"&ROUND(D7*0.039369964,3)&\" in )\",\"\")","v":"( 1,417 in )"},"Befestigungslochbild Riegel [D]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"E\",\"\")","v":"E"},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),Artikelstamm!BD6,\"\")","v":5},null,"Gewinde [E]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"F\",\"\")","v":"F"},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),Artikelstamm!BE6,\"\")","v":8},{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C53=1),\"( \"&ROUND(D9*0.039369964,3)&\" in )\",\"\")","v":"( 0,315 in )"},"Tiefe Gewinde [F]"]
[null,null,{"$f":"IF(Berechnung!C53=2,\"B\",\"\")","v":""},{"$f":"IF(Berechnung!C53=2,Artikelstamm!BF6,\"\")","v":""},{"$f":"IF(Berechnung!C53=2,\"( \"&ROUND(D10*0.039369964,3)&\" in )\",\"\")","v":""},"Lage Klemmschloss [B]"]
[null,null,{"$f":"IF(Berechnung!C53=2,\"C1\",\"\")","v":""},{"$f":"IF(Berechnung!C53=2,Artikelstamm!BG6,\"\")","v":""},{"$f":"IF(Berechnung!C53=2,\"( \"&ROUND(D11*0.039369964,3)&\" in )\",\"\")","v":""},"Lage Klemmschloss [i / C1]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"C\",\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),Artikelstamm!BH6,\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"( \"&ROUND(D12*0.039369964,3)&\" in )\",\"\")","v":""},"Lage Schraubensenkung [C]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"T\",\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),Artikelstamm!BI6,\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"( \"&ROUND(D13*0.039369964,3)&\" in )\",\"\")","v":""},"Tiefe Schraubensenkung [T]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"E\",\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),Artikelstamm!BJ6,\"\")","v":""},null,"Gewinde [E]"]
[null,null,{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"F min.\",\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),Artikelstamm!BK6,\"\")","v":""},{"$f":"IF(AND(Berechnung!C44=2,Berechnung!C53=1),\"( \"&ROUND(D15*0.039369964,3)&\" in )\",\"\")","v":""},"Tiefe Gewinde [F]"]
[null,{"$f":"Eingabe!M19","v":"Nutbreite:"},"a",{"$f":"Artikelstamm!G6","v":18},{"$f":"\"( \"&Eingabe!O19&\" )\"","v":"( 0,709 in )"}]
[null,null,null,{"$f":"Artikelstamm!BP6&\" / +\"&Artikelstamm!BQ6","v":"0 / +0,2"},{"$f":"\"( \"&ROUND(Artikelstamm!BP6/25.4,3)&\" / +\"&ROUND(Artikelstamm!BQ6/25.4,3)&\" in )\"","v":"( 0 / +0,008 in )"},"Größt-/Kleinstmaß"]
[null,null,"a1",{"$f":"Artikelstamm!G6","v":18},{"$f":"\"( \"&Eingabe!O19&\" )\"","v":"( 0,709 in )"},"Leistenbreite [a1]"]
[null,null,null,{"$f":"Artikelstamm!BL6&\" / \"&Artikelstamm!BM6","v":"-0,2 / -0,5"},{"$f":"\"( \"&ROUND(Artikelstamm!BL6/25.4,3)&\" / \"&ROUND(Artikelstamm!BM6/25.4,3)&\" in )\"","v":"( -0,008 / -0,02 in )"},"Größt-/Kleinstmaß"]
[null,null,"R min.",{"$f":"\"R\"&Artikelstamm!BT6&\"  (\"&Artikelstamm!BT6&\"x45°)\"","v":"R1  (1x45°)"},{"$f":"\"( \"&ROUND(Artikelstamm!BT6*0.039369964,3)&\" in )\"","v":"( 0,039 in )"},"Radius/Kantenbrucn [R]"]
[null,{"$f":"Eingabe!M20","v":"Nuttiefe:"},"h",{"$f":"Berechnung!D68","v":30},{"$f":"\"( \"&Eingabe!O20&\" )\"","v":"( 1,181 in )"}]
[null,null,null,{"$f":"Artikelstamm!BR6&\" / +\"&Artikelstamm!BS6","v":"0 / +0,2"},{"$f":"\"( \"&ROUND(Artikelstamm!BR6/25.4,3)&\" / +\"&ROUND(Artikelstamm!BS6/25.4,3)&\" in )\"","v":"( 0 / +0,008 in )"},"Größt-/Kleinstmaß","h1 + s"]
[null,null,"h1",{"$f":"Berechnung!D68","v":30},{"$f":"\"( \"&Eingabe!O20&\" )\"","v":"( 1,181 in )"},"Leistenhöhe [h1]",{"$f":"D23+Berechnung!D48","v":31},{"$f":"\"( \"&ROUND(G23/25.4,3)&\" in )\"","v":"( 1,22 in )"}]
[null,null,null,{"$f":"Artikelstamm!BN6&\" / \"&Artikelstamm!BO6","v":"-0,2 / -0,4"},{"$f":"\"( \"&ROUND(Artikelstamm!BN6/25.4,3)&\" / \"&ROUND(Artikelstamm!BO6/25.4,3)&\" in )\"","v":"( -0,008 / -0,016 in )"},"Größt-/Kleinstmaß",{"$f":"IF(Berechnung!D191>0,\"+\",\"\")&Berechnung!D191&\" / \"&Berechnung!D192","v":"+0,2 / -0,2"},{"$f":"\"( \"&IF(Berechnung!D191>0,\"+\",\"\")&ROUND(Berechnung!D191/25.4,3)&\" / \"&ROUND(Berechnung!D192/25.4,3)&\" in )\"","v":"( +0,008 / -0,008 in )"}]
[null,{"$f":"Eingabe!M21","v":"Leistenlänge:"},"L",{"$f":"Berechnung!D26","v":495},{"$f":"\"( \"&ROUND(Berechnung!D26*0.039369964,3)&\" in )\"","v":"( 19,488 in )"}]
[null,{"$f":"Eingabe!M24","v":"Kugeleinsatz:"},null,{"$f":"Berechnung!D114","v":16}]
[null,{"$f":"Eingabe!M25","v":"Hub:"},"s",{"$f":"Berechnung!D48","v":1},{"$f":"\"( \"&Eingabe!O25&\" )\"","v":"( 0,039 in )"}]
[null,{"$f":"Eingabe!M28","v":"Tragkraft pro Einsatz:"},null,{"$f":"Berechnung!C130","v":0.79},{"$f":"\"( \"&Eingabe!O28&\" )\"","v":"( 177,6 lbf )"}]
[null,null,null,{"$f":"Eingabe!P28","v":"( 80,5 kg / 177,5 lb. )"},null,null,null,null,{"$f":"Eingabe!M16","v":"Befestigung:"},{"$f":"Berechnung!B54&IF(AND(Berechnung!C44=2,Berechnung!C53=1),\" (ISO 4762 - M\"&Artikelstamm!BJ6&\" x \"&Berechnung!D185&\" - 8.8)\",\"\")&IF(AND(Berechnung!C44=1,Berechnung!C53=1),\" (\"&'Text - Sprache'!M5&\" M\"&D8&\" x \"&Berechnung!D199&\")\",\"\")&\"            /            \"&Berechnung!B55","v":"Riegel (Schraube M5 x 12)            /            Klemmschloss"}]
[null,{"$f":"Eingabe!M29","v":"Gesamttragkraft:"},null,{"$f":"Berechnung!C131","v":12.64},{"$f":"\"( \"&Eingabe!O29&\" )\"","v":"( 2841,6 lbf )"}]
[null,null,null,{"$f":"Eingabe!P29","v":"( 1288 kg / 2841 lb. )"}]
[null,{"$f":"Eingabe!M23","v":"Kugelabstand:"},"G",{"$f":"Berechnung!D112","v":30},{"$f":"\"( \"&Eingabe!O23&\" )\"","v":"( 1,181 in )"}]
[null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!M23)","v":"Kugelabstand:"},{"$f":"IF(Berechnung!C44>1,\"\",\"G1\")","v":"G1"},{"$f":"IF(Berechnung!C44>1,\"\",Berechnung!D111)","v":30},{"$f":"IF(Berechnung!C44>1,\"\",\"( \"&ROUND(Berechnung!D111*0.039369964,3)&\" in )\")","v":"( 1,181 in )"}]
[null,null,"M",{"$f":"Artikelstamm!S6","v":22.5},{"$f":"\"( \"&ROUND(Artikelstamm!S6*0.039369964,3)&\" in )\"","v":"( 0,886 in )"},"Insertabstand (vorn od. vorn+hinten) [M]"]
[null,null,{"$f":"IF(Berechnung!C44=1,\"\",\"N\")","v":""},{"$f":"IF(Berechnung!C44=1,\"\",Artikelstamm!T6)","v":""},{"$f":"IF(Berechnung!C44=1,\"\",ROUND(Artikelstamm!T6*0.039369964,3)&\" in\")","v":""},"Insertabstand hinten [N]"]
[null,{"$f":"Eingabe!M33","v":"max. Einsatztemperatur:"},null,{"$f":"Berechnung!C89","v":"100 °C"},{"$f":"\"( \"&Eingabe!P33&\" )\"","v":"( 212 °F )"}]
[null,{"$f":"Eingabe!M38","v":"Masse / Kugelleiste:"},null,{"$f":"Eingabe!N38","v":"ca. 0,9 kg"},{"$f":"\"( \"&Eingabe!O38&\" )\"","v":"( 1,984 lb. )"}]
[null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!M32)","v":"Anschlussgewinde:"},{"$f":"IF(Berechnung!C44>1,\"\",\"A\")","v":"A"},{"$f":"IF(Berechnung!C44>1,\"\",Artikelstamm!AB6)","v":"G1/8"}]
[null,null,{"$f":"IF(Berechnung!C44>1,\"\",\"K\")","v":"K"},{"$f":"IF(Berechnung!C44>1,\"\",Berechnung!D167)","v":8},{"$f":"IF(Berechnung!C44>1,\"\",\"( \"&ROUND(Berechnung!D167*0.039369964,3)&\" in )\")","v":"( 0,315 in )"},"Lage Anschlussgewinde [K]"]
[null,{"$f":"IF(Berechnung!C44>1,\"\",'Text - Sprache'!I41&\":\")","v":"Verschlussschraube:"},{"$f":"IF(Berechnung!C44>1,\"\",\"L1\")","v":"L1"},{"$f":"IF(Berechnung!C44>1,\"\",Artikelstamm!AL6)","v":3.5},{"$f":"IF(Berechnung!C44>1,\"\",\"( \"&ROUND(Artikelstamm!AL6*0.039369964,3)&\" in )\")","v":"( 0,138 in )"}]
[null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!M37)","v":"Kolbendichtung:"},null,{"$f":"IF(Berechnung!C44>1,\"\",Berechnung!C98)","v":"NBR"}]
[null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!M30)","v":"Ölbedarf:"},null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!N30&\" cm³\")","v":"1,6 cm³"},{"$f":"IF(Berechnung!C44>1,\"\",\"( \"&Eingabe!O30&\" )\")","v":"( 0,0976 in³ )"}]
[null,{"$f":"IF(Berechnung!C44>1,\"\",Eingabe!M31)","v":"Betriebsdruck:"},null,{"$f":"IF(Berechnung!C44>1,\"\",Berechnung!D84)","v":100},{"$f":"IF(Berechnung!C44>1,\"\",\"( \"&Eingabe!O31&\" )\")","v":"( 1450 PSI )"},null,{"$f":"IF(AND(Berechnung!C44=1,Berechnung!C87<>Berechnung!C86),Eingabe!P31,\"\")","v":""}]
[]
[null,"text 1",null,null,null,null,null,{"$f":"Eingabe!M13","v":"Kugelleiste, hydraulisch"},null,null,{"$f":"Eingabe!M11","v":"892177118L495R"}]
[null,"text 2",null,null,null,null,null,"name",{"$f":"TODAY()","v":"2017-04-18"}]

{"sheet":"Artikelstamm","index":6,"n_rows":59,"n_cols":75,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung","Zeichnung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Riegel","Riegel","Riegel","Riegel","Klemmschl.","Klemmschl.","Schraube","Schraube","Schraube","Schraube","Leistenkörper","Leistenkörper","Leistenkörper","Leistenkörper","Nut","Nut","Nut","Nut"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74]
[null,"Leistenart","Nutbreite","Betätigungsart","Befestigung 1\nStandard","Befestigung 2","Nutbreite\nin\nmm","Typ\nStandard\n92xx","Typ\nHub vergrößert\n92xx","Typ Version\nStandard","Typ Version\nHub vergrößert","Typ Version\nKugelleiste\nTellerfeder","Typ Version\nStahlausführung\nStandard bis 100°C","Typ Version\nStahlausführung\nVITON bis 200°C","Typ Version\nStahlausführung\nKALREZ bis 250°C","Typ-Endung","Hub\nStandard\n921x","Hub\nvergößert\n922x","Randabstand\nerste\nKugel/Rolle","Randabstand\nletzte\nKugel/Rolle","Abstand 1./2.\nKugel/Rolle\nmin.","Abstand weitere\nKugel/Rolle\nmin.","Abstand weitere\nKugel/Rolle\nStandard","Abstand weitere\nKugel/Rolle\nmax.","Schrittweite\nbei\nAbstandsänderung","Tragkraft\nje\nKugel/Rolle","Position\nAnschlussgewinde\nAluminiumausf.","Anschluss-\ngewinde","Betriebsdruck\nStandard","Nuttiefe min.","Nuttiefe min.\n\nHub vergrößert","Nuttiefe min.\nKugelleiste\nTellerfeder","Nuttiefe\nStandard","Nuttiefe max.\nStahlausführung","Schrittweite\nNuttiefe","Leistenlänge\nmax.","Leistenlänge\nmax.\nStahlausführung","Überstand\nVerschluss-\nschraube","Ø\nInsert-\nbohrung","Tiefe\nInsert-\nbohrung","Ø Kolben-/\nFeder-\nbohrung","Tiefe\nKolben-/Feder-\nbohrung","Tiefe\nTellerfeder-\nbohrung","Tiefe Kolben-/\nFederbohrung\nHub vergrößert","Gewicht je Insert\ninkl. Kolben/Federn\nkg","Ø Ölbohrung\nAluminium","Position\nÖlbohrung\nAluminiumausf.","Ø Ölbohrung\nStahlausf.","Position\nÖlbohrung\nStahlausf.","Artikelnummer\nLeistenkörper\nAluminium","Artikelnummer\nLeistenkörper\nStahl","Artikelnummer\nRohmaterial\nAluminium","Anzahl T-\nFeder je\nPaket","Maß C","Maß D","Gewinde E","Maß F\nGewindetiefe","Maß B","Maß C1","Maß C","Maß T\nSenkungstiefe","Maß E\nGewinde","Maß F\nGewindetiefe","untere\nToleranz\nLeistenbreite a1","obere\nToleranz\nLeistenbreite a1","untere\nToleranz\nLeistenhöhe h1","obere\nToleranz\nLeistenhöhe h1","untere\nToleranz\nNutbreite a","obere\nToleranz\nNutbreite a","untere\nToleranz\nNuttiefe h","obere\nToleranz\nNuttiefe h","Eckenradius\nLeistenkörper R","untere Hubtoleranz","obere Hubtoleranz"]
[null,{"$f":"\"A\"&B3","v":"A1"},{"$f":"\"A\"&C3","v":"A2"},"A3","A4","A5","A6","A7","A8","A9","A10",{"$f":"\"A\"&L3","v":"A11"},{"$f":"\"A\"&M3","v":"A12"},{"$f":"\"A\"&N3","v":"A13"},{"$f":"\"A\"&O3","v":"A14"},{"$f":"\"A\"&P3","v":"A15"},"A16","A17","A18","A19","A20","A21","A22","A23","A24","A25",{"$f":"\"A\"&AA3","v":"A26"},{"$f":"\"A\"&AB3","v":"A27"},{"$f":"\"A\"&AC3","v":"A28"},"A29","A30",{"$f":"\"A\"&AF3","v":"A31"},"A32","A33","A34","A35","A36","A37","A38","A39","A40","A41","A42","A43","A44","A45",{"$f":"\"A\"&AU3","v":"A46"},{"$f":"\"A\"&AV3","v":"A47"},{"$f":"\"A\"&AW3","v":"A48"},"A49","A50","A51",{"$f":"\"A\"&BA3","v":"A52"},{"$f":"\"A\"&BB3","v":"A53"},{"$f":"\"A\"&BC3","v":"A54"},"A55","A56","A57","A58","A59","A60","A61","A62","A63","A64","A65","A66","A67","A68","A69","A70","A71","A72","A73","A74"]
[null,{"$f":"Berechnung!D28","v":"Kugelleiste"},{"$f":"Berechnung!D36","v":"18 mm"},{"$f":"Berechnung!D44","v":"hydraulisch"},{"$f":"DGET($B7:E31,E3,$B5:$D6)","v":"Riegel"},{"$f":"DGET($B7:F31,F3,$B5:$D6)","v":"Klemmschloss"},{"$f":"DGET($B7:G31,G3,$B5:$D6)","v":18},{"$f":"DGET($B7:H31,H3,$B5:$D6)","v":17},{"$f":"DGET($B7:I31,I3,$B5:$D6)","v":27},{"$f":"DGET($B7:J31,J3,$B5:$D6)","v":71},{"$f":"DGET($B7:K31,K3,$B5:$D6)","v":0},{"$f":"DGET($B7:L31,L3,$B5:$D6)","v":0},{"$f":"DGET($B7:M31,M3,$B5:$D6)","v":60},{"$f":"DGET($B7:N31,N3,$B5:$D6)","v":50},{"$f":"DGET($B7:O31,O3,$B5:$D6)","v":40},{"$f":"DGET($B7:P31,P3,$B5:$D6)","v":18},{"$f":"DGET($B7:Q31,Q3,$B5:$D6)","v":1},{"$f":"DGET($B7:R31,R3,$B5:$D6)","v":0},{"$f":"DGET($B7:S31,S3,$B5:$D6)","v":22.5},{"$f":"DGET($B7:T31,T3,$B5:$D6)","v":22.5},{"$f":"DGET($B7:U31,U3,$B5:$D6)","v":26},{"$f":"DGET($B7:V31,V3,$B5:$D6)","v":20},{"$f":"DGET($B7:W31,W3,$B5:$D6)","v":30},{"$f":"DGET($B7:X31,X3,$B5:$D6)","v":60},{"$f":"DGET($B7:Y31,Y3,$B5:$D6)","v":1},{"$f":"DGET($B7:Z31,Z3,$B5:$D6)","v":0.79},{"$f":"DGET($B7:AA31,AA3,$B5:$D6)","v":8},{"$f":"DGET($B7:AB31,AB3,$B5:$D6)","v":"G1/8"},{"$f":"DGET($B7:AC31,AC3,$B5:$D6)","v":100},{"$f":"DGET($B7:AD31,AD3,$B5:$D6)","v":29.5},{"$f":"DGET($B7:AE31,AE3,$B5:$D6)","v":0},{"$f":"DGET($B7:AF31,AF3,$B5:$D6)","v":0},{"$f":"DGET($B7:AG31,AG3,$B5:$D6)","v":30},{"$f":"DGET($B7:AH31,AH3,$B5:$D6)","v":45},{"$f":"DGET($B7:AI31,AI3,$B5:$D6)","v":0.1},{"$f":"DGET($B7:AJ31,AJ3,$B5:$D6)","v":2950},{"$f":"DGET($B7:AK31,AK3,$B5:$D6)","v":2400},{"$f":"DGET($B7:AL31,AL3,$B5:$D6)","v":3.5},{"$f":"DGET($B7:AM31,AM3,$B5:$D6)","v":16},{"$f":"DGET($B7:AN31,AN3,$B5:$D6)","v":14},{"$f":"DGET($B7:AO31,AO3,$B5:$D6)","v":10},{"$f":"DGET($B7:AP31,AP3,$B5:$D6)","v":24.1},{"$f":"DGET($B7:AQ31,AQ3,$B5:$D6)","v":0},{"$f":"DGET($B7:AR31,AR3,$B5:$D6)","v":0},{"$f":"DGET($B7:AS31,AS3,$B5:$D6)","v":2.3E-2},{"$f":"DGET($B7:AT31,AT3,$B5:$D6)","v":5},{"$f":"DGET($B7:AU31,AU3,$B5:$D6)","v":7},{"$f":"DGET($B7:AV31,AV3,$B5:$D6)","v":6},{"$f":"DGET($B7:AW31,AW3,$B5:$D6)","v":7},{"$f":"DGET($B7:AX31,AX3,$B5:$D6)","v":504950830},{"$f":"DGET($B7:AY31,AY3,$B5:$D6)","v":504951072},{"$f":"DGET($B7:AZ31,AZ3,$B5:$D6)","v":404950706},{"$f":"DGET($B7:BA31,BA3,$B5:$D6)","v":0},{"$f":"DGET($B7:BB31,BB3,$B5:$D6)","v":5},{"$f":"DGET($B7:BC31,BC3,$B5:$D6)","v":36},{"$f":"DGET($B7:BD31,BD3,$B5:$D6)","v":5},{"$f":"DGET($B7:BE31,BE3,$B5:$D6)","v":8},{"$f":"DGET($B7:BF31,BF3,$B5:$D6)","v":12},{"$f":"DGET($B7:BG31,BG3,$B5:$D6)","v":35},{"$f":"DGET($B7:BH31,BH3,$B5:$D6)","v":0},{"$f":"DGET($B7:BI31,BI3,$B5:$D6)","v":0},{"$f":"DGET($B7:BJ31,BJ3,$B5:$D6)","v":0},{"$f":"DGET($B7:BK31,BK3,$B5:$D6)","v":0},{"$f":"DGET($B7:BL31,BL3,$B5:$D6)","v":-0.2},{"$f":"DGET($B7:BM31,BM3,$B5:$D6)","v":-0.5},{"$f":"DGET($B7:BN31,BN3,$B5:$D6)","v":-0.2},{"$f":"DGET($B7:BO31,BO3,$B5:$D6)","v":-0.4},{"$f":"DGET($B7:BP31,BP3,$B5:$D6)","v":0},{"$f":"DGET($B7:BQ31,BQ3,$B5:$D6)","v":0.2},{"$f":"DGET($B7:BR31,BR3,$B5:$D6)","v":0},{"$f":"DGET($B7:BS31,BS3,$B5:$D6)","v":0.2},{"$f":"DGET($B7:BT31,BT3,$B5:$D6)","v":1},{"$f":"DGET($B7:BU31,BU3,$B5:$D6)","v":0.2},{"$f":"DGET($B7:BV31,BV3,$B5:$D6)","v":0.4},{"$f":"DGET($B7:BW31,BW3,$B5:$D6)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B5","v":"A1"},"A2","A3","A4","A5","A6","A7","A8","A9","A10",{"$f":"L5","v":"A11"},{"$f":"M5","v":"A12"},{"$f":"N5","v":"A13"},{"$f":"O5","v":"A14"},{"$f":"P5","v":"A15"},"A16","A17","A18","A19","A20","A21","A22","A23",{"$f":"Y5","v":"A24"},"A25",{"$f":"AA5","v":"A26"},{"$f":"AB5","v":"A27"},{"$f":"AC5","v":"A28"},{"$f":"AD5","v":"A29"},{"$f":"AE5","v":"A30"},{"$f":"AF5","v":"A31"},"A32",{"$f":"AH5","v":"A33"},"A34","A35","A36","A37","A38",{"$f":"AN5","v":"A39"},"A40","A41",{"$f":"AQ5","v":"A42"},"A43","A44","A45",{"$f":"AU5","v":"A46"},"A47",{"$f":"AW5","v":"A48"},"A49","A50","A51","A52","A53","A54","A55","A56","A57","A58","A59","A60","A61","A62","A63","A64","A65","A66","A67","A68","A69","A70","A71","A72","A73","A74"]
[null,{"$f":"'Text - Sprache'!F5","v":"Kugelleiste"},"18 mm",{"$f":"'Text - Sprache'!I5","v":"hydraulisch"},{"$f":"'Text - Sprache'!L5","v":"Riegel"},{"$f":"'Text - Sprache'!N5","v":"Klemmschloss"},18,17,27,71,0,0,60,50,40,18,1,0,22.5,{"$f":"S8","v":22.5},26,20,30,60,1,0.79,8,"G1/8",100,29.5,0,0,30,45,0.1,2950,2400,3.5,16,14,10,24.1,0,0,2.3E-2,5,7,6,7,504950830,504951072,404950706,0,5,36,5,8,12,35,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.2,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},"22 mm",{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},22,{"$f":"H8","v":17},{"$f":"I8","v":27},{"$f":"J8","v":71},0,0,{"$f":"M8","v":60},{"$f":"N8","v":50},{"$f":"O8","v":40},22,2,0,30,{"$f":"S9","v":30},32,23,40,80,{"$f":"Y8","v":1},1.1000000000000001,8.5,{"$f":"AB8","v":"G1/8"},{"$f":"AC8","v":100},37,0,0,38,55,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,{"$f":"AL8","v":3.5},19,17,12,29,0,0,3.6999999999999998E-2,6,8.5,7,8,504950831,504951073,404950733,0,7,40,5,8,16,46,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},"28 mm",{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},28,{"$f":"H8","v":17},{"$f":"I8","v":27},{"$f":"J8","v":71},70,0,{"$f":"M8","v":60},{"$f":"N8","v":50},{"$f":"O8","v":40},28,2,3,32.5,32.5,37,28,45,90,{"$f":"Y8","v":1},1.5,11,"G1/4",{"$f":"AC8","v":100},42,43,0,48,60,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,4.5,24,21.2,14,{"$f":"Berechnung!C153","v":39},0,{"$f":"AP10","v":39},7.1999999999999995E-2,6,9,7,8.5,504950832,504951074,404950707,0,9,50,6,12,16,51,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},"36 mm",{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},36,{"$f":"H8","v":17},{"$f":"I8","v":27},{"$f":"J8","v":71},70,0,{"$f":"M8","v":60},{"$f":"N8","v":50},{"$f":"O8","v":40},36,2,3,35,35,43,34,50,100,{"$f":"Y8","v":1},2.5,11,{"$f":"AB10","v":"G1/4"},{"$f":"AC8","v":100},53,52.5,0,61,75,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},4000,{"$f":"AL10","v":4.5},30,27.5,18,{"$f":"Berechnung!C154","v":51},0,{"$f":"AP11","v":51},0.152,8,10,8,10,504950833,504951075,404950708,0,10,55,6,12,16,56.5,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.3,0,0.2,2,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},"13/16\"  (20,6 mm)",{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},20.6,{"$f":"H8","v":17},{"$f":"I8","v":27},{"$f":"J8","v":71},0,0,{"$f":"M8","v":60},{"$f":"N8","v":50},{"$f":"O8","v":40},13,{"$f":"Q8","v":1},{"$f":"R8","v":0},22.5,22.5,{"$f":"U8","v":26},{"$f":"V8","v":20},30,60,{"$f":"Y8","v":1},{"$f":"Z8","v":0.79},8,{"$f":"AB8","v":"G1/8"},{"$f":"AC8","v":100},29.4,0,0,29.4,40,{"$f":"AI8","v":0.1},2950,{"$f":"AK8","v":2400},3.5,16,14,10,{"$f":"AP8","v":24.1},0,0,{"$f":"AS8","v":2.3E-2},5,6.4,{"$f":"AV8","v":6},6.9,504950834,504951070,404950749,0,5,36,5,8,12,35,0,0,0,0,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},"1 1/16\" (27 mm)",{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},27,{"$f":"H8","v":17},{"$f":"I8","v":27},{"$f":"J8","v":71},0,0,{"$f":"M8","v":60},{"$f":"N8","v":50},{"$f":"O8","v":40},17,{"$f":"Q9","v":2},{"$f":"R9","v":0},30,30,{"$f":"U9","v":32},23,40,80,{"$f":"Y8","v":1},{"$f":"Z9","v":1.1000000000000001},11,{"$f":"AB10","v":"G1/4"},{"$f":"AC8","v":100},37.4,0,0,38.9,58,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK9","v":3000},{"$f":"AL10","v":4.5},{"$f":"AM9","v":19},{"$f":"AN9","v":17},{"$f":"AO9","v":12},{"$f":"AP9","v":29},0,0,3.6999999999999998E-2,6,9,7,8.5,504950835,504951071,404950750,0,7,40,5,8,16,46,0,0,0,0,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C8","v":"18 mm"},{"$f":"'Text - Sprache'!J5","v":"gefedert"},{"$f":"'Text - Sprache'!M5","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G8","v":18},18,28,72,0,71,60,50,40,{"$f":"P8","v":18},{"$f":"Q8","v":1},0,27.5,12.5,{"$f":"V14","v":20},20,{"$f":"W8","v":30},{"$f":"X8","v":60},{"$f":"Y8","v":1},0.22,0,0,0,29.4,0,25,{"$f":"AG8","v":30},{"$f":"AH8","v":45},{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,0,{"$f":"AM8","v":16},14,16,26,22.4,0,2.7E-2,0,0,0,0,504950940,504951078,{"$f":"AZ8","v":404950706},8,0,0,0,0,{"$f":"BF8","v":12},10,10,20,6,11,{"$f":"BL8","v":-0.2},-0.5,-0.2,-0.4,0,0.2,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C9","v":"22 mm"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G9","v":22},{"$f":"H14","v":18},{"$f":"I14","v":28},{"$f":"J14","v":72},0,71,{"$f":"M14","v":60},{"$f":"N14","v":50},{"$f":"O14","v":40},22,2,0,40,15,23,23,{"$f":"W9","v":40},{"$f":"X9","v":80},{"$f":"Y8","v":1},0.42,0,0,0,38,0,31,{"$f":"AG9","v":38},55,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK14","v":3000},0,19,17,19,35.6,28.6,0,4.2000000000000003E-2,0,0,0,0,504950941,504951079,404950733,10,0,0,0,0,16,24.5,12.5,13,8,13,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C10","v":"28 mm"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G10","v":28},{"$f":"H14","v":18},{"$f":"I14","v":28},{"$f":"J14","v":72},0,71,{"$f":"M14","v":60},{"$f":"N14","v":50},{"$f":"O14","v":40},28,2,0,50,25,28,28,{"$f":"W10","v":45},90,{"$f":"Y8","v":1},0.63,0,0,0,48,0,35,48,60,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK14","v":3000},0,24,21.2,24,45,32,0,8.2000000000000003E-2,0,0,0,0,504950942,504951080,404950707,8,0,0,0,0,16,30,15,16,10,15,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C11","v":"36 mm"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G11","v":36},{"$f":"H14","v":18},{"$f":"I14","v":28},{"$f":"J14","v":72},0,0,{"$f":"M14","v":60},{"$f":"N14","v":50},{"$f":"O14","v":40},36,2,0,57.5,27.5,34,34,50,100,{"$f":"Y8","v":1},1,0,0,0,46,0,0,61,75,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK11","v":4000},0,30,27.5,30,{"$f":"AQ17","v":43.2},43.2,0,0.16600000000000001,0,0,0,0,504950985,504951081,404950708,10,0,0,0,0,16,35,20,14.5,10,15,-0.2,-0.5,-0.2,-0.4,0,0.3,0,0.2,2,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C12","v":"13/16\"  (20,6 mm)"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G12","v":20.6},{"$f":"H14","v":18},{"$f":"I14","v":28},{"$f":"J14","v":72},0,71,{"$f":"M14","v":60},{"$f":"N14","v":50},{"$f":"O14","v":40},13,1,{"$f":"R14","v":0},27.5,{"$f":"T14","v":12.5},20,20,30,60,{"$f":"Y8","v":1},{"$f":"Z14","v":0.22},0,0,0,29.4,0,{"$f":"AF14","v":25},29.4,40,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK14","v":3000},0,16,14,{"$f":"AO14","v":16},26,22.4,0,{"$f":"AS14","v":2.7E-2},0,0,0,0,504950938,504951076,404950749,{"$f":"BA14","v":8},0,0,0,0,12,10,10,20,6,11,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B8","v":"Kugelleiste"},{"$f":"C13","v":"1 1/16\" (27 mm)"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G13","v":27},{"$f":"H14","v":18},{"$f":"I14","v":28},{"$f":"J14","v":72},0,71,{"$f":"M14","v":60},{"$f":"N14","v":50},{"$f":"O14","v":40},17,2,{"$f":"R15","v":0},40,15,23,23,40,80,{"$f":"Y8","v":1},{"$f":"Z15","v":0.42},0,0,0,38,0,{"$f":"AF15","v":31},38.9,58,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK14","v":3000},0,19,17,19,35.6,28.6,0,{"$f":"AS15","v":4.2000000000000003E-2},0,0,0,0,504950939,504951077,404950750,{"$f":"BA15","v":10},0,0,0,0,16,24.5,12.5,13,8,13,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"'Text - Sprache'!G5","v":"Rollenleiste"},{"$f":"C8","v":"18 mm"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G8","v":18},15,25,70,0,0,60,50,40,{"$f":"P8","v":18},{"$f":"Q8","v":1},{"$f":"R8","v":0},{"$f":"S8","v":22.5},22.5,{"$f":"U8","v":26},{"$f":"V8","v":20},30,60,{"$f":"Y8","v":1},1.1399999999999999,{"$f":"AA8","v":8},{"$f":"AB8","v":"G1/8"},120,29.5,0,0,{"$f":"AG8","v":30},{"$f":"AH8","v":45},0.1,2950,{"$f":"AK8","v":2400},3.5,16,14,11,25.1,0,0,2.5000000000000001E-2,{"$f":"AT8","v":5},7,6,{"$f":"AW8","v":7},504950989,504951084,{"$f":"AZ8","v":404950706},0,{"$f":"BB8","v":5},36,5,8,12,35,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.2,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C9","v":"22 mm"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G9","v":22},{"$f":"H20","v":15},{"$f":"I20","v":25},{"$f":"J20","v":70},0,0,{"$f":"M20","v":60},{"$f":"N20","v":50},{"$f":"O20","v":40},{"$f":"P9","v":22},{"$f":"Q9","v":2},0,{"$f":"S9","v":30},30,{"$f":"U9","v":32},23,40,80,{"$f":"Y8","v":1},1.85,{"$f":"AA9","v":8.5},{"$f":"AB8","v":"G1/8"},{"$f":"AC20","v":120},37.5,0,0,{"$f":"AG9","v":38},55,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,{"$f":"AL8","v":3.5},{"$f":"AM9","v":19},17,14,31.5,0,0,4.5999999999999999E-2,6,{"$f":"AU9","v":8.5},7,{"$f":"AW9","v":8},504950990,504951085,404950733,0,7,40,5,8,16,46,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C10","v":"28 mm"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G10","v":28},{"$f":"H20","v":15},{"$f":"I20","v":25},{"$f":"J20","v":70},70,0,{"$f":"M20","v":60},{"$f":"N20","v":50},{"$f":"O20","v":40},{"$f":"P10","v":28},2,3,32.5,32.5,{"$f":"U10","v":37},28,{"$f":"W10","v":45},90,{"$f":"Y8","v":1},3,{"$f":"AA10","v":11},{"$f":"AB10","v":"G1/4"},{"$f":"AC20","v":120},43,43,0,{"$f":"AG10","v":48},60,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,{"$f":"AL10","v":4.5},24,21.2,18,39.700000000000003,0,{"$f":"AP22","v":39.700000000000003},9.2999999999999999E-2,6,{"$f":"AU10","v":9},7,9,504950991,504951086,404950707,0,9,50,6,12,16,51,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C11","v":"36 mm"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G11","v":36},{"$f":"H20","v":15},{"$f":"I20","v":25},{"$f":"J20","v":70},70,0,{"$f":"M20","v":60},{"$f":"N20","v":50},{"$f":"O20","v":40},{"$f":"P11","v":36},2,3,35,35,43,34,50,100,{"$f":"Y8","v":1},4.5,{"$f":"AA11","v":11},{"$f":"AB10","v":"G1/4"},{"$f":"AC20","v":120},54.5,54.5,0,{"$f":"AG11","v":61},75,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},4000,{"$f":"AL10","v":4.5},30,27.5,22,51,0,{"$f":"AP23","v":51},0.18099999999999999,8,{"$f":"AU11","v":10},8,{"$f":"AW11","v":10},504950992,504951087,404950708,0,10,55,6,12,16,56.5,0,0,0,0,-0.2,-0.5,-0.2,-0.4,0,0.3,0,0.2,2,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C12","v":"13/16\"  (20,6 mm)"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G12","v":20.6},{"$f":"H20","v":15},{"$f":"I20","v":25},{"$f":"J20","v":70},0,0,{"$f":"M20","v":60},{"$f":"N20","v":50},{"$f":"O20","v":40},{"$f":"P12","v":13},1,0,22.5,22.5,{"$f":"U12","v":26},20,30,60,{"$f":"Y8","v":1},{"$f":"Z20","v":1.1399999999999999},{"$f":"AA12","v":8},{"$f":"AB8","v":"G1/8"},{"$f":"AC20","v":120},29.4,0,0,{"$f":"AG12","v":29.4},40,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},2400,{"$f":"AL8","v":3.5},16,14,{"$f":"AO20","v":11},{"$f":"AP20","v":25.1},0,0,{"$f":"AS20","v":2.5000000000000001E-2},5,{"$f":"AU12","v":6.4},6,{"$f":"AW12","v":6.9},504950987,504951082,404950749,0,5,36,5,8,12,35,0,0,0,0,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C13","v":"1 1/16\" (27 mm)"},{"$f":"D8","v":"hydraulisch"},{"$f":"E8","v":"Riegel"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G13","v":27},{"$f":"H20","v":15},{"$f":"I20","v":25},{"$f":"J20","v":70},0,0,{"$f":"M20","v":60},{"$f":"N20","v":50},{"$f":"O20","v":40},{"$f":"P13","v":17},2,0,30,30,32,23,40,80,{"$f":"Y8","v":1},{"$f":"Z21","v":1.85},{"$f":"AA13","v":11},{"$f":"AB10","v":"G1/4"},{"$f":"AC20","v":120},38,0,0,{"$f":"AG13","v":38.9},58,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,{"$f":"AL10","v":4.5},19,17,{"$f":"AO21","v":14},{"$f":"AP21","v":31.5},0,0,{"$f":"AS21","v":4.5999999999999999E-2},6,{"$f":"AU13","v":9},7,{"$f":"AW13","v":8.5},504950988,504951083,404950750,0,7,40,5,8,16,46,0,0,0,0,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},{"$f":"C8","v":"18 mm"},{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},{"$f":"G8","v":18},16,26,70,0,0,60,50,40,{"$f":"P8","v":18},{"$f":"Q8","v":1},{"$f":"R14","v":0},27.5,{"$f":"T14","v":12.5},{"$f":"V26","v":20},{"$f":"V14","v":20},{"$f":"W8","v":30},{"$f":"X8","v":60},{"$f":"Y8","v":1},0.6,0,0,0,28.5,0,0,{"$f":"AG8","v":30},{"$f":"AH8","v":45},{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},{"$f":"AK14","v":3000},0,{"$f":"AM8","v":16},14,16,27.5,0,0,2.8000000000000001E-2,0,0,0,0,504950995,504951090,{"$f":"AZ8","v":404950706},14,0,0,0,0,{"$f":"BF8","v":12},10,10,20,6,11,{"$f":"BL8","v":-0.2},-0.5,-0.2,-0.4,0,0.2,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},"22 mm",{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},22,{"$f":"H26","v":16},{"$f":"I26","v":26},{"$f":"J26","v":70},0,0,{"$f":"M26","v":60},{"$f":"N26","v":50},{"$f":"O26","v":40},22,2,0,40,15,23,23,{"$f":"W9","v":40},{"$f":"X9","v":80},{"$f":"Y8","v":1},0.9,0,0,0,34.5,0,0,{"$f":"AG9","v":38},55,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,0,19,17,19,31.5,0,0,5.1999999999999998E-2,0,0,0,0,504950996,504951091,404950733,16,0,0,0,0,16,24.5,12.5,13,8,13,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},"28 mm",{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},28,{"$f":"H26","v":16},{"$f":"I26","v":26},{"$f":"J26","v":70},0,0,{"$f":"M26","v":60},{"$f":"N26","v":50},{"$f":"O26","v":40},28,2,0,50,25,28,28,{"$f":"W10","v":45},90,{"$f":"Y8","v":1},1.4,0,0,0,42,0,0,48,60,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,0,24,21.2,24,38.799999999999997,0,0,9.9000000000000005E-2,0,0,0,0,504950997,504951092,404950707,16,0,0,0,0,16,30,15,16,10,15,-0.2,-0.5,-0.2,-0.4,0,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},"36 mm",{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},36,{"$f":"H26","v":16},{"$f":"I26","v":26},{"$f":"J26","v":70},0,0,{"$f":"M26","v":60},{"$f":"N26","v":50},{"$f":"O26","v":40},36,2,0,57.5,27.5,34,34,50,100,{"$f":"Y8","v":1},2.4,0,0,0,51.5,0,0,61,75,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},4000,0,30,27.5,30,48.15,0,0,0.189,0,0,0,0,504950998,504951093,404950708,14,0,0,0,0,16,35,20,14.5,10,15,-0.2,-0.5,-0.2,-0.4,0,0.3,0,0.2,2,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},"13/16\"  (20,6 mm)",{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},20.6,{"$f":"H26","v":16},{"$f":"I26","v":26},{"$f":"J26","v":70},0,0,{"$f":"M26","v":60},{"$f":"N26","v":50},{"$f":"O26","v":40},13,1,0,27.5,{"$f":"T14","v":12.5},20,20,30,60,{"$f":"Y8","v":1},{"$f":"Z26","v":0.6},0,0,0,28.5,0,0,29.4,40,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,0,16,14,{"$f":"AO26","v":16},{"$f":"AP26","v":27.5},0,0,{"$f":"AS26","v":2.8000000000000001E-2},0,0,0,0,504950993,504951088,404950749,{"$f":"BA26","v":14},0,0,0,0,12,10,10,20,6,11,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[null,{"$f":"B20","v":"Rollenleiste"},"1 1/16\" (27 mm)",{"$f":"D14","v":"gefedert"},{"$f":"E14","v":"Schraube"},{"$f":"F8","v":"Klemmschloss"},27,{"$f":"H26","v":16},{"$f":"I26","v":26},{"$f":"J26","v":70},0,0,{"$f":"M26","v":60},{"$f":"N26","v":50},{"$f":"O26","v":40},17,2,0,40,{"$f":"T15","v":15},23,23,40,80,{"$f":"Y8","v":1},{"$f":"Z27","v":0.9},0,0,0,34.5,0,0,38.9,58,{"$f":"AI8","v":0.1},{"$f":"AJ8","v":2950},3000,0,19,17,{"$f":"AO27","v":19},{"$f":"AP27","v":31.5},0,0,{"$f":"AS27","v":5.1999999999999998E-2},0,0,0,0,504950994,504951089,404950750,{"$f":"BA27","v":16},0,0,0,0,16,24.5,12.5,13,8,13,-0.6,-0.8,-0.2,-0.4,-0.4,0.25,0,0.2,1,0.2,0.4]
[]
[]
[null,"min. Anzahl von Kugel/Rolleneinsätzen",null,null,3]
[]
[null,"Temperatur / Tragkraft"]
[null,"untere Grenztemperatur °C",null,null,0]
[null,"Temperaturgrenzen Dichtungen:"]
[null,"Temperatur max.","(Standard)","NBR",100,"max. Temp. Schraubenfedern!"]
[null,"Temperatur max.","(Viton)","FKM",200]
[null,"Temperatur max.","(Kalrez, Isolast)","FFKM",250]
[]
[null,"Temperaturgrenzen Tellerfedern:"]
[null,"% der Tragkraft >100-150°C",null,null,0.95]
[null,"% der Tragkraft >150-200°C",null,null,0.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"% der Tragkraft >200-250°C",null,null,0.6]
[]
[null,"Temperaturbereich 1",null,"bis °C",100,"Standard"]
[null,"Temperaturbereich 2",null,"bis °C",150,"Grenztemp. Tellerfedern"]
[null,"Temperaturbereich 3",null,"bis °C",200,"Grenztemp. FKM"]
[null,"Temperaturbereich 4",null,"bis °C",250,"Grenztemp. FFKM"]
[]
[null,"Gehäusematerial"]
[null,"Standard",null,null,{"$f":"'Text - Sprache'!D41","v":"Aluminium"},"AlMgSi 0,7 (F27)"]
[null,"Option",null,null,{"$f":"'Text - Sprache'!E41","v":"Stahl"},"C45"]
[]
[null,"Gewichtsberechnung"]
[null,"Dichte Aluminium",null,"kg/dm³",2.7]
[null,"Dichte Stahl",null,"kg/dm³",7.85]

{"sheet":"Berechnung","index":7,"n_rows":201,"n_cols":6,"rows_kept":201,"cut":false,"hidden":true,"merged":[[1,3,1,4]]}
[null,{"$f":"IF(B3=\"\",B5,B3)","v":0}]
[null,"PDF-Zeichnungen erzeugt?","PDF-Formular Fertigung","Zeichnungsnummern",null,"Musternummer"]
[null,null,{"$f":"\"5049592\"&\"X\"&RIGHT(E44)&\"XX\"&E36","v":"5049592X7XX18"},{"$f":"IF(C103=1,Artikelstamm!AX6,Artikelstamm!AY6)&\"#\"&F3","v":"504950830#000000000"},{"$f":"\"892\"&E44&E103&E36&\"#\"&F3","v":"892177118#000000000"},{"$f":"TEXT(Übergabe!D9,\"000000000\")","v":"000000000"}]
[null,"PDF-Kenner aus Penta-Konfiguration","PDF-Formular Montage",null,"Ausprägung der Leiste","Typ-Nr."]
[null,null,{"$f":"\"892\"&\"X\"&RIGHT(E44)&\"XX\"&E36","v":"892X7XX18"},{"$f":"\"892\"&E44&E103&E36","v":"892177118"},{"$f":"E20&E53&E58&E68&E32","v":"L495R"},{"$f":"\"92\"&E44&\"-\"&E103&E36","v":"9217-7118"}]
[]
[null,"Auswahl Sprache",1,{"$f":"INDEX(B8:B14,C7)","v":"Deutsch"}]
[1,{"$f":"'Text - Sprache'!B7","v":"Deutsch"},1]
[2,{"$f":"'Text - Sprache'!B8","v":"English"}]
[3,{"$f":"'Text - Sprache'!B9","v":"Italiano"}]
[4,{"$f":"'Text - Sprache'!B10","v":"Français"}]
[5,{"$f":"'Text - Sprache'!B11","v":"Español"}]
[6,{"$f":"'Text - Sprache'!B12","v":"Polski"}]
[7,{"$f":"'Text - Sprache'!B13","v":"한국어"}]
[8,{"$f":"'Text - Sprache'!B14","v":0}]
[9,{"$f":"'Text - Sprache'!B15","v":0}]
[10,{"$f":"'Text - Sprache'!B16","v":0}]
[11,{"$f":"'Text - Sprache'!B17","v":0}]
[]
["1.","mögliche Leistenlänge (ohne/inkl. Verschlußschraube)",{"$f":"IF(D25>D24,D24,IF(D25<D23,D23,D26))","v":495},{"$f":"IF(D25>D24,D24,IF(D25<D23,D23,D26+Artikelstamm!AL6))","v":498.5},{"$f":"\"L\"&C20","v":"L495"}]
[null,"max. zulässige Leistenlänge",null,{"$f":"IF(C103=1,Artikelstamm!AJ6,Artikelstamm!AK6)","v":2950}]
[null,"minimale Anzahl Inserts",null,{"$f":"Artikelstamm!E34","v":3}]
[null,"min. Leistenlänge (ohne Verschlußschraube)",null,{"$f":"Artikelstamm!S6+Artikelstamm!T6+D111+(D22-2)*D112","v":105}]
[null,"max. Leistenlänge (ohne Verschlußschraube)",null,{"$f":"(ROUNDDOWN(((D21-Artikelstamm!S6-Artikelstamm!T6-D111)/D112),0))*D112+D111+Artikelstamm!S6+Artikelstamm!T6","v":2925}]
[null,"gewünschte Leistenlänge",null,{"$f":"ROUND(Eingabe!C11,0)","v":500}]
[null,"errechnete Leistenlänge (ohne Verschlußschraube)",null,{"$f":"(C114-2)*D112+D111+Artikelstamm!S6+Artikelstamm!T6","v":495}]
[]
["2.","Auswahl Leistenart",1,{"$f":"INDEX(B29:B30,C28)","v":"Kugelleiste"}]
[1,{"$f":"Artikelstamm!B8","v":"Kugelleiste"},"Text Deutsch",{"$f":"IF(C28=1,'Text - Sprache'!F3,'Text - Sprache'!G3)","v":"Kugelleiste"}]
[2,{"$f":"Artikelstamm!B20","v":"Rollenleiste"}]
[]
["2.1","Auswahl Rollenausrichtung",false,{"$f":"IF(C32=FALSE,\"0°\",\"90°\")","v":"0°"},{"$f":"IF(OR(C28=1,C32=FALSE),\"\",\"X\")","v":""}]
[null,null,"Text für Übergabe",{"$f":"IF(C28=2,D32,\"\")","v":""}]
[]
[]
["3.","Auswahl Nutbreite",1,{"$f":"INDEX(B37:B42,C36)","v":"18 mm"},{"$f":"Artikelstamm!P6","v":18}]
[1,{"$f":"Artikelstamm!C8","v":"18 mm"}]
[2,{"$f":"Artikelstamm!C9","v":"22 mm"}]
[3,{"$f":"Artikelstamm!C10","v":"28 mm"}]
[4,{"$f":"Artikelstamm!C11","v":"36 mm"}]
[5,{"$f":"Artikelstamm!C12","v":"13/16\"  (20,6 mm)"}]
[6,{"$f":"Artikelstamm!C13","v":"1 1/16\" (27 mm)"}]
[]
["4.","Auswahl Betätigungsart",1,{"$f":"INDEX(B45:B46,C44)","v":"hydraulisch"},{"$f":"IF(C48=1,Artikelstamm!H6,Artikelstamm!I6)","v":17}]
[1,{"$f":"Artikelstamm!D8","v":"hydraulisch"},"Text Deutsch",{"$f":"IF(C44=1,'Text - Sprache'!I3,'Text - Sprache'!J3)","v":"hydraulisch"}]
[2,{"$f":"Artikelstamm!D14","v":"gefedert"},"Kennbuchstabe",{"$f":"IF(C44=1,\"H\",\"F\")","v":"H"}]
[]
["5.","Auswahl Hub",1,{"$f":"INDEX(B49:B50,C48)","v":1},{"$f":"IF(C48=2,Artikelstamm!K6,Artikelstamm!J6)","v":71}]
[1,{"$f":"Artikelstamm!Q6","v":1}]
[2,{"$f":"IF(OR(Artikelstamm!R6=0,Einstellungen!B10=FALSE),\"\",Artikelstamm!R6)","v":""}]
[]
[]
["6.","Auswahl Befestigung",1,{"$f":"INDEX(B54:B55,C53)","v":"Riegel"},{"$f":"INDEX(D54:D55,C53)","v":"R"}]
[1,{"$f":"Artikelstamm!E6","v":"Riegel"},null,{"$f":"IF(C44=1,\"R\",\"S\")","v":"R"}]
[2,{"$f":"Artikelstamm!F6","v":"Klemmschloss"},null,"K"]
[null,null,"Text Deutsch",{"$f":"IF(C53=2,'Text - Sprache'!N3,IF(C44=1,'Text - Sprache'!L3,'Text - Sprache'!M3))","v":"Riegel"}]
[]
["7.","Auswahl Kugel/Rollenabstand",{"$f":"IF(C28=1,'Text - Sprache'!D23,'Text - Sprache'!E23)","v":"Kugelabstand"},{"$f":"C66","v":30},{"$f":"IF(D58=C60,\"\",\"G\"&D58)","v":""}]
[null,"kleinster Abstand",{"$f":"Artikelstamm!V6","v":20},{"$f":"(C60-C59)/C62","v":10}]
[null,"Standardabstand",{"$f":"Artikelstamm!W6","v":30},{"$f":"(C61-C59)/C62","v":40}]
[null,"größter Abstand",{"$f":"Artikelstamm!X6","v":60},{"$f":"(C61-C60)/C62","v":30}]
[null,"Schrittweite (mm)",{"$f":"Artikelstamm!Y6","v":1}]
[null,"Mittelwert Drehfeld",50,"0-110"]
[null,"Wert aus Drehfeld",50]
[null,"Berechnung Abstand",{"$f":"IF(C64=C63,C60,C60-((C64-C63)*C62))","v":30}]
[null,"Abstand mit Grenzen kleinster/größter",{"$f":"IF(C65<C59,C59,IF(C65>C61,C61,C65))","v":30}]
[]
["8.","Auswahl Nuttiefe",null,{"$f":"C82","v":30},{"$f":"IF(D68=C75,\"\",\"H\"&D68)","v":""}]
[null,"Kugelleiste mit Tellerfeder möglich?",{"$f":"AND(C28=1,C36<>4,C44=2,C48=1)","v":false},"Ausführung mit Tellerfeder?"]
[null,"Drehfeldwert bei min. Nuttiefe Kugell. Tellerfeder",{"$f":"C79+(C75-C72)/C77","v":600},{"$f":"OR(AND(C69=TRUE,D89>C91),AND(C69=TRUE,C71=TRUE))","v":false}]
[null,"Kugelleiste mit Tellerfeder notwendig?",{"$f":"C80>C78","v":false}]
[null,"kleinste Nuttiefe (Kugelleiste Tellerfeder)",{"$f":"Artikelstamm!AF6","v":0},{"$f":"IF(C69=TRUE,\"(\"&C72&\")\",\"\")","v":""}]
[null,"kleinste Nuttiefe (Standard)",{"$f":"IF(C48=1,Artikelstamm!AD6,Artikelstamm!AE6)","v":29.5}]
[null,"kleinste Nuttiefe",{"$f":"IF(D70=TRUE,C72,C73)","v":29.5}]
[null,"Standardnuttiefe",{"$f":"Artikelstamm!AG6","v":30}]
[null,"größte Nuttiefe",{"$f":"IF(C103=1,Artikelstamm!AG6,Artikelstamm!AH6)","v":30}]
[null,"Schrittweite (mm)",{"$f":"Artikelstamm!AI6","v":0.1}]
[null,"Drehfeldwert bei min. Nuttiefe Kugell. Standard (Druckfeder)",{"$f":"C79+(C75-C73)/C77","v":305}]
[null,"Mittelwert Drehfeld",300,"0-460"]
[null,"Wert aus Drehfeld",300]
[null,"Berechnung Nuttiefe",{"$f":"IF(C80=C79,C75,C75-((C80-C79)*C77))","v":30}]
[null,"Nuttiefe innerhalb Grenzen kleinste/größte",{"$f":"IF(C81<C74,C74,IF(C81>C76,C76,C81))","v":30}]
[]
["9.1","Betriebsdruck",{"$f":"AND(C85<=C87,C85>=0)","v":true},{"$f":"ROUNDDOWN(IF(C44=1,IF(C84=TRUE,C85,C87),0),0)","v":100}]
[null,"gewünschter Betriebsdruck (bar)",{"$f":"ROUND(Eingabe!G30,0)","v":100}]
[null,"mögliche Druckreduzierung wg. Temperatur auf (bar)",{"$f":"C128*C87/C119","v":100},{"$f":"IF(C86=C87,\"\",CEILING(C86,5))","v":""}]
[null,"max. Betriebsdruck (=Standard) (bar)",{"$f":"Artikelstamm!AC6","v":100}]
[]
["9.2","max. Einsatztemperatur",{"$f":"IF(AND(C94>=C90,C94<=C93),C96&\" °C\",'Text - Sprache'!Q23&\"!\")","v":"100 °C"},{"$f":"IF(AND(C94>=C90,C94<=C93),C96,\"high\")","v":100},{"$f":"IF(D89<=C91,Artikelstamm!M6,IF(AND(D89>C91,D89<=C92),Artikelstamm!N6,Artikelstamm!O6))","v":60}]
[null,"untere Grenztemperatur °C",{"$f":"Artikelstamm!E37","v":0}]
[null,"Standardeinsatztemperatur bis",{"$f":"Artikelstamm!E39","v":100},{"$f":"AND(C94>=C90,C94<=C91)","v":true}]
[null,"Grenztemperatur VITON",{"$f":"Artikelstamm!E40","v":200},{"$f":"AND(C94>C91,C94<=C92)","v":false}]
[null,"Grenztemperatur KALREZ",{"$f":"Artikelstamm!E41","v":250},{"$f":"AND(C94>C92,C94<=C93)","v":false}]
[null,"Wunschtemperatur",{"$f":"IF(Einstellungen!B10=FALSE,C91,ROUND(Eingabe!G38,0))","v":100}]
[]
[null,"max Einsatztemperatur",{"$f":"IF(D124=TRUE,C124,IF(D125=TRUE,C125,IF(D126=TRUE,C126,IF(D127=TRUE,C127,0))))","v":100}]
[null,"Wunschtemperatur ausserhalb zul. Temperaturbereich",{"$f":"C90&\" - \"&C93&\" °C\"","v":"0 - 250 °C"},{"$f":"OR(C94<C90,C94>C93)","v":false}]
[null,"Kolbendichtung",{"$f":"IF(D91=TRUE,C99,IF(D92=TRUE,C100,IF(D93=TRUE,C101,\"\")))","v":"NBR"},{"$f":"IF(C98=C99,A99,IF(C98=C100,A100,A101))","v":1}]
[1,"N",{"$f":"Artikelstamm!D39","v":"NBR"},{"$f":"IF(C98=C99,B99,IF(C98=C100,B100,B101))","v":"N"}]
[2,"V",{"$f":"Artikelstamm!D40","v":"FKM"}]
[3,"K",{"$f":"Artikelstamm!D41","v":"FFKM"}]
[]
["9.3","Gehäusematerial",1,{"$f":"INDEX(B104:B105,C103)","v":"Aluminium"},{"$f":"IF(AND(C103=1,D70=TRUE),Artikelstamm!L6,IF(AND(C103=1,D70=FALSE),E48,E89))","v":71}]
[1,{"$f":"IF(C94>C91,\"\",Artikelstamm!E54)","v":"Aluminium"},"Text Deutsch",{"$f":"IF(C103=1,'Text - Sprache'!D39,'Text - Sprache'!E39)","v":"Aluminium"}]
[2,{"$f":"IF(Einstellungen!B10=TRUE,Artikelstamm!E55,\"\")","v":"Stahl"},"Material",{"$f":"IF(C103=1,Artikelstamm!F54,Artikelstamm!F55)","v":"AlMgSi 0,7 (F27)"}]
[]
[]
[]
[]
[null,"Abstände der Inserts",{"$f":"IF(C28=1,'Text - Sprache'!F23,'Text - Sprache'!G23)","v":"Kugeleinsatz"}]
[null,"Abstand 1.-2. Insert",null,{"$f":"IF(D112<Artikelstamm!U6,Artikelstamm!U6,D112)","v":30}]
[null,"Abstand weitere Inserts",null,{"$f":"D58","v":30}]
[]
[null,"Anzahl Inserts",{"$f":"ROUNDDOWN(((D25-Artikelstamm!S6-Artikelstamm!T6-D111)/D112),0)+2","v":16},{"$f":"IF(C114<C115,C115,C114)","v":16}]
[null,"minimale Anzahl Inserts",{"$f":"Artikelstamm!E34","v":3}]
[]
[]
[null,"Tragkraft (abhängig von Einsatztemperatur und Betriebsdruck)"]
[null,"Standardtragkraft (bis 100 °C) je Einsatz kN",{"$f":"Artikelstamm!Z6","v":0.79},1]
[null,{"$f":"\"Tragkraft >\"&Artikelstamm!E48&\" - \"&Artikelstamm!E49&\" °C  je Einsatz kN\"","v":"Tragkraft >100 - 150 °C  je Einsatz kN"},{"$f":"C119*Artikelstamm!E44","v":0.75049999999999994},{"$f":"Artikelstamm!E44","v":0.95}]
[null,{"$f":"\"Tragkraft >\"&Artikelstamm!E49&\" - \"&Artikelstamm!E50&\" °C  je Einsatz kN\"","v":"Tragkraft >150 - 200 °C  je Einsatz kN"},{"$f":"C119*Artikelstamm!E45","v":0.55299999999999994},{"$f":"Artikelstamm!E45","v":0.7}]
[null,{"$f":"\"Tragkraft >\"&Artikelstamm!E50&\" - \"&Artikelstamm!E51&\" °C  je Einsatz kN\"","v":"Tragkraft >200 - 250 °C  je Einsatz kN"},{"$f":"C119*Artikelstamm!E46","v":0.47399999999999998},{"$f":"Artikelstamm!E46","v":0.6}]
[null,"Temperatur min.  °C",{"$f":"Artikelstamm!E37","v":0}]
[null,"Grenztemperatur 1  °C (Standarddichtung)",{"$f":"Artikelstamm!E48","v":100},{"$f":"AND(C94>C123,C94<=C124)","v":true}]
[null,"Grenztemperatur 2  °C (bei gefederten Leisten)",{"$f":"Artikelstamm!E49","v":150},{"$f":"AND(C94>C124,C94<=C125)","v":false}]
[null,"Grenztemperatur 3  °C (VITON)",{"$f":"Artikelstamm!E50","v":200},{"$f":"AND(C94>C125,C94<=C126)","v":false}]
[null,"Temperatur max.  °C (KALREZ)",{"$f":"Artikelstamm!E51","v":250},{"$f":"AND(C94>C126,C94<=C127)","v":false}]
[null,"Tragkraft je Einsatz bei Einsatztemperatur kN",{"$f":"ROUNDDOWN(IF(D124=TRUE,C119,IF(D125=TRUE,C120,IF(D126=TRUE,C121,IF(D127=TRUE,C122,0)))),2)","v":0.79}]
[null,"Tragkraft je Einsatz bei Betriebsdruck",{"$f":"ROUNDDOWN(IF(C44=1,C119/C87*D84,C128),2)","v":0.79}]
[null,"Tragkraft je Einsatz inkl. Temperatur und Betriebsdruck",{"$f":"IF(C44=2,C128,IF(AND(D84<=C87,D84>=D86),C128,C129))","v":0.79}]
[null,"Gesamttragkraft je Leiste bei Einsatztemperatur kN",{"$f":"C130*D114","v":12.64}]
[]
[null,"Ölbedarf","cm³",{"$f":"ROUNDUP((POWER(C134,2)*PI()/4*C135/1000*C136),1)","v":1.6}]
[null,"Ø Kolben",{"$f":"Artikelstamm!AO6","v":10}]
[null,"Hub (+ 0,2 mm \"wahrer Hub\")",{"$f":"D48+0.2","v":1.2}]
[null,"Anzahl Kolben",{"$f":"D114","v":16}]
[]
[null,"Gewicht","kg",{"$f":"ROUND(C150+D114*C139,1)","v":0.9}]
[null,"Gewicht je Insert inkl. Kolben/Federn (kg)",{"$f":"Artikelstamm!AS6","v":2.3E-2}]
[null,"Ø Insertbohrung",{"$f":"Artikelstamm!AM6","v":16}]
[null,"Tiefe Insertbohrung",{"$f":"Artikelstamm!AN6","v":14}]
[null,"Gewicht je Insertbohrung (kg)",{"$f":"ROUNDUP(POWER(C140,2)*PI()/4*(C141+0.4)/1000000*C146,4)","v":7.899999999999999E-3}]
[null,"Ø Kolbenbohrung",{"$f":"Artikelstamm!AO6","v":10}]
[null,"Tiefe Kolbenbohrung (ohne Insertbohrung)",{"$f":"Artikelstamm!AP6-Artikelstamm!AN6","v":10.100000000000001}]
[null,"Gewicht je Kolbenbohrung (kg)",{"$f":"ROUNDUP(POWER(C143,2)*PI()/4*(C144+0.4)/1000000*C146,4)","v":2.3E-3}]
[null,"Dichte des Leistenmaterials (kg/dm³)",{"$f":"IF(C103=1,Artikelstamm!E58,Artikelstamm!E59)","v":2.7},{"$f":"D103","v":"Aluminium"}]
[null,"Ø Ölbohrung",{"$f":"IF(C103=1,Artikelstamm!AT6,Artikelstamm!AV6)","v":5},{"$f":"C147","v":5}]
[null,"Gewicht Ölbohrung (kg)",{"$f":"ROUNDUP(POWER(C147,2)*PI()/4*(D20-Artikelstamm!AL6)/1000000*C146,4)","v":2.63E-2}]
[null,"Gewicht des Leistenkörpers (ohne Kolben/Insert-Bohrungen) (kg)",{"$f":"ROUND(((Artikelstamm!G6)*(D68)*C20/1000000*C146)-C148,4)","v":0.69540000000000002}]
[null,"Gewicht des Leistenkörpers (mit allen Bohrungen) (kg)",{"$f":"C149-D114*(C142+C145)","v":0.53220000000000001},{"$f":"ROUND(C150,2)","v":0.53}]
[]
[null,"Bohrungstiefe Kolbenbohrung","berechnetes Maß","Standardmaß"]
[null,"Kugelleiste 28 hydraulisch",{"$f":"IF(AND(C28=1,C36=3,C44=1),IF(D68<44.5,35.5,D68-9),D153)","v":39},39]
[null,"Kugelleiste 36 hydraulisch",{"$f":"IF(AND(C28=1,C36=4,C44=1),IF(D68<60.7,D68-6,D154),D154)","v":51},51]
[]
[null,"Bohrungstiefe Kolben/Federbohrung",null,{"$f":"IF(D70=TRUE,Artikelstamm!AQ6,Artikelstamm!AP6)","v":24.1}]
[]
[null,"Position Ölbohrung Stahlausführung",{"$f":"C36","v":1},{"$f":"LOOKUP(C158,A160:A165,C160:C165)","v":7}]
[null,{"$f":"\"gewähltes Material: \"&D103","v":"gewähltes Material: Aluminium"},"berechnetes Maß","Standardmaß Alu / Stahl","(Standardmaß Alu)"]
[{"$f":"A37","v":1},"18 mm",{"$f":"IF(D$68<=C$75,D160,D160+(C$82-C$75))","v":7},{"$f":"IF(C$103=1,Artikelstamm!AU8,Artikelstamm!AW8)","v":7},{"$f":"Artikelstamm!AU8","v":7}]
[2,"22 mm",8.5,{"$f":"IF(C$103=1,Artikelstamm!AU9,Artikelstamm!AW9)","v":8.5},{"$f":"Artikelstamm!AU9","v":8.5}]
[3,"28 mm",9,{"$f":"IF(C$103=1,Artikelstamm!AU10,Artikelstamm!AW10)","v":9},{"$f":"Artikelstamm!AU10","v":9}]
[4,"36 mm",10,{"$f":"IF(C$103=1,Artikelstamm!AU11,Artikelstamm!AW11)","v":10},{"$f":"Artikelstamm!AU11","v":10}]
[5,"13/16\"  (20,6 mm)",6.4,{"$f":"IF(C$103=1,Artikelstamm!AU12,Artikelstamm!AW12)","v":6.4},{"$f":"Artikelstamm!AU12","v":6.4}]
[6,"1 1/16\" (27 mm)",9,{"$f":"IF(C$103=1,Artikelstamm!AU13,Artikelstamm!AW13)","v":9},{"$f":"Artikelstamm!AU13","v":9}]
[]
[null,"Position Anschlussgewinde Stahlausführung",{"$f":"C36","v":1},{"$f":"LOOKUP(C167,A169:A174,C169:C174)","v":8}]
[null,null,"berechnetes Maß","Standardmaß Alu"]
[{"$f":"A37","v":1},"18 mm",{"$f":"IF(D$68<=C$75,D169,D169+(C$82-C$75))","v":8},{"$f":"Artikelstamm!AA8","v":8}]
[2,"22 mm",8.5,{"$f":"Artikelstamm!AA9","v":8.5}]
[3,"28 mm",11,{"$f":"Artikelstamm!AA10","v":11}]
[4,"36 mm",11,{"$f":"Artikelstamm!AA11","v":11}]
[5,"13/16\"  (20,6 mm)",8,{"$f":"Artikelstamm!AA12","v":8}]
[6,"1 1/16\" (27 mm)",11,{"$f":"Artikelstamm!AA13","v":11}]
[]
[null,"Anzahl Tellerfedern (gesamt)",null,{"$f":"IF(OR(C178=TRUE,C179=TRUE),C177*D114,0)","v":0}]
[null,"Anzahl T-Federn je Paket",{"$f":"Artikelstamm!BA6","v":0}]
[null,"Kugelleiste mit Tellerfedern?",{"$f":"AND(C28=1,C44=2,OR(D70=TRUE,C36=4))","v":false}]
[null,"Rollenleiste gefedert?",{"$f":"AND(C28=2,C44=2)","v":false}]
[]
[null,"Konfigurationszeitstempel",{"$f":"NOW()","v":"2017-04-18T10:33:42.870"},{"$f":"TEXT(C181,\"TT.MM.JJJ hh:mm:ss\")","v":"18.04.2017 10:33:43"}]
[]
[]
["für Zeichnung"]
[null,"Schraubenlänge (gefederte Leisten)",{"$f":"C186-C187+C188","v":30},{"$f":"IF(AND(C185<15,C185>=12),12,IF(AND(C185>12,C185<20),16,FLOOR(C185,5)))","v":30}]
[null,"Leistenhöhe",{"$f":"D68","v":30}]
[null,"Senkungstiefe",{"$f":"Artikelstamm!BI6","v":0}]
[null,"Gewindetiefe",{"$f":"Artikelstamm!BK6","v":0}]
[]
["für Zeichnung"]
[null,"Toleranz Leistenhöhe angehoben (inkl. Einsatz)","obere Toleranz",{"$f":"C196+C194","v":0.2}]
[null,null,"untere Toleranz",{"$f":"C195+C193","v":-0.2}]
[null,"untere Hubtoleranz",{"$f":"Artikelstamm!BU6","v":0.2}]
[null,"obere Hubtoleranz",{"$f":"Artikelstamm!BV6","v":0.4}]
[null,"untere Leistenhöhentoleranz",{"$f":"Artikelstamm!BO6","v":-0.4}]
[null,"obere Leistenhöhentoleranz",{"$f":"Artikelstamm!BN6","v":-0.2}]
[]
["für Zeichnung"]
[null,"Schraubenlänge für Riegel (hydraulische Leisten)",{"$f":"C200+C201","v":13},{"$f":"IF(AND(C199<15,C199>=12),12,IF(AND(C199>12,C199<20),16,FLOOR(C199,5)))","v":12}]
[null,"Gewindetiefe",{"$f":"Artikelstamm!BE6","v":8}]
[null,"Riegeldicke",5]

{"sheet":"Text - Sprache","index":8,"n_rows":89,"n_cols":18,"rows_kept":89,"cut":false,"hidden":true,"merged":[[73,0,88,0],[1,0,16,0],[19,0,34,0],[37,0,52,0],[55,0,70,0]]}
[]
["A",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Sprache",{"$f":"C7","v":"Auswahl"},{"$f":"D7","v":"Eingabe"},{"$f":"E7","v":"Ergebnis"},{"$f":"F7","v":"Kugelleiste"},{"$f":"G7","v":"Rollenleiste"},"Betätigungsart","hydraulisch","gefedert","Befestigung","Riegel","Schraube","Klemmschloss","Nutbreite","Nuttiefe","Leistenlänge","gewünschte Leistenlänge"]
[null,{"$f":"\"SA\"&B2","v":"SA1"},{"$f":"\"SA\"&C2","v":"SA2"},{"$f":"\"SA\"&D2","v":"SA3"},"SA4","SA5","SA6","SA7","SA8","SA9","SA10","SA11","SA12","SA13","SA14","SA15","SA16","SA17"]
[null,{"$f":"Berechnung!D7","v":"Deutsch"},{"$f":"DGET($B6:C17,C2,$B4:$B5)","v":"Auswahl"},{"$f":"DGET($B6:D17,D2,$B4:$B5)","v":"Eingabe"},{"$f":"DGET($B6:E17,E2,$B4:$B5)","v":"Ergebnis"},{"$f":"DGET($B6:F17,F2,$B4:$B5)","v":"Kugelleiste"},{"$f":"DGET($B6:G17,G2,$B4:$B5)","v":"Rollenleiste"},{"$f":"DGET($B6:H17,H2,$B4:$B5)","v":"Betätigungsart"},{"$f":"DGET($B6:I17,I2,$B4:$B5)","v":"hydraulisch"},{"$f":"DGET($B6:J17,J2,$B4:$B5)","v":"gefedert"},{"$f":"DGET($B6:K17,K2,$B4:$B5)","v":"Befestigung"},{"$f":"DGET($B6:L17,L2,$B4:$B5)","v":"Riegel"},{"$f":"DGET($B6:M17,M2,$B4:$B5)","v":"Schraube"},{"$f":"DGET($B6:N17,N2,$B4:$B5)","v":"Klemmschloss"},{"$f":"DGET($B6:O17,O2,$B4:$B5)","v":"Nutbreite"},{"$f":"DGET($B6:P17,P2,$B4:$B5)","v":"Nuttiefe"},{"$f":"DGET($B6:Q17,Q2,$B4:$B5)","v":"Leistenlänge"},{"$f":"DGET($B6:R17,R2,$B4:$B5)","v":"gewünschte Leistenlänge"}]
[null,{"$f":"B4","v":"SA1"},{"$f":"C4","v":"SA2"},{"$f":"D4","v":"SA3"},{"$f":"E4","v":"SA4"},"SA5","SA6","SA7","SA8",{"$f":"J4","v":"SA9"},"SA10","SA11","SA12","SA13","SA14","SA15","SA16","SA17"]
[null,"Deutsch","Auswahl","Eingabe","Ergebnis","Kugelleiste","Rollenleiste","Betätigungsart","hydraulisch","gefedert","Befestigung","Riegel","Schraube","Klemmschloss","Nutbreite","Nuttiefe","Leistenlänge","gewünschte Leistenlänge"]
[null,"English","Selection","Input","Output","Ball bar","Roller bar","Actuation","hydraulic","spring loaded","Fastening","Fastening plate","Screw","Wedge lock","Slot width","Slot depth","Bar lenght","desired bar lenght"]
[null,"Italiano","Selezione","Inserimento","Risultato","Guida a sfere","Guida a rulli","Azionamento","idraulico","a molle","Fissaggio","Piastrina di fissaggio","Vite","Cuneo di fissaggio","Larghezza cava","Profondità cava","Lunghezza guida","Lunghezza guida desiderata"]
[null,"Français","Sélection","Entrée","Résultat","Tasseau à billes","Tasseau à rouleaux","Mode opératoire","hydraulique","chargé par ressort","Fixation","Plaque de fixation","Vis","Verrou","Largeur de la rainure","Profondeur de la rainure","Longueur du tasseau","Longeur du tasseau désirée"]
[null,"Español","Selección","Entrada","Résultado","Regleta de bolas","Regleta de rodillos","Modo operativo","idraúlico","con muelle","Fijación","Placa de fijación","Tornillo","Cerrojo","Ancho de la ranura","aaprofundid de la ranura","Longitud de la regleta","Longitud deseada de la regleta"]
[null,"Polski","Wybierz","Wprowadź","Wynik","Listwy kulkowe","Listwy rolkowe","Sterowanie","Hydrauliczne","Sprężynowe","Zamocowanie","Rygiel","Śruba","Zamek klinowy","Szerokość rowka","Głębokość rowka","Długość listwy","Oczeiwana długość listwy"]
[null,"한국어","선택","입력","결과","볼 바","롤러 바","작동","유압식","스프링력","고정","고정판","스크류","웨지(쐐기) 잠금","슬롯 너비","슬롯 깊이","바 길이","희망 바 길이"]
[]
[]
[]
[]
[]
[]
["B",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Sprache",{"$f":"C25","v":"Hub"},"Kugelabstand","Rollenabstand","Kugeleinsatz","Rolleneinsatz","Tragkraft pro Einsatz","Gesamttragkraft","Sprache","Rollenausrichtung",{"$f":"L25","v":"Tellerfedern"},"Variante mit","Betriebsdruck","Druck zu hoch!","Einsatztemperatur","unzulässige Temperatur","Optionen"]
[null,{"$f":"\"SB\"&B20","v":"SB1"},{"$f":"\"SB\"&C20","v":"SB2"},"SB3","SB4","SB5","SB6","SB7","SB8","SB9","SB10","SB11","SB12","SB13","SB14","SB15","SB16","SB17"]
[null,{"$f":"B5","v":"Deutsch"},{"$f":"DGET($B24:C35,C20,$B22:$B23)","v":"Hub"},{"$f":"DGET($B24:D35,D20,$B22:$B23)","v":"Kugelabstand"},{"$f":"DGET($B24:E35,E20,$B22:$B23)","v":"Rollenabstand"},{"$f":"DGET($B24:F35,F20,$B22:$B23)","v":"Kugeleinsatz"},{"$f":"DGET($B24:G35,G20,$B22:$B23)","v":"Rolleneinsatz"},{"$f":"DGET($B24:H35,H20,$B22:$B23)","v":"Tragkraft pro Einsatz"},{"$f":"DGET($B24:I35,I20,$B22:$B23)","v":"Gesamttragkraft"},{"$f":"DGET($B24:J35,J20,$B22:$B23)","v":"Sprache"},{"$f":"DGET($B24:K35,K20,$B22:$B23)","v":"Rollenausrichtung"},{"$f":"DGET($B24:L35,L20,$B22:$B23)","v":"Tellerfedern"},{"$f":"DGET($B24:M35,M20,$B22:$B23)","v":"Variante mit"},{"$f":"DGET($B24:N35,N20,$B22:$B23)","v":"Betriebsdruck"},{"$f":"DGET($B24:O35,O20,$B22:$B23)","v":"Druck zu hoch!"},{"$f":"DGET($B24:P35,P20,$B22:$B23)","v":"Einsatztemperatur"},{"$f":"DGET($B24:Q35,Q20,$B22:$B23)","v":"unzulässige Temperatur"},{"$f":"DGET($B24:R35,R20,$B22:$B23)","v":"Optionen"}]
[null,{"$f":"B22","v":"SB1"},"SB2","SB3","SB4","SB5","SB6","SB7","SB8","SB9","SB10","SB11","SB12","SB13","SB14","SB15","SB16","SB17"]
[null,{"$f":"B7","v":"Deutsch"},"Hub","Kugelabstand","Rollenabstand","Kugeleinsatz","Rolleneinsatz","Tragkraft pro Einsatz","Gesamttragkraft","Sprache","Rollenausrichtung","Tellerfedern","Variante mit","Betriebsdruck","Druck zu hoch!","Einsatztemperatur","unzulässige Temperatur","Optionen"]
[null,{"$f":"B8","v":"English"},"Stroke","Distance of balls","Distance of rollers","Ball insert","Roller insert","Load capacity per insert","Total load capacity","Language","Roller orientation","disc springs","version with","Operating pressure","Pressure to high!","Operation temperature","invalid temperatur","Options"]
[null,{"$f":"B9","v":"Italiano"},"Corsa","Distanza fra le sfere","Distanza fra i rulli","Inserto a sfera","Inserto a rullo","Cpacità di carico per inserto","Capacità di carico totale","Lingua","Orientamento dei rulli","molle a tazza","variante con","Pressione di esercizio","Pressione troppo elevata!","Temperatura di funzionamento","temperatura non valida","Opzioni"]
[null,"Français","Course","Ecart des billes","Ecart des rouleaux","Insert à billes","Insert à rouleaux","Force portante par insert","Force portante totale","Langue","Orientation des rouleaux","Rondelles Belleville","Version avec","Pression d'utilisation","Pression trop élevée !","Température d'utilisation","Température inadmissible","Options"]
[null,"Español","Carrera","Espacio  de las bolas","Espacio de los rodillos","Inserto para bolas","Inserto para rodillos","Capacidad de carga / inserto","Capacidad de cargo total","Lengua","Orientación de los rodillos","Resortes Belleville","Versión con","Presión de trabajo","Presión demasiado alta","Temperatura de trabajo","Temperatura no es válida","Opciones"]
[null,"Polski","Skok","Rozstaw kulek","Rozstaw rolek","Wkład kulkowy","Wkład rolkowy","Nośność / wkład","Nośność całkowita","Język","Kierunek rolek","Sprężyny talerzowe","Wersja z ","Ciśnienie zasilania","Ciśnienie za wysokie!","Temperatura pracy","Niedopuszczalna temeratura","Opcje"]
[null,"한국어","스트로크","볼의 거리","롤러의 거리","볼 인써트","롤러 인써트","인써트 하중용량","총 하중용량","언어","롤러 방향","접시 스프링","버전","작동 압력","압력이 높다!","작동 온도","허용하지 않은 온도","옵션"]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[]
["C",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Sprache",{"$f":"C43","v":"Gehäusematerial"},{"$f":"D43","v":"Aluminium"},{"$f":"E43","v":"Stahl"},"Kolbendichtung","Anschlussgewinde","inkl.","Verschlussschraube","reduzierter Betriebsdruck","empfohlen",{"$f":"L43","v":"Ölbedarf"},"Masse","Zeichnungsnummer","Bearbeiter","nicht verfügbar","Bearbeiter eintragen!","keine Berechtigung!"]
[null,{"$f":"\"SC\"&B38","v":"SC1"},{"$f":"\"SC\"&C38","v":"SC2"},"SC3","SC4","SC5","SC6","SC7","SC8","SC9","SC10","SC11","SC12","SC13","SC14","SC15","SC16","SC17"]
[null,{"$f":"B5","v":"Deutsch"},{"$f":"DGET($B42:C53,C38,$B40:$B41)","v":"Gehäusematerial"},{"$f":"DGET($B42:D53,D38,$B40:$B41)","v":"Aluminium"},{"$f":"DGET($B42:E53,E38,$B40:$B41)","v":"Stahl"},{"$f":"DGET($B42:F53,F38,$B40:$B41)","v":"Kolbendichtung"},{"$f":"DGET($B42:G53,G38,$B40:$B41)","v":"Anschlussgewinde"},{"$f":"DGET($B42:H53,H38,$B40:$B41)","v":"inkl."},{"$f":"DGET($B42:I53,I38,$B40:$B41)","v":"Verschlussschraube"},{"$f":"DGET($B42:J53,J38,$B40:$B41)","v":"reduzierter Betriebsdruck"},{"$f":"DGET($B42:K53,K38,$B40:$B41)","v":"empfohlen"},{"$f":"DGET($B42:L53,L38,$B40:$B41)","v":"Ölbedarf"},{"$f":"DGET($B42:M53,M38,$B40:$B41)","v":"Masse"},{"$f":"DGET($B42:N53,N38,$B40:$B41)","v":"Zeichnungsnummer"},{"$f":"DGET($B42:O53,O38,$B40:$B41)","v":"Bearbeiter"},{"$f":"DGET($B42:P53,P38,$B40:$B41)","v":"nicht verfügbar"},{"$f":"DGET($B42:Q53,Q38,$B40:$B41)","v":"Bearbeiter eintragen!"},{"$f":"DGET($B42:R53,R38,$B40:$B41)","v":"keine Berechtigung!"}]
[null,{"$f":"B40","v":"SC1"},{"$f":"C40","v":"SC2"},{"$f":"D40","v":"SC3"},{"$f":"E40","v":"SC4"},{"$f":"F40","v":"SC5"},{"$f":"G40","v":"SC6"},"SC7","SC8","SC9","SC10","SC11","SC12",{"$f":"N40","v":"SC13"},{"$f":"O40","v":"SC14"},{"$f":"P40","v":"SC15"},{"$f":"Q40","v":"SC16"},{"$f":"R40","v":"SC17"}]
[null,{"$f":"B7","v":"Deutsch"},"Gehäusematerial","Aluminium","Stahl","Kolbendichtung","Anschlussgewinde","inkl.","Verschlussschraube","reduzierter Betriebsdruck","empfohlen","Ölbedarf","Masse","Zeichnungsnummer","Bearbeiter","nicht verfügbar","Bearbeiter eintragen!","keine Berechtigung!"]
[null,{"$f":"B8","v":"English"},"Material of housing","aluminium","steel","Piston sealing","Connecting thread","incl.","Plug screw","reduced operating pressure","recommended","Oil consumption","Weight","Drawing number","editor","not available","fill in editor!","no authorization!"]
[null,{"$f":"B9","v":"Italiano"},"Materiale del corpo esterno","alluminio","acciaio","Guarnizioni pistone","Filettatura raccordo","incl.","Tappo a vite","pressione di esercizio ridotta","raccomandata","Consumo olio","Peso","No. Disegno","utente","indisponibile ","Inserisci l'utente","nessuna autorizzazione"]
[null,"Français","Matériau du carter","Aluminium","Acier","Garniture de piston","Filetage de raccordement incl.","incl.","Vis de fermeture","Pression d'utilisation réduite","recommandée","Consommation d'huile","Poids","N°. de plan","Editeur","pas disponible","remplir dans l'éditeur!","aucune autorisation!"]
[null,"Español","Material del cárter","Aluminio","Acero","Empaque del pistón","Rosca de conexión","incl.","Tornillo de cierre","Presión de trabajo reducida","recomendada","Consumo ólio","Peso","No. dibujo ","Editor","no disponible","llenar en el editor!","sin autorización!"]
[null,"Polski","Materiał obudowy","Aluminium","Stal","Uszczelnienie tłoków","Gwint przyłączeniowy","zawiera","śrubunek","Zmniejszyć ciśnienie","zalecenie","Zapotrzebowanie oleju","Masa","Nr rysunku","Edytor","nie dostępne","wypełnić w edytorze!","brak uprawnień!"]
[null,"한국어","하우징 재질","알루미늄","스틸","피스톤 씰링","연결 나사","포함","플러그 스크류","작동 압력 감소","추천","기름 소비량","무게","도면 번호","편집자","이용 불가능","편집자를 쓰시오!","권한 없음!"]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[]
["D",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Sprache",{"$f":"C61","v":"keine gültige Musternummer!"},{"$f":"D61","v":"zuerst PDF erzeugen!"},"Listenpreis","Preisbasis","Preisgruppe","Es sind bereits PDF-Dokumente vorhanden!","Sollen diese ersetzt werden?","PDF erstellen","Abbruch","Konfiguration einlesen","Konfiguration","Vorgang erfolgreich abgeschlossen","Es ist ein Fehler aufgetreten!","Bitte warten…","Merkmalsausprägung","Währungsfaktor"]
[null,{"$f":"\"SD\"&B56","v":"SD1"},{"$f":"\"SD\"&C56","v":"SD2"},"SD3","SD4","SD5","SD6","SD7","SD8","SD9","SD10","SD11","SD12","SD13","SD14","SD15","SD16","SD17"]
[null,{"$f":"B5","v":"Deutsch"},{"$f":"DGET($B60:C71,C56,$B58:$B59)","v":"keine gültige Musternummer!"},{"$f":"DGET($B60:D71,D56,$B58:$B59)","v":"zuerst PDF erzeugen!"},{"$f":"DGET($B60:E71,E56,$B58:$B59)","v":"Listenpreis"},{"$f":"DGET($B60:F71,F56,$B58:$B59)","v":"Preisbasis"},{"$f":"DGET($B60:G71,G56,$B58:$B59)","v":"Preisgruppe"},{"$f":"DGET($B60:H71,H56,$B58:$B59)","v":"Es sind bereits PDF-Dokumente vorhanden!"},{"$f":"DGET($B60:I71,I56,$B58:$B59)","v":"Sollen diese ersetzt werden?"},{"$f":"DGET($B60:J71,J56,$B58:$B59)","v":"PDF erstellen"},{"$f":"DGET($B60:K71,K56,$B58:$B59)","v":"Abbruch"},{"$f":"DGET($B60:L71,L56,$B58:$B59)","v":"Konfiguration einlesen"},{"$f":"DGET($B60:M71,M56,$B58:$B59)","v":"Konfiguration"},{"$f":"DGET($B60:N71,N56,$B58:$B59)","v":"Vorgang erfolgreich abgeschlossen"},{"$f":"DGET($B60:O71,O56,$B58:$B59)","v":"Es ist ein Fehler aufgetreten!"},{"$f":"DGET($B60:P71,P56,$B58:$B59)","v":"Bitte warten…"},{"$f":"DGET($B60:Q71,Q56,$B58:$B59)","v":"Merkmalsausprägung"},{"$f":"DGET($B60:R71,R56,$B58:$B59)","v":"Währungsfaktor"}]
[null,{"$f":"B58","v":"SD1"},{"$f":"C58","v":"SD2"},{"$f":"D58","v":"SD3"},"SD4","SD5","SD6","SD7","SD8","SD9","SD10","SD11","SD12","SD13","SD14","SD15","SD16","SD17"]
[null,{"$f":"B7","v":"Deutsch"},"keine gültige Musternummer!","zuerst PDF erzeugen!","Listenpreis","Preisbasis","Preisgruppe","Es sind bereits PDF-Dokumente vorhanden!","Sollen diese ersetzt werden?","PDF erstellen","Abbruch","Konfiguration einlesen","Konfiguration","Vorgang erfolgreich abgeschlossen","Es ist ein Fehler aufgetreten!","Bitte warten…","Merkmalsausprägung","Währungsfaktor"]
[null,{"$f":"B8","v":"English"},"invalid sample number!","First create PDF!","List price","Issue of prices","Price category","PDF documents already exist!","Should these be replaced?","Create PDF","Abort","read Configuration","Configuration","Operation completed successfully","There was an error!","please wait…","characteristic value","currency factor"]
[null,"Italiano","modello non è un numero valido!","Innanzitutto creare PDF","Listino","Base prezzi","Gruppo Prezzi","I documenti PDF già esistenti!","Questi dovrebbero essere sostituiti?","Creare PDF","Abortire","Leggi di configurazione","Configurazione","Operazione completata con successo","Si è verificato un errore!","Attendere prego ...","Caratteristica espressione","fattore di valuta"]
[null,"Français","invalid sample number!","D'abord créer des PDF!","Prix du catalogue","Base de prix","Groupe de prix","Des documents PDF existent déjà!","Devraient-ils être remplacés?","Créer des PDF","Avorter","Lire la configuration","Configuration","L'opération s'est terminée avec succès","Il y avait une erreur!","S'il vous plaît patienter ...","expression de caractéristique","facteur de devises"]
[null,"Español","invalid sample number!","En primer lugar crear PDF!","Precio de catálogo","Precio base","Precio grupo","Documentos PDF ya existe!","Si estos ser reemplazado?","Crear PDF","Abortar","leer la configuración","Configuración","La operación se realizó con éxito","Hubo un error!","Por favor, espere ...","Característica expresión","factor de moneda"]
[null,"Polski","invalid sample number!","Najpierw stwórz PDF!","Cena cennikowa","Cena bazowa","Grupa cenowa","Dokument PDF już istnieje!","Należy je zastąpić?","Stwórz PDF","Anuluj","Wczytaj konfigurację","Konfiguracja","Operacja zakończona pomyślnie","Napotkano błąd!","Proszę czekać…","Wartość charakterystyczna","współczynnik waluty"]
[null,"한국어","invalid sample number!","먼저 PDF를 생성하십시오!","가격표","발행가","가격표","PDF 파일이 이미 있습니다!","변경하시겠습니까?","PDF 출력","취소","환경설정 실행","환경설정","실행이 완료 되었습니다","오류가 있습니다!","기다려 주십시오…","고유값","통용 화폐"]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[]
["E",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,"Sprache",{"$f":"C79","v":"Währungssymbol"},{"$f":"D79","v":"Faktor (universal)"},"Pflichtfelder","ACHTUNG","Diese Datei enthält Makros! Die Ausführung von Makros wird jedoch verhindert! Bitte stellen Sie sicher, dass Makros ausgeführt werden können!",0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"SE\"&B74","v":"SE1"},{"$f":"\"SD\"&C74","v":"SD2"},"SD3","SD4","SD5","SD6","SD7","SD8","SD9","SD10","SD11","SD12","SD13","SD14","SD15","SD16","SD17"]
[null,{"$f":"B5","v":"Deutsch"},{"$f":"DGET($B78:C89,C74,$B76:$B77)","v":"Währungssymbol"},{"$f":"DGET($B78:D89,D74,$B76:$B77)","v":"Faktor (universal)"},{"$f":"DGET($B78:E89,E74,$B76:$B77)","v":"Pflichtfelder"},{"$f":"DGET($B78:F89,F74,$B76:$B77)","v":"ACHTUNG"},{"$f":"DGET($B78:G89,G74,$B76:$B77)","v":"Diese Datei enthält Makros! Die Ausführung von Makros wird jedoch verhindert! Bitte stellen Sie sicher, dass Makros ausgeführt werden können!"},{"$f":"DGET($B78:H89,H74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:I89,I74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:J89,J74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:K89,K74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:L89,L74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:M89,M74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:N89,N74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:O89,O74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:P89,P74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:Q89,Q74,$B76:$B77)","v":{"$error":"#VALUE!"}},{"$f":"DGET($B78:R89,R74,$B76:$B77)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B76","v":"SE1"},{"$f":"C76","v":"SD2"},{"$f":"D76","v":"SD3"},"SD4","SD5","SD6","SD7","SD8","SD9","SD10","SD11","SD12","SD13","SD14","SD15","SD16","SD17"]
[null,{"$f":"B7","v":"Deutsch"},"Währungssymbol","Faktor (universal)","Pflichtfelder","ACHTUNG","Diese Datei enthält Makros! Die Ausführung von Makros wird jedoch verhindert! Bitte stellen Sie sicher, dass Makros ausgeführt werden können!"]
[null,{"$f":"B8","v":"English"},"currency symbol","factor (universal)","required fields","ATTENTION","This file contains macros! The execution of macros is prevented! Please make sure that macros can be executed!"]
[null,"Italiano","simbolo di valuta","fattore (universale)","campi obbligatori","ATTENZIONE ","Questo file contiene macro! L'esecuzione di macro è impedito! Si prega di assicurarsi che le macro possono essere eseguite!"]
[null,"Français","symbole de la monnaie","facteur (universel)","champs obligatoires","ATTENTION ","Ce fichier contient des macros! L'exécution de macros est empêché! S'il vous plaît assurez que les macros peuvent être exécutées!"]
[null,"Español","símbolo de moneda","factor (universal)","los campos requeridos","ATENCIÓN","Este archivo contiene macros! La ejecución de las macros se impide! Por favor, asegúrese de que las macros se pueden ejecutar!"]
[null,"Polski","Symbol waluty","współczynnik (uniwersalny)","Pole wymagane","UWAGA","Ten plik zawiera makra! Wykonanie makr jest zabezpieczone! Proszę się upewnić, że makra mogą być wykonane!"]
[null,"한국어","통용 화폐","일반적 요소","필요 사항","주의","이 파일은 매크로가 포함되어 있습니다. 매크로 실행은 보호되어 있습니다. 매크로를 실행할 수 있는지 확인하세요."]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"Übergabe","index":9,"n_rows":99,"n_cols":7,"rows_kept":99,"cut":false,"hidden":true,"merged":[[59,6,60,6]]}
[]
[]
[null,"Übergabewerte an PSI-Penta"]
[]
[null,"Diese Werte werden zur Generierung der Stückliste bzw. zur Kalkulation in PSI-Penta benötigt"]
[null,"(werden teilweise auch für die PDF-Zeichnungen benötigt)"]
[null,"B","C","D","E"]
[null,null,"Feldname für Penta + PDF"]
[9]
[10,null,null,100]
[11,null,null,"K"]
[12,null,null,0]
[13,null,"STATUS",2]
[14,null,"NAME"]
[15,null,"KONFNAME"]
[16,null,"BAMUNR",{"$f":"Berechnung!F3","v":"000000000"}]
[17,"Bezeichnung 1","ARTBEZ1",{"$f":"Berechnung!D29&Berechnung!E32&Berechnung!D46&Artikelstamm!P6&\"L\"&Berechnung!D20&Berechnung!E53&\"N\"&Berechnung!D114&LEFT(Berechnung!D104,2)&\"__________\"","v":"KugelleisteH18L498,5RN16Al__________"},null,"max. 30 Zeichen"]
[18,"Bezeichnung 2","ARTBEZ2",{"$f":"Berechnung!C131&\"kN_H\"&Berechnung!D68&\"_G\"&Berechnung!D58&\"_T\"&Berechnung!D89&IF(Berechnung!C44=1,Berechnung!D99&\"_P\"&Berechnung!D84,\"\")&\"__________\"","v":"12,64kN_H30_G30_T100N_P100__________"},null,"max. 30 Zeichen"]
[19,"Konfigurationszeitstempel TT.MM.JJJJ hh:mm:ss","KONFZEIT",{"$f":"Berechnung!D181","v":"18.04.2017 10:33:43"}]
[20,"Zeichnungsnummer / Artikelnummer","ZSB",{"$f":"Berechnung!E3","v":"892177118#000000000"},null,"für die Montagezeichnung der Leiste"]
[21,"Zeichnungsnummer Einbauzeichnung","ZSBE",{"$f":"\"E\"&Berechnung!E3","v":"E892177118#000000000"},null,"Angebots- bzw. Freigabezeichnung für den Kunden"]
[22,"Zeichnungsnummer Fertigungszeichnung","ZNG",{"$f":"Berechnung!D3","v":"504950830#000000000"},null,"für die Fertigungszeichnung des Leistenkörpers"]
[23,"Verpackungsgröße","VERPACK",{"$f":"\"BxHxL= \"&Berechnung!E36&\"x\"&Berechnung!D68&\"x\"&Berechnung!D20","v":"BxHxL= 18x30x498,5"},null,"Einbauhinweis für VERPACK"]
[24,"\"sprechende\" Artikelnummer","ARTNR",{"$f":"Berechnung!D5&Berechnung!E5","v":"892177118L495R"},null,"(bisher verwendet; entspricht Katalogangabe)","beschreibt die Variante vollständig"]
[25]
[26,"Leistenart","LEISTART",{"$f":"Berechnung!D29","v":"Kugelleiste"},{"$f":"Berechnung!C28","v":1},"Kugel- oder Rollenleiste","1 (Kugelleiste) oder 2 (Rollenleiste)"]
[27,"Betätigungsart","BETART",{"$f":"Berechnung!D45","v":"hydraulisch"},{"$f":"Berechnung!C44","v":1},"hydraulisch oder gefedert","1 (hydraulisch) oder 2 (gefedert)"]
[28,"Kugelleiste mit Tellerfedern?","TFED",{"$f":"IF(OR(Berechnung!D70=TRUE,AND(Berechnung!C28=1,Berechnung!C44=2,Berechnung!E36=36)),\"J\",\"N\")","v":"N"},null,"J (mit Tellerfedern) oder N (mit Schraubenfeder)"]
[29,"Befestigung","BEF",{"$f":"Berechnung!D56","v":"Riegel"},{"$f":"Berechnung!C53","v":1},"Riegel bzw. Schraube oder Klemmschloss","1 (Riegel bzw. Schraube) oder 2 (Klemmschloss)"]
[30,"Hub in mm","HUB",{"$f":"Berechnung!D48","v":1},null,"Standard oder vergrößert (mm)"]
[31,"Hub","HUBKEN",null,{"$f":"Berechnung!C48","v":1},null,"1 (Standard) oder 2 (vergrößert)"]
[32,"Nutbreite in mm","NUTBR",{"$f":"Berechnung!D36","v":"18 mm"},{"$f":"Berechnung!E36","v":18},null,"13 (13/16\"), 17 (1 1/16\"), 18 (18mm), 22 (22mm), 28 (28mm), 36 (36mm)"]
[33,"Anzahl der Einsätze","ANZEIN",{"$f":"Berechnung!D114","v":16},null,"(Stück)"]
[34,"Gesamtzahl Tellerfedern","ANZTFED",{"$f":"Berechnung!D176","v":0}]
[35,"Anzahl \"Aufpreis je 100 mm\" >500 mm","ANZAUF",{"$f":"IF(Berechnung!C20-500<0,0,ROUNDUP((Berechnung!C20-500)/100,0))","v":0},null,"(Stück) zur Berechnung Preis Leistenkörper"]
[36,"Leistenlänge >1600?","LEISTEL",{"$f":"Berechnung!C20>1600","v":false},{"$f":"IF(D36=FALSE,0,1)","v":0},"zur Berechnung Preis Leistenkörper","0 (<=1600) oder 1 (>1600)"]
[37,"Leiste auf Höhe fräsen? (Höhe < Standard)","LEISTEH",{"$f":"Berechnung!D68<Artikelstamm!AG6","v":false},{"$f":"IF(D37=FALSE,0,1)","v":0},"zur Berechnung Preis Leistenkörper","0 (Standardhöhe) oder 1 (Höhe kleiner Standard)"]
[38,"Leistenhöhe > Standard","LEISTEH1",null,{"$f":"IF(Berechnung!D68>Berechnung!C75,1,0)","v":0},"zur Berechnung Preis Leistenkörper Stahl","0 (Standardhöhe oder kleiner) oder 1 (Höhe > Standard)"]
[39,"Leistenmaterial","MAT",{"$f":"Berechnung!D104","v":"Aluminium"},{"$f":"Berechnung!C103","v":1},"Aluminuim oder Stahl","1 (Aluminuim) oder 2 (Stahl)"]
[40,"Gewicht der Leiste ca.","GEWLEIST",{"$f":"Berechnung!D138","v":0.9},null,"(kg)"]
[41,"Gewicht des Leistenkörpers","GEWLKOER",{"$f":"Berechnung!D150","v":0.53},null,"(kg)"]
[42,"Dichtungsmaterial","DICHMAT",{"$f":"Berechnung!C98","v":"NBR"},{"$f":"Berechnung!D98","v":1},"NBR, FKM oder FFKM","1 (Standard NBR) oder 2 (FKM) oder 3 (FFKM)"]
[43]
[44]
[45]
[46]
[47,"Übergabewerte für die PDF-Zeichnungen"]
[48]
[49,"Technische Daten und Angaben"]
[50,"Diese Angaben werden für die Zeichnungen benötigt, könnten aber auch in PSI-Penta verwendet werden, z.B. für den Angebotstext"]
[51]
[52,"Name PDF-Formular Montagezeichnung","ZSBPDF",{"$f":"Berechnung!C5","v":"892X7XX18"},null,"für die Montagezeichnung"]
[53,"Name PDF-Formular Einbauzeichnung","ZSBEPDF",{"$f":"\"E\"&Berechnung!C5","v":"E892X7XX18"},null,"für die Einbauzeichnung"]
[54,"Name PDF-Formular Fertigungszeichnung","ZNGPDF",{"$f":"Berechnung!C3","v":"5049592X7XX18"},null,"für Fertigungszeichnung"]
[55,"Leistenlänge in mm","LLEIST",{"$f":"Berechnung!D20","v":498.5},null,"Gesamtlänge der Leiste inkl. Verschlußschraube (mm)"]
[56,"Länge des Leistenkörpers in mm","LKOER",{"$f":"Berechnung!C20","v":495},null,"(mm) Länge des Fertigungsteils Leistenkörper"]
[57,"Nuttiefe in mm","NUTTIEF",{"$f":"Berechnung!D68","v":30},null,"(mm)"]
[58,"Abstand der Einsätze in mm","ABEIN",{"$f":"Berechnung!D58","v":30},null,"(mm)"]
[59,"Rollenausrichtung","ROLAUS",{"$f":"Berechnung!D33","v":""},{"$f":"Berechnung!E32","v":""},"nur bei Rollenleisten (0° oder 90°), sonst leer","\"leer\" (0°) oder X (90°)"]
[60,"Tragkraft pro Einsatz in kN","FEIN",{"$f":"Berechnung!C130","v":0.79},null,"kN","unter Berücksichtigung von Betriebsdruck \nund Einsatztemperatur"]
[61,"Gesamttragkraft der Leiste in kN","FLEIST",{"$f":"Berechnung!C131","v":12.64},null,"kN bei voller Überdeckung aller Einsätze"]
[62,"Ölbedarf in ccm","OELB",{"$f":"IF(E27=1,Berechnung!D133,0)","v":1.6},null,"cm³ (für vollen Hub)"]
[63,"Betriebsdruck in bar","DRUCK",{"$f":"Berechnung!D84","v":100},null,"bar (kann niedriger als Standard gewählt werden)"]
[64,"reduzierter Betriebsdruck in bar","DRUCKZUL",{"$f":"IF(D67>100,Berechnung!D86,\"\")","v":""},null,"bar, bei hydraulischen Leisten für erhöhte Temperaturen (empfohlen)"]
[65,"Anschlussgewinde","AGEW",{"$f":"Artikelstamm!AB6","v":"G1/8"},null,"bei hydraulischen Leisten"]
[66,"Überstand Verschlussschraube in mm","VERSCH",{"$f":"IF(Berechnung!C44=1,Artikelstamm!AL6)","v":3.5},null,"mm, bei hydraulischen Leisten"]
[67,"max. Einsatztemperatur in °C","EINTEMP",{"$f":"Berechnung!D89","v":100},null,"°C"]
[68]
[69]
[70]
[71]
[72,"Diese Werte werden ausschließlich für die Zeichnungen benötigt"]
[73]
[74,"Maße für die Fertigungszeichnung"]
[75]
[76,"Bohrungstiefe Kolben-/Federbohrung","BOHRTIEF",{"$f":"Berechnung!D156","v":24.1},null,"teilweise abhängig von der Nuttiefe (mm)"]
[77,"Abstand zwischen Einsatz 1 u. 2","ABEIN12",{"$f":"Berechnung!D111","v":30},null,"(mm) kann wg. Klemmschloss vom Abstand der restlichen Einsätze abweichen (Wert Artikelstamm)"]
[78,"Anzahl Einsatzabstände ohne 1. Einsatz","ANABEINO1",{"$f":"D33-2","v":14},null,"(Stück) für hydraulische Leisten"]
[79,"Gesamtmaß vom 2. bis letzten Einsatz","ABEIN2L",{"$f":"D78*D58","v":420},null,"(mm) für hydraulische Leisten"]
[80,"Anzahl Einsatzabstände inkl. 1. Einsatz","ANABEIN",{"$f":"D33-1","v":15},null,"(Stück) für gefederte Leisten"]
[81,"Gesamtmaß vom 1. bis letzten Einsatz","ABEIN1L",{"$f":"D80*D58","v":450},null,"(mm) für gefederte Leisten"]
[82,"Position Ölbohrung Stahlausführung","POSOEL",{"$f":"Berechnung!D158","v":7},null,"(mm) für Stahlleisten mit Nuttiefe > Standard"]
[83,"Position Anschlussgewinde Stahlausführung","POSAGEW",{"$f":"Berechnung!D167","v":8},null,"(mm) für Stahlleisten mit Nuttiefe > Standard"]
[84,"Durchmesser Ölbohrung","DOEL",{"$f":"Berechnung!D147","v":5},null,"(mm) unterschiedliche Abmessungen Alu/Stahl"]
[85]
[86,"Texte zum Eintragen in die PDF-Zeichnungen"]
[87]
[88,"Material des Leistenkörpers","MATLKOER",{"$f":"Berechnung!D105","v":"AlMgSi 0,7 (F27)"}]
[89,"Artikelnummer Rohmaterial","NRROH",{"$f":"IF(Berechnung!C103=1,Artikelstamm!AZ6,\"\")","v":404950706},null,"nur für Stangenmaterial Aluminium"]
[90,"Kenner Befestigung","BEFKEN",{"$f":"Berechnung!E53","v":"R"},null,"R (Riegel) oder S (Schraube) oder K (Klemmschloss)"]
[91,"Datum","DAT",{"$f":"TEXT(Berechnung!C181,\"TT.MM.JJJ\")","v":"18.04.2017"},null,"Datum der Erstellung"]
[92,"Typ-Nr.","TYPNR",{"$f":"Berechnung!F5","v":"9217-7118"}]
[93]
[94,"Werte zur Steuerung von Optionsfelden in den PDF-Zeichnungen"]
[95]
[96,"Befestigung Riegel / Schraube?","RIESCHR",{"$f":"IF(Berechnung!C53=1,\"JA\",\"NEIN\")","v":"JA"},null,"JA (Riegel/Schraube) oder NEIN (Klemmschloss)"]
[97,"Rollenausrichtung 90°?","ROLAUS90",{"$f":"IF(Berechnung!C32=TRUE,\"JA\",\"NEIN\")","v":"NEIN"},null,"JA (90°) oder NEIN (0°), nur für Rollenleiste"]
[98]
[99]

{"sheet":"PSIPENTA","index":10,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Übergabe Penta",null,"Dateiname:","892-APP.xls",null,null,null,"Konfiguration","Konfigurationswerte"]
["Konfigurationswerte",null,{"$f":"COUNTA(D4:D45)+3","v":3},null,null,"aktuelle Konfiguration",null,"Standardwerte","aus PSI-Penta"]
["\"",null,null,"Zelle (VBA)","Bennennung","Inhalt",null,null,9]
[4,null,null,null,"1. Leistenlänge",{"$f":"Eingabe!C11","v":500},null,500,500]
[5,null,null,null,"2. Auswahl Kugel- / Rollenleiste",{"$f":"Berechnung!C28","v":1},null,1,1]
[6,null,null,null,"2.1 Rollenausrichtung",{"$f":"Berechnung!C32","v":false},null,false,false]
[7,null,null,null,"3. Nutbreite",{"$f":"Berechnung!C36","v":1},null,1,1]
[8,null,null,null,"4. Betätigungsart",{"$f":"Berechnung!C44","v":1},null,1,1]
[9,null,null,null,"5. Hub",{"$f":"Berechnung!C48","v":1},null,1,1]
[10,null,null,null,"6. Befestigung",{"$f":"Berechnung!C53","v":1},null,1,1]
[11,null,null,null,"7. Abstand Einsätze",{"$f":"Berechnung!C64","v":50},null,{"$f":"Berechnung!C63","v":50},50]
[12,null,null,null,"8. Nuttiefe",{"$f":"Berechnung!C80","v":300},null,{"$f":"Berechnung!C79","v":300},150]
[13,null,null,null,"9.1 Betriebsdruck",{"$f":"Eingabe!G30","v":100},null,100,100]
[14,null,null,null,"9.2 Einsatztemperatur",{"$f":"Eingabe!G38","v":100},null,{"$f":"Artikelstamm!E39","v":100},100]
[15,null,null,null,"9.3 Gehäusematerial",{"$f":"Berechnung!C103","v":1},null,1,1]
[16,null,null,null,{"$f":"Übergabe!B9","v":0},{"$f":"IF(Übergabe!D9=0,\"\",Übergabe!D9)","v":""}]
[17,null,null,null,{"$f":"Übergabe!B19","v":"Konfigurationszeitstempel TT.MM.JJJJ hh:mm:ss"}]
[18,null,null,null,{"$f":"Berechnung!B2","v":"PDF-Zeichnungen erzeugt?"},{"$f":"IF(Berechnung!B1=0,\"\",Berechnung!B1)","v":""}]
[19,null,null,null,{"$f":"Übergabe!B10","v":0},{"$f":"Übergabe!D10","v":100},null,100,100]
[20,null,null,null,{"$f":"Übergabe!B11","v":0},{"$f":"Übergabe!D11","v":"K"},null,"K","K"]
[21,null,null,null,{"$f":"Übergabe!B12","v":0},{"$f":"Übergabe!D12","v":0},null,0,0]
[22,null,null,null,{"$f":"Übergabe!B13","v":0},{"$f":"Übergabe!D13","v":2},null,2,2]
[23,null,null,null,{"$f":"Übergabe!B14","v":0},{"$f":"IF(Übergabe!D14=0,\"\",Übergabe!D14)","v":""}]
[24,null,null,null,{"$f":"Übergabe!B15","v":0},{"$f":"IF(Übergabe!D15=0,\"\",Übergabe!D15)","v":""}]
[25,null,null,null,"Dateiname Excelergebnistabelle"]
[26,null,null,null,"Pfad Excelergebnistabelle"]
[27,null,null,null,"Datapool-String PSI-Penta"]