PPK-CPK(自動生成）

1、Attention:1 Now, the Rep(5) sheet is a sample of auto PpK & CpK caculating formula.2 If you want to use the auto PpK & CpK caculating formula, first please clearthe data of the data line of the Original Data sheet, and then input the usefuldata into the Data Line of the Original Data Sheet.3

2、 The formula can caculate the PpK & CpK at the same time.If you want aPpK report, please clear the CpK related result, because they are irrelevant,and so is to CpK report.4 If the data of you analysised item is deferent from the sample data, maybeyou should change the size of Y axes of the X-Bar

3、 Chart and R-Bar chart, ormaybe you couldnt see the point in the graph.5 Please keep the file as a original file, every time when you want to use theformula, please make a copy for the file.USL:USL:LSL:LSL:RAND(1/0)19.5019.351DataNo.No.RandStat.1 119.4217.682 219.4417.73 319.414 419.445 519.4317.696

4、 619.4417.717 719.4317.718 819.4217.79 919.4417.69101019.4217.71111119.4317.69121219.4117.71131319.4217.7141419.4117.7151519.4317.71161619.4217.7171719.4317.69181819.4117.71191919.4217.7202019.4417.69212119.4217.71222219.4317.7232319.4317.71242419.4117.67252519.4317.69262619.4217.68272719.4217.72828

5、19.4117.71292919.4217.7303019.4117.69313119.4217.7323219.4117.72333319.4117.71343419.4317.69353519.4417.7363619.4217.71373719.4417.69383819.4317.71393919.4117.7404019.4217.69414119.4217.7424219.4117.71434319.4117.71444419.4417.7454519.4117.69464619.4117.69474719.4117.7484819.4217.71494919.4417.75050

6、19.4217.69515119.4417.69525219.4417.7535319.4317.7545419.4117.71555519.4317.7565619.4317.69575719.4217.7585819.4217.71595919.4417.7606019.4417.68616119.4117.7626219.4317.69636319.4117.69646419.4217.69656519.4317.71666619.4317.71676719.4317.7686819.4217.69696919.4417.68707019.4317.71717119.4217.69727

7、219.4117.7737319.4317.71747419.4417.71757519.4217.69767619.4217.7777719.4317.71787819.4217.69797919.4217.7808019.4217.7818119.4417.71828219.4317.7838319.4117.7848419.4417.71858519.4117.7868619.4317.69878719.4417.7888819.4117.7898919.4117.69909019.4217.7919119.4417.71929219.4417.68939319.4417.7194941

8、9.4417.7959519.4117.69969619.4317.7979719.4217.71989819.4317.7999919.4417.6910010019.4117.6910110119.4417.710210219.4217.7110310319.4217.710410419.4117.6710510519.4117.6910610619.4417.6810710719.4317.6910810819.4417.6810910919.4417.711011019.4417.7111111119.4317.711211219.4417.7111311319.4217.691141

9、1419.4417.7111511519.4317.711611619.4417.6911711719.4417.711811819.4417.7111911919.4317.712012019.4317.7112112119.4417.6912212219.4317.6912312319.4217.7112412419.4217.712512519.4317.68VARIABLE CAPABILITY CHECK SHEETPart Number:W982852R、W982853PDate:2002/10/26Prepared by: 邱春根USL: 19.5000CpU:2.32Cp:2.

10、35PpU:2.25Pp:2.28LSL: 19.3500CpL:2.38CpK:2.322.32PpL:2.31PpK:2.252.25group12345AverageRange119.4219.4419.4119.4419.4319.4280.03X: 19.4260219.4419.4319.4219.4419.4219.4310.02R:0.0248319.4319.4119.4219.4119.4319.4200.02(R/d2) =0.0106419.4219.4319.4119.4219.4419.4250.02(s):0.0110519.4219.4319.4319.4119

11、.4319.4240.03619.4219.4219.4119.4219.4119.4160.02719.4219.4119.4119.4319.4419.4200.03USL: 19.5000819.4219.4419.4319.4119.4219.4250.03LSL: 19.3500919.4219.4119.4119.4419.4119.4190.031019.4119.4119.4219.4419.4219.4230.031119.4419.4419.4319.4119.4319.4310.03X-Bar1219.4319.4219.4219.4419.4419.4320.02UCL

12、: 19.44031319.4119.4319.4119.4219.4319.4190.02LCL: 19.41171419.4319.4319.4219.4419.4319.4300.021519.4219.4119.4319.4419.4219.4250.031619.4219.4319.4219.4219.4219.4210.02R-Bar1719.4419.4319.4119.4419.4119.4250.03USL:0.05241819.4319.4419.4119.4119.4219.4220.03LCL:0.00001919.4419.4419.4419.4419.4119.43

13、40.032019.4319.4219.4319.4419.4119.4250.03Warning2119.4419.4219.4219.4119.4119.4210.030.00002219.4419.4319.4419.4419.4419.4380.012319.4319.4419.4219.4419.4319.4330.02Warning2419.4419.4419.4419.4319.4319.4360.010.00002519.4419.4319.4219.4219.4319.4270.02X-Bar Chart12345678910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 2519.3950 19.4000 19.4