{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Calculation BELT","Calculation SCREW","Blad2","Calculation WV","Information","Blad3"],"not_rendered":{"charts":6,"images":5,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Calculation BELT","index":0,"n_rows":298,"n_cols":80,"rows_kept":298,"merged":[[2,1,2,3],[3,1,3,3],[4,1,4,3],[4,5,4,6],[28,30,28,31],[42,30,42,31],[55,30,55,31],[68,30,68,31],[81,30,81,31],[94,30,94,31],[104,38,106,38],[104,39,106,39],[106,23,106,24],[106,25,106,26],[106,27,106,28],[106,29,106,30],[106,31,106,32],[106,33,106,34],[135,20,135,21],[135,22,135,23]]}
["Linear unit WM",null,null,"Sizing & selection",{"$nulls":4},"2015 03 09 JHj       Release 0"]
["WM60Z  WM80Z",{"$nulls":22},"max stroke",null,"add length C","Min dist carriage LA","Fx max","Fy","Fz","Mx","My","Mz","Frd","Mta","Speed","Acc",null,"Carriage weight","Weight",null," carriage ","Distance between","ball guide carriage",null,"preload","Cz dyn","Cy dyn","Diameter drive pulley","pre-tension belt","C dyn Ball bearing drive shaft","C dyn Ball bearing tension","Idle torque at 150 rpm","½ speed","full speed","Belt weight kg/m","Pulley width drive","Pulley width tension","VWZ",{"$nulls":4},"#"]
["Customer",{"$nulls":38},"0 stroke","100 mm","friction N","Lx","Ly",null,"each carriage","   each carriage",{"$nulls":5},"Nm","Nm","Nm",{"$nulls":3},"kgm²","kgm²/m"]
["Project",{"$nulls":11},2,{"$f":"VLOOKUP(M4,M5:N6,2)","v":"WM80Z"},{"$f":"VLOOKUP(M4,M5:O6,3)","v":"WM08Z170"},null,{"$f":"IF(P16=0,8,IF(AND(M4=1,Q16),1,IF(AND(M4=1,Q16=5),2,M4+Q16)))","v":4},{"$f":"VLOOKUP($Q$4,$Q$5:R12,R13)","v":"WM80Z- S"},{"$f":"VLOOKUP($Q$4,$Q$5:S12,S13)","v":"S = Single short carriage"},null,{"$f":"VLOOKUP($Q$4,$Q$5:U12,U13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:V12,V13)","v":"S"},null,{"$f":"VLOOKUP($Q$4,$Q$5:X12,X13)","v":5500},{"$f":"VLOOKUP($Q$4,$Q$5:Y12,Y13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:Z12,Z13)","v":490},{"$f":"VLOOKUP($Q$4,$Q$5:AA12,AA13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AB12,AB13)","v":1230},{"$f":"VLOOKUP($Q$4,$Q$5:AC12,AC13)","v":2100},{"$f":"VLOOKUP($Q$4,$Q$5:AD12,AD13)","v":2100},{"$f":"VLOOKUP($Q$4,$Q$5:AE12,AE13)","v":68},{"$f":"VLOOKUP($Q$4,$Q$5:AF12,AF13)","v":135},{"$f":"VLOOKUP($Q$4,$Q$5:AG12,AG13)","v":135},{"$f":"VLOOKUP($Q$4,$Q$5:AH12,AH13)","v":600},{"$f":"VLOOKUP($Q$4,$Q$5:AI12,AI13)","v":40},{"$f":"VLOOKUP($Q$4,$Q$5:AJ12,AJ13)","v":5},{"$f":"VLOOKUP($Q$4,$Q$5:AK12,AK13)","v":20},{"$f":"VLOOKUP($Q$4,$Q$5:AL12,AL13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AM12,AM13)","v":2.1},{"$f":"VLOOKUP($Q$4,$Q$5:AN12,AN13)","v":9.2},{"$f":"VLOOKUP($Q$4,$Q$5:AO12,AO13)","v":0.8},{"$f":"VLOOKUP($Q$4,$Q$5:AP12,AP13)","v":22.5},{"$f":"VLOOKUP($Q$4,$Q$5:AQ12,AQ13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AR12,AR13)","v":48.75},{"$f":"VLOOKUP($Q$4,$Q$5:AS12,AS13)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AT12,AT13)","v":400},{"$f":"VLOOKUP($Q$4,$Q$5:AU12,AU13)","v":35838},{"$f":"VLOOKUP($Q$4,$Q$5:AV12,AV13)","v":37446},{"$f":"VLOOKUP($Q$4,$Q$5:AW12,AW13)","v":54.11268065124442},{"$f":"VLOOKUP($Q$4,$Q$5:AX12,AX13)","v":1470},{"$f":"VLOOKUP($Q$4,$Q$5:AY12,AY13)","v":13800},{"$f":"VLOOKUP($Q$4,$Q$5:AZ12,AZ13)","v":8060},{"$f":"VLOOKUP($Q$4,$Q$5:BA12,BA13)","v":4},{"$f":"VLOOKUP($Q$4,$Q$5:BB12,BB13)","v":5.4},{"$f":"VLOOKUP($Q$4,$Q$5:BC12,BC13)","v":6.2},{"$f":"VLOOKUP($Q$4,$Q$5:BD12,BD13)","v":0.14},{"$f":"VLOOKUP($Q$4,$Q$5:BE12,BE13)","v":75},{"$f":"VLOOKUP($Q$4,$Q$5:BF12,BF13)","v":30},{"$f":"VLOOKUP($Q$4,$Q$5:BG12,BG13)","v":0.0024},{"$f":"VLOOKUP($Q$4,$Q$5:BH12,BH13)","v":0.003},{"$f":"VLOOKUP($Q$4,$Q$5:BI12,BI13)","v":0}]
["Date",{"$nulls":3},"Ref:","xxx",{"$nulls":6},1,"WM60Z","WM06Z120",null,1,"WM60Z - S","S = Single short carriage",null,null,"S",null,{"v":4000,"d":"4,000"},null,420,0,{"$f":"IF(C52<2.5,850-C52/2.5*300,550)","v":670},1400,{"$f":"AC5","v":1400},25,50,{"$f":"AF5","v":50},150,17,2.5,20,null,1.25,4.3,0.45,18,0,35,null,300,{"$f":"2*11934","v":23868},{"$f":"2*12964","v":25928},{"$f":"120/PI()","v":38.197186342054884},850,7280,4230,1.6,2.5,3,0.074,55,25,0.00024,0.0008]
[{"$nulls":12},2,"WM80Z","WM08Z170",null,2,"WM60Z- Y","Y = Double short carriages",null,null,"Y",null,{"v":4000,"d":"4,000"},null,{"$f":"G18+Z5","v":920},255,{"$f":"$AB$5","v":670},2800,{"$f":"AC6","v":2800},50,{"$f":"1.4*G18","v":700},{"$f":"AF6","v":700},150,17,2.5,20,null,2.5,4.3,0.45,36,{"$f":"G18","v":500},35,null,300,{"$f":"2*11934","v":23868},{"$f":"2*12964","v":25928},{"$f":"120/PI()","v":38.197186342054884},850,7280,4230,{"$f":"0.3+BA5","v":1.9000000000000001},{"$f":"0.4+BB5","v":2.9},{"$f":"0.5+BC5","v":3.5},0.074,55,25,0.00024,0.0008]
["Linear drive unit:",{"$nulls":15},3,"WM80Z- N","N = Single standard carriage",null,null,"N",null,{"v":5400,"d":"5,400"},null,590,0,{"$f":"IF(C52<2.5,1470-C52/2.5*400,1070)","v":1230},3000,3000,150,300,300,600,40,5,20,null,3.4,11.2,0.8,25,154,48.75,null,600,{"$f":"4*13739","v":54956},{"$f":"4*14356","v":57424},{"$f":"170/PI()","v":54.11268065124442},1470,13800,8060,6.5,7.7,9.3,0.14,75,30,0.0024,0.003]
[null,"Size",{"$nulls":14},4,"WM80Z- S","S = Single short carriage",null,null,"S",null,{"v":5500,"d":"5,500"},null,490,0,{"$f":"$AB$7","v":1230},2100,2100,68,135,135,600,40,5,20,null,2.1,9.2,0.8,22.5,0,48.75,null,400,{"$f":"2*17919","v":35838},{"$f":"2*18723","v":37446},{"$f":"170/PI()","v":54.11268065124442},1470,13800,8060,4,5.4,6.2,0.14,75,30,0.0024,0.003]
[{"$nulls":16},5,"WM80Z- L","L = Single long carriage",null,null,"L",null,{"v":5400,"d":"5,400"},null,760,0,{"$f":"$AB$7","v":1230},3000,3000,150,750,750,600,40,5,20,null,5.1,11.2,0.8,25,{"$f":"170+154","v":324},48.75,null,600,{"$f":"4*13739","v":54956},{"$f":"4*14356","v":57424},54.11268065124442,1470,13800,8060,6.5,7.7,9.3,0.14,75,30,0.0024,0.003]
[null,"Guidings","  Ball guides",{"$nulls":13},6,"WM80Z- Z","Z = Double standard carriages",null,null,"Z",null,{"v":5400,"d":"5,400"},null,{"$f":"G18+Z7","v":1090},360,1230,6000,6000,300,{"$f":"3*G18","v":1500},1500,600,40,5,20,null,6.8,11.2,0.8,50,{"$f":"G18","v":500},48.75,null,600,{"$f":"4*13739","v":54956},{"$f":"4*14356","v":57424},54.11268065124442,1470,13800,8060,{"$f":"BA7+0.6","v":7.1},{"$f":"BB7+0.7","v":8.4},{"$f":"BC7+0.8","v":10.100000000000001},0.14,75,30,0.0024,0.003]
[null,"Drive mechanism","  Belt drive",{"$nulls":13},7,"WM80Z- Y","Y = Double short carriages",null,null,"Y",null,{"v":5500,"d":"5,500"},null,{"$f":"G18+Z8","v":990},280,1230,4200,4200,136,{"$f":"2.1*G18","v":1050},1050,600,40,5,20,null,4.2,9.2,0.8,45,{"$f":"G18","v":500},48.75,null,400,{"$f":"2*17919","v":35838},{"$f":"2*18723","v":37446},54.11268065124442,1470,13800,8060,{"$f":"BA8+0.6","v":4.6},{"$f":"BB8+0.7","v":6.1000000000000005},{"$f":"BC8+0.8","v":7},0.14,75,30,0.0024,0.003]
[null,"Type of belt",{"$f":"IF(M4=1,\"  20 ATL 5\",\"  25 AT 10\")","v":"  25 AT 10"},{"$nulls":13},8]
[{"$nulls":16},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]
[null,"Move per rev",{"$f":"IF(M4=1,120,170)","v":170},"mm"]
[null,"Repeatability",0.05,"mm",null,{"$f":"IF(AND($K$22=3,$K$12<$K$23),\"Min Lc =\",\" \")","v":" "},{"$f":"IF(AND($K$22=3,$K$12<$K$23),$K$23,\" \")","v":" "},{"$f":"IF(AND($K$22=3,$K$12<$K$23),\"mm\",\" \")","v":" "},{"$nulls":10},"Carriages/unit"]
[{"$nulls":15},{"$f":"IF(AND(M4=1,OR(Q16=1,Q16=3,Q16=4)),0,1)","v":1},2,{"$f":"VLOOKUP(Q16,Q17:R21,2)","v":"S = Single short carriage"},{"$f":"IF(Q16>3,2,1)","v":1},null,{"$f":"AQ4","v":0},{"$f":"AM4","v":2.1},{"$f":"V4","v":"S"},1,{"$f":"IF(X16=1,1,0)","v":1},{"$nulls":23},1,"WM60Z - S","S = Single short carriage"]
[{"$nulls":16},1,{"$f":"IF(M4=1,\"  xxx\",\"N = Single standard carriage\")","v":"N = Single standard carriage"},{"$nulls":5},1,"Yes",{"$nulls":23},2,"WM60Z- Y","Y = Double short carriages"]
[null,"Saddle",null,null,{"$f":"IF(K22=2,\"Not available\",\" \")","v":" "},{"$f":"IF(S16=2,\"LA =\",\" \")","v":" "},500,{"$f":"IF(Q16>3,\"mm\",\" \")","v":" "},{"$f":"IF(AND(S16=2,G18<AA4),\"Too short\",\" \")","v":" "},{"$nulls":7},2,"S = Single short carriage",{"$nulls":5},2,"No",null,null,"Following assumption is made:  each Nm torque in Mz and My will create a friction force of ",{"$nulls":8},{"$f":"IF(Q4=4,1,1.5)","v":1},"N for  WM60S and WM 80S with single carriage",{"$nulls":10},3,"WM80Z- N","N = Single standard carriage"]
[null,"Stroke",2000,"mm",null,"Total length",{"$f":"C19+Z4","v":2490},"mm",{"$nulls":8},3,{"$f":"IF(M4=1,\"  xxx \",\"L = Single long carriage\")","v":"L = Single long carriage"},{"$nulls":9},"For other units, this will be concidered to create a pair of forces in Y or Z direction",{"$nulls":20},4,"WM80Z- S","S = Single short carriage"]
[null,null,{"$f":"IF(C19>X4,\"Longer than standard. Check with plant\",\" \")","v":" "},{"$nulls":13},4,{"$f":"IF(M4=1,\"  xxx\",\"Z = Double standard carriages\")","v":"Z = Double standard carriages"},{"$nulls":30},5,"WM80Z- L","L = Single long carriage"]
[null,null,"Number of units",{"$nulls":13},5,"Y = Double short carriages",{"$nulls":30},6,"WM80Z- Z","Z = Double standard carriages"]
[{"$f":"IF(Q23=2,\"Distance between  linear units\",\" \")","v":" "},null,null,800,{"$nulls":22},"Configuration",{"$nulls":4},"If WM60Z or WM80Z with single short carriage, then Yes = 1 otherwise No = 0",{"$nulls":16},7,"WM80Z- Y","Y = Double short carriages"]
[{"$nulls":16},1,"units",{"$f":"Q23-1","v":0},1,null,null,1,{"$nulls":3},{"$f":"IF(AND(Q23=1,T23=1,W23=1),1,IF(AND(Q23=2,T23=1,W23=1),2,IF(AND(Q23=1,T23=1,W23=2),3,IF(AND(Q23=2,T23=1,W23=2),4,IF(AND(Q23=1,T23=2),5,IF(AND(Q23=2,T23=2),6,\"\"))))))","v":1},{"$nulls":4},{"$f":"IF(OR(Q4=1,Q4=4),1,0)","v":1}]
[null,null,"Weight of linear drive unit/-s",{"$f":"Q23*(AN4+(G19+IF(S16=2,G18,0))/100*AO4+AM4)","v":{"v":31.220000000000002,"d":"31.2"}},"kg",null,{"$f":"IF(M35=0,\" \",IF(C27/2000>#REF!,\"OK\",\"Too much\"))","v":" "},{"$nulls":9},"one single unit",null,null,1,"Horizontal",null,1,{"$f":"IF(T23=1,\"Top or downward\",\" \")","v":"Top or downward"},null,null,{"$f":"R108","v":"Horizontal mounting, single unit, carriage at top"}]
[{"$nulls":5},{"$f":"IF(M35=0,\" \",\"Deflection\")","v":" "},{"$nulls":10},"two units in parallel",null,null,2,"Vertical",null,2,{"$f":"IF(T23=1,\"Sideway\",\" \")","v":"Sideway"}]
[null,"Mounting direction"]
[{"$nulls":23},"Friction factor =",0.1]
[{"$nulls":16},"Horizontal mounting, single unit, carriage at top",{"$nulls":5},{"$f":"S4","v":"S = Single short carriage"},{"$nulls":10},"Fx per unit  ","Total Fx at"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":5},"at constant",{"$nulls":4},"Max",{"$nulls":5},"during acc  ","  const. speed"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction","speed",null,"Totally",null,null,"allowed","% of max"]
[{"$nulls":16},"Mx =",{"$f":"$C$49*10*M52/1000","v":0},0,{"$f":"Y16*R31+S31+C46","v":0},"Nm",{"$f":"T31/AR4*1000*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V31","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4*S16)*C53+AP4*S16+V39","v":{"v":26.7,"d":"27"}},"N",{"$f":"AB4","v":1230},{"$nulls":5},{"$f":"Z31","v":{"v":26.7,"d":"27"}},{"$f":"C43+AP4*S16+W39","v":{"v":22.5,"d":"23"}}]
[{"$nulls":16},"My =",{"$f":"$C$49*10*M51/1000","v":0},{"$f":"C49*C53*M53/1000","v":0},{"$f":"Y16*R32+S32+C47","v":0},"Nm",{"$f":"IF(AF23=1,T32*AK18,T32/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,(T32-S32)*AK18,(T32-S32)/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":2100},{"$f":"Z32/AB32","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Mz =",0,{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R33+S33+C48","v":0},"Nm",{"$f":"IF(AF23=1,T33*AK18,T33/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,(T33-S33)*AK18,(T33-S33)/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},null,"Fz =",{"$f":"C45+C49*10*Y16","v":0},"N",{"$f":"AD4","v":2100},{"$f":"Z33/AB33","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",{"$f":"T31","v":0},"Nm",{"$f":"AE4","v":68},{"$f":"Z34/AB34","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z32*Y27","v":0},{"$f":"V35","v":0},null,"My =",{"$f":"T32","v":0},"Nm",{"$f":"AF4","v":135},{"$f":"Z35/AB35","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"Z33*Y27","v":0},{"$f":"V36","v":0},null,"Mz =",{"$f":"T33","v":0},"Nm",{"$f":"AG4","v":135},{"$f":"Z36/AB36","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":27},"Totally",{"$f":"SUM(AC32:AC37)","v":{"v":0,"d":"0%"}}]
[{"$nulls":20},"Totally",{"$f":"SUM(V31:V38)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W31:W38)","v":{"v":0,"d":"0.0"}},"N"]
[]
[]
[{"$nulls":16},"Horizontal mounting, 2 units, carriage at top"]
[null,"Fx =",0,"N",{"$f":"IF(C43>$AB$4*$Q$23,\"Too much\",\" \")","v":" "},null,null,{"$f":"IF(T23=2,\" \",\"Orientation of carriage\")","v":"Orientation of carriage"},{"$nulls":8},"Load torques caused by off center load",{"$nulls":10},"Max"]
[null,"Fy =",0,"N",{"$f":"IF(C44>AC4*$Q$23,\"Too much\",\" \")","v":" "},{"$nulls":12},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[null,"Fz =",0,"N",{"$f":"IF(C45>AD4*$Q$23,\"Too much\",\" \")","v":" "},{"$nulls":11},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},0,null,"Fx =",{"$f":"C43+T47/D22*1000+(C49+AM4*2)*C53+V53+AP4*2*S16+V46/D22*1000*2","v":{"v":53.4,"d":"53"}},"N",{"$f":"2*AB4","v":2460},{"$nulls":5},{"$f":"Z45*(D22/2+M52)/D22","v":{"v":26.7,"d":"27"}},{"$f":"C43+T47/D22*1000+W53+AP4*2*S16+V46/D22*1000*2","v":45},{"$nulls":44}," Please note:"]
[null,"Mx =",0,"Nm",{"$f":"IF(Q23=2,\" \",IF(C46>AE4,\"Too much\",\" \"))","v":" "},{"$nulls":11},"My =",{"$f":"C49*10*M51/1000","v":0},{"$f":"C49*C53*M53/1000","v":0},{"$f":"Y16*R46+S46+C47","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T46,T46/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(T46-S46),(T46-S46)/U16*1000*Y27)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4*1","v":2100},{"$f":"Z46/AB46","v":{"v":0,"d":"0%"}},{"$nulls":50}," Fx, Fy, Fz, Mx, My and Mz are external forces and torques and "]
[null,"My =",0,"Nm",{"$f":"IF(C47>AF4*$Q$23,\"Too much\",\" \")","v":" "},{"$nulls":11},"Mz =",0,{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R47+S47+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+C49*10*Y16+C46/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":4200},{"$f":"Z47/AB47","v":{"v":0,"d":"0%"}},{"$nulls":50}," are not connected with or caused by \"Total mass to move\""]
[null,"Mz =",0,"Nm",{"$f":"IF(Q23=2,\" \",IF(C48>$AG$4,\"Too much\",\" \"))","v":" "},{"$nulls":19},"Mx =",{"$f":"T45","v":0},"Nm",{"$nulls":3},"Anser att Mx blir ett kraftpar som ökar Fz"]
[null,"Total mass to move",0,"kg         in location from top of carriage",{"$nulls":3},"Lx =",0,"mm",{"$nulls":6},"Fy =",{"$nulls":4},{"$f":"C44*Y27","v":0},{"$f":"V49","v":0},null,"My =",{"$f":"T46","v":0},"Nm",{"$f":"AF4*2","v":270},{"$f":"Z49/AB49","v":{"v":0,"d":"0%"}}]
["Will this mass be carried by the carriage/carriages?",{"$nulls":6},"Ly =",0,"mm",null,null,"ABS",{"$nulls":3},"Fz =",{"$nulls":4},{"$f":"(C49*10*Y16+C45)*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V50","v":0},null,"Mz =",{"$f":"T47","v":0},"Nm",{"$nulls":3},"Anser att Mz blir ett kraftpar som ökar Fx"]
[{"$nulls":7},"Lz =",0,"mm",null,null,{"$f":"ABS(I49)","v":0}]
[null,"Speed",1.5,"m/s",{"$f":"IF(C52>AJ4,\"Too high speed\",\" \")","v":" "},{"$nulls":7},{"$f":"ABS(I50)","v":0},{"$nulls":14},"Totally",{"$f":"SUM(AC46:AC51)","v":{"v":0,"d":"0%"}}]
[null,"Acceleration",2,"m/s²",{"$f":"IF(C53>40,\"Too high acceleration\",\" \")","v":" "},{"$nulls":7},{"$f":"ABS(I51)","v":0},{"$nulls":7},"Totally",{"$f":"SUM(V45:V52)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W45:W52)","v":{"v":0,"d":"0.0"}},"N"]
[]
["Move profile over",null,1800,"mm stroke",null,{"$f":"IF(C55>C19,\"This is longer than stroke of unit !\",\" \")","v":" "},{"$nulls":10},"Horizontal mounting, single unit, carriage sideway"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max"]
["Time to move one direction",{"$nulls":16},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[null,null,{"$f":"Blad2!C32","v":1.95},"sec",{"$nulls":12},"Mx =",{"$f":"C49*10*M53/1000","v":0},0,{"$f":"Y16*R58+C46","v":0},"Nm",{"$f":"T58/AR4*1000*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V58","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4)*C53+AP4*S16+V66","v":{"v":26.7,"d":"27"}},"N",{"$f":"AB4","v":1230},{"$nulls":5},{"$f":"Z58","v":{"v":26.7,"d":"27"}},{"$f":"C43+AP4*S16+W66","v":{"v":22.5,"d":"23"}}]
[{"$nulls":16},"My =",0,{"$f":"C49*C53*M53/1000","v":0},{"$f":"S59+C47","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T59,T59/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(T59-S59),(T59-S59)/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},null,"Fy =",{"$f":"C44+Y16*C49*10","v":0},"N",{"$f":"AC4","v":2100},{"$f":"Z59/AB59","v":{"v":0,"d":"0%"}}]
[{"$f":"Blad2!A35","v":" "},{"$nulls":15},"Mz =",{"$f":"C49*10*M51/1000","v":0},{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R60+S60+C48","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T60,T60/AQ4*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(T60-S60),(T60-S60)/AQ4*1000*Y27)","v":{"v":0,"d":"0.0"}},null,"Fz =",{"$f":"C45","v":0},"N",{"$f":"AD4","v":2100},{"$f":"Z60/AB60","v":{"v":0,"d":"0%"}}]
[{"$f":"Blad2!A36","v":" "},null,{"$f":"Blad2!C36","v":" "},{"$f":"Blad2!D36","v":" "},{"$nulls":20},"Mx =",{"$f":"T58","v":0},"Nm",{"$f":"AE4","v":68},{"$f":"Z61/AB61","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z59*Y27","v":0},{"$f":"V62","v":0},null,"My =",{"$f":"T59","v":0},"Nm",{"$f":"AF4","v":135},{"$f":"Z62/AB62","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"C45*Y27","v":0},{"$f":"V63","v":0},null,"Mz =",{"$f":"T60","v":0},"Nm",{"$f":"AG4","v":135},{"$f":"Z63/AB63","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":27},"Totally",{"$f":"SUM(AC59:AC64)","v":{"v":0,"d":"0%"}}]
[{"$nulls":20},"Totally",{"$f":"SUM(V58:V65)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W58:W65)","v":{"v":0,"d":"0.0"}},"N"]
[]
[{"$nulls":16},"Horizontal mounting, two units, carriages sideway"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[{"$f":"R108","v":"Horizontal mounting, single unit, carriage at top"},{"$nulls":15},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},0,null,"Fx =",{"$f":"C43+V79+T73/D22*1000+(C49+AM4*2*S16)*C53","v":{"v":8.4,"d":"8"}},"N",{"$f":"AB4*2","v":2460},{"$nulls":5},{"$f":"Z71*(D22/2+M52)/D22","v":4.2},{"$f":"C43+V80","v":0}]
[{"$nulls":16},"My =",0,{"$f":"C49*C53*M53/1000","v":0},{"$f":"C47+S72","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T72,T72/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(T72-S72),(T72-S72)/U16*1000*Y27)","v":0},null,"Fy =",{"$f":"C44+C49*10*Y16","v":0},"N",{"$f":"AC4","v":2100},{"$f":"Z72/AB72","v":{"v":0,"d":"0%"}}]
[null,"Result:",null,"Allowed",{"$nulls":12},"Mz =",{"$f":"C49*10*M51/1000","v":0},{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R73+S73+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+Y16*C49*10*M53/1000/D22*1000+C46/D22*1000","v":0},"N",{"$f":"AD4*2","v":4200},{"$f":"Z73/AB73","v":{"v":0,"d":"0%"}}]
["Fx =",{"$f":"X108","v":{"v":26.7,"d":"27"}},"N",{"$f":"Y108","v":1230},"N",{"$f":"IF(B74>D74,\"Too much !\",\" \")","v":" "},{"$nulls":18},"Mx =",0,"Nm",null,null,"Anser att Mx blir ett kraftpar som ökar Fz"]
["Fy =",{"$f":"Z108","v":0},"N",{"$f":"AA108","v":2100},"N"," ",{"$nulls":10},"Fy =",{"$nulls":4},{"$f":"Z72*Y27","v":0},{"$f":"V75","v":0},null,"My =",{"$f":"T72","v":0},"Nm",{"$f":"AF4*2","v":270},{"$f":"Z75/AB75","v":{"v":0,"d":"0%"}}]
["Fz =",{"$f":"AB108","v":0},"N",{"$f":"AC108","v":2100},"N"," ",{"$nulls":10},"Fz =",{"$nulls":4},{"$f":"Z73*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V76","v":{"v":0,"d":"0.0"}},null,"Mz =",{"$f":"T73","v":0},"Nm",null,null,"Anser att Mz blir ett kraftpar som ökar Fx"]
["Mx =",{"$f":"AD108","v":0},"Nm",{"$f":"AE108","v":68},"Nm"," "]
["My =",{"$f":"AF108","v":0},"Nm",{"$f":"AG108","v":135},"Nm"," ",{"$nulls":21},"Totally",{"$f":"SUM(AC72:AC77)","v":{"v":0,"d":"0%"}}]
["Mz =",{"$f":"AH108","v":0},"Nm",{"$f":"AI108","v":135},"Nm"," ",{"$nulls":14},"Totally",{"$f":"SUM(V71:V78)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W71:W78)","v":{"v":0,"d":"0.0"}},"N"]
[{"$nulls":5},"Total dynamic load combined all directions (apart of Fx)",{"$f":"AJ108","v":{"v":1E-3,"d":"0%"}}]
[null,{"$f":"IF(AJ108>1,\"The total load is too much ! Select bigger unit or another configuration.\",IF(B74>D74,\"The axial force is too much ! Select bigger unit or another configuration.\",\" \"))","v":" "},{"$nulls":14},"Vertical mounting, single unit"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max"]
[null,"Designation:  ",{"$f":"CONCATENATE(O4,BO18,IF(C19<1000,\"-00\",IF(C19<10000,\"-0\",\"-\")),C19,IF(G19<1000,\"-00\",IF(G19<10000,\"-0\",\"-\")),G19,\"x\",W16,IF(Q16<3,\"-0000\",-G18))","v":"WM08Z170-02000-02490xS-0000"},{"$nulls":14},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[{"$nulls":16},"Mx =",0,0,{"$f":"C46","v":0},"Nm",{"$f":"T84/AR4*1000*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V84","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4*S16)*C53+AP4*S16+V92+C49*10","v":{"v":26.7,"d":"27"}},"N",{"$f":"AB4","v":1230},{"$nulls":5},{"$f":"Z84","v":{"v":26.7,"d":"27"}},{"$f":"C43+AP4*S16+W92+C49*10","v":{"v":22.5,"d":"23"}}]
[null,"Calculation of lifetime",{"$nulls":14},"My =",{"$f":"C49*10*M53/1000","v":0},{"$f":"C49*C53*M53/1000","v":0},{"$f":"Y16*R85+S85+C47","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T85,T85/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(R85+C47),(R85+C47)/U16*1000*Y27)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":2100},{"$f":"Z85/AB85","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Mz =",{"$f":"C49*10*M52/1000","v":0},{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R86+S86+C48","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T86,T86/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(C48+R86),(C48+R86)/U16*1000*Y27)","v":0},null,"Fz =",{"$f":"C45","v":0},"N",{"$f":"AD4","v":2100},{"$f":"Z86/AB86","v":{"v":0,"d":"0%"}}]
[null,null,"Average load factor fm",1,{"$f":"IF(D87>1,\"  Not possible\",\" \")","v":" "},{"$nulls":19},"Mx =",{"$f":"T84","v":0},"Nm",{"$f":"AE4","v":68},{"$f":"Z87/AB87","v":{"v":0,"d":"0%"}}]
[null,null,"Ball guide",{"$f":"IF(R121<100000,R121,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(P121>10*10^7,\">50 000\",P121/1000)","v":">50 000"},"km",{"$nulls":9},"Fy =",{"$nulls":4},{"$f":"C44*Y27","v":0},{"$f":"V88","v":0},null,"My =",{"$f":"T85","v":0},"Nm",{"$f":"AF4","v":135},{"$f":"Z88/AB88","v":{"v":0,"d":"0%"}}]
[null,null,"Ball bearing drive end",{"$f":"IF(AD123<100000,AD123,\"> 100 000\")","v":{"v":59455.84338848684,"d":"59,456"}},"h",{"$f":"IF(AF123>50000,\">50 000\",AF123)","v":">50 000"},"km",{"$nulls":9},"Fz =",{"$nulls":4},{"$f":"C45*Y27","v":0},{"$f":"V89","v":0},null,"Mz =",{"$f":"T86","v":0},"Nm",{"$f":"AG4","v":135},{"$f":"Z89/AB89","v":{"v":0,"d":"0%"}}]
[null,null,"Ball bearing tensioon wheel",{"$f":"IF(AD124<100000,AD124,\"> 100 000\")","v":{"v":11559.453124712321,"d":"11,559"}},"h",{"$f":"IF(AF124>50000,\">50 000\",AF124)","v":">50 000"},"km"]
[{"$nulls":27},"Totally",{"$f":"SUM(AC85:AC90)","v":{"v":0,"d":"0%"}}]
[null,null,"number of cycles per minute",10,null,"Duty cycle",{"$f":"D92*2*C58/60","v":{"v":0.65,"d":"65%"}},{"$f":"IF(G92>1,\"Not possible !\",\" \")","v":" "},{"$nulls":12},"Totally",{"$f":"SUM(V84:V91)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W84:W91)","v":{"v":0,"d":"0.0"}},"N"]
[null,null,"Working hours per day",16,{"$f":"IF(D93>24,\"  Not possible\",\" \")","v":" "}]
[null,null,"Working days per year",365,{"$f":"IF(D94>365,\"  Not possible\",\" \")","v":" "},{"$nulls":11},"Vertical  mounting, two units"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max"]
[null,null,"Lifetime ",{"$f":"IF(P121*10^3/C55/2/D92/60/D93/D94>50,\"> 50\",P121*10^3/C55/2/D92/60/D93/D94)","v":"> 50"},"Years","Ball guide",{"$nulls":11},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[{"$nulls":3},{"$f":"IF(AH123>50,\"> 50\",AH123)","v":{"v":25.45198775192074,"d":"25.5"}},"Years","Ball bearing drive end",{"$nulls":10},"Mx =",0,0,0,"Nm",{"$f":"C46/D22*1000*Y27","v":{"v":0,"d":"0.0"}},{"$f":"V97","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+C49*10+2*AM4*S16+2*AP4*S16+T99/D22*1000+(C49+2*AM4*S16)*C53","v":{"v":57.6,"d":"58"}},"N",{"$f":"AB4*2","v":2460},{"$nulls":5},{"$f":"Z97*(D22/2+M52)/D22","v":{"v":28.8,"d":"29"}},{"$f":"C43+C49*10+2*AM4*S16+2*AP4*S16","v":{"v":49.2,"d":"49"}}]
[{"$nulls":3},{"$f":"IF(AH124>50,\"> 50\",AH124)","v":{"v":4.94839602941452,"d":"4.9"}},"Years","Ball bearing tension wheel",{"$nulls":10},"My =",{"$f":"C49*M53*10/1000","v":0},{"$f":"C49*C53*M53/1000","v":0},{"$f":"Y16*R98+S98+C47","v":0},"Nm",{"$f":"IF(AF23=1,AK18*T98,T98/U16*1000*Y27)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF23=1,AK18*(R98+C47),(R98+C47)/U16*1000*Y27)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":2100},{"$f":"Z98/AB98","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Mz =",{"$f":"C49*10*M52/1000","v":0},{"$f":"C49*C53*M52/1000","v":0},{"$f":"Y16*R99+S99+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+C46/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":4200},{"$f":"Z99/AB99","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",0,"Nm",null,null,"Anser att Mx blir ett kraftpar som ökar Fz"]
[null,null,"Idle torque at no load",{"$f":"O142","v":{"v":5.54604462474645,"d":"5.55"}},"Nm and",{"$f":"R117","v":{"v":529.4117647058824,"d":"529"}},"rpm at",{"$f":"C52","v":1.5},"m/s",{"$nulls":7},"Fy =",{"$nulls":4},{"$f":"C44*Y27","v":0},{"$f":"V101","v":0},null,"My =",{"$f":"T98","v":0},"Nm",{"$f":"AF4*2","v":270},{"$f":"Z101/AB101","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"Z99*Y27","v":0},{"$f":"V102","v":0},null,"Mz =",{"$f":"T99","v":0},"Nm",null,null,"Anser att Mz blir ett kraftpar som ökar Fx"]
[null,null,"Drive torque at constant speed",{"$f":"P151","v":{"v":6.186852685090134,"d":"6.19"}},"Nm and",{"$f":"D103*R117/9.55","v":{"v":342.9730469098319,"d":"343"}},"W"]
[null,null,"Drive torque during acc",{"$f":"P152","v":{"v":6.306470189687622,"d":"6.31"}},"Nm and",{"$f":"D104*R117/9.55","v":{"v":349.60413740183924,"d":"350"}},"W",{"$nulls":20},"Totally",{"$f":"SUM(AC98:AC103)","v":{"v":0,"d":"0%"}}]
[null,null,"System inertia",{"$f":"S161","v":2.2863210661320816E-3},"kg m² (excluding gear, motor etc)",{"$nulls":15},"Totally",{"$f":"SUM(V97:V104)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W97:W104)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":14},"Total Fx  at const speed","Total Fx during acc"]
[null,{"$f":"IF(P152>AI4*Q23,\"Too high drive torque\",IF(AND(Q23=2,P152<2*AI4,P152>AI4),\"Will require central gear mounting\",\" \"))","v":" "},{"$nulls":34},"Max Fx"]
[{"$nulls":23},"Fx",null,"Fy",null,"Fz",null,"Mx",null,"My",null,"Mz",null,"Total","one unit"]
[null,"Gear / Motor",{"$nulls":15},{"$f":"VLOOKUP($AA$23,$Q$109:R114,2)","v":"Horizontal mounting, single unit, carriage at top"},{"$f":"VLOOKUP($AA$23,$Q$109:S114,2)","v":"Horizontal mounting, single unit, carriage at top"},{"$nulls":4},{"$f":"VLOOKUP($AA$23,$Q$109:X114,8)","v":{"v":26.7,"d":"27"}},{"$f":"VLOOKUP($AA$23,$Q$109:Y114,9)","v":1230},{"$f":"VLOOKUP($AA$23,$Q$109:Z114,10)","v":0},{"$f":"VLOOKUP($AA$23,$Q$109:AA114,11)","v":2100},{"$f":"VLOOKUP($AA$23,$Q$109:AB114,12)","v":0},{"$f":"VLOOKUP($AA$23,$Q$109:AC114,13)","v":2100},{"$f":"VLOOKUP($AA$23,$Q$109:AD114,14)","v":0},{"$f":"VLOOKUP($AA$23,$Q$109:AE114,15)","v":68},{"$f":"VLOOKUP($AA$23,$Q$109:AF114,16)","v":0},{"$f":"VLOOKUP($AA$23,$Q$109:AG114,17)","v":135},{"$f":"VLOOKUP($AA$23,$Q$109:AH114,18)","v":0},{"$f":"VLOOKUP($AA$23,$Q$109:AI114,19)","v":135},{"$f":"VLOOKUP($AA$23,$Q$109:AJ114,20)+0.001","v":{"v":1E-3,"d":"0%"}},{"$f":"VLOOKUP($AA$23,$Q$109:AK114,21)","v":26.7},{"$f":"VLOOKUP($AA$23,$Q$109:AL114,22)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$23,$Q$109:AM114,23)","v":22.5},{"$f":"VLOOKUP($AA$23,$Q$109:AN114,24)","v":26.7}]
[{"$nulls":16},1,"Horizontal mounting, single unit, carriage at top",{"$nulls":5},{"$f":"Z31","v":{"v":26.7,"d":"27"}},{"$f":"AB31","v":1230},{"$f":"Z32","v":0},{"$f":"AB32","v":2100},{"$f":"Z33","v":0},{"$f":"AB33","v":2100},{"$f":"Z34","v":0},{"$f":"AB34","v":68},{"$f":"Z35","v":0},{"$f":"AB35","v":135},{"$f":"Z36","v":0},{"$f":"AB36","v":135},{"$f":"AC38","v":{"v":0,"d":"0%"}},{"$f":"AH31","v":26.7},{"$f":"AF38","v":{"v":0,"d":"0.0"}},{"$f":"AI31","v":22.5},{"$f":"AH31","v":26.7}]
[{"$nulls":16},2,"Horizontal mounting, 2 units, carriage at top",{"$nulls":5},{"$f":"Z45","v":{"v":53.4,"d":"53"}},{"$f":"AB45","v":2460},{"$f":"Z46","v":0},{"$f":"AB46","v":2100},{"$f":"Z47","v":0},{"$f":"AB47","v":4200},{"$f":"IF(Z48=0,\" - \",Z48)","v":" - "},{"$f":"IF(AB48=0,\" - \",AB48)","v":" - "},{"$f":"Z49","v":0},{"$f":"AB49","v":270},{"$f":"Z50","v":0},{"$f":"IF(AB50=0,\" - \",AB50)","v":" - "},{"$f":"AC52","v":{"v":0,"d":"0%"}},{"$f":"AH45","v":26.7},{"$f":"AF52","v":0},{"$f":"AI45","v":{"v":45,"d":"45.0"}},{"$f":"AH45*2","v":53.4}]
[null,null,{"$f":"IF($L$262=2,\"Ratio\",\" \")","v":"Ratio"},3,{"$nulls":12},3,"Horizontal mounting, single unit, carriage sideway",{"$nulls":5},{"$f":"Z58","v":{"v":26.7,"d":"27"}},{"$f":"AB58","v":1230},{"$f":"Z59","v":0},{"$f":"AB59","v":2100},{"$f":"Z60","v":0},{"$f":"AB60","v":2100},{"$f":"Z61","v":0},{"$f":"AB61","v":68},{"$f":"Z62","v":0},{"$f":"AB62","v":135},{"$f":"Z63","v":0},{"$f":"AB63","v":135},{"$f":"AC65","v":{"v":0,"d":"0%"}},{"$f":"AH58","v":26.7},{"$f":"AF65","v":{"v":0,"d":"0.0"}},{"$f":"AI58","v":22.5},{"$f":"AH58","v":26.7}]
[null,null,{"$f":"IF($L$262=2,\"Effiency factor\",\" \")","v":"Effiency factor"},{"v":0.95,"d":"95%"},{"$nulls":12},4,"Horizontal mounting, two units, carriages sideway",{"$nulls":5},{"$f":"Z71","v":{"v":8.4,"d":"8"}},{"$f":"AB71","v":2460},{"$f":"Z72","v":0},{"$f":"AB72","v":2100},{"$f":"Z73","v":0},{"$f":"AB73","v":4200},{"$f":"IF(Z74=0,\" - \",Z74)","v":" - "},{"$f":"IF(AB74=0,\" - \",AB74)","v":" - "},{"$f":"Z75","v":0},{"$f":"AB75","v":270},{"$f":"Z76","v":0},{"$f":"IF(AB76=0,\" - \",AB76)","v":" - "},{"$f":"AC78","v":{"v":0,"d":"0%"}},{"$f":"AH71","v":4.2},{"$f":"AF78","v":0},{"$f":"AI71","v":{"v":0,"d":"0.0"}},{"$f":"AH71*2","v":8.4}]
[null,null,{"$f":"IF($L$262=2,\"Idle torque\",\" \")","v":"Idle torque"},0.1,{"$f":"IF($L$262=2,\"Nm\",\" \")","v":"Nm"},{"$nulls":11},5,"Vertical mounting, single unit",{"$nulls":5},{"$f":"Z84","v":{"v":26.7,"d":"27"}},{"$f":"AB84","v":1230},{"$f":"Z85","v":0},{"$f":"AB85","v":2100},{"$f":"Z86","v":0},{"$f":"AB86","v":2100},{"$f":"Z87","v":0},{"$f":"AB87","v":68},{"$f":"Z88","v":0},{"$f":"AB88","v":135},{"$f":"Z89","v":0},{"$f":"AB89","v":135},{"$f":"AC91","v":{"v":0,"d":"0%"}},{"$f":"AH84","v":26.7},{"$f":"AF91","v":{"v":0,"d":"0.0"}},{"$f":"AI84","v":{"v":22.5,"d":"23"}},{"$f":"AH84","v":26.7}]
[null,null,{"$f":"IF($L$262=2,\"Inertia\",\" \")","v":"Inertia"},5e-05,{"$f":"IF($L$262=2,\"kg m²\",\" \")","v":"kg m²"},{"$f":"IF(AND(L262=2,Q23=2),\"Total inertia for gears and parallel shaft\",\" \")","v":" "},{"$nulls":10},6,"Vertical  mounting, two units",{"$nulls":5},{"$f":"Z97","v":{"v":57.6,"d":"58"}},{"$f":"AB97","v":2460},{"$f":"Z98","v":0},{"$f":"AB98","v":2100},{"$f":"Z99","v":0},{"$f":"AB99","v":4200},{"$f":"IF(Z100=0,\" - \",Z100)","v":" - "},{"$f":"IF(AB100=0,\" - \",AB100)","v":" - "},{"$f":"Z101","v":0},{"$f":"AB101","v":270},{"$f":"Z102","v":0},{"$f":"AB102","v":0},{"$f":"AC104","v":{"v":0,"d":"0%"}},{"$f":"AH97","v":28.8},{"$f":"AF104","v":0},{"$f":"AI97","v":{"v":49.2,"d":"49"}},{"$f":"AH97*2","v":57.6}]
[]
[]
[{"$nulls":16},"rpm drive shaft",{"$f":"$C$52*1000/C14*60","v":{"v":529.4117647058824,"d":"529"}},null,"motor speed",{"$f":"R117*IF(L262=1,1,D111)","v":{"v":1588.2352941176473,"d":"1588"}},"rpm"]
[]
[null,null,{"$f":"IF(OR(L266=2,L266=3),\"Nominal torque\",IF(L266=4,\"Holding torque\",\" \"))","v":" "},{"$f":"IF(L266=2,Q206,IF(L266=3,R177,IF(L266=4,O234,\" \")))","v":" "},{"$f":"IF(L266=2,\"Nm\",IF(L266=3,\"Nm at max speed\",IF(L266=4,\"Nm\",\" \")))","v":" "},{"$nulls":8},"Calculation of lifetime.",null,null,"The lifetime of the ball guides will be based on the total % of load in all directions and the max allowed Fz load compared to Cz value for the ball guides"]
[null,null,{"$f":"IF($L$266=2,\"Nominal speed\",IF($L$266=3,\"Peak torque\",\" \"))","v":" "},{"$f":"IF(L266=2,O206,IF(L266=3,S177,\" \"))","v":" "},{"$f":"IF($L$266=2,\"rpm\",IF($L$266=3,\"Nm\",\" \"))","v":" "},{"$nulls":8},"Lh ball guide = (C / ( Fz x %))^3 x 10^5  m"]
[null,null,{"$f":"IF($L$266=2,\"Nominal power\",IF($L$266=3,\"Max speed\",\" \"))","v":" "},{"$f":"IF(L266=2,P206,IF(L266=3,O177,\" \"))","v":" "},{"$f":"IF($L$266=2,\"kW\",IF($L$266=3,\"rpm\",\" \"))","v":" "},{"$nulls":8},"Lifetime ball guide =",null,{"$f":"(AU4*Q23*T23/(AD4+AT4)/AJ108/D87)^3*10^5","v":2.9458543424302086E+17},"m",{"$f":"P121/C52/3600","v":54552858193152.01},"h"]
[null,null,{"$f":"IF(L266=3,\"Nominal power\",\" \")","v":" "},{"$f":"IF(L266=3,P177,\" \")","v":" "},{"$f":"IF(L266=3,\"kW\",\" \")","v":" "}]
[null,null,{"$f":"IF(L266=5,\"Customer motor data:\",\" \")","v":"Customer motor data:"},"Supplier, torque, power, rpm etc",{"$nulls":9},"Force at drive pulley equally shared on two ball bearings. Total force( 2 x 1,1 x pretension belt) + Fx",{"$nulls":10},{"$f":"(2*1.1*AX4+X108)/2","v":{"v":1630.3500000000001,"d":"1630"}},"N / bearing",null,"Lifetime ball bearing",null,{"$f":"(AY4/Y123)^3*10^6/C14/60","v":{"v":59455.84338848684,"d":"59456"}},"h",{"$f":"AD123*3600*C52/1000","v":{"v":321061.554297829,"d":"321,062"}},"km",{"$f":"AF123*1000/C55/2*1000/D92/60/D93/D94","v":25.45198775192074}]
[{"$nulls":13},"Force at tensioning wheel equally shared on two ball bearings. Total force (2 x 1,1 x pretension belt) + (2 x Fx)",{"$nulls":10},{"$f":"(2*1.1*AX4+2*X108)/2","v":{"v":1643.7000000000003,"d":"1644"}},"N / bearing",null,"Lifetime ball bearing",null,{"$f":"(AZ4/Y124)^3*10^6/C14/60","v":{"v":11559.453124712321,"d":"11559"}},"h",{"$f":"AD124*3600*C52/1000","v":{"v":62421.04687344653,"d":"62,421"}},"km",{"$f":"AF124*1000/C55/2*1000/$D$92/60/$D$93/$D$94","v":4.94839602941452}]
[]
[{"$nulls":14},"Efficieny factor belt =",{"v":0.95,"d":"95%"}]
[null,null,{"$f":"IF(L266=5,\"Motor inertia:\",\" \")","v":"Motor inertia:"},0.0005,{"$f":"IF(L266=5,\"kg m²\",\" \")","v":"kg m²"}]
[]
[null,"Required motor data"]
[null,null,"Torque at constant speed",{"$f":"Z151","v":{"v":2.270825503540398,"d":"2.27"}},"Nm"]
[null,null," Torque during acceleration",{"$f":"Z152","v":{"v":2.3969569380089224,"d":"2.40"}},"Nm"]
[null,null,"Power at constant speed",{"$f":"D130*D134/9550","v":{"v":0.3776549959691454,"d":"0.38"}},"kW"]
[null,null,"Power during acceleration",{"$f":"D131*D134/9550","v":{"v":0.39863158192941744,"d":"0.40"}},"kW",{"$f":"D134/D120*50","v":{"$error":"#VALUE!"}},{"$f":"IF(L266=2,\"Hz\",\" \")","v":" "}]
[null,null,"Max speed",{"$f":"U117","v":{"v":1588.2352941176473,"d":"1,588"}},"rpm"]
[null,null,"Inertia balance",{"$f":"R167","v":{"v":1.6442935702515735,"d":"1.6"}}]
[]
["Notes:",{"$nulls":23},{"$f":"M4+1","v":3},null,null,"kg m²"]
[{"$nulls":26},{"$f":"VLOOKUP(Y137,Z139:AB142,2)","v":"GS24"},{"$f":"VLOOKUP(Y137,Z139:AB142,3)","v":1.63E-4}]
[{"$nulls":11},"Idle torque Nm",null,150,{"$f":"IF($M$4=1,600,450)","v":450},{"$f":"IF($M$4=1,1250,885)","v":885},{"$nulls":9},1,"GS14",{"$f":"0.0000065","v":6.5e-06}]
[{"$nulls":13},{"$f":"BA4","v":4},{"$f":"BB4","v":5.4},6.2,{"$nulls":8},"WM60",2,"GS19",3.9e-05]
[{"$nulls":24},"WM80",3,"GS24",1.63E-4]
[{"$nulls":11},"Idle torque at this speed",null,null,{"$f":"IF(R117<=150,N140,IF(AND(R117>150,R117<=O139),N140+(R117-150)/(O139-N139)*(O140-N140),O140+(R117-O139)/(P139-O139)*(P140-O140)))","v":{"v":5.54604462474645,"d":"5.55"}},"Nm",{"$nulls":8},"WM120",4,"GS28",0.00038]
{"$rows_empty":8}
[{"$nulls":11},"Drive torque during constant speed",{"$nulls":3},{"$f":"O142+AM108*C14/2/1000/P126/PI()","v":6.186852685090134},"Nm",{"$nulls":4},"Motor torque during costant speed",{"$nulls":3},{"$f":"IF(L262=1,P151/0.99,P151/D111/D112+D113)","v":2.270825503540398},"Nm"]
[{"$nulls":11},"Drive torque during acceleration",{"$nulls":3},{"$f":"O142+AN108*C14/2/1000/P126/PI()","v":6.306470189687622},"Nm (including ball screw inertia)",{"$nulls":4},"Motor torque duringacceleration",{"$nulls":3},{"$f":"AC161+Z151","v":{"v":2.3969569380089224,"d":"2.397"}},"Nm including inertia and losses in gear"]
[]
[]
[{"$nulls":15},{"$f":"P152-P151","v":0.1196175045974881}]
[{"$nulls":26},"Drive ",null,"motor"]
[{"$nulls":11},"Linear inertia from load, carries and belt:",{"$nulls":4},"m x ( m/min / 2π / rpm ) ^2 =",null,null,{"$f":"(BD4*2*G19/1000+C49+AM4*Q23)*(C52*60/2/PI()/R117)^2","v":2.0476778175394085E-3},"kg m²",{"$nulls":5},"shaft",null,"shaft"]
[{"$nulls":11},"Inertia drive pulley",null," J = m / 2 x R²",{"$nulls":5},{"$f":"PI()*AW4^2/4*BE4*2.7/10^6/2*(AW4/2/1000)^2*Q23","v":{"v":1.7045946328048096E-4,"d":"0.000170"}},"kg m²",{"$nulls":3},"Inertia",null,{"$f":"S161","v":2.2863210661320816E-3},"kgm²",{"$f":"IF(L262=1,S161+T162+T164,(S160+T162)/D111^2/D112+T163+T164)","v":5.6906432748538016E-4},"kgm²",null,1]
[{"$nulls":11},"Inertia tension pulley",{"$nulls":7},{"$f":"PI()*AW4^2/4*BF4*2.7/10^6/2*(AW4/2/1000)^2*Q23","v":6.81837853121924e-05},"kg m²",{"$nulls":3},"Top speed",null,{"$f":"R117","v":{"v":529.4117647058824,"d":"529"}},"rpm",{"$f":"U117","v":{"v":1588.2352941176473,"d":"1588"}},"rpm",null,"Guide for selection of fm factor"]
[{"$nulls":11},"Parallel shaft VWZ-",{"$nulls":7},{"$f":"(Q23-1)*(2*BG4+BH4*D22/1000)","v":0},"kg m²",{"$nulls":3},"Acceleration time",null,{"$f":"C52/C53","v":0.75},"sec",{"$f":"AA160","v":0.75},"sec",null,"fm = 1,0 ; The same load in both directions"]
[{"$nulls":18},{"$f":"SUM(T157:T160)","v":2.2863210661320816E-3},{"$nulls":7},{"$f":"AA158*3.14*AA159/30/AA160","v":{"v":0.16891877994481738,"d":"0.169"}},"Nm",{"$f":"AC158*3.14*AC159/30/AC160","v":{"v":0.1261314344685243,"d":"0.126"}},"Nm",null,"fm = 0,89 ; Full load forward, 75% load back"]
[{"$nulls":11},"Inertia coupling",{"$nulls":7},{"$f":"AB138","v":1.63E-4},{"$nulls":11},"fm = 0,81 ; Full load forward, 50% load back"]
[{"$nulls":11},"Inertia gear",{"$nulls":7},{"$f":"IF(L262=2,D114,0)","v":5e-05},{"$nulls":11},"fm = 0,8 ; Full load forward, no load back"]
[{"$nulls":11},"Inertia motor",{"$nulls":7},{"$f":"IF(L266=1,0,IF(L266=2,R206,IF(L266=3,V177,IF(L266=4,P234,IF(L266=5,D127,0)))))","v":0.0005},{"$nulls":11},"fm = 0,48 ; Full load 10% of the stroke forward and 20% rest of cycle"]
[]
[{"$nulls":12},"Total inertia reduced to motor shaft",{"$nulls":5},{"$f":"(S161+T162)/IF(L262=1,1,D111^2)+T163+T164","v":8.2214678512578681E-4}]
[{"$nulls":12},"Inertia balance",{"$nulls":4},{"$f":"S166/T164","v":1.6442935702515735}]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[{"$nulls":12},"AKM servo motor",null,"nom rpm","kW","nom Nm","Nm at max rpm","Peak Nm","Inertia","Brake inertia",null,"Nm/A","mVmin","Ohm"]
[{"$nulls":12},{"$f":"VLOOKUP($L$274,$L$178:M201,M$174)","v":"AKM65M"},{"$f":"VLOOKUP($L$274,$L$175:N198,N174)","v":0},{"$f":"VLOOKUP($L$274,$L$175:O198,O174)","v":2500},{"$f":"VLOOKUP($L$274,$L$175:P198,P174)","v":5.03},{"$f":"VLOOKUP($L$274,$L$175:Q198,Q174)","v":25},{"$f":"VLOOKUP($L$274,$L$175:R198,R174)","v":19.2},{"$f":"VLOOKUP($L$274,$L$175:S198,S174)","v":65.2},{"$f":"VLOOKUP($L$274,$L$175:T198,T174)","v":0.004},{"$f":"VLOOKUP($L$274,$L$175:U198,U174)","v":6.1e-05},{"$f":"VLOOKUP($L$274,$L$175:V198,V174)","v":0.004061},{"$f":"VLOOKUP($L$274,$L$175:W198,W174)","v":1.85},{"$f":"VLOOKUP($L$274,$L$175:X198,X174)","v":119},{"$f":"VLOOKUP($L$274,$L$175:Y198,Y174)","v":0.68}]
[{"$nulls":11},1,"AKM31C",null,5000,0.52,1.15,1,3.88,3.3e-05,1.2e-06,{"$f":"IF($O$266=2,T178+U178,T178)","v":3.4200000000000005E-5},0.85,54.5,21.4]
[{"$nulls":11},2,"AKM32C",null,3000,0.58,2,1.86,6.92,5.9e-05,1.2e-06,6.02E-5,1.4,89.8,23]
[{"$nulls":11},3,"AKM33E",null,4500,1.1,2.79,2.34,9.96,{"v":8.5e-05,"d":"0.000085"},1.2e-06,8.6200000000000008E-5,1.1,70.6,8.36]
[{"$nulls":11},4,"AKM41C",null,3000,0.56,1.95,1.77,6.12,8.1e-05,6.8e-06,8.78e-05,1.34,86.3,21.7]
[{"$nulls":11},5,"AKM42E",null,3500,1.03,3.42,2.81,11.3,0.00015,6.8e-06,0.0001568,1.26,80.9,7.22]
[{"$nulls":11},6,"AKM43E",null,2500,1.03,4.7,3.92,15.9,0.00021,6.8e-06,0.0002168,1.72,111,8.04]
[{"$nulls":11},7,"AKM44G",null,4000,1.57,5.88,3.76,20.2,2.7E-4,6.8e-06,0.0002768,1.19,76.6,2.65]
[{"$nulls":11},8,"AKM51E",null,2500,1.04,4.7,3.98,11.6,0.00034,1.7E-5,3.57E-4,1.72,110,8.47]
[{"$nulls":11},9,"AKM52G",null,2500,1.85,8.43,7.06,21.5,6.2E-4,1.7E-5,0.000637,1.79,115,3.47]
[{"$nulls":11},10,"AKM53K",null,4000,3.2,11.6,7.65,30.1,9.1E-4,1.7E-5,0.000927,1.24,79.8,1]
[{"$nulls":11},11,"AKM54K",null,3500,3.68,14.4,10.05,38.4,0.0012,1.7E-5,1.217E-3,1.5,96.6,1.02]
[{"$nulls":11},12,"AKM62K",null,3500,3.3,12.2,9,30.1,0.0017,6.1e-05,1.761E-3,1.28,82.1,1.05]
[{"$nulls":11},13,"AKM63K",null,3000,4.05,16.8,12.9,42.6,0.0024,6.1e-05,2.4609999999999996E-3,1.71,110,1.09]
[{"$nulls":11},14,"AKM64L",null,3000,4.9,21,15.6,54.1,0.0032,6.1e-05,3.261E-3,1.66,107,0.71]
[{"$nulls":11},15,"AKM65M",null,2500,5.03,25,19.2,65.2,0.004,6.1e-05,0.004061,1.85,119,0.68]
[{"$nulls":11},16]
[{"$nulls":11},17]
[{"$nulls":11},18]
[{"$nulls":11},19]
[{"$nulls":11},20]
[{"$nulls":11},21]
[{"$nulls":11},22]
[{"$nulls":11},23]
[{"$nulls":11},24]
[]
[]
[]
[{"$nulls":12},"AC motors",null,"rpm","kW","Nm","Kgm2"]
[{"$nulls":12},{"$f":"VLOOKUP($L$274,$L$207:M230,M$174)","v":"IEC90 1500 rpm 1,5 kW"},null,{"$f":"VLOOKUP($L$274,$L$204:O227,O$174)","v":1420},{"$f":"VLOOKUP($L$274,$L$204:P227,P$174)","v":1.5},{"$f":"VLOOKUP($L$274,$L$204:Q227,Q$174)","v":10.289070422535213},{"$f":"VLOOKUP($L$274,$L$204:R227,R$174)","v":2.8E-3}]
[{"$nulls":11},1,"IEC 63  3000 rpm  0,25 kW",null,2750,0.25,{"$f":"71620*1.36*P207/O207/10","v":{"v":0.8854836363636365,"d":"0.9"}},0.00023]
[{"$nulls":11},2,"IEC 63  with brake 3000 rpm  0,25 kW",null,2750,0.25,{"v":0.8854836363636365,"d":"0.9"},0.00025]
[{"$nulls":11},3,"IEC 63  1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},0.00025]
[{"$nulls":11},4,"IEC 63  with brake 1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},3.5E-4]
[{"$nulls":11},5,"IEC71 3000 rpm 0,55 kW",null,2760,0.55,{"v":1.9410057971014496,"d":"1.9"},0.00042]
[{"$nulls":11},6,"IEC71 with brake 3000 rpm 0,55 kW",null,2760,0.55,1.9,0.00049]
[{"$nulls":11},7,"IEC71 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00081]
[{"$nulls":11},8,"IEC71 with brake 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00094]
[{"$nulls":11},9,"IEC80 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},0.00098]
[{"$nulls":11},10,"IEC80 with brake 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},{"$f":"0.000061+R215","v":1.041E-3}]
[{"$nulls":11},11,"IEC80 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},1.874E-3]
[{"$nulls":11},12,"IEC80 with brake 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},{"$f":"0.000061+R217","v":0.001935}]
[{"$nulls":11},13,"IEC90 3000 rpm 2,2 kW",null,2860,2.2,7.3,0.00161]
[{"$nulls":11},14,"IEC90 with brake 3000 rpm 2,2 kW",null,2850,2.2,{"v":7.518843508771932,"d":"7.5"},{"$f":"0.0002+R219","v":{"v":1.8100000000000002E-3,"d":"0.00181"}}]
[{"$nulls":11},15,"IEC90 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":2.8E-3,"d":"0.00280"}]
[{"$nulls":11},16,"IEC90 with brake 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":0.0041,"d":"0.00410"}]
[{"$nulls":11},17,"IEC100 3000 rpm 3 kW",null,2850,3,9.9,0.0032]
[{"$nulls":11},18,"IEC100 with brake 3000 rpm 3 kW",null,2850,3,9.9,0.00427]
[{"$nulls":11},19,"IEC100 1500 rpm 3 kW",null,1430,3,20,0.006]
[{"$nulls":11},20,"IEC100 with brake 1500 rpm 3 kW",null,1430,3,20,0.0101]
[{"$nulls":11},21,"IEC112 3000 rpm 4 kW",null,2890,4,13.2,0.00499]
[{"$nulls":11},22,"IEC112 with brake 3000 rpm 4 kW",null,2890,4,13.2,0.0083]
[{"$nulls":11},23,"IEC112 1500 rpm 4 kW",null,1420,4,26.6,0.01114]
[{"$nulls":11},24,"IEC112 with brake 1500 rpm 4 kW",null,1420,4,26.6,0.02]
[]
[]
[{"$nulls":14},"Hold torque","Inertia"]
[{"$nulls":12},{"$f":"VLOOKUP($L$274,$L$235:M258,M$174)","v":"-"},{"$f":"VLOOKUP($L$274,$L$232:N255,N$174)","v":0},{"$f":"VLOOKUP($L$274,$L$232:O255,O$174)","v":"-"},{"$f":"VLOOKUP($L$274,$L$232:P255,P$174)","v":"-"}]
[{"$nulls":11},1,"KML061",null,1.2,2.4e-05]
[{"$nulls":11},2,"KML062",null,1.77,{"v":3.95e-05,"d":"0.000040"}]
[{"$nulls":11},3,"KML063",null,2.47,{"v":5.93e-05,"d":"0.000059"}]
[{"$nulls":11},4,"KML091",null,2.72,{"v":1.13E-4,"d":"0.000113"}]
[{"$nulls":11},5,"KML092",null,5.44,0.000219]
[{"$nulls":11},6,"KML093",null,8.16,0.000332]
[{"$nulls":11},7,"-",null,"-","-"]
[{"$nulls":11},8,"-",null,"-","-"]
[{"$nulls":11},9,"-",null,"-","-"]
[{"$nulls":11},10,"-",null,"-","-"]
[{"$nulls":11},11,"-",null,"-","-"]
[{"$nulls":11},12,"-",null,"-","-"]
[{"$nulls":11},13,"-",null,"-","-"]
[{"$nulls":11},14,"-",null,"-","-"]
[{"$nulls":11},15,"-",null,"-","-"]
[{"$nulls":11},16,"-",null,"-","-"]
[{"$nulls":11},17,"-",null,"-","-"]
[{"$nulls":11},18,"-",null,"-","-"]
[{"$nulls":11},19,"-",null,"-","-"]
[{"$nulls":11},20,"-",null,"-","-"]
[{"$nulls":11},21,"-",null,"-","-"]
[{"$nulls":11},22,"-",null,"-","-"]
[{"$nulls":11},23,"-",null,"-","-"]
[{"$nulls":11},24,"-",null,"-","-"]
[]
[]
[]
[{"$nulls":11},2]
[{"$nulls":11},1,"Direct / coupling"]
[{"$nulls":11},2,"Gear"]
[]
[{"$nulls":11},5,null,null,2]
[{"$nulls":11},1,"No motor",null,1,{"$f":"IF($L$266=3,\"Without brake\",\" \")","v":" "}]
[{"$nulls":11},2,"AC motor",null,2,{"$f":"IF($L$266=3,\"With brake\",\" \")","v":" "}]
[{"$nulls":11},3,"AKM servo motor"]
[{"$nulls":11},4,"Stepper motor"]
[{"$nulls":11},5,"Customer motor"]
[]
[]
[{"$nulls":11},15]
[{"$nulls":11},1,{"$f":"IF($L$266=1,\"-\",IF($L$266=2,M207,IF($L$266=3,M178,IF($L$266=4,M235,\" - \"))))","v":" - "}]
[{"$nulls":11},2," - "]
[{"$nulls":11},3," - "]
[{"$nulls":11},4," - "]
[{"$nulls":11},5," - "]
[{"$nulls":11},6," - "]
[{"$nulls":11},7," - "]
[{"$nulls":11},8," - "]
[{"$nulls":11},9," - "]
[{"$nulls":11},10," - "]
[{"$nulls":11},11," - "]
[{"$nulls":11},12," - "]
[{"$nulls":11},13," - "]
[{"$nulls":11},14," - "]
[{"$nulls":11},15," - "]
[{"$nulls":11},16," - "]
[{"$nulls":11},17," - "]
[{"$nulls":11},18," - "]
[{"$nulls":11},19," - "]
[{"$nulls":11},20," - "]
[{"$nulls":11},21," - "]
[{"$nulls":11},22," - "]
[{"$nulls":11},23," - "]
[{"$nulls":11},24," - "]

{"sheet":"Calculation SCREW","index":1,"n_rows":289,"n_cols":80,"rows_kept":289,"merged":[[2,1,2,3],[3,1,3,3],[4,1,4,3],[4,5,4,6],[23,30,23,31],[37,30,37,31],[50,30,50,31],[63,30,63,31],[76,30,76,31],[89,30,89,31],[99,38,101,38],[99,39,101,39],[101,23,101,24],[101,25,101,26],[101,27,101,28],[101,29,101,30],[101,31,101,32],[101,33,101,34],[126,20,126,21],[126,22,126,23]]}
["Linear unit WM",null,null,"Sizing & selection",{"$nulls":4},"2015 03 23 JHj       Release 1"]
["WM60 WM80 WM120",{"$nulls":22},"max stroke","C/C \"Schlitt\" in long carr","add length C","Min dist carriage LA","Fx max","Fy","Fz","Mx","My","Mz","Frd","Mta","Speed","Acc","Long carriage weight","Carriage weight","Weight",null,"second carriage ","Distance between","ball guide carriage",null,"preload","Cz dyn","Cy dyn","Cx dyn   ball screw","preload ball screw","preload ball bearing",null,"Cr dyn ball bearing","Ball screw diameter","Inertia kgm² / m",{"$nulls":8},"#"]
["Customer",{"$nulls":38},"0 stroke","100 mm","friction N","Lx","Ly",null,"each carriage"]
["Project",{"$nulls":15},2,{"$f":"VLOOKUP($Q$4,$Q$5:R9,R10)","v":"WM60S"},{"$f":"VLOOKUP($Q$4,$Q$5:S9,S10)","v":"Ball screw Ø20 with single ball nut"},{"$f":"VLOOKUP($Q$4,$Q$5:T9,T10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:U9,U10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:V9,V10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:W9,W10)","v":0.02},{"$f":"VLOOKUP($Q$4,$Q$5:X9,X10)","v":5000},{"$f":"VLOOKUP($Q$4,$Q$5:Y9,Y10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:Z9,Z10)","v":480},{"$f":"VLOOKUP($Q$4,$Q$5:AA9,AA10)","v":255},{"$f":"VLOOKUP($Q$4,$Q$5:AB9,AB10)","v":2800},{"$f":"VLOOKUP($Q$4,$Q$5:AC9,AC10)*S13","v":1400},{"$f":"VLOOKUP($Q$4,$Q$5:AD9,AD10)*S13","v":1400},{"$f":"VLOOKUP($Q$4,$Q$5:AE9,AE10)","v":50},{"$f":"VLOOKUP($Q$4,$Q$5:AF9,AF10)","v":100},{"$f":"VLOOKUP($Q$4,$Q$5:AG9,AG10)","v":100},{"$f":"VLOOKUP($Q$4,$Q$5:AH9,AH10)","v":500},{"$f":"VLOOKUP($Q$4,$Q$5:AI9,AI10)","v":35},{"$f":"VLOOKUP($Q$4,$Q$5:AJ9,AJ10)","v":2.5},{"$f":"VLOOKUP($Q$4,$Q$5:AK9,AK10)","v":20},{"$f":"VLOOKUP($Q$4,$Q$5:AL9,AL10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AM9,AM10)","v":1},{"$f":"VLOOKUP($Q$4,$Q$5:AN9,AN10)","v":3.8},{"$f":"VLOOKUP($Q$4,$Q$5:AO9,AO10)","v":0.65},{"$f":"VLOOKUP($Q$4,$Q$5:AP9,AP10)","v":18},{"$f":"VLOOKUP($Q$4,$Q$5:AQ9,AQ10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AR9,AR10)","v":35},{"$f":"VLOOKUP($Q$4,$Q$5:AS9,AS10)","v":"WM06S"},{"$f":"VLOOKUP($Q$4,$Q$5:AT9,AT10)","v":300},{"$f":"VLOOKUP($Q$4,$Q$5:AU9,AU10)","v":23868},{"$f":"VLOOKUP($Q$4,$Q$5:AV9,AV10)","v":25928},{"$f":"BO21","v":10500},{"$f":"VLOOKUP($Q$4,$Q$5:AX9,AX10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AY9,AY10)","v":500},{"$f":"VLOOKUP($Q$4,$Q$5:AZ9,AZ10)","v":"7205 BEP"},{"$f":"VLOOKUP($Q$4,$Q$5:BA9,BA10)","v":20200},{"$f":"VLOOKUP($Q$4,$Q$5:BB9,BB10)","v":20},{"$f":"VLOOKUP($Q$4,$Q$5:BC9,BC10)","v":8.460000000000001E-5},{"$f":"VLOOKUP($Q$4,$Q$5:BD9,BD10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BE9,BE10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BF9,BF10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BG9,BG10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BH9,BH10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BI9,BI10)","v":0}]
["Date",{"$nulls":3},"Ref:","xxx",{"$nulls":10},1,"WM60D","Ball screw Ø20 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=50,5000,11000)","v":{"v":11000,"d":"11,000"}},{"$f":"190+141.7","v":331.7},{"$f":"IF(Q13=2,AV17,AR17)","v":650},335,4000,2000,2000,100,{"$f":"IF($Q$13=1,200,IF($Q$13=2,500,2*$G$18))","v":200},{"$f":"AF5","v":200},500,35,2.5,10,3.1,1.99,6.16,0.65,20,141.7,35,"WM06D",500,{"$f":"4*10581","v":42324},{"$f":"4*11495","v":45980},null,400,500,"7205 BEP",20200,20,{"$f":"8.46*10^-5","v":8.460000000000001E-5}]
[{"$nulls":16},2,"WM60S","Ball screw Ø20 with single ball nut",{"$nulls":3},0.02,{"v":5000,"d":"5,000"},0,{"$f":"AT17","v":480},255,2800,1400,1400,50,{"$f":"IF($Q$13=1,100,IF($Q$13=2,0,1.4*$G$18))","v":100},{"$f":"AF6","v":100},500,35,2.5,20,0,1,3.8,0.65,18,0,35,"WM06S",300,{"$f":"2*11934","v":23868},{"$f":"2*12964","v":25928},null,0,500,"7205 BEP",20200,20,{"$f":"BC5","v":8.460000000000001E-5}]
["Linear drive unit:",{"$nulls":15},3,"WM80D","Ball screw Ø25 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=50,5000,11000)","v":{"v":11000,"d":"11,000"}},{"$f":"170+154","v":324},{"$f":"IF(Q13=2,BB17,AX17)","v":635},360,5000,3000,3000,350,{"$f":"IF($Q$13=1,300,IF($Q$13=2,750,3*$G$18))","v":300},300,700,55,2.5,20,6.4,4.26,11.57,1.08,25,154,48.75,"WM08D",600,{"$f":"4*13739","v":54956},{"$f":"4*14356","v":57424},null,500,700,"7206 BEP",21700,25,{"$f":"2.25*10^-4","v":2.2500000000000002E-4}]
[null,"Size",{"$nulls":14},4,"WM80S","Ball screw Ø25 with single ball nut",{"$nulls":3},0.02,5000,0,{"$f":"AZ17","v":515},280,3500,2100,2100,150,{"$f":"IF($Q$13=1,180,IF($Q$13=2,0,2.1*$G$18))","v":180},180,700,55,2.5,20,0,1.6,7,1.1,22.5,0,48.75,"WM08S",400,{"$f":"2*17919","v":35838},{"$f":"2*18723","v":37446},null,0,700,"7206 BEP",27500,25,{"$f":"BC7","v":2.2500000000000002E-4}]
[{"$nulls":16},5,"WM120D","Ball screw Ø32 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=40,5000,11000)","v":{"v":11000,"d":"11,000"}},{"$f":"180+186","v":366},{"$f":"IF(Q13=2,BF17,BD17)","v":805},450,{"$f":"IF($BO$16=40,8000,12000)","v":{"v":12000,"d":"12,000"}},6000,6000,500,{"$f":"IF($Q$13=1,600,IF($Q$13=2,1500,6*$G$18))","v":600},600,1000,80,2,20,14.2,9.25,25.91,1.93,30,186,80.75,"WM12D",1000,{"$f":"4*17919","v":71676},{"$f":"4*18723","v":74892},null,1200,1500,"7207 BEP",34500,32,{"$f":"6.34*10^-4","v":0.000634}]
[null,"Guidings","  Ball guides",{"$nulls":13},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]
[null,"Drive mechanism",{"$f":"S4","v":"Ball screw Ø20 with single ball nut"}]
[null,"Ball screw lead mm",{"$nulls":16},"Carriages/unit"]
[{"$nulls":16},1,null,{"$f":"IF(Q13=3,2,1)","v":1},null,{"$f":"VLOOKUP(Q13,Q14:U16,5)","v":0},{"$f":"VLOOKUP(Q13,Q14:V16,6)","v":1},{"$f":"VLOOKUP(Q13,Q14:W16,7)","v":"S"},1,{"$f":"IF(X13=1,1,0)","v":1},null,null,"Following assumption is made:  each Nm torque in Mz and My will create a friction force of ",{"$nulls":8},{"$f":"IF(Q4=4,1,1.5)","v":1.5},"N for  WM60S and WM 80S with single carriage"]
[null,"Move per rev",{"$f":"BO16","v":5},"mm",{"$nulls":12},1,{"$f":"IF(OR($Q$4=2,$Q$4=4),\"S = Single short carriage\",\"N = Single standard carriage\")","v":"S = Single short carriage"},null,null,{"$f":"AQ4","v":0},{"$f":"AM4","v":1},{"$f":"IF(OR($Q$4=2,$Q$4=4),\"S\",\"N\")","v":"S"},1,"Yes",null,null,"For other units, this will be concidered to create a pair of forces in Y or Z direction"]
[null,"Repeatability",{"$f":"W4","v":0.02},"mm",{"$nulls":12},2,{"$f":"IF(OR($Q$4=2,$Q$4=4),\" \",\"L = Single long carriage\")","v":" "},null,null,{"$f":"Y4","v":0},{"$f":"IF(Q4=1,1.47,IF(Q4=2,3.43,8.67))","v":3.43},{"$f":"IF(OR($Q$4=2,$Q$4=4),\"? \",\"L\")","v":"? "},2,"No",{"$nulls":22},"Calculation of total length  L tot = stroke + C",{"$nulls":14},"Screw lead"]
[{"$nulls":16},3,{"$f":"IF(OR($Q$4=2,$Q$4=4),\"Y = Double short carriages\",\"Z = Double standard carriages\")","v":"Y = Double short carriages"},null,null,{"$f":"G18","v":500},{"$f":"2*AM4","v":2},{"$f":"IF(OR($Q$4=2,$Q$4=4),\"Y\",\"Z\")","v":"Y"},{"$nulls":20},"WM60D",null,"WM60S","WM60D Long carr.",null,null,"WM80D",null,"WM80S","WM8D0 long carriage",null,null,"WM120D","WM120D long carr",null,null,{"$f":"Q4","v":2},"WM60D","WM60S","WM80D","WM80S","WM120D",1,{"$f":"VLOOKUP(BN16,BN17:BO20,2)","v":5}]
[{"$nulls":5},{"$f":"IF(AND(OR(Q4=2,Q4=4),Q13=2),\"Long carriage not available\",\" \")","v":" "},{"$nulls":20},"Configuration",{"$nulls":4},"If WM60S or WM80S with single carriage, then Yes = 1 otherwise No = 0",{"$nulls":10},"C =",{"$f":"VLOOKUP(C19,AQ18:AR34,2)","v":650},"C =",{"$f":"VLOOKUP(C19,AS18:AT35,2)","v":480},"C =",{"$f":"VLOOKUP(C19,AU18:AV34,2)","v":840},"C =",{"$f":"VLOOKUP(C19,AW18:AX32,2)","v":635},"C =",{"$f":"VLOOKUP(C19,AY18:AZ33,2)","v":515},"C =",{"$f":"VLOOKUP(C19,BA18:BB33,2)","v":805},"C =",{"$f":"VLOOKUP(C19,BC18:BD31,2)","v":805},"C =",{"$f":"VLOOKUP(C19,BE18:BF31,2)","v":985},null,null,5,5,5,5,5,1,5]
[null,"Saddle",null,null,{"$f":"IF(K22=2,\"Not available\",\" \")","v":" "},{"$f":"IF(Q13=3,\"LA =\",\" \")","v":" "},500,{"$f":"IF(Q13=3,\"mm\",\"Only when C-saddle\")","v":"Only when C-saddle"},{"$f":"IF(AND(Q13=3,G18<AA4),\"Too short\",\" \")","v":" "},{"$nulls":7},1,"units",{"$f":"Q18-1","v":0},1,null,null,1,{"$nulls":3},{"$f":"IF(AND(Q18=1,T18=1,W18=1),1,IF(AND(Q18=2,T18=1,W18=1),2,IF(AND(Q18=1,T18=1,W18=2),3,IF(AND(Q18=2,T18=1,W18=2),4,IF(AND(Q18=1,T18=2),5,IF(AND(Q18=2,T18=2),6,\"\"))))))","v":1},{"$nulls":4},{"$f":"IF(AND(Q4=2,Q13=1),1,IF(AND(Q4=4,Q13=1),1,0))","v":1},{"$nulls":10},0,460,0,335,0,650,0,500,0,350,0,670,0,595,0,775,null,null,20,20,10,10,10,2,{"$f":"IF(BH16>2,10,20)","v":20}]
[null,"Stroke",2100,"mm",null,"Total length",{"$f":"C19+Z4+IF(Q13=3,G18,0)","v":2580},"mm",{"$nulls":8},"one single unit",null,null,1,"Horizontal",null,1,{"$f":"IF(T18=1,\"Top or downward\",\" \")","v":"Top or downward"},null,null,{"$f":"R103","v":"Horizontal mounting, single unit, carriage at top"},{"$nulls":15},696,560,581,390,506,750,781,595,681,425,611,765,891,735,711,915,null,null,50,50,20,20,20,3,{"$f":"IF(BH16>2,20,50)","v":50}]
[null,null,{"$f":"IF(C19>X4,\"Longer than standard. Check with plant\",\" \")","v":" "},{"$nulls":13},"two units in parallel",null,null,2,"Vertical",null,2,{"$f":"IF(T18=1,\"Sideway\",\" \")","v":"Sideway"},{"$nulls":18},1336,600,1141,430,1146,790,1536,635,1311,475,1366,805,1696,805,1516,985,{"$nulls":4},50,50,40,4,{"$f":"IF(BH16<=2,\" - \",IF(BH16=5,40,50))","v":" - "}]
[null,null,"Number of units",{"$nulls":39},2076,650,1806,480,1886,840,2376,685,2066,515,2206,855,2626,875,2446,1055,null,null,"Dynamic rating of ball screw  Cx",{"$nulls":4},{"$f":"BN16","v":1},{"$f":"VLOOKUP(BN21,BN22:BO25,2)","v":10500}]
[{"$f":"IF(Q18=2,\"Distance between  linear units\",\" \")","v":" "},null,null,800,{"$nulls":19},"Friction factor =",0.1,{"$nulls":17},2781,690,2461,520,2591,880,3206,725,2831,565,3036,895,3556,945,3376,1125,null,null,10500,10500,12300,12300,21500,1,{"$f":"IF($BH$16<=2,BI22,IF(BH16=5,BM22,BK22))","v":10500}]
[{"$nulls":16},"Horizontal mounting, single unit, carriage at top",{"$nulls":16},"Fx per unit  ","Total Fx at",{"$nulls":7},3546,730,3126,570,3356,920,4046,765,3591,605,3876,935,4486,1015,4306,1195,null,null,11600,11600,13200,13200,33400,2,{"$f":"IF($BH$16<=2,BI23,IF(BH17=5,BM23,BK23))","v":11600}]
[null,null,"Weight of linear drive unit/-s",{"$f":"Q18*(AN4+G19/100*AO4+IF(Q13=2,AL4,IF(Q13=3,1.5*AM4,AM4)))","v":{"v":21.57,"d":"21.6"}},"kg",null,{"$f":"IF(M33=0,\" \",IF(C27/2000>#REF!,\"OK\",\"Too much\"))","v":" "},{"$nulls":9},"Load torques caused by off center load",{"$nulls":5},"at constant",{"$nulls":4},"Max",{"$nulls":5},"during acc  ","  const. speed",{"$nulls":7},4286,780,3781,610,4096,970,4886,815,4355,645,4716,985,5416,1085,5236,1265,null,null,8400,8400,13000,13000,29700,3,8400]
[{"$nulls":5},{"$f":"IF(M33=0,\" \",\"Deflection\")","v":" "},{"$nulls":11},"Static","Dynamic","Totally",null,"Friction","speed",null,"Totally",null,null,"allowed","% of max",{"$nulls":13},5016,820,4446,650,4826,1010,5716,855,5116,695,5546,1025,6346,1145,6166,1325,{"$nulls":4},15400,15400,14900,4,0]
[null,"Mounting direction",{"$nulls":14},"Mx =",{"$f":"$C$49*10*M50/1000","v":0},0,{"$f":"Y13*R26+S26+C46","v":0},"Nm",{"$f":"T26/AR4*1000*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V26","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4*S13)*C53+AP4*S13+V34","v":{"v":18.1,"d":"18"}},"N",{"$f":"AB4","v":2800},{"$nulls":5},{"$f":"Z26","v":{"v":18.1,"d":"18"}},{"$f":"C43+AP4*S13+W34","v":18},{"$nulls":7},5756,870,5111,700,5566,1060,6556,905,5871,735,6386,1075,7286,1215,7106,1395]
[{"$nulls":16},"My =",{"$f":"$C$49*10*M49/1000","v":0},{"$f":"C49*C53*M51/1000","v":0},{"$f":"Y13*R27+S27+C47","v":0},"Nm",{"$f":"IF(AF18=1,T27*AK13,T27/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,(T27-S27)*AK13,(T27-S27)/U13*1000*Y22)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":1400},{"$f":"Z27/AB27","v":{"v":0,"d":"0%"}},{"$nulls":13},6486,910,5766,740,6296,1100,7386,945,6641,785,7216,1115,8216,1275,8036,1455,null,"Ball nut",{"$f":"CONCATENATE(BB4,IF(BO16<10,0,\"\"),BO16,IF(OR(Q4=2,Q4=4),\"-S\",\"-D\"))","v":"2005-S"}]
[{"$nulls":16},"Mz =",0,{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R28+S28+C48","v":0},"Nm",{"$f":"IF(AF18=1,T28*AK13,T28/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,(T28-S28)*AK13,(T28-S28)/U13*1000*Y22)","v":0},null,"Fz =",{"$f":"C45+C49*10*Y13","v":0},"N",{"$f":"AD4","v":1400},{"$f":"Z28/AB28","v":{"v":0,"d":"0%"}},{"$nulls":13},7251,950,6431,790,7061,1140,8261,985,7396,825,8091,1155,9241,1345,9061,1525]
[{"$nulls":24},"Mx =",{"$f":"T26","v":0},"Nm",{"$f":"AE4","v":50},{"$f":"Z29/AB29","v":{"v":0,"d":"0%"}},{"$nulls":13},8011,1000,7091,830,7821,1190,9121,1035,8161,865,8951,1205,10201,1415,10021,1595,null,null,"Idle torque at",150,1500,3000,"rpm"]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z27*Y22","v":0},{"$f":"V30","v":0},null,"My =",{"$f":"T27","v":0},"Nm",{"$f":"AF4","v":100},{"$f":"Z30/AB30","v":{"v":0,"d":"0%"}},{"$nulls":13},8761,1040,7756,870,8571,1230,10046,1075,8926,915,9876,1245,11001,"##",11001,"##",{"$nulls":3},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,2)","v":0.7},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,3)","v":1.1},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,4)","v":1.5},"Nm"]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"Z28*Y22","v":0},{"$f":"V31","v":0},null,"Mz =",{"$f":"T28","v":0},"Nm",{"$f":"AG4","v":100},{"$f":"Z31/AB31","v":{"v":0,"d":"0%"}},{"$nulls":13},9521,1090,8420,920,9331,1280,11001,"##",9731,955,10831,"##",15000,null,15000,{"$nulls":3},"2005-D",0.8,1.4,1.8]
[{"$nulls":42},10271,1130,9076,960,10081,1320,15000,null,10541,"##",15000,{"$nulls":7},"2005-S",0.7,1.1,1.5]
[{"$nulls":27},"Totally",{"$f":"SUM(AC27:AC32)","v":{"v":0,"d":"0%"}},{"$nulls":13},11001,"##",9741,1010,11001,"##",null,null,15000,{"$nulls":9},"2020-D",1.3,2,2.3]
[{"$nulls":20},"Totally",{"$f":"SUM(V26:V33)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W26:W33)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":18},15000,null,10391,"##",15000,{"$nulls":13},"2020-S",1,1.6,1.8]
[{"$nulls":44},15000,{"$nulls":15},"2050-D",1.6,2.4,2.6]
[{"$nulls":60},"2050-S",1.4,2,2.2]
[{"$nulls":16},"Horizontal mounting, 2 units, carriage at top",{"$nulls":43},"2505-D",1.1,1.7,2.1]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max",{"$nulls":32},"2505-S",0.9,1.3,1.7]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",{"$nulls":31},"2510-D",1.5,2.1,2.5]
[{"$nulls":16},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},0,null,"Fx =",{"$f":"C43+T42/D22*1000+(C49+AM4*2)*C53+V48+AP4*2*S13+V41/D22*1000*2","v":{"v":36.2,"d":"36"}},"N",{"$f":"2*AB4","v":5600},{"$nulls":5},{"$f":"Z40*(D22/2+M50)/D22","v":{"v":18.1,"d":"18"}},{"$f":"C43+T42/D22*1000+W48+AP4*2*S13+V41/D22*1000*2","v":36},{"$nulls":25},"2510-S",1.1,1.5,1.8]
[{"$nulls":16},"My =",{"$f":"C49*10*M49/1000","v":0},{"$f":"C49*C53*M51/1000","v":0},{"$f":"Y13*R41+S41+C47","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T41,T41/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(T41-S41),(T41-S41)/U13*1000*Y22)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4*1","v":1400},{"$f":"Z41/AB41","v":{"v":0,"d":"0%"}},{"$nulls":31},"2520-D",1.8,2.3,2.6]
[{"$nulls":16},"Mz =",0,{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R42+S42+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+C49*10*Y13+C46/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":2800},{"$f":"Z42/AB42","v":{"v":0,"d":"0%"}},{"$nulls":31},"2520-S",1.3,1.8,2]
[null,"Fx =",0,"N",{"$f":"IF(C43>$AB$4*$Q$18,\"Too much\",\" \")","v":" "},null,null,{"$f":"IF(T18=2,\" \",\"Orientation of carriage\")","v":"Orientation of carriage"},{"$nulls":16},"Mx =",{"$f":"T40","v":0},"Nm",{"$nulls":3},"Anser att Mx blir ett kraftpar som ökar Fz",{"$nulls":29},"2550-D",2.3,3,3.6]
[null,"Fy =",0,"N",{"$f":"IF(C44>AC4*$Q$18,\"Too much\",\" \")","v":" "},{"$nulls":11},"Fy =",{"$nulls":4},{"$f":"C44*Y22","v":0},{"$f":"V44","v":0},null,"My =",{"$f":"T41","v":0},"Nm",{"$f":"AF4*2","v":200},{"$f":"Z44/AB44","v":{"v":0,"d":"0%"}},{"$nulls":31},"2550-S",2,2.4,2.9]
[null,"Fz =",0,"N",{"$f":"IF(C45>AD4*$Q$18,\"Too much\",\" \")","v":" "},{"$nulls":11},"Fz =",{"$nulls":4},{"$f":"(C49*10*Y13+C45)*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V45","v":0},null,"Mz =",{"$f":"T42","v":0},"Nm",{"$nulls":3},"Anser att Mz blir ett kraftpar som ökar Fx",{"$nulls":29},"3205-D",1.4,2.5,3,{"$nulls":15}," Please note:"]
[null,"Mx =",0,"Nm",{"$f":"IF(Q18=2,\" \",IF(C46>AE4,\"Too much\",\" \"))","v":" "},{"$nulls":55},"3210-D",2,3,3.7,{"$nulls":15}," Fx, Fy, Fz, Mx, My and Mz are external forces and torques and "]
[null,"My =",0,"Nm",{"$f":"IF(C47>AF4*$Q$18,\"Too much\",\" \")","v":" "},{"$nulls":22},"Totally",{"$f":"SUM(AC41:AC46)","v":{"v":0,"d":"0%"}},{"$nulls":31},"3220-D",2.3,3.3,4,{"$nulls":15}," are not connected with or caused by \"Total mass to move\""]
[null,"Mz =",0,"Nm",{"$f":"IF(Q18=2,\" \",IF(C48>$AG$4,\"Too much\",\" \"))","v":" "},{"$nulls":7},"ABS",{"$nulls":7},"Totally",{"$f":"SUM(V40:V47)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W40:W47)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":36},"3240-D",2.4,3.8,4.3]
[null,"Total mass to move",0,"kg         in location from top of carriage",{"$nulls":3},"Lx =",0,"mm",null,null,{"$f":"ABS(I49)","v":0}]
["Will this mass be carried by the carriage/carriages?",{"$nulls":6},"Ly =",0,"mm",null,null,{"$f":"ABS(I50)","v":0},{"$nulls":3},"Horizontal mounting, single unit, carriage sideway"]
[{"$nulls":7},"Lz =",0,"mm",null,null,0,{"$nulls":3},"Load torques caused by off center load",{"$nulls":10},"Max"]
[null,"Speed",0.2,"m/s",{"$f":"IF(C52>AJ4,\"Too high speed\",\" \")","v":" "},null,{"$f":"IF(R112>3001,\"Too high rpm \",\" \")","v":" "},{"$nulls":10},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[null,"Acceleration",0.1,"m/s²",{"$f":"IF(C53>AK4,\"Too high acceleration\",\" \")","v":" "},{"$nulls":11},"Mx =",{"$f":"C49*10*M51/1000","v":0},0,{"$f":"Y13*R53+C46","v":0},"Nm",{"$f":"T53/AR4*1000*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V53","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4)*C53+AP4*S13+V61","v":{"v":18.1,"d":"18"}},"N",{"$f":"AB4","v":2800},{"$nulls":5},{"$f":"Z53","v":{"v":18.1,"d":"18"}},{"$f":"C43+AP4*S13+W61","v":18}]
[{"$nulls":16},"My =",0,{"$f":"C49*C53*M51/1000","v":0},{"$f":"S54+C47","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T54,T54/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(T54-S54),(T54-S54)/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},null,"Fy =",{"$f":"C44+Y13*C49*10","v":0},"N",{"$f":"AC4","v":1400},{"$f":"Z54/AB54","v":{"v":0,"d":"0%"}}]
["Move profile over",null,2000,"mm stroke",null,{"$f":"IF(C55>C19,\"This is longer than stroke of unit !\",\" \")","v":" "},{"$nulls":10},"Mz =",{"$f":"C49*10*M49/1000","v":0},{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R55+S55+C48","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T55,T55/AQ4*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(T55-S55),(T55-S55)/AQ4*1000*Y22)","v":{"v":0,"d":"0.0"}},null,"Fz =",{"$f":"C45","v":0},"N",{"$f":"AD4","v":1400},{"$f":"Z55/AB55","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",{"$f":"T53","v":0},"Nm",{"$f":"AE4","v":50},{"$f":"Z56/AB56","v":{"v":0,"d":"0%"}}]
["Time to move one direction",{"$nulls":15},"Fy =",{"$nulls":4},{"$f":"Z54*Y22","v":0},{"$f":"V57","v":0},null,"My =",{"$f":"T54","v":0},"Nm",{"$f":"AF4","v":100},{"$f":"Z57/AB57","v":{"v":0,"d":"0%"}}]
[null,null,{"$f":"Blad2!C14","v":{"v":12,"d":"12.00"}},"sec",{"$nulls":12},"Fz =",{"$nulls":4},{"$f":"C45*Y22","v":0},{"$f":"V58","v":0},null,"Mz =",{"$f":"T55","v":0},"Nm",{"$f":"AG4","v":100},{"$f":"Z58/AB58","v":{"v":0,"d":"0%"}}]
[]
[{"$f":"Blad2!A17","v":" "},{"$nulls":26},"Totally",{"$f":"SUM(AC54:AC59)","v":{"v":0,"d":"0%"}}]
[{"$f":"Blad2!A18","v":" "},null,{"$f":"Blad2!C18","v":" "},{"$f":"Blad2!D18","v":" "},{"$nulls":16},"Totally",{"$f":"SUM(V53:V60)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W53:W60)","v":{"v":0,"d":"0.0"}},"N"]
[]
[{"$nulls":16},"Horizontal mounting, two units, carriages sideway"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[{"$nulls":16},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},0,null,"Fx =",{"$f":"C43+V74+T68/D22*1000+(C49+AM4*2*S13)*C53","v":{"v":0.2,"d":"0"}},"N",{"$f":"AB4*2","v":5600},{"$nulls":5},{"$f":"Z66*(D22/2+M50)/D22","v":0.1},{"$f":"C43+V75","v":0}]
[{"$nulls":16},"My =",0,{"$f":"C49*C53*M51/1000","v":0},{"$f":"C47+S67","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T67,T67/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(T67-S67),(T67-S67)/U13*1000*Y22)","v":0},null,"Fy =",{"$f":"C44+C49*10*Y13","v":0},"N",{"$f":"AC4","v":1400},{"$f":"Z67/AB67","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Mz =",{"$f":"C49*10*M49/1000","v":0},{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R68+S68+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+Y13*C49*10*M51/1000/D22*1000+C46/D22*1000","v":0},"N",{"$f":"AD4*2","v":2800},{"$f":"Z68/AB68","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",0,"Nm",null,null,"Anser att Mx blir ett kraftpar som ökar Fz"]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z67*Y22","v":0},{"$f":"V70","v":0},null,"My =",{"$f":"T67","v":0},"Nm",{"$f":"AF4*2","v":200},{"$f":"Z70/AB70","v":{"v":0,"d":"0%"}}]
[{"$f":"R103","v":"Horizontal mounting, single unit, carriage at top"},{"$nulls":15},"Fz =",{"$nulls":4},{"$f":"Z68*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V71","v":{"v":0,"d":"0.0"}},null,"Mz =",{"$f":"T68","v":0},"Nm",null,null,"Anser att Mz blir ett kraftpar som ökar Fx"]
[]
[null,"Result:",null,"Allowed",{"$nulls":23},"Totally",{"$f":"SUM(AC67:AC72)","v":{"v":0,"d":"0%"}}]
["Fx =",{"$f":"X103","v":{"v":18.1,"d":"18"}},"N",{"$f":"Y103","v":2800},"N",{"$f":"IF(B74>D74,\"Too much !\",\" \")","v":" "},{"$nulls":14},"Totally",{"$f":"SUM(V66:V73)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W66:W73)","v":{"v":0,"d":"0.0"}},"N"]
["Fy =",{"$f":"Z103","v":0},"N",{"$f":"AA103","v":1400},"N"," "]
["Fz =",{"$f":"AB103","v":0},"N",{"$f":"AC103","v":1400},"N"," ",{"$nulls":10},"Vertical mounting, single unit"]
["Mx =",{"$f":"AD103","v":0},"Nm",{"$f":"AE103","v":50},"Nm"," ",{"$nulls":10},"Load torques caused by off center load",{"$nulls":10},"Max"]
["My =",{"$f":"AF103","v":0},"Nm",{"$f":"AG103","v":100},"Nm"," ",{"$nulls":11},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
["Mz =",{"$f":"AH103","v":0},"Nm",{"$f":"AI103","v":100},"Nm"," ",{"$nulls":10},"Mx =",0,0,{"$f":"C46","v":0},"Nm",{"$f":"T79/AR4*1000*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V79","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+(C49+AM4*S13)*C53+AP4*S13+V87+C49*10","v":{"v":18.1,"d":"18"}},"N",{"$f":"AB4","v":2800},{"$nulls":5},{"$f":"Z79","v":{"v":18.1,"d":"18"}},{"$f":"C43+AP4*S13+W87+C49*10","v":18}]
[{"$nulls":5},"Total dynamic load combined all directions (apart of Fx)",{"$f":"AJ103","v":{"v":1E-3,"d":"0%"}},{"$nulls":9},"My =",{"$f":"C49*10*M51/1000","v":0},{"$f":"C49*C53*M51/1000","v":0},{"$f":"Y13*R80+S80+C47","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T80,T80/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(R80+C47),(R80+C47)/U13*1000*Y22)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":1400},{"$f":"Z80/AB80","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IF(AJ103>1,\"The total load is too much ! Select bigger unit or another configuration.\",IF(B74>D74,\"The axial force is too much ! Select bigger unit or another configuration.\",\" \"))","v":" "},{"$nulls":14},"Mz =",{"$f":"C49*10*M50/1000","v":0},{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R81+S81+C48","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T81,T81/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(C48+R81),(C48+R81)/U13*1000*Y22)","v":0},null,"Fz =",{"$f":"C45","v":0},"N",{"$f":"AD4","v":1400},{"$f":"Z81/AB81","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",{"$f":"T79","v":0},"Nm",{"$f":"AE4","v":50},{"$f":"Z82/AB82","v":{"v":0,"d":"0%"}}]
[null,"Designation:  ",{"$f":"CONCATENATE(AS4,\"0\",IF(BO16<10,0,\"\"),BO16,IF(C19<1000,\"-00\",IF(C19<10000,\"-0\",\"-\")),C19,IF(G19<1000,\"-00\",IF(G19<10000,\"-0\",\"-\")),G19,\"x\",W13,IF(Q13<3,\"-0000\",-G18))","v":"WM06S005-02100-02580xS-0000"},{"$nulls":13},"Fy =",{"$nulls":4},{"$f":"C44*Y22","v":0},{"$f":"V83","v":0},null,"My =",{"$f":"T80","v":0},"Nm",{"$f":"AF4","v":100},{"$f":"Z83/AB83","v":{"v":0,"d":"0%"}}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"C45*Y22","v":0},{"$f":"V84","v":0},null,"Mz =",{"$f":"T81","v":0},"Nm",{"$f":"AG4","v":100},{"$f":"Z84/AB84","v":{"v":0,"d":"0%"}}]
[null,"Calculation of lifetime"]
[{"$nulls":27},"Totally",{"$f":"SUM(AC80:AC85)","v":{"v":0,"d":"0%"}}]
[null,null,"Average load factor fm",1,{"$nulls":16},"Totally",{"$f":"SUM(V79:V86)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W79:W86)","v":{"v":0,"d":"0.0"}},"N"]
[null,null,"Ball guide",{"$f":"IF(R116<100000,R116,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(P116>5*10^7,\">50 000\",P116/1000)","v":">50 000"},"km"]
[null,null,"Ball screw",{"$f":"IF(T119<100000,T119,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(R119>5*10^7,\">50 000\",R119/1000)","v":">50 000"},"km",{"$nulls":9},"Vertical  mounting, two units"]
[null,null,"Ball bearing drive end",{"$f":"IF(T122<100000,T122,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(R122>5*10^7,\">50 000\",R122/1000)","v":">50 000"},"km",{"$nulls":9},"Load torques caused by off center load",{"$nulls":10},"Max"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max"]
[null,null,"number of cycles per minute",1,null,"Duty cycle",{"$f":"D92*2*C58/60","v":{"v":0.4,"d":"40%"}},{"$f":"IF(G92>1,\"Not possible !\",\" \")","v":" "},{"$nulls":8},"Mx =",0,0,0,"Nm",{"$f":"C46/D22*1000*Y22","v":{"v":0,"d":"0.0"}},{"$f":"V92","v":{"v":0,"d":"0.0"}},null,"Fx =",{"$f":"C43+C49*10+2*AM4*S13+2*AP4*S13+T94/D22*1000+(C49+2*AM4*S13)*C53","v":{"v":38.2,"d":"38"}},"N",{"$f":"AB4*2","v":5600},{"$nulls":5},{"$f":"Z92*(D22/2+M50)/D22","v":{"v":19.1,"d":"19"}},{"$f":"C43+C49*10+2*AM4*S13+2*AP4*S13","v":38}]
[null,null,"Working hours per day",8,{"$nulls":12},"My =",{"$f":"C49*M51*10/1000","v":0},{"$f":"C49*C53*M51/1000","v":0},{"$f":"Y13*R93+S93+C47","v":0},"Nm",{"$f":"IF(AF18=1,AK13*T93,T93/U13*1000*Y22)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AF18=1,AK13*(R93+C47),(R93+C47)/U13*1000*Y22)","v":0},null,"Fy =",{"$f":"C44","v":0},"N",{"$f":"AC4","v":1400},{"$f":"Z93/AB93","v":{"v":0,"d":"0%"}}]
[null,null,"Working days per year",220,{"$nulls":12},"Mz =",{"$f":"C49*10*M50/1000","v":0},{"$f":"C49*C53*M50/1000","v":0},{"$f":"Y13*R94+S94+C48","v":0},"Nm",{"v":0,"d":"0.0"},0,null,"Fz =",{"$f":"C45+C46/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":2800},{"$f":"Z94/AB94","v":{"v":0,"d":"0%"}}]
[{"$nulls":24},"Mx =",0,"Nm",null,null,"Anser att Mx blir ett kraftpar som ökar Fz"]
[null,null,"Lifetime ",{"$f":"IF(P116*10^3/C55/2/D92/60/D93/D94>50,\"> 50\",P116*10^3/C55/2/D92/60/D93/D94)","v":"> 50"},"Years","Ball guide",{"$nulls":10},"Fy =",{"$nulls":4},{"$f":"C44*Y22","v":0},{"$f":"V96","v":0},null,"My =",{"$f":"T93","v":0},"Nm",{"$f":"AF4*2","v":200},{"$f":"Z96/AB96","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},{"$f":"IF(V119>50,\"> 50\",V119)","v":"> 50"},"Years","Ball screw",{"$nulls":10},"Fz =",{"$nulls":4},{"$f":"Z94*Y22","v":0},{"$f":"V97","v":0},null,"Mz =",{"$f":"T94","v":0},"Nm",null,null,"Anser att Mz blir ett kraftpar som ökar Fx"]
[{"$nulls":3},{"$f":"IF(V122>50,\"> 50\",V122)","v":"> 50"},"Years","Ball bearing drive end"]
[{"$nulls":27},"Totally",{"$f":"SUM(AC93:AC98)","v":{"v":0,"d":"0%"}}]
[{"$nulls":20},"Totally",{"$f":"SUM(V92:V99)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W92:W99)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":8},"klart hit",{"$nulls":5},"Total Fx  at const speed","Total Fx during acc"]
[null,null,"Idle torque at no load",{"$f":"N135","v":{"v":0.8600000000000001,"d":"0.86"}},"Nm and",{"$f":"R112","v":{"v":2400,"d":"2,400"}},"rpm at",{"$f":"C52","v":0.2},"m/s",{"$nulls":27},"Max Fx"]
[{"$nulls":23},"Fx",null,"Fy",null,"Fz",null,"Mx",null,"My",null,"Mz",null,"Total","one unit"]
[null,null,"Drive torque at constant speed",{"$f":"P145","v":{"v":0.8759154943091896,"d":"0.88"}},"Nm and",{"$f":"D103*R112/9.55","v":{"v":220.12535982639318,"d":"220"}},"W",{"$nulls":10},{"$f":"VLOOKUP($AA$18,$Q$104:R109,2)","v":"Horizontal mounting, single unit, carriage at top"},{"$f":"VLOOKUP($AA$18,$Q$104:S109,2)","v":"Horizontal mounting, single unit, carriage at top"},{"$nulls":4},{"$f":"VLOOKUP($AA$18,$Q$104:X109,8)","v":{"v":18.1,"d":"18"}},{"$f":"VLOOKUP($AA$18,$Q$104:Y109,9)","v":2800},{"$f":"VLOOKUP($AA$18,$Q$104:Z109,10)","v":0},{"$f":"VLOOKUP($AA$18,$Q$104:AA109,11)","v":1400},{"$f":"VLOOKUP($AA$18,$Q$104:AB109,12)","v":0},{"$f":"VLOOKUP($AA$18,$Q$104:AC109,13)","v":1400},{"$f":"VLOOKUP($AA$18,$Q$104:AD109,14)","v":0},{"$f":"VLOOKUP($AA$18,$Q$104:AE109,15)","v":50},{"$f":"VLOOKUP($AA$18,$Q$104:AF109,16)","v":0},{"$f":"VLOOKUP($AA$18,$Q$104:AG109,17)","v":100},{"$f":"VLOOKUP($AA$18,$Q$104:AH109,18)","v":0},{"$f":"VLOOKUP($AA$18,$Q$104:AI109,19)","v":100},{"$f":"VLOOKUP($AA$18,$Q$104:AJ109,20)+0.001","v":{"v":1E-3,"d":"0%"}},{"$f":"VLOOKUP($AA$18,$Q$104:AK109,21)","v":18.1},{"$f":"VLOOKUP($AA$18,$Q$104:AL109,22)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$18,$Q$104:AM109,23)","v":{"v":18,"d":"18.0"}},{"$f":"VLOOKUP($AA$18,$Q$104:AN109,24)","v":18.1}]
[null,null,"Drive torque during acc",{"$f":"P146","v":{"v":0.903432279534568,"d":"0.90"}},"Nm and",{"$f":"D104*R112/9.55","v":{"v":227.04057286732595,"d":"227"}},"W",{"$nulls":9},1,"Horizontal mounting, single unit, carriage at top",{"$nulls":5},{"$f":"Z26","v":{"v":18.1,"d":"18"}},{"$f":"AB26","v":2800},{"$f":"Z27","v":0},{"$f":"AB27","v":1400},{"$f":"Z28","v":0},{"$f":"AB28","v":1400},{"$f":"Z29","v":0},{"$f":"AB29","v":50},{"$f":"Z30","v":0},{"$f":"AB30","v":100},{"$f":"Z31","v":0},{"$f":"AB31","v":100},{"$f":"AC33","v":{"v":0,"d":"0%"}},{"$f":"AH26","v":18.1},{"$f":"AF33","v":{"v":0,"d":"0.0"}},{"$f":"AI26","v":{"v":18,"d":"18.0"}},{"$f":"AH26","v":18.1}]
[null,null,"System inertia",{"$f":"S154","v":2.1890125739776461E-4},"kg m² (excluding gear, motor etc)",{"$nulls":11},2,"Horizontal mounting, 2 units, carriage at top",{"$nulls":5},{"$f":"Z40","v":{"v":36.2,"d":"36"}},{"$f":"AB40","v":5600},{"$f":"Z41","v":0},{"$f":"AB41","v":1400},{"$f":"Z42","v":0},{"$f":"AB42","v":2800},{"$f":"IF(Z43=0,\" - \",Z43)","v":" - "},{"$f":"IF(AB43=0,\" - \",AB43)","v":" - "},{"$f":"Z44","v":0},{"$f":"AB44","v":200},{"$f":"Z45","v":0},{"$f":"IF(AB45=0,\" - \",AB45)","v":" - "},{"$f":"AC47","v":{"v":0,"d":"0%"}},{"$f":"AH40","v":18.1},{"$f":"AF47","v":0},{"$f":"AI40","v":{"v":36,"d":"36.0"}},{"$f":"AH40*2","v":36.2}]
[null,{"$f":"IF(AND(Q18=1,P146>AI4),\"Too high drive torque\",IF(AND(Q18=2,P146>2*AI4),\"Too high drive torque\",\" \"))","v":" "},{"$nulls":14},3,"Horizontal mounting, single unit, carriage sideway",{"$nulls":5},{"$f":"Z53","v":{"v":18.1,"d":"18"}},{"$f":"AB53","v":2800},{"$f":"Z54","v":0},{"$f":"AB54","v":1400},{"$f":"Z55","v":0},{"$f":"AB55","v":1400},{"$f":"Z56","v":0},{"$f":"AB56","v":50},{"$f":"Z57","v":0},{"$f":"AB57","v":100},{"$f":"Z58","v":0},{"$f":"AB58","v":100},{"$f":"AC60","v":{"v":0,"d":"0%"}},{"$f":"AH53","v":18.1},{"$f":"AF60","v":{"v":0,"d":"0.0"}},{"$f":"AI53","v":{"v":18,"d":"18.0"}},{"$f":"AH53","v":18.1}]
[{"$nulls":16},4,"Horizontal mounting, two units, carriages sideway",{"$nulls":5},{"$f":"Z66","v":{"v":0.2,"d":"0"}},{"$f":"AB66","v":5600},{"$f":"Z67","v":0},{"$f":"AB67","v":1400},{"$f":"Z68","v":0},{"$f":"AB68","v":2800},{"$f":"IF(Z69=0,\" - \",Z69)","v":" - "},{"$f":"IF(AB69=0,\" - \",AB69)","v":" - "},{"$f":"Z70","v":0},{"$f":"AB70","v":200},{"$f":"Z71","v":0},{"$f":"IF(AB71=0,\" - \",AB71)","v":" - "},{"$f":"AC73","v":{"v":0,"d":"0%"}},{"$f":"AH66","v":0.1},{"$f":"AF73","v":0},{"$f":"AI66","v":{"v":0,"d":"0.0"}},{"$f":"AH66*2","v":0.2}]
[null,"Gear / Motor",{"$nulls":14},5,"Vertical mounting, single unit",{"$nulls":5},{"$f":"Z79","v":{"v":18.1,"d":"18"}},{"$f":"AB79","v":2800},{"$f":"Z80","v":0},{"$f":"AB80","v":1400},{"$f":"Z81","v":0},{"$f":"AB81","v":1400},{"$f":"Z82","v":0},{"$f":"AB82","v":50},{"$f":"Z83","v":0},{"$f":"AB83","v":100},{"$f":"Z84","v":0},{"$f":"AB84","v":100},{"$f":"AC86","v":{"v":0,"d":"0%"}},{"$f":"AH79","v":18.1},{"$f":"AF86","v":{"v":0,"d":"0.0"}},{"$f":"AI79","v":18},{"$f":"AH79","v":18.1}]
[{"$nulls":16},6,"Vertical  mounting, two units",{"$nulls":5},{"$f":"Z92","v":{"v":38.2,"d":"38"}},{"$f":"AB92","v":5600},{"$f":"Z93","v":0},{"$f":"AB93","v":1400},{"$f":"Z94","v":0},{"$f":"AB94","v":2800},{"$f":"IF(Z95=0,\" - \",Z95)","v":" - "},{"$f":"IF(AB95=0,\" - \",AB95)","v":" - "},{"$f":"Z96","v":0},{"$f":"AB96","v":200},{"$f":"Z97","v":0},{"$f":"AB97","v":0},{"$f":"AC99","v":{"v":0,"d":"0%"}},{"$f":"AH92","v":19.1},{"$f":"AF99","v":0},{"$f":"AI92","v":38},{"$f":"AH92*2","v":38.2}]
[]
[null,null,{"$f":"IF($L$253=2,\"Ratio\",\" \")","v":" "},2]
[null,null,{"$f":"IF($L$253=2,\"Effiency factor\",\" \")","v":" "},{"v":0.95,"d":"95%"},{"$nulls":12},"rpm ball screw",{"$f":"$C$52*1000/BO16*60","v":2400},null,"motor speed",{"$f":"R112*IF(L253=1,1,D111)","v":2400},"rpm"]
[null,null,{"$f":"IF($L$253=2,\"Idle torque\",\" \")","v":" "},0.1,{"$f":"IF($L$253=2,\"Nm\",\" \")","v":" "}]
[null,null,{"$f":"IF($L$253=2,\"Inertia\",\" \")","v":" "},5e-05,{"$f":"IF($L$253=2,\"kg m²\",\" \")","v":" "},{"$f":"IF(AND(L253=2,Q18=2),\"Total inertia for gears and parallel shaft\",\" \")","v":" "},{"$nulls":7},"Calculation of lifetime.",null,null,"The lifetime of the ball guides will be based on the total % of load in all directions and the max allowed Fz load compared to Cz value for the ball guides"]
[{"$nulls":13},"Lh ball guide = (C / ( Fz x %))^3 x 10^5  m"]
[{"$nulls":13},"Lifetime ball guide =",null,{"$f":"(AU4*Q18*T18/(AD4+AT4)/AJ103/D87)^3*10^5","v":2.767587263999999E+17},"m",{"$f":"P116/C52/3600","v":384387119999999.9},"h"]
[]
[{"$nulls":13},"Lh ball screw = (C / Fx)^3 x 10^6  revolutions"]
[null,null,{"$f":"IF(OR(L257=2,L257=3),\"Nominal torque\",IF(L257=4,\"Holding torque\",\" \"))","v":"Nominal torque"},{"$f":"IF(L257=2,Q197,IF(L257=3,R168,IF(L257=4,O225,\" \")))","v":{"v":2.630597372262774,"d":"2.6"}},{"$f":"IF(L257=2,\"Nm\",IF(L257=3,\"Nm at max speed\",IF(L257=4,\"Nm\",\" \")))","v":"Nm"},{"$nulls":8},"Lifetime ball screw =",null,{"$f":"(AW4/(AK103+AX4)/D87)^3*10^6","v":195223535058276.5},"rev   =",{"$f":"P119*BO16/1000","v":976117675291.3824},"m  =",{"$f":"R119/C52/3600","v":{"v":1355718993.4602535,"d":"1,355,718,993"}},"h",{"$f":"R119*1000/C55/2/D92/60/D93/D94","v":{"v":2310884.6479436136,"d":"2310884.6"}}]
[null,null,{"$f":"IF($L$257=2,\"Nominal speed\",IF($L$257=3,\"Peak torque\",\" \"))","v":"Nominal speed"},{"$f":"IF(L257=2,O197,IF(L257=3,S168,\" \"))","v":1370},{"$f":"IF($L$257=2,\"rpm\",IF($L$257=3,\"Nm\",\" \"))","v":"rpm"}]
[null,null,{"$f":"IF($L$257=2,\"Nominal power\",IF($L$257=3,\"Max speed\",\" \"))","v":"Nominal power"},{"$f":"IF(L257=2,P197,IF(L257=3,O168,\" \"))","v":0.37},{"$f":"IF($L$257=2,\"kW\",IF($L$257=3,\"rpm\",\" \"))","v":"kW"}]
[null,null,{"$f":"IF(L257=3,\"Nominal power\",\" \")","v":" "},{"$f":"IF(L257=3,P168,\" \")","v":" "},{"$f":"IF(L257=3,\"kW\",\" \")","v":" "},{"$nulls":8},"Lifetime ball bearing =",null,{"$f":"(BA4/(AY4+AK103)/D87)^3*10^6","v":59267052808.738976},"rev    =",{"$f":"P122*BO16/1000","v":296335264.0436949},"m  =",{"$f":"R122/C52/3600","v":{"v":411576.7556162429,"d":"411,577"}},"h",{"$f":"R122*1000/C55/2/D92/60/D93/D94","v":{"v":701.5512879822322,"d":"701.6"}}]
[null,null,{"$f":"IF(L257=5,\"Customer motor data:\",\" \")","v":" "},"Supplier, torque, power, rpm etc",{"$nulls":24},{"$f":"2*0.19*10^-4+1.35*10^-6","v":3.935e-05}]
[{"$nulls":28},{"$f":"2*0.78*10^-4+6.7*10^-6","v":1.6270000000000002E-4}]
[{"$nulls":13},"Efficieny factor ball nut =",{"v":0.9,"d":"90%"},{"$nulls":12},{"$f":"2*4.18*10^-4+6.7*10^-6","v":8.4269999999999994E-4},{"$f":"2*184*10^-6+15*10^-6","v":0.000383}]
[]
[null,null,{"$f":"IF(L257=5,\"Motor inertia:\",\" \")","v":" "},0.0003,{"$f":"IF(L257=5,\"kg m²\",\" \")","v":" "}]
[{"$nulls":24},{"$f":"IF(Q4<=2,2,IF(Q4=5,4,3))","v":2},null,null,"kg m²"]
[null,"Required motor data",{"$nulls":24},{"$f":"VLOOKUP(Y128,Z130:AB133,2)","v":"GS19"},{"$f":"VLOOKUP(Y128,Z130:AB133,3)","v":3.9e-05}]
[null,null,"Torque at constant speed",{"$f":"Z145","v":{"v":0.8847631255648379,"d":"0.88"}},"Nm",{"$nulls":6},{"$f":"BI29","v":"Idle torque at"},150,1500,3000,"rpm",{"$nulls":9},1,"GS14",{"$f":"0.0000065","v":6.5e-06}]
[null,null," Torque during acceleration",{"$f":"Z146","v":{"v":1.0188915234939973,"d":"1.02"}},"Nm",{"$nulls":6},0,0.7,1.1,1.5,"Nm",{"$nulls":8},"WM60",2,"GS19",3.9e-05]
[null,null,"Power at constant speed",{"$f":"D130*D134/9550","v":{"v":0.22234884830948806,"d":"0.22"}},"kW",{"$nulls":19},"WM80",3,"GS24",1.63E-4]
[null,null,"Power during acceleration",{"$f":"D131*D134/9550","v":{"v":0.2560565085220517,"d":"0.26"}},"kW",{"$f":"D134/D120*50","v":{"v":87.59124087591242,"d":"88"}},{"$f":"IF(L257=2,\"Hz\",\" \")","v":"Hz"},{"$nulls":4},"Idle torque Nm",null,{"$f":"IF(R112<=150,M131,IF(AND(R112>150,R112<=1500),M131+(R112-150)/1350*(N131-M131),N131+(R112-1500)/(Q129-1500)*(O131-N131)))","v":{"v":0.8600000000000001,"d":"0.86"}},"Single unit, single carriage",{"$nulls":9},"WM120",4,"GS28",0.00038]
[null,null,"Max speed",{"$f":"U112","v":{"v":2400,"d":"2,400"}},"rpm",{"$nulls":8},{"$f":"(S13-1)*AP4*BO16/2/1000/PI()/0.9","v":{"v":0,"d":"0.00"}},"additional carriage"]
[null,null,"Inertia balance",{"$f":"R161","v":{"v":1.3183966140713144,"d":"1.3"}},{"$nulls":8},"Totally",{"$f":"(N134+N133)*Q18","v":{"v":0.8600000000000001,"d":"0.86"}},"Nm per unit"]
[]
["Notes:"]
{"$rows_empty":7}
[{"$nulls":11},"Drive torque during constant speed",{"$nulls":3},{"$f":"N135+AM103*BO16/2/1000/O125/PI()","v":0.8759154943091896},"Nm",{"$nulls":4},"Motor torque during costant speed",{"$nulls":3},{"$f":"IF(L253=1,P145/0.99,P145/D111/D112+D113)","v":0.8847631255648379},"Nm",null,"Här är lite frågetecken, eller nej?"]
[{"$nulls":11},"Drive torque during acceleration",{"$nulls":3},{"$f":"N135+AN103*BO16/2/1000/O125/PI()+Q18*BC4*G19/1000*PI()*R112/30/C52*C53","v":0.903432279534568},"Nm (including ball screw inertia)",{"$nulls":4},"Motor torque duringacceleration",{"$nulls":3},{"$f":"AC155+Z145","v":{"v":1.0188915234939973,"d":"1.019"}},"Nm including inertia and losses in gear"]
[]
[]
[{"$nulls":15},{"$f":"P146-P145","v":0.02751678522537837},{"$nulls":15},1]
[{"$nulls":26},"Drive ",null,"motor",null,null,"Guide for selection of fm factor"]
[{"$nulls":11},"Linear inertia from load and carries:",{"$nulls":4},"m x ( m/min / 2π / rpm ) ^2 =",null,null,{"$f":"(C49+AM4*S13*Q18)*(C52*60/2/PI()/R112)^2","v":6.3325739776461111E-7},"kg m²",{"$nulls":5},"shaft",null,"shaft",null,null,"fm = 1,0 ; The same load in both directions"]
[{"$nulls":11},"Inertia ball screw",{"$nulls":7},{"$f":"BC4*G19/1000*Q18","v":{"v":2.18268E-4,"d":"0.000218"}},"kg m²",{"$nulls":3},"Inertia",null,{"$f":"S154","v":2.1890125739776461E-4},"kgm²",{"$f":"IF(L253=1,S154+T156+T158,(S154+T156)/D111^2/D112+T157+T158)","v":1.0679012573977646E-3},"kgm²",null,"fm = 0,89 ; Full load forward, 75% load back"]
[{"$nulls":24},"Top speed",null,{"$f":"R112","v":2400},"rpm",{"$f":"U112","v":2400},"rpm",null,"fm = 0,81 ; Full load forward, 50% load back"]
[{"$nulls":18},{"$f":"SUM(T151:T152)","v":2.1890125739776461E-4},{"$nulls":5},"Acceleration time",null,{"$f":"C52/C53","v":2},"sec",{"$f":"AA154","v":2},"sec",null,"fm = 0,8 ; Full load forward, no load back"]
[{"$nulls":26},{"$f":"AA152*3.14*AA153/30/AA154","v":{"v":0.027493997929159235,"d":"0.027"}},"Nm",{"$f":"AC152*3.14*AC153/30/AC154","v":{"v":0.13412839792915923,"d":"0.134"}},"Nm",null,"fm = 0,48 ; Full load 10% of the stroke forward and 20% rest of cycle"]
[{"$nulls":11},"Inertia coupling",{"$nulls":7},{"$f":"AB129*Q18","v":3.9e-05}]
[{"$nulls":11},"Inertia gear",{"$nulls":7},{"$f":"IF(L253=2,D114,0)","v":0}]
[{"$nulls":11},"Inertia motor",{"$nulls":7},{"$f":"IF(L257=1,0,IF(L257=2,R197,IF(L257=3,V168,IF(L257=4,P225,IF(L257=5,D127,0)))))","v":0.00081}]
[]
[{"$nulls":12},"Total inertia reduced to motor shaft",{"$nulls":5},{"$f":"(S154+T156)/IF(L253=1,1,D111^2)+T157+T158","v":1.0679012573977646E-3}]
[{"$nulls":12},"Inertia balance",{"$nulls":4},{"$f":"S160/T158","v":1.3183966140713144}]
[]
[]
[]
[{"$nulls":11},1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[{"$nulls":12},"AKM servo motor",null,"nom rpm","kW","nom Nm","Nm at max rpm","Peak Nm","Inertia","Brake inertia",null,"Nm/A","mVmin","Ohm"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$169:M192,M$165)","v":"AKM44G"},{"$f":"VLOOKUP($L$265,$L$169:N192,N165)","v":0},{"$f":"VLOOKUP($L$265,$L$169:O192,O165)","v":4000},{"$f":"VLOOKUP($L$265,$L$169:P192,P165)","v":1.57},{"$f":"VLOOKUP($L$265,$L$169:Q192,Q165)","v":5.88},{"$f":"VLOOKUP($L$265,$L$169:R192,R165)","v":3.76},{"$f":"VLOOKUP($L$265,$L$169:S192,S165)","v":20.2},{"$f":"VLOOKUP($L$265,$L$169:T192,T165)","v":2.7E-4},{"$f":"VLOOKUP($L$265,$L$169:U192,U165)","v":6.8e-06},{"$f":"VLOOKUP($L$265,$L$169:V192,V165)","v":0.0002768},{"$f":"VLOOKUP($L$265,$L$169:W192,W165)","v":1.19},{"$f":"VLOOKUP($L$265,$L$169:X192,X165)","v":76.6},{"$f":"VLOOKUP($L$265,$L$169:Y192,Y165)","v":2.65}]
[{"$nulls":11},1,"AKM31C",null,5000,0.52,1.15,1,3.88,3.3e-05,1.2e-06,{"$f":"IF($O$257=2,T169+U169,T169)","v":3.4200000000000005E-5},0.85,54.5,21.4]
[{"$nulls":11},2,"AKM32C",null,3000,0.58,2,1.86,6.92,5.9e-05,1.2e-06,6.02E-5,1.4,89.8,23]
[{"$nulls":11},3,"AKM33E",null,4500,1.1,2.79,2.34,9.96,{"v":8.5e-05,"d":"0.000085"},1.2e-06,8.6200000000000008E-5,1.1,70.6,8.36]
[{"$nulls":11},4,"AKM41C",null,3000,0.56,1.95,1.77,6.12,8.1e-05,6.8e-06,8.78e-05,1.34,86.3,21.7]
[{"$nulls":11},5,"AKM42E",null,3500,1.03,3.42,2.81,11.3,0.00015,6.8e-06,0.0001568,1.26,80.9,7.22]
[{"$nulls":11},6,"AKM43E",null,2500,1.03,4.7,3.92,15.9,0.00021,6.8e-06,0.0002168,1.72,111,8.04]
[{"$nulls":11},7,"AKM44G",null,4000,1.57,5.88,3.76,20.2,2.7E-4,6.8e-06,0.0002768,1.19,76.6,2.65]
[{"$nulls":11},8,"AKM51E",null,2500,1.04,4.7,3.98,11.6,0.00034,1.7E-5,3.57E-4,1.72,110,8.47]
[{"$nulls":11},9,"AKM52G",null,2500,1.85,8.43,7.06,21.5,6.2E-4,1.7E-5,0.000637,1.79,115,3.47]
[{"$nulls":11},10,"AKM53K",null,4000,3.2,11.6,7.65,30.1,9.1E-4,1.7E-5,0.000927,1.24,79.8,1]
[{"$nulls":11},11,"AKM54K",null,3500,3.68,14.4,10.05,38.4,0.0012,1.7E-5,1.217E-3,1.5,96.6,1.02]
[{"$nulls":11},12,"AKM62K",null,3500,3.3,12.2,9,30.1,0.0017,6.1e-05,1.761E-3,1.28,82.1,1.05]
[{"$nulls":11},13,"AKM63K",null,3000,4.05,16.8,12.9,42.6,0.0024,6.1e-05,2.4609999999999996E-3,1.71,110,1.09]
[{"$nulls":11},14,"AKM64L",null,3000,4.9,21,15.6,54.1,0.0032,6.1e-05,3.261E-3,1.66,107,0.71]
[{"$nulls":11},15,"AKM65M",null,2500,5.03,25,19.2,65.2,0.004,6.1e-05,0.004061,1.85,119,0.68]
[{"$nulls":11},16]
[{"$nulls":11},17]
[{"$nulls":11},18]
[{"$nulls":11},19]
[{"$nulls":11},20]
[{"$nulls":11},21]
[{"$nulls":11},22]
[{"$nulls":11},23]
[{"$nulls":11},24]
[]
[]
[]
[{"$nulls":12},"AC motors",null,"rpm","kW","Nm","Kgm2"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$198:M221,M$165)","v":"IEC71 1500 rpm 0,37 kW"},null,{"$f":"VLOOKUP($L$265,$L$198:O221,O$165)","v":1370},{"$f":"VLOOKUP($L$265,$L$198:P221,P$165)","v":0.37},{"$f":"VLOOKUP($L$265,$L$198:Q221,Q$165)","v":2.630597372262774},{"$f":"VLOOKUP($L$265,$L$198:R221,R$165)","v":0.00081}]
[{"$nulls":11},1,"IEC 63  3000 rpm  0,25 kW",null,2750,0.25,{"$f":"71620*1.36*P198/O198/10","v":{"v":0.8854836363636365,"d":"0.9"}},0.00023]
[{"$nulls":11},2,"IEC 63  with brake 3000 rpm  0,25 kW",null,2750,0.25,{"v":0.8854836363636365,"d":"0.9"},0.00025]
[{"$nulls":11},3,"IEC 63  1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},0.00025]
[{"$nulls":11},4,"IEC 63  with brake 1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},3.5E-4]
[{"$nulls":11},5,"IEC71 3000 rpm 0,55 kW",null,2760,0.55,{"v":1.9410057971014496,"d":"1.9"},0.00042]
[{"$nulls":11},6,"IEC71 with brake 3000 rpm 0,55 kW",null,2760,0.55,1.9,0.00049]
[{"$nulls":11},7,"IEC71 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00081]
[{"$nulls":11},8,"IEC71 with brake 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00094]
[{"$nulls":11},9,"IEC80 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},0.00098]
[{"$nulls":11},10,"IEC80 with brake 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},{"$f":"0.000061+R206","v":1.041E-3}]
[{"$nulls":11},11,"IEC80 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},1.874E-3]
[{"$nulls":11},12,"IEC80 with brake 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},{"$f":"0.000061+R208","v":0.001935}]
[{"$nulls":11},13,"IEC90 3000 rpm 2,2 kW",null,2860,2.2,7.3,0.00161]
[{"$nulls":11},14,"IEC90 with brake 3000 rpm 2,2 kW",null,2850,2.2,{"v":7.518843508771932,"d":"7.5"},{"$f":"0.0002+R210","v":{"v":1.8100000000000002E-3,"d":"0.00181"}}]
[{"$nulls":11},15,"IEC90 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":2.8E-3,"d":"0.00280"}]
[{"$nulls":11},16,"IEC90 with brake 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":0.0041,"d":"0.00410"}]
[{"$nulls":11},17,"IEC100 3000 rpm 3 kW",null,2850,3,9.9,0.0032]
[{"$nulls":11},18,"IEC100 with brake 3000 rpm 3 kW",null,2850,3,9.9,0.00427]
[{"$nulls":11},19,"IEC100 1500 rpm 3 kW",null,1430,3,20,0.006]
[{"$nulls":11},20,"IEC100 with brake 1500 rpm 3 kW",null,1430,3,20,0.0101]
[{"$nulls":11},21,"IEC112 3000 rpm 4 kW",null,2890,4,13.2,0.00499]
[{"$nulls":11},22,"IEC112 with brake 3000 rpm 4 kW",null,2890,4,13.2,0.0083]
[{"$nulls":11},23,"IEC112 1500 rpm 4 kW",null,1420,4,26.6,0.01114]
[{"$nulls":11},24,"IEC112 with brake 1500 rpm 4 kW",null,1420,4,26.6,0.02]
[]
[]
[{"$nulls":14},"Hold torque","Inertia"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$226:M249,M$165)","v":"-"},{"$f":"VLOOKUP($L$265,$L$226:N249,N$165)","v":0},{"$f":"VLOOKUP($L$265,$L$226:O249,O$165)","v":"-"},{"$f":"VLOOKUP($L$265,$L$226:P249,P$165)","v":"-"}]
[{"$nulls":11},1,"KML061",null,1.2,2.4e-05]
[{"$nulls":11},2,"KML062",null,1.77,{"v":3.95e-05,"d":"0.000040"}]
[{"$nulls":11},3,"KML063",null,2.47,{"v":5.93e-05,"d":"0.000059"}]
[{"$nulls":11},4,"KML091",null,2.72,{"v":1.13E-4,"d":"0.000113"}]
[{"$nulls":11},5,"KML092",null,5.44,0.000219]
[{"$nulls":11},6,"KML093",null,8.16,0.000332]
[{"$nulls":11},7,"-",null,"-","-"]
[{"$nulls":11},8,"-",null,"-","-"]
[{"$nulls":11},9,"-",null,"-","-"]
[{"$nulls":11},10,"-",null,"-","-"]
[{"$nulls":11},11,"-",null,"-","-"]
[{"$nulls":11},12,"-",null,"-","-"]
[{"$nulls":11},13,"-",null,"-","-"]
[{"$nulls":11},14,"-",null,"-","-"]
[{"$nulls":11},15,"-",null,"-","-"]
[{"$nulls":11},16,"-",null,"-","-"]
[{"$nulls":11},17,"-",null,"-","-"]
[{"$nulls":11},18,"-",null,"-","-"]
[{"$nulls":11},19,"-",null,"-","-"]
[{"$nulls":11},20,"-",null,"-","-"]
[{"$nulls":11},21,"-",null,"-","-"]
[{"$nulls":11},22,"-",null,"-","-"]
[{"$nulls":11},23,"-",null,"-","-"]
[{"$nulls":11},24,"-",null,"-","-"]
[]
[]
[]
[{"$nulls":11},1]
[{"$nulls":11},1,"Direct / coupling"]
[{"$nulls":11},2,"Gear"]
[]
[{"$nulls":11},2,null,null,2]
[{"$nulls":11},1,"No motor",null,1,{"$f":"IF($L$257=3,\"Without brake\",\" \")","v":" "}]
[{"$nulls":11},2,"AC motor",null,2,{"$f":"IF($L$257=3,\"With brake\",\" \")","v":" "}]
[{"$nulls":11},3,"AKM servo motor"]
[{"$nulls":11},4,"Stepper motor"]
[{"$nulls":11},5,"Customer motor"]
[]
[]
[{"$nulls":11},7]
[{"$nulls":11},1,{"$f":"IF($L$257=1,\"-\",IF($L$257=2,M198,IF($L$257=3,M169,IF($L$257=4,M226,\" - \"))))","v":"IEC 63  3000 rpm  0,25 kW"}]
[{"$nulls":11},2,"IEC 63  with brake 3000 rpm  0,25 kW"]
[{"$nulls":11},3,"IEC 63  1500 rpm  0,18 kW"]
[{"$nulls":11},4,"IEC 63  with brake 1500 rpm  0,18 kW"]
[{"$nulls":11},5,"IEC71 3000 rpm 0,55 kW"]
[{"$nulls":11},6,"IEC71 with brake 3000 rpm 0,55 kW"]
[{"$nulls":11},7,"IEC71 1500 rpm 0,37 kW"]
[{"$nulls":11},8,"IEC71 with brake 1500 rpm 0,37 kW"]
[{"$nulls":11},9,"IEC80 3000 rpm 1,1 kW"]
[{"$nulls":11},10,"IEC80 with brake 3000 rpm 1,1 kW"]
[{"$nulls":11},11,"IEC80 1500 rpm 0,75 kW"]
[{"$nulls":11},12,"IEC80 with brake 1500 rpm 0,75 kW"]
[{"$nulls":11},13,"IEC90 3000 rpm 2,2 kW"]
[{"$nulls":11},14,"IEC90 with brake 3000 rpm 2,2 kW"]
[{"$nulls":11},15,"IEC90 1500 rpm 1,5 kW"]
[{"$nulls":11},16,"IEC90 with brake 1500 rpm 1,5 kW"]
[{"$nulls":11},17,"IEC100 3000 rpm 3 kW"]
[{"$nulls":11},18,"IEC100 with brake 3000 rpm 3 kW"]
[{"$nulls":11},19,"IEC100 1500 rpm 3 kW"]
[{"$nulls":11},20,"IEC100 with brake 1500 rpm 3 kW"]
[{"$nulls":11},21,"IEC112 3000 rpm 4 kW"]
[{"$nulls":11},22,"IEC112 with brake 3000 rpm 4 kW"]
[{"$nulls":11},23,"IEC112 1500 rpm 4 kW"]
[{"$nulls":11},24,"IEC112 with brake 1500 rpm 4 kW"]

{"sheet":"Blad2","index":2,"n_rows":50,"n_cols":14,"rows_kept":50,"hidden":true}
[]
[null,"Customized profile",null,"Screw driven"]
[]
["Acceleration",null,{"$f":"'Calculation SCREW'!C53","v":0.1},"m/s2",{"$nulls":4},{"$f":"IF((J8+J10)>H6,1,0)","v":0}]
["Deceleration",null,{"$f":"C4","v":0.1},"m/s2",{"$nulls":4},{"$f":"IF(I4=1,J5,C7)","v":0.2},{"$f":"I9*C4","v":0.447213595499958}]
["Distance (stroke)",null,{"$f":"'Calculation SCREW'!C55","v":2000},"mm",{"$nulls":3},{"$f":"C6/1000","v":2}]
["Speed",null,{"$f":"'Calculation SCREW'!C52","v":0.2},"m/s"]
["Distance for acc.",null,{"$f":"1000*H8","v":200},"mm",{"$nulls":3},{"$f":"IF(I4=0,J8,I8)","v":{"v":0.2,"d":"0.200"}},{"$f":"H6*C5/(C5+C4)","v":1},{"$f":"C4*J9*J9/2","v":0.2}]
["Time for acc.",null,{"$f":"IF(I4=0,J9,I9)","v":{"v":2,"d":"2.000"}},"s",{"$nulls":4},{"$f":"SQRT(2*I8/C4)","v":4.47213595499958},{"$f":"C7/C4","v":2}]
["Distance for decel.",null,{"$f":"H10*1000","v":200},"mm",{"$nulls":3},{"$f":"IF(I4=0,J10,I10)","v":{"v":0.2,"d":"0.200"}},{"$f":"H6*C4/(C5+C4)","v":1},{"$f":"C5*J11*J11/2","v":0.2}]
["Time for decel.",null,{"$f":"IF(I4=0,J11,I11)","v":{"v":2,"d":"2.000"}},"s",{"$nulls":4},{"$f":"SQRT(2*I10/C5)","v":4.47213595499958},{"$f":"C7/C5","v":2},0,{"$f":"H8*1000","v":{"v":200,"d":"200.000"}},{"$f":"L11+H12*1000","v":{"v":1800,"d":"1800.000"}},{"$f":"H6*1000","v":2000}]
["Dist. at const speed",null,{"$f":"H12*1000","v":1600},"mm",{"$nulls":3},{"$f":"H6-H8-H10","v":{"v":1.6,"d":"1.600"}},null,{"$f":"IF((H8+H10)>H6,\"Du når ej önskad max hastighet\",\" \")","v":" "},0,{"$f":"I5","v":0.2},{"$f":"L12","v":0.2},0]
["Time at const speed",null,{"$f":"H12/C7","v":{"v":8,"d":"8.000"}},"s"]
["Cycle time",null,{"$f":"IF(I4=0,J14,I14)","v":{"v":12,"d":"12.000"}},"s",{"$nulls":4},{"$f":"I9+I11","v":8.94427190999916},{"$f":"C11+C9+C13","v":{"v":12,"d":"12.000"}}]
["Average speed",null,{"$f":"H6/C14","v":{"v":0.16666666666666666,"d":"0.167"}},"m/s"]
[]
[{"$f":"IF(I4=1,\"You will not reach full speed\",\" \")","v":" "}]
[{"$f":"IF(I4=1,\"You will reach just\",\" \")","v":" "},null,{"$f":"IF(I4=1,I9*C4,\" \")","v":" "},{"$f":"IF(I4=1,\"m/s\",\" \")","v":" "}]
[]
[null,"Customized profile",null,"Belt driven"]
[]
["Acceleration",null,{"$f":"'Calculation BELT'!C53","v":2},"m/s2",{"$nulls":4},{"$f":"IF((J26+J28)>H24,1,0)","v":0}]
["Deceleration",null,{"$f":"C22","v":2},"m/s2",{"$nulls":4},{"$f":"IF(I22=1,J23,C25)","v":1.5},{"$f":"I27*C22","v":1.8973665961010275}]
["Distance (stroke)",null,{"$f":"'Calculation BELT'!C55","v":1800},"mm",{"$nulls":3},{"$f":"C24/1000","v":1.8}]
["Speed",null,{"$f":"'Calculation BELT'!C52","v":1.5},"m/s"]
["Distance for acc.",null,{"$f":"1000*H26","v":{"v":562.5,"d":"563"}},"mm",{"$nulls":3},{"$f":"IF(I22=0,J26,I26)","v":{"v":0.5625,"d":"0.563"}},{"$f":"H24*C23/(C23+C22)","v":0.9},{"$f":"C22*J27*J27/2","v":0.5625}]
["Time for acc.",null,{"$f":"IF(I22=0,J27,I27)","v":{"v":0.75,"d":"0.750"}},"s",{"$nulls":4},{"$f":"SQRT(2*I26/C22)","v":0.9486832980505138},{"$f":"C25/C22","v":0.75}]
["Distance for decel.",null,{"$f":"H28*1000","v":{"v":562.5,"d":"563"}},"mm",{"$nulls":3},{"$f":"IF(I22=0,J28,I28)","v":{"v":0.5625,"d":"0.563"}},{"$f":"H24*C22/(C23+C22)","v":0.9},{"$f":"C23*J29*J29/2","v":0.5625}]
["Time for decel.",null,{"$f":"IF(I22=0,J29,I29)","v":{"v":0.75,"d":"0.750"}},"s",{"$nulls":4},{"$f":"SQRT(2*I28/C23)","v":0.9486832980505138},{"$f":"C25/C23","v":0.75},0,{"$f":"H26*1000","v":{"v":562.5,"d":"562.500"}},{"$f":"L29+H30*1000","v":{"v":1237.5,"d":"1237.500"}},{"$f":"H24*1000","v":1800}]
["Dist. at const speed",null,{"$f":"H30*1000","v":675},"mm",{"$nulls":3},{"$f":"H24-H26-H28","v":0.675},null,{"$f":"IF((H26+H28)>H24,\"Du når ej önskad max hastighet\",\" \")","v":" "},0,{"$f":"I23","v":1.5},{"$f":"L30","v":1.5},0]
["Time at const speed",null,{"$f":"H30/C25","v":{"v":0.45,"d":"0.450"}},"s"]
["Cycle time",null,{"$f":"IF(I22=0,J32,I32)","v":{"v":1.95,"d":"1.950"}},"s",{"$nulls":4},{"$f":"I27+I29","v":1.8973665961010275},{"$f":"C29+C27+C31","v":{"v":1.95,"d":"1.950"}}]
["Average speed",null,{"$f":"H24/C32","v":{"v":0.9230769230769231,"d":"0.923"}},"m/s"]
[]
[{"$f":"IF(I22=1,\"You will not reach full speed\",\" \")","v":" "}]
[{"$f":"IF(I22=1,\"You will reach just\",\" \")","v":" "},null,{"$f":"IF(I22=1,I27*C22,\" \")","v":" "},{"$f":"IF(I22=1,\"m/s\",\" \")","v":" "}]
[null,"Customized profile",null,"screw drive, un-guided  WV"]
[]
["Acceleration",null,{"$f":"'Calculation WV'!C53","v":1.2},"m/s2",{"$nulls":4},{"$f":"IF((J43+J45)>H41,1,0)","v":0}]
["Deceleration",null,{"$f":"C39","v":1.2},"m/s2",{"$nulls":4},{"$f":"IF(I39=1,J40,C42)","v":0.6},{"$f":"I44*C39","v":1.6248076809271923}]
["Distance (stroke)",null,{"$f":"'Calculation WV'!C55","v":2200},"mm",{"$nulls":3},{"$f":"C41/1000","v":2.2}]
["Speed",null,{"$f":"'Calculation WV'!C52","v":0.6},"m/s"]
["Distance for acc.",null,{"$f":"1000*H43","v":150},"mm",{"$nulls":3},{"$f":"IF(I39=0,J43,I43)","v":{"v":0.15,"d":"0.150"}},{"$f":"H41*C40/(C40+C39)","v":1.1},{"$f":"C39*J44*J44/2","v":0.15}]
["Time for acc.",null,{"$f":"IF(I39=0,J44,I44)","v":{"v":0.5,"d":"0.500"}},"s",{"$nulls":4},{"$f":"SQRT(2*I43/C39)","v":1.3540064007726602},{"$f":"C42/C39","v":0.5}]
["Distance for decel.",null,{"$f":"H45*1000","v":150},"mm",{"$nulls":3},{"$f":"IF(I39=0,J45,I45)","v":{"v":0.15,"d":"0.150"}},{"$f":"H41*C39/(C40+C39)","v":1.1},{"$f":"C40*J46*J46/2","v":0.15}]
["Time for decel.",null,{"$f":"IF(I39=0,J46,I46)","v":{"v":0.5,"d":"0.500"}},"s",{"$nulls":4},{"$f":"SQRT(2*I45/C40)","v":1.3540064007726602},{"$f":"C42/C40","v":0.5},0,{"$f":"H43*1000","v":{"v":150,"d":"150.000"}},{"$f":"L46+H47*1000","v":{"v":2050.0000000000005,"d":"2050.000"}},{"$f":"H41*1000","v":2200}]
["Dist. at const speed",null,{"$f":"H47*1000","v":{"v":1900.0000000000005,"d":"1900"}},"mm",{"$nulls":3},{"$f":"H41-H43-H45","v":{"v":1.9000000000000004,"d":"1.900"}},null,{"$f":"IF((H43+H45)>H41,\"Du når ej önskad max hastighet\",\" \")","v":" "},0,{"$f":"I40","v":0.6},{"$f":"L47","v":0.6},0]
["Time at const speed",null,{"$f":"H47/C42","v":{"v":3.1666666666666674,"d":"3.167"}},"s"]
["Cycle time",null,{"$f":"IF(I39=0,J49,I49)","v":{"v":4.166666666666668,"d":"4.167"}},"s",{"$nulls":4},{"$f":"I44+I46","v":2.7080128015453204},{"$f":"C46+C44+C48","v":{"v":4.166666666666668,"d":"4.167"}}]
["Average speed",null,{"$f":"H41/C49","v":{"v":0.5279999999999999,"d":"0.528"}},"m/s"]

{"sheet":"Calculation WV","index":3,"n_rows":289,"n_cols":67,"rows_kept":289,"merged":[[2,1,2,3],[3,1,3,3],[4,1,4,3],[4,5,4,6],[23,30,23,31],[37,30,37,31],[51,30,51,31],[64,30,64,31],[74,38,76,38],[74,39,76,39],[76,23,76,24],[76,25,76,26],[76,27,76,28],[76,29,76,30],[76,31,76,32],[76,33,76,34],[101,20,101,21],[101,22,101,23]]}
["Linear unit WV",null,null,"Sizing & selection",{"$nulls":4},"2015 03 23 JHj       Release 0"]
["WV60  WV80  WV120",{"$nulls":22},"max stroke",null,"add length C",null,"Fx max","Fy","Fz","Mx","My","Mz","Frd","Mta","Speed","Acc",null,"Carriage weight","Weight",{"$nulls":8},"Cx dyn   ball screw","preload ball screw","preload ball bearing",null,"Cr dyn ball bearing","Ball screw diameter","Inertia kgm² / m",{"$nulls":8},"#"]
["Customer",{"$nulls":38},"0 stroke","100 mm",null,"Lx","Ly"]
["Project",{"$nulls":15},1,{"$f":"VLOOKUP($Q$4,$Q$5:R9,R10)","v":"WV60"},{"$f":"VLOOKUP($Q$4,$Q$5:S9,S10)","v":"Ball screw Ø20 with double ball nuts"},{"$f":"VLOOKUP($Q$4,$Q$5:T9,T10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:U9,U10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:V9,V10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:W9,W10)","v":0.01},{"$f":"VLOOKUP($Q$4,$Q$5:X9,X10)","v":11000},{"$f":"VLOOKUP($Q$4,$Q$5:Y9,Y10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:Z9,Z10)","v":570},{"$f":"VLOOKUP($Q$4,$Q$5:AA9,AA10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AB9,AB10)","v":4000},{"$f":"VLOOKUP($Q$4,$Q$5:AC9,AC10)*S13","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AD9,AD10)*S13","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AE9,AE10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AF9,AF10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AG9,AG10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AH9,AH10)","v":500},{"$f":"VLOOKUP($Q$4,$Q$5:AI9,AI10)","v":35},{"$f":"VLOOKUP($Q$4,$Q$5:AJ9,AJ10)","v":2.5},{"$f":"VLOOKUP($Q$4,$Q$5:AK9,AK10)","v":20},{"$f":"VLOOKUP($Q$4,$Q$5:AL9,AL10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AM9,AM10)","v":1.42},{"$f":"VLOOKUP($Q$4,$Q$5:AN9,AN10)","v":4.72},{"$f":"VLOOKUP($Q$4,$Q$5:AO9,AO10)","v":0.55},{"$f":"VLOOKUP($Q$4,$Q$5:AP9,AP10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AQ9,AQ10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AR9,AR10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AS9,AS10)","v":"WV06D"},{"$f":"VLOOKUP($Q$4,$Q$5:AT9,AT10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AU9,AU10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:AV9,AV10)","v":0},{"$f":"BO21","v":11600},{"$f":"VLOOKUP($Q$4,$Q$5:AX9,AX10)","v":400},{"$f":"VLOOKUP($Q$4,$Q$5:AY9,AY10)","v":500},{"$f":"VLOOKUP($Q$4,$Q$5:AZ9,AZ10)","v":"7205 BEP"},{"$f":"VLOOKUP($Q$4,$Q$5:BA9,BA10)","v":20200},{"$f":"VLOOKUP($Q$4,$Q$5:BB9,BB10)","v":20},{"$f":"VLOOKUP($Q$4,$Q$5:BC9,BC10)","v":8.460000000000001E-5},{"$f":"VLOOKUP($Q$4,$Q$5:BD9,BD10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BE9,BE10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BF9,BF10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BG9,BG10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BH9,BH10)","v":0},{"$f":"VLOOKUP($Q$4,$Q$5:BI9,BI10)","v":0}]
["Date",{"$nulls":3},"Ref:","xxx",{"$nulls":10},1,"WV60","Ball screw Ø20 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=50,5000,11000)","v":{"v":11000,"d":"11,000"}},null,{"$f":"AR17","v":570},null,4000,0,0,0,0,0,500,35,2.5,20,null,1.42,4.72,0.55,{"$nulls":3},"WV06D",{"$nulls":4},400,500,"7205 BEP",20200,20,{"$f":"8.46*10^-5","v":8.460000000000001E-5}]
[{"$nulls":16},2,"WV80","Ball screw Ø25 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=50,5000,11000)","v":{"v":11000,"d":"11,000"}},null,{"$f":"AX17","v":505},null,5000,0,0,0,0,0,700,55,2.5,20,null,2.25,7.95,0.99,{"$nulls":3},"WV08D",{"$nulls":4},500,700,"7206 BEP",21700,25,{"$f":"2.25*10^-4","v":2.2500000000000002E-4}]
["Linear drive unit:",{"$nulls":15},3,"WV120","Ball screw Ø32 with double ball nuts",{"$nulls":3},0.01,{"$f":"IF($BO$16=40,5000,11000)","v":{"v":11000,"d":"11,000"}},null,{"$f":"BD17","v":640},null,{"$f":"IF(BO16=40,8000,12000)","v":12000},0,0,0,0,0,1000,80,2,20,null,4.75,18.1,1.94,{"$nulls":3},"WV12D",{"$nulls":4},1200,1500,"7207 BEP",34500,32,{"$f":"6.34*10^-4","v":0.000634}]
[null,"Size",{"$nulls":14},4]
[{"$nulls":16},5]
[null,"Guidings","  un-guided",{"$nulls":13},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]
[null,"Drive mechanism",{"$f":"S4","v":"Ball screw Ø20 with double ball nuts"}]
[null,"Ball screw lead mm",{"$nulls":16},"Carriages/unit",{"$nulls":10},1,{"$f":"VLOOKUP(AD12,AC13:AE17,3)","v":0.5}]
[{"$nulls":16},1,null,{"$f":"IF(Q13=3,2,1)","v":1},null,{"$f":"VLOOKUP(Q13,Q14:U16,5)","v":0},{"$f":"VLOOKUP(Q13,Q14:V16,6)","v":1.42},{"$f":"VLOOKUP(Q13,Q14:W16,7)","v":"N"},2,{"$f":"IF(X13=1,1,0)","v":0},{"$nulls":3},1,{"$f":"IF($Q$18=2,\"50 / 50\",\" \")","v":" "},0.5]
[null,"Move per rev",{"$f":"BO16","v":20},"mm",{"$nulls":12},1,"N = Single standard carriage",null,null,{"$f":"AQ4","v":0},{"$f":"AM4","v":1.42},"N",1,"Yes",{"$nulls":3},2,{"$f":"IF($Q$18=2,\"45 / 55\",\" \")","v":" "},0.55]
[null,"Repeatability",{"$f":"W4","v":0.01},"mm",{"$nulls":12},2,{"$nulls":3},{"$f":"Y4","v":0},{"$f":"IF(Q4=1,1.47,IF(Q4=2,3.43,8.67))","v":1.47},"N",2,"No",{"$nulls":3},3,{"$f":"IF($Q$18=2,\"40 / 60\",\" \")","v":" "},0.6,{"$nulls":16},"Calculation of total length  L tot = stroke + C",{"$nulls":14},"Screw lead"]
[{"$nulls":16},3,{"$nulls":3},{"$f":"G18","v":0},{"$f":"2*AM4","v":2.84},"N",{"$nulls":5},4,{"$f":"IF($Q$18=2,\"30 / 70\",\" \")","v":" "},0.7,{"$nulls":12},"WV60",{"$nulls":5},"WV80",{"$nulls":5},"WV120",{"$nulls":3},{"$f":"Q4","v":1},"WV60",null,"WV80",null,"WV120",2,{"$f":"VLOOKUP(BN16,BN17:BO20,2)","v":20}]
[{"$nulls":5},{"$f":"IF(AND(OR(Q4=2,Q4=4),Q13=2),\"Long carriage not available\",\" \")","v":" "},{"$nulls":20},"Configuration",null,5,{"$f":"IF($Q$18=2,\"20 / 80\",\" \")","v":" "},0.8,{"$nulls":11},"C =",{"$f":"VLOOKUP(C19,AQ18:AR34,2)","v":570},{"$nulls":4},"C =",{"$f":"VLOOKUP(C19,AW18:AX32,2)","v":505},{"$nulls":4},"C =",{"$f":"VLOOKUP(C19,BC18:BD31,2)","v":640},{"$nulls":4},5,null,5,null,5,1,5]
[{"$nulls":4},{"$f":"IF(K22=2,\"Not available\",\" \")","v":" "},{"$nulls":11},1,"units",{"$f":"Q18-1","v":0},1,null,null,1,{"$nulls":3},{"$f":"IF(AND(Q18=1,T18=1),1,IF(AND(Q18=2,T18=1),2,IF(AND(Q18=1,T18=2),3,IF(AND(Q18=2,T18=2),4,\"\"))))","v":1},{"$nulls":15},0,430,{"$nulls":4},0,395,{"$nulls":4},0,465,{"$nulls":4},20,null,10,null,10,2,{"$f":"IF(BH16=1,20,10)","v":20}]
[null,"Stroke",2200,"mm",null,"Total length",{"$f":"C19+Z4","v":2770},"mm",{"$nulls":8},"one single unit",null,null,1,"Horizontal",null,1,{"$f":"IF(T18=1,\"Top or downward\",\" \")","v":"Top or downward"},null,null,{"$f":"R78","v":"Horizontal mounting, single unit"},{"$nulls":15},691,480,{"$nulls":4},776,460,{"$nulls":4},941,570,{"$nulls":4},50,null,20,null,20,3,{"$f":"IF(BH16>1,20,50)","v":50}]
[null,null,{"$f":"IF(C19>X4,\"Longer than standard. Check with plant\",\" \")","v":" "},{"$nulls":13},"two units in parallel",null,null,2,"Vertical",null,2,{"$f":"IF(T18=1,\"Sideway\",\" \")","v":"Sideway"},{"$nulls":18},1416,520,{"$nulls":4},1671,505,{"$nulls":4},1861,640,{"$nulls":6},50,null,40,4,{"$f":"IF(BH16=1,\" - \",IF(BH16=3,40,50))","v":" - "}]
[null,null,"Number of units",{"$nulls":39},2156,570,{"$nulls":4},2506,550,{"$nulls":4},2791,710,{"$nulls":4},"Dynamic rating of ball screw  Cx",{"$nulls":4},{"$f":"BN16","v":2},{"$f":"VLOOKUP(BN21,BN22:BO25,2)","v":11600}]
[{"$f":"IF(Q18=2,\"Distance between  linear units\",\" \")","v":" "},null,null,800,{"$nulls":19},"Friction factor =",0.1,{"$nulls":17},2886,610,{"$nulls":4},3341,590,{"$nulls":4},3721,780,{"$nulls":4},10500,null,12300,null,21500,1,{"$f":"IF($BH$16=1,BI22,IF($BH$16=3,BM22,BK22))","v":10500}]
[{"$nulls":16},"Horizontal mounting, single unit",{"$nulls":16},"Fx per unit  ","Total Fx at",{"$nulls":7},3626,660,{"$nulls":4},4176,635,{"$nulls":4},4651,845,{"$nulls":4},11600,null,13200,null,33400,2,{"$f":"IF($BH$16=1,BI23,IF($BH$16=3,BM23,BK23))","v":11600}]
[null,null,"Weight of linear drive unit/-s",{"$f":"Q18*(AN4+G19/100*AO4+IF(Q13=2,AL4,IF(Q13=3,1.5*AM4,AM4)))","v":{"v":21.375,"d":"21.4"}},"kg",null,{"$f":"IF(M33=0,\" \",IF(C27/2000>#REF!,\"OK\",\"Too much\"))","v":" "},{"$nulls":20},"Max",{"$nulls":5},"during acc  ","  const. speed",{"$nulls":7},4356,700,{"$nulls":4},5016,680,{"$nulls":4},5586,910,{"$nulls":4},8400,null,13000,null,29700,3,8400]
[{"$nulls":5},{"$f":"IF(M33=0,\" \",\"Deflection\")","v":" "},{"$nulls":18},"Totally",null,null,"allowed",{"$nulls":14},5096,740,{"$nulls":4},5851,725,{"$nulls":4},6521,980,{"$nulls":6},15400,null,14900,4,0]
[null,"Mounting direction",{"$nulls":22},"Fx =",{"$f":"C42+(C49+AM4)*C53+C49*E50*10","v":{"v":1.704,"d":"2"}},"N",{"$f":"AB4","v":4000},{"$nulls":5},{"$f":"Z26","v":{"v":1.704,"d":"2"}},{"$f":"C42+C49*E50*10","v":0},{"$nulls":7},5836,790,{"$nulls":4},6686,770,{"$nulls":4},7451,1050]
[{"$nulls":24},"Fy =",{"$f":"C43","v":0},"N",{"$f":"AC4","v":0},{"$nulls":14},6566,830,{"$nulls":4},7521,815,{"$nulls":4},8381,1125,{"$nulls":3},"Ball nut",{"$f":"CONCATENATE(BB4,IF(BO16<10,0,\"\"),BO16,\"-D\")","v":"2020-D"}]
[{"$nulls":24},"Fz =",{"$f":"C44+C49*10*Y13","v":0},"N",{"$f":"AD4","v":0},{"$nulls":14},7336,880,{"$nulls":4},8381,855,{"$nulls":4},9376,1190]
[{"$nulls":24},"Mx =",{"$f":"T26","v":0},"Nm",{"$f":"AE4","v":0},{"$nulls":14},8086,920,{"$nulls":4},9246,895,{"$nulls":4},10301,1260,{"$nulls":4},"Idle torque at",150,1500,3000,"rpm"]
[{"$nulls":24},"My =",{"$f":"T27","v":0},"Nm",{"$f":"AF4","v":0},{"$nulls":14},8846,960,{"$nulls":4},10111,945,{"$nulls":4},11001,"##",{"$nulls":5},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,2)","v":0.9},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,3)","v":1.5},{"$f":"VLOOKUP($BI$27,$BI$31:$BL$48,4)","v":1.9},"Nm"]
[{"$nulls":24},"Mz =",{"$f":"T28","v":0},"Nm",{"$f":"AG4","v":0},{"$nulls":14},9606,1010,{"$nulls":4},11001,"##",{"$nulls":4},15000,{"$nulls":5},"2005-D",0.7,1.3,1.7]
[{"$nulls":6},{"$f":"IF(Q18=2,\"How is the load shared?\",\" \")","v":" "},{"$nulls":35},10356,1050,{"$nulls":4},15000,{"$nulls":11},"2020-D",0.9,1.5,1.9]
[{"$nulls":42},11001,"##",{"$nulls":16},"2050-D",1.1,1.5,2.1]
[{"$nulls":8},{"$f":"IF(AND(Q18=2,AD12=1),\"equally\",\" \")","v":" "},{"$nulls":11},"Totally",{"$f":"SUM(V26:V33)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W26:W33)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":18},15000,{"$nulls":17},"2505-D",0.9,1.6,2]
[{"$nulls":60},"2510-D",1.1,1.9,2.4]
[{"$nulls":60},"2520-D",1.3,2.1,2.6]
[{"$nulls":16},"Horizontal mounting, 2 units",{"$nulls":43},"2550-D",1.4,2.3,3]
[{"$nulls":27},"Max",{"$nulls":32},"3205-D",1,2.1,2.4]
[{"$nulls":24},"Totally",null,null,"allowed","% of max",{"$nulls":31},"3210-D",1.1,2.2,2.6]
[{"$nulls":24},"Fx =",{"$f":"C42+(C49+2*AM4)*C53+C49*E50*10","v":{"v":3.408,"d":"3"}},"N",{"$f":"2*AB4","v":8000},{"$nulls":5},{"$f":"Z40*AE12","v":{"v":1.704,"d":"2"}},{"$f":"C42+C49*E50*10","v":0},{"$nulls":25},"3220-D",1.4,2.5,3]
[{"$nulls":24},"Fy =",{"$f":"C43","v":0},"N",{"$f":"AC4*1","v":0},{"$nulls":32},"3240-D",1.5,2.8,3.5]
[null,"Fx =",0,"N",{"$f":"IF(C42>AB4*Q18,\"Too much\",\" \")","v":" "},{"$nulls":19},"Fz =",{"$f":"C44+C49*10*Y13+C45/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":0}]
[null,"Fy =",0,"N",{"$nulls":20},"Mx =",{"$f":"T40","v":0},"Nm"]
[null,"Fz =",0,"N",{"$nulls":20},"My =",{"$f":"T41","v":0},"Nm",{"$f":"AF4*2","v":0}]
[null,"Mx =",0,"Nm",{"$nulls":20},"Mz =",{"$f":"T42","v":0},"Nm"]
[null,"My =",0,"Nm"]
[null,"Mz =",0,"Nm"]
[{"$nulls":12},"ABS",{"$nulls":7},"Totally",{"$f":"SUM(V40:V47)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W40:W47)","v":{"v":0,"d":"0.0"}},"N"]
[null,"Total mass to move",0,"kg         ",{"$nulls":8},{"$f":"ABS(I49)","v":0}]
[{"$f":"IF(T18=1,\"Coefficient of friction for external guides\",\" \")","v":"Coefficient of friction for external guides"},{"$nulls":3},0.01,{"$nulls":7},{"$f":"ABS(I50)","v":0}]
[{"$nulls":12},0,{"$nulls":3},"Vertical mounting, single unit"]
[null,"Speed",0.6,"m/s",{"$f":"IF(C52>AJ4,\"Too high speed\",\" \")","v":" "},null,{"$f":"IF(R87>3001,\"Too high rpm\",\" \")","v":" "},{"$nulls":20},"Max"]
[null,"Acceleration",1.2,"m/s²",{"$f":"IF(C53>40,\"Too high acceleration\",\" \")","v":" "},{"$nulls":19},"Totally",null,null,"allowed"]
[{"$nulls":24},"Fx =",{"$f":"C42+(C49+AM4)*C53+C49*10+AM4*10","v":{"v":15.904,"d":"16"}},"N",{"$f":"AB4","v":4000},{"$nulls":5},{"$f":"Z54","v":{"v":15.904,"d":"16"}},{"$f":"C42+C49*10+AM4*10","v":{"v":14.2,"d":"14"}}]
["Move profile over",null,2200,"mm stroke",null,{"$f":"IF(C55>C19,\"This is longer than stroke of unit !\",\" \")","v":" "},{"$nulls":18},"Fy =",{"$f":"C43","v":0},"N",{"$f":"AC4","v":0}]
[{"$nulls":24},"Fz =",{"$f":"C44","v":0},"N",{"$f":"AD4","v":0}]
["Time to move one direction",{"$nulls":23},"Mx =",{"$f":"T54","v":0},"Nm",{"$f":"AE4","v":0}]
[null,null,{"$f":"Blad2!C49","v":{"v":4.166666666666668,"d":"4.17"}},"sec",{"$nulls":20},"My =",{"$f":"T55","v":0},"Nm",{"$f":"AF4","v":0}]
[{"$nulls":24},"Mz =",{"$f":"T56","v":0},"Nm",{"$f":"AG4","v":0}]
[{"$f":"Blad2!A17","v":" "}]
[{"$f":"Blad2!A18","v":" "},null,{"$f":"Blad2!C18","v":" "},{"$f":"Blad2!D18","v":" "},{"$nulls":23},"Totally"]
[{"$nulls":20},"Totally",{"$f":"SUM(V54:V61)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W54:W61)","v":{"v":0,"d":"0.0"}},"N"]
[]
[{"$nulls":16},"Vertical  mounting, two units"]
[{"$nulls":27},"Max"]
[{"$nulls":24},"Totally",null,null,"allowed"]
[{"$nulls":24},"Fx =",{"$f":"C42+C49*10+2*AM4*10+(C49+2*AM4)*C53","v":{"v":31.808,"d":"32"}},"N",{"$f":"AB4*2","v":8000},{"$nulls":5},{"$f":"Z67*AE12","v":{"v":15.904,"d":"16"}},{"$f":"C42+C49*10+2*AM4*10","v":{"v":28.4,"d":"28"}}]
[{"$nulls":24},"Fy =",{"$f":"C43","v":0},"N",{"$f":"AC4","v":0}]
[{"$nulls":24},"Fz =",{"$f":"C44+C45/D22*1000*2","v":0},"N",{"$f":"AD4*2","v":0}]
[{"$nulls":24},"Mx =",0,"Nm"]
[{"$f":"R78","v":"Horizontal mounting, single unit"},{"$nulls":23},"My =",{"$f":"T68","v":0},"Nm",{"$f":"AF4*2","v":0}]
[{"$nulls":24},"Mz =",{"$f":"T69","v":0},"Nm"]
[null,"Result:",null,"Allowed"]
["Fx =",{"$f":"X78","v":{"v":1.704,"d":"2"}},"N",{"$f":"Y78","v":4000},"N",{"$f":"IF(B74>D74,\"Too much !\",\" \")","v":" "},{"$nulls":21},"Totally"]
[{"$nulls":20},"Totally",{"$f":"SUM(V67:V74)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(W67:W74)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":14},"Total Fx  at const speed","Total Fx during acc"]
[{"$nulls":36},"Max Fx"]
[{"$nulls":23},"Fx",null,"Fy",null,"Fz",null,"Mx",null,"My",null,"Mz",null,"Total","one unit"]
[{"$nulls":17},{"$f":"VLOOKUP($AA$18,$Q$79:R84,2)","v":"Horizontal mounting, single unit"},{"$f":"VLOOKUP($AA$18,$Q$79:S84,2)","v":"Horizontal mounting, single unit"},{"$nulls":4},{"$f":"VLOOKUP($AA$18,$Q$79:X84,8)","v":{"v":1.704,"d":"2"}},{"$f":"VLOOKUP($AA$18,$Q$79:Y84,9)","v":4000},{"$f":"VLOOKUP($AA$18,$Q$79:Z84,10)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AA84,11)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AB84,12)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AC84,13)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AD84,14)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AE84,15)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AF84,16)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AG84,17)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AH84,18)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AI84,19)","v":0},{"$f":"VLOOKUP($AA$18,$Q$79:AJ84,20)+0.001","v":{"v":1E-3,"d":"0%"}},{"$f":"VLOOKUP($AA$18,$Q$79:AK84,21)","v":{"v":1.704,"d":"1.7"}},{"$f":"VLOOKUP($AA$18,$Q$79:AL84,22)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$18,$Q$79:AM84,23)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$18,$Q$79:AN84,24)","v":{"v":1.704,"d":"1.7"}}]
[{"$nulls":16},1,"Horizontal mounting, single unit",{"$nulls":5},{"$f":"Z26","v":{"v":1.704,"d":"2"}},{"$f":"AB26","v":4000},{"$nulls":11},{"$f":"AH26","v":{"v":1.704,"d":"1.7"}},{"$f":"AF33","v":{"v":0,"d":"0.0"}},{"$f":"AI26","v":{"v":0,"d":"0.0"}},{"$f":"AH26","v":{"v":1.704,"d":"1.7"}}]
[{"$nulls":16},2,"Horizontal mounting, 2 units",{"$nulls":5},{"$f":"Z40","v":{"v":3.408,"d":"3"}},{"$f":"AB40","v":8000},{"$nulls":11},{"$f":"AH40","v":{"v":1.704,"d":"1.7"}},{"$f":"AF47","v":0},{"$f":"AI40","v":{"v":0,"d":"0.0"}},{"$f":"AH40*2","v":{"v":3.408,"d":"3.4"}}]
[{"$nulls":16},3,"Vertical mounting, single unit",{"$nulls":5},{"$f":"Z54","v":{"v":15.904,"d":"16"}},{"$f":"AB54","v":4000},{"$nulls":11},{"$f":"AH54","v":{"v":15.904,"d":"15.9"}},{"$f":"AF61","v":{"v":0,"d":"0.0"}},{"$f":"AI54","v":{"v":14.2,"d":"14"}},{"$f":"AH54","v":{"v":15.904,"d":"15.9"}}]
[null,"Designation:  ",{"$f":"CONCATENATE(AS4,\"0\",IF(BO16<10,0,\"\"),BO16,IF(C19<1000,\"-00\",IF(C19<10000,\"-0\",\"-\")),C19,IF(G19<1000,\"-00\",IF(G19<10000,\"-0\",\"-\")),G19,\"x\",W13,IF(Q13<3,\"-0000\",-G18))","v":"WV06D020-02200-02770xN-0000"},{"$nulls":13},4,"Vertical  mounting, two units",{"$nulls":5},{"$f":"Z67","v":{"v":31.808,"d":"32"}},{"$f":"AB67","v":8000},{"$nulls":11},{"$f":"AH67","v":{"v":15.904,"d":"15.9"}},{"$f":"AF74","v":0},{"$f":"AI67","v":{"v":28.4,"d":"28"}},{"$f":"AH67*2","v":{"v":31.808,"d":"31.8"}}]
[{"$nulls":16},5]
[null,"Calculation of lifetime",{"$nulls":14},6]
[]
[null,null,"Average load factor fm",1]
[{"$nulls":16},"rpm ball screw",{"$f":"$C$52*1000/BO16*60","v":1800},null,"motor speed",{"$f":"R87*IF(L253=1,1,D110)","v":1800},"rpm"]
[null,null,"Ball screw",{"$f":"IF(T119<100000,T119,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(R119>5*10^7,\">50 000\",R119/1000)","v":">50 000"},"km"]
[null,null,"Ball bearing drive end",{"$f":"IF(T122<100000,T122,\"> 100 000\")","v":"> 100 000"},"h",{"$f":"IF(R122>5*10^7,\">50 000\",R122/1000)","v":">50 000"},"km"]
[]
[null,null,"number of cycles per minute",1,null,"Duty cycle",{"$f":"D91*2*C58/60","v":{"v":0.13888888888888892,"d":"14%"}},{"$f":"IF(G91>1,\"Not possible !\",\" \")","v":" "}]
[null,null,"Working hours per day",8]
[null,null,"Working days per year",220]
[]
[null,null,"Lifetime "]
[{"$nulls":3},{"$f":"IF(V119>50,\"> 50\",V119)","v":"> 50"},"Years","Ball screw"]
[{"$nulls":3},{"$f":"IF(V122>50,\"> 50\",V122)","v":"> 50"},"Years","Ball bearing drive end"]
[{"$nulls":28},{"$f":"2*0.19*10^-4+1.35*10^-6","v":3.935e-05}]
[{"$nulls":28},{"$f":"2*0.78*10^-4+6.7*10^-6","v":1.6270000000000002E-4}]
[null,null,"Idle torque at no load",{"$f":"O135","v":1.42},"Nm and",{"$f":"R87","v":{"v":1800,"d":"1,800"}},"rpm at",{"$f":"C52","v":0.6},"m/s",{"$nulls":18},{"$f":"2*4.18*10^-4+6.7*10^-6","v":8.4269999999999994E-4},{"$f":"2*184*10^-6+15*10^-6","v":0.000383}]
[]
[null,null,"Drive torque at constant speed",{"$f":"P145","v":1.42},"Nm and",{"$f":"D102*R87/9.55","v":{"v":267.6439790575916,"d":"268"}},"W"]
[null,null,"Drive torque during acc",{"$f":"P146","v":{"v":1.5143715198537178,"d":"1.51"}},"Nm and",{"$f":"D103*R87/9.55","v":{"v":285.431281228973,"d":"285"}},"W",{"$nulls":17},{"$f":"IF(Q4<=2,2,IF(Q4=5,4,3))","v":2},null,null,"kg m²"]
[null,null,"System inertia",{"$f":"S154","v":2.4872960807721195E-4},"kg m² (excluding gear, motor etc)",{"$nulls":21},{"$f":"VLOOKUP(Y103,Z105:AB108,2)","v":"GS19"},{"$f":"VLOOKUP(Y103,Z105:AB108,3)","v":3.9e-05}]
[null,{"$f":"IF(AND(Q18=1,P146>AI4),\"Too high drive torque\",IF(AND(Q18=2,P146>2*AI4),\"Too high drive torque\",\" \"))","v":" "},{"$nulls":23},1,"GS14",{"$f":"0.0000065","v":6.5e-06}]
[{"$nulls":24},"WM60",2,"GS19",3.9e-05]
[null,"Gear / Motor",{"$nulls":22},"WM80",3,"GS24",1.63E-4]
[{"$nulls":24},"WM120",4,"GS28",0.00038]
[]
[null,null,{"$f":"IF($L$253=2,\"Ratio\",\" \")","v":" "},4]
[null,null,{"$f":"IF($L$253=2,\"Effiency factor\",\" \")","v":" "},{"v":0.95,"d":"95%"}]
[null,null,{"$f":"IF($L$253=2,\"Idle torque\",\" \")","v":" "},0.1,{"$f":"IF($L$253=2,\"Nm\",\" \")","v":" "}]
[null,null,{"$f":"IF($L$253=2,\"Inertia\",\" \")","v":" "},5e-05,{"$f":"IF($L$253=2,\"kg m²\",\" \")","v":" "},{"$f":"IF(AND(L253=2,Q18=2),\"Total inertia for gears and parallel shaft\",\" \")","v":" "}]
[]
[]
[{"$nulls":12},"Calculation of lifetime."]
[]
[null,null,{"$f":"IF(OR(L257=2,L257=3),\"Nominal torque\",IF(L257=4,\"Holding torque\",\" \"))","v":"Nominal torque"},{"$f":"IF(L257=2,Q197,IF(L257=3,R168,IF(L257=4,O225,\" \")))","v":{"v":3.7726591549295785,"d":"3.8"}},{"$f":"IF(L257=2,\"Nm\",IF(L257=3,\"Nm at max speed\",IF(L257=4,\"Nm\",\" \")))","v":"Nm"},{"$nulls":8},"Lh ball screw = (C / Fx)^3 x 10^6  revolutions"]
[null,null,{"$f":"IF($L$257=2,\"Nominal speed\",IF($L$257=3,\"Peak torque\",\" \"))","v":"Nominal speed"},{"$f":"IF(L257=2,O197,IF(L257=3,S168,\" \"))","v":2840},{"$f":"IF($L$257=2,\"rpm\",IF($L$257=3,\"Nm\",\" \"))","v":"rpm"},{"$nulls":8},"Lifetime ball screw =",null,{"$f":"(AW4/(AK78+AX4)/D86)^3*10^6","v":24079945455.828934},"rev   =",{"$f":"P119*BO16/1000","v":481598909.1165787},"m  =",{"$f":"R119/C52/3600","v":{"v":222962.457924342,"d":"222,962"}},"h",{"$f":"R119*1000/C55/2/D91/60/D92/D93","v":{"v":1036.4990296069618,"d":"1036.5"}}]
[null,null,{"$f":"IF($L$257=2,\"Nominal power\",IF($L$257=3,\"Max speed\",\" \"))","v":"Nominal power"},{"$f":"IF(L257=2,P197,IF(L257=3,O168,\" \"))","v":1.1},{"$f":"IF($L$257=2,\"kW\",IF($L$257=3,\"rpm\",\" \"))","v":"kW"},{"$nulls":11},"Nm"]
[null,null,{"$f":"IF(L257=3,\"Nominal power\",\" \")","v":" "},{"$f":"IF(L257=3,P168,\" \")","v":" "},{"$f":"IF(L257=3,\"kW\",\" \")","v":" "},{"$nulls":11},"Nm (including ball screw inertia)"]
[null,null,{"$f":"IF(L257=5,\"Customer motor data:\",\" \")","v":" "},"Supplier, torque, power, rpm etc",{"$nulls":9},"Lifetime ball bearing =",null,{"$f":"(BA4/(AY4+AK78)/D86)^3*10^6","v":65269670092.7607},"rev    =",{"$f":"P122*BO16/1000","v":1305393401.8552139},"m  =",{"$f":"R122/C52/3600","v":{"v":604348.7971551917,"d":"604,349"}},"h",{"$f":"R122*1000/C55/2/D91/60/D92/D93","v":{"v":2809.472714047895,"d":"2809.5"}}]
[]
[{"$nulls":31},1]
[{"$nulls":13},"Efficieny factor ball nut =",{"v":0.9,"d":"90%"},{"$nulls":11},"Drive ",null,"motor",null,null,"Guide for selection of fm factor"]
[null,null,{"$f":"IF(L257=5,\"Motor inertia:\",\" \")","v":" "},0.0003,{"$f":"IF(L257=5,\"kg m²\",\" \")","v":" "},{"$nulls":21},"shaft",null,"shaft",null,null,"fm = 1,0 ; The same load in both directions"]
[{"$nulls":24},"Inertia",null,{"$f":"S154","v":2.4872960807721195E-4},"kgm²",{"$f":"IF(L253=1,S154+T156+T158,(S154+T156)/D110^2/D111+T157+T158)","v":1.2677296080772118E-3},"kgm²",null,"fm = 0,89 ; Full load forward, 75% load back"]
[null,"Required motor data",{"$nulls":22},"Top speed",null,{"$f":"R87","v":1800},"rpm",{"$f":"U87","v":1800},"rpm",null,"fm = 0,81 ; Full load forward, 50% load back"]
[null,null,"Torque at constant speed",{"$f":"Z147","v":{"v":1.4343434343434343,"d":"1.43"}},"Nm",{"$nulls":19},"Acceleration time",null,{"$f":"C52/C53","v":0.5},"sec",{"$f":"AA129","v":0.5},"sec",null,"fm = 0,8 ; Full load forward, no load back"]
[null,null," Torque during acceleration",{"$f":"Z148","v":{"v":1.9120239506669279,"d":"1.91"}},"Nm",{"$nulls":7},{"$f":"BI29","v":"Idle torque at"},150,1500,3000,"rpm",{"$nulls":9},{"$f":"AA127*3.14*AA128/30/AA129","v":{"v":0.09372131632349347,"d":"0.094"}},"Nm",{"$f":"AC127*3.14*AC128/30/AC129","v":{"v":0.4776805163234935,"d":"0.478"}},"Nm",null,"fm = 0,48 ; Full load 10% of the stroke forward and 20% rest of cycle"]
[null,null,"Power at constant speed",{"$f":"D129*D133/9550","v":{"v":0.27034745359352685,"d":"0.27"}},"kW",{"$nulls":7},0,0.9,1.5,1.9,"Nm"]
[null,null,"Power during acceleration",{"$f":"D130*D133/9550","v":{"v":0.3603814776126147,"d":"0.36"}},"kW",{"$f":"D133/D119*50","v":{"v":31.690140845070424,"d":"32"}},{"$f":"IF(L257=2,\"Hz\",\" \")","v":"Hz"}]
[null,null,"Max speed",{"$f":"U87","v":{"v":1800,"d":"1,800"}},"rpm",{"$nulls":7},"Idle torque Nm",null,{"$f":"IF(R87<=150,N131,IF(AND(R87>150,R87<=1500),N131+(R87-150)/1350*(O131-N131),O131+(R87-1500)/(Q104-1500)*(P131-O131)))","v":1.42},"Single unit"]
[null,null,"Inertia balance",{"$f":"R161","v":{"v":1.293601640895114,"d":"1.3"}}]
[{"$nulls":13},"Totally",{"$f":"O133*Q18","v":1.42},"Nm per application"]
["Notes:"]
{"$rows_empty":8}
[{"$nulls":11},"Drive torque during constant speed",{"$nulls":3},{"$f":"O135+AM78*BO16/2/1000/O125/PI()","v":1.42}]
[{"$nulls":11},"Drive torque during acceleration",{"$nulls":3},{"$f":"O135+AN78*BO16/2/1000/O125/PI()+Q18*BC4*G19/1000*PI()*R87/30/C52*C53","v":1.5143715198537178}]
[{"$nulls":21},"Motor torque during costant speed",{"$nulls":3},{"$f":"IF(L253=1,P145/0.99,P145/D110/D111+D112)","v":1.4343434343434343},"Nm",null,"Här är lite frågetecken, eller nej?"]
[{"$nulls":21},"Motor torque duringacceleration",{"$nulls":3},{"$f":"AC130+Z147","v":{"v":1.9120239506669279,"d":"1.912"}},"Nm including inertia and losses in gear"]
[{"$nulls":15},{"$f":"P146-P145","v":0.09437151985371783}]
[]
[{"$nulls":11},"Linear inertia from load and carries:",{"$nulls":4},"m x ( m/min / 2π / rpm ) ^2 =",null,null,{"$f":"(C49+AM4*S13*Q18)*(C52*60/2/PI()/R87)^2","v":1.4387608077211964E-5},"kg m²"]
[{"$nulls":11},"Inertia ball screw",{"$nulls":7},{"$f":"BC4*G19/1000*Q18","v":{"v":2.3434200000000001E-4,"d":"0.000234"}},"kg m²"]
[]
[{"$nulls":18},{"$f":"SUM(T151:T152)","v":2.4872960807721195E-4}]
[]
[{"$nulls":11},"Inertia coupling",{"$nulls":7},{"$f":"AB104*Q18","v":3.9e-05}]
[{"$nulls":11},"Inertia gear",{"$nulls":7},{"$f":"IF(L253=2,D113,0)","v":0}]
[{"$nulls":11},"Inertia motor",{"$nulls":7},{"$f":"IF(L257=1,0,IF(L257=2,R197,IF(L257=3,V168,IF(L257=4,P225,IF(L257=5,D126,0)))))","v":0.00098}]
[]
[{"$nulls":12},"Total inertia reduced to motor shaft",{"$nulls":5},{"$f":"(S154+T156)/IF(L253=1,1,D110^2)+T157+T158","v":1.2677296080772118E-3}]
[{"$nulls":12},"Inertia balance",{"$nulls":4},{"$f":"S160/T158","v":1.293601640895114}]
[]
[]
[]
[{"$nulls":11},1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[{"$nulls":12},"AKM servo motor",null,"nom rpm","kW","nom Nm","Nm at max rpm","Peak Nm","Inertia","Brake inertia",null,"Nm/A","mVmin","Ohm"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$169:M192,M$165)","v":"AKM52G"},{"$f":"VLOOKUP($L$265,$L$169:N192,N165)","v":0},{"$f":"VLOOKUP($L$265,$L$169:O192,O165)","v":2500},{"$f":"VLOOKUP($L$265,$L$169:P192,P165)","v":1.85},{"$f":"VLOOKUP($L$265,$L$169:Q192,Q165)","v":8.43},{"$f":"VLOOKUP($L$265,$L$169:R192,R165)","v":7.06},{"$f":"VLOOKUP($L$265,$L$169:S192,S165)","v":21.5},{"$f":"VLOOKUP($L$265,$L$169:T192,T165)","v":6.2E-4},{"$f":"VLOOKUP($L$265,$L$169:U192,U165)","v":1.7E-5},{"$f":"VLOOKUP($L$265,$L$169:V192,V165)","v":0.000637},{"$f":"VLOOKUP($L$265,$L$169:W192,W165)","v":1.79},{"$f":"VLOOKUP($L$265,$L$169:X192,X165)","v":115},{"$f":"VLOOKUP($L$265,$L$169:Y192,Y165)","v":3.47}]
[{"$nulls":11},1,"AKM31C",null,5000,0.52,1.15,1,3.88,3.3e-05,1.2e-06,{"$f":"IF($O$257=2,T169+U169,T169)","v":3.4200000000000005E-5},0.85,54.5,21.4]
[{"$nulls":11},2,"AKM32C",null,3000,0.58,2,1.86,6.92,5.9e-05,1.2e-06,6.02E-5,1.4,89.8,23]
[{"$nulls":11},3,"AKM33E",null,4500,1.1,2.79,2.34,9.96,{"v":8.5e-05,"d":"0.000085"},1.2e-06,8.6200000000000008E-5,1.1,70.6,8.36]
[{"$nulls":11},4,"AKM41C",null,3000,0.56,1.95,1.77,6.12,8.1e-05,6.8e-06,8.78e-05,1.34,86.3,21.7]
[{"$nulls":11},5,"AKM42E",null,3500,1.03,3.42,2.81,11.3,0.00015,6.8e-06,0.0001568,1.26,80.9,7.22]
[{"$nulls":11},6,"AKM43E",null,2500,1.03,4.7,3.92,15.9,0.00021,6.8e-06,0.0002168,1.72,111,8.04]
[{"$nulls":11},7,"AKM44G",null,4000,1.57,5.88,3.76,20.2,2.7E-4,6.8e-06,0.0002768,1.19,76.6,2.65]
[{"$nulls":11},8,"AKM51E",null,2500,1.04,4.7,3.98,11.6,0.00034,1.7E-5,3.57E-4,1.72,110,8.47]
[{"$nulls":11},9,"AKM52G",null,2500,1.85,8.43,7.06,21.5,6.2E-4,1.7E-5,0.000637,1.79,115,3.47]
[{"$nulls":11},10,"AKM53K",null,4000,3.2,11.6,7.65,30.1,9.1E-4,1.7E-5,0.000927,1.24,79.8,1]
[{"$nulls":11},11,"AKM54K",null,3500,3.68,14.4,10.05,38.4,0.0012,1.7E-5,1.217E-3,1.5,96.6,1.02]
[{"$nulls":11},12,"AKM62K",null,3500,3.3,12.2,9,30.1,0.0017,6.1e-05,1.761E-3,1.28,82.1,1.05]
[{"$nulls":11},13,"AKM63K",null,3000,4.05,16.8,12.9,42.6,0.0024,6.1e-05,2.4609999999999996E-3,1.71,110,1.09]
[{"$nulls":11},14,"AKM64L",null,3000,4.9,21,15.6,54.1,0.0032,6.1e-05,3.261E-3,1.66,107,0.71]
[{"$nulls":11},15,"AKM65M",null,2500,5.03,25,19.2,65.2,0.004,6.1e-05,0.004061,1.85,119,0.68]
[{"$nulls":11},16]
[{"$nulls":11},17]
[{"$nulls":11},18]
[{"$nulls":11},19]
[{"$nulls":11},20]
[{"$nulls":11},21]
[{"$nulls":11},22]
[{"$nulls":11},23]
[{"$nulls":11},24]
[]
[]
[]
[{"$nulls":12},"AC motors",null,"rpm","kW","Nm","Kgm2"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$198:M221,M$165)","v":"IEC80 3000 rpm 1,1 kW"},null,{"$f":"VLOOKUP($L$265,$L$198:O221,O$165)","v":2840},{"$f":"VLOOKUP($L$265,$L$198:P221,P$165)","v":1.1},{"$f":"VLOOKUP($L$265,$L$198:Q221,Q$165)","v":3.7726591549295785},{"$f":"VLOOKUP($L$265,$L$198:R221,R$165)","v":0.00098}]
[{"$nulls":11},1,"IEC 63  3000 rpm  0,25 kW",null,2750,0.25,{"$f":"71620*1.36*P198/O198/10","v":{"v":0.8854836363636365,"d":"0.9"}},0.00023]
[{"$nulls":11},2,"IEC 63  with brake 3000 rpm  0,25 kW",null,2750,0.25,{"v":0.8854836363636365,"d":"0.9"},0.00025]
[{"$nulls":11},3,"IEC 63  1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},0.00025]
[{"$nulls":11},4,"IEC 63  with brake 1500 rpm  0,18 kW",null,1360,0.18,{"v":1.28916,"d":"1.3"},3.5E-4]
[{"$nulls":11},5,"IEC71 3000 rpm 0,55 kW",null,2760,0.55,{"v":1.9410057971014496,"d":"1.9"},0.00042]
[{"$nulls":11},6,"IEC71 with brake 3000 rpm 0,55 kW",null,2760,0.55,1.9,0.00049]
[{"$nulls":11},7,"IEC71 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00081]
[{"$nulls":11},8,"IEC71 with brake 1500 rpm 0,37 kW",null,1370,0.37,{"v":2.630597372262774,"d":"2.6"},0.00094]
[{"$nulls":11},9,"IEC80 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},0.00098]
[{"$nulls":11},10,"IEC80 with brake 3000 rpm 1,1 kW",null,2840,1.1,{"v":3.7726591549295785,"d":"3.8"},{"$f":"0.000061+R206","v":1.041E-3}]
[{"$nulls":11},11,"IEC80 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},1.874E-3]
[{"$nulls":11},12,"IEC80 with brake 1500 rpm 0,75 kW",null,1380,0.75,{"v":5.293652173913044,"d":"5.3"},{"$f":"0.000061+R208","v":0.001935}]
[{"$nulls":11},13,"IEC90 3000 rpm 2,2 kW",null,2860,2.2,7.3,0.00161]
[{"$nulls":11},14,"IEC90 with brake 3000 rpm 2,2 kW",null,2850,2.2,{"v":7.518843508771932,"d":"7.5"},{"$f":"0.0002+R210","v":{"v":1.8100000000000002E-3,"d":"0.00181"}}]
[{"$nulls":11},15,"IEC90 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":2.8E-3,"d":"0.00280"}]
[{"$nulls":11},16,"IEC90 with brake 1500 rpm 1,5 kW",null,1420,1.5,{"v":10.289070422535213,"d":"10.3"},{"v":0.0041,"d":"0.00410"}]
[{"$nulls":11},17,"IEC100 3000 rpm 3 kW",null,2850,3,9.9,0.0032]
[{"$nulls":11},18,"IEC100 with brake 3000 rpm 3 kW",null,2850,3,9.9,0.00427]
[{"$nulls":11},19,"IEC100 1500 rpm 3 kW",null,1430,3,20,0.006]
[{"$nulls":11},20,"IEC100 with brake 1500 rpm 3 kW",null,1430,3,20,0.0101]
[{"$nulls":11},21,"IEC112 3000 rpm 4 kW",null,2890,4,13.2,0.00499]
[{"$nulls":11},22,"IEC112 with brake 3000 rpm 4 kW",null,2890,4,13.2,0.0083]
[{"$nulls":11},23,"IEC112 1500 rpm 4 kW",null,1420,4,26.6,0.01114]
[{"$nulls":11},24,"IEC112 with brake 1500 rpm 4 kW",null,1420,4,26.6,0.02]
[]
[]
[{"$nulls":14},"Hold torque","Inertia"]
[{"$nulls":12},{"$f":"VLOOKUP($L$265,$L$226:M249,M$165)","v":"-"},{"$f":"VLOOKUP($L$265,$L$226:N249,N$165)","v":0},{"$f":"VLOOKUP($L$265,$L$226:O249,O$165)","v":"-"},{"$f":"VLOOKUP($L$265,$L$226:P249,P$165)","v":"-"}]
[{"$nulls":11},1,"KML061",null,1.2,2.4e-05]
[{"$nulls":11},2,"KML062",null,1.77,{"v":3.95e-05,"d":"0.000040"}]
[{"$nulls":11},3,"KML063",null,2.47,{"v":5.93e-05,"d":"0.000059"}]
[{"$nulls":11},4,"KML091",null,2.72,{"v":1.13E-4,"d":"0.000113"}]
[{"$nulls":11},5,"KML092",null,5.44,0.000219]
[{"$nulls":11},6,"KML093",null,8.16,0.000332]
[{"$nulls":11},7,"-",null,"-","-"]
[{"$nulls":11},8,"-",null,"-","-"]
[{"$nulls":11},9,"-",null,"-","-"]
[{"$nulls":11},10,"-",null,"-","-"]
[{"$nulls":11},11,"-",null,"-","-"]
[{"$nulls":11},12,"-",null,"-","-"]
[{"$nulls":11},13,"-",null,"-","-"]
[{"$nulls":11},14,"-",null,"-","-"]
[{"$nulls":11},15,"-",null,"-","-"]
[{"$nulls":11},16,"-",null,"-","-"]
[{"$nulls":11},17,"-",null,"-","-"]
[{"$nulls":11},18,"-",null,"-","-"]
[{"$nulls":11},19,"-",null,"-","-"]
[{"$nulls":11},20,"-",null,"-","-"]
[{"$nulls":11},21,"-",null,"-","-"]
[{"$nulls":11},22,"-",null,"-","-"]
[{"$nulls":11},23,"-",null,"-","-"]
[{"$nulls":11},24,"-",null,"-","-"]
[]
[]
[]
[{"$nulls":11},1]
[{"$nulls":11},1,"Direct / coupling"]
[{"$nulls":11},2,"Gear"]
[]
[{"$nulls":11},2,null,null,2]
[{"$nulls":11},1,"No motor",null,1,{"$f":"IF($L$257=3,\"Without brake\",\" \")","v":" "}]
[{"$nulls":11},2,"AC motor",null,2,{"$f":"IF($L$257=3,\"With brake\",\" \")","v":" "}]
[{"$nulls":11},3,"AKM servo motor"]
[{"$nulls":11},4,"Stepper motor"]
[{"$nulls":11},5,"Customer motor"]
[]
[]
[{"$nulls":11},9]
[{"$nulls":11},1,{"$f":"IF($L$257=1,\"-\",IF($L$257=2,M198,IF($L$257=3,M169,IF($L$257=4,M226,\" - \"))))","v":"IEC 63  3000 rpm  0,25 kW"}]
[{"$nulls":11},2,"IEC 63  with brake 3000 rpm  0,25 kW"]
[{"$nulls":11},3,"IEC 63  1500 rpm  0,18 kW"]
[{"$nulls":11},4,"IEC 63  with brake 1500 rpm  0,18 kW"]
[{"$nulls":11},5,"IEC71 3000 rpm 0,55 kW"]
[{"$nulls":11},6,"IEC71 with brake 3000 rpm 0,55 kW"]
[{"$nulls":11},7,"IEC71 1500 rpm 0,37 kW"]
[{"$nulls":11},8,"IEC71 with brake 1500 rpm 0,37 kW"]
[{"$nulls":11},9,"IEC80 3000 rpm 1,1 kW"]
[{"$nulls":11},10,"IEC80 with brake 3000 rpm 1,1 kW"]
[{"$nulls":11},11,"IEC80 1500 rpm 0,75 kW"]
[{"$nulls":11},12,"IEC80 with brake 1500 rpm 0,75 kW"]
[{"$nulls":11},13,"IEC90 3000 rpm 2,2 kW"]
[{"$nulls":11},14,"IEC90 with brake 3000 rpm 2,2 kW"]
[{"$nulls":11},15,"IEC90 1500 rpm 1,5 kW"]
[{"$nulls":11},16,"IEC90 with brake 1500 rpm 1,5 kW"]
[{"$nulls":11},17,"IEC100 3000 rpm 3 kW"]
[{"$nulls":11},18,"IEC100 with brake 3000 rpm 3 kW"]
[{"$nulls":11},19,"IEC100 1500 rpm 3 kW"]
[{"$nulls":11},20,"IEC100 with brake 1500 rpm 3 kW"]
[{"$nulls":11},21,"IEC112 3000 rpm 4 kW"]
[{"$nulls":11},22,"IEC112 with brake 3000 rpm 4 kW"]
[{"$nulls":11},23,"IEC112 1500 rpm 4 kW"]
[{"$nulls":11},24,"IEC112 with brake 1500 rpm 4 kW"]

{"sheet":"Information","index":4,"n_rows":74,"n_cols":12,"rows_kept":74}
["Glossary"]
[]
["Stroke","This is the max theoretical stroke of the unit."]
[null,"Please note that it is important to stop the"]
[null," movement before reaching end of stroke."]
[]
["Speed","This is the max speed used during the stroke"]
[]
["Acceleration","Rate of speed change going from a lower to a higher speed"]
[null,"Typically meassured in m/s2"]
[]
["Force / Mass","Example: when you push a box on the floor, you are using a force."]
[null,"Mass is what you normally call \"weight\""]
[null,"The friction between the rolls and the floor is the force at constant speed"]
[null,"When you accelarate the box you will need a bigger force but this will"]
[null," this software take care of."]
[]
[]
[]
[{"$nulls":5},"Force"]
[]
[{"$nulls":6},"Force"]
[]
[]
[]
[null,"If you instead lift the box, you need a force"]
[null,"doing that but don't forget that you are also"]
[null,"moving a mass."]
[null,"Both force and mass must be inserted"]
[null,"in the calculation."]
[]
[null,"Example: When you push a car, the mass is about 1000 kg but"]
[null,null,"the force is perhaps just 200 N."]
[null,null,"When you lift the same car, the mass is still 1000 kg but the force is about 10 000 N"]
[]
[null,null,"Compressing a spring requires a force but the mass is close to zero."]
[]
[null,null,"Similar examples are punching holes, extruding, pumping and locking clamps."]
[]
[]
[]
[" load factor fm","   Very often the force to the unit is not the same all the time during the stroke."]
[null,"If the load is lower during some part, this is positive for the life time of ball screw"]
[null,"and ball bearings. The requested max motor power will still be the same."]
[]
[null,null,"Guide for selection of fm factor"]
[null,null,"fm = 1,0 ;The same load in both directions"]
[null,null,"fm = 0,89 ;Load forward, 75% load back"]
[null,null,"fm = 0,81 ;Load forward, 50% load back"]
[null,null,"fm = 0,8 ;Load forward, no load back"]
[null,null,"fm = 0,63 ;Load 50% of the stroke forward and no load back"]
[]
[null,"This can be calculated from formulas normally found in ball bearing catalogues."]
[]
[]
[" Please note:"]
[" Fx, Fy, Fz, Mx, My and Mz are external forces and torques and  are not connected with or caused by \"Total mass to move\""]
[" Forces and torques towards the carriage caused by the weight of mass and accelaration of the mass are"]
[" taken care of by the calculations. The orientation of the linear unit and the location of the mass are important for correct answer."]
[]
[" If the mass is carried by external guides or by the carriage/carriages, select correct  No or Yes"]
[]
[]
["Calculations at a unit with two carraiges, two units with each one carriage or two units with each two carriages are made as if the carriages are connected with a solid block."]
[]
[{"$nulls":5},"connecing block"]
[]
["One unit",{"$nulls":10},"Two units in parallel with each one carriage"]
[]
[]
[]
[]
[]
[{"$nulls":9},"Two units in parallel with each two carriages"]

{"sheet":"Blad3","index":5,"n_rows":53,"n_cols":7,"rows_kept":53,"hidden":true}
["Glossary"]
[]
["Stroke","This is the max theoretical stroke of the unit."]
[null,"Please note that it is important to stop the"]
[null," movement before reaching end of stroke."]
[]
["Speed","This is the max speed used during the stroke"]
[]
["Acceleration","Rate of speed change going from a lower to a higher speed"]
[null,"Typically meassured in m/s2"]
[]
["Force / Mass","Example: when you push a box on the floor, you are using a force."]
[null,"Mass is what you normally call \"weight\""]
[null,"The friction between the rolls and the floor is the force at constant speed"]
[null,"When you accelarate the box you will need a bigger force but this will"]
[null," this software take care of."]
[]
[]
[]
[{"$nulls":5},"Force"]
[]
[{"$nulls":6},"Force"]
[]
[]
[]
[null,"If you instead lift the box, you need a force"]
[null,"doing that but don't forget that you are also"]
[null,"moving a mass."]
[null,"Both force and mass must be inserted"]
[null,"in the calculation."]
[]
[null,"Example: When you push a car, the mass is about 1000 kg but"]
[null,null,"the force is perhaps just 200 N."]
[null,null,"When you lift the same car, the mass is still 1000 kg but the force is about 10 000 N"]
[]
[null,null,"Compressing a spring requires a force but the mass is close to zero."]
[]
[null,null,"Similar examples are punching holes, extruding, pumping and locking clamps."]
[]
[]
[]
[" load factor fm","   Very often the force to the unit is not the same all the time during the stroke."]
[null,"If the load is lower during some part, this is positive for the life time of ball screw"]
[null,"and ball bearings. The requested max motor power will still be the same."]
[]
[null,null,"Guide for selection of fm factor"]
[null,null,"fm = 1,0 ;The same load in both directions"]
[null,null,"fm = 0,89 ;Full load forward, 75% load back"]
[null,null,"fm = 0,81 ;Full load forward, 50% load back"]
[null,null,"fm = 0,8 ;Full load forward, no load back"]
[null,null,"fm = 0,63 ;Full load 50% of the stroke forward and no load back"]
[]
[null,"This can be calculated from formulas normally found in ball bearing catalogues."]