{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["说明","自动计算","抽芯测试数据库","拓钢查询表","参数"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"说明","index":0,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,19]]}
["压力测试箱的使用说明"]
[]
["压力测试箱的工作原理：通过改变压铸机通向油缸前腔的压力，调节油缸抽拔力，从而得到油缸抽拔滑块实际所需要的力。"]
["压力测试箱的用处：用实验的方法检验滑块的实际抽拔力。"]
["计算表的用处：简便计算，输入必须的数据返回结果。并保存数据。对以后的设计便于查询类似模具所使用油缸的实际出力。长期记录，分析数据寻找滑块出力的内在联系。"]
["注1：此表格需要启用宏，否则无法计算并且无法保存数据。"]
["注2：此表格是在excel2013版下制作，请尽量使用07以上版本的excel。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"用来读取现在所调节的压力值"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"通过手轮调节油缸前腔油压，从而改变油缸的出力"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"通过读取的值，结合所使用的油缸，查上表，得到油缸实际出力值"]

{"sheet":"自动计算","index":1,"n_rows":22,"n_cols":45,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,0,9,0],[11,0,21,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,null,"测试日期","测试人员","模具编号","滑块位置","测试压铸机品牌","测试压铸机规格","测试油缸品牌","测试油缸标称吨位","抽芯有效周长(mm)","抽芯有效长度(mm)","抽芯拔模斜度(0)","理论抽芯力(T)","预热次数","预热平均","常压次数","常压平均","增压次数","增压平均","建议吨位"]
[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":"C3","v":"2023-06-29"},{"$f":"E3","v":"周杰伦"},{"$f":"C5","v":"JL-2457"},{"$f":"E5","v":"上滑块"},{"$f":"C6","v":"力劲"},{"$f":"E6","v":"1250T"},{"$f":"C7","v":"拓钢油缸"},{"$f":"E7","v":"13T"},{"$f":"C9","v":78.5},{"$f":"E9","v":80},{"$f":"C10","v":0.5},{"$f":"E10","v":1.8},{"$f":"AB19","v":0},{"$f":"AC19","v":0},{"$f":"AB20","v":0},{"$f":"AC20","v":{"$error":"#DIV/0!"}},{"$f":"AB21","v":0},{"$f":"AC21","v":0},{"$f":"AD16","v":{"$error":"#DIV/0!"}}]
["基础数据录入","测试日期",{"$f":"TODAY()","v":"2023-06-29"},"测试人员","周杰伦"]
[]
[null,"模具编号","JL-2457","滑块位置","上滑块"]
[null,"测试压铸机品牌","力劲","测试压铸机规格","1250T"]
[null,"测试油缸品牌","拓钢油缸","测试油缸标称吨位","13T"]
[]
[null,"抽芯有效周长(mm)",78.5,"抽芯有效长度(mm)",80]
[null,"抽芯拔模斜度(0)",0.5,"理论抽芯力(T)",{"$f":"ROUND((0.25*COS(RADIANS(C10))-SIN(RADIANS(C10)))*C9*E9*12/10000,1)","v":1.8}]
[]
["测试数据录入","序号","压铸阶段","测试压力(Mpa)","实际抽芯力(T)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"次数","平均抽芯力","建议使用油缸"]
[null,1,null,null,{"$f":"IF(D13<>\"\",ROUND(D13*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"预热",{"$f":"COUNTIF($C$13:$C$22,AA13)","v":0},{"$f":"ROUND(AVERAGEIF($C$13:$C$22,AA13,$E$13:$E$22)*10,0)/10","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,{"$f":"IF(D14<>\"\",ROUND(D14*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"常压",{"$f":"COUNTIF($C$13:$C$22,AA14)","v":0},{"$f":"ROUND(AVERAGEIF($C$13:$C$22,AA14,$E$13:$E$22)*10,0)/10","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(AC14,参数!F3:G14,2)","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,{"$f":"IF(D15<>\"\",ROUND(D15*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"增压",0,{"$error":"#DIV/0!"},{"$f":"VLOOKUP(AC15,参数!F4:G15,2)","v":{"$error":"#DIV/0!"}}]
[null,4,null,null,{"$f":"IF(D16<>\"\",ROUND(D16*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","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,{"$f":"IF(AB15<>0,IF(AC15>AC14,AD15,AD14),AD14)","v":{"$error":"#DIV/0!"}}]
[null,5,null,null,{"$f":"IF(D17<>\"\",ROUND(D17*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""}]
[null,6,null,null,{"$f":"IF(D18<>\"\",ROUND(D18*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"次数","平均抽芯力","建议使用油缸"]
[null,7,null,null,{"$f":"IF(D19<>\"\",ROUND(D19*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"预热",{"$f":"IF(AB13<>0,AB13,0)","v":0},{"$f":"IF(AB13<>0,AC13,0)","v":0},null,{"$f":"AB19=\"\"","v":false}]
[null,8,null,null,{"$f":"IF(D20<>\"\",ROUND(D20*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"常压",{"$f":"IF(AB14<>0,AB14,0)","v":0},{"$f":"IF(AC14<>0,AC14,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AD14<>0,AD14,\"\")","v":{"$error":"#DIV/0!"}},false]
[null,9,null,null,{"$f":"IF(D21<>\"\",ROUND(D21*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"增压",{"$f":"IF(AB15<>0,AB15,0)","v":0},{"$f":"IF(AB15<>0,AC15,0)","v":0},{"$f":"IF(AB15<>0,AD15,0)","v":0},{"$f":"AB21=\"\"","v":false}]
[null,10,null,null,{"$f":"IF(D22<>\"\",ROUND(D22*IF($C$7=\"拓钢油缸\",VLOOKUP($E$7,参数!$A$3:$E$13,5,0),VLOOKUP($E$7,参数!$A$15:$E$26,5,0))/10000,1),\"\")","v":""}]

{"sheet":"抽芯测试数据库","index":2,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["测试日期","测试人员","模具编号","滑块位置","测试压铸机品牌","测试压铸机规格","测试油缸品牌","测试油缸标称吨位","抽芯有效周长(mm)","抽芯有效长度(mm)","抽芯拔模斜度(0)","理论抽芯力(T)","预热次数","预热平均","常压次数","常压平均","增压次数","增压平均","建议吨位"]

{"sheet":"拓钢查询表","index":3,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,14],[1,0,1,14],[2,1,3,1],[2,2,2,14]]}
["进油口（接油缸前腔）",null,"直流24V（选一个电源）",null,null,"油压表","出油口（接压铸机油箱）",null,null,null,"交流220V",null,"压力旋钮（高——低）"]
["抽芯力查询表"]
["拓钢油缸     标称吨位","正常12mpa   出力","调试压力（Mpa)     "]
["缸径*杆径",null,2,3,4,5,6,7,8,9,10,11,12,13,14]
["3T      70*32","3.7T","0.6T","0.9T","1.2T","1.5T","1.8T","2.1T","2.4T","2.7T","3T","3.3T","3.7T","4T","4.3T"]
["4T       80*35","4.9T","0.8T","1.2T","1.6T","2T","2.4T","2.8T","3.2T","3.7T","4.1T","4.5T","4.9T","5.3T","5.7T"]
["5T       90*45","5.7T","1T","1.4T","1.9T","2.4T","2.9T","3.3T","3.8T","4.3T","4.8T","5.2T","5.7T","6.2T","6.7T"]
["6.5T    100*45","7.5T","1.3T","1.9T","2.5T","3.1T","3.8T","4.4T","5T","5.6T","6.3T","6.9T","7.5T","8.1T","8.8T"]
["8T       110*50","9T","1.5T","2.3T","3T","3.8T","4.5T","5.3T","6T","6.8T","7.5T","8.3T","9T","9.8T","10.6T"]
["10T    125*55","11.9T","2T","3T","4T","4.9T","5.9T","6.9T","7.9T","8.9T","9.9T","10.9T","11.9T","12.9T","13.8T"]
["13T    140*60","15.1T","2.5T","3.8T","5T","6.3T","7.5T","8.8T","10T","11.3T","12.6T","13.8T","15.1T","16.3T","17.6T"]
["16T    160*70","19.5T","3.2T","4.9T","6.5T","8.1T","9.7T","11.4T","13T","14.6T","16.2T","17.9T","19.5T","21.1T","22.7T"]
["20T    180*75","25.2T","4.2T","6.3T","8.4T","10.5T","12.6T","14.7T","16.8T","18.9T","21T","23.1T","25.2T","27.3T","29.4T"]
["25T    200*80","31.7T","5.3T","7.9T","10.6T","13.2T","15.8T","18.5T","21.1T","23.7T","26.4T","29T","31.7T","34.3T","36.9T"]
["30T    220*90","38T","6.3T","9.5T","12.7T","15.8T","19T","22.1T","25.3T","28.5T","31.6T","34.8T","38T","41.1T","44.3T"]
["计算公式：（缸内径面积-活塞杆面积）*测试压力"]

{"sheet":"参数","index":4,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["拓钢油缸","内径","杆径","抽芯力","截面积","负载","吨位"]
["3T",70,32,36511.920000000006,3042.6600000000003,1,"3T"]
["4T",80,35,48748.5,4062.375,3,"4T"]
["5T",90,45,57226.5,4768.875,4,"5T"]
["6.5T",100,45,75124.5,6260.375,5,"6.5T"]
["8T",110,50,90432,7536,6.5,"8T"]
["10T",125,55,118692,9891,8,"10T"]
["13T",140,60,150720,12560,10,"13T"]
["16T",160,70,194994,16249.5,13,"16T"]
["20T",180,75,252220.5,21018.375,16,"20T"]
["25T",200,80,316512,26376,20,"25T"]
["30T",220,90,379626,31635.5,25,"30T"]
["南武油缸","内径","杆径","抽芯力","截面积",30,"30T以上"]
["3.8T",63,28,30002.699999999997,2500.2249999999999]
["4.6T",70,31.5,36811.005000000005,3067.5837500000002]
["6T",80,35.5,48416.445,4034.7037500000001]
["7.7T",90,40,61230,5102.5]
["9.4T",100,45,75124.5,6260.375]
["11T",110,50,90432,7536]
["15T",125,56,117646.38,9803.8649999999998]
["18T",140,63,147244.02000000002,12270.335000000001]
["21T",150,67,169663.62,14138.635]
["25T",160,70,194994,16249.5]
["30T",180,80,244920,20410]
["37T",200,90,300498,25041.5]