当前位置:首页 >> 机械/仪表 >>

SPC全套Excel表格


2012-2-1 87353125.xls

TYPE OF TOLERENCE: BOTH SIDE 1, MAX TOL.3, MIN TOL 4, B"COLUMN? INPUT.BEFORE TIME BEFORE DATA DELETE.

PROCESS CAPABILITY STUDY
PART NO: 96179248 PART NAME G/K-GEARSHIFT OP.NO CHECK ITEM
TYPE OF TOL.

P/NO: 96179248 P/NAME: G/K-GEARSHIFT PROCESS: ITEM:

USL : LSL : TOL : MEAN :

0.88 0.72 0.16 0.8 0.8200 0.8100 0.8300 0.8100 0.8200 0.7400 0.8300 0.8400 0.8200 0.8200

INSP : DATE : MIN UNIT : Xo : 0.8200 0.7600 0.8500 0.8200 0.8200 0.8200 0.8500 0.8000 0.8200 0.8400 0.8000 0.8400 0.8400 0.8000 0.8300 0.001

USL LSL INSPECTOR DATE UNIT Xo : DATA NO.1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200?

1 0.880 0.720

0.8100 0.8300 0.8200 0.8200 0.8200

0.8100 0.8300 0.8300 0.8300 0.8300

0.8200 0.8100 0.8400 0.8100 0.8200

0.8300 0.8400 0.8100 0.8300 0.8200

0.8200 0.8400 0.7800 0.7800 0.8100

0.001 0.81 0.81 0.82 0.83 0.82 0.82 0.74 0.82 0.82 0.8 0.83 0.83 0.81 0.84 0.84 0.81 0.83 0.76 0.85 0.84 0.82 0.83 0.84 0.81 0.78 0.83 0.84 0.85 0.8 0.84 0.82 0.83 0.81 0.83 0.78 0.81 0.82 0.82 0.82 0.8 0.82 0.83 0.82 0.82 0.81 0.82 0.82 0.82 0.84 0.83 AVG = σ = 0.8188 0.0206 MIN = Cp = PC% = 0.15% 7.40 0.757 ~ 0.881 0.74 1.30 77.1% MAX = Cpk = PCk% = OUT OF LOWER SPEC 0.85 0.99 100.8% = 0.00% -1.69 N = k = 50 0.23

OUT OF UPPER SPEC = KURTOSIS = SPREAD RANGE(6σ) =

SKEWNESS =

DISTRIBUTION CURVE
30 25 20 15 10 5
0.701 … 0.720 … 0.739 … 0.758 … 0.777 … 0.796 … 0.815 … 0.834 … 0.853 … 0.872 … 0.891 … 0.910 … 0.929 …

0

MAX+SL/2 0.8505 X+3s 0.881 US 0.88 MIN-SL/2 0.7395 X-3s 0.757 LS 0.72 a 0.72 b 0.880502 h 0.00321 0.001188 0.7015 0.7027 0.7039 0.7051 0.7063 0.7074 0.7086 0.7098 0.7110 0.7122 0.7134 0.7146 0.7158 0.7169 0.7181 0.7193 0.7205 0.7217 0.7229 0.7241 0.7253 0.7264 0.7276 0.7288 0.7300 0.7312 0.7324 0.7336 0.7348 0.7359 0.7371 0.7383 0.7395 0.7407 0.7419 0.7431 0.7443 0.7454 0.7466 0.7478 0.7490 0.7502 0.7514 0.7526 0.7538 0.7549 0.7561 0.7573 0.7585 0.7597 0.7609 0.7621 0.7633 0.7644 0.7656 0.7668 0.7680 0.7692 0.7704 0.7716 0.7728 0.7739 0.7751 0.7763 0.7775 0.7787 0.7799 0.7811 0.7823 0.7834 0.7846 0.7858 0.7870 0.7882 0.7894 0.7906 0.7918 0.7929 0.7941 0.7953 0.7965 0.7977 0.7989 0.8001 0.8013 0.8024 0.8036 0.8048 0.8060 0.8072 0.8084 0.8096 0.8108 0.8119 0.8131 0.8143 0.8155 0.8167 0.8179 0.8191 0.8203 0.8214 0.8226 0.8238 0.8250 0.8262 0.8274 0.8286 0.8298 0.8309 0.8321 0.8333 0.8345 0.8357 0.8369 0.8381 0.8393 0.8404 0.8416 0.8428 0.8440 0.8452 0.8464 0.8476 0.8488 0.8499 0.8511 0.8523 0.8535 0.8547 0.8559 0.8571 0.8583 0.8594 0.8606 0.8618 0.8630 0.8642 0.8654 0.8666 0.8678 0.8689 0.8701 0.8713 0.8725 0.8737 0.8749 0.8761 0.8773 0.8784 0.8796 0.8808 0.8820 0.8832 0.8844 0.8856 0.8868 0.8879 0.8891 0.8903 0.8915 0.8927 0.8939 0.8951 0.8963 0.8974 0.8986 0.8998 0.9010 0.9022 0.9034 0.9046 0.9058 0.9069 0.9081 0.9093 0.9105 0.9117 0.9129 0.9141 0.9153 0.9164 0.9176 0.9188 0.9200 0.9212 0.9224 0.9236 0.9248 0.9259 0.9271 0.9283 0.9295 8.14E-05 0.000109 0.000147 0.000196 0.00026 0.000344 0.000454 0.000597 0.000782 0.00102 0.001326 0.001717 0.002215 0.002846 0.003644 0.004647 0.005904 0.007473 0.009421 0.011832 0.014802 0.018446 0.022896 0.028309 0.034864 0.042767 0.052252 0.063585 0.077066 0.093028 0.111839 0.133905 0.159666 0.189596 0.224199 0.264008 0.309573 0.361461 0.420238 0.486467 0.560684 0.643391 0.735034 0.835983 0.946516 1.066792 1.196833 1.336501 1.485478 1.643246 1.809076 1.982013 2.160869 2.344231 2.530461 2.717718 2.903981 3.087088 3.264781 3.434759 3.594752 3.742589 3.876283 3.994124 4.094763 4.177312 4.241433 4.287419 4.316276 4.329777 4.330514 4.321917 4.308257 4.294616 4.286835 4.291425 4.315452 4.366394 4.451963 4.579913 4.757821 4.992852 5.291527 5.659474 6.1012 6.619868 7.217104 7.89283 8.645138 9.470202 10.36225 11.31359 12.31465 13.35415 14.41927 15.49587 16.56877 17.62209 18.63954 19.60484 20.50207 21.31601 22.03255 22.63898 23.12429 23.47948 23.69767 23.77435 23.7074 23.49715 23.14634 22.66002 22.04543 21.31177 20.46996 19.53239 18.5126 17.42496 16.28435 15.10584 13.90438 12.69449 11.49002 10.30389 9.147932 8.032681 6.967293 5.95946 5.01537 4.139714 3.335719 2.605219 1.948741 1.365629 0.854168 0.411727 0.03491 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 2 2 2 2 2 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 6 6 7 7 8 9 9 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 9 8 7 6 5 4 3 3 2 1 1 0 0 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 0.7015 0.7063 0.7110 0.7158 0.7205 0.7253 0.7300 0.7348 0.7395 0.7443 0.7490 0.7538 0.7585 0.7633 0.7680 0.7728 0.7775 0.7823 0.7870 0.7918 0.7965 0.8013 0.8060 0.8108 0.8155 0.8203 0.8250 0.8298 0.8345 0.8393 0.8440 0.8488 0.8535 0.8583 0.8630 0.8678 0.8725 0.8773 0.8820 0.8868 0.8915 0.8963 0.9010 0.9058 0.9105 0.9153 0.9200 0.9248 0.9295

MIN.UNIT Max Min KIND Q'TYT GRADE KIND
grade width

0.001 0.85 0.74 6.8388344 111 CLASS Q'TY 6 18 GRADE KIND r 18.5 0.019 2 1.026316 8.447494 1 1.68E-06 6.1E-06 2.1E-05 6.86E-05 0.000213 0.000624 0.001738 0.004586 0.011473 0.027216 0.061205 0.130494 0.263773 0.505484 0.918376 1.581866 2.583181 3.99923 5.869944 8.168225 10.776 13.47795 15.98182 17.96655 19.1487 19.34863 18.5352 16.83373 14.49438 11.83192 9.15687 6.718541 4.673466 3.082048 1.926974 1.142217 0.641885 0.341981 0.172736 0.082718 0.037554 0.016164 0.006596 0.002552 0.000936 0.000325 0.000107 3.35E-05 9.94E-06 0.9295 0.701500 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 2 2 2 2 11 11 11 11 26 26 26 26 9 9 9 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1 -100 -100 -100 1

0.695395 0.72 0.000492 0.7015 0.7063 0.7110 0.7158 0.7205 0.7253 0.7300 0.7348 0.7395 0.7443 0.7490 0.7538 0.7585 0.7633 0.7680 0.7728 0.7775 0.7823 0.7870 0.7918 0.7965 0.8013 0.8060 0.8108 0.8155 0.8203 0.8250 0.8298 0.8345 0.8393 0.8440 0.8488 0.8535 0.8583 0.8630 0.8678 0.8725 0.8773 0.8820 0.8868 0.8915 0.8963 0.9010 0.9058 0.9105 0.9153 0.9200 0.9248 0.9295 0.7015 0.7063 0.7110 0.7158 0.7205 0.7253 0.7300 0.7348 0.7395 0.7443 0.7490 0.7538 0.7585 0.7633 0.7680 0.7728 0.7775 0.7823 0.7870 0.7918 0.7965 0.8013 0.8060 0.8108 0.8155 0.8203 0.8250 0.8298 0.8345 0.8393 0.8440 0.8488 0.8535 0.8583 0.8630 0.8678 0.8725 0.8773 0.8820 0.8868 0.8915 0.8963 0.9010 0.9058 0.9105 0.9153 0.9200 0.9248 0.9295 0 0 0 0 0 0 0 0 0 1 1 1 1 2 2 2 2 4 4 4 4 7 7 15 15 31 31 31 41 41 48 48 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 2 0 0 0 3 0 8 0 16 0 0 10 0 7 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.02325 0.0185 0.01375 0.009 0.00425 0.0005 0.00525 0.01 0.01475 0.0195 0.02425 0.029 0.03375 0.0385 0.04325 0.048 0.05275 0.0575 0.06225 0.067 0.07175 0.0765 0.08125 0.086 0.09075 0.0955 0.10025 0.105 0.10975 0.1145 0.11925 0.124 0.12875 0.1335 0.13825 0.143 0.14775 0.1525 0.15725 0.162 0.16675 0.1715 0.17625 0.181 0.18575 0.1905 0.19525 0.2 0.20475 0.2095 0.18325 0.1785 0.17375 0.169 0.16425 0.1595 0.15475 0.15 0.14525 0.1405 0.13575 0.131 0.12625 0.1215 0.11675 0.112 0.10725 0.1025 0.09775 0.093 0.08825 0.0835 0.07875 0.074 0.06925 0.0645 0.05975 0.055 0.05025 0.0455 0.04075 0.036 0.03125 0.0265 0.02175 0.017 0.01225 0.0075 0.00275 0.002 0.00675 0.0115 0.01625 0.021 0.02575 0.0305 0.03525 0.04 0.04475 0.0495 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0

0.720500

0.739500

0.758500

0.777500

0.796500

0.815500

0.834500

0.853500

0.872500

0.891500

0.910500

0.929500 1


赞助商链接
相关文章:
管制
SPC全套Excel版 3页 1下载券 柏拉图,直方图,管制图制... 12页 免费 CPK计算表格EXCEL 2页 1下载券 管制图 50页 免费 投资控制管理规范 3页 免费管...
各种规则
SPC全套Excel版 3页 免费 做人的基本原则 37页 免费 QA QC的工作职责 4页 ...两只表并不能告诉一个人更准确的时间,反而会让看表的人失去对准确时间的信心...
QC训练教材
SPC全套Excel版 3页 免费 QC七大手法及SPC过程控制培... 59页 免费 QC七大手法...查核表: 相當於備忘錄, 將要進行查看工作項目一項一項的整理出來, 然後定期或...
更多相关标签: