Process Performance (Pp) & Ppk Excel Template |DOWNLOAD
Last updated on November 16th, 2024 at 08:55 am
Process Performance Excel Template (Pp & Ppk Format) | DOWNLOAD
Process Performance Excel Template: According to the SPC (Statistical Process Control Manual), the process Performance (Pp) compares the process performance of the process to the maximum allowable variation as indicated by the tolerance. The Pp (Process Performance) provides a measure of how well the process will satisfy the variability requirements. And the Index of process performance is termed as Ppk. It takes the process location as well as the performance into account. Download the Excel Template /Format of Pp & Ppk from the below link.
DOWNLOAD Excel Template/Format of Pp & Ppk calculation with Example.
How to use the Pp & Ppk Excel Format in your process to calculate the index value?
1: Download the Template/ Format from the above links.
2: Read the note mentioned in the Excel template.
3: Only the yellow colour box (mentioned in format) is changeable and other values will calculate automatically.
The formula of Pp (Process Performance):
Pp = ((USL-LSL)/ (6 X S))
[Where USL=Upper specification limit, LSL=Lower specification limit and S= Standard Deviation]
The formula of Ppk (Process Performance Index):
Ppk = Minimum of PPU or PPL
PPU= ((USL-Average of average)/ (3 X S))
PPL= ((Average of average-LSL)/ (3 X S))
Note: Pp ≥ Ppk.
Example:
Company XYZ pvt ltd is interested to know the process performance of moulding process that, how well the process is performing and satisfies the variability requirements of mould hardness. The process engineer has collected the total 100 numbers of readings considering with subgroup size 5. Readings are given below;
| Sl.No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Subgroup1 | 63.00 | 61.00 | 65.00 | 62.00 | 65.00 | 63.00 | 65.00 | 64.00 | 63.00 | 65.00 |
| Subgroup2 | 63.00 | 62.00 | 64.00 | 62.00 | 66.00 | 64.00 | 65.00 | 62.00 | 64.00 | 62.00 |
| Subgroup3 | 62.00 | 63.00 | 65.00 | 65.00 | 65.00 | 62.00 | 62.00 | 65.00 | 62.00 | 62.00 |
| Subgroup4 | 63.00 | 66.00 | 64.00 | 64.00 | 65.00 | 63.00 | 62.00 | 63.00 | 65.00 | 64.00 |
| Subgroup5 | 64.00 | 65.00 | 63.00 | 63.00 | 65.00 | 62.00 | 62.00 | 62.00 | 62.00 | 62.00 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 61.00 | 63.00 | 62.00 | 63.00 | 62.00 | 66.00 | 62.00 | 62.00 | 63.00 | 65.00 |
| 64.00 | 63.00 | 63.00 | 63.00 | 62.00 | 65.00 | 67.00 | 62.00 | 64.00 | 64.00 |
| 62.00 | 68.00 | 65.00 | 66.00 | 64.00 | 64.00 | 64.00 | 64.00 | 62.00 | 65.00 |
| 63.00 | 68.00 | 64.00 | 68.00 | 64.00 | 66.00 | 67.00 | 64.00 | 63.00 | 64.00 |
| 62.00 | 64.00 | 63.00 | 64.00 | 62.00 | 65.00 | 62.00 | 65.00 | 62.00 | 63.00 |
| Characteristics | Mould Hardness |
| Process: | Moulding Process |
| USL | 70 |
| LSL | 60 |
| Pp | 1.06 |
| Ppk | 0.8 |
In the above example, the value of Ppk (0.8) is indicating that the process needs further improvement. The start-up process requires at least 1.33 and next to 1.67 and 2 onward.
QA/QC/TQM/Lean/6-Sigma Template or Format:
Useful Articles:
Quality at the source | Steps to Implement It
Jidoka Autonomation, Bakayoke & Yo-I-don |Concept in TPS
Pull Production System | Concept
Download QA & QC useful template/ format in free
More on TECHIEQUALITY
Thank you for reading… Keep visiting Techiequality.Com
Popular Post
How to create forecast in excel | Illustration with Example
How to plot the Run Chart in Excel | Run Chart Excel Template:
Strategies for Manufacturing Process Improvement |11+ Strategies
About Author
TECHIEQUALITY
The Author is an Expert in Quality Management System, Operation Management, Business Excellence, Process Excellence, IATF 16949, ISO 9001, ISO 14001, ISO 45001, ISO 17025, TQM, TPM & QA. He is Certified as an IA for ISO 9001, IATF 16949, ISO 14001, ISO 17025 & ISO 45001 Standard.