Introduction:
This page provides you with a general overview of how to use the tool.
For a detailed presentation of the tool, go to the subsection of the relevant distribution:
General Overview:
1. Enter your data
Go to the tab of the distribution you want to study.
Enter the necessary information in the "2) Distribution Parameters" section.
Then run the Excel Macro by clicking on "Calculate Workbook" to let the tool perform the calculations.
(Average calculation time: 5-10 seconds)
2. Lancer l'analyse
Constater l'analyse de capabilité 6sigma, dans l'onglet "Résultats" :
-Les indicateurs de capabilité sont calculés
-Les éléments graphiques suivants sont tracés, Droite d'Henry, Courbe de Gauss, Histogramme
2. Launch the analysis
Go to the tab of the distribution you want to study.
Enter the necessary information in the "2) Distribution Parameters" section.
Then run the Excel Macro by clicking on "Calculate Workbook" to let the tool perform the calculations.
(Average calculation time: 20 seconds)
3. Observe the results
Observe the analysis by navigating to the tab:
-
Indicators and parameters are calculated based on the distribution (Cp, Cpk, PPM, Variance...)
-
Graphs are plotted based on the distribution (Henry's Straight Line, Gaussian Curve, Histogram, Density Function)
 |  |
|---|---|
 |  |
 |  |
 |  |
 |
Technical Note:
It is necessary to enable Macros to operate the tool.
Automatic calculations are disabled to avoid slowdowns. To start the spreadsheet calculation, I recommend
running the Macro in the tab of the desired distribution. The Macro serves only this purpose. Moreover, it performs calculations in the correct order.
The calculations of the Macro take between 5 and 10 seconds.
Author's Note:
I have created this tool to conduct capability studies quickly and easily.
This is a free tool that will remain free.
This tool may have defects; I invite you to report them to me so that necessary corrections can be made to benefit other users.
I disclaim any responsibility for calculation errors or misinterpretation of results provided by the tool.
The workbook is not locked, no password, no locked cells. This is intentional because this tool belongs to its users first and foremost.
I hope this tool proves to be useful to you.