{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","sin","Sheet3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":488,"n_cols":57,"rows_kept":488,"cut":false,"hidden":false,"merged":[[391,4,393,4],[399,4,403,4],[33,0,33,3],[57,4,59,4],[61,4,62,4],[67,4,71,4],[72,4,77,4],[404,4,409,4],[410,4,411,4],[57,5,59,5],[61,5,62,5],[67,5,71,5],[72,5,77,5],[78,5,79,5],[385,5,387,5],[388,5,390,5],[391,5,393,5],[399,5,403,5],[404,5,409,5],[410,5,411,5],[78,4,79,4],[385,4,387,4],[388,4,390,4],[404,6,409,6],[57,6,59,6],[61,6,62,6],[67,6,71,6],[72,6,77,6],[78,6,79,6],[410,6,411,6],[57,7,59,7],[61,7,62,7],[67,7,71,7],[72,7,77,7],[78,7,79,7],[385,7,387,7],[388,7,390,7],[391,7,393,7],[399,7,403,7],[404,7,409,7],[410,7,411,7],[385,6,387,6],[388,6,390,6],[391,6,393,6],[399,6,403,6],[410,8,411,8],[57,13,59,13],[61,13,62,13],[67,13,71,13],[72,13,77,13],[78,13,79,13],[385,8,387,8],[388,8,390,8],[391,8,393,8],[399,8,403,8],[404,8,409,8],[57,8,59,8],[61,8,62,8],[67,8,71,8],[72,8,77,8],[78,8,79,8],[67,20,70,20],[72,20,76,20],[57,21,58,21],[57,17,58,17],[57,18,58,18],[57,19,58,19],[57,20,58,20],[61,20,62,20]]}
[null,null,null,null,8,null,30,null,90,null,1,null,2]
[null,"系列","本体长度",null,"工位数",null,"最小间距",null,"最大间距",null,"单工位负载","电机安装方式","变距方式","传感器固定方式",null,"导程"]
[null,null,null,"总长（限制条件）",null,"轴径",null,"导轨",null,"角度","单工位负载","C",null,null,"旋转圈数",null,"理论壁厚（大于0）","扭矩"]
[4,40,null,300,"3-8",26,6.5,5,null,null,1,"H",null,null,0.9]
[5,50,null,260,"3-10",26,8,null,null,null,0.5,"L"]
[3,60,null,450,"3-16",26,"8.5、23","5、7",null,{"$f":"$AB$142","v":0.42610198761277163},"1.5、5","R",null,null,null,null,{"$f":"$Z$156","v":6.3105951281788037}]
[7,"60S",null,600,"8-36",34,7,5,null,{"$f":"$AB$170","v":0.5244299276798905},1.5,null,null,null,null,null,{"$f":"$Z$182","v":173.33333333333334}]
[2,80,null,1500,"3-25",34,12.6,7,null,{"$f":"$AB$70","v":0.5244299276798905},5,null,null,null,null,null,{"$f":"$Z$93","v":6.8580107620128814}]
[1,"80F",null,1500,"3-40",38,"23、30","7、9",null,{"$f":"$AB$18","v":0.56702351315528732},"5、10",null,null,null,null,null,{"$f":"$Z$33","v":6.0504281963843347}]
[6,"80S",null,1500,"6-40",38,46,15,null,{"$f":"$AB$101","v":0.56702351315528732},20,null,null,null,null,null,{"$f":"$Z$114","v":6.0504281963843347}]
[8,"130F",null,2500,"6-40",44,null,"7、9、12",null,{"$f":"$AB$193","v":0.62330027485348627},"5、10、15",null,null,null,null,null,{"$f":"$Z$201","v":7.5120146595547652}]
[9,"175F",null,2500,"8-45",54,null,"9、12、15",null,{"$f":"$AB$226","v":0.78085943289325976},"10、15、20",null,null,null,null,null,{"$f":"$Z$234","v":10.970407859619542}]
[10,"230F",null,4000,"10-50",69,null,15,null,{"$f":"$AB$258","v":0.78085943289325976},20,null,null,null,null,null,{"$f":"$Z$266","v":10.970407859619542}]
[11,"SG350",null,4000,"20-50",null,null,"12、15",null,null,"15、20"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z57)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD18/AF18","v":0.56702351315528732},"槽高",{"$f":"38*3.14","v":119.32000000000001},"斜边长",{"$f":"SQRT(Z19+AD19)","v":210.43219060886204}]
[null,null,"系列",null,"本体长度","角度转换",null,null,"导轨",null,"长度条件","负载1","负载2","轴径","SIN角度","理论壁厚（大于0）",null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z18^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD18^2","v":14237.262400000001},null,null,null,null,null,null,{"$f":"AD24-4-0.5","v":535.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z57)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD20/AF20","v":0.71834760654614449},"槽高",{"$f":"38*3.14","v":119.32000000000001},"斜边长",{"$f":"SQRT(Z21+AD21)","v":166.1034280794743}]
[null,"系列",40,"本体长度",{"$f":"$E$53*($C$53-1)","v":480},{"$f":"DEGREES(ASIN(J4))","v":0},null,null,{"$f":"\"MGNR5\"","v":"MGNR5"},null,{"$f":"IF(D4>=E21,\"A\",\"\")","v":""},{"$f":"IF(1>=$G$53,\"A\")","v":"A"},{"$f":"IF(1>=$G$53,\"A\")","v":"A"},26,{"$f":"IF(F21>=15,\"A\",\"\")","v":""},{"$f":"IF(Q4>=0,\"A\",\"\")","v":"A"},null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z20^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD20^2","v":14237.262400000001},null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+231.6+93+AK19*1.17)/1000,AK22)","v":9.2029332400000001}]
[null,"系列",50,"本体长度",480,{"$f":"DEGREES(ASIN(J5))","v":0},null,null,null,null,{"$f":"IF(D5>=E22,\"A\",\"\")","v":""},{"$f":"IF(0.5>=$G$53,\"A\")","v":false},{"$f":"IF(0.5>=$G$53,\"A\")","v":false},26,{"$f":"IF(F22>=15,\"A\",\"\")","v":""},{"$f":"IF(Q5>=0,\"A\",\"\")","v":"A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+231.6+AK19*1.17)/1000,AK23)","v":9.0559332399999999}]
[null,"系列",60,"本体长度",480,25.220435588917063,null,null,{"$f":"IF($D$53>=22.6,\"MGNR7\",\"MGNR5\")","v":"MGNR7"},null,{"$f":"IF(D6>=E23,\"A\",\"\")","v":""},{"$f":"IF(AND($G$53>1.5,5>=$G$53),\"A\")","v":false},{"$f":"IF(AND($G$53>1.5,5>=$G$53,I23=\"MGNR5\"),\"A\")","v":false},26,"A","A",null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB20*$D$53-10-5.5","v":6.0504281963843347},null,null,"凸轮轴长",{"$f":"Z48","v":520},null,"销钉孔间距",{"$f":"IF(AD24<=300,100,AG24)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+93+AK19*1.17)/1000,AK24)","v":9.0559332399999999}]
[null,"系列","60S","本体长度",480,31.629874189776277,null,null,{"$f":"\"MGNR5\"","v":"MGNR5"},null,"A",{"$f":"IF(1.5>=$G$53,\"A\")","v":"A"},{"$f":"IF(1.5>=$G$53,\"A\")","v":"A"},34,"A","A",null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z23<=4.3,Z23+2,Z23)","v":6.0504281963843347},null,null,"型材长",{"$f":"AD23+20","v":540},null,"销钉孔间距",{"$f":"IF(AD24<=600,200,AG25)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+93+AK19*1.17)/1000,AK25)","v":9.0559332399999999}]
[null,"系列",80,"本体长度",480,31.629874189776277,null,null,{"$f":"IF($D$53<28.9,\"MGNR7\",\"MGNR9\")","v":"MGNR9"},null,"A",{"$f":"IF(5>=$G$53,\"A\")","v":"A"},{"$f":"IF(5>=$G$53,\"A\")","v":"A"},34,"A","A",null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z24<=3.3,Z24+2,Z24)","v":6.0504281963843347},null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AD24+32+25+75,AD26)","v":672},null,"销钉孔间距",{"$f":"IF(AD24<=800,400,AG26)","v":400},null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+93+AK19*1.17)/1000,AK26)","v":9.0559332399999999}]
[null,"系列","80F","本体长度",480,34.542925991735892,null,null,{"$f":"IF(B3>=29,\"MGNR9\",\"MGNR7\")","v":"MGNR7"},null,"A",{"$f":"IF(AND($G$53>5,10>=$G$53),\"A\")","v":false},{"$f":"IF(AND($G$53>5,10>=$G$53,I26=\"MGNR7\"),\"A\")","v":false},38,"A","A",null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z25>=1.8,Z25,#N/A)","v":6.0504281963843347},null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AD24+32+75,AD27)","v":612},null,"销钉孔间距",{"$f":"IF(AD24<=1000,500,AG27)","v":500},null,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"C\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+AK19*1.17)/1000,AK27)","v":9.0559332399999999}]
[null,"系列","80S","本体长度",480,34.542925991735892,null,null,{"$f":"\"MGNR15\"","v":"MGNR15"},null,"A",{"$f":"IF(20>=$G$53,\"A\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},38,"A","A",null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB18>0.766,1,Z28)","v":1.5},null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AD24+32+25+40,AD28)","v":612},null,"销钉孔间距",{"$f":"IF(AD24<=1500,600,800)","v":600},null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"C\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+AK19*1.17)/1000,AK28)","v":9.0559332399999999}]
[null,"系列","130F","本体长度",480,38.557540606537039,null,null,{"$f":"$AG$202","v":"MGNR9"},null,"A",{"$f":"IF(AND($G$53>5,15>=$G$53),\"A\")","v":false},{"$f":"IF(AND($G$53>5,15>=$G$53),\"A\")","v":false},44,"A","A",null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB18>0.5,1.5,Z29)","v":1.5},null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AD24+32+25+40,AD29)","v":612},null,"销钉孔间距",{"$f":"VLOOKUP(AF28,AF23:AG27,2,0)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"C\",$D$53>=29),(AD23*7.8*19*19*3.14/1000+4.754*AD24+89*C53+229+235+362.8+AK19*1.17)/1000,AK29)","v":9.0559332399999999}]
[null,"系列","175F","本体长度",480,51.339331755598515,null,null,{"$f":"$AH$233","v":"MGNR9"},null,"A",{"$f":"IF(AND($G$53>10,20>=$G$53),\"A\")","v":false},{"$f":"IF(AND($G$53>10,20>=$G$53),\"A\")","v":false},54,"A","A",null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB18>0.342,2,Z30)","v":2},null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AD24+32+25+40,AD24+32+40)","v":612},null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+231.6+93+AK19*1.17)/1000,AK30)","v":9.0559332399999999}]
[null,"系列","230F","本体长度",480,51.339331755598515,null,null,{"$f":"\"MGNR15\"","v":"MGNR15"},null,"A",{"$f":"IF(20>=$G$53,\"A\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},69,"A","A",null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB18>0.259,3,Z31)","v":3},null,null,"总长",{"$f":"VLOOKUP(AC30,AC25:AD29,2,0)","v":672},null,"ø5",{"$f":"CONCATENATE(AF30,AF31,AG28)","v":"ø5:200"},null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+231.6+AK19*1.17)/1000,AK31)","v":0}]
[null,"系列","SG350","本体长度",null,0,null,null,null,null,{"$f":"IF(E31>=D14,\"A\",\"\")","v":""},{"$f":"IF(AND($G$53>15,20>=$G$53),\"A\")","v":false},{"$f":"IF(AND($G$53>15,20>=$G$53),\"A\")","v":false},{"$f":"IF(F31>=15,\"A\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB18>0.208,5,#N/A)","v":5},null,null,"总宽",{"$f":"IF($F$53=\"C\",94,AD32)","v":94},null,":",null,null,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+93+AK19*1.17)/1000,AK32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y32,Y27:Z31,2,0)","v":1.5},null,null,"总宽",{"$f":"IF($F$53=\"H\",94,164)","v":164},null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+93+AK19*1.17)/1000,AK33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z32>Z26,#N/A,Z26)","v":6.0504281963843347},null,null,"总宽",{"$f":"VLOOKUP(AC33,AC31:AD32,2,0)","v":94},null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+93+AK19*1.17)/1000,AK34)","v":0}]
["符合三者条件的函数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"不加余量轴长",{"$f":"$E$53*($C$53-1)","v":480},null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"H\"),167.5,AD35)","v":80},null,"型材固定螺母","M6",{"$f":"_xlfn.IFS(AD24>=2001,\"20\",AD24>=1001,\"16\",AD24>=501,\"10\",AD24<501,\"6\")","v":"10"},":","重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"C\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+AK19*1.17)/1000,AK35)","v":0}]
[null,null,"系列",null,"本体长度","角度转换",null,null,"导轨",null,"长度条件","负载1","负载2","轴径","SIN角度","理论壁厚（大于0）",null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34>=1201,$C$53>=17),Z34+30,Z36)","v":486},16.600000000000001,null,"总高",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\"),166,AD36)","v":80},null,{"$f":"CONCATENATE(AF34,AI34,AG34,AI34,AH34,AI34,AI37)","v":"型材固定螺母:M6:10:48"},null,null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"C\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+AK19*1.17)/1000,AK36)","v":0}]
[null,null,"系列",null,"本体长度","角度转换",null,null,"导轨",null,"长度条件","负载1","负载2","轴径","SIN角度","理论壁厚（大于0）",null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34>=1201,$C$53<17),Z34+($C$53-1)*1.8,Z41)","v":486},null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"L\"),80,AD37)","v":80},null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"C\",$D$53>=22.6),(AD23*7.8*19*19*3.14/1000+4.754*AD24+68*C53+229+235+362.8+AK19*1.17)/1000,AK37)","v":0}]
[null,null,"60S",null,480,36.051213599783999,null,null,"MGNR5",null,"A","A","A",34,"A","A",null,"长度条件","负载1","负载2","轴径","SIN角度","理论壁厚（大于0）",null,"轴长",{"$f":"IF(AND(Z34>=801,$C$53>=19),Z30+30,Z38)","v":486},18.75,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"R\"),80,AD38)","v":80},null,null,null,null,48]
[null,null,80,null,480,36.051213599783999,null,null,"MGNR9",null,"A","A","A",34,"A","A",null,"A","A","A",null,"A","A",null,"轴长",{"$f":"IF(AND(Z34>=801,$C$53<19),Z34+($C$53-1)*1.6,Z39)","v":486},null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"C\"),80,78.5)","v":80},null,null,null,null,null,"重量",{"$f":"VLOOKUP(AJ38,AJ21:AK36,2,0)","v":9.2029332400000001}]
[null,null,"80S",null,480,39.12992145114,null,null,"MGNR15",null,"A","A","A",38,"A","A",null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34>=501,$C$53>=20),Z31+30,Z40)","v":486},20,null,"总高",{"$f":"VLOOKUP(AC39,AC34:AD38,2,0)","v":80}]
[null,null,"230F",null,480,55.904203649683701,null,null,"MGNR15",null,"A","A","A",69,"A","A",null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34>=501,$C$53<20),Z34+($C$53-1)*1.5,Z41)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z32>=301,$C$53>=30),Z32+30,Z42)","v":486},30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34>=301,$C$53<30),Z34+($C$53-1)*1,Z43)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34<=300,$C$53>=60),Z33+30,Z44)","v":0},60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z34<=300,$C$53<60),Z34+0.5*($C$53-1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y45,Y35:Z44,2,0)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=40,Z45+46,Z47)","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=29,Z45+34,Z45+28)","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y48,Y46:Z47,2,0)","v":520}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"槽宽",{"$f":"IF(Z23>=3.3,\"8\",Z51)","v":"8"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"槽宽",{"$f":"IF(Z23>=1.8,\"6\",#N/A)","v":"6"}]
[null,null,"工位数\n","最小间距\n填写不含余量的间距","最大间距\n填写不含余量的间距","电机安装方式\n只填写大写字母：L R C H","单工位负载  （KG）","电机                           伺服S/步进B","变距方式  单边1双边2","传感器固定方式    (侧装C尾部W)",{"$f":"IF($I$53=1,\"单边边距（电机在动端D不动端B）\",\"\")","v":""},null,null,null,"旋转圈数",null,null,null,null,null,null,null,null,null,"槽宽",{"$f":"VLOOKUP(Y52,Y50:Z51,2,0)","v":"8"}]
["输入数据","输入数据",7,30,80,"C",1,"B",2,"W",null,null,null,null,0.9,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z34<=300,\"0.5\",Z54)","v":"1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z34<=500,\"1\",Z55)","v":"1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z34<=800,\"1.5\",Z56)","v":"1.5"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z34<=1200,\"2\",\"4\")","v":"2"}]
[null,null,"顺序","系列","本体长度","总长（限制条件）","最小工位数","最大工位数","轴径","最小间距","导轨","滑块","最大间距","角度","单工位负载","电机安装方式","变距方式","传感器固定方式","旋转圈数","导程","理论壁厚（大于0）","扭矩",null,null,"余量",{"$f":"VLOOKUP(Y57,Y53:Z56,2,0)","v":"1"}]
[null,null,1,"80F",{"$f":"($C$53-1)*$E$53","v":480},1500,"3","40",38,23,"MGNR7","MGN7",null,{"$f":"$AB$18","v":0.56702351315528732},5,null,1,null,null,null,40.020389916382697,null,null,null,null,null,null,"CL80F","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,30,"MGNR9","MGN9C",null,null,10,null,2,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB18>=0.765,0.2,Z60)","v":0.3},null,{"$f":"CONCATENATE(AB58,AC58,AD58,AE58,AF58,AG58,AH58,AI58,AJ58,AK58,AL58,AM58,AN58)","v":"CL80F-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,40,"MGNR9","MGN9H",null,null,10,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB18>=0.566,0.3,Z61)","v":0.3}]
[null,null,2,80,{"$f":"($C$53-1)*$E$53","v":480},1500,"3","25",34,12.6,"MGNR7","MGN7",null,{"$f":"$AB$70","v":0.5244299276798905},5,null,null,null,null,null,{"$f":"$Z$93","v":6.8580107620128814},null,null,null,"角度力矩",{"$f":"IF(AB18>=0.307,0.5,0.9)","v":0.5}]
[null,null,3,60,{"$f":"($C$53-1)*$E$53","v":480},450,"3","16",26,8.5,"MGNR5","MGN5",null,{"$f":"$AB$142","v":0.42610198761277163},1.5,null,null,null,null,null,{"$f":"$Z$156","v":6.3105951281788037},null,null,null,"角度力矩",{"$f":"VLOOKUP(Y62,Y59:Z61,2,0)","v":0.3}]
[null,null,null,null,null,null,null,null,null,23,"MGNR7","MGN7",null,null,5,null,null,null,null,null,null,null,null,null,"静态扭矩",0.65]
[null,null,4,40,null,300,"3","8",26,6.5,"MGNR5","MGN5",null,null,1,null,null,null,null,null,null,null,null,null,"扭矩",{"$f":"0.1*Z62*$G$53*$C$53+Z63","v":0.86}]
[null,null,5,50,{"$f":"($C$53-1)*$E$53","v":480},260,"3","10",26,8,"MGNR5","MGN5",null,null,0.5,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y65=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,6,"80S",null,1500,"6","40",38,46,"MGNR15","MGN15",null,{"$f":"$AB$101","v":0.56702351315528732},20,null,null,null,null,null,{"$f":"$Z$114","v":6.0504281963843347},null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z65/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[null,null,7,"60S",{"$f":"($C$53-1)*$E$53","v":480},600,"8","36",34,7,"MGNR5","MGN5",null,{"$f":"$AB$170","v":0.5244299276798905},1.5,null,null,null,null,null,{"$f":"$Z$182","v":173.33333333333334}]
[null,null,8,"130F",{"$f":"($C$53-1)*$E$53","v":480},2500,"6","40",44,23,"MGNR7","MGN7",null,{"$f":"$AB$193","v":0.62330027485348627},5,null,null,null,null,null,{"$f":"$Z$201","v":7.5120146595547652}]
[null,null,null,null,null,null,null,null,null,30,"MGNR9","MGN9C",null,null,10,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,40,"MGNR9","MGN9H",null,null,10,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z85)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD70/AF70","v":0.5244299276798905},"槽高",{"$f":"34*3.14","v":106.76},"斜边长",{"$f":"SQRT(Z71+AD71)","v":203.57343157800443},null,"CL80","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,35,"MGNR12","MGN12C",null,null,15,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z70^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD70^2","v":11397.697600000001},null,null,null,{"$f":"CONCATENATE(AH70,AI70,AJ70,AK70,AL70,AM70,AN70,AO70,AP70,AQ70,AR70,AS70,AT70)","v":"CL80-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,46,"MGNR12","MGN12H",null,null,15,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z85)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD72/AF72","v":0.67860035873376268},"槽高",{"$f":"34*3.14","v":106.76},"斜边长",{"$f":"SQRT(Z73+AD73)","v":157.32381898413567}]
[null,null,9,"175F",{"$f":"($C$53-1)*$E$53","v":480},2500,"8","45",54,30,"MGNR9","MGN9C",null,{"$f":"$AB$226","v":0.78085943289325976},10,null,null,null,null,null,{"$f":"$Z$234","v":10.970407859619542},null,null,null,"导程2的平方",{"$f":"Z72^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD72^2","v":11397.697600000001}]
[null,null,null,null,null,null,null,null,null,40,"MGNR9","MGN9H",null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+205.3+26.3+93,AL75)","v":8588.7382399999988},null,29,null,22.6,null,12.6]
[null,null,null,null,null,null,null,null,null,35,"MGNR12","MGN12C",null,null,15,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB72*$D$53-8-5.5","v":6.8580107620128814},null,null,"凸轮轴长",{"$f":"Z86","v":520},null,null,"销钉孔间距",{"$f":"IF(AD76<=300,100,AH76)","v":200},null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+205.3+26.3+93,AL76)","v":8466.2382399999988},"重量",{"$f":"IF(AND($D$53>=29,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+205.3+26.3+93,AN76)","v":8588.7382399999988},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+205.3+26.3+93,AP76)","v":8466.2382399999988},"重量",{"$f":"IF(AND($D$53>=12.6,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+205.3+26.3+93,AR76)","v":7429.7577600000004}]
[null,null,null,null,null,null,null,null,null,46,"MGNR12","MGN12H",null,null,15,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z75<=3.3,Z75+2,Z75)","v":6.8580107620128814},null,null,"型材长",{"$f":"AD75+20","v":540},null,null,"销钉孔间距",{"$f":"IF(AD76<=600,200,AH77)","v":200},null,null,"重量",{"$f":"IF(AND($D$53>=12.6,$F$53=\"C\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+205.3+26.3+93,AL77)","v":7429.7577600000004},"重量",{"$f":"IF(AND($D$53>=29,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+205.3+26.3+93,AN77)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+205.3+26.3+93,AP77)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+205.3+26.3+93,AR77)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,45,"MGNR15","MGN15C",null,null,20,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z76<=1.8,Z76+1,Z76)","v":6.8580107620128814},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AD76+32+25+75,AE78)","v":672},null,"销钉孔间距",{"$f":"IF(AD76<=800,400,AH78)","v":400},null,null,"重量",{"$f":"IF(AND($D$53>=29,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+205.3+26.3+93,AL78)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AN78)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AP78)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AR78)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,62,"MGNR15","MGN15H",null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z77<=1.3,#N/A,Z77)","v":6.8580107620128814},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AD76+32+75,AE79)","v":72},null,"销钉孔间距",{"$f":"IF(AD76<=1000,500,AH79)","v":500},null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+205.3+26.3+93,AL79)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"L\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+166.8+196+93,AN79)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,,$F$5=\"L\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,AP79)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"L\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93,AR79)","v":8720.8599999999988}]
[null,null,10,"230F",{"$f":"($C$53-1)*$E$53","v":480},4000,"10","50",69,45,"MGNR15C","MGN15C",null,{"$f":"$AB$258","v":0.78085943289325976},null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"VLOOKUP(Y79,Y77:Z78,2,0)","v":6.8580107620128814},null,null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AD76+32+25+40,AE80)","v":72},null,"销钉孔间距",{"$f":"IF(AD76<=1500,600,800)","v":600},null,null,"重量",{"$f":"IF(AND($D$53>=12.6,$F$53=\"C\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+205.3+26.3+93,AL80)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AN80)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AP80)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AR80)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,62,"MGNR15","MGN15H",null,null,20,null,null,null,null,null,{"$f":"$Z$266","v":10.970407859619542},null,null,null,"不含余量长度",{"$f":"($C$53-1)*$E$53","v":480},null,null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AD76+32+25+40,AE81)","v":72},null,"销钉孔间距",{"$f":"VLOOKUP(AG80,AG75:AH79,2,0)","v":200},null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AL81)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+166.8+196+93,AN81)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,AP81)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93,AR81)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"IF(Z80<=300,0.5,Z82)","v":1},null,null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AD76+32+25+40,X31+32+40)","v":72},null,"ø5",{"$f":"CONCATENATE(AG81,AG82,AH80)","v":"ø5:200"},null,null,"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AL82)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AN82)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AP82)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AR82)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"IF(Z80<=500,1,Z83)","v":1},null,null,null,"总长",{"$f":"VLOOKUP(AD82,AD77:AE81,2,0)","v":672},null,":",null,null,null,"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"L\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AL83)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,116+$AD$75*9.318+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,116+$AD$75*9.318+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93)","v":8720.8599999999988},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,116+$AD$75*9.318+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"IF(Z80<=800,1.5,Z84)","v":1.5},null,null,null,"总宽",{"$f":"IF($F$53=\"C\",80,AE84)","v":80},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"L\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+166.8+196+93,AL84)","v":8720.8599999999988},"重量",{"$f":"VLOOKUP(AM83,AM75:AN82,2,0)","v":8588.7382399999988},"重量",8466.2382399999988,"重量",7429.7577600000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"IF(Z80<=1200,2,4)","v":2},null,null,null,"总宽",{"$f":"IF($F$53=\"H\",80,157)","v":157},null,"型材固定螺母","M6",{"$f":"_xlfn.IFS(AD76>=2001,\"20\",AD76>=1001,\"16\",AD76>=501,\"10\",AD76<501,\"6\")","v":"10"},":","重量",{"$f":"IF(AND($D$53>=22.6,,$F$5=\"L\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,AL85)","v":8720.8599999999988},null,{"$f":"AN83/1000","v":8.5887382399999996},null,8.4662382399999991,null,7.4297577600000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"VLOOKUP(Y85,Y81:Z84,2,0)","v":1},null,null,null,"总宽",{"$f":"VLOOKUP(AD85,AD83:AE84,2,0)","v":80},null,{"$f":"CONCATENATE(AG84,AJ84,AH84,AJ84,AI84,AJ84,AJ87)","v":"型材固定螺母:M6:10:48"},null,null,null,"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"L\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93,AL86)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凸轮轴长度",{"$f":"Z80+Z94+2*Z95","v":520},null,null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"H\"),160.5,AE87)","v":73},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AL87)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(Z70>0.766,1,Z88)","v":1},null,null,null,"总高",{"$f":"IF(AND($D$53>=12.5,$F$53=\"H\"),159,AE88)","v":73},null,null,null,null,48,"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AL88)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(Z70>0.5,1.5,Z89)","v":1.5},null,null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"L\"),73,AE89)","v":73},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"R\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AL89)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(Z70>0.342,2,Z90)","v":2},null,null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"R\"),73,AE90)","v":73},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+166.8+196+93,AL90)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(Z70>0.259,3,Z91)","v":3},null,null,null,"总高",{"$f":"IF(AND($D$53>=29,$F$53=\"C\"),73,71.5)","v":73},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,AL91)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(Z70>=0.208,5,#N/A)","v":5},null,null,null,"总高",{"$f":"VLOOKUP(AD91,AD86:AE90,2,0)","v":73},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"R\",$J$53=\"C\"),116+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93,AL92)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y92,Y87:Z91,2,0)","v":1},null,"角度力矩",{"$f":"IF(AB70>=0.765,0.2,AC93)","v":0.5},null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+81.1*$C$53+166.8+196+93,AL93)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z92>Z79,#N/A,Z79)","v":6.8580107620128814},null,"角度力矩",{"$f":"IF(AB70>=0.566,0.3,AC94)","v":0.5},null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+207+63.6*$C$53+166.8+196+93,AL94)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($C$53-1)*Z85","v":6},{"$f":"IF(Y94>=30,30,Y94)","v":6},null,"角度力矩",{"$f":"IF(AB70>=0.307,0.5,0.9)","v":0.5},null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=12.6,,$F$53=\"H\",$J$53=\"W\"),122.8+$AD$75*7.8*17*17*3.14/1000+$AD$76*4.95+204+207+31.1*$C$53+166.8+196+93,AL95)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"两侧留余",{"$f":"IF($D$53>28.9,17,14)","v":17},null,"角度力矩",{"$f":"VLOOKUP(AB95,AB92:AC94,2,0)","v":0.5},null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=29,,$F$53=\"H\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+81.1*$C$53+166.8+196+93,AL96)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y96=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3},null,"静态扭矩",0.65,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),116+$AD$75*7.8*19*19*3.14/1000+$AD$76*4.75+204+209+63.6*$C$53+166.8+196+93,116+$AD$75*9.318+$AD$76*4.95+204+209+31.1*$C$53+166.8+196+93)","v":8720.8599999999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z96/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666},null,"扭矩",{"$f":"0.1*AC95*$G$53*$C$53+AC96","v":1},null,null,null,null,null,null,null,"重量",{"$f":"VLOOKUP(AK97,AK74:AL96,2,0)","v":8588.7382399999988}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"AL97/1000","v":8.5887382399999996}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z120)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD101/AF101","v":0.56702351315528732},"槽高",{"$f":"38*3.14","v":119.32000000000001},"斜边长",{"$f":"SQRT(Z102+AD102)","v":210.43219060886204},null,"CL80S","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z101^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD101^2","v":14237.262400000001},null,null,null,{"$f":"CONCATENATE(AH101,AI101,AJ101,AK101,AL101,AM101,AN101,AO101,AP101,AQ101,AR101,AS101,AT101)","v":"CL80S-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z120)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD103/AF103","v":0.71834760654614449},"槽高",{"$f":"38*3.14","v":119.32000000000001},"斜边长",{"$f":"SQRT(Z104+AD104)","v":166.1034280794743}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z103^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD103^2","v":14237.262400000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB103*$D$53-10-5.5","v":6.0504281963843347},{"$f":"IF(Z107>=4,Z107,Z107+2)","v":6.0504281963843347},null,"凸轮轴长",{"$f":"AB131","v":532},null,"销钉孔间距",{"$f":"IF(AD108<=300,100,AG108)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*$C$53+231.6+93)/1000,AK108)","v":9.0506815839999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB101>0.766,1,Z109)","v":1.5},null,null,"型材长",{"$f":"AD107+20","v":552},null,"销钉孔间距",{"$f":"IF(AD108<=600,200,AG109)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*$C$53+231.6)/1000,AK109)","v":8.0318815840000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB101>0.5,1.5,Z110)","v":1.5},null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AD108+32+25+75,AD110)","v":684},null,"销钉孔间距",{"$f":"IF(AD108<=800,400,AG110)","v":400},null,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*$C$53+362.8+93)/1000,AK110)","v":8.0318815840000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB101>0.342,2,Z111)","v":2},null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AD108+32+75,AD111)","v":624},null,"销钉孔间距",{"$f":"IF(AD108<=1000,500,AG111)","v":500},null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*$C$53+362.8+93)/1000,AK111)","v":8.0318815840000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB101>0.259,3,Z112)","v":3},null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AD108+32+25+40,AD112)","v":624},null,"销钉孔间距",{"$f":"IF(AD108<=1500,600,800)","v":600},null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*$C$53+362.8+93)/1000,(AD107*7.8*19*19*3.14/1000+4.622*AD108+205+209+151*AC83+362.8)/1000)","v":8.0318815840000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB101>0.208,5,#N/A)","v":5},null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AD108+32+25+40,AD113)","v":624},null,"销钉孔间距",{"$f":"VLOOKUP(AF112,AF107:AG111,2,0)","v":200},null,null,"重量",{"$f":"VLOOKUP(AJ112,AJ107:AK111,2,0)","v":9.0506815839999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y113,Y108:Z112,2,0)","v":1.5},null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AD108+32+25+40,AD108+32+40)","v":624},null,"ø5",{"$f":"CONCATENATE(AF113,AF114,AG112)","v":"ø5:200"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z113>Z107,#N/A,Z107)","v":6.0504281963843347},null,null,"总长",{"$f":"VLOOKUP(AC114,AC109:AD113,2,0)","v":684},null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"不留余量的轴长",{"$f":"($C$53-1)*$E$53","v":480},null,null,"总宽",{"$f":"IF($F$53=\"C\",90,AD116)","v":90}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z115<=300,\"0.5\",Z117)","v":"1"},null,null,"总宽",{"$f":"IF($F$53=\"H\",90,157)","v":157},null,"型材固定螺母","M6",{"$f":"_xlfn.IFS(AD108>=2001,\"20\",AD108>=1001,\"16\",AD108>=501,\"10\",AD108<501,\"6\")","v":"10"},":",48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z115<=500,\"1\",Z118)","v":"1"},null,null,"总宽",{"$f":"VLOOKUP(AC117,AC115:AD116,2,0)","v":90},null,{"$f":"CONCATENATE(AF116,AI116,AG116,AI116,AH116,AI116,AJ116)","v":"型材固定螺母:M6:10:48"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z115<=800,\"1.5\",Z119)","v":"1.5"},null,null,"总高",{"$f":"IF($F$53=\"H\",166,78.5)","v":78.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z115<=1200,\"2\",4)","v":"2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"VLOOKUP(Y120,Y116:Z119,2,0)","v":"1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=300,$C$53>=60),Z115+30,Z122)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=300,$C$53<60),Z115+($C$53-1)*0.5,Z123)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=500,$C$53>=30),Z115+30,Z124)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=500,$C$53<30),Z115+($C$53-1)*1,Z125)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=800,$C$53>=20),Z115+30,Z126)","v":489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=800,$C$53<20),Z115+($C$53-1)*1.5,Z127)","v":489}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=1200,$C$53>=15),Z115+30,Z128)","v":492}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115<=1200,$C$53<15),Z115+($C$53-1)*2,Z129)","v":492}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115>1200,$C$53>=14),Z115+30,Z130)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"IF(AND(Z115>1200,$C$53<14),Z115+($C$53-1)*2.1,Z131)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余后轴长",{"$f":"VLOOKUP(Y131,Y121:Z130,2,0)","v":486},"轴长",{"$f":"Z131+46","v":532}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y132=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z132/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB101>=0.765,0.2,Z135)","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB101>=0.566,0.3,Z136)","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB101>=0.307,0.5,0.9)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"VLOOKUP(Y137,Y134:Z136,2,0)","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"静态扭矩",0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"扭矩",{"$f":"0.1*Z137*$G$53*$C$53+Z138","v":0.86}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,16.100000000000001,null,8.5,null,"CL60","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z158)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD142/AF142","v":0.42610198761277163},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z143+AD143)","v":191.597322644249},null,null,null,"重量",{"$f":"IF(AND($D$53>=23,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+57)/1000,AK143)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+57)/1000,AM143)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+57)/1000,AO143)","v":3.6673980360000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+57)/1000,AQ143)","v":3.6517480360000003},null,{"$f":"CONCATENATE(AS141,AT141,AU141,AV141,AW141,AX141,AY141,AZ141,BA141,BB141,BC141,BD141,BE141)","v":"CL60-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z142^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD142^2","v":6665.0896000000002},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+57)/1000,AK144)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+71+57+54.4)/1000,AM144)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+57+54.4)/1000,AO144)","v":3.6673980360000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+57)/1000,AQ144)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z158)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD144/AF144","v":0.5770198376059601},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z145+AD145)","v":141.48560357772479},null,null,null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+57)/1000,AK145)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+54.4)/1000,AM145)","v":3.7466980360000002},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3+54.4)/1000,AO145)","v":3.8009980360000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"L\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AQ145)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z144^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD144^2","v":6665.0896000000002},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+71+57+54.4)/1000,AK146)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+96.3+54.4)/1000,AM146)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+94.3+96.3+54.4)/1000,AO146)","v":0.34860000000000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AQ146)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+57+54.4)/1000,AK147)","v":3.6673980360000002},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+96.3+54.4)/1000,AM147)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"H\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3+54.4)/1000,AO147)","v":0.34860000000000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AQ147)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB144*$D$53-6-5","v":6.3105951281788037},null,null,null,"凸轮轴长",{"$f":"Z164","v":507},null,"销钉孔间距",{"$f":"IF(AE148>=401,200,AH148)","v":200},null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+57)/1000,AK148)","v":3.7466980360000002},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AM148)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,AO148)","v":0.34860000000000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000,AQ148)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z147<=1.8,Z147+1,Z147)","v":6.3105951281788037},null,null,null,"型材长",{"$f":"AE147+16","v":523},null,"销钉孔间距",{"$f":"IF(AE148>=201,150,AH149)","v":150},null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+54.4)/1000,AK149)","v":3.7466980360000002},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AM149)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,AO149)","v":0.34860000000000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000,AQ149)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z148<=1.3,#N/A,Z148)","v":6.3105951281788037},null,null,null,"支柱长度",{"$f":"IF(AC162>=0.32,55,50)","v":55},null,"销钉孔间距",{"$f":"IF(AE148>=101,70,50)","v":70},null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3+54.4)/1000,AK150)","v":3.8009980360000002},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AM150)","v":3.6223980359999999},"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,(AH96*7.8*13*13*3.14/1000+AH97*2.15+AG101*11.45+87+71+96.3+94.3)/1000)","v":0.34860000000000002},"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000,($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB142>0.766,1,Z151)","v":2},null,null,null,"支柱长度",{"$f":"IF($H$53=\"S\",AE149,45)","v":45},null,"销钉孔间距",{"$f":"VLOOKUP(AG150,AG147:AH149,2,0)","v":200},null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"L\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AK151)","v":{"$error":"#VALUE!"}},"重量",{"$f":"VLOOKUP(AL150,AL142:AM149,2,0)","v":3.6223980359999999},"重量",{"$f":"VLOOKUP(AN150,AN127:AO149,2,0)","v":3.6673980360000002},"重量",{"$f":"VLOOKUP(AP150,AP142:AQ149,2,0)","v":3.6517480360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB142>0.5,1.5,Z152)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AE148+23+20+10+AE150,AE152)","v":621},null,"ø4",{"$f":"CONCATENATE(AG151,AG152,AH150)","v":"ø4:200"},null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+96.3+54.4)/1000,AK152)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB142>0.342,2,Z153)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AE148+23+10+AE153,AE153)","v":571},null,":",null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+94.3+96.3+54.4)/1000,AK153)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB142>0.259,3,Z154)","v":3},null,null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AE148+23+20+25,AE154)","v":571},null,null,null,null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AK154)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB142>0.208,5,#N/A)","v":5},null,null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AE148+23+20+25,AE155)","v":571},null,"螺纹孔","M4",{"$f":"IF(AE148>=400,\"8\",IF(200<AE148<400,\"6\",IF(AE148<=200,\"4\")))","v":"8"},"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+94.3+96.3+54.4)/1000,AK155)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y155,Y150:Z154,2,0)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AE148+23+20+25,AE148+23+25)","v":571},null,{"$f":"CONCATENATE(AG154,AG152,AH154,AG152,AI154,AG152,AI158)","v":"螺纹孔:M4:8:40"},null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"H\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3+54.4)/1000,AK156)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z155>Z149,#N/A,Z149)","v":6.3105951281788037},null,null,null,"总长",{"$f":"VLOOKUP(AD156,AD151:AE155,2,0)","v":621},null,null,null,null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3+54.4)/1000,AK157)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"角度力矩",{"$f":"IF(AB142>=0.965,0.1,AC158)","v":0.5},"总宽",{"$f":"IF($F$53=\"C\",60,AE158)","v":60},null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AK158)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z157>=301,1,0.5)","v":1},null,"角度力矩",{"$f":"IF(AB142>=0.866,0.16,AC159)","v":0.5},"总宽",{"$f":"IF($F$53=\"H\",60,151)","v":151},null,null,null,40,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,AK159)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z157>=301,$C$53>=30),Z157+30,Z160)","v":479},null,"角度力矩",{"$f":"IF(AB142>=0.707,0.28,0.5)","v":0.5},"总宽",{"$f":"VLOOKUP(AD159,AD157:AE158,2,0)","v":60},null,null,null,null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000,AK160)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z157>=301,$C$53<30),Z157+1*($O$5338-1),Z161)","v":479},null,"角度力矩",{"$f":"VLOOKUP(AB160,AB157:AC159,2,0)","v":0.5},"总高",{"$f":"IF($F$53=\"H\",107.5,54)","v":54},null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AK161)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z157<301,$C$53>=60),Z157+30,Z162)","v":479},null,"静态扭矩",0.15,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,AK162)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z157<301,$C$53<60),Z157+($O$5338-1)*0.5,Z163)","v":479},null,"扭矩",{"$f":"0.1*AC160*$G$53*$C$53+AC161","v":0.5},null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=8.5,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*11.45+87+71+96.3+94.3)/1000,AK163)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y163,Y159:Z162,2,0)","v":479},null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=22.6,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*31+87+71+96.3+94.3)/1000,AK164)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=22.6,Z163+28,Z163+22)","v":507},null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=16.1,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3)/1000,(AD111*7.8*13*13*3.14/1000+AD112*2.15+AC116*11.45+87+71+96.3+94.3)/1000)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y165=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3},null,null,null,null,null,null,null,null,null,"重量",{"$f":"VLOOKUP(AJ165,AJ142:AK164,2,0)","v":3.6223980359999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z165/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z184)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD170/AF170","v":0.5244299276798905},"槽高",{"$f":"34*3.14","v":106.76},"斜边长",{"$f":"SQRT(Z171+AD171)","v":203.57343157800443},null,"CL60S","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z170^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD170^2","v":11397.697600000001},null,null,null,{"$f":"CONCATENATE(AH170,AI170,AJ170,AK170,AL170,AM170,AN170,AO170,AP170,AQ170,AR170,AS170,AT170)","v":"CL60S-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z184)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD172/AF172","v":0.67860035873376268},"槽高",{"$f":"34*3.14","v":106.76},"斜边长",{"$f":"SQRT(Z173+AD173)","v":157.32381898413567}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z172^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD172^2","v":11397.697600000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*C53+67)/1000,AL175)","v":5.5862747579999992}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB172*$D$53-5-4.5","v":10.858010762012881},null,null,null,"凸轮轴长",{"$f":"Z188","v":514},null,"销钉孔间距",{"$f":"IF(AE176>=401,200,AH176)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+67+64.3)/1000,AL176)","v":5.5862747579999992}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB170>0.766,1,Z177)","v":1.5},null,null,null,"型材长",{"$f":"AE175+16","v":530},null,"销钉孔间距",{"$f":"IF(AE176>=201,150,AH177)","v":150},null,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"C\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+183.5+140)/1000,AL177)","v":0.6127999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB170>0.5,1.5,Z178)","v":1.5},null,null,null,"支柱长度",{"$f":"IF(AC189>=0.32,55,50)","v":55},null,"销钉孔间距",{"$f":"IF(AE176>=101,70,50)","v":70},null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"C\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+183.5+140)/1000,AL178)","v":0.6127999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB170>0.342,2,Z179)","v":2},null,null,null,"支柱长度",{"$f":"IF($H$53=\"S\",AE177,45)","v":45},null,"销钉孔间距",{"$f":"VLOOKUP(AG178,AG175:AH177,2,0)","v":200},null,null,"重量",{"$f":"IF(AND($F$53=\"H\",$J$53=\"C\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+183.5+140)/1000,AL179)","v":0.6127999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB170>0.259,3,Z180)","v":3},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AE176+23+20+10+AE178,AE180)","v":628},null,"ø4",{"$f":"CONCATENATE(AG179,AG180,AH178)","v":"ø4:200"},40,null,"重量",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+183.5+140+64.3)/1000,AL180)","v":0.6127999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB170>0.208,5,#N/A)","v":5},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AE176+23+10+AE178,AE181)","v":578},null,":",null,null,null,"重量",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),(AE175*7.8*16.5*16.5*3.14/1000+AE176*3.25+125+100+11.45*$C$53+183.5+140+64.3)/1000,(AC175*7.8*16.5*16.5*3.14/1000+AC176*3.25+125+100+11.19*AB181+11.83*AB180+183.5+140+64.3)/1000)","v":0.6127999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y181,Y176:Z180,2,0)","v":1.5},null,null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AE176+23+20+25,AE182)","v":578},null,null,null,null,null,"重量",{"$f":"VLOOKUP(AK181,AK174:AL180,2,0)","v":5.5862747579999992}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z181>Z175,#N/A,Z170)","v":173.33333333333334},null,null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AE176+23+20+25,AE183)","v":578},null,"螺纹孔","M4",{"$f":"IF(AE176>=400,\"8\",IF(200<AE176<400,\"6\",IF(AE176<=200,\"4\")))","v":"8"},":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"不含余量轴长",{"$f":"$E$53*($C$53-1)","v":480},null,null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AE176+23+20+25,AE176+23+25)","v":578},null,{"$f":"CONCATENATE(AG182,AJ182,AH182,AJ182,AI182,AJ182,AI179)","v":"螺纹孔:M4:8:40"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量",{"$f":"IF(Z183>=301,1,0.5)","v":1},null,"角度力矩",{"$f":"IF(AB170>=0.965,0.1,AC185)","v":0.5},"总长",{"$f":"VLOOKUP(AD184,AD179:AE183,2,0)","v":628}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"留余量长度",{"$f":"($C$53-1)*Z184","v":6},null,"角度力矩",{"$f":"IF(AB170>=0.866,0.16,AC186)","v":0.5},"总宽",{"$f":"IF($F$53=\"C\",82,AE186)","v":82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最大留余",{"$f":"IF(Z185>=30,30,Z185)","v":6},null,"角度力矩",{"$f":"IF(AB170>=0.707,0.2,0.5)","v":0.5},"总宽",{"$f":"IF($F$53=\"H\",82,151)","v":151}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"两侧总留余",{"$f":"IF($D$53>=22.6,28,22)","v":28},null,"角度力矩",{"$f":"VLOOKUP(AB187,AB184:AC186,2,0)","v":0.5},"总宽",{"$f":"VLOOKUP(AD187,AD185:AE186,2,0)","v":82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"Z183+Z186+Z187","v":514},null,"静态扭矩",0.25,"总高",{"$f":"IF($F$53=\"H\",149,73.5)","v":73.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y189=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3},null,"扭矩",{"$f":"0.1*AC187*$G$53*$C$53+AC188","v":0.60000000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z189/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"130F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z207)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD193/AF193","v":0.62330027485348627},"槽高",{"$f":"44*3.14","v":138.16},"斜边长",{"$f":"SQRT(Z194+AD194)","v":221.65881449751654},null,"CL130F","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z193^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD193^2","v":19088.185600000001},null,null,null,{"$f":"CONCATENATE(AH193,AI193,AJ193,AK193,AL193,AM193,AN193,AO193,AP193,AQ193,AR193,AS193,AT193)","v":"CL130F-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z207)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD195/AF195","v":0.76706715531849223},"槽高",{"$f":"44*3.14","v":138.16},"斜边长",{"$f":"SQRT(Z196+AD196)","v":180.11460801321221}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z195^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD195^2","v":19088.185600000001}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB195*$D$53-10-5.5","v":7.5120146595547652},null,"凸轮轴长",{"$f":"Z218","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z198<=4.3,Z198+2,Z198)","v":7.5120146595547652},null,"型材长",{"$f":"AC198+10","v":530}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z199<=3.3,Z199+2,Z199)","v":7.5120146595547652},null,"总长",{"$f":"IF($F$53=\"C\",AC199+85+20,AC199+65+20)","v":635},null,null,"直线导轨",{"$f":"IF(G1>34.7,\"MGNR12\",AG201)","v":"MGNR9"},null,"凸轮轴",{"$f":"22*22*3.14*AC198*7.8/1000/1000","v":6.1641465599999989}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"VLOOKUP(Y201,Y199:Z200,2,0)","v":7.5120146595547652},null,"总宽",{"$f":"IF($F$53=\"C\",150,AC202)","v":150},null,null,"直线导轨",{"$f":"IF(G1>28.9,\"MGNR9\",\"MGNR7\")","v":"MGNR9"},null,"型材",{"$f":"9855.48/1304*AC199/1000","v":4.0056782208588952}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"总宽",{"$f":"IF($F$53=\"H\",150,239)","v":239},null,null,"直线导轨",{"$f":"VLOOKUP(AF202,AF200:AG201,2,0)","v":"MGNR9"},null,"固定端",0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z202<=300,\"0.5\",Z204)","v":"1"},null,"总宽",{"$f":"VLOOKUP(AB203,AB201:AC202,2,0)","v":150},null,null,null,null,null,"支撑端",0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z202<=500,\"1\",Z205)","v":"1"},null,"总高",{"$f":"IF($F$53=\"H\",220,93)","v":93},null,null,"销钉孔间距",{"$f":"IF(AC199<=300,100,AG205)","v":200},null,"滑座",{"$f":"0.336*C55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z202<=800,\"1.5\",Z206)","v":"1.5"},null,null,null,null,null,"销钉孔间距",{"$f":"IF(AC199<=600,200,AG206)","v":200},null,"电机直连座",{"$f":"IF($F$53=\"C\",\"0.36\",\"0\")","v":"0.36"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z202<=1200,\"2\",\"4\")","v":"2"},null,null,null,null,null,"销钉孔间距",{"$f":"IF(AC199<=800,400,AG207)","v":400},null,"电机折连板",{"$f":"IF($F$53<>\"C\",\"0.6\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"VLOOKUP(Y207,Y203:Z206,2,0)","v":"1"},null,null,null,null,null,"销钉孔间距",{"$f":"IF(AC199<=1000,500,AG208)","v":500},null,"张紧块",{"$f":"IF($F$53<>\"C\",\"0.025\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z202>=1201,Z202+Z213,Z209)","v":486},null,null,null,null,null,"销钉孔间距",{"$f":"IF(AC199<=1500,600,AG209)","v":600},null,"前罩",{"$f":"IF($F$53<>\"C\",\"0.0268\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z202>=801,Z202+Z213,Z210)","v":486},null,null,null,null,null,"销钉孔间距",{"$f":"IF(AC199<=2000,800,1000)","v":800},null,"电机座盖板",{"$f":"IF($F$53=\"C\",\"0.035\",\"0\")","v":"0.035"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z202>=501,Z202+Z213,Z211)","v":486},null,null,null,null,null,"销钉孔间距",{"$f":"VLOOKUP(AF210,AF204:AG210,2,0)","v":200},null,"型材盖板",{"$f":"1698/1314*(AC199+10)/1000","v":0.69780821917808211}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z202>=301,Z202+Z213,Z202+Y213)","v":486},null,null,null,null,null,"ø8",{"$f":"CONCATENATE(AF211,AF212,AG210)","v":"ø8:200"},null,"总重",{"$f":"SUM(AJ200:AJ210)","v":11.957633000036978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y212,Y208:Z211,2,0)","v":486},null,null,null,null,null,":"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($C$53-1)*Z207","v":6},{"$f":"IF(Y213>=30,30,Y213)","v":6},null,"角度力矩",{"$f":"IF(AB193>=0.765,0.3,AC214)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"角度力矩",{"$f":"IF(AB193>=0.566,0.5,AC215)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=45,Z212+51,Z216)","v":520},null,"角度力矩",{"$f":"IF(AB193>=0.307,0.8,1.5)","v":0.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=40,Z212+46,Z217)","v":520},null,"角度力矩",{"$f":"VLOOKUP(AB216,AB213:AC215,2,0)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=28,Z212+34,Z212+28)","v":520},null,"静态扭矩",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y218,Y215:Z217,2,0)","v":520},null,"扭矩",{"$f":"0.1*AC216*$G$53*$C$53+AC217","v":1.35}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y219=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z219/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"175F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z240)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD226/AF226","v":0.78085943289325976},"槽高",{"$f":"69*3.14","v":216.66},"斜边长",{"$f":"SQRT(Z227+AD227)","v":277.46351119461536},null,null,null,"零件名称","重量",null,null,"CL175F","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z226^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD226^2","v":46941.5556},null,null,null,null,null,"凸轮轴",{"$f":"34.5*34.5*3.14*AC231*7.8/1000/1000","v":15.158833560000001},null,null,{"$f":"CONCATENATE(AN226,AO226,AP226,AQ226,AR226,AS226,AT226,AU226,AV226,AW226,AX226,AY226,AZ226)","v":"CL175F-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z240)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD228/AF228","v":0.88234692865398467},"槽高",{"$f":"69*3.14","v":216.66},"斜边长",{"$f":"SQRT(Z229+AD229)","v":245.54967322265588},null,null,null,"型材",{"$f":"22523/2000*AC232/1000","v":6.0812100000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z228^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD228^2","v":46941.5556},null,null,null,null,null,"固定端",1.022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支撑端",1.034]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB228*$D$53-10-5.5","v":10.970407859619542},null,"凸轮轴长",{"$f":"Z251","v":520},"销钉孔间距",{"$f":"IF(AC232<=300,100,AE232)","v":200},null,"直线导轨",{"$f":"IF(G1>45,\"MGNR15\",AH232)","v":"MGNR9"},null,"滑座",{"$f":"1.18*C53","v":8.26}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z231<=4.3,Z231+2,Z231)","v":10.970407859619542},null,"型材长",{"$f":"AC231+20","v":540},"销钉孔间距",{"$f":"IF(AC232<=600,200,AE233)","v":200},null,"直线导轨",{"$f":"IF(G1>34.7,\"MGNR12\",\"MGNR9\")","v":"MGNR9"},null,"电机直连座",{"$f":"IF($F$53=\"C\",\"0.534\",\"0\")","v":"0.534"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z232<=3.3,Z232+2,Z232)","v":10.970407859619542},null,"总高",{"$f":"IF($F$53=\"H\",250,123.5)","v":123.5},"销钉孔间距",{"$f":"IF(AC232<=800,400,AE234)","v":400},null,"直线导轨",{"$f":"VLOOKUP(AG233,AG231:AH232,2,0)","v":"MGNR9"},null,"电机折连板",{"$f":"IF($F$53<>\"C\",\"0.615\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"VLOOKUP(Y234,Y232:Z233,2,0)","v":10.970407859619542},null,"总宽",{"$f":"IF($F$53=\"C\",200,AC235)","v":200},"销钉孔间距",{"$f":"IF(AC232<=1000,500,AE235)","v":500},null,"直线滑块",{"$f":"IF(G1>62,\"MGN15H\",AH235)","v":"MGN9C"},null,"张紧块",{"$f":"IF($F$53<>\"C\",\"0.037\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"总宽",{"$f":"IF($F$53=\"H\",200,AC236)","v":312.5},"销钉孔间距",{"$f":"IF(AC232<=1500,600,AE236)","v":600},null,"直线滑块",{"$f":"IF(G1>45,\"MGN15C\",AH236)","v":"MGN9C"},null,"前罩",{"$f":"IF($F$53<>\"C\",\"0.396\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z235<=300,\"0.5\",Z237)","v":"1"},null,"总宽",{"$f":"IF(AH246=\"CL175F-07M-90-00\",312.5,AC237)","v":312.5},"销钉孔间距",{"$f":"IF(AC232<=2000,800,1000)","v":800},null,"直线滑块",{"$f":"IF(G1>34.7,\"MGN12C\",\"MGN9C\")","v":"MGN9C"},null,"电机座盖板",{"$f":"IF($F$53=\"C\",\"0.072\",\"0\")","v":"0.072"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z235<=500,\"1\",Z238)","v":"1"},null,"总宽",{"$f":"IF(AH246=\"CL175F-07M-115-00\",322.5,312.5)","v":312.5},"销钉孔间距",{"$f":"VLOOKUP(AD237,AD231:AE237,2,0)","v":200},null,"直线滑块",{"$f":"VLOOKUP(AG237,AG234:AH236,2,0)","v":"MGN9C"},null,"型材盖板",{"$f":"4280/2010*(AC232+10)/1000","v":1.1711442786069652}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z235<=800,\"1.6\",Z239)","v":"1.6"},null,"总宽",{"$f":"VLOOKUP(AB238,AB234:AC237,2,0)","v":200},"ø8",{"$f":"CONCATENATE(AD238,AD239,AE237)","v":"ø8:200"},null,null,null,null,"底板",{"$f":"4058/460*AC232/1000","v":4.7637391304347823}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z235<=1200,\"1.8\",\"2\")","v":"1.8"},null,"总长",{"$f":"IF($F$53=\"C\",AC232+135,AC232+95)","v":675},":",null,null,null,null,null,"总重",{"$f":"SUM(AK227:AK238)","v":37.490926969041752}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"VLOOKUP(Y240,Y236:Z239,2,0)","v":"1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"电机折连板",{"$f":"IF(AND(AC249<2.39,$F$53<>\"H\"),\"CL175F-07M-90-00\",AH242)","v":"CL175F-07M-90-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z235>=1201,Z235+Z252,Z243)","v":486},null,null,null,null,null,null,"电机折连板",{"$f":"IF(AND(AC249<3.18,$F$53<>\"H\"),\"CL175F-07M-115-00\",AH243)","v":"CL175F-07M-115-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z235>=801,Z235+Z252,Z244)","v":486},null,null,null,null,null,null,"电机折连板",{"$f":"IF(AND(AC249>=3.18,$F$53<>\"H\"),\"CL175F-07M-100-00\",AH244)","v":"CL175F-15M-100-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z235>=501,Z235+Z252,Z245)","v":486},null,"角度力矩",{"$f":"IF(AB226>=0.865,0.4,AC245)","v":0.6},null,null,null,"电机折连板",{"$f":"IF(AND(AC249<2.39,$F$53=\"H\"),\"CL175F-15M-90-00\",AH245)","v":"CL175F-15M-100-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z235>=301,Z235+Z252)","v":486},null,"角度力矩",{"$f":"IF(AB226>=0.666,0.6,AC246)","v":0.6},null,null,null,"电机折连板",{"$f":"IF(AND(AC249<3.18,$F$53=\"H\"),\"CL175F-15M-115-00\",\"CL175F-15M-100-00\")","v":"CL175F-15M-100-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y246,Y242:Z245,2,0)","v":486},null,"角度力矩",{"$f":"IF(AB226>=0.407,0.8,1.5)","v":0.8},null,null,null,"电机折连板",{"$f":"VLOOKUP(AG246,AG241:AH245,2,0)","v":"CL175F-07M-90-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>62,Z246+68,Z248)","v":520},null,"角度力矩",{"$f":"VLOOKUP(AB247,AB244:AC246,2,0)","v":0.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>45,Z246+51,Z249)","v":520},null,"静态扭矩",1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>34.7,Z246+40,Z250)","v":520},null,"扭矩",{"$f":"0.1*AC247*$C$53*$G$53+AC248","v":1.92}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>28.9,Z246+34,\"\")","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y251,Y247:Z250,2,0)","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($C$53-1)*Z240","v":6},{"$f":"IF(Y252>=30,30,Y252)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y253=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z253/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"230F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z272)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD258/AF258","v":0.78085943289325976},"槽高",{"$f":"69*3.14","v":216.66},"斜边长",{"$f":"SQRT(Z259+AD259)","v":277.46351119461536},null,null,null,null,null,null,null,null,"CL230F","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z258^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD258^2","v":46941.5556},null,null,null,null,null,null,"零件名称","重量",null,null,{"$f":"CONCATENATE(AO258,AP258,AQ258,AR258,AS258,AT258,AU258,AV258,AW258,AX258,AY258,AZ258,BA258)","v":"CL230F-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z272)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD260/AF260","v":0.88234692865398467},"槽高",{"$f":"69*3.14","v":216.66},"斜边长",{"$f":"SQRT(Z261+AD261)","v":245.54967322265588},null,null,null,null,"凸轮轴",{"$f":"37*37*3.14*AC263*7.8/1000/1000","v":17.435364959999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z260^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD260^2","v":46941.5556},null,null,null,null,null,null,"型材",{"$f":"28678/2118*AC264/1000","v":7.311671388101983}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"固定端",1.4119999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB260*$D$53-10-5.5","v":10.970407859619542},null,"凸轮轴长",{"$f":"Z283","v":520},null,"电机直连座",{"$f":"IF(AC281<2.39,\"CL175F-16M-90-01\",AF264)","v":"CL175F-16M-90-01"},null,null,null,null,"支撑端",1.4239999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z263<=4.3,Z263+2,Z263)","v":10.970407859619542},null,"型材长",{"$f":"AC263+20","v":540},null,"电机直连座",{"$f":"IF(AC281<3.18,\"CL175F-16M-115-01\",\"CL175F-16M-100-01\")","v":"CL175F-16M-115-01"},null,null,null,null,"滑座",{"$f":"1636*C53/1000","v":11.452}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z264<=3.3,Z264+2,Z264)","v":10.970407859619542},null,null,null,null,"电机直连座",{"$f":"VLOOKUP(AE265,AE263:AF264,2,0)","v":"CL175F-16M-90-01"},null,null,null,null,"电机直连座",{"$f":"IF($F$53=\"C\",\"0.534\",\"0\")","v":"0.534"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"VLOOKUP(Y266,Y264:Z265,2,0)","v":10.970407859619542},null,"销钉孔间距",{"$f":"IF(AC264<=300,100,AC267)","v":200},null,null,null,null,null,null,null,"电机折连板",{"$f":"IF($F$53<>\"C\",\"0.782\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"销钉孔间距",{"$f":"IF(AC264<=600,200,AC268)","v":200},null,null,null,null,null,null,null,"张紧块",{"$f":"IF($F$53<>\"C\",\"0.047\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z267<=300,\"0.5\",Z269)","v":"1"},null,"销钉孔间距",{"$f":"IF(AC264<=800,400,AC269)","v":400},null,null,null,null,null,null,null,"前罩",{"$f":"IF($F$53<>\"C\",\"0.483\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z267<=500,\"1\",Z270)","v":"1"},null,"销钉孔间距",{"$f":"IF(AC264<=1000,500,AC270)","v":500},null,"电机折连板",{"$f":"IF(AND(AC281<2.39,$F$53<>\"H\"),\"CL230F-07M-90-00\",AF270)","v":"CL230F-07M-90-00"},null,"前罩",{"$f":"IF(AND(AC281<2.39,$F$53<>\"H\"),\"CL230F-19C-90-00\",AI270)","v":"CL230F-19C-90-00"},null,"电机座盖板",{"$f":"IF($F$53=\"C\",\"0.057\",\"0\")","v":"0.057"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z267<=800,\"1.6\",Z271)","v":"1.6"},null,"销钉孔间距",{"$f":"IF(AC264<=1500,600,AC271)","v":600},null,"电机折连板",{"$f":"IF(AND(AC281<3.18,$F$53<>\"H\"),\"CL230F-07M-115-00\",AF271)","v":"CL230F-07M-115-00"},null,"前罩",{"$f":"IF(AND(AC281<3.18,$F$53<>\"H\"),\"CL230F-19C-115-00\",AI271)","v":"CL230F-19C-115-00"},null,"型材盖板",{"$f":"4280/2010*(AC264+10)/1000","v":1.1711442786069652}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z267<=1200,\"1.8\",\"2\")","v":"1.8"},null,"销钉孔间距",{"$f":"IF(AC264<=2000,800,1000)","v":800},null,"电机折连板",{"$f":"IF(AND(AC281>=3.18,$F$53<>\"H\"),\"CL230F-07M-100-00\",AF272)","v":"CL175F-15M-100-00"},null,"前罩",{"$f":"IF(AND(AC281>=3.18,$F$53<>\"H\"),\"CL230F-19C-90-00\",AI272)","v":"CL175F-19C-90-H-00"},null,"底板",{"$f":"4058/460*AC264/1000","v":4.7637391304347823}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"VLOOKUP(Y272,Y268:Z271,2,0)","v":"1"},null,"销钉孔间距",{"$f":"VLOOKUP(AB272,AB266:AC272,2,0)","v":200},null,"电机折连板",{"$f":"IF(AND(AC281<2.39,$F$53=\"H\"),\"CL175F-15M-90-00\",AF273)","v":"CL175F-15M-100-00"},null,"前罩",{"$f":"IF(AND(AC281<2.39,$F$53=\"H\"),\"CL175F-19C-90-H-00\",AI273)","v":"CL175F-19C-90-H-00"},null,"总重",{"$f":"SUM(AL260:AL271)","v":44.969919757143728}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($C$53-1)*Z272","v":6},{"$f":"IF(Y273>=30,30,Y273)","v":6},null,"ø8",{"$f":"CONCATENATE(AB273,AB274,AC272)","v":"ø8:200"},null,"电机折连板",{"$f":"IF(AND(AC281<3.18,$F$53=\"H\"),\"CL175F-15M-115-00\",\"CL175F-15M-100-00\")","v":"CL175F-15M-100-00"},null,"前罩",{"$f":"IF(AND(AC281<3.18,$F$53=\"H\"),\"CL175F-19C-115-H-00\",\"CL175F-19C-90-H-00\")","v":"CL175F-19C-90-H-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z267>=1201,Z273+Z267,Z275)","v":486},null,":",null,null,"电机折连板",{"$f":"VLOOKUP(AE274,AE269:AF273,2,0)","v":"CL230F-07M-90-00"},null,"前罩",{"$f":"VLOOKUP(AH274,AH269:AI273,2,0)","v":"CL230F-19C-90-00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z267>=801,Z273+Z267,Z276)","v":486}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z267>=501,Z273+Z267,Z277)","v":486},null,"角度力矩",{"$f":"IF(AB258>=0.865,0.4,AC277)","v":0.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(Z267>=301,Z273+Z267,Z273+Z267)","v":486},null,"角度力矩",{"$f":"IF(AB258>=0.666,0.6,AC278)","v":0.6},null,"总宽",{"$f":"IF($F$53=\"C\",250,AF278)","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y278,Y274:Z277,2,0)","v":486},null,"角度力矩",{"$f":"IF(AB258>=0.407,0.8,1.5)","v":0.8},null,"总宽",{"$f":"IF($F$53=\"H\",250,AF279)","v":347}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>62,Z278+68,Z280)","v":520},null,"角度力矩",{"$f":"VLOOKUP(AB279,AB276:AC278,2,0)","v":0.6},null,"总宽",{"$f":"IF(AI274=\"CL230F-19C-90-00\",347,357)","v":347}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>45,Z278+51,Z281)","v":520},null,"静态扭矩",1.5,null,"总宽",{"$f":"VLOOKUP(AE280,AE277:AF279,2,0)","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>34.7,Z278+40,Z282)","v":520},null,"扭矩",{"$f":"0.1*AC279*$C$53*$G$53+AC280","v":1.92},null,"总高",{"$f":"IF($F$53<>\"H\",152.5,AF282)","v":152.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>28.9,Z278+34,\"\")","v":520},null,null,null,null,"总高",{"$f":"IF(AI274=\"CL175F-19C-90-H-00\",258.5,263.5)","v":263.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y283,Y279:Z282,2,0)","v":520},null,null,null,null,"总高",{"$f":"VLOOKUP(AE283,AE281:AF282,2,0)","v":152.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"总长",{"$f":"IF($F$53<>\"C\",AC264+95,AF285)","v":670}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y285=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3},null,null,null,null,"总长",{"$f":"IF(AF265=\"CL175F-16M-90-00\",AC264+115,AF286)","v":670}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z285/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666},null,null,null,null,"总长",{"$f":"IF(AF265=\"CL175F-16M-100-00\",AC264+120,AC264+130)","v":670}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"总长",{"$f":"VLOOKUP(AE287,AE284:AF286,2,0)","v":670}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z307)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD291/AF291","v":0.42610198761277163},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z292+AD292)","v":191.597322644249}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z291^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD291^2","v":6665.0896000000002},null,null,null,null,null,null,null,null,null,null,"CL40","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z307)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD293/AF293","v":0.5770198376059601},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z294+AD294)","v":141.48560357772479},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AO292,AP292,AQ292,AR292,AS292,AT292,AU292,AV292,AW292,AX292,AY292,AZ292,BA292)","v":"CL40-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z293^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD293^2","v":6665.0896000000002},null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"C\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+57)/1000,AL296)","v":3.5623980360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB293*$D$53-6-5","v":6.3105951281788037},null,null,null,"凸轮轴长",{"$f":"Z313","v":507},null,"销钉孔间距",{"$f":"IF(AE297>=401,200,AH297)","v":200},null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+57+54.4)/1000,AL297)","v":3.5623980360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z296<=1.8,Z296+1,Z296)","v":6.3105951281788037},null,null,null,"型材长",{"$f":"AE296+16","v":523},null,"销钉孔间距",{"$f":"IF(AE297>=201,150,AH298)","v":150},null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"C\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*25+87+71+96.3+94.3+54.4)/1000,AL298)","v":3.8009980360000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z297<=1.3,#N/A,Z297)","v":6.3105951281788037},null,null,null,null,null,null,"销钉孔间距",{"$f":"IF(AE297>=101,70,50)","v":70},null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"R\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+94.3+96.3+54.4)/1000,AL299)","v":3.6415980360000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB291>0.766,1,Z300)","v":2},null,null,null,"直连座长",58,null,"销钉孔间距",{"$f":"VLOOKUP(AG299,AG296:AH298,2,0)","v":200},null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"H\",$J$53=\"W\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+96.3+94.3+54.4)/1000,AL300)","v":3.6415980360000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB291>0.5,1.5,Z301)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"W\"),AE297+23+20+10+AE299,AE301)","v":634},null,"ø4",{"$f":"CONCATENATE(AG300,AG301,AH299)","v":"ø4:200"},null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"L\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+96.3+94.3)/1000,AL301)","v":3.6415980360000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB291>0.342,2,Z302)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"C\",$J$53=\"C\"),AE297+23+10+AE302,AE302)","v":571},null,":",null,null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"R\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+96.3+94.3)/1000,AL302)","v":3.6415980360000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB291>0.259,3,Z303)","v":3},null,null,null,"总长",{"$f":"IF(AND($F$53=\"L\",$J$53=\"W\"),AE297+23+20+25,AE303)","v":571},null,null,null,null,null,"重量",{"$f":"IF(AND($D$53>=6.5,$F$53=\"H\",$J$53=\"C\"),($AE$147*7.8*13*13*3.14/1000+$AE$148*2.15+$C$53*10+87+71+96.3+94.3)/1000,(AE147*7.8*13*13*3.14/1000+AE148*2.15+C53*10+87+71+96.3+94.3)/1000)","v":3.6415980360000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB291>0.208,5,#N/A)","v":5},null,null,null,"总长",{"$f":"IF(AND($F$53=\"R\",$J$53=\"W\"),AE297+23+20+25,AE304)","v":571},null,"螺纹孔","M4",{"$f":"IF(AE297>=400,\"8\",IF(200<AE297<400,\"6\",IF(AE297<=200,\"4\")))","v":"8"},25,"重量",{"$f":"VLOOKUP(AK303,AK295:AL302,2,0)","v":3.5623980360000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y304,Y299:Z303,2,0)","v":2},null,null,null,"总长",{"$f":"IF(AND($F$53=\"H\",$J$53=\"W\"),AE297+23+20+25,AE297+23+25)","v":571},null,{"$f":"CONCATENATE(AG303,AG301,AH303,AG301,AI303,AG301,AJ303)","v":"螺纹孔:M4:8:25"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z304>Z298,#N/A,Z298)","v":6.3105951281788037},null,null,null,"总长",{"$f":"VLOOKUP(AD305,AD300:AE304,2,0)","v":634}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"角度力矩",{"$f":"IF(AB291>=0.965,0.1,AC307)","v":0.5},"总宽",{"$f":"IF($F$53=\"C\",60,AE307)","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z306>=301,1,0.5)","v":1},null,"角度力矩",{"$f":"IF(AB291>=0.866,0.16,AC308)","v":0.5},"总宽",{"$f":"IF($F$53=\"H\",60,151)","v":151}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z306>=301,$C$53>=30),Z306+30,Z309)","v":479},null,"角度力矩",{"$f":"IF(AB291>=0.707,0.28,0.5)","v":0.5},"总宽",{"$f":"VLOOKUP(AD308,AD306:AE307,2,0)","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z306>=301,$C$53<30),Z306+1*($O$5338-1),Z310)","v":479},null,"角度力矩",{"$f":"VLOOKUP(AB309,AB306:AC308,2,0)","v":0.5},"总高",{"$f":"IF($F$53=\"H\",107.5,47)","v":47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z306<301,$C$53>=60),Z306+30,Z311)","v":479},null,"静态扭矩",0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z306<301,$C$53<60),Z306+($O$5338-1)*0.5,Z312)","v":479},null,"扭矩",{"$f":"0.1*AC309*$G$53*$C$53+AC310","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y312,Y308:Z311,2,0)","v":479}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=22.6,Z312+28,Z312+22)","v":507}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y314=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z314/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1",{"$f":"($E$53-$D$53+2*Z339)*($C$53-1)/$I$53/$O$53","v":173.33333333333334},"sin1",{"$f":"AD323/AF323","v":0.42610198761277163},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z324+AD324)","v":191.597322644249}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程1的平方",{"$f":"Z323^2","v":30044.444444444449},"导程的平方",null,"槽高平方",{"$f":"AD323^2","v":6665.0896000000002},null,null,null,null,null,null,null,null,null,null,"CL50","-",{"$f":"$C$53","v":7},"-",{"$f":"$D$53","v":30},"-",{"$f":"$E$53","v":80},"-",{"$f":"$F$53","v":"C"},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$K$53,\"\")","v":""},{"$f":"IF($I$53=1,\"-\",\"\")","v":""},{"$f":"IF($I$53=1,$J$53,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2",{"$f":"($E$53-$D$53+2*Z339)*($C$53-1-$I$53)/$I$53/$O$53","v":115.55555555555556},"sin2",{"$f":"AD325/AF325","v":0.5770198376059601},"槽高",{"$f":"26*3.14","v":81.64},"斜边长",{"$f":"SQRT(Z326+AD326)","v":141.48560357772479},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AO324,AP324,AQ324,AR324,AS324,AT324,AU324,AV324,AW324,AX324,AY324,AZ324,BA324)","v":"CL50-7-30-80-C"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程2的平方",{"$f":"Z325^2","v":13353.086419753086},"导程的平方",null,"槽高平方",{"$f":"AD325^2","v":6665.0896000000002},null,null,null,null,null,null,"零件名称","重量"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"凸轮轴",{"$f":"13*13*3.14*AE328*7.8/1000/1000","v":2.0985480359999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"AB325*$D$53-6-5","v":6.3105951281788037},null,null,null,"凸轮轴长",{"$f":"Z345","v":507},null,"销钉孔间距",{"$f":"IF(AE329>=401,200,AH329)","v":200},null,null,"型材",{"$f":"0.76*AE329/1000","v":0.39291999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z328<=1.8,Z328+1,Z328)","v":6.3105951281788037},null,null,null,"型材长",{"$f":"AE328+10","v":517},null,"销钉孔间距",{"$f":"IF(AE329>=201,150,AH330)","v":150},null,null,"侧板",2.5999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z329<=1.3,#N/A,Z329)","v":6.3105951281788037},null,null,null,null,null,null,"销钉孔间距",{"$f":"IF(AE329>=101,70,50)","v":70},null,null,"固定端",0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB323>0.766,1,Z332)","v":2},null,null,null,"总长",{"$f":"IF(F53=\"C\",V316+18+53,V316+18+35)","v":71},null,"销钉孔间距",{"$f":"VLOOKUP(AG331,AG328:AH330,2,0)","v":200},null,null,"支撑端",0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB323>0.5,1.5,Z333)","v":2},null,null,null,"总高",{"$f":"IF(F53=\"H\",119,62)","v":62},null,"ø4",{"$f":"CONCATENATE(AG332,AG333,AH331)","v":"ø4:200"},null,null,"滑座",{"$f":"0.017*C53","v":0.11900000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB323>0.342,2,Z334)","v":2},null,null,null,"总宽",{"$f":"IF(F53=\"C\",51.6,AE334)","v":51.6},null,":",null,null,null,"电机折连板",{"$f":"AM342*0.094","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB323>0.259,3,Z335)","v":3},null,null,null,"总宽",{"$f":"IF(F53=\"H\",51.6,101.6)","v":101.6},null,null,null,null,null,"电机直连板",{"$f":"AM341*0.047","v":4.7E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"IF(AB323>0.208,5,#N/A)","v":5},null,null,null,"总宽",{"$f":"VLOOKUP(AD335,AD333:AE334,2,0)","v":51.6},null,"螺纹孔","M4",{"$f":"IF(AE329>=400,\"8\",IF(200<AE329<400,\"6\",IF(AE329<=200,\"4\")))","v":"8"},null,"后罩",{"$f":"AM344*0.035","v":3.5000000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"壁厚留余",{"$f":"VLOOKUP(Y336,Y331:Z335,2,0)","v":2},null,null,null,null,null,null,{"$f":"CONCATENATE(AG335,AG333,AH335,AG333,AI335)","v":"螺纹孔:M4:8"},null,null,null,"前罩",{"$f":"AM345*0.091","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"理论壁厚",{"$f":"IF(Z336>Z330,#N/A,Z330)","v":6.3105951281788037},null,null,null,null,null,null,null,null,null,null,"总重",{"$f":"SUM(AL327:AL336)","v":2.798468036}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长不加余量",{"$f":"$E$53*($C$53-1)","v":480},null,"角度力矩",{"$f":"IF(AB323>=0.965,0.1,AC339)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"余量",{"$f":"IF(Z338>=301,1,0.5)","v":1},null,"角度力矩",{"$f":"IF(AB323>=0.866,0.16,AC340)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z338>=301,$C$53>=30),Z338+30,Z341)","v":479},null,"角度力矩",{"$f":"IF(AB323>=0.707,0.2,0.5)","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z338>=301,$C$53<30),Z338+1*($O$5338-1),Z342)","v":479},null,"角度力矩",{"$f":"VLOOKUP(AB341,AB338:AC340,2,0)","v":0.5},null,null,null,null,null,null,null,"电机直连板",null,{"$f":"IF(F53=\"C\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z338<301,$C$53>=60),Z338+30,Z343)","v":479},null,"静态扭矩",0.15,null,null,null,null,null,null,null,"电机折连板",null,{"$f":"IF(F53=\"C\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF(AND(Z338<301,$C$53<60),Z338+($O$5338-1)*0.5,Z344)","v":479},null,"扭矩",{"$f":"AC341+AC342","v":0.65},null,null,null,null,null,null,null,"感应圈",null,{"$f":"IF(J53=\"W\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"VLOOKUP(Y344,Y340:Z343,2,0)","v":479},null,null,null,null,null,null,null,null,null,null,"后罩",null,{"$f":"IF(J53=\"W\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"轴长",{"$f":"IF($D$53>=22.6,Z344+28,Z344+22)","v":507},null,null,null,null,null,null,null,null,null,null,"前罩",null,{"$f":"IF(F53=\"C\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD($C$53,2),\"奇数\",\"偶数\")","v":"奇数"},{"$f":"IF(Y346=\"奇数\",($C$53-1)/2,($C$53-1)/2)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"导程",{"$f":"IF($I$53=2,($E$53-$D$53)*Z346/$O$53,($E$53-$D$53)*($C$53-1)/$O$53)","v":166.66666666666666}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"顺序","系列","本体长度","总长（限制条件）","最少工位数","最多工位数","轴径","最小间距","导轨数量","导轨","滑块","最大间距","角度","单工位负载","电机安装方式","变距方式","传感器固定方式","旋转圈数","导程","理论壁厚（大于0）","扭矩"]
[null,null,1,"80F",{"$f":"($C$53-1)*$E$53","v":480},1500,"3","40",38,23,2,"MGNR7","MGN7",null,{"$f":"$AB$18","v":0.56702351315528732},5,null,1,null,null,{"$f":"$Z$66","v":166.66666666666666},{"$f":"$Z$33","v":6.0504281963843347},{"$f":"$Z$64","v":0.86}]
[null,null,2,"80F",null,null,null,null,null,30,2,"MGNR9","MGN9C",null,0.56702351315528732,10,null,2,null,null,{"$f":"$Z$66","v":166.66666666666666},6.0504281963843347,{"$f":"$Z$64","v":0.86}]
[null,null,3,"80F",null,null,null,null,null,40,2,"MGNR9","MGN9H",null,0.56702351315528732,10,null,null,null,null,{"$f":"$Z$66","v":166.66666666666666},6.0504281963843347,{"$f":"$Z$64","v":0.86}]
[null,null,4,80,{"$f":"($C$53-1)*$E$53","v":480},1500,"3","25",34,12.6,2,"MGNR7","MGN7",null,{"$f":"$AB$70","v":0.5244299276798905},5,null,null,null,null,{"$f":"$Z$97","v":166.66666666666666},{"$f":"$Z$93","v":6.8580107620128814},{"$f":"$AC$97","v":1}]
[null,null,5,80,null,null,null,null,null,23,4,"MGNR7","MGN7",null,0.5244299276798905,5,null,null,null,null,{"$f":"$Z$97","v":166.66666666666666},6.8580107620128814,{"$f":"$AC$97","v":1}]
[null,null,6,80,null,null,null,null,null,30,2,"MGNR9","MGN9C",null,0.5244299276798905,10,null,null,null,null,{"$f":"$Z$97","v":166.66666666666666},6.8580107620128814,{"$f":"$AC$97","v":1}]
[null,null,7,60,{"$f":"($C$53-1)*$E$53","v":480},450,"3","16",26,8.5,2,"MGNR5","MGN5",null,{"$f":"$AB$142","v":0.42610198761277163},1.5,null,null,null,null,{"$f":"$Z$166","v":166.66666666666666},{"$f":"$Z$156","v":6.3105951281788037},{"$f":"$AC$162","v":0.5}]
[null,null,8,60,null,null,null,null,null,16.100000000000001,4,"MGNR5","MGN5",null,0.42610198761277163,1.5,null,null,null,null,{"$f":"$Z$166","v":166.66666666666666},6.3105951281788037,{"$f":"$AC$162","v":0.5}]
[null,null,9,60,null,null,null,null,null,23,2,"MGNR7","MGN7",null,0.42610198761277163,5,null,null,null,null,{"$f":"$Z$166","v":166.66666666666666},6.3105951281788037,{"$f":"$AC$162","v":0.5}]
[null,null,10,40,null,300,"3","8",26,6.5,2,"MGNR5","MGN5",null,null,1]
[null,null,11,50,{"$f":"($C$53-1)*$E$53","v":480},260,"3","10",26,8,2,"MGNR5","MGN5",null,null,0.5]
[null,null,12,"80S",null,1500,"6","40",38,46,2,"MGNR15","MGN15",null,{"$f":"$AB$101","v":0.56702351315528732},20,null,null,null,null,{"$f":"$Z$133","v":166.66666666666666},{"$f":"$Z$114","v":6.0504281963843347},{"$f":"$Z$139","v":0.86}]
[null,null,13,"80S",null,1500,"6","40",38,46,2,"MGNR15","MGN15H",null,{"$f":"$AB$101","v":0.56702351315528732},20,null,null,null,null,{"$f":"$Z$133","v":166.66666666666666},{"$f":"$Z$114","v":6.0504281963843347},{"$f":"$Z$139","v":0.86}]
[null,null,14,"60S",{"$f":"($C$53-1)*$E$53","v":480},600,"8","36",34,7,4,"MGNR5","MGN5",null,{"$f":"$AB$170","v":0.5244299276798905},1.5,null,null,null,null,{"$f":"$Z$190","v":166.66666666666666},{"$f":"$Z$182","v":173.33333333333334},{"$f":"$AC$189","v":0.60000000000000009}]
[null,null,15,"130F",{"$f":"($C$53-1)*$E$53","v":480},2500,"6","40",44,23,2,"MGNR7","MGN7",null,{"$f":"$AB$193","v":0.62330027485348627},5,null,null,null,null,{"$f":"$Z$220","v":166.66666666666666},{"$f":"$Z$201","v":7.5120146595547652},{"$f":"$AC$218","v":1.35}]
[null,null,16,"130F",null,null,null,null,null,30,2,"MGNR9","MGN9C",null,0.62330027485348627,10,null,null,null,null,{"$f":"$Z$220","v":166.66666666666666},7.5120146595547652,{"$f":"$AC$218","v":1.35}]
[null,null,17,"130F",null,null,null,null,null,40,2,"MGNR9","MGN9H",null,0.62330027485348627,10,null,null,null,null,{"$f":"$Z$220","v":166.66666666666666},7.5120146595547652,{"$f":"$AC$218","v":1.35}]
[null,null,18,"130F",null,null,null,null,null,35,2,"MGNR12","MGN12C",null,0.62330027485348627,15,null,null,null,null,{"$f":"$Z$220","v":166.66666666666666},7.5120146595547652,{"$f":"$AC$218","v":1.35}]
[null,null,19,"130F",null,null,null,null,null,46,2,"MGNR12","MGN12H",null,0.62330027485348627,15,null,null,null,null,{"$f":"$Z$220","v":166.66666666666666},7.5120146595547652,{"$f":"$AC$218","v":1.35}]
[null,null,20,"175F",{"$f":"($C$53-1)*$E$53","v":480},2500,"8","45",54,30,2,"MGNR9","MGN9C",null,{"$f":"$AB$226","v":0.78085943289325976},10,null,null,null,null,{"$f":"$Z$254","v":166.66666666666666},{"$f":"$Z$234","v":10.970407859619542},{"$f":"$AC$249","v":1.92}]
[null,null,21,"175F",null,null,null,null,null,40,2,"MGNR9","MGN9H",null,0.78085943289325976,10,null,null,null,null,166.66666666666666,10.970407859619542,1.92]
[null,null,22,"175F",null,null,null,null,null,35,2,"MGNR12","MGN12C",null,0.78085943289325976,15,null,null,null,null,166.66666666666666,10.970407859619542,1.92]
[null,null,23,"175F",null,null,null,null,null,46,2,"MGNR12","MGN12H",null,0.78085943289325976,15,null,null,null,null,166.66666666666666,10.970407859619542,1.92]
[null,null,24,"175F",null,null,null,null,null,45,2,"MGNR15","MGN15C",null,0.78085943289325976,20,null,null,null,null,166.66666666666666,10.970407859619542,1.92]
[null,null,25,"175F",null,null,null,null,null,62,2,"MGNR15","MGN15H",null,0.78085943289325976,20,null,null,null,null,166.66666666666666,10.970407859619542,1.92]
[null,null,26,"230F",{"$f":"($C$53-1)*$E$53","v":480},4000,"10","50",69,45,2,"MGNR15C","MGN15C",null,{"$f":"$AB$258","v":0.78085943289325976},20,null,null,null,null,{"$f":"$Z$286","v":166.66666666666666},{"$f":"$Z$266","v":10.970407859619542},{"$f":"$AC$281","v":1.92}]
[null,null,27,"230F",null,null,null,null,null,62,2,"MGNR15","MGN15H",null,{"$f":"$AB$258","v":0.78085943289325976},20,null,null,null,null,{"$f":"$Z$286","v":166.66666666666666},{"$f":"$Z$266","v":10.970407859619542},{"$f":"$AC$281","v":1.92}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"排序","系列","优点","产品型号","导程","本体长度","总长","总宽","总高","重量（不含电机）","扭矩","底部安装孔与数量","底部销钉孔与间距","滑座安装孔：大小：数量:X方向间距：Y方向间距","滑座销孔大小：数量：Y方向间距","导轨数量","导轨","滑块","SIN","理论壁厚","工位数","角度转换","导轨","长度条件","负载1",null,"轴径","SIN角度","理论壁厚（大于0）","最小间距",null,null,"工位数",null,null,"长度条件","负载1",null,null,"SIN角度","理论壁厚（大于0）","最小间距"]
[null,1,"80F","销量高、精度高",{"$f":"$AB$59","v":"CL80F-7-30-80-C"},{"$f":"$Z$66","v":166.66666666666666},{"$f":"($C$53-1)*$E$53","v":480},{"$f":"$AD$30","v":672},{"$f":"$AD$33","v":94},{"$f":"$AD$39","v":80},{"$f":"$AK$38","v":9.2029332400000001},{"$f":"$Z$64","v":0.86},{"$f":"$AG$85","v":"型材固定螺母:M6:10:48"},{"$f":"$AG$30","v":"ø5:200"},{"$f":"Sheet3!$A$8","v":"M4：4：14：84"},{"$f":"Sheet3!$J$8","v":"M4：2：84"},2,"MGNR7","MGN7",{"$f":"$AB$18","v":0.56702351315528732},{"$f":"$Z$33","v":6.0504281963843347},{"$f":"IF(AND($C$53>3,40>=$C$53),\"A\")","v":"A"},{"$f":"DEGREES(ASIN(T423))","v":34.542925991735892},"MGNR7",{"$f":"IF(1500>=G423,\"A\",\"\")","v":"A"},{"$f":"IF(AND(5>=$G$53),\"A\")","v":"A"},null,38,{"$f":"IF(W423>=15,\"A\",\"\")","v":"A"},{"$f":"IF(U423>=0,\"A\",\"\")","v":"A"},{"$f":"IF(AND($D$53>23,$D$53<=30),\"A\",\"\")","v":"A"},null,null,"A",null,null,"A","A",null,null,"A","A","A"]
[null,2,"80F","销量高、精度高",{"$f":"$AB$59","v":"CL80F-7-30-80-C"},166.66666666666666,480,672,94,80,9.2029332400000001,0.86,{"$f":"$AG$85","v":"型材固定螺母:M6:10:48"},"ø5:200",{"$f":"Sheet3!$A$9","v":"M4：4：20：84"},{"$f":"Sheet3!$J$9","v":"M5：2：84"},2,"MGNR9","MGN9C",{"$f":"$AB$18","v":0.56702351315528732},{"$f":"$Z$33","v":6.0504281963843347},"A",34.542925991735892,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,38,"A","A",{"$f":"IF(AND($D$53>30,$D$53<=40),\"A\",\"\")","v":""}]
[null,3,"80F","销量高、精度高",{"$f":"$AB$59","v":"CL80F-7-30-80-C"},166.66666666666666,480,672,94,80,9.2029332400000001,0.86,"型材固定螺母:M6:10:48","ø5:200",{"$f":"Sheet3!$A$10","v":"M4：4：24：84"},{"$f":"Sheet3!$J$10","v":"M5：2：84"},2,"MGNR9","MGN9H",0.56702351315528732,6.0504281963843347,"A",34.542925991735892,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,38,"A","A",{"$f":"IF($D$53>40,\"A\",\"\")","v":""}]
[null,4,80,"成本低",{"$f":"$AH$71","v":"CL80-7-30-80-C"},{"$f":"$Z$97","v":166.66666666666666},480,{"$f":"$AE$82","v":672},{"$f":"$AE$85","v":80},{"$f":"$AE$91","v":73},{"$f":"$AR$84","v":7.4297577600000002},{"$f":"$AC$97","v":1},"型材固定螺母:M6:10:48","ø5:200",{"$f":"Sheet3!$A$13","v":"M5：2：/：62"},{"$f":"Sheet3!$J$13","v":"M4：2：25"},4,"MGNR7","MGN7",{"$f":"$AB$70","v":0.5244299276798905},{"$f":"$Z$93","v":6.8580107620128814},{"$f":"IF(AND($C$53>3,25>=$C$53),\"A\")","v":"A"},31.629874189776277,"MGNR7","A",{"$f":"IF(5>=$G$53,\"A\")","v":"A"},null,34,"A","A",{"$f":"IF(AND($D$53>16.1,$D$53<=23),\"A\",\"\")","v":""}]
[null,5,80,"成本低",{"$f":"$AH$71","v":"CL80-7-30-80-C"},166.66666666666666,480,672,80,73,{"$f":"$AP$84","v":8.4662382399999991},1,"型材固定螺母:M6:10:48","ø5:200",{"$f":"Sheet3!$A$14","v":"M5：2：/：56"},{"$f":"Sheet3!$J$14","v":"M4：2：50"},2,"MGNR7","MGN7",0.5244299276798905,6.8580107620128814,"A",31.629874189776277,"MGNR7","A","A",null,34,"A","A",{"$f":"IF(AND($D$53>23,$D$53<=30),\"A\",\"\")","v":"A"}]
[null,6,80,"成本低",{"$f":"$AH$71","v":"CL80-7-30-80-C"},166.66666666666666,480,672,80,73,{"$f":"$AN$84","v":8.5887382399999996},1,"型材固定螺母:M6:10:48","ø5:200",{"$f":"Sheet3!$A$15","v":"M4：4：20：52"},{"$f":"Sheet3!$J$15","v":"M4：2：52"},2,"MGNR9","MGN9C",0.5244299276798905,6.8580107620128814,"A",31.629874189776277,"MGNR9","A",{"$f":"IF(10>=$G$53,\"A\")","v":"A"},null,34,"A","A",{"$f":"IF($D$53>30,\"A\",\"\")","v":""}]
[null,7,60,"成本适中、精度高",{"$f":"$AS$142","v":"CL60-7-30-80-C"},{"$f":"$Z$166","v":166.66666666666666},480,{"$f":"$AE$156","v":621},{"$f":"$AE$159","v":60},{"$f":"$AE$160","v":54},{"$f":"$AQ$150","v":3.6517480360000003},{"$f":"$AC$162","v":0.5},{"$f":"$AG$155","v":"螺纹孔:M4:8:40"},{"$f":"$AH$151","v":"ø4:200"},{"$f":"Sheet3!$A$4","v":"M3：2：/：19"},{"$f":"Sheet3!$J$4","v":"M3：2：46"},4,"MGNR5","MGN5",{"$f":"$AB$142","v":0.42610198761277163},{"$f":"$Z$156","v":6.3105951281788037},{"$f":"IF(AND($C$53>3,16>=$C$53),\"A\")","v":"A"},25.220435588917063,"MGNR5",{"$f":"IF(450>=G429,\"A\",\"\")","v":""},{"$f":"IF(AND(1.5>=$G$53),\"A\")","v":"A"},null,26,"A","A",{"$f":"IF(AND($D$53>8.5,$D$53<=16.1),\"A\",\"\")","v":""}]
[null,8,60,"成本适中、精度高",{"$f":"$AS$142","v":"CL60-7-30-80-C"},166.66666666666666,480,621,60,54,{"$f":"$AO$150","v":3.6673980360000002},{"$f":"$AC$162","v":0.5},{"$f":"$AG$155","v":"螺纹孔:M4:8:40"},{"$f":"$AH$151","v":"ø4:200"},{"$f":"Sheet3!$A$5","v":"M3：2：8：44"},{"$f":"Sheet3!$J$5","v":"M4：2：44"},2,"MGNR5","MGN5",{"$f":"$AB$142","v":0.42610198761277163},{"$f":"$Z$156","v":6.3105951281788037},{"$f":"IF(AND($C$53>3,16>=$C$53),\"A\")","v":"A"},25.220435588917063,"MGNR5",{"$f":"IF(450>=G430,\"A\",\"\")","v":""},{"$f":"IF(AND(1.5>=$G$53),\"A\")","v":"A"},null,26,"A","A",{"$f":"IF(AND($D$53>16.1,$D$53<=23),\"A\",\"\")","v":""}]
[null,9,60,"成本适中、精度高",{"$f":"$AS$142","v":"CL60-7-30-80-C"},166.66666666666666,{"$f":"($C$53-1)*$E$53","v":480},621,60,54,{"$f":"$AM$150","v":3.6223980359999999},{"$f":"$AC$162","v":0.5},{"$f":"$AG$155","v":"螺纹孔:M4:8:40"},{"$f":"$AH$151","v":"ø4:200"},{"$f":"Sheet3!$A$6","v":"M3：4：16：36"},{"$f":"Sheet3!$J$6","v":"M4：2：36"},2,"MGNR7","MGN7",{"$f":"$AB$142","v":0.42610198761277163},{"$f":"$Z$156","v":6.3105951281788037},{"$f":"IF(AND($C$53>3,16>=$C$53),\"A\")","v":"A"},{"$f":"DEGREES(ASIN(T431))","v":25.220435588917063},"MGNR7",{"$f":"IF(450>=G431,\"A\",\"\")","v":""},{"$f":"IF(AND(1.5>=$G$53),\"A\")","v":"A"},null,26,{"$f":"IF(W431>=15,\"A\",\"\")","v":"A"},{"$f":"IF(U431>=0,\"A\",\"\")","v":"A"},{"$f":"IF($D$53>23,\"A\",\"\")","v":"A"}]
[null,10,40,"体积小、成本高、负载大",{"$f":"AO293","v":"CL40-7-30-80-C"},166.66666666666666,480,{"$f":"AE305","v":634},{"$f":"AE308","v":60},{"$f":"AE309","v":47},{"$f":"$AL$303","v":3.5623980360000003},{"$f":"AC311","v":0.5},{"$f":"AG304","v":"螺纹孔:M4:8:25"},{"$f":"AH300","v":"ø4:200"},{"$f":"Sheet3!$A$3","v":"M3：2：8：25"},{"$f":"Sheet3!$J$3","v":"M3：2：25"},2,"MGNR5","MGN5",{"$f":"$AB$291","v":0.42610198761277163},{"$f":"$Z$298","v":6.3105951281788037},{"$f":"IF(AND($C$53>3,8>=$C$53),\"A\")","v":"A"},25.220435588917063,"MGNR5",{"$f":"IF(300>=G432,\"A\",\"\")","v":""},{"$f":"IF(1>=$G$53,\"A\")","v":"A"},null,26,"A","A",{"$f":"IF(AND($D$53>6.5,$D$53<=8),\"A\",\"\")","v":""}]
[null,11,50,"成本低",{"$f":"AO325","v":"CL50-7-30-80-C"},{"$f":"$Z$347","v":166.66666666666666},480,{"$f":"$AE$331","v":71},{"$f":"$AE$335","v":51.6},{"$f":"$AE$332","v":62},{"$f":"$AL$303","v":3.5623980360000003},{"$f":"$AC$343","v":0.65},{"$f":"M432","v":"螺纹孔:M4:8:25"},{"$f":"N432","v":"ø4:200"},"M3：2：/：42","M3：2：32",2,"导杆","导杆",{"$f":"AB323","v":0.42610198761277163},{"$f":"Z337","v":6.3105951281788037},{"$f":"IF(AND($C$53>3,10>=$C$53),\"A\")","v":"A"},25.220435588917063,"MGNR5",{"$f":"IF(260>=G433,\"A\",\"\")","v":""},{"$f":"IF(0.5>=$G$53,\"A\")","v":false},null,26,"A","A",{"$f":"IF($D$53>8,\"A\",\"\")","v":"A"}]
[null,12,"80S","负载大",{"$f":"$AH$102","v":"CL80S-7-30-80-C"},{"$f":"$Z$133","v":166.66666666666666},480,{"$f":"$AD$114","v":684},{"$f":"$AD$117","v":90},{"$f":"$AD$118","v":78.5},{"$f":"$AK$112","v":9.0506815839999994},{"$f":"$Z$139","v":0.86},{"$f":"$AF$117","v":"型材固定螺母:M6:10:48"},{"$f":"$AG$113","v":"ø5:200"},{"$f":"Sheet3!$A$11","v":"M5：4：20：60"},{"$f":"Sheet3!$J$11","v":"M6：2：50"},2,"MGNR15","MGN15",{"$f":"$AB$101","v":0.56702351315528732},{"$f":"$Z$114","v":6.0504281963843347},{"$f":"IF(AND($C$53>6,40>=$C$53),\"A\")","v":"A"},34.542925991735892,"MGNR15",{"$f":"IF(1500>=G434,\"A\",\"\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},null,38,"A","A",{"$f":"IF(AND($D$53>45,$D$53<=62),\"A\",\"\")","v":""}]
[null,13,"80S","负载大",{"$f":"$AH$102","v":"CL80S-7-30-80-C"},{"$f":"$Z$133","v":166.66666666666666},480,{"$f":"$AD$114","v":684},{"$f":"$AD$117","v":90},{"$f":"$AD$118","v":78.5},{"$f":"$AK$112","v":9.0506815839999994},{"$f":"$Z$139","v":0.86},{"$f":"$AF$117","v":"型材固定螺母:M6:10:48"},{"$f":"$AG$113","v":"ø5:200"},{"$f":"Sheet3!$A$12","v":"M5：4：50：60"},{"$f":"Sheet3!$J$12","v":"M6：2：50"},2,"MGNR15","MGN15",{"$f":"$AB$101","v":0.56702351315528732},{"$f":"$Z$114","v":6.0504281963843347},{"$f":"IF(AND($C$53>6,40>=$C$53),\"A\")","v":"A"},34.542925991735892,"MGNR15",{"$f":"IF(1500>=G435,\"A\",\"\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},null,38,"A","A",{"$f":"IF($D$53>62,\"A\",\"\")","v":""}]
[null,14,"60S","成本高、间距小",{"$f":"AH171","v":"CL60S-7-30-80-C"},{"$f":"$Z$190","v":166.66666666666666},{"$f":"($C$53-1)*$E$53","v":480},{"$f":"AE184","v":628},{"$f":"AE187","v":82},{"$f":"AE188","v":73.5},{"$f":"$AL$181","v":5.5862747579999992},{"$f":"$AC$189","v":0.60000000000000009},{"$f":"$AG$183","v":"螺纹孔:M4:8:40"},{"$f":"$AH$179","v":"ø4:200"},{"$f":"Sheet3!$A$7","v":"M3：2：/：19"},{"$f":"Sheet3!$J$7","v":"M3：2：46"},4,"MGNR5","MGN5",{"$f":"$AB$170","v":0.5244299276798905},{"$f":"$Z$182","v":173.33333333333334},{"$f":"IF(AND($C$53>8,36>=$C$53),\"A\")","v":false},{"$f":"DEGREES(ASIN(T436))","v":31.629874189776277},"MGNR5",{"$f":"IF(600>=G436,\"A\",\"\")","v":"A"},{"$f":"IF(1.5>=$G$53,\"A\")","v":"A"},null,34,{"$f":"IF(W436>=15,\"A\",\"\")","v":"A"},{"$f":"IF(U436>=0,\"A\",\"\")","v":"A"},{"$f":"IF($D$53>7,\"A\",\"\")","v":"A"}]
[null,15,"130F",null,{"$f":"$AH$194","v":"CL130F-7-30-80-C"},{"$f":"$Z$220","v":166.66666666666666},480,{"$f":"$AC$200","v":635},{"$f":"$AC$203","v":150},{"$f":"$AC$204","v":93},{"$f":"$AJ$211","v":11.957633000036978},{"$f":"$AC$218","v":1.35},null,{"$f":"$AG$211","v":"ø8:200"},{"$f":"Sheet3!$A$16","v":"M4：2：14：125"},{"$f":"Sheet3!$J$16","v":"M4：2：125"},2,"MGNR7","MGN7",{"$f":"$AB$193","v":0.62330027485348627},{"$f":"$Z$201","v":7.5120146595547652},{"$f":"IF(AND($C$53>6,40>=$C$53),\"A\")","v":"A"},38.557540606537039,"MGNR7",{"$f":"IF(2500>=G437,\"A\",\"\")","v":"A"},{"$f":"IF(AND(5>=$G$53),\"A\")","v":"A"},null,44,"A","A",{"$f":"IF(AND($D$53>23,$D$53<=30),\"A\",\"\")","v":"A"}]
[null,16,"130F",null,{"$f":"$AH$194","v":"CL130F-7-30-80-C"},166.66666666666666,480,635,150,93,{"$f":"$AJ$211","v":11.957633000036978},1.35,null,{"$f":"$AG$211","v":"ø8:200"},{"$f":"Sheet3!$A$17","v":"M4：2：15：125"},{"$f":"Sheet3!$J$17","v":"M4：2：125"},2,"MGNR9","MGN9C",0.62330027485348627,7.5120146595547652,"A",38.557540606537039,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,44,"A","A",{"$f":"IF(AND($D$53>30,$D$53<=40),\"A\",\"\")","v":""}]
[null,17,"130F",null,{"$f":"$AH$194","v":"CL130F-7-30-80-C"},166.66666666666666,480,635,150,93,{"$f":"$AJ$211","v":11.957633000036978},1.35,null,{"$f":"$AG$211","v":"ø8:200"},{"$f":"Sheet3!$A$18","v":"M4：2：28：125"},{"$f":"Sheet3!$J$18","v":"M4：2：125"},2,"MGNR9","MGN9H",0.62330027485348627,7.5120146595547652,"A",38.557540606537039,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,44,"A","A",{"$f":"IF($D$53>40,\"A\",\"\")","v":""}]
[null,18,"130F",null,{"$f":"$AH$194","v":"CL130F-7-30-80-C"},166.66666666666666,480,635,150,93,{"$f":"$AJ$211","v":11.957633000036978},1.35,null,{"$f":"$AG$211","v":"ø8:200"},{"$f":"Sheet3!$A$19","v":"M4：2：20：125"},{"$f":"Sheet3!$J$19","v":"M4：2：125"},2,"MGNR12","MGN12C",0.62330027485348627,7.5120146595547652,"A",38.557540606537039,"MGNR12","A",{"$f":"IF(AND(15>=$G$53),\"A\")","v":"A"},null,44,"A","A",{"$f":"IF(AND($D$53>35,$D$53<=46),\"A\",\"\")","v":""}]
[null,19,"130F",null,{"$f":"$AH$194","v":"CL130F-7-30-80-C"},166.66666666666666,480,635,150,93,{"$f":"$AJ$211","v":11.957633000036978},1.35,null,{"$f":"$AG$211","v":"ø8:200"},{"$f":"Sheet3!$A$20","v":"M4：2：28：125"},{"$f":"Sheet3!$J$20","v":"M4：2：125"},2,"MGNR12","MGN12H",0.62330027485348627,7.5120146595547652,"A",38.557540606537039,"MGNR12","A",{"$f":"IF(AND(15>=$G$53),\"A\")","v":"A"},null,44,"A","A",{"$f":"IF($D$53>46,\"A\",\"\")","v":""}]
[null,20,"175F",null,{"$f":"$AN$227","v":"CL175F-7-30-80-C"},{"$f":"$Z$254","v":166.66666666666666},480,{"$f":"$AC$239","v":675},{"$f":"$AC$238","v":200},{"$f":"$AC$233","v":123.5},{"$f":"$AK$239","v":37.490926969041752},{"$f":"$AC$249","v":1.92},null,{"$f":"$AE$238","v":"ø8:200"},{"$f":"Sheet3!$A$21","v":"M5：2：16：185"},{"$f":"Sheet3!$J$21","v":"M5：2：185"},2,"MGNR9","MGN9C",{"$f":"$AB$226","v":0.78085943289325976},{"$f":"$Z$234","v":10.970407859619542},{"$f":"IF(AND($C$53>8,45>=$C$53),\"A\")","v":false},51.339331755598515,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF(AND($D$53>30,$D$53<=40),\"A\",\"\")","v":""}]
[null,21,"175F",null,"CL175F-7-30-80-C",166.66666666666666,480,675,200,123.5,37.490926969041752,1.92,null,"ø8:200",{"$f":"Sheet3!$A$22","v":"M5：2：24：185"},{"$f":"Sheet3!$J$22","v":"M5：2：185"},2,"MGNR9","MGN9H",0.78085943289325976,10.970407859619542,false,51.339331755598515,"MGNR9","A",{"$f":"IF(AND(10>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF($D$53>40,\"A\",\"\")","v":""}]
[null,22,"175F",null,"CL175F-7-30-80-C",166.66666666666666,480,675,200,123.5,37.490926969041752,1.92,null,"ø8:200",{"$f":"Sheet3!$A$23","v":"M5：2：22：185"},{"$f":"Sheet3!$J$23","v":"M5：2：185"},2,"MGNR12","MGN12C",0.78085943289325976,10.970407859619542,false,51.339331755598515,"MGNR12","A",{"$f":"IF(AND(15>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF(AND($D$53>35,$D$53<=46),\"A\",\"\")","v":""}]
[null,23,"175F",null,"CL175F-7-30-80-C",166.66666666666666,480,675,200,123.5,37.490926969041752,1.92,null,"ø8:200",{"$f":"Sheet3!$A$24","v":"M5：2：34：185"},{"$f":"Sheet3!$J$24","v":"M5：2：185"},2,"MGNR12","MGN12H",0.78085943289325976,10.970407859619542,false,51.339331755598515,"MGNR12","A",{"$f":"IF(AND(15>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF($D$53>46,\"A\",\"\")","v":""}]
[null,24,"175F",null,"CL175F-7-30-80-C",166.66666666666666,480,675,200,123.5,37.490926969041752,1.92,null,"ø8:200",{"$f":"Sheet3!$A$25","v":"M6：2：32：185"},{"$f":"Sheet3!$J$25","v":"M6：2：185"},2,"MGNR15","MGN15C",0.78085943289325976,10.970407859619542,false,51.339331755598515,"MGNR15","A",{"$f":"IF(AND(20>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF(AND($D$53>45,$D$53<=62),\"A\",\"\")","v":""}]
[null,25,"175F",null,"CL175F-7-30-80-C",166.66666666666666,480,675,200,123.5,37.490926969041752,1.92,null,"ø8:200",{"$f":"Sheet3!$A$26","v":"M6：2：48：185"},{"$f":"Sheet3!$J$26","v":"M6：2：185"},2,"MGNR15","MGN15H",0.78085943289325976,10.970407859619542,false,51.339331755598515,"MGNR15","A",{"$f":"IF(AND(20>=$G$53),\"A\")","v":"A"},null,54,"A","A",{"$f":"IF($D$53>62,\"A\",\"\")","v":""}]
[null,26,"230F",null,{"$f":"$AO$259","v":"CL230F-7-30-80-C"},{"$f":"$Z$286","v":166.66666666666666},480,{"$f":"$AF$287","v":670},{"$f":"$AF$280","v":250},{"$f":"$AF$283","v":152.5},{"$f":"$AL$272","v":44.969919757143728},{"$f":"$AC$281","v":1.92},null,{"$f":"$AC$273","v":"ø8:200"},{"$f":"Sheet3!$A$27","v":"M6：2：32：215"},{"$f":"Sheet3!$J$27","v":"M6：2：215"},2,"MGNR15C","MGN15C",{"$f":"$AB$258","v":0.78085943289325976},{"$f":"$Z$266","v":10.970407859619542},{"$f":"IF(AND($C$53>10,50>=$C$53),\"A\")","v":false},51.339331755598515,"MGNR15C",{"$f":"IF(4000>=G448,\"A\",\"\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},null,69,"A","A",{"$f":"IF(AND($D$53>45,$D$53<=62),\"A\",\"\")","v":""}]
[null,27,"230F",null,{"$f":"$AO$259","v":"CL230F-7-30-80-C"},{"$f":"$Z$286","v":166.66666666666666},480,{"$f":"$AF$287","v":670},{"$f":"$AF$280","v":250},{"$f":"$AF$283","v":152.5},{"$f":"$AL$272","v":44.969919757143728},{"$f":"$AC$281","v":1.92},null,{"$f":"$AC$273","v":"ø8:200"},{"$f":"Sheet3!$A$28","v":"M6：2：48：215"},{"$f":"Sheet3!$J$28","v":"M6：2：215"},2,"MGNR15","MGN15H",{"$f":"$AB$258","v":0.78085943289325976},{"$f":"$Z$266","v":10.970407859619542},{"$f":"IF(AND($C$53>10,50>=$C$53),\"A\")","v":false},51.339331755598515,"MGNR15",{"$f":"IF(4000>=G449,\"A\",\"\")","v":"A"},{"$f":"IF(20>=$G$53,\"A\")","v":"A"},null,69,"A","A",{"$f":"IF($D$53>62,\"A\",\"\")","v":""}]
[]
[]
[]
[]
[null,"排序","系列","产品型号","导程","本体长度","总长","总宽","总高","重量（不含电机）","扭矩","底部安装孔与数量","底部销钉孔与间距","滑座安装孔：大小：数量:X方向间距：Y方向间距","滑座销孔大小：数量：Y方向间距","导轨数量","导轨","滑块","SIN","理论壁厚","工位数","角度转换","导轨","长度条件","负载1",null,"轴径","SIN角度","理论壁厚（大于0）","最小间距"]
[null,3,"80F","CL80F-4-50-60-C",16.6666666666667,180,379.5,94,80,4.6169917299999996,0.73,"型材固定螺母:M6:6:48","ø5:100","M4：4：24：84","M5：2：84",2,"MGNR9","MGN9H",0.98840104694931996,34.434551377793603,"A",81.264903621314701,"MGNR9","A","A",null,38,"A","A","A"]
[null,6,80,"CL80-4-50-60-C",16.6666666666667,180,367.5,80,73,4.2067923860000001,0.73,"型材固定螺母:M6:6:48","ø5:100","M4：4：20：52","M4：2：52",2,"MGNR9","MGN9C",0.98557360314180698,36.418285790915903,"A",80.2559374555712,"MGNR9","A","A",null,34,"A","A","A"]
[null,9,60,"CL60-4-50-60-C",16.6666666666667,180,321.5,60,54,1.6457982099999999,0.19,"螺纹孔:M4:FALSE:40","ø4:150","M3：4：16：36","M4：2：36",2,"MGNR7","MGN7",0.97570095917854704,38.860506498678703,"A",77.343443819455103,"MGNR7","A","A",null,26,"A","A","A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"排序","系列","优点","产品型号","导程","本体长度","总长","总宽","总高","重量（不含电机）","扭矩","底部安装孔与数量","底部销钉孔与间距","滑座安装孔：大小：数量:X方向间距：Y方向间距","滑座销孔大小：数量：Y方向间距","导轨数量","导轨","滑块","SIN","理论壁厚","工位数","角度转换","导轨","长度条件","负载1",null,"轴径","SIN角度","理论壁厚（大于0）","最小间距"]
[null,1,"80F","销量高、精度高","CL80F-7-30-80-C",166.66666666666666,480,672,94,80,9.2029332400000001,0.86,"型材固定螺母:M6:10:48","ø5:200","M4：4：14：84","M4：2：84",2,"MGNR7"]
[null,5,80,"成本低","CL80-7-30-80-C",166.66666666666666,480,672,80,73,8.4662382399999991,1,"型材固定螺母:M6:10:48","ø5:200","M5：2：/：56","M4：2：50",2,"MGNR7"]
[null,15,"130F",null,"CL130F-7-30-80-C",166.66666666666666,480,635,150,93,11.957633000036978,1.35,null,"ø8:200","M4：2：14：125","M4：2：125",2,"MGNR7"]

{"sheet":"sin","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["三角函数","sIN","cos","TAN","三角函数","sIN","cos","TAN"]
["o","o",1,"o","9o*",1,"o","无"]
[1,1.7399999999999999E-2,0.99980000000000002,1.7399999999999999E-2,"89*",0.99980000000000002,1.7399999999999999E-2,57.289900000000003]
[2,3.4799999999999998E-2,0.99929999999999997,3.49E-2,88,0.99929999999999997,3.4799999999999998E-2,28.636199999999999]
[3,5.2299999999999999E-2,0.99860000000000004,5.2400000000000002E-2,"87\"","o.9986",5.2299999999999999E-2,19.081099999999999]
[4,"o.0697","o.9975","o.0699",86,"o.9975",6.9699999999999998E-2,14.300599999999999]
[5,"o.0871","o.9961",8.7400000000000005E-2,"85*",0.99609999999999999,"o.0871",11.43]
[6,"o.1045","o.9945",0.1051,84,0.99450000000000005,0.1045,9.5143000000000004]
[7,0.12180000000000001,"o.9925",0.1227,83,"o.9925",0.12180000000000001,8.1442999999999994]
["8*",0.1391,0.99019999999999997,0.14050000000000001,"82*",0.99019999999999997,0.1391,7.1153000000000004]
["g",0.15640000000000001,0.98760000000000003,0.1583,81,"o.9876",0.15640000000000001,6.3136999999999999]
["10*",0.1736,0.98480000000000001,0.17630000000000001,"8o*",0.98480000000000001,0.1736,5.6711999999999998]
[11,0.1908,0.98160000000000003,0.1943,"79*",0.98160000000000003,0.1908,5.1444999999999999]
["12*",0.2079,0.97809999999999997,0.21249999999999999,"78*",0.97809999999999997,0.2079,4.7046000000000001]
[13,0.22489999999999999,"o.9743",0.23080000000000001,77,0.97430000000000005,0.22489999999999999,4.3314000000000004]
[14,0.2419,0.97019999999999995,0.24929999999999999,76,"o.9702",0.2419,4.0106999999999999]
["15*",0.25879999999999997,0.96589999999999998,0.26790000000000003,75,0.96589999999999998,0.25879999999999997,3.7320000000000002]
["16\"",0.27560000000000001,0.96120000000000005,0.28670000000000001,74,0.96120000000000005,0.27560000000000001,3.4874000000000001]
[17,0.2923,0.95630000000000004,0.30570000000000003,"73*",0.95630000000000004,0.2923,3.2707999999999999]
[18,0.309,0.95099999999999996,0.32490000000000002,"72*",0.95099999999999996,"o.3o9o",3.0775999999999999]
[19,0.32550000000000001,0.94550000000000001,0.34429999999999999,71,0.94550000000000001,0.32550000000000001,2.9041999999999999]
["2o*",0.34200000000000003,0.93959999999999999,0.3639,"7o",0.93959999999999999,0.34200000000000003,2.7473999999999998]
[21,0.35830000000000001,0.9335,0.38379999999999997,"69\"",0.9335,0.35830000000000001,2.605]
["22'",0.37459999999999999,0.92710000000000004,0.40400000000000003,68,0.92710000000000004,0.37459999999999999,2.4750000000000001]
[23,0.39069999999999999,0.92049999999999998,0.4244,67,0.92049999999999998,0.39069999999999999,2.3557999999999999]
[24,0.40670000000000001,0.91349999999999998,0.44519999999999998,"66*",0.91349999999999998,0.40670000000000001,2.246]
["25*",0.42259999999999998,0.90629999999999999,0.46629999999999999,"65*",0.90629999999999999,0.42259999999999998,2.1444999999999999]
["26*",0.43830000000000002,"o.8987",0.48770000000000002,64,0.89870000000000005,0.43830000000000002,2.0503]
[27,0.45390000000000003,0.89100000000000001,0.50949999999999995,"63\"","o.8910",0.45390000000000003,1.9625999999999999]
[28,0.46939999999999998,"o.8829",0.53169999999999995,"62*","o.8829",0.46939999999999998,1.8807]
[29,0.48480000000000001,"o.8746",0.55430000000000001,61,0.87460000000000004,0.48480000000000001,1.804]
["3o",0.5,0.86599999999999999,0.57730000000000004,"6o*","o.8660",0.5,1.732]
[31,0.51500000000000001,0.85709999999999997,0.6008,"59\"",0.85709999999999997,0.51500000000000001,1.6641999999999999]
["32*",0.52990000000000004,0.84799999999999998,0.62480000000000002,58,0.84799999999999998,0.52990000000000004,1.6003000000000001]
[33,0.54459999999999997,0.83860000000000001,0.64939999999999998,"57\"",0.83860000000000001,0.54459999999999997,1.5398000000000001]
[34,0.55910000000000004,0.82899999999999996,0.67449999999999999,"56*",0.82899999999999996,0.55910000000000004,1.4824999999999999]
[35,0.57350000000000001,0.81910000000000005,0.70020000000000004,"55*",0.81910000000000005,0.57350000000000001,1.4280999999999999]

{"sheet":"Sheet3","index":2,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,8]]}
[null,null,"螺纹孔",null,null,null,"销钉孔"]
[null,"：","大小","数量","X间距","Y间距","大小","数量","Y间距"]
[{"$f":"CONCATENATE(C3,$B$2,D3,$B$2,E3,$B$2,F3)","v":"M3：2：8：25"},"CL40-03M-D5C-M3-00","M3",2,8,25,"M3",2,25,{"$f":"CONCATENATE(G3,$B$2,H3,$B$2,I3)","v":"M3：2：25"}]
["M3：2：/：19","CL60-03M-S5C-M3-00","M3",2,"/",19,"M3",2,46,{"$f":"CONCATENATE(G4,$B$2,H4,$B$2,I4)","v":"M3：2：46"}]
["M3：2：8：44","CL60-03M-D5C-M3-00","M3",2,8,44,"M4",2,44,"M4：2：44"]
["M3：4：16：36","CL60-03M-D7C-M3-00","M3",4,16,36,"M4",2,36,"M4：2：36"]
["M3：2：/：19","CL60S-03M-S5C-M3-00","M3",2,"/",19,"M3",2,46,"M3：2：46"]
["M4：4：14：84","CL80F-03M-D7C-M3-01","M4",4,14,84,"M4",2,84,"M4：2：84"]
[{"$f":"CONCATENATE(C9,$B$2,D9,$B$2,E9,$B$2,F9)","v":"M4：4：20：84"},"CL80F-03M-D9C-M5-01","M4",4,20,84,"M5",2,84,"M5：2：84"]
["M4：4：24：84","CL80F-03M-D9HC-M4-01","M4",4,24,84,"M5",2,84,{"$f":"CONCATENATE(G10,$B$2,H10,$B$2,I10)","v":"M5：2：84"}]
["M5：4：20：60","CL80S-03M-D15C-M4-01","M5",4,20,60,"M6",2,50,"M6：2：50"]
["M5：4：50：60","CL80S-03M-D15HW-M4-01","M5",4,50,60,"M6",2,50,"M6：2：50"]
["M5：2：/：62","CL80-03M-S7C-M4-00","M5",2,"/",62,"M4",2,25,"M4：2：25"]
["M5：2：/：56","CL80-03M-D7C-M3-00","M5",2,"/",56,"M4",2,50,"M4：2：50"]
["M4：4：20：52","CL80-03M-D9C-M4-00","M4",4,20,52,"M4",2,52,"M4：2：52"]
["M4：2：14：125","CL130F-03M-D7C-M4-03","M4",2,14,125,"M4",2,125,"M4：2：125"]
["M4：2：15：125","CL130F-03M-D9C-M4-03","M4",2,15,125,"M4",2,125,"M4：2：125"]
["M4：2：28：125","CL130F-03M-D9HC-M4-03","M4",2,28,125,"M4",2,125,"M4：2：125"]
[{"$f":"CONCATENATE(C19,$B$2,D19,$B$2,E19,$B$2,F19)","v":"M4：2：20：125"},"CL130F-03M-D12C-M4-03","M4",2,20,125,"M4",2,125,"M4：2：125"]
["M4：2：28：125","CL130F-03M-D12HC-M4-03","M4",2,28,125,"M4",2,125,{"$f":"CONCATENATE(G20,$B$2,H20,$B$2,I20)","v":"M4：2：125"}]
["M5：2：16：185","CL175F-03M-D9C-M4-02","M5",2,16,185,"M5",2,185,"M5：2：185"]
["M5：2：24：185","CL175F-03M-D9HC-M4-02","M5",2,24,185,"M5",2,185,"M5：2：185"]
["M5：2：22：185","CL175F-03M-D12C-M5-02","M5",2,22,185,"M5",2,185,"M5：2：185"]
["M5：2：34：185","CL175F-03M-D12HC-M4-02","M5",2,34,185,"M5",2,185,"M5：2：185"]
["M6：2：32：185","CL175F-03M-D15C-M4-02","M6",2,32,185,"M6",2,185,"M6：2：185"]
["M6：2：48：185","CL175F-03M-D15HC-M4-02","M6",2,48,185,"M6",2,185,"M6：2：185"]
["M6：2：32：215","CL230F-03M-D15C-M4-01","M6",2,32,215,"M6",2,215,"M6：2：215"]
["M6：2：48：215","CL230F-03M-D15HC-M5-01","M6",2,48,215,"M6",2,215,"M6：2：215"]