Process capability is a measurable property of a process against the specification, expressed as a process capability index (e.g., Cpk or Cpm). The output of this measurement is usually illustrated by a chronological control sample, a histogram and calculations that predict how many parts will be produced out of specification (OOS). If you want to have a look at the template and you have Excel 2019, 2021 or office 365, just download it. If you need another language in the template (Spanish, French, Italian or whatever) just write me a mail (roland.schnurr@sixsigmablackbelt.de),
You can modify all the cells in the template (format, images, etc.), except the grey cells. These are calculated.
Have any questions? Write an email to roland.schnurr@sixsigmablackbelt.de
Get the add in via Microsoft Store.
Another option is the macro enabled template. Here you get the template to calculate all the process capability figures you need. The template is multilingual and can display values in German, English and Italian.
For a more detailed view of process capability, statistical process control and related software, have a look on cp-cpk-process-capability-calculation.
For more information on
- process capability
- stable processes
- statistical process control
- measurement system analysis
view the full guide to process capability.
How to calculate cpk in excel with the free template
If you want that i make some adjustments for you contact me.
If you want to to have a more scientific look on process control you can check this discussion on the homepage of ASQ.
Please feel free to contact me, if you have some suggestions to improve this page (roland.schnurr@sixsigmablackbelt.de).
[1] „IATF 16949-2016 | AIAG“. https://www.aiag.org/quality/iatf-16949-2016 (17. April 2022).
[2] „(MSA) Measurement System Analysis | AIAG“. https://www.aiag.org/quality/automotive-core-tools/msa (17. April 2022).
[3] E. Dietrich und A. Schulze, Statistische Verfahren zur Maschinen- und Prozessqualifikation: mit 61 Tabellen, 6., Vollst. überarb. Aufl. München: Hanser, 2009. ISBN 978-3-446-41525-6