Calculation of PPM & Sigma Level in an Excel Spreadsheet

Elsmar Forum Sponsor

Jim Wynne

Leader
Admin
#3
Dear sir
I want to know that my calculation in excel sheet is right or wrong, if not please help with example

with regard
vikash Kumar
That's a very busy spreadsheet, and there are lots of abbreviations and references that can't be resolved. If you could perhaps extract a single example and show us your formulae it would be easier to help you.
 
A

adamsjm

#4
I looked at your spreadsheet and have the following questions.

Why is the date line 26 blank? If you wish to keep blank lines then your formulas need to trap anticipated errors due to missing data. This will avoid the #DIV/0! and #NUM! errors.

Why are cells AI6 and AI7 using vk4 vs vk9 as the rest of the cells in the AI column?

Column AK is trying to calculate a rolling 6 sigma level. Rejects are not a normal function since it is lower bounded by zero. Also, there are no specifications for rejects, therefore, no Cpk or 6 sigma level can be calculated. Therefore, column AK is not providing any information of value. Just eliminate it.

Hope this helps.
 
Thread starter Similar threads Forum Replies Date
0 PPM calculation of customer complaints for PMS Customer Complaints 10
F Determining what type of scrap to include in my internal PPM calculation Quality Manager and Management Related Issues 5
Q PPM - Filtering Defects out of calculation Quality Tools, Improvement and Analysis 5
K Proper YTD PPM Supplier Calculation Six Sigma 3
S Supplier ppm calculation issue - Disregard minor NC parts? Supplier Quality Assurance and other Supplier Issues 6
M Formula for the Calculation of PPM (Parts Per Million) Statistical Analysis Tools, Techniques and SPC 15
B Logistical or Quality PPM's? Calculation of PPM relevant parts Quality Tools, Improvement and Analysis 28
S Is ppm calculation valid or invalid for bulk materials? IATF 16949 - Automotive Quality Systems Standard 4
T Sample Size Calculation for PPM (Parts Per Million) Prediction Statistical Analysis Tools, Techniques and SPC 6
B Wrong standard deviation calculation in AIAG SPC manual? Capability, Accuracy and Stability - Processes, Machines, etc. 13
CaliperJim Cost of Quality calculation Quality Tools, Improvement and Analysis 4
T Sample size calculation Using Minitab Software 3
T Capability calculation of surface profile Capability, Accuracy and Stability - Processes, Machines, etc. 20
N Little Law and WIP calculation Lean in Manufacturing and Service Industries 0
M Return Rate Calculation Benchmarking 2
A Please Help With EOQ Calculation Manufacturing and Related Processes 2
I Excel based Gage R&R VS Minitab calculation Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
S Calibration Interval calculation for ECG Machine Calibration Frequency (Interval) 4
bobdoering Informational Ndc Calculation Error Caution Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Sidney Vianna IATF 16949 News Risked Based Audit Day Calculation IATF 16949 - Automotive Quality Systems Standard 2
L Uncertainty calculation for an average Measurement Uncertainty (MU) 1
L Scrap % calculation for a year. Manufacturing and Related Processes 3
T Question for: Cg & Cgk calculation General Measurement Device and Calibration Topics 3
E 21 CFR 211.103 Calculation of Yield Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 5
S Cost of Poor Quality (CoPQ) - Scrap element of calculation includes lost margin? Misc. Quality Assurance and Business Systems Related Topics 7
K Analysis variation among the lots during cpk calculation. Design and Development of Products and Processes 1
T Overvoltages consideration in Applied Part for RMS Calculation. IEC 60601 - Medical Electrical Equipment Safety Standards Series 6
U Cpk Calculation - I analyse a double seam cans Manufacturing and Related Processes 15
I Lifetime Support Calculation - Thermal Operating Profile Reliability Analysis - Predictions, Testing and Standards 7
qualprod Stock Reorder point calculation Lean in Manufacturing and Service Industries 1
G 3 Operator Std. Dev. and uncertainty calculation Measurement Uncertainty (MU) 2
F Holes position inspection - Calculation of centre distance and plug sizes of a gauge Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
P Any official doc/spec on different types of Yield calculation? Manufacturing and Related Processes 0
M Benchmarking Process Data - Man-day calculation gone wrong Benchmarking 5
H Taguchi mixed model DoE [L16 (4^3 2^6): factors interaction and ANOVA calculation Using Minitab Software 3
L P-Chart Control Limit Calculation help Statistical Analysis Tools, Techniques and SPC 1
H Sample Size Calculation (Confidence Interval and Reliability) - Medical Devices Reliability Analysis - Predictions, Testing and Standards 9
E Questions regarding Cpk Calculation - Should we be using LSL/USL or LCL/UCL? Capability, Accuracy and Stability - Processes, Machines, etc. 5
leftoverture Number of Distinct Categories" or NDC Calculation in MSA Studies Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 44
V Sample Size Calculation for Image Analysis - Microscopy Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
Q Rule 5.2h - Site Separation - Audit Manday Calculation (IATF 16949) IATF 16949 - Automotive Quality Systems Standard 17
kedarg6500 Gage R&R - Is my sheet calculation wrong? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21
Cats Clause Practical use of Heat Input calculation for Manual MIG Welding Manufacturing and Related Processes 4
J CMM Uncertainty Calculation Question - Deviations Measurement Uncertainty (MU) 9
S Scrap % Calculation Formula Manufacturing and Related Processes 10
T Reliability calculation for repairable system Reliability Analysis - Predictions, Testing and Standards 14
F Calculation of reduction on audit time - IAF MD1:2007, IAF MD5:2015 and IAF MD11:2013 General Auditing Discussions 1
M Is there a calculation in Net Promoter Score (NPS) ? Statistical Analysis Tools, Techniques and SPC 3
bobdoering Unilateral Tolerance Capability Calculation Imported Legacy Blogs 0
M Help with uncertainty calculation in the calibration of a Pyrogen Test Processor Measurement Uncertainty (MU) 7

Similar threads

Top Bottom