Calculation of PPM & Sigma Level in an Excel Spreadsheet

vikash

Registered
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
 

Attachments

  • Existing PPM level of company.xls
    97.5 KB · Views: 793

Jim Wynne

Leader
Admin
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

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.
 
Top Bottom