Spreadsheet: 832006d1686057556-error-message-until-first-data-point-plotted-spc-plan-template
Sheet: Sheet1

F-QA-##     Document Title
Instructions for completing this form are found on Page 2 of this document
1 | Nomenclature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Drawing No.
Characteristic |  |  |  | 2 |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Rev.
6 | Upper Spec Limit |  |  |  |  |  |  |  |  |  |  |  | inches |  |  | 8 | Upper Control Limit |  |  |  |  |  |  |  |  | inches |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Sample Frequency
7 | Lower Spec Limit |  |  |  |  |  |  |  |  |  |  |  | inches |  |  | 9 | Lower Control Limit |  |  |  |  |  |  |  |  | inches |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Sample Size
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Verification Level
 |  |  | 14 | Unit |  | Reading | LSL | LCL | UCL | USL | CL Alert | [NAME] |  | Unit |  | Reading |  |  |  | Unit |  | Reading |  |  |  | Unit |  | Reading |  |  |  | Unit |  | Reading |  |  |  |  |  | 13 | Code Letter
 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  | 41 |  |  |  |  |  | 61 |  |  |  |  |  | 81
 |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  | 42 |  |  |  |  |  | 62 |  |  |  |  |  | 82 |  |  |  |  |  |  |  |  |  | 17 | Data Results
 |  |  |  | 3 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  | 43 |  |  |  |  |  | 63 |  |  |  |  |  | 83 |  |  |  |  |  |  |  |  |  | Min
 |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  | 44 |  |  |  |  |  | 64 |  |  |  |  |  | 84 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | 5 |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  | 45 |  |  |  |  |  | 65 |  |  |  |  |  | 85 |  |  |  |  |  |  |  |  |  |  | Cp
 |  |  |  | 6 |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  | 46 |  |  |  |  |  | 66 |  |  |  |  |  | 86 |  |  |  |  |  |  |  |  |  |  | Cpk
 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  | 47 |  |  |  |  |  | 67 |  |  |  |  |  | 87
 |  |  |  | 8 |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  | 48 |  |  |  |  |  | 68 |  |  |  |  |  | 88 |  |  |  |  |  |  |  |  |  | k criterion
 |  |  |  | 9 |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  | 49 |  |  |  |  |  | 69 |  |  |  |  |  | 89 |  |  |  |  |  |  |  |  |  | F criterion
 |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  | 50 |  |  |  |  |  | 70 |  |  |  |  |  | 90
 |  |  |  | 11 |  |  |  |  |  |  |  |  |  | 30.5151515151515 |  |  |  |  |  | 51 |  |  |  |  |  | 71 |  |  |  |  |  | 91
 |  |  |  | 12 |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  | 52 |  |  |  |  |  | 72 |  |  |  |  |  | 92
 |  |  |  | 13 |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  | 53 |  |  |  |  |  | 73 |  |  |  |  |  | 93
 |  |  |  | 14 |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  | 54 |  |  |  |  |  | 74 |  |  |  |  |  | 94
 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  | 55 |  |  |  |  |  | 75 |  |  |  |  |  | 95
 |  |  |  | 16 |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  | 56 |  |  |  |  |  | 76 |  |  |  |  |  | 96
 |  |  |  | 17 |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  | 57 |  |  |  |  |  | 77 |  |  |  |  |  | 97
 |  |  |  | 18 |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  |  | 58 |  |  |  |  |  | 78 |  |  |  |  |  | 98
 |  |  |  | 19 |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  | 59 |  |  |  |  |  | 79 |  |  |  |  |  | 99
 |  |  |  | 20 |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  | 60 |  |  |  |  |  | 80 |  |  |  |  |  | 100
 |  |  | 15 | Date:
 |  |  | 16 | Time:
 |  |  |  |  |  |  |  |  | MIL-STD-1916
 |  |  |  |  |  |  |  |  | TABLE III. Variables sampling plans |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Verification Levels Used for Dropdown
 |  |  |  |  |  |  |  |  |  |  |  |  | Verification levels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
 |  |  |  |  |  |  |  |  |  |  |  | T |  | VII |  | VI |  | V |  | IV |  | III |  | II |  | I |  | R |  |  |  |  |  |  |  |  | IV
 |  |  |  |  |  |  |  |  | A |  |  | 113 |  | 87 |  | 64 |  | 44 |  | 29 |  | 18 |  | 9 |  | 4 |  | 2 |  |  |  |  |  |  |  |  | III
 |  |  |  |  |  |  |  |  | B |  |  | 122 |  | 92 |  | 69 |  | 49 |  | 32 |  | 20 |  | 11 |  | 5 |  | 2
 |  |  |  |  |  |  |  |  | C |  |  | 129 |  | 100 |  | 74 |  | 54 |  | 37 |  | 23 |  | 13 |  | 7 |  | 2
 |  |  |  |  |  |  |  |  | D |  |  | 136 |  | 107 |  | 81 |  | 58 |  | 41 |  | 26 |  | 15 |  | 8 |  | 3 |  |  |  |  |  |  |  |  | Code imbedded to draw sample size
 |  |  |  |  |  |  |  |  | E |  |  | 145 |  | 113 |  | 87 |  | 64 |  | 44 |  | 29 |  | 18 |  | 9 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | k values (one- or two-sided)
 |  |  |  |  |  |  |  |  | Code letter |  |  | T |  | VII |  | VI |  | V |  | IV |  | III |  | II |  | I |  | R
 |  |  |  |  |  |  |  |  | A |  |  | 3.51 |  | 3.27 |  | 3 |  | 2.69 |  | 2.4 |  | 2.05 |  | 1.64 |  | 1.21 |  | 1.2 |  |  |  |  |  |  |  |  | Code imbedded for k-value
 |  |  |  |  |  |  |  |  | B |  |  | 3.58 |  | 3.32 |  | 3.07 |  | 2.79 |  | 2.46 |  | 2.14 |  | 1.77 |  | 1.33 |  | 1.2
 |  |  |  |  |  |  |  |  | C |  |  | 3.64 |  | 3.4 |  | 3.12 |  | 2.86 |  | 2.56 |  | 2.21 |  | 1.86 |  | 1.45 |  | 1.2
 |  |  |  |  |  |  |  |  | D |  |  | 3.69 |  | 3.46 |  | 3.21 |  | 2.91 |  | 2.63 |  | 2.32 |  | 1.93 |  | 1.56 |  | 1.2
 |  |  |  |  |  |  |  |  | E |  |  | 3.76 |  | 3.51 |  | 3.27 |  | 3 |  | 2.69 |  | 2.4 |  | 2.05 |  | 1.64 |  | 1.21 |  |  |  |  |  |  |  |  | Code imbedded for F criterion
 |  |  |  |  |  |  |  |  |  |  |  | F values (two-sided)
 |  |  |  |  |  |  |  |  | Code letter |  |  | T |  | VII |  | VI |  | V |  | IV |  | III |  | II |  | I |  | R
 |  |  |  |  |  |  |  |  | A |  |  | 0.136 |  | 0.145 |  | 0.157 |  | 0.174 |  | 0.193 |  | 0.222 |  | 0.271 |  | 0.37 |  | 0.707
 |  |  |  |  |  |  |  |  | B |  |  | 0.134 |  | 0.143 |  | 0.154 |  | 0.168 |  | 0.188 |  | 0.214 |  | 0.253 |  | 0.333 |  | 0.707 |  |  |  |  | Mean
 |  |  |  |  |  |  |  |  | C |  |  | 0.132 |  | 0.14 |  | 0.152 |  | 0.165 |  | 0.182 |  | 0.208 |  | 0.242 |  | 0.301 |  | 0.707 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | D |  |  | 0.13 |  | 0.138 |  | 0.148 |  | 0.162 |  | 0.177 |  | 0.199 |  | 0.233 |  | 0.283 |  | 0.435 |  |  |  |  | USL-Avg
 |  |  |  |  |  |  |  |  | E |  |  | 0.128 |  | 0.136 |  | 0.145 |  | 0.157 |  | 0.174 |  | 0.193 |  | 0.222 |  | 0.271 |  | 0.37 |  |  |  |  | Avg-LSL
 |  |  |  |  |  |  |  |  | MIL-STD-1916
 |  |  |  |  |  |  |  |  | Table I. Code Letters (CL) for entry into the sampling tables
 |  |  |  |  |  |  |  |  | Lot or production interval size |  |  |  |  |  |  |  |  |  | Verification levels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Range Based on Lot Size
 |  |  |  |  |  | Results |  |  | Min |  |  |  |  |  |  | [NAME] |  |  | VII |  | VI |  | V |  | IV |  | III |  | II |  | I
 |  |  |  |  |  | 2-170 |  |  | 2 |  |  |  |  |  |  | 170 |  |  | A |  | A |  | A |  | A |  | A |  | A |  | A
 |  |  |  |  |  | 171-288 |  |  | 171 |  |  |  |  |  |  | 288 |  |  | A |  | A |  | A |  | A |  | A |  | A |  | B
 |  |  |  |  |  | 289-544 |  |  | 289 |  |  |  |  |  |  | 544 |  |  | A |  | A |  | A |  | A |  | A |  | B |  | C |  |  | Code imbedded to find intersection point between
 |  |  |  |  |  | 545-960 |  |  | 545 |  |  |  |  |  |  | 960 |  |  | A |  | A |  | A |  | A |  | B |  | C |  | D |  |  | Lot Size/Sample Frequency and Verification Level
 |  |  |  |  |  | 961-1632 |  |  | 961 |  |  |  |  |  |  | 1632 |  |  | A |  | A |  | A |  | B |  | C |  | D |  | E
 |  |  |  |  |  | 1633-3072 |  |  | 1633 |  |  |  |  |  |  | 3072 |  |  | A |  | A |  | B |  | C |  | D |  | E |  | E
 |  |  |  |  |  | 3073-5440 |  |  | 3073 |  |  |  |  |  |  | 5440 |  |  | A |  | B |  | C |  | D |  | E |  | E |  | E
 |  |  |  |  |  | 5441-9216 |  |  | 5441 |  |  |  |  |  |  | 9216 |  |  | B |  | C |  | D |  | E |  | E |  | E |  | E
 |  |  |  |  |  | 9217-17408 |  |  | 9217 |  |  |  |  |  |  | 17408 |  |  | C |  | D |  | E |  | E |  | E |  | E |  | E
 |  |  |  |  |  | 17409-30720 |  |  | 17409 |  |  |  |  |  |  | 30720 |  |  | D |  | E |  | E |  | E |  | E |  | E |  | E
 |  |  |  |  |  | 30721-[PHONE] |  |  | 30721 |  |  |  |  |  |  | 100000000 |  |  | E |  | E |  | E |  | E |  | E |  | E |  | E
Instructions for populating Page 1 of this document and general Sampling Plan instructions found below.
1. | [NAME] of product as it appears on the controlled drawing (if there is a commonly used alternate name it may be listed in
 | parentheses after the official nomenclature).
2. | [NAME] being measured by utilization of this form nominal dimension (Ex. 1.000; 0.200; 0.1502; etc.)
3. | [NAME] descriptive term (Ex. Outside Diameter; [NAME]; Width Between Slots, etc.)
4. | [NAME] number.
5. | [NAME] revision.
6. | Insert Upper Limit. This may be the Upper Specification Limit/Tolerance as defined by the drawing or may be the Upper Control Limit as defined by
 | contractual requirements, process parameters, etc.
7. | Insert Lower Limit. This may be the Lower Specification Limit/Tolerance as defined by the drawing or may be the Lower Control Limit as defined by
 | contractual requirements, process parameters, etc.
8. | Sample Frequency represents the maximum amount of units that may be produced between inspection points for the listed criteria.
9. | Insert the sample size. This shall be the number of units inspected for the required characteristic at the frequency listed in Block 7.
10. | Insert the individual measurements for the listed criteria. If any units fails to meet the criteria stop and notify Supervision.
11. | [NAME] date of the inspection occurrence.
12. | Insert time of the inspection occurrence.
13. | Inspector to select from dropdown menu the sampling plan Verification Level based on process evidence (V - Tightened, IV - Normal, III - Reduced)
14. | The Code Letter is a derived letter from MIL-STD-1916 based on the lot size/sample frequency (Block 8) and the verification level (Block 13). This code
 | letter establishes the sample size and respective k-values and F criterion.
15. | This is a analytical data summarized from Block 9. If the Min or [NAME] are highlighted stop and notify Supervision as these indicate an Out of
 | Tolerance condition. If the [NAME] is highlighted stop and notify Supervision as this is an indication of an unstable process.
16. | Insert time of the inspection occurrence.
17. | This is a analytical data summarized from Block 14. If the Min or [NAME] are highlighted stop and notify Supervision as these indicate an Out of
 | Tolerance condition. If the [NAME] is highlighted stop and notify Supervision as this is an indication of an unstable process. If the k or f values are
 | highlighted stop and notify Supervision as this is a violation of the variable sampling plan acceptance criteria.
Sampling Plan Procedure
 | At product release, inspection shall be 100% for specific criteria until Attribute Sampling Plan Level IV Code Letter E (qty 192) is reached
 | If no defects are found AND process is stable with a Cpk of 1.33 or higher, inspection shall move to Variable Sampling Plan Level V Tightened
 | (MIL-STD-1916 Table III)
 | Movement between Tightened, Normal and Reduced shall be IAW MIL-STD-1916 guidelines.
 |  | Beginning plan would be 64 units @ Code Letter E Level V
 |  | Reduce to Normal after 5 consecutive lots have been accepted