{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["设计介绍","试验设计三原则","Plackett Burman","部分因子","全因子","RSM","田口","混料设计"],"not_rendered":{"images":11,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"设计介绍","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"merged":[[1,4,1,7]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":4},"烧结温度、烧结时间和成型压力对于陶瓷强度"]
[]
[null,"标准序","水稻亩产",null,"烧结温度","烧结时间","成型压力","陶瓷强度"]
[null,1,832,null,1300,8,20,91.8]
[null,2,770,null,1500,8,20,110.16]
[null,3,1124,null,1300,10,20,82.62]
[null,4,1385,null,1500,10,20,104.04]
[null,5,987,null,1300,8,24,79.56]
[null,6,846,null,1500,8,24,126.99]
[null,7,1035,null,1300,10,24,68.85]
[null,8,1179,null,1500,10,24,122.4]
[{"$nulls":4},1300,8,20,94.86]
[{"$nulls":4},1500,8,20,105.57]
[{"$nulls":4},1300,10,20,81.09]
[{"$nulls":4},1500,10,20,105.57]
[{"$nulls":4},1300,8,24,84.15]
[{"$nulls":4},1500,8,24,126.99]
[{"$nulls":4},1300,10,24,67.32]
[{"$nulls":4},1500,10,24,123.93]

{"sheet":"试验设计三原则","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"flags":["formulas_cached_only"]}
[]
[null,"例1","例2","例3"]
[]
[null,"粘接强度","Y","强度"]
[null,7.6,67,53]
[null,9.2,75,65]
[null,9.9,90,59]
[null,10.1,52,74]
[null,7.8,79,56]
[null,8.4,61,96]
[null,9.5,59,64]
[null,9.9,87,96]
[{"$nulls":3},56]
[{"$nulls":3},70]
[{"$nulls":3},68]
[{"$nulls":3},73]
[{"$nulls":3},60]
[{"$nulls":3},95]
[{"$nulls":3},68]
[{"$nulls":3},103]

{"sheet":"Plackett Burman","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"flags":["formulas_cached_only"]}
[]
["例2"]
["波峰焊接合格率改善",null,"合格率"]
["Factor",null,51.8]
["传送带角度",null,85.3]
["传送带速度",null,54.6]
["锡面高度",null,78.9]
["锡炉温度",null,69.2]
["松香温度",null,76.4]
["松香比重",null,78.6]
["预热温度",null,66.7]
["锡条型号",null,88.9]
[null,null,49.4]
[null,null,71.9]
[null,null,63.1]

{"sheet":"部分因子","index":3,"n_rows":22,"n_cols":6,"rows_kept":22,"flags":["formulas_cached_only"]}
[]
["例1（4因子）"]
[]
["注塑强度",null,null,"取得塑胶轮的最大机械强度 "]
[15]
[38,null,"Standard order for fraction factorial design for a b c d ("]
[88,{"$nulls":3},"lower","Upper"]
[100,null,"a","料筒温度",120,180]
[12,1,"B ","挤入速度",5.8,10]
[21,null,"C","注塑压力",40,60]
[44,null,"D","模温",75,95]
[81]
[]
[null,null,"Sample 1","Sample 2"," Sample 3"]
[null,null,127,119,128]
[null,null,120,130,134]
[null,null,155,170,169]
[null,null,120,125,127]
[null,null,136,140,142]
[null,null,72,80,79]
[null,null,71,73,75]
[null,null,95,92,102]

{"sheet":"全因子","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"flags":["formulas_cached_only"]}
[]
["例1",null,null,"例2",null,"例3"]
[]
["磨损量","磨损",null,"粘结强度",null,"粘接强度"]
[4.2,3.7,null,37,null,7.6]
[2.8,4.6,null,37,null,9.2]
[5,3.1,null,37,null,9.9]
[3.2,3.4,null,31,null,10.1]
[3.8,3.4,null,55,null,12.6]
[2.7,5.3,null,47,null,12.9]
[4.8,2.4,null,55,null,11.8]
[3.1,4.7,null,49,null,12.5]
[null,3.1,null,32]
[null,4.8,null,24]
[null,2.7,null,29]
[null,3.8,null,33]
[null,3.2,null,46]
[null,4.9,null,36]
[null,2.8,null,45]
[null,4.2,null,33]
[{"$nulls":3},35]
[{"$nulls":3},31]

{"sheet":"RSM","index":5,"n_rows":360,"n_cols":33,"rows_kept":360,"merged":[[7,55,7,57],[8,55,8,57],[8,61,8,62],[9,55,9,57],[9,61,9,62],[10,55,10,57],[10,61,10,62],[101,3,101,5],[102,3,102,5],[102,9,102,10],[103,3,103,5],[103,9,103,10],[104,3,104,5],[104,9,104,10]],"flags":["formulas_cached_only"]}
[]
[null,"例1",{"$nulls":13},"例2",{"$nulls":6},"例3"]
[null,"RSM",null,"after find top point",{"$nulls":11},"BBD","其目标值为87+3mg ",null,null,"exercise"]
[null,"2 (4-1)+ 3cp",null,"(23 +3 cp)",null,"CCD (or 2 level + 3cp +modify 3 axial cp)",{"$nulls":9},"化学量",{"$nulls":6},"strength",{"$nulls":6},"CCD +6 CP, 20 runs"]
[null,"life",null,"life",null,null,"life",{"$nulls":5},"diff"," 1/2",null,83.2,null,"因素"," -"," +","最优设置水平",null,81,{"$nulls":3},"standard order","Wear"]
[null,17,null,181,null,1,181,null,"CCD1","H",140,160,20,10,null,84.8,null,"反应压力",180,210,207.4,null,28,null,30,40,1,3.7,null,"IPress","(injection press)",1200,1400]
[null,26,null,189,null,2,189,null,null,"O",0.4,0.48,0.07999999999999996,0.03999999999999998,null,86.8,null,"反应温度",300,350,{"v":347,"d":"347.0"},null,50,null,75,100,2,4.6,null,"HPress","(Holding press)",700,800]
[null,25,null,212,null,3,212,null,null,"B",20,60,40,20,null,85.1,null,"反应时间",30,40,33.8,null,46,null,"A ","B",3,3.1,null,"ITime","(injection time",1.2,1.6]
[null,85,null,254,null,4,254,null,null,"G",20,60,40,20,null,87.6,{"$nulls":6},62,{"$nulls":3},4,3.4]
[null,49,null,191,null,5,191,{"$nulls":8},86.9,{"$nulls":6},50,{"$nulls":3},5,3.4]
[null,56,null,197,null,6,197,{"$nulls":3}," -"," +",{"$nulls":3},84.2,{"$nulls":6},80,{"$nulls":3},6,5.3]
[null,62,null,200,null,7,200,null,"CCD3","H",200,240,{"$nulls":3},85.2,{"$nulls":6},98,{"$nulls":3},7,2.4]
[null,168,null,297,null,8,297,null,null,"O",0.57,0.65,{"$nulls":3},84.6,{"$nulls":6},95,{"$nulls":3},8,4.7]
[null,64,null,254,null,9,254,null,null,"B",20,60,{"$nulls":3},91.4,{"$nulls":6},12,{"$nulls":3},9,4.1]
[null,77,null,256,null,10,256,{"$nulls":8},88.8,{"$nulls":6},18,{"$nulls":3},10,5]
[null,55,null,259,null,11,259,{"$nulls":8},86.3,{"$nulls":6},22,{"$nulls":3},11,2.7]
[{"$nulls":5},12,189,{"$nulls":8},89.2,{"$nulls":6},13,{"$nulls":3},12,3.8]
[{"$nulls":5},13,235,{"$nulls":8},88.7,{"$nulls":6},26,{"$nulls":3},13,3.6]
[{"$nulls":5},14,172,{"$nulls":8},88.2,{"$nulls":6},45,{"$nulls":3},14,4.9]
[{"$nulls":5},15,261,{"$nulls":15},45,{"$nulls":3},15,3.2]
[{"$nulls":5},16,229,{"$nulls":15},86,{"$nulls":3},16,4.1]
[{"$nulls":5},17,275,{"$nulls":15},75]
[{"$nulls":5},18,244,{"$nulls":15},50]
[{"$nulls":5},19,250,{"$nulls":15},50]
[{"$nulls":5},20,279,{"$nulls":15},50]
[{"$nulls":22},55]
[{"$nulls":22},54]
[{"$nulls":22},82]
[{"$nulls":22},120]
[{"$nulls":22},50]
[{"$nulls":22},99]
[{"$nulls":22},13]
[{"$nulls":22},30]
[{"$nulls":22},76]
[{"$nulls":22},20]
[{"$nulls":22},60]
[{"$nulls":22},73]
[{"$nulls":22},33]
[{"$nulls":22},82]
[{"$nulls":22},86]
{"$rows_empty":168}
[null,"for general full factorial design"]
[null,null,"3 factor ","level",{"$nulls":5},"strength"]
[null,null,"adhesive",2,{"$nulls":5},81]
[null,null,"temp",3,{"$nulls":5},28]
[null,null,"time",3,{"$nulls":5},50]
[null,null,"2 replicates",{"$nulls":6},46]
[{"$nulls":9},62]
[{"$nulls":9},50]
[null,"分析方法：",{"$nulls":7},80]
[null,1,"直接用全因子的方法分析（方差分析法）",{"$nulls":6},98]
[null,2,"用RS方法分析，需要重新定义数据",{"$nulls":6},95]
[{"$nulls":9},12]
[null,"两种方法的结果P不一样。但　不矛盾",{"$nulls":7},18]
[null,null,"方差是水平的平均值的差异",{"$nulls":6},22]
[null,null,"回归是拟合线是不是是水平。",{"$nulls":6},13]
[{"$nulls":9},26]
[{"$nulls":9},45]
[{"$nulls":9},45]
[{"$nulls":9},86]
[{"$nulls":9},75]
[{"$nulls":9},50]
[{"$nulls":9},50]
[{"$nulls":9},50]
[{"$nulls":9},55]
[{"$nulls":9},54]
[{"$nulls":9},82]
[{"$nulls":9},120]
[{"$nulls":9},50]
[{"$nulls":9},99]
[{"$nulls":9},13]
[{"$nulls":9},30]
[{"$nulls":9},76]
[{"$nulls":9},20]
[{"$nulls":9},60]
[{"$nulls":9},73]
[{"$nulls":9},33]
[{"$nulls":9},82]
[{"$nulls":9},86]
{"$rows_empty":26}
["用main-effect and interaction plot 分析。（在ANOVA里）"]
{"$rows_empty":61}
[null,"以下数据来展现,中心点明显时,因子分析方法同RSM的差异. 因子分析方法只能在给定的水平优化,达不到最佳"]
[]
[null,"StdOrder","RunOrder","CenterPt","Blocks","焊錫溫度","焊錫速渡","焊錫時間","試作數量","焊錫不良"]
[null,1,1,1,1,380,7,0.7,1000,26]
[null,2,2,1,1,420,7,0.7,1000,18]
[null,3,3,1,1,380,9,0.7,1000,17]
[null,4,4,1,1,420,9,0.7,1000,13]
[null,5,5,1,1,380,7,1.3,1000,16]
[null,6,6,1,1,420,7,1.3,1000,12]
[null,7,7,1,1,380,9,1.3,1000,18]
[null,8,8,1,1,420,9,1.3,1000,5]
[null,9,9,0,1,400,8,1,1000,9]
[null,10,10,0,1,400,8,1,1000,8]
[null,11,11,0,1,400,8,1,1000,8]
[null,12,12,0,1,400,8,1,1000,6]
[]
[]
[null,"RSM分析是编码未变码的选择差异"]
[{"$nulls":3},"编码输入","参数输入"]
[null,"编码","上部回归系数","编码系数","编码系数"]
[null,null,"下部回归系数","编码系数","参数系数"]
[]
[null,"未编码","上部回归系数","编码系数","参数系数"]
[null,null,"下部回归系数","无","无"]
[]
[null,"注","因子是参数输入时，选编码会进行时，提供两种系数，其它怎选都可以"]

{"sheet":"田口","index":6,"n_rows":19,"n_cols":7,"rows_kept":19,"flags":["formulas_cached_only"]}
["P1","P2","P3","P4","P5","P6","P7"]
[10.18,10.18,10.12,10.06,10.02,9.98,10.2]
[10.03,10.01,9.98,9.96,9.91,9.89,10.12]
[9.81,9.78,9.74,9.74,9.71,9.68,9.87]
[10.09,10.08,10.07,9.99,9.92,9.88,10.14]
[10.06,10.05,10.05,9.89,9.85,9.78,10.12]
[10.2,10.19,10.18,10.17,10.14,10.13,10.22]
[9.91,9.88,9.88,9.84,9.82,9.8,9.93]
[10.32,10.28,10.25,10.2,10.18,10.18,10.36]
[10.04,10.02,10.01,9.98,9.95,9.89,10.11]
[10,9.98,9.93,9.8,9.77,9.7,10.15]
[9.97,9.97,9.91,9.88,9.87,9.85,10.05]
[10.06,9.94,9.9,9.88,9.8,9.72,10.12]
[10.15,10.08,10.04,9.98,9.91,9.9,10.22]
[9.91,9.87,9.86,9.87,9.85,9.8,10.02]
[10.02,10,9.95,9.92,9.78,9.71,10.06]
[10.08,10,9.99,9.95,9.92,9.85,10.14]
[10.07,10.02,9.89,9.89,9.85,9.76,10.19]
[10.1,10.08,10.05,9.99,9.97,9.95,10.12]

{"sheet":"混料设计","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"flags":["formulas_cached_only"]}
["除味剂设计",null,null,"高强度钢配方设计"]
["可接受性",null,null,"断裂强度"]
[5.73,null,null,142]
[7.2,null,null,142]
[7.46,null,null,138]
[7.3,null,null,145]
[8.23,null,null,136]
[7.3,null,null,133]
[7.2,null,null,135]
[7.06,null,null,133]
[6.56,null,null,133]
[7.13,null,null,132]