{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calculation","Blad2","Information"],"not_rendered":{"charts":2,"images":4,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Calculation","index":0,"n_rows":286,"n_cols":64,"rows_kept":286,"merged":[[1,36,1,37],[1,39,1,40],[1,45,1,46],[1,48,1,49],[1,50,1,51],[1,53,1,54],[1,55,1,56],[3,1,3,3],[4,1,4,3],[5,1,5,3],[5,5,5,6],[19,33,19,34],[20,30,20,31],[34,30,34,31],[47,30,47,31],[60,30,60,31],[73,30,73,31],[86,30,86,31],[96,38,98,38],[96,39,98,39],[97,36,97,37],[98,23,98,24],[98,25,98,26],[98,27,98,28],[98,29,98,30],[98,31,98,32],[98,33,98,34],[123,20,123,21],[123,22,123,23],[124,14,124,19]]}
["Linear unit WH",null,null,"Sizing & selection",{"$nulls":4},"2015 02 03  JHj       Release 2",{"$nulls":48},"Distance carriage top to"]
["WH50 WH80 WH120",{"$nulls":19},"max stroke",null,null,"Min dist carriages","Fx max","Fy","Fz","Mx","My","Mz","Frd","Mta","Speed","Acc","Fx at this ","Carriage ","Weight",null,"preload","Wheel distance",null,null,"preload","C dyn","Da","pulley diameter",null,"Pretension","Drive station",null,"Tension station",null,null,"Fr >= Fa",null,"Fr < Fa",null,"center",{"$nulls":5},"#"]
[{"$nulls":34},"speed","weight","0 stroke","100 mm","friction","Lx","Ly",null,"each wheel",null,null,"Drive ","tension","belt","Type","C","Type","C",null,"x","y","x","y","wheeles"]
["Customer",{"$nulls":15},1,{"$f":"VLOOKUP(Q4,Q5:R7,2)","v":"WH50"},{"$f":"VLOOKUP(Q4,Q5:S7,3)","v":"16ATL5"},{"$f":"VLOOKUP(Q4,Q5:T7,4)","v":120},{"$f":"VLOOKUP($Q$4,$Q$5:U7,5)","v":3000},{"$f":"VLOOKUP($Q$4,$Q$5:V7,6)","v":440},{"$f":"VLOOKUP($Q$4,$Q$5:W7,7)","v":140},{"$f":"VLOOKUP($Q$4,$Q$5:X7,8)","v":260},{"$f":"VLOOKUP($Q$4,$Q$5:Y7,9)","v":670},{"$f":"VLOOKUP($Q$4,$Q$5:Z7,10)","v":415},{"$f":"VLOOKUP($Q$4,$Q$5:AA7,11)","v":730},{"$f":"VLOOKUP($Q$4,$Q$5:AB7,12)","v":16},{"$f":"VLOOKUP($Q$4,$Q$5:AC7,13)","v":87},{"$f":"VLOOKUP($Q$4,$Q$5:AD7,14)","v":50},{"$f":"VLOOKUP($Q$4,$Q$5:AE7,15)","v":150},{"$f":"VLOOKUP($Q$4,$Q$5:AF7,16)","v":17},{"$f":"VLOOKUP($Q$4,$Q$5:AG7,17)","v":6.5},{"$f":"VLOOKUP($Q$4,$Q$5:AH7,18)","v":40},{"$f":"VLOOKUP($Q$4,$Q$5:AI7,19)","v":585},{"$f":"VLOOKUP($Q$4,$Q$5:AJ7,20)","v":0.9},{"$f":"VLOOKUP($Q$4,$Q$5:AK7,21)","v":3.5},{"$f":"VLOOKUP($Q$4,$Q$5:AL7,22)","v":0.44},{"$f":"VLOOKUP($Q$4,$Q$5:AM7,23)","v":16},{"$f":"VLOOKUP($Q$4,$Q$5:AN7,24)","v":198},{"$f":"VLOOKUP($Q$4,$Q$5:AO7,25)","v":39},{"$f":"VLOOKUP($Q$4,$Q$5:AP7,26)","v":"WH05Z120"},{"$f":"VLOOKUP($Q$4,$Q$5:AQ7,27)","v":200},{"$f":"VLOOKUP($Q$4,$Q$5:AR7,28)","v":1630},{"$f":"VLOOKUP($Q$4,$Q$5:AS7,29)","v":15.8},{"$f":"VLOOKUP($Q$4,$Q$5:AT7,30)","v":38.2},{"$f":"VLOOKUP($Q$4,$Q$5:AU7,31)","v":38.2},{"$f":"VLOOKUP($Q$4,$Q$5:AV7,32)","v":650},{"$f":"VLOOKUP($Q$4,$Q$5:AW7,33)","v":"61906 INA"},{"$f":"VLOOKUP($Q$4,$Q$5:AX7,34)","v":7000},{"$f":"VLOOKUP($Q$4,$Q$5:AY7,35)","v":"609 SKF"},{"$f":"VLOOKUP($Q$4,$Q$5:AZ7,36)","v":3710},{"$f":"VLOOKUP($Q$4,$Q$5:BA7,37)","v":"LFR50/5-6-2Z"},{"$f":"VLOOKUP($Q$4,$Q$5:BB7,38)","v":1},{"$f":"VLOOKUP($Q$4,$Q$5:BC7,39)","v":3.1},{"$f":"VLOOKUP($Q$4,$Q$5:BD7,40)","v":0.5},{"$f":"VLOOKUP($Q$4,$Q$5:BE7,41)","v":3.6},{"$f":"VLOOKUP($Q$4,$Q$5:BF7,42)","v":35}]
["Project",{"$nulls":15},1,"WH50","16ATL5",120,{"v":3000,"d":"3,000"},440,140,260,670,{"$f":"IF(Q10=3,830,415)","v":415},{"$f":"IF(Q10=3,1460,730)","v":730},{"$f":"IF(Q10=3,32,16)","v":16},{"$f":"IF($Q$10=1,87,IF($Q$10=2,130,0.415*$G$16))","v":87},{"$f":"IF($Q$10=1,50,IF($Q$10=2,75,0.73*$G$16))","v":50},150,17,6.5,40,{"$f":"IF(C50<2,670-170/2*C50,540-170/6.5*C50)","v":585},{"$f":"IF($Q$10=1,0.9,IF($Q$10=2,1.47,2*0.9))","v":0.9},3.5,0.44,{"$f":"IF(Q10=3,32,16)","v":16},{"$f":"IF($Q$10=3,$G$16,IF(Q10=2,368,198))","v":198},39,"WH05Z120",200,1630,15.8,38.2,38.2,650,"61906 INA",7000,"609 SKF",3710,"LFR50/5-6-2Z",1,3.1,0.5,3.6,35]
["Date",{"$nulls":3},"Ref:","xxx",{"$nulls":10},2,"WH80","32ATL10",200,{"v":11000,"d":"11,000"},550,170,300,2700,{"$f":"IF(Q10=3,1764,882)","v":882},{"$f":"IF(Q10=3,4200,2100)","v":2100},{"$f":"IF(Q10=3,150,75)","v":75},{"$f":"IF($Q$10=1,230,IF($Q$10=2,345,0.882*$G$16))","v":230},{"$f":"IF($Q$10=1,100,IF($Q$10=2,150,2.1*$G$16))","v":100},500,100,10,40,{"$f":"IF(C50<=0.5,2700,IF(AND(C50>0.5,C50<3),2800-2800/10*C50,2300-900/10*C50))","v":2520},{"$f":"IF($Q$10=1,2.75,IF($Q$10=2,3.43,2*2.75))","v":2.75},8.63,0.93,{"$f":"IF(Q10=3,40,20)","v":20},{"$f":"IF($Q$10=3,$G$16,IF(Q10=2,390,220))","v":220},65,"WH08Z200",500,4100,22.8,63.66,63.66,1350,"6010 SKF",21600,"6204 SKF",12700,"LFR 50/8-6-2Z",1,3.1,0.5,3.6,45]
[{"$nulls":16},3,"WH120","50ATL10",260,{"v":11000,"d":"11,000"},605,240,300,5000,{"$f":"IF(Q10=3,9960,4980)","v":4980},{"$f":"IF(Q10=3,18600,9300)","v":9300},{"$f":"IF(Q10=3,1000,500)","v":500},{"$f":"IF($Q$10=1,930,IF($Q$10=2,1395,4.98*$G$16))","v":930},{"$f":"IF($Q$10=1,500,IF($Q$10=2,750,9.3*$G$16))","v":500},700,200,10,40,{"$f":"IF(C50<=1.5,5000,IF(AND(C50>1.5,C50<3.5),5500-3700/10*C50,4800-1700/10*C50))","v":5000},{"$f":"IF($Q$10=1,5.5,IF($Q$10=2,8.67,2*5.5))","v":5.5},17,1.64,{"$f":"IF(Q10=3,60,30)","v":30},{"$f":"IF($Q$10=3,$G$16,IF(Q10=2,420,180))","v":180},97,"WH12Z260",2500,14500,44.25,82.76,82.76,2500,"6011 SKF",28100,"6305 SKF",22500,"LFR5302-10-2Z",1,2.7,0.5,3.2,67]
["Linear drive unit:"]
[null,"Size"]
[{"$nulls":16},1,null,{"$f":"IF(Q10=3,2,1)","v":1},null,{"$f":"VLOOKUP(Q10,Q11:U13,5)","v":0},{"$f":"VLOOKUP(Q10,Q11:V13,6)","v":0.9},{"$f":"VLOOKUP(Q10,Q11:W13,7)","v":"N"},1,{"$f":"IF(X10=1,1,0)","v":1}]
[null,"Guidings","  Wheel guide",{"$nulls":13},1,"N = Single standard carriage",null,null,0,{"$f":"AJ4","v":0.9},"N",1,"Yes"]
[null,"Drive mechanism","  Belt drive",null,{"$f":"S4","v":"16ATL5"},{"$nulls":3},{"$f":"IF(G16<X4,\"Too short\",\" \")","v":" "},{"$nulls":7},2,"L = Single long carriage",null,null,{"$f":"W4","v":140},{"$f":"IF(Q4=1,1.47,IF(Q4=2,3.43,8.67))","v":1.47},"L",2,"No"]
[null,"Move per rev",{"$f":"T4","v":120},"mm",null,{"$f":"IF(AND($K$20=3,$K$10<$K$21),\"Min Lc =\",\" \")","v":" "},{"$f":"IF(AND($K$20=3,$K$10<$K$21),$K$21,\" \")","v":" "},{"$f":"IF(AND($K$20=3,$K$10<$K$21),\"mm\",\" \")","v":" "},{"$nulls":8},3,"Z = Double standard carriage",null,null,{"$f":"G16","v":500},{"$f":"2*AJ4","v":1.8},"Z"]
[null,"Repeatability",0.05,"mm",{"$nulls":22},"Configuration"]
[{"$nulls":16},1,"units",{"$f":"Q15-1","v":0},1,null,null,2,{"$nulls":3},{"$f":"IF(AND(Q15=1,T15=1,W15=1),1,IF(AND(Q15=2,T15=1,W15=1),2,IF(AND(Q15=1,T15=1,W15=2),3,IF(AND(Q15=2,T15=1,W15=2),4,IF(AND(Q15=1,T15=2),5,IF(AND(Q15=2,T15=2),6,\"\"))))))","v":3}]
[null,"Saddle",null,null,{"$f":"IF(K20=2,\"Not available\",\" \")","v":" "},{"$f":"IF(Q10=3,\"LA =\",\" \")","v":" "},500,{"$f":"IF(Q10=3,\"mm\",\"Only when C-saddle\")","v":"Only when C-saddle"},{"$nulls":8},"one single unit",null,null,1,"Horizontal",null,1,{"$f":"IF(T15=1,\"Top or downward\",\" \")","v":"Top or downward"},null,null,{"$f":"R100","v":"Horizontal mounting, single unit, carriage sideway"}]
[null,"Stroke",2000,"mm",null,"Total length",{"$f":"C17+V4+U10","v":2440},"mm",{"$nulls":8},"two units in parallel",null,null,2,"Vertical",null,2,{"$f":"IF(T15=1,\"Sideway\",\" \")","v":"Sideway"}]
[null,null,{"$f":"IF(C17>U4,\"Longer than standard. Check with plant\",\" \")","v":" "}]
[null,null,"Number of units",{"$nulls":20},"Friction factor =",0.01]
[{"$f":"IF(Q15=2,\"Distance between  linear units\",\" \")","v":" "},null,null,800,{"$nulls":12},"Horizontal mounting, single unit, carriage at top",{"$nulls":13},"Radial F","Axial F",null,"Fx at"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max",null,null,"constant speed","Acceleration"]
[null,null,"Weight of linear drive unit/-s",{"$f":"Q15*(AK4+AL4*(G17+IF(Q10=3,G16,0))/100+V10)","v":{"v":15.136,"d":"15.1"}},"kg",null,{"$f":"IF(M31=0,\" \",IF(C25/2000>#REF!,\"OK\",\"Too much\"))","v":" "},{"$nulls":10},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
[{"$nulls":5},{"$f":"IF(M31=0,\" \",\"Deflection\")","v":" "},{"$nulls":10},"Mx =",{"$f":"$C$47*10*M48/1000","v":0},0,{"$f":"Y10*R23+S23+C44","v":0},"Nm",{"$f":"T23/AO4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fx =",{"$f":"C41+(C47+AJ4)*C51+AM4*S10+V31","v":{"v":16.9,"d":"17"}},"N",{"$f":"AI4","v":585},{"$nulls":5},{"$f":"C41+V31","v":{"v":0,"d":"0.0"}},{"$f":"AH23+U126*2*G17/1000*C51+(C47+AJ4*S10)*C51","v":{"v":1.1684,"d":"1"}}]
[null,"Mounting direction",{"$nulls":14},"My =",{"$f":"$C$47*10*M47/1000","v":0},{"$f":"C47*C51*M49/1000","v":0},{"$f":"Y10*R24+S24+C45","v":0},"Nm",{"$f":"T24/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42","v":0},"N",{"$f":"Z4","v":415},{"$f":"Z24/AB24","v":{"v":0,"d":"0%"}},null,{"v":0,"d":"0.0"},{"$f":"Z24/4/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":16},"Mz =",0,{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R25+S25+C46","v":0},"Nm",{"$f":"T25/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fz =",{"$f":"C43+C47*10*Y10","v":0},"N",{"$f":"AA4","v":730},{"$f":"Z25/AB25","v":{"v":0,"d":"0%"}},null,{"$f":"Z25/4/S10","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$nulls":24},"Mx =",{"$f":"T23","v":0},"Nm",{"$f":"AB4","v":16},{"$f":"Z26/AB26","v":{"v":0,"d":"0%"}},null,{"$f":"Z26/AO4*1000/2/S10","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z24*Y19","v":0},null,null,"My =",{"$f":"T24","v":0},"Nm",{"$f":"AC4","v":87},{"$f":"Z27/AB27","v":{"v":0,"d":"0%"}},null,{"$f":"(Z27+C47*C50*BF4/1000)/AN4*1000/2/S10","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"Z25*Y19","v":0},null,null,"Mz =",{"$f":"T25","v":0},"Nm",{"$f":"AD4","v":50},{"$f":"Z28/AB28","v":{"v":0,"d":"0%"}},null,{"v":0,"d":"0.0"},{"$f":"Z28/AN4*1000/4/S10","v":{"v":0,"d":"0.0"}}]
[]
[{"$nulls":27},"Totally",{"$f":"SUM(AC24:AC29)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(AE23:AE29)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(AF23:AF29)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":20},"Totally",{"$f":"SUM(V23:V30)","v":{"v":0,"d":"0.0"}},"N"]
[]
[]
[{"$nulls":16},"Horizontal mounting, 2 units, carriage at top",{"$nulls":13},"Radial F","Axial F"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
[{"$nulls":16},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},null,null,"Fx =",{"$f":"C41+C46/D20*1000+(C47+AJ4*2)*C51+V45+AM4*2*S10+V38/D20*1000","v":{"v":33.8,"d":"34"}},"N",{"$f":"2*AI4","v":1170},{"$nulls":5},{"$f":"C41+V45","v":{"v":0,"d":"0.0"}},{"$f":"C41+(C47+AJ4*2*S10)*C51+V45+V38/D20*1000+2*U126*G17/1000*2*C51","v":{"v":2.3368,"d":"2"}}]
[{"$nulls":16},"My =",{"$f":"C47*10*M47/1000","v":0},{"$f":"C47*C51*M49/1000","v":0},{"$f":"Y10*R38+S38+C45","v":0},"Nm",{"$f":"T38/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42","v":0},"N",{"$f":"Z4*1","v":415},{"$f":"Z38/AB38","v":{"v":0,"d":"0%"}},null,0,{"$f":"Z38/4/S10","v":0}]
[{"$nulls":16},"Mz =",0,{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R39+S39+C46","v":0},"Nm",{"v":0,"d":"0.0"},null,null,"Fz =",{"$f":"C43+C47*10*Y10+C44/D20*1000*2","v":0},"N",{"$f":"AA4*2","v":1460},{"$f":"Z39/AB39","v":{"v":0,"d":"0%"}},null,{"$f":"(C43/2+C47*10*(D20/2+M48)/D20+C44/D20*1000)/4/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":24},"Mx =",{"$f":"T37","v":0},"Nm",null,null,"Anser att Mx blir ett kraftpar som ökar Fz",{"$nulls":33}," Please note:"]
[null,"Fx =",0,"N",{"$nulls":3},{"$f":"IF(T15=2,\" \",\"Orientation of carriage\")","v":"Orientation of carriage"},{"$nulls":8},"Fy =",{"$nulls":4},{"$f":"C42*Y19","v":0},null,null,"My =",{"$f":"T38","v":0},"Nm",{"$f":"AC4*2","v":174},{"$f":"Z41/AB41","v":{"v":0,"d":"0%"}},null,{"$f":"(Z41+C47*C50*BF4/1000)/AN4*1000/2/2/S10","v":0},{"$nulls":32}," Fx, Fy, Fz, Mx, My and Mz are external forces and torques and "]
[null,"Fy =",0,"N",{"$nulls":12},"Fz =",{"$nulls":4},{"$f":"(C47*10+C42+C44/D20*1000+T38/AN4*1000)*Y19","v":{"v":0,"d":"0.0"}},null,null,"Mz =",{"$f":"T39","v":0},"Nm",null,null,"Anser att Mz blir ett kraftpar som ökar Fx",{"$nulls":33}," are not connected with or caused by \"Total mass to move\""]
[null,"Fz =",0,"N"]
[null,"Mx =",0,"Nm",{"$nulls":23},"Totally",{"$f":"SUM(AC38:AC43)","v":{"v":0,"d":"0%"}},null,{"$f":"AE41+AE39","v":{"v":0,"d":"0.0"}},{"$f":"AF38","v":0}]
[null,"My =",0,"Nm",{"$nulls":16},"Totally",{"$f":"SUM(V37:V44)","v":{"v":0,"d":"0.0"}},"N"]
[null,"Mz =",0,"Nm",{"$nulls":8},"ABS"]
[null,"Total mass to move",0,"kg     in location from top of carriage",{"$nulls":3},"Lx =",0,"mm",null,null,{"$f":"ABS(I47)","v":0},{"$nulls":3},"Horizontal mounting, single unit, carriage sideway",{"$nulls":13},"Radial F","Axial F"]
["Will this mass be carried by the carriage/carriages?",{"$nulls":6},"Ly =",0,"mm",null,null,{"$f":"ABS(I48)","v":0},{"$nulls":3},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max"]
[{"$nulls":7},"Lz =",0,"mm",null,null,0,{"$nulls":4},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
[null,"Speed",1,"m/s",{"$f":"IF(C50>AG4,\"Too high speed\",\" \")","v":" "},{"$nulls":11},"Mx =",{"$f":"C47*10*M49/1000","v":0},0,{"$f":"Y10*R50+C44","v":0},"Nm",{"$f":"T50/AO4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fx =",{"$f":"C41+(C47+AJ4)*C51+AM4*S10+V58","v":{"v":16.9,"d":"17"}},"N",{"$f":"AI4","v":585},{"$nulls":5},{"$f":"C41+V58","v":{"v":0,"d":"0.0"}},{"$f":"Z50+U126*2*G17/1000*C51","v":{"v":17.1684,"d":"17"}}]
[null,"Acceleration",1,"m/s²",{"$f":"IF(C51>40,\"Too high acceleration\",\" \")","v":" "},{"$nulls":11},"My =",0,{"$f":"C47*C51*M49/1000","v":0},{"$f":"S51+C45","v":0},"Nm",{"$f":"T51/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42+Y10*C47*10","v":0},"N",{"$f":"Z4","v":415},{"$f":"Z51/AB51","v":{"v":0,"d":"0%"}},null,null,{"$f":"Z51/4/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":16},"Mz =",{"$f":"C47*10*M47/1000","v":0},{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R52+S52+C46","v":0},"Nm",{"$f":"T52/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fz =",{"$f":"C43","v":0},"N",{"$f":"AA4","v":730},{"$f":"Z52/AB52","v":{"v":0,"d":"0%"}},null,{"$f":"Z52/4/S10","v":{"v":0,"d":"0.0"}}]
["Move profile over",null,1500,"mm stroke",null,{"$f":"IF(C53>C17,\"This is longer than stroke of unit !\",\" \")","v":" "},{"$nulls":18},"Mx =",{"$f":"T50","v":0},"Nm",{"$f":"AB4","v":16},{"$f":"Z53/AB53","v":{"v":0,"d":"0%"}},null,{"$f":"(Z53+C47*10*BF4/1000)/AO4*1000/2/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z51*Y19","v":0},null,null,"My =",{"$f":"T51","v":0},"Nm",{"$f":"AC4","v":87},{"$f":"Z54/AB54","v":{"v":0,"d":"0%"}},null,{"$f":"(Z54+C47*C50*BF4/1000)/AN4*1000/2/S10","v":{"v":0,"d":"0.0"}}]
["Time to move one direction",{"$nulls":15},"Fz =",{"$nulls":4},{"$f":"C43*Y19","v":0},null,null,"Mz =",{"$f":"T52","v":0},"Nm",{"$f":"AD4","v":50},{"$f":"Z55/AB55","v":{"v":0,"d":"0%"}},null,null,{"$f":"Z55/AN4*1000/2/S10","v":{"v":0,"d":"0.0"}}]
[null,null,{"$f":"Blad2!C14","v":{"v":2.5,"d":"2.50"}},"sec"]
[{"$nulls":27},"Totally",{"$f":"SUM(AC51:AC56)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(AE52:AE56)","v":{"v":0,"d":"0.0"}},{"$f":"AF51+AF55","v":{"v":0,"d":"0.0"}}]
[{"$f":"Blad2!A17","v":" "},{"$nulls":19},"Totally",{"$f":"SUM(V50:V57)","v":{"v":0,"d":"0.0"}},"N"]
[{"$f":"Blad2!A18","v":" "},null,{"$f":"Blad2!C18","v":" "},{"$f":"Blad2!D18","v":" "}]
[{"$nulls":16},"Horizontal mounting, two units, carriages sideway",{"$nulls":13},"Radial F","Axial F"]
[{"$nulls":16},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max"]
[{"$nulls":17},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
[{"$nulls":16},"Mx =",0,0,0,"Nm",{"v":0,"d":"0.0"},null,null,"Fx =",{"$f":"C41+V71+T65/D20*1000+(C47+AJ4*2*S10)*C51","v":{"v":1.8,"d":"2"}},"N",{"$f":"AI4*2","v":1170},{"$nulls":5},{"$f":"C41+V71","v":{"v":0,"d":"0.0"}},{"$f":"AH63+(C47+AJ4*2*S10)*C51+U126*G17/1000*2*2*C51","v":{"v":2.3368,"d":"2"}},{"$f":"IF(Q10=3,G16,AN4)","v":198}]
[{"$nulls":16},"My =",0,{"$f":"C47*C51*M49/1000","v":0},{"$f":"C45+S64","v":0},"Nm",{"$f":"T64/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42+C47*10*Y10","v":0},"N",{"$f":"Z4","v":415},{"$f":"Z64/AB64","v":{"v":0,"d":"0%"}},null,0,{"$f":"Z64/4/S10+Z68/AJ63*1000/2/S10","v":0}]
[{"$nulls":16},"Mz =",{"$f":"C47*10*M47/1000","v":0},{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R65+S65+C46","v":0},"Nm",{"v":0,"d":"0.0"},null,null,"Fz =",{"$f":"C43+Y10*C47*10*M49/1000/D20*1000+C44/D20*1000","v":0},"N",{"$f":"AA4*2","v":1460},{"$f":"Z65/AB65","v":{"v":0,"d":"0%"}},null,{"$f":"(Z65+C47*10*BF4/D20)/4/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":24},"Mx =",0,"Nm",{"$f":"AC17","v":0},{"v":0,"d":"0%"},"Anser att Mx blir ett kraftpar som ökar Fz"]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"Z64*Y19","v":0},null,null,"My =",{"$f":"T64","v":0},"Nm",{"$f":"AC4*2","v":174},{"$f":"Z67/AB67","v":{"v":0,"d":"0%"}},null,{"$f":"(Z67+C47*C50*BF4/1000)/AN4/4/S10*1000","v":{"v":0,"d":"0.0"}}]
[{"$nulls":16},"Fz =",{"$nulls":4},{"$f":"(Y10*C47*10*M49/1000/D20*1000+C43)*Y19","v":0},null,null,"Mz =",{"$f":"T65","v":0},"Nm",{"$f":"AE17","v":0},{"v":0,"d":"0%"},"Anser att Mz blir ett kraftpar som ökar Fx"]
[{"$f":"R100","v":"Horizontal mounting, single unit, carriage sideway"}]
[{"$nulls":27},"Totally",{"$f":"SUM(AC64:AC69)","v":{"v":0,"d":"0%"}},null,{"$f":"AE65+AE67","v":{"v":0,"d":"0.0"}},{"$f":"AF64","v":0}]
[null,"Result:",null,"Allowed",{"$nulls":16},"Totally",{"$f":"SUM(V63:V70)","v":{"v":0,"d":"0.0"}},"N"]
["Fx =",{"$f":"X100","v":{"v":16.9,"d":"17"}},"N",{"$f":"Y100","v":585},"N",{"$f":"IF(B72>D72,\"Too much !\",\" \")","v":" "}]
["Fy =",{"$f":"Z100","v":0},"N",{"$f":"AA100","v":415},"N"," ",{"$nulls":10},"Vertical mounting, single unit",{"$nulls":13},"Radial F","Axial F"]
["Fz =",{"$f":"AB100","v":0},"N",{"$f":"AC100","v":730},"N"," ",{"$nulls":10},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max"]
["Mx =",{"$f":"AD100","v":0},"Nm",{"$f":"AE100","v":16},"Nm"," ",{"$nulls":11},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
["My =",{"$f":"AF100","v":0},"Nm",{"$f":"AG100","v":87},"Nm"," ",{"$nulls":10},"Mx =",0,0,{"$f":"C44","v":0},"Nm",{"$f":"T76/AO4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fx =",{"$f":"C41+(C47+AJ4)*C51+AM4+V84+C47*10","v":{"v":16.9,"d":"17"}},"N",{"$f":"AI4","v":585},{"$nulls":5},{"$f":"C41+V84+AM4*S10+C47*10","v":16},{"$f":"AH76+(AJ4*S10+C47)*C51+U126*G17*2/1000*C51","v":{"v":17.1684,"d":"17"}}]
["Mz =",{"$f":"AH100","v":0},"Nm",{"$f":"AI100","v":50},"Nm"," ",{"$nulls":10},"My =",{"$f":"C47*10*M49/1000","v":0},{"$f":"C47*C51*M49/1000","v":0},{"$f":"Y10*R77+S77+C45","v":0},"Nm",{"$f":"T77/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42","v":0},"N",{"$f":"Z4","v":415},{"$f":"Z77/AB77","v":{"v":0,"d":"0%"}},null,null,{"$f":"Z77/4/S10","v":0}]
[{"$nulls":5},"Total load combined all directions",{"$f":"AJ100","v":{"v":0,"d":"0%"}},{"$nulls":9},"Mz =",{"$f":"C47*10*M48/1000","v":0},{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R78+S78+C46","v":0},"Nm",{"$f":"T78/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fz =",{"$f":"C43","v":0},"N",{"$f":"AA4","v":730},{"$f":"Z78/AB78","v":{"v":0,"d":"0%"}},null,{"$f":"Z78/4/S10","v":0}]
[null,{"$f":"IF(AJ100>1,\"The total load is too much ! Select bigger unit or another configuration.\",IF(B72>D72,\"The axial force is too much ! Select bigger unit or another configuration.\",\" \"))","v":" "},{"$nulls":22},"Mx =",{"$f":"T76","v":0},"Nm",{"$f":"AB4","v":16},{"$f":"Z79/AB79","v":{"v":0,"d":"0%"}},null,{"$f":"Z79/AO4*1000/2/S10","v":{"v":0,"d":"0.0"}}]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"C42*Y19","v":0},null,null,"My =",{"$f":"T77","v":0},"Nm",{"$f":"AC4","v":87},{"$f":"Z80/AB80","v":{"v":0,"d":"0%"}},null,{"$f":"(Z80+C47*C50*BF4/1000)/AN4*1000/2/S10","v":{"v":0,"d":"0.0"}}]
[null,"Designation:",{"$f":"CONCATENATE(AP4,R109,S109,T109,U109,\"x\",W10,IF(Q10<3,\"-0000\",W110))","v":"WH05Z120-02000-02440xN-0000"},{"$nulls":13},"Fz =",{"$nulls":4},{"$f":"C43*Y19","v":0},null,null,"Mz =",{"$f":"T78","v":0},"Nm",{"$f":"AD4","v":50},{"$f":"Z81/AB81","v":{"v":0,"d":"0%"}},null,null,{"$f":"Z81/AN4/4*1000/S10","v":{"v":0,"d":"0.0"}}]
[]
[null,"Calculation of lifetime",{"$nulls":25},"Totally",{"$f":"SUM(AC77:AC82)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(AE78:AE82)","v":{"v":0,"d":"0.0"}},{"$f":"AF81+AF77","v":{"v":0,"d":"0.0"}}]
[{"$nulls":20},"Totally",{"$f":"SUM(V76:V83)","v":{"v":0,"d":"0.0"}},"N"]
[null,null,"Average load factor fm",1]
[null,null,"Track roller / wheel",{"$f":"IF(AG121<100000,AG121,\"> 100 000\")","v":{"v":7464.097179310604,"d":"7,464"}},"h",{"$f":"D86*3600*$C$50/1000","v":{"v":26870.74984551817,"d":"26,871"}},"km",{"$nulls":9},"Vertical  mounting, two units",{"$nulls":13},"Radial F","Axial F"]
[null,null,"Ball bearing drive station",{"$f":"IF(AG116<100000,AG116,\"> 100 000\")","v":{"v":30198.07726344931,"d":"30,198"}},"h",{"$f":"D87*3600*$C$50/1000","v":{"v":108713.07814841752,"d":"108,713"}},"km",{"$nulls":9},"Load torques caused by off center load",{"$nulls":10},"Max",null,null,"at one wheel max"]
[null,null,"Ball bearing tension station",{"$f":"IF(AG117<100000,AG117,\"> 100 000\")","v":{"v":4341.874060138814,"d":"4,342"}},"h",{"v":15630.74661649973,"d":"15,631"},"km",{"$nulls":10},"Static","Dynamic","Totally",null,"Friction",null,null,"Totally",null,null,"allowed","% of max",null,"N","N"]
[{"$nulls":16},"Mx =",0,0,0,"Nm",{"$f":"C44/D20*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fx =",{"$f":"C41+C47*10+2*AJ4+2*AM4+T91/D20*1000+(C47+2*AJ4)*C51","v":{"v":35.599999999999994,"d":"36"}},"N",{"$f":"AI4*2","v":1170},{"$nulls":5},{"$f":"C41+C47*10+V97+AJ4*10*2*S10","v":18},{"$f":"AH89+(C47+AJ4*2*S10+U126*G17/1000*2*2)*C51","v":{"v":20.3368,"d":"20"}}]
[null,null,"number of cycles per minute",1,null,"Duty cycle",{"$f":"D90*2*C56/60","v":{"v":0.08333333333333333,"d":"8%"}},{"$f":"IF(G90>1,\"Not possible !\",\" \")","v":" "},{"$nulls":8},"My =",{"$f":"C47*M49*10/1000","v":0},{"$f":"C47*C51*M49/1000","v":0},{"$f":"Y10*R90+S90+C45","v":0},"Nm",{"$f":"T90/AN4*1000*Y19","v":{"v":0,"d":"0.0"}},null,null,"Fy =",{"$f":"C42","v":0},"N",{"$f":"Z4","v":415},{"$f":"Z90/AB90","v":{"v":0,"d":"0%"}},null,null,{"$f":"Z90/S10/4","v":0}]
[null,null,"Working hours per day",8,{"$nulls":12},"Mz =",{"$f":"C47*10*M48/1000","v":0},{"$f":"C47*C51*M48/1000","v":0},{"$f":"Y10*R91+S91+C46","v":0},"Nm",{"v":0,"d":"0.0"},null,null,"Fz =",{"$f":"C43+C44/D20*1000*2","v":0},"N",{"$f":"AA4*2","v":1460},{"$f":"Z91/AB91","v":{"v":0,"d":"0%"}},null,{"$f":"Z91/8/S10","v":{"v":0,"d":"0.0"}}]
[null,null,"Working days per year",224,{"$nulls":20},"Mx =",0,"Nm",{"$f":"AB43","v":0},{"v":0,"d":"0%"},"Anser att Mx blir ett kraftpar som ökar Fz"]
[{"$nulls":16},"Fy =",{"$nulls":4},{"$f":"C42*Y19","v":0},null,null,"My =",{"$f":"T90","v":0},"Nm",{"$f":"AC4*2","v":174},{"$f":"Z93/AB93","v":{"v":0,"d":"0%"}},null,{"$f":"(Z93+C47*C50*BF4/1000)/AN4*1000/4/S10","v":{"v":0,"d":"0.0"}}]
[null,null,"Lifetime ",{"$f":"IF(F86*10^6/C53/2/D90/60/D91/D92>50,\"> 50\",F86*10^6/C53/2/D90/60/D91/D92)","v":"> 50"},"Years","Track roller / wheel",{"$nulls":10},"Fz =",{"$nulls":4},{"$f":"Z91*Y19","v":0},null,null,"Mz =",{"$f":"T91","v":0},"Nm",{"$f":"AD4","v":50},{"v":0,"d":"0%"},"Anser att Mz blir ett kraftpar som ökar Fx"]
[{"$nulls":3},{"$f":"IF(AK116>50,\"> 50\",AK116)","v":"> 50"},"Years","Ball bearing drive station"]
[{"$nulls":3},{"$f":"IF(AK117>50,\"> 50\",AK117)","v":{"v":48.45841584976355,"d":"48.5"}},"Years","Ball bearing tension station",{"$nulls":21},"Totally",{"$f":"SUM(AC90:AC95)","v":{"v":0,"d":"0%"}},null,{"$f":"AE91+AE93","v":{"v":0,"d":"0.0"}},{"$f":"AF90","v":0}]
[{"$nulls":20},"Totally",{"$f":"SUM(V89:V96)","v":{"v":0,"d":"0.0"}},"N",{"$nulls":15},"Total Fx  at const speed","Total Fx during acc"]
[{"$nulls":36},"Each wheel"]
[null,null,"Idle torque at no load",{"$f":"N133","v":{"v":1.8814623854899981,"d":"1.88"}},"Nm and",{"$f":"R113","v":{"v":499.96317201642506,"d":"500"}},"rpm at",{"$f":"C50","v":1},"m/s",{"$nulls":14},"Fx",null,"Fy",null,"Fz",null,"Mx",null,"My",null,"Mz",null,"Total","F rad","F axial"]
[{"$nulls":17},{"$f":"VLOOKUP($AA$15,$Q$101:R106,2)","v":"Horizontal mounting, single unit, carriage sideway"},{"$f":"VLOOKUP($AA$15,$Q$101:S106,2)","v":"Horizontal mounting, single unit, carriage sideway"},{"$nulls":4},{"$f":"VLOOKUP($AA$15,$Q$101:X106,8)","v":{"v":16.9,"d":"17"}},{"$f":"VLOOKUP($AA$15,$Q$101:Y106,9)","v":585},{"$f":"VLOOKUP($AA$15,$Q$101:Z106,10)","v":0},{"$f":"VLOOKUP($AA$15,$Q$101:AA106,11)","v":415},{"$f":"VLOOKUP($AA$15,$Q$101:AB106,12)","v":0},{"$f":"VLOOKUP($AA$15,$Q$101:AC106,13)","v":730},{"$f":"VLOOKUP($AA$15,$Q$101:AD106,14)","v":0},{"$f":"VLOOKUP($AA$15,$Q$101:AE106,15)","v":16},{"$f":"VLOOKUP($AA$15,$Q$101:AF106,16)","v":0},{"$f":"VLOOKUP($AA$15,$Q$101:AG106,17)","v":87},{"$f":"VLOOKUP($AA$15,$Q$101:AH106,18)","v":0},{"$f":"VLOOKUP($AA$15,$Q$101:AI106,19)","v":50},{"$f":"VLOOKUP($AA$15,$Q$101:AJ106,20)","v":{"v":0,"d":"0%"}},{"$f":"VLOOKUP($AA$15,$Q$101:AK106,21)","v":{"v":200,"d":"200.0"}},{"$f":"VLOOKUP($AA$15,$Q$101:AL106,22)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$15,$Q$101:AM106,23)","v":{"v":0,"d":"0.0"}},{"$f":"VLOOKUP($AA$15,$Q$101:AN106,24)","v":{"v":17.1684,"d":"17.2"}}]
[null,null,"Drive torque at constant speed",{"$f":"P142","v":{"v":1.8814623854899981,"d":"1.88"}},"Nm and",{"$f":"D101*R113/9.55","v":{"v":98.49862851090778,"d":"98"}},"W",{"$nulls":9},1,"Horizontal mounting, single unit, carriage at top",{"$nulls":5},{"$f":"Z23","v":{"v":16.9,"d":"17"}},{"$f":"AB23","v":585},{"$f":"Z24","v":0},{"$f":"AB24","v":415},{"$f":"Z25","v":0},{"$f":"AB25","v":730},{"$f":"Z26","v":0},{"$f":"AB26","v":16},{"$f":"Z27","v":0},{"$f":"AB27","v":87},{"$f":"Z28","v":0},{"$f":"AB28","v":50},{"$f":"AC30","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE30","v":{"v":200,"d":"200.0"}},{"$f":"AF30","v":{"v":0,"d":"0.0"}},{"$f":"AH23","v":{"v":0,"d":"0.0"}},{"$f":"AI23","v":{"v":1.1684,"d":"1.2"}}]
[null,null,"Drive torque during acc",{"$f":"P143","v":{"v":2.209378825489998,"d":"2.21"}},"Nm and",{"$f":"D102*R113/9.55","v":{"v":115.66576395580135,"d":"116"}},"W",{"$nulls":9},2,"Horizontal mounting, 2 units, carriage at top",{"$nulls":5},{"$f":"Z37","v":{"v":33.8,"d":"34"}},{"$f":"AB37","v":1170},{"$f":"Z38","v":0},{"$f":"AB38","v":415},{"$f":"Z39","v":0},{"$f":"AB39","v":1460},{"$f":"IF(Z40=0,\" - \",Z40)","v":" - "},{"$f":"IF(AB40=0,\" - \",AB40)","v":" - "},{"$f":"Z41","v":0},{"$f":"AB41","v":174},{"$f":"Z42","v":0},{"$f":"IF(AB42=0,\" - \",AB42)","v":" - "},{"$f":"AC44","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE44","v":{"v":200,"d":"200.0"}},{"$f":"AF44","v":0},{"$f":"AH37","v":{"v":0,"d":"0.0"}},{"$f":"AI37","v":{"v":2.3368,"d":"2.3"}}]
[null,null,"System inertia",{"$f":"S153","v":4.62932547145129E-4},"kg m² (excluding gear, motor etc)",{"$nulls":11},3,"Horizontal mounting, single unit, carriage sideway",{"$nulls":5},{"$f":"Z50","v":{"v":16.9,"d":"17"}},{"$f":"AB50","v":585},{"$f":"Z51","v":0},{"$f":"AB51","v":415},{"$f":"Z52","v":0},{"$f":"AB52","v":730},{"$f":"Z53","v":0},{"$f":"AB53","v":16},{"$f":"Z54","v":0},{"$f":"AB54","v":87},{"$f":"Z55","v":0},{"$f":"AB55","v":50},{"$f":"AC57","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE57","v":{"v":200,"d":"200.0"}},{"$f":"AF57","v":{"v":0,"d":"0.0"}},{"$f":"AH50","v":{"v":0,"d":"0.0"}},{"$f":"AI50","v":{"v":17.1684,"d":"17.2"}}]
[null,{"$f":"IF(AND(Q15=1,P143>AC126),\"Too high drive torque\",IF(AND(Q15=2,P143>2*AC126),\"Too high drive torque\",IF(AND(Q15=2,P143>AC126),\"Central mounting of motor/gear required\",\" \")))","v":" "},{"$nulls":14},4,"Horizontal mounting, two units, carriages sideway",{"$nulls":5},{"$f":"Z63","v":{"v":1.8,"d":"2"}},{"$f":"AB63","v":1170},{"$f":"Z64","v":0},{"$f":"AB64","v":415},{"$f":"Z65","v":0},{"$f":"AB65","v":1460},{"$f":"IF(Z66=0,\" - \",Z66)","v":" - "},{"$f":"IF(AB66=0,\" - \",AB66)","v":" - "},{"$f":"Z67","v":0},{"$f":"AB67","v":174},{"$f":"Z68","v":0},{"$f":"IF(AB68=0,\" - \",AB68)","v":" - "},{"$f":"AC70","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE70","v":{"v":200,"d":"200.0"}},{"$f":"AF70","v":0},{"$f":"AH63","v":{"v":0,"d":"0.0"}},{"$f":"AI63","v":{"v":2.3368,"d":"2.3"}}]
[{"$nulls":16},5,"Vertical mounting, single unit",{"$nulls":5},{"$f":"Z76","v":{"v":16.9,"d":"17"}},{"$f":"AB76","v":585},{"$f":"Z77","v":0},{"$f":"AB77","v":415},{"$f":"Z78","v":0},{"$f":"AB78","v":730},{"$f":"Z79","v":0},{"$f":"AB79","v":16},{"$f":"Z80","v":0},{"$f":"AB80","v":87},{"$f":"Z81","v":0},{"$f":"AB81","v":50},{"$f":"AC83","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE83","v":{"v":200,"d":"200.0"}},{"$f":"AF83","v":{"v":0,"d":"0.0"}},{"$f":"AH76","v":16},{"$f":"AI76","v":{"v":17.1684,"d":"17.2"}}]
[null,"Gear / Motor",{"$nulls":14},6,"Vertical  mounting, two units",{"$nulls":5},{"$f":"Z89","v":{"v":35.599999999999994,"d":"36"}},{"$f":"AB89","v":1170},{"$f":"Z90","v":0},{"$f":"AB90","v":415},{"$f":"Z91","v":0},{"$f":"AB91","v":1460},{"$f":"IF(Z92=0,\" - \",Z92)","v":" - "},{"$f":"IF(AB92=0,\" - \",AB92)","v":" - "},{"$f":"Z93","v":0},{"$f":"AB93","v":174},{"$f":"Z94","v":0},{"$f":"AB94","v":50},{"$f":"AC96","v":{"v":0,"d":"0%"}},{"$f":"AQ4+AE96","v":{"v":200,"d":"200.0"}},{"$f":"AF96","v":0},{"$f":"AH89","v":18},{"$f":"AI89","v":{"v":20.3368,"d":"20.3"}}]
[]
[]
[null,null,{"$f":"IF($L$250=2,\"Ratio\",\" \")","v":"Ratio"},4,{"$nulls":13},{"$f":"IF(S109<1000,\"-00\",IF(S109<10000,\"-0\",\"-\"))","v":"-0"},{"$f":"C17","v":2000},{"$f":"IF(U109<1000,\"-00\",IF(U109<10000,\"-0\",\"-\"))","v":"-0"},{"$f":"G17","v":2440},{"$f":"IF(W109<1000,\"-0\",\"-\")","v":"-0"},{"$f":"G16","v":500}]
[null,null,{"$f":"IF($L$250=2,\"Effiency factor\",\" \")","v":"Effiency factor"},{"v":0.9,"d":"90%"},{"$nulls":18},{"$f":"CONCATENATE(V109,W109)","v":"-0500"}]
[null,null,{"$f":"IF($L$250=2,\"Idle torque\",\" \")","v":"Idle torque"},0.1,{"$f":"IF($L$250=2,\"Nm\",\" \")","v":"Nm"}]
[null,null,{"$f":"IF($L$250=2,\"Inertia\",\" \")","v":"Inertia"},5e-05,{"$f":"IF($L$250=2,\"kg m²\",\" \")","v":"kg m²"},{"$nulls":11},"rpm wheels",{"$f":"$C$50*1000/AS4/PI()*60","v":{"v":1208.771719685281,"d":"1209"}}]
[{"$nulls":16},"rpm drive wheel",{"$f":"$C$50*1000/AT4/PI()*60","v":{"v":499.96317201642506,"d":"500"}},null,"motor speed",{"$f":"R113*IF(L250=1,1,D109)","v":1999.8526880657002}]
[{"$nulls":16},"rpm tension wheel",{"$f":"$C$50*1000/AU4/PI()*60","v":{"v":499.96317201642506,"d":"500"}}]
[]
[{"$nulls":16},"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*AV4+X100)/2","v":{"v":723.4500000000002,"d":"723"}},"N / bearing",null,"Lifetime ball bearing",null,{"$f":"(AX4/AB116)^3*10^6/R113/60","v":{"v":30198.07726344931,"d":"30198"}},"h",{"$f":"AG116*3600*$C$50/1000","v":{"v":108713.07814841752,"d":"108,713"}},"km",{"$f":"AI116*1000/$C$53/2*1000/$D$90/60/$D$91/$D$92","v":337.0321123152825}]
[null,null,{"$f":"IF(OR(L254=2,L254=3),\"Nominal torque\",IF(L254=4,\"Holding torque\",\" \"))","v":"Nominal torque"},{"$f":"IF(L254=2,Q194,IF(L254=3,R165,IF(L254=4,O222,\" \")))","v":15.6},{"$f":"IF(L254=2,\"Nm\",IF(L254=3,\"Nm at max speed\",IF(L254=4,\"Nm\",\" \")))","v":"Nm at max speed"},{"$nulls":11},"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*AV4+2*X100)/2","v":{"v":731.9000000000001,"d":"732"}},"N / bearing",null,"Lifetime ball bearing",null,{"$f":"(AZ4/AB117)^3*10^6/R114/60","v":{"v":4341.874060138814,"d":"4342"}},"h",{"$f":"AG117*3600*$C$50/1000","v":{"v":15630.74661649973,"d":"15,631"}},"km",{"$f":"AI117*1000/$C$53/2*1000/$D$90/60/$D$91/$D$92","v":48.45841584976355}]
[null,null,{"$f":"IF($L$254=2,\"Nominal speed\",IF($L$254=3,\"Peak torque\",\" \"))","v":"Peak torque"},{"$f":"IF(L254=2,O194,IF(L254=3,S165,\" \"))","v":54.1},{"$f":"IF($L$254=2,\"rpm\",IF($L$254=3,\"Nm\",\" \"))","v":"Nm"}]
[null,null,{"$f":"IF($L$254=2,\"Nominal power\",IF($L$254=3,\"Max speed\",\" \"))","v":"Max speed"},{"$f":"IF(L254=2,P194,IF(L254=3,O165,\" \"))","v":3000},{"$f":"IF($L$254=2,\"kW\",IF($L$254=3,\"rpm\",\" \"))","v":"rpm"},{"$nulls":11},"Max radial load wheel  Fr",null,null,{"$f":"AK100","v":{"v":200,"d":"200.0"}},null,"Calculation equivalent load  P = x*Fr + y*Fa",{"$nulls":4},"x = ",{"$f":"IF(T119>=T120,BB4,BD4)","v":1}]
[null,null,{"$f":"IF(L254=3,\"Nominal power\",\" \")","v":"Nominal power"},{"$f":"IF(L254=3,P165,\" \")","v":4.9},{"$f":"IF(L254=3,\"kW\",\" \")","v":"kW"},{"$nulls":11},"Max axial load wheel    Fa",null,null,{"$f":"AL100","v":{"v":0,"d":"0.0"}},{"$nulls":6},"y = ",{"$f":"IF(T119>=T120,BC4,BE4)","v":3.1}]
[null,null,{"$f":"IF(L254=5,\"Customer motor data:\",\" \")","v":" "},"Supplier, torque, power, rpm etc",{"$nulls":22},"P = ",{"$f":"AB119*T119+AB120*T120","v":200},null,null,"Lifetime wheel",null,{"$f":"(AR4/AB121/D85)^3*10^6/R112/60","v":{"v":7464.097179310604,"d":"7464"}},"h"]
[]
[]
[{"$nulls":20},"Belt weight",null,"Pulley width",null,"VWZ shaft / coupling",{"$nulls":3},"Max"]
[null,null,{"$f":"IF(L254=5,\"Motor inertia:\",\" \")","v":" "},0.0003,{"$f":"IF(L254=5,\"kg m²\",\" \")","v":" "},{"$nulls":9},"Idle torque",{"$nulls":5},"kg/m","kg","drive mm","tension",{"$nulls":3},"kg m²","torque"]
[{"$nulls":12},{"$f":"Q4","v":1},{"$f":"VLOOKUP($M$126,$M$127:T129,2)","v":"WH50"},{"$f":"VLOOKUP($M$126,$M$127:U129,3)","v":150},{"$f":"VLOOKUP($M$126,$M$127:U129,4)","v":1500},{"$f":"VLOOKUP($M$126,$M$127:U129,5)","v":3250},{"$f":"VLOOKUP($M$126,$M$127:V129,6)","v":1.7},{"$f":"VLOOKUP($M$126,$M$127:W129,7)","v":2.4},{"$f":"VLOOKUP($M$126,$M$127:X129,8)","v":3.8},{"$f":"VLOOKUP($M$126,$M$127:Y129,9)","v":0.055},{"$f":"U126*G17/1000*2","v":0.26839999999999997},{"$f":"VLOOKUP($M$126,$M$127:AA129,11)","v":45},{"$f":"VLOOKUP($M$126,$M$127:AB129,12)","v":20},{"$f":"VLOOKUP($M$126,$M$127:AC129,13)","v":0.0008},{"$f":"VLOOKUP($M$126,$M$127:AD129,14)","v":0.00024},{"$f":"VLOOKUP($M$126,$M$127:AE129,15)","v":"GS14"},{"$f":"VLOOKUP($M$126,$M$127:AF129,16)","v":6.5e-06},{"$f":"VLOOKUP($M$126,$M$127:AG129,17)","v":17}]
[null,"Required motor data",{"$nulls":10},1,"WH50",150,1500,3250,1.7,2.4,3.8,0.055,null,45,20,0.0008,0.00024,"GS14",{"$f":"0.0000065","v":6.5e-06},17]
[null,null,"Torque at constant speed",{"$f":"V142","v":{"v":0.6226284404138883,"d":"0.62"}},"Nm",{"$nulls":7},2,"WH80",150,1500,3000,2.4,3.5,5,0.21,null,70,37,0.0008,0.00046,"GS19",1.21E-4,100]
[null,null," Torque during acceleration",{"$f":"V143","v":{"v":1.3097353188218288,"d":"1.31"}},"Nm",{"$nulls":7},3,"WH120",150,1500,2308,4.85,7,10,0.34,null,110,56,0.0058,0.006,"GS24",4.66E-4,200]
[null,null,"Power at constant speed",{"$f":"D128*D132/9550","v":{"v":0.1303837864112952,"d":"0.13"}},"kW"]
[null,null,"Power during acceleration",{"$f":"D129*D132/9550","v":{"v":0.27426991602098655,"d":"0.27"}},"kW",{"$f":"D132/D118*50","v":{"v":1848.292687676248,"d":"1,848"}},{"$f":"IF(L254=2,\"Hz\",\" \")","v":" "},{"$nulls":4},"Idle torque Nm",null,{"$f":"IF(R113<=150,R126,IF(AND(R113>150,R113<=1500),R126+(R113-150)/1350*(S126-R126),S126+(R113-1500)/(Q126-1500)*(T126-S126)))","v":{"v":1.8814623854899981,"d":"1.88"}},"Single unit, single carriage"]
[null,null,"Max speed",{"$f":"U113","v":{"v":1999.8526880657002,"d":"2,000"}},"rpm",{"$nulls":8},{"$f":"(S10-1)*AM4*AT4/2/1000","v":{"v":0,"d":"0.00"}},"additional carriage"]
[null,null,"Inertia balance",{"$f":"R159","v":{"v":1.0247936044364283,"d":"1.0"}},{"$nulls":8},"Totally",{"$f":"(N132+N131)*Q15","v":{"v":1.8814623854899981,"d":"1.88"}},"Nm"]
[]
["Notes:"]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"Drive torque during constant speed",{"$nulls":3},{"$f":"N133+AM100*AT4/2/1000","v":1.8814623854899981},"Nm","Motor torque during costant speed",{"$nulls":3},{"$f":"IF(L250=1,P142/0.99,P142/D109/D110+D111)","v":0.6226284404138883},"Nm",null,"Här är lite frågetecken, eller nej?"]
[{"$nulls":11},"Drive torque during acceleration",{"$nulls":3},{"$f":"N133+AN100*AT4/2/1000","v":2.209378825489998},"Nm","Motor torque duringacceleration",{"$nulls":3},{"$f":"AC152+V142","v":{"v":1.3097353188218288,"d":"1.310"}},"Nm including inertia and losses in gear"]
[]
[{"$nulls":15},{"$f":"P143-P142","v":0.3279164400000001}]
[]
[{"$nulls":26},"Drive ",null,"motor",null,null,"Guide for selection of fm factor"]
[{"$nulls":26},"shaft",null,"shaft",null,null,"fm = 1,0 ; The same load in both directions"]
[{"$nulls":11},"Linear inertia from load, carries and belt:",{"$nulls":4},"m x ( m/min / 2π / rpm ) ^2 =",null,null,{"$f":"(V126+C47+AJ4*S10*Q15)*(C50*60/2/PI()/R113)^2","v":4.262440040000003E-4},"kg m²",{"$nulls":3},"Inertia",null,{"$f":"S153","v":4.62932547145129E-4},"kgm²",{"$f":"IF(L250=1,S153+T154+T156,(S153+T154)/D109^2/D110+T155+T156)","v":0.003282599482440634},"kgm²",null,"fm = 0,89 ; Load forward, 75% load back"]
[{"$nulls":11},"Inertia drive pulley",null," J = m / 2 x R²",{"$nulls":5},{"$f":"PI()*AT4^2/4*W126*2.7/10^6/2*(AT4/2/1000)^2*Q15","v":{"v":2.5399760638935242E-5,"d":"0.000025"}},"kg m²",{"$nulls":3},"Top speed",null,{"$f":"R113","v":{"v":499.96317201642506,"d":"500"}},"rpm",{"$f":"U113","v":{"v":1999.8526880657002,"d":"2000"}},"rpm",null,"fm = 0,81 ; Load forward, 50% load back"]
[{"$nulls":11},"Inertia tension pulley",{"$nulls":7},{"$f":"PI()*AU4^2/4*X126*2.7/10^6/2*(AU4/2/1000)^2*Q15","v":1.1288782506193444E-5},"kg m²",{"$nulls":3},"Acceleration time",null,{"$f":"C50/C51","v":1},"sec",{"$f":"AA151","v":1},"sec",null,"fm = 0,8 ; Load forward, no load back"]
[{"$nulls":11},"Parallel shaft VWZ-",{"$nulls":7},{"$f":"S15*(Y126*D20/1000+2*Z126)","v":0},"kg m²",{"$nulls":5},{"$f":"AA149*3.14*AA150/30/AA151","v":{"v":0.024225018851967033,"d":"0.024"}},"Nm",{"$f":"AC149*3.14*AC150/30/AC151","v":{"v":0.6871068784079405,"d":"0.687"}},"Nm",null,"fm = 0,48 ; Full load 10% of the stroke forward and 20% rest of cycle"]
[{"$nulls":18},{"$f":"SUM(T149:T152)","v":4.62932547145129E-4}]
[{"$nulls":11},"Inertia coupling",{"$nulls":7},{"$f":"AB126","v":6.5e-06}]
[{"$nulls":11},"Inertia gear",{"$nulls":7},{"$f":"IF(L250=2,D112,0)","v":5e-05}]
[{"$nulls":11},"Inertia motor",{"$nulls":7},{"$f":"IF(L254=1,0,IF(L254=2,R194,IF(L254=3,V165,IF(L254=4,P222,IF(L254=5,D125,0)))))","v":0.0032}]
[]
[{"$nulls":12},"Total inertia reduced to motor shaft",{"$nulls":5},{"$f":"(S153+T154)/IF(L250=1,1,D109^2)+T155+T156","v":3.2793395341965707E-3}]
[{"$nulls":12},"Inertia balance",{"$nulls":4},{"$f":"S158/T156","v":1.0247936044364283}]
[]
[]
[{"$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$262,$L$166:M189,M$162)","v":"AKM64L"},{"$f":"VLOOKUP($L$262,$L$166:N189,N162)","v":0},{"$f":"VLOOKUP($L$262,$L$166:O189,O162)","v":3000},{"$f":"VLOOKUP($L$262,$L$166:P189,P162)","v":4.9},{"$f":"VLOOKUP($L$262,$L$166:Q189,Q162)","v":21},{"$f":"VLOOKUP($L$262,$L$166:R189,R162)","v":15.6},{"$f":"VLOOKUP($L$262,$L$166:S189,S162)","v":54.1},{"$f":"VLOOKUP($L$262,$L$166:T189,T162)","v":0.0032},{"$f":"VLOOKUP($L$262,$L$166:U189,U162)","v":6.1e-05},{"$f":"VLOOKUP($L$262,$L$166:V189,V162)","v":0.0032},{"$f":"VLOOKUP($L$262,$L$166:W189,W162)","v":1.66},{"$f":"VLOOKUP($L$262,$L$166:X189,X162)","v":107},{"$f":"VLOOKUP($L$262,$L$166:Y189,Y162)","v":0.71}]
[{"$nulls":11},1,"AKM31C",null,5000,0.52,1.15,1,3.88,3.3e-05,1.2e-06,{"$f":"IF($O$254=2,T166+U166,T166)","v":3.3e-05},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,5.9e-05,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.5e-05,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.1e-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.00015,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.00021,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,2.7E-4,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,0.00034,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,6.2E-4,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,9.1E-4,1.24,79.8,1]
[{"$nulls":11},11,"AKM54K",null,3500,3.68,14.4,10.05,38.4,0.0012,1.7E-5,0.0012,1.5,96.6,1.02]
[{"$nulls":11},12,"AKM62K",null,3500,3.3,12.2,9,30.1,0.0017,6.1e-05,0.0017,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,0.0024,1.71,110,1.09]
[{"$nulls":11},14,"AKM64L",null,3000,4.9,21,15.6,54.1,0.0032,6.1e-05,0.0032,1.66,107,0.71]
[{"$nulls":11},15,"AKM65M",null,2500,5.03,25,19.2,65.2,0.004,6.1e-05,0.004,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$262,$L$195:M218,M$162)","v":"IEC90 with brake 3000 rpm 2,2 kW"},{"$f":"VLOOKUP($L$262,$L$195:N218,N$162)","v":0},{"$f":"VLOOKUP($L$262,$L$195:O218,O$162)","v":2850},{"$f":"VLOOKUP($L$262,$L$195:P218,P$162)","v":2.2},{"$f":"VLOOKUP($L$262,$L$195:Q218,Q$162)","v":7.518843508771932},{"$f":"VLOOKUP($L$262,$L$195:R218,R$162)","v":1.8100000000000002E-3}]
[{"$nulls":11},1,"IEC 63  3000 rpm  0,25 kW",null,2750,0.25,{"$f":"71620*1.36*P195/O195/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+R203","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+R205","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+R207","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$262,$L$223:M246,M$162)","v":"-"},{"$f":"VLOOKUP($L$262,$L$223:N246,N$162)","v":0},{"$f":"VLOOKUP($L$262,$L$223:O246,O$162)","v":"-"},{"$f":"VLOOKUP($L$262,$L$223:P246,P$162)","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},3,null,null,1]
[{"$nulls":11},1,"No motor",null,1,{"$f":"IF($L$254=3,\"Without brake\",\" \")","v":"Without brake"}]
[{"$nulls":11},2,"AC motor",null,2,{"$f":"IF($L$254=3,\"With brake\",\" \")","v":"With brake"}]
[{"$nulls":11},3,"AKM servo motor"]
[{"$nulls":11},4,"Stepper motor"]
[{"$nulls":11},5,"Customer motor"]
[]
[]
[{"$nulls":11},14]
[{"$nulls":11},1,{"$f":"IF($L$254=1,\"-\",IF($L$254=2,M195,IF($L$254=3,M166,IF($L$254=4,M223,\" - \"))))","v":"AKM31C"}]
[{"$nulls":11},2,"AKM32C"]
[{"$nulls":11},3,"AKM33E"]
[{"$nulls":11},4,"AKM41C"]
[{"$nulls":11},5,"AKM42E"]
[{"$nulls":11},6,"AKM43E"]
[{"$nulls":11},7,"AKM44G"]
[{"$nulls":11},8,"AKM51E"]
[{"$nulls":11},9,"AKM52G"]
[{"$nulls":11},10,"AKM53K"]
[{"$nulls":11},11,"AKM54K"]
[{"$nulls":11},12,"AKM62K"]
[{"$nulls":11},13,"AKM63K"]
[{"$nulls":11},14,"AKM64L"]
[{"$nulls":11},15,"AKM65M"]
[{"$nulls":11},16,0]
[{"$nulls":11},17,0]
[{"$nulls":11},18,0]
[{"$nulls":11},19,0]
[{"$nulls":11},20,0]
[{"$nulls":11},21,0]
[{"$nulls":11},22,0]
[{"$nulls":11},23,0]
[{"$nulls":11},24,0]

{"sheet":"Blad2","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"hidden":true}
[]
[null,"Customized profile"]
[]
["Acceleration",null,{"$f":"Calculation!C51","v":1},"m/s2",{"$nulls":4},{"$f":"IF((J8+J10)>H6,1,0)","v":0}]
["Deceleration",null,{"$f":"C4","v":1},"m/s2",{"$nulls":4},{"$f":"IF(I4=1,J5,C7)","v":1},{"$f":"I9*C4","v":1.224744871391589}]
["Distance (stroke)",null,{"$f":"Calculation!C53","v":1500},"mm",{"$nulls":3},{"$f":"C6/1000","v":1.5}]
["Speed",null,{"$f":"Calculation!C50","v":1},"m/s"]
["Distance for acc.",null,{"$f":"1000*H8","v":500},"mm",{"$nulls":3},{"$f":"IF(I4=0,J8,I8)","v":{"v":0.5,"d":"0.500"}},{"$f":"H6*C5/(C5+C4)","v":0.75},{"$f":"C4*J9*J9/2","v":0.5}]
["Time for acc.",null,{"$f":"IF(I4=0,J9,I9)","v":{"v":1,"d":"1.000"}},"s",{"$nulls":4},{"$f":"SQRT(2*I8/C4)","v":1.224744871391589},{"$f":"C7/C4","v":1}]
["Distance for decel.",null,{"$f":"H10*1000","v":500},"mm",{"$nulls":3},{"$f":"IF(I4=0,J10,I10)","v":{"v":0.5,"d":"0.500"}},{"$f":"H6*C4/(C5+C4)","v":0.75},{"$f":"C5*J11*J11/2","v":0.5}]
["Time for decel.",null,{"$f":"IF(I4=0,J11,I11)","v":{"v":1,"d":"1.000"}},"s",{"$nulls":4},{"$f":"SQRT(2*I10/C5)","v":1.224744871391589},{"$f":"C7/C5","v":1},0,{"$f":"H8*1000","v":{"v":500,"d":"500.000"}},{"$f":"L11+H12*1000","v":{"v":1000,"d":"1000.000"}},{"$f":"H6*1000","v":1500}]
["Dist. at const speed",null,{"$f":"H12*1000","v":500},"mm",{"$nulls":3},{"$f":"H6-H8-H10","v":{"v":0.5,"d":"0.500"}},null,{"$f":"IF((H8+H10)>H6,\"Du når ej önskad max hastighet\",\" \")","v":" "},0,{"$f":"I5","v":1},{"$f":"L12","v":1},0]
["Time at const speed",null,{"$f":"H12/C7","v":{"v":0.5,"d":"0.500"}},"s"]
["Cycle time",null,{"$f":"IF(I4=0,J14,I14)","v":{"v":2.5,"d":"2.500"}},"s",{"$nulls":4},{"$f":"I9+I11","v":2.449489742783178},{"$f":"C11+C9+C13","v":{"v":2.5,"d":"2.500"}}]
["Average speed",null,{"$f":"H6/C14","v":{"v":0.6,"d":"0.600"}},"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":" "}]

{"sheet":"Information","index":2,"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"]