{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["X-MR","X-R","X-S","Attribute chart (2)","Attribute chart","移动平均控制图","CUSUM","稀有事件控制图","小批量","EWMA"],"not_rendered":{"images":1,"macros":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"X-MR","index":0,"n_rows":115,"n_cols":5,"rows_kept":115,"flags":["formulas_cached_only"]}
[null,"Xi",null,null,"Viscosity(黏度）"]
[null,10.01,null,null,33.75]
[null,10.2,null,null,33.05]
[null,10.11,null,null,34]
[null,10.22,null,null,33.81]
[null,10.26,null,null,33.46]
[null,10.47,null,null,34.02]
[null,9.98,null,null,33.68]
[null,10.18,null,null,33.27]
[null,10.65,null,null,33.49]
[null,10.1,null,null,33.2]
[null,9.51,null,null,33.62]
[null,10.07,null,null,33]
[null,9.95,null,null,33.54]
[null,9.71,null,null,33.12]
[null,9.8,null,null,33.84]
[null,9.97]
[null,9.82]
[null,10.08]
[null,9.53]
[null,10.49]
[null,9.86]
[null,10.28]
[null,9.47]
[null,9.97]
[null,10.3]
[null,10.07]
[null,9.39]
[null,10.19]
[null,10.23]
[null,10.04]
[null,9.94]
[null,10.05]
[null,9.95]
[null,10.41]
[null,10.25]
[null,10.3]
[null,10.54]
[null,9.97]
[null,10.13]
[null,10.08]
[null,9.7]
[null,9.8]
[null,10.1]
[null,10.55]
[null,9.57]
[null,10.68]
[null,9.76]
[null,10.44]
[null,9.84]
[null,10.24]
[null,9.96]
[null,10.15]
[null,10.49]
[null,9.72]
[null,9.73]
[null,9.67]
[null,10.1]
[null,10.11]
[null,10.26]
[null,9.52]
[null,10.28]
[null,9.96]
[null,10.11]
[null,9.82]
[null,10.42]
[null,10.1]
[null,10]
[null,10]
[null,9.99]
[null,10.6]
[null,9.41]
[null,10.15]
[null,9.85]
[null,9.46]
[null,9.09]
[null,9.4]
[null,10.12]
[null,10.06]
[null,9.98]
[null,9.78]
[null,10.48]
[null,10.09]
[null,10.17]
[null,10.36]
[null,9.65]
[null,9.63]
[null,10.25]
[null,9.33]
[null,10.24]
[null,9.88]
[null,9.87]
[null,10.35]
[null,10.11]
[null,10.06]
[null,9.79]
[null,10]
[null,10.13]
[null,9.91]
[null,10.27]
[null,10.07]
["Average",10.021400000000002]
[]
[]
[]
[]
[null,"There are drawbacks in the interpretation and use of X-bar MR chart"]
[1,"All interpretation is faulty if the data distribution is not normal."]
[null,"所有的解释都是错误的，如果数据不正态"]
[2,"individual's charts do not separate piece to piece repeatability of the process."]
[null,"单值图不能分为件与件的重复"]
[3,"Variability patterns canot be assured until 80-100 readings are taken."]
[null,"如果数据点少于80　到100，　变化的模式不能保证"]
[4,"individual's charts are not as sensitive to changes in the process as the Xbar -R chart"]
[null,"单值图没有Xbar-R图敏感"]

{"sheet":"X-R","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"merged":[[1,2,1,6]],"flags":["formulas_cached_only"]}
["exercise","spec:5.5 +/-0.05mm"]
[null,null,"测量值（单位：mm）"]
["date","组别",1,2,3,4,5]
["2007-07-10",1,5.51,5.52,5.51,5.53,{"v":5.5,"d":"5.50"}]
["2007-07-11",2,5.49,5.49,5.48,5.49,5.52]
["2007-07-12",3,{"v":5.5,"d":"5.50"},5.51,5.53,5.53,5.52]
["2007-07-13",4,5.52,5.52,5.49,5.51,5.51]
["2007-07-14",5,5.49,{"v":5.5,"d":"5.50"},5.49,{"v":5.5,"d":"5.50"},5.51]
["2007-07-15",6,5.49,5.48,5.47,5.47,{"v":5.5,"d":"5.50"}]
["2007-07-16",7,5.46,5.48,{"v":5.5,"d":"5.50"},5.49,5.49]
["2007-07-17",8,5.51,5.52,5.51,{"v":5.5,"d":"5.50"},5.48]
["2007-07-18",9,5.49,5.51,5.51,5.48,5.49]
["2007-07-19",10,5.46,5.47,5.48,5.46,5.49]
["2007-07-20",11,5.49,5.47,{"v":5.5,"d":"5.50"},5.48,5.47]
["2007-07-21",12,{"v":5.5,"d":"5.50"},5.51,5.51,5.49,{"v":5.5,"d":"5.50"}]
["2007-07-22",13,5.51,5.49,{"v":5.5,"d":"5.50"},5.49,5.51]
["2007-07-23",14,5.49,5.47,{"v":5.5,"d":"5.50"},5.49,5.51]
["2007-07-24",15,{"v":5.5,"d":"5.50"},5.51,5.53,5.52,5.51]
["2007-07-25",16,5.51,5.49,5.51,5.52,5.51]
["2007-07-26",17,5.51,{"v":5.5,"d":"5.50"},5.51,5.49,5.48]
["2007-07-27",18,5.52,5.49,5.51,5.53,5.49]
["2007-07-28",19,5.49,{"v":5.5,"d":"5.50"},5.48,5.49,5.47]
["2007-07-29",20,5.48,5.51,5.49,5.49,5.51]
["2007-07-30",21,5.51,{"v":5.5,"d":"5.50"},5.51,5.52,5.53]
["2007-07-31",22,5.48,5.49,5.52,5.51,{"v":5.5,"d":"5.50"}]
["2007-08-01",23,5.48,5.49,5.51,{"v":5.5,"d":"5.50"},5.52]
["2007-08-02",24,{"v":5.5,"d":"5.50"},5.52,5.48,5.49,5.48]
["2007-08-03",25,5.51,5.51,5.49,{"v":5.5,"d":"5.50"},{"v":5.5,"d":"5.50"}]
["2007-08-04",26,5.54,5.52,5.52,5.53,5.53]
["2007-08-05",27,5.53,{"v":5.5,"d":"5.50"},5.51,5.53,5.52]
["2007-08-06",28,5.51,5.52,5.52,5.52,5.51]
["2007-08-07",29,5.47,5.48,5.51,{"v":5.5,"d":"5.50"},5.51]
["2007-08-08",30,5.51,5.48,5.47,5.51,{"v":5.5,"d":"5.50"}]
{"$rows_empty":33}
[null,"Step "]

{"sheet":"X-S","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"merged":[[2,2,2,11]],"flags":["formulas_cached_only"]}
[]
[null,null,"Spec: 10.15 +/-0.1mm"]
[null,"组别","测                           量                         值"]
["日期","组别",1,2,3,4,5,6,7,8,9,10]
["2007-07-10",1,10.16,10.18,10.16,10.19,10.14,10.16,10.18,10.16,10.15,10.19]
["2007-07-11",2,10.16,10.14,10.15,10.18,10.12,10.13,{"v":10.2,"d":"10.20"},10.16,10.17,10.14]
["2007-07-12",3,{"v":10.2,"d":"10.20"},10.21,10.18,10.16,10.14,10.22,10.19,10.18,10.17,10.21]
["2007-07-13",4,10.15,10.19,10.14,10.17,10.09,10.19,10.14,10.16,10.13,10.22]
["2007-07-14",5,10.18,10.17,10.13,10.15,{"v":10.2,"d":"10.20"},10.18,10.18,10.16,10.21,10.19]
["2007-07-15",6,10.11,10.11,10.13,10.15,10.14,{"v":10.1,"d":"10.10"},10.12,10.13,10.16,10.18]
["2007-07-16",7,10.16,10.14,10.15,10.16,10.19,10.21,10.16,10.18,10.14,10.17]
["2007-07-17",8,10.17,10.24,10.19,10.16,10.17,10.12,10.21,10.18,10.21,10.22]
["2007-07-18",9,10.19,10.18,10.15,10.14,{"v":10.2,"d":"10.20"},10.16,10.18,10.16,10.09,10.13]
["2007-07-19",10,10.18,10.15,10.14,10.12,10.13,10.15,10.14,10.18,{"v":10.2,"d":"10.20"},10.13]
["2007-07-20",11,10.19,10.14,10.06,10.19,10.18,10.18,10.17,10.16,10.11,10.12]
["2007-07-21",12,10.15,10.14,10.21,10.17,10.15,10.12,10.18,10.17,10.24,{"v":10.2,"d":"10.20"}]
["2007-07-22",13,10.18,10.14,10.12,10.16,10.18,{"v":10.1,"d":"10.10"},10.09,10.08,10.09,10.17]
["2007-07-23",14,10.08,10.14,10.12,10.15,10.15,10.18,10.19,{"v":10.2,"d":"10.20"},10.18,10.17]
["2007-07-24",15,10.19,10.15,10.16,10.18,10.18,10.19,10.18,10.17,10.14,10.16]
["2007-07-25",16,10.16,10.15,10.12,10.19,10.18,10.16,10.17,10.22,10.11,10.18]
["2007-07-26",17,10.15,10.19,10.15,10.14,10.17,10.08,10.12,10.11,10.15,10.17]
["2007-07-27",18,10.17,10.14,{"v":10.1,"d":"10.10"},10.21,10.18,10.15,10.17,10.22,{"v":10.1,"d":"10.10"},10.11]
["2007-07-28",19,10.15,10.11,10.16,10.14,10.22,10.23,10.21,10.18,10.15,10.17]
["2007-07-29",20,10.18,10.17,10.13,{"v":10.1,"d":"10.10"},10.07,10.09,10.12,10.14,10.16,{"v":10.2,"d":"10.20"}]
["2007-07-30",21,10.15,10.18,10.17,10.19,10.21,10.22,10.12,10.18,10.16,10.17]
["2007-07-31",22,10.18,{"v":10.2,"d":"10.20"},10.13,10.14,10.18,10.09,10.08,10.16,10.14,10.18]
["2007-08-01",23,10.15,10.16,10.14,10.14,10.12,10.18,10.17,{"v":10.1,"d":"10.10"},10.09,10.15]
["2007-08-02",24,10.18,10.19,{"v":10.1,"d":"10.10"},10.12,10.08,10.09,10.18,10.13,10.15,10.16]
["2007-08-03",25,10.16,10.18,10.17,10.19,10.08,10.12,10.08,10.21,10.15,10.18]

{"sheet":"Attribute chart (2)","index":3,"n_rows":41,"n_cols":42,"rows_kept":41,"flags":["formulas_cached_only"]}
["P chart",{"$nulls":6},"P chart",{"$nulls":4},"NP chart",{"$nulls":3},"NP chart",{"$nulls":3},"C chart",{"$nulls":3},"C chart",{"$nulls":7},"U chart"]
[{"$nulls":7},"练习1",{"$nulls":4},"练习2",{"$nulls":7},"练习3"]
[{"$nulls":18},"NP chart",{"$nulls":6},"缺陷数"]
["Date","No","测试数","不良数","Material",null,null,"P/N","sample","reject","Material",null,"sample","defect",{"$nulls":3},"样本","不良",null,1,"Unit","defect",null,"No","10（单位mm）","异色","麻点","起毛","总",null,null,"No","抽样数","缺陷数",null,null,"Date","P/N","sample","reject","Material"]
["2007-08-10",1,206,8,1,null,null,1,51,12,1,null,50,12,null,null,1,80,1,null,2,5,10,null,1,10,5,7,3,15,null,null,1,105,235,null,null,"2007-08-10",1,51,12,1]
["2007-08-11",2,201,6,1,null,null,2,50,15,1,null,50,15,null,null,2,80,3,null,3,5,12,null,2,10,3,9,6,18,null,null,2,98,236,null,null,"2007-08-11",2,50,15,1]
["2007-08-12",3,195,11,1,null,null,3,54,8,1,null,50,8,null,null,3,80,2,null,4,5,8,null,3,10,9,5,8,22,null,null,3,101,253,null,null,"2007-08-12",3,54,8,1]
["2007-08-13",4,213,6,1,null,null,4,52,10,1,null,50,10,null,null,4,80,0,null,5,5,14,null,4,10,11,7,6,24,null,null,4,103,214,null,null,"2007-08-13",4,52,10,1]
["2007-08-14",5,204,4,1,null,null,5,49,4,1,null,50,4,null,null,5,80,1,null,6,5,10,null,5,10,8,9,4,21,null,null,5,109,210,null,null,"2007-08-14",5,49,4,1]
["2007-08-15",6,186,11,1,null,null,6,50,7,1,null,50,7,null,null,6,80,2,null,7,5,16,null,6,10,6,12,11,29,null,null,6,95,195,null,null,"2007-08-15",6,50,7,1]
["2007-08-16",7,199,7,1,null,null,7,51,16,1,null,50,16,null,null,7,80,4,null,8,5,11,null,7,10,7,7,8,22,null,null,7,89,183,null,null,"2007-08-16",7,51,16,1]
["2007-08-17",8,201,6,1,null,null,8,50,9,1,null,50,9,null,null,8,80,2,null,9,5,7,null,8,10,9,8,7,24,null,null,8,95,204,null,null,"2007-08-17",8,50,9,1]
["2007-08-18",9,207,12,1,null,null,9,52,14,1,null,50,14,null,null,9,80,1,null,10,5,10,null,9,10,11,8,8,27,null,null,9,110,206,null,null,"2007-08-18",9,52,14,1]
["2007-08-19",10,198,6,1,null,null,10,49,10,1,null,50,10,null,null,10,80,3,null,11,5,15,null,10,10,5,10,6,21,null,null,10,103,197,null,null,"2007-08-19",10,49,10,1]
["2007-08-20",11,176,8,1,null,null,11,50,5,2,null,50,5,null,null,11,80,2,null,12,5,9,null,11,10,14,9,9,32,null,null,11,104,196,null,null,"2007-08-20",11,50,5,2]
["2007-08-21",12,186,9,1,null,null,12,50,6,2,null,50,6,null,null,12,80,2,null,13,5,5,null,12,10,16,5,5,26,null,null,12,92,158,null,null,"2007-08-21",12,50,6,2]
["2007-08-22",13,204,4,1,null,null,13,47,17,2,null,50,17,null,null,13,80,2,null,14,5,7,null,13,10,7,14,8,29,null,null,13,86,193,null,null,"2007-08-22",13,47,17,2]
["2007-08-23",14,215,7,2,null,null,14,50,12,2,null,50,12,null,null,14,80,0,null,15,5,11,null,14,10,6,9,9,24,null,null,14,108,208,null,null,"2007-08-23",14,50,12,2]
["2007-08-24",15,223,11,2,null,null,15,53,22,2,null,50,22,null,null,15,80,4,null,16,5,12,null,15,10,9,8,5,22,null,null,15,112,352,null,null,"2007-08-24",15,53,22,2]
["2007-08-25",16,215,13,2,null,null,16,50,8,2,null,50,8,null,null,16,80,5,null,17,5,6,null,16,10,12,5,7,24,null,null,16,106,213,null,null,"2007-08-25",16,50,8,2]
["2007-08-26",17,204,10,2,null,null,17,52,10,2,null,50,10,null,null,17,80,1,null,18,5,8,null,17,10,7,6,6,19,null,null,17,99,224,null,null,"2007-08-26",17,52,10,2]
["2007-08-27",18,216,6,2,null,null,18,52,5,2,null,50,5,null,null,18,80,2,null,19,5,10,null,18,10,15,6,6,27,null,null,18,100,210,null,null,"2007-08-27",18,52,5,2]
["2007-08-28",19,218,8,2,null,null,19,51,13,2,null,50,13,null,null,19,80,4,null,20,5,7,null,19,10,9,8,8,25,null,null,19,101,178,null,null,"2007-08-28",19,51,13,2]
["2007-08-29",20,207,14,2,null,null,20,51,11,2,null,50,11,null,null,20,80,2,null,null,5,5,null,20,10,7,11,5,23,null,null,20,114,199,null,null,"2007-08-29",20,51,11,2]
["2007-08-30",21,229,12,2,{"$nulls":11},21,80,1,{"$nulls":5},21,10,6,12,6,24,null,null,21,94,204]
["2007-08-31",22,178,9,2,{"$nulls":8},0.214,null,null,22,80,1,null,"mean",{"$nulls":3},22,10,3,5,9,17,null,null,22,89,213]
["2007-09-01",23,196,6,2,{"$nulls":11},23,80,1,{"$nulls":5},23,10,9,7,6,22,null,null,25,110,231]
["2007-09-02",24,185,7,2,{"$nulls":11},24,80,3]
["2007-09-03",25,189,9,2,{"$nulls":11},25,80,2]
[]
[null,"example"," nbar",202.04,{"$nulls":12},"np+3sqrt(np(1-p))"]
[null,null,"p bar",0.4016,{"$nulls":9},"NP",null,null,"np-3sqrt(np(1-p))"]
[{"$nulls":13},"UCL",{"$nulls":4},6.269872338499119]
[{"$nulls":13},"LCL"]
[]
[]
[]
["两种计算不良率平均值方法的差异"]
[10,11,4,20,10]
[100,120,50,200,10,0.2743333333333333]
[0.1,0.09166666666666666,0.08,0.1,1]

{"sheet":"Attribute chart","index":4,"n_rows":41,"n_cols":28,"rows_kept":41,"flags":["formulas_cached_only"]}
["P chart",{"$nulls":7},"NP chart",{"$nulls":4},"C chart",{"$nulls":3},"C chart",{"$nulls":7},"U chart"]
[]
[{"$nulls":18},"缺陷数"]
["Date","No","测试数","不良数","Material",{"$nulls":3},"sample","defect",{"$nulls":3},1,"Unit","defect",null,"No","10（单位mm）","异色","麻点","起毛","总",null,null,"No","抽样数","缺陷数"]
["2007-08-10",1,206,8,1,{"$nulls":3},50,12,{"$nulls":3},2,5,10,null,1,10,5,7,3,15,null,null,1,105,235]
["2007-08-11",2,201,6,1,{"$nulls":3},50,15,{"$nulls":3},3,5,12,null,2,10,3,9,6,18,null,null,2,98,236]
["2007-08-12",3,195,11,1,{"$nulls":3},50,8,{"$nulls":3},4,5,8,null,3,10,9,5,8,22,null,null,3,101,253]
["2007-08-13",4,213,6,1,{"$nulls":3},50,10,{"$nulls":3},5,5,14,null,4,10,11,7,6,24,null,null,4,103,214]
["2007-08-14",5,204,4,1,{"$nulls":3},50,4,{"$nulls":3},6,5,10,null,5,10,8,9,4,21,null,null,5,109,210]
["2007-08-15",6,186,11,1,{"$nulls":3},50,7,{"$nulls":3},7,5,16,null,6,10,6,12,11,29,null,null,6,95,195]
["2007-08-16",7,199,7,1,{"$nulls":3},50,16,{"$nulls":3},8,5,11,null,7,10,7,7,8,22,null,null,7,89,183]
["2007-08-17",8,201,6,1,{"$nulls":3},50,9,{"$nulls":3},9,5,7,null,8,10,9,8,7,24,null,null,8,95,204]
["2007-08-18",9,207,12,1,{"$nulls":3},50,14,{"$nulls":3},10,5,10,null,9,10,11,8,8,27,null,null,9,110,206]
["2007-08-19",10,198,6,1,{"$nulls":3},50,10,{"$nulls":3},11,5,15,null,10,10,5,10,6,21,null,null,10,103,197]
["2007-08-20",11,176,8,1,{"$nulls":3},50,5,{"$nulls":3},12,5,9,null,11,10,14,9,9,32,null,null,11,104,196]
["2007-08-21",12,186,9,1,{"$nulls":3},50,6,{"$nulls":3},13,5,5,null,12,10,16,5,5,26,null,null,12,92,158]
["2007-08-22",13,204,4,1,{"$nulls":3},50,17,{"$nulls":3},14,5,7,null,13,10,7,14,8,29,null,null,13,86,193]
["2007-08-23",14,215,7,2,{"$nulls":3},50,12,{"$nulls":3},15,5,11,null,14,10,6,9,9,24,null,null,14,108,208]
["2007-08-24",15,223,11,2,{"$nulls":3},50,22,{"$nulls":3},16,5,12,null,15,10,9,8,5,22,null,null,15,112,352]
["2007-08-25",16,215,13,2,{"$nulls":3},50,8,{"$nulls":3},17,5,6,null,16,10,12,5,7,24,null,null,16,106,213]
["2007-08-26",17,204,10,2,{"$nulls":3},50,10,{"$nulls":3},18,5,8,null,17,10,7,6,6,19,null,null,17,99,224]
["2007-08-27",18,216,6,2,{"$nulls":3},50,5,{"$nulls":3},19,5,10,null,18,10,15,6,6,27,null,null,18,100,210]
["2007-08-28",19,218,8,2,{"$nulls":3},50,13,{"$nulls":3},20,5,7,null,19,10,9,8,8,25,null,null,19,101,178]
["2007-08-29",20,207,14,2,{"$nulls":3},50,11,{"$nulls":4},5,5,null,20,10,7,11,5,23,null,null,20,114,199]
["2007-08-30",21,229,12,2,{"$nulls":12},21,10,6,12,6,24,null,null,21,94,204]
["2007-08-31",22,178,9,2,{"$nulls":4},0.214,{"$nulls":3},"mean",{"$nulls":3},22,10,3,5,9,17,null,null,22,89,213]
["2007-09-01",23,196,6,2,{"$nulls":12},23,10,9,7,6,22,null,null,25,110,231]
["2007-09-02",24,185,7,2]
["2007-09-03",25,189,9,2]
[]
[null,"example"," nbar",202.04]
[null,null,"p bar",0.4016,{"$nulls":5},"NP"]
[{"$nulls":9},"UCL"]
[{"$nulls":9},"LCL"]
[]
[]
[]
["两种计算不良率平均值方法的差异"]
[10,11,4,20,10]
[100,120,50,200,10,0.2743333333333333]
[0.1,0.09166666666666666,0.08,0.1,1]

{"sheet":"移动平均控制图","index":5,"n_rows":47,"n_cols":2,"rows_kept":47,"flags":["formulas_cached_only"]}
["石灰石重量"]
["NO.","石灰石重量"]
[1,905]
[2,930]
[3,865]
[4,895]
[5,905]
[6,885]
[7,890]
[8,930]
[9,915]
[10,910]
[11,920]
[12,915]
[13,925]
[14,860]
[15,905]
[16,925]
[17,925]
[18,905]
[19,915]
[20,930]
[21,890]
[22,940]
[23,860]
[24,875]
[25,985]
[26,970]
[27,940]
[28,975]
[29,1000]
[30,1035]
[31,1020]
[32,985]
[33,960]
[34,945]
[35,965]
[36,940]
[37,900]
[38,920]
[39,980]
[40,950]
[41,955]
[42,970]
[43,970]
[44,1035]
[45,1040]

{"sheet":"CUSUM","index":6,"n_rows":127,"n_cols":3,"rows_kept":127,"flags":["formulas_cached_only"]}
[]
["AB间距","月份","日期"]
[-0.44025,9,28]
[5.90038,9,28]
[2.08965,9,28]
[0.09998,9,28]
[2.01594,9,28]
[4.83012,9,29]
[3.78732,9,29]
[4.99821,9,29]
[6.91169,9,29]
[1.93847,9,29]
[-3.09907,9,30]
[-3.18827,9,30]
[5.28978,9,30]
[0.56182,9,30]
[-3.1896,9,30]
[7.93177,10,4]
[3.72692,10,4]
[3.83152,10,4]
[-2.17454,10,4]
[2.81598,10,4]
[4.52023,10,5]
[3.95372,10,5]
[7.99326,10,5]
[4.98677,10,5]
[-2.03427,10,5]
[3.89134,10,6]
[1.99825,10,6]
[0.01028,10,6]
[-0.24542,10,6]
[2.08175,10,6]
[-4.86937,10,7]
[-2.69206,10,7]
[-3.02947,10,7]
[2.99932,10,7]
[3.50123,10,7]
[-1.99506,10,8]
[-1.62939,10,8]
[2.14395,10,8]
[-1.90688,10,8]
[8.02322,10,8]
[4.75466,10,11]
[1.1424,10,11]
[0.9379,10,11]
[-7.30286,10,11]
[-5.22516,10,11]
[-4.06527,10,12]
[-1.91314,10,12]
[2.0459,10,12]
[4.93029,10,12]
[0.03095,10,12]
[-2.80363,10,13]
[-3.12681,10,13]
[-4.57793,10,13]
[-3.17924,10,13]
[-2.44537,10,13]
[1.36225,10,14]
[0.92825,10,14]
[-0.24151,10,14]
[-0.83762,10,14]
[-1.99674,10,14]
[4.90024,10,15]
[1.28079,10,15]
[2.87917,10,15]
[1.83867,10,15]
[-0.75614,10,15]
[3.72977,10,18]
[3.77141,10,18]
[-4.04994,10,18]
[3.89824,10,18]
[1.76868,10,18]
[2.2731,10,18]
[-3.82297,10,18]
[-2.26821,10,18]
[-2.07973,10,18]
[0.01739,10,18]
[3.71309,10,19]
[1.72573,10,19]
[3.07264,10,19]
[0.15676,10,19]
[-0.05666,10,19]
[3.81341,10,19]
[-3.78952,10,19]
[-3.81635,10,19]
[-4.8882,10,19]
[-3.24534,10,19]
[-0.27272,10,20]
[-4.33095,10,20]
[-1.83547,10,20]
[-3.98876,10,20]
[-4.97431,10,20]
[-5.1405,10,20]
[-0.10379,10,20]
[2.21033,10,20]
[5.13041,10,20]
[-1.89455,10,20]
[0.95119,10,21]
[-5.15414,10,21]
[4.82794,10,21]
[0.13001,10,21]
[-0.09911,10,21]
[-1.15453,10,21]
[2.29868,10,21]
[5.15847,10,21]
[0.08558,10,21]
[-3.09574,10,21]
[5.16744,10,22]
[0.29748,10,22]
[-4.66858,10,22]
[-2.13787,10,22]
[-0.0045,10,22]
[0.18096,10,22]
[4.30247,10,22]
[-2.21708,10,22]
[7.17603,10,22]
[5.86525,10,22]
[0.95699,10,25]
[-4.03441,10,25]
[-2.05086,10,25]
[-3.10319,10,25]
[-1.83001,10,25]
[5.03945,10,25]
[1.96583,10,25]
[-0.21026,10,25]
[0.27517,10,25]
[-5.32797,10,25]

{"sheet":"稀有事件控制图","index":7,"n_rows":85,"n_cols":4,"rows_kept":85,"flags":["formulas_cached_only"]}
[null,"稀有事件"]
[null,"感染日期",null,"针刺伤的日期和时间"]
[null,"2013-02-03",null,"2013-01-02T12:00:00"]
[null,"2013-02-17",null,"2013-01-10T03:10:00"]
[null,"2013-02-28",null,"2013-01-17T11:33:00"]
[null,"2013-04-05",null,"2013-01-21T04:02:00"]
[null,"2013-04-13",null,"2013-01-21T09:00:00"]
[null,"2013-04-26",null,"2013-01-29T14:59:00"]
[null,"2013-04-29",null,"2013-02-04T07:01:00"]
[null,"2013-05-22",null,"2013-02-06T08:17:00"]
[null,"2013-05-26",null,"2013-02-07T20:06:00"]
[null,"2013-06-03",null,"2013-02-09T04:58:00"]
[null,"2013-06-26",null,"2013-02-09T22:53:00"]
[null,"2013-07-10",null,"2013-02-11T03:26:00"]
[null,"2013-07-15",null,"2013-02-14T00:44:00"]
[null,"2013-07-16",null,"2013-02-14T12:20:00"]
[null,"2013-07-23",null,"2013-02-19T08:31:00"]
[null,"2013-07-31",null,"2013-02-19T11:18:00"]
[null,"2013-08-06",null,"2013-02-20T03:30:00"]
[null,"2013-08-07",null,"2013-02-21T22:27:00"]
[null,"2013-08-25",null,"2013-02-25T17:52:00"]
[null,"2013-08-27",null,"2013-02-28T14:32:00"]
[null,"2013-09-07",null,"2013-03-05T11:39:00"]
[null,"2013-09-11",null,"2013-03-06T09:16:00"]
[null,"2013-09-23",null,"2013-03-09T06:13:00"]
[null,"2013-09-28",null,"2013-03-10T16:43:00"]
[null,"2013-10-04",null,"2013-03-21T10:23:00"]
[null,"2013-10-14",null,"2013-03-23T14:07:00"]
[null,"2013-10-26",null,"2013-03-28T18:31:00"]
[null,"2013-10-26",null,"2013-03-29T08:43:00"]
[null,"2013-10-26",null,"2013-04-10T03:27:00"]
[null,"2013-10-26",null,"2013-04-11T23:21:00"]
[null,"2013-10-26",null,"2013-04-23T20:30:00"]
[null,"2013-10-28",null,"2013-04-29T16:24:00"]
[null,"2013-11-05",null,"2013-05-04T04:16:00"]
[null,"2013-11-11",null,"2013-05-11T15:15:00"]
[null,"2013-11-17",null,"2013-05-21T17:34:00"]
[null,"2013-11-30",null,"2013-06-04T01:36:00"]
[null,"2013-12-16",null,"2013-06-10T08:59:00"]
[{"$nulls":3},"2013-06-13T18:58:00"]
[{"$nulls":3},"2013-06-17T23:10:00"]
[{"$nulls":3},"2013-06-19T12:50:00"]
[{"$nulls":3},"2013-06-27T01:15:00"]
[{"$nulls":3},"2013-06-30T04:43:00"]
[{"$nulls":3},"2013-07-05T18:55:00"]
[{"$nulls":3},"2013-07-11T07:14:00"]
[{"$nulls":3},"2013-07-13T05:10:00"]
[{"$nulls":3},"2013-07-14T18:03:00"]
[{"$nulls":3},"2013-07-15T05:18:00"]
[{"$nulls":3},"2013-07-17T22:16:00"]
[{"$nulls":3},"2013-07-22T05:45:00"]
[{"$nulls":3},"2013-07-26T09:24:00"]
[{"$nulls":3},"2013-07-30T19:59:00"]
[{"$nulls":3},"2013-08-05T15:52:00"]
[{"$nulls":3},"2013-08-13T06:04:00"]
[{"$nulls":3},"2013-08-25T07:02:00"]
[{"$nulls":3},"2013-08-29T23:24:00"]
[{"$nulls":3},"2013-09-12T13:40:00"]
[{"$nulls":3},"2013-09-14T22:44:00"]
[{"$nulls":3},"2013-09-19T22:19:00"]
[{"$nulls":3},"2013-09-20T03:50:00"]
[{"$nulls":3},"2013-09-20T20:06:00"]
[{"$nulls":3},"2013-09-21T00:31:00"]
[{"$nulls":3},"2013-09-22T01:25:00"]
[{"$nulls":3},"2013-09-23T17:34:00"]
[{"$nulls":3},"2013-09-24T15:35:00"]
[{"$nulls":3},"2013-09-30T16:44:00"]
[{"$nulls":3},"2013-10-13T18:40:00"]
[{"$nulls":3},"2013-10-18T13:42:00"]
[{"$nulls":3},"2013-10-26T09:16:00"]
[{"$nulls":3},"2013-11-04T01:19:00"]
[{"$nulls":3},"2013-11-08T06:35:00"]
[{"$nulls":3},"2013-11-13T05:42:00"]
[{"$nulls":3},"2013-11-14T20:27:00"]
[{"$nulls":3},"2013-11-21T20:43:00"]
[{"$nulls":3},"2013-12-03T22:03:00"]
[{"$nulls":3},"2013-12-04T01:27:00"]
[{"$nulls":3},"2013-12-04T02:19:00"]
[{"$nulls":3},"2013-12-05T15:32:00"]
[{"$nulls":3},"2013-12-09T21:02:00"]
[{"$nulls":3},"2013-12-12T13:47:00"]
[{"$nulls":3},"2013-12-21T19:38:00"]
[{"$nulls":3},"2013-12-23T22:03:00"]
[{"$nulls":3},"2013-12-29T03:32:00"]
[{"$nulls":3},"2013-12-31T20:12:00"]

{"sheet":"小批量","index":8,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[10,1,10,2],[10,3,10,4],[10,5,10,6],[11,1,11,2],[11,3,11,4],[11,5,11,6],[20,1,20,2],[20,3,20,4],[20,5,20,6],[21,1,21,2],[21,3,21,4],[21,5,21,6]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"零件号","样本号","转换值","yij"]
["零件号码",1,2,3,4,5,6,null,null,1,1,-0.857,"Y11"]
["公差","Φ110+0.003+0.026","Φ245-0.195-0.075","Φ200+0.12+0.20","Φ180-0.255-0.125","Φ950+0.035","Φ190-0.10+0",null,null,1,2,0.117,"Y12"]
[{"$nulls":9},1,3,1.091,"Y13"]
["零件号码","X1j","y1j","X2j","y2j","x3j","y3j",null,null,1,4,0.701,"Y14"]
["数据1","Φ110+0.01",-0.857,"Φ245-0.12",0.586,"Φ200+0.145",-0.605,null,null,1,5,-1.051,"Y15"]
["数据2","Φ110+0.015",0.117,"Φ245-0.14",-0.391,"Φ200+0.17",0.559,null,null,2,1,0.586,"Y21"]
["数据3","Φ110+0.02",1.091,"Φ245-0.11",1.075,"Φ200+0.13",-1.304,null,null,2,2,-0.391,"Y22"]
["数据4","Φ110+0.018",0.701,"Φ245-0.16",-1.368,"Φ200+0.165",0.326,null,null,2,3,1.075,"Y23"]
["数据5","Φ110+0.009",-1.051,"Φ245-0.13",0.098,"Φ200+0.18",1.024,null,null,2,4,-1.368,"Y24"]
["均值"," µ ̂1 =100.0144",null,"μ︿2=245-0.132",null,"μ︿3=200.158",{"$nulls":3},2,5,0.098,"Y25"]
["标准差","σ︿1=0.005135114",null,"σ︿2=0.020463175",null,"σ︿3=0.021475173",{"$nulls":3},3,1,-0.605,"Y31"]
[{"$nulls":9},3,2,0.559,"Y32"]
[{"$nulls":9},3,3,-1.304,"Y33"]
["零件号码","X4j","y4j","X5j","y5j","x6j","y6j",null,null,3,4,0.326,"Y34"]
["数据1","Φ180-0.185",-0.071,"Φ95+0..023",0.202,"Φ190-0.05",-0.605,null,null,3,5,1.024,"Y35"]
["数据2","Φ180-0.21",-0.662,"Φ95+0..02",-0.231,"Φ190-0.0375",0.559,null,null,4,1,-0.071,"Y41"]
["数据3","Φ180-0.15",0.756,"Φ95+0..015",-0.951,"Φ190-0.08",-1.304,null,null,4,2,-0.662,"Y42"]
["数据4","Φ180-0.135",1.11,"Φ95+0..018",-0.52,"Φ190-0.0635",0.326,null,null,4,3,0.756,"Y43"]
["数据5","Φ180-0.23",-1.134,"Φ95+0..032",1.503,"Φ190-0.02",1.024,null,null,4,4,1.11,"Y44"]
["均值","μ︿4=180-0.182",null,"μ︿5=95.0216",null,"μ︿6=190-0.0502",{"$nulls":3},4,5,-1.134,"Y45"]
["标准差","σ︿4=0.042319839",null,"σ︿5=0.006918984",null,"σ︿6=0.024596679",{"$nulls":3},5,1,0.202,"Y51"]
[{"$nulls":9},5,2,-0.231,"Y52"]
[{"$nulls":9},5,3,-0.951,"Y53"]
[{"$nulls":9},5,4,-0.52,"Y54"]
[{"$nulls":9},5,5,1.503,"Y55"]
[{"$nulls":9},6,1,-0.605,"Y61"]
[{"$nulls":9},6,2,0.559,"Y62"]
[{"$nulls":9},6,3,-1.304,"Y63"]
[{"$nulls":9},6,4,0.326,"Y64"]
[{"$nulls":9},6,5,1.024,"Y65"]

{"sheet":"EWMA","index":9,"n_rows":25,"n_cols":2,"rows_kept":25,"flags":["formulas_cached_only"]}
[null,"轴棍直径"]
[null,18.5]
[null,20.9]
[null,20.8]
[null,19.5]
[null,20.7]
[null,21.1]
[null,19.1]
[null,19.8]
[null,20.2]
[null,20.2]
[null,19.7]
[null,21.2]
[null,20.4]
[null,21]
[null,19.4]
[null,20.2]
[null,21.3]
[null,22.1]
[null,21.5]
[null,{"v":20,"d":"20.0"}]
[null,20.7]
[null,21.7]
[null,22.2]
[null,22.9]